eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_REPLENISH_COUNT_PVT dependencies on FND_GLOBAL

Line 24: g_user_name fnd_user.user_name%TYPE := fnd_global.user_name;

20: * Globals constant holding the package name.
21: **/
22: g_pkg_name CONSTANT VARCHAR2(30) := 'INV_REPLENISH_COUNT_PVT';
23: g_version_printed BOOLEAN := FALSE;
24: g_user_name fnd_user.user_name%TYPE := fnd_global.user_name;
25:
26: /**
27: * This Procedure is used to print the Debug Messages to log file.
28: * @param p_message Debug Message

Line 84: || fnd_global.local_chr(10)

80:
81: IF l_trace_on = 1 THEN
82: print_debug(
83: 'The input parameters are: '
84: || fnd_global.local_chr(10)
85: || ' p_organization_id : '
86: || p_organization_id
87: || fnd_global.local_chr(10)
88: || ' p_replenish_header_id : '

Line 87: || fnd_global.local_chr(10)

83: 'The input parameters are: '
84: || fnd_global.local_chr(10)
85: || ' p_organization_id : '
86: || p_organization_id
87: || fnd_global.local_chr(10)
88: || ' p_replenish_header_id : '
89: || p_replenish_header_id
90: || fnd_global.local_chr(10)
91: || ' p_locator_id : '

Line 90: || fnd_global.local_chr(10)

86: || p_organization_id
87: || fnd_global.local_chr(10)
88: || ' p_replenish_header_id : '
89: || p_replenish_header_id
90: || fnd_global.local_chr(10)
91: || ' p_locator_id : '
92: || p_locator_id
93: || fnd_global.local_chr(10)
94: || ' p_item_id : '

Line 93: || fnd_global.local_chr(10)

89: || p_replenish_header_id
90: || fnd_global.local_chr(10)
91: || ' p_locator_id : '
92: || p_locator_id
93: || fnd_global.local_chr(10)
94: || ' p_item_id : '
95: || p_item_id
96: || fnd_global.local_chr(10)
97: || ' p_count_type_code : '

Line 96: || fnd_global.local_chr(10)

92: || p_locator_id
93: || fnd_global.local_chr(10)
94: || ' p_item_id : '
95: || p_item_id
96: || fnd_global.local_chr(10)
97: || ' p_count_type_code : '
98: || p_count_type_code
99: || fnd_global.local_chr(10)
100: || ' p_count_quantity : '

Line 99: || fnd_global.local_chr(10)

95: || p_item_id
96: || fnd_global.local_chr(10)
97: || ' p_count_type_code : '
98: || p_count_type_code
99: || fnd_global.local_chr(10)
100: || ' p_count_quantity : '
101: || p_count_quantity
102: || fnd_global.local_chr(10)
103: || ' p_count_uom_code : '

Line 102: || fnd_global.local_chr(10)

98: || p_count_type_code
99: || fnd_global.local_chr(10)
100: || ' p_count_quantity : '
101: || p_count_quantity
102: || fnd_global.local_chr(10)
103: || ' p_count_uom_code : '
104: || p_count_uom_code
105: || fnd_global.local_chr(10)
106: || ' p_primary_uom_code : '

Line 105: || fnd_global.local_chr(10)

101: || p_count_quantity
102: || fnd_global.local_chr(10)
103: || ' p_count_uom_code : '
104: || p_count_uom_code
105: || fnd_global.local_chr(10)
106: || ' p_primary_uom_code : '
107: || p_primary_uom_code
108: || fnd_global.local_chr(10)
109: , l_proc

Line 108: || fnd_global.local_chr(10)

104: || p_count_uom_code
105: || fnd_global.local_chr(10)
106: || ' p_primary_uom_code : '
107: || p_primary_uom_code
108: || fnd_global.local_chr(10)
109: , l_proc
110: , 9
111: );
112: END IF;

Line 152: , fnd_global.user_id

148: mtl_replenish_lines_s.NEXTVAL
149: , p_replenish_header_id
150: , p_organization_id
151: , SYSDATE
152: , fnd_global.user_id
153: , SYSDATE
154: , fnd_global.user_id
155: , fnd_global.login_id
156: , p_locator_id

Line 154: , fnd_global.user_id

150: , p_organization_id
151: , SYSDATE
152: , fnd_global.user_id
153: , SYSDATE
154: , fnd_global.user_id
155: , fnd_global.login_id
156: , p_locator_id
157: , p_item_id
158: , p_count_type_code

Line 155: , fnd_global.login_id

151: , SYSDATE
152: , fnd_global.user_id
153: , SYSDATE
154: , fnd_global.user_id
155: , fnd_global.login_id
156: , p_locator_id
157: , p_item_id
158: , p_count_type_code
159: , p_count_quantity

Line 219: || fnd_global.local_chr(10)

215:
216: IF l_trace_on = 1 THEN
217: print_debug(
218: 'The input parameters are: '
219: || fnd_global.local_chr(10)
220: || ' p_replenish_header_id : '
221: || p_replenish_header_id
222: || fnd_global.local_chr(10)
223: || ' p_replenish_line_id : '

Line 222: || fnd_global.local_chr(10)

218: 'The input parameters are: '
219: || fnd_global.local_chr(10)
220: || ' p_replenish_header_id : '
221: || p_replenish_header_id
222: || fnd_global.local_chr(10)
223: || ' p_replenish_line_id : '
224: || p_replenish_line_id
225: || fnd_global.local_chr(10)
226: || ' p_count_quantity : '

Line 225: || fnd_global.local_chr(10)

221: || p_replenish_header_id
222: || fnd_global.local_chr(10)
223: || ' p_replenish_line_id : '
224: || p_replenish_line_id
225: || fnd_global.local_chr(10)
226: || ' p_count_quantity : '
227: || p_count_quantity
228: || fnd_global.local_chr(10)
229: || ' p_count_uom_code : '

Line 228: || fnd_global.local_chr(10)

224: || p_replenish_line_id
225: || fnd_global.local_chr(10)
226: || ' p_count_quantity : '
227: || p_count_quantity
228: || fnd_global.local_chr(10)
229: || ' p_count_uom_code : '
230: || p_count_uom_code
231: || fnd_global.local_chr(10)
232: , l_proc

Line 231: || fnd_global.local_chr(10)

227: || p_count_quantity
228: || fnd_global.local_chr(10)
229: || ' p_count_uom_code : '
230: || p_count_uom_code
231: || fnd_global.local_chr(10)
232: , l_proc
233: , 9
234: );
235: END IF;

Line 240: , last_updated_by = fnd_global.user_id

236:
237: -- Convert the count quantity into the item primary uom quantity.
238: UPDATE mtl_replenish_lines
239: SET last_update_date = SYSDATE
240: , last_updated_by = fnd_global.user_id
241: , last_update_login = fnd_global.login_id
242: , count_quantity = p_count_quantity
243: , count_uom_code = p_count_uom_code
244: , primary_uom_count_quantity =

Line 241: , last_update_login = fnd_global.login_id

237: -- Convert the count quantity into the item primary uom quantity.
238: UPDATE mtl_replenish_lines
239: SET last_update_date = SYSDATE
240: , last_updated_by = fnd_global.user_id
241: , last_update_login = fnd_global.login_id
242: , count_quantity = p_count_quantity
243: , count_uom_code = p_count_uom_code
244: , primary_uom_count_quantity =
245: inv_convert.inv_um_convert(p_item_id, 6, p_count_quantity, p_count_uom_code, primary_uom_code, NULL, NULL)

Line 293: || fnd_global.local_chr(10)

289:
290: IF l_trace_on = 1 THEN
291: print_debug(
292: 'The input parameters are: '
293: || fnd_global.local_chr(10)
294: || ' p_replenish_header_id : '
295: || p_replenish_header_id
296: || fnd_global.local_chr(10)
297: || ' p_use_loc_pick_seq : '

Line 296: || fnd_global.local_chr(10)

292: 'The input parameters are: '
293: || fnd_global.local_chr(10)
294: || ' p_replenish_header_id : '
295: || p_replenish_header_id
296: || fnd_global.local_chr(10)
297: || ' p_use_loc_pick_seq : '
298: || p_use_loc_pick_seq
299: || fnd_global.local_chr(10)
300: || ' p_organization_id : '

Line 299: || fnd_global.local_chr(10)

295: || p_replenish_header_id
296: || fnd_global.local_chr(10)
297: || ' p_use_loc_pick_seq : '
298: || p_use_loc_pick_seq
299: || fnd_global.local_chr(10)
300: || ' p_organization_id : '
301: || p_organization_id
302: || fnd_global.local_chr(10)
303: || ' p_subinventory_code : '

Line 302: || fnd_global.local_chr(10)

298: || p_use_loc_pick_seq
299: || fnd_global.local_chr(10)
300: || ' p_organization_id : '
301: || p_organization_id
302: || fnd_global.local_chr(10)
303: || ' p_subinventory_code : '
304: || p_subinventory_code
305: || fnd_global.local_chr(10)
306: || ' p_planning_level : '

Line 305: || fnd_global.local_chr(10)

301: || p_organization_id
302: || fnd_global.local_chr(10)
303: || ' p_subinventory_code : '
304: || p_subinventory_code
305: || fnd_global.local_chr(10)
306: || ' p_planning_level : '
307: || p_planning_level
308: || fnd_global.local_chr(10)
309: || ' p_quantity_tracked : '

Line 308: || fnd_global.local_chr(10)

304: || p_subinventory_code
305: || fnd_global.local_chr(10)
306: || ' p_planning_level : '
307: || p_planning_level
308: || fnd_global.local_chr(10)
309: || ' p_quantity_tracked : '
310: || p_quantity_tracked
311: || fnd_global.local_chr(10)
312: , l_proc

Line 311: || fnd_global.local_chr(10)

307: || p_planning_level
308: || fnd_global.local_chr(10)
309: || ' p_quantity_tracked : '
310: || p_quantity_tracked
311: || fnd_global.local_chr(10)
312: , l_proc
313: , 9
314: );
315: END IF;

Line 424: || fnd_global.local_chr(10)

420:
421: IF l_trace_on = 1 THEN
422: print_debug(
423: 'The input parameters are: '
424: || fnd_global.local_chr(10)
425: || ' p_organization_id : '
426: || p_organization_id
427: || fnd_global.local_chr(10)
428: || ' p_subinventory_code : '

Line 427: || fnd_global.local_chr(10)

423: 'The input parameters are: '
424: || fnd_global.local_chr(10)
425: || ' p_organization_id : '
426: || p_organization_id
427: || fnd_global.local_chr(10)
428: || ' p_subinventory_code : '
429: || p_subinventory_code
430: || fnd_global.local_chr(10)
431: || ' p_planning_level : '

Line 430: || fnd_global.local_chr(10)

426: || p_organization_id
427: || fnd_global.local_chr(10)
428: || ' p_subinventory_code : '
429: || p_subinventory_code
430: || fnd_global.local_chr(10)
431: || ' p_planning_level : '
432: || p_planning_level
433: , l_func_name
434: , 9

Line 506: || fnd_global.local_chr(10)

502:
503: IF l_trace_on = 1 THEN
504: print_debug(
505: 'The input parameters are: '
506: || fnd_global.local_chr(10)
507: || ' p_replenish_header_id : '
508: || p_replenish_header_id
509: || fnd_global.local_chr(10)
510: || ' p_quantity_tracked : '

Line 509: || fnd_global.local_chr(10)

505: 'The input parameters are: '
506: || fnd_global.local_chr(10)
507: || ' p_replenish_header_id : '
508: || p_replenish_header_id
509: || fnd_global.local_chr(10)
510: || ' p_quantity_tracked : '
511: || p_quantity_tracked
512: || fnd_global.local_chr(10)
513: || ' p_planning_level : '

Line 512: || fnd_global.local_chr(10)

508: || p_replenish_header_id
509: || fnd_global.local_chr(10)
510: || ' p_quantity_tracked : '
511: || p_quantity_tracked
512: || fnd_global.local_chr(10)
513: || ' p_planning_level : '
514: || p_planning_level
515: || fnd_global.local_chr(10)
516: || ' p_subinventory_code : '

Line 515: || fnd_global.local_chr(10)

511: || p_quantity_tracked
512: || fnd_global.local_chr(10)
513: || ' p_planning_level : '
514: || p_planning_level
515: || fnd_global.local_chr(10)
516: || ' p_subinventory_code : '
517: || p_subinventory_code
518: || fnd_global.local_chr(10)
519: , l_func_name

Line 518: || fnd_global.local_chr(10)

514: || p_planning_level
515: || fnd_global.local_chr(10)
516: || ' p_subinventory_code : '
517: || p_subinventory_code
518: || fnd_global.local_chr(10)
519: , l_func_name
520: , 9
521: );
522: END IF;

Line 676: || fnd_global.local_chr(10)

672:
673: IF l_trace_on = 1 THEN
674: print_debug(
675: 'The input parameters are: '
676: || fnd_global.local_chr(10)
677: || ' p_replenish_header_id : '
678: || p_replenish_header_id
679: || fnd_global.local_chr(10)
680: || ' p_planning_level : '

Line 679: || fnd_global.local_chr(10)

675: 'The input parameters are: '
676: || fnd_global.local_chr(10)
677: || ' p_replenish_header_id : '
678: || p_replenish_header_id
679: || fnd_global.local_chr(10)
680: || ' p_planning_level : '
681: || p_planning_level
682: || fnd_global.local_chr(10)
683: , l_func_name

Line 682: || fnd_global.local_chr(10)

678: || p_replenish_header_id
679: || fnd_global.local_chr(10)
680: || ' p_planning_level : '
681: || p_planning_level
682: || fnd_global.local_chr(10)
683: , l_func_name
684: , 9
685: );
686: END IF;

Line 733: || fnd_global.local_chr(10)

729:
730: IF l_trace_on = 1 THEN
731: print_debug(
732: 'The input parameters are: '
733: || fnd_global.local_chr(10)
734: || ' p_replenish_header_id : '
735: || p_replenish_header_id
736: || fnd_global.local_chr(10)
737: || ' p_organization_id : '

Line 736: || fnd_global.local_chr(10)

732: 'The input parameters are: '
733: || fnd_global.local_chr(10)
734: || ' p_replenish_header_id : '
735: || p_replenish_header_id
736: || fnd_global.local_chr(10)
737: || ' p_organization_id : '
738: || p_organization_id
739: || fnd_global.local_chr(10)
740: , l_proc

Line 739: || fnd_global.local_chr(10)

735: || p_replenish_header_id
736: || fnd_global.local_chr(10)
737: || ' p_organization_id : '
738: || p_organization_id
739: || fnd_global.local_chr(10)
740: , l_proc
741: , 9
742: );
743: END IF;