Search Results g_debug_enabled




Overview
Explore in AI Chat

Overview

APPS.PON_REMINDER_NOTIFICATION_PKG is an Oracle E-Business Suite PL/SQL package body that belongs to the sourcing family of modules (the PON prefix denotes Oracle Sourcing / Oracle Purchasing sourcing objects). Its core business purpose is to generate and dispatch reminder notifications to bidders and internal participants involved in sourcing events such as auctions, RFQs, and bids. These reminders are driven by configurable timing rules, allowing the application to notify recipients a defined number of days before a close date, after an open date, or after a preview date. The package is tightly integrated with the Oracle Workflow notification framework (WF_ITEMS and related APIs) and with the FND logging infrastructure. It exposes a wrapper procedure that performs administrative housekeeping, including the purging of obsolete notifications, before delegating the actual message composition and delivery work.

Key Procedures and Functions

The package documents six program units:

  • SEND_NOTIFICATION_WRAPPER — The public entry point. It parses the incoming reminder timing parameters, such as the reminder trigger type and the associated day values, purges unused notifications, and then calls the core notification procedure. It also initializes debug state and writes progress messages when logging is enabled.
  • SEND_NOTIFICATION — The principal worker that assembles the recipient list and reminder content, then initiates delivery for each applicable sourcing event.
  • CALL_WF_PROCESS_TO_SEND_NOTIF — Bridges the package to the Workflow engine, invoking the appropriate workflow process responsible for transmitting the notification.
  • START_WF_PROCESS — Starts the designated Workflow process instance used to generate and route the notification item.
  • PURGE_NOTIF_WF — Removes or cleans up workflow notification records that are no longer required, preventing accumulation of stale reminder items.
  • LOG_MESSAGE — Writes diagnostic and progress text to the FND logging tables when debug output is active.

Tables Accessed

The package operates across a defined set of APPS synonyms:

  • PON_AUCTION_HEADERS_ALL, PON_BID_HEADERS, and PON_BIDDING_PARTIES — supply the sourcing event, bid, and participant data used to determine who receives a reminder and when.
  • PER_ALL_PEOPLE_F and FND_USER — resolve recipients to valid application users and persons.
  • WF_ITEMS — supports creation and management of workflow notification items.
  • FND_LOG_MESSAGES — stores debug and progress messages emitted through LOG_MESSAGE.
  • DUAL, DBMS_RANDOM, and PLITBLM — utilities used for single-row queries, random value generation, and PL/SQL table indexing respectively.

Usage Notes

The package is normally invoked by Oracle Sourcing's internal reminder scheduling logic, typically through a concurrent program or background process rather than direct user action. In the 12.1.1 and 12.2.2 code lines, the debug behavior referenced by the search term g_debug_enabled is governed by the profile option AFLOG_ENABLED and the current FND logging runtime level. When AFLOG_ENABLED is 'Y' and the runtime level permits statement-level logging, g_debug_enabled is set to 'Y' and detailed trace output is written to FND_LOG_MESSAGES. This makes the variable the central switch for troubleshooting notification delivery. Custom code should call SEND_NOTIFICATION_WRAPPER rather than lower-level procedures, as it encapsulates parameter parsing and purge handling. No other packaged objects are documented as referencing this package, confirming its role as a top-level reminder utility.