index

Package gb_medical_strings

This package contains the error messages and error message functions for the MEDICAL API (gb_medical).

Message NameError Message
INVALID_DISA_CODEInvalid Disability Type for Medical Information
Disability Type Code must exist in STVDISA.
INVALID_DISB_INDInvalid Primary Disability Indicator for Medical Information; valid values: 'N' and 'Y'
The valid values are Y or N.
INVALID_MDEQ_CODEInvalid Medical Equipment for Medical Information
Medical Equipment Code must exist in STVMDEQ
INVALID_MEDI_CODEInvalid Medical Condition for Medical Information
Medical Condition Code must exist in STVMEDI.
INVALID_PIDMInvalid PIDM for Medical Information
The PIDM does not exist in Banner.
INVALID_PRIMARY_DISB_EXISTSOnly one disability may be designated as primary for Medical Information
Only one medical condition may be designated as primary.
INVALID_SPSR_CODEInvalid Disability Service for Medical Information
Disability Service Code must exist in STVSPSR.
MISSING_MEDI_CODEMissing mandatory Medical Condition for Medical Information
Medical Condition Code must be entered. It is a key value for records in the table.
MISSING_PIDMMissing mandatory PIDM for Medical Information
The PIDM for the person must be provided. It is a key value for records in the table.
PK_NOT_FOUNDCannot find record using primary or unique key for Medical Information
The combination of key values (PIDM, Medical Condition Code) does not exist.
P_DELETE_FAILEDCannot delete Medical Information, record does not exist
An attempt was made to delete a medical information record that does not exist.
RECORD_EXISTSCannot create Medical Information, record already exists
An attempt was made to create a medical information record with a PIDM and Medical Condition Code that already exists.


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.