25.7 ADD_ERROR Procedure Signature 5
This procedure adds an error message to the error stack of a tabular form that is used to display text as defined by a shared component. This error message can be displayed to all display locations. It can be called in a validation or process to add one or more errors to the error stack.
Note:
This procedure must be called before the Oracle APEX application has performed the last validation or process. Otherwise, the error is ignored if it does not have a display location ofapex_error.c_on_error_page
.
Syntax
APEX_ERROR.ADD_ERROR (
p_error_code IN VARCHAR2,
p0 IN VARCHAR2 DEFAULT NULL,
p1 IN VARCHAR2 DEFAULT NULL,
p2 IN VARCHAR2 DEFAULT NULL,
p3 IN VARCHAR2 DEFAULT NULL,
p4 IN VARCHAR2 DEFAULT NULL,
p5 IN VARCHAR2 DEFAULT NULL,
p6 IN VARCHAR2 DEFAULT NULL,
p7 IN VARCHAR2 DEFAULT NULL,
p8 IN VARCHAR2 DEFAULT NULL,
p9 IN VARCHAR2 DEFAULT NULL,
p_escape_placeholders IN BOOLEAN DEFAULT TRUE,
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 25-3 ADD_ERROR Parameters
Parameters | Description |
---|---|
p_error_code |
Name of shared component text message. |
p0 through p9 |
Values for %0 through %9 placeholders defined in the text message. |
p_escape_placeholders |
If set to TRUE , the values provided in p0 through p9 are escaped with sys.htf.escape_sc before replacing the placeholder in the text message. If set to FALSE , values are not escaped.
|
p_additional_info |
Additional error information needed if the error is displayed on the error page. |
p_display_location |
Specifies where the error message is displayed. Use the constants defined for p_display_location . See Constants and Attributes Used for Result Types.
|
p_region_id |
The ID of the tabular form region on the current page. The ID can be read from the view APEX_APPLICATION_PAGE_REGIONS .
|
p_column_alias |
The name of the tabular form column alias defined for p_region_id that is highlighted if apex_error.c_inline_with_field or apex_error.c_inline_with_field_and_notif are used as a display location.
|
p_row_num |
Number of the tabular form row where the error occurred. |
Example
This example illustrates how to add a custom error message, where the text is stored in a text message, to the error stack. The CUSTOMER_ID
column on the tabular form is highlighted. The error message is displayed inline in a notification. This example can be used in a validation or process.
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_region_id => l_region_id,
p_column_alias => 'CUSTOMER_ID',
p_row_num => l_row_num );
Parent topic: APEX_ERROR