index

Package gb_userpiidomains_str

This package contains the error messages and error message functions for the USER PII DOMAINS API, gb_userpiidomains.

Message KeyError Message
INVALID_FDMN_CODE_PIIInvalid value for FGAC Domain Personal Identifiable Information code
An attempt was made to create or update the Personal Identifiable Information to an invalid value.  The Domains code must exist as a valid domain on the FGAC Domains Validation form (GTVFDMN).
MISSING_FDMN_CODE_PIIMissing mandatory value for FGAC Domain Personal Identifiable Information code
The FGAC Domain Personal Identifer Information code is missing and must exist as a valid domain on the FGAC Domains Validation form (GTVFDMN).
MISSING_FGAC_USER_IDMissing mandatory value for FGAC User ID for whom the Personal Identifiable Information Domains apply
The FGAC Domains Personal Identifiable Information User ID is missing and must be a vlid value in all_users table.
MISSING_USER_IDMissing mandatory value for FGAC User ID
The FGAC Personal Identifiable Information User ID is missing.
PK_NOT_FOUNDCannot find record using primary or unique key
An attempt to update or delete a FGAC Personal Identifiable Information record was unsuccessful because the record could not be found using the primary key of domain and PII User ID.
GOBFPUD_EXISTSCannot delete record when child record exists on GOBFPUD
An attempt to delete a User Personal Identifiable Information record was unsuccessful because a FGAC Person User Defaults record exists for that record.
P_DELETE_FAILEDCannot delete, record does not exist
An attempt to delete a User Personal Identifiable Information record was unsuccessful because the record could not be found.
RECORD_EXISTSCannot create, record already exists
An attempt to create a User Personal Identifiable Information 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 the error message. Required