index

Package sb_enrollment_str

NOTE: Please be advised that this API is currently intended to only support internal operations.
To ensure data integrity, this API is not supported when called by external applications or interfaces to manipulate data. The recommendation for external applications is to use message level integration to integrate with this entitity in Banner.
 
This package contains the error messages and error message functions for the Enrollment API (sb_enrollment).

Message KeyError Message
HOLD_EXISTSStudent has a hold that prevents enrollment
An attempt was made to create or update student enrollment, however a hold exists for the student which prevents enrollment.
INVALID_ACAD_STANDINGStudent academic standing prevents enrollment
An attempt was made to create or update student enrollment, however the academic standing status prevents enrollment.
INVALID_AR_INDInvalid accounts receivable indicator, Valid values are (Y)es, (C)onfirmed or (N)o
An attempt was made to create or update student enrollment term charges acceptance indicator with a value other than 'Y' (registration charges accepted), 'C' (registration confirmed) or 'N' (registration not confirmed).
INVALID_COMB_ACAD_STANDINGStudent combined academic standing prevents enrollment
An attempt was made to create or update student enrollment, however the combined academic standing status prevents enrollment.
INVALID_ESTS_CODEInvalid enrollment status value
The student enrollment status code entered must be a valid value in the Enrollment Status Code validation table (STVESTS).
INVALID_PIDMInvalid learner identification number
An attempt was made to create, update or delete a student enrollment record for a student that does not exist.
INVALID_REG_STATUSStudent status prevents enrollment
An attempt was made to create or update enrollment for a student, however the registration status prevents (validation table STVSTST or STVESTS) enrollment.
INVALID_RGRE_CODEInvalid enrollment registration reason value
The registration reason code entered must be a valid value in the Registration Reason Code validation table (STVRGRE).
INVALID_STATUS_DATEInvalid enrollment status date range
An attempt was made to create or update student enrollment with an enrollment status that is not available for the enrollment date.  The enrollment status date must be between the start and end dates defined in the Enrollment Status Controls.
INVALID_STUDENTPerson not a student, cannot register
An attempt was made to create or update enrollment for a student, however a general student record does not exist for the person.
INVALID_TERM_CODEInvalid enrollment term value
The student enrollment term code entered must be valid value in the Term Code Validation table (STVTERM).
INVALID_TERM_STATUSEnrollment term prohibits registration
An attempt was made to create an enrollment for a student, however the base term does not allow registration (SOATERM).
INVALID_TMST_CODEInvalid enrollment time status value
The student enrollment time status code must be a valid value in the Time Status Code validation table (STVTMST).
INVALID_MINH_SRCE_CDEInvalid minimum enrollment hours source code, Valid values are (A)STD, (C)AST, (M)HRS or (U)SER
An attempt was made to create or update student enrollment minimum enrollment hours source code with a value other than (A)STD, (C)AST, (M)HRS or (U)SER.
INVALID_MAXH_SRCE_CDEInvalid maximum enrollment hours source code, Valid values are (A)STD, (C)AST, (M)HRS or (U)SER
An attempt was made to create or update student enrollment minimum enrollment hours source code with a value other than (A)STD, (C)AST, (M)HRS or (U)SER.
MISSING_ADD_DATEMissing mandatory enrollment add date
The student enrollment add date is missing and must be a valid date value and format.
MISSING_AR_INDMissing mandatory accounts receivable indicator
The student enrollment term charges acceptance indicator is missing and must be designated with a value of 'Y' (Yes), 'C' (Confirmed) or 'N' (No).
MISSING_ESTS_CODEMissing mandatory enrollment status value
The student enrollment status code is missing and must be a valid value in the Enrollment Status Code validation table (STVESTS).
MISSING_MIN_HRSMissing mandatory minimum enrollment hours
The student enrollment minimum hours is missing and must be a valid number in the format 999999.999
MISSING_MHRS_OVERMissing mandatory maximum override hours
The student enrollment maximum hours is missing and must be a valid number in the format 999999.999
MISSING_PIDMMissing mandatory learner identification number
The required person record (PIDM) is missing and must match an existing person record (PIDM).
MISSING_TERM_CODEMissing mandatory enrollment term value
The student enrollment term code is missing and must be a valid value in the Term Code validation table (STVTERM).
PAYMENT_MADEAn accounts receivable activity exists for the enrollment term; cannot delete
An attempt to delete the student enrollment record was unsuccessful because accounts receivable charges associated with course enrollment exists.
PK_NOT_FOUNDCannot find an enrollment term record
An attempt to update or delete a student enrollment record was unsuccessful because the record could not be found using the primary key of student pidm and term code.
P_DELETE_FAILEDCannot delete, record does not exist
An attempt to delete a student enrollment record was unsuccessful because the record could not be found.
RECORD_EXISTSCannot create, enrollment record already exists
An attempt to create a student enrollment record was unsuccessful because the record already exists; duplicates are not allowed.
REG_DATA_EXISTSCourse registration data exists for the enrollment term; cannot delete
An attempt to delete the student enrollment record was unsuccessful because at least one course registration record exists.


Program units
f_get_error   Returns the error message corresponding to p_errorname.

Variables
error_tab   Global error table that holds the error message.


error_tab

error_tab gb_common_strings.errmsg_tab_type;

Global error table that holds the error message.


f_get_error

Function f_get_error(p_errorname VARCHAR2) return varchar2

Returns the error message corresponding to p_errorname.

Parameters
p_errorname   Name associated with the error message.