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.GMI_PICK_RELEASE_PVT dependencies on GMI_PICK_RELEASE_PVT

Line 1: PACKAGE BODY GMI_Pick_Release_PVT AS

1: PACKAGE BODY GMI_Pick_Release_PVT AS
2: /* $Header: GMIVPKRB.pls 120.0 2005/05/25 16:00:43 appldev noship $ */
3: /* +=========================================================================+
4: | Copyright (c) 2000 Oracle Corporation |
5: | TVP, Reading, England |

Line 22: API Name : GMI_Pick_Release_PVT

18: | HISTORY |
19: | 03-May-2000 odaboval Created |
20: | |
21: +=========================================================================+
22: API Name : GMI_Pick_Release_PVT
23: Type : Global
24: -
25: Pre-reqs : N/A
26: Parameters: Per function

Line 32: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMI_Pick_Release_PVT';

28: Current Vers : 1.0
29: */
30:
31:
32: G_PKG_NAME CONSTANT VARCHAR2(30) := 'GMI_Pick_Release_PVT';
33:
34: PROCEDURE Process_Line
35: (
36: p_api_version IN NUMBER

Line 141: GMI_Reservation_Util.PrintLn('Entering_GMI_Pick_Release_PVT.');

137:
138:
139: BEGIN
140: gmi_reservation_util.println('Value of p_grouping_rule_idp_grouping_rule_id in process_line is '||p_grouping_rule_id);
141: GMI_Reservation_Util.PrintLn('Entering_GMI_Pick_Release_PVT.');
142:
143: SAVEPOINT Process_Line_PVT;
144: /* Standard Call to check for call compatibility */
145: IF NOT fnd_api.Compatible_API_Call(l_api_version

Line 207: GMI_Reservation_Util.PrintLn('Exiting_GMI_Pick_Release_PVT. fully detailed no Error');

203:
204:
205: /* Return success immediately if the line is already fully detailed */
206: IF NVL(p_mo_line_rec.quantity_detailed, 0) >= NVL(p_mo_line_rec.quantity, 0) THEN
207: GMI_Reservation_Util.PrintLn('Exiting_GMI_Pick_Release_PVT. fully detailed no Error');
208: /* odab removed it in order to get the x_detail_rec_count */
209: /* odab return; */
210: /* NEED TO put it back ( for performance) */
211: END IF;

Line 223: GMI_Reservation_Util.PrintLn('Entering_GMI_Pick_Release_PVT. Before Set_Org_Client_Info, ps_mode='||l_pick_slip_mode);

219: ELSE
220: l_pick_slip_mode := p_print_mode;
221: END IF;
222:
223: GMI_Reservation_Util.PrintLn('Entering_GMI_Pick_Release_PVT. Before Set_Org_Client_Info, ps_mode='||l_pick_slip_mode);
224: inv_project.set_org_client_info(x_return_status, p_mo_line_Rec.organization_id);
225:
226: GMI_Reservation_Util.PrintLn('GMI_Pick_Release_PVT. Before Get_Delivery_Details');
227: /* Determine the demand source and delivery information for the given line. */

Line 226: GMI_Reservation_Util.PrintLn('GMI_Pick_Release_PVT. Before Get_Delivery_Details');

222:
223: GMI_Reservation_Util.PrintLn('Entering_GMI_Pick_Release_PVT. Before Set_Org_Client_Info, ps_mode='||l_pick_slip_mode);
224: inv_project.set_org_client_info(x_return_status, p_mo_line_Rec.organization_id);
225:
226: GMI_Reservation_Util.PrintLn('GMI_Pick_Release_PVT. Before Get_Delivery_Details');
227: /* Determine the demand source and delivery information for the given line. */
228: GMI_Pick_Release_Util.Get_Delivery_Details(
229: p_mo_line_id => p_mo_line_rec.line_id
230: , x_inv_delivery_details => l_demand_info

Line 235: GMI_Reservation_Util.PrintLn('GMI_Pick_Release_PVT. To find : Item='||p_mo_line_rec.inventory_item_id||', org_id='||p_mo_line_rec.organization_id);

231: , x_return_status => x_return_status
232: , x_msg_count => x_msg_count
233: , x_msg_data => x_msg_data);
234:
235: GMI_Reservation_Util.PrintLn('GMI_Pick_Release_PVT. To find : Item='||p_mo_line_rec.inventory_item_id||', org_id='||p_mo_line_rec.organization_id);
236: OPEN c_mtl_items( p_mo_line_rec.organization_id
237: , p_mo_line_rec.inventory_item_id);
238: FETCH c_mtl_items
239: INTO l_reservable_type;

Line 251: GMI_Reservation_Util.PrintLn('GMI_Pick_Release_PVT. To find : SecondInventory, from_subInv_code='||p_mo_line_rec.from_subinventory_code);

247: RAISE FND_API.G_EXC_ERROR;
248: END IF;
249: CLOSE c_mtl_items;
250:
251: GMI_Reservation_Util.PrintLn('GMI_Pick_Release_PVT. To find : SecondInventory, from_subInv_code='||p_mo_line_rec.from_subinventory_code);
252:
253: IF ( p_mo_line_rec.from_subinventory_code is not NULL )
254: THEN
255: OPEN c_second_inventory( p_mo_line_rec.organization_id

Line 271: GMI_Reservation_Util.PrintLn('GMI_Pick_Release_PVT. To find : TransactionType, TransactionType='||p_mo_line_rec.transaction_type_id);

267: END IF;
268: CLOSE c_second_inventory;
269: END IF;
270:
271: GMI_Reservation_Util.PrintLn('GMI_Pick_Release_PVT. To find : TransactionType, TransactionType='||p_mo_line_rec.transaction_type_id);
272:
273: OPEN c_transaction_type(p_mo_line_rec.transaction_type_id);
274: FETCH c_transaction_type
275: INTO l_demand_source_type;

Line 286: GMI_Reservation_Util.PrintLn('GMI_Pick_Release_PVT. Transaction Type found!');

282: RAISE FND_API.G_EXC_ERROR;
283: END IF;
284: CLOSE c_transaction_type;
285:
286: GMI_Reservation_Util.PrintLn('GMI_Pick_Release_PVT. Transaction Type found!');
287:
288: /* Compute the MTL_SALES_ORDERS header ID to use when dealing with reservations.*/
289: l_mso_header_id := INV_SALESORDER.GET_SALESORDER_FOR_OEHEADER(l_demand_info.oe_header_id);
290: IF ( l_mso_header_id IS NULL ) THEN

Line 367: FND_MESSAGE.Set_Token('WHERE', 'GMI_Pick_Release_PVT.Process_Line');

363: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
364: ROLLBACK TO Process_Line_PVT;
365: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
366: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Reallocate');
367: FND_MESSAGE.Set_Token('WHERE', 'GMI_Pick_Release_PVT.Process_Line');
368: FND_MSG_PUB.Add;
369: RAISE FND_API.G_EXC_ERROR;
370: END IF;
371: END LOOP;

Line 428: FND_MESSAGE.Set_Token('WHERE', 'GMI_Pick_Release_PVT.Process_Line');

424: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
425: ROLLBACK TO Process_Line_PVT;
426: FND_MESSAGE.SET_NAME('GMI','GMI_ERROR');
427: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Pick_Release_Util.Create_Pick_Slip_and_Print');
428: FND_MESSAGE.Set_Token('WHERE', 'GMI_Pick_Release_PVT.Process_Line');
429: FND_MSG_PUB.Add;
430: RAISE FND_API.G_EXC_ERROR;
431: END IF;
432:

Line 434: GMI_Reservation_Util.PrintLn('In the end of GMI_Pick_Release_PVT.Process_Line : NO Error, detail_rec_count='||x_detail_rec_count);

430: RAISE FND_API.G_EXC_ERROR;
431: END IF;
432:
433:
434: GMI_Reservation_Util.PrintLn('In the end of GMI_Pick_Release_PVT.Process_Line : NO Error, detail_rec_count='||x_detail_rec_count);
435:
436:
437: EXCEPTION
438: WHEN FND_API.G_EXC_ERROR THEN

Line 464: END GMI_Pick_Release_PVT;

460:
461:
462: END Process_Line;
463:
464: END GMI_Pick_Release_PVT;