index

Package ab_custom_search_detail_str

This package contains the error messages and error message functions for the Custom Search Detail API (ab_custom_search_detail).

Message NameError Message
INVALID_DISP_INDDisplay Indicator for the ab_custom_search_detail API is not valid.
Valid values for the Display Indicator are Y and N. Y indicates that the associated search option should be displayed on the search page. N indicates that the search option should not be displayed.
INVALID_DISP_SEQNODisplay Sequence Number for the ab_custom_search_detail API is not valid.
The Display Sequence Number must be a numeric value between 01 and 99.
INVALID_DOSR_CODESearch Option Code for the ab_custom_search_detail API is not valid.
The Search Option Code entered does not exist on the Advancement Officers Search Options Table (ATVDOSR).
INVALID_PIDMUnique identifier (AORDOSR_PIDM) for the ab_custom_search_detail API is not valid.
The Internal Identification Number is missing or does not exist in the database.
INVALID_SRCH_NAMESearch Name for the ab_custom_search_detail API is not valid.
The Search Name does not exist on the Advancement Officer Search Options Preference Header Table (AOBDOSR).
INVALID_USER_IDUser ID (AORDOSR_USER_ID) for the ab_custom_search_detail API is not valid.
The User ID supplied does not exist within the Banner system.
MISSING_DISP_INDDisplay Indicator is missing. This field is required by the ab_custom_search_detail API.
Valid values for the Display Indicator are Y and N. Y indicates that the associated search option should be displayed on the search page. N indicates that the search option should not be displayed.
MISSING_DISP_SEQNODisplay Sequence Number is missing. This field is required by the ab_custom_search_detail API.
The Display Sequence Number must be a numeric value between 01 and 99.
MISSING_DOSR_CODESearch Option Code is missing. This field is required by the ab_custom_search_detail API.
The Search Option Code must be entered and exist on the Advancement Officers Search Options Table (ATVDOSR).
MISSING_PARENTRequired AOBDOSR record not found for ab_custom_search_detail API.
An Advancement Officer Search Options Preference Header Table (AOBDOSR) record must exist for the Internal Identification Number and the Search Name.
MISSING_PIDMUnique identifier (AORDOSR_PIDM) is missing. This field is required by the ab_custom_search_detail API.
An Internal Identification Number must be supplied.
MISSING_SRCH_NAMESearch Name is missing. This field is required by the ab_custom_search_detail API.
The Search Name must be entered and exist on the Advancement Officer Search Options Preference Header Table (AOBDOSR).
MISSING_USER_IDUser ID (AORDOSR_USER_ID) is missing. This field is required by the ab_custom_search_detail API.
A User ID must be supplied and exist within the Banner system.
PK_NOT_FOUNDCannot find record using primary or unique key for the ab_custom_search_detail API.
The Advancement Officer Search Options Preference Repeating Table record could not be found using the Internal Identification Number, Search Name, and Search Option Code supplied.
P_DELETE_FAILEDCannot delete CUSTOM_SEARCH_DETAIL (ab_custom_search_detail) because the record does not exist.
A record does not exist for the Internal Identification Number, Search Name, and Search Option Code supplied.
RECORD_EXISTSab_custom_search_detail API cannot create CUSTOM_SEARCH_DETAIL (ab_custom_search_detail) because the record already exists.
A record already exists for the Internal Identification Number, Search Name, and Search Option Code supplied.


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.