Search Results ams_act_contact_points_s

Overview

The APPS.AMS_CNT_POINT_PVT package body is a private Oracle EBS PL/SQL API that supports the Oracle Marketing (AMS) Contact Point entity. A contact point represents a specific communication endpoint — such as an email address, phone number, fax number, or web collaboration script — associated with an activity, customer, or contact. This package encapsulates the business logic required to create, maintain, and validate those contact point records in the AMS_ACT_CONTACT_POINTS tables.

The package is classified as PVT (private), meaning it is not exposed as a public API and is intended for internal consumption by the AMS schema and other supporting packages. The header comments reference a history of bug fixes, including error message name truncation, foreign key validation corrections for check_conact_point_fk_rec, and a revision expanding contact_point_value from 30 to 256 characters. The ams_debug_high_on and ams_debug_low_on constants referenced in the body are standard AMS debugging flags derived from FND_MSG_PUB.CHECK_MSG_LEVEL, used to control diagnostic logging.

Key Procedures and Functions

The package exposes seven documented procedures and functions:

• CREATE_CNT_POINT — Inserts a new contact point record based on the incoming cnt_point_rec_type record and returns the generated contact_point_id.
• UPDATE_CNT_POINT — Modifies an existing contact point record, applying the supplied record against the identified row.
• DELETE_CNT_POINT — Removes a contact point record from the entity.
• LOCK_CNT_POINT — Obtains a row-level lock on a contact point to support concurrent-safe updates.
• VALIDATE_CNT_POINT — Performs full validation of a contact point record prior to create or update, enforcing business rules such as value format and foreign key integrity (notably for inbound/outbound scripts).
• CHECK_CNT_POINT_ITEMS — Verifies referenced lookup items and dependent attributes for the contact point.
• VALIDATE_CNT_POINT_REC — Validates the individual record structure and its field-level consistency.

These routines follow the standard AMS private API conventions and rely on FND_API and FND_MSG_PUB for return status and message handling.

Tables Accessed

The package operates against the following tables via APPS synonyms:

• AMS_ACT_CONTACT_POINTS — The primary transactional table storing contact point records (email, phone, fax, script, etc.) linked to activities.
• AMS_ACT_CONTACT_POINTS_S — The corresponding DFF/translation/audit shadow table, accessed to maintain synchronized secondary attributes or translated values.
• DUAL — Used for simple singleton SQL expressions, lookups, and sequence or status checks.

Usage Notes

AMS_CNT_POINT_PVT is referenced by three other packages within the AMS schema, indicating it serves as a foundational internal layer for higher-level Marketing APIs that manage activity contact points. Because it is a private package, it should not be invoked directly from custom code or forms without careful consideration of the supported public API surface. It is typically called during activity setup and maintenance flows, WebADI collaboration script usage, and inbound/outbound script validation. The ams_debug_high_on flag, when enabled through message level settings, activates verbose diagnostic output for troubleshooting contact point creation or validation failures in Oracle EBS 12.1.1 and 12.2.2 environments.