12-11-2025 01:56:45: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) ShowCBS Ac No Proce With Error System.Data.OracleClient.OracleException (0x80131938): ORA-12541: TNS:no listener at System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc) at System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName) at System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions) at System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OracleClient.OracleConnection.Open() at SSLWCF.OracleDataHandler.GetDataTable(DataTable& dataSource, String CommandText, CommandType commandType) in E:\DARSHAN\BANKING SOURCE\RTGS\SSLWCF_64BIT\SSLWCF\OracleDataHandler.cs:line 33 at SSLWCF.TranProcess.ShowCBSAcNo(String CbsNo) in E:\DARSHAN\BANKING SOURCE\RTGS\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 148ShowCBS Ac No Proce Executed |||| 12-11-2025 01:56:45:TranProcess.cs: Exception in ValidateAcNo()System.Data.OracleClient.OracleException (0x80131938): ORA-12541: TNS:no listener at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OracleClient.OracleConnection.Open() at SSLWCF.OracleDataHandler.GetDataTable(DataTable& dataSource, String CommandText, CommandType commandType) in E:\DARSHAN\BANKING SOURCE\RTGS\SSLWCF_64BIT\SSLWCF\OracleDataHandler.cs:line 33 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo, String strUTR) in E:\DARSHAN\BANKING SOURCE\RTGS\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 79 12-11-2025 01:56:45:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001001413 ValidationAcNo.cs: Query TO Fetch()<------------------------------------------------------------------------------------------------------------------------> System.Data.OracleClient.OracleException (0x80131938): ORA-12541: TNS:no listener at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OracleClient.OracleConnection.Open() at SSLWCF.OracleDataHandler.GetDataTable(DataTable& dataSource, String CommandText, CommandType commandType) in E:\DARSHAN\BANKING SOURCE\RTGS\SSLWCF_64BIT\SSLWCF\OracleDataHandler.cs:line 33 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo, String strUTR) in E:\DARSHAN\BANKING SOURCE\RTGS\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 79 12-11-2025 01:56:45:ValidationRequest(): Log:Validation Request DetailsAXNPM31608669272|001001001413 <------------------------Started ValidationRequest CBS A/C No : 001001001413 ------------------------> <------------------------------------------------------------------------------------------------------------------------> Service1.svc:Exception in ValidationRequest()ORA-12541: TNS:no listener ValidationRequest Execution Success with response : 111 <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 01:59:33: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) ShowCBS Ac No Proce With Error System.Data.OracleClient.OracleException (0x80131938): ORA-12541: TNS:no listener at System.Data.OracleClient.OracleException.Check(OciErrorHandle errorHandle, Int32 rc) at System.Data.OracleClient.OracleInternalConnection.OpenOnLocalTransaction(String userName, String password, String serverName, Boolean integratedSecurity, Boolean unicode, Boolean omitOracleConnectionName) at System.Data.OracleClient.OracleInternalConnection..ctor(OracleConnectionString connectionOptions) at System.Data.OracleClient.OracleConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OracleClient.OracleConnection.Open() at SSLWCF.OracleDataHandler.GetDataTable(DataTable& dataSource, String CommandText, CommandType commandType) in E:\DARSHAN\BANKING SOURCE\RTGS\SSLWCF_64BIT\SSLWCF\OracleDataHandler.cs:line 33 at SSLWCF.TranProcess.ShowCBSAcNo(String CbsNo) in E:\DARSHAN\BANKING SOURCE\RTGS\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 148ShowCBS Ac No Proce Executed |||| 12-11-2025 01:59:33:TranProcess.cs: Exception in ValidateAcNo()System.Data.OracleClient.OracleException (0x80131938): ORA-12541: TNS:no listener at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OracleClient.OracleConnection.Open() at SSLWCF.OracleDataHandler.GetDataTable(DataTable& dataSource, String CommandText, CommandType commandType) in E:\DARSHAN\BANKING SOURCE\RTGS\SSLWCF_64BIT\SSLWCF\OracleDataHandler.cs:line 33 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo, String strUTR) in E:\DARSHAN\BANKING SOURCE\RTGS\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 79 12-11-2025 01:59:33:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001001138 ValidationAcNo.cs: Query TO Fetch()<------------------------------------------------------------------------------------------------------------------------> System.Data.OracleClient.OracleException (0x80131938): ORA-12541: TNS:no listener at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OracleClient.OracleConnection.Open() at SSLWCF.OracleDataHandler.GetDataTable(DataTable& dataSource, String CommandText, CommandType commandType) in E:\DARSHAN\BANKING SOURCE\RTGS\SSLWCF_64BIT\SSLWCF\OracleDataHandler.cs:line 33 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo, String strUTR) in E:\DARSHAN\BANKING SOURCE\RTGS\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 79 12-11-2025 01:59:33:ValidationRequest(): Log:Validation Request DetailsAXNPM31608792460|001001001138 <------------------------Started ValidationRequest CBS A/C No : 001001001138 ------------------------> <------------------------------------------------------------------------------------------------------------------------> Service1.svc:Exception in ValidationRequest()ORA-12541: TNS:no listener ValidationRequest Execution Success with response : 111 <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 02:05:28: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 12-11-2025 02:05:28: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 12-11-2025 02:05:28:ValidationRequest(): Log:Validation Request DetailsAXNPM31609104306|001001001314 <------------------------Started ValidationRequest CBS A/C No : 001001001314 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 02:34:00: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 12-11-2025 02:34:00: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 12-11-2025 02:34:00:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPM31609104306' 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, 'AXNPM31609104306','VIJAYA KUMAR S S','001001001314','ONE 97 COMMUNICATIONS LIMITED ESCROW ACCOUNT _01', '924020007330961','UTIB0000022','UTIB0SMCBL1',1100,'123')TranProcess.cs: Inward_process(): 001001001314 AXNPM31609104306 Status : 000 12-11-2025 02:34:00:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM31609104306|001001001314 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM31609104306|001001001314 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 03:05:34: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 12-11-2025 03:05:34: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 12-11-2025 03:05:34:ValidationRequest(): Log:Validation Request DetailsAXNPM31611462674|002001000102 <------------------------Started ValidationRequest CBS A/C No : 002001000102 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 03:09:04: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 12-11-2025 03:09:04: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 12-11-2025 03:09:04:ValidationRequest(): Log:Validation Request DetailsAXNPM31611826691|001030001102 <------------------------Started ValidationRequest CBS A/C No : 001030001102 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 03:10:22: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 12-11-2025 03:10:22: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 12-11-2025 03:10:22:ValidationRequest(): Log:Validation Request DetailsAXNPM31611957820|001001001413 <------------------------Started ValidationRequest CBS A/C No : 001001001413 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 03:10:22: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 12-11-2025 03:10:22: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 12-11-2025 03:10:22:ValidationRequest(): Log:Validation Request DetailsAXNPM31611954820|001001001138 <------------------------Started ValidationRequest CBS A/C No : 001001001138 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 03:32:43: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 12-11-2025 03:32:43: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 12-11-2025 03:32:43:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPM31611462674' 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, 'AXNPM31611462674','JAYALAKSHMI','002001000102','ONE 97 COMMUNICATIONS LIMITED ESCROW ACCOUNT _01', '924020007330961','UTIB0000022','UTIB0SMCBL1',570,'123')TranProcess.cs: Inward_process(): 002001000102 AXNPM31611462674 Status : 000 12-11-2025 03:32:43:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM31611462674|002001000102 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM31611462674|002001000102 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 03:32:57: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 12-11-2025 03:32:57: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 12-11-2025 03:32:57:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPM31611826691' 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, 'AXNPM31611826691','SADHANA G V','001030001102','ONE 97 COMMUNICATIONS LIMITED ESCROW ACCOUNT _01', '924020007330961','UTIB0000022','UTIB0SMCBL1',4970,'123')TranProcess.cs: Inward_process(): 001030001102 AXNPM31611826691 Status : 000 12-11-2025 03:32:57:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM31611826691|001030001102 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM31611826691|001030001102 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 03:33:02: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 12-11-2025 03:33:02: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 12-11-2025 03:33:03:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPM31611957820' 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, 'AXNPM31611957820','SHAMALA S P','001001001413','ONE 97 COMMUNICATIONS LIMITED ESCROW ACCOUNT _01', '924020007330961','UTIB0000022','UTIB0SMCBL1',2340,'123')TranProcess.cs: Inward_process(): 001001001413 AXNPM31611957820 Status : 000 12-11-2025 03:33:03:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM31611957820|001001001413 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM31611957820|001001001413 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 03:33:03: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 12-11-2025 03:33:03: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 12-11-2025 03:33:03:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPM31611954820' 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, 'AXNPM31611954820','GIRISH BABU','001001001138','ONE 97 COMMUNICATIONS LIMITED ESCROW ACCOUNT _01', '924020007330961','UTIB0000022','UTIB0SMCBL1',194,'123')TranProcess.cs: Inward_process(): 001001001138 AXNPM31611954820 Status : 000 12-11-2025 03:33:03:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM31611954820|001001001138 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM31611954820|001001001138 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 03:34:34: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 12-11-2025 03:34:35: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 12-11-2025 03:34:35:ValidationRequest(): Log:Validation Request DetailsAXNPN31612350887|001002001216 <------------------------Started ValidationRequest CBS A/C No : 001002001216 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 04:02:37: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 12-11-2025 04:02:37: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 12-11-2025 04:02:37:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPN31612350887' 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, 'AXNPN31612350887','SRI LAKSHMI ADINARAYANASAMY TRADERS','001002001216','PHONEPE LIMITED-PAYMENT AGGREGATOR ESCROW ACCOUNT', '922020004688715','UTIB0001506','UTIB0SMCBL1',1655,'123')TranProcess.cs: Inward_process(): 001002001216 AXNPN31612350887 Status : 000 12-11-2025 04:02:37:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN31612350887|001002001216 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN31612350887|001002001216 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 04:05:06:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003000', 0, brlength) branch, SUBSTR ('001001003000', brlength+1, schlength) linksno, SUBSTR ('001001003000', -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|003000|SB|1 12-11-2025 04:05:06:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001003000 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 = 003000ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|003000|1 12-11-2025 04:05:06:ValidationRequest(): Log:Validation Request DetailsAXNPN31612989888|001001003000 <------------------------Started ValidationRequest CBS A/C No : 001001003000 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 04:13:04: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 12-11-2025 04:13:04: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 12-11-2025 04:13:04:ValidationRequest(): Log:Validation Request DetailsAXNPN31613087552|001001000623 <------------------------Started ValidationRequest CBS A/C No : 001001000623 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 04:14:09:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003316', 0, brlength) branch, SUBSTR ('001001003316', brlength+1, schlength) linksno, SUBSTR ('001001003316', -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|003316|SB|1 12-11-2025 04:14:09:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001003316 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 = 003316ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|003316|1 12-11-2025 04:14:09:ValidationRequest(): Log:Validation Request DetailsYESAP53164414391|001001003316 <------------------------Started ValidationRequest CBS A/C No : 001001003316 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 04:23:22: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 12-11-2025 04:23:22: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 12-11-2025 04:23:22:ValidationRequest(): Log:Validation Request DetailsYESAP53164566970|001002000369 <------------------------Started ValidationRequest CBS A/C No : 001002000369 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 04:32:21:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003000', 0, brlength) branch, SUBSTR ('001001003000', brlength+1, schlength) linksno, SUBSTR ('001001003000', -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|003000|SB|1 12-11-2025 04:32:21:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001003000 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 = 003000ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|003000|1 12-11-2025 04:32:21:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPN31612989888' 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, 'AXNPN31612989888','SRINIVASA T R','001001003000','PHONEPE LIMITED-PAYMENT AGGREGATOR ESCROW ACCOUNT', '922020004688715','UTIB0001506','UTIB0SMCBL1',180,'123')TranProcess.cs: Inward_process(): 001001003000 AXNPN31612989888 Status : 000 12-11-2025 04:32:21:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN31612989888|001001003000 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN31612989888|001001003000 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 04:32:31: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 12-11-2025 04:32:31: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 12-11-2025 04:32:31:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPN31613087552' 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, 'AXNPN31613087552','SHIVASHANKAR','001001000623','PHONEPE LIMITED-PAYMENT AGGREGATOR ESCROW ACCOUNT', '922020004688715','UTIB0001506','UTIB0SMCBL1',14056,'123')TranProcess.cs: Inward_process(): 001001000623 AXNPN31613087552 Status : 000 12-11-2025 04:32:31:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN31613087552|001001000623 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN31613087552|001001000623 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 04:32:32:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003316', 0, brlength) branch, SUBSTR ('001001003316', brlength+1, schlength) linksno, SUBSTR ('001001003316', -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|003316|SB|1 12-11-2025 04:32:32:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001003316 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 = 003316ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|003316|1 12-11-2025 04:32:32:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'YESAP53164414391' 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, 'YESAP53164414391','SURESH BABU S R','001001003316','PhonePe Limited', '002261100000025','YESB0000001','UTIB0SMCBL1',2700,'123')TranProcess.cs: Inward_process(): 001001003316 YESAP53164414391 Status : 000 12-11-2025 04:32:32:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : YESAP53164414391|001001003316 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : YESAP53164414391|001001003316 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 04:32:42: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 12-11-2025 04:32:42: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 12-11-2025 04:32:42:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'YESAP53164566970' 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, 'YESAP53164566970','SRI VENKATESHWARA DISTRIBUTORS','001002000369','PhonePe Limited', '002261100000025','YESB0000001','UTIB0SMCBL1',28358,'123')TranProcess.cs: Inward_process(): 001002000369 YESAP53164566970 Status : 000 12-11-2025 04:32:42:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : YESAP53164566970|001002000369 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : YESAP53164566970|001002000369 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 05:18:08: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 12-11-2025 05:18:08: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 12-11-2025 05:18:08:ValidationRequest(): Log:Validation Request DetailsAXNPN31613845381|002001000103 <------------------------Started ValidationRequest CBS A/C No : 002001000103 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 05:31:58: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 12-11-2025 05:31:58: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 12-11-2025 05:31:59:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPN31613845381' 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, 'AXNPN31613845381','MOHAN','002001000103','PHONEPE LIMITED-PAYMENT AGGREGATOR ESCROW ACCOUNT', '922020004688715','UTIB0001506','UTIB0SMCBL1',2035,'123')TranProcess.cs: Inward_process(): 002001000103 AXNPN31613845381 Status : 000 12-11-2025 05:31:59:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN31613845381|002001000103 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN31613845381|002001000103 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 09:27:41:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001001379', 0, brlength) branch, SUBSTR ('001001001379', brlength+1, schlength) linksno, SUBSTR ('001001001379', -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|001379|SB|1 12-11-2025 09:27:41:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001001379 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 = 001379ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|001379|1 12-11-2025 09:27:41:ValidationRequest(): Log:Validation Request DetailsKVBLH00248265592|001001001379 <------------------------Started ValidationRequest CBS A/C No : 001001001379 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 09:32:25:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001001379', 0, brlength) branch, SUBSTR ('001001001379', brlength+1, schlength) linksno, SUBSTR ('001001001379', -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|001379|SB|1 12-11-2025 09:32:25:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001001379 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 = 001379ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|001379|1 12-11-2025 09:32:25:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'KVBLH00248265592' 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, 'KVBLH00248265592','ME','001001001379','SUBBALAKSHMI A', '1783177000000423','KVBL0002101','UTIB0SMCBL1',20000,'123')TranProcess.cs: Inward_process(): 001001001379 KVBLH00248265592 Status : 000 12-11-2025 09:32:25:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : KVBLH00248265592|001001001379 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : KVBLH00248265592|001001001379 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 12:29:22:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003561', 0, brlength) branch, SUBSTR ('001001003561', brlength+1, schlength) linksno, SUBSTR ('001001003561', -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|003561|SB|1 12-11-2025 12:29:22:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001003561 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 = 003561ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|003561|1 12-11-2025 12:29:22:ValidationRequest(): Log:Validation Request DetailsIN42531659996396|001001003561 <------------------------Started ValidationRequest CBS A/C No : 001001003561 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 12:34:12:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003561', 0, brlength) branch, SUBSTR ('001001003561', brlength+1, schlength) linksno, SUBSTR ('001001003561', -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|003561|SB|1 12-11-2025 12:34:12:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001003561 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 = 003561ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|003561|1 12-11-2025 12:34:12:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'IN42531659996396' 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, 'IN42531659996396','SACHIN G V','001001003561','SHRI SIDDAGANGA SWEETS - BAKERY', '777405500004','ICIC0SF0002','UTIB0SMCBL1',60000,'123')TranProcess.cs: Inward_process(): 001001003561 IN42531659996396 Status : 000 12-11-2025 12:34:12:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : IN42531659996396|001001003561 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : IN42531659996396|001001003561 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 14:15:55:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001030001056', 0, brlength) branch, SUBSTR ('001030001056', brlength+1, schlength) linksno, SUBSTR ('001030001056', -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|001056|CHL|1 12-11-2025 14:15:55:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001030001056 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 = 001056ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CHL|001056|1 12-11-2025 14:15:55:ValidationRequest(): Log:Validation Request DetailsFDRLR52025111200152657|001030001056 <------------------------Started ValidationRequest CBS A/C No : 001030001056 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 14:15:56:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001030001056', 0, brlength) branch, SUBSTR ('001030001056', brlength+1, schlength) linksno, SUBSTR ('001030001056', -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|001056|CHL|1 12-11-2025 14:15:56:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001030001056 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 = 001056ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CHL|001056|1 12-11-2025 14:15:56:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'FDRLR52025111200152657' 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, 'FDRLR52025111200152657','NAGENDRA R','001030001056','RAJESHWARI T K', '19900100116748','FDRL0001990','UTIB0SMCBL1',1000000,'123')TranProcess.cs: Inward_process(): 001030001056 FDRLR52025111200152657 Status : 000 12-11-2025 14:15:56:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : FDRLR52025111200152657|001030001056 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : FDRLR52025111200152657|001030001056 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 16:02:11:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001002863', 0, brlength) branch, SUBSTR ('001001002863', brlength+1, schlength) linksno, SUBSTR ('001001002863', -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|002863|SB|1 12-11-2025 16:02:11:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001002863 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 = 002863ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|002863|1 12-11-2025 16:02:11:ValidationRequest(): Log:Validation Request DetailsKKBKH25316673581|001001002863 <------------------------Started ValidationRequest CBS A/C No : 001001002863 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 16:03:23:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001002862', 0, brlength) branch, SUBSTR ('001001002862', brlength+1, schlength) linksno, SUBSTR ('001001002862', -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|002862|SB|1 12-11-2025 16:03:23:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001002862 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 = 002862ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|002862|1 12-11-2025 16:03:23:ValidationRequest(): Log:Validation Request DetailsKKBKH25316673894|001001002862 <------------------------Started ValidationRequest CBS A/C No : 001001002862 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 16:31:53:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001002863', 0, brlength) branch, SUBSTR ('001001002863', brlength+1, schlength) linksno, SUBSTR ('001001002863', -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|002863|SB|1 12-11-2025 16:31:53:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001002863 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 = 002863ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|002863|1 12-11-2025 16:31:53:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'KKBKH25316673581' 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, 'KKBKH25316673581','P VANIMOHAN','001001002863','P V MOHAN KUMAR', '332010204976','KKBK0000958','UTIB0SMCBL1',500,'123')TranProcess.cs: Inward_process(): 001001002863 KKBKH25316673581 Status : 000 12-11-2025 16:31:53:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : KKBKH25316673581|001001002863 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : KKBKH25316673581|001001002863 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 16:32:14:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001002862', 0, brlength) branch, SUBSTR ('001001002862', brlength+1, schlength) linksno, SUBSTR ('001001002862', -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|002862|SB|1 12-11-2025 16:32:14:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001002862 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 = 002862ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|002862|1 12-11-2025 16:32:14:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'KKBKH25316673894' 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, 'KKBKH25316673894','MOHANKUMAR P V','001001002862','P V MOHAN KUMAR', '332010204976','KKBK0000958','UTIB0SMCBL1',500,'123')TranProcess.cs: Inward_process(): 001001002862 KKBKH25316673894 Status : 000 12-11-2025 16:32:14:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : KKBKH25316673894|001001002862 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : KKBKH25316673894|001001002862 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 19:25:10:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('002002000002', 0, brlength) branch, SUBSTR ('002002000002', brlength+1, schlength) linksno, SUBSTR ('002002000002', -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 = 002 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed VINAYAKANAGAR|DEPOSIT|000002|CA|2 12-11-2025 19:25:10:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 002002000002 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) = 'CA' AND depm_no = 000002ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|000002|2 12-11-2025 19:25:10:ValidationRequest(): Log:Validation Request DetailsCIUBH25316054091|002002000002 <------------------------Started ValidationRequest CBS A/C No : 002002000002 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 19:33:40:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('002002000002', 0, brlength) branch, SUBSTR ('002002000002', brlength+1, schlength) linksno, SUBSTR ('002002000002', -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 = 002 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed VINAYAKANAGAR|DEPOSIT|000002|CA|2 12-11-2025 19:33:40:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 002002000002 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) = 'CA' AND depm_no = 000002ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|000002|2 12-11-2025 19:33:40:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'CIUBH25316054091' 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, 'CIUBH25316054091','Tirumala enterprises','002002000002','TIRUMALA ENTERPRISES', '00512020010029366','CIUB0000093','UTIB0SMCBL1',100000,'123')TranProcess.cs: Inward_process(): 002002000002 CIUBH25316054091 Status : 000 12-11-2025 19:33:40:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : CIUBH25316054091|002002000002 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : CIUBH25316054091|002002000002 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 19:39:43:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001000118', 0, brlength) branch, SUBSTR ('001001000118', brlength+1, schlength) linksno, SUBSTR ('001001000118', -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|000118|SB|1 12-11-2025 19:39:43:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001000118 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 = 000118ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|000118|1 12-11-2025 19:39:43:ValidationRequest(): Log:Validation Request DetailsSBIN225316098678|001001000118 <------------------------Started ValidationRequest CBS A/C No : 001001000118 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 12-11-2025 20:02:10:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001000118', 0, brlength) branch, SUBSTR ('001001000118', brlength+1, schlength) linksno, SUBSTR ('001001000118', -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|000118|SB|1 12-11-2025 20:02:10:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001000118 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 = 000118ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|000118|1 12-11-2025 20:02:10:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'SBIN225316098678' 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, 'SBIN225316098678','LR PRASANNA KUMAR','001001000118','SBI LIFE INSURANCE CO LTD', '00000031473914754','SBIN0000539','UTIB0SMCBL1',59003.07,'123')TranProcess.cs: Inward_process(): 001001000118 SBIN225316098678 Status : 000 12-11-2025 20:02:10:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : SBIN225316098678|001001000118 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : SBIN225316098678|001001000118 ------------------------------> <------------------------------------------------------------------------------------------------------------------------>