index

Package ab_project_results_strings

This package contains the error messages and error message functions for AB_PROJECT_RESULTS.

Message NameError Message
INVALID_CAMPAIGNAMRPRRS_CAMPAIGN for the ab_project_results API is not valid.
The Campaign does not exist in the database.
INVALID_DESGAMRPRRS_DESG for the ab_project_results API is not valid.
The Designation does not exist in the database.
INVALID_GIFT_NOAMRPRRS_GIFT_NO for the ab_project_results API is not valid.
Gift Number is not valid for the Internal ID.
INVALID_PIDMAMRPRRS_PIDM for the ab_project_results API is not valid.
The Internal ID does not exist in the database.
INVALID_PLEDGE_NOAMRPRRS_PLEDGE_NO for the ab_project_results API is not valid.
Pledge Number is not valid for the Internal ID.
INVALID_PROJ_CODEAMRPRRS_PROJ_CODE for the ab_project_results API is not valid.
The Project Code does not exist in the database.
INVALID_PROP_CODEAMRPRRS_PROP_CODE for the ab_project_results API is not valid.
The Proposal Code does not exist in the database.
INVALID_PROP_SEQ_NOAMRPRRS_PROP_SEQ_NO for the ab_project_results API is not valid.
The Proposal Code does not exist in the database.
INVALID_RESULT_DATEAMRPRRS_RESULT_DATE for the ab_project_results API is not valid.
The Result Date is not a valid date.
INVALID_SEQ_NOAMRPRRS_SEQ_NO for the ab_project_results API is not valid.
The Project Results Sequence Number must be between 0 and 999.
INVALID_VALUEAMRPRRS_VALUE for the ab_project_results API is not valid.
The Result Value must be between 0 and 999999999.99.
MISSING_DATA_ORIGINAMRPRRS_DATA_ORIGIN is missing. This field is required by the ab_project_results API.
The source of the data being supplied must be given.
MISSING_PIDMAMRPRRS_PIDM is missing. This field is required by the ab_project_results API.
An Internal ID must be supplied.
MISSING_PROJ_CODEAMRPRRS_PROJ_CODE is missing. This field is required by the ab_project_results API.
A Project Code must be supplied.
MISSING_PROP_CODEAMRPRRS_PROP_CODE is missing. This field is required by the ab_project_results API.
A Proposal Code must be supplied.
MISSING_PROP_SEQ_NOAMRPRRS_PROP_SEQ_NO is missing. This field is required by the ab_project_results API.
A Proposal Code Sequence Number must be supplied.
MISSING_RESULT_DATEAMRPRRS_RESULT_DATE is missing. This field is required by the ab_project_results API.
A Result Date must be supplied.
MISSING_SEQ_NOAMRPRRS_SEQ_NO is missing. This field is required by the ab_project_results API.
A Project Results Sequence Number must be supplied.
MISSING_USER_IDAMRPRRS_USER_ID is missing. This field is required by the ab_project_results API.
A User ID must be supplied for the person making the change.
PK_NOT_FOUNDCannot find record using primary or unique key for the ab_project_results API.
A record could not be found for the supplied primary key information.
P_DELETE_FAILEDCannot delete PROJECT_RESULTS(ab_project_results) because the record does not exist.
A record could not be found for the supplied primary key information.
RECORD_EXISTSab_project_results API cannot create PROJECT_RESULTS(ab_project_results) because the record already exists.
The record cannot be created because another record already exists with the same primary key.


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.