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 272: x_return_status := fnd_api.g_ret_sts_success;

268: l_sai_info c_sai_info%ROWTYPE ;
269: l_mmtt_secondary_qty_sum NUMBER := 0 ;
270:
271: BEGIN
272: x_return_status := fnd_api.g_ret_sts_success;
273:
274: OPEN c_mmtt_info;
275: FETCH c_mmtt_info INTO l_mmtt_info;
276: CLOSE c_mmtt_info;

Line 296: RAISE fnd_api.g_exc_unexpected_error;

292: FROM mtl_material_transactions_temp
293: WHERE reservation_id= l_mmtt_info.reservation_id;
294: EXCEPTION
295: WHEN OTHERS THEN
296: RAISE fnd_api.g_exc_unexpected_error;
297: END;
298:
299: /* Start fix for Bug#9758641. Also consider records from mtl_available_inventory_temp.
300: This is required since user can use select available inventory form to create new allocation

Line 339: --RAISE fnd_api.g_exc_unexpected_error;

335: fnd_msg_pub.ADD;
336: /*Bug:4700706. When the reservation record is deleted somehow by this time we need not
337: deal with the reservation.So we just return. */
338: RETURN;
339: --RAISE fnd_api.g_exc_unexpected_error;
340: END IF;
341: CLOSE c_rsv_info;
342:
343: -- Bug#2621481: For ATO Item, Retain the Reservation Qty

Line 437: IF x_return_status <> fnd_api.g_ret_sts_success THEN

433: , p_original_serial_number => l_dummy_sn
434: , p_to_serial_number => l_dummy_sn
435: );
436:
437: IF x_return_status <> fnd_api.g_ret_sts_success THEN
438: fnd_message.set_name('INV', 'INV_UPD_RSV_FAILED');
439: fnd_msg_pub.ADD;
440: RAISE fnd_api.g_exc_unexpected_error;
441: END IF;

Line 440: RAISE fnd_api.g_exc_unexpected_error;

436:
437: IF x_return_status <> fnd_api.g_ret_sts_success THEN
438: fnd_message.set_name('INV', 'INV_UPD_RSV_FAILED');
439: fnd_msg_pub.ADD;
440: RAISE fnd_api.g_exc_unexpected_error;
441: END IF;
442: EXCEPTION
443: WHEN fnd_api.g_exc_error THEN
444: x_return_status := fnd_api.g_ret_sts_error;

Line 443: WHEN fnd_api.g_exc_error THEN

439: fnd_msg_pub.ADD;
440: RAISE fnd_api.g_exc_unexpected_error;
441: END IF;
442: EXCEPTION
443: WHEN fnd_api.g_exc_error THEN
444: x_return_status := fnd_api.g_ret_sts_error;
445: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
446: WHEN fnd_api.g_exc_unexpected_error THEN
447: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 444: x_return_status := fnd_api.g_ret_sts_error;

440: RAISE fnd_api.g_exc_unexpected_error;
441: END IF;
442: EXCEPTION
443: WHEN fnd_api.g_exc_error THEN
444: x_return_status := fnd_api.g_ret_sts_error;
445: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
446: WHEN fnd_api.g_exc_unexpected_error THEN
447: x_return_status := fnd_api.g_ret_sts_unexp_error;
448: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

Line 446: WHEN fnd_api.g_exc_unexpected_error THEN

442: EXCEPTION
443: WHEN fnd_api.g_exc_error THEN
444: x_return_status := fnd_api.g_ret_sts_error;
445: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
446: WHEN fnd_api.g_exc_unexpected_error THEN
447: x_return_status := fnd_api.g_ret_sts_unexp_error;
448: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
449: WHEN OTHERS THEN
450: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 447: x_return_status := fnd_api.g_ret_sts_unexp_error;

443: WHEN fnd_api.g_exc_error THEN
444: x_return_status := fnd_api.g_ret_sts_error;
445: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
446: WHEN fnd_api.g_exc_unexpected_error THEN
447: x_return_status := fnd_api.g_ret_sts_unexp_error;
448: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
449: WHEN OTHERS THEN
450: x_return_status := fnd_api.g_ret_sts_unexp_error;
451: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

Line 450: x_return_status := fnd_api.g_ret_sts_unexp_error;

446: WHEN fnd_api.g_exc_unexpected_error THEN
447: x_return_status := fnd_api.g_ret_sts_unexp_error;
448: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
449: WHEN OTHERS THEN
450: x_return_status := fnd_api.g_ret_sts_unexp_error;
451: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
452: fnd_msg_pub.add_exc_msg(g_pkg_name, 'UNDO_PICK_RELEASE');
453: END IF;
454: END backorder_only;

Line 504: x_return_status := fnd_api.g_ret_sts_success;

500: FROM mtl_allocations_gtmp
501: WHERE transaction_temp_id = p_transaction_temp_id
502: GROUP BY lot_number;
503: BEGIN
504: x_return_status := fnd_api.g_ret_sts_success;
505:
506: IF l_debug = 1 THEN
507: print_debug('Splitting the Current Allocation to create a new one for the Remaining Qty', l_api_name, g_info);
508: END IF;

Line 535: IF x_return_status <> fnd_api.g_ret_sts_success THEN

531: , p_primary_qty => l_rem_pri_qty
532: , p_sec_txn_qty => l_rem_sec_txn_qty --INVCONV KKILLAMS
533: );
534:
535: IF x_return_status <> fnd_api.g_ret_sts_success THEN
536: IF l_debug = 1 THEN
537: print_debug('Error: Cannot copy the MMTT - Error = ' || x_msg_data, l_api_name, g_error);
538: END IF;
539: RAISE fnd_api.g_exc_unexpected_error;

Line 539: RAISE fnd_api.g_exc_unexpected_error;

535: IF x_return_status <> fnd_api.g_ret_sts_success THEN
536: IF l_debug = 1 THEN
537: print_debug('Error: Cannot copy the MMTT - Error = ' || x_msg_data, l_api_name, g_error);
538: END IF;
539: RAISE fnd_api.g_exc_unexpected_error;
540: END IF;
541:
542: IF l_debug = 1 THEN
543: print_debug('The old Transaction Temp id id = '|| p_transaction_temp_id, l_api_name, g_info);

Line 670: x_return_status := fnd_api.g_ret_sts_unexp_error;

666: print_debug('Created a new Allocation: TxnTempID = ' || x_new_txn_temp_id, l_api_name, g_info);
667: END IF;
668: EXCEPTION
669: WHEN OTHERS THEN
670: x_return_status := fnd_api.g_ret_sts_unexp_error;
671: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
672: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
673: END IF;
674: IF l_debug = 1 THEN

Line 712: , p_init_msg_lst => fnd_api.g_false

708: x_return_status => l_return_status
709: , x_msg_count => l_msg_count
710: , x_msg_data => l_msg_data
711: , p_api_version_number => 1.0
712: , p_init_msg_lst => fnd_api.g_false
713: , p_organization_id => p_cc_rsv_rec.organization_id
714: , p_inventory_item_id => p_cc_rsv_rec.inventory_item_id
715: , p_tree_mode => inv_quantity_tree_pub.g_reservation_mode
716: , p_is_revision_control => (p_cc_rsv_rec.revision IS NOT NULL)

Line 740: IF l_return_status <> fnd_api.g_ret_sts_success THEN

736: , x_satt => l_satt -- invConv change
737: , x_satr => l_satr -- invConv change
738: --END INVCONV kkilams
739: );
740: IF l_return_status <> fnd_api.g_ret_sts_success THEN
741: IF l_debug = 1 THEN
742: print_debug('Error: Querying the Quantity Tree errored out', l_api_name, g_error);
743: END IF;
744: fnd_message.set_name('INV','INV-CANNOT QUERY TREE');

Line 819: x_return_status := fnd_api.g_ret_sts_success;

815: l_sqr NUMBER;
816:
817: BEGIN
818:
819: x_return_status := fnd_api.g_ret_sts_success;
820:
821: fill_cycle_count_rsv_rec(
822: x_rsv_rec => l_cc_rsv_rec
823: , p_organization_id => p_organization_id

Line 858: , p_init_msg_lst => fnd_api.g_false

854: /* Querying MTR to check for any Reservation with the same values as that of the new
855: Cycle Count Reservation record to be created */
856: inv_reservation_pvt.query_reservation(
857: p_api_version_number => 1.0
858: , p_init_msg_lst => fnd_api.g_false
859: , x_return_status => x_return_status
860: , x_msg_count => l_msg_count
861: , x_msg_data => l_msg_data
862: , p_query_input => l_cc_rsv_rec

Line 868: IF x_return_status <> fnd_api.g_ret_sts_success THEN

864: , x_mtl_reservation_tbl_count => l_reservation_count
865: , x_error_code => l_api_error_code
866: );
867:
868: IF x_return_status <> fnd_api.g_ret_sts_success THEN
869: IF l_debug = 1 THEN
870: print_debug('Error: Querying Reservations to check for any existing reservation failed', l_api_name, g_error);
871: END IF;
872: fnd_message.set_name('INV', 'INV_QRY_RSV_FAILED');

Line 874: RAISE fnd_api.g_exc_unexpected_error;

870: print_debug('Error: Querying Reservations to check for any existing reservation failed', l_api_name, g_error);
871: END IF;
872: fnd_message.set_name('INV', 'INV_QRY_RSV_FAILED');
873: fnd_msg_pub.ADD;
874: RAISE fnd_api.g_exc_unexpected_error;
875: END IF;
876:
877: IF l_debug = 1 THEN
878: print_debug('Number of CC Reservations existing for Item = ' || l_reservation_count, l_api_name, g_info);

Line 887: RAISE fnd_api.g_exc_unexpected_error;

883: print_debug('Error: Query Reservation returned more than one record', l_api_name, g_error);
884: END IF;
885: fnd_message.set_name('INV', 'INV_NON_UNIQUE_RSV');
886: fnd_msg_pub.ADD;
887: RAISE fnd_api.g_exc_unexpected_error;
888: END IF;
889:
890: l_update_rsv := (l_reservation_count = 1);
891:

Line 914: , p_init_msg_lst => fnd_api.g_false

910: --Bug 13836909 Calling the update quantities only when we update/txfer the reservation.
911: IF( p_reservation_id is not null or l_update_rsv) THEN
912: inv_quantity_tree_pub.update_quantities(
913: p_api_version_number => 1.0
914: , p_init_msg_lst => fnd_api.g_false
915: , x_return_status => x_return_status
916: , x_msg_count => l_msg_count
917: , x_msg_data => l_msg_data
918: , p_organization_id => p_organization_id

Line 951: IF x_return_status <> fnd_api.g_ret_sts_success THEN

947: , x_satt => l_satt
948: , x_satr => l_satr
949: );
950:
951: IF x_return_status <> fnd_api.g_ret_sts_success THEN
952: IF l_debug = 1 THEN
953: print_debug('Error from update quantity tree', l_api_name, g_info);
954: END IF;
955: RAISE fnd_api.g_exc_unexpected_error;

Line 955: RAISE fnd_api.g_exc_unexpected_error;

951: IF x_return_status <> fnd_api.g_ret_sts_success THEN
952: IF l_debug = 1 THEN
953: print_debug('Error from update quantity tree', l_api_name, g_info);
954: END IF;
955: RAISE fnd_api.g_exc_unexpected_error;
956: END IF;
957: END IF;
958:
959: -- If Reservation already exists, Transfer the existing Reservation. Otherwise Create a new one.

Line 979: , p_init_msg_lst => fnd_api.g_true

975: , x_msg_count => l_msg_count
976: , x_msg_data => l_msg_data
977: , x_reservation_id => l_new_reservation_id
978: , p_api_version_number => 1.0
979: , p_init_msg_lst => fnd_api.g_true
980: , p_original_rsv_rec => l_existing_rsv_rec
981: , p_to_rsv_rec => l_cc_rsv_rec
982: , p_original_serial_number => l_dummy_sn
983: , p_validation_flag => fnd_api.g_true

Line 983: , p_validation_flag => fnd_api.g_true

979: , p_init_msg_lst => fnd_api.g_true
980: , p_original_rsv_rec => l_existing_rsv_rec
981: , p_to_rsv_rec => l_cc_rsv_rec
982: , p_original_serial_number => l_dummy_sn
983: , p_validation_flag => fnd_api.g_true
984: );
985:
986: IF x_return_status <> fnd_api.g_ret_sts_success THEN
987: IF l_debug = 1 THEN

Line 986: IF x_return_status <> fnd_api.g_ret_sts_success THEN

982: , p_original_serial_number => l_dummy_sn
983: , p_validation_flag => fnd_api.g_true
984: );
985:
986: IF x_return_status <> fnd_api.g_ret_sts_success THEN
987: IF l_debug = 1 THEN
988: print_debug('Call to Transfer Reservation API Failed', l_api_name, g_error);
989: END IF;
990: fnd_message.set_name('INV','INV_TRANSFER_RSV_FAILED');

Line 992: RAISE fnd_api.g_exc_unexpected_error;

988: print_debug('Call to Transfer Reservation API Failed', l_api_name, g_error);
989: END IF;
990: fnd_message.set_name('INV','INV_TRANSFER_RSV_FAILED');
991: fnd_msg_pub.ADD;
992: RAISE fnd_api.g_exc_unexpected_error;
993: END IF;
994:
995: -- The Reservation created below will always be updated in the Reservation created now.
996: l_cc_rsv_rec.reservation_id := l_new_reservation_id;

Line 1017: , p_init_msg_lst => fnd_api.g_false

1013: x_return_status => x_return_status
1014: , x_msg_count => l_msg_count
1015: , x_msg_data => l_msg_data
1016: , p_api_version_number => 1.0
1017: , p_init_msg_lst => fnd_api.g_false
1018: , p_original_rsv_rec => l_reservations_tbl(1)
1019: , p_to_rsv_rec => l_cc_rsv_rec
1020: , p_original_serial_number => l_dummy_sn
1021: , p_to_serial_number => l_dummy_sn

Line 1022: , p_validation_flag => fnd_api.g_true

1018: , p_original_rsv_rec => l_reservations_tbl(1)
1019: , p_to_rsv_rec => l_cc_rsv_rec
1020: , p_original_serial_number => l_dummy_sn
1021: , p_to_serial_number => l_dummy_sn
1022: , p_validation_flag => fnd_api.g_true
1023: );
1024: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1025: fnd_message.set_name('INV','INV_UPDATE_RSV_FAILED');
1026: fnd_msg_pub.ADD;

Line 1024: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1020: , p_original_serial_number => l_dummy_sn
1021: , p_to_serial_number => l_dummy_sn
1022: , p_validation_flag => fnd_api.g_true
1023: );
1024: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1025: fnd_message.set_name('INV','INV_UPDATE_RSV_FAILED');
1026: fnd_msg_pub.ADD;
1027: RAISE fnd_api.g_exc_unexpected_error;
1028: END IF;

Line 1027: RAISE fnd_api.g_exc_unexpected_error;

1023: );
1024: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1025: fnd_message.set_name('INV','INV_UPDATE_RSV_FAILED');
1026: fnd_msg_pub.ADD;
1027: RAISE fnd_api.g_exc_unexpected_error;
1028: END IF;
1029: ELSE
1030: l_cc_rsv_rec.primary_reservation_quantity := p_primary_quantity;
1031: --INVCONV kkillams

Line 1045: , p_init_msg_lst => fnd_api.g_true

1041: , x_reservation_id => l_new_reservation_id
1042: , x_quantity_reserved => l_qty_reserved
1043: , x_secondary_quantity_reserved=> l_sec_qty_reserved --INVCONV kkillams
1044: , p_api_version_number => 1.0
1045: , p_init_msg_lst => fnd_api.g_true
1046: , p_rsv_rec => l_cc_rsv_rec
1047: , p_serial_number => l_dummy_sn
1048: , x_serial_number => l_dummy_sn
1049: , p_validation_flag => fnd_api.g_true

Line 1049: , p_validation_flag => fnd_api.g_true

1045: , p_init_msg_lst => fnd_api.g_true
1046: , p_rsv_rec => l_cc_rsv_rec
1047: , p_serial_number => l_dummy_sn
1048: , x_serial_number => l_dummy_sn
1049: , p_validation_flag => fnd_api.g_true
1050: , p_partial_reservation_flag => fnd_api.g_false
1051: , p_force_reservation_flag => fnd_api.g_false
1052: );
1053: IF x_return_status <> fnd_api.g_ret_sts_success THEN

Line 1050: , p_partial_reservation_flag => fnd_api.g_false

1046: , p_rsv_rec => l_cc_rsv_rec
1047: , p_serial_number => l_dummy_sn
1048: , x_serial_number => l_dummy_sn
1049: , p_validation_flag => fnd_api.g_true
1050: , p_partial_reservation_flag => fnd_api.g_false
1051: , p_force_reservation_flag => fnd_api.g_false
1052: );
1053: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1054: fnd_message.set_name('INV','INV_CREATE_RSV_FAILED');

Line 1051: , p_force_reservation_flag => fnd_api.g_false

1047: , p_serial_number => l_dummy_sn
1048: , x_serial_number => l_dummy_sn
1049: , p_validation_flag => fnd_api.g_true
1050: , p_partial_reservation_flag => fnd_api.g_false
1051: , p_force_reservation_flag => fnd_api.g_false
1052: );
1053: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1054: fnd_message.set_name('INV','INV_CREATE_RSV_FAILED');
1055: fnd_msg_pub.ADD;

Line 1053: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1049: , p_validation_flag => fnd_api.g_true
1050: , p_partial_reservation_flag => fnd_api.g_false
1051: , p_force_reservation_flag => fnd_api.g_false
1052: );
1053: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1054: fnd_message.set_name('INV','INV_CREATE_RSV_FAILED');
1055: fnd_msg_pub.ADD;
1056: RAISE fnd_api.g_exc_unexpected_error;
1057: END IF;

Line 1056: RAISE fnd_api.g_exc_unexpected_error;

1052: );
1053: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1054: fnd_message.set_name('INV','INV_CREATE_RSV_FAILED');
1055: fnd_msg_pub.ADD;
1056: RAISE fnd_api.g_exc_unexpected_error;
1057: END IF;
1058:
1059: /* Since a new Reservation is created, the next Reservation created below should be
1060: updated in the Reservation created now */

Line 1091: , p_init_msg_lst => fnd_api.g_false

1087: x_return_status => x_return_status
1088: , x_msg_count => l_msg_count
1089: , x_msg_data => l_msg_data
1090: , p_api_version_number => 1.0
1091: , p_init_msg_lst => fnd_api.g_false
1092: , p_original_rsv_rec => l_existing_rsv_rec
1093: , p_to_rsv_rec => l_cc_rsv_rec
1094: , p_original_serial_number => l_dummy_sn
1095: , p_to_serial_number => l_dummy_sn

Line 1096: , p_validation_flag => fnd_api.g_true

1092: , p_original_rsv_rec => l_existing_rsv_rec
1093: , p_to_rsv_rec => l_cc_rsv_rec
1094: , p_original_serial_number => l_dummy_sn
1095: , p_to_serial_number => l_dummy_sn
1096: , p_validation_flag => fnd_api.g_true
1097: );
1098: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1099: fnd_message.set_name('INV','INV_UPDATE_RSV_FAILED');
1100: fnd_msg_pub.ADD;

Line 1098: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1094: , p_original_serial_number => l_dummy_sn
1095: , p_to_serial_number => l_dummy_sn
1096: , p_validation_flag => fnd_api.g_true
1097: );
1098: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1099: fnd_message.set_name('INV','INV_UPDATE_RSV_FAILED');
1100: fnd_msg_pub.ADD;
1101: RAISE fnd_api.g_exc_unexpected_error;
1102: END IF;

Line 1101: RAISE fnd_api.g_exc_unexpected_error;

1097: );
1098: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1099: fnd_message.set_name('INV','INV_UPDATE_RSV_FAILED');
1100: fnd_msg_pub.ADD;
1101: RAISE fnd_api.g_exc_unexpected_error;
1102: END IF;
1103: END IF;
1104: EXCEPTION
1105: WHEN fnd_api.g_exc_error THEN

Line 1105: WHEN fnd_api.g_exc_error THEN

1101: RAISE fnd_api.g_exc_unexpected_error;
1102: END IF;
1103: END IF;
1104: EXCEPTION
1105: WHEN fnd_api.g_exc_error THEN
1106: x_return_status := fnd_api.g_ret_sts_error;
1107: fnd_msg_pub.count_and_get(p_encoded=>fnd_api.g_false, p_data => l_msg_data, p_count => l_msg_count);
1108: IF l_debug = 1 THEN
1109: print_debug('Exception: Expected: Message = ' || l_msg_data, l_api_name, g_exception);

Line 1106: x_return_status := fnd_api.g_ret_sts_error;

1102: END IF;
1103: END IF;
1104: EXCEPTION
1105: WHEN fnd_api.g_exc_error THEN
1106: x_return_status := fnd_api.g_ret_sts_error;
1107: fnd_msg_pub.count_and_get(p_encoded=>fnd_api.g_false, p_data => l_msg_data, p_count => l_msg_count);
1108: IF l_debug = 1 THEN
1109: print_debug('Exception: Expected: Message = ' || l_msg_data, l_api_name, g_exception);
1110: END IF;

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

1103: END IF;
1104: EXCEPTION
1105: WHEN fnd_api.g_exc_error THEN
1106: x_return_status := fnd_api.g_ret_sts_error;
1107: fnd_msg_pub.count_and_get(p_encoded=>fnd_api.g_false, p_data => l_msg_data, p_count => l_msg_count);
1108: IF l_debug = 1 THEN
1109: print_debug('Exception: Expected: Message = ' || l_msg_data, l_api_name, g_exception);
1110: END IF;
1111: WHEN fnd_api.g_exc_unexpected_error THEN

Line 1111: WHEN fnd_api.g_exc_unexpected_error THEN

1107: fnd_msg_pub.count_and_get(p_encoded=>fnd_api.g_false, p_data => l_msg_data, p_count => l_msg_count);
1108: IF l_debug = 1 THEN
1109: print_debug('Exception: Expected: Message = ' || l_msg_data, l_api_name, g_exception);
1110: END IF;
1111: WHEN fnd_api.g_exc_unexpected_error THEN
1112: x_return_status := fnd_api.g_ret_sts_unexp_error;
1113: fnd_msg_pub.count_and_get(p_encoded=>fnd_api.g_false, p_data => l_msg_data, p_count => l_msg_count);
1114: IF l_debug = 1 THEN
1115: print_debug('Exception: Unexpected: Message = ' || l_msg_data, l_api_name, g_exception);

Line 1112: x_return_status := fnd_api.g_ret_sts_unexp_error;

1108: IF l_debug = 1 THEN
1109: print_debug('Exception: Expected: Message = ' || l_msg_data, l_api_name, g_exception);
1110: END IF;
1111: WHEN fnd_api.g_exc_unexpected_error THEN
1112: x_return_status := fnd_api.g_ret_sts_unexp_error;
1113: fnd_msg_pub.count_and_get(p_encoded=>fnd_api.g_false, p_data => l_msg_data, p_count => l_msg_count);
1114: IF l_debug = 1 THEN
1115: print_debug('Exception: Unexpected: Message = ' || l_msg_data, l_api_name, g_exception);
1116: END IF;

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

1109: print_debug('Exception: Expected: Message = ' || l_msg_data, l_api_name, g_exception);
1110: END IF;
1111: WHEN fnd_api.g_exc_unexpected_error THEN
1112: x_return_status := fnd_api.g_ret_sts_unexp_error;
1113: fnd_msg_pub.count_and_get(p_encoded=>fnd_api.g_false, p_data => l_msg_data, p_count => l_msg_count);
1114: IF l_debug = 1 THEN
1115: print_debug('Exception: Unexpected: Message = ' || l_msg_data, l_api_name, g_exception);
1116: END IF;
1117: WHEN OTHERS THEN

Line 1118: x_return_status := fnd_api.g_ret_sts_unexp_error;

1114: IF l_debug = 1 THEN
1115: print_debug('Exception: Unexpected: Message = ' || l_msg_data, l_api_name, g_exception);
1116: END IF;
1117: WHEN OTHERS THEN
1118: x_return_status := fnd_api.g_ret_sts_unexp_error;
1119: IF l_debug = 1 THEN
1120: print_debug('Exception: Others: Message = ' || SQLERRM, l_api_name, g_exception);
1121: END IF;
1122: END create_cc_reservations;

Line 1169: x_return_status := fnd_api.g_ret_sts_success;

1165: l_primary_lot_qty NUMBER;
1166:
1167: l_secondary_lot_qty NUMBER; --INVCONV KKILLAMS
1168: BEGIN
1169: x_return_status := fnd_api.g_ret_sts_success;
1170:
1171: IF l_debug = 1 THEN
1172: print_debug('Creating Cycle Count Reservation to report Missing Material', l_api_name, g_info);
1173: END IF;

Line 1233: x_return_status := fnd_api.g_ret_sts_unexp_error;

1229: END LOOP;
1230: END IF;
1231: EXCEPTION
1232: WHEN OTHERS THEN
1233: x_return_status := fnd_api.g_ret_sts_unexp_error;
1234: END report_cycle_count;
1235:
1236: PROCEDURE populate_tt_lot(
1237: x_return_status OUT NOCOPY VARCHAR2

Line 1244: x_return_status := fnd_api.g_ret_sts_success;

1240: ) IS
1241: l_api_name VARCHAR2(30) := 'POPULATE_TABLE';
1242: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1243: BEGIN
1244: x_return_status := fnd_api.g_ret_sts_success;
1245:
1246: IF l_debug = 1 THEN
1247: print_debug('Populating Temp Table for a Lot Ctrl Item', l_api_name, g_info);
1248: END IF;

Line 1275: --x_return_status := fnd_api.g_ret_sts_error; --FlexiLotAlloc

1271: IF SQL%ROWCOUNT = 0 THEN
1272: IF l_debug = 1 THEN
1273: print_debug('Error: No Records Found for the Given Query Criteria', l_api_name, g_error);
1274: END IF;
1275: --x_return_status := fnd_api.g_ret_sts_error; --FlexiLotAlloc
1276: END IF;
1277:
1278: IF l_debug = 1 THEN
1279: print_debug('Populated Temp Table with Lot Information', l_api_name, g_info);

Line 1283: x_return_status := fnd_api.g_ret_sts_unexp_error;

1279: print_debug('Populated Temp Table with Lot Information', l_api_name, g_info);
1280: END IF;
1281: EXCEPTION
1282: WHEN OTHERS THEN
1283: x_return_status := fnd_api.g_ret_sts_unexp_error;
1284: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1285: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1286: END IF;
1287: IF l_debug = 1 THEN

Line 1300: x_return_status := fnd_api.g_ret_sts_success;

1296: ) IS
1297: l_api_name VARCHAR2(30) := 'POPULATE_TABLE';
1298: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1299: BEGIN
1300: x_return_status := fnd_api.g_ret_sts_success;
1301:
1302: IF l_debug = 1 THEN
1303: print_debug('Populating Temp Table for a Serial Ctrl Item', l_api_name, g_info);
1304: END IF;

Line 1324: x_return_status := fnd_api.g_ret_sts_unexp_error;

1320: print_debug('Populated Temp Table with Serial Information', l_api_name, g_info);
1321: END IF;
1322: EXCEPTION
1323: WHEN OTHERS THEN
1324: x_return_status := fnd_api.g_ret_sts_unexp_error;
1325: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1326: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1327: END IF;
1328: IF l_debug = 1 THEN

Line 1341: x_return_status := fnd_api.g_ret_sts_success;

1337: ) IS
1338: l_api_name VARCHAR2(30) := 'POPULATE_TABLE';
1339: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1340: BEGIN
1341: x_return_status := fnd_api.g_ret_sts_success;
1342:
1343: IF l_debug = 1 THEN
1344: print_debug('Populating Temp Table for a Lot and Serial Ctrl Item', l_api_name, g_info);
1345: END IF;

Line 1377: x_return_status := fnd_api.g_ret_sts_unexp_error;

1373: print_debug('Populated Temp Table with Lot and Serial Information', l_api_name, g_info);
1374: END IF;
1375: EXCEPTION
1376: WHEN OTHERS THEN
1377: x_return_status := fnd_api.g_ret_sts_unexp_error;
1378: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1379: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1380: END IF;
1381: IF l_debug = 1 THEN

Line 1400: x_return_status := fnd_api.g_ret_sts_success;

1396: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1397: l_lot_control_code NUMBER := p_lot_control_code;
1398: l_serial_control_code NUMBER := p_serial_control_code;
1399: BEGIN
1400: x_return_status := fnd_api.g_ret_sts_success;
1401:
1402: -- Printing the Input Parameters.
1403: IF l_debug = 1 THEN
1404: print_debug('Populating the Allocations Temp Table with Suggested Lots/Serials', l_api_name, g_info);

Line 1418: RAISE fnd_api.g_exc_error;

1414: print_debug('Error: Either TxnTmpID or MOLineID has to be passed', l_api_name, g_error);
1415: END IF;
1416: fnd_message.set_name('INV', 'INV_MISSING_REQUIRED_PARAMETER');
1417: fnd_msg_pub.ADD;
1418: RAISE fnd_api.g_exc_error;
1419: END IF;
1420:
1421: -- Determining the Item Controls.
1422: IF p_lot_control_code IS NULL OR p_serial_control_code IS NULL THEN

Line 1430: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1426: , x_serial_control_code => l_serial_control_code
1427: , p_transaction_temp_id => p_transaction_temp_id
1428: , p_mo_line_id => p_mo_line_id
1429: );
1430: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1431: IF l_debug = 1 THEN
1432: print_debug('Error: Cannot determine the Item Controls', l_api_name, g_error);
1433: END IF;
1434: fnd_message.set_name('INV','INV_INVALID_ITEM_ORG');

Line 1436: RAISE fnd_api.g_exc_error;

1432: print_debug('Error: Cannot determine the Item Controls', l_api_name, g_error);
1433: END IF;
1434: fnd_message.set_name('INV','INV_INVALID_ITEM_ORG');
1435: fnd_msg_pub.ADD;
1436: RAISE fnd_api.g_exc_error;
1437: END IF;
1438: END IF;
1439:
1440: -- First clear Allocations Temp Table.

Line 1450: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1446: populate_tt_serial(x_return_status, p_transaction_temp_id, p_mo_line_id);
1447: ELSIF l_lot_control_code = 2 AND l_serial_control_code NOT IN(1, 6) THEN
1448: populate_tt_lot_serial(x_return_status, p_transaction_temp_id, p_mo_line_id);
1449: END IF;
1450: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1451: IF l_debug = 1 THEN
1452: print_debug('Error: Not able to Populate the Allocations Temp Table', l_api_name, g_error);
1453: END IF;
1454: RAISE fnd_api.g_exc_unexpected_error;

Line 1454: RAISE fnd_api.g_exc_unexpected_error;

1450: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1451: IF l_debug = 1 THEN
1452: print_debug('Error: Not able to Populate the Allocations Temp Table', l_api_name, g_error);
1453: END IF;
1454: RAISE fnd_api.g_exc_unexpected_error;
1455: END IF;
1456:
1457: IF l_debug = 1 THEN
1458: print_debug('Allocations Temp Table Populated with the Suggested Lots/Serials', l_api_name, g_info);

Line 1461: WHEN fnd_api.g_exc_error THEN

1457: IF l_debug = 1 THEN
1458: print_debug('Allocations Temp Table Populated with the Suggested Lots/Serials', l_api_name, g_info);
1459: END IF;
1460: EXCEPTION
1461: WHEN fnd_api.g_exc_error THEN
1462: x_return_status := fnd_api.g_ret_sts_error;
1463: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1464: IF l_debug = 1 THEN
1465: print_debug('Exception: Expected Error occurred', l_api_name, g_exception);

Line 1462: x_return_status := fnd_api.g_ret_sts_error;

1458: print_debug('Allocations Temp Table Populated with the Suggested Lots/Serials', l_api_name, g_info);
1459: END IF;
1460: EXCEPTION
1461: WHEN fnd_api.g_exc_error THEN
1462: x_return_status := fnd_api.g_ret_sts_error;
1463: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1464: IF l_debug = 1 THEN
1465: print_debug('Exception: Expected Error occurred', l_api_name, g_exception);
1466: END IF;

Line 1467: WHEN fnd_api.g_exc_unexpected_error THEN

1463: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1464: IF l_debug = 1 THEN
1465: print_debug('Exception: Expected Error occurred', l_api_name, g_exception);
1466: END IF;
1467: WHEN fnd_api.g_exc_unexpected_error THEN
1468: x_return_status := fnd_api.g_ret_sts_unexp_error;
1469: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1470: IF l_debug = 1 THEN
1471: print_debug('Exception: UnExpected Error occurred', l_api_name, g_exception);

Line 1468: x_return_status := fnd_api.g_ret_sts_unexp_error;

1464: IF l_debug = 1 THEN
1465: print_debug('Exception: Expected Error occurred', l_api_name, g_exception);
1466: END IF;
1467: WHEN fnd_api.g_exc_unexpected_error THEN
1468: x_return_status := fnd_api.g_ret_sts_unexp_error;
1469: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1470: IF l_debug = 1 THEN
1471: print_debug('Exception: UnExpected Error occurred', l_api_name, g_exception);
1472: END IF;

Line 1474: x_return_status := fnd_api.g_ret_sts_unexp_error;

1470: IF l_debug = 1 THEN
1471: print_debug('Exception: UnExpected Error occurred', l_api_name, g_exception);
1472: END IF;
1473: WHEN OTHERS THEN
1474: x_return_status := fnd_api.g_ret_sts_unexp_error;
1475: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1476: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1477: END IF;
1478: IF l_debug = 1 THEN

Line 1500: x_return_status := fnd_api.g_ret_sts_success;

1496: l_debug NUMBER := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'), 0);
1497: l_lot_control_code NUMBER := p_lot_control_code;
1498: l_serial_control_code NUMBER := p_serial_control_code;
1499: BEGIN
1500: x_return_status := fnd_api.g_ret_sts_success;
1501:
1502: -- Printing the Input Parameters.
1503: IF l_debug = 1 THEN
1504: print_debug('Processing Missing Qty Action', l_api_name, g_info);

Line 1522: RAISE fnd_api.g_exc_error;

1518: IF p_transaction_temp_id IS NULL THEN
1519: IF l_debug = 1 THEN
1520: print_debug('Error: Transaction Temp ID cannot be NULL', l_api_name, g_error);
1521: END IF;
1522: RAISE fnd_api.g_exc_error;
1523: END IF;
1524:
1525: -- Determining the Item Controls.
1526: IF p_lot_control_code IS NULL OR p_serial_control_code IS NULL THEN

Line 1534: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1530: , x_serial_control_code => l_serial_control_code
1531: , p_transaction_temp_id => p_transaction_temp_id
1532: , p_mo_line_id => NULL
1533: );
1534: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1535: IF l_debug = 1 THEN
1536: print_debug('Error: Cannot determine the Item Controls', l_api_name, g_error);
1537: END IF;
1538: fnd_message.set_name('INV','INV_INVALID_ITEM_ORG');

Line 1540: RAISE fnd_api.g_exc_error;

1536: print_debug('Error: Cannot determine the Item Controls', l_api_name, g_error);
1537: END IF;
1538: fnd_message.set_name('INV','INV_INVALID_ITEM_ORG');
1539: fnd_msg_pub.ADD;
1540: RAISE fnd_api.g_exc_error;
1541: END IF;
1542: END IF;
1543:
1544: remove_confirmed(

Line 1583: IF x_return_status <> fnd_api.g_ret_sts_success THEN

1579: , p_lot_control_code => l_lot_control_code
1580: , p_sec_missing_quantity => p_remaining_secondary_quantity --INVCONV kkillams
1581: );
1582: END IF;
1583: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1584: RAISE fnd_api.g_exc_unexpected_error;
1585: END IF;
1586: EXCEPTION
1587: WHEN fnd_api.g_exc_error THEN

Line 1584: RAISE fnd_api.g_exc_unexpected_error;

1580: , p_sec_missing_quantity => p_remaining_secondary_quantity --INVCONV kkillams
1581: );
1582: END IF;
1583: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1584: RAISE fnd_api.g_exc_unexpected_error;
1585: END IF;
1586: EXCEPTION
1587: WHEN fnd_api.g_exc_error THEN
1588: x_return_status := fnd_api.g_ret_sts_error;

Line 1587: WHEN fnd_api.g_exc_error THEN

1583: IF x_return_status <> fnd_api.g_ret_sts_success THEN
1584: RAISE fnd_api.g_exc_unexpected_error;
1585: END IF;
1586: EXCEPTION
1587: WHEN fnd_api.g_exc_error THEN
1588: x_return_status := fnd_api.g_ret_sts_error;
1589: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1590: IF l_debug = 1 THEN
1591: print_debug('Exception: Expected Error occurred', l_api_name, g_exception);

Line 1588: x_return_status := fnd_api.g_ret_sts_error;

1584: RAISE fnd_api.g_exc_unexpected_error;
1585: END IF;
1586: EXCEPTION
1587: WHEN fnd_api.g_exc_error THEN
1588: x_return_status := fnd_api.g_ret_sts_error;
1589: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1590: IF l_debug = 1 THEN
1591: print_debug('Exception: Expected Error occurred', l_api_name, g_exception);
1592: END IF;

Line 1593: WHEN fnd_api.g_exc_unexpected_error THEN

1589: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1590: IF l_debug = 1 THEN
1591: print_debug('Exception: Expected Error occurred', l_api_name, g_exception);
1592: END IF;
1593: WHEN fnd_api.g_exc_unexpected_error THEN
1594: x_return_status := fnd_api.g_ret_sts_unexp_error;
1595: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1596: IF l_debug = 1 THEN
1597: print_debug('Exception: Unexpected Error occurred', l_api_name, g_exception);

Line 1594: x_return_status := fnd_api.g_ret_sts_unexp_error;

1590: IF l_debug = 1 THEN
1591: print_debug('Exception: Expected Error occurred', l_api_name, g_exception);
1592: END IF;
1593: WHEN fnd_api.g_exc_unexpected_error THEN
1594: x_return_status := fnd_api.g_ret_sts_unexp_error;
1595: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1596: IF l_debug = 1 THEN
1597: print_debug('Exception: Unexpected Error occurred', l_api_name, g_exception);
1598: END IF;

Line 1600: x_return_status := fnd_api.g_ret_sts_unexp_error;

1596: IF l_debug = 1 THEN
1597: print_debug('Exception: Unexpected Error occurred', l_api_name, g_exception);
1598: END IF;
1599: WHEN OTHERS THEN
1600: x_return_status := fnd_api.g_ret_sts_unexp_error;
1601: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1602: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1603: END IF;
1604: IF l_debug = 1 THEN

Line 1631: x_return_status := fnd_api.g_ret_sts_success;

1627: l_inventory_item_id NUMBER;
1628: l_organization_id NUMBER;
1629:
1630: BEGIN
1631: x_return_status := fnd_api.g_ret_sts_success;
1632:
1633: IF l_debug = 1 THEN
1634: print_debug('Updating Allocation Qty', l_api_name, g_info);
1635: print_debug('Transaction Temp ID = ' || p_transaction_temp_id, l_api_name, g_info);

Line 1661: RAISE fnd_api.g_exc_error;

1657: );
1658: IF ( l_confirmed_quantity_primary < 0 )THEN
1659: fnd_message.set_name('INV','INV_UOM_CONV_ERROR');
1660: fnd_msg_pub.ADD;
1661: RAISE fnd_api.g_exc_error;
1662: END IF;
1663:
1664: ELSE
1665: l_confirmed_quantity_primary:=p_confirmed_quantity;

Line 1679: WHEN fnd_api.g_exc_error THEN

1675:
1676:
1677:
1678: EXCEPTION
1679: WHEN fnd_api.g_exc_error THEN
1680: x_return_status := fnd_api.g_ret_sts_error;
1681: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1682: IF l_debug = 1 THEN
1683: print_debug('Exception: Expected Error occurred', l_api_name, g_exception);

Line 1680: x_return_status := fnd_api.g_ret_sts_error;

1676:
1677:
1678: EXCEPTION
1679: WHEN fnd_api.g_exc_error THEN
1680: x_return_status := fnd_api.g_ret_sts_error;
1681: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1682: IF l_debug = 1 THEN
1683: print_debug('Exception: Expected Error occurred', l_api_name, g_exception);
1684: END IF;

Line 1686: x_return_status := fnd_api.g_ret_sts_unexp_error;

1682: IF l_debug = 1 THEN
1683: print_debug('Exception: Expected Error occurred', l_api_name, g_exception);
1684: END IF;
1685: WHEN OTHERS THEN
1686: x_return_status := fnd_api.g_ret_sts_unexp_error;
1687: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1688: IF l_debug = 1 THEN
1689: print_debug('Exception: Unknown Error occurred: SQLCode = ' || SQLCODE, l_api_name, g_exception);
1690: END IF;