Search Results pn_debug

Overview

APPS.PN_DEBUG is a utility package in the Oracle E-Business Suite Property Manager (PN) module, which manages real estate leases, rent schedules, and property-related transactions. The package provides a centralized diagnostic and logging framework used throughout the PN product family. Its principal responsibility is to allow developers and support personnel to enable, control, and capture debug output generated by PN business logic without modifying the code being diagnosed. The package also manages an internal error stack and user-level locking, enabling consistent error propagation and controlled access to shared processes such as lease or variable-rent calculations.

In Oracle EBS 12.1.1 and 12.2.2, PN_DEBUG is deployed in the APPS schema with a status of VALID. It is classified as an "OTHER" API, indicating that it is an internal utility rather than a public integration API. The package is documented with 29 procedures and functions, all focused on debugging, logging, error stack manipulation, and session-level locking.

Key Procedures and Functions

The documented procedures fall into several functional groups:

Initialization and control: INITIALIZE sets up the package state for a session. ENABLE_DEBUG and DISABLE_DEBUG toggle debugging on or off, while SET_DEBUG_LEVEL controls the verbosity of captured output.
Debug output: DEBUG generates a diagnostic message. WRITE_FILE writes debug information to an output file. WRITE_LOG and LOG_MESSAGE record entries in the log. GET_MESSAGE retrieves a stored message, and NO_OF_DEBUG_MESSAGES returns the count of messages captured thus far. SET_PROCESS labels the current processing context.
Error stack management: INIT_ERR_STACK, SET_ERR_STACK, and RESET_ERR_STACK initialize, populate, and clear the internal error stack. RAISE_ERROR raises a formatted error using the stack contents.
Function tracking: SET_CURR_FUNCTION and RESET_CURR_FUNCTION mark entry into and exit from a procedure or function, supporting traceability of execution flow.
User locking: SET_USER_LOCK_MODE configures lock behavior; ACQUIRE_USER_LOCK and RELEASE_USER_LOCK obtain and free a user-level lock to prevent concurrent execution of sensitive processes.

The package depends on FND_FILE, FND_GLOBAL, and PN_PLSQL_DATATYPES, reflecting its integration with EBS file output, session context, and PN-specific datatype definitions.

Tables Accessed

PN_DEBUG references four objects through APPS synonyms. DBMS_LOCK is used to implement the user-level lock procedures. DUAL supports simple singleton queries. UTL_FILE provides the file I/O backing for WRITE_FILE and related logging output. PLITBLM is referenced in the dependency list and is associated with PL/SQL internal table and message handling used by the logging framework. No application transaction tables (such as lease or rent tables) are directly accessed, confirming that PN_DEBUG acts purely as an infrastructure utility.

Usage Notes

PN_DEBUG is referenced by six other PN packages, including PN_LEASE_PUB, PN_LEASE_PVT, PN_VAREN_PVT, PN_VAREN_UTIL, PN_INDEX_RENT_PVT, and PN_AM_WF. These packages call its debug, error stack, and locking routines during lease processing, variable-rent calculation, index-based rent adjustment, and workflow-driven activity management. The package is therefore invoked indirectly whenever property business logic executes, rather than being exposed directly to end users. Administrators typically enable debugging at the session or profile level, reproduce a transaction, and then inspect the resulting log file. Because ENABLE_DEBUG, SET_DEBUG_LEVEL, and the user-lock routines affect session behavior, custom code and concurrent programs should call them judiciously to avoid contention or excessive log volume. Disabling debug after diagnostics are complete restores normal performance.

PACKAGE: APPS.PN_DEBUG 12.2.2
owner:APPS, object_type:PACKAGE, object_name:PN_DEBUG, status:VALID,
PACKAGE: APPS.PN_PLSQL_DATATYPES 12.2.2
owner:APPS, object_type:PACKAGE, object_name:PN_PLSQL_DATATYPES, status:VALID,
PACKAGE BODY: APPS.PN_DEBUG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PN_DEBUG, status:VALID,
PACKAGE BODY: APPS.PN_INDEX_RENT_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PN_INDEX_RENT_PVT, status:VALID,
PACKAGE BODY: APPS.PN_VAREN_UTIL 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PN_VAREN_UTIL, status:VALID,
PACKAGE BODY: APPS.PN_LEASE_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PN_LEASE_PUB, status:VALID,
PACKAGE BODY: APPS.PN_AM_WF 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PN_AM_WF, status:VALID,
12.2.2 DBA Data 12.2.2
PACKAGE: APPS.PN_DEBUG 12.2.2
12.2.2 DBA Data 12.2.2
PACKAGE BODY: APPS.PN_VAREN_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PN_VAREN_PVT, status:VALID,
PACKAGE BODY: APPS.PN_LEASE_PVT 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:PN_LEASE_PVT, status:VALID,
SYNONYM: PUBLIC.DBMS_LOCK 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:DBMS_LOCK, status:VALID,
APPS.PN_VAREN_PVT dependencies on PN_DEBUG 12.2.2
APPS.PN_LEASE_PUB dependencies on PN_DEBUG 12.2.2
APPS.PN_AM_WF dependencies on PN_DEBUG 12.2.2
PACKAGE BODY: APPS.PN_DEBUG 12.2.2
APPS.PN_LEASE_PVT dependencies on PN_DEBUG 12.2.2
APPS.PN_VAREN_UTIL dependencies on PN_DEBUG 12.2.2
APPS.PN_DEBUG dependencies on PN_DEBUG 12.2.2
APPS.PN_INDEX_RENT_PVT dependencies on PN_DEBUG 12.2.2
SYNONYM: PUBLIC.UTL_FILE 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:UTL_FILE, status:VALID,
APPS.PN_DEBUG dependencies on FND_GLOBAL 12.2.2
APPS.PN_DEBUG dependencies on STANDARD 12.2.2
APPS.PN_DEBUG dependencies on FND_FILE 12.2.2
PACKAGE: APPS.FND_FILE 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_FILE, status:VALID,
PACKAGE: SYS.DBMS_STANDARD 12.2.2
owner:SYS, object_type:PACKAGE, object_name:DBMS_STANDARD, status:VALID,
PACKAGE: APPS.FND_LOG 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_LOG, status:VALID,
PACKAGE: APPS.FND_GLOBAL 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_GLOBAL, status:VALID,
SYNONYM: PUBLIC.DUAL 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:DUAL, status:VALID,
SYNONYM: PUBLIC.PLITBLM 12.2.2
owner:PUBLIC, object_type:SYNONYM, object_name:PLITBLM, status:VALID,
12.2.2 DBA Data 12.2.2
12.2.2 DBA Data 12.2.2
PACKAGE: APPS.FND_MESSAGE 12.2.2
owner:APPS, object_type:PACKAGE, object_name:FND_MESSAGE, status:VALID,