Search Results val_frtbill_mthd

Overview

GML_VALIDATE_PO is an Oracle EBS validation library owned by APPS and classified as an OTHER API rather than a public interface. It belongs to the GML (Process Manufacturing / Oracle Quality and laboratory) application family, and its name indicates it exists to validate the reference data that surrounds purchase order and receiving transactions in a process manufacturing organization. The package is declared AUTHID CURRENT_USER, so it executes with the privileges of the calling session and relies on APPS synonyms to reach the underlying tables.

The central design pattern of the package is the boolean validator: each val_* function accepts a single code value and returns TRUE or FALSE depending on whether that value exists in the corresponding master table. This allows calling forms or APIs to reject invalid input before a transaction is written. A smaller set of procedures supplies derived values, chiefly currency and GL source information, for transaction processing.

Key Procedures and Functions

The package exposes fifteen documented programs. The validation functions are:

• VAL_ORGN_CODE — confirms that a plant or organization code exists in the organization master.
• VAL_DOC_ASSIGN — verifies that a document sequence assignment exists for the given organization.
• VAL_WAREHOUSE — validates a warehouse code in the context of a specific organization, since warehouses are organization-scoped.
• VAL_VENDOR — checks a vendor site against a company code.
• VAL_ITEM — confirms an item number exists in the item master.
• VAL_CURRENCY — the function matching the user's search, val_currency accepts a currency code and returns TRUE if it is a defined currency in the currency master. It performs existence checking only; base currency resolution is handled separately by GET_BASE_CURRENCY.
• VAL_AQUI_COST_CODE — validates an acquisition cost code used on purchase documents.
• VAL_UOM — verifies a unit of measure code.
• VAL_SHIPPER_CODE — validates a shipper or carrier code.
• VAL_FRTBILL_MTHD — checks the freight billing method code.
• VAL_TERMS_CODE — validates payment terms.
• VAL_QC_GRADE_WANTED — confirms a quality grade exists for quality-driven receipt requirements.

Three procedures complete the package. GET_GL_SOURCE returns the transaction source type used when generating general ledger entries. GET_BASE_CURRENCY returns the base currency code for a given organization, drawing on the organization master and GL policy. GET_EXCHANGE_RATE returns the exchange rate, multiplication/division sign, and rate date for a from-currency and to-currency pair, providing the conversion factors needed to value a transaction in the functional currency.

Tables Accessed

The package reads fifteen master tables through APPS synonyms. Currency and financial reference data come from GL_CURR_MST, GL_PLCY_MST, GL_SRCE_MST, and GL_XCHG_RTE. Organization and setup data come from SY_ORGN_MST, SY_DOCS_SEQ, and SY_UOMS_MST. Inventory and item validation use IC_ITEM_MST and IC_WHSE_MST. Purchasing-related checks draw on PO_COST_MST and PO_VEND_MST. Transportation and trade data come from OP_SHIP_MST, OP_FRGT_MTH, and OP_TERM_MST, while quality grade validation uses QC_GRAD_MST. Lookups are read-only; the package does not write to these tables.

Usage Notes

GML_VALIDATE_PO is an internal utility, not a published API. It is referenced by two other packages, which is consistent with its role as a shared validation layer for process manufacturing purchasing and receiving flows. Typical invocation occurs from Oracle Forms during field-level validation, from concurrent programs that pre-validate interface data, or from custom PL/SQL that must confirm reference data before inserting transactions. Because the functions return BOOLEAN rather than an error code, callers are responsible for translating a FALSE result into an appropriate user-facing message. Values returned by GET_BASE_CURRENCY and GET_EXCHANGE_RATE should be treated as read-only reference data; caching within a session is advisable when validating many lines against the same currency pair.