28-08-2025 11:36:07:<------------------------Started ValidationRequest CBS A/C No : 001001002467 ------------------------>
28-08-2025 11:36:07:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:36:07:Connection Establisment started
28-08-2025 11:36:07:Connection Read From File  : Status OK 
28-08-2025 11:36:07:Connection Successfully Opened  : Status OK 
28-08-2025 11:36:07:ValidateAcNo CBS A/C No : 001001002467
28-08-2025 11:36:07:CBS A/C No : 001001002467
28-08-2025 11:36:07:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 11:36:07:Record Count : 1
28-08-2025 11:36:07:BRLENGTH 3
28-08-2025 11:36:07:SCHLENGTH 3
28-08-2025 11:36:07:ACLENGTH 6
28-08-2025 11:36:07:Branch Code 3
28-08-2025 11:36:07:Scheme Code 3
28-08-2025 11:36:07:Account No 3
28-08-2025 11:36:07:Link Main Started
28-08-2025 11:36:07:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:36:07:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:36:07:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|002467|SB |001
28-08-2025 11:36:07:Validation Account Proce Executed with out error Y
28-08-2025 11:36:07:ValidationRequest Exccution Success with response :  000
28-08-2025 11:36:07:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:40:25:<------------------------Started ValidationRequest CBS A/C No : 002001000308 ------------------------>
28-08-2025 11:40:25:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:40:25:Connection Establisment started
28-08-2025 11:40:25:Connection Read From File  : Status OK 
28-08-2025 11:40:25:<------------------------Started ValidationRequest CBS A/C No : 001001002467 ------------------------>
28-08-2025 11:40:25:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:40:25:Connection Establisment started
28-08-2025 11:40:25:Connection Read From File  : Status OK 
28-08-2025 11:40:25:<------------------------Started ValidationRequest CBS A/C No : 001001003013 ------------------------>
28-08-2025 11:40:25:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:40:25:Connection Establisment started
28-08-2025 11:40:25:Connection Read From File  : Status OK 
28-08-2025 11:40:25:Connection Successfully Opened  : Status OK 
28-08-2025 11:40:25:ValidateAcNo CBS A/C No : 002001000308
28-08-2025 11:40:25:CBS A/C No : 002001000308
28-08-2025 11:40:25: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
28-08-2025 11:40:25:Record Count : 1
28-08-2025 11:40:25:BRLENGTH 3
28-08-2025 11:40:25:SCHLENGTH 3
28-08-2025 11:40:25:ACLENGTH 6
28-08-2025 11:40:25:Branch Code 3
28-08-2025 11:40:25:Scheme Code 3
28-08-2025 11:40:25:Account No 3
28-08-2025 11:40:25:Link Main Started
28-08-2025 11:40:25:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:40:25:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 002
28-08-2025 11:40:25:ShowCBS Ac No Proce Executed  BARDANSAL|DEPOSIT|000308|SB |002
28-08-2025 11:40:25:Validation Account Proce Executed with out error Y
28-08-2025 11:40:25:ValidationRequest Exccution Success with response :  000
28-08-2025 11:40:25:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:40:25:Connection Successfully Opened  : Status OK 
28-08-2025 11:40:25:ValidateAcNo CBS A/C No : 001001002467
28-08-2025 11:40:25:CBS A/C No : 001001002467
28-08-2025 11:40:25: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
28-08-2025 11:40:25:Record Count : 1
28-08-2025 11:40:25:BRLENGTH 3
28-08-2025 11:40:25:SCHLENGTH 3
28-08-2025 11:40:25:ACLENGTH 6
28-08-2025 11:40:25:Branch Code 3
28-08-2025 11:40:25:Scheme Code 3
28-08-2025 11:40:25:Account No 3
28-08-2025 11:40:25:Link Main Started
28-08-2025 11:40:25:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:40:25:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:40:25:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|002467|SB |001
28-08-2025 11:40:25:Validation Account Proce Executed with out error Y
28-08-2025 11:40:25:ValidationRequest Exccution Success with response :  000
28-08-2025 11:40:25:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:40:25:<------------------------Started ValidationRequest CBS A/C No : 001001011330 ------------------------>
28-08-2025 11:40:25:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:40:25:Connection Establisment started
28-08-2025 11:40:25:Connection Read From File  : Status OK 
28-08-2025 11:40:25:Connection Successfully Opened  : Status OK 
28-08-2025 11:40:25:ValidateAcNo CBS A/C No : 001001003013
28-08-2025 11:40:25:CBS A/C No : 001001003013
28-08-2025 11:40:25: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
28-08-2025 11:40:25:Record Count : 1
28-08-2025 11:40:25:BRLENGTH 3
28-08-2025 11:40:25:SCHLENGTH 3
28-08-2025 11:40:25:ACLENGTH 6
28-08-2025 11:40:25:Branch Code 3
28-08-2025 11:40:25:Scheme Code 3
28-08-2025 11:40:25:Account No 3
28-08-2025 11:40:25:Link Main Started
28-08-2025 11:40:25:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:40:25:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:40:25:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|003013|SB |001
28-08-2025 11:40:25:Validation Account Proce Executed with out error Y
28-08-2025 11:40:25:ValidationRequest Exccution Success with response :  000
28-08-2025 11:40:25:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:40:25:<------------------------Started ValidationRequest CBS A/C No : 001001011946 ------------------------>
28-08-2025 11:40:25:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:40:25:Connection Establisment started
28-08-2025 11:40:25:Connection Read From File  : Status OK 
28-08-2025 11:40:25:<------------------------Started ValidationRequest CBS A/C No : 001002000319 ------------------------>
28-08-2025 11:40:25:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:40:25:Connection Establisment started
28-08-2025 11:40:25:Connection Read From File  : Status OK 
28-08-2025 11:40:26:<------------------------Started ValidationRequest CBS A/C No : 001001013000 ------------------------>
28-08-2025 11:40:26:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:40:26:Connection Establisment started
28-08-2025 11:40:26:Connection Read From File  : Status OK 
28-08-2025 11:40:26:Connection Successfully Opened  : Status OK 
28-08-2025 11:40:26:ValidateAcNo CBS A/C No : 001001011330
28-08-2025 11:40:26:CBS A/C No : 001001011330
28-08-2025 11:40:26: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
28-08-2025 11:40:26:Record Count : 1
28-08-2025 11:40:26:BRLENGTH 3
28-08-2025 11:40:26:SCHLENGTH 3
28-08-2025 11:40:26:ACLENGTH 6
28-08-2025 11:40:26:Branch Code 3
28-08-2025 11:40:26:Scheme Code 3
28-08-2025 11:40:26:Account No 3
28-08-2025 11:40:26:Link Main Started
28-08-2025 11:40:26:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:40:26:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:40:26:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|011330|SB |001
28-08-2025 11:40:26:Validation Account Proce Executed with out error Y
28-08-2025 11:40:26:ValidationRequest Exccution Success with response :  000
28-08-2025 11:40:26:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:40:26:<------------------------Started ValidationRequest CBS A/C No : 001001011909 ------------------------>
28-08-2025 11:40:26:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:40:26:Connection Establisment started
28-08-2025 11:40:26:Connection Read From File  : Status OK 
28-08-2025 11:40:26:<------------------------Started ValidationRequest CBS A/C No : 001001005543 ------------------------>
28-08-2025 11:40:26:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:40:26:Connection Establisment started
28-08-2025 11:40:26:Connection Read From File  : Status OK 
28-08-2025 11:40:26:Connection Successfully Opened  : Status OK 
28-08-2025 11:40:26:ValidateAcNo CBS A/C No : 001001011946
28-08-2025 11:40:26:CBS A/C No : 001001011946
28-08-2025 11:40:26: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
28-08-2025 11:40:26:Record Count : 1
28-08-2025 11:40:26:BRLENGTH 3
28-08-2025 11:40:26:SCHLENGTH 3
28-08-2025 11:40:26:ACLENGTH 6
28-08-2025 11:40:26:Branch Code 3
28-08-2025 11:40:26:Scheme Code 3
28-08-2025 11:40:26:Account No 3
28-08-2025 11:40:26:Link Main Started
28-08-2025 11:40:26:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:40:26:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:40:26:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|011946|SB |001
28-08-2025 11:40:26:Validation Account Proce Executed with out error Y
28-08-2025 11:40:26:ValidationRequest Exccution Success with response :  000
28-08-2025 11:40:26:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:40:26:Connection Successfully Opened  : Status OK 
28-08-2025 11:40:26:ValidateAcNo CBS A/C No : 001002000319
28-08-2025 11:40:26:CBS A/C No : 001002000319
28-08-2025 11:40:26: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
28-08-2025 11:40:26:Record Count : 1
28-08-2025 11:40:26:BRLENGTH 3
28-08-2025 11:40:26:SCHLENGTH 3
28-08-2025 11:40:26:ACLENGTH 6
28-08-2025 11:40:26:Branch Code 3
28-08-2025 11:40:26:Scheme Code 3
28-08-2025 11:40:26:Account No 3
28-08-2025 11:40:26:Link Main Started
28-08-2025 11:40:26:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:40:26:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:40:26:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000319|CD |001
28-08-2025 11:40:26:Validation Account Proce Executed with out error Y
28-08-2025 11:40:26:ValidationRequest Exccution Success with response :  000
28-08-2025 11:40:26:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:40:26:<------------------------Started ValidationRequest CBS A/C No : 001001004009 ------------------------>
28-08-2025 11:40:26:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:40:26:Connection Establisment started
28-08-2025 11:40:26:Connection Read From File  : Status OK 
28-08-2025 11:40:26:Connection Successfully Opened  : Status OK 
28-08-2025 11:40:26:ValidateAcNo CBS A/C No : 001001013000
28-08-2025 11:40:26:CBS A/C No : 001001013000
28-08-2025 11:40:26: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
28-08-2025 11:40:26:Record Count : 1
28-08-2025 11:40:26:BRLENGTH 3
28-08-2025 11:40:26:SCHLENGTH 3
28-08-2025 11:40:26:ACLENGTH 6
28-08-2025 11:40:26:Branch Code 3
28-08-2025 11:40:26:Scheme Code 3
28-08-2025 11:40:26:Account No 3
28-08-2025 11:40:26:Link Main Started
28-08-2025 11:40:26:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:40:26:<------------------------Started ValidationRequest CBS A/C No : 0000001002000487 ------------------------>
28-08-2025 11:40:26:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:40:26:Connection Establisment started
28-08-2025 11:40:26:Connection Read From File  : Status OK 
28-08-2025 11:40:26:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:40:26:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|013000|SB |001
28-08-2025 11:40:26:Validation Account Proce Executed with out error Y
28-08-2025 11:40:26:ValidationRequest Exccution Success with response :  000
28-08-2025 11:40:26:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:40:26:<------------------------Started ValidationRequest CBS A/C No : 0000001001012120 ------------------------>
28-08-2025 11:40:26:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:40:26:Connection Establisment started
28-08-2025 11:40:26:Connection Read From File  : Status OK 
28-08-2025 11:40:26:Connection Successfully Opened  : Status OK 
28-08-2025 11:40:26:ValidateAcNo CBS A/C No : 001001011909
28-08-2025 11:40:26:CBS A/C No : 001001011909
28-08-2025 11:40:26: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
28-08-2025 11:40:26:Record Count : 1
28-08-2025 11:40:26:BRLENGTH 3
28-08-2025 11:40:26:SCHLENGTH 3
28-08-2025 11:40:26:ACLENGTH 6
28-08-2025 11:40:26:Branch Code 3
28-08-2025 11:40:26:Scheme Code 3
28-08-2025 11:40:26:Account No 3
28-08-2025 11:40:26:Link Main Started
28-08-2025 11:40:26:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:40:26:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:40:26:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|011909|SB |001
28-08-2025 11:40:26:Validation Account Proce Executed with out error Y
28-08-2025 11:40:26:ValidationRequest Exccution Success with response :  000
28-08-2025 11:40:26:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:40:26:Connection Successfully Opened  : Status OK 
28-08-2025 11:40:26:ValidateAcNo CBS A/C No : 001001005543
28-08-2025 11:40:26:CBS A/C No : 001001005543
28-08-2025 11:40:26: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
28-08-2025 11:40:26:Record Count : 1
28-08-2025 11:40:26:BRLENGTH 3
28-08-2025 11:40:26:SCHLENGTH 3
28-08-2025 11:40:26:ACLENGTH 6
28-08-2025 11:40:26:Branch Code 3
28-08-2025 11:40:26:Scheme Code 3
28-08-2025 11:40:26:Account No 3
28-08-2025 11:40:26:Link Main Started
28-08-2025 11:40:26:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:40:26:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:40:26:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|005543|SB |001
28-08-2025 11:40:26:Validation Account Proce Executed with out error Y
28-08-2025 11:40:26:ValidationRequest Exccution Success with response :  000
28-08-2025 11:40:26:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:40:26:Connection Successfully Opened  : Status OK 
28-08-2025 11:40:26:ValidateAcNo CBS A/C No : 001001004009
28-08-2025 11:40:26:CBS A/C No : 001001004009
28-08-2025 11:40:26: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
28-08-2025 11:40:26:Record Count : 1
28-08-2025 11:40:26:BRLENGTH 3
28-08-2025 11:40:26:SCHLENGTH 3
28-08-2025 11:40:26:ACLENGTH 6
28-08-2025 11:40:26:Branch Code 3
28-08-2025 11:40:26:Scheme Code 3
28-08-2025 11:40:26:Account No 3
28-08-2025 11:40:26:Link Main Started
28-08-2025 11:40:26:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:40:26:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:40:26:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|004009|SB |001
28-08-2025 11:40:26:Validation Account Proce Executed with out error Y
28-08-2025 11:40:26:ValidationRequest Exccution Success with response :  000
28-08-2025 11:40:26:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:40:26:Connection Successfully Opened  : Status OK 
28-08-2025 11:40:26:ValidateAcNo CBS A/C No : 0000001002000487
28-08-2025 11:40:26:Validation Account Proce Executed with out error N
28-08-2025 11:40:26:ValidationRequest Exccution Success with response :  111
28-08-2025 11:40:26:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:40:26:<------------------------Started ValidationRequest CBS A/C No : 001002000833 ------------------------>
28-08-2025 11:40:26:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:40:26:Connection Establisment started
28-08-2025 11:40:26:Connection Read From File  : Status OK 
28-08-2025 11:40:26:<------------------------Started ValidationRequest CBS A/C No : 002001000068 ------------------------>
28-08-2025 11:40:26:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:40:26:Connection Establisment started
28-08-2025 11:40:26:Connection Read From File  : Status OK 
28-08-2025 11:40:26:Connection Successfully Opened  : Status OK 
28-08-2025 11:40:26:ValidateAcNo CBS A/C No : 0000001001012120
28-08-2025 11:40:26:Validation Account Proce Executed with out error N
28-08-2025 11:40:26:ValidationRequest Exccution Success with response :  111
28-08-2025 11:40:26:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:40:26:Connection Successfully Opened  : Status OK 
28-08-2025 11:40:26:ValidateAcNo CBS A/C No : 001002000833
28-08-2025 11:40:26:CBS A/C No : 001002000833
28-08-2025 11:40:26: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
28-08-2025 11:40:26:Record Count : 1
28-08-2025 11:40:26:BRLENGTH 3
28-08-2025 11:40:26:SCHLENGTH 3
28-08-2025 11:40:26:ACLENGTH 6
28-08-2025 11:40:26:Branch Code 3
28-08-2025 11:40:26:Scheme Code 3
28-08-2025 11:40:26:Account No 3
28-08-2025 11:40:26:Link Main Started
28-08-2025 11:40:26:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:40:26:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:40:26:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000833|CD |001
28-08-2025 11:40:26:Validation Account Proce Executed with out error Y
28-08-2025 11:40:26:ValidationRequest Exccution Success with response :  000
28-08-2025 11:40:26:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:40:26:Connection Successfully Opened  : Status OK 
28-08-2025 11:40:26:ValidateAcNo CBS A/C No : 002001000068
28-08-2025 11:40:26:CBS A/C No : 002001000068
28-08-2025 11:40:26: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
28-08-2025 11:40:26:Record Count : 1
28-08-2025 11:40:26:BRLENGTH 3
28-08-2025 11:40:26:SCHLENGTH 3
28-08-2025 11:40:26:ACLENGTH 6
28-08-2025 11:40:26:Branch Code 3
28-08-2025 11:40:26:Scheme Code 3
28-08-2025 11:40:26:Account No 3
28-08-2025 11:40:26:Link Main Started
28-08-2025 11:40:26:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:40:26:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 002
28-08-2025 11:40:26:ShowCBS Ac No Proce Executed  BARDANSAL|DEPOSIT|000068|SB |002
28-08-2025 11:40:26:Validation Account Proce Executed with out error Y
28-08-2025 11:40:26:ValidationRequest Exccution Success with response :  000
28-08-2025 11:40:26:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:50:10:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN24026062273|001002000319 -------------------------->
28-08-2025 11:50:10:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:50:10:Connection Establisment started
28-08-2025 11:50:10:Connection Read From File  : Status OK 
28-08-2025 11:50:10:Connection Successfully Opened  : Status OK 
28-08-2025 11:50:10:ValidateAcNo CBS A/C No : 001002000319
28-08-2025 11:50:10:CBS A/C No : 001002000319
28-08-2025 11:50:10:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 11:50:10:Record Count : 1
28-08-2025 11:50:10:BRLENGTH 3
28-08-2025 11:50:10:SCHLENGTH 3
28-08-2025 11:50:10:ACLENGTH 6
28-08-2025 11:50:10:Branch Code 3
28-08-2025 11:50:10:Scheme Code 3
28-08-2025 11:50:10:Account No 3
28-08-2025 11:50:10:Link Main Started
28-08-2025 11:50:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:50:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:50:10:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000319|CD |001
28-08-2025 11:50:10:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN24026064078|001002000833 -------------------------->
28-08-2025 11:50:10:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:50:10:Connection Establisment started
28-08-2025 11:50:10:Connection Read From File  : Status OK 
28-08-2025 11:50:10:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM24026069970|001001011330 -------------------------->
28-08-2025 11:50:10:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:50:10:Connection Establisment started
28-08-2025 11:50:10:Connection Read From File  : Status OK 
28-08-2025 11:50:10:Validation Account Proce Executed with out error Y
28-08-2025 11:50:10:Connection Successfully Opened  : Status OK 
28-08-2025 11:50:10:ValidateAcNo CBS A/C No : 001001011330
28-08-2025 11:50:10:CBS A/C No : 001001011330
28-08-2025 11:50:10:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 11:50:10:Record Count : 1
28-08-2025 11:50:10:BRLENGTH 3
28-08-2025 11:50:10:SCHLENGTH 3
28-08-2025 11:50:10:Connection Read From File  : Status OK 
28-08-2025 11:50:10:Branch Code 3
28-08-2025 11:50:10:Scheme Code 3
28-08-2025 11:50:10:Account No 3
28-08-2025 11:50:10:Link Main Started
28-08-2025 11:50:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:50:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:50:10:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|011330|SB |001
28-08-2025 11:50:10:Validation Account Proce Executed with out error Y
28-08-2025 11:50:10:Connection Establisment started
28-08-2025 11:50:10:Connection Read From File  : Status OK 
28-08-2025 11:50:10:CBS A/C No : 001002000319
28-08-2025 11:50:10:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 11:50:10:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM24026069295|001001002467 -------------------------->
28-08-2025 11:50:10:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:50:10:Connection Establisment started
28-08-2025 11:50:10:Connection Read From File  : Status OK 
28-08-2025 11:50:10:Record Count : 1
28-08-2025 11:50:10:BRLENGTH 3
28-08-2025 11:50:10:SCHLENGTH 3
28-08-2025 11:50:10:ACLENGTH 6
28-08-2025 11:50:10:Branch Code 3
28-08-2025 11:50:10:Scheme Code 3
28-08-2025 11:50:10:Account No 3
28-08-2025 11:50:10:Link Main Started
28-08-2025 11:50:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:50:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:50:10:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000319|CD |001
28-08-2025 11:50:10:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN24026064048|001001003013 -------------------------->
28-08-2025 11:50:10:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:50:10:Connection Establisment started
28-08-2025 11:50:10:Connection Read From File  : Status OK 
28-08-2025 11:50:10:Connection Successfully Opened  : Status OK 
28-08-2025 11:50:10:ValidateAcNo CBS A/C No : 001002000833
28-08-2025 11:50:10:CBS A/C No : 001002000833
28-08-2025 11:50:10:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 11:50:10:Record Count : 1
28-08-2025 11:50:10:BRLENGTH 3
28-08-2025 11:50:10:SCHLENGTH 3
28-08-2025 11:50:10:ACLENGTH 6
28-08-2025 11:50:10:Branch Code 3
28-08-2025 11:50:10:Scheme Code 3
28-08-2025 11:50:10:Account No 3
28-08-2025 11:50:10:Link Main Started
28-08-2025 11:50:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:50:10:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM24026069820|002001000068 -------------------------->
28-08-2025 11:50:10:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:50:10:Connection Establisment started
28-08-2025 11:50:10:Connection Read From File  : Status OK 
28-08-2025 11:50:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:50:10:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000833|CD |001
28-08-2025 11:50:10:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN24026064068|002001000308 -------------------------->
28-08-2025 11:50:10:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:50:10:Connection Establisment started
28-08-2025 11:50:10:Connection Read From File  : Status OK 
28-08-2025 11:50:10:Validation Account Proce Executed with out error Y
28-08-2025 11:50:10:Connection Establisment started
28-08-2025 11:50:10:Connection Successfully Opened  : Status OK 
28-08-2025 11:50:10:Connection Read From File  : Status OK 
28-08-2025 11:50:10:CBS A/C No : 001001002467
28-08-2025 11:50:10:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 11:50:10:Record Count : 1
28-08-2025 11:50:10:BRLENGTH 3
28-08-2025 11:50:10:SCHLENGTH 3
28-08-2025 11:50:10:ACLENGTH 6
28-08-2025 11:50:10:Branch Code 3
28-08-2025 11:50:10:Scheme Code 3
28-08-2025 11:50:10:Account No 3
28-08-2025 11:50:10:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN24026062280|001001013000 -------------------------->
28-08-2025 11:50:10:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:50:10:Connection Establisment started
28-08-2025 11:50:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:50:10:Connection Read From File  : Status OK 
28-08-2025 11:50:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:50:10:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|002467|SB |001
28-08-2025 11:50:10:Validation Account Proce Executed with out error Y
28-08-2025 11:50:10:Connection Establisment started
28-08-2025 11:50:10:Connection Read From File  : Status OK 
28-08-2025 11:50:10:ValidateAcNo CBS A/C No : 001001003013
28-08-2025 11:50:10:CBS A/C No : 001001003013
28-08-2025 11:50:10:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 11:50:10:Record Count : 1
28-08-2025 11:50:10:BRLENGTH 3
28-08-2025 11:50:10:SCHLENGTH 3
28-08-2025 11:50:10:ACLENGTH 6
28-08-2025 11:50:10:Branch Code 3
28-08-2025 11:50:10:Scheme Code 3
28-08-2025 11:50:10:Account No 3
28-08-2025 11:50:10:Link Main Started
28-08-2025 11:50:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:50:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:50:10:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|003013|SB |001
28-08-2025 11:50:10:Validation Account Proce Executed with out error Y
28-08-2025 11:50:10:Connection Establisment started
28-08-2025 11:50:10:Connection Successfully Opened  : Status OK 
28-08-2025 11:50:10:ValidateAcNo CBS A/C No : 002001000068
28-08-2025 11:50:10:Connection Read From File  : Status OK 
28-08-2025 11:50:10:CBS A/C No : 002001000068
28-08-2025 11:50:10:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 11:50:10:Record Count : 1
28-08-2025 11:50:10:BRLENGTH 3
28-08-2025 11:50:10:SCHLENGTH 3
28-08-2025 11:50:10:ACLENGTH 6
28-08-2025 11:50:10:Branch Code 3
28-08-2025 11:50:10:Scheme Code 3
28-08-2025 11:50:10:Account No 3
28-08-2025 11:50:10:Link Main Started
28-08-2025 11:50:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:50:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 002
28-08-2025 11:50:10:ShowCBS Ac No Proce Executed  BARDANSAL|DEPOSIT|000068|SB |002
28-08-2025 11:50:10:Validation Account Proce Executed with out error Y
28-08-2025 11:50:10:Connection Establisment started
28-08-2025 11:50:10:Connection Read From File  : Status OK 
28-08-2025 11:50:10:ValidateAcNo CBS A/C No : 002001000308
28-08-2025 11:50:10:CBS A/C No : 002001000308
28-08-2025 11:50:10:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 11:50:10:Record Count : 1
28-08-2025 11:50:10:BRLENGTH 3
28-08-2025 11:50:10:SCHLENGTH 3
28-08-2025 11:50:10:ACLENGTH 6
28-08-2025 11:50:10:Branch Code 3
28-08-2025 11:50:10:Scheme Code 3
28-08-2025 11:50:10:Account No 3
28-08-2025 11:50:10:Link Main Started
28-08-2025 11:50:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:50:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 002
28-08-2025 11:50:10:ShowCBS Ac No Proce Executed  BARDANSAL|DEPOSIT|000308|SB |002
28-08-2025 11:50:10:Validation Account Proce Executed with out error Y
28-08-2025 11:50:10:Connection Establisment started
28-08-2025 11:50:10:Connection Successfully Opened  : Status OK 
28-08-2025 11:50:10:Connection Read From File  : Status OK 
28-08-2025 11:50:10:CBS A/C No : 001002000833
28-08-2025 11:50:10:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 11:50:10:Record Count : 1
28-08-2025 11:50:10:BRLENGTH 3
28-08-2025 11:50:10:SCHLENGTH 3
28-08-2025 11:50:10:ACLENGTH 6
28-08-2025 11:50:10:Branch Code 3
28-08-2025 11:50:10:Scheme Code 3
28-08-2025 11:50:10:Account No 3
28-08-2025 11:50:10:Link Main Started
28-08-2025 11:50:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:50:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:50:10:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000833|CD |001
28-08-2025 11:50:10:Vno --->:71989
28-08-2025 11:50:10:Current Date  --->:28-08-2025
28-08-2025 11:50:10:Vno --->:71988
28-08-2025 11:50:10:Current Date  --->:28-08-2025
28-08-2025 11:50:10:Connection Successfully Opened  : Status OK 
28-08-2025 11:50:10:CBS A/C No : 001001011330
28-08-2025 11:50:10:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 11:50:10:Record Count : 1
28-08-2025 11:50:10:BRLENGTH 3
28-08-2025 11:50:10:SCHLENGTH 3
28-08-2025 11:50:10:ACLENGTH 6
28-08-2025 11:50:10:Branch Code 3
28-08-2025 11:50:10:Scheme Code 3
28-08-2025 11:50:10:Account No 3
28-08-2025 11:50:10:Link Main Started
28-08-2025 11:50:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:50:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:50:10:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|011330|SB |001
28-08-2025 11:50:10:calling  CallNewRtgsBothProc 
28-08-2025 11:50:10:Parameters passing - InwardAuthorise 
28-08-2025 11:50:10:calling  CallNewRtgsBothProc 
28-08-2025 11:50:10:Parameters passing - InwardAuthorise 
28-08-2025 11:50:10: brn =001
28-08-2025 11:50:10: acno =000319
28-08-2025 11:50:10: acno =000833
28-08-2025 11:50:10: abbr =CD
28-08-2025 11:50:10: amt.ToString() =390
28-08-2025 11:50:10: traceNo =71988
28-08-2025 11:50:10: amt.ToString() =345
28-08-2025 11:50:10: traceNo =71989
28-08-2025 11:50:10: narr =NEFT, BY PHONEPE LIMITED-PAYMENT AGGREGATOR ESCROW ACCOUNT UTIB0001506 922020004688715
28-08-2025 11:50:10:Transaction Process :  BEFORE CAL PROC:
28-08-2025 11:50:10:Transaction Process :  BEFORE CAL PROC:
28-08-2025 11:50:10:Vno --->:71990
28-08-2025 11:50:10:Current Date  --->:28-08-2025
28-08-2025 11:50:10:calling  CallNewRtgsBothProc 
28-08-2025 11:50:10:Parameters passing - InwardAuthorise 
28-08-2025 11:50:10: brn =001
28-08-2025 11:50:10: acno =011330
28-08-2025 11:50:10: abbr =SB
28-08-2025 11:50:10: amt.ToString() =1010
28-08-2025 11:50:10: traceNo =71990
28-08-2025 11:50:10: narr =NEFT, BY ONE 97 COMMUNICATIONS LIMITED ESCROW ACCOUNT _01 UTIB0000022 924020007330961
28-08-2025 11:50:10:Transaction Process :  BEFORE CAL PROC:
28-08-2025 11:50:10:Connection Successfully Opened  : Status OK 
28-08-2025 11:50:10:ValidateAcNo CBS A/C No : 001001013000
28-08-2025 11:50:10:CBS A/C No : 001001013000
28-08-2025 11:50:10:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 11:50:10:Record Count : 1
28-08-2025 11:50:10:BRLENGTH 3
28-08-2025 11:50:10:SCHLENGTH 3
28-08-2025 11:50:10:ACLENGTH 6
28-08-2025 11:50:10:Branch Code 3
28-08-2025 11:50:10:Scheme Code 3
28-08-2025 11:50:10:Account No 3
28-08-2025 11:50:10:Link Main Started
28-08-2025 11:50:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:50:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:50:10:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|013000|SB |001
28-08-2025 11:50:10:Validation Account Proce Executed with out error Y
28-08-2025 11:50:10:Connection Establisment started
28-08-2025 11:50:10:Connection Successfully Opened  : Status OK 
28-08-2025 11:50:10:Connection Read From File  : Status OK 
28-08-2025 11:50:10:CBS A/C No : 001001003013
28-08-2025 11:50:10:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 11:50:10:Record Count : 1
28-08-2025 11:50:10:BRLENGTH 3
28-08-2025 11:50:10:SCHLENGTH 3
28-08-2025 11:50:10:ACLENGTH 6
28-08-2025 11:50:10:Branch Code 3
28-08-2025 11:50:10:Scheme Code 3
28-08-2025 11:50:10:Account No 3
28-08-2025 11:50:10:Link Main Started
28-08-2025 11:50:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:50:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:50:10:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|003013|SB |001
28-08-2025 11:50:10:Vno --->:71991
28-08-2025 11:50:10:Current Date  --->:28-08-2025
28-08-2025 11:50:10:calling  CallNewRtgsBothProc 
28-08-2025 11:50:10:Parameters passing - InwardAuthorise 
28-08-2025 11:50:10: brn =001
28-08-2025 11:50:10: acno =003013
28-08-2025 11:50:10: abbr =SB
28-08-2025 11:50:10: amt.ToString() =435
28-08-2025 11:50:10: traceNo =71991
28-08-2025 11:50:10: narr =NEFT, BY PHONEPE LIMITED-PAYMENT AGGREGATOR ESCROW ACCOUNT UTIB0001506 922020004688715
28-08-2025 11:50:10:Transaction Process :  BEFORE CAL PROC:
28-08-2025 11:50:10:Connection Successfully Opened  : Status OK 
28-08-2025 11:50:10:CBS A/C No : 001001002467
28-08-2025 11:50:10:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 11:50:10:Record Count : 1
28-08-2025 11:50:10:BRLENGTH 3
28-08-2025 11:50:10:SCHLENGTH 3
28-08-2025 11:50:10:ACLENGTH 6
28-08-2025 11:50:10:Branch Code 3
28-08-2025 11:50:10:Scheme Code 3
28-08-2025 11:50:10:Account No 3
28-08-2025 11:50:10:Link Main Started
28-08-2025 11:50:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:50:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:50:10:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|002467|SB |001
28-08-2025 11:50:10:Vno --->:71992
28-08-2025 11:50:10:Current Date  --->:28-08-2025
28-08-2025 11:50:10:calling  CallNewRtgsBothProc 
28-08-2025 11:50:10:Parameters passing - InwardAuthorise 
28-08-2025 11:50:10: brn =001
28-08-2025 11:50:10: acno =002467
28-08-2025 11:50:10: abbr =SB
28-08-2025 11:50:10: amt.ToString() =687
28-08-2025 11:50:10: traceNo =71992
28-08-2025 11:50:10: narr =NEFT, BY ONE 97 COMMUNICATIONS LIMITED ESCROW ACCOUNT _01 UTIB0000022 924020007330961
28-08-2025 11:50:10:Transaction Process :  BEFORE CAL PROC:
28-08-2025 11:50:10:cbs no--->001002000833
28-08-2025 11:50:10:CBS A/C No : 001002000833
28-08-2025 11:50:10:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 11:50:10:Record Count : 1
28-08-2025 11:50:10:BRLENGTH 3
28-08-2025 11:50:10:SCHLENGTH 3
28-08-2025 11:50:10:ACLENGTH 6
28-08-2025 11:50:10:Branch Code 3
28-08-2025 11:50:10:Scheme Code 3
28-08-2025 11:50:10:Account No 3
28-08-2025 11:50:10:Link Main Started
28-08-2025 11:50:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:50:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:50:10:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000833|CD |001
28-08-2025 11:50:10:cbs no--->001002000319
28-08-2025 11:50:10:CBS A/C No : 001002000319
28-08-2025 11:50:10:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 11:50:10:Record Count : 1
28-08-2025 11:50:10:BRLENGTH 3
28-08-2025 11:50:10:SCHLENGTH 3
28-08-2025 11:50:10:ACLENGTH 6
28-08-2025 11:50:10:Branch Code 3
28-08-2025 11:50:10:Scheme Code 3
28-08-2025 11:50:10:Account No 3
28-08-2025 11:50:10:Link Main Started
28-08-2025 11:50:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:50:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:50:10:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000319|CD |001
28-08-2025 11:50:10:Closed YN quier  --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG,DSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM  clientmaster,depositmaster,depositschemesetup,ADDRESS  where CLMS_SNO=DEPM_CLIENT AND DSCH_BRANCH = DEPM_BRANCH AND DSCH_ABBR = DEPM_ABBR  and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='CD'  AND DEPM_NO=000319  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=000319  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=000319  AND ADDR_SNO=CLMS_ADDRESS
28-08-2025 11:50:10:Connection Successfully Opened  : Status OK 
28-08-2025 11:50:10:CBS A/C No : 002001000068
28-08-2025 11:50:10:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 11:50:10:Record Count : 1
28-08-2025 11:50:10:BRLENGTH 3
28-08-2025 11:50:10:SCHLENGTH 3
28-08-2025 11:50:10:ACLENGTH 6
28-08-2025 11:50:10:Branch Code 3
28-08-2025 11:50:10:Scheme Code 3
28-08-2025 11:50:10:Account No 3
28-08-2025 11:50:10:Link Main Started
28-08-2025 11:50:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:50:10:cbs no--->001001003013
28-08-2025 11:50:10:CBS A/C No : 001001003013
28-08-2025 11:50:10:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 11:50:10:ShowCBS Ac No Proce Executed  BARDANSAL|DEPOSIT|000068|SB |002
28-08-2025 11:50:10:Record Count : 1
28-08-2025 11:50:10:BRLENGTH 3
28-08-2025 11:50:10:SCHLENGTH 3
28-08-2025 11:50:10:ACLENGTH 6
28-08-2025 11:50:10:Branch Code 3
28-08-2025 11:50:10:Scheme Code 3
28-08-2025 11:50:10:Account No 3
28-08-2025 11:50:10:Link Main Started
28-08-2025 11:50:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:50:10:closed y n Record count --->1
28-08-2025 11:50:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:50:10:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|003013|SB |001
28-08-2025 11:50:10:Closed YN quier  --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG,DSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM  clientmaster,depositmaster,depositschemesetup,ADDRESS  where CLMS_SNO=DEPM_CLIENT AND DSCH_BRANCH = DEPM_BRANCH AND DSCH_ABBR = DEPM_ABBR  and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB'  AND DEPM_NO=003013  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=003013  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=003013  AND ADDR_SNO=CLMS_ADDRESS
28-08-2025 11:50:10:closed y n Record count --->1
28-08-2025 11:50:10:Vno --->:71993
28-08-2025 11:50:10:Current Date  --->:28-08-2025
28-08-2025 11:50:10:calling  CallNewRtgsBothProc 
28-08-2025 11:50:10:Parameters passing - InwardAuthorise 
28-08-2025 11:50:10: brn =002
28-08-2025 11:50:10: acno =000068
28-08-2025 11:50:10: abbr =SB
28-08-2025 11:50:10: amt.ToString() =100
28-08-2025 11:50:10: traceNo =71993
28-08-2025 11:50:10: narr =NEFT, BY ONE 97 COMMUNICATIONS LIMITED ESCROW ACCOUNT _01 UTIB0000022 924020007330961
28-08-2025 11:50:10:Transaction Process :  BEFORE CAL PROC:
28-08-2025 11:50:10:closed y n Record count --->1
28-08-2025 11:50:10:Connection Successfully Opened  : Status OK 
28-08-2025 11:50:10:CBS A/C No : 002001000308
28-08-2025 11:50:10:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 11:50:10:Record Count : 1
28-08-2025 11:50:10:BRLENGTH 3
28-08-2025 11:50:10:SCHLENGTH 3
28-08-2025 11:50:10:ACLENGTH 6
28-08-2025 11:50:10:Branch Code 3
28-08-2025 11:50:10:Scheme Code 3
28-08-2025 11:50:10:Account No 3
28-08-2025 11:50:10:Link Main Started
28-08-2025 11:50:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:50:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 002
28-08-2025 11:50:10:ShowCBS Ac No Proce Executed  BARDANSAL|DEPOSIT|000308|SB |002
28-08-2025 11:50:10:Vno --->:71994
28-08-2025 11:50:10:Current Date  --->:28-08-2025
28-08-2025 11:50:10:calling  CallNewRtgsBothProc 
28-08-2025 11:50:10:Parameters passing - InwardAuthorise 
28-08-2025 11:50:10: brn =002
28-08-2025 11:50:10: acno =000308
28-08-2025 11:50:10: abbr =SB
28-08-2025 11:50:10: amt.ToString() =190
28-08-2025 11:50:10: traceNo =71994
28-08-2025 11:50:10: narr =NEFT, BY PHONEPE LIMITED-PAYMENT AGGREGATOR ESCROW ACCOUNT UTIB0001506 922020004688715
28-08-2025 11:50:10:Transaction Process :  BEFORE CAL PROC:
28-08-2025 11:50:10:cbs no--->002001000068
28-08-2025 11:50:10:CBS A/C No : 002001000068
28-08-2025 11:50:10:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 11:50:10:Record Count : 1
28-08-2025 11:50:10:BRLENGTH 3
28-08-2025 11:50:10:SCHLENGTH 3
28-08-2025 11:50:10:ACLENGTH 6
28-08-2025 11:50:10:Branch Code 3
28-08-2025 11:50:10:Scheme Code 3
28-08-2025 11:50:10:Account No 3
28-08-2025 11:50:10:Link Main Started
28-08-2025 11:50:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:50:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 002
28-08-2025 11:50:10:ShowCBS Ac No Proce Executed  BARDANSAL|DEPOSIT|000068|SB |002
28-08-2025 11:50:10:Closed YN quier  --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG,DSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM  clientmaster,depositmaster,depositschemesetup,ADDRESS  where CLMS_SNO=DEPM_CLIENT AND DSCH_BRANCH = DEPM_BRANCH AND DSCH_ABBR = DEPM_ABBR  and DEPM_BRANCH=002 and TRIM(DEPM_ABBR)='SB'  AND DEPM_NO=000068  AND ADDR_SNO=CLMS_ADDRESS union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG,LSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM  clientmaster,LOANMASTER,LOANSCHEMESETUP,ADDRESS  where CLMS_SNO=LOAM_CLIENT  AND LSCH_BRANCH = LOAM_BRANCH AND LSCH_ABBREV = LOAM_ABBR and LOAM_BRANCH =002 and TRIM(LOAM_ABBR)='SB'  AND LOAM_NO=000068  AND ADDR_SNO=CLMS_ADDRESS UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG,ODST_GLLINK AS GLLINK,ADDR_MOBILENO FROM  clientmaster,ODMASTER,ODSCHEMESETUP,ADDRESS  where CLMS_SNO=ODMT_CLIENT AND ODST_BRANCH = ODMT_BRANCH AND ODST_ABBR = ODMT_ABBR and ODMT_BRANCH=002 and TRIM(ODMT_ABBR)='SB'  AND ODMT_NO=000068  AND ADDR_SNO=CLMS_ADDRESS
28-08-2025 11:50:10:Connection Successfully Opened  : Status OK 
28-08-2025 11:50:10:CBS A/C No : 001001013000
28-08-2025 11:50:10:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 11:50:10:Record Count : 1
28-08-2025 11:50:10:BRLENGTH 3
28-08-2025 11:50:10:SCHLENGTH 3
28-08-2025 11:50:10:ACLENGTH 6
28-08-2025 11:50:10:Branch Code 3
28-08-2025 11:50:10:Scheme Code 3
28-08-2025 11:50:10:Account No 3
28-08-2025 11:50:10:Link Main Started
28-08-2025 11:50:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:50:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:50:10:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|013000|SB |001
28-08-2025 11:50:10:Vno --->:71995
28-08-2025 11:50:10:Current Date  --->:28-08-2025
28-08-2025 11:50:10:calling  CallNewRtgsBothProc 
28-08-2025 11:50:10:Parameters passing - InwardAuthorise 
28-08-2025 11:50:10: brn =001
28-08-2025 11:50:10: acno =013000
28-08-2025 11:50:10: abbr =SB
28-08-2025 11:50:10: amt.ToString() =300
28-08-2025 11:50:10: traceNo =71995
28-08-2025 11:50:10: narr =NEFT, BY PHONEPE LIMITED-PAYMENT AGGREGATOR ESCROW ACCOUNT UTIB0001506 922020004688715
28-08-2025 11:50:10:Transaction Process :  BEFORE CAL PROC:
28-08-2025 11:50:10:SMS Inserted for Mobile Number : +919886958966
28-08-2025 11:50:10:cbs no--->001001013000
28-08-2025 11:50:10:CBS A/C No : 001001013000
28-08-2025 11:50:10:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 11:50:10:Record Count : 1
28-08-2025 11:50:10:BRLENGTH 3
28-08-2025 11:50:10:SCHLENGTH 3
28-08-2025 11:50:10:ACLENGTH 6
28-08-2025 11:50:10:Branch Code 3
28-08-2025 11:50:10:Scheme Code 3
28-08-2025 11:50:10:Account No 3
28-08-2025 11:50:10:Link Main Started
28-08-2025 11:50:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:50:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:50:10:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|013000|SB |001
28-08-2025 11:50:10:Closed YN quier  --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG,DSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM  clientmaster,depositmaster,depositschemesetup,ADDRESS  where CLMS_SNO=DEPM_CLIENT AND DSCH_BRANCH = DEPM_BRANCH AND DSCH_ABBR = DEPM_ABBR  and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB'  AND DEPM_NO=013000  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=013000  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=013000  AND ADDR_SNO=CLMS_ADDRESS
28-08-2025 11:50:10:cbs no--->002001000308
28-08-2025 11:50:10:CBS A/C No : 002001000308
28-08-2025 11:50:10:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 11:50:10:Record Count : 1
28-08-2025 11:50:10:BRLENGTH 3
28-08-2025 11:50:10:SCHLENGTH 3
28-08-2025 11:50:10:ACLENGTH 6
28-08-2025 11:50:10:Branch Code 3
28-08-2025 11:50:10:Scheme Code 3
28-08-2025 11:50:10:Account No 3
28-08-2025 11:50:10:Link Main Started
28-08-2025 11:50:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:50:10:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN24026064066|001001004009 -------------------------->
28-08-2025 11:50:10:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:50:10:Connection Establisment started
28-08-2025 11:50:10:Connection Read From File  : Status OK 
28-08-2025 11:50:10:ShowCBS Ac No Proce Executed  BARDANSAL|DEPOSIT|000308|SB |002
28-08-2025 11:50:10:Closed YN quier  --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG,DSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM  clientmaster,depositmaster,depositschemesetup,ADDRESS  where CLMS_SNO=DEPM_CLIENT AND DSCH_BRANCH = DEPM_BRANCH AND DSCH_ABBR = DEPM_ABBR  and DEPM_BRANCH=002 and TRIM(DEPM_ABBR)='SB'  AND DEPM_NO=000308  AND ADDR_SNO=CLMS_ADDRESS union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG,LSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM  clientmaster,LOANMASTER,LOANSCHEMESETUP,ADDRESS  where CLMS_SNO=LOAM_CLIENT  AND LSCH_BRANCH = LOAM_BRANCH AND LSCH_ABBREV = LOAM_ABBR and LOAM_BRANCH =002 and TRIM(LOAM_ABBR)='SB'  AND LOAM_NO=000308  AND ADDR_SNO=CLMS_ADDRESS UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG,ODST_GLLINK AS GLLINK,ADDR_MOBILENO FROM  clientmaster,ODMASTER,ODSCHEMESETUP,ADDRESS  where CLMS_SNO=ODMT_CLIENT AND ODST_BRANCH = ODMT_BRANCH AND ODST_ABBR = ODMT_ABBR and ODMT_BRANCH=002 and TRIM(ODMT_ABBR)='SB'  AND ODMT_NO=000308  AND ADDR_SNO=CLMS_ADDRESS
28-08-2025 11:50:11:SMS Inserted for Mobile Number : +919902598578
28-08-2025 11:50:11:closed y n Record count --->1
28-08-2025 11:50:11:closed y n Record count --->1
28-08-2025 11:50:11:SMS Inserted for Mobile Number : +919901351118
28-08-2025 11:50:11:SMS Inserted for Mobile Number : +918123174703
28-08-2025 11:50:11:SMS Inserted for Mobile Number : +919448317015
28-08-2025 11:50:11:Inward Process Executed Sussefully
28-08-2025 11:50:11:Inward Process Executed Sussefully
28-08-2025 11:50:11:ConfirmationReq Execution Success with Status 000
28-08-2025 11:50:11:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM24026069970|001001011330 ------------------------------>
28-08-2025 11:50:11:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:50:11:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM24026069295|001001002467 ------------------------------>
28-08-2025 11:50:11:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:50:11:Connection Successfully Opened  : Status OK 
28-08-2025 11:50:11:ValidateAcNo CBS A/C No : 001001004009
28-08-2025 11:50:11:CBS A/C No : 001001004009
28-08-2025 11:50:11: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
28-08-2025 11:50:11:Record Count : 1
28-08-2025 11:50:11:BRLENGTH 3
28-08-2025 11:50:11:SCHLENGTH 3
28-08-2025 11:50:11:ACLENGTH 6
28-08-2025 11:50:11:Branch Code 3
28-08-2025 11:50:11:Scheme Code 3
28-08-2025 11:50:11:Account No 3
28-08-2025 11:50:11:Link Main Started
28-08-2025 11:50:11:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:50:11:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:50:11:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|004009|SB |001
28-08-2025 11:50:11:Validation Account Proce Executed with out error Y
28-08-2025 11:50:11:Connection Establisment started
28-08-2025 11:50:11:Connection Read From File  : Status OK 
28-08-2025 11:50:11:Connection Successfully Opened  : Status OK 
28-08-2025 11:50:11:CBS A/C No : 001001004009
28-08-2025 11:50:11: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
28-08-2025 11:50:11:Record Count : 1
28-08-2025 11:50:11:BRLENGTH 3
28-08-2025 11:50:11:SCHLENGTH 3
28-08-2025 11:50:11:ACLENGTH 6
28-08-2025 11:50:11:Branch Code 3
28-08-2025 11:50:11:Scheme Code 3
28-08-2025 11:50:11:Account No 3
28-08-2025 11:50:11:Link Main Started
28-08-2025 11:50:11:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:50:11:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:50:11:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|004009|SB |001
28-08-2025 11:50:11:Vno --->:71996
28-08-2025 11:50:11:Current Date  --->:28-08-2025
28-08-2025 11:50:11:calling  CallNewRtgsBothProc 
28-08-2025 11:50:11:Parameters passing - InwardAuthorise 
28-08-2025 11:50:11: brn =001
28-08-2025 11:50:11: acno =004009
28-08-2025 11:50:11: abbr =SB
28-08-2025 11:50:11: amt.ToString() =1326
28-08-2025 11:50:11: traceNo =71996
28-08-2025 11:50:11: narr =NEFT, BY PHONEPE LIMITED-PAYMENT AGGREGATOR ESCROW ACCOUNT UTIB0001506 922020004688715
28-08-2025 11:50:11:Transaction Process :  BEFORE CAL PROC:
28-08-2025 11:50:11:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM24026069824|001001011946 -------------------------->
28-08-2025 11:50:11:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:50:11:Connection Establisment started
28-08-2025 11:50:11:Connection Read From File  : Status OK 
28-08-2025 11:50:11:Inward Process Executed Sussefully
28-08-2025 11:50:11:Inward Process Executed Sussefully
28-08-2025 11:50:11:ConfirmationReq Execution Success with Status 000
28-08-2025 11:50:11:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN24026064078|001002000833 ------------------------------>
28-08-2025 11:50:11:Error ConfirmationReq  The process cannot access the file 'D:\IISPL\RTGSInward\SSLWCFSSK\log\2025-08-28T115011_RtgsNeftLog.txt' because it is being used by another process.
28-08-2025 11:50:11:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM24026069820|002001000068 ------------------------------>
28-08-2025 11:50:11:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:50:11:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:50:11:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN24026064048|001001003013 ------------------------------>
28-08-2025 11:50:11:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:50:11:Connection Successfully Opened  : Status OK 
28-08-2025 11:50:11:ValidateAcNo CBS A/C No : 001001011946
28-08-2025 11:50:11:CBS A/C No : 001001011946
28-08-2025 11:50:11: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
28-08-2025 11:50:11:Record Count : 1
28-08-2025 11:50:11:BRLENGTH 3
28-08-2025 11:50:11:SCHLENGTH 3
28-08-2025 11:50:11:ACLENGTH 6
28-08-2025 11:50:11:Branch Code 3
28-08-2025 11:50:11:Scheme Code 3
28-08-2025 11:50:11:Account No 3
28-08-2025 11:50:11:Link Main Started
28-08-2025 11:50:11:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:50:11:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:50:11:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|011946|SB |001
28-08-2025 11:50:11:Validation Account Proce Executed with out error Y
28-08-2025 11:50:11:Connection Establisment started
28-08-2025 11:50:11:Connection Read From File  : Status OK 
28-08-2025 11:50:11:Connection Successfully Opened  : Status OK 
28-08-2025 11:50:11:CBS A/C No : 001001011946
28-08-2025 11:50:11: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
28-08-2025 11:50:11:Record Count : 1
28-08-2025 11:50:11:BRLENGTH 3
28-08-2025 11:50:11:SCHLENGTH 3
28-08-2025 11:50:11:ACLENGTH 6
28-08-2025 11:50:11:Branch Code 3
28-08-2025 11:50:11:Scheme Code 3
28-08-2025 11:50:11:Account No 3
28-08-2025 11:50:11:Link Main Started
28-08-2025 11:50:11:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:50:11:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:50:11:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|011946|SB |001
28-08-2025 11:50:11:Vno --->:71997
28-08-2025 11:50:11:Current Date  --->:28-08-2025
28-08-2025 11:50:11:calling  CallNewRtgsBothProc 
28-08-2025 11:50:11:Parameters passing - InwardAuthorise 
28-08-2025 11:50:11: brn =001
28-08-2025 11:50:11: acno =011946
28-08-2025 11:50:11: abbr =SB
28-08-2025 11:50:11: amt.ToString() =1682
28-08-2025 11:50:11: traceNo =71997
28-08-2025 11:50:11: narr =NEFT, BY ONE 97 COMMUNICATIONS LIMITED ESCROW ACCOUNT _01 UTIB0000022 924020007330961
28-08-2025 11:50:11:Transaction Process :  BEFORE CAL PROC:
28-08-2025 11:50:11:cbs no--->001001004009
28-08-2025 11:50:11:CBS A/C No : 001001004009
28-08-2025 11:50:11: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
28-08-2025 11:50:11:Record Count : 1
28-08-2025 11:50:11:BRLENGTH 3
28-08-2025 11:50:11:SCHLENGTH 3
28-08-2025 11:50:11:ACLENGTH 6
28-08-2025 11:50:11:Branch Code 3
28-08-2025 11:50:11:Scheme Code 3
28-08-2025 11:50:11:Account No 3
28-08-2025 11:50:11:Link Main Started
28-08-2025 11:50:11:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:50:11:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:50:11:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|004009|SB |001
28-08-2025 11:50:11: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=004009  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=004009  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=004009  AND ADDR_SNO=CLMS_ADDRESS
28-08-2025 11:50:11:closed y n Record count --->1
28-08-2025 11:50:11:SMS Inserted for Mobile Number : +919742763537
28-08-2025 11:50:11:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN24026064083|001001011909 -------------------------->
28-08-2025 11:50:11:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:50:11:Connection Establisment started
28-08-2025 11:50:11:Connection Read From File  : Status OK 
28-08-2025 11:50:11:Connection Successfully Opened  : Status OK 
28-08-2025 11:50:11:ValidateAcNo CBS A/C No : 001001011909
28-08-2025 11:50:11:CBS A/C No : 001001011909
28-08-2025 11:50:11: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
28-08-2025 11:50:11:Record Count : 1
28-08-2025 11:50:11:BRLENGTH 3
28-08-2025 11:50:11:SCHLENGTH 3
28-08-2025 11:50:11:ACLENGTH 6
28-08-2025 11:50:11:Branch Code 3
28-08-2025 11:50:11:Scheme Code 3
28-08-2025 11:50:11:Account No 3
28-08-2025 11:50:11:Link Main Started
28-08-2025 11:50:11:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:50:11:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:50:11:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|011909|SB |001
28-08-2025 11:50:11:Validation Account Proce Executed with out error Y
28-08-2025 11:50:11:Connection Establisment started
28-08-2025 11:50:11:Connection Read From File  : Status OK 
28-08-2025 11:50:11:Connection Successfully Opened  : Status OK 
28-08-2025 11:50:11:CBS A/C No : 001001011909
28-08-2025 11:50:11: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
28-08-2025 11:50:11:Record Count : 1
28-08-2025 11:50:11:BRLENGTH 3
28-08-2025 11:50:11:SCHLENGTH 3
28-08-2025 11:50:11:ACLENGTH 6
28-08-2025 11:50:11:Branch Code 3
28-08-2025 11:50:11:Scheme Code 3
28-08-2025 11:50:11:Account No 3
28-08-2025 11:50:11:Link Main Started
28-08-2025 11:50:11:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:50:11:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:50:11:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|011909|SB |001
28-08-2025 11:50:11:Inward Process Executed Sussefully
28-08-2025 11:50:11:ConfirmationReq Execution Success with Status 000
28-08-2025 11:50:11:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN24026062273|001002000319 ------------------------------>
28-08-2025 11:50:11:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:50:11:Vno --->:71998
28-08-2025 11:50:11:Current Date  --->:28-08-2025
28-08-2025 11:50:11:calling  CallNewRtgsBothProc 
28-08-2025 11:50:11:Parameters passing - InwardAuthorise 
28-08-2025 11:50:11: brn =001
28-08-2025 11:50:11: acno =011909
28-08-2025 11:50:11: abbr =SB
28-08-2025 11:50:11: amt.ToString() =1225
28-08-2025 11:50:11: traceNo =71998
28-08-2025 11:50:11: narr =NEFT, BY PHONEPE LIMITED-PAYMENT AGGREGATOR ESCROW ACCOUNT UTIB0001506 922020004688715
28-08-2025 11:50:11:Transaction Process :  BEFORE CAL PROC:
28-08-2025 11:50:11:cbs no--->001001011909
28-08-2025 11:50:11:CBS A/C No : 001001011909
28-08-2025 11:50:11: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
28-08-2025 11:50:11:Record Count : 1
28-08-2025 11:50:11:BRLENGTH 3
28-08-2025 11:50:11:SCHLENGTH 3
28-08-2025 11:50:11:ACLENGTH 6
28-08-2025 11:50:11:Branch Code 3
28-08-2025 11:50:11:Scheme Code 3
28-08-2025 11:50:11:Account No 3
28-08-2025 11:50:11:Link Main Started
28-08-2025 11:50:11:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:50:11:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:50:11:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|011909|SB |001
28-08-2025 11:50:11: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=011909  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=011909  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=011909  AND ADDR_SNO=CLMS_ADDRESS
28-08-2025 11:50:11:closed y n Record count --->1
28-08-2025 11:50:11:SMS Inserted for Mobile Number : +919902390767
28-08-2025 11:50:11:Inward Process Executed Sussefully
28-08-2025 11:50:11:ConfirmationReq Execution Success with Status 000
28-08-2025 11:50:11:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN24026062280|001001013000 ------------------------------>
28-08-2025 11:50:11:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:50:11:ConfirmationReq Execution Success with Status 000
28-08-2025 11:50:11:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM24026069824|001001011946 ------------------------------>
28-08-2025 11:50:11:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:50:11:Inward Process Executed Sussefully
28-08-2025 11:50:11:ConfirmationReq Execution Success with Status 000
28-08-2025 11:50:11:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN24026064083|001001011909 ------------------------------>
28-08-2025 11:50:11:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:50:11:SMS Inserted for Mobile Number : +918123666480
28-08-2025 11:50:11:Inward Process Executed Sussefully
28-08-2025 11:50:11:ConfirmationReq Execution Success with Status 000
28-08-2025 11:50:11:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN24026064066|001001004009 ------------------------------>
28-08-2025 11:50:11:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:50:11:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN24026064082|001001005543 -------------------------->
28-08-2025 11:50:11:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:50:11:Connection Establisment started
28-08-2025 11:50:11:Connection Read From File  : Status OK 
28-08-2025 11:50:11:Connection Successfully Opened  : Status OK 
28-08-2025 11:50:11:ValidateAcNo CBS A/C No : 001001005543
28-08-2025 11:50:11:CBS A/C No : 001001005543
28-08-2025 11:50:11: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
28-08-2025 11:50:11:Record Count : 1
28-08-2025 11:50:11:BRLENGTH 3
28-08-2025 11:50:11:SCHLENGTH 3
28-08-2025 11:50:11:ACLENGTH 6
28-08-2025 11:50:11:Branch Code 3
28-08-2025 11:50:11:Scheme Code 3
28-08-2025 11:50:11:Account No 3
28-08-2025 11:50:11:Link Main Started
28-08-2025 11:50:11:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:50:11:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:50:11:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|005543|SB |001
28-08-2025 11:50:11:Validation Account Proce Executed with out error Y
28-08-2025 11:50:11:Connection Establisment started
28-08-2025 11:50:11:Connection Read From File  : Status OK 
28-08-2025 11:50:11:Connection Successfully Opened  : Status OK 
28-08-2025 11:50:11:CBS A/C No : 001001005543
28-08-2025 11:50:11: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
28-08-2025 11:50:11:Record Count : 1
28-08-2025 11:50:11:BRLENGTH 3
28-08-2025 11:50:11:SCHLENGTH 3
28-08-2025 11:50:11:ACLENGTH 6
28-08-2025 11:50:11:Branch Code 3
28-08-2025 11:50:11:Scheme Code 3
28-08-2025 11:50:11:Account No 3
28-08-2025 11:50:11:Link Main Started
28-08-2025 11:50:11:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:50:11:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:50:11:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|005543|SB |001
28-08-2025 11:50:11:Vno --->:71999
28-08-2025 11:50:11:Current Date  --->:28-08-2025
28-08-2025 11:50:11:calling  CallNewRtgsBothProc 
28-08-2025 11:50:11:Parameters passing - InwardAuthorise 
28-08-2025 11:50:11: brn =001
28-08-2025 11:50:11: acno =005543
28-08-2025 11:50:11: abbr =SB
28-08-2025 11:50:11: amt.ToString() =200
28-08-2025 11:50:11: traceNo =71999
28-08-2025 11:50:11: narr =NEFT, BY PHONEPE LIMITED-PAYMENT AGGREGATOR ESCROW ACCOUNT UTIB0001506 922020004688715
28-08-2025 11:50:11:Transaction Process :  BEFORE CAL PROC:
28-08-2025 11:50:11:cbs no--->001001005543
28-08-2025 11:50:11:CBS A/C No : 001001005543
28-08-2025 11:50:11: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
28-08-2025 11:50:11:Record Count : 1
28-08-2025 11:50:11:BRLENGTH 3
28-08-2025 11:50:11:SCHLENGTH 3
28-08-2025 11:50:11:ACLENGTH 6
28-08-2025 11:50:11:Branch Code 3
28-08-2025 11:50:11:Scheme Code 3
28-08-2025 11:50:11:Account No 3
28-08-2025 11:50:11:Link Main Started
28-08-2025 11:50:11:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:50:11:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:50:11:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|005543|SB |001
28-08-2025 11:50:11: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=005543  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=005543  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=005543  AND ADDR_SNO=CLMS_ADDRESS
28-08-2025 11:50:11:closed y n Record count --->1
28-08-2025 11:50:11:SMS Inserted for Mobile Number : +919731114296
28-08-2025 11:50:12:Inward Process Executed Sussefully
28-08-2025 11:50:12:ConfirmationReq Execution Success with Status 000
28-08-2025 11:50:12:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN24026064082|001001005543 ------------------------------>
28-08-2025 11:50:12:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:52:03:<------------------------Started ValidationRequest CBS A/C No : 001001009671 ------------------------>
28-08-2025 11:52:03:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 11:52:03:Connection Establisment started
28-08-2025 11:52:03:Connection Read From File  : Status OK 
28-08-2025 11:52:03:Connection Successfully Opened  : Status OK 
28-08-2025 11:52:03:ValidateAcNo CBS A/C No : 001001009671
28-08-2025 11:52:03:CBS A/C No : 001001009671
28-08-2025 11:52:03: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
28-08-2025 11:52:03:Record Count : 1
28-08-2025 11:52:03:BRLENGTH 3
28-08-2025 11:52:03:SCHLENGTH 3
28-08-2025 11:52:03:ACLENGTH 6
28-08-2025 11:52:03:Branch Code 3
28-08-2025 11:52:03:Scheme Code 3
28-08-2025 11:52:03:Account No 3
28-08-2025 11:52:03:Link Main Started
28-08-2025 11:52:03:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 11:52:03:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 11:52:03:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|009671|SB |001
28-08-2025 11:52:03:Validation Account Proce Executed with out error Y
28-08-2025 11:52:03:ValidationRequest Exccution Success with response :  000
28-08-2025 11:52:03:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 12:10:59:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM24026182953|001001002467 -------------------------->
28-08-2025 12:10:59:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 12:10:59:Connection Establisment started
28-08-2025 12:10:59:Connection Read From File  : Status OK 
28-08-2025 12:10:59:Connection Successfully Opened  : Status OK 
28-08-2025 12:10:59:ValidateAcNo CBS A/C No : 001001002467
28-08-2025 12:10:59:CBS A/C No : 001001002467
28-08-2025 12:10:59:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 12:10:59:Record Count : 1
28-08-2025 12:10:59:BRLENGTH 3
28-08-2025 12:10:59:SCHLENGTH 3
28-08-2025 12:10:59:ACLENGTH 6
28-08-2025 12:10:59:Branch Code 3
28-08-2025 12:10:59:Scheme Code 3
28-08-2025 12:10:59:Account No 3
28-08-2025 12:10:59:Link Main Started
28-08-2025 12:10:59:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 12:10:59:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 12:10:59:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|002467|SB |001
28-08-2025 12:10:59:Validation Account Proce Executed with out error Y
28-08-2025 12:10:59:Connection Establisment started
28-08-2025 12:10:59:Connection Read From File  : Status OK 
28-08-2025 12:10:59:Connection Successfully Opened  : Status OK 
28-08-2025 12:10:59:CBS A/C No : 001001002467
28-08-2025 12:10:59:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 12:10:59:Record Count : 1
28-08-2025 12:10:59:BRLENGTH 3
28-08-2025 12:10:59:SCHLENGTH 3
28-08-2025 12:10:59:ACLENGTH 6
28-08-2025 12:10:59:Branch Code 3
28-08-2025 12:10:59:Scheme Code 3
28-08-2025 12:10:59:Account No 3
28-08-2025 12:10:59:Link Main Started
28-08-2025 12:10:59:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 12:10:59:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 12:10:59:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|002467|SB |001
28-08-2025 12:10:59:Vno --->:72000
28-08-2025 12:10:59:Current Date  --->:28-08-2025
28-08-2025 12:10:59:calling  CallNewRtgsBothProc 
28-08-2025 12:10:59:Parameters passing - InwardAuthorise 
28-08-2025 12:10:59: brn =001
28-08-2025 12:10:59: acno =002467
28-08-2025 12:10:59: abbr =SB
28-08-2025 12:10:59: amt.ToString() =59.96
28-08-2025 12:10:59: traceNo =72000
28-08-2025 12:10:59: narr =NEFT, BY ONE 97 COMMUNICATIONS LIMITED ESCROW ACCOUNT _01 UTIB0000022 924020007330961
28-08-2025 12:10:59:Transaction Process :  BEFORE CAL PROC:
28-08-2025 12:11:00:Inward Process Executed Sussefully
28-08-2025 12:11:00:ConfirmationReq Execution Success with Status 000
28-08-2025 12:11:00:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM24026182953|001001002467 ------------------------------>
28-08-2025 12:11:00:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 12:12:15:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : SBIN325240117846|001001009671 -------------------------->
28-08-2025 12:12:15:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 12:12:15:Connection Establisment started
28-08-2025 12:12:15:Connection Read From File  : Status OK 
28-08-2025 12:12:15:Connection Successfully Opened  : Status OK 
28-08-2025 12:12:15:ValidateAcNo CBS A/C No : 001001009671
28-08-2025 12:12:15:CBS A/C No : 001001009671
28-08-2025 12:12:15: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
28-08-2025 12:12:15:Record Count : 1
28-08-2025 12:12:15:BRLENGTH 3
28-08-2025 12:12:15:SCHLENGTH 3
28-08-2025 12:12:15:ACLENGTH 6
28-08-2025 12:12:15:Branch Code 3
28-08-2025 12:12:15:Scheme Code 3
28-08-2025 12:12:15:Account No 3
28-08-2025 12:12:15:Link Main Started
28-08-2025 12:12:15:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 12:12:15:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 12:12:15:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|009671|SB |001
28-08-2025 12:12:15:Validation Account Proce Executed with out error Y
28-08-2025 12:12:15:Connection Establisment started
28-08-2025 12:12:15:Connection Read From File  : Status OK 
28-08-2025 12:12:15:Connection Successfully Opened  : Status OK 
28-08-2025 12:12:15:CBS A/C No : 001001009671
28-08-2025 12:12:15: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
28-08-2025 12:12:15:Record Count : 1
28-08-2025 12:12:15:BRLENGTH 3
28-08-2025 12:12:15:SCHLENGTH 3
28-08-2025 12:12:15:ACLENGTH 6
28-08-2025 12:12:15:Branch Code 3
28-08-2025 12:12:15:Scheme Code 3
28-08-2025 12:12:15:Account No 3
28-08-2025 12:12:15:Link Main Started
28-08-2025 12:12:15:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 12:12:15:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 12:12:15:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|009671|SB |001
28-08-2025 12:12:15:Vno --->:72001
28-08-2025 12:12:15:Current Date  --->:28-08-2025
28-08-2025 12:12:15:calling  CallNewRtgsBothProc 
28-08-2025 12:12:15:Parameters passing - InwardAuthorise 
28-08-2025 12:12:15: brn =001
28-08-2025 12:12:15: acno =009671
28-08-2025 12:12:15: abbr =SB
28-08-2025 12:12:15: amt.ToString() =30000
28-08-2025 12:12:15: traceNo =72001
28-08-2025 12:12:15: narr =NEFT, BY M s  SHIVABASAV TRADING COMPANY  SH SBIN0040493 00000038994823001
28-08-2025 12:12:15:Transaction Process :  BEFORE CAL PROC:
28-08-2025 12:12:15:cbs no--->001001009671
28-08-2025 12:12:15:CBS A/C No : 001001009671
28-08-2025 12:12:15: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
28-08-2025 12:12:15:Record Count : 1
28-08-2025 12:12:15:BRLENGTH 3
28-08-2025 12:12:15:SCHLENGTH 3
28-08-2025 12:12:15:ACLENGTH 6
28-08-2025 12:12:15:Branch Code 3
28-08-2025 12:12:15:Scheme Code 3
28-08-2025 12:12:15:Account No 3
28-08-2025 12:12:15:Link Main Started
28-08-2025 12:12:15:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 12:12:15:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 12:12:15:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|009671|SB |001
28-08-2025 12:12:15: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=009671  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=009671  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=009671  AND ADDR_SNO=CLMS_ADDRESS
28-08-2025 12:12:15:closed y n Record count --->1
28-08-2025 12:12:15:SMS Inserted for Mobile Number : +919886596586
28-08-2025 12:12:15:Inward Process Executed Sussefully
28-08-2025 12:12:15:ConfirmationReq Execution Success with Status 000
28-08-2025 12:12:15:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : SBIN325240117846|001001009671 ------------------------------>
28-08-2025 12:12:15:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 13:16:52:<------------------------Started ValidationRequest CBS A/C No : 001001013809 ------------------------>
28-08-2025 13:16:52:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 13:16:52:Connection Establisment started
28-08-2025 13:16:52:Connection Read From File  : Status OK 
28-08-2025 13:16:52:Connection Successfully Opened  : Status OK 
28-08-2025 13:16:52:ValidateAcNo CBS A/C No : 001001013809
28-08-2025 13:16:52:CBS A/C No : 001001013809
28-08-2025 13:16:52:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 13:16:52:Record Count : 1
28-08-2025 13:16:52:BRLENGTH 3
28-08-2025 13:16:52:SCHLENGTH 3
28-08-2025 13:16:52:ACLENGTH 6
28-08-2025 13:16:52:Branch Code 3
28-08-2025 13:16:52:Scheme Code 3
28-08-2025 13:16:52:Account No 3
28-08-2025 13:16:52:Link Main Started
28-08-2025 13:16:52:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 13:16:52:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 13:16:52:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|013809|SB |001
28-08-2025 13:16:52:Validation Account Proce Executed with out error Y
28-08-2025 13:16:52:ValidationRequest Exccution Success with response :  000
28-08-2025 13:16:52:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 13:35:33:<------------------------Started ValidationRequest CBS A/C No : 001001005056 ------------------------>
28-08-2025 13:35:33:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 13:35:33:Connection Establisment started
28-08-2025 13:35:33:Connection Read From File  : Status OK 
28-08-2025 13:35:33:Connection Successfully Opened  : Status OK 
28-08-2025 13:35:33:ValidateAcNo CBS A/C No : 001001005056
28-08-2025 13:35:33:CBS A/C No : 001001005056
28-08-2025 13:35:33:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 13:35:33:Record Count : 1
28-08-2025 13:35:33:BRLENGTH 3
28-08-2025 13:35:33:SCHLENGTH 3
28-08-2025 13:35:33:ACLENGTH 6
28-08-2025 13:35:33:Branch Code 3
28-08-2025 13:35:33:Scheme Code 3
28-08-2025 13:35:33:Account No 3
28-08-2025 13:35:33:Link Main Started
28-08-2025 13:35:33:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 13:35:33:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 13:35:33:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|005056|SB |001
28-08-2025 13:35:33:Validation Account Proce Executed with out error Y
28-08-2025 13:35:33:ValidationRequest Exccution Success with response :  000
28-08-2025 13:35:33:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 13:42:02:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXISCN1063005108|001001013809 -------------------------->
28-08-2025 13:42:02:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 13:42:02:Connection Establisment started
28-08-2025 13:42:02:Connection Read From File  : Status OK 
28-08-2025 13:42:02:Connection Successfully Opened  : Status OK 
28-08-2025 13:42:02:ValidateAcNo CBS A/C No : 001001013809
28-08-2025 13:42:02:CBS A/C No : 001001013809
28-08-2025 13:42:02:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 13:42:02:Record Count : 1
28-08-2025 13:42:02:BRLENGTH 3
28-08-2025 13:42:02:SCHLENGTH 3
28-08-2025 13:42:02:ACLENGTH 6
28-08-2025 13:42:02:Branch Code 3
28-08-2025 13:42:02:Scheme Code 3
28-08-2025 13:42:02:Account No 3
28-08-2025 13:42:02:Link Main Started
28-08-2025 13:42:02:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 13:42:02:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 13:42:02:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|013809|SB |001
28-08-2025 13:42:02:Validation Account Proce Executed with out error Y
28-08-2025 13:42:02:Connection Establisment started
28-08-2025 13:42:02:Connection Read From File  : Status OK 
28-08-2025 13:42:02:Connection Successfully Opened  : Status OK 
28-08-2025 13:42:02:CBS A/C No : 001001013809
28-08-2025 13:42:02:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 13:42:02:Record Count : 1
28-08-2025 13:42:02:BRLENGTH 3
28-08-2025 13:42:02:SCHLENGTH 3
28-08-2025 13:42:02:ACLENGTH 6
28-08-2025 13:42:02:Branch Code 3
28-08-2025 13:42:02:Scheme Code 3
28-08-2025 13:42:02:Account No 3
28-08-2025 13:42:02:Link Main Started
28-08-2025 13:42:02:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 13:42:02:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 13:42:02:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|013809|SB |001
28-08-2025 13:42:02:Vno --->:72002
28-08-2025 13:42:02:Current Date  --->:28-08-2025
28-08-2025 13:42:02:calling  CallNewRtgsBothProc 
28-08-2025 13:42:02:Parameters passing - InwardAuthorise 
28-08-2025 13:42:02: brn =001
28-08-2025 13:42:02: acno =013809
28-08-2025 13:42:02: abbr =SB
28-08-2025 13:42:02: amt.ToString() =2841
28-08-2025 13:42:02: traceNo =72002
28-08-2025 13:42:02: narr =NEFT, BY UNITED INDIA INSURANCE COMPANY LIMITED UTIB0000006 914020047605659
28-08-2025 13:42:02:Transaction Process :  BEFORE CAL PROC:
28-08-2025 13:42:02:cbs no--->001001013809
28-08-2025 13:42:02:CBS A/C No : 001001013809
28-08-2025 13:42:02:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 13:42:02:Record Count : 1
28-08-2025 13:42:02:BRLENGTH 3
28-08-2025 13:42:02:SCHLENGTH 3
28-08-2025 13:42:02:ACLENGTH 6
28-08-2025 13:42:02:Branch Code 3
28-08-2025 13:42:02:Scheme Code 3
28-08-2025 13:42:02:Account No 3
28-08-2025 13:42:02:Link Main Started
28-08-2025 13:42:02:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 13:42:02:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 13:42:02:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|013809|SB |001
28-08-2025 13:42:02:Closed YN quier  --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG,DSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM  clientmaster,depositmaster,depositschemesetup,ADDRESS  where CLMS_SNO=DEPM_CLIENT AND DSCH_BRANCH = DEPM_BRANCH AND DSCH_ABBR = DEPM_ABBR  and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB'  AND DEPM_NO=013809  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=013809  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=013809  AND ADDR_SNO=CLMS_ADDRESS
28-08-2025 13:42:02:closed y n Record count --->1
28-08-2025 13:42:02:SMS Inserted for Mobile Number : +919342479981
28-08-2025 13:42:02:Inward Process Executed Sussefully
28-08-2025 13:42:02:ConfirmationReq Execution Success with Status 000
28-08-2025 13:42:02:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXISCN1063005108|001001013809 ------------------------------>
28-08-2025 13:42:02:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 14:01:26:<------------------------Started ValidationRequest CBS A/C No : 002002000029 ------------------------>
28-08-2025 14:01:26:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 14:01:26:Connection Establisment started
28-08-2025 14:01:26:Connection Read From File  : Status OK 
28-08-2025 14:01:26:Connection Successfully Opened  : Status OK 
28-08-2025 14:01:26:ValidateAcNo CBS A/C No : 002002000029
28-08-2025 14:01:26:CBS A/C No : 002002000029
28-08-2025 14:01:26: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
28-08-2025 14:01:26:Record Count : 1
28-08-2025 14:01:26:BRLENGTH 3
28-08-2025 14:01:26:SCHLENGTH 3
28-08-2025 14:01:26:ACLENGTH 6
28-08-2025 14:01:26:Branch Code 3
28-08-2025 14:01:26:Scheme Code 3
28-08-2025 14:01:26:Account No 3
28-08-2025 14:01:26:Link Main Started
28-08-2025 14:01:26:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
28-08-2025 14:01:26:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 002
28-08-2025 14:01:26:ShowCBS Ac No Proce Executed  BARDANSAL|DEPOSIT|000029|CD |002
28-08-2025 14:01:26:Validation Account Proce Executed with out error Y
28-08-2025 14:01:26:ValidationRequest Exccution Success with response :  000
28-08-2025 14:01:26:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 14:11:02:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : CMS2402532470292|001001005056 -------------------------->
28-08-2025 14:11:02:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 14:11:02:Connection Establisment started
28-08-2025 14:11:02:Connection Read From File  : Status OK 
28-08-2025 14:11:02:Connection Successfully Opened  : Status OK 
28-08-2025 14:11:02:ValidateAcNo CBS A/C No : 001001005056
28-08-2025 14:11:02:CBS A/C No : 001001005056
28-08-2025 14:11:02:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 14:11:02:Record Count : 1
28-08-2025 14:11:02:BRLENGTH 3
28-08-2025 14:11:02:SCHLENGTH 3
28-08-2025 14:11:02:ACLENGTH 6
28-08-2025 14:11:02:Branch Code 3
28-08-2025 14:11:02:Scheme Code 3
28-08-2025 14:11:02:Account No 3
28-08-2025 14:11:02:Link Main Started
28-08-2025 14:11:02:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 14:11:02:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 14:11:02:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|005056|SB |001
28-08-2025 14:11:02:Validation Account Proce Executed with out error Y
28-08-2025 14:11:02:Connection Establisment started
28-08-2025 14:11:02:Connection Read From File  : Status OK 
28-08-2025 14:11:02:Connection Successfully Opened  : Status OK 
28-08-2025 14:11:02:CBS A/C No : 001001005056
28-08-2025 14:11:02:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 14:11:02:Record Count : 1
28-08-2025 14:11:02:BRLENGTH 3
28-08-2025 14:11:02:SCHLENGTH 3
28-08-2025 14:11:02:ACLENGTH 6
28-08-2025 14:11:02:Branch Code 3
28-08-2025 14:11:02:Scheme Code 3
28-08-2025 14:11:02:Account No 3
28-08-2025 14:11:02:Link Main Started
28-08-2025 14:11:02:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 14:11:02:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 14:11:02:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|005056|SB |001
28-08-2025 14:11:02:Vno --->:72003
28-08-2025 14:11:02:Current Date  --->:28-08-2025
28-08-2025 14:11:02:calling  CallNewRtgsBothProc 
28-08-2025 14:11:02:Parameters passing - InwardAuthorise 
28-08-2025 14:11:02: brn =001
28-08-2025 14:11:02: acno =005056
28-08-2025 14:11:02: abbr =SB
28-08-2025 14:11:02: amt.ToString() =31430
28-08-2025 14:11:02: traceNo =72003
28-08-2025 14:11:02: narr =NEFT, BY LIC OF INDIA DO DHARWAD NEFT A C KKBK0000958 0012362158
28-08-2025 14:11:02:Transaction Process :  BEFORE CAL PROC:
28-08-2025 14:11:02:cbs no--->001001005056
28-08-2025 14:11:02:CBS A/C No : 001001005056
28-08-2025 14:11:02:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 14:11:02:Record Count : 1
28-08-2025 14:11:02:BRLENGTH 3
28-08-2025 14:11:02:SCHLENGTH 3
28-08-2025 14:11:02:ACLENGTH 6
28-08-2025 14:11:02:Branch Code 3
28-08-2025 14:11:02:Scheme Code 3
28-08-2025 14:11:02:Account No 3
28-08-2025 14:11:02:Link Main Started
28-08-2025 14:11:02:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 14:11:02:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 14:11:02:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|005056|SB |001
28-08-2025 14:11:02:Closed YN quier  --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG,DSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM  clientmaster,depositmaster,depositschemesetup,ADDRESS  where CLMS_SNO=DEPM_CLIENT AND DSCH_BRANCH = DEPM_BRANCH AND DSCH_ABBR = DEPM_ABBR  and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB'  AND DEPM_NO=005056  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=005056  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=005056  AND ADDR_SNO=CLMS_ADDRESS
28-08-2025 14:11:02:closed y n Record count --->1
28-08-2025 14:11:02:SMS Inserted for Mobile Number : +919480556570
28-08-2025 14:11:02:Inward Process Executed Sussefully
28-08-2025 14:11:02:ConfirmationReq Execution Success with Status 000
28-08-2025 14:11:02:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : CMS2402532470292|001001005056 ------------------------------>
28-08-2025 14:11:02:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 14:40:12:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : CNRBH00070976789|002002000029 -------------------------->
28-08-2025 14:40:12:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 14:40:12:Connection Establisment started
28-08-2025 14:40:12:Connection Read From File  : Status OK 
28-08-2025 14:40:12:Connection Successfully Opened  : Status OK 
28-08-2025 14:40:12:ValidateAcNo CBS A/C No : 002002000029
28-08-2025 14:40:12:CBS A/C No : 002002000029
28-08-2025 14:40:12:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 14:40:12:Record Count : 1
28-08-2025 14:40:12:BRLENGTH 3
28-08-2025 14:40:12:SCHLENGTH 3
28-08-2025 14:40:12:ACLENGTH 6
28-08-2025 14:40:12:Branch Code 3
28-08-2025 14:40:12:Scheme Code 3
28-08-2025 14:40:12:Account No 3
28-08-2025 14:40:12:Link Main Started
28-08-2025 14:40:12:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
28-08-2025 14:40:12:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 002
28-08-2025 14:40:12:ShowCBS Ac No Proce Executed  BARDANSAL|DEPOSIT|000029|CD |002
28-08-2025 14:40:12:Validation Account Proce Executed with out error Y
28-08-2025 14:40:12:Connection Establisment started
28-08-2025 14:40:12:Connection Read From File  : Status OK 
28-08-2025 14:40:12:Connection Successfully Opened  : Status OK 
28-08-2025 14:40:12:CBS A/C No : 002002000029
28-08-2025 14:40:12:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 14:40:12:Record Count : 1
28-08-2025 14:40:12:BRLENGTH 3
28-08-2025 14:40:12:SCHLENGTH 3
28-08-2025 14:40:12:ACLENGTH 6
28-08-2025 14:40:12:Branch Code 3
28-08-2025 14:40:12:Scheme Code 3
28-08-2025 14:40:12:Account No 3
28-08-2025 14:40:12:Link Main Started
28-08-2025 14:40:13:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
28-08-2025 14:40:13:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 002
28-08-2025 14:40:13:ShowCBS Ac No Proce Executed  BARDANSAL|DEPOSIT|000029|CD |002
28-08-2025 14:40:13:Vno --->:72004
28-08-2025 14:40:13:Current Date  --->:28-08-2025
28-08-2025 14:40:13:calling  CallNewRtgsBothProc 
28-08-2025 14:40:13:Parameters passing - InwardAuthorise 
28-08-2025 14:40:13: brn =002
28-08-2025 14:40:13: acno =000029
28-08-2025 14:40:13: abbr =CD
28-08-2025 14:40:13: amt.ToString() =25000
28-08-2025 14:40:13: traceNo =72004
28-08-2025 14:40:13: narr =NEFT, BY KISAN HARDWARE CNRB0010638 06383070001330
28-08-2025 14:40:13:Transaction Process :  BEFORE CAL PROC:
28-08-2025 14:40:13:cbs no--->002002000029
28-08-2025 14:40:13:CBS A/C No : 002002000029
28-08-2025 14:40:13:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 14:40:13:Record Count : 1
28-08-2025 14:40:13:BRLENGTH 3
28-08-2025 14:40:13:SCHLENGTH 3
28-08-2025 14:40:13:ACLENGTH 6
28-08-2025 14:40:13:Branch Code 3
28-08-2025 14:40:13:Scheme Code 3
28-08-2025 14:40:13:Account No 3
28-08-2025 14:40:13:Link Main Started
28-08-2025 14:40:13:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
28-08-2025 14:40:13:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 002
28-08-2025 14:40:13:ShowCBS Ac No Proce Executed  BARDANSAL|DEPOSIT|000029|CD |002
28-08-2025 14:40:13:Closed YN quier  --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG,DSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM  clientmaster,depositmaster,depositschemesetup,ADDRESS  where CLMS_SNO=DEPM_CLIENT AND DSCH_BRANCH = DEPM_BRANCH AND DSCH_ABBR = DEPM_ABBR  and DEPM_BRANCH=002 and TRIM(DEPM_ABBR)='CD'  AND DEPM_NO=000029  AND ADDR_SNO=CLMS_ADDRESS union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG,LSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM  clientmaster,LOANMASTER,LOANSCHEMESETUP,ADDRESS  where CLMS_SNO=LOAM_CLIENT  AND LSCH_BRANCH = LOAM_BRANCH AND LSCH_ABBREV = LOAM_ABBR and LOAM_BRANCH =002 and TRIM(LOAM_ABBR)='CD'  AND LOAM_NO=000029  AND ADDR_SNO=CLMS_ADDRESS UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG,ODST_GLLINK AS GLLINK,ADDR_MOBILENO FROM  clientmaster,ODMASTER,ODSCHEMESETUP,ADDRESS  where CLMS_SNO=ODMT_CLIENT AND ODST_BRANCH = ODMT_BRANCH AND ODST_ABBR = ODMT_ABBR and ODMT_BRANCH=002 and TRIM(ODMT_ABBR)='CD'  AND ODMT_NO=000029  AND ADDR_SNO=CLMS_ADDRESS
28-08-2025 14:40:13:closed y n Record count --->1
28-08-2025 14:40:13:SMS Inserted for Mobile Number : +919448173501
28-08-2025 14:40:13:Inward Process Executed Sussefully
28-08-2025 14:40:13:ConfirmationReq Execution Success with Status 000
28-08-2025 14:40:13:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : CNRBH00070976789|002002000029 ------------------------------>
28-08-2025 14:40:13:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 15:24:45:<------------------------Started ValidationRequest CBS A/C No : 001002000861 ------------------------>
28-08-2025 15:24:45:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 15:24:45:Connection Establisment started
28-08-2025 15:24:45:Connection Read From File  : Status OK 
28-08-2025 15:24:45:Connection Successfully Opened  : Status OK 
28-08-2025 15:24:45:ValidateAcNo CBS A/C No : 001002000861
28-08-2025 15:24:45:CBS A/C No : 001002000861
28-08-2025 15:24:45:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 15:24:45:Record Count : 1
28-08-2025 15:24:45:BRLENGTH 3
28-08-2025 15:24:45:SCHLENGTH 3
28-08-2025 15:24:45:ACLENGTH 6
28-08-2025 15:24:45:Branch Code 3
28-08-2025 15:24:45:Scheme Code 3
28-08-2025 15:24:45:Account No 3
28-08-2025 15:24:45:Link Main Started
28-08-2025 15:24:45:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
28-08-2025 15:24:45:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 15:24:45:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000861|CD |001
28-08-2025 15:24:45:Validation Account Proce Executed with out error Y
28-08-2025 15:24:45:ValidationRequest Exccution Success with response :  000
28-08-2025 15:24:45:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 15:45:05:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : CNRBH00070992251|001002000861 -------------------------->
28-08-2025 15:45:05:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 15:45:05:Connection Establisment started
28-08-2025 15:45:05:Connection Read From File  : Status OK 
28-08-2025 15:45:05:Connection Successfully Opened  : Status OK 
28-08-2025 15:45:05:ValidateAcNo CBS A/C No : 001002000861
28-08-2025 15:45:05:CBS A/C No : 001002000861
28-08-2025 15:45:05:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 15:45:05:Record Count : 1
28-08-2025 15:45:05:BRLENGTH 3
28-08-2025 15:45:05:SCHLENGTH 3
28-08-2025 15:45:05:ACLENGTH 6
28-08-2025 15:45:05:Branch Code 3
28-08-2025 15:45:05:Scheme Code 3
28-08-2025 15:45:05:Account No 3
28-08-2025 15:45:05:Link Main Started
28-08-2025 15:45:05:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
28-08-2025 15:45:05:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 15:45:05:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000861|CD |001
28-08-2025 15:45:05:Validation Account Proce Executed with out error Y
28-08-2025 15:45:05:Connection Establisment started
28-08-2025 15:45:05:Connection Read From File  : Status OK 
28-08-2025 15:45:05:Connection Successfully Opened  : Status OK 
28-08-2025 15:45:05:CBS A/C No : 001002000861
28-08-2025 15:45:05:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 15:45:05:Record Count : 1
28-08-2025 15:45:05:BRLENGTH 3
28-08-2025 15:45:05:SCHLENGTH 3
28-08-2025 15:45:05:ACLENGTH 6
28-08-2025 15:45:05:Branch Code 3
28-08-2025 15:45:05:Scheme Code 3
28-08-2025 15:45:05:Account No 3
28-08-2025 15:45:05:Link Main Started
28-08-2025 15:45:05:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
28-08-2025 15:45:05:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 15:45:05:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000861|CD |001
28-08-2025 15:45:05:Vno --->:72005
28-08-2025 15:45:05:Current Date  --->:28-08-2025
28-08-2025 15:45:05:calling  CallNewRtgsBothProc 
28-08-2025 15:45:05:Parameters passing - InwardAuthorise 
28-08-2025 15:45:05: brn =001
28-08-2025 15:45:05: acno =000861
28-08-2025 15:45:05: abbr =CD
28-08-2025 15:45:05: amt.ToString() =1500
28-08-2025 15:45:05: traceNo =72005
28-08-2025 15:45:05: narr =NEFT, BY SANA MOHAMMAD HUSEIN MALAGI CHARITABLE CNRB0003865 120035194789
28-08-2025 15:45:05:Transaction Process :  BEFORE CAL PROC:
28-08-2025 15:45:06:Inward Process Executed Sussefully
28-08-2025 15:45:06:ConfirmationReq Execution Success with Status 000
28-08-2025 15:45:06:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : CNRBH00070992251|001002000861 ------------------------------>
28-08-2025 15:45:06:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 16:45:25:<------------------------Started ValidationRequest CBS A/C No : 001002000868 ------------------------>
28-08-2025 16:45:25:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 16:45:25:Connection Establisment started
28-08-2025 16:45:25:Connection Read From File  : Status OK 
28-08-2025 16:45:25:Connection Successfully Opened  : Status OK 
28-08-2025 16:45:25:ValidateAcNo CBS A/C No : 001002000868
28-08-2025 16:45:25:CBS A/C No : 001002000868
28-08-2025 16:45:25: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
28-08-2025 16:45:25:Record Count : 1
28-08-2025 16:45:25:BRLENGTH 3
28-08-2025 16:45:25:SCHLENGTH 3
28-08-2025 16:45:25:ACLENGTH 6
28-08-2025 16:45:25:Branch Code 3
28-08-2025 16:45:25:Scheme Code 3
28-08-2025 16:45:25:Account No 3
28-08-2025 16:45:25:Link Main Started
28-08-2025 16:45:25:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
28-08-2025 16:45:25:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 16:45:25:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000868|CD |001
28-08-2025 16:45:25:Validation Account Proce Executed with out error Y
28-08-2025 16:45:25:ValidationRequest Exccution Success with response :  000
28-08-2025 16:45:25:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 17:20:10:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : ICIN224041674715|001002000868 -------------------------->
28-08-2025 17:20:10:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 17:20:10:Connection Establisment started
28-08-2025 17:20:10:Connection Read From File  : Status OK 
28-08-2025 17:20:10:Connection Successfully Opened  : Status OK 
28-08-2025 17:20:10:ValidateAcNo CBS A/C No : 001002000868
28-08-2025 17:20:10:CBS A/C No : 001002000868
28-08-2025 17:20:10:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 17:20:10:Record Count : 1
28-08-2025 17:20:10:BRLENGTH 3
28-08-2025 17:20:10:SCHLENGTH 3
28-08-2025 17:20:10:ACLENGTH 6
28-08-2025 17:20:10:Branch Code 3
28-08-2025 17:20:10:Scheme Code 3
28-08-2025 17:20:10:Account No 3
28-08-2025 17:20:10:Link Main Started
28-08-2025 17:20:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
28-08-2025 17:20:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 17:20:10:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000868|CD |001
28-08-2025 17:20:10:Validation Account Proce Executed with out error Y
28-08-2025 17:20:10:Connection Establisment started
28-08-2025 17:20:10:Connection Read From File  : Status OK 
28-08-2025 17:20:10:Connection Successfully Opened  : Status OK 
28-08-2025 17:20:10:CBS A/C No : 001002000868
28-08-2025 17:20:10:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 17:20:10:Record Count : 1
28-08-2025 17:20:10:BRLENGTH 3
28-08-2025 17:20:10:SCHLENGTH 3
28-08-2025 17:20:10:ACLENGTH 6
28-08-2025 17:20:10:Branch Code 3
28-08-2025 17:20:10:Scheme Code 3
28-08-2025 17:20:10:Account No 3
28-08-2025 17:20:10:Link Main Started
28-08-2025 17:20:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
28-08-2025 17:20:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 17:20:10:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000868|CD |001
28-08-2025 17:20:10:Vno --->:72006
28-08-2025 17:20:10:Current Date  --->:28-08-2025
28-08-2025 17:20:10:calling  CallNewRtgsBothProc 
28-08-2025 17:20:10:Parameters passing - InwardAuthorise 
28-08-2025 17:20:10: brn =001
28-08-2025 17:20:10: acno =000868
28-08-2025 17:20:10: abbr =CD
28-08-2025 17:20:10: amt.ToString() =53412
28-08-2025 17:20:10: traceNo =72006
28-08-2025 17:20:10: narr =NEFT, BY BELLAD AND COMPANY ICIC0099999 0104SLNEFTPL
28-08-2025 17:20:10:Transaction Process :  BEFORE CAL PROC:
28-08-2025 17:20:10:cbs no--->001002000868
28-08-2025 17:20:10:CBS A/C No : 001002000868
28-08-2025 17:20:10:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 17:20:10:Record Count : 1
28-08-2025 17:20:10:BRLENGTH 3
28-08-2025 17:20:10:SCHLENGTH 3
28-08-2025 17:20:10:ACLENGTH 6
28-08-2025 17:20:10:Branch Code 3
28-08-2025 17:20:10:Scheme Code 3
28-08-2025 17:20:10:Account No 3
28-08-2025 17:20:10:Link Main Started
28-08-2025 17:20:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
28-08-2025 17:20:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 17:20:10:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000868|CD |001
28-08-2025 17:20:10:Closed YN quier  --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG,DSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM  clientmaster,depositmaster,depositschemesetup,ADDRESS  where CLMS_SNO=DEPM_CLIENT AND DSCH_BRANCH = DEPM_BRANCH AND DSCH_ABBR = DEPM_ABBR  and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='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
28-08-2025 17:20:10:closed y n Record count --->1
28-08-2025 17:20:10:SMS Inserted for Mobile Number : +919448051124
28-08-2025 17:20:10:Inward Process Executed Sussefully
28-08-2025 17:20:10:ConfirmationReq Execution Success with Status 000
28-08-2025 17:20:10:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : ICIN224041674715|001002000868 ------------------------------>
28-08-2025 17:20:10:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 17:27:57:<------------------------Started ValidationRequest CBS A/C No : 001001013897 ------------------------>
28-08-2025 17:27:57:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 17:27:57:Connection Establisment started
28-08-2025 17:27:57:Connection Read From File  : Status OK 
28-08-2025 17:27:57:Connection Successfully Opened  : Status OK 
28-08-2025 17:27:57:ValidateAcNo CBS A/C No : 001001013897
28-08-2025 17:27:57:CBS A/C No : 001001013897
28-08-2025 17:27:57:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 17:27:57:Record Count : 1
28-08-2025 17:27:57:BRLENGTH 3
28-08-2025 17:27:57:SCHLENGTH 3
28-08-2025 17:27:57:ACLENGTH 6
28-08-2025 17:27:57:Branch Code 3
28-08-2025 17:27:57:Scheme Code 3
28-08-2025 17:27:57:Account No 3
28-08-2025 17:27:57:Link Main Started
28-08-2025 17:27:57:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 17:27:57:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 17:27:57:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|013897|SB |001
28-08-2025 17:27:57:Validation Account Proce Executed with out error Y
28-08-2025 17:27:57:ValidationRequest Exccution Success with response :  000
28-08-2025 17:27:57:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 17:36:45:<------------------------Started ValidationRequest CBS A/C No : 001002000868 ------------------------>
28-08-2025 17:36:45:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 17:36:45:Connection Establisment started
28-08-2025 17:36:45:Connection Read From File  : Status OK 
28-08-2025 17:36:45:Connection Successfully Opened  : Status OK 
28-08-2025 17:36:45:ValidateAcNo CBS A/C No : 001002000868
28-08-2025 17:36:45:CBS A/C No : 001002000868
28-08-2025 17:36:45:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 17:36:45:Record Count : 1
28-08-2025 17:36:45:BRLENGTH 3
28-08-2025 17:36:45:SCHLENGTH 3
28-08-2025 17:36:45:ACLENGTH 6
28-08-2025 17:36:45:Branch Code 3
28-08-2025 17:36:45:Scheme Code 3
28-08-2025 17:36:45:Account No 3
28-08-2025 17:36:45:Link Main Started
28-08-2025 17:36:45:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
28-08-2025 17:36:45:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 17:36:45:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000868|CD |001
28-08-2025 17:36:45:Validation Account Proce Executed with out error Y
28-08-2025 17:36:45:ValidationRequest Exccution Success with response :  000
28-08-2025 17:36:45:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 17:42:35:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : MAHBH00822894640|001001013897 -------------------------->
28-08-2025 17:42:35:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 17:42:35:Connection Establisment started
28-08-2025 17:42:35:Connection Read From File  : Status OK 
28-08-2025 17:42:35:Connection Successfully Opened  : Status OK 
28-08-2025 17:42:35:ValidateAcNo CBS A/C No : 001001013897
28-08-2025 17:42:35:CBS A/C No : 001001013897
28-08-2025 17:42:35:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 17:42:35:Record Count : 1
28-08-2025 17:42:35:BRLENGTH 3
28-08-2025 17:42:35:SCHLENGTH 3
28-08-2025 17:42:35:ACLENGTH 6
28-08-2025 17:42:35:Branch Code 3
28-08-2025 17:42:35:Scheme Code 3
28-08-2025 17:42:35:Account No 3
28-08-2025 17:42:35:Link Main Started
28-08-2025 17:42:35:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 17:42:35:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 17:42:35:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|013897|SB |001
28-08-2025 17:42:35:Validation Account Proce Executed with out error Y
28-08-2025 17:42:35:Connection Establisment started
28-08-2025 17:42:35:Connection Read From File  : Status OK 
28-08-2025 17:42:35:Connection Successfully Opened  : Status OK 
28-08-2025 17:42:35:CBS A/C No : 001001013897
28-08-2025 17:42:35:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 17:42:35:Record Count : 1
28-08-2025 17:42:35:BRLENGTH 3
28-08-2025 17:42:35:SCHLENGTH 3
28-08-2025 17:42:35:ACLENGTH 6
28-08-2025 17:42:35:Branch Code 3
28-08-2025 17:42:35:Scheme Code 3
28-08-2025 17:42:35:Account No 3
28-08-2025 17:42:35:Link Main Started
28-08-2025 17:42:35:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 17:42:35:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 17:42:35:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|013897|SB |001
28-08-2025 17:42:35:Vno --->:72007
28-08-2025 17:42:35:Current Date  --->:28-08-2025
28-08-2025 17:42:35:calling  CallNewRtgsBothProc 
28-08-2025 17:42:35:Parameters passing - InwardAuthorise 
28-08-2025 17:42:35: brn =001
28-08-2025 17:42:35: acno =013897
28-08-2025 17:42:35: abbr =SB
28-08-2025 17:42:35: amt.ToString() =10000
28-08-2025 17:42:35: traceNo =72007
28-08-2025 17:42:35: narr =NEFT, BY LAVI ASSOCIATES PROP RAJESH HABIB MAHB0001179 00000060243125981
28-08-2025 17:42:35:Transaction Process :  BEFORE CAL PROC:
28-08-2025 17:42:35:cbs no--->001001013897
28-08-2025 17:42:35:CBS A/C No : 001001013897
28-08-2025 17:42:35:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 17:42:35:Record Count : 1
28-08-2025 17:42:35:BRLENGTH 3
28-08-2025 17:42:35:SCHLENGTH 3
28-08-2025 17:42:35:ACLENGTH 6
28-08-2025 17:42:35:Branch Code 3
28-08-2025 17:42:35:Scheme Code 3
28-08-2025 17:42:35:Account No 3
28-08-2025 17:42:35:Link Main Started
28-08-2025 17:42:35:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 17:42:35:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 17:42:35:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|013897|SB |001
28-08-2025 17:42:35: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=013897  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=013897  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=013897  AND ADDR_SNO=CLMS_ADDRESS
28-08-2025 17:42:35:closed y n Record count --->1
28-08-2025 17:42:35:SMS Inserted for Mobile Number : +919901793636
28-08-2025 17:42:35:Inward Process Executed Sussefully
28-08-2025 17:42:35:ConfirmationReq Execution Success with Status 000
28-08-2025 17:42:35:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : MAHBH00822894640|001001013897 ------------------------------>
28-08-2025 17:42:35:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 18:12:18:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXOIR24000916540|001002000868 -------------------------->
28-08-2025 18:12:18:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 18:12:18:Connection Establisment started
28-08-2025 18:12:18:Connection Read From File  : Status OK 
28-08-2025 18:12:18:Connection Successfully Opened  : Status OK 
28-08-2025 18:12:18:ValidateAcNo CBS A/C No : 001002000868
28-08-2025 18:12:18:CBS A/C No : 001002000868
28-08-2025 18:12:18: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
28-08-2025 18:12:18:Record Count : 1
28-08-2025 18:12:18:BRLENGTH 3
28-08-2025 18:12:18:SCHLENGTH 3
28-08-2025 18:12:18:ACLENGTH 6
28-08-2025 18:12:18:Branch Code 3
28-08-2025 18:12:18:Scheme Code 3
28-08-2025 18:12:18:Account No 3
28-08-2025 18:12:18:Link Main Started
28-08-2025 18:12:18:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
28-08-2025 18:12:18:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 18:12:18:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000868|CD |001
28-08-2025 18:12:18:Validation Account Proce Executed with out error Y
28-08-2025 18:12:18:Connection Establisment started
28-08-2025 18:12:18:Connection Read From File  : Status OK 
28-08-2025 18:12:18:Connection Successfully Opened  : Status OK 
28-08-2025 18:12:18:CBS A/C No : 001002000868
28-08-2025 18:12:18: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
28-08-2025 18:12:18:Record Count : 1
28-08-2025 18:12:18:BRLENGTH 3
28-08-2025 18:12:18:SCHLENGTH 3
28-08-2025 18:12:18:ACLENGTH 6
28-08-2025 18:12:18:Branch Code 3
28-08-2025 18:12:18:Scheme Code 3
28-08-2025 18:12:18:Account No 3
28-08-2025 18:12:18:Link Main Started
28-08-2025 18:12:18:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
28-08-2025 18:12:18:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 18:12:18:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000868|CD |001
28-08-2025 18:12:18:Vno --->:72008
28-08-2025 18:12:18:Current Date  --->:28-08-2025
28-08-2025 18:12:18:calling  CallNewRtgsBothProc 
28-08-2025 18:12:18:Parameters passing - InwardAuthorise 
28-08-2025 18:12:18: brn =001
28-08-2025 18:12:18: acno =000868
28-08-2025 18:12:18: abbr =CD
28-08-2025 18:12:18: amt.ToString() =1534
28-08-2025 18:12:18: traceNo =72008
28-08-2025 18:12:18: narr =NEFT, BY GENESIS INDUSTRIAL SUPPLY UTIB0001690 917020035434040
28-08-2025 18:12:18:Transaction Process :  BEFORE CAL PROC:
28-08-2025 18:12:18:cbs no--->001002000868
28-08-2025 18:12:18:CBS A/C No : 001002000868
28-08-2025 18:12:18: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
28-08-2025 18:12:18:Record Count : 1
28-08-2025 18:12:18:BRLENGTH 3
28-08-2025 18:12:18:SCHLENGTH 3
28-08-2025 18:12:18:ACLENGTH 6
28-08-2025 18:12:18:Branch Code 3
28-08-2025 18:12:18:Scheme Code 3
28-08-2025 18:12:18:Account No 3
28-08-2025 18:12:18:Link Main Started
28-08-2025 18:12:18:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
28-08-2025 18:12:18:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 18:12:18:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000868|CD |001
28-08-2025 18:12:18: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
28-08-2025 18:12:18:closed y n Record count --->1
28-08-2025 18:12:18:SMS Inserted for Mobile Number : +919448051124
28-08-2025 18:12:18:Inward Process Executed Sussefully
28-08-2025 18:12:18:ConfirmationReq Execution Success with Status 000
28-08-2025 18:12:18:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXOIR24000916540|001002000868 ------------------------------>
28-08-2025 18:12:18:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 18:23:26:<------------------------Started ValidationRequest CBS A/C No : 001001013897 ------------------------>
28-08-2025 18:23:26:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 18:23:26:Connection Establisment started
28-08-2025 18:23:26:Connection Read From File  : Status OK 
28-08-2025 18:23:26:Connection Successfully Opened  : Status OK 
28-08-2025 18:23:26:ValidateAcNo CBS A/C No : 001001013897
28-08-2025 18:23:26:CBS A/C No : 001001013897
28-08-2025 18:23:26: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
28-08-2025 18:23:26:Record Count : 1
28-08-2025 18:23:26:BRLENGTH 3
28-08-2025 18:23:26:SCHLENGTH 3
28-08-2025 18:23:26:ACLENGTH 6
28-08-2025 18:23:26:Branch Code 3
28-08-2025 18:23:26:Scheme Code 3
28-08-2025 18:23:26:Account No 3
28-08-2025 18:23:26:Link Main Started
28-08-2025 18:23:26:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 18:23:26:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 18:23:26:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|013897|SB |001
28-08-2025 18:23:26:Validation Account Proce Executed with out error Y
28-08-2025 18:23:26:ValidationRequest Exccution Success with response :  000
28-08-2025 18:23:26:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 18:27:22:<------------------------Started ValidationRequest CBS A/C No : 001002000895 ------------------------>
28-08-2025 18:27:22:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 18:27:22:Connection Establisment started
28-08-2025 18:27:22:Connection Read From File  : Status OK 
28-08-2025 18:27:22:Connection Successfully Opened  : Status OK 
28-08-2025 18:27:22:ValidateAcNo CBS A/C No : 001002000895
28-08-2025 18:27:22:CBS A/C No : 001002000895
28-08-2025 18:27:22:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 18:27:22:Record Count : 1
28-08-2025 18:27:22:BRLENGTH 3
28-08-2025 18:27:22:SCHLENGTH 3
28-08-2025 18:27:22:ACLENGTH 6
28-08-2025 18:27:22:Branch Code 3
28-08-2025 18:27:22:Scheme Code 3
28-08-2025 18:27:22:Account No 3
28-08-2025 18:27:22:Link Main Started
28-08-2025 18:27:22:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
28-08-2025 18:27:22:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 18:27:22:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000895|CD |001
28-08-2025 18:27:22:Validation Account Proce Executed with out error Y
28-08-2025 18:27:22:ValidationRequest Exccution Success with response :  000
28-08-2025 18:27:22:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 18:41:17:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : MAHBH00822914766|001001013897 -------------------------->
28-08-2025 18:41:17:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 18:41:17:Connection Establisment started
28-08-2025 18:41:17:Connection Read From File  : Status OK 
28-08-2025 18:41:17:Connection Successfully Opened  : Status OK 
28-08-2025 18:41:17:ValidateAcNo CBS A/C No : 001001013897
28-08-2025 18:41:17:CBS A/C No : 001001013897
28-08-2025 18:41:17:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 18:41:17:Record Count : 1
28-08-2025 18:41:17:BRLENGTH 3
28-08-2025 18:41:17:SCHLENGTH 3
28-08-2025 18:41:17:ACLENGTH 6
28-08-2025 18:41:17:Branch Code 3
28-08-2025 18:41:17:Scheme Code 3
28-08-2025 18:41:17:Account No 3
28-08-2025 18:41:17:Link Main Started
28-08-2025 18:41:17:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 18:41:17:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 18:41:17:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|013897|SB |001
28-08-2025 18:41:17:Validation Account Proce Executed with out error Y
28-08-2025 18:41:17:Connection Establisment started
28-08-2025 18:41:17:Connection Read From File  : Status OK 
28-08-2025 18:41:17:Connection Successfully Opened  : Status OK 
28-08-2025 18:41:17:CBS A/C No : 001001013897
28-08-2025 18:41:17:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 18:41:17:Record Count : 1
28-08-2025 18:41:17:BRLENGTH 3
28-08-2025 18:41:17:SCHLENGTH 3
28-08-2025 18:41:17:ACLENGTH 6
28-08-2025 18:41:17:Branch Code 3
28-08-2025 18:41:17:Scheme Code 3
28-08-2025 18:41:17:Account No 3
28-08-2025 18:41:17:Link Main Started
28-08-2025 18:41:17:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 18:41:17:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 18:41:17:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|013897|SB |001
28-08-2025 18:41:17:Vno --->:72009
28-08-2025 18:41:17:Current Date  --->:28-08-2025
28-08-2025 18:41:17:calling  CallNewRtgsBothProc 
28-08-2025 18:41:17:Parameters passing - InwardAuthorise 
28-08-2025 18:41:17: brn =001
28-08-2025 18:41:17: acno =013897
28-08-2025 18:41:17: abbr =SB
28-08-2025 18:41:17: amt.ToString() =5000
28-08-2025 18:41:17: traceNo =72009
28-08-2025 18:41:17: narr =NEFT, BY LAVI ASSOCIATES PROP RAJESH HABIB MAHB0001179 00000060243125981
28-08-2025 18:41:17:Transaction Process :  BEFORE CAL PROC:
28-08-2025 18:41:17:cbs no--->001001013897
28-08-2025 18:41:17:CBS A/C No : 001001013897
28-08-2025 18:41:17:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 18:41:17:Record Count : 1
28-08-2025 18:41:17:BRLENGTH 3
28-08-2025 18:41:17:SCHLENGTH 3
28-08-2025 18:41:17:ACLENGTH 6
28-08-2025 18:41:17:Branch Code 3
28-08-2025 18:41:17:Scheme Code 3
28-08-2025 18:41:17:Account No 3
28-08-2025 18:41:17:Link Main Started
28-08-2025 18:41:17:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 
28-08-2025 18:41:17:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 18:41:17:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|013897|SB |001
28-08-2025 18:41:17:Closed YN quier  --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG,DSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM  clientmaster,depositmaster,depositschemesetup,ADDRESS  where CLMS_SNO=DEPM_CLIENT AND DSCH_BRANCH = DEPM_BRANCH AND DSCH_ABBR = DEPM_ABBR  and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB'  AND DEPM_NO=013897  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=013897  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=013897  AND ADDR_SNO=CLMS_ADDRESS
28-08-2025 18:41:17:closed y n Record count --->1
28-08-2025 18:41:17:SMS Inserted for Mobile Number : +919901793636
28-08-2025 18:41:17:Inward Process Executed Sussefully
28-08-2025 18:41:17:ConfirmationReq Execution Success with Status 000
28-08-2025 18:41:17:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : MAHBH00822914766|001001013897 ------------------------------>
28-08-2025 18:41:17:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 18:41:56:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : INDBH28088415351|001002000895 -------------------------->
28-08-2025 18:41:56:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 18:41:56:Connection Establisment started
28-08-2025 18:41:56:Connection Read From File  : Status OK 
28-08-2025 18:41:56:Connection Successfully Opened  : Status OK 
28-08-2025 18:41:56:ValidateAcNo CBS A/C No : 001002000895
28-08-2025 18:41:56:CBS A/C No : 001002000895
28-08-2025 18:41:56: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
28-08-2025 18:41:56:Record Count : 1
28-08-2025 18:41:56:BRLENGTH 3
28-08-2025 18:41:56:SCHLENGTH 3
28-08-2025 18:41:56:ACLENGTH 6
28-08-2025 18:41:56:Branch Code 3
28-08-2025 18:41:56:Scheme Code 3
28-08-2025 18:41:56:Account No 3
28-08-2025 18:41:56:Link Main Started
28-08-2025 18:41:56:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
28-08-2025 18:41:56:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 18:41:56:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000895|CD |001
28-08-2025 18:41:56:Validation Account Proce Executed with out error Y
28-08-2025 18:41:56:Connection Establisment started
28-08-2025 18:41:56:Connection Read From File  : Status OK 
28-08-2025 18:41:56:Connection Successfully Opened  : Status OK 
28-08-2025 18:41:56:CBS A/C No : 001002000895
28-08-2025 18:41:56: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
28-08-2025 18:41:56:Record Count : 1
28-08-2025 18:41:56:BRLENGTH 3
28-08-2025 18:41:56:SCHLENGTH 3
28-08-2025 18:41:56:ACLENGTH 6
28-08-2025 18:41:56:Branch Code 3
28-08-2025 18:41:56:Scheme Code 3
28-08-2025 18:41:56:Account No 3
28-08-2025 18:41:56:Link Main Started
28-08-2025 18:41:56:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
28-08-2025 18:41:56:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 18:41:56:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000895|CD |001
28-08-2025 18:41:56:Vno --->:72010
28-08-2025 18:41:56:Current Date  --->:28-08-2025
28-08-2025 18:41:56:calling  CallNewRtgsBothProc 
28-08-2025 18:41:56:Parameters passing - InwardAuthorise 
28-08-2025 18:41:56: brn =001
28-08-2025 18:41:56: acno =000895
28-08-2025 18:41:56: abbr =CD
28-08-2025 18:41:56: amt.ToString() =1000000
28-08-2025 18:41:56: traceNo =72010
28-08-2025 18:41:56: narr =NEFT, BY MY SEEDS PRIVATE LIMITED INDB0000006 650014162252
28-08-2025 18:41:56:Transaction Process :  BEFORE CAL PROC:
28-08-2025 18:41:56:cbs no--->001002000895
28-08-2025 18:41:56:CBS A/C No : 001002000895
28-08-2025 18:41:56: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
28-08-2025 18:41:56:Record Count : 1
28-08-2025 18:41:56:BRLENGTH 3
28-08-2025 18:41:56:SCHLENGTH 3
28-08-2025 18:41:56:ACLENGTH 6
28-08-2025 18:41:56:Branch Code 3
28-08-2025 18:41:56:Scheme Code 3
28-08-2025 18:41:56:Account No 3
28-08-2025 18:41:56:Link Main Started
28-08-2025 18:41:56:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
28-08-2025 18:41:56:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 18:41:56:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000895|CD |001
28-08-2025 18:41:56:Closed YN quier  --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG,DSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM  clientmaster,depositmaster,depositschemesetup,ADDRESS  where CLMS_SNO=DEPM_CLIENT AND DSCH_BRANCH = DEPM_BRANCH AND DSCH_ABBR = DEPM_ABBR  and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='CD'  AND DEPM_NO=000895  AND ADDR_SNO=CLMS_ADDRESS union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG,LSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM  clientmaster,LOANMASTER,LOANSCHEMESETUP,ADDRESS  where CLMS_SNO=LOAM_CLIENT  AND LSCH_BRANCH = LOAM_BRANCH AND LSCH_ABBREV = LOAM_ABBR and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='CD'  AND LOAM_NO=000895  AND ADDR_SNO=CLMS_ADDRESS UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG,ODST_GLLINK AS GLLINK,ADDR_MOBILENO FROM  clientmaster,ODMASTER,ODSCHEMESETUP,ADDRESS  where CLMS_SNO=ODMT_CLIENT AND ODST_BRANCH = ODMT_BRANCH AND ODST_ABBR = ODMT_ABBR and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='CD'  AND ODMT_NO=000895  AND ADDR_SNO=CLMS_ADDRESS
28-08-2025 18:41:56:closed y n Record count --->1
28-08-2025 18:41:56:SMS Inserted for Mobile Number : +919972536615
28-08-2025 18:41:56:Inward Process Executed Sussefully
28-08-2025 18:41:56:ConfirmationReq Execution Success with Status 000
28-08-2025 18:41:56:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : INDBH28088415351|001002000895 ------------------------------>
28-08-2025 18:41:56:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 19:35:39:<------------------------Started ValidationRequest CBS A/C No : 001002000868 ------------------------>
28-08-2025 19:35:39:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 19:35:39:Connection Establisment started
28-08-2025 19:35:39:Connection Read From File  : Status OK 
28-08-2025 19:35:40:Connection Successfully Opened  : Status OK 
28-08-2025 19:35:40:ValidateAcNo CBS A/C No : 001002000868
28-08-2025 19:35:40:CBS A/C No : 001002000868
28-08-2025 19:35:40: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
28-08-2025 19:35:40:Record Count : 1
28-08-2025 19:35:40:BRLENGTH 3
28-08-2025 19:35:40:SCHLENGTH 3
28-08-2025 19:35:40:ACLENGTH 6
28-08-2025 19:35:40:Branch Code 3
28-08-2025 19:35:40:Scheme Code 3
28-08-2025 19:35:40:Account No 3
28-08-2025 19:35:40:Link Main Started
28-08-2025 19:35:40:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
28-08-2025 19:35:40:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 19:35:40:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000868|CD |001
28-08-2025 19:35:40:Validation Account Proce Executed with out error Y
28-08-2025 19:35:40:ValidationRequest Exccution Success with response :  000
28-08-2025 19:35:40:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 19:54:17:<------------------------Started ValidationRequest CBS A/C No : 001002000835 ------------------------>
28-08-2025 19:54:17:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 19:54:17:Connection Establisment started
28-08-2025 19:54:17:Connection Read From File  : Status OK 
28-08-2025 19:54:17:Connection Successfully Opened  : Status OK 
28-08-2025 19:54:17:ValidateAcNo CBS A/C No : 001002000835
28-08-2025 19:54:17:CBS A/C No : 001002000835
28-08-2025 19:54:17:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 19:54:17:Record Count : 1
28-08-2025 19:54:17:BRLENGTH 3
28-08-2025 19:54:17:SCHLENGTH 3
28-08-2025 19:54:17:ACLENGTH 6
28-08-2025 19:54:17:Branch Code 3
28-08-2025 19:54:17:Scheme Code 3
28-08-2025 19:54:17:Account No 3
28-08-2025 19:54:17:Link Main Started
28-08-2025 19:54:17:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
28-08-2025 19:54:17:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 19:54:17:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000835|CD |001
28-08-2025 19:54:17:Validation Account Proce Executed with out error Y
28-08-2025 19:54:17:ValidationRequest Exccution Success with response :  000
28-08-2025 19:54:17:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 20:10:10:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : FBBT252403221772|001002000868 -------------------------->
28-08-2025 20:10:10:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 20:10:10:Connection Establisment started
28-08-2025 20:10:10:Connection Read From File  : Status OK 
28-08-2025 20:10:10:Connection Successfully Opened  : Status OK 
28-08-2025 20:10:10:ValidateAcNo CBS A/C No : 001002000868
28-08-2025 20:10:10:CBS A/C No : 001002000868
28-08-2025 20:10:10:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 20:10:10:Record Count : 1
28-08-2025 20:10:10:BRLENGTH 3
28-08-2025 20:10:10:SCHLENGTH 3
28-08-2025 20:10:10:ACLENGTH 6
28-08-2025 20:10:10:Branch Code 3
28-08-2025 20:10:10:Scheme Code 3
28-08-2025 20:10:10:Account No 3
28-08-2025 20:10:10:Link Main Started
28-08-2025 20:10:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
28-08-2025 20:10:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 20:10:10:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000868|CD |001
28-08-2025 20:10:10:Validation Account Proce Executed with out error Y
28-08-2025 20:10:10:Connection Establisment started
28-08-2025 20:10:10:Connection Read From File  : Status OK 
28-08-2025 20:10:10:Connection Successfully Opened  : Status OK 
28-08-2025 20:10:10:CBS A/C No : 001002000868
28-08-2025 20:10:10:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO
28-08-2025 20:10:10:Record Count : 1
28-08-2025 20:10:10:BRLENGTH 3
28-08-2025 20:10:10:SCHLENGTH 3
28-08-2025 20:10:10:ACLENGTH 6
28-08-2025 20:10:10:Branch Code 3
28-08-2025 20:10:10:Scheme Code 3
28-08-2025 20:10:10:Account No 3
28-08-2025 20:10:10:Link Main Started
28-08-2025 20:10:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
28-08-2025 20:10:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 20:10:10:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000868|CD |001
28-08-2025 20:10:10:Vno --->:72011
28-08-2025 20:10:10:Current Date  --->:28-08-2025
28-08-2025 20:10:10:calling  CallNewRtgsBothProc 
28-08-2025 20:10:10:Parameters passing - InwardAuthorise 
28-08-2025 20:10:10: brn =001
28-08-2025 20:10:10: acno =000868
28-08-2025 20:10:10: abbr =CD
28-08-2025 20:10:10: amt.ToString() =28677
28-08-2025 20:10:10: traceNo =72011
28-08-2025 20:10:10: narr =NEFT, BY ISHAN MOTORS FDRL0009993 15070200001606
28-08-2025 20:10:10:Transaction Process :  BEFORE CAL PROC:
28-08-2025 20:10:11:cbs no--->001002000868
28-08-2025 20:10:11:CBS A/C No : 001002000868
28-08-2025 20:10:11: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
28-08-2025 20:10:11:Record Count : 1
28-08-2025 20:10:11:BRLENGTH 3
28-08-2025 20:10:11:SCHLENGTH 3
28-08-2025 20:10:11:ACLENGTH 6
28-08-2025 20:10:11:Branch Code 3
28-08-2025 20:10:11:Scheme Code 3
28-08-2025 20:10:11:Account No 3
28-08-2025 20:10:11:Link Main Started
28-08-2025 20:10:11:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
28-08-2025 20:10:11:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 20:10:11:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000868|CD |001
28-08-2025 20:10:11: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
28-08-2025 20:10:11:closed y n Record count --->1
28-08-2025 20:10:11:SMS Inserted for Mobile Number : +919448051124
28-08-2025 20:10:11:Inward Process Executed Sussefully
28-08-2025 20:10:11:ConfirmationReq Execution Success with Status 000
28-08-2025 20:10:11:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : FBBT252403221772|001002000868 ------------------------------>
28-08-2025 20:10:11:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 20:10:48:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : IDFB524046834560|001002000835 -------------------------->
28-08-2025 20:10:48:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 20:10:48:Connection Establisment started
28-08-2025 20:10:48:Connection Read From File  : Status OK 
28-08-2025 20:10:48:Connection Successfully Opened  : Status OK 
28-08-2025 20:10:48:ValidateAcNo CBS A/C No : 001002000835
28-08-2025 20:10:48:CBS A/C No : 001002000835
28-08-2025 20:10:48: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
28-08-2025 20:10:48:Record Count : 1
28-08-2025 20:10:48:BRLENGTH 3
28-08-2025 20:10:48:SCHLENGTH 3
28-08-2025 20:10:48:ACLENGTH 6
28-08-2025 20:10:48:Branch Code 3
28-08-2025 20:10:48:Scheme Code 3
28-08-2025 20:10:48:Account No 3
28-08-2025 20:10:48:Link Main Started
28-08-2025 20:10:48:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
28-08-2025 20:10:48:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 20:10:48:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000835|CD |001
28-08-2025 20:10:48:Validation Account Proce Executed with out error Y
28-08-2025 20:10:48:Connection Establisment started
28-08-2025 20:10:48:Connection Read From File  : Status OK 
28-08-2025 20:10:48:Connection Successfully Opened  : Status OK 
28-08-2025 20:10:48:CBS A/C No : 001002000835
28-08-2025 20:10:48: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
28-08-2025 20:10:48:Record Count : 1
28-08-2025 20:10:48:BRLENGTH 3
28-08-2025 20:10:48:SCHLENGTH 3
28-08-2025 20:10:48:ACLENGTH 6
28-08-2025 20:10:48:Branch Code 3
28-08-2025 20:10:48:Scheme Code 3
28-08-2025 20:10:48:Account No 3
28-08-2025 20:10:48:Link Main Started
28-08-2025 20:10:48:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
28-08-2025 20:10:48:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 20:10:48:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000835|CD |001
28-08-2025 20:10:48:Vno --->:72012
28-08-2025 20:10:48:Current Date  --->:28-08-2025
28-08-2025 20:10:48:calling  CallNewRtgsBothProc 
28-08-2025 20:10:48:Parameters passing - InwardAuthorise 
28-08-2025 20:10:48: brn =001
28-08-2025 20:10:48: acno =000835
28-08-2025 20:10:48: abbr =CD
28-08-2025 20:10:48: amt.ToString() =23955
28-08-2025 20:10:48: traceNo =72012
28-08-2025 20:10:48: narr =NEFT, BY NINJA FAST FOOD IDFB0040142 10226461075
28-08-2025 20:10:48:Transaction Process :  BEFORE CAL PROC:
28-08-2025 20:10:48:cbs no--->001002000835
28-08-2025 20:10:48:CBS A/C No : 001002000835
28-08-2025 20:10:48: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
28-08-2025 20:10:48:Record Count : 1
28-08-2025 20:10:48:BRLENGTH 3
28-08-2025 20:10:48:SCHLENGTH 3
28-08-2025 20:10:48:ACLENGTH 6
28-08-2025 20:10:48:Branch Code 3
28-08-2025 20:10:48:Scheme Code 3
28-08-2025 20:10:48:Account No 3
28-08-2025 20:10:48:Link Main Started
28-08-2025 20:10:48:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 
28-08-2025 20:10:48:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 20:10:48:ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000835|CD |001
28-08-2025 20:10:48: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=000835  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=000835  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=000835  AND ADDR_SNO=CLMS_ADDRESS
28-08-2025 20:10:48:closed y n Record count --->1
28-08-2025 20:10:48:SMS Inserted for Mobile Number : +919845507007
28-08-2025 20:10:48:Inward Process Executed Sussefully
28-08-2025 20:10:48:ConfirmationReq Execution Success with Status 000
28-08-2025 20:10:48:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : IDFB524046834560|001002000835 ------------------------------>
28-08-2025 20:10:48:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 21:50:18:<------------------------Started ValidationRequest CBS A/C No : 001022000081 ------------------------>
28-08-2025 21:50:18:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 21:50:18:Connection Establisment started
28-08-2025 21:50:18:Connection Read From File  : Status OK 
28-08-2025 21:50:18:Connection Successfully Opened  : Status OK 
28-08-2025 21:50:18:ValidateAcNo CBS A/C No : 001022000081
28-08-2025 21:50:18:CBS A/C No : 001022000081
28-08-2025 21:50:18: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
28-08-2025 21:50:18:Record Count : 1
28-08-2025 21:50:18:BRLENGTH 3
28-08-2025 21:50:18:SCHLENGTH 3
28-08-2025 21:50:18:ACLENGTH 6
28-08-2025 21:50:18:Branch Code 3
28-08-2025 21:50:18:Scheme Code 3
28-08-2025 21:50:18:Account No 3
28-08-2025 21:50:18:Link Main Started
28-08-2025 21:50:18:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 022 and LINK_BRANCH=BRAN_SNO 
28-08-2025 21:50:18:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 21:50:18:ShowCBS Ac No Proce Executed  HEAD OFFICE|OD|000081|OD |001
28-08-2025 21:50:18:Validation Account Proce Executed with out error Y
28-08-2025 21:50:18:ValidationRequest Exccution Success with response :  000
28-08-2025 21:50:18:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 22:00:19:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : HDFCR52025082855374161|001022000081 -------------------------->
28-08-2025 22:00:19:<------------------------------------------------------------------------------------------------------------------------>
28-08-2025 22:00:19:Connection Establisment started
28-08-2025 22:00:19:Connection Read From File  : Status OK 
28-08-2025 22:00:19:Connection Successfully Opened  : Status OK 
28-08-2025 22:00:19:ValidateAcNo CBS A/C No : 001022000081
28-08-2025 22:00:19:CBS A/C No : 001022000081
28-08-2025 22:00:19: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
28-08-2025 22:00:19:Record Count : 1
28-08-2025 22:00:19:BRLENGTH 3
28-08-2025 22:00:19:SCHLENGTH 3
28-08-2025 22:00:19:ACLENGTH 6
28-08-2025 22:00:19:Branch Code 3
28-08-2025 22:00:19:Scheme Code 3
28-08-2025 22:00:19:Account No 3
28-08-2025 22:00:19:Link Main Started
28-08-2025 22:00:19:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 022 and LINK_BRANCH=BRAN_SNO 
28-08-2025 22:00:19:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 22:00:19:ShowCBS Ac No Proce Executed  HEAD OFFICE|OD|000081|OD |001
28-08-2025 22:00:19:Validation Account Proce Executed with out error Y
28-08-2025 22:00:19:Connection Establisment started
28-08-2025 22:00:19:Connection Read From File  : Status OK 
28-08-2025 22:00:19:Connection Successfully Opened  : Status OK 
28-08-2025 22:00:19:CBS A/C No : 001022000081
28-08-2025 22:00:19: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
28-08-2025 22:00:19:Record Count : 1
28-08-2025 22:00:19:BRLENGTH 3
28-08-2025 22:00:19:SCHLENGTH 3
28-08-2025 22:00:19:ACLENGTH 6
28-08-2025 22:00:19:Branch Code 3
28-08-2025 22:00:19:Scheme Code 3
28-08-2025 22:00:19:Account No 3
28-08-2025 22:00:19:Link Main Started
28-08-2025 22:00:19:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 022 and LINK_BRANCH=BRAN_SNO 
28-08-2025 22:00:19:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 22:00:19:ShowCBS Ac No Proce Executed  HEAD OFFICE|OD|000081|OD |001
28-08-2025 22:00:19:Vno --->:72013
28-08-2025 22:00:19:Current Date  --->:28-08-2025
28-08-2025 22:00:19:calling  CallNewRtgsBothProc 
28-08-2025 22:00:19:Parameters passing - InwardAuthorise 
28-08-2025 22:00:19: brn =001
28-08-2025 22:00:19: acno =000081
28-08-2025 22:00:19: abbr =OD
28-08-2025 22:00:19: amt.ToString() =200000
28-08-2025 22:00:19: traceNo =72013
28-08-2025 22:00:19: narr =RTGS, BY SHIVSHAKTI MINERALS HDFC0000240 99902727279999  
28-08-2025 22:00:19:Transaction Process :  BEFORE CAL PROC:
28-08-2025 22:00:19:cbs no--->001022000081
28-08-2025 22:00:19:CBS A/C No : 001022000081
28-08-2025 22:00:19: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
28-08-2025 22:00:19:Record Count : 1
28-08-2025 22:00:19:BRLENGTH 3
28-08-2025 22:00:19:SCHLENGTH 3
28-08-2025 22:00:19:ACLENGTH 6
28-08-2025 22:00:19:Branch Code 3
28-08-2025 22:00:19:Scheme Code 3
28-08-2025 22:00:19:Account No 3
28-08-2025 22:00:19:Link Main Started
28-08-2025 22:00:19:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 022 and LINK_BRANCH=BRAN_SNO 
28-08-2025 22:00:19:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001
28-08-2025 22:00:19:ShowCBS Ac No Proce Executed  HEAD OFFICE|OD|000081|OD |001
28-08-2025 22:00:19: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=000081  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=000081  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=000081  AND ADDR_SNO=CLMS_ADDRESS
28-08-2025 22:00:19:closed y n Record count --->1
28-08-2025 22:00:19:SMS Inserted for Mobile Number : +919845507007
28-08-2025 22:00:19:Inward Process Executed Sussefully
28-08-2025 22:00:19:ConfirmationReq Execution Success with Status 000
28-08-2025 22:00:19:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : HDFCR52025082855374161|001022000081 ------------------------------>
28-08-2025 22:00:19:<------------------------------------------------------------------------------------------------------------------------>