DBA Data[Home] [Help]

APPS.PAY_YEPP_MISS_ASSIGN_PKG dependencies on FND_FILE

Line 199: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,

195: null;
196: lvc_message := 'No person was picked up based on selection parameters.' ||
197: ' The YEPP Archive for the GRE has no missing assignments.';
198: hr_utility.set_location(gv_package_name || '.formated_zero_count', 10);
199: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
200: pay_us_payroll_utils.formated_data_string (p_input_string => lvc_message
201: ,p_bold => 'N'
202: ,p_output_file_type => output_file_type));
203: hr_utility.set_location(gv_package_name || '.formated_zero_count', 20);

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

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

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

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

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

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, '');
689:
690: COMMIT;
691: END IF;

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

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

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

696:
697: lv_element_count := 0;
698:
699: lv_title := 'Element Information';
700: FND_FILE.PUT_LINE(fnd_file.output,pay_us_payroll_utils.formated_header_string(
701: lv_title
702: ,lv_output_file_type
703: ));
704:

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

');

705: lv_element_info := 'Elements which have an Input Value of Type Money' ||
706: ' and are Not Feeding Year End Balances';
707:
708: IF lv_output_file_type ='HTML' THEN
709: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
710: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
711: pay_us_payroll_utils.formated_data_string (p_input_string =>lv_element_info,
712: p_bold => 'N',
713: p_output_file_type => lv_output_file_type)||'

');

Line 710: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,

706: ' and are Not Feeding Year End Balances';
707:
708: IF lv_output_file_type ='HTML' THEN
709: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
710: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
711: pay_us_payroll_utils.formated_data_string (p_input_string =>lv_element_info,
712: p_bold => 'N',
713: p_output_file_type => lv_output_file_type)||'

');
714: ELSE

Line 715: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,

711: pay_us_payroll_utils.formated_data_string (p_input_string =>lv_element_info,
712: p_bold => 'N',
713: p_output_file_type => lv_output_file_type)||'

');
714: ELSE
715: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,
716: pay_us_payroll_utils.formated_data_string (p_input_string =>lv_element_info,
717: p_bold => 'N',
718: p_output_file_type => lv_output_file_type));
719: END IF;

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

733: -- Display Table for HTML and only for 1st record
734: IF lv_element_count = 0 THEN
735: IF lv_output_file_type ='HTML' THEN
736:
737: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
738: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
739: END IF;
740:
741: formated_element_header(lv_output_file_type

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

734: IF lv_element_count = 0 THEN
735: IF lv_output_file_type ='HTML' THEN
736:
737: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
738: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
739: END IF;
740:
741: formated_element_header(lv_output_file_type
742: ,lv_header_label);

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

740:
741: formated_element_header(lv_output_file_type
742: ,lv_header_label);
743:
744: FND_FILE.PUT_LINE(fnd_file.output, lv_header_label);
745: END IF;
746:
747: hr_utility.set_location(gv_package_name || '.select_employee', 150);
748:

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

757: IF lv_output_file_type ='HTML' THEN
758: lv_element_row := '

' || lv_element_row || '' ;
759: END IF;
760:
761: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_element_row);
762: END LOOP;
763: CLOSE c_get_elements;
764:
765: hr_utility.set_location(gv_package_name || '.select_employee', 160);

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

764:
765: hr_utility.set_location(gv_package_name || '.select_employee', 160);
766:
767: IF lv_output_file_type='HTML' and lv_element_count > 0 THEN
768: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
769: --ELSIF lv_element_count = 0 THEN
770:
771: -- hr_utility.set_location(gv_package_name || '.select_employee', 170);
772: END IF;

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

');

776: ,p_bold => 'N'
777: ,p_output_file_type => lv_output_file_type);
778:
779: IF lv_output_file_type='HTML' THEN
780: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'

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

');
782: ELSE
783: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_element_count_info);
784: END IF;

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

');

777: ,p_output_file_type => lv_output_file_type);
778:
779: IF lv_output_file_type='HTML' THEN
780: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'

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

');
782: ELSE
783: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_element_count_info);
784: END IF;
785:

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

779: IF lv_output_file_type='HTML' THEN
780: FND_FILE.PUT_LINE(FND_FILE.OUTPUT,'

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

');
782: ELSE
783: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_element_count_info);
784: END IF;
785:
786:
787: hr_utility.set_location(gv_package_name || '.select_employee', 180);