Search Results ams_importclient_pvt




Overview
Explore in AI Chat

Overview

APPS.AMS_IMPORTCLIENT_PVT is a private PL/SQL package body within the Oracle E-Business Suite Marketing (AMS) module. It supports the client-side import of marketing list data and lead data into Oracle Marketing and Oracle Sales foundations. The package acts as the processing engine behind the AMS list import feature, validating, staging, and transferring incoming source records into the standard interface tables that downstream concurrent programs consume. As an API classification of "PVT" (private), the package is not intended for direct invocation by external customizations; it is called internally by the AMS_IMPORTCLIENT package and related import infrastructure. Its responsibility spans reading source staging rows, mapping them against lead and list mapping views, applying user statuses, and recording any import errors encountered during processing. The package also depends on FND_API, FND_MSG_PUB, FND_MESSAGE, and FND_GLOBAL, indicating that it conforms to the standard Oracle EBS API error-handling and message-stack conventions, including message propagation through the FND message dictionary. Because it is marked VALID and is referenced by two other packages, it forms an active component of the AMS import pipeline in both 12.1.1 and 12.2.2.

Key Procedures and Functions

The package body documents five procedures and functions:

  • WRITE_MESSAGE — Writes diagnostic or error messages to the FND message stack and/or the import error tables, providing the feedback mechanism used throughout the import process.
  • MARK_INSERT_LEAD_ERRORS — Identifies and flags records that failed validation or insertion during lead processing, recording them in the lead import error structures.
  • LOAD_LEAD_DATA_TO_INTERFACE — Moves staged lead records from the AMS import source lines into the standard import interface tables for downstream sales/marketing consumption.
  • INSERT_LEAD_DATA — Performs the actual insertion of lead data, applying mappings from the lead mapping view and user statuses.
  • INSERT_LIST_DATA — Inserts marketing list data, including list headers and source fields, into the appropriate AMS import tables.

Specific parameter lists are not exposed in the metadata and are therefore not reproduced here.

Tables Accessed

The package reads and writes several AMS and AS synonyms: AMS_IMP_LIST_HEADERS_ALL (list header import staging), AMS_IMP_SOURCE_LINES (source import rows), AMS_LIST_IMPORT_ERRORS and its sequence AMS_LIST_IMPORT_ERRORS_S (error logging for list imports), AMS_LIST_SRC_FIELDS (list source field definitions), and the lead/list mapping views AMS_LEAD_MAPPING_V, AMS_USER_STATUSES_VL, AS_IMPORT_INTERFACE, AS_IMPORT_INTERFACE_S, and AS_LEAD_IMPORT_ERRORS. DUAL and ALL_SEQUENCES support sequence lookups, while DBMS_SQL and PLITBLM support dynamic SQL and index-by table operations. The user search term ams_list_import_errors_s corresponds to the sequence used to populate AMS_LIST_IMPORT_ERRORS, confirming that list-import error capture is a core concern of this package.

Usage Notes

AMS_IMPORTCLIENT_PVT is invoked indirectly through the AMS import client UI and associated concurrent programs rather than called directly from forms or custom code. It is not referenced by any database object per the metadata, and it depends on FND_MSG_PUB, so callers should anticipate FND message-stack handling. When troubleshooting list or lead import errors, query AMS_LIST_IMPORT_ERRORS (populated via AMS_LIST_IMPORT_ERRORS_S) for diagnostics produced by WRITE_MESSAGE and MARK_INSERT_LEAD_ERRORS.