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

Line 71: fnd_file.put_line( fnd_file.output, arp_standard.fnd_message('AR_BPA_PRINT_CHILD_REQ',

67: dphase,
68: dstatus,
69: message);
70:
71: fnd_file.put_line( fnd_file.output, arp_standard.fnd_message('AR_BPA_PRINT_CHILD_REQ',
72: 'REQ_ID',
73: p_request_id,
74: 'PHASE',
75: dphase,

Line 80: fnd_file.put_line( fnd_file.log, 'child request id: ' || p_request_id || ' complete successfully');

76: 'STATUS',
77: dstatus));
78:
79: IF ((dphase = 'COMPLETE') and (dstatus = 'NORMAL')) THEN
80: fnd_file.put_line( fnd_file.log, 'child request id: ' || p_request_id || ' complete successfully');
81: ELSE
82: fnd_file.put_line( fnd_file.log, 'child request id: ' || p_request_id || ' did not complete successfully');
83: END IF;
84:

Line 82: fnd_file.put_line( fnd_file.log, 'child request id: ' || p_request_id || ' did not complete successfully');

78:
79: IF ((dphase = 'COMPLETE') and (dstatus = 'NORMAL')) THEN
80: fnd_file.put_line( fnd_file.log, 'child request id: ' || p_request_id || ' complete successfully');
81: ELSE
82: fnd_file.put_line( fnd_file.log, 'child request id: ' || p_request_id || ' did not complete successfully');
83: END IF;
84:
85: END;
86:

Line 616: fnd_file.put_line( fnd_file.log, 'userenv_lang: ' || userenv_lang);

612: from fnd_languages
613: where installed_flag = 'B';
614:
615: MO_global.init('AR');
616: fnd_file.put_line( fnd_file.log, 'userenv_lang: ' || userenv_lang);
617: fnd_file.put_line( fnd_file.log, 'base_lang: ' || base_lang);
618:
619: /* Read in Parameter Values supplied by user */
620: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Operating Unit',parm_number);

Line 617: fnd_file.put_line( fnd_file.log, 'base_lang: ' || base_lang);

613: where installed_flag = 'B';
614:
615: MO_global.init('AR');
616: fnd_file.put_line( fnd_file.log, 'userenv_lang: ' || userenv_lang);
617: fnd_file.put_line( fnd_file.log, 'base_lang: ' || base_lang);
618:
619: /* Read in Parameter Values supplied by user */
620: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Operating Unit',parm_number);
621: IF retval = -1 THEN

Line 626: fnd_file.put_line( fnd_file.log, 'p_org_id: ' || p_org_id);

622: p_org_id := NULL;
623: ELSE
624: p_org_id:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
625: END IF;
626: fnd_file.put_line( fnd_file.log, 'p_org_id: ' || p_org_id);
627:
628: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Job Size',parm_number);
629: IF retval = -1 THEN
630: p_job_size:= NULL;

Line 634: fnd_file.put_line( fnd_file.log, 'p_job_size: ' || p_job_size);

630: p_job_size:= NULL;
631: ELSE
632: p_job_size:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
633: END IF;
634: fnd_file.put_line( fnd_file.log, 'p_job_size: ' || p_job_size);
635:
636: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Transactions to Print',parm_number);
637: IF retval = -1 THEN
638: p_choice:= NULL;

Line 642: fnd_file.put_line( fnd_file.log, 'p_choice: ' || p_choice);

638: p_choice:= NULL;
639: ELSE
640: p_choice:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
641: END IF;
642: fnd_file.put_line( fnd_file.log, 'p_choice: ' || p_choice);
643:
644: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Order By',parm_number);
645: IF retval = -1 THEN
646: p_order_by:= NULL;

Line 650: fnd_file.put_line( fnd_file.log, 'p_order_by: ' || p_order_by);

646: p_order_by:= NULL;
647: ELSE
648: p_order_by:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
649: END IF;
650: fnd_file.put_line( fnd_file.log, 'p_order_by: ' || p_order_by);
651:
652: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Batch',parm_number);
653: IF retval = -1 THEN
654: p_BATCH_ID := NULL;

Line 659: fnd_file.put_line( fnd_file.log, 'p_BATCH_ID: ' || p_BATCH_ID);

655: ELSE
656: p_BATCH_ID := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
657: filter_exists := true;
658: END IF;
659: fnd_file.put_line( fnd_file.log, 'p_BATCH_ID: ' || p_BATCH_ID);
660:
661: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Transaction Class',parm_number);
662: IF retval = -1 THEN
663: p_cust_trx_class := NULL;

Line 667: fnd_file.put_line( fnd_file.log, 'p_cust_trx_class: ' || p_cust_trx_class);

663: p_cust_trx_class := NULL;
664: ELSE
665: p_cust_trx_class := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
666: END IF;
667: fnd_file.put_line( fnd_file.log, 'p_cust_trx_class: ' || p_cust_trx_class);
668:
669: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Transaction Type',parm_number);
670: IF retval = -1 THEN
671: p_TRX_TYPE_ID := NULL;

Line 675: fnd_file.put_line( fnd_file.log, 'p_TRX_TYPE_ID: ' || p_TRX_TYPE_ID);

671: p_TRX_TYPE_ID := NULL;
672: ELSE
673: p_TRX_TYPE_ID := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
674: END IF;
675: fnd_file.put_line( fnd_file.log, 'p_TRX_TYPE_ID: ' || p_TRX_TYPE_ID);
676:
677: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Customer Class',parm_number);
678: IF retval = -1 THEN
679: p_customer_class_code:= NULL;

Line 683: fnd_file.put_line( fnd_file.log, 'p_customer_class_code: ' || p_customer_class_code);

679: p_customer_class_code:= NULL;
680: ELSE
681: p_customer_class_code:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
682: END IF;
683: fnd_file.put_line( fnd_file.log, 'p_customer_class_code: ' || p_customer_class_code);
684:
685: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(From) Bill To Customer Name',parm_number);
686: IF retval = -1 THEN
687: p_customer_name_low:= NULL;

Line 691: fnd_file.put_line( fnd_file.log, 'p_customer_name_low: ' || p_customer_name_low);

687: p_customer_name_low:= NULL;
688: ELSE
689: p_customer_name_low:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
690: END IF;
691: fnd_file.put_line( fnd_file.log, 'p_customer_name_low: ' || p_customer_name_low);
692:
693: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(To) Bill To Customer Name',parm_number);
694: IF retval = -1 THEN
695: p_CUSTOMER_NAME_HIGH := NULL;

Line 699: fnd_file.put_line( fnd_file.log, 'p_CUSTOMER_NAME_HIGH: ' || p_CUSTOMER_NAME_HIGH);

695: p_CUSTOMER_NAME_HIGH := NULL;
696: ELSE
697: p_CUSTOMER_NAME_HIGH := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
698: END IF;
699: fnd_file.put_line( fnd_file.log, 'p_CUSTOMER_NAME_HIGH: ' || p_CUSTOMER_NAME_HIGH);
700:
701: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(Low) Bill To Customer Number',parm_number);
702: IF retval = -1 THEN
703: p_customer_no_low:= NULL;

Line 707: fnd_file.put_line( fnd_file.log, 'p_customer_no_low: ' || p_customer_no_low);

703: p_customer_no_low:= NULL;
704: ELSE
705: p_customer_no_low:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
706: END IF;
707: fnd_file.put_line( fnd_file.log, 'p_customer_no_low: ' || p_customer_no_low);
708:
709: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(High) Bill To Customer Number',parm_number);
710: IF retval = -1 THEN
711: p_customer_no_high := NULL;

Line 715: fnd_file.put_line( fnd_file.log, 'p_customer_no_high: ' || p_customer_no_high);

711: p_customer_no_high := NULL;
712: ELSE
713: p_customer_no_high := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
714: END IF;
715: fnd_file.put_line( fnd_file.log, 'p_customer_no_high: ' || p_customer_no_high);
716:
717: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(Low) Transaction Number',parm_number);
718: IF retval = -1 THEN
719: p_TRX_NUMBER_LOW := NULL;

Line 723: fnd_file.put_line( fnd_file.log, 'p_TRX_NUMBER_LOW: ' || p_TRX_NUMBER_LOW);

719: p_TRX_NUMBER_LOW := NULL;
720: ELSE
721: p_TRX_NUMBER_LOW := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
722: END IF;
723: fnd_file.put_line( fnd_file.log, 'p_TRX_NUMBER_LOW: ' || p_TRX_NUMBER_LOW);
724:
725: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(High) Transaction Number',parm_number);
726: IF retval = -1 THEN
727: p_TRX_NUMBER_HIGH := NULL;

Line 731: fnd_file.put_line( fnd_file.log, 'p_TRX_NUMBER_HIGH: ' || p_TRX_NUMBER_HIGH);

727: p_TRX_NUMBER_HIGH := NULL;
728: ELSE
729: p_TRX_NUMBER_HIGH := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
730: END IF;
731: fnd_file.put_line( fnd_file.log, 'p_TRX_NUMBER_HIGH: ' || p_TRX_NUMBER_HIGH);
732:
733: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Installment Number',parm_number);
734: IF retval = -1 THEN
735: p_INSTALLMENT_NO := NULL;

Line 739: fnd_file.put_line( fnd_file.log, 'p_INSTALLMENT_NO: ' || p_INSTALLMENT_NO);

735: p_INSTALLMENT_NO := NULL;
736: ELSE
737: p_INSTALLMENT_NO := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
738: END IF;
739: fnd_file.put_line( fnd_file.log, 'p_INSTALLMENT_NO: ' || p_INSTALLMENT_NO);
740:
741: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(Low) Print Date',parm_number);
742: IF retval = -1 THEN
743: p_PRINT_DATE_LOW := NULL;

Line 747: fnd_file.put_line( fnd_file.log, 'p_PRINT_DATE_LOW: ' || p_PRINT_DATE_LOW);

743: p_PRINT_DATE_LOW := NULL;
744: ELSE
745: p_PRINT_DATE_LOW := fnd_date.canonical_to_date(FND_REQUEST_INFO.GET_PARAMETER(parm_number));
746: END IF;
747: fnd_file.put_line( fnd_file.log, 'p_PRINT_DATE_LOW: ' || p_PRINT_DATE_LOW);
748:
749: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(High) Print Date',parm_number);
750: IF retval = -1 THEN
751: p_PRINT_DATE_HIGH := NULL;

Line 755: fnd_file.put_line( fnd_file.log, 'p_PRINT_DATE_HIGH: ' || p_PRINT_DATE_HIGH);

751: p_PRINT_DATE_HIGH := NULL;
752: ELSE
753: p_PRINT_DATE_HIGH := fnd_date.canonical_to_date(FND_REQUEST_INFO.GET_PARAMETER(parm_number));
754: END IF;
755: fnd_file.put_line( fnd_file.log, 'p_PRINT_DATE_HIGH: ' || p_PRINT_DATE_HIGH);
756:
757: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Open Invoices Only',parm_number);
758: IF retval = -1 THEN
759: p_OPEN_INVOICE_FLAG := NULL;

Line 763: fnd_file.put_line( fnd_file.log, 'p_OPEN_INVOICE_FLAG: ' || p_OPEN_INVOICE_FLAG);

759: p_OPEN_INVOICE_FLAG := NULL;
760: ELSE
761: p_OPEN_INVOICE_FLAG := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
762: END IF;
763: fnd_file.put_line( fnd_file.log, 'p_OPEN_INVOICE_FLAG: ' || p_OPEN_INVOICE_FLAG);
764:
765: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Invoice Trx Id List',parm_number);
766: IF retval = -1 THEN
767: p_INVOICE_LIST_STRING := NULL;

Line 771: fnd_file.put_line( fnd_file.log, 'p_INVOICE_LIST_STRING: ' || p_INVOICE_LIST_STRING);

767: p_INVOICE_LIST_STRING := NULL;
768: ELSE
769: p_INVOICE_LIST_STRING := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
770: END IF;
771: fnd_file.put_line( fnd_file.log, 'p_INVOICE_LIST_STRING: ' || p_INVOICE_LIST_STRING);
772:
773:
774: select_stmt :=
775: ' select distinct(nvl(rtrim(substr(a_bill.language,1,4)), ''' || base_lang || ''')) language ' || cr ||

Line 825: --fnd_file.put_line( fnd_file.log, 'The final sql: ' || sql_stmt);

821: p_where2 ) ;
822: sql_stmt := sql_stmt || cr || ' UNION ' || cr || select_stmt || cr || p_where2 ;
823: END IF;
824:
825: --fnd_file.put_line( fnd_file.log, 'The final sql: ' || sql_stmt);
826: ------------------------------------------------
827: -- Parse sql stmts
828: ------------------------------------------------
829:

Line 903: fnd_file.put_line( fnd_file.log, 'No transactions matched the input parameters.' );

899: END IF;
900: END LOOP;
901:
902: IF lang_str IS NULL THEN
903: fnd_file.put_line( fnd_file.log, 'No transactions matched the input parameters.' );
904: ELSE
905: fnd_file.put_line( fnd_file.log, 'lang_str: ' || lang_str);
906: END IF;
907:

Line 905: fnd_file.put_line( fnd_file.log, 'lang_str: ' || lang_str);

901:
902: IF lang_str IS NULL THEN
903: fnd_file.put_line( fnd_file.log, 'No transactions matched the input parameters.' );
904: ELSE
905: fnd_file.put_line( fnd_file.log, 'lang_str: ' || lang_str);
906: END IF;
907:
908: RETURN lang_str;
909:

Line 912: fnd_file.put_line( fnd_file.log, sql_stmt);

908: RETURN lang_str;
909:
910: EXCEPTION
911: WHEN OTHERS THEN
912: fnd_file.put_line( fnd_file.log, sql_stmt);
913: RAISE;
914:
915: END PRINT_MLS_FUNCTION ;
916:

Line 986: FND_FILE.PUT_LINE( FND_FILE.LOG, 'AR_BPA_PRINT_CONC.print_invoices(+)' );

982:
983: BEGIN
984:
985: MO_global.init('AR');
986: FND_FILE.PUT_LINE( FND_FILE.LOG, 'AR_BPA_PRINT_CONC.print_invoices(+)' );
987: -- to check if the output directory exists
988:
989: -- read the variable request_data to check if it is reentering the program
990: req_data := fnd_conc_global.request_data;

Line 993: FND_FILE.PUT_LINE( FND_FILE.LOG, 'print_invoices: ' || 'req_data: '|| req_data );

989: -- read the variable request_data to check if it is reentering the program
990: req_data := fnd_conc_global.request_data;
991: m_request_id := fnd_global.conc_request_id;
992:
993: FND_FILE.PUT_LINE( FND_FILE.LOG, 'print_invoices: ' || 'req_data: '|| req_data );
994: FND_FILE.PUT_LINE( FND_FILE.LOG, 'print_invoices: ' || 'm_request_id: '|| m_request_id );
995: IF (req_data is null) THEN
996: FND_FILE.PUT_LINE( FND_FILE.LOG, 'print_invoices: '
997: || 'Entering print master program at the first time');

Line 994: FND_FILE.PUT_LINE( FND_FILE.LOG, 'print_invoices: ' || 'm_request_id: '|| m_request_id );

990: req_data := fnd_conc_global.request_data;
991: m_request_id := fnd_global.conc_request_id;
992:
993: FND_FILE.PUT_LINE( FND_FILE.LOG, 'print_invoices: ' || 'req_data: '|| req_data );
994: FND_FILE.PUT_LINE( FND_FILE.LOG, 'print_invoices: ' || 'm_request_id: '|| m_request_id );
995: IF (req_data is null) THEN
996: FND_FILE.PUT_LINE( FND_FILE.LOG, 'print_invoices: '
997: || 'Entering print master program at the first time');
998: -- read the user env language

Line 996: FND_FILE.PUT_LINE( FND_FILE.LOG, 'print_invoices: '

992:
993: FND_FILE.PUT_LINE( FND_FILE.LOG, 'print_invoices: ' || 'req_data: '|| req_data );
994: FND_FILE.PUT_LINE( FND_FILE.LOG, 'print_invoices: ' || 'm_request_id: '|| m_request_id );
995: IF (req_data is null) THEN
996: FND_FILE.PUT_LINE( FND_FILE.LOG, 'print_invoices: '
997: || 'Entering print master program at the first time');
998: -- read the user env language
999: select substr(userenv('LANG'),1,4)
1000: into userenv_lang

Line 1008: FND_FILE.PUT_LINE( FND_FILE.LOG, 'userenv_lang: '|| userenv_lang );

1004: into base_lang
1005: from fnd_languages
1006: where installed_flag = 'B';
1007:
1008: FND_FILE.PUT_LINE( FND_FILE.LOG, 'userenv_lang: '|| userenv_lang );
1009: fnd_file.put_line( fnd_file.log, 'base_lang: ' || base_lang);
1010:
1011: if p_job_size > 0 then l_job_size := p_job_size; end if;
1012: p_print_date_high := fnd_date.canonical_to_date(p_print_date_high_in);

Line 1009: fnd_file.put_line( fnd_file.log, 'base_lang: ' || base_lang);

1005: from fnd_languages
1006: where installed_flag = 'B';
1007:
1008: FND_FILE.PUT_LINE( FND_FILE.LOG, 'userenv_lang: '|| userenv_lang );
1009: fnd_file.put_line( fnd_file.log, 'base_lang: ' || base_lang);
1010:
1011: if p_job_size > 0 then l_job_size := p_job_size; end if;
1012: p_print_date_high := fnd_date.canonical_to_date(p_print_date_high_in);
1013: p_print_date_low := fnd_date.canonical_to_date(p_print_date_low_in);

Line 1015: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_org_id: '|| p_org_id );

1011: if p_job_size > 0 then l_job_size := p_job_size; end if;
1012: p_print_date_high := fnd_date.canonical_to_date(p_print_date_high_in);
1013: p_print_date_low := fnd_date.canonical_to_date(p_print_date_low_in);
1014: -- print out the input parameters;
1015: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_org_id: '|| p_org_id );
1016: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_job_size: '|| l_job_size );
1017: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_choice: '|| p_choice );
1018: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_order_by: '|| p_order_by );
1019: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_BATCH_ID: '|| p_BATCH_ID );

Line 1016: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_job_size: '|| l_job_size );

1012: p_print_date_high := fnd_date.canonical_to_date(p_print_date_high_in);
1013: p_print_date_low := fnd_date.canonical_to_date(p_print_date_low_in);
1014: -- print out the input parameters;
1015: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_org_id: '|| p_org_id );
1016: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_job_size: '|| l_job_size );
1017: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_choice: '|| p_choice );
1018: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_order_by: '|| p_order_by );
1019: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_BATCH_ID: '|| p_BATCH_ID );
1020: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_cust_trx_class '|| p_cust_trx_class );

Line 1017: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_choice: '|| p_choice );

1013: p_print_date_low := fnd_date.canonical_to_date(p_print_date_low_in);
1014: -- print out the input parameters;
1015: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_org_id: '|| p_org_id );
1016: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_job_size: '|| l_job_size );
1017: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_choice: '|| p_choice );
1018: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_order_by: '|| p_order_by );
1019: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_BATCH_ID: '|| p_BATCH_ID );
1020: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_cust_trx_class '|| p_cust_trx_class );
1021: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_TYPE_ID: '|| p_TRX_TYPE_ID );

Line 1018: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_order_by: '|| p_order_by );

1014: -- print out the input parameters;
1015: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_org_id: '|| p_org_id );
1016: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_job_size: '|| l_job_size );
1017: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_choice: '|| p_choice );
1018: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_order_by: '|| p_order_by );
1019: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_BATCH_ID: '|| p_BATCH_ID );
1020: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_cust_trx_class '|| p_cust_trx_class );
1021: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_TYPE_ID: '|| p_TRX_TYPE_ID );
1022: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_class_code: '|| p_customer_class_code );

Line 1019: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_BATCH_ID: '|| p_BATCH_ID );

1015: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_org_id: '|| p_org_id );
1016: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_job_size: '|| l_job_size );
1017: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_choice: '|| p_choice );
1018: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_order_by: '|| p_order_by );
1019: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_BATCH_ID: '|| p_BATCH_ID );
1020: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_cust_trx_class '|| p_cust_trx_class );
1021: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_TYPE_ID: '|| p_TRX_TYPE_ID );
1022: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_class_code: '|| p_customer_class_code );
1023: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_name_low: '|| p_customer_name_low );

Line 1020: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_cust_trx_class '|| p_cust_trx_class );

1016: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_job_size: '|| l_job_size );
1017: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_choice: '|| p_choice );
1018: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_order_by: '|| p_order_by );
1019: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_BATCH_ID: '|| p_BATCH_ID );
1020: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_cust_trx_class '|| p_cust_trx_class );
1021: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_TYPE_ID: '|| p_TRX_TYPE_ID );
1022: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_class_code: '|| p_customer_class_code );
1023: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_name_low: '|| p_customer_name_low );
1024: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_CUSTOMER_NAME_HIGH: '|| p_CUSTOMER_NAME_HIGH );

Line 1021: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_TYPE_ID: '|| p_TRX_TYPE_ID );

1017: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_choice: '|| p_choice );
1018: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_order_by: '|| p_order_by );
1019: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_BATCH_ID: '|| p_BATCH_ID );
1020: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_cust_trx_class '|| p_cust_trx_class );
1021: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_TYPE_ID: '|| p_TRX_TYPE_ID );
1022: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_class_code: '|| p_customer_class_code );
1023: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_name_low: '|| p_customer_name_low );
1024: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_CUSTOMER_NAME_HIGH: '|| p_CUSTOMER_NAME_HIGH );
1025: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_low: '|| p_customer_no_low );

Line 1022: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_class_code: '|| p_customer_class_code );

1018: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_order_by: '|| p_order_by );
1019: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_BATCH_ID: '|| p_BATCH_ID );
1020: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_cust_trx_class '|| p_cust_trx_class );
1021: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_TYPE_ID: '|| p_TRX_TYPE_ID );
1022: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_class_code: '|| p_customer_class_code );
1023: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_name_low: '|| p_customer_name_low );
1024: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_CUSTOMER_NAME_HIGH: '|| p_CUSTOMER_NAME_HIGH );
1025: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_low: '|| p_customer_no_low );
1026: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_high: '|| p_customer_no_high );

Line 1023: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_name_low: '|| p_customer_name_low );

1019: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_BATCH_ID: '|| p_BATCH_ID );
1020: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_cust_trx_class '|| p_cust_trx_class );
1021: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_TYPE_ID: '|| p_TRX_TYPE_ID );
1022: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_class_code: '|| p_customer_class_code );
1023: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_name_low: '|| p_customer_name_low );
1024: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_CUSTOMER_NAME_HIGH: '|| p_CUSTOMER_NAME_HIGH );
1025: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_low: '|| p_customer_no_low );
1026: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_high: '|| p_customer_no_high );
1027: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_LOW: '|| p_TRX_NUMBER_LOW );

Line 1024: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_CUSTOMER_NAME_HIGH: '|| p_CUSTOMER_NAME_HIGH );

1020: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_cust_trx_class '|| p_cust_trx_class );
1021: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_TYPE_ID: '|| p_TRX_TYPE_ID );
1022: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_class_code: '|| p_customer_class_code );
1023: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_name_low: '|| p_customer_name_low );
1024: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_CUSTOMER_NAME_HIGH: '|| p_CUSTOMER_NAME_HIGH );
1025: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_low: '|| p_customer_no_low );
1026: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_high: '|| p_customer_no_high );
1027: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_LOW: '|| p_TRX_NUMBER_LOW );
1028: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_HIGH: '|| p_TRX_NUMBER_HIGH );

Line 1025: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_low: '|| p_customer_no_low );

1021: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_TYPE_ID: '|| p_TRX_TYPE_ID );
1022: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_class_code: '|| p_customer_class_code );
1023: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_name_low: '|| p_customer_name_low );
1024: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_CUSTOMER_NAME_HIGH: '|| p_CUSTOMER_NAME_HIGH );
1025: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_low: '|| p_customer_no_low );
1026: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_high: '|| p_customer_no_high );
1027: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_LOW: '|| p_TRX_NUMBER_LOW );
1028: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_HIGH: '|| p_TRX_NUMBER_HIGH );
1029: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INSTALLMENT_NO: '|| p_INSTALLMENT_NO );

Line 1026: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_high: '|| p_customer_no_high );

1022: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_class_code: '|| p_customer_class_code );
1023: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_name_low: '|| p_customer_name_low );
1024: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_CUSTOMER_NAME_HIGH: '|| p_CUSTOMER_NAME_HIGH );
1025: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_low: '|| p_customer_no_low );
1026: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_high: '|| p_customer_no_high );
1027: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_LOW: '|| p_TRX_NUMBER_LOW );
1028: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_HIGH: '|| p_TRX_NUMBER_HIGH );
1029: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INSTALLMENT_NO: '|| p_INSTALLMENT_NO );
1030: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_LOW: '|| p_PRINT_DATE_LOW );

Line 1027: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_LOW: '|| p_TRX_NUMBER_LOW );

1023: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_name_low: '|| p_customer_name_low );
1024: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_CUSTOMER_NAME_HIGH: '|| p_CUSTOMER_NAME_HIGH );
1025: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_low: '|| p_customer_no_low );
1026: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_high: '|| p_customer_no_high );
1027: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_LOW: '|| p_TRX_NUMBER_LOW );
1028: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_HIGH: '|| p_TRX_NUMBER_HIGH );
1029: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INSTALLMENT_NO: '|| p_INSTALLMENT_NO );
1030: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_LOW: '|| p_PRINT_DATE_LOW );
1031: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_HIGH: '|| p_PRINT_DATE_HIGH );

Line 1028: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_HIGH: '|| p_TRX_NUMBER_HIGH );

1024: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_CUSTOMER_NAME_HIGH: '|| p_CUSTOMER_NAME_HIGH );
1025: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_low: '|| p_customer_no_low );
1026: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_high: '|| p_customer_no_high );
1027: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_LOW: '|| p_TRX_NUMBER_LOW );
1028: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_HIGH: '|| p_TRX_NUMBER_HIGH );
1029: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INSTALLMENT_NO: '|| p_INSTALLMENT_NO );
1030: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_LOW: '|| p_PRINT_DATE_LOW );
1031: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_HIGH: '|| p_PRINT_DATE_HIGH );
1032: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_OPEN_INVOICE_FLAG: '|| p_OPEN_INVOICE_FLAG );

Line 1029: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INSTALLMENT_NO: '|| p_INSTALLMENT_NO );

1025: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_low: '|| p_customer_no_low );
1026: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_high: '|| p_customer_no_high );
1027: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_LOW: '|| p_TRX_NUMBER_LOW );
1028: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_HIGH: '|| p_TRX_NUMBER_HIGH );
1029: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INSTALLMENT_NO: '|| p_INSTALLMENT_NO );
1030: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_LOW: '|| p_PRINT_DATE_LOW );
1031: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_HIGH: '|| p_PRINT_DATE_HIGH );
1032: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_OPEN_INVOICE_FLAG: '|| p_OPEN_INVOICE_FLAG );
1033: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INVOICE_LIST_STRING: '|| p_INVOICE_LIST_STRING );

Line 1030: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_LOW: '|| p_PRINT_DATE_LOW );

1026: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_high: '|| p_customer_no_high );
1027: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_LOW: '|| p_TRX_NUMBER_LOW );
1028: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_HIGH: '|| p_TRX_NUMBER_HIGH );
1029: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INSTALLMENT_NO: '|| p_INSTALLMENT_NO );
1030: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_LOW: '|| p_PRINT_DATE_LOW );
1031: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_HIGH: '|| p_PRINT_DATE_HIGH );
1032: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_OPEN_INVOICE_FLAG: '|| p_OPEN_INVOICE_FLAG );
1033: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INVOICE_LIST_STRING: '|| p_INVOICE_LIST_STRING );
1034: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TEMPLATE_ID: '|| p_template_id );

Line 1031: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_HIGH: '|| p_PRINT_DATE_HIGH );

1027: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_LOW: '|| p_TRX_NUMBER_LOW );
1028: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_HIGH: '|| p_TRX_NUMBER_HIGH );
1029: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INSTALLMENT_NO: '|| p_INSTALLMENT_NO );
1030: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_LOW: '|| p_PRINT_DATE_LOW );
1031: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_HIGH: '|| p_PRINT_DATE_HIGH );
1032: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_OPEN_INVOICE_FLAG: '|| p_OPEN_INVOICE_FLAG );
1033: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INVOICE_LIST_STRING: '|| p_INVOICE_LIST_STRING );
1034: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TEMPLATE_ID: '|| p_template_id );
1035: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_child_TEMPLATE_ID: '|| p_child_template_id );

Line 1032: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_OPEN_INVOICE_FLAG: '|| p_OPEN_INVOICE_FLAG );

1028: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_HIGH: '|| p_TRX_NUMBER_HIGH );
1029: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INSTALLMENT_NO: '|| p_INSTALLMENT_NO );
1030: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_LOW: '|| p_PRINT_DATE_LOW );
1031: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_HIGH: '|| p_PRINT_DATE_HIGH );
1032: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_OPEN_INVOICE_FLAG: '|| p_OPEN_INVOICE_FLAG );
1033: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INVOICE_LIST_STRING: '|| p_INVOICE_LIST_STRING );
1034: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TEMPLATE_ID: '|| p_template_id );
1035: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_child_TEMPLATE_ID: '|| p_child_template_id );
1036: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_locale: '|| p_locale);

Line 1033: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INVOICE_LIST_STRING: '|| p_INVOICE_LIST_STRING );

1029: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INSTALLMENT_NO: '|| p_INSTALLMENT_NO );
1030: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_LOW: '|| p_PRINT_DATE_LOW );
1031: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_HIGH: '|| p_PRINT_DATE_HIGH );
1032: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_OPEN_INVOICE_FLAG: '|| p_OPEN_INVOICE_FLAG );
1033: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INVOICE_LIST_STRING: '|| p_INVOICE_LIST_STRING );
1034: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TEMPLATE_ID: '|| p_template_id );
1035: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_child_TEMPLATE_ID: '|| p_child_template_id );
1036: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_locale: '|| p_locale);
1037: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_index_flag: '|| p_index_flag);

Line 1034: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TEMPLATE_ID: '|| p_template_id );

1030: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_LOW: '|| p_PRINT_DATE_LOW );
1031: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_HIGH: '|| p_PRINT_DATE_HIGH );
1032: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_OPEN_INVOICE_FLAG: '|| p_OPEN_INVOICE_FLAG );
1033: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INVOICE_LIST_STRING: '|| p_INVOICE_LIST_STRING );
1034: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TEMPLATE_ID: '|| p_template_id );
1035: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_child_TEMPLATE_ID: '|| p_child_template_id );
1036: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_locale: '|| p_locale);
1037: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_index_flag: '|| p_index_flag);
1038:

Line 1035: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_child_TEMPLATE_ID: '|| p_child_template_id );

1031: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_HIGH: '|| p_PRINT_DATE_HIGH );
1032: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_OPEN_INVOICE_FLAG: '|| p_OPEN_INVOICE_FLAG );
1033: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INVOICE_LIST_STRING: '|| p_INVOICE_LIST_STRING );
1034: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TEMPLATE_ID: '|| p_template_id );
1035: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_child_TEMPLATE_ID: '|| p_child_template_id );
1036: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_locale: '|| p_locale);
1037: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_index_flag: '|| p_index_flag);
1038:
1039: -- fetch a list of payment schedule id based on the inputted parameters

Line 1036: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_locale: '|| p_locale);

1032: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_OPEN_INVOICE_FLAG: '|| p_OPEN_INVOICE_FLAG );
1033: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INVOICE_LIST_STRING: '|| p_INVOICE_LIST_STRING );
1034: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TEMPLATE_ID: '|| p_template_id );
1035: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_child_TEMPLATE_ID: '|| p_child_template_id );
1036: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_locale: '|| p_locale);
1037: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_index_flag: '|| p_index_flag);
1038:
1039: -- fetch a list of payment schedule id based on the inputted parameters
1040: -- and insert into the ar_bpa_print_requests table

Line 1037: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_index_flag: '|| p_index_flag);

1033: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INVOICE_LIST_STRING: '|| p_INVOICE_LIST_STRING );
1034: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TEMPLATE_ID: '|| p_template_id );
1035: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_child_TEMPLATE_ID: '|| p_child_template_id );
1036: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_locale: '|| p_locale);
1037: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_index_flag: '|| p_index_flag);
1038:
1039: -- fetch a list of payment schedule id based on the inputted parameters
1040: -- and insert into the ar_bpa_print_requests table
1041:

Line 1104: --fnd_file.put_line( fnd_file.log, sql_stmt);

1100: -- sql_stmt := sql_stmt || cr || ' ORDER BY a_bill_loc.postal_code ' ;
1101: -- END IF;
1102:
1103:
1104: --fnd_file.put_line( fnd_file.log, sql_stmt);
1105: ------------------------------------------------
1106: -- Parse sql stmts
1107: ------------------------------------------------
1108:

Line 1159: fnd_file.put_line( fnd_file.log, 'inserted row count: ' || inserted_row_counts);

1155: END IF;
1156:
1157:
1158: inserted_row_counts := dbms_sql.execute(sql_stmt_c);
1159: fnd_file.put_line( fnd_file.log, 'inserted row count: ' || inserted_row_counts);
1160:
1161: IF inserted_row_counts > 0 THEN
1162:
1163: divided_worker_counts := ceil(inserted_row_counts/l_job_size);

Line 1166: fnd_file.put_line( fnd_file.log, 'row count per worker: ' || row_counts_perworker);

1162:
1163: divided_worker_counts := ceil(inserted_row_counts/l_job_size);
1164: row_counts_perworker := ceil(inserted_row_counts/divided_worker_counts);
1165:
1166: fnd_file.put_line( fnd_file.log, 'row count per worker: ' || row_counts_perworker);
1167: fnd_file.put_line( fnd_file.log, 'divided worker count: ' || divided_worker_counts);
1168:
1169: l_worker_id := 1 ;
1170: l_low_range := 1 ;

Line 1167: fnd_file.put_line( fnd_file.log, 'divided worker count: ' || divided_worker_counts);

1163: divided_worker_counts := ceil(inserted_row_counts/l_job_size);
1164: row_counts_perworker := ceil(inserted_row_counts/divided_worker_counts);
1165:
1166: fnd_file.put_line( fnd_file.log, 'row count per worker: ' || row_counts_perworker);
1167: fnd_file.put_line( fnd_file.log, 'divided worker count: ' || divided_worker_counts);
1168:
1169: l_worker_id := 1 ;
1170: l_low_range := 1 ;
1171: l_high_range := row_counts_perworker ;

Line 1204: fnd_file.put_line( fnd_file.log, 'can not start for worker_id: ' ||no_of_workers );

1200: p_locale,
1201: p_index_flag,
1202: '','', TRUE);
1203: IF (l_request_id = 0) THEN
1204: fnd_file.put_line( fnd_file.log, 'can not start for worker_id: ' ||no_of_workers );
1205: FND_MESSAGE.RETRIEVE(return_stat);
1206: fnd_file.put_line( fnd_file.log, 'Error occured : ' ||return_stat );
1207: l_fail_count := l_fail_count + 1;
1208: ELSE

Line 1206: fnd_file.put_line( fnd_file.log, 'Error occured : ' ||return_stat );

1202: '','', TRUE);
1203: IF (l_request_id = 0) THEN
1204: fnd_file.put_line( fnd_file.log, 'can not start for worker_id: ' ||no_of_workers );
1205: FND_MESSAGE.RETRIEVE(return_stat);
1206: fnd_file.put_line( fnd_file.log, 'Error occured : ' ||return_stat );
1207: l_fail_count := l_fail_count + 1;
1208: ELSE
1209: commit;
1210: fnd_file.put_line( fnd_file.log, 'child request id: ' ||

Line 1210: fnd_file.put_line( fnd_file.log, 'child request id: ' ||

1206: fnd_file.put_line( fnd_file.log, 'Error occured : ' ||return_stat );
1207: l_fail_count := l_fail_count + 1;
1208: ELSE
1209: commit;
1210: fnd_file.put_line( fnd_file.log, 'child request id: ' ||
1211: l_request_id || ' started for worker_id: ' ||no_of_workers );
1212: END IF;
1213: END LOOP;
1214:

Line 1217: fnd_file.put_line( fnd_file.log, 'The Master program changed status to pause and wait for child processes');

1213: END LOOP;
1214:
1215: fnd_conc_global.set_req_globals(conc_status => 'PAUSED',
1216: request_data => to_char(inserted_row_counts));
1217: fnd_file.put_line( fnd_file.log, 'The Master program changed status to pause and wait for child processes');
1218: ELSE
1219: fnd_file.new_line( fnd_file.log,1 );
1220: fnd_file.put_line( fnd_file.log, 'No transactions matched the input parameters.');
1221: fnd_file.new_line( fnd_file.log,1 );

Line 1219: fnd_file.new_line( fnd_file.log,1 );

1215: fnd_conc_global.set_req_globals(conc_status => 'PAUSED',
1216: request_data => to_char(inserted_row_counts));
1217: fnd_file.put_line( fnd_file.log, 'The Master program changed status to pause and wait for child processes');
1218: ELSE
1219: fnd_file.new_line( fnd_file.log,1 );
1220: fnd_file.put_line( fnd_file.log, 'No transactions matched the input parameters.');
1221: fnd_file.new_line( fnd_file.log,1 );
1222: END IF;
1223:

Line 1220: fnd_file.put_line( fnd_file.log, 'No transactions matched the input parameters.');

1216: request_data => to_char(inserted_row_counts));
1217: fnd_file.put_line( fnd_file.log, 'The Master program changed status to pause and wait for child processes');
1218: ELSE
1219: fnd_file.new_line( fnd_file.log,1 );
1220: fnd_file.put_line( fnd_file.log, 'No transactions matched the input parameters.');
1221: fnd_file.new_line( fnd_file.log,1 );
1222: END IF;
1223:
1224: ELSE

Line 1221: fnd_file.new_line( fnd_file.log,1 );

1217: fnd_file.put_line( fnd_file.log, 'The Master program changed status to pause and wait for child processes');
1218: ELSE
1219: fnd_file.new_line( fnd_file.log,1 );
1220: fnd_file.put_line( fnd_file.log, 'No transactions matched the input parameters.');
1221: fnd_file.new_line( fnd_file.log,1 );
1222: END IF;
1223:
1224: ELSE
1225:

Line 1226: FND_FILE.PUT_LINE( FND_FILE.LOG, 'print_invoices: '

1222: END IF;
1223:
1224: ELSE
1225:
1226: FND_FILE.PUT_LINE( FND_FILE.LOG, 'print_invoices: '
1227: || 'Entering print master program at the second time');
1228: fnd_file.put_line( fnd_file.output,
1229: arp_standard.fnd_message('AR_BPA_PRINT_OUTPUT_HDR',
1230: 'NUM_OF_WORKER',

Line 1228: fnd_file.put_line( fnd_file.output,

1224: ELSE
1225:
1226: FND_FILE.PUT_LINE( FND_FILE.LOG, 'print_invoices: '
1227: || 'Entering print master program at the second time');
1228: fnd_file.put_line( fnd_file.output,
1229: arp_standard.fnd_message('AR_BPA_PRINT_OUTPUT_HDR',
1230: 'NUM_OF_WORKER',
1231: divided_worker_counts,
1232: 'TRX_COUNT',

Line 1273: FND_FILE.PUT_LINE( FND_FILE.LOG, 'AR_BPA_PRINT_CONC.print_invoices(-)' );

1269: COMMIT;
1270:
1271: END IF;
1272:
1273: FND_FILE.PUT_LINE( FND_FILE.LOG, 'AR_BPA_PRINT_CONC.print_invoices(-)' );
1274:
1275: EXCEPTION
1276: WHEN OTHERS THEN
1277: RAISE;