Search Results validate_countlistsequence

Overview

MTL_INV_VALIDATE_GRP is a grouped PL/SQL validation package in the Oracle E-Business Suite Inventory module, owned by the APPS schema and declared with AUTHID CURRENT_USER. It serves as the central validation layer for Oracle Inventory cycle counting operations. Its procedures accept user-entered or imported cycle count data and verify that each attribute — count date, count header, count quantity, item, locator, subinventory, unit of measure, and adjustment account — conforms to the rules defined in Oracle Inventory setup. When a value fails validation, the package returns the standard FND_API return status, message count, and message data, and in several procedures also an additional x_errorcode OUT parameter. This error code is why the package is commonly surfaced in searches for "x_errorcode": the validation procedures expose both the generic API message stack and a specific error identifier that callers can interrogate programmatically. The ETRM catalog classifies the package as an API group with nineteen documented procedures and records that it is referenced by three other packages.

Key Procedures and Functions

The package divides into helper routines and validation routines.

• GET_OFFSET_DATE — computes a date corresponding to an offset in days from a given start date, honoring a calendar code and exception set. The header comment confirms NOCOPY was added to the OUT parameters, including x_result_date, under Bug 4410902.
• GET_COUNTUOM — derives the count unit of measure from a supplied UOM code.
• GET_ITEM_SKU — derives item and SKU information from a count list sequence, accepting a row of MTL_CYCLE_COUNT_ENTRIES.
• GET_STOCKLOCATORCONTROLCODE — retrieves the stock locator control code for a given organization.
• VALIDATE_ADJUSTACCOUNT — validates the adjustment account against a passed adjustment account record structure, using the standard API parameters plus x_errorcode.
• VALIDATE_COUNTDATE — validates the count date, with x_errorcode added to its OUT parameters under the GSCC File.Sql.39 standard.
• VALIDATE_COUNTHEADER, VALIDATE_COUNTLISTSEQUENCE, VALIDATE_COUNTQUANTITY, VALIDATE_COUNTUOM — validate the count header, the count list sequence, the entered count quantity, and the count UOM respectively.
• VALIDATE_CTROL — validates cycle count control values.
• VALIDATE_ITEM, VALIDATE_LOCATOR, VALIDATE_SUBINV — validate that the item, locator, and subinventory supplied are valid within the counting organization.
• VALIDATE_PRIMARYUOMQUANTITY, VALIDATE_SECONDARYCOUNTUOM, VALIDATE_SECONDARYCOUNTQTY — validate primary and secondary UOM quantities, supporting dual-unit-of-measure counting.
• LOCATOR_CONTROL and NO_NEG_BALANCE — support locator control determination and negative balance restriction checks.

Tables Accessed

The package reads setup and transaction tables through APPS synonyms, including MTL_CYCLE_COUNT_ENTRIES, MTL_CYCLE_COUNT_HEADERS, MTL_CYCLE_COUNT_ITEMS, MTL_CC_SUBINVENTORIES, MTL_PARAMETERS, MTL_SYSTEM_ITEMS, MTL_ITEM_LOCATIONS, and MTL_SECONDARY_INVENTORIES for count, item, and locator validation. BOM_CALENDAR_DATES supports offset date computation, while FND_ID_FLEX_SEGMENTS and GL_CODE_COMBINATIONS support adjustment account validation.

Usage Notes

The package is invoked from Oracle Inventory cycle count forms and from custom code that performs bulk count entry or import, typically calling the validation procedures before committing counts. Callers should initialize the message list, check x_return_status, and drain messages via FND_MSG_PUB, while also inspecting x_errorcode where the procedure exposes it.