index

Package gb_emergency_contact_strings

Error messages and error message functions for EMERGENCY_CONTACT (gb_emergency_contact).
 

Message KeyError Message
ENTITY_ERROREmergency Contacts cannot be created for Companies
The Entity Indicator in the SPRIDEN table must be P in order to create an Emergency Contact record.
INVALID_ATYP_CODEInvalid value for Address Type Code
The Address Type must be found in the STVNATN table.
INVALID_NATN_CODEInvalid value for Nation Code
The Nation Code must be found in the STVNATN table.
INVALID_PIDMInvalid value for PIDM
The PIDM must be found in the the SPRIDEN table.
INVALID_PRIORITYInvalid value for Priority
The Priority must be between 1 and 9.
INVALID_RELT_CODEInvalid value for Relationship code
The Relationship code must be found in the STVRELT table.
INVALID_STAT_CODEInvalid value for State Code
The State Code must exist in the STVSTAT table.
MISSING_FIRST_NAMEMissing mandatory value for First Name
First name is required.
MISSING_LAST_NAMEMissing mandatory value for Last Name
Last Name is required.
MISSING_PIDMMissing mandatory value for PIDM
PIDM cannot be null.
MISSING_PRIORITYMissing mandatory value for Priority
Priority is required.
NATION_STATE_ERRORIf Address and City are provided, then State or Nation is required
Enter a State Code, Nation Code, or both.
  Cannot find record using primary or unique key
There is no Emergency Contact record for the given PIDM and priority.
P_DELETE_FAILEDCannot delete, record does not exist
There is no Emergency Contact record for this PIDM.
RECORD_EXISTSCannot create, record already exists
There is already a record for this PIDM and priority.
Either create the new record with a different priority or use a different PIDM.
STREET_LINE1_ERRORIf Street Line1 is specified then City is required
Provide a value for City.
ZIP_ERRORZip is required when State code is provided
Provide a value for Zip.


Program units
f_get_error   Returns the error message corresponding to p_errorname.

Variables
error_tab   PL/SQL table type to hold API specific error message strings.


error_tab

error_tab gb_common.errmsg_tab_type;

PL/SQL table type to hold API specific error message strings.


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.