Search Results translate_message

Overview

APPS.EAM_ASSET_MOVE_UTIL is a utility package within the Oracle Enterprise Asset Management (eAM) module of Oracle E-Business Suite, documented for releases 12.1.1 and 12.2.2. The package encapsulates the validation logic that governs whether an asset instance may be relocated from one organization to another. It supports the Asset Move user interface by exposing both single-asset and multi-asset validation entry points, and it is also referenced by the public eAM Asset Move API (EAM_ASSET_MOVE_PUB). The header revision shipped with the 12.1.1 code line (120.4.12010000.2, dated 2008/10/20) remains the basis for the logic documented in 12.2.2.

In operational terms, the package answers a set of prerequisite business questions before an asset move transaction is permitted: Is the destination item transactable in the target organization? Is the inventory period open? Does the asset carry a subinventory, a location, a route, or an in-transit status? Does it have production equipment or property manager links that would be invalidated by relocation? By centralizing these checks, EAM_ASSET_MOVE_UTIL ensures that asset moves do not violate inventory, maintenance, or organizational constraints.

Key Procedures and Functions

The package exposes fourteen documented units, most of which are boolean predicates used internally by the two public validation procedures.

• isValidMove — Validates a single asset instance for a move, accepting the instance, transaction date, item, and current organization, and returning a status plus a message.
• isValidAssetMove — Extends validation to an asset hierarchy record supplied by EAM_ASSET_MOVE_PUB, used when validating a list of asset records with a counter for iteration.
• isOpenPeriod — Determines whether the inventory period is open for the organization as of the transaction date (typically SYSDATE).
• isTransactable — Confirms the inventory item is transactable within the given organization.
• hasSubInventory — Indicates whether the asset instance is associated with a subinventory.
• isLocated — Indicates whether the asset is currently situated at a location.
• isInTransit — Detects whether the asset is in an in-transit state.
• isAssetRoute — Determines whether the asset participates in an asset route.
• hasProdEquipLink — Checks for an existing production equipment association.
• hasPropMngrLink — Checks for a property manager association.
• isInMaintOrg — Evaluates whether the asset resides in a different maintenance or production organization that is not maintained, blocking the move.
• isItemAssigned — Verifies item assignment for the organization.
• isUniqueShipmentNumber — Confirms uniqueness of a shipment number associated with the move.
• translate_message — Resolves Oracle Applications message tokens into user-facing text, enabling localized error and warning messages returned through the x_return_message parameters.

Tables Accessed

The package reads and, where appropriate, writes through APPS synonyms of core eAM and inventory tables.

• CSI_ITEM_INSTANCES — The primary asset instance table, queried to establish asset attributes, location, subinventory, and status.
• MTL_OBJECT_GENEALOGY — Used to trace asset relationships and hierarchies.
• MTL_PARAMETERS — Supplies organization-level inventory parameters, including period and transaction controls.
• MTL_SERIAL_NUMBERS — Provides serial number and shipment tracking data.
• MTL_SYSTEM_ITEMS_B — Confirms item definition and assignment within the organization.
• DUAL — Used for simple scalar checks and date evaluations.

Usage Notes

EAM_ASSET_MOVE_UTIL is invoked primarily from the eAM Asset Move form and from the Asset Move public API (EAM_ASSET_MOVE_PUB.isValidAssetMove). It is referenced by one other package in the ETRM registry. Because it is classified as a UTIL package and is called before the Asset Move UI is presented, customers generally consume it indirectly through standard eAM functionality rather than by direct invocation. Custom code extending asset move logic should call isValidMove or isValidAssetMove rather than the individual boolean functions, and should rely on translate_message to render returned messages in the user's language. As with all APPS-owned packages, direct modification is not supported.