index

Package sb_studypath_enrollment_str

This package contains the error messages and error message functions for Study Path Enrollment API (sb_studypath_enrollment).

Message NameError Message
INVALID_ESTS_CODEEnrollment status code is invalid for study path enrollment
Study path enrollment status code must be valid on STVESTS.
INVALID_PIDMPIDM is invalid for study path enrollment
PIDM for the study path enrollment must be one that exists.
INVALID_TERM_CODETerm code is invalid for study path enrollment
Study path enrollment term must be valid on STVTERM.
MISSING_ADD_DATEEnrollment add date is missing and is required for study path enrollment
An attempt was made to create or update a study path enrollment record without an add date.
MISSING_DATA_ORIGINData source is missing and is required for study path enrollment
An attempt was made to create or update a study path enrollment record without a data source.
MISSING_ESTS_CODEEnrollment status is missing and is required for study path enrollment
An attempt was made to create or update a study path enrollment record without an enrollment status.
MISSING_ESTS_DATEEnrollment status date is missing and is required for study path enrollment
An attempt was made to create or update a study path enrollment record without an enrollment status date.
MISSING_KEY_SEQNOKey sequence number is missing and is required for study path enrollment
An attempt was made to create or update a study path enrollment record without a key sequence number.
MISSING_PIDMPIDM is missing and is required for study path enrollment
An attempt was made to create or update a study path enrollment record without a PIDM.
MISSING_TERM_CODETerm code is missing and is required for study path enrollment
An attempt was made to create or update a study path enrollment record without a term code.
MISSING_USERUser ID is missing and is required for study path enrollment
An attempt was made to create or update a study path enrollment record without a user ID.
PK_NOT_FOUNDCannot find study path enrollment record using primary or unique key
Cannot find study path enrollment record using primary or unique key.
P_DELETE_FAILEDCannot delete study path enrollment because the record does not exist
Cannot delete study path enrollment because the record does not exist.
RECORD_EXISTSCannot create study path enrollment record because it already exists
Cannot create study path enrollment because the record already exists.
NO_ENROLLMENTCannot create study path enrollment because base enrollment record does not exist
Cannot create study path enrollment because the base enrollment record does not exist in SFBETRM.


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.