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 1850: WSH_USA_INV_PVT.query_reservations (

1846: -- delete or update all the move order lines
1847:
1848: IF p_changed_attribute.ordered_quantity = 0 THEN
1849:
1850: WSH_USA_INV_PVT.query_reservations (
1851: p_source_code => p_source_code,
1852: p_source_header_id => p_changed_attribute.source_header_id,
1853: p_source_line_id => p_changed_attribute.source_line_id,
1854: p_organization_id => old_delivery_detail_rec.organization_id,

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

1869: --
1870: -- Debug Statements
1871: --
1872: IF l_debug_on THEN
1873: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_USA_INV_PVT.DELETE_RESERVATION',WSH_DEBUG_SV.C_PROC_LEVEL);
1874: END IF;
1875: --
1876: WSH_USA_INV_PVT.delete_reservation( -- For that source header and line id
1877: p_query_input => l_rsv_array(l_counter),

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

1872: IF l_debug_on THEN
1873: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_USA_INV_PVT.DELETE_RESERVATION',WSH_DEBUG_SV.C_PROC_LEVEL);
1874: END IF;
1875: --
1876: WSH_USA_INV_PVT.delete_reservation( -- For that source header and line id
1877: p_query_input => l_rsv_array(l_counter),
1878: x_return_status => l_return_status);
1879:
1880: IF l_debug_on THEN

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

1892: x_return_status := FND_API.G_RET_STS_ERROR;
1893: --IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1894: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1895: --ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1896: --WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.delete_reservation',l_module_name);
1897: --END IF;
1898: --
1899: -- Debug Statements
1900: --

Line 1919: WSH_USA_INV_PVT.cancel_nonstaged_reservation (

1915: IF l_debug_on THEN
1916: WSH_DEBUG_SV.logmsg(l_module_name, 'IN CANCELLING NON STAGED RESERVATION FOR SOURCE '||P_CHANGED_ATTRIBUTE.SOURCE_LINE_ID );
1917: END IF;
1918: --
1919: WSH_USA_INV_PVT.cancel_nonstaged_reservation (
1920: p_source_code => p_source_code,
1921: p_source_header_id => p_changed_attribute.source_header_id,
1922: p_source_line_id => p_changed_attribute.source_line_id,
1923: p_delivery_detail_id => old_delivery_detail_rec.delivery_detail_id, --Bug3012297

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

1941: x_return_status := FND_API.G_RET_STS_ERROR;
1942: --IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1943: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);
1944: --ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1945: --WSH_UTIL_CORE.default_handler('WSH_USA_INV_PVT.cancel_nonstaged_reservation',l_module_name);
1946: --END IF;
1947: --
1948: -- Debug Statements
1949: --

Line 2166: l_delivery_detail_split_rec WSH_USA_INV_PVT.DeliveryDetailInvRecType;

2162: l_lot_number WSH_DELIVERY_DETAILS.LOT_NUMBER%TYPE;
2163: l_locator_id WSH_DELIVERY_DETAILS.LOCATOR_ID%TYPE;
2164: l_picked_quantity WSH_DELIVERY_DETAILS.PICKED_QUANTITY%TYPE;
2165: l_picked_quantity2 WSH_DELIVERY_DETAILS.PICKED_QUANTITY2%TYPE;
2166: l_delivery_detail_split_rec WSH_USA_INV_PVT.DeliveryDetailInvRecType;
2167: l_cancel_quantity NUMBER;
2168: l_cancel_quantity2 NUMBER;
2169:
2170: l_msg_count NUMBER;

Line 2256: WSH_USA_INV_PVT.cancel_staged_reservation(

2252: -- Cancel Quantity is not used in this API,so passing as non-zero value
2253: l_cancel_quantity := l_picked_quantity;
2254: l_cancel_quantity2 := l_picked_quantity2;
2255:
2256: WSH_USA_INV_PVT.cancel_staged_reservation(
2257: p_source_code => p_source_code,
2258: p_source_header_id => l_source_header_id,
2259: p_source_line_id => p_source_line_id,
2260: p_delivery_detail_split_rec => l_delivery_detail_split_rec,

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

2262: p_cancellation_quantity2 => l_cancel_quantity2,
2263: x_return_status => x_return_status);
2264:
2265: IF l_debug_on THEN
2266: WSH_DEBUG_SV.log(l_module_name,'WSH_USA_INV_PVT.CANCEL_STAGED_RESERVATION',x_return_status);
2267: END IF;
2268: IF x_return_status IN (fnd_api.g_ret_sts_error,
2269: fnd_api.g_ret_sts_unexp_error) THEN
2270: IF l_debug_on THEN

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

2267: END IF;
2268: IF x_return_status IN (fnd_api.g_ret_sts_error,
2269: fnd_api.g_ret_sts_unexp_error) THEN
2270: IF l_debug_on THEN
2271: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_USA_INV_PVT.CANCEL_STAGED_RESERVATION ') ;
2272: END IF;
2273:
2274: x_return_status := FND_API.G_RET_STS_ERROR;
2275: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);

Line 2366: WSH_USA_INV_PVT.update_serial_numbers(

2362: -- Debug Statements
2363: --
2364: --HW OPMCONV - Removed branching
2365:
2366: WSH_USA_INV_PVT.update_serial_numbers(
2367: p_delivery_detail_id => l_delivery_detail_id,
2368: p_serial_number => l_serial_number,
2369: p_transaction_temp_id => l_txn_temp_id,
2370: x_return_status => x_return_status);

Line 2712: l_delivery_detail_split_rec WSH_USA_INV_PVT.DeliveryDetailInvRecType;

2708: WHERE wda.delivery_id is not null
2709: AND wda.delivery_detail_id = p_del_det
2710: AND wda.delivery_id = wnd.delivery_id;
2711:
2712: l_delivery_detail_split_rec WSH_USA_INV_PVT.DeliveryDetailInvRecType;
2713: l_picked_quantity NUMBER;
2714: l_picked_quantity2 NUMBER;
2715: l_excess_picked_quantity NUMBER;
2716: -- HW OPMCONV - Added new variables

Line 3586: WSH_USA_INV_PVT.cancel_staged_reservation(

3582: l_delivery_detail_split_rec.revision := p_revision;
3583: l_delivery_detail_split_rec.lot_number := p_lot_number;
3584: l_delivery_detail_split_rec.locator_id := p_locator_id;
3585:
3586: WSH_USA_INV_PVT.cancel_staged_reservation(
3587: p_source_code => p_source_code,
3588: p_source_header_id => p_source_header_id,
3589: p_source_line_id => p_source_line_id,
3590: p_delivery_detail_split_rec => l_delivery_detail_split_rec, -- New need to build up

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

3591: p_cancellation_quantity => l_change_reservation_quantity,
3592: p_cancellation_quantity2 => l_change_reservation_quantity2,
3593: x_return_status => x_return_status);
3594: IF l_debug_on THEN
3595: WSH_DEBUG_SV.log(l_module_name,'WSH_USA_INV_PVT.CANCEL_STAGED_RESERVATION',x_return_status);
3596: END IF;
3597:
3598: IF x_return_status = fnd_api.g_ret_sts_success THEN
3599: --

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

3607: --
3608: -- Debug Statements
3609: --
3610: IF l_debug_on THEN
3611: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_USA_INV_PVT.CANCEL_STAGED_RESERVATION ' );
3612: END IF;
3613: --
3614: x_return_status := FND_API.G_RET_STS_ERROR;
3615: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);

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

3683: ELSIF p_ordered_quantity = 0 AND (p_transaction_temp_id IS NOT NULL OR p_serial_number IS NOT NULL ) THEN
3684: --
3685: IF l_debug_on THEN
3686: WSH_DEBUG_SV.logmsg(l_module_name,'Complete Order Qty Cancelation - all serial numbers will be unmarked',WSH_DEBUG_SV.C_PROC_LEVEL);
3687: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_USA_INV_PVT.UPDATE_SERIAL_NUMBERS',WSH_DEBUG_SV.C_PROC_LEVEL);
3688: END IF;
3689: --
3690: WSH_USA_INV_PVT.update_serial_numbers(
3691: p_delivery_detail_id => p_delivery_detail_id,

Line 3690: WSH_USA_INV_PVT.update_serial_numbers(

3686: WSH_DEBUG_SV.logmsg(l_module_name,'Complete Order Qty Cancelation - all serial numbers will be unmarked',WSH_DEBUG_SV.C_PROC_LEVEL);
3687: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_USA_INV_PVT.UPDATE_SERIAL_NUMBERS',WSH_DEBUG_SV.C_PROC_LEVEL);
3688: END IF;
3689: --
3690: WSH_USA_INV_PVT.update_serial_numbers(
3691: p_delivery_detail_id => p_delivery_detail_id,
3692: p_serial_number => p_serial_number,
3693: p_transaction_temp_id => p_transaction_temp_id,
3694: x_return_status => x_return_status);

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

3715: --
3716: -- Debug Statements
3717: --
3718: IF l_debug_on THEN
3719: WSH_DEBUG_SV.logmsg(l_module_name, 'ERROR IN WSH_USA_INV_PVT.UPDATE_SERIAL_NUMBERS ' );
3720: END IF;
3721: --
3722: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3723: WSH_UTIL_CORE.add_message (x_return_status,l_module_name);