Results for “g_msg_lvl_error”

50+ results




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

Overview

The APPS.WSM_WLT_VALIDATE_PVT package is a private (PVT) API belonging to the Oracle E-Business Suite Warehouse Management (WSM) module, specifically the Work In Process (WIP) transactional validation layer. Its principal business function is to validate and reconcile data associated with shop-floor and work-order transactions before they are committed to WIP and inventory subsystems. In the context of Oracle EBS 12.1.1 and 12.2.2, this package forms part of the internal validation framework that guards the integrity of manufacturing execution transactions originating from the Warehouse Management and mobile supply chain applications (MSCA).

The package body carries the header signature $Header: WSMVVLDB.pls 120.28 2006/09/19, and its private scope indicates that it is not intended for direct invocation by end users or external integrations. Instead, it is designed for consumption by other WSM packages and is documented as being referenced by one other package. The naming convention and API classification (PVT) confirm it as an internal implementation package rather than a public, supported API.

Key Procedures and Functions

The metadata documents fifteen procedures, spanning transaction insertion, header validation, date derivation, and detailed validation of job, routing, BOM, and network information. Key routines include:

The remaining documented procedures follow the same derivation/validation pattern, ensuring each transaction attribute is checked against manufacturing master data before posting.

Tables Accessed

The package reads from a broad set of WIP, BOM, inventory, and HR tables through APPS synonyms. WIP_DISCRETE_JOBS, WIP_ACCOUNTING_CLASSES, and WIP_ENTITIES provide the job definition and accounting context. BOM tables (BOM_ALTERNATE_DESIGNATORS, BOM_OPERATIONAL_ROUTINGS, BOM_OPERATION_NETWORKS, BOM_OPERATION_SEQUENCES, BOM_STANDARD_OPERATIONS, and BOM_DEPARTMENTS) supply routing and operation data. Inventory tables (MTL_PARAMETERS, MTL_SECONDARY_INVENTORIES, MTL_SYSTEM_ITEMS, MTL_SYSTEM_ITEMS_KFV, and MTL_TRANSACTION_REASONS) provide item and subinventory context, while GL_CODE_COMBINATIONS and HR_ORGANIZATION_INFORMATION are used for account and organization validation.

Usage Notes

Because the package is classified as PVT, it should not be invoked directly from custom code. It is typically called by the parent WSM public API during transaction processing from Warehouse Management mobile forms, Material Workbench, or related concurrent programs. The declared logging and message-level variables (g_log_level_error, g_msg_lvl_error, etc.) demonstrate the package uses FND_LOG and FND_MSG_PUB for diagnostics and error reporting, making FND debug logging valuable when troubleshooting validation failures in 12.1.1 or 12.2.2.