Package sb_fieldofstudy

Package sb_fieldofstudy_str

This package contains the error messages and error message functions for the Field of Study (sb_fieldofstudy). These are used in the SB_FIELDOFSTUDY API procedures and
SB_FIELDOFSTUDY_RULES validation.

Message Key	Error Message
INVALID_CACT_CODE	Invalid field of study curriculum activity code
Curriculum activity code must exist in table STVCACT.
INVALID_CONC_CODE	Invalid field of study concentration code
Concentration field of study code must exist in table STVMAJR and the STVMAJR_VALID_CONCENTRATN_IND = Y.
INVALID_CSTS_CODE	Invalid field of study curriculum status code
Curriculum status code must exist in table STVCSTS.
INVALID_DATE_RANGE	Invalid field of study date range end date must be greater than start date
Start date must be less than or equal to the end date.
INVALID_DEPT_CODE	Invalid field of study department code
Department code must exist in table STVDEPT.
INVALID_LFST_CODE	Invalid learner field of study type for field of study
Learner field of study code must exist in table GTVLFST.
INVALID_LMOD_RANGE	Invalid number of Field of Study rows for type; cannot exceed SOACTRL count.
Number of current fields of study for the field of study type code may not exceed the count entered on the curriculum control page for the module.
INVALID_MAJR_CODE	Invalid field of study major code
Major field of study must exist in table STVMAJR and the STVMAJR_VALID_MAJOR_IND = Y
INVALID_MAJR_CODE_ATTACH	Invalid field of study attached major code
Major attached to concentration field of study must exist in table STVMAJR and the STVMAJR_VALID_MAJOR_IND = Y
INVALID_MINR_CODE	Invalid field of study minor code
Minor field of study must exist in table STVMAJR and the STVMAJR_VALID_MINOR_IND = Y
INVALID_PIDM	Invalid or missing PIDM for field of study
PIDM value may not be null.
INVALID_ROLLED_SEQNO	Invalid sequence number of rolled field of study
The rolled sequence number may exist only on a field of study for a learner module.
INVALID_LEARNER_ROLLED_SEQNO	Invalid sequence number of rolled field of study
The rolled sequence number must exist for the PIDM on a field of study that is part of an outcome curriculum.
INVALID_TERM_CODE	Invalid field of study term code
Term code must exist in table STVTERM.
INVALID_TERM_CODE_CTLG	Invalid field of study catalog term code
Catalog term code must exist in table STVTERM.
INVALID_TERM_CODE_END	Invalid field of study end term code
End term code must exist in table STVTERM.
INVALID_TERM_RANGE	Invalid field of study term range; end term must be greater than term code
If the end term is not null, it must be greater than the term code value.
INVALID_TMST_CODE	Invalid field of study time status code
Time status code must exist in table STVTMST.
MISSING_CACT_CODE	Missing curriculum activity code for field of study
Curriculum activity code is required and cannot be null.
MISSING_CSTS_CODE	Missing curriculum status for field of study
Curriculum status code is required and cannot be null.
MISSING_DATA_ORIGIN	Missing field of study data origin
Data origin is required and cannot be null.
MISSING_LCUR_SEQNO	Missing curriculum sequence for field of study
Curriculum sequence number is required for creation of a field of study.
MISSING_LFST_CODE	Missing learner field of study type
Learner field of study type code is required and cannot be null.
MISSING_MAJR_CODE	Missing field of study major value
Field of study major value is required.
MISSING_PARENT	Required field of study parent record not found
Field of study requires a curriculum parent record.
MISSING_PIDM	Missing PIDM for field of study
PIDM value is required and cannot be null.
MISSING_PRIORITY_NO	Missing field of study priority number
Priority number is required and cannot be null.
MISSING_SEQNO	Missing field of study sequence
The sequence number is required and cannot be null. This may have resulted from a failure of the function f_seqno to generate a new number.
MISSING_TERM_CODE	Missing term code for field of study
Term code is required and cannot be null.
MISSING_USER_ID	Missing field of study USER
Oracle ID is required and cannot be null.
P_DELETE_FAILED	Cannot delete field of study, record does not exist
Primary key values sent to the procedure p_delete are incorrect, and no field of study with those values exists.
RECORD_EXISTS	Cannot create field of study, record already exists
Primary key values sent to the procedure p_create exists on a record.

Program units

f_get_error	Returns the error message corresponding to p_errorname.
f_major	Returns the MAJOR field of study constant.
f_minor	Returns the MINOR field of study constant.
f_concentration	Returns the CONCENTRATION field of study constant.

Variables

error_tab

Variable for the error.

Constants

MAJOR	Major field of study type constant
MINOR	Minor field of study type constant
CONCENTRATION	Concentration field of study type constant

MAJOR

MAJOR          CONSTANT VARCHAR2(30) := 'MAJOR';

Major field of study type constant

MINOR

MINOR          CONSTANT VARCHAR2(30) := 'MINOR';

Minor field of study type constant

CONCENTRATION

CONCENTRATION  CONSTANT VARCHAR2(30) := 'CONCENTRATION';

Concentration field of study type constant

error_tab

error_tab gb_common.errmsg_tab_type;

Variable for the error.

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.

f_major

FUNCTION f_major RETURN VARCHAR2;

Returns the MAJOR field of study constant.

f_minor

FUNCTION f_minor RETURN VARCHAR2;

Returns the MINOR field of study constant.

f_concentration

FUNCTION f_concentration RETURN VARCHAR2;

Returns the CONCENTRATION field of study constant.