This procedure adds an error message to the error stack that is used to display an error for a tabular form inline in a notification. It can be called in a validation or process to add one or more errors to the error stack.
This procedure must be called before the Application Express application has performed the last validation or process. Otherwise, the error is ignored if it does not have a display location of apex_error.c_on_error_page
.
Syntax
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 );
Parameters
Table 8-4 describes the parameters available in the ADD_ERROR Procedure Signature 4.
Table 8-4 ADD_ERROR Procedure Signature 4 Parameters
Parameters | Description |
---|---|
|
Displayed error message. |
|
Additional error information needed if the error is displayed on the error page. |
|
Specifies where the error message is displayed. Use the constant |
|
The ID of a tabular form region on the current page. The ID can be read from the view |
|
Name of a tabular form column alias defined for p_region_id that is highlighted if |
|
Number of the tabular form row where the error occurred. |
Example
This example illustrates how to add a custom error message for a tabular form, where the column CUSTOMER_ID
is highlighted, to the error stack. The error message is displayed inline in a notification. This example can be used in a validation or process.
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 );