index

Package ab_project_history_strings

This package contains the error messages and error message functions for the Project History API (ab_project_history).


Message NameError Message
INVALID_GIVH_CODEGiving Vehicle Code is not valid.
The Giving Vehicle Code does not exist in the database.
INVALID_GIVH_CODE_CHG_INDGiving Vehicle Code Change Indicator is not valid.
The Giving Vehicle Code Change Indicator must be Y or N.
INVALID_PIDMInternal ID not valid.
The Internal ID does not exist in Banner.
INVALID_PROJ_CODEProject Code is not valid.
The Project Code does not exist in the database.
INVALID_PROJ_EFF_FROM_DATEProject Effective From Date is not valid.
The Project Effective From Date is not a valid date.
INVALID_PROJ_EFF_TO_DATEProject Effective To Date is not valid.
The Project Effective To Date is not a valid date.
INVALID_PROJ_FROM_DATE_CHG_INDProject Effective From Date Change Indicator is not valid.
The Project Effective From Date Change Indicator must be Y or N.
INVALID_PROJ_TEXT_CHG_INDProject Text Change Indicator is not valid.
The Project Text Change Indicator must be Y or N.
INVALID_PROJ_TO_DATE_CHG_INDProject Effective To Date Change Indicator is not valid.
The Project Effective To Date Change Indicator must be Y or N.
INVALID_PROPOSALProject Code is not valid for the Internal ID.
The Project Code is not assigned to the constituent.
INVALID_PROP_CODEProposal Code is not valid.
The Proposal Code does not exist in the database.
INVALID_PROP_SEQ_NOProposal Code Sequence Number is not valid.
The Proposal Code Sequence Number does not exist in the database.
INVALID_PRST_CODEProject Status Code is not valid.
The Project Status Code does not exist in the database.
INVALID_PRST_CODE_CHG_INDProject Status Code Change Indicator is not valid.
The Project Status Code Change Indicator must be Y or N.
INVALID_PRST_DATEProject Status Date is not valid.
The Project Status Date is not a valid date.
INVALID_PRST_DATE_CHG_INDProject Status Date Change Indicator is not valid.
The Project Status Date Change Indicator must be Y or N.
INVALID_SEQ_NOProject History Sequence Number is not valid. It must be between 0 and 999
The Project History Sequence Number must be between 0 and 999.
INVALID_TARGET_ASK_AMOUNTTarget Ask Amount is not valid. It must be between 0 and 999999999.99
The Target Ask Amount  must be between 0 and 999999999.99.
INVALID_TARGET_ASK_AMT_CHG_INDTarget Ask Amount Change Indicator is not valid.
The Target Ask Amount Change Indicator must be Y or N.
INVALID_TARGET_ASK_DATETarget Ask Date is not valid.
The Target Ask Date is not a valid date.
INVALID_TARGET_ASK_DTE_CHG_INDTarget Ask Date Change Indicator is not valid.
The Target Ask Date Change Indicator must be Y or N.
MISSING_DATA_ORIGINData Origin is missing.
The origin of the data being supplied must be entered.
MISSING_PARENTRequired Project (AMRPROP) record not found.
No Project record found to match this history change.
MISSING_PIDMInternal ID is missing.
An Internal ID must be supplied.
MISSING_PROJ_CODEProject Code is missing.
A Project Code must be supplied.
MISSING_PROP_CODEProposal Code is missing.
A Proposal Code must be supplied.
MISSING_PROP_SEQ_NOProposal Code Sequence Number is missing.
A Proposal Code Sequence Number must be supplied.
MISSING_SEQ_NOProject History Sequence Number is missing.
A sequence number must be supplied for the Project History record.
MISSING_USER_IDUser ID is missing.
A value for User ID must be supplied.
PK_NOT_FOUNDCannot find record using primary or unique key for the Project History API.
The record cannot be found using the Internal ID, Proposal Code, and Project Code.
P_DELETE_FAILEDCannot delete Project History (ab_project_history) because the record does not exist.
No record exists for the Internal ID, Proposal Code, and Project Code.
RECORD_EXISTSProject History API cannot create Project History (ab_project_history) because the record already exists.
A new record cannot be created using the Internal ID, Proposal Code, Project Code, and Sequence Number.
SEQ_NO_IN_USEProject History Sequence Number already used for the Proposal
The Project History Sequence Number already used for the Proposal, Project, and Internal ID combination.
INVALID_FRBPROP_CODE_CHG_INDFinance Proposal Code Change Indicator is not valid.
The Finance Proposal Code Indicator must be Y or N.
INVALID_FRBPROP_CODEFinance Proposal Code is not valid.
The Finance Proposal must be exist on the FRBPROP table.
FRBPROP_CODE_NOT_ALLOWEDBanner Finance is not installed, Finance Proposal Code is not allowed.
Banner Finance must be installed to use Finance Proposal codes.

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.