Search Results wsh_util_validate

Overview

WSH_UTIL_VALIDATE is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Shipping Execution (WSH) product family and serves as the central reusable validation library for the Oracle Shipping module. Its business purpose is to enforce data integrity and business-rule conformance before shipping data is written to the database or before shipping transactions are processed further. Rather than embedding validation logic redundantly in forms, concurrent programs, and public APIs, Oracle consolidates these checks in a single package so that consistent error messages and lookup-based rules are applied uniformly across the Order Management, Shipping, and Warehouse Management flows.

The package body is documented as VALID and carries an API classification of OTHER in the ETRM 12.2.2 repository. It exposes 50 documented procedures and functions, and it is referenced by 43 other packages, confirming its role as a low-level utility layer rather than an application entry point.

Key Procedures and Functions

The documented validation routines cover the principal shipping attributes:

VALIDATE_ORG — confirms that an organization identifier corresponds to a valid shipping/inventory organization in MTL_PARAMETERS.
VALIDATE_LOCATION — verifies address and location identifiers against HR_LOCATIONS_ALL, HR_LOCATIONS_ALL_TL, and WSH_LOCATIONS.
VALIDATE_LOOKUP — checks a supplied value against the lookup types maintained in the FND and OE/AR lookup views.
VALIDATE_CUSTOMER and VALIDATE_CONTACT — validate ship-to/sold-to parties, account roles, party sites, and site uses in the HZ tables.
VALIDATE_ITEM and VALIDATE_QUANTITY — validate inventory items, customer items, and numeric quantities, while VALIDATE_NEGATIVE rejects negative values.
VALIDATE_UOM and VALIDATE_CURRENCY — confirm units of measure and currency codes against MTL_UNITS_OF_MEASURE and FND_CURRENCIES_VL.
VALIDATE_USER — validates an application user against FND_USER.
VALIDATE_SHIP_METHOD, VALIDATE_FREIGHT_TERMS, and VALIDATE_FOB — validate carrier, service, and trade-term attributes.
VALIDATE_FLEXFIELDS — invokes the FND Flexfield key validation APIs for descriptive and key flexfield segments.
VALIDATE_BOOLEAN, VALIDATE_RELEASED_STATUS, VALIDATE_DELIVERY_NAME, VALIDATE_REPORT_SET, and VALIDATE_LOADING_ORDER — handle flag values, delivery release status, delivery naming, report set configuration, and loading-order sequencing rules.

All routines follow the FND_API convention of returning a standard success/error flag and populating a message stack through FND_MESSAGE, allowing callers to surface translated error text.

Tables Accessed

The package reads and, where appropriate, references master and transactional shipping data through APPS synonyms. Documented tables include FND_USER, HR_LOCATIONS_ALL, HR_LOCATIONS_ALL_TL, HZ_CUST_ACCOUNTS, HZ_CUST_ACCOUNT_ROLES, HZ_PARTY_SITES, HZ_PARTY_SITE_USES, MTL_CUSTOMER_ITEMS, MTL_PARAMETERS, MTL_SYSTEM_ITEMS, MTL_UNITS_OF_MEASURE, WSH_CARRIERS, WSH_CARRIER_SERVICES, WSH_LOCATIONS, and WSH_NEW_DELIVERIES. Additional dependencies include WSH_TRIPS, WSH_TRIP_STOPS, WSH_PICKING_BATCHES, WSH_SHIPPING_PARAMETERS, WSH_ORG_CARRIER_SERVICES, and WSH_SHIP_CONFIRM_RULES, together with lookup views such as AR_LOOKUPS, OE_LOOKUPS, and FND_LOOKUP_VALUES_VL. These are predominantly read operations used to confirm existence, status, and enabled flags before downstream transactions proceed.

Usage Notes

WSH_UTIL_VALIDATE is not invoked directly by end users. It is called internally by Shipping forms, concurrent programs, and public APIs such as WSH_DELIVERY_PUB and WSH_TRIPS_PVT. Custom development that extends shipping functionality should call these routines rather than reimplementing validation logic, ensuring consistent error handling. Because the package body depends on FND_API, FND_FLEX_KEY_API, WSH_DEBUG_SV, and WSH_UTIL_CORE, recompilation must occur after related Oracle patches, and its VALID status should be monitored following upgrades.

PACKAGE BODY: APPS.WSH_UTIL_VALIDATE 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_UTIL_VALIDATE, status:VALID,
PACKAGE BODY: APPS.WSH_UTIL_VALIDATE 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_UTIL_VALIDATE, status:VALID,
SYNONYM: APPS.WSH_PICK_SEQUENCE_RULES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:WSH_PICK_SEQUENCE_RULES, status:VALID,
PACKAGE: APPS.WSH_UTIL_VALIDATE 12.1.1
owner:APPS, object_type:PACKAGE, object_name:WSH_UTIL_VALIDATE, status:VALID,
PACKAGE: APPS.WSH_UTIL_VALIDATE 12.2.2
owner:APPS, object_type:PACKAGE, object_name:WSH_UTIL_VALIDATE, status:VALID,
PACKAGE: APPS.WSH_MAP_LOCATION_REGION_PKG 12.1.1
owner:APPS, object_type:PACKAGE, object_name:WSH_MAP_LOCATION_REGION_PKG, status:VALID,
PACKAGE: APPS.WSH_MAP_LOCATION_REGION_PKG 12.2.2
owner:APPS, object_type:PACKAGE, object_name:WSH_MAP_LOCATION_REGION_PKG, status:VALID,
SYNONYM: APPS.WSH_REPORT_SETS 12.2.2
owner:APPS, object_type:SYNONYM, object_name:WSH_REPORT_SETS, status:VALID,
PACKAGE BODY: APPS.WSH_WSHRDPIK_XMLP_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_WSHRDPIK_XMLP_PKG, status:VALID,
PACKAGE BODY: APPS.WSH_WSHRDPIK_XMLP_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_WSHRDPIK_XMLP_PKG, status:VALID,
PACKAGE BODY: APPS.WSH_PICKING_BATCHES_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_PICKING_BATCHES_PUB, status:VALID,
PACKAGE BODY: APPS.WSH_TRIP_STOPS_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_TRIP_STOPS_PUB, status:VALID,
PACKAGE BODY: APPS.WSH_EXCEPTIONS_GRP 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_EXCEPTIONS_GRP, status:VALID,
SYNONYM: APPS.WSH_SHIP_CONFIRM_RULES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:WSH_SHIP_CONFIRM_RULES, status:VALID,
PACKAGE BODY: APPS.WSH_TRIP_CONSOLIDATION 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_TRIP_CONSOLIDATION, status:VALID,
PACKAGE BODY: APPS.WSH_CONTAINER_UTILITIES 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_CONTAINER_UTILITIES, status:VALID,
PACKAGE BODY: APPS.WSH_PICKING_BATCHES_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_PICKING_BATCHES_PUB, status:VALID,
SYNONYM: APPS.WSH_PICK_GROUPING_RULES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:WSH_PICK_GROUPING_RULES, status:VALID,
PACKAGE BODY: APPS.WSH_XC_UTIL 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_XC_UTIL, status:VALID,
SYNONYM: APPS.WSH_PICK_SEQUENCE_RULES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:WSH_PICK_SEQUENCE_RULES, status:VALID,
PACKAGE BODY: APPS.WSH_XC_UTIL 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_XC_UTIL, status:VALID,
PACKAGE BODY: APPS.WSH_DLVB_COMMON_ACTIONS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_DLVB_COMMON_ACTIONS, status:VALID,
PACKAGE BODY: APPS.WSH_DLVB_COMMON_ACTIONS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_DLVB_COMMON_ACTIONS, status:VALID,
SYNONYM: APPS.WSH_SHIP_CONFIRM_RULES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:WSH_SHIP_CONFIRM_RULES, status:VALID,
PACKAGE BODY: APPS.WSH_PICKING_BATCHES_GRP 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_PICKING_BATCHES_GRP, status:VALID,
PACKAGE BODY: APPS.WSH_DELIVERIES_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_DELIVERIES_PUB, status:VALID,
PACKAGE BODY: APPS.WSH_SUPPLIER_PARTY 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_SUPPLIER_PARTY, status:VALID,
PACKAGE BODY: APPS.WSH_CONTAINER_GRP 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_CONTAINER_GRP, status:VALID,
PACKAGE BODY: APPS.WSH_TRIP_CONSOLIDATION 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_TRIP_CONSOLIDATION, status:VALID,
SYNONYM: APPS.WSH_REPORT_SETS 12.1.1
owner:APPS, object_type:SYNONYM, object_name:WSH_REPORT_SETS, status:VALID,
PACKAGE BODY: APPS.WSH_CARRIERS_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_CARRIERS_PUB, status:VALID,
PACKAGE BODY: APPS.WSH_PARTY_MERGE 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_PARTY_MERGE, status:VALID,
PACKAGE BODY: APPS.WSH_PICKING_BATCHES_GRP 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_PICKING_BATCHES_GRP, status:VALID,
SYNONYM: APPS.WSH_PICKING_BATCHES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:WSH_PICKING_BATCHES, status:VALID,
PACKAGE BODY: APPS.WSH_SUPPLIER_PARTY 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_SUPPLIER_PARTY, status:VALID,
PACKAGE BODY: APPS.WSH_TRIPS_PUB 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_TRIPS_PUB, status:VALID,
PACKAGE BODY: APPS.WSH_TRIP_STOPS_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_TRIP_STOPS_PUB, status:VALID,
PACKAGE BODY: APPS.WSH_TRIPS_PUB 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_TRIPS_PUB, status:VALID,
PACKAGE BODY: APPS.WSH_CONTAINER_GRP 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_CONTAINER_GRP, status:VALID,
PACKAGE BODY: APPS.WSH_DELIVERY_DETAILS_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_DELIVERY_DETAILS_PKG, status:VALID,
PACKAGE BODY: APPS.WSH_TP_RELEASE 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_TP_RELEASE, status:VALID,
SYNONYM: APPS.WSH_ORG_CARRIER_SERVICES 12.1.1
owner:APPS, object_type:SYNONYM, object_name:WSH_ORG_CARRIER_SERVICES, status:VALID,
PACKAGE BODY: APPS.WSH_PROCESS_INTERFACED_PKG 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_PROCESS_INTERFACED_PKG, status:VALID,
PACKAGE BODY: APPS.WSH_WV_UTILS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_WV_UTILS, status:VALID,
PACKAGE BODY: APPS.WSH_FREIGHT_COSTS_GRP 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_FREIGHT_COSTS_GRP, status:VALID,
PACKAGE BODY: APPS.WSH_CONTAINER_UTILITIES 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_CONTAINER_UTILITIES, status:VALID,
SYNONYM: APPS.WSH_PICK_GROUPING_RULES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:WSH_PICK_GROUPING_RULES, status:VALID,
PACKAGE BODY: APPS.WSH_EXCEPTIONS_GRP 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_EXCEPTIONS_GRP, status:VALID,
SYNONYM: APPS.WSH_PICKING_BATCHES 12.2.2
owner:APPS, object_type:SYNONYM, object_name:WSH_PICKING_BATCHES, status:VALID,
PACKAGE BODY: APPS.WSH_OTM_REF_DATA_GEN_PKG 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:WSH_OTM_REF_DATA_GEN_PKG, status:VALID,