index

Package gb_cm_user_procedure_str

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

Message KeyError Message
INVALID_CMSC_CODEInvalid value for Source Code
Matching Source Code must be defined on table GTVCMSC and have subordinate GORCMSP Rule Priority and GORCMSR Matching Rule before building a GORCMUP Matching Procedure.
INVALID_DATA_ORIGINInvalid value for Data Origin
Data Origin must contain valid value.
INVALID_PRIORITY_NOInvalid value for Priority Number
Priority Number must be two-digit number.
INVALID_SEQ_NOInvalid value for Sequence Number
Sequence Number must be two-digit number.
INVALID_USER_IDInvalid value for User ID
User ID must be valid Banner User ID.
MISSING_CMSC_CODEMissing mandatory value for Source Code
Matching Source must exist on GTVCMSC.
MISSING_PARENTRequired parent record not found 
Parent record must exist on GORCMSC.
MISSING_PRIORITY_NOMissing mandatory value for Priority Number
Priority Number must be two-digit number.
MISSING_PROCEDURE_NAMEMissing mandatory value for Procedure Name
Procedure Name must be entered and exist on database.
MISSING_SEQ_NOMissing mandatory value for Sequence Number
Sequence Number must be two-digit number.
MISSING_USER_IDMissing mandatory value for User ID
Valid User ID must be entered.
PK_NOT_FOUNDCannot find record using primary or unique key
Passed parameter values could not locate row in table.
P_DELETE_FAILEDCannot delete, record does not exist
Passed parameter values could not locate row in table.
RECORD_EXISTSCannot create, record already exists
Passed paramters found existing row in GORCMUP table.


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.