04-04-2022 09:32:34:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001002394', 0, brlength) branch, SUBSTR ('001001002394', brlength+1, schlength) linksno, SUBSTR ('001001002394', -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|002394|SB|1

04-04-2022 09:32:34:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001002394
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 = 002394ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|002394|1
04-04-2022 09:32:34:ValidationRequest(): Log:Validation Request Details25-488641525-1|001001002394 
<------------------------Started ValidationRequest CBS A/C No : 001001002394 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

04-04-2022 09:37:55:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001002394', 0, brlength) branch, SUBSTR ('001001002394', brlength+1, schlength) linksno, SUBSTR ('001001002394', -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|002394|SB|1

04-04-2022 09:37:55:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001002394
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 = 002394ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|002394|1
04-04-2022 09:37:55:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = '25-488641525-1'
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, '25-488641525-1','Chandan T P','001001002394','CHANDAN T P', '914010019728569','','UTIB0SMCBL1',10,'123')TranProcess.cs: Inward_process(): 001001002394 25-488641525-1  Status : 000

04-04-2022 09:37:55:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 25-488641525-1|001001002394 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 25-488641525-1|001001002394 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

04-04-2022 10:07:34:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001000181', 0, brlength) branch, SUBSTR ('001001000181', brlength+1, schlength) linksno, SUBSTR ('001001000181', -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|000181|SB|1

04-04-2022 10:07:34:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001000181
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 = 000181ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|000181|1
04-04-2022 10:07:34:ValidationRequest(): Log:Validation Request Details25-488727358-1|001001000181 
<------------------------Started ValidationRequest CBS A/C No : 001001000181 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

04-04-2022 10:10:37:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001000181', 0, brlength) branch, SUBSTR ('001001000181', brlength+1, schlength) linksno, SUBSTR ('001001000181', -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|000181|SB|1

04-04-2022 10:10:37:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001000181
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 = 000181ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|000181|1
04-04-2022 10:10:37:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = '25-488727358-1'
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, '25-488727358-1','Manjunatha swamy S C','001001000181','S M DINAKARA', '918010083723448','','UTIB0SMCBL1',3570,'123')TranProcess.cs: Inward_process(): 001001000181 25-488727358-1  Status : 000

04-04-2022 10:10:37:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 25-488727358-1|001001000181 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 25-488727358-1|001001000181 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

04-04-2022 11:24:00:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003569', 0, brlength) branch, SUBSTR ('001001003569', brlength+1, schlength) linksno, SUBSTR ('001001003569', -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|003569|SB|1

04-04-2022 11:24:00:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001003569
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 = 003569ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|003569|1
04-04-2022 11:24:00:ValidationRequest(): Log:Validation Request DetailsKARBN22094715252|001001003569 
<------------------------Started ValidationRequest CBS A/C No : 001001003569 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

04-04-2022 11:41:52:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001001410', 0, brlength) branch, SUBSTR ('001001001410', brlength+1, schlength) linksno, SUBSTR ('001001001410', -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|001410|SB|1

04-04-2022 11:41:52:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001001410
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 = 001410ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|001410|1
04-04-2022 11:41:52:ValidationRequest(): Log:Validation Request Details25-488936364-1|001001001410 
<------------------------Started ValidationRequest CBS A/C No : 001001001410 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

04-04-2022 11:47:51:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001001410', 0, brlength) branch, SUBSTR ('001001001410', brlength+1, schlength) linksno, SUBSTR ('001001001410', -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|001410|SB|1

04-04-2022 11:47:51:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001001410
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 = 001410ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|001410|1
04-04-2022 11:47:51:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = '25-488936364-1'
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, '25-488936364-1','satish','001001001410','S SATHEESH BABU', '333010100057929','','UTIB0SMCBL1',4500,'123')TranProcess.cs: Inward_process(): 001001001410 25-488936364-1  Status : 000

04-04-2022 11:47:51:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 25-488936364-1|001001001410 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 25-488936364-1|001001001410 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

04-04-2022 11:54:11:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003569', 0, brlength) branch, SUBSTR ('001001003569', brlength+1, schlength) linksno, SUBSTR ('001001003569', -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|003569|SB|1

04-04-2022 11:54:11:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001003569
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 = 003569ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|003569|1
04-04-2022 11:54:11:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'KARBN22094715252'
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, 'KARBN22094715252','SHANMUKA MP','001001003569','DIGETAL', '7677000600015901','KARB0000767','UTIB0SMCBL1',5500,'123')TranProcess.cs: Inward_process(): 001001003569 KARBN22094715252  Status : 000

04-04-2022 11:54:11:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : KARBN22094715252|001001003569 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : KARBN22094715252|001001003569 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

04-04-2022 12:09:39:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001001120', 0, brlength) branch, SUBSTR ('001001001120', brlength+1, schlength) linksno, SUBSTR ('001001001120', -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|001120|SB|1

04-04-2022 12:09:39:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001001120
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 = 001120ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|001120|1
04-04-2022 12:09:39:ValidationRequest(): Log:Validation Request DetailsSIBLH22094284618|001001001120 
<------------------------Started ValidationRequest CBS A/C No : 001001001120 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

04-04-2022 12:14:33:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001001176', 0, brlength) branch, SUBSTR ('001001001176', brlength+1, schlength) linksno, SUBSTR ('001001001176', -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|001176|SB|1

04-04-2022 12:14:33:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001001176
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 = 001176ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|001176|1
04-04-2022 12:14:33:ValidationRequest(): Log:Validation Request DetailsSIBLH22094285731|001001001176 
<------------------------Started ValidationRequest CBS A/C No : 001001001176 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

04-04-2022 12:17:58:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001001120', 0, brlength) branch, SUBSTR ('001001001120', brlength+1, schlength) linksno, SUBSTR ('001001001120', -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|001120|SB|1

04-04-2022 12:17:58:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001001120
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 = 001120ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|001120|1
04-04-2022 12:17:58:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'SIBLH22094284618'
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, 'SIBLH22094284618','RAMESH V S','001001001120','V S RAMESH', '0911053000001352','SIBL0002002','UTIB0SMCBL1',3260204,'123')TranProcess.cs: Inward_process(): 001001001120 SIBLH22094284618  Status : 000

04-04-2022 12:17:58:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : SIBLH22094284618|001001001120 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : SIBLH22094284618|001001001120 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

04-04-2022 12:21:22:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001107', 0, brlength) branch, SUBSTR ('001002001107', brlength+1, schlength) linksno, SUBSTR ('001002001107', -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|001107|CA|1

04-04-2022 12:21:22:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001002001107
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 = 001107ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|CA|001107|1
04-04-2022 12:21:22:ValidationRequest(): Log:Validation Request DetailsIBKL220404871440|001002001107 
<------------------------Started ValidationRequest CBS A/C No : 001002001107 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

04-04-2022 12:21:30:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001001176', 0, brlength) branch, SUBSTR ('001001001176', brlength+1, schlength) linksno, SUBSTR ('001001001176', -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|001176|SB|1

04-04-2022 12:21:30:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001001176
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 = 001176ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|001176|1
04-04-2022 12:21:30:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'SIBLH22094285731'
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, 'SIBLH22094285731','SUNEETHA N','001001001176','V S RAMESH', '0911053000001352','SIBL0002002','UTIB0SMCBL1',1842081,'123')TranProcess.cs: Inward_process(): 001001001176 SIBLH22094285731  Status : 000

04-04-2022 12:21:30:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : SIBLH22094285731|001001001176 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : SIBLH22094285731|001001001176 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

04-04-2022 12:48:41:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001107', 0, brlength) branch, SUBSTR ('001002001107', brlength+1, schlength) linksno, SUBSTR ('001002001107', -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|001107|CA|1

04-04-2022 12:48:41:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001002001107
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 = 001107ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|CA|001107|1
04-04-2022 12:48:41:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'IBKL220404871440'
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, 'IBKL220404871440','SRI VISHWAKARMA PATTINA SAHAKARA SANGA NIYAMITHA','001002001107','V DHANANJAYA', '1938104000003773','IBKL0001938','UTIB0SMCBL1',300000,'123')TranProcess.cs: Inward_process(): 001002001107 IBKL220404871440  Status : 000

04-04-2022 12:48:41:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : IBKL220404871440|001002001107 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : IBKL220404871440|001002001107 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

04-04-2022 14:22:47:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003321', 0, brlength) branch, SUBSTR ('001001003321', brlength+1, schlength) linksno, SUBSTR ('001001003321', -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|003321|SB|1

04-04-2022 14:22:47:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001003321
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 = 003321ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|003321|1
04-04-2022 14:22:47:ValidationRequest(): Log:Validation Request DetailsN094221901321831|001001003321 
<------------------------Started ValidationRequest CBS A/C No : 001001003321 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

04-04-2022 15:24:49:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003321', 0, brlength) branch, SUBSTR ('001001003321', brlength+1, schlength) linksno, SUBSTR ('001001003321', -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|003321|SB|1

04-04-2022 15:24:49:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001001003321
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 = 003321ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|SB|003321|1
04-04-2022 15:24:49:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'N094221901321831'
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, 'N094221901321831','Rama Bhagawan H S','001001003321','SHARATH BABU H R', '50100186307801','HDFC0000001','UTIB0SMCBL1',100000,'123')TranProcess.cs: Inward_process(): 001001003321 N094221901321831  Status : 000

04-04-2022 15:24:49:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : N094221901321831|001001003321 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : N094221901321831|001001003321 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>

04-04-2022 16:42:30:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 10105100000473
<------------------------------------------------------------------------------------------------------------------------>
N
04-04-2022 16:42:31:ValidationRequest(): Log:Validation Request DetailsFBBT220946114569|10105100000473 
<------------------------Started ValidationRequest CBS A/C No : 10105100000473 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  111
<------------------------------------------------------------------------------------------------------------------------>

04-04-2022 16:44:36:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 10105100000473
<------------------------------------------------------------------------------------------------------------------------>
N
04-04-2022 16:44:36:ValidationRequest(): Log:Validation Request DetailsFBBT220946114569|10105100000473 
<------------------------Started ValidationRequest CBS A/C No : 10105100000473 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  111
<------------------------------------------------------------------------------------------------------------------------>

04-04-2022 16:50:26:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002000921', 0, brlength) branch, SUBSTR ('001002000921', brlength+1, schlength) linksno, SUBSTR ('001002000921', -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|000921|CA|1

04-04-2022 16:50:26:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001002000921
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 = 000921ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|CA|000921|1
04-04-2022 16:50:26:ValidationRequest(): Log:Validation Request DetailsAXSK220940024753|001002000921 
<------------------------Started ValidationRequest CBS A/C No : 001002000921 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  000
<------------------------------------------------------------------------------------------------------------------------>

04-04-2022 16:59:52:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 10105100000473
<------------------------------------------------------------------------------------------------------------------------>
N
04-04-2022 16:59:52:ValidationRequest(): Log:Validation Request DetailsFBBT220946114569|10105100000473 
<------------------------Started ValidationRequest CBS A/C No : 10105100000473 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  111
<------------------------------------------------------------------------------------------------------------------------>

04-04-2022 17:10:43:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 10105100000473
<------------------------------------------------------------------------------------------------------------------------>
N
04-04-2022 17:10:44:ValidationRequest(): Log:Validation Request DetailsFBBT220946114569|10105100000473 
<------------------------Started ValidationRequest CBS A/C No : 10105100000473 ------------------------>
<------------------------------------------------------------------------------------------------------------------------>
ValidationRequest Execution Success with response :  111
<------------------------------------------------------------------------------------------------------------------------>

04-04-2022 17:28:40:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002000921', 0, brlength) branch, SUBSTR ('001002000921', brlength+1, schlength) linksno, SUBSTR ('001002000921', -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|000921|CA|1

04-04-2022 17:28:40:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------>
ValidateAcNo CBS A/C No : 001002000921
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 = 000921ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------>
Y|CA|000921|1
04-04-2022 17:28:40:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXSK220940024753'
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, 'AXSK220940024753','ALBUR MARIBOREGOWDA AND SONS','001002000921','V P TRADERS', '910020048605494','UTIB0001123','UTIB0SMCBL1',750000,'123')TranProcess.cs: Inward_process(): 001002000921 AXSK220940024753  Status : 000

04-04-2022 17:28:40:<------------------------------------------------------------------------------------------------------------------------>
<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXSK220940024753|001002000921 -------------------------->
<------------------------------------------------------------------------------------------------------------------------>
ConfirmationReq Execution Success with Status 000
<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXSK220940024753|001002000921 ------------------------------>
<------------------------------------------------------------------------------------------------------------------------>