index

Package gb_busprofpii_str

This package contains the error messages and error message functions for GB_BUSPROFPII_STR.

Message KeyError Message
INVALID_FBPR_CODEInvalid value for PII Business Profile Code
An attempt was made to create or update the PII Business Profile Code.  It must be valid in the table GTVFBPR.
INVALID_FDMN_CODEInvalid value for PII Domain Code
An attempt was made to create or update the PII Domain Code.  It must be valid in the table GTVFDMN.
INVALID_USER_IDInvalid value for PII User ID
The Business Profile PII User ID is missing and must be a valid user in table ALL_USERS.
MISSING_FBPR_CODEMissing mandatory value for PII Business Profile Code
The PII Business Profile Code is missing and must be a valid code in the Business Profile Validation table (GTVFBPR).
MISSING_FDMN_CODEMissing mandatory value for PII Domain code
The PII Domain code is missing and must be a valid code in the Domain Code validation table (GTVFDMN).
MISSING_PARENTRequired parent record not found
Required parent record not found
MISSING_USER_IDMissing mandatory value for PII User ID
An attempt was made to create or update the PII Business Profile without a User ID.
PK_NOT_FOUNDCannot find record using primary or unique key
An attempt to update or delete a PII Business Profile record was unsuccessful because the record could not be found using the primary key.
P_DELETE_FAILEDCannot delete, record does not exist
An attempt to delete a PII Business Profile was unsuccessful because the record does not exists.
RECORD_EXISTSCannot create, record already exists
An attempt to create a PII Business Profile was unsuccessful because the record already exists;  duplicates are not allowed.


Program units
f_get_error   Returns error message corresponding to p_errorname.

Variables
error_tab   Global variable for storing the error messages.


error_tab

error_tab gb_common_strings.errmsg_tab_type;

Global variable for storing the error messages.


f_get_error

FUNCTION f_get_error(p_errorname VARCHAR2) RETURN VARCHAR2

Returns error message corresponding to p_errorname.

Parameters
p_errorname   Name associated with error message.