Search Results ams_debug_medium_on




Overview
Explore in AI Chat

Overview

AMS_ADI_OBJECTS_EXPORT_PVT is a private PL/SQL package within the Oracle E-Business Suite Applications (APPS) schema, classified under the PVT (private) API convention. It belongs to the Oracle Marketing (AMS) product family and specifically supports the deployment/export infrastructure for Oracle Marketing objects, as reflected in the ADI (Application Data Integration / object deployment) naming component. The package serves as the backend engine that assembles a batch of schedules selected for export into the AMS_ADI_OBJECTS_EXPORT staging table, so that downstream deployment or migration processes can package and transmit those marketing objects between environments.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the definer. It exposes a single public procedure and relies on FND logging and message infrastructure for diagnostics. The header identifies the source file as amsvadxs.pls (version 120.0), indicating a long-standing, stable component of the Marketing deployment framework.

Key Procedures and Functions

  • INSERT_EXPORT_SCHEDULES — The sole documented procedure. Its purpose, stated in the package header comments, is to insert schedules into the AMS_ADI_OBJECTS_EXPORT table. It accepts a collection of schedule identifiers, an optional commit flag (defaulting to FND_API.G_FALSE), and returns an export batch identifier through an OUT NOCOPY parameter. This design follows standard EBS API patterns, allowing the caller to control transaction boundaries and to receive a batch handle that ties the inserted rows together for subsequent export processing.

No other procedures or functions are exposed in the documented package specification.

Tables Accessed

Based on the documented synonym references, the package interacts with the following objects:

  • AMS_ADI_OBJECTS_EXPORT (referenced in the procedure purpose) — the primary staging table into which selected schedules are written, forming the export batch.
  • AMS_ADI_OBJECTS_EXPORT_LIST and AMS_ADI_OBJECTS_EXPORT_LIST_S — the export list definition and its sequence/intersection table, used to identify and validate which objects belong to a given export grouping.
  • DUAL — the standard single-row utility table, typically for sequencing or constant selection.
  • PLITBLM — the generic PL/SQL index-by table used by FND logging/message utilities, reflecting the package's integration with the FND diagnostics framework.

Usage Notes

This package is a private (PVT) API and is not intended for direct invocation by external integrators. It is invoked internally by the Oracle Marketing object deployment/export subsystem, commonly triggered through concurrent programs or forms that initiate the export of schedule-related marketing objects between EBS instances. Because it is private, dependent application code within the AMS deployment stack is the expected caller rather than customer-written code; it is not referenced by any other documented public packages.

A notable diagnostic feature is the constant declarations for debug levels, including AMS_DEBUG_MEDIUM_ON, which are evaluated at package load time via FND_MSG_PUB.CHECK_MSG_LEVEL. These constants — AMS_DEBUG_HIGH_ON, AMS_DEBUG_LOW_ON, and AMS_DEBUG_MEDIUM_ON — allow the package to emit trace output at appropriate verbosity, which explains why users troubleshooting export issues search for terms such as ams_debug_medium_on. Enabling the corresponding FND message level allows administrators to capture detailed logging during export operations. Log output is routed through FND_LOG at LEVEL_STATEMENT, as defined by g_log_level. The package should be treated as internal; any modification or direct call risks undermining the integrity of the Marketing deployment framework.