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:
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:
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:
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:
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:
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:
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:
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, '
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, '
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:
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:
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:
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:
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:
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:
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, '
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, '
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:
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:
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:
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:
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, '
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, '
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:
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:
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:
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:
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:
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:
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, '
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, '
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:
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:
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:
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:
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, '
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, '
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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:
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, '
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, '
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:
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:
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:
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:
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, '
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, '
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:
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:
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:
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, '
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, '
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:
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:
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:
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:
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, '
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, '
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:
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:
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:
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:
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:
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, '
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, '
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:
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:
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, '
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, '
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:
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:
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:
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:
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:
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:
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, '
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, '
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:
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:
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:
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, '
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, '
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:
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:
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:
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:
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:
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, '
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, '
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:
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:
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:
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:
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:
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, '
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, '