Results for “validate_cu_details”

18 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

The APPS.EAM_CONSTRUCTION_UNIT_PVT package body is the private implementation layer of the Enterprise Asset Management (EAM) Construction Unit API in Oracle E-Business Suite. It belongs to the EAM module, which supports the definition and management of complex assets constructed from multiple work orders and activities. The Construction Unit (CU) is a logical grouping that ties together a set of EAM work orders or activities that collectively build an asset, enabling cost roll-up, status tracking, and capitalization.

Because the package is classified as PVT (private), it is not intended for direct invocation by external applications. Instead, it backs the public API surface exposed by EAM_CONSTRUCTION_UNIT_PUB, which delegates the bulk of its transactional logic to this private package body. The package encapsulates validation, persistence, copy, and diagnostic logic for construction units and their associated activity lines, using the standard Oracle EBS API framework: savepoints, FND_API.Compatible_API_Call version checking, FND_MSG_PUB message stacking, and debug instrumentation keyed to the EAM_DEBUG profile option.

Key Procedures and Functions

The package exposes eight documented procedures and functions:

  • CREATE_CONSTRUCTION_UNIT — Creates a new construction unit header record and its associated activity table entries. It accepts a public CU record and activity table, initializes the message list, establishes a savepoint, and returns the generated construction unit identifier along with standard return status and message outputs.
  • UPDATE_CONSTRUCTION_UNIT — Modifies an existing construction unit and its related activities, applying the same API framework conventions as creation.
  • COPY_CONSTRUCTION_UNIT — Duplicates an existing construction unit, including its activity structure, to accelerate the setup of similar asset builds.
  • VALIDATE_CU_DETAILS — Performs business-rule validation on construction unit data before persistence, ensuring referential and attribute integrity.
  • SET_DEBUG — Reads the EAM_DEBUG profile option and initializes the package-level debug flag.
  • GET_DEBUG — Returns the current debug flag value to calling routines.
  • DEBUG — Writes diagnostic messages via EAM_ERROR_MESSAGE_PVT.Write_Debug when the debug flag is enabled; exceptions are intentionally suppressed.
  • DUMP_ERROR_STACK — Outputs the accumulated error stack for troubleshooting failed API calls.

Tables Accessed

The package reads and writes several core EAM and inventory tables through APPS synonyms:

  • EAM_CONSTRUCTION_UNITS — The primary table holding construction unit header records.
  • MTL_PARAMETERS — Supplies organization-level inventory parameters required for validation and defaults.
  • MTL_SYSTEM_ITEMS_B and MTL_SYSTEM_ITEMS_KFV — Provide item definitions and the key flexfield view used to resolve and validate items referenced by construction units.
  • WIP_ACCOUNTING_CLASSES — Supports accounting class assignment and validation for the construction process.
  • PLITBLM — The standard Oracle EBS message table used by the FND message stack framework.

Usage Notes

This package should never be called directly. It is invoked by EAM_CONSTRUCTION_UNIT_PUB in response to construction unit creation, update, or copy operations initiated from the EAM responsibility. Typical callers include the Construction Unit setup forms, EAM concurrent programs that build or capitalize constructed assets, and custom integrations that use the public API. One other package references it, consistent with its role as a shared private implementation.

Because the package relies on FND_API.Compatible_API_Call, callers must supply a compatible API version. Debug output is controlled by the EAM_DEBUG profile option and should be enabled only for troubleshooting, since verbose tracing carries a performance cost.