DBA Data[Home] [Help]

APPS.PAY_CA_YEPP_MISS_ASSIGN_PKG dependencies on FND_FILE

Line 243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,

239: lvc_message := hr_general.decode_lookup ('PAY_CA_MISSING_ASG','NO_MISSING_ASG');
240:
241: hr_utility.set_location(gv_package_name || '.formated_zero_count', 10);
242:
243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
244: pay_us_payroll_utils.formated_data_string (p_input_string => lvc_message
245: ,p_bold => 'N'
246: ,p_output_file_type => output_file_type));
247: END;

Line 275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

271: lvc_message2 := hr_general.decode_lookup('PAY_CA_MISSING_ASG','ASG_SET_ID')||': '||to_char(assignment_set_id);
272: lvc_message3 := hr_general.decode_lookup('PAY_CA_MISSING_ASG','NUMBER_OF_ASG')||': '||to_char(record_count);
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,

Line 276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

272: lvc_message3 := hr_general.decode_lookup('PAY_CA_MISSING_ASG','NUMBER_OF_ASG')||': '||to_char(record_count);
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',

Line 277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');

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, '');
795:
796: COMMIT;
797:

Line 794: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

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;
797:
798: END IF;