index

Package gb_businessprofile_str

This package contains the error messages and error message functions for the BUSINESS PROFILE API, GB_BUSINESSPROFILE.

Message KeyError Message
MISSING_FGAC_USER_IDMissing mandatory value for Business Profile Fine-grained Access User ID.
The Business Profile Fine-grained Access User ID is missing and must be a valid user in the ALL_USERS table.  This is the Oracle ID for the Banner user.
MISSING_FBPR_CODEMissing mandatory value for Business Profile Code.
The Business Profile Code is missing and must be a valid code in the Business Profile Validation table (GTVFBPR).
MISSING_USER_IDMissing mandatory value for Business Profile User ID.
The Business Profile User ID is missing and must be a valid user in table ALL_USERS.  This is the Oracle ID for the Banner user for which the Business Profile will apply.
INVALID_FGAC_USER_IDInvalid value for Business Profile Fine-grained Access User ID.
An attempt was made to create or update the Business Profile Fine-grained Access User ID.  The User ID must be a valid user in the table ALL_USERS.
This is the Oracle ID for the Banner user for which the Business Profile will apply.
INVALID_FBPR_CODEInvalid value for Business Profile Code.
An attempt was made to create or update the Business Profile Code with an invalid value.  Valid values must exist in the Business Profile Validation table (GTVFBPR).
INVALID_USER_IDInvalid value for Business Profile User ID. 
An attempt was made to create or update the Business Profile User ID.  The User ID must be a valid user in the table ALL_USERS.
This is the Oracle ID for the Banner user who updated the record most recently, in insert, update or delete mode.
GOBFPUD_EXISTSCannot delete record while child record exists on Fine-grained Access Person User Defaults.
An attempt was made to delete a Business Profile Record when a Fine-grained Access Person User Defaults record exists for that Business Profile.
P_DELETE_FAILEDCannot delete, record does not exist
An attempt was made to delete a Business Profile Record was unsuccessful because the record could not be found.
PK_NOT_FOUNDCannot find record using primary or unique key
An attempt to update or delete a Business Profile record was unsuccessful because the record could not be found using the primary key of Fine-grained Access User ID and Business Profile Code.  This is the Oracle ID for the Banner user who updated the record most recently, in insert, update or delete mode.
RECORD_EXISTSCannot create, record already exists
An attempt to create a Business Profile was unsuccessful because the record already exists;  duplicates are not allowed.


Program units
f_get_error   Returns error message corresponding to p_errorname.

Variables
error_tab   PL/SQL table type to hold API specific error message strings.


error_tab

error_tab gb_common.errmsg_tab_type;

PL/SQL table type to hold API specific error message strings.


f_get_error

FUNCTION f_get_error(p_errorname VARCHAR2) RETURN VARCHAR2

Returns error message corresponding to p_errorname.

Parameters
p_errorname   Name associated with the error message.

Returns
Returns the error message corresponding to p_errorname.