index

Package gb_domaintype_str

Error messages and error message functions for the DOMAIN TYPE API, gb_domaintype.
 

Message Key Error Message
MISSING_FDTP_CODEDomain Type - Missing mandatory value for GOBFDTP_FDTP_CODE.
The FGAC Domain Type Code is missing and must be a valid value, as defined on the GTVFGAC table.
MISSING_PREDICATE_INDDomain Type - Missing mandatory value for GOBFDTP_PREDICATE_IND.
The FGAC Domain Type Predicate indicator is missing and must be a valid value. Valid values are "Y" (Yes) and "N" (No).
MISSING_SYS_REQ_INDDomain Type - Missing mandatory value for GOBFDTP_SYS_REQ_IND.
The FGAC Domain Type System Required indicator is missing and must be a valid value. Valid values are "Y" (Yes) and "N" (No).
MISSING_USER_IDDomain Type - Missing mandatory value for GOBFDTP_USER_ID.
The FGAC Domain Type User ID is missing and must be a valid value.
INVALID_FDTP_CODEDomain Type - Invalid value for GOBFDTP_FDTP_CODE.
The FGAC Domain Type Code entered must be a valid value in the FGAC Code Validation table (GTVFGAC).
INVALID_PREDICATE_INDDomain Type - Invalid value for GOBFDTP_PREDICATE_IND.
The FGAC Domain Type Predicate indicator entered must have a value of "Y" (Yes) or "N" (No).
INVALID_SYS_REQ_INDDomain Type - Invalid value for GOBFDTP_SYS_REQ_IND.
The FGAC Domain Type System Required indicator entered must have a value of "Y" (Yes) or "N" (No).
PK_NOT_FOUNDCannot find Domain Type record using primary or unique key.
An attempt to find a FGAC Domain Type record was unsuccessful using the primary or unique key.
RECORD_EXISTSCannot create Domain Type, record already exists.
An attempt to create a FGAC Domain Type record was unsuccessful because the record already exists.
GOBFDMN_EXISTSCannot delete Domain Type, GOBFDMN exists.
An attempt to delete a FGAC Domain Type record was unsuccessful because a GOBFDMN record exists.
RECORD_REQUIREDCannot delete Domain Type, record required.
An attempt to delete a FGAC Domain Type record was unsuccessful because the record is system required.


Program units
f_get_error   Returns an 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 an error message corresponding to p_errorname.

Parameters
p_errorname   Name associated with error message. Required