index

Package sb_centricperiod_strings

This package contains the Error messages and error message functions for the CENTRICPERIOD API (sb_centricperiod).

Message NameError Message
INVALID_CODEInvalid student centric period code
Student centric period code must be valid on SOBSCPS.
INVALID_DESCInvalid student centric period description
Student centric period description must be valid on SOBSCPS.
INVALID_SCPC_CODEInvalid student centric period cycle code
Student centric period cycle code must be valid on STVSCPC.
MISSING_CODEStudent centric period code is missing and is required for student centric period
An attempt was made to create or update a student centric period record without a centric period code.
MISSING_DESCStudent centric period description is missing and is required for student centric period
An attempt was made to create or update a student centric period record without a centric period description.
MISSING_USER_IDUser ID is missing and is required for student centric period
An attempt was made to create or update a student centric period record without a user ID.
MISSING_SCPC_CODEStudent centric period cycle code is missing and is required for student centric period
An attempt was made to create or update a student centric period record without a centric period cycle code.
PK_NOT_FOUNDCannot find student centric period record using primary or unique key
Cannot find student centric period record using primary or unique key.
P_DELETE_FAILEDCannot delete student centric period because the record does not exist
Cannot delete student centric period because the record does not exist.
RECORD_EXISTSStudent centric period already exists, student centric period not created
Cannot create student centric period because the record already exists.
TERM_CONTROL_RECORD_EXISTSStudent centric period term control record(s) exist; cannot delete
An attempt to delete a student centric period record was unsuccessful because term control 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.