eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_USA_QUANTITY_PVT dependencies on WSH_USA_INV_PVT

Line 1591: WSH_USA_INV_PVT.query_reservations (

1587: -- delete or update all the move order lines
1588:
1589: IF p_changed_attribute.ordered_quantity = 0 THEN
1590:
1591: WSH_USA_INV_PVT.query_reservations (
1592: p_source_code => p_source_code,
1593: p_source_header_id => p_changed_attribute.source_header_id,
1594: p_source_line_id => p_changed_attribute.source_line_id,
1595: p_organization_id => old_delivery_detail_rec.organization_id,

Line 1614: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_USA_INV_PVT.DELETE_RESERVATION',WSH_DEBUG_SV.C_PROC_LEVEL);

1610: --
1611: -- Debug Statements
1612: --
1613: IF l_debug_on THEN
1614: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_USA_INV_PVT.DELETE_RESERVATION',WSH_DEBUG_SV.C_PROC_LEVEL);
1615: END IF;
1616: --
1617: WSH_USA_INV_PVT.delete_reservation( -- For that source header and line id
1618: p_query_input => l_rsv_array(l_counter),

Line 1617: WSH_USA_INV_PVT.delete_reservation( -- For that source header and line id

1613: IF l_debug_on THEN
1614: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_USA_INV_PVT.DELETE_RESERVATION',WSH_DEBUG_SV.C_PROC_LEVEL);
1615: END IF;
1616: --
1617: WSH_USA_INV_PVT.delete_reservation( -- For that source header and line id
1618: p_query_input => l_rsv_array(l_counter),
1619: x_return_status => l_return_status);
1620:
1621: IF l_debug_on THEN

Line 1637: --WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.delete_reservation',l_module_name);

1633: x_return_status := FND_API.G_RET_STS_ERROR;
1634: --IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1635: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1636: --ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1637: --WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.delete_reservation',l_module_name);
1638: --END IF;
1639: --
1640: -- Debug Statements
1641: --

Line 1660: WSH_USA_INV_PVT.cancel_nonstaged_reservation (

1656: IF l_debug_on THEN
1657: WSH_DEBUG_SV.logmsg(l_module_name, 'IN CANCELLING NON STAGED RESERVATION FOR SOURCE '||P_CHANGED_ATTRIBUTE.SOURCE_LINE_ID );
1658: END IF;
1659: --
1660: WSH_USA_INV_PVT.cancel_nonstaged_reservation (
1661: p_source_code => p_source_code,
1662: p_source_header_id => p_changed_attribute.source_header_id,
1663: p_source_line_id => p_changed_attribute.source_line_id,
1664: p_delivery_detail_id => old_delivery_detail_rec.delivery_detail_id, --Bug3012297

Line 1686: --WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.cancel_nonstaged_reservation',l_module_name);

1682: x_return_status := FND_API.G_RET_STS_ERROR;
1683: --IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1684: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1685: --ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1686: --WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.cancel_nonstaged_reservation',l_module_name);
1687: --END IF;
1688: --
1689: -- Debug Statements
1690: --

Line 1902: l_delivery_detail_split_rec WSH_USA_INV_PVT.DeliveryDetailInvRecType;

1898: l_lot_number WSH_DELIVERY_DETAILS.LOT_NUMBER%TYPE;
1899: l_locator_id WSH_DELIVERY_DETAILS.LOCATOR_ID%TYPE;
1900: l_picked_quantity WSH_DELIVERY_DETAILS.PICKED_QUANTITY%TYPE;
1901: l_picked_quantity2 WSH_DELIVERY_DETAILS.PICKED_QUANTITY2%TYPE;
1902: l_delivery_detail_split_rec WSH_USA_INV_PVT.DeliveryDetailInvRecType;
1903: l_cancel_quantity NUMBER;
1904: l_cancel_quantity2 NUMBER;
1905:
1906: l_msg_count NUMBER;

Line 1991: WSH_USA_INV_PVT.cancel_staged_reservation(

1987: -- Cancel Quantity is not used in this API,so passing as non-zero value
1988: l_cancel_quantity := l_picked_quantity;
1989: l_cancel_quantity2 := l_picked_quantity2;
1990:
1991: WSH_USA_INV_PVT.cancel_staged_reservation(
1992: p_source_code => p_source_code,
1993: p_source_header_id => l_source_header_id,
1994: p_source_line_id => p_source_line_id,
1995: p_delivery_detail_split_rec => l_delivery_detail_split_rec,

Line 2001: WSH_DEBUG_SV.log(l_module_name,'WSH_USA_INV_PVT.CANCEL_STAGED_RESERVATION',x_return_status);

1997: p_cancellation_quantity2 => l_cancel_quantity2,
1998: x_return_status => x_return_status);
1999:
2000: IF l_debug_on THEN
2001: WSH_DEBUG_SV.log(l_module_name,'WSH_USA_INV_PVT.CANCEL_STAGED_RESERVATION',x_return_status);
2002: END IF;
2003: IF x_return_status IN (fnd_api.g_ret_sts_error,
2004: fnd_api.g_ret_sts_unexp_error) THEN
2005: IF l_debug_on THEN

Line 2006: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_USA_INV_PVT.CANCEL_STAGED_RESERVATION ') ;

2002: END IF;
2003: IF x_return_status IN (fnd_api.g_ret_sts_error,
2004: fnd_api.g_ret_sts_unexp_error) THEN
2005: IF l_debug_on THEN
2006: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_USA_INV_PVT.CANCEL_STAGED_RESERVATION ') ;
2007: END IF;
2008:
2009: x_return_status := FND_API.G_RET_STS_ERROR;
2010: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);

Line 2101: WSH_USA_INV_PVT.update_serial_numbers(

2097: -- Debug Statements
2098: --
2099: --HW OPMCONV - Removed branching
2100:
2101: WSH_USA_INV_PVT.update_serial_numbers(
2102: p_delivery_detail_id => l_delivery_detail_id,
2103: p_serial_number => l_serial_number,
2104: p_transaction_temp_id => l_txn_temp_id,
2105: x_return_status => x_return_status);

Line 2433: l_delivery_detail_split_rec WSH_USA_INV_PVT.DeliveryDetailInvRecType;

2429: WHERE wda.delivery_id is not null
2430: AND wda.delivery_detail_id = p_del_det
2431: AND wda.delivery_id = wnd.delivery_id;
2432:
2433: l_delivery_detail_split_rec WSH_USA_INV_PVT.DeliveryDetailInvRecType;
2434: l_picked_quantity NUMBER;
2435: l_picked_quantity2 NUMBER;
2436: l_excess_picked_quantity NUMBER;
2437: -- HW OPMCONV - Added new variables

Line 3184: WSH_USA_INV_PVT.cancel_staged_reservation(

3180: l_delivery_detail_split_rec.revision := p_revision;
3181: l_delivery_detail_split_rec.lot_number := p_lot_number;
3182: l_delivery_detail_split_rec.locator_id := p_locator_id;
3183:
3184: WSH_USA_INV_PVT.cancel_staged_reservation(
3185: p_source_code => p_source_code,
3186: p_source_header_id => p_source_header_id,
3187: p_source_line_id => p_source_line_id,
3188: p_delivery_detail_split_rec => l_delivery_detail_split_rec, -- New need to build up

Line 3193: WSH_DEBUG_SV.log(l_module_name,'WSH_USA_INV_PVT.CANCEL_STAGED_RESERVATION',x_return_status);

3189: p_cancellation_quantity => l_change_reservation_quantity,
3190: p_cancellation_quantity2 => l_change_reservation_quantity2,
3191: x_return_status => x_return_status);
3192: IF l_debug_on THEN
3193: WSH_DEBUG_SV.log(l_module_name,'WSH_USA_INV_PVT.CANCEL_STAGED_RESERVATION',x_return_status);
3194: END IF;
3195:
3196: IF x_return_status = fnd_api.g_ret_sts_success THEN
3197: --

Line 3209: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_USA_INV_PVT.CANCEL_STAGED_RESERVATION ' );

3205: --
3206: -- Debug Statements
3207: --
3208: IF l_debug_on THEN
3209: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_USA_INV_PVT.CANCEL_STAGED_RESERVATION ' );
3210: END IF;
3211: --
3212: x_return_status := FND_API.G_RET_STS_ERROR;
3213: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);

Line 3285: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_USA_INV_PVT.UPDATE_SERIAL_NUMBERS',WSH_DEBUG_SV.C_PROC_LEVEL);

3281: ELSIF p_ordered_quantity = 0 AND (p_transaction_temp_id IS NOT NULL OR p_serial_number IS NOT NULL ) THEN
3282: --
3283: IF l_debug_on THEN
3284: WSH_DEBUG_SV.logmsg(l_module_name,'Complete Order Qty Cancelation - all serial numbers will be unmarked',WSH_DEBUG_SV.C_PROC_LEVEL);
3285: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_USA_INV_PVT.UPDATE_SERIAL_NUMBERS',WSH_DEBUG_SV.C_PROC_LEVEL);
3286: END IF;
3287: --
3288: WSH_USA_INV_PVT.update_serial_numbers(
3289: p_delivery_detail_id => p_delivery_detail_id,

Line 3288: WSH_USA_INV_PVT.update_serial_numbers(

3284: WSH_DEBUG_SV.logmsg(l_module_name,'Complete Order Qty Cancelation - all serial numbers will be unmarked',WSH_DEBUG_SV.C_PROC_LEVEL);
3285: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_USA_INV_PVT.UPDATE_SERIAL_NUMBERS',WSH_DEBUG_SV.C_PROC_LEVEL);
3286: END IF;
3287: --
3288: WSH_USA_INV_PVT.update_serial_numbers(
3289: p_delivery_detail_id => p_delivery_detail_id,
3290: p_serial_number => p_serial_number,
3291: p_transaction_temp_id => p_transaction_temp_id,
3292: x_return_status => x_return_status);

Line 3317: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_USA_INV_PVT.UPDATE_SERIAL_NUMBERS ' );

3313: --
3314: -- Debug Statements
3315: --
3316: IF l_debug_on THEN
3317: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_USA_INV_PVT.UPDATE_SERIAL_NUMBERS ' );
3318: END IF;
3319: --
3320: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3321: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);