DBA Data[Home] [Help]

APPS.PAY_US_YEPP_MISS_ASSIGN_PKG dependencies on FND_FILE

Line 189: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,

185: null;
186: lvc_message := 'No person was picked up based on selection parameters.' ||
187: ' The YEPP Archive for the GRE has no missing assignments.';
188: hr_utility.set_location(gv_package_name || '.formated_zero_count', 10);
189: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
190: pay_us_payroll_utils.formated_data_string (p_input_string => lvc_message
191: ,p_bold => 'N'
192: ,p_output_file_type => output_file_type));
193: hr_utility.set_location(gv_package_name || '.formated_zero_count', 20);

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

218: to_char(record_count);
219: hr_utility.set_location(gv_package_name || '.formated_assign_count', 10);
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:

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

219: hr_utility.set_location(gv_package_name || '.formated_assign_count', 10);
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,''||

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

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, '');
654:
655: COMMIT;
656: END IF;

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

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;
656: END IF;
657: hr_utility.set_location(gv_package_name || '.select_employee', 130);

Line 666: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_header_string(

662:
663: lv_element_count := 0;
664:
665: lv_title := 'Element Information';
666: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_header_string(
667: lv_title
668: ,lv_output_file_type
669: ));
670:

Line 674: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');

670:
671: lv_element_info := 'Elements With Input Value of Type Money and Not Feeding Year End Balances';
672:
673: IF lv_output_file_type ='HTML' THEN
674: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
675: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
676: pay_us_payroll_utils.formated_data_string (p_input_string =>lv_element_info,
677: p_bold => 'N',
678: p_output_file_type => lv_output_file_type)||'

');

Line 675: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,

671: lv_element_info := 'Elements With Input Value of Type Money and Not Feeding Year End Balances';
672:
673: IF lv_output_file_type ='HTML' THEN
674: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
675: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
676: pay_us_payroll_utils.formated_data_string (p_input_string =>lv_element_info,
677: p_bold => 'N',
678: p_output_file_type => lv_output_file_type)||'

');
679: ELSE

Line 680: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,

676: pay_us_payroll_utils.formated_data_string (p_input_string =>lv_element_info,
677: p_bold => 'N',
678: p_output_file_type => lv_output_file_type)||'

');
679: ELSE
680: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
681: pay_us_payroll_utils.formated_data_string (p_input_string =>lv_element_info,
682: p_bold => 'N',
683: p_output_file_type => lv_output_file_type));
684: END IF;

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

699: -- Display Table for HTML and only for 1st record
700: IF lv_element_count = 0 THEN
701: IF lv_output_file_type ='HTML' THEN
702:
703: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
704: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
705: END IF;
706:
707: formated_element_header(lv_output_file_type

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

700: IF lv_element_count = 0 THEN
701: IF lv_output_file_type ='HTML' THEN
702:
703: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
704: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
705: END IF;
706:
707: formated_element_header(lv_output_file_type
708: ,lv_header_label);

Line 710: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label);

706:
707: formated_element_header(lv_output_file_type
708: ,lv_header_label);
709:
710: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label);
711: END IF;
712:
713: hr_utility.set_location(gv_package_name || '.select_employee', 150);
714:

Line 728: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_element_row);

724: IF lv_output_file_type ='HTML' THEN
725: lv_element_row := '

' || lv_element_row || '' ;
726: END IF;
727:
728: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_element_row);
729: END LOOP;
730: CLOSE c_get_elements;
731:
732: hr_utility.set_location(gv_package_name || '.select_employee', 160);

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

731:
732: hr_utility.set_location(gv_package_name || '.select_employee', 160);
733:
734: IF lv_output_file_type='HTML' and lv_element_count > 0 THEN
735: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
736: --ELSIF lv_element_count = 0 THEN
737:
738: -- hr_utility.set_location(gv_package_name || '.select_employee', 170);
739: END IF;

Line 747: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'

');

743: ,p_bold => 'N'
744: ,p_output_file_type => lv_output_file_type);
745:
746: IF lv_output_file_type='HTML' THEN
747: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'

');
748: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_element_count_info ||'

');
749: ELSE
750: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_element_count_info);
751: END IF;

Line 748: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_element_count_info ||'

');

744: ,p_output_file_type => lv_output_file_type);
745:
746: IF lv_output_file_type='HTML' THEN
747: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'

');
748: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_element_count_info ||'

');
749: ELSE
750: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_element_count_info);
751: END IF;
752: */

Line 750: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_element_count_info);

746: IF lv_output_file_type='HTML' THEN
747: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'

');
748: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_element_count_info ||'

');
749: ELSE
750: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_element_count_info);
751: END IF;
752: */
753:
754: hr_utility.set_location(gv_package_name || '.select_employee', 180);