Search Results pa_debug

Overview

PA_DEBUG is a central debugging and diagnostic utility package in the Oracle E-Business Suite Projects (PA) module. It is owned by the APPS schema and is maintained in a VALID state in both Oracle EBS 12.1.1 and 12.2.2. Its primary business function is to provide a standardized, controllable mechanism through which Projects application code, concurrent programs, and custom extensions can emit debug and diagnostic messages without disrupting normal production processing. Because it is classified as an "OTHER" API rather than a public business API, PA_DEBUG is intended primarily for internal and developer-facing use rather than for end-user business transactions.

The package allows developers and support personnel to selectively enable verbose output, route messages to logs or output files, and inspect runtime behavior. It also supplies error-stack management routines that standardize how exceptions are recorded and re-raised within Projects code. Its broad dependency footprint — referenced by 473 other packages — confirms that it acts as shared diagnostic infrastructure across the Projects suite.

Key Procedures and Functions

The documented interface exposes 29 procedures and functions, including the following core entries:

INITIALIZE — establishes the package's internal state at the start of a session or process.
ENABLE_DEBUG / DISABLE_DEBUG — toggle whether debug output is generated.
SET_DEBUG_LEVEL / DEBUG — set the verbosity threshold and emit a formatted debug message when the level permits.
GET_MESSAGE / NO_OF_DEBUG_MESSAGES — retrieve buffered debug text and report how many messages have been captured.
SET_USER_LOCK_MODE / ACQUIRE_USER_LOCK / RELEASE_USER_LOCK — coordinate serialized access to shared debug resources using locking semantics.
SET_PROCESS / WRITE_FILE — associate the current run with a named process and write captured output to a file.
INIT_ERR_STACK / SET_ERR_STACK / RESET_ERR_STACK / RAISE_ERROR — initialize, populate, clear, and raise errors using a structured error stack.
LOG_MESSAGE — record messages through the logging framework.
SET_CURR_FUNCTION / RESET_CURR_FUNCTION — track the currently executing function for contextual diagnostics.
WRITE_LOG — persist accumulated diagnostic information.

Tables Accessed

PA_DEBUG does not target conventional Projects transactional tables. Its documented references resolve to database and utility synonyms: DBMS_LOCK, DUAL, PLITBLM, and UTL_FILE. DBMS_LOCK supports the user-lock coordination routines. DUAL is used for lightweight singleton queries. UTL_FILE is used by WRITE_FILE to direct debug output to the file system. PLITBLM is referenced for PL/SQL internal table manipulation. Package dependencies additionally include FND_FILE, FND_GLOBAL, FND_LOG, FND_MESSAGE, PA_PLSQL_DATATYPES, and DBMS_STANDARD, reflecting integration with the Oracle Application Object Library logging and message infrastructure.

Usage Notes

PA_DEBUG is typically invoked from within other Projects packages rather than directly by end users. Developers insert DEBUG, LOG_MESSAGE, and error-stack calls into PL/SQL procedures and concurrent program logic, then enable output through ENABLE_DEBUG and SET_DEBUG_LEVEL when investigating issues. Custom code extending Projects functionality can adopt the same conventions to achieve consistent diagnostics. Because it is not referenced by any database object and is classified as OTHER, it is a supporting utility rather than an entry-point API, and its use should be limited to controlled diagnostic scenarios.

PACKAGE BODY: APPS.PA_DEBUG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_DEBUG, status:VALID,
PACKAGE BODY: APPS.PA_DEBUG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_DEBUG, status:VALID,
PACKAGE BODY: APPS.PA_PURGE_EXTN_VALIDATE 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PURGE_EXTN_VALIDATE, status:VALID,
PACKAGE BODY: APPS.PA_STARTUP 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_STARTUP, status:VALID,
PACKAGE BODY: APPS.PA_STARTUP 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_STARTUP, status:VALID,
PACKAGE BODY: APPS.PA_PURGE_EXTN 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PURGE_EXTN, status:VALID,
PACKAGE BODY: APPS.PA_PURGE_EXTN 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PURGE_EXTN, status:VALID,
PACKAGE: APPS.PA_DEBUG 12.2.2
PACKAGE BODY: APPS.PA_PROCESS_ACCUM_ACTUALS_RES 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PROCESS_ACCUM_ACTUALS_RES, status:VALID,
PACKAGE BODY: APPS.PA_PROCESS_ACCUM_ACTUALS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PROCESS_ACCUM_ACTUALS, status:VALID,
PACKAGE BODY: APPS.PA_PROCESS_ACCUM_BUDGETS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PROCESS_ACCUM_BUDGETS, status:VALID,
PACKAGE BODY: APPS.PA_ACCUM_SRW 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_ACCUM_SRW, status:VALID,
PACKAGE BODY: APPS.PA_PROCESS_ACCUM_BUDGETS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PROCESS_ACCUM_BUDGETS, status:VALID,
PACKAGE BODY: APPS.PA_PROCESS_ACCUM_ACTUALS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PROCESS_ACCUM_ACTUALS, status:VALID,
PACKAGE BODY: APPS.PA_FCK_UTIL 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_FCK_UTIL, status:VALID,
PACKAGE BODY: APPS.PA_ADW_CREATE_VIEWS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_ADW_CREATE_VIEWS, status:VALID,
PACKAGE BODY: APPS.PA_WORK_TYPE_UTILS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_WORK_TYPE_UTILS, status:VALID,
PACKAGE BODY: APPS.PA_CLIENT_EXTN_ASGMT_APPRVL 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_CLIENT_EXTN_ASGMT_APPRVL, status:VALID,
PACKAGE BODY: APPS.PA_PROCESS_ACCUM_ACTUALS_RES 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PROCESS_ACCUM_ACTUALS_RES, status:VALID,
PACKAGE BODY: APPS.PA_PERF_RULES_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PERF_RULES_PKG, status:VALID,
PACKAGE BODY: APPS.PA_CC_UTILS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_CC_UTILS, status:VALID,
PACKAGE BODY: APPS.PA_PERF_OBJECT_RULES_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PERF_OBJECT_RULES_PKG, status:VALID,
PACKAGE BODY: APPS.PA_CI_TYPES_UTIL 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_CI_TYPES_UTIL, status:VALID,
PACKAGE BODY: APPS.PA_PERF_THRESHOLDS_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PERF_THRESHOLDS_PKG, status:VALID,
PACKAGE BODY: APPS.PA_PROCESS_ACCUM_BUDGETS_RES 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PROCESS_ACCUM_BUDGETS_RES, status:VALID,
PACKAGE BODY: APPS.PA_WORK_TYPE_UTILS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_WORK_TYPE_UTILS, status:VALID,
PACKAGE BODY: APPS.PA_CLIENT_EXTN_ASGMT_APPRVL 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_CLIENT_EXTN_ASGMT_APPRVL, status:VALID,
PACKAGE BODY: APPS.PA_STATUS_LIST_ITEMS_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_STATUS_LIST_ITEMS_PUB, status:VALID,
PACKAGE BODY: APPS.PA_ASSET_REVERSAL_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_ASSET_REVERSAL_PVT, status:VALID,
PACKAGE BODY: APPS.PA_HR_ORG_UTILS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_HR_ORG_UTILS, status:VALID,
PACKAGE BODY: APPS.PA_STATUS_LIST_ITEMS_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_STATUS_LIST_ITEMS_PUB, status:VALID,
PACKAGE BODY: APPS.PA_CI_TYPES_UTIL 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_CI_TYPES_UTIL, status:VALID,
PACKAGE BODY: APPS.PA_PAY_VALIDATE 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PAY_VALIDATE, status:VALID,
PACKAGE BODY: APPS.PA_ROLE_LISTS_PVT 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_ROLE_LISTS_PVT, status:VALID,
PACKAGE BODY: APPS.PA_DELETE_ACCUM_RECS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_DELETE_ACCUM_RECS, status:VALID,
PACKAGE BODY: APPS.PA_RES_LIST_MEMBERS_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_RES_LIST_MEMBERS_PKG, status:VALID,
PACKAGE BODY: APPS.PA_FUND_REVAL_UTIL 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_FUND_REVAL_UTIL, status:VALID,
PACKAGE BODY: APPS.PA_PERF_TRANSACTIONS_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PERF_TRANSACTIONS_PKG, status:VALID,
PACKAGE BODY: APPS.PA_RES_AVL_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_RES_AVL_PVT, status:VALID,
PACKAGE BODY: APPS.PA_PCO_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PCO_PKG, status:VALID,
PACKAGE BODY: APPS.PA_PERF_RULES_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PERF_RULES_PKG, status:VALID,
PACKAGE BODY: APPS.PA_REFRESH_RES_LISTS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_REFRESH_RES_LISTS, status:VALID,
PACKAGE BODY: APPS.PA_PROGRESS_REPORT_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PROGRESS_REPORT_PUB, status:VALID,
PACKAGE BODY: APPS.PA_RESOURCE_SETUP_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_RESOURCE_SETUP_PVT, status:VALID,
PACKAGE BODY: APPS.PA_PRODUCT_INSTALL_UTILS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PRODUCT_INSTALL_UTILS, status:VALID,
PACKAGE BODY: APPS.PA_PROCESS_ACCUM_COMMITMENTS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PROCESS_ACCUM_COMMITMENTS, status:VALID,
PACKAGE BODY: APPS.PA_LABOR_SCH_RULE_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_LABOR_SCH_RULE_PKG, status:VALID,
PACKAGE BODY: APPS.PA_ROLE_CONTROLS_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_ROLE_CONTROLS_PVT, status:VALID,
PACKAGE BODY: APPS.PA_PAGE_TYPE_REGION_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PA_PAGE_TYPE_REGION_PVT, status:VALID,
PACKAGE BODY: APPS.PA_REP_UTIL_SETUP 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:PA_REP_UTIL_SETUP, status:VALID,