Search Results wsm_esa_pkg_error

Overview

APPS.CSTPOYUT is a cost management utility package body in Oracle E-Business Suite (EBS) Release 11i and 12.x, including 12.1.1 and 12.2.2. Its primary responsibility is to synchronize operation cost information in WIP_OPERATION_YIELDS with the material and operation costing data maintained by the Cost Management module. The package was originally created on 03/02/00 by Sujit Dalai and shipped under the file header CSTOYUTB.pls (version 115.5, last modified 2002/11/08). Despite its age, the package remains referenced across supported EBS releases because the underlying WIP operation yield and scrap-accounting logic has not materially changed.

The most notable aspect of the package, in the context of the search term wsm_esa_enabled, is its internal call to WSMPUTIL.WSM_ESA_ENABLED. This helper returns the "Estimated Scrap Accounting" (ESA) flag for a given WIP entity. The value of this flag governs whether operation cost and scrap-accounting updates proceed at all. When the flag equals zero, the package raises the internally declared exception WSM_ESA_PKG_ERROR; when the flag is not equal to one, the routine writes a message to the concurrent request log ("Estimated Scrap Accounting flag is disabled") and exits by returning 1 without performing the update. Only when ESA is fully enabled does execution continue to the UPDATE wip_operation_yields statement.

Key Procedures and Functions

The package exposes three documented program units:

• UPDATE_MAT_COST — The principal function, responsible for updating operation cost in WIP_OPERATION_YIELDS from the material cost manager. It accepts identifiers for cost type, material transaction, organization, operation sequence, inventory item, WIP entity, and WIP entity type, together with auditor columns (user, login, program application, program, request). It first evaluates the ESA flag and then performs the update of the operation yields record.
• UPDATE_WIP_COST — A companion routine that writes operation costing information to WIP tables, complementing the material cost path above.
• UPDATE_WOY_STATUS — Manages the status column of the WIP operation yields record, ensuring state consistency after cost updates are applied.

Tables Accessed

Through APPS synonyms, the package reads and writes the following documented tables:

• WIP_OPERATION_YIELDS — The central target of the update logic.
• WIP_ENTITIES and WIP_TRANSACTIONS — Source WIP context for the entities/transactions being costed.
• WIP_TRANSACTION_ACCOUNTS — Accounting distributions written alongside transaction cost updates.
• CST_ITEM_COSTS — The Cost Management source of item cost values.
• MTL_PARAMETERS — Organization-level cost and inventory parameters that drive validation and costing rules.

Usage Notes

CSTPOYUT is not invoked directly by end users; it is an internal utility invoked from WIP and Cost Management processing flows. Typical callers include the WIP costing and material transaction concurrent programs, the Resource Transaction and Move Transaction processing paths, and custom extensions that need to keep WIP_OPERATION_YIELDS aligned with Cost Management. Because the ESA flag is evaluated on entry, environments with Estimated Scrap Accounting disabled will simply log the skip message and return 1 without error. Custom code calling this package should therefore treat a return code of 1 as "not applied" rather than failure, and should handle the raised WSM_ESA_PKG_ERROR when the flag is zero. The package references no external packages other than WSMPUTIL and standard FND logging, and is itself referenced by no other documented packages, confirming its role as a leaf utility.