19: * Global constant holding the package name
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.
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)
66: || ' p_replenish_count: '
67: || p_replenish_count
68: || fnd_global.local_chr(10)
69: || ', p_organization_id: '
64: print_debug('The input parameters are: '
65: || fnd_global.local_chr(10)
66: || ' p_replenish_count: '
67: || p_replenish_count
68: || fnd_global.local_chr(10)
69: || ', p_organization_id: '
70: || p_organization_id
71: || ', p_subinventory: '
72: || p_subinventory
69: || ', p_organization_id: '
70: || p_organization_id
71: || ', p_subinventory: '
72: || p_subinventory
73: || fnd_global.local_chr(10)
74: , l_proc
75: , 9
76: );
77: END IF;
139: BEGIN
140: IF l_trace_on = 1 THEN
141: print_debug(
142: 'The input parameters are: '
143: || fnd_global.local_chr(10)
144: || ', p_subinventory: '
145: || p_subinventory
146: || fnd_global.local_chr(10)
147: || ', p_organization_id: '
142: 'The input parameters are: '
143: || fnd_global.local_chr(10)
144: || ', p_subinventory: '
145: || p_subinventory
146: || fnd_global.local_chr(10)
147: || ', p_organization_id: '
148: || p_organization_id
149: , l_proc
150: , 9
211: BEGIN
212: IF l_trace_on = 1 THEN
213: print_debug(
214: 'The input parameters are: '
215: || fnd_global.local_chr(10)
216: || ' p_locator : '
217: || p_locator
218: || fnd_global.local_chr(10)
219: || ', p_replenish_header_id : '
214: 'The input parameters are: '
215: || fnd_global.local_chr(10)
216: || ' p_locator : '
217: || p_locator
218: || fnd_global.local_chr(10)
219: || ', p_replenish_header_id : '
220: || p_replenish_header_id
221: || fnd_global.local_chr(10)
222: || ', p_organization_id : '
217: || p_locator
218: || fnd_global.local_chr(10)
219: || ', p_replenish_header_id : '
220: || p_replenish_header_id
221: || fnd_global.local_chr(10)
222: || ', p_organization_id : '
223: || p_organization_id
224: || fnd_global.local_chr(10)
225: || ', p_subinventory : '
220: || p_replenish_header_id
221: || fnd_global.local_chr(10)
222: || ', p_organization_id : '
223: || p_organization_id
224: || fnd_global.local_chr(10)
225: || ', p_subinventory : '
226: || p_subinventory
227: , l_proc
228: , 9
284: END IF;
285: IF l_trace_on = 1 THEN
286: print_debug(
287: 'The input parameters are: '
288: || fnd_global.local_chr(10)
289: || ' p_locator : '
290: || p_locator
291: || fnd_global.local_chr(10)
292: || ', p_replenish_header_id : '
287: 'The input parameters are: '
288: || fnd_global.local_chr(10)
289: || ' p_locator : '
290: || p_locator
291: || fnd_global.local_chr(10)
292: || ', p_replenish_header_id : '
293: || p_replenish_header_id
294: || fnd_global.local_chr(10)
295: || ', p_organization_id : '
290: || p_locator
291: || fnd_global.local_chr(10)
292: || ', p_replenish_header_id : '
293: || p_replenish_header_id
294: || fnd_global.local_chr(10)
295: || ', p_organization_id : '
296: || p_organization_id
297: || fnd_global.local_chr(10)
298: || ', p_subinventory : '
293: || p_replenish_header_id
294: || fnd_global.local_chr(10)
295: || ', p_organization_id : '
296: || p_organization_id
297: || fnd_global.local_chr(10)
298: || ', p_subinventory : '
299: || p_subinventory
300: || fnd_global.local_chr(10)
301: || ', p_alias : '
296: || p_organization_id
297: || fnd_global.local_chr(10)
298: || ', p_subinventory : '
299: || p_subinventory
300: || fnd_global.local_chr(10)
301: || ', p_alias : '
302: || p_alias
303: , l_proc
304: , 9
366: l_append:=wms_deploy.get_item_suffix_for_lov(p_item);
367: IF l_trace_on = 1 THEN
368: print_debug(
369: 'The input parameters are: '
370: || fnd_global.local_chr(10)
371: || ' p_item : '
372: || p_item
373: || fnd_global.local_chr(10)
374: || ', p_organization_id: '
369: 'The input parameters are: '
370: || fnd_global.local_chr(10)
371: || ' p_item : '
372: || p_item
373: || fnd_global.local_chr(10)
374: || ', p_organization_id: '
375: || p_organization_id
376: || fnd_global.local_chr(10)
377: || ', p_subinventory: '
372: || p_item
373: || fnd_global.local_chr(10)
374: || ', p_organization_id: '
375: || p_organization_id
376: || fnd_global.local_chr(10)
377: || ', p_subinventory: '
378: || p_subinventory
379: || fnd_global.local_chr(10)
380: || ', p_locator_id : '
375: || p_organization_id
376: || fnd_global.local_chr(10)
377: || ', p_subinventory: '
378: || p_subinventory
379: || fnd_global.local_chr(10)
380: || ', p_locator_id : '
381: || p_locator_id
382: , l_proc
383: , 9
599: BEGIN
600: IF l_trace_on = 1 THEN
601: print_debug(
602: 'The input parameters are: '
603: || fnd_global.local_chr(10)
604: || ' p_count_type : '
605: || p_count_type
606: || fnd_global.local_chr(10)
607: || ', p_qty_tracked : '
602: 'The input parameters are: '
603: || fnd_global.local_chr(10)
604: || ' p_count_type : '
605: || p_count_type
606: || fnd_global.local_chr(10)
607: || ', p_qty_tracked : '
608: || p_qty_tracked
609: || fnd_global.local_chr(10)
610: || ', p_inventory_planning_level : '
605: || p_count_type
606: || fnd_global.local_chr(10)
607: || ', p_qty_tracked : '
608: || p_qty_tracked
609: || fnd_global.local_chr(10)
610: || ', p_inventory_planning_level : '
611: || p_inventory_planning_level
612: || fnd_global.local_chr(10)
613: || ', p_par_level : '
608: || p_qty_tracked
609: || fnd_global.local_chr(10)
610: || ', p_inventory_planning_level : '
611: || p_inventory_planning_level
612: || fnd_global.local_chr(10)
613: || ', p_par_level : '
614: || p_par_level
615: , l_proc
616: , 9