20-02-2025 18:35:01:Qury from rtgsinward--->:select REMIT_UTR utrno from rtgsinward where REMIT_UTR='UTIBN62025022057242951' 20-02-2025 18:35:01:Record Count --->:0 20-02-2025 18:35:01: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(173127,TO_date(sysdate,'DD/MM/RRRR'),sysdate,'UTIBN62025022057242951','0','S A Pillappa Reddy','001001002994','OPTIVAL HEALTH SOLUTIONS PVT LTD','008010200052395','UTIB0000008','YESB0CSB001','',9642,'N','315495242') 20-02-2025 18:35:01:SenderAcno - BY OPTIVAL HEALTH SOLUTIONS PVT LTD UTIB0000008 008010200052395 20-02-2025 18:35:01:narr - NEFT, BY OPTIVAL HEALTH SOLUTIONS PVT LTD UTIB0000008 008010200052395 20-02-2025 18:35:01:calling GetInwardAuthLimit 20-02-2025 18:35:01:calling CallNewRtgsBothProc 20-02-2025 18:35:01:proc msg - RTGS TRANSACTION IS SUCCESSFUL 20-02-2025 18:35:01:proc status - Y 20-02-2025 18:35:01:update rtgsinward - UPDATE rtgsinward SET web_status = 'Y', trandate = SYSDATE WHERE voucherno = 173127 20-02-2025 18:35:01:Transaction SMS Alert - Client Code Started 6279 20-02-2025 18:35:02:Transaction SMS Alert - Client Code Completed 6279