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_MMX_WRAPPER_PVT dependencies on FND_GLOBAL

Line 18: G_USER_NAME fnd_user.user_name%TYPE := FND_GLOBAL.USER_NAME;

14: --
15: -- Find the user name, INV debug profile setting
16: --
17:
18: G_USER_NAME fnd_user.user_name%TYPE := FND_GLOBAL.USER_NAME;
19: G_TRACE_ON NUMBER := NVL(fnd_profile.value('INV_DEBUG_TRACE'),2);
20:
21:
22: PROCEDURE print_debug

Line 286: print_debug('Starting Min-max planning with the following parameters: ' || fnd_global.local_chr(10)||

282: SAVEPOINT sp_exec_min_max;
283: x_return_status := FND_API.G_RET_STS_SUCCESS;
284:
285: IF G_TRACE_ON = 1 THEN
286: print_debug('Starting Min-max planning with the following parameters: ' || fnd_global.local_chr(10)||
287: ' p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10)||
288: ', p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10)
289: , l_proc
290: , 9);

Line 287: ' p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10)||

283: x_return_status := FND_API.G_RET_STS_SUCCESS;
284:
285: IF G_TRACE_ON = 1 THEN
286: print_debug('Starting Min-max planning with the following parameters: ' || fnd_global.local_chr(10)||
287: ' p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10)||
288: ', p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10)
289: , l_proc
290: , 9);
291:

Line 288: ', p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10)

284:
285: IF G_TRACE_ON = 1 THEN
286: print_debug('Starting Min-max planning with the following parameters: ' || fnd_global.local_chr(10)||
287: ' p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10)||
288: ', p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10)
289: , l_proc
290: , 9);
291:
292: FOR i in 1..p_subinv_tbl.count

Line 295: print_debug(', p_subinv('|| i ||'): ' || p_subinv_tbl(i) || fnd_global.local_chr(10)

291:
292: FOR i in 1..p_subinv_tbl.count
293: LOOP
294:
295: print_debug(', p_subinv('|| i ||'): ' || p_subinv_tbl(i) || fnd_global.local_chr(10)
296: , l_proc
297: , 9);
298: END LOOP;
299:

Line 300: print_debug('Parameters contd..: ' || fnd_global.local_chr(10)||

296: , l_proc
297: , 9);
298: END LOOP;
299:
300: print_debug('Parameters contd..: ' || fnd_global.local_chr(10)||
301: ' p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10)||
302: ', p_gen_report:' || p_gen_report || fnd_global.local_chr(10)||
303: ', p_mo_line_grouping:' || p_mo_line_grouping || fnd_global.local_chr(10)||
304: ', p_item_select: ' || p_item_select || fnd_global.local_chr(10)||

Line 301: ' p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10)||

297: , 9);
298: END LOOP;
299:
300: print_debug('Parameters contd..: ' || fnd_global.local_chr(10)||
301: ' p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10)||
302: ', p_gen_report:' || p_gen_report || fnd_global.local_chr(10)||
303: ', p_mo_line_grouping:' || p_mo_line_grouping || fnd_global.local_chr(10)||
304: ', p_item_select: ' || p_item_select || fnd_global.local_chr(10)||
305: ', p_handle_rep_item: ' || to_char(p_handle_rep_item) || fnd_global.local_chr(10)||

Line 302: ', p_gen_report:' || p_gen_report || fnd_global.local_chr(10)||

298: END LOOP;
299:
300: print_debug('Parameters contd..: ' || fnd_global.local_chr(10)||
301: ' p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10)||
302: ', p_gen_report:' || p_gen_report || fnd_global.local_chr(10)||
303: ', p_mo_line_grouping:' || p_mo_line_grouping || fnd_global.local_chr(10)||
304: ', p_item_select: ' || p_item_select || fnd_global.local_chr(10)||
305: ', p_handle_rep_item: ' || to_char(p_handle_rep_item) || fnd_global.local_chr(10)||
306: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10)||

Line 303: ', p_mo_line_grouping:' || p_mo_line_grouping || fnd_global.local_chr(10)||

299:
300: print_debug('Parameters contd..: ' || fnd_global.local_chr(10)||
301: ' p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10)||
302: ', p_gen_report:' || p_gen_report || fnd_global.local_chr(10)||
303: ', p_mo_line_grouping:' || p_mo_line_grouping || fnd_global.local_chr(10)||
304: ', p_item_select: ' || p_item_select || fnd_global.local_chr(10)||
305: ', p_handle_rep_item: ' || to_char(p_handle_rep_item) || fnd_global.local_chr(10)||
306: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10)||
307: ', p_cat_select: ' || p_cat_select || fnd_global.local_chr(10)||

Line 304: ', p_item_select: ' || p_item_select || fnd_global.local_chr(10)||

300: print_debug('Parameters contd..: ' || fnd_global.local_chr(10)||
301: ' p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10)||
302: ', p_gen_report:' || p_gen_report || fnd_global.local_chr(10)||
303: ', p_mo_line_grouping:' || p_mo_line_grouping || fnd_global.local_chr(10)||
304: ', p_item_select: ' || p_item_select || fnd_global.local_chr(10)||
305: ', p_handle_rep_item: ' || to_char(p_handle_rep_item) || fnd_global.local_chr(10)||
306: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10)||
307: ', p_cat_select: ' || p_cat_select || fnd_global.local_chr(10)||
308: ', p_cat_set_id: ' || to_char(p_cat_set_id) || fnd_global.local_chr(10)||

Line 305: ', p_handle_rep_item: ' || to_char(p_handle_rep_item) || fnd_global.local_chr(10)||

301: ' p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10)||
302: ', p_gen_report:' || p_gen_report || fnd_global.local_chr(10)||
303: ', p_mo_line_grouping:' || p_mo_line_grouping || fnd_global.local_chr(10)||
304: ', p_item_select: ' || p_item_select || fnd_global.local_chr(10)||
305: ', p_handle_rep_item: ' || to_char(p_handle_rep_item) || fnd_global.local_chr(10)||
306: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10)||
307: ', p_cat_select: ' || p_cat_select || fnd_global.local_chr(10)||
308: ', p_cat_set_id: ' || to_char(p_cat_set_id) || fnd_global.local_chr(10)||
309: ', p_mcat_struct: ' || to_char(p_mcat_struct) || fnd_global.local_chr(10)||

Line 306: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10)||

302: ', p_gen_report:' || p_gen_report || fnd_global.local_chr(10)||
303: ', p_mo_line_grouping:' || p_mo_line_grouping || fnd_global.local_chr(10)||
304: ', p_item_select: ' || p_item_select || fnd_global.local_chr(10)||
305: ', p_handle_rep_item: ' || to_char(p_handle_rep_item) || fnd_global.local_chr(10)||
306: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10)||
307: ', p_cat_select: ' || p_cat_select || fnd_global.local_chr(10)||
308: ', p_cat_set_id: ' || to_char(p_cat_set_id) || fnd_global.local_chr(10)||
309: ', p_mcat_struct: ' || to_char(p_mcat_struct) || fnd_global.local_chr(10)||
310: ', p_level: ' || to_char(p_level) || fnd_global.local_chr(10)||

Line 307: ', p_cat_select: ' || p_cat_select || fnd_global.local_chr(10)||

303: ', p_mo_line_grouping:' || p_mo_line_grouping || fnd_global.local_chr(10)||
304: ', p_item_select: ' || p_item_select || fnd_global.local_chr(10)||
305: ', p_handle_rep_item: ' || to_char(p_handle_rep_item) || fnd_global.local_chr(10)||
306: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10)||
307: ', p_cat_select: ' || p_cat_select || fnd_global.local_chr(10)||
308: ', p_cat_set_id: ' || to_char(p_cat_set_id) || fnd_global.local_chr(10)||
309: ', p_mcat_struct: ' || to_char(p_mcat_struct) || fnd_global.local_chr(10)||
310: ', p_level: ' || to_char(p_level) || fnd_global.local_chr(10)||
311: ', p_restock: ' || to_char(p_restock) || fnd_global.local_chr(10)||

Line 308: ', p_cat_set_id: ' || to_char(p_cat_set_id) || fnd_global.local_chr(10)||

304: ', p_item_select: ' || p_item_select || fnd_global.local_chr(10)||
305: ', p_handle_rep_item: ' || to_char(p_handle_rep_item) || fnd_global.local_chr(10)||
306: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10)||
307: ', p_cat_select: ' || p_cat_select || fnd_global.local_chr(10)||
308: ', p_cat_set_id: ' || to_char(p_cat_set_id) || fnd_global.local_chr(10)||
309: ', p_mcat_struct: ' || to_char(p_mcat_struct) || fnd_global.local_chr(10)||
310: ', p_level: ' || to_char(p_level) || fnd_global.local_chr(10)||
311: ', p_restock: ' || to_char(p_restock) || fnd_global.local_chr(10)||
312: ', p_include_nonnet: ' || to_char(p_include_nonnet) || fnd_global.local_chr(10)||

Line 309: ', p_mcat_struct: ' || to_char(p_mcat_struct) || fnd_global.local_chr(10)||

305: ', p_handle_rep_item: ' || to_char(p_handle_rep_item) || fnd_global.local_chr(10)||
306: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10)||
307: ', p_cat_select: ' || p_cat_select || fnd_global.local_chr(10)||
308: ', p_cat_set_id: ' || to_char(p_cat_set_id) || fnd_global.local_chr(10)||
309: ', p_mcat_struct: ' || to_char(p_mcat_struct) || fnd_global.local_chr(10)||
310: ', p_level: ' || to_char(p_level) || fnd_global.local_chr(10)||
311: ', p_restock: ' || to_char(p_restock) || fnd_global.local_chr(10)||
312: ', p_include_nonnet: ' || to_char(p_include_nonnet) || fnd_global.local_chr(10)||
313: ', p_include_po: ' || to_char(p_include_po) || fnd_global.local_chr(10)||

Line 310: ', p_level: ' || to_char(p_level) || fnd_global.local_chr(10)||

306: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10)||
307: ', p_cat_select: ' || p_cat_select || fnd_global.local_chr(10)||
308: ', p_cat_set_id: ' || to_char(p_cat_set_id) || fnd_global.local_chr(10)||
309: ', p_mcat_struct: ' || to_char(p_mcat_struct) || fnd_global.local_chr(10)||
310: ', p_level: ' || to_char(p_level) || fnd_global.local_chr(10)||
311: ', p_restock: ' || to_char(p_restock) || fnd_global.local_chr(10)||
312: ', p_include_nonnet: ' || to_char(p_include_nonnet) || fnd_global.local_chr(10)||
313: ', p_include_po: ' || to_char(p_include_po) || fnd_global.local_chr(10)||
314: ', p_include_mo: ' || to_char(p_include_mo) || fnd_global.local_chr(10)||

Line 311: ', p_restock: ' || to_char(p_restock) || fnd_global.local_chr(10)||

307: ', p_cat_select: ' || p_cat_select || fnd_global.local_chr(10)||
308: ', p_cat_set_id: ' || to_char(p_cat_set_id) || fnd_global.local_chr(10)||
309: ', p_mcat_struct: ' || to_char(p_mcat_struct) || fnd_global.local_chr(10)||
310: ', p_level: ' || to_char(p_level) || fnd_global.local_chr(10)||
311: ', p_restock: ' || to_char(p_restock) || fnd_global.local_chr(10)||
312: ', p_include_nonnet: ' || to_char(p_include_nonnet) || fnd_global.local_chr(10)||
313: ', p_include_po: ' || to_char(p_include_po) || fnd_global.local_chr(10)||
314: ', p_include_mo: ' || to_char(p_include_mo) || fnd_global.local_chr(10)||
315: ', p_include_wip: ' || to_char(p_include_wip) || fnd_global.local_chr(10)||

Line 312: ', p_include_nonnet: ' || to_char(p_include_nonnet) || fnd_global.local_chr(10)||

308: ', p_cat_set_id: ' || to_char(p_cat_set_id) || fnd_global.local_chr(10)||
309: ', p_mcat_struct: ' || to_char(p_mcat_struct) || fnd_global.local_chr(10)||
310: ', p_level: ' || to_char(p_level) || fnd_global.local_chr(10)||
311: ', p_restock: ' || to_char(p_restock) || fnd_global.local_chr(10)||
312: ', p_include_nonnet: ' || to_char(p_include_nonnet) || fnd_global.local_chr(10)||
313: ', p_include_po: ' || to_char(p_include_po) || fnd_global.local_chr(10)||
314: ', p_include_mo: ' || to_char(p_include_mo) || fnd_global.local_chr(10)||
315: ', p_include_wip: ' || to_char(p_include_wip) || fnd_global.local_chr(10)||
316: ', p_include_if: ' || to_char(p_include_if) || fnd_global.local_chr(10)

Line 313: ', p_include_po: ' || to_char(p_include_po) || fnd_global.local_chr(10)||

309: ', p_mcat_struct: ' || to_char(p_mcat_struct) || fnd_global.local_chr(10)||
310: ', p_level: ' || to_char(p_level) || fnd_global.local_chr(10)||
311: ', p_restock: ' || to_char(p_restock) || fnd_global.local_chr(10)||
312: ', p_include_nonnet: ' || to_char(p_include_nonnet) || fnd_global.local_chr(10)||
313: ', p_include_po: ' || to_char(p_include_po) || fnd_global.local_chr(10)||
314: ', p_include_mo: ' || to_char(p_include_mo) || fnd_global.local_chr(10)||
315: ', p_include_wip: ' || to_char(p_include_wip) || fnd_global.local_chr(10)||
316: ', p_include_if: ' || to_char(p_include_if) || fnd_global.local_chr(10)
317: , l_proc

Line 314: ', p_include_mo: ' || to_char(p_include_mo) || fnd_global.local_chr(10)||

310: ', p_level: ' || to_char(p_level) || fnd_global.local_chr(10)||
311: ', p_restock: ' || to_char(p_restock) || fnd_global.local_chr(10)||
312: ', p_include_nonnet: ' || to_char(p_include_nonnet) || fnd_global.local_chr(10)||
313: ', p_include_po: ' || to_char(p_include_po) || fnd_global.local_chr(10)||
314: ', p_include_mo: ' || to_char(p_include_mo) || fnd_global.local_chr(10)||
315: ', p_include_wip: ' || to_char(p_include_wip) || fnd_global.local_chr(10)||
316: ', p_include_if: ' || to_char(p_include_if) || fnd_global.local_chr(10)
317: , l_proc
318: , 9);

Line 315: ', p_include_wip: ' || to_char(p_include_wip) || fnd_global.local_chr(10)||

311: ', p_restock: ' || to_char(p_restock) || fnd_global.local_chr(10)||
312: ', p_include_nonnet: ' || to_char(p_include_nonnet) || fnd_global.local_chr(10)||
313: ', p_include_po: ' || to_char(p_include_po) || fnd_global.local_chr(10)||
314: ', p_include_mo: ' || to_char(p_include_mo) || fnd_global.local_chr(10)||
315: ', p_include_wip: ' || to_char(p_include_wip) || fnd_global.local_chr(10)||
316: ', p_include_if: ' || to_char(p_include_if) || fnd_global.local_chr(10)
317: , l_proc
318: , 9);
319:

Line 316: ', p_include_if: ' || to_char(p_include_if) || fnd_global.local_chr(10)

312: ', p_include_nonnet: ' || to_char(p_include_nonnet) || fnd_global.local_chr(10)||
313: ', p_include_po: ' || to_char(p_include_po) || fnd_global.local_chr(10)||
314: ', p_include_mo: ' || to_char(p_include_mo) || fnd_global.local_chr(10)||
315: ', p_include_wip: ' || to_char(p_include_wip) || fnd_global.local_chr(10)||
316: ', p_include_if: ' || to_char(p_include_if) || fnd_global.local_chr(10)
317: , l_proc
318: , 9);
319:
320: print_debug('Parameters contd..: ' || fnd_global.local_chr(10)||

Line 320: print_debug('Parameters contd..: ' || fnd_global.local_chr(10)||

316: ', p_include_if: ' || to_char(p_include_if) || fnd_global.local_chr(10)
317: , l_proc
318: , 9);
319:
320: print_debug('Parameters contd..: ' || fnd_global.local_chr(10)||
321: ' p_net_rsv: ' || to_char(p_net_rsv) || fnd_global.local_chr(10)||
322: ', p_net_unrsv: ' || to_char(p_net_unrsv) || fnd_global.local_chr(10)||
323: ', p_net_wip: ' || to_char(p_net_wip) || fnd_global.local_chr(10)||
324: ', p_dd_loc_id: ' || to_char(p_dd_loc_id) || fnd_global.local_chr(10)||

Line 321: ' p_net_rsv: ' || to_char(p_net_rsv) || fnd_global.local_chr(10)||

317: , l_proc
318: , 9);
319:
320: print_debug('Parameters contd..: ' || fnd_global.local_chr(10)||
321: ' p_net_rsv: ' || to_char(p_net_rsv) || fnd_global.local_chr(10)||
322: ', p_net_unrsv: ' || to_char(p_net_unrsv) || fnd_global.local_chr(10)||
323: ', p_net_wip: ' || to_char(p_net_wip) || fnd_global.local_chr(10)||
324: ', p_dd_loc_id: ' || to_char(p_dd_loc_id) || fnd_global.local_chr(10)||
325: ', p_buyer_hi: ' || p_buyer_hi || fnd_global.local_chr(10)||

Line 322: ', p_net_unrsv: ' || to_char(p_net_unrsv) || fnd_global.local_chr(10)||

318: , 9);
319:
320: print_debug('Parameters contd..: ' || fnd_global.local_chr(10)||
321: ' p_net_rsv: ' || to_char(p_net_rsv) || fnd_global.local_chr(10)||
322: ', p_net_unrsv: ' || to_char(p_net_unrsv) || fnd_global.local_chr(10)||
323: ', p_net_wip: ' || to_char(p_net_wip) || fnd_global.local_chr(10)||
324: ', p_dd_loc_id: ' || to_char(p_dd_loc_id) || fnd_global.local_chr(10)||
325: ', p_buyer_hi: ' || p_buyer_hi || fnd_global.local_chr(10)||
326: ', p_buyer_lo: ' || p_buyer_lo || fnd_global.local_chr(10)||

Line 323: ', p_net_wip: ' || to_char(p_net_wip) || fnd_global.local_chr(10)||

319:
320: print_debug('Parameters contd..: ' || fnd_global.local_chr(10)||
321: ' p_net_rsv: ' || to_char(p_net_rsv) || fnd_global.local_chr(10)||
322: ', p_net_unrsv: ' || to_char(p_net_unrsv) || fnd_global.local_chr(10)||
323: ', p_net_wip: ' || to_char(p_net_wip) || fnd_global.local_chr(10)||
324: ', p_dd_loc_id: ' || to_char(p_dd_loc_id) || fnd_global.local_chr(10)||
325: ', p_buyer_hi: ' || p_buyer_hi || fnd_global.local_chr(10)||
326: ', p_buyer_lo: ' || p_buyer_lo || fnd_global.local_chr(10)||
327: ', p_range_buyer: ' || p_range_buyer || fnd_global.local_chr(10)||

Line 324: ', p_dd_loc_id: ' || to_char(p_dd_loc_id) || fnd_global.local_chr(10)||

320: print_debug('Parameters contd..: ' || fnd_global.local_chr(10)||
321: ' p_net_rsv: ' || to_char(p_net_rsv) || fnd_global.local_chr(10)||
322: ', p_net_unrsv: ' || to_char(p_net_unrsv) || fnd_global.local_chr(10)||
323: ', p_net_wip: ' || to_char(p_net_wip) || fnd_global.local_chr(10)||
324: ', p_dd_loc_id: ' || to_char(p_dd_loc_id) || fnd_global.local_chr(10)||
325: ', p_buyer_hi: ' || p_buyer_hi || fnd_global.local_chr(10)||
326: ', p_buyer_lo: ' || p_buyer_lo || fnd_global.local_chr(10)||
327: ', p_range_buyer: ' || p_range_buyer || fnd_global.local_chr(10)||
328: ', p_range_sql: ' || p_range_sql || fnd_global.local_chr(10)||

Line 325: ', p_buyer_hi: ' || p_buyer_hi || fnd_global.local_chr(10)||

321: ' p_net_rsv: ' || to_char(p_net_rsv) || fnd_global.local_chr(10)||
322: ', p_net_unrsv: ' || to_char(p_net_unrsv) || fnd_global.local_chr(10)||
323: ', p_net_wip: ' || to_char(p_net_wip) || fnd_global.local_chr(10)||
324: ', p_dd_loc_id: ' || to_char(p_dd_loc_id) || fnd_global.local_chr(10)||
325: ', p_buyer_hi: ' || p_buyer_hi || fnd_global.local_chr(10)||
326: ', p_buyer_lo: ' || p_buyer_lo || fnd_global.local_chr(10)||
327: ', p_range_buyer: ' || p_range_buyer || fnd_global.local_chr(10)||
328: ', p_range_sql: ' || p_range_sql || fnd_global.local_chr(10)||
329: ', p_sort: ' || p_sort || fnd_global.local_chr(10)||

Line 326: ', p_buyer_lo: ' || p_buyer_lo || fnd_global.local_chr(10)||

322: ', p_net_unrsv: ' || to_char(p_net_unrsv) || fnd_global.local_chr(10)||
323: ', p_net_wip: ' || to_char(p_net_wip) || fnd_global.local_chr(10)||
324: ', p_dd_loc_id: ' || to_char(p_dd_loc_id) || fnd_global.local_chr(10)||
325: ', p_buyer_hi: ' || p_buyer_hi || fnd_global.local_chr(10)||
326: ', p_buyer_lo: ' || p_buyer_lo || fnd_global.local_chr(10)||
327: ', p_range_buyer: ' || p_range_buyer || fnd_global.local_chr(10)||
328: ', p_range_sql: ' || p_range_sql || fnd_global.local_chr(10)||
329: ', p_sort: ' || p_sort || fnd_global.local_chr(10)||
330: ', p_selection: ' || to_char(p_selection) || fnd_global.local_chr(10)||

Line 327: ', p_range_buyer: ' || p_range_buyer || fnd_global.local_chr(10)||

323: ', p_net_wip: ' || to_char(p_net_wip) || fnd_global.local_chr(10)||
324: ', p_dd_loc_id: ' || to_char(p_dd_loc_id) || fnd_global.local_chr(10)||
325: ', p_buyer_hi: ' || p_buyer_hi || fnd_global.local_chr(10)||
326: ', p_buyer_lo: ' || p_buyer_lo || fnd_global.local_chr(10)||
327: ', p_range_buyer: ' || p_range_buyer || fnd_global.local_chr(10)||
328: ', p_range_sql: ' || p_range_sql || fnd_global.local_chr(10)||
329: ', p_sort: ' || p_sort || fnd_global.local_chr(10)||
330: ', p_selection: ' || to_char(p_selection) || fnd_global.local_chr(10)||
331: ', p_sysdate: ' || to_char(p_sysdate, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10)||

Line 328: ', p_range_sql: ' || p_range_sql || fnd_global.local_chr(10)||

324: ', p_dd_loc_id: ' || to_char(p_dd_loc_id) || fnd_global.local_chr(10)||
325: ', p_buyer_hi: ' || p_buyer_hi || fnd_global.local_chr(10)||
326: ', p_buyer_lo: ' || p_buyer_lo || fnd_global.local_chr(10)||
327: ', p_range_buyer: ' || p_range_buyer || fnd_global.local_chr(10)||
328: ', p_range_sql: ' || p_range_sql || fnd_global.local_chr(10)||
329: ', p_sort: ' || p_sort || fnd_global.local_chr(10)||
330: ', p_selection: ' || to_char(p_selection) || fnd_global.local_chr(10)||
331: ', p_sysdate: ' || to_char(p_sysdate, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10)||
332: ', p_s_cutoff: ' || to_char(p_s_cutoff, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10)||

Line 329: ', p_sort: ' || p_sort || fnd_global.local_chr(10)||

325: ', p_buyer_hi: ' || p_buyer_hi || fnd_global.local_chr(10)||
326: ', p_buyer_lo: ' || p_buyer_lo || fnd_global.local_chr(10)||
327: ', p_range_buyer: ' || p_range_buyer || fnd_global.local_chr(10)||
328: ', p_range_sql: ' || p_range_sql || fnd_global.local_chr(10)||
329: ', p_sort: ' || p_sort || fnd_global.local_chr(10)||
330: ', p_selection: ' || to_char(p_selection) || fnd_global.local_chr(10)||
331: ', p_sysdate: ' || to_char(p_sysdate, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10)||
332: ', p_s_cutoff: ' || to_char(p_s_cutoff, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10)||
333: ', p_s_cutoff: ' || to_char(p_s_cutoff, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10)||

Line 330: ', p_selection: ' || to_char(p_selection) || fnd_global.local_chr(10)||

326: ', p_buyer_lo: ' || p_buyer_lo || fnd_global.local_chr(10)||
327: ', p_range_buyer: ' || p_range_buyer || fnd_global.local_chr(10)||
328: ', p_range_sql: ' || p_range_sql || fnd_global.local_chr(10)||
329: ', p_sort: ' || p_sort || fnd_global.local_chr(10)||
330: ', p_selection: ' || to_char(p_selection) || fnd_global.local_chr(10)||
331: ', p_sysdate: ' || to_char(p_sysdate, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10)||
332: ', p_s_cutoff: ' || to_char(p_s_cutoff, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10)||
333: ', p_s_cutoff: ' || to_char(p_s_cutoff, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10)||
334: ', p_d_cutoff: ' || to_char(p_d_cutoff, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10)

Line 331: ', p_sysdate: ' || to_char(p_sysdate, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10)||

327: ', p_range_buyer: ' || p_range_buyer || fnd_global.local_chr(10)||
328: ', p_range_sql: ' || p_range_sql || fnd_global.local_chr(10)||
329: ', p_sort: ' || p_sort || fnd_global.local_chr(10)||
330: ', p_selection: ' || to_char(p_selection) || fnd_global.local_chr(10)||
331: ', p_sysdate: ' || to_char(p_sysdate, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10)||
332: ', p_s_cutoff: ' || to_char(p_s_cutoff, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10)||
333: ', p_s_cutoff: ' || to_char(p_s_cutoff, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10)||
334: ', p_d_cutoff: ' || to_char(p_d_cutoff, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10)
335: , l_proc

Line 332: ', p_s_cutoff: ' || to_char(p_s_cutoff, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10)||

328: ', p_range_sql: ' || p_range_sql || fnd_global.local_chr(10)||
329: ', p_sort: ' || p_sort || fnd_global.local_chr(10)||
330: ', p_selection: ' || to_char(p_selection) || fnd_global.local_chr(10)||
331: ', p_sysdate: ' || to_char(p_sysdate, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10)||
332: ', p_s_cutoff: ' || to_char(p_s_cutoff, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10)||
333: ', p_s_cutoff: ' || to_char(p_s_cutoff, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10)||
334: ', p_d_cutoff: ' || to_char(p_d_cutoff, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10)
335: , l_proc
336: , 9);

Line 333: ', p_s_cutoff: ' || to_char(p_s_cutoff, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10)||

329: ', p_sort: ' || p_sort || fnd_global.local_chr(10)||
330: ', p_selection: ' || to_char(p_selection) || fnd_global.local_chr(10)||
331: ', p_sysdate: ' || to_char(p_sysdate, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10)||
332: ', p_s_cutoff: ' || to_char(p_s_cutoff, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10)||
333: ', p_s_cutoff: ' || to_char(p_s_cutoff, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10)||
334: ', p_d_cutoff: ' || to_char(p_d_cutoff, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10)
335: , l_proc
336: , 9);
337: END IF;

Line 334: ', p_d_cutoff: ' || to_char(p_d_cutoff, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10)

330: ', p_selection: ' || to_char(p_selection) || fnd_global.local_chr(10)||
331: ', p_sysdate: ' || to_char(p_sysdate, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10)||
332: ', p_s_cutoff: ' || to_char(p_s_cutoff, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10)||
333: ', p_s_cutoff: ' || to_char(p_s_cutoff, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10)||
334: ', p_d_cutoff: ' || to_char(p_d_cutoff, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10)
335: , l_proc
336: , 9);
337: END IF;
338:

Line 1222: print_debug ('Executing do_restock with the following parameters: ' || fnd_global.local_chr(10) ||

1218: G_CURRENT_MO_HDR_ID := NULL;
1219: G_CURRENT_MO_LINE_NUM := NULL;
1220:
1221: IF G_TRACE_ON = 1 THEN
1222: print_debug ('Executing do_restock with the following parameters: ' || fnd_global.local_chr(10) ||
1223: ' p_item_id ' || to_char(p_item_id) || fnd_global.local_chr(10) ||
1224: ', p_mbf: ' || to_char(p_mbf) || fnd_global.local_chr(10) ||
1225: ', p_handle_repetitive_item: ' || to_char(p_handle_repetitive_item) || fnd_global.local_chr(10) ||
1226: ', p_repetitive_planned_item: ' || p_repetitive_planned_item || fnd_global.local_chr(10) ||

Line 1223: ' p_item_id ' || to_char(p_item_id) || fnd_global.local_chr(10) ||

1219: G_CURRENT_MO_LINE_NUM := NULL;
1220:
1221: IF G_TRACE_ON = 1 THEN
1222: print_debug ('Executing do_restock with the following parameters: ' || fnd_global.local_chr(10) ||
1223: ' p_item_id ' || to_char(p_item_id) || fnd_global.local_chr(10) ||
1224: ', p_mbf: ' || to_char(p_mbf) || fnd_global.local_chr(10) ||
1225: ', p_handle_repetitive_item: ' || to_char(p_handle_repetitive_item) || fnd_global.local_chr(10) ||
1226: ', p_repetitive_planned_item: ' || p_repetitive_planned_item || fnd_global.local_chr(10) ||
1227: ', p_qty: ' || to_char(p_qty) || fnd_global.local_chr(10) ||

Line 1224: ', p_mbf: ' || to_char(p_mbf) || fnd_global.local_chr(10) ||

1220:
1221: IF G_TRACE_ON = 1 THEN
1222: print_debug ('Executing do_restock with the following parameters: ' || fnd_global.local_chr(10) ||
1223: ' p_item_id ' || to_char(p_item_id) || fnd_global.local_chr(10) ||
1224: ', p_mbf: ' || to_char(p_mbf) || fnd_global.local_chr(10) ||
1225: ', p_handle_repetitive_item: ' || to_char(p_handle_repetitive_item) || fnd_global.local_chr(10) ||
1226: ', p_repetitive_planned_item: ' || p_repetitive_planned_item || fnd_global.local_chr(10) ||
1227: ', p_qty: ' || to_char(p_qty) || fnd_global.local_chr(10) ||
1228: ', p_fixed_lead_time: ' || to_char(p_fixed_lead_time) || fnd_global.local_chr(10) ||

Line 1225: ', p_handle_repetitive_item: ' || to_char(p_handle_repetitive_item) || fnd_global.local_chr(10) ||

1221: IF G_TRACE_ON = 1 THEN
1222: print_debug ('Executing do_restock with the following parameters: ' || fnd_global.local_chr(10) ||
1223: ' p_item_id ' || to_char(p_item_id) || fnd_global.local_chr(10) ||
1224: ', p_mbf: ' || to_char(p_mbf) || fnd_global.local_chr(10) ||
1225: ', p_handle_repetitive_item: ' || to_char(p_handle_repetitive_item) || fnd_global.local_chr(10) ||
1226: ', p_repetitive_planned_item: ' || p_repetitive_planned_item || fnd_global.local_chr(10) ||
1227: ', p_qty: ' || to_char(p_qty) || fnd_global.local_chr(10) ||
1228: ', p_fixed_lead_time: ' || to_char(p_fixed_lead_time) || fnd_global.local_chr(10) ||
1229: ', p_variable_lead_time: ' || to_char(p_variable_lead_time) || fnd_global.local_chr(10) ||

Line 1226: ', p_repetitive_planned_item: ' || p_repetitive_planned_item || fnd_global.local_chr(10) ||

1222: print_debug ('Executing do_restock with the following parameters: ' || fnd_global.local_chr(10) ||
1223: ' p_item_id ' || to_char(p_item_id) || fnd_global.local_chr(10) ||
1224: ', p_mbf: ' || to_char(p_mbf) || fnd_global.local_chr(10) ||
1225: ', p_handle_repetitive_item: ' || to_char(p_handle_repetitive_item) || fnd_global.local_chr(10) ||
1226: ', p_repetitive_planned_item: ' || p_repetitive_planned_item || fnd_global.local_chr(10) ||
1227: ', p_qty: ' || to_char(p_qty) || fnd_global.local_chr(10) ||
1228: ', p_fixed_lead_time: ' || to_char(p_fixed_lead_time) || fnd_global.local_chr(10) ||
1229: ', p_variable_lead_time: ' || to_char(p_variable_lead_time) || fnd_global.local_chr(10) ||
1230: ', p_buying_lead_time: ' || to_char(p_buying_lead_time) || fnd_global.local_chr(10) ||

Line 1227: ', p_qty: ' || to_char(p_qty) || fnd_global.local_chr(10) ||

1223: ' p_item_id ' || to_char(p_item_id) || fnd_global.local_chr(10) ||
1224: ', p_mbf: ' || to_char(p_mbf) || fnd_global.local_chr(10) ||
1225: ', p_handle_repetitive_item: ' || to_char(p_handle_repetitive_item) || fnd_global.local_chr(10) ||
1226: ', p_repetitive_planned_item: ' || p_repetitive_planned_item || fnd_global.local_chr(10) ||
1227: ', p_qty: ' || to_char(p_qty) || fnd_global.local_chr(10) ||
1228: ', p_fixed_lead_time: ' || to_char(p_fixed_lead_time) || fnd_global.local_chr(10) ||
1229: ', p_variable_lead_time: ' || to_char(p_variable_lead_time) || fnd_global.local_chr(10) ||
1230: ', p_buying_lead_time: ' || to_char(p_buying_lead_time) || fnd_global.local_chr(10) ||
1231: ', p_uom: ' || p_uom || fnd_global.local_chr(10) ||

Line 1228: ', p_fixed_lead_time: ' || to_char(p_fixed_lead_time) || fnd_global.local_chr(10) ||

1224: ', p_mbf: ' || to_char(p_mbf) || fnd_global.local_chr(10) ||
1225: ', p_handle_repetitive_item: ' || to_char(p_handle_repetitive_item) || fnd_global.local_chr(10) ||
1226: ', p_repetitive_planned_item: ' || p_repetitive_planned_item || fnd_global.local_chr(10) ||
1227: ', p_qty: ' || to_char(p_qty) || fnd_global.local_chr(10) ||
1228: ', p_fixed_lead_time: ' || to_char(p_fixed_lead_time) || fnd_global.local_chr(10) ||
1229: ', p_variable_lead_time: ' || to_char(p_variable_lead_time) || fnd_global.local_chr(10) ||
1230: ', p_buying_lead_time: ' || to_char(p_buying_lead_time) || fnd_global.local_chr(10) ||
1231: ', p_uom: ' || p_uom || fnd_global.local_chr(10) ||
1232: ', p_accru_acct: ' || to_char(p_accru_acct) || fnd_global.local_chr(10) ||

Line 1229: ', p_variable_lead_time: ' || to_char(p_variable_lead_time) || fnd_global.local_chr(10) ||

1225: ', p_handle_repetitive_item: ' || to_char(p_handle_repetitive_item) || fnd_global.local_chr(10) ||
1226: ', p_repetitive_planned_item: ' || p_repetitive_planned_item || fnd_global.local_chr(10) ||
1227: ', p_qty: ' || to_char(p_qty) || fnd_global.local_chr(10) ||
1228: ', p_fixed_lead_time: ' || to_char(p_fixed_lead_time) || fnd_global.local_chr(10) ||
1229: ', p_variable_lead_time: ' || to_char(p_variable_lead_time) || fnd_global.local_chr(10) ||
1230: ', p_buying_lead_time: ' || to_char(p_buying_lead_time) || fnd_global.local_chr(10) ||
1231: ', p_uom: ' || p_uom || fnd_global.local_chr(10) ||
1232: ', p_accru_acct: ' || to_char(p_accru_acct) || fnd_global.local_chr(10) ||
1233: ', p_ipv_acct: ' || to_char(p_ipv_acct) || fnd_global.local_chr(10) ||

Line 1230: ', p_buying_lead_time: ' || to_char(p_buying_lead_time) || fnd_global.local_chr(10) ||

1226: ', p_repetitive_planned_item: ' || p_repetitive_planned_item || fnd_global.local_chr(10) ||
1227: ', p_qty: ' || to_char(p_qty) || fnd_global.local_chr(10) ||
1228: ', p_fixed_lead_time: ' || to_char(p_fixed_lead_time) || fnd_global.local_chr(10) ||
1229: ', p_variable_lead_time: ' || to_char(p_variable_lead_time) || fnd_global.local_chr(10) ||
1230: ', p_buying_lead_time: ' || to_char(p_buying_lead_time) || fnd_global.local_chr(10) ||
1231: ', p_uom: ' || p_uom || fnd_global.local_chr(10) ||
1232: ', p_accru_acct: ' || to_char(p_accru_acct) || fnd_global.local_chr(10) ||
1233: ', p_ipv_acct: ' || to_char(p_ipv_acct) || fnd_global.local_chr(10) ||
1234: ', p_budget_acct: ' || to_char(p_budget_acct) || fnd_global.local_chr(10)

Line 1231: ', p_uom: ' || p_uom || fnd_global.local_chr(10) ||

1227: ', p_qty: ' || to_char(p_qty) || fnd_global.local_chr(10) ||
1228: ', p_fixed_lead_time: ' || to_char(p_fixed_lead_time) || fnd_global.local_chr(10) ||
1229: ', p_variable_lead_time: ' || to_char(p_variable_lead_time) || fnd_global.local_chr(10) ||
1230: ', p_buying_lead_time: ' || to_char(p_buying_lead_time) || fnd_global.local_chr(10) ||
1231: ', p_uom: ' || p_uom || fnd_global.local_chr(10) ||
1232: ', p_accru_acct: ' || to_char(p_accru_acct) || fnd_global.local_chr(10) ||
1233: ', p_ipv_acct: ' || to_char(p_ipv_acct) || fnd_global.local_chr(10) ||
1234: ', p_budget_acct: ' || to_char(p_budget_acct) || fnd_global.local_chr(10)
1235: , l_proc_name

Line 1232: ', p_accru_acct: ' || to_char(p_accru_acct) || fnd_global.local_chr(10) ||

1228: ', p_fixed_lead_time: ' || to_char(p_fixed_lead_time) || fnd_global.local_chr(10) ||
1229: ', p_variable_lead_time: ' || to_char(p_variable_lead_time) || fnd_global.local_chr(10) ||
1230: ', p_buying_lead_time: ' || to_char(p_buying_lead_time) || fnd_global.local_chr(10) ||
1231: ', p_uom: ' || p_uom || fnd_global.local_chr(10) ||
1232: ', p_accru_acct: ' || to_char(p_accru_acct) || fnd_global.local_chr(10) ||
1233: ', p_ipv_acct: ' || to_char(p_ipv_acct) || fnd_global.local_chr(10) ||
1234: ', p_budget_acct: ' || to_char(p_budget_acct) || fnd_global.local_chr(10)
1235: , l_proc_name
1236: , 9);

Line 1233: ', p_ipv_acct: ' || to_char(p_ipv_acct) || fnd_global.local_chr(10) ||

1229: ', p_variable_lead_time: ' || to_char(p_variable_lead_time) || fnd_global.local_chr(10) ||
1230: ', p_buying_lead_time: ' || to_char(p_buying_lead_time) || fnd_global.local_chr(10) ||
1231: ', p_uom: ' || p_uom || fnd_global.local_chr(10) ||
1232: ', p_accru_acct: ' || to_char(p_accru_acct) || fnd_global.local_chr(10) ||
1233: ', p_ipv_acct: ' || to_char(p_ipv_acct) || fnd_global.local_chr(10) ||
1234: ', p_budget_acct: ' || to_char(p_budget_acct) || fnd_global.local_chr(10)
1235: , l_proc_name
1236: , 9);
1237:

Line 1234: ', p_budget_acct: ' || to_char(p_budget_acct) || fnd_global.local_chr(10)

1230: ', p_buying_lead_time: ' || to_char(p_buying_lead_time) || fnd_global.local_chr(10) ||
1231: ', p_uom: ' || p_uom || fnd_global.local_chr(10) ||
1232: ', p_accru_acct: ' || to_char(p_accru_acct) || fnd_global.local_chr(10) ||
1233: ', p_ipv_acct: ' || to_char(p_ipv_acct) || fnd_global.local_chr(10) ||
1234: ', p_budget_acct: ' || to_char(p_budget_acct) || fnd_global.local_chr(10)
1235: , l_proc_name
1236: , 9);
1237:
1238: print_debug ('Parameters Contd..' || fnd_global.local_chr(10) ||

Line 1238: print_debug ('Parameters Contd..' || fnd_global.local_chr(10) ||

1234: ', p_budget_acct: ' || to_char(p_budget_acct) || fnd_global.local_chr(10)
1235: , l_proc_name
1236: , 9);
1237:
1238: print_debug ('Parameters Contd..' || fnd_global.local_chr(10) ||
1239: ' p_charge_acct: ' || to_char(p_charge_acct) || fnd_global.local_chr(10) ||
1240: ', p_purch_flag: ' || p_purch_flag || fnd_global.local_chr(10) ||
1241: ', p_order_flag: ' || p_order_flag || fnd_global.local_chr(10) ||
1242: ', p_transact_flag: ' || p_transact_flag || fnd_global.local_chr(10) ||

Line 1239: ' p_charge_acct: ' || to_char(p_charge_acct) || fnd_global.local_chr(10) ||

1235: , l_proc_name
1236: , 9);
1237:
1238: print_debug ('Parameters Contd..' || fnd_global.local_chr(10) ||
1239: ' p_charge_acct: ' || to_char(p_charge_acct) || fnd_global.local_chr(10) ||
1240: ', p_purch_flag: ' || p_purch_flag || fnd_global.local_chr(10) ||
1241: ', p_order_flag: ' || p_order_flag || fnd_global.local_chr(10) ||
1242: ', p_transact_flag: ' || p_transact_flag || fnd_global.local_chr(10) ||
1243: ', p_unit_price: ' || to_char(p_unit_price) || fnd_global.local_chr(10) ||

Line 1240: ', p_purch_flag: ' || p_purch_flag || fnd_global.local_chr(10) ||

1236: , 9);
1237:
1238: print_debug ('Parameters Contd..' || fnd_global.local_chr(10) ||
1239: ' p_charge_acct: ' || to_char(p_charge_acct) || fnd_global.local_chr(10) ||
1240: ', p_purch_flag: ' || p_purch_flag || fnd_global.local_chr(10) ||
1241: ', p_order_flag: ' || p_order_flag || fnd_global.local_chr(10) ||
1242: ', p_transact_flag: ' || p_transact_flag || fnd_global.local_chr(10) ||
1243: ', p_unit_price: ' || to_char(p_unit_price) || fnd_global.local_chr(10) ||
1244: ', p_wip_id: ' || to_char(p_wip_id) || fnd_global.local_chr(10) ||

Line 1241: ', p_order_flag: ' || p_order_flag || fnd_global.local_chr(10) ||

1237:
1238: print_debug ('Parameters Contd..' || fnd_global.local_chr(10) ||
1239: ' p_charge_acct: ' || to_char(p_charge_acct) || fnd_global.local_chr(10) ||
1240: ', p_purch_flag: ' || p_purch_flag || fnd_global.local_chr(10) ||
1241: ', p_order_flag: ' || p_order_flag || fnd_global.local_chr(10) ||
1242: ', p_transact_flag: ' || p_transact_flag || fnd_global.local_chr(10) ||
1243: ', p_unit_price: ' || to_char(p_unit_price) || fnd_global.local_chr(10) ||
1244: ', p_wip_id: ' || to_char(p_wip_id) || fnd_global.local_chr(10) ||
1245: ', p_user_id: ' || to_char(p_user_id) ||

Line 1242: ', p_transact_flag: ' || p_transact_flag || fnd_global.local_chr(10) ||

1238: print_debug ('Parameters Contd..' || fnd_global.local_chr(10) ||
1239: ' p_charge_acct: ' || to_char(p_charge_acct) || fnd_global.local_chr(10) ||
1240: ', p_purch_flag: ' || p_purch_flag || fnd_global.local_chr(10) ||
1241: ', p_order_flag: ' || p_order_flag || fnd_global.local_chr(10) ||
1242: ', p_transact_flag: ' || p_transact_flag || fnd_global.local_chr(10) ||
1243: ', p_unit_price: ' || to_char(p_unit_price) || fnd_global.local_chr(10) ||
1244: ', p_wip_id: ' || to_char(p_wip_id) || fnd_global.local_chr(10) ||
1245: ', p_user_id: ' || to_char(p_user_id) ||
1246: ', p_sysd: ' || to_char(p_sysd, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10) ||

Line 1243: ', p_unit_price: ' || to_char(p_unit_price) || fnd_global.local_chr(10) ||

1239: ' p_charge_acct: ' || to_char(p_charge_acct) || fnd_global.local_chr(10) ||
1240: ', p_purch_flag: ' || p_purch_flag || fnd_global.local_chr(10) ||
1241: ', p_order_flag: ' || p_order_flag || fnd_global.local_chr(10) ||
1242: ', p_transact_flag: ' || p_transact_flag || fnd_global.local_chr(10) ||
1243: ', p_unit_price: ' || to_char(p_unit_price) || fnd_global.local_chr(10) ||
1244: ', p_wip_id: ' || to_char(p_wip_id) || fnd_global.local_chr(10) ||
1245: ', p_user_id: ' || to_char(p_user_id) ||
1246: ', p_sysd: ' || to_char(p_sysd, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10) ||
1247: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||

Line 1244: ', p_wip_id: ' || to_char(p_wip_id) || fnd_global.local_chr(10) ||

1240: ', p_purch_flag: ' || p_purch_flag || fnd_global.local_chr(10) ||
1241: ', p_order_flag: ' || p_order_flag || fnd_global.local_chr(10) ||
1242: ', p_transact_flag: ' || p_transact_flag || fnd_global.local_chr(10) ||
1243: ', p_unit_price: ' || to_char(p_unit_price) || fnd_global.local_chr(10) ||
1244: ', p_wip_id: ' || to_char(p_wip_id) || fnd_global.local_chr(10) ||
1245: ', p_user_id: ' || to_char(p_user_id) ||
1246: ', p_sysd: ' || to_char(p_sysd, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10) ||
1247: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
1248: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||

Line 1246: ', p_sysd: ' || to_char(p_sysd, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10) ||

1242: ', p_transact_flag: ' || p_transact_flag || fnd_global.local_chr(10) ||
1243: ', p_unit_price: ' || to_char(p_unit_price) || fnd_global.local_chr(10) ||
1244: ', p_wip_id: ' || to_char(p_wip_id) || fnd_global.local_chr(10) ||
1245: ', p_user_id: ' || to_char(p_user_id) ||
1246: ', p_sysd: ' || to_char(p_sysd, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10) ||
1247: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
1248: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||
1249: ', p_build_in_wip: ' || p_build_in_wip || fnd_global.local_chr(10) ||
1250: ', p_pick_components: ' || p_pick_components || fnd_global.local_chr(10) ||

Line 1247: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||

1243: ', p_unit_price: ' || to_char(p_unit_price) || fnd_global.local_chr(10) ||
1244: ', p_wip_id: ' || to_char(p_wip_id) || fnd_global.local_chr(10) ||
1245: ', p_user_id: ' || to_char(p_user_id) ||
1246: ', p_sysd: ' || to_char(p_sysd, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10) ||
1247: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
1248: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||
1249: ', p_build_in_wip: ' || p_build_in_wip || fnd_global.local_chr(10) ||
1250: ', p_pick_components: ' || p_pick_components || fnd_global.local_chr(10) ||
1251: ', p_src_type: ' || to_char(p_src_type) || fnd_global.local_chr(10)

Line 1248: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||

1244: ', p_wip_id: ' || to_char(p_wip_id) || fnd_global.local_chr(10) ||
1245: ', p_user_id: ' || to_char(p_user_id) ||
1246: ', p_sysd: ' || to_char(p_sysd, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10) ||
1247: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
1248: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||
1249: ', p_build_in_wip: ' || p_build_in_wip || fnd_global.local_chr(10) ||
1250: ', p_pick_components: ' || p_pick_components || fnd_global.local_chr(10) ||
1251: ', p_src_type: ' || to_char(p_src_type) || fnd_global.local_chr(10)
1252: , l_proc_name

Line 1249: ', p_build_in_wip: ' || p_build_in_wip || fnd_global.local_chr(10) ||

1245: ', p_user_id: ' || to_char(p_user_id) ||
1246: ', p_sysd: ' || to_char(p_sysd, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10) ||
1247: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
1248: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||
1249: ', p_build_in_wip: ' || p_build_in_wip || fnd_global.local_chr(10) ||
1250: ', p_pick_components: ' || p_pick_components || fnd_global.local_chr(10) ||
1251: ', p_src_type: ' || to_char(p_src_type) || fnd_global.local_chr(10)
1252: , l_proc_name
1253: , 9);

Line 1250: ', p_pick_components: ' || p_pick_components || fnd_global.local_chr(10) ||

1246: ', p_sysd: ' || to_char(p_sysd, 'DD-MON-YYYY HH24:MI:SS') || fnd_global.local_chr(10) ||
1247: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
1248: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||
1249: ', p_build_in_wip: ' || p_build_in_wip || fnd_global.local_chr(10) ||
1250: ', p_pick_components: ' || p_pick_components || fnd_global.local_chr(10) ||
1251: ', p_src_type: ' || to_char(p_src_type) || fnd_global.local_chr(10)
1252: , l_proc_name
1253: , 9);
1254:

Line 1251: ', p_src_type: ' || to_char(p_src_type) || fnd_global.local_chr(10)

1247: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
1248: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||
1249: ', p_build_in_wip: ' || p_build_in_wip || fnd_global.local_chr(10) ||
1250: ', p_pick_components: ' || p_pick_components || fnd_global.local_chr(10) ||
1251: ', p_src_type: ' || to_char(p_src_type) || fnd_global.local_chr(10)
1252: , l_proc_name
1253: , 9);
1254:
1255: print_debug ('Parameters Contd..' || fnd_global.local_chr(10) ||

Line 1255: print_debug ('Parameters Contd..' || fnd_global.local_chr(10) ||

1251: ', p_src_type: ' || to_char(p_src_type) || fnd_global.local_chr(10)
1252: , l_proc_name
1253: , 9);
1254:
1255: print_debug ('Parameters Contd..' || fnd_global.local_chr(10) ||
1256: ' p_encum_flag: ' || p_encum_flag || fnd_global.local_chr(10) ||
1257: ', p_customer_id: ' || to_char(p_customer_id) || fnd_global.local_chr(10) ||
1258: ', p_customer_site_id: ' || to_char(p_customer_site_id) || fnd_global.local_chr(10) ||
1259: ', p_cal_code: ' || p_cal_code || fnd_global.local_chr(10) ||

Line 1256: ' p_encum_flag: ' || p_encum_flag || fnd_global.local_chr(10) ||

1252: , l_proc_name
1253: , 9);
1254:
1255: print_debug ('Parameters Contd..' || fnd_global.local_chr(10) ||
1256: ' p_encum_flag: ' || p_encum_flag || fnd_global.local_chr(10) ||
1257: ', p_customer_id: ' || to_char(p_customer_id) || fnd_global.local_chr(10) ||
1258: ', p_customer_site_id: ' || to_char(p_customer_site_id) || fnd_global.local_chr(10) ||
1259: ', p_cal_code: ' || p_cal_code || fnd_global.local_chr(10) ||
1260: ', p_except_id: ' || to_char(p_except_id) || fnd_global.local_chr(10) ||

Line 1257: ', p_customer_id: ' || to_char(p_customer_id) || fnd_global.local_chr(10) ||

1253: , 9);
1254:
1255: print_debug ('Parameters Contd..' || fnd_global.local_chr(10) ||
1256: ' p_encum_flag: ' || p_encum_flag || fnd_global.local_chr(10) ||
1257: ', p_customer_id: ' || to_char(p_customer_id) || fnd_global.local_chr(10) ||
1258: ', p_customer_site_id: ' || to_char(p_customer_site_id) || fnd_global.local_chr(10) ||
1259: ', p_cal_code: ' || p_cal_code || fnd_global.local_chr(10) ||
1260: ', p_except_id: ' || to_char(p_except_id) || fnd_global.local_chr(10) ||
1261: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||

Line 1258: ', p_customer_site_id: ' || to_char(p_customer_site_id) || fnd_global.local_chr(10) ||

1254:
1255: print_debug ('Parameters Contd..' || fnd_global.local_chr(10) ||
1256: ' p_encum_flag: ' || p_encum_flag || fnd_global.local_chr(10) ||
1257: ', p_customer_id: ' || to_char(p_customer_id) || fnd_global.local_chr(10) ||
1258: ', p_customer_site_id: ' || to_char(p_customer_site_id) || fnd_global.local_chr(10) ||
1259: ', p_cal_code: ' || p_cal_code || fnd_global.local_chr(10) ||
1260: ', p_except_id: ' || to_char(p_except_id) || fnd_global.local_chr(10) ||
1261: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||
1262: ', p_description: ' || p_description || fnd_global.local_chr(10) ||

Line 1259: ', p_cal_code: ' || p_cal_code || fnd_global.local_chr(10) ||

1255: print_debug ('Parameters Contd..' || fnd_global.local_chr(10) ||
1256: ' p_encum_flag: ' || p_encum_flag || fnd_global.local_chr(10) ||
1257: ', p_customer_id: ' || to_char(p_customer_id) || fnd_global.local_chr(10) ||
1258: ', p_customer_site_id: ' || to_char(p_customer_site_id) || fnd_global.local_chr(10) ||
1259: ', p_cal_code: ' || p_cal_code || fnd_global.local_chr(10) ||
1260: ', p_except_id: ' || to_char(p_except_id) || fnd_global.local_chr(10) ||
1261: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||
1262: ', p_description: ' || p_description || fnd_global.local_chr(10) ||
1263: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||

Line 1260: ', p_except_id: ' || to_char(p_except_id) || fnd_global.local_chr(10) ||

1256: ' p_encum_flag: ' || p_encum_flag || fnd_global.local_chr(10) ||
1257: ', p_customer_id: ' || to_char(p_customer_id) || fnd_global.local_chr(10) ||
1258: ', p_customer_site_id: ' || to_char(p_customer_site_id) || fnd_global.local_chr(10) ||
1259: ', p_cal_code: ' || p_cal_code || fnd_global.local_chr(10) ||
1260: ', p_except_id: ' || to_char(p_except_id) || fnd_global.local_chr(10) ||
1261: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||
1262: ', p_description: ' || p_description || fnd_global.local_chr(10) ||
1263: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
1264: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||

Line 1261: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||

1257: ', p_customer_id: ' || to_char(p_customer_id) || fnd_global.local_chr(10) ||
1258: ', p_customer_site_id: ' || to_char(p_customer_site_id) || fnd_global.local_chr(10) ||
1259: ', p_cal_code: ' || p_cal_code || fnd_global.local_chr(10) ||
1260: ', p_except_id: ' || to_char(p_except_id) || fnd_global.local_chr(10) ||
1261: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||
1262: ', p_description: ' || p_description || fnd_global.local_chr(10) ||
1263: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
1264: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
1265: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||

Line 1262: ', p_description: ' || p_description || fnd_global.local_chr(10) ||

1258: ', p_customer_site_id: ' || to_char(p_customer_site_id) || fnd_global.local_chr(10) ||
1259: ', p_cal_code: ' || p_cal_code || fnd_global.local_chr(10) ||
1260: ', p_except_id: ' || to_char(p_except_id) || fnd_global.local_chr(10) ||
1261: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||
1262: ', p_description: ' || p_description || fnd_global.local_chr(10) ||
1263: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
1264: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
1265: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
1266: ', p_location_id: ' || to_char(p_location_id) || fnd_global.local_chr(10) ||

Line 1263: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||

1259: ', p_cal_code: ' || p_cal_code || fnd_global.local_chr(10) ||
1260: ', p_except_id: ' || to_char(p_except_id) || fnd_global.local_chr(10) ||
1261: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||
1262: ', p_description: ' || p_description || fnd_global.local_chr(10) ||
1263: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
1264: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
1265: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
1266: ', p_location_id: ' || to_char(p_location_id) || fnd_global.local_chr(10) ||
1267: ', p_po_org_id: ' || to_char(p_po_org_id) || fnd_global.local_chr(10) ||

Line 1264: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||

1260: ', p_except_id: ' || to_char(p_except_id) || fnd_global.local_chr(10) ||
1261: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||
1262: ', p_description: ' || p_description || fnd_global.local_chr(10) ||
1263: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
1264: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
1265: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
1266: ', p_location_id: ' || to_char(p_location_id) || fnd_global.local_chr(10) ||
1267: ', p_po_org_id: ' || to_char(p_po_org_id) || fnd_global.local_chr(10) ||
1268: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10) ||

Line 1265: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||

1261: ', p_employee_id: ' || to_char(p_employee_id) || fnd_global.local_chr(10) ||
1262: ', p_description: ' || p_description || fnd_global.local_chr(10) ||
1263: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
1264: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
1265: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
1266: ', p_location_id: ' || to_char(p_location_id) || fnd_global.local_chr(10) ||
1267: ', p_po_org_id: ' || to_char(p_po_org_id) || fnd_global.local_chr(10) ||
1268: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10) ||
1269: ', p_mo_line_grouping ' || to_char(p_mo_line_grouping) || fnd_global.local_chr(10)

Line 1266: ', p_location_id: ' || to_char(p_location_id) || fnd_global.local_chr(10) ||

1262: ', p_description: ' || p_description || fnd_global.local_chr(10) ||
1263: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
1264: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
1265: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
1266: ', p_location_id: ' || to_char(p_location_id) || fnd_global.local_chr(10) ||
1267: ', p_po_org_id: ' || to_char(p_po_org_id) || fnd_global.local_chr(10) ||
1268: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10) ||
1269: ', p_mo_line_grouping ' || to_char(p_mo_line_grouping) || fnd_global.local_chr(10)
1270: , l_proc_name

Line 1267: ', p_po_org_id: ' || to_char(p_po_org_id) || fnd_global.local_chr(10) ||

1263: ', p_src_org: ' || to_char(p_src_org) || fnd_global.local_chr(10) ||
1264: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
1265: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
1266: ', p_location_id: ' || to_char(p_location_id) || fnd_global.local_chr(10) ||
1267: ', p_po_org_id: ' || to_char(p_po_org_id) || fnd_global.local_chr(10) ||
1268: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10) ||
1269: ', p_mo_line_grouping ' || to_char(p_mo_line_grouping) || fnd_global.local_chr(10)
1270: , l_proc_name
1271: , 9);

Line 1268: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10) ||

1264: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
1265: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
1266: ', p_location_id: ' || to_char(p_location_id) || fnd_global.local_chr(10) ||
1267: ', p_po_org_id: ' || to_char(p_po_org_id) || fnd_global.local_chr(10) ||
1268: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10) ||
1269: ', p_mo_line_grouping ' || to_char(p_mo_line_grouping) || fnd_global.local_chr(10)
1270: , l_proc_name
1271: , 9);
1272: print_debug('Calling INV_Minmax_PVT.do_restock'

Line 1269: ', p_mo_line_grouping ' || to_char(p_mo_line_grouping) || fnd_global.local_chr(10)

1265: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
1266: ', p_location_id: ' || to_char(p_location_id) || fnd_global.local_chr(10) ||
1267: ', p_po_org_id: ' || to_char(p_po_org_id) || fnd_global.local_chr(10) ||
1268: ', p_pur_revision: ' || to_char(p_pur_revision) || fnd_global.local_chr(10) ||
1269: ', p_mo_line_grouping ' || to_char(p_mo_line_grouping) || fnd_global.local_chr(10)
1270: , l_proc_name
1271: , 9);
1272: print_debug('Calling INV_Minmax_PVT.do_restock'
1273: , l_proc_name

Line 1446: print_debug ('Executing get_move_order_info with the following parameters: ' || fnd_global.local_chr(10) ||

1442: BEGIN
1443: SAVEPOINT sp_get_move_order_info;
1444: l_return_status := FND_API.G_RET_STS_SUCCESS;
1445: IF G_TRACE_ON = 1 THEN
1446: print_debug ('Executing get_move_order_info with the following parameters: ' || fnd_global.local_chr(10) ||
1447: ' p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||
1448: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
1449: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
1450: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||

Line 1447: ' p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||

1443: SAVEPOINT sp_get_move_order_info;
1444: l_return_status := FND_API.G_RET_STS_SUCCESS;
1445: IF G_TRACE_ON = 1 THEN
1446: print_debug ('Executing get_move_order_info with the following parameters: ' || fnd_global.local_chr(10) ||
1447: ' p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||
1448: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
1449: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
1450: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
1451: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||

Line 1448: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||

1444: l_return_status := FND_API.G_RET_STS_SUCCESS;
1445: IF G_TRACE_ON = 1 THEN
1446: print_debug ('Executing get_move_order_info with the following parameters: ' || fnd_global.local_chr(10) ||
1447: ' p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||
1448: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
1449: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
1450: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
1451: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||
1452: ', p_need_by_time: ' || to_char(p_need_by_date) || fnd_global.local_chr(10)

Line 1449: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||

1445: IF G_TRACE_ON = 1 THEN
1446: print_debug ('Executing get_move_order_info with the following parameters: ' || fnd_global.local_chr(10) ||
1447: ' p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||
1448: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
1449: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
1450: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
1451: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||
1452: ', p_need_by_time: ' || to_char(p_need_by_date) || fnd_global.local_chr(10)
1453: , l_proc_name

Line 1450: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||

1446: print_debug ('Executing get_move_order_info with the following parameters: ' || fnd_global.local_chr(10) ||
1447: ' p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||
1448: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
1449: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
1450: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
1451: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||
1452: ', p_need_by_time: ' || to_char(p_need_by_date) || fnd_global.local_chr(10)
1453: , l_proc_name
1454: , 9 );

Line 1451: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||

1447: ' p_user_id: ' || to_char(p_user_id) || fnd_global.local_chr(10) ||
1448: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
1449: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
1450: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
1451: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||
1452: ', p_need_by_time: ' || to_char(p_need_by_date) || fnd_global.local_chr(10)
1453: , l_proc_name
1454: , 9 );
1455: END IF;

Line 1452: ', p_need_by_time: ' || to_char(p_need_by_date) || fnd_global.local_chr(10)

1448: ', p_organization_id: ' || to_char(p_organization_id) || fnd_global.local_chr(10) ||
1449: ', p_subinv: ' || p_subinv || fnd_global.local_chr(10) ||
1450: ', p_src_subinv: ' || p_src_subinv || fnd_global.local_chr(10) ||
1451: ', p_approval: ' || to_char(p_approval) || fnd_global.local_chr(10) ||
1452: ', p_need_by_time: ' || to_char(p_need_by_date) || fnd_global.local_chr(10)
1453: , l_proc_name
1454: , 9 );
1455: END IF;
1456: