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: l_append varchar2(2):='';
359:
360: --bug11683825,support the GTIN cross reference value
361: g_gtin_cross_ref_type VARCHAR2(25) := fnd_profile.value('INV:GTIN_CROSS_REFERENCE_TYPE');

Line 361: g_gtin_cross_ref_type VARCHAR2(25) := fnd_profile.value('INV:GTIN_CROSS_REFERENCE_TYPE');

357: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);
358: l_append varchar2(2):='';
359:
360: --bug11683825,support the GTIN cross reference value
361: g_gtin_cross_ref_type VARCHAR2(25) := fnd_profile.value('INV:GTIN_CROSS_REFERENCE_TYPE');
362: g_gtin_code_length NUMBER := 14;
363: g_crossref VARCHAR2(40) := lpad(Rtrim(p_item, '%'), g_gtin_code_length, '00000000000000');
364:
365: BEGIN

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

594: , p_inventory_planning_level IN NUMBER
595: , p_par_level IN NUMBER
596: ) IS
597: l_proc CONSTANT VARCHAR2(30) := 'GET_REPLENISH_COUNT_TYPES_LOV';
598: l_trace_on NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 2);
599: BEGIN
600: IF l_trace_on = 1 THEN
601: print_debug(
602: 'The input parameters are: '