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_AUTO_ALLOC_BATCH_PKG dependencies on GMI_RESERVATION_UTIL

Line 151: GMI_RESERVATION_UTIL.PrintLn('FND_API.compatible_api_call failed');

147: p_api_version,
148: l_api_name,
149: G_PKG_NAME)
150: THEN
151: GMI_RESERVATION_UTIL.PrintLn('FND_API.compatible_api_call failed');
152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
153: END IF;
154:
155: /* Check p_init_msg_list

Line 162: GMI_RESERVATION_UTIL.PrintLn (' After initialize IN Auto_allocation_batch');

158: THEN
159: FND_MSG_PUB.initialize;
160: END IF;
161:
162: GMI_RESERVATION_UTIL.PrintLn (' After initialize IN Auto_allocation_batch');
163:
164: IF( NVL(p_batch_id,0) = 0 ) THEN
165: GMI_RESERVATION_UTIL.PrintLn('Batch id is missing');
166: FND_MESSAGE.Set_Name('GMI','Missing');

Line 165: GMI_RESERVATION_UTIL.PrintLn('Batch id is missing');

161:
162: GMI_RESERVATION_UTIL.PrintLn (' After initialize IN Auto_allocation_batch');
163:
164: IF( NVL(p_batch_id,0) = 0 ) THEN
165: GMI_RESERVATION_UTIL.PrintLn('Batch id is missing');
166: FND_MESSAGE.Set_Name('GMI','Missing');
167: FND_MESSAGE.Set_Token('MISSING', 'Batch_Id');
168: FND_MSG_PUB.Add;
169: RAISE FND_API.G_EXC_ERROR;

Line 177: GMI_RESERVATION_UTIL.PrintLn('No record in the batch table for batch id: '|| p_batch_id );

173: FETCH get_batch_rec_cur INTO l_batch_rec;
174:
175: IF(get_batch_rec_cur%NOTFOUND) THEN
176: CLOSE get_batch_rec_cur;
177: GMI_RESERVATION_UTIL.PrintLn('No record in the batch table for batch id: '|| p_batch_id );
178: FND_MESSAGE.Set_Name('GMI','Missing');
179: FND_MESSAGE.Set_Token('Missing','Batch_id');
180: FND_MSG_PUB.Add;
181: RAISE FND_API.G_EXC_ERROR;

Line 186: GMI_RESERVATION_UTIL.PrintLn(' After Fetching The Batchrec');

182: END IF;
183:
184: CLOSE get_batch_rec_cur;
185:
186: GMI_RESERVATION_UTIL.PrintLn(' After Fetching The Batchrec');
187:
188: /* The parameters available for search criteria are order_type,line_no to and from,
189: delivery_detail_id to and from , whse_code,item_no, sched_shipdate to and from.
190: */

Line 220: GMI_RESERVATION_UTIL.PrintLn('1: Where Clause is : ' || l_where_clause);

216: l_where_clause := l_where_clause || ')';
217: --||to_char(l_batch_rec.to_order_header_no) ;
218: END IF;
219:
220: GMI_RESERVATION_UTIL.PrintLn('1: Where Clause is : ' || l_where_clause);
221:
222: /* To and from delivery_detail_ids */
223:
224: IF( NVL(l_batch_rec.from_delivery_detail_id,0) <> 0)

Line 237: GMI_RESERVATION_UTIL.PrintLn('2: Where Clause is : ' || l_where_clause);

233: l_where_clause := l_where_clause ||
234: ' AND delivery_detail_id <= '|| l_batch_rec.to_delivery_detail_id;
235: END IF;
236:
237: GMI_RESERVATION_UTIL.PrintLn('2: Where Clause is : ' || l_where_clause);
238:
239: /* Order type Id */
240:
241: IF ( NVL( l_batch_rec.order_type_id,0) <> 0 )

Line 247: GMI_RESERVATION_UTIL.PrintLn('3: Where Clause is : ' || l_where_clause);

243: l_where_clause := l_where_clause ||
244: ' AND source_header_type_id = ' || l_batch_rec.order_type_id ;
245: END IF;
246:
247: GMI_RESERVATION_UTIL.PrintLn('3: Where Clause is : ' || l_where_clause);
248:
249: /* Sched Ship date */
250:
251: IF ( TO_CHAR(l_batch_rec.from_sched_ship_date) <> FND_API.G_MISS_CHAR AND

Line 293: GMI_RESERVATION_UTIL.PrintLn('whse_code : '|| l_batch_rec.whse_code);

289: l_where_clause := l_where_clause || '''';
290: l_where_clause := l_where_clause || ')';
291: END IF;
292:
293: GMI_RESERVATION_UTIL.PrintLn('whse_code : '|| l_batch_rec.whse_code);
294:
295: /* Warehouse code ( ship_to_org_id) */
296: IF ( NVL( l_batch_rec.whse_code,' ') <> ' ' )
297: THEN

Line 302: GMI_RESERVATION_UTIL.PrintLn('Get_ship_to_org_cur failed, No Data found');

298: OPEN get_ship_to_org_cur(l_batch_rec.whse_code);
299: FETCH get_ship_to_org_cur INTO l_ship_to_org_id;
300: IF(get_ship_to_org_cur%NOTFOUND)
301: THEN
302: GMI_RESERVATION_UTIL.PrintLn('Get_ship_to_org_cur failed, No Data found');
303: CLOSE get_ship_to_org_cur;
304: RAISE FND_API.G_EXC_ERROR;
305: END IF;
306: CLOSE get_ship_to_org_cur;

Line 323: GMI_RESERVATION_UTIL.PrintLn('get_inventory_item_id_cur failed, No Data found');

319: OPEN get_inventory_item_id_cur(l_batch_rec.item_id);
320: FETCH get_inventory_item_id_cur INTO l_inventory_item_id;
321: IF(get_inventory_item_id_cur%NOTFOUND)
322: THEN
323: GMI_RESERVATION_UTIL.PrintLn('get_inventory_item_id_cur failed, No Data found');
324: CLOSE get_inventory_item_id_cur;
325: RAISE FND_API.G_EXC_ERROR;
326: END IF;
327: CLOSE get_inventory_item_id_cur;

Line 334: GMI_RESERVATION_UTIL.PrintLn('5: Where Clause is : ' || l_where_clause);

330: l_where_clause := l_where_clause || l_inventory_item_id ;
331:
332: END IF;
333:
334: GMI_RESERVATION_UTIL.PrintLn('5: Where Clause is : ' || l_where_clause);
335:
336: /* fetch the delivery detail rec into l_wdd_line for the above where clause */
337:
338: OPEN wdd_cur1 FOR

Line 344: gmi_reservation_util.println('before fetch');

340:
341: WHERE ' || l_where_clause ||
342: 'ORDER BY delivery_detail_id ' ;
343: LOOP
344: gmi_reservation_util.println('before fetch');
345: FETCH wdd_cur1 INTO l_wdd_rec;
346: EXIT WHEN wdd_cur1%NOTFOUND;
347:
348: GMI_RESERVATION_UTIL.PrintLn('l_wdd_rec.delivery_detail_id'|| l_wdd_rec.delivery_detail_id);

Line 348: GMI_RESERVATION_UTIL.PrintLn('l_wdd_rec.delivery_detail_id'|| l_wdd_rec.delivery_detail_id);

344: gmi_reservation_util.println('before fetch');
345: FETCH wdd_cur1 INTO l_wdd_rec;
346: EXIT WHEN wdd_cur1%NOTFOUND;
347:
348: GMI_RESERVATION_UTIL.PrintLn('l_wdd_rec.delivery_detail_id'|| l_wdd_rec.delivery_detail_id);
349: GMI_RESERVATION_UTIL.PrintLn('In Auto_allocation_batch Before calling Auto_Alloc_Wdd_line');
350: /* Call auto_alloc_Wdd_line */
351:
352: Auto_Alloc_Wdd_Line (

Line 349: GMI_RESERVATION_UTIL.PrintLn('In Auto_allocation_batch Before calling Auto_Alloc_Wdd_line');

345: FETCH wdd_cur1 INTO l_wdd_rec;
346: EXIT WHEN wdd_cur1%NOTFOUND;
347:
348: GMI_RESERVATION_UTIL.PrintLn('l_wdd_rec.delivery_detail_id'|| l_wdd_rec.delivery_detail_id);
349: GMI_RESERVATION_UTIL.PrintLn('In Auto_allocation_batch Before calling Auto_Alloc_Wdd_line');
350: /* Call auto_alloc_Wdd_line */
351:
352: Auto_Alloc_Wdd_Line (
353: p_api_version => 1.0

Line 368: GMI_RESERVATION_UTIL.PrintLn('Status from auto_alloc_Wdd_line'|| l_return_status);

364: ,x_return_status => l_return_status
365: ,x_msg_count => l_msg_count
366: ,x_msg_data => l_msg_data);
367:
368: GMI_RESERVATION_UTIL.PrintLn('Status from auto_alloc_Wdd_line'|| l_return_status);
369:
370: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
371: THEN
372: GMI_reservation_Util.PrintLn('Return_status from Auto_Alloc_Wdd_Line : '||l_return_status);

Line 372: GMI_reservation_Util.PrintLn('Return_status from Auto_Alloc_Wdd_Line : '||l_return_status);

368: GMI_RESERVATION_UTIL.PrintLn('Status from auto_alloc_Wdd_line'|| l_return_status);
369:
370: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
371: THEN
372: GMI_reservation_Util.PrintLn('Return_status from Auto_Alloc_Wdd_Line : '||l_return_status);
373: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS( 'WARNING', '');
374: retcode := 'C';
375:
376: ELSIF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

Line 378: GMI_reservation_Util.PrintLn('Return_status from Auto_Alloc_Wdd_Line : '||l_return_status);

374: retcode := 'C';
375:
376: ELSIF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
377: THEN
378: GMI_reservation_Util.PrintLn('Return_status from Auto_Alloc_Wdd_Line : '||l_return_status);
379: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS( 'WARNING', '');
380: FND_MESSAGE.Set_Name('GMI','GMI_AUTO_ALLOC_WDD_LINE_ERROR');
381: FND_MSG_PUB.Add;
382: RAISE FND_API.G_EXC_ERROR;

Line 387: GMI_RESERVATION_UTIL.PrintLn('Pick_Confirm_Flag is set to : '|| l_batch_rec.pick_confirm_flag);

383: END IF;
384: x_return_status := l_return_status;
385:
386: /* If pick_confirm flag is set then, auto_pick_confirm */
387: GMI_RESERVATION_UTIL.PrintLn('Pick_Confirm_Flag is set to : '|| l_batch_rec.pick_confirm_flag);
388:
389: IF ( l_batch_rec.pick_confirm_flag = 'Y' AND x_return_status = FND_API.G_RET_STS_SUCCESS)
390: THEN
391: GMI_RESERVATION_UTIL.PrintLn( 'pick_confirm_flag Is set to Y for batch_id : '|| p_batch_id);

Line 391: GMI_RESERVATION_UTIL.PrintLn( 'pick_confirm_flag Is set to Y for batch_id : '|| p_batch_id);

387: GMI_RESERVATION_UTIL.PrintLn('Pick_Confirm_Flag is set to : '|| l_batch_rec.pick_confirm_flag);
388:
389: IF ( l_batch_rec.pick_confirm_flag = 'Y' AND x_return_status = FND_API.G_RET_STS_SUCCESS)
390: THEN
391: GMI_RESERVATION_UTIL.PrintLn( 'pick_confirm_flag Is set to Y for batch_id : '|| p_batch_id);
392: l_return_status := FND_API.G_RET_STS_SUCCESS;
393:
394: GMI_RESERVATION_UTIL.PrintLn( ' START PICK CONFIRMATION');
395:

Line 394: GMI_RESERVATION_UTIL.PrintLn( ' START PICK CONFIRMATION');

390: THEN
391: GMI_RESERVATION_UTIL.PrintLn( 'pick_confirm_flag Is set to Y for batch_id : '|| p_batch_id);
392: l_return_status := FND_API.G_RET_STS_SUCCESS;
393:
394: GMI_RESERVATION_UTIL.PrintLn( ' START PICK CONFIRMATION');
395:
396: IF(l_wdd_rec.released_status = 'S') THEN
397:
398: GMI_RESERVATION_UTIL.PrintLn( 'Before Call to Call_Pick_Confirm ');

Line 398: GMI_RESERVATION_UTIL.PrintLn( 'Before Call to Call_Pick_Confirm ');

394: GMI_RESERVATION_UTIL.PrintLn( ' START PICK CONFIRMATION');
395:
396: IF(l_wdd_rec.released_status = 'S') THEN
397:
398: GMI_RESERVATION_UTIL.PrintLn( 'Before Call to Call_Pick_Confirm ');
399: Call_Pick_Confirm (
400: p_mo_line_id => l_wdd_rec.move_order_line_id
401: , p_delivery_detail_id => l_wdd_rec.delivery_detail_id
402: , p_init_msg_list => 1

Line 413: GMI_RESERVATION_UTIL.PrintLn('Status from Call_Pick_Confirm'|| l_return_status);

409: , x_msg_count => l_msg_count
410: , x_msg_data => l_msg_data);
411:
412:
413: GMI_RESERVATION_UTIL.PrintLn('Status from Call_Pick_Confirm'|| l_return_status);
414: IF(l_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING)
415: THEN
416: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS( 'WARNING', '');
417: retcode := 'P';

Line 421: GMI_reservation_Util.PrintLn('Return_status from call_pick_confirm : '||x_return_status);

417: retcode := 'P';
418: ELSIF (l_return_status <> FND_API.G_RET_STS_SUCCESS)
419: THEN
420: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS( 'WARNING', '');
421: GMI_reservation_Util.PrintLn('Return_status from call_pick_confirm : '||x_return_status);
422: FND_MESSAGE.Set_Name('GMI','GMI_PICK_CONFIRM_ERROR');
423: FND_MSG_PUB.Add;
424: RAISE FND_API.G_EXC_ERROR;
425: END IF;

Line 428: GMI_RESERVATION_UTIL.PrintLn('Can Not Pick Confirm, The release status for the delivery_line is: '||

424: RAISE FND_API.G_EXC_ERROR;
425: END IF;
426:
427: ELSE
428: GMI_RESERVATION_UTIL.PrintLn('Can Not Pick Confirm, The release status for the delivery_line is: '||
429: l_wdd_rec.released_status );
430: END IF; /* IF released_status is 'S' */
431:
432: ELSE /* Pick Confirm Is set to 'N' */

Line 433: GMI_RESERVATION_UTIL.PrintLn( 'pick_confirm_flag Is set to N for batch_id : '|| p_batch_id);

429: l_wdd_rec.released_status );
430: END IF; /* IF released_status is 'S' */
431:
432: ELSE /* Pick Confirm Is set to 'N' */
433: GMI_RESERVATION_UTIL.PrintLn( 'pick_confirm_flag Is set to N for batch_id : '|| p_batch_id);
434: END IF;
435: END LOOP;
436: GMI_RESERVATION_UTIL.PrintLn('ENd of auto_allocate_batch');
437:

Line 436: GMI_RESERVATION_UTIL.PrintLn('ENd of auto_allocate_batch');

432: ELSE /* Pick Confirm Is set to 'N' */
433: GMI_RESERVATION_UTIL.PrintLn( 'pick_confirm_flag Is set to N for batch_id : '|| p_batch_id);
434: END IF;
435: END LOOP;
436: GMI_RESERVATION_UTIL.PrintLn('ENd of auto_allocate_batch');
437:
438: /* EXCEPTION HANDLING
439: ====================*/
440: EXCEPTION

Line 443: GMI_RESERVATION_UTIL.PrintLn('sqlcode : ' ||to_char(sqlcode));

439: ====================*/
440: EXCEPTION
441: WHEN FND_API.G_EXC_ERROR THEN
442: -- ROLLBACK TO SAVEPOINT Auto_Allocate_Batch_SP;
443: GMI_RESERVATION_UTIL.PrintLn('sqlcode : ' ||to_char(sqlcode));
444: GMI_RESERVATION_UTIL.PrintLn('sqlerr : '|| SUBSTRB(SQLERRM, 1, 150));
445: x_return_status := FND_API.G_RET_STS_ERROR;
446: errbuf := SUBSTRB(SQLERRM, 1, 150);
447: retcode := x_return_status;

Line 444: GMI_RESERVATION_UTIL.PrintLn('sqlerr : '|| SUBSTRB(SQLERRM, 1, 150));

440: EXCEPTION
441: WHEN FND_API.G_EXC_ERROR THEN
442: -- ROLLBACK TO SAVEPOINT Auto_Allocate_Batch_SP;
443: GMI_RESERVATION_UTIL.PrintLn('sqlcode : ' ||to_char(sqlcode));
444: GMI_RESERVATION_UTIL.PrintLn('sqlerr : '|| SUBSTRB(SQLERRM, 1, 150));
445: x_return_status := FND_API.G_RET_STS_ERROR;
446: errbuf := SUBSTRB(SQLERRM, 1, 150);
447: retcode := x_return_status;
448:

Line 459: GMI_RESERVATION_UTIL.PrintLn('sqlcode : ' ||to_char(sqlcode));

455: );
456:
457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
458: -- ROLLBACK TO SAVEPOINT Auto_Allocate_Batch_SP;
459: GMI_RESERVATION_UTIL.PrintLn('sqlcode : ' ||to_char(sqlcode));
460: GMI_RESERVATION_UTIL.PrintLn('sqlerr : '|| SUBSTRB(SQLERRM, 1, 150));
461:
462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
463: errbuf := SUBSTRB(SQLERRM, 1, 150);

Line 460: GMI_RESERVATION_UTIL.PrintLn('sqlerr : '|| SUBSTRB(SQLERRM, 1, 150));

456:
457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
458: -- ROLLBACK TO SAVEPOINT Auto_Allocate_Batch_SP;
459: GMI_RESERVATION_UTIL.PrintLn('sqlcode : ' ||to_char(sqlcode));
460: GMI_RESERVATION_UTIL.PrintLn('sqlerr : '|| SUBSTRB(SQLERRM, 1, 150));
461:
462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
463: errbuf := SUBSTRB(SQLERRM, 1, 150);
464: retcode := x_return_status;

Line 476: GMI_RESERVATION_UTIL.PrintLn('sqlcode : ' ||to_char(sqlcode));

472: , p_data => x_msg_data
473: );
474: WHEN OTHERS THEN
475: --ROLLBACK TO SAVEPOINT Auto_Allocate_Batch_SP;
476: GMI_RESERVATION_UTIL.PrintLn('sqlcode : ' ||to_char(sqlcode));
477: GMI_RESERVATION_UTIL.PrintLn('sqlerr : '|| SUBSTRB(SQLERRM, 1, 150));
478:
479: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
480: , l_api_name

Line 477: GMI_RESERVATION_UTIL.PrintLn('sqlerr : '|| SUBSTRB(SQLERRM, 1, 150));

473: );
474: WHEN OTHERS THEN
475: --ROLLBACK TO SAVEPOINT Auto_Allocate_Batch_SP;
476: GMI_RESERVATION_UTIL.PrintLn('sqlcode : ' ||to_char(sqlcode));
477: GMI_RESERVATION_UTIL.PrintLn('sqlerr : '|| SUBSTRB(SQLERRM, 1, 150));
478:
479: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
480: , l_api_name
481: );

Line 574: l_ic_item_mst_rec GMI_Reservation_Util.ic_item_mst_rec;

570: l_tran_row IC_TRAN_PND%ROWTYPE;
571:
572:
573: l_allocation_rec GMI_Auto_Allocate_PUB.gmi_allocation_rec;
574: l_ic_item_mst_rec GMI_Reservation_Util.ic_item_mst_rec;
575: --l_ic_item_mst_rec ic_item_mst%ROWTYPE;
576: l_ic_item_mst ic_item_mst%ROWTYPE;
577: l_old_transaction_rec GMI_TRANS_ENGINE_PUB.ictran_rec;
578: l_op_alot_prm_rec op_alot_prm%rowtype;

Line 662: GMI_RESERVATION_UTIL.PrintLn('FND_API.compatible_api_call failed');

658: p_api_version,
659: l_api_name,
660: G_PKG_NAME)
661: THEN
662: GMI_RESERVATION_UTIL.PrintLn('FND_API.compatible_api_call failed');
663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
664: END IF;
665:
666:

Line 674: GMI_RESERVATION_UTIL.PrintLn('In Procedure Auto_Alloc_WDD_Line After Initialize');

670: THEN
671: FND_MSG_PUB.initialize;
672: END IF;
673:
674: GMI_RESERVATION_UTIL.PrintLn('In Procedure Auto_Alloc_WDD_Line After Initialize');
675:
676: /* Below procedure fills in allocation record
677: TYPE gmi_allocation_rec is RECORD
678: ( doc_id IC_TRAN_PND.DOC_ID%TYPE

Line 705: GMI_RESERVATION_UTIL.PrintLn('Get_Whse_Code_cur Failed, No Data found');

701: FETCH get_whse_code_cur into l_whse_code;
702:
703: IF(get_whse_code_cur%NOTFOUND)
704: THEN
705: GMI_RESERVATION_UTIL.PrintLn('Get_Whse_Code_cur Failed, No Data found');
706: CLOSE get_whse_code_cur;
707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
708: END IF;
709:

Line 712: GMI_RESERVATION_UTIL.PrintLn('l_whse_code is '|| l_whse_code);

708: END IF;
709:
710: CLOSE get_whse_code_cur;
711:
712: GMI_RESERVATION_UTIL.PrintLn('l_whse_code is '|| l_whse_code);
713: GMI_RESERVATION_UTIL.PrintLn('Wdd org_id is '|| p_wdd_rec.organization_id);
714:
715: IF (NVL(p_batch_rec.delete_existing_aloc_flag,'N') = 'Y' OR
716: (p_batch_rec.delete_existing_aloc_flag IS NULL AND UPPER(l_GML$DEL_ALC_BEFORE_AUTO) = 'YES') )

Line 713: GMI_RESERVATION_UTIL.PrintLn('Wdd org_id is '|| p_wdd_rec.organization_id);

709:
710: CLOSE get_whse_code_cur;
711:
712: GMI_RESERVATION_UTIL.PrintLn('l_whse_code is '|| l_whse_code);
713: GMI_RESERVATION_UTIL.PrintLn('Wdd org_id is '|| p_wdd_rec.organization_id);
714:
715: IF (NVL(p_batch_rec.delete_existing_aloc_flag,'N') = 'Y' OR
716: (p_batch_rec.delete_existing_aloc_flag IS NULL AND UPPER(l_GML$DEL_ALC_BEFORE_AUTO) = 'YES') )
717: THEN

Line 718: GMI_RESERVATION_UTIL.println('Delete_existing_aloc_flag is Y');

714:
715: IF (NVL(p_batch_rec.delete_existing_aloc_flag,'N') = 'Y' OR
716: (p_batch_rec.delete_existing_aloc_flag IS NULL AND UPPER(l_GML$DEL_ALC_BEFORE_AUTO) = 'YES') )
717: THEN
718: GMI_RESERVATION_UTIL.println('Delete_existing_aloc_flag is Y');
719:
720: OPEN c_get_trans_id(p_wdd_rec.delivery_detail_id);
721: FETCH c_get_trans_id INTO ic_tran_tbl_row;
722:

Line 725: GMI_RESERVATION_UTIL.println('In c_get_trans_id%FOUND');

721: FETCH c_get_trans_id INTO ic_tran_tbl_row;
722:
723: IF (c_get_trans_id%FOUND)
724: THEN
725: GMI_RESERVATION_UTIL.println('In c_get_trans_id%FOUND');
726: GMI_RESERVATION_UTIL.println('Deleting existing Allocations');
727: WHILE c_get_trans_id%FOUND
728: LOOP
729: l_tran_rec.trans_id := ic_tran_tbl_row.trans_id;

Line 726: GMI_RESERVATION_UTIL.println('Deleting existing Allocations');

722:
723: IF (c_get_trans_id%FOUND)
724: THEN
725: GMI_RESERVATION_UTIL.println('In c_get_trans_id%FOUND');
726: GMI_RESERVATION_UTIL.println('Deleting existing Allocations');
727: WHILE c_get_trans_id%FOUND
728: LOOP
729: l_tran_rec.trans_id := ic_tran_tbl_row.trans_id;
730: GMI_Reservation_Util.PrintLn('l_tran_rec.trans_id = ' || l_tran_rec.trans_id);

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

726: GMI_RESERVATION_UTIL.println('Deleting existing Allocations');
727: WHILE c_get_trans_id%FOUND
728: LOOP
729: l_tran_rec.trans_id := ic_tran_tbl_row.trans_id;
730: GMI_Reservation_Util.PrintLn('l_tran_rec.trans_id = ' || l_tran_rec.trans_id);
731: GMI_Reservation_Util.PrintLn('Before Call to Delete Pending Transaction');
732:
733: GMI_TRANS_ENGINE_PUB.delete_pending_transaction (
734: 1

Line 731: GMI_Reservation_Util.PrintLn('Before Call to Delete Pending Transaction');

727: WHILE c_get_trans_id%FOUND
728: LOOP
729: l_tran_rec.trans_id := ic_tran_tbl_row.trans_id;
730: GMI_Reservation_Util.PrintLn('l_tran_rec.trans_id = ' || l_tran_rec.trans_id);
731: GMI_Reservation_Util.PrintLn('Before Call to Delete Pending Transaction');
732:
733: GMI_TRANS_ENGINE_PUB.delete_pending_transaction (
734: 1
735: , FND_API.G_FALSE

Line 744: GMI_Reservation_Util.PrintLn('After Call to Delete Pending Transaction');

740: , x_return_status
741: , x_msg_count
742: , x_msg_data
743: );
744: GMI_Reservation_Util.PrintLn('After Call to Delete Pending Transaction');
745: GMI_Reservation_Util.PrintLn('Return from DELETE PENDING TRANS x_return_status = ' || x_return_status);
746:
747: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
748: THEN

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

741: , x_msg_count
742: , x_msg_data
743: );
744: GMI_Reservation_Util.PrintLn('After Call to Delete Pending Transaction');
745: GMI_Reservation_Util.PrintLn('Return from DELETE PENDING TRANS x_return_status = ' || x_return_status);
746:
747: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
748: THEN
749: GMI_RESERVATION_UTIL.PrintLn('Error returned by Delete_Pending_Transaction');

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

745: GMI_Reservation_Util.PrintLn('Return from DELETE PENDING TRANS x_return_status = ' || x_return_status);
746:
747: IF x_return_status <> FND_API.G_RET_STS_SUCCESS
748: THEN
749: GMI_RESERVATION_UTIL.PrintLn('Error returned by Delete_Pending_Transaction');
750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
751: END IF;
752:
753: FETCH c_get_trans_id INTO ic_tran_tbl_row;

Line 759: GMI_RESERVATION_UTIL.PrintLn('Before the call to Get_Allocation_Record ');

755: CLOSE c_get_trans_id;
756: END IF;
757: END IF;
758:
759: GMI_RESERVATION_UTIL.PrintLn('Before the call to Get_Allocation_Record ');
760:
761: Get_Allocation_Record (
762: p_wdd_line => p_wdd_rec
763: , x_allocation_rec => l_allocation_rec

Line 770: GMI_RESERVATION_UTIL.PrintLn('Status from Get_Allocation_Record Is : '|| x_return_status);

766: , x_msg_count => x_msg_count
767: , x_msg_data => x_msg_data
768: );
769:
770: GMI_RESERVATION_UTIL.PrintLn('Status from Get_Allocation_Record Is : '|| x_return_status);
771:
772: IF nvl(l_allocation_rec.order_qty1,0)=0 THEN
773: GMI_RESERVATION_UTIL.println('Line is fully allocated, nothing to do, RETURN');
774: RETURN;

Line 773: GMI_RESERVATION_UTIL.println('Line is fully allocated, nothing to do, RETURN');

769:
770: GMI_RESERVATION_UTIL.PrintLn('Status from Get_Allocation_Record Is : '|| x_return_status);
771:
772: IF nvl(l_allocation_rec.order_qty1,0)=0 THEN
773: GMI_RESERVATION_UTIL.println('Line is fully allocated, nothing to do, RETURN');
774: RETURN;
775: END IF;
776:
777: GMI_RESERVATION_UTIL.println('Will attempt to allocate '|| l_allocation_rec.order_qty1);

Line 777: GMI_RESERVATION_UTIL.println('Will attempt to allocate '|| l_allocation_rec.order_qty1);

773: GMI_RESERVATION_UTIL.println('Line is fully allocated, nothing to do, RETURN');
774: RETURN;
775: END IF;
776:
777: GMI_RESERVATION_UTIL.println('Will attempt to allocate '|| l_allocation_rec.order_qty1);
778:
779:
780: OPEN Get_Whse_Cur(l_whse_code);
781: FETCH Get_Whse_Cur Into l_ic_whse_mst_rec;

Line 784: GMI_RESERVATION_UTIL.println('Get_Whse_Cur%Notfound');

780: OPEN Get_Whse_Cur(l_whse_code);
781: FETCH Get_Whse_Cur Into l_ic_whse_mst_rec;
782: IF(Get_Whse_Cur%NOTFOUND)
783: THEN
784: GMI_RESERVATION_UTIL.println('Get_Whse_Cur%Notfound');
785: CLOSE Get_Whse_Cur;
786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
787: END IF;
788:

Line 793: GMI_RESERVATION_UTIL.println('NON CONTROL . Auto allocation can not be performed');

789: CLOSE Get_Whse_Cur;
790:
791:
792: IF (l_ic_item_mst_rec.lot_ctl = 0 and l_ic_item_mst_rec.loct_ctl * l_ic_whse_mst_rec.loct_ctl = 0) THEN
793: GMI_RESERVATION_UTIL.println('NON CONTROL . Auto allocation can not be performed');
794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
795: END IF;
796:
797: IF (nvl(l_ic_item_mst_rec.alloc_class, '%#S$%') = '%#S$%' ) THEN

Line 798: GMI_RESERVATION_UTIL.println('Alloc Class is missing from item set up.');

794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
795: END IF;
796:
797: IF (nvl(l_ic_item_mst_rec.alloc_class, '%#S$%') = '%#S$%' ) THEN
798: GMI_RESERVATION_UTIL.println('Alloc Class is missing from item set up.');
799: GMI_RESERVATION_UTIL.println('Auto allocation can not be performed');
800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
801: END IF;
802:

Line 799: GMI_RESERVATION_UTIL.println('Auto allocation can not be performed');

795: END IF;
796:
797: IF (nvl(l_ic_item_mst_rec.alloc_class, '%#S$%') = '%#S$%' ) THEN
798: GMI_RESERVATION_UTIL.println('Alloc Class is missing from item set up.');
799: GMI_RESERVATION_UTIL.println('Auto allocation can not be performed');
800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
801: END IF;
802:
803: /* find out if there is default lot already */

Line 804: GMI_RESERVATION_UTIL.println('Before find_default_lot');

800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
801: END IF;
802:
803: /* find out if there is default lot already */
804: GMI_RESERVATION_UTIL.println('Before find_default_lot');
805: GMI_RESERVATION_UTIL.find_default_lot
806: ( x_return_status => x_return_status,
807: x_msg_count => x_msg_count,
808: x_msg_data => x_msg_data,

Line 805: GMI_RESERVATION_UTIL.find_default_lot

801: END IF;
802:
803: /* find out if there is default lot already */
804: GMI_RESERVATION_UTIL.println('Before find_default_lot');
805: GMI_RESERVATION_UTIL.find_default_lot
806: ( x_return_status => x_return_status,
807: x_msg_count => x_msg_count,
808: x_msg_data => x_msg_data,
809: x_reservation_id => l_trans_id,

Line 815: GMI_RESERVATION_UTIL.println('Error returned by find default lot');

811:
812: );
813:
814: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
815: GMI_RESERVATION_UTIL.println('Error returned by find default lot');
816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
817: END IF;
818:
819: IF nvl(l_trans_id, 0) <> 0 THEN

Line 820: GMI_RESERVATION_UTIL.println('Default trans exists');

816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
817: END IF;
818:
819: IF nvl(l_trans_id, 0) <> 0 THEN
820: GMI_RESERVATION_UTIL.println('Default trans exists');
821: ELSE
822: GMI_RESERVATION_UTIL.println('Create default trans ');
823: GMI_RESERVATION_UTIL.create_dflt_lot_from_scratch
824: ( p_whse_code => l_whse_code

Line 822: GMI_RESERVATION_UTIL.println('Create default trans ');

818:
819: IF nvl(l_trans_id, 0) <> 0 THEN
820: GMI_RESERVATION_UTIL.println('Default trans exists');
821: ELSE
822: GMI_RESERVATION_UTIL.println('Create default trans ');
823: GMI_RESERVATION_UTIL.create_dflt_lot_from_scratch
824: ( p_whse_code => l_whse_code
825: , p_line_id => p_wdd_rec.source_line_id
826: , p_item_id => l_ic_item_mst_rec.item_id

Line 823: GMI_RESERVATION_UTIL.create_dflt_lot_from_scratch

819: IF nvl(l_trans_id, 0) <> 0 THEN
820: GMI_RESERVATION_UTIL.println('Default trans exists');
821: ELSE
822: GMI_RESERVATION_UTIL.println('Create default trans ');
823: GMI_RESERVATION_UTIL.create_dflt_lot_from_scratch
824: ( p_whse_code => l_whse_code
825: , p_line_id => p_wdd_rec.source_line_id
826: , p_item_id => l_ic_item_mst_rec.item_id
827: , p_qty1 => p_wdd_rec.requested_quantity

Line 834: GMI_Reservation_Util.PrintLn('creating default lot returns error');

830: , x_msg_count => x_msg_count
831: , x_msg_data => x_msg_data
832: );
833: IF( l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
834: GMI_Reservation_Util.PrintLn('creating default lot returns error');
835: raise FND_API.G_EXC_UNEXPECTED_ERROR;
836: END IF;
837: END IF;
838:

Line 839: GMI_RESERVATION_UTIL.println('Before Call To get allocation Parms');

835: raise FND_API.G_EXC_UNEXPECTED_ERROR;
836: END IF;
837: END IF;
838:
839: GMI_RESERVATION_UTIL.println('Before Call To get allocation Parms');
840:
841: GMI_ALLOCATION_RULES_PVT.GET_ALLOCATION_PARMS
842: ( p_alloc_class => l_ic_item_mst_rec.alloc_class,
843: p_org_id => l_allocation_rec.org_id,

Line 853: GMI_RESERVATION_UTIL.println('Status from GET_ALLOCATION_PARMS : ' ||l_return_status);

849: x_msg_data => x_msg_data
850: );
851:
852:
853: GMI_RESERVATION_UTIL.println('Status from GET_ALLOCATION_PARMS : ' ||l_return_status);
854:
855: IF( l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
856: GMI_Reservation_Util.PrintLn('get allocation prm returns error');
857: raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 856: GMI_Reservation_Util.PrintLn('get allocation prm returns error');

852:
853: GMI_RESERVATION_UTIL.println('Status from GET_ALLOCATION_PARMS : ' ||l_return_status);
854:
855: IF( l_return_status <> FND_API.G_RET_STS_SUCCESS ) then
856: GMI_Reservation_Util.PrintLn('get allocation prm returns error');
857: raise FND_API.G_EXC_UNEXPECTED_ERROR;
858: END IF;
859:
860: --l_commit := FND_API.G_FALSE;

Line 867: GMI_RESERVATION_UTIL.println('Get_Item_Cur%NOTFOUND');

863: FETCH get_item_cur INTO l_ic_item_mst;
864:
865: IF (get_item_cur%NOTFOUND)
866: THEN
867: GMI_RESERVATION_UTIL.println('Get_Item_Cur%NOTFOUND');
868: raise FND_API.G_EXC_UNEXPECTED_ERROR;
869: END IF;
870:
871: CLOSE get_item_cur;

Line 873: GMI_RESERVATION_UTIL.println('Before Call To GMI_ALLOCATE_INVENTORY_PVT.Allocate_line');

869: END IF;
870:
871: CLOSE get_item_cur;
872:
873: GMI_RESERVATION_UTIL.println('Before Call To GMI_ALLOCATE_INVENTORY_PVT.Allocate_line');
874:
875:
876: GMI_ALLOCATE_INVENTORY_PVT.ALLOCATE_LINE
877: ( p_allocation_rec => l_allocation_rec

Line 889: GMI_RESERVATION_UTIL.println('After Call To GMI_ALLOCATE_INVENTORY_PVT.Allocate_line');

885: , x_msg_count => x_msg_count
886: , x_msg_data => x_msg_data
887: );
888:
889: GMI_RESERVATION_UTIL.println('After Call To GMI_ALLOCATE_INVENTORY_PVT.Allocate_line');
890: GMI_RESERVATION_UTIL.println('GMI_ALLOCATE_INVENTORY_PVT.Allocate line status '|| x_return_status);
891:
892: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
893: GMI_RESERVATION_UTIL.println('Warning returned by allocate line ');

Line 890: GMI_RESERVATION_UTIL.println('GMI_ALLOCATE_INVENTORY_PVT.Allocate line status '|| x_return_status);

886: , x_msg_data => x_msg_data
887: );
888:
889: GMI_RESERVATION_UTIL.println('After Call To GMI_ALLOCATE_INVENTORY_PVT.Allocate_line');
890: GMI_RESERVATION_UTIL.println('GMI_ALLOCATE_INVENTORY_PVT.Allocate line status '|| x_return_status);
891:
892: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
893: GMI_RESERVATION_UTIL.println('Warning returned by allocate line ');
894: RETURN;

Line 893: GMI_RESERVATION_UTIL.println('Warning returned by allocate line ');

889: GMI_RESERVATION_UTIL.println('After Call To GMI_ALLOCATE_INVENTORY_PVT.Allocate_line');
890: GMI_RESERVATION_UTIL.println('GMI_ALLOCATE_INVENTORY_PVT.Allocate line status '|| x_return_status);
891:
892: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
893: GMI_RESERVATION_UTIL.println('Warning returned by allocate line ');
894: RETURN;
895: ELSIF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
896: GMI_RESERVATION_UTIL.println('Error returned by allocate line ');
897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 896: GMI_RESERVATION_UTIL.println('Error returned by allocate line ');

892: IF x_return_status = WSH_UTIL_CORE.G_RET_STS_WARNING THEN
893: GMI_RESERVATION_UTIL.println('Warning returned by allocate line ');
894: RETURN;
895: ELSIF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
896: GMI_RESERVATION_UTIL.println('Error returned by allocate line ');
897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
898: END IF;
899:
900: GMI_RESERVATION_UTIL.println('Before Call To GMI_RESERVATION_UTIL.find_default_lot');

Line 900: GMI_RESERVATION_UTIL.println('Before Call To GMI_RESERVATION_UTIL.find_default_lot');

896: GMI_RESERVATION_UTIL.println('Error returned by allocate line ');
897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
898: END IF;
899:
900: GMI_RESERVATION_UTIL.println('Before Call To GMI_RESERVATION_UTIL.find_default_lot');
901: GMI_RESERVATION_UTIL.find_default_lot
902: ( x_return_status => l_return_status,
903: x_msg_count => x_msg_count,
904: x_msg_data => x_msg_data,

Line 901: GMI_RESERVATION_UTIL.find_default_lot

897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
898: END IF;
899:
900: GMI_RESERVATION_UTIL.println('Before Call To GMI_RESERVATION_UTIL.find_default_lot');
901: GMI_RESERVATION_UTIL.find_default_lot
902: ( x_return_status => l_return_status,
903: x_msg_count => x_msg_count,
904: x_msg_data => x_msg_data,
905: x_reservation_id => l_trans_id,

Line 909: GMI_RESERVATION_UTIL.println('Error returned by find default lot');

905: x_reservation_id => l_trans_id,
906: p_line_id => p_wdd_rec.source_line_id
907: );
908: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
909: GMI_RESERVATION_UTIL.println('Error returned by find default lot');
910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
911: END IF;
912:
913: l_old_transaction_rec.trans_id := l_trans_id;

Line 917: GMI_RESERVATION_UTIL.PrintLn('balancing default lot for line_id '|| p_wdd_rec.source_line_id);

913: l_old_transaction_rec.trans_id := l_trans_id;
914: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
915: (l_old_transaction_rec, l_old_transaction_rec )
916: THEN
917: GMI_RESERVATION_UTIL.PrintLn('balancing default lot for line_id '|| p_wdd_rec.source_line_id);
918: GMI_RESERVATION_UTIL.balance_default_lot
919: ( p_ic_default_rec => l_old_transaction_rec
920: , p_opm_item_id => l_old_transaction_rec.item_id
921: , x_return_status => l_return_status

Line 918: GMI_RESERVATION_UTIL.balance_default_lot

914: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND
915: (l_old_transaction_rec, l_old_transaction_rec )
916: THEN
917: GMI_RESERVATION_UTIL.PrintLn('balancing default lot for line_id '|| p_wdd_rec.source_line_id);
918: GMI_RESERVATION_UTIL.balance_default_lot
919: ( p_ic_default_rec => l_old_transaction_rec
920: , p_opm_item_id => l_old_transaction_rec.item_id
921: , x_return_status => l_return_status
922: , x_msg_count => x_msg_count

Line 927: GMI_RESERVATION_UTIL.PrintLn('Error returned by balancing default lot');

923: , x_msg_data => x_msg_data
924: );
925: IF l_return_status <> FND_API.G_RET_STS_SUCCESS
926: THEN
927: GMI_RESERVATION_UTIL.PrintLn('Error returned by balancing default lot');
928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
929: END IF;
930: END IF;
931:

Line 942: GMI_Reservation_Util.PrintLn('txn_no_default : NOTFOUND ');

938:
939: FETCH cur_txn_no_default INTO l_total_qty, l_total_qty2;
940: IF cur_txn_no_default%NOTFOUND THEN
941: CLOSE cur_txn_no_default;
942: GMI_Reservation_Util.PrintLn('txn_no_default : NOTFOUND ');
943: FND_MESSAGE.SET_NAME('GMI','GMI_REQUIRED_MISSING');
944: RAISE FND_API.G_EXC_ERROR;
945: END IF;
946: CLOSE cur_txn_no_default;

Line 948: GMI_RESERVATION_UTIL.PrintLn('l_total_qty '||l_total_qty);

944: RAISE FND_API.G_EXC_ERROR;
945: END IF;
946: CLOSE cur_txn_no_default;
947:
948: GMI_RESERVATION_UTIL.PrintLn('l_total_qty '||l_total_qty);
949: GMI_RESERVATION_UTIL.PrintLn(' l_total_qty2 '||l_total_qty2);
950:
951: UPDATE ic_txn_request_lines
952: SET quantity_detailed = l_total_qty

Line 949: GMI_RESERVATION_UTIL.PrintLn(' l_total_qty2 '||l_total_qty2);

945: END IF;
946: CLOSE cur_txn_no_default;
947:
948: GMI_RESERVATION_UTIL.PrintLn('l_total_qty '||l_total_qty);
949: GMI_RESERVATION_UTIL.PrintLn(' l_total_qty2 '||l_total_qty2);
950:
951: UPDATE ic_txn_request_lines
952: SET quantity_detailed = l_total_qty
953: , secondary_quantity_detailed = l_total_qty2

Line 961: GMI_RESERVATION_UTIL.PrintLn('Exiting Procedure Auto_Alloc_Wdd_Line Successfully');

957: THEN
958: x_return_status := FND_API.G_RET_STS_SUCCESS;
959: END IF;
960:
961: GMI_RESERVATION_UTIL.PrintLn('Exiting Procedure Auto_Alloc_Wdd_Line Successfully');
962:
963: /* EXCEPTION HANDLING
964: ====================*/
965: EXCEPTION

Line 971: GMI_RESERVATION_UTIL.PrintLn('In Exception FND_API.G_EXC_ERROR In Procedure Auto_Alloc_Wdd_Line ');

967: ROLLBACK TO SAVEPOINT Auto_Alloc_Wdd_Line_SP;
968:
969: x_return_status := FND_API.G_RET_STS_ERROR;
970:
971: GMI_RESERVATION_UTIL.PrintLn('In Exception FND_API.G_EXC_ERROR In Procedure Auto_Alloc_Wdd_Line ');
972:
973: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
974: , l_api_name
975: );

Line 985: GMI_RESERVATION_UTIL.PrintLn('In Exception FND_API.G_EXC_UNEXPECTED_ERROR In Procedure Auto_Alloc_Wdd_Line ');

981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
982: ROLLBACK TO SAVEPOINT Auto_Alloc_Wdd_Line_SP;
983:
984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
985: GMI_RESERVATION_UTIL.PrintLn('In Exception FND_API.G_EXC_UNEXPECTED_ERROR In Procedure Auto_Alloc_Wdd_Line ');
986:
987: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
988: , l_api_name
989: );

Line 996: GMI_RESERVATION_UTIL.PrintLn('In Exception OTHERS In Procedure Auto_Alloc_Wdd_Line ');

992: , p_data => x_msg_data
993: );
994: WHEN OTHERS THEN
995: ROLLBACK TO SAVEPOINT Auto_Alloc_Wdd_Line_SP;
996: GMI_RESERVATION_UTIL.PrintLn('In Exception OTHERS In Procedure Auto_Alloc_Wdd_Line ');
997: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
998: , l_api_name
999: );
1000:

Line 1090: GMI_RESERVATION_UTIL.PrintLn('In Call_Pick_Confirm after initialize');

1086: THEN
1087: FND_MSG_PUB.Initialize;
1088: END IF;
1089:
1090: GMI_RESERVATION_UTIL.PrintLn('In Call_Pick_Confirm after initialize');
1091: /* check what is the move order type. If it's a non pick wave mo,
1092: call the pick engine, otherwise, call the pick release api
1093: call directed pick and put away api
1094: */

Line 1111: GMI_Reservation_Util.PrintLn('(Auto_alloc_batch) Call_Pick_Confirm : the MO is locked for line_id='||p_mo_line_id);

1107: , x_return_status => x_return_status);
1108:
1109: IF ( x_return_status = '54' )
1110: THEN
1111: GMI_Reservation_Util.PrintLn('(Auto_alloc_batch) Call_Pick_Confirm : the MO is locked for line_id='||p_mo_line_id);
1112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1113: END IF;
1114:
1115: -- for non ctl items, no allocation is made but the default trans

Line 1124: GMI_Reservation_Util.PrintLn('get_transacted_qty%NOTFOUND');

1120: OPEN get_transacted_qty (l_mo_line_rec.txn_source_line_id);
1121: FETCH get_transacted_qty Into l_transacted_qty, l_transacted_qty2;
1122: IF(get_transacted_qty%NOTFOUND)
1123: THEN
1124: GMI_Reservation_Util.PrintLn('get_transacted_qty%NOTFOUND');
1125: CLOSE get_transacted_qty;
1126: END IF;
1127: CLOSE get_transacted_qty;
1128:

Line 1129: GMI_Reservation_Util.PrintLn('Total qtys have been transacted for source line '

1125: CLOSE get_transacted_qty;
1126: END IF;
1127: CLOSE get_transacted_qty;
1128:
1129: GMI_Reservation_Util.PrintLn('Total qtys have been transacted for source line '
1130: || l_mo_line_rec.txn_source_line_id);
1131: GMI_Reservation_Util.PrintLn(' total qty1 '|| l_transacted_qty);
1132: GMI_Reservation_Util.PrintLn(' total qty2 '|| l_transacted_qty2);
1133:

Line 1131: GMI_Reservation_Util.PrintLn(' total qty1 '|| l_transacted_qty);

1127: CLOSE get_transacted_qty;
1128:
1129: GMI_Reservation_Util.PrintLn('Total qtys have been transacted for source line '
1130: || l_mo_line_rec.txn_source_line_id);
1131: GMI_Reservation_Util.PrintLn(' total qty1 '|| l_transacted_qty);
1132: GMI_Reservation_Util.PrintLn(' total qty2 '|| l_transacted_qty2);
1133:
1134: OPEN get_trans_qty_for_del(l_mo_line_rec.txn_source_line_id, p_delivery_detail_id);
1135: FETCH get_trans_qty_for_del Into l_del_trans_qty, l_del_trans_qty2;

Line 1132: GMI_Reservation_Util.PrintLn(' total qty2 '|| l_transacted_qty2);

1128:
1129: GMI_Reservation_Util.PrintLn('Total qtys have been transacted for source line '
1130: || l_mo_line_rec.txn_source_line_id);
1131: GMI_Reservation_Util.PrintLn(' total qty1 '|| l_transacted_qty);
1132: GMI_Reservation_Util.PrintLn(' total qty2 '|| l_transacted_qty2);
1133:
1134: OPEN get_trans_qty_for_del(l_mo_line_rec.txn_source_line_id, p_delivery_detail_id);
1135: FETCH get_trans_qty_for_del Into l_del_trans_qty, l_del_trans_qty2;
1136: IF(get_trans_qty_for_del%NOTFOUND )

Line 1142: GMI_Reservation_Util.PrintLn('Total qty1 being transacted '|| l_del_trans_qty);

1138: CLOSE get_trans_qty_for_del;
1139: END IF;
1140: CLOSE get_trans_qty_for_del;
1141:
1142: GMI_Reservation_Util.PrintLn('Total qty1 being transacted '|| l_del_trans_qty);
1143: GMI_Reservation_Util.PrintLn('Total qty2 being transacted '|| l_del_trans_qty2);
1144:
1145: l_trans_qty := nvl(l_del_trans_qty,0);
1146: l_trans_qty2 := nvl(l_del_trans_qty2,0);

Line 1143: GMI_Reservation_Util.PrintLn('Total qty2 being transacted '|| l_del_trans_qty2);

1139: END IF;
1140: CLOSE get_trans_qty_for_del;
1141:
1142: GMI_Reservation_Util.PrintLn('Total qty1 being transacted '|| l_del_trans_qty);
1143: GMI_Reservation_Util.PrintLn('Total qty2 being transacted '|| l_del_trans_qty2);
1144:
1145: l_trans_qty := nvl(l_del_trans_qty,0);
1146: l_trans_qty2 := nvl(l_del_trans_qty2,0);
1147:

Line 1148: GMI_RESERVATION_UTIL.PrintLn('Before Calling GMI_Pick_Wave_Confirm_PVT.Check_Shipping_Tolerances');

1144:
1145: l_trans_qty := nvl(l_del_trans_qty,0);
1146: l_trans_qty2 := nvl(l_del_trans_qty2,0);
1147:
1148: GMI_RESERVATION_UTIL.PrintLn('Before Calling GMI_Pick_Wave_Confirm_PVT.Check_Shipping_Tolerances');
1149:
1150: GMI_Pick_Wave_Confirm_PVT.Check_Shipping_Tolerances
1151: ( x_return_status => x_return_status,
1152: x_msg_count => x_msg_count,

Line 1162: GMI_RESERVATION_UTIL.PrintLn('After Calling GMI_Pick_Wave_Confirm_PVT.Check_Shipping_Tolerances');

1158: p_quantity => l_trans_qty,
1159: p_quantity2 => l_trans_qty2
1160: );
1161:
1162: GMI_RESERVATION_UTIL.PrintLn('After Calling GMI_Pick_Wave_Confirm_PVT.Check_Shipping_Tolerances');
1163: GMI_RESERVATION_UTIL.PrintLn('Status from Check_Shipping_Tolerances : '||x_return_status);
1164: IF x_return_status <> 'S' THEN
1165: fnd_message.set_name('INV', 'INV_CHECK_TOLERANCE_ERROR');
1166: RAISE FND_API.G_EXC_ERROR;

Line 1163: GMI_RESERVATION_UTIL.PrintLn('Status from Check_Shipping_Tolerances : '||x_return_status);

1159: p_quantity2 => l_trans_qty2
1160: );
1161:
1162: GMI_RESERVATION_UTIL.PrintLn('After Calling GMI_Pick_Wave_Confirm_PVT.Check_Shipping_Tolerances');
1163: GMI_RESERVATION_UTIL.PrintLn('Status from Check_Shipping_Tolerances : '||x_return_status);
1164: IF x_return_status <> 'S' THEN
1165: fnd_message.set_name('INV', 'INV_CHECK_TOLERANCE_ERROR');
1166: RAISE FND_API.G_EXC_ERROR;
1167: ELSE

Line 1169: GMI_Reservation_Util.PrintLn('WARNING!');

1165: fnd_message.set_name('INV', 'INV_CHECK_TOLERANCE_ERROR');
1166: RAISE FND_API.G_EXC_ERROR;
1167: ELSE
1168: IF l_allowed = 'N' THEN
1169: GMI_Reservation_Util.PrintLn('WARNING!');
1170: GMI_Reservation_Util.PrintLn('MOVE ORDER line : line_id ='||l_mo_line_rec.line_id ||
1171: ' can not be transacted because picked qty exceeds over shippment tolerance. '||
1172: ' The allocated quantity is '|| l_mo_line_rec.quantity_detailed
1173: ||' but the max allowed quantity is '||

Line 1170: GMI_Reservation_Util.PrintLn('MOVE ORDER line : line_id ='||l_mo_line_rec.line_id ||

1166: RAISE FND_API.G_EXC_ERROR;
1167: ELSE
1168: IF l_allowed = 'N' THEN
1169: GMI_Reservation_Util.PrintLn('WARNING!');
1170: GMI_Reservation_Util.PrintLn('MOVE ORDER line : line_id ='||l_mo_line_rec.line_id ||
1171: ' can not be transacted because picked qty exceeds over shippment tolerance. '||
1172: ' The allocated quantity is '|| l_mo_line_rec.quantity_detailed
1173: ||' but the max allowed quantity is '||
1174: l_max_qty || ' Please reduce allocation quantity ');

Line 1180: GMI_Reservation_Util.PrintLn('(opm_dbg) mo_header_id ='||l_mo_line_tbl(1).header_id);

1176: RETURN;
1177: END IF ;
1178: END IF;
1179:
1180: GMI_Reservation_Util.PrintLn('(opm_dbg) mo_header_id ='||l_mo_line_tbl(1).header_id);
1181: GMI_Reservation_Util.PrintLn('(opm_dbg) mo_line_tbl.COUNT ='||l_mo_line_tbl.COUNT);
1182:
1183: SAVEPOINT GMI_Before_Pick_Confirm;
1184: l_commit := FND_API.G_FALSE;

Line 1181: GMI_Reservation_Util.PrintLn('(opm_dbg) mo_line_tbl.COUNT ='||l_mo_line_tbl.COUNT);

1177: END IF ;
1178: END IF;
1179:
1180: GMI_Reservation_Util.PrintLn('(opm_dbg) mo_header_id ='||l_mo_line_tbl(1).header_id);
1181: GMI_Reservation_Util.PrintLn('(opm_dbg) mo_line_tbl.COUNT ='||l_mo_line_tbl.COUNT);
1182:
1183: SAVEPOINT GMI_Before_Pick_Confirm;
1184: l_commit := FND_API.G_FALSE;
1185:

Line 1186: GMI_Reservation_Util.PrintLn('(opm_dbg) Before calling Pick_Confirm ='||l_mo_line_tbl(1).header_id);

1182:
1183: SAVEPOINT GMI_Before_Pick_Confirm;
1184: l_commit := FND_API.G_FALSE;
1185:
1186: GMI_Reservation_Util.PrintLn('(opm_dbg) Before calling Pick_Confirm ='||l_mo_line_tbl(1).header_id);
1187: GMI_Pick_Wave_Confirm_PVT.Pick_Confirm(
1188: p_api_version_number => 1.0,
1189: p_init_msg_lst => FND_API.G_FALSE,
1190: p_validation_flag => FND_API.G_VALID_LEVEL_FULL,

Line 1199: GMI_Reservation_Util.PrintLn('(opm_dbg) l_return_status from GMI_pick_wave_Confirm_pub.Pick_Confirm is ' || l_return_status);

1195: x_return_status => l_return_status,
1196: x_msg_data => x_msg_data,
1197: x_msg_count => x_msg_count);
1198:
1199: GMI_Reservation_Util.PrintLn('(opm_dbg) l_return_status from GMI_pick_wave_Confirm_pub.Pick_Confirm is ' || l_return_status);
1200: GMI_Reservation_Util.PrintLn('(opm_dbg) mo_line.count=' || ll_mo_line_tbl.count);
1201: /* Message('l_return_status from GMI_pick_release_pub.Auto_detail is ' || l_return_status); */
1202:
1203: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

Line 1200: GMI_Reservation_Util.PrintLn('(opm_dbg) mo_line.count=' || ll_mo_line_tbl.count);

1196: x_msg_data => x_msg_data,
1197: x_msg_count => x_msg_count);
1198:
1199: GMI_Reservation_Util.PrintLn('(opm_dbg) l_return_status from GMI_pick_wave_Confirm_pub.Pick_Confirm is ' || l_return_status);
1200: GMI_Reservation_Util.PrintLn('(opm_dbg) mo_line.count=' || ll_mo_line_tbl.count);
1201: /* Message('l_return_status from GMI_pick_release_pub.Auto_detail is ' || l_return_status); */
1202:
1203: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
1204: THEN

Line 1205: GMI_Reservation_Util.PrintLn('return error');

1201: /* Message('l_return_status from GMI_pick_release_pub.Auto_detail is ' || l_return_status); */
1202:
1203: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )
1204: THEN
1205: GMI_Reservation_Util.PrintLn('return error');
1206: FND_MESSAGE.Set_Name('GMI','PICK_CONFIRM_ERROR');
1207: FND_MESSAGE.Set_Token('WHERE', 'AFTER_CALL_PICK_CONFIRM');
1208: FND_MESSAGE.Set_Token('WHAT', 'UnexpectedError');
1209: FND_MSG_PUB.Add;

Line 1215: GMI_Reservation_Util.PrintLn('return error');

1211: END IF;
1212:
1213: IF ( ll_mo_line_tbl.count = 0 )
1214: THEN
1215: GMI_Reservation_Util.PrintLn('return error');
1216: FND_MESSAGE.Set_Name('GMI','PICK_CONFIRM_ERROR');
1217: FND_MESSAGE.Set_Token('WHERE', 'MO_LINE_COUNT_0');
1218: FND_MESSAGE.Set_Token('WHAT', 'UnexpectedError');
1219: FND_MSG_PUB.Add;

Line 1226: GMI_Reservation_Util.PrintLn('(opm_dbg) Before setting the return value');

1222:
1223: END IF;
1224:
1225:
1226: GMI_Reservation_Util.PrintLn('(opm_dbg) Before setting the return value');
1227: /* ==================================================================
1228: Set the Returned values from the GMI_Reservation_Util.ic_tran_rec_tbl
1229: ================================================================== */
1230: x_delivered_qty := ll_mo_line_tbl(1).quantity_delivered;

Line 1228: Set the Returned values from the GMI_Reservation_Util.ic_tran_rec_tbl

1224:
1225:
1226: GMI_Reservation_Util.PrintLn('(opm_dbg) Before setting the return value');
1227: /* ==================================================================
1228: Set the Returned values from the GMI_Reservation_Util.ic_tran_rec_tbl
1229: ================================================================== */
1230: x_delivered_qty := ll_mo_line_tbl(1).quantity_delivered;
1231:
1232: GMI_Reservation_Util.PrintLn('(opm_dbg) Before setting the return value 1');

Line 1232: GMI_Reservation_Util.PrintLn('(opm_dbg) Before setting the return value 1');

1228: Set the Returned values from the GMI_Reservation_Util.ic_tran_rec_tbl
1229: ================================================================== */
1230: x_delivered_qty := ll_mo_line_tbl(1).quantity_delivered;
1231:
1232: GMI_Reservation_Util.PrintLn('(opm_dbg) Before setting the return value 1');
1233: x_qty_UM := ll_mo_line_tbl(1).uom_code;
1234:
1235: GMI_Reservation_Util.PrintLn('(opm_dbg) Before setting the return value 2');
1236: x_delivered_qty2 := ll_mo_line_tbl(1).secondary_quantity_delivered;

Line 1235: GMI_Reservation_Util.PrintLn('(opm_dbg) Before setting the return value 2');

1231:
1232: GMI_Reservation_Util.PrintLn('(opm_dbg) Before setting the return value 1');
1233: x_qty_UM := ll_mo_line_tbl(1).uom_code;
1234:
1235: GMI_Reservation_Util.PrintLn('(opm_dbg) Before setting the return value 2');
1236: x_delivered_qty2 := ll_mo_line_tbl(1).secondary_quantity_delivered;
1237:
1238: GMI_Reservation_Util.PrintLn('(opm_dbg) Before setting the return value 3');
1239: x_qty_UM2 := ll_mo_line_tbl(1).secondary_uom_code;

Line 1238: GMI_Reservation_Util.PrintLn('(opm_dbg) Before setting the return value 3');

1234:
1235: GMI_Reservation_Util.PrintLn('(opm_dbg) Before setting the return value 2');
1236: x_delivered_qty2 := ll_mo_line_tbl(1).secondary_quantity_delivered;
1237:
1238: GMI_Reservation_Util.PrintLn('(opm_dbg) Before setting the return value 3');
1239: x_qty_UM2 := ll_mo_line_tbl(1).secondary_uom_code;
1240:
1241: GMI_Reservation_Util.PrintLn('(opm_dbg) End of GMI_auto_allocation_batch_pkg.Call_Pick_Confirm, l_return_status is '
1242: || l_return_status);

Line 1241: GMI_Reservation_Util.PrintLn('(opm_dbg) End of GMI_auto_allocation_batch_pkg.Call_Pick_Confirm, l_return_status is '

1237:
1238: GMI_Reservation_Util.PrintLn('(opm_dbg) Before setting the return value 3');
1239: x_qty_UM2 := ll_mo_line_tbl(1).secondary_uom_code;
1240:
1241: GMI_Reservation_Util.PrintLn('(opm_dbg) End of GMI_auto_allocation_batch_pkg.Call_Pick_Confirm, l_return_status is '
1242: || l_return_status);
1243:
1244: EXCEPTION
1245: WHEN FND_API.G_EXC_ERROR THEN

Line 1279: , x_ic_item_mst_rec OUT NOCOPY GMI_Reservation_Util.ic_item_mst_rec

1275:
1276: PROCEDURE get_allocation_record
1277: ( p_wdd_line IN wsh_delivery_details%rowtype
1278: , x_allocation_rec OUT NOCOPY GMI_Auto_Allocate_PUB.gmi_allocation_rec
1279: , x_ic_item_mst_rec OUT NOCOPY GMI_Reservation_Util.ic_item_mst_rec
1280: , x_return_status OUT NOCOPY VARCHAR2
1281: , x_msg_count OUT NOCOPY NUMBER
1282: , x_msg_data OUT NOCOPY VARCHAR2
1283: ) IS

Line 1351: GMI_RESERVATION_UTIL.PrintLn('Beginning of Get_Allocation_Record ');

1347: AND w.delete_mark = 0;
1348:
1349: BEGIN
1350:
1351: GMI_RESERVATION_UTIL.PrintLn('Beginning of Get_Allocation_Record ');
1352:
1353: /* ======================================================================= */
1354: /* Init variables */
1355: /* ======================================================================= */

Line 1370: GMI_reservation_Util.PrintLn('Customer info not found');

1366: ;
1367:
1368: IF (c_customer_and_so_info%NOTFOUND) THEN
1369: CLOSE c_customer_and_so_info;
1370: GMI_reservation_Util.PrintLn('Customer info not found');
1371: GMI_reservation_Util.PrintLn('in Util v: cust_no=NOTFOUND');
1372: FND_MESSAGE.Set_Name('GMI','GMI_CUST_INFO');
1373: FND_MESSAGE.Set_Token('SO_LINE_ID', x_allocation_rec.line_id);
1374: FND_MSG_PUB.Add;

Line 1371: GMI_reservation_Util.PrintLn('in Util v: cust_no=NOTFOUND');

1367:
1368: IF (c_customer_and_so_info%NOTFOUND) THEN
1369: CLOSE c_customer_and_so_info;
1370: GMI_reservation_Util.PrintLn('Customer info not found');
1371: GMI_reservation_Util.PrintLn('in Util v: cust_no=NOTFOUND');
1372: FND_MESSAGE.Set_Name('GMI','GMI_CUST_INFO');
1373: FND_MESSAGE.Set_Token('SO_LINE_ID', x_allocation_rec.line_id);
1374: FND_MSG_PUB.Add;
1375: RAISE FND_API.G_EXC_ERROR;

Line 1377: GMI_reservation_Util.PrintLn(' in Util v: cust_id='||x_allocation_rec.of_cust_id||',

1373: FND_MESSAGE.Set_Token('SO_LINE_ID', x_allocation_rec.line_id);
1374: FND_MSG_PUB.Add;
1375: RAISE FND_API.G_EXC_ERROR;
1376: ELSE
1377: GMI_reservation_Util.PrintLn(' in Util v: cust_id='||x_allocation_rec.of_cust_id||',
1378: doc_line='||x_allocation_rec.doc_line);
1379: END IF;
1380: CLOSE c_customer_and_so_info;
1381:

Line 1387: GMI_RESERVATION_UTIL.PrintLn('Set up Trans rec');

1383: /* Initialize the allocation record type */
1384: /* Note that the Qty are not converted (only the Apps/OPM UOM) */
1385: /* ============================================================================================= */
1386:
1387: GMI_RESERVATION_UTIL.PrintLn('Set up Trans rec');
1388: x_allocation_rec.doc_id := INV_SALESORDER.GET_SALESORDER_FOR_OEHEADER(l_header_id);
1389:
1390: IF ( x_allocation_rec.doc_id IS NULL ) THEN
1391: FND_MESSAGE.SET_NAME('GMI','INV_COULD_NOT_GET_MSO_HEADER');

Line 1401: GMI_RESERVATION_UTIL.PrintLn('get_allocated_qty%NOTFOUND');

1397: OPEN get_allocated_qty (p_wdd_line.source_line_id, p_wdd_line.delivery_detail_id);
1398: FETCH get_allocated_qty Into l_del_qty, l_del_qty2;
1399: IF(get_allocated_qty%NOTFOUND)
1400: THEN
1401: GMI_RESERVATION_UTIL.PrintLn('get_allocated_qty%NOTFOUND');
1402: CLOSE get_allocated_qty;
1403: END IF;
1404: CLOSE get_allocated_qty;
1405:

Line 1407: GMI_reservation_Util.PrintLn(' allocated qty for delivery '||l_del_qty);

1403: END IF;
1404: CLOSE get_allocated_qty;
1405:
1406:
1407: GMI_reservation_Util.PrintLn(' allocated qty for delivery '||l_del_qty);
1408: GMI_reservation_Util.PrintLn(' allocated qty2 for delivery '||l_del_qty2);
1409:
1410: x_allocation_rec.line_id := p_wdd_line.source_line_id;
1411: x_allocation_rec.prefqc_grade := p_wdd_line.preferred_grade;

Line 1408: GMI_reservation_Util.PrintLn(' allocated qty2 for delivery '||l_del_qty2);

1404: CLOSE get_allocated_qty;
1405:
1406:
1407: GMI_reservation_Util.PrintLn(' allocated qty for delivery '||l_del_qty);
1408: GMI_reservation_Util.PrintLn(' allocated qty2 for delivery '||l_del_qty2);
1409:
1410: x_allocation_rec.line_id := p_wdd_line.source_line_id;
1411: x_allocation_rec.prefqc_grade := p_wdd_line.preferred_grade;
1412: x_allocation_rec.order_qty1 := p_wdd_line.requested_quantity - nvl(l_del_qty,0);

Line 1414: GMI_reservation_Util.PrintLn(' requested qty for delivery '||p_wdd_line.requested_quantity);

1410: x_allocation_rec.line_id := p_wdd_line.source_line_id;
1411: x_allocation_rec.prefqc_grade := p_wdd_line.preferred_grade;
1412: x_allocation_rec.order_qty1 := p_wdd_line.requested_quantity - nvl(l_del_qty,0);
1413:
1414: GMI_reservation_Util.PrintLn(' requested qty for delivery '||p_wdd_line.requested_quantity);
1415:
1416: IF x_allocation_rec.order_qty1 < 0 THEN
1417: x_allocation_rec.order_qty1 := 0;
1418: END IF;

Line 1426: GMI_RESERVATION_UTIL.PrintLn('get_whse_code%NOTFOUND');

1422: OPEN get_whse_code(p_wdd_line.organization_id);
1423: FETCH get_whse_code INTO x_allocation_rec.whse_code;
1424: IF(get_whse_code%NOTFOUND)
1425: THEN
1426: GMI_RESERVATION_UTIL.PrintLn('get_whse_code%NOTFOUND');
1427: CLOSE get_whse_code;
1428: END IF;
1429:
1430: CLOSE get_whse_code;

Line 1444: GMI_RESERVATION_UTIL.PrintLn('Before Opening cursor Cur_get_process_org');

1440: /* ============================================================================================= */
1441: /* Get whse, and organization code from Process. */
1442: /* ============================================================================================= */
1443:
1444: GMI_RESERVATION_UTIL.PrintLn('Before Opening cursor Cur_get_process_org');
1445:
1446: OPEN cur_get_process_org(p_wdd_line.organization_id);
1447: FETCH cur_get_process_org INTO x_allocation_rec.whse_code,l_co_code,x_orgn_code;
1448: IF(Cur_get_process_org%NOTFOUND) THEN

Line 1450: GMI_reservation_Util.PrintLn(' in end of Get_Allocation__Record ERROR:No rows found for cur_get_process_org.');

1446: OPEN cur_get_process_org(p_wdd_line.organization_id);
1447: FETCH cur_get_process_org INTO x_allocation_rec.whse_code,l_co_code,x_orgn_code;
1448: IF(Cur_get_process_org%NOTFOUND) THEN
1449: CLOSE Cur_get_process_org;
1450: GMI_reservation_Util.PrintLn(' in end of Get_Allocation__Record ERROR:No rows found for cur_get_process_org.');
1451: FND_MESSAGE.Set_Name('GMI','GMI_GET_PROCESS_ORG');
1452: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_wdd_line.organization_id);
1453: FND_MSG_PUB.Add;
1454: RAISE FND_API.G_EXC_ERROR;

Line 1464: GMI_RESERVATION_UTIL.PrintLn('Before get opm item from apps');

1460:
1461: /* ============================================================================================= */
1462: /* Get Item details */
1463: /* ============================================================================================= */
1464: GMI_RESERVATION_UTIL.PrintLn('Before get opm item from apps');
1465:
1466: GMI_RESERVATION_UTIL.Get_OPM_item_from_Apps(
1467: p_organization_id => p_wdd_line.organization_id
1468: , p_inventory_item_id => p_wdd_line.inventory_item_id

Line 1466: GMI_RESERVATION_UTIL.Get_OPM_item_from_Apps(

1462: /* Get Item details */
1463: /* ============================================================================================= */
1464: GMI_RESERVATION_UTIL.PrintLn('Before get opm item from apps');
1465:
1466: GMI_RESERVATION_UTIL.Get_OPM_item_from_Apps(
1467: p_organization_id => p_wdd_line.organization_id
1468: , p_inventory_item_id => p_wdd_line.inventory_item_id
1469: , x_ic_item_mst_rec => x_ic_item_mst_rec
1470: , x_return_status => x_return_status

Line 1475: GMI_reservation_Util.PrintLn(' in Util v: item_no='||x_ic_item_mst_rec.item_no);

1471: , x_msg_count => x_msg_count
1472: , x_msg_data => x_msg_data);
1473:
1474:
1475: GMI_reservation_Util.PrintLn(' in Util v: item_no='||x_ic_item_mst_rec.item_no);
1476:
1477: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1478: THEN
1479: GMI_RESERVATION_UTIL.PrintLn('Status get opm item from apps '|| x_return_status);

Line 1479: GMI_RESERVATION_UTIL.PrintLn('Status get opm item from apps '|| x_return_status);

1475: GMI_reservation_Util.PrintLn(' in Util v: item_no='||x_ic_item_mst_rec.item_no);
1476:
1477: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1478: THEN
1479: GMI_RESERVATION_UTIL.PrintLn('Status get opm item from apps '|| x_return_status);
1480: GMI_reservation_Util.PrintLn(' in end of GMI_Reservation_Util.Get_Allocation_Record
1481: ERROR:Returned by Get_OPM_item_from_Apps.');
1482: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
1483: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_wdd_line.organization_id);

Line 1480: GMI_reservation_Util.PrintLn(' in end of GMI_Reservation_Util.Get_Allocation_Record

1476:
1477: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)
1478: THEN
1479: GMI_RESERVATION_UTIL.PrintLn('Status get opm item from apps '|| x_return_status);
1480: GMI_reservation_Util.PrintLn(' in end of GMI_Reservation_Util.Get_Allocation_Record
1481: ERROR:Returned by Get_OPM_item_from_Apps.');
1482: FND_MESSAGE.Set_Name('GMI','GMI_OPM_ITEM');
1483: FND_MESSAGE.Set_Token('ORGANIZATION_ID', p_wdd_line.organization_id);
1484: FND_MESSAGE.Set_Token('INVENTORY_ITEM_ID', p_wdd_line.inventory_item_id);

Line 1511: GMI_reservation_Util.PrintLn(' Exiting Util Get_Allocation_Record:');

1507: /* ============================================================================================= */
1508: /* Get User details not needed */
1509: /* ============================================================================================= */
1510:
1511: GMI_reservation_Util.PrintLn(' Exiting Util Get_Allocation_Record:');
1512:
1513: EXCEPTION
1514: WHEN FND_API.G_EXC_ERROR THEN
1515: GMI_Reservation_Util.PrintLn('Exiting Util Get_Allocation_Record: Error');

Line 1515: GMI_Reservation_Util.PrintLn('Exiting Util Get_Allocation_Record: Error');

1511: GMI_reservation_Util.PrintLn(' Exiting Util Get_Allocation_Record:');
1512:
1513: EXCEPTION
1514: WHEN FND_API.G_EXC_ERROR THEN
1515: GMI_Reservation_Util.PrintLn('Exiting Util Get_Allocation_Record: Error');
1516: x_return_status := FND_API.G_RET_STS_ERROR;
1517:
1518: /* Get message count and data */
1519: FND_MSG_PUB.count_and_get

Line 1525: GMI_Reservation_Util.PrintLn('Exiting Util Get_Allocation_Record: ErrorOther');

1521: , p_data => x_msg_data
1522: );
1523:
1524: WHEN OTHERS THEN
1525: GMI_Reservation_Util.PrintLn('Exiting Util Get_Allocation_Record: ErrorOther');
1526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1527:
1528: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
1529: , l_api_name

Line 1656: gmi_reservation_util.Println(' Line Insert Error => ' || l_err_no ||

1652: l_err_no :=SQLCODE;
1653: l_err_msg :=SUBSTR(SQLERRM,1 ,100);
1654:
1655: WSH_UTIL_CORE.Println(' Line Insert Error => ' || l_err_no || l_err_msg);
1656: gmi_reservation_util.Println(' Line Insert Error => ' || l_err_no ||
1657: l_err_msg );
1658:
1659: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1660: THEN

Line 1684: GMI_RESERVATION_UTIL.println('before submit_request');

1680: l_version NUMBER ;
1681:
1682: BEGIN
1683: l_version := 1.0;
1684: GMI_RESERVATION_UTIL.println('before submit_request');
1685: l_Request_Id := FND_REQUEST.Submit_Request('GML','GMIALLOC','','',FALSE,1.0,
1686: FND_API.G_FALSE,FND_API.G_TRUE,p_batch_id);
1687: /*
1688:

Line 1702: GMI_RESERVATION_UTIL.println('l_msg is :'|| l_msg);

1698: '','','','','','','','','','');
1699: */
1700: IF(l_request_id = 0 )THEN
1701: FND_MESSAGE.RETRIEVE(l_msg);
1702: GMI_RESERVATION_UTIL.println('l_msg is :'|| l_msg);
1703: END IF;
1704:
1705: GMI_RESERVATION_UTIL.println('request_id is : '||l_request_id);
1706: Return L_Request_Id;

Line 1705: GMI_RESERVATION_UTIL.println('request_id is : '||l_request_id);

1701: FND_MESSAGE.RETRIEVE(l_msg);
1702: GMI_RESERVATION_UTIL.println('l_msg is :'|| l_msg);
1703: END IF;
1704:
1705: GMI_RESERVATION_UTIL.println('request_id is : '||l_request_id);
1706: Return L_Request_Id;
1707:
1708: END Submit_allocation_request;
1709: