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_DETAIL_UTIL_PVT dependencies on INV_PP_DEBUG

Line 219: IF inv_pp_debug.is_debug_mode THEN

215: BEGIN
216: --
217: -- debugging section
218: -- can be commented ut for final code
219: IF inv_pp_debug.is_debug_mode THEN
220: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
221: END IF;
222: -- end of debugging section
223: --

Line 220: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);

216: --
217: -- debugging section
218: -- can be commented ut for final code
219: IF inv_pp_debug.is_debug_mode THEN
220: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
221: END IF;
222: -- end of debugging section
223: --
224: x_return_status := fnd_api.g_ret_sts_success;

Line 235: IF inv_pp_debug.is_debug_mode THEN

231: WHEN timeout_on_resource THEN
232: --
233: -- debugging section
234: -- can be commented ut for final code
235: IF inv_pp_debug.is_debug_mode THEN
236: inv_pp_debug.send_message_to_pipe('can not lock the move order line record');
237: END IF;
238: -- end of debugging section
239: --

Line 236: inv_pp_debug.send_message_to_pipe('can not lock the move order line record');

232: --
233: -- debugging section
234: -- can be commented ut for final code
235: IF inv_pp_debug.is_debug_mode THEN
236: inv_pp_debug.send_message_to_pipe('can not lock the move order line record');
237: END IF;
238: -- end of debugging section
239: --
240: RAISE timeout_on_resource;

Line 246: IF inv_pp_debug.is_debug_mode THEN

242: END;
243: print_debug('after fething req line');
244: IF l_req_csr%notfound THEN
245: print_debug('mo line not found ');
246: IF inv_pp_debug.is_debug_mode THEN
247: inv_pp_debug.send_message_to_pipe('mo line not found');
248: END IF;
249: fnd_message.set_name('INV','INV_PP_INPUT_LINE_NOTFOUND');
250: fnd_message.set_token

Line 247: inv_pp_debug.send_message_to_pipe('mo line not found');

243: print_debug('after fething req line');
244: IF l_req_csr%notfound THEN
245: print_debug('mo line not found ');
246: IF inv_pp_debug.is_debug_mode THEN
247: inv_pp_debug.send_message_to_pipe('mo line not found');
248: END IF;
249: fnd_message.set_name('INV','INV_PP_INPUT_LINE_NOTFOUND');
250: fnd_message.set_token
251: ('LINE_ID',fnd_number.number_to_canonical(p_move_order_line_id));

Line 286: IF inv_pp_debug.is_debug_mode THEN

282: l_end_assembly_pegging_flag := NVL(inv_cache.item_rec.end_assembly_pegging_flag,'N');
283: l_allocate_serial_flag := inv_cache.org_rec.allocate_serial_flag;
284: ELSE
285: print_debug('init request_context no data found');
286: IF inv_pp_debug.is_debug_mode THEN
287: inv_pp_debug.send_message_to_pipe('mo context not found');
288: END IF;
289: RAISE no_data_found;
290: END IF;

Line 287: inv_pp_debug.send_message_to_pipe('mo context not found');

283: l_allocate_serial_flag := inv_cache.org_rec.allocate_serial_flag;
284: ELSE
285: print_debug('init request_context no data found');
286: IF inv_pp_debug.is_debug_mode THEN
287: inv_pp_debug.send_message_to_pipe('mo context not found');
288: END IF;
289: RAISE no_data_found;
290: END IF;
291: print_debug('after init request_context ');

Line 467: IF inv_pp_debug.is_debug_mode THEN

463: x_request_context.ship_to_location,
464: x_request_context.shipment_number,
465: x_request_context.freight_code;
466: IF l_ship_info_csr%notfound THEN
467: IF inv_pp_debug.is_debug_mode THEN
468: inv_pp_debug.send_message_to_pipe('mo shipping not found');
469: inv_pp_debug.send_message_to_pipe('trans source type:' || x_request_line_rec.transaction_source_type_id);
470: END IF;
471: CLOSE l_ship_info_csr;

Line 468: inv_pp_debug.send_message_to_pipe('mo shipping not found');

464: x_request_context.shipment_number,
465: x_request_context.freight_code;
466: IF l_ship_info_csr%notfound THEN
467: IF inv_pp_debug.is_debug_mode THEN
468: inv_pp_debug.send_message_to_pipe('mo shipping not found');
469: inv_pp_debug.send_message_to_pipe('trans source type:' || x_request_line_rec.transaction_source_type_id);
470: END IF;
471: CLOSE l_ship_info_csr;
472: -- bug 5677255, keep the source_type_id for reservations

Line 469: inv_pp_debug.send_message_to_pipe('trans source type:' || x_request_line_rec.transaction_source_type_id);

465: x_request_context.freight_code;
466: IF l_ship_info_csr%notfound THEN
467: IF inv_pp_debug.is_debug_mode THEN
468: inv_pp_debug.send_message_to_pipe('mo shipping not found');
469: inv_pp_debug.send_message_to_pipe('trans source type:' || x_request_line_rec.transaction_source_type_id);
470: END IF;
471: CLOSE l_ship_info_csr;
472: -- bug 5677255, keep the source_type_id for reservations
473: If x_request_line_rec.reference = 'ORDER_LINE_ID_RSV' Then

Line 486: IF inv_pp_debug.is_debug_mode THEN

482: x_request_context.ship_to_location,
483: x_request_context.shipment_number,
484: x_request_context.freight_code;
485: IF l_ship_info_csr%notfound THEN
486: IF inv_pp_debug.is_debug_mode THEN
487: inv_pp_debug.send_message_to_pipe('reservation mo order line not found');
488: inv_pp_debug.send_message_to_pipe('trans source type:' || x_request_line_rec.transaction_source_type_id);
489: END IF;
490: CLOSE l_order_info_csr;

Line 487: inv_pp_debug.send_message_to_pipe('reservation mo order line not found');

483: x_request_context.shipment_number,
484: x_request_context.freight_code;
485: IF l_ship_info_csr%notfound THEN
486: IF inv_pp_debug.is_debug_mode THEN
487: inv_pp_debug.send_message_to_pipe('reservation mo order line not found');
488: inv_pp_debug.send_message_to_pipe('trans source type:' || x_request_line_rec.transaction_source_type_id);
489: END IF;
490: CLOSE l_order_info_csr;
491: RAISE no_data_found;

Line 488: inv_pp_debug.send_message_to_pipe('trans source type:' || x_request_line_rec.transaction_source_type_id);

484: x_request_context.freight_code;
485: IF l_ship_info_csr%notfound THEN
486: IF inv_pp_debug.is_debug_mode THEN
487: inv_pp_debug.send_message_to_pipe('reservation mo order line not found');
488: inv_pp_debug.send_message_to_pipe('trans source type:' || x_request_line_rec.transaction_source_type_id);
489: END IF;
490: CLOSE l_order_info_csr;
491: RAISE no_data_found;
492: End if;

Line 529: IF inv_pp_debug.is_debug_mode THEN

525: x_request_context.ship_to_location,
526: x_request_context.shipment_number,
527: x_request_context.freight_code;
528: IF l_rma_info_csr%notfound THEN
529: IF inv_pp_debug.is_debug_mode THEN
530: inv_pp_debug.send_message_to_pipe('rma info not found');
531: inv_pp_debug.send_message_to_pipe('trans source type:' || x_request_line_rec.transaction_source_type_id);
532: END IF;
533: CLOSE l_rma_info_csr;

Line 530: inv_pp_debug.send_message_to_pipe('rma info not found');

526: x_request_context.shipment_number,
527: x_request_context.freight_code;
528: IF l_rma_info_csr%notfound THEN
529: IF inv_pp_debug.is_debug_mode THEN
530: inv_pp_debug.send_message_to_pipe('rma info not found');
531: inv_pp_debug.send_message_to_pipe('trans source type:' || x_request_line_rec.transaction_source_type_id);
532: END IF;
533: CLOSE l_rma_info_csr;
534: RAISE no_data_found;

Line 531: inv_pp_debug.send_message_to_pipe('trans source type:' || x_request_line_rec.transaction_source_type_id);

527: x_request_context.freight_code;
528: IF l_rma_info_csr%notfound THEN
529: IF inv_pp_debug.is_debug_mode THEN
530: inv_pp_debug.send_message_to_pipe('rma info not found');
531: inv_pp_debug.send_message_to_pipe('trans source type:' || x_request_line_rec.transaction_source_type_id);
532: END IF;
533: CLOSE l_rma_info_csr;
534: RAISE no_data_found;
535: END IF;

Line 629: IF inv_pp_debug.is_debug_mode THEN

625:
626: --
627: -- debugging section
628: -- can be commented ut for final code
629: IF inv_pp_debug.is_debug_mode THEN
630: inv_pp_debug.send_message_to_pipe
631: ('======== Move Order Line Information ========');
632: inv_pp_debug.send_message_to_pipe('line_id '
633: || x_request_line_rec.line_id);

Line 630: inv_pp_debug.send_message_to_pipe

626: --
627: -- debugging section
628: -- can be commented ut for final code
629: IF inv_pp_debug.is_debug_mode THEN
630: inv_pp_debug.send_message_to_pipe
631: ('======== Move Order Line Information ========');
632: inv_pp_debug.send_message_to_pipe('line_id '
633: || x_request_line_rec.line_id);
634: inv_pp_debug.send_message_to_pipe('header_id '

Line 632: inv_pp_debug.send_message_to_pipe('line_id '

628: -- can be commented ut for final code
629: IF inv_pp_debug.is_debug_mode THEN
630: inv_pp_debug.send_message_to_pipe
631: ('======== Move Order Line Information ========');
632: inv_pp_debug.send_message_to_pipe('line_id '
633: || x_request_line_rec.line_id);
634: inv_pp_debug.send_message_to_pipe('header_id '
635: || x_request_line_rec.header_id);
636: inv_pp_debug.send_message_to_pipe('line_number '

Line 634: inv_pp_debug.send_message_to_pipe('header_id '

630: inv_pp_debug.send_message_to_pipe
631: ('======== Move Order Line Information ========');
632: inv_pp_debug.send_message_to_pipe('line_id '
633: || x_request_line_rec.line_id);
634: inv_pp_debug.send_message_to_pipe('header_id '
635: || x_request_line_rec.header_id);
636: inv_pp_debug.send_message_to_pipe('line_number '
637: || x_request_line_rec.line_number);
638: inv_pp_debug.send_message_to_pipe('organization_id '

Line 636: inv_pp_debug.send_message_to_pipe('line_number '

632: inv_pp_debug.send_message_to_pipe('line_id '
633: || x_request_line_rec.line_id);
634: inv_pp_debug.send_message_to_pipe('header_id '
635: || x_request_line_rec.header_id);
636: inv_pp_debug.send_message_to_pipe('line_number '
637: || x_request_line_rec.line_number);
638: inv_pp_debug.send_message_to_pipe('organization_id '
639: || x_request_line_rec.organization_id);
640: inv_pp_debug.send_message_to_pipe('inventory_item_id '

Line 638: inv_pp_debug.send_message_to_pipe('organization_id '

634: inv_pp_debug.send_message_to_pipe('header_id '
635: || x_request_line_rec.header_id);
636: inv_pp_debug.send_message_to_pipe('line_number '
637: || x_request_line_rec.line_number);
638: inv_pp_debug.send_message_to_pipe('organization_id '
639: || x_request_line_rec.organization_id);
640: inv_pp_debug.send_message_to_pipe('inventory_item_id '
641: || x_request_line_rec.inventory_item_id);
642: inv_pp_debug.send_message_to_pipe('revision '

Line 640: inv_pp_debug.send_message_to_pipe('inventory_item_id '

636: inv_pp_debug.send_message_to_pipe('line_number '
637: || x_request_line_rec.line_number);
638: inv_pp_debug.send_message_to_pipe('organization_id '
639: || x_request_line_rec.organization_id);
640: inv_pp_debug.send_message_to_pipe('inventory_item_id '
641: || x_request_line_rec.inventory_item_id);
642: inv_pp_debug.send_message_to_pipe('revision '
643: || x_request_line_rec.revision);
644: inv_pp_debug.send_message_to_pipe('from_subinventory_id '

Line 642: inv_pp_debug.send_message_to_pipe('revision '

638: inv_pp_debug.send_message_to_pipe('organization_id '
639: || x_request_line_rec.organization_id);
640: inv_pp_debug.send_message_to_pipe('inventory_item_id '
641: || x_request_line_rec.inventory_item_id);
642: inv_pp_debug.send_message_to_pipe('revision '
643: || x_request_line_rec.revision);
644: inv_pp_debug.send_message_to_pipe('from_subinventory_id '
645: || x_request_line_rec.from_subinventory_id);
646: inv_pp_debug.send_message_to_pipe('from_subinventory_code '

Line 644: inv_pp_debug.send_message_to_pipe('from_subinventory_id '

640: inv_pp_debug.send_message_to_pipe('inventory_item_id '
641: || x_request_line_rec.inventory_item_id);
642: inv_pp_debug.send_message_to_pipe('revision '
643: || x_request_line_rec.revision);
644: inv_pp_debug.send_message_to_pipe('from_subinventory_id '
645: || x_request_line_rec.from_subinventory_id);
646: inv_pp_debug.send_message_to_pipe('from_subinventory_code '
647: || x_request_line_rec.from_subinventory_code);
648: inv_pp_debug.send_message_to_pipe('from_locator_id '

Line 646: inv_pp_debug.send_message_to_pipe('from_subinventory_code '

642: inv_pp_debug.send_message_to_pipe('revision '
643: || x_request_line_rec.revision);
644: inv_pp_debug.send_message_to_pipe('from_subinventory_id '
645: || x_request_line_rec.from_subinventory_id);
646: inv_pp_debug.send_message_to_pipe('from_subinventory_code '
647: || x_request_line_rec.from_subinventory_code);
648: inv_pp_debug.send_message_to_pipe('from_locator_id '
649: || x_request_line_rec.from_locator_id);
650: inv_pp_debug.send_message_to_pipe('to_subinventory_code '

Line 648: inv_pp_debug.send_message_to_pipe('from_locator_id '

644: inv_pp_debug.send_message_to_pipe('from_subinventory_id '
645: || x_request_line_rec.from_subinventory_id);
646: inv_pp_debug.send_message_to_pipe('from_subinventory_code '
647: || x_request_line_rec.from_subinventory_code);
648: inv_pp_debug.send_message_to_pipe('from_locator_id '
649: || x_request_line_rec.from_locator_id);
650: inv_pp_debug.send_message_to_pipe('to_subinventory_code '
651: || x_request_line_rec.to_subinventory_code);
652: inv_pp_debug.send_message_to_pipe('to_subinventory_id '

Line 650: inv_pp_debug.send_message_to_pipe('to_subinventory_code '

646: inv_pp_debug.send_message_to_pipe('from_subinventory_code '
647: || x_request_line_rec.from_subinventory_code);
648: inv_pp_debug.send_message_to_pipe('from_locator_id '
649: || x_request_line_rec.from_locator_id);
650: inv_pp_debug.send_message_to_pipe('to_subinventory_code '
651: || x_request_line_rec.to_subinventory_code);
652: inv_pp_debug.send_message_to_pipe('to_subinventory_id '
653: || x_request_line_rec.to_subinventory_id);
654: inv_pp_debug.send_message_to_pipe('to_locator_id '

Line 652: inv_pp_debug.send_message_to_pipe('to_subinventory_id '

648: inv_pp_debug.send_message_to_pipe('from_locator_id '
649: || x_request_line_rec.from_locator_id);
650: inv_pp_debug.send_message_to_pipe('to_subinventory_code '
651: || x_request_line_rec.to_subinventory_code);
652: inv_pp_debug.send_message_to_pipe('to_subinventory_id '
653: || x_request_line_rec.to_subinventory_id);
654: inv_pp_debug.send_message_to_pipe('to_locator_id '
655: || x_request_line_rec.to_locator_id);
656: inv_pp_debug.send_message_to_pipe('to_account_id '

Line 654: inv_pp_debug.send_message_to_pipe('to_locator_id '

650: inv_pp_debug.send_message_to_pipe('to_subinventory_code '
651: || x_request_line_rec.to_subinventory_code);
652: inv_pp_debug.send_message_to_pipe('to_subinventory_id '
653: || x_request_line_rec.to_subinventory_id);
654: inv_pp_debug.send_message_to_pipe('to_locator_id '
655: || x_request_line_rec.to_locator_id);
656: inv_pp_debug.send_message_to_pipe('to_account_id '
657: || x_request_line_rec.to_account_id);
658: inv_pp_debug.send_message_to_pipe('lot_number '

Line 656: inv_pp_debug.send_message_to_pipe('to_account_id '

652: inv_pp_debug.send_message_to_pipe('to_subinventory_id '
653: || x_request_line_rec.to_subinventory_id);
654: inv_pp_debug.send_message_to_pipe('to_locator_id '
655: || x_request_line_rec.to_locator_id);
656: inv_pp_debug.send_message_to_pipe('to_account_id '
657: || x_request_line_rec.to_account_id);
658: inv_pp_debug.send_message_to_pipe('lot_number '
659: || x_request_line_rec.lot_number);
660: inv_pp_debug.send_message_to_pipe('serial_number_start '

Line 658: inv_pp_debug.send_message_to_pipe('lot_number '

654: inv_pp_debug.send_message_to_pipe('to_locator_id '
655: || x_request_line_rec.to_locator_id);
656: inv_pp_debug.send_message_to_pipe('to_account_id '
657: || x_request_line_rec.to_account_id);
658: inv_pp_debug.send_message_to_pipe('lot_number '
659: || x_request_line_rec.lot_number);
660: inv_pp_debug.send_message_to_pipe('serial_number_start '
661: || x_request_line_rec.serial_number_start);
662: inv_pp_debug.send_message_to_pipe('serial_number_end '

Line 660: inv_pp_debug.send_message_to_pipe('serial_number_start '

656: inv_pp_debug.send_message_to_pipe('to_account_id '
657: || x_request_line_rec.to_account_id);
658: inv_pp_debug.send_message_to_pipe('lot_number '
659: || x_request_line_rec.lot_number);
660: inv_pp_debug.send_message_to_pipe('serial_number_start '
661: || x_request_line_rec.serial_number_start);
662: inv_pp_debug.send_message_to_pipe('serial_number_end '
663: || x_request_line_rec.serial_number_end);
664: inv_pp_debug.send_message_to_pipe('uom_code '

Line 662: inv_pp_debug.send_message_to_pipe('serial_number_end '

658: inv_pp_debug.send_message_to_pipe('lot_number '
659: || x_request_line_rec.lot_number);
660: inv_pp_debug.send_message_to_pipe('serial_number_start '
661: || x_request_line_rec.serial_number_start);
662: inv_pp_debug.send_message_to_pipe('serial_number_end '
663: || x_request_line_rec.serial_number_end);
664: inv_pp_debug.send_message_to_pipe('uom_code '
665: || x_request_line_rec.uom_code);
666: inv_pp_debug.send_message_to_pipe('quantity '

Line 664: inv_pp_debug.send_message_to_pipe('uom_code '

660: inv_pp_debug.send_message_to_pipe('serial_number_start '
661: || x_request_line_rec.serial_number_start);
662: inv_pp_debug.send_message_to_pipe('serial_number_end '
663: || x_request_line_rec.serial_number_end);
664: inv_pp_debug.send_message_to_pipe('uom_code '
665: || x_request_line_rec.uom_code);
666: inv_pp_debug.send_message_to_pipe('quantity '
667: || x_request_line_rec.quantity);
668: inv_pp_debug.send_message_to_pipe('quantity_delivered '

Line 666: inv_pp_debug.send_message_to_pipe('quantity '

662: inv_pp_debug.send_message_to_pipe('serial_number_end '
663: || x_request_line_rec.serial_number_end);
664: inv_pp_debug.send_message_to_pipe('uom_code '
665: || x_request_line_rec.uom_code);
666: inv_pp_debug.send_message_to_pipe('quantity '
667: || x_request_line_rec.quantity);
668: inv_pp_debug.send_message_to_pipe('quantity_delivered '
669: || x_request_line_rec.quantity_delivered);
670: inv_pp_debug.send_message_to_pipe('quantity_detailed '

Line 668: inv_pp_debug.send_message_to_pipe('quantity_delivered '

664: inv_pp_debug.send_message_to_pipe('uom_code '
665: || x_request_line_rec.uom_code);
666: inv_pp_debug.send_message_to_pipe('quantity '
667: || x_request_line_rec.quantity);
668: inv_pp_debug.send_message_to_pipe('quantity_delivered '
669: || x_request_line_rec.quantity_delivered);
670: inv_pp_debug.send_message_to_pipe('quantity_detailed '
671: || x_request_line_rec.quantity_detailed);
672: inv_pp_debug.send_message_to_pipe('date_required '

Line 670: inv_pp_debug.send_message_to_pipe('quantity_detailed '

666: inv_pp_debug.send_message_to_pipe('quantity '
667: || x_request_line_rec.quantity);
668: inv_pp_debug.send_message_to_pipe('quantity_delivered '
669: || x_request_line_rec.quantity_delivered);
670: inv_pp_debug.send_message_to_pipe('quantity_detailed '
671: || x_request_line_rec.quantity_detailed);
672: inv_pp_debug.send_message_to_pipe('date_required '
673: || x_request_line_rec.date_required);
674: inv_pp_debug.send_message_to_pipe('reason_id '

Line 672: inv_pp_debug.send_message_to_pipe('date_required '

668: inv_pp_debug.send_message_to_pipe('quantity_delivered '
669: || x_request_line_rec.quantity_delivered);
670: inv_pp_debug.send_message_to_pipe('quantity_detailed '
671: || x_request_line_rec.quantity_detailed);
672: inv_pp_debug.send_message_to_pipe('date_required '
673: || x_request_line_rec.date_required);
674: inv_pp_debug.send_message_to_pipe('reason_id '
675: || x_request_line_rec.reason_id);
676: inv_pp_debug.send_message_to_pipe('reference '

Line 674: inv_pp_debug.send_message_to_pipe('reason_id '

670: inv_pp_debug.send_message_to_pipe('quantity_detailed '
671: || x_request_line_rec.quantity_detailed);
672: inv_pp_debug.send_message_to_pipe('date_required '
673: || x_request_line_rec.date_required);
674: inv_pp_debug.send_message_to_pipe('reason_id '
675: || x_request_line_rec.reason_id);
676: inv_pp_debug.send_message_to_pipe('reference '
677: || x_request_line_rec.reference);
678: inv_pp_debug.send_message_to_pipe('reference_type_code '

Line 676: inv_pp_debug.send_message_to_pipe('reference '

672: inv_pp_debug.send_message_to_pipe('date_required '
673: || x_request_line_rec.date_required);
674: inv_pp_debug.send_message_to_pipe('reason_id '
675: || x_request_line_rec.reason_id);
676: inv_pp_debug.send_message_to_pipe('reference '
677: || x_request_line_rec.reference);
678: inv_pp_debug.send_message_to_pipe('reference_type_code '
679: || x_request_line_rec.reference_type_code);
680: inv_pp_debug.send_message_to_pipe('reference_id '

Line 678: inv_pp_debug.send_message_to_pipe('reference_type_code '

674: inv_pp_debug.send_message_to_pipe('reason_id '
675: || x_request_line_rec.reason_id);
676: inv_pp_debug.send_message_to_pipe('reference '
677: || x_request_line_rec.reference);
678: inv_pp_debug.send_message_to_pipe('reference_type_code '
679: || x_request_line_rec.reference_type_code);
680: inv_pp_debug.send_message_to_pipe('reference_id '
681: || x_request_line_rec.reference_id);
682: inv_pp_debug.send_message_to_pipe('project_id '

Line 680: inv_pp_debug.send_message_to_pipe('reference_id '

676: inv_pp_debug.send_message_to_pipe('reference '
677: || x_request_line_rec.reference);
678: inv_pp_debug.send_message_to_pipe('reference_type_code '
679: || x_request_line_rec.reference_type_code);
680: inv_pp_debug.send_message_to_pipe('reference_id '
681: || x_request_line_rec.reference_id);
682: inv_pp_debug.send_message_to_pipe('project_id '
683: || x_request_line_rec.project_id);
684: inv_pp_debug.send_message_to_pipe('task_id '

Line 682: inv_pp_debug.send_message_to_pipe('project_id '

678: inv_pp_debug.send_message_to_pipe('reference_type_code '
679: || x_request_line_rec.reference_type_code);
680: inv_pp_debug.send_message_to_pipe('reference_id '
681: || x_request_line_rec.reference_id);
682: inv_pp_debug.send_message_to_pipe('project_id '
683: || x_request_line_rec.project_id);
684: inv_pp_debug.send_message_to_pipe('task_id '
685: || x_request_line_rec.task_id);
686: inv_pp_debug.send_message_to_pipe('transaction_header_id '

Line 684: inv_pp_debug.send_message_to_pipe('task_id '

680: inv_pp_debug.send_message_to_pipe('reference_id '
681: || x_request_line_rec.reference_id);
682: inv_pp_debug.send_message_to_pipe('project_id '
683: || x_request_line_rec.project_id);
684: inv_pp_debug.send_message_to_pipe('task_id '
685: || x_request_line_rec.task_id);
686: inv_pp_debug.send_message_to_pipe('transaction_header_id '
687: || x_request_line_rec.transaction_header_id);
688: inv_pp_debug.send_message_to_pipe('line_status '

Line 686: inv_pp_debug.send_message_to_pipe('transaction_header_id '

682: inv_pp_debug.send_message_to_pipe('project_id '
683: || x_request_line_rec.project_id);
684: inv_pp_debug.send_message_to_pipe('task_id '
685: || x_request_line_rec.task_id);
686: inv_pp_debug.send_message_to_pipe('transaction_header_id '
687: || x_request_line_rec.transaction_header_id);
688: inv_pp_debug.send_message_to_pipe('line_status '
689: || x_request_line_rec.line_status);
690: inv_pp_debug.send_message_to_pipe('status_date '

Line 688: inv_pp_debug.send_message_to_pipe('line_status '

684: inv_pp_debug.send_message_to_pipe('task_id '
685: || x_request_line_rec.task_id);
686: inv_pp_debug.send_message_to_pipe('transaction_header_id '
687: || x_request_line_rec.transaction_header_id);
688: inv_pp_debug.send_message_to_pipe('line_status '
689: || x_request_line_rec.line_status);
690: inv_pp_debug.send_message_to_pipe('status_date '
691: || x_request_line_rec.status_date);
692: inv_pp_debug.send_message_to_pipe('txn_source_id '

Line 690: inv_pp_debug.send_message_to_pipe('status_date '

686: inv_pp_debug.send_message_to_pipe('transaction_header_id '
687: || x_request_line_rec.transaction_header_id);
688: inv_pp_debug.send_message_to_pipe('line_status '
689: || x_request_line_rec.line_status);
690: inv_pp_debug.send_message_to_pipe('status_date '
691: || x_request_line_rec.status_date);
692: inv_pp_debug.send_message_to_pipe('txn_source_id '
693: || x_request_line_rec.txn_source_id);
694: inv_pp_debug.send_message_to_pipe('txn_source_line_id '

Line 692: inv_pp_debug.send_message_to_pipe('txn_source_id '

688: inv_pp_debug.send_message_to_pipe('line_status '
689: || x_request_line_rec.line_status);
690: inv_pp_debug.send_message_to_pipe('status_date '
691: || x_request_line_rec.status_date);
692: inv_pp_debug.send_message_to_pipe('txn_source_id '
693: || x_request_line_rec.txn_source_id);
694: inv_pp_debug.send_message_to_pipe('txn_source_line_id '
695: || x_request_line_rec.txn_source_line_id);
696: inv_pp_debug.send_message_to_pipe('txn_source_line_detail_id '

Line 694: inv_pp_debug.send_message_to_pipe('txn_source_line_id '

690: inv_pp_debug.send_message_to_pipe('status_date '
691: || x_request_line_rec.status_date);
692: inv_pp_debug.send_message_to_pipe('txn_source_id '
693: || x_request_line_rec.txn_source_id);
694: inv_pp_debug.send_message_to_pipe('txn_source_line_id '
695: || x_request_line_rec.txn_source_line_id);
696: inv_pp_debug.send_message_to_pipe('txn_source_line_detail_id '
697: || x_request_line_rec.txn_source_line_detail_id);
698: inv_pp_debug.send_message_to_pipe('transaction_type_id '

Line 696: inv_pp_debug.send_message_to_pipe('txn_source_line_detail_id '

692: inv_pp_debug.send_message_to_pipe('txn_source_id '
693: || x_request_line_rec.txn_source_id);
694: inv_pp_debug.send_message_to_pipe('txn_source_line_id '
695: || x_request_line_rec.txn_source_line_id);
696: inv_pp_debug.send_message_to_pipe('txn_source_line_detail_id '
697: || x_request_line_rec.txn_source_line_detail_id);
698: inv_pp_debug.send_message_to_pipe('transaction_type_id '
699: || x_request_line_rec.transaction_type_id);
700: inv_pp_debug.send_message_to_pipe('transaction_source_type_id '

Line 698: inv_pp_debug.send_message_to_pipe('transaction_type_id '

694: inv_pp_debug.send_message_to_pipe('txn_source_line_id '
695: || x_request_line_rec.txn_source_line_id);
696: inv_pp_debug.send_message_to_pipe('txn_source_line_detail_id '
697: || x_request_line_rec.txn_source_line_detail_id);
698: inv_pp_debug.send_message_to_pipe('transaction_type_id '
699: || x_request_line_rec.transaction_type_id);
700: inv_pp_debug.send_message_to_pipe('transaction_source_type_id '
701: || x_request_line_rec.transaction_source_type_id);
702: inv_pp_debug.send_message_to_pipe('primary_quantity '

Line 700: inv_pp_debug.send_message_to_pipe('transaction_source_type_id '

696: inv_pp_debug.send_message_to_pipe('txn_source_line_detail_id '
697: || x_request_line_rec.txn_source_line_detail_id);
698: inv_pp_debug.send_message_to_pipe('transaction_type_id '
699: || x_request_line_rec.transaction_type_id);
700: inv_pp_debug.send_message_to_pipe('transaction_source_type_id '
701: || x_request_line_rec.transaction_source_type_id);
702: inv_pp_debug.send_message_to_pipe('primary_quantity '
703: || x_request_line_rec.primary_quantity);
704: inv_pp_debug.send_message_to_pipe('to_organization_id '

Line 702: inv_pp_debug.send_message_to_pipe('primary_quantity '

698: inv_pp_debug.send_message_to_pipe('transaction_type_id '
699: || x_request_line_rec.transaction_type_id);
700: inv_pp_debug.send_message_to_pipe('transaction_source_type_id '
701: || x_request_line_rec.transaction_source_type_id);
702: inv_pp_debug.send_message_to_pipe('primary_quantity '
703: || x_request_line_rec.primary_quantity);
704: inv_pp_debug.send_message_to_pipe('to_organization_id '
705: || x_request_line_rec.to_organization_id);
706: inv_pp_debug.send_message_to_pipe('put_away_strategy_id '

Line 704: inv_pp_debug.send_message_to_pipe('to_organization_id '

700: inv_pp_debug.send_message_to_pipe('transaction_source_type_id '
701: || x_request_line_rec.transaction_source_type_id);
702: inv_pp_debug.send_message_to_pipe('primary_quantity '
703: || x_request_line_rec.primary_quantity);
704: inv_pp_debug.send_message_to_pipe('to_organization_id '
705: || x_request_line_rec.to_organization_id);
706: inv_pp_debug.send_message_to_pipe('put_away_strategy_id '
707: || x_request_line_rec.put_away_strategy_id);
708: inv_pp_debug.send_message_to_pipe('pick_strategy_id '

Line 706: inv_pp_debug.send_message_to_pipe('put_away_strategy_id '

702: inv_pp_debug.send_message_to_pipe('primary_quantity '
703: || x_request_line_rec.primary_quantity);
704: inv_pp_debug.send_message_to_pipe('to_organization_id '
705: || x_request_line_rec.to_organization_id);
706: inv_pp_debug.send_message_to_pipe('put_away_strategy_id '
707: || x_request_line_rec.put_away_strategy_id);
708: inv_pp_debug.send_message_to_pipe('pick_strategy_id '
709: || x_request_line_rec.pick_strategy_id);
710: inv_pp_debug.send_message_to_pipe('unit_number '

Line 708: inv_pp_debug.send_message_to_pipe('pick_strategy_id '

704: inv_pp_debug.send_message_to_pipe('to_organization_id '
705: || x_request_line_rec.to_organization_id);
706: inv_pp_debug.send_message_to_pipe('put_away_strategy_id '
707: || x_request_line_rec.put_away_strategy_id);
708: inv_pp_debug.send_message_to_pipe('pick_strategy_id '
709: || x_request_line_rec.pick_strategy_id);
710: inv_pp_debug.send_message_to_pipe('unit_number '
711: || x_request_line_rec.unit_number);
712: inv_pp_debug.send_message_to_pipe

Line 710: inv_pp_debug.send_message_to_pipe('unit_number '

706: inv_pp_debug.send_message_to_pipe('put_away_strategy_id '
707: || x_request_line_rec.put_away_strategy_id);
708: inv_pp_debug.send_message_to_pipe('pick_strategy_id '
709: || x_request_line_rec.pick_strategy_id);
710: inv_pp_debug.send_message_to_pipe('unit_number '
711: || x_request_line_rec.unit_number);
712: inv_pp_debug.send_message_to_pipe
713: ('======== Request Context ========');
714: inv_pp_debug.send_message_to_pipe

Line 712: inv_pp_debug.send_message_to_pipe

708: inv_pp_debug.send_message_to_pipe('pick_strategy_id '
709: || x_request_line_rec.pick_strategy_id);
710: inv_pp_debug.send_message_to_pipe('unit_number '
711: || x_request_line_rec.unit_number);
712: inv_pp_debug.send_message_to_pipe
713: ('======== Request Context ========');
714: inv_pp_debug.send_message_to_pipe
715: ('type_code = '|| x_request_context.type_code);
716: IF x_request_context.transfer_flag THEN

Line 714: inv_pp_debug.send_message_to_pipe

710: inv_pp_debug.send_message_to_pipe('unit_number '
711: || x_request_line_rec.unit_number);
712: inv_pp_debug.send_message_to_pipe
713: ('======== Request Context ========');
714: inv_pp_debug.send_message_to_pipe
715: ('type_code = '|| x_request_context.type_code);
716: IF x_request_context.transfer_flag THEN
717: inv_pp_debug.send_message_to_pipe('transfer_flag = true');
718: ELSE

Line 717: inv_pp_debug.send_message_to_pipe('transfer_flag = true');

713: ('======== Request Context ========');
714: inv_pp_debug.send_message_to_pipe
715: ('type_code = '|| x_request_context.type_code);
716: IF x_request_context.transfer_flag THEN
717: inv_pp_debug.send_message_to_pipe('transfer_flag = true');
718: ELSE
719: inv_pp_debug.send_message_to_pipe('transfer_flag = false');
720: END IF;
721: inv_pp_debug.send_message_to_pipe

Line 719: inv_pp_debug.send_message_to_pipe('transfer_flag = false');

715: ('type_code = '|| x_request_context.type_code);
716: IF x_request_context.transfer_flag THEN
717: inv_pp_debug.send_message_to_pipe('transfer_flag = true');
718: ELSE
719: inv_pp_debug.send_message_to_pipe('transfer_flag = false');
720: END IF;
721: inv_pp_debug.send_message_to_pipe
722: ('transaction_action_id = '|| x_request_context.transaction_action_id);
723: inv_pp_debug.send_message_to_pipe

Line 721: inv_pp_debug.send_message_to_pipe

717: inv_pp_debug.send_message_to_pipe('transfer_flag = true');
718: ELSE
719: inv_pp_debug.send_message_to_pipe('transfer_flag = false');
720: END IF;
721: inv_pp_debug.send_message_to_pipe
722: ('transaction_action_id = '|| x_request_context.transaction_action_id);
723: inv_pp_debug.send_message_to_pipe
724: ('item_revision_control = '|| x_request_context.item_revision_control);
725: inv_pp_debug.send_message_to_pipe

Line 723: inv_pp_debug.send_message_to_pipe

719: inv_pp_debug.send_message_to_pipe('transfer_flag = false');
720: END IF;
721: inv_pp_debug.send_message_to_pipe
722: ('transaction_action_id = '|| x_request_context.transaction_action_id);
723: inv_pp_debug.send_message_to_pipe
724: ('item_revision_control = '|| x_request_context.item_revision_control);
725: inv_pp_debug.send_message_to_pipe
726: ('item_lot_control_code = '|| x_request_context.item_lot_control_code);
727: inv_pp_debug.send_message_to_pipe

Line 725: inv_pp_debug.send_message_to_pipe

721: inv_pp_debug.send_message_to_pipe
722: ('transaction_action_id = '|| x_request_context.transaction_action_id);
723: inv_pp_debug.send_message_to_pipe
724: ('item_revision_control = '|| x_request_context.item_revision_control);
725: inv_pp_debug.send_message_to_pipe
726: ('item_lot_control_code = '|| x_request_context.item_lot_control_code);
727: inv_pp_debug.send_message_to_pipe
728: ('item_serial_control_code = '|| x_request_context.item_serial_control_code);
729: inv_pp_debug.send_message_to_pipe

Line 727: inv_pp_debug.send_message_to_pipe

723: inv_pp_debug.send_message_to_pipe
724: ('item_revision_control = '|| x_request_context.item_revision_control);
725: inv_pp_debug.send_message_to_pipe
726: ('item_lot_control_code = '|| x_request_context.item_lot_control_code);
727: inv_pp_debug.send_message_to_pipe
728: ('item_serial_control_code = '|| x_request_context.item_serial_control_code);
729: inv_pp_debug.send_message_to_pipe
730: ('lot_expiration_date = '|| x_request_context.lot_expiration_date);
731: inv_pp_debug.send_message_to_pipe

Line 729: inv_pp_debug.send_message_to_pipe

725: inv_pp_debug.send_message_to_pipe
726: ('item_lot_control_code = '|| x_request_context.item_lot_control_code);
727: inv_pp_debug.send_message_to_pipe
728: ('item_serial_control_code = '|| x_request_context.item_serial_control_code);
729: inv_pp_debug.send_message_to_pipe
730: ('lot_expiration_date = '|| x_request_context.lot_expiration_date);
731: inv_pp_debug.send_message_to_pipe
732: ('primary_uom_code = '|| x_request_context.primary_uom_code);
733: inv_pp_debug.send_message_to_pipe

Line 731: inv_pp_debug.send_message_to_pipe

727: inv_pp_debug.send_message_to_pipe
728: ('item_serial_control_code = '|| x_request_context.item_serial_control_code);
729: inv_pp_debug.send_message_to_pipe
730: ('lot_expiration_date = '|| x_request_context.lot_expiration_date);
731: inv_pp_debug.send_message_to_pipe
732: ('primary_uom_code = '|| x_request_context.primary_uom_code);
733: inv_pp_debug.send_message_to_pipe
734: ('transaction_uom_code = '|| x_request_context.transaction_uom_code);
735: inv_pp_debug.send_message_to_pipe

Line 733: inv_pp_debug.send_message_to_pipe

729: inv_pp_debug.send_message_to_pipe
730: ('lot_expiration_date = '|| x_request_context.lot_expiration_date);
731: inv_pp_debug.send_message_to_pipe
732: ('primary_uom_code = '|| x_request_context.primary_uom_code);
733: inv_pp_debug.send_message_to_pipe
734: ('transaction_uom_code = '|| x_request_context.transaction_uom_code);
735: inv_pp_debug.send_message_to_pipe
736: ('pick_strategy_id = '|| x_request_context.pick_strategy_id);
737: inv_pp_debug.send_message_to_pipe

Line 735: inv_pp_debug.send_message_to_pipe

731: inv_pp_debug.send_message_to_pipe
732: ('primary_uom_code = '|| x_request_context.primary_uom_code);
733: inv_pp_debug.send_message_to_pipe
734: ('transaction_uom_code = '|| x_request_context.transaction_uom_code);
735: inv_pp_debug.send_message_to_pipe
736: ('pick_strategy_id = '|| x_request_context.pick_strategy_id);
737: inv_pp_debug.send_message_to_pipe
738: ('put_away_strategy_id = '|| x_request_context.put_away_strategy_id);
739: inv_pp_debug.send_message_to_pipe

Line 737: inv_pp_debug.send_message_to_pipe

733: inv_pp_debug.send_message_to_pipe
734: ('transaction_uom_code = '|| x_request_context.transaction_uom_code);
735: inv_pp_debug.send_message_to_pipe
736: ('pick_strategy_id = '|| x_request_context.pick_strategy_id);
737: inv_pp_debug.send_message_to_pipe
738: ('put_away_strategy_id = '|| x_request_context.put_away_strategy_id);
739: inv_pp_debug.send_message_to_pipe
740: ('txn_header_id = '|| x_request_context.txn_header_id);
741: inv_pp_debug.send_message_to_pipe

Line 739: inv_pp_debug.send_message_to_pipe

735: inv_pp_debug.send_message_to_pipe
736: ('pick_strategy_id = '|| x_request_context.pick_strategy_id);
737: inv_pp_debug.send_message_to_pipe
738: ('put_away_strategy_id = '|| x_request_context.put_away_strategy_id);
739: inv_pp_debug.send_message_to_pipe
740: ('txn_header_id = '|| x_request_context.txn_header_id);
741: inv_pp_debug.send_message_to_pipe
742: ('txn_line_id = '|| x_request_context.txn_line_id);
743: inv_pp_debug.send_message_to_pipe

Line 741: inv_pp_debug.send_message_to_pipe

737: inv_pp_debug.send_message_to_pipe
738: ('put_away_strategy_id = '|| x_request_context.put_away_strategy_id);
739: inv_pp_debug.send_message_to_pipe
740: ('txn_header_id = '|| x_request_context.txn_header_id);
741: inv_pp_debug.send_message_to_pipe
742: ('txn_line_id = '|| x_request_context.txn_line_id);
743: inv_pp_debug.send_message_to_pipe
744: ('txn_line_detail = '|| x_request_context.txn_line_detail);
745: inv_pp_debug.send_message_to_pipe

Line 743: inv_pp_debug.send_message_to_pipe

739: inv_pp_debug.send_message_to_pipe
740: ('txn_header_id = '|| x_request_context.txn_header_id);
741: inv_pp_debug.send_message_to_pipe
742: ('txn_line_id = '|| x_request_context.txn_line_id);
743: inv_pp_debug.send_message_to_pipe
744: ('txn_line_detail = '|| x_request_context.txn_line_detail);
745: inv_pp_debug.send_message_to_pipe
746: ('customer_id = '|| x_request_context.customer_id);
747: inv_pp_debug.send_message_to_pipe

Line 745: inv_pp_debug.send_message_to_pipe

741: inv_pp_debug.send_message_to_pipe
742: ('txn_line_id = '|| x_request_context.txn_line_id);
743: inv_pp_debug.send_message_to_pipe
744: ('txn_line_detail = '|| x_request_context.txn_line_detail);
745: inv_pp_debug.send_message_to_pipe
746: ('customer_id = '|| x_request_context.customer_id);
747: inv_pp_debug.send_message_to_pipe
748: ('customer_number = '|| x_request_context.customer_number);
749: inv_pp_debug.send_message_to_pipe

Line 747: inv_pp_debug.send_message_to_pipe

743: inv_pp_debug.send_message_to_pipe
744: ('txn_line_detail = '|| x_request_context.txn_line_detail);
745: inv_pp_debug.send_message_to_pipe
746: ('customer_id = '|| x_request_context.customer_id);
747: inv_pp_debug.send_message_to_pipe
748: ('customer_number = '|| x_request_context.customer_number);
749: inv_pp_debug.send_message_to_pipe
750: ('ship_to_location = '|| x_request_context.ship_to_location);
751: inv_pp_debug.send_message_to_pipe

Line 749: inv_pp_debug.send_message_to_pipe

745: inv_pp_debug.send_message_to_pipe
746: ('customer_id = '|| x_request_context.customer_id);
747: inv_pp_debug.send_message_to_pipe
748: ('customer_number = '|| x_request_context.customer_number);
749: inv_pp_debug.send_message_to_pipe
750: ('ship_to_location = '|| x_request_context.ship_to_location);
751: inv_pp_debug.send_message_to_pipe
752: ('shipment_number = '|| x_request_context.shipment_number);
753: inv_pp_debug.send_message_to_pipe

Line 751: inv_pp_debug.send_message_to_pipe

747: inv_pp_debug.send_message_to_pipe
748: ('customer_number = '|| x_request_context.customer_number);
749: inv_pp_debug.send_message_to_pipe
750: ('ship_to_location = '|| x_request_context.ship_to_location);
751: inv_pp_debug.send_message_to_pipe
752: ('shipment_number = '|| x_request_context.shipment_number);
753: inv_pp_debug.send_message_to_pipe
754: ('freight_code = '|| x_request_context.freight_code);
755: --

Line 753: inv_pp_debug.send_message_to_pipe

749: inv_pp_debug.send_message_to_pipe
750: ('ship_to_location = '|| x_request_context.ship_to_location);
751: inv_pp_debug.send_message_to_pipe
752: ('shipment_number = '|| x_request_context.shipment_number);
753: inv_pp_debug.send_message_to_pipe
754: ('freight_code = '|| x_request_context.freight_code);
755: --
756: inv_pp_debug.send_message_to_pipe
757: ('exit '||g_pkg_name||'.'||l_api_name);

Line 756: inv_pp_debug.send_message_to_pipe

752: ('shipment_number = '|| x_request_context.shipment_number);
753: inv_pp_debug.send_message_to_pipe
754: ('freight_code = '|| x_request_context.freight_code);
755: --
756: inv_pp_debug.send_message_to_pipe
757: ('exit '||g_pkg_name||'.'||l_api_name);
758: END IF;
759: -- end of debugging section
760: --

Line 766: IF inv_pp_debug.is_debug_mode THEN

762: WHEN fnd_api.g_exc_error THEN
763: --
764: -- debugging section
765: -- can be commented ut for final code
766: IF inv_pp_debug.is_debug_mode THEN
767: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
768: -- the message retrieved here since it is no longer on the stack
769: inv_pp_debug.set_last_error_message(Sqlerrm);
770: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 769: inv_pp_debug.set_last_error_message(Sqlerrm);

765: -- can be commented ut for final code
766: IF inv_pp_debug.is_debug_mode THEN
767: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
768: -- the message retrieved here since it is no longer on the stack
769: inv_pp_debug.set_last_error_message(Sqlerrm);
770: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
771: inv_pp_debug.send_last_error_message;
772: END IF;
773: -- end of debugging section

Line 770: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

766: IF inv_pp_debug.is_debug_mode THEN
767: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
768: -- the message retrieved here since it is no longer on the stack
769: inv_pp_debug.set_last_error_message(Sqlerrm);
770: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
771: inv_pp_debug.send_last_error_message;
772: END IF;
773: -- end of debugging section
774: --

Line 771: inv_pp_debug.send_last_error_message;

767: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
768: -- the message retrieved here since it is no longer on the stack
769: inv_pp_debug.set_last_error_message(Sqlerrm);
770: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
771: inv_pp_debug.send_last_error_message;
772: END IF;
773: -- end of debugging section
774: --
775: x_return_status := fnd_api.g_ret_sts_error;

Line 790: IF inv_pp_debug.is_debug_mode THEN

786: WHEN fnd_api.g_exc_unexpected_error THEN
787: --
788: -- debugging section
789: -- can be commented ut for final code
790: IF inv_pp_debug.is_debug_mode THEN
791: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
792: -- the message retrieved here since it is no longer on the stack
793: inv_pp_debug.set_last_error_message(Sqlerrm);
794: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 793: inv_pp_debug.set_last_error_message(Sqlerrm);

789: -- can be commented ut for final code
790: IF inv_pp_debug.is_debug_mode THEN
791: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
792: -- the message retrieved here since it is no longer on the stack
793: inv_pp_debug.set_last_error_message(Sqlerrm);
794: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
795: inv_pp_debug.send_last_error_message;
796: END IF;
797: -- end of debugging section

Line 794: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

790: IF inv_pp_debug.is_debug_mode THEN
791: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
792: -- the message retrieved here since it is no longer on the stack
793: inv_pp_debug.set_last_error_message(Sqlerrm);
794: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
795: inv_pp_debug.send_last_error_message;
796: END IF;
797: -- end of debugging section
798: --

Line 795: inv_pp_debug.send_last_error_message;

791: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
792: -- the message retrieved here since it is no longer on the stack
793: inv_pp_debug.set_last_error_message(Sqlerrm);
794: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
795: inv_pp_debug.send_last_error_message;
796: END IF;
797: -- end of debugging section
798: --
799: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 814: IF inv_pp_debug.is_debug_mode THEN

810: WHEN OTHERS THEN
811: --
812: -- debugging section
813: -- can be commented ut for final code
814: IF inv_pp_debug.is_debug_mode THEN
815: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
816: -- the message retrieved here since it is no longer on the stack
817: inv_pp_debug.set_last_error_message(Sqlerrm);
818: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 817: inv_pp_debug.set_last_error_message(Sqlerrm);

813: -- can be commented ut for final code
814: IF inv_pp_debug.is_debug_mode THEN
815: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
816: -- the message retrieved here since it is no longer on the stack
817: inv_pp_debug.set_last_error_message(Sqlerrm);
818: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
819: inv_pp_debug.send_last_error_message;
820: END IF;
821: -- end of debugging section

Line 818: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

814: IF inv_pp_debug.is_debug_mode THEN
815: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
816: -- the message retrieved here since it is no longer on the stack
817: inv_pp_debug.set_last_error_message(Sqlerrm);
818: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
819: inv_pp_debug.send_last_error_message;
820: END IF;
821: -- end of debugging section
822: --

Line 819: inv_pp_debug.send_last_error_message;

815: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
816: -- the message retrieved here since it is no longer on the stack
817: inv_pp_debug.set_last_error_message(Sqlerrm);
818: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
819: inv_pp_debug.send_last_error_message;
820: END IF;
821: -- end of debugging section
822: --
823: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 864: IF inv_pp_debug.is_debug_mode THEN

860: l_res_index NUMBER;
861: l_index NUMBER := 0;
862: -- l_other_wdds_count NUMBER; --BUG14014540/14061007/14240024/12781502 -- Commented for Bug 14170648
863: BEGIN
864: IF inv_pp_debug.is_debug_mode THEN
865: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
866: END IF;
867: -- split the picking request into multiple records
868: -- based on reservations

Line 865: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);

861: l_index NUMBER := 0;
862: -- l_other_wdds_count NUMBER; --BUG14014540/14061007/14240024/12781502 -- Commented for Bug 14170648
863: BEGIN
864: IF inv_pp_debug.is_debug_mode THEN
865: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
866: END IF;
867: -- split the picking request into multiple records
868: -- based on reservations
869: --

Line 1099: IF inv_pp_debug.is_debug_mode THEN

1095: -- Bug # 2286454-----------------------
1096: x_remaining_quantity := l_remain_pri_qty;
1097: x_remaining_sec_qty := l_remain_sec_qty;
1098:
1099: IF inv_pp_debug.is_debug_mode THEN
1100: inv_pp_debug.send_message_to_pipe('detail table size: ' || x_detail_level_tbl_size);
1101: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
1102: END IF;
1103: --

Line 1100: inv_pp_debug.send_message_to_pipe('detail table size: ' || x_detail_level_tbl_size);

1096: x_remaining_quantity := l_remain_pri_qty;
1097: x_remaining_sec_qty := l_remain_sec_qty;
1098:
1099: IF inv_pp_debug.is_debug_mode THEN
1100: inv_pp_debug.send_message_to_pipe('detail table size: ' || x_detail_level_tbl_size);
1101: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
1102: END IF;
1103: --
1104: EXCEPTION

Line 1101: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);

1097: x_remaining_sec_qty := l_remain_sec_qty;
1098:
1099: IF inv_pp_debug.is_debug_mode THEN
1100: inv_pp_debug.send_message_to_pipe('detail table size: ' || x_detail_level_tbl_size);
1101: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
1102: END IF;
1103: --
1104: EXCEPTION
1105: when fnd_api.g_exc_error then

Line 1156: IF inv_pp_debug.is_debug_mode THEN

1152: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1153: l_api_name VARCHAR2(30) := 'validate_and_init';
1154: BEGIN
1155: --
1156: IF inv_pp_debug.is_debug_mode THEN
1157: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
1158: END IF;
1159: -- Validation and Initialization
1160: --

Line 1157: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);

1153: l_api_name VARCHAR2(30) := 'validate_and_init';
1154: BEGIN
1155: --
1156: IF inv_pp_debug.is_debug_mode THEN
1157: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
1158: END IF;
1159: -- Validation and Initialization
1160: --
1161: print_debug('in inv validate and init');

Line 1210: IF inv_pp_debug.is_debug_mode THEN

1206: x_request_line_rec.serial_number_end IS NOT NULL)) THEN
1207: x_request_context.detail_serial := TRUE;
1208: ELSE
1209: x_request_context.detail_serial := FALSE;
1210: IF inv_pp_debug.is_debug_mode THEN
1211: inv_pp_debug.send_message_to_pipe('detail serial is FALSE');
1212: END IF;
1213:
1214: END IF;

Line 1211: inv_pp_debug.send_message_to_pipe('detail serial is FALSE');

1207: x_request_context.detail_serial := TRUE;
1208: ELSE
1209: x_request_context.detail_serial := FALSE;
1210: IF inv_pp_debug.is_debug_mode THEN
1211: inv_pp_debug.send_message_to_pipe('detail serial is FALSE');
1212: END IF;
1213:
1214: END IF;
1215:

Line 1219: IF inv_pp_debug.is_debug_mode THEN

1215:
1216: -- initialize serial output table
1217: init_output_serial_rows;
1218: x_return_status := l_return_status;
1219: IF inv_pp_debug.is_debug_mode THEN
1220: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
1221: END IF;
1222: --
1223: EXCEPTION

Line 1220: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);

1216: -- initialize serial output table
1217: init_output_serial_rows;
1218: x_return_status := l_return_status;
1219: IF inv_pp_debug.is_debug_mode THEN
1220: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
1221: END IF;
1222: --
1223: EXCEPTION
1224: when fnd_api.g_exc_error then

Line 2032: IF inv_pp_debug.is_debug_mode THEN

2028: BEGIN
2029: --
2030: -- debugging portion
2031: -- can be commented ut for final code
2032: IF inv_pp_debug.is_debug_mode THEN
2033: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
2034: END IF;
2035: -- end of debugging section
2036: --

Line 2033: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);

2029: --
2030: -- debugging portion
2031: -- can be commented ut for final code
2032: IF inv_pp_debug.is_debug_mode THEN
2033: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
2034: END IF;
2035: -- end of debugging section
2036: --
2037: -- Initialisize API return status to access

Line 2451: IF inv_pp_debug.is_debug_mode THEN

2447: END LOOP;
2448: --
2449: -- debugging portion
2450: -- can be commented ut for final code
2451: IF inv_pp_debug.is_debug_mode THEN
2452: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
2453: END IF;
2454: -- end of debugging section
2455: --

Line 2452: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);

2448: --
2449: -- debugging portion
2450: -- can be commented ut for final code
2451: IF inv_pp_debug.is_debug_mode THEN
2452: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
2453: END IF;
2454: -- end of debugging section
2455: --
2456: EXCEPTION

Line 2461: IF inv_pp_debug.is_debug_mode THEN

2457: when fnd_api.g_exc_error then
2458: --
2459: -- debugging portion
2460: -- can be commented ut for final code
2461: IF inv_pp_debug.is_debug_mode THEN
2462: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2463: -- the message retrieved here since it is no longer on the stack
2464: inv_pp_debug.set_last_error_message(Sqlerrm);
2465: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 2464: inv_pp_debug.set_last_error_message(Sqlerrm);

2460: -- can be commented ut for final code
2461: IF inv_pp_debug.is_debug_mode THEN
2462: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2463: -- the message retrieved here since it is no longer on the stack
2464: inv_pp_debug.set_last_error_message(Sqlerrm);
2465: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2466: inv_pp_debug.send_last_error_message;
2467: END IF;
2468: -- end of debugging section

Line 2465: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

2461: IF inv_pp_debug.is_debug_mode THEN
2462: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2463: -- the message retrieved here since it is no longer on the stack
2464: inv_pp_debug.set_last_error_message(Sqlerrm);
2465: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2466: inv_pp_debug.send_last_error_message;
2467: END IF;
2468: -- end of debugging section
2469: --

Line 2466: inv_pp_debug.send_last_error_message;

2462: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2463: -- the message retrieved here since it is no longer on the stack
2464: inv_pp_debug.set_last_error_message(Sqlerrm);
2465: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2466: inv_pp_debug.send_last_error_message;
2467: END IF;
2468: -- end of debugging section
2469: --
2470: x_return_status := fnd_api.g_ret_sts_error;

Line 2476: IF inv_pp_debug.is_debug_mode THEN

2472: when fnd_api.g_exc_unexpected_error then
2473: --
2474: -- debugging portion
2475: -- can be commented ut for final code
2476: IF inv_pp_debug.is_debug_mode THEN
2477: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2478: -- the message retrieved here since it is no longer on the stack
2479: inv_pp_debug.set_last_error_message(Sqlerrm);
2480: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 2479: inv_pp_debug.set_last_error_message(Sqlerrm);

2475: -- can be commented ut for final code
2476: IF inv_pp_debug.is_debug_mode THEN
2477: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2478: -- the message retrieved here since it is no longer on the stack
2479: inv_pp_debug.set_last_error_message(Sqlerrm);
2480: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2481: inv_pp_debug.send_last_error_message;
2482: END IF;
2483: -- end of debugging section

Line 2480: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

2476: IF inv_pp_debug.is_debug_mode THEN
2477: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2478: -- the message retrieved here since it is no longer on the stack
2479: inv_pp_debug.set_last_error_message(Sqlerrm);
2480: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2481: inv_pp_debug.send_last_error_message;
2482: END IF;
2483: -- end of debugging section
2484: --

Line 2481: inv_pp_debug.send_last_error_message;

2477: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2478: -- the message retrieved here since it is no longer on the stack
2479: inv_pp_debug.set_last_error_message(Sqlerrm);
2480: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2481: inv_pp_debug.send_last_error_message;
2482: END IF;
2483: -- end of debugging section
2484: --
2485: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2491: IF inv_pp_debug.is_debug_mode THEN

2487: when others then
2488: --
2489: -- debugging portion
2490: -- can be commented ut for final code
2491: IF inv_pp_debug.is_debug_mode THEN
2492: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2493: -- the message retrieved here since it is no longer on the stack
2494: inv_pp_debug.set_last_error_message(Sqlerrm);
2495: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 2494: inv_pp_debug.set_last_error_message(Sqlerrm);

2490: -- can be commented ut for final code
2491: IF inv_pp_debug.is_debug_mode THEN
2492: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2493: -- the message retrieved here since it is no longer on the stack
2494: inv_pp_debug.set_last_error_message(Sqlerrm);
2495: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2496: inv_pp_debug.send_last_error_message;
2497: END IF;
2498: -- end of debugging section

Line 2495: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

2491: IF inv_pp_debug.is_debug_mode THEN
2492: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2493: -- the message retrieved here since it is no longer on the stack
2494: inv_pp_debug.set_last_error_message(Sqlerrm);
2495: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2496: inv_pp_debug.send_last_error_message;
2497: END IF;
2498: -- end of debugging section
2499: --

Line 2496: inv_pp_debug.send_last_error_message;

2492: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2493: -- the message retrieved here since it is no longer on the stack
2494: inv_pp_debug.set_last_error_message(Sqlerrm);
2495: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2496: inv_pp_debug.send_last_error_message;
2497: END IF;
2498: -- end of debugging section
2499: --
2500: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2525: IF inv_pp_debug.is_debug_mode THEN

2521: BEGIN
2522: --
2523: -- debugging portion
2524: -- can be commented ut for final code
2525: IF inv_pp_debug.is_debug_mode THEN
2526: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
2527: END IF;
2528: -- end of debugging section
2529: --

Line 2526: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);

2522: --
2523: -- debugging portion
2524: -- can be commented ut for final code
2525: IF inv_pp_debug.is_debug_mode THEN
2526: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
2527: END IF;
2528: -- end of debugging section
2529: --
2530: -- Initialisize API return status to access

Line 2769: IF inv_pp_debug.is_debug_mode THEN

2765: END LOOP;
2766: --
2767: -- debugging portion
2768: -- can be commented ut for final code
2769: IF inv_pp_debug.is_debug_mode THEN
2770: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
2771: END IF;
2772: -- end of debugging section
2773: --

Line 2770: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);

2766: --
2767: -- debugging portion
2768: -- can be commented ut for final code
2769: IF inv_pp_debug.is_debug_mode THEN
2770: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
2771: END IF;
2772: -- end of debugging section
2773: --
2774: EXCEPTION

Line 2779: IF inv_pp_debug.is_debug_mode THEN

2775: when fnd_api.g_exc_error then
2776: --
2777: -- debugging portion
2778: -- can be commented ut for final code
2779: IF inv_pp_debug.is_debug_mode THEN
2780: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2781: -- the message retrieved here since it is no longer on the stack
2782: inv_pp_debug.set_last_error_message(Sqlerrm);
2783: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 2782: inv_pp_debug.set_last_error_message(Sqlerrm);

2778: -- can be commented ut for final code
2779: IF inv_pp_debug.is_debug_mode THEN
2780: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2781: -- the message retrieved here since it is no longer on the stack
2782: inv_pp_debug.set_last_error_message(Sqlerrm);
2783: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2784: inv_pp_debug.send_last_error_message;
2785: END IF;
2786: -- end of debugging section

Line 2783: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

2779: IF inv_pp_debug.is_debug_mode THEN
2780: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2781: -- the message retrieved here since it is no longer on the stack
2782: inv_pp_debug.set_last_error_message(Sqlerrm);
2783: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2784: inv_pp_debug.send_last_error_message;
2785: END IF;
2786: -- end of debugging section
2787: --

Line 2784: inv_pp_debug.send_last_error_message;

2780: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2781: -- the message retrieved here since it is no longer on the stack
2782: inv_pp_debug.set_last_error_message(Sqlerrm);
2783: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2784: inv_pp_debug.send_last_error_message;
2785: END IF;
2786: -- end of debugging section
2787: --
2788: x_return_status := fnd_api.g_ret_sts_error;

Line 2794: IF inv_pp_debug.is_debug_mode THEN

2790: when fnd_api.g_exc_unexpected_error then
2791: --
2792: -- debugging portion
2793: -- can be commented ut for final code
2794: IF inv_pp_debug.is_debug_mode THEN
2795: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2796: -- the message retrieved here since it is no longer on the stack
2797: inv_pp_debug.set_last_error_message(Sqlerrm);
2798: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 2797: inv_pp_debug.set_last_error_message(Sqlerrm);

2793: -- can be commented ut for final code
2794: IF inv_pp_debug.is_debug_mode THEN
2795: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2796: -- the message retrieved here since it is no longer on the stack
2797: inv_pp_debug.set_last_error_message(Sqlerrm);
2798: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2799: inv_pp_debug.send_last_error_message;
2800: END IF;
2801: -- end of debugging section

Line 2798: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

2794: IF inv_pp_debug.is_debug_mode THEN
2795: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2796: -- the message retrieved here since it is no longer on the stack
2797: inv_pp_debug.set_last_error_message(Sqlerrm);
2798: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2799: inv_pp_debug.send_last_error_message;
2800: END IF;
2801: -- end of debugging section
2802: --

Line 2799: inv_pp_debug.send_last_error_message;

2795: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2796: -- the message retrieved here since it is no longer on the stack
2797: inv_pp_debug.set_last_error_message(Sqlerrm);
2798: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2799: inv_pp_debug.send_last_error_message;
2800: END IF;
2801: -- end of debugging section
2802: --
2803: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2809: IF inv_pp_debug.is_debug_mode THEN

2805: when others then
2806: --
2807: -- debugging portion
2808: -- can be commented ut for final code
2809: IF inv_pp_debug.is_debug_mode THEN
2810: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2811: -- the message retrieved here since it is no longer on the stack
2812: inv_pp_debug.set_last_error_message(Sqlerrm);
2813: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 2812: inv_pp_debug.set_last_error_message(Sqlerrm);

2808: -- can be commented ut for final code
2809: IF inv_pp_debug.is_debug_mode THEN
2810: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2811: -- the message retrieved here since it is no longer on the stack
2812: inv_pp_debug.set_last_error_message(Sqlerrm);
2813: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2814: inv_pp_debug.send_last_error_message;
2815: END IF;
2816: -- end of debugging section

Line 2813: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

2809: IF inv_pp_debug.is_debug_mode THEN
2810: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2811: -- the message retrieved here since it is no longer on the stack
2812: inv_pp_debug.set_last_error_message(Sqlerrm);
2813: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2814: inv_pp_debug.send_last_error_message;
2815: END IF;
2816: -- end of debugging section
2817: --

Line 2814: inv_pp_debug.send_last_error_message;

2810: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2811: -- the message retrieved here since it is no longer on the stack
2812: inv_pp_debug.set_last_error_message(Sqlerrm);
2813: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2814: inv_pp_debug.send_last_error_message;
2815: END IF;
2816: -- end of debugging section
2817: --
2818: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2843: IF inv_pp_debug.is_debug_mode THEN

2839: BEGIN
2840: --
2841: -- debugging portion
2842: -- can be commented ut for final code
2843: IF inv_pp_debug.is_debug_mode THEN
2844: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
2845: END IF;
2846: -- end of debugging section
2847: --

Line 2844: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);

2840: --
2841: -- debugging portion
2842: -- can be commented ut for final code
2843: IF inv_pp_debug.is_debug_mode THEN
2844: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
2845: END IF;
2846: -- end of debugging section
2847: --
2848: -- Initialisize API return status to access

Line 2906: IF inv_pp_debug.is_debug_mode THEN

2902: END LOOP;
2903: --
2904: -- debugging portion
2905: -- can be commented ut for final code
2906: IF inv_pp_debug.is_debug_mode THEN
2907: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
2908: END IF;
2909: -- end of debugging section
2910: --

Line 2907: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);

2903: --
2904: -- debugging portion
2905: -- can be commented ut for final code
2906: IF inv_pp_debug.is_debug_mode THEN
2907: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
2908: END IF;
2909: -- end of debugging section
2910: --
2911: EXCEPTION

Line 2916: IF inv_pp_debug.is_debug_mode THEN

2912: when fnd_api.g_exc_error then
2913: --
2914: -- debugging portion
2915: -- can be commented ut for final code
2916: IF inv_pp_debug.is_debug_mode THEN
2917: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2918: -- the message retrieved here since it is no longer on the stack
2919: inv_pp_debug.set_last_error_message(Sqlerrm);
2920: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 2919: inv_pp_debug.set_last_error_message(Sqlerrm);

2915: -- can be commented ut for final code
2916: IF inv_pp_debug.is_debug_mode THEN
2917: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2918: -- the message retrieved here since it is no longer on the stack
2919: inv_pp_debug.set_last_error_message(Sqlerrm);
2920: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2921: inv_pp_debug.send_last_error_message;
2922: END IF;
2923: -- end of debugging section

Line 2920: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

2916: IF inv_pp_debug.is_debug_mode THEN
2917: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2918: -- the message retrieved here since it is no longer on the stack
2919: inv_pp_debug.set_last_error_message(Sqlerrm);
2920: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2921: inv_pp_debug.send_last_error_message;
2922: END IF;
2923: -- end of debugging section
2924: --

Line 2921: inv_pp_debug.send_last_error_message;

2917: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2918: -- the message retrieved here since it is no longer on the stack
2919: inv_pp_debug.set_last_error_message(Sqlerrm);
2920: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2921: inv_pp_debug.send_last_error_message;
2922: END IF;
2923: -- end of debugging section
2924: --
2925: x_return_status := fnd_api.g_ret_sts_error;

Line 2931: IF inv_pp_debug.is_debug_mode THEN

2927: when fnd_api.g_exc_unexpected_error then
2928: --
2929: -- debugging portion
2930: -- can be commented ut for final code
2931: IF inv_pp_debug.is_debug_mode THEN
2932: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2933: -- the message retrieved here since it is no longer on the stack
2934: inv_pp_debug.set_last_error_message(Sqlerrm);
2935: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 2934: inv_pp_debug.set_last_error_message(Sqlerrm);

2930: -- can be commented ut for final code
2931: IF inv_pp_debug.is_debug_mode THEN
2932: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2933: -- the message retrieved here since it is no longer on the stack
2934: inv_pp_debug.set_last_error_message(Sqlerrm);
2935: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2936: inv_pp_debug.send_last_error_message;
2937: END IF;
2938: -- end of debugging section

Line 2935: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

2931: IF inv_pp_debug.is_debug_mode THEN
2932: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2933: -- the message retrieved here since it is no longer on the stack
2934: inv_pp_debug.set_last_error_message(Sqlerrm);
2935: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2936: inv_pp_debug.send_last_error_message;
2937: END IF;
2938: -- end of debugging section
2939: --

Line 2936: inv_pp_debug.send_last_error_message;

2932: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2933: -- the message retrieved here since it is no longer on the stack
2934: inv_pp_debug.set_last_error_message(Sqlerrm);
2935: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2936: inv_pp_debug.send_last_error_message;
2937: END IF;
2938: -- end of debugging section
2939: --
2940: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2946: IF inv_pp_debug.is_debug_mode THEN

2942: when others then
2943: --
2944: -- debugging portion
2945: -- can be commented ut for final code
2946: IF inv_pp_debug.is_debug_mode THEN
2947: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2948: -- the message retrieved here since it is no longer on the stack
2949: inv_pp_debug.set_last_error_message(Sqlerrm);
2950: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 2949: inv_pp_debug.set_last_error_message(Sqlerrm);

2945: -- can be commented ut for final code
2946: IF inv_pp_debug.is_debug_mode THEN
2947: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2948: -- the message retrieved here since it is no longer on the stack
2949: inv_pp_debug.set_last_error_message(Sqlerrm);
2950: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2951: inv_pp_debug.send_last_error_message;
2952: END IF;
2953: -- end of debugging section

Line 2950: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

2946: IF inv_pp_debug.is_debug_mode THEN
2947: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2948: -- the message retrieved here since it is no longer on the stack
2949: inv_pp_debug.set_last_error_message(Sqlerrm);
2950: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2951: inv_pp_debug.send_last_error_message;
2952: END IF;
2953: -- end of debugging section
2954: --

Line 2951: inv_pp_debug.send_last_error_message;

2947: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2948: -- the message retrieved here since it is no longer on the stack
2949: inv_pp_debug.set_last_error_message(Sqlerrm);
2950: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2951: inv_pp_debug.send_last_error_message;
2952: END IF;
2953: -- end of debugging section
2954: --
2955: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3080: IF inv_pp_debug.is_debug_mode THEN

3076: BEGIN
3077: --
3078: -- debugging section
3079: -- can be commented ut for final code
3080: IF inv_pp_debug.is_debug_mode THEN
3081: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
3082: END IF;
3083: -- end of debugging section
3084: --

Line 3081: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);

3077: --
3078: -- debugging section
3079: -- can be commented ut for final code
3080: IF inv_pp_debug.is_debug_mode THEN
3081: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
3082: END IF;
3083: -- end of debugging section
3084: --
3085: g_output_process_tbl_size := 0;

Line 3090: IF inv_pp_debug.is_debug_mode THEN

3086: g_output_process_tbl.DELETE;
3087: --
3088: -- debugging section
3089: -- can be commented ut for final code
3090: IF inv_pp_debug.is_debug_mode THEN
3091: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
3092: END IF;
3093: -- end of debugging section
3094: --

Line 3091: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);

3087: --
3088: -- debugging section
3089: -- can be commented ut for final code
3090: IF inv_pp_debug.is_debug_mode THEN
3091: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
3092: END IF;
3093: -- end of debugging section
3094: --
3095: END init_output_process_tbl;

Line 3261: IF inv_pp_debug.is_debug_mode THEN

3257:
3258: BEGIN
3259: -- debugging section
3260: -- can be commented ut for final code
3261: IF inv_pp_debug.is_debug_mode THEN
3262: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
3263: END IF;
3264: -- end of debugging section
3265: --

Line 3262: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);

3258: BEGIN
3259: -- debugging section
3260: -- can be commented ut for final code
3261: IF inv_pp_debug.is_debug_mode THEN
3262: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
3263: END IF;
3264: -- end of debugging section
3265: --
3266: IF g_debug IS NULL or NOT INV_CACHE.is_pickrelease THEN

Line 3271: inv_pp_debug.set_debug_mode(g_debug);

3267: g_debug := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),2);
3268: END IF;
3269: l_debug := g_debug;
3270:
3271: inv_pp_debug.set_debug_mode(g_debug);
3272:
3273: IF l_debug = 1 THEN
3274: print_debug('in process output ');
3275: print_output_process_tbl(p_request_context);

Line 3338: --IF inv_pp_debug.is_debug_mode THEN

3334: l_sec_lot_temp_qty := g_output_process_tbl(1).secondary_quantity;
3335: END IF;
3336: l_txn_temp_qty := g_output_process_tbl(1).primary_quantity;
3337: l_sec_txn_temp_qty := g_output_process_tbl(1).secondary_quantity;
3338: --IF inv_pp_debug.is_debug_mode THEN
3339: print_debug('process output before loop, lot pri qty '||l_lot_temp_qty);
3340: print_debug('process output before loop, lot sec qty '||l_sec_lot_temp_qty);
3341: print_debug('process output before loop, txn pri qty '||l_txn_temp_qty);
3342: print_debug('process output before loop, txn sec qty '||l_sec_txn_temp_qty);

Line 3541: IF inv_pp_debug.is_debug_mode THEN

3537: l_mtlt_tbl(l_mtlt_tbl_size).transaction_temp_id := l_txn_temp_id;
3538: l_mtlt_tbl(l_mtlt_tbl_size).primary_quantity := l_qty_sign * l_lot_temp_qty;
3539: l_mtlt_tbl(l_mtlt_tbl_size).secondary_quantity := l_qty_sign * l_sec_lot_temp_qty;
3540: l_mtlt_tbl(l_mtlt_tbl_size).secondary_unit_of_measure := p_request_context.secondary_uom_code; --Bug#8217560
3541: IF inv_pp_debug.is_debug_mode THEN
3542: print_debug('process output , lot pri qty '||l_lot_temp_qty);
3543: print_debug('process output , lot sec qty '||l_sec_lot_temp_qty);
3544: END IF;
3545: l_mtlt_tbl(l_mtlt_tbl_size).lot_number := g_output_process_tbl(l_index-1).lot_number;

Line 3685: IF inv_pp_debug.is_debug_mode THEN

3681: l_mmtt_tbl(l_mmtt_tbl_size).primary_quantity:=
3682: l_qty_sign * l_txn_temp_qty;
3683: l_mmtt_tbl(l_mmtt_tbl_size).secondary_transaction_quantity:=
3684: l_qty_sign * l_sec_txn_temp_qty;
3685: IF inv_pp_debug.is_debug_mode THEN
3686: print_debug('process output , txn pri qty '||l_txn_temp_qty);
3687: print_debug('process output , txn sec qty '||l_sec_txn_temp_qty);
3688: inv_pp_debug.send_message_to_pipe('pri qty '|| l_txn_temp_qty);
3689: inv_pp_debug.send_message_to_pipe('qty_sign' || l_qty_sign);

Line 3688: inv_pp_debug.send_message_to_pipe('pri qty '|| l_txn_temp_qty);

3684: l_qty_sign * l_sec_txn_temp_qty;
3685: IF inv_pp_debug.is_debug_mode THEN
3686: print_debug('process output , txn pri qty '||l_txn_temp_qty);
3687: print_debug('process output , txn sec qty '||l_sec_txn_temp_qty);
3688: inv_pp_debug.send_message_to_pipe('pri qty '|| l_txn_temp_qty);
3689: inv_pp_debug.send_message_to_pipe('qty_sign' || l_qty_sign);
3690: inv_pp_debug.send_message_to_pipe('sec qty '|| l_sec_txn_temp_qty);
3691: END IF;
3692:

Line 3689: inv_pp_debug.send_message_to_pipe('qty_sign' || l_qty_sign);

3685: IF inv_pp_debug.is_debug_mode THEN
3686: print_debug('process output , txn pri qty '||l_txn_temp_qty);
3687: print_debug('process output , txn sec qty '||l_sec_txn_temp_qty);
3688: inv_pp_debug.send_message_to_pipe('pri qty '|| l_txn_temp_qty);
3689: inv_pp_debug.send_message_to_pipe('qty_sign' || l_qty_sign);
3690: inv_pp_debug.send_message_to_pipe('sec qty '|| l_sec_txn_temp_qty);
3691: END IF;
3692:
3693:

Line 3690: inv_pp_debug.send_message_to_pipe('sec qty '|| l_sec_txn_temp_qty);

3686: print_debug('process output , txn pri qty '||l_txn_temp_qty);
3687: print_debug('process output , txn sec qty '||l_sec_txn_temp_qty);
3688: inv_pp_debug.send_message_to_pipe('pri qty '|| l_txn_temp_qty);
3689: inv_pp_debug.send_message_to_pipe('qty_sign' || l_qty_sign);
3690: inv_pp_debug.send_message_to_pipe('sec qty '|| l_sec_txn_temp_qty);
3691: END IF;
3692:
3693:
3694: IF (p_request_context.primary_uom_code = p_request_context.transaction_uom_code ) THEN

Line 4052: IF inv_pp_debug.is_debug_mode THEN

4048: x_return_status := l_return_status;
4049: --
4050: -- debugging section
4051: -- can be commented ut for final code
4052: IF inv_pp_debug.is_debug_mode THEN
4053: inv_pp_debug.send_message_to_pipe('=================== create output records: ');
4054: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_material_transactions_temp: '
4055: || l_mmtt_tbl_size);
4056: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_transaction_lots_temp: '

Line 4053: inv_pp_debug.send_message_to_pipe('=================== create output records: ');

4049: --
4050: -- debugging section
4051: -- can be commented ut for final code
4052: IF inv_pp_debug.is_debug_mode THEN
4053: inv_pp_debug.send_message_to_pipe('=================== create output records: ');
4054: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_material_transactions_temp: '
4055: || l_mmtt_tbl_size);
4056: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_transaction_lots_temp: '
4057: || l_mtlt_tbl_size);

Line 4054: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_material_transactions_temp: '

4050: -- debugging section
4051: -- can be commented ut for final code
4052: IF inv_pp_debug.is_debug_mode THEN
4053: inv_pp_debug.send_message_to_pipe('=================== create output records: ');
4054: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_material_transactions_temp: '
4055: || l_mmtt_tbl_size);
4056: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_transaction_lots_temp: '
4057: || l_mtlt_tbl_size);
4058: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_serial_numbers_temp: '

Line 4056: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_transaction_lots_temp: '

4052: IF inv_pp_debug.is_debug_mode THEN
4053: inv_pp_debug.send_message_to_pipe('=================== create output records: ');
4054: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_material_transactions_temp: '
4055: || l_mmtt_tbl_size);
4056: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_transaction_lots_temp: '
4057: || l_mtlt_tbl_size);
4058: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_serial_numbers_temp: '
4059: || l_msnt_tbl_size);
4060: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);

Line 4058: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_serial_numbers_temp: '

4054: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_material_transactions_temp: '
4055: || l_mmtt_tbl_size);
4056: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_transaction_lots_temp: '
4057: || l_mtlt_tbl_size);
4058: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_serial_numbers_temp: '
4059: || l_msnt_tbl_size);
4060: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
4061: END IF;
4062: -- end of debugging section

Line 4060: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);

4056: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_transaction_lots_temp: '
4057: || l_mtlt_tbl_size);
4058: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_serial_numbers_temp: '
4059: || l_msnt_tbl_size);
4060: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
4061: END IF;
4062: -- end of debugging section
4063: --
4064: EXCEPTION

Line 4069: IF inv_pp_debug.is_debug_mode THEN

4065: WHEN fnd_api.g_exc_error THEN
4066: --
4067: -- debugging section
4068: -- can be commented ut for final code
4069: IF inv_pp_debug.is_debug_mode THEN
4070: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
4071: -- the message retrieved here since it is no longer on the stack
4072: inv_pp_debug.set_last_error_message(Sqlerrm);
4073: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 4072: inv_pp_debug.set_last_error_message(Sqlerrm);

4068: -- can be commented ut for final code
4069: IF inv_pp_debug.is_debug_mode THEN
4070: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
4071: -- the message retrieved here since it is no longer on the stack
4072: inv_pp_debug.set_last_error_message(Sqlerrm);
4073: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
4074: inv_pp_debug.send_last_error_message;
4075: END IF;
4076: -- end of debugging section

Line 4073: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

4069: IF inv_pp_debug.is_debug_mode THEN
4070: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
4071: -- the message retrieved here since it is no longer on the stack
4072: inv_pp_debug.set_last_error_message(Sqlerrm);
4073: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
4074: inv_pp_debug.send_last_error_message;
4075: END IF;
4076: -- end of debugging section
4077: --

Line 4074: inv_pp_debug.send_last_error_message;

4070: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
4071: -- the message retrieved here since it is no longer on the stack
4072: inv_pp_debug.set_last_error_message(Sqlerrm);
4073: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
4074: inv_pp_debug.send_last_error_message;
4075: END IF;
4076: -- end of debugging section
4077: --
4078: x_return_status := fnd_api.g_ret_sts_error;

Line 4084: IF inv_pp_debug.is_debug_mode THEN

4080: WHEN fnd_api.g_exc_unexpected_error THEN
4081: --
4082: -- debugging section
4083: -- can be commented ut for final code
4084: IF inv_pp_debug.is_debug_mode THEN
4085: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
4086: -- the message retrieved here since it is no longer on the stack
4087: inv_pp_debug.set_last_error_message(Sqlerrm);
4088: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 4087: inv_pp_debug.set_last_error_message(Sqlerrm);

4083: -- can be commented ut for final code
4084: IF inv_pp_debug.is_debug_mode THEN
4085: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
4086: -- the message retrieved here since it is no longer on the stack
4087: inv_pp_debug.set_last_error_message(Sqlerrm);
4088: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
4089: inv_pp_debug.send_last_error_message;
4090: END IF;
4091: -- end of debugging section

Line 4088: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

4084: IF inv_pp_debug.is_debug_mode THEN
4085: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
4086: -- the message retrieved here since it is no longer on the stack
4087: inv_pp_debug.set_last_error_message(Sqlerrm);
4088: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
4089: inv_pp_debug.send_last_error_message;
4090: END IF;
4091: -- end of debugging section
4092: --

Line 4089: inv_pp_debug.send_last_error_message;

4085: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
4086: -- the message retrieved here since it is no longer on the stack
4087: inv_pp_debug.set_last_error_message(Sqlerrm);
4088: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
4089: inv_pp_debug.send_last_error_message;
4090: END IF;
4091: -- end of debugging section
4092: --
4093: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 4099: IF inv_pp_debug.is_debug_mode THEN

4095: WHEN OTHERS THEN
4096: --
4097: -- debugging section
4098: -- can be commented ut for final code
4099: IF inv_pp_debug.is_debug_mode THEN
4100: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
4101: -- the message retrieved here since it is no longer on the stack
4102: inv_pp_debug.set_last_error_message(Sqlerrm);
4103: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 4102: inv_pp_debug.set_last_error_message(Sqlerrm);

4098: -- can be commented ut for final code
4099: IF inv_pp_debug.is_debug_mode THEN
4100: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
4101: -- the message retrieved here since it is no longer on the stack
4102: inv_pp_debug.set_last_error_message(Sqlerrm);
4103: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
4104: inv_pp_debug.send_last_error_message;
4105: END IF;
4106: -- end of debugging section

Line 4103: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

4099: IF inv_pp_debug.is_debug_mode THEN
4100: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
4101: -- the message retrieved here since it is no longer on the stack
4102: inv_pp_debug.set_last_error_message(Sqlerrm);
4103: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
4104: inv_pp_debug.send_last_error_message;
4105: END IF;
4106: -- end of debugging section
4107: --

Line 4104: inv_pp_debug.send_last_error_message;

4100: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
4101: -- the message retrieved here since it is no longer on the stack
4102: inv_pp_debug.set_last_error_message(Sqlerrm);
4103: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
4104: inv_pp_debug.send_last_error_message;
4105: END IF;
4106: -- end of debugging section
4107: --
4108: x_return_status := fnd_api.g_ret_sts_unexp_error;