Search Results validate_def_notify_resp_id

Overview

APPS.BIS_TARGET_LEVEL_VALIDATE_PVT is a private (PVT) PL/SQL API belonging to the Oracle E-Business Suite Business Intelligence System (BIS) schema. Its purpose is to validate the level and dimension identifiers, workflow process names, responsibility identifiers, and computed target identifiers that are referenced when defining a Measures record within the BIS target/measure configuration framework. The package body carries the internal header identifier BISVTLVB.pls and is designated a private API in the ETRM classification, meaning it is intended for internal consumption by other BIS packages rather than as a public integration point. The header comments confirm its stated role as the "Private API for validating items in the MEASUREs record." A maintenance note dated 27-JAN-2003 (bug#2758428) documents a refactor that introduced separate local variables for IN and OUT parameters, reflecting the package's long-standing presence in the EBS code base through the 12.1.1 and 12.2.2 releases.

Key Procedures and Functions

The package exposes twelve documented procedures, each responsible for validating a specific attribute of a Measures record definition. All follow the standard EBS API validation pattern: they accept an input value (and typically an API version), write a return status via an OUT parameter, and populate an error table using BIS_UTILITIES_PUB.Error_Tbl_Type when the value fails validation.

• VALIDATE_ORG_LEVEL_ID — validates the organizational level identifier used as a measure dimension.
• VALIDATE_TIME_LEVEL_ID — validates the time level identifier.
• VALIDATE_DIMENSION1_LEVEL_ID through VALIDATE_DIMENSION7_LEVEL_ID — seven procedures that validate the level identifier for each of the seven configurable dimension slots.
• VALIDATE_WF_PROCESS_SHORT_NAME — validates the short name of the associated Workflow process used in measure notification or processing logic.
• VALIDATE_DEF_NOTIFY_RESP_ID — the procedure matching the user's search term; validates the default notification responsibility identifier assigned to a measure definition.
• VALIDATE_DF_COMPUTED_TARGET_ID — validates the default computed target identifier.

Using VALIDATE_DIMENSION_LEVEL_ID as the documented template, each procedure declares a cursor over BIS_LEVELS keyed on the supplied level identifier, checks the value is not missing and not null via BIS_UTILITIES_PUB helper functions, and on failure invokes BIS_UTILITIES_PVT.Add_Error_Message with a named error message such as BIS_INVALID_DIMENSION_LEVEL_ID, an error level of FND_MSG_PUB.G_MSG_LVL_ERROR, and the calling procedure name attributed via G_PKG_NAME.

Tables Accessed

The only table documented as referenced through APPS synonyms is BIS_LEVELS. Each level-validation procedure queries BIS_LEVELS to confirm that the supplied level identifier exists before accepting the Measures record attribute. The validation is read-only; no inserts, updates, or deletes against BIS_LEVELS are recorded in the documented body. Error conditions are surfaced through the error table rather than through table writes.

Usage Notes

BIS_TARGET_LEVEL_VALIDATE_PVT is invoked internally by one other documented package, and it is not exposed as a standalone concurrent program or form-level entry point. Practically, it is triggered during the save or submission of a Measures/target definition in the BIS setup UI, when EBS must confirm that referenced levels, dimensions, workflow process names, notification responsibilities, and computed targets are valid before committing the record. The standard return convention applies: callers inspect x_return_status against FND_API.G_RET_STS_SUCCESS and, on error, read the populated BIS_UTILITIES_PUB.Error_Tbl_Type to obtain the named message and originating procedure. Custom code should not call it directly in place of public BIS APIs, as the PVT designation signals that its signature may change between releases. Because it depends on FND_API and BIS_UTILITIES_PUB/PVT, the package requires the standard EBS foundation packages to be initialized on the session before use.