Package sb_sect_chrt_restriction

Package sb_sect_chrt_restriction_str

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

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