Search Results validate_responsibility_id




Overview
Explore in AI Chat

Overview

BIS_MEASURE_SEC_VALIDATE_PVT is a private PL/SQL package in the APPS schema that provides the internal validation logic for the Measures Security record used by Oracle E-Business Suite's Balanced Scorecard / performance management components. The package is classified as a Private (PVT) API, meaning it is not intended for direct invocation by external callers; rather, it is called by the public API layer to enforce data integrity before a Measure Security record is committed to the database. Its principal responsibility is to confirm that the reference values supplied on an inbound Measures Security record—specifically foreign key identifiers such as the target level and responsibility—correspond to valid records in their respective base tables, and to raise a standard API error when a violation is detected.

Key Procedures and Functions

The documented package exposes three procedures:

  • VALIDATE_TARGET_LEVEL_ID — Verifies that the Target_Level_Id held on the incoming Measure Security record refers to an existing target level. It opens an explicit cursor against BIS_TARGET_LEVELS to test for existence, and when the identifier is supplied but no matching row is found, it adds the error message BIS_INVALID_MSR_SECURITY_VALUE via BIS_UTILITIES_PVT.Add_Error_Message and raises FND_API.G_EXC_ERROR to abort processing.
  • VALIDATE_RESPONSIBILITY_ID — Performs the analogous existence check for the Responsibility_Id carried on the Measure Security record, ensuring the responsibility reference is valid before the record is persisted.
  • VALIDATE_RECORD — Serves as the orchestration entry point, invoking the individual column-level validators in sequence to validate the complete Measures Security record.

Tables Accessed

Validation against BIS_TARGET_LEVELS is confirmed by the documented source. The package reads this table to confirm that a supplied Target_Level_Id resolves to a known target level. No inserts, updates, or deletes are performed; the package is strictly read-only, consistent with its validation-only purpose. Additional base tables are referenced indirectly through the responsibility and record validators, but BIS_TARGET_LEVELS is the only table explicitly documented in the ETRM metadata.

Usage Notes

This package is invoked indirectly. A caller searching on "validate_target_level_id" is typically tracing why a Measures Security record was rejected with the error message BIS_INVALID_MSR_SECURITY_VALUE. The private package is referenced by one other package, which is the public API (BIS_MEASURE_SECURITY_PUB) that external code, forms, or concurrent programs call. Standard guidance applies: do not call BIS_MEASURE_SEC_VALIDATE_PVT directly from custom code; instead invoke the corresponding public API, which delegates to this private validator and returns the standard x_return_status and x_error_tbl outputs. The validation level parameter defaults to FND_API.G_VALID_LEVEL_FULL, so callers relying on default behavior receive complete record validation. When diagnosing a rejected record, verify that the Target_Level_Id exists in BIS_TARGET_LEVELS and that the referenced responsibility is active and valid.