Search Results update_failed

Overview

The APPS.WSH_CARRIER_VEHICLE_TYPES_PKG package body is a table handler (PL/SQL API) for the WSH_CARRIER_VEHICLE_TYPES base table within Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the Shipping Execution (WSH) module and provides the programmatic interface through which carrier-to-vehicle-type assignments are created, modified, and managed. The header comment in the source identifies the object explicitly as a "Table Handlers for table WSH_CARRIER_VEHICLE_TYPES," confirming its role as the canonical DML gateway for that entity rather than as a business-process orchestrator.

Carrier vehicle types associate a carrier (as defined in the shipping and transportation model) with the vehicle types that carrier can service, along with an assignment flag and descriptive flexfield attribute columns. This relationship supports transportation planning, rate shopping, and shipment routing decisions in the Oracle Shipping and Transportation Management flows.

Key Procedures and Functions

The ETRM documentation records three procedures for this package: CREATE_CARRIER_VEHICLE_TYPE, UPDATE_CARRIER_VEHICLE_TYPE, and LOCK_CARRIER_VEHICLE_TYPE.

• CREATE_CARRIER_VEHICLE_TYPE — Inserts a new carrier vehicle type assignment. The source excerpt shows this procedure accepts a record-type parameter carrying carrier, vehicle type, assignment flag, attribute category, and attribute1 through attributeN values, and returns standard table-handler OUT parameters including a ROWID, a return status, an exception message, a position, the procedure name, and SQL error diagnostics. It also contains embedded debug instrumentation via WSH_DEBUG_INTERFACE and WSH_DEBUG_SV, conditionally enabled when debug logging is active.
• UPDATE_CARRIER_VEHICLE_TYPE — Modifies an existing carrier vehicle type record, typically keyed by primary key or ROWID, using the same record-type input and standard OUT parameter convention. This is the procedure implicated when an "update_failed" condition is raised.
• LOCK_CARRIER_VEHICLE_TYPE — Acquires a row-level lock on a carrier vehicle type record, supporting optimistic concurrency control before an update is applied.

No parameter lists are invented here; only the documented procedure names and their purpose are described.

Tables Accessed

The single documented table reference is WSH_CARRIER_VEHICLE_TYPES, accessed through an APPS synonym. This package performs insert, update, and lock operations against that table. The table stores the carrier identifier, vehicle type identifier, assigned flag, attribute category, and descriptive flexfield attribute columns that the API surfaces as its record-type input.

Usage Notes

As an API-classified "OTHER" object with zero dependent packages (referenced by 0 other packages), WSH_CARRIER_VEHICLE_TYPES_PKG is not a widely reused shared dependency; it is invoked directly by Oracle Shipping UI forms, concurrent programs that preload or maintain carrier vehicle type data, and custom extensions in Release 12.1.1 and 12.2.2.

When a user encounters an update_failed error, the failure surfaces through the OUT parameters X_RETURN_STATUS, X_EXCEPTION_MSG, and X_SQLERR. Diagnosis should capture those outputs, inspect the SQL error code (X_SQL_CODE), and verify that the target row is not locked by another session and that the supplied ROWID or key still exists. Debug logging can be enabled to trace the carrier and vehicle type values passed into the failing procedure.