Introduction:
The Users can customize the Error Messages in Apex Error Notifications
Default Messages:
Procedures:
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.
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;
Summary:
The User can set any messages by using the above 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.
