BANINST1@S10B80

index

Package sb_feedback_session_strings

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

Message NameError Message
BAD_DATE_RANGEStart date must be equal to or less than end date.
CHILD_RECORD_EXISTSCannot delete feedback_session(sb_feedback_session) because feedback exists for this session.
Use the purge process to delete feedback data.
INVALID_ADD_COMMENTS_FLAGAdd Comments Flag is not valid.
Valid Values are Y and N.
INVALID_ADD_RECOMMENDS_FLAGAdd Recommends Flag is not valid.
Valid Values are Y and N.
INVALID_SURROGATE_IDSurrogate ID is not valid.
There is no feedback session with the given surrogate id.
INVALID_SUSPEND_FEEDBACK_INDSuspend Feedback Ind is not valid.
Valid Values are Y and N.
INVALID_TERM_CODETerm Code is not valid.
The term code was not found in STVTERM.
MISSING_ADD_COMMENTS_FLAGRequired Add Comments Flag is missing.
Valid Values are Y and N.
MISSING_ADD_RECOMMENDS_FLAGRequired Add Recommends Flag is missing.
Valid Values are Y and N.
MISSING_DATA_ORIGINRequired Data Origin is missing.
This value cannot be null.
MISSING_DESCRIPTIONRequired Description is missing.
This value cannot be null.
MISSING_END_DATERequired End Date is missing.
This value cannot be null.
MISSING_START_DATERequired Start Date is missing.
This value cannot be null.
MISSING_SURROGATE_IDRequired Surrogate Id is missing.
This value cannot be null.
MISSING_SUSPEND_FEEDBACK_INDRequired Suspend Feedback Ind is missing.
This value cannot be null.
MISSING_TERM_CODERequired Term Code is missing.
This value cannot be null.
MISSING_USER_IDRequired User Id is missing.
This value cannot be null.
NO_CHANGE_DESCCannot change session description or term because feedback exists for this session.
Once feedback exists for a session, you may not change the term code or description for a session.
NO_CHANGE_DESC_DUPTerm and Description combination already exists.
The term and description combination must be unique, and another session exists with the same values.
OPTIMISTIC_LOCK_FAILCannot update because another user has modified the record. Retry the operation.
Retry the operation.
OVERLAP_DATE_RANGEDate range overlaps with another session for this term.
Date ranges within a term cannot overlap.
PK_NOT_FOUNDCannot find record using primary or unique key for the sb_feedback_session API.
The record does not exist and may have been removed by another user.
P_DELETE_FAILEDCannot delete feedback session(sb_feedback_session) because the record does not exist.
The record does not exist and may have been removed by another user.
RECORD_EXISTSCannot create feedback_session(sb_feedback_session) because the record already exists.
There already exists a Feedback Session with this term and description. Enter a different term or a different description.


Program units
f_get_error   Returns the error message corresponding to p_errorname.

Variables
error_tab   Global PL/SQL table that holds the error messages.


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.