index

Package sb_learner_str

This package contains the error messages and error message functions for the Learner API (sb_learner).  These messages are used in the sb_learner.p_insert, p_update p_delete and the validation procedure sb_learner_rules.p_validate.

Message KeyError Message
INVALID_ACYR_CODEInvalid learner academic year code
Academic Year (ACYR) code is invalid and does not exist in table STVACYR.
INVALID_APRN_CODEInvalid learner apprenticeship code
Apprenticeship (APRN) code is invalid and does not exist in table STVAPRN.
INVALID_ASTD_CODEInvalid learner academic standing code
Academic standing (ASTD) code is invalid and does not exist in table STVASTD.
INVALID_ASTD_EFF_TERMLearner ASTD term must equal learner effective term
Academic standing override term must equal the learner effective term.
INVALID_ASTD_MISSING_CODELearner ASTD code must be entered for academic standing term
Both the academic standing (ASTD) code and the academic standing term must be entered if either is not blank.
INVALID_ASTD_MISSING_TERMLearner ASTD term must be entered for academic standing code
Academic standing (ASTD) term must not be blank if the ASTD code is present.
INVALID_BLCK_CODEInvalid learner block code
Block (BLCK) code is invalid and must exist in table STVBLCK.
INVALID_BSKL_CODEInvalid learner basic skill code
Basic skill (BSKL) code is invalid and must exist in table STVBSKL.
INVALID_CAPL_CODEInvalid learner career planning
Career planning (CAPL) code is invalid and must exist in table STVCAPL.
INVALID_CAST_CODEInvalid learner combined academic standing code
Combined academic standing (CAST) code is invalid and must exist in table STVCAST.
INVALID_CAST_MISSING_CODELearner CAST code must be entered for combined academic standing term
Combined academic standing (CAST) code must be entered if the combined academic standing term is entered.
INVALID_CAST_MISSING_TERMLearner CAST Term must be entered for combined academic standing code
Combined academic standing (CAST) term must be entered if the combined academic standing code is entered.
INVALID_COLL_CODE_DUALInvalid learner dual degree college code
Dual degree college code is invalid and must exist in table STVCOLL.
INVALID_DEGC_CODE_DUALInvalid learner dual degree code
Dual degree code is invalid must exist in table STVDEGC.
INVALID_DEPT_CODE_DUALInvalid learner dual degree department code
Dual degree department code is invalid and must exist in table STVDEPT.
INVALID_EDLV_CODEInvalid learner education level code
Education level (EDLV) code is invalid and must exist in table STVEDLV.
INVALID_EGOL_CODEInvalid learner education goal code
Education goal (EGOL) code is invalid and must exist in table STVEGOL.
INVALID_EMEX_CODEInvalid learner employment expectation
Employment expectation (EMEX) code is invalid and must exist in table STVEMEX.
INVALID_FULL_PART_INDLearner Full/Part Time Indicator must be F or P
Learner full-time/part-time indicator must be F,P or null.
INVALID_GAIN_CODEInvalid learner gain status code
Employment and training (GAIN) code is invalid and must exist in table STVGAIN.
INVALID_GRAD_CREDIT_APPR_INDInvalid learner graduate credit approved indicator
Learner graduate credit approval indicator must be Y or blank.
INVALID_INCM_CODEInvalid learner income range code
Income Range (INCM) code is invalid and must exist in table STVINCM.
INVALID_LEAV_CODEInvalid learner leave code
Leave of absence (LEAV) code is invalid and must exist in table STVLEAV.
INVALID_LEAV_DATE_RANGELearner leave of absence from date must be less than the to date
Learner leave of absence from date must be less than the to date.
INVALID_LEAV_MISSING_CODELearner leave of absence code must be entered for leave dates
Learner leave of absence code must be entered for the leave dates.
INVALID_LEAV_MISSING_DATESLearner leave of absence dates must be entered for leave code
Learner leave of absence dates must be entered for the leave code.
INVALID_LEVL_CODE_DUALInvalid dual degree level code
Dual degree level code is invalid and must exist in table STVLEVL.
INVALID_MAJR_CODE_DUALInvalid learner dual degree major code
Dual degree major code is invalid and must exist in table STVMAJR.
INVALID_MISSING_DUAL_DEGREEMissing Learner dual degree code
Dual degree code must be entered for dual degree level, college, major and department.
INVALID_ORSN_CODEInvalid learner orientation code
Orientation (ORSN) code is invalid and must exist in table STVORSN.
INVALID_PIDMInvalid learner PIDM
Internal personal indentification number (PIDM) must exist in the common identification table as a person record.
INVALID_PRAC_CODEInvalid learner practical training code
Practical training (PRAC) code is invalid and must exist in table STVPRAC.
INVALID_PREV_CODEInvalid learner progress evaluation
Progress evaluation (PREV) code is invalid and must exist in table STVPREV.
INVALID_PREV_MISSING_CODELearner PREV code must be entered for progress evaluation term code
Both the progress evaluation (PREV) code and the term must be entered; one cannot be blank if the other is entered.
INVALID_PREV_MISSING_TERMLearner PREV Term must be entered for progress evaluation code
Learner progress evaluation (PREV) term must be entered for the progress evaluation code.
INVALID_RATE_CODEInvalid learner rate code
RATE code is invalid and must exist in table STVRATE.
INVALID_RESD_CODEInvalid learner residency code
Resident (RESD) code is invalid and must exist in table STVRESD.
INVALID_SESS_CODEInvalid learner session code
Session (SESS) code is invalid and must exist in table STVSESS.
INVALID_SITE_CODEInvalid learner site code
SITE code is invalid and must exist in table STVSITE.
INVALID_STST_CODEInvalid learner student status code
Student status (STST) code is invalid and must exist in table STVSTST.
INVALID_STYP_CODEInvalid learner student type code
Student type (STYP) code is invalid and must exist in table STVSTYP.
INVALID_TERM_CODE_ASTDInvalid learner academic standing term code
Academic standing (ASTD) term code is invalid and must exist in table STVTERM.
INVALID_TERM_CODE_CASTInvalid learner combined academic standing term code
Combined academic standing (CACT) term code is invalid and must exist in table STVTERM.
INVALID_TERM_CODE_EFFInvalid learner effective term
Effective term code is invalid and must exist in table STVTERM.
INVALID_TERM_CODE_GRADInvalid learner graduation term
Graduation term code is invalid and must exist in table STVTERM.
INVALID_TERM_CODE_PREVInvalid learner progress evaluation term code
Progress evaluation (PREV) term code is invalid and must exist in table STVTERM.
INVALID_TRCN_CODEInvalid learner transfer center code
Transfer center (TRCN) code is invalid and must exist in table STVTRCN.
INVALID_VOED_CODEInvalid learner vocation education status
Vocation education status (VOED) code is invalid and must exist in table STVVOED.
MISSING_PIDMMissing learner PIDM
Internal personal identification number (PIDM) value must be entered.
MISSING_RESD_CODEMissing learner residency code
Resident (RESD) code must be entered.
MISSING_STST_CODEMissing learner student status code
Student status (STST) code must be entered.
MISSING_STYP_CODEMissing learner student type code
Student type (STYP) code must be entered.
MISSING_TERM_CODE_EFFMissing learner effective term
Effective term must be entered.
PK_NOT_FOUNDCannot find learner record using primary or unique key
Learner record does not exist for the internal personal identification number (PIDM)
 and effective term code.
P_DELETE_FAILEDCannot delete learner, record does not exist
Learner record does not exist for the internal personal identification number (PIDM)
 and effective term and cannot be deleted.
RECORD_EXISTSCannot create learner, record already exists
Learner record already exists for the internal personal identification number (PIDM)
 and effective term.


Program units
f_get_error   Returns the error message corresponding to p_errorname.

Variables
error_tab   Error table constant.


error_tab

error_tab gb_common_strings.errmsg_tab_type;

Error table constant.


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.