Package tb_deposit

Package tb_deposit_str

Error messages and error message functions for DEPOSIT.
References to System Transactions refer to the creation of transactions such as Tuition and Fee Assessment, Financial Aid disbursement, Contract and Exemption credits, etc. which are generated based on rules in other tables.
Note that in addition to the messages below, errors may be raised from -
      GB_CURRENCY_RATE regarding currency conversion
      TB_CASHIER_SESSION regarding cashier session
      TB_COMMON regarding address and other common data
      TB_DETAIL_CODE regarding detail codes
      TB_DEPO_CONTROL regarding deposit detail control information

Message Key	Error Message
INVALID_AMOUNT_MIN	Deposit amount must be greater than or equal to the minimum amount.
An attempt was made to create a new deposit or change the Minimum of an existing deposit with an Amount that is not greater than or equal to the Minimum.
INVALID_AUTO_RELEASE_IND	Invalid value for Auto Release indicator, must be Y or N for student transaction and N for non-student transaction.
An attempt was made to create or update a deposit with an Auto Release indicator other than N for a non-student transaction and other than Y or N for a student transaction.
INVALID_DETAIL_CODE_DEPOSIT	Invalid value for Deposit Detail Code.
An attempt was made to create a deposit with a Deposit Detail Code that is not in the Detail Charge/Payment Code Definition table (TBBDETC) or the Deposit Detail Definition table (TBBDEPC).
INVALID_DETAIL_CODE_PAYMENT	Invalid value for Detail Code Payment.
An attempt was made to create a deposit with a Payment Code that is not in the Detail Charge/Payment Code Definition table (TBBDETC).
INVALID_EFF_DATE_CHNG	Effective Date may not be changed when the feed indicator is equal to F.
An attempt was made to update an Effective Date after the transaction was fed to the finance ledgers.
INVALID_EFF_SYSDATE	The Effective Date must be greater than or equal to today's date.
An attempt was made to create or update a deposit with an Effective Date prior to today's date.
INVALID_EXP_REL_DATE	Expiration Date must be greater than or equal to Release Date.
An attempt was made to create or update a deposit with an Expiration Date prior to the Release Date.
INVALID_EXP_SYSDATE	Expiration Date must be greater than or equal to today's date.
An attempt was made to create or update a deposit with an Expiration Date prior to today's date.
INVALID_REL_SYSDATE	Release Date must be greater than or equal to today's date.
An attempt was made to create or update a deposit with a Release Date prior to today's date.
INVALID_RELEASE_MODE	Invalid value for p_release_mode parameter, must be A or M.
An attempt was made to release a deposit with a mode other than A (Automatic) or M (Manual).
MISSING_AMOUNT	Missing mandatory value for deposit Amount.
The Amount may not be null. It must be specified unless calculated from a valid Currency Code and Foreign Amount.
MISSING_AUTO_RELEASE_IND	Missing mandatory value for Auto Release indicator.
Mandatory value for Auto Release indicator is missing.
MISSING_DESC	Missing mandatory value for Detail Code Deposit Description.
Mandatory value for Detail Code Deposit Description is missing.
MISSING_DETAIL_CODE_DEPOSIT	Missing mandatory value for Deposit Detail Code.
Mandatory value for Deposit Detail Code is missing.
MISSING_DETAIL_CODE_PAYMENT	Missing mandatory value for Detail Code Payment.
Mandatory value for Payment Detail Code is missing.
RELEASE_AMOUNT_ERR	Deposit amount to be released must be less than or equal to balance.
An attempt was made to release a deposit specifying an amount which is greater than the remaining Balance of the deposit.
RELEASE_DATE_ERR	Deposit amount may not be released until release date.
An attempt was made to release a deposit prior to the Release Date.
RELEASE_MIN_AMOUNT_ERR	Deposit balance may not fall below minimum until expiration date.
An attempt was made to release a deposit specifying an amount that makes the deposit Balance fall below the Minimum before the Expiration Date.
XNOR_MINAMT_EXPDATE	Minimum Amount and Expiration Date must both be populated or both be null.
An attempt was made to create or update a deposit with the Minimum Amount or the Expiration Date without the second value for the pair.

Program units

f_get_error

Returns error message corresponding to p_errorname

Variables

error_tab

Error table

error_tab

error_tab gb_common_strings.errmsg_tab_type;

Error table

f_get_error

Function f_get_error(p_errorname VARCHAR2) RETURN VARCHAR2

Returns error message corresponding to p_errorname

Parameters

p_errorname

Name associated with error message.