index

Package gb_visa_strings

This package contains the error messages and error message functions for the VISA API (gb_visa).

Message NameError Message
DEFAULTED_REC_EXISTSAnother Visa with unspecified dates exists. Cannot create record.
Only one record per PIDM can exist with the default Visa dates.
EXPIRE_ISSUE_DATE_ORDEREnd Date cannot be earlier than Visa Issue Date.
End Date cannot be earlier than Issue Date.
EXPIRE_REQ_DATE_ORDEREnd Date cannot be earlier than Visa Request Date.
End Date cannot be earlier than Request Date.
GORDOCM_EXISTSCannot delete Visa, Visa Document Information exists
All child records in the GORDOCM table must be deleted before deleting the parent GORVISA record.
INVALID_NATN_CODE_ISSUEInvalid Nation for Visa.
Nation code must exist in STVNATN.
INVALID_NO_ENTRIESInvalid Number of Entries for Visa; valid values are 'M', 'S' or a Number (1-99).
The valid values are M, S or a number between 1 and 99.
INVALID_PENT_CODEInvalid Port of Entry for Visa.
The Port of Entry code must exist in STVPENT.
INVALID_PIDMInvalid PIDM for Visa.
The PIDM does not exist in Banner.
INVALID_VISS_CODEInvalid Issuing Authority for Visa.
The Issuing Authority code must exist in GTVVISS.
INVALID_VTYP_CODEInvalid Type for Visa.
The Visa Type code must exist in STVVTYP.
ISSUE_REQ_DATE_ORDERRequest Date cannot be later than Visa Issue Date.
Request Date cannot be later than Issue Date.
MISSING_PIDMMissing mandatory PIDM for Visa.
The PIDM for the person must be provided. It is a key value for records in the table.
MISSING_USER_IDMissing User ID for Visa.
Typically this indicates an internal problem, since the Oracle user id is defaulted if it is not provided.
MISSING_VTYP_CODEMissing mandatory Type for Visa.
Visa Type code must be entered. It is a key value for records in the table.
NO_ENTRIES_NOT_REQDNumber of Entries must be null when Entry Indicator = 'N' for Visa.
Number of Entries must be null when Entry Indicator is N.
NO_ENTRIES_REQDNumber of Entries is required when Entry Indicator = 'Y' for Visa.
Number of Entries is required when Entry Indicator is Y.
PK_NOT_FOUNDCannot update Visa, record does not exist.
The combination of key values (PIDM, Sequence Number, Visa Type) is not present in the table for any record.
P_DELETE_FAILEDCannot delete Visa, record does not exist.
Record not found in Banner.  An attempt was made to delete a Visa record using combination of key values (PIDM, Sequence Number, Visa Type), but a record with this key is not present in the table.
RECORD_EXISTSCannot create Visa, record already exists.
A record with the requested PIDM, Sequence Number and Visa Type already exists in Banner.
START_EXPIRE_DATE_ORDERStart Date cannot be later than Visa End Date.
Start Date cannot be later than End Date.
START_ISSUE_DATE_ORDERStart Date cannot be earlier than Visa Issue Date.
Start Date cannot be earlier than Issue Date.
START_REQ_DATE_ORDERStart Date cannot be earlier than Visa Request Date.
Start Date cannot be earlier than Request Date.


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.