');
230:
231: IF output_file_type ='HTML' THEN
232: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
233: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
234: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
235:
236:
237: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
238: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message1,
Line 237: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
233: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
234: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
235:
236:
237: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
238: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message1,
239: p_bold => 'N',
240: p_output_file_type => output_file_type)||'
');
241:
Line 242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
238: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message1,
239: p_bold => 'N',
240: p_output_file_type => output_file_type)||'
');
241:
242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
243: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message2,
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_message2,
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_message3,
249: p_bold => 'N',
250: p_output_file_type => output_file_type)||'
');
251: ELSE
Line 252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
248: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message3,
249: p_bold => 'N',
250: p_output_file_type => output_file_type)||'');
251: ELSE
252: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
253: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message1,
254: p_bold => 'N',
255: p_output_file_type => output_file_type));
256:
Line 257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
253: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message1,
254: p_bold => 'N',
255: p_output_file_type => output_file_type));
256:
257: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
258: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message2,
259: p_bold => 'N',
260: p_output_file_type => output_file_type));
261:
Line 262: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
258: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message2,
259: p_bold => 'N',
260: p_output_file_type => output_file_type));
261:
262: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
263: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message3,
264: p_bold => 'N',
265: p_output_file_type => output_file_type));
266: END IF;
Line 540: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
536: hr_utility.set_location(gv_package_name || '.select_employee', 20);
537: hr_utility.trace('lv_assignment_set = ' || lv_assignment_set);
538: hr_utility.trace('lv_output_file_type = ' || lv_output_file_type);
539:
540: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
541: pay_us_payroll_utils.formated_header_string(gv_title || ':- Tax Year: ' ||
542: to_char(lv_effective_date,'YYYY'),lv_output_file_type ));
543:
544: open c_get_business_group_id(nvl(p_tax_unit_id,l_pre_organization_id));
Line 582: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
578: /*create assignment set only when the first row is fetched*/
579: hr_utility.set_location(gv_package_name || '.select_employee', 50);
580: IF lv_miss_assignments=0 THEN
581: IF lv_output_file_type ='HTML' THEN
582: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
583: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
584: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
585: END IF;
586:
Line 583: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
579: hr_utility.set_location(gv_package_name || '.select_employee', 50);
580: IF lv_miss_assignments=0 THEN
581: IF lv_output_file_type ='HTML' THEN
582: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
583: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
584: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
585: END IF;
586:
587:
Line 584: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
580: IF lv_miss_assignments=0 THEN
581: IF lv_output_file_type ='HTML' THEN
582: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
583: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
584: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
585: END IF;
586:
587:
588: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,formated_header_string(lv_legislation_code,
Line 588: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,formated_header_string(lv_legislation_code,
584: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
585: END IF;
586:
587:
588: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,formated_header_string(lv_legislation_code,
589: lv_output_file_type,
590: l_pre_or_gre
591: )
592: );
Line 595: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
591: )
592: );
593:
594: IF lv_output_file_type ='HTML' THEN
595: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
596: END IF;
597:
598: hr_utility.set_location(gv_package_name || '.select_employee', 60);
599:
Line 657: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
653: IF lv_output_file_type ='HTML' THEN
654: lv_data_row := '
' || lv_data_row || '
' ;
655: END IF;
656: hr_utility.set_location(gv_package_name || '.select_employee', 40);
657: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
658: hr_utility.trace('10');
659: END IF; /* lv_assignment_id IS NOT NULL */
660: END LOOP; /*loop c_get_missing_assignments */
661: CLOSE c_get_missing_assignments;
Line 665: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
661: CLOSE c_get_missing_assignments;
662: hr_utility.set_location(gv_package_name || '.select_employee', 100);
663:
664: IF lv_output_file_type='HTML' THEN
665: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
666:
667: END IF;
668:
669: IF lv_miss_assignments=0 THEN
Line 686: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
682: IF lv_output_file_type ='HTML' THEN
683: UPDATE fnd_concurrent_requests
684: SET output_file_type = 'HTML'
685: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID ;
686: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
687: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
688: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
689:
690: COMMIT;
Line 687: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
683: UPDATE fnd_concurrent_requests
684: SET output_file_type = 'HTML'
685: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID ;
686: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
687: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
688: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '