index

Package ab_gift_auxl_hold_strings

This package contains the error messages and error message functions for the Gift Auxiliary Hold API (ab_gift_auxl_hold).

Message NameError Message
INVALID_ACC_REJ_INDBenefit or Premium Reject or Accept Indicator for the Gift Auxiliary Hold API is not valid.
The Benefit or Premium Reject or Accept Indicator must be A, R or Null.
INVALID_AUXL_CODEAuxiliary Code for the Gift Auxiliary Hold API is not valid.
The Auxiliary Code does not exist on the Auxiliary Code Validation Table (ATVAUXL).
INVALID_DCPR_CODEBenefit or Premium code for the Gift Auxiliary Hold API is not valid.
The Benefit or Premium code does not exist on the Benefit/Premiums Validation Table (ATVDCPR).
INVALID_DCPR_COSTActual Value for the Gift Auxiliary Hold API is not valid.
The Actual Value is not numeric or is outside the range of 0 to 999999999.99.
INVALID_DCPR_VALUEBenefit or Premium Value for the Gift Auxiliary Hold API is not valid.
Then Benefit or Premium Value is not numeric or is outside the range of 0 to 999999999.99.
INVALID_DEDUCT_FOR_TAXESBenefit or Premium Deduct for Taxes indicator for the Gift Auxiliary Hold API is not valid.
The Benefit or Premium Deduct for Taxes indicator must be Y or Null.
INVALID_DONR_CODEDonor Code for the Gift Auxiliary Hold API is not valid.
The Donor Code does not exist for the Donor.
INVALID_GIFT_NOGift Number for the Gift Auxiliary Hold API is not valid.
The Gift Number does not exist.
INVALID_IDNo pending gifts for the ID Number.
The ID Number does not exist.
INVALID_ID_GIFTGift Number invalid for the ID Number.
The Gift Number does not exist for the ID Number.
INVALID_ID_PIDMNo pending gifts for the ID and Internal ID combination.
The combination of ID and Internal ID has no pending gifts.
INVALID_ID_PIDM_GIFTGift Number invalid for the ID and Internal ID combination.
The pending Gift Number does not exist for the combination of ID and Internal ID.
INVALID_ISSUE_DATEBenefit or Premium Issue Date for the Gift Auxiliary Hold API is not valid.
The Benefit or Premium Issue Date is not a valid date.
INVALID_PIDMNo pending gifts for the Internal ID.
There are no pending gifts for the Internal ID.
INVALID_PIDM_GIFTGift Number invalid for the Internal ID.
The Gift Number does not exist for the Internal ID.
INVALID_PREF_CLASPreferred Class for the Gift Auxiliary Hold API is not valid.
The Preferred Class is not the Preferred Class for the Advancement Individual
MISSING_AUXL_CODEAuxiliary Code is missing. This field is required by the Gift Auxiliary Hold API.
The Auxiliary Code was not supplied and must be a valid value from the Auxiliary Code Validation Table (ATVAUXL).
MISSING_AUXL_DESCAuxiliary Code Description is missing. This field is required by the Gift Auxiliary Hold API.
The Auxiliary Code Description was not supplied.
MISSING_AUXL_VALUE_DATEAuxiliary Value Date is missing. This field is required by the Gift Auxiliary Hold API.
The Auxiliary Value Date was not supplied.
MISSING_DATA_ORIGINData Origin is missing. This field is required by the Gift Auxiliary Hold API.
The Data Origin was not supplied.
MISSING_DCPR_COSTActual Value is missing. This field is required by the Gift Auxiliary Hold API.
The Actual Value was not supplied and must be in the range of 0 to 999999999.99.
MISSING_GIFT_NOGift Number is missing. This field is required by the Gift Auxiliary Hold API.
A Gift Number was not supplied.
MISSING_IDID Number is missing. This field is required by the Gift Auxiliary Hold API.
An ID Number was not supplied.
MISSING_USER_IDUser ID is missing. This field is required by the Gift Auxiliary Hold API.
The User ID was not supplied.
PK_NOT_FOUNDCannot find record using primary or unique key for the Gift Auxiliary Hold API.
The record could not be found using the Primary Key.
P_DELETE_FAILEDCannot delete Gift Auxiliary Hold (ab_gift_auxl_hold) because the record does not exist.
The record to be deleted does not exist based on the key information supplied.


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.