Search Results pg_debug

Overview

IEX_WF_DEL_CUR_STATUS_NOTE_PUB is a public PL/SQL package in the Oracle EBS Advanced Collections (IEX) module. Its business purpose is to raise Oracle Workflow notifications when a delinquency is closed or reaches a "Current" status. As documented in the package header comments, the procedure must be called with an itemtype and workflow process that will launch the workflow; the workflow then notifies both the owner and the manager associated with the delinquency. This supports the collections process by ensuring that responsible parties are informed when a delinquent customer account is brought back to a current standing.

The package is classified as an API, Public (PUB), with owner APPS. The header revision ($Header: iexwfcnb.pls 120.1 2006/05/30 ... noship $) indicates the code originates from the 11i/12.1 development line and is carried forward into 12.2.2. It is referenced by one other package, indicating it is consumed as a callable utility rather than being an entry point form-driven object.

Key Procedures and Functions

The ETRM metadata documents four procedures within this package body:

START_WORKFLOW - The primary entry point. Based on the excerpted source, it accepts an API version, initialization flag, commit flag, and a collection of delinquency IDs (IEX_UTILITIES.t_del_id), returning the standard FND_API return status, message count, and message data. It validates compatibility using FND_API.Compatible_API_Call and raises FND_API.G_EXC_UNEXPECTED_ERROR on failure. Its role is to initiate the workflow process that fires the status-change notifications.
SELECT_NOTICE - Retrieves the notification content or definition used within the workflow, determining which notice template or message applies to the delinquency status change.
SELECT_RESOURCE_INFO - Gathers resource (owner and manager) information, resolving the owner and manager identifiers and names needed to address the notification.
SEND_NOTIFICATION - Performs the actual dispatch of the workflow notification to the identified owner and manager recipients.

Supporting internal routines include a forward-declared clear_table_values procedure and a PG_DEBUG variable derived from FND_LOG.G_CURRENT_RUNTIME_LEVEL (formerly FND_PROFILE IEX_DEBUG_LEVEL) for diagnostic logging.

Tables Accessed

The documented tables referenced via APPS synonyms are:

IEX_DEL_WF_S - The delinquency workflow staging table, holding records that drive the workflow launch and track delinquency status transitions associated with notifications.
DUAL - The standard Oracle single-row utility table, used for scalar evaluations or lookups.
PLITBLM - The PL/SQL index-by-table (associative array) mapping used for message/log handling within the API framework.

Usage Notes

START_WORKFLOW is the documented public entry point and is the object surfaced when searching for "start_workflow." It is typically invoked when a delinquency transitions to a closed or Current state, so that workflow can notify the delinquency owner and their manager. Standard FND_API conventions apply: callers pass p_api_version, optionally request initialization and commit, supply the delinquency ID collection, and inspect x_return_status, x_msg_count, and x_msg_data for outcome handling. Because the package is classified as a Public API owned by APPS, it is appropriate for invocation from other IEX packages, concurrent programs, or custom code that must trigger delinquency status notifications in Oracle EBS 12.1.1 or 12.2.2.

PACKAGE BODY: APPS.IEX_WF_DEL_CUR_STATUS_NOTE_PUB 12.2.2
PACKAGE BODY: APPS.IEX_WF_DEL_CUR_STATUS_NOTE_PUB 12.1.1
PACKAGE BODY: APPS.IEX_CASE_INFO_PUB 12.2.2
PACKAGE BODY: APPS.IEX_CASE_OWNER_PUB 12.2.2
PACKAGE BODY: APPS.IEX_CASE_OWNER_PUB 12.1.1
PACKAGE BODY: APPS.IEX_CASE_INFO_PUB 12.1.1
PACKAGE BODY: APPS.IEX_CASE_UTL_PUB 12.2.2
PACKAGE BODY: APPS.IEX_CASE_UTL_PUB 12.1.1
PACKAGE BODY: APPS.IEX_SCORE_CASE_PVT 12.1.1
PACKAGE BODY: APPS.IEX_STRATEGY_WF 12.1.1
PACKAGE BODY: APPS.IEX_SCORE_CASE_PVT 12.2.2
PACKAGE BODY: APPS.IEX_STRY_UTL_PUB 12.1.1
PACKAGE BODY: APPS.IEX_STRATEGY_WF 12.2.2
PACKAGE BODY: APPS.IEX_DELINQUENCY_PUB 12.2.2
PACKAGE BODY: APPS.IEX_STRY_UTL_PUB 12.2.2
PACKAGE BODY: APPS.IEX_DELINQUENCY_PUB 12.1.1
PACKAGE BODY: APPS.AR_CC_ERROR_MAPPINGS_PKG 12.1.1
PACKAGE BODY: APPS.ARP_DISTRIBUTIONS_PKG 12.2.2
PACKAGE BODY: APPS.ARP_DISTRIBUTIONS_PKG 12.1.1
PACKAGE BODY: APPS.AR_MRC_ENGINE3 12.2.2
PACKAGE BODY: APPS.IEX_STRY_API_PUB 12.1.1
PACKAGE BODY: APPS.AR_CC_ERROR_MAPPINGS_PKG 12.2.2
PACKAGE BODY: APPS.ARP_CR_HISTORY_PKG 12.2.2
PACKAGE BODY: APPS.ARP_CR_HISTORY_PKG 12.1.1
PACKAGE BODY: APPS.AR_MRC_ENGINE3 12.1.1
PACKAGE BODY: APPS.IEX_STRY_CHECKLIST_PUB 12.2.2
PACKAGE BODY: APPS.IEX_SEND_FFM_PVT 12.1.1
PACKAGE BODY: APPS.IEX_DISPUTE_PVT 12.2.2
PACKAGE BODY: APPS.IEX_DISPUTE_PVT 12.1.1
PACKAGE BODY: APPS.IEX_STRATEGY_WORK_PUB 12.1.1
PACKAGE BODY: APPS.IEX_STRY_CHECKLIST_PUB 12.1.1
PACKAGE BODY: APPS.IEX_STRY_API_PUB 12.2.2
PACKAGE BODY: APPS.IEX_SEND_FFM_PVT 12.2.2
PACKAGE BODY: APPS.AR_BILLS_MAINTAIN_VAL_PVT 12.1.1
PACKAGE BODY: APPS.AR_BILLS_MAINTAIN_VAL_PVT 12.2.2
PACKAGE BODY: APPS.AR_BILLS_CREATION_VAL_PVT 12.2.2
PACKAGE BODY: APPS.ARP_MISC_CASH_DIST_PKG 12.2.2
PACKAGE BODY: APPS.IEX_PROMISES_PUB 12.2.2
PACKAGE BODY: APPS.AR_BILLS_CREATION_LIB_PVT 12.1.1
PACKAGE BODY: APPS.AR_BILLS_CREATION_VAL_PVT 12.1.1
PACKAGE BODY: APPS.IEX_PROMISES_PUB 12.1.1
PACKAGE BODY: APPS.ARP_MISC_CASH_DIST_PKG 12.1.1
PACKAGE BODY: APPS.AR_BILLS_CREATION_LIB_PVT 12.2.2
PACKAGE BODY: APPS.ARP_RUN 12.1.1
PACKAGE BODY: APPS.IEX_PAYMENTS_PUB 12.1.1
PACKAGE BODY: APPS.AR_BR_CANCEL_UNPAID_API_PUB 12.2.2
PACKAGE BODY: APPS.AR_BR_CANCEL_UNPAID_API_PUB 12.1.1
PACKAGE BODY: APPS.IEX_AGING_BUCKETS_PKG 12.2.2
PACKAGE BODY: APPS.IEX_STRATEGY_WORK_PUB 12.2.2
PACKAGE BODY: APPS.IEX_CASES_PVT 12.2.2