index

Package tb_memo_str

Error messages and error message functions for MEMO.

Message NameError Message
INVALID_AMOUNTYou may not create a Memo with a zero amount.
An attempt was made to create a new memo using zero as the amount.
INVALID_BILLING_INDInvalid value for billing indicator, must be Y or N.
An attempt was made to create or update a memo billing indicator to a value other than (Y)es or (N)o.
INVALID_EXPIRATION_DATEExpiration Date must be greater than system date.
An attempt was made to create or update a memo with a prior expiration date.
INVALID_SRCE_CODEInvalid value for Source Code.
The source code must be valid in the Billing Detail Source Code Validation table (TTVSRCE).
INVALID_SRCE_ENTRYSource Code other than T may not be entered by operator.
An attempt was made to create a memo with a source code other than T, which is enabled only for system transactions.
INVALID_UPDATE_ZEROMemo has been released; changes not allowed.
An attempt was made to update a memo that already has an amount of zero.
MISSING_AMOUNTMissing mandatory value for amount.
The amount may not be null.
MISSING_BILLING_INDMissing mandatory value for billing indicator.
The billing indicator may not be null.
MISSING_DESCDescription may not be changed to null.
An attempt was made to update the description to null.
MISSING_ENTRY_DATEMissing mandatory value for entry date.
The entry date may not be null.
MISSING_SRCE_CODEMissing mandatory value for source code.
The source code may not be null.
P_DELETE_AUTHYou may not delete system generated memos.
An attempt was made to delete a memo with a source code other than T, which is enabled only for system transactions.
P_UPDATE_AUTHYou may not change system generated memos.
An attempt was made to update a memo with a source code other than T, which is enabled only for system transactions.
INVALID_AIDY_CODEInvalid Aid Year Code.
An attempt was made to create a record with invalid aid year code.
INVALID_PERIOD_CODEInvalid Period Code.
Invalid Financial Aid Enrollment Period code.
AID_YEAR_NULLAid Year Code must be Null.
Aid year must be  null when Term Code is ARTERM (non-student transactions).
PERIOD_CODE_NULLPeriod Code must be Null.
Enroll Period must be  null when Term Code is ARTERM (non-student transactions).

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.