03-06-2025 12:21:08:<------------------------Started ValidationRequest CBS A/C No : 001001013099 ------------------------> 03-06-2025 12:21:08:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:21:08:Connection Establisment started 03-06-2025 12:21:08:Error ValidationRequest The process cannot access the file 'D:\IISPL\RTGSInward\SSLWCFSSK\log\2025-06-03T122108_RtgsNeftLog.txt' because it is being used by another process. 03-06-2025 12:21:08:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:21:08:ValidationRequest Exccution Success with response : 111 03-06-2025 12:21:08:Connection Establisment started 03-06-2025 12:21:08:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:21:08:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:21:08:<------------------------Started ValidationRequest CBS A/C No : 001001005543 ------------------------> 03-06-2025 12:21:08:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:21:08:<------------------------Started ValidationRequest CBS A/C No : 001001012574 ------------------------> 03-06-2025 12:21:08:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:21:08:Connection Establisment started 03-06-2025 12:21:08:Connection Read From File : Status OK 03-06-2025 12:21:08:Connection Read From File : Status OK 03-06-2025 12:21:08:Connection Read From File : Status OK 03-06-2025 12:21:08:Connection Successfully Opened : Status OK 03-06-2025 12:21:08:ValidateAcNo CBS A/C No : 001001004009 03-06-2025 12:21:08:CBS A/C No : 001001004009 03-06-2025 12:21:08:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 03-06-2025 12:21:08:<------------------------Started ValidationRequest CBS A/C No : 0000001002000487 ------------------------> 03-06-2025 12:21:08:<------------------------Started ValidationRequest CBS A/C No : 001001003013 ------------------------> 03-06-2025 12:21:08:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:21:08:Connection Establisment started 03-06-2025 12:21:08:Connection Establisment started 03-06-2025 12:21:08:Connection Read From File : Status OK 03-06-2025 12:21:08:<------------------------Started ValidationRequest CBS A/C No : 0000001001011111 ------------------------> 03-06-2025 12:21:08:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:21:08:<------------------------Started ValidationRequest CBS A/C No : 001001001671 ------------------------> 03-06-2025 12:21:08:Connection Establisment started 03-06-2025 12:21:08:Connection Read From File : Status OK 03-06-2025 12:21:08:Connection Establisment started 03-06-2025 12:21:08:Connection Read From File : Status OK 03-06-2025 12:21:08:Record Count : 1 03-06-2025 12:21:08:BRLENGTH 3 03-06-2025 12:21:08:SCHLENGTH 3 03-06-2025 12:21:08:ACLENGTH 6 03-06-2025 12:21:08:Branch Code 3 03-06-2025 12:21:08:Scheme Code 3 03-06-2025 12:21:08:Account No 3 03-06-2025 12:21:08:Link Main Started 03-06-2025 12:21:08:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:21:08:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:21:08:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|004009|SB |001 03-06-2025 12:21:08:<------------------------Started ValidationRequest CBS A/C No : 001002000868 ------------------------> 03-06-2025 12:21:08:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:21:08:Connection Establisment started 03-06-2025 12:21:08:Connection Read From File : Status OK 03-06-2025 12:21:08:Validation Account Proce Executed with out error Y 03-06-2025 12:21:08:ValidationRequest Exccution Success with response : 000 03-06-2025 12:21:08:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:21:08:<------------------------Started ValidationRequest CBS A/C No : 001001003670 ------------------------> 03-06-2025 12:21:08:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:21:08:Connection Establisment started 03-06-2025 12:21:08:Connection Read From File : Status OK 03-06-2025 12:21:08:Connection Successfully Opened : Status OK 03-06-2025 12:21:08:ValidateAcNo CBS A/C No : 001001013099 03-06-2025 12:21:08:CBS A/C No : 001001013099 03-06-2025 12:21:08:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 03-06-2025 12:21:08:Record Count : 1 03-06-2025 12:21:08:BRLENGTH 3 03-06-2025 12:21:08:SCHLENGTH 3 03-06-2025 12:21:08:ACLENGTH 6 03-06-2025 12:21:08:Branch Code 3 03-06-2025 12:21:08:Scheme Code 3 03-06-2025 12:21:08:Account No 3 03-06-2025 12:21:08:Link Main Started 03-06-2025 12:21:08:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:21:08:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:21:08:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|013099|SB |001 03-06-2025 12:21:08:Validation Account Proce Executed with out error Y 03-06-2025 12:21:08:ValidationRequest Exccution Success with response : 000 03-06-2025 12:21:08:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:21:08:<------------------------Started ValidationRequest CBS A/C No : 002002000012 ------------------------> 03-06-2025 12:21:08:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:21:08:Connection Establisment started 03-06-2025 12:21:08:Connection Read From File : Status OK 03-06-2025 12:21:08:Connection Successfully Opened : Status OK 03-06-2025 12:21:08:ValidateAcNo CBS A/C No : 001001005543 03-06-2025 12:21:08:CBS A/C No : 001001005543 03-06-2025 12:21:08:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 03-06-2025 12:21:08:Record Count : 1 03-06-2025 12:21:08:BRLENGTH 3 03-06-2025 12:21:08:SCHLENGTH 3 03-06-2025 12:21:08:ACLENGTH 6 03-06-2025 12:21:08:Branch Code 3 03-06-2025 12:21:08:Scheme Code 3 03-06-2025 12:21:08:Account No 3 03-06-2025 12:21:08:Link Main Started 03-06-2025 12:21:08:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:21:08:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:21:08:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|005543|SB |001 03-06-2025 12:21:08:Validation Account Proce Executed with out error Y 03-06-2025 12:21:08:ValidationRequest Exccution Success with response : 000 03-06-2025 12:21:08:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:21:08:<------------------------Started ValidationRequest CBS A/C No : 0000001001013815 ------------------------> 03-06-2025 12:21:08:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:21:08:Connection Establisment started 03-06-2025 12:21:08:Connection Read From File : Status OK 03-06-2025 12:21:08:Connection Successfully Opened : Status OK 03-06-2025 12:21:08:ValidateAcNo CBS A/C No : 001001012574 03-06-2025 12:21:08:CBS A/C No : 001001012574 03-06-2025 12:21:08:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 03-06-2025 12:21:08:Record Count : 1 03-06-2025 12:21:08:BRLENGTH 3 03-06-2025 12:21:08:SCHLENGTH 3 03-06-2025 12:21:08:ACLENGTH 6 03-06-2025 12:21:08:Branch Code 3 03-06-2025 12:21:08:Scheme Code 3 03-06-2025 12:21:08:Account No 3 03-06-2025 12:21:08:Link Main Started 03-06-2025 12:21:08:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:21:08:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:21:08:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|012574|SB |001 03-06-2025 12:21:08:Validation Account Proce Executed with out error Y 03-06-2025 12:21:08:ValidationRequest Exccution Success with response : 000 03-06-2025 12:21:08:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:21:08:<------------------------Started ValidationRequest CBS A/C No : 001001002209 ------------------------> 03-06-2025 12:21:08:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:21:08:Connection Establisment started 03-06-2025 12:21:08:Connection Read From File : Status OK 03-06-2025 12:21:08:Connection Successfully Opened : Status OK 03-06-2025 12:21:08:ValidateAcNo CBS A/C No : 0000001002000487 03-06-2025 12:21:08:Validation Account Proce Executed with out error N 03-06-2025 12:21:08:ValidationRequest Exccution Success with response : 111 03-06-2025 12:21:08:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:21:08:<------------------------Started ValidationRequest CBS A/C No : 001022000083 ------------------------> 03-06-2025 12:21:08:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:21:08:Connection Establisment started 03-06-2025 12:21:08:Connection Read From File : Status OK 03-06-2025 12:21:09:Connection Successfully Opened : Status OK 03-06-2025 12:21:09:ValidateAcNo CBS A/C No : 001001003013 03-06-2025 12:21:09:CBS A/C No : 001001003013 03-06-2025 12:21:09:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 03-06-2025 12:21:09:Record Count : 1 03-06-2025 12:21:09:BRLENGTH 3 03-06-2025 12:21:09:SCHLENGTH 3 03-06-2025 12:21:09:ACLENGTH 6 03-06-2025 12:21:09:Branch Code 3 03-06-2025 12:21:09:Scheme Code 3 03-06-2025 12:21:09:Account No 3 03-06-2025 12:21:09:Link Main Started 03-06-2025 12:21:09:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:21:09:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:21:09:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|003013|SB |001 03-06-2025 12:21:09:Validation Account Proce Executed with out error Y 03-06-2025 12:21:09:ValidationRequest Exccution Success with response : 000 03-06-2025 12:21:09:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:21:09:<------------------------Started ValidationRequest CBS A/C No : 001001009761 ------------------------> 03-06-2025 12:21:09:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:21:09:Connection Establisment started 03-06-2025 12:21:09:Connection Read From File : Status OK 03-06-2025 12:21:09:Connection Successfully Opened : Status OK 03-06-2025 12:21:09:ValidateAcNo CBS A/C No : 0000001001011111 03-06-2025 12:21:09:Validation Account Proce Executed with out error N 03-06-2025 12:21:09:ValidationRequest Exccution Success with response : 111 03-06-2025 12:21:09:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:21:09:Connection Successfully Opened : Status OK 03-06-2025 12:21:09:ValidateAcNo CBS A/C No : 001001001671 03-06-2025 12:21:09:CBS A/C No : 001001001671 03-06-2025 12:21:09:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 03-06-2025 12:21:09:Record Count : 1 03-06-2025 12:21:09:BRLENGTH 3 03-06-2025 12:21:09:SCHLENGTH 3 03-06-2025 12:21:09:ACLENGTH 6 03-06-2025 12:21:09:Branch Code 3 03-06-2025 12:21:09:Scheme Code 3 03-06-2025 12:21:09:Account No 3 03-06-2025 12:21:09:Link Main Started 03-06-2025 12:21:09:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:21:09:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:21:09:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001671|SB |001 03-06-2025 12:21:09:Validation Account Proce Executed with out error Y 03-06-2025 12:21:09:ValidationRequest Exccution Success with response : 000 03-06-2025 12:21:09:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:21:09:<------------------------Started ValidationRequest CBS A/C No : 001001013800 ------------------------> 03-06-2025 12:21:09:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:21:09:Connection Establisment started 03-06-2025 12:21:09:Connection Read From File : Status OK 03-06-2025 12:21:09:Connection Successfully Opened : Status OK 03-06-2025 12:21:09:ValidateAcNo CBS A/C No : 001002000868 03-06-2025 12:21:09:CBS A/C No : 001002000868 03-06-2025 12:21:09:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 03-06-2025 12:21:09:Record Count : 1 03-06-2025 12:21:09:BRLENGTH 3 03-06-2025 12:21:09:SCHLENGTH 3 03-06-2025 12:21:09:ACLENGTH 6 03-06-2025 12:21:09:Branch Code 3 03-06-2025 12:21:09:Scheme Code 3 03-06-2025 12:21:09:Account No 3 03-06-2025 12:21:09:Link Main Started 03-06-2025 12:21:09:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:21:09:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:21:09:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000868|CD |001 03-06-2025 12:21:09:Validation Account Proce Executed with out error Y 03-06-2025 12:21:09:ValidationRequest Exccution Success with response : 000 03-06-2025 12:21:09:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:21:09:Connection Successfully Opened : Status OK 03-06-2025 12:21:09:ValidateAcNo CBS A/C No : 001001003670 03-06-2025 12:21:09:CBS A/C No : 001001003670 03-06-2025 12:21:09:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 03-06-2025 12:21:09:Record Count : 1 03-06-2025 12:21:09:BRLENGTH 3 03-06-2025 12:21:09:SCHLENGTH 3 03-06-2025 12:21:09:ACLENGTH 6 03-06-2025 12:21:09:Branch Code 3 03-06-2025 12:21:09:Scheme Code 3 03-06-2025 12:21:09:Account No 3 03-06-2025 12:21:09:Link Main Started 03-06-2025 12:21:09:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:21:09:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:21:09:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|003670|SB |001 03-06-2025 12:21:09:Validation Account Proce Executed with out error Y 03-06-2025 12:21:09:ValidationRequest Exccution Success with response : 000 03-06-2025 12:21:09:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:21:09:Connection Successfully Opened : Status OK 03-06-2025 12:21:09:ValidateAcNo CBS A/C No : 002002000012 03-06-2025 12:21:09:CBS A/C No : 002002000012 03-06-2025 12:21:09:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 03-06-2025 12:21:09:Record Count : 1 03-06-2025 12:21:09:BRLENGTH 3 03-06-2025 12:21:09:SCHLENGTH 3 03-06-2025 12:21:09:ACLENGTH 6 03-06-2025 12:21:09:Branch Code 3 03-06-2025 12:21:09:Scheme Code 3 03-06-2025 12:21:09:Account No 3 03-06-2025 12:21:09:Link Main Started 03-06-2025 12:21:09:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:21:09:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 002 03-06-2025 12:21:09:ShowCBS Ac No Proce Executed BARDANSAL|DEPOSIT|000012|CD |002 03-06-2025 12:21:09:Validation Account Proce Executed with out error Y 03-06-2025 12:21:09:ValidationRequest Exccution Success with response : 000 03-06-2025 12:21:09:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:21:09:Connection Successfully Opened : Status OK 03-06-2025 12:21:09:ValidateAcNo CBS A/C No : 0000001001013815 03-06-2025 12:21:09:Validation Account Proce Executed with out error N 03-06-2025 12:21:09:ValidationRequest Exccution Success with response : 111 03-06-2025 12:21:09:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:21:09:Connection Successfully Opened : Status OK 03-06-2025 12:21:09:ValidateAcNo CBS A/C No : 001001002209 03-06-2025 12:21:09:CBS A/C No : 001001002209 03-06-2025 12:21:09:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 03-06-2025 12:21:09:Record Count : 1 03-06-2025 12:21:09:BRLENGTH 3 03-06-2025 12:21:09:SCHLENGTH 3 03-06-2025 12:21:09:ACLENGTH 6 03-06-2025 12:21:09:Branch Code 3 03-06-2025 12:21:09:Scheme Code 3 03-06-2025 12:21:09:Account No 3 03-06-2025 12:21:09:Link Main Started 03-06-2025 12:21:09:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:21:09:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:21:09:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|002209|SB |001 03-06-2025 12:21:09:Validation Account Proce Executed with out error Y 03-06-2025 12:21:09:ValidationRequest Exccution Success with response : 000 03-06-2025 12:21:09:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:21:09:Connection Successfully Opened : Status OK 03-06-2025 12:21:09:ValidateAcNo CBS A/C No : 001022000083 03-06-2025 12:21:09:CBS A/C No : 001022000083 03-06-2025 12:21:09:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 03-06-2025 12:21:09:Record Count : 1 03-06-2025 12:21:09:BRLENGTH 3 03-06-2025 12:21:09:SCHLENGTH 3 03-06-2025 12:21:09:ACLENGTH 6 03-06-2025 12:21:09:Branch Code 3 03-06-2025 12:21:09:Scheme Code 3 03-06-2025 12:21:09:Account No 3 03-06-2025 12:21:09:Link Main Started 03-06-2025 12:21:09:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 022 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:21:09:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:21:09:ShowCBS Ac No Proce Executed HEAD OFFICE|OD|000083|OD |001 03-06-2025 12:21:09:Validation Account Proce Executed with out error Y 03-06-2025 12:21:09:ValidationRequest Exccution Success with response : 000 03-06-2025 12:21:09:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:21:09:Connection Successfully Opened : Status OK 03-06-2025 12:21:09:ValidateAcNo CBS A/C No : 001001009761 03-06-2025 12:21:09:CBS A/C No : 001001009761 03-06-2025 12:21:09:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 03-06-2025 12:21:09:Record Count : 1 03-06-2025 12:21:09:BRLENGTH 3 03-06-2025 12:21:09:SCHLENGTH 3 03-06-2025 12:21:09:ACLENGTH 6 03-06-2025 12:21:09:Branch Code 3 03-06-2025 12:21:09:Scheme Code 3 03-06-2025 12:21:09:Account No 3 03-06-2025 12:21:09:Link Main Started 03-06-2025 12:21:09:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:21:09:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:21:09:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|009761|SB |001 03-06-2025 12:21:09:Validation Account Proce Executed with out error Y 03-06-2025 12:21:09:ValidationRequest Exccution Success with response : 000 03-06-2025 12:21:09:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:21:09:Connection Successfully Opened : Status OK 03-06-2025 12:21:09:ValidateAcNo CBS A/C No : 001001013800 03-06-2025 12:21:09:CBS A/C No : 001001013800 03-06-2025 12:21:09:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 03-06-2025 12:21:09:Record Count : 1 03-06-2025 12:21:09:BRLENGTH 3 03-06-2025 12:21:09:SCHLENGTH 3 03-06-2025 12:21:09:ACLENGTH 6 03-06-2025 12:21:09:Branch Code 3 03-06-2025 12:21:09:Scheme Code 3 03-06-2025 12:21:09:Account No 3 03-06-2025 12:21:09:Link Main Started 03-06-2025 12:21:09:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:21:09:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:21:09:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|013800|SB |001 03-06-2025 12:21:09:Validation Account Proce Executed with out error Y 03-06-2025 12:21:09:ValidationRequest Exccution Success with response : 000 03-06-2025 12:21:09:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:40:12:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN15487614317|001001002209 --------------------------> 03-06-2025 12:40:12:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:40:12:Connection Establisment started 03-06-2025 12:40:12:Connection Read From File : Status OK 03-06-2025 12:40:12:Connection Successfully Opened : Status OK 03-06-2025 12:40:12:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN15487612704|001001004009 --------------------------> 03-06-2025 12:40:12:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:40:12:Connection Establisment started 03-06-2025 12:40:12:CBS A/C No : 001001002209 03-06-2025 12: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 03-06-2025 12:40:12:Record Count : 1 03-06-2025 12:40:12:BRLENGTH 3 03-06-2025 12:40:12:SCHLENGTH 3 03-06-2025 12:40:12:ACLENGTH 6 03-06-2025 12:40:12:Branch Code 3 03-06-2025 12:40:12:Scheme Code 3 03-06-2025 12:40:12:Account No 3 03-06-2025 12:40:12:Link Main Started 03-06-2025 12:40:12:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:40:12:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN15487614576|001001013800 --------------------------> 03-06-2025 12:40:12:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:40:12:Connection Establisment started 03-06-2025 12:40:12:Connection Read From File : Status OK 03-06-2025 12:40:12:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:40:12:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|002209|SB |001 03-06-2025 12:40:12:Validation Account Proce Executed with out error Y 03-06-2025 12:40:12:Connection Establisment started 03-06-2025 12:40:12:Connection Read From File : Status OK 03-06-2025 12:40:12:ValidateAcNo CBS A/C No : 001001013800 03-06-2025 12:40:12:CBS A/C No : 001001013800 03-06-2025 12: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 03-06-2025 12:40:12:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN15487612717|001001005543 --------------------------> 03-06-2025 12:40:12:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:40:12:Connection Establisment started 03-06-2025 12:40:12:Connection Read From File : Status OK 03-06-2025 12:40:12:BRLENGTH 3 03-06-2025 12:40:12:SCHLENGTH 3 03-06-2025 12:40:12:ACLENGTH 6 03-06-2025 12:40:12:Branch Code 3 03-06-2025 12:40:12:Scheme Code 3 03-06-2025 12:40:12:Account No 3 03-06-2025 12:40:12:Link Main Started 03-06-2025 12:40:12:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:40:12:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:40:12:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|013800|SB |001 03-06-2025 12:40:12:Validation Account Proce Executed with out error Y 03-06-2025 12:40:12:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM15487621819|001001009761 --------------------------> 03-06-2025 12:40:12:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:40:12:Connection Establisment started 03-06-2025 12:40:12:Error ConfirmationReq The process cannot access the file 'D:\IISPL\RTGSInward\SSLWCFSSK\log\2025-06-03T124012_RtgsNeftLog.txt' because it is being used by another process. 03-06-2025 12:40:12:Connection Read From File : Status OK 03-06-2025 12:40:12:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN15487614317|001001002209 ------------------------------> 03-06-2025 12:40:12:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:40:12:Connection Successfully Opened : Status OK 03-06-2025 12:40:12:ValidateAcNo CBS A/C No : 001001004009 03-06-2025 12:40:12:CBS A/C No : 001001004009 03-06-2025 12: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 03-06-2025 12:40:12:Record Count : 1 03-06-2025 12:40:12:BRLENGTH 3 03-06-2025 12:40:12:SCHLENGTH 3 03-06-2025 12:40:12:ACLENGTH 6 03-06-2025 12:40:12:Branch Code 3 03-06-2025 12:40:12:Scheme Code 3 03-06-2025 12:40:12:Account No 3 03-06-2025 12:40:12:Link Main Started 03-06-2025 12:40:12:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:40:12:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:40:12:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|004009|SB |001 03-06-2025 12:40:12:Validation Account Proce Executed with out error Y 03-06-2025 12:40:12:Connection Establisment started 03-06-2025 12:40:12:Connection Read From File : Status OK 03-06-2025 12:40:12:CBS A/C No : 001001013800 03-06-2025 12: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 03-06-2025 12:40:12:Record Count : 1 03-06-2025 12:40:12:BRLENGTH 3 03-06-2025 12:40:12:SCHLENGTH 3 03-06-2025 12:40:12:ACLENGTH 6 03-06-2025 12:40:12:Branch Code 3 03-06-2025 12:40:12:Scheme Code 3 03-06-2025 12:40:12:Account No 3 03-06-2025 12:40:12:Link Main Started 03-06-2025 12:40:12:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:40:12:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:40:12:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|013800|SB |001 03-06-2025 12:40:12:Connection Successfully Opened : Status OK 03-06-2025 12:40:12:ValidateAcNo CBS A/C No : 001001005543 03-06-2025 12:40:12:CBS A/C No : 001001005543 03-06-2025 12: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 03-06-2025 12:40:12:Record Count : 1 03-06-2025 12:40:12:BRLENGTH 3 03-06-2025 12:40:12:SCHLENGTH 3 03-06-2025 12:40:12:ACLENGTH 6 03-06-2025 12:40:12:Branch Code 3 03-06-2025 12:40:12:Scheme Code 3 03-06-2025 12:40:12:Account No 3 03-06-2025 12:40:12:Link Main Started 03-06-2025 12:40:12:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:40:12:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:40:12:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|005543|SB |001 03-06-2025 12:40:12:Validation Account Proce Executed with out error Y 03-06-2025 12:40:12:Connection Establisment started 03-06-2025 12:40:12:Connection Successfully Opened : Status OK 03-06-2025 12:40:12:Connection Read From File : Status OK 03-06-2025 12:40:12:CBS A/C No : 001001004009 03-06-2025 12: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 03-06-2025 12:40:12:Record Count : 1 03-06-2025 12:40:12:BRLENGTH 3 03-06-2025 12:40:12:SCHLENGTH 3 03-06-2025 12:40:12:ACLENGTH 6 03-06-2025 12:40:12:Branch Code 3 03-06-2025 12:40:12:Scheme Code 3 03-06-2025 12:40:12:Account No 3 03-06-2025 12:40:12:Link Main Started 03-06-2025 12:40:12:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:40:12:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:40:12:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|004009|SB |001 03-06-2025 12:40:12:Vno --->:67675 03-06-2025 12:40:12:Connection Successfully Opened : Status OK 03-06-2025 12:40:12:ValidateAcNo CBS A/C No : 001001009761 03-06-2025 12:40:12:CBS A/C No : 001001009761 03-06-2025 12: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 03-06-2025 12:40:12:Current Date --->:03-06-2025 03-06-2025 12:40:12:Record Count : 1 03-06-2025 12:40:12:BRLENGTH 3 03-06-2025 12:40:12:SCHLENGTH 3 03-06-2025 12:40:12:ACLENGTH 6 03-06-2025 12:40:12:Branch Code 3 03-06-2025 12:40:12:Scheme Code 3 03-06-2025 12:40:12:Account No 3 03-06-2025 12:40:12:Link Main Started 03-06-2025 12:40:12:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:40:12:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:40:12:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|009761|SB |001 03-06-2025 12:40:12:Validation Account Proce Executed with out error Y 03-06-2025 12:40:12:Connection Establisment started 03-06-2025 12:40:12:Connection Read From File : Status OK 03-06-2025 12:40:12:Connection Successfully Opened : Status OK 03-06-2025 12:40:12:CBS A/C No : 001001009761 03-06-2025 12: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 03-06-2025 12:40:12:Record Count : 1 03-06-2025 12:40:12:BRLENGTH 3 03-06-2025 12:40:12:SCHLENGTH 3 03-06-2025 12:40:12:ACLENGTH 6 03-06-2025 12:40:12:Branch Code 3 03-06-2025 12:40:12:Scheme Code 3 03-06-2025 12:40:12:Account No 3 03-06-2025 12:40:12:Link Main Started 03-06-2025 12:40:12:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:40:12:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:40:12:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|009761|SB |001 03-06-2025 12:40:12:Vno --->:67676 03-06-2025 12:40:12:Current Date --->:03-06-2025 03-06-2025 12:40:12:calling CallNewRtgsBothProc 03-06-2025 12:40:12:Parameters passing - InwardAuthorise 03-06-2025 12:40:12: brn =001 03-06-2025 12:40:12: acno =013800 03-06-2025 12:40:12: abbr =SB 03-06-2025 12:40:12: amt.ToString() =1500 03-06-2025 12:40:12: traceNo =67674 03-06-2025 12:40:12: narr =NEFT, BY PHONEPE PRIVATE LIMITED-PAYMENT AGGREGATOR ESCROW ACCOUNT UTIB0001506 922020004688715 03-06-2025 12:40:12:calling CallNewRtgsBothProc 03-06-2025 12:40:12:Parameters passing - InwardAuthorise 03-06-2025 12:40:12: brn =001 03-06-2025 12:40:12: acno =009761 03-06-2025 12:40:12: abbr =SB 03-06-2025 12:40:12: amt.ToString() =240 03-06-2025 12:40:12: traceNo =67676 03-06-2025 12:40:12: narr =NEFT, BY ONE 97 COMMUNICATIONS LIMITED ESCROW ACCOUNT _01 UTIB0000022 924020007330961 03-06-2025 12:40:12:Transaction Process : BEFORE CAL PROC: 03-06-2025 12:40:12:Connection Successfully Opened : Status OK 03-06-2025 12:40:12:CBS A/C No : 001001005543 03-06-2025 12: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 03-06-2025 12:40:12:Record Count : 1 03-06-2025 12:40:12:BRLENGTH 3 03-06-2025 12:40:12:SCHLENGTH 3 03-06-2025 12:40:12:ACLENGTH 6 03-06-2025 12:40:12:Branch Code 3 03-06-2025 12:40:12:Scheme Code 3 03-06-2025 12:40:12:Account No 3 03-06-2025 12:40:12:Link Main Started 03-06-2025 12:40:12:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:40:12:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:40:12:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|005543|SB |001 03-06-2025 12:40:12:Vno --->:67677 03-06-2025 12:40:12:Current Date --->:03-06-2025 03-06-2025 12:40:12:System.IO.IOException: The process cannot access the file 'D:\IISPL\RTGSInward\SSLWCFSSK\log\2025-06-03T124012_RtgsNeftLog.txt' because it is being used by another process. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileStream.Init(String path, FileMode mode, FileAccess access, Int32 rights, Boolean useRights, FileShare share, Int32 bufferSize, FileOptions options, SECURITY_ATTRIBUTES secAttrs, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost) at System.IO.FileStream..ctor(String path, FileMode mode, FileAccess access, FileShare share, Int32 bufferSize, FileOptions options, String msgPath, Boolean bFromProxy, Boolean useLongPath, Boolean checkHost) at System.IO.StreamWriter.CreateFile(String path, Boolean append, Boolean checkHost) at System.IO.StreamWriter..ctor(String path, Boolean append, Encoding encoding, Int32 bufferSize, Boolean checkHost) at System.IO.StreamWriter..ctor(String path, Boolean append) at SSLWCF.ProcessLog.WriteLog(String logMessage) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\ProcessLog.cs:line 25 at SSLWCF.TranProcess.CallNewRtgsBothProc(String brn, String acno, String abbr, String amt, String traceNo, String narr, String InOut, String UserBrn, String gUserId) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 363 03-06-2025 12:40:12:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN15487612707|001001001671 --------------------------> 03-06-2025 12:40:12:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:40:12:Connection Establisment started 03-06-2025 12:40:12:Connection Read From File : Status OK 03-06-2025 12:40:12:cbs no--->001001009761 03-06-2025 12:40:12:CBS A/C No : 001001009761 03-06-2025 12: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 03-06-2025 12:40:12:Record Count : 1 03-06-2025 12:40:12:BRLENGTH 3 03-06-2025 12:40:12:SCHLENGTH 3 03-06-2025 12:40:12:ACLENGTH 6 03-06-2025 12:40:12:Branch Code 3 03-06-2025 12:40:12:Scheme Code 3 03-06-2025 12:40:12:Account No 3 03-06-2025 12:40:12:Link Main Started 03-06-2025 12:40:12:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:40:12:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:40:12:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|009761|SB |001 03-06-2025 12:40:12:Closed YN quier --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG,DSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,depositmaster,depositschemesetup,ADDRESS where CLMS_SNO=DEPM_CLIENT AND DSCH_BRANCH = DEPM_BRANCH AND DSCH_ABBR = DEPM_ABBR and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB' AND DEPM_NO=009761 AND ADDR_SNO=CLMS_ADDRESS union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG,LSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,LOANMASTER,LOANSCHEMESETUP,ADDRESS where CLMS_SNO=LOAM_CLIENT AND LSCH_BRANCH = LOAM_BRANCH AND LSCH_ABBREV = LOAM_ABBR and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='SB' AND LOAM_NO=009761 AND ADDR_SNO=CLMS_ADDRESS UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG,ODST_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,ODMASTER,ODSCHEMESETUP,ADDRESS where CLMS_SNO=ODMT_CLIENT AND ODST_BRANCH = ODMT_BRANCH AND ODST_ABBR = ODMT_ABBR and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='SB' AND ODMT_NO=009761 AND ADDR_SNO=CLMS_ADDRESS 03-06-2025 12:40:12:calling CallNewRtgsBothProc 03-06-2025 12:40:12:Parameters passing - InwardAuthorise 03-06-2025 12:40:12: brn =001 03-06-2025 12:40:12: acno =005543 03-06-2025 12:40:12: abbr =SB 03-06-2025 12:40:12: amt.ToString() =820 03-06-2025 12:40:12: traceNo =67677 03-06-2025 12:40:12: narr =NEFT, BY PHONEPE PRIVATE LIMITED-PAYMENT AGGREGATOR ESCROW ACCOUNT UTIB0001506 922020004688715 03-06-2025 12:40:12:Transaction Process : BEFORE CAL PROC: 03-06-2025 12:40:12:closed y n Record count --->1 03-06-2025 12:40:12:Connection Successfully Opened : Status OK 03-06-2025 12:40:12:ValidateAcNo CBS A/C No : 001001001671 03-06-2025 12:40:12:CBS A/C No : 001001001671 03-06-2025 12: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 03-06-2025 12:40:12:Record Count : 1 03-06-2025 12:40:12:BRLENGTH 3 03-06-2025 12:40:12:SCHLENGTH 3 03-06-2025 12:40:12:ACLENGTH 6 03-06-2025 12:40:12:Branch Code 3 03-06-2025 12:40:12:Scheme Code 3 03-06-2025 12:40:12:Account No 3 03-06-2025 12:40:12:Link Main Started 03-06-2025 12:40:12:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:40:12:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:40:12:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001671|SB |001 03-06-2025 12:40:12:Validation Account Proce Executed with out error Y 03-06-2025 12:40:12:Connection Establisment started 03-06-2025 12:40:12:Connection Read From File : Status OK 03-06-2025 12:40:12:Connection Successfully Opened : Status OK 03-06-2025 12:40:12:CBS A/C No : 001001001671 03-06-2025 12: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 03-06-2025 12:40:12:Record Count : 1 03-06-2025 12:40:12:BRLENGTH 3 03-06-2025 12:40:12:SCHLENGTH 3 03-06-2025 12:40:12:ACLENGTH 6 03-06-2025 12:40:12:Branch Code 3 03-06-2025 12:40:12:Scheme Code 3 03-06-2025 12:40:12:Account No 3 03-06-2025 12:40:12:Link Main Started 03-06-2025 12:40:12:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:40:12:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:40:12:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001671|SB |001 03-06-2025 12:40:12:cbs no--->001001013800 03-06-2025 12:40:12:CBS A/C No : 001001013800 03-06-2025 12: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 03-06-2025 12:40:12:Record Count : 1 03-06-2025 12:40:12:BRLENGTH 3 03-06-2025 12:40:12:SCHLENGTH 3 03-06-2025 12:40:12:ACLENGTH 6 03-06-2025 12:40:12:Branch Code 3 03-06-2025 12:40:12:Scheme Code 3 03-06-2025 12:40:12:Account No 3 03-06-2025 12:40:12:Link Main Started 03-06-2025 12:40:12:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:40:12:Vno --->:67678 03-06-2025 12:40:12:Current Date --->:03-06-2025 03-06-2025 12:40:12:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:40:12:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN15487612718|002002000012 --------------------------> 03-06-2025 12:40:12:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:40:12:Connection Establisment started 03-06-2025 12:40:12:Connection Read From File : Status OK 03-06-2025 12:40:12:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|013800|SB |001 03-06-2025 12:40:12: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=013800 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=013800 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=013800 AND ADDR_SNO=CLMS_ADDRESS 03-06-2025 12:40:12:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN15487614577|001001003670 --------------------------> 03-06-2025 12:40:12:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:40:12:Connection Establisment started 03-06-2025 12:40:12:Connection Read From File : Status OK 03-06-2025 12:40:12:calling CallNewRtgsBothProc 03-06-2025 12:40:12:Parameters passing - InwardAuthorise 03-06-2025 12:40:12: brn =001 03-06-2025 12:40:12: acno =001671 03-06-2025 12:40:12: abbr =SB 03-06-2025 12:40:12: amt.ToString() =124.98 03-06-2025 12:40:12: traceNo =67678 03-06-2025 12:40:12: narr =NEFT, BY PHONEPE PRIVATE LIMITED-PAYMENT AGGREGATOR ESCROW ACCOUNT UTIB0001506 922020004688715 03-06-2025 12:40:12:Transaction Process : BEFORE CAL PROC: 03-06-2025 12:40:12:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM15487621793|001001013099 --------------------------> 03-06-2025 12:40:12:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:40:12:Connection Establisment started 03-06-2025 12:40:12:Connection Read From File : Status OK 03-06-2025 12:40:12:closed y n Record count --->1 03-06-2025 12:40:12:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN15487612702|001022000083 --------------------------> 03-06-2025 12:40:12:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:40:12:Connection Establisment started 03-06-2025 12:40:12:SMS Inserted for Mobile Number : +919964401589 03-06-2025 12:40:12:SMS Inserted for Mobile Number : +917899199652 03-06-2025 12:40:12:cbs no--->001001005543 03-06-2025 12:40:12:CBS A/C No : 001001005543 03-06-2025 12: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 03-06-2025 12:40:12:Record Count : 1 03-06-2025 12:40:12:BRLENGTH 3 03-06-2025 12:40:12:SCHLENGTH 3 03-06-2025 12:40:12:ACLENGTH 6 03-06-2025 12:40:12:Branch Code 3 03-06-2025 12:40:12:Scheme Code 3 03-06-2025 12:40:12:Account No 3 03-06-2025 12:40:12:Link Main Started 03-06-2025 12:40:12:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:40:12:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:40:12:Connection Successfully Opened : Status OK 03-06-2025 12:40:12:ValidateAcNo CBS A/C No : 002002000012 03-06-2025 12:40:12:CBS A/C No : 002002000012 03-06-2025 12: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 03-06-2025 12:40:12:Record Count : 1 03-06-2025 12:40:12:BRLENGTH 3 03-06-2025 12:40:12:SCHLENGTH 3 03-06-2025 12:40:12:ACLENGTH 6 03-06-2025 12:40:12:Branch Code 3 03-06-2025 12:40:12:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|005543|SB |001 03-06-2025 12:40:12: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 03-06-2025 12:40:12:Account No 3 03-06-2025 12:40:12:Link Main Started 03-06-2025 12: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 03-06-2025 12:40:12:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 002 03-06-2025 12:40:12:ShowCBS Ac No Proce Executed BARDANSAL|DEPOSIT|000012|CD |002 03-06-2025 12:40:12:Inward Process Executed Sussefully 03-06-2025 12:40:12:ConfirmationReq Execution Success with Status 000 03-06-2025 12:40:12:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN15487612704|001001004009 ------------------------------> 03-06-2025 12:40:12:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:40:12:Validation Account Proce Executed with out error Y 03-06-2025 12:40:12:Connection Establisment started 03-06-2025 12:40:12:Connection Successfully Opened : Status OK 03-06-2025 12:40:12:ValidateAcNo CBS A/C No : 001001013099 03-06-2025 12:40:12:CBS A/C No : 001001013099 03-06-2025 12: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 03-06-2025 12:40:12:Record Count : 1 03-06-2025 12:40:12:BRLENGTH 3 03-06-2025 12:40:12:SCHLENGTH 3 03-06-2025 12:40:12:ACLENGTH 6 03-06-2025 12:40:12:Branch Code 3 03-06-2025 12:40:12:Scheme Code 3 03-06-2025 12:40:12:Account No 3 03-06-2025 12:40:12:Link Main Started 03-06-2025 12:40:12:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:40:12:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:40:12:closed y n Record count --->1 03-06-2025 12:40:12:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : FBBT251540852639|001002000868 --------------------------> 03-06-2025 12:40:12:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:40:12:Connection Establisment started 03-06-2025 12:40:12:Connection Read From File : Status OK 03-06-2025 12:40:12:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|013099|SB |001 03-06-2025 12:40:12:Validation Account Proce Executed with out error Y 03-06-2025 12:40:12:Connection Establisment started 03-06-2025 12:40:12:Connection Successfully Opened : Status OK 03-06-2025 12:40:12:Connection Read From File : Status OK 03-06-2025 12:40:12:ValidateAcNo CBS A/C No : 001022000083 03-06-2025 12:40:12:CBS A/C No : 001022000083 03-06-2025 12: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 03-06-2025 12:40:12:Record Count : 1 03-06-2025 12:40:12:BRLENGTH 3 03-06-2025 12:40:12:SCHLENGTH 3 03-06-2025 12:40:12:ACLENGTH 6 03-06-2025 12:40:12:Branch Code 3 03-06-2025 12:40:12:Scheme Code 3 03-06-2025 12:40:12:Account No 3 03-06-2025 12:40:12:Link Main Started 03-06-2025 12:40:12:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 022 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:40:12:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:40:12:ShowCBS Ac No Proce Executed HEAD OFFICE|OD|000083|OD |001 03-06-2025 12:40:13:cbs no--->001001001671 03-06-2025 12:40:13:CBS A/C No : 001001001671 03-06-2025 12: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 03-06-2025 12:40:13:Record Count : 1 03-06-2025 12:40:13:BRLENGTH 3 03-06-2025 12:40:13:SCHLENGTH 3 03-06-2025 12:40:13:ACLENGTH 6 03-06-2025 12:40:13:Branch Code 3 03-06-2025 12:40:13:Scheme Code 3 03-06-2025 12:40:13:Account No 3 03-06-2025 12:40:13:Link Main Started 03-06-2025 12:40:13:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:40:13:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:40:13:Validation Account Proce Executed with out error Y 03-06-2025 12:40:13:Connection Establisment started 03-06-2025 12:40:13:Connection Successfully Opened : Status OK 03-06-2025 12:40:13:Connection Read From File : Status OK 03-06-2025 12:40:13:CBS A/C No : 002002000012 03-06-2025 12: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 03-06-2025 12:40:13:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001671|SB |001 03-06-2025 12: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=001 and TRIM(DEPM_ABBR)='SB' AND DEPM_NO=001671 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=001671 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=001671 AND ADDR_SNO=CLMS_ADDRESS 03-06-2025 12:40:13:Record Count : 1 03-06-2025 12:40:13:BRLENGTH 3 03-06-2025 12:40:13:SCHLENGTH 3 03-06-2025 12:40:13:ACLENGTH 6 03-06-2025 12:40:13:Branch Code 3 03-06-2025 12:40:13:Scheme Code 3 03-06-2025 12:40:13:Account No 3 03-06-2025 12:40:13:Link Main Started 03-06-2025 12: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 03-06-2025 12:40:13:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 002 03-06-2025 12:40:13:ShowCBS Ac No Proce Executed BARDANSAL|DEPOSIT|000012|CD |002 03-06-2025 12:40:13:Vno --->:67679 03-06-2025 12:40:13:Current Date --->:03-06-2025 03-06-2025 12:40:13:Connection Successfully Opened : Status OK 03-06-2025 12:40:13:ValidateAcNo CBS A/C No : 001001003670 03-06-2025 12:40:13:CBS A/C No : 001001003670 03-06-2025 12: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 03-06-2025 12:40:13:Record Count : 1 03-06-2025 12:40:13:BRLENGTH 3 03-06-2025 12:40:13:SCHLENGTH 3 03-06-2025 12:40:13:calling CallNewRtgsBothProc 03-06-2025 12:40:13:Parameters passing - InwardAuthorise 03-06-2025 12:40:13: brn =002 03-06-2025 12:40:13:Branch Code 3 03-06-2025 12:40:13:Scheme Code 3 03-06-2025 12:40:13: abbr =CD 03-06-2025 12:40:13: amt.ToString() =7735 03-06-2025 12:40:13: traceNo =67679 03-06-2025 12:40:13: narr =NEFT, BY PHONEPE PRIVATE LIMITED-PAYMENT AGGREGATOR ESCROW ACCOUNT UTIB0001506 922020004688715 03-06-2025 12:40:13:Link Main Started 03-06-2025 12:40:13:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:40:13:closed y n Record count --->1 03-06-2025 12:40:13:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:40:13:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|003670|SB |001 03-06-2025 12:40:13:Validation Account Proce Executed with out error Y 03-06-2025 12:40:13:Connection Establisment started 03-06-2025 12:40:13:Connection Successfully Opened : Status OK 03-06-2025 12:40:13:Connection Read From File : Status OK 03-06-2025 12:40:13:CBS A/C No : 001001013099 03-06-2025 12: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 03-06-2025 12:40:13:Record Count : 1 03-06-2025 12:40:13:BRLENGTH 3 03-06-2025 12:40:13:SCHLENGTH 3 03-06-2025 12:40:13:ACLENGTH 6 03-06-2025 12:40:13:Branch Code 3 03-06-2025 12:40:13:Scheme Code 3 03-06-2025 12:40:13:Account No 3 03-06-2025 12:40:13:Link Main Started 03-06-2025 12:40:13:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:40:13:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:40:13:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|013099|SB |001 03-06-2025 12:40:13:Vno --->:67680 03-06-2025 12:40:13:Current Date --->:03-06-2025 03-06-2025 12:40:13:calling CallNewRtgsBothProc 03-06-2025 12:40:13:Parameters passing - InwardAuthorise 03-06-2025 12:40:13: brn =001 03-06-2025 12:40:13: acno =013099 03-06-2025 12:40:13: abbr =SB 03-06-2025 12:40:13: amt.ToString() =10 03-06-2025 12:40:13: traceNo =67680 03-06-2025 12:40:13: narr =NEFT, BY ONE 97 COMMUNICATIONS LIMITED ESCROW ACCOUNT _01 UTIB0000022 924020007330961 03-06-2025 12:40:13:Transaction Process : BEFORE CAL PROC: 03-06-2025 12:40:13:Connection Successfully Opened : Status OK 03-06-2025 12:40:13:ValidateAcNo CBS A/C No : 001002000868 03-06-2025 12:40:13:CBS A/C No : 001002000868 03-06-2025 12: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 03-06-2025 12:40:13:Record Count : 1 03-06-2025 12:40:13:BRLENGTH 3 03-06-2025 12:40:13:SCHLENGTH 3 03-06-2025 12:40:13:ACLENGTH 6 03-06-2025 12:40:13:Branch Code 3 03-06-2025 12:40:13:Scheme Code 3 03-06-2025 12:40:13:Account No 3 03-06-2025 12:40:13:Link Main Started 03-06-2025 12: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 03-06-2025 12:40:13:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:40:13:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000868|CD |001 03-06-2025 12:40:13:Validation Account Proce Executed with out error Y 03-06-2025 12:40:13:Connection Establisment started 03-06-2025 12:40:13:Connection Successfully Opened : Status OK 03-06-2025 12:40:13:CBS A/C No : 001001003670 03-06-2025 12: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 03-06-2025 12:40:13:Record Count : 1 03-06-2025 12:40:13:BRLENGTH 3 03-06-2025 12:40:13:SCHLENGTH 3 03-06-2025 12:40:13:ACLENGTH 6 03-06-2025 12:40:13:Branch Code 3 03-06-2025 12:40:13:Scheme Code 3 03-06-2025 12:40:13:Account No 3 03-06-2025 12:40:13:Link Main Started 03-06-2025 12:40:13:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:40:13:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:40:13:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|003670|SB |001 03-06-2025 12:40:13:Vno --->:67681 03-06-2025 12:40:13:Current Date --->:03-06-2025 03-06-2025 12:40:13:cbs no--->001001013099 03-06-2025 12:40:13:CBS A/C No : 001001013099 03-06-2025 12: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 03-06-2025 12:40:13:calling CallNewRtgsBothProc 03-06-2025 12:40:13:Parameters passing - InwardAuthorise 03-06-2025 12:40:13: brn =001 03-06-2025 12:40:13: acno =003670 03-06-2025 12:40:13: abbr =SB 03-06-2025 12:40:13: amt.ToString() =125 03-06-2025 12:40:13: traceNo =67681 03-06-2025 12:40:13: narr =NEFT, BY PHONEPE PRIVATE LIMITED-PAYMENT AGGREGATOR ESCROW ACCOUNT UTIB0001506 922020004688715 03-06-2025 12:40:13:Transaction Process : BEFORE CAL PROC: 03-06-2025 12:40:13:Record Count : 1 03-06-2025 12:40:13:BRLENGTH 3 03-06-2025 12:40:13:SCHLENGTH 3 03-06-2025 12:40:13:ACLENGTH 6 03-06-2025 12:40:13:Branch Code 3 03-06-2025 12:40:13:Scheme Code 3 03-06-2025 12:40:13:Account No 3 03-06-2025 12:40:13:Link Main Started 03-06-2025 12:40:13:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:40:13:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:40:13:Inward Process Executed Sussefully 03-06-2025 12:40:13:ConfirmationReq Execution Success with Status 000 03-06-2025 12:40:13:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN15487614576|001001013800 ------------------------------> 03-06-2025 12:40:13:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:40:13:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|013099|SB |001 03-06-2025 12: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=001 and TRIM(DEPM_ABBR)='SB' AND DEPM_NO=013099 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=013099 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=013099 AND ADDR_SNO=CLMS_ADDRESS 03-06-2025 12:40:13:Inward Process Executed Sussefully 03-06-2025 12:40:13:ConfirmationReq Execution Success with Status 000 03-06-2025 12:40:13:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM15487621819|001001009761 ------------------------------> 03-06-2025 12:40:13:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:40:13:cbs no--->001001003670 03-06-2025 12:40:13:CBS A/C No : 001001003670 03-06-2025 12: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 03-06-2025 12:40:13:Record Count : 1 03-06-2025 12:40:13:BRLENGTH 3 03-06-2025 12:40:13:SCHLENGTH 3 03-06-2025 12:40:13:ACLENGTH 6 03-06-2025 12:40:13:Branch Code 3 03-06-2025 12:40:13:Scheme Code 3 03-06-2025 12:40:13:Account No 3 03-06-2025 12:40:13:Link Main Started 03-06-2025 12:40:13:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:40:13:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:40:13:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|003670|SB |001 03-06-2025 12: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=001 and TRIM(DEPM_ABBR)='SB' AND DEPM_NO=003670 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=003670 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=003670 AND ADDR_SNO=CLMS_ADDRESS 03-06-2025 12:40:13:closed y n Record count --->1 03-06-2025 12:40:13:Connection Successfully Opened : Status OK 03-06-2025 12:40:13:CBS A/C No : 001022000083 03-06-2025 12: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 03-06-2025 12:40:13:Record Count : 1 03-06-2025 12:40:13:BRLENGTH 3 03-06-2025 12:40:13:SCHLENGTH 3 03-06-2025 12:40:13:ACLENGTH 6 03-06-2025 12:40:13:Branch Code 3 03-06-2025 12:40:13:Scheme Code 3 03-06-2025 12:40:13:Account No 3 03-06-2025 12:40:13:Link Main Started 03-06-2025 12:40:13:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 022 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:40:13:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:40:13:closed y n Record count --->1 03-06-2025 12:40:13:ShowCBS Ac No Proce Executed HEAD OFFICE|OD|000083|OD |001 03-06-2025 12:40:13:Vno --->:67682 03-06-2025 12:40:13:Current Date --->:03-06-2025 03-06-2025 12:40:13:cbs no--->002002000012 03-06-2025 12:40:13:CBS A/C No : 002002000012 03-06-2025 12: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 03-06-2025 12:40:13:calling CallNewRtgsBothProc 03-06-2025 12:40:13:Parameters passing - InwardAuthorise 03-06-2025 12:40:13: brn =001 03-06-2025 12:40:13: acno =000083 03-06-2025 12:40:13: abbr =OD 03-06-2025 12:40:13: amt.ToString() =19146 03-06-2025 12:40:13: traceNo =67682 03-06-2025 12:40:13: narr =NEFT, BY PHONEPE PRIVATE LIMITED-PAYMENT AGGREGATOR ESCROW ACCOUNT UTIB0001506 922020004688715 03-06-2025 12:40:13:Transaction Process : BEFORE CAL PROC: 03-06-2025 12:40:13:BRLENGTH 3 03-06-2025 12:40:13:SCHLENGTH 3 03-06-2025 12:40:13:ACLENGTH 6 03-06-2025 12:40:13:Branch Code 3 03-06-2025 12:40:13:Scheme Code 3 03-06-2025 12:40:13:Account No 3 03-06-2025 12:40:13:Link Main Started 03-06-2025 12: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 03-06-2025 12:40:13:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 002 03-06-2025 12:40:13:ShowCBS Ac No Proce Executed BARDANSAL|DEPOSIT|000012|CD |002 03-06-2025 12: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=000012 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=000012 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=000012 AND ADDR_SNO=CLMS_ADDRESS 03-06-2025 12:40:13:SMS Inserted for Mobile Number : +918904258948 03-06-2025 12:40:13:closed y n Record count --->1 03-06-2025 12:40:13:SMS Inserted for Mobile Number : +916362093924 03-06-2025 12:40:13:cbs no--->001022000083 03-06-2025 12:40:13:CBS A/C No : 001022000083 03-06-2025 12: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 03-06-2025 12:40:13:Record Count : 1 03-06-2025 12:40:13:BRLENGTH 3 03-06-2025 12:40:13:SCHLENGTH 3 03-06-2025 12:40:13:ACLENGTH 6 03-06-2025 12:40:13:Branch Code 3 03-06-2025 12:40:13:Scheme Code 3 03-06-2025 12:40:13:Account No 3 03-06-2025 12:40:13:Link Main Started 03-06-2025 12:40:13:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 022 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:40:13:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:40:13:ShowCBS Ac No Proce Executed HEAD OFFICE|OD|000083|OD |001 03-06-2025 12: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=001 and TRIM(DEPM_ABBR)='OD' AND DEPM_NO=000083 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=000083 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=000083 AND ADDR_SNO=CLMS_ADDRESS 03-06-2025 12:40:13:closed y n Record count --->1 03-06-2025 12:40:13:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN15487612703|001001003013 --------------------------> 03-06-2025 12:40:13:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:40:13:Connection Establisment started 03-06-2025 12:40:13:Connection Read From File : Status OK 03-06-2025 12:40:13:Inward Process Executed Sussefully 03-06-2025 12:40:13:ConfirmationReq Execution Success with Status 000 03-06-2025 12:40:13:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN15487612717|001001005543 ------------------------------> 03-06-2025 12:40:13:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:40:13:SMS Inserted for Mobile Number : +919886671196 03-06-2025 12:40:13:Connection Successfully Opened : Status OK 03-06-2025 12:40:13:CBS A/C No : 001002000868 03-06-2025 12: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 03-06-2025 12:40:13:Record Count : 1 03-06-2025 12:40:13:BRLENGTH 3 03-06-2025 12:40:13:SCHLENGTH 3 03-06-2025 12:40:13:ACLENGTH 6 03-06-2025 12:40:13:Branch Code 3 03-06-2025 12:40:13:Scheme Code 3 03-06-2025 12:40:13:Account No 3 03-06-2025 12:40:13:Link Main Started 03-06-2025 12: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 03-06-2025 12:40:13:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:40:13:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000868|CD |001 03-06-2025 12:40:13:SMS Inserted for Mobile Number : +919448453402 03-06-2025 12:40:13:Vno --->:67683 03-06-2025 12:40:13:Current Date --->:03-06-2025 03-06-2025 12:40:13:calling CallNewRtgsBothProc 03-06-2025 12:40:13:Parameters passing - InwardAuthorise 03-06-2025 12:40:13: brn =001 03-06-2025 12:40:13: acno =000868 03-06-2025 12:40:13: abbr =CD 03-06-2025 12:40:13: amt.ToString() =34793 03-06-2025 12:40:13: traceNo =67683 03-06-2025 12:40:13: narr =NEFT, BY ISHAN MOTORS FDRL0009993 15070200001606 03-06-2025 12:40:13:Transaction Process : BEFORE CAL PROC: 03-06-2025 12:40:13:SMS Inserted for Mobile Number : +919480027319 03-06-2025 12:40:13:Connection Successfully Opened : Status OK 03-06-2025 12:40:13:ValidateAcNo CBS A/C No : 001001003013 03-06-2025 12:40:13:CBS A/C No : 001001003013 03-06-2025 12: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 03-06-2025 12:40:13:Inward Process Executed Sussefully 03-06-2025 12:40:13:ConfirmationReq Execution Success with Status 000 03-06-2025 12:40:13:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN15487614577|001001003670 ------------------------------> 03-06-2025 12:40:13:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:40:13:Record Count : 1 03-06-2025 12:40:13:BRLENGTH 3 03-06-2025 12:40:13:SCHLENGTH 3 03-06-2025 12:40:13:ACLENGTH 6 03-06-2025 12:40:13:Branch Code 3 03-06-2025 12:40:13:Scheme Code 3 03-06-2025 12:40:13:Account No 3 03-06-2025 12:40:13:Link Main Started 03-06-2025 12:40:13:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:40:13:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:40:13:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|003013|SB |001 03-06-2025 12:40:13:Validation Account Proce Executed with out error Y 03-06-2025 12:40:13:Connection Establisment started 03-06-2025 12:40:13:Connection Read From File : Status OK 03-06-2025 12:40:13:Connection Successfully Opened : Status OK 03-06-2025 12:40:13:CBS A/C No : 001001003013 03-06-2025 12: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 03-06-2025 12:40:13:Inward Process Executed Sussefully 03-06-2025 12:40:13:ConfirmationReq Execution Success with Status 000 03-06-2025 12:40:13:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM15487621793|001001013099 ------------------------------> 03-06-2025 12:40:13:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:40:13:Record Count : 1 03-06-2025 12:40:13:BRLENGTH 3 03-06-2025 12:40:13:SCHLENGTH 3 03-06-2025 12:40:13:ACLENGTH 6 03-06-2025 12:40:13:Branch Code 3 03-06-2025 12:40:13:Scheme Code 3 03-06-2025 12:40:13:Account No 3 03-06-2025 12:40:13:Link Main Started 03-06-2025 12:40:13:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:40:13:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:40:13:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|003013|SB |001 03-06-2025 12:40:13:Vno --->:67684 03-06-2025 12:40:13:Current Date --->:03-06-2025 03-06-2025 12:40:13:calling CallNewRtgsBothProc 03-06-2025 12:40:13:Parameters passing - InwardAuthorise 03-06-2025 12:40:13: brn =001 03-06-2025 12:40:13: acno =003013 03-06-2025 12:40:13: abbr =SB 03-06-2025 12:40:13: amt.ToString() =333 03-06-2025 12:40:13: traceNo =67684 03-06-2025 12:40:13: narr =NEFT, BY PHONEPE PRIVATE LIMITED-PAYMENT AGGREGATOR ESCROW ACCOUNT UTIB0001506 922020004688715 03-06-2025 12:40:13:Transaction Process : BEFORE CAL PROC: 03-06-2025 12:40:13:cbs no--->001002000868 03-06-2025 12:40:13:CBS A/C No : 001002000868 03-06-2025 12: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 03-06-2025 12:40:13:Record Count : 1 03-06-2025 12:40:13:BRLENGTH 3 03-06-2025 12:40:13:SCHLENGTH 3 03-06-2025 12:40:13:ACLENGTH 6 03-06-2025 12:40:13:Branch Code 3 03-06-2025 12:40:13:Scheme Code 3 03-06-2025 12:40:13:Account No 3 03-06-2025 12:40:13:Link Main Started 03-06-2025 12: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 03-06-2025 12:40:13:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:40:13:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000868|CD |001 03-06-2025 12: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=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 03-06-2025 12:40:13:closed y n Record count --->1 03-06-2025 12:40:13:cbs no--->001001003013 03-06-2025 12:40:13:CBS A/C No : 001001003013 03-06-2025 12: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 03-06-2025 12:40:13:Record Count : 1 03-06-2025 12:40:13:BRLENGTH 3 03-06-2025 12:40:13:SCHLENGTH 3 03-06-2025 12:40:13:ACLENGTH 6 03-06-2025 12:40:13:Branch Code 3 03-06-2025 12:40:13:Scheme Code 3 03-06-2025 12:40:13:Account No 3 03-06-2025 12:40:13:Link Main Started 03-06-2025 12:40:13:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:40:13:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:40:13:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|003013|SB |001 03-06-2025 12: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=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 03-06-2025 12:40:13:Inward Process Executed Sussefully 03-06-2025 12:40:13:ConfirmationReq Execution Success with Status 000 03-06-2025 12:40:13:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN15487612702|001022000083 ------------------------------> 03-06-2025 12:40:13:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:40:13:ConfirmationReq Execution Success with Status 000 03-06-2025 12:40:13:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN15487612718|002002000012 ------------------------------> 03-06-2025 12:40:13:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:40:13:ConfirmationReq Execution Success with Status 111 03-06-2025 12:40:13:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN15487612707|001001001671 ------------------------------> 03-06-2025 12:40:13:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:40:13:closed y n Record count --->1 03-06-2025 12:40:13:SMS Inserted for Mobile Number : +919448051124 03-06-2025 12:40:13:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN15487614575|001001012574 --------------------------> 03-06-2025 12:40:13:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:40:13:Connection Establisment started 03-06-2025 12:40:13:Connection Read From File : Status OK 03-06-2025 12:40:13:SMS Inserted for Mobile Number : +919901351118 03-06-2025 12:40:13:Connection Successfully Opened : Status OK 03-06-2025 12:40:13:ValidateAcNo CBS A/C No : 001001012574 03-06-2025 12:40:13:CBS A/C No : 001001012574 03-06-2025 12: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 03-06-2025 12:40:13:Record Count : 1 03-06-2025 12:40:13:BRLENGTH 3 03-06-2025 12:40:13:SCHLENGTH 3 03-06-2025 12:40:13:ACLENGTH 6 03-06-2025 12:40:13:Branch Code 3 03-06-2025 12:40:13:Scheme Code 3 03-06-2025 12:40:13:Account No 3 03-06-2025 12:40:13:Link Main Started 03-06-2025 12:40:13:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:40:13:Inward Process Executed Sussefully 03-06-2025 12:40:13:ConfirmationReq Execution Success with Status 000 03-06-2025 12:40:13:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : FBBT251540852639|001002000868 ------------------------------> 03-06-2025 12:40:13:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:40:13:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:40:13:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|012574|SB |001 03-06-2025 12:40:13:Validation Account Proce Executed with out error Y 03-06-2025 12:40:13:Connection Establisment started 03-06-2025 12:40:13:Connection Read From File : Status OK 03-06-2025 12:40:13:Connection Successfully Opened : Status OK 03-06-2025 12:40:13:CBS A/C No : 001001012574 03-06-2025 12: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 03-06-2025 12:40:13:Record Count : 1 03-06-2025 12:40:13:BRLENGTH 3 03-06-2025 12:40:13:SCHLENGTH 3 03-06-2025 12:40:13:ACLENGTH 6 03-06-2025 12:40:13:Branch Code 3 03-06-2025 12:40:13:Scheme Code 3 03-06-2025 12:40:13:Account No 3 03-06-2025 12:40:13:Link Main Started 03-06-2025 12:40:13:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:40:13:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:40:13:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|012574|SB |001 03-06-2025 12:40:13:Vno --->:67685 03-06-2025 12:40:13:Current Date --->:03-06-2025 03-06-2025 12:40:13:calling CallNewRtgsBothProc 03-06-2025 12:40:13:Parameters passing - InwardAuthorise 03-06-2025 12:40:13: brn =001 03-06-2025 12:40:13: acno =012574 03-06-2025 12:40:13: abbr =SB 03-06-2025 12:40:13: amt.ToString() =560 03-06-2025 12:40:13: traceNo =67685 03-06-2025 12:40:13: narr =NEFT, BY PHONEPE PRIVATE LIMITED-PAYMENT AGGREGATOR ESCROW ACCOUNT UTIB0001506 922020004688715 03-06-2025 12:40:13:Transaction Process : BEFORE CAL PROC: 03-06-2025 12:40:14:cbs no--->001001012574 03-06-2025 12:40:14:CBS A/C No : 001001012574 03-06-2025 12:40:14:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 03-06-2025 12:40:14:Record Count : 1 03-06-2025 12:40:14:BRLENGTH 3 03-06-2025 12:40:14:SCHLENGTH 3 03-06-2025 12:40:14:ACLENGTH 6 03-06-2025 12:40:14:Branch Code 3 03-06-2025 12:40:14:Scheme Code 3 03-06-2025 12:40:14:Account No 3 03-06-2025 12:40:14:Link Main Started 03-06-2025 12:40:14:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 12:40:14:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 12:40:14:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|012574|SB |001 03-06-2025 12:40:14: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=012574 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=012574 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=012574 AND ADDR_SNO=CLMS_ADDRESS 03-06-2025 12:40:14:closed y n Record count --->1 03-06-2025 12:40:14:Inward Process Executed Sussefully 03-06-2025 12:40:14:ConfirmationReq Execution Success with Status 000 03-06-2025 12:40:14:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN15487612703|001001003013 ------------------------------> 03-06-2025 12:40:14:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 12:40:14:SMS Inserted for Mobile Number : +917019984305 03-06-2025 12:40:14:Inward Process Executed Sussefully 03-06-2025 12:40:14:ConfirmationReq Execution Success with Status 000 03-06-2025 12:40:14:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN15487614575|001001012574 ------------------------------> 03-06-2025 12:40:14:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 14:35:26:<------------------------Started ValidationRequest CBS A/C No : 0000001001012615 ------------------------> 03-06-2025 14:35:26:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 14:35:26:Connection Establisment started 03-06-2025 14:35:26:Connection Read From File : Status OK 03-06-2025 14:35:27:Connection Successfully Opened : Status OK 03-06-2025 14:35:27:ValidateAcNo CBS A/C No : 0000001001012615 03-06-2025 14:35:27:Validation Account Proce Executed with out error N 03-06-2025 14:35:27:ValidationRequest Exccution Success with response : 111 03-06-2025 14:35:27:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 14:35:28:<------------------------Started ValidationRequest CBS A/C No : 001001003241 ------------------------> 03-06-2025 14:35:28:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 14:35:28:Connection Establisment started 03-06-2025 14:35:28:Connection Read From File : Status OK 03-06-2025 14:35:28:Connection Successfully Opened : Status OK 03-06-2025 14:35:28:ValidateAcNo CBS A/C No : 001001003241 03-06-2025 14:35:28:CBS A/C No : 001001003241 03-06-2025 14:35:28:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 03-06-2025 14:35:28:Record Count : 1 03-06-2025 14:35:28:BRLENGTH 3 03-06-2025 14:35:28:SCHLENGTH 3 03-06-2025 14:35:28:ACLENGTH 6 03-06-2025 14:35:28:Branch Code 3 03-06-2025 14:35:28:Scheme Code 3 03-06-2025 14:35:28:Account No 3 03-06-2025 14:35:28:Link Main Started 03-06-2025 14:35:28:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 14:35:28:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 14:35:28:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|003241|SB |001 03-06-2025 14:35:28:Validation Account Proce Executed with out error Y 03-06-2025 14:35:28:ValidationRequest Exccution Success with response : 000 03-06-2025 14:35:28:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 14:35:29:<------------------------Started ValidationRequest CBS A/C No : 001001001118 ------------------------> 03-06-2025 14:35:29:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 14:35:29:Connection Establisment started 03-06-2025 14:35:29:Connection Read From File : Status OK 03-06-2025 14:35:29:Connection Successfully Opened : Status OK 03-06-2025 14:35:29:ValidateAcNo CBS A/C No : 001001001118 03-06-2025 14:35:29:CBS A/C No : 001001001118 03-06-2025 14:35:29:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 03-06-2025 14:35:29:Record Count : 1 03-06-2025 14:35:29:BRLENGTH 3 03-06-2025 14:35:29:SCHLENGTH 3 03-06-2025 14:35:29:ACLENGTH 6 03-06-2025 14:35:29:Branch Code 3 03-06-2025 14:35:29:Scheme Code 3 03-06-2025 14:35:29:Account No 3 03-06-2025 14:35:29:Link Main Started 03-06-2025 14:35:29:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 14:35:29:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 14:35:29:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001118|SB |001 03-06-2025 14:35:29:Validation Account Proce Executed with out error Y 03-06-2025 14:35:29:ValidationRequest Exccution Success with response : 000 03-06-2025 14:35:29:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 14:35:33:<------------------------Started ValidationRequest CBS A/C No : 001001011946 ------------------------> 03-06-2025 14:35:33:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 14:35:33:Connection Establisment started 03-06-2025 14:35:33:Connection Read From File : Status OK 03-06-2025 14:35:33:Connection Successfully Opened : Status OK 03-06-2025 14:35:33:ValidateAcNo CBS A/C No : 001001011946 03-06-2025 14:35:33:CBS A/C No : 001001011946 03-06-2025 14: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 03-06-2025 14:35:33:Record Count : 1 03-06-2025 14:35:33:BRLENGTH 3 03-06-2025 14:35:33:SCHLENGTH 3 03-06-2025 14:35:33:ACLENGTH 6 03-06-2025 14:35:33:Branch Code 3 03-06-2025 14:35:33:Scheme Code 3 03-06-2025 14:35:33:Account No 3 03-06-2025 14:35:33:Link Main Started 03-06-2025 14: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 03-06-2025 14:35:33:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 14:35:33:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|011946|SB |001 03-06-2025 14:35:33:Validation Account Proce Executed with out error Y 03-06-2025 14:35:33:ValidationRequest Exccution Success with response : 000 03-06-2025 14:35:33:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 14:35:37:<------------------------Started ValidationRequest CBS A/C No : 001001012956 ------------------------> 03-06-2025 14:35:37:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 14:35:37:Connection Establisment started 03-06-2025 14:35:37:Connection Read From File : Status OK 03-06-2025 14:35:37:Connection Successfully Opened : Status OK 03-06-2025 14:35:37:ValidateAcNo CBS A/C No : 001001012956 03-06-2025 14:35:37:CBS A/C No : 001001012956 03-06-2025 14:35:37:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 03-06-2025 14:35:37:Record Count : 1 03-06-2025 14:35:37:BRLENGTH 3 03-06-2025 14:35:37:SCHLENGTH 3 03-06-2025 14:35:37:ACLENGTH 6 03-06-2025 14:35:37:Branch Code 3 03-06-2025 14:35:37:Scheme Code 3 03-06-2025 14:35:37:Account No 3 03-06-2025 14:35:37:Link Main Started 03-06-2025 14:35:37:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 14:35:37:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 14:35:37:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|012956|SB |001 03-06-2025 14:35:37:Validation Account Proce Executed with out error Y 03-06-2025 14:35:37:ValidationRequest Exccution Success with response : 000 03-06-2025 14:35:37:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 15:12:07:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM15488179581|001001003241 --------------------------> 03-06-2025 15:12:07:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM15488179582|001001001118 --------------------------> 03-06-2025 15:12:07:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 15:12:07:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 15:12:07:Connection Establisment started 03-06-2025 15:12:07:Connection Read From File : Status OK 03-06-2025 15:12:07:Connection Read From File : Status OK 03-06-2025 15:12:07:Connection Successfully Opened : Status OK 03-06-2025 15:12:07:ValidateAcNo CBS A/C No : 001001011946 03-06-2025 15:12:07:CBS A/C No : 001001011946 03-06-2025 15:12: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 03-06-2025 15:12:08:Record Count : 1 03-06-2025 15:12:08:BRLENGTH 3 03-06-2025 15:12:08:SCHLENGTH 3 03-06-2025 15:12:08:ACLENGTH 6 03-06-2025 15:12:08:Branch Code 3 03-06-2025 15:12:08:Scheme Code 3 03-06-2025 15:12:08:Account No 3 03-06-2025 15:12:08:Link Main Started 03-06-2025 15:12:08:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 15:12:08:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 15:12:08:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|011946|SB |001 03-06-2025 15:12:08:Validation Account Proce Executed with out error Y 03-06-2025 15:12:08:Connection Establisment started 03-06-2025 15:12:08:Connection Read From File : Status OK 03-06-2025 15:12:08:Connection Successfully Opened : Status OK 03-06-2025 15:12:08:CBS A/C No : 001001011946 03-06-2025 15:12:08:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 03-06-2025 15:12:08:Record Count : 1 03-06-2025 15:12:08:BRLENGTH 3 03-06-2025 15:12:08:SCHLENGTH 3 03-06-2025 15:12:08:ACLENGTH 6 03-06-2025 15:12:08:Branch Code 3 03-06-2025 15:12:08:Scheme Code 3 03-06-2025 15:12:08:Account No 3 03-06-2025 15:12:08:Link Main Started 03-06-2025 15:12:08:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 15:12:08:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 15:12:08:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|011946|SB |001 03-06-2025 15:12:08:Vno --->:67686 03-06-2025 15:12:08:Current Date --->:03-06-2025 03-06-2025 15:12:08:Connection Successfully Opened : Status OK 03-06-2025 15:12:08:ValidateAcNo CBS A/C No : 001001001118 03-06-2025 15:12:08:CBS A/C No : 001001001118 03-06-2025 15:12:08:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 03-06-2025 15:12:08:Record Count : 1 03-06-2025 15:12:08:BRLENGTH 3 03-06-2025 15:12:08:SCHLENGTH 3 03-06-2025 15:12:08:ACLENGTH 6 03-06-2025 15:12:08:Branch Code 3 03-06-2025 15:12:08:Scheme Code 3 03-06-2025 15:12:08:Account No 3 03-06-2025 15:12:08:Link Main Started 03-06-2025 15:12:08:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 15:12:08:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 15:12:08:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001118|SB |001 03-06-2025 15:12:08:Validation Account Proce Executed with out error Y 03-06-2025 15:12:08:Connection Establisment started 03-06-2025 15:12:08:Connection Read From File : Status OK 03-06-2025 15:12:08:Connection Successfully Opened : Status OK 03-06-2025 15:12:08:CBS A/C No : 001001001118 03-06-2025 15:12:08:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 03-06-2025 15:12:08:Record Count : 1 03-06-2025 15:12:08:BRLENGTH 3 03-06-2025 15:12:08:SCHLENGTH 3 03-06-2025 15:12:08:ACLENGTH 6 03-06-2025 15:12:08:Branch Code 3 03-06-2025 15:12:08:Scheme Code 3 03-06-2025 15:12:08:Account No 3 03-06-2025 15:12:08:Link Main Started 03-06-2025 15:12:08:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 15:12:08:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 15:12:08:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001118|SB |001 03-06-2025 15:12:08:Vno --->:67687 03-06-2025 15:12:08:Current Date --->:03-06-2025 03-06-2025 15:12:08:calling CallNewRtgsBothProc 03-06-2025 15:12:08:Parameters passing - InwardAuthorise 03-06-2025 15:12:08: brn =001 03-06-2025 15:12:08: acno =011946 03-06-2025 15:12:08: abbr =SB 03-06-2025 15:12:08: amt.ToString() =1601 03-06-2025 15:12:08: traceNo =67686 03-06-2025 15:12:08: narr =NEFT, BY ONE 97 COMMUNICATIONS LIMITED ESCROW ACCOUNT _01 UTIB0000022 924020007330961 03-06-2025 15:12:08:Transaction Process : BEFORE CAL PROC: 03-06-2025 15:12:08:calling CallNewRtgsBothProc 03-06-2025 15:12:08:Parameters passing - InwardAuthorise 03-06-2025 15:12:08: brn =001 03-06-2025 15:12:08: acno =001118 03-06-2025 15:12:08: abbr =SB 03-06-2025 15:12:08: amt.ToString() =270 03-06-2025 15:12:08: traceNo =67687 03-06-2025 15:12:08: narr =NEFT, BY ONE 97 COMMUNICATIONS LIMITED ESCROW ACCOUNT _01 UTIB0000022 924020007330961 03-06-2025 15:12:08:Transaction Process : BEFORE CAL PROC: 03-06-2025 15:12:08:cbs no--->001001001118 03-06-2025 15:12:08:CBS A/C No : 001001001118 03-06-2025 15:12:08:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 03-06-2025 15:12:08:Record Count : 1 03-06-2025 15:12:08:BRLENGTH 3 03-06-2025 15:12:08:SCHLENGTH 3 03-06-2025 15:12:08:ACLENGTH 6 03-06-2025 15:12:08:Branch Code 3 03-06-2025 15:12:08:Scheme Code 3 03-06-2025 15:12:08:Account No 3 03-06-2025 15:12:08:Link Main Started 03-06-2025 15:12:08:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 15:12:08:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 15:12:08:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001118|SB |001 03-06-2025 15:12:08:Closed YN quier --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG,DSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,depositmaster,depositschemesetup,ADDRESS where CLMS_SNO=DEPM_CLIENT AND DSCH_BRANCH = DEPM_BRANCH AND DSCH_ABBR = DEPM_ABBR and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB' AND DEPM_NO=001118 AND ADDR_SNO=CLMS_ADDRESS union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG,LSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,LOANMASTER,LOANSCHEMESETUP,ADDRESS where CLMS_SNO=LOAM_CLIENT AND LSCH_BRANCH = LOAM_BRANCH AND LSCH_ABBREV = LOAM_ABBR and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='SB' AND LOAM_NO=001118 AND ADDR_SNO=CLMS_ADDRESS UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG,ODST_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,ODMASTER,ODSCHEMESETUP,ADDRESS where CLMS_SNO=ODMT_CLIENT AND ODST_BRANCH = ODMT_BRANCH AND ODST_ABBR = ODMT_ABBR and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='SB' AND ODMT_NO=001118 AND ADDR_SNO=CLMS_ADDRESS 03-06-2025 15:12:08:Inward Process Executed Sussefully 03-06-2025 15:12:08:ConfirmationReq Execution Success with Status 000 03-06-2025 15:12:08:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM15488179634|001001011946 ------------------------------> 03-06-2025 15:12:08:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 15:12:08:closed y n Record count --->1 03-06-2025 15:12:08:SMS Inserted for Mobile Number : +919945936919 03-06-2025 15:12:08:Inward Process Executed Sussefully 03-06-2025 15:12:08:ConfirmationReq Execution Success with Status 000 03-06-2025 15:12:08:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM15488179582|001001001118 ------------------------------> 03-06-2025 15:12:08:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 15:13:49:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM15488179909|001001012956 --------------------------> 03-06-2025 15:13:49:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 15:13:49:Connection Establisment started 03-06-2025 15:13:49:Connection Read From File : Status OK 03-06-2025 15:13:49:Connection Successfully Opened : Status OK 03-06-2025 15:13:49:ValidateAcNo CBS A/C No : 001001012956 03-06-2025 15:13:49:CBS A/C No : 001001012956 03-06-2025 15:13:49:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 03-06-2025 15:13:49:Record Count : 1 03-06-2025 15:13:49:BRLENGTH 3 03-06-2025 15:13:49:SCHLENGTH 3 03-06-2025 15:13:49:ACLENGTH 6 03-06-2025 15:13:49:Branch Code 3 03-06-2025 15:13:49:Scheme Code 3 03-06-2025 15:13:49:Account No 3 03-06-2025 15:13:49:Link Main Started 03-06-2025 15:13:49:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 15:13:49:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 15:13:49:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|012956|SB |001 03-06-2025 15:13:49:Validation Account Proce Executed with out error Y 03-06-2025 15:13:49:Connection Establisment started 03-06-2025 15:13:49:Connection Read From File : Status OK 03-06-2025 15:13:49:Connection Successfully Opened : Status OK 03-06-2025 15:13:49:CBS A/C No : 001001012956 03-06-2025 15:13:49:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 03-06-2025 15:13:49:Record Count : 1 03-06-2025 15:13:49:BRLENGTH 3 03-06-2025 15:13:49:SCHLENGTH 3 03-06-2025 15:13:49:ACLENGTH 6 03-06-2025 15:13:49:Branch Code 3 03-06-2025 15:13:49:Scheme Code 3 03-06-2025 15:13:49:Account No 3 03-06-2025 15:13:49:Link Main Started 03-06-2025 15:13:49:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 15:13:49:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 15:13:49:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|012956|SB |001 03-06-2025 15:13:49:Vno --->:67688 03-06-2025 15:13:49:Current Date --->:03-06-2025 03-06-2025 15:13:49:calling CallNewRtgsBothProc 03-06-2025 15:13:49:Parameters passing - InwardAuthorise 03-06-2025 15:13:49: brn =001 03-06-2025 15:13:49: acno =012956 03-06-2025 15:13:49: abbr =SB 03-06-2025 15:13:49: amt.ToString() =440 03-06-2025 15:13:49: traceNo =67688 03-06-2025 15:13:49: narr =NEFT, BY ONE 97 COMMUNICATIONS LIMITED ESCROW ACCOUNT _01 UTIB0000022 924020007330961 03-06-2025 15:13:49:Transaction Process : BEFORE CAL PROC: 03-06-2025 15:13:49:Inward Process Executed Sussefully 03-06-2025 15:13:49:ConfirmationReq Execution Success with Status 000 03-06-2025 15:13:49:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM15488179909|001001012956 ------------------------------> 03-06-2025 15:13:49:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 15:34:16:<------------------------Started ValidationRequest CBS A/C No : 001002000895 ------------------------> 03-06-2025 15:34:16:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 15:34:16:Connection Establisment started 03-06-2025 15:34:16:Connection Read From File : Status OK 03-06-2025 15:34:17:Connection Successfully Opened : Status OK 03-06-2025 15:34:17:ValidateAcNo CBS A/C No : 001002000895 03-06-2025 15:34:17:CBS A/C No : 001002000895 03-06-2025 15:34: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 03-06-2025 15:34:17:Record Count : 1 03-06-2025 15:34:17:BRLENGTH 3 03-06-2025 15:34:17:SCHLENGTH 3 03-06-2025 15:34:17:ACLENGTH 6 03-06-2025 15:34:17:Branch Code 3 03-06-2025 15:34:17:Scheme Code 3 03-06-2025 15:34:17:Account No 3 03-06-2025 15:34:17:Link Main Started 03-06-2025 15:34:17:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 03-06-2025 15:34:17:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 15:34:17:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000895|CD |001 03-06-2025 15:34:17:Validation Account Proce Executed with out error Y 03-06-2025 15:34:17:ValidationRequest Exccution Success with response : 000 03-06-2025 15:34:17:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 15:42:15:<------------------------Started ValidationRequest CBS A/C No : 001002000858 ------------------------> 03-06-2025 15:42:15:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 15:42:15:Connection Establisment started 03-06-2025 15:42:15:Connection Read From File : Status OK 03-06-2025 15:42:15:Connection Successfully Opened : Status OK 03-06-2025 15:42:15:ValidateAcNo CBS A/C No : 001002000858 03-06-2025 15:42:15:CBS A/C No : 001002000858 03-06-2025 15:42: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 03-06-2025 15:42:15:Record Count : 1 03-06-2025 15:42:15:BRLENGTH 3 03-06-2025 15:42:15:SCHLENGTH 3 03-06-2025 15:42:15:ACLENGTH 6 03-06-2025 15:42:15:Branch Code 3 03-06-2025 15:42:15:Scheme Code 3 03-06-2025 15:42:15:Account No 3 03-06-2025 15:42:15:Link Main Started 03-06-2025 15:42:15:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 03-06-2025 15:42:15:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 15:42:15:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000858|CD |001 03-06-2025 15:42:15:Validation Account Proce Executed with out error Y 03-06-2025 15:42:15:ValidationRequest Exccution Success with response : 000 03-06-2025 15:42:15:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 16:09:34:<------------------------Started ValidationRequest CBS A/C No : 001022000081 ------------------------> 03-06-2025 16:09:34:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 16:09:34:Connection Establisment started 03-06-2025 16:09:34:Connection Read From File : Status OK 03-06-2025 16:09:34:Connection Successfully Opened : Status OK 03-06-2025 16:09:34:ValidateAcNo CBS A/C No : 001022000081 03-06-2025 16:09:34:CBS A/C No : 001022000081 03-06-2025 16:09:34:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 03-06-2025 16:09:34:Record Count : 1 03-06-2025 16:09:34:BRLENGTH 3 03-06-2025 16:09:34:SCHLENGTH 3 03-06-2025 16:09:34:ACLENGTH 6 03-06-2025 16:09:34:Branch Code 3 03-06-2025 16:09:34:Scheme Code 3 03-06-2025 16:09:34:Account No 3 03-06-2025 16:09:34:Link Main Started 03-06-2025 16:09:34:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 022 and LINK_BRANCH=BRAN_SNO 03-06-2025 16:09:34:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 16:09:34:ShowCBS Ac No Proce Executed HEAD OFFICE|OD|000081|OD |001 03-06-2025 16:09:34:Validation Account Proce Executed with out error Y 03-06-2025 16:09:34:ValidationRequest Exccution Success with response : 000 03-06-2025 16:09:34:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 16:12:07:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 002095606150|001002000895 --------------------------> 03-06-2025 16:12:07:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 16:12:07:Connection Establisment started 03-06-2025 16:12:07:Connection Read From File : Status OK 03-06-2025 16:12:07:Connection Successfully Opened : Status OK 03-06-2025 16:12:07:ValidateAcNo CBS A/C No : 001002000895 03-06-2025 16:12:07:CBS A/C No : 001002000895 03-06-2025 16:12: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 03-06-2025 16:12:07:Record Count : 1 03-06-2025 16:12:07:BRLENGTH 3 03-06-2025 16:12:07:SCHLENGTH 3 03-06-2025 16:12:07:ACLENGTH 6 03-06-2025 16:12:07:Branch Code 3 03-06-2025 16:12:07:Scheme Code 3 03-06-2025 16:12:07:Account No 3 03-06-2025 16:12:07:Link Main Started 03-06-2025 16:12:07:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 03-06-2025 16:12:07:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 16:12:07:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000895|CD |001 03-06-2025 16:12:07:Validation Account Proce Executed with out error Y 03-06-2025 16:12:07:Connection Establisment started 03-06-2025 16:12:07:Connection Read From File : Status OK 03-06-2025 16:12:07:Connection Successfully Opened : Status OK 03-06-2025 16:12:07:CBS A/C No : 001002000895 03-06-2025 16:12: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 03-06-2025 16:12:07:Record Count : 1 03-06-2025 16:12:07:BRLENGTH 3 03-06-2025 16:12:07:SCHLENGTH 3 03-06-2025 16:12:07:ACLENGTH 6 03-06-2025 16:12:07:Branch Code 3 03-06-2025 16:12:07:Scheme Code 3 03-06-2025 16:12:07:Account No 3 03-06-2025 16:12:07:Link Main Started 03-06-2025 16:12:07:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 03-06-2025 16:12:07:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 16:12:07:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000895|CD |001 03-06-2025 16:12:07:Vno --->:67689 03-06-2025 16:12:07:Current Date --->:03-06-2025 03-06-2025 16:12:07:calling CallNewRtgsBothProc 03-06-2025 16:12:07:Parameters passing - InwardAuthorise 03-06-2025 16:12:07: brn =001 03-06-2025 16:12:07: acno =000895 03-06-2025 16:12:07: abbr =CD 03-06-2025 16:12:07: amt.ToString() =110000 03-06-2025 16:12:07: traceNo =67689 03-06-2025 16:12:07: narr =NEFT, BY SHREE MALLIKARJUN AGENCIES UBIN0900648 560371000495471 03-06-2025 16:12:07:Transaction Process : BEFORE CAL PROC: 03-06-2025 16:12:07:cbs no--->001002000895 03-06-2025 16:12:07:CBS A/C No : 001002000895 03-06-2025 16:12: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 03-06-2025 16:12:07:Record Count : 1 03-06-2025 16:12:07:BRLENGTH 3 03-06-2025 16:12:07:SCHLENGTH 3 03-06-2025 16:12:07:ACLENGTH 6 03-06-2025 16:12:07:Branch Code 3 03-06-2025 16:12:07:Scheme Code 3 03-06-2025 16:12:07:Account No 3 03-06-2025 16:12:07:Link Main Started 03-06-2025 16:12:07:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 03-06-2025 16:12:07:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 16:12:07:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000895|CD |001 03-06-2025 16:12:07:Closed YN quier --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG,DSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,depositmaster,depositschemesetup,ADDRESS where CLMS_SNO=DEPM_CLIENT AND DSCH_BRANCH = DEPM_BRANCH AND DSCH_ABBR = DEPM_ABBR and DEPM_BRANCH=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 03-06-2025 16:12:07:closed y n Record count --->1 03-06-2025 16:12:07:SMS Inserted for Mobile Number : +919972536615 03-06-2025 16:12:08:Inward Process Executed Sussefully 03-06-2025 16:12:08:ConfirmationReq Execution Success with Status 000 03-06-2025 16:12:08:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 002095606150|001002000895 ------------------------------> 03-06-2025 16:12:08:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 16:16:19:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : HDFCH00277326067|001002000858 --------------------------> 03-06-2025 16:16:19:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 16:16:19:Connection Establisment started 03-06-2025 16:16:19:Connection Read From File : Status OK 03-06-2025 16:16:19:Connection Successfully Opened : Status OK 03-06-2025 16:16:19:ValidateAcNo CBS A/C No : 001002000858 03-06-2025 16:16:19:CBS A/C No : 001002000858 03-06-2025 16:16: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 03-06-2025 16:16:19:Record Count : 1 03-06-2025 16:16:19:BRLENGTH 3 03-06-2025 16:16:19:SCHLENGTH 3 03-06-2025 16:16:19:ACLENGTH 6 03-06-2025 16:16:19:Branch Code 3 03-06-2025 16:16:19:Scheme Code 3 03-06-2025 16:16:19:Account No 3 03-06-2025 16:16:19:Link Main Started 03-06-2025 16:16:19:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 03-06-2025 16:16:19:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 16:16:19:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000858|CD |001 03-06-2025 16:16:19:Validation Account Proce Executed with out error Y 03-06-2025 16:16:19:Connection Establisment started 03-06-2025 16:16:19:Connection Read From File : Status OK 03-06-2025 16:16:19:Connection Successfully Opened : Status OK 03-06-2025 16:16:19:CBS A/C No : 001002000858 03-06-2025 16:16: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 03-06-2025 16:16:19:Record Count : 1 03-06-2025 16:16:19:BRLENGTH 3 03-06-2025 16:16:19:SCHLENGTH 3 03-06-2025 16:16:19:ACLENGTH 6 03-06-2025 16:16:19:Branch Code 3 03-06-2025 16:16:19:Scheme Code 3 03-06-2025 16:16:19:Account No 3 03-06-2025 16:16:19:Link Main Started 03-06-2025 16:16:19:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 03-06-2025 16:16:19:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 16:16:19:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000858|CD |001 03-06-2025 16:16:19:Vno --->:67690 03-06-2025 16:16:19:Current Date --->:03-06-2025 03-06-2025 16:16:19:calling CallNewRtgsBothProc 03-06-2025 16:16:19:Parameters passing - InwardAuthorise 03-06-2025 16:16:19: brn =001 03-06-2025 16:16:19: acno =000858 03-06-2025 16:16:19: abbr =CD 03-06-2025 16:16:19: amt.ToString() =2100 03-06-2025 16:16:19: traceNo =67690 03-06-2025 16:16:19: narr =NEFT, BY GREENSHINE ENERGY LLP HDFC0000001 50200029611144 03-06-2025 16:16:19:Transaction Process : BEFORE CAL PROC: 03-06-2025 16:16:19:cbs no--->001002000858 03-06-2025 16:16:19:CBS A/C No : 001002000858 03-06-2025 16:16: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 03-06-2025 16:16:19:Record Count : 1 03-06-2025 16:16:19:BRLENGTH 3 03-06-2025 16:16:19:SCHLENGTH 3 03-06-2025 16:16:19:ACLENGTH 6 03-06-2025 16:16:19:Branch Code 3 03-06-2025 16:16:19:Scheme Code 3 03-06-2025 16:16:19:Account No 3 03-06-2025 16:16:19:Link Main Started 03-06-2025 16:16:19:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 03-06-2025 16:16:19:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 16:16:19:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000858|CD |001 03-06-2025 16:16: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)='CD' AND DEPM_NO=000858 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=000858 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=000858 AND ADDR_SNO=CLMS_ADDRESS 03-06-2025 16:16:19:closed y n Record count --->1 03-06-2025 16:16:19:SMS Inserted for Mobile Number : +919845276351 03-06-2025 16:16:19:Inward Process Executed Sussefully 03-06-2025 16:16:19:ConfirmationReq Execution Success with Status 000 03-06-2025 16:16:19:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : HDFCH00277326067|001002000858 ------------------------------> 03-06-2025 16:16:19:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 16:42:14:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : HDFCH00277409645|001022000081 --------------------------> 03-06-2025 16:42:14:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 16:42:14:Connection Establisment started 03-06-2025 16:42:14:Connection Read From File : Status OK 03-06-2025 16:42:14:Connection Successfully Opened : Status OK 03-06-2025 16:42:14:ValidateAcNo CBS A/C No : 001022000081 03-06-2025 16:42:14:CBS A/C No : 001022000081 03-06-2025 16:42:14:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 03-06-2025 16:42:14:Record Count : 1 03-06-2025 16:42:14:BRLENGTH 3 03-06-2025 16:42:14:SCHLENGTH 3 03-06-2025 16:42:14:ACLENGTH 6 03-06-2025 16:42:14:Branch Code 3 03-06-2025 16:42:14:Scheme Code 3 03-06-2025 16:42:14:Account No 3 03-06-2025 16:42:14:Link Main Started 03-06-2025 16:42:14:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 022 and LINK_BRANCH=BRAN_SNO 03-06-2025 16:42:14:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 16:42:14:ShowCBS Ac No Proce Executed HEAD OFFICE|OD|000081|OD |001 03-06-2025 16:42:14:Validation Account Proce Executed with out error Y 03-06-2025 16:42:14:Connection Establisment started 03-06-2025 16:42:14:Connection Read From File : Status OK 03-06-2025 16:42:14:Connection Successfully Opened : Status OK 03-06-2025 16:42:14:CBS A/C No : 001022000081 03-06-2025 16:42:14:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 03-06-2025 16:42:14:Record Count : 1 03-06-2025 16:42:14:BRLENGTH 3 03-06-2025 16:42:14:SCHLENGTH 3 03-06-2025 16:42:14:ACLENGTH 6 03-06-2025 16:42:14:Branch Code 3 03-06-2025 16:42:14:Scheme Code 3 03-06-2025 16:42:14:Account No 3 03-06-2025 16:42:14:Link Main Started 03-06-2025 16:42:14:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 022 and LINK_BRANCH=BRAN_SNO 03-06-2025 16:42:14:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 16:42:14:ShowCBS Ac No Proce Executed HEAD OFFICE|OD|000081|OD |001 03-06-2025 16:42:14:Vno --->:67691 03-06-2025 16:42:14:Current Date --->:03-06-2025 03-06-2025 16:42:14:calling CallNewRtgsBothProc 03-06-2025 16:42:14:Parameters passing - InwardAuthorise 03-06-2025 16:42:14: brn =001 03-06-2025 16:42:14: acno =000081 03-06-2025 16:42:14: abbr =OD 03-06-2025 16:42:14: amt.ToString() =500000 03-06-2025 16:42:14: traceNo =67691 03-06-2025 16:42:14: narr =NEFT, BY SHIVSHAKTI MINERALS HDFC0000001 99902727279999 03-06-2025 16:42:14:Transaction Process : BEFORE CAL PROC: 03-06-2025 16:42:14:cbs no--->001022000081 03-06-2025 16:42:14:CBS A/C No : 001022000081 03-06-2025 16:42:14:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 03-06-2025 16:42:14:Record Count : 1 03-06-2025 16:42:14:BRLENGTH 3 03-06-2025 16:42:14:SCHLENGTH 3 03-06-2025 16:42:14:ACLENGTH 6 03-06-2025 16:42:14:Branch Code 3 03-06-2025 16:42:14:Scheme Code 3 03-06-2025 16:42:14:Account No 3 03-06-2025 16:42:14:Link Main Started 03-06-2025 16:42:14:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 022 and LINK_BRANCH=BRAN_SNO 03-06-2025 16:42:14:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 16:42:14:ShowCBS Ac No Proce Executed HEAD OFFICE|OD|000081|OD |001 03-06-2025 16:42:14: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 03-06-2025 16:42:14:closed y n Record count --->1 03-06-2025 16:42:14:SMS Inserted for Mobile Number : +919845507007 03-06-2025 16:42:14:Inward Process Executed Sussefully 03-06-2025 16:42:14:ConfirmationReq Execution Success with Status 000 03-06-2025 16:42:14:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : HDFCH00277409645|001022000081 ------------------------------> 03-06-2025 16:42:14:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 18:46:04:<------------------------Started ValidationRequest CBS A/C No : 001001006185 ------------------------> 03-06-2025 18:46:04:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 18:46:04:Connection Establisment started 03-06-2025 18:46:04:Connection Read From File : Status OK 03-06-2025 18:46:04:Connection Successfully Opened : Status OK 03-06-2025 18:46:04:ValidateAcNo CBS A/C No : 001001006185 03-06-2025 18:46:04:CBS A/C No : 001001006185 03-06-2025 18:46:04:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 03-06-2025 18:46:04:Record Count : 1 03-06-2025 18:46:04:BRLENGTH 3 03-06-2025 18:46:04:SCHLENGTH 3 03-06-2025 18:46:04:ACLENGTH 6 03-06-2025 18:46:04:Branch Code 3 03-06-2025 18:46:04:Scheme Code 3 03-06-2025 18:46:04:Account No 3 03-06-2025 18:46:04:Link Main Started 03-06-2025 18:46:04:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 18:46:04:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 18:46:04:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|006185|SB |001 03-06-2025 18:46:04:Validation Account Proce Executed with out error Y 03-06-2025 18:46:04:ValidationRequest Exccution Success with response : 000 03-06-2025 18:46:04:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 19:20:52:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXOIR15401389278|001001006185 --------------------------> 03-06-2025 19:20:52:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 19:20:52:Connection Establisment started 03-06-2025 19:20:52:Connection Read From File : Status OK 03-06-2025 19:20:52:Connection Successfully Opened : Status OK 03-06-2025 19:20:52:ValidateAcNo CBS A/C No : 001001006185 03-06-2025 19:20:52:CBS A/C No : 001001006185 03-06-2025 19:20: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 03-06-2025 19:20:52:Record Count : 1 03-06-2025 19:20:52:BRLENGTH 3 03-06-2025 19:20:52:SCHLENGTH 3 03-06-2025 19:20:52:ACLENGTH 6 03-06-2025 19:20:52:Branch Code 3 03-06-2025 19:20:52:Scheme Code 3 03-06-2025 19:20:52:Account No 3 03-06-2025 19:20:52:Link Main Started 03-06-2025 19:20:52:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 19:20:52:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 19:20:52:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|006185|SB |001 03-06-2025 19:20:52:Validation Account Proce Executed with out error Y 03-06-2025 19:20:52:Connection Establisment started 03-06-2025 19:20:52:Connection Read From File : Status OK 03-06-2025 19:20:52:Connection Successfully Opened : Status OK 03-06-2025 19:20:52:CBS A/C No : 001001006185 03-06-2025 19:20: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 03-06-2025 19:20:52:Record Count : 1 03-06-2025 19:20:52:BRLENGTH 3 03-06-2025 19:20:52:SCHLENGTH 3 03-06-2025 19:20:52:ACLENGTH 6 03-06-2025 19:20:52:Branch Code 3 03-06-2025 19:20:52:Scheme Code 3 03-06-2025 19:20:52:Account No 3 03-06-2025 19:20:52:Link Main Started 03-06-2025 19:20:52:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 19:20:52:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 19:20:52:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|006185|SB |001 03-06-2025 19:20:53:Vno --->:67692 03-06-2025 19:20:53:Current Date --->:03-06-2025 03-06-2025 19:20:53:calling CallNewRtgsBothProc 03-06-2025 19:20:53:Parameters passing - InwardAuthorise 03-06-2025 19:20:53: brn =001 03-06-2025 19:20:53: acno =006185 03-06-2025 19:20:53: abbr =SB 03-06-2025 19:20:53: amt.ToString() =15000 03-06-2025 19:20:53: traceNo =67692 03-06-2025 19:20:53: narr =NEFT, BY SAMPATHKUMAR M UTIB0000086 129010100091118 03-06-2025 19:20:53:Transaction Process : BEFORE CAL PROC: 03-06-2025 19:20:53:cbs no--->001001006185 03-06-2025 19:20:53:CBS A/C No : 001001006185 03-06-2025 19:20:53:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 03-06-2025 19:20:53:Record Count : 1 03-06-2025 19:20:53:BRLENGTH 3 03-06-2025 19:20:53:SCHLENGTH 3 03-06-2025 19:20:53:ACLENGTH 6 03-06-2025 19:20:53:Branch Code 3 03-06-2025 19:20:53:Scheme Code 3 03-06-2025 19:20:53:Account No 3 03-06-2025 19:20:53:Link Main Started 03-06-2025 19:20:53:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 19:20:53:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 19:20:53:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|006185|SB |001 03-06-2025 19:20:53:Closed YN quier --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG,DSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,depositmaster,depositschemesetup,ADDRESS where CLMS_SNO=DEPM_CLIENT AND DSCH_BRANCH = DEPM_BRANCH AND DSCH_ABBR = DEPM_ABBR and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB' AND DEPM_NO=006185 AND ADDR_SNO=CLMS_ADDRESS union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG,LSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,LOANMASTER,LOANSCHEMESETUP,ADDRESS where CLMS_SNO=LOAM_CLIENT AND LSCH_BRANCH = LOAM_BRANCH AND LSCH_ABBREV = LOAM_ABBR and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='SB' AND LOAM_NO=006185 AND ADDR_SNO=CLMS_ADDRESS UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG,ODST_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,ODMASTER,ODSCHEMESETUP,ADDRESS where CLMS_SNO=ODMT_CLIENT AND ODST_BRANCH = ODMT_BRANCH AND ODST_ABBR = ODMT_ABBR and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='SB' AND ODMT_NO=006185 AND ADDR_SNO=CLMS_ADDRESS 03-06-2025 19:20:53:closed y n Record count --->1 03-06-2025 19:20:53:SMS Inserted for Mobile Number : +919448135758 03-06-2025 19:20:53:Inward Process Executed Sussefully 03-06-2025 19:20:53:ConfirmationReq Execution Success with Status 000 03-06-2025 19:20:53:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXOIR15401389278|001001006185 ------------------------------> 03-06-2025 19:20:53:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 21:31:34:<------------------------Started ValidationRequest CBS A/C No : 001001010604 ------------------------> 03-06-2025 21:31:34:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 21:31:34:Connection Establisment started 03-06-2025 21:31:34:Connection Read From File : Status OK 03-06-2025 21:31:34:Connection Successfully Opened : Status OK 03-06-2025 21:31:34:ValidateAcNo CBS A/C No : 001001010604 03-06-2025 21:31:34:CBS A/C No : 001001010604 03-06-2025 21:31:34:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 03-06-2025 21:31:34:Record Count : 1 03-06-2025 21:31:34:BRLENGTH 3 03-06-2025 21:31:34:SCHLENGTH 3 03-06-2025 21:31:34:ACLENGTH 6 03-06-2025 21:31:34:Branch Code 3 03-06-2025 21:31:34:Scheme Code 3 03-06-2025 21:31:34:Account No 3 03-06-2025 21:31:34:Link Main Started 03-06-2025 21:31:34:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 21:31:34:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 21:31:34:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|010604|SB |001 03-06-2025 21:31:34:Validation Account Proce Executed with out error Y 03-06-2025 21:31:34:ValidationRequest Exccution Success with response : 000 03-06-2025 21:31:34:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 22:10:12:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : SBIN525154064273|001001010604 --------------------------> 03-06-2025 22:10:12:<------------------------------------------------------------------------------------------------------------------------> 03-06-2025 22:10:12:Connection Establisment started 03-06-2025 22:10:12:Connection Read From File : Status OK 03-06-2025 22:10:12:Connection Successfully Opened : Status OK 03-06-2025 22:10:12:ValidateAcNo CBS A/C No : 001001010604 03-06-2025 22:10:12:CBS A/C No : 001001010604 03-06-2025 22:10:12:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 03-06-2025 22:10:12:Record Count : 1 03-06-2025 22:10:12:BRLENGTH 3 03-06-2025 22:10:12:SCHLENGTH 3 03-06-2025 22:10:12:ACLENGTH 6 03-06-2025 22:10:12:Branch Code 3 03-06-2025 22:10:12:Scheme Code 3 03-06-2025 22:10:12:Account No 3 03-06-2025 22:10:12:Link Main Started 03-06-2025 22:10:12:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 22:10:12:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 22:10:12:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|010604|SB |001 03-06-2025 22:10:12:Validation Account Proce Executed with out error Y 03-06-2025 22:10:12:Connection Establisment started 03-06-2025 22:10:12:Connection Read From File : Status OK 03-06-2025 22:10:12:Connection Successfully Opened : Status OK 03-06-2025 22:10:12:CBS A/C No : 001001010604 03-06-2025 22:10:12:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 03-06-2025 22:10:12:Record Count : 1 03-06-2025 22:10:12:BRLENGTH 3 03-06-2025 22:10:12:SCHLENGTH 3 03-06-2025 22:10:12:ACLENGTH 6 03-06-2025 22:10:12:Branch Code 3 03-06-2025 22:10:12:Scheme Code 3 03-06-2025 22:10:12:Account No 3 03-06-2025 22:10:12:Link Main Started 03-06-2025 22:10:12:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 22:10:12:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 22:10:12:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|010604|SB |001 03-06-2025 22:10:12:Vno --->:67693 03-06-2025 22:10:12:Current Date --->:03-06-2025 03-06-2025 22:10:12:calling CallNewRtgsBothProc 03-06-2025 22:10:12:Parameters passing - InwardAuthorise 03-06-2025 22:10:12: brn =001 03-06-2025 22:10:12: acno =010604 03-06-2025 22:10:12: abbr =SB 03-06-2025 22:10:12: amt.ToString() =34016 03-06-2025 22:10:12: traceNo =67693 03-06-2025 22:10:12: narr =NEFT, BY CREDIT ACCESS GRAMEEN LIMITED SBIN0004266 00000044013697544 03-06-2025 22:10:12:Transaction Process : BEFORE CAL PROC: 03-06-2025 22:10:12:cbs no--->001001010604 03-06-2025 22:10:12:CBS A/C No : 001001010604 03-06-2025 22:10:12:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 03-06-2025 22:10:12:Record Count : 1 03-06-2025 22:10:12:BRLENGTH 3 03-06-2025 22:10:12:SCHLENGTH 3 03-06-2025 22:10:12:ACLENGTH 6 03-06-2025 22:10:12:Branch Code 3 03-06-2025 22:10:12:Scheme Code 3 03-06-2025 22:10:12:Account No 3 03-06-2025 22:10:12:Link Main Started 03-06-2025 22:10:12:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 03-06-2025 22:10:12:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 03-06-2025 22:10:12:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|010604|SB |001 03-06-2025 22:10:12: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=010604 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=010604 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=010604 AND ADDR_SNO=CLMS_ADDRESS 03-06-2025 22:10:12:closed y n Record count --->1 03-06-2025 22:10:12:SMS Inserted for Mobile Number : +918951504486 03-06-2025 22:10:12:Inward Process Executed Sussefully 03-06-2025 22:10:12:ConfirmationReq Execution Success with Status 000 03-06-2025 22:10:12:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : SBIN525154064273|001001010604 ------------------------------> 03-06-2025 22:10:12:<------------------------------------------------------------------------------------------------------------------------>