Search Results check_pvdr_rcvr_control_exist




Overview

PA_CC_UTILS is a shared utility package in the Oracle Projects (PA) module of Oracle E-Business Suite. Its documented purpose is to provide common infrastructure for the Borrowed and Lent accounting and the Intercompany (IC) Billing processes. The package declares a set of global variables that carry session context through those processes: login, program application, program, request, and user identifiers, plus the primary set of books identifier, the provider organization identifier, collections of reporting set of books identifiers and reporting currency codes, and a debug mode flag. These globals allow callers to establish a consistent execution context and to emit diagnostic output during long-running project accounting operations. The package is owned by APPS and is classified as OTHER, indicating it is an internal utility rather than a public business API. It is referenced by 25 other packages, confirming its role as a low-level, widely reused dependency within the Projects code base.

Key Procedures and Functions

  • IS_RECEIVER_CONTROL_SETUP — Returns a numeric result indicating whether receiver control setup exists for a given provider organization and receiver organization pair. Used to determine whether intercompany control configuration is in place before processing.
  • CHECK_PVDR_RCVR_CONTROL_EXIST — Returns a numeric result indicating whether provider/receiver control records exist for a given project. Complements IS_RECEIVER_CONTROL_SETUP by validating at the project level.
  • LOG_MESSAGE — Writes a message using the current function name established by SET_CURR_FUNCTION. A write mode parameter controls output: mode 0 prints only in debug mode, while mode 1 always prints. This provides consistent diagnostic tracing across the IC and Borrowed/Lent processes.
  • SET_CURR_FUNCTION — Sets the current function name passed by the caller and records stack information. It is intended to be invoked at the beginning of each procedure so that subsequent LOG_MESSAGE calls are attributed to the correct routine.
  • RESET_CURR_FUNCTION — Resets the current function name and the associated stack information. It takes no arguments and is intended to be called at the end of each procedure to unwind the trace context.

Tables Accessed

  • PA_IMPLEMENTATIONS_ALL — Supplies the provider organization identifier stored in g_prvdr_org_id, reflecting the implementation's organization context.
  • PA_CC_ORG_RELATIONSHIPS — Backs the organization relationship checks performed by the receiver/provider control functions.
  • PLITBLM — A standard Oracle tooling table used for message and diagnostic handling, consistent with the LOG_MESSAGE routine.

Usage Notes

PA_CC_UTILS is an internal support package. It is not exposed as a user-facing API but is invoked by the various Projects packages that implement Borrowed and Lent processing and Intercompany Billing. Custom code that calls these routines should follow the same conventions: invoke SET_CURR_FUNCTION at the start of a procedure, issue LOG_MESSAGE calls for tracing, and call RESET_CURR_FUNCTION on exit. Because it is referenced by 25 other packages and carries global state, callers should avoid concurrent reliance on its globals within a single session and should treat the package as a tracing and control-check utility rather than a source of business validation logic.