APPS.INV_QUANTITY_TREE_PVT dependencies on FND_PROFILE

Line 331: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

327: -- Added p_level parameter with default as 14
328: PROCEDURE print_debug(p_message IN VARCHAR2, p_level IN NUMBER DEFAULT 14) IS
329: BEGIN
330: IF g_debug IS NULL THEN
331: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
332: END IF;
333:
334: IF (g_debug = 1) THEN
335: inv_log_util.trace(p_message, 'INV_QUANTITY_TREE_PVT', p_level);

Line 464: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

460: z_lpn VARCHAR2(200);
461: BEGIN
462:
463: IF g_debug IS NULL THEN
464: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
465: END IF;
466:
467: -- Bug 6332112 : Removed if g_debug and indented the complete procedure
468: l_reservable := 'Y';

Line 546: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

542: -- IF p_tree_id > g_rootinfo_counter THEN
543: -- RETURN;
544: -- END IF;
545: IF g_debug IS NULL THEN
546: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
547: END IF;
548:
549: IF (g_debug = 1) THEN
550: l_root_id := g_demand_info(p_tree_id).root_id;

Line 1904: g_lock_timeout := nvl(to_number(fnd_profile.value('INV_QTY_TREE_TIMEOUT')),dbms_lock.maxwait);

1900: RAISE fnd_api.g_exc_error;
1901: END IF;
1902:
1903: IF g_lock_timeout IS NULL THEN
1904: g_lock_timeout := nvl(to_number(fnd_profile.value('INV_QTY_TREE_TIMEOUT')),dbms_lock.maxwait);
1905: END IF;
1906: --get lock handle by calling helper function
1907: l_lock_handle := get_lock_handle(
1908: p_organization_id => p_organization_id

Line 10848: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);

10844: AND organization_id = org_id;
10845:
10846: BEGIN
10847: IF g_debug IS NULL THEN
10848: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
10849: END IF;
10850:
10851: IF g_is_mat_status_used IS NULL THEN
10852: g_is_mat_status_used := NVL(FND_PROFILE.VALUE('INV_MATERIAL_STATUS'), 2);

Line 10852: g_is_mat_status_used := NVL(FND_PROFILE.VALUE('INV_MATERIAL_STATUS'), 2);

10848: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
10849: END IF;
10850:
10851: IF g_is_mat_status_used IS NULL THEN
10852: g_is_mat_status_used := NVL(FND_PROFILE.VALUE('INV_MATERIAL_STATUS'), 2);
10853: END IF;
10854:
10855: IF g_debug = 1 THEN
10856: print_debug(l_api_name || ' Entered',9);