Search Results calling_fn

Overview

The APPS.FA_STANDARD_PKG package body is a foundational utility package within the Oracle E-Business Suite Fixed Assets (FA) module. It resides in the APPS schema and is delivered in a VALID state in both EBS 12.1.1 and 12.2.2. The package is classified as an OTHER API in the ETRM metadata, indicating that it is not a public, supported business API intended for external integration, but rather an internal shared-service package that centralizes common helper logic used across the Fixed Assets codebase.

Its principal business function is to provide standardized, reusable routines — most notably error-handling and message-generation logic — that other FA packages invoke rather than duplicating equivalent logic. By concentrating these utilities in one place, Oracle ensures consistent exception-raising behavior, uniform message text, and a single point of maintenance across the Fixed Assets application. The package is heavily depended upon: the metadata records that 36 other packages reference FA_STANDARD_PKG, underscoring its role as a low-level building block in the FA dependency chain.

Key Procedures and Functions

The ETRM documentation lists one documented procedure or function for this package:

• RAISE_ERROR — The single documented program unit. It serves as the standardized error-raising routine for the Fixed Assets module. Its purpose is to accept an error condition and surface it as a properly formatted application exception, typically by retrieving the appropriate message text via the FND_MESSAGE facility and then propagating the error to the calling program. This centralizes the formatting and raising of errors so that every dependent FA package reports failures in a consistent manner.

No parameter lists are enumerated in the source metadata, and no other documented program units exist. The dependency list confirms that RAISE_ERROR and its siblings rely on APP_EXCEPTION and FND_MESSAGE for exception syntax and message lookup, and on FA_API_TYPES for shared Fixed Assets data-type definitions.

Tables Accessed

The ETRM metadata does not document any direct references to Fixed Assets application tables from within this package. The dependency listing reports references only to PL/SQL constructs and infrastructure packages — App_Exception, FA_API_TYPES, the package itself, FND_MESSAGE, FND_PROFILE, and the SYS/DBMS_STANDARD/STANDARD built-ins. This is consistent with the package's role as a utility layer: it does not query or manipulate asset records, books, or depreciation data directly. Instead, any profile-option retrieval it performs uses the FND_PROFILE API rather than a direct table read, and any message text is obtained through FND_MESSAGE. Custom implementations should therefore not expect this package to be a source of asset table access.

Usage Notes

Because FA_STANDARD_PKG is classified as OTHER and its procedures are not documented as public APIs, it is intended primarily for internal consumption by Oracle's own Fixed Assets code. It is typically invoked indirectly — for example, when a user action in the Fixed Assets forms raises an application error, the underlying FA package calls FA_STANDARD_PKG.RAISE_ERROR to present the message. The same applies to concurrent programs (such as depreciation, mass additions, and period close) and to other FA APIs that surface validation or processing errors.

The metadata explicitly states that FA_STANDARD_PKG is not referenced by any database object other than its 36 dependent packages, and the package body is dependent on FA_STANDARD_PKG's own specification. For custom development, the recommended approach is to invoke supported FA APIs rather than calling FA_STANDARD_PKG directly, since Oracle does not warrant the stability of OTHER-classified internal routines across patches or upgrades. Developers who must reference it should treat RAISE_ERROR as an error-propagation helper only and avoid extending the package, as direct modifications to APPS-owned objects are not supported.