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

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

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

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

Line 232: IF inv_pp_debug.is_debug_mode THEN

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

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

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

Line 243: IF inv_pp_debug.is_debug_mode THEN

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

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

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

Line 283: IF inv_pp_debug.is_debug_mode THEN

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

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

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

Line 419: IF inv_pp_debug.is_debug_mode THEN

415: x_request_context.ship_to_location,
416: x_request_context.shipment_number,
417: x_request_context.freight_code;
418: IF l_ship_info_csr%notfound THEN
419: IF inv_pp_debug.is_debug_mode THEN
420: inv_pp_debug.send_message_to_pipe('mo shipping not found');
421: inv_pp_debug.send_message_to_pipe('trans source type:' || x_request_line_rec.transaction_source_type_id);
422: END IF;
423: CLOSE l_ship_info_csr;

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

416: x_request_context.shipment_number,
417: x_request_context.freight_code;
418: IF l_ship_info_csr%notfound THEN
419: IF inv_pp_debug.is_debug_mode THEN
420: inv_pp_debug.send_message_to_pipe('mo shipping not found');
421: inv_pp_debug.send_message_to_pipe('trans source type:' || x_request_line_rec.transaction_source_type_id);
422: END IF;
423: CLOSE l_ship_info_csr;
424: -- bug 5677255, keep the source_type_id for reservations

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

417: x_request_context.freight_code;
418: IF l_ship_info_csr%notfound THEN
419: IF inv_pp_debug.is_debug_mode THEN
420: inv_pp_debug.send_message_to_pipe('mo shipping not found');
421: inv_pp_debug.send_message_to_pipe('trans source type:' || x_request_line_rec.transaction_source_type_id);
422: END IF;
423: CLOSE l_ship_info_csr;
424: -- bug 5677255, keep the source_type_id for reservations
425: If x_request_line_rec.reference = 'ORDER_LINE_ID_RSV' Then

Line 438: IF inv_pp_debug.is_debug_mode THEN

434: x_request_context.ship_to_location,
435: x_request_context.shipment_number,
436: x_request_context.freight_code;
437: IF l_ship_info_csr%notfound THEN
438: IF inv_pp_debug.is_debug_mode THEN
439: inv_pp_debug.send_message_to_pipe('reservation mo order line not found');
440: inv_pp_debug.send_message_to_pipe('trans source type:' || x_request_line_rec.transaction_source_type_id);
441: END IF;
442: CLOSE l_order_info_csr;

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

435: x_request_context.shipment_number,
436: x_request_context.freight_code;
437: IF l_ship_info_csr%notfound THEN
438: IF inv_pp_debug.is_debug_mode THEN
439: inv_pp_debug.send_message_to_pipe('reservation mo order line not found');
440: inv_pp_debug.send_message_to_pipe('trans source type:' || x_request_line_rec.transaction_source_type_id);
441: END IF;
442: CLOSE l_order_info_csr;
443: RAISE no_data_found;

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

436: x_request_context.freight_code;
437: IF l_ship_info_csr%notfound THEN
438: IF inv_pp_debug.is_debug_mode THEN
439: inv_pp_debug.send_message_to_pipe('reservation mo order line not found');
440: inv_pp_debug.send_message_to_pipe('trans source type:' || x_request_line_rec.transaction_source_type_id);
441: END IF;
442: CLOSE l_order_info_csr;
443: RAISE no_data_found;
444: End if;

Line 481: IF inv_pp_debug.is_debug_mode THEN

477: x_request_context.ship_to_location,
478: x_request_context.shipment_number,
479: x_request_context.freight_code;
480: IF l_rma_info_csr%notfound THEN
481: IF inv_pp_debug.is_debug_mode THEN
482: inv_pp_debug.send_message_to_pipe('rma info not found');
483: inv_pp_debug.send_message_to_pipe('trans source type:' || x_request_line_rec.transaction_source_type_id);
484: END IF;
485: CLOSE l_rma_info_csr;

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

478: x_request_context.shipment_number,
479: x_request_context.freight_code;
480: IF l_rma_info_csr%notfound THEN
481: IF inv_pp_debug.is_debug_mode THEN
482: inv_pp_debug.send_message_to_pipe('rma info not found');
483: inv_pp_debug.send_message_to_pipe('trans source type:' || x_request_line_rec.transaction_source_type_id);
484: END IF;
485: CLOSE l_rma_info_csr;
486: RAISE no_data_found;

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

479: x_request_context.freight_code;
480: IF l_rma_info_csr%notfound THEN
481: IF inv_pp_debug.is_debug_mode THEN
482: inv_pp_debug.send_message_to_pipe('rma info not found');
483: inv_pp_debug.send_message_to_pipe('trans source type:' || x_request_line_rec.transaction_source_type_id);
484: END IF;
485: CLOSE l_rma_info_csr;
486: RAISE no_data_found;
487: END IF;

Line 581: IF inv_pp_debug.is_debug_mode THEN

577:
578: --
579: -- debugging section
580: -- can be commented ut for final code
581: IF inv_pp_debug.is_debug_mode THEN
582: inv_pp_debug.send_message_to_pipe
583: ('======== Move Order Line Information ========');
584: inv_pp_debug.send_message_to_pipe('line_id '
585: || x_request_line_rec.line_id);

Line 582: inv_pp_debug.send_message_to_pipe

578: --
579: -- debugging section
580: -- can be commented ut for final code
581: IF inv_pp_debug.is_debug_mode THEN
582: inv_pp_debug.send_message_to_pipe
583: ('======== Move Order Line Information ========');
584: inv_pp_debug.send_message_to_pipe('line_id '
585: || x_request_line_rec.line_id);
586: inv_pp_debug.send_message_to_pipe('header_id '

Line 584: inv_pp_debug.send_message_to_pipe('line_id '

580: -- can be commented ut for final code
581: IF inv_pp_debug.is_debug_mode THEN
582: inv_pp_debug.send_message_to_pipe
583: ('======== Move Order Line Information ========');
584: inv_pp_debug.send_message_to_pipe('line_id '
585: || x_request_line_rec.line_id);
586: inv_pp_debug.send_message_to_pipe('header_id '
587: || x_request_line_rec.header_id);
588: inv_pp_debug.send_message_to_pipe('line_number '

Line 586: inv_pp_debug.send_message_to_pipe('header_id '

582: inv_pp_debug.send_message_to_pipe
583: ('======== Move Order Line Information ========');
584: inv_pp_debug.send_message_to_pipe('line_id '
585: || x_request_line_rec.line_id);
586: inv_pp_debug.send_message_to_pipe('header_id '
587: || x_request_line_rec.header_id);
588: inv_pp_debug.send_message_to_pipe('line_number '
589: || x_request_line_rec.line_number);
590: inv_pp_debug.send_message_to_pipe('organization_id '

Line 588: inv_pp_debug.send_message_to_pipe('line_number '

584: inv_pp_debug.send_message_to_pipe('line_id '
585: || x_request_line_rec.line_id);
586: inv_pp_debug.send_message_to_pipe('header_id '
587: || x_request_line_rec.header_id);
588: inv_pp_debug.send_message_to_pipe('line_number '
589: || x_request_line_rec.line_number);
590: inv_pp_debug.send_message_to_pipe('organization_id '
591: || x_request_line_rec.organization_id);
592: inv_pp_debug.send_message_to_pipe('inventory_item_id '

Line 590: inv_pp_debug.send_message_to_pipe('organization_id '

586: inv_pp_debug.send_message_to_pipe('header_id '
587: || x_request_line_rec.header_id);
588: inv_pp_debug.send_message_to_pipe('line_number '
589: || x_request_line_rec.line_number);
590: inv_pp_debug.send_message_to_pipe('organization_id '
591: || x_request_line_rec.organization_id);
592: inv_pp_debug.send_message_to_pipe('inventory_item_id '
593: || x_request_line_rec.inventory_item_id);
594: inv_pp_debug.send_message_to_pipe('revision '

Line 592: inv_pp_debug.send_message_to_pipe('inventory_item_id '

588: inv_pp_debug.send_message_to_pipe('line_number '
589: || x_request_line_rec.line_number);
590: inv_pp_debug.send_message_to_pipe('organization_id '
591: || x_request_line_rec.organization_id);
592: inv_pp_debug.send_message_to_pipe('inventory_item_id '
593: || x_request_line_rec.inventory_item_id);
594: inv_pp_debug.send_message_to_pipe('revision '
595: || x_request_line_rec.revision);
596: inv_pp_debug.send_message_to_pipe('from_subinventory_id '

Line 594: inv_pp_debug.send_message_to_pipe('revision '

590: inv_pp_debug.send_message_to_pipe('organization_id '
591: || x_request_line_rec.organization_id);
592: inv_pp_debug.send_message_to_pipe('inventory_item_id '
593: || x_request_line_rec.inventory_item_id);
594: inv_pp_debug.send_message_to_pipe('revision '
595: || x_request_line_rec.revision);
596: inv_pp_debug.send_message_to_pipe('from_subinventory_id '
597: || x_request_line_rec.from_subinventory_id);
598: inv_pp_debug.send_message_to_pipe('from_subinventory_code '

Line 596: inv_pp_debug.send_message_to_pipe('from_subinventory_id '

592: inv_pp_debug.send_message_to_pipe('inventory_item_id '
593: || x_request_line_rec.inventory_item_id);
594: inv_pp_debug.send_message_to_pipe('revision '
595: || x_request_line_rec.revision);
596: inv_pp_debug.send_message_to_pipe('from_subinventory_id '
597: || x_request_line_rec.from_subinventory_id);
598: inv_pp_debug.send_message_to_pipe('from_subinventory_code '
599: || x_request_line_rec.from_subinventory_code);
600: inv_pp_debug.send_message_to_pipe('from_locator_id '

Line 598: inv_pp_debug.send_message_to_pipe('from_subinventory_code '

594: inv_pp_debug.send_message_to_pipe('revision '
595: || x_request_line_rec.revision);
596: inv_pp_debug.send_message_to_pipe('from_subinventory_id '
597: || x_request_line_rec.from_subinventory_id);
598: inv_pp_debug.send_message_to_pipe('from_subinventory_code '
599: || x_request_line_rec.from_subinventory_code);
600: inv_pp_debug.send_message_to_pipe('from_locator_id '
601: || x_request_line_rec.from_locator_id);
602: inv_pp_debug.send_message_to_pipe('to_subinventory_code '

Line 600: inv_pp_debug.send_message_to_pipe('from_locator_id '

596: inv_pp_debug.send_message_to_pipe('from_subinventory_id '
597: || x_request_line_rec.from_subinventory_id);
598: inv_pp_debug.send_message_to_pipe('from_subinventory_code '
599: || x_request_line_rec.from_subinventory_code);
600: inv_pp_debug.send_message_to_pipe('from_locator_id '
601: || x_request_line_rec.from_locator_id);
602: inv_pp_debug.send_message_to_pipe('to_subinventory_code '
603: || x_request_line_rec.to_subinventory_code);
604: inv_pp_debug.send_message_to_pipe('to_subinventory_id '

Line 602: inv_pp_debug.send_message_to_pipe('to_subinventory_code '

598: inv_pp_debug.send_message_to_pipe('from_subinventory_code '
599: || x_request_line_rec.from_subinventory_code);
600: inv_pp_debug.send_message_to_pipe('from_locator_id '
601: || x_request_line_rec.from_locator_id);
602: inv_pp_debug.send_message_to_pipe('to_subinventory_code '
603: || x_request_line_rec.to_subinventory_code);
604: inv_pp_debug.send_message_to_pipe('to_subinventory_id '
605: || x_request_line_rec.to_subinventory_id);
606: inv_pp_debug.send_message_to_pipe('to_locator_id '

Line 604: inv_pp_debug.send_message_to_pipe('to_subinventory_id '

600: inv_pp_debug.send_message_to_pipe('from_locator_id '
601: || x_request_line_rec.from_locator_id);
602: inv_pp_debug.send_message_to_pipe('to_subinventory_code '
603: || x_request_line_rec.to_subinventory_code);
604: inv_pp_debug.send_message_to_pipe('to_subinventory_id '
605: || x_request_line_rec.to_subinventory_id);
606: inv_pp_debug.send_message_to_pipe('to_locator_id '
607: || x_request_line_rec.to_locator_id);
608: inv_pp_debug.send_message_to_pipe('to_account_id '

Line 606: inv_pp_debug.send_message_to_pipe('to_locator_id '

602: inv_pp_debug.send_message_to_pipe('to_subinventory_code '
603: || x_request_line_rec.to_subinventory_code);
604: inv_pp_debug.send_message_to_pipe('to_subinventory_id '
605: || x_request_line_rec.to_subinventory_id);
606: inv_pp_debug.send_message_to_pipe('to_locator_id '
607: || x_request_line_rec.to_locator_id);
608: inv_pp_debug.send_message_to_pipe('to_account_id '
609: || x_request_line_rec.to_account_id);
610: inv_pp_debug.send_message_to_pipe('lot_number '

Line 608: inv_pp_debug.send_message_to_pipe('to_account_id '

604: inv_pp_debug.send_message_to_pipe('to_subinventory_id '
605: || x_request_line_rec.to_subinventory_id);
606: inv_pp_debug.send_message_to_pipe('to_locator_id '
607: || x_request_line_rec.to_locator_id);
608: inv_pp_debug.send_message_to_pipe('to_account_id '
609: || x_request_line_rec.to_account_id);
610: inv_pp_debug.send_message_to_pipe('lot_number '
611: || x_request_line_rec.lot_number);
612: inv_pp_debug.send_message_to_pipe('serial_number_start '

Line 610: inv_pp_debug.send_message_to_pipe('lot_number '

606: inv_pp_debug.send_message_to_pipe('to_locator_id '
607: || x_request_line_rec.to_locator_id);
608: inv_pp_debug.send_message_to_pipe('to_account_id '
609: || x_request_line_rec.to_account_id);
610: inv_pp_debug.send_message_to_pipe('lot_number '
611: || x_request_line_rec.lot_number);
612: inv_pp_debug.send_message_to_pipe('serial_number_start '
613: || x_request_line_rec.serial_number_start);
614: inv_pp_debug.send_message_to_pipe('serial_number_end '

Line 612: inv_pp_debug.send_message_to_pipe('serial_number_start '

608: inv_pp_debug.send_message_to_pipe('to_account_id '
609: || x_request_line_rec.to_account_id);
610: inv_pp_debug.send_message_to_pipe('lot_number '
611: || x_request_line_rec.lot_number);
612: inv_pp_debug.send_message_to_pipe('serial_number_start '
613: || x_request_line_rec.serial_number_start);
614: inv_pp_debug.send_message_to_pipe('serial_number_end '
615: || x_request_line_rec.serial_number_end);
616: inv_pp_debug.send_message_to_pipe('uom_code '

Line 614: inv_pp_debug.send_message_to_pipe('serial_number_end '

610: inv_pp_debug.send_message_to_pipe('lot_number '
611: || x_request_line_rec.lot_number);
612: inv_pp_debug.send_message_to_pipe('serial_number_start '
613: || x_request_line_rec.serial_number_start);
614: inv_pp_debug.send_message_to_pipe('serial_number_end '
615: || x_request_line_rec.serial_number_end);
616: inv_pp_debug.send_message_to_pipe('uom_code '
617: || x_request_line_rec.uom_code);
618: inv_pp_debug.send_message_to_pipe('quantity '

Line 616: inv_pp_debug.send_message_to_pipe('uom_code '

612: inv_pp_debug.send_message_to_pipe('serial_number_start '
613: || x_request_line_rec.serial_number_start);
614: inv_pp_debug.send_message_to_pipe('serial_number_end '
615: || x_request_line_rec.serial_number_end);
616: inv_pp_debug.send_message_to_pipe('uom_code '
617: || x_request_line_rec.uom_code);
618: inv_pp_debug.send_message_to_pipe('quantity '
619: || x_request_line_rec.quantity);
620: inv_pp_debug.send_message_to_pipe('quantity_delivered '

Line 618: inv_pp_debug.send_message_to_pipe('quantity '

614: inv_pp_debug.send_message_to_pipe('serial_number_end '
615: || x_request_line_rec.serial_number_end);
616: inv_pp_debug.send_message_to_pipe('uom_code '
617: || x_request_line_rec.uom_code);
618: inv_pp_debug.send_message_to_pipe('quantity '
619: || x_request_line_rec.quantity);
620: inv_pp_debug.send_message_to_pipe('quantity_delivered '
621: || x_request_line_rec.quantity_delivered);
622: inv_pp_debug.send_message_to_pipe('quantity_detailed '

Line 620: inv_pp_debug.send_message_to_pipe('quantity_delivered '

616: inv_pp_debug.send_message_to_pipe('uom_code '
617: || x_request_line_rec.uom_code);
618: inv_pp_debug.send_message_to_pipe('quantity '
619: || x_request_line_rec.quantity);
620: inv_pp_debug.send_message_to_pipe('quantity_delivered '
621: || x_request_line_rec.quantity_delivered);
622: inv_pp_debug.send_message_to_pipe('quantity_detailed '
623: || x_request_line_rec.quantity_detailed);
624: inv_pp_debug.send_message_to_pipe('date_required '

Line 622: inv_pp_debug.send_message_to_pipe('quantity_detailed '

618: inv_pp_debug.send_message_to_pipe('quantity '
619: || x_request_line_rec.quantity);
620: inv_pp_debug.send_message_to_pipe('quantity_delivered '
621: || x_request_line_rec.quantity_delivered);
622: inv_pp_debug.send_message_to_pipe('quantity_detailed '
623: || x_request_line_rec.quantity_detailed);
624: inv_pp_debug.send_message_to_pipe('date_required '
625: || x_request_line_rec.date_required);
626: inv_pp_debug.send_message_to_pipe('reason_id '

Line 624: inv_pp_debug.send_message_to_pipe('date_required '

620: inv_pp_debug.send_message_to_pipe('quantity_delivered '
621: || x_request_line_rec.quantity_delivered);
622: inv_pp_debug.send_message_to_pipe('quantity_detailed '
623: || x_request_line_rec.quantity_detailed);
624: inv_pp_debug.send_message_to_pipe('date_required '
625: || x_request_line_rec.date_required);
626: inv_pp_debug.send_message_to_pipe('reason_id '
627: || x_request_line_rec.reason_id);
628: inv_pp_debug.send_message_to_pipe('reference '

Line 626: inv_pp_debug.send_message_to_pipe('reason_id '

622: inv_pp_debug.send_message_to_pipe('quantity_detailed '
623: || x_request_line_rec.quantity_detailed);
624: inv_pp_debug.send_message_to_pipe('date_required '
625: || x_request_line_rec.date_required);
626: inv_pp_debug.send_message_to_pipe('reason_id '
627: || x_request_line_rec.reason_id);
628: inv_pp_debug.send_message_to_pipe('reference '
629: || x_request_line_rec.reference);
630: inv_pp_debug.send_message_to_pipe('reference_type_code '

Line 628: inv_pp_debug.send_message_to_pipe('reference '

624: inv_pp_debug.send_message_to_pipe('date_required '
625: || x_request_line_rec.date_required);
626: inv_pp_debug.send_message_to_pipe('reason_id '
627: || x_request_line_rec.reason_id);
628: inv_pp_debug.send_message_to_pipe('reference '
629: || x_request_line_rec.reference);
630: inv_pp_debug.send_message_to_pipe('reference_type_code '
631: || x_request_line_rec.reference_type_code);
632: inv_pp_debug.send_message_to_pipe('reference_id '

Line 630: inv_pp_debug.send_message_to_pipe('reference_type_code '

626: inv_pp_debug.send_message_to_pipe('reason_id '
627: || x_request_line_rec.reason_id);
628: inv_pp_debug.send_message_to_pipe('reference '
629: || x_request_line_rec.reference);
630: inv_pp_debug.send_message_to_pipe('reference_type_code '
631: || x_request_line_rec.reference_type_code);
632: inv_pp_debug.send_message_to_pipe('reference_id '
633: || x_request_line_rec.reference_id);
634: inv_pp_debug.send_message_to_pipe('project_id '

Line 632: inv_pp_debug.send_message_to_pipe('reference_id '

628: inv_pp_debug.send_message_to_pipe('reference '
629: || x_request_line_rec.reference);
630: inv_pp_debug.send_message_to_pipe('reference_type_code '
631: || x_request_line_rec.reference_type_code);
632: inv_pp_debug.send_message_to_pipe('reference_id '
633: || x_request_line_rec.reference_id);
634: inv_pp_debug.send_message_to_pipe('project_id '
635: || x_request_line_rec.project_id);
636: inv_pp_debug.send_message_to_pipe('task_id '

Line 634: inv_pp_debug.send_message_to_pipe('project_id '

630: inv_pp_debug.send_message_to_pipe('reference_type_code '
631: || x_request_line_rec.reference_type_code);
632: inv_pp_debug.send_message_to_pipe('reference_id '
633: || x_request_line_rec.reference_id);
634: inv_pp_debug.send_message_to_pipe('project_id '
635: || x_request_line_rec.project_id);
636: inv_pp_debug.send_message_to_pipe('task_id '
637: || x_request_line_rec.task_id);
638: inv_pp_debug.send_message_to_pipe('transaction_header_id '

Line 636: inv_pp_debug.send_message_to_pipe('task_id '

632: inv_pp_debug.send_message_to_pipe('reference_id '
633: || x_request_line_rec.reference_id);
634: inv_pp_debug.send_message_to_pipe('project_id '
635: || x_request_line_rec.project_id);
636: inv_pp_debug.send_message_to_pipe('task_id '
637: || x_request_line_rec.task_id);
638: inv_pp_debug.send_message_to_pipe('transaction_header_id '
639: || x_request_line_rec.transaction_header_id);
640: inv_pp_debug.send_message_to_pipe('line_status '

Line 638: inv_pp_debug.send_message_to_pipe('transaction_header_id '

634: inv_pp_debug.send_message_to_pipe('project_id '
635: || x_request_line_rec.project_id);
636: inv_pp_debug.send_message_to_pipe('task_id '
637: || x_request_line_rec.task_id);
638: inv_pp_debug.send_message_to_pipe('transaction_header_id '
639: || x_request_line_rec.transaction_header_id);
640: inv_pp_debug.send_message_to_pipe('line_status '
641: || x_request_line_rec.line_status);
642: inv_pp_debug.send_message_to_pipe('status_date '

Line 640: inv_pp_debug.send_message_to_pipe('line_status '

636: inv_pp_debug.send_message_to_pipe('task_id '
637: || x_request_line_rec.task_id);
638: inv_pp_debug.send_message_to_pipe('transaction_header_id '
639: || x_request_line_rec.transaction_header_id);
640: inv_pp_debug.send_message_to_pipe('line_status '
641: || x_request_line_rec.line_status);
642: inv_pp_debug.send_message_to_pipe('status_date '
643: || x_request_line_rec.status_date);
644: inv_pp_debug.send_message_to_pipe('txn_source_id '

Line 642: inv_pp_debug.send_message_to_pipe('status_date '

638: inv_pp_debug.send_message_to_pipe('transaction_header_id '
639: || x_request_line_rec.transaction_header_id);
640: inv_pp_debug.send_message_to_pipe('line_status '
641: || x_request_line_rec.line_status);
642: inv_pp_debug.send_message_to_pipe('status_date '
643: || x_request_line_rec.status_date);
644: inv_pp_debug.send_message_to_pipe('txn_source_id '
645: || x_request_line_rec.txn_source_id);
646: inv_pp_debug.send_message_to_pipe('txn_source_line_id '

Line 644: inv_pp_debug.send_message_to_pipe('txn_source_id '

640: inv_pp_debug.send_message_to_pipe('line_status '
641: || x_request_line_rec.line_status);
642: inv_pp_debug.send_message_to_pipe('status_date '
643: || x_request_line_rec.status_date);
644: inv_pp_debug.send_message_to_pipe('txn_source_id '
645: || x_request_line_rec.txn_source_id);
646: inv_pp_debug.send_message_to_pipe('txn_source_line_id '
647: || x_request_line_rec.txn_source_line_id);
648: inv_pp_debug.send_message_to_pipe('txn_source_line_detail_id '

Line 646: inv_pp_debug.send_message_to_pipe('txn_source_line_id '

642: inv_pp_debug.send_message_to_pipe('status_date '
643: || x_request_line_rec.status_date);
644: inv_pp_debug.send_message_to_pipe('txn_source_id '
645: || x_request_line_rec.txn_source_id);
646: inv_pp_debug.send_message_to_pipe('txn_source_line_id '
647: || x_request_line_rec.txn_source_line_id);
648: inv_pp_debug.send_message_to_pipe('txn_source_line_detail_id '
649: || x_request_line_rec.txn_source_line_detail_id);
650: inv_pp_debug.send_message_to_pipe('transaction_type_id '

Line 648: inv_pp_debug.send_message_to_pipe('txn_source_line_detail_id '

644: inv_pp_debug.send_message_to_pipe('txn_source_id '
645: || x_request_line_rec.txn_source_id);
646: inv_pp_debug.send_message_to_pipe('txn_source_line_id '
647: || x_request_line_rec.txn_source_line_id);
648: inv_pp_debug.send_message_to_pipe('txn_source_line_detail_id '
649: || x_request_line_rec.txn_source_line_detail_id);
650: inv_pp_debug.send_message_to_pipe('transaction_type_id '
651: || x_request_line_rec.transaction_type_id);
652: inv_pp_debug.send_message_to_pipe('transaction_source_type_id '

Line 650: inv_pp_debug.send_message_to_pipe('transaction_type_id '

646: inv_pp_debug.send_message_to_pipe('txn_source_line_id '
647: || x_request_line_rec.txn_source_line_id);
648: inv_pp_debug.send_message_to_pipe('txn_source_line_detail_id '
649: || x_request_line_rec.txn_source_line_detail_id);
650: inv_pp_debug.send_message_to_pipe('transaction_type_id '
651: || x_request_line_rec.transaction_type_id);
652: inv_pp_debug.send_message_to_pipe('transaction_source_type_id '
653: || x_request_line_rec.transaction_source_type_id);
654: inv_pp_debug.send_message_to_pipe('primary_quantity '

Line 652: inv_pp_debug.send_message_to_pipe('transaction_source_type_id '

648: inv_pp_debug.send_message_to_pipe('txn_source_line_detail_id '
649: || x_request_line_rec.txn_source_line_detail_id);
650: inv_pp_debug.send_message_to_pipe('transaction_type_id '
651: || x_request_line_rec.transaction_type_id);
652: inv_pp_debug.send_message_to_pipe('transaction_source_type_id '
653: || x_request_line_rec.transaction_source_type_id);
654: inv_pp_debug.send_message_to_pipe('primary_quantity '
655: || x_request_line_rec.primary_quantity);
656: inv_pp_debug.send_message_to_pipe('to_organization_id '

Line 654: inv_pp_debug.send_message_to_pipe('primary_quantity '

650: inv_pp_debug.send_message_to_pipe('transaction_type_id '
651: || x_request_line_rec.transaction_type_id);
652: inv_pp_debug.send_message_to_pipe('transaction_source_type_id '
653: || x_request_line_rec.transaction_source_type_id);
654: inv_pp_debug.send_message_to_pipe('primary_quantity '
655: || x_request_line_rec.primary_quantity);
656: inv_pp_debug.send_message_to_pipe('to_organization_id '
657: || x_request_line_rec.to_organization_id);
658: inv_pp_debug.send_message_to_pipe('put_away_strategy_id '

Line 656: inv_pp_debug.send_message_to_pipe('to_organization_id '

652: inv_pp_debug.send_message_to_pipe('transaction_source_type_id '
653: || x_request_line_rec.transaction_source_type_id);
654: inv_pp_debug.send_message_to_pipe('primary_quantity '
655: || x_request_line_rec.primary_quantity);
656: inv_pp_debug.send_message_to_pipe('to_organization_id '
657: || x_request_line_rec.to_organization_id);
658: inv_pp_debug.send_message_to_pipe('put_away_strategy_id '
659: || x_request_line_rec.put_away_strategy_id);
660: inv_pp_debug.send_message_to_pipe('pick_strategy_id '

Line 658: inv_pp_debug.send_message_to_pipe('put_away_strategy_id '

654: inv_pp_debug.send_message_to_pipe('primary_quantity '
655: || x_request_line_rec.primary_quantity);
656: inv_pp_debug.send_message_to_pipe('to_organization_id '
657: || x_request_line_rec.to_organization_id);
658: inv_pp_debug.send_message_to_pipe('put_away_strategy_id '
659: || x_request_line_rec.put_away_strategy_id);
660: inv_pp_debug.send_message_to_pipe('pick_strategy_id '
661: || x_request_line_rec.pick_strategy_id);
662: inv_pp_debug.send_message_to_pipe('unit_number '

Line 660: inv_pp_debug.send_message_to_pipe('pick_strategy_id '

656: inv_pp_debug.send_message_to_pipe('to_organization_id '
657: || x_request_line_rec.to_organization_id);
658: inv_pp_debug.send_message_to_pipe('put_away_strategy_id '
659: || x_request_line_rec.put_away_strategy_id);
660: inv_pp_debug.send_message_to_pipe('pick_strategy_id '
661: || x_request_line_rec.pick_strategy_id);
662: inv_pp_debug.send_message_to_pipe('unit_number '
663: || x_request_line_rec.unit_number);
664: inv_pp_debug.send_message_to_pipe

Line 662: inv_pp_debug.send_message_to_pipe('unit_number '

658: inv_pp_debug.send_message_to_pipe('put_away_strategy_id '
659: || x_request_line_rec.put_away_strategy_id);
660: inv_pp_debug.send_message_to_pipe('pick_strategy_id '
661: || x_request_line_rec.pick_strategy_id);
662: inv_pp_debug.send_message_to_pipe('unit_number '
663: || x_request_line_rec.unit_number);
664: inv_pp_debug.send_message_to_pipe
665: ('======== Request Context ========');
666: inv_pp_debug.send_message_to_pipe

Line 664: inv_pp_debug.send_message_to_pipe

660: inv_pp_debug.send_message_to_pipe('pick_strategy_id '
661: || x_request_line_rec.pick_strategy_id);
662: inv_pp_debug.send_message_to_pipe('unit_number '
663: || x_request_line_rec.unit_number);
664: inv_pp_debug.send_message_to_pipe
665: ('======== Request Context ========');
666: inv_pp_debug.send_message_to_pipe
667: ('type_code = '|| x_request_context.type_code);
668: IF x_request_context.transfer_flag THEN

Line 666: inv_pp_debug.send_message_to_pipe

662: inv_pp_debug.send_message_to_pipe('unit_number '
663: || x_request_line_rec.unit_number);
664: inv_pp_debug.send_message_to_pipe
665: ('======== Request Context ========');
666: inv_pp_debug.send_message_to_pipe
667: ('type_code = '|| x_request_context.type_code);
668: IF x_request_context.transfer_flag THEN
669: inv_pp_debug.send_message_to_pipe('transfer_flag = true');
670: ELSE

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

665: ('======== Request Context ========');
666: inv_pp_debug.send_message_to_pipe
667: ('type_code = '|| x_request_context.type_code);
668: IF x_request_context.transfer_flag THEN
669: inv_pp_debug.send_message_to_pipe('transfer_flag = true');
670: ELSE
671: inv_pp_debug.send_message_to_pipe('transfer_flag = false');
672: END IF;
673: inv_pp_debug.send_message_to_pipe

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

667: ('type_code = '|| x_request_context.type_code);
668: IF x_request_context.transfer_flag THEN
669: inv_pp_debug.send_message_to_pipe('transfer_flag = true');
670: ELSE
671: inv_pp_debug.send_message_to_pipe('transfer_flag = false');
672: END IF;
673: inv_pp_debug.send_message_to_pipe
674: ('transaction_action_id = '|| x_request_context.transaction_action_id);
675: inv_pp_debug.send_message_to_pipe

Line 673: inv_pp_debug.send_message_to_pipe

669: inv_pp_debug.send_message_to_pipe('transfer_flag = true');
670: ELSE
671: inv_pp_debug.send_message_to_pipe('transfer_flag = false');
672: END IF;
673: inv_pp_debug.send_message_to_pipe
674: ('transaction_action_id = '|| x_request_context.transaction_action_id);
675: inv_pp_debug.send_message_to_pipe
676: ('item_revision_control = '|| x_request_context.item_revision_control);
677: inv_pp_debug.send_message_to_pipe

Line 675: inv_pp_debug.send_message_to_pipe

671: inv_pp_debug.send_message_to_pipe('transfer_flag = false');
672: END IF;
673: inv_pp_debug.send_message_to_pipe
674: ('transaction_action_id = '|| x_request_context.transaction_action_id);
675: inv_pp_debug.send_message_to_pipe
676: ('item_revision_control = '|| x_request_context.item_revision_control);
677: inv_pp_debug.send_message_to_pipe
678: ('item_lot_control_code = '|| x_request_context.item_lot_control_code);
679: inv_pp_debug.send_message_to_pipe

Line 677: inv_pp_debug.send_message_to_pipe

673: inv_pp_debug.send_message_to_pipe
674: ('transaction_action_id = '|| x_request_context.transaction_action_id);
675: inv_pp_debug.send_message_to_pipe
676: ('item_revision_control = '|| x_request_context.item_revision_control);
677: inv_pp_debug.send_message_to_pipe
678: ('item_lot_control_code = '|| x_request_context.item_lot_control_code);
679: inv_pp_debug.send_message_to_pipe
680: ('item_serial_control_code = '|| x_request_context.item_serial_control_code);
681: inv_pp_debug.send_message_to_pipe

Line 679: inv_pp_debug.send_message_to_pipe

675: inv_pp_debug.send_message_to_pipe
676: ('item_revision_control = '|| x_request_context.item_revision_control);
677: inv_pp_debug.send_message_to_pipe
678: ('item_lot_control_code = '|| x_request_context.item_lot_control_code);
679: inv_pp_debug.send_message_to_pipe
680: ('item_serial_control_code = '|| x_request_context.item_serial_control_code);
681: inv_pp_debug.send_message_to_pipe
682: ('lot_expiration_date = '|| x_request_context.lot_expiration_date);
683: inv_pp_debug.send_message_to_pipe

Line 681: inv_pp_debug.send_message_to_pipe

677: inv_pp_debug.send_message_to_pipe
678: ('item_lot_control_code = '|| x_request_context.item_lot_control_code);
679: inv_pp_debug.send_message_to_pipe
680: ('item_serial_control_code = '|| x_request_context.item_serial_control_code);
681: inv_pp_debug.send_message_to_pipe
682: ('lot_expiration_date = '|| x_request_context.lot_expiration_date);
683: inv_pp_debug.send_message_to_pipe
684: ('primary_uom_code = '|| x_request_context.primary_uom_code);
685: inv_pp_debug.send_message_to_pipe

Line 683: inv_pp_debug.send_message_to_pipe

679: inv_pp_debug.send_message_to_pipe
680: ('item_serial_control_code = '|| x_request_context.item_serial_control_code);
681: inv_pp_debug.send_message_to_pipe
682: ('lot_expiration_date = '|| x_request_context.lot_expiration_date);
683: inv_pp_debug.send_message_to_pipe
684: ('primary_uom_code = '|| x_request_context.primary_uom_code);
685: inv_pp_debug.send_message_to_pipe
686: ('transaction_uom_code = '|| x_request_context.transaction_uom_code);
687: inv_pp_debug.send_message_to_pipe

Line 685: inv_pp_debug.send_message_to_pipe

681: inv_pp_debug.send_message_to_pipe
682: ('lot_expiration_date = '|| x_request_context.lot_expiration_date);
683: inv_pp_debug.send_message_to_pipe
684: ('primary_uom_code = '|| x_request_context.primary_uom_code);
685: inv_pp_debug.send_message_to_pipe
686: ('transaction_uom_code = '|| x_request_context.transaction_uom_code);
687: inv_pp_debug.send_message_to_pipe
688: ('pick_strategy_id = '|| x_request_context.pick_strategy_id);
689: inv_pp_debug.send_message_to_pipe

Line 687: inv_pp_debug.send_message_to_pipe

683: inv_pp_debug.send_message_to_pipe
684: ('primary_uom_code = '|| x_request_context.primary_uom_code);
685: inv_pp_debug.send_message_to_pipe
686: ('transaction_uom_code = '|| x_request_context.transaction_uom_code);
687: inv_pp_debug.send_message_to_pipe
688: ('pick_strategy_id = '|| x_request_context.pick_strategy_id);
689: inv_pp_debug.send_message_to_pipe
690: ('put_away_strategy_id = '|| x_request_context.put_away_strategy_id);
691: inv_pp_debug.send_message_to_pipe

Line 689: inv_pp_debug.send_message_to_pipe

685: inv_pp_debug.send_message_to_pipe
686: ('transaction_uom_code = '|| x_request_context.transaction_uom_code);
687: inv_pp_debug.send_message_to_pipe
688: ('pick_strategy_id = '|| x_request_context.pick_strategy_id);
689: inv_pp_debug.send_message_to_pipe
690: ('put_away_strategy_id = '|| x_request_context.put_away_strategy_id);
691: inv_pp_debug.send_message_to_pipe
692: ('txn_header_id = '|| x_request_context.txn_header_id);
693: inv_pp_debug.send_message_to_pipe

Line 691: inv_pp_debug.send_message_to_pipe

687: inv_pp_debug.send_message_to_pipe
688: ('pick_strategy_id = '|| x_request_context.pick_strategy_id);
689: inv_pp_debug.send_message_to_pipe
690: ('put_away_strategy_id = '|| x_request_context.put_away_strategy_id);
691: inv_pp_debug.send_message_to_pipe
692: ('txn_header_id = '|| x_request_context.txn_header_id);
693: inv_pp_debug.send_message_to_pipe
694: ('txn_line_id = '|| x_request_context.txn_line_id);
695: inv_pp_debug.send_message_to_pipe

Line 693: inv_pp_debug.send_message_to_pipe

689: inv_pp_debug.send_message_to_pipe
690: ('put_away_strategy_id = '|| x_request_context.put_away_strategy_id);
691: inv_pp_debug.send_message_to_pipe
692: ('txn_header_id = '|| x_request_context.txn_header_id);
693: inv_pp_debug.send_message_to_pipe
694: ('txn_line_id = '|| x_request_context.txn_line_id);
695: inv_pp_debug.send_message_to_pipe
696: ('txn_line_detail = '|| x_request_context.txn_line_detail);
697: inv_pp_debug.send_message_to_pipe

Line 695: inv_pp_debug.send_message_to_pipe

691: inv_pp_debug.send_message_to_pipe
692: ('txn_header_id = '|| x_request_context.txn_header_id);
693: inv_pp_debug.send_message_to_pipe
694: ('txn_line_id = '|| x_request_context.txn_line_id);
695: inv_pp_debug.send_message_to_pipe
696: ('txn_line_detail = '|| x_request_context.txn_line_detail);
697: inv_pp_debug.send_message_to_pipe
698: ('customer_id = '|| x_request_context.customer_id);
699: inv_pp_debug.send_message_to_pipe

Line 697: inv_pp_debug.send_message_to_pipe

693: inv_pp_debug.send_message_to_pipe
694: ('txn_line_id = '|| x_request_context.txn_line_id);
695: inv_pp_debug.send_message_to_pipe
696: ('txn_line_detail = '|| x_request_context.txn_line_detail);
697: inv_pp_debug.send_message_to_pipe
698: ('customer_id = '|| x_request_context.customer_id);
699: inv_pp_debug.send_message_to_pipe
700: ('customer_number = '|| x_request_context.customer_number);
701: inv_pp_debug.send_message_to_pipe

Line 699: inv_pp_debug.send_message_to_pipe

695: inv_pp_debug.send_message_to_pipe
696: ('txn_line_detail = '|| x_request_context.txn_line_detail);
697: inv_pp_debug.send_message_to_pipe
698: ('customer_id = '|| x_request_context.customer_id);
699: inv_pp_debug.send_message_to_pipe
700: ('customer_number = '|| x_request_context.customer_number);
701: inv_pp_debug.send_message_to_pipe
702: ('ship_to_location = '|| x_request_context.ship_to_location);
703: inv_pp_debug.send_message_to_pipe

Line 701: inv_pp_debug.send_message_to_pipe

697: inv_pp_debug.send_message_to_pipe
698: ('customer_id = '|| x_request_context.customer_id);
699: inv_pp_debug.send_message_to_pipe
700: ('customer_number = '|| x_request_context.customer_number);
701: inv_pp_debug.send_message_to_pipe
702: ('ship_to_location = '|| x_request_context.ship_to_location);
703: inv_pp_debug.send_message_to_pipe
704: ('shipment_number = '|| x_request_context.shipment_number);
705: inv_pp_debug.send_message_to_pipe

Line 703: inv_pp_debug.send_message_to_pipe

699: inv_pp_debug.send_message_to_pipe
700: ('customer_number = '|| x_request_context.customer_number);
701: inv_pp_debug.send_message_to_pipe
702: ('ship_to_location = '|| x_request_context.ship_to_location);
703: inv_pp_debug.send_message_to_pipe
704: ('shipment_number = '|| x_request_context.shipment_number);
705: inv_pp_debug.send_message_to_pipe
706: ('freight_code = '|| x_request_context.freight_code);
707: --

Line 705: inv_pp_debug.send_message_to_pipe

701: inv_pp_debug.send_message_to_pipe
702: ('ship_to_location = '|| x_request_context.ship_to_location);
703: inv_pp_debug.send_message_to_pipe
704: ('shipment_number = '|| x_request_context.shipment_number);
705: inv_pp_debug.send_message_to_pipe
706: ('freight_code = '|| x_request_context.freight_code);
707: --
708: inv_pp_debug.send_message_to_pipe
709: ('exit '||g_pkg_name||'.'||l_api_name);

Line 708: inv_pp_debug.send_message_to_pipe

704: ('shipment_number = '|| x_request_context.shipment_number);
705: inv_pp_debug.send_message_to_pipe
706: ('freight_code = '|| x_request_context.freight_code);
707: --
708: inv_pp_debug.send_message_to_pipe
709: ('exit '||g_pkg_name||'.'||l_api_name);
710: END IF;
711: -- end of debugging section
712: --

Line 718: IF inv_pp_debug.is_debug_mode THEN

714: WHEN fnd_api.g_exc_error THEN
715: --
716: -- debugging section
717: -- can be commented ut for final code
718: IF inv_pp_debug.is_debug_mode THEN
719: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
720: -- the message retrieved here since it is no longer on the stack
721: inv_pp_debug.set_last_error_message(Sqlerrm);
722: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 721: inv_pp_debug.set_last_error_message(Sqlerrm);

717: -- can be commented ut for final code
718: IF inv_pp_debug.is_debug_mode THEN
719: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
720: -- the message retrieved here since it is no longer on the stack
721: inv_pp_debug.set_last_error_message(Sqlerrm);
722: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
723: inv_pp_debug.send_last_error_message;
724: END IF;
725: -- end of debugging section

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

718: IF inv_pp_debug.is_debug_mode THEN
719: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
720: -- the message retrieved here since it is no longer on the stack
721: inv_pp_debug.set_last_error_message(Sqlerrm);
722: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
723: inv_pp_debug.send_last_error_message;
724: END IF;
725: -- end of debugging section
726: --

Line 723: inv_pp_debug.send_last_error_message;

719: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
720: -- the message retrieved here since it is no longer on the stack
721: inv_pp_debug.set_last_error_message(Sqlerrm);
722: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
723: inv_pp_debug.send_last_error_message;
724: END IF;
725: -- end of debugging section
726: --
727: x_return_status := fnd_api.g_ret_sts_error;

Line 742: IF inv_pp_debug.is_debug_mode THEN

738: WHEN fnd_api.g_exc_unexpected_error THEN
739: --
740: -- debugging section
741: -- can be commented ut for final code
742: IF inv_pp_debug.is_debug_mode THEN
743: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
744: -- the message retrieved here since it is no longer on the stack
745: inv_pp_debug.set_last_error_message(Sqlerrm);
746: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 745: inv_pp_debug.set_last_error_message(Sqlerrm);

741: -- can be commented ut for final code
742: IF inv_pp_debug.is_debug_mode THEN
743: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
744: -- the message retrieved here since it is no longer on the stack
745: inv_pp_debug.set_last_error_message(Sqlerrm);
746: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
747: inv_pp_debug.send_last_error_message;
748: END IF;
749: -- end of debugging section

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

742: IF inv_pp_debug.is_debug_mode THEN
743: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
744: -- the message retrieved here since it is no longer on the stack
745: inv_pp_debug.set_last_error_message(Sqlerrm);
746: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
747: inv_pp_debug.send_last_error_message;
748: END IF;
749: -- end of debugging section
750: --

Line 747: inv_pp_debug.send_last_error_message;

743: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
744: -- the message retrieved here since it is no longer on the stack
745: inv_pp_debug.set_last_error_message(Sqlerrm);
746: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
747: inv_pp_debug.send_last_error_message;
748: END IF;
749: -- end of debugging section
750: --
751: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 766: IF inv_pp_debug.is_debug_mode THEN

762: WHEN OTHERS 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_unexp_error;

Line 814: IF inv_pp_debug.is_debug_mode THEN

810: l_sec_reserved_qty NUMBER;
811: l_res_index NUMBER;
812: l_index NUMBER := 0;
813: BEGIN
814: IF inv_pp_debug.is_debug_mode THEN
815: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
816: END IF;
817: -- split the picking request into multiple records
818: -- based on reservations

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

811: l_res_index NUMBER;
812: l_index NUMBER := 0;
813: BEGIN
814: IF inv_pp_debug.is_debug_mode THEN
815: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
816: END IF;
817: -- split the picking request into multiple records
818: -- based on reservations
819: --

Line 992: IF inv_pp_debug.is_debug_mode THEN

988:
989: -- Bug # 2286454-----------------------
990: x_remaining_quantity := l_remain_pri_qty;
991:
992: IF inv_pp_debug.is_debug_mode THEN
993: inv_pp_debug.send_message_to_pipe('detail table size: ' || x_detail_level_tbl_size);
994: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
995: END IF;
996: --

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

989: -- Bug # 2286454-----------------------
990: x_remaining_quantity := l_remain_pri_qty;
991:
992: IF inv_pp_debug.is_debug_mode THEN
993: inv_pp_debug.send_message_to_pipe('detail table size: ' || x_detail_level_tbl_size);
994: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
995: END IF;
996: --
997: EXCEPTION

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

990: x_remaining_quantity := l_remain_pri_qty;
991:
992: IF inv_pp_debug.is_debug_mode THEN
993: inv_pp_debug.send_message_to_pipe('detail table size: ' || x_detail_level_tbl_size);
994: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
995: END IF;
996: --
997: EXCEPTION
998: when fnd_api.g_exc_error then

Line 1024: IF inv_pp_debug.is_debug_mode THEN

1020: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
1021: l_api_name VARCHAR2(30) := 'validate_and_init';
1022: BEGIN
1023: --
1024: IF inv_pp_debug.is_debug_mode THEN
1025: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
1026: END IF;
1027: -- Validation and Initialization
1028: --

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

1021: l_api_name VARCHAR2(30) := 'validate_and_init';
1022: BEGIN
1023: --
1024: IF inv_pp_debug.is_debug_mode THEN
1025: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
1026: END IF;
1027: -- Validation and Initialization
1028: --
1029: print_debug('in inv validate and init');

Line 1077: IF inv_pp_debug.is_debug_mode THEN

1073: x_request_line_rec.serial_number_end IS NOT NULL)) THEN
1074: x_request_context.detail_serial := TRUE;
1075: ELSE
1076: x_request_context.detail_serial := FALSE;
1077: IF inv_pp_debug.is_debug_mode THEN
1078: inv_pp_debug.send_message_to_pipe('detail serial is FALSE');
1079: END IF;
1080:
1081: END IF;

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

1074: x_request_context.detail_serial := TRUE;
1075: ELSE
1076: x_request_context.detail_serial := FALSE;
1077: IF inv_pp_debug.is_debug_mode THEN
1078: inv_pp_debug.send_message_to_pipe('detail serial is FALSE');
1079: END IF;
1080:
1081: END IF;
1082:

Line 1086: IF inv_pp_debug.is_debug_mode THEN

1082:
1083: -- initialize serial output table
1084: init_output_serial_rows;
1085: x_return_status := l_return_status;
1086: IF inv_pp_debug.is_debug_mode THEN
1087: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
1088: END IF;
1089: --
1090: EXCEPTION

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

1083: -- initialize serial output table
1084: init_output_serial_rows;
1085: x_return_status := l_return_status;
1086: IF inv_pp_debug.is_debug_mode THEN
1087: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
1088: END IF;
1089: --
1090: EXCEPTION
1091: when fnd_api.g_exc_error then

Line 1899: IF inv_pp_debug.is_debug_mode THEN

1895: BEGIN
1896: --
1897: -- debugging portion
1898: -- can be commented ut for final code
1899: IF inv_pp_debug.is_debug_mode THEN
1900: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
1901: END IF;
1902: -- end of debugging section
1903: --

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

1896: --
1897: -- debugging portion
1898: -- can be commented ut for final code
1899: IF inv_pp_debug.is_debug_mode THEN
1900: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
1901: END IF;
1902: -- end of debugging section
1903: --
1904: -- Initialisize API return status to access

Line 2316: IF inv_pp_debug.is_debug_mode THEN

2312: END LOOP;
2313: --
2314: -- debugging portion
2315: -- can be commented ut for final code
2316: IF inv_pp_debug.is_debug_mode THEN
2317: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
2318: END IF;
2319: -- end of debugging section
2320: --

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

2313: --
2314: -- debugging portion
2315: -- can be commented ut for final code
2316: IF inv_pp_debug.is_debug_mode THEN
2317: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
2318: END IF;
2319: -- end of debugging section
2320: --
2321: EXCEPTION

Line 2326: IF inv_pp_debug.is_debug_mode THEN

2322: when fnd_api.g_exc_error then
2323: --
2324: -- debugging portion
2325: -- can be commented ut for final code
2326: IF inv_pp_debug.is_debug_mode THEN
2327: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2328: -- the message retrieved here since it is no longer on the stack
2329: inv_pp_debug.set_last_error_message(Sqlerrm);
2330: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 2329: inv_pp_debug.set_last_error_message(Sqlerrm);

2325: -- can be commented ut for final code
2326: IF inv_pp_debug.is_debug_mode THEN
2327: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2328: -- the message retrieved here since it is no longer on the stack
2329: inv_pp_debug.set_last_error_message(Sqlerrm);
2330: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2331: inv_pp_debug.send_last_error_message;
2332: END IF;
2333: -- end of debugging section

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

2326: IF inv_pp_debug.is_debug_mode THEN
2327: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2328: -- the message retrieved here since it is no longer on the stack
2329: inv_pp_debug.set_last_error_message(Sqlerrm);
2330: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2331: inv_pp_debug.send_last_error_message;
2332: END IF;
2333: -- end of debugging section
2334: --

Line 2331: inv_pp_debug.send_last_error_message;

2327: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2328: -- the message retrieved here since it is no longer on the stack
2329: inv_pp_debug.set_last_error_message(Sqlerrm);
2330: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2331: inv_pp_debug.send_last_error_message;
2332: END IF;
2333: -- end of debugging section
2334: --
2335: x_return_status := fnd_api.g_ret_sts_error;

Line 2341: IF inv_pp_debug.is_debug_mode THEN

2337: when fnd_api.g_exc_unexpected_error then
2338: --
2339: -- debugging portion
2340: -- can be commented ut for final code
2341: IF inv_pp_debug.is_debug_mode THEN
2342: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2343: -- the message retrieved here since it is no longer on the stack
2344: inv_pp_debug.set_last_error_message(Sqlerrm);
2345: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 2344: inv_pp_debug.set_last_error_message(Sqlerrm);

2340: -- can be commented ut for final code
2341: IF inv_pp_debug.is_debug_mode THEN
2342: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2343: -- the message retrieved here since it is no longer on the stack
2344: inv_pp_debug.set_last_error_message(Sqlerrm);
2345: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2346: inv_pp_debug.send_last_error_message;
2347: END IF;
2348: -- end of debugging section

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

2341: IF inv_pp_debug.is_debug_mode THEN
2342: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2343: -- the message retrieved here since it is no longer on the stack
2344: inv_pp_debug.set_last_error_message(Sqlerrm);
2345: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2346: inv_pp_debug.send_last_error_message;
2347: END IF;
2348: -- end of debugging section
2349: --

Line 2346: inv_pp_debug.send_last_error_message;

2342: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2343: -- the message retrieved here since it is no longer on the stack
2344: inv_pp_debug.set_last_error_message(Sqlerrm);
2345: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2346: inv_pp_debug.send_last_error_message;
2347: END IF;
2348: -- end of debugging section
2349: --
2350: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2356: IF inv_pp_debug.is_debug_mode THEN

2352: when others then
2353: --
2354: -- debugging portion
2355: -- can be commented ut for final code
2356: IF inv_pp_debug.is_debug_mode THEN
2357: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2358: -- the message retrieved here since it is no longer on the stack
2359: inv_pp_debug.set_last_error_message(Sqlerrm);
2360: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 2359: inv_pp_debug.set_last_error_message(Sqlerrm);

2355: -- can be commented ut for final code
2356: IF inv_pp_debug.is_debug_mode THEN
2357: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2358: -- the message retrieved here since it is no longer on the stack
2359: inv_pp_debug.set_last_error_message(Sqlerrm);
2360: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2361: inv_pp_debug.send_last_error_message;
2362: END IF;
2363: -- end of debugging section

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

2356: IF inv_pp_debug.is_debug_mode THEN
2357: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2358: -- the message retrieved here since it is no longer on the stack
2359: inv_pp_debug.set_last_error_message(Sqlerrm);
2360: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2361: inv_pp_debug.send_last_error_message;
2362: END IF;
2363: -- end of debugging section
2364: --

Line 2361: inv_pp_debug.send_last_error_message;

2357: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2358: -- the message retrieved here since it is no longer on the stack
2359: inv_pp_debug.set_last_error_message(Sqlerrm);
2360: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2361: inv_pp_debug.send_last_error_message;
2362: END IF;
2363: -- end of debugging section
2364: --
2365: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2390: IF inv_pp_debug.is_debug_mode THEN

2386: BEGIN
2387: --
2388: -- debugging portion
2389: -- can be commented ut for final code
2390: IF inv_pp_debug.is_debug_mode THEN
2391: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
2392: END IF;
2393: -- end of debugging section
2394: --

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

2387: --
2388: -- debugging portion
2389: -- can be commented ut for final code
2390: IF inv_pp_debug.is_debug_mode THEN
2391: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
2392: END IF;
2393: -- end of debugging section
2394: --
2395: -- Initialisize API return status to access

Line 2632: IF inv_pp_debug.is_debug_mode THEN

2628: END LOOP;
2629: --
2630: -- debugging portion
2631: -- can be commented ut for final code
2632: IF inv_pp_debug.is_debug_mode THEN
2633: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
2634: END IF;
2635: -- end of debugging section
2636: --

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

2629: --
2630: -- debugging portion
2631: -- can be commented ut for final code
2632: IF inv_pp_debug.is_debug_mode THEN
2633: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
2634: END IF;
2635: -- end of debugging section
2636: --
2637: EXCEPTION

Line 2642: IF inv_pp_debug.is_debug_mode THEN

2638: when fnd_api.g_exc_error then
2639: --
2640: -- debugging portion
2641: -- can be commented ut for final code
2642: IF inv_pp_debug.is_debug_mode THEN
2643: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2644: -- the message retrieved here since it is no longer on the stack
2645: inv_pp_debug.set_last_error_message(Sqlerrm);
2646: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 2645: inv_pp_debug.set_last_error_message(Sqlerrm);

2641: -- can be commented ut for final code
2642: IF inv_pp_debug.is_debug_mode THEN
2643: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2644: -- the message retrieved here since it is no longer on the stack
2645: inv_pp_debug.set_last_error_message(Sqlerrm);
2646: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2647: inv_pp_debug.send_last_error_message;
2648: END IF;
2649: -- end of debugging section

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

2642: IF inv_pp_debug.is_debug_mode THEN
2643: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2644: -- the message retrieved here since it is no longer on the stack
2645: inv_pp_debug.set_last_error_message(Sqlerrm);
2646: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2647: inv_pp_debug.send_last_error_message;
2648: END IF;
2649: -- end of debugging section
2650: --

Line 2647: inv_pp_debug.send_last_error_message;

2643: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2644: -- the message retrieved here since it is no longer on the stack
2645: inv_pp_debug.set_last_error_message(Sqlerrm);
2646: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2647: inv_pp_debug.send_last_error_message;
2648: END IF;
2649: -- end of debugging section
2650: --
2651: x_return_status := fnd_api.g_ret_sts_error;

Line 2657: IF inv_pp_debug.is_debug_mode THEN

2653: when fnd_api.g_exc_unexpected_error then
2654: --
2655: -- debugging portion
2656: -- can be commented ut for final code
2657: IF inv_pp_debug.is_debug_mode THEN
2658: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2659: -- the message retrieved here since it is no longer on the stack
2660: inv_pp_debug.set_last_error_message(Sqlerrm);
2661: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 2660: inv_pp_debug.set_last_error_message(Sqlerrm);

2656: -- can be commented ut for final code
2657: IF inv_pp_debug.is_debug_mode THEN
2658: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2659: -- the message retrieved here since it is no longer on the stack
2660: inv_pp_debug.set_last_error_message(Sqlerrm);
2661: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2662: inv_pp_debug.send_last_error_message;
2663: END IF;
2664: -- end of debugging section

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

2657: IF inv_pp_debug.is_debug_mode THEN
2658: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2659: -- the message retrieved here since it is no longer on the stack
2660: inv_pp_debug.set_last_error_message(Sqlerrm);
2661: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2662: inv_pp_debug.send_last_error_message;
2663: END IF;
2664: -- end of debugging section
2665: --

Line 2662: inv_pp_debug.send_last_error_message;

2658: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2659: -- the message retrieved here since it is no longer on the stack
2660: inv_pp_debug.set_last_error_message(Sqlerrm);
2661: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2662: inv_pp_debug.send_last_error_message;
2663: END IF;
2664: -- end of debugging section
2665: --
2666: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2672: IF inv_pp_debug.is_debug_mode THEN

2668: when others then
2669: --
2670: -- debugging portion
2671: -- can be commented ut for final code
2672: IF inv_pp_debug.is_debug_mode THEN
2673: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2674: -- the message retrieved here since it is no longer on the stack
2675: inv_pp_debug.set_last_error_message(Sqlerrm);
2676: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 2675: inv_pp_debug.set_last_error_message(Sqlerrm);

2671: -- can be commented ut for final code
2672: IF inv_pp_debug.is_debug_mode THEN
2673: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2674: -- the message retrieved here since it is no longer on the stack
2675: inv_pp_debug.set_last_error_message(Sqlerrm);
2676: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2677: inv_pp_debug.send_last_error_message;
2678: END IF;
2679: -- end of debugging section

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

2672: IF inv_pp_debug.is_debug_mode THEN
2673: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2674: -- the message retrieved here since it is no longer on the stack
2675: inv_pp_debug.set_last_error_message(Sqlerrm);
2676: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2677: inv_pp_debug.send_last_error_message;
2678: END IF;
2679: -- end of debugging section
2680: --

Line 2677: inv_pp_debug.send_last_error_message;

2673: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
2674: -- the message retrieved here since it is no longer on the stack
2675: inv_pp_debug.set_last_error_message(Sqlerrm);
2676: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
2677: inv_pp_debug.send_last_error_message;
2678: END IF;
2679: -- end of debugging section
2680: --
2681: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 2706: IF inv_pp_debug.is_debug_mode THEN

2702: BEGIN
2703: --
2704: -- debugging portion
2705: -- can be commented ut for final code
2706: IF inv_pp_debug.is_debug_mode THEN
2707: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
2708: END IF;
2709: -- end of debugging section
2710: --

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

2703: --
2704: -- debugging portion
2705: -- can be commented ut for final code
2706: IF inv_pp_debug.is_debug_mode THEN
2707: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
2708: END IF;
2709: -- end of debugging section
2710: --
2711: -- 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 2943: IF inv_pp_debug.is_debug_mode THEN

2939: BEGIN
2940: --
2941: -- debugging section
2942: -- can be commented ut for final code
2943: IF inv_pp_debug.is_debug_mode THEN
2944: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
2945: END IF;
2946: -- end of debugging section
2947: --

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

2940: --
2941: -- debugging section
2942: -- can be commented ut for final code
2943: IF inv_pp_debug.is_debug_mode THEN
2944: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
2945: END IF;
2946: -- end of debugging section
2947: --
2948: g_output_process_tbl_size := 0;

Line 2953: IF inv_pp_debug.is_debug_mode THEN

2949: g_output_process_tbl.DELETE;
2950: --
2951: -- debugging section
2952: -- can be commented ut for final code
2953: IF inv_pp_debug.is_debug_mode THEN
2954: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
2955: END IF;
2956: -- end of debugging section
2957: --

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

2950: --
2951: -- debugging section
2952: -- can be commented ut for final code
2953: IF inv_pp_debug.is_debug_mode THEN
2954: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
2955: END IF;
2956: -- end of debugging section
2957: --
2958: END init_output_process_tbl;

Line 3113: IF inv_pp_debug.is_debug_mode THEN

3109: l_task_priority NUMBER;
3110: BEGIN
3111: -- debugging section
3112: -- can be commented ut for final code
3113: IF inv_pp_debug.is_debug_mode THEN
3114: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
3115: END IF;
3116: -- end of debugging section
3117: --

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

3110: BEGIN
3111: -- debugging section
3112: -- can be commented ut for final code
3113: IF inv_pp_debug.is_debug_mode THEN
3114: inv_pp_debug.send_message_to_pipe('enter '||g_pkg_name||'.'||l_api_name);
3115: END IF;
3116: -- end of debugging section
3117: --
3118: IF g_debug IS NULL or NOT INV_CACHE.is_pickrelease THEN

Line 3172: --IF inv_pp_debug.is_debug_mode THEN

3168: l_sec_lot_temp_qty := g_output_process_tbl(1).secondary_quantity;
3169: END IF;
3170: l_txn_temp_qty := g_output_process_tbl(1).primary_quantity;
3171: l_sec_txn_temp_qty := g_output_process_tbl(1).secondary_quantity;
3172: --IF inv_pp_debug.is_debug_mode THEN
3173: print_debug('process output before loop, lot pri qty '||l_lot_temp_qty);
3174: print_debug('process output before loop, lot sec qty '||l_sec_lot_temp_qty);
3175: print_debug('process output before loop, txn pri qty '||l_txn_temp_qty);
3176: print_debug('process output before loop, txn sec qty '||l_sec_txn_temp_qty);

Line 3265: IF inv_pp_debug.is_debug_mode THEN

3261: l_mtlt_tbl_size := l_mtlt_tbl_size +1;
3262: l_mtlt_tbl(l_mtlt_tbl_size).transaction_temp_id := l_txn_temp_id;
3263: l_mtlt_tbl(l_mtlt_tbl_size).primary_quantity := l_qty_sign * l_lot_temp_qty;
3264: l_mtlt_tbl(l_mtlt_tbl_size).secondary_quantity := l_qty_sign * l_sec_lot_temp_qty;
3265: IF inv_pp_debug.is_debug_mode THEN
3266: print_debug('process output , lot pri qty '||l_lot_temp_qty);
3267: print_debug('process output , lot sec qty '||l_sec_lot_temp_qty);
3268: END IF;
3269: l_mtlt_tbl(l_mtlt_tbl_size).lot_number := g_output_process_tbl(l_index-1).lot_number;

Line 3352: IF inv_pp_debug.is_debug_mode THEN

3348: l_mmtt_tbl(l_mmtt_tbl_size).primary_quantity:=
3349: l_qty_sign * l_txn_temp_qty;
3350: l_mmtt_tbl(l_mmtt_tbl_size).secondary_transaction_quantity:=
3351: l_qty_sign * l_sec_txn_temp_qty;
3352: IF inv_pp_debug.is_debug_mode THEN
3353: print_debug('process output , txn pri qty '||l_txn_temp_qty);
3354: print_debug('process output , txn sec qty '||l_sec_txn_temp_qty);
3355: inv_pp_debug.send_message_to_pipe('pri qty '|| l_txn_temp_qty);
3356: inv_pp_debug.send_message_to_pipe('qty_sign' || l_qty_sign);

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

3351: l_qty_sign * l_sec_txn_temp_qty;
3352: IF inv_pp_debug.is_debug_mode THEN
3353: print_debug('process output , txn pri qty '||l_txn_temp_qty);
3354: print_debug('process output , txn sec qty '||l_sec_txn_temp_qty);
3355: inv_pp_debug.send_message_to_pipe('pri qty '|| l_txn_temp_qty);
3356: inv_pp_debug.send_message_to_pipe('qty_sign' || l_qty_sign);
3357: inv_pp_debug.send_message_to_pipe('sec qty '|| l_sec_txn_temp_qty);
3358: END IF;
3359: l_mmtt_tbl(l_mmtt_tbl_size).transaction_quantity :=

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

3352: IF inv_pp_debug.is_debug_mode THEN
3353: print_debug('process output , txn pri qty '||l_txn_temp_qty);
3354: print_debug('process output , txn sec qty '||l_sec_txn_temp_qty);
3355: inv_pp_debug.send_message_to_pipe('pri qty '|| l_txn_temp_qty);
3356: inv_pp_debug.send_message_to_pipe('qty_sign' || l_qty_sign);
3357: inv_pp_debug.send_message_to_pipe('sec qty '|| l_sec_txn_temp_qty);
3358: END IF;
3359: l_mmtt_tbl(l_mmtt_tbl_size).transaction_quantity :=
3360: l_qty_sign *

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

3353: print_debug('process output , txn pri qty '||l_txn_temp_qty);
3354: print_debug('process output , txn sec qty '||l_sec_txn_temp_qty);
3355: inv_pp_debug.send_message_to_pipe('pri qty '|| l_txn_temp_qty);
3356: inv_pp_debug.send_message_to_pipe('qty_sign' || l_qty_sign);
3357: inv_pp_debug.send_message_to_pipe('sec qty '|| l_sec_txn_temp_qty);
3358: END IF;
3359: l_mmtt_tbl(l_mmtt_tbl_size).transaction_quantity :=
3360: l_qty_sign *
3361: inv_convert.inv_um_convert

Line 3633: IF inv_pp_debug.is_debug_mode THEN

3629: x_return_status := l_return_status;
3630: --
3631: -- debugging section
3632: -- can be commented ut for final code
3633: IF inv_pp_debug.is_debug_mode THEN
3634: inv_pp_debug.send_message_to_pipe('=================== create output records: ');
3635: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_material_transactions_temp: '
3636: || l_mmtt_tbl_size);
3637: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_transaction_lots_temp: '

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

3630: --
3631: -- debugging section
3632: -- can be commented ut for final code
3633: IF inv_pp_debug.is_debug_mode THEN
3634: inv_pp_debug.send_message_to_pipe('=================== create output records: ');
3635: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_material_transactions_temp: '
3636: || l_mmtt_tbl_size);
3637: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_transaction_lots_temp: '
3638: || l_mtlt_tbl_size);

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

3631: -- debugging section
3632: -- can be commented ut for final code
3633: IF inv_pp_debug.is_debug_mode THEN
3634: inv_pp_debug.send_message_to_pipe('=================== create output records: ');
3635: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_material_transactions_temp: '
3636: || l_mmtt_tbl_size);
3637: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_transaction_lots_temp: '
3638: || l_mtlt_tbl_size);
3639: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_serial_numbers_temp: '

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

3633: IF inv_pp_debug.is_debug_mode THEN
3634: inv_pp_debug.send_message_to_pipe('=================== create output records: ');
3635: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_material_transactions_temp: '
3636: || l_mmtt_tbl_size);
3637: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_transaction_lots_temp: '
3638: || l_mtlt_tbl_size);
3639: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_serial_numbers_temp: '
3640: || l_msnt_tbl_size);
3641: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);

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

3635: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_material_transactions_temp: '
3636: || l_mmtt_tbl_size);
3637: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_transaction_lots_temp: '
3638: || l_mtlt_tbl_size);
3639: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_serial_numbers_temp: '
3640: || l_msnt_tbl_size);
3641: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
3642: END IF;
3643: -- end of debugging section

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

3637: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_transaction_lots_temp: '
3638: || l_mtlt_tbl_size);
3639: inv_pp_debug.send_message_to_pipe('# of records inserted to mtl_serial_numbers_temp: '
3640: || l_msnt_tbl_size);
3641: inv_pp_debug.send_message_to_pipe('exit '||g_pkg_name||'.'||l_api_name);
3642: END IF;
3643: -- end of debugging section
3644: --
3645: EXCEPTION

Line 3650: IF inv_pp_debug.is_debug_mode THEN

3646: WHEN fnd_api.g_exc_error THEN
3647: --
3648: -- debugging section
3649: -- can be commented ut for final code
3650: IF inv_pp_debug.is_debug_mode THEN
3651: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
3652: -- the message retrieved here since it is no longer on the stack
3653: inv_pp_debug.set_last_error_message(Sqlerrm);
3654: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 3653: inv_pp_debug.set_last_error_message(Sqlerrm);

3649: -- can be commented ut for final code
3650: IF inv_pp_debug.is_debug_mode THEN
3651: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
3652: -- the message retrieved here since it is no longer on the stack
3653: inv_pp_debug.set_last_error_message(Sqlerrm);
3654: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
3655: inv_pp_debug.send_last_error_message;
3656: END IF;
3657: -- end of debugging section

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

3650: IF inv_pp_debug.is_debug_mode THEN
3651: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
3652: -- the message retrieved here since it is no longer on the stack
3653: inv_pp_debug.set_last_error_message(Sqlerrm);
3654: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
3655: inv_pp_debug.send_last_error_message;
3656: END IF;
3657: -- end of debugging section
3658: --

Line 3655: inv_pp_debug.send_last_error_message;

3651: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
3652: -- the message retrieved here since it is no longer on the stack
3653: inv_pp_debug.set_last_error_message(Sqlerrm);
3654: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
3655: inv_pp_debug.send_last_error_message;
3656: END IF;
3657: -- end of debugging section
3658: --
3659: x_return_status := fnd_api.g_ret_sts_error;

Line 3665: IF inv_pp_debug.is_debug_mode THEN

3661: WHEN fnd_api.g_exc_unexpected_error THEN
3662: --
3663: -- debugging section
3664: -- can be commented ut for final code
3665: IF inv_pp_debug.is_debug_mode THEN
3666: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
3667: -- the message retrieved here since it is no longer on the stack
3668: inv_pp_debug.set_last_error_message(Sqlerrm);
3669: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 3668: inv_pp_debug.set_last_error_message(Sqlerrm);

3664: -- can be commented ut for final code
3665: IF inv_pp_debug.is_debug_mode THEN
3666: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
3667: -- the message retrieved here since it is no longer on the stack
3668: inv_pp_debug.set_last_error_message(Sqlerrm);
3669: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
3670: inv_pp_debug.send_last_error_message;
3671: END IF;
3672: -- end of debugging section

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

3665: IF inv_pp_debug.is_debug_mode THEN
3666: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
3667: -- the message retrieved here since it is no longer on the stack
3668: inv_pp_debug.set_last_error_message(Sqlerrm);
3669: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
3670: inv_pp_debug.send_last_error_message;
3671: END IF;
3672: -- end of debugging section
3673: --

Line 3670: inv_pp_debug.send_last_error_message;

3666: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
3667: -- the message retrieved here since it is no longer on the stack
3668: inv_pp_debug.set_last_error_message(Sqlerrm);
3669: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
3670: inv_pp_debug.send_last_error_message;
3671: END IF;
3672: -- end of debugging section
3673: --
3674: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 3680: IF inv_pp_debug.is_debug_mode THEN

3676: WHEN OTHERS THEN
3677: --
3678: -- debugging section
3679: -- can be commented ut for final code
3680: IF inv_pp_debug.is_debug_mode THEN
3681: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
3682: -- the message retrieved here since it is no longer on the stack
3683: inv_pp_debug.set_last_error_message(Sqlerrm);
3684: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);

Line 3683: inv_pp_debug.set_last_error_message(Sqlerrm);

3679: -- can be commented ut for final code
3680: IF inv_pp_debug.is_debug_mode THEN
3681: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
3682: -- the message retrieved here since it is no longer on the stack
3683: inv_pp_debug.set_last_error_message(Sqlerrm);
3684: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
3685: inv_pp_debug.send_last_error_message;
3686: END IF;
3687: -- end of debugging section

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

3680: IF inv_pp_debug.is_debug_mode THEN
3681: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
3682: -- the message retrieved here since it is no longer on the stack
3683: inv_pp_debug.set_last_error_message(Sqlerrm);
3684: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
3685: inv_pp_debug.send_last_error_message;
3686: END IF;
3687: -- end of debugging section
3688: --

Line 3685: inv_pp_debug.send_last_error_message;

3681: -- Note: in debug mode, later call to fnd_msg_pub.get will not get
3682: -- the message retrieved here since it is no longer on the stack
3683: inv_pp_debug.set_last_error_message(Sqlerrm);
3684: inv_pp_debug.send_message_to_pipe('exception in '||l_api_name);
3685: inv_pp_debug.send_last_error_message;
3686: END IF;
3687: -- end of debugging section
3688: --
3689: x_return_status := fnd_api.g_ret_sts_unexp_error;