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.WMS_PARAMETER_PVT dependencies on INV_PP_DEBUG

Line 245: IF inv_pp_debug.is_debug_mode THEN

241: x_flex_data_type_code := NULL;
242: x_flex_name := NULL;
243: x_flex_description := NULL;
244:
245: IF inv_pp_debug.is_debug_mode THEN
246: inv_pp_debug.send_message_to_pipe('Get_desc_flex_info(): ');
247: inv_pp_debug.send_message_to_pipe('p_flexfield_name: '|| p_flexfield_name);
248: inv_pp_debug.send_message_to_pipe('p_column_name: '|| p_column_name);
249: inv_pp_debug.send_message_to_pipe('x_if_flex_then_available: '|| x_if_flex_then_available);

Line 246: inv_pp_debug.send_message_to_pipe('Get_desc_flex_info(): ');

242: x_flex_name := NULL;
243: x_flex_description := NULL;
244:
245: IF inv_pp_debug.is_debug_mode THEN
246: inv_pp_debug.send_message_to_pipe('Get_desc_flex_info(): ');
247: inv_pp_debug.send_message_to_pipe('p_flexfield_name: '|| p_flexfield_name);
248: inv_pp_debug.send_message_to_pipe('p_column_name: '|| p_column_name);
249: inv_pp_debug.send_message_to_pipe('x_if_flex_then_available: '|| x_if_flex_then_available);
250: END IF;

Line 247: inv_pp_debug.send_message_to_pipe('p_flexfield_name: '|| p_flexfield_name);

243: x_flex_description := NULL;
244:
245: IF inv_pp_debug.is_debug_mode THEN
246: inv_pp_debug.send_message_to_pipe('Get_desc_flex_info(): ');
247: inv_pp_debug.send_message_to_pipe('p_flexfield_name: '|| p_flexfield_name);
248: inv_pp_debug.send_message_to_pipe('p_column_name: '|| p_column_name);
249: inv_pp_debug.send_message_to_pipe('x_if_flex_then_available: '|| x_if_flex_then_available);
250: END IF;
251:

Line 248: inv_pp_debug.send_message_to_pipe('p_column_name: '|| p_column_name);

244:
245: IF inv_pp_debug.is_debug_mode THEN
246: inv_pp_debug.send_message_to_pipe('Get_desc_flex_info(): ');
247: inv_pp_debug.send_message_to_pipe('p_flexfield_name: '|| p_flexfield_name);
248: inv_pp_debug.send_message_to_pipe('p_column_name: '|| p_column_name);
249: inv_pp_debug.send_message_to_pipe('x_if_flex_then_available: '|| x_if_flex_then_available);
250: END IF;
251:
252: --

Line 249: inv_pp_debug.send_message_to_pipe('x_if_flex_then_available: '|| x_if_flex_then_available);

245: IF inv_pp_debug.is_debug_mode THEN
246: inv_pp_debug.send_message_to_pipe('Get_desc_flex_info(): ');
247: inv_pp_debug.send_message_to_pipe('p_flexfield_name: '|| p_flexfield_name);
248: inv_pp_debug.send_message_to_pipe('p_column_name: '|| p_column_name);
249: inv_pp_debug.send_message_to_pipe('x_if_flex_then_available: '|| x_if_flex_then_available);
250: END IF;
251:
252: --
253: fnd_dflex.get_flexfield(

Line 292: IF inv_pp_debug.is_debug_mode THEN

288: END LOOP;
289:
290: --
291: IF l_segment_index = 0 THEN
292: IF inv_pp_debug.is_debug_mode THEN
293: inv_pp_debug.send_message_to_pipe('No segment found in Global context. ncontexts enabled : '|| l_contexts.ncontexts);
294: END IF;
295:
296: --segment not found

Line 293: inv_pp_debug.send_message_to_pipe('No segment found in Global context. ncontexts enabled : '|| l_contexts.ncontexts);

289:
290: --
291: IF l_segment_index = 0 THEN
292: IF inv_pp_debug.is_debug_mode THEN
293: inv_pp_debug.send_message_to_pipe('No segment found in Global context. ncontexts enabled : '|| l_contexts.ncontexts);
294: END IF;
295:
296: --segment not found
297: /*Start of New proposed fix*/

Line 299: inv_pp_debug.send_message_to_pipe('l_seg : '|| l_seg);

295:
296: --segment not found
297: /*Start of New proposed fix*/
298: FOR l_seg IN 1 .. l_contexts.ncontexts LOOP
299: inv_pp_debug.send_message_to_pipe('l_seg : '|| l_seg);
300:
301: IF l_contexts.is_enabled(l_seg) = TRUE
302: AND l_seg <> l_contexts.global_context THEN
303: inv_pp_debug.send_message_to_pipe('context ENABLED and not GLOBAL');

Line 303: inv_pp_debug.send_message_to_pipe('context ENABLED and not GLOBAL');

299: inv_pp_debug.send_message_to_pipe('l_seg : '|| l_seg);
300:
301: IF l_contexts.is_enabled(l_seg) = TRUE
302: AND l_seg <> l_contexts.global_context THEN
303: inv_pp_debug.send_message_to_pipe('context ENABLED and not GLOBAL');
304: l_context.context_code := l_contexts.context_code(l_seg);
305: l_context.flexfield := l_flexfield;
306: fnd_dflex.get_segments(l_context, l_segments, TRUE);
307:

Line 312: IF inv_pp_debug.is_debug_mode THEN

308: FOR l_index IN 1 .. l_segments.nsegments LOOP
309: IF l_segments.application_column_name(l_index) = p_column_name THEN
310: l_segment_index := l_index;
311:
312: IF inv_pp_debug.is_debug_mode THEN
313: inv_pp_debug.send_message_to_pipe('Found context code:'|| l_context.context_code);
314: END IF;
315:
316: RETURN;

Line 313: inv_pp_debug.send_message_to_pipe('Found context code:'|| l_context.context_code);

309: IF l_segments.application_column_name(l_index) = p_column_name THEN
310: l_segment_index := l_index;
311:
312: IF inv_pp_debug.is_debug_mode THEN
313: inv_pp_debug.send_message_to_pipe('Found context code:'|| l_context.context_code);
314: END IF;
315:
316: RETURN;
317: END IF;

Line 321: inv_pp_debug.send_message_to_pipe('AFTER LOOP: l_segment_index :'|| l_segment_index);

317: END IF;
318: END LOOP;
319: END IF;
320:
321: inv_pp_debug.send_message_to_pipe('AFTER LOOP: l_segment_index :'|| l_segment_index);
322: END LOOP;
323: END IF;
324:
325: IF l_segment_index = 0 THEN

Line 331: inv_pp_debug.send_message_to_pipe('segment found .');

327: RETURN;
328: END IF;
329:
330: /*End of Proposed fix*/
331: inv_pp_debug.send_message_to_pipe('segment found .');
332:
333: --
334: -- segment found
335: -- if the segment does not use a value set, no type info

Line 364: IF inv_pp_debug.is_debug_mode THEN

360: x_flex_data_type_code := NULL;
361: x_flex_name := NULL;
362: x_flex_description := NULL;
363:
364: IF inv_pp_debug.is_debug_mode THEN
365: inv_pp_debug.send_message_to_pipe('EXCEPTION: x_if_flex_then_available: '|| x_if_flex_then_available);
366: END IF;
367:
368: RETURN;

Line 365: inv_pp_debug.send_message_to_pipe('EXCEPTION: x_if_flex_then_available: '|| x_if_flex_then_available);

361: x_flex_name := NULL;
362: x_flex_description := NULL;
363:
364: IF inv_pp_debug.is_debug_mode THEN
365: inv_pp_debug.send_message_to_pipe('EXCEPTION: x_if_flex_then_available: '|| x_if_flex_then_available);
366: END IF;
367:
368: RETURN;
369: END get_desc_flex_info;

Line 424: IF inv_pp_debug.is_debug_mode THEN

420:
421: --
422: -- validate input
423:
424: IF inv_pp_debug.is_debug_mode THEN
425: inv_pp_debug.send_message_to_pipe('Get_flex_info(): ');
426: inv_pp_debug.send_message_to_pipe('p_db_object_ref_type_code: '|| p_db_object_ref_type_code);
427: inv_pp_debug.send_message_to_pipe('p_parameter_type_code: '|| p_parameter_type_code);
428: inv_pp_debug.send_message_to_pipe('p_flexfield_usage_code: '|| p_flexfield_usage_code);

Line 425: inv_pp_debug.send_message_to_pipe('Get_flex_info(): ');

421: --
422: -- validate input
423:
424: IF inv_pp_debug.is_debug_mode THEN
425: inv_pp_debug.send_message_to_pipe('Get_flex_info(): ');
426: inv_pp_debug.send_message_to_pipe('p_db_object_ref_type_code: '|| p_db_object_ref_type_code);
427: inv_pp_debug.send_message_to_pipe('p_parameter_type_code: '|| p_parameter_type_code);
428: inv_pp_debug.send_message_to_pipe('p_flexfield_usage_code: '|| p_flexfield_usage_code);
429: inv_pp_debug.send_message_to_pipe('p_flexfield_name: '|| p_flexfield_name);

Line 426: inv_pp_debug.send_message_to_pipe('p_db_object_ref_type_code: '|| p_db_object_ref_type_code);

422: -- validate input
423:
424: IF inv_pp_debug.is_debug_mode THEN
425: inv_pp_debug.send_message_to_pipe('Get_flex_info(): ');
426: inv_pp_debug.send_message_to_pipe('p_db_object_ref_type_code: '|| p_db_object_ref_type_code);
427: inv_pp_debug.send_message_to_pipe('p_parameter_type_code: '|| p_parameter_type_code);
428: inv_pp_debug.send_message_to_pipe('p_flexfield_usage_code: '|| p_flexfield_usage_code);
429: inv_pp_debug.send_message_to_pipe('p_flexfield_name: '|| p_flexfield_name);
430: inv_pp_debug.send_message_to_pipe('p_column_name: '|| p_column_name);

Line 427: inv_pp_debug.send_message_to_pipe('p_parameter_type_code: '|| p_parameter_type_code);

423:
424: IF inv_pp_debug.is_debug_mode THEN
425: inv_pp_debug.send_message_to_pipe('Get_flex_info(): ');
426: inv_pp_debug.send_message_to_pipe('p_db_object_ref_type_code: '|| p_db_object_ref_type_code);
427: inv_pp_debug.send_message_to_pipe('p_parameter_type_code: '|| p_parameter_type_code);
428: inv_pp_debug.send_message_to_pipe('p_flexfield_usage_code: '|| p_flexfield_usage_code);
429: inv_pp_debug.send_message_to_pipe('p_flexfield_name: '|| p_flexfield_name);
430: inv_pp_debug.send_message_to_pipe('p_column_name: '|| p_column_name);
431: inv_pp_debug.send_message_to_pipe('x_if_flex_then_available: '|| x_if_flex_then_available);

Line 428: inv_pp_debug.send_message_to_pipe('p_flexfield_usage_code: '|| p_flexfield_usage_code);

424: IF inv_pp_debug.is_debug_mode THEN
425: inv_pp_debug.send_message_to_pipe('Get_flex_info(): ');
426: inv_pp_debug.send_message_to_pipe('p_db_object_ref_type_code: '|| p_db_object_ref_type_code);
427: inv_pp_debug.send_message_to_pipe('p_parameter_type_code: '|| p_parameter_type_code);
428: inv_pp_debug.send_message_to_pipe('p_flexfield_usage_code: '|| p_flexfield_usage_code);
429: inv_pp_debug.send_message_to_pipe('p_flexfield_name: '|| p_flexfield_name);
430: inv_pp_debug.send_message_to_pipe('p_column_name: '|| p_column_name);
431: inv_pp_debug.send_message_to_pipe('x_if_flex_then_available: '|| x_if_flex_then_available);
432: END IF;

Line 429: inv_pp_debug.send_message_to_pipe('p_flexfield_name: '|| p_flexfield_name);

425: inv_pp_debug.send_message_to_pipe('Get_flex_info(): ');
426: inv_pp_debug.send_message_to_pipe('p_db_object_ref_type_code: '|| p_db_object_ref_type_code);
427: inv_pp_debug.send_message_to_pipe('p_parameter_type_code: '|| p_parameter_type_code);
428: inv_pp_debug.send_message_to_pipe('p_flexfield_usage_code: '|| p_flexfield_usage_code);
429: inv_pp_debug.send_message_to_pipe('p_flexfield_name: '|| p_flexfield_name);
430: inv_pp_debug.send_message_to_pipe('p_column_name: '|| p_column_name);
431: inv_pp_debug.send_message_to_pipe('x_if_flex_then_available: '|| x_if_flex_then_available);
432: END IF;
433:

Line 430: inv_pp_debug.send_message_to_pipe('p_column_name: '|| p_column_name);

426: inv_pp_debug.send_message_to_pipe('p_db_object_ref_type_code: '|| p_db_object_ref_type_code);
427: inv_pp_debug.send_message_to_pipe('p_parameter_type_code: '|| p_parameter_type_code);
428: inv_pp_debug.send_message_to_pipe('p_flexfield_usage_code: '|| p_flexfield_usage_code);
429: inv_pp_debug.send_message_to_pipe('p_flexfield_name: '|| p_flexfield_name);
430: inv_pp_debug.send_message_to_pipe('p_column_name: '|| p_column_name);
431: inv_pp_debug.send_message_to_pipe('x_if_flex_then_available: '|| x_if_flex_then_available);
432: END IF;
433:
434: IF p_db_object_ref_type_code = g_miss_num

Line 431: inv_pp_debug.send_message_to_pipe('x_if_flex_then_available: '|| x_if_flex_then_available);

427: inv_pp_debug.send_message_to_pipe('p_parameter_type_code: '|| p_parameter_type_code);
428: inv_pp_debug.send_message_to_pipe('p_flexfield_usage_code: '|| p_flexfield_usage_code);
429: inv_pp_debug.send_message_to_pipe('p_flexfield_name: '|| p_flexfield_name);
430: inv_pp_debug.send_message_to_pipe('p_column_name: '|| p_column_name);
431: inv_pp_debug.send_message_to_pipe('x_if_flex_then_available: '|| x_if_flex_then_available);
432: END IF;
433:
434: IF p_db_object_ref_type_code = g_miss_num
435: OR p_db_object_ref_type_code IS NULL

Line 442: inv_pp_debug.send_message_to_pipe('Failed input validation .RETURN');

438: OR p_flexfield_usage_code = g_miss_char
439: OR p_flexfield_application_id = g_miss_num
440: OR p_flexfield_name = g_miss_char
441: OR p_column_name = g_miss_char THEN
442: inv_pp_debug.send_message_to_pipe('Failed input validation .RETURN');
443: RETURN;
444: END IF;
445:
446: --

Line 460: inv_pp_debug.send_message_to_pipe('p_flexfield_application_id IS NULL.RETURN');

456: END IF;
457:
458: --
459: IF p_flexfield_application_id IS NULL THEN
460: inv_pp_debug.send_message_to_pipe('p_flexfield_application_id IS NULL.RETURN');
461:
462: IF (p_flexfield_usage_code IS NOT NULL) THEN
463: x_if_flex_then_available := 'N';
464: END IF;

Line 476: inv_pp_debug.send_message_to_pipe('l_appl_short_name : '|| l_appl_short_name);

472: -- as flexfield segment.
473: --
474: l_appl_short_name := get_application_short_name(p_flexfield_application_id);
475: --
476: inv_pp_debug.send_message_to_pipe('l_appl_short_name : '|| l_appl_short_name);
477:
478: IF l_appl_short_name IS NULL THEN
479: fnd_message.set_name('INV', 'INV_INVALID_APPLICATION_ID');
480: fnd_message.set_token('APPLICATION_ID', p_flexfield_application_id);

Line 512: inv_pp_debug.send_message_to_pipe('flexfield usage code NULL: '|| ' x_if_flex_then_available: ' || x_if_flex_then_available);

508: x_if_flex_then_available := 'Y';
509: x_flex_data_type_code := NULL;
510: x_flex_name := NULL;
511: x_flex_description := NULL;
512: inv_pp_debug.send_message_to_pipe('flexfield usage code NULL: '|| ' x_if_flex_then_available: ' || x_if_flex_then_available);
513: END IF;
514: EXCEPTION
515: WHEN fnd_api.g_exc_unexpected_error THEN
516: inv_pp_debug.send_message_to_pipe('EXCEPTION ');

Line 516: inv_pp_debug.send_message_to_pipe('EXCEPTION ');

512: inv_pp_debug.send_message_to_pipe('flexfield usage code NULL: '|| ' x_if_flex_then_available: ' || x_if_flex_then_available);
513: END IF;
514: EXCEPTION
515: WHEN fnd_api.g_exc_unexpected_error THEN
516: inv_pp_debug.send_message_to_pipe('EXCEPTION ');
517: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
518: END get_flex_info;
519:
520: -- API name : IfFlexThenAvailable

Line 5384: IF inv_pp_debug.is_debug_mode THEN

5380: , po_line_id
5381: FROM rcv_transactions
5382: WHERE transaction_id = p_reference_id;
5383: BEGIN
5384: IF inv_pp_debug.is_debug_mode THEN
5385: inv_pp_debug.send_message_to_pipe('GetPOHeaderLineID(): ');
5386: inv_pp_debug.send_message_to_pipe('p_transaction_source_type_id: '|| p_transaction_source_type_id);
5387: inv_pp_debug.send_message_to_pipe('p_reference: '|| p_reference);
5388: inv_pp_debug.send_message_to_pipe('p_reference_id: '|| p_reference_id);

Line 5385: inv_pp_debug.send_message_to_pipe('GetPOHeaderLineID(): ');

5381: FROM rcv_transactions
5382: WHERE transaction_id = p_reference_id;
5383: BEGIN
5384: IF inv_pp_debug.is_debug_mode THEN
5385: inv_pp_debug.send_message_to_pipe('GetPOHeaderLineID(): ');
5386: inv_pp_debug.send_message_to_pipe('p_transaction_source_type_id: '|| p_transaction_source_type_id);
5387: inv_pp_debug.send_message_to_pipe('p_reference: '|| p_reference);
5388: inv_pp_debug.send_message_to_pipe('p_reference_id: '|| p_reference_id);
5389: inv_pp_debug.send_message_to_pipe('p_header_flag: '|| p_header_flag);

Line 5386: inv_pp_debug.send_message_to_pipe('p_transaction_source_type_id: '|| p_transaction_source_type_id);

5382: WHERE transaction_id = p_reference_id;
5383: BEGIN
5384: IF inv_pp_debug.is_debug_mode THEN
5385: inv_pp_debug.send_message_to_pipe('GetPOHeaderLineID(): ');
5386: inv_pp_debug.send_message_to_pipe('p_transaction_source_type_id: '|| p_transaction_source_type_id);
5387: inv_pp_debug.send_message_to_pipe('p_reference: '|| p_reference);
5388: inv_pp_debug.send_message_to_pipe('p_reference_id: '|| p_reference_id);
5389: inv_pp_debug.send_message_to_pipe('p_header_flag: '|| p_header_flag);
5390: inv_pp_debug.send_message_to_pipe('p_line_flag: '|| p_line_flag);

Line 5387: inv_pp_debug.send_message_to_pipe('p_reference: '|| p_reference);

5383: BEGIN
5384: IF inv_pp_debug.is_debug_mode THEN
5385: inv_pp_debug.send_message_to_pipe('GetPOHeaderLineID(): ');
5386: inv_pp_debug.send_message_to_pipe('p_transaction_source_type_id: '|| p_transaction_source_type_id);
5387: inv_pp_debug.send_message_to_pipe('p_reference: '|| p_reference);
5388: inv_pp_debug.send_message_to_pipe('p_reference_id: '|| p_reference_id);
5389: inv_pp_debug.send_message_to_pipe('p_header_flag: '|| p_header_flag);
5390: inv_pp_debug.send_message_to_pipe('p_line_flag: '|| p_line_flag);
5391: END IF;

Line 5388: inv_pp_debug.send_message_to_pipe('p_reference_id: '|| p_reference_id);

5384: IF inv_pp_debug.is_debug_mode THEN
5385: inv_pp_debug.send_message_to_pipe('GetPOHeaderLineID(): ');
5386: inv_pp_debug.send_message_to_pipe('p_transaction_source_type_id: '|| p_transaction_source_type_id);
5387: inv_pp_debug.send_message_to_pipe('p_reference: '|| p_reference);
5388: inv_pp_debug.send_message_to_pipe('p_reference_id: '|| p_reference_id);
5389: inv_pp_debug.send_message_to_pipe('p_header_flag: '|| p_header_flag);
5390: inv_pp_debug.send_message_to_pipe('p_line_flag: '|| p_line_flag);
5391: END IF;
5392:

Line 5389: inv_pp_debug.send_message_to_pipe('p_header_flag: '|| p_header_flag);

5385: inv_pp_debug.send_message_to_pipe('GetPOHeaderLineID(): ');
5386: inv_pp_debug.send_message_to_pipe('p_transaction_source_type_id: '|| p_transaction_source_type_id);
5387: inv_pp_debug.send_message_to_pipe('p_reference: '|| p_reference);
5388: inv_pp_debug.send_message_to_pipe('p_reference_id: '|| p_reference_id);
5389: inv_pp_debug.send_message_to_pipe('p_header_flag: '|| p_header_flag);
5390: inv_pp_debug.send_message_to_pipe('p_line_flag: '|| p_line_flag);
5391: END IF;
5392:
5393: -- validate input parameters

Line 5390: inv_pp_debug.send_message_to_pipe('p_line_flag: '|| p_line_flag);

5386: inv_pp_debug.send_message_to_pipe('p_transaction_source_type_id: '|| p_transaction_source_type_id);
5387: inv_pp_debug.send_message_to_pipe('p_reference: '|| p_reference);
5388: inv_pp_debug.send_message_to_pipe('p_reference_id: '|| p_reference_id);
5389: inv_pp_debug.send_message_to_pipe('p_header_flag: '|| p_header_flag);
5390: inv_pp_debug.send_message_to_pipe('p_line_flag: '|| p_line_flag);
5391: END IF;
5392:
5393: -- validate input parameters
5394: IF p_transaction_source_type_id IS NULL

Line 5425: IF inv_pp_debug.is_debug_mode THEN

5421: -- ==========================================================
5422: ELSIF (p_transaction_source_type_id = 1
5423: AND p_reference_id IS NOT NULL
5424: ) THEN
5425: IF inv_pp_debug.is_debug_mode THEN
5426: inv_pp_debug.send_message_to_pipe('Open cursor rcv_transactions ');
5427: END IF;
5428:
5429: OPEN l_rcv_transactions_curs;

Line 5426: inv_pp_debug.send_message_to_pipe('Open cursor rcv_transactions ');

5422: ELSIF (p_transaction_source_type_id = 1
5423: AND p_reference_id IS NOT NULL
5424: ) THEN
5425: IF inv_pp_debug.is_debug_mode THEN
5426: inv_pp_debug.send_message_to_pipe('Open cursor rcv_transactions ');
5427: END IF;
5428:
5429: OPEN l_rcv_transactions_curs;
5430: FETCH l_rcv_transactions_curs INTO l_po_header_id, l_po_line_id;

Line 5433: IF inv_pp_debug.is_debug_mode THEN

5429: OPEN l_rcv_transactions_curs;
5430: FETCH l_rcv_transactions_curs INTO l_po_header_id, l_po_line_id;
5431: CLOSE l_rcv_transactions_curs;
5432:
5433: IF inv_pp_debug.is_debug_mode THEN
5434: inv_pp_debug.send_message_to_pipe('l_po_header_id : '|| l_po_header_id);
5435: inv_pp_debug.send_message_to_pipe('l_po_line_id : '|| l_po_line_id);
5436: END IF;
5437: END IF;

Line 5434: inv_pp_debug.send_message_to_pipe('l_po_header_id : '|| l_po_header_id);

5430: FETCH l_rcv_transactions_curs INTO l_po_header_id, l_po_line_id;
5431: CLOSE l_rcv_transactions_curs;
5432:
5433: IF inv_pp_debug.is_debug_mode THEN
5434: inv_pp_debug.send_message_to_pipe('l_po_header_id : '|| l_po_header_id);
5435: inv_pp_debug.send_message_to_pipe('l_po_line_id : '|| l_po_line_id);
5436: END IF;
5437: END IF;
5438: --bug 2983185 - PO information constant for move order line, so

Line 5435: inv_pp_debug.send_message_to_pipe('l_po_line_id : '|| l_po_line_id);

5431: CLOSE l_rcv_transactions_curs;
5432:
5433: IF inv_pp_debug.is_debug_mode THEN
5434: inv_pp_debug.send_message_to_pipe('l_po_header_id : '|| l_po_header_id);
5435: inv_pp_debug.send_message_to_pipe('l_po_line_id : '|| l_po_line_id);
5436: END IF;
5437: END IF;
5438: --bug 2983185 - PO information constant for move order line, so
5439: -- we don't need to constantly requery this information for every

Line 5922: --inv_pp_debug.set_debug_mode(inv_pp_debug.g_debug_mode_yes);

5918: WHERE transaction_id = p_reference_id
5919: AND routing_header_id = 3 ;
5920: --End bug 4505225
5921: BEGIN
5922: --inv_pp_debug.set_debug_mode(inv_pp_debug.g_debug_mode_yes);
5923: --inv_pp_debug.set_debug_pipe_name('htnguyen');
5924:
5925: IF inv_pp_debug.is_debug_mode THEN
5926: inv_pp_debug.send_message_to_pipe('GetSOHeaderLineID(): ');

Line 5923: --inv_pp_debug.set_debug_pipe_name('htnguyen');

5919: AND routing_header_id = 3 ;
5920: --End bug 4505225
5921: BEGIN
5922: --inv_pp_debug.set_debug_mode(inv_pp_debug.g_debug_mode_yes);
5923: --inv_pp_debug.set_debug_pipe_name('htnguyen');
5924:
5925: IF inv_pp_debug.is_debug_mode THEN
5926: inv_pp_debug.send_message_to_pipe('GetSOHeaderLineID(): ');
5927: inv_pp_debug.send_message_to_pipe('p_line_id: '|| p_line_id);

Line 5925: IF inv_pp_debug.is_debug_mode THEN

5921: BEGIN
5922: --inv_pp_debug.set_debug_mode(inv_pp_debug.g_debug_mode_yes);
5923: --inv_pp_debug.set_debug_pipe_name('htnguyen');
5924:
5925: IF inv_pp_debug.is_debug_mode THEN
5926: inv_pp_debug.send_message_to_pipe('GetSOHeaderLineID(): ');
5927: inv_pp_debug.send_message_to_pipe('p_line_id: '|| p_line_id);
5928: inv_pp_debug.send_message_to_pipe('p_transaction_source_type_id: '|| p_transaction_source_type_id);
5929: inv_pp_debug.send_message_to_pipe('p_reference: '|| p_reference);

Line 5926: inv_pp_debug.send_message_to_pipe('GetSOHeaderLineID(): ');

5922: --inv_pp_debug.set_debug_mode(inv_pp_debug.g_debug_mode_yes);
5923: --inv_pp_debug.set_debug_pipe_name('htnguyen');
5924:
5925: IF inv_pp_debug.is_debug_mode THEN
5926: inv_pp_debug.send_message_to_pipe('GetSOHeaderLineID(): ');
5927: inv_pp_debug.send_message_to_pipe('p_line_id: '|| p_line_id);
5928: inv_pp_debug.send_message_to_pipe('p_transaction_source_type_id: '|| p_transaction_source_type_id);
5929: inv_pp_debug.send_message_to_pipe('p_reference: '|| p_reference);
5930: inv_pp_debug.send_message_to_pipe('p_reference_id: '|| p_reference_id);

Line 5927: inv_pp_debug.send_message_to_pipe('p_line_id: '|| p_line_id);

5923: --inv_pp_debug.set_debug_pipe_name('htnguyen');
5924:
5925: IF inv_pp_debug.is_debug_mode THEN
5926: inv_pp_debug.send_message_to_pipe('GetSOHeaderLineID(): ');
5927: inv_pp_debug.send_message_to_pipe('p_line_id: '|| p_line_id);
5928: inv_pp_debug.send_message_to_pipe('p_transaction_source_type_id: '|| p_transaction_source_type_id);
5929: inv_pp_debug.send_message_to_pipe('p_reference: '|| p_reference);
5930: inv_pp_debug.send_message_to_pipe('p_reference_id: '|| p_reference_id);
5931: inv_pp_debug.send_message_to_pipe('p_header_flag: '|| p_header_flag);

Line 5928: inv_pp_debug.send_message_to_pipe('p_transaction_source_type_id: '|| p_transaction_source_type_id);

5924:
5925: IF inv_pp_debug.is_debug_mode THEN
5926: inv_pp_debug.send_message_to_pipe('GetSOHeaderLineID(): ');
5927: inv_pp_debug.send_message_to_pipe('p_line_id: '|| p_line_id);
5928: inv_pp_debug.send_message_to_pipe('p_transaction_source_type_id: '|| p_transaction_source_type_id);
5929: inv_pp_debug.send_message_to_pipe('p_reference: '|| p_reference);
5930: inv_pp_debug.send_message_to_pipe('p_reference_id: '|| p_reference_id);
5931: inv_pp_debug.send_message_to_pipe('p_header_flag: '|| p_header_flag);
5932: inv_pp_debug.send_message_to_pipe('p_line_flag: '|| p_line_flag);

Line 5929: inv_pp_debug.send_message_to_pipe('p_reference: '|| p_reference);

5925: IF inv_pp_debug.is_debug_mode THEN
5926: inv_pp_debug.send_message_to_pipe('GetSOHeaderLineID(): ');
5927: inv_pp_debug.send_message_to_pipe('p_line_id: '|| p_line_id);
5928: inv_pp_debug.send_message_to_pipe('p_transaction_source_type_id: '|| p_transaction_source_type_id);
5929: inv_pp_debug.send_message_to_pipe('p_reference: '|| p_reference);
5930: inv_pp_debug.send_message_to_pipe('p_reference_id: '|| p_reference_id);
5931: inv_pp_debug.send_message_to_pipe('p_header_flag: '|| p_header_flag);
5932: inv_pp_debug.send_message_to_pipe('p_line_flag: '|| p_line_flag);
5933: END IF;

Line 5930: inv_pp_debug.send_message_to_pipe('p_reference_id: '|| p_reference_id);

5926: inv_pp_debug.send_message_to_pipe('GetSOHeaderLineID(): ');
5927: inv_pp_debug.send_message_to_pipe('p_line_id: '|| p_line_id);
5928: inv_pp_debug.send_message_to_pipe('p_transaction_source_type_id: '|| p_transaction_source_type_id);
5929: inv_pp_debug.send_message_to_pipe('p_reference: '|| p_reference);
5930: inv_pp_debug.send_message_to_pipe('p_reference_id: '|| p_reference_id);
5931: inv_pp_debug.send_message_to_pipe('p_header_flag: '|| p_header_flag);
5932: inv_pp_debug.send_message_to_pipe('p_line_flag: '|| p_line_flag);
5933: END IF;
5934:

Line 5931: inv_pp_debug.send_message_to_pipe('p_header_flag: '|| p_header_flag);

5927: inv_pp_debug.send_message_to_pipe('p_line_id: '|| p_line_id);
5928: inv_pp_debug.send_message_to_pipe('p_transaction_source_type_id: '|| p_transaction_source_type_id);
5929: inv_pp_debug.send_message_to_pipe('p_reference: '|| p_reference);
5930: inv_pp_debug.send_message_to_pipe('p_reference_id: '|| p_reference_id);
5931: inv_pp_debug.send_message_to_pipe('p_header_flag: '|| p_header_flag);
5932: inv_pp_debug.send_message_to_pipe('p_line_flag: '|| p_line_flag);
5933: END IF;
5934:
5935: -- RMA = 12

Line 5932: inv_pp_debug.send_message_to_pipe('p_line_flag: '|| p_line_flag);

5928: inv_pp_debug.send_message_to_pipe('p_transaction_source_type_id: '|| p_transaction_source_type_id);
5929: inv_pp_debug.send_message_to_pipe('p_reference: '|| p_reference);
5930: inv_pp_debug.send_message_to_pipe('p_reference_id: '|| p_reference_id);
5931: inv_pp_debug.send_message_to_pipe('p_header_flag: '|| p_header_flag);
5932: inv_pp_debug.send_message_to_pipe('p_line_flag: '|| p_line_flag);
5933: END IF;
5934:
5935: -- RMA = 12
5936: -- BUG 3205362 - For performance reasons cache the in parameters and results of this function

Line 5982: IF inv_pp_debug.is_debug_mode THEN

5978: END IF;
5979: l_line_id := g_gsohl_line_id;
5980: l_header_id := g_gsohl_header_id;
5981:
5982: IF inv_pp_debug.is_debug_mode THEN
5983: inv_pp_debug.send_message_to_pipe('l_header_id : '|| l_header_id);
5984: inv_pp_debug.send_message_to_pipe('l_line_id : '|| l_line_id);
5985: END IF;
5986:

Line 5983: inv_pp_debug.send_message_to_pipe('l_header_id : '|| l_header_id);

5979: l_line_id := g_gsohl_line_id;
5980: l_header_id := g_gsohl_header_id;
5981:
5982: IF inv_pp_debug.is_debug_mode THEN
5983: inv_pp_debug.send_message_to_pipe('l_header_id : '|| l_header_id);
5984: inv_pp_debug.send_message_to_pipe('l_line_id : '|| l_line_id);
5985: END IF;
5986:
5987: IF (p_header_flag = 'Y') THEN

Line 5984: inv_pp_debug.send_message_to_pipe('l_line_id : '|| l_line_id);

5980: l_header_id := g_gsohl_header_id;
5981:
5982: IF inv_pp_debug.is_debug_mode THEN
5983: inv_pp_debug.send_message_to_pipe('l_header_id : '|| l_header_id);
5984: inv_pp_debug.send_message_to_pipe('l_line_id : '|| l_line_id);
5985: END IF;
5986:
5987: IF (p_header_flag = 'Y') THEN
5988: l_return_val := l_header_id;