index

Package gb_telephone_strings

Error messages and error message functions for the TELEPHONE API (GB_TELEPHONE).
 

Message KeyError Message
INVALID_ATYP_CODEInvalid value for Telephone Address Type
The Telephone Address type must match an Address Type Code from STVATYP.
INVALID_PIDMInvalid or missing PIDM
Supply a value for PIDM.
INVALID_PRIMARY_INDInvalid value for Primary Indicator
The Primary Indicator must be Y or NULL.
INVALID_STATUS_INDInvalid value for Telephone Status Indicator
Use Y for active, null for inactive.
INVALID_TELE_CODEInvalid value for Telephone Code
The Telephone Code must exist in the STVTELE table. Either correct the Telephone Code or add it to STVTELE.
INVALID_UNLIST_INDUnlisted Indicator must be Y or NULL
Unlisted Indicator must be Y or NULL
MISSING_PIDMMissing mandatory value for PIDM
A PIDM must be provided to perform any Create, Update or Delete operation on Telephone
MISSING_SEQNOMissing mandatory value for Telephone Sequence number
A Telephone Sequence number distinguishes one phone number of a type from another.
Every Create, Update, or Delete operation requires that a sequence number be provided, and one was not found.
MISSING_TELE_CODEMissing mandatory value for Telephone Code
The Telephone Code defines what type of telephone number this is, and is required. One was not provided for this operation.
P_DELETE_FAILEDCould not locate record to delete
There is no telephone record with this PIDM telephone code and sequence number to delete.

Program units
f_get_error   Returns the error message corresponding to p_errorname.

Variables
error_tab   PL/SQL table that holds error messages for this API.

error_tab 

error_tab gb_common.errmsg_tab_type;

PL/SQL table that holds error messages for this API.

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.

Returns
Error message corresponding to p_errorname.