Search Results final_process_logging

Overview

APPS.FEM_INTG_PL_PKG is a PL/SQL package within Oracle Enterprise Financial Management (FEM), the segment of Oracle E-Business Suite that supports Enterprise Performance Foundation and related financial integration and reporting infrastructure. The package is defined with AUTHID CURRENT_USER and was authored to serve as a process-locking wrapper layer for the integration between Oracle General Ledger (OGL) and FEM. Its central responsibility is to provide lightweight validation functions that determine whether specific metadata operations — such as editing, deleting, or executing dimension rules against an object definition — are permitted at a given moment. In this capacity, the package acts as a gatekeeper, preventing conflicting or premature actions against object definitions and chart-of-accounts structures that are still referenced or in use.

Key Procedures and Functions

The package exposes six documented program units, each returning a VARCHAR2 flag value of 'T' or 'F' where applicable.

• OBJ_DEF_DATA_EDIT_LOCK_EXISTS — Determines whether an edit lock currently exists on a specified object definition. This supports concurrency control, allowing callers to detect that another process or user holds a lock before attempting modifications.
• CAN_DELETE_OBJECT_DEF — Evaluates whether a given object definition is eligible for deletion. This is the object most directly associated with the search term "can_delete_object_def" and is typically the entry point used by delete validation logic.
• DIMENSION_RULES_HAVE_BEEN_RUN — Verifies that all dimension rules associated with a given chart of accounts have executed successfully. It is used to confirm that prerequisite rule processing has completed before dependent operations proceed.
• EFFECTIVE_DATE_INCL_RSLT_DATA — Checks whether the supplied effective dates encompass the full range of result data, guarding against operations that would act on an incomplete or misaligned date span.
• REGISTER_PROCESS_EXECUTION — Records the execution of a process, supporting the process-locking and tracking behavior central to the package's purpose.
• FINAL_PROCESS_LOGGING — Performs concluding logging for a process, capturing completion status and related diagnostic information.

Tables Accessed

The package references two documented tables through APPS synonyms:

• FEM_INTG_DIM_RULES — Stores dimension rule definitions used during OGL-FEM integration. It is consulted when determining whether dimension rules have run and when validating object definition integrity.
• FEM_PL_OBJECT_EXECUTIONS — Tracks the execution history of FEM process-locking objects. It underpins the process registration and logging functions and informs lock and deletion eligibility checks.

Usage Notes

FEM_INTG_PL_PKG is not an end-user-facing API. It is invoked programmatically by other PL/SQL packages — three documented packages reference it — and by concurrent programs and forms that manage object definitions and dimension rule processing within FEM. Typical invocation occurs when a user attempts to delete an object definition, when the system validates that dimension rules have completed, or when a process registers its execution and performs final logging. Because the functions return simple 'T' or 'F' indicators, callers are expected to embed them in conditional logic rather than treat them as raising exceptions. Applications integrating with FEM at the database layer may also call these functions from custom code to reproduce the standard validation behavior. The AUTHID CURRENT_USER declaration means the package executes with the privileges of the invoking user, so schema-level grants on the underlying FEM tables must be in place for correct operation.