eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_GEOCODE_REPORT_PKG dependencies on FND_FILE

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

741: ** Defined data set so that it is printed at the end of the
742: ** report.
743: ****************************************************************/
744:
745: fnd_file.put_line(fnd_file.output, formated_header_string(
746: 'THIS IS A LIST OF ASSIGNMENT INFORMATION FOR THE GEOCODE UPDATE QUARTERLY PATCH'
747: ,p_output_file_type
748: ));
749:

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

746: 'THIS IS A LIST OF ASSIGNMENT INFORMATION FOR THE GEOCODE UPDATE QUARTERLY PATCH'
747: ,p_output_file_type
748: ));
749:
750: fnd_file.put_line(fnd_file.output, formated_header_string(
751: 'Please correct all the following situations(if needed) before running your next payroll'
752: ,p_output_file_type
753: ));
754:

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

751: 'Please correct all the following situations(if needed) before running your next payroll'
752: ,p_output_file_type
753: ));
754:
755: fnd_file.put_line(fnd_file.output, formated_header_string(
756: 'I. Errored Employees'
757: ,p_output_file_type
758: ));
759:

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

756: 'I. Errored Employees'
757: ,p_output_file_type
758: ));
759:
760: fnd_file.put_line(fnd_file.output, formated_header_string(
761: 'ACTION REQUIRED'
762: ,p_output_file_type
763: ));
764:

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

761: 'ACTION REQUIRED'
762: ,p_output_file_type
763: ));
764:
765: fnd_file.put_line(fnd_file.output, formated_header_string(
766: 'WARNING!! Employees that have ERRORED during the upgrade process'
767: ,p_output_file_type
768: ));
769:

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

766: 'WARNING!! Employees that have ERRORED during the upgrade process'
767: ,p_output_file_type
768: ));
769:
770: fnd_file.put_line(fnd_file.output, formated_header_string(
771: 'Please address these errors immediately as the patch will not complete succesfully'
772: ,p_output_file_type
773: ));
774:

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

771: 'Please address these errors immediately as the patch will not complete succesfully'
772: ,p_output_file_type
773: ));
774:
775: fnd_file.put_line(fnd_file.output, formated_header_string(
776: ' until all the assignments are processed without error.'
777: ,p_output_file_type
778: ));
779:

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

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

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

');
790: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
791: end if;
792: hr_utility.set_location(gv_package_name || '.report_1', 15);
793:
Line 790: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
786: ****************************************************************/
787: if p_output_file_type ='HTML' then
788: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
789: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
790: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
791: end if;
792: hr_utility.set_location(gv_package_name || '.report_1', 15);
793:
794: lv_format1 :=
Line 814: fnd_file.put_line(fnd_file.output, lv_format1);

810:
811: hr_utility.set_location(gv_package_name || '.report_1', 20);
812:
813:
814: fnd_file.put_line(fnd_file.output, lv_format1);
815:
816: if p_output_file_type ='HTML' then
817: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
818: end if;
Line 817: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

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

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

867: -- if p_output_file_type ='HTML' then
868: lv_data_row := '
' || lv_data_row || '' ;
869: -- end if;
870:
871: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
872:
873:
874: /*****************************************************************
875: ** initialize Data varaibles
Line 886: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');

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

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

938: ** Defined data set so that it is printed at the end of the
939: ** report.
940: ****************************************************************/
941:
942: fnd_file.put_line(fnd_file.output, formated_header_string(
943: 'II. Incorrect percent in time.'
944: ,p_output_file_type
945: ));
946:

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

943: 'II. Incorrect percent in time.'
944: ,p_output_file_type
945: ));
946:
947: fnd_file.put_line(fnd_file.output, formated_header_string(
948: 'ACTION REQUIRED'
949: ,p_output_file_type
950: ));
951:

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

948: 'ACTION REQUIRED'
949: ,p_output_file_type
950: ));
951:
952: fnd_file.put_line(fnd_file.output, formated_header_string(
953: 'Employees whose sum of percent in time is greater then 100% at the local level.'
954: ,p_output_file_type
955: ));
956:

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

953: 'Employees whose sum of percent in time is greater then 100% at the local level.'
954: ,p_output_file_type
955: ));
956:
957: fnd_file.put_line(fnd_file.output, formated_header_string(
958: 'Due to jurisdiction code upgrade, some cities may have exceeded 100% in time.'
959: ,p_output_file_type
960: ));
961:

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

958: 'Due to jurisdiction code upgrade, some cities may have exceeded 100% in time.'
959: ,p_output_file_type
960: ));
961:
962: fnd_file.put_line(fnd_file.output, formated_header_string(
963: 'Please correct this at the W-4 Percentage screen by setting the percent in time for the city'
964: ,p_output_file_type
965: ));
966:

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

963: 'Please correct this at the W-4 Percentage screen by setting the percent in time for the city'
964: ,p_output_file_type
965: ));
966:
967: fnd_file.put_line(fnd_file.output, formated_header_string(
968: '(or total of all the cities) to not exceed 100% time in total. '
969: ,p_output_file_type
970: ));
971:

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

975: ** the body and table before printing the header info, otherwise
976: ** just print the header information.
977: ****************************************************************/
978: if p_output_file_type ='HTML' then
979: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
980: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
981: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
982: end if;
983: hr_utility.set_location(gv_package_name || '.report_2', 20);
Line 980: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
976: ** just print the header information.
977: ****************************************************************/
978: if p_output_file_type ='HTML' then
979: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
980: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
981: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
982: end if;
983: hr_utility.set_location(gv_package_name || '.report_2', 20);
984:
Line 981: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
977: ****************************************************************/
978: if p_output_file_type ='HTML' then
979: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
980: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
981: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
982: end if;
983: hr_utility.set_location(gv_package_name || '.report_2', 20);
984:
985: lv_format1 :=
Line 1000: fnd_file.put_line(fnd_file.output, lv_format1);

996:
997: hr_utility.set_location(gv_package_name || '.report_2', 30);
998:
999:
1000: fnd_file.put_line(fnd_file.output, lv_format1);
1001:
1002: if p_output_file_type ='HTML' then
1003: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1004: end if;
Line 1003: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

999:
1000: fnd_file.put_line(fnd_file.output, lv_format1);
1001:
1002: if p_output_file_type ='HTML' then
1003: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1004: end if;
1005:
1006: hr_utility.set_location(gv_package_name || '.report_2', 40);
1007: /*****************************************************

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

1052: -- if p_output_file_type ='HTML' then
1053: lv_data_row := '
' || lv_data_row || '' ;
1054: -- end if;
1055:
1056: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1057:
1058:
1059: /*****************************************************************
1060: ** initialize Data varaibles
Line 1071: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');

1067: ** Close of the Data Section of the Report
1068: *****************************************************/
1069:
1070: if p_output_file_type ='HTML' then
1071: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1072: end if;
1073:
1074: END report_2;
1075:

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

1123: ** Defined data set so that it is printed at the end of the
1124: ** report.
1125: ****************************************************************/
1126:
1127: fnd_file.put_line(fnd_file.output, formated_header_string(
1128: 'III. Missing county tax records.'
1129: ,p_output_file_type
1130: ));
1131:

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

1128: 'III. Missing county tax records.'
1129: ,p_output_file_type
1130: ));
1131:
1132: fnd_file.put_line(fnd_file.output, formated_header_string(
1133: 'ACTION REQUIRED'
1134: ,p_output_file_type
1135: ));
1136:

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

1133: 'ACTION REQUIRED'
1134: ,p_output_file_type
1135: ));
1136:
1137: fnd_file.put_line(fnd_file.output, formated_header_string(
1138: 'Employees who have missing county tax records.'
1139: ,p_output_file_type
1140: ));
1141:

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

1138: 'Employees who have missing county tax records.'
1139: ,p_output_file_type
1140: ));
1141:
1142: fnd_file.put_line(fnd_file.output, formated_header_string(
1143: 'Please correct this by creating a new county tax record from the W-4 form.'
1144: ,p_output_file_type
1145: ));
1146:

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

1150: ** the body and table before printing the header info, otherwise
1151: ** just print the header information.
1152: ****************************************************************/
1153: if p_output_file_type ='HTML' then
1154: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1155: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1156: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1157: end if;
1158: hr_utility.set_location(gv_package_name || '.report_3', 20);
Line 1155: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1151: ** just print the header information.
1152: ****************************************************************/
1153: if p_output_file_type ='HTML' then
1154: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1155: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1156: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1157: end if;
1158: hr_utility.set_location(gv_package_name || '.report_3', 20);
1159:
Line 1156: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1152: ****************************************************************/
1153: if p_output_file_type ='HTML' then
1154: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1155: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1156: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1157: end if;
1158: hr_utility.set_location(gv_package_name || '.report_3', 20);
1159:
1160: lv_format1 :=
Line 1176: fnd_file.put_line(fnd_file.output, lv_format1);

1172:
1173: hr_utility.set_location(gv_package_name || '.report_3', 30);
1174:
1175:
1176: fnd_file.put_line(fnd_file.output, lv_format1);
1177:
1178: if p_output_file_type ='HTML' then
1179: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1180: end if;
Line 1179: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

1175:
1176: fnd_file.put_line(fnd_file.output, lv_format1);
1177:
1178: if p_output_file_type ='HTML' then
1179: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1180: end if;
1181:
1182: hr_utility.set_location(gv_package_name || '.report_3', 40);
1183: /*****************************************************

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

1230: -- if p_output_file_type ='HTML' then
1231: lv_data_row := '
' || lv_data_row || '' ;
1232: -- end if;
1233:
1234: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1235:
1236:
1237: /*****************************************************************
1238: ** initialize Data varaibles
Line 1249: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');

1245: ** Close of the Data Section of the Report
1246: *****************************************************/
1247:
1248: if p_output_file_type ='HTML' then
1249: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1250: end if;
1251:
1252: END report_3;
1253:

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

1324: ** Defined data set so that it is printed at the end of the
1325: ** report.
1326: ****************************************************************/
1327:
1328: fnd_file.put_line(fnd_file.output, formated_header_string(
1329: 'IV. Primary city becoming Secondary with jurisdiction code change'
1330: ,p_output_file_type
1331: ));
1332:

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

1329: 'IV. Primary city becoming Secondary with jurisdiction code change'
1330: ,p_output_file_type
1331: ));
1332:
1333: fnd_file.put_line(fnd_file.output, formated_header_string(
1334: 'NO ACTION IS REQUIRED. This is for information ONLY.'
1335: ,p_output_file_type
1336: ));
1337:

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

1334: 'NO ACTION IS REQUIRED. This is for information ONLY.'
1335: ,p_output_file_type
1336: ));
1337:
1338: fnd_file.put_line(fnd_file.output, formated_header_string(
1339: 'Employees who have records updated in the following tables because'
1340: ,p_output_file_type
1341: ));
1342:

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

1339: 'Employees who have records updated in the following tables because'
1340: ,p_output_file_type
1341: ));
1342:
1343: fnd_file.put_line(fnd_file.output, formated_header_string(
1344: 'a primary city has changed to a secondary city with a jurisdiction'
1345: ,p_output_file_type
1346: ));
1347:

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

1344: 'a primary city has changed to a secondary city with a jurisdiction'
1345: ,p_output_file_type
1346: ));
1347:
1348: fnd_file.put_line(fnd_file.output, formated_header_string(
1349: 'code change.'
1350: ,p_output_file_type
1351: ));
1352:

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

1349: 'code change.'
1350: ,p_output_file_type
1351: ));
1352:
1353: fnd_file.put_line(fnd_file.output, formated_header_string(
1354: 'The city displayed here is the NEW PRIMARY CITY for the assignment.'
1355: ,p_output_file_type
1356: ));
1357:

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

1361: ** the body and table before printing the header info, otherwise
1362: ** just print the header information.
1363: ****************************************************************/
1364: if p_output_file_type ='HTML' then
1365: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1366: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1367: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1368: end if;
1369: hr_utility.set_location(gv_package_name || '.report_4', 20);
Line 1366: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1362: ** just print the header information.
1363: ****************************************************************/
1364: if p_output_file_type ='HTML' then
1365: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1366: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1367: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1368: end if;
1369: hr_utility.set_location(gv_package_name || '.report_4', 20);
1370:
Line 1367: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1363: ****************************************************************/
1364: if p_output_file_type ='HTML' then
1365: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1366: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1367: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1368: end if;
1369: hr_utility.set_location(gv_package_name || '.report_4', 20);
1370:
1371: lv_format1 :=
Line 1409: fnd_file.put_line(fnd_file.output, lv_format1);

1405:
1406: hr_utility.set_location(gv_package_name || '.report_4', 30);
1407:
1408:
1409: fnd_file.put_line(fnd_file.output, lv_format1);
1410:
1411: if p_output_file_type ='HTML' then
1412: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1413: end if;
Line 1412: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

1408:
1409: fnd_file.put_line(fnd_file.output, lv_format1);
1410:
1411: if p_output_file_type ='HTML' then
1412: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1413: end if;
1414:
1415: hr_utility.set_location(gv_package_name || '.report_4', 40);
1416: /*****************************************************

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

1468: -- if p_output_file_type ='HTML' then
1469: lv_data_row := '
' || lv_data_row || '' ;
1470: -- end if;
1471:
1472: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1473:
1474:
1475: /*****************************************************************
1476: ** initialize Data varaibles
Line 1487: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');

1483: ** Close of the Data Section of the Report
1484: *****************************************************/
1485:
1486: if p_output_file_type ='HTML' then
1487: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1488: end if;
1489:
1490: END report_4;
1491:

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

1555: ** Defined data set so that it is printed at the end of the
1556: ** report.
1557: ****************************************************************/
1558:
1559: fnd_file.put_line(fnd_file.output, formated_header_string(
1560: 'V. Primary city jurisdiction code change.'
1561: ,p_output_file_type
1562: ));
1563:

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

1560: 'V. Primary city jurisdiction code change.'
1561: ,p_output_file_type
1562: ));
1563:
1564: fnd_file.put_line(fnd_file.output, formated_header_string(
1565: 'NO ACTION IS REQUIRED. This is for information ONLY.'
1566: ,p_output_file_type
1567: ));
1568:

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

1565: 'NO ACTION IS REQUIRED. This is for information ONLY.'
1566: ,p_output_file_type
1567: ));
1568:
1569: fnd_file.put_line(fnd_file.output, formated_header_string(
1570: 'Employees whose records have been updated in the following tables'
1571: ,p_output_file_type
1572: ));
1573:

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

1570: 'Employees whose records have been updated in the following tables'
1571: ,p_output_file_type
1572: ));
1573:
1574: fnd_file.put_line(fnd_file.output, formated_header_string(
1575: 'because a primary citys jurisdiction code has changed.'
1576: ,p_output_file_type
1577: ));
1578:

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

1582: ** the body and table before printing the header info, otherwise
1583: ** just print the header information.
1584: ****************************************************************/
1585: if p_output_file_type ='HTML' then
1586: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1587: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1588: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1589: end if;
1590: hr_utility.set_location(gv_package_name || '.report_5', 20);
Line 1587: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1583: ** just print the header information.
1584: ****************************************************************/
1585: if p_output_file_type ='HTML' then
1586: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1587: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1588: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1589: end if;
1590: hr_utility.set_location(gv_package_name || '.report_5', 20);
1591:
Line 1588: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1584: ****************************************************************/
1585: if p_output_file_type ='HTML' then
1586: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1587: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1588: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1589: end if;
1590: hr_utility.set_location(gv_package_name || '.report_5', 20);
1591:
1592: lv_format1 :=
Line 1626: fnd_file.put_line(fnd_file.output, lv_format1);

1622:
1623: hr_utility.set_location(gv_package_name || '.report_5', 30);
1624:
1625:
1626: fnd_file.put_line(fnd_file.output, lv_format1);
1627:
1628: if p_output_file_type ='HTML' then
1629: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1630: end if;
Line 1629: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

1625:
1626: fnd_file.put_line(fnd_file.output, lv_format1);
1627:
1628: if p_output_file_type ='HTML' then
1629: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1630: end if;
1631:
1632: hr_utility.set_location(gv_package_name || '.report_5', 40);
1633: /*****************************************************

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

1684: -- if p_output_file_type ='HTML' then
1685: lv_data_row := '
' || lv_data_row || '' ;
1686: -- end if;
1687:
1688: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1689:
1690:
1691: /*****************************************************************
1692: ** initialize Data varaibles
Line 1703: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');

1699: ** Close of the Data Section of the Report
1700: *****************************************************/
1701:
1702: if p_output_file_type ='HTML' then
1703: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1704: end if;
1705:
1706: END report_5;
1707:

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

1778: ** Defined data set so that it is printed at the end of the
1779: ** report.
1780: ****************************************************************/
1781:
1782: fnd_file.put_line(fnd_file.output, formated_header_string(
1783: 'VI. Secondary jurisdiction code change.'
1784: ,p_output_file_type
1785: ));
1786:

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

1783: 'VI. Secondary jurisdiction code change.'
1784: ,p_output_file_type
1785: ));
1786:
1787: fnd_file.put_line(fnd_file.output, formated_header_string(
1788: 'ACTION REQUIRED'
1789: ,p_output_file_type
1790: ));
1791:

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

1788: 'ACTION REQUIRED'
1789: ,p_output_file_type
1790: ));
1791:
1792: fnd_file.put_line(fnd_file.output, formated_header_string(
1793: 'WARNING! Employees whose secondary city jurisdiction code has changed. Thus this means'
1794: ,p_output_file_type
1795: ));
1796:

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

1793: 'WARNING! Employees whose secondary city jurisdiction code has changed. Thus this means'
1794: ,p_output_file_type
1795: ));
1796:
1797: fnd_file.put_line(fnd_file.output, formated_header_string(
1798: 'the employees will have different or a new Primary City.'
1799: ,p_output_file_type
1800: ));
1801:

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

1798: 'the employees will have different or a new Primary City.'
1799: ,p_output_file_type
1800: ));
1801:
1802: fnd_file.put_line(fnd_file.output, formated_header_string(
1803: 'New city tax records and Vertex Element Entries have been created for'
1804: ,p_output_file_type
1805: ));
1806:

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

1803: 'New city tax records and Vertex Element Entries have been created for'
1804: ,p_output_file_type
1805: ));
1806:
1807: fnd_file.put_line(fnd_file.output, formated_header_string(
1808: 'these assignments with the new jurisdiction code.'
1809: ,p_output_file_type
1810: ));
1811:

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

1808: 'these assignments with the new jurisdiction code.'
1809: ,p_output_file_type
1810: ));
1811:
1812: fnd_file.put_line(fnd_file.output, formated_header_string(
1813: 'Please check the records of these employees and determine which CITY is to be the Primary City.'
1814: ,p_output_file_type
1815: ));
1816:

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

1813: 'Please check the records of these employees and determine which CITY is to be the Primary City.'
1814: ,p_output_file_type
1815: ));
1816:
1817: fnd_file.put_line(fnd_file.output, formated_header_string(
1818: 'Then, ensure that the percentages reflect the new primary city.'
1819: ,p_output_file_type
1820: ));
1821:

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

1818: 'Then, ensure that the percentages reflect the new primary city.'
1819: ,p_output_file_type
1820: ));
1821:
1822: fnd_file.put_line(fnd_file.output, formated_header_string(
1823: 'also ensure that the subject to balances are correct. Some manual balance adjustments'
1824: ,p_output_file_type
1825: ));
1826:

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

1823: 'also ensure that the subject to balances are correct. Some manual balance adjustments'
1824: ,p_output_file_type
1825: ));
1826:
1827: fnd_file.put_line(fnd_file.output, formated_header_string(
1828: 'may be required to reflect the new taxing jurisdictions of highlighted cities.'
1829: ,p_output_file_type
1830: ));
1831:

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

1828: 'may be required to reflect the new taxing jurisdictions of highlighted cities.'
1829: ,p_output_file_type
1830: ));
1831:
1832: fnd_file.put_line(fnd_file.output, formated_header_string(
1833: 'The resident city and work city listed reflects the location as of the day this patch is run.'
1834: ,p_output_file_type
1835: ));
1836:

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

1833: 'The resident city and work city listed reflects the location as of the day this patch is run.'
1834: ,p_output_file_type
1835: ));
1836:
1837: fnd_file.put_line(fnd_file.output, formated_header_string(
1838: 'NOTE : This only applies to those cities that have local level taxes. All other'
1839: ,p_output_file_type
1840: ));
1841:

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

1838: 'NOTE : This only applies to those cities that have local level taxes. All other'
1839: ,p_output_file_type
1840: ));
1841:
1842: fnd_file.put_line(fnd_file.output, formated_header_string(
1843: 'cities may be ignored and are listed for information only.'
1844: ,p_output_file_type
1845: ));
1846:

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

1850: ** the body and table before printing the header info, otherwise
1851: ** just print the header information.
1852: ****************************************************************/
1853: if p_output_file_type ='HTML' then
1854: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1855: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1856: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1857: end if;
1858: hr_utility.set_location(gv_package_name || '.report_6', 20);
Line 1855: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1851: ** just print the header information.
1852: ****************************************************************/
1853: if p_output_file_type ='HTML' then
1854: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1855: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1856: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1857: end if;
1858: hr_utility.set_location(gv_package_name || '.report_6', 20);
1859:
Line 1856: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1852: ****************************************************************/
1853: if p_output_file_type ='HTML' then
1854: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1855: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
1856: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1857: end if;
1858: hr_utility.set_location(gv_package_name || '.report_6', 20);
1859:
1860: lv_format1 :=
Line 1898: fnd_file.put_line(fnd_file.output, lv_format1);

1894:
1895: hr_utility.set_location(gv_package_name || '.report_6', 30);
1896:
1897:
1898: fnd_file.put_line(fnd_file.output, lv_format1);
1899:
1900: if p_output_file_type ='HTML' then
1901: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
1902: end if;
Line 1901: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

1897:
1898: fnd_file.put_line(fnd_file.output, lv_format1);
1899:
1900: if p_output_file_type ='HTML' then
1901: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1902: end if;
1903:
1904: hr_utility.set_location(gv_package_name || '.report_6', 40);
1905: /*****************************************************

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

1956: -- if p_output_file_type ='HTML' then
1957: lv_data_row := '
' || lv_data_row || '' ;
1958: -- end if;
1959:
1960: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
1961:
1962:
1963: /*****************************************************************
1964: ** initialize Data varaibles
Line 1975: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');

1971: ** Close of the Data Section of the Report
1972: *****************************************************/
1973:
1974: if p_output_file_type ='HTML' then
1975: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
1976: end if;
1977:
1978: END report_6;
1979:

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

2067: ** Defined data set so that it is printed at the end of the
2068: ** report.
2069: ****************************************************************/
2070:
2071: fnd_file.put_line(fnd_file.output, formated_header_string(
2072: 'VII. Employees who have new Primary City.'
2073: ,p_output_file_type
2074: ));
2075:

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

2072: 'VII. Employees who have new Primary City.'
2073: ,p_output_file_type
2074: ));
2075:
2076: fnd_file.put_line(fnd_file.output, formated_header_string(
2077: 'NO ACTION IS REQUIRED. This is for information ONLY.'
2078: ,p_output_file_type
2079: ));
2080:

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

2077: 'NO ACTION IS REQUIRED. This is for information ONLY.'
2078: ,p_output_file_type
2079: ));
2080:
2081: fnd_file.put_line(fnd_file.output, formated_header_string(
2082: 'The jurisdction code has not changed thus the tax rates will stay the same.'
2083: ,p_output_file_type
2084: ));
2085:

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

2082: 'The jurisdction code has not changed thus the tax rates will stay the same.'
2083: ,p_output_file_type
2084: ));
2085:
2086: fnd_file.put_line(fnd_file.output, formated_header_string(
2087: 'the employees will have different or a new Primary City.'
2088: ,p_output_file_type
2089: ));
2090:

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

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

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

');
2101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2102: end if;
2103: hr_utility.set_location(gv_package_name || '.report_7', 20);
2104:
Line 2101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
2097: ****************************************************************/
2098: if p_output_file_type ='HTML' then
2099: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2100: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2101: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2102: end if;
2103: hr_utility.set_location(gv_package_name || '.report_7', 20);
2104:
2105: lv_format1 :=
Line 2122: fnd_file.put_line(fnd_file.output, lv_format1);

2118:
2119: hr_utility.set_location(gv_package_name || '.report_7', 30);
2120:
2121:
2122: fnd_file.put_line(fnd_file.output, lv_format1);
2123:
2124: if p_output_file_type ='HTML' then
2125: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
2126: end if;
Line 2125: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

2121:
2122: fnd_file.put_line(fnd_file.output, lv_format1);
2123:
2124: if p_output_file_type ='HTML' then
2125: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2126: end if;
2127:
2128: hr_utility.set_location(gv_package_name || '.report_7', 40);
2129: /*****************************************************

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

2174: -- if p_output_file_type ='HTML' then
2175: lv_data_row := '
' || lv_data_row || '' ;
2176: -- end if;
2177:
2178: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
2179:
2180:
2181: /*****************************************************************
2182: ** initialize Data varaibles
Line 2193: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');

2189: ** Close of the Data Section of the Report
2190: *****************************************************/
2191:
2192: if p_output_file_type ='HTML' then
2193: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2194: end if;
2195:
2196: END report_7;
2197:

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

2238: ** Defined data set so that it is printed at the end of the
2239: ** report.
2240: ****************************************************************/
2241:
2242: fnd_file.put_line(fnd_file.output, formated_header_string(
2243: 'VIII. User Defined cities that are now supported by Vertex'
2244: ,p_output_file_type
2245: ));
2246:

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

2243: 'VIII. User Defined cities that are now supported by Vertex'
2244: ,p_output_file_type
2245: ));
2246:
2247: fnd_file.put_line(fnd_file.output, formated_header_string(
2248: 'NO ACTION IS REQUIRED. This is for information ONLY.'
2249: ,p_output_file_type
2250: ));
2251:

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

2248: 'NO ACTION IS REQUIRED. This is for information ONLY.'
2249: ,p_output_file_type
2250: ));
2251:
2252: fnd_file.put_line(fnd_file.output, formated_header_string(
2253: 'The following lists user defined cities that are now supported by Vertex.'
2254: ,p_output_file_type
2255: ));
2256:

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

2261: ** the body and table before printing the header info, otherwise
2262: ** just print the header information.
2263: ****************************************************************/
2264: if p_output_file_type ='HTML' then
2265: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2266: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2268: end if;
2269: hr_utility.set_location(gv_package_name || '.report_8', 20);
Line 2266: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2262: ** just print the header information.
2263: ****************************************************************/
2264: if p_output_file_type ='HTML' then
2265: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2266: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2268: end if;
2269: hr_utility.set_location(gv_package_name || '.report_8', 20);
2270:
Line 2267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
2263: ****************************************************************/
2264: if p_output_file_type ='HTML' then
2265: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2266: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2267: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2268: end if;
2269: hr_utility.set_location(gv_package_name || '.report_8', 20);
2270:
2271: lv_format1 :=
Line 2288: fnd_file.put_line(fnd_file.output, lv_format1);

2284:
2285: hr_utility.set_location(gv_package_name || '.report_8', 30);
2286:
2287:
2288: fnd_file.put_line(fnd_file.output, lv_format1);
2289:
2290: if p_output_file_type ='HTML' then
2291: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
2292: end if;
Line 2291: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

2287:
2288: fnd_file.put_line(fnd_file.output, lv_format1);
2289:
2290: if p_output_file_type ='HTML' then
2291: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2292: end if;
2293:
2294: hr_utility.set_location(gv_package_name || '.report_8', 40);
2295: /*****************************************************

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

2340: -- if p_output_file_type ='HTML' then
2341: lv_data_row := '
' || lv_data_row || '' ;
2342: -- end if;
2343:
2344: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
2345:
2346:
2347: /*****************************************************************
2348: ** initialize Data varaibles
Line 2359: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');

2355: ** Close of the Data Section of the Report
2356: *****************************************************/
2357:
2358: if p_output_file_type ='HTML' then
2359: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2360: end if;
2361:
2362: END report_8;
2363:

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

2426: ** Defined data set so that it is printed at the end of the
2427: ** report.
2428: ****************************************************************/
2429:
2430: fnd_file.put_line(fnd_file.output, formated_header_string(
2431: 'IX. Summary of employees for whom new city tax records have been created'
2432: ,p_output_file_type
2433: ));
2434:

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

2431: 'IX. Summary of employees for whom new city tax records have been created'
2432: ,p_output_file_type
2433: ));
2434:
2435: fnd_file.put_line(fnd_file.output, formated_header_string(
2436: 'NO ACTION IS REQUIRED. This is for information ONLY.'
2437: ,p_output_file_type
2438: ));
2439:

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

2436: 'NO ACTION IS REQUIRED. This is for information ONLY.'
2437: ,p_output_file_type
2438: ));
2439:
2440: fnd_file.put_line(fnd_file.output, formated_header_string(
2441: 'Please ensure that for these assignments, the tax records are as expected and the percent'
2442: ,p_output_file_type
2443: ));
2444:

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

2441: 'Please ensure that for these assignments, the tax records are as expected and the percent'
2442: ,p_output_file_type
2443: ));
2444:
2445: fnd_file.put_line(fnd_file.output, formated_header_string(
2446: 'of time spent in each city is correct. These names may be duplicated from above.'
2447: ,p_output_file_type
2448: ));
2449:

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

2454: ** the body and table before printing the header info, otherwise
2455: ** just print the header information.
2456: ****************************************************************/
2457: if p_output_file_type ='HTML' then
2458: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2459: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2460: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2461: end if;
2462: hr_utility.set_location(gv_package_name || '.report_9', 20);
Line 2459: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2455: ** just print the header information.
2456: ****************************************************************/
2457: if p_output_file_type ='HTML' then
2458: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2459: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2460: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2461: end if;
2462: hr_utility.set_location(gv_package_name || '.report_9', 20);
2463:
Line 2460: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
2456: ****************************************************************/
2457: if p_output_file_type ='HTML' then
2458: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2459: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2460: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2461: end if;
2462: hr_utility.set_location(gv_package_name || '.report_9', 20);
2463:
2464: lv_format1 :=
Line 2488: fnd_file.put_line(fnd_file.output, lv_format1);

2484:
2485: hr_utility.set_location(gv_package_name || '.report_9', 30);
2486:
2487:
2488: fnd_file.put_line(fnd_file.output, lv_format1);
2489:
2490: if p_output_file_type ='HTML' then
2491: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
2492: end if;
Line 2491: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

2487:
2488: fnd_file.put_line(fnd_file.output, lv_format1);
2489:
2490: if p_output_file_type ='HTML' then
2491: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2492: end if;
2493:
2494: hr_utility.set_location(gv_package_name || '.report_9', 40);
2495: /*****************************************************

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

2544: -- if p_output_file_type ='HTML' then
2545: lv_data_row := '
' || lv_data_row || '' ;
2546: -- end if;
2547:
2548: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
2549:
2550:
2551: /*****************************************************************
2552: ** initialize Data varaibles
Line 2563: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');

2559: ** Close of the Data Section of the Report
2560: *****************************************************/
2561:
2562: if p_output_file_type ='HTML' then
2563: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2564: end if;
2565:
2566: END report_9;
2567:

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

2631: ** Defined data set so that it is printed at the end of the
2632: ** report.
2633: ****************************************************************/
2634:
2635: fnd_file.put_line(fnd_file.output, formated_header_string(
2636: 'X. Summary of employees for whom new Vertex Element Entry records have been created'
2637: ,p_output_file_type
2638: ));
2639:

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

2636: 'X. Summary of employees for whom new Vertex Element Entry records have been created'
2637: ,p_output_file_type
2638: ));
2639:
2640: fnd_file.put_line(fnd_file.output, formated_header_string(
2641: 'NO ACTION IS REQUIRED. This is for information ONLY.'
2642: ,p_output_file_type
2643: ));
2644:

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

2641: 'NO ACTION IS REQUIRED. This is for information ONLY.'
2642: ,p_output_file_type
2643: ));
2644:
2645: fnd_file.put_line(fnd_file.output, formated_header_string(
2646: 'Please ensure that for these assignments, the tax records are as expected and the percent'
2647: ,p_output_file_type
2648: ));
2649:

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

2646: 'Please ensure that for these assignments, the tax records are as expected and the percent'
2647: ,p_output_file_type
2648: ));
2649:
2650: fnd_file.put_line(fnd_file.output, formated_header_string(
2651: 'of time spent in each city is correct and the sum of percent of time spent in all states equals 100.'
2652: ,p_output_file_type
2653: ));
2654:

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

2651: 'of time spent in each city is correct and the sum of percent of time spent in all states equals 100.'
2652: ,p_output_file_type
2653: ));
2654:
2655: fnd_file.put_line(fnd_file.output, formated_header_string(
2656: 'These names may be duplicated from above. They are listed just for a reference.'
2657: ,p_output_file_type
2658: ));
2659:

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

2664: ** the body and table before printing the header info, otherwise
2665: ** just print the header information.
2666: ****************************************************************/
2667: if p_output_file_type ='HTML' then
2668: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2669: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2670: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2671: end if;
2672: hr_utility.set_location(gv_package_name || '.report_10', 20);
Line 2669: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2665: ** just print the header information.
2666: ****************************************************************/
2667: if p_output_file_type ='HTML' then
2668: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2669: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2670: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2671: end if;
2672: hr_utility.set_location(gv_package_name || '.report_10', 20);
2673:
Line 2670: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
2666: ****************************************************************/
2667: if p_output_file_type ='HTML' then
2668: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2669: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2670: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2671: end if;
2672: hr_utility.set_location(gv_package_name || '.report_10', 20);
2673:
2674: lv_format1 :=
Line 2698: fnd_file.put_line(fnd_file.output, lv_format1);

2694:
2695: hr_utility.set_location(gv_package_name || '.report_10', 30);
2696:
2697:
2698: fnd_file.put_line(fnd_file.output, lv_format1);
2699:
2700: if p_output_file_type ='HTML' then
2701: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
2702: end if;
Line 2701: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

2697:
2698: fnd_file.put_line(fnd_file.output, lv_format1);
2699:
2700: if p_output_file_type ='HTML' then
2701: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2702: end if;
2703:
2704: hr_utility.set_location(gv_package_name || '.report_10', 40);
2705: /*****************************************************

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

2754: -- if p_output_file_type ='HTML' then
2755: lv_data_row := '
' || lv_data_row || '' ;
2756: -- end if;
2757:
2758: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
2759:
2760:
2761: /*****************************************************************
2762: ** initialize Data varaibles
Line 2773: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');

2769: ** Close of the Data Section of the Report
2770: *****************************************************/
2771:
2772: if p_output_file_type ='HTML' then
2773: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2774: end if;
2775:
2776: END report_10;
2777:

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

2822: ** Defined data set so that it is printed at the end of the
2823: ** report.
2824: ****************************************************************/
2825:
2826: fnd_file.put_line(fnd_file.output, formated_header_string(
2827: 'XI. New taxability rules.'
2828: ,p_output_file_type
2829: ));
2830:

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

2827: 'XI. New taxability rules.'
2828: ,p_output_file_type
2829: ));
2830:
2831: fnd_file.put_line(fnd_file.output, formated_header_string(
2832: 'The taxability rules have been changed for the following jurisdiction codes to reflect the new jurisdiction code.'
2833: ,p_output_file_type
2834: ));
2835:

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

2839: ** the body and table before printing the header info, otherwise
2840: ** just print the header information.
2841: ****************************************************************/
2842: if p_output_file_type ='HTML' then
2843: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2844: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2845: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2846: end if;
2847: hr_utility.set_location(gv_package_name || '.report_11', 20);
Line 2844: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2840: ** just print the header information.
2841: ****************************************************************/
2842: if p_output_file_type ='HTML' then
2843: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2844: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2845: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2846: end if;
2847: hr_utility.set_location(gv_package_name || '.report_11', 20);
2848:
Line 2845: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
2841: ****************************************************************/
2842: if p_output_file_type ='HTML' then
2843: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2844: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
2845: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2846: end if;
2847: hr_utility.set_location(gv_package_name || '.report_11', 20);
2848:
2849: lv_format1 :=
Line 2862: fnd_file.put_line(fnd_file.output, lv_format1);

2858:
2859: hr_utility.set_location(gv_package_name || '.report_11', 30);
2860:
2861:
2862: fnd_file.put_line(fnd_file.output, lv_format1);
2863:
2864: if p_output_file_type ='HTML' then
2865: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
2866: end if;
Line 2865: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

2861:
2862: fnd_file.put_line(fnd_file.output, lv_format1);
2863:
2864: if p_output_file_type ='HTML' then
2865: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2866: end if;
2867:
2868: hr_utility.set_location(gv_package_name || '.report_11', 40);
2869: /*****************************************************

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

2913: -- if p_output_file_type ='HTML' then
2914: lv_data_row := '
' || lv_data_row || '' ;
2915: -- end if;
2916:
2917: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
2918:
2919:
2920: /*****************************************************************
2921: ** initialize Data varaibles
Line 2932: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');

2928: ** Close of the Data Section of the Report
2929: *****************************************************/
2930:
2931: if p_output_file_type ='HTML' then
2932: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
2933: end if;
2934:
2935: END report_11;
2936:

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

3024: ** Defined data set so that it is printed at the end of the
3025: ** report.
3026: ****************************************************************/
3027:
3028: fnd_file.put_line(fnd_file.output, formated_header_string(
3029: 'XII. County Code Change. '
3030: ,p_output_file_type
3031: ));
3032:

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

3029: 'XII. County Code Change. '
3030: ,p_output_file_type
3031: ));
3032:
3033: fnd_file.put_line(fnd_file.output, formated_header_string(
3034: 'ACTION REQUIRED.'
3035: ,p_output_file_type
3036: ));
3037:

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

3034: 'ACTION REQUIRED.'
3035: ,p_output_file_type
3036: ));
3037:
3038: fnd_file.put_line(fnd_file.output, formated_header_string(
3039: 'The following assignments are located in jurisdictions which are '
3040: ,p_output_file_type
3041: ));
3042:

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

3039: 'The following assignments are located in jurisdictions which are '
3040: ,p_output_file_type
3041: ));
3042:
3043: fnd_file.put_line(fnd_file.output, formated_header_string(
3044: 'changing their county codes. You must update the jurisdiction information'
3045: ,p_output_file_type
3046: ));
3047:

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

3044: 'changing their county codes. You must update the jurisdiction information'
3045: ,p_output_file_type
3046: ));
3047:
3048: fnd_file.put_line(fnd_file.output, formated_header_string(
3049: 'for these assignments as Vertex will discontinue support for the'
3050: ,p_output_file_type
3051: ));
3052:

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

3049: 'for these assignments as Vertex will discontinue support for the'
3050: ,p_output_file_type
3051: ));
3052:
3053: fnd_file.put_line(fnd_file.output, formated_header_string(
3054: 'old jurisdictions in upcoming data files and taxes will stop being withheld'
3055: ,p_output_file_type
3056: ));
3057:

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

3062: ** the body and table before printing the header info, otherwise
3063: ** just print the header information.
3064: ****************************************************************/
3065: if p_output_file_type ='HTML' then
3066: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3067: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3068: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3069: end if;
3070: hr_utility.set_location(gv_package_name || '.report_12', 20);
Line 3067: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
3063: ** just print the header information.
3064: ****************************************************************/
3065: if p_output_file_type ='HTML' then
3066: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3067: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
3068: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3069: end if;
3070: hr_utility.set_location(gv_package_name || '.report_12', 20);
3071:
Line 3068: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
3064: ****************************************************************/
3065: if p_output_file_type ='HTML' then
3066: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3067: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
3068: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3069: end if;
3070: hr_utility.set_location(gv_package_name || '.report_12', 20);
3071:
3072: lv_format1 :=
Line 3108: fnd_file.put_line(fnd_file.output, lv_format1);

3104:
3105: hr_utility.set_location(gv_package_name || '.report_12', 30);
3106:
3107:
3108: fnd_file.put_line(fnd_file.output, lv_format1);
3109:
3110: if p_output_file_type ='HTML' then
3111: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
3112: end if;
Line 3111: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

3107:
3108: fnd_file.put_line(fnd_file.output, lv_format1);
3109:
3110: if p_output_file_type ='HTML' then
3111: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3112: end if;
3113:
3114: hr_utility.set_location(gv_package_name || '.report_12', 40);
3115: /*****************************************************

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

3167: -- if p_output_file_type ='HTML' then
3168: lv_data_row := '
' || lv_data_row || '' ;
3169: -- end if;
3170:
3171: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
3172:
3173:
3174: /*****************************************************************
3175: ** initialize Data varaibles
Line 3186: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');

3182: ** Close of the Data Section of the Report
3183: *****************************************************/
3184:
3185: if p_output_file_type ='HTML' then
3186: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3187: end if;
3188:
3189: --Added for Annual GEO 2010 Bug#9541247
3190: --The Details about County Name Change will only come in the Report

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

3198: FETCH c_county_name_change INTO l_count,l_description;
3199:
3200: IF c_county_name_change%FOUND THEN
3201:
3202: fnd_file.put_line(fnd_file.output, formated_header_string(
3203: 'County Name Change'
3204: ,p_output_file_type
3205: ));
3206:

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

3207: END IF;
3208:
3209: WHILE (c_county_name_change%FOUND)
3210: LOOP
3211: fnd_file.put_line(fnd_file.output, formated_header_string(
3212: l_description
3213: ,p_output_file_type
3214: ));
3215: FETCH c_county_name_change INTO l_count,l_description;

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

3248: ** Defined data set so that it is printed at the end of the
3249: ** report.
3250: ****************************************************************/
3251:
3252: fnd_file.put_line(fnd_file.output, formated_header_string(
3253: 'XIII. Table Row Counts. '
3254: ,p_output_file_type
3255: ));
3256:

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

3253: 'XIII. Table Row Counts. '
3254: ,p_output_file_type
3255: ));
3256:
3257: fnd_file.put_line(fnd_file.output, formated_header_string(
3258: 'NO ACTION IS REQUIRED. This is for information ONLY.'
3259: ,p_output_file_type
3260: ));
3261:

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

3258: 'NO ACTION IS REQUIRED. This is for information ONLY.'
3259: ,p_output_file_type
3260: ));
3261:
3262: fnd_file.put_line(fnd_file.output, formated_header_string(
3263: 'The following tables were updated and now have the following row counts:'
3264: ,p_output_file_type
3265: ));
3266:

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

3271: ** the body and table before printing the header info, otherwise
3272: ** just print the header information.
3273: ****************************************************************/
3274: if p_output_file_type ='HTML' then
3275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3278: end if;
3279: hr_utility.set_location(gv_package_name || '.report_13', 20);
Line 3276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
3272: ** just print the header information.
3273: ****************************************************************/
3274: if p_output_file_type ='HTML' then
3275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
3277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3278: end if;
3279: hr_utility.set_location(gv_package_name || '.report_13', 20);
3280:
Line 3277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
3273: ****************************************************************/
3274: if p_output_file_type ='HTML' then
3275: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3276: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
3277: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3278: end if;
3279: hr_utility.set_location(gv_package_name || '.report_13', 20);
3280:
3281: lv_format1 :=
Line 3294: fnd_file.put_line(fnd_file.output, lv_format1);

3290:
3291: hr_utility.set_location(gv_package_name || '.report_13', 30);
3292:
3293:
3294: fnd_file.put_line(fnd_file.output, lv_format1);
3295:
3296: if p_output_file_type ='HTML' then
3297: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
3298: end if;
Line 3297: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

3293:
3294: fnd_file.put_line(fnd_file.output, lv_format1);
3295:
3296: if p_output_file_type ='HTML' then
3297: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3298: end if;
3299:
3300: hr_utility.set_location(gv_package_name || '.report_13', 40);
3301: /*****************************************************

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

3337: hr_utility.set_location(gv_package_name || '.report_13', 65);
3338:
3339: lv_data_row := '
' || lv_data_row || '' ;
3340:
3341: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
3342:
3343: -- count for pay_us_counties --
3344:
3345: ln_row_count := 0;
Line 3369: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

3365: hr_utility.set_location(gv_package_name || '.report_13', 70);
3366:
3367: lv_data_row := '
' || lv_data_row || '' ;
3368:
3369: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
3370:
3371: -- count for pay_us_city_geocodes --
3372:
3373: ln_row_count := 0;
Line 3396: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

3392: hr_utility.set_location(gv_package_name || '.report_13', 75);
3393:
3394: lv_data_row := '
' || lv_data_row || '' ;
3395:
3396: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
3397:
3398: -- count for pay_us_city_names --
3399:
3400: ln_row_count := 0;
Line 3423: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

3419: hr_utility.set_location(gv_package_name || '.report_13', 80);
3420:
3421: lv_data_row := '
' || lv_data_row || '' ;
3422:
3423: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
3424:
3425: -- count for pay_us_zip_codes --
3426:
3427: ln_row_count := 0;
Line 3450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

3446: hr_utility.set_location(gv_package_name || '.report_13', 85);
3447:
3448: lv_data_row := '
' || lv_data_row || '' ;
3449:
3450: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
3451:
3452: -- count for pay_us_modified_geocodes --
3453:
3454: ln_row_count := 0;
Line 3477: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);

3473: hr_utility.set_location(gv_package_name || '.report_13', 90);
3474:
3475: lv_data_row := '
' || lv_data_row || '' ;
3476:
3477: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
3478: /*****************************************************************
3479: ** initialize Data varaibles
3480: *****************************************************************/
3481: lv_data_row := null;
Line 3489: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');

3485: ** Close of the Data Section of the Report
3486: *****************************************************/
3487:
3488: if p_output_file_type ='HTML' then
3489: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3490: end if;
3491:
3492: END report_13;
3493:

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

3616: ** Defined data set so that it is printed at the end of the
3617: ** report.
3618: ****************************************************************/
3619:
3620: fnd_file.put_line(fnd_file.output, formated_header_string(
3621: 'XIV. Work Location ZIP Code Support.'
3622: ,p_output_file_type
3623: ));
3624:

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

3621: 'XIV. Work Location ZIP Code Support.'
3622: ,p_output_file_type
3623: ));
3624:
3625: fnd_file.put_line(fnd_file.output, formated_header_string(
3626: 'ACTION REQUIRED.'
3627: ,p_output_file_type
3628: ));
3629:

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

3626: 'ACTION REQUIRED.'
3627: ,p_output_file_type
3628: ));
3629:
3630: fnd_file.put_line(fnd_file.output, formated_header_string(
3631: 'The following work locations are using ZIP Codes no longer '
3632: ,p_output_file_type
3633: ));
3634:

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

3631: 'The following work locations are using ZIP Codes no longer '
3632: ,p_output_file_type
3633: ));
3634:
3635: fnd_file.put_line(fnd_file.output, formated_header_string(
3636: 'supported by Vertex. Please review these locations and adjust'
3637: ,p_output_file_type
3638: ));
3639:

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

3636: 'supported by Vertex. Please review these locations and adjust'
3637: ,p_output_file_type
3638: ));
3639:
3640: fnd_file.put_line(fnd_file.output, formated_header_string(
3641: 'Their ZIP Codes to supported values.'
3642: ,p_output_file_type
3643: ));
3644:

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

3649: ** the body and table before printing the header info, otherwise
3650: ** just print the header information.
3651: ****************************************************************/
3652: if p_output_file_type ='HTML' then
3653: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3654: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3655: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3656: end if;
3657: hr_utility.set_location(gv_package_name || '.report_14', 20);
Line 3654: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
3650: ** just print the header information.
3651: ****************************************************************/
3652: if p_output_file_type ='HTML' then
3653: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3654: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
3655: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3656: end if;
3657: hr_utility.set_location(gv_package_name || '.report_14', 20);
3658:
Line 3655: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
3651: ****************************************************************/
3652: if p_output_file_type ='HTML' then
3653: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3654: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
3655: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3656: end if;
3657: hr_utility.set_location(gv_package_name || '.report_14', 20);
3658:
3659: lv_format1 :=
Line 3692: fnd_file.put_line(fnd_file.output, lv_format1);

3688:
3689: hr_utility.set_location(gv_package_name || '.report_14', 30);
3690:
3691:
3692: fnd_file.put_line(fnd_file.output, lv_format1);
3693:
3694: if p_output_file_type ='HTML' then
3695: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
3696: end if;
Line 3695: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

3691:
3692: fnd_file.put_line(fnd_file.output, lv_format1);
3693:
3694: if p_output_file_type ='HTML' then
3695: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3696: end if;
3697:
3698: hr_utility.set_location(gv_package_name || '.report_14', 40);
3699: /*****************************************************

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

3751: -- if p_output_file_type ='HTML' then
3752: lv_data_row := '
' || lv_data_row || '' ;
3753: -- end if;
3754:
3755: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
3756:
3757:
3758: /*****************************************************************
3759: ** initialize Data varaibles
Line 3770: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');

3766: ** Close of the Data Section of the Report
3767: *****************************************************/
3768:
3769: if p_output_file_type ='HTML' then
3770: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3771: end if;
3772:
3773: END report_14;
3774:

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

3897: ** Defined data set so that it is printed at the end of the
3898: ** report.
3899: ****************************************************************/
3900:
3901: fnd_file.put_line(fnd_file.output, formated_header_string(
3902: 'XV. Home Address ZIP Code Support.'
3903: ,p_output_file_type
3904: ));
3905:

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

3902: 'XV. Home Address ZIP Code Support.'
3903: ,p_output_file_type
3904: ));
3905:
3906: fnd_file.put_line(fnd_file.output, formated_header_string(
3907: 'ACTION REQUIRED.'
3908: ,p_output_file_type
3909: ));
3910:

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

3907: 'ACTION REQUIRED.'
3908: ,p_output_file_type
3909: ));
3910:
3911: fnd_file.put_line(fnd_file.output, formated_header_string(
3912: 'The following home addresses are using ZIP Codes no longer '
3913: ,p_output_file_type
3914: ));
3915:

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

3912: 'The following home addresses are using ZIP Codes no longer '
3913: ,p_output_file_type
3914: ));
3915:
3916: fnd_file.put_line(fnd_file.output, formated_header_string(
3917: 'supported by Vertex. Please review these addresses and adjust'
3918: ,p_output_file_type
3919: ));
3920:

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

3917: 'supported by Vertex. Please review these addresses and adjust'
3918: ,p_output_file_type
3919: ));
3920:
3921: fnd_file.put_line(fnd_file.output, formated_header_string(
3922: 'their ZIP Codes to supported values.'
3923: ,p_output_file_type
3924: ));
3925:

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

3930: ** the body and table before printing the header info, otherwise
3931: ** just print the header information.
3932: ****************************************************************/
3933: if p_output_file_type ='HTML' then
3934: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3935: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3936: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3937: end if;
3938: hr_utility.set_location(gv_package_name || '.report_15', 20);
Line 3935: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
3931: ** just print the header information.
3932: ****************************************************************/
3933: if p_output_file_type ='HTML' then
3934: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3935: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
3936: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3937: end if;
3938: hr_utility.set_location(gv_package_name || '.report_15', 20);
3939:
Line 3936: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
3932: ****************************************************************/
3933: if p_output_file_type ='HTML' then
3934: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3935: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
3936: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3937: end if;
3938: hr_utility.set_location(gv_package_name || '.report_15', 20);
3939:
3940: lv_format1 :=
Line 3969: fnd_file.put_line(fnd_file.output, lv_format1);

3965:
3966: hr_utility.set_location(gv_package_name || '.report_15', 30);
3967:
3968:
3969: fnd_file.put_line(fnd_file.output, lv_format1);
3970:
3971: if p_output_file_type ='HTML' then
3972: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
3973: end if;
Line 3972: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

3968:
3969: fnd_file.put_line(fnd_file.output, lv_format1);
3970:
3971: if p_output_file_type ='HTML' then
3972: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
3973: end if;
3974:
3975: hr_utility.set_location(gv_package_name || '.report_15', 40);
3976: /*****************************************************

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

4024: -- if p_output_file_type ='HTML' then
4025: lv_data_row := '
' || lv_data_row || '' ;
4026: -- end if;
4027:
4028: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
4029:
4030:
4031: /*****************************************************************
4032: ** initialize Data varaibles
Line 4043: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');

4039: ** Close of the Data Section of the Report
4040: *****************************************************/
4041:
4042: if p_output_file_type ='HTML' then
4043: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4044: end if;
4045:
4046: END report_15;
4047:

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

4258: BEGIN
4259:
4260: hr_utility.set_location(gv_package_name || '.report_16', 10);
4261:
4262: fnd_file.put_line(fnd_file.output, formated_header_string(
4263: 'XVI. City Name Change'
4264: ,p_output_file_type
4265: ));
4266:

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

4263: 'XVI. City Name Change'
4264: ,p_output_file_type
4265: ));
4266:
4267: fnd_file.put_line(fnd_file.output, formated_header_string(
4268: 'NO ACTION IS REQUIRED. This is for information ONLY.'
4269: ,p_output_file_type
4270: ));
4271:

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

4268: 'NO ACTION IS REQUIRED. This is for information ONLY.'
4269: ,p_output_file_type
4270: ));
4271:
4272: fnd_file.put_line(fnd_file.output, formated_header_string(
4273: 'The following are the City Name changes.'
4274: ,p_output_file_type
4275: ));
4276:

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

4278:
4279: /*Start of City Name change details section */
4280:
4281: if p_output_file_type ='HTML' then
4282: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4283: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4284: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4285: end if;
4286:
Line 4283: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
4279: /*Start of City Name change details section */
4280:
4281: if p_output_file_type ='HTML' then
4282: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4283: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
4284: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4285: end if;
4286:
4287: hr_utility.set_location(gv_package_name || '.report_16', 20);
Line 4284: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
4280:
4281: if p_output_file_type ='HTML' then
4282: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4283: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
4284: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4285: end if;
4286:
4287: hr_utility.set_location(gv_package_name || '.report_16', 20);
4288:
Line 4321: fnd_file.put_line(fnd_file.output, lv_format1);

4317: ;
4318:
4319: hr_utility.set_location(gv_package_name || '.report_16', 25);
4320:
4321: fnd_file.put_line(fnd_file.output, lv_format1);
4322:
4323: if p_output_file_type ='HTML' then
4324: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
4325: end if;
Line 4324: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

4320:
4321: fnd_file.put_line(fnd_file.output, lv_format1);
4322:
4323: if p_output_file_type ='HTML' then
4324: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4325: end if;
4326:
4327: /*****************************************************
4328: ** Start of the Data Section

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

4360: hr_utility.set_location(gv_package_name || '.report_16', 60);
4361:
4362: lv_data_row := '
' || lv_data_row || '' ;
4363:
4364: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
4365:
4366: lv_data_row := null;
4367:
4368: end loop;
Line 4377: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');

4373: ** Close of the Data Section
4374: *****************************************************/
4375:
4376: if p_output_file_type ='HTML' then
4377: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4378: end if;
4379:
4380: /* End of City Name change details section */
4381:

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

4378: end if;
4379:
4380: /* End of City Name change details section */
4381:
4382: fnd_file.put_line(fnd_file.output, formated_header_string(
4383: 'The following are the Person Addresses updated for City Name changes.'
4384: ,p_output_file_type
4385: ));
4386:

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

4386:
4387: /* Start of Person Address details updated section */
4388:
4389: if p_output_file_type ='HTML' then
4390: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4391: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4392: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4393: end if;
4394:
Line 4391: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
4387: /* Start of Person Address details updated section */
4388:
4389: if p_output_file_type ='HTML' then
4390: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4391: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
4392: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4393: end if;
4394:
4395: hr_utility.set_location(gv_package_name || '.report_16', 70);
Line 4392: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
4388:
4389: if p_output_file_type ='HTML' then
4390: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4391: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
4392: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4393: end if;
4394:
4395: hr_utility.set_location(gv_package_name || '.report_16', 70);
4396:
Line 4429: fnd_file.put_line(fnd_file.output, lv_format1);

4425: ;
4426:
4427: hr_utility.set_location(gv_package_name || '.report_16', 80);
4428:
4429: fnd_file.put_line(fnd_file.output, lv_format1);
4430:
4431: if p_output_file_type ='HTML' then
4432: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
4433: end if;
Line 4432: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

4428:
4429: fnd_file.put_line(fnd_file.output, lv_format1);
4430:
4431: if p_output_file_type ='HTML' then
4432: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4433: end if;
4434:
4435: hr_utility.set_location(gv_package_name || '.report_16', 90);
4436:

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

4475: hr_utility.set_location(gv_package_name || '.report_16', 130);
4476:
4477: lv_data_row := '
' || lv_data_row || '' ;
4478:
4479: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
4480:
4481: lv_data_row := null;
4482:
4483: end loop;
Line 4492: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');

4488: ** Close of the Data Section
4489: *****************************************************/
4490:
4491: if p_output_file_type ='HTML' then
4492: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4493: end if;
4494:
4495: /* End of Person Address details updated section */
4496:

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

4493: end if;
4494:
4495: /* End of Person Address details updated section */
4496:
4497: fnd_file.put_line(fnd_file.output, formated_header_string(
4498: 'The following are the Location Addresses updated for City Name changes.'
4499: ,p_output_file_type
4500: ));
4501:

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

4501:
4502: /* Start of Location details updated section */
4503:
4504: if p_output_file_type ='HTML' then
4505: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4506: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4507: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4508: end if;
4509:
Line 4506: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
4502: /* Start of Location details updated section */
4503:
4504: if p_output_file_type ='HTML' then
4505: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4506: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
4507: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4508: end if;
4509:
4510: hr_utility.set_location(gv_package_name || '.report_16', 140);
Line 4507: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
4503:
4504: if p_output_file_type ='HTML' then
4505: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4506: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
4507: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4508: end if;
4509:
4510: hr_utility.set_location(gv_package_name || '.report_16', 140);
4511:
Line 4540: fnd_file.put_line(fnd_file.output, lv_format1);

4536: ;
4537:
4538: hr_utility.set_location(gv_package_name || '.report_16', 150);
4539:
4540: fnd_file.put_line(fnd_file.output, lv_format1);
4541:
4542: if p_output_file_type ='HTML' then
4543: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
4544: end if;
Line 4543: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

4539:
4540: fnd_file.put_line(fnd_file.output, lv_format1);
4541:
4542: if p_output_file_type ='HTML' then
4543: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4544: end if;
4545:
4546: hr_utility.set_location(gv_package_name || '.report_16', 160);
4547:

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

4584: hr_utility.set_location(gv_package_name || '.report_16', 200);
4585:
4586: lv_data_row := '
' || lv_data_row || '' ;
4587:
4588: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
4589:
4590: lv_data_row := null;
4591:
4592: end loop;
Line 4601: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');

4597: ** Close of the Data Section
4598: *****************************************************/
4599:
4600: if p_output_file_type ='HTML' then
4601: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4602: end if;
4603:
4604: /* End of Location details updated section */
4605:

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

4602: end if;
4603:
4604: /* End of Location details updated section */
4605:
4606: fnd_file.put_line(fnd_file.output, formated_header_string(
4607: 'The following are the Organization Information Details updated for City Name changes.'
4608: ,p_output_file_type
4609: ));
4610:

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

4610:
4611: /* Start of Organization Information updated section */
4612:
4613: if p_output_file_type ='HTML' then
4614: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4615: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4616: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4617: end if;
4618:
Line 4615: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
4611: /* Start of Organization Information updated section */
4612:
4613: if p_output_file_type ='HTML' then
4614: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4615: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
4616: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4617: end if;
4618:
4619: hr_utility.set_location(gv_package_name || '.report_16', 210);
Line 4616: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
4612:
4613: if p_output_file_type ='HTML' then
4614: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4615: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');
4616: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4617: end if;
4618:
4619: hr_utility.set_location(gv_package_name || '.report_16', 210);
4620:
Line 4649: fnd_file.put_line(fnd_file.output, lv_format1);

4645: ;
4646:
4647: hr_utility.set_location(gv_package_name || '.report_16', 220);
4648:
4649: fnd_file.put_line(fnd_file.output, lv_format1);
4650:
4651: if p_output_file_type ='HTML' then
4652: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '
');
4653: end if;
Line 4652: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');

4648:
4649: fnd_file.put_line(fnd_file.output, lv_format1);
4650:
4651: if p_output_file_type ='HTML' then
4652: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4653: end if;
4654:
4655: hr_utility.set_location(gv_package_name || '.report_16', 230);
4656:

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

4693: hr_utility.set_location(gv_package_name || '.report_16', 270);
4694:
4695: lv_data_row := '
' || lv_data_row || '' ;
4696:
4697: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, lv_data_row);
4698:
4699: lv_data_row := null;
4700:
4701: end loop;
Line 4710: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '

');

4706: ** Close of the Data Section
4707: *****************************************************/
4708:
4709: if p_output_file_type ='HTML' then
4710: FND_FILE.PUT_LINE(FND_FILE.OUTPUT, '');
4711: end if;
4712:
4713: /* End of Organization Information updated section */
4714:

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

4832: INTO lv_patch_name
4833: FROM pay_patch_status
4834: WHERE id = p_geo_phase_id;
4835:
4836: fnd_file.put_line(fnd_file.output, formated_header_string(
4837: 'Patch Name : '||lv_patch_name
4838: ,lv_output_file_type
4839: ));
4840:

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

4837: 'Patch Name : '||lv_patch_name
4838: ,lv_output_file_type
4839: ));
4840:
4841: fnd_file.put_line(fnd_file.output, formated_header_string(
4842: 'Child Request "Geocode Upgrade Concurrent Program" not submitted for '||lv_patch_name
4843: ,lv_output_file_type
4844: ));
4845:

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

4842: 'Child Request "Geocode Upgrade Concurrent Program" not submitted for '||lv_patch_name
4843: ,lv_output_file_type
4844: ));
4845:
4846: fnd_file.put_line(fnd_file.output, formated_header_string(
4847: 'Generating Output for City Name change details in main "Geocode Upgrade Manager" Output'
4848: ,lv_output_file_type
4849: ));
4850: