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 236: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);

232:
233: l_api_version_number CONSTANT NUMBER := 1.0;
234: l_api_name CONSTANT VARCHAR2(30) := 'Create_Reservation';
235: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
236: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
237:
238: /**** {{ R12 Enhanced reservations code changes }}****/
239: -- l_mtl_reservation_tbl inv_reservation_global.mtl_reservation_tbl_type;
240: -- l_from_rsv_rec inv_reservation_global.mtl_reservation_rec_type := p_rsv_rec;

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

644: l_api_name CONSTANT VARCHAR2(30) := 'Update_Reservation';
645: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
646: l_quantity_reserved NUMBER;
647: l_secondary_quantity_reserved NUMBER;
648: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
649:
650: BEGIN
651: -- Standard call to check for call compatibility
652: IF NOT fnd_api.compatible_api_call(l_api_version_number

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

771: l_api_name CONSTANT VARCHAR2(30) := 'Update_Reservation';
772: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
773: l_quantity_reserved NUMBER;
774: l_secondary_quantity_reserved NUMBER; -- INVCONV
775: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
776:
777: BEGIN
778: -- Standard call to check for call compatibility
779: IF NOT fnd_api.compatible_api_call(l_api_version_number

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

897: ) IS
898: l_api_version_number CONSTANT NUMBER := 1.0;
899: l_api_name CONSTANT VARCHAR2(30) := 'Relieve_Reservation';
900: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
901: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0); -- INVCONV
902: l_secondary_relieved_quantity NUMBER; -- INVCONV
903: l_secondary_remain_quantity NUMBER; -- INVCONV
904: BEGIN
905: -- Standard call to check for call compatibility