');
273:
274: if output_file_type ='HTML' then
275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
278: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
279: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message1,
280: p_bold => 'N',
281: p_output_file_type => output_file_type)||'
');
Line 278: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
274: if output_file_type ='HTML' then
275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
278: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
279: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message1,
280: p_bold => 'N',
281: p_output_file_type => output_file_type)||'
');
282: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
Line 282: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
278: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'
'||
279: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message1,
280: p_bold => 'N',
281: p_output_file_type => output_file_type)||'
');
282: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
283: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message2,
284: p_bold => 'N',
285: p_output_file_type => output_file_type)||'
');
286: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
Line 286: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
282: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'
'||
283: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message2,
284: p_bold => 'N',
285: p_output_file_type => output_file_type)||'
');
286: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,''||
287: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message3,
288: p_bold => 'N',
289: p_output_file_type => output_file_type)||'
');
290: else
Line 291: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
287: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message3,
288: p_bold => 'N',
289: p_output_file_type => output_file_type)||'
');
290: else
291: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
292: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message1,
293: p_bold => 'N',
294: p_output_file_type => output_file_type));
295: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
Line 295: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
291: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
292: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message1,
293: p_bold => 'N',
294: p_output_file_type => output_file_type));
295: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
296: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message2,
297: p_bold => 'N',
298: p_output_file_type => output_file_type));
299: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
Line 299: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
295: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
296: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message2,
297: p_bold => 'N',
298: p_output_file_type => output_file_type));
299: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
300: pay_us_payroll_utils.formated_data_string (p_input_string =>lvc_message3,
301: p_bold => 'N',
302: p_output_file_type => output_file_type));
303: end if;
Line 578: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
574:
575: -- 'Year End Archive Missing Assignments Report'
576: gv_title := hr_general.decode_lookup('PAY_CA_MISSING_ASG','MISSING_REPORT_HEADING');
577:
578: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
579: pay_us_payroll_utils.formated_header_string(gv_title || ' - '|| p_report_type ||' '||
580: to_char(lv_effective_date,'YYYY'), p_output_file_type ));
581:
582: IF p_report_type IN ('T4','T4A') THEN
Line 686: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
682:
683: IF lv_miss_assignments=0 THEN
684:
685: IF p_output_file_type ='HTML' THEN
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: END IF;
690:
Line 687: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
683: IF lv_miss_assignments=0 THEN
684:
685: IF p_output_file_type ='HTML' THEN
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: END IF;
690:
691: IF p_report_type in ('T4','T4A') THEN
Line 688: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
684:
685: IF p_output_file_type ='HTML' THEN
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: END IF;
690:
691: IF p_report_type in ('T4','T4A') THEN
692:
Line 693: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,formated_header_string(p_output_file_type));
689: END IF;
690:
691: IF p_report_type in ('T4','T4A') THEN
692:
693: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,formated_header_string(p_output_file_type));
694: ELSE
695: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,formated_header_string_rl(p_output_file_type));
696: END IF;
697:
Line 695: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,formated_header_string_rl(p_output_file_type));
691: IF p_report_type in ('T4','T4A') THEN
692:
693: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,formated_header_string(p_output_file_type));
694: ELSE
695: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,formated_header_string_rl(p_output_file_type));
696: END IF;
697:
698: IF p_output_file_type ='HTML' THEN
699: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
Line 699: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
695: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,formated_header_string_rl(p_output_file_type));
696: END IF;
697:
698: IF p_output_file_type ='HTML' THEN
699: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
700: END IF;
701:
702: OPEN c_assignment_set_exists(p_assign_set);
703: FETCH c_assignment_set_exists into lv_assignment_set_id;
Line 765: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
761: IF p_output_file_type ='HTML' THEN
762: lv_data_row := '
' || lv_data_row || '
' ;
763: END IF;
764:
765: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
766:
767: END IF; /*non zero run result value for the assignment*/
768:
769: END LOOP; /*loop for checking the nonzero run_result values for selected assignments*/
Line 772: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
768:
769: END LOOP; /*loop for checking the nonzero run_result values for selected assignments*/
770:
771: IF p_output_file_type='HTML' THEN
772: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
773: END IF;
774:
775: /* If No Assignments are fetched */
776: IF lv_miss_assignments = 0 THEN
Line 792: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
788:
789: UPDATE fnd_concurrent_requests
790: SET output_file_type = 'HTML'
791: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID ;
792: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
793: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
794: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
795:
796: COMMIT;
Line 793: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
789: UPDATE fnd_concurrent_requests
790: SET output_file_type = 'HTML'
791: WHERE request_id = FND_GLOBAL.CONC_REQUEST_ID ;
792: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
793: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
794: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '