Search Results validate_award_data




Overview
Explore in AI Chat

Overview

PO_GMS_INTEGRATION_PVT is a private (PVT) PL/SQL package in the APPS schema that provides the integration bridge between Oracle Purchasing and Oracle Grants Management (GMS) within Oracle E-Business Suite 12.1.1 and 12.2.2. Its central responsibility is to keep award distribution lines synchronized with the distributions generated by Purchasing and Requisitioning activities. When a PO or requisition distribution is created from CopyDoc, the Autocreate process, the PO Release process, or a Change PO action, and the parent distribution references a Grants award, this package invokes the Grants APIs to generate the corresponding award distribution lines in GMS_AWARD_DISTRIBUTIONS.

The package was originally shipped under the header identifier POXVGMSB.pls, with the module base derived through PO_LOG.get_package_base. Logging is wired through PO_LOG subprogram identifiers, and debug output is governed by the AFLOG_ENABLED profile option, reflecting standard EBS diagnostic conventions. Because it carries the PVT classification, it is an internal implementation package: it is designed to be called by other Purchasing packages rather than directly by end users or form-level code.

Key Procedures and Functions

  • MAINTAIN_ADL — The principal driver routine. "ADL" denotes Award Distribution Lines in Grants. It evaluates whether the parent Purchasing distribution references an award and, when it does, calls the Grants API to create the new award distribution lines. Its caller parameter distinguishes the invoking business flow (AUTOCREATE, CHANGEPO, COPYDOC, CREATE_RELEASE), and it returns a standard EBS return status plus message count and message data. It also passes a GMS PO interface object of type gms_po_interface_type, which carries the distribution identifier among its attributes.
  • VALIDATE_AWARD_DATA — The validation routine associated with the search term "validate_award_data." It verifies that award-related data supplied by Purchasing is valid and usable before any downstream award distribution processing is attempted, allowing the integration to fail cleanly and report messages through the standard API message list.
  • MAINTAIN_PO_ADL — The Purchasing-side counterpart that maintains the PO award distribution lines, coordinating the interface data between the Purchasing distribution record and the Grants representation.
  • GET_AWARD_ID — Retrieves the award identifier associated with the distribution or interface context so that subsequent GMS API calls can target the correct award.
  • GET_NUMBER_FROM_AWARD_SET_ID — Extracts the numeric award reference from an award set identifier, supporting the key translation required between Purchasing and Grants numbering schemes.
  • IS_GMS_ENABLED and GET_GMS_ENABLED_FLAG — Determine whether Grants Management integration is enabled for the current operating context, providing the gating check that short-circuits all further processing when GMS is not installed or not enabled.
  • IS_AWARD_REQUIRED_FOR_PROJECT — Determines whether an award is mandatory for a given project, which influences whether distribution records must participate in award distribution line creation.

Tables Accessed

  • GMS_AWARDS_ALL — Read to resolve and verify award information, and, together with GMS_AWARD_DISTRIBUTIONS referenced in the package comments, to satisfy the Grants-side data requirements of the integration.
  • PO_DISTRIBUTIONS_ALL — The Purchasing distribution records that trigger the integration; read to identify distributions that reference an award and to obtain the distribution identifier passed into the GMS interface object.
  • PLITBLM — The standard EBS message-list table used to accumulate API messages that are returned to the caller through x_msg_count and x_msg_data.

Usage Notes

PO_GMS_INTEGRATION_PVT is invoked indirectly, not by end users. It is referenced by seven other packages, and its procedures fire during Purchasing business flows, including CopyDoc, Autocreate, PO Release, and Change PO, whenever distributions referencing awards are created. The caller parameter identifies which of these flows initiated the call. Because the package is classified PVT, customizations should not call it directly; instead, the invitation of the standard Purchasing flows will exercise it. Error handling follows the standard EBS API contract, returning S, E, or U status values with messages multiplexed through the message list, so callers should interrogate x_msg_count and use the standard message retrieval utilities rather than assuming a single message buffer. The gms_po_interface_type SQL object passes distribution context into the Grants API. Customers diagnosing integration failures related to award distribution line creation should enable FND debug logging via the AFLOG_ENABLED profile and review PO_LOG output for the POXVGMSB module base.