index

Package sb_crse_mutual_exclusion_str

This package contains the error messages and error message functions for the Course Mutual Exclusion API (sb_crse_mutual_exclusion).

Message NameError Message
DUPLICATE_OVERLAPMutually exclusive course has duplicate or overlapping terms.
When entering the same mutual exclusion for multiple term ranges, the ranges cannot overlap.
EQUIVALENCY_EXISTSCourse already an equivalent, cannot be a mutual exclusion.
An excluded course cannot be both an equivalent and a mutual exclusion to the excluding course.
INVALID_CRSE_NUMBCourse number for the course mutual exclusion is not valid.
The course number for this subject does not exist in the database.
INVALID_CRSE_NUMB_MEXCCourse number for the course mutual exclusion is not valid.
The course number for this subject does not exist in the database.
INVALID_DATA_ORIGINData origin for the course mutual exclusion is not valid.
A valid data origin must be entered for the course mutual exclusion.
INVALID_EFF_TERMEffective term for the course mutual exclusion is not valid.
A valid term code must be entered for the effective term of the course mutual exclusion.
INVALID_END_TERMEnd term for the course mutual exclusion is not valid.
A valid term code must be entered for the end term of the course mutual exclusion.
INVALID_GRDE_CODEGrade for the course mutual exclusion is not valid.
A valid grade code must be entered for the course mutual exclusion.
INVALID_LEVL_CODELevel for the course mutual exclusion is not valid.
A valid level code must be entered for the course mutual exclusion.
INVALID_MEXC_TO_ITSELFA course cannot be a mutual exclusion to itself.
The excluded course cannot be the same as the excluding course.
INVALID_START_TERMStart term for the course mutual exclusion is not valid.
A valid term code must be entered for the start term of the course mutual exclusion.
INVALID_SUBJ_CODESubject for the course mutual exclusion is not valid.
A valid subject code must be entered for the course mutual exclusion.
INVALID_SUBJ_CODE_MEXCSubject for the course mutual exclusion is not valid.
A valid subject code must be entered for the course mutual exclusion.
INVALID_USER_IDUser ID for the course mutual exclusion is not valid.
A valid user ID must be entered for the course mutual exclusion.
MISSING_CRSE_NUMBCourse number is missing and is required by the course mutual exclusion.
Course number is required for the course mutual exclusion and cannot be null.
MISSING_EFF_TERMEffective term is missing and is required by the course mutual exclusion.
Effective term is required for the course mutual exclusion and cannot be null.
MISSING_PARENTThe excluding course does not exist in the catalog.
The excluding course of the mutual exclusion group does not exist in the catalog.
MISSING_PARENT_MEXCThe excluded course does not exist in the catalog.
The excluded course of the mutual exclusion group does not exist in the catalog.
MISSING_SUBJ_CODESubject is missing and is required by the course mutual exclusion.
Subject is required for the course mutual exclusion and cannot be null.
MISSING_USER_IDUser ID is missing and is required by the course mutual exclusion.
User ID is required for the course mutual exclusion and cannot be null.
PK_NOT_FOUNDCannot find record using primary or unique key for the course mutual exclusion.
Course mutual exclusion record cannot be found in the database using the primary or unique key.
P_DELETE_FAILEDCannot delete course mutual exclusion because the record does not exist.
Course mutual exclusion record cannot be deleted because it does not exist in the database.
P_SEQUENCE_ERROROracle sequence error occurred on the primary key of the course mutual exclusion restriction.
Report this error to your system administrator.
RECORD_EXISTSCourse mutual exclusion record cannot be created because it already exists.
Course mutual exclusion record already exists in the database.


Program units
f_get_error   Returns the error message corresponding to p_errorname.

Variables
error_tab   Global PL/SQL table that holds the error messages.


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.