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
358: BEGIN
359: IF l_trace_on = 1 THEN
360: print_debug(
361: 'The input parameters are: '
362: || fnd_global.local_chr(10)
363: || ' p_item : '
364: || p_item
365: || fnd_global.local_chr(10)
366: || ', p_organization_id: '
361: 'The input parameters are: '
362: || fnd_global.local_chr(10)
363: || ' p_item : '
364: || p_item
365: || fnd_global.local_chr(10)
366: || ', p_organization_id: '
367: || p_organization_id
368: || fnd_global.local_chr(10)
369: || ', p_subinventory: '
364: || p_item
365: || fnd_global.local_chr(10)
366: || ', p_organization_id: '
367: || p_organization_id
368: || fnd_global.local_chr(10)
369: || ', p_subinventory: '
370: || p_subinventory
371: || fnd_global.local_chr(10)
372: || ', p_locator_id : '
367: || p_organization_id
368: || fnd_global.local_chr(10)
369: || ', p_subinventory: '
370: || p_subinventory
371: || fnd_global.local_chr(10)
372: || ', p_locator_id : '
373: || p_locator_id
374: , l_proc
375: , 9
497: BEGIN
498: IF l_trace_on = 1 THEN
499: print_debug(
500: 'The input parameters are: '
501: || fnd_global.local_chr(10)
502: || ' p_count_type : '
503: || p_count_type
504: || fnd_global.local_chr(10)
505: || ', p_qty_tracked : '
500: 'The input parameters are: '
501: || fnd_global.local_chr(10)
502: || ' p_count_type : '
503: || p_count_type
504: || fnd_global.local_chr(10)
505: || ', p_qty_tracked : '
506: || p_qty_tracked
507: || fnd_global.local_chr(10)
508: || ', p_inventory_planning_level : '
503: || p_count_type
504: || fnd_global.local_chr(10)
505: || ', p_qty_tracked : '
506: || p_qty_tracked
507: || fnd_global.local_chr(10)
508: || ', p_inventory_planning_level : '
509: || p_inventory_planning_level
510: || fnd_global.local_chr(10)
511: || ', p_par_level : '
506: || p_qty_tracked
507: || fnd_global.local_chr(10)
508: || ', p_inventory_planning_level : '
509: || p_inventory_planning_level
510: || fnd_global.local_chr(10)
511: || ', p_par_level : '
512: || p_par_level
513: , l_proc
514: , 9