Package sb_sect_atts_restriction

Package sb_sect_atts_restriction_str

This package contains the error messages and error message functions for the Section Student Attribute Restriction API (sb_sect_atts_restriction).

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