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_ACTIONS_PVT dependencies on WSH_USA_INV_PVT

Line 454: l_detail_inv_rec WSH_USA_INV_PVT.DeliveryDetailInvRecType;

450: AND wdd.source_line_id = x_line_id
451: AND wdd.requested_quantity = 0
452: AND wdd.released_status <> 'D';
453:
454: l_detail_inv_rec WSH_USA_INV_PVT.DeliveryDetailInvRecType;
455: l_detail_info WSH_DELIVERY_DETAILS_ACTIONS.SplitDetailRecType;
456:
457: l_cancel_Reservation_Tab_Type WSH_USA_ACTIONS_PVT.Cancel_Reservation_Tab_Type; --bugfix 8915868
458: l_cancel_counter NUMBER :=0 ; --bugfix 8915868

Line 627: IF wsh_usa_inv_pvt.is_mo_type_putaway (c.move_order_line_id) = 'Y' THEN

623: END IF;
624: -- Keeping the function call separate to avoid extra overhead of calling
625: -- a function for each check, it will be called only when above is
626: -- satisfied
627: IF wsh_usa_inv_pvt.is_mo_type_putaway (c.move_order_line_id) = 'Y' THEN
628: --{
629: IF l_debug_on THEN
630: WSH_DEBUG_SV.log(l_module_name,'DO NOT ALLOW SPLIT FOR PUTAWAY MOL,---',c.move_order_line_id) ;
631: WSH_DEBUG_SV.log(l_module_name,'ORDER NUMBER---',c.source_header_number) ;

Line 810: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_USA_INV_PVT.get_detailed_quantity');

806: -- the detailed quantity of the move order line
807: -- or the quantity in the delivery detail, which ever is
808: -- greater.
809: IF l_debug_on THEN
810: WSH_DEBUG_SV.logmsg(l_module_name, 'Calling WSH_USA_INV_PVT.get_detailed_quantity');
811: WSH_DEBUG_SV.log(l_module_name,'move_order',c.move_order_line_id);
812: END IF;
813:
814: -- Bug3143426 (included branch for l_res_qty_to_transfer calculation)

Line 819: WSH_USA_INV_PVT.get_detailed_quantity (

815: -- HW OPMCONV. Removed forking and Call get_detailed_quantity as a procedure
816: -- anxsharm, X-dock changes
817: --{
818: IF c.move_order_line_id IS NOT NULL THEN
819: WSH_USA_INV_PVT.get_detailed_quantity (
820: p_mo_line_id => c.move_order_line_id,
821: x_detailed_qty => l_detailed_qty,
822: x_detailed_qty2 => l_detailed_qty2,
823: x_return_status => x_return_status);

Line 852: -- associated to PTO components. Code has been added in the API WSH_USA_INV_PVT.Split_Reservation

848: IF l_debug_on THEN
849: WSH_DEBUG_SV.logmsg(l_module_name,'The line belongs to model (not ATO) and DD status is S. Transfer Move order line');
850: END IF;
851: -- bug # 9410461: Changed value from 'CANCEL' to 'PTOTRANSFER'. It prevents the cancelling of move order lines
852: -- associated to PTO components. Code has been added in the API WSH_USA_INV_PVT.Split_Reservation
853: -- for the value 'PTOTRANSFER'.
854: l_move_order_line_status := 'PTOTRANSFER';
855: END IF;
856: ELSE

Line 1112: WSH_USA_INV_PVT.get_detailed_quantity (

1108: -- detailed quantity is only for details released to warehouse.
1109: -- anxsharm, X-dock changes
1110: --{
1111: IF c.released_status = 'S' AND c.move_order_line_id IS NOT NULL THEN
1112: WSH_USA_INV_PVT.get_detailed_quantity (
1113: p_mo_line_id => c.move_order_line_id,
1114: x_detailed_qty => l_detailed_qty,
1115: x_detailed_qty2 => l_detailed_qty2,
1116: x_return_status => x_return_status);

Line 1179: WSH_USA_INV_PVT.cancel_staged_reservation(p_source_code => p_source_code,

1175:
1176: --bugfix 8976069 added join for 'Y' and 'C'
1177: IF (p_changed_attributes(l_counter).ship_from_org_id <> l_detail_inv_rec.organization_id) and c.released_status in ('Y', 'C') THEN
1178:
1179: WSH_USA_INV_PVT.cancel_staged_reservation(p_source_code => p_source_code,
1180: p_source_header_id => p_changed_attributes(l_counter).source_header_id,
1181: p_source_line_id => p_changed_attributes(l_counter).original_source_line_id,
1182: p_delivery_detail_split_rec => l_detail_inv_rec,
1183: p_cancellation_quantity =>l_res_qty_to_transfer,

Line 1190: WSH_DEBUG_SV.logmsg(l_module_name,'unexpected error after WSH_USA_INV_PVT.cancel_staged_reservation ');

1186:
1187:
1188: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1189: IF l_debug_on THEN
1190: WSH_DEBUG_SV.logmsg(l_module_name,'unexpected error after WSH_USA_INV_PVT.cancel_staged_reservation ');
1191: END IF;
1192: exit records_loop ;
1193: END IF;
1194:

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

1194:
1195: ELSE
1196:
1197: IF l_debug_on THEN
1198: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_USA_INV_PVT.SPLIT_RESERVATION',WSH_DEBUG_SV.C_PROC_LEVEL);
1199: END IF;
1200: --
1201: -- Added parameter p_shipped_flag for bug 10105817
1202: WSH_USA_INV_PVT.Split_Reservation (

Line 1202: WSH_USA_INV_PVT.Split_Reservation (

1198: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_USA_INV_PVT.SPLIT_RESERVATION',WSH_DEBUG_SV.C_PROC_LEVEL);
1199: END IF;
1200: --
1201: -- Added parameter p_shipped_flag for bug 10105817
1202: WSH_USA_INV_PVT.Split_Reservation (
1203: p_delivery_detail_split_rec => l_detail_inv_rec,
1204: p_source_code => p_source_code,
1205: p_source_header_id => p_changed_attributes(l_counter).source_header_id,
1206: p_original_source_line_id => p_changed_attributes(l_counter).original_source_line_id,

Line 1350: -- WSH_USA_INV_PVT.Split_Reservation returs Expected/Unexpected error.

1346: -- Loop here to calculate the reservations to split for each p_changed_attribute
1347: -- IF Condition added for bug 10105817
1348: -- Proceed further only l_rs is SUCCESS/WARNING.
1349: -- Added If Condition, since ITS proceeds further and completes normally even if API
1350: -- WSH_USA_INV_PVT.Split_Reservation returs Expected/Unexpected error.
1351: IF l_rs NOT IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN -- {
1352: -- Loop here to calculate the reservations to split for each p_changed_attribute
1353:
1354:

Line 1401: WSH_USA_INV_PVT.Get_total_reserved_quantity (

1397: l_Cancel_Reservation_Tab_Type(l_cancel_counter).cancelled_quantity2 := l_total_spare_rsv2;
1398:
1399: END IF;
1400:
1401: WSH_USA_INV_PVT.Get_total_reserved_quantity (
1402: p_source_code => p_source_code ,
1403: p_source_header_id => p_changed_attributes(l_counter ).source_header_id ,
1404: p_source_line_id => p_changed_attributes(l_counter ).original_source_line_id ,
1405: p_organization_id => p_changed_attributes(l_counter ).organization_id ,

Line 1426: WSH_USA_INV_PVT.Get_total_reserved_quantity (

1422: (p_changed_attributes(l_counter).Ship_from_org_id = l_organization_id) THEN --{
1423:
1424: -- Get total reserved quantity on current line
1425: -- HW OPMCONV - Pass Qty2 as a parameter
1426: WSH_USA_INV_PVT.Get_total_reserved_quantity (
1427: p_source_code => p_source_code ,
1428: p_source_header_id => p_changed_attributes(l_counter ).source_header_id ,
1429: p_source_line_id => p_changed_attributes(l_counter ).source_line_id ,
1430: p_organization_id => p_changed_attributes(l_counter ).organization_id ,

Line 1512: WSH_USA_INV_PVT.get_detailed_quantity (

1508: -- detailed quantity is only for details released to warehouse.
1509: -- anxsharm, X-dock changes
1510: --{
1511: IF c.released_status = 'S' AND c.move_order_line_id IS NOT NULL THEN
1512: WSH_USA_INV_PVT.get_detailed_quantity (
1513: p_mo_line_id => c.move_order_line_id,
1514: x_detailed_qty => l_detailed_qty,
1515: x_detailed_qty2 => l_detailed_qty2,
1516: x_return_status => x_return_status);

Line 1576: WSH_DEBUG_SV.logmsg(l_module_name,'TRansfering unstaged reservations : BEfore WSH_USA_INV_PVT.Split_Reservation ');

1572: l_detail_inv_rec.locator_id := c.locator_id;
1573: l_detail_inv_rec.lpn_id := c.lpn_id;
1574:
1575: IF l_debug_on THEN
1576: WSH_DEBUG_SV.logmsg(l_module_name,'TRansfering unstaged reservations : BEfore WSH_USA_INV_PVT.Split_Reservation ');
1577: END IF;
1578: -- HW OPMCONV - Added Qty2
1579: l_res_qty_to_transfer := LEAST ( nvl(c.picked_quantity , c.requested_quantity ) ,
1580: l_total_res_qty_to_transfer );

Line 1618: WSH_USA_INV_PVT.Split_Reservation (

1614: WSH_DEBUG_SV.logmsg(l_module_name,'l_direction_flag = ' || l_direction_flag );
1615: WSH_DEBUG_SV.logmsg(l_module_name,'p_shipped_flag = '||p_changed_attributes(l_counter).shipped_flag);
1616: END IF;
1617: --
1618: WSH_USA_INV_PVT.Split_Reservation (
1619: p_delivery_detail_split_rec => l_detail_inv_rec,
1620: p_source_code => p_source_code,
1621: p_source_header_id => p_changed_attributes(l_counter).source_header_id,
1622: p_original_source_line_id => p_changed_attributes(l_counter).original_source_line_id,

Line 1633: WSH_DEBUG_SV.logmsg(l_module_name,'unexpected error after WSH_USA_INV_PVT.Split_Reservation ');

1629: x_return_status => l_rs);
1630:
1631: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1632: IF l_debug_on THEN
1633: WSH_DEBUG_SV.logmsg(l_module_name,'unexpected error after WSH_USA_INV_PVT.Split_Reservation ');
1634: END IF;
1635: exit unstaged_rsv_loop ;
1636: END IF;
1637:

Line 1686: WSH_USA_INV_PVT.cancel_nonstaged_reservation( p_source_code => l_Cancel_Reservation_Tab_Type(i).source_code,

1682: IF (l_cancel_counter > 0) AND (p_interface_flag = 'N') THEN
1683:
1684: FOR i in 1..l_cancel_counter LOOP
1685:
1686: WSH_USA_INV_PVT.cancel_nonstaged_reservation( p_source_code => l_Cancel_Reservation_Tab_Type(i).source_code,
1687: p_source_header_id => l_Cancel_Reservation_Tab_Type(i).source_header_id,
1688: p_source_line_id => l_Cancel_Reservation_Tab_Type(i).source_line_id,
1689: p_delivery_detail_id => l_Cancel_Reservation_Tab_Type(i).delivery_detail_id,
1690: p_organization_id => l_Cancel_Reservation_Tab_Type(i).organization_id ,

Line 1697: WSH_DEBUG_SV.logmsg(l_module_name,'unexpected error after WSH_USA_INV_PVT.cancel_nonstaged_reservation');

1693: x_return_status => l_rs);
1694: --
1695: IF l_rs IN (WSH_UTIL_CORE.G_RET_STS_ERROR, WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR) THEN
1696: IF l_debug_on THEN
1697: WSH_DEBUG_SV.logmsg(l_module_name,'unexpected error after WSH_USA_INV_PVT.cancel_nonstaged_reservation');
1698: END IF;
1699: END IF;
1700: --
1701: END LOOP ;