30-09-2024 14:35:22:Qury from rtgsinward--->:select REMIT_UTR utrno from rtgsinward where REMIT_UTR='CIUBH24274028172' 30-09-2024 14:35:22:Record Count --->:0 30-09-2024 14:35:22:quiery Insert into rtgsinward : Insert into rtgsinward(VOUCHERNO,VOUCHERDATE,RECEIVED_DATETIME,REMIT_UTR,AGENT_BANKACNO,BENEFI_NAME,BENEFI_ACCNO,REMIT_NAME,REMIT_ACNO,SENDER_IFSC,BENEFI_IFSC,STATUS,AMOUNT,TRANMODE,FILE_NAME)VALUES(159512,TO_date(sysdate,'DD/MM/RRRR'),sysdate,'CIUBH24274028172','0','Y SURYA NARAYANA REDDY','001001003465','LIC INDIA D065','00510909010267418','CIUB0000032','YESB0CSB001','',64000,'N','305477315') 30-09-2024 14:35:22:SenderAcno - BY LIC INDIA D065 CIUB0000032 00510909010267418 30-09-2024 14:35:22:narr - NEFT, BY LIC INDIA D065 CIUB0000032 00510909010267418 30-09-2024 14:35:22:calling GetInwardAuthLimit 30-09-2024 14:35:22:calling CallNewRtgsBothProc 30-09-2024 14:35:22:proc msg - RTGS TRANSACTION IS SUCCESSFUL 30-09-2024 14:35:22:proc status - Y 30-09-2024 14:35:22:update rtgsinward - UPDATE rtgsinward SET web_status = 'Y', trandate = SYSDATE WHERE voucherno = 159512 30-09-2024 14:35:22:Transaction SMS Alert - Client Code Started 6854 30-09-2024 14:35:23:Transaction SMS Alert - Client Code Completed 6854