Monday 24 September 2018

USING APEX_ERROR NOTIFICATIONS TO MANAGE CUSTOM ERROR MESSAGES

Include User Notifications or Custom Messages and Error Messages in Oracle APEX’s default Success and Error Message style. 


Default Success message :



Default Error message :



Steps in APEX :

ü  Step 1 : Create a text field item P11_ENAME.




Step 2 : Create a File Browse Item P11_FILE_BROWSE and change the Storage Type as APEX_APPLICATION_TEMP_FILES and Change the Purge File at End of Session.


APEX Screen :


ü  Step 3 : Create an Application Process Insert Image and copy the below code as source.
Code :
        
DECLARE
   v_blob      BLOB;
   v_emp_cnt   NUMBER;
   v_name      VARCHAR2 (100);
   v_sno       NUMBER;
BEGIN
   BEGIN
      SELECT blob_content, NAME
        INTO v_blob, v_name
        FROM apex_application_temp_files
       WHERE ID = (SELECT MAX (ID)
                     FROM apex_application_temp_files);
   EXCEPTION
      WHEN OTHERS
      THEN
         raise_application_error (-20038, 'Table');
   END;

   BEGIN
      SELECT NVL (MAX (sno), 0) + 1
        INTO v_sno
        FROM emp_files;
   --RAISE_APPLICATION_ERROR(-20034,v_sno);
   END;

   BEGIN
      IF :p11_empno IS NOT NULL
      THEN
         BEGIN
            SELECT COUNT (1)
              INTO v_emp_cnt
              FROM emp123
             WHERE empno = :p11_empno;

            IF v_emp_cnt = 1
            THEN
               BEGIN
                  INSERT INTO emp_files
                              (sno, empno, file_name, blob_content
                              )
                       VALUES (v_sno, :p11_empno, v_name, v_blob
                              );

                  COMMIT;
                 apex_application.g_print_success_message :=
                        '<span style="color : white ">Success :</span>'
                     || TRIM (:p11_empno);
               EXCEPTION
                  WHEN OTHERS
                  THEN
                     raise_application_error (-20098,
                                              SQLERRM || '-' || 'INSIDE'
                                             );
               END;
            ELSE
               /*  apex_application.g_print_success_message :=
                       '<span style="color : white ">Error in Uploading Image for Employee :</span>'
                    || TRIM (:p11_empno);*/
               apex_error.add_error
                   (p_message               =>    'Employee No : '
                                               || :p11_empno
                                               || ' already exists.',
                    p_display_location      => apex_error.c_inline_in_notification
                   );
            END IF;
         END;
      ELSE
         apex_error.add_error
                   (p_message               => 'No value in the Employee number field.',
                    p_display_location      => apex_error.c_inline_in_notification
                   );
      END IF;
   END;
END;

Note : Above code contains two packages. apex_application.g_print_success_message for Success and apex_error.add_error  for Error Messages. You can change the Message info based on the requirement.

My Custom Success Message :

My Custom Error Message : I have passed the Employee Number in to the Error Notification.


3 comments:

  1. Such a nice blog, I really like what you write in this blog, I also have some relevant Information about Best HR Training In Hyderabad | Hr training institute in Hyderabad! if you want more information.
    Oracle Fusion HCM Online Training
    Oracle Fusion SCM Online Training
    Oracle Fusion Financials Online Training
    Big Data and Hadoop Training In Hyderabad

    ReplyDelete
  2. Dear very help code, but i need multi image upload in browser who selected 3 image but insert only one impage plz guid me if possible fsd@makramco.net

    ReplyDelete