Search Results validate_ship_to_org

Overview

APPS.PO_SERVICES_PVT is a private (PVT) PL/SQL package body within the Oracle E-Business Suite Purchasing module. Its header comment block identifies it internally as POXVSVCB.pls, confirming its association with the "Services FPJ" (Fixed Price Jobs) feature set introduced for services procurement processing. The package encapsulates business validation and attribute-retrieval logic for service-oriented purchasing documents, including purchase orders, blanket agreements, and requisitions that reference job, labor, and expense constructs.

The package is classified as a private API, meaning it is not intended as a public integration interface. Instead, it is consumed internally by other Purchasing packages and forms. The metadata notes that PO_SERVICES_PVT is referenced by seven other packages, underscoring its role as a shared utility layer for service-line validation across the Purchasing schema.

Key Procedures and Functions

ALLOW_PRICE_OVERRIDE — retrieves the Allow Price Override flag for a given blanket purchase line and returns a BOOLEAN indicating whether price override is permitted. This is the only routine for which full source is shown in the documentation excerpt.

GET_AP_COMPATIBILITY_FLAG — returns the Accounts Payable compatibility indicator, used to determine whether downstream Payables processing supports the service line configuration.

GET_CONTRACTOR_STATUS — retrieves the contractor status associated with a service procurement context.

GET_EXPENSE_LINE / IS_EXPENSE_LINE — a paired retrieval and predicate set. IS_EXPENSE_LINE evaluates whether a line qualifies as an expense-based service line; GET_EXPENSE_LINE returns the corresponding expense line structure.

GET_JOB_LONG_DESCRIPTION / GET_JOB_NAME — return descriptive job attributes for a given job identifier, resolving human-readable values from the job definition tables.

GET_LABOR_REQ_LINE — returns the labor requisition line associated with a service line, supporting linkage between requisition and order documents for labor-based services.

IS_RATE_BASED_LINE — predicate that determines whether a service line is rate-based, which affects pricing and matching logic.

VALIDATE_SHIP_TO_ORG — the routine implied by the search term "validate_ship_to_org." It performs validation of the ship-to organization assigned to a service document or line. This validation typically confirms that the organization is a valid, enabled inventory or receiving organization in the operating context. Detailed parameter documentation is not present in the supplied metadata.

GET_PO_AMOUNTS — returns monetary amounts (such as line or shipment totals) for a purchase order.

CHECK_PO_HAS_SVC_LINE_WITH_REQ — predicate that determines whether a purchase order contains at least one service line linked to a requisition.

IS_FPS_PO_LINE_WITH_REQ / IS_FPS_PO_SHIPMENT_WITH_REQ — predicates that identify Fixed Price Services (FPS) purchase order lines and shipments, respectively, that carry an associated requisition reference.

Tables Accessed

The package reads and, in some paths, writes to the following documented tables via APPS synonyms:

• PO_LINES_ALL — primary source of purchase order and blanket line attributes, including the allow_price_override_flag read by ALLOW_PRICE_OVERRIDE.
• PO_LINE_LOCATIONS_ALL — shipment-level attributes, including ship-to organization, used in shipment validation and the FPS shipment predicate.
• PO_DISTRIBUTIONS_ALL — accounting distribution data supporting amount and expense-line logic.
• PO_REQUISITION_LINES_ALL — requisition lines, used by GET_LABOR_REQ_LINE and the requisition-linkage predicates.
• MTL_PARAMETERS — inventory organization parameters, consulted when validating ship-to organizations and their receiving/inventory status.
• HR_ALL_ORGANIZATION_UNITS — organization definitions, supporting resolve-and-validate operations against organizational identifiers.
• PER_JOBS — job definitions, providing the source for GET_JOB_NAME and GET_JOB_LONG_DESCRIPTION.
• FND_PRODUCT_INSTALLATIONS — product installation status, used for compatibility gating (for example, the AP compatibility flag).

The pattern of access is predominantly read-only lookup and validation; the package does not appear to be a primary DML driver for purchasing transactions.

Usage Notes

Because PO_SERVICES_PVT is a PVT-classified package, it is not a sanctioned public API for external or custom integration. It is invoked internally by Purchasing forms, concurrent programs, and other Purchasing packages—particularly those handling service procurement, blanket agreements, and requisition-to-order conversion for fixed price services. The instrumentation at the top of the body (PO_DEBUG.is_debug_stmt_on and is_debug_unexp_on, plus the g_module_prefix constant used with FND logging) indicates that the package emits debug and unexpected-error diagnostics when PO_DEBUG tracing is enabled, which is useful when troubleshooting service-line validation failures.

Custom code should query PO_LINES_ALL and PO_LINE_LOCATIONS_ALL directly, or use the public Purchasing APIs, rather than calling these private routines. The presence of VALIDATE_SHIP_TO_ORG in the ETRM catalog reflects its role in diagnosing ship-to organization validation errors encountered during service procurement setup.