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 84: fnd_file.put_line( fnd_file.output, arp_standard.fnd_message('AR_BPA_PRINT_CHILD_REQ',

80: dphase,
81: dstatus,
82: message);
83:
84: fnd_file.put_line( fnd_file.output, arp_standard.fnd_message('AR_BPA_PRINT_CHILD_REQ',
85: 'REQ_ID',
86: p_request_id,
87: 'PHASE',
88: dphase,

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

89: 'STATUS',
90: dstatus));
91:
92: IF ((dphase = 'COMPLETE') and (dstatus = 'NORMAL')) THEN
93: fnd_file.put_line( fnd_file.log, 'child request id: ' || p_request_id || ' complete successfully');
94: ELSE
95: fnd_file.put_line( fnd_file.log, 'child request id: ' || p_request_id || ' did not complete successfully');
96: END IF;
97:

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

91:
92: IF ((dphase = 'COMPLETE') and (dstatus = 'NORMAL')) THEN
93: fnd_file.put_line( fnd_file.log, 'child request id: ' || p_request_id || ' complete successfully');
94: ELSE
95: fnd_file.put_line( fnd_file.log, 'child request id: ' || p_request_id || ' did not complete successfully');
96: END IF;
97:
98: END;
99:

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

627: from fnd_languages
628: where installed_flag = 'B';
629:
630: MO_global.init('AR');
631: fnd_file.put_line( fnd_file.log, 'userenv_lang: ' || userenv_lang);
632: fnd_file.put_line( fnd_file.log, 'base_lang: ' || base_lang);
633:
634: /* Read in Parameter Values supplied by user */
635: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Operating Unit',parm_number);

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

628: where installed_flag = 'B';
629:
630: MO_global.init('AR');
631: fnd_file.put_line( fnd_file.log, 'userenv_lang: ' || userenv_lang);
632: fnd_file.put_line( fnd_file.log, 'base_lang: ' || base_lang);
633:
634: /* Read in Parameter Values supplied by user */
635: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Operating Unit',parm_number);
636: IF retval = -1 THEN

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

637: p_org_id := NULL;
638: ELSE
639: p_org_id:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
640: END IF;
641: fnd_file.put_line( fnd_file.log, 'p_org_id: ' || p_org_id);
642:
643: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Job Size',parm_number);
644: IF retval = -1 THEN
645: p_job_size:= NULL;

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

645: p_job_size:= NULL;
646: ELSE
647: p_job_size:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
648: END IF;
649: fnd_file.put_line( fnd_file.log, 'p_job_size: ' || p_job_size);
650:
651: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Transactions to Print',parm_number);
652: IF retval = -1 THEN
653: p_choice:= NULL;

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

653: p_choice:= NULL;
654: ELSE
655: p_choice:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
656: END IF;
657: fnd_file.put_line( fnd_file.log, 'p_choice: ' || p_choice);
658:
659: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Order By',parm_number);
660: IF retval = -1 THEN
661: p_order_by:= NULL;

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

661: p_order_by:= NULL;
662: ELSE
663: p_order_by:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
664: END IF;
665: fnd_file.put_line( fnd_file.log, 'p_order_by: ' || p_order_by);
666:
667: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Batch',parm_number);
668: IF retval = -1 THEN
669: p_BATCH_ID := NULL;

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

670: ELSE
671: p_BATCH_ID := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
672: filter_exists := true;
673: END IF;
674: fnd_file.put_line( fnd_file.log, 'p_BATCH_ID: ' || p_BATCH_ID);
675:
676: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Transaction Class',parm_number);
677: IF retval = -1 THEN
678: p_cust_trx_class := NULL;

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

678: p_cust_trx_class := NULL;
679: ELSE
680: p_cust_trx_class := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
681: END IF;
682: fnd_file.put_line( fnd_file.log, 'p_cust_trx_class: ' || p_cust_trx_class);
683:
684: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Transaction Type',parm_number);
685: IF retval = -1 THEN
686: p_TRX_TYPE_ID := NULL;

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

686: p_TRX_TYPE_ID := NULL;
687: ELSE
688: p_TRX_TYPE_ID := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
689: END IF;
690: fnd_file.put_line( fnd_file.log, 'p_TRX_TYPE_ID: ' || p_TRX_TYPE_ID);
691:
692: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Customer Class',parm_number);
693: IF retval = -1 THEN
694: p_customer_class_code:= NULL;

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

694: p_customer_class_code:= NULL;
695: ELSE
696: p_customer_class_code:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
697: END IF;
698: fnd_file.put_line( fnd_file.log, 'p_customer_class_code: ' || p_customer_class_code);
699:
700: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(From) Bill To Customer Name',parm_number);
701: IF retval = -1 THEN
702: p_customer_name_low:= NULL;

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

702: p_customer_name_low:= NULL;
703: ELSE
704: p_customer_name_low:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
705: END IF;
706: fnd_file.put_line( fnd_file.log, 'p_customer_name_low: ' || p_customer_name_low);
707:
708: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(To) Bill To Customer Name',parm_number);
709: IF retval = -1 THEN
710: p_CUSTOMER_NAME_HIGH := NULL;

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

710: p_CUSTOMER_NAME_HIGH := NULL;
711: ELSE
712: p_CUSTOMER_NAME_HIGH := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
713: END IF;
714: fnd_file.put_line( fnd_file.log, 'p_CUSTOMER_NAME_HIGH: ' || p_CUSTOMER_NAME_HIGH);
715:
716: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(Low) Bill To Customer Number',parm_number);
717: IF retval = -1 THEN
718: p_customer_no_low:= NULL;

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

718: p_customer_no_low:= NULL;
719: ELSE
720: p_customer_no_low:= FND_REQUEST_INFO.GET_PARAMETER(parm_number);
721: END IF;
722: fnd_file.put_line( fnd_file.log, 'p_customer_no_low: ' || p_customer_no_low);
723:
724: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(High) Bill To Customer Number',parm_number);
725: IF retval = -1 THEN
726: p_customer_no_high := NULL;

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

726: p_customer_no_high := NULL;
727: ELSE
728: p_customer_no_high := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
729: END IF;
730: fnd_file.put_line( fnd_file.log, 'p_customer_no_high: ' || p_customer_no_high);
731:
732: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(Low) Transaction Number',parm_number);
733: IF retval = -1 THEN
734: p_TRX_NUMBER_LOW := NULL;

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

734: p_TRX_NUMBER_LOW := NULL;
735: ELSE
736: p_TRX_NUMBER_LOW := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
737: END IF;
738: fnd_file.put_line( fnd_file.log, 'p_TRX_NUMBER_LOW: ' || p_TRX_NUMBER_LOW);
739:
740: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(High) Transaction Number',parm_number);
741: IF retval = -1 THEN
742: p_TRX_NUMBER_HIGH := NULL;

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

742: p_TRX_NUMBER_HIGH := NULL;
743: ELSE
744: p_TRX_NUMBER_HIGH := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
745: END IF;
746: fnd_file.put_line( fnd_file.log, 'p_TRX_NUMBER_HIGH: ' || p_TRX_NUMBER_HIGH);
747:
748: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Installment Number',parm_number);
749: IF retval = -1 THEN
750: p_INSTALLMENT_NO := NULL;

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

750: p_INSTALLMENT_NO := NULL;
751: ELSE
752: p_INSTALLMENT_NO := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
753: END IF;
754: fnd_file.put_line( fnd_file.log, 'p_INSTALLMENT_NO: ' || p_INSTALLMENT_NO);
755:
756: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(Low) Print Date',parm_number);
757: IF retval = -1 THEN
758: p_PRINT_DATE_LOW := NULL;

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

758: p_PRINT_DATE_LOW := NULL;
759: ELSE
760: p_PRINT_DATE_LOW := fnd_date.canonical_to_date(FND_REQUEST_INFO.GET_PARAMETER(parm_number));
761: END IF;
762: fnd_file.put_line( fnd_file.log, 'p_PRINT_DATE_LOW: ' || p_PRINT_DATE_LOW);
763:
764: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('(High) Print Date',parm_number);
765: IF retval = -1 THEN
766: p_PRINT_DATE_HIGH := NULL;

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

766: p_PRINT_DATE_HIGH := NULL;
767: ELSE
768: p_PRINT_DATE_HIGH := fnd_date.canonical_to_date(FND_REQUEST_INFO.GET_PARAMETER(parm_number));
769: END IF;
770: fnd_file.put_line( fnd_file.log, 'p_PRINT_DATE_HIGH: ' || p_PRINT_DATE_HIGH);
771:
772: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Open Invoices Only',parm_number);
773: IF retval = -1 THEN
774: p_OPEN_INVOICE_FLAG := NULL;

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

774: p_OPEN_INVOICE_FLAG := NULL;
775: ELSE
776: p_OPEN_INVOICE_FLAG := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
777: END IF;
778: fnd_file.put_line( fnd_file.log, 'p_OPEN_INVOICE_FLAG: ' || p_OPEN_INVOICE_FLAG);
779:
780: retval := FND_REQUEST_INFO.GET_PARAM_NUMBER('Invoice Trx Id List',parm_number);
781: IF retval = -1 THEN
782: p_INVOICE_LIST_STRING := NULL;

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

782: p_INVOICE_LIST_STRING := NULL;
783: ELSE
784: p_INVOICE_LIST_STRING := FND_REQUEST_INFO.GET_PARAMETER(parm_number);
785: END IF;
786: fnd_file.put_line( fnd_file.log, 'p_INVOICE_LIST_STRING: ' || p_INVOICE_LIST_STRING);
787:
788:
789: select_stmt :=
790: ' select distinct(nvl(rtrim(substr(a_bill_loc.language,1,4)), ''' || base_lang || ''')) language ' || cr ||

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

836: p_where2 ) ;
837: sql_stmt := sql_stmt || cr || ' UNION ' || cr || select_stmt || cr || p_where2 ;
838: END IF;
839:
840: --fnd_file.put_line( fnd_file.log, 'The final sql: ' || sql_stmt);
841: ------------------------------------------------
842: -- Parse sql stmts
843: ------------------------------------------------
844:

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

914: END IF;
915: END LOOP;
916:
917: IF lang_str IS NULL THEN
918: fnd_file.put_line( fnd_file.log, 'No transactions matched the input parameters.' );
919: ELSE
920: fnd_file.put_line( fnd_file.log, 'lang_str: ' || lang_str);
921: END IF;
922:

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

916:
917: IF lang_str IS NULL THEN
918: fnd_file.put_line( fnd_file.log, 'No transactions matched the input parameters.' );
919: ELSE
920: fnd_file.put_line( fnd_file.log, 'lang_str: ' || lang_str);
921: END IF;
922:
923: RETURN lang_str;
924:

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

923: RETURN lang_str;
924:
925: EXCEPTION
926: WHEN OTHERS THEN
927: fnd_file.put_line( fnd_file.log, sql_stmt);
928: RAISE;
929:
930: END PRINT_MLS_FUNCTION ;
931:

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

997:
998: BEGIN
999:
1000: MO_global.init('AR');
1001: FND_FILE.PUT_LINE( FND_FILE.LOG, 'AR_BPA_PRINT_CONC.print_invoices(+)' );
1002: -- to check if the output directory exists
1003:
1004: -- read the variable request_data to check if it is reentering the program
1005: req_data := fnd_conc_global.request_data;

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

1004: -- read the variable request_data to check if it is reentering the program
1005: req_data := fnd_conc_global.request_data;
1006: m_request_id := fnd_global.conc_request_id;
1007:
1008: FND_FILE.PUT_LINE( FND_FILE.LOG, 'print_invoices: ' || 'req_data: '|| req_data );
1009: FND_FILE.PUT_LINE( FND_FILE.LOG, 'print_invoices: ' || 'm_request_id: '|| m_request_id );
1010: IF (req_data is null) THEN
1011: FND_FILE.PUT_LINE( FND_FILE.LOG, 'print_invoices: '
1012: || 'Entering print master program at the first time');

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

1005: req_data := fnd_conc_global.request_data;
1006: m_request_id := fnd_global.conc_request_id;
1007:
1008: FND_FILE.PUT_LINE( FND_FILE.LOG, 'print_invoices: ' || 'req_data: '|| req_data );
1009: FND_FILE.PUT_LINE( FND_FILE.LOG, 'print_invoices: ' || 'm_request_id: '|| m_request_id );
1010: IF (req_data is null) THEN
1011: FND_FILE.PUT_LINE( FND_FILE.LOG, 'print_invoices: '
1012: || 'Entering print master program at the first time');
1013: -- read the user env language

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

1007:
1008: FND_FILE.PUT_LINE( FND_FILE.LOG, 'print_invoices: ' || 'req_data: '|| req_data );
1009: FND_FILE.PUT_LINE( FND_FILE.LOG, 'print_invoices: ' || 'm_request_id: '|| m_request_id );
1010: IF (req_data is null) THEN
1011: FND_FILE.PUT_LINE( FND_FILE.LOG, 'print_invoices: '
1012: || 'Entering print master program at the first time');
1013: -- read the user env language
1014: select substr(userenv('LANG'),1,4)
1015: into userenv_lang

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

1019: into base_lang
1020: from fnd_languages
1021: where installed_flag = 'B';
1022:
1023: FND_FILE.PUT_LINE( FND_FILE.LOG, 'userenv_lang: '|| userenv_lang );
1024: fnd_file.put_line( fnd_file.log, 'base_lang: ' || base_lang);
1025:
1026: if p_job_size > 0 then l_job_size := p_job_size; end if;
1027: p_print_date_high := fnd_date.canonical_to_date(p_print_date_high_in);

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

1020: from fnd_languages
1021: where installed_flag = 'B';
1022:
1023: FND_FILE.PUT_LINE( FND_FILE.LOG, 'userenv_lang: '|| userenv_lang );
1024: fnd_file.put_line( fnd_file.log, 'base_lang: ' || base_lang);
1025:
1026: if p_job_size > 0 then l_job_size := p_job_size; end if;
1027: p_print_date_high := fnd_date.canonical_to_date(p_print_date_high_in);
1028: p_print_date_low := fnd_date.canonical_to_date(p_print_date_low_in);

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

1026: if p_job_size > 0 then l_job_size := p_job_size; end if;
1027: p_print_date_high := fnd_date.canonical_to_date(p_print_date_high_in);
1028: p_print_date_low := fnd_date.canonical_to_date(p_print_date_low_in);
1029: -- print out the input parameters;
1030: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_org_id: '|| p_org_id );
1031: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_job_size: '|| l_job_size );
1032: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_choice: '|| p_choice );
1033: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_order_by: '|| p_order_by );
1034: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_BATCH_ID: '|| p_BATCH_ID );

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

1027: p_print_date_high := fnd_date.canonical_to_date(p_print_date_high_in);
1028: p_print_date_low := fnd_date.canonical_to_date(p_print_date_low_in);
1029: -- print out the input parameters;
1030: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_org_id: '|| p_org_id );
1031: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_job_size: '|| l_job_size );
1032: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_choice: '|| p_choice );
1033: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_order_by: '|| p_order_by );
1034: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_BATCH_ID: '|| p_BATCH_ID );
1035: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_cust_trx_class '|| p_cust_trx_class );

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

1028: p_print_date_low := fnd_date.canonical_to_date(p_print_date_low_in);
1029: -- print out the input parameters;
1030: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_org_id: '|| p_org_id );
1031: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_job_size: '|| l_job_size );
1032: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_choice: '|| p_choice );
1033: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_order_by: '|| p_order_by );
1034: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_BATCH_ID: '|| p_BATCH_ID );
1035: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_cust_trx_class '|| p_cust_trx_class );
1036: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_TYPE_ID: '|| p_TRX_TYPE_ID );

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

1029: -- print out the input parameters;
1030: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_org_id: '|| p_org_id );
1031: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_job_size: '|| l_job_size );
1032: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_choice: '|| p_choice );
1033: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_order_by: '|| p_order_by );
1034: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_BATCH_ID: '|| p_BATCH_ID );
1035: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_cust_trx_class '|| p_cust_trx_class );
1036: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_TYPE_ID: '|| p_TRX_TYPE_ID );
1037: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_class_code: '|| p_customer_class_code );

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

1030: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_org_id: '|| p_org_id );
1031: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_job_size: '|| l_job_size );
1032: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_choice: '|| p_choice );
1033: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_order_by: '|| p_order_by );
1034: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_BATCH_ID: '|| p_BATCH_ID );
1035: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_cust_trx_class '|| p_cust_trx_class );
1036: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_TYPE_ID: '|| p_TRX_TYPE_ID );
1037: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_class_code: '|| p_customer_class_code );
1038: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_name_low: '|| p_customer_name_low );

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

1031: FND_FILE.PUT_LINE( FND_FILE.LOG, 'l_job_size: '|| l_job_size );
1032: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_choice: '|| p_choice );
1033: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_order_by: '|| p_order_by );
1034: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_BATCH_ID: '|| p_BATCH_ID );
1035: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_cust_trx_class '|| p_cust_trx_class );
1036: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_TYPE_ID: '|| p_TRX_TYPE_ID );
1037: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_class_code: '|| p_customer_class_code );
1038: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_name_low: '|| p_customer_name_low );
1039: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_CUSTOMER_NAME_HIGH: '|| p_CUSTOMER_NAME_HIGH );

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

1032: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_choice: '|| p_choice );
1033: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_order_by: '|| p_order_by );
1034: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_BATCH_ID: '|| p_BATCH_ID );
1035: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_cust_trx_class '|| p_cust_trx_class );
1036: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_TYPE_ID: '|| p_TRX_TYPE_ID );
1037: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_class_code: '|| p_customer_class_code );
1038: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_name_low: '|| p_customer_name_low );
1039: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_CUSTOMER_NAME_HIGH: '|| p_CUSTOMER_NAME_HIGH );
1040: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_low: '|| p_customer_no_low );

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

1033: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_order_by: '|| p_order_by );
1034: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_BATCH_ID: '|| p_BATCH_ID );
1035: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_cust_trx_class '|| p_cust_trx_class );
1036: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_TYPE_ID: '|| p_TRX_TYPE_ID );
1037: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_class_code: '|| p_customer_class_code );
1038: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_name_low: '|| p_customer_name_low );
1039: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_CUSTOMER_NAME_HIGH: '|| p_CUSTOMER_NAME_HIGH );
1040: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_low: '|| p_customer_no_low );
1041: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_high: '|| p_customer_no_high );

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

1034: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_BATCH_ID: '|| p_BATCH_ID );
1035: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_cust_trx_class '|| p_cust_trx_class );
1036: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_TYPE_ID: '|| p_TRX_TYPE_ID );
1037: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_class_code: '|| p_customer_class_code );
1038: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_name_low: '|| p_customer_name_low );
1039: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_CUSTOMER_NAME_HIGH: '|| p_CUSTOMER_NAME_HIGH );
1040: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_low: '|| p_customer_no_low );
1041: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_high: '|| p_customer_no_high );
1042: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_LOW: '|| p_TRX_NUMBER_LOW );

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

1035: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_cust_trx_class '|| p_cust_trx_class );
1036: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_TYPE_ID: '|| p_TRX_TYPE_ID );
1037: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_class_code: '|| p_customer_class_code );
1038: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_name_low: '|| p_customer_name_low );
1039: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_CUSTOMER_NAME_HIGH: '|| p_CUSTOMER_NAME_HIGH );
1040: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_low: '|| p_customer_no_low );
1041: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_high: '|| p_customer_no_high );
1042: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_LOW: '|| p_TRX_NUMBER_LOW );
1043: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_HIGH: '|| p_TRX_NUMBER_HIGH );

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

1036: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_TYPE_ID: '|| p_TRX_TYPE_ID );
1037: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_class_code: '|| p_customer_class_code );
1038: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_name_low: '|| p_customer_name_low );
1039: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_CUSTOMER_NAME_HIGH: '|| p_CUSTOMER_NAME_HIGH );
1040: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_low: '|| p_customer_no_low );
1041: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_high: '|| p_customer_no_high );
1042: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_LOW: '|| p_TRX_NUMBER_LOW );
1043: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_HIGH: '|| p_TRX_NUMBER_HIGH );
1044: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INSTALLMENT_NO: '|| p_INSTALLMENT_NO );

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

1037: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_class_code: '|| p_customer_class_code );
1038: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_name_low: '|| p_customer_name_low );
1039: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_CUSTOMER_NAME_HIGH: '|| p_CUSTOMER_NAME_HIGH );
1040: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_low: '|| p_customer_no_low );
1041: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_high: '|| p_customer_no_high );
1042: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_LOW: '|| p_TRX_NUMBER_LOW );
1043: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_HIGH: '|| p_TRX_NUMBER_HIGH );
1044: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INSTALLMENT_NO: '|| p_INSTALLMENT_NO );
1045: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_LOW: '|| p_PRINT_DATE_LOW );

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

1038: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_name_low: '|| p_customer_name_low );
1039: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_CUSTOMER_NAME_HIGH: '|| p_CUSTOMER_NAME_HIGH );
1040: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_low: '|| p_customer_no_low );
1041: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_high: '|| p_customer_no_high );
1042: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_LOW: '|| p_TRX_NUMBER_LOW );
1043: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_HIGH: '|| p_TRX_NUMBER_HIGH );
1044: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INSTALLMENT_NO: '|| p_INSTALLMENT_NO );
1045: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_LOW: '|| p_PRINT_DATE_LOW );
1046: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_HIGH: '|| p_PRINT_DATE_HIGH );

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

1039: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_CUSTOMER_NAME_HIGH: '|| p_CUSTOMER_NAME_HIGH );
1040: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_low: '|| p_customer_no_low );
1041: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_high: '|| p_customer_no_high );
1042: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_LOW: '|| p_TRX_NUMBER_LOW );
1043: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_HIGH: '|| p_TRX_NUMBER_HIGH );
1044: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INSTALLMENT_NO: '|| p_INSTALLMENT_NO );
1045: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_LOW: '|| p_PRINT_DATE_LOW );
1046: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_HIGH: '|| p_PRINT_DATE_HIGH );
1047: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_OPEN_INVOICE_FLAG: '|| p_OPEN_INVOICE_FLAG );

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

1040: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_low: '|| p_customer_no_low );
1041: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_high: '|| p_customer_no_high );
1042: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_LOW: '|| p_TRX_NUMBER_LOW );
1043: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_HIGH: '|| p_TRX_NUMBER_HIGH );
1044: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INSTALLMENT_NO: '|| p_INSTALLMENT_NO );
1045: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_LOW: '|| p_PRINT_DATE_LOW );
1046: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_HIGH: '|| p_PRINT_DATE_HIGH );
1047: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_OPEN_INVOICE_FLAG: '|| p_OPEN_INVOICE_FLAG );
1048: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INVOICE_LIST_STRING: '|| p_INVOICE_LIST_STRING );

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

1041: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_customer_no_high: '|| p_customer_no_high );
1042: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_LOW: '|| p_TRX_NUMBER_LOW );
1043: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_HIGH: '|| p_TRX_NUMBER_HIGH );
1044: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INSTALLMENT_NO: '|| p_INSTALLMENT_NO );
1045: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_LOW: '|| p_PRINT_DATE_LOW );
1046: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_HIGH: '|| p_PRINT_DATE_HIGH );
1047: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_OPEN_INVOICE_FLAG: '|| p_OPEN_INVOICE_FLAG );
1048: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INVOICE_LIST_STRING: '|| p_INVOICE_LIST_STRING );
1049: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TEMPLATE_ID: '|| p_template_id );

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

1042: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_LOW: '|| p_TRX_NUMBER_LOW );
1043: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_HIGH: '|| p_TRX_NUMBER_HIGH );
1044: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INSTALLMENT_NO: '|| p_INSTALLMENT_NO );
1045: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_LOW: '|| p_PRINT_DATE_LOW );
1046: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_HIGH: '|| p_PRINT_DATE_HIGH );
1047: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_OPEN_INVOICE_FLAG: '|| p_OPEN_INVOICE_FLAG );
1048: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INVOICE_LIST_STRING: '|| p_INVOICE_LIST_STRING );
1049: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TEMPLATE_ID: '|| p_template_id );
1050: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_child_TEMPLATE_ID: '|| p_child_template_id );

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

1043: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TRX_NUMBER_HIGH: '|| p_TRX_NUMBER_HIGH );
1044: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INSTALLMENT_NO: '|| p_INSTALLMENT_NO );
1045: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_LOW: '|| p_PRINT_DATE_LOW );
1046: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_HIGH: '|| p_PRINT_DATE_HIGH );
1047: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_OPEN_INVOICE_FLAG: '|| p_OPEN_INVOICE_FLAG );
1048: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INVOICE_LIST_STRING: '|| p_INVOICE_LIST_STRING );
1049: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TEMPLATE_ID: '|| p_template_id );
1050: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_child_TEMPLATE_ID: '|| p_child_template_id );
1051: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_locale: '|| p_locale);

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

1044: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INSTALLMENT_NO: '|| p_INSTALLMENT_NO );
1045: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_LOW: '|| p_PRINT_DATE_LOW );
1046: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_HIGH: '|| p_PRINT_DATE_HIGH );
1047: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_OPEN_INVOICE_FLAG: '|| p_OPEN_INVOICE_FLAG );
1048: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INVOICE_LIST_STRING: '|| p_INVOICE_LIST_STRING );
1049: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TEMPLATE_ID: '|| p_template_id );
1050: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_child_TEMPLATE_ID: '|| p_child_template_id );
1051: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_locale: '|| p_locale);
1052: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_index_flag: '|| p_index_flag);

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

1045: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_LOW: '|| p_PRINT_DATE_LOW );
1046: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_HIGH: '|| p_PRINT_DATE_HIGH );
1047: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_OPEN_INVOICE_FLAG: '|| p_OPEN_INVOICE_FLAG );
1048: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INVOICE_LIST_STRING: '|| p_INVOICE_LIST_STRING );
1049: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TEMPLATE_ID: '|| p_template_id );
1050: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_child_TEMPLATE_ID: '|| p_child_template_id );
1051: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_locale: '|| p_locale);
1052: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_index_flag: '|| p_index_flag);
1053:

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

1046: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_PRINT_DATE_HIGH: '|| p_PRINT_DATE_HIGH );
1047: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_OPEN_INVOICE_FLAG: '|| p_OPEN_INVOICE_FLAG );
1048: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INVOICE_LIST_STRING: '|| p_INVOICE_LIST_STRING );
1049: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TEMPLATE_ID: '|| p_template_id );
1050: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_child_TEMPLATE_ID: '|| p_child_template_id );
1051: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_locale: '|| p_locale);
1052: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_index_flag: '|| p_index_flag);
1053:
1054: -- fetch a list of payment schedule id based on the inputted parameters

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

1047: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_OPEN_INVOICE_FLAG: '|| p_OPEN_INVOICE_FLAG );
1048: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INVOICE_LIST_STRING: '|| p_INVOICE_LIST_STRING );
1049: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TEMPLATE_ID: '|| p_template_id );
1050: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_child_TEMPLATE_ID: '|| p_child_template_id );
1051: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_locale: '|| p_locale);
1052: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_index_flag: '|| p_index_flag);
1053:
1054: -- fetch a list of payment schedule id based on the inputted parameters
1055: -- and insert into the ar_bpa_print_requests table

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

1048: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_INVOICE_LIST_STRING: '|| p_INVOICE_LIST_STRING );
1049: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_TEMPLATE_ID: '|| p_template_id );
1050: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_child_TEMPLATE_ID: '|| p_child_template_id );
1051: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_locale: '|| p_locale);
1052: FND_FILE.PUT_LINE( FND_FILE.LOG, 'p_index_flag: '|| p_index_flag);
1053:
1054: -- fetch a list of payment schedule id based on the inputted parameters
1055: -- and insert into the ar_bpa_print_requests table
1056:

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

1115: -- sql_stmt := sql_stmt || cr || ' ORDER BY a_bill_loc.postal_code ' ;
1116: -- END IF;
1117:
1118:
1119: --fnd_file.put_line( fnd_file.log, sql_stmt);
1120: ------------------------------------------------
1121: -- Parse sql stmts
1122: ------------------------------------------------
1123:

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

1170: END IF;
1171:
1172:
1173: inserted_row_counts := dbms_sql.execute(sql_stmt_c);
1174: fnd_file.put_line( fnd_file.log, 'inserted row count: ' || inserted_row_counts);
1175:
1176: IF inserted_row_counts > 0 THEN
1177:
1178: divided_worker_counts := ceil(inserted_row_counts/l_job_size);

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

1177:
1178: divided_worker_counts := ceil(inserted_row_counts/l_job_size);
1179: row_counts_perworker := ceil(inserted_row_counts/divided_worker_counts);
1180:
1181: fnd_file.put_line( fnd_file.log, 'row count per worker: ' || row_counts_perworker);
1182: fnd_file.put_line( fnd_file.log, 'divided worker count: ' || divided_worker_counts);
1183:
1184: l_worker_id := 1 ;
1185: l_low_range := 1 ;

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

1178: divided_worker_counts := ceil(inserted_row_counts/l_job_size);
1179: row_counts_perworker := ceil(inserted_row_counts/divided_worker_counts);
1180:
1181: fnd_file.put_line( fnd_file.log, 'row count per worker: ' || row_counts_perworker);
1182: fnd_file.put_line( fnd_file.log, 'divided worker count: ' || divided_worker_counts);
1183:
1184: l_worker_id := 1 ;
1185: l_low_range := 1 ;
1186: l_high_range := row_counts_perworker ;

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

1215: p_locale,
1216: p_index_flag,
1217: '','', TRUE);
1218: IF (l_request_id = 0) THEN
1219: fnd_file.put_line( fnd_file.log, 'can not start for worker_id: ' ||no_of_workers );
1220: FND_MESSAGE.RETRIEVE(return_stat);
1221: fnd_file.put_line( fnd_file.log, 'Error occured : ' ||return_stat );
1222: l_fail_count := l_fail_count + 1;
1223: ELSE

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

1217: '','', TRUE);
1218: IF (l_request_id = 0) THEN
1219: fnd_file.put_line( fnd_file.log, 'can not start for worker_id: ' ||no_of_workers );
1220: FND_MESSAGE.RETRIEVE(return_stat);
1221: fnd_file.put_line( fnd_file.log, 'Error occured : ' ||return_stat );
1222: l_fail_count := l_fail_count + 1;
1223: ELSE
1224: commit;
1225: fnd_file.put_line( fnd_file.log, 'child request id: ' ||

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

1221: fnd_file.put_line( fnd_file.log, 'Error occured : ' ||return_stat );
1222: l_fail_count := l_fail_count + 1;
1223: ELSE
1224: commit;
1225: fnd_file.put_line( fnd_file.log, 'child request id: ' ||
1226: l_request_id || ' started for worker_id: ' ||no_of_workers );
1227: END IF;
1228: END LOOP;
1229:

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

1228: END LOOP;
1229:
1230: fnd_conc_global.set_req_globals(conc_status => 'PAUSED',
1231: request_data => to_char(inserted_row_counts));
1232: fnd_file.put_line( fnd_file.log, 'The Master program changed status to pause and wait for child processes');
1233: ELSE
1234: fnd_file.new_line( fnd_file.log,1 );
1235: fnd_file.put_line( fnd_file.log, 'No transactions matched the input parameters.');
1236: fnd_file.new_line( fnd_file.log,1 );

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

1230: fnd_conc_global.set_req_globals(conc_status => 'PAUSED',
1231: request_data => to_char(inserted_row_counts));
1232: fnd_file.put_line( fnd_file.log, 'The Master program changed status to pause and wait for child processes');
1233: ELSE
1234: fnd_file.new_line( fnd_file.log,1 );
1235: fnd_file.put_line( fnd_file.log, 'No transactions matched the input parameters.');
1236: fnd_file.new_line( fnd_file.log,1 );
1237: END IF;
1238:

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

1231: request_data => to_char(inserted_row_counts));
1232: fnd_file.put_line( fnd_file.log, 'The Master program changed status to pause and wait for child processes');
1233: ELSE
1234: fnd_file.new_line( fnd_file.log,1 );
1235: fnd_file.put_line( fnd_file.log, 'No transactions matched the input parameters.');
1236: fnd_file.new_line( fnd_file.log,1 );
1237: END IF;
1238:
1239: ELSE

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

1232: fnd_file.put_line( fnd_file.log, 'The Master program changed status to pause and wait for child processes');
1233: ELSE
1234: fnd_file.new_line( fnd_file.log,1 );
1235: fnd_file.put_line( fnd_file.log, 'No transactions matched the input parameters.');
1236: fnd_file.new_line( fnd_file.log,1 );
1237: END IF;
1238:
1239: ELSE
1240:

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

1237: END IF;
1238:
1239: ELSE
1240:
1241: FND_FILE.PUT_LINE( FND_FILE.LOG, 'print_invoices: '
1242: || 'Entering print master program at the second time');
1243: fnd_file.put_line( fnd_file.output,
1244: arp_standard.fnd_message('AR_BPA_PRINT_OUTPUT_HDR',
1245: 'NUM_OF_WORKER',

Line 1243: fnd_file.put_line( fnd_file.output,

1239: ELSE
1240:
1241: FND_FILE.PUT_LINE( FND_FILE.LOG, 'print_invoices: '
1242: || 'Entering print master program at the second time');
1243: fnd_file.put_line( fnd_file.output,
1244: arp_standard.fnd_message('AR_BPA_PRINT_OUTPUT_HDR',
1245: 'NUM_OF_WORKER',
1246: divided_worker_counts,
1247: 'TRX_COUNT',

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

1284: COMMIT;
1285:
1286: END IF;
1287:
1288: FND_FILE.PUT_LINE( FND_FILE.LOG, 'AR_BPA_PRINT_CONC.print_invoices(-)' );
1289:
1290: EXCEPTION
1291: WHEN OTHERS THEN
1292: RAISE;