index

Package gb_cm_source_priority_str

This package contains the error messages and error message functions for GB_CM_SOURCE_PRIORITY_STR.

Message KeyError Message
DETAILS_EXISTCannot delete, details exist
The detail records in the Common Matching Rules table GORCMSR must be deleted first.
INVALID_CMSC_CODEInvalid value for Source Code
Matching Source Code must be defined on table GTVCMSC before adding subordinate GORCMSP Rule Priority row.
INVALID_PRIORITY_NOInvalid value for Priority Number
Priority Number must be two-digit number.
MISSING_CMSC_CODEMissing mandatory value for Source Code
Matching Source Code must be valid row from GTVCMSC table.
MISSING_DESCMissing mandatory value for Description
Description must be supplied for Matching Source rule.
MISSING_PRIORITY_NOMissing mandatory value for Priority Number
Priority must be two-digit number.
MISSING_USER_IDMissing mandatory value for User ID
Valid Banner User ID must be supplied.
PK_NOT_FOUNDCannot find record using primary or unique key
Row could not be located in GORCMSP table using passed parameter values.
P_DELETE_FAILEDCannot delete, record does not exist
Row could not be deleted in GORCMSP table using passed parameter values.
RECORD_EXISTSCannot create, record already exists
Row already exists in GORCMSP table using passed parameter values.
MISSING_PARENTRequired parent record not found
Parent record not found for this combination of key values.


Program units
f_get_error   Returns error message corresponding to p_errorname

Variables
error_tab   Global error table that holds the error message.


error_tab

error_tab gb_common_strings.errmsg_tab_type;

Global error table that holds the error message.


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 error message.