index

Package gb_cm_rules_str

* This package contains the error messages and error message functions
* for GB_CM_RULES.
*
*    74-1 begin
* *    74-1 end
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
Message KeyError Message
CANNOT_DELETE_RULES_EXISTCannot delete, record used in existing Matching Rules rec
ord.
Column is used in an existing Matching Rule.
INVALID_CMSC_CODEInvalid value for Source Code
Common Matching Source Code must be defined on form GTVCMSC.
INVALID_COLUMN_NAMEInvalid value for Column Name
Column Name must be defined in ALL_TAB_COMMENTS table.
INVALID_DATA_ORIGINInvalid value for Data Origin
Data Origin must contain valid value.
INVALID_DATA_REQ_INDInvalid value for Match on Null Data
GORCMSR_DATA_REQ_IND can only be set to 'N' or 'Y'.
INVALID_LENGTHInvalid value for Length
GORCMSR_LENGTH must be valid 3-digit integer.
INVALID_ONLINE_INDColumn is invalid for online common matching
Corresponding column row in GORCMDD table must have GORCMDD_ONLINE_MATCH_IND set to 'Y' to allow Online Common Matching process.
INVALID_PRIORITY_NOInvalid value for Priority Number
GORCMSR_PRIORITY_NO must be valid 2-digit integer.
INVALID_USER_IDInvalid value for User ID
User ID must exist on table ALL_USERS.
IN_DATA_DICTIONARYCannot delete, required column
GORCMSR rows with GORCMSR_DATA_REQ_IND set to 'Y' cannot be deleted.  Existing rules may relying on these columns.
LENGTH_NOT_POSITIVELength must be a positive number
GORCMSR_LENGTH must be valid positive 3-digit integer.
MISSING_CMSC_CODEMissing mandatory value for Source Code
Valid Common Matching Source Code must be entered from GTVCMSC table.
MISSING_COLUMN_NAMEMissing mandatory value for Column Name
GORCMSR_COLUMN_NAME must be entered from valued on GORCMDD table.
MISSING_DATA_REQ_INDMissing mandatory value for Match on Null Data
GORCMSR_DATA_REQ_IND must be entered.  Valid values are 'Y' and 'N'.
MISSING_LENGTHMissing mandatory value for Length
Valid 3-digit integer for GORCMSR_LENGTH must be entered. 
MISSING_PARENTRequired parent record not found 
Parent GTVCMSC or GORCMDD row may be missing.
MISSING_PRIORITY_NOMissing mandatory value for Priority Number
Valid 2-digit GORCMDD_PRIORITY_NUMBER must be entered. 
MISSING_USER_IDMissing mandatory value for User ID
Valid User ID must be entered.
OVERRIDES_LENGTHCannot override Max Length
Maximum length set on GORCMDD table cannot be overridden here.
PK_NOT_FOUNDCannot find record using primary or unique key
Passed parameter values could not locate row in table.
P_DELETE_FAILEDThere is no row in the table with the key values passed. 
Passed parameter values could not locate row in table.
RECORD_EXISTSCannot create, record already exists
Row already exists in database for this Common Matching Source Code and Priority Number combination.

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.