02-07-2026 00:55:01:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003783', 0, brlength) branch, SUBSTR ('001001003783', brlength+1, schlength) linksno, SUBSTR ('001001003783', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|003783|SB|1

02-07-2026 00:55:01:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001003783
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 003783ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|003783|1
02-07-2026 00:55:01:ValidationRequest(): Log:Validation Request DetailsIN12618344400165|001001003783 
<------------------------Started ValidationRequest CBS A/C No : 001001003783 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 01:02:37:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003783', 0, brlength) branch, SUBSTR ('001001003783', brlength+1, schlength) linksno, SUBSTR ('001001003783', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|003783|SB|1

02-07-2026 01:02:37:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001003783
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 003783ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|003783|1
02-07-2026 01:02:37:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'IN12618344400165'
TranProcess.cs: Inward_process() UTR Validation0
TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest:  INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'IN12618344400165','VAISHNAVI H R','001001003783','ANIL KUMAR P', '121701507819','ICIC0SF0002','UTIB0SMCBL1',1000,'123')TranProcess.cs: Inward_process(): 001001003783 IN12618344400165  Status : 000

02-07-2026 01:02:37:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : IN12618344400165|001001003783 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : IN12618344400165|001001003783 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 01:38:12:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001001138', 0, brlength) branch, SUBSTR ('001001001138', brlength+1, schlength) linksno, SUBSTR ('001001001138', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|001138|SB|1

02-07-2026 01:38:12:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001001138
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 001138ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|001138|1
02-07-2026 01:38:12:ValidationRequest(): Log:Validation Request DetailsAXNPM18372231978|001001001138 
<------------------------Started ValidationRequest CBS A/C No : 001001001138 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 01:50:40:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001001314', 0, brlength) branch, SUBSTR ('001001001314', brlength+1, schlength) linksno, SUBSTR ('001001001314', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|001314|SB|1

02-07-2026 01:50:40:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001001314
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 001314ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|001314|1
02-07-2026 01:50:40:ValidationRequest(): Log:Validation Request DetailsAXNPM18372618007|001001001314 
<------------------------Started ValidationRequest CBS A/C No : 001001001314 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 02:02:50:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001001138', 0, brlength) branch, SUBSTR ('001001001138', brlength+1, schlength) linksno, SUBSTR ('001001001138', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|001138|SB|1

02-07-2026 02:02:50:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001001138
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 001138ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|001138|1
02-07-2026 02:02:50:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPM18372231978'
TranProcess.cs: Inward_process() UTR Validation0
TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest:  INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'AXNPM18372231978','GIRISH BABU','001001001138','PAYTM PAYMENTS SERVICES LTD-PAYMENT AGGREGATOR ESCROW A/C', '922020004482533','UTIB0000022','UTIB0SMCBL1',640,'123')TranProcess.cs: Inward_process(): 001001001138 AXNPM18372231978  Status : 000

02-07-2026 02:02:50:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM18372231978|001001001138 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM18372231978|001001001138 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 02:03:11:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001001314', 0, brlength) branch, SUBSTR ('001001001314', brlength+1, schlength) linksno, SUBSTR ('001001001314', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|001314|SB|1

02-07-2026 02:03:11:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001001314
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 001314ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|001314|1
02-07-2026 02:03:11:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPM18372618007'
TranProcess.cs: Inward_process() UTR Validation0
TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest:  INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'AXNPM18372618007','VIJAYA KUMAR S S','001001001314','PAYTM PAYMENTS SERVICES LTD-PAYMENT AGGREGATOR ESCROW A/C', '922020004482533','UTIB0000022','UTIB0SMCBL1',840,'123')TranProcess.cs: Inward_process(): 001001001314 AXNPM18372618007  Status : 000

02-07-2026 02:03:11:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM18372618007|001001001314 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM18372618007|001001001314 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 02:38:01:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001001413', 0, brlength) branch, SUBSTR ('001001001413', brlength+1, schlength) linksno, SUBSTR ('001001001413', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|001413|SB|1

02-07-2026 02:38:01:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001001413
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 001413ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|001413|1
02-07-2026 02:38:01:ValidationRequest(): Log:Validation Request DetailsAXNPM18373938212|001001001413 
<------------------------Started ValidationRequest CBS A/C No : 001001001413 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 02:46:45:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001030001125', 0, brlength) branch, SUBSTR ('001030001125', brlength+1, schlength) linksno, SUBSTR ('001030001125', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 030 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|OD|001125|CHL|1

02-07-2026 02:46:45:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001030001125
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (odmt_closedyn, 'N') AS closedyn, odmt_closedate, odmt_smsregyn AS smsreg FROM clientmaster, odmaster WHERE clms_sno = odmt_client AND NVL(odmt_closedyn, 'N') = 'N' AND odmt_branch = 1 AND TRIM (odmt_abbr) = 'CHL' AND odmt_no = 001125ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|CHL|001125|1
02-07-2026 02:46:45:ValidationRequest(): Log:Validation Request DetailsAXNPN18374181522|001030001125 
<------------------------Started ValidationRequest CBS A/C No : 001030001125 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 03:03:20:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001001413', 0, brlength) branch, SUBSTR ('001001001413', brlength+1, schlength) linksno, SUBSTR ('001001001413', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|001413|SB|1

02-07-2026 03:03:20:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001001413
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 001413ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|001413|1
02-07-2026 03:03:20:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPM18373938212'
TranProcess.cs: Inward_process() UTR Validation0
TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest:  INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'AXNPM18373938212','SHAMALA S P','001001001413','PAYTM PAYMENTS SERVICES LTD-PAYMENT AGGREGATOR ESCROW A/C', '922020004482533','UTIB0000022','UTIB0SMCBL1',20,'123')TranProcess.cs: Inward_process(): 001001001413 AXNPM18373938212  Status : 000

02-07-2026 03:03:20:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM18373938212|001001001413 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM18373938212|001001001413 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 03:03:42:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001030001125', 0, brlength) branch, SUBSTR ('001030001125', brlength+1, schlength) linksno, SUBSTR ('001030001125', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 030 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|OD|001125|CHL|1

02-07-2026 03:03:42:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001030001125
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (odmt_closedyn, 'N') AS closedyn, odmt_closedate, odmt_smsregyn AS smsreg FROM clientmaster, odmaster WHERE clms_sno = odmt_client AND NVL(odmt_closedyn, 'N') = 'N' AND odmt_branch = 1 AND TRIM (odmt_abbr) = 'CHL' AND odmt_no = 001125ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|CHL|001125|1
02-07-2026 03:03:42:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPN18374181522'
TranProcess.cs: Inward_process() UTR Validation0
TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest:  INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'AXNPN18374181522','PAVAN KUMAR D','001030001125','PHONEPE LIMITED-PAYMENT AGGREGATOR ESCROW ACCOUNT', '922020004688715','UTIB0001506','UTIB0SMCBL1',3900,'123')TranProcess.cs: Inward_process(): 001030001125 AXNPN18374181522  Status : 000

02-07-2026 03:03:42:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN18374181522|001030001125 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN18374181522|001030001125 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 03:20:06:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001216', 0, brlength) branch, SUBSTR ('001002001216', brlength+1, schlength) linksno, SUBSTR ('001002001216', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 002 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|001216|CA|1

02-07-2026 03:20:06:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001002001216
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'CA' AND depm_no = 001216ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|CA|001216|1
02-07-2026 03:20:06:ValidationRequest(): Log:Validation Request DetailsAXNPN18375008746|001002001216 
<------------------------Started ValidationRequest CBS A/C No : 001002001216 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 03:28:33:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003750', 0, brlength) branch, SUBSTR ('001001003750', brlength+1, schlength) linksno, SUBSTR ('001001003750', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|003750|SB|1

02-07-2026 03:28:33:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001003750
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 003750ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|003750|1
02-07-2026 03:28:33:ValidationRequest(): Log:Validation Request DetailsAXNPM18375222064|001001003750 
<------------------------Started ValidationRequest CBS A/C No : 001001003750 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 03:31:17:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001030001102', 0, brlength) branch, SUBSTR ('001030001102', brlength+1, schlength) linksno, SUBSTR ('001030001102', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 030 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|OD|001102|CHL|1

02-07-2026 03:31:17:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001030001102
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (odmt_closedyn, 'N') AS closedyn, odmt_closedate, odmt_smsregyn AS smsreg FROM clientmaster, odmaster WHERE clms_sno = odmt_client AND NVL(odmt_closedyn, 'N') = 'N' AND odmt_branch = 1 AND TRIM (odmt_abbr) = 'CHL' AND odmt_no = 001102ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|CHL|001102|1
02-07-2026 03:31:17:ValidationRequest(): Log:Validation Request DetailsAXNPM18375287867|001030001102 
<------------------------Started ValidationRequest CBS A/C No : 001030001102 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 03:33:40:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001216', 0, brlength) branch, SUBSTR ('001002001216', brlength+1, schlength) linksno, SUBSTR ('001002001216', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 002 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|001216|CA|1

02-07-2026 03:33:40:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001002001216
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'CA' AND depm_no = 001216ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|CA|001216|1
02-07-2026 03:33:40:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPN18375008746'
TranProcess.cs: Inward_process() UTR Validation0
TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest:  INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'AXNPN18375008746','SRI LAKSHMI ADINARAYANASAMY TRADERS','001002001216','PHONEPE LIMITED-PAYMENT AGGREGATOR ESCROW ACCOUNT', '922020004688715','UTIB0001506','UTIB0SMCBL1',400,'123')TranProcess.cs: Inward_process(): 001002001216 AXNPN18375008746  Status : 000

02-07-2026 03:33:40:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN18375008746|001002001216 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN18375008746|001002001216 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 03:33:49:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003750', 0, brlength) branch, SUBSTR ('001001003750', brlength+1, schlength) linksno, SUBSTR ('001001003750', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|003750|SB|1

02-07-2026 03:33:49:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001003750
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 003750ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|003750|1
02-07-2026 03:33:49:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPM18375222064'
TranProcess.cs: Inward_process() UTR Validation0
TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest:  INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'AXNPM18375222064','AMITH K R','001001003750','PAYTM PAYMENTS SERVICES LTD-PAYMENT AGGREGATOR ESCROW A/C', '922020004482533','UTIB0000022','UTIB0SMCBL1',5677,'123')TranProcess.cs: Inward_process(): 001001003750 AXNPM18375222064  Status : 000

02-07-2026 03:33:49:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM18375222064|001001003750 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM18375222064|001001003750 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 03:33:52:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001030001102', 0, brlength) branch, SUBSTR ('001030001102', brlength+1, schlength) linksno, SUBSTR ('001030001102', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 030 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|OD|001102|CHL|1

02-07-2026 03:33:52:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001030001102
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (odmt_closedyn, 'N') AS closedyn, odmt_closedate, odmt_smsregyn AS smsreg FROM clientmaster, odmaster WHERE clms_sno = odmt_client AND NVL(odmt_closedyn, 'N') = 'N' AND odmt_branch = 1 AND TRIM (odmt_abbr) = 'CHL' AND odmt_no = 001102ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|CHL|001102|1
02-07-2026 03:33:52:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPM18375287867'
TranProcess.cs: Inward_process() UTR Validation0
TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest:  INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'AXNPM18375287867','SADHANA G V','001030001102','PAYTM PAYMENTS SERVICES LTD-PAYMENT AGGREGATOR ESCROW A/C', '922020004482533','UTIB0000022','UTIB0SMCBL1',18260,'123')TranProcess.cs: Inward_process(): 001030001102 AXNPM18375287867  Status : 000

02-07-2026 03:33:52:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM18375287867|001030001102 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM18375287867|001030001102 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 03:34:04:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('002001000102', 0, brlength) branch, SUBSTR ('002001000102', brlength+1, schlength) linksno, SUBSTR ('002001000102', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 002
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  VINAYAKANAGAR|DEPOSIT|000102|SB|2

02-07-2026 03:34:04:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 002001000102
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 2 AND TRIM (depm_abbr) = 'SB' AND depm_no = 000102ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|000102|2
02-07-2026 03:34:04:ValidationRequest(): Log:Validation Request DetailsAXNPM18375356547|002001000102 
<------------------------Started ValidationRequest CBS A/C No : 002001000102 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 03:35:39:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001165', 0, brlength) branch, SUBSTR ('001002001165', brlength+1, schlength) linksno, SUBSTR ('001002001165', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 002 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|001165|CA|1

02-07-2026 03:35:39:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001002001165
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'CA' AND depm_no = 001165ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|CA|001165|1
02-07-2026 03:35:39:ValidationRequest(): Log:Validation Request DetailsAXNPM18375396603|001002001165 
<------------------------Started ValidationRequest CBS A/C No : 001002001165 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 04:02:50:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('002001000102', 0, brlength) branch, SUBSTR ('002001000102', brlength+1, schlength) linksno, SUBSTR ('002001000102', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 002
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  VINAYAKANAGAR|DEPOSIT|000102|SB|2

02-07-2026 04:02:50:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 002001000102
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 2 AND TRIM (depm_abbr) = 'SB' AND depm_no = 000102ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|000102|2
02-07-2026 04:02:50:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPM18375356547'
TranProcess.cs: Inward_process() UTR Validation0
TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest:  INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'AXNPM18375356547','JAYALAKSHMI','002001000102','PAYTM PAYMENTS SERVICES LTD-PAYMENT AGGREGATOR ESCROW A/C', '922020004482533','UTIB0000022','UTIB0SMCBL1',41539,'123')TranProcess.cs: Inward_process(): 002001000102 AXNPM18375356547  Status : 000

02-07-2026 04:02:50:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM18375356547|002001000102 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM18375356547|002001000102 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 04:02:50:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001165', 0, brlength) branch, SUBSTR ('001002001165', brlength+1, schlength) linksno, SUBSTR ('001002001165', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 002 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|001165|CA|1

02-07-2026 04:02:50:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001002001165
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'CA' AND depm_no = 001165ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|CA|001165|1
02-07-2026 04:02:50:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPM18375396603'
TranProcess.cs: Inward_process() UTR Validation0
TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest:  INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'AXNPM18375396603','SANGEETHA TEXTORIUM','001002001165','PAYTM PAYMENTS SERVICES LTD-PAYMENT AGGREGATOR ESCROW A/C', '922020004482533','UTIB0000022','UTIB0SMCBL1',10900,'123')TranProcess.cs: Inward_process(): 001002001165 AXNPM18375396603  Status : 000

02-07-2026 04:02:50:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM18375396603|001002001165 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM18375396603|001002001165 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 04:06:00:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001000623', 0, brlength) branch, SUBSTR ('001001000623', brlength+1, schlength) linksno, SUBSTR ('001001000623', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000623|SB|1

02-07-2026 04:06:00:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001000623
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 000623ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|000623|1
02-07-2026 04:06:00:ValidationRequest(): Log:Validation Request DetailsAXNPN18376096961|001001000623 
<------------------------Started ValidationRequest CBS A/C No : 001001000623 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 04:06:42:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001154', 0, brlength) branch, SUBSTR ('001002001154', brlength+1, schlength) linksno, SUBSTR ('001002001154', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 002 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|001154|CA|1

02-07-2026 04:06:42:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001002001154
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'CA' AND depm_no = 001154ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|CA|001154|1
02-07-2026 04:06:42:ValidationRequest(): Log:Validation Request DetailsAXNPN18376114603|001002001154 
<------------------------Started ValidationRequest CBS A/C No : 001002001154 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 04:26:34:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002000369', 0, brlength) branch, SUBSTR ('001002000369', brlength+1, schlength) linksno, SUBSTR ('001002000369', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 002 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000369|CA|1

02-07-2026 04:26:34:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001002000369
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'CA' AND depm_no = 000369ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|CA|000369|1
02-07-2026 04:26:34:ValidationRequest(): Log:Validation Request DetailsAXNPN18376597645|001002000369 
<------------------------Started ValidationRequest CBS A/C No : 001002000369 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 04:33:23:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001000623', 0, brlength) branch, SUBSTR ('001001000623', brlength+1, schlength) linksno, SUBSTR ('001001000623', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000623|SB|1

02-07-2026 04:33:23:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001000623
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 000623ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|000623|1
02-07-2026 04:33:23:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPN18376096961'
TranProcess.cs: Inward_process() UTR Validation0
TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest:  INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'AXNPN18376096961','SHIVASHANKAR','001001000623','PHONEPE LIMITED-PAYMENT AGGREGATOR ESCROW ACCOUNT', '922020004688715','UTIB0001506','UTIB0SMCBL1',16489.21,'123')TranProcess.cs: Inward_process(): 001001000623 AXNPN18376096961  Status : 000

02-07-2026 04:33:23:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN18376096961|001001000623 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN18376096961|001001000623 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 04:33:24:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001154', 0, brlength) branch, SUBSTR ('001002001154', brlength+1, schlength) linksno, SUBSTR ('001002001154', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 002 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|001154|CA|1

02-07-2026 04:33:24:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001002001154
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'CA' AND depm_no = 001154ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|CA|001154|1
02-07-2026 04:33:24:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPN18376114603'
TranProcess.cs: Inward_process() UTR Validation0
TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest:  INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'AXNPN18376114603','BALAJI JEWELS','001002001154','PHONEPE LIMITED-PAYMENT AGGREGATOR ESCROW ACCOUNT', '922020004688715','UTIB0001506','UTIB0SMCBL1',650,'123')TranProcess.cs: Inward_process(): 001002001154 AXNPN18376114603  Status : 000

02-07-2026 04:33:24:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN18376114603|001002001154 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN18376114603|001002001154 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 04:33:38:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002000369', 0, brlength) branch, SUBSTR ('001002000369', brlength+1, schlength) linksno, SUBSTR ('001002000369', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 002 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000369|CA|1

02-07-2026 04:33:38:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001002000369
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'CA' AND depm_no = 000369ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|CA|000369|1
02-07-2026 04:33:38:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPN18376597645'
TranProcess.cs: Inward_process() UTR Validation0
TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest:  INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'AXNPN18376597645','SRI VENKATESHWARA DISTRIBUTORS','001002000369','PHONEPE LIMITED-PAYMENT AGGREGATOR ESCROW ACCOUNT', '922020004688715','UTIB0001506','UTIB0SMCBL1',8401.04,'123')TranProcess.cs: Inward_process(): 001002000369 AXNPN18376597645  Status : 000

02-07-2026 04:33:38:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN18376597645|001002000369 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN18376597645|001002000369 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 04:42:12:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('002001000103', 0, brlength) branch, SUBSTR ('002001000103', brlength+1, schlength) linksno, SUBSTR ('002001000103', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 002
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  VINAYAKANAGAR|DEPOSIT|000103|SB|2

02-07-2026 04:42:12:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 002001000103
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 2 AND TRIM (depm_abbr) = 'SB' AND depm_no = 000103ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|000103|2
02-07-2026 04:42:12:ValidationRequest(): Log:Validation Request DetailsAXNPN18376870958|002001000103 
<------------------------Started ValidationRequest CBS A/C No : 002001000103 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 05:03:00:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('002001000103', 0, brlength) branch, SUBSTR ('002001000103', brlength+1, schlength) linksno, SUBSTR ('002001000103', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 002
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  VINAYAKANAGAR|DEPOSIT|000103|SB|2

02-07-2026 05:03:00:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 002001000103
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 2 AND TRIM (depm_abbr) = 'SB' AND depm_no = 000103ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|000103|2
02-07-2026 05:03:00:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPN18376870958'
TranProcess.cs: Inward_process() UTR Validation0
TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest:  INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'AXNPN18376870958','MOHAN','002001000103','PHONEPE LIMITED-PAYMENT AGGREGATOR ESCROW ACCOUNT', '922020004688715','UTIB0001506','UTIB0SMCBL1',1733,'123')TranProcess.cs: Inward_process(): 002001000103 AXNPN18376870958  Status : 000

02-07-2026 05:03:00:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN18376870958|002001000103 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN18376870958|002001000103 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 08:29:49:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003844', 0, brlength) branch, SUBSTR ('001001003844', brlength+1, schlength) linksno, SUBSTR ('001001003844', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|003844|SB|1

02-07-2026 08:29:49:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001003844
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 003844ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|003844|1
02-07-2026 08:29:49:ValidationRequest(): Log:Validation Request DetailsTGMBN26183011198|001001003844 
<------------------------Started ValidationRequest CBS A/C No : 001001003844 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 08:34:06:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003844', 0, brlength) branch, SUBSTR ('001001003844', brlength+1, schlength) linksno, SUBSTR ('001001003844', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|003844|SB|1

02-07-2026 08:34:06:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001003844
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 003844ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|003844|1
02-07-2026 08:34:06:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'TGMBN26183011198'
TranProcess.cs: Inward_process() UTR Validation0
TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest:  INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'TGMBN26183011198','Anil Kumar J','001001003844','ANIL KUMAR J', '00000103060009977','TGMB0000001','UTIB0SMCBL1',300,'123')TranProcess.cs: Inward_process(): 001001003844 TGMBN26183011198  Status : 000

02-07-2026 08:34:06:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : TGMBN26183011198|001001003844 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : TGMBN26183011198|001001003844 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 09:25:10:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002000866', 0, brlength) branch, SUBSTR ('001002000866', brlength+1, schlength) linksno, SUBSTR ('001002000866', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 002 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000866|CA|1

02-07-2026 09:25:10:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001002000866
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'CA' AND depm_no = 000866ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|CA|000866|1
02-07-2026 09:25:10:ValidationRequest(): Log:Validation Request DetailsAXOMB18302040046|001002000866 
<------------------------Started ValidationRequest CBS A/C No : 001002000866 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 09:33:33:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002000866', 0, brlength) branch, SUBSTR ('001002000866', brlength+1, schlength) linksno, SUBSTR ('001002000866', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 002 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000866|CA|1

02-07-2026 09:33:33:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001002000866
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'CA' AND depm_no = 000866ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|CA|000866|1
02-07-2026 09:33:33:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXOMB18302040046'
TranProcess.cs: Inward_process() UTR Validation0
TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest:  INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'AXOMB18302040046','T B Jayadevappa','001002000866','THIRUMALA TRADERS', '916030018259174','UTIB0001123','UTIB0SMCBL1',1277276,'123')TranProcess.cs: Inward_process(): 001002000866 AXOMB18302040046  Status : 000

02-07-2026 09:33:33:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXOMB18302040046|001002000866 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXOMB18302040046|001002000866 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 11:15:01:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001042', 0, brlength) branch, SUBSTR ('001002001042', brlength+1, schlength) linksno, SUBSTR ('001002001042', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 002 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|001042|CA|1

02-07-2026 11:15:01:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001002001042
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'CA' AND depm_no = 001042ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|CA|001042|1
02-07-2026 11:15:01:ValidationRequest(): Log:Validation Request DetailsSBIN426183943373|001002001042 
<------------------------Started ValidationRequest CBS A/C No : 001002001042 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 11:33:52:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001042', 0, brlength) branch, SUBSTR ('001002001042', brlength+1, schlength) linksno, SUBSTR ('001002001042', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 002 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|001042|CA|1

02-07-2026 11:33:52:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001002001042
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'CA' AND depm_no = 001042ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|CA|001042|1
02-07-2026 11:33:52:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'SBIN426183943373'
TranProcess.cs: Inward_process() UTR Validation0
TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest:  INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'SBIN426183943373','Mallikarjunaiah','001002001042','Mallikarjunaiah', '00000042323258099','SBIN0007500','UTIB0SMCBL1',50000,'123')TranProcess.cs: Inward_process(): 001002001042 SBIN426183943373  Status : 000

02-07-2026 11:33:52:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : SBIN426183943373|001002001042 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : SBIN426183943373|001002001042 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 11:50:19:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003783', 0, brlength) branch, SUBSTR ('001001003783', brlength+1, schlength) linksno, SUBSTR ('001001003783', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|003783|SB|1

02-07-2026 11:50:19:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001003783
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 003783ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|003783|1
02-07-2026 11:50:19:ValidationRequest(): Log:Validation Request DetailsIN12618344494369|001001003783 
<------------------------Started ValidationRequest CBS A/C No : 001001003783 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 12:04:56:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003783', 0, brlength) branch, SUBSTR ('001001003783', brlength+1, schlength) linksno, SUBSTR ('001001003783', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|003783|SB|1

02-07-2026 12:04:56:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001003783
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'SB' AND depm_no = 003783ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|003783|1
02-07-2026 12:04:56:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'IN12618344494369'
TranProcess.cs: Inward_process() UTR Validation0
TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest:  INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'IN12618344494369','VAISHNAVI H R','001001003783','ANIL KUMAR P', '121701507819','ICIC0SF0002','UTIB0SMCBL1',500,'123')TranProcess.cs: Inward_process(): 001001003783 IN12618344494369  Status : 000

02-07-2026 12:04:56:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : IN12618344494369|001001003783 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : IN12618344494369|001001003783 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 12:38:30:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001232', 0, brlength) branch, SUBSTR ('001002001232', brlength+1, schlength) linksno, SUBSTR ('001002001232', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 002 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|001232|CA|1

02-07-2026 12:38:30:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001002001232
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'CA' AND depm_no = 001232ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|CA|001232|1
02-07-2026 12:38:30:ValidationRequest(): Log:Validation Request DetailsHDFCR52026070278100278|001002001232 
<------------------------Started ValidationRequest CBS A/C No : 001002001232 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 12:38:32:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001232', 0, brlength) branch, SUBSTR ('001002001232', brlength+1, schlength) linksno, SUBSTR ('001002001232', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 002 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|001232|CA|1

02-07-2026 12:38:32:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001002001232
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'CA' AND depm_no = 001232ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|CA|001232|1
02-07-2026 12:38:32:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'HDFCR52026070278100278'
TranProcess.cs: Inward_process() UTR Validation0
TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest:  INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'HDFCR52026070278100278','S L V ENTERPRISES','001002001232','RAJESH M R', '50200098301636','HDFC0008838','UTIB0SMCBL1',500000,'123')TranProcess.cs: Inward_process(): 001002001232 HDFCR52026070278100278  Status : 000

02-07-2026 12:38:32:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : HDFCR52026070278100278|001002001232 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : HDFCR52026070278100278|001002001232 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 13:16:12:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('002001000102', 0, brlength) branch, SUBSTR ('002001000102', brlength+1, schlength) linksno, SUBSTR ('002001000102', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 002
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  VINAYAKANAGAR|DEPOSIT|000102|SB|2

02-07-2026 13:16:12:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 002001000102
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 2 AND TRIM (depm_abbr) = 'SB' AND depm_no = 000102ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|000102|2
02-07-2026 13:16:12:ValidationRequest(): Log:Validation Request DetailsAXNPM18378635005|002001000102 
<------------------------Started ValidationRequest CBS A/C No : 002001000102 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 13:34:40:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('002001000102', 0, brlength) branch, SUBSTR ('002001000102', brlength+1, schlength) linksno, SUBSTR ('002001000102', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 001 AND bran_sno = 002
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  VINAYAKANAGAR|DEPOSIT|000102|SB|2

02-07-2026 13:34:40:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 002001000102
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 2 AND TRIM (depm_abbr) = 'SB' AND depm_no = 000102ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|000102|2
02-07-2026 13:34:40:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPM18378635005'
TranProcess.cs: Inward_process() UTR Validation0
TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest:  INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'AXNPM18378635005','JAYALAKSHMI','002001000102','PAYTM PAYMENTS SERVICES LTD-PAYMENT AGGREGATOR ESCROW A/C', '922020004482533','UTIB0000022','UTIB0SMCBL1',18376.5,'123')TranProcess.cs: Inward_process(): 002001000102 AXNPM18378635005  Status : 000

02-07-2026 13:34:40:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM18378635005|002001000102 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM18378635005|002001000102 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 13:56:14:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002000369', 0, brlength) branch, SUBSTR ('001002000369', brlength+1, schlength) linksno, SUBSTR ('001002000369', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 002 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000369|CA|1

02-07-2026 13:56:14:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001002000369
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'CA' AND depm_no = 000369ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|CA|000369|1
02-07-2026 13:56:14:ValidationRequest(): Log:Validation Request DetailsKARBN26183969754|001002000369 
<------------------------Started ValidationRequest CBS A/C No : 001002000369 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 14:07:13:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002000369', 0, brlength) branch, SUBSTR ('001002000369', brlength+1, schlength) linksno, SUBSTR ('001002000369', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno)
TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1
TranProcess.cs: Linkmain Query  SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 002 AND bran_sno = 001
TranProcess.cs: Linkmain Query Row Count dtTemp: 1
ShowCBS Ac No Proce Executed  HEAD OFFICE|DEPOSIT|000369|CA|1

02-07-2026 14:07:13:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001002000369
ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'CA' AND depm_no = 000369ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|CA|000369|1
02-07-2026 14:07:13:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'KARBN26183969754'
TranProcess.cs: Inward_process() UTR Validation0
TranProcess.cs: Inward_process(): Insert To rtgsinwardrequest:  INSERT INTO rtgsinwardrequest (voucherno, voucherdate, trandate, received_datetime, remit_utr, benefi_name, benefi_accno, remit_name, remit_acno, sender_ifsc, benefi_ifsc, amount, file_name) VALUES ( seq_rtgsinward.NEXTVAL,TRUNC(SYSDATE),SYSDATE, SYSDATE, 'KARBN26183969754','VENKATESHWARA DISTRIBUTOR TIPTUR','001002000369','RAJA RAM GENERAL STORES', '0097000600019301','KARB0000009','UTIB0SMCBL1',5387,'123')TranProcess.cs: Inward_process(): 001002000369 KARBN26183969754  Status : 000

02-07-2026 14:07:13:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : KARBN26183969754|001002000369 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : KARBN26183969754|001002000369 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 22:41:53:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 111
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 22:41:53:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 111
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 22:41:53:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 111
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 22:41:53:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 111
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 22:41:53:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 111
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 22:41:53:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 111
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 22:41:53:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 111
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 22:41:53:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 111
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 22:41:53:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 111
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

02-07-2026 22:41:53:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 111
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 010405000010|10305100002333 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>