index

Package gb_third_party_access_strings

This package contains the error messages and error message functions for the Third Party Access API.

Message KeyError Message
EXTERNAL_USER_EXISTSThird party ID already exists.
Third Party ID should be unique.
INVALID_EXTERNAL_USERInvalid value for External User. Should be lowercase letters, numbers, periods, hyphens, and underscores.
External User should be lowercase letters, numbers, periods, hyphens, and underscores.
INVALID_PIDMInvalid or missing PIDM.
Supply a value for PIDM.
INVALID_PIN_DISABLED_INDInvalid value for Personal Identification Number disabled indicator.
Personal Identification Number disabled indicator must be Y or N.
INVALID_USAGE_ACCEPT_INDInvalid value for Terms of Usage accepted indicator.
Terms of Usage accepted indicator must be Y or N.
MISSING_PIDMMissing mandatory value for PIDM.
A PIDM must be provided to perform any Create or Update operation on Third Party Access.
MISSING_PIN_DISABLED_INDMissing mandatory value for Personal Identification Number disabled indicator.
Supply a value for Personal Identification Number disabled indicator.
MISSING_USAGE_ACCEPT_INDMissing mandatory value for Terms of Usage accepted indicator.
Supply a value for Terms of Usage accepted indicator.
MISSING_USERMissing mandatory value for User ID.
Supply a value for User ID.
PIN_NOTLONG_CHARPIN must be 6 characters long.
PIN must be 6 characters long.
PIN_NOTLONG_NUMBERPIN must be 6 digits long.
PIN must be 6 digits long.
PIN_NOT_NUMBERPIN must be numeric.
PIN must be numeric.
PK_NOT_FOUNDCannot find record using primary or unique key.
QUESTION_MUST_EXISTSPIN Hint Question must not be null.
If p_response is not NULL then p_question must be not NULL.
RECORD_EXISTSCannot create, record already exists.
RESPONSE_MUST_EXISTSPIN Hint Response must not be null.
If p_question is not NULL then p_response must be not NULL.


Program units
f_get_error   Returns the error message corresponding to p_errorname.

Variables
error_tab  


error_tab

error_tab gb_common.errmsg_tab_type;

f_get_error

FUNCTION f_get_error(p_errorname VARCHAR2) RETURN VARCHAR2

Returns the error message corresponding to p_errorname.

Parameters
p_errorname   Name associated with the error message.