Package nb_effcert_addl_queue

Package nb_effcert_addl_queue_strings

This package contains the error messages and error message functions for the Effort Certification Additional Queue Members API (NB_EFFCERT_ADDL_QUEUE).

Message Name	Error Message
CHILD_EXISTS	Cannot delete Effort Certification Additional Queue Members, Effort Certification Member Fund Type record exists.
An attempt was made to delete a EFFCERT_ADDL_QUEUE record, but a child record with these key values was found.
INVALID_ALT_CERTIFIER_IND	Invalid Alternate Certifier Indicator for Effort Certification Additional Queue Members, valid values: (Y)es alternate certifier and (N)o, not an alternate certifier.
There are two valid values for Alternate Certifier Indicator: (Y)es alternate certifier and (N)o, not an alternate certifier.
INVALID_COAS_CODE	Invalid Chart Of Accounts for Effort Certification Additional Queue Members.
An invalid Chart Of Accounts parameter was provided when calling a function or procedure in the Effort Certification Additional Queue Members API (NB_EFFCERT_ADDL_QUEUE). The code must exist in the Chart of Accounts Validation table (FTVCOAS).
INVALID_FTYP_INCL_EXCL_TYPE	Invalid Include Or Exclude Fund Type for Effort Certification Additional Queue Members, valid values: (I)nclude, (E)xclude and Include (A)ll.
There are three valid values for Include Or Exclude Fund Type: (I)nclude, (E)xclude and Include (A)ll.
INVALID_GRAD_CERT_REQ_IND	Invalid Required Certification for Graduate Students Indicator for Effort Certification Additional Queue Members, valid values: (Y)es and (N)o.
There are two valid values for Required Certification for Graduate Students Indicator: (Y)es and (N)o.
INVALID_MEMBER_USER_ID	Invalid User Name for Effort Certification Additional Queue Members.
An invalid User Name parameter was provided when calling a function or procedure in the Effort Certification Additional Queue Members API (NB_EFFCERT_ADDL_QUEUE). The code must exist in the Enterprise Oracle Access Table (GOBEACC).
INVALID_ORGN_CODE	Invalid Organization for Effort Certification Additional Queue Members.
An invalid Organization parameter was provided when calling a function or procedure in the Effort Certification Additional Queue Members API (NB_EFFCERT_ADDL_QUEUE). The code must exist in the Organization Validation table (FTVORGN).
INVALID_POST_REVIEW_ACTION	Invalid Post-Reviewer Action for Effort Certification Additional Queue Members, valid values: (N)one, (F)YI, and (R)eview.
There are three valid values for Post-Reviewer Action: (N)one, (F)YI, and (R)eview.
INVALID_PRE_REVIEW_ACTION	Invalid Pre-Reviewer Action for Effort Certification Additional Queue Members, valid values: (N)one, (F)YI, and (R)eview.
There are three valid values for Pre-Reviewer Action: (N)one, (F)YI, and (R)eview.
MISSING_ALT_CERTIFIER_IND	Missing mandatory Alternate Certifier Indicator for Effort Certification Additional Queue Members.
The Alternate Certifier Indicator parameter was omitted when calling a function or procedure in the Effort Certification Additional Queue Members API (NB_EFFCERT_ADDL_QUEUE). This parameter is a key value for the EFFCERT_ADDL_QUEUE entity and must be provided.
MISSING_COAS_CODE	Missing mandatory Chart Of Accounts for Effort Certification Additional Queue Members.
The Chart Of Accounts parameter was omitted when calling a function or procedure in the Effort Certification Additional Queue Members API (NB_EFFCERT_ADDL_QUEUE). This parameter is a key value for the EFFCERT_ADDL_QUEUE entity and must be provided.
MISSING_FTYP_INCL_EXCL_TYPE	Missing mandatory Include Or Exclude Fund Type for Effort Certification Additional Queue Members.
The Include Or Exclude Fund Type parameter was omitted when calling a function or procedure in the Effort Certification Additional Queue Members
MISSING_PRE_REVIEW_ACTION	Missing mandatory Pre-Review Action for Effort Certification Additional Queue Members.
The Pre-Review Action parameter was omitted when calling a function or procedure in the Effort Certification Additional Queue Members
MISSING_POST_REVIEW_ACTION	Missing mandatory Post-Review Action for Effort Certification Additional Queue Members.
The Post-Review Action parameter was omitted when calling a function or procedure in the Effort Certification Additional Queue Members API (NB_EFFCERT_ADDL_QUEUE). This parameter is a key value for the EFFCERT_ADDL_QUEUE entity and must be provided.
MISSING_GRAD_CERT_REQ_IND	Missing mandatory Required Certification for Graduate Students Indicator for Effort Certification Additional Queue Members.
The Required Certification for Graduate Students Indicator parameter was omitted when calling a function or procedure in the Effort Certification Additional Queue Members API (NB_EFFCERT_ADDL_QUEUE). This parameter is a key value for the EFFCERT_ADDL_QUEUE entity and must be provided.
MISSING_MEMBER_USER_ID	Missing mandatory User Name for Effort Certification Additional Queue Members.
The User Name parameter was omitted when calling a function or procedure in the Effort Certification Additional Queue Members API (NB_EFFCERT_ADDL_QUEUE). This parameter is a key value for the EFFCERT_ADDL_QUEUE entity and must be provided.
MISSING_ORGN_CODE	Missing mandatory Organization for Effort Certification Additional Queue Members.
The Organization parameter was omitted when calling a function or procedure in the Effort Certification Additional Queue Members API (NB_EFFCERT_ADDL_QUEUE). This parameter is a key value for the EFFCERT_ADDL_QUEUE entity and must be provided.
PK_NOT_FOUND	Cannot update Effort Certification Additional Queue Members, record does not exist.
The combination of required parameters does not refer to an existing EFFCERT_ADDL_QUEUE entity.
P_DELETE_FAILED	Cannot delete Effort Certification Additional Queue Members, record does not exist.
An attempt was made to delete a EFFCERT_ADDL_QUEUE record, but a record with these key values (or ROWID) could not be found.
RECORD_EXISTS	Cannot create Effort Certification Additional Queue Members, record already exists.
An attempt was made to create a new EFFCERT_ADDL_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.