Search Results wsh_dpw_param_not_set

Overview

WSH_PARAMETERS_PVT is a private PL/SQL package in the Oracle E-Business Suite Shipping (WSH) module. It provides a controlled, server-side interface for reading organization-specific shipping configuration parameters stored in the WSH_PARAMETERS table. Rather than allowing direct queries against WSH_PARAMETERS, Oracle Shipping exposes these settings through a small set of accessor routines, ensuring that parameter lookups are performed consistently and that an appropriate error is raised when no parameter row exists for the requested organization. The package caches the fetched row in package-level variables to avoid repeated queries within a session, and it validates the existence of a configuration row before allowing dependent shipping logic to proceed. Because it is classified as a private (PVT) package, it is intended for internal use by other Shipping APIs and concurrent programs rather than as a formally supported public API.

Key Procedures and Functions

• GET_PARAM_VALUE — Returns the value of a named shipping parameter for a given organization. It is the primary character-type accessor used by other Shipping packages to retrieve configuration flags and identifiers such as UOM classes, packing enforcement settings, and report set identifiers.
• GET_PARAM_VALUE_NUM — Returns the numeric value of a named shipping parameter for a given organization. This routine supports parameters that are stored as numbers, such as report set IDs and rule IDs referenced in the WSH_PARAMETERS record. It is the routine most commonly associated with the search term "get_param_value_num" and is invoked when calling code requires a numeric result rather than a character string.

Both routines rely on an internal row-fetching mechanism that selects a single WSH_PARAMETERS row for the current organization. If no row is found, the package raises the standard message WSH_DPW_PARAM_NOT_SET, indicating that Departure/Packing/Weight parameters have not been configured for the organization.

Tables Accessed

The package reads from a single table, WSH_PARAMETERS, accessed through an APPS synonym. This table stores organization-level shipping parameters, including planning method flags, weight and volume UOM classes, invoice and delivery completion flags, weight/volume calculation flags, container control flags, percent fill basis, packing enforcement, and various report set and rule identifiers. The package performs a SELECT only; it does not insert, update, or delete records, so parameter maintenance is handled elsewhere through the Shipping setup forms.

Usage Notes

WSH_PARAMETERS_PVT is referenced by approximately five other packages within the Shipping application, which call its accessor routines to obtain configuration values during order release, packing, and delivery processing. The numeric accessor is particularly useful where downstream logic expects an ID or count rather than a string. Typical invocation paths are Shipping forms, shipping concurrent programs, and custom extensions that need to interrogate organization shipping setup. Because the package is private and not a documented public API, custom code should prefer supported public interfaces where available; direct dependence on WSH_PARAMETERS_PVT should be treated as subject to change across releases such as 12.1.1 and 12.2.2. When calling it directly, ensure the current organization context is set, since the fetch relies on the organization identifier supplied by the caller.