Package sb_course_labor

Package sb_course_labor_strings

This package contains the error messages and error message functions for Course Labor Distribution API (sb_course_labor).

Message Name	Error Message
INVALID_ACCI_CODE	Account Index for the course labor distribution is not valid.
An attempt was made to create or update the Course Labor Distribution Account Index with an invalid value.
INVALID_ACCT_CODE	Account for the course labor distribution is not valid.
An attempt was made to create or update the Course Labor Distribution Account with an invalid value.
INVALID_ACCT_EXTERNAL_CDE	External Account Code for the course labor distribution is not valid.
An attempt was made to create or update the Course Labor Distribution External Account Code with an invalid value.
INVALID_ACTV_CODE	Activity for the course labor distribution is not valid.
An attempt was made to create or update the Course Labor Distribution Activity with an invalid value.
INVALID_COAS_CODE	Chart Of Accounts Code for the course labor distribution is not valid.
An attempt was made to create or update the Course Labor Distribution Chart Of Accounts Code with an invalid value.
INVALID_CRSE_NUMB	Course Number for the course labor distribution is not valid.
An attempt was made to create or update the Course Labor Distribution Course Number with an invalid value.
INVALID_CTYP_CODE	Cost Type for the course labor distribution is not valid.
An attempt was made to create or update the Course Labor Distribution Cost Type with an invalid value.
INVALID_DATA_ORIGIN	Data Origin for the course labor distribution is not valid.
An attempt was made to create or update the Course Labor Distribution Data Origin with an invalid value.
INVALID_FUND_CODE	Fund for the course labor distribution is not valid.
An attempt was made to create or update the Course Labor Distribution Fund with an invalid value.
INVALID_LOCN_CODE	Location for the course labor distribution is not valid.
An attempt was made to create or update the Course Labor Distribution Location with an invalid value.
INVALID_ORGN_CODE	Organization for the course labor distribution is not valid.
An attempt was made to create or update the Course Labor Distribution Organization with an invalid value.
INVALID_PERCENT	Percentage for the course labor distribution is not valid.
An attempt was made to create or update the Course Labor Distribution Percentage with an invalid value.
INVALID_PROG_CODE	Program for the course labor distribution is not valid.
An attempt was made to create or update the Course Labor Distribution Program with an invalid value.
INVALID_PROJ_CODE	Project for the course labor distribution is not valid.
An attempt was made to create or update the Course Labor Distribution Project with an invalid value.
INVALID_SEQ_NO	Sequence Number for the course labor distribution is not valid.
An attempt was made to create or update the Course Labor Distribution Sequence Number with an invalid value.
INVALID_SUBJ_CODE	Subject Code for the course labor distribution is not valid.
An attempt was made to create or update the Course Labor Distribution Subject Code with an invalid value.
INVALID_TERM_CODE_EFF	Effective Term Code for the course labor distribution is not valid.
An attempt was made to create or update the Course Labor Distribution Effective Term Code with an invalid value.
INVALID_USER_ID	User Id for the course labor distribution is not valid.
An attempt was made to create or update the Course Labor Distribution User ID with an invalid value.
MISSING_CRSE_NUMB	Missing mandatory Course Number for course labor distribution.
The Course Number associated with the Subject is missing and must be entered.
MISSING_PARENT	Missing required parent record for course labor distribution.
Required parent record not found.
MISSING_PERCENT	Missing mandatory Percentage of Pay for course labor distribution.
The Percentage of Pay to be applied to this labor distribution is missing and must be entered.
MISSING_SEQ_NO	Missing mandatory Sequence Number for course labor distribution.
The Sequence Number of the course labor distribution is missing and must be entered.
MISSING_SUBJ_CODE	Missing mandatory Subject Code for course labor distribution.
The Subject Code is missing and must be entered
MISSING_TERM_CODE_EFF	Missing mandatory Effective Term Code for course labor distribution.
The Effective Term Code is missing and must be a valid value in the Term Code Validation Table (STVTERM).
MISSING_USER_ID	Missing mandatory value for most recent user ID to create or update the record.
User ID is missing and it is required for audit information.
PK_NOT_FOUND	Cannot find record using primary or unique key.
Cannot find record with subject code, course number, effective term code and course labor sequence number.
P_DELETE_FAILED	Cannot delete, record does not exist.
Record to be deleted does not exist.
RECORD_EXISTS	Cannot create course labor, record already exists.
A record currently exists having the same subject code, course number, effective term code and course labor sequence number.

Program units

f_get_error

Variables

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.