Search Results pay_log

Overview

APPS.HR_UTILITY is a foundational PL/SQL package body in the Oracle E-Business Suite HRMS (Human Resources Management System) schema, delivered in the APPS schema and marked VALID. It functions as a shared utility library that centralizes error handling, messaging, tracing, diagnostic, and session-context operations used throughout Oracle HRMS and, by extension, many other Oracle EBS modules. The package is documented with an API classification of OTHER, indicating that it is not a public business API but an internal infrastructure component.

The package derives much of its dependency footprint from Oracle Application Object Library (FND) and Oracle HR core services. It references FND_GLOBAL, FND_MESSAGE, FND_LOG, FND_NUMBER, FND_PROFILE, FND_RESPONSIBILITY, FND_SESSIONS, FND_USER, FND_USER_RESP_GROUPS, HR_GENERAL, HR_LEGISLATION_INSTALLATIONS, and PAY_PROC_LOGGING, along with Oracle-supplied built-ins such as DBMS_OUTPUT, DBMS_PIPE, DBMS_SQL, DBMS_UTILITY, DBMS_SYSTEM, and DBMS_STANDARD. This dependency set confirms its role as a cross-cutting helper rather than a business-transaction package.

Key Procedures and Functions

ETRM 12.2.2 documents 39 procedures and functions within HR_UTILITY. The principal groupings are:

• Messaging: HR_ERROR, RAISE_ERROR, ORACLE_ERROR, SET_MESSAGE, SET_MESSAGE_TOKEN, GET_MESSAGE, GET_MESSAGE_DETAILS, CLEAR_MESSAGE, SET_WARNING, CHECK_WARNING, and CLEAR_WARNING provide a standardized mechanism for storing, retrieving, formatting, and raising application messages and warnings, typically integrating with FND_MESSAGE.
• Tracing and diagnostics: TRACE, TRACE_ON, TRACE_OFF, TRACE_UDF, READ_TRACE_PIPE, and READ_TRACE_TABLE support runtime tracing of HR processes. These routines write and read trace output, using DBMS_PIPE, DBMS_OUTPUT, or a trace table depending on configuration.
• Context and environment: SET_LOCATION records a session or processing location used for diagnostics. The function TO and other helpers support internal conversions and general utilities.
• Data insertion: FND_INSERT performs controlled inserts into Oracle Application Object Library tables, most likely session and user-related records.

Each routine is intended for internal HRMS use; parameter lists are not reproduced here, and callers should not assume a public API contract.

Tables Accessed

Through APPS synonyms, HR_UTILITY accesses the following documented tables and views:

• FND_RESPONSIBILITY, FND_USER, FND_USER_RESP_GROUPS: Read for responsibility, user, and security context lookups used in messaging and session handling.
• FND_SESSIONS, ICX_SESSION_ATTRIBUTES: Session and self-service session attribute data used when resolving the current runtime context.
• HR_LEGISLATION_INSTALLATIONS: Determines which HR legislation/legislative data groups are installed, influencing message and trace behavior.
• V$PROCESS, V$SESSION: Database session and process information used by tracing and diagnostic routines.
• DUAL: Standard single-row utility queries for expressions and sequence-style lookups.
• DBMS_OUTPUT, DBMS_PIPE, DBMS_SQL, DBMS_UTILITY, PLITBLM: Supplied PL/SQL packages invoked for output buffering, inter-process communication, dynamic SQL, and utility functions.

Usage Notes

HR_UTILITY is invoked internally by the Oracle HRMS codebase rather than directly by end users. The ETRM metadata indicates it is referenced by 15,228 other database objects, confirming its status as one of the most widely depended-upon helper packages in the APPS schema. It is typically called from PL/SQL forms, concurrent programs, and other HR packages whenever consistent error handling, message token substitution, or diagnostic tracing is required.

Custom code should avoid calling undocumented HR_UTILITY routines directly, as their behavior is not guaranteed across releases. Where customizations need equivalent functionality, Oracle-supported APIs (for example, FND_MESSAGE or FND_LOG) should be preferred. This summary is based on ETRM 12.2.2 metadata and applies to Oracle EBS 12.1.1 and 12.2.2 environments.