Search Results put_log

Overview

APPS.HXT_RETRIEVAL_ROLLBACK is a server-side PL/SQL package body within the Oracle E-Business Suite Time and Labor (HXT) and OTL Retrieval (HXC) module stack. Its primary business function is to reverse or "roll back" previously retrieved, transferred, or batch-processed timecard data so that payroll and time-entry records can be restored to a consistent pre-retrieval state. The package supports both normal retrieval batches and retroactive (retro) batches, and it also accommodates Business Event Engine (BEE) driven rollbacks and time transfer / overtime rollbacks. The header comment ($Header: hxtrollret.pkb 120.1.12020000.2) indicates the package was last versioned under the 12.1.3 / 12.2.2 release lineage, making it applicable to both Oracle EBS 12.1.1 and 12.2.2 environments. The package maintains internal collection types (NUMTAB) for tracking identifiers such as batch IDs and sequence numbers, uses a package-level counter (g_seq), and writes diagnostic output through a local put_log mechanism to aid troubleshooting during long-running rollback operations.

Key Procedures and Functions

The documented public interface exposes six procedures and functions:

• ROLLBACK_NORMAL_BATCHES — Reverses standard Time and Labor retrieval batches, restoring affected timecards and transaction records to their prior state.
• ROLLBACK_RETRO_BATCHES — Handles rollback of retroactive batches, where a newer retrieval must be undone and prior results reinstated.
• PUT_LOG — A logging utility used throughout the package (for example, via display_numtab) to emit diagnostic messages and collection contents during processing.
• ROLLBACK_BEE — Rollback logic tied to Business Event Engine processing, reversing BEE-originated data changes.
• ROLLBACK_BEE_RETRO — The retroactive counterpart to ROLLBACK_BEE, reversing BEE data where retro processing applies.
• ROLLBACK_XFER_TIME_OTLR — Reverses time-transfer and overtime retrieval activity, a distinct rollback path from standard batch reversal.

Supporting (private) routines include display_numtab and string_list for formatting NUMTAB collections, set_session_date for populating FND_SESSIONS, and payroll_name for resolving payroll identifiers through PAY_ALL_PAYROLLS_F.

Tables Accessed

The package reads and writes across the HXC and HXT schemas via APPS synonyms. FND_SESSIONS is used to set the effective session date prior to processing. HXC_RET_PAY_DETAILS, HXC_RET_PAY_LATEST_DETAILS, HXC_PAY_LATEST_DETAILS, and HXC_DATA_SETS hold retrieval/pay details and data set definitions that must be updated or purged during rollback. HXC_TRANSACTIONS and HXC_TRANSACTION_DETAILS store the transactional time records being reversed. HXC_ROLLBACK_LOG, HXC_ROLLBACK_TIMECARDS_ALL, and HXC_TIMECARD_SUMMARY log rollback outcomes and summarize affected timecards. HXT_BATCH_STATES and HXT_SEQNO track batch status and sequence control. HXT_REVERSED_BATCH_LINES_ALL and HXT_REVERSED_BATCH_TC_ALL capture the reversed batch lines and timecards, while HXT_DET_HOURS_WORKED_F records detailed hours worked that must be adjusted.

Usage Notes

HXT_RETRIEVAL_ROLLBACK is referenced by zero other packages in the documented metadata, so it is not a shared utility API. It is typically invoked from Oracle Forms (Time and Labor administrative screens), concurrent programs, or targeted custom code when an administrator needs to undo a retrieval or batch run. Because it manipulates payroll-retrieval, transaction, and timecard data directly, it should be called within a controlled transaction boundary, with the FND_SESSIONS effective date correctly set. The presence of put_log and display_numtab indicates the package is intended for diagnostic-run scenarios where detailed trace output is desirable.