Package sb_sect_dept_restriction

Package sb_sect_dept_restriction_str

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

Message Name	Error Message
INVALID_DEPT_CODE	Department code for the section department restriction is not valid.
An attempt was made to create or update a section department restriction with an invalid department code.
INVALID_DEPT_IE_CDE	Include/Exclude value for the section department restriction is not valid. Valid values are I and E.
An attempt was made to create or update a section department restriction with an invalid Include/Exclude value.
INVALID_REC_TYPE	Record type for the section department restriction is not valid. Valid values are 1 and 2.
An attempt was made to create or update a section department restriction with an invalid record type.
INVALID_TERM_CODE	Term code for the section department restriction is not valid.
An attempt was made to create or update a section department restriction with an invalid term code.
MISSING_CRN	Course reference number is missing and is required for section department restrictions.
An attempt was made to create or update a section department restriction without the required course reference number.
MISSING_CTRL_RECORD	Section department restriction code (Type 2) record cannot be created without an existing control (Type 1) record.
A section department restriction control (Type 1) record is required before creating a section department restriction code (Type 2) record.
MISSING_REC_TYPE	Record type is missing and is required for section department restrictions.
An attempt was made to create or update a section department restriction without the required record type.
MISSING_SECTION	Base section record does not exist for the section department restriction.
Check the section base record for the valid term and course reference number.
MISSING_TERM_CODE	Term code is missing and is required for section department restrictions.
An attempt was made to create or update a section department restriction without the required term code.
MISSING_USER_ID	User identification is missing and is required for section department restrictions.
An attempt was made to create or update a section department restriction without the user ID.
NO_UPDATE	Section department restriction code (Type 2) record cannot be updated.
Section department restriction code cannot be updated because it is part of the unique index.
PK_NOT_FOUND	Cannot find the section department restriction record using the primary or unique key.
Section department restriction does not exist.
P_DELETE_FAILED	Cannot delete the section department restriction because the record does not exist.
Section department restriction does not exist.
P_SEQUENCE_ERROR	Oracle sequence error occurred on the primary key of the section department restriction.
Report this error to your system administrator.
RECORD_EXISTS	Section department restriction cannot be created because the record already exists.
Section department restriction already exists.
REC_TYPE_CODE_ERROR	Department code must be null to create a section department restriction control (Type 1) record or not null to create a restriction code (Type 2) record.
Department code is required for a section department restriction code (Type 2) record or must be null for a control (Type 1) record.
REC_TYPE_IE_ERROR	Include/Exclude value must be specified for a section 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 section department restriction control (Type 1) record or must be null for a restriction code (Type 2) record.
TYPE1_DELETE_ERROR	Section department restriction control (Type 1) record cannot be deleted because a restriction code (Type 2) record exists.
Section department restriction code (Type 2) records must be deleted before deleting the section department restriction control (Type 1) record.
TYPE1_QUERY_ERROR	Department code cannot be specified for a section department restriction control (Type 1) record.
Department code can only be specified for section department restriction code (Type 2) records.
TYPE2_QUERY_ERROR	Department code must be specified for a section department restriction code (Type 2) record.
Department code must be specified for section department restriction code (Type 2) records.

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.