index

Package sb_centricperiod_term_strings

This package contains the Error messages and error message functions for the CENTRICPERIOD_TERM API (sb_centricperiod_term).

Message NameError Message
INVALID_SCPS_CODEInvalid student centric period code
Student centric period code must be valid on SOBSCPS.
INVALID_TERM_CODEInvalid student centric period term code
Student centric period term code must be valid on STVTERM.
INVALID_TERM_CONTROL_INDInvalid student centric period term control indicator
Student centric period term control indicator must be Y or null.
MISSING_SCPS_CODEStudent centric period code is missing and is required for student centric period term
An attempt was made to create or update a student centric period term record without a centric period code.
MISSING_TERM_CODEStudent centric period term code is missing and is required for student centric period term
An attempt was made to create or update a student centric period term record without a centric period term code.
MISSING_USER_IDUser ID is missing and is required for student centric period term
An attempt was made to create or update a student centric period term record without a user ID.
PK_NOT_FOUNDCannot find student centric period record term using primary or unique key
Cannot find student centric period term record using primary or unique key.
P_DELETE_FAILEDCannot delete student centric period term because the record does not exist
Cannot delete student centric period term because the record does not exist.
RECORD_EXISTSStudent centric period term already exists, student centric period term not created
Cannot create student centric period term because the record already exists.
TERM_CONTROL_IND_EXISTSStudent centric period term control already exists.
Cannot create student centric period term control because term control record already exists.
CANNOT_DELETE_LAST_RECORDCannot delete last student centric period term record.
Cannot delete last student centric period term record.
CANNOT_DELETE_START_TERMCannot delete student centric period start term record; remaining term record conflicts with another start term.
Cannot delete student centric period start term record; remaining term record conflicts with another start term.
MIN_SCP_TERM_EXISTSStudent centric period earliest term already exists as the earliest term for another centric period.
Student centric period earliest term already exists as the earliest term for another centric period.
TERM_HEADER_RECORD_EXISTSStudent centric period term header record(s) exist; cannot delete
An attempt to delete a student centric period record was unsuccessful because term header records exist.
CENTRIC_ASSR_RECORD_EXISTSStudent centric period academic status record(s) exist; cannot delete
An attempt to delete a student centric period record was unsuccessful because centric academic status records exist.
CENTRIC_CSCP_RECORD_EXISTSStudent centric period continuant record(s) exist; cannot delete
An attempt to delete a student centric period record was unsuccessful because centric continuant records exist.
CENTRIC_GPA_RECORD_EXISTSStudent centric period gpa record(s) exist; cannot delete
An attempt to delete a student centric period record was unsuccessful because centric gpa records exist.
CENTRIC_STDN_RECORD_EXISTSStudent centric period general learner record(s) exist; cannot delete
An attempt to delete a student centric period record was unsuccessful because centric general learner records exist.
CENTRIC_STSH_RECORD_EXISTSStudent centric period time status history record(s) exist; cannot delete
An attempt to delete a student centric period record was unsuccessful because centric time status history records exist.
CENTRIC_STSL_RECORD_EXISTSStudent centric period time status level record(s) exist; cannot delete
An attempt to delete a student centric period record was unsuccessful because centric time status level records exist.
CENTRIC_STST_RECORD_EXISTSStudent centric period time status record(s) exist; cannot delete
An attempt to delete a student centric period record was unsuccessful because centric time status records exist.


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.