01-12-2025 01:37:38: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 01-12-2025 01:37:38: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 01-12-2025 01:37:38:ValidationRequest(): Log:Validation Request DetailsAXNPM33564269305|001001001413 <------------------------Started ValidationRequest CBS A/C No : 001001001413 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-12-2025 01:48:11: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 01-12-2025 01:48:11: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 01-12-2025 01:48:11:ValidationRequest(): Log:Validation Request DetailsAXNPM33564601213|001001001138 <------------------------Started ValidationRequest CBS A/C No : 001001001138 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-12-2025 01:49:17: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 01-12-2025 01:49:17: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 01-12-2025 01:49:17:ValidationRequest(): Log:Validation Request DetailsAXNPM33564640229|001001001314 <------------------------Started ValidationRequest CBS A/C No : 001001001314 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-12-2025 02:02:01:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001001413', 0, brlength) branch, SUBSTR ('001001001413', brlength+1, schlength) linksno, SUBSTR ('001001001413', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) 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 |||| 01-12-2025 02:02:01: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 01-12-2025 02:02:01: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 01-12-2025 02:02:01:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM33564269305|001001001413 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM33564269305|001001001413 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 01-12-2025 02:02:18: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.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 |||| 01-12-2025 02:02:18: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 01-12-2025 02:02:18: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 01-12-2025 02:02:18:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM33564601213|001001001138 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM33564601213|001001001138 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 01-12-2025 02:02:18: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 01-12-2025 02:02:18:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001001314 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 01-12-2025 02:02:18:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM33564640229|001001001314 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 111 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM33564640229|001001001314 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 01-12-2025 03:46:36: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 01-12-2025 03:46:36: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 01-12-2025 03:46:36:ValidationRequest(): Log:Validation Request DetailsAXNPN33567934329|001001000623 <------------------------Started ValidationRequest CBS A/C No : 001001000623 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-12-2025 04:02: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 01-12-2025 04:02: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 01-12-2025 04:02:04:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPN33567934329' 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, 'AXNPN33567934329','SHIVASHANKAR','001001000623','PHONEPE LIMITED-PAYMENT AGGREGATOR ESCROW ACCOUNT', '922020004688715','UTIB0001506','UTIB0SMCBL1',13645,'123')TranProcess.cs: Inward_process(): 001001000623 AXNPN33567934329 Status : 000 01-12-2025 04:02:04:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN33567934329|001001000623 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN33567934329|001001000623 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 01-12-2025 05:20:18: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 01-12-2025 05:20:18: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 01-12-2025 05:20:18:ValidationRequest(): Log:Validation Request DetailsAXNPN33569051833|002001000103 <------------------------Started ValidationRequest CBS A/C No : 002001000103 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-12-2025 05:31:15: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 01-12-2025 05:31:15: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 01-12-2025 05:31:15:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXNPN33569051833' 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, 'AXNPN33569051833','MOHAN','002001000103','PHONEPE LIMITED-PAYMENT AGGREGATOR ESCROW ACCOUNT', '922020004688715','UTIB0001506','UTIB0SMCBL1',1740,'123')TranProcess.cs: Inward_process(): 002001000103 AXNPN33569051833 Status : 000 01-12-2025 05:31:15:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN33569051833|002001000103 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPN33569051833|002001000103 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 01-12-2025 09:27:52:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003118', 0, brlength) branch, SUBSTR ('001001003118', brlength+1, schlength) linksno, SUBSTR ('001001003118', -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|003118|SB|1 01-12-2025 09:27:52:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001003118 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 = 003118ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|003118|1 01-12-2025 09:27:52:ValidationRequest(): Log:Validation Request DetailsICMS2512012YPEUX|001001003118 <------------------------Started ValidationRequest CBS A/C No : 001001003118 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-12-2025 09:34:00:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003118', 0, brlength) branch, SUBSTR ('001001003118', brlength+1, schlength) linksno, SUBSTR ('001001003118', -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|003118|SB|1 01-12-2025 09:34:00:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001003118 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 = 003118ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|003118|1 01-12-2025 09:34:00:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'ICMS2512012YPEUX' 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, 'ICMS2512012YPEUX','CHARULATHA UMESH','001001003118','LICIPPBGLR-LIC IPPCELL BENGALURU', '0024102000031684','IBKL0000998','UTIB0SMCBL1',184875,'123')TranProcess.cs: Inward_process(): 001001003118 ICMS2512012YPEUX Status : 000 01-12-2025 09:34:00:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : ICMS2512012YPEUX|001001003118 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : ICMS2512012YPEUX|001001003118 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 01-12-2025 11:00:22:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001002995', 0, brlength) branch, SUBSTR ('001001002995', brlength+1, schlength) linksno, SUBSTR ('001001002995', -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|002995|SB|1 01-12-2025 11:00:22:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001002995 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 = 002995ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|002995|1 01-12-2025 11:00:22:ValidationRequest(): Log:Validation Request DetailsSBINR52025120107685575|001001002995 <------------------------Started ValidationRequest CBS A/C No : 001001002995 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-12-2025 11:00:28:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001002995', 0, brlength) branch, SUBSTR ('001001002995', brlength+1, schlength) linksno, SUBSTR ('001001002995', -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|002995|SB|1 01-12-2025 11:00:28:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001002995 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 = 002995ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|002995|1 01-12-2025 11:00:28:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'SBINR52025120107685575' 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, 'SBINR52025120107685575','RAVI C A','001001002995','AMARNATH O R R', '10705136108','SBIN0007500','UTIB0SMCBL1',600000,'123')TranProcess.cs: Inward_process(): 001001002995 SBINR52025120107685575 Status : 000 01-12-2025 11:00:28:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : SBINR52025120107685575|001001002995 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : SBINR52025120107685575|001001002995 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 01-12-2025 11:11:51:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003922', 0, brlength) branch, SUBSTR ('001001003922', brlength+1, schlength) linksno, SUBSTR ('001001003922', -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|003922|SB|1 01-12-2025 11:11:51:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001003922 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 = 003922ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|003922|1 01-12-2025 11:11:51:ValidationRequest(): Log:Validation Request DetailsICICR52025120100428390|001001003922 <------------------------Started ValidationRequest CBS A/C No : 001001003922 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-12-2025 11:11:53:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001003922', 0, brlength) branch, SUBSTR ('001001003922', brlength+1, schlength) linksno, SUBSTR ('001001003922', -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|003922|SB|1 01-12-2025 11:11:53:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001003922 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 = 003922ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|003922|1 01-12-2025 11:11:53:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'ICICR52025120100428390' 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, 'ICICR52025120100428390','SATHISH R M','001001003922','T R YATHEESH KUMAR', '777401500588','ICIC0007774','UTIB0SMCBL1',600000,'123')TranProcess.cs: Inward_process(): 001001003922 ICICR52025120100428390 Status : 000 01-12-2025 11:11:53:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : ICICR52025120100428390|001001003922 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : ICICR52025120100428390|001001003922 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 01-12-2025 11:31:28:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001042', 0, brlength) branch, SUBSTR ('001002001042', brlength+1, schlength) linksno, SUBSTR ('001002001042', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 002 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001042|CA|1 01-12-2025 11:31:28:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001002001042 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'CA' AND depm_no = 001042ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|001042|1 01-12-2025 11:31:28:ValidationRequest(): Log:Validation Request DetailsCNRBH00092676609|001002001042 <------------------------Started ValidationRequest CBS A/C No : 001002001042 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-12-2025 12:01:16:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001042', 0, brlength) branch, SUBSTR ('001002001042', brlength+1, schlength) linksno, SUBSTR ('001002001042', -aclength) acno FROM (SELECT a.sitp_doublevalue AS iinlenth, a.sitp_longvalue AS iin, b.sitp_doublevalue AS brlength, c.sitp_doublevalue AS schlength, d.sitp_doublevalue AS aclength FROM (SELECT 1 sno, sitp_doublevalue, sitp_longvalue FROM head.siteparameters WHERE sitp_name = 'IIN NUMBER') a, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'BRANCH CODE') b, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'SCHEME CODE') c, (SELECT 1 sno, sitp_doublevalue FROM head.siteparameters WHERE sitp_name = 'ACCOUNT NO') d WHERE a.sno = b.sno AND c.sno = a.sno AND d.sno = a.sno) TranProcess.cs: Fetch Query Row Count dtSplitCBSNo: 1 TranProcess.cs: Linkmain Query SELECT link_type, link_abbrev, bran_name, bran_sno FROM linkmain, MASTER.branch WHERE link_sno = 002 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001042|CA|1 01-12-2025 12:01:16:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001002001042 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (depm_closedyn, 'N') AS closedyn, depm_closedate, depm_smsregyn AS smsreg FROM clientmaster, depositmaster WHERE clms_sno = depm_client AND NVL(depm_closedyn, 'N') = 'N' AND depm_branch = 1 AND TRIM (depm_abbr) = 'CA' AND depm_no = 001042ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|001042|1 01-12-2025 12:01:16:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'CNRBH00092676609' 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, 'CNRBH00092676609','MALLIKARJUNAIAH','001002001042','MALLIKARJUNAIAH', '0699101021487','CNRB0000699','UTIB0SMCBL1',200000,'123')TranProcess.cs: Inward_process(): 001002001042 CNRBH00092676609 Status : 000 01-12-2025 12:01:16:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : CNRBH00092676609|001002001042 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : CNRBH00092676609|001002001042 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 01-12-2025 13:31:42:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001024001056', 0, brlength) branch, SUBSTR ('001024001056', brlength+1, schlength) linksno, SUBSTR ('001024001056', -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 = 024 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|OD|001056|DCL|1 01-12-2025 13:31:42:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001024001056 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) = 'DCL' AND odmt_no = 001056ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|DCL|001056|1 01-12-2025 13:31:42:ValidationRequest(): Log:Validation Request DetailsHDFCH00643207929|001024001056 <------------------------Started ValidationRequest CBS A/C No : 001024001056 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-12-2025 14:01:22:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001024001056', 0, brlength) branch, SUBSTR ('001024001056', brlength+1, schlength) linksno, SUBSTR ('001024001056', -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 = 024 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|OD|001056|DCL|1 01-12-2025 14:01:22:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001024001056 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) = 'DCL' AND odmt_no = 001056ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|DCL|001056|1 01-12-2025 14:01:22:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'HDFCH00643207929' 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, 'HDFCH00643207929','TIPTUR RAMAIAH SETTY RAJU','001024001056','ACUMEN CAPITAL MARKET (I) LTD DSCNB A/C', '57500001272122','HDFC0000240','UTIB0SMCBL1',10000,'123')TranProcess.cs: Inward_process(): 001024001056 HDFCH00643207929 Status : 000 01-12-2025 14:01:22:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : HDFCH00643207929|001024001056 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : HDFCH00643207929|001024001056 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 01-12-2025 14:01:47:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001037000155', 0, brlength) branch, SUBSTR ('001037000155', brlength+1, schlength) linksno, SUBSTR ('001037000155', -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 = 037 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|LOAN|000155|HME|1 01-12-2025 14:01:47:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001037000155 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (loam_closedyn, 'N') AS closedyn, loam_closedate, loam_smsregyn AS smsreg FROM clientmaster, loanmaster WHERE clms_sno = loam_client AND NVL(loam_closedyn, 'N') = 'N' AND loam_branch = 1 AND TRIM (loam_abbr) = 'HME' AND loam_no = 000155ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|HME|000155|1 01-12-2025 14:01:47:ValidationRequest(): Log:Validation Request DetailsKKBKH25335745430|001037000155 <------------------------Started ValidationRequest CBS A/C No : 001037000155 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-12-2025 14:09:00:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001024001040', 0, brlength) branch, SUBSTR ('001024001040', brlength+1, schlength) linksno, SUBSTR ('001024001040', -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 = 024 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|OD|001040|DCL|1 01-12-2025 14:09:00:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001024001040 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) = 'DCL' AND odmt_no = 001040ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|DCL|001040|1 01-12-2025 14:09:00:ValidationRequest(): Log:Validation Request DetailsSBIN425335978877|001024001040 <------------------------Started ValidationRequest CBS A/C No : 001024001040 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-12-2025 14:31:42:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001037000155', 0, brlength) branch, SUBSTR ('001037000155', brlength+1, schlength) linksno, SUBSTR ('001037000155', -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 = 037 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|LOAN|000155|HME|1 01-12-2025 14:31:42:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001037000155 ValidationAcNo.cs: Query TO Fetch() SELECT clms_des, clms_sno, NVL (loam_closedyn, 'N') AS closedyn, loam_closedate, loam_smsregyn AS smsreg FROM clientmaster, loanmaster WHERE clms_sno = loam_client AND NVL(loam_closedyn, 'N') = 'N' AND loam_branch = 1 AND TRIM (loam_abbr) = 'HME' AND loam_no = 000155ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|HME|000155|1 01-12-2025 14:31:42:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'KKBKH25335745430' 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, 'KKBKH25335745430','AYESHA SADIQ ACCOUNT','001037000155','S N ROADWAYS', '5646100145','KKBK0000958','UTIB0SMCBL1',50000,'123')TranProcess.cs: Inward_process(): 001037000155 KKBKH25335745430 Status : 000 01-12-2025 14:31:42:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : KKBKH25335745430|001037000155 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : KKBKH25335745430|001037000155 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 01-12-2025 14:33:48:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001024001040', 0, brlength) branch, SUBSTR ('001024001040', brlength+1, schlength) linksno, SUBSTR ('001024001040', -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 = 024 AND bran_sno = 001 TranProcess.cs: Linkmain Query Row Count dtTemp: 1 ShowCBS Ac No Proce Executed HEAD OFFICE|OD|001040|DCL|1 01-12-2025 14:33:48:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001024001040 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) = 'DCL' AND odmt_no = 001040ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|DCL|001040|1 01-12-2025 14:33:48:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'SBIN425335978877' 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, 'SBIN425335978877','shashishekara gupta B N','001024001040','Mr B N Shashishekara Gupta', '00000037610530792','SBIN0040097','UTIB0SMCBL1',100000,'123')TranProcess.cs: Inward_process(): 001024001040 SBIN425335978877 Status : 000 01-12-2025 14:33:48:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : SBIN425335978877|001024001040 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : SBIN425335978877|001024001040 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 01-12-2025 15:55:19:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001000015', 0, brlength) branch, SUBSTR ('001001000015', brlength+1, schlength) linksno, SUBSTR ('001001000015', -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|000015|SB|1 01-12-2025 15:55:19:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001000015 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 = 000015ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|000015|1 01-12-2025 15:55:19:ValidationRequest(): Log:Validation Request DetailsCIUBH25335087780|001001000015 <------------------------Started ValidationRequest CBS A/C No : 001001000015 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-12-2025 16:07:14:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001001000015', 0, brlength) branch, SUBSTR ('001001000015', brlength+1, schlength) linksno, SUBSTR ('001001000015', -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|000015|SB|1 01-12-2025 16:07:14:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001001000015 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 = 000015ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|SB|000015|1 01-12-2025 16:07:15:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'CIUBH25335087780' 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, 'CIUBH25335087780','SRIDEVI D N','001001000015','DEFINE CREDIT CO OPERATIVE SOCIETY', '00512120020111027','CIUB0000855','UTIB0SMCBL1',6375,'123')TranProcess.cs: Inward_process(): 001001000015 CIUBH25335087780 Status : 000 01-12-2025 16:07:15:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : CIUBH25335087780|001001000015 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : CIUBH25335087780|001001000015 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 01-12-2025 17:59:38:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001217', 0, brlength) branch, SUBSTR ('001002001217', brlength+1, schlength) linksno, SUBSTR ('001002001217', -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|001217|CA|1 01-12-2025 17:59:38:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001002001217 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 = 001217ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|001217|1 01-12-2025 17:59:38:ValidationRequest(): Log:Validation Request Details1201i29627522301|001002001217 <------------------------Started ValidationRequest CBS A/C No : 001002001217 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-12-2025 18:10:14:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001002001217', 0, brlength) branch, SUBSTR ('001002001217', brlength+1, schlength) linksno, SUBSTR ('001002001217', -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|001217|CA|1 01-12-2025 18:10:14:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001002001217 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 = 001217ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CA|001217|1 01-12-2025 18:10:14:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = '1201i29627522301' 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, '1201i29627522301','DIYA ENTERPRISES','001002001217','ESHWAR', '1938102000004459','IBKL0NEFT01','UTIB0SMCBL1',70000,'123')TranProcess.cs: Inward_process(): 001002001217 1201i29627522301 Status : 000 01-12-2025 18:10:14:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 1201i29627522301|001002001217 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : 1201i29627522301|001002001217 ------------------------------> <------------------------------------------------------------------------------------------------------------------------> 01-12-2025 22:53:40:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001030001123', 0, brlength) branch, SUBSTR ('001030001123', brlength+1, schlength) linksno, SUBSTR ('001030001123', -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|001123|CHL|1 01-12-2025 22:53:40:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001030001123 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 = 001123ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CHL|001123|1 01-12-2025 22:53:40:ValidationRequest(): Log:Validation Request DetailsAXOMB33502258719|001030001123 <------------------------Started ValidationRequest CBS A/C No : 001030001123 ------------------------> <------------------------------------------------------------------------------------------------------------------------> ValidationRequest Execution Success with response : 000 <------------------------------------------------------------------------------------------------------------------------> 01-12-2025 23:02:09:ShowCBSAcNo(). Log: TranProcess.cs: ShowCBSAcNo() Query: SELECT SUBSTR ('001030001123', 0, brlength) branch, SUBSTR ('001030001123', brlength+1, schlength) linksno, SUBSTR ('001030001123', -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|001123|CHL|1 01-12-2025 23:02:09:Validation Account Proce Executed with out error <------------------------------------------------------------------------------------------------------------------------> ValidateAcNo CBS A/C No : 001030001123 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 = 001123ValidationAcNo.cs: Closedyn Query Row count1<------------------------------------------------------------------------------------------------------------------------> Y|CHL|001123|1 01-12-2025 23:02:09:TranProcess.cs: Inward_process() UTR ValidationSELECT remit_utr FROM rtgsinwardrequest WHERE Trim(remit_utr) = 'AXOMB33502258719' 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, 'AXOMB33502258719','B R Dayananda Swamy','001030001123','HARSHA ELECTRICALS', '914020021370973','UTIB0001123','UTIB0SMCBL1',227000,'123')TranProcess.cs: Inward_process(): 001030001123 AXOMB33502258719 Status : 000 01-12-2025 23:02:09:<------------------------------------------------------------------------------------------------------------------------> <-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXOMB33502258719|001030001123 --------------------------> <------------------------------------------------------------------------------------------------------------------------> ConfirmationReq Execution Success with Status 000 <-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXOMB33502258719|001030001123 ------------------------------> <------------------------------------------------------------------------------------------------------------------------>