top of page

Exception Handling in IFS

Writer's picture: Rumesh Aponso (RMAX)Rumesh Aponso (RMAX)
PROCEDURE Test_Exception_Handling
IS
BEGIN
   -- TODO: Pre Logic
   Dbms_Output.Put_Line('Pre Logic');
   
   BEGIN
      @ApproveTransactionStatement(2024-11-21, RMAX)
      SAVEPOINT A;
      
      -- TODO: Main Logic
      Dbms_Output.Put_Line('Main Logic');
      
      -- Error Demo
      Error_SYS.Record_General(lu_name_, 'TEMPERROR: RMAX DUMMY 101');
   EXCEPTION
      WHEN OTHERS THEN
         @ApproveTransactionStatement(2024-11-21, RMAX)
         ROLLBACK TO A;
         
         -- TODO: Error Handling Logic
         Dbms_Output.Put_Line('Error Handling Logic');
   END;   
END Test_Exception_Handling;

3 views0 comments

Related Posts

See All

Fnd Dynamic Tab Page in IEE Client

[FndWindowRegistration("YVVDA_COMPANY_ADDR", "YvvdaCompanyAddr", FndWindowRegistrationFlags.HomePage)] [FndDynamicTabPage("frmCompanyAddr...

LISTAGG in PLSQL

Example 1: SELECT DISTINCT LISTAGG(t.commission_receiver, ';') WITHIN GROUP (ORDER BY t.commission_receiver) FROM...

Get Foundation Error from ORA Error

FUNCTION Strip_Ora_Error ( sqlerrm_        IN VARCHAR2,    sqlcode_        IN NUMBER DEFAULT NULL,    strip_ora_only_ IN BOOLEAN DEFAULT...

Comments


Copyright © 2025 RMAXOneNote

  • Online CV
  • LinkedIn
  • Youtube
  • GitHub
  • Blogger
bottom of page