index

Package gb_email_strings

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

Message KeyError Message
INVALID_DISP_WEB_INDDisplay on Web indicator must be Y or N.
Display on Web indicator must be Y or N.
INVALID_EMAL_CODEInvalid value for e-mail Code.
e-mail Code must exist in the GTVEMAL table.
INVALID_PIDMInvalid value for PIDM.
PIDM must exist in the SPRIDEN table.
INVALID_PREFERRED_EMAILThe preferred e-mail address type should be Active.
The record is marked as the preferred e-mail address, but it is inactive. The preferred indicator may only be Y on active e-mail records. 
INVALID_PREFERRED_INDPreferred indicator must be Y or N.
Preferred indicator must be Y or N.
INVALID_STATUS_INDStatus indicator must be A or I.
Status indicator must be A or I.
MISSING_DISP_WEB_INDDisplay on Web indicator is required. It must be Y or N.
Display on Web indicator is required. It must be Y or N.
MISSING_EMAIL_ADDRESSe-mail address is required.
E-mail address is required.
MISSING_EMAL_CODEE-mail Code is required.
E-mail Code is required.
MISSING_PIDMPIDM is required.
PIDM is required.
MISSING_PREFERRED_INDPreferred indicator is required. It must be Y or N.
Preferred indicator is required. It must be Y or N.
MISSING_STATUS_INDStatus indicator is required. It must be A or I.
Status indicator is required. It must be A or I.
MISSING_USER_IDUser ID is required.
Oracle User ID is required.
PK_NOT_FOUNDCannot find record using primary or unique key.
For e-mail, the key is composed of PIDM, e-mail Code and e-mail Address. The values given for these three parameters cannot be found in the GOREMAL table
PREFERRED_EXISTSPreferred e-mail already exists.
Only one e-mail record can be marked as preferred. Locate the existing record with the preferred indicator set and clear it before setting another record to preferred.
P_DELETE_FAILEDCannot delete, record does not exist.
A record with the specified PIDM, E-Mail Code and e-mail Address cannot be located in the GOREMAL table.
RECORD_EXISTSCannot create, record already exists.
A record with the specified PIDM, E-Mail Code and e-mail Address already exists in the GOREMAL table. Specify a different e-mail code or e-mail Address

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.