[Home] [Help]
810:
811: -- Initialize return status
812: x_return_status := fnd_api.g_ret_sts_success;
813:
814: -- Standard call to check for call compatibility
815: IF NOT fnd_api.compatible_api_call(l_api_version_number
816: , p_api_version_number
817: , l_api_name
818: , G_PKG_NAME
4761: IF (l_debug = 1) then
4762: debug_print('Inside Query reservations...');
4763: END IF;
4764:
4765: -- Standard call to check for call compatibility
4766: IF NOT fnd_api.compatible_api_call(l_api_version_number, p_api_version_number, l_api_name, g_pkg_name) THEN
4767: RAISE fnd_api.g_exc_unexpected_error;
4768: END IF;
4769:
8163: debug_print('Inside create reservation... ');
8164: END IF;
8165:
8166: --
8167: -- Standard call to check for call compatibility
8168: IF NOT fnd_api.compatible_api_call(l_api_version_number, p_api_version_number, l_api_name, g_pkg_name) THEN
8169: RAISE fnd_api.g_exc_unexpected_error;
8170: END IF;
8171:
9797:
9798: l_reservation_qty_lot NUMBER := 0; --Bug 12978409
9799:
9800: BEGIN
9801: -- Standard call to check for call compatibility
9802: IF NOT fnd_api.compatible_api_call
9803: (l_api_version_number
9804: , p_api_version_number
9805: , l_api_name
10044: debug_print('Inside update reservation...');
10045: END IF;
10046:
10047:
10048: -- Standard call to check for call compatibility
10049: IF NOT fnd_api.compatible_api_call(l_api_version_number, p_api_version_number, l_api_name, g_pkg_name) THEN
10050: RAISE fnd_api.g_exc_unexpected_error;
10051: END IF;
10052:
11846: l_serial_number_table inv_reservation_global.serial_number_tbl_type;
11847: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
11848: /*** End R12 }} ***/
11849: BEGIN
11850: -- Standard call to check for call compatibility
11851: IF NOT fnd_api.compatible_api_call(l_api_version_number, p_api_version_number, l_api_name, g_pkg_name) THEN
11852: RAISE fnd_api.g_exc_unexpected_error;
11853: END IF;
11854:
12637: l_debug := g_debug;
12638: IF (l_debug = 1) THEN
12639: debug_print('Inside delete reservation...');
12640: END IF;
12641: -- Standard call to check for call compatibility
12642: IF NOT fnd_api.compatible_api_call(l_api_version_number, p_api_version_number, l_api_name, g_pkg_name) THEN
12643: RAISE fnd_api.g_exc_unexpected_error;
12644: END IF;
12645:
12982: l_reservation_id NUMBER;
12983: l_reservation_qty_lot NUMBER := 0; --Bug 12978409
12984:
12985: BEGIN
12986: -- Standard call to check for call compatibility
12987: IF NOT fnd_api.compatible_api_call
12988: (l_api_version_number
12989: , p_api_version_number
12990: , l_api_name
13244: IF (l_debug = 1) THEN
13245: debug_print('Inside transfer reservation...');
13246: END IF;
13247:
13248: -- Standard call to check for call compatibility
13249: IF NOT fnd_api.compatible_api_call(l_api_version_number, p_api_version_number, l_api_name, g_pkg_name) THEN
13250: RAISE fnd_api.g_exc_unexpected_error;
13251: END IF;
13252:
17274: BEGIN
17275: x_error_code := inv_reservation_global.g_err_unexpected;
17276:
17277: --
17278: -- Standard call to check for call compatibility
17279: IF NOT fnd_api.compatible_api_call(l_api_version_number, p_api_version_number, l_api_name, g_pkg_name) THEN
17280: RAISE fnd_api.g_exc_unexpected_error;
17281: END IF;
17282:
17745: fnd_msg_pub.ADD;
17746: RAISE FND_API.G_EXC_ERROR;
17747: END IF;
17748:
17749: -- Standard check of p_commit.
17750: IF fnd_api.to_boolean(p_commit) THEN
17751: COMMIT WORK;
17752: END IF;
17753: EXCEPTION
17900: AND wdd2.released_status = 'X'); -- For LPN reuse ER : 6845650
17901:
17902: l_debug number;
17903: BEGIN
17904: -- Standard Start of API savepoint
17905: SAVEPOINT transfer_lpn_trx_reservation;
17906: -- Use cache to get value for l_debug
17907: IF g_is_pickrelease_set IS NULL THEN
17908: g_is_pickrelease_set := 2;