APPS.INV_QUANTITY_TREE_PVT dependencies on FND_PROFILE

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

276: -- Added p_level parameter with default as 14
277: PROCEDURE print_debug(p_message IN VARCHAR2, p_level IN NUMBER DEFAULT 14) IS
278: BEGIN
279: IF g_debug IS NULL THEN
280: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
281: END IF;
282:
283: IF (g_debug = 1) THEN
284: inv_log_util.trace(p_message, 'INV_QUANTITY_TREE_PVT', p_level);

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

1430: z_lpn VARCHAR2(200);
1431: BEGIN
1432:
1433: IF g_debug IS NULL THEN
1434: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1435: END IF;
1436:
1437: -- Bug 6332112 : Removed if g_debug and indented the complete procedure
1438: l_reservable := 'Y';

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

1512: -- IF p_tree_id > g_rootinfo_counter THEN
1513: -- RETURN;
1514: -- END IF;
1515: IF g_debug IS NULL THEN
1516: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1517: END IF;
1518:
1519: IF (g_debug = 1) THEN
1520: l_root_id := g_demand_info(p_tree_id).root_id;

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

2155: RAISE fnd_api.g_exc_error;
2156: END IF;
2157:
2158: IF g_lock_timeout IS NULL THEN
2159: g_lock_timeout := nvl(to_number(fnd_profile.value('INV_QTY_TREE_TIMEOUT')),dbms_lock.maxwait);
2160: END IF;
2161: --get lock handle by calling helper function
2162: l_lock_handle := get_lock_handle(
2163: p_organization_id => p_organization_id

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

10303: -- invConv changes end
10304:
10305: BEGIN
10306: IF g_debug IS NULL THEN
10307: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
10308: END IF;
10309:
10310: IF g_debug = 1 THEN
10311: print_debug(l_api_name || ' Entered',9);

Line 10349: -- INV_QUANTITY_TREE_PVT.g_is_mat_status_used := NVL(FND_PROFILE.VALUE('INV_MATERIAL_STATUS'), 2);

10345: -- material status usage :
10346: -- INV_MATERIAL_STATUS == 1 == YES
10347: -- INV_MATERIAL_STATUS == 2 == NO
10348:
10349: -- INV_QUANTITY_TREE_PVT.g_is_mat_status_used := NVL(FND_PROFILE.VALUE('INV_MATERIAL_STATUS'), 2);
10350: -- invConv changes end.
10351: --END IF;
10352: /* Jalaj Srivastava Bug 5590287
10353: set the value of global var g_is_mat_status_used only if it is null */

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

10351: --END IF;
10352: /* Jalaj Srivastava Bug 5590287
10353: set the value of global var g_is_mat_status_used only if it is null */
10354: IF INV_QUANTITY_TREE_PVT.g_is_mat_status_used IS NULL THEN
10355: INV_QUANTITY_TREE_PVT.g_is_mat_status_used := NVL(FND_PROFILE.VALUE('INV_MATERIAL_STATUS'), 2);
10356: END IF;
10357:
10358: if (p_is_revision_control = TRUE)
10359: THEN

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

10385:
10386: g_is_pickrelease := nvl(inv_cache.is_pickrelease,FALSE);
10387:
10388: IF g_debug IS NULL THEN
10389: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
10390: END IF;
10391:
10392: g_empty_root_index := NULL;
10393: g_hash_string := NULL;