[Home] [Help]
1: PACKAGE BODY GMI_PICK_WAVE_CONFIRM_PVT AS
2: /* $Header: GMIVPWCB.pls 120.1 2005/08/30 08:24:08 nchekuri noship $ */
3: /* +=========================================================================+
4: | Copyright (c) 2000 Oracle Corporation |
5: | TVP, Reading, England |
29: | Sep. 3rd, 2004 HAW BUG#:3871662. Removed cursor check_wsh |
30: | Sep. 3rd 2004 PKU BUG 3859774 |
31: | ONLY primary allocations should be compared with primary available |
32: +=========================================================================+
33: API Name : GMI_PICK_WAVE_CONFIRM_PVT
34: Type : Global
35: -
36: Pre-reqs : N/A
37: Parameters: Per function
78: x_return_status OUT NOCOPY VARCHAR2
79: );
80: -- END Bug 3776538
81:
82: G_PKG_NAME CONSTANT VARCHAR2(30):='GMI_PICK_WAVE_CONFIRM_PVT';
83:
84:
85:
86:
744: -- for non ctl items, no allocation is made but the default trans
745: -- qty is updated by the system, can not be over allocating
746: IF (l_mo_line_rec.quantity_delivered > l_mo_line_rec.quantity )
747: AND (l_default_transaction <> 1) THEN
748: GMI_Pick_Wave_Confirm_PVT.Check_Shipping_Tolerances
749: ( x_return_status => x_return_status,
750: x_msg_count => x_msg_count,
751: x_msg_data => x_msg_data,
752: x_allowed => l_allowed,
1242: */
1243:
1244: /* HAW 3387829 */
1245: -- Since Non-Inv and Non-Lot are executing the same procedure:
1246: --- GMI_PICK_WAVE_CONFIRM_PVT.BALANCE_NONCTL_INV_TRAN, let's call it once for
1247: -- both of them and call New_txn_nonctl_CUR as well.
1248: -- Earlier there was no call to New_txn_nonctl_CUR for non-inventory items
1249: -- and trans_id was never popualated which caused the issue reported in
1250: -- bug 3387829
1249: -- and trans_id was never popualated which caused the issue reported in
1250: -- bug 3387829
1251:
1252: /* Bug 2901317 - Treating non-inventory as non-controlled item */
1253: gmi_reservation_util.println('Calling GMI_PICK_WAVE_CONFIRM_PVT.BALANCE_NONCTL_INV_TRAN');
1254: GMI_PICK_WAVE_CONFIRM_PVT.BALANCE_NONCTL_INV_TRAN
1255: (
1256: p_mo_line_rec => l_mo_line_rec ,
1257: p_commit => p_commit,
1250: -- bug 3387829
1251:
1252: /* Bug 2901317 - Treating non-inventory as non-controlled item */
1253: gmi_reservation_util.println('Calling GMI_PICK_WAVE_CONFIRM_PVT.BALANCE_NONCTL_INV_TRAN');
1254: GMI_PICK_WAVE_CONFIRM_PVT.BALANCE_NONCTL_INV_TRAN
1255: (
1256: p_mo_line_rec => l_mo_line_rec ,
1257: p_commit => p_commit,
1258: p_item_id => l_ic_item_mst_rec.item_id,
1913:
1914:
1915: BEGIN
1916:
1917: gmi_reservation_util.println('Inside GMI_PICK_WAVE_CONFIRM_PVT.check_quantity_to_pick');
1918: OPEN c_detail_info(p_order_line_id);
1919: FETCH c_detail_info INTO l_detail_info;
1920: l_found_flag := c_detail_info%FOUND;
1921: CLOSE c_detail_info;
2190: l_ato_line_id NUMBER;
2191:
2192: BEGIN
2193:
2194: gmi_reservation_util.println('Entering GMI_PICK_WAVE_CONFIRM_PVT.Get_Min_Max_Tolerance_Quantity');
2195:
2196: x_return_status := FND_API.G_RET_STS_SUCCESS;
2197: /*
2198: IF NOT FND_API.Compatible_API_Call
2324: -- HW print qty2 for OPM
2325: gmi_reservation_util.println('Return Min remaining quantity2 : '||x_min_remaining_quantity2);
2326: gmi_reservation_util.println('Return Max remaining quantity2 : '||x_max_remaining_quantity2);
2327:
2328: gmi_reservation_util.println('Exiting GMI_PICK_WAVE_CONFIRM_PVT.Get_Min_Max_Tolerance_Quantity '||x_return_status);
2329:
2330: EXCEPTION
2331:
2332: WHEN NO_DATA_FOUND THEN
2584: IF (l_noninv_ind = 1) THEN
2585: GMI_Reservation_Util.PrintLn('Non Inventory Item');
2586: IF (p_requested_qty < ABS(l_dflt_nonctl_tran_rec.trans_qty)) THEN
2587:
2588: GMI_PICK_WAVE_CONFIRM_PVT.BALANCE_NONINV_TRAN
2589: (
2590: p_dflt_nonctl_tran_rec => l_dflt_nonctl_tran_rec,
2591: p_commit => p_commit,
2592: p_requested_qty => p_requested_qty,
2919: , p_manual_pick IN VARCHAR2 DEFAULT NULL
2920: )
2921: IS
2922: BEGIN
2923: GMI_Pick_Wave_Confirm_PVT.Pick_Confirm(
2924: p_api_version_number => 1.0,
2925: p_init_msg_lst => FND_API.G_FALSE,
2926: p_validation_flag => FND_API.G_VALID_LEVEL_FULL,
2927: p_commit => p_commit,
3005: GMI_Reservation_Util.PrintLn('pending_quantity2 - '||p_shipping_attr(1).pending_quantity2);
3006: END dump_shp_attrb_data;
3007:
3008:
3009: END GMI_PICK_WAVE_CONFIRM_PVT;