index

Package sb_crse_dept_restriction_str

This package contains the error messages and error message functions for the Course Department Restriction API (sb_crse_dept_restriction).

Message NameError Message
COPY_ERRORCourse department restrictions cannot be copied because the from term is not the most recent term.
An attempt was made to copy course department restrictions from a term that is not the most recent term for which restrictions exist.
INVALID_DEPT_CODEDepartment code for the course department restriction is not valid.
An attempt was made to create or update a course department restriction with an invalid department code.
INVALID_DEPT_IE_CDEInclude/Exclude value for the course department restriction is not valid. Valid values are I and E.
An attempt was made to create or update a course department restriction with an invalid Include/Exclude value.
INVALID_EFF_TERMEffective term for the course department restriction is not valid.
An attempt was made to create or update a course department restriction with an invalid term code.
INVALID_REC_TYPERecord type for the course department restriction is not valid. Valid values are 1 and 2.
An attempt was made to create or update a course department restriction with an invalid record type.
INVALID_SUBJ_CODESubject code for the course department restriction is not valid.
An attempt was made to create or update a course department restriction with an invalid subject code.
MISSING_BASECourse base record does not exist for the effective term of the course department restriction.
Check the course base record on the SCABASE form for the valid term range.
MISSING_CRSE_NUMBCourse number is missing and is required for course department restrictions.
An attempt was made to create or update a course department restriction without the required course number.
MISSING_CTRL_RECORDCourse department restriction code (Type 2) record cannot be created without an existing control (Type 1) record.
A course department restriction control (Type 1) record is required before creating a course department restriction code (Type 2) record.
MISSING_EFF_TERMEffective term is missing and is required for course department restrictions.
An attempt was made to create or update a course department restriction without the required term code.
MISSING_REC_TYPERecord type is missing and is required for course department restrictions.
An attempt was made to create or update a course department restriction without the required record type.
MISSING_SUBJ_CODESubject code is missing and is required for course department restrictions.
An attempt was made to create or update a course department restriction without the required subject code.
MISSING_USER_IDUser identification is missing and is required for course department restrictions.
An attempt was made to create or update a course department restriction without the user ID.
NO_UPDATECourse department restriction code (Type 2) record cannot be updated.
Course department restriction code cannot be updated because it is part of the unique index.
PK_NOT_FOUNDCannot find the course department restriction record using the primary or unique key.
Course department restriction does not exist.
P_DELETE_FAILEDCannot delete the course department restriction because the record does not exist.
Course department restriction does not exist.
P_SEQUENCE_ERROROracle sequence error occurred on the primary key of the course department restriction.
Report this error to your system administrator.
RECORD_EXISTSCourse department restriction cannot be created because the record already exists.
Course department restriction already exists.
REC_TYPE_CODE_ERRORDepartment code must be null to create a course department restriction control (Type 1) record or not null to create a restriction code (Type 2) record.
Department code is required for a course department restriction code (Type 2) record or must be null for a control (Type 1) record.
REC_TYPE_IE_ERRORInclude/Exclude value must be specified for a course department restriction control (Type 1) record or must be null for a restriction code (Type 2) record.
Include/Exclude value must be I or E for a course department restriction control (Type 1) record or must be null for a restriction code (Type 2) record.
TYPE1_DELETE_ERRORCourse department restriction control (Type 1) record cannot be deleted because a restriction code (Type 2) record exists.
Course department restriction code (Type 2) records must be deleted before deleting the course department restriction control (Type 1) record.
TYPE1_QUERY_ERRORDepartment code cannot be specified for a course department restriction control (Type 1) record.
Department code can only be specified for course department restriction code (Type 2) records.
TYPE2_QUERY_ERRORDepartment code must be specified for a course department restriction code (Type 2) record.
Department code must be specified for course department restriction code (Type 2) records.

Program units
f_get_error  

Variables
error_tab  

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.