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.INV_LPN_RESERVATIONS_PVT dependencies on FND_API

Line 209: RAISE fnd_api.g_exc_unexpected_error;

205: IF (l_debug = 1) THEN
206: debug_print('Missing input parameters');
207: END IF;
208:
209: RAISE fnd_api.g_exc_unexpected_error;
210: END IF;
211:
212: --bug#2402957. call is_lpn_reserved to see if lpn is reserved for some other demand.
213: l_lpn_already_resv := is_lpn_reserved(

Line 228: RAISE fnd_api.g_exc_error;

224: debug_print('Error: LPN is reserved for some other demand line');
225: END IF;
226: fnd_message.set_name('INV', 'INV_CANNOT_RESERVE_LPN');
227: fnd_msg_pub.ADD;
228: RAISE fnd_api.g_exc_error;
229: END IF;
230:
231: OPEN c_item_controls;
232: -- INVCONV - incorporate secondary uom and tracking quantity below

Line 353: RAISE fnd_api.g_exc_error;

349: debug_print('Error: Order Line completely reserved');
350: END IF;
351: fnd_message.set_name('INV', 'INV_CANNOT_CREATE_RESERVATION');
352: fnd_msg_pub.ADD;
353: RAISE fnd_api.g_exc_error;
354: ELSIF ((l_ordered_qty - l_reserved_qty + l_lpn_reserved_qty < l_quantity) and l_fb = 'P')
355: or ((l_sec_ordered_qty - l_sec_rsv_qty + l_lpn_sec_rsv_qty < l_sec_qty) and l_fb = 'S') -- 16773889
356: THEN
357: --error as lpn has more qty than order line.

Line 363: RAISE fnd_api.g_exc_error;

359: debug_print('Error: LPN Qty > Order Line Qty');
360: END IF;
361: fnd_message.set_name('INV', 'INV_LPN_QTY_GREATER');
362: fnd_msg_pub.ADD;
363: RAISE fnd_api.g_exc_error;
364: END IF;
365: END IF;
366:
367: -- create the quantity tree

Line 370: , p_init_msg_lst => fnd_api.g_true

366:
367: -- create the quantity tree
368: inv_quantity_tree_pvt.create_tree(
369: p_api_version_number => 1.0
370: , p_init_msg_lst => fnd_api.g_true
371: , x_return_status => l_return_status
372: , x_msg_count => l_msg_count
373: , x_msg_data => l_msg_data
374: , p_organization_id => p_organization_id

Line 391: IF l_return_status = fnd_api.g_ret_sts_error THEN

387: , p_lot_expiration_date => SYSDATE -- Bug#2716563
388: , x_tree_id => l_tree_id
389: );
390:
391: IF l_return_status = fnd_api.g_ret_sts_error THEN
392: IF (l_debug = 1) THEN
393: debug_print('Error creating quantity tree');
394: END IF;
395:

Line 396: RAISE fnd_api.g_exc_error;

392: IF (l_debug = 1) THEN
393: debug_print('Error creating quantity tree');
394: END IF;
395:
396: RAISE fnd_api.g_exc_error;
397: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
398: IF (l_debug = 1) THEN
399: debug_print('Unexpected error creating quantity tree');
400: END IF;

Line 397: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

393: debug_print('Error creating quantity tree');
394: END IF;
395:
396: RAISE fnd_api.g_exc_error;
397: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
398: IF (l_debug = 1) THEN
399: debug_print('Unexpected error creating quantity tree');
400: END IF;
401:

Line 402: RAISE fnd_api.g_exc_unexpected_error;

398: IF (l_debug = 1) THEN
399: debug_print('Unexpected error creating quantity tree');
400: END IF;
401:
402: RAISE fnd_api.g_exc_unexpected_error;
403: END IF;
404:
405: OPEN c_lpn_contents;
406:

Line 448: , p_init_msg_lst => fnd_api.g_false

444: END IF;
445:
446: inv_reservation_pvt.query_reservation(
447: p_api_version_number => 1.0
448: , p_init_msg_lst => fnd_api.g_false
449: , x_return_status => l_return_status
450: , x_msg_count => l_msg_count
451: , x_msg_data => l_msg_data
452: , p_query_input => l_query_rec

Line 458: IF l_return_status = fnd_api.g_ret_sts_error THEN

454: , x_mtl_reservation_tbl_count => l_rsv_count
455: , x_error_code => l_error_code
456: );
457:
458: IF l_return_status = fnd_api.g_ret_sts_error THEN
459: IF (l_debug = 1) THEN
460: debug_print('Error in query_reservation');
461: END IF;
462:

Line 463: RAISE fnd_api.g_exc_error;

459: IF (l_debug = 1) THEN
460: debug_print('Error in query_reservation');
461: END IF;
462:
463: RAISE fnd_api.g_exc_error;
464: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
465: IF (l_debug = 1) THEN
466: debug_print('Unexpected error in query_reservation');
467: END IF;

Line 464: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

460: debug_print('Error in query_reservation');
461: END IF;
462:
463: RAISE fnd_api.g_exc_error;
464: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
465: IF (l_debug = 1) THEN
466: debug_print('Unexpected error in query_reservation');
467: END IF;
468:

Line 469: RAISE fnd_api.g_exc_unexpected_error;

465: IF (l_debug = 1) THEN
466: debug_print('Unexpected error in query_reservation');
467: END IF;
468:
469: RAISE fnd_api.g_exc_unexpected_error;
470: END IF;
471:
472: -- If reservation exists
473: IF l_rsv_count >= 1 THEN

Line 505: , p_init_msg_lst => fnd_api.g_true

501:
502: --query quantity tree to make sure quantity is available to increase reservations
503: inv_quantity_tree_pvt.query_tree(
504: p_api_version_number => 1.0
505: , p_init_msg_lst => fnd_api.g_true
506: , x_return_status => l_return_status
507: , x_msg_count => l_msg_count
508: , x_msg_data => l_msg_data
509: , p_tree_id => l_tree_id

Line 532: IF l_return_status = fnd_api.g_ret_sts_error THEN

528: , p_lpn_id => p_lpn_id
529: , p_transfer_locator_id => NULL
530: );
531:
532: IF l_return_status = fnd_api.g_ret_sts_error THEN
533: IF (l_debug = 1) THEN
534: debug_print('Error from query_tree');
535: END IF;
536:

Line 537: RAISE fnd_api.g_exc_error;

533: IF (l_debug = 1) THEN
534: debug_print('Error from query_tree');
535: END IF;
536:
537: RAISE fnd_api.g_exc_error;
538: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
539: IF (l_debug = 1) THEN
540: debug_print('Unexpected error from query_tree');
541: END IF;

Line 538: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

534: debug_print('Error from query_tree');
535: END IF;
536:
537: RAISE fnd_api.g_exc_error;
538: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
539: IF (l_debug = 1) THEN
540: debug_print('Unexpected error from query_tree');
541: END IF;
542:

Line 543: RAISE fnd_api.g_exc_unexpected_error;

539: IF (l_debug = 1) THEN
540: debug_print('Unexpected error from query_tree');
541: END IF;
542:
543: RAISE fnd_api.g_exc_unexpected_error;
544: END IF;
545:
546: --Bug#2402957:
547: -- If (ATR + AlreadyReserved) <> LPN Qty => LPN is reserved for some other demand, so error.

Line 558: RAISE fnd_api.g_exc_error;

554: debug_print('Error: LPN is reserved for some other demand line');
555: END IF;
556: fnd_message.set_name('INV', 'INV_CANNOT_RESERVE_LPN');
557: fnd_msg_pub.ADD;
558: RAISE fnd_api.g_exc_error;
559: END IF;
560:
561: l_increase_quantity := l_atr + l_rsv_tbl(1).primary_reservation_quantity;
562: -- INVCONV BEGIN

Line 584: , p_init_msg_lst => fnd_api.g_false

580: END IF;
581:
582: inv_reservation_pvt.update_reservation(
583: p_api_version_number => 1.0
584: , p_init_msg_lst => fnd_api.g_false
585: , x_return_status => l_return_status
586: , x_msg_count => l_msg_count
587: , x_msg_data => l_msg_data
588: , p_original_rsv_rec => l_rsv_tbl(1)

Line 592: , p_validation_flag => fnd_api.g_true

588: , p_original_rsv_rec => l_rsv_tbl(1)
589: , p_to_rsv_rec => l_rsv_rec
590: , p_original_serial_number => l_dummy_sn
591: , p_to_serial_number => l_dummy_sn
592: , p_validation_flag => fnd_api.g_true
593: );
594:
595: IF l_return_status = fnd_api.g_ret_sts_error THEN
596: IF (l_debug = 1) THEN

Line 595: IF l_return_status = fnd_api.g_ret_sts_error THEN

591: , p_to_serial_number => l_dummy_sn
592: , p_validation_flag => fnd_api.g_true
593: );
594:
595: IF l_return_status = fnd_api.g_ret_sts_error THEN
596: IF (l_debug = 1) THEN
597: debug_print('Error from update_reservation');
598: END IF;
599:

Line 600: RAISE fnd_api.g_exc_error;

596: IF (l_debug = 1) THEN
597: debug_print('Error from update_reservation');
598: END IF;
599:
600: RAISE fnd_api.g_exc_error;
601: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
602: IF (l_debug = 1) THEN
603: debug_print('Unexpected error from update_reservation');
604: END IF;

Line 601: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

597: debug_print('Error from update_reservation');
598: END IF;
599:
600: RAISE fnd_api.g_exc_error;
601: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
602: IF (l_debug = 1) THEN
603: debug_print('Unexpected error from update_reservation');
604: END IF;
605:

Line 606: RAISE fnd_api.g_exc_unexpected_error;

602: IF (l_debug = 1) THEN
603: debug_print('Unexpected error from update_reservation');
604: END IF;
605:
606: RAISE fnd_api.g_exc_unexpected_error;
607: END IF;
608: END IF; -- if new increase quantity > 0
609: END IF; -- if increase quantity > 0
610: ELSE --Else, create new reservation

Line 617: , p_init_msg_lst => fnd_api.g_true

613: END IF;
614:
615: inv_quantity_tree_pvt.query_tree(
616: p_api_version_number => 1.0
617: , p_init_msg_lst => fnd_api.g_true
618: , x_return_status => l_return_status
619: , x_msg_count => l_msg_count
620: , x_msg_data => l_msg_data
621: , p_tree_id => l_tree_id

Line 647: IF l_return_status = fnd_api.g_ret_sts_error THEN

643: , p_lpn_id => p_lpn_id
644: , p_transfer_locator_id => NULL
645: );
646:
647: IF l_return_status = fnd_api.g_ret_sts_error THEN
648: IF (l_debug = 1) THEN
649: debug_print('Error in query_tree');
650: END IF;
651:

Line 652: RAISE fnd_api.g_exc_error;

648: IF (l_debug = 1) THEN
649: debug_print('Error in query_tree');
650: END IF;
651:
652: RAISE fnd_api.g_exc_error;
653: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
654: IF (l_debug = 1) THEN
655: debug_print('Unexpected error in query_tree');
656: END IF;

Line 653: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

649: debug_print('Error in query_tree');
650: END IF;
651:
652: RAISE fnd_api.g_exc_error;
653: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
654: IF (l_debug = 1) THEN
655: debug_print('Unexpected error in query_tree');
656: END IF;
657:

Line 658: RAISE fnd_api.g_exc_unexpected_error;

654: IF (l_debug = 1) THEN
655: debug_print('Unexpected error in query_tree');
656: END IF;
657:
658: RAISE fnd_api.g_exc_unexpected_error;
659: END IF;
660:
661: --Bug#2402957:
662: -- If ATR <> LPN Qty => LPN is also reserved for some other demand, so error.

Line 672: RAISE fnd_api.g_exc_error;

668: debug_print('Error: LPN is reserved for some other order line');
669: END IF;
670: fnd_message.set_name('INV', 'INV_CANNOT_RESERVE_LPN');
671: fnd_msg_pub.ADD;
672: RAISE fnd_api.g_exc_error;
673: END IF;
674:
675: IF (l_debug = 1) THEN
676: debug_print('New Reservation Qty = '|| l_quantity);

Line 746: , p_init_msg_lst => fnd_api.g_false

742:
743: -- INVCONV - Upgrade call for Inventory Convergence
744: inv_reservation_pvt.create_reservation(
745: p_api_version_number => 1.0
746: , p_init_msg_lst => fnd_api.g_false
747: , x_return_status => l_return_status
748: , x_msg_count => l_msg_count
749: , x_msg_data => l_msg_data
750: , p_rsv_rec => l_rsv_rec

Line 753: , p_partial_reservation_flag => fnd_api.g_true

749: , x_msg_data => l_msg_data
750: , p_rsv_rec => l_rsv_rec
751: , p_serial_number => l_dummy_sn
752: , x_serial_number => l_dummy_sn
753: , p_partial_reservation_flag => fnd_api.g_true
754: , p_force_reservation_flag => fnd_api.g_false
755: , p_validation_flag => fnd_api.g_true
756: , x_quantity_reserved => l_quantity_reserved
757: , x_secondary_quantity_reserved => l_secondary_quantity_reserved --INVCONV

Line 754: , p_force_reservation_flag => fnd_api.g_false

750: , p_rsv_rec => l_rsv_rec
751: , p_serial_number => l_dummy_sn
752: , x_serial_number => l_dummy_sn
753: , p_partial_reservation_flag => fnd_api.g_true
754: , p_force_reservation_flag => fnd_api.g_false
755: , p_validation_flag => fnd_api.g_true
756: , x_quantity_reserved => l_quantity_reserved
757: , x_secondary_quantity_reserved => l_secondary_quantity_reserved --INVCONV
758: , x_reservation_id => l_reservation_id

Line 755: , p_validation_flag => fnd_api.g_true

751: , p_serial_number => l_dummy_sn
752: , x_serial_number => l_dummy_sn
753: , p_partial_reservation_flag => fnd_api.g_true
754: , p_force_reservation_flag => fnd_api.g_false
755: , p_validation_flag => fnd_api.g_true
756: , x_quantity_reserved => l_quantity_reserved
757: , x_secondary_quantity_reserved => l_secondary_quantity_reserved --INVCONV
758: , x_reservation_id => l_reservation_id
759: );

Line 761: IF l_return_status = fnd_api.g_ret_sts_error THEN

757: , x_secondary_quantity_reserved => l_secondary_quantity_reserved --INVCONV
758: , x_reservation_id => l_reservation_id
759: );
760:
761: IF l_return_status = fnd_api.g_ret_sts_error THEN
762: IF (l_debug = 1) THEN
763: debug_print('Error in create_reservation');
764: END IF;
765:

Line 766: RAISE fnd_api.g_exc_error;

762: IF (l_debug = 1) THEN
763: debug_print('Error in create_reservation');
764: END IF;
765:
766: RAISE fnd_api.g_exc_error;
767: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
768: IF (l_debug = 1) THEN
769: debug_print('Unexpected error in create_reservation');
770: END IF;

Line 767: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

763: debug_print('Error in create_reservation');
764: END IF;
765:
766: RAISE fnd_api.g_exc_error;
767: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
768: IF (l_debug = 1) THEN
769: debug_print('Unexpected error in create_reservation');
770: END IF;
771:

Line 772: RAISE fnd_api.g_exc_unexpected_error;

768: IF (l_debug = 1) THEN
769: debug_print('Unexpected error in create_reservation');
770: END IF;
771:
772: RAISE fnd_api.g_exc_unexpected_error;
773: END IF;
774: END IF; -- if quantity > 0
775: END IF; -- if reservation count > 0
776: END LOOP;

Line 779: x_return_status := fnd_api.g_ret_sts_success;

775: END IF; -- if reservation count > 0
776: END LOOP;
777:
778: CLOSE c_lpn_contents;
779: x_return_status := fnd_api.g_ret_sts_success;
780:
781: IF (l_debug = 1) THEN
782: debug_print('Exit Create_LPN_Reservations');
783: END IF;

Line 785: WHEN fnd_api.g_exc_error THEN

781: IF (l_debug = 1) THEN
782: debug_print('Exit Create_LPN_Reservations');
783: END IF;
784: EXCEPTION
785: WHEN fnd_api.g_exc_error THEN
786: x_return_status := fnd_api.g_ret_sts_error;
787: ROLLBACK TO entire_lpn; --bug#2402957.
788: IF (l_debug = 1) THEN
789: debug_print('Error in Create_LPN_Reservations');

Line 786: x_return_status := fnd_api.g_ret_sts_error;

782: debug_print('Exit Create_LPN_Reservations');
783: END IF;
784: EXCEPTION
785: WHEN fnd_api.g_exc_error THEN
786: x_return_status := fnd_api.g_ret_sts_error;
787: ROLLBACK TO entire_lpn; --bug#2402957.
788: IF (l_debug = 1) THEN
789: debug_print('Error in Create_LPN_Reservations');
790: END IF;

Line 792: WHEN fnd_api.g_exc_unexpected_error THEN

788: IF (l_debug = 1) THEN
789: debug_print('Error in Create_LPN_Reservations');
790: END IF;
791: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded=> 'F');
792: WHEN fnd_api.g_exc_unexpected_error THEN
793: x_return_status := fnd_api.g_ret_sts_unexp_error;
794:
795: IF (l_debug = 1) THEN
796: debug_print('Unexpected error in Create_LPN_Reservations');

Line 793: x_return_status := fnd_api.g_ret_sts_unexp_error;

789: debug_print('Error in Create_LPN_Reservations');
790: END IF;
791: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded=> 'F');
792: WHEN fnd_api.g_exc_unexpected_error THEN
793: x_return_status := fnd_api.g_ret_sts_unexp_error;
794:
795: IF (l_debug = 1) THEN
796: debug_print('Unexpected error in Create_LPN_Reservations');
797: END IF;

Line 800: x_return_status := fnd_api.g_ret_sts_unexp_error;

796: debug_print('Unexpected error in Create_LPN_Reservations');
797: END IF;
798: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded=> 'F');
799: WHEN OTHERS THEN
800: x_return_status := fnd_api.g_ret_sts_unexp_error;
801:
802: IF (l_debug = 1) THEN
803: debug_print('Other error in Create_LPN_Reservations');
804: END IF;

Line 918: p_init_msg_lst => fnd_api.g_false,

914: debug_print('Try to use API to Update MR');
915: END IF;
916: inv_reservation_pvt.update_reservation
917: (p_api_version_number => 1.0,
918: p_init_msg_lst => fnd_api.g_false,
919: x_return_status => x_return_status,
920: x_msg_count => x_msg_count,
921: x_msg_data => x_msg_data,
922: p_original_rsv_rec => l_rsv_rec,

Line 926: p_validation_flag => fnd_api.g_false

922: p_original_rsv_rec => l_rsv_rec,
923: p_to_rsv_rec => l_to_rsv_rec,
924: p_original_serial_number => l_serial_number_tbl,
925: p_to_serial_number => l_serial_number_tbl,
926: p_validation_flag => fnd_api.g_false
927: );
928:
929: IF l_debug=1 THEN
930: debug_print ('Return Status after update reservations '||x_return_status);

Line 933: IF x_return_status = fnd_api.g_ret_sts_error THEN

929: IF l_debug=1 THEN
930: debug_print ('Return Status after update reservations '||x_return_status);
931: END IF;
932:
933: IF x_return_status = fnd_api.g_ret_sts_error THEN
934:
935: IF l_debug=1 THEN
936: debug_print('Raising expected error'||x_return_status);
937: END IF;

Line 938: RAISE fnd_api.g_exc_error;

934:
935: IF l_debug=1 THEN
936: debug_print('Raising expected error'||x_return_status);
937: END IF;
938: RAISE fnd_api.g_exc_error;
939:
940: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
941:
942: IF l_debug=1 THEN

Line 940: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

936: debug_print('Raising expected error'||x_return_status);
937: END IF;
938: RAISE fnd_api.g_exc_error;
939:
940: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
941:
942: IF l_debug=1 THEN
943: debug_print('Rasing Unexpected error'||x_return_status);
944: END IF;

Line 945: RAISE fnd_api.g_exc_unexpected_error;

941:
942: IF l_debug=1 THEN
943: debug_print('Rasing Unexpected error'||x_return_status);
944: END IF;
945: RAISE fnd_api.g_exc_unexpected_error;
946:
947: END IF;
948:
949: END LOOP;

Line 968: , p_init_msg_lst => fnd_api.g_false

964: END IF;
965:
966: inv_reservation_pvt.delete_reservation(
967: p_api_version_number => 1.0
968: , p_init_msg_lst => fnd_api.g_false
969: , x_return_status => x_return_status
970: , x_msg_count => x_msg_count
971: , x_msg_data => x_msg_data
972: , p_rsv_rec => l_rsv_rec

Line 977: IF x_return_status = fnd_api.g_ret_sts_error THEN

973: , p_original_serial_number => l_serial_number_tbl
974:
975: );
976:
977: IF x_return_status = fnd_api.g_ret_sts_error THEN
978: RAISE fnd_api.g_exc_error;
979: END IF;
980:
981: --

Line 978: RAISE fnd_api.g_exc_error;

974:
975: );
976:
977: IF x_return_status = fnd_api.g_ret_sts_error THEN
978: RAISE fnd_api.g_exc_error;
979: END IF;
980:
981: --
982: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 982: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

978: RAISE fnd_api.g_exc_error;
979: END IF;
980:
981: --
982: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
983: RAISE fnd_api.g_exc_unexpected_error;
984: -- END IF;
985: END IF;
986:

Line 983: RAISE fnd_api.g_exc_unexpected_error;

979: END IF;
980:
981: --
982: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
983: RAISE fnd_api.g_exc_unexpected_error;
984: -- END IF;
985: END IF;
986:
987: END LOOP;

Line 1007: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

1003: , p_to_subinventory_code => p_to_subinventory_code
1004: , p_to_locator_id => p_to_locator_id
1005: );
1006:
1007: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1008: IF (l_debug = 1) THEN
1009: debug_print(l_api_name||':Error return status from transfer_serial_rsv_in_LPN');
1010: END IF;
1011:

Line 1012: RAISE fnd_api.g_exc_error;

1008: IF (l_debug = 1) THEN
1009: debug_print(l_api_name||':Error return status from transfer_serial_rsv_in_LPN');
1010: END IF;
1011:
1012: RAISE fnd_api.g_exc_error;
1013: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1014: IF (l_debug = 1) THEN
1015: debug_print(l_api_name||':Unexpected return status from transfer_serial_rsv_in_LPN');
1016: END IF;

Line 1013: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

1009: debug_print(l_api_name||':Error return status from transfer_serial_rsv_in_LPN');
1010: END IF;
1011:
1012: RAISE fnd_api.g_exc_error;
1013: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1014: IF (l_debug = 1) THEN
1015: debug_print(l_api_name||':Unexpected return status from transfer_serial_rsv_in_LPN');
1016: END IF;
1017:

Line 1018: RAISE fnd_api.g_exc_unexpected_error;

1014: IF (l_debug = 1) THEN
1015: debug_print(l_api_name||':Unexpected return status from transfer_serial_rsv_in_LPN');
1016: END IF;
1017:
1018: RAISE fnd_api.g_exc_unexpected_error;
1019: END IF;
1020:
1021: inv_quantity_tree_pvt.clear_quantity_cache;
1022: x_return_status := fnd_api.g_ret_sts_success;

Line 1022: x_return_status := fnd_api.g_ret_sts_success;

1018: RAISE fnd_api.g_exc_unexpected_error;
1019: END IF;
1020:
1021: inv_quantity_tree_pvt.clear_quantity_cache;
1022: x_return_status := fnd_api.g_ret_sts_success;
1023:
1024: EXCEPTION
1025: WHEN fnd_api.g_exc_error THEN
1026: x_return_status := fnd_api.g_ret_sts_error;

Line 1025: WHEN fnd_api.g_exc_error THEN

1021: inv_quantity_tree_pvt.clear_quantity_cache;
1022: x_return_status := fnd_api.g_ret_sts_success;
1023:
1024: EXCEPTION
1025: WHEN fnd_api.g_exc_error THEN
1026: x_return_status := fnd_api.g_ret_sts_error;
1027: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1028: WHEN fnd_api.g_exc_unexpected_error THEN
1029: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1026: x_return_status := fnd_api.g_ret_sts_error;

1022: x_return_status := fnd_api.g_ret_sts_success;
1023:
1024: EXCEPTION
1025: WHEN fnd_api.g_exc_error THEN
1026: x_return_status := fnd_api.g_ret_sts_error;
1027: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1028: WHEN fnd_api.g_exc_unexpected_error THEN
1029: x_return_status := fnd_api.g_ret_sts_unexp_error;
1030: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1028: WHEN fnd_api.g_exc_unexpected_error THEN

1024: EXCEPTION
1025: WHEN fnd_api.g_exc_error THEN
1026: x_return_status := fnd_api.g_ret_sts_error;
1027: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1028: WHEN fnd_api.g_exc_unexpected_error THEN
1029: x_return_status := fnd_api.g_ret_sts_unexp_error;
1030: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1031: WHEN OTHERS THEN
1032: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1029: x_return_status := fnd_api.g_ret_sts_unexp_error;

1025: WHEN fnd_api.g_exc_error THEN
1026: x_return_status := fnd_api.g_ret_sts_error;
1027: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1028: WHEN fnd_api.g_exc_unexpected_error THEN
1029: x_return_status := fnd_api.g_ret_sts_unexp_error;
1030: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1031: WHEN OTHERS THEN
1032: x_return_status := fnd_api.g_ret_sts_unexp_error;
1033:

Line 1032: x_return_status := fnd_api.g_ret_sts_unexp_error;

1028: WHEN fnd_api.g_exc_unexpected_error THEN
1029: x_return_status := fnd_api.g_ret_sts_unexp_error;
1030: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1031: WHEN OTHERS THEN
1032: x_return_status := fnd_api.g_ret_sts_unexp_error;
1033:
1034: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1035: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1036: END IF;

Line 1155: p_init_msg_lst => fnd_api.g_false,

1151: debug_print('Try to use API to Update MR');
1152: END IF;
1153: inv_reservation_pvt.update_reservation
1154: (p_api_version_number => 1.0,
1155: p_init_msg_lst => fnd_api.g_false,
1156: x_return_status => x_return_status,
1157: x_msg_count => x_msg_count,
1158: x_msg_data => x_msg_data,
1159: p_original_rsv_rec => l_rsv_rec,

Line 1163: p_validation_flag => fnd_api.g_false

1159: p_original_rsv_rec => l_rsv_rec,
1160: p_to_rsv_rec => l_to_rsv_rec,
1161: p_original_serial_number => l_serial_number_tbl,
1162: p_to_serial_number => l_serial_number_tbl,
1163: p_validation_flag => fnd_api.g_false
1164: );
1165:
1166: IF l_debug=1 THEN
1167: debug_print ('Return Status after update reservations '||x_return_status);

Line 1170: IF x_return_status = fnd_api.g_ret_sts_error THEN

1166: IF l_debug=1 THEN
1167: debug_print ('Return Status after update reservations '||x_return_status);
1168: END IF;
1169:
1170: IF x_return_status = fnd_api.g_ret_sts_error THEN
1171:
1172: IF l_debug=1 THEN
1173: debug_print('Raising expected error'||x_return_status);
1174: END IF;

Line 1175: RAISE fnd_api.g_exc_error;

1171:
1172: IF l_debug=1 THEN
1173: debug_print('Raising expected error'||x_return_status);
1174: END IF;
1175: RAISE fnd_api.g_exc_error;
1176:
1177: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1178:
1179: IF l_debug=1 THEN

Line 1177: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1173: debug_print('Raising expected error'||x_return_status);
1174: END IF;
1175: RAISE fnd_api.g_exc_error;
1176:
1177: ELSIF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1178:
1179: IF l_debug=1 THEN
1180: debug_print('Rasing Unexpected error'||x_return_status);
1181: END IF;

Line 1182: RAISE fnd_api.g_exc_unexpected_error;

1178:
1179: IF l_debug=1 THEN
1180: debug_print('Rasing Unexpected error'||x_return_status);
1181: END IF;
1182: RAISE fnd_api.g_exc_unexpected_error;
1183:
1184: END IF;
1185:
1186: END LOOP;

Line 1205: , p_init_msg_lst => fnd_api.g_false

1201: END IF;
1202:
1203: inv_reservation_pvt.delete_reservation(
1204: p_api_version_number => 1.0
1205: , p_init_msg_lst => fnd_api.g_false
1206: , x_return_status => x_return_status
1207: , x_msg_count => x_msg_count
1208: , x_msg_data => x_msg_data
1209: , p_rsv_rec => l_rsv_rec

Line 1214: IF x_return_status = fnd_api.g_ret_sts_error THEN

1210: , p_original_serial_number => l_serial_number_tbl
1211:
1212: );
1213:
1214: IF x_return_status = fnd_api.g_ret_sts_error THEN
1215: RAISE fnd_api.g_exc_error;
1216: END IF;
1217:
1218: --

Line 1215: RAISE fnd_api.g_exc_error;

1211:
1212: );
1213:
1214: IF x_return_status = fnd_api.g_ret_sts_error THEN
1215: RAISE fnd_api.g_exc_error;
1216: END IF;
1217:
1218: --
1219: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

Line 1219: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN

1215: RAISE fnd_api.g_exc_error;
1216: END IF;
1217:
1218: --
1219: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1220: RAISE fnd_api.g_exc_unexpected_error;
1221: -- END IF;
1222: END IF;
1223:

Line 1220: RAISE fnd_api.g_exc_unexpected_error;

1216: END IF;
1217:
1218: --
1219: IF x_return_status = fnd_api.g_ret_sts_unexp_error THEN
1220: RAISE fnd_api.g_exc_unexpected_error;
1221: -- END IF;
1222: END IF;
1223:
1224: END LOOP;

Line 1244: IF (x_return_status = fnd_api.g_ret_sts_error) THEN

1240: , p_to_subinventory_code => p_to_subinventory_code
1241: , p_to_locator_id => p_to_locator_id
1242: );
1243:
1244: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1245: IF (l_debug = 1) THEN
1246: debug_print(l_api_name||':Error return status from transfer_serial_rsv_in_LPN');
1247: END IF;
1248:

Line 1249: RAISE fnd_api.g_exc_error;

1245: IF (l_debug = 1) THEN
1246: debug_print(l_api_name||':Error return status from transfer_serial_rsv_in_LPN');
1247: END IF;
1248:
1249: RAISE fnd_api.g_exc_error;
1250: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1251: IF (l_debug = 1) THEN
1252: debug_print(l_api_name||':Unexpected return status from transfer_serial_rsv_in_LPN');
1253: END IF;

Line 1250: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN

1246: debug_print(l_api_name||':Error return status from transfer_serial_rsv_in_LPN');
1247: END IF;
1248:
1249: RAISE fnd_api.g_exc_error;
1250: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1251: IF (l_debug = 1) THEN
1252: debug_print(l_api_name||':Unexpected return status from transfer_serial_rsv_in_LPN');
1253: END IF;
1254:

Line 1255: RAISE fnd_api.g_exc_unexpected_error;

1251: IF (l_debug = 1) THEN
1252: debug_print(l_api_name||':Unexpected return status from transfer_serial_rsv_in_LPN');
1253: END IF;
1254:
1255: RAISE fnd_api.g_exc_unexpected_error;
1256: END IF;
1257:
1258: inv_quantity_tree_pvt.clear_quantity_cache;
1259:

Line 1260: x_return_status := fnd_api.g_ret_sts_success;

1256: END IF;
1257:
1258: inv_quantity_tree_pvt.clear_quantity_cache;
1259:
1260: x_return_status := fnd_api.g_ret_sts_success;
1261: EXCEPTION
1262: WHEN fnd_api.g_exc_error THEN
1263: x_return_status := fnd_api.g_ret_sts_error;
1264: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1262: WHEN fnd_api.g_exc_error THEN

1258: inv_quantity_tree_pvt.clear_quantity_cache;
1259:
1260: x_return_status := fnd_api.g_ret_sts_success;
1261: EXCEPTION
1262: WHEN fnd_api.g_exc_error THEN
1263: x_return_status := fnd_api.g_ret_sts_error;
1264: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1265: WHEN fnd_api.g_exc_unexpected_error THEN
1266: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1263: x_return_status := fnd_api.g_ret_sts_error;

1259:
1260: x_return_status := fnd_api.g_ret_sts_success;
1261: EXCEPTION
1262: WHEN fnd_api.g_exc_error THEN
1263: x_return_status := fnd_api.g_ret_sts_error;
1264: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1265: WHEN fnd_api.g_exc_unexpected_error THEN
1266: x_return_status := fnd_api.g_ret_sts_unexp_error;
1267: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1265: WHEN fnd_api.g_exc_unexpected_error THEN

1261: EXCEPTION
1262: WHEN fnd_api.g_exc_error THEN
1263: x_return_status := fnd_api.g_ret_sts_error;
1264: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1265: WHEN fnd_api.g_exc_unexpected_error THEN
1266: x_return_status := fnd_api.g_ret_sts_unexp_error;
1267: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1268: WHEN OTHERS THEN
1269: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1266: x_return_status := fnd_api.g_ret_sts_unexp_error;

1262: WHEN fnd_api.g_exc_error THEN
1263: x_return_status := fnd_api.g_ret_sts_error;
1264: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1265: WHEN fnd_api.g_exc_unexpected_error THEN
1266: x_return_status := fnd_api.g_ret_sts_unexp_error;
1267: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1268: WHEN OTHERS THEN
1269: x_return_status := fnd_api.g_ret_sts_unexp_error;
1270:

Line 1269: x_return_status := fnd_api.g_ret_sts_unexp_error;

1265: WHEN fnd_api.g_exc_unexpected_error THEN
1266: x_return_status := fnd_api.g_ret_sts_unexp_error;
1267: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1268: WHEN OTHERS THEN
1269: x_return_status := fnd_api.g_ret_sts_unexp_error;
1270:
1271: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1272: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1273: END IF;