DBA Data[Home] [Help]

APPS.INV_RESERVATION_PUB dependencies on FND_PROFILE

Line 47: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

43:
44: l_api_version_number CONSTANT NUMBER := 1.0;
45: l_api_name CONSTANT VARCHAR2(30) := 'Create_Reservation';
46: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
47: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
48:
49: l_rsv_rec inv_reservation_global.mtl_reservation_rec_type;
50: l_progress NUMBER;
51: l_secondary_quantity_reserved NUMBER;

Line 218: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

214:
215: l_api_version_number CONSTANT NUMBER := 1.0;
216: l_api_name CONSTANT VARCHAR2(30) := 'Create_Reservation';
217: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
218: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
219:
220: /**** {{ R12 Enhanced reservations code changes }}****/
221: -- l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
222: -- l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type := p_rsv_rec;

Line 630: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

626: l_api_name CONSTANT VARCHAR2(30) := 'Update_Reservation';
627: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
628: l_quantity_reserved NUMBER;
629: l_secondary_quantity_reserved NUMBER;
630: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
631:
632: BEGIN
633: -- Standard call to check for call compatibility
634: IF NOT fnd_api.compatible_api_call(l_api_version_number

Line 757: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

753: l_api_name CONSTANT VARCHAR2(30) := 'Update_Reservation';
754: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
755: l_quantity_reserved NUMBER;
756: l_secondary_quantity_reserved NUMBER; -- INVCONV
757: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
758:
759: BEGIN
760: -- Standard call to check for call compatibility
761: IF NOT fnd_api.compatible_api_call(l_api_version_number

Line 883: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0); -- INVCONV

879: ) IS
880: l_api_version_number CONSTANT NUMBER := 1.0;
881: l_api_name CONSTANT VARCHAR2(30) := 'Relieve_Reservation';
882: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
883: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0); -- INVCONV
884: l_secondary_relieved_quantity NUMBER; -- INVCONV
885: l_secondary_remain_quantity NUMBER; -- INVCONV
886: BEGIN
887: -- Standard call to check for call compatibility