index

Package nb_effcert_dflt_queue_strings

This package contains the error messages and error message functions for the Effort Certification Default Queue Rule API (NB_EFFCERT_DFLT_QUEUE).
 

Message NameError Message
DATA_SOURCE_GROUPCannot create Effort Certification Default Queue Rule, Participant Data Source is defined as Group.
An attempt was made to create a new EFFCERT_DFLT_QUEUE record, but Participant Data Source is defined as a group.
INVALID_ALT_CERTIFIER_INDInvalid Alternate Certifier Indicator for Effort Certification Default Queue Rule. Valid Values are (Y)es and (N)o.
Invalid Alternate Certifier Indicator for Effort Certification Default Queue Rule, Valid Values: (Y)es and (N)o.
INVALID_GRAD_CERT_REQ_INDInvalid Required Certification For Graduate Students Indicator for Effort Certification Default Queue Rule. Valid Values are (Y)es and (N)o.
Invalid Required Certification For Graduate Students Indicator for Effort Certification Default Queue Rule, Valid Values: (Y)es and (N)o.
INVALID_POST_REVIEW_ACTIONInvalid Post-Review Action for Effort Certification Default Queue Rule. Valid Values are (F)YI, (R)eview, and (N)one.
Invalid Post-Review Action for Effort Certification Default Queue Rule, Valid Values: (F)YI, (R)eview, and (N)one.
INVALID_PRE_REVIEW_ACTIONInvalid Pre-Review Action for Effort Certification Default Queue Rule. Valid Values are (F)YI, (R)eview, and (N)one.
Invalid Pre-Review Action for Effort Certification Default Queue Rule, Valid Values: (F)YI, (R)eview, and (N)one.
MISSING_ALT_CERTIFIER_INDMissing Alternate Certifier Indicator for Effort Certification Default Queue Rule.
A Alternate Certifier Indicator must be provided. Valid values are: (Y)es and (N)o.
MISSING_PRE_REVIEW_ACTIONMissing Pre-Review Action for Effort Certification Default Queue Rule.
A Pre-Review Action must be provided. Valid values are: (F)YI, (R)eview, and (N)one.
MISSING_POST_REVIEW_ACTIONMissing Post-Review Action for Effort Certification Default Queue Rule.
A Post-Review Action must be provided. Valid values are: (F)YI, (R)eview, and (N)one.
MISSING_GRAD_CERT_REQ_INDMissing Required Certification For Graduate Students Indicator for Effort Certification Default Queue Rule.
A Required Certification For Graduate Students Indicator must be provided. Valid values are: (Y)es and (N)o
MISSING_NTRQPRT_IDMissing mandatory Effort Certification Queue Participant Rule ID for Effort Certification Default Queue Rule.
The Effort Certification Queue Participant ID parameter was omitted when calling a function or procedure in the Effort Certification Default Queue Rule API. This parameter is a key value for the EFFCERT_DFLT_QUEUE entity and must be provided.
MISSING_PARENTNo Effort Certification Routing Queue Participant record exists for Effort Certification Default Queue Rule.
An attempt was made to create a EFFCERT_DFLT_QUEUE record, but no parent record with these key values could be found.
PK_NOT_FOUNDCannot update Effort Certification Default Queue Rule, record does not exist.
The combination of required parameters does not refer to an existing EFFCERT_DFLT_QUEUE entity.
P_DELETE_FAILEDCannot delete Effort Certification Default Queue Rule, record does not exist.
An attempt was made to delete a EFFCERT_DFLT_QUEUE record, but a record with these key values (or rowid) could not be found.
RECORD_EXISTSCannot create Effort Certification Default Queue Rule, record already exists.
An attempt was made to create a new EFFCERT_DFLT_QUEUE record, but a record already exists with these key values.


Program units
f_get_error   Returns the error message corresponding to p_errorname.

Variables
error_tab   Global PL/SQL table that holds the error messages.


error_tab

error_tab gb_common_strings.errmsg_tab_type;

Global PL/SQL table that holds the error messages.


f_get_error

Function f_get_error(p_errorname VARCHAR2)
  RETURN gb_common_strings.err_type

Returns the error message corresponding to p_errorname.

Parameters
p_errorname   Name associated with the error message.