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 5376: IF inv_pp_debug.is_debug_mode THEN

5372: , po_line_id
5373: FROM rcv_transactions
5374: WHERE transaction_id = p_reference_id;
5375: BEGIN
5376: IF inv_pp_debug.is_debug_mode THEN
5377: inv_pp_debug.send_message_to_pipe('GetPOHeaderLineID(): ');
5378: inv_pp_debug.send_message_to_pipe('p_transaction_source_type_id: '|| p_transaction_source_type_id);
5379: inv_pp_debug.send_message_to_pipe('p_reference: '|| p_reference);
5380: inv_pp_debug.send_message_to_pipe('p_reference_id: '|| p_reference_id);

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

5373: FROM rcv_transactions
5374: WHERE transaction_id = p_reference_id;
5375: BEGIN
5376: IF inv_pp_debug.is_debug_mode THEN
5377: inv_pp_debug.send_message_to_pipe('GetPOHeaderLineID(): ');
5378: inv_pp_debug.send_message_to_pipe('p_transaction_source_type_id: '|| p_transaction_source_type_id);
5379: inv_pp_debug.send_message_to_pipe('p_reference: '|| p_reference);
5380: inv_pp_debug.send_message_to_pipe('p_reference_id: '|| p_reference_id);
5381: inv_pp_debug.send_message_to_pipe('p_header_flag: '|| p_header_flag);

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

5374: WHERE transaction_id = p_reference_id;
5375: BEGIN
5376: IF inv_pp_debug.is_debug_mode THEN
5377: inv_pp_debug.send_message_to_pipe('GetPOHeaderLineID(): ');
5378: inv_pp_debug.send_message_to_pipe('p_transaction_source_type_id: '|| p_transaction_source_type_id);
5379: inv_pp_debug.send_message_to_pipe('p_reference: '|| p_reference);
5380: inv_pp_debug.send_message_to_pipe('p_reference_id: '|| p_reference_id);
5381: inv_pp_debug.send_message_to_pipe('p_header_flag: '|| p_header_flag);
5382: inv_pp_debug.send_message_to_pipe('p_line_flag: '|| p_line_flag);

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

5375: BEGIN
5376: IF inv_pp_debug.is_debug_mode THEN
5377: inv_pp_debug.send_message_to_pipe('GetPOHeaderLineID(): ');
5378: inv_pp_debug.send_message_to_pipe('p_transaction_source_type_id: '|| p_transaction_source_type_id);
5379: inv_pp_debug.send_message_to_pipe('p_reference: '|| p_reference);
5380: inv_pp_debug.send_message_to_pipe('p_reference_id: '|| p_reference_id);
5381: inv_pp_debug.send_message_to_pipe('p_header_flag: '|| p_header_flag);
5382: inv_pp_debug.send_message_to_pipe('p_line_flag: '|| p_line_flag);
5383: END IF;

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

5376: IF inv_pp_debug.is_debug_mode THEN
5377: inv_pp_debug.send_message_to_pipe('GetPOHeaderLineID(): ');
5378: inv_pp_debug.send_message_to_pipe('p_transaction_source_type_id: '|| p_transaction_source_type_id);
5379: inv_pp_debug.send_message_to_pipe('p_reference: '|| p_reference);
5380: inv_pp_debug.send_message_to_pipe('p_reference_id: '|| p_reference_id);
5381: inv_pp_debug.send_message_to_pipe('p_header_flag: '|| p_header_flag);
5382: inv_pp_debug.send_message_to_pipe('p_line_flag: '|| p_line_flag);
5383: END IF;
5384:

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

5377: inv_pp_debug.send_message_to_pipe('GetPOHeaderLineID(): ');
5378: inv_pp_debug.send_message_to_pipe('p_transaction_source_type_id: '|| p_transaction_source_type_id);
5379: inv_pp_debug.send_message_to_pipe('p_reference: '|| p_reference);
5380: inv_pp_debug.send_message_to_pipe('p_reference_id: '|| p_reference_id);
5381: inv_pp_debug.send_message_to_pipe('p_header_flag: '|| p_header_flag);
5382: inv_pp_debug.send_message_to_pipe('p_line_flag: '|| p_line_flag);
5383: END IF;
5384:
5385: -- validate input parameters

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

5378: inv_pp_debug.send_message_to_pipe('p_transaction_source_type_id: '|| p_transaction_source_type_id);
5379: inv_pp_debug.send_message_to_pipe('p_reference: '|| p_reference);
5380: inv_pp_debug.send_message_to_pipe('p_reference_id: '|| p_reference_id);
5381: inv_pp_debug.send_message_to_pipe('p_header_flag: '|| p_header_flag);
5382: inv_pp_debug.send_message_to_pipe('p_line_flag: '|| p_line_flag);
5383: END IF;
5384:
5385: -- validate input parameters
5386: IF p_transaction_source_type_id IS NULL

Line 5411: IF inv_pp_debug.is_debug_mode THEN

5407: -- ==========================================================
5408: ELSIF (p_transaction_source_type_id = 1
5409: AND p_reference_id IS NOT NULL
5410: ) THEN
5411: IF inv_pp_debug.is_debug_mode THEN
5412: inv_pp_debug.send_message_to_pipe('Open cursor rcv_transactions ');
5413: END IF;
5414:
5415: OPEN l_rcv_transactions_curs;

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

5408: ELSIF (p_transaction_source_type_id = 1
5409: AND p_reference_id IS NOT NULL
5410: ) THEN
5411: IF inv_pp_debug.is_debug_mode THEN
5412: inv_pp_debug.send_message_to_pipe('Open cursor rcv_transactions ');
5413: END IF;
5414:
5415: OPEN l_rcv_transactions_curs;
5416: FETCH l_rcv_transactions_curs INTO l_po_header_id, l_po_line_id;

Line 5419: IF inv_pp_debug.is_debug_mode THEN

5415: OPEN l_rcv_transactions_curs;
5416: FETCH l_rcv_transactions_curs INTO l_po_header_id, l_po_line_id;
5417: CLOSE l_rcv_transactions_curs;
5418:
5419: IF inv_pp_debug.is_debug_mode THEN
5420: inv_pp_debug.send_message_to_pipe('l_po_header_id : '|| l_po_header_id);
5421: inv_pp_debug.send_message_to_pipe('l_po_line_id : '|| l_po_line_id);
5422: END IF;
5423: END IF;

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

5416: FETCH l_rcv_transactions_curs INTO l_po_header_id, l_po_line_id;
5417: CLOSE l_rcv_transactions_curs;
5418:
5419: IF inv_pp_debug.is_debug_mode THEN
5420: inv_pp_debug.send_message_to_pipe('l_po_header_id : '|| l_po_header_id);
5421: inv_pp_debug.send_message_to_pipe('l_po_line_id : '|| l_po_line_id);
5422: END IF;
5423: END IF;
5424: --bug 2983185 - PO information constant for move order line, so

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

5417: CLOSE l_rcv_transactions_curs;
5418:
5419: IF inv_pp_debug.is_debug_mode THEN
5420: inv_pp_debug.send_message_to_pipe('l_po_header_id : '|| l_po_header_id);
5421: inv_pp_debug.send_message_to_pipe('l_po_line_id : '|| l_po_line_id);
5422: END IF;
5423: END IF;
5424: --bug 2983185 - PO information constant for move order line, so
5425: -- we don't need to constantly requery this information for every

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

5904: WHERE transaction_id = p_reference_id
5905: AND routing_header_id = 3 ;
5906: --End bug 4505225
5907: BEGIN
5908: --inv_pp_debug.set_debug_mode(inv_pp_debug.g_debug_mode_yes);
5909: --inv_pp_debug.set_debug_pipe_name('htnguyen');
5910:
5911: IF inv_pp_debug.is_debug_mode THEN
5912: inv_pp_debug.send_message_to_pipe('GetSOHeaderLineID(): ');

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

5905: AND routing_header_id = 3 ;
5906: --End bug 4505225
5907: BEGIN
5908: --inv_pp_debug.set_debug_mode(inv_pp_debug.g_debug_mode_yes);
5909: --inv_pp_debug.set_debug_pipe_name('htnguyen');
5910:
5911: IF inv_pp_debug.is_debug_mode THEN
5912: inv_pp_debug.send_message_to_pipe('GetSOHeaderLineID(): ');
5913: inv_pp_debug.send_message_to_pipe('p_line_id: '|| p_line_id);

Line 5911: IF inv_pp_debug.is_debug_mode THEN

5907: BEGIN
5908: --inv_pp_debug.set_debug_mode(inv_pp_debug.g_debug_mode_yes);
5909: --inv_pp_debug.set_debug_pipe_name('htnguyen');
5910:
5911: IF inv_pp_debug.is_debug_mode THEN
5912: inv_pp_debug.send_message_to_pipe('GetSOHeaderLineID(): ');
5913: inv_pp_debug.send_message_to_pipe('p_line_id: '|| p_line_id);
5914: inv_pp_debug.send_message_to_pipe('p_transaction_source_type_id: '|| p_transaction_source_type_id);
5915: inv_pp_debug.send_message_to_pipe('p_reference: '|| p_reference);

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

5908: --inv_pp_debug.set_debug_mode(inv_pp_debug.g_debug_mode_yes);
5909: --inv_pp_debug.set_debug_pipe_name('htnguyen');
5910:
5911: IF inv_pp_debug.is_debug_mode THEN
5912: inv_pp_debug.send_message_to_pipe('GetSOHeaderLineID(): ');
5913: inv_pp_debug.send_message_to_pipe('p_line_id: '|| p_line_id);
5914: inv_pp_debug.send_message_to_pipe('p_transaction_source_type_id: '|| p_transaction_source_type_id);
5915: inv_pp_debug.send_message_to_pipe('p_reference: '|| p_reference);
5916: inv_pp_debug.send_message_to_pipe('p_reference_id: '|| p_reference_id);

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

5909: --inv_pp_debug.set_debug_pipe_name('htnguyen');
5910:
5911: IF inv_pp_debug.is_debug_mode THEN
5912: inv_pp_debug.send_message_to_pipe('GetSOHeaderLineID(): ');
5913: inv_pp_debug.send_message_to_pipe('p_line_id: '|| p_line_id);
5914: inv_pp_debug.send_message_to_pipe('p_transaction_source_type_id: '|| p_transaction_source_type_id);
5915: inv_pp_debug.send_message_to_pipe('p_reference: '|| p_reference);
5916: inv_pp_debug.send_message_to_pipe('p_reference_id: '|| p_reference_id);
5917: inv_pp_debug.send_message_to_pipe('p_header_flag: '|| p_header_flag);

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

5910:
5911: IF inv_pp_debug.is_debug_mode THEN
5912: inv_pp_debug.send_message_to_pipe('GetSOHeaderLineID(): ');
5913: inv_pp_debug.send_message_to_pipe('p_line_id: '|| p_line_id);
5914: inv_pp_debug.send_message_to_pipe('p_transaction_source_type_id: '|| p_transaction_source_type_id);
5915: inv_pp_debug.send_message_to_pipe('p_reference: '|| p_reference);
5916: inv_pp_debug.send_message_to_pipe('p_reference_id: '|| p_reference_id);
5917: inv_pp_debug.send_message_to_pipe('p_header_flag: '|| p_header_flag);
5918: inv_pp_debug.send_message_to_pipe('p_line_flag: '|| p_line_flag);

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

5911: IF inv_pp_debug.is_debug_mode THEN
5912: inv_pp_debug.send_message_to_pipe('GetSOHeaderLineID(): ');
5913: inv_pp_debug.send_message_to_pipe('p_line_id: '|| p_line_id);
5914: inv_pp_debug.send_message_to_pipe('p_transaction_source_type_id: '|| p_transaction_source_type_id);
5915: inv_pp_debug.send_message_to_pipe('p_reference: '|| p_reference);
5916: inv_pp_debug.send_message_to_pipe('p_reference_id: '|| p_reference_id);
5917: inv_pp_debug.send_message_to_pipe('p_header_flag: '|| p_header_flag);
5918: inv_pp_debug.send_message_to_pipe('p_line_flag: '|| p_line_flag);
5919: END IF;

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

5912: inv_pp_debug.send_message_to_pipe('GetSOHeaderLineID(): ');
5913: inv_pp_debug.send_message_to_pipe('p_line_id: '|| p_line_id);
5914: inv_pp_debug.send_message_to_pipe('p_transaction_source_type_id: '|| p_transaction_source_type_id);
5915: inv_pp_debug.send_message_to_pipe('p_reference: '|| p_reference);
5916: inv_pp_debug.send_message_to_pipe('p_reference_id: '|| p_reference_id);
5917: inv_pp_debug.send_message_to_pipe('p_header_flag: '|| p_header_flag);
5918: inv_pp_debug.send_message_to_pipe('p_line_flag: '|| p_line_flag);
5919: END IF;
5920:

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

5913: inv_pp_debug.send_message_to_pipe('p_line_id: '|| p_line_id);
5914: inv_pp_debug.send_message_to_pipe('p_transaction_source_type_id: '|| p_transaction_source_type_id);
5915: inv_pp_debug.send_message_to_pipe('p_reference: '|| p_reference);
5916: inv_pp_debug.send_message_to_pipe('p_reference_id: '|| p_reference_id);
5917: inv_pp_debug.send_message_to_pipe('p_header_flag: '|| p_header_flag);
5918: inv_pp_debug.send_message_to_pipe('p_line_flag: '|| p_line_flag);
5919: END IF;
5920:
5921: -- RMA = 12

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

5914: inv_pp_debug.send_message_to_pipe('p_transaction_source_type_id: '|| p_transaction_source_type_id);
5915: inv_pp_debug.send_message_to_pipe('p_reference: '|| p_reference);
5916: inv_pp_debug.send_message_to_pipe('p_reference_id: '|| p_reference_id);
5917: inv_pp_debug.send_message_to_pipe('p_header_flag: '|| p_header_flag);
5918: inv_pp_debug.send_message_to_pipe('p_line_flag: '|| p_line_flag);
5919: END IF;
5920:
5921: -- RMA = 12
5922: -- BUG 3205362 - For performance reasons cache the in parameters and results of this function

Line 5968: IF inv_pp_debug.is_debug_mode THEN

5964: END IF;
5965: l_line_id := g_gsohl_line_id;
5966: l_header_id := g_gsohl_header_id;
5967:
5968: IF inv_pp_debug.is_debug_mode THEN
5969: inv_pp_debug.send_message_to_pipe('l_header_id : '|| l_header_id);
5970: inv_pp_debug.send_message_to_pipe('l_line_id : '|| l_line_id);
5971: END IF;
5972:

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

5965: l_line_id := g_gsohl_line_id;
5966: l_header_id := g_gsohl_header_id;
5967:
5968: IF inv_pp_debug.is_debug_mode THEN
5969: inv_pp_debug.send_message_to_pipe('l_header_id : '|| l_header_id);
5970: inv_pp_debug.send_message_to_pipe('l_line_id : '|| l_line_id);
5971: END IF;
5972:
5973: IF (p_header_flag = 'Y') THEN

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

5966: l_header_id := g_gsohl_header_id;
5967:
5968: IF inv_pp_debug.is_debug_mode THEN
5969: inv_pp_debug.send_message_to_pipe('l_header_id : '|| l_header_id);
5970: inv_pp_debug.send_message_to_pipe('l_line_id : '|| l_line_id);
5971: END IF;
5972:
5973: IF (p_header_flag = 'Y') THEN
5974: l_return_val := l_header_id;