APPS.INV_REPLENISH_COUNT_LOVS dependencies on FND_PROFILE

Line 24: g_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);

20: **/
21: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_REPLENISH_COUNT_LOVS';
22: g_version_printed BOOLEAN := FALSE;
23: g_user_name fnd_user.user_name%TYPE := fnd_global.user_name;
24: g_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);
25:
26: /**
27: * This Procedure is used to print the Debug Messages to log file.
28: * @param p_message Debug Message

Line 61: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);

57: , p_organization_id IN NUMBER
58: , p_subinventory IN VARCHAR2
59: ) IS
60: l_proc CONSTANT VARCHAR2(30) := 'GET_REPLENISH_COUNT_LOV';
61: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);
62: BEGIN
63: IF l_trace_on = 1 THEN
64: print_debug('The input parameters are: '
65: || fnd_global.local_chr(10)

Line 138: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);

134: , p_subinventory IN VARCHAR2
135: , p_organization_id IN NUMBER) IS
136:
137: l_proc CONSTANT VARCHAR2(30) := 'GET_REPLENISH_COUNT_SUBS_LOV';
138: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);
139: BEGIN
140: IF l_trace_on = 1 THEN
141: print_debug(
142: 'The input parameters are: '

Line 210: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);

206: , p_subinventory IN VARCHAR2
207: , p_qty_tracked IN NUMBER
208: ) IS
209: l_proc CONSTANT VARCHAR2(30) := 'GET_REPLENISH_COUNT_LOCS_KFF';
210: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);
211: BEGIN
212: IF l_trace_on = 1 THEN
213: print_debug(
214: 'The input parameters are: '

Line 271: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);

267: , p_qty_tracked IN NUMBER
268: , p_alias IN VARCHAR2
269: ) IS
270: l_proc CONSTANT VARCHAR2(30) := 'GET_REPLENISH_COUNT_LOCS_KFF';
271: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);
272: BEGIN
273:
274: IF p_alias IS NULL THEN
275: get_replenish_count_locs_kff(

Line 357: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);

353: , p_locator_id IN NUMBER
354: , p_qty_tracked IN NUMBER
355: ) IS
356: l_proc CONSTANT VARCHAR2(30) := 'GET_REPLENISH_COUNT_ITEMS_LOV';
357: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);
358: BEGIN
359: IF l_trace_on = 1 THEN
360: print_debug(
361: 'The input parameters are: '

Line 496: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);

492: , p_inventory_planning_level IN NUMBER
493: , p_par_level IN NUMBER
494: ) IS
495: l_proc CONSTANT VARCHAR2(30) := 'GET_REPLENISH_COUNT_TYPES_LOV';
496: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);
497: BEGIN
498: IF l_trace_on = 1 THEN
499: print_debug(
500: 'The input parameters are: '