index

Package ab_proposal_history_strings

This package contains the error messages and error message functions for the Proposal History API (ab_proposal_history).

Message NameError Message
INVALID_ASK_AMOUNTAsk Amount is not valid. It must be between 0 and 99999999999.99
The Ask Amount must be between 0 and 99999999999.99.
INVALID_ASK_AMOUNT_CHG_INDAsk Amount Change Indicator is not valid.
Ask Amount Change Indicator must be a Y or N.
INVALID_COMMENT_CHG_INDComment Change Indicator is not valid.
Comment Change Indicator must be a Y or N.
INVALID_DUE_DATEProposal Due Date is not valid.
The Proposal Due Date is not a valid date.
INVALID_DUE_DATE_CHG_INDProposal Due Date Change Indicator is not valid.
Proposal Due Date Change Indicator must be a Y or N.
INVALID_FINANCE_CODEFinance Code is not valid.
Finance Code is not valid.
INVALID_FINANCE_CODE_CHG_INDFinance Code Change Indicator is not valid.
Finance Code Change Indicator must be a Y or N.
INVALID_PIDMInternal ID is not valid.
The Internal ID does not exist in the database.
INVALID_PROPOSALProposal Code is not valid for the Internal ID.
The Internal ID does not have this Proposal Code on any records.
INVALID_PROP_CODEProposal Code is not valid.
The Proposal Code does not exist in the database.
INVALID_PRST_CODEProposal Status Code is not valid.
The Proposal Status Code does not exist in the database.
INVALID_PRST_CODE_CHG_INDProposal Status Code Change Indicator is not valid.
Proposal Status Code Change Indicator must be Y or N.
INVALID_PRST_DATEProposal Status Date is not valid.
The Proposal Status Date is not a valid date.
INVALID_PRST_DATE_CHG_INDProposal Status Date Change Indicator is not valid.
Proposal Status Date Change Indicator must be Y or N.
INVALID_SEQ_NOProposal History Sequence Number is not valid. It must be between 0 and 999
The Proposal History Sequence Number must be between 0 and 999.
INVALID_STAFF_IDEN_CHG_INDStaff Identification Change Indicator is not valid.
Staff Identification Change Indicator must be Y or N.
INVALID_STAFF_IDEN_CODEStaff Identification is not valid.
The Staff Identification value does not exist in the database.
INVALID_STAFF_PIDMStaff Internal ID is not valid.
The Internal ID for the Staff Member does not exist in the database.
INVALID_STAFF_PIDM_CHG_INDStaff Internal ID Change Indicator is not valid.
Staff Internal ID Change Indicator must be Y or N.
MISSING_DATA_ORIGINData Origin is missing.
The source of the data being supplied must be given.
MISSING_PIDMInternal ID is missing.
An Internal ID must be supplied.
MISSING_PROP_CODEProposal Code is missing.
A Proposal Code must be supplied.
MISSING_SEQ_NOProposal History Sequence Number is missing.
A Proposal History Sequence Number must be supplied.
MISSING_USER_IDUser ID is missing.
A User ID must be supplied for the person making the change.
PK_NOT_FOUNDCannot find record using primary or unique key for the Proposal History API.
A record could not be found for the supplied primary key information.
P_DELETE_FAILEDCannot delete the Proposal History record (ab_proposal_history) because the record does not exist.
A record could not be found for the supplied primary key information.
RECORD_EXISTSProposal History API cannot create Proposal History (ab_proposal_history) because the record already exists.
The record cannot be created because another record already exists with the same primary key.
SEQ_NO_IN_USEProposal History Sequence Number already used for the Proposal
The Proposal History Sequence Number has already been used on another record for this person.


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.