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 FND_API

Line 39: | p_init_msg_list FND_API.G_TRUE to reset list

35: /***************************************************************************/
36: /*
37: | PARAMETERS:
38: | p_api_version Known api version
39: | p_init_msg_list FND_API.G_TRUE to reset list
40: | p_commit Commit flag. API commits if this is set.
41: | x_return_status Return status
42: | x_msg_count Number of messages in the list
43: | x_msg_data Text of messages

Line 135: x_return_status := FND_API.G_RET_STS_SUCCESS;

131: BEGIN
132:
133: /*Int variables
134: =========================================*/
135: x_return_status := FND_API.G_RET_STS_SUCCESS;
136: retcode := x_return_status;
137:
138: /* Standard begin of API savepoint
139: ===========================================*/

Line 145: IF NOT FND_API.compatible_api_call (

141:
142: /*Standard call to check for call compatibility.
143: ==============================================*/
144:
145: IF NOT FND_API.compatible_api_call (
146: l_api_version,
147: p_api_version,
148: l_api_name,
149: G_PKG_NAME)

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 152: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
156: =========================================*/

Line 157: IF FND_API.to_boolean(p_init_msg_list)

153: END IF;
154:
155: /* Check p_init_msg_list
156: =========================================*/
157: IF FND_API.to_boolean(p_init_msg_list)
158: THEN
159: FND_MSG_PUB.initialize;
160: END IF;
161:

Line 169: RAISE FND_API.G_EXC_ERROR;

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;
170: END IF;
171:
172: OPEN get_batch_rec_cur;
173: FETCH get_batch_rec_cur INTO l_batch_rec;

Line 181: RAISE FND_API.G_EXC_ERROR;

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;
182: END IF;
183:
184: CLOSE get_batch_rec_cur;
185:

Line 251: IF ( TO_CHAR(l_batch_rec.from_sched_ship_date) <> FND_API.G_MISS_CHAR AND

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
252: TO_CHAR(l_batch_rec.from_sched_ship_date, 'DD-MON-YYYY') <> ' ')
253: THEN
254: l_where_clause := l_where_clause || ' AND TO_DATE(date_scheduled ';
255: l_where_clause := l_where_clause || ',';

Line 272: IF ( TO_CHAR(l_batch_rec.to_sched_ship_date) <> FND_API.G_MISS_CHAR AND

268: l_where_clause := l_where_clause || '''';
269: l_where_clause := l_where_clause || ')';
270: END IF;
271:
272: IF ( TO_CHAR(l_batch_rec.to_sched_ship_date) <> FND_API.G_MISS_CHAR AND
273: TO_CHAR(l_batch_rec.to_sched_ship_date, 'DD-MON-YY') <> ' ')
274: THEN
275: l_where_clause := l_where_clause || ' AND TO_DATE(date_scheduled ';
276: l_where_clause := l_where_clause || ',';

Line 304: RAISE FND_API.G_EXC_ERROR;

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;
307:
308: l_where_clause := l_where_clause || ' AND organization_id = ';

Line 325: RAISE FND_API.G_EXC_ERROR;

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;
328:
329: l_where_clause := l_where_clause || ' AND inventory_item_id = ';

Line 354: ,p_init_msg_list => FND_API.G_FALSE

350: /* Call auto_alloc_Wdd_line */
351:
352: Auto_Alloc_Wdd_Line (
353: p_api_version => 1.0
354: ,p_init_msg_list => FND_API.G_FALSE
355: ,p_commit => FND_API.G_FALSE
356: ,p_wdd_rec => l_wdd_rec
357: ,p_batch_rec => l_batch_rec
358: ,x_number_of_rows => l_number_of_rows

Line 355: ,p_commit => FND_API.G_FALSE

351:
352: Auto_Alloc_Wdd_Line (
353: p_api_version => 1.0
354: ,p_init_msg_list => FND_API.G_FALSE
355: ,p_commit => FND_API.G_FALSE
356: ,p_wdd_rec => l_wdd_rec
357: ,p_batch_rec => l_batch_rec
358: ,x_number_of_rows => l_number_of_rows
359: ,x_qc_grade => l_qc_grade

Line 376: ELSIF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

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)
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');

Line 382: RAISE FND_API.G_EXC_ERROR;

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;
383: END IF;
384: x_return_status := l_return_status;
385:
386: /* If pick_confirm flag is set then, auto_pick_confirm */

Line 389: IF ( l_batch_rec.pick_confirm_flag = 'Y' AND x_return_status = FND_API.G_RET_STS_SUCCESS)

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);
392: l_return_status := FND_API.G_RET_STS_SUCCESS;
393:

Line 392: l_return_status := FND_API.G_RET_STS_SUCCESS;

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:
396: IF(l_wdd_rec.released_status = 'S') THEN

Line 418: ELSIF (l_return_status <> FND_API.G_RET_STS_SUCCESS)

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';
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');

Line 424: RAISE FND_API.G_EXC_ERROR;

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;
426:
427: ELSE
428: GMI_RESERVATION_UTIL.PrintLn('Can Not Pick Confirm, The release status for the delivery_line is: '||

Line 441: WHEN FND_API.G_EXC_ERROR THEN

437:
438: /* EXCEPTION HANDLING
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;

Line 445: x_return_status := FND_API.G_RET_STS_ERROR;

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:
449: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME

Line 452: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE

448:
449: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
450: , l_api_name
451: );
452: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
453: , p_count => x_msg_count
454: , p_data => x_msg_data
455: );
456:

Line 457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

453: , p_count => x_msg_count
454: , p_data => x_msg_data
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:

Line 462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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;
465:
466:

Line 470: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

466:
467: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
468: , l_api_name
469: );
470: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
471: , p_count => x_msg_count
472: , p_data => x_msg_data
473: );
474: WHEN OTHERS THEN

Line 483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

479: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
480: , l_api_name
481: );
482:
483: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
484: errbuf := SUBSTRB(SQLERRM, 1, 150);
485: retcode := x_return_status;
486:
487: /* Get message count and data */

Line 501: | p_init_msg_list FND_API.G_TRUE to reset list

497: /***************************************************************************/
498: /*
499: | PARAMETERS:
500: | p_api_version Known api version
501: | p_init_msg_list FND_API.G_TRUE to reset list
502: | p_commit Commit flag. API commits if this is set.
503: | x_return_status Return status
504: | x_msg_count Number of messages in the list
505: | x_msg_data Text of messages

Line 646: x_return_status := FND_API.G_RET_STS_SUCCESS;

642: BEGIN
643:
644: /*Init variables
645: =========================================*/
646: x_return_status := FND_API.G_RET_STS_SUCCESS;
647:
648:
649: /* Standard begin of API savepoint
650: ===========================================*/

Line 656: IF NOT FND_API.compatible_api_call (

652:
653: /*Standard call to check for call compatibility.
654: ==============================================*/
655:
656: IF NOT FND_API.compatible_api_call (
657: l_api_version,
658: p_api_version,
659: l_api_name,
660: G_PKG_NAME)

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 663: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
667: /* Check p_init_msg_list

Line 669: IF FND_API.to_boolean(p_init_msg_list)

665:
666:
667: /* Check p_init_msg_list
668: =========================================*/
669: IF FND_API.to_boolean(p_init_msg_list)
670: THEN
671: FND_MSG_PUB.initialize;
672: END IF;
673:

Line 707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
710: CLOSE get_whse_code_cur;
711:

Line 735: , FND_API.G_FALSE

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
736: , FND_API.G_FALSE
737: , FND_API.G_VALID_LEVEL_FULL
738: , l_tran_rec
739: , l_tran_row

Line 736: , FND_API.G_FALSE

732:
733: GMI_TRANS_ENGINE_PUB.delete_pending_transaction (
734: 1
735: , FND_API.G_FALSE
736: , FND_API.G_FALSE
737: , FND_API.G_VALID_LEVEL_FULL
738: , l_tran_rec
739: , l_tran_row
740: , x_return_status

Line 737: , FND_API.G_VALID_LEVEL_FULL

733: GMI_TRANS_ENGINE_PUB.delete_pending_transaction (
734: 1
735: , FND_API.G_FALSE
736: , FND_API.G_FALSE
737: , FND_API.G_VALID_LEVEL_FULL
738: , l_tran_rec
739: , l_tran_row
740: , x_return_status
741: , x_msg_count

Line 747: IF x_return_status <> FND_API.G_RET_STS_SUCCESS

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');
750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
751: END IF;

Line 750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
754: END LOOP;

Line 786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
789: CLOSE Get_Whse_Cur;
790:

Line 794: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
798: GMI_RESERVATION_UTIL.println('Alloc Class is missing from item set up.');

Line 800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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 */
804: GMI_RESERVATION_UTIL.println('Before find_default_lot');

Line 816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
820: GMI_RESERVATION_UTIL.println('Default trans exists');

Line 833: IF( l_return_status <> FND_API.G_RET_STS_SUCCESS ) then

829: , x_return_status => x_return_status
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;

Line 835: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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:
839: GMI_RESERVATION_UTIL.println('Before Call To get allocation Parms');

Line 855: IF( l_return_status <> FND_API.G_RET_STS_SUCCESS ) then

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;
858: END IF;
859:

Line 857: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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;
861:

Line 860: --l_commit := FND_API.G_FALSE;

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;
861:
862: OPEN get_item_cur(l_ic_item_mst_rec.item_id);
863: FETCH get_item_cur INTO l_ic_item_mst;
864:

Line 868: raise FND_API.G_EXC_UNEXPECTED_ERROR;

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;
872:

Line 895: ELSIF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

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;
898: END IF;
899:

Line 897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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');
901: GMI_RESERVATION_UTIL.find_default_lot

Line 908: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

904: x_msg_data => x_msg_data,
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:

Line 910: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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;
914: IF GMI_TRAN_PND_DB_PVT.FETCH_IC_TRAN_PND

Line 925: IF l_return_status <> FND_API.G_RET_STS_SUCCESS

921: , x_return_status => l_return_status
922: , x_msg_count => x_msg_count
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;

Line 928: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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:
932: OPEN cur_txn_no_default

Line 944: RAISE FND_API.G_EXC_ERROR;

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;
947:
948: GMI_RESERVATION_UTIL.PrintLn('l_total_qty '||l_total_qty);

Line 958: x_return_status := FND_API.G_RET_STS_SUCCESS;

954: WHERE line_id = p_wdd_rec.move_order_line_id;
955:
956: IF (x_return_status <> WSH_UTIL_CORE.G_RET_STS_WARNING)
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:

Line 966: WHEN FND_API.G_EXC_ERROR THEN

962:
963: /* EXCEPTION HANDLING
964: ====================*/
965: EXCEPTION
966: WHEN FND_API.G_EXC_ERROR THEN
967: ROLLBACK TO SAVEPOINT Auto_Alloc_Wdd_Line_SP;
968:
969: x_return_status := FND_API.G_RET_STS_ERROR;
970:

Line 969: x_return_status := FND_API.G_RET_STS_ERROR;

965: EXCEPTION
966: WHEN FND_API.G_EXC_ERROR THEN
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

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 976: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE

972:
973: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
974: , l_api_name
975: );
976: FND_MSG_PUB.Count_AND_GET ( p_encoded => FND_API.G_FALSE
977: , p_count => x_msg_count
978: , p_data => x_msg_data
979: );
980:

Line 981: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

977: , p_count => x_msg_count
978: , p_data => x_msg_data
979: );
980:
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 ');

Line 984: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

980:
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

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 990: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE

986:
987: FND_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME
988: , l_api_name
989: );
990: FND_MSG_PUB.Count_AND_GET ( p_encoded=> FND_API.G_FALSE
991: , p_count => x_msg_count
992: , p_data => x_msg_data
993: );
994: WHEN OTHERS THEN

Line 1025: l_init_msg_list VARCHAR2(255) := FND_API.G_TRUE;

1021: , x_msg_data OUT NOCOPY VARCHAR2
1022: )
1023: IS
1024: l_api_version_number CONSTANT NUMBER := 1.0;
1025: l_init_msg_list VARCHAR2(255) := FND_API.G_TRUE;
1026: l_api_name CONSTANT VARCHAR2(30) := 'Line_Pick_Confirm';
1027: x_success NUMBER;
1028:
1029: l_mo_hdr_rec GMI_Move_Order_Global.mo_hdr_rec;

Line 1083: x_return_status := FND_API.G_RET_STS_SUCCESS;

1079: AND line_detail_id = p_line_detail_id;
1080:
1081: BEGIN
1082: /* Init status : */
1083: x_return_status := FND_API.G_RET_STS_SUCCESS;
1084:
1085: IF (p_init_msg_list = 1)
1086: THEN
1087: FND_MSG_PUB.Initialize;

Line 1112: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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
1116: -- qty is updated by the system, can not be over allocating

Line 1166: RAISE FND_API.G_EXC_ERROR;

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
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 ||

Line 1184: l_commit := FND_API.G_FALSE;

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:
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,

Line 1189: p_init_msg_lst => 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,
1191: p_commit => l_commit,
1192: p_delivery_detail_id => p_delivery_detail_id,
1193: p_mo_line_tbl => l_mo_line_tbl,

Line 1190: p_validation_flag => FND_API.G_VALID_LEVEL_FULL,

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,
1191: p_commit => l_commit,
1192: p_delivery_detail_id => p_delivery_detail_id,
1193: p_mo_line_tbl => l_mo_line_tbl,
1194: x_mo_line_tbl => ll_mo_line_tbl,

Line 1203: IF ( l_return_status <> FND_API.G_RET_STS_SUCCESS )

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
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');

Line 1210: RAISE FND_API.G_EXC_UNEXPECTED_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;
1210: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1211: END IF;
1212:
1213: IF ( ll_mo_line_tbl.count = 0 )
1214: THEN

Line 1220: RAISE FND_API.G_EXC_UNEXPECTED_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;
1220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1221: END IF;
1222:
1223: END IF;
1224:

Line 1245: WHEN FND_API.G_EXC_ERROR THEN

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
1246: /* ROLLBACK TO SAVEPOINT GMI_Before_Pick_Confirm; */
1247:
1248: x_return_status := FND_API.G_RET_STS_ERROR;
1249: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);

Line 1248: x_return_status := FND_API.G_RET_STS_ERROR;

1244: EXCEPTION
1245: WHEN FND_API.G_EXC_ERROR THEN
1246: /* ROLLBACK TO SAVEPOINT GMI_Before_Pick_Confirm; */
1247:
1248: x_return_status := FND_API.G_RET_STS_ERROR;
1249: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data);
1250:
1251: WHEN G_RET_STS_WARNING THEN
1252:

Line 1263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1259: IF (x_return_status = '54')
1260: THEN
1261: x_return_status := '54' ;
1262: ELSE
1263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1264: END IF;
1265:
1266: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1267: THEN

Line 1356: x_return_status := FND_API.G_RET_STS_SUCCESS;

1352:
1353: /* ======================================================================= */
1354: /* Init variables */
1355: /* ======================================================================= */
1356: x_return_status := FND_API.G_RET_STS_SUCCESS;
1357:
1358: OPEN c_customer_and_so_info(x_allocation_rec.line_id);
1359: FETCH c_customer_and_so_info
1360: INTO x_allocation_rec.of_cust_id

Line 1375: RAISE FND_API.G_EXC_ERROR;

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;
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;

Line 1394: RAISE FND_API.G_EXC_ERROR;

1390: IF ( x_allocation_rec.doc_id IS NULL ) THEN
1391: FND_MESSAGE.SET_NAME('GMI','INV_COULD_NOT_GET_MSO_HEADER');
1392: FND_MESSAGE.Set_Token('OE_HEADER_ID', l_header_id);
1393: FND_MSG_PUB.Add;
1394: RAISE FND_API.G_EXC_ERROR;
1395: END IF;
1396:
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;

Line 1454: RAISE FND_API.G_EXC_ERROR;

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;
1455: ELSE
1456: CLOSE Cur_get_process_org;
1457: END IF;
1458:

Line 1477: IF (x_return_status <> FND_API.G_RET_STS_SUCCESS)

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);
1480: GMI_reservation_Util.PrintLn(' in end of GMI_Reservation_Util.Get_Allocation_Record
1481: ERROR:Returned by Get_OPM_item_from_Apps.');

Line 1486: RAISE FND_API.G_EXC_ERROR;

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);
1485: FND_MSG_PUB.Add;
1486: RAISE FND_API.G_EXC_ERROR;
1487: ELSE
1488: x_allocation_rec.item_no := x_ic_item_mst_rec.item_no;
1489: END IF;
1490:

Line 1514: WHEN FND_API.G_EXC_ERROR THEN

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');
1516: x_return_status := FND_API.G_RET_STS_ERROR;
1517:
1518: /* Get message count and data */

Line 1516: x_return_status := FND_API.G_RET_STS_ERROR;

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
1520: ( p_count => x_msg_count

Line 1526: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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
1530: );

Line 1667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1663: , 'Insert_Row'
1664: );
1665: END IF;
1666:
1667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1668:
1669:
1670: END Insert_Row;
1671:

Line 1686: FND_API.G_FALSE,FND_API.G_TRUE,p_batch_id);

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:
1689: '','','','','','','','','','',
1690: '','','','','','','','','','',