index

Package sb_enroll_ver_payment_strings

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

Message NameError Message
INVALID_DETC_CODEInvalid detail code
The accounts receivable detail code for the self-service charge is invalid.
INVALID_EPRT_CODEInvalid enrollment verification request type code
The enrollment verification request type code does not exist in the STVEPRT table.
INVALID_WPYO_CODEInvalid self-service payment code
The payment option code associated with the self-service product does not exist in the STVWPYO table.
MISSING_EPRT_CODEMissing mandatory value for the enrollment verification request type code
No value was entered for the required enrollment verification request type code.
MISSING_WPYO_CODEMissing mandatory value for the payment option
No value was entered for the required payment option code associated with the self-service product.
PK_NOT_FOUNDCannot find the record using primary or unique key
Cannot find the desired record with the specified enrollment verification type code and payment option code in the SFRENPO table.
P_DELETE_FAILEDCannot delete record
The record to be deleted using the enrollment verification type code and payment option code does not exist in the SFRENPO table.
RECORD_EXISTSCannot create record
Record for enrollment verification type code and payment option code already exists in the SFRENPO table.
MISSING_PARENTMissing required parent record
Required parent record not found.
MISSING_DATA_ORIGINMissing mandatory value for the data origin
The value for the origin of the data must be entered.
MISSING_USER_IDMissing mandatory value for the user ID
The user ID to create or update the record must be 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.