index

Package gb_displaycolumns_str

Error messages and error message functions for the DISPLAY COLUMNS API, gb_displaycolumns.

Message KeyError Message
INVALID_DATA_TYPE_CDEInvalid display type code for display items, must be C,N or D
An attempt was made to create or update the Data type of a display column item to a value other than 'C' (character), 'N' (numeric) or 'D' (date).
INVALID_NUMERIC_PRECISIONNumeric precision allowed only with numeric type display items
An attempt was made to create or update the Numeric precision for a display item that is a character or date. Numeric precision is only allowed for display columns that are numeric type.
INVALID_OBJS_CODEInvalid object code for display items
An attempt was made to create or update the Object name for a display column with an invalid value. The Object name must exist as a valid object in the Object Maintenance Table (GUAOBJS).
INVALID_QUERY_COLUMNQuery column can be entered only for character display items
An attempt was made to create or update the Form Item that data is queried into for a data display item that is date or numeric data type.  The Form Item for query is only allowed for columns that are character type.
INVALID_SYS_REQ_INDInvalid system required indicator, values must be Y or N
An attempt was made to create or update the System Required indicator for a display column to a value other than 'Y' (Yes) or 'N' (No).
MISSING_BLOCK_NAMEMissing block name for display items
The display column Block Name is missing and must be a valid block name in ALL_TABLES.
MISSING_COLUMN_NAMEMissing item name for display items
The display Column Name is missing and must be a valid column name in ALL_TAB_COLUMNS.
MISSING_OBJS_CODEMissing object code for display items
The Object code is missing and must be a valid value object name in the Object Maintenance Table (GUBOBJS).
MISSING_SYS_REQ_INDMissing system required indicator for display items
The display column System Required indicator is missing and must be 'Y' (Yes) or 'N' (No).
MISSING_USER_IDMissing USER for display items
The display items Oracle ID is missing and must be a valid value.
PK_NOT_FOUNDCannot find record using primary or unique key
An attempt to find a display item record was unsuccessful because the record could not be found using the primary or unique key of Object, Block and Column name.
P_DELETE_FAILEDCannot delete, record does not exist
An attempt to delete a display item record was unsuccessful because the record does not exist.
P_DEL_FAILED_MASKSCannot delete, display masks records exist for display item
An attempt to delete a display item record was unsuccessful because display masks records exist for the display item on the Display Mask Column Rules Table (GORDMSK).
P_DEL_FAILED_SYS_REQCannot delete, display item is system required
An attempt to delete a display columns item record was unsuccessful because the column display rule is system required.
P_UPD_FAILED_SYS_REQCannot update, display item is system required
An attempt to update a display columns item was unsuccessful because the column display rule is system required.
RECORD_EXISTSCannot create, record already exists
An attempt to create a display columns item record was unsuccessful because the record already exists; duplicates are not allowed.


Program units
f_get_error   Returns the error message corresponding to p_errorname.

Variables
error_tab   Error messages array.


error_tab

error_tab gb_common_strings.errmsg_tab_type;

Error messages array.


f_get_error

FUNCTION f_get_error(p_errorname VARCHAR2) RETURN VARCHAR2

Returns the error message corresponding to p_errorname.

Parameters
p_errorname   Name associated with an error message.