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_MISSING_QTY_ACTIONS_ENGINE dependencies on FND_API

Line 43: x_return_status := fnd_api.g_ret_sts_success;

39: AND mtrl.line_id = p_mo_line_id
40: AND msi.inventory_item_id = mtrl.inventory_item_id
41: AND msi.organization_id = mtrl.organization_id;
42: BEGIN
43: x_return_status := fnd_api.g_ret_sts_success;
44:
45: OPEN c_item_controls;
46: FETCH c_item_controls INTO x_lot_control_code, x_serial_control_code;
47: IF c_item_controls%NOTFOUND THEN

Line 48: x_return_status := fnd_api.g_ret_sts_error;

44:
45: OPEN c_item_controls;
46: FETCH c_item_controls INTO x_lot_control_code, x_serial_control_code;
47: IF c_item_controls%NOTFOUND THEN
48: x_return_status := fnd_api.g_ret_sts_error;
49: END IF;
50: CLOSE c_item_controls;
51: END get_item_controls;
52:

Line 137: x_return_status := fnd_api.g_ret_sts_success;

133: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
134: l_updated_count NUMBER := 0;
135: l_deleted_count NUMBER := 0;
136: BEGIN
137: x_return_status := fnd_api.g_ret_sts_success;
138:
139: IF l_debug = 1 THEN
140: print_debug('Updating Temp table to remove Confirmed Lots/Serials', l_api_name, g_info);
141: END IF;

Line 256: x_return_status := fnd_api.g_ret_sts_success;

252: FROM mtl_reservations
253: WHERE reservation_id = l_mmtt_info.reservation_id;
254:
255: BEGIN
256: x_return_status := fnd_api.g_ret_sts_success;
257:
258: OPEN c_mmtt_info;
259: FETCH c_mmtt_info INTO l_mmtt_info;
260: CLOSE c_mmtt_info;

Line 275: RAISE fnd_api.g_exc_unexpected_error;

271: FROM mtl_material_transactions_temp
272: WHERE reservation_id= l_mmtt_info.reservation_id;
273: EXCEPTION
274: WHEN OTHERS THEN
275: RAISE fnd_api.g_exc_unexpected_error;
276: END;
277:
278: print_debug('sum of all allocations ='||l_mmtt_primary_qty_sum,l_api_name,g_info);
279:

Line 292: --RAISE fnd_api.g_exc_unexpected_error;

288: fnd_msg_pub.ADD;
289: /*Bug:4700706. When the reservation record is deleted somehow by this time we need not
290: deal with the reservation.So we just return. */
291: RETURN;
292: --RAISE fnd_api.g_exc_unexpected_error;
293: END IF;
294: CLOSE c_rsv_info;
295:
296: -- Bug#2621481: For ATO Item, Retain the Reservation Qty

Line 354: IF x_return_status <> fnd_api.g_ret_sts_success THEN

350: , p_original_serial_number => l_dummy_sn
351: , p_to_serial_number => l_dummy_sn
352: );
353:
354: IF x_return_status <> fnd_api.g_ret_sts_success THEN
355: fnd_message.set_name('INV', 'INV_UPD_RSV_FAILED');
356: fnd_msg_pub.ADD;
357: RAISE fnd_api.g_exc_unexpected_error;
358: END IF;

Line 357: RAISE fnd_api.g_exc_unexpected_error;

353:
354: IF x_return_status <> fnd_api.g_ret_sts_success THEN
355: fnd_message.set_name('INV', 'INV_UPD_RSV_FAILED');
356: fnd_msg_pub.ADD;
357: RAISE fnd_api.g_exc_unexpected_error;
358: END IF;
359: EXCEPTION
360: WHEN fnd_api.g_exc_error THEN
361: x_return_status := fnd_api.g_ret_sts_error;

Line 360: WHEN fnd_api.g_exc_error THEN

356: fnd_msg_pub.ADD;
357: RAISE fnd_api.g_exc_unexpected_error;
358: END IF;
359: EXCEPTION
360: WHEN fnd_api.g_exc_error THEN
361: x_return_status := fnd_api.g_ret_sts_error;
362: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
363: WHEN fnd_api.g_exc_unexpected_error THEN
364: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 361: x_return_status := fnd_api.g_ret_sts_error;

357: RAISE fnd_api.g_exc_unexpected_error;
358: END IF;
359: EXCEPTION
360: WHEN fnd_api.g_exc_error THEN
361: x_return_status := fnd_api.g_ret_sts_error;
362: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
363: WHEN fnd_api.g_exc_unexpected_error THEN
364: x_return_status := fnd_api.g_ret_sts_unexp_error;
365: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 363: WHEN fnd_api.g_exc_unexpected_error THEN

359: EXCEPTION
360: WHEN fnd_api.g_exc_error THEN
361: x_return_status := fnd_api.g_ret_sts_error;
362: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
363: WHEN fnd_api.g_exc_unexpected_error THEN
364: x_return_status := fnd_api.g_ret_sts_unexp_error;
365: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
366: WHEN OTHERS THEN
367: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 364: x_return_status := fnd_api.g_ret_sts_unexp_error;

360: WHEN fnd_api.g_exc_error THEN
361: x_return_status := fnd_api.g_ret_sts_error;
362: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
363: WHEN fnd_api.g_exc_unexpected_error THEN
364: x_return_status := fnd_api.g_ret_sts_unexp_error;
365: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
366: WHEN OTHERS THEN
367: x_return_status := fnd_api.g_ret_sts_unexp_error;
368: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 367: x_return_status := fnd_api.g_ret_sts_unexp_error;

363: WHEN fnd_api.g_exc_unexpected_error THEN
364: x_return_status := fnd_api.g_ret_sts_unexp_error;
365: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
366: WHEN OTHERS THEN
367: x_return_status := fnd_api.g_ret_sts_unexp_error;
368: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
369: fnd_msg_pub.add_exc_msg(g_pkg_name, 'UNDO_PICK_RELEASE');
370: END IF;
371: END backorder_only;

Line 421: x_return_status := fnd_api.g_ret_sts_success;

417: FROM mtl_allocations_gtmp
418: WHERE transaction_temp_id = p_transaction_temp_id
419: GROUP BY lot_number;
420: BEGIN
421: x_return_status := fnd_api.g_ret_sts_success;
422:
423: IF l_debug = 1 THEN
424: print_debug('Splitting the Current Allocation to create a new one for the Remaining Qty', l_api_name, g_info);
425: END IF;

Line 452: IF x_return_status <> fnd_api.g_ret_sts_success THEN

448: , p_primary_qty => l_rem_pri_qty
449: , p_sec_txn_qty => l_rem_sec_txn_qty --INVCONV KKILLAMS
450: );
451:
452: IF x_return_status <> fnd_api.g_ret_sts_success THEN
453: IF l_debug = 1 THEN
454: print_debug('Error: Cannot copy the MMTT - Error = ' || x_msg_data, l_api_name, g_error);
455: END IF;
456: RAISE fnd_api.g_exc_unexpected_error;

Line 456: RAISE fnd_api.g_exc_unexpected_error;

452: IF x_return_status <> fnd_api.g_ret_sts_success THEN
453: IF l_debug = 1 THEN
454: print_debug('Error: Cannot copy the MMTT - Error = ' || x_msg_data, l_api_name, g_error);
455: END IF;
456: RAISE fnd_api.g_exc_unexpected_error;
457: END IF;
458:
459: IF l_debug = 1 THEN
460: print_debug('The old Transaction Temp id id = '|| p_transaction_temp_id, l_api_name, g_info);

Line 587: x_return_status := fnd_api.g_ret_sts_unexp_error;

583: print_debug('Created a new Allocation: TxnTempID = ' || x_new_txn_temp_id, l_api_name, g_info);
584: END IF;
585: EXCEPTION
586: WHEN OTHERS THEN
587: x_return_status := fnd_api.g_ret_sts_unexp_error;
588: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
589: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
590: END IF;
591: IF l_debug = 1 THEN

Line 629: , p_init_msg_lst => fnd_api.g_false

625: x_return_status => l_return_status
626: , x_msg_count => l_msg_count
627: , x_msg_data => l_msg_data
628: , p_api_version_number => 1.0
629: , p_init_msg_lst => fnd_api.g_false
630: , p_organization_id => p_cc_rsv_rec.organization_id
631: , p_inventory_item_id => p_cc_rsv_rec.inventory_item_id
632: , p_tree_mode => inv_quantity_tree_pub.g_reservation_mode
633: , p_is_revision_control => (p_cc_rsv_rec.revision IS NOT NULL)

Line 657: IF l_return_status <> fnd_api.g_ret_sts_success THEN

653: , x_satt => l_satt -- invConv change
654: , x_satr => l_satr -- invConv change
655: --END INVCONV kkilams
656: );
657: IF l_return_status <> fnd_api.g_ret_sts_success THEN
658: IF l_debug = 1 THEN
659: print_debug('Error: Querying the Quantity Tree errored out', l_api_name, g_error);
660: END IF;
661: fnd_message.set_name('INV','INV-CANNOT QUERY TREE');

Line 723: x_return_status := fnd_api.g_ret_sts_success;

719: l_existing_cc_res_sec_qty NUMBER := 0;
720:
721: BEGIN
722:
723: x_return_status := fnd_api.g_ret_sts_success;
724:
725: fill_cycle_count_rsv_rec(
726: x_rsv_rec => l_cc_rsv_rec
727: , p_organization_id => p_organization_id

Line 762: , p_init_msg_lst => fnd_api.g_false

758: /* Querying MTR to check for any Reservation with the same values as that of the new
759: Cycle Count Reservation record to be created */
760: inv_reservation_pvt.query_reservation(
761: p_api_version_number => 1.0
762: , p_init_msg_lst => fnd_api.g_false
763: , x_return_status => x_return_status
764: , x_msg_count => l_msg_count
765: , x_msg_data => l_msg_data
766: , p_query_input => l_cc_rsv_rec

Line 772: IF x_return_status <> fnd_api.g_ret_sts_success THEN

768: , x_mtl_reservation_tbl_count => l_reservation_count
769: , x_error_code => l_api_error_code
770: );
771:
772: IF x_return_status <> fnd_api.g_ret_sts_success THEN
773: IF l_debug = 1 THEN
774: print_debug('Error: Querying Reservations to check for any existing reservation failed', l_api_name, g_error);
775: END IF;
776: fnd_message.set_name('INV', 'INV_QRY_RSV_FAILED');

Line 778: RAISE fnd_api.g_exc_unexpected_error;

774: print_debug('Error: Querying Reservations to check for any existing reservation failed', l_api_name, g_error);
775: END IF;
776: fnd_message.set_name('INV', 'INV_QRY_RSV_FAILED');
777: fnd_msg_pub.ADD;
778: RAISE fnd_api.g_exc_unexpected_error;
779: END IF;
780:
781: IF l_debug = 1 THEN
782: print_debug('Number of CC Reservations existing for Item = ' || l_reservation_count, l_api_name, g_info);

Line 791: RAISE fnd_api.g_exc_unexpected_error;

787: print_debug('Error: Query Reservation returned more than one record', l_api_name, g_error);
788: END IF;
789: fnd_message.set_name('INV', 'INV_NON_UNIQUE_RSV');
790: fnd_msg_pub.ADD;
791: RAISE fnd_api.g_exc_unexpected_error;
792: END IF;
793:
794: l_update_rsv := (l_reservation_count = 1);
795:

Line 832: , p_init_msg_lst => fnd_api.g_true

828: , x_msg_count => l_msg_count
829: , x_msg_data => l_msg_data
830: , x_reservation_id => l_new_reservation_id
831: , p_api_version_number => 1.0
832: , p_init_msg_lst => fnd_api.g_true
833: , p_original_rsv_rec => l_existing_rsv_rec
834: , p_to_rsv_rec => l_cc_rsv_rec
835: , p_original_serial_number => l_dummy_sn
836: , p_validation_flag => fnd_api.g_true

Line 836: , p_validation_flag => fnd_api.g_true

832: , p_init_msg_lst => fnd_api.g_true
833: , p_original_rsv_rec => l_existing_rsv_rec
834: , p_to_rsv_rec => l_cc_rsv_rec
835: , p_original_serial_number => l_dummy_sn
836: , p_validation_flag => fnd_api.g_true
837: );
838:
839: IF x_return_status <> fnd_api.g_ret_sts_success THEN
840: IF l_debug = 1 THEN

Line 839: IF x_return_status <> fnd_api.g_ret_sts_success THEN

835: , p_original_serial_number => l_dummy_sn
836: , p_validation_flag => fnd_api.g_true
837: );
838:
839: IF x_return_status <> fnd_api.g_ret_sts_success THEN
840: IF l_debug = 1 THEN
841: print_debug('Call to Transfer Reservation API Failed', l_api_name, g_error);
842: END IF;
843: fnd_message.set_name('INV','INV_TRANSFER_RSV_FAILED');

Line 845: RAISE fnd_api.g_exc_unexpected_error;

841: print_debug('Call to Transfer Reservation API Failed', l_api_name, g_error);
842: END IF;
843: fnd_message.set_name('INV','INV_TRANSFER_RSV_FAILED');
844: fnd_msg_pub.ADD;
845: RAISE fnd_api.g_exc_unexpected_error;
846: END IF;
847:
848: -- The Reservation created below will always be updated in the Reservation created now.
849: l_cc_rsv_rec.reservation_id := l_new_reservation_id;

Line 870: , p_init_msg_lst => fnd_api.g_false

866: x_return_status => x_return_status
867: , x_msg_count => l_msg_count
868: , x_msg_data => l_msg_data
869: , p_api_version_number => 1.0
870: , p_init_msg_lst => fnd_api.g_false
871: , p_original_rsv_rec => l_reservations_tbl(1)
872: , p_to_rsv_rec => l_cc_rsv_rec
873: , p_original_serial_number => l_dummy_sn
874: , p_to_serial_number => l_dummy_sn

Line 875: , p_validation_flag => fnd_api.g_true

871: , p_original_rsv_rec => l_reservations_tbl(1)
872: , p_to_rsv_rec => l_cc_rsv_rec
873: , p_original_serial_number => l_dummy_sn
874: , p_to_serial_number => l_dummy_sn
875: , p_validation_flag => fnd_api.g_true
876: );
877: IF x_return_status <> fnd_api.g_ret_sts_success THEN
878: fnd_message.set_name('INV','INV_UPDATE_RSV_FAILED');
879: fnd_msg_pub.ADD;

Line 877: IF x_return_status <> fnd_api.g_ret_sts_success THEN

873: , p_original_serial_number => l_dummy_sn
874: , p_to_serial_number => l_dummy_sn
875: , p_validation_flag => fnd_api.g_true
876: );
877: IF x_return_status <> fnd_api.g_ret_sts_success THEN
878: fnd_message.set_name('INV','INV_UPDATE_RSV_FAILED');
879: fnd_msg_pub.ADD;
880: RAISE fnd_api.g_exc_unexpected_error;
881: END IF;

Line 880: RAISE fnd_api.g_exc_unexpected_error;

876: );
877: IF x_return_status <> fnd_api.g_ret_sts_success THEN
878: fnd_message.set_name('INV','INV_UPDATE_RSV_FAILED');
879: fnd_msg_pub.ADD;
880: RAISE fnd_api.g_exc_unexpected_error;
881: END IF;
882: ELSE
883: l_cc_rsv_rec.primary_reservation_quantity := p_primary_quantity;
884: --INVCONV kkillams

Line 898: , p_init_msg_lst => fnd_api.g_true

894: , x_reservation_id => l_new_reservation_id
895: , x_quantity_reserved => l_qty_reserved
896: , x_secondary_quantity_reserved=> l_sec_qty_reserved --INVCONV kkillams
897: , p_api_version_number => 1.0
898: , p_init_msg_lst => fnd_api.g_true
899: , p_rsv_rec => l_cc_rsv_rec
900: , p_serial_number => l_dummy_sn
901: , x_serial_number => l_dummy_sn
902: , p_validation_flag => fnd_api.g_true

Line 902: , p_validation_flag => fnd_api.g_true

898: , p_init_msg_lst => fnd_api.g_true
899: , p_rsv_rec => l_cc_rsv_rec
900: , p_serial_number => l_dummy_sn
901: , x_serial_number => l_dummy_sn
902: , p_validation_flag => fnd_api.g_true
903: , p_partial_reservation_flag => fnd_api.g_false
904: , p_force_reservation_flag => fnd_api.g_false
905: );
906: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 903: , p_partial_reservation_flag => fnd_api.g_false

899: , p_rsv_rec => l_cc_rsv_rec
900: , p_serial_number => l_dummy_sn
901: , x_serial_number => l_dummy_sn
902: , p_validation_flag => fnd_api.g_true
903: , p_partial_reservation_flag => fnd_api.g_false
904: , p_force_reservation_flag => fnd_api.g_false
905: );
906: IF x_return_status <> fnd_api.g_ret_sts_success THEN
907: fnd_message.set_name('INV','INV_CREATE_RSV_FAILED');

Line 904: , p_force_reservation_flag => fnd_api.g_false

900: , p_serial_number => l_dummy_sn
901: , x_serial_number => l_dummy_sn
902: , p_validation_flag => fnd_api.g_true
903: , p_partial_reservation_flag => fnd_api.g_false
904: , p_force_reservation_flag => fnd_api.g_false
905: );
906: IF x_return_status <> fnd_api.g_ret_sts_success THEN
907: fnd_message.set_name('INV','INV_CREATE_RSV_FAILED');
908: fnd_msg_pub.ADD;

Line 906: IF x_return_status <> fnd_api.g_ret_sts_success THEN

902: , p_validation_flag => fnd_api.g_true
903: , p_partial_reservation_flag => fnd_api.g_false
904: , p_force_reservation_flag => fnd_api.g_false
905: );
906: IF x_return_status <> fnd_api.g_ret_sts_success THEN
907: fnd_message.set_name('INV','INV_CREATE_RSV_FAILED');
908: fnd_msg_pub.ADD;
909: RAISE fnd_api.g_exc_unexpected_error;
910: END IF;

Line 909: RAISE fnd_api.g_exc_unexpected_error;

905: );
906: IF x_return_status <> fnd_api.g_ret_sts_success THEN
907: fnd_message.set_name('INV','INV_CREATE_RSV_FAILED');
908: fnd_msg_pub.ADD;
909: RAISE fnd_api.g_exc_unexpected_error;
910: END IF;
911:
912: /* Since a new Reservation is created, the next Reservation created below should be
913: updated in the Reservation created now */

Line 944: , p_init_msg_lst => fnd_api.g_false

940: x_return_status => x_return_status
941: , x_msg_count => l_msg_count
942: , x_msg_data => l_msg_data
943: , p_api_version_number => 1.0
944: , p_init_msg_lst => fnd_api.g_false
945: , p_original_rsv_rec => l_existing_rsv_rec
946: , p_to_rsv_rec => l_cc_rsv_rec
947: , p_original_serial_number => l_dummy_sn
948: , p_to_serial_number => l_dummy_sn

Line 949: , p_validation_flag => fnd_api.g_true

945: , p_original_rsv_rec => l_existing_rsv_rec
946: , p_to_rsv_rec => l_cc_rsv_rec
947: , p_original_serial_number => l_dummy_sn
948: , p_to_serial_number => l_dummy_sn
949: , p_validation_flag => fnd_api.g_true
950: );
951: IF x_return_status <> fnd_api.g_ret_sts_success THEN
952: fnd_message.set_name('INV','INV_UPDATE_RSV_FAILED');
953: fnd_msg_pub.ADD;

Line 951: IF x_return_status <> fnd_api.g_ret_sts_success THEN

947: , p_original_serial_number => l_dummy_sn
948: , p_to_serial_number => l_dummy_sn
949: , p_validation_flag => fnd_api.g_true
950: );
951: IF x_return_status <> fnd_api.g_ret_sts_success THEN
952: fnd_message.set_name('INV','INV_UPDATE_RSV_FAILED');
953: fnd_msg_pub.ADD;
954: RAISE fnd_api.g_exc_unexpected_error;
955: END IF;

Line 954: RAISE fnd_api.g_exc_unexpected_error;

950: );
951: IF x_return_status <> fnd_api.g_ret_sts_success THEN
952: fnd_message.set_name('INV','INV_UPDATE_RSV_FAILED');
953: fnd_msg_pub.ADD;
954: RAISE fnd_api.g_exc_unexpected_error;
955: END IF;
956: END IF;
957: EXCEPTION
958: WHEN fnd_api.g_exc_error THEN

Line 958: WHEN fnd_api.g_exc_error THEN

954: RAISE fnd_api.g_exc_unexpected_error;
955: END IF;
956: END IF;
957: EXCEPTION
958: WHEN fnd_api.g_exc_error THEN
959: x_return_status := fnd_api.g_ret_sts_error;
960: fnd_msg_pub.count_and_get(p_encoded=>fnd_api.g_false, p_data => l_msg_data, p_count => l_msg_count);
961: IF l_debug = 1 THEN
962: print_debug('Exception: Expected: Message = ' || l_msg_data, l_api_name, g_exception);

Line 959: x_return_status := fnd_api.g_ret_sts_error;

955: END IF;
956: END IF;
957: EXCEPTION
958: WHEN fnd_api.g_exc_error THEN
959: x_return_status := fnd_api.g_ret_sts_error;
960: fnd_msg_pub.count_and_get(p_encoded=>fnd_api.g_false, p_data => l_msg_data, p_count => l_msg_count);
961: IF l_debug = 1 THEN
962: print_debug('Exception: Expected: Message = ' || l_msg_data, l_api_name, g_exception);
963: END IF;

Line 960: fnd_msg_pub.count_and_get(p_encoded=>fnd_api.g_false, p_data => l_msg_data, p_count => l_msg_count);

956: END IF;
957: EXCEPTION
958: WHEN fnd_api.g_exc_error THEN
959: x_return_status := fnd_api.g_ret_sts_error;
960: fnd_msg_pub.count_and_get(p_encoded=>fnd_api.g_false, p_data => l_msg_data, p_count => l_msg_count);
961: IF l_debug = 1 THEN
962: print_debug('Exception: Expected: Message = ' || l_msg_data, l_api_name, g_exception);
963: END IF;
964: WHEN fnd_api.g_exc_unexpected_error THEN

Line 964: WHEN fnd_api.g_exc_unexpected_error THEN

960: fnd_msg_pub.count_and_get(p_encoded=>fnd_api.g_false, p_data => l_msg_data, p_count => l_msg_count);
961: IF l_debug = 1 THEN
962: print_debug('Exception: Expected: Message = ' || l_msg_data, l_api_name, g_exception);
963: END IF;
964: WHEN fnd_api.g_exc_unexpected_error THEN
965: x_return_status := fnd_api.g_ret_sts_unexp_error;
966: fnd_msg_pub.count_and_get(p_encoded=>fnd_api.g_false, p_data => l_msg_data, p_count => l_msg_count);
967: IF l_debug = 1 THEN
968: print_debug('Exception: Unexpected: Message = ' || l_msg_data, l_api_name, g_exception);

Line 965: x_return_status := fnd_api.g_ret_sts_unexp_error;

961: IF l_debug = 1 THEN
962: print_debug('Exception: Expected: Message = ' || l_msg_data, l_api_name, g_exception);
963: END IF;
964: WHEN fnd_api.g_exc_unexpected_error THEN
965: x_return_status := fnd_api.g_ret_sts_unexp_error;
966: fnd_msg_pub.count_and_get(p_encoded=>fnd_api.g_false, p_data => l_msg_data, p_count => l_msg_count);
967: IF l_debug = 1 THEN
968: print_debug('Exception: Unexpected: Message = ' || l_msg_data, l_api_name, g_exception);
969: END IF;

Line 966: fnd_msg_pub.count_and_get(p_encoded=>fnd_api.g_false, p_data => l_msg_data, p_count => l_msg_count);

962: print_debug('Exception: Expected: Message = ' || l_msg_data, l_api_name, g_exception);
963: END IF;
964: WHEN fnd_api.g_exc_unexpected_error THEN
965: x_return_status := fnd_api.g_ret_sts_unexp_error;
966: fnd_msg_pub.count_and_get(p_encoded=>fnd_api.g_false, p_data => l_msg_data, p_count => l_msg_count);
967: IF l_debug = 1 THEN
968: print_debug('Exception: Unexpected: Message = ' || l_msg_data, l_api_name, g_exception);
969: END IF;
970: WHEN OTHERS THEN

Line 971: x_return_status := fnd_api.g_ret_sts_unexp_error;

967: IF l_debug = 1 THEN
968: print_debug('Exception: Unexpected: Message = ' || l_msg_data, l_api_name, g_exception);
969: END IF;
970: WHEN OTHERS THEN
971: x_return_status := fnd_api.g_ret_sts_unexp_error;
972: IF l_debug = 1 THEN
973: print_debug('Exception: Others: Message = ' || SQLERRM, l_api_name, g_exception);
974: END IF;
975: END create_cc_reservations;

Line 1022: x_return_status := fnd_api.g_ret_sts_success;

1018: l_primary_lot_qty NUMBER;
1019:
1020: l_secondary_lot_qty NUMBER; --INVCONV KKILLAMS
1021: BEGIN
1022: x_return_status := fnd_api.g_ret_sts_success;
1023:
1024: IF l_debug = 1 THEN
1025: print_debug('Creating Cycle Count Reservation to report Missing Material', l_api_name, g_info);
1026: END IF;

Line 1086: x_return_status := fnd_api.g_ret_sts_unexp_error;

1082: END LOOP;
1083: END IF;
1084: EXCEPTION
1085: WHEN OTHERS THEN
1086: x_return_status := fnd_api.g_ret_sts_unexp_error;
1087: END report_cycle_count;
1088:
1089: PROCEDURE populate_tt_lot(
1090: x_return_status OUT NOCOPY VARCHAR2

Line 1097: x_return_status := fnd_api.g_ret_sts_success;

1093: ) IS
1094: l_api_name VARCHAR2(30) := 'POPULATE_TABLE';
1095: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1096: BEGIN
1097: x_return_status := fnd_api.g_ret_sts_success;
1098:
1099: IF l_debug = 1 THEN
1100: print_debug('Populating Temp Table for a Lot Ctrl Item', l_api_name, g_info);
1101: END IF;

Line 1128: x_return_status := fnd_api.g_ret_sts_error;

1124: IF SQL%ROWCOUNT = 0 THEN
1125: IF l_debug = 1 THEN
1126: print_debug('Error: No Records Found for the Given Query Criteria', l_api_name, g_error);
1127: END IF;
1128: x_return_status := fnd_api.g_ret_sts_error;
1129: END IF;
1130:
1131: IF l_debug = 1 THEN
1132: print_debug('Populated Temp Table with Lot Information', l_api_name, g_info);

Line 1136: x_return_status := fnd_api.g_ret_sts_unexp_error;

1132: print_debug('Populated Temp Table with Lot Information', l_api_name, g_info);
1133: END IF;
1134: EXCEPTION
1135: WHEN OTHERS THEN
1136: x_return_status := fnd_api.g_ret_sts_unexp_error;
1137: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1138: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1139: END IF;
1140: IF l_debug = 1 THEN

Line 1153: x_return_status := fnd_api.g_ret_sts_success;

1149: ) IS
1150: l_api_name VARCHAR2(30) := 'POPULATE_TABLE';
1151: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1152: BEGIN
1153: x_return_status := fnd_api.g_ret_sts_success;
1154:
1155: IF l_debug = 1 THEN
1156: print_debug('Populating Temp Table for a Serial Ctrl Item', l_api_name, g_info);
1157: END IF;

Line 1177: x_return_status := fnd_api.g_ret_sts_unexp_error;

1173: print_debug('Populated Temp Table with Serial Information', l_api_name, g_info);
1174: END IF;
1175: EXCEPTION
1176: WHEN OTHERS THEN
1177: x_return_status := fnd_api.g_ret_sts_unexp_error;
1178: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1179: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1180: END IF;
1181: IF l_debug = 1 THEN

Line 1194: x_return_status := fnd_api.g_ret_sts_success;

1190: ) IS
1191: l_api_name VARCHAR2(30) := 'POPULATE_TABLE';
1192: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1193: BEGIN
1194: x_return_status := fnd_api.g_ret_sts_success;
1195:
1196: IF l_debug = 1 THEN
1197: print_debug('Populating Temp Table for a Lot and Serial Ctrl Item', l_api_name, g_info);
1198: END IF;

Line 1230: x_return_status := fnd_api.g_ret_sts_unexp_error;

1226: print_debug('Populated Temp Table with Lot and Serial Information', l_api_name, g_info);
1227: END IF;
1228: EXCEPTION
1229: WHEN OTHERS THEN
1230: x_return_status := fnd_api.g_ret_sts_unexp_error;
1231: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1232: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1233: END IF;
1234: IF l_debug = 1 THEN

Line 1253: x_return_status := fnd_api.g_ret_sts_success;

1249: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1250: l_lot_control_code NUMBER := p_lot_control_code;
1251: l_serial_control_code NUMBER := p_serial_control_code;
1252: BEGIN
1253: x_return_status := fnd_api.g_ret_sts_success;
1254:
1255: -- Printing the Input Parameters.
1256: IF l_debug = 1 THEN
1257: print_debug('Populating the Allocations Temp Table with Suggested Lots/Serials', l_api_name, g_info);

Line 1271: RAISE fnd_api.g_exc_error;

1267: print_debug('Error: Either TxnTmpID or MOLineID has to be passed', l_api_name, g_error);
1268: END IF;
1269: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');
1270: fnd_msg_pub.ADD;
1271: RAISE fnd_api.g_exc_error;
1272: END IF;
1273:
1274: -- Determining the Item Controls.
1275: IF p_lot_control_code IS NULL OR p_serial_control_code IS NULL THEN

Line 1283: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1279: , x_serial_control_code => l_serial_control_code
1280: , p_transaction_temp_id => p_transaction_temp_id
1281: , p_mo_line_id => p_mo_line_id
1282: );
1283: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1284: IF l_debug = 1 THEN
1285: print_debug('Error: Cannot determine the Item Controls', l_api_name, g_error);
1286: END IF;
1287: fnd_message.set_name('INV','INV_INVALID_ITEM_ORG');

Line 1289: RAISE fnd_api.g_exc_error;

1285: print_debug('Error: Cannot determine the Item Controls', l_api_name, g_error);
1286: END IF;
1287: fnd_message.set_name('INV','INV_INVALID_ITEM_ORG');
1288: fnd_msg_pub.ADD;
1289: RAISE fnd_api.g_exc_error;
1290: END IF;
1291: END IF;
1292:
1293: -- First clear Allocations Temp Table.

Line 1303: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1299: populate_tt_serial(x_return_status, p_transaction_temp_id, p_mo_line_id);
1300: ELSIF l_lot_control_code = 2 AND l_serial_control_code NOT IN(1, 6) THEN
1301: populate_tt_lot_serial(x_return_status, p_transaction_temp_id, p_mo_line_id);
1302: END IF;
1303: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1304: IF l_debug = 1 THEN
1305: print_debug('Error: Not able to Populate the Allocations Temp Table', l_api_name, g_error);
1306: END IF;
1307: RAISE fnd_api.g_exc_unexpected_error;

Line 1307: RAISE fnd_api.g_exc_unexpected_error;

1303: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1304: IF l_debug = 1 THEN
1305: print_debug('Error: Not able to Populate the Allocations Temp Table', l_api_name, g_error);
1306: END IF;
1307: RAISE fnd_api.g_exc_unexpected_error;
1308: END IF;
1309:
1310: IF l_debug = 1 THEN
1311: print_debug('Allocations Temp Table Populated with the Suggested Lots/Serials', l_api_name, g_info);

Line 1314: WHEN fnd_api.g_exc_error THEN

1310: IF l_debug = 1 THEN
1311: print_debug('Allocations Temp Table Populated with the Suggested Lots/Serials', l_api_name, g_info);
1312: END IF;
1313: EXCEPTION
1314: WHEN fnd_api.g_exc_error THEN
1315: x_return_status := fnd_api.g_ret_sts_error;
1316: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1317: IF l_debug = 1 THEN
1318: print_debug('Exception: Expected Error occurred', l_api_name, g_exception);

Line 1315: x_return_status := fnd_api.g_ret_sts_error;

1311: print_debug('Allocations Temp Table Populated with the Suggested Lots/Serials', l_api_name, g_info);
1312: END IF;
1313: EXCEPTION
1314: WHEN fnd_api.g_exc_error THEN
1315: x_return_status := fnd_api.g_ret_sts_error;
1316: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1317: IF l_debug = 1 THEN
1318: print_debug('Exception: Expected Error occurred', l_api_name, g_exception);
1319: END IF;

Line 1320: WHEN fnd_api.g_exc_unexpected_error THEN

1316: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1317: IF l_debug = 1 THEN
1318: print_debug('Exception: Expected Error occurred', l_api_name, g_exception);
1319: END IF;
1320: WHEN fnd_api.g_exc_unexpected_error THEN
1321: x_return_status := fnd_api.g_ret_sts_unexp_error;
1322: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1323: IF l_debug = 1 THEN
1324: print_debug('Exception: UnExpected Error occurred', l_api_name, g_exception);

Line 1321: x_return_status := fnd_api.g_ret_sts_unexp_error;

1317: IF l_debug = 1 THEN
1318: print_debug('Exception: Expected Error occurred', l_api_name, g_exception);
1319: END IF;
1320: WHEN fnd_api.g_exc_unexpected_error THEN
1321: x_return_status := fnd_api.g_ret_sts_unexp_error;
1322: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1323: IF l_debug = 1 THEN
1324: print_debug('Exception: UnExpected Error occurred', l_api_name, g_exception);
1325: END IF;

Line 1327: x_return_status := fnd_api.g_ret_sts_unexp_error;

1323: IF l_debug = 1 THEN
1324: print_debug('Exception: UnExpected Error occurred', l_api_name, g_exception);
1325: END IF;
1326: WHEN OTHERS THEN
1327: x_return_status := fnd_api.g_ret_sts_unexp_error;
1328: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1329: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1330: END IF;
1331: IF l_debug = 1 THEN

Line 1353: x_return_status := fnd_api.g_ret_sts_success;

1349: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1350: l_lot_control_code NUMBER := p_lot_control_code;
1351: l_serial_control_code NUMBER := p_serial_control_code;
1352: BEGIN
1353: x_return_status := fnd_api.g_ret_sts_success;
1354:
1355: -- Printing the Input Parameters.
1356: IF l_debug = 1 THEN
1357: print_debug('Processing Missing Qty Action', l_api_name, g_info);

Line 1375: RAISE fnd_api.g_exc_error;

1371: IF p_transaction_temp_id IS NULL THEN
1372: IF l_debug = 1 THEN
1373: print_debug('Error: Transaction Temp ID cannot be NULL', l_api_name, g_error);
1374: END IF;
1375: RAISE fnd_api.g_exc_error;
1376: END IF;
1377:
1378: -- Determining the Item Controls.
1379: IF p_lot_control_code IS NULL OR p_serial_control_code IS NULL THEN

Line 1387: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1383: , x_serial_control_code => l_serial_control_code
1384: , p_transaction_temp_id => p_transaction_temp_id
1385: , p_mo_line_id => NULL
1386: );
1387: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1388: IF l_debug = 1 THEN
1389: print_debug('Error: Cannot determine the Item Controls', l_api_name, g_error);
1390: END IF;
1391: fnd_message.set_name('INV','INV_INVALID_ITEM_ORG');

Line 1393: RAISE fnd_api.g_exc_error;

1389: print_debug('Error: Cannot determine the Item Controls', l_api_name, g_error);
1390: END IF;
1391: fnd_message.set_name('INV','INV_INVALID_ITEM_ORG');
1392: fnd_msg_pub.ADD;
1393: RAISE fnd_api.g_exc_error;
1394: END IF;
1395: END IF;
1396:
1397: remove_confirmed(

Line 1436: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1432: , p_lot_control_code => l_lot_control_code
1433: , p_sec_missing_quantity => p_remaining_secondary_quantity --INVCONV kkillams
1434: );
1435: END IF;
1436: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1437: RAISE fnd_api.g_exc_unexpected_error;
1438: END IF;
1439: EXCEPTION
1440: WHEN fnd_api.g_exc_error THEN

Line 1437: RAISE fnd_api.g_exc_unexpected_error;

1433: , p_sec_missing_quantity => p_remaining_secondary_quantity --INVCONV kkillams
1434: );
1435: END IF;
1436: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1437: RAISE fnd_api.g_exc_unexpected_error;
1438: END IF;
1439: EXCEPTION
1440: WHEN fnd_api.g_exc_error THEN
1441: x_return_status := fnd_api.g_ret_sts_error;

Line 1440: WHEN fnd_api.g_exc_error THEN

1436: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1437: RAISE fnd_api.g_exc_unexpected_error;
1438: END IF;
1439: EXCEPTION
1440: WHEN fnd_api.g_exc_error THEN
1441: x_return_status := fnd_api.g_ret_sts_error;
1442: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1443: IF l_debug = 1 THEN
1444: print_debug('Exception: Expected Error occurred', l_api_name, g_exception);

Line 1441: x_return_status := fnd_api.g_ret_sts_error;

1437: RAISE fnd_api.g_exc_unexpected_error;
1438: END IF;
1439: EXCEPTION
1440: WHEN fnd_api.g_exc_error THEN
1441: x_return_status := fnd_api.g_ret_sts_error;
1442: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1443: IF l_debug = 1 THEN
1444: print_debug('Exception: Expected Error occurred', l_api_name, g_exception);
1445: END IF;

Line 1446: WHEN fnd_api.g_exc_unexpected_error THEN

1442: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1443: IF l_debug = 1 THEN
1444: print_debug('Exception: Expected Error occurred', l_api_name, g_exception);
1445: END IF;
1446: WHEN fnd_api.g_exc_unexpected_error THEN
1447: x_return_status := fnd_api.g_ret_sts_unexp_error;
1448: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1449: IF l_debug = 1 THEN
1450: print_debug('Exception: Unexpected Error occurred', l_api_name, g_exception);

Line 1447: x_return_status := fnd_api.g_ret_sts_unexp_error;

1443: IF l_debug = 1 THEN
1444: print_debug('Exception: Expected Error occurred', l_api_name, g_exception);
1445: END IF;
1446: WHEN fnd_api.g_exc_unexpected_error THEN
1447: x_return_status := fnd_api.g_ret_sts_unexp_error;
1448: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1449: IF l_debug = 1 THEN
1450: print_debug('Exception: Unexpected Error occurred', l_api_name, g_exception);
1451: END IF;

Line 1453: x_return_status := fnd_api.g_ret_sts_unexp_error;

1449: IF l_debug = 1 THEN
1450: print_debug('Exception: Unexpected Error occurred', l_api_name, g_exception);
1451: END IF;
1452: WHEN OTHERS THEN
1453: x_return_status := fnd_api.g_ret_sts_unexp_error;
1454: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1455: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1456: END IF;
1457: IF l_debug = 1 THEN

Line 1484: x_return_status := fnd_api.g_ret_sts_success;

1480: l_inventory_item_id NUMBER;
1481: l_organization_id NUMBER;
1482:
1483: BEGIN
1484: x_return_status := fnd_api.g_ret_sts_success;
1485:
1486: IF l_debug = 1 THEN
1487: print_debug('Updating Allocation Qty', l_api_name, g_info);
1488: print_debug('Transaction Temp ID = ' || p_transaction_temp_id, l_api_name, g_info);

Line 1514: RAISE fnd_api.g_exc_error;

1510: );
1511: IF ( l_confirmed_quantity_primary < 0 )THEN
1512: fnd_message.set_name('INV','INV_UOM_CONV_ERROR');
1513: fnd_msg_pub.ADD;
1514: RAISE fnd_api.g_exc_error;
1515: END IF;
1516:
1517: ELSE
1518: l_confirmed_quantity_primary:=p_confirmed_quantity;

Line 1532: WHEN fnd_api.g_exc_error THEN

1528:
1529:
1530:
1531: EXCEPTION
1532: WHEN fnd_api.g_exc_error THEN
1533: x_return_status := fnd_api.g_ret_sts_error;
1534: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1535: IF l_debug = 1 THEN
1536: print_debug('Exception: Expected Error occurred', l_api_name, g_exception);

Line 1533: x_return_status := fnd_api.g_ret_sts_error;

1529:
1530:
1531: EXCEPTION
1532: WHEN fnd_api.g_exc_error THEN
1533: x_return_status := fnd_api.g_ret_sts_error;
1534: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1535: IF l_debug = 1 THEN
1536: print_debug('Exception: Expected Error occurred', l_api_name, g_exception);
1537: END IF;

Line 1539: x_return_status := fnd_api.g_ret_sts_unexp_error;

1535: IF l_debug = 1 THEN
1536: print_debug('Exception: Expected Error occurred', l_api_name, g_exception);
1537: END IF;
1538: WHEN OTHERS THEN
1539: x_return_status := fnd_api.g_ret_sts_unexp_error;
1540: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1541: IF l_debug = 1 THEN
1542: print_debug('Exception: Unknown Error occurred: SQLCode = ' || SQLCODE, l_api_name, g_exception);
1543: END IF;