index

Package ab_atvdcpr_strings

This package contains the error messages and error message functions for the Gift Society Premiums Validation Table.

Message NameError Message
INVALID_CODEBenefit/Premium Code is not valid.
The Benefit/Premium Code does not exist in Banner.
INVALID_COSTBenefit/Premium Cost is not valid.
The Benefit/Premium Cost  must be between 0 and 999999999.99.
INVALID_VALUEBenefit/Premium Value is not valid.
The Benefit/Premium Value must be between 0 and 999999999.99.
MISSING_CODEBenefit/Premium Code is missing.
The Benefit/Premium Code is required.
MISSING_DESCBenefit/Premium Description is missing.
Benefit/Premium Description is required.
PK_NOT_FOUNDCannot find record using primary or unique key for the ab_atvdcpr API.
The Benefit/Premium record cannot be found.
P_DELETE_FAILEDCannot delete ATVDCPR(ab_atvdcpr) because the record does not exist.
The Benefit/Premium record cannot be deleted because it does not exist.
RECORD_EXISTSab_atvdcpr API cannot create ATVDCPR(ab_atvdcpr) because the record already exists.
The Benefit/Premium cannot be created because it already exists.

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.