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_MSG_PUB

Line 227: fnd_msg_pub.ADD;

223: IF (l_debug = 1) THEN
224: debug_print('Error: LPN is reserved for some other demand line');
225: END IF;
226: fnd_message.set_name('INV', 'INV_CANNOT_RESERVE_LPN');
227: fnd_msg_pub.ADD;
228: RAISE fnd_api.g_exc_error;
229: END IF;
230:
231: OPEN c_item_controls;

Line 352: fnd_msg_pub.ADD;

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

Line 362: fnd_msg_pub.ADD;

358: IF (l_debug = 1) THEN
359: debug_print('Error: LPN Qty > Order Line Qty');
360: END IF;
361: fnd_message.set_name('INV', 'INV_LPN_QTY_GREATER');
362: fnd_msg_pub.ADD;
363: RAISE fnd_api.g_exc_error;
364: END IF;
365: END IF;
366:

Line 557: fnd_msg_pub.ADD;

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

Line 671: fnd_msg_pub.ADD;

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

Line 791: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded=> 'F');

787: ROLLBACK TO entire_lpn; --bug#2402957.
788: IF (l_debug = 1) THEN
789: debug_print('Error in Create_LPN_Reservations');
790: END IF;
791: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded=> 'F');
792: WHEN fnd_api.g_exc_unexpected_error THEN
793: x_return_status := fnd_api.g_ret_sts_unexp_error;
794:
795: IF (l_debug = 1) THEN

Line 798: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded=> 'F');

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

Line 806: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

802: IF (l_debug = 1) THEN
803: debug_print('Other error in Create_LPN_Reservations');
804: END IF;
805:
806: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
807: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
808: END IF;
809: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded=> 'F');
810: END create_lpn_reservations;

Line 807: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

803: debug_print('Other error in Create_LPN_Reservations');
804: END IF;
805:
806: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
807: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
808: END IF;
809: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded=> 'F');
810: END create_lpn_reservations;
811:

Line 809: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded=> 'F');

805:
806: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
807: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
808: END IF;
809: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data, p_encoded=> 'F');
810: END create_lpn_reservations;
811:
812: --Transfer_LPN_Reservations
813: --

Line 1027: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

Line 1030: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

Line 1034: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

Line 1035: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

Line 1037: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1033:
1034: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1035: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1036: END IF;
1037: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1038: END transfer_lpn_reservations;
1039:
1040:
1041: -- ER 7307189 changes start

Line 1264: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

Line 1267: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

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

Line 1271: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

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

Line 1272: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);

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

Line 1274: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);

1270:
1271: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
1272: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1273: END IF;
1274: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
1275:
1276: END transfer_reserved_lpn_contents;
1277:
1278: -- ER 7307189 changes end