index

Package sb_catlg_int_partner_strings

This package contains the error messages and error message functions for the Catalog Integration Partner API (sb_catlg_int_partner).

Message NameError Message
INVALID_CRSE_NUMBInvalid course number for the integration partner
Course number does not exist in the table SCBCRSE.
INVALID_DATA_ORIGINInvalid data origin for the integration partner
Data origin value is invalid.
INVALID_intg_cde Invalid integration partner code
Integration partner code does not exist in the table GORINTG.
INVALID_SUBJ_CODEInvalid subject for the integration partner
Subject code does not exist on the table STVSUBJ.
INVALID_TERM_CODE_EFFInvalid term code for the integration partner
Term code does not exist on the table STVTERM.
INVALID_USER_IDInvalid user ID for integration partner
Invalid user ID for the integration partner.
MISSING_CRSE_NUMBMissing mandatory Course Number for Integration Partner
Missing course number.
MISSING_INTG_CDE Missing mandatory integration partner code
Missing integration partner.
MISSING_PARENTIntegration partner code not defined on the integration partner rules table GORINTG
Missing integration partner code.
MISSING_SUBJ_CODEMissing mandatory subject code for integration partner
Missing subject code.
MISSING_TERM_CODE_EFFMissing mandatory term code for the integration partner.
Missing term code.
MISSING_USER_IDMissing mandatory user ID for integration partner
User ID is required and missing.
PK_NOT_FOUNDCannot find record using primary or unique key for Integration Partner
Cannot find a record with the specified integration partner code.
P_DELETE_FAILEDCannot delete, record does not exist
Record does not exist.
RECORD_EXISTSCannot create, record already exists
Record for the specified integration code already exists.


Program units
f_get_error  

Variables
error_tab  


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.