6/12/2026 1:27:27 PM:<------------------------Started ValidationRequest CBS A/C No : 001002000895 ------------------------>
6/12/2026 1:27:27 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 1:27:27 PM:Connection Establisment started
6/12/2026 1:27:27 PM:Connection Read From File  : Status OK 
6/12/2026 1:27:27 PM:Connection Successfully Opened  : Status OK 
6/12/2026 1:27:27 PM:ValidateAcNo CBS A/C No : 001002000895
6/12/2026 1:27:27 PM:CBS A/C No : 001002000895
6/12/2026 1:27:27 PM: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
6/12/2026 1:27:27 PM:Record Count : 1
6/12/2026 1:27:27 PM:BRLENGTH 3
6/12/2026 1:27:27 PM:SCHLENGTH 3
6/12/2026 1:27:27 PM:ACLENGTH 6
6/12/2026 1:27:27 PM:Branch Code 3
6/12/2026 1:27:27 PM:Scheme Code 3
6/12/2026 1:27:27 PM:Account No 3
6/12/2026 1:27:27 PM:Link Main Started
6/12/2026 1:27:27 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
6/12/2026 1:27:27 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 1:27:27 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000895|CD |001
6/12/2026 1:27:27 PM:Validation Account Proce Executed with out error Y
6/12/2026 1:27:27 PM:ValidationRequest Exccution Success with response :  000
6/12/2026 1:27:27 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 1:35:27 PM:<------------------------Started ValidationRequest CBS A/C No : 001001009597 ------------------------>
6/12/2026 1:35:27 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 1:35:27 PM:Connection Establisment started
6/12/2026 1:35:27 PM:Connection Read From File  : Status OK 
6/12/2026 1:35:27 PM:Connection Successfully Opened  : Status OK 
6/12/2026 1:35:27 PM:ValidateAcNo CBS A/C No : 001001009597
6/12/2026 1:35:27 PM:CBS A/C No : 001001009597
6/12/2026 1:35:27 PM: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
6/12/2026 1:35:27 PM:Record Count : 1
6/12/2026 1:35:27 PM:BRLENGTH 3
6/12/2026 1:35:27 PM:SCHLENGTH 3
6/12/2026 1:35:27 PM:ACLENGTH 6
6/12/2026 1:35:27 PM:Branch Code 3
6/12/2026 1:35:27 PM:Scheme Code 3
6/12/2026 1:35:27 PM:Account No 3
6/12/2026 1:35:27 PM:Link Main Started
6/12/2026 1:35:27 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 1:35:27 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 1:35:27 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|009597|SB |001
6/12/2026 1:35:27 PM:Validation Account Proce Executed with out error Y
6/12/2026 1:35:27 PM:ValidationRequest Exccution Success with response :  000
6/12/2026 1:35:27 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 1:43:20 PM:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXOMB16302063866|001002000895 -------------------------->
6/12/2026 1:43:20 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 1:43:20 PM:Connection Establisment started
6/12/2026 1:43:20 PM:Connection Read From File  : Status OK 
6/12/2026 1:43:20 PM:Connection Successfully Opened  : Status OK 
6/12/2026 1:43:20 PM:ValidateAcNo CBS A/C No : 001002000895
6/12/2026 1:43:20 PM:CBS A/C No : 001002000895
6/12/2026 1:43:20 PM: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
6/12/2026 1:43:20 PM:Record Count : 1
6/12/2026 1:43:20 PM:BRLENGTH 3
6/12/2026 1:43:20 PM:SCHLENGTH 3
6/12/2026 1:43:20 PM:ACLENGTH 6
6/12/2026 1:43:20 PM:Branch Code 3
6/12/2026 1:43:20 PM:Scheme Code 3
6/12/2026 1:43:20 PM:Account No 3
6/12/2026 1:43:20 PM:Link Main Started
6/12/2026 1:43:20 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
6/12/2026 1:43:20 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 1:43:20 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000895|CD |001
6/12/2026 1:43:20 PM:Validation Account Proce Executed with out error Y
6/12/2026 1:43:20 PM:Connection Establisment started
6/12/2026 1:43:20 PM:Connection Read From File  : Status OK 
6/12/2026 1:43:20 PM:Connection Successfully Opened  : Status OK 
6/12/2026 1:43:20 PM:CBS A/C No : 001002000895
6/12/2026 1:43:20 PM: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
6/12/2026 1:43:20 PM:Record Count : 1
6/12/2026 1:43:20 PM:BRLENGTH 3
6/12/2026 1:43:20 PM:SCHLENGTH 3
6/12/2026 1:43:20 PM:ACLENGTH 6
6/12/2026 1:43:20 PM:Branch Code 3
6/12/2026 1:43:20 PM:Scheme Code 3
6/12/2026 1:43:20 PM:Account No 3
6/12/2026 1:43:20 PM:Link Main Started
6/12/2026 1:43:20 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
6/12/2026 1:43:20 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 1:43:20 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000895|CD |001
6/12/2026 1:43:20 PM:Vno --->:85596
6/12/2026 1:43:20 PM:Current Date  --->:6/12/2026
6/12/2026 1:43:20 PM:calling  CallNewRtgsBothProc 
6/12/2026 1:43:20 PM:Parameters passing - InwardAuthorise 
6/12/2026 1:43:20 PM: brn =001
6/12/2026 1:43:20 PM: acno =000895
6/12/2026 1:43:20 PM: abbr =CD
6/12/2026 1:43:20 PM: amt.ToString() =200000
6/12/2026 1:43:20 PM: traceNo =85596
6/12/2026 1:43:20 PM: narr =NEFT, BY SRI LAXMI NARASIMHA FERTILIZERS SEEDS   PESTICIDES UTIB0001178 918020033860442
6/12/2026 1:43:20 PM:Transaction Process :  BEFORE CAL PROC:
6/12/2026 1:43:20 PM:cbs no--->001002000895
6/12/2026 1:43:20 PM:CBS A/C No : 001002000895
6/12/2026 1:43:20 PM: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
6/12/2026 1:43:20 PM:Record Count : 1
6/12/2026 1:43:20 PM:BRLENGTH 3
6/12/2026 1:43:20 PM:SCHLENGTH 3
6/12/2026 1:43:20 PM:ACLENGTH 6
6/12/2026 1:43:20 PM:Branch Code 3
6/12/2026 1:43:20 PM:Scheme Code 3
6/12/2026 1:43:20 PM:Account No 3
6/12/2026 1:43:20 PM:Link Main Started
6/12/2026 1:43:20 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
6/12/2026 1:43:20 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 1:43:20 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000895|CD |001
6/12/2026 1:43:20 PM: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
6/12/2026 1:43:20 PM:closed y n Record count --->1
6/12/2026 1:43:20 PM:SMS Inserted for Mobile Number : +919972536615
6/12/2026 1:43:20 PM:Inward Process Executed Sussefully
6/12/2026 1:43:20 PM:ConfirmationReq Execution Success with Status 000
6/12/2026 1:43:20 PM:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXOMB16302063866|001002000895 ------------------------------>
6/12/2026 1:43:20 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 1:45:56 PM:<------------------------Started ValidationRequest CBS A/C No : 001001004027 ------------------------>
6/12/2026 1:45:56 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 1:45:56 PM:Connection Establisment started
6/12/2026 1:45:56 PM:Connection Read From File  : Status OK 
6/12/2026 1:45:56 PM:Connection Successfully Opened  : Status OK 
6/12/2026 1:45:56 PM:ValidateAcNo CBS A/C No : 001001004027
6/12/2026 1:45:56 PM:CBS A/C No : 001001004027
6/12/2026 1:45:56 PM: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
6/12/2026 1:45:56 PM:Record Count : 1
6/12/2026 1:45:56 PM:BRLENGTH 3
6/12/2026 1:45:56 PM:SCHLENGTH 3
6/12/2026 1:45:56 PM:ACLENGTH 6
6/12/2026 1:45:56 PM:Branch Code 3
6/12/2026 1:45:56 PM:Scheme Code 3
6/12/2026 1:45:56 PM:Account No 3
6/12/2026 1:45:56 PM:Link Main Started
6/12/2026 1:45:56 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 1:45:56 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 1:45:56 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|004027|SB |001
6/12/2026 1:45:56 PM:Validation Account Proce Executed with out error Y
6/12/2026 1:45:56 PM:ValidationRequest Exccution Success with response :  000
6/12/2026 1:45:56 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 1:47:25 PM:<------------------------Started ValidationRequest CBS A/C No : 001001007318 ------------------------>
6/12/2026 1:47:25 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 1:47:25 PM:Connection Establisment started
6/12/2026 1:47:25 PM:Connection Read From File  : Status OK 
6/12/2026 1:47:25 PM:Connection Successfully Opened  : Status OK 
6/12/2026 1:47:25 PM:ValidateAcNo CBS A/C No : 001001007318
6/12/2026 1:47:25 PM:CBS A/C No : 001001007318
6/12/2026 1:47:25 PM: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
6/12/2026 1:47:25 PM:Record Count : 1
6/12/2026 1:47:25 PM:BRLENGTH 3
6/12/2026 1:47:25 PM:SCHLENGTH 3
6/12/2026 1:47:25 PM:ACLENGTH 6
6/12/2026 1:47:25 PM:Branch Code 3
6/12/2026 1:47:25 PM:Scheme Code 3
6/12/2026 1:47:25 PM:Account No 3
6/12/2026 1:47:25 PM:Link Main Started
6/12/2026 1:47:25 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 1:47:25 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 1:47:25 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|007318|SB |001
6/12/2026 1:47:25 PM:Validation Account Proce Executed with out error Y
6/12/2026 1:47:25 PM:ValidationRequest Exccution Success with response :  000
6/12/2026 1:47:25 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 2:10:55 PM:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM16308002244|001001009597 -------------------------->
6/12/2026 2:10:55 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 2:10:55 PM:Connection Establisment started
6/12/2026 2:10:55 PM:Connection Read From File  : Status OK 
6/12/2026 2:10:55 PM:Connection Successfully Opened  : Status OK 
6/12/2026 2:10:55 PM:ValidateAcNo CBS A/C No : 001001009597
6/12/2026 2:10:55 PM:CBS A/C No : 001001009597
6/12/2026 2:10:55 PM: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
6/12/2026 2:10:55 PM:Record Count : 1
6/12/2026 2:10:55 PM:BRLENGTH 3
6/12/2026 2:10:55 PM:SCHLENGTH 3
6/12/2026 2:10:55 PM:ACLENGTH 6
6/12/2026 2:10:55 PM:Branch Code 3
6/12/2026 2:10:55 PM:Scheme Code 3
6/12/2026 2:10:55 PM:Account No 3
6/12/2026 2:10:55 PM:Link Main Started
6/12/2026 2:10:55 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 2:10:55 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 2:10:55 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|009597|SB |001
6/12/2026 2:10:55 PM:Validation Account Proce Executed with out error Y
6/12/2026 2:10:55 PM:Connection Establisment started
6/12/2026 2:10:55 PM:Connection Read From File  : Status OK 
6/12/2026 2:10:55 PM:Connection Successfully Opened  : Status OK 
6/12/2026 2:10:55 PM:CBS A/C No : 001001009597
6/12/2026 2:10:55 PM: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
6/12/2026 2:10:55 PM:Record Count : 1
6/12/2026 2:10:55 PM:BRLENGTH 3
6/12/2026 2:10:55 PM:SCHLENGTH 3
6/12/2026 2:10:55 PM:ACLENGTH 6
6/12/2026 2:10:55 PM:Branch Code 3
6/12/2026 2:10:55 PM:Scheme Code 3
6/12/2026 2:10:55 PM:Account No 3
6/12/2026 2:10:55 PM:Link Main Started
6/12/2026 2:10:55 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 2:10:55 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 2:10:55 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|009597|SB |001
6/12/2026 2:10:55 PM:Vno --->:85597
6/12/2026 2:10:55 PM:Current Date  --->:6/12/2026
6/12/2026 2:10:55 PM:calling  CallNewRtgsBothProc 
6/12/2026 2:10:55 PM:Parameters passing - InwardAuthorise 
6/12/2026 2:10:55 PM: brn =001
6/12/2026 2:10:55 PM: acno =009597
6/12/2026 2:10:55 PM: abbr =SB
6/12/2026 2:10:55 PM: amt.ToString() =150
6/12/2026 2:10:55 PM: traceNo =85597
6/12/2026 2:10:55 PM: narr =NEFT, BY PAYTM PAYMENTS SERVICES LTD-PAYMENT AGGREGATOR ESCROW A/C UTIB0000022 922020004482533
6/12/2026 2:10:55 PM:Transaction Process :  BEFORE CAL PROC:
6/12/2026 2:10:56 PM:cbs no--->001001009597
6/12/2026 2:10:56 PM:CBS A/C No : 001001009597
6/12/2026 2:10:56 PM: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
6/12/2026 2:10:56 PM:Record Count : 1
6/12/2026 2:10:56 PM:BRLENGTH 3
6/12/2026 2:10:56 PM:SCHLENGTH 3
6/12/2026 2:10:56 PM:ACLENGTH 6
6/12/2026 2:10:56 PM:Branch Code 3
6/12/2026 2:10:56 PM:Scheme Code 3
6/12/2026 2:10:56 PM:Account No 3
6/12/2026 2:10:56 PM:Link Main Started
6/12/2026 2:10:56 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 2:10:56 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 2:10:56 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|009597|SB |001
6/12/2026 2:10:56 PM: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=009597  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=009597  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=009597  AND ADDR_SNO=CLMS_ADDRESS
6/12/2026 2:10:56 PM:closed y n Record count --->1
6/12/2026 2:10:56 PM:SMS Inserted for Mobile Number : +919738750827
6/12/2026 2:10:56 PM:Inward Process Executed Sussefully
6/12/2026 2:10:56 PM:ConfirmationReq Execution Success with Status 000
6/12/2026 2:10:56 PM:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM16308002244|001001009597 ------------------------------>
6/12/2026 2:10:56 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 2:11:33 PM:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : IDIBH16346031303|001001004027 -------------------------->
6/12/2026 2:11:33 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 2:11:33 PM:Connection Establisment started
6/12/2026 2:11:33 PM:Connection Read From File  : Status OK 
6/12/2026 2:11:33 PM:Connection Successfully Opened  : Status OK 
6/12/2026 2:11:33 PM:ValidateAcNo CBS A/C No : 001001004027
6/12/2026 2:11:33 PM:CBS A/C No : 001001004027
6/12/2026 2:11:33 PM: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
6/12/2026 2:11:33 PM:Record Count : 1
6/12/2026 2:11:33 PM:BRLENGTH 3
6/12/2026 2:11:33 PM:SCHLENGTH 3
6/12/2026 2:11:33 PM:ACLENGTH 6
6/12/2026 2:11:33 PM:Branch Code 3
6/12/2026 2:11:33 PM:Scheme Code 3
6/12/2026 2:11:33 PM:Account No 3
6/12/2026 2:11:33 PM:Link Main Started
6/12/2026 2:11:33 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 2:11:33 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 2:11:33 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|004027|SB |001
6/12/2026 2:11:33 PM:Validation Account Proce Executed with out error Y
6/12/2026 2:11:33 PM:Connection Establisment started
6/12/2026 2:11:33 PM:Connection Read From File  : Status OK 
6/12/2026 2:11:33 PM:Connection Successfully Opened  : Status OK 
6/12/2026 2:11:33 PM:CBS A/C No : 001001004027
6/12/2026 2:11:33 PM: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
6/12/2026 2:11:33 PM:Record Count : 1
6/12/2026 2:11:33 PM:BRLENGTH 3
6/12/2026 2:11:33 PM:SCHLENGTH 3
6/12/2026 2:11:33 PM:ACLENGTH 6
6/12/2026 2:11:33 PM:Branch Code 3
6/12/2026 2:11:33 PM:Scheme Code 3
6/12/2026 2:11:33 PM:Account No 3
6/12/2026 2:11:33 PM:Link Main Started
6/12/2026 2:11:33 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 2:11:33 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 2:11:33 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|004027|SB |001
6/12/2026 2:11:33 PM:Vno --->:85598
6/12/2026 2:11:33 PM:Current Date  --->:6/12/2026
6/12/2026 2:11:33 PM:calling  CallNewRtgsBothProc 
6/12/2026 2:11:33 PM:Parameters passing - InwardAuthorise 
6/12/2026 2:11:33 PM: brn =001
6/12/2026 2:11:33 PM: acno =004027
6/12/2026 2:11:33 PM: abbr =SB
6/12/2026 2:11:33 PM: amt.ToString() =22500
6/12/2026 2:11:33 PM: traceNo =85598
6/12/2026 2:11:33 PM: narr =NEFT, BY AMOGH ENTERPRISES IDIB000H015 00000008070943727
6/12/2026 2:11:33 PM:Transaction Process :  BEFORE CAL PROC:
6/12/2026 2:11:33 PM:cbs no--->001001004027
6/12/2026 2:11:33 PM:CBS A/C No : 001001004027
6/12/2026 2:11:33 PM: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
6/12/2026 2:11:33 PM:Record Count : 1
6/12/2026 2:11:33 PM:BRLENGTH 3
6/12/2026 2:11:33 PM:SCHLENGTH 3
6/12/2026 2:11:33 PM:ACLENGTH 6
6/12/2026 2:11:33 PM:Branch Code 3
6/12/2026 2:11:33 PM:Scheme Code 3
6/12/2026 2:11:33 PM:Account No 3
6/12/2026 2:11:33 PM:Link Main Started
6/12/2026 2:11:33 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 2:11:33 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 2:11:33 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|004027|SB |001
6/12/2026 2:11:33 PM: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=004027  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=004027  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=004027  AND ADDR_SNO=CLMS_ADDRESS
6/12/2026 2:11:33 PM:closed y n Record count --->1
6/12/2026 2:11:33 PM:SMS Inserted for Mobile Number : +919900734245
6/12/2026 2:11:33 PM:Inward Process Executed Sussefully
6/12/2026 2:11:33 PM:ConfirmationReq Execution Success with Status 000
6/12/2026 2:11:33 PM:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : IDIBH16346031303|001001004027 ------------------------------>
6/12/2026 2:11:33 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 2:11:37 PM:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : IDIBH16346032016|001001007318 -------------------------->
6/12/2026 2:11:37 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 2:11:37 PM:Connection Establisment started
6/12/2026 2:11:37 PM:Connection Read From File  : Status OK 
6/12/2026 2:11:37 PM:Connection Successfully Opened  : Status OK 
6/12/2026 2:11:37 PM:ValidateAcNo CBS A/C No : 001001007318
6/12/2026 2:11:37 PM:CBS A/C No : 001001007318
6/12/2026 2:11:37 PM: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
6/12/2026 2:11:37 PM:Record Count : 1
6/12/2026 2:11:37 PM:BRLENGTH 3
6/12/2026 2:11:37 PM:SCHLENGTH 3
6/12/2026 2:11:37 PM:ACLENGTH 6
6/12/2026 2:11:37 PM:Branch Code 3
6/12/2026 2:11:37 PM:Scheme Code 3
6/12/2026 2:11:37 PM:Account No 3
6/12/2026 2:11:37 PM:Link Main Started
6/12/2026 2:11:37 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 2:11:37 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 2:11:37 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|007318|SB |001
6/12/2026 2:11:37 PM:Validation Account Proce Executed with out error Y
6/12/2026 2:11:37 PM:Connection Establisment started
6/12/2026 2:11:37 PM:Connection Read From File  : Status OK 
6/12/2026 2:11:37 PM:Connection Successfully Opened  : Status OK 
6/12/2026 2:11:37 PM:CBS A/C No : 001001007318
6/12/2026 2:11:37 PM: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
6/12/2026 2:11:38 PM:Record Count : 1
6/12/2026 2:11:38 PM:BRLENGTH 3
6/12/2026 2:11:38 PM:SCHLENGTH 3
6/12/2026 2:11:38 PM:ACLENGTH 6
6/12/2026 2:11:38 PM:Branch Code 3
6/12/2026 2:11:38 PM:Scheme Code 3
6/12/2026 2:11:38 PM:Account No 3
6/12/2026 2:11:38 PM:Link Main Started
6/12/2026 2:11:38 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 2:11:38 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 2:11:38 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|007318|SB |001
6/12/2026 2:11:38 PM:Vno --->:85599
6/12/2026 2:11:38 PM:Current Date  --->:6/12/2026
6/12/2026 2:11:38 PM:calling  CallNewRtgsBothProc 
6/12/2026 2:11:38 PM:Parameters passing - InwardAuthorise 
6/12/2026 2:11:38 PM: brn =001
6/12/2026 2:11:38 PM: acno =007318
6/12/2026 2:11:38 PM: abbr =SB
6/12/2026 2:11:38 PM: amt.ToString() =22500
6/12/2026 2:11:38 PM: traceNo =85599
6/12/2026 2:11:38 PM: narr =NEFT, BY AMOGH ENTERPRISES IDIB000H015 00000008070943727
6/12/2026 2:11:38 PM:Transaction Process :  BEFORE CAL PROC:
6/12/2026 2:11:38 PM:cbs no--->001001007318
6/12/2026 2:11:38 PM:CBS A/C No : 001001007318
6/12/2026 2:11:38 PM: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
6/12/2026 2:11:38 PM:Record Count : 1
6/12/2026 2:11:38 PM:BRLENGTH 3
6/12/2026 2:11:38 PM:SCHLENGTH 3
6/12/2026 2:11:38 PM:ACLENGTH 6
6/12/2026 2:11:38 PM:Branch Code 3
6/12/2026 2:11:38 PM:Scheme Code 3
6/12/2026 2:11:38 PM:Account No 3
6/12/2026 2:11:38 PM:Link Main Started
6/12/2026 2:11:38 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 2:11:38 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 2:11:38 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|007318|SB |001
6/12/2026 2:11:38 PM: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=007318  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=007318  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=007318  AND ADDR_SNO=CLMS_ADDRESS
6/12/2026 2:11:38 PM:closed y n Record count --->1
6/12/2026 2:11:38 PM:SMS Inserted for Mobile Number : +918105182491
6/12/2026 2:11:38 PM:Inward Process Executed Sussefully
6/12/2026 2:11:38 PM:ConfirmationReq Execution Success with Status 000
6/12/2026 2:11:38 PM:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : IDIBH16346032016|001001007318 ------------------------------>
6/12/2026 2:11:38 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 4:00:00 PM:<------------------------Started ValidationRequest CBS A/C No : 001002000895 ------------------------>
6/12/2026 4:00:00 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 4:00:00 PM:Connection Establisment started
6/12/2026 4:00:00 PM:Connection Read From File  : Status OK 
6/12/2026 4:00:00 PM:Connection Successfully Opened  : Status OK 
6/12/2026 4:00:00 PM:ValidateAcNo CBS A/C No : 001002000895
6/12/2026 4:00:00 PM:CBS A/C No : 001002000895
6/12/2026 4:00:00 PM: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
6/12/2026 4:00:00 PM:Record Count : 1
6/12/2026 4:00:00 PM:BRLENGTH 3
6/12/2026 4:00:00 PM:SCHLENGTH 3
6/12/2026 4:00:00 PM:ACLENGTH 6
6/12/2026 4:00:00 PM:Branch Code 3
6/12/2026 4:00:00 PM:Scheme Code 3
6/12/2026 4:00:00 PM:Account No 3
6/12/2026 4:00:00 PM:Link Main Started
6/12/2026 4:00:00 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
6/12/2026 4:00:00 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 4:00:00 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000895|CD |001
6/12/2026 4:00:00 PM:Validation Account Proce Executed with out error Y
6/12/2026 4:00:00 PM:ValidationRequest Exccution Success with response :  000
6/12/2026 4:00:00 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 4:00:19 PM:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : PUNBR52026061218498800|001002000895 -------------------------->
6/12/2026 4:00:19 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 4:00:19 PM:Connection Establisment started
6/12/2026 4:00:19 PM:Connection Read From File  : Status OK 
6/12/2026 4:00:19 PM:Connection Successfully Opened  : Status OK 
6/12/2026 4:00:19 PM:ValidateAcNo CBS A/C No : 001002000895
6/12/2026 4:00:19 PM:CBS A/C No : 001002000895
6/12/2026 4:00:19 PM: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
6/12/2026 4:00:19 PM:Record Count : 1
6/12/2026 4:00:19 PM:BRLENGTH 3
6/12/2026 4:00:19 PM:SCHLENGTH 3
6/12/2026 4:00:19 PM:ACLENGTH 6
6/12/2026 4:00:19 PM:Branch Code 3
6/12/2026 4:00:19 PM:Scheme Code 3
6/12/2026 4:00:19 PM:Account No 3
6/12/2026 4:00:19 PM:Link Main Started
6/12/2026 4:00:19 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
6/12/2026 4:00:19 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 4:00:19 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000895|CD |001
6/12/2026 4:00:19 PM:Validation Account Proce Executed with out error Y
6/12/2026 4:00:19 PM:Connection Establisment started
6/12/2026 4:00:19 PM:Connection Read From File  : Status OK 
6/12/2026 4:00:19 PM:Connection Successfully Opened  : Status OK 
6/12/2026 4:00:19 PM:CBS A/C No : 001002000895
6/12/2026 4:00:19 PM: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
6/12/2026 4:00:19 PM:Record Count : 1
6/12/2026 4:00:19 PM:BRLENGTH 3
6/12/2026 4:00:19 PM:SCHLENGTH 3
6/12/2026 4:00:19 PM:ACLENGTH 6
6/12/2026 4:00:19 PM:Branch Code 3
6/12/2026 4:00:19 PM:Scheme Code 3
6/12/2026 4:00:19 PM:Account No 3
6/12/2026 4:00:19 PM:Link Main Started
6/12/2026 4:00:19 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
6/12/2026 4:00:19 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 4:00:19 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000895|CD |001
6/12/2026 4:00:19 PM:Vno --->:85600
6/12/2026 4:00:19 PM:Current Date  --->:6/12/2026
6/12/2026 4:00:19 PM:calling  CallNewRtgsBothProc 
6/12/2026 4:00:19 PM:Parameters passing - InwardAuthorise 
6/12/2026 4:00:19 PM: brn =001
6/12/2026 4:00:19 PM: acno =000895
6/12/2026 4:00:19 PM: abbr =CD
6/12/2026 4:00:19 PM: amt.ToString() =300000
6/12/2026 4:00:19 PM: traceNo =85600
6/12/2026 4:00:19 PM: narr =RTGS, BY SHIVA FERTILIZERS AND PESTICIDES PUNB0285000 2850002100000332
6/12/2026 4:00:19 PM:Transaction Process :  BEFORE CAL PROC:
6/12/2026 4:00:19 PM:cbs no--->001002000895
6/12/2026 4:00:19 PM:CBS A/C No : 001002000895
6/12/2026 4:00:19 PM: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
6/12/2026 4:00:19 PM:Record Count : 1
6/12/2026 4:00:19 PM:BRLENGTH 3
6/12/2026 4:00:19 PM:SCHLENGTH 3
6/12/2026 4:00:19 PM:ACLENGTH 6
6/12/2026 4:00:19 PM:Branch Code 3
6/12/2026 4:00:19 PM:Scheme Code 3
6/12/2026 4:00:19 PM:Account No 3
6/12/2026 4:00:19 PM:Link Main Started
6/12/2026 4:00:19 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
6/12/2026 4:00:19 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 4:00:19 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000895|CD |001
6/12/2026 4:00:19 PM: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
6/12/2026 4:00:19 PM:closed y n Record count --->1
6/12/2026 4:00:19 PM:SMS Inserted for Mobile Number : +919972536615
6/12/2026 4:00:19 PM:Inward Process Executed Sussefully
6/12/2026 4:00:19 PM:ConfirmationReq Execution Success with Status 000
6/12/2026 4:00:19 PM:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : PUNBR52026061218498800|001002000895 ------------------------------>
6/12/2026 4:00:19 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 4:05:55 PM:<------------------------Started ValidationRequest CBS A/C No : 001001007600 ------------------------>
6/12/2026 4:05:55 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 4:05:55 PM:Connection Establisment started
6/12/2026 4:05:55 PM:Connection Read From File  : Status OK 
6/12/2026 4:05:55 PM:Connection Successfully Opened  : Status OK 
6/12/2026 4:05:55 PM:ValidateAcNo CBS A/C No : 001001007600
6/12/2026 4:05:55 PM:CBS A/C No : 001001007600
6/12/2026 4:05:55 PM: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
6/12/2026 4:05:55 PM:Record Count : 1
6/12/2026 4:05:55 PM:BRLENGTH 3
6/12/2026 4:05:55 PM:SCHLENGTH 3
6/12/2026 4:05:55 PM:ACLENGTH 6
6/12/2026 4:05:55 PM:Branch Code 3
6/12/2026 4:05:55 PM:Scheme Code 3
6/12/2026 4:05:55 PM:Account No 3
6/12/2026 4:05:55 PM:Link Main Started
6/12/2026 4:05:55 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 4:05:55 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 4:05:55 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|007600|SB |001
6/12/2026 4:05:55 PM:Validation Account Proce Executed with out error Y
6/12/2026 4:05:55 PM:ValidationRequest Exccution Success with response :  000
6/12/2026 4:05:55 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 4:05:55 PM:<------------------------Started ValidationRequest CBS A/C No : 001001013661 ------------------------>
6/12/2026 4:05:55 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 4:05:55 PM:Connection Establisment started
6/12/2026 4:05:55 PM:Connection Read From File  : Status OK 
6/12/2026 4:05:55 PM:<------------------------Started ValidationRequest CBS A/C No : 001001011946 ------------------------>
6/12/2026 4:05:55 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 4:05:55 PM:Connection Establisment started
6/12/2026 4:05:55 PM:Connection Read From File  : Status OK 
6/12/2026 4:05:55 PM:Connection Successfully Opened  : Status OK 
6/12/2026 4:05:55 PM:ValidateAcNo CBS A/C No : 001001013661
6/12/2026 4:05:55 PM:CBS A/C No : 001001013661
6/12/2026 4:05:55 PM: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
6/12/2026 4:05:55 PM:Record Count : 1
6/12/2026 4:05:55 PM:BRLENGTH 3
6/12/2026 4:05:55 PM:SCHLENGTH 3
6/12/2026 4:05:55 PM:ACLENGTH 6
6/12/2026 4:05:55 PM:Branch Code 3
6/12/2026 4:05:55 PM:Scheme Code 3
6/12/2026 4:05:55 PM:Account No 3
6/12/2026 4:05:55 PM:Link Main Started
6/12/2026 4:05:55 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 4:05:55 PM:<------------------------Started ValidationRequest CBS A/C No : 001002000669 ------------------------>
6/12/2026 4:05:55 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 4:05:55 PM:Connection Establisment started
6/12/2026 4:05:55 PM:Connection Read From File  : Status OK 
6/12/2026 4:05:55 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 4:05:55 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|013661|SB |001
6/12/2026 4:05:55 PM:Validation Account Proce Executed with out error Y
6/12/2026 4:05:55 PM:ValidationRequest Exccution Success with response :  000
6/12/2026 4:05:55 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 4:05:55 PM:Connection Successfully Opened  : Status OK 
6/12/2026 4:05:55 PM:ValidateAcNo CBS A/C No : 001001011946
6/12/2026 4:05:55 PM:CBS A/C No : 001001011946
6/12/2026 4:05:55 PM: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
6/12/2026 4:05:55 PM:Record Count : 1
6/12/2026 4:05:55 PM:BRLENGTH 3
6/12/2026 4:05:55 PM:SCHLENGTH 3
6/12/2026 4:05:55 PM:ACLENGTH 6
6/12/2026 4:05:55 PM:Branch Code 3
6/12/2026 4:05:55 PM:Scheme Code 3
6/12/2026 4:05:55 PM:Account No 3
6/12/2026 4:05:55 PM:Link Main Started
6/12/2026 4:05:55 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 4:05:55 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 4:05:55 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|011946|SB |001
6/12/2026 4:05:55 PM:Validation Account Proce Executed with out error Y
6/12/2026 4:05:55 PM:ValidationRequest Exccution Success with response :  000
6/12/2026 4:05:55 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 4:05:55 PM:Connection Successfully Opened  : Status OK 
6/12/2026 4:05:55 PM:ValidateAcNo CBS A/C No : 001002000669
6/12/2026 4:05:55 PM:CBS A/C No : 001002000669
6/12/2026 4:05:55 PM: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
6/12/2026 4:05:55 PM:Record Count : 1
6/12/2026 4:05:55 PM:BRLENGTH 3
6/12/2026 4:05:55 PM:SCHLENGTH 3
6/12/2026 4:05:55 PM:ACLENGTH 6
6/12/2026 4:05:55 PM:Branch Code 3
6/12/2026 4:05:55 PM:Scheme Code 3
6/12/2026 4:05:55 PM:Account No 3
6/12/2026 4:05:55 PM:Link Main Started
6/12/2026 4:05:55 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
6/12/2026 4:05:55 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 4:05:55 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000669|CD |001
6/12/2026 4:05:55 PM:Validation Account Proce Executed with out error Y
6/12/2026 4:05:55 PM:ValidationRequest Exccution Success with response :  000
6/12/2026 4:05:55 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 4:05:56 PM:<------------------------Started ValidationRequest CBS A/C No : 001001002467 ------------------------>
6/12/2026 4:05:56 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 4:05:56 PM:Connection Establisment started
6/12/2026 4:05:56 PM:Connection Read From File  : Status OK 
6/12/2026 4:05:56 PM:Connection Successfully Opened  : Status OK 
6/12/2026 4:05:56 PM:ValidateAcNo CBS A/C No : 001001002467
6/12/2026 4:05:56 PM:CBS A/C No : 001001002467
6/12/2026 4:05:56 PM: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
6/12/2026 4:05:56 PM:Record Count : 1
6/12/2026 4:05:56 PM:BRLENGTH 3
6/12/2026 4:05:56 PM:SCHLENGTH 3
6/12/2026 4:05:56 PM:ACLENGTH 6
6/12/2026 4:05:56 PM:Branch Code 3
6/12/2026 4:05:56 PM:Scheme Code 3
6/12/2026 4:05:56 PM:Account No 3
6/12/2026 4:05:56 PM:Link Main Started
6/12/2026 4:05:56 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 4:05:56 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 4:05:56 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|002467|SB |001
6/12/2026 4:05:56 PM:Validation Account Proce Executed with out error Y
6/12/2026 4:05:56 PM:ValidationRequest Exccution Success with response :  000
6/12/2026 4:05:56 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 4:05:56 PM:<------------------------Started ValidationRequest CBS A/C No : 002001000095 ------------------------>
6/12/2026 4:05:56 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 4:05:56 PM:Connection Establisment started
6/12/2026 4:05:56 PM:Connection Read From File  : Status OK 
6/12/2026 4:05:56 PM:Connection Successfully Opened  : Status OK 
6/12/2026 4:05:56 PM:ValidateAcNo CBS A/C No : 002001000095
6/12/2026 4:05:56 PM:CBS A/C No : 002001000095
6/12/2026 4:05:56 PM: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
6/12/2026 4:05:56 PM:Record Count : 1
6/12/2026 4:05:56 PM:BRLENGTH 3
6/12/2026 4:05:56 PM:SCHLENGTH 3
6/12/2026 4:05:56 PM:ACLENGTH 6
6/12/2026 4:05:56 PM:Branch Code 3
6/12/2026 4:05:56 PM:Scheme Code 3
6/12/2026 4:05:56 PM:Account No 3
6/12/2026 4:05:56 PM:Link Main Started
6/12/2026 4:05:56 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 4:05:56 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 002
6/12/2026 4:05:56 PM:ShowCBS Ac No Proce Executed  BARDANSAL|DEPOSIT|000095|SB |002
6/12/2026 4:05:56 PM:Validation Account Proce Executed with out error Y
6/12/2026 4:05:56 PM:ValidationRequest Exccution Success with response :  000
6/12/2026 4:05:56 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 4:05:56 PM:<------------------------Started ValidationRequest CBS A/C No : 001001011330 ------------------------>
6/12/2026 4:05:56 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 4:05:56 PM:Connection Establisment started
6/12/2026 4:05:56 PM:Connection Read From File  : Status OK 
6/12/2026 4:05:56 PM:Connection Successfully Opened  : Status OK 
6/12/2026 4:05:56 PM:ValidateAcNo CBS A/C No : 001001011330
6/12/2026 4:05:56 PM:CBS A/C No : 001001011330
6/12/2026 4:05:56 PM: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
6/12/2026 4:05:56 PM:Record Count : 1
6/12/2026 4:05:56 PM:BRLENGTH 3
6/12/2026 4:05:56 PM:SCHLENGTH 3
6/12/2026 4:05:56 PM:ACLENGTH 6
6/12/2026 4:05:56 PM:Branch Code 3
6/12/2026 4:05:56 PM:Scheme Code 3
6/12/2026 4:05:56 PM:Account No 3
6/12/2026 4:05:56 PM:Link Main Started
6/12/2026 4:05:56 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 4:05:56 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 4:05:56 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|011330|SB |001
6/12/2026 4:05:56 PM:Validation Account Proce Executed with out error Y
6/12/2026 4:05:56 PM:ValidationRequest Exccution Success with response :  000
6/12/2026 4:05:56 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 4:10:37 PM:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM16308232194|002001000095 -------------------------->
6/12/2026 4:10:37 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 4:10:37 PM:Connection Establisment started
6/12/2026 4:10:37 PM:Connection Read From File  : Status OK 
6/12/2026 4:10:37 PM:Connection Successfully Opened  : Status OK 
6/12/2026 4:10:37 PM:ValidateAcNo CBS A/C No : 002001000095
6/12/2026 4:10:37 PM:CBS A/C No : 002001000095
6/12/2026 4:10:37 PM: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
6/12/2026 4:10:37 PM:Record Count : 1
6/12/2026 4:10:37 PM:BRLENGTH 3
6/12/2026 4:10:37 PM:SCHLENGTH 3
6/12/2026 4:10:37 PM:ACLENGTH 6
6/12/2026 4:10:37 PM:Branch Code 3
6/12/2026 4:10:37 PM:Scheme Code 3
6/12/2026 4:10:37 PM:Account No 3
6/12/2026 4:10:37 PM:Link Main Started
6/12/2026 4:10:37 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 4:10:37 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 002
6/12/2026 4:10:37 PM:ShowCBS Ac No Proce Executed  BARDANSAL|DEPOSIT|000095|SB |002
6/12/2026 4:10:37 PM:Validation Account Proce Executed with out error Y
6/12/2026 4:10:37 PM:Connection Establisment started
6/12/2026 4:10:37 PM:Connection Read From File  : Status OK 
6/12/2026 4:10:37 PM:Connection Successfully Opened  : Status OK 
6/12/2026 4:10:37 PM:CBS A/C No : 002001000095
6/12/2026 4:10:37 PM: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
6/12/2026 4:10:37 PM:Record Count : 1
6/12/2026 4:10:37 PM:BRLENGTH 3
6/12/2026 4:10:37 PM:SCHLENGTH 3
6/12/2026 4:10:37 PM:ACLENGTH 6
6/12/2026 4:10:37 PM:Branch Code 3
6/12/2026 4:10:37 PM:Scheme Code 3
6/12/2026 4:10:37 PM:Account No 3
6/12/2026 4:10:37 PM:Link Main Started
6/12/2026 4:10:37 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 4:10:37 PM:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM16308232198|001001013661 -------------------------->
6/12/2026 4:10:37 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 4:10:37 PM:Connection Establisment started
6/12/2026 4:10:37 PM:Connection Read From File  : Status OK 
6/12/2026 4:10:37 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 002
6/12/2026 4:10:37 PM:ShowCBS Ac No Proce Executed  BARDANSAL|DEPOSIT|000095|SB |002
6/12/2026 4:10:37 PM:Vno --->:85601
6/12/2026 4:10:37 PM:Current Date  --->:6/12/2026
6/12/2026 4:10:37 PM:calling  CallNewRtgsBothProc 
6/12/2026 4:10:37 PM:Parameters passing - InwardAuthorise 
6/12/2026 4:10:37 PM: brn =002
6/12/2026 4:10:37 PM: acno =000095
6/12/2026 4:10:37 PM: abbr =SB
6/12/2026 4:10:37 PM: amt.ToString() =312
6/12/2026 4:10:37 PM: traceNo =85601
6/12/2026 4:10:37 PM: narr =NEFT, BY PAYTM PAYMENTS SERVICES LTD-PAYMENT AGGREGATOR ESCROW A/C UTIB0000022 922020004482533
6/12/2026 4:10:37 PM:Transaction Process :  BEFORE CAL PROC:
6/12/2026 4:10:37 PM:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM16308232228|001001011946 -------------------------->
6/12/2026 4:10:37 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 4:10:37 PM:Connection Establisment started
6/12/2026 4:10:37 PM:Connection Read From File  : Status OK 
6/12/2026 4:10:37 PM:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM16308232203|001001007600 -------------------------->
6/12/2026 4:10:37 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 4:10:37 PM:Connection Establisment started
6/12/2026 4:10:37 PM:Connection Read From File  : Status OK 
6/12/2026 4:10:37 PM:cbs no--->002001000095
6/12/2026 4:10:37 PM:CBS A/C No : 002001000095
6/12/2026 4:10:37 PM: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
6/12/2026 4:10:37 PM:Record Count : 1
6/12/2026 4:10:37 PM:BRLENGTH 3
6/12/2026 4:10:37 PM:SCHLENGTH 3
6/12/2026 4:10:37 PM:ACLENGTH 6
6/12/2026 4:10:37 PM:Branch Code 3
6/12/2026 4:10:37 PM:Scheme Code 3
6/12/2026 4:10:37 PM:Account No 3
6/12/2026 4:10:37 PM:Link Main Started
6/12/2026 4:10:37 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 4:10:37 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 002
6/12/2026 4:10:37 PM:ShowCBS Ac No Proce Executed  BARDANSAL|DEPOSIT|000095|SB |002
6/12/2026 4:10:37 PM: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)='SB'  AND DEPM_NO=000095  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)='SB'  AND LOAM_NO=000095  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)='SB'  AND ODMT_NO=000095  AND ADDR_SNO=CLMS_ADDRESS
6/12/2026 4:10:37 PM:closed y n Record count --->1
6/12/2026 4:10:37 PM:Connection Successfully Opened  : Status OK 
6/12/2026 4:10:37 PM:ValidateAcNo CBS A/C No : 001001013661
6/12/2026 4:10:37 PM:CBS A/C No : 001001013661
6/12/2026 4:10:37 PM: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
6/12/2026 4:10:37 PM:Record Count : 1
6/12/2026 4:10:37 PM:BRLENGTH 3
6/12/2026 4:10:37 PM:SCHLENGTH 3
6/12/2026 4:10:37 PM:ACLENGTH 6
6/12/2026 4:10:37 PM:Branch Code 3
6/12/2026 4:10:37 PM:Scheme Code 3
6/12/2026 4:10:37 PM:Account No 3
6/12/2026 4:10:37 PM:Link Main Started
6/12/2026 4:10:37 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 4:10:37 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 4:10:37 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|013661|SB |001
6/12/2026 4:10:37 PM:Validation Account Proce Executed with out error Y
6/12/2026 4:10:37 PM:Connection Establisment started
6/12/2026 4:10:37 PM:Connection Successfully Opened  : Status OK 
6/12/2026 4:10:37 PM:Connection Read From File  : Status OK 
6/12/2026 4:10:37 PM:CBS A/C No : 001001007600
6/12/2026 4:10:37 PM: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
6/12/2026 4:10:37 PM:Record Count : 1
6/12/2026 4:10:37 PM:BRLENGTH 3
6/12/2026 4:10:37 PM:SCHLENGTH 3
6/12/2026 4:10:37 PM:ACLENGTH 6
6/12/2026 4:10:37 PM:Branch Code 3
6/12/2026 4:10:37 PM:Scheme Code 3
6/12/2026 4:10:37 PM:Account No 3
6/12/2026 4:10:37 PM:Link Main Started
6/12/2026 4:10:37 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 4:10:37 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 4:10:37 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|007600|SB |001
6/12/2026 4:10:37 PM:Validation Account Proce Executed with out error Y
6/12/2026 4:10:37 PM:Connection Establisment started
6/12/2026 4:10:37 PM:Connection Successfully Opened  : Status OK 
6/12/2026 4:10:37 PM:Connection Read From File  : Status OK 
6/12/2026 4:10:37 PM: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
6/12/2026 4:10:37 PM:Record Count : 1
6/12/2026 4:10:37 PM:BRLENGTH 3
6/12/2026 4:10:37 PM:SCHLENGTH 3
6/12/2026 4:10:37 PM:ACLENGTH 6
6/12/2026 4:10:37 PM:Branch Code 3
6/12/2026 4:10:37 PM:Scheme Code 3
6/12/2026 4:10:37 PM:Account No 3
6/12/2026 4:10:37 PM:Link Main Started
6/12/2026 4:10:37 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 4:10:37 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 4:10:37 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|013661|SB |001
6/12/2026 4:10:37 PM:Vno --->:85602
6/12/2026 4:10:37 PM:Current Date  --->:6/12/2026
6/12/2026 4:10:37 PM:calling  CallNewRtgsBothProc 
6/12/2026 4:10:37 PM:Parameters passing - InwardAuthorise 
6/12/2026 4:10:37 PM: brn =001
6/12/2026 4:10:37 PM: acno =013661
6/12/2026 4:10:37 PM: abbr =SB
6/12/2026 4:10:37 PM: amt.ToString() =1530
6/12/2026 4:10:37 PM: traceNo =85602
6/12/2026 4:10:37 PM: narr =NEFT, BY PAYTM PAYMENTS SERVICES LTD-PAYMENT AGGREGATOR ESCROW A/C UTIB0000022 922020004482533
6/12/2026 4:10:37 PM:Transaction Process :  BEFORE CAL PROC:
6/12/2026 4:10:37 PM:cbs no--->001001013661
6/12/2026 4:10:37 PM:CBS A/C No : 001001013661
6/12/2026 4:10:37 PM: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
6/12/2026 4:10:37 PM:Record Count : 1
6/12/2026 4:10:37 PM:BRLENGTH 3
6/12/2026 4:10:37 PM:SCHLENGTH 3
6/12/2026 4:10:37 PM:ACLENGTH 6
6/12/2026 4:10:37 PM:Branch Code 3
6/12/2026 4:10:37 PM:Scheme Code 3
6/12/2026 4:10:37 PM:Account No 3
6/12/2026 4:10:37 PM:Link Main Started
6/12/2026 4:10:37 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 4:10:37 PM:Connection Successfully Opened  : Status OK 
6/12/2026 4:10:37 PM:ValidateAcNo CBS A/C No : 001001011946
6/12/2026 4:10:37 PM:CBS A/C No : 001001011946
6/12/2026 4:10:37 PM: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
6/12/2026 4:10:37 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 4:10:37 PM:Record Count : 1
6/12/2026 4:10:37 PM:BRLENGTH 3
6/12/2026 4:10:37 PM:SCHLENGTH 3
6/12/2026 4:10:37 PM:ACLENGTH 6
6/12/2026 4:10:37 PM:Branch Code 3
6/12/2026 4:10:37 PM:Scheme Code 3
6/12/2026 4:10:37 PM:Account No 3
6/12/2026 4:10:37 PM:Link Main Started
6/12/2026 4:10:37 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 4:10:37 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|013661|SB |001
6/12/2026 4:10:37 PM: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=013661  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=013661  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=013661  AND ADDR_SNO=CLMS_ADDRESS
6/12/2026 4:10:37 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 4:10:37 PM:closed y n Record count --->1
6/12/2026 4:10:37 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|011946|SB |001
6/12/2026 4:10:37 PM:Validation Account Proce Executed with out error Y
6/12/2026 4:10:37 PM:Connection Establisment started
6/12/2026 4:10:37 PM:Connection Read From File  : Status OK 
6/12/2026 4:10:37 PM:Connection Successfully Opened  : Status OK 
6/12/2026 4:10:37 PM:CBS A/C No : 001001011946
6/12/2026 4:10:37 PM: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
6/12/2026 4:10:37 PM:Record Count : 1
6/12/2026 4:10:37 PM:BRLENGTH 3
6/12/2026 4:10:37 PM:SCHLENGTH 3
6/12/2026 4:10:37 PM:ACLENGTH 6
6/12/2026 4:10:37 PM:Branch Code 3
6/12/2026 4:10:37 PM:Scheme Code 3
6/12/2026 4:10:37 PM:Account No 3
6/12/2026 4:10:37 PM:Link Main Started
6/12/2026 4:10:37 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 4:10:37 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 4:10:37 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|011946|SB |001
6/12/2026 4:10:37 PM:SMS Inserted for Mobile Number : +919611367485
6/12/2026 4:10:37 PM:Inward Process Executed Sussefully
6/12/2026 4:10:37 PM:ConfirmationReq Execution Success with Status 000
6/12/2026 4:10:37 PM:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM16308232194|002001000095 ------------------------------>
6/12/2026 4:10:37 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 4:10:37 PM:Vno --->:85603
6/12/2026 4:10:37 PM:Current Date  --->:6/12/2026
6/12/2026 4:10:37 PM:calling  CallNewRtgsBothProc 
6/12/2026 4:10:37 PM:Parameters passing - InwardAuthorise 
6/12/2026 4:10:37 PM: brn =001
6/12/2026 4:10:37 PM: acno =011946
6/12/2026 4:10:37 PM: abbr =SB
6/12/2026 4:10:37 PM: amt.ToString() =908
6/12/2026 4:10:37 PM: traceNo =85603
6/12/2026 4:10:37 PM: narr =NEFT, BY PAYTM PAYMENTS SERVICES LTD-PAYMENT AGGREGATOR ESCROW A/C UTIB0000022 922020004482533
6/12/2026 4:10:37 PM:Transaction Process :  BEFORE CAL PROC:
6/12/2026 4:10:38 PM:Inward Process Executed Sussefully
6/12/2026 4:10:38 PM:ConfirmationReq Execution Success with Status 000
6/12/2026 4:10:38 PM:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM16308232228|001001011946 ------------------------------>
6/12/2026 4:10:38 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 4:10:38 PM:Connection Successfully Opened  : Status OK 
6/12/2026 4:10:38 PM:CBS A/C No : 001001007600
6/12/2026 4:10:38 PM: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
6/12/2026 4:10:38 PM:Record Count : 1
6/12/2026 4:10:38 PM:BRLENGTH 3
6/12/2026 4:10:38 PM:SCHLENGTH 3
6/12/2026 4:10:38 PM:ACLENGTH 6
6/12/2026 4:10:38 PM:Branch Code 3
6/12/2026 4:10:38 PM:Scheme Code 3
6/12/2026 4:10:38 PM:Account No 3
6/12/2026 4:10:38 PM:Link Main Started
6/12/2026 4:10:38 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 4:10:38 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 4:10:38 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|007600|SB |001
6/12/2026 4:10:38 PM:Vno --->:85604
6/12/2026 4:10:38 PM:Current Date  --->:6/12/2026
6/12/2026 4:10:38 PM:SMS Inserted for Mobile Number : +918880882755
6/12/2026 4:10:38 PM:calling  CallNewRtgsBothProc 
6/12/2026 4:10:38 PM:Parameters passing - InwardAuthorise 
6/12/2026 4:10:38 PM: brn =001
6/12/2026 4:10:38 PM: acno =007600
6/12/2026 4:10:38 PM: abbr =SB
6/12/2026 4:10:38 PM: amt.ToString() =708
6/12/2026 4:10:38 PM: traceNo =85604
6/12/2026 4:10:38 PM: narr =NEFT, BY PAYTM PAYMENTS SERVICES LTD-PAYMENT AGGREGATOR ESCROW A/C UTIB0000022 922020004482533
6/12/2026 4:10:38 PM:Transaction Process :  BEFORE CAL PROC:
6/12/2026 4:10:38 PM:Inward Process Executed Sussefully
6/12/2026 4:10:38 PM:ConfirmationReq Execution Success with Status 000
6/12/2026 4:10:38 PM:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM16308232198|001001013661 ------------------------------>
6/12/2026 4:10:38 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 4:10:38 PM:cbs no--->001001007600
6/12/2026 4:10:38 PM:CBS A/C No : 001001007600
6/12/2026 4:10:38 PM: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
6/12/2026 4:10:38 PM:Record Count : 1
6/12/2026 4:10:38 PM:BRLENGTH 3
6/12/2026 4:10:38 PM:SCHLENGTH 3
6/12/2026 4:10:38 PM:ACLENGTH 6
6/12/2026 4:10:38 PM:Branch Code 3
6/12/2026 4:10:38 PM:Scheme Code 3
6/12/2026 4:10:38 PM:Account No 3
6/12/2026 4:10:38 PM:Link Main Started
6/12/2026 4:10:38 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 4:10:38 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 4:10:38 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|007600|SB |001
6/12/2026 4:10:38 PM: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=007600  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=007600  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=007600  AND ADDR_SNO=CLMS_ADDRESS
6/12/2026 4:10:38 PM:closed y n Record count --->1
6/12/2026 4:10:38 PM:SMS Inserted for Mobile Number : +918197548955
6/12/2026 4:10:38 PM:Inward Process Executed Sussefully
6/12/2026 4:10:38 PM:ConfirmationReq Execution Success with Status 000
6/12/2026 4:10:38 PM:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM16308232203|001001007600 ------------------------------>
6/12/2026 4:10:38 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 4:10:38 PM:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM16308230908|001001011330 -------------------------->
6/12/2026 4:10:38 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 4:10:38 PM:Connection Establisment started
6/12/2026 4:10:38 PM:Connection Read From File  : Status OK 
6/12/2026 4:10:38 PM:Connection Successfully Opened  : Status OK 
6/12/2026 4:10:38 PM:ValidateAcNo CBS A/C No : 001001011330
6/12/2026 4:10:38 PM:CBS A/C No : 001001011330
6/12/2026 4:10:38 PM: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
6/12/2026 4:10:38 PM:Record Count : 1
6/12/2026 4:10:38 PM:BRLENGTH 3
6/12/2026 4:10:38 PM:SCHLENGTH 3
6/12/2026 4:10:38 PM:ACLENGTH 6
6/12/2026 4:10:38 PM:Branch Code 3
6/12/2026 4:10:38 PM:Scheme Code 3
6/12/2026 4:10:38 PM:Account No 3
6/12/2026 4:10:38 PM:Link Main Started
6/12/2026 4:10:38 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 4:10:38 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 4:10:38 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|011330|SB |001
6/12/2026 4:10:38 PM:Validation Account Proce Executed with out error Y
6/12/2026 4:10:38 PM:Connection Establisment started
6/12/2026 4:10:38 PM:Connection Read From File  : Status OK 
6/12/2026 4:10:38 PM:Connection Successfully Opened  : Status OK 
6/12/2026 4:10:38 PM:CBS A/C No : 001001011330
6/12/2026 4:10:38 PM: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
6/12/2026 4:10:38 PM:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM16308232208|001001002467 -------------------------->
6/12/2026 4:10:38 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 4:10:38 PM:Connection Establisment started
6/12/2026 4:10:38 PM:Connection Read From File  : Status OK 
6/12/2026 4:10:38 PM:Record Count : 1
6/12/2026 4:10:38 PM:BRLENGTH 3
6/12/2026 4:10:38 PM:SCHLENGTH 3
6/12/2026 4:10:38 PM:ACLENGTH 6
6/12/2026 4:10:38 PM:Branch Code 3
6/12/2026 4:10:38 PM:Scheme Code 3
6/12/2026 4:10:38 PM:Account No 3
6/12/2026 4:10:38 PM:Link Main Started
6/12/2026 4:10:38 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 4:10:38 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 4:10:38 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|011330|SB |001
6/12/2026 4:10:38 PM:Vno --->:85605
6/12/2026 4:10:38 PM:Current Date  --->:6/12/2026
6/12/2026 4:10:38 PM:calling  CallNewRtgsBothProc 
6/12/2026 4:10:38 PM:Parameters passing - InwardAuthorise 
6/12/2026 4:10:38 PM: brn =001
6/12/2026 4:10:38 PM: acno =011330
6/12/2026 4:10:38 PM: abbr =SB
6/12/2026 4:10:38 PM: amt.ToString() =2457
6/12/2026 4:10:38 PM: traceNo =85605
6/12/2026 4:10:38 PM: narr =NEFT, BY PAYTM PAYMENTS SERVICES LTD-PAYMENT AGGREGATOR ESCROW A/C UTIB0000022 922020004482533
6/12/2026 4:10:38 PM:Transaction Process :  BEFORE CAL PROC:
6/12/2026 4:10:38 PM:Inward Process Executed Sussefully
6/12/2026 4:10:38 PM:ConfirmationReq Execution Success with Status 000
6/12/2026 4:10:38 PM:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM16308230908|001001011330 ------------------------------>
6/12/2026 4:10:38 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 4:10:38 PM:Connection Successfully Opened  : Status OK 
6/12/2026 4:10:38 PM:ValidateAcNo CBS A/C No : 001001002467
6/12/2026 4:10:38 PM:CBS A/C No : 001001002467
6/12/2026 4:10:38 PM: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
6/12/2026 4:10:38 PM:Record Count : 1
6/12/2026 4:10:38 PM:BRLENGTH 3
6/12/2026 4:10:38 PM:SCHLENGTH 3
6/12/2026 4:10:38 PM:ACLENGTH 6
6/12/2026 4:10:38 PM:Branch Code 3
6/12/2026 4:10:38 PM:Scheme Code 3
6/12/2026 4:10:38 PM:Account No 3
6/12/2026 4:10:38 PM:Link Main Started
6/12/2026 4:10:38 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 4:10:38 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 4:10:38 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|002467|SB |001
6/12/2026 4:10:38 PM:Validation Account Proce Executed with out error Y
6/12/2026 4:10:38 PM:Connection Establisment started
6/12/2026 4:10:38 PM:Connection Read From File  : Status OK 
6/12/2026 4:10:38 PM:Connection Successfully Opened  : Status OK 
6/12/2026 4:10:38 PM:CBS A/C No : 001001002467
6/12/2026 4:10:38 PM: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
6/12/2026 4:10:38 PM:Record Count : 1
6/12/2026 4:10:38 PM:BRLENGTH 3
6/12/2026 4:10:38 PM:SCHLENGTH 3
6/12/2026 4:10:38 PM:ACLENGTH 6
6/12/2026 4:10:38 PM:Branch Code 3
6/12/2026 4:10:38 PM:Scheme Code 3
6/12/2026 4:10:38 PM:Account No 3
6/12/2026 4:10:38 PM:Link Main Started
6/12/2026 4:10:38 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 4:10:38 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 4:10:38 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|002467|SB |001
6/12/2026 4:10:38 PM:Vno --->:85606
6/12/2026 4:10:38 PM:Current Date  --->:6/12/2026
6/12/2026 4:10:38 PM:calling  CallNewRtgsBothProc 
6/12/2026 4:10:38 PM:Parameters passing - InwardAuthorise 
6/12/2026 4:10:38 PM: brn =001
6/12/2026 4:10:38 PM: acno =002467
6/12/2026 4:10:38 PM: abbr =SB
6/12/2026 4:10:38 PM: amt.ToString() =80
6/12/2026 4:10:38 PM: traceNo =85606
6/12/2026 4:10:38 PM: narr =NEFT, BY PAYTM PAYMENTS SERVICES LTD-PAYMENT AGGREGATOR ESCROW A/C UTIB0000022 922020004482533
6/12/2026 4:10:38 PM:Transaction Process :  BEFORE CAL PROC:
6/12/2026 4:10:39 PM:Inward Process Executed Sussefully
6/12/2026 4:10:39 PM:ConfirmationReq Execution Success with Status 000
6/12/2026 4:10:39 PM:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM16308232208|001001002467 ------------------------------>
6/12/2026 4:10:39 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 4:35:48 PM:<------------------------Started ValidationRequest CBS A/C No : 001002000849 ------------------------>
6/12/2026 4:35:48 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 4:35:48 PM:Connection Establisment started
6/12/2026 4:35:48 PM:Connection Read From File  : Status OK 
6/12/2026 4:35:48 PM:Connection Successfully Opened  : Status OK 
6/12/2026 4:35:48 PM:ValidateAcNo CBS A/C No : 001002000849
6/12/2026 4:35:48 PM:CBS A/C No : 001002000849
6/12/2026 4:35:48 PM: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
6/12/2026 4:35:48 PM:Record Count : 1
6/12/2026 4:35:48 PM:BRLENGTH 3
6/12/2026 4:35:48 PM:SCHLENGTH 3
6/12/2026 4:35:48 PM:ACLENGTH 6
6/12/2026 4:35:48 PM:Branch Code 3
6/12/2026 4:35:48 PM:Scheme Code 3
6/12/2026 4:35:48 PM:Account No 3
6/12/2026 4:35:48 PM:Link Main Started
6/12/2026 4:35:48 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
6/12/2026 4:35:48 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 4:35:48 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000849|CD |001
6/12/2026 4:35:48 PM:Validation Account Proce Executed with out error Y
6/12/2026 4:35:48 PM:ValidationRequest Exccution Success with response :  000
6/12/2026 4:35:48 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 5:10:58 PM:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : HDFCH01059780417|001002000849 -------------------------->
6/12/2026 5:10:58 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 5:10:58 PM:Connection Establisment started
6/12/2026 5:10:58 PM:Connection Read From File  : Status OK 
6/12/2026 5:10:58 PM:Connection Successfully Opened  : Status OK 
6/12/2026 5:10:58 PM:ValidateAcNo CBS A/C No : 001002000849
6/12/2026 5:10:58 PM:CBS A/C No : 001002000849
6/12/2026 5:10:58 PM: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
6/12/2026 5:10:58 PM:Record Count : 1
6/12/2026 5:10:58 PM:BRLENGTH 3
6/12/2026 5:10:58 PM:SCHLENGTH 3
6/12/2026 5:10:58 PM:ACLENGTH 6
6/12/2026 5:10:58 PM:Branch Code 3
6/12/2026 5:10:58 PM:Scheme Code 3
6/12/2026 5:10:58 PM:Account No 3
6/12/2026 5:10:58 PM:Link Main Started
6/12/2026 5:10:58 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
6/12/2026 5:10:58 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 5:10:58 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000849|CD |001
6/12/2026 5:10:58 PM:Validation Account Proce Executed with out error Y
6/12/2026 5:10:58 PM:Connection Establisment started
6/12/2026 5:10:58 PM:Connection Read From File  : Status OK 
6/12/2026 5:10:58 PM:Connection Successfully Opened  : Status OK 
6/12/2026 5:10:58 PM:CBS A/C No : 001002000849
6/12/2026 5:10:58 PM: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
6/12/2026 5:10:58 PM:Record Count : 1
6/12/2026 5:10:58 PM:BRLENGTH 3
6/12/2026 5:10:58 PM:SCHLENGTH 3
6/12/2026 5:10:58 PM:ACLENGTH 6
6/12/2026 5:10:58 PM:Branch Code 3
6/12/2026 5:10:58 PM:Scheme Code 3
6/12/2026 5:10:58 PM:Account No 3
6/12/2026 5:10:58 PM:Link Main Started
6/12/2026 5:10:58 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
6/12/2026 5:10:58 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 5:10:58 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000849|CD |001
6/12/2026 5:10:58 PM:Vno --->:85607
6/12/2026 5:10:58 PM:Current Date  --->:6/12/2026
6/12/2026 5:10:58 PM:calling  CallNewRtgsBothProc 
6/12/2026 5:10:58 PM:Parameters passing - InwardAuthorise 
6/12/2026 5:10:58 PM: brn =001
6/12/2026 5:10:58 PM: acno =000849
6/12/2026 5:10:58 PM: abbr =CD
6/12/2026 5:10:58 PM: amt.ToString() =117200
6/12/2026 5:10:58 PM: traceNo =85607
6/12/2026 5:10:58 PM: narr =NEFT, BY SHREE KALIKUND TRADING CO HDFC0000001 06632000002601
6/12/2026 5:10:58 PM:Transaction Process :  BEFORE CAL PROC:
6/12/2026 5:10:58 PM:cbs no--->001002000849
6/12/2026 5:10:58 PM:CBS A/C No : 001002000849
6/12/2026 5:10:58 PM: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
6/12/2026 5:10:58 PM:Record Count : 1
6/12/2026 5:10:58 PM:BRLENGTH 3
6/12/2026 5:10:58 PM:SCHLENGTH 3
6/12/2026 5:10:58 PM:ACLENGTH 6
6/12/2026 5:10:58 PM:Branch Code 3
6/12/2026 5:10:58 PM:Scheme Code 3
6/12/2026 5:10:58 PM:Account No 3
6/12/2026 5:10:58 PM:Link Main Started
6/12/2026 5:10:58 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
6/12/2026 5:10:58 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 5:10:58 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000849|CD |001
6/12/2026 5:10:58 PM: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=000849  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=000849  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=000849  AND ADDR_SNO=CLMS_ADDRESS
6/12/2026 5:10:58 PM:closed y n Record count --->1
6/12/2026 5:10:59 PM:SMS Inserted for Mobile Number : +919972497007
6/12/2026 5:10:59 PM:Inward Process Executed Sussefully
6/12/2026 5:10:59 PM:ConfirmationReq Execution Success with Status 000
6/12/2026 5:10:59 PM:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : HDFCH01059780417|001002000849 ------------------------------>
6/12/2026 5:10:59 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 6:23:28 PM:<------------------------Started ValidationRequest CBS A/C No : 001001012933 ------------------------>
6/12/2026 6:23:28 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 6:23:28 PM:Connection Establisment started
6/12/2026 6:23:28 PM:Connection Read From File  : Status OK 
6/12/2026 6:23:28 PM:Connection Successfully Opened  : Status OK 
6/12/2026 6:23:28 PM:ValidateAcNo CBS A/C No : 001001012933
6/12/2026 6:23:28 PM:CBS A/C No : 001001012933
6/12/2026 6:23:28 PM: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
6/12/2026 6:23:28 PM:Record Count : 1
6/12/2026 6:23:28 PM:BRLENGTH 3
6/12/2026 6:23:28 PM:SCHLENGTH 3
6/12/2026 6:23:28 PM:ACLENGTH 6
6/12/2026 6:23:28 PM:Branch Code 3
6/12/2026 6:23:28 PM:Scheme Code 3
6/12/2026 6:23:28 PM:Account No 3
6/12/2026 6:23:28 PM:Link Main Started
6/12/2026 6:23:28 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 6:23:28 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 6:23:28 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|012933|SB |001
6/12/2026 6:23:28 PM:Validation Account Proce Executed with out error Y
6/12/2026 6:23:28 PM:ValidationRequest Exccution Success with response :  000
6/12/2026 6:23:28 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 6:27:34 PM:<------------------------Started ValidationRequest CBS A/C No : 001002000849 ------------------------>
6/12/2026 6:27:34 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 6:27:34 PM:Connection Establisment started
6/12/2026 6:27:34 PM:Connection Read From File  : Status OK 
6/12/2026 6:27:34 PM:Connection Successfully Opened  : Status OK 
6/12/2026 6:27:34 PM:ValidateAcNo CBS A/C No : 001002000849
6/12/2026 6:27:34 PM:CBS A/C No : 001002000849
6/12/2026 6:27:34 PM: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
6/12/2026 6:27:34 PM:Record Count : 1
6/12/2026 6:27:34 PM:BRLENGTH 3
6/12/2026 6:27:34 PM:SCHLENGTH 3
6/12/2026 6:27:34 PM:ACLENGTH 6
6/12/2026 6:27:34 PM:Branch Code 3
6/12/2026 6:27:34 PM:Scheme Code 3
6/12/2026 6:27:34 PM:Account No 3
6/12/2026 6:27:34 PM:Link Main Started
6/12/2026 6:27:34 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
6/12/2026 6:27:34 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 6:27:34 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000849|CD |001
6/12/2026 6:27:34 PM:Validation Account Proce Executed with out error Y
6/12/2026 6:27:34 PM:ValidationRequest Exccution Success with response :  000
6/12/2026 6:27:34 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 6:45:18 PM:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 0612i7740380711|001001012933 -------------------------->
6/12/2026 6:45:18 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 6:45:18 PM:Connection Establisment started
6/12/2026 6:45:18 PM:Connection Read From File  : Status OK 
6/12/2026 6:45:18 PM:Connection Successfully Opened  : Status OK 
6/12/2026 6:45:18 PM:ValidateAcNo CBS A/C No : 001001012933
6/12/2026 6:45:18 PM:CBS A/C No : 001001012933
6/12/2026 6:45:18 PM: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
6/12/2026 6:45:18 PM:Record Count : 1
6/12/2026 6:45:18 PM:BRLENGTH 3
6/12/2026 6:45:18 PM:SCHLENGTH 3
6/12/2026 6:45:18 PM:ACLENGTH 6
6/12/2026 6:45:18 PM:Branch Code 3
6/12/2026 6:45:18 PM:Scheme Code 3
6/12/2026 6:45:18 PM:Account No 3
6/12/2026 6:45:18 PM:Link Main Started
6/12/2026 6:45:18 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 6:45:18 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 6:45:18 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|012933|SB |001
6/12/2026 6:45:18 PM:Validation Account Proce Executed with out error Y
6/12/2026 6:45:18 PM:Connection Establisment started
6/12/2026 6:45:18 PM:Connection Read From File  : Status OK 
6/12/2026 6:45:18 PM:Connection Successfully Opened  : Status OK 
6/12/2026 6:45:18 PM:CBS A/C No : 001001012933
6/12/2026 6:45:18 PM: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
6/12/2026 6:45:18 PM:Record Count : 1
6/12/2026 6:45:18 PM:BRLENGTH 3
6/12/2026 6:45:18 PM:SCHLENGTH 3
6/12/2026 6:45:18 PM:ACLENGTH 6
6/12/2026 6:45:18 PM:Branch Code 3
6/12/2026 6:45:18 PM:Scheme Code 3
6/12/2026 6:45:18 PM:Account No 3
6/12/2026 6:45:18 PM:Link Main Started
6/12/2026 6:45:18 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 6:45:18 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 6:45:18 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|012933|SB |001
6/12/2026 6:45:18 PM:Vno --->:85608
6/12/2026 6:45:18 PM:Current Date  --->:6/12/2026
6/12/2026 6:45:18 PM:calling  CallNewRtgsBothProc 
6/12/2026 6:45:18 PM:Parameters passing - InwardAuthorise 
6/12/2026 6:45:18 PM: brn =001
6/12/2026 6:45:18 PM: acno =012933
6/12/2026 6:45:18 PM: abbr =SB
6/12/2026 6:45:18 PM: amt.ToString() =47000
6/12/2026 6:45:18 PM: traceNo =85608
6/12/2026 6:45:18 PM: narr =NEFT, BY SMART URBAN COOP CREDIT SOCIETY LTD IBKL0NEFT01 2204102000000073
6/12/2026 6:45:18 PM:Transaction Process :  BEFORE CAL PROC:
6/12/2026 6:45:18 PM:cbs no--->001001012933
6/12/2026 6:45:18 PM:CBS A/C No : 001001012933
6/12/2026 6:45:18 PM: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
6/12/2026 6:45:18 PM:Record Count : 1
6/12/2026 6:45:18 PM:BRLENGTH 3
6/12/2026 6:45:18 PM:SCHLENGTH 3
6/12/2026 6:45:18 PM:ACLENGTH 6
6/12/2026 6:45:18 PM:Branch Code 3
6/12/2026 6:45:18 PM:Scheme Code 3
6/12/2026 6:45:18 PM:Account No 3
6/12/2026 6:45:18 PM:Link Main Started
6/12/2026 6:45:18 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 6:45:18 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 6:45:18 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|012933|SB |001
6/12/2026 6:45:18 PM: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=012933  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=012933  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=012933  AND ADDR_SNO=CLMS_ADDRESS
6/12/2026 6:45:18 PM:closed y n Record count --->1
6/12/2026 6:45:19 PM:SMS Inserted for Mobile Number : +919916189012
6/12/2026 6:45:19 PM:Inward Process Executed Sussefully
6/12/2026 6:45:19 PM:ConfirmationReq Execution Success with Status 000
6/12/2026 6:45:19 PM:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 0612i7740380711|001001012933 ------------------------------>
6/12/2026 6:45:19 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 6:47:16 PM:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : KKBKH26163873047|001002000849 -------------------------->
6/12/2026 6:47:16 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 6:47:16 PM:Connection Establisment started
6/12/2026 6:47:16 PM:Connection Read From File  : Status OK 
6/12/2026 6:47:16 PM:Connection Successfully Opened  : Status OK 
6/12/2026 6:47:16 PM:ValidateAcNo CBS A/C No : 001002000849
6/12/2026 6:47:16 PM:CBS A/C No : 001002000849
6/12/2026 6:47:16 PM: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
6/12/2026 6:47:16 PM:Record Count : 1
6/12/2026 6:47:16 PM:BRLENGTH 3
6/12/2026 6:47:16 PM:SCHLENGTH 3
6/12/2026 6:47:16 PM:ACLENGTH 6
6/12/2026 6:47:16 PM:Branch Code 3
6/12/2026 6:47:16 PM:Scheme Code 3
6/12/2026 6:47:16 PM:Account No 3
6/12/2026 6:47:16 PM:Link Main Started
6/12/2026 6:47:16 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
6/12/2026 6:47:16 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 6:47:16 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000849|CD |001
6/12/2026 6:47:16 PM:Validation Account Proce Executed with out error Y
6/12/2026 6:47:16 PM:Connection Establisment started
6/12/2026 6:47:16 PM:Connection Read From File  : Status OK 
6/12/2026 6:47:16 PM:Connection Successfully Opened  : Status OK 
6/12/2026 6:47:16 PM:CBS A/C No : 001002000849
6/12/2026 6:47:16 PM: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
6/12/2026 6:47:16 PM:Record Count : 1
6/12/2026 6:47:16 PM:BRLENGTH 3
6/12/2026 6:47:16 PM:SCHLENGTH 3
6/12/2026 6:47:16 PM:ACLENGTH 6
6/12/2026 6:47:16 PM:Branch Code 3
6/12/2026 6:47:16 PM:Scheme Code 3
6/12/2026 6:47:16 PM:Account No 3
6/12/2026 6:47:16 PM:Link Main Started
6/12/2026 6:47:16 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
6/12/2026 6:47:16 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 6:47:16 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000849|CD |001
6/12/2026 6:47:16 PM:Vno --->:85609
6/12/2026 6:47:16 PM:Current Date  --->:6/12/2026
6/12/2026 6:47:16 PM:calling  CallNewRtgsBothProc 
6/12/2026 6:47:16 PM:Parameters passing - InwardAuthorise 
6/12/2026 6:47:16 PM: brn =001
6/12/2026 6:47:16 PM: acno =000849
6/12/2026 6:47:16 PM: abbr =CD
6/12/2026 6:47:16 PM: amt.ToString() =113750
6/12/2026 6:47:16 PM: traceNo =85609
6/12/2026 6:47:16 PM: narr =NEFT, BY HIRALAL POKHRAJ  CO KKBK0000958 1850390990
6/12/2026 6:47:16 PM:Transaction Process :  BEFORE CAL PROC:
6/12/2026 6:47:16 PM:cbs no--->001002000849
6/12/2026 6:47:16 PM:CBS A/C No : 001002000849
6/12/2026 6:47:16 PM: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
6/12/2026 6:47:16 PM:Record Count : 1
6/12/2026 6:47:16 PM:BRLENGTH 3
6/12/2026 6:47:16 PM:SCHLENGTH 3
6/12/2026 6:47:16 PM:ACLENGTH 6
6/12/2026 6:47:16 PM:Branch Code 3
6/12/2026 6:47:16 PM:Scheme Code 3
6/12/2026 6:47:16 PM:Account No 3
6/12/2026 6:47:16 PM:Link Main Started
6/12/2026 6:47:16 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
6/12/2026 6:47:16 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 6:47:16 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000849|CD |001
6/12/2026 6:47:16 PM: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=000849  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=000849  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=000849  AND ADDR_SNO=CLMS_ADDRESS
6/12/2026 6:47:16 PM:closed y n Record count --->1
6/12/2026 6:47:16 PM:SMS Inserted for Mobile Number : +919972497007
6/12/2026 6:47:16 PM:Inward Process Executed Sussefully
6/12/2026 6:47:16 PM:ConfirmationReq Execution Success with Status 000
6/12/2026 6:47:16 PM:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : KKBKH26163873047|001002000849 ------------------------------>
6/12/2026 6:47:16 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 6:57:23 PM:<------------------------Started ValidationRequest CBS A/C No : 001001013191 ------------------------>
6/12/2026 6:57:23 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 6:57:23 PM:Connection Establisment started
6/12/2026 6:57:23 PM:Connection Read From File  : Status OK 
6/12/2026 6:57:23 PM:Connection Successfully Opened  : Status OK 
6/12/2026 6:57:23 PM:ValidateAcNo CBS A/C No : 001001013191
6/12/2026 6:57:23 PM:CBS A/C No : 001001013191
6/12/2026 6:57:23 PM: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
6/12/2026 6:57:23 PM:Record Count : 1
6/12/2026 6:57:23 PM:BRLENGTH 3
6/12/2026 6:57:23 PM:SCHLENGTH 3
6/12/2026 6:57:23 PM:ACLENGTH 6
6/12/2026 6:57:23 PM:Branch Code 3
6/12/2026 6:57:23 PM:Scheme Code 3
6/12/2026 6:57:23 PM:Account No 3
6/12/2026 6:57:23 PM:Link Main Started
6/12/2026 6:57:23 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 6:57:23 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 6:57:23 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|013191|SB |001
6/12/2026 6:57:23 PM:Validation Account Proce Executed with out error Y
6/12/2026 6:57:23 PM:ValidationRequest Exccution Success with response :  000
6/12/2026 6:57:23 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 7:12:51 PM:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : IN22616324815324|001001013191 -------------------------->
6/12/2026 7:12:51 PM:<------------------------------------------------------------------------------------------------------------------------>
6/12/2026 7:12:51 PM:Connection Establisment started
6/12/2026 7:12:51 PM:Connection Read From File  : Status OK 
6/12/2026 7:12:51 PM:Connection Successfully Opened  : Status OK 
6/12/2026 7:12:51 PM:ValidateAcNo CBS A/C No : 001001013191
6/12/2026 7:12:51 PM:CBS A/C No : 001001013191
6/12/2026 7:12:51 PM: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
6/12/2026 7:12:51 PM:Record Count : 1
6/12/2026 7:12:51 PM:BRLENGTH 3
6/12/2026 7:12:51 PM:SCHLENGTH 3
6/12/2026 7:12:51 PM:ACLENGTH 6
6/12/2026 7:12:51 PM:Branch Code 3
6/12/2026 7:12:51 PM:Scheme Code 3
6/12/2026 7:12:51 PM:Account No 3
6/12/2026 7:12:51 PM:Link Main Started
6/12/2026 7:12:51 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 7:12:51 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 7:12:51 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|013191|SB |001
6/12/2026 7:12:51 PM:Validation Account Proce Executed with out error Y
6/12/2026 7:12:51 PM:Connection Establisment started
6/12/2026 7:12:51 PM:Connection Read From File  : Status OK 
6/12/2026 7:12:51 PM:Connection Successfully Opened  : Status OK 
6/12/2026 7:12:51 PM:CBS A/C No : 001001013191
6/12/2026 7:12:51 PM: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
6/12/2026 7:12:51 PM:Record Count : 1
6/12/2026 7:12:51 PM:BRLENGTH 3
6/12/2026 7:12:51 PM:SCHLENGTH 3
6/12/2026 7:12:51 PM:ACLENGTH 6
6/12/2026 7:12:51 PM:Branch Code 3
6/12/2026 7:12:51 PM:Scheme Code 3
6/12/2026 7:12:51 PM:Account No 3
6/12/2026 7:12:51 PM:Link Main Started
6/12/2026 7:12:51 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
6/12/2026 7:12:51 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
6/12/2026 7:12:51 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|013191|SB |001
6/12/2026 7:12:51 PM:Vno --->:85610
6/12/2026 7:12:51 PM:Current Date  --->:6/12/2026
6/12/2026 7:12:51 PM:calling  CallNewRtgsBothProc 
6/12/2026 7:12:51 PM:Parameters passing - InwardAuthorise 
6/12/2026 7:12:51 PM: brn =001
6/12/2026 7:12:51 PM: acno =013191
6/12/2026 7:12:51 PM: abbr =SB
6/12/2026 7:12:51 PM: amt.ToString() =2826.84
6/12/2026 7:12:51 PM: traceNo =85610
6/12/2026 7:12:51 PM: narr =NEFT, BY LENDENCLUB BORROWER REPAYMENT ISP LTD ACCOUNT ICIC0099999 0104SLNEFTPL
6/12/2026 7:12:51 PM:Transaction Process :  BEFORE CAL PROC:
6/12/2026 7:12:51 PM:Inward Process Executed Sussefully
6/12/2026 7:12:51 PM:ConfirmationReq Execution Success with Status 000
6/12/2026 7:12:51 PM:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : IN22616324815324|001001013191 ------------------------------>
6/12/2026 7:12:51 PM:<------------------------------------------------------------------------------------------------------------------------>