01-04-2024 06:31:41:<------------------------Started ValidationRequest CBS A/C No : 001001011568 ------------------------> 01-04-2024 06:31:41:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 06:31:41:Connection Establisment started 01-04-2024 06:31:41:Connection Read From File : Status OK 01-04-2024 06:31:42:Connection Successfully Opened : Status OK 01-04-2024 06:31:42:ValidateAcNo CBS A/C No : 001001011568 01-04-2024 06:31:42:ValidateAcNo CBS A/C No 2: 001001011568 01-04-2024 06:31:42:ShowCBSAcNo CBS A/C No : 001001011568 01-04-2024 06:31:42:ShowCBSAcNo CBS A/C No 2: 001001011568 01-04-2024 06:31:42:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 06:31:42:Record Count : 1 01-04-2024 06:31:42:BRLENGTH 3 01-04-2024 06:31:42:SCHLENGTH 3 01-04-2024 06:31:42:ACLENGTH 6 01-04-2024 06:31:42:Branch Code 3 01-04-2024 06:31:42:Scheme Code 3 01-04-2024 06:31:42:Account No 3 01-04-2024 06:31:42:Link Main Started 01-04-2024 06:31:42:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 01-04-2024 06:31:42:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 06:31:42:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|011568|SB |001 01-04-2024 06:31:42:A/c no length validation qry --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG FROM clientmaster,depositmaster where CLMS_SNO=DEPM_CLIENT and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB' AND DEPM_NO=011568 union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG FROM clientmaster,LOANMASTER where CLMS_SNO=LOAM_CLIENT and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='SB' AND LOAM_NO=011568 UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG FROM clientmaster,ODMASTER where CLMS_SNO=ODMT_CLIENT and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='SB' AND ODMT_NO=011568 01-04-2024 06:31:42:Validation Account Proce Executed with out error Y 01-04-2024 06:31:42:ValidationRequest Exccution Success with response : 000 01-04-2024 06:31:42:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 06:32:15:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : IDFBH24091346292|001001011568 --------------------------> 01-04-2024 06:32:15:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 06:32:15:ConfirmationReq CBS A/C No : 001001011568 01-04-2024 06:32:15:ConfirmationReq A/C No 2: 001001011568 01-04-2024 06:32:15:Connection Establisment started 01-04-2024 06:32:15:Connection Read From File : Status OK 01-04-2024 06:32:16:Connection Successfully Opened : Status OK 01-04-2024 06:32:16:ValidateAcNo CBS A/C No : 001001011568 01-04-2024 06:32:16:ValidateAcNo CBS A/C No 2: 001001011568 01-04-2024 06:32:16:ShowCBSAcNo CBS A/C No : 001001011568 01-04-2024 06:32:16:ShowCBSAcNo CBS A/C No 2: 001001011568 01-04-2024 06:32:16:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 06:32:16:Record Count : 1 01-04-2024 06:32:16:BRLENGTH 3 01-04-2024 06:32:16:SCHLENGTH 3 01-04-2024 06:32:16:ACLENGTH 6 01-04-2024 06:32:16:Branch Code 3 01-04-2024 06:32:16:Scheme Code 3 01-04-2024 06:32:16:Account No 3 01-04-2024 06:32:16:Link Main Started 01-04-2024 06:32:16:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 01-04-2024 06:32:16:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 06:32:16:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|011568|SB |001 01-04-2024 06:32:16:A/c no length validation qry --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG FROM clientmaster,depositmaster where CLMS_SNO=DEPM_CLIENT and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB' AND DEPM_NO=011568 union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG FROM clientmaster,LOANMASTER where CLMS_SNO=LOAM_CLIENT and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='SB' AND LOAM_NO=011568 UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG FROM clientmaster,ODMASTER where CLMS_SNO=ODMT_CLIENT and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='SB' AND ODMT_NO=011568 01-04-2024 06:32:16:Validation Account Proce Executed with out error Y 01-04-2024 06:32:16:Connection Establisment started 01-04-2024 06:32:16:Connection Read From File : Status OK 01-04-2024 06:32:16:Connection Successfully Opened : Status OK 01-04-2024 06:32:16:Inward_process CBS A/C No : 001001011568 01-04-2024 06:32:16:Inward_processCBS A/C No : 001001011568 01-04-2024 06:32:16:ShowCBSAcNo CBS A/C No : 001001011568 01-04-2024 06:32:16:ShowCBSAcNo CBS A/C No 2: 001001011568 01-04-2024 06:32:16:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 06:32:16:Record Count : 1 01-04-2024 06:32:16:BRLENGTH 3 01-04-2024 06:32:16:SCHLENGTH 3 01-04-2024 06:32:16:ACLENGTH 6 01-04-2024 06:32:16:Branch Code 3 01-04-2024 06:32:16:Scheme Code 3 01-04-2024 06:32:16:Account No 3 01-04-2024 06:32:16:Link Main Started 01-04-2024 06:32:16:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 01-04-2024 06:32:16:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 06:32:16:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|011568|SB |001 01-04-2024 06:32:16:Vno --->:142467 01-04-2024 06:32:16:Current Date --->:01-04-2024 01-04-2024 06:32:16:calling CallNewRtgsBothProc 01-04-2024 06:32:16:Parameters passing - InwardAuthorise 01-04-2024 06:32:16: brn =001 01-04-2024 06:32:16: acno =011568 01-04-2024 06:32:16: abbr =SB 01-04-2024 06:32:16: amt.ToString() =20000 01-04-2024 06:32:16: traceNo =142467 01-04-2024 06:32:16: narr =NEFT, BY MARVEL RESIDENCY APARTMENT OWNERS A IDFB0010201 00000010091775943 01-04-2024 06:32:16:Transaction Process : BEFORE CAL PROC: 01-04-2024 06:32:16:cbs no--->001001011568 01-04-2024 06:32:16:ShowCBSAcNo CBS A/C No : 001001011568 01-04-2024 06:32:16:ShowCBSAcNo CBS A/C No 2: 001001011568 01-04-2024 06:32:16:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 06:32:16:Record Count : 1 01-04-2024 06:32:16:BRLENGTH 3 01-04-2024 06:32:16:SCHLENGTH 3 01-04-2024 06:32:16:ACLENGTH 6 01-04-2024 06:32:16:Branch Code 3 01-04-2024 06:32:16:Scheme Code 3 01-04-2024 06:32:16:Account No 3 01-04-2024 06:32:16:Link Main Started 01-04-2024 06:32:16:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 01-04-2024 06:32:16:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 06:32:16:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|011568|SB |001 01-04-2024 06:32:16:Closed YN quier --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG,DSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,depositmaster,depositschemesetup,ADDRESS where CLMS_SNO=DEPM_CLIENT AND DSCH_BRANCH = DEPM_BRANCH AND DSCH_ABBR = DEPM_ABBR and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB' AND DEPM_NO=011568 AND ADDR_SNO=CLMS_ADDRESS union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG,LSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,LOANMASTER,LOANSCHEMESETUP,ADDRESS where CLMS_SNO=LOAM_CLIENT AND LSCH_BRANCH = LOAM_BRANCH AND LSCH_ABBREV = LOAM_ABBR and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='SB' AND LOAM_NO=011568 AND ADDR_SNO=CLMS_ADDRESS UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG,ODST_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,ODMASTER,ODSCHEMESETUP,ADDRESS where CLMS_SNO=ODMT_CLIENT AND ODST_BRANCH = ODMT_BRANCH AND ODST_ABBR = ODMT_ABBR and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='SB' AND ODMT_NO=011568 AND ADDR_SNO=CLMS_ADDRESS 01-04-2024 06:32:16:closed y n Record count --->1 01-04-2024 06:32:16:CBS A/C FOR SMS PUSH : XXXXXX011568 01-04-2024 06:32:18:SMS Inserted for Mobile Number : +919036349824 01-04-2024 06:32:18:Inward Process Executed Sussefully 01-04-2024 06:32:18:ConfirmationReq Execution Success with Status 000 01-04-2024 06:32:18:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : IDFBH24091346292|001001011568 ------------------------------> 01-04-2024 06:32:18:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 07:01:44:<------------------------Started ValidationRequest CBS A/C No : 001001000899 ------------------------> 01-04-2024 07:01:44:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 07:01:44:Connection Establisment started 01-04-2024 07:01:44:Connection Read From File : Status OK 01-04-2024 07:01:45:Connection Successfully Opened : Status OK 01-04-2024 07:01:45:ValidateAcNo CBS A/C No : 001001000899 01-04-2024 07:01:45:ValidateAcNo CBS A/C No 2: 001001000899 01-04-2024 07:01:45:ShowCBSAcNo CBS A/C No : 001001000899 01-04-2024 07:01:45:ShowCBSAcNo CBS A/C No 2: 001001000899 01-04-2024 07:01:45:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 07:01:45:Record Count : 1 01-04-2024 07:01:45:BRLENGTH 3 01-04-2024 07:01:45:SCHLENGTH 3 01-04-2024 07:01:45:ACLENGTH 6 01-04-2024 07:01:45:Branch Code 3 01-04-2024 07:01:45:Scheme Code 3 01-04-2024 07:01:45:Account No 3 01-04-2024 07:01:45:Link Main Started 01-04-2024 07:01:45:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 01-04-2024 07:01:45:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 07:01:45:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000899|SB |001 01-04-2024 07:01:45:A/c no length validation qry --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG FROM clientmaster,depositmaster where CLMS_SNO=DEPM_CLIENT and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB' AND DEPM_NO=000899 union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG FROM clientmaster,LOANMASTER where CLMS_SNO=LOAM_CLIENT and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='SB' AND LOAM_NO=000899 UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG FROM clientmaster,ODMASTER where CLMS_SNO=ODMT_CLIENT and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='SB' AND ODMT_NO=000899 01-04-2024 07:01:45:Validation Account Proce Executed with out error Y 01-04-2024 07:01:45:ValidationRequest Exccution Success with response : 000 01-04-2024 07:01:45:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 07:01:52:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : HS92409238397789|001001000899 --------------------------> 01-04-2024 07:01:52:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 07:01:52:ConfirmationReq CBS A/C No : 001001000899 01-04-2024 07:01:52:ConfirmationReq A/C No 2: 001001000899 01-04-2024 07:01:52:Connection Establisment started 01-04-2024 07:01:52:Connection Read From File : Status OK 01-04-2024 07:01:52:Connection Successfully Opened : Status OK 01-04-2024 07:01:52:ValidateAcNo CBS A/C No : 001001000899 01-04-2024 07:01:52:ValidateAcNo CBS A/C No 2: 001001000899 01-04-2024 07:01:52:ShowCBSAcNo CBS A/C No : 001001000899 01-04-2024 07:01:52:ShowCBSAcNo CBS A/C No 2: 001001000899 01-04-2024 07:01:52:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 07:01:52:Record Count : 1 01-04-2024 07:01:52:BRLENGTH 3 01-04-2024 07:01:52:SCHLENGTH 3 01-04-2024 07:01:52:ACLENGTH 6 01-04-2024 07:01:52:Branch Code 3 01-04-2024 07:01:52:Scheme Code 3 01-04-2024 07:01:52:Account No 3 01-04-2024 07:01:52:Link Main Started 01-04-2024 07:01:52:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 01-04-2024 07:01:52:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 07:01:52:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000899|SB |001 01-04-2024 07:01:52:A/c no length validation qry --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG FROM clientmaster,depositmaster where CLMS_SNO=DEPM_CLIENT and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB' AND DEPM_NO=000899 union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG FROM clientmaster,LOANMASTER where CLMS_SNO=LOAM_CLIENT and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='SB' AND LOAM_NO=000899 UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG FROM clientmaster,ODMASTER where CLMS_SNO=ODMT_CLIENT and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='SB' AND ODMT_NO=000899 01-04-2024 07:01:52:Validation Account Proce Executed with out error Y 01-04-2024 07:01:52:Connection Establisment started 01-04-2024 07:01:52:Connection Read From File : Status OK 01-04-2024 07:01:52:Connection Successfully Opened : Status OK 01-04-2024 07:01:52:Inward_process CBS A/C No : 001001000899 01-04-2024 07:01:52:Inward_processCBS A/C No : 001001000899 01-04-2024 07:01:52:ShowCBSAcNo CBS A/C No : 001001000899 01-04-2024 07:01:52:ShowCBSAcNo CBS A/C No 2: 001001000899 01-04-2024 07:01:52:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 07:01:52:Record Count : 1 01-04-2024 07:01:52:BRLENGTH 3 01-04-2024 07:01:52:SCHLENGTH 3 01-04-2024 07:01:52:ACLENGTH 6 01-04-2024 07:01:52:Branch Code 3 01-04-2024 07:01:52:Scheme Code 3 01-04-2024 07:01:52:Account No 3 01-04-2024 07:01:52:Link Main Started 01-04-2024 07:01:52:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 01-04-2024 07:01:52:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 07:01:52:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000899|SB |001 01-04-2024 07:01:52:Vno --->:142468 01-04-2024 07:01:52:Current Date --->:01-04-2024 01-04-2024 07:01:52:calling CallNewRtgsBothProc 01-04-2024 07:01:52:Parameters passing - InwardAuthorise 01-04-2024 07:01:52: brn =001 01-04-2024 07:01:52: acno =000899 01-04-2024 07:01:52: abbr =SB 01-04-2024 07:01:52: amt.ToString() =1000 01-04-2024 07:01:52: traceNo =142468 01-04-2024 07:01:52: narr =NEFT, BY ESWAR ROHITH PUVVADA ICIC0SF0002 055801597820 01-04-2024 07:01:52:Transaction Process : BEFORE CAL PROC: 01-04-2024 07:01:52:cbs no--->001001000899 01-04-2024 07:01:52:ShowCBSAcNo CBS A/C No : 001001000899 01-04-2024 07:01:52:ShowCBSAcNo CBS A/C No 2: 001001000899 01-04-2024 07:01:52:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 07:01:52:Record Count : 1 01-04-2024 07:01:52:BRLENGTH 3 01-04-2024 07:01:52:SCHLENGTH 3 01-04-2024 07:01:52:ACLENGTH 6 01-04-2024 07:01:52:Branch Code 3 01-04-2024 07:01:52:Scheme Code 3 01-04-2024 07:01:52:Account No 3 01-04-2024 07:01:52:Link Main Started 01-04-2024 07:01:52:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 01-04-2024 07:01:52:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 07:01:52:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000899|SB |001 01-04-2024 07:01:52:Closed YN quier --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG,DSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,depositmaster,depositschemesetup,ADDRESS where CLMS_SNO=DEPM_CLIENT AND DSCH_BRANCH = DEPM_BRANCH AND DSCH_ABBR = DEPM_ABBR and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB' AND DEPM_NO=000899 AND ADDR_SNO=CLMS_ADDRESS union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG,LSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,LOANMASTER,LOANSCHEMESETUP,ADDRESS where CLMS_SNO=LOAM_CLIENT AND LSCH_BRANCH = LOAM_BRANCH AND LSCH_ABBREV = LOAM_ABBR and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='SB' AND LOAM_NO=000899 AND ADDR_SNO=CLMS_ADDRESS UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG,ODST_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,ODMASTER,ODSCHEMESETUP,ADDRESS where CLMS_SNO=ODMT_CLIENT AND ODST_BRANCH = ODMT_BRANCH AND ODST_ABBR = ODMT_ABBR and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='SB' AND ODMT_NO=000899 AND ADDR_SNO=CLMS_ADDRESS 01-04-2024 07:01:52:closed y n Record count --->1 01-04-2024 07:01:52:CBS A/C FOR SMS PUSH : XXXXXX000899 01-04-2024 07:01:52:SMS Inserted for Mobile Number : +919880559856 01-04-2024 07:01:52:Inward Process Executed Sussefully 01-04-2024 07:01:52:ConfirmationReq Execution Success with Status 000 01-04-2024 07:01:52:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : HS92409238397789|001001000899 ------------------------------> 01-04-2024 07:01:52:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 08:31:51:<------------------------Started ValidationRequest CBS A/C No : 001001010972 ------------------------> 01-04-2024 08:31:51:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 08:31:51:Connection Establisment started 01-04-2024 08:31:51:Connection Read From File : Status OK 01-04-2024 08:31:51:Connection Successfully Opened : Status OK 01-04-2024 08:31:51:ValidateAcNo CBS A/C No : 001001010972 01-04-2024 08:31:51:ValidateAcNo CBS A/C No 2: 001001010972 01-04-2024 08:31:51:ShowCBSAcNo CBS A/C No : 001001010972 01-04-2024 08:31:51:ShowCBSAcNo CBS A/C No 2: 001001010972 01-04-2024 08:31:51:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 08:31:51:Record Count : 1 01-04-2024 08:31:51:BRLENGTH 3 01-04-2024 08:31:51:SCHLENGTH 3 01-04-2024 08:31:51:ACLENGTH 6 01-04-2024 08:31:51:Branch Code 3 01-04-2024 08:31:51:Scheme Code 3 01-04-2024 08:31:51:Account No 3 01-04-2024 08:31:51:Link Main Started 01-04-2024 08:31:51:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 01-04-2024 08:31:51:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 08:31:51:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|010972|SB |001 01-04-2024 08:31:51:A/c no length validation qry --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG FROM clientmaster,depositmaster where CLMS_SNO=DEPM_CLIENT and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB' AND DEPM_NO=010972 union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG FROM clientmaster,LOANMASTER where CLMS_SNO=LOAM_CLIENT and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='SB' AND LOAM_NO=010972 UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG FROM clientmaster,ODMASTER where CLMS_SNO=ODMT_CLIENT and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='SB' AND ODMT_NO=010972 01-04-2024 08:31:51:Validation Account Proce Executed with out error Y 01-04-2024 08:31:51:ValidationRequest Exccution Success with response : 000 01-04-2024 08:31:51:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 08:31:51:<------------------------Started ValidationRequest CBS A/C No : 001001010972 ------------------------> 01-04-2024 08:31:51:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 08:31:51:Connection Establisment started 01-04-2024 08:31:51:Connection Read From File : Status OK 01-04-2024 08:31:52:Connection Successfully Opened : Status OK 01-04-2024 08:31:52:ValidateAcNo CBS A/C No : 001001010972 01-04-2024 08:31:52:ValidateAcNo CBS A/C No 2: 001001010972 01-04-2024 08:31:52:ShowCBSAcNo CBS A/C No : 001001010972 01-04-2024 08:31:52:ShowCBSAcNo CBS A/C No 2: 001001010972 01-04-2024 08:31:52:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 08:31:52:Record Count : 1 01-04-2024 08:31:52:BRLENGTH 3 01-04-2024 08:31:52:SCHLENGTH 3 01-04-2024 08:31:52:ACLENGTH 6 01-04-2024 08:31:52:Branch Code 3 01-04-2024 08:31:52:Scheme Code 3 01-04-2024 08:31:52:Account No 3 01-04-2024 08:31:52:Link Main Started 01-04-2024 08:31:52:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 01-04-2024 08:31:52:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 08:31:52:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|010972|SB |001 01-04-2024 08:31:52:A/c no length validation qry --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG FROM clientmaster,depositmaster where CLMS_SNO=DEPM_CLIENT and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB' AND DEPM_NO=010972 union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG FROM clientmaster,LOANMASTER where CLMS_SNO=LOAM_CLIENT and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='SB' AND LOAM_NO=010972 UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG FROM clientmaster,ODMASTER where CLMS_SNO=ODMT_CLIENT and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='SB' AND ODMT_NO=010972 01-04-2024 08:31:52:Validation Account Proce Executed with out error Y 01-04-2024 08:31:52:ValidationRequest Exccution Success with response : 000 01-04-2024 08:31:52:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 08:32:04:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : FDRLH24091348346|001001010972 --------------------------> 01-04-2024 08:32:04:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 08:32:04:ConfirmationReq CBS A/C No : 001001010972 01-04-2024 08:32:04:ConfirmationReq A/C No 2: 001001010972 01-04-2024 08:32:04:Connection Establisment started 01-04-2024 08:32:04:Connection Read From File : Status OK 01-04-2024 08:32:05:Connection Successfully Opened : Status OK 01-04-2024 08:32:05:ValidateAcNo CBS A/C No : 001001010972 01-04-2024 08:32:05:ValidateAcNo CBS A/C No 2: 001001010972 01-04-2024 08:32:05:ShowCBSAcNo CBS A/C No : 001001010972 01-04-2024 08:32:05:ShowCBSAcNo CBS A/C No 2: 001001010972 01-04-2024 08:32:05:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 08:32:05:Record Count : 1 01-04-2024 08:32:05:BRLENGTH 3 01-04-2024 08:32:05:SCHLENGTH 3 01-04-2024 08:32:05:ACLENGTH 6 01-04-2024 08:32:05:Branch Code 3 01-04-2024 08:32:05:Scheme Code 3 01-04-2024 08:32:05:Account No 3 01-04-2024 08:32:05:Link Main Started 01-04-2024 08:32:05:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 01-04-2024 08:32:05:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 08:32:05:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|010972|SB |001 01-04-2024 08:32:05:A/c no length validation qry --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG FROM clientmaster,depositmaster where CLMS_SNO=DEPM_CLIENT and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB' AND DEPM_NO=010972 union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG FROM clientmaster,LOANMASTER where CLMS_SNO=LOAM_CLIENT and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='SB' AND LOAM_NO=010972 UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG FROM clientmaster,ODMASTER where CLMS_SNO=ODMT_CLIENT and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='SB' AND ODMT_NO=010972 01-04-2024 08:32:05:Validation Account Proce Executed with out error Y 01-04-2024 08:32:05:Connection Establisment started 01-04-2024 08:32:05:Connection Read From File : Status OK 01-04-2024 08:32:05:Connection Successfully Opened : Status OK 01-04-2024 08:32:05:Inward_process CBS A/C No : 001001010972 01-04-2024 08:32:05:Inward_processCBS A/C No : 001001010972 01-04-2024 08:32:05:ShowCBSAcNo CBS A/C No : 001001010972 01-04-2024 08:32:05:ShowCBSAcNo CBS A/C No 2: 001001010972 01-04-2024 08:32:05:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 08:32:05:Record Count : 1 01-04-2024 08:32:05:BRLENGTH 3 01-04-2024 08:32:05:SCHLENGTH 3 01-04-2024 08:32:05:ACLENGTH 6 01-04-2024 08:32:05:Branch Code 3 01-04-2024 08:32:05:Scheme Code 3 01-04-2024 08:32:05:Account No 3 01-04-2024 08:32:05:Link Main Started 01-04-2024 08:32:05:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 01-04-2024 08:32:05:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 08:32:05:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|010972|SB |001 01-04-2024 08:32:05:Vno --->:142469 01-04-2024 08:32:05:Current Date --->:01-04-2024 01-04-2024 08:32:05:calling CallNewRtgsBothProc 01-04-2024 08:32:05:Parameters passing - InwardAuthorise 01-04-2024 08:32:05: brn =001 01-04-2024 08:32:05: acno =010972 01-04-2024 08:32:05: abbr =SB 01-04-2024 08:32:05: amt.ToString() =1500 01-04-2024 08:32:05: traceNo =142469 01-04-2024 08:32:05: narr =NEFT, BY SUSANA VERGHESE KURIAN FDRL0002199 21994100000164 01-04-2024 08:32:05:Transaction Process : BEFORE CAL PROC: 01-04-2024 08:32:05:cbs no--->001001010972 01-04-2024 08:32:05:ShowCBSAcNo CBS A/C No : 001001010972 01-04-2024 08:32:05:ShowCBSAcNo CBS A/C No 2: 001001010972 01-04-2024 08:32:05:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 08:32:05:Record Count : 1 01-04-2024 08:32:05:BRLENGTH 3 01-04-2024 08:32:05:SCHLENGTH 3 01-04-2024 08:32:05:ACLENGTH 6 01-04-2024 08:32:05:Branch Code 3 01-04-2024 08:32:05:Scheme Code 3 01-04-2024 08:32:05:Account No 3 01-04-2024 08:32:05:Link Main Started 01-04-2024 08:32:05:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 01-04-2024 08:32:05:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 08:32:05:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|010972|SB |001 01-04-2024 08:32:05:Closed YN quier --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG,DSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,depositmaster,depositschemesetup,ADDRESS where CLMS_SNO=DEPM_CLIENT AND DSCH_BRANCH = DEPM_BRANCH AND DSCH_ABBR = DEPM_ABBR and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB' AND DEPM_NO=010972 AND ADDR_SNO=CLMS_ADDRESS union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG,LSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,LOANMASTER,LOANSCHEMESETUP,ADDRESS where CLMS_SNO=LOAM_CLIENT AND LSCH_BRANCH = LOAM_BRANCH AND LSCH_ABBREV = LOAM_ABBR and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='SB' AND LOAM_NO=010972 AND ADDR_SNO=CLMS_ADDRESS UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG,ODST_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,ODMASTER,ODSCHEMESETUP,ADDRESS where CLMS_SNO=ODMT_CLIENT AND ODST_BRANCH = ODMT_BRANCH AND ODST_ABBR = ODMT_ABBR and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='SB' AND ODMT_NO=010972 AND ADDR_SNO=CLMS_ADDRESS 01-04-2024 08:32:05:closed y n Record count --->1 01-04-2024 08:32:05:CBS A/C FOR SMS PUSH : XXXXXX010972 01-04-2024 08:32:05:SMS Inserted for Mobile Number : +918296502932 01-04-2024 08:32:05:Inward Process Executed Sussefully 01-04-2024 08:32:05:ConfirmationReq Execution Success with Status 000 01-04-2024 08:32:05:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : FDRLH24091348346|001001010972 ------------------------------> 01-04-2024 08:32:05:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 08:32:05:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : FDRLH24091348340|001001010972 --------------------------> 01-04-2024 08:32:05:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 08:32:05:ConfirmationReq CBS A/C No : 001001010972 01-04-2024 08:32:05:ConfirmationReq A/C No 2: 001001010972 01-04-2024 08:32:05:Connection Establisment started 01-04-2024 08:32:05:Connection Read From File : Status OK 01-04-2024 08:32:05:Connection Successfully Opened : Status OK 01-04-2024 08:32:05:ValidateAcNo CBS A/C No : 001001010972 01-04-2024 08:32:05:ValidateAcNo CBS A/C No 2: 001001010972 01-04-2024 08:32:05:ShowCBSAcNo CBS A/C No : 001001010972 01-04-2024 08:32:05:ShowCBSAcNo CBS A/C No 2: 001001010972 01-04-2024 08:32:05:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 08:32:05:Record Count : 1 01-04-2024 08:32:05:BRLENGTH 3 01-04-2024 08:32:05:SCHLENGTH 3 01-04-2024 08:32:05:ACLENGTH 6 01-04-2024 08:32:05:Branch Code 3 01-04-2024 08:32:05:Scheme Code 3 01-04-2024 08:32:05:Account No 3 01-04-2024 08:32:05:Link Main Started 01-04-2024 08:32:05:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 01-04-2024 08:32:05:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 08:32:05:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|010972|SB |001 01-04-2024 08:32:05:A/c no length validation qry --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG FROM clientmaster,depositmaster where CLMS_SNO=DEPM_CLIENT and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB' AND DEPM_NO=010972 union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG FROM clientmaster,LOANMASTER where CLMS_SNO=LOAM_CLIENT and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='SB' AND LOAM_NO=010972 UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG FROM clientmaster,ODMASTER where CLMS_SNO=ODMT_CLIENT and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='SB' AND ODMT_NO=010972 01-04-2024 08:32:05:Validation Account Proce Executed with out error Y 01-04-2024 08:32:05:Connection Establisment started 01-04-2024 08:32:05:Connection Read From File : Status OK 01-04-2024 08:32:05:Connection Successfully Opened : Status OK 01-04-2024 08:32:05:Inward_process CBS A/C No : 001001010972 01-04-2024 08:32:05:Inward_processCBS A/C No : 001001010972 01-04-2024 08:32:05:ShowCBSAcNo CBS A/C No : 001001010972 01-04-2024 08:32:05:ShowCBSAcNo CBS A/C No 2: 001001010972 01-04-2024 08:32:05:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 08:32:05:Record Count : 1 01-04-2024 08:32:05:BRLENGTH 3 01-04-2024 08:32:05:SCHLENGTH 3 01-04-2024 08:32:05:ACLENGTH 6 01-04-2024 08:32:05:Branch Code 3 01-04-2024 08:32:05:Scheme Code 3 01-04-2024 08:32:05:Account No 3 01-04-2024 08:32:05:Link Main Started 01-04-2024 08:32:05:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 01-04-2024 08:32:05:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 08:32:05:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|010972|SB |001 01-04-2024 08:32:05:Vno --->:142470 01-04-2024 08:32:05:Current Date --->:01-04-2024 01-04-2024 08:32:06:calling CallNewRtgsBothProc 01-04-2024 08:32:06:Parameters passing - InwardAuthorise 01-04-2024 08:32:06: brn =001 01-04-2024 08:32:06: acno =010972 01-04-2024 08:32:06: abbr =SB 01-04-2024 08:32:06: amt.ToString() =11500 01-04-2024 08:32:06: traceNo =142470 01-04-2024 08:32:06: narr =NEFT, BY KURIEN VERGHESE FDRL0002199 21990100000071 01-04-2024 08:32:06:Transaction Process : BEFORE CAL PROC: 01-04-2024 08:32:06:cbs no--->001001010972 01-04-2024 08:32:06:ShowCBSAcNo CBS A/C No : 001001010972 01-04-2024 08:32:06:ShowCBSAcNo CBS A/C No 2: 001001010972 01-04-2024 08:32:06:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 08:32:06:Record Count : 1 01-04-2024 08:32:06:BRLENGTH 3 01-04-2024 08:32:06:SCHLENGTH 3 01-04-2024 08:32:06:ACLENGTH 6 01-04-2024 08:32:06:Branch Code 3 01-04-2024 08:32:06:Scheme Code 3 01-04-2024 08:32:06:Account No 3 01-04-2024 08:32:06:Link Main Started 01-04-2024 08:32:06:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 01-04-2024 08:32:06:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 08:32:06:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|010972|SB |001 01-04-2024 08:32:06:Closed YN quier --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG,DSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,depositmaster,depositschemesetup,ADDRESS where CLMS_SNO=DEPM_CLIENT AND DSCH_BRANCH = DEPM_BRANCH AND DSCH_ABBR = DEPM_ABBR and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB' AND DEPM_NO=010972 AND ADDR_SNO=CLMS_ADDRESS union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG,LSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,LOANMASTER,LOANSCHEMESETUP,ADDRESS where CLMS_SNO=LOAM_CLIENT AND LSCH_BRANCH = LOAM_BRANCH AND LSCH_ABBREV = LOAM_ABBR and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='SB' AND LOAM_NO=010972 AND ADDR_SNO=CLMS_ADDRESS UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG,ODST_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,ODMASTER,ODSCHEMESETUP,ADDRESS where CLMS_SNO=ODMT_CLIENT AND ODST_BRANCH = ODMT_BRANCH AND ODST_ABBR = ODMT_ABBR and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='SB' AND ODMT_NO=010972 AND ADDR_SNO=CLMS_ADDRESS 01-04-2024 08:32:06:closed y n Record count --->1 01-04-2024 08:32:06:CBS A/C FOR SMS PUSH : XXXXXX010972 01-04-2024 08:32:06:SMS Inserted for Mobile Number : +918296502932 01-04-2024 08:32:06:Inward Process Executed Sussefully 01-04-2024 08:32:06:ConfirmationReq Execution Success with Status 000 01-04-2024 08:32:06:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : FDRLH24091348340|001001010972 ------------------------------> 01-04-2024 08:32:06:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 08:33:22:<------------------------Started ValidationRequest CBS A/C No : 002002000088 ------------------------> 01-04-2024 08:33:22:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 08:33:22:Connection Establisment started 01-04-2024 08:33:22:Connection Read From File : Status OK 01-04-2024 08:33:22:Connection Successfully Opened : Status OK 01-04-2024 08:33:22:ValidateAcNo CBS A/C No : 002002000088 01-04-2024 08:33:22:ValidateAcNo CBS A/C No 2: 002002000088 01-04-2024 08:33:22:ShowCBSAcNo CBS A/C No : 002002000088 01-04-2024 08:33:22:ShowCBSAcNo CBS A/C No 2: 002002000088 01-04-2024 08:33:22:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 08:33:22:Record Count : 1 01-04-2024 08:33:22:BRLENGTH 3 01-04-2024 08:33:22:SCHLENGTH 3 01-04-2024 08:33:22:ACLENGTH 6 01-04-2024 08:33:22:Branch Code 3 01-04-2024 08:33:22:Scheme Code 3 01-04-2024 08:33:22:Account No 3 01-04-2024 08:33:22:Link Main Started 01-04-2024 08:33:22:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 01-04-2024 08:33:22:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 002 01-04-2024 08:33:22:ShowCBS Ac No Proce Executed DOMMASANDRA|DEPOSIT|000088|CA |002 01-04-2024 08:33:22:A/c no length validation qry --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG FROM clientmaster,depositmaster where CLMS_SNO=DEPM_CLIENT and DEPM_BRANCH=002 and TRIM(DEPM_ABBR)='CA' AND DEPM_NO=000088 union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG FROM clientmaster,LOANMASTER where CLMS_SNO=LOAM_CLIENT and LOAM_BRANCH =002 and TRIM(LOAM_ABBR)='CA' AND LOAM_NO=000088 UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG FROM clientmaster,ODMASTER where CLMS_SNO=ODMT_CLIENT and ODMT_BRANCH=002 and TRIM(ODMT_ABBR)='CA' AND ODMT_NO=000088 01-04-2024 08:33:22:Validation Account Proce Executed with out error Y 01-04-2024 08:33:22:ValidationRequest Exccution Success with response : 000 01-04-2024 08:33:22:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 08:34:06:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : P092240312798728|002002000088 --------------------------> 01-04-2024 08:34:06:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 08:34:06:ConfirmationReq CBS A/C No : 002002000088 01-04-2024 08:34:06:ConfirmationReq A/C No 2: 002002000088 01-04-2024 08:34:06:Connection Establisment started 01-04-2024 08:34:06:Connection Read From File : Status OK 01-04-2024 08:34:06:Connection Successfully Opened : Status OK 01-04-2024 08:34:06:ValidateAcNo CBS A/C No : 002002000088 01-04-2024 08:34:06:ValidateAcNo CBS A/C No 2: 002002000088 01-04-2024 08:34:06:ShowCBSAcNo CBS A/C No : 002002000088 01-04-2024 08:34:06:ShowCBSAcNo CBS A/C No 2: 002002000088 01-04-2024 08:34:06:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 08:34:06:Record Count : 1 01-04-2024 08:34:06:BRLENGTH 3 01-04-2024 08:34:06:SCHLENGTH 3 01-04-2024 08:34:06:ACLENGTH 6 01-04-2024 08:34:06:Branch Code 3 01-04-2024 08:34:06:Scheme Code 3 01-04-2024 08:34:06:Account No 3 01-04-2024 08:34:06:Link Main Started 01-04-2024 08:34:06:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 01-04-2024 08:34:06:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 002 01-04-2024 08:34:06:ShowCBS Ac No Proce Executed DOMMASANDRA|DEPOSIT|000088|CA |002 01-04-2024 08:34:06:A/c no length validation qry --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG FROM clientmaster,depositmaster where CLMS_SNO=DEPM_CLIENT and DEPM_BRANCH=002 and TRIM(DEPM_ABBR)='CA' AND DEPM_NO=000088 union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG FROM clientmaster,LOANMASTER where CLMS_SNO=LOAM_CLIENT and LOAM_BRANCH =002 and TRIM(LOAM_ABBR)='CA' AND LOAM_NO=000088 UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG FROM clientmaster,ODMASTER where CLMS_SNO=ODMT_CLIENT and ODMT_BRANCH=002 and TRIM(ODMT_ABBR)='CA' AND ODMT_NO=000088 01-04-2024 08:34:06:Validation Account Proce Executed with out error Y 01-04-2024 08:34:06:Connection Establisment started 01-04-2024 08:34:06:Connection Read From File : Status OK 01-04-2024 08:34:06:Connection Successfully Opened : Status OK 01-04-2024 08:34:06:Inward_process CBS A/C No : 002002000088 01-04-2024 08:34:06:Inward_processCBS A/C No : 002002000088 01-04-2024 08:34:06:ShowCBSAcNo CBS A/C No : 002002000088 01-04-2024 08:34:06:ShowCBSAcNo CBS A/C No 2: 002002000088 01-04-2024 08:34:06:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 08:34:06:Record Count : 1 01-04-2024 08:34:06:BRLENGTH 3 01-04-2024 08:34:06:SCHLENGTH 3 01-04-2024 08:34:06:ACLENGTH 6 01-04-2024 08:34:06:Branch Code 3 01-04-2024 08:34:06:Scheme Code 3 01-04-2024 08:34:06:Account No 3 01-04-2024 08:34:06:Link Main Started 01-04-2024 08:34:06:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 01-04-2024 08:34:06:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 002 01-04-2024 08:34:06:ShowCBS Ac No Proce Executed DOMMASANDRA|DEPOSIT|000088|CA |002 01-04-2024 08:34:06:Vno --->:142471 01-04-2024 08:34:06:Current Date --->:01-04-2024 01-04-2024 08:34:06:calling CallNewRtgsBothProc 01-04-2024 08:34:06:Parameters passing - InwardAuthorise 01-04-2024 08:34:06: brn =002 01-04-2024 08:34:06: acno =000088 01-04-2024 08:34:06: abbr =CA 01-04-2024 08:34:06: amt.ToString() =14000 01-04-2024 08:34:06: traceNo =142471 01-04-2024 08:34:06: narr =NEFT, BY SANTHOSH CHARITABLE TRUST CNRB0002757 2757101002645 01-04-2024 08:34:06:Transaction Process : BEFORE CAL PROC: 01-04-2024 08:34:07:cbs no--->002002000088 01-04-2024 08:34:07:ShowCBSAcNo CBS A/C No : 002002000088 01-04-2024 08:34:07:ShowCBSAcNo CBS A/C No 2: 002002000088 01-04-2024 08:34:07:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 08:34:07:Record Count : 1 01-04-2024 08:34:07:BRLENGTH 3 01-04-2024 08:34:07:SCHLENGTH 3 01-04-2024 08:34:07:ACLENGTH 6 01-04-2024 08:34:07:Branch Code 3 01-04-2024 08:34:07:Scheme Code 3 01-04-2024 08:34:07:Account No 3 01-04-2024 08:34:07:Link Main Started 01-04-2024 08:34:07:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 01-04-2024 08:34:07:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 002 01-04-2024 08:34:07:ShowCBS Ac No Proce Executed DOMMASANDRA|DEPOSIT|000088|CA |002 01-04-2024 08:34:07:Closed YN quier --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG,DSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,depositmaster,depositschemesetup,ADDRESS where CLMS_SNO=DEPM_CLIENT AND DSCH_BRANCH = DEPM_BRANCH AND DSCH_ABBR = DEPM_ABBR and DEPM_BRANCH=002 and TRIM(DEPM_ABBR)='CA' AND DEPM_NO=000088 AND ADDR_SNO=CLMS_ADDRESS union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG,LSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,LOANMASTER,LOANSCHEMESETUP,ADDRESS where CLMS_SNO=LOAM_CLIENT AND LSCH_BRANCH = LOAM_BRANCH AND LSCH_ABBREV = LOAM_ABBR and LOAM_BRANCH =002 and TRIM(LOAM_ABBR)='CA' AND LOAM_NO=000088 AND ADDR_SNO=CLMS_ADDRESS UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG,ODST_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,ODMASTER,ODSCHEMESETUP,ADDRESS where CLMS_SNO=ODMT_CLIENT AND ODST_BRANCH = ODMT_BRANCH AND ODST_ABBR = ODMT_ABBR and ODMT_BRANCH=002 and TRIM(ODMT_ABBR)='CA' AND ODMT_NO=000088 AND ADDR_SNO=CLMS_ADDRESS 01-04-2024 08:34:07:closed y n Record count --->1 01-04-2024 08:34:07:CBS A/C FOR SMS PUSH : XXXXXX000088 01-04-2024 08:34:07:SMS Inserted for Mobile Number : +919739292730 01-04-2024 08:34:07:Inward Process Executed Sussefully 01-04-2024 08:34:07:ConfirmationReq Execution Success with Status 000 01-04-2024 08:34:07:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : P092240312798728|002002000088 ------------------------------> 01-04-2024 08:34:07:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 09:31:26:<------------------------Started ValidationRequest CBS A/C No : 001001000143 ------------------------> 01-04-2024 09:31:26:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 09:31:26:Connection Establisment started 01-04-2024 09:31:26:Connection Read From File : Status OK 01-04-2024 09:31:27:Connection Successfully Opened : Status OK 01-04-2024 09:31:27:ValidateAcNo CBS A/C No : 001001000143 01-04-2024 09:31:27:ValidateAcNo CBS A/C No 2: 001001000143 01-04-2024 09:31:27:ShowCBSAcNo CBS A/C No : 001001000143 01-04-2024 09:31:27:ShowCBSAcNo CBS A/C No 2: 001001000143 01-04-2024 09:31:27:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 09:31:27:Record Count : 1 01-04-2024 09:31:27:BRLENGTH 3 01-04-2024 09:31:27:SCHLENGTH 3 01-04-2024 09:31:27:ACLENGTH 6 01-04-2024 09:31:27:Branch Code 3 01-04-2024 09:31:27:Scheme Code 3 01-04-2024 09:31:27:Account No 3 01-04-2024 09:31:27:Link Main Started 01-04-2024 09:31:27:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 01-04-2024 09:31:27:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 09:31:27:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000143|SB |001 01-04-2024 09:31:27:A/c no length validation qry --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG FROM clientmaster,depositmaster where CLMS_SNO=DEPM_CLIENT and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB' AND DEPM_NO=000143 union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG FROM clientmaster,LOANMASTER where CLMS_SNO=LOAM_CLIENT and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='SB' AND LOAM_NO=000143 UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG FROM clientmaster,ODMASTER where CLMS_SNO=ODMT_CLIENT and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='SB' AND ODMT_NO=000143 01-04-2024 09:31:27:Validation Account Proce Executed with out error Y 01-04-2024 09:31:27:ValidationRequest Exccution Success with response : 000 01-04-2024 09:31:27:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 09:31:45:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : HS92409238418024|001001000143 --------------------------> 01-04-2024 09:31:45:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 09:31:45:ConfirmationReq CBS A/C No : 001001000143 01-04-2024 09:31:45:ConfirmationReq A/C No 2: 001001000143 01-04-2024 09:31:45:Connection Establisment started 01-04-2024 09:31:45:Connection Read From File : Status OK 01-04-2024 09:31:46:Connection Successfully Opened : Status OK 01-04-2024 09:31:46:ValidateAcNo CBS A/C No : 001001000143 01-04-2024 09:31:46:ValidateAcNo CBS A/C No 2: 001001000143 01-04-2024 09:31:46:ShowCBSAcNo CBS A/C No : 001001000143 01-04-2024 09:31:46:ShowCBSAcNo CBS A/C No 2: 001001000143 01-04-2024 09:31:46:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 09:31:46:Record Count : 1 01-04-2024 09:31:46:BRLENGTH 3 01-04-2024 09:31:46:SCHLENGTH 3 01-04-2024 09:31:46:ACLENGTH 6 01-04-2024 09:31:46:Branch Code 3 01-04-2024 09:31:46:Scheme Code 3 01-04-2024 09:31:46:Account No 3 01-04-2024 09:31:46:Link Main Started 01-04-2024 09:31:46:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 01-04-2024 09:31:46:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 09:31:46:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000143|SB |001 01-04-2024 09:31:46:A/c no length validation qry --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG FROM clientmaster,depositmaster where CLMS_SNO=DEPM_CLIENT and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB' AND DEPM_NO=000143 union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG FROM clientmaster,LOANMASTER where CLMS_SNO=LOAM_CLIENT and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='SB' AND LOAM_NO=000143 UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG FROM clientmaster,ODMASTER where CLMS_SNO=ODMT_CLIENT and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='SB' AND ODMT_NO=000143 01-04-2024 09:31:46:Validation Account Proce Executed with out error Y 01-04-2024 09:31:46:Connection Establisment started 01-04-2024 09:31:46:Connection Read From File : Status OK 01-04-2024 09:31:46:Connection Successfully Opened : Status OK 01-04-2024 09:31:46:Inward_process CBS A/C No : 001001000143 01-04-2024 09:31:46:Inward_processCBS A/C No : 001001000143 01-04-2024 09:31:46:ShowCBSAcNo CBS A/C No : 001001000143 01-04-2024 09:31:46:ShowCBSAcNo CBS A/C No 2: 001001000143 01-04-2024 09:31:46:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 09:31:46:Record Count : 1 01-04-2024 09:31:46:BRLENGTH 3 01-04-2024 09:31:46:SCHLENGTH 3 01-04-2024 09:31:46:ACLENGTH 6 01-04-2024 09:31:46:Branch Code 3 01-04-2024 09:31:46:Scheme Code 3 01-04-2024 09:31:46:Account No 3 01-04-2024 09:31:46:Link Main Started 01-04-2024 09:31:46:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 01-04-2024 09:31:46:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 09:31:46:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000143|SB |001 01-04-2024 09:31:46:Vno --->:142472 01-04-2024 09:31:46:Current Date --->:01-04-2024 01-04-2024 09:31:46:calling CallNewRtgsBothProc 01-04-2024 09:31:46:Parameters passing - InwardAuthorise 01-04-2024 09:31:46: brn =001 01-04-2024 09:31:46: acno =000143 01-04-2024 09:31:46: abbr =SB 01-04-2024 09:31:46: amt.ToString() =19000 01-04-2024 09:31:46: traceNo =142472 01-04-2024 09:31:46: narr =NEFT, BY VAISHAKRAVISHANKARA ICIC0SF0002 004701612390 01-04-2024 09:31:46:Transaction Process : BEFORE CAL PROC: 01-04-2024 09:31:46:cbs no--->001001000143 01-04-2024 09:31:46:ShowCBSAcNo CBS A/C No : 001001000143 01-04-2024 09:31:46:ShowCBSAcNo CBS A/C No 2: 001001000143 01-04-2024 09:31:46:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 09:31:46:Record Count : 1 01-04-2024 09:31:46:BRLENGTH 3 01-04-2024 09:31:46:SCHLENGTH 3 01-04-2024 09:31:46:ACLENGTH 6 01-04-2024 09:31:46:Branch Code 3 01-04-2024 09:31:46:Scheme Code 3 01-04-2024 09:31:46:Account No 3 01-04-2024 09:31:46:Link Main Started 01-04-2024 09:31:46:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 01-04-2024 09:31:46:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 09:31:46:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000143|SB |001 01-04-2024 09:31:46:Closed YN quier --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG,DSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,depositmaster,depositschemesetup,ADDRESS where CLMS_SNO=DEPM_CLIENT AND DSCH_BRANCH = DEPM_BRANCH AND DSCH_ABBR = DEPM_ABBR and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB' AND DEPM_NO=000143 AND ADDR_SNO=CLMS_ADDRESS union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG,LSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,LOANMASTER,LOANSCHEMESETUP,ADDRESS where CLMS_SNO=LOAM_CLIENT AND LSCH_BRANCH = LOAM_BRANCH AND LSCH_ABBREV = LOAM_ABBR and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='SB' AND LOAM_NO=000143 AND ADDR_SNO=CLMS_ADDRESS UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG,ODST_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,ODMASTER,ODSCHEMESETUP,ADDRESS where CLMS_SNO=ODMT_CLIENT AND ODST_BRANCH = ODMT_BRANCH AND ODST_ABBR = ODMT_ABBR and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='SB' AND ODMT_NO=000143 AND ADDR_SNO=CLMS_ADDRESS 01-04-2024 09:31:46:closed y n Record count --->1 01-04-2024 09:31:46:CBS A/C FOR SMS PUSH : XXXXXX000143 01-04-2024 09:31:46:SMS Inserted for Mobile Number : +919980137665 01-04-2024 09:31:46:Inward Process Executed Sussefully 01-04-2024 09:31:46:ConfirmationReq Execution Success with Status 000 01-04-2024 09:31:46:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : HS92409238418024|001001000143 ------------------------------> 01-04-2024 09:31:46:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 13:01:41:<------------------------Started ValidationRequest CBS A/C No : 001001010792 ------------------------> 01-04-2024 13:01:41:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 13:01:41:Connection Establisment started 01-04-2024 13:01:41:Connection Read From File : Status OK 01-04-2024 13:01:42:Connection Successfully Opened : Status OK 01-04-2024 13:01:42:ValidateAcNo CBS A/C No : 001001010792 01-04-2024 13:01:42:ValidateAcNo CBS A/C No 2: 001001010792 01-04-2024 13:01:42:ShowCBSAcNo CBS A/C No : 001001010792 01-04-2024 13:01:42:ShowCBSAcNo CBS A/C No 2: 001001010792 01-04-2024 13:01:42:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 13:01:42:Record Count : 1 01-04-2024 13:01:42:BRLENGTH 3 01-04-2024 13:01:42:SCHLENGTH 3 01-04-2024 13:01:42:ACLENGTH 6 01-04-2024 13:01:42:Branch Code 3 01-04-2024 13:01:42:Scheme Code 3 01-04-2024 13:01:42:Account No 3 01-04-2024 13:01:42:Link Main Started 01-04-2024 13:01:42:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 01-04-2024 13:01:42:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 13:01:42:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|010792|SB |001 01-04-2024 13:01:42:A/c no length validation qry --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG FROM clientmaster,depositmaster where CLMS_SNO=DEPM_CLIENT and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB' AND DEPM_NO=010792 union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG FROM clientmaster,LOANMASTER where CLMS_SNO=LOAM_CLIENT and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='SB' AND LOAM_NO=010792 UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG FROM clientmaster,ODMASTER where CLMS_SNO=ODMT_CLIENT and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='SB' AND ODMT_NO=010792 01-04-2024 13:01:42:Validation Account Proce Executed with out error Y 01-04-2024 13:01:42:ValidationRequest Exccution Success with response : 000 01-04-2024 13:01:42:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 13:01:42:<------------------------Started ValidationRequest CBS A/C No : 001001010792 ------------------------> 01-04-2024 13:01:42:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 13:01:42:Connection Establisment started 01-04-2024 13:01:42:Connection Read From File : Status OK 01-04-2024 13:01:43:Connection Successfully Opened : Status OK 01-04-2024 13:01:43:ValidateAcNo CBS A/C No : 001001010792 01-04-2024 13:01:43:ValidateAcNo CBS A/C No 2: 001001010792 01-04-2024 13:01:43:ShowCBSAcNo CBS A/C No : 001001010792 01-04-2024 13:01:43:ShowCBSAcNo CBS A/C No 2: 001001010792 01-04-2024 13:01:43:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 13:01:43:Record Count : 1 01-04-2024 13:01:43:BRLENGTH 3 01-04-2024 13:01:43:SCHLENGTH 3 01-04-2024 13:01:43:ACLENGTH 6 01-04-2024 13:01:43:Branch Code 3 01-04-2024 13:01:43:Scheme Code 3 01-04-2024 13:01:43:Account No 3 01-04-2024 13:01:43:Link Main Started 01-04-2024 13:01:43:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 01-04-2024 13:01:43:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 13:01:43:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|010792|SB |001 01-04-2024 13:01:43:A/c no length validation qry --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG FROM clientmaster,depositmaster where CLMS_SNO=DEPM_CLIENT and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB' AND DEPM_NO=010792 union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG FROM clientmaster,LOANMASTER where CLMS_SNO=LOAM_CLIENT and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='SB' AND LOAM_NO=010792 UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG FROM clientmaster,ODMASTER where CLMS_SNO=ODMT_CLIENT and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='SB' AND ODMT_NO=010792 01-04-2024 13:01:43:Validation Account Proce Executed with out error Y 01-04-2024 13:01:43:ValidationRequest Exccution Success with response : 000 01-04-2024 13:01:43:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 13:02:08:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : FDRLH24091357906|001001010792 --------------------------> 01-04-2024 13:02:08:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 13:02:08:ConfirmationReq CBS A/C No : 001001010792 01-04-2024 13:02:08:ConfirmationReq A/C No 2: 001001010792 01-04-2024 13:02:08:Connection Establisment started 01-04-2024 13:02:08:Connection Read From File : Status OK 01-04-2024 13:02:09:Connection Successfully Opened : Status OK 01-04-2024 13:02:09:ValidateAcNo CBS A/C No : 001001010792 01-04-2024 13:02:09:ValidateAcNo CBS A/C No 2: 001001010792 01-04-2024 13:02:09:ShowCBSAcNo CBS A/C No : 001001010792 01-04-2024 13:02:09:ShowCBSAcNo CBS A/C No 2: 001001010792 01-04-2024 13:02:09:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 13:02:09:Record Count : 1 01-04-2024 13:02:09:BRLENGTH 3 01-04-2024 13:02:09:SCHLENGTH 3 01-04-2024 13:02:09:ACLENGTH 6 01-04-2024 13:02:09:Branch Code 3 01-04-2024 13:02:09:Scheme Code 3 01-04-2024 13:02:09:Account No 3 01-04-2024 13:02:09:Link Main Started 01-04-2024 13:02:09:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 01-04-2024 13:02:09:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 13:02:09:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|010792|SB |001 01-04-2024 13:02:09:A/c no length validation qry --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG FROM clientmaster,depositmaster where CLMS_SNO=DEPM_CLIENT and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB' AND DEPM_NO=010792 union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG FROM clientmaster,LOANMASTER where CLMS_SNO=LOAM_CLIENT and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='SB' AND LOAM_NO=010792 UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG FROM clientmaster,ODMASTER where CLMS_SNO=ODMT_CLIENT and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='SB' AND ODMT_NO=010792 01-04-2024 13:02:09:Validation Account Proce Executed with out error Y 01-04-2024 13:02:09:Connection Establisment started 01-04-2024 13:02:09:Connection Read From File : Status OK 01-04-2024 13:02:09:Connection Successfully Opened : Status OK 01-04-2024 13:02:09:Inward_process CBS A/C No : 001001010792 01-04-2024 13:02:09:Inward_processCBS A/C No : 001001010792 01-04-2024 13:02:09:ShowCBSAcNo CBS A/C No : 001001010792 01-04-2024 13:02:09:ShowCBSAcNo CBS A/C No 2: 001001010792 01-04-2024 13:02:09:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 13:02:09:Record Count : 1 01-04-2024 13:02:09:BRLENGTH 3 01-04-2024 13:02:09:SCHLENGTH 3 01-04-2024 13:02:09:ACLENGTH 6 01-04-2024 13:02:09:Branch Code 3 01-04-2024 13:02:09:Scheme Code 3 01-04-2024 13:02:09:Account No 3 01-04-2024 13:02:09:Link Main Started 01-04-2024 13:02:09:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 01-04-2024 13:02:09:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 13:02:09:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|010792|SB |001 01-04-2024 13:02:09:Vno --->:142487 01-04-2024 13:02:09:Current Date --->:01-04-2024 01-04-2024 13:02:09:calling CallNewRtgsBothProc 01-04-2024 13:02:09:Parameters passing - InwardAuthorise 01-04-2024 13:02:09: brn =001 01-04-2024 13:02:09: acno =010792 01-04-2024 13:02:09: abbr =SB 01-04-2024 13:02:09: amt.ToString() =67500 01-04-2024 13:02:09: traceNo =142487 01-04-2024 13:02:09: narr =NEFT, BY ALGOMOX PRIVATE LIMITED FDRL0001769 17690200003787 01-04-2024 13:02:09:Transaction Process : BEFORE CAL PROC: 01-04-2024 13:02:09:cbs no--->001001010792 01-04-2024 13:02:09:ShowCBSAcNo CBS A/C No : 001001010792 01-04-2024 13:02:09:ShowCBSAcNo CBS A/C No 2: 001001010792 01-04-2024 13:02:09:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 13:02:09:Record Count : 1 01-04-2024 13:02:09:BRLENGTH 3 01-04-2024 13:02:09:SCHLENGTH 3 01-04-2024 13:02:09:ACLENGTH 6 01-04-2024 13:02:09:Branch Code 3 01-04-2024 13:02:09:Scheme Code 3 01-04-2024 13:02:09:Account No 3 01-04-2024 13:02:09:Link Main Started 01-04-2024 13:02:09:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 01-04-2024 13:02:09:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 13:02:09:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|010792|SB |001 01-04-2024 13:02:09:Closed YN quier --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG,DSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,depositmaster,depositschemesetup,ADDRESS where CLMS_SNO=DEPM_CLIENT AND DSCH_BRANCH = DEPM_BRANCH AND DSCH_ABBR = DEPM_ABBR and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB' AND DEPM_NO=010792 AND ADDR_SNO=CLMS_ADDRESS union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG,LSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,LOANMASTER,LOANSCHEMESETUP,ADDRESS where CLMS_SNO=LOAM_CLIENT AND LSCH_BRANCH = LOAM_BRANCH AND LSCH_ABBREV = LOAM_ABBR and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='SB' AND LOAM_NO=010792 AND ADDR_SNO=CLMS_ADDRESS UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG,ODST_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,ODMASTER,ODSCHEMESETUP,ADDRESS where CLMS_SNO=ODMT_CLIENT AND ODST_BRANCH = ODMT_BRANCH AND ODST_ABBR = ODMT_ABBR and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='SB' AND ODMT_NO=010792 AND ADDR_SNO=CLMS_ADDRESS 01-04-2024 13:02:09:closed y n Record count --->1 01-04-2024 13:02:09:CBS A/C FOR SMS PUSH : XXXXXX010792 01-04-2024 13:02:09:SMS Inserted for Mobile Number : +917760959747 01-04-2024 13:02:09:Inward Process Executed Sussefully 01-04-2024 13:02:09:ConfirmationReq Execution Success with Status 000 01-04-2024 13:02:09:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : FDRLH24091357906|001001010792 ------------------------------> 01-04-2024 13:02:09:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 13:02:09:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : FDRLH24091357928|001001010792 --------------------------> 01-04-2024 13:02:09:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 13:02:09:ConfirmationReq CBS A/C No : 001001010792 01-04-2024 13:02:09:ConfirmationReq A/C No 2: 001001010792 01-04-2024 13:02:09:Connection Establisment started 01-04-2024 13:02:09:Connection Read From File : Status OK 01-04-2024 13:02:10:Connection Successfully Opened : Status OK 01-04-2024 13:02:10:ValidateAcNo CBS A/C No : 001001010792 01-04-2024 13:02:10:ValidateAcNo CBS A/C No 2: 001001010792 01-04-2024 13:02:10:ShowCBSAcNo CBS A/C No : 001001010792 01-04-2024 13:02:10:ShowCBSAcNo CBS A/C No 2: 001001010792 01-04-2024 13:02:10:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 13:02:10:Record Count : 1 01-04-2024 13:02:10:BRLENGTH 3 01-04-2024 13:02:10:SCHLENGTH 3 01-04-2024 13:02:10:ACLENGTH 6 01-04-2024 13:02:10:Branch Code 3 01-04-2024 13:02:10:Scheme Code 3 01-04-2024 13:02:10:Account No 3 01-04-2024 13:02:10:Link Main Started 01-04-2024 13:02:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 01-04-2024 13:02:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 13:02:10:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|010792|SB |001 01-04-2024 13:02:10:A/c no length validation qry --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG FROM clientmaster,depositmaster where CLMS_SNO=DEPM_CLIENT and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB' AND DEPM_NO=010792 union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG FROM clientmaster,LOANMASTER where CLMS_SNO=LOAM_CLIENT and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='SB' AND LOAM_NO=010792 UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG FROM clientmaster,ODMASTER where CLMS_SNO=ODMT_CLIENT and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='SB' AND ODMT_NO=010792 01-04-2024 13:02:10:Validation Account Proce Executed with out error Y 01-04-2024 13:02:10:Connection Establisment started 01-04-2024 13:02:10:Connection Read From File : Status OK 01-04-2024 13:02:10:Connection Successfully Opened : Status OK 01-04-2024 13:02:10:Inward_process CBS A/C No : 001001010792 01-04-2024 13:02:10:Inward_processCBS A/C No : 001001010792 01-04-2024 13:02:10:ShowCBSAcNo CBS A/C No : 001001010792 01-04-2024 13:02:10:ShowCBSAcNo CBS A/C No 2: 001001010792 01-04-2024 13:02:10:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 13:02:10:Record Count : 1 01-04-2024 13:02:10:BRLENGTH 3 01-04-2024 13:02:10:SCHLENGTH 3 01-04-2024 13:02:10:ACLENGTH 6 01-04-2024 13:02:10:Branch Code 3 01-04-2024 13:02:10:Scheme Code 3 01-04-2024 13:02:10:Account No 3 01-04-2024 13:02:10:Link Main Started 01-04-2024 13:02:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 01-04-2024 13:02:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 13:02:10:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|010792|SB |001 01-04-2024 13:02:10:Vno --->:142488 01-04-2024 13:02:10:Current Date --->:01-04-2024 01-04-2024 13:02:10:calling CallNewRtgsBothProc 01-04-2024 13:02:10:Parameters passing - InwardAuthorise 01-04-2024 13:02:10: brn =001 01-04-2024 13:02:10: acno =010792 01-04-2024 13:02:10: abbr =SB 01-04-2024 13:02:10: amt.ToString() =2000 01-04-2024 13:02:10: traceNo =142488 01-04-2024 13:02:10: narr =NEFT, BY ALGOMOX PRIVATE LIMITED FDRL0001769 17690200003787 01-04-2024 13:02:10:Transaction Process : BEFORE CAL PROC: 01-04-2024 13:02:10:cbs no--->001001010792 01-04-2024 13:02:10:ShowCBSAcNo CBS A/C No : 001001010792 01-04-2024 13:02:10:ShowCBSAcNo CBS A/C No 2: 001001010792 01-04-2024 13:02:10:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 13:02:10:Record Count : 1 01-04-2024 13:02:10:BRLENGTH 3 01-04-2024 13:02:10:SCHLENGTH 3 01-04-2024 13:02:10:ACLENGTH 6 01-04-2024 13:02:10:Branch Code 3 01-04-2024 13:02:10:Scheme Code 3 01-04-2024 13:02:10:Account No 3 01-04-2024 13:02:10:Link Main Started 01-04-2024 13:02:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 01-04-2024 13:02:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 13:02:10:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|010792|SB |001 01-04-2024 13:02:10:Closed YN quier --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG,DSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,depositmaster,depositschemesetup,ADDRESS where CLMS_SNO=DEPM_CLIENT AND DSCH_BRANCH = DEPM_BRANCH AND DSCH_ABBR = DEPM_ABBR and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB' AND DEPM_NO=010792 AND ADDR_SNO=CLMS_ADDRESS union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG,LSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,LOANMASTER,LOANSCHEMESETUP,ADDRESS where CLMS_SNO=LOAM_CLIENT AND LSCH_BRANCH = LOAM_BRANCH AND LSCH_ABBREV = LOAM_ABBR and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='SB' AND LOAM_NO=010792 AND ADDR_SNO=CLMS_ADDRESS UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG,ODST_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,ODMASTER,ODSCHEMESETUP,ADDRESS where CLMS_SNO=ODMT_CLIENT AND ODST_BRANCH = ODMT_BRANCH AND ODST_ABBR = ODMT_ABBR and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='SB' AND ODMT_NO=010792 AND ADDR_SNO=CLMS_ADDRESS 01-04-2024 13:02:10:closed y n Record count --->1 01-04-2024 13:02:10:CBS A/C FOR SMS PUSH : XXXXXX010792 01-04-2024 13:02:10:SMS Inserted for Mobile Number : +917760959747 01-04-2024 13:02:10:Inward Process Executed Sussefully 01-04-2024 13:02:10:ConfirmationReq Execution Success with Status 000 01-04-2024 13:02:10:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : FDRLH24091357928|001001010792 ------------------------------> 01-04-2024 13:02:10:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 13:31:58:<------------------------Started ValidationRequest CBS A/C No : 001001012056 ------------------------> 01-04-2024 13:31:58:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 13:31:58:Connection Establisment started 01-04-2024 13:31:58:Connection Read From File : Status OK 01-04-2024 13:31:58:Connection Successfully Opened : Status OK 01-04-2024 13:31:58:ValidateAcNo CBS A/C No : 001001012056 01-04-2024 13:31:58:ValidateAcNo CBS A/C No 2: 001001012056 01-04-2024 13:31:58:ShowCBSAcNo CBS A/C No : 001001012056 01-04-2024 13:31:58:ShowCBSAcNo CBS A/C No 2: 001001012056 01-04-2024 13:31:58:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 13:31:58:Record Count : 1 01-04-2024 13:31:58:BRLENGTH 3 01-04-2024 13:31:58:SCHLENGTH 3 01-04-2024 13:31:58:ACLENGTH 6 01-04-2024 13:31:58:Branch Code 3 01-04-2024 13:31:58:Scheme Code 3 01-04-2024 13:31:58:Account No 3 01-04-2024 13:31:58:Link Main Started 01-04-2024 13:31:58:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 01-04-2024 13:31:58:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 13:31:58:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|012056|SB |001 01-04-2024 13:31:58:A/c no length validation qry --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG FROM clientmaster,depositmaster where CLMS_SNO=DEPM_CLIENT and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB' AND DEPM_NO=012056 union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG FROM clientmaster,LOANMASTER where CLMS_SNO=LOAM_CLIENT and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='SB' AND LOAM_NO=012056 UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG FROM clientmaster,ODMASTER where CLMS_SNO=ODMT_CLIENT and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='SB' AND ODMT_NO=012056 01-04-2024 13:31:58:Validation Account Proce Executed with out error Y 01-04-2024 13:31:58:ValidationRequest Exccution Success with response : 000 01-04-2024 13:31:58:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 13:32:30:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : DEUTN24092478216|001001012056 --------------------------> 01-04-2024 13:32:30:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 13:32:30:ConfirmationReq CBS A/C No : 001001012056 01-04-2024 13:32:30:ConfirmationReq A/C No 2: 001001012056 01-04-2024 13:32:30:Connection Establisment started 01-04-2024 13:32:30:Connection Read From File : Status OK 01-04-2024 13:32:30:Connection Successfully Opened : Status OK 01-04-2024 13:32:30:ValidateAcNo CBS A/C No : 001001012056 01-04-2024 13:32:30:ValidateAcNo CBS A/C No 2: 001001012056 01-04-2024 13:32:30:ShowCBSAcNo CBS A/C No : 001001012056 01-04-2024 13:32:30:ShowCBSAcNo CBS A/C No 2: 001001012056 01-04-2024 13:32:30:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 13:32:30:Record Count : 1 01-04-2024 13:32:30:BRLENGTH 3 01-04-2024 13:32:30:SCHLENGTH 3 01-04-2024 13:32:30:ACLENGTH 6 01-04-2024 13:32:30:Branch Code 3 01-04-2024 13:32:30:Scheme Code 3 01-04-2024 13:32:30:Account No 3 01-04-2024 13:32:30:Link Main Started 01-04-2024 13:32:30:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 01-04-2024 13:32:30:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 13:32:30:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|012056|SB |001 01-04-2024 13:32:30:A/c no length validation qry --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG FROM clientmaster,depositmaster where CLMS_SNO=DEPM_CLIENT and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB' AND DEPM_NO=012056 union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG FROM clientmaster,LOANMASTER where CLMS_SNO=LOAM_CLIENT and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='SB' AND LOAM_NO=012056 UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG FROM clientmaster,ODMASTER where CLMS_SNO=ODMT_CLIENT and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='SB' AND ODMT_NO=012056 01-04-2024 13:32:30:Validation Account Proce Executed with out error Y 01-04-2024 13:32:30:Connection Establisment started 01-04-2024 13:32:30:Connection Read From File : Status OK 01-04-2024 13:32:30:Connection Successfully Opened : Status OK 01-04-2024 13:32:30:Inward_process CBS A/C No : 001001012056 01-04-2024 13:32:30:Inward_processCBS A/C No : 001001012056 01-04-2024 13:32:30:ShowCBSAcNo CBS A/C No : 001001012056 01-04-2024 13:32:30:ShowCBSAcNo CBS A/C No 2: 001001012056 01-04-2024 13:32:30:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 13:32:30:Record Count : 1 01-04-2024 13:32:30:BRLENGTH 3 01-04-2024 13:32:30:SCHLENGTH 3 01-04-2024 13:32:30:ACLENGTH 6 01-04-2024 13:32:30:Branch Code 3 01-04-2024 13:32:30:Scheme Code 3 01-04-2024 13:32:30:Account No 3 01-04-2024 13:32:30:Link Main Started 01-04-2024 13:32:30:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 01-04-2024 13:32:30:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 13:32:30:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|012056|SB |001 01-04-2024 13:32:30:Vno --->:142489 01-04-2024 13:32:30:Current Date --->:01-04-2024 01-04-2024 13:32:30:calling CallNewRtgsBothProc 01-04-2024 13:32:30:Parameters passing - InwardAuthorise 01-04-2024 13:32:30: brn =001 01-04-2024 13:32:30: acno =012056 01-04-2024 13:32:30: abbr =SB 01-04-2024 13:32:30: amt.ToString() =15000 01-04-2024 13:32:30: traceNo =142489 01-04-2024 13:32:30: narr =NEFT, BY SRI GAYATRI GRANITES DEUT0784PBC 000005877050019 01-04-2024 13:32:30:Transaction Process : BEFORE CAL PROC: 01-04-2024 13:32:30:cbs no--->001001012056 01-04-2024 13:32:30:ShowCBSAcNo CBS A/C No : 001001012056 01-04-2024 13:32:30:ShowCBSAcNo CBS A/C No 2: 001001012056 01-04-2024 13:32:30:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 13:32:30:Record Count : 1 01-04-2024 13:32:30:BRLENGTH 3 01-04-2024 13:32:30:SCHLENGTH 3 01-04-2024 13:32:30:ACLENGTH 6 01-04-2024 13:32:30:Branch Code 3 01-04-2024 13:32:30:Scheme Code 3 01-04-2024 13:32:30:Account No 3 01-04-2024 13:32:30:Link Main Started 01-04-2024 13:32:30:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 01-04-2024 13:32:30:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 13:32:30:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|012056|SB |001 01-04-2024 13:32:30:Closed YN quier --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG,DSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,depositmaster,depositschemesetup,ADDRESS where CLMS_SNO=DEPM_CLIENT AND DSCH_BRANCH = DEPM_BRANCH AND DSCH_ABBR = DEPM_ABBR and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB' AND DEPM_NO=012056 AND ADDR_SNO=CLMS_ADDRESS union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG,LSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,LOANMASTER,LOANSCHEMESETUP,ADDRESS where CLMS_SNO=LOAM_CLIENT AND LSCH_BRANCH = LOAM_BRANCH AND LSCH_ABBREV = LOAM_ABBR and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='SB' AND LOAM_NO=012056 AND ADDR_SNO=CLMS_ADDRESS UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG,ODST_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,ODMASTER,ODSCHEMESETUP,ADDRESS where CLMS_SNO=ODMT_CLIENT AND ODST_BRANCH = ODMT_BRANCH AND ODST_ABBR = ODMT_ABBR and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='SB' AND ODMT_NO=012056 AND ADDR_SNO=CLMS_ADDRESS 01-04-2024 13:32:30:closed y n Record count --->1 01-04-2024 13:32:30:CBS A/C FOR SMS PUSH : XXXXXX012056 01-04-2024 13:32:31:SMS Inserted for Mobile Number : +916361578762 01-04-2024 13:32:31:Inward Process Executed Sussefully 01-04-2024 13:32:31:ConfirmationReq Execution Success with Status 000 01-04-2024 13:32:31:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : DEUTN24092478216|001001012056 ------------------------------> 01-04-2024 13:32:31:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 14:59:06:<------------------------Started ValidationRequest CBS A/C No : 001020000186 ------------------------> 01-04-2024 14:59:06:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 14:59:06:Connection Establisment started 01-04-2024 14:59:06:Connection Read From File : Status OK 01-04-2024 14:59:06:Connection Successfully Opened : Status OK 01-04-2024 14:59:06:ValidateAcNo CBS A/C No : 001020000186 01-04-2024 14:59:06:ValidateAcNo CBS A/C No 2: 001020000186 01-04-2024 14:59:06:ShowCBSAcNo CBS A/C No : 001020000186 01-04-2024 14:59:06:ShowCBSAcNo CBS A/C No 2: 001020000186 01-04-2024 14:59:06:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 14:59:06:Record Count : 1 01-04-2024 14:59:06:BRLENGTH 3 01-04-2024 14:59:06:SCHLENGTH 3 01-04-2024 14:59:06:ACLENGTH 6 01-04-2024 14:59:06:Branch Code 3 01-04-2024 14:59:06:Scheme Code 3 01-04-2024 14:59:06:Account No 3 01-04-2024 14:59:06:Link Main Started 01-04-2024 14:59:06:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 020 01-04-2024 14:59:06:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 14:59:06:ShowCBS Ac No Proce Executed HEAD OFFICE|OD|000186|OD |001 01-04-2024 14:59:06:A/c no length validation qry --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG FROM clientmaster,depositmaster where CLMS_SNO=DEPM_CLIENT and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='OD' AND DEPM_NO=000186 union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG FROM clientmaster,LOANMASTER where CLMS_SNO=LOAM_CLIENT and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='OD' AND LOAM_NO=000186 UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG FROM clientmaster,ODMASTER where CLMS_SNO=ODMT_CLIENT and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='OD' AND ODMT_NO=000186 01-04-2024 14:59:06:Validation Account Proce Executed with out error Y 01-04-2024 14:59:06:ValidationRequest Exccution Success with response : 000 01-04-2024 14:59:06:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 14:59:13:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : HDFCR52024033194465496|001020000186 --------------------------> 01-04-2024 14:59:13:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 14:59:13:ConfirmationReq CBS A/C No : 001020000186 01-04-2024 14:59:13:ConfirmationReq A/C No 2: 001020000186 01-04-2024 14:59:13:Connection Establisment started 01-04-2024 14:59:13:Connection Read From File : Status OK 01-04-2024 14:59:13:Connection Successfully Opened : Status OK 01-04-2024 14:59:13:ValidateAcNo CBS A/C No : 001020000186 01-04-2024 14:59:13:ValidateAcNo CBS A/C No 2: 001020000186 01-04-2024 14:59:13:ShowCBSAcNo CBS A/C No : 001020000186 01-04-2024 14:59:13:ShowCBSAcNo CBS A/C No 2: 001020000186 01-04-2024 14:59:13:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 14:59:13:Record Count : 1 01-04-2024 14:59:13:BRLENGTH 3 01-04-2024 14:59:13:SCHLENGTH 3 01-04-2024 14:59:13:ACLENGTH 6 01-04-2024 14:59:13:Branch Code 3 01-04-2024 14:59:13:Scheme Code 3 01-04-2024 14:59:13:Account No 3 01-04-2024 14:59:13:Link Main Started 01-04-2024 14:59:13:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 020 01-04-2024 14:59:13:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 14:59:13:ShowCBS Ac No Proce Executed HEAD OFFICE|OD|000186|OD |001 01-04-2024 14:59:13:A/c no length validation qry --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG FROM clientmaster,depositmaster where CLMS_SNO=DEPM_CLIENT and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='OD' AND DEPM_NO=000186 union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG FROM clientmaster,LOANMASTER where CLMS_SNO=LOAM_CLIENT and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='OD' AND LOAM_NO=000186 UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG FROM clientmaster,ODMASTER where CLMS_SNO=ODMT_CLIENT and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='OD' AND ODMT_NO=000186 01-04-2024 14:59:13:Validation Account Proce Executed with out error Y 01-04-2024 14:59:13:Connection Establisment started 01-04-2024 14:59:13:Connection Read From File : Status OK 01-04-2024 14:59:13:Connection Successfully Opened : Status OK 01-04-2024 14:59:13:Inward_process CBS A/C No : 001020000186 01-04-2024 14:59:13:Inward_processCBS A/C No : 001020000186 01-04-2024 14:59:13:ShowCBSAcNo CBS A/C No : 001020000186 01-04-2024 14:59:13:ShowCBSAcNo CBS A/C No 2: 001020000186 01-04-2024 14:59:13:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 14:59:13:Record Count : 1 01-04-2024 14:59:13:BRLENGTH 3 01-04-2024 14:59:13:SCHLENGTH 3 01-04-2024 14:59:13:ACLENGTH 6 01-04-2024 14:59:13:Branch Code 3 01-04-2024 14:59:13:Scheme Code 3 01-04-2024 14:59:13:Account No 3 01-04-2024 14:59:13:Link Main Started 01-04-2024 14:59:13:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 020 01-04-2024 14:59:13:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 14:59:13:ShowCBS Ac No Proce Executed HEAD OFFICE|OD|000186|OD |001 01-04-2024 14:59:13:Vno --->:142490 01-04-2024 14:59:13:Current Date --->:01-04-2024 01-04-2024 14:59:13:Inward Process Executed Sussefully 01-04-2024 14:59:13:ConfirmationReq Execution Success with Status 000 01-04-2024 14:59:13:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : HDFCR52024033194465496|001020000186 ------------------------------> 01-04-2024 14:59:13:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 16:41:55:<------------------------Started ValidationRequest CBS A/C No : 001002001929 ------------------------> 01-04-2024 16:41:55:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 16:41:55:Connection Establisment started 01-04-2024 16:41:55:Connection Read From File : Status OK 01-04-2024 16:41:55:Connection Successfully Opened : Status OK 01-04-2024 16:41:55:ValidateAcNo CBS A/C No : 001002001929 01-04-2024 16:41:55:ValidateAcNo CBS A/C No 2: 001002001929 01-04-2024 16:41:55:ShowCBSAcNo CBS A/C No : 001002001929 01-04-2024 16:41:55:ShowCBSAcNo CBS A/C No 2: 001002001929 01-04-2024 16:41:55:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 16:41:55:Record Count : 1 01-04-2024 16:41:55:BRLENGTH 3 01-04-2024 16:41:55:SCHLENGTH 3 01-04-2024 16:41:55:ACLENGTH 6 01-04-2024 16:41:55:Branch Code 3 01-04-2024 16:41:55:Scheme Code 3 01-04-2024 16:41:55:Account No 3 01-04-2024 16:41:55:Link Main Started 01-04-2024 16:41:55:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 01-04-2024 16:41:55:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 16:41:55:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001929|CA |001 01-04-2024 16:41:55:A/c no length validation qry --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG FROM clientmaster,depositmaster where CLMS_SNO=DEPM_CLIENT and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='CA' AND DEPM_NO=001929 union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG FROM clientmaster,LOANMASTER where CLMS_SNO=LOAM_CLIENT and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='CA' AND LOAM_NO=001929 UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG FROM clientmaster,ODMASTER where CLMS_SNO=ODMT_CLIENT and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='CA' AND ODMT_NO=001929 01-04-2024 16:41:55:Validation Account Proce Executed with out error Y 01-04-2024 16:41:55:ValidationRequest Exccution Success with response : 000 01-04-2024 16:41:55:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 16:42:02:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : ICICR12024040102159797|001002001929 --------------------------> 01-04-2024 16:42:02:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 16:42:02:ConfirmationReq CBS A/C No : 001002001929 01-04-2024 16:42:02:ConfirmationReq A/C No 2: 001002001929 01-04-2024 16:42:02:Connection Establisment started 01-04-2024 16:42:02:Connection Read From File : Status OK 01-04-2024 16:42:02:Connection Successfully Opened : Status OK 01-04-2024 16:42:02:ValidateAcNo CBS A/C No : 001002001929 01-04-2024 16:42:02:ValidateAcNo CBS A/C No 2: 001002001929 01-04-2024 16:42:02:ShowCBSAcNo CBS A/C No : 001002001929 01-04-2024 16:42:02:ShowCBSAcNo CBS A/C No 2: 001002001929 01-04-2024 16:42:02:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 16:42:02:Record Count : 1 01-04-2024 16:42:02:BRLENGTH 3 01-04-2024 16:42:02:SCHLENGTH 3 01-04-2024 16:42:02:ACLENGTH 6 01-04-2024 16:42:02:Branch Code 3 01-04-2024 16:42:02:Scheme Code 3 01-04-2024 16:42:02:Account No 3 01-04-2024 16:42:02:Link Main Started 01-04-2024 16:42:02:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 01-04-2024 16:42:02:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 16:42:02:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001929|CA |001 01-04-2024 16:42:02:A/c no length validation qry --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG FROM clientmaster,depositmaster where CLMS_SNO=DEPM_CLIENT and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='CA' AND DEPM_NO=001929 union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG FROM clientmaster,LOANMASTER where CLMS_SNO=LOAM_CLIENT and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='CA' AND LOAM_NO=001929 UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG FROM clientmaster,ODMASTER where CLMS_SNO=ODMT_CLIENT and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='CA' AND ODMT_NO=001929 01-04-2024 16:42:02:Validation Account Proce Executed with out error Y 01-04-2024 16:42:02:Connection Establisment started 01-04-2024 16:42:02:Connection Read From File : Status OK 01-04-2024 16:42:02:Connection Successfully Opened : Status OK 01-04-2024 16:42:02:Inward_process CBS A/C No : 001002001929 01-04-2024 16:42:02:Inward_processCBS A/C No : 001002001929 01-04-2024 16:42:02:ShowCBSAcNo CBS A/C No : 001002001929 01-04-2024 16:42:02:ShowCBSAcNo CBS A/C No 2: 001002001929 01-04-2024 16:42:02:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 16:42:02:Record Count : 1 01-04-2024 16:42:02:BRLENGTH 3 01-04-2024 16:42:02:SCHLENGTH 3 01-04-2024 16:42:02:ACLENGTH 6 01-04-2024 16:42:02:Branch Code 3 01-04-2024 16:42:02:Scheme Code 3 01-04-2024 16:42:02:Account No 3 01-04-2024 16:42:02:Link Main Started 01-04-2024 16:42:02:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 01-04-2024 16:42:02:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 16:42:02:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001929|CA |001 01-04-2024 16:42:02:Vno --->:142491 01-04-2024 16:42:02:Current Date --->:01-04-2024 01-04-2024 16:42:02:calling CallNewRtgsBothProc 01-04-2024 16:42:02:Parameters passing - InwardAuthorise 01-04-2024 16:42:02: brn =001 01-04-2024 16:42:02: acno =001929 01-04-2024 16:42:02: abbr =CA 01-04-2024 16:42:02: amt.ToString() =509529 01-04-2024 16:42:02: traceNo =142491 01-04-2024 16:42:02: narr =RTGS, BY SUJIT KUMAR PIRI SHASWATI DAS ICIC0000047 004701027605 01-04-2024 16:42:02:Transaction Process : BEFORE CAL PROC: 01-04-2024 16:42:02:cbs no--->001002001929 01-04-2024 16:42:02:ShowCBSAcNo CBS A/C No : 001002001929 01-04-2024 16:42:02:ShowCBSAcNo CBS A/C No 2: 001002001929 01-04-2024 16:42:02:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 16:42:02:Record Count : 1 01-04-2024 16:42:02:BRLENGTH 3 01-04-2024 16:42:02:SCHLENGTH 3 01-04-2024 16:42:02:ACLENGTH 6 01-04-2024 16:42:02:Branch Code 3 01-04-2024 16:42:02:Scheme Code 3 01-04-2024 16:42:02:Account No 3 01-04-2024 16:42:02:Link Main Started 01-04-2024 16:42:02:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 01-04-2024 16:42:02:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 16:42:02:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001929|CA |001 01-04-2024 16:42:02:Closed YN quier --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG,DSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,depositmaster,depositschemesetup,ADDRESS where CLMS_SNO=DEPM_CLIENT AND DSCH_BRANCH = DEPM_BRANCH AND DSCH_ABBR = DEPM_ABBR and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='CA' AND DEPM_NO=001929 AND ADDR_SNO=CLMS_ADDRESS union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG,LSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,LOANMASTER,LOANSCHEMESETUP,ADDRESS where CLMS_SNO=LOAM_CLIENT AND LSCH_BRANCH = LOAM_BRANCH AND LSCH_ABBREV = LOAM_ABBR and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='CA' AND LOAM_NO=001929 AND ADDR_SNO=CLMS_ADDRESS UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG,ODST_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,ODMASTER,ODSCHEMESETUP,ADDRESS where CLMS_SNO=ODMT_CLIENT AND ODST_BRANCH = ODMT_BRANCH AND ODST_ABBR = ODMT_ABBR and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='CA' AND ODMT_NO=001929 AND ADDR_SNO=CLMS_ADDRESS 01-04-2024 16:42:02:closed y n Record count --->1 01-04-2024 16:42:02:CBS A/C FOR SMS PUSH : XXXXXX001929 01-04-2024 16:42:05:SMS Inserted for Mobile Number : +918217399314 01-04-2024 16:42:06:Inward Process Executed Sussefully 01-04-2024 16:42:06:ConfirmationReq Execution Success with Status 000 01-04-2024 16:42:06:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : ICICR12024040102159797|001002001929 ------------------------------> 01-04-2024 16:42:06:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 17:39:59:<------------------------Started ValidationRequest CBS A/C No : 001001011928 ------------------------> 01-04-2024 17:39:59:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 17:39:59:Connection Establisment started 01-04-2024 17:39:59:Connection Read From File : Status OK 01-04-2024 17:39:59:Connection Successfully Opened : Status OK 01-04-2024 17:39:59:ValidateAcNo CBS A/C No : 001001011928 01-04-2024 17:39:59:ValidateAcNo CBS A/C No 2: 001001011928 01-04-2024 17:39:59:ShowCBSAcNo CBS A/C No : 001001011928 01-04-2024 17:39:59:ShowCBSAcNo CBS A/C No 2: 001001011928 01-04-2024 17:39:59:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 17:39:59:Record Count : 1 01-04-2024 17:39:59:BRLENGTH 3 01-04-2024 17:39:59:SCHLENGTH 3 01-04-2024 17:39:59:ACLENGTH 6 01-04-2024 17:39:59:Branch Code 3 01-04-2024 17:39:59:Scheme Code 3 01-04-2024 17:39:59:Account No 3 01-04-2024 17:39:59:Link Main Started 01-04-2024 17:39:59:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 01-04-2024 17:39:59:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 17:39:59:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|011928|SB |001 01-04-2024 17:39:59:A/c no length validation qry --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG FROM clientmaster,depositmaster where CLMS_SNO=DEPM_CLIENT and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB' AND DEPM_NO=011928 union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG FROM clientmaster,LOANMASTER where CLMS_SNO=LOAM_CLIENT and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='SB' AND LOAM_NO=011928 UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG FROM clientmaster,ODMASTER where CLMS_SNO=ODMT_CLIENT and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='SB' AND ODMT_NO=011928 01-04-2024 17:39:59:Validation Account Proce Executed with out error Y 01-04-2024 17:39:59:ValidationRequest Exccution Success with response : 000 01-04-2024 17:39:59:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 17:40:10:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : HS92409238527536|001001011928 --------------------------> 01-04-2024 17:40:10:<------------------------------------------------------------------------------------------------------------------------> 01-04-2024 17:40:10:ConfirmationReq CBS A/C No : 001001011928 01-04-2024 17:40:10:ConfirmationReq A/C No 2: 001001011928 01-04-2024 17:40:10:Connection Establisment started 01-04-2024 17:40:10:Connection Read From File : Status OK 01-04-2024 17:40:10:Connection Successfully Opened : Status OK 01-04-2024 17:40:10:ValidateAcNo CBS A/C No : 001001011928 01-04-2024 17:40:10:ValidateAcNo CBS A/C No 2: 001001011928 01-04-2024 17:40:10:ShowCBSAcNo CBS A/C No : 001001011928 01-04-2024 17:40:10:ShowCBSAcNo CBS A/C No 2: 001001011928 01-04-2024 17:40:10:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 17:40:10:Record Count : 1 01-04-2024 17:40:10:BRLENGTH 3 01-04-2024 17:40:10:SCHLENGTH 3 01-04-2024 17:40:10:ACLENGTH 6 01-04-2024 17:40:10:Branch Code 3 01-04-2024 17:40:10:Scheme Code 3 01-04-2024 17:40:10:Account No 3 01-04-2024 17:40:10:Link Main Started 01-04-2024 17:40:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 01-04-2024 17:40:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 17:40:10:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|011928|SB |001 01-04-2024 17:40:10:A/c no length validation qry --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG FROM clientmaster,depositmaster where CLMS_SNO=DEPM_CLIENT and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB' AND DEPM_NO=011928 union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG FROM clientmaster,LOANMASTER where CLMS_SNO=LOAM_CLIENT and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='SB' AND LOAM_NO=011928 UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG FROM clientmaster,ODMASTER where CLMS_SNO=ODMT_CLIENT and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='SB' AND ODMT_NO=011928 01-04-2024 17:40:10:Validation Account Proce Executed with out error Y 01-04-2024 17:40:10:Connection Establisment started 01-04-2024 17:40:10:Connection Read From File : Status OK 01-04-2024 17:40:10:Connection Successfully Opened : Status OK 01-04-2024 17:40:10:Inward_process CBS A/C No : 001001011928 01-04-2024 17:40:10:Inward_processCBS A/C No : 001001011928 01-04-2024 17:40:10:ShowCBSAcNo CBS A/C No : 001001011928 01-04-2024 17:40:10:ShowCBSAcNo CBS A/C No 2: 001001011928 01-04-2024 17:40:10:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 17:40:10:Record Count : 1 01-04-2024 17:40:10:BRLENGTH 3 01-04-2024 17:40:10:SCHLENGTH 3 01-04-2024 17:40:10:ACLENGTH 6 01-04-2024 17:40:10:Branch Code 3 01-04-2024 17:40:10:Scheme Code 3 01-04-2024 17:40:10:Account No 3 01-04-2024 17:40:10:Link Main Started 01-04-2024 17:40:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 01-04-2024 17:40:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 17:40:10:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|011928|SB |001 01-04-2024 17:40:10:Vno --->:142492 01-04-2024 17:40:10:Current Date --->:01-04-2024 01-04-2024 17:40:10:calling CallNewRtgsBothProc 01-04-2024 17:40:10:Parameters passing - InwardAuthorise 01-04-2024 17:40:10: brn =001 01-04-2024 17:40:10: acno =011928 01-04-2024 17:40:10: abbr =SB 01-04-2024 17:40:10: amt.ToString() =17205 01-04-2024 17:40:10: traceNo =142492 01-04-2024 17:40:10: narr =NEFT, BY SARANYAARRUCHAMY ICIC0SF0002 034201529643 01-04-2024 17:40:10:Transaction Process : BEFORE CAL PROC: 01-04-2024 17:40:10:cbs no--->001001011928 01-04-2024 17:40:10:ShowCBSAcNo CBS A/C No : 001001011928 01-04-2024 17:40:10:ShowCBSAcNo CBS A/C No 2: 001001011928 01-04-2024 17:40:10:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 01-04-2024 17:40:10:Record Count : 1 01-04-2024 17:40:10:BRLENGTH 3 01-04-2024 17:40:10:SCHLENGTH 3 01-04-2024 17:40:10:ACLENGTH 6 01-04-2024 17:40:10:Branch Code 3 01-04-2024 17:40:10:Scheme Code 3 01-04-2024 17:40:10:Account No 3 01-04-2024 17:40:10:Link Main Started 01-04-2024 17:40:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 01-04-2024 17:40:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 01-04-2024 17:40:10:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|011928|SB |001 01-04-2024 17:40:10:Closed YN quier --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG,DSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,depositmaster,depositschemesetup,ADDRESS where CLMS_SNO=DEPM_CLIENT AND DSCH_BRANCH = DEPM_BRANCH AND DSCH_ABBR = DEPM_ABBR and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB' AND DEPM_NO=011928 AND ADDR_SNO=CLMS_ADDRESS union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG,LSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,LOANMASTER,LOANSCHEMESETUP,ADDRESS where CLMS_SNO=LOAM_CLIENT AND LSCH_BRANCH = LOAM_BRANCH AND LSCH_ABBREV = LOAM_ABBR and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='SB' AND LOAM_NO=011928 AND ADDR_SNO=CLMS_ADDRESS UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG,ODST_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,ODMASTER,ODSCHEMESETUP,ADDRESS where CLMS_SNO=ODMT_CLIENT AND ODST_BRANCH = ODMT_BRANCH AND ODST_ABBR = ODMT_ABBR and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='SB' AND ODMT_NO=011928 AND ADDR_SNO=CLMS_ADDRESS 01-04-2024 17:40:10:closed y n Record count --->1 01-04-2024 17:40:10:CBS A/C FOR SMS PUSH : XXXXXX011928 01-04-2024 17:40:11:SMS Inserted for Mobile Number : +919901235558 01-04-2024 17:40:11:Inward Process Executed Sussefully 01-04-2024 17:40:11:ConfirmationReq Execution Success with Status 000 01-04-2024 17:40:11:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : HS92409238527536|001001011928 ------------------------------> 01-04-2024 17:40:11:<------------------------------------------------------------------------------------------------------------------------>