index

Package sb_enroll_ver_service_strings

This package contains the error messages and error message functions for the Enrollment Verification Self-Service Options API (sb_enroll_ver_service).

Message NameError Message
INVALID_ACCT_TYPE_CDEInvalid acount type code code for acounts receivable
The acounts receivable type code entered was not one of the student's accounts (S) or an authorized miscellaneous (M).
INVALID_CHARGEInvalid service charge
The charge entered is not a valid self-service charge for C (copy) or R (request).
INVALID_CHARGE_PER_CDEInvalid charge for the service
The charge associated with the self-service code entered C (copy) or R (request) is invalid.
INVALID_EPRT_CODEInvalid value for the enrollment verification type code
The enrollment verification type code does not exist in the STVEPRT table.
INVALID_WSSO_CODEInvalid code for the self-service requests
The service option code that was entered for the self-service request does not exist in the STVWSSO table.
MISSING_ACCT_TYPE_CDEMissing mandatory value for accounts receivable
The acounts receivable type code to be created, one of the student's accounts (C) or a miscellaneous one (M), was not entered.
MISSING_EPRT_CODEMissing mandatory value for the enrollment verification request
The enrollment verification request type code was not entered.
MISSING_PARENTMissing required parent record
Required parent record not found.
MISSING_WSSO_CODEMissing self-service requests code
Must enter the service option code for the self-service request.
PK_NOT_FOUNDCannot find record using primary or unique key
Cannot find the desired record with the enrollment verification request code and/or service option code that was entered in the SFRENSS table.
P_DELETE_FAILEDCannot delete record
Record to be deleted does not exist in the SFRENSS table.
RECORD_EXISTSCannot create record
The record for enrollment verification request code and service option code already exists in the SFRENSS table.
MISSING_USER_IDMissing mandatory value for the user ID
The user ID to create or update the record was not entered.
MISSING_DATA_ORIGINMissing mandatory value for the data origin
The value for the origin of the data was not entered.


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.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.err_type

Returns the error message corresponding to p_errorname.

Parameters
p_errorname   Name associated with the error message.