29-05-2025 18:03:03:<------------------------Started ValidationRequest CBS A/C No : 0000001001012345 ------------------------> 29-05-2025 18:03:03:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 18:03:03:Connection Establisment started 29-05-2025 18:03:03:Connection Read From File : Status OK 29-05-2025 18:03:03:Validation Account Proce error System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. at System.Data.OracleClient.OCI.DetermineClientVersion() 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.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 52 29-05-2025 18:03:03:Validation Account Proce Executed with out error System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. at System.Data.OracleClient.OCI.DetermineClientVersion() 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.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 52 29-05-2025 18:03:03:Error ValidationRequest System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. at System.Data.OracleClient.OCI.DetermineClientVersion() 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.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 52 29-05-2025 18:03:03:ValidationRequest Exccution Success with response : 111 29-05-2025 18:03:03:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 18:35:20:<------------------------Started ValidationRequest CBS A/C No : 001001009761 ------------------------> 29-05-2025 18:35:20:<------------------------Started ValidationRequest CBS A/C No : 001001011946 ------------------------> 29-05-2025 18:35:20:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 18:35:20:Connection Establisment started 29-05-2025 18:35:20:Connection Read From File : Status OK 29-05-2025 18:35:20:Connection Establisment started 29-05-2025 18:35:20:Connection Read From File : Status OK 29-05-2025 18:35:20:Validation Account Proce error System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. at System.Data.ProviderBase.DbConnectionPool.GetConnection(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.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.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OracleClient.OracleConnection.Open() at SSLWCF.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 52 29-05-2025 18:35:20:Validation Account Proce Executed with out error System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. at System.Data.ProviderBase.DbConnectionPool.GetConnection(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.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.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OracleClient.OracleConnection.Open() at SSLWCF.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 52 29-05-2025 18:35:20:Error ValidationRequest System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. at System.Data.ProviderBase.DbConnectionPool.GetConnection(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.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.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OracleClient.OracleConnection.Open() at SSLWCF.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 52 29-05-2025 18:35:20:ValidationRequest Exccution Success with response : 111 29-05-2025 18:35:20:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 18:35:20:Validation Account Proce error System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. at System.Data.ProviderBase.DbConnectionPool.GetConnection(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.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.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OracleClient.OracleConnection.Open() at SSLWCF.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 52 29-05-2025 18:35:20:Validation Account Proce Executed with out error System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. at System.Data.ProviderBase.DbConnectionPool.GetConnection(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.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.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OracleClient.OracleConnection.Open() at SSLWCF.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 52 29-05-2025 18:35:20:Error ValidationRequest System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. at System.Data.ProviderBase.DbConnectionPool.GetConnection(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.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.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) at System.Data.OracleClient.OracleConnection.Open() at SSLWCF.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 52 29-05-2025 18:35:20:ValidationRequest Exccution Success with response : 111 29-05-2025 18:35:20:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 18:35:21:<------------------------Started ValidationRequest CBS A/C No : 001001009916 ------------------------> 29-05-2025 18:35:21:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 18:35:21:Connection Establisment started 29-05-2025 18:35:21:Connection Read From File : Status OK 29-05-2025 18:35:21:Validation Account Proce error System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. 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.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 52 29-05-2025 18:35:21:Validation Account Proce Executed with out error System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. 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.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 52 29-05-2025 18:35:21:Error ValidationRequest System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. 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.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 52 29-05-2025 18:35:21:ValidationRequest Exccution Success with response : 111 29-05-2025 18:35:21:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 18:35:22:<------------------------Started ValidationRequest CBS A/C No : 001001009761 ------------------------> 29-05-2025 18:35:22:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 18:35:22:Connection Establisment started 29-05-2025 18:35:22:Connection Read From File : Status OK 29-05-2025 18:35:22:Validation Account Proce error System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. 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.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 52 29-05-2025 18:35:22:Validation Account Proce Executed with out error System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. 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.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 52 29-05-2025 18:35:22:Error ValidationRequest System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. 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.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 52 29-05-2025 18:35:22:ValidationRequest Exccution Success with response : 111 29-05-2025 18:35:22:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 18:35:23:<------------------------Started ValidationRequest CBS A/C No : 001001011946 ------------------------> 29-05-2025 18:35:23:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 18:35:23:Connection Establisment started 29-05-2025 18:35:23:Connection Read From File : Status OK 29-05-2025 18:35:23:Validation Account Proce error System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. 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.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 52 29-05-2025 18:35:23:Validation Account Proce Executed with out error System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. 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.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 52 29-05-2025 18:35:23:Error ValidationRequest System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. 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.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 52 29-05-2025 18:35:23:ValidationRequest Exccution Success with response : 111 29-05-2025 18:35:23:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 18:35:27:<------------------------Started ValidationRequest CBS A/C No : 001001001118 ------------------------> 29-05-2025 18:35:27:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 18:35:27:Connection Establisment started 29-05-2025 18:35:27:Connection Read From File : Status OK 29-05-2025 18:35:27:Validation Account Proce error System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. at System.Data.OracleClient.OCI.DetermineClientVersion() 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.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 52 29-05-2025 18:35:27:Validation Account Proce Executed with out error System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. at System.Data.OracleClient.OCI.DetermineClientVersion() 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.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 52 29-05-2025 18:35:27:Error ValidationRequest System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. at System.Data.OracleClient.OCI.DetermineClientVersion() 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.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 52 29-05-2025 18:35:27:ValidationRequest Exccution Success with response : 111 29-05-2025 18:35:27:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 18:35:27:<------------------------Started ValidationRequest CBS A/C No : 001001010115 ------------------------> 29-05-2025 18:35:27:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 18:35:27:Connection Establisment started 29-05-2025 18:35:27:Connection Read From File : Status OK 29-05-2025 18:35:27:Validation Account Proce error System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. 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.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 52 29-05-2025 18:35:27:Validation Account Proce Executed with out error System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. 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.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 52 29-05-2025 18:35:27:Error ValidationRequest System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. 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.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 52 29-05-2025 18:35:27:ValidationRequest Exccution Success with response : 111 29-05-2025 18:35:27:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 18:35:30:<------------------------Started ValidationRequest CBS A/C No : 001001003241 ------------------------> 29-05-2025 18:35:30:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 18:35:30:Connection Establisment started 29-05-2025 18:35:30:Connection Read From File : Status OK 29-05-2025 18:35:30:Validation Account Proce error System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. 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.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 52 29-05-2025 18:35:30:Validation Account Proce Executed with out error System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. 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.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 52 29-05-2025 18:35:30:Error ValidationRequest System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. 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.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 52 29-05-2025 18:35:30:ValidationRequest Exccution Success with response : 111 29-05-2025 18:35:30:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 18:37:19:<------------------------Started ValidationRequest CBS A/C No : 001001009438 ------------------------> 29-05-2025 18:37:19:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 18:37:19:Connection Establisment started 29-05-2025 18:37:19:Connection Read From File : Status OK 29-05-2025 18:37:19:Validation Account Proce error System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. at System.Data.OracleClient.OCI.DetermineClientVersion() 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.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 52 29-05-2025 18:37:19:Validation Account Proce Executed with out error System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. at System.Data.OracleClient.OCI.DetermineClientVersion() 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.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 52 29-05-2025 18:37:19:Error ValidationRequest System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. at System.Data.OracleClient.OCI.DetermineClientVersion() 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.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 52 29-05-2025 18:37:19:ValidationRequest Exccution Success with response : 111 29-05-2025 18:37:19:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 18:37:20:<------------------------Started ValidationRequest CBS A/C No : 002001000468 ------------------------> 29-05-2025 18:37:20:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 18:37:20:Connection Establisment started 29-05-2025 18:37:20:Connection Read From File : Status OK 29-05-2025 18:37:20:Validation Account Proce error System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. 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.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 52 29-05-2025 18:37:20:Validation Account Proce Executed with out error System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. 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.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 52 29-05-2025 18:37:20:Error ValidationRequest System.Exception: System.Data.OracleClient requires Oracle client software version 8.1.7 or greater. 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.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 52 29-05-2025 18:37:20:ValidationRequest Exccution Success with response : 111 29-05-2025 18:37:20:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 18:56:25:<------------------------Started ValidationRequest CBS A/C No : 0000001001012345 ------------------------> 29-05-2025 18:56:25:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 18:56:25:Connection Establisment started 29-05-2025 18:56:25:Connection Read From File : Status OK 29-05-2025 18:56:25:Validation Account Proce error System.InvalidOperationException: Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed. ---> System.BadImageFormatException: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B) at System.Data.Common.UnsafeNativeMethods.OCILobCopy2(IntPtr svchp, IntPtr errhp, IntPtr dst_locp, IntPtr src_locp, UInt64 amount, UInt64 dst_offset, UInt64 src_offset) at System.Data.OracleClient.OCI.DetermineClientVersion() --- End of inner exception stack trace --- at System.Data.OracleClient.OCI.DetermineClientVersion() 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.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 52 29-05-2025 18:56:25:Validation Account Proce Executed with out error System.InvalidOperationException: Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed. ---> System.BadImageFormatException: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B) at System.Data.Common.UnsafeNativeMethods.OCILobCopy2(IntPtr svchp, IntPtr errhp, IntPtr dst_locp, IntPtr src_locp, UInt64 amount, UInt64 dst_offset, UInt64 src_offset) at System.Data.OracleClient.OCI.DetermineClientVersion() --- End of inner exception stack trace --- at System.Data.OracleClient.OCI.DetermineClientVersion() 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.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 52 29-05-2025 18:56:25:Error ValidationRequest System.InvalidOperationException: Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed. ---> System.BadImageFormatException: An attempt was made to load a program with an incorrect format. (Exception from HRESULT: 0x8007000B) at System.Data.Common.UnsafeNativeMethods.OCILobCopy2(IntPtr svchp, IntPtr errhp, IntPtr dst_locp, IntPtr src_locp, UInt64 amount, UInt64 dst_offset, UInt64 src_offset) at System.Data.OracleClient.OCI.DetermineClientVersion() --- End of inner exception stack trace --- at System.Data.OracleClient.OCI.DetermineClientVersion() 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.TranProcess.OpenConn() in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 44 at SSLWCF.TranProcess.ValidateAcNo(String CbsNo) in F:\DARSHAN\SSLWCF_64BIT\SSLWCF\TranProcess.cs:line 52 29-05-2025 18:56:25:ValidationRequest Exccution Success with response : 111 29-05-2025 18:56:25:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 19:01:42:<------------------------Started ValidationRequest CBS A/C No : 0000001001012345 ------------------------> 29-05-2025 19:01:42:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 19:01:42:Connection Establisment started 29-05-2025 19:01:42:Connection Read From File : Status OK 29-05-2025 19:01:43:Connection Successfully Opened : Status OK 29-05-2025 19:01:43:ValidateAcNo CBS A/C No : 0000001001012345 29-05-2025 19:01:43:Validation Account Proce Executed with out error N 29-05-2025 19:01:43:ValidationRequest Exccution Success with response : 111 29-05-2025 19:01:43:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 19:05:25:<------------------------Started ValidationRequest CBS A/C No : 001001010115 ------------------------> 29-05-2025 19:05:25:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 19:05:25:Connection Establisment started 29-05-2025 19:05:25:Connection Read From File : Status OK 29-05-2025 19:05:25:Connection Successfully Opened : Status OK 29-05-2025 19:05:25:ValidateAcNo CBS A/C No : 001001010115 29-05-2025 19:05:25:CBS A/C No : 001001010115 29-05-2025 19:05:25:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 29-05-2025 19:05:25:Record Count : 1 29-05-2025 19:05:25:BRLENGTH 3 29-05-2025 19:05:25:SCHLENGTH 3 29-05-2025 19:05:25:ACLENGTH 6 29-05-2025 19:05:25:Branch Code 3 29-05-2025 19:05:25:Scheme Code 3 29-05-2025 19:05:25:Account No 3 29-05-2025 19:05:25:Link Main Started 29-05-2025 19:05:25:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 29-05-2025 19:05:25:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 29-05-2025 19:05:25:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|010115|SB |001 29-05-2025 19:05:25:Validation Account Proce Executed with out error Y 29-05-2025 19:05:25:ValidationRequest Exccution Success with response : 000 29-05-2025 19:05:25:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 19:25:26:<------------------------Started ValidationRequest CBS A/C No : 001001001118 ------------------------> 29-05-2025 19:25:26:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 19:25:26:Connection Establisment started 29-05-2025 19:25:26:Connection Read From File : Status OK 29-05-2025 19:25:26:Connection Successfully Opened : Status OK 29-05-2025 19:25:26:ValidateAcNo CBS A/C No : 001001001118 29-05-2025 19:25:26:CBS A/C No : 001001001118 29-05-2025 19:25:26:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 29-05-2025 19:25:26:Record Count : 1 29-05-2025 19:25:26:BRLENGTH 3 29-05-2025 19:25:26:SCHLENGTH 3 29-05-2025 19:25:26:ACLENGTH 6 29-05-2025 19:25:26:Branch Code 3 29-05-2025 19:25:26:Scheme Code 3 29-05-2025 19:25:26:Account No 3 29-05-2025 19:25:26:Link Main Started 29-05-2025 19:25:26:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 29-05-2025 19:25:26:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 29-05-2025 19:25:26:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001118|SB |001 29-05-2025 19:25:26:Validation Account Proce Executed with out error Y 29-05-2025 19:25:26:ValidationRequest Exccution Success with response : 000 29-05-2025 19:25:26:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 19:25:28:<------------------------Started ValidationRequest CBS A/C No : 001001003241 ------------------------> 29-05-2025 19:25:28:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 19:25:28:Connection Establisment started 29-05-2025 19:25:28:Connection Read From File : Status OK 29-05-2025 19:25:29:Connection Successfully Opened : Status OK 29-05-2025 19:25:29:ValidateAcNo CBS A/C No : 001001003241 29-05-2025 19:25:29:CBS A/C No : 001001003241 29-05-2025 19:25:29:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 29-05-2025 19:25:29:Record Count : 1 29-05-2025 19:25:29:BRLENGTH 3 29-05-2025 19:25:29:SCHLENGTH 3 29-05-2025 19:25:29:ACLENGTH 6 29-05-2025 19:25:29:Branch Code 3 29-05-2025 19:25:29:Scheme Code 3 29-05-2025 19:25:29:Account No 3 29-05-2025 19:25:29:Link Main Started 29-05-2025 19:25:29:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 29-05-2025 19:25:29:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 29-05-2025 19:25:29:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|003241|SB |001 29-05-2025 19:25:29:Validation Account Proce Executed with out error Y 29-05-2025 19:25:29:ValidationRequest Exccution Success with response : 000 29-05-2025 19:25:29:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 19:25:32:<------------------------Started ValidationRequest CBS A/C No : 001001011946 ------------------------> 29-05-2025 19:25:32:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 19:25:32:Connection Establisment started 29-05-2025 19:25:32:Connection Read From File : Status OK 29-05-2025 19:25:32:Connection Successfully Opened : Status OK 29-05-2025 19:25:32:ValidateAcNo CBS A/C No : 001001011946 29-05-2025 19:25:32:CBS A/C No : 001001011946 29-05-2025 19:25:32:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 29-05-2025 19:25:32:Record Count : 1 29-05-2025 19:25:32:BRLENGTH 3 29-05-2025 19:25:32:SCHLENGTH 3 29-05-2025 19:25:32:ACLENGTH 6 29-05-2025 19:25:32:Branch Code 3 29-05-2025 19:25:32:Scheme Code 3 29-05-2025 19:25:32:Account No 3 29-05-2025 19:25:32:Link Main Started 29-05-2025 19:25:32:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 29-05-2025 19:25:32:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 29-05-2025 19:25:32:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|011946|SB |001 29-05-2025 19:25:32:Validation Account Proce Executed with out error Y 29-05-2025 19:25:32:ValidationRequest Exccution Success with response : 000 29-05-2025 19:25:32:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 19:30:05:<------------------------Started ValidationRequest CBS A/C No : 001002000868 ------------------------> 29-05-2025 19:30:05:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 19:30:05:Connection Establisment started 29-05-2025 19:30:05:Connection Read From File : Status OK 29-05-2025 19:30:05:Connection Successfully Opened : Status OK 29-05-2025 19:30:05:ValidateAcNo CBS A/C No : 001002000868 29-05-2025 19:30:05:CBS A/C No : 001002000868 29-05-2025 19:30:05:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 29-05-2025 19:30:05:Record Count : 1 29-05-2025 19:30:05:BRLENGTH 3 29-05-2025 19:30:05:SCHLENGTH 3 29-05-2025 19:30:05:ACLENGTH 6 29-05-2025 19:30:05:Branch Code 3 29-05-2025 19:30:05:Scheme Code 3 29-05-2025 19:30:05:Account No 3 29-05-2025 19:30:05:Link Main Started 29-05-2025 19:30:05:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 29-05-2025 19:30:05:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 29-05-2025 19:30:05:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000868|CD |001 29-05-2025 19:30:05:Validation Account Proce Executed with out error Y 29-05-2025 19:30:05:ValidationRequest Exccution Success with response : 000 29-05-2025 19:30:05:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 19:41:57:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM14953710840|001001010115 --------------------------> 29-05-2025 19:41:57:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 19:41:57:Connection Establisment started 29-05-2025 19:41:57:Connection Read From File : Status OK 29-05-2025 19:41:57:Connection Successfully Opened : Status OK 29-05-2025 19:41:57:ValidateAcNo CBS A/C No : 001001010115 29-05-2025 19:41:57:CBS A/C No : 001001010115 29-05-2025 19:41:57:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 29-05-2025 19:41:57:Record Count : 1 29-05-2025 19:41:57:BRLENGTH 3 29-05-2025 19:41:57:SCHLENGTH 3 29-05-2025 19:41:57:ACLENGTH 6 29-05-2025 19:41:57:Branch Code 3 29-05-2025 19:41:57:Scheme Code 3 29-05-2025 19:41:57:Account No 3 29-05-2025 19:41:57:Link Main Started 29-05-2025 19:41:57:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 29-05-2025 19:41:57:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 29-05-2025 19:41:57:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|010115|SB |001 29-05-2025 19:41:57:Validation Account Proce Executed with out error Y 29-05-2025 19:41:57:Connection Establisment started 29-05-2025 19:41:57:Connection Read From File : Status OK 29-05-2025 19:41:57:Connection Successfully Opened : Status OK 29-05-2025 19:41:57:CBS A/C No : 001001010115 29-05-2025 19:41:57:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 29-05-2025 19:41:57:Record Count : 1 29-05-2025 19:41:57:BRLENGTH 3 29-05-2025 19:41:57:SCHLENGTH 3 29-05-2025 19:41:57:ACLENGTH 6 29-05-2025 19:41:57:Branch Code 3 29-05-2025 19:41:57:Scheme Code 3 29-05-2025 19:41:57:Account No 3 29-05-2025 19:41:57:Link Main Started 29-05-2025 19:41:57:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 29-05-2025 19:41:57:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 29-05-2025 19:41:57:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|010115|SB |001 29-05-2025 19:41:57:Vno --->:67436 29-05-2025 19:41:57:Current Date --->:29-05-2025 29-05-2025 19:41:57:calling CallNewRtgsBothProc 29-05-2025 19:41:57:Parameters passing - InwardAuthorise 29-05-2025 19:41:57: brn =001 29-05-2025 19:41:57: acno =010115 29-05-2025 19:41:57: abbr =SB 29-05-2025 19:41:57: amt.ToString() =3190 29-05-2025 19:41:57: traceNo =67436 29-05-2025 19:41:57: narr =NEFT, BY ONE 97 COMMUNICATIONS LIMITED ESCROW ACCOUNT _01 UTIB0000022 924020007330961 29-05-2025 19:41:57:Transaction Process : BEFORE CAL PROC: 29-05-2025 19:41:58:cbs no--->001001010115 29-05-2025 19:41:58:CBS A/C No : 001001010115 29-05-2025 19:41:58:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 29-05-2025 19:41:58:Record Count : 1 29-05-2025 19:41:58:BRLENGTH 3 29-05-2025 19:41:58:SCHLENGTH 3 29-05-2025 19:41:58:ACLENGTH 6 29-05-2025 19:41:58:Branch Code 3 29-05-2025 19:41:58:Scheme Code 3 29-05-2025 19:41:58:Account No 3 29-05-2025 19:41:58:Link Main Started 29-05-2025 19:41:58:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 29-05-2025 19:41:58:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 29-05-2025 19:41:58:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|010115|SB |001 29-05-2025 19:41:58:Closed YN quier --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG,DSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,depositmaster,depositschemesetup,ADDRESS where CLMS_SNO=DEPM_CLIENT AND DSCH_BRANCH = DEPM_BRANCH AND DSCH_ABBR = DEPM_ABBR and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB' AND DEPM_NO=010115 AND ADDR_SNO=CLMS_ADDRESS union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG,LSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,LOANMASTER,LOANSCHEMESETUP,ADDRESS where CLMS_SNO=LOAM_CLIENT AND LSCH_BRANCH = LOAM_BRANCH AND LSCH_ABBREV = LOAM_ABBR and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='SB' AND LOAM_NO=010115 AND ADDR_SNO=CLMS_ADDRESS UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG,ODST_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,ODMASTER,ODSCHEMESETUP,ADDRESS where CLMS_SNO=ODMT_CLIENT AND ODST_BRANCH = ODMT_BRANCH AND ODST_ABBR = ODMT_ABBR and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='SB' AND ODMT_NO=010115 AND ADDR_SNO=CLMS_ADDRESS 29-05-2025 19:41:58:closed y n Record count --->1 29-05-2025 19:41:58:SMS Inserted for Mobile Number : +919902069158 29-05-2025 19:41:58:Inward Process Executed Sussefully 29-05-2025 19:41:58:ConfirmationReq Execution Success with Status 000 29-05-2025 19:41:58:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM14953710840|001001010115 ------------------------------> 29-05-2025 19:41:58:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 19:45:41:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM14953773865|001001011946 --------------------------> 29-05-2025 19:45:41:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 19:45:41:Connection Establisment started 29-05-2025 19:45:41:Connection Read From File : Status OK 29-05-2025 19:45:41:Connection Successfully Opened : Status OK 29-05-2025 19:45:41:ValidateAcNo CBS A/C No : 001001011946 29-05-2025 19:45:41:CBS A/C No : 001001011946 29-05-2025 19:45:41:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 29-05-2025 19:45:41:Record Count : 1 29-05-2025 19:45:41:BRLENGTH 3 29-05-2025 19:45:41:SCHLENGTH 3 29-05-2025 19:45:41:ACLENGTH 6 29-05-2025 19:45:41:Branch Code 3 29-05-2025 19:45:41:Scheme Code 3 29-05-2025 19:45:41:Account No 3 29-05-2025 19:45:41:Link Main Started 29-05-2025 19:45:41:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 29-05-2025 19:45:41:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 29-05-2025 19:45:41:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|011946|SB |001 29-05-2025 19:45:41:Validation Account Proce Executed with out error Y 29-05-2025 19:45:41:Connection Establisment started 29-05-2025 19:45:41:Connection Read From File : Status OK 29-05-2025 19:45:41:Connection Successfully Opened : Status OK 29-05-2025 19:45:41:CBS A/C No : 001001011946 29-05-2025 19:45:41:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 29-05-2025 19:45:41:Record Count : 1 29-05-2025 19:45:41:BRLENGTH 3 29-05-2025 19:45:41:SCHLENGTH 3 29-05-2025 19:45:41:ACLENGTH 6 29-05-2025 19:45:41:Branch Code 3 29-05-2025 19:45:41:Scheme Code 3 29-05-2025 19:45:41:Account No 3 29-05-2025 19:45:41:Link Main Started 29-05-2025 19:45:41:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 29-05-2025 19:45:41:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 29-05-2025 19:45:41:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|011946|SB |001 29-05-2025 19:45:41:Vno --->:67437 29-05-2025 19:45:41:Current Date --->:29-05-2025 29-05-2025 19:45:41:calling CallNewRtgsBothProc 29-05-2025 19:45:41:Parameters passing - InwardAuthorise 29-05-2025 19:45:41: brn =001 29-05-2025 19:45:41: acno =011946 29-05-2025 19:45:41: abbr =SB 29-05-2025 19:45:41: amt.ToString() =1203 29-05-2025 19:45:41: traceNo =67437 29-05-2025 19:45:41: narr =NEFT, BY ONE 97 COMMUNICATIONS LIMITED ESCROW ACCOUNT _01 UTIB0000022 924020007330961 29-05-2025 19:45:41:Transaction Process : BEFORE CAL PROC: 29-05-2025 19:45:41:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM14953772517|001001003241 --------------------------> 29-05-2025 19:45:41:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 19:45:41:Connection Establisment started 29-05-2025 19:45:41:Connection Read From File : Status OK 29-05-2025 19:45:41:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM14953773855|001001001118 --------------------------> 29-05-2025 19:45:41:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 19:45:41:Connection Establisment started 29-05-2025 19:45:41:Connection Read From File : Status OK 29-05-2025 19:45:41:Connection Successfully Opened : Status OK 29-05-2025 19:45:41:ValidateAcNo CBS A/C No : 001001003241 29-05-2025 19:45:41:CBS A/C No : 001001003241 29-05-2025 19:45:41:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 29-05-2025 19:45:41:Record Count : 1 29-05-2025 19:45:41:BRLENGTH 3 29-05-2025 19:45:41:SCHLENGTH 3 29-05-2025 19:45:41:ACLENGTH 6 29-05-2025 19:45:41:Branch Code 3 29-05-2025 19:45:41:Scheme Code 3 29-05-2025 19:45:41:Account No 3 29-05-2025 19:45:41:Link Main Started 29-05-2025 19:45:41:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 29-05-2025 19:45:41:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 29-05-2025 19:45:41:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|003241|SB |001 29-05-2025 19:45:41:Validation Account Proce Executed with out error Y 29-05-2025 19:45:41:Connection Establisment started 29-05-2025 19:45:41:Connection Read From File : Status OK 29-05-2025 19:45:41:Connection Successfully Opened : Status OK 29-05-2025 19:45:41:CBS A/C No : 001001003241 29-05-2025 19:45:41:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 29-05-2025 19:45:41:Record Count : 1 29-05-2025 19:45:41:BRLENGTH 3 29-05-2025 19:45:41:SCHLENGTH 3 29-05-2025 19:45:41:ACLENGTH 6 29-05-2025 19:45:41:Branch Code 3 29-05-2025 19:45:41:Scheme Code 3 29-05-2025 19:45:41:Account No 3 29-05-2025 19:45:41:Link Main Started 29-05-2025 19:45:41:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 29-05-2025 19:45:41:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 29-05-2025 19:45:41:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|003241|SB |001 29-05-2025 19:45:41:Inward Process Executed Sussefully 29-05-2025 19:45:41:ConfirmationReq Execution Success with Status 000 29-05-2025 19:45:41:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM14953773865|001001011946 ------------------------------> 29-05-2025 19:45:41:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 19:45:41:Vno --->:67438 29-05-2025 19:45:41:Current Date --->:29-05-2025 29-05-2025 19:45:41:calling CallNewRtgsBothProc 29-05-2025 19:45:41:Parameters passing - InwardAuthorise 29-05-2025 19:45:41: brn =001 29-05-2025 19:45:41: acno =003241 29-05-2025 19:45:41: abbr =SB 29-05-2025 19:45:41: amt.ToString() =17 29-05-2025 19:45:41: traceNo =67438 29-05-2025 19:45:41: narr =NEFT, BY ONE 97 COMMUNICATIONS LIMITED ESCROW ACCOUNT _01 UTIB0000022 924020007330961 29-05-2025 19:45:41:Transaction Process : BEFORE CAL PROC: 29-05-2025 19:45:41:Connection Successfully Opened : Status OK 29-05-2025 19:45:41:ValidateAcNo CBS A/C No : 001001001118 29-05-2025 19:45:41:CBS A/C No : 001001001118 29-05-2025 19:45:41:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 29-05-2025 19:45:41:Record Count : 1 29-05-2025 19:45:41:BRLENGTH 3 29-05-2025 19:45:41:SCHLENGTH 3 29-05-2025 19:45:41:ACLENGTH 6 29-05-2025 19:45:41:Branch Code 3 29-05-2025 19:45:41:Scheme Code 3 29-05-2025 19:45:41:Account No 3 29-05-2025 19:45:41:Link Main Started 29-05-2025 19:45:41:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 29-05-2025 19:45:41:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 29-05-2025 19:45:41:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001118|SB |001 29-05-2025 19:45:41:Validation Account Proce Executed with out error Y 29-05-2025 19:45:41:Connection Establisment started 29-05-2025 19:45:41:Connection Read From File : Status OK 29-05-2025 19:45:41:Connection Successfully Opened : Status OK 29-05-2025 19:45:41:CBS A/C No : 001001001118 29-05-2025 19:45:41:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 29-05-2025 19:45:41:Record Count : 1 29-05-2025 19:45:41:BRLENGTH 3 29-05-2025 19:45:41:SCHLENGTH 3 29-05-2025 19:45:41:ACLENGTH 6 29-05-2025 19:45:41:Branch Code 3 29-05-2025 19:45:41:Scheme Code 3 29-05-2025 19:45:41:Account No 3 29-05-2025 19:45:41:Link Main Started 29-05-2025 19:45:41:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 29-05-2025 19:45:41:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 29-05-2025 19:45:41:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001118|SB |001 29-05-2025 19:45:41:Vno --->:67439 29-05-2025 19:45:41:Current Date --->:29-05-2025 29-05-2025 19:45:41:calling CallNewRtgsBothProc 29-05-2025 19:45:41:Parameters passing - InwardAuthorise 29-05-2025 19:45:41: brn =001 29-05-2025 19:45:41: acno =001118 29-05-2025 19:45:41: abbr =SB 29-05-2025 19:45:41: amt.ToString() =540 29-05-2025 19:45:41: traceNo =67439 29-05-2025 19:45:41: narr =NEFT, BY ONE 97 COMMUNICATIONS LIMITED ESCROW ACCOUNT _01 UTIB0000022 924020007330961 29-05-2025 19:45:41:Transaction Process : BEFORE CAL PROC: 29-05-2025 19:45:41:cbs no--->001001001118 29-05-2025 19:45:41:CBS A/C No : 001001001118 29-05-2025 19:45:41:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 29-05-2025 19:45:41:Record Count : 1 29-05-2025 19:45:41:BRLENGTH 3 29-05-2025 19:45:41:SCHLENGTH 3 29-05-2025 19:45:41:ACLENGTH 6 29-05-2025 19:45:41:Branch Code 3 29-05-2025 19:45:41:Scheme Code 3 29-05-2025 19:45:41:Account No 3 29-05-2025 19:45:41:Link Main Started 29-05-2025 19:45:41:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 29-05-2025 19:45:41:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 29-05-2025 19:45:41:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|001118|SB |001 29-05-2025 19:45:41:Closed YN quier --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG,DSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,depositmaster,depositschemesetup,ADDRESS where CLMS_SNO=DEPM_CLIENT AND DSCH_BRANCH = DEPM_BRANCH AND DSCH_ABBR = DEPM_ABBR and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB' AND DEPM_NO=001118 AND ADDR_SNO=CLMS_ADDRESS union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG,LSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,LOANMASTER,LOANSCHEMESETUP,ADDRESS where CLMS_SNO=LOAM_CLIENT AND LSCH_BRANCH = LOAM_BRANCH AND LSCH_ABBREV = LOAM_ABBR and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='SB' AND LOAM_NO=001118 AND ADDR_SNO=CLMS_ADDRESS UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG,ODST_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,ODMASTER,ODSCHEMESETUP,ADDRESS where CLMS_SNO=ODMT_CLIENT AND ODST_BRANCH = ODMT_BRANCH AND ODST_ABBR = ODMT_ABBR and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='SB' AND ODMT_NO=001118 AND ADDR_SNO=CLMS_ADDRESS 29-05-2025 19:45:41:ConfirmationReq Execution Success with Status 000 29-05-2025 19:45:41:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM14953772517|001001003241 ------------------------------> 29-05-2025 19:45:41:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 19:45:41:closed y n Record count --->1 29-05-2025 19:45:41:SMS Inserted for Mobile Number : +919945936919 29-05-2025 19:45:41:Inward Process Executed Sussefully 29-05-2025 19:45:41:ConfirmationReq Execution Success with Status 000 29-05-2025 19:45:41:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM14953773855|001001001118 ------------------------------> 29-05-2025 19:45:41:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 19:46:01:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : SBIN325149963724|001002000868 --------------------------> 29-05-2025 19:46:01:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 19:46:01:Connection Establisment started 29-05-2025 19:46:01:Connection Read From File : Status OK 29-05-2025 19:46:01:Connection Successfully Opened : Status OK 29-05-2025 19:46:01:ValidateAcNo CBS A/C No : 001002000868 29-05-2025 19:46:01:CBS A/C No : 001002000868 29-05-2025 19:46:01:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 29-05-2025 19:46:01:Record Count : 1 29-05-2025 19:46:01:BRLENGTH 3 29-05-2025 19:46:01:SCHLENGTH 3 29-05-2025 19:46:01:ACLENGTH 6 29-05-2025 19:46:01:Branch Code 3 29-05-2025 19:46:01:Scheme Code 3 29-05-2025 19:46:01:Account No 3 29-05-2025 19:46:01:Link Main Started 29-05-2025 19:46:01:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 29-05-2025 19:46:01:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 29-05-2025 19:46:01:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000868|CD |001 29-05-2025 19:46:01:Validation Account Proce Executed with out error Y 29-05-2025 19:46:01:Connection Establisment started 29-05-2025 19:46:01:Connection Read From File : Status OK 29-05-2025 19:46:01:Connection Successfully Opened : Status OK 29-05-2025 19:46:01:CBS A/C No : 001002000868 29-05-2025 19:46:01:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 29-05-2025 19:46:01:Record Count : 1 29-05-2025 19:46:01:BRLENGTH 3 29-05-2025 19:46:01:SCHLENGTH 3 29-05-2025 19:46:01:ACLENGTH 6 29-05-2025 19:46:01:Branch Code 3 29-05-2025 19:46:01:Scheme Code 3 29-05-2025 19:46:01:Account No 3 29-05-2025 19:46:01:Link Main Started 29-05-2025 19:46:01:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 29-05-2025 19:46:01:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 29-05-2025 19:46:01:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000868|CD |001 29-05-2025 19:46:01:Vno --->:67440 29-05-2025 19:46:01:Current Date --->:29-05-2025 29-05-2025 19:46:01:calling CallNewRtgsBothProc 29-05-2025 19:46:01:Parameters passing - InwardAuthorise 29-05-2025 19:46:01: brn =001 29-05-2025 19:46:01: acno =000868 29-05-2025 19:46:01: abbr =CD 29-05-2025 19:46:01: amt.ToString() =4623 29-05-2025 19:46:01: traceNo =67440 29-05-2025 19:46:01: narr =NEFT, BY B G ASSOCIATES SBIN0017788 00000035103616026 29-05-2025 19:46:01:Transaction Process : BEFORE CAL PROC: 29-05-2025 19:46:01:cbs no--->001002000868 29-05-2025 19:46:01:CBS A/C No : 001002000868 29-05-2025 19:46:01:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 29-05-2025 19:46:01:Record Count : 1 29-05-2025 19:46:01:BRLENGTH 3 29-05-2025 19:46:01:SCHLENGTH 3 29-05-2025 19:46:01:ACLENGTH 6 29-05-2025 19:46:01:Branch Code 3 29-05-2025 19:46:01:Scheme Code 3 29-05-2025 19:46:01:Account No 3 29-05-2025 19:46:01:Link Main Started 29-05-2025 19:46:01:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 29-05-2025 19:46:01:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 29-05-2025 19:46:01:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000868|CD |001 29-05-2025 19:46:01:Closed YN quier --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG,DSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,depositmaster,depositschemesetup,ADDRESS where CLMS_SNO=DEPM_CLIENT AND DSCH_BRANCH = DEPM_BRANCH AND DSCH_ABBR = DEPM_ABBR and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='CD' AND DEPM_NO=000868 AND ADDR_SNO=CLMS_ADDRESS union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG,LSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,LOANMASTER,LOANSCHEMESETUP,ADDRESS where CLMS_SNO=LOAM_CLIENT AND LSCH_BRANCH = LOAM_BRANCH AND LSCH_ABBREV = LOAM_ABBR and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='CD' AND LOAM_NO=000868 AND ADDR_SNO=CLMS_ADDRESS UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG,ODST_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,ODMASTER,ODSCHEMESETUP,ADDRESS where CLMS_SNO=ODMT_CLIENT AND ODST_BRANCH = ODMT_BRANCH AND ODST_ABBR = ODMT_ABBR and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='CD' AND ODMT_NO=000868 AND ADDR_SNO=CLMS_ADDRESS 29-05-2025 19:46:01:closed y n Record count --->1 29-05-2025 19:46:01:SMS Inserted for Mobile Number : +919448051124 29-05-2025 19:46:01:Inward Process Executed Sussefully 29-05-2025 19:46:01:ConfirmationReq Execution Success with Status 000 29-05-2025 19:46:01:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : SBIN325149963724|001002000868 ------------------------------> 29-05-2025 19:46:01:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 20:02:47:<------------------------Started ValidationRequest CBS A/C No : 001002000868 ------------------------> 29-05-2025 20:02:47:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 20:02:47:Connection Establisment started 29-05-2025 20:02:47:Connection Read From File : Status OK 29-05-2025 20:02:47:Connection Successfully Opened : Status OK 29-05-2025 20:02:47:ValidateAcNo CBS A/C No : 001002000868 29-05-2025 20:02:47:CBS A/C No : 001002000868 29-05-2025 20:02:47:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 29-05-2025 20:02:47:Record Count : 1 29-05-2025 20:02:47:BRLENGTH 3 29-05-2025 20:02:47:SCHLENGTH 3 29-05-2025 20:02:47:ACLENGTH 6 29-05-2025 20:02:47:Branch Code 3 29-05-2025 20:02:47:Scheme Code 3 29-05-2025 20:02:47:Account No 3 29-05-2025 20:02:47:Link Main Started 29-05-2025 20:02:47:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 29-05-2025 20:02:47:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 29-05-2025 20:02:47:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000868|CD |001 29-05-2025 20:02:47:Validation Account Proce Executed with out error Y 29-05-2025 20:02:47:ValidationRequest Exccution Success with response : 000 29-05-2025 20:02:47:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 20:35:24:<------------------------Started ValidationRequest CBS A/C No : 001001009916 ------------------------> 29-05-2025 20:35:24:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 20:35:24:Connection Establisment started 29-05-2025 20:35:24:Connection Read From File : Status OK 29-05-2025 20:35:24:Connection Successfully Opened : Status OK 29-05-2025 20:35:24:ValidateAcNo CBS A/C No : 001001009916 29-05-2025 20:35:24:CBS A/C No : 001001009916 29-05-2025 20:35:24:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 29-05-2025 20:35:24:Record Count : 1 29-05-2025 20:35:24:BRLENGTH 3 29-05-2025 20:35:24:SCHLENGTH 3 29-05-2025 20:35:24:ACLENGTH 6 29-05-2025 20:35:24:Branch Code 3 29-05-2025 20:35:24:Scheme Code 3 29-05-2025 20:35:24:Account No 3 29-05-2025 20:35:24:Link Main Started 29-05-2025 20:35:24:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 29-05-2025 20:35:24:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 29-05-2025 20:35:24:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|009916|SB |001 29-05-2025 20:35:24:Validation Account Proce Executed with out error Y 29-05-2025 20:35:24:ValidationRequest Exccution Success with response : 000 29-05-2025 20:35:24:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 20:35:29:<------------------------Started ValidationRequest CBS A/C No : 001001003241 ------------------------> 29-05-2025 20:35:29:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 20:35:29:Connection Establisment started 29-05-2025 20:35:29:Connection Read From File : Status OK 29-05-2025 20:35:29:Connection Successfully Opened : Status OK 29-05-2025 20:35:29:ValidateAcNo CBS A/C No : 001001003241 29-05-2025 20:35:29:CBS A/C No : 001001003241 29-05-2025 20:35:29:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 29-05-2025 20:35:29:Record Count : 1 29-05-2025 20:35:29:BRLENGTH 3 29-05-2025 20:35:29:SCHLENGTH 3 29-05-2025 20:35:29:ACLENGTH 6 29-05-2025 20:35:29:Branch Code 3 29-05-2025 20:35:29:Scheme Code 3 29-05-2025 20:35:29:Account No 3 29-05-2025 20:35:29:Link Main Started 29-05-2025 20:35:29:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 29-05-2025 20:35:29:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 29-05-2025 20:35:29:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|003241|SB |001 29-05-2025 20:35:29:Validation Account Proce Executed with out error Y 29-05-2025 20:35:29:ValidationRequest Exccution Success with response : 000 29-05-2025 20:35:29:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 20:35:33:<------------------------Started ValidationRequest CBS A/C No : 001002000813 ------------------------> 29-05-2025 20:35:33:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 20:35:33:Connection Establisment started 29-05-2025 20:35:33:Connection Read From File : Status OK 29-05-2025 20:35:33:Connection Successfully Opened : Status OK 29-05-2025 20:35:33:ValidateAcNo CBS A/C No : 001002000813 29-05-2025 20:35:33:CBS A/C No : 001002000813 29-05-2025 20:35:33:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 29-05-2025 20:35:33:Record Count : 1 29-05-2025 20:35:33:BRLENGTH 3 29-05-2025 20:35:33:SCHLENGTH 3 29-05-2025 20:35:33:ACLENGTH 6 29-05-2025 20:35:33:Branch Code 3 29-05-2025 20:35:33:Scheme Code 3 29-05-2025 20:35:33:Account No 3 29-05-2025 20:35:33:Link Main Started 29-05-2025 20:35:33:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 29-05-2025 20:35:33:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 29-05-2025 20:35:33:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000813|CD |001 29-05-2025 20:35:33:Validation Account Proce Executed with out error Y 29-05-2025 20:35:33:ValidationRequest Exccution Success with response : 000 29-05-2025 20:35:33:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 20:35:34:<------------------------Started ValidationRequest CBS A/C No : 001001011946 ------------------------> 29-05-2025 20:35:34:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 20:35:34:Connection Establisment started 29-05-2025 20:35:34:Connection Read From File : Status OK 29-05-2025 20:35:34:Connection Successfully Opened : Status OK 29-05-2025 20:35:34:ValidateAcNo CBS A/C No : 001001011946 29-05-2025 20:35:34:CBS A/C No : 001001011946 29-05-2025 20:35:34:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 29-05-2025 20:35:34:Record Count : 1 29-05-2025 20:35:34:BRLENGTH 3 29-05-2025 20:35:34:SCHLENGTH 3 29-05-2025 20:35:34:ACLENGTH 6 29-05-2025 20:35:34:Branch Code 3 29-05-2025 20:35:34:Scheme Code 3 29-05-2025 20:35:34:Account No 3 29-05-2025 20:35:34:Link Main Started 29-05-2025 20:35:34:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 29-05-2025 20:35:34:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 29-05-2025 20:35:34:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|011946|SB |001 29-05-2025 20:35:34:Validation Account Proce Executed with out error Y 29-05-2025 20:35:34:ValidationRequest Exccution Success with response : 000 29-05-2025 20:35:34:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 20:40:10:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : SBIN325149980640|001002000868 --------------------------> 29-05-2025 20:40:10:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 20:40:10:Connection Establisment started 29-05-2025 20:40:10:Connection Read From File : Status OK 29-05-2025 20:40:10:Connection Successfully Opened : Status OK 29-05-2025 20:40:10:ValidateAcNo CBS A/C No : 001002000868 29-05-2025 20:40:10:CBS A/C No : 001002000868 29-05-2025 20:40:10:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 29-05-2025 20:40:10:Record Count : 1 29-05-2025 20:40:10:BRLENGTH 3 29-05-2025 20:40:10:SCHLENGTH 3 29-05-2025 20:40:10:ACLENGTH 6 29-05-2025 20:40:10:Branch Code 3 29-05-2025 20:40:10:Scheme Code 3 29-05-2025 20:40:10:Account No 3 29-05-2025 20:40:10:Link Main Started 29-05-2025 20:40:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 29-05-2025 20:40:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 29-05-2025 20:40:10:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000868|CD |001 29-05-2025 20:40:10:Validation Account Proce Executed with out error Y 29-05-2025 20:40:10:Connection Establisment started 29-05-2025 20:40:10:Connection Read From File : Status OK 29-05-2025 20:40:10:Connection Successfully Opened : Status OK 29-05-2025 20:40:10:CBS A/C No : 001002000868 29-05-2025 20:40:10:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 29-05-2025 20:40:10:Record Count : 1 29-05-2025 20:40:10:BRLENGTH 3 29-05-2025 20:40:10:SCHLENGTH 3 29-05-2025 20:40:10:ACLENGTH 6 29-05-2025 20:40:10:Branch Code 3 29-05-2025 20:40:10:Scheme Code 3 29-05-2025 20:40:10:Account No 3 29-05-2025 20:40:10:Link Main Started 29-05-2025 20:40:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 29-05-2025 20:40:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 29-05-2025 20:40:10:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000868|CD |001 29-05-2025 20:40:10:Vno --->:67441 29-05-2025 20:40:10:Current Date --->:29-05-2025 29-05-2025 20:40:10:calling CallNewRtgsBothProc 29-05-2025 20:40:10:Parameters passing - InwardAuthorise 29-05-2025 20:40:10: brn =001 29-05-2025 20:40:10: acno =000868 29-05-2025 20:40:10: abbr =CD 29-05-2025 20:40:10: amt.ToString() =3175 29-05-2025 20:40:10: traceNo =67441 29-05-2025 20:40:10: narr =NEFT, BY B G ASSOCIATES SBIN0017788 00000035103616026 29-05-2025 20:40:10:Transaction Process : BEFORE CAL PROC: 29-05-2025 20:40:10:cbs no--->001002000868 29-05-2025 20:40:10:CBS A/C No : 001002000868 29-05-2025 20:40:10:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 29-05-2025 20:40:10:Record Count : 1 29-05-2025 20:40:10:BRLENGTH 3 29-05-2025 20:40:10:SCHLENGTH 3 29-05-2025 20:40:10:ACLENGTH 6 29-05-2025 20:40:10:Branch Code 3 29-05-2025 20:40:10:Scheme Code 3 29-05-2025 20:40:10:Account No 3 29-05-2025 20:40:10:Link Main Started 29-05-2025 20:40:10:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 29-05-2025 20:40:10:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 29-05-2025 20:40:10:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000868|CD |001 29-05-2025 20:40:10:Closed YN quier --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG,DSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,depositmaster,depositschemesetup,ADDRESS where CLMS_SNO=DEPM_CLIENT AND DSCH_BRANCH = DEPM_BRANCH AND DSCH_ABBR = DEPM_ABBR and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='CD' AND DEPM_NO=000868 AND ADDR_SNO=CLMS_ADDRESS union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG,LSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,LOANMASTER,LOANSCHEMESETUP,ADDRESS where CLMS_SNO=LOAM_CLIENT AND LSCH_BRANCH = LOAM_BRANCH AND LSCH_ABBREV = LOAM_ABBR and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='CD' AND LOAM_NO=000868 AND ADDR_SNO=CLMS_ADDRESS UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG,ODST_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,ODMASTER,ODSCHEMESETUP,ADDRESS where CLMS_SNO=ODMT_CLIENT AND ODST_BRANCH = ODMT_BRANCH AND ODST_ABBR = ODMT_ABBR and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='CD' AND ODMT_NO=000868 AND ADDR_SNO=CLMS_ADDRESS 29-05-2025 20:40:10:closed y n Record count --->1 29-05-2025 20:40:10:SMS Inserted for Mobile Number : +919448051124 29-05-2025 20:40:10:Inward Process Executed Sussefully 29-05-2025 20:40:10:ConfirmationReq Execution Success with Status 000 29-05-2025 20:40:10:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : SBIN325149980640|001002000868 ------------------------------> 29-05-2025 20:40:10:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 21:10:29:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM14953956126|001001011946 --------------------------> 29-05-2025 21:10:29:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 21:10:29:<-----------------------STARTED CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM14953956130|001002000813 --------------------------> 29-05-2025 21:10:29:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 21:10:29:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 21:10:29:Connection Establisment started 29-05-2025 21:10:29:Connection Establisment started 29-05-2025 21:10:29:Connection Read From File : Status OK 29-05-2025 21:10:29:Connection Read From File : Status OK 29-05-2025 21:10:29:Connection Successfully Opened : Status OK 29-05-2025 21:10:29:ValidateAcNo CBS A/C No : 001001011946 29-05-2025 21:10:29:CBS A/C No : 001001011946 29-05-2025 21:10:29:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 29-05-2025 21:10:29:Record Count : 1 29-05-2025 21:10:29:BRLENGTH 3 29-05-2025 21:10:29:SCHLENGTH 3 29-05-2025 21:10:29:ACLENGTH 6 29-05-2025 21:10:29:Branch Code 3 29-05-2025 21:10:29:Scheme Code 3 29-05-2025 21:10:29:Account No 3 29-05-2025 21:10:29:Link Main Started 29-05-2025 21:10:29:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 29-05-2025 21:10:29:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 29-05-2025 21:10:29:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|011946|SB |001 29-05-2025 21:10:29:Validation Account Proce Executed with out error Y 29-05-2025 21:10:29:Connection Establisment started 29-05-2025 21:10:29:Connection Successfully Opened : Status OK 29-05-2025 21:10:29:ValidateAcNo CBS A/C No : 001002000813 29-05-2025 21:10:29:CBS A/C No : 001002000813 29-05-2025 21:10:29:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 29-05-2025 21:10:29:Record Count : 1 29-05-2025 21:10:29:BRLENGTH 3 29-05-2025 21:10:29:SCHLENGTH 3 29-05-2025 21:10:29:ACLENGTH 6 29-05-2025 21:10:29:Branch Code 3 29-05-2025 21:10:29:Scheme Code 3 29-05-2025 21:10:29:Account No 3 29-05-2025 21:10:29:Link Main Started 29-05-2025 21:10:29:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 29-05-2025 21:10:29:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 29-05-2025 21:10:29:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000813|CD |001 29-05-2025 21:10:29:Validation Account Proce Executed with out error Y 29-05-2025 21:10:29:Connection Establisment started 29-05-2025 21:10:29:Connection Successfully Opened : Status OK 29-05-2025 21:10:29:Connection Read From File : Status OK 29-05-2025 21:10:29:CBS A/C No : 001001011946 29-05-2025 21:10:29:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 29-05-2025 21:10:29:Record Count : 1 29-05-2025 21:10:29:BRLENGTH 3 29-05-2025 21:10:29:SCHLENGTH 3 29-05-2025 21:10:29:ACLENGTH 6 29-05-2025 21:10:29:Branch Code 3 29-05-2025 21:10:29:Scheme Code 3 29-05-2025 21:10:29:Account No 3 29-05-2025 21:10:29:Link Main Started 29-05-2025 21:10:29:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 29-05-2025 21:10:29:Connection Successfully Opened : Status OK 29-05-2025 21:10:29:ValidateAcNo CBS A/C No : 001001009916 29-05-2025 21:10:29:CBS A/C No : 001001009916 29-05-2025 21:10:29:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 29-05-2025 21:10:29:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 29-05-2025 21:10:29:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|011946|SB |001 29-05-2025 21:10:29:Record Count : 1 29-05-2025 21:10:29:BRLENGTH 3 29-05-2025 21:10:29:SCHLENGTH 3 29-05-2025 21:10:29:ACLENGTH 6 29-05-2025 21:10:29:Branch Code 3 29-05-2025 21:10:29:Scheme Code 3 29-05-2025 21:10:29:Account No 3 29-05-2025 21:10:29:Link Main Started 29-05-2025 21:10:29:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 29-05-2025 21:10:29:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 29-05-2025 21:10:29:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|009916|SB |001 29-05-2025 21:10:29:Validation Account Proce Executed with out error Y 29-05-2025 21:10:29:Connection Establisment started 29-05-2025 21:10:29:Connection Read From File : Status OK 29-05-2025 21:10:29:Connection Successfully Opened : Status OK 29-05-2025 21:10:29:CBS A/C No : 001001009916 29-05-2025 21:10:29:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 29-05-2025 21:10:29:Record Count : 1 29-05-2025 21:10:29:BRLENGTH 3 29-05-2025 21:10:29:SCHLENGTH 3 29-05-2025 21:10:29:ACLENGTH 6 29-05-2025 21:10:29:Branch Code 3 29-05-2025 21:10:29:Scheme Code 3 29-05-2025 21:10:29:Account No 3 29-05-2025 21:10:29:Link Main Started 29-05-2025 21:10:29:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 29-05-2025 21:10:29:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 29-05-2025 21:10:29:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|009916|SB |001 29-05-2025 21:10:29:Vno --->:67442 29-05-2025 21:10:29:Current Date --->:29-05-2025 29-05-2025 21:10:29:Vno --->:67443 29-05-2025 21:10:29:Current Date --->:29-05-2025 29-05-2025 21:10:29:calling CallNewRtgsBothProc 29-05-2025 21:10:29:Parameters passing - InwardAuthorise 29-05-2025 21:10:29: brn =001 29-05-2025 21:10:29: acno =011946 29-05-2025 21:10:29: abbr =SB 29-05-2025 21:10:29: amt.ToString() =1111 29-05-2025 21:10:29: traceNo =67442 29-05-2025 21:10:29: narr =NEFT, BY ONE 97 COMMUNICATIONS LIMITED ESCROW ACCOUNT _01 UTIB0000022 924020007330961 29-05-2025 21:10:29:Transaction Process : BEFORE CAL PROC: 29-05-2025 21:10:29:calling CallNewRtgsBothProc 29-05-2025 21:10:29:Parameters passing - InwardAuthorise 29-05-2025 21:10:29: brn =001 29-05-2025 21:10:29: acno =009916 29-05-2025 21:10:29: abbr =SB 29-05-2025 21:10:29: amt.ToString() =250 29-05-2025 21:10:29: traceNo =67443 29-05-2025 21:10:29: narr =NEFT, BY ONE 97 COMMUNICATIONS LIMITED ESCROW ACCOUNT _01 UTIB0000022 924020007330961 29-05-2025 21:10:29:Transaction Process : BEFORE CAL PROC: 29-05-2025 21:10:29:Connection Successfully Opened : Status OK 29-05-2025 21:10:29:CBS A/C No : 001002000813 29-05-2025 21:10:29:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 29-05-2025 21:10:29:Record Count : 1 29-05-2025 21:10:29:BRLENGTH 3 29-05-2025 21:10:29:SCHLENGTH 3 29-05-2025 21:10:29:ACLENGTH 6 29-05-2025 21:10:29:Branch Code 3 29-05-2025 21:10:29:Scheme Code 3 29-05-2025 21:10:29:Account No 3 29-05-2025 21:10:29:Link Main Started 29-05-2025 21:10:29:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 29-05-2025 21:10:29:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 29-05-2025 21:10:29:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000813|CD |001 29-05-2025 21:10:29:Vno --->:67444 29-05-2025 21:10:29:Current Date --->:29-05-2025 29-05-2025 21:10:29:calling CallNewRtgsBothProc 29-05-2025 21:10:29:Parameters passing - InwardAuthorise 29-05-2025 21:10:29: brn =001 29-05-2025 21:10:29: acno =000813 29-05-2025 21:10:29: abbr =CD 29-05-2025 21:10:29: amt.ToString() =2061.59 29-05-2025 21:10:29: traceNo =67444 29-05-2025 21:10:29: narr =NEFT, BY ONE 97 COMMUNICATIONS LIMITED ESCROW ACCOUNT _01 UTIB0000022 924020007330961 29-05-2025 21:10:29:Transaction Process : BEFORE CAL PROC: 29-05-2025 21:10:29:cbs no--->001001009916 29-05-2025 21:10:29:CBS A/C No : 001001009916 29-05-2025 21:10:29:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 29-05-2025 21:10:29:Record Count : 1 29-05-2025 21:10:29:BRLENGTH 3 29-05-2025 21:10:29:SCHLENGTH 3 29-05-2025 21:10:29:ACLENGTH 6 29-05-2025 21:10:29:Branch Code 3 29-05-2025 21:10:29:Scheme Code 3 29-05-2025 21:10:29:Account No 3 29-05-2025 21:10:29:Link Main Started 29-05-2025 21:10:29:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 001 and LINK_BRANCH=BRAN_SNO 29-05-2025 21:10:29:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 29-05-2025 21:10:30:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|009916|SB |001 29-05-2025 21:10:30:Closed YN quier --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG,DSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,depositmaster,depositschemesetup,ADDRESS where CLMS_SNO=DEPM_CLIENT AND DSCH_BRANCH = DEPM_BRANCH AND DSCH_ABBR = DEPM_ABBR and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='SB' AND DEPM_NO=009916 AND ADDR_SNO=CLMS_ADDRESS union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG,LSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,LOANMASTER,LOANSCHEMESETUP,ADDRESS where CLMS_SNO=LOAM_CLIENT AND LSCH_BRANCH = LOAM_BRANCH AND LSCH_ABBREV = LOAM_ABBR and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='SB' AND LOAM_NO=009916 AND ADDR_SNO=CLMS_ADDRESS UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG,ODST_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,ODMASTER,ODSCHEMESETUP,ADDRESS where CLMS_SNO=ODMT_CLIENT AND ODST_BRANCH = ODMT_BRANCH AND ODST_ABBR = ODMT_ABBR and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='SB' AND ODMT_NO=009916 AND ADDR_SNO=CLMS_ADDRESS 29-05-2025 21:10:30:closed y n Record count --->1 29-05-2025 21:10:30:SMS Inserted for Mobile Number : +917676999889 29-05-2025 21:10:30:cbs no--->001002000813 29-05-2025 21:10:30:CBS A/C No : 001002000813 29-05-2025 21:10:30:Show A/C Number query SELECT A.SITP_DOUBLEVALUE AS IINLENTH ,A.SITP_LONGVALUE AS IIN,B.SITP_DOUBLEVALUE AS BRLENGTH,C.SITP_DOUBLEVALUE AS SCHLENGTH,D.SITP_DOUBLEVALUE AS ACLENGTH From (select 1 SNO,SITP_DOUBLEVALUE,SITP_LONGVALUE from head.siteparameters where SITP_NAME = 'IIN NUMBER')A, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'BRANCH CODE')B, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'SCHEME CODE')C, (select 1 SNO,SITP_DOUBLEVALUE from head.siteparameters where SITP_NAME = 'ACCOUNT NO')D Where A.sno = B.sno AND C.SNO= A.SNO AND D.SNO = A.SNO 29-05-2025 21:10:30:Record Count : 1 29-05-2025 21:10:30:BRLENGTH 3 29-05-2025 21:10:30:SCHLENGTH 3 29-05-2025 21:10:30:ACLENGTH 6 29-05-2025 21:10:30:Branch Code 3 29-05-2025 21:10:30:Scheme Code 3 29-05-2025 21:10:30:Account No 3 29-05-2025 21:10:30:Link Main Started 29-05-2025 21:10:30:Link Main quesry Select LINK_ABBREV,LINK_TYPE,BRAN_NAME from linkmain,MASTER.branch where LINK_SNO = 002 and LINK_BRANCH=BRAN_SNO 29-05-2025 21:10:30:Branch Selection quesry Select bran_name,bran_sno from MASTER.branch Where bran_sno = 001 29-05-2025 21:10:30:ShowCBS Ac No Proce Executed HEAD OFFICE|DEPOSIT|000813|CD |001 29-05-2025 21:10:30:Closed YN quier --->select CLMS_DES,CLMS_SNO,nvl(DEPM_CLOSEDYN,'N') as DEPM_CLOSEDYN,DEPM_CLOSEDATE,DEPM_SMSREGYN AS SMSREG,DSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,depositmaster,depositschemesetup,ADDRESS where CLMS_SNO=DEPM_CLIENT AND DSCH_BRANCH = DEPM_BRANCH AND DSCH_ABBR = DEPM_ABBR and DEPM_BRANCH=001 and TRIM(DEPM_ABBR)='CD' AND DEPM_NO=000813 AND ADDR_SNO=CLMS_ADDRESS union select CLMS_DES,CLMS_SNO,nvl(LOAM_CLOSEDYN,'N')as LOAM_CLOSEDYN,LOAM_CLOSEDATE,LOAM_SMSREGYN AS SMSREG,LSCH_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,LOANMASTER,LOANSCHEMESETUP,ADDRESS where CLMS_SNO=LOAM_CLIENT AND LSCH_BRANCH = LOAM_BRANCH AND LSCH_ABBREV = LOAM_ABBR and LOAM_BRANCH =001 and TRIM(LOAM_ABBR)='CD' AND LOAM_NO=000813 AND ADDR_SNO=CLMS_ADDRESS UNION select CLMS_DES,CLMS_SNO,nvl(ODMT_CLOSEDYN,'N') as ODMT_CLOSEDYN,ODMT_CLOSEDATE,ODMT_SMSREGYN AS SMSREG,ODST_GLLINK AS GLLINK,ADDR_MOBILENO FROM clientmaster,ODMASTER,ODSCHEMESETUP,ADDRESS where CLMS_SNO=ODMT_CLIENT AND ODST_BRANCH = ODMT_BRANCH AND ODST_ABBR = ODMT_ABBR and ODMT_BRANCH=001 and TRIM(ODMT_ABBR)='CD' AND ODMT_NO=000813 AND ADDR_SNO=CLMS_ADDRESS 29-05-2025 21:10:30:Inward Process Executed Sussefully 29-05-2025 21:10:30:ConfirmationReq Execution Success with Status 000 29-05-2025 21:10:30:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM14953956126|001001011946 ------------------------------> 29-05-2025 21:10:30:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 21:10:30:closed y n Record count --->1 29-05-2025 21:10:30:Inward Process Executed Sussefully 29-05-2025 21:10:30:ConfirmationReq Execution Success with Status 000 29-05-2025 21:10:30:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM14953955305|001001009916 ------------------------------> 29-05-2025 21:10:30:<------------------------------------------------------------------------------------------------------------------------> 29-05-2025 21:10:30:SMS Inserted for Mobile Number : +919035337225 29-05-2025 21:10:30:Inward Process Executed Sussefully 29-05-2025 21:10:30:ConfirmationReq Execution Success with Status 000 29-05-2025 21:10:30:<-----------------------END CONFIRMATION REQUEST PROCESS FOR THE DETAILS : AXNPM14953956130|001002000813 ------------------------------> 29-05-2025 21:10:30:<------------------------------------------------------------------------------------------------------------------------>