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 200: RAISE fnd_api.g_exc_unexpected_error;

196: IF (l_debug = 1) THEN
197: debug_print('Missing input parameters');
198: END IF;
199:
200: RAISE fnd_api.g_exc_unexpected_error;
201: END IF;
202:
203: --bug#2402957. call is_lpn_reserved to see if lpn is reserved for some other demand.
204: l_lpn_already_resv := is_lpn_reserved(

Line 219: RAISE fnd_api.g_exc_error;

215: debug_print('Error: LPN is reserved for some other demand line');
216: END IF;
217: fnd_message.set_name('INV', 'INV_CANNOT_RESERVE_LPN');
218: fnd_msg_pub.ADD;
219: RAISE fnd_api.g_exc_error;
220: END IF;
221:
222: OPEN c_item_controls;
223: -- INVCONV - incorporate secondary uom and tracking quantity below

Line 313: RAISE fnd_api.g_exc_error;

309: debug_print('Error: Order Line completely reserved');
310: END IF;
311: fnd_message.set_name('INV', 'INV_CANNOT_CREATE_RESERVATION');
312: fnd_msg_pub.ADD;
313: RAISE fnd_api.g_exc_error;
314: ELSIF (l_ordered_qty - l_reserved_qty + l_lpn_reserved_qty < l_quantity) THEN
315: --error as lpn has more qty than order line.
316: IF (l_debug = 1) THEN
317: debug_print('Error: LPN Qty > Order Line Qty');

Line 321: RAISE fnd_api.g_exc_error;

317: debug_print('Error: LPN Qty > Order Line Qty');
318: END IF;
319: fnd_message.set_name('INV', 'INV_LPN_QTY_GREATER');
320: fnd_msg_pub.ADD;
321: RAISE fnd_api.g_exc_error;
322: END IF;
323: END IF;
324:
325: -- create the quantity tree

Line 328: , p_init_msg_lst => fnd_api.g_true

324:
325: -- create the quantity tree
326: inv_quantity_tree_pvt.create_tree(
327: p_api_version_number => 1.0
328: , p_init_msg_lst => fnd_api.g_true
329: , x_return_status => l_return_status
330: , x_msg_count => l_msg_count
331: , x_msg_data => l_msg_data
332: , p_organization_id => p_organization_id

Line 349: IF l_return_status = fnd_api.g_ret_sts_error THEN

345: , p_lot_expiration_date => SYSDATE -- Bug#2716563
346: , x_tree_id => l_tree_id
347: );
348:
349: IF l_return_status = fnd_api.g_ret_sts_error THEN
350: IF (l_debug = 1) THEN
351: debug_print('Error creating quantity tree');
352: END IF;
353:

Line 354: RAISE fnd_api.g_exc_error;

350: IF (l_debug = 1) THEN
351: debug_print('Error creating quantity tree');
352: END IF;
353:
354: RAISE fnd_api.g_exc_error;
355: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
356: IF (l_debug = 1) THEN
357: debug_print('Unexpected error creating quantity tree');
358: END IF;

Line 355: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

351: debug_print('Error creating quantity tree');
352: END IF;
353:
354: RAISE fnd_api.g_exc_error;
355: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
356: IF (l_debug = 1) THEN
357: debug_print('Unexpected error creating quantity tree');
358: END IF;
359:

Line 360: RAISE fnd_api.g_exc_unexpected_error;

356: IF (l_debug = 1) THEN
357: debug_print('Unexpected error creating quantity tree');
358: END IF;
359:
360: RAISE fnd_api.g_exc_unexpected_error;
361: END IF;
362:
363: OPEN c_lpn_contents;
364:

Line 406: , p_init_msg_lst => fnd_api.g_false

402: END IF;
403:
404: inv_reservation_pvt.query_reservation(
405: p_api_version_number => 1.0
406: , p_init_msg_lst => fnd_api.g_false
407: , x_return_status => l_return_status
408: , x_msg_count => l_msg_count
409: , x_msg_data => l_msg_data
410: , p_query_input => l_query_rec

Line 416: IF l_return_status = fnd_api.g_ret_sts_error THEN

412: , x_mtl_reservation_tbl_count => l_rsv_count
413: , x_error_code => l_error_code
414: );
415:
416: IF l_return_status = fnd_api.g_ret_sts_error THEN
417: IF (l_debug = 1) THEN
418: debug_print('Error in query_reservation');
419: END IF;
420:

Line 421: RAISE fnd_api.g_exc_error;

417: IF (l_debug = 1) THEN
418: debug_print('Error in query_reservation');
419: END IF;
420:
421: RAISE fnd_api.g_exc_error;
422: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
423: IF (l_debug = 1) THEN
424: debug_print('Unexpected error in query_reservation');
425: END IF;

Line 422: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

418: debug_print('Error in query_reservation');
419: END IF;
420:
421: RAISE fnd_api.g_exc_error;
422: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
423: IF (l_debug = 1) THEN
424: debug_print('Unexpected error in query_reservation');
425: END IF;
426:

Line 427: RAISE fnd_api.g_exc_unexpected_error;

423: IF (l_debug = 1) THEN
424: debug_print('Unexpected error in query_reservation');
425: END IF;
426:
427: RAISE fnd_api.g_exc_unexpected_error;
428: END IF;
429:
430: -- If reservation exists
431: IF l_rsv_count >= 1 THEN

Line 463: , p_init_msg_lst => fnd_api.g_true

459:
460: --query quantity tree to make sure quantity is available to increase reservations
461: inv_quantity_tree_pvt.query_tree(
462: p_api_version_number => 1.0
463: , p_init_msg_lst => fnd_api.g_true
464: , x_return_status => l_return_status
465: , x_msg_count => l_msg_count
466: , x_msg_data => l_msg_data
467: , p_tree_id => l_tree_id

Line 490: IF l_return_status = fnd_api.g_ret_sts_error THEN

486: , p_lpn_id => p_lpn_id
487: , p_transfer_locator_id => NULL
488: );
489:
490: IF l_return_status = fnd_api.g_ret_sts_error THEN
491: IF (l_debug = 1) THEN
492: debug_print('Error from query_tree');
493: END IF;
494:

Line 495: RAISE fnd_api.g_exc_error;

491: IF (l_debug = 1) THEN
492: debug_print('Error from query_tree');
493: END IF;
494:
495: RAISE fnd_api.g_exc_error;
496: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
497: IF (l_debug = 1) THEN
498: debug_print('Unexpected error from query_tree');
499: END IF;

Line 496: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

492: debug_print('Error from query_tree');
493: END IF;
494:
495: RAISE fnd_api.g_exc_error;
496: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
497: IF (l_debug = 1) THEN
498: debug_print('Unexpected error from query_tree');
499: END IF;
500:

Line 501: RAISE fnd_api.g_exc_unexpected_error;

497: IF (l_debug = 1) THEN
498: debug_print('Unexpected error from query_tree');
499: END IF;
500:
501: RAISE fnd_api.g_exc_unexpected_error;
502: END IF;
503:
504: --Bug#2402957:
505: -- If (ATR + AlreadyReserved) <> LPN Qty => LPN is reserved for some other demand, so error.

Line 515: RAISE fnd_api.g_exc_error;

511: debug_print('Error: LPN is reserved for some other demand line');
512: END IF;
513: fnd_message.set_name('INV', 'INV_CANNOT_RESERVE_LPN');
514: fnd_msg_pub.ADD;
515: RAISE fnd_api.g_exc_error;
516: END IF;
517:
518: l_increase_quantity := l_atr + l_rsv_tbl(1).primary_reservation_quantity;
519: -- INVCONV BEGIN

Line 541: , p_init_msg_lst => fnd_api.g_false

537: END IF;
538:
539: inv_reservation_pvt.update_reservation(
540: p_api_version_number => 1.0
541: , p_init_msg_lst => fnd_api.g_false
542: , x_return_status => l_return_status
543: , x_msg_count => l_msg_count
544: , x_msg_data => l_msg_data
545: , p_original_rsv_rec => l_rsv_tbl(1)

Line 549: , p_validation_flag => fnd_api.g_true

545: , p_original_rsv_rec => l_rsv_tbl(1)
546: , p_to_rsv_rec => l_rsv_rec
547: , p_original_serial_number => l_dummy_sn
548: , p_to_serial_number => l_dummy_sn
549: , p_validation_flag => fnd_api.g_true
550: );
551:
552: IF l_return_status = fnd_api.g_ret_sts_error THEN
553: IF (l_debug = 1) THEN

Line 552: IF l_return_status = fnd_api.g_ret_sts_error THEN

548: , p_to_serial_number => l_dummy_sn
549: , p_validation_flag => fnd_api.g_true
550: );
551:
552: IF l_return_status = fnd_api.g_ret_sts_error THEN
553: IF (l_debug = 1) THEN
554: debug_print('Error from update_reservation');
555: END IF;
556:

Line 557: RAISE fnd_api.g_exc_error;

553: IF (l_debug = 1) THEN
554: debug_print('Error from update_reservation');
555: END IF;
556:
557: RAISE fnd_api.g_exc_error;
558: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
559: IF (l_debug = 1) THEN
560: debug_print('Unexpected error from update_reservation');
561: END IF;

Line 558: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

554: debug_print('Error from update_reservation');
555: END IF;
556:
557: RAISE fnd_api.g_exc_error;
558: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
559: IF (l_debug = 1) THEN
560: debug_print('Unexpected error from update_reservation');
561: END IF;
562:

Line 563: RAISE fnd_api.g_exc_unexpected_error;

559: IF (l_debug = 1) THEN
560: debug_print('Unexpected error from update_reservation');
561: END IF;
562:
563: RAISE fnd_api.g_exc_unexpected_error;
564: END IF;
565: END IF; -- if new increase quantity > 0
566: END IF; -- if increase quantity > 0
567: ELSE --Else, create new reservation

Line 574: , p_init_msg_lst => fnd_api.g_true

570: END IF;
571:
572: inv_quantity_tree_pvt.query_tree(
573: p_api_version_number => 1.0
574: , p_init_msg_lst => fnd_api.g_true
575: , x_return_status => l_return_status
576: , x_msg_count => l_msg_count
577: , x_msg_data => l_msg_data
578: , p_tree_id => l_tree_id

Line 595: IF l_return_status = fnd_api.g_ret_sts_error THEN

591: , p_lpn_id => p_lpn_id
592: , p_transfer_locator_id => NULL
593: );
594:
595: IF l_return_status = fnd_api.g_ret_sts_error THEN
596: IF (l_debug = 1) THEN
597: debug_print('Error in query_tree');
598: END IF;
599:

Line 600: RAISE fnd_api.g_exc_error;

596: IF (l_debug = 1) THEN
597: debug_print('Error in query_tree');
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 in query_tree');
604: END IF;

Line 601: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

597: debug_print('Error in query_tree');
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 in query_tree');
604: END IF;
605:

Line 606: RAISE fnd_api.g_exc_unexpected_error;

602: IF (l_debug = 1) THEN
603: debug_print('Unexpected error in query_tree');
604: END IF;
605:
606: RAISE fnd_api.g_exc_unexpected_error;
607: END IF;
608:
609: --Bug#2402957:
610: -- If ATR <> LPN Qty => LPN is also reserved for some other demand, so error.

Line 620: RAISE fnd_api.g_exc_error;

616: debug_print('Error: LPN is reserved for some other order line');
617: END IF;
618: fnd_message.set_name('INV', 'INV_CANNOT_RESERVE_LPN');
619: fnd_msg_pub.ADD;
620: RAISE fnd_api.g_exc_error;
621: END IF;
622:
623: IF (l_debug = 1) THEN
624: debug_print('New Reservation Qty = '|| l_quantity);

Line 694: , p_init_msg_lst => fnd_api.g_false

690:
691: -- INVCONV - Upgrade call for Inventory Convergence
692: inv_reservation_pvt.create_reservation(
693: p_api_version_number => 1.0
694: , p_init_msg_lst => fnd_api.g_false
695: , x_return_status => l_return_status
696: , x_msg_count => l_msg_count
697: , x_msg_data => l_msg_data
698: , p_rsv_rec => l_rsv_rec

Line 701: , p_partial_reservation_flag => fnd_api.g_true

697: , x_msg_data => l_msg_data
698: , p_rsv_rec => l_rsv_rec
699: , p_serial_number => l_dummy_sn
700: , x_serial_number => l_dummy_sn
701: , p_partial_reservation_flag => fnd_api.g_true
702: , p_force_reservation_flag => fnd_api.g_false
703: , p_validation_flag => fnd_api.g_true
704: , x_quantity_reserved => l_quantity_reserved
705: , x_secondary_quantity_reserved => l_secondary_quantity_reserved --INVCONV

Line 702: , p_force_reservation_flag => fnd_api.g_false

698: , p_rsv_rec => l_rsv_rec
699: , p_serial_number => l_dummy_sn
700: , x_serial_number => l_dummy_sn
701: , p_partial_reservation_flag => fnd_api.g_true
702: , p_force_reservation_flag => fnd_api.g_false
703: , p_validation_flag => fnd_api.g_true
704: , x_quantity_reserved => l_quantity_reserved
705: , x_secondary_quantity_reserved => l_secondary_quantity_reserved --INVCONV
706: , x_reservation_id => l_reservation_id

Line 703: , p_validation_flag => fnd_api.g_true

699: , p_serial_number => l_dummy_sn
700: , x_serial_number => l_dummy_sn
701: , p_partial_reservation_flag => fnd_api.g_true
702: , p_force_reservation_flag => fnd_api.g_false
703: , p_validation_flag => fnd_api.g_true
704: , x_quantity_reserved => l_quantity_reserved
705: , x_secondary_quantity_reserved => l_secondary_quantity_reserved --INVCONV
706: , x_reservation_id => l_reservation_id
707: );

Line 709: IF l_return_status = fnd_api.g_ret_sts_error THEN

705: , x_secondary_quantity_reserved => l_secondary_quantity_reserved --INVCONV
706: , x_reservation_id => l_reservation_id
707: );
708:
709: IF l_return_status = fnd_api.g_ret_sts_error THEN
710: IF (l_debug = 1) THEN
711: debug_print('Error in create_reservation');
712: END IF;
713:

Line 714: RAISE fnd_api.g_exc_error;

710: IF (l_debug = 1) THEN
711: debug_print('Error in create_reservation');
712: END IF;
713:
714: RAISE fnd_api.g_exc_error;
715: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
716: IF (l_debug = 1) THEN
717: debug_print('Unexpected error in create_reservation');
718: END IF;

Line 715: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN

711: debug_print('Error in create_reservation');
712: END IF;
713:
714: RAISE fnd_api.g_exc_error;
715: ELSIF l_return_status = fnd_api.g_ret_sts_unexp_error THEN
716: IF (l_debug = 1) THEN
717: debug_print('Unexpected error in create_reservation');
718: END IF;
719:

Line 720: RAISE fnd_api.g_exc_unexpected_error;

716: IF (l_debug = 1) THEN
717: debug_print('Unexpected error in create_reservation');
718: END IF;
719:
720: RAISE fnd_api.g_exc_unexpected_error;
721: END IF;
722: END IF; -- if quantity > 0
723: END IF; -- if reservation count > 0
724: END LOOP;

Line 727: x_return_status := fnd_api.g_ret_sts_success;

723: END IF; -- if reservation count > 0
724: END LOOP;
725:
726: CLOSE c_lpn_contents;
727: x_return_status := fnd_api.g_ret_sts_success;
728:
729: IF (l_debug = 1) THEN
730: debug_print('Exit Create_LPN_Reservations');
731: END IF;

Line 733: WHEN fnd_api.g_exc_error THEN

729: IF (l_debug = 1) THEN
730: debug_print('Exit Create_LPN_Reservations');
731: END IF;
732: EXCEPTION
733: WHEN fnd_api.g_exc_error THEN
734: x_return_status := fnd_api.g_ret_sts_error;
735: ROLLBACK TO entire_lpn; --bug#2402957.
736: IF (l_debug = 1) THEN
737: debug_print('Error in Create_LPN_Reservations');

Line 734: x_return_status := fnd_api.g_ret_sts_error;

730: debug_print('Exit Create_LPN_Reservations');
731: END IF;
732: EXCEPTION
733: WHEN fnd_api.g_exc_error THEN
734: x_return_status := fnd_api.g_ret_sts_error;
735: ROLLBACK TO entire_lpn; --bug#2402957.
736: IF (l_debug = 1) THEN
737: debug_print('Error in Create_LPN_Reservations');
738: END IF;

Line 740: WHEN fnd_api.g_exc_unexpected_error THEN

736: IF (l_debug = 1) THEN
737: debug_print('Error in Create_LPN_Reservations');
738: END IF;
739: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded=> 'F');
740: WHEN fnd_api.g_exc_unexpected_error THEN
741: x_return_status := fnd_api.g_ret_sts_unexp_error;
742:
743: IF (l_debug = 1) THEN
744: debug_print('Unexpected error in Create_LPN_Reservations');

Line 741: x_return_status := fnd_api.g_ret_sts_unexp_error;

737: debug_print('Error in Create_LPN_Reservations');
738: END IF;
739: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded=> 'F');
740: WHEN fnd_api.g_exc_unexpected_error THEN
741: x_return_status := fnd_api.g_ret_sts_unexp_error;
742:
743: IF (l_debug = 1) THEN
744: debug_print('Unexpected error in Create_LPN_Reservations');
745: END IF;

Line 748: x_return_status := fnd_api.g_ret_sts_unexp_error;

744: debug_print('Unexpected error in Create_LPN_Reservations');
745: END IF;
746: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded=> 'F');
747: WHEN OTHERS THEN
748: x_return_status := fnd_api.g_ret_sts_unexp_error;
749:
750: IF (l_debug = 1) THEN
751: debug_print('Other error in Create_LPN_Reservations');
752: END IF;

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

884: , p_to_subinventory_code => p_to_subinventory_code
885: , p_to_locator_id => p_to_locator_id
886: );
887:
888: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
889: IF (l_debug = 1) THEN
890: debug_print('Error return status from transfer_serial_rsv_in_LPN');
891: END IF;
892:

Line 893: RAISE fnd_api.g_exc_error;

889: IF (l_debug = 1) THEN
890: debug_print('Error return status from transfer_serial_rsv_in_LPN');
891: END IF;
892:
893: RAISE fnd_api.g_exc_error;
894: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
895: IF (l_debug = 1) THEN
896: debug_print('Unexpected return status from transfer_serial_rsv_in_LPN');
897: END IF;

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

890: debug_print('Error return status from transfer_serial_rsv_in_LPN');
891: END IF;
892:
893: RAISE fnd_api.g_exc_error;
894: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
895: IF (l_debug = 1) THEN
896: debug_print('Unexpected return status from transfer_serial_rsv_in_LPN');
897: END IF;
898:

Line 899: RAISE fnd_api.g_exc_unexpected_error;

895: IF (l_debug = 1) THEN
896: debug_print('Unexpected return status from transfer_serial_rsv_in_LPN');
897: END IF;
898:
899: RAISE fnd_api.g_exc_unexpected_error;
900: END IF;
901:
902: /*** End R12 }} ***/
903:

Line 906: x_return_status := fnd_api.g_ret_sts_success;

902: /*** End R12 }} ***/
903:
904: inv_quantity_tree_pvt.clear_quantity_cache;
905:
906: x_return_status := fnd_api.g_ret_sts_success;
907: EXCEPTION
908: WHEN fnd_api.g_exc_error THEN
909: x_return_status := fnd_api.g_ret_sts_error;
910: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 908: WHEN fnd_api.g_exc_error THEN

904: inv_quantity_tree_pvt.clear_quantity_cache;
905:
906: x_return_status := fnd_api.g_ret_sts_success;
907: EXCEPTION
908: WHEN fnd_api.g_exc_error THEN
909: x_return_status := fnd_api.g_ret_sts_error;
910: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
911: WHEN fnd_api.g_exc_unexpected_error THEN
912: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 909: x_return_status := fnd_api.g_ret_sts_error;

905:
906: x_return_status := fnd_api.g_ret_sts_success;
907: EXCEPTION
908: WHEN fnd_api.g_exc_error THEN
909: x_return_status := fnd_api.g_ret_sts_error;
910: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
911: WHEN fnd_api.g_exc_unexpected_error THEN
912: x_return_status := fnd_api.g_ret_sts_unexp_error;
913: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 911: WHEN fnd_api.g_exc_unexpected_error THEN

907: EXCEPTION
908: WHEN fnd_api.g_exc_error THEN
909: x_return_status := fnd_api.g_ret_sts_error;
910: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
911: WHEN fnd_api.g_exc_unexpected_error THEN
912: x_return_status := fnd_api.g_ret_sts_unexp_error;
913: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
914: WHEN OTHERS THEN
915: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 912: x_return_status := fnd_api.g_ret_sts_unexp_error;

908: WHEN fnd_api.g_exc_error THEN
909: x_return_status := fnd_api.g_ret_sts_error;
910: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
911: WHEN fnd_api.g_exc_unexpected_error THEN
912: x_return_status := fnd_api.g_ret_sts_unexp_error;
913: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
914: WHEN OTHERS THEN
915: x_return_status := fnd_api.g_ret_sts_unexp_error;
916:

Line 915: x_return_status := fnd_api.g_ret_sts_unexp_error;

911: WHEN fnd_api.g_exc_unexpected_error THEN
912: x_return_status := fnd_api.g_ret_sts_unexp_error;
913: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
914: WHEN OTHERS THEN
915: x_return_status := fnd_api.g_ret_sts_unexp_error;
916:
917: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
918: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
919: END IF;

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

1058: , p_to_subinventory_code => p_to_subinventory_code
1059: , p_to_locator_id => p_to_locator_id
1060: );
1061:
1062: IF (x_return_status = fnd_api.g_ret_sts_error) THEN
1063: IF (l_debug = 1) THEN
1064: debug_print('transfer_reserved_lpn_contents:Error return status from transfer_serial_rsv_in_LPN');
1065: END IF;
1066:

Line 1067: RAISE fnd_api.g_exc_error;

1063: IF (l_debug = 1) THEN
1064: debug_print('transfer_reserved_lpn_contents:Error return status from transfer_serial_rsv_in_LPN');
1065: END IF;
1066:
1067: RAISE fnd_api.g_exc_error;
1068: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1069: IF (l_debug = 1) THEN
1070: debug_print('transfer_reserved_lpn_contents:Unexpected return status from transfer_serial_rsv_in_LPN');
1071: END IF;

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

1064: debug_print('transfer_reserved_lpn_contents:Error return status from transfer_serial_rsv_in_LPN');
1065: END IF;
1066:
1067: RAISE fnd_api.g_exc_error;
1068: ELSIF (x_return_status = fnd_api.g_ret_sts_unexp_error) THEN
1069: IF (l_debug = 1) THEN
1070: debug_print('transfer_reserved_lpn_contents:Unexpected return status from transfer_serial_rsv_in_LPN');
1071: END IF;
1072:

Line 1073: RAISE fnd_api.g_exc_unexpected_error;

1069: IF (l_debug = 1) THEN
1070: debug_print('transfer_reserved_lpn_contents:Unexpected return status from transfer_serial_rsv_in_LPN');
1071: END IF;
1072:
1073: RAISE fnd_api.g_exc_unexpected_error;
1074: END IF;
1075:
1076: inv_quantity_tree_pvt.clear_quantity_cache;
1077:

Line 1078: x_return_status := fnd_api.g_ret_sts_success;

1074: END IF;
1075:
1076: inv_quantity_tree_pvt.clear_quantity_cache;
1077:
1078: x_return_status := fnd_api.g_ret_sts_success;
1079: EXCEPTION
1080: WHEN fnd_api.g_exc_error THEN
1081: x_return_status := fnd_api.g_ret_sts_error;
1082: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1080: WHEN fnd_api.g_exc_error THEN

1076: inv_quantity_tree_pvt.clear_quantity_cache;
1077:
1078: x_return_status := fnd_api.g_ret_sts_success;
1079: EXCEPTION
1080: WHEN fnd_api.g_exc_error THEN
1081: x_return_status := fnd_api.g_ret_sts_error;
1082: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1083: WHEN fnd_api.g_exc_unexpected_error THEN
1084: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1081: x_return_status := fnd_api.g_ret_sts_error;

1077:
1078: x_return_status := fnd_api.g_ret_sts_success;
1079: EXCEPTION
1080: WHEN fnd_api.g_exc_error THEN
1081: x_return_status := fnd_api.g_ret_sts_error;
1082: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1083: WHEN fnd_api.g_exc_unexpected_error THEN
1084: x_return_status := fnd_api.g_ret_sts_unexp_error;
1085: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 1083: WHEN fnd_api.g_exc_unexpected_error THEN

1079: EXCEPTION
1080: WHEN fnd_api.g_exc_error THEN
1081: x_return_status := fnd_api.g_ret_sts_error;
1082: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1083: WHEN fnd_api.g_exc_unexpected_error THEN
1084: x_return_status := fnd_api.g_ret_sts_unexp_error;
1085: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1086: WHEN OTHERS THEN
1087: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 1084: x_return_status := fnd_api.g_ret_sts_unexp_error;

1080: WHEN fnd_api.g_exc_error THEN
1081: x_return_status := fnd_api.g_ret_sts_error;
1082: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1083: WHEN fnd_api.g_exc_unexpected_error THEN
1084: x_return_status := fnd_api.g_ret_sts_unexp_error;
1085: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1086: WHEN OTHERS THEN
1087: x_return_status := fnd_api.g_ret_sts_unexp_error;
1088:

Line 1087: x_return_status := fnd_api.g_ret_sts_unexp_error;

1083: WHEN fnd_api.g_exc_unexpected_error THEN
1084: x_return_status := fnd_api.g_ret_sts_unexp_error;
1085: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1086: WHEN OTHERS THEN
1087: x_return_status := fnd_api.g_ret_sts_unexp_error;
1088:
1089: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1090: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1091: END IF;