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_RESERVATION_UTIL

Line 140: gmi_reservation_util.println('Value of p_grouping_rule_idp_grouping_rule_id in process_line is '||p_grouping_rule_id);

136: l_GML$DEL_ALC_BEFORE_AUTO VARCHAR2(255) DEFAULT NVL(FND_PROFILE.VALUE('GML$DEL_ALC_BEFORE_AUTO'),' ') ;
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 */

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 158: GMI_Reservation_Util.PrintLn('l_p_allow_delete = ' || l_p_allow_delete);

154:
155: --==================================================================
156:
157: l_p_allow_delete := p_allow_delete;
158: GMI_Reservation_Util.PrintLn('l_p_allow_delete = ' || l_p_allow_delete);
159:
160: GMI_Reservation_Util.PrintLn('l_IC$DEFAULT_LOCT = ' || l_IC$DEFAULT_LOCT) ;
161: GMI_Reservation_Util.PrintLn('l_GML$DEL_ALC_BEFORE_AUTO = ' || l_GML$DEL_ALC_BEFORE_AUTO) ;
162:

Line 160: GMI_Reservation_Util.PrintLn('l_IC$DEFAULT_LOCT = ' || l_IC$DEFAULT_LOCT) ;

156:
157: l_p_allow_delete := p_allow_delete;
158: GMI_Reservation_Util.PrintLn('l_p_allow_delete = ' || l_p_allow_delete);
159:
160: GMI_Reservation_Util.PrintLn('l_IC$DEFAULT_LOCT = ' || l_IC$DEFAULT_LOCT) ;
161: GMI_Reservation_Util.PrintLn('l_GML$DEL_ALC_BEFORE_AUTO = ' || l_GML$DEL_ALC_BEFORE_AUTO) ;
162:
163: IF (UPPER(l_p_allow_delete) = 'YES')
164: OR (l_p_allow_delete IS NULL AND UPPER(l_GML$DEL_ALC_BEFORE_AUTO) = 'YES')

Line 161: GMI_Reservation_Util.PrintLn('l_GML$DEL_ALC_BEFORE_AUTO = ' || l_GML$DEL_ALC_BEFORE_AUTO) ;

157: l_p_allow_delete := p_allow_delete;
158: GMI_Reservation_Util.PrintLn('l_p_allow_delete = ' || l_p_allow_delete);
159:
160: GMI_Reservation_Util.PrintLn('l_IC$DEFAULT_LOCT = ' || l_IC$DEFAULT_LOCT) ;
161: GMI_Reservation_Util.PrintLn('l_GML$DEL_ALC_BEFORE_AUTO = ' || l_GML$DEL_ALC_BEFORE_AUTO) ;
162:
163: IF (UPPER(l_p_allow_delete) = 'YES')
164: OR (l_p_allow_delete IS NULL AND UPPER(l_GML$DEL_ALC_BEFORE_AUTO) = 'YES')
165: THEN

Line 174: GMI_Reservation_Util.PrintLn('l_tran_rec.trans_id = ' || l_tran_rec.trans_id);

170: WHILE c_get_trans_id%FOUND LOOP
171:
172: l_tran_rec.trans_id := ic_tran_tbl_row.trans_id;
173:
174: GMI_Reservation_Util.PrintLn('l_tran_rec.trans_id = ' || l_tran_rec.trans_id);
175:
176: GMI_TRANS_ENGINE_PUB.delete_pending_transaction
177: ( 1
178: , FND_API.G_FALSE

Line 188: GMI_Reservation_Util.PrintLn('return from DELETE PENDING TRANS x_return_status = ' || x_return_status);

184: , x_msg_count
185: , x_msg_data
186: );
187:
188: GMI_Reservation_Util.PrintLn('return from DELETE PENDING TRANS x_return_status = ' || x_return_status);
189:
190: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
191: THEN
192: GMI_RESERVATION_UTIL.PrintLn('Error returned by Delete_Pending_Transaction');

Line 192: GMI_RESERVATION_UTIL.PrintLn('Error returned by Delete_Pending_Transaction');

188: GMI_Reservation_Util.PrintLn('return from DELETE PENDING TRANS x_return_status = ' || x_return_status);
189:
190: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
191: THEN
192: GMI_RESERVATION_UTIL.PrintLn('Error returned by Delete_Pending_Transaction');
193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
194: END IF;
195: FETCH c_get_trans_id INTO ic_tran_tbl_row;
196: END LOOP;

Line 200: GMI_Reservation_Util.PrintLn('outside of lizloop');

196: END LOOP;
197: CLOSE c_get_trans_id;
198: END IF;
199: END IF ;
200: GMI_Reservation_Util.PrintLn('outside of lizloop');
201:
202: --==================================================================
203:
204:

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 300: GMI_Reservation_Util.PrintLn('p_mo_line_rec.unit_number is ' || p_mo_line_Rec.unit_number);

296:
297: /* find out the corresponding delivery detail id to fill in ic_tran_pnd */
298: /* this could result more than 1 delivery, need to do a loop for the deliveries */
299:
300: GMI_Reservation_Util.PrintLn('p_mo_line_rec.unit_number is ' || p_mo_line_Rec.unit_number);
301: /* Retrieve reservation information for that demand source */
302: /* only if the item is reservable */
303: IF( l_reservable_type = 1 AND nvl(l_sub_reservable_type, 1) = 1 )
304: THEN

Line 306: GMI_Reservation_Util.PrintLn('(opm_dbg) Realloc reservation info for demand source :');

302: /* only if the item is reservable */
303: IF( l_reservable_type = 1 AND nvl(l_sub_reservable_type, 1) = 1 )
304: THEN
305: FOR delivery IN c_get_delivery_detail LOOP
306: GMI_Reservation_Util.PrintLn('(opm_dbg) Realloc reservation info for demand source :');
307: l_qry_rsv_rec.organization_id := p_mo_line_rec.organization_id;
308: l_qry_rsv_rec.inventory_item_id := p_mo_line_rec.inventory_item_id;
309: l_qry_rsv_rec.demand_source_type_id := l_demand_source_type;
310: l_qry_rsv_rec.demand_source_header_id := l_mso_header_id;

Line 338: GMI_Reservation_Util.PrintLn('(opm_dbg) organization_id='||l_qry_rsv_rec.organization_id);

334: l_qry_rsv_rec.reservation_quantity := 0;
335: l_qry_rsv_rec.attribute2 := 0;
336: END IF;
337:
338: GMI_Reservation_Util.PrintLn('(opm_dbg) organization_id='||l_qry_rsv_rec.organization_id);
339: GMI_Reservation_Util.PrintLn('(opm_dbg) inv_item_id='||l_qry_rsv_rec.inventory_item_id);
340: GMI_Reservation_Util.PrintLn('(opm_dbg) source_header_id='||l_qry_rsv_rec.demand_source_header_id);
341: GMI_Reservation_Util.PrintLn('(opm_dbg) source_line_id='||l_qry_rsv_rec.demand_source_line_id);
342: GMI_Reservation_Util.PrintLn('(opm_dbg) Res_UOM_code='||l_qry_rsv_rec.reservation_uom_code);

Line 339: GMI_Reservation_Util.PrintLn('(opm_dbg) inv_item_id='||l_qry_rsv_rec.inventory_item_id);

335: l_qry_rsv_rec.attribute2 := 0;
336: END IF;
337:
338: GMI_Reservation_Util.PrintLn('(opm_dbg) organization_id='||l_qry_rsv_rec.organization_id);
339: GMI_Reservation_Util.PrintLn('(opm_dbg) inv_item_id='||l_qry_rsv_rec.inventory_item_id);
340: GMI_Reservation_Util.PrintLn('(opm_dbg) source_header_id='||l_qry_rsv_rec.demand_source_header_id);
341: GMI_Reservation_Util.PrintLn('(opm_dbg) source_line_id='||l_qry_rsv_rec.demand_source_line_id);
342: GMI_Reservation_Util.PrintLn('(opm_dbg) Res_UOM_code='||l_qry_rsv_rec.reservation_uom_code);
343: GMI_Reservation_Util.PrintLn('(opm_dbg) Shedule_ship_date='||l_qry_rsv_rec.requirement_date);

Line 340: GMI_Reservation_Util.PrintLn('(opm_dbg) source_header_id='||l_qry_rsv_rec.demand_source_header_id);

336: END IF;
337:
338: GMI_Reservation_Util.PrintLn('(opm_dbg) organization_id='||l_qry_rsv_rec.organization_id);
339: GMI_Reservation_Util.PrintLn('(opm_dbg) inv_item_id='||l_qry_rsv_rec.inventory_item_id);
340: GMI_Reservation_Util.PrintLn('(opm_dbg) source_header_id='||l_qry_rsv_rec.demand_source_header_id);
341: GMI_Reservation_Util.PrintLn('(opm_dbg) source_line_id='||l_qry_rsv_rec.demand_source_line_id);
342: GMI_Reservation_Util.PrintLn('(opm_dbg) Res_UOM_code='||l_qry_rsv_rec.reservation_uom_code);
343: GMI_Reservation_Util.PrintLn('(opm_dbg) Shedule_ship_date='||l_qry_rsv_rec.requirement_date);
344:

Line 341: GMI_Reservation_Util.PrintLn('(opm_dbg) source_line_id='||l_qry_rsv_rec.demand_source_line_id);

337:
338: GMI_Reservation_Util.PrintLn('(opm_dbg) organization_id='||l_qry_rsv_rec.organization_id);
339: GMI_Reservation_Util.PrintLn('(opm_dbg) inv_item_id='||l_qry_rsv_rec.inventory_item_id);
340: GMI_Reservation_Util.PrintLn('(opm_dbg) source_header_id='||l_qry_rsv_rec.demand_source_header_id);
341: GMI_Reservation_Util.PrintLn('(opm_dbg) source_line_id='||l_qry_rsv_rec.demand_source_line_id);
342: GMI_Reservation_Util.PrintLn('(opm_dbg) Res_UOM_code='||l_qry_rsv_rec.reservation_uom_code);
343: GMI_Reservation_Util.PrintLn('(opm_dbg) Shedule_ship_date='||l_qry_rsv_rec.requirement_date);
344:
345: GMI_Reservation_Util.PrintLn('UOM_CODE='||p_mo_line_rec.uom_code);

Line 342: GMI_Reservation_Util.PrintLn('(opm_dbg) Res_UOM_code='||l_qry_rsv_rec.reservation_uom_code);

338: GMI_Reservation_Util.PrintLn('(opm_dbg) organization_id='||l_qry_rsv_rec.organization_id);
339: GMI_Reservation_Util.PrintLn('(opm_dbg) inv_item_id='||l_qry_rsv_rec.inventory_item_id);
340: GMI_Reservation_Util.PrintLn('(opm_dbg) source_header_id='||l_qry_rsv_rec.demand_source_header_id);
341: GMI_Reservation_Util.PrintLn('(opm_dbg) source_line_id='||l_qry_rsv_rec.demand_source_line_id);
342: GMI_Reservation_Util.PrintLn('(opm_dbg) Res_UOM_code='||l_qry_rsv_rec.reservation_uom_code);
343: GMI_Reservation_Util.PrintLn('(opm_dbg) Shedule_ship_date='||l_qry_rsv_rec.requirement_date);
344:
345: GMI_Reservation_Util.PrintLn('UOM_CODE='||p_mo_line_rec.uom_code);
346: GMI_Reservation_Util.PrintLn('SO line qty='||p_mo_line_rec.quantity);

Line 343: GMI_Reservation_Util.PrintLn('(opm_dbg) Shedule_ship_date='||l_qry_rsv_rec.requirement_date);

339: GMI_Reservation_Util.PrintLn('(opm_dbg) inv_item_id='||l_qry_rsv_rec.inventory_item_id);
340: GMI_Reservation_Util.PrintLn('(opm_dbg) source_header_id='||l_qry_rsv_rec.demand_source_header_id);
341: GMI_Reservation_Util.PrintLn('(opm_dbg) source_line_id='||l_qry_rsv_rec.demand_source_line_id);
342: GMI_Reservation_Util.PrintLn('(opm_dbg) Res_UOM_code='||l_qry_rsv_rec.reservation_uom_code);
343: GMI_Reservation_Util.PrintLn('(opm_dbg) Shedule_ship_date='||l_qry_rsv_rec.requirement_date);
344:
345: GMI_Reservation_Util.PrintLn('UOM_CODE='||p_mo_line_rec.uom_code);
346: GMI_Reservation_Util.PrintLn('SO line qty='||p_mo_line_rec.quantity);
347: GMI_Reservation_Util.PrintLn(' attribute1='||l_qry_rsv_rec.attribute1);

Line 345: GMI_Reservation_Util.PrintLn('UOM_CODE='||p_mo_line_rec.uom_code);

341: GMI_Reservation_Util.PrintLn('(opm_dbg) source_line_id='||l_qry_rsv_rec.demand_source_line_id);
342: GMI_Reservation_Util.PrintLn('(opm_dbg) Res_UOM_code='||l_qry_rsv_rec.reservation_uom_code);
343: GMI_Reservation_Util.PrintLn('(opm_dbg) Shedule_ship_date='||l_qry_rsv_rec.requirement_date);
344:
345: GMI_Reservation_Util.PrintLn('UOM_CODE='||p_mo_line_rec.uom_code);
346: GMI_Reservation_Util.PrintLn('SO line qty='||p_mo_line_rec.quantity);
347: GMI_Reservation_Util.PrintLn(' attribute1='||l_qry_rsv_rec.attribute1);
348: GMI_Reservation_Util.PrintLn(' attribute2='||l_qry_rsv_rec.attribute2);
349: GMI_Reservation_Util.PrintLn(' attribute3='||l_qry_rsv_rec.attribute3);

Line 346: GMI_Reservation_Util.PrintLn('SO line qty='||p_mo_line_rec.quantity);

342: GMI_Reservation_Util.PrintLn('(opm_dbg) Res_UOM_code='||l_qry_rsv_rec.reservation_uom_code);
343: GMI_Reservation_Util.PrintLn('(opm_dbg) Shedule_ship_date='||l_qry_rsv_rec.requirement_date);
344:
345: GMI_Reservation_Util.PrintLn('UOM_CODE='||p_mo_line_rec.uom_code);
346: GMI_Reservation_Util.PrintLn('SO line qty='||p_mo_line_rec.quantity);
347: GMI_Reservation_Util.PrintLn(' attribute1='||l_qry_rsv_rec.attribute1);
348: GMI_Reservation_Util.PrintLn(' attribute2='||l_qry_rsv_rec.attribute2);
349: GMI_Reservation_Util.PrintLn(' attribute3='||l_qry_rsv_rec.attribute3);
350: GMI_Reservation_Util.PrintLn(' attribute4='||l_qry_rsv_rec.attribute4);

Line 347: GMI_Reservation_Util.PrintLn(' attribute1='||l_qry_rsv_rec.attribute1);

343: GMI_Reservation_Util.PrintLn('(opm_dbg) Shedule_ship_date='||l_qry_rsv_rec.requirement_date);
344:
345: GMI_Reservation_Util.PrintLn('UOM_CODE='||p_mo_line_rec.uom_code);
346: GMI_Reservation_Util.PrintLn('SO line qty='||p_mo_line_rec.quantity);
347: GMI_Reservation_Util.PrintLn(' attribute1='||l_qry_rsv_rec.attribute1);
348: GMI_Reservation_Util.PrintLn(' attribute2='||l_qry_rsv_rec.attribute2);
349: GMI_Reservation_Util.PrintLn(' attribute3='||l_qry_rsv_rec.attribute3);
350: GMI_Reservation_Util.PrintLn(' attribute4='||l_qry_rsv_rec.attribute4);
351:

Line 348: GMI_Reservation_Util.PrintLn(' attribute2='||l_qry_rsv_rec.attribute2);

344:
345: GMI_Reservation_Util.PrintLn('UOM_CODE='||p_mo_line_rec.uom_code);
346: GMI_Reservation_Util.PrintLn('SO line qty='||p_mo_line_rec.quantity);
347: GMI_Reservation_Util.PrintLn(' attribute1='||l_qry_rsv_rec.attribute1);
348: GMI_Reservation_Util.PrintLn(' attribute2='||l_qry_rsv_rec.attribute2);
349: GMI_Reservation_Util.PrintLn(' attribute3='||l_qry_rsv_rec.attribute3);
350: GMI_Reservation_Util.PrintLn(' attribute4='||l_qry_rsv_rec.attribute4);
351:
352: /* l_qry_rsv_rec.ship_ready_flag := 2; -- only records which are not ship ready */

Line 349: GMI_Reservation_Util.PrintLn(' attribute3='||l_qry_rsv_rec.attribute3);

345: GMI_Reservation_Util.PrintLn('UOM_CODE='||p_mo_line_rec.uom_code);
346: GMI_Reservation_Util.PrintLn('SO line qty='||p_mo_line_rec.quantity);
347: GMI_Reservation_Util.PrintLn(' attribute1='||l_qry_rsv_rec.attribute1);
348: GMI_Reservation_Util.PrintLn(' attribute2='||l_qry_rsv_rec.attribute2);
349: GMI_Reservation_Util.PrintLn(' attribute3='||l_qry_rsv_rec.attribute3);
350: GMI_Reservation_Util.PrintLn(' attribute4='||l_qry_rsv_rec.attribute4);
351:
352: /* l_qry_rsv_rec.ship_ready_flag := 2; -- only records which are not ship ready */
353:

Line 350: GMI_Reservation_Util.PrintLn(' attribute4='||l_qry_rsv_rec.attribute4);

346: GMI_Reservation_Util.PrintLn('SO line qty='||p_mo_line_rec.quantity);
347: GMI_Reservation_Util.PrintLn(' attribute1='||l_qry_rsv_rec.attribute1);
348: GMI_Reservation_Util.PrintLn(' attribute2='||l_qry_rsv_rec.attribute2);
349: GMI_Reservation_Util.PrintLn(' attribute3='||l_qry_rsv_rec.attribute3);
350: GMI_Reservation_Util.PrintLn(' attribute4='||l_qry_rsv_rec.attribute4);
351:
352: /* l_qry_rsv_rec.ship_ready_flag := 2; -- only records which are not ship ready */
353:
354: GMI_Reservation_Util.Reallocate(

Line 354: GMI_Reservation_Util.Reallocate(

350: GMI_Reservation_Util.PrintLn(' attribute4='||l_qry_rsv_rec.attribute4);
351:
352: /* l_qry_rsv_rec.ship_ready_flag := 2; -- only records which are not ship ready */
353:
354: GMI_Reservation_Util.Reallocate(
355: p_query_input => l_qry_rsv_rec
356: , x_allocated_trans => l_allocated_transactions
357: , x_allocated_qty => l_quantity_detailed
358: , x_return_status => x_return_status

Line 366: FND_MESSAGE.Set_Token('BY_PROC', 'GMI_Reservation_Util.Reallocate');

362: /* Return an error if the Reallocation call failed */
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;

Line 381: GMI_Reservation_Util.PrintLn('ictrans count='||GMI_Reservation_Util.ic_tran_rec_tbl.COUNT);

377: /* Update the detailed quantity (and if possible, the sourcing information) */
378: /* of the Move Order Line */
379: /* If the move order line is not fully detailed, update the */
380: /* return status as appropriate. */
381: GMI_Reservation_Util.PrintLn('ictrans count='||GMI_Reservation_Util.ic_tran_rec_tbl.COUNT);
382: GMI_Reservation_Util.PrintLn('qty detailed='||l_quantity_detailed);
383: GMI_Reservation_Util.PrintLn('mo_line.primary_qty='||p_mo_line_rec.primary_quantity);
384: /* I think that I don't have to return an error when I can't Pick Full !!! (odab) */
385: /* IF l_quantity_detailed < p_mo_line_rec.primary_quantity THEN */

Line 382: GMI_Reservation_Util.PrintLn('qty detailed='||l_quantity_detailed);

378: /* of the Move Order Line */
379: /* If the move order line is not fully detailed, update the */
380: /* return status as appropriate. */
381: GMI_Reservation_Util.PrintLn('ictrans count='||GMI_Reservation_Util.ic_tran_rec_tbl.COUNT);
382: GMI_Reservation_Util.PrintLn('qty detailed='||l_quantity_detailed);
383: GMI_Reservation_Util.PrintLn('mo_line.primary_qty='||p_mo_line_rec.primary_quantity);
384: /* I think that I don't have to return an error when I can't Pick Full !!! (odab) */
385: /* IF l_quantity_detailed < p_mo_line_rec.primary_quantity THEN */
386: /* GMI_Reservation_Util.PrintLn('qty detailed < mo_line.primary_qty : Couldnt Pick Full'); */

Line 383: GMI_Reservation_Util.PrintLn('mo_line.primary_qty='||p_mo_line_rec.primary_quantity);

379: /* If the move order line is not fully detailed, update the */
380: /* return status as appropriate. */
381: GMI_Reservation_Util.PrintLn('ictrans count='||GMI_Reservation_Util.ic_tran_rec_tbl.COUNT);
382: GMI_Reservation_Util.PrintLn('qty detailed='||l_quantity_detailed);
383: GMI_Reservation_Util.PrintLn('mo_line.primary_qty='||p_mo_line_rec.primary_quantity);
384: /* I think that I don't have to return an error when I can't Pick Full !!! (odab) */
385: /* IF l_quantity_detailed < p_mo_line_rec.primary_quantity THEN */
386: /* GMI_Reservation_Util.PrintLn('qty detailed < mo_line.primary_qty : Couldnt Pick Full'); */
387: /* ROLLBACK TO Process_Line_PVT; */

Line 386: /* GMI_Reservation_Util.PrintLn('qty detailed < mo_line.primary_qty : Couldnt Pick Full'); */

382: GMI_Reservation_Util.PrintLn('qty detailed='||l_quantity_detailed);
383: GMI_Reservation_Util.PrintLn('mo_line.primary_qty='||p_mo_line_rec.primary_quantity);
384: /* I think that I don't have to return an error when I can't Pick Full !!! (odab) */
385: /* IF l_quantity_detailed < p_mo_line_rec.primary_quantity THEN */
386: /* GMI_Reservation_Util.PrintLn('qty detailed < mo_line.primary_qty : Couldnt Pick Full'); */
387: /* ROLLBACK TO Process_Line_PVT; */
388: /* FND_MESSAGE.SET_NAME('INV','INV_COULD_NOT_PICK_FULL'); */
389: /* FND_MSG_PUB.Add; */
390: /* RAISE fnd_api.g_exc_unexpected_error; */

Line 405: gmi_reservation_util.println('Value of p_grouping_rule_id in Process Line before update_row is '||p_grouping_rule_id);

401: l_mo_line_rec.quantity_detailed := nvl(l_quantity_detailed, 0) + NVL(l_mo_line_rec.quantity_delivered, 0);
402: l_mo_line_rec.txn_source_id := l_mso_header_id;
403: l_mo_line_rec.txn_source_line_id := l_demand_info.oe_line_id;
404:
405: gmi_reservation_util.println('Value of p_grouping_rule_id in Process Line before update_row is '||p_grouping_rule_id);
406: GMI_Reservation_Util.PrintLn('calling GMI_Move_Order_line_UTIL.Update_Row');
407: GMI_Move_Order_Line_UTIL.Update_Row(l_mo_line_rec);
408:
409: gmi_reservation_util.println('Value of p_grouping_rule_id in process_line before calling Create_Pick_Slip_and_Print is '||p_grouping_rule_id);

Line 406: GMI_Reservation_Util.PrintLn('calling GMI_Move_Order_line_UTIL.Update_Row');

402: l_mo_line_rec.txn_source_id := l_mso_header_id;
403: l_mo_line_rec.txn_source_line_id := l_demand_info.oe_line_id;
404:
405: gmi_reservation_util.println('Value of p_grouping_rule_id in Process Line before update_row is '||p_grouping_rule_id);
406: GMI_Reservation_Util.PrintLn('calling GMI_Move_Order_line_UTIL.Update_Row');
407: GMI_Move_Order_Line_UTIL.Update_Row(l_mo_line_rec);
408:
409: gmi_reservation_util.println('Value of p_grouping_rule_id in process_line before calling Create_Pick_Slip_and_Print is '||p_grouping_rule_id);
410: /* =======================================================================================*/

Line 409: gmi_reservation_util.println('Value of p_grouping_rule_id in process_line before calling Create_Pick_Slip_and_Print is '||p_grouping_rule_id);

405: gmi_reservation_util.println('Value of p_grouping_rule_id in Process Line before update_row is '||p_grouping_rule_id);
406: GMI_Reservation_Util.PrintLn('calling GMI_Move_Order_line_UTIL.Update_Row');
407: GMI_Move_Order_Line_UTIL.Update_Row(l_mo_line_rec);
408:
409: gmi_reservation_util.println('Value of p_grouping_rule_id in process_line before calling Create_Pick_Slip_and_Print is '||p_grouping_rule_id);
410: /* =======================================================================================*/
411: /* Pick Slip (data + printing) */
412: /* ======================================================================================= */
413: GMI_Pick_Release_Util.Create_Pick_Slip_and_Print(

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