Search Results validate_bids




Overview
Explore in AI Chat

Overview

The APPS.PON_VALIDATE_ITEM_PRICES_INT package is a public Oracle Purchasing (PON) database package responsible for validating item price data that is loaded into Oracle E-Business Suite through the Purchasing interface tables. Its primary business purpose is to verify the integrity and business validity of item price, bid, and award information before that data is processed by the downstream Purchasing extraction and submission programs. The suffix _INT indicates that the package participates in the interface load path, where external or staged data is checked against master item, category, unit of measure, and purchasing setup before it is committed.

In the Oracle EBS 12.1.1 and 12.2.2 releases, this package is a component of the Sourcing and Purchasing module and works in conjunction with the award processing logic in PON_AWARD_PKG. The package header declares global constants g_xml_upload_mode and g_txt_upload_mode, which are aliased to corresponding constants in PON_AWARD_PKG. These constants allow the validation routines to behave differently depending on whether the incoming data originates from an XML upload or a delimited text upload.

The package is declared AUTHID CURRENT_USER, meaning its SQL statements execute with the privileges of the calling user rather than the definer. The header carries the revision marker PONVAIPS.pls 120.2.12020000.2, confirming its presence across both the 12.1.1 and 12.2.2 code lines.

Key Procedures and Functions

The documented interface exposes three procedures:

  • validate_bids — The procedure matching the user's search term. It accepts a source indicator, a batch identifier, and an optional trading partner identifier. It validates bid-related item price data associated with a specific interface batch, providing a direct entry point for bid validation during sourcing or award upload processing.
  • validate — The general-purpose validation entry point. It receives the source, batch, document type, user, trading partner, contact, language, contract type, global flag, and organization context. This procedure performs the full validation pass for an interface batch, applying the correct language and organization context when checking items, categories, and units of measure.
  • validateAwardBidXML — A specialized procedure that validates award and bid data arriving as XML. It returns a status and a return code through OUT parameters, allowing the calling program to detect validation failures programmatically. Its inclusion confirms that the package supports the XML-based award upload path in addition to text-based loads.

Tables Accessed

The package queries a broad set of master and setup tables through APPS synonyms. Item validation relies on MTL_SYSTEM_ITEMS_KFV and MTL_SYSTEM_ITEMS_TL for item identity and descriptions, and on MTL_UNITS_OF_MEASURE_TL for unit-of-measure verification. Category validation uses MTL_CATEGORIES, MTL_CATEGORIES_KFV, MTL_CATEGORY_SETS, MTL_CATEGORY_SET_VALID_CATS, MTL_DEFAULT_CATEGORY_SETS, and MTL_ITEM_CATEGORIES to confirm that assigned categories are valid within the appropriate category set.

Organizational and user context is derived from HR_ALL_ORGANIZATION_UNITS, FND_USER, and FINANCIALS_SYSTEM_PARAMS_ALL. Lookup validation uses FND_LOOKUP_VALUES. For award and project-related data, the package references GMS_AWARDS_ALL and PA_PROJECTS_ALL, supporting integration between Purchasing and Grants/Projects. The package is referenced by one other package, indicating it is called from within the broader Purchasing interface framework rather than invoked directly by end users.

Usage Notes

PON_VALIDATE_ITEM_PRICES_INT is not typically invoked manually from a form. It is called by the Purchasing interface and award processing programs when item price or bid data is staged for validation. The validate_bids procedure is the relevant entry point when validating bid uploads, and it should be supplied with the source mode, the target batch identifier, and the trading partner where applicable.

Because the package is AUTHID CURRENT_USER, custom code that calls it must run under a schema with the required object privileges. Customers extending the interface should call the documented procedures rather than duplicate validation logic, and should check the return status and code from validateAwardBidXML before proceeding to submission. In 12.1.1 and 12.2.2, the reference implementation remains PONVAIPS.pls 120.2.12020000.2, and behavior is governed by the XML and text upload mode constants inherited from PON_AWARD_PKG.