DBA Data[Home] [Help]

APPS.PAY_US_GEOCODE_REPORT_PKG dependencies on FND_FILE

Line 381: fnd_file.put_line(fnd_file.output, formated_header_string(

377: ** Defined data set so that it is printed at the end of the
378: ** report.
379: ****************************************************************/
380:
381: fnd_file.put_line(fnd_file.output, formated_header_string(
382: 'THIS IS A LIST OF ASSIGNMENT INFORMATION FOR THE GEOCODE UPDATE QUARTERLY PATCH'
383: ,p_output_file_type
384: ));
385:

Line 386: fnd_file.put_line(fnd_file.output, formated_header_string(

382: 'THIS IS A LIST OF ASSIGNMENT INFORMATION FOR THE GEOCODE UPDATE QUARTERLY PATCH'
383: ,p_output_file_type
384: ));
385:
386: fnd_file.put_line(fnd_file.output, formated_header_string(
387: 'Please correct all the following situations(if needed) before running your next payroll'
388: ,p_output_file_type
389: ));
390:

Line 391: fnd_file.put_line(fnd_file.output, formated_header_string(

387: 'Please correct all the following situations(if needed) before running your next payroll'
388: ,p_output_file_type
389: ));
390:
391: fnd_file.put_line(fnd_file.output, formated_header_string(
392: 'I. Errored Employees'
393: ,p_output_file_type
394: ));
395:

Line 396: fnd_file.put_line(fnd_file.output, formated_header_string(

392: 'I. Errored Employees'
393: ,p_output_file_type
394: ));
395:
396: fnd_file.put_line(fnd_file.output, formated_header_string(
397: 'ACTION REQUIRED'
398: ,p_output_file_type
399: ));
400:

Line 401: fnd_file.put_line(fnd_file.output, formated_header_string(

397: 'ACTION REQUIRED'
398: ,p_output_file_type
399: ));
400:
401: fnd_file.put_line(fnd_file.output, formated_header_string(
402: 'WARNING!! Employees that have ERRORED during the upgrade process'
403: ,p_output_file_type
404: ));
405:

Line 406: fnd_file.put_line(fnd_file.output, formated_header_string(

402: 'WARNING!! Employees that have ERRORED during the upgrade process'
403: ,p_output_file_type
404: ));
405:
406: fnd_file.put_line(fnd_file.output, formated_header_string(
407: 'Please address these errors immediately as the patch will not complete succesfully'
408: ,p_output_file_type
409: ));
410:

Line 411: fnd_file.put_line(fnd_file.output, formated_header_string(

407: 'Please address these errors immediately as the patch will not complete succesfully'
408: ,p_output_file_type
409: ));
410:
411: fnd_file.put_line(fnd_file.output, formated_header_string(
412: ' until all the assignments are processed without error.'
413: ,p_output_file_type
414: ));
415:

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

420: ** the body and table before printing the header info, otherwise
421: ** just print the header information.
422: ****************************************************************/
423: if p_output_file_type ='HTML' then
424: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
425: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
426: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
427: end if;
428: hr_utility.set_location(gv_package_name || '.report_1', 15);

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

421: ** just print the header information.
422: ****************************************************************/
423: if p_output_file_type ='HTML' then
424: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
425: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
426: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
427: end if;
428: hr_utility.set_location(gv_package_name || '.report_1', 15);
429:

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

422: ****************************************************************/
423: if p_output_file_type ='HTML' then
424: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
425: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
426: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
427: end if;
428: hr_utility.set_location(gv_package_name || '.report_1', 15);
429:
430: lv_format1 :=

Line 450: fnd_file.put_line(fnd_file.output, lv_format1);

446:
447: hr_utility.set_location(gv_package_name || '.report_1', 20);
448:
449:
450: fnd_file.put_line(fnd_file.output, lv_format1);
451:
452: if p_output_file_type ='HTML' then
453: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
454: end if;

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

449:
450: fnd_file.put_line(fnd_file.output, lv_format1);
451:
452: if p_output_file_type ='HTML' then
453: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
454: end if;
455:
456: hr_utility.set_location(gv_package_name || '.report_1', 30);
457: /*****************************************************

Line 507: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

503: -- if p_output_file_type ='HTML' then
504: lv_data_row := '

' || lv_data_row || '' ;
505: -- end if;
506:
507: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
508:
509:
510: /*****************************************************************
511: ** initialize Data varaibles

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

518: ** Close of the Data Section of the Report
519: *****************************************************/
520:
521: if p_output_file_type ='HTML' then
522: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
523: end if;
524:
525: END report_1;
526:

Line 578: fnd_file.put_line(fnd_file.output, formated_header_string(

574: ** Defined data set so that it is printed at the end of the
575: ** report.
576: ****************************************************************/
577:
578: fnd_file.put_line(fnd_file.output, formated_header_string(
579: 'II. Incorrect percent in time.'
580: ,p_output_file_type
581: ));
582:

Line 583: fnd_file.put_line(fnd_file.output, formated_header_string(

579: 'II. Incorrect percent in time.'
580: ,p_output_file_type
581: ));
582:
583: fnd_file.put_line(fnd_file.output, formated_header_string(
584: 'ACTION REQUIRED'
585: ,p_output_file_type
586: ));
587:

Line 588: fnd_file.put_line(fnd_file.output, formated_header_string(

584: 'ACTION REQUIRED'
585: ,p_output_file_type
586: ));
587:
588: fnd_file.put_line(fnd_file.output, formated_header_string(
589: 'Employees whose sum of percent in time is greater then 100% at the local level.'
590: ,p_output_file_type
591: ));
592:

Line 593: fnd_file.put_line(fnd_file.output, formated_header_string(

589: 'Employees whose sum of percent in time is greater then 100% at the local level.'
590: ,p_output_file_type
591: ));
592:
593: fnd_file.put_line(fnd_file.output, formated_header_string(
594: 'Due to jurisdiction code upgrade, some cities may have exceeded 100% in time.'
595: ,p_output_file_type
596: ));
597:

Line 598: fnd_file.put_line(fnd_file.output, formated_header_string(

594: 'Due to jurisdiction code upgrade, some cities may have exceeded 100% in time.'
595: ,p_output_file_type
596: ));
597:
598: fnd_file.put_line(fnd_file.output, formated_header_string(
599: 'Please correct this at the W-4 Percentage screen by setting the percent in time for the city'
600: ,p_output_file_type
601: ));
602:

Line 603: fnd_file.put_line(fnd_file.output, formated_header_string(

599: 'Please correct this at the W-4 Percentage screen by setting the percent in time for the city'
600: ,p_output_file_type
601: ));
602:
603: fnd_file.put_line(fnd_file.output, formated_header_string(
604: '(or total of all the cities) to not exceed 100% time in total. '
605: ,p_output_file_type
606: ));
607:

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

611: ** the body and table before printing the header info, otherwise
612: ** just print the header information.
613: ****************************************************************/
614: if p_output_file_type ='HTML' then
615: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
616: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
617: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
618: end if;
619: hr_utility.set_location(gv_package_name || '.report_2', 20);

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

612: ** just print the header information.
613: ****************************************************************/
614: if p_output_file_type ='HTML' then
615: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
616: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
617: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
618: end if;
619: hr_utility.set_location(gv_package_name || '.report_2', 20);
620:

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

613: ****************************************************************/
614: if p_output_file_type ='HTML' then
615: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
616: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
617: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
618: end if;
619: hr_utility.set_location(gv_package_name || '.report_2', 20);
620:
621: lv_format1 :=

Line 636: fnd_file.put_line(fnd_file.output, lv_format1);

632:
633: hr_utility.set_location(gv_package_name || '.report_2', 30);
634:
635:
636: fnd_file.put_line(fnd_file.output, lv_format1);
637:
638: if p_output_file_type ='HTML' then
639: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
640: end if;

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

635:
636: fnd_file.put_line(fnd_file.output, lv_format1);
637:
638: if p_output_file_type ='HTML' then
639: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
640: end if;
641:
642: hr_utility.set_location(gv_package_name || '.report_2', 40);
643: /*****************************************************

Line 692: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

688: -- if p_output_file_type ='HTML' then
689: lv_data_row := '

' || lv_data_row || '' ;
690: -- end if;
691:
692: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
693:
694:
695: /*****************************************************************
696: ** initialize Data varaibles

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

703: ** Close of the Data Section of the Report
704: *****************************************************/
705:
706: if p_output_file_type ='HTML' then
707: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
708: end if;
709:
710: END report_2;
711:

Line 763: fnd_file.put_line(fnd_file.output, formated_header_string(

759: ** Defined data set so that it is printed at the end of the
760: ** report.
761: ****************************************************************/
762:
763: fnd_file.put_line(fnd_file.output, formated_header_string(
764: 'III. Missing county tax records.'
765: ,p_output_file_type
766: ));
767:

Line 768: fnd_file.put_line(fnd_file.output, formated_header_string(

764: 'III. Missing county tax records.'
765: ,p_output_file_type
766: ));
767:
768: fnd_file.put_line(fnd_file.output, formated_header_string(
769: 'ACTION REQUIRED'
770: ,p_output_file_type
771: ));
772:

Line 773: fnd_file.put_line(fnd_file.output, formated_header_string(

769: 'ACTION REQUIRED'
770: ,p_output_file_type
771: ));
772:
773: fnd_file.put_line(fnd_file.output, formated_header_string(
774: 'Employees who have missing county tax records.'
775: ,p_output_file_type
776: ));
777:

Line 778: fnd_file.put_line(fnd_file.output, formated_header_string(

774: 'Employees who have missing county tax records.'
775: ,p_output_file_type
776: ));
777:
778: fnd_file.put_line(fnd_file.output, formated_header_string(
779: 'Please correct this by creating a new county tax record from the W-4 form.'
780: ,p_output_file_type
781: ));
782:

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

786: ** the body and table before printing the header info, otherwise
787: ** just print the header information.
788: ****************************************************************/
789: if p_output_file_type ='HTML' then
790: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
791: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
792: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
793: end if;
794: hr_utility.set_location(gv_package_name || '.report_3', 20);

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

787: ** just print the header information.
788: ****************************************************************/
789: if p_output_file_type ='HTML' then
790: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
791: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
792: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
793: end if;
794: hr_utility.set_location(gv_package_name || '.report_3', 20);
795:

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

788: ****************************************************************/
789: if p_output_file_type ='HTML' then
790: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
791: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
792: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
793: end if;
794: hr_utility.set_location(gv_package_name || '.report_3', 20);
795:
796: lv_format1 :=

Line 812: fnd_file.put_line(fnd_file.output, lv_format1);

808:
809: hr_utility.set_location(gv_package_name || '.report_3', 30);
810:
811:
812: fnd_file.put_line(fnd_file.output, lv_format1);
813:
814: if p_output_file_type ='HTML' then
815: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
816: end if;

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

811:
812: fnd_file.put_line(fnd_file.output, lv_format1);
813:
814: if p_output_file_type ='HTML' then
815: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
816: end if;
817:
818: hr_utility.set_location(gv_package_name || '.report_3', 40);
819: /*****************************************************

Line 870: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

866: -- if p_output_file_type ='HTML' then
867: lv_data_row := '

' || lv_data_row || '' ;
868: -- end if;
869:
870: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
871:
872:
873: /*****************************************************************
874: ** initialize Data varaibles

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

881: ** Close of the Data Section of the Report
882: *****************************************************/
883:
884: if p_output_file_type ='HTML' then
885: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
886: end if;
887:
888: END report_3;
889:

Line 964: fnd_file.put_line(fnd_file.output, formated_header_string(

960: ** Defined data set so that it is printed at the end of the
961: ** report.
962: ****************************************************************/
963:
964: fnd_file.put_line(fnd_file.output, formated_header_string(
965: 'IV. Primary city becoming Secondary with jurisdiction code change'
966: ,p_output_file_type
967: ));
968:

Line 969: fnd_file.put_line(fnd_file.output, formated_header_string(

965: 'IV. Primary city becoming Secondary with jurisdiction code change'
966: ,p_output_file_type
967: ));
968:
969: fnd_file.put_line(fnd_file.output, formated_header_string(
970: 'NO ACTION IS REQUIRED. This is for information ONLY.'
971: ,p_output_file_type
972: ));
973:

Line 974: fnd_file.put_line(fnd_file.output, formated_header_string(

970: 'NO ACTION IS REQUIRED. This is for information ONLY.'
971: ,p_output_file_type
972: ));
973:
974: fnd_file.put_line(fnd_file.output, formated_header_string(
975: 'Employees who have records updated in the following tables because'
976: ,p_output_file_type
977: ));
978:

Line 979: fnd_file.put_line(fnd_file.output, formated_header_string(

975: 'Employees who have records updated in the following tables because'
976: ,p_output_file_type
977: ));
978:
979: fnd_file.put_line(fnd_file.output, formated_header_string(
980: 'a primary city has changed to a secondary city with a jurisdiction'
981: ,p_output_file_type
982: ));
983:

Line 984: fnd_file.put_line(fnd_file.output, formated_header_string(

980: 'a primary city has changed to a secondary city with a jurisdiction'
981: ,p_output_file_type
982: ));
983:
984: fnd_file.put_line(fnd_file.output, formated_header_string(
985: 'code change.'
986: ,p_output_file_type
987: ));
988:

Line 989: fnd_file.put_line(fnd_file.output, formated_header_string(

985: 'code change.'
986: ,p_output_file_type
987: ));
988:
989: fnd_file.put_line(fnd_file.output, formated_header_string(
990: 'The city displayed here is the NEW PRIMARY CITY for the assignment.'
991: ,p_output_file_type
992: ));
993:

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

997: ** the body and table before printing the header info, otherwise
998: ** just print the header information.
999: ****************************************************************/
1000: if p_output_file_type ='HTML' then
1001: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1002: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1003: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1004: end if;
1005: hr_utility.set_location(gv_package_name || '.report_4', 20);

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

998: ** just print the header information.
999: ****************************************************************/
1000: if p_output_file_type ='HTML' then
1001: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1002: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1003: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1004: end if;
1005: hr_utility.set_location(gv_package_name || '.report_4', 20);
1006:

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

999: ****************************************************************/
1000: if p_output_file_type ='HTML' then
1001: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1002: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1003: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1004: end if;
1005: hr_utility.set_location(gv_package_name || '.report_4', 20);
1006:
1007: lv_format1 :=

Line 1045: fnd_file.put_line(fnd_file.output, lv_format1);

1041:
1042: hr_utility.set_location(gv_package_name || '.report_4', 30);
1043:
1044:
1045: fnd_file.put_line(fnd_file.output, lv_format1);
1046:
1047: if p_output_file_type ='HTML' then
1048: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1049: end if;

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

1044:
1045: fnd_file.put_line(fnd_file.output, lv_format1);
1046:
1047: if p_output_file_type ='HTML' then
1048: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1049: end if;
1050:
1051: hr_utility.set_location(gv_package_name || '.report_4', 40);
1052: /*****************************************************

Line 1108: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

1104: -- if p_output_file_type ='HTML' then
1105: lv_data_row := '

' || lv_data_row || '' ;
1106: -- end if;
1107:
1108: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1109:
1110:
1111: /*****************************************************************
1112: ** initialize Data varaibles

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

1119: ** Close of the Data Section of the Report
1120: *****************************************************/
1121:
1122: if p_output_file_type ='HTML' then
1123: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1124: end if;
1125:
1126: END report_4;
1127:

Line 1195: fnd_file.put_line(fnd_file.output, formated_header_string(

1191: ** Defined data set so that it is printed at the end of the
1192: ** report.
1193: ****************************************************************/
1194:
1195: fnd_file.put_line(fnd_file.output, formated_header_string(
1196: 'V. Primary city jurisdiction code change.'
1197: ,p_output_file_type
1198: ));
1199:

Line 1200: fnd_file.put_line(fnd_file.output, formated_header_string(

1196: 'V. Primary city jurisdiction code change.'
1197: ,p_output_file_type
1198: ));
1199:
1200: fnd_file.put_line(fnd_file.output, formated_header_string(
1201: 'NO ACTION IS REQUIRED. This is for information ONLY.'
1202: ,p_output_file_type
1203: ));
1204:

Line 1205: fnd_file.put_line(fnd_file.output, formated_header_string(

1201: 'NO ACTION IS REQUIRED. This is for information ONLY.'
1202: ,p_output_file_type
1203: ));
1204:
1205: fnd_file.put_line(fnd_file.output, formated_header_string(
1206: 'Employees whose records have been updated in the following tables'
1207: ,p_output_file_type
1208: ));
1209:

Line 1210: fnd_file.put_line(fnd_file.output, formated_header_string(

1206: 'Employees whose records have been updated in the following tables'
1207: ,p_output_file_type
1208: ));
1209:
1210: fnd_file.put_line(fnd_file.output, formated_header_string(
1211: 'because a primary citys jurisdiction code has changed.'
1212: ,p_output_file_type
1213: ));
1214:

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

1218: ** the body and table before printing the header info, otherwise
1219: ** just print the header information.
1220: ****************************************************************/
1221: if p_output_file_type ='HTML' then
1222: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1223: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1224: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1225: end if;
1226: hr_utility.set_location(gv_package_name || '.report_5', 20);

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

1219: ** just print the header information.
1220: ****************************************************************/
1221: if p_output_file_type ='HTML' then
1222: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1223: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1224: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1225: end if;
1226: hr_utility.set_location(gv_package_name || '.report_5', 20);
1227:

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

1220: ****************************************************************/
1221: if p_output_file_type ='HTML' then
1222: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1223: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1224: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1225: end if;
1226: hr_utility.set_location(gv_package_name || '.report_5', 20);
1227:
1228: lv_format1 :=

Line 1262: fnd_file.put_line(fnd_file.output, lv_format1);

1258:
1259: hr_utility.set_location(gv_package_name || '.report_5', 30);
1260:
1261:
1262: fnd_file.put_line(fnd_file.output, lv_format1);
1263:
1264: if p_output_file_type ='HTML' then
1265: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1266: end if;

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

1261:
1262: fnd_file.put_line(fnd_file.output, lv_format1);
1263:
1264: if p_output_file_type ='HTML' then
1265: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1266: end if;
1267:
1268: hr_utility.set_location(gv_package_name || '.report_5', 40);
1269: /*****************************************************

Line 1324: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

1320: -- if p_output_file_type ='HTML' then
1321: lv_data_row := '

' || lv_data_row || '' ;
1322: -- end if;
1323:
1324: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1325:
1326:
1327: /*****************************************************************
1328: ** initialize Data varaibles

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

1335: ** Close of the Data Section of the Report
1336: *****************************************************/
1337:
1338: if p_output_file_type ='HTML' then
1339: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1340: end if;
1341:
1342: END report_5;
1343:

Line 1418: fnd_file.put_line(fnd_file.output, formated_header_string(

1414: ** Defined data set so that it is printed at the end of the
1415: ** report.
1416: ****************************************************************/
1417:
1418: fnd_file.put_line(fnd_file.output, formated_header_string(
1419: 'VI. Secondary jurisdiction code change.'
1420: ,p_output_file_type
1421: ));
1422:

Line 1423: fnd_file.put_line(fnd_file.output, formated_header_string(

1419: 'VI. Secondary jurisdiction code change.'
1420: ,p_output_file_type
1421: ));
1422:
1423: fnd_file.put_line(fnd_file.output, formated_header_string(
1424: 'ACTION REQUIRED'
1425: ,p_output_file_type
1426: ));
1427:

Line 1428: fnd_file.put_line(fnd_file.output, formated_header_string(

1424: 'ACTION REQUIRED'
1425: ,p_output_file_type
1426: ));
1427:
1428: fnd_file.put_line(fnd_file.output, formated_header_string(
1429: 'WARNING! Employees whose secondary city jurisdiction code has changed. Thus this means'
1430: ,p_output_file_type
1431: ));
1432:

Line 1433: fnd_file.put_line(fnd_file.output, formated_header_string(

1429: 'WARNING! Employees whose secondary city jurisdiction code has changed. Thus this means'
1430: ,p_output_file_type
1431: ));
1432:
1433: fnd_file.put_line(fnd_file.output, formated_header_string(
1434: 'the employees will have different or a new Primary City.'
1435: ,p_output_file_type
1436: ));
1437:

Line 1438: fnd_file.put_line(fnd_file.output, formated_header_string(

1434: 'the employees will have different or a new Primary City.'
1435: ,p_output_file_type
1436: ));
1437:
1438: fnd_file.put_line(fnd_file.output, formated_header_string(
1439: 'New city tax records and Vertex Element Entries have been created for'
1440: ,p_output_file_type
1441: ));
1442:

Line 1443: fnd_file.put_line(fnd_file.output, formated_header_string(

1439: 'New city tax records and Vertex Element Entries have been created for'
1440: ,p_output_file_type
1441: ));
1442:
1443: fnd_file.put_line(fnd_file.output, formated_header_string(
1444: 'these assignments with the new jurisdiction code.'
1445: ,p_output_file_type
1446: ));
1447:

Line 1448: fnd_file.put_line(fnd_file.output, formated_header_string(

1444: 'these assignments with the new jurisdiction code.'
1445: ,p_output_file_type
1446: ));
1447:
1448: fnd_file.put_line(fnd_file.output, formated_header_string(
1449: 'Please check the records of these employees and determine which CITY is to be the Primary City.'
1450: ,p_output_file_type
1451: ));
1452:

Line 1453: fnd_file.put_line(fnd_file.output, formated_header_string(

1449: 'Please check the records of these employees and determine which CITY is to be the Primary City.'
1450: ,p_output_file_type
1451: ));
1452:
1453: fnd_file.put_line(fnd_file.output, formated_header_string(
1454: 'Then, ensure that the percentages reflect the new primary city.'
1455: ,p_output_file_type
1456: ));
1457:

Line 1458: fnd_file.put_line(fnd_file.output, formated_header_string(

1454: 'Then, ensure that the percentages reflect the new primary city.'
1455: ,p_output_file_type
1456: ));
1457:
1458: fnd_file.put_line(fnd_file.output, formated_header_string(
1459: 'also ensure that the subject to balances are correct. Some manual balance adjustments'
1460: ,p_output_file_type
1461: ));
1462:

Line 1463: fnd_file.put_line(fnd_file.output, formated_header_string(

1459: 'also ensure that the subject to balances are correct. Some manual balance adjustments'
1460: ,p_output_file_type
1461: ));
1462:
1463: fnd_file.put_line(fnd_file.output, formated_header_string(
1464: 'may be required to reflect the new taxing jurisdictions of highlighted cities.'
1465: ,p_output_file_type
1466: ));
1467:

Line 1468: fnd_file.put_line(fnd_file.output, formated_header_string(

1464: 'may be required to reflect the new taxing jurisdictions of highlighted cities.'
1465: ,p_output_file_type
1466: ));
1467:
1468: fnd_file.put_line(fnd_file.output, formated_header_string(
1469: 'The resident city and work city listed reflects the location as of the day this patch is run.'
1470: ,p_output_file_type
1471: ));
1472:

Line 1473: fnd_file.put_line(fnd_file.output, formated_header_string(

1469: 'The resident city and work city listed reflects the location as of the day this patch is run.'
1470: ,p_output_file_type
1471: ));
1472:
1473: fnd_file.put_line(fnd_file.output, formated_header_string(
1474: 'NOTE : This only applies to those cities that have local level taxes. All other'
1475: ,p_output_file_type
1476: ));
1477:

Line 1478: fnd_file.put_line(fnd_file.output, formated_header_string(

1474: 'NOTE : This only applies to those cities that have local level taxes. All other'
1475: ,p_output_file_type
1476: ));
1477:
1478: fnd_file.put_line(fnd_file.output, formated_header_string(
1479: 'cities may be ignored and are listed for information only.'
1480: ,p_output_file_type
1481: ));
1482:

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

1486: ** the body and table before printing the header info, otherwise
1487: ** just print the header information.
1488: ****************************************************************/
1489: if p_output_file_type ='HTML' then
1490: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1491: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1492: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1493: end if;
1494: hr_utility.set_location(gv_package_name || '.report_6', 20);

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

1487: ** just print the header information.
1488: ****************************************************************/
1489: if p_output_file_type ='HTML' then
1490: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1491: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1492: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1493: end if;
1494: hr_utility.set_location(gv_package_name || '.report_6', 20);
1495:

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

1488: ****************************************************************/
1489: if p_output_file_type ='HTML' then
1490: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1491: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1492: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1493: end if;
1494: hr_utility.set_location(gv_package_name || '.report_6', 20);
1495:
1496: lv_format1 :=

Line 1534: fnd_file.put_line(fnd_file.output, lv_format1);

1530:
1531: hr_utility.set_location(gv_package_name || '.report_6', 30);
1532:
1533:
1534: fnd_file.put_line(fnd_file.output, lv_format1);
1535:
1536: if p_output_file_type ='HTML' then
1537: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1538: end if;

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

1533:
1534: fnd_file.put_line(fnd_file.output, lv_format1);
1535:
1536: if p_output_file_type ='HTML' then
1537: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1538: end if;
1539:
1540: hr_utility.set_location(gv_package_name || '.report_6', 40);
1541: /*****************************************************

Line 1596: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

1592: -- if p_output_file_type ='HTML' then
1593: lv_data_row := '

' || lv_data_row || '' ;
1594: -- end if;
1595:
1596: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1597:
1598:
1599: /*****************************************************************
1600: ** initialize Data varaibles

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

1607: ** Close of the Data Section of the Report
1608: *****************************************************/
1609:
1610: if p_output_file_type ='HTML' then
1611: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1612: end if;
1613:
1614: END report_6;
1615:

Line 1709: fnd_file.put_line(fnd_file.output, formated_header_string(

1705: ** Defined data set so that it is printed at the end of the
1706: ** report.
1707: ****************************************************************/
1708:
1709: fnd_file.put_line(fnd_file.output, formated_header_string(
1710: 'VII. Employees who have new Primary City.'
1711: ,p_output_file_type
1712: ));
1713:

Line 1714: fnd_file.put_line(fnd_file.output, formated_header_string(

1710: 'VII. Employees who have new Primary City.'
1711: ,p_output_file_type
1712: ));
1713:
1714: fnd_file.put_line(fnd_file.output, formated_header_string(
1715: 'NO ACTION IS REQUIRED. This is for information ONLY.'
1716: ,p_output_file_type
1717: ));
1718:

Line 1719: fnd_file.put_line(fnd_file.output, formated_header_string(

1715: 'NO ACTION IS REQUIRED. This is for information ONLY.'
1716: ,p_output_file_type
1717: ));
1718:
1719: fnd_file.put_line(fnd_file.output, formated_header_string(
1720: 'The jurisdction code has not changed thus the tax rates will stay the same.'
1721: ,p_output_file_type
1722: ));
1723:

Line 1724: fnd_file.put_line(fnd_file.output, formated_header_string(

1720: 'The jurisdction code has not changed thus the tax rates will stay the same.'
1721: ,p_output_file_type
1722: ));
1723:
1724: fnd_file.put_line(fnd_file.output, formated_header_string(
1725: 'the employees will have different or a new Primary City.'
1726: ,p_output_file_type
1727: ));
1728:

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

1733: ** the body and table before printing the header info, otherwise
1734: ** just print the header information.
1735: ****************************************************************/
1736: if p_output_file_type ='HTML' then
1737: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1738: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1739: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1740: end if;
1741: hr_utility.set_location(gv_package_name || '.report_7', 20);

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

1734: ** just print the header information.
1735: ****************************************************************/
1736: if p_output_file_type ='HTML' then
1737: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1738: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1739: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1740: end if;
1741: hr_utility.set_location(gv_package_name || '.report_7', 20);
1742:

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

1735: ****************************************************************/
1736: if p_output_file_type ='HTML' then
1737: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1738: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1739: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1740: end if;
1741: hr_utility.set_location(gv_package_name || '.report_7', 20);
1742:
1743: lv_format1 :=

Line 1760: fnd_file.put_line(fnd_file.output, lv_format1);

1756:
1757: hr_utility.set_location(gv_package_name || '.report_7', 30);
1758:
1759:
1760: fnd_file.put_line(fnd_file.output, lv_format1);
1761:
1762: if p_output_file_type ='HTML' then
1763: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1764: end if;

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

1759:
1760: fnd_file.put_line(fnd_file.output, lv_format1);
1761:
1762: if p_output_file_type ='HTML' then
1763: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1764: end if;
1765:
1766: hr_utility.set_location(gv_package_name || '.report_7', 40);
1767: /*****************************************************

Line 1816: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

1812: -- if p_output_file_type ='HTML' then
1813: lv_data_row := '

' || lv_data_row || '' ;
1814: -- end if;
1815:
1816: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1817:
1818:
1819: /*****************************************************************
1820: ** initialize Data varaibles

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

1827: ** Close of the Data Section of the Report
1828: *****************************************************/
1829:
1830: if p_output_file_type ='HTML' then
1831: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1832: end if;
1833:
1834: END report_7;
1835:

Line 1880: fnd_file.put_line(fnd_file.output, formated_header_string(

1876: ** Defined data set so that it is printed at the end of the
1877: ** report.
1878: ****************************************************************/
1879:
1880: fnd_file.put_line(fnd_file.output, formated_header_string(
1881: 'VIII. User Defined cities that are now supported by Vertex'
1882: ,p_output_file_type
1883: ));
1884:

Line 1885: fnd_file.put_line(fnd_file.output, formated_header_string(

1881: 'VIII. User Defined cities that are now supported by Vertex'
1882: ,p_output_file_type
1883: ));
1884:
1885: fnd_file.put_line(fnd_file.output, formated_header_string(
1886: 'NO ACTION IS REQUIRED. This is for information ONLY.'
1887: ,p_output_file_type
1888: ));
1889:

Line 1890: fnd_file.put_line(fnd_file.output, formated_header_string(

1886: 'NO ACTION IS REQUIRED. This is for information ONLY.'
1887: ,p_output_file_type
1888: ));
1889:
1890: fnd_file.put_line(fnd_file.output, formated_header_string(
1891: 'The following lists user defined cities that are now supported by Vertex.'
1892: ,p_output_file_type
1893: ));
1894:

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

1899: ** the body and table before printing the header info, otherwise
1900: ** just print the header information.
1901: ****************************************************************/
1902: if p_output_file_type ='HTML' then
1903: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1904: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1905: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1906: end if;
1907: hr_utility.set_location(gv_package_name || '.report_8', 20);

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

1900: ** just print the header information.
1901: ****************************************************************/
1902: if p_output_file_type ='HTML' then
1903: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1904: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1905: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1906: end if;
1907: hr_utility.set_location(gv_package_name || '.report_8', 20);
1908:

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

1901: ****************************************************************/
1902: if p_output_file_type ='HTML' then
1903: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1904: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1905: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1906: end if;
1907: hr_utility.set_location(gv_package_name || '.report_8', 20);
1908:
1909: lv_format1 :=

Line 1926: fnd_file.put_line(fnd_file.output, lv_format1);

1922:
1923: hr_utility.set_location(gv_package_name || '.report_8', 30);
1924:
1925:
1926: fnd_file.put_line(fnd_file.output, lv_format1);
1927:
1928: if p_output_file_type ='HTML' then
1929: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1930: end if;

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

1925:
1926: fnd_file.put_line(fnd_file.output, lv_format1);
1927:
1928: if p_output_file_type ='HTML' then
1929: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1930: end if;
1931:
1932: hr_utility.set_location(gv_package_name || '.report_8', 40);
1933: /*****************************************************

Line 1982: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

1978: -- if p_output_file_type ='HTML' then
1979: lv_data_row := '

' || lv_data_row || '' ;
1980: -- end if;
1981:
1982: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1983:
1984:
1985: /*****************************************************************
1986: ** initialize Data varaibles

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

1993: ** Close of the Data Section of the Report
1994: *****************************************************/
1995:
1996: if p_output_file_type ='HTML' then
1997: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1998: end if;
1999:
2000: END report_8;
2001:

Line 2068: fnd_file.put_line(fnd_file.output, formated_header_string(

2064: ** Defined data set so that it is printed at the end of the
2065: ** report.
2066: ****************************************************************/
2067:
2068: fnd_file.put_line(fnd_file.output, formated_header_string(
2069: 'IX. Summary of employees for whom new city tax records have been created'
2070: ,p_output_file_type
2071: ));
2072:

Line 2073: fnd_file.put_line(fnd_file.output, formated_header_string(

2069: 'IX. Summary of employees for whom new city tax records have been created'
2070: ,p_output_file_type
2071: ));
2072:
2073: fnd_file.put_line(fnd_file.output, formated_header_string(
2074: 'NO ACTION IS REQUIRED. This is for information ONLY.'
2075: ,p_output_file_type
2076: ));
2077:

Line 2078: fnd_file.put_line(fnd_file.output, formated_header_string(

2074: 'NO ACTION IS REQUIRED. This is for information ONLY.'
2075: ,p_output_file_type
2076: ));
2077:
2078: fnd_file.put_line(fnd_file.output, formated_header_string(
2079: 'Please ensure that for these assignments, the tax records are as expected and the percent'
2080: ,p_output_file_type
2081: ));
2082:

Line 2083: fnd_file.put_line(fnd_file.output, formated_header_string(

2079: 'Please ensure that for these assignments, the tax records are as expected and the percent'
2080: ,p_output_file_type
2081: ));
2082:
2083: fnd_file.put_line(fnd_file.output, formated_header_string(
2084: 'of time spent in each city is correct. These names may be duplicated from above.'
2085: ,p_output_file_type
2086: ));
2087:

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

2092: ** the body and table before printing the header info, otherwise
2093: ** just print the header information.
2094: ****************************************************************/
2095: if p_output_file_type ='HTML' then
2096: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2097: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2098: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2099: end if;
2100: hr_utility.set_location(gv_package_name || '.report_9', 20);

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

2093: ** just print the header information.
2094: ****************************************************************/
2095: if p_output_file_type ='HTML' then
2096: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2097: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2098: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2099: end if;
2100: hr_utility.set_location(gv_package_name || '.report_9', 20);
2101:

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

2094: ****************************************************************/
2095: if p_output_file_type ='HTML' then
2096: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2097: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2098: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2099: end if;
2100: hr_utility.set_location(gv_package_name || '.report_9', 20);
2101:
2102: lv_format1 :=

Line 2126: fnd_file.put_line(fnd_file.output, lv_format1);

2122:
2123: hr_utility.set_location(gv_package_name || '.report_9', 30);
2124:
2125:
2126: fnd_file.put_line(fnd_file.output, lv_format1);
2127:
2128: if p_output_file_type ='HTML' then
2129: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2130: end if;

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

2125:
2126: fnd_file.put_line(fnd_file.output, lv_format1);
2127:
2128: if p_output_file_type ='HTML' then
2129: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2130: end if;
2131:
2132: hr_utility.set_location(gv_package_name || '.report_9', 40);
2133: /*****************************************************

Line 2186: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

2182: -- if p_output_file_type ='HTML' then
2183: lv_data_row := '

' || lv_data_row || '' ;
2184: -- end if;
2185:
2186: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
2187:
2188:
2189: /*****************************************************************
2190: ** initialize Data varaibles

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

2197: ** Close of the Data Section of the Report
2198: *****************************************************/
2199:
2200: if p_output_file_type ='HTML' then
2201: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2202: end if;
2203:
2204: END report_9;
2205:

Line 2273: fnd_file.put_line(fnd_file.output, formated_header_string(

2269: ** Defined data set so that it is printed at the end of the
2270: ** report.
2271: ****************************************************************/
2272:
2273: fnd_file.put_line(fnd_file.output, formated_header_string(
2274: 'X. Summary of employees for whom new Vertex Element Entry records have been created'
2275: ,p_output_file_type
2276: ));
2277:

Line 2278: fnd_file.put_line(fnd_file.output, formated_header_string(

2274: 'X. Summary of employees for whom new Vertex Element Entry records have been created'
2275: ,p_output_file_type
2276: ));
2277:
2278: fnd_file.put_line(fnd_file.output, formated_header_string(
2279: 'NO ACTION IS REQUIRED. This is for information ONLY.'
2280: ,p_output_file_type
2281: ));
2282:

Line 2283: fnd_file.put_line(fnd_file.output, formated_header_string(

2279: 'NO ACTION IS REQUIRED. This is for information ONLY.'
2280: ,p_output_file_type
2281: ));
2282:
2283: fnd_file.put_line(fnd_file.output, formated_header_string(
2284: 'Please ensure that for these assignments, the tax records are as expected and the percent'
2285: ,p_output_file_type
2286: ));
2287:

Line 2288: fnd_file.put_line(fnd_file.output, formated_header_string(

2284: 'Please ensure that for these assignments, the tax records are as expected and the percent'
2285: ,p_output_file_type
2286: ));
2287:
2288: fnd_file.put_line(fnd_file.output, formated_header_string(
2289: 'of time spent in each city is correct and the sum of percent of time spent in all states equals 100.'
2290: ,p_output_file_type
2291: ));
2292:

Line 2293: fnd_file.put_line(fnd_file.output, formated_header_string(

2289: 'of time spent in each city is correct and the sum of percent of time spent in all states equals 100.'
2290: ,p_output_file_type
2291: ));
2292:
2293: fnd_file.put_line(fnd_file.output, formated_header_string(
2294: 'These names may be duplicated from above. They are listed just for a reference.'
2295: ,p_output_file_type
2296: ));
2297:

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

2302: ** the body and table before printing the header info, otherwise
2303: ** just print the header information.
2304: ****************************************************************/
2305: if p_output_file_type ='HTML' then
2306: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2307: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2308: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2309: end if;
2310: hr_utility.set_location(gv_package_name || '.report_10', 20);

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

2303: ** just print the header information.
2304: ****************************************************************/
2305: if p_output_file_type ='HTML' then
2306: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2307: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2308: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2309: end if;
2310: hr_utility.set_location(gv_package_name || '.report_10', 20);
2311:

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

2304: ****************************************************************/
2305: if p_output_file_type ='HTML' then
2306: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2307: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2308: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2309: end if;
2310: hr_utility.set_location(gv_package_name || '.report_10', 20);
2311:
2312: lv_format1 :=

Line 2336: fnd_file.put_line(fnd_file.output, lv_format1);

2332:
2333: hr_utility.set_location(gv_package_name || '.report_10', 30);
2334:
2335:
2336: fnd_file.put_line(fnd_file.output, lv_format1);
2337:
2338: if p_output_file_type ='HTML' then
2339: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2340: end if;

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

2335:
2336: fnd_file.put_line(fnd_file.output, lv_format1);
2337:
2338: if p_output_file_type ='HTML' then
2339: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2340: end if;
2341:
2342: hr_utility.set_location(gv_package_name || '.report_10', 40);
2343: /*****************************************************

Line 2396: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

2392: -- if p_output_file_type ='HTML' then
2393: lv_data_row := '

' || lv_data_row || '' ;
2394: -- end if;
2395:
2396: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
2397:
2398:
2399: /*****************************************************************
2400: ** initialize Data varaibles

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

2407: ** Close of the Data Section of the Report
2408: *****************************************************/
2409:
2410: if p_output_file_type ='HTML' then
2411: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2412: end if;
2413:
2414: END report_10;
2415:

Line 2464: fnd_file.put_line(fnd_file.output, formated_header_string(

2460: ** Defined data set so that it is printed at the end of the
2461: ** report.
2462: ****************************************************************/
2463:
2464: fnd_file.put_line(fnd_file.output, formated_header_string(
2465: 'XI. New taxability rules.'
2466: ,p_output_file_type
2467: ));
2468:

Line 2469: fnd_file.put_line(fnd_file.output, formated_header_string(

2465: 'XI. New taxability rules.'
2466: ,p_output_file_type
2467: ));
2468:
2469: fnd_file.put_line(fnd_file.output, formated_header_string(
2470: 'The taxability rules have been changed for the following jurisdiction codes to reflect the new jurisdiction code.'
2471: ,p_output_file_type
2472: ));
2473:

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

2477: ** the body and table before printing the header info, otherwise
2478: ** just print the header information.
2479: ****************************************************************/
2480: if p_output_file_type ='HTML' then
2481: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2482: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2483: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2484: end if;
2485: hr_utility.set_location(gv_package_name || '.report_11', 20);

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

2478: ** just print the header information.
2479: ****************************************************************/
2480: if p_output_file_type ='HTML' then
2481: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2482: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2483: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2484: end if;
2485: hr_utility.set_location(gv_package_name || '.report_11', 20);
2486:

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

2479: ****************************************************************/
2480: if p_output_file_type ='HTML' then
2481: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2482: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2483: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2484: end if;
2485: hr_utility.set_location(gv_package_name || '.report_11', 20);
2486:
2487: lv_format1 :=

Line 2500: fnd_file.put_line(fnd_file.output, lv_format1);

2496:
2497: hr_utility.set_location(gv_package_name || '.report_11', 30);
2498:
2499:
2500: fnd_file.put_line(fnd_file.output, lv_format1);
2501:
2502: if p_output_file_type ='HTML' then
2503: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2504: end if;

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

2499:
2500: fnd_file.put_line(fnd_file.output, lv_format1);
2501:
2502: if p_output_file_type ='HTML' then
2503: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2504: end if;
2505:
2506: hr_utility.set_location(gv_package_name || '.report_11', 40);
2507: /*****************************************************

Line 2555: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

2551: -- if p_output_file_type ='HTML' then
2552: lv_data_row := '

' || lv_data_row || '' ;
2553: -- end if;
2554:
2555: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
2556:
2557:
2558: /*****************************************************************
2559: ** initialize Data varaibles

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

2566: ** Close of the Data Section of the Report
2567: *****************************************************/
2568:
2569: if p_output_file_type ='HTML' then
2570: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2571: end if;
2572:
2573: END report_11;
2574:

Line 2650: fnd_file.put_line(fnd_file.output, formated_header_string(

2646: ** Defined data set so that it is printed at the end of the
2647: ** report.
2648: ****************************************************************/
2649:
2650: fnd_file.put_line(fnd_file.output, formated_header_string(
2651: 'XII. County Code Change. '
2652: ,p_output_file_type
2653: ));
2654:

Line 2655: fnd_file.put_line(fnd_file.output, formated_header_string(

2651: 'XII. County Code Change. '
2652: ,p_output_file_type
2653: ));
2654:
2655: fnd_file.put_line(fnd_file.output, formated_header_string(
2656: 'ACTION REQUIRED.'
2657: ,p_output_file_type
2658: ));
2659:

Line 2660: fnd_file.put_line(fnd_file.output, formated_header_string(

2656: 'ACTION REQUIRED.'
2657: ,p_output_file_type
2658: ));
2659:
2660: fnd_file.put_line(fnd_file.output, formated_header_string(
2661: 'The following assignments are located in jurisdictions which are '
2662: ,p_output_file_type
2663: ));
2664:

Line 2665: fnd_file.put_line(fnd_file.output, formated_header_string(

2661: 'The following assignments are located in jurisdictions which are '
2662: ,p_output_file_type
2663: ));
2664:
2665: fnd_file.put_line(fnd_file.output, formated_header_string(
2666: 'changing their county codes. You must update the jurisdiction information'
2667: ,p_output_file_type
2668: ));
2669:

Line 2670: fnd_file.put_line(fnd_file.output, formated_header_string(

2666: 'changing their county codes. You must update the jurisdiction information'
2667: ,p_output_file_type
2668: ));
2669:
2670: fnd_file.put_line(fnd_file.output, formated_header_string(
2671: 'for these assignments as Vertex will discontinue support for the'
2672: ,p_output_file_type
2673: ));
2674:

Line 2675: fnd_file.put_line(fnd_file.output, formated_header_string(

2671: 'for these assignments as Vertex will discontinue support for the'
2672: ,p_output_file_type
2673: ));
2674:
2675: fnd_file.put_line(fnd_file.output, formated_header_string(
2676: 'old jurisdictions in upcoming data files and taxes will stop being withheld'
2677: ,p_output_file_type
2678: ));
2679:

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

2684: ** the body and table before printing the header info, otherwise
2685: ** just print the header information.
2686: ****************************************************************/
2687: if p_output_file_type ='HTML' then
2688: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2689: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2690: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2691: end if;
2692: hr_utility.set_location(gv_package_name || '.report_12', 20);

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

2685: ** just print the header information.
2686: ****************************************************************/
2687: if p_output_file_type ='HTML' then
2688: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2689: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2690: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2691: end if;
2692: hr_utility.set_location(gv_package_name || '.report_12', 20);
2693:

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

2686: ****************************************************************/
2687: if p_output_file_type ='HTML' then
2688: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2689: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2690: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2691: end if;
2692: hr_utility.set_location(gv_package_name || '.report_12', 20);
2693:
2694: lv_format1 :=

Line 2730: fnd_file.put_line(fnd_file.output, lv_format1);

2726:
2727: hr_utility.set_location(gv_package_name || '.report_12', 30);
2728:
2729:
2730: fnd_file.put_line(fnd_file.output, lv_format1);
2731:
2732: if p_output_file_type ='HTML' then
2733: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2734: end if;

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

2729:
2730: fnd_file.put_line(fnd_file.output, lv_format1);
2731:
2732: if p_output_file_type ='HTML' then
2733: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2734: end if;
2735:
2736: hr_utility.set_location(gv_package_name || '.report_12', 40);
2737: /*****************************************************

Line 2793: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

2789: -- if p_output_file_type ='HTML' then
2790: lv_data_row := '

' || lv_data_row || '' ;
2791: -- end if;
2792:
2793: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
2794:
2795:
2796: /*****************************************************************
2797: ** initialize Data varaibles

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

2804: ** Close of the Data Section of the Report
2805: *****************************************************/
2806:
2807: if p_output_file_type ='HTML' then
2808: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2809: end if;
2810:
2811: END report_12;
2812:

Line 2841: fnd_file.put_line(fnd_file.output, formated_header_string(

2837: ** Defined data set so that it is printed at the end of the
2838: ** report.
2839: ****************************************************************/
2840:
2841: fnd_file.put_line(fnd_file.output, formated_header_string(
2842: 'XIII. Table Row Counts. '
2843: ,p_output_file_type
2844: ));
2845:

Line 2846: fnd_file.put_line(fnd_file.output, formated_header_string(

2842: 'XIII. Table Row Counts. '
2843: ,p_output_file_type
2844: ));
2845:
2846: fnd_file.put_line(fnd_file.output, formated_header_string(
2847: 'NO ACTION IS REQUIRED. This is for information ONLY.'
2848: ,p_output_file_type
2849: ));
2850:

Line 2851: fnd_file.put_line(fnd_file.output, formated_header_string(

2847: 'NO ACTION IS REQUIRED. This is for information ONLY.'
2848: ,p_output_file_type
2849: ));
2850:
2851: fnd_file.put_line(fnd_file.output, formated_header_string(
2852: 'The following tables were updated and now have the following row counts:'
2853: ,p_output_file_type
2854: ));
2855:

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

2860: ** the body and table before printing the header info, otherwise
2861: ** just print the header information.
2862: ****************************************************************/
2863: if p_output_file_type ='HTML' then
2864: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2865: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2866: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2867: end if;
2868: hr_utility.set_location(gv_package_name || '.report_13', 20);

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

2861: ** just print the header information.
2862: ****************************************************************/
2863: if p_output_file_type ='HTML' then
2864: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2865: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2866: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2867: end if;
2868: hr_utility.set_location(gv_package_name || '.report_13', 20);
2869:

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

2862: ****************************************************************/
2863: if p_output_file_type ='HTML' then
2864: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2865: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2866: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2867: end if;
2868: hr_utility.set_location(gv_package_name || '.report_13', 20);
2869:
2870: lv_format1 :=

Line 2883: fnd_file.put_line(fnd_file.output, lv_format1);

2879:
2880: hr_utility.set_location(gv_package_name || '.report_13', 30);
2881:
2882:
2883: fnd_file.put_line(fnd_file.output, lv_format1);
2884:
2885: if p_output_file_type ='HTML' then
2886: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2887: end if;

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

2882:
2883: fnd_file.put_line(fnd_file.output, lv_format1);
2884:
2885: if p_output_file_type ='HTML' then
2886: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2887: end if;
2888:
2889: hr_utility.set_location(gv_package_name || '.report_13', 40);
2890: /*****************************************************

Line 2930: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

2926: hr_utility.set_location(gv_package_name || '.report_13', 65);
2927:
2928: lv_data_row := '

' || lv_data_row || '' ;
2929:
2930: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
2931:
2932: -- count for pay_us_counties --
2933:
2934: ln_row_count := 0;

Line 2958: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

2954: hr_utility.set_location(gv_package_name || '.report_13', 70);
2955:
2956: lv_data_row := '

' || lv_data_row || '' ;
2957:
2958: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
2959:
2960: -- count for pay_us_city_geocodes --
2961:
2962: ln_row_count := 0;

Line 2985: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

2981: hr_utility.set_location(gv_package_name || '.report_13', 75);
2982:
2983: lv_data_row := '

' || lv_data_row || '' ;
2984:
2985: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
2986:
2987: -- count for pay_us_city_names --
2988:
2989: ln_row_count := 0;

Line 3012: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

3008: hr_utility.set_location(gv_package_name || '.report_13', 80);
3009:
3010: lv_data_row := '

' || lv_data_row || '' ;
3011:
3012: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
3013:
3014: -- count for pay_us_zip_codes --
3015:
3016: ln_row_count := 0;

Line 3039: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

3035: hr_utility.set_location(gv_package_name || '.report_13', 85);
3036:
3037: lv_data_row := '

' || lv_data_row || '' ;
3038:
3039: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
3040:
3041: -- count for pay_us_modified_geocodes --
3042:
3043: ln_row_count := 0;

Line 3066: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

3062: hr_utility.set_location(gv_package_name || '.report_13', 90);
3063:
3064: lv_data_row := '

' || lv_data_row || '' ;
3065:
3066: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
3067: /*****************************************************************
3068: ** initialize Data varaibles
3069: *****************************************************************/
3070: lv_data_row := null;

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

3074: ** Close of the Data Section of the Report
3075: *****************************************************/
3076:
3077: if p_output_file_type ='HTML' then
3078: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3079: end if;
3080:
3081: END report_13;
3082:

Line 3209: fnd_file.put_line(fnd_file.output, formated_header_string(

3205: ** Defined data set so that it is printed at the end of the
3206: ** report.
3207: ****************************************************************/
3208:
3209: fnd_file.put_line(fnd_file.output, formated_header_string(
3210: 'XIV. Work Location ZIP Code Support.'
3211: ,p_output_file_type
3212: ));
3213:

Line 3214: fnd_file.put_line(fnd_file.output, formated_header_string(

3210: 'XIV. Work Location ZIP Code Support.'
3211: ,p_output_file_type
3212: ));
3213:
3214: fnd_file.put_line(fnd_file.output, formated_header_string(
3215: 'ACTION REQUIRED.'
3216: ,p_output_file_type
3217: ));
3218:

Line 3219: fnd_file.put_line(fnd_file.output, formated_header_string(

3215: 'ACTION REQUIRED.'
3216: ,p_output_file_type
3217: ));
3218:
3219: fnd_file.put_line(fnd_file.output, formated_header_string(
3220: 'The following work locations are using ZIP Codes no longer '
3221: ,p_output_file_type
3222: ));
3223:

Line 3224: fnd_file.put_line(fnd_file.output, formated_header_string(

3220: 'The following work locations are using ZIP Codes no longer '
3221: ,p_output_file_type
3222: ));
3223:
3224: fnd_file.put_line(fnd_file.output, formated_header_string(
3225: 'supported by Vertex. Please review these locations and adjust'
3226: ,p_output_file_type
3227: ));
3228:

Line 3229: fnd_file.put_line(fnd_file.output, formated_header_string(

3225: 'supported by Vertex. Please review these locations and adjust'
3226: ,p_output_file_type
3227: ));
3228:
3229: fnd_file.put_line(fnd_file.output, formated_header_string(
3230: 'Their ZIP Codes to supported values.'
3231: ,p_output_file_type
3232: ));
3233:

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

3238: ** the body and table before printing the header info, otherwise
3239: ** just print the header information.
3240: ****************************************************************/
3241: if p_output_file_type ='HTML' then
3242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3244: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3245: end if;
3246: hr_utility.set_location(gv_package_name || '.report_14', 20);

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

3239: ** just print the header information.
3240: ****************************************************************/
3241: if p_output_file_type ='HTML' then
3242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
3244: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3245: end if;
3246: hr_utility.set_location(gv_package_name || '.report_14', 20);
3247:

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

3240: ****************************************************************/
3241: if p_output_file_type ='HTML' then
3242: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3243: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
3244: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3245: end if;
3246: hr_utility.set_location(gv_package_name || '.report_14', 20);
3247:
3248: lv_format1 :=

Line 3281: fnd_file.put_line(fnd_file.output, lv_format1);

3277:
3278: hr_utility.set_location(gv_package_name || '.report_14', 30);
3279:
3280:
3281: fnd_file.put_line(fnd_file.output, lv_format1);
3282:
3283: if p_output_file_type ='HTML' then
3284: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
3285: end if;

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

3280:
3281: fnd_file.put_line(fnd_file.output, lv_format1);
3282:
3283: if p_output_file_type ='HTML' then
3284: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3285: end if;
3286:
3287: hr_utility.set_location(gv_package_name || '.report_14', 40);
3288: /*****************************************************

Line 3341: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

3337: -- if p_output_file_type ='HTML' then
3338: lv_data_row := '

' || lv_data_row || '' ;
3339: -- end if;
3340:
3341: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
3342:
3343:
3344: /*****************************************************************
3345: ** initialize Data varaibles

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

3352: ** Close of the Data Section of the Report
3353: *****************************************************/
3354:
3355: if p_output_file_type ='HTML' then
3356: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3357: end if;
3358:
3359: END report_14;
3360:

Line 3487: fnd_file.put_line(fnd_file.output, formated_header_string(

3483: ** Defined data set so that it is printed at the end of the
3484: ** report.
3485: ****************************************************************/
3486:
3487: fnd_file.put_line(fnd_file.output, formated_header_string(
3488: 'XV. Home Address ZIP Code Support.'
3489: ,p_output_file_type
3490: ));
3491:

Line 3492: fnd_file.put_line(fnd_file.output, formated_header_string(

3488: 'XV. Home Address ZIP Code Support.'
3489: ,p_output_file_type
3490: ));
3491:
3492: fnd_file.put_line(fnd_file.output, formated_header_string(
3493: 'ACTION REQUIRED.'
3494: ,p_output_file_type
3495: ));
3496:

Line 3497: fnd_file.put_line(fnd_file.output, formated_header_string(

3493: 'ACTION REQUIRED.'
3494: ,p_output_file_type
3495: ));
3496:
3497: fnd_file.put_line(fnd_file.output, formated_header_string(
3498: 'The following home addresses are using ZIP Codes no longer '
3499: ,p_output_file_type
3500: ));
3501:

Line 3502: fnd_file.put_line(fnd_file.output, formated_header_string(

3498: 'The following home addresses are using ZIP Codes no longer '
3499: ,p_output_file_type
3500: ));
3501:
3502: fnd_file.put_line(fnd_file.output, formated_header_string(
3503: 'supported by Vertex. Please review these addresses and adjust'
3504: ,p_output_file_type
3505: ));
3506:

Line 3507: fnd_file.put_line(fnd_file.output, formated_header_string(

3503: 'supported by Vertex. Please review these addresses and adjust'
3504: ,p_output_file_type
3505: ));
3506:
3507: fnd_file.put_line(fnd_file.output, formated_header_string(
3508: 'their ZIP Codes to supported values.'
3509: ,p_output_file_type
3510: ));
3511:

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

3516: ** the body and table before printing the header info, otherwise
3517: ** just print the header information.
3518: ****************************************************************/
3519: if p_output_file_type ='HTML' then
3520: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3521: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3522: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3523: end if;
3524: hr_utility.set_location(gv_package_name || '.report_15', 20);

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

3517: ** just print the header information.
3518: ****************************************************************/
3519: if p_output_file_type ='HTML' then
3520: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3521: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
3522: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3523: end if;
3524: hr_utility.set_location(gv_package_name || '.report_15', 20);
3525:

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

3518: ****************************************************************/
3519: if p_output_file_type ='HTML' then
3520: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3521: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
3522: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3523: end if;
3524: hr_utility.set_location(gv_package_name || '.report_15', 20);
3525:
3526: lv_format1 :=

Line 3555: fnd_file.put_line(fnd_file.output, lv_format1);

3551:
3552: hr_utility.set_location(gv_package_name || '.report_15', 30);
3553:
3554:
3555: fnd_file.put_line(fnd_file.output, lv_format1);
3556:
3557: if p_output_file_type ='HTML' then
3558: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
3559: end if;

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

3554:
3555: fnd_file.put_line(fnd_file.output, lv_format1);
3556:
3557: if p_output_file_type ='HTML' then
3558: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3559: end if;
3560:
3561: hr_utility.set_location(gv_package_name || '.report_15', 40);
3562: /*****************************************************

Line 3614: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

3610: -- if p_output_file_type ='HTML' then
3611: lv_data_row := '

' || lv_data_row || '' ;
3612: -- end if;
3613:
3614: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
3615:
3616:
3617: /*****************************************************************
3618: ** initialize Data varaibles

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

3625: ** Close of the Data Section of the Report
3626: *****************************************************/
3627:
3628: if p_output_file_type ='HTML' then
3629: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3630: end if;
3631:
3632: END report_15;
3633: