Apex error handling procedure.. we are commonly using raise application error only.. when system will through the oracle error code like ORA-20001. it will come before message.. so if we use the below code we will avoid the error code.
apex_error.add_error ( p_message => 'This custom account is not active!', p_display_location => apex_error.c_inline_in_notification );
apex_error.add_error ( p_error_code => 'INVALID_CUSTOMER_ID', p0 => l_customer_id, p_display_location => apex_error.c_inline_with_field_and_notif, p_page_item_name => 'P5_CUSTOMER_ID' );
APEX_ERROR.ADD_ERROR ( p_message in varchar2, p_additional_info in varchar2 default null, p_display_location in varchar2, p_region_id in number, p_column_alias in varchar2 default null, p_row_num in number );
apex_error.add_error ( p_message => 'Invalid Customer ID!', p_display_location => apex_error.c_inline_with_field_and_notif, p_region_id => l_region_id, p_column_alias => 'CUSTOMER_ID', p_row_num => l_row_num );
Advertisements