4/1/2026 3:17:50 AM:<------------------------Started ValidationRequest CBS A/C No : 0000001001013407 ------------------------>
4/1/2026 3:17:50 AM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 3:17:50 AM:Connection Establisment started
4/1/2026 3:17:50 AM:Connection Read From File  : Status OK 
4/1/2026 3:17:50 AM:<------------------------Started ValidationRequest CBS A/C No : 001001012012 ------------------------>
4/1/2026 3:17:50 AM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 3:17:50 AM:Connection Establisment started
4/1/2026 3:17:50 AM:Connection Read From File  : Status OK 
4/1/2026 3:17:50 AM:Connection Successfully Opened  : Status OK 
4/1/2026 3:17:50 AM:ValidateAcNo CBS A/C No : 0000001001013407
4/1/2026 3:17:50 AM:Validation Account Proce Executed with out error N
4/1/2026 3:17:50 AM:ValidationRequest Exccution Success with response :  111
4/1/2026 3:17:50 AM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 3:17:50 AM:Connection Successfully Opened  : Status OK 
4/1/2026 3:17:50 AM:ValidateAcNo CBS A/C No : 001001012012
4/1/2026 3:17:50 AM:CBS A/C No : 001001012012
4/1/2026 3:17:50 AM: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
4/1/2026 3:17:50 AM:Record Count : 1
4/1/2026 3:17:50 AM:BRLENGTH 3
4/1/2026 3:17:50 AM:SCHLENGTH 3
4/1/2026 3:17:50 AM:ACLENGTH 6
4/1/2026 3:17:50 AM:Branch Code 3
4/1/2026 3:17:50 AM:Scheme Code 3
4/1/2026 3:17:50 AM:Account No 3
4/1/2026 3:17:50 AM:Link Main Started
4/1/2026 3:17:50 AM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
4/1/2026 3:17:50 AM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 3:17:50 AM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|012012|SB |001
4/1/2026 3:17:50 AM:Validation Account Proce Executed with out error Y
4/1/2026 3:17:50 AM:ValidationRequest Exccution Success with response :  000
4/1/2026 3:17:50 AM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 3:40:12 AM:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : YESAP60911716328|001001012012 -------------------------->
4/1/2026 3:40:12 AM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 3:40:12 AM:Connection Establisment started
4/1/2026 3:40:12 AM:Connection Read From File  : Status OK 
4/1/2026 3:40:12 AM:Connection Successfully Opened  : Status OK 
4/1/2026 3:40:12 AM:ValidateAcNo CBS A/C No : 001001012012
4/1/2026 3:40:12 AM:CBS A/C No : 001001012012
4/1/2026 3:40:12 AM: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
4/1/2026 3:40:12 AM:Record Count : 1
4/1/2026 3:40:12 AM:BRLENGTH 3
4/1/2026 3:40:12 AM:SCHLENGTH 3
4/1/2026 3:40:12 AM:ACLENGTH 6
4/1/2026 3:40:12 AM:Branch Code 3
4/1/2026 3:40:12 AM:Scheme Code 3
4/1/2026 3:40:12 AM:Account No 3
4/1/2026 3:40:12 AM:Link Main Started
4/1/2026 3:40:12 AM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
4/1/2026 3:40:12 AM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 3:40:12 AM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|012012|SB |001
4/1/2026 3:40:12 AM:Validation Account Proce Executed with out error Y
4/1/2026 3:40:12 AM:Connection Establisment started
4/1/2026 3:40:12 AM:Connection Read From File  : Status OK 
4/1/2026 3:40:12 AM:Connection Successfully Opened  : Status OK 
4/1/2026 3:40:12 AM:CBS A/C No : 001001012012
4/1/2026 3:40:12 AM: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
4/1/2026 3:40:12 AM:Record Count : 1
4/1/2026 3:40:12 AM:BRLENGTH 3
4/1/2026 3:40:12 AM:SCHLENGTH 3
4/1/2026 3:40:12 AM:ACLENGTH 6
4/1/2026 3:40:12 AM:Branch Code 3
4/1/2026 3:40:12 AM:Scheme Code 3
4/1/2026 3:40:12 AM:Account No 3
4/1/2026 3:40:12 AM:Link Main Started
4/1/2026 3:40:12 AM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
4/1/2026 3:40:12 AM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 3:40:12 AM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|012012|SB |001
4/1/2026 3:40:12 AM:Vno --->:82243
4/1/2026 3:40:12 AM:Current Date  --->:4/1/2026
4/1/2026 3:40:12 AM:calling  CallNewRtgsBothProc 
4/1/2026 3:40:12 AM:Parameters passing - InwardAuthorise 
4/1/2026 3:40:12 AM: brn =001
4/1/2026 3:40:12 AM: acno =012012
4/1/2026 3:40:12 AM: abbr =SB
4/1/2026 3:40:12 AM: amt.ToString() =1519
4/1/2026 3:40:12 AM: traceNo =82243
4/1/2026 3:40:12 AM: narr =NEFT, BY RESILIENT INNOVATIONS PRIVATE LIMIT YESB0000001 010577900000019
4/1/2026 3:40:12 AM:Transaction Process :  BEFORE CAL PROC:
4/1/2026 3:40:12 AM:Inward Process Executed Sussefully
4/1/2026 3:40:12 AM:ConfirmationReq Execution Success with Status 000
4/1/2026 3:40:12 AM:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : YESAP60911716328|001001012012 ------------------------------>
4/1/2026 3:40:12 AM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 8:49:10 PM:<------------------------Started ValidationRequest CBS A/C No : 001002000868 ------------------------>
4/1/2026 8:49:10 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 8:49:10 PM:Connection Establisment started
4/1/2026 8:49:10 PM:Connection Read From File  : Status OK 
4/1/2026 8:49:10 PM:Connection Successfully Opened  : Status OK 
4/1/2026 8:49:10 PM:ValidateAcNo CBS A/C No : 001002000868
4/1/2026 8:49:10 PM:CBS A/C No : 001002000868
4/1/2026 8:49:10 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
4/1/2026 8:49:10 PM:Record Count : 1
4/1/2026 8:49:10 PM:BRLENGTH 3
4/1/2026 8:49:10 PM:SCHLENGTH 3
4/1/2026 8:49:10 PM:ACLENGTH 6
4/1/2026 8:49:10 PM:Branch Code 3
4/1/2026 8:49:10 PM:Scheme Code 3
4/1/2026 8:49:10 PM:Account No 3
4/1/2026 8:49:10 PM:Link Main Started
4/1/2026 8:49:10 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
4/1/2026 8:49:10 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 8:49:10 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000868|CD |001
4/1/2026 8:49:10 PM:Validation Account Proce Executed with out error Y
4/1/2026 8:49:10 PM:ValidationRequest Exccution Success with response :  000
4/1/2026 8:49:10 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 8:51:02 PM:<------------------------Started ValidationRequest CBS A/C No : 001001013191 ------------------------>
4/1/2026 8:51:02 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 8:51:02 PM:Connection Establisment started
4/1/2026 8:51:02 PM:Connection Read From File  : Status OK 
4/1/2026 8:51:02 PM:Connection Successfully Opened  : Status OK 
4/1/2026 8:51:02 PM:ValidateAcNo CBS A/C No : 001001013191
4/1/2026 8:51:02 PM:CBS A/C No : 001001013191
4/1/2026 8:51:02 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
4/1/2026 8:51:02 PM:Record Count : 1
4/1/2026 8:51:02 PM:BRLENGTH 3
4/1/2026 8:51:02 PM:SCHLENGTH 3
4/1/2026 8:51:02 PM:ACLENGTH 6
4/1/2026 8:51:02 PM:Branch Code 3
4/1/2026 8:51:02 PM:Scheme Code 3
4/1/2026 8:51:02 PM:Account No 3
4/1/2026 8:51:02 PM:Link Main Started
4/1/2026 8:51:02 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
4/1/2026 8:51:02 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 8:51:02 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|013191|SB |001
4/1/2026 8:51:02 PM:Validation Account Proce Executed with out error Y
4/1/2026 8:51:02 PM:ValidationRequest Exccution Success with response :  000
4/1/2026 8:51:02 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 9:00:16 PM:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : SBIN226091732874|001002000868 -------------------------->
4/1/2026 9:00:16 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 9:00:16 PM:Connection Establisment started
4/1/2026 9:00:16 PM:Connection Read From File  : Status OK 
4/1/2026 9:00:16 PM:Connection Successfully Opened  : Status OK 
4/1/2026 9:00:16 PM:ValidateAcNo CBS A/C No : 001002000868
4/1/2026 9:00:16 PM:CBS A/C No : 001002000868
4/1/2026 9:00: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
4/1/2026 9:00:16 PM:Record Count : 1
4/1/2026 9:00:16 PM:BRLENGTH 3
4/1/2026 9:00:16 PM:SCHLENGTH 3
4/1/2026 9:00:16 PM:ACLENGTH 6
4/1/2026 9:00:16 PM:Branch Code 3
4/1/2026 9:00:16 PM:Scheme Code 3
4/1/2026 9:00:16 PM:Account No 3
4/1/2026 9:00:16 PM:Link Main Started
4/1/2026 9:00: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 
4/1/2026 9:00:16 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 9:00:16 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000868|CD |001
4/1/2026 9:00:16 PM:Validation Account Proce Executed with out error Y
4/1/2026 9:00:16 PM:Connection Establisment started
4/1/2026 9:00:16 PM:Connection Read From File  : Status OK 
4/1/2026 9:00:16 PM:Connection Successfully Opened  : Status OK 
4/1/2026 9:00:16 PM:CBS A/C No : 001002000868
4/1/2026 9:00: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
4/1/2026 9:00:16 PM:Record Count : 1
4/1/2026 9:00:16 PM:BRLENGTH 3
4/1/2026 9:00:16 PM:SCHLENGTH 3
4/1/2026 9:00:16 PM:ACLENGTH 6
4/1/2026 9:00:16 PM:Branch Code 3
4/1/2026 9:00:16 PM:Scheme Code 3
4/1/2026 9:00:16 PM:Account No 3
4/1/2026 9:00:16 PM:Link Main Started
4/1/2026 9:00: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 
4/1/2026 9:00:16 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 9:00:16 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000868|CD |001
4/1/2026 9:00:16 PM:Vno --->:82244
4/1/2026 9:00:16 PM:Current Date  --->:4/1/2026
4/1/2026 9:00:16 PM:calling  CallNewRtgsBothProc 
4/1/2026 9:00:16 PM:Parameters passing - InwardAuthorise 
4/1/2026 9:00:16 PM: brn =001
4/1/2026 9:00:16 PM: acno =000868
4/1/2026 9:00:16 PM: abbr =CD
4/1/2026 9:00:16 PM: amt.ToString() =31329
4/1/2026 9:00:16 PM: traceNo =82244
4/1/2026 9:00:16 PM: narr =NEFT, BY NAGSHANTI ENTERPRISES PVT LTD SBIN0004266 00000030291709361
4/1/2026 9:00:16 PM:Transaction Process :  BEFORE CAL PROC:
4/1/2026 9:00:16 PM:cbs no--->001002000868
4/1/2026 9:00:16 PM:CBS A/C No : 001002000868
4/1/2026 9:00: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
4/1/2026 9:00:16 PM:Record Count : 1
4/1/2026 9:00:16 PM:BRLENGTH 3
4/1/2026 9:00:16 PM:SCHLENGTH 3
4/1/2026 9:00:16 PM:ACLENGTH 6
4/1/2026 9:00:16 PM:Branch Code 3
4/1/2026 9:00:16 PM:Scheme Code 3
4/1/2026 9:00:16 PM:Account No 3
4/1/2026 9:00:16 PM:Link Main Started
4/1/2026 9:00: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 
4/1/2026 9:00:16 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 9:00:16 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000868|CD |001
4/1/2026 9:00: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=000868  AND ADDR_SNO=CLMS_ADDRESS union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG,LSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM  clientmaster,LOANMASTER,LOANSCHEMESETUP,ADDRESS  where CLMS_SNO=LOAM_CLIENT  AND LSCH_BRANCH = LOAM_BRANCH AND LSCH_ABBREV = LOAM_ABBR and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='CD'  AND LOAM_NO=000868  AND ADDR_SNO=CLMS_ADDRESS UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG,ODST_GLLINK AS GLLINK,ADDR_MOBILENO FROM  clientmaster,ODMASTER,ODSCHEMESETUP,ADDRESS  where CLMS_SNO=ODMT_CLIENT AND ODST_BRANCH = ODMT_BRANCH AND ODST_ABBR = ODMT_ABBR and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='CD'  AND ODMT_NO=000868  AND ADDR_SNO=CLMS_ADDRESS
4/1/2026 9:00:16 PM:closed y n Record count --->1
4/1/2026 9:00:16 PM:SMS Inserted for Mobile Number : +919448051124
4/1/2026 9:00:16 PM:Inward Process Executed Sussefully
4/1/2026 9:00:16 PM:ConfirmationReq Execution Success with Status 000
4/1/2026 9:00:16 PM:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : SBIN226091732874|001002000868 ------------------------------>
4/1/2026 9:00:16 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 9:00:21 PM:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : IN22609104772283|001001013191 -------------------------->
4/1/2026 9:00:21 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 9:00:21 PM:Connection Establisment started
4/1/2026 9:00:21 PM:Connection Read From File  : Status OK 
4/1/2026 9:00:21 PM:Connection Successfully Opened  : Status OK 
4/1/2026 9:00:21 PM:ValidateAcNo CBS A/C No : 001001013191
4/1/2026 9:00:21 PM:CBS A/C No : 001001013191
4/1/2026 9:00:21 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
4/1/2026 9:00:21 PM:Record Count : 1
4/1/2026 9:00:21 PM:BRLENGTH 3
4/1/2026 9:00:21 PM:SCHLENGTH 3
4/1/2026 9:00:21 PM:ACLENGTH 6
4/1/2026 9:00:21 PM:Branch Code 3
4/1/2026 9:00:21 PM:Scheme Code 3
4/1/2026 9:00:21 PM:Account No 3
4/1/2026 9:00:21 PM:Link Main Started
4/1/2026 9:00:21 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
4/1/2026 9:00:21 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 9:00:21 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|013191|SB |001
4/1/2026 9:00:21 PM:Validation Account Proce Executed with out error Y
4/1/2026 9:00:21 PM:Connection Establisment started
4/1/2026 9:00:21 PM:Connection Read From File  : Status OK 
4/1/2026 9:00:21 PM:Connection Successfully Opened  : Status OK 
4/1/2026 9:00:21 PM:CBS A/C No : 001001013191
4/1/2026 9:00:21 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
4/1/2026 9:00:21 PM:Record Count : 1
4/1/2026 9:00:21 PM:BRLENGTH 3
4/1/2026 9:00:21 PM:SCHLENGTH 3
4/1/2026 9:00:21 PM:ACLENGTH 6
4/1/2026 9:00:21 PM:Branch Code 3
4/1/2026 9:00:21 PM:Scheme Code 3
4/1/2026 9:00:21 PM:Account No 3
4/1/2026 9:00:21 PM:Link Main Started
4/1/2026 9:00:21 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
4/1/2026 9:00:21 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 9:00:21 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|013191|SB |001
4/1/2026 9:00:21 PM:Vno --->:82245
4/1/2026 9:00:21 PM:Current Date  --->:4/1/2026
4/1/2026 9:00:21 PM:calling  CallNewRtgsBothProc 
4/1/2026 9:00:21 PM:Parameters passing - InwardAuthorise 
4/1/2026 9:00:21 PM: brn =001
4/1/2026 9:00:21 PM: acno =013191
4/1/2026 9:00:21 PM: abbr =SB
4/1/2026 9:00:21 PM: amt.ToString() =3.28
4/1/2026 9:00:21 PM: traceNo =82245
4/1/2026 9:00:21 PM: narr =NEFT, BY LENDENCLUB BORROWER REPAYMENT ISP LTD ACCOUNT ICIC0099999 0104SLNEFTPL
4/1/2026 9:00:21 PM:Transaction Process :  BEFORE CAL PROC:
4/1/2026 9:00:21 PM:Inward Process Executed Sussefully
4/1/2026 9:00:21 PM:ConfirmationReq Execution Success with Status 000
4/1/2026 9:00:21 PM:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : IN22609104772283|001001013191 ------------------------------>
4/1/2026 9:00:21 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 9:07:23 PM:<------------------------Started ValidationRequest CBS A/C No : 001001006185 ------------------------>
4/1/2026 9:07:23 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 9:07:23 PM:Connection Establisment started
4/1/2026 9:07:23 PM:Connection Read From File  : Status OK 
4/1/2026 9:07:23 PM:Connection Successfully Opened  : Status OK 
4/1/2026 9:07:23 PM:ValidateAcNo CBS A/C No : 001001006185
4/1/2026 9:07:23 PM:CBS A/C No : 001001006185
4/1/2026 9:07: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
4/1/2026 9:07:23 PM:Record Count : 1
4/1/2026 9:07:23 PM:BRLENGTH 3
4/1/2026 9:07:23 PM:SCHLENGTH 3
4/1/2026 9:07:23 PM:ACLENGTH 6
4/1/2026 9:07:23 PM:Branch Code 3
4/1/2026 9:07:23 PM:Scheme Code 3
4/1/2026 9:07:23 PM:Account No 3
4/1/2026 9:07:23 PM:Link Main Started
4/1/2026 9:07: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 
4/1/2026 9:07:23 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 9:07:23 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|006185|SB |001
4/1/2026 9:07:23 PM:Validation Account Proce Executed with out error Y
4/1/2026 9:07:23 PM:ValidationRequest Exccution Success with response :  000
4/1/2026 9:07:23 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 9:10:50 PM:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : BARBS26092461540|001001006185 -------------------------->
4/1/2026 9:10:50 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 9:10:50 PM:Connection Establisment started
4/1/2026 9:10:50 PM:Connection Read From File  : Status OK 
4/1/2026 9:10:50 PM:Connection Successfully Opened  : Status OK 
4/1/2026 9:10:50 PM:ValidateAcNo CBS A/C No : 001001006185
4/1/2026 9:10:50 PM:CBS A/C No : 001001006185
4/1/2026 9:10:50 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
4/1/2026 9:10:50 PM:Record Count : 1
4/1/2026 9:10:50 PM:BRLENGTH 3
4/1/2026 9:10:50 PM:SCHLENGTH 3
4/1/2026 9:10:50 PM:ACLENGTH 6
4/1/2026 9:10:50 PM:Branch Code 3
4/1/2026 9:10:50 PM:Scheme Code 3
4/1/2026 9:10:50 PM:Account No 3
4/1/2026 9:10:50 PM:Link Main Started
4/1/2026 9:10:50 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
4/1/2026 9:10:50 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 9:10:50 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|006185|SB |001
4/1/2026 9:10:50 PM:Validation Account Proce Executed with out error Y
4/1/2026 9:10:50 PM:Connection Establisment started
4/1/2026 9:10:50 PM:Connection Read From File  : Status OK 
4/1/2026 9:10:50 PM:Connection Successfully Opened  : Status OK 
4/1/2026 9:10:50 PM:CBS A/C No : 001001006185
4/1/2026 9:10:50 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
4/1/2026 9:10:50 PM:Record Count : 1
4/1/2026 9:10:50 PM:BRLENGTH 3
4/1/2026 9:10:50 PM:SCHLENGTH 3
4/1/2026 9:10:50 PM:ACLENGTH 6
4/1/2026 9:10:50 PM:Branch Code 3
4/1/2026 9:10:50 PM:Scheme Code 3
4/1/2026 9:10:50 PM:Account No 3
4/1/2026 9:10:50 PM:Link Main Started
4/1/2026 9:10:50 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
4/1/2026 9:10:50 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 9:10:50 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|006185|SB |001
4/1/2026 9:10:50 PM:Vno --->:82246
4/1/2026 9:10:50 PM:Current Date  --->:4/1/2026
4/1/2026 9:10:50 PM:calling  CallNewRtgsBothProc 
4/1/2026 9:10:50 PM:Parameters passing - InwardAuthorise 
4/1/2026 9:10:50 PM: brn =001
4/1/2026 9:10:50 PM: acno =006185
4/1/2026 9:10:50 PM: abbr =SB
4/1/2026 9:10:50 PM: amt.ToString() =18000
4/1/2026 9:10:50 PM: traceNo =82246
4/1/2026 9:10:50 PM: narr =NEFT, BY NEW  DECENT  STATIONERIES BARB0VJKESH 89500200000258
4/1/2026 9:10:50 PM:Transaction Process :  BEFORE CAL PROC:
4/1/2026 9:10:50 PM:cbs no--->001001006185
4/1/2026 9:10:50 PM:CBS A/C No : 001001006185
4/1/2026 9:10:50 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
4/1/2026 9:10:50 PM:Record Count : 1
4/1/2026 9:10:50 PM:BRLENGTH 3
4/1/2026 9:10:50 PM:SCHLENGTH 3
4/1/2026 9:10:50 PM:ACLENGTH 6
4/1/2026 9:10:50 PM:Branch Code 3
4/1/2026 9:10:50 PM:Scheme Code 3
4/1/2026 9:10:50 PM:Account No 3
4/1/2026 9:10:50 PM:Link Main Started
4/1/2026 9:10:50 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
4/1/2026 9:10:50 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 9:10:50 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|006185|SB |001
4/1/2026 9:10:50 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=006185  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=006185  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=006185  AND ADDR_SNO=CLMS_ADDRESS
4/1/2026 9:10:50 PM:closed y n Record count --->1
4/1/2026 9:10:50 PM:SMS Inserted for Mobile Number : +919448135758
4/1/2026 9:10:50 PM:Inward Process Executed Sussefully
4/1/2026 9:10:50 PM:ConfirmationReq Execution Success with Status 000
4/1/2026 9:10:50 PM:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : BARBS26092461540|001001006185 ------------------------------>
4/1/2026 9:10:50 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 9:30:55 PM:<------------------------Started ValidationRequest CBS A/C No : 0000001001014045 ------------------------>
4/1/2026 9:30:55 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 9:30:55 PM:Connection Establisment started
4/1/2026 9:30:55 PM:Connection Read From File  : Status OK 
4/1/2026 9:30:55 PM:Connection Successfully Opened  : Status OK 
4/1/2026 9:30:55 PM:ValidateAcNo CBS A/C No : 0000001001014045
4/1/2026 9:30:55 PM:Validation Account Proce Executed with out error N
4/1/2026 9:30:55 PM:ValidationRequest Exccution Success with response :  111
4/1/2026 9:30:55 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:24:30 PM:<------------------------Started ValidationRequest CBS A/C No : 001001009761 ------------------------>
4/1/2026 10:24:30 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:24:30 PM:Connection Establisment started
4/1/2026 10:24:30 PM:Connection Read From File  : Status OK 
4/1/2026 10:24:30 PM:Connection Successfully Opened  : Status OK 
4/1/2026 10:24:30 PM:ValidateAcNo CBS A/C No : 001001009761
4/1/2026 10:24:30 PM:CBS A/C No : 001001009761
4/1/2026 10:24:30 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
4/1/2026 10:24:30 PM:Record Count : 1
4/1/2026 10:24:30 PM:BRLENGTH 3
4/1/2026 10:24:30 PM:SCHLENGTH 3
4/1/2026 10:24:30 PM:ACLENGTH 6
4/1/2026 10:24:30 PM:Branch Code 3
4/1/2026 10:24:30 PM:Scheme Code 3
4/1/2026 10:24:30 PM:Account No 3
4/1/2026 10:24:30 PM:Link Main Started
4/1/2026 10:24:30 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
4/1/2026 10:24:30 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:24:30 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|009761|SB |001
4/1/2026 10:24:30 PM:Validation Account Proce Executed with out error Y
4/1/2026 10:24:30 PM:ValidationRequest Exccution Success with response :  000
4/1/2026 10:24:30 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:25:24 PM:<------------------------Started ValidationRequest CBS A/C No : 001001009242 ------------------------>
4/1/2026 10:25:24 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:25:24 PM:Connection Establisment started
4/1/2026 10:25:24 PM:Connection Read From File  : Status OK 
4/1/2026 10:25:24 PM:<------------------------Started ValidationRequest CBS A/C No : 001022000085 ------------------------>
4/1/2026 10:25:24 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:25:24 PM:Connection Establisment started
4/1/2026 10:25:24 PM:Connection Read From File  : Status OK 
4/1/2026 10:25:24 PM:Connection Successfully Opened  : Status OK 
4/1/2026 10:25:24 PM:ValidateAcNo CBS A/C No : 001001009242
4/1/2026 10:25:24 PM:CBS A/C No : 001001009242
4/1/2026 10:25:24 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
4/1/2026 10:25:24 PM:Record Count : 1
4/1/2026 10:25:24 PM:BRLENGTH 3
4/1/2026 10:25:24 PM:SCHLENGTH 3
4/1/2026 10:25:24 PM:ACLENGTH 6
4/1/2026 10:25:24 PM:Branch Code 3
4/1/2026 10:25:24 PM:Scheme Code 3
4/1/2026 10:25:24 PM:Account No 3
4/1/2026 10:25:24 PM:Link Main Started
4/1/2026 10:25:24 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
4/1/2026 10:25:24 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:25:24 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|009242|SB |001
4/1/2026 10:25:24 PM:Validation Account Proce Executed with out error Y
4/1/2026 10:25:24 PM:ValidationRequest Exccution Success with response :  000
4/1/2026 10:25:24 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:25:24 PM:Connection Successfully Opened  : Status OK 
4/1/2026 10:25:24 PM:ValidateAcNo CBS A/C No : 001022000085
4/1/2026 10:25:24 PM:CBS A/C No : 001022000085
4/1/2026 10:25:24 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
4/1/2026 10:25:24 PM:Record Count : 1
4/1/2026 10:25:24 PM:BRLENGTH 3
4/1/2026 10:25:24 PM:SCHLENGTH 3
4/1/2026 10:25:24 PM:ACLENGTH 6
4/1/2026 10:25:24 PM:Branch Code 3
4/1/2026 10:25:24 PM:Scheme Code 3
4/1/2026 10:25:24 PM:Account No 3
4/1/2026 10:25:24 PM:Link Main Started
4/1/2026 10:25:24 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 022 and LINK_BRANCH=BRAN_SNO 
4/1/2026 10:25:24 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:25:24 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|OD|000085|OD |001
4/1/2026 10:25:24 PM:Validation Account Proce Executed with out error Y
4/1/2026 10:25:24 PM:ValidationRequest Exccution Success with response :  000
4/1/2026 10:25:24 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:26:23 PM:<------------------------Started ValidationRequest CBS A/C No : 001001011330 ------------------------>
4/1/2026 10:26:23 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:26:23 PM:Connection Establisment started
4/1/2026 10:26:23 PM:Connection Read From File  : Status OK 
4/1/2026 10:26:23 PM:Connection Successfully Opened  : Status OK 
4/1/2026 10:26:23 PM:ValidateAcNo CBS A/C No : 001001011330
4/1/2026 10:26:23 PM:CBS A/C No : 001001011330
4/1/2026 10:26: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
4/1/2026 10:26:23 PM:Record Count : 1
4/1/2026 10:26:23 PM:BRLENGTH 3
4/1/2026 10:26:23 PM:SCHLENGTH 3
4/1/2026 10:26:23 PM:ACLENGTH 6
4/1/2026 10:26:23 PM:Branch Code 3
4/1/2026 10:26:23 PM:Scheme Code 3
4/1/2026 10:26:23 PM:Account No 3
4/1/2026 10:26:23 PM:Link Main Started
4/1/2026 10:26: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 
4/1/2026 10:26:23 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:26:23 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|011330|SB |001
4/1/2026 10:26:23 PM:Validation Account Proce Executed with out error Y
4/1/2026 10:26:23 PM:ValidationRequest Exccution Success with response :  000
4/1/2026 10:26:23 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:26:39 PM:<------------------------Started ValidationRequest CBS A/C No : 001001009242 ------------------------>
4/1/2026 10:26:39 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:26:39 PM:Connection Establisment started
4/1/2026 10:26:39 PM:Connection Read From File  : Status OK 
4/1/2026 10:26:39 PM:Connection Successfully Opened  : Status OK 
4/1/2026 10:26:39 PM:ValidateAcNo CBS A/C No : 001001009242
4/1/2026 10:26:39 PM:CBS A/C No : 001001009242
4/1/2026 10:26:39 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
4/1/2026 10:26:39 PM:<------------------------Started ValidationRequest CBS A/C No : 001001013661 ------------------------>
4/1/2026 10:26:39 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:26:39 PM:Connection Establisment started
4/1/2026 10:26:39 PM:Connection Read From File  : Status OK 
4/1/2026 10:26:39 PM:Record Count : 1
4/1/2026 10:26:39 PM:BRLENGTH 3
4/1/2026 10:26:39 PM:SCHLENGTH 3
4/1/2026 10:26:39 PM:ACLENGTH 6
4/1/2026 10:26:39 PM:Branch Code 3
4/1/2026 10:26:39 PM:Scheme Code 3
4/1/2026 10:26:39 PM:Account No 3
4/1/2026 10:26:39 PM:Link Main Started
4/1/2026 10:26:39 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
4/1/2026 10:26:39 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:26:39 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|009242|SB |001
4/1/2026 10:26:39 PM:Validation Account Proce Executed with out error Y
4/1/2026 10:26:39 PM:ValidationRequest Exccution Success with response :  000
4/1/2026 10:26:39 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:26:39 PM:Connection Successfully Opened  : Status OK 
4/1/2026 10:26:39 PM:ValidateAcNo CBS A/C No : 001001013661
4/1/2026 10:26:39 PM:CBS A/C No : 001001013661
4/1/2026 10:26:39 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
4/1/2026 10:26:39 PM:Record Count : 1
4/1/2026 10:26:39 PM:BRLENGTH 3
4/1/2026 10:26:39 PM:SCHLENGTH 3
4/1/2026 10:26:39 PM:ACLENGTH 6
4/1/2026 10:26:39 PM:Branch Code 3
4/1/2026 10:26:39 PM:Scheme Code 3
4/1/2026 10:26:39 PM:Account No 3
4/1/2026 10:26:39 PM:Link Main Started
4/1/2026 10:26:39 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
4/1/2026 10:26:39 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:26:39 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|013661|SB |001
4/1/2026 10:26:39 PM:Validation Account Proce Executed with out error Y
4/1/2026 10:26:39 PM:ValidationRequest Exccution Success with response :  000
4/1/2026 10:26:39 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:26:39 PM:<------------------------Started ValidationRequest CBS A/C No : 001001011946 ------------------------>
4/1/2026 10:26:39 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:26:39 PM:Connection Establisment started
4/1/2026 10:26:39 PM:Connection Read From File  : Status OK 
4/1/2026 10:26:39 PM:<------------------------Started ValidationRequest CBS A/C No : 001001002467 ------------------------>
4/1/2026 10:26:39 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:26:39 PM:Connection Establisment started
4/1/2026 10:26:39 PM:Connection Read From File  : Status OK 
4/1/2026 10:26:39 PM:Connection Successfully Opened  : Status OK 
4/1/2026 10:26:39 PM:ValidateAcNo CBS A/C No : 001001011946
4/1/2026 10:26:39 PM:CBS A/C No : 001001011946
4/1/2026 10:26:39 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
4/1/2026 10:26:39 PM:Record Count : 1
4/1/2026 10:26:39 PM:BRLENGTH 3
4/1/2026 10:26:39 PM:SCHLENGTH 3
4/1/2026 10:26:39 PM:ACLENGTH 6
4/1/2026 10:26:39 PM:Branch Code 3
4/1/2026 10:26:39 PM:Scheme Code 3
4/1/2026 10:26:39 PM:Account No 3
4/1/2026 10:26:39 PM:Link Main Started
4/1/2026 10:26:39 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
4/1/2026 10:26:39 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:26:39 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|011946|SB |001
4/1/2026 10:26:39 PM:Validation Account Proce Executed with out error Y
4/1/2026 10:26:39 PM:ValidationRequest Exccution Success with response :  000
4/1/2026 10:26:39 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:26:40 PM:Connection Successfully Opened  : Status OK 
4/1/2026 10:26:40 PM:ValidateAcNo CBS A/C No : 001001002467
4/1/2026 10:26:40 PM:CBS A/C No : 001001002467
4/1/2026 10:26:40 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
4/1/2026 10:26:40 PM:Record Count : 1
4/1/2026 10:26:40 PM:BRLENGTH 3
4/1/2026 10:26:40 PM:SCHLENGTH 3
4/1/2026 10:26:40 PM:ACLENGTH 6
4/1/2026 10:26:40 PM:Branch Code 3
4/1/2026 10:26:40 PM:Scheme Code 3
4/1/2026 10:26:40 PM:Account No 3
4/1/2026 10:26:40 PM:Link Main Started
4/1/2026 10:26:40 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
4/1/2026 10:26:40 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:26:40 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|002467|SB |001
4/1/2026 10:26:40 PM:Validation Account Proce Executed with out error Y
4/1/2026 10:26:40 PM:ValidationRequest Exccution Success with response :  000
4/1/2026 10:26:40 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:26:54 PM:<------------------------Started ValidationRequest CBS A/C No : 001001010089 ------------------------>
4/1/2026 10:26:54 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:26:54 PM:Connection Establisment started
4/1/2026 10:26:54 PM:Connection Read From File  : Status OK 
4/1/2026 10:26:54 PM:Connection Successfully Opened  : Status OK 
4/1/2026 10:26:54 PM:ValidateAcNo CBS A/C No : 001001010089
4/1/2026 10:26:54 PM:CBS A/C No : 001001010089
4/1/2026 10:26:54 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
4/1/2026 10:26:54 PM:Record Count : 1
4/1/2026 10:26:54 PM:BRLENGTH 3
4/1/2026 10:26:54 PM:SCHLENGTH 3
4/1/2026 10:26:54 PM:ACLENGTH 6
4/1/2026 10:26:54 PM:Branch Code 3
4/1/2026 10:26:54 PM:Scheme Code 3
4/1/2026 10:26:54 PM:Account No 3
4/1/2026 10:26:54 PM:Link Main Started
4/1/2026 10:26:54 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
4/1/2026 10:26:54 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:26:54 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|010089|SB |001
4/1/2026 10:26:54 PM:Validation Account Proce Executed with out error Y
4/1/2026 10:26:54 PM:ValidationRequest Exccution Success with response :  000
4/1/2026 10:26:54 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:26:57 PM:<------------------------Started ValidationRequest CBS A/C No : 001001004111 ------------------------>
4/1/2026 10:26:57 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:26:57 PM:Connection Establisment started
4/1/2026 10:26:57 PM:Connection Read From File  : Status OK 
4/1/2026 10:26:57 PM:Connection Successfully Opened  : Status OK 
4/1/2026 10:26:57 PM:ValidateAcNo CBS A/C No : 001001004111
4/1/2026 10:26:57 PM:CBS A/C No : 001001004111
4/1/2026 10:26:57 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
4/1/2026 10:26:57 PM:Record Count : 1
4/1/2026 10:26:57 PM:BRLENGTH 3
4/1/2026 10:26:57 PM:SCHLENGTH 3
4/1/2026 10:26:57 PM:ACLENGTH 6
4/1/2026 10:26:57 PM:Branch Code 3
4/1/2026 10:26:57 PM:Scheme Code 3
4/1/2026 10:26:57 PM:Account No 3
4/1/2026 10:26:57 PM:Link Main Started
4/1/2026 10:26:57 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
4/1/2026 10:26:57 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:26:57 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|004111|SB |001
4/1/2026 10:26:57 PM:Validation Account Proce Executed with out error Y
4/1/2026 10:26:57 PM:ValidationRequest Exccution Success with response :  000
4/1/2026 10:26:57 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:27:54 PM:<------------------------Started ValidationRequest CBS A/C No : 001022000085 ------------------------>
4/1/2026 10:27:54 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:27:54 PM:Connection Establisment started
4/1/2026 10:27:54 PM:Connection Read From File  : Status OK 
4/1/2026 10:27:54 PM:Connection Successfully Opened  : Status OK 
4/1/2026 10:27:54 PM:ValidateAcNo CBS A/C No : 001022000085
4/1/2026 10:27:54 PM:CBS A/C No : 001022000085
4/1/2026 10:27:54 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
4/1/2026 10:27:54 PM:Record Count : 1
4/1/2026 10:27:54 PM:BRLENGTH 3
4/1/2026 10:27:54 PM:SCHLENGTH 3
4/1/2026 10:27:54 PM:ACLENGTH 6
4/1/2026 10:27:54 PM:Branch Code 3
4/1/2026 10:27:54 PM:Scheme Code 3
4/1/2026 10:27:54 PM:Account No 3
4/1/2026 10:27:54 PM:Link Main Started
4/1/2026 10:27:54 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 022 and LINK_BRANCH=BRAN_SNO 
4/1/2026 10:27:54 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:27:54 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|OD|000085|OD |001
4/1/2026 10:27:54 PM:Validation Account Proce Executed with out error Y
4/1/2026 10:27:54 PM:ValidationRequest Exccution Success with response :  000
4/1/2026 10:27:54 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:42:12 PM:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM09198266587|001001009761 -------------------------->
4/1/2026 10:42:12 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:42:12 PM:Connection Establisment started
4/1/2026 10:42:12 PM:Connection Read From File  : Status OK 
4/1/2026 10:42:12 PM:Connection Successfully Opened  : Status OK 
4/1/2026 10:42:12 PM:ValidateAcNo CBS A/C No : 001001009761
4/1/2026 10:42:12 PM:CBS A/C No : 001001009761
4/1/2026 10:42:12 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
4/1/2026 10:42:12 PM:Record Count : 1
4/1/2026 10:42:12 PM:BRLENGTH 3
4/1/2026 10:42:12 PM:SCHLENGTH 3
4/1/2026 10:42:12 PM:ACLENGTH 6
4/1/2026 10:42:12 PM:Branch Code 3
4/1/2026 10:42:12 PM:Scheme Code 3
4/1/2026 10:42:12 PM:Account No 3
4/1/2026 10:42:12 PM:Link Main Started
4/1/2026 10:42:12 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
4/1/2026 10:42:12 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:42:12 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|009761|SB |001
4/1/2026 10:42:12 PM:Validation Account Proce Executed with out error Y
4/1/2026 10:42:12 PM:Connection Establisment started
4/1/2026 10:42:12 PM:Connection Read From File  : Status OK 
4/1/2026 10:42:12 PM:Connection Successfully Opened  : Status OK 
4/1/2026 10:42:12 PM:CBS A/C No : 001001009761
4/1/2026 10:42:12 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
4/1/2026 10:42:12 PM:Record Count : 1
4/1/2026 10:42:12 PM:BRLENGTH 3
4/1/2026 10:42:12 PM:SCHLENGTH 3
4/1/2026 10:42:12 PM:ACLENGTH 6
4/1/2026 10:42:12 PM:Branch Code 3
4/1/2026 10:42:12 PM:Scheme Code 3
4/1/2026 10:42:12 PM:Account No 3
4/1/2026 10:42:12 PM:Link Main Started
4/1/2026 10:42:12 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
4/1/2026 10:42:12 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:42:12 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|009761|SB |001
4/1/2026 10:42:12 PM:Vno --->:82247
4/1/2026 10:42:12 PM:Current Date  --->:4/1/2026
4/1/2026 10:42:12 PM:calling  CallNewRtgsBothProc 
4/1/2026 10:42:12 PM:Parameters passing - InwardAuthorise 
4/1/2026 10:42:12 PM: brn =001
4/1/2026 10:42:12 PM: acno =009761
4/1/2026 10:42:12 PM: abbr =SB
4/1/2026 10:42:12 PM: amt.ToString() =415
4/1/2026 10:42:12 PM: traceNo =82247
4/1/2026 10:42:12 PM: narr =NEFT, BY PAYTM PAYMENTS SERVICES LTD-PAYMENT AGGREGATOR ESCROW A/C UTIB0000022 922020004482533
4/1/2026 10:42:12 PM:Transaction Process :  BEFORE CAL PROC:
4/1/2026 10:42:12 PM:cbs no--->001001009761
4/1/2026 10:42:12 PM:CBS A/C No : 001001009761
4/1/2026 10:42:12 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
4/1/2026 10:42:12 PM:Record Count : 1
4/1/2026 10:42:12 PM:BRLENGTH 3
4/1/2026 10:42:12 PM:SCHLENGTH 3
4/1/2026 10:42:12 PM:ACLENGTH 6
4/1/2026 10:42:12 PM:Branch Code 3
4/1/2026 10:42:12 PM:Scheme Code 3
4/1/2026 10:42:12 PM:Account No 3
4/1/2026 10:42:12 PM:Link Main Started
4/1/2026 10:42:12 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
4/1/2026 10:42:12 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:42:12 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|009761|SB |001
4/1/2026 10:42:12 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=009761  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=009761  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=009761  AND ADDR_SNO=CLMS_ADDRESS
4/1/2026 10:42:12 PM:closed y n Record count --->1
4/1/2026 10:42:12 PM:SMS Inserted for Mobile Number : +917899199652
4/1/2026 10:42:12 PM:Inward Process Executed Sussefully
4/1/2026 10:42:12 PM:ConfirmationReq Execution Success with Status 000
4/1/2026 10:42:12 PM:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM09198266587|001001009761 ------------------------------>
4/1/2026 10:42:12 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:48:08 PM:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM09198266046|001001009242 -------------------------->
4/1/2026 10:48:08 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:48:08 PM:Connection Establisment started
4/1/2026 10:48:08 PM:Connection Read From File  : Status OK 
4/1/2026 10:48:08 PM:Connection Successfully Opened  : Status OK 
4/1/2026 10:48:08 PM:ValidateAcNo CBS A/C No : 001001009242
4/1/2026 10:48:08 PM:CBS A/C No : 001001009242
4/1/2026 10:48:08 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
4/1/2026 10:48:08 PM:Record Count : 1
4/1/2026 10:48:08 PM:BRLENGTH 3
4/1/2026 10:48:08 PM:SCHLENGTH 3
4/1/2026 10:48:08 PM:ACLENGTH 6
4/1/2026 10:48:08 PM:Branch Code 3
4/1/2026 10:48:08 PM:Scheme Code 3
4/1/2026 10:48:08 PM:Account No 3
4/1/2026 10:48:08 PM:Link Main Started
4/1/2026 10:48:08 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
4/1/2026 10:48:08 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:48:08 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|009242|SB |001
4/1/2026 10:48:08 PM:Validation Account Proce Executed with out error Y
4/1/2026 10:48:08 PM:Connection Establisment started
4/1/2026 10:48:08 PM:Connection Read From File  : Status OK 
4/1/2026 10:48:08 PM:Connection Successfully Opened  : Status OK 
4/1/2026 10:48:08 PM:CBS A/C No : 001001009242
4/1/2026 10:48:08 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
4/1/2026 10:48:08 PM:Record Count : 1
4/1/2026 10:48:08 PM:BRLENGTH 3
4/1/2026 10:48:08 PM:SCHLENGTH 3
4/1/2026 10:48:08 PM:ACLENGTH 6
4/1/2026 10:48:08 PM:Branch Code 3
4/1/2026 10:48:08 PM:Scheme Code 3
4/1/2026 10:48:08 PM:Account No 3
4/1/2026 10:48:08 PM:Link Main Started
4/1/2026 10:48:08 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
4/1/2026 10:48:08 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:48:08 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|009242|SB |001
4/1/2026 10:48:08 PM:Vno --->:82248
4/1/2026 10:48:08 PM:Current Date  --->:4/1/2026
4/1/2026 10:48:08 PM:calling  CallNewRtgsBothProc 
4/1/2026 10:48:08 PM:Parameters passing - InwardAuthorise 
4/1/2026 10:48:08 PM: brn =001
4/1/2026 10:48:08 PM: acno =009242
4/1/2026 10:48:08 PM: abbr =SB
4/1/2026 10:48:08 PM: amt.ToString() =289.5
4/1/2026 10:48:08 PM: traceNo =82248
4/1/2026 10:48:08 PM: narr =NEFT, BY PAYTM PAYMENTS SERVICES LTD-PAYMENT AGGREGATOR ESCROW A/C UTIB0000022 922020004482533
4/1/2026 10:48:08 PM:Transaction Process :  BEFORE CAL PROC:
4/1/2026 10:48:08 PM:cbs no--->001001009242
4/1/2026 10:48:08 PM:CBS A/C No : 001001009242
4/1/2026 10:48:08 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
4/1/2026 10:48:08 PM:Record Count : 1
4/1/2026 10:48:08 PM:BRLENGTH 3
4/1/2026 10:48:08 PM:SCHLENGTH 3
4/1/2026 10:48:08 PM:ACLENGTH 6
4/1/2026 10:48:08 PM:Branch Code 3
4/1/2026 10:48:08 PM:Scheme Code 3
4/1/2026 10:48:08 PM:Account No 3
4/1/2026 10:48:08 PM:Link Main Started
4/1/2026 10:48:08 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
4/1/2026 10:48:08 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:48:08 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|009242|SB |001
4/1/2026 10:48:08 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=009242  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=009242  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=009242  AND ADDR_SNO=CLMS_ADDRESS
4/1/2026 10:48:08 PM:closed y n Record count --->1
4/1/2026 10:48:08 PM:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM09198265967|001022000085 -------------------------->
4/1/2026 10:48:08 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:48:08 PM:Connection Establisment started
4/1/2026 10:48:08 PM:Connection Read From File  : Status OK 
4/1/2026 10:48:08 PM:SMS Inserted for Mobile Number : +919742887541
4/1/2026 10:48:08 PM:Inward Process Executed Sussefully
4/1/2026 10:48:08 PM:ConfirmationReq Execution Success with Status 000
4/1/2026 10:48:08 PM:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM09198266046|001001009242 ------------------------------>
4/1/2026 10:48:08 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:48:08 PM:Connection Successfully Opened  : Status OK 
4/1/2026 10:48:08 PM:ValidateAcNo CBS A/C No : 001022000085
4/1/2026 10:48:08 PM:CBS A/C No : 001022000085
4/1/2026 10:48:08 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
4/1/2026 10:48:08 PM:Record Count : 1
4/1/2026 10:48:08 PM:BRLENGTH 3
4/1/2026 10:48:08 PM:SCHLENGTH 3
4/1/2026 10:48:08 PM:ACLENGTH 6
4/1/2026 10:48:08 PM:Branch Code 3
4/1/2026 10:48:08 PM:Scheme Code 3
4/1/2026 10:48:08 PM:Account No 3
4/1/2026 10:48:08 PM:Link Main Started
4/1/2026 10:48:08 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 022 and LINK_BRANCH=BRAN_SNO 
4/1/2026 10:48:08 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:48:08 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|OD|000085|OD |001
4/1/2026 10:48:08 PM:Validation Account Proce Executed with out error Y
4/1/2026 10:48:08 PM:Connection Establisment started
4/1/2026 10:48:08 PM:Connection Read From File  : Status OK 
4/1/2026 10:48:08 PM:Connection Successfully Opened  : Status OK 
4/1/2026 10:48:08 PM:CBS A/C No : 001022000085
4/1/2026 10:48:08 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
4/1/2026 10:48:08 PM:Record Count : 1
4/1/2026 10:48:08 PM:BRLENGTH 3
4/1/2026 10:48:08 PM:SCHLENGTH 3
4/1/2026 10:48:08 PM:ACLENGTH 6
4/1/2026 10:48:08 PM:Branch Code 3
4/1/2026 10:48:08 PM:Scheme Code 3
4/1/2026 10:48:08 PM:Account No 3
4/1/2026 10:48:08 PM:Link Main Started
4/1/2026 10:48:08 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 022 and LINK_BRANCH=BRAN_SNO 
4/1/2026 10:48:08 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:48:08 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|OD|000085|OD |001
4/1/2026 10:48:08 PM:Vno --->:82249
4/1/2026 10:48:08 PM:Current Date  --->:4/1/2026
4/1/2026 10:48:09 PM:calling  CallNewRtgsBothProc 
4/1/2026 10:48:09 PM:Parameters passing - InwardAuthorise 
4/1/2026 10:48:09 PM: brn =001
4/1/2026 10:48:09 PM: acno =000085
4/1/2026 10:48:09 PM: abbr =OD
4/1/2026 10:48:09 PM: amt.ToString() =7705
4/1/2026 10:48:09 PM: traceNo =82249
4/1/2026 10:48:09 PM: narr =NEFT, BY PAYTM PAYMENTS SERVICES LTD-PAYMENT AGGREGATOR ESCROW A/C UTIB0000022 922020004482533
4/1/2026 10:48:09 PM:Transaction Process :  BEFORE CAL PROC:
4/1/2026 10:48:09 PM:cbs no--->001022000085
4/1/2026 10:48:09 PM:CBS A/C No : 001022000085
4/1/2026 10:48:09 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
4/1/2026 10:48:09 PM:Record Count : 1
4/1/2026 10:48:09 PM:BRLENGTH 3
4/1/2026 10:48:09 PM:SCHLENGTH 3
4/1/2026 10:48:09 PM:ACLENGTH 6
4/1/2026 10:48:09 PM:Branch Code 3
4/1/2026 10:48:09 PM:Scheme Code 3
4/1/2026 10:48:09 PM:Account No 3
4/1/2026 10:48:09 PM:Link Main Started
4/1/2026 10:48:09 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 022 and LINK_BRANCH=BRAN_SNO 
4/1/2026 10:48:09 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:48:09 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|OD|000085|OD |001
4/1/2026 10:48:09 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)='OD'  AND DEPM_NO=000085  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)='OD'  AND LOAM_NO=000085  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)='OD'  AND ODMT_NO=000085  AND ADDR_SNO=CLMS_ADDRESS
4/1/2026 10:48:09 PM:closed y n Record count --->1
4/1/2026 10:48:09 PM:SMS Inserted for Mobile Number : +919036313117
4/1/2026 10:48:09 PM:Inward Process Executed Sussefully
4/1/2026 10:48:09 PM:ConfirmationReq Execution Success with Status 000
4/1/2026 10:48:09 PM:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM09198265967|001022000085 ------------------------------>
4/1/2026 10:48:09 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:52:03 PM:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM09198267265|001001011330 -------------------------->
4/1/2026 10:52:03 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:52:03 PM:Connection Establisment started
4/1/2026 10:52:03 PM:Connection Read From File  : Status OK 
4/1/2026 10:52:03 PM:Connection Successfully Opened  : Status OK 
4/1/2026 10:52:03 PM:ValidateAcNo CBS A/C No : 001001011330
4/1/2026 10:52:03 PM:CBS A/C No : 001001011330
4/1/2026 10:52:03 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
4/1/2026 10:52:03 PM:Record Count : 1
4/1/2026 10:52:03 PM:BRLENGTH 3
4/1/2026 10:52:03 PM:SCHLENGTH 3
4/1/2026 10:52:03 PM:ACLENGTH 6
4/1/2026 10:52:03 PM:Branch Code 3
4/1/2026 10:52:03 PM:Scheme Code 3
4/1/2026 10:52:03 PM:Account No 3
4/1/2026 10:52:03 PM:Link Main Started
4/1/2026 10:52:03 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
4/1/2026 10:52:03 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:52:03 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|011330|SB |001
4/1/2026 10:52:03 PM:Validation Account Proce Executed with out error Y
4/1/2026 10:52:03 PM:Connection Establisment started
4/1/2026 10:52:03 PM:Connection Read From File  : Status OK 
4/1/2026 10:52:03 PM:Connection Successfully Opened  : Status OK 
4/1/2026 10:52:03 PM:CBS A/C No : 001001011330
4/1/2026 10:52:03 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
4/1/2026 10:52:03 PM:Record Count : 1
4/1/2026 10:52:03 PM:BRLENGTH 3
4/1/2026 10:52:03 PM:SCHLENGTH 3
4/1/2026 10:52:03 PM:ACLENGTH 6
4/1/2026 10:52:03 PM:Branch Code 3
4/1/2026 10:52:03 PM:Scheme Code 3
4/1/2026 10:52:03 PM:Account No 3
4/1/2026 10:52:03 PM:Link Main Started
4/1/2026 10:52:03 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
4/1/2026 10:52:03 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:52:03 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|011330|SB |001
4/1/2026 10:52:03 PM:Vno --->:82250
4/1/2026 10:52:03 PM:Current Date  --->:4/1/2026
4/1/2026 10:52:03 PM:calling  CallNewRtgsBothProc 
4/1/2026 10:52:03 PM:Parameters passing - InwardAuthorise 
4/1/2026 10:52:03 PM: brn =001
4/1/2026 10:52:03 PM: acno =011330
4/1/2026 10:52:03 PM: abbr =SB
4/1/2026 10:52:03 PM: amt.ToString() =2295
4/1/2026 10:52:03 PM: traceNo =82250
4/1/2026 10:52:03 PM: narr =NEFT, BY PAYTM PAYMENTS SERVICES LTD-PAYMENT AGGREGATOR ESCROW A/C UTIB0000022 922020004482533
4/1/2026 10:52:03 PM:Transaction Process :  BEFORE CAL PROC:
4/1/2026 10:52:03 PM:Inward Process Executed Sussefully
4/1/2026 10:52:03 PM:ConfirmationReq Execution Success with Status 000
4/1/2026 10:52:03 PM:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM09198267265|001001011330 ------------------------------>
4/1/2026 10:52:03 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:53:19 PM:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM09198267612|001022000085 -------------------------->
4/1/2026 10:53:19 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:53:19 PM:Connection Establisment started
4/1/2026 10:53:19 PM:Connection Read From File  : Status OK 
4/1/2026 10:53:19 PM:Connection Successfully Opened  : Status OK 
4/1/2026 10:53:19 PM:ValidateAcNo CBS A/C No : 001022000085
4/1/2026 10:53:19 PM:CBS A/C No : 001022000085
4/1/2026 10:53: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
4/1/2026 10:53:19 PM:Record Count : 1
4/1/2026 10:53:19 PM:BRLENGTH 3
4/1/2026 10:53:19 PM:SCHLENGTH 3
4/1/2026 10:53:19 PM:ACLENGTH 6
4/1/2026 10:53:19 PM:Branch Code 3
4/1/2026 10:53:19 PM:Scheme Code 3
4/1/2026 10:53:19 PM:Account No 3
4/1/2026 10:53:19 PM:Link Main Started
4/1/2026 10:53:19 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 022 and LINK_BRANCH=BRAN_SNO 
4/1/2026 10:53:19 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:53:19 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|OD|000085|OD |001
4/1/2026 10:53:19 PM:Validation Account Proce Executed with out error Y
4/1/2026 10:53:19 PM:Connection Establisment started
4/1/2026 10:53:19 PM:Connection Read From File  : Status OK 
4/1/2026 10:53:19 PM:Connection Successfully Opened  : Status OK 
4/1/2026 10:53:19 PM:CBS A/C No : 001022000085
4/1/2026 10:53: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
4/1/2026 10:53:19 PM:Record Count : 1
4/1/2026 10:53:19 PM:BRLENGTH 3
4/1/2026 10:53:19 PM:SCHLENGTH 3
4/1/2026 10:53:19 PM:ACLENGTH 6
4/1/2026 10:53:19 PM:Branch Code 3
4/1/2026 10:53:19 PM:Scheme Code 3
4/1/2026 10:53:19 PM:Account No 3
4/1/2026 10:53:19 PM:Link Main Started
4/1/2026 10:53:19 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 022 and LINK_BRANCH=BRAN_SNO 
4/1/2026 10:53:19 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:53:19 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|OD|000085|OD |001
4/1/2026 10:53:19 PM:Vno --->:82251
4/1/2026 10:53:19 PM:Current Date  --->:4/1/2026
4/1/2026 10:53:19 PM:calling  CallNewRtgsBothProc 
4/1/2026 10:53:19 PM:Parameters passing - InwardAuthorise 
4/1/2026 10:53:19 PM: brn =001
4/1/2026 10:53:19 PM: acno =000085
4/1/2026 10:53:19 PM: abbr =OD
4/1/2026 10:53:19 PM: amt.ToString() =13870
4/1/2026 10:53:19 PM: traceNo =82251
4/1/2026 10:53:19 PM: narr =NEFT, BY PAYTM PAYMENTS SERVICES LTD-PAYMENT AGGREGATOR ESCROW A/C UTIB0000022 922020004482533
4/1/2026 10:53:19 PM:Transaction Process :  BEFORE CAL PROC:
4/1/2026 10:53:19 PM:cbs no--->001022000085
4/1/2026 10:53:19 PM:CBS A/C No : 001022000085
4/1/2026 10:53: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
4/1/2026 10:53:19 PM:Record Count : 1
4/1/2026 10:53:19 PM:BRLENGTH 3
4/1/2026 10:53:19 PM:SCHLENGTH 3
4/1/2026 10:53:19 PM:ACLENGTH 6
4/1/2026 10:53:19 PM:Branch Code 3
4/1/2026 10:53:19 PM:Scheme Code 3
4/1/2026 10:53:19 PM:Account No 3
4/1/2026 10:53:19 PM:Link Main Started
4/1/2026 10:53:19 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 022 and LINK_BRANCH=BRAN_SNO 
4/1/2026 10:53:19 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:53:19 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|OD|000085|OD |001
4/1/2026 10:53: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)='OD'  AND DEPM_NO=000085  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)='OD'  AND LOAM_NO=000085  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)='OD'  AND ODMT_NO=000085  AND ADDR_SNO=CLMS_ADDRESS
4/1/2026 10:53:19 PM:closed y n Record count --->1
4/1/2026 10:53:19 PM:SMS Inserted for Mobile Number : +919036313117
4/1/2026 10:53:19 PM:Inward Process Executed Sussefully
4/1/2026 10:53:19 PM:ConfirmationReq Execution Success with Status 000
4/1/2026 10:53:19 PM:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM09198267612|001022000085 ------------------------------>
4/1/2026 10:53:19 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:53:38 PM:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM09198269128|001001009242 -------------------------->
4/1/2026 10:53:38 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:53:38 PM:Connection Establisment started
4/1/2026 10:53:38 PM:Connection Read From File  : Status OK 
4/1/2026 10:53:38 PM:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM09198268841|001001013661 -------------------------->
4/1/2026 10:53:38 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:53:38 PM:Connection Establisment started
4/1/2026 10:53:38 PM:Connection Read From File  : Status OK 
4/1/2026 10:53:38 PM:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM09198267806|001001002467 -------------------------->
4/1/2026 10:53:38 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:53:38 PM:Connection Establisment started
4/1/2026 10:53:38 PM:Connection Read From File  : Status OK 
4/1/2026 10:53:38 PM:Connection Successfully Opened  : Status OK 
4/1/2026 10:53:38 PM:ValidateAcNo CBS A/C No : 001001009242
4/1/2026 10:53:38 PM:CBS A/C No : 001001009242
4/1/2026 10:53: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
4/1/2026 10:53:38 PM:Record Count : 1
4/1/2026 10:53:38 PM:BRLENGTH 3
4/1/2026 10:53:38 PM:SCHLENGTH 3
4/1/2026 10:53:38 PM:ACLENGTH 6
4/1/2026 10:53:38 PM:Branch Code 3
4/1/2026 10:53:38 PM:Scheme Code 3
4/1/2026 10:53:38 PM:Account No 3
4/1/2026 10:53:38 PM:Link Main Started
4/1/2026 10:53: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 
4/1/2026 10:53:38 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:53:38 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|009242|SB |001
4/1/2026 10:53:38 PM:Validation Account Proce Executed with out error Y
4/1/2026 10:53:38 PM:Connection Establisment started
4/1/2026 10:53:38 PM:Connection Successfully Opened  : Status OK 
4/1/2026 10:53:38 PM:ValidateAcNo CBS A/C No : 001001002467
4/1/2026 10:53:38 PM:CBS A/C No : 001001002467
4/1/2026 10:53: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
4/1/2026 10:53:38 PM:Record Count : 1
4/1/2026 10:53:38 PM:BRLENGTH 3
4/1/2026 10:53:38 PM:SCHLENGTH 3
4/1/2026 10:53:38 PM:ACLENGTH 6
4/1/2026 10:53:38 PM:Branch Code 3
4/1/2026 10:53:38 PM:Scheme Code 3
4/1/2026 10:53:38 PM:Account No 3
4/1/2026 10:53:38 PM:Link Main Started
4/1/2026 10:53: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 
4/1/2026 10:53:38 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:53:38 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|002467|SB |001
4/1/2026 10:53:38 PM:Validation Account Proce Executed with out error Y
4/1/2026 10:53:38 PM:Connection Establisment started
4/1/2026 10:53:38 PM:Connection Successfully Opened  : Status OK 
4/1/2026 10:53:38 PM:Connection Read From File  : Status OK 
4/1/2026 10:53: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
4/1/2026 10:53:38 PM:Record Count : 1
4/1/2026 10:53:38 PM:BRLENGTH 3
4/1/2026 10:53:38 PM:SCHLENGTH 3
4/1/2026 10:53:38 PM:ACLENGTH 6
4/1/2026 10:53:38 PM:Branch Code 3
4/1/2026 10:53:38 PM:Scheme Code 3
4/1/2026 10:53:38 PM:Account No 3
4/1/2026 10:53:38 PM:Link Main Started
4/1/2026 10:53: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 
4/1/2026 10:53:38 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:53:38 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|009242|SB |001
4/1/2026 10:53:38 PM:Vno --->:82252
4/1/2026 10:53:38 PM:Current Date  --->:4/1/2026
4/1/2026 10:53:38 PM:calling  CallNewRtgsBothProc 
4/1/2026 10:53:38 PM:Parameters passing - InwardAuthorise 
4/1/2026 10:53:38 PM: brn =001
4/1/2026 10:53:38 PM: acno =009242
4/1/2026 10:53:38 PM: abbr =SB
4/1/2026 10:53:38 PM: amt.ToString() =580
4/1/2026 10:53:38 PM: traceNo =82252
4/1/2026 10:53:38 PM: narr =NEFT, BY PAYTM PAYMENTS SERVICES LTD-PAYMENT AGGREGATOR ESCROW A/C UTIB0000022 922020004482533
4/1/2026 10:53:38 PM:Transaction Process :  BEFORE CAL PROC:
4/1/2026 10:53:38 PM:cbs no--->001001009242
4/1/2026 10:53:38 PM:CBS A/C No : 001001009242
4/1/2026 10:53: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
4/1/2026 10:53:38 PM:Record Count : 1
4/1/2026 10:53:38 PM:BRLENGTH 3
4/1/2026 10:53:38 PM:SCHLENGTH 3
4/1/2026 10:53:38 PM:ACLENGTH 6
4/1/2026 10:53:38 PM:Branch Code 3
4/1/2026 10:53:38 PM:Scheme Code 3
4/1/2026 10:53:38 PM:Account No 3
4/1/2026 10:53:38 PM:Link Main Started
4/1/2026 10:53: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 
4/1/2026 10:53:38 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:53:38 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|009242|SB |001
4/1/2026 10:53: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=009242  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=009242  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=009242  AND ADDR_SNO=CLMS_ADDRESS
4/1/2026 10:53:38 PM:closed y n Record count --->1
4/1/2026 10:53:38 PM:Connection Successfully Opened  : Status OK 
4/1/2026 10:53:38 PM:ValidateAcNo CBS A/C No : 001001013661
4/1/2026 10:53:38 PM:CBS A/C No : 001001013661
4/1/2026 10:53: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
4/1/2026 10:53:38 PM:Record Count : 1
4/1/2026 10:53:38 PM:BRLENGTH 3
4/1/2026 10:53:38 PM:SCHLENGTH 3
4/1/2026 10:53:38 PM:ACLENGTH 6
4/1/2026 10:53:38 PM:Branch Code 3
4/1/2026 10:53:38 PM:Scheme Code 3
4/1/2026 10:53:38 PM:Account No 3
4/1/2026 10:53:38 PM:Link Main Started
4/1/2026 10:53: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 
4/1/2026 10:53:38 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:53:38 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|013661|SB |001
4/1/2026 10:53:38 PM:Validation Account Proce Executed with out error Y
4/1/2026 10:53:38 PM:Connection Establisment started
4/1/2026 10:53:38 PM:Connection Read From File  : Status OK 
4/1/2026 10:53:38 PM:Connection Successfully Opened  : Status OK 
4/1/2026 10:53:38 PM:CBS A/C No : 001001013661
4/1/2026 10:53: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
4/1/2026 10:53:38 PM:Record Count : 1
4/1/2026 10:53:38 PM:BRLENGTH 3
4/1/2026 10:53:38 PM:SCHLENGTH 3
4/1/2026 10:53:38 PM:ACLENGTH 6
4/1/2026 10:53:38 PM:Branch Code 3
4/1/2026 10:53:38 PM:Scheme Code 3
4/1/2026 10:53:38 PM:Account No 3
4/1/2026 10:53:38 PM:Link Main Started
4/1/2026 10:53: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 
4/1/2026 10:53:38 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:53:38 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|013661|SB |001
4/1/2026 10:53:38 PM:Vno --->:82253
4/1/2026 10:53:38 PM:Current Date  --->:4/1/2026
4/1/2026 10:53:38 PM:SMS Inserted for Mobile Number : +919742887541
4/1/2026 10:53:38 PM:calling  CallNewRtgsBothProc 
4/1/2026 10:53:38 PM:Parameters passing - InwardAuthorise 
4/1/2026 10:53:38 PM: brn =001
4/1/2026 10:53:38 PM: acno =013661
4/1/2026 10:53:38 PM: abbr =SB
4/1/2026 10:53:38 PM: amt.ToString() =660
4/1/2026 10:53:38 PM: traceNo =82253
4/1/2026 10:53:38 PM: narr =NEFT, BY PAYTM PAYMENTS SERVICES LTD-PAYMENT AGGREGATOR ESCROW A/C UTIB0000022 922020004482533
4/1/2026 10:53:38 PM:Transaction Process :  BEFORE CAL PROC:
4/1/2026 10:53:38 PM:Inward Process Executed Sussefully
4/1/2026 10:53:38 PM:ConfirmationReq Execution Success with Status 000
4/1/2026 10:53:38 PM:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM09198269128|001001009242 ------------------------------>
4/1/2026 10:53:38 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:53:38 PM:cbs no--->001001013661
4/1/2026 10:53:38 PM:CBS A/C No : 001001013661
4/1/2026 10:53: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
4/1/2026 10:53:38 PM:Record Count : 1
4/1/2026 10:53:38 PM:BRLENGTH 3
4/1/2026 10:53:38 PM:SCHLENGTH 3
4/1/2026 10:53:38 PM:ACLENGTH 6
4/1/2026 10:53:38 PM:Branch Code 3
4/1/2026 10:53:38 PM:Scheme Code 3
4/1/2026 10:53:38 PM:Account No 3
4/1/2026 10:53:38 PM:Link Main Started
4/1/2026 10:53: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 
4/1/2026 10:53:38 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:53:38 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|013661|SB |001
4/1/2026 10:53: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=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
4/1/2026 10:53:38 PM:closed y n Record count --->1
4/1/2026 10:53:38 PM:Connection Successfully Opened  : Status OK 
4/1/2026 10:53:38 PM:CBS A/C No : 001001002467
4/1/2026 10:53: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
4/1/2026 10:53:38 PM:Record Count : 1
4/1/2026 10:53:38 PM:BRLENGTH 3
4/1/2026 10:53:38 PM:SCHLENGTH 3
4/1/2026 10:53:38 PM:ACLENGTH 6
4/1/2026 10:53:38 PM:Branch Code 3
4/1/2026 10:53:38 PM:Scheme Code 3
4/1/2026 10:53:38 PM:Account No 3
4/1/2026 10:53:38 PM:Link Main Started
4/1/2026 10:53: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 
4/1/2026 10:53:38 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:53:38 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|002467|SB |001
4/1/2026 10:53:38 PM:Vno --->:82254
4/1/2026 10:53:38 PM:Current Date  --->:4/1/2026
4/1/2026 10:53:38 PM:calling  CallNewRtgsBothProc 
4/1/2026 10:53:38 PM:Parameters passing - InwardAuthorise 
4/1/2026 10:53:38 PM: brn =001
4/1/2026 10:53:38 PM: acno =002467
4/1/2026 10:53:38 PM: abbr =SB
4/1/2026 10:53:38 PM: amt.ToString() =620
4/1/2026 10:53:38 PM: traceNo =82254
4/1/2026 10:53:38 PM: narr =NEFT, BY PAYTM PAYMENTS SERVICES LTD-PAYMENT AGGREGATOR ESCROW A/C UTIB0000022 922020004482533
4/1/2026 10:53:38 PM:Transaction Process :  BEFORE CAL PROC:
4/1/2026 10:53:38 PM:Inward Process Executed Sussefully
4/1/2026 10:53:38 PM:ConfirmationReq Execution Success with Status 000
4/1/2026 10:53:38 PM:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM09198267806|001001002467 ------------------------------>
4/1/2026 10:53:38 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:53:38 PM:SMS Inserted for Mobile Number : +918880882755
4/1/2026 10:53:38 PM:Inward Process Executed Sussefully
4/1/2026 10:53:38 PM:ConfirmationReq Execution Success with Status 000
4/1/2026 10:53:38 PM:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM09198268841|001001013661 ------------------------------>
4/1/2026 10:53:38 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:56:23 PM:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM09198265521|001001010089 -------------------------->
4/1/2026 10:56:23 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:56:23 PM:Connection Establisment started
4/1/2026 10:56:23 PM:Connection Read From File  : Status OK 
4/1/2026 10:56:23 PM:Connection Successfully Opened  : Status OK 
4/1/2026 10:56:23 PM:ValidateAcNo CBS A/C No : 001001010089
4/1/2026 10:56:23 PM:CBS A/C No : 001001010089
4/1/2026 10:56: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
4/1/2026 10:56:23 PM:Record Count : 1
4/1/2026 10:56:23 PM:BRLENGTH 3
4/1/2026 10:56:23 PM:SCHLENGTH 3
4/1/2026 10:56:23 PM:ACLENGTH 6
4/1/2026 10:56:23 PM:Branch Code 3
4/1/2026 10:56:23 PM:Scheme Code 3
4/1/2026 10:56:23 PM:Account No 3
4/1/2026 10:56:23 PM:Link Main Started
4/1/2026 10:56: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 
4/1/2026 10:56:23 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:56:23 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|010089|SB |001
4/1/2026 10:56:23 PM:Validation Account Proce Executed with out error Y
4/1/2026 10:56:23 PM:Connection Establisment started
4/1/2026 10:56:23 PM:Connection Read From File  : Status OK 
4/1/2026 10:56:23 PM:Connection Successfully Opened  : Status OK 
4/1/2026 10:56:23 PM:CBS A/C No : 001001010089
4/1/2026 10:56: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
4/1/2026 10:56:23 PM:Record Count : 1
4/1/2026 10:56:23 PM:BRLENGTH 3
4/1/2026 10:56:23 PM:SCHLENGTH 3
4/1/2026 10:56:23 PM:ACLENGTH 6
4/1/2026 10:56:23 PM:Branch Code 3
4/1/2026 10:56:23 PM:Scheme Code 3
4/1/2026 10:56:23 PM:Account No 3
4/1/2026 10:56:23 PM:Link Main Started
4/1/2026 10:56: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 
4/1/2026 10:56:23 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:56:23 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|010089|SB |001
4/1/2026 10:56:23 PM:Vno --->:82255
4/1/2026 10:56:23 PM:Current Date  --->:4/1/2026
4/1/2026 10:56:23 PM:calling  CallNewRtgsBothProc 
4/1/2026 10:56:23 PM:Parameters passing - InwardAuthorise 
4/1/2026 10:56:23 PM: brn =001
4/1/2026 10:56:23 PM: acno =010089
4/1/2026 10:56:23 PM: abbr =SB
4/1/2026 10:56:23 PM: amt.ToString() =815
4/1/2026 10:56:23 PM: traceNo =82255
4/1/2026 10:56:23 PM: narr =NEFT, BY PAYTM PAYMENTS SERVICES LTD-PAYMENT AGGREGATOR ESCROW A/C UTIB0000022 922020004482533
4/1/2026 10:56:23 PM:Transaction Process :  BEFORE CAL PROC:
4/1/2026 10:56:23 PM:cbs no--->001001010089
4/1/2026 10:56:23 PM:CBS A/C No : 001001010089
4/1/2026 10:56: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
4/1/2026 10:56:23 PM:Record Count : 1
4/1/2026 10:56:23 PM:BRLENGTH 3
4/1/2026 10:56:23 PM:SCHLENGTH 3
4/1/2026 10:56:23 PM:ACLENGTH 6
4/1/2026 10:56:23 PM:Branch Code 3
4/1/2026 10:56:23 PM:Scheme Code 3
4/1/2026 10:56:23 PM:Account No 3
4/1/2026 10:56:23 PM:Link Main Started
4/1/2026 10:56: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 
4/1/2026 10:56:23 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:56:23 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|010089|SB |001
4/1/2026 10:56:23 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=010089  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=010089  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=010089  AND ADDR_SNO=CLMS_ADDRESS
4/1/2026 10:56:23 PM:closed y n Record count --->1
4/1/2026 10:56:23 PM:SMS Inserted for Mobile Number : +919513334899
4/1/2026 10:56:23 PM:Inward Process Executed Sussefully
4/1/2026 10:56:23 PM:ConfirmationReq Execution Success with Status 000
4/1/2026 10:56:23 PM:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM09198265521|001001010089 ------------------------------>
4/1/2026 10:56:23 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:56:26 PM:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM09198265515|001001004111 -------------------------->
4/1/2026 10:56:26 PM:<------------------------------------------------------------------------------------------------------------------------>
4/1/2026 10:56:26 PM:Connection Establisment started
4/1/2026 10:56:26 PM:Connection Read From File  : Status OK 
4/1/2026 10:56:26 PM:Connection Successfully Opened  : Status OK 
4/1/2026 10:56:26 PM:ValidateAcNo CBS A/C No : 001001004111
4/1/2026 10:56:26 PM:CBS A/C No : 001001004111
4/1/2026 10:56:26 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
4/1/2026 10:56:26 PM:Record Count : 1
4/1/2026 10:56:26 PM:BRLENGTH 3
4/1/2026 10:56:26 PM:SCHLENGTH 3
4/1/2026 10:56:26 PM:ACLENGTH 6
4/1/2026 10:56:26 PM:Branch Code 3
4/1/2026 10:56:26 PM:Scheme Code 3
4/1/2026 10:56:26 PM:Account No 3
4/1/2026 10:56:26 PM:Link Main Started
4/1/2026 10:56:26 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
4/1/2026 10:56:26 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:56:26 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|004111|SB |001
4/1/2026 10:56:26 PM:Validation Account Proce Executed with out error Y
4/1/2026 10:56:26 PM:Connection Establisment started
4/1/2026 10:56:26 PM:Connection Read From File  : Status OK 
4/1/2026 10:56:26 PM:Connection Successfully Opened  : Status OK 
4/1/2026 10:56:26 PM:CBS A/C No : 001001004111
4/1/2026 10:56:26 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
4/1/2026 10:56:26 PM:Record Count : 1
4/1/2026 10:56:26 PM:BRLENGTH 3
4/1/2026 10:56:26 PM:SCHLENGTH 3
4/1/2026 10:56:26 PM:ACLENGTH 6
4/1/2026 10:56:26 PM:Branch Code 3
4/1/2026 10:56:26 PM:Scheme Code 3
4/1/2026 10:56:26 PM:Account No 3
4/1/2026 10:56:26 PM:Link Main Started
4/1/2026 10:56:26 PM:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
4/1/2026 10:56:26 PM:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
4/1/2026 10:56:26 PM:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|004111|SB |001
4/1/2026 10:56:26 PM:Vno --->:82256
4/1/2026 10:56:26 PM:Current Date  --->:4/1/2026
4/1/2026 10:56:26 PM:calling  CallNewRtgsBothProc 
4/1/2026 10:56:26 PM:Parameters passing - InwardAuthorise 
4/1/2026 10:56:26 PM: brn =001
4/1/2026 10:56:26 PM: acno =004111
4/1/2026 10:56:26 PM: abbr =SB
4/1/2026 10:56:26 PM: amt.ToString() =300
4/1/2026 10:56:26 PM: traceNo =82256
4/1/2026 10:56:26 PM: narr =NEFT, BY PAYTM PAYMENTS SERVICES LTD-PAYMENT AGGREGATOR ESCROW A/C UTIB0000022 922020004482533
4/1/2026 10:56:26 PM:Transaction Process :  BEFORE CAL PROC:
4/1/2026 10:56:26 PM:Inward Process Executed Sussefully
4/1/2026 10:56:26 PM:ConfirmationReq Execution Success with Status 000
4/1/2026 10:56:26 PM:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM09198265515|001001004111 ------------------------------>
4/1/2026 10:56:26 PM:<------------------------------------------------------------------------------------------------------------------------>