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.OE_PREPAYMENT_UTIL dependencies on FND_FILE

Line 563: fnd_file.put_line(FND_FILE.OUTPUT, 'Pack H or above must be installed to use this concurrent program');

559: IF OE_CODE_CONTROL.Get_Code_Release_Level < '110508' THEN
560: IF l_debug_level > 0 THEN
561: oe_debug_pub.add( 'OEXUPPY: BELOW PACKH , PREPAYMENTS NOT ENABLED' ) ;
562: END IF;
563: fnd_file.put_line(FND_FILE.OUTPUT, 'Pack H or above must be installed to use this concurrent program');
564: RETURN;
565: END IF;
566: l_return_status := FND_API.G_RET_STS_SUCCESS;
567:

Line 586: fnd_file.put_line(FND_FILE.OUTPUT, 'Pending Process Payments Concurrent Program');

582:
583: /* -----------------------------------------------------------
584: Log Output file
585: -----------------------------------------------------------*/
586: fnd_file.put_line(FND_FILE.OUTPUT, 'Pending Process Payments Concurrent Program');
587: fnd_file.put_line(FND_FILE.OUTPUT, '');
588: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
589: fnd_file.put_line(FND_FILE.OUTPUT, 'Operating Unit: '|| p_operating_unit); --MOAC Changes
590: fnd_file.put_line(FND_FILE.OUTPUT, 'PPP Hold Selected: '|| p_ppp_hold);

Line 587: fnd_file.put_line(FND_FILE.OUTPUT, '');

583: /* -----------------------------------------------------------
584: Log Output file
585: -----------------------------------------------------------*/
586: fnd_file.put_line(FND_FILE.OUTPUT, 'Pending Process Payments Concurrent Program');
587: fnd_file.put_line(FND_FILE.OUTPUT, '');
588: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
589: fnd_file.put_line(FND_FILE.OUTPUT, 'Operating Unit: '|| p_operating_unit); --MOAC Changes
590: fnd_file.put_line(FND_FILE.OUTPUT, 'PPP Hold Selected: '|| p_ppp_hold);
591: fnd_file.put_line(FND_FILE.OUTPUT, 'Epayment Failure Hold Selected: '|| p_epay_failure_hold);

Line 588: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');

584: Log Output file
585: -----------------------------------------------------------*/
586: fnd_file.put_line(FND_FILE.OUTPUT, 'Pending Process Payments Concurrent Program');
587: fnd_file.put_line(FND_FILE.OUTPUT, '');
588: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
589: fnd_file.put_line(FND_FILE.OUTPUT, 'Operating Unit: '|| p_operating_unit); --MOAC Changes
590: fnd_file.put_line(FND_FILE.OUTPUT, 'PPP Hold Selected: '|| p_ppp_hold);
591: fnd_file.put_line(FND_FILE.OUTPUT, 'Epayment Failure Hold Selected: '|| p_epay_failure_hold);
592: fnd_file.put_line(FND_FILE.OUTPUT, 'Epayment Server Failure Hold Selected: '|| p_epay_server_failure_hold);

Line 589: fnd_file.put_line(FND_FILE.OUTPUT, 'Operating Unit: '|| p_operating_unit); --MOAC Changes

585: -----------------------------------------------------------*/
586: fnd_file.put_line(FND_FILE.OUTPUT, 'Pending Process Payments Concurrent Program');
587: fnd_file.put_line(FND_FILE.OUTPUT, '');
588: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
589: fnd_file.put_line(FND_FILE.OUTPUT, 'Operating Unit: '|| p_operating_unit); --MOAC Changes
590: fnd_file.put_line(FND_FILE.OUTPUT, 'PPP Hold Selected: '|| p_ppp_hold);
591: fnd_file.put_line(FND_FILE.OUTPUT, 'Epayment Failure Hold Selected: '|| p_epay_failure_hold);
592: fnd_file.put_line(FND_FILE.OUTPUT, 'Epayment Server Failure Hold Selected: '|| p_epay_server_failure_hold);
593: fnd_file.put_line(FND_FILE.OUTPUT, 'Payment Authorizatin Hold Selected: '|| p_payment_authorization_hold);

Line 590: fnd_file.put_line(FND_FILE.OUTPUT, 'PPP Hold Selected: '|| p_ppp_hold);

586: fnd_file.put_line(FND_FILE.OUTPUT, 'Pending Process Payments Concurrent Program');
587: fnd_file.put_line(FND_FILE.OUTPUT, '');
588: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
589: fnd_file.put_line(FND_FILE.OUTPUT, 'Operating Unit: '|| p_operating_unit); --MOAC Changes
590: fnd_file.put_line(FND_FILE.OUTPUT, 'PPP Hold Selected: '|| p_ppp_hold);
591: fnd_file.put_line(FND_FILE.OUTPUT, 'Epayment Failure Hold Selected: '|| p_epay_failure_hold);
592: fnd_file.put_line(FND_FILE.OUTPUT, 'Epayment Server Failure Hold Selected: '|| p_epay_server_failure_hold);
593: fnd_file.put_line(FND_FILE.OUTPUT, 'Payment Authorizatin Hold Selected: '|| p_payment_authorization_hold);
594: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Type: '|| p_order_type_id);

Line 591: fnd_file.put_line(FND_FILE.OUTPUT, 'Epayment Failure Hold Selected: '|| p_epay_failure_hold);

587: fnd_file.put_line(FND_FILE.OUTPUT, '');
588: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
589: fnd_file.put_line(FND_FILE.OUTPUT, 'Operating Unit: '|| p_operating_unit); --MOAC Changes
590: fnd_file.put_line(FND_FILE.OUTPUT, 'PPP Hold Selected: '|| p_ppp_hold);
591: fnd_file.put_line(FND_FILE.OUTPUT, 'Epayment Failure Hold Selected: '|| p_epay_failure_hold);
592: fnd_file.put_line(FND_FILE.OUTPUT, 'Epayment Server Failure Hold Selected: '|| p_epay_server_failure_hold);
593: fnd_file.put_line(FND_FILE.OUTPUT, 'Payment Authorizatin Hold Selected: '|| p_payment_authorization_hold);
594: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Type: '|| p_order_type_id);
595: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Number From: '|| p_order_number_from);

Line 592: fnd_file.put_line(FND_FILE.OUTPUT, 'Epayment Server Failure Hold Selected: '|| p_epay_server_failure_hold);

588: fnd_file.put_line(FND_FILE.OUTPUT, 'Concurrent Program Parameters');
589: fnd_file.put_line(FND_FILE.OUTPUT, 'Operating Unit: '|| p_operating_unit); --MOAC Changes
590: fnd_file.put_line(FND_FILE.OUTPUT, 'PPP Hold Selected: '|| p_ppp_hold);
591: fnd_file.put_line(FND_FILE.OUTPUT, 'Epayment Failure Hold Selected: '|| p_epay_failure_hold);
592: fnd_file.put_line(FND_FILE.OUTPUT, 'Epayment Server Failure Hold Selected: '|| p_epay_server_failure_hold);
593: fnd_file.put_line(FND_FILE.OUTPUT, 'Payment Authorizatin Hold Selected: '|| p_payment_authorization_hold);
594: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Type: '|| p_order_type_id);
595: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Number From: '|| p_order_number_from);
596: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Number To: '|| p_order_number_to);

Line 593: fnd_file.put_line(FND_FILE.OUTPUT, 'Payment Authorizatin Hold Selected: '|| p_payment_authorization_hold);

589: fnd_file.put_line(FND_FILE.OUTPUT, 'Operating Unit: '|| p_operating_unit); --MOAC Changes
590: fnd_file.put_line(FND_FILE.OUTPUT, 'PPP Hold Selected: '|| p_ppp_hold);
591: fnd_file.put_line(FND_FILE.OUTPUT, 'Epayment Failure Hold Selected: '|| p_epay_failure_hold);
592: fnd_file.put_line(FND_FILE.OUTPUT, 'Epayment Server Failure Hold Selected: '|| p_epay_server_failure_hold);
593: fnd_file.put_line(FND_FILE.OUTPUT, 'Payment Authorizatin Hold Selected: '|| p_payment_authorization_hold);
594: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Type: '|| p_order_type_id);
595: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Number From: '|| p_order_number_from);
596: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Number To: '|| p_order_number_to);
597: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer Number From: '|| p_customer_number_from);

Line 594: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Type: '|| p_order_type_id);

590: fnd_file.put_line(FND_FILE.OUTPUT, 'PPP Hold Selected: '|| p_ppp_hold);
591: fnd_file.put_line(FND_FILE.OUTPUT, 'Epayment Failure Hold Selected: '|| p_epay_failure_hold);
592: fnd_file.put_line(FND_FILE.OUTPUT, 'Epayment Server Failure Hold Selected: '|| p_epay_server_failure_hold);
593: fnd_file.put_line(FND_FILE.OUTPUT, 'Payment Authorizatin Hold Selected: '|| p_payment_authorization_hold);
594: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Type: '|| p_order_type_id);
595: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Number From: '|| p_order_number_from);
596: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Number To: '|| p_order_number_to);
597: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer Number From: '|| p_customer_number_from);
598: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer Number To: '|| p_customer_number_to);

Line 595: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Number From: '|| p_order_number_from);

591: fnd_file.put_line(FND_FILE.OUTPUT, 'Epayment Failure Hold Selected: '|| p_epay_failure_hold);
592: fnd_file.put_line(FND_FILE.OUTPUT, 'Epayment Server Failure Hold Selected: '|| p_epay_server_failure_hold);
593: fnd_file.put_line(FND_FILE.OUTPUT, 'Payment Authorizatin Hold Selected: '|| p_payment_authorization_hold);
594: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Type: '|| p_order_type_id);
595: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Number From: '|| p_order_number_from);
596: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Number To: '|| p_order_number_to);
597: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer Number From: '|| p_customer_number_from);
598: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer Number To: '|| p_customer_number_to);
599: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer Class: '|| p_customer_class_code);

Line 596: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Number To: '|| p_order_number_to);

592: fnd_file.put_line(FND_FILE.OUTPUT, 'Epayment Server Failure Hold Selected: '|| p_epay_server_failure_hold);
593: fnd_file.put_line(FND_FILE.OUTPUT, 'Payment Authorizatin Hold Selected: '|| p_payment_authorization_hold);
594: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Type: '|| p_order_type_id);
595: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Number From: '|| p_order_number_from);
596: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Number To: '|| p_order_number_to);
597: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer Number From: '|| p_customer_number_from);
598: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer Number To: '|| p_customer_number_to);
599: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer Class: '|| p_customer_class_code);
600: fnd_file.put_line(FND_FILE.OUTPUT, 'Credit Card Number: '|| p_credit_card_number);

Line 597: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer Number From: '|| p_customer_number_from);

593: fnd_file.put_line(FND_FILE.OUTPUT, 'Payment Authorizatin Hold Selected: '|| p_payment_authorization_hold);
594: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Type: '|| p_order_type_id);
595: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Number From: '|| p_order_number_from);
596: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Number To: '|| p_order_number_to);
597: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer Number From: '|| p_customer_number_from);
598: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer Number To: '|| p_customer_number_to);
599: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer Class: '|| p_customer_class_code);
600: fnd_file.put_line(FND_FILE.OUTPUT, 'Credit Card Number: '|| p_credit_card_number);
601: fnd_file.put_line(FND_FILE.OUTPUT, 'Card Brand: '|| p_credit_card_type);

Line 598: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer Number To: '|| p_customer_number_to);

594: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Type: '|| p_order_type_id);
595: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Number From: '|| p_order_number_from);
596: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Number To: '|| p_order_number_to);
597: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer Number From: '|| p_customer_number_from);
598: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer Number To: '|| p_customer_number_to);
599: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer Class: '|| p_customer_class_code);
600: fnd_file.put_line(FND_FILE.OUTPUT, 'Credit Card Number: '|| p_credit_card_number);
601: fnd_file.put_line(FND_FILE.OUTPUT, 'Card Brand: '|| p_credit_card_type);
602: fnd_file.put_line(FND_FILE.OUTPUT, 'Bill To Org: '|| p_bill_to_org_id);

Line 599: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer Class: '|| p_customer_class_code);

595: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Number From: '|| p_order_number_from);
596: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Number To: '|| p_order_number_to);
597: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer Number From: '|| p_customer_number_from);
598: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer Number To: '|| p_customer_number_to);
599: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer Class: '|| p_customer_class_code);
600: fnd_file.put_line(FND_FILE.OUTPUT, 'Credit Card Number: '|| p_credit_card_number);
601: fnd_file.put_line(FND_FILE.OUTPUT, 'Card Brand: '|| p_credit_card_type);
602: fnd_file.put_line(FND_FILE.OUTPUT, 'Bill To Org: '|| p_bill_to_org_id);
603: fnd_file.put_line(FND_FILE.OUTPUT, 'Booked Date Since: '|| p_booked_date_since);

Line 600: fnd_file.put_line(FND_FILE.OUTPUT, 'Credit Card Number: '|| p_credit_card_number);

596: fnd_file.put_line(FND_FILE.OUTPUT, 'Order Number To: '|| p_order_number_to);
597: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer Number From: '|| p_customer_number_from);
598: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer Number To: '|| p_customer_number_to);
599: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer Class: '|| p_customer_class_code);
600: fnd_file.put_line(FND_FILE.OUTPUT, 'Credit Card Number: '|| p_credit_card_number);
601: fnd_file.put_line(FND_FILE.OUTPUT, 'Card Brand: '|| p_credit_card_type);
602: fnd_file.put_line(FND_FILE.OUTPUT, 'Bill To Org: '|| p_bill_to_org_id);
603: fnd_file.put_line(FND_FILE.OUTPUT, 'Booked Date Since: '|| p_booked_date_since);
604: fnd_file.put_line(FND_FILE.OUTPUT, '');

Line 601: fnd_file.put_line(FND_FILE.OUTPUT, 'Card Brand: '|| p_credit_card_type);

597: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer Number From: '|| p_customer_number_from);
598: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer Number To: '|| p_customer_number_to);
599: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer Class: '|| p_customer_class_code);
600: fnd_file.put_line(FND_FILE.OUTPUT, 'Credit Card Number: '|| p_credit_card_number);
601: fnd_file.put_line(FND_FILE.OUTPUT, 'Card Brand: '|| p_credit_card_type);
602: fnd_file.put_line(FND_FILE.OUTPUT, 'Bill To Org: '|| p_bill_to_org_id);
603: fnd_file.put_line(FND_FILE.OUTPUT, 'Booked Date Since: '|| p_booked_date_since);
604: fnd_file.put_line(FND_FILE.OUTPUT, '');
605:

Line 602: fnd_file.put_line(FND_FILE.OUTPUT, 'Bill To Org: '|| p_bill_to_org_id);

598: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer Number To: '|| p_customer_number_to);
599: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer Class: '|| p_customer_class_code);
600: fnd_file.put_line(FND_FILE.OUTPUT, 'Credit Card Number: '|| p_credit_card_number);
601: fnd_file.put_line(FND_FILE.OUTPUT, 'Card Brand: '|| p_credit_card_type);
602: fnd_file.put_line(FND_FILE.OUTPUT, 'Bill To Org: '|| p_bill_to_org_id);
603: fnd_file.put_line(FND_FILE.OUTPUT, 'Booked Date Since: '|| p_booked_date_since);
604: fnd_file.put_line(FND_FILE.OUTPUT, '');
605:
606: -----------------------------------------------------------

Line 603: fnd_file.put_line(FND_FILE.OUTPUT, 'Booked Date Since: '|| p_booked_date_since);

599: fnd_file.put_line(FND_FILE.OUTPUT, 'Customer Class: '|| p_customer_class_code);
600: fnd_file.put_line(FND_FILE.OUTPUT, 'Credit Card Number: '|| p_credit_card_number);
601: fnd_file.put_line(FND_FILE.OUTPUT, 'Card Brand: '|| p_credit_card_type);
602: fnd_file.put_line(FND_FILE.OUTPUT, 'Bill To Org: '|| p_bill_to_org_id);
603: fnd_file.put_line(FND_FILE.OUTPUT, 'Booked Date Since: '|| p_booked_date_since);
604: fnd_file.put_line(FND_FILE.OUTPUT, '');
605:
606: -----------------------------------------------------------
607: -- Setting Debug Mode and File

Line 604: fnd_file.put_line(FND_FILE.OUTPUT, '');

600: fnd_file.put_line(FND_FILE.OUTPUT, 'Credit Card Number: '|| p_credit_card_number);
601: fnd_file.put_line(FND_FILE.OUTPUT, 'Card Brand: '|| p_credit_card_type);
602: fnd_file.put_line(FND_FILE.OUTPUT, 'Bill To Org: '|| p_bill_to_org_id);
603: fnd_file.put_line(FND_FILE.OUTPUT, 'Booked Date Since: '|| p_booked_date_since);
604: fnd_file.put_line(FND_FILE.OUTPUT, '');
605:
606: -----------------------------------------------------------
607: -- Setting Debug Mode and File
608: -----------------------------------------------------------

Line 610: FND_FILE.Put_Line(FND_FILE.OUTPUT,'Debug Level: '||nvl(p_debug_level,1));

606: -----------------------------------------------------------
607: -- Setting Debug Mode and File
608: -----------------------------------------------------------
609:
610: FND_FILE.Put_Line(FND_FILE.OUTPUT,'Debug Level: '||nvl(p_debug_level,1));
611: -- commenting out as debug mode will be set to 'CONC' automatically when
612: -- debug level is > 0 and the debug messages can be seen in the conc program log file
613: /*
614: IF nvl(p_debug_level, 1) > 0 THEN

Line 616: FND_FILE.Put_Line(FND_FILE.OUTPUT,'Debug File: ' || l_filename);

612: -- debug level is > 0 and the debug messages can be seen in the conc program log file
613: /*
614: IF nvl(p_debug_level, 1) > 0 THEN
615: l_filename := OE_DEBUG_PUB.set_debug_mode ('FILE');
616: FND_FILE.Put_Line(FND_FILE.OUTPUT,'Debug File: ' || l_filename);
617: FND_FILE.Put_Line(FND_FILE.OUTPUT, '');
618: END IF;
619:
620: l_filename := OE_DEBUG_PUB.set_debug_mode ('CONC');

Line 617: FND_FILE.Put_Line(FND_FILE.OUTPUT, '');

613: /*
614: IF nvl(p_debug_level, 1) > 0 THEN
615: l_filename := OE_DEBUG_PUB.set_debug_mode ('FILE');
616: FND_FILE.Put_Line(FND_FILE.OUTPUT,'Debug File: ' || l_filename);
617: FND_FILE.Put_Line(FND_FILE.OUTPUT, '');
618: END IF;
619:
620: l_filename := OE_DEBUG_PUB.set_debug_mode ('CONC');
621: */

Line 635: fnd_file.put_line(FND_FILE.OUTPUT, 'Request Id: '|| to_char(l_request_id));

631:
632: IF l_debug_level > 0 THEN
633: oe_debug_pub.add( 'REQUEST ID: '|| TO_CHAR ( L_REQUEST_ID ) ) ;
634: END IF;
635: fnd_file.put_line(FND_FILE.OUTPUT, 'Request Id: '|| to_char(l_request_id));
636: -- fnd_file.put_line(FND_FILE.OUTPUT, 'l_hold1:l_hold2:l_hold3 : '|| l_hold1||':'||l_hold2||':'||l_hold3);
637:
638: l_count_header := 0;
639: l_count_header_success := 0;

Line 636: -- fnd_file.put_line(FND_FILE.OUTPUT, 'l_hold1:l_hold2:l_hold3 : '|| l_hold1||':'||l_hold2||':'||l_hold3);

632: IF l_debug_level > 0 THEN
633: oe_debug_pub.add( 'REQUEST ID: '|| TO_CHAR ( L_REQUEST_ID ) ) ;
634: END IF;
635: fnd_file.put_line(FND_FILE.OUTPUT, 'Request Id: '|| to_char(l_request_id));
636: -- fnd_file.put_line(FND_FILE.OUTPUT, 'l_hold1:l_hold2:l_hold3 : '|| l_hold1||':'||l_hold2||':'||l_hold3);
637:
638: l_count_header := 0;
639: l_count_header_success := 0;
640: l_count_header_failure := 0;

Line 668: fnd_file.put_line(FND_FILE.OUTPUT, 'Processing header_id: '||l_header_id);

664: END IF;
665: END IF;
666: --bug4689411 end
667:
668: fnd_file.put_line(FND_FILE.OUTPUT, 'Processing header_id: '||l_header_id);
669: l_count_header := l_count_header + 1;
670: IF l_count_header = 1 THEN
671: -- Set Message Context
672: OE_MSG_PUB.set_msg_context(

Line 863: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders found: ' ||l_count_header);

859: IF l_debug_level > 0 THEN
860: oe_debug_pub.add( 'NO. OF ORDERS FAILED: ' || L_COUNT_HEADER_FAILURE ) ;
861: END IF;
862:
863: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders found: ' ||l_count_header);
864: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders processed successfully: '||l_count_header_success);
865: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders failed: ' ||l_count_header_failure);
866: fnd_file.put_line(FND_FILE.OUTPUT,'');
867:

Line 864: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders processed successfully: '||l_count_header_success);

860: oe_debug_pub.add( 'NO. OF ORDERS FAILED: ' || L_COUNT_HEADER_FAILURE ) ;
861: END IF;
862:
863: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders found: ' ||l_count_header);
864: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders processed successfully: '||l_count_header_success);
865: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders failed: ' ||l_count_header_failure);
866: fnd_file.put_line(FND_FILE.OUTPUT,'');
867:
868: /* -----------------------------------------------------------

Line 865: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders failed: ' ||l_count_header_failure);

861: END IF;
862:
863: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders found: ' ||l_count_header);
864: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders processed successfully: '||l_count_header_success);
865: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders failed: ' ||l_count_header_failure);
866: fnd_file.put_line(FND_FILE.OUTPUT,'');
867:
868: /* -----------------------------------------------------------
869: Messages

Line 866: fnd_file.put_line(FND_FILE.OUTPUT,'');

862:
863: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders found: ' ||l_count_header);
864: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders processed successfully: '||l_count_header_success);
865: fnd_file.put_line(FND_FILE.OUTPUT,'No. of orders failed: ' ||l_count_header_failure);
866: fnd_file.put_line(FND_FILE.OUTPUT,'');
867:
868: /* -----------------------------------------------------------
869: Messages
870: -----------------------------------------------------------

Line 876: fnd_file.put_line(FND_FILE.OUTPUT,'');

872: IF l_debug_level > 0 THEN
873: oe_debug_pub.add( 'BEFORE MESSAGES LOOP' ) ;
874: END IF;
875:
876: fnd_file.put_line(FND_FILE.OUTPUT,'');
877: fnd_file.put_line(FND_FILE.OUTPUT,'Source/Order/Seq/Line Message');
878: OPEN l_msg_cursor;
879: LOOP
880: FETCH l_msg_cursor

Line 877: fnd_file.put_line(FND_FILE.OUTPUT,'Source/Order/Seq/Line Message');

873: oe_debug_pub.add( 'BEFORE MESSAGES LOOP' ) ;
874: END IF;
875:
876: fnd_file.put_line(FND_FILE.OUTPUT,'');
877: fnd_file.put_line(FND_FILE.OUTPUT,'Source/Order/Seq/Line Message');
878: OPEN l_msg_cursor;
879: LOOP
880: FETCH l_msg_cursor
881: INTO l_header_id

Line 890: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_header_id)

886: , l_source_document_type_id
887: , l_message_text;
888: EXIT WHEN l_msg_cursor%NOTFOUND;
889:
890: fnd_file.put_line(FND_FILE.OUTPUT,to_char(l_header_id)
891: ||'/'||to_char(l_order_source_id)
892: ||'/'||l_orig_sys_document_ref
893: ||'/'||l_source_document_id
894: ||'/'||l_change_sequence

Line 897: fnd_file.put_line(FND_FILE.OUTPUT,'');

893: ||'/'||l_source_document_id
894: ||'/'||l_change_sequence
895: ||'/'||l_source_document_type_id
896: ||' '||l_message_text);
897: fnd_file.put_line(FND_FILE.OUTPUT,'');
898: END LOOP;
899:
900: retcode := 0;
901: IF l_debug_level > 0 THEN

Line 916: fnd_file.put_line(FND_FILE.OUTPUT,'Unexpected error: ' || sqlerrm);

912: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
913: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'PendProcessPayments_Conc_Prog');
914: END IF;
915:
916: fnd_file.put_line(FND_FILE.OUTPUT,'Unexpected error: ' || sqlerrm);
917: OE_MSG_PUB.Count_And_Get
918: ( p_count => l_msg_count,
919: p_data => l_msg_data
920: );

Line 937: fnd_file.put_line(FND_FILE.OUTPUT,'Unexpected error: ' || sqlerrm);

933: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
934: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'PendProcessPayments_Conc_Prog');
935: END IF;
936:
937: fnd_file.put_line(FND_FILE.OUTPUT,'Unexpected error: ' || sqlerrm);
938:
939: END PendProcessPayments_Conc_Prog;
940:
941: /*-------------------------------------------------------------------