08-07-2025 13:58:44:<------------------------Started ValidationRequest CBS A/C No : 001002000895 ------------------------> 08-07-2025 13:58:44:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 13:58:44:Connection Establisment started 08-07-2025 13:58:44:Connection Read From File : Status OK 08-07-2025 13:58:45:Connection Successfully Opened : Status OK 08-07-2025 13:58:45:ValidateAcNo CBS A/C No : 001002000895 08-07-2025 13:58:45:CBS A/C No : 001002000895 08-07-2025 13:58: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 08-07-2025 13:58:45:Record Count : 1 08-07-2025 13:58:45:BRLENGTH 3 08-07-2025 13:58:45:SCHLENGTH 3 08-07-2025 13:58:45:ACLENGTH 6 08-07-2025 13:58:45:Branch Code 3 08-07-2025 13:58:45:Scheme Code 3 08-07-2025 13:58:45:Account No 3 08-07-2025 13:58:45:Link Main Started 08-07-2025 13:58:45:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 08-07-2025 13:58:45:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 13:58:45:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000895|CD |001 08-07-2025 13:58:45:Validation Account Proce Executed with out error Y 08-07-2025 13:58:45:ValidationRequest Exccution Success with response : 000 08-07-2025 13:58:45:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 14:02:27:<------------------------Started ValidationRequest CBS A/C No : 001001012279 ------------------------> 08-07-2025 14:02:27:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 14:02:27:Connection Establisment started 08-07-2025 14:02:27:Connection Read From File : Status OK 08-07-2025 14:02:27:Connection Successfully Opened : Status OK 08-07-2025 14:02:27:ValidateAcNo CBS A/C No : 001001012279 08-07-2025 14:02:27:CBS A/C No : 001001012279 08-07-2025 14:02: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 08-07-2025 14:02:27:Record Count : 1 08-07-2025 14:02:27:BRLENGTH 3 08-07-2025 14:02:27:SCHLENGTH 3 08-07-2025 14:02:27:ACLENGTH 6 08-07-2025 14:02:27:Branch Code 3 08-07-2025 14:02:27:Scheme Code 3 08-07-2025 14:02:27:Account No 3 08-07-2025 14:02:27:Link Main Started 08-07-2025 14:02:27:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 14:02:27:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 14:02:27:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|012279|SB |001 08-07-2025 14:02:27:Validation Account Proce Executed with out error Y 08-07-2025 14:02:27:ValidationRequest Exccution Success with response : 000 08-07-2025 14:02:27:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 14:25:31:<------------------------Started ValidationRequest CBS A/C No : 001001002975 ------------------------> 08-07-2025 14:25:31:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 14:25:31:Connection Establisment started 08-07-2025 14:25:31:Connection Read From File : Status OK 08-07-2025 14:25:31:Connection Successfully Opened : Status OK 08-07-2025 14:25:31:ValidateAcNo CBS A/C No : 001001002975 08-07-2025 14:25:31:CBS A/C No : 001001002975 08-07-2025 14:25:31: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 08-07-2025 14:25:31:Record Count : 1 08-07-2025 14:25:31:BRLENGTH 3 08-07-2025 14:25:31:SCHLENGTH 3 08-07-2025 14:25:31:ACLENGTH 6 08-07-2025 14:25:31:Branch Code 3 08-07-2025 14:25:31:Scheme Code 3 08-07-2025 14:25:31:Account No 3 08-07-2025 14:25:31:Link Main Started 08-07-2025 14:25:31:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 14:25:31:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 14:25:31:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|002975|SB |001 08-07-2025 14:25:31:Validation Account Proce Executed with out error Y 08-07-2025 14:25:31:ValidationRequest Exccution Success with response : 000 08-07-2025 14:25:31:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 14:44:57:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : BDBLR62025070819437951|001002000895 --------------------------> 08-07-2025 14:44:57:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 14:44:57:Connection Establisment started 08-07-2025 14:44:57:Connection Read From File : Status OK 08-07-2025 14:44:57:Connection Successfully Opened : Status OK 08-07-2025 14:44:57:ValidateAcNo CBS A/C No : 001002000895 08-07-2025 14:44:57:CBS A/C No : 001002000895 08-07-2025 14:44:57: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 08-07-2025 14:44:57:Record Count : 1 08-07-2025 14:44:57:BRLENGTH 3 08-07-2025 14:44:57:SCHLENGTH 3 08-07-2025 14:44:57:ACLENGTH 6 08-07-2025 14:44:57:Branch Code 3 08-07-2025 14:44:57:Scheme Code 3 08-07-2025 14:44:57:Account No 3 08-07-2025 14:44:57:Link Main Started 08-07-2025 14:44:57:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 08-07-2025 14:44:57:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 14:44:57:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000895|CD |001 08-07-2025 14:44:57:Validation Account Proce Executed with out error Y 08-07-2025 14:44:57:Connection Establisment started 08-07-2025 14:44:57:Connection Read From File : Status OK 08-07-2025 14:44:57:Connection Successfully Opened : Status OK 08-07-2025 14:44:57:CBS A/C No : 001002000895 08-07-2025 14:44:57: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 08-07-2025 14:44:57:Record Count : 1 08-07-2025 14:44:57:BRLENGTH 3 08-07-2025 14:44:57:SCHLENGTH 3 08-07-2025 14:44:57:ACLENGTH 6 08-07-2025 14:44:57:Branch Code 3 08-07-2025 14:44:57:Scheme Code 3 08-07-2025 14:44:57:Account No 3 08-07-2025 14:44:57:Link Main Started 08-07-2025 14:44:57:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 08-07-2025 14:44:57:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 14:44:57:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000895|CD |001 08-07-2025 14:44:57:Vno --->:69535 08-07-2025 14:44:57:Current Date --->:08-07-2025 08-07-2025 14:44:57:calling CallNewRtgsBothProc 08-07-2025 14:44:57:Parameters passing - InwardAuthorise 08-07-2025 14:44:57: brn =001 08-07-2025 14:44:57: acno =000895 08-07-2025 14:44:57: abbr =CD 08-07-2025 14:44:57: amt.ToString() =500000 08-07-2025 14:44:57: traceNo =69535 08-07-2025 14:44:57: narr =RTGS, BY MSSEEDCROPGENETICS BDBL0002541 20100031885023 08-07-2025 14:44:57:Transaction Process : BEFORE CAL PROC: 08-07-2025 14:44:57:cbs no--->001002000895 08-07-2025 14:44:57:CBS A/C No : 001002000895 08-07-2025 14:44:57: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 08-07-2025 14:44:57:Record Count : 1 08-07-2025 14:44:57:BRLENGTH 3 08-07-2025 14:44:57:SCHLENGTH 3 08-07-2025 14:44:57:ACLENGTH 6 08-07-2025 14:44:57:Branch Code 3 08-07-2025 14:44:57:Scheme Code 3 08-07-2025 14:44:57:Account No 3 08-07-2025 14:44:57:Link Main Started 08-07-2025 14:44:57:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 08-07-2025 14:44:57:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 14:44:57:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000895|CD |001 08-07-2025 14:44:57: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)='CD' AND DEPM_NO=000895 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)='CD' AND LOAM_NO=000895 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)='CD' AND ODMT_NO=000895 AND ADDR_SNO=CLMS_ADDRESS 08-07-2025 14:44:57:closed y n Record count --->1 08-07-2025 14:44:57:SMS Inserted for Mobile Number : +919972536615 08-07-2025 14:44:57:Inward Process Executed Sussefully 08-07-2025 14:44:57:ConfirmationReq Execution Success with Status 000 08-07-2025 14:44:57:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : BDBLR62025070819437951|001002000895 ------------------------------> 08-07-2025 14:44:57:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 14:57:32:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : PUNBH70009935018|001001012279 --------------------------> 08-07-2025 14:57:32:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 14:57:32:Connection Establisment started 08-07-2025 14:57:32:Connection Read From File : Status OK 08-07-2025 14:57:32:Connection Successfully Opened : Status OK 08-07-2025 14:57:32:ValidateAcNo CBS A/C No : 001001012279 08-07-2025 14:57:32:CBS A/C No : 001001012279 08-07-2025 14:57:32: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 08-07-2025 14:57:32:Record Count : 1 08-07-2025 14:57:32:BRLENGTH 3 08-07-2025 14:57:32:SCHLENGTH 3 08-07-2025 14:57:32:ACLENGTH 6 08-07-2025 14:57:32:Branch Code 3 08-07-2025 14:57:32:Scheme Code 3 08-07-2025 14:57:32:Account No 3 08-07-2025 14:57:32:Link Main Started 08-07-2025 14:57:32:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 14:57:32:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 14:57:32:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|012279|SB |001 08-07-2025 14:57:32:Validation Account Proce Executed with out error Y 08-07-2025 14:57:32:Connection Establisment started 08-07-2025 14:57:32:Connection Read From File : Status OK 08-07-2025 14:57:32:Connection Successfully Opened : Status OK 08-07-2025 14:57:32:CBS A/C No : 001001012279 08-07-2025 14:57:32: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 08-07-2025 14:57:32:Record Count : 1 08-07-2025 14:57:32:BRLENGTH 3 08-07-2025 14:57:32:SCHLENGTH 3 08-07-2025 14:57:32:ACLENGTH 6 08-07-2025 14:57:32:Branch Code 3 08-07-2025 14:57:32:Scheme Code 3 08-07-2025 14:57:32:Account No 3 08-07-2025 14:57:32:Link Main Started 08-07-2025 14:57:32:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 14:57:32:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 14:57:32:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|012279|SB |001 08-07-2025 14:57:32:Vno --->:69536 08-07-2025 14:57:32:Current Date --->:08-07-2025 08-07-2025 14:57:32:calling CallNewRtgsBothProc 08-07-2025 14:57:32:Parameters passing - InwardAuthorise 08-07-2025 14:57:32: brn =001 08-07-2025 14:57:32: acno =012279 08-07-2025 14:57:32: abbr =SB 08-07-2025 14:57:32: amt.ToString() =14400 08-07-2025 14:57:32: traceNo =69536 08-07-2025 14:57:32: narr =NEFT, BY AUSKIN CARE PUNB0449400 1910002100019972 08-07-2025 14:57:32:Transaction Process : BEFORE CAL PROC: 08-07-2025 14:57:32:cbs no--->001001012279 08-07-2025 14:57:32:CBS A/C No : 001001012279 08-07-2025 14:57:32: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 08-07-2025 14:57:32:Record Count : 1 08-07-2025 14:57:32:BRLENGTH 3 08-07-2025 14:57:32:SCHLENGTH 3 08-07-2025 14:57:32:ACLENGTH 6 08-07-2025 14:57:32:Branch Code 3 08-07-2025 14:57:32:Scheme Code 3 08-07-2025 14:57:32:Account No 3 08-07-2025 14:57:32:Link Main Started 08-07-2025 14:57:32:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 14:57:32:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 14:57:32:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|012279|SB |001 08-07-2025 14:57:32: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=012279 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=012279 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=012279 AND ADDR_SNO=CLMS_ADDRESS 08-07-2025 14:57:32:closed y n Record count --->1 08-07-2025 14:57:32:SMS Inserted for Mobile Number : +919742420563 08-07-2025 14:57:32:Inward Process Executed Sussefully 08-07-2025 14:57:32:ConfirmationReq Execution Success with Status 000 08-07-2025 14:57:32:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : PUNBH70009935018|001001012279 ------------------------------> 08-07-2025 14:57:32:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 15:05:31:<------------------------Started ValidationRequest CBS A/C No : 001001012956 ------------------------> 08-07-2025 15:05:31:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 15:05:31:Connection Establisment started 08-07-2025 15:05:31:Connection Read From File : Status OK 08-07-2025 15:05:31:Connection Successfully Opened : Status OK 08-07-2025 15:05:31:ValidateAcNo CBS A/C No : 001001012956 08-07-2025 15:05:31:CBS A/C No : 001001012956 08-07-2025 15:05:31: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 08-07-2025 15:05:31:Record Count : 1 08-07-2025 15:05:31:BRLENGTH 3 08-07-2025 15:05:31:SCHLENGTH 3 08-07-2025 15:05:31:ACLENGTH 6 08-07-2025 15:05:31:Branch Code 3 08-07-2025 15:05:31:Scheme Code 3 08-07-2025 15:05:31:Account No 3 08-07-2025 15:05:31:Link Main Started 08-07-2025 15:05:31:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 15:05:31:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 15:05:31:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|012956|SB |001 08-07-2025 15:05:31:Validation Account Proce Executed with out error Y 08-07-2025 15:05:31:ValidationRequest Exccution Success with response : 000 08-07-2025 15:05:31:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 15:05:31:<------------------------Started ValidationRequest CBS A/C No : 001001001118 ------------------------> 08-07-2025 15:05:31:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 15:05:31:Connection Establisment started 08-07-2025 15:05:31:Connection Read From File : Status OK 08-07-2025 15:05:31:Connection Successfully Opened : Status OK 08-07-2025 15:05:31:ValidateAcNo CBS A/C No : 001001001118 08-07-2025 15:05:31:CBS A/C No : 001001001118 08-07-2025 15:05:31: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 08-07-2025 15:05:31:Record Count : 1 08-07-2025 15:05:31:BRLENGTH 3 08-07-2025 15:05:31:SCHLENGTH 3 08-07-2025 15:05:31:ACLENGTH 6 08-07-2025 15:05:31:Branch Code 3 08-07-2025 15:05:31:Scheme Code 3 08-07-2025 15:05:31:Account No 3 08-07-2025 15:05:31:Link Main Started 08-07-2025 15:05:31:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 15:05:31:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 15:05:31:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001118|SB |001 08-07-2025 15:05:31:Validation Account Proce Executed with out error Y 08-07-2025 15:05:31:ValidationRequest Exccution Success with response : 000 08-07-2025 15:05:31:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 15:05:31:<------------------------Started ValidationRequest CBS A/C No : 001001009761 ------------------------> 08-07-2025 15:05:31:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 15:05:31:Connection Establisment started 08-07-2025 15:05:31:Connection Read From File : Status OK 08-07-2025 15:05:31:Connection Successfully Opened : Status OK 08-07-2025 15:05:31:ValidateAcNo CBS A/C No : 001001009761 08-07-2025 15:05:31:CBS A/C No : 001001009761 08-07-2025 15:05:31: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 08-07-2025 15:05:31:Record Count : 1 08-07-2025 15:05:31:BRLENGTH 3 08-07-2025 15:05:31:SCHLENGTH 3 08-07-2025 15:05:31:ACLENGTH 6 08-07-2025 15:05:31:Branch Code 3 08-07-2025 15:05:31:Scheme Code 3 08-07-2025 15:05:31:Account No 3 08-07-2025 15:05:31:Link Main Started 08-07-2025 15:05:31:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 15:05:31:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 15:05:31:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|009761|SB |001 08-07-2025 15:05:31:Validation Account Proce Executed with out error Y 08-07-2025 15:05:31:ValidationRequest Exccution Success with response : 000 08-07-2025 15:05:31:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 15:08:55:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : HDFCH00351656473|001001002975 --------------------------> 08-07-2025 15:08:55:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 15:08:55:Connection Establisment started 08-07-2025 15:08:55:Connection Read From File : Status OK 08-07-2025 15:08:55:Connection Successfully Opened : Status OK 08-07-2025 15:08:55:ValidateAcNo CBS A/C No : 001001002975 08-07-2025 15:08:55:CBS A/C No : 001001002975 08-07-2025 15:08: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 08-07-2025 15:08:55:Record Count : 1 08-07-2025 15:08:55:BRLENGTH 3 08-07-2025 15:08:55:SCHLENGTH 3 08-07-2025 15:08:55:ACLENGTH 6 08-07-2025 15:08:55:Branch Code 3 08-07-2025 15:08:55:Scheme Code 3 08-07-2025 15:08:55:Account No 3 08-07-2025 15:08:55:Link Main Started 08-07-2025 15:08:55:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 15:08:55:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 15:08:55:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|002975|SB |001 08-07-2025 15:08:55:Validation Account Proce Executed with out error Y 08-07-2025 15:08:55:Connection Establisment started 08-07-2025 15:08:55:Connection Read From File : Status OK 08-07-2025 15:08:55:Connection Successfully Opened : Status OK 08-07-2025 15:08:55:CBS A/C No : 001001002975 08-07-2025 15:08: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 08-07-2025 15:08:55:Record Count : 1 08-07-2025 15:08:55:BRLENGTH 3 08-07-2025 15:08:55:SCHLENGTH 3 08-07-2025 15:08:55:ACLENGTH 6 08-07-2025 15:08:55:Branch Code 3 08-07-2025 15:08:55:Scheme Code 3 08-07-2025 15:08:55:Account No 3 08-07-2025 15:08:55:Link Main Started 08-07-2025 15:08:55:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 15:08:55:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 15:08:55:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|002975|SB |001 08-07-2025 15:08:55:Vno --->:69537 08-07-2025 15:08:55:Current Date --->:08-07-2025 08-07-2025 15:08:55:calling CallNewRtgsBothProc 08-07-2025 15:08:55:Parameters passing - InwardAuthorise 08-07-2025 15:08:55: brn =001 08-07-2025 15:08:55: acno =002975 08-07-2025 15:08:55: abbr =SB 08-07-2025 15:08:55: amt.ToString() =16500 08-07-2025 15:08:55: traceNo =69537 08-07-2025 15:08:55: narr =NEFT, BY INDUS TOWERS LIMITED IPA A/C104 HDFC0000240 00030310009104 08-07-2025 15:08:55:Transaction Process : BEFORE CAL PROC: 08-07-2025 15:08:55:cbs no--->001001002975 08-07-2025 15:08:55:CBS A/C No : 001001002975 08-07-2025 15:08: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 08-07-2025 15:08:55:Record Count : 1 08-07-2025 15:08:55:BRLENGTH 3 08-07-2025 15:08:55:SCHLENGTH 3 08-07-2025 15:08:55:ACLENGTH 6 08-07-2025 15:08:55:Branch Code 3 08-07-2025 15:08:55:Scheme Code 3 08-07-2025 15:08:55:Account No 3 08-07-2025 15:08:55:Link Main Started 08-07-2025 15:08:55:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 15:08:55:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 15:08:55:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|002975|SB |001 08-07-2025 15:08:55: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=002975 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=002975 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=002975 AND ADDR_SNO=CLMS_ADDRESS 08-07-2025 15:08:55:closed y n Record count --->1 08-07-2025 15:08:55:SMS Inserted for Mobile Number : +919448801245 08-07-2025 15:08:55:Inward Process Executed Sussefully 08-07-2025 15:08:55:ConfirmationReq Execution Success with Status 000 08-07-2025 15:08:55:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : HDFCH00351656473|001001002975 ------------------------------> 08-07-2025 15:08:55:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 15:27:16:<------------------------Started ValidationRequest CBS A/C No : 001002000868 ------------------------> 08-07-2025 15:27:16:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 15:27:16:Connection Establisment started 08-07-2025 15:27:16:Connection Read From File : Status OK 08-07-2025 15:27:16:Connection Successfully Opened : Status OK 08-07-2025 15:27:16:ValidateAcNo CBS A/C No : 001002000868 08-07-2025 15:27:16:CBS A/C No : 001002000868 08-07-2025 15:27: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 08-07-2025 15:27:16:Record Count : 1 08-07-2025 15:27:16:BRLENGTH 3 08-07-2025 15:27:16:SCHLENGTH 3 08-07-2025 15:27:16:ACLENGTH 6 08-07-2025 15:27:16:Branch Code 3 08-07-2025 15:27:16:Scheme Code 3 08-07-2025 15:27:16:Account No 3 08-07-2025 15:27:16:Link Main Started 08-07-2025 15:27:16:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 08-07-2025 15:27:16:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 15:27:16:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000868|CD |001 08-07-2025 15:27:16:Validation Account Proce Executed with out error Y 08-07-2025 15:27:16:ValidationRequest Exccution Success with response : 000 08-07-2025 15:27:16:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 15:27:45:<------------------------Started ValidationRequest CBS A/C No : 001002000868 ------------------------> 08-07-2025 15:27:45:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 15:27:45:Connection Establisment started 08-07-2025 15:27:45:Connection Read From File : Status OK 08-07-2025 15:27:45:Connection Successfully Opened : Status OK 08-07-2025 15:27:45:ValidateAcNo CBS A/C No : 001002000868 08-07-2025 15:27:45:CBS A/C No : 001002000868 08-07-2025 15:27: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 08-07-2025 15:27:45:Record Count : 1 08-07-2025 15:27:45:BRLENGTH 3 08-07-2025 15:27:45:SCHLENGTH 3 08-07-2025 15:27:45:ACLENGTH 6 08-07-2025 15:27:45:Branch Code 3 08-07-2025 15:27:45:Scheme Code 3 08-07-2025 15:27:45:Account No 3 08-07-2025 15:27:45:Link Main Started 08-07-2025 15:27:45:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 08-07-2025 15:27:45:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 15:27:45:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000868|CD |001 08-07-2025 15:27:45:Validation Account Proce Executed with out error Y 08-07-2025 15:27:45:ValidationRequest Exccution Success with response : 000 08-07-2025 15:27:45:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 15:27:54:<------------------------Started ValidationRequest CBS A/C No : 001002000868 ------------------------> 08-07-2025 15:27:54:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 15:27:54:Connection Establisment started 08-07-2025 15:27:54:Connection Read From File : Status OK 08-07-2025 15:27:54:Connection Successfully Opened : Status OK 08-07-2025 15:27:54:ValidateAcNo CBS A/C No : 001002000868 08-07-2025 15:27:54:CBS A/C No : 001002000868 08-07-2025 15:27:54: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 08-07-2025 15:27:54:Record Count : 1 08-07-2025 15:27:54:BRLENGTH 3 08-07-2025 15:27:54:SCHLENGTH 3 08-07-2025 15:27:54:ACLENGTH 6 08-07-2025 15:27:54:Branch Code 3 08-07-2025 15:27:54:Scheme Code 3 08-07-2025 15:27:54:Account No 3 08-07-2025 15:27:54:Link Main Started 08-07-2025 15:27:54:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 08-07-2025 15:27:54:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 15:27:54:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000868|CD |001 08-07-2025 15:27:54:Validation Account Proce Executed with out error Y 08-07-2025 15:27:54:ValidationRequest Exccution Success with response : 000 08-07-2025 15:27:54:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 15:48:35:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM18940924723|001001001118 --------------------------> 08-07-2025 15:48:35:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 15:48:35:Connection Establisment started 08-07-2025 15:48:35:Connection Read From File : Status OK 08-07-2025 15:48:35:Connection Successfully Opened : Status OK 08-07-2025 15:48:35:ValidateAcNo CBS A/C No : 001001001118 08-07-2025 15:48:35:CBS A/C No : 001001001118 08-07-2025 15:48:35: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 08-07-2025 15:48:35:Record Count : 1 08-07-2025 15:48:35:BRLENGTH 3 08-07-2025 15:48:35:SCHLENGTH 3 08-07-2025 15:48:35:ACLENGTH 6 08-07-2025 15:48:35:Branch Code 3 08-07-2025 15:48:35:Scheme Code 3 08-07-2025 15:48:35:Account No 3 08-07-2025 15:48:35:Link Main Started 08-07-2025 15:48:35:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 15:48:35:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 15:48:35:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001118|SB |001 08-07-2025 15:48:36:Validation Account Proce Executed with out error Y 08-07-2025 15:48:36:Connection Establisment started 08-07-2025 15:48:36:Connection Read From File : Status OK 08-07-2025 15:48:36:Connection Successfully Opened : Status OK 08-07-2025 15:48:36:CBS A/C No : 001001001118 08-07-2025 15:48:36: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 08-07-2025 15:48:36:Record Count : 1 08-07-2025 15:48:36:BRLENGTH 3 08-07-2025 15:48:36:SCHLENGTH 3 08-07-2025 15:48:36:ACLENGTH 6 08-07-2025 15:48:36:Branch Code 3 08-07-2025 15:48:36:Scheme Code 3 08-07-2025 15:48:36:Account No 3 08-07-2025 15:48:36:Link Main Started 08-07-2025 15:48:36:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 15:48:36:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 15:48:36:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001118|SB |001 08-07-2025 15:48:36:Vno --->:69538 08-07-2025 15:48:36:Current Date --->:08-07-2025 08-07-2025 15:48:36:calling CallNewRtgsBothProc 08-07-2025 15:48:36:Parameters passing - InwardAuthorise 08-07-2025 15:48:36: brn =001 08-07-2025 15:48:36: acno =001118 08-07-2025 15:48:36: abbr =SB 08-07-2025 15:48:36: amt.ToString() =210 08-07-2025 15:48:36: traceNo =69538 08-07-2025 15:48:36: narr =NEFT, BY ONE 97 COMMUNICATIONS LIMITED ESCROW ACCOUNT _01 UTIB0000022 924020007330961 08-07-2025 15:48:36:Transaction Process : BEFORE CAL PROC: 08-07-2025 15:48:36:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM18940924761|001001009761 --------------------------> 08-07-2025 15:48:36:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 15:48:36:Connection Establisment started 08-07-2025 15:48:36:Connection Read From File : Status OK 08-07-2025 15:48:36:cbs no--->001001001118 08-07-2025 15:48:36:CBS A/C No : 001001001118 08-07-2025 15:48:36: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 08-07-2025 15:48:36:Record Count : 1 08-07-2025 15:48:36:BRLENGTH 3 08-07-2025 15:48:36:SCHLENGTH 3 08-07-2025 15:48:36:ACLENGTH 6 08-07-2025 15:48:36:Branch Code 3 08-07-2025 15:48:36:Scheme Code 3 08-07-2025 15:48:36:Account No 3 08-07-2025 15:48:36:Link Main Started 08-07-2025 15:48:36:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 15:48:36:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM18940924732|001001012956 --------------------------> 08-07-2025 15:48:36:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 15:48:36:Connection Establisment started 08-07-2025 15:48:36:Connection Read From File : Status OK 08-07-2025 15:48:36:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 15:48:36:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001118|SB |001 08-07-2025 15:48:36: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=001118 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=001118 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=001118 AND ADDR_SNO=CLMS_ADDRESS 08-07-2025 15:48:36:closed y n Record count --->1 08-07-2025 15:48:36:Connection Successfully Opened : Status OK 08-07-2025 15:48:36:ValidateAcNo CBS A/C No : 001001009761 08-07-2025 15:48:36:CBS A/C No : 001001009761 08-07-2025 15:48:36: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 08-07-2025 15:48:36:Record Count : 1 08-07-2025 15:48:36:BRLENGTH 3 08-07-2025 15:48:36:SCHLENGTH 3 08-07-2025 15:48:36:ACLENGTH 6 08-07-2025 15:48:36:Branch Code 3 08-07-2025 15:48:36:Scheme Code 3 08-07-2025 15:48:36:Account No 3 08-07-2025 15:48:36:Link Main Started 08-07-2025 15:48:36:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 15:48:36:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 15:48:36:SMS Inserted for Mobile Number : +919945936919 08-07-2025 15:48:36:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|009761|SB |001 08-07-2025 15:48:36:Validation Account Proce Executed with out error Y 08-07-2025 15:48:36:Connection Establisment started 08-07-2025 15:48:36:Connection Read From File : Status OK 08-07-2025 15:48:36:Connection Successfully Opened : Status OK 08-07-2025 15:48:36:CBS A/C No : 001001009761 08-07-2025 15:48:36: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 08-07-2025 15:48:36:Record Count : 1 08-07-2025 15:48:36:BRLENGTH 3 08-07-2025 15:48:36:SCHLENGTH 3 08-07-2025 15:48:36:ACLENGTH 6 08-07-2025 15:48:36:Branch Code 3 08-07-2025 15:48:36:Scheme Code 3 08-07-2025 15:48:36:Account No 3 08-07-2025 15:48:36:Link Main Started 08-07-2025 15:48:36:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 15:48:36:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 15:48:36:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|009761|SB |001 08-07-2025 15:48:36:Vno --->:69539 08-07-2025 15:48:36:Current Date --->:08-07-2025 08-07-2025 15:48:36:calling CallNewRtgsBothProc 08-07-2025 15:48:36:Parameters passing - InwardAuthorise 08-07-2025 15:48:36: brn =001 08-07-2025 15:48:36: acno =009761 08-07-2025 15:48:36: abbr =SB 08-07-2025 15:48:36: amt.ToString() =455 08-07-2025 15:48:36: traceNo =69539 08-07-2025 15:48:36: narr =NEFT, BY ONE 97 COMMUNICATIONS LIMITED ESCROW ACCOUNT _01 UTIB0000022 924020007330961 08-07-2025 15:48:36:Transaction Process : BEFORE CAL PROC: 08-07-2025 15:48:36:Inward Process Executed Sussefully 08-07-2025 15:48:36:ConfirmationReq Execution Success with Status 000 08-07-2025 15:48:36:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM18940924723|001001001118 ------------------------------> 08-07-2025 15:48:36:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 15:48:36:Connection Successfully Opened : Status OK 08-07-2025 15:48:36:ValidateAcNo CBS A/C No : 001001012956 08-07-2025 15:48:36:CBS A/C No : 001001012956 08-07-2025 15:48:36: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 08-07-2025 15:48:36:Record Count : 1 08-07-2025 15:48:36:BRLENGTH 3 08-07-2025 15:48:36:SCHLENGTH 3 08-07-2025 15:48:36:ACLENGTH 6 08-07-2025 15:48:36:Branch Code 3 08-07-2025 15:48:36:Scheme Code 3 08-07-2025 15:48:36:Account No 3 08-07-2025 15:48:36:Link Main Started 08-07-2025 15:48:36:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 15:48:36:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 15:48:36:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|012956|SB |001 08-07-2025 15:48:36:Validation Account Proce Executed with out error Y 08-07-2025 15:48:36:Connection Establisment started 08-07-2025 15:48:36:Connection Read From File : Status OK 08-07-2025 15:48:36:Connection Successfully Opened : Status OK 08-07-2025 15:48:36:CBS A/C No : 001001012956 08-07-2025 15:48:36: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 08-07-2025 15:48:36:Record Count : 1 08-07-2025 15:48:36:BRLENGTH 3 08-07-2025 15:48:36:SCHLENGTH 3 08-07-2025 15:48:36:ACLENGTH 6 08-07-2025 15:48:36:Branch Code 3 08-07-2025 15:48:36:Scheme Code 3 08-07-2025 15:48:36:Account No 3 08-07-2025 15:48:36:Link Main Started 08-07-2025 15:48:36:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 15:48:36:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 15:48:36:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|012956|SB |001 08-07-2025 15:48:36:cbs no--->001001009761 08-07-2025 15:48:36:CBS A/C No : 001001009761 08-07-2025 15:48:36: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 08-07-2025 15:48:36:Current Date --->:08-07-2025 08-07-2025 15:48:36:Record Count : 1 08-07-2025 15:48:36:BRLENGTH 3 08-07-2025 15:48:36:SCHLENGTH 3 08-07-2025 15:48:36:ACLENGTH 6 08-07-2025 15:48:36:Branch Code 3 08-07-2025 15:48:36:Scheme Code 3 08-07-2025 15:48:36:Account No 3 08-07-2025 15:48:36:Link Main Started 08-07-2025 15:48:36:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 15:48:36:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 15:48:36:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|009761|SB |001 08-07-2025 15:48:36:calling CallNewRtgsBothProc 08-07-2025 15:48:36:Parameters passing - InwardAuthorise 08-07-2025 15:48:36: brn =001 08-07-2025 15:48:36: acno =012956 08-07-2025 15:48:36: abbr =SB 08-07-2025 15:48:36: amt.ToString() =465 08-07-2025 15:48:36: traceNo =69540 08-07-2025 15:48:36: narr =NEFT, BY ONE 97 COMMUNICATIONS LIMITED ESCROW ACCOUNT _01 UTIB0000022 924020007330961 08-07-2025 15:48:36:Transaction Process : BEFORE CAL PROC: 08-07-2025 15:48:36:closed y n Record count --->1 08-07-2025 15:48:36:Inward Process Executed Sussefully 08-07-2025 15:48:36:ConfirmationReq Execution Success with Status 000 08-07-2025 15:48:36:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM18940924732|001001012956 ------------------------------> 08-07-2025 15:48:36:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 15:48:36:SMS Inserted for Mobile Number : +917899199652 08-07-2025 15:48:36:Inward Process Executed Sussefully 08-07-2025 15:48:36:ConfirmationReq Execution Success with Status 000 08-07-2025 15:48:36:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM18940924761|001001009761 ------------------------------> 08-07-2025 15:48:36:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 15:56:01:<------------------------Started ValidationRequest CBS A/C No : 001001002975 ------------------------> 08-07-2025 15:56:01:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 15:56:01:Connection Establisment started 08-07-2025 15:56:01:Connection Read From File : Status OK 08-07-2025 15:56:01:Connection Successfully Opened : Status OK 08-07-2025 15:56:01:ValidateAcNo CBS A/C No : 001001002975 08-07-2025 15:56:01:CBS A/C No : 001001002975 08-07-2025 15:56:01: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 08-07-2025 15:56:01:Record Count : 1 08-07-2025 15:56:01:BRLENGTH 3 08-07-2025 15:56:01:SCHLENGTH 3 08-07-2025 15:56:01:ACLENGTH 6 08-07-2025 15:56:01:Branch Code 3 08-07-2025 15:56:01:Scheme Code 3 08-07-2025 15:56:01:Account No 3 08-07-2025 15:56:01:Link Main Started 08-07-2025 15:56:01:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 15:56:01:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 15:56:01:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|002975|SB |001 08-07-2025 15:56:01:Validation Account Proce Executed with out error Y 08-07-2025 15:56:01:ValidationRequest Exccution Success with response : 000 08-07-2025 15:56:01:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 16:01:53:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : KARBN25189453163|001002000868 --------------------------> 08-07-2025 16:01:53:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 16:01:53:Connection Establisment started 08-07-2025 16:01:53:Connection Read From File : Status OK 08-07-2025 16:01:53:Connection Successfully Opened : Status OK 08-07-2025 16:01:53:ValidateAcNo CBS A/C No : 001002000868 08-07-2025 16:01:53:CBS A/C No : 001002000868 08-07-2025 16:01:53: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 08-07-2025 16:01:53:Record Count : 1 08-07-2025 16:01:53:BRLENGTH 3 08-07-2025 16:01:53:SCHLENGTH 3 08-07-2025 16:01:53:ACLENGTH 6 08-07-2025 16:01:53:Branch Code 3 08-07-2025 16:01:53:Scheme Code 3 08-07-2025 16:01:53:Account No 3 08-07-2025 16:01:53:Link Main Started 08-07-2025 16:01:53:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 08-07-2025 16:01:53:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 16:01:53:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000868|CD |001 08-07-2025 16:01:53:Validation Account Proce Executed with out error Y 08-07-2025 16:01:53:Connection Establisment started 08-07-2025 16:01:53:Connection Read From File : Status OK 08-07-2025 16:01:53:Connection Successfully Opened : Status OK 08-07-2025 16:01:53:CBS A/C No : 001002000868 08-07-2025 16:01:53: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 08-07-2025 16:01:53:Record Count : 1 08-07-2025 16:01:53:BRLENGTH 3 08-07-2025 16:01:53:SCHLENGTH 3 08-07-2025 16:01:53:ACLENGTH 6 08-07-2025 16:01:53:Branch Code 3 08-07-2025 16:01:53:Scheme Code 3 08-07-2025 16:01:53:Account No 3 08-07-2025 16:01:53:Link Main Started 08-07-2025 16:01:53:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 08-07-2025 16:01:53:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 16:01:53:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000868|CD |001 08-07-2025 16:01:53:Vno --->:69541 08-07-2025 16:01:53:Current Date --->:08-07-2025 08-07-2025 16:01:53:calling CallNewRtgsBothProc 08-07-2025 16:01:53:Parameters passing - InwardAuthorise 08-07-2025 16:01:53: brn =001 08-07-2025 16:01:53: acno =000868 08-07-2025 16:01:53: abbr =CD 08-07-2025 16:01:53: amt.ToString() =502 08-07-2025 16:01:53: traceNo =69541 08-07-2025 16:01:53: narr =NEFT, BY TATWATIS MOTORS KARB0000924 9242000100020901 08-07-2025 16:01:53:Transaction Process : BEFORE CAL PROC: 08-07-2025 16:01:53:cbs no--->001002000868 08-07-2025 16:01:53:CBS A/C No : 001002000868 08-07-2025 16:01:53: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 08-07-2025 16:01:53:Record Count : 1 08-07-2025 16:01:53:BRLENGTH 3 08-07-2025 16:01:53:SCHLENGTH 3 08-07-2025 16:01:53:ACLENGTH 6 08-07-2025 16:01:53:Branch Code 3 08-07-2025 16:01:53:Scheme Code 3 08-07-2025 16:01:53:Account No 3 08-07-2025 16:01:53:Link Main Started 08-07-2025 16:01:53:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 08-07-2025 16:01:53:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 16:01:53:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000868|CD |001 08-07-2025 16:01:53: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)='CD' AND DEPM_NO=000868 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)='CD' AND LOAM_NO=000868 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)='CD' AND ODMT_NO=000868 AND ADDR_SNO=CLMS_ADDRESS 08-07-2025 16:01:53:closed y n Record count --->1 08-07-2025 16:01:53:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : KARBN25189452885|001002000868 --------------------------> 08-07-2025 16:01:53:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 16:01:53:Connection Establisment started 08-07-2025 16:01:53:Connection Read From File : Status OK 08-07-2025 16:01:53:SMS Inserted for Mobile Number : +919448051124 08-07-2025 16:01:53:Inward Process Executed Sussefully 08-07-2025 16:01:53:ConfirmationReq Execution Success with Status 000 08-07-2025 16:01:53:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : KARBN25189453163|001002000868 ------------------------------> 08-07-2025 16:01:53:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 16:01:53:Connection Successfully Opened : Status OK 08-07-2025 16:01:53:ValidateAcNo CBS A/C No : 001002000868 08-07-2025 16:01:53:CBS A/C No : 001002000868 08-07-2025 16:01:53: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 08-07-2025 16:01:53:Record Count : 1 08-07-2025 16:01:53:BRLENGTH 3 08-07-2025 16:01:53:SCHLENGTH 3 08-07-2025 16:01:53:ACLENGTH 6 08-07-2025 16:01:53:Branch Code 3 08-07-2025 16:01:53:Scheme Code 3 08-07-2025 16:01:53:Account No 3 08-07-2025 16:01:53:Link Main Started 08-07-2025 16:01:53:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 08-07-2025 16:01:53:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 16:01:53:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000868|CD |001 08-07-2025 16:01:53:Validation Account Proce Executed with out error Y 08-07-2025 16:01:53:Connection Establisment started 08-07-2025 16:01:53:Connection Read From File : Status OK 08-07-2025 16:01:53:Connection Successfully Opened : Status OK 08-07-2025 16:01:53:CBS A/C No : 001002000868 08-07-2025 16:01:53: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 08-07-2025 16:01:53:Record Count : 1 08-07-2025 16:01:53:BRLENGTH 3 08-07-2025 16:01:53:SCHLENGTH 3 08-07-2025 16:01:53:ACLENGTH 6 08-07-2025 16:01:53:Branch Code 3 08-07-2025 16:01:53:Scheme Code 3 08-07-2025 16:01:53:Account No 3 08-07-2025 16:01:53:Link Main Started 08-07-2025 16:01:53:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 08-07-2025 16:01:53:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 16:01:53:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000868|CD |001 08-07-2025 16:01:53:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : KARBN25189452484|001002000868 --------------------------> 08-07-2025 16:01:53:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 16:01:53:Connection Establisment started 08-07-2025 16:01:53:Connection Read From File : Status OK 08-07-2025 16:01:53:Vno --->:69542 08-07-2025 16:01:53:Current Date --->:08-07-2025 08-07-2025 16:01:53:calling CallNewRtgsBothProc 08-07-2025 16:01:53:Parameters passing - InwardAuthorise 08-07-2025 16:01:53: brn =001 08-07-2025 16:01:53: acno =000868 08-07-2025 16:01:53: abbr =CD 08-07-2025 16:01:53: amt.ToString() =2304 08-07-2025 16:01:53: traceNo =69542 08-07-2025 16:01:53: narr =NEFT, BY TATWATIS MOTORS KARB0000924 9242000100020901 08-07-2025 16:01:53:Transaction Process : BEFORE CAL PROC: 08-07-2025 16:01:53:cbs no--->001002000868 08-07-2025 16:01:53:CBS A/C No : 001002000868 08-07-2025 16:01:53: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 08-07-2025 16:01:53:Record Count : 1 08-07-2025 16:01:53:BRLENGTH 3 08-07-2025 16:01:53:SCHLENGTH 3 08-07-2025 16:01:53:ACLENGTH 6 08-07-2025 16:01:53:Branch Code 3 08-07-2025 16:01:53:Scheme Code 3 08-07-2025 16:01:53:Account No 3 08-07-2025 16:01:53:Link Main Started 08-07-2025 16:01:53:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 08-07-2025 16:01:53:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 16:01:53:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000868|CD |001 08-07-2025 16:01:53: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)='CD' AND DEPM_NO=000868 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)='CD' AND LOAM_NO=000868 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)='CD' AND ODMT_NO=000868 AND ADDR_SNO=CLMS_ADDRESS 08-07-2025 16:01:53:closed y n Record count --->1 08-07-2025 16:01:53:Connection Successfully Opened : Status OK 08-07-2025 16:01:53:ValidateAcNo CBS A/C No : 001002000868 08-07-2025 16:01:53:CBS A/C No : 001002000868 08-07-2025 16:01:53: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 08-07-2025 16:01:53:Record Count : 1 08-07-2025 16:01:53:BRLENGTH 3 08-07-2025 16:01:53:SCHLENGTH 3 08-07-2025 16:01:53:ACLENGTH 6 08-07-2025 16:01:53:Branch Code 3 08-07-2025 16:01:53:Scheme Code 3 08-07-2025 16:01:53:Account No 3 08-07-2025 16:01:53:Link Main Started 08-07-2025 16:01:53:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 08-07-2025 16:01:53:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 16:01:53:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000868|CD |001 08-07-2025 16:01:53:Validation Account Proce Executed with out error Y 08-07-2025 16:01:53:Connection Establisment started 08-07-2025 16:01:53:Connection Read From File : Status OK 08-07-2025 16:01:53:Connection Successfully Opened : Status OK 08-07-2025 16:01:53:CBS A/C No : 001002000868 08-07-2025 16:01:53: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 08-07-2025 16:01:53:Record Count : 1 08-07-2025 16:01:53:BRLENGTH 3 08-07-2025 16:01:53:SCHLENGTH 3 08-07-2025 16:01:53:ACLENGTH 6 08-07-2025 16:01:53:Branch Code 3 08-07-2025 16:01:53:Scheme Code 3 08-07-2025 16:01:53:Account No 3 08-07-2025 16:01:53:Link Main Started 08-07-2025 16:01:53:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 08-07-2025 16:01:53:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 16:01:53:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000868|CD |001 08-07-2025 16:01:53:Vno --->:69543 08-07-2025 16:01:53:Current Date --->:08-07-2025 08-07-2025 16:01:54:calling CallNewRtgsBothProc 08-07-2025 16:01:54:Parameters passing - InwardAuthorise 08-07-2025 16:01:54: brn =001 08-07-2025 16:01:54: acno =000868 08-07-2025 16:01:54: abbr =CD 08-07-2025 16:01:54: amt.ToString() =9996 08-07-2025 16:01:54: traceNo =69543 08-07-2025 16:01:54: narr =NEFT, BY TATWATIS MOTORS KARB0000924 9242000100020901 08-07-2025 16:01:54:Transaction Process : BEFORE CAL PROC: 08-07-2025 16:01:54:cbs no--->001002000868 08-07-2025 16:01:54:CBS A/C No : 001002000868 08-07-2025 16:01:54: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 08-07-2025 16:01:54:Record Count : 1 08-07-2025 16:01:54:BRLENGTH 3 08-07-2025 16:01:54:SCHLENGTH 3 08-07-2025 16:01:54:ACLENGTH 6 08-07-2025 16:01:54:Branch Code 3 08-07-2025 16:01:54:Scheme Code 3 08-07-2025 16:01:54:Account No 3 08-07-2025 16:01:54:Link Main Started 08-07-2025 16:01:54:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 08-07-2025 16:01:54:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 16:01:54:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000868|CD |001 08-07-2025 16:01:54: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)='CD' AND DEPM_NO=000868 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)='CD' AND LOAM_NO=000868 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)='CD' AND ODMT_NO=000868 AND ADDR_SNO=CLMS_ADDRESS 08-07-2025 16:01:54:SMS Inserted for Mobile Number : +919448051124 08-07-2025 16:01:54:closed y n Record count --->1 08-07-2025 16:01:54:Inward Process Executed Sussefully 08-07-2025 16:01:54:ConfirmationReq Execution Success with Status 000 08-07-2025 16:01:54:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : KARBN25189452885|001002000868 ------------------------------> 08-07-2025 16:01:54:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 16:01:54:SMS Inserted for Mobile Number : +919448051124 08-07-2025 16:01:54:Inward Process Executed Sussefully 08-07-2025 16:01:54:ConfirmationReq Execution Success with Status 000 08-07-2025 16:01:54:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : KARBN25189452484|001002000868 ------------------------------> 08-07-2025 16:01:54:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 16:28:16:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : HDFCH00352000259|001001002975 --------------------------> 08-07-2025 16:28:16:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 16:28:16:Connection Establisment started 08-07-2025 16:28:16:Connection Read From File : Status OK 08-07-2025 16:28:16:Connection Successfully Opened : Status OK 08-07-2025 16:28:16:ValidateAcNo CBS A/C No : 001001002975 08-07-2025 16:28:16:CBS A/C No : 001001002975 08-07-2025 16:28: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 08-07-2025 16:28:16:Record Count : 1 08-07-2025 16:28:16:BRLENGTH 3 08-07-2025 16:28:16:SCHLENGTH 3 08-07-2025 16:28:16:ACLENGTH 6 08-07-2025 16:28:16:Branch Code 3 08-07-2025 16:28:16:Scheme Code 3 08-07-2025 16:28:16:Account No 3 08-07-2025 16:28:16:Link Main Started 08-07-2025 16:28:16:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 16:28:16:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 16:28:16:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|002975|SB |001 08-07-2025 16:28:16:Validation Account Proce Executed with out error Y 08-07-2025 16:28:16:Connection Establisment started 08-07-2025 16:28:16:Connection Read From File : Status OK 08-07-2025 16:28:16:Connection Successfully Opened : Status OK 08-07-2025 16:28:16:CBS A/C No : 001001002975 08-07-2025 16:28: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 08-07-2025 16:28:16:Record Count : 1 08-07-2025 16:28:16:BRLENGTH 3 08-07-2025 16:28:16:SCHLENGTH 3 08-07-2025 16:28:16:ACLENGTH 6 08-07-2025 16:28:16:Branch Code 3 08-07-2025 16:28:16:Scheme Code 3 08-07-2025 16:28:16:Account No 3 08-07-2025 16:28:16:Link Main Started 08-07-2025 16:28:16:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 16:28:16:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 16:28:16:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|002975|SB |001 08-07-2025 16:28:17:Vno --->:69544 08-07-2025 16:28:17:Current Date --->:08-07-2025 08-07-2025 16:28:17:calling CallNewRtgsBothProc 08-07-2025 16:28:17:Parameters passing - InwardAuthorise 08-07-2025 16:28:17: brn =001 08-07-2025 16:28:17: acno =002975 08-07-2025 16:28:17: abbr =SB 08-07-2025 16:28:17: amt.ToString() =7260 08-07-2025 16:28:17: traceNo =69544 08-07-2025 16:28:17: narr =NEFT, BY RELIANCE INDUSTRIES LTD HDFC0000240 57500000418961 08-07-2025 16:28:17:Transaction Process : BEFORE CAL PROC: 08-07-2025 16:28:17:cbs no--->001001002975 08-07-2025 16:28:17:CBS A/C No : 001001002975 08-07-2025 16:28:17: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 08-07-2025 16:28:17:Record Count : 1 08-07-2025 16:28:17:BRLENGTH 3 08-07-2025 16:28:17:SCHLENGTH 3 08-07-2025 16:28:17:ACLENGTH 6 08-07-2025 16:28:17:Branch Code 3 08-07-2025 16:28:17:Scheme Code 3 08-07-2025 16:28:17:Account No 3 08-07-2025 16:28:17:Link Main Started 08-07-2025 16:28:17:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 16:28:17:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 16:28:17:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|002975|SB |001 08-07-2025 16:28:17: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=002975 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=002975 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=002975 AND ADDR_SNO=CLMS_ADDRESS 08-07-2025 16:28:17:closed y n Record count --->1 08-07-2025 16:28:17:SMS Inserted for Mobile Number : +919448801245 08-07-2025 16:28:17:Inward Process Executed Sussefully 08-07-2025 16:28:17:ConfirmationReq Execution Success with Status 000 08-07-2025 16:28:17:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : HDFCH00352000259|001001002975 ------------------------------> 08-07-2025 16:28:17:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 16:35:29:<------------------------Started ValidationRequest CBS A/C No : 001001011946 ------------------------> 08-07-2025 16:35:29:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 16:35:29:Connection Establisment started 08-07-2025 16:35:29:Connection Read From File : Status OK 08-07-2025 16:35:29:Connection Successfully Opened : Status OK 08-07-2025 16:35:29:ValidateAcNo CBS A/C No : 001001011946 08-07-2025 16:35:29:CBS A/C No : 001001011946 08-07-2025 16:35:29: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 08-07-2025 16:35:29:Record Count : 1 08-07-2025 16:35:29:BRLENGTH 3 08-07-2025 16:35:29:SCHLENGTH 3 08-07-2025 16:35:29:ACLENGTH 6 08-07-2025 16:35:29:Branch Code 3 08-07-2025 16:35:29:Scheme Code 3 08-07-2025 16:35:29:Account No 3 08-07-2025 16:35:29:Link Main Started 08-07-2025 16:35:29:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 16:35:29:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 16:35:29:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|011946|SB |001 08-07-2025 16:35:29:Validation Account Proce Executed with out error Y 08-07-2025 16:35:29:ValidationRequest Exccution Success with response : 000 08-07-2025 16:35:29:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 16:35:32:<------------------------Started ValidationRequest CBS A/C No : 001001005798 ------------------------> 08-07-2025 16:35:32:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 16:35:32:Connection Establisment started 08-07-2025 16:35:32:Connection Read From File : Status OK 08-07-2025 16:35:33:Connection Successfully Opened : Status OK 08-07-2025 16:35:33:ValidateAcNo CBS A/C No : 001001005798 08-07-2025 16:35:33:CBS A/C No : 001001005798 08-07-2025 16:35:33: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 08-07-2025 16:35:33:Record Count : 1 08-07-2025 16:35:33:BRLENGTH 3 08-07-2025 16:35:33:SCHLENGTH 3 08-07-2025 16:35:33:ACLENGTH 6 08-07-2025 16:35:33:Branch Code 3 08-07-2025 16:35:33:Scheme Code 3 08-07-2025 16:35:33:Account No 3 08-07-2025 16:35:33:Link Main Started 08-07-2025 16:35:33:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 16:35:33:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 16:35:33:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|005798|SB |001 08-07-2025 16:35:33:Validation Account Proce Executed with out error Y 08-07-2025 16:35:33:ValidationRequest Exccution Success with response : 000 08-07-2025 16:35:33:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 16:35:37:<------------------------Started ValidationRequest CBS A/C No : 001001002467 ------------------------> 08-07-2025 16:35:37:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 16:35:37:Connection Establisment started 08-07-2025 16:35:37:Connection Read From File : Status OK 08-07-2025 16:35:38:Connection Successfully Opened : Status OK 08-07-2025 16:35:38:ValidateAcNo CBS A/C No : 001001002467 08-07-2025 16:35:38:CBS A/C No : 001001002467 08-07-2025 16:35:38: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 08-07-2025 16:35:38:Record Count : 1 08-07-2025 16:35:38:BRLENGTH 3 08-07-2025 16:35:38:SCHLENGTH 3 08-07-2025 16:35:38:ACLENGTH 6 08-07-2025 16:35:38:Branch Code 3 08-07-2025 16:35:38:Scheme Code 3 08-07-2025 16:35:38:Account No 3 08-07-2025 16:35:38:Link Main Started 08-07-2025 16:35:38:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 16:35:38:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 16:35:38:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|002467|SB |001 08-07-2025 16:35:38:Validation Account Proce Executed with out error Y 08-07-2025 16:35:38:ValidationRequest Exccution Success with response : 000 08-07-2025 16:35:38:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 17:09:42:<------------------------Started ValidationRequest CBS A/C No : 001001001331 ------------------------> 08-07-2025 17:09:42:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 17:09:42:Connection Establisment started 08-07-2025 17:09:42:Connection Read From File : Status OK 08-07-2025 17:09:42:Connection Successfully Opened : Status OK 08-07-2025 17:09:42:ValidateAcNo CBS A/C No : 001001001331 08-07-2025 17:09:42:CBS A/C No : 001001001331 08-07-2025 17:09: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 08-07-2025 17:09:42:Record Count : 1 08-07-2025 17:09:42:BRLENGTH 3 08-07-2025 17:09:42:SCHLENGTH 3 08-07-2025 17:09:42:ACLENGTH 6 08-07-2025 17:09:42:Branch Code 3 08-07-2025 17:09:42:Scheme Code 3 08-07-2025 17:09:42:Account No 3 08-07-2025 17:09:42:Link Main Started 08-07-2025 17:09:42:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 17:09:42:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 17:09:42:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001331|SB |001 08-07-2025 17:09:42:Validation Account Proce Executed with out error Y 08-07-2025 17:09:42:ValidationRequest Exccution Success with response : 000 08-07-2025 17:09:42:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 17:10:12:<------------------------Started ValidationRequest CBS A/C No : 001001013477 ------------------------> 08-07-2025 17:10:12:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 17:10:12:Connection Establisment started 08-07-2025 17:10:12:Connection Read From File : Status OK 08-07-2025 17:10:12:Connection Successfully Opened : Status OK 08-07-2025 17:10:12:ValidateAcNo CBS A/C No : 001001013477 08-07-2025 17:10:12:CBS A/C No : 001001013477 08-07-2025 17:10:12: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 08-07-2025 17:10:12:Record Count : 1 08-07-2025 17:10:12:BRLENGTH 3 08-07-2025 17:10:12:SCHLENGTH 3 08-07-2025 17:10:12:ACLENGTH 6 08-07-2025 17:10:12:Branch Code 3 08-07-2025 17:10:12:Scheme Code 3 08-07-2025 17:10:12:Account No 3 08-07-2025 17:10:12:Link Main Started 08-07-2025 17:10:12:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 17:10:12:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 17:10:12:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|013477|SB |001 08-07-2025 17:10:12:Validation Account Proce Executed with out error Y 08-07-2025 17:10:12:ValidationRequest Exccution Success with response : 000 08-07-2025 17:10:12:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 17:14:01:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM18941227218|001001002467 --------------------------> 08-07-2025 17:14:01:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 17:14:01:Connection Establisment started 08-07-2025 17:14:01:Connection Read From File : Status OK 08-07-2025 17:14:01:Connection Successfully Opened : Status OK 08-07-2025 17:14:01:ValidateAcNo CBS A/C No : 001001002467 08-07-2025 17:14:01:CBS A/C No : 001001002467 08-07-2025 17:14:01: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 08-07-2025 17:14:01:Record Count : 1 08-07-2025 17:14:01:BRLENGTH 3 08-07-2025 17:14:01:SCHLENGTH 3 08-07-2025 17:14:01:ACLENGTH 6 08-07-2025 17:14:01:Branch Code 3 08-07-2025 17:14:01:Scheme Code 3 08-07-2025 17:14:01:Account No 3 08-07-2025 17:14:01:Link Main Started 08-07-2025 17:14:01:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 17:14:01:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 17:14:01:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|002467|SB |001 08-07-2025 17:14:01:Validation Account Proce Executed with out error Y 08-07-2025 17:14:01:Connection Establisment started 08-07-2025 17:14:01:Connection Read From File : Status OK 08-07-2025 17:14:01:Connection Successfully Opened : Status OK 08-07-2025 17:14:01:CBS A/C No : 001001002467 08-07-2025 17:14:01: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 08-07-2025 17:14:01:Record Count : 1 08-07-2025 17:14:01:BRLENGTH 3 08-07-2025 17:14:01:SCHLENGTH 3 08-07-2025 17:14:01:ACLENGTH 6 08-07-2025 17:14:01:Branch Code 3 08-07-2025 17:14:01:Scheme Code 3 08-07-2025 17:14:01:Account No 3 08-07-2025 17:14:01:Link Main Started 08-07-2025 17:14:01:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 17:14:01:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 17:14:01:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|002467|SB |001 08-07-2025 17:14:01:Vno --->:69545 08-07-2025 17:14:01:Current Date --->:08-07-2025 08-07-2025 17:14:01:calling CallNewRtgsBothProc 08-07-2025 17:14:01:Parameters passing - InwardAuthorise 08-07-2025 17:14:01: brn =001 08-07-2025 17:14:01: acno =002467 08-07-2025 17:14:01: abbr =SB 08-07-2025 17:14:01: amt.ToString() =486 08-07-2025 17:14:01: traceNo =69545 08-07-2025 17:14:01: narr =NEFT, BY ONE 97 COMMUNICATIONS LIMITED ESCROW ACCOUNT _01 UTIB0000022 924020007330961 08-07-2025 17:14:01:Transaction Process : BEFORE CAL PROC: 08-07-2025 17:14:01:Inward Process Executed Sussefully 08-07-2025 17:14:01:ConfirmationReq Execution Success with Status 000 08-07-2025 17:14:01:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM18941227218|001001002467 ------------------------------> 08-07-2025 17:14:01:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 17:14:01:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : HDFCH00352145616|001001005798 --------------------------> 08-07-2025 17:14:01:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 17:14:01:Connection Establisment started 08-07-2025 17:14:01:Connection Read From File : Status OK 08-07-2025 17:14:01:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM18941227221|001001011946 --------------------------> 08-07-2025 17:14:01:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 17:14:01:Connection Establisment started 08-07-2025 17:14:01:Connection Read From File : Status OK 08-07-2025 17:14:01:Connection Successfully Opened : Status OK 08-07-2025 17:14:01:ValidateAcNo CBS A/C No : 001001005798 08-07-2025 17:14:01:CBS A/C No : 001001005798 08-07-2025 17:14:01: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 08-07-2025 17:14:01:Record Count : 1 08-07-2025 17:14:01:BRLENGTH 3 08-07-2025 17:14:01:SCHLENGTH 3 08-07-2025 17:14:01:ACLENGTH 6 08-07-2025 17:14:01:Branch Code 3 08-07-2025 17:14:01:Scheme Code 3 08-07-2025 17:14:01:Account No 3 08-07-2025 17:14:01:Link Main Started 08-07-2025 17:14:01:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 17:14:01:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 17:14:01:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|005798|SB |001 08-07-2025 17:14:01:Validation Account Proce Executed with out error Y 08-07-2025 17:14:01:Connection Establisment started 08-07-2025 17:14:01:Connection Read From File : Status OK 08-07-2025 17:14:01:Connection Successfully Opened : Status OK 08-07-2025 17:14:01:CBS A/C No : 001001005798 08-07-2025 17:14:01: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 08-07-2025 17:14:01:Record Count : 1 08-07-2025 17:14:01:BRLENGTH 3 08-07-2025 17:14:01:SCHLENGTH 3 08-07-2025 17:14:01:ACLENGTH 6 08-07-2025 17:14:01:Branch Code 3 08-07-2025 17:14:01:Scheme Code 3 08-07-2025 17:14:01:Account No 3 08-07-2025 17:14:01:Link Main Started 08-07-2025 17:14:01:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 17:14:01:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 17:14:01:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|005798|SB |001 08-07-2025 17:14:01:Vno --->:69546 08-07-2025 17:14:01:Current Date --->:08-07-2025 08-07-2025 17:14:01:calling CallNewRtgsBothProc 08-07-2025 17:14:01:Parameters passing - InwardAuthorise 08-07-2025 17:14:01: brn =001 08-07-2025 17:14:01: acno =005798 08-07-2025 17:14:01: abbr =SB 08-07-2025 17:14:01: amt.ToString() =200000 08-07-2025 17:14:01: traceNo =69546 08-07-2025 17:14:01: narr =NEFT, BY SHREYASH RAJENDRAKUMAR KAMBLE HDFC0001172 50100611158190 08-07-2025 17:14:01:Transaction Process : BEFORE CAL PROC: 08-07-2025 17:14:01:Connection Successfully Opened : Status OK 08-07-2025 17:14:01:ValidateAcNo CBS A/C No : 001001011946 08-07-2025 17:14:01:CBS A/C No : 001001011946 08-07-2025 17:14:01: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 08-07-2025 17:14:01:Record Count : 1 08-07-2025 17:14:01:BRLENGTH 3 08-07-2025 17:14:01:SCHLENGTH 3 08-07-2025 17:14:01:ACLENGTH 6 08-07-2025 17:14:01:Branch Code 3 08-07-2025 17:14:01:Scheme Code 3 08-07-2025 17:14:01:Account No 3 08-07-2025 17:14:01:Link Main Started 08-07-2025 17:14:01:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 17:14:01:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 17:14:01:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|011946|SB |001 08-07-2025 17:14:01:cbs no--->001001005798 08-07-2025 17:14:01:CBS A/C No : 001001005798 08-07-2025 17:14:01: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 08-07-2025 17:14:01:Validation Account Proce Executed with out error Y 08-07-2025 17:14:01:Connection Establisment started 08-07-2025 17:14:01:Connection Read From File : Status OK 08-07-2025 17:14:01:Connection Successfully Opened : Status OK 08-07-2025 17:14:01:CBS A/C No : 001001011946 08-07-2025 17:14:01:Record Count : 1 08-07-2025 17:14:01:BRLENGTH 3 08-07-2025 17:14:01:SCHLENGTH 3 08-07-2025 17:14:01:ACLENGTH 6 08-07-2025 17:14:01:Branch Code 3 08-07-2025 17:14:01:Scheme Code 3 08-07-2025 17:14:01:Account No 3 08-07-2025 17:14:01:Link Main Started 08-07-2025 17:14:01:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 17:14:01:Record Count : 1 08-07-2025 17:14:01:BRLENGTH 3 08-07-2025 17:14:01:SCHLENGTH 3 08-07-2025 17:14:01:ACLENGTH 6 08-07-2025 17:14:01:Branch Code 3 08-07-2025 17:14:01:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 17:14:01:Account No 3 08-07-2025 17:14:01:Link Main Started 08-07-2025 17:14:01:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 17:14:01:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|005798|SB |001 08-07-2025 17:14:01: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=005798 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=005798 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=005798 AND ADDR_SNO=CLMS_ADDRESS 08-07-2025 17:14:01:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 17:14:01:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|011946|SB |001 08-07-2025 17:14:01:Vno --->:69547 08-07-2025 17:14:01:Current Date --->:08-07-2025 08-07-2025 17:14:01:calling CallNewRtgsBothProc 08-07-2025 17:14:01:Parameters passing - InwardAuthorise 08-07-2025 17:14:01: brn =001 08-07-2025 17:14:01: acno =011946 08-07-2025 17:14:01: abbr =SB 08-07-2025 17:14:01: amt.ToString() =425 08-07-2025 17:14:01: traceNo =69547 08-07-2025 17:14:01: narr =NEFT, BY ONE 97 COMMUNICATIONS LIMITED ESCROW ACCOUNT _01 UTIB0000022 924020007330961 08-07-2025 17:14:01:Transaction Process : BEFORE CAL PROC: 08-07-2025 17:14:01:closed y n Record count --->1 08-07-2025 17:14:01:Inward Process Executed Sussefully 08-07-2025 17:14:01:ConfirmationReq Execution Success with Status 000 08-07-2025 17:14:01:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM18941227221|001001011946 ------------------------------> 08-07-2025 17:14:01:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 17:14:01:Inward Process Executed Sussefully 08-07-2025 17:14:01:ConfirmationReq Execution Success with Status 000 08-07-2025 17:14:01:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : HDFCH00352145616|001001005798 ------------------------------> 08-07-2025 17:14:01:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 17:27:33:<------------------------Started ValidationRequest CBS A/C No : 001001013442 ------------------------> 08-07-2025 17:27:33:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 17:27:33:Connection Establisment started 08-07-2025 17:27:33:Connection Read From File : Status OK 08-07-2025 17:27:33:Connection Successfully Opened : Status OK 08-07-2025 17:27:33:ValidateAcNo CBS A/C No : 001001013442 08-07-2025 17:27:33:CBS A/C No : 001001013442 08-07-2025 17:27:33: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 08-07-2025 17:27:33:Record Count : 1 08-07-2025 17:27:33:BRLENGTH 3 08-07-2025 17:27:33:SCHLENGTH 3 08-07-2025 17:27:33:ACLENGTH 6 08-07-2025 17:27:33:Branch Code 3 08-07-2025 17:27:33:Scheme Code 3 08-07-2025 17:27:33:Account No 3 08-07-2025 17:27:33:Link Main Started 08-07-2025 17:27:33:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 17:27:33:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 17:27:33:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|013442|SB |001 08-07-2025 17:27:33:Validation Account Proce Executed with out error Y 08-07-2025 17:27:33:ValidationRequest Exccution Success with response : 000 08-07-2025 17:27:33:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 17:46:29:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : CMS1892520704808|001001013477 --------------------------> 08-07-2025 17:46:29:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 17:46:29:Connection Establisment started 08-07-2025 17:46:29:Connection Read From File : Status OK 08-07-2025 17:46:29:Connection Successfully Opened : Status OK 08-07-2025 17:46:29:ValidateAcNo CBS A/C No : 001001013477 08-07-2025 17:46:29:CBS A/C No : 001001013477 08-07-2025 17:46:29: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 08-07-2025 17:46:29:Record Count : 1 08-07-2025 17:46:29:BRLENGTH 3 08-07-2025 17:46:29:SCHLENGTH 3 08-07-2025 17:46:29:ACLENGTH 6 08-07-2025 17:46:29:Branch Code 3 08-07-2025 17:46:29:Scheme Code 3 08-07-2025 17:46:29:Account No 3 08-07-2025 17:46:29:Link Main Started 08-07-2025 17:46:29:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 17:46:29:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 17:46:29:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|013477|SB |001 08-07-2025 17:46:29:Validation Account Proce Executed with out error Y 08-07-2025 17:46:29:Connection Establisment started 08-07-2025 17:46:29:Connection Read From File : Status OK 08-07-2025 17:46:29:Connection Successfully Opened : Status OK 08-07-2025 17:46:29:CBS A/C No : 001001013477 08-07-2025 17:46:29: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 08-07-2025 17:46:29:Record Count : 1 08-07-2025 17:46:29:BRLENGTH 3 08-07-2025 17:46:29:SCHLENGTH 3 08-07-2025 17:46:29:ACLENGTH 6 08-07-2025 17:46:29:Branch Code 3 08-07-2025 17:46:29:Scheme Code 3 08-07-2025 17:46:29:Account No 3 08-07-2025 17:46:29:Link Main Started 08-07-2025 17:46:29:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 17:46:29:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 17:46:29:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|013477|SB |001 08-07-2025 17:46:29:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 002161111360|001001001331 --------------------------> 08-07-2025 17:46:29:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 17:46:29:Connection Establisment started 08-07-2025 17:46:29:Connection Read From File : Status OK 08-07-2025 17:46:29:Connection Successfully Opened : Status OK 08-07-2025 17:46:29:ValidateAcNo CBS A/C No : 001001001331 08-07-2025 17:46:29:CBS A/C No : 001001001331 08-07-2025 17:46:29: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 08-07-2025 17:46:29:Record Count : 1 08-07-2025 17:46:29:BRLENGTH 3 08-07-2025 17:46:29:SCHLENGTH 3 08-07-2025 17:46:29:ACLENGTH 6 08-07-2025 17:46:29:Branch Code 3 08-07-2025 17:46:29:Scheme Code 3 08-07-2025 17:46:29:Account No 3 08-07-2025 17:46:29:Link Main Started 08-07-2025 17:46:29:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 17:46:29:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 17:46:29:Vno --->:69548 08-07-2025 17:46:29:Current Date --->:08-07-2025 08-07-2025 17:46:29:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001331|SB |001 08-07-2025 17:46:29:calling CallNewRtgsBothProc 08-07-2025 17:46:29:Parameters passing - InwardAuthorise 08-07-2025 17:46:29: brn =001 08-07-2025 17:46:29: acno =013477 08-07-2025 17:46:29: abbr =SB 08-07-2025 17:46:29: amt.ToString() =276399 08-07-2025 17:46:29: traceNo =69548 08-07-2025 17:46:29: narr =NEFT, BY LIC OF INDIA DO DHARWAD NEFT A C KKBK0000958 0012362158 08-07-2025 17:46:29:Transaction Process : BEFORE CAL PROC: 08-07-2025 17:46:29:Validation Account Proce Executed with out error Y 08-07-2025 17:46:29:Connection Establisment started 08-07-2025 17:46:29:Connection Read From File : Status OK 08-07-2025 17:46:29:Connection Successfully Opened : Status OK 08-07-2025 17:46:29:CBS A/C No : 001001001331 08-07-2025 17:46:29: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 08-07-2025 17:46:29:Record Count : 1 08-07-2025 17:46:29:BRLENGTH 3 08-07-2025 17:46:29:SCHLENGTH 3 08-07-2025 17:46:29:ACLENGTH 6 08-07-2025 17:46:29:Branch Code 3 08-07-2025 17:46:29:Scheme Code 3 08-07-2025 17:46:29:Account No 3 08-07-2025 17:46:29:Link Main Started 08-07-2025 17:46:29:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 17:46:29:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 17:46:29:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001331|SB |001 08-07-2025 17:46:29:Vno --->:69549 08-07-2025 17:46:29:Current Date --->:08-07-2025 08-07-2025 17:46:29:calling CallNewRtgsBothProc 08-07-2025 17:46:29:Parameters passing - InwardAuthorise 08-07-2025 17:46:29: brn =001 08-07-2025 17:46:29: acno =001331 08-07-2025 17:46:29: abbr =SB 08-07-2025 17:46:29: amt.ToString() =6500 08-07-2025 17:46:29: traceNo =69549 08-07-2025 17:46:29: narr =NEFT, BY LAXMI METAL UBIN0533173 331701010560637 08-07-2025 17:46:29:Transaction Process : BEFORE CAL PROC: 08-07-2025 17:46:29:cbs no--->001001013477 08-07-2025 17:46:29:CBS A/C No : 001001013477 08-07-2025 17:46:29: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 08-07-2025 17:46:29:Record Count : 1 08-07-2025 17:46:29:BRLENGTH 3 08-07-2025 17:46:29:SCHLENGTH 3 08-07-2025 17:46:29:ACLENGTH 6 08-07-2025 17:46:29:Branch Code 3 08-07-2025 17:46:29:Scheme Code 3 08-07-2025 17:46:29:Account No 3 08-07-2025 17:46:29:Link Main Started 08-07-2025 17:46:29:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 17:46:29:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 17:46:29:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|013477|SB |001 08-07-2025 17:46:29: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=013477 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=013477 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=013477 AND ADDR_SNO=CLMS_ADDRESS 08-07-2025 17:46:29:cbs no--->001001001331 08-07-2025 17:46:29:CBS A/C No : 001001001331 08-07-2025 17:46:29: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 08-07-2025 17:46:29:Record Count : 1 08-07-2025 17:46:29:BRLENGTH 3 08-07-2025 17:46:29:SCHLENGTH 3 08-07-2025 17:46:29:ACLENGTH 6 08-07-2025 17:46:29:Branch Code 3 08-07-2025 17:46:29:Scheme Code 3 08-07-2025 17:46:29:Account No 3 08-07-2025 17:46:29:Link Main Started 08-07-2025 17:46:29:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 17:46:29:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 17:46:29:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001331|SB |001 08-07-2025 17:46:29: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=001331 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=001331 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=001331 AND ADDR_SNO=CLMS_ADDRESS 08-07-2025 17:46:29:closed y n Record count --->1 08-07-2025 17:46:29:SMS Inserted for Mobile Number : +919743932311 08-07-2025 17:46:29:closed y n Record count --->1 08-07-2025 17:46:29:SMS Inserted for Mobile Number : +919448462055 08-07-2025 17:46:29:Inward Process Executed Sussefully 08-07-2025 17:46:29:ConfirmationReq Execution Success with Status 000 08-07-2025 17:46:29:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : CMS1892520704808|001001013477 ------------------------------> 08-07-2025 17:46:29:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 17:46:29:Inward Process Executed Sussefully 08-07-2025 17:46:29:ConfirmationReq Execution Success with Status 000 08-07-2025 17:46:29:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 002161111360|001001001331 ------------------------------> 08-07-2025 17:46:29:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 18:07:10:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXOIC18941408395|001001013442 --------------------------> 08-07-2025 18:07:10:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 18:07:10:Connection Establisment started 08-07-2025 18:07:10:Connection Read From File : Status OK 08-07-2025 18:07:10:Connection Successfully Opened : Status OK 08-07-2025 18:07:10:ValidateAcNo CBS A/C No : 001001013442 08-07-2025 18:07:10:CBS A/C No : 001001013442 08-07-2025 18:07: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 08-07-2025 18:07:10:Record Count : 1 08-07-2025 18:07:10:BRLENGTH 3 08-07-2025 18:07:10:SCHLENGTH 3 08-07-2025 18:07:10:ACLENGTH 6 08-07-2025 18:07:10:Branch Code 3 08-07-2025 18:07:10:Scheme Code 3 08-07-2025 18:07:10:Account No 3 08-07-2025 18:07:10:Link Main Started 08-07-2025 18:07:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 18:07:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 18:07:10:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|013442|SB |001 08-07-2025 18:07:10:Validation Account Proce Executed with out error Y 08-07-2025 18:07:10:Connection Establisment started 08-07-2025 18:07:10:Connection Read From File : Status OK 08-07-2025 18:07:10:Connection Successfully Opened : Status OK 08-07-2025 18:07:10:CBS A/C No : 001001013442 08-07-2025 18:07: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 08-07-2025 18:07:10:Record Count : 1 08-07-2025 18:07:10:BRLENGTH 3 08-07-2025 18:07:10:SCHLENGTH 3 08-07-2025 18:07:10:ACLENGTH 6 08-07-2025 18:07:10:Branch Code 3 08-07-2025 18:07:10:Scheme Code 3 08-07-2025 18:07:10:Account No 3 08-07-2025 18:07:10:Link Main Started 08-07-2025 18:07:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 18:07:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 18:07:10:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|013442|SB |001 08-07-2025 18:07:10:Vno --->:69550 08-07-2025 18:07:10:Current Date --->:08-07-2025 08-07-2025 18:07:10:calling CallNewRtgsBothProc 08-07-2025 18:07:10:Parameters passing - InwardAuthorise 08-07-2025 18:07:10: brn =001 08-07-2025 18:07:10: acno =013442 08-07-2025 18:07:10: abbr =SB 08-07-2025 18:07:10: amt.ToString() =1400 08-07-2025 18:07:10: traceNo =69550 08-07-2025 18:07:10: narr =NEFT, BY MANOJ INDUSTRIES UTIB0000129 922030007383230 08-07-2025 18:07:10:Transaction Process : BEFORE CAL PROC: 08-07-2025 18:07:10:cbs no--->001001013442 08-07-2025 18:07:10:CBS A/C No : 001001013442 08-07-2025 18:07: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 08-07-2025 18:07:10:Record Count : 1 08-07-2025 18:07:10:BRLENGTH 3 08-07-2025 18:07:10:SCHLENGTH 3 08-07-2025 18:07:10:ACLENGTH 6 08-07-2025 18:07:10:Branch Code 3 08-07-2025 18:07:10:Scheme Code 3 08-07-2025 18:07:10:Account No 3 08-07-2025 18:07:10:Link Main Started 08-07-2025 18:07:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 18:07:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 18:07:10:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|013442|SB |001 08-07-2025 18:07: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=013442 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=013442 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=013442 AND ADDR_SNO=CLMS_ADDRESS 08-07-2025 18:07:10:closed y n Record count --->1 08-07-2025 18:07:10:SMS Inserted for Mobile Number : +917019333040 08-07-2025 18:07:10:Inward Process Executed Sussefully 08-07-2025 18:07:10:ConfirmationReq Execution Success with Status 000 08-07-2025 18:07:10:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXOIC18941408395|001001013442 ------------------------------> 08-07-2025 18:07:10:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 19:39:09:<------------------------Started ValidationRequest CBS A/C No : 1001013537 ------------------------> 08-07-2025 19:39:09:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 19:39:09:Connection Establisment started 08-07-2025 19:39:09:Connection Read From File : Status OK 08-07-2025 19:39:09:Connection Successfully Opened : Status OK 08-07-2025 19:39:09:ValidateAcNo CBS A/C No : 1001013537 08-07-2025 19:39:09:Validation Account Proce Executed with out error N 08-07-2025 19:39:09:ValidationRequest Exccution Success with response : 111 08-07-2025 19:39:09:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 22:12:08:<------------------------Started ValidationRequest CBS A/C No : 002002000034 ------------------------> 08-07-2025 22:12:08:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 22:12:08:Connection Establisment started 08-07-2025 22:12:08:Connection Read From File : Status OK 08-07-2025 22:12:08:Connection Successfully Opened : Status OK 08-07-2025 22:12:08:ValidateAcNo CBS A/C No : 002002000034 08-07-2025 22:12:08:CBS A/C No : 002002000034 08-07-2025 22:12:08: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 08-07-2025 22:12:08:Record Count : 1 08-07-2025 22:12:08:BRLENGTH 3 08-07-2025 22:12:08:SCHLENGTH 3 08-07-2025 22:12:08:ACLENGTH 6 08-07-2025 22:12:08:Branch Code 3 08-07-2025 22:12:08:Scheme Code 3 08-07-2025 22:12:08:Account No 3 08-07-2025 22:12:08:Link Main Started 08-07-2025 22:12:08:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 08-07-2025 22:12:08:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 002 08-07-2025 22:12:08:ShowCBS Ac No Proce Executed BARDANSAL|DEPOSIT|000034|CD |002 08-07-2025 22:12:08:Validation Account Proce Executed with out error Y 08-07-2025 22:12:08:ValidationRequest Exccution Success with response : 000 08-07-2025 22:12:08:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 22:40:12:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : CNRBH00059960403|002002000034 --------------------------> 08-07-2025 22:40:12:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 22:40:12:Connection Establisment started 08-07-2025 22:40:12:Connection Read From File : Status OK 08-07-2025 22:40:13:Connection Successfully Opened : Status OK 08-07-2025 22:40:13:ValidateAcNo CBS A/C No : 002002000034 08-07-2025 22:40:13:CBS A/C No : 002002000034 08-07-2025 22:40: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 08-07-2025 22:40:13:Record Count : 1 08-07-2025 22:40:13:BRLENGTH 3 08-07-2025 22:40:13:SCHLENGTH 3 08-07-2025 22:40:13:ACLENGTH 6 08-07-2025 22:40:13:Branch Code 3 08-07-2025 22:40:13:Scheme Code 3 08-07-2025 22:40:13:Account No 3 08-07-2025 22:40:13:Link Main Started 08-07-2025 22:40:13:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 08-07-2025 22:40:13:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 002 08-07-2025 22:40:13:ShowCBS Ac No Proce Executed BARDANSAL|DEPOSIT|000034|CD |002 08-07-2025 22:40:13:Validation Account Proce Executed with out error Y 08-07-2025 22:40:13:Connection Establisment started 08-07-2025 22:40:13:Connection Read From File : Status OK 08-07-2025 22:40:13:Connection Successfully Opened : Status OK 08-07-2025 22:40:13:CBS A/C No : 002002000034 08-07-2025 22:40: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 08-07-2025 22:40:13:Record Count : 1 08-07-2025 22:40:13:BRLENGTH 3 08-07-2025 22:40:13:SCHLENGTH 3 08-07-2025 22:40:13:ACLENGTH 6 08-07-2025 22:40:13:Branch Code 3 08-07-2025 22:40:13:Scheme Code 3 08-07-2025 22:40:13:Account No 3 08-07-2025 22:40:13:Link Main Started 08-07-2025 22:40:13:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 08-07-2025 22:40:13:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 002 08-07-2025 22:40:13:ShowCBS Ac No Proce Executed BARDANSAL|DEPOSIT|000034|CD |002 08-07-2025 22:40:13:Vno --->:69551 08-07-2025 22:40:13:Current Date --->:08-07-2025 08-07-2025 22:40:13:calling CallNewRtgsBothProc 08-07-2025 22:40:13:Parameters passing - InwardAuthorise 08-07-2025 22:40:13: brn =002 08-07-2025 22:40:13: acno =000034 08-07-2025 22:40:13: abbr =CD 08-07-2025 22:40:13: amt.ToString() =46288 08-07-2025 22:40:13: traceNo =69551 08-07-2025 22:40:13: narr =NEFT, BY SRI JAGADAMBHA HOME INDUSTRY CNRB0010349 03493070000457 08-07-2025 22:40:13:Transaction Process : BEFORE CAL PROC: 08-07-2025 22:40:13:cbs no--->002002000034 08-07-2025 22:40:13:CBS A/C No : 002002000034 08-07-2025 22:40: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 08-07-2025 22:40:13:Record Count : 1 08-07-2025 22:40:13:BRLENGTH 3 08-07-2025 22:40:13:SCHLENGTH 3 08-07-2025 22:40:13:ACLENGTH 6 08-07-2025 22:40:13:Branch Code 3 08-07-2025 22:40:13:Scheme Code 3 08-07-2025 22:40:13:Account No 3 08-07-2025 22:40:13:Link Main Started 08-07-2025 22:40:13:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 08-07-2025 22:40:13:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 002 08-07-2025 22:40:13:ShowCBS Ac No Proce Executed BARDANSAL|DEPOSIT|000034|CD |002 08-07-2025 22:40:13: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)='CD' AND DEPM_NO=000034 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)='CD' AND LOAM_NO=000034 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)='CD' AND ODMT_NO=000034 AND ADDR_SNO=CLMS_ADDRESS 08-07-2025 22:40:13:closed y n Record count --->1 08-07-2025 22:40:13:SMS Inserted for Mobile Number : +919900145345 08-07-2025 22:40:13:Inward Process Executed Sussefully 08-07-2025 22:40:13:ConfirmationReq Execution Success with Status 000 08-07-2025 22:40:13:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : CNRBH00059960403|002002000034 ------------------------------> 08-07-2025 22:40:13:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 22:57:09:<------------------------Started ValidationRequest CBS A/C No : 001001013537 ------------------------> 08-07-2025 22:57:09:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 22:57:09:Connection Establisment started 08-07-2025 22:57:09:Connection Read From File : Status OK 08-07-2025 22:57:09:Connection Successfully Opened : Status OK 08-07-2025 22:57:09:ValidateAcNo CBS A/C No : 001001013537 08-07-2025 22:57:09:CBS A/C No : 001001013537 08-07-2025 22:57: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 08-07-2025 22:57:09:Record Count : 1 08-07-2025 22:57:09:BRLENGTH 3 08-07-2025 22:57:09:SCHLENGTH 3 08-07-2025 22:57:09:ACLENGTH 6 08-07-2025 22:57:09:Branch Code 3 08-07-2025 22:57:09:Scheme Code 3 08-07-2025 22:57:09:Account No 3 08-07-2025 22:57:09:Link Main Started 08-07-2025 22:57:09:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 22:57:09:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 22:57:09:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|013537|SB |001 08-07-2025 22:57:09:Validation Account Proce Executed with out error Y 08-07-2025 22:57:09:ValidationRequest Exccution Success with response : 000 08-07-2025 22:57:09:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 23:11:55:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : ICIN418958334613|001001013537 --------------------------> 08-07-2025 23:11:55:<------------------------------------------------------------------------------------------------------------------------> 08-07-2025 23:11:55:Connection Establisment started 08-07-2025 23:11:55:Connection Read From File : Status OK 08-07-2025 23:11:55:Connection Successfully Opened : Status OK 08-07-2025 23:11:55:ValidateAcNo CBS A/C No : 001001013537 08-07-2025 23:11:55:CBS A/C No : 001001013537 08-07-2025 23:11: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 08-07-2025 23:11:55:Record Count : 1 08-07-2025 23:11:55:BRLENGTH 3 08-07-2025 23:11:55:SCHLENGTH 3 08-07-2025 23:11:55:ACLENGTH 6 08-07-2025 23:11:55:Branch Code 3 08-07-2025 23:11:55:Scheme Code 3 08-07-2025 23:11:55:Account No 3 08-07-2025 23:11:55:Link Main Started 08-07-2025 23:11:55:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 23:11:55:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 23:11:55:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|013537|SB |001 08-07-2025 23:11:55:Validation Account Proce Executed with out error Y 08-07-2025 23:11:55:Connection Establisment started 08-07-2025 23:11:55:Connection Read From File : Status OK 08-07-2025 23:11:55:Connection Successfully Opened : Status OK 08-07-2025 23:11:55:CBS A/C No : 001001013537 08-07-2025 23:11: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 08-07-2025 23:11:55:Record Count : 1 08-07-2025 23:11:55:BRLENGTH 3 08-07-2025 23:11:55:SCHLENGTH 3 08-07-2025 23:11:55:ACLENGTH 6 08-07-2025 23:11:55:Branch Code 3 08-07-2025 23:11:55:Scheme Code 3 08-07-2025 23:11:55:Account No 3 08-07-2025 23:11:55:Link Main Started 08-07-2025 23:11:55:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 23:11:55:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 23:11:55:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|013537|SB |001 08-07-2025 23:11:55:Vno --->:69552 08-07-2025 23:11:55:Current Date --->:08-07-2025 08-07-2025 23:11:55:calling CallNewRtgsBothProc 08-07-2025 23:11:55:Parameters passing - InwardAuthorise 08-07-2025 23:11:55: brn =001 08-07-2025 23:11:55: acno =013537 08-07-2025 23:11:55: abbr =SB 08-07-2025 23:11:55: amt.ToString() =18800 08-07-2025 23:11:55: traceNo =69552 08-07-2025 23:11:55: narr =NEFT, BY SHREE RAGHAVENDRA FINANCIAL CONSULTANCY PRIVATE LI ICIC0SF0002 015705018518 08-07-2025 23:11:55:Transaction Process : BEFORE CAL PROC: 08-07-2025 23:11:55:cbs no--->001001013537 08-07-2025 23:11:55:CBS A/C No : 001001013537 08-07-2025 23:11: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 08-07-2025 23:11:55:Record Count : 1 08-07-2025 23:11:55:BRLENGTH 3 08-07-2025 23:11:55:SCHLENGTH 3 08-07-2025 23:11:55:ACLENGTH 6 08-07-2025 23:11:55:Branch Code 3 08-07-2025 23:11:55:Scheme Code 3 08-07-2025 23:11:55:Account No 3 08-07-2025 23:11:55:Link Main Started 08-07-2025 23:11:55:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 08-07-2025 23:11:55:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 08-07-2025 23:11:55:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|013537|SB |001 08-07-2025 23:11:55: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=013537 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=013537 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=013537 AND ADDR_SNO=CLMS_ADDRESS 08-07-2025 23:11:55:closed y n Record count --->1 08-07-2025 23:11:55:SMS Inserted for Mobile Number : +916361516193 08-07-2025 23:11:56:Inward Process Executed Sussefully 08-07-2025 23:11:56:ConfirmationReq Execution Success with Status 000 08-07-2025 23:11:56:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : ICIN418958334613|001001013537 ------------------------------> 08-07-2025 23:11:56:<------------------------------------------------------------------------------------------------------------------------>