Search Results p_exceptions_only

Overview

WSH_WSHRDASP_XMLP_PKG is the generated PL/SQL package body that implements the server-side logic for the Oracle E-Business Suite concurrent program XML report commonly identified as the Shipping Delivery / Ship Confirmation report (WSHRDASP). The package follows the standard XML Publisher concurrent program pattern used throughout Oracle EBS 12.1.1 and 12.2.2, in which the report definition, its XML data template, and the associated PL/SQL package are generated and maintained together. The package is owned by the APPS schema and is classified as an OTHER API object, meaning it is not a supported public interface but rather an internal companion to the concurrent program.

Its principal responsibility is to accept the report's runtime parameters, resolve those parameters into readable descriptive values (batch name, customer or supplier name, ship-from organization, ship-to location, ship method meaning, trip, delivery, and related attributes), and expose them to the report's data model and layout through the XML Publisher formula and parameter functions. The file header indicates a version lineage of 120.4 dated 2010/08/30, which places the shipped code across both the 12.1.1 and 12.2.2 releases without functional divergence.

Key Procedures and Functions

The package exposes 21 documented procedures and functions. The report event handlers form the structural backbone:

• BEFOREREPORT — the primary initialization function. It opens cursors that resolve the report parameters into display values and sets P_CONC_REQUEST_ID from FND_GLOBAL.CONC_REQUEST_ID.
• BEFOREPFORM and AFTERPFORM — parameter form event handlers that prepare and post-process parameter form values before and after the report form is displayed.
• AFTERREPORT — performs any cleanup or finalization after the report data has been produced.
• CF_1FORMULA and CF_MESSAGE — XML Publisher formula (CF_) functions that return computed values for the report layout, including the localized Auto Ship Confirmation message derived from FND_NEW_MESSAGES.

The remaining documented members are CP_ (concurrent program parameter) functions, each of which returns the descriptive value for a single report parameter:

• CP_BATCH_NAME_P, CP_BATCH_ID_P — resolve picking batch identity.
• CP_CUSTOMER_P, CP_SHIP_TO_P — resolve customer and ship-to party names, supporting the RTV (return to vendor) variant where the same field carries supplier data.
• CP_SHIP_FROM_P, CP_ORG_P — resolve the ship-from organization name, which is the value most commonly surfaced when users search on "p_ship_from."
• CP_SHIP_METHOD_P — resolves the ship method lookup meaning.
• CP_DELIVERY_FROM_P, CP_DELIVERY_TO_P — resolve the delivery range parameters.
• CP_TRIP_NAME_P, CP_TRIP_ID_P — resolve trip identity for trip-based reporting.
• CP_PR_BATCH_P, CP_MESSAGE_P, CP_EXCEPTIONS_ONLY_P — resolve print-batch, message text, and the exceptions-only YES/NO lookup meaning respectively.

Tables Accessed

The package reads from the following tables through APPS synonyms:

• WSH_PICKING_BATCHES — source of the picking batch name via BATCH_ID.
• HZ_PARTIES and HZ_CUST_ACCOUNTS — joined to resolve customer party names, truncated to 50 bytes for layout conformity.
• PO_VENDORS — used in the RTV variant to resolve supplier names.
• WSH_NEW_DELIVERIES, WSH_DELIVERY_LEGS, WSH_TRIPS, WSH_TRIP_STOPS — delivery and trip reporting data.
• WSH_EXCEPTIONS — exception detail for the exceptions-only mode.
• WSH_SHIP_CONFIRM_RULES — resolves the ship confirmation rule name from SHIP_CONFIRM_RULE_ID.
• HR_ALL_ORGANIZATION_UNITS — resolves the ship-from organization name from ORGANIZATION_ID.
• FND_LOOKUP_VALUES_VL and FND_LOOKUPS — resolve ship method and YES_NO meaning values.
• FND_NEW_MESSAGES — retrieves the localized WSH_AUTO_SC_MESSAGE text.

Usage Notes

This package is never invoked directly by end users or by custom code. It is called by the Oracle EBS concurrent manager when the associated XML Publisher concurrent program is submitted, and by the XML Publisher runtime when the report template requests formula or parameter values. The "p_ship_from" search term relates to the report's SHIP_FROM parameter, whose display value is produced by CP_SHIP_FROM_P. Because the object is generated and version-managed by Oracle, it should not be modified; report customizations belong in a copied template or a custom concurrent program. It is referenced by zero other packages.