Search Results set_completion_status

Overview

APPS.CSTPSMCM is a cost management package body that drives the costing of Work in Process (WIP) split and merge transactions. Its single documented entry point, WSM_COST_MANAGER, acts as the orchestration routine for picking up completed split/merge transactions that have not yet been costed and assigning them to a processing group for cost resolution. The package therefore sits between the WIP transaction layer, which records split and merge activity, and the Cost Management (CST) costing engine, which consumes those transactions.

The package is registered to the WIP application (the concurrency check in the body scans FND_CONCURRENT_REQUESTS for program_application_id 702, the WIP application identifier), and it is executed in a concurrent program context. The header indicates a maintenance level of 115.5, dated August 2004, which is consistent with a long-lived Oracle EBS module object carried forward into 12.1.1 and 12.2.2.

Key Procedures and Functions

• WSM_COST_MANAGER — The package's sole documented procedure. It accepts an OUT return code and an OUT error buffer, following the standard EBS concurrent program calling convention. It establishes the runtime context using FND_GLOBAL (user, login, request, program, and application identifiers), retrieves the MRP_DEBUG profile value, and initializes error-handling variables. Before doing any work, it verifies that no other instance of the same WIP concurrent program is in an active phase (Inactive, Pending, or Running); if one is found, it raises the CST_CSTPSMCW_RUNNING exception to prevent concurrent execution. It then iterates over the distinct organizations returned by a cursor over WSM_SPLIT_MERGE_TRANSACTIONS, and for each organization generates a new group identifier and updates the qualifying rows, stamping them with the group ID and resetting their costed status to Pending so the costing engine can process them.

No other procedures or functions are documented for this package.

Tables Accessed

• FND_CONCURRENT_REQUESTS — Read to detect another running instance of the WIP cost manager program. The package selects the request ID of any concurrent request in the same application and program that is in a non-terminal phase and is not the current request.
• WSM_SPLIT_MERGE_TRANSACTIONS — The primary work table. It is queried for distinct organization IDs where the split/merge transaction status is Completed and the costed flag is Pending or Error. Qualifying rows are then updated with a new group ID and set to Pending costed status.
• WSM_SPLIT_MERGE_TRANSACTIONS_S — The sequence associated with the split/merge transactions table, used via NEXTVAL to generate the group identifier assigned to each batch of transactions.
• DUAL — Used solely as the source for the sequence NEXTVAL selection.

Usage Notes

WSM_COST_MANAGER is designed to be invoked as an Oracle EBS concurrent program rather than called interactively. The signature (return code plus error buffer) and the use of FND_GLOBAL to derive request and program identifiers confirm that the routine is registered and submitted through the standard concurrent manager. It is not documented as being referenced by any other package, so there is no documented programmatic caller.

The package's relevance to searches for "set_completion_status" is peripheral: the completion state it filters on is the WIP status value (WIP_CONSTANTS.COMPLETED), and it filters on costed status values of Pending and Error. It does not expose a set_completion_status API. Administrators encountering this object should treat it as an internal costing batch utility whose behavior depends on the state of outstanding split/merge transactions and on the absence of a competing concurrent run.