Package sb_crse_atts_restriction

Package sb_crse_atts_restriction_str

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

Message Name	Error Message
COPY_ERROR	Course student attribute restrictions cannot be copied because the from term is not the most recent term.
An attempt was made to copy course student attribute restrictions from a term that is not the most recent term for which restrictions exist.
INVALID_ATTS_CODE	Student attribute code for the course student attribute restriction is not valid.
An attempt was made to create or update a course student attribute restriction with an invalid student attribute code.
INVALID_ATTS_IE_CDE	Include/Exclude value for the course student attribute restriction is not valid. Valid values are I and E.
An attempt was made to create or update a course student attribute restriction with an invalid Include/Exclude value.
INVALID_EFF_TERM	Effective term for the course student attribute restriction is not valid.
An attempt was made to create or update a course student attribute restriction with an invalid term code.
INVALID_REC_TYPE	Record type for the course student attribute restriction is not valid. Valid values are 1 and 2.
An attempt was made to create or update a course student attribute restriction with an invalid record type.
INVALID_SUBJ_CODE	Subject code for the course student attribute restriction is not valid.
An attempt was made to create or update a course student attribute restriction with an invalid subject code.
MISSING_BASE	Course base record does not exist for the effective term of the course student attribute restriction.
Check the course base record on the SCABASE form for the valid term range.
MISSING_CRSE_NUMB	Course number is missing and is required for course student attribute restrictions.
An attempt was made to create or update a course student attribute restriction without the required course number.
MISSING_CTRL_RECORD	Course student attribute restriction code (Type 2) record cannot be created without an existing control (Type 1) record.
A course student attribute restriction control (Type 1) record is required before creating a course student attribute restriction code (Type 2) record.
MISSING_EFF_TERM	Effective term is missing and is required for course student attribute restrictions.
An attempt was made to create or update a course student attribute restriction without the required term code.
MISSING_REC_TYPE	Record type is missing and is required for course student attribute restrictions.
An attempt was made to create or update a course student attribute restriction without the required record type.
MISSING_SUBJ_CODE	Subject code is missing and is required for course student attribute restrictions.
An attempt was made to create or update a course student attribute restriction without the required subject code.
MISSING_USER_ID	User identification is missing and is required for course student attribute restrictions.
An attempt was made to create or update a course student attribute restriction without the user ID.
NO_UPDATE	Course student attribute restriction code (Type 2) record cannot be updated.
Course student attribute restriction code cannot be updated because it is part of the unique index.
PK_NOT_FOUND	Cannot find the course student attribute restriction record using the primary or unique key.
Course student attribute restriction does not exist.
P_DELETE_FAILED	Cannot delete the course student attribute restriction because the record does not exist.
Course student attribute restriction does not exist.
P_SEQUENCE_ERROR	Oracle sequence error occurred on the primary key of the course student attribute restriction.
Report this error to your system administrator.
RECORD_EXISTS	Course student attribute restriction cannot be created because the record already exists.
Course student attribute restriction already exists.
REC_TYPE_CODE_ERROR	Student attribute code must be null to create a course 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 course 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 course 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 course student attribute restriction control (Type 1) record or must be null for a restriction code (Type 2) record.
TYPE1_DELETE_ERROR	Course student attribute restriction control (Type 1) record cannot be deleted because a restriction code (Type 2) record exists.
Course student attribute restriction code (Type 2) records must be deleted before deleting the course student attribute restriction control (Type 1) record.
TYPE1_QUERY_ERROR	Student attribute code cannot be specified for a course student attribute restriction control (Type 1) record.
Student attribute code can only be specified for course student attribute restriction code (Type 2) records.
TYPE2_QUERY_ERROR	Student attribute code must be specified for a course student attribute restriction code (Type 2) record.
Student attribute code must be specified for course 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.