index

Package tb_term_control_ar_str

Error messages and error message functions for TB_TERM_CONTROL_AR.

Note that in addition to the messages below, errors may be raised from -
     TB_COMMON regarding common data

Message NameError Message
INVALID_ACCD_DUE_CDEInvalid value for Show Account Detail Totals, must be A or B.
An attempt was made to create or update Show Account Detail Totals to a value other than (A)ccount Balance only or (B)oth Balance and Current Due.
INVALID_AID_AUTH_DISP_INDInvalid value for Authorized Aid Indicator, must be Y or N.
An attempt was made to create or update the Authorized Aid indicator to a value other than Y or N.
INVALID_AID_CALC_INDInvalid value for TBBTERM_AID_CALC_IND (reserved for future use), must be Y or N.
Set TBBTERM_AID_CALC_IND (which is reserved for future use) to N when creating or updating a record.
INVALID_AID_MEMO_DISP_INDInvalid value for Aid Memos Indicator, must be Y or N.
An attempt was made to create or update the Aid Memos indicator to a value other than Y or N.
INVALID_AUTH_DISP_TOTShow Authorized Aid Totals must be (N)o when there is no display of Authorized Aid.
An attempt was made to create or update a record enabling Authorized Aid Totals, when the display of Authorized Aid is not enabled.
INVALID_AUTH_DUE_CDEInvalid value for Show Authorized Aid Totals, must be N, A, or B.
An attempt was made to create or update Show Authorized Aid Totals to a value other than (N)o calculated amounts, (A)djusted Balance only, or (B)oth Adjusted Balance and Current Due.
INVALID_DETAIL_WEB_DISP_INDInvalid value for Enable Account Detail by Term, must be Y or N.
An attempt was made to create or update the Enable Account Detail by Term indicator to a value other than Y or N.
INVALID_MEMO_DISP_TOTShow Memo Totals must be (N)o when there is no display of Memos.
An attempt was made to create or update a record enabling Memo Totals, when the display of Memos is not enabled.
INVALID_MEMO_DUE_CDEInvalid value for Show Memo Totals, must be N, A, or B.
An attempt was made to create or update Show Memo Totals to a value other than (N)o calculated amounts, (A)djusted Balance only, or (B)oth Adjusted Balance and Current Due.
INVALID_OTH_MEMO_DISP_INDInvalid value for Other Memos Indicator, must be Y or N.
An attempt was made to create or update the Other Memos indicator to a value other than Y or N.
INVALID_PAY_BTN_INDInvalid value for Enable Pay Now Buttons Indicator, must be Y or N.
An attempt was made to create or update the Enable Pay Now Buttons indicator to a value other than Y or N.
INVALID_SUM_DETC_INDInvalid value for Sum by Detail Code, must be Y or N.
An attempt was made to create or update the Sum by Detail Code indicator to a value other than Y or N.
INVALID_TERM_CODEInvalid value for Term Code.
The term code provided does not exist in the Term Code Validation table STVTERM.
MISSING_ACCD_DUE_CDEMissing mandatory value for Show Account Detail Totals.
Show Account Detail Totals may not be null.
MISSING_AID_AUTH_DISP_INDMissing mandatory value for Authorized Aid Indicator.
The Authorized Aid Indicator may not be null.
MISSING_AID_CALC_INDMissing mandatory value for TBBTERM_AID_CALC_IND (reserved for future use).
TBBTERM_AID_CALC_IND may not be null.
MISSING_AID_MEMO_DISP_INDMissing mandatory value for Aid Memos Indicator.
The Aid Memos Indicator may not be null.
MISSING_AUTH_DUE_CDEMissing mandatory value for Show Authorized Aid Totals.
Show Authorized Aid Totals may not be null.
MISSING_DETAIL_WEB_DISP_INDMissing mandatory value for Enable Account Detail by Term.
The Enable Account Detail by Term Indicator may not be null.
MISSING_MEMO_DUE_CDEMissing mandatory value for Show Memo Totals.
Show Memo Totals may not be null.
MISSING_OTH_MEMO_DISP_INDMissing mandatory value for Other Memos Indicator.
The Other Memos Indicator may not be null.
MISSING_PAY_BTN_INDMissing mandatory value for Enable Pay Now Buttons Indicator.
The Enable Pay Now Buttons indicator may not be null.
MISSING_SUM_DETC_INDMissing mandatory value for Sum by Detail Code.
The Sum by Detail Code Indicator may not be null.
MISSING_USER_IDMissing mandatory value for User ID.
User ID may not be null.
RECORD_EXISTSCannot create, record already exists.
An attempt was made to create a record with a Term Code that already exists in the table.

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.