index

Package gb_userdefault_str

Error messages and error message functions for the USER DEFAULT API, gb_userdefault.

Message KeyError Message
INVALID_CROSS_DOMAIN_INDInvalid value for Cross Domain indicator
An attempt was made to create or update the Cross Domain indicator to a value other than 'Y' (Yes) or 'N' (No).
INVALID_EXEMPT_INDInvalid value for User Exempt indicator
An attempt was made to create or update the User Exempt indicator to a value other than 'Y' (Yes) or 'N' (No).
INVALID_FDMN_CODEInvalid value for Home Domain code
An attempt was made to create or update the FGAC User default Domain Code with an invalid value. The Domain Code must exist in the Domain Code Validation table (GTVFDMN).
INVALID_FGAC_USER_IDInvalid value for User Default FGAC User ID
An attempt was made to create or update the User default FGAC User ID with an invalid value.
INVALID_USER_IDInvalid value for User ID
An attempt was made to create or update the User default User ID with an invalid value.
MISSING_CROSS_DOMAIN_INDMissing mandatory value for Cross Domain indicator
The Cross Domain indicator is missing and must be 'Y' (Yes) or 'N' (No).
MISSING_EXEMPT_INDMissing mandatory value for Exempt indicator
The User Exempt indicator is missing and must be 'Y' (Yes) or 'N' (No).
MISSING_FGAC_USER_IDMissing mandatory value for User Default User ID
The User default FGAC User ID is missing and must be a valid value.
MISSING_USER_IDMissing mandatory value for User ID
The User ID is missing and must be a valid value.
PK_NOT_FOUNDCannot find User Default record using primary or unique key
An attempt to find a User default record was unsuccessful because the record could not be found using the primary or unique key of FGAC User ID.
P_DELETE_FAILEDCannot delete User Default, record does not exist
An attempt to delete a User default record was unsuccessful because the record does not exist.
RECORD_EXISTSCannot create User Default, record already exists
An attempt to create a User Default record was unsuccessful because the record already exists.


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 the error message. Required