Search Results validate_picklist_lines

Overview

CSP_PICKLIST_LINES_PVT is a private (PVT) PL/SQL API package in the APPS schema that maintains picklist line records within Oracle EBS order fulfillment and shipping operations. Picklists drive warehouse picking activities, and their lines represent the individual item-quantity allocations that warehouse personnel confirm before shipment. This package provides the programmatic backbone for creating, updating, deleting, and validating those line records, exposing a standardized API signature that conforms to the Oracle Application Object Library API framework — shown by the use of FND_API.Compatible_API_Call, savepoints, message-list initialization, and the standard OUT parameters X_Return_Status, X_Msg_Count, and X_Msg_Data. The header comment identifies the source file as cspvtplb.pls with a version of 115.9 dated 2003, indicating an early-Release-11i-origin codebase that remains shipped and supported through 12.1.1 and 12.2.2. It is classified as PVT because it is intended for internal consumption by other CSP packages and public APIs rather than by external callers.

Key Procedures and Functions

The package documents 14 procedures. Three are transactional data-maintenance APIs:

• CREATE_PICKLIST_LINES — inserts a new picklist line from a record-typed IN parameter and returns the generated primary key (X_PICKLIST_LINE_ID).
• UPDATE_PICKLIST_LINES — modifies an existing line record using the same record structure.
• DELETE_PICKLIST_LINES — removes a picklist line identified by its primary key or record.

The remainder are single-attribute validators, each confirming that a supplied value is present, well-formed, and consistent before a write is attempted:

• VALIDATE_PICKLIST_LINE_ID, VALIDATE_PICKLIST_LINE_NUMBER — verify the line's surrogate key and human-readable sequence number.
• VALIDATE_PICKLIST_HEADER_ID — confirms the parent picklist header reference exists.
• VALIDATE_LINE_ID — checks the underlying order/line identifier linked to the picklist line.
• VALIDATE_INVENTORY_ITEM_ID — confirms the inventory item is valid for picking.
• VALIDATE_UOM_CODE — checks the unit of measure against the item's defined UOMs.
• VALIDATE_REVISION — validates the item revision where revision control applies.
• VALIDATE_QUANTITY_PICKED — ensures the picked quantity is numeric, positive, and within allowable bounds.
• VALIDATE_TRANSACTION_TEMP_ID — confirms the staging transaction reference used during picking.

Two procedures provide composite validation: VALIDATE_PICKLIST_LINE_REC applies the individual checks across all fields of a single line record, while VALIDATE_PICKLIST_LINES validates a collection or set of lines — the routine most often referenced when bulk-confirming or bulk-loading picklist data. All validators raise standard FND_API exception errors and populate the message list rather than returning a simple Boolean.

Tables Accessed

The ETRM metadata does not enumerate specific base tables via APPS synonyms; where the documentation is silent, the package operates on the CSP picklist line schema (CSP_PICKLIST_LINES and its associated header/line tables) accessed through APPS synonyms. Validation routines read inventory item, UOM, and revision definitions from the inventory master tables, and transaction-temp validation references the interim shipping transaction structures. All access is confined to the APPS schema under standard EBS security.

Usage Notes

Because it is a private package, CSP_PICKLIST_LINES_PVT is not invoked directly from Oracle Forms or concurrent programs. Instead, it is called by one referencing package — typically the public shipping or pick-confirm API — which supplies the transaction context, performs the top-level commit, and translates the PVT message list into user-facing errors. The internal savepoints allow the calling API to roll back a failed line without discarding the entire picking transaction. Customizations should call the public wrapper rather than this package, since the API version constant (1.0) and internal validation ordering are subject to change without notice between 12.1.1 and 12.2.2.