');
220:
221: IF output_file_type ='HTML' THEN
222: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
223: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
224: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
225:
226:
227: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
228: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message1,
Line 227: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
223: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
224: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
225:
226:
227: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
228: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message1,
229: p_bold => 'N',
230: p_output_file_type => output_file_type)||'
');
231:
Line 232: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
228: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message1,
229: p_bold => 'N',
230: p_output_file_type => output_file_type)||'
');
231:
232: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
233: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message2,
234: p_bold => 'N',
235: p_output_file_type => output_file_type)||'
');
236:
Line 237: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
233: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message2,
234: p_bold => 'N',
235: p_output_file_type => output_file_type)||'
');
236:
237: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
238: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message3,
239: p_bold => 'N',
240: p_output_file_type => output_file_type)||'
');
241: ELSE
Line 242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
238: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message3,
239: p_bold => 'N',
240: p_output_file_type => output_file_type)||'');
241: ELSE
242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
243: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message1,
244: p_bold => 'N',
245: p_output_file_type => output_file_type));
246:
Line 247: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
243: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message1,
244: p_bold => 'N',
245: p_output_file_type => output_file_type));
246:
247: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
248: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message2,
249: p_bold => 'N',
250: p_output_file_type => output_file_type));
251:
Line 252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
248: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message2,
249: p_bold => 'N',
250: p_output_file_type => output_file_type));
251:
252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
253: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message3,
254: p_bold => 'N',
255: p_output_file_type => output_file_type));
256: END IF;
Line 518: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
514: hr_utility.set_location(gv_package_name || '.select_employee', 20);
515: hr_utility.trace('lv_assignment_set = ' || lv_assignment_set);
516: hr_utility.trace('lv_output_file_type = ' || lv_output_file_type);
517:
518: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
519: pay_us_payroll_utils.formated_header_string(gv_title || ':- Tax Year: ' ||
520: to_char(lv_effective_date,'YYYY'),lv_output_file_type ));
521:
522: open c_get_business_group_id(p_tax_unit_id);
Line 558: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
554: /*create assignment set only when the first row is fetched*/
555: hr_utility.set_location(gv_package_name || '.select_employee', 50);
556: IF lv_miss_assignments=0 THEN
557: IF lv_output_file_type ='HTML' THEN
558: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
559: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
560: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
561: END IF;
562:
Line 559: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
555: hr_utility.set_location(gv_package_name || '.select_employee', 50);
556: IF lv_miss_assignments=0 THEN
557: IF lv_output_file_type ='HTML' THEN
558: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
559: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
560: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
561: END IF;
562:
563:
Line 560: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
556: IF lv_miss_assignments=0 THEN
557: IF lv_output_file_type ='HTML' THEN
558: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
559: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
560: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
561: END IF;
562:
563:
564: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,formated_header_string( lv_output_file_type));
Line 564: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,formated_header_string( lv_output_file_type));
560: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
561: END IF;
562:
563:
564: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,formated_header_string( lv_output_file_type));
565:
566: IF lv_output_file_type ='HTML' THEN
567: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
568: END IF;
Line 567: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
563:
564: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,formated_header_string( lv_output_file_type));
565:
566: IF lv_output_file_type ='HTML' THEN
567: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
568: END IF;
569:
570: hr_utility.set_location(gv_package_name || '.select_employee', 60);
571:
Line 622: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
618: IF lv_output_file_type ='HTML' THEN
619: lv_data_row := '
' || lv_data_row || '
' ;
620: END IF;
621: hr_utility.set_location(gv_package_name || '.select_employee', 40);
622: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
623:
624: END IF; /* lv_assignment_id IS NOT NULL */
625: END LOOP; /*loop c_get_missing_assignments */
626: CLOSE c_get_missing_assignments;
Line 630: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
626: CLOSE c_get_missing_assignments;
627: hr_utility.set_location(gv_package_name || '.select_employee', 100);
628:
629: IF lv_output_file_type='HTML' THEN
630: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
631:
632: END IF;
633:
634: IF lv_miss_assignments=0 THEN
Line 651: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
647: IF lv_output_file_type ='HTML' THEN
648: UPDATE fnd_concurrent_requests
649: SET output_file_type = 'HTML'
650: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID ;
651: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
652: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
653: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
654:
655: COMMIT;
Line 652: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
648: UPDATE fnd_concurrent_requests
649: SET output_file_type = 'HTML'
650: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID ;
651: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
652: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
653: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '