Search Results set_wpr_log_context

Overview

PQH_WKS_ERROR_CHK is an Oracle E-Business Suite PL/SQL package owned by the APPS schema and classified under the OTHER API category. It belongs to the Public Sector/HR budgeting subsystem (PQH), which supports position and budget worksheet processing. The package validates worksheet data before it is applied to the budget, acting as a pre-application error and integrity checker within the worksheet budgeting workflow. It consolidates validation logic across worksheet details, periods, budget sets, budget elements, funding sources, and cost allocation data, and records diagnostic information to the process log.

Its principal role is to detect inconsistencies, invalid combinations, and structural problems in worksheet rows so that the budget application process can proceed safely. The package is therefore a defensive gatekeeper that protects downstream budget posting from corrupt or incomplete worksheet data.

Key Procedures and Functions

The package exposes eighteen documented procedures and functions, organized around setup, validation, and logging:

• POPULATE_GLOBALS — Initializes package-level variables used by subsequent validation calls within a session.
• CHECK_WKS_ERRORS — The primary driver that orchestrates worksheet error checking across the various entity checks.
• CHECK_WKS_DATES — Validates date-related consistency for the worksheet.
• CHECK_LEVEL1_ROWS — Verifies top-level worksheet rows for validity.
• CHECK_WKS_DETAILS — Validates worksheet detail lines.
• CHECK_WKS_PERIODS — Checks worksheet period data for correctness.
• CHECK_WKS_BUDGET_SETS — Validates budget set assignments associated with the worksheet.
• CHECK_WKS_BUDGET_ELEMENTS — Validates budget element values.
• CHECK_WKS_FUND_SRCS — Validates funding source entries.
• CHECK_INPUT_WKS_DETAILS — Validates user-supplied detail input, including grade, job, and position references.
• CHECK_PC_POSN — Checks position and cost allocation relationships.
• SET_WKS_LOG_CONTEXT, SET_WPR_LOG_CONTEXT, SET_WST_LOG_CONTEXT, SET_WEL_LOG_CONTEXT, SET_WFS_LOG_CONTEXT — Establish logging context for worksheets, worksheet periods, budget sets, budget elements, and funding sources, respectively, so that messages are attributed correctly.
• END_LOG — Finalizes the logging session.
• UPDT_BATCH — Updates batch processing status or batch-related records.

Tables Accessed

The package reads and writes the following documented tables through APPS synonyms:

• PQH_WORKSHEET_DETAILS, PQH_WORKSHEET_PERIODS, PQH_WORKSHEET_BUDGET_SETS, PQH_WORKSHEET_BDGT_ELMNTS, PQH_WORKSHEET_FUND_SRCS — the core worksheet structures that hold the data being validated.
• PQH_PROCESS_LOG — receives error and diagnostic messages generated during validation.
• PQH_BUDGETS, PQH_BUDGET_DETAILS — provide budget context for the worksheet.
• FND_NEW_MESSAGES — supplies user-facing error message text.
• HR_ALL_POSITIONS_F, PER_GRADES, PER_JOBS, PER_SHARED_TYPES, PER_TIME_PERIODS — reference entities used to validate positions, grades, jobs, shared types, and time periods.
• PAY_COST_ALLOCATION_KEYFLEX — validates cost allocation key flexfield values for worksheet rows.

Usage Notes

PQH_WKS_ERROR_CHK is referenced by the PQH_APPLY_BUDGET package, indicating it is invoked during the budget application process, typically to pre-validate worksheet data before commit. It is also self-referential, with internal calls between its procedures. In practice it is called from Oracle Public Sector budgeting forms, concurrent programs that apply or validate worksheets, and custom extensions that need to confirm worksheet integrity. Because it writes to PQH_PROCESS_LOG, callers should ensure the appropriate logging context is set. The package is valid and should be invoked rather than directly modified, consistent with Oracle support guidelines for proprietary APPS code.