Search Results debug_enter

Overview

PQP_GB_PSI_GRADE_CODES is a United Kingdom–localized Oracle HRMS package body owned by APPS and classified as an "OTHER" API within the ETRM repository. It supports the statutory reporting obligations of UK payroll processing under the Payroll Standard Interface (PSI) framework, specifically the extraction and validation of employee grade code information. The package supplies the grade-related data elements that UK legislative reporting requires from the PER_GRADES table, together with a set of controlled debugging utilities that allow PL/SQL execution to be traced through the database pipe mechanism without altering production code. The body is versioned at pqpgbpsigrd.pkb 120.0 and is identified in ETRM as being referenced by no other packages, indicating it operates as a top-level entry point called directly by concurrent programs or forms rather than as a shared library.

Key Procedures and Functions

• DEBUG — A thin wrapper that forwards trace messages and location identifiers to PQP_UTILITIES.DEBUG, providing a consistent internal entry point for diagnostic output throughout the package.
• DEBUG_ENTER — The procedure most closely associated with the "debug_enter" search term. It tests the package-level debug flag and, when tracing is enabled and the nested call level is zero, activates HR_UTILITY.TRACE_ON using the 'REQID' pipe name before delegating to PQP_UTILITIES.DEBUG_ENTER. This ensures a single trace pipe is opened per concurrent request session.
• DEBUG_EXIT — The logical counterpart to DEBUG_ENTER; it closes down diagnostic tracing for a procedure boundary once the guarded debug flag is set.
• DEBUG_OTHERS — A standard exception handler used to capture and route unexpected errors to the debug trace rather than allowing uncontrolled propagation.
• CHK_GRADE_CODES_CRIT — Implements the validation logic that determines whether grade code records satisfy the criteria required for UK statutory reporting, operating on the criteria that govern inclusion in the extract.
• GRADE_EXTRACT_MAIN — The principal processing routine that drives extraction of grade code data for the PSI submission, orchestrating validation and output generation.
• GRADE_CODES_POST_PROCESSING — Performs the reconciliation and cleanup steps applied after the main extract has completed, prior to final file generation.

Tables Accessed

The package references a single documented table, PER_GRADES, accessed through its APPS synonym. PER_GRADES is the Oracle HRMS grade definition table holding grade identifiers, names, and related attributes for each business group. CHK_GRADE_CODES_CRIT and GRADE_EXTRACT_MAIN read from this table to identify the grades that must be reported to the UK authorities, while GRADE_CODES_POST_PROCESSING confirms that each extracted grade resolved to a valid PER_GRADES row before the submission data set is finalized.

Usage Notes

The package is invoked in the context of UK payroll statutory reporting, typically from a concurrent program responsible for generating the PSI grade code extract, or from custom code that must reproduce the same validation rules. Because it is referenced by no other documented packages, callers invoke its procedures directly. The debug procedures are guarded by the package-level debug flag, so DEBUG_ENTER only opens an HR_UTILITY trace pipe when diagnostics have been deliberately enabled; otherwise the routines return immediately with negligible overhead. This design makes it safe to leave debug calls embedded in the production extract path while enabling request-level tracing — via the REQID pipe — only when a concurrent request requires investigation.