Package sb_curric_status_event

Package sb_curric_status_event_strings

This package contains the error messages and error message functions for the Curriculum Status Event API (sb_curric_status_event).

Message Name	Error Message
INVALID_CSTS_CODE	Invalid curriculum status for the curriculum status event.
>An attempt was made to create or update the curriculum status code with an invalid value. The code must exist as a valid code on the curriculum status validation table (STVCSTS).
INVALID_CSTS_CODE_TRN	Invalid curriculum status translation for the curriculum status event.
An attempt was made to create or update the curriculum status translation code with an invalid value. The code must exist as a valid code on the curriculum status validation table (STVCSTS).
INVALID_DATA_ORIGIN	Invalid data origin for the curriculum status event.
An attempt was made to create or update the data origin for a curriculum status to an invalid value.
INVALID_SYS_REQ_IND	Invalid system required indicator for the curriculum status event.
An attempt was made to create or update the system required indicator for a curriculum status with a value other than 'Y' or 'N'.
INVALID_USER_ID	Invalid user ID for the curriculum status event.
An attempt was made to create or update the data origin for a curriculum status to an invalid value.
MISSING_CSTS_CODE	Missing curriculum status code.
The curriculum status code is missing and is required.
MISSING_CSTS_CODE_TRN	Missing curriculum status translation code.</TD<>/TR>
The curriculum status translation code is missing and is required.
MISSING_DATA_ORIGIN	Missing data origin for the curriculum status event.
The curriculum status data origin is missing and must be designated with a valid value.
MISSING_SYS_REQ_IND	Missing system required indicator for the curriculum status event.
The curriculum status system required indicator is missing and must be designated with a 'Y'(Yes) or 'N'(No).
MISSING_USER_ID	Missing user ID for the curriculum status event.
The curriculum status user ID is missing and must be designated with a valid value.
PK_NOT_FOUND	Cannot find the curriculum status event record using the primary or unique key.
An attempt to update or delete a curriculum status was unsuccessful because the record could not be found using the primary key of curriculum status code.
P_DELETE_FAILED	Cannot delete the curriculum status event because the record does not exist.
An attempt to delete a curriculum status was unsuccessful because the record could not be found.
RECORD_EXISTS	Cannot create curriculum status event because the record already exists.</TD<>/TR>
An attempt to create a curriculum status was unsuccessful because the record already exists; duplicates are not allowed.

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.