Search Results validate_fnd_lookup

Overview

APPS.HZ_RELATIONSHIP_TYPE_V2PUB is a public PL/SQL API package in Oracle E-Business Suite that manages relationship type definitions within the Trading Community Architecture (TCA) and Receivables foundation. Relationship types define the permissible associations between parties in the HZ (Trading Community) model, such as "Customer Of," "Employee Of," or "Contact Of." The package encapsulates the business rules that govern the creation and maintenance of these relationship definitions, insulating callers from the underlying table structures and validation logic. The header comment (ARH2RTSB.pls) indicates the package is maintained under the AR (Receivables) module file naming convention, consistent with its dependency on the AR_LOOKUPS view.

Key Procedures and Functions

• CREATE_RELATIONSHIP_TYPE — The public entry point for defining a new relationship type. It performs validation and delegates to the private helper do_create_relationship_type, which populates the relationship type record and returns a newly generated relationship type identifier along with a return status.
• UPDATE_RELATIONSHIP_TYPE — The public entry point for modifying an existing relationship type. It delegates to the private helper do_update_relationship_type, which applies changes to the relationship type record and manages the object version number used for optimistic concurrency control, returning a status code.
• IN_INSTANCE_SETS — Determines whether the object is associated with instance sets, supporting the TCA instance-set framework that partitions and shares reference data across operating units.

A private helper, validate_fnd_lookup, is also present in the package body. Although not part of the public interface, it is relevant when the user searches for "validate_fnd_lookup." This function checks whether a supplied lookup type and code or meaning combination exists in AR_LOOKUPS; it returns 'Y' when a match is found and 'N' otherwise, treating NULL or FND_API.G_MISS_CHAR column values as absent. Bug references (3831950 and 4218352) document its addition and the extension of validation to lookup meanings.

Tables Accessed

The package references several tables through APPS synonyms. HZ_RELATIONSHIP_TYPES is the primary target for insert and update operations performed by the create and update procedures. HZ_PARTIES is referenced to validate party context associated with relationship definitions. FND_OBJECTS and FND_OBJECT_INSTANCE_SETS support the instance-set determination logic, allowing relationship type metadata to be shared across operating units. The private lookup validation function queries AR_LOOKUPS to confirm that lookup codes and meanings are valid before they are used within a relationship type.

Usage Notes

HZ_RELATIONSHIP_TYPE_V2PUB is a V2-style public API following standard EBS conventions: it returns a return status and message list and participates in the TCA messaging framework. It is typically invoked from TCA maintenance forms, concurrent programs that seed or migrate relationship type reference data, and custom integration code that establishes party relationships. Because it is classified as a PUBLIC API, direct calls are supported, but callers should respect the concurrency control provided by the object version number and standard API error handling. The package is referenced by five other packages within the application, indicating that it functions as a foundational utility in the relationship management layer. Developers integrating with this API should supply meaningful values for lookup-driven attributes, as the internal validate_fnd_lookup logic enforces that both codes and their meanings resolve to valid AR lookups.