index

Package sb_crse_chrt_restriction_str

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

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