index

Package tb_common_str

Error messages and error message functions for TB_COMMON.

These errors may be raised from -
      TB_RECEIVABLE
      TB_DEPOSIT
      TB_MISC_DETAIL

Message KeyError Message
HAS_AR_HOLDAccounts Receivable hold exists, you may not process this transaction.
An attempt was made to create a record on an Entity with a hold that prevents Accounts Receivable transactions.  If authorized, pass Y to the hold override parameter.
INVALID_ACCT_FEED_AUTHYou are not authorized to change the Accounting Feed Indicator to F.
An attempt was made to update the Accounting Feed Indicator to F.  This change is enabled for the Feed process only.
INVALID_ACCT_FEED_CHANGEMay not change Feed Indicator after set to F.
An attempt was made to update the Accounting Feed Indicator from F to another value.  Once a transaction has been fed to the Finance ledgers, the Accounting Feed Indicator may not be changed.
INVALID_ACCT_FEED_CREATEYou are not authorized to create transactions with Accounting Feed Indicator F.
An attempt was made to create a new record with the Accounting Feed Indicator set to F.  For inserts, this value is reserved for Purge processing.
INVALID_ACCT_FEED_INDInvalid value for Accounting Feed Indicator, must be Y or F.
An attempt was made to update the Accounting Feed Indicator with a value other than Y or F.
INVALID_ACCT_FEED_IND_NInvalid value for Accounting Feed Indicator, must be Y, N, or F.
An attempt was made to update the Accounting Feed Indicator with a value other than Y, N, or F.
INVALID_ACCT_FEED_REQFeed Document and Date are required when Accounting Feed Indicator is changed to F.
An attempt was made to update the Accounting Feed Indicator to F without providing required values for Feed Document Code and Feed Date.
INVALID_ATYP_CODE_SEQNOAddress Type and Sequence may not be entered on student transactions.
An attempt was made to create or update a student transaction (has a valid Term Code) with Address Type or Sequence.  Address information may not be used with student transactions.
INVALID_FEED_CHANGEFeed Document Code and Date may only be changed when setting Accounting Feed Indicator to F.
An invalid attempt was made to change the Feed Document Code or Feed Date.  These values may only be changed at the same time that the Accounting Feed Indicator is changed to F.
INVALID_ID_SSNUnable to find identification record given ID or SSN.
Unable to find identification record given ID or SSN.
INVALID_PIDMInvalid value for PIDM.
The PIDM provided does not exist in the Identification table SPRIDEN.
INVALID_TERM_CODEInvalid value for Term Code.
The term code provided is not ARTERM (for non-student transactions) and does not exist in the Term Code Validation table STVTERM (for student transactions).
MISSING_ACCT_FEED_INDMissing mandatory value for Accounting Feed Indicator.
The Accounting Feed Indicator may not be null.
MISSING_ATYP_CODE_SEQNOAddress Type and Sequence Number are both required for non-student transactions.
An attempt was made to create a non-student record (with a term Code of ARTERM) without values for both Address Type and Sequence Number, and no default was found in the Customer Profile.  Or, an attempt was made to update the address of an existing non-student record without providing both Address Code and Sequence.
MISSING_EFFECTIVE_DATEMissing mandatory value for Effective Date.
The Effective Date may not be null.
MISSING_ENTRY_DATEMissing mandatory value for Entry Date.
The Entry Date may not be null.
MISSING_PIDMMissing mandatory value for PIDM.
The PIDM may not be null.
MISSING_RECEIPTMissing mandatory value for Receipt Number.
The Receipt Number may not be null.
MISSING_TERM_CODEMissing mandatory value for Term Code.
The Term Code may not be null.
MISSING_TRAN_NUMBERMissing mandatory value for Transaction Number.
Attempt to create was not able to generate a valid Transaction Number.
MISSING_USERMissing mandatory value for User.
User may not be null.
MULTI_SSNMultiple students found using SSN provided.
Multiple students found using SSN provided.
PK_NOT_FOUNDCannot find record using primary or unique key.
The key values passed in the update failed to locate a record in the table.
PROFILE_AMOUNT_CHARGEUser does not have permission to enter charges for detail codes of this category.
An attempt was made to create a Receivable payment reversal or charge using a detail code in a category authorized only for payments for a restricted Cashier (TBBUPRF, TBRUPRF).
PROFILE_AMOUNT_CREDITUser does not have permission to enter credits for detail codes of this category.
An attempt was made to create the Credit side of a Miscellaneous Transaction using a detail code in a category authorized only for payments for a restricted Cashier (TBBUPRF, TBRUPRF).
PROFILE_AMOUNT_DEBITUser does not have permission to enter debits for detail codes of this category.
An attempt was made to create the Debit side of a Miscellaneous Transaction using a detail code in a category authorized only for charges for a restricted Cashier (TBBUPRF, TBRUPRF).
PROFILE_AMOUNT_PAYMENTUser does not have permission to enter payments for detail codes of this category.
An attempt was made to create a Deposit, Receivable charge reversal or payment using a detail code in a category authorized only for charges for a restricted Cashier (TBBUPRF, TBRUPRF).
PROFILE_DCAT_NOT_FOUNDUser does not have permission to enter detail codes of this category.
An attempt was made to create a transaction using a detail code that is not included in those category codes authorized for a restricted Cashier (TBBUPRF, TBRUPRF).
P_DELETE_AUTHORIZEDYou are not authorized to delete record.
Delete is enabled for Purge processing only.
P_DELETE_FAILEDCannot delete, record does not exist.
The key values passed in the delete failed to locate a record in the table.


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.