Search Results validate_safety_info




Overview
Explore in AI Chat

Overview

APPS.EAM_SAFETY_ASSET_UTL_PKG is a utility PL/SQL package within the Oracle Enterprise Asset Management (eAM) module of Oracle E-Business Suite. It provides the validation logic that governs how safety-related asset information is captured and checked before it is persisted against an asset instance registered in Enterprise Asset Management. The package is declared with AUTHID CURRENT_USER, meaning its procedures execute with the privileges of the calling schema rather than the package owner, a design pattern commonly used for APIs intended to be invoked from multiple entry points such as forms, concurrent programs, or external integrations.

The package header carries the version identifier $Header: EAMSAFUS.pls 120.0 2011/02/23, indicating it is part of the standard eAM safety functionality shipped across the 12.1.1 and 12.2.2 code lines. Its responsibilities centre on instance-number validation and safety-information validation, making it a supporting utility behind the eAM safety asset numbering and safety attribute screens.

Key Procedures and Functions

The ETRM documentation records two public procedures in the package specification:

  • VALIDATE_INSTANCE_NUMBER — validates the instance number associated with an asset instance. It accepts an instance identifier as input and returns the resolved instance number, a create/update indicator, a standard return status, and the usual message count and message data outputs. This procedure is the object most directly associated with the user search term validate_instance_number, and it serves as the server-side check invoked when a user or process supplies an instance number that must resolve to a valid CSI instance.
  • VALIDATE_SAFETY_INFO — validates a complete eAM asset safety information record supplied via the EAM_SAFETY_ASSET_NUMBER_PUB.eam_asset_safety_info_rec_type record type. It returns the standard status and message outputs, allowing callers to determine whether the supplied safety data satisfies the business rules before an insert or update is attempted.

Both procedures follow the standard Oracle EBS API output convention: x_return_status, x_msg_count, and x_msg_data. Neither procedure is documented as returning an explicit value, confirming they are procedures rather than functions.

Tables Accessed

The documented table references for this package are:

  • CSI_ITEM_INSTANCES — the core instance repository of the Install Base (CSI) schema. VALIDATE_INSTANCE_NUMBER reads from this table to confirm that the supplied instance identifier corresponds to a genuine item instance before allowing downstream processing.
  • EAM_ASSET_SAFETY_TYPES — the eAM configuration table that defines the valid safety types and their attributes. VALIDATE_SAFETY_INFO consults this table to ensure that safety information presented against an asset conforms to an established, enabled safety type.

Access is performed through APPS synonyms in the standard EBS manner, so the package remains insulated from the underlying schema owners.

Usage Notes

EAM_SAFETY_ASSET_UTL_PKG is a utility package rather than a top-level business API. It is referenced by one other documented package, and is typically invoked from the eAM asset safety forms and from the surrounding safety asset numbering flow immediately before the corresponding public API performs its insert or update. Because the procedures raise or bundle errors through the standard message count and message data outputs, callers are expected to check x_return_status and drain the message stack on failure.

Customisations and extensions that need to accept or verify an eAM instance number should call VALIDATE_INSTANCE_NUMBER instead of reimplementing the check, thereby preserving consistency with the seeded eAM validation rules across 12.1.1 and 12.2.2 environments.