index

Package gb_institution_role_strings

Error messages and error message functions for the INSTITUTION_ROLE API (gb_institution_role).

Message NameError Message
MISSING_PIDMInternal Id (PIDM) is missing. This field is required by the gb_institution_role API.
The PIDM is a required field but the value is NULL.
MISSING_ROLE_GROUPRole Group is missing. This field is required by the gb_institution_role API.
The Role Group is a required field but the value is NULL.
MISSING_ROLERole is missing. This field is required by the gb_institution_role API.
The Role is a required field but the value is NULL.
MISSING_USER_IDUser Id is missing. This field is required by the gb_institution_role API.
The User Id is a required field but the value is NULL.
INVALID_PIDMInternal Id (PIDM) for the gb_institution_role API is not valid.
The PIDM does not exist in the database.
INVALID_ROLE_GROUPRole Group for the gb_institution_role API is not valid.
The Role Group does not exist in the gtvsqpr validation table.
INVALID_ROLERole for the gb_institution_role API is not valid.
The Role does not exist in the gtvsqru validation table.
INVALID_VPDI_CODEVPDI Code for the gb_institution_role API is not valid.
The VPDI Code does not exist in the gtvvpdi validation table.
P_DELETE_FAILEDCannot delete INSTITUTION_ROLE(gb_institution_role) because the record does not exist.
A record with the primary key can not be found and therefore the delete request can not be satisfied.
PK_NOT_FOUNDCannot find record using primary or unique key for the gb_institution_role API.
A record with the primary key can not be found.
RECORD_EXISTSGb_institution_role API cannot create INSTITUTION_ROLE(gb_institution_role) because the record already exists.
A record with the same primary key already exists and therefore a new record may not be created.


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.