Search Results bis_invalid_dimension_level_id




Overview
Explore in AI Chat

Overview

APPS.BIS_DIM_LEVEL_VALIDATE_PVT is a private PL/SQL package body in the Oracle E-Business Suite (EBS) Business Intelligence System (BIS) module. It provides the private validation API used to verify the contents of a Dimension Level record before that record is persisted or processed by the public dimension level API. Dimension levels define the hierarchical granularity associated with a business dimension — for example, the levels within a time or organization dimension — and therefore constitute a foundational element of the BIS analytical data model.

The package is classified as PVT (private API) within the ETRM documentation. As a private package, it is not intended to be called directly by external or customer code; instead it is consumed internally by the public companion API, BIS_DIMENSION_LEVEL_PUB, and by one other package that references it. Its purpose is to centralize record-level validation logic so that all callers obtain consistent, standardized error reporting. The header comment identifies the source file as BISVDLVS.pls and describes the package as the "Private API for validating items in the Dimension Level record."

Key Procedures and Functions

  • Validate_Record — The single documented procedure in the package body. It accepts a dimension level record (of type BIS_DIMENSION_LEVEL_PUB.Dimension_Level_Rec_Type), a standard API version argument, and a validation level argument that defaults to FND_API.G_VALID_LEVEL_FULL. It returns a standard return status (x_return_status) and an error table (x_error_tbl) of type BIS_UTILITIES_PUB.Error_Tbl_Type. The procedure initializes the return status to FND_API.G_RET_STS_SUCCESS, then evaluates the record for missing or null mandatory attributes. When validation fails, it populates the error table by calling BIS_UTILITIES_PVT.Add_Error_Message with the message name BIS_INVALID_DIMENSION_LEVEL_ID. This message name is directly relevant to users searching for "bis_invalid_dimension_level_id," since the package is the component that raises that specific error condition.

Tables Accessed

The ETRM metadata does not document any database tables referenced directly by this package via APPS synonyms. This is consistent with its role as a pure validation routine: its logic operates on the in-memory dimension level record passed by the caller and on the utilities package error table, rather than querying or mutating base tables. Any persistence of a validated record is performed by the calling public API, not by this private validator.

Usage Notes

This package is invoked internally when a dimension level record must be validated prior to insert, update, or processing. Callers include the public dimension level API and one additional dependent package. Typical invocation points are BIS setup forms or concurrent programs that create and maintain dimension levels, as well as custom code that legitimately calls the public BIS dimension level API and relies on its implicit validation. Because the package is private, direct invocation is not supported; customers should use BIS_DIMENSION_LEVEL_PUB. When an error is returned, the error table will contain the BIS_INVALID_DIMENSION_LEVEL_ID message, indicating that the dimension short name or dimension level short name is missing or null. Developers diagnosing this error should inspect the record passed to the public API for those mandatory attributes.