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_PSD_UPGRADE_PKG dependencies on FND_FILE

Line 225: fnd_file.put_line(fnd_file.log,'UPGRADE Mode can be executed only after running the process in GENERATE Mode successfully.');

221: WHEN NO_DATA_FOUND THEN
222:
223: hr_utility.trace('UPGRADE Mode can be executed only after running the process in GENERATE Mode successfully.');
224: hr_utility.trace('Not able to find the PAY_PATCH_STATUS entry corresponding to GENERATE Mode execution.');
225: fnd_file.put_line(fnd_file.log,'UPGRADE Mode can be executed only after running the process in GENERATE Mode successfully.');
226: fnd_file.put_line(fnd_file.log,'Not able to find the PAY_PATCH_STATUS entry corresponding to GENERATE Mode execution.');
227: hr_utility.raise_error;
228:
229: END;

Line 226: fnd_file.put_line(fnd_file.log,'Not able to find the PAY_PATCH_STATUS entry corresponding to GENERATE Mode execution.');

222:
223: hr_utility.trace('UPGRADE Mode can be executed only after running the process in GENERATE Mode successfully.');
224: hr_utility.trace('Not able to find the PAY_PATCH_STATUS entry corresponding to GENERATE Mode execution.');
225: fnd_file.put_line(fnd_file.log,'UPGRADE Mode can be executed only after running the process in GENERATE Mode successfully.');
226: fnd_file.put_line(fnd_file.log,'Not able to find the PAY_PATCH_STATUS entry corresponding to GENERATE Mode execution.');
227: hr_utility.raise_error;
228:
229: END;
230:

Line 260: fnd_file.put_line(fnd_file.log,'Inconsistent state of Upgrade Process. Raise error');

256: WHEN TOO_MANY_ROWS THEN
257:
258: hr_utility.trace('Inconsistent state of Upgrade Process. Raise error');
259: hr_utility.trace('Too Many rows of Upgrade Process found');
260: fnd_file.put_line(fnd_file.log,'Inconsistent state of Upgrade Process. Raise error');
261: fnd_file.put_line(fnd_file.log,'Too Many rows of Upgrade Process found');
262: hr_utility.raise_error;
263:
264: END;

Line 261: fnd_file.put_line(fnd_file.log,'Too Many rows of Upgrade Process found');

257:
258: hr_utility.trace('Inconsistent state of Upgrade Process. Raise error');
259: hr_utility.trace('Too Many rows of Upgrade Process found');
260: fnd_file.put_line(fnd_file.log,'Inconsistent state of Upgrade Process. Raise error');
261: fnd_file.put_line(fnd_file.log,'Too Many rows of Upgrade Process found');
262: hr_utility.raise_error;
263:
264: END;
265:

Line 291: fnd_file.put_line(fnd_file.log,'Incomplete Upgrade Run Exists. Run the Process in UPGRADE mode');

287: AND id > l_prev_upgrade_id
288: AND nvl(status,'P') <> 'C';
289:
290: hr_utility.trace('Incomplete Upgrade Run Exists. Run the Process in UPGRADE mode');
291: fnd_file.put_line(fnd_file.log,'Incomplete Upgrade Run Exists. Run the Process in UPGRADE mode');
292: hr_utility.raise_error;
293:
294: EXCEPTION
295:

Line 419: fnd_file.put_line(fnd_file.log,'PSDCODE changes entries found for Upgrade');

415: IF l_upgrade_needed = 'Y' THEN
416:
417: hr_utility.trace('PSDCODE changes entries found for Upgrade');
418: hr_utility.trace('Processing required');
419: fnd_file.put_line(fnd_file.log,'PSDCODE changes entries found for Upgrade');
420: fnd_file.put_line(fnd_file.log,'Processing required');
421:
422: /*Get the MODE of Execution for the PSDCODE Process*/
423:

Line 420: fnd_file.put_line(fnd_file.log,'Processing required');

416:
417: hr_utility.trace('PSDCODE changes entries found for Upgrade');
418: hr_utility.trace('Processing required');
419: fnd_file.put_line(fnd_file.log,'PSDCODE changes entries found for Upgrade');
420: fnd_file.put_line(fnd_file.log,'Processing required');
421:
422: /*Get the MODE of Execution for the PSDCODE Process*/
423:
424: SELECT pay_us_geo_upd_pkg.get_parameter('MODE',ppa.legislative_parameters)

Line 445: fnd_file.put_line(fnd_file.log,'No PSDCODE changes entries for Upgrade');

441: ELSE
442:
443: hr_utility.trace('No PSDCODE changes entries for Upgrade');
444: hr_utility.trace('No Processing required');
445: fnd_file.put_line(fnd_file.log,'No PSDCODE changes entries for Upgrade');
446: fnd_file.put_line(fnd_file.log,'No Processing required');
447:
448: END IF; /*l_upgrade_needed IF*/
449:

Line 446: fnd_file.put_line(fnd_file.log,'No Processing required');

442:
443: hr_utility.trace('No PSDCODE changes entries for Upgrade');
444: hr_utility.trace('No Processing required');
445: fnd_file.put_line(fnd_file.log,'No PSDCODE changes entries for Upgrade');
446: fnd_file.put_line(fnd_file.log,'No Processing required');
447:
448: END IF; /*l_upgrade_needed IF*/
449:
450: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.perform_initial_setup');

Line 996: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_psd_upgrade_pkg.generate_assignment for Assignment ID '||p_assignment_id);

992: EXCEPTION
993:
994: WHEN OTHERS THEN
995:
996: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_psd_upgrade_pkg.generate_assignment for Assignment ID '||p_assignment_id);
997: fnd_file.put_line(fnd_file.log,'SQLERRM = ' || SQLERRM);
998: hr_utility.trace('Exception raised in pay_us_psdcode_upgrade_pkg.generate_assignment');
999: hr_utility.trace('SQLERRM = ' || SQLERRM);
1000:

Line 997: fnd_file.put_line(fnd_file.log,'SQLERRM = ' || SQLERRM);

993:
994: WHEN OTHERS THEN
995:
996: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_psd_upgrade_pkg.generate_assignment for Assignment ID '||p_assignment_id);
997: fnd_file.put_line(fnd_file.log,'SQLERRM = ' || SQLERRM);
998: hr_utility.trace('Exception raised in pay_us_psdcode_upgrade_pkg.generate_assignment');
999: hr_utility.trace('SQLERRM = ' || SQLERRM);
1000:
1001: END;

Line 1163: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_psd_upgrade_pkg.upgrade_assignment for Assignment ID '||p_assignment_id);

1159: AND process_date = p_date
1160: AND process_type = 'PA'
1161: AND assignment_id = p_assignment_id;
1162:
1163: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_psd_upgrade_pkg.upgrade_assignment for Assignment ID '||p_assignment_id);
1164: hr_utility.trace('Exception raised in pay_us_psdcode_upgrade_pkg.upgrade_assignment');
1165: hr_utility.trace('SQLERRM = ' || SQLERRM);
1166: hr_utility.raise_error;
1167:

Line 1408: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_psd_upgrade_pkg.action_creation');

1404: EXCEPTION
1405:
1406: WHEN OTHERS THEN
1407:
1408: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_psd_upgrade_pkg.action_creation');
1409: fnd_file.put_line(fnd_file.log,sqlerrm);
1410:
1411: END action_creation;
1412:

Line 1409: fnd_file.put_line(fnd_file.log,sqlerrm);

1405:
1406: WHEN OTHERS THEN
1407:
1408: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_psd_upgrade_pkg.action_creation');
1409: fnd_file.put_line(fnd_file.log,sqlerrm);
1410:
1411: END action_creation;
1412:
1413: PROCEDURE archive_code (p_xfr_action_id IN NUMBER,

Line 1496: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_psd_upgrade_pkg.archive_code for Assignment Action ID '||p_xfr_action_id);

1492: EXCEPTION
1493:
1494: WHEN OTHERS THEN
1495:
1496: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_psd_upgrade_pkg.archive_code for Assignment Action ID '||p_xfr_action_id);
1497: fnd_file.put_line(fnd_file.log,'Error '||sqlerrm);
1498: hr_utility.raise_error;
1499:
1500: END archive_code;

Line 1497: fnd_file.put_line(fnd_file.log,'Error '||sqlerrm);

1493:
1494: WHEN OTHERS THEN
1495:
1496: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_psd_upgrade_pkg.archive_code for Assignment Action ID '||p_xfr_action_id);
1497: fnd_file.put_line(fnd_file.log,'Error '||sqlerrm);
1498: hr_utility.raise_error;
1499:
1500: END archive_code;
1501:

Line 1598: fnd_file.put_line(fnd_file.output,'

Run Balance Invalidation

');

1594: FETCH get_run_balance_details INTO l_business_group_id,l_business_group_name,l_balance_validation_id;
1595:
1596: IF get_run_balance_details%FOUND THEN
1597:
1598: fnd_file.put_line(fnd_file.output,'

Run Balance Invalidation

');
1599:
1600: IF p_mode = 'GENERATE' THEN
1601:
1602: fnd_file.put_line(fnd_file.output,'

Run Balances related to below listed Defined Balances will be invalidated.

');

Line 1602: fnd_file.put_line(fnd_file.output,'
Run Balances related to below listed Defined Balances will be invalidated.
');

1598: fnd_file.put_line(fnd_file.output,'

Run Balance Invalidation

');
1599:
1600: IF p_mode = 'GENERATE' THEN
1601:
1602: fnd_file.put_line(fnd_file.output,'
Run Balances related to below listed Defined Balances will be invalidated.
');
1603: fnd_file.put_line(fnd_file.output,'

Need to Run Generate Run Balances Concurrent Program to regenerate them after UPRADE Mode Run.

');
1604:
1605: ELSIF p_mode = 'UPGRADE' THEN
1606:

Line 1603: fnd_file.put_line(fnd_file.output,'
Need to Run Generate Run Balances Concurrent Program to regenerate them after UPRADE Mode Run.
');

1599:
1600: IF p_mode = 'GENERATE' THEN
1601:
1602: fnd_file.put_line(fnd_file.output,'

Run Balances related to below listed Defined Balances will be invalidated.

');
1603: fnd_file.put_line(fnd_file.output,'
Need to Run Generate Run Balances Concurrent Program to regenerate them after UPRADE Mode Run.
');
1604:
1605: ELSIF p_mode = 'UPGRADE' THEN
1606:
1607: fnd_file.put_line(fnd_file.output,'

Run Balances related to below listed Defined Balances are invalidated.

');

Line 1607: fnd_file.put_line(fnd_file.output,'
Run Balances related to below listed Defined Balances are invalidated.
');

1603: fnd_file.put_line(fnd_file.output,'

Need to Run Generate Run Balances Concurrent Program to regenerate them after UPRADE Mode Run.

');
1604:
1605: ELSIF p_mode = 'UPGRADE' THEN
1606:
1607: fnd_file.put_line(fnd_file.output,'
Run Balances related to below listed Defined Balances are invalidated.
');
1608: fnd_file.put_line(fnd_file.output,'

Need to Run Generate Run Balances Concurrent Program to regenerate them.

');
1609:
1610: END IF;
1611:

Line 1608: fnd_file.put_line(fnd_file.output,'
Need to Run Generate Run Balances Concurrent Program to regenerate them.
');

1604:
1605: ELSIF p_mode = 'UPGRADE' THEN
1606:
1607: fnd_file.put_line(fnd_file.output,'

Run Balances related to below listed Defined Balances are invalidated.

');
1608: fnd_file.put_line(fnd_file.output,'
Need to Run Generate Run Balances Concurrent Program to regenerate them.
');
1609:
1610: END IF;
1611:
1612: fnd_file.put_line(fnd_file.output,'');

Line 1612: fnd_file.put_line(fnd_file.output,'

');

1608: fnd_file.put_line(fnd_file.output,'

Need to Run Generate Run Balances Concurrent Program to regenerate them.

');
1609:
1610: END IF;
1611:
1612: fnd_file.put_line(fnd_file.output,'

');
1613: fnd_file.put_line(fnd_file.output,'');
1614: fnd_file.put_line(fnd_file.output,'');
1615:
1616: OPEN get_defined_balance_details;

Line 1613: fnd_file.put_line(fnd_file.output,'

');

1609:
1610: END IF;
1611:
1612: fnd_file.put_line(fnd_file.output,'

Balance Name	Dimension Name	Balance Name

');
1613: fnd_file.put_line(fnd_file.output,'');
1614: fnd_file.put_line(fnd_file.output,'');
1615:
1616: OPEN get_defined_balance_details;
1617: FETCH get_defined_balance_details INTO l_balance_name,l_dimension_name;

Line 1614: fnd_file.put_line(fnd_file.output,'

');

1610: END IF;
1611:
1612: fnd_file.put_line(fnd_file.output,'

Balance Name	Dimension Name	Dimension Name

');
1613: fnd_file.put_line(fnd_file.output,'');
1614: fnd_file.put_line(fnd_file.output,'');
1615:
1616: OPEN get_defined_balance_details;
1617: FETCH get_defined_balance_details INTO l_balance_name,l_dimension_name;
1618:

Line 1622: fnd_file.put_line(fnd_file.output,'

');

1618:
1619: WHILE (get_defined_balance_details%FOUND)
1620: LOOP
1621:
1622: fnd_file.put_line(fnd_file.output,'

');
1623: fnd_file.put_line(fnd_file.output,'');
1624:
1625: FETCH get_defined_balance_details INTO l_balance_name,l_dimension_name;
1626:

Line 1623: fnd_file.put_line(fnd_file.output,'

');

1619: WHILE (get_defined_balance_details%FOUND)
1620: LOOP
1621:
1622: fnd_file.put_line(fnd_file.output,'

');
1623: fnd_file.put_line(fnd_file.output,'');
1624:
1625: FETCH get_defined_balance_details INTO l_balance_name,l_dimension_name;
1626:
1627: END LOOP;

Line 1629: fnd_file.put_line(fnd_file.output,'

Balance Name	Dimension Name
'\|\|l_balance_name\|\|'
'\|\|l_balance_name\|\|'	'\|\|l_dimension_name\|\|'
'\|\|l_dimension_name\|\|'
'\|\|l_balance_name\|\|'	'\|\|l_dimension_name\|\|'

');

1625: FETCH get_defined_balance_details INTO l_balance_name,l_dimension_name;
1626:
1627: END LOOP;
1628:
1629: fnd_file.put_line(fnd_file.output,'');
1630:
1631: CLOSE get_defined_balance_details;
1632:
1633: IF p_mode = 'GENERATE' THEN

Line 1635: fnd_file.put_line(fnd_file.output,'
Below table indicates the Business Groups for which Run Balances will be invalidated.
');

1631: CLOSE get_defined_balance_details;
1632:
1633: IF p_mode = 'GENERATE' THEN
1634:
1635: fnd_file.put_line(fnd_file.output,'

Below table indicates the Business Groups for which Run Balances will be invalidated.

');
1636:
1637: ELSIF p_mode = 'UPGRADE' THEN
1638:
1639: fnd_file.put_line(fnd_file.output,'

Below table indicates the Business Groups for which Run Balances are invalidated.

');

Line 1639: fnd_file.put_line(fnd_file.output,'
Below table indicates the Business Groups for which Run Balances are invalidated.
');

1635: fnd_file.put_line(fnd_file.output,'

Below table indicates the Business Groups for which Run Balances will be invalidated.

');
1636:
1637: ELSIF p_mode = 'UPGRADE' THEN
1638:
1639: fnd_file.put_line(fnd_file.output,'
Below table indicates the Business Groups for which Run Balances are invalidated.
');
1640:
1641: END IF;
1642:
1643: fnd_file.put_line(fnd_file.output,'');

Line 1643: fnd_file.put_line(fnd_file.output,'

');

1639: fnd_file.put_line(fnd_file.output,'

Below table indicates the Business Groups for which Run Balances are invalidated.

');
1640:
1641: END IF;
1642:
1643: fnd_file.put_line(fnd_file.output,'

');
1644: fnd_file.put_line(fnd_file.output,'');
1645: fnd_file.put_line(fnd_file.output,'');
1646:
1647: END IF;

Line 1644: fnd_file.put_line(fnd_file.output,'

');

1640:
1641: END IF;
1642:
1643: fnd_file.put_line(fnd_file.output,'

Business Group ID	Business Group Name
Business Group ID

');
1644: fnd_file.put_line(fnd_file.output,'');
1645: fnd_file.put_line(fnd_file.output,'');
1646:
1647: END IF;
1648:

Line 1645: fnd_file.put_line(fnd_file.output,'

');

1641: END IF;
1642:
1643: fnd_file.put_line(fnd_file.output,'

Business Group ID	Business Group Name	Business Group Name

');
1644: fnd_file.put_line(fnd_file.output,'');
1645: fnd_file.put_line(fnd_file.output,'');
1646:
1647: END IF;
1648:
1649: WHILE(get_run_balance_details%FOUND)

Line 1654: fnd_file.put_line(fnd_file.output,'

');

1650: LOOP
1651:
1652: IF l_print_business_group_id <> l_business_group_id THEN
1653:
1654: fnd_file.put_line(fnd_file.output,'

');
1655: fnd_file.put_line(fnd_file.output,'');
1656: l_print_business_group_id := l_business_group_id;
1657:
1658: END IF;

Line 1655: fnd_file.put_line(fnd_file.output,'

');

1651:
1652: IF l_print_business_group_id <> l_business_group_id THEN
1653:
1654: fnd_file.put_line(fnd_file.output,'

');
1655: fnd_file.put_line(fnd_file.output,'');
1656: l_print_business_group_id := l_business_group_id;
1657:
1658: END IF;
1659:

Line 2221: fnd_file.put_line(fnd_file.output,'PSDCODE Upgrade Details');

2217: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.generate_output');
2218:
2219: l_upgrade_needed := upgrade_needed();
2220:
2221: fnd_file.put_line(fnd_file.output,'PSDCODE Upgrade Details');
2222: fnd_file.put_line(fnd_file.output,'

PSDCODE Upgrade Details

');
2223:
2224: IF l_upgrade_needed = 'Y' THEN
2225:

Line 2222: fnd_file.put_line(fnd_file.output,'

PSDCODE Upgrade Details

');

2218:
2219: l_upgrade_needed := upgrade_needed();
2220:
2221: fnd_file.put_line(fnd_file.output,'PSDCODE Upgrade Details');
2222: fnd_file.put_line(fnd_file.output,'

PSDCODE Upgrade Details

');
2223:
2224: IF l_upgrade_needed = 'Y' THEN
2225:
2226: SELECT id,applied_date

Line 2234: fnd_file.put_line(fnd_file.output,'
Process Date : '||to_char(l_date,'DD-MON-YYYY HH:MM:SS')||'
');

2230: AND legislation_code = 'US'
2231: AND status = 'P'
2232: AND description = p_mode;
2233:
2234: fnd_file.put_line(fnd_file.output,'

Process Date : '||to_char(l_date,'DD-MON-YYYY HH:MM:SS')||'

');
2235: fnd_file.put_line(fnd_file.output,'

Process Mode : '||p_mode||'

');
2236: fnd_file.put_line(fnd_file.output,'

List of PSDCODES that needs upgrade

');
2237: fnd_file.put_line(fnd_file.output,'

Business Group ID	Business Group Name
'\|\|l_business_group_id\|\|'
'\|\|l_business_group_id\|\|'	'\|\|l_business_group_name\|\|'
'\|\|l_business_group_name\|\|'
'\|\|l_business_group_id\|\|'	'\|\|l_business_group_name\|\|'

');
2238: fnd_file.put_line(fnd_file.output,'');

Line 2235: fnd_file.put_line(fnd_file.output,'
Process Mode : '||p_mode||'
');

2231: AND status = 'P'
2232: AND description = p_mode;
2233:
2234: fnd_file.put_line(fnd_file.output,'

Process Date : '||to_char(l_date,'DD-MON-YYYY HH:MM:SS')||'

');
2235: fnd_file.put_line(fnd_file.output,'
Process Mode : '||p_mode||'
');
2236: fnd_file.put_line(fnd_file.output,'

List of PSDCODES that needs upgrade

');
2237: fnd_file.put_line(fnd_file.output,'

Jurisdiction Code

');
2238: fnd_file.put_line(fnd_file.output,'');
2239: fnd_file.put_line(fnd_file.output,'');

Line 2236: fnd_file.put_line(fnd_file.output,'

List of PSDCODES that needs upgrade

');

2232: AND description = p_mode;
2233:
2234: fnd_file.put_line(fnd_file.output,'

Process Date : '||to_char(l_date,'DD-MON-YYYY HH:MM:SS')||'

');
2235: fnd_file.put_line(fnd_file.output,'

Process Mode : '||p_mode||'

');
2236: fnd_file.put_line(fnd_file.output,'
List of PSDCODES that needs upgrade
');
2237: fnd_file.put_line(fnd_file.output,'

Jurisdiction Code	School District Code

');
2238: fnd_file.put_line(fnd_file.output,'');
2239: fnd_file.put_line(fnd_file.output,'');
2240: fnd_file.put_line(fnd_file.output,'');

Line 2237: fnd_file.put_line(fnd_file.output,'

Jurisdiction Code	School District Code	Old PSDCODE

');

2233:
2234: fnd_file.put_line(fnd_file.output,'

Process Date : '||to_char(l_date,'DD-MON-YYYY HH:MM:SS')||'

');
2235: fnd_file.put_line(fnd_file.output,'

Process Mode : '||p_mode||'

');
2236: fnd_file.put_line(fnd_file.output,'

List of PSDCODES that needs upgrade

');
2237: fnd_file.put_line(fnd_file.output,'

');
2238: fnd_file.put_line(fnd_file.output,'');
2239: fnd_file.put_line(fnd_file.output,'');
2240: fnd_file.put_line(fnd_file.output,'');
2241: fnd_file.put_line(fnd_file.output,'');

Line 2238: fnd_file.put_line(fnd_file.output,'

');

2234: fnd_file.put_line(fnd_file.output,'

Process Date : '||to_char(l_date,'DD-MON-YYYY HH:MM:SS')||'

');
2235: fnd_file.put_line(fnd_file.output,'

Process Mode : '||p_mode||'

');
2236: fnd_file.put_line(fnd_file.output,'

List of PSDCODES that needs upgrade

');
2237: fnd_file.put_line(fnd_file.output,'

Jurisdiction Code	School District Code	Old PSDCODE	New PSDCODE
Jurisdiction Code

');
2238: fnd_file.put_line(fnd_file.output,'');
2239: fnd_file.put_line(fnd_file.output,'');
2240: fnd_file.put_line(fnd_file.output,'');
2241: fnd_file.put_line(fnd_file.output,'');
2242:

Line 2239: fnd_file.put_line(fnd_file.output,'

');

2235: fnd_file.put_line(fnd_file.output,'

Process Mode : '||p_mode||'

');
2236: fnd_file.put_line(fnd_file.output,'

List of PSDCODES that needs upgrade

');
2237: fnd_file.put_line(fnd_file.output,'

Jurisdiction Code	School District Code	Old PSDCODE	New PSDCODE
School District Code

');
2238: fnd_file.put_line(fnd_file.output,'');
2239: fnd_file.put_line(fnd_file.output,'');
2240: fnd_file.put_line(fnd_file.output,'');
2241: fnd_file.put_line(fnd_file.output,'');
2242:
2243: OPEN get_psdcode_details;

Line 2240: fnd_file.put_line(fnd_file.output,'

');

2236: fnd_file.put_line(fnd_file.output,'

List of PSDCODES that needs upgrade

');
2237: fnd_file.put_line(fnd_file.output,'

Jurisdiction Code	School District Code	Old PSDCODE	New PSDCODE
Old PSDCODE

');
2238: fnd_file.put_line(fnd_file.output,'');
2239: fnd_file.put_line(fnd_file.output,'');
2240: fnd_file.put_line(fnd_file.output,'');
2241: fnd_file.put_line(fnd_file.output,'');
2242:
2243: OPEN get_psdcode_details;
2244: FETCH get_psdcode_details INTO l_old_psd_code,l_new_psd_code,l_school_dsts_code,l_jurisdiction_code;

Line 2241: fnd_file.put_line(fnd_file.output,'

');

2237: fnd_file.put_line(fnd_file.output,'

Jurisdiction Code	School District Code	Old PSDCODE	New PSDCODE
New PSDCODE

');
2238: fnd_file.put_line(fnd_file.output,'');
2239: fnd_file.put_line(fnd_file.output,'');
2240: fnd_file.put_line(fnd_file.output,'');
2241: fnd_file.put_line(fnd_file.output,'');
2242:
2243: OPEN get_psdcode_details;
2244: FETCH get_psdcode_details INTO l_old_psd_code,l_new_psd_code,l_school_dsts_code,l_jurisdiction_code;
2245:

Line 2249: fnd_file.put_line(fnd_file.output,'

');

2245:
2246: WHILE (get_psdcode_details%FOUND)
2247: LOOP
2248:
2249: fnd_file.put_line(fnd_file.output,'

');
2250:
2251: FETCH get_psdcode_details INTO l_old_psd_code,l_new_psd_code,l_school_dsts_code,l_jurisdiction_code;
2252:
2253: END LOOP;

Line 2257: fnd_file.put_line(fnd_file.output,'

Jurisdiction Code	School District Code	Old PSDCODE	New PSDCODE
'\|\|l_jurisdiction_code\|\|'	'\|\|l_school_dsts_code\|\|'	'\|\|l_old_psd_code\|\|'	'\|\|l_new_psd_code\|\|'
'\|\|l_jurisdiction_code\|\|'	'\|\|l_school_dsts_code\|\|'	'\|\|l_old_psd_code\|\|'	'\|\|l_new_psd_code\|\|'

');

2253: END LOOP;
2254:
2255: CLOSE get_psdcode_details;
2256:
2257: fnd_file.put_line(fnd_file.output,'');
2258:
2259: /* Start of Employee Update related details printing*/
2260:
2261: IF p_mode = 'GENERATE' THEN

Line 2262: fnd_file.put_line(fnd_file.output,'

List down employees for whom Jurisdiction code and relevant tables are to be updated

');

2258:
2259: /* Start of Employee Update related details printing*/
2260:
2261: IF p_mode = 'GENERATE' THEN
2262: fnd_file.put_line(fnd_file.output,'

List down employees for whom Jurisdiction code and relevant tables are to be updated

');
2263: ELSE
2264: fnd_file.put_line(fnd_file.output,'

List down employees for whom Jurisdiction code and relevant tables were updated

');
2265: END IF;
2266:

Line 2264: fnd_file.put_line(fnd_file.output,'

List down employees for whom Jurisdiction code and relevant tables were updated

');

2260:
2261: IF p_mode = 'GENERATE' THEN
2262: fnd_file.put_line(fnd_file.output,'

List down employees for whom Jurisdiction code and relevant tables are to be updated

');
2263: ELSE
2264: fnd_file.put_line(fnd_file.output,'
List down employees for whom Jurisdiction code and relevant tables were updated
');
2265: END IF;
2266:
2267: fnd_file.put_line(fnd_file.output,'

Abbrevations for Table Names

');
2268: fnd_file.put_line(fnd_file.output,'');

Line 2267: fnd_file.put_line(fnd_file.output,'

Abbrevations for Table Names

');

2263: ELSE
2264: fnd_file.put_line(fnd_file.output,'

List down employees for whom Jurisdiction code and relevant tables were updated

');
2265: END IF;
2266:
2267: fnd_file.put_line(fnd_file.output,'
Abbrevations for Table Names
');
2268: fnd_file.put_line(fnd_file.output,'

');
2269: fnd_file.put_line(fnd_file.output,'');
2270: fnd_file.put_line(fnd_file.output,'');
2271: fnd_file.put_line(fnd_file.output,'');

Line 2268: fnd_file.put_line(fnd_file.output,'

Table Name	Abbrevation
PAY_US_ASG_REPORTING	PUAR
PAY_ELEMENT_ENTRY_VALUES_F	PEEV

');

2264: fnd_file.put_line(fnd_file.output,'

List down employees for whom Jurisdiction code and relevant tables were updated

');
2265: END IF;
2266:
2267: fnd_file.put_line(fnd_file.output,'

Abbrevations for Table Names

');
2268: fnd_file.put_line(fnd_file.output,'

');
2269: fnd_file.put_line(fnd_file.output,'');
2270: fnd_file.put_line(fnd_file.output,'');
2271: fnd_file.put_line(fnd_file.output,'');
2272: fnd_file.put_line(fnd_file.output,'');

Line 2269: fnd_file.put_line(fnd_file.output,'

');

2265: END IF;
2266:
2267: fnd_file.put_line(fnd_file.output,'

Abbrevations for Table Names

');
2268: fnd_file.put_line(fnd_file.output,'

Table Name	Abbrevation
PAY_US_ASG_REPORTING	PUAR
PAY_ELEMENT_ENTRY_VALUES_F	PEEV
PAY_RUN_RESULTS	PRR
Table Name	Abbrevation

');
2269: fnd_file.put_line(fnd_file.output,'');
2270: fnd_file.put_line(fnd_file.output,'');
2271: fnd_file.put_line(fnd_file.output,'');
2272: fnd_file.put_line(fnd_file.output,'');
2273: fnd_file.put_line(fnd_file.output,'');

Line 2270: fnd_file.put_line(fnd_file.output,'

');

2266:
2267: fnd_file.put_line(fnd_file.output,'

Abbrevations for Table Names

');
2268: fnd_file.put_line(fnd_file.output,'

Table Name	Abbrevation
PAY_US_ASG_REPORTING	PUAR
PAY_ELEMENT_ENTRY_VALUES_F	PEEV
PAY_RUN_RESULTS	PRR
PAY_RUN_RESULT_VALUES	PRRV
PAY_US_ASG_REPORTING	PUAR

');
2269: fnd_file.put_line(fnd_file.output,'');
2270: fnd_file.put_line(fnd_file.output,'');
2271: fnd_file.put_line(fnd_file.output,'');
2272: fnd_file.put_line(fnd_file.output,'');
2273: fnd_file.put_line(fnd_file.output,'');
2274: fnd_file.put_line(fnd_file.output,'');

Line 2271: fnd_file.put_line(fnd_file.output,'

');

2267: fnd_file.put_line(fnd_file.output,'

Abbrevations for Table Names

');
2268: fnd_file.put_line(fnd_file.output,'

Table Name	Abbrevation
PAY_US_ASG_REPORTING	PUAR
PAY_ELEMENT_ENTRY_VALUES_F	PEEV
PAY_RUN_RESULTS	PRR
PAY_RUN_RESULT_VALUES	PRRV
PAY_ACTION_INFORMATION	PAI
PAY_ELEMENT_ENTRY_VALUES_F	PEEV

');
2269: fnd_file.put_line(fnd_file.output,'');
2270: fnd_file.put_line(fnd_file.output,'');
2271: fnd_file.put_line(fnd_file.output,'');
2272: fnd_file.put_line(fnd_file.output,'');
2273: fnd_file.put_line(fnd_file.output,'');
2274: fnd_file.put_line(fnd_file.output,'');
2275: fnd_file.put_line(fnd_file.output,''); -- Added for bug 14213838.

Line 2272: fnd_file.put_line(fnd_file.output,'

');

2268: fnd_file.put_line(fnd_file.output,'

Table Name	Abbrevation
PAY_US_ASG_REPORTING	PUAR
PAY_ELEMENT_ENTRY_VALUES_F	PEEV
PAY_RUN_RESULTS	PRR
PAY_RUN_RESULT_VALUES	PRRV
PAY_ACTION_INFORMATION	PAI
FF_ARCHIVE_ITEM_CONTEXTS	FAIC
PAY_RUN_RESULTS	PRR

');
2269: fnd_file.put_line(fnd_file.output,'');
2270: fnd_file.put_line(fnd_file.output,'');
2271: fnd_file.put_line(fnd_file.output,'');
2272: fnd_file.put_line(fnd_file.output,'');
2273: fnd_file.put_line(fnd_file.output,'');
2274: fnd_file.put_line(fnd_file.output,'');
2275: fnd_file.put_line(fnd_file.output,''); -- Added for bug 14213838.
2276: fnd_file.put_line(fnd_file.output,'

Table Name	Abbrevation
PAY_US_ASG_REPORTING	PUAR
PAY_ELEMENT_ENTRY_VALUES_F	PEEV
PAY_RUN_RESULTS	PRR
PAY_RUN_RESULT_VALUES	PRRV
PAY_ACTION_INFORMATION	PAI
FF_ARCHIVE_ITEM_CONTEXTS	FAIC

');

Line 2273: fnd_file.put_line(fnd_file.output,'PAY_RUN_RESULT_VALUESPRRV');

2269: fnd_file.put_line(fnd_file.output,'Table NameAbbrevation');
2270: fnd_file.put_line(fnd_file.output,'PAY_US_ASG_REPORTINGPUAR');
2271: fnd_file.put_line(fnd_file.output,'PAY_ELEMENT_ENTRY_VALUES_FPEEV');
2272: fnd_file.put_line(fnd_file.output,'PAY_RUN_RESULTSPRR');
2273: fnd_file.put_line(fnd_file.output,'PAY_RUN_RESULT_VALUESPRRV');
2274: fnd_file.put_line(fnd_file.output,'PAY_ACTION_INFORMATIONPAI');
2275: fnd_file.put_line(fnd_file.output,'FF_ARCHIVE_ITEM_CONTEXTSFAIC'); -- Added for bug 14213838.
2276: fnd_file.put_line(fnd_file.output,'');
2277:

Line 2274: fnd_file.put_line(fnd_file.output,'PAY_ACTION_INFORMATIONPAI');

2270: fnd_file.put_line(fnd_file.output,'PAY_US_ASG_REPORTINGPUAR');
2271: fnd_file.put_line(fnd_file.output,'PAY_ELEMENT_ENTRY_VALUES_FPEEV');
2272: fnd_file.put_line(fnd_file.output,'PAY_RUN_RESULTSPRR');
2273: fnd_file.put_line(fnd_file.output,'PAY_RUN_RESULT_VALUESPRRV');
2274: fnd_file.put_line(fnd_file.output,'PAY_ACTION_INFORMATIONPAI');
2275: fnd_file.put_line(fnd_file.output,'FF_ARCHIVE_ITEM_CONTEXTSFAIC'); -- Added for bug 14213838.
2276: fnd_file.put_line(fnd_file.output,'');
2277:
2278: fnd_file.put_line(fnd_file.output,'

Update Details

');

Line 2275: fnd_file.put_line(fnd_file.output,'FF_ARCHIVE_ITEM_CONTEXTSFAIC'); -- Added for bug 14213838.

2271: fnd_file.put_line(fnd_file.output,'PAY_ELEMENT_ENTRY_VALUES_FPEEV');
2272: fnd_file.put_line(fnd_file.output,'PAY_RUN_RESULTSPRR');
2273: fnd_file.put_line(fnd_file.output,'PAY_RUN_RESULT_VALUESPRRV');
2274: fnd_file.put_line(fnd_file.output,'PAY_ACTION_INFORMATIONPAI');
2275: fnd_file.put_line(fnd_file.output,'FF_ARCHIVE_ITEM_CONTEXTSFAIC'); -- Added for bug 14213838.
2276: fnd_file.put_line(fnd_file.output,'');
2277:
2278: fnd_file.put_line(fnd_file.output,'

Update Details

');
2279: fnd_file.put_line(fnd_file.output,'');

Line 2276: fnd_file.put_line(fnd_file.output,'

');

2272: fnd_file.put_line(fnd_file.output,'PAY_RUN_RESULTSPRR');
2273: fnd_file.put_line(fnd_file.output,'PAY_RUN_RESULT_VALUESPRRV');
2274: fnd_file.put_line(fnd_file.output,'PAY_ACTION_INFORMATIONPAI');
2275: fnd_file.put_line(fnd_file.output,'FF_ARCHIVE_ITEM_CONTEXTSFAIC'); -- Added for bug 14213838.
2276: fnd_file.put_line(fnd_file.output,'');
2277:
2278: fnd_file.put_line(fnd_file.output,'

Update Details

');
2279: fnd_file.put_line(fnd_file.output,'');
2280: fnd_file.put_line(fnd_file.output,'');

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

Update Details

');

2274: fnd_file.put_line(fnd_file.output,'

');
2275: fnd_file.put_line(fnd_file.output,''); -- Added for bug 14213838.
2276: fnd_file.put_line(fnd_file.output,'

Employee Details		Jurisdiction Details		Tables Updated
PAY_ACTION_INFORMATION	PAI
FF_ARCHIVE_ITEM_CONTEXTS	FAIC

');
2277:
2278: fnd_file.put_line(fnd_file.output,'
Update Details
');
2279: fnd_file.put_line(fnd_file.output,'');
2280: fnd_file.put_line(fnd_file.output,'');
2281: fnd_file.put_line(fnd_file.output,'');
2282: fnd_file.put_line(fnd_file.output,'');

Line 2279: fnd_file.put_line(fnd_file.output,'

Employee Details		Jurisdiction Details		Tables Updated
Full Name	Assignment ID

');

2275: fnd_file.put_line(fnd_file.output,'

'); -- Added for bug 14213838.
2276: fnd_file.put_line(fnd_file.output,'

FF_ARCHIVE_ITEM_CONTEXTS

FAIC

');
2277:
2278: fnd_file.put_line(fnd_file.output,'

Update Details

');
2279: fnd_file.put_line(fnd_file.output,'');
2280: fnd_file.put_line(fnd_file.output,'');
2281: fnd_file.put_line(fnd_file.output,'');
2282: fnd_file.put_line(fnd_file.output,'');
2283: fnd_file.put_line(fnd_file.output,'');
Line 2280: fnd_file.put_line(fnd_file.output,'
');
2276: fnd_file.put_line(fnd_file.output,'

Employee Details Jurisdiction Details Tables Updated
Full Name Assignment ID Old Jurisdiction Code
Employee Details Jurisdiction Details Tables Updated
');
2277:
2278: fnd_file.put_line(fnd_file.output,'
Update Details
');
2279: fnd_file.put_line(fnd_file.output,'');
2280: fnd_file.put_line(fnd_file.output,'');
2281: fnd_file.put_line(fnd_file.output,'');
2282: fnd_file.put_line(fnd_file.output,'');
2283: fnd_file.put_line(fnd_file.output,'');
2284: fnd_file.put_line(fnd_file.output,'');
Line 2281: fnd_file.put_line(fnd_file.output,'
');
2277:
2278: fnd_file.put_line(fnd_file.output,'
Update Details
');
2279: fnd_file.put_line(fnd_file.output,'

Employee Details Jurisdiction Details Tables Updated
Full Name Assignment ID Old Jurisdiction Code New Jurisdiction Code
Full Name
');
2280: fnd_file.put_line(fnd_file.output,'');
2281: fnd_file.put_line(fnd_file.output,'');
2282: fnd_file.put_line(fnd_file.output,'');
2283: fnd_file.put_line(fnd_file.output,'');
2284: fnd_file.put_line(fnd_file.output,'');
2285: fnd_file.put_line(fnd_file.output,'');
Line 2282: fnd_file.put_line(fnd_file.output,'
');
2278: fnd_file.put_line(fnd_file.output,'
Update Details
');
2279: fnd_file.put_line(fnd_file.output,'
Employee Details Jurisdiction Details Tables Updated
Full Name Assignment ID Old Jurisdiction Code New Jurisdiction Code PUAR Assignment ID
');
2280: fnd_file.put_line(fnd_file.output,'');
2281: fnd_file.put_line(fnd_file.output,'');
2282: fnd_file.put_line(fnd_file.output,'');
2283: fnd_file.put_line(fnd_file.output,'');
2284: fnd_file.put_line(fnd_file.output,'');
2285: fnd_file.put_line(fnd_file.output,'');
2286: fnd_file.put_line(fnd_file.output,'');
Line 2283: fnd_file.put_line(fnd_file.output,'
');
2279: fnd_file.put_line(fnd_file.output,'
Employee Details Jurisdiction Details Tables Updated
Full Name Assignment ID Old Jurisdiction Code New Jurisdiction Code PUAR PEEV Old Jurisdiction Code
');
2280: fnd_file.put_line(fnd_file.output,'');
2281: fnd_file.put_line(fnd_file.output,'');
2282: fnd_file.put_line(fnd_file.output,'');
2283: fnd_file.put_line(fnd_file.output,'');
2284: fnd_file.put_line(fnd_file.output,'');
2285: fnd_file.put_line(fnd_file.output,'');
2286: fnd_file.put_line(fnd_file.output,'');
2287: fnd_file.put_line(fnd_file.output,'');
Line 2284: fnd_file.put_line(fnd_file.output,'
');
2280: fnd_file.put_line(fnd_file.output,'
');
2281: fnd_file.put_line(fnd_file.output,'');
2282: fnd_file.put_line(fnd_file.output,'');
2283: fnd_file.put_line(fnd_file.output,'');
2284: fnd_file.put_line(fnd_file.output,'');
2285: fnd_file.put_line(fnd_file.output,'');
2286: fnd_file.put_line(fnd_file.output,'');
2287: fnd_file.put_line(fnd_file.output,'');
2288: fnd_file.put_line(fnd_file.output,'');
Line 2285: fnd_file.put_line(fnd_file.output,'
');
2281: fnd_file.put_line(fnd_file.output,'
');
2282: fnd_file.put_line(fnd_file.output,'');
2283: fnd_file.put_line(fnd_file.output,'');
2284: fnd_file.put_line(fnd_file.output,'');
2285: fnd_file.put_line(fnd_file.output,'');
2286: fnd_file.put_line(fnd_file.output,'');
2287: fnd_file.put_line(fnd_file.output,'');
2288: fnd_file.put_line(fnd_file.output,'');
2289: fnd_file.put_line(fnd_file.output,'');
Line 2286: fnd_file.put_line(fnd_file.output,'
');
2282: fnd_file.put_line(fnd_file.output,'
');
2283: fnd_file.put_line(fnd_file.output,'');
2284: fnd_file.put_line(fnd_file.output,'');
2285: fnd_file.put_line(fnd_file.output,'');
2286: fnd_file.put_line(fnd_file.output,'');
2287: fnd_file.put_line(fnd_file.output,'');
2288: fnd_file.put_line(fnd_file.output,'');
2289: fnd_file.put_line(fnd_file.output,'');
2290: fnd_file.put_line(fnd_file.output,''); -- Added for bug 14213838.
Line 2287: fnd_file.put_line(fnd_file.output,'
');
2283: fnd_file.put_line(fnd_file.output,'
');
2284: fnd_file.put_line(fnd_file.output,'');
2285: fnd_file.put_line(fnd_file.output,'');
2286: fnd_file.put_line(fnd_file.output,'');
2287: fnd_file.put_line(fnd_file.output,'');
2288: fnd_file.put_line(fnd_file.output,'');
2289: fnd_file.put_line(fnd_file.output,'');
2290: fnd_file.put_line(fnd_file.output,''); -- Added for bug 14213838.
2291:
Line 2288: fnd_file.put_line(fnd_file.output,'
');
2284: fnd_file.put_line(fnd_file.output,'
');
2285: fnd_file.put_line(fnd_file.output,'');
2286: fnd_file.put_line(fnd_file.output,'');
2287: fnd_file.put_line(fnd_file.output,'');
2288: fnd_file.put_line(fnd_file.output,'');
2289: fnd_file.put_line(fnd_file.output,'');
2290: fnd_file.put_line(fnd_file.output,''); -- Added for bug 14213838.
2291:
2292: OPEN get_emp_update_details(l_id,p_mode,l_date);
Line 2289: fnd_file.put_line(fnd_file.output,'
');
2285: fnd_file.put_line(fnd_file.output,'
');
2286: fnd_file.put_line(fnd_file.output,'');
2287: fnd_file.put_line(fnd_file.output,'');
2288: fnd_file.put_line(fnd_file.output,'');
2289: fnd_file.put_line(fnd_file.output,'');
2290: fnd_file.put_line(fnd_file.output,''); -- Added for bug 14213838.
2291:
2292: OPEN get_emp_update_details(l_id,p_mode,l_date);
2293: FETCH get_emp_update_details INTO l_full_name,l_emp_assignment_id,l_old_jurisdiction_code,l_new_jurisdiction_code,l_table_name;
Line 2290: fnd_file.put_line(fnd_file.output,'
'); -- Added for bug 14213838.
2286: fnd_file.put_line(fnd_file.output,'
');
2287: fnd_file.put_line(fnd_file.output,'');
2288: fnd_file.put_line(fnd_file.output,'');
2289: fnd_file.put_line(fnd_file.output,'');
2290: fnd_file.put_line(fnd_file.output,''); -- Added for bug 14213838.
2291:
2292: OPEN get_emp_update_details(l_id,p_mode,l_date);
2293: FETCH get_emp_update_details INTO l_full_name,l_emp_assignment_id,l_old_jurisdiction_code,l_new_jurisdiction_code,l_table_name;
2294:
Line 2345: fnd_file.put_line(fnd_file.output,'
');
2341: ELSE
2342:
2343: /*New Employee/New Assignment/New Jurisdiction so print the existing employee details first*/
2344:
2345: fnd_file.put_line(fnd_file.output,'
');
2346: fnd_file.put_line(fnd_file.output,'');
2347: fnd_file.put_line(fnd_file.output,'');
2348:
2349: l_print_full_name := l_full_name;
Line 2346: fnd_file.put_line(fnd_file.output,'
');
2342:
2343: /*New Employee/New Assignment/New Jurisdiction so print the existing employee details first*/
2344:
2345: fnd_file.put_line(fnd_file.output,'
');
2346: fnd_file.put_line(fnd_file.output,'');
2347: fnd_file.put_line(fnd_file.output,'');
2348:
2349: l_print_full_name := l_full_name;
2350: l_print_emp_assignment_id := l_emp_assignment_id;
Line 2347: fnd_file.put_line(fnd_file.output,'
');
2343: /*New Employee/New Assignment/New Jurisdiction so print the existing employee details first*/
2344:
2345: fnd_file.put_line(fnd_file.output,'
');
2346: fnd_file.put_line(fnd_file.output,'');
2347: fnd_file.put_line(fnd_file.output,'');
2348:
2349: l_print_full_name := l_full_name;
2350: l_print_emp_assignment_id := l_emp_assignment_id;
2351: l_print_old_juri_code := l_old_jurisdiction_code;
Line 2396: fnd_file.put_line(fnd_file.output,'
');
2392: IF (get_emp_update_details%NOTFOUND) THEN
2393:
2394: /*No more records exist. Print the last employee details*/
2395:
2396: fnd_file.put_line(fnd_file.output,'
');
2397: fnd_file.put_line(fnd_file.output,'');
2398: fnd_file.put_line(fnd_file.output,'');
2399: END IF;
2400:
Line 2397: fnd_file.put_line(fnd_file.output,'
');
2393:
2394: /*No more records exist. Print the last employee details*/
2395:
2396: fnd_file.put_line(fnd_file.output,'
');
2397: fnd_file.put_line(fnd_file.output,'');
2398: fnd_file.put_line(fnd_file.output,'');
2399: END IF;
2400:
2401: END LOOP;
Line 2398: fnd_file.put_line(fnd_file.output,'
');
2394: /*No more records exist. Print the last employee details*/
2395:
2396: fnd_file.put_line(fnd_file.output,'
');
2397: fnd_file.put_line(fnd_file.output,'');
2398: fnd_file.put_line(fnd_file.output,'');
2399: END IF;
2400:
2401: END LOOP;
2402:
Line 2405: fnd_file.put_line(fnd_file.output,'
Employee Details Jurisdiction Details Tables Updated
Full Name Assignment ID Old Jurisdiction Code New Jurisdiction Code PUAR PEEV PRR New Jurisdiction Code
Employee Details Jurisdiction Details Tables Updated
Full Name Assignment ID Old Jurisdiction Code New Jurisdiction Code PUAR PEEV PRR PRRV PUAR
Full Name Assignment ID Old Jurisdiction Code New Jurisdiction Code PUAR PEEV PRR PRRV PAI PEEV Assignment ID Old Jurisdiction Code New Jurisdiction Code PUAR PEEV PRR PRRV PAI FAIC

PRR Old Jurisdiction Code New Jurisdiction Code PUAR PEEV PRR PRRV PAI FAIC

PRRV New Jurisdiction Code PUAR PEEV PRR PRRV PAI FAIC

PAI PUAR PEEV PRR PRRV PAI FAIC

FAIC

PEEV PRR PRRV PAI FAIC

'||l_print_full_name||' '||l_print_emp_assignment_id||' '||l_print_old_juri_code||' '||l_print_new_juri_code||'
'||l_print_full_name||' '||l_print_emp_assignment_id||' '||l_print_old_juri_code||' '||l_print_new_juri_code||' '||l_pay_us_asg_reporting||' '||l_pay_element_entry_values_f||' '||l_pay_run_results||' '||l_pay_run_result_values||' '||l_pay_action_information||' '||l_ff_archive_item_contexts||'

'||l_pay_us_asg_reporting||' '||l_pay_element_entry_values_f||' '||l_pay_run_results||' '||l_pay_run_result_values||'
'||l_print_full_name||' '||l_print_emp_assignment_id||' '||l_print_old_juri_code||' '||l_print_new_juri_code||' '||l_pay_us_asg_reporting||' '||l_pay_element_entry_values_f||' '||l_pay_run_results||' '||l_pay_run_result_values||' '||l_pay_action_information||' '||l_ff_archive_item_contexts||'

'||l_pay_action_information||' '||l_ff_archive_item_contexts||'

'||l_print_full_name||' '||l_print_emp_assignment_id||' '||l_print_old_juri_code||' '||l_print_new_juri_code||' '||l_pay_us_asg_reporting||' '||l_pay_element_entry_values_f||' '||l_pay_run_results||' '||l_pay_run_result_values||' '||l_pay_action_information||' '||l_ff_archive_item_contexts||'

'||l_print_full_name||' '||l_print_emp_assignment_id||' '||l_print_old_juri_code||' '||l_print_new_juri_code||'
'||l_print_full_name||' '||l_print_emp_assignment_id||' '||l_print_old_juri_code||' '||l_print_new_juri_code||' '||l_pay_us_asg_reporting||' '||l_pay_element_entry_values_f||' '||l_pay_run_results||' '||l_pay_run_result_values||' '||l_pay_action_information||' '||l_ff_archive_item_contexts||'

'||l_pay_us_asg_reporting||' '||l_pay_element_entry_values_f||' '||l_pay_run_results||' '||l_pay_run_result_values||'
'||l_print_full_name||' '||l_print_emp_assignment_id||' '||l_print_old_juri_code||' '||l_print_new_juri_code||' '||l_pay_us_asg_reporting||' '||l_pay_element_entry_values_f||' '||l_pay_run_results||' '||l_pay_run_result_values||' '||l_pay_action_information||' '||l_ff_archive_item_contexts||'

'||l_pay_action_information||' '||l_ff_archive_item_contexts||'

'||l_print_full_name||' '||l_print_emp_assignment_id||' '||l_print_old_juri_code||' '||l_print_new_juri_code||' '||l_pay_us_asg_reporting||' '||l_pay_element_entry_values_f||' '||l_pay_run_results||' '||l_pay_run_result_values||' '||l_pay_action_information||' '||l_ff_archive_item_contexts||'

');

2401: END LOOP;
2402:
2403: CLOSE get_emp_update_details;
2404:
2405: fnd_file.put_line(fnd_file.output,'');
2406:
2407: /* End of Employee Update related details printing*/
2408:
2409: -- Added for bug 14213838.

Line 2413: fnd_file.put_line(fnd_file.output,'
List down GREs for whom PSD Code and relevant tables are to be updated
');

2409: -- Added for bug 14213838.
2410: /* Start of GRE Update related details printing*/
2411:
2412: IF p_mode = 'GENERATE' THEN
2413: fnd_file.put_line(fnd_file.output,'
List down GREs for whom PSD Code and relevant tables are to be updated
');
2414: ELSE
2415: fnd_file.put_line(fnd_file.output,'
List down GREs for whom PSD Code and relevant tables were updated
');
2416: END IF;
2417:

Line 2415: fnd_file.put_line(fnd_file.output,'
List down GREs for whom PSD Code and relevant tables were updated
');

2411:
2412: IF p_mode = 'GENERATE' THEN
2413: fnd_file.put_line(fnd_file.output,'
List down GREs for whom PSD Code and relevant tables are to be updated
');
2414: ELSE
2415: fnd_file.put_line(fnd_file.output,'
List down GREs for whom PSD Code and relevant tables were updated
');
2416: END IF;
2417:
2418: fnd_file.put_line(fnd_file.output,'
Abbrevation for Table Name
');
2419: fnd_file.put_line(fnd_file.output,'');
Line 2418: fnd_file.put_line(fnd_file.output,'
Abbrevation for Table Name
');
2414: ELSE
2415: fnd_file.put_line(fnd_file.output,'
List down GREs for whom PSD Code and relevant tables were updated
');
2416: END IF;
2417:
2418: fnd_file.put_line(fnd_file.output,'
Abbrevation for Table Name
');
2419: fnd_file.put_line(fnd_file.output,'

');
2420: fnd_file.put_line(fnd_file.output,'');
2421: fnd_file.put_line(fnd_file.output,'');
2422: fnd_file.put_line(fnd_file.output,'
Table Name Abbrevation
HR_ORGANIZATION_INFORMATION HOI
');

Line 2419: fnd_file.put_line(fnd_file.output,'');
2415: fnd_file.put_line(fnd_file.output,'
List down GREs for whom PSD Code and relevant tables were updated
');
2416: END IF;
2417:
2418: fnd_file.put_line(fnd_file.output,'
Abbrevation for Table Name
');
2419: fnd_file.put_line(fnd_file.output,'

');
2420: fnd_file.put_line(fnd_file.output,'');
2421: fnd_file.put_line(fnd_file.output,'');
2422: fnd_file.put_line(fnd_file.output,'
Table Name Abbrevation
HR_ORGANIZATION_INFORMATION HOI
');
2423:

Line 2420: fnd_file.put_line(fnd_file.output,'Table NameAbbrevation');

2416: END IF;
2417:
2418: fnd_file.put_line(fnd_file.output,'
Abbrevation for Table Name
');
2419: fnd_file.put_line(fnd_file.output,'');
2420: fnd_file.put_line(fnd_file.output,'');
2421: fnd_file.put_line(fnd_file.output,'');
2422: fnd_file.put_line(fnd_file.output,'

Table Name Abbrevation
HR_ORGANIZATION_INFORMATION HOI
');
2423:
2424: fnd_file.put_line(fnd_file.output,'
Update Details
');

Line 2421: fnd_file.put_line(fnd_file.output,'HR_ORGANIZATION_INFORMATIONHOI');

2417:
2418: fnd_file.put_line(fnd_file.output,'
Abbrevation for Table Name
');
2419: fnd_file.put_line(fnd_file.output,'');
2420: fnd_file.put_line(fnd_file.output,'');
2421: fnd_file.put_line(fnd_file.output,'');
2422: fnd_file.put_line(fnd_file.output,'
Table Name Abbrevation

HR_ORGANIZATION_INFORMATION HOI
');
2423:
2424: fnd_file.put_line(fnd_file.output,'
Update Details
');
2425: fnd_file.put_line(fnd_file.output,'');
Line 2422: fnd_file.put_line(fnd_file.output,'

');

2418: fnd_file.put_line(fnd_file.output,'
Abbrevation for Table Name
');
2419: fnd_file.put_line(fnd_file.output,'');
2420: fnd_file.put_line(fnd_file.output,'');
2421: fnd_file.put_line(fnd_file.output,'');
2422: fnd_file.put_line(fnd_file.output,'
Table Name Abbrevation
HR_ORGANIZATION_INFORMATION HOI

');
2423:
2424: fnd_file.put_line(fnd_file.output,'
Update Details
');
2425: fnd_file.put_line(fnd_file.output,'');
2426: fnd_file.put_line(fnd_file.output,'');
Line 2424: fnd_file.put_line(fnd_file.output,'
Update Details
');
2420: fnd_file.put_line(fnd_file.output,'
');
2421: fnd_file.put_line(fnd_file.output,'');
2422: fnd_file.put_line(fnd_file.output,'
Governement Reporting Entity Details PSD Code Details Tables Updated
Table Name Abbrevation
HR_ORGANIZATION_INFORMATION HOI
');
2423:
2424: fnd_file.put_line(fnd_file.output,'
Update Details
');
2425: fnd_file.put_line(fnd_file.output,'');
2426: fnd_file.put_line(fnd_file.output,'');
2427: fnd_file.put_line(fnd_file.output,'');
2428: fnd_file.put_line(fnd_file.output,'');
Line 2425: fnd_file.put_line(fnd_file.output,'
Governement Reporting Entity Details PSD Code Details Tables Updated
GRE Name GRE ID
');
2421: fnd_file.put_line(fnd_file.output,'
');
2422: fnd_file.put_line(fnd_file.output,'

HR_ORGANIZATION_INFORMATION HOI
');
2423:
2424: fnd_file.put_line(fnd_file.output,'
Update Details
');
2425: fnd_file.put_line(fnd_file.output,'');
2426: fnd_file.put_line(fnd_file.output,'');
2427: fnd_file.put_line(fnd_file.output,'');
2428: fnd_file.put_line(fnd_file.output,'');
2429: fnd_file.put_line(fnd_file.output,'');
Line 2426: fnd_file.put_line(fnd_file.output,'
');
2422: fnd_file.put_line(fnd_file.output,'

Governement Reporting Entity Details PSD Code Details Tables Updated
GRE Name GRE ID Old PSD Code
Governement Reporting Entity Details PSD Code Details Tables Updated
');
2423:
2424: fnd_file.put_line(fnd_file.output,'
Update Details
');
2425: fnd_file.put_line(fnd_file.output,'');
2426: fnd_file.put_line(fnd_file.output,'');
2427: fnd_file.put_line(fnd_file.output,'');
2428: fnd_file.put_line(fnd_file.output,'');
2429: fnd_file.put_line(fnd_file.output,'');
2430: fnd_file.put_line(fnd_file.output,'');
Line 2427: fnd_file.put_line(fnd_file.output,'
');
2423:
2424: fnd_file.put_line(fnd_file.output,'
Update Details
');
2425: fnd_file.put_line(fnd_file.output,'

Governement Reporting Entity Details PSD Code Details Tables Updated
GRE Name GRE ID Old PSD Code New PSD Code
GRE Name
');
2426: fnd_file.put_line(fnd_file.output,'');
2427: fnd_file.put_line(fnd_file.output,'');
2428: fnd_file.put_line(fnd_file.output,'');
2429: fnd_file.put_line(fnd_file.output,'');
2430: fnd_file.put_line(fnd_file.output,'');
2431: fnd_file.put_line(fnd_file.output,'');
Line 2428: fnd_file.put_line(fnd_file.output,'
');
2424: fnd_file.put_line(fnd_file.output,'
Update Details
');
2425: fnd_file.put_line(fnd_file.output,'
Governement Reporting Entity Details PSD Code Details Tables Updated
GRE Name GRE ID Old PSD Code New PSD Code HOI

GRE ID
');
2426: fnd_file.put_line(fnd_file.output,'');
2427: fnd_file.put_line(fnd_file.output,'');
2428: fnd_file.put_line(fnd_file.output,'');
2429: fnd_file.put_line(fnd_file.output,'');
2430: fnd_file.put_line(fnd_file.output,'');
2431: fnd_file.put_line(fnd_file.output,'');
2432:
Line 2429: fnd_file.put_line(fnd_file.output,'
');
2425: fnd_file.put_line(fnd_file.output,'
Governement Reporting Entity Details PSD Code Details Tables Updated
GRE Name GRE ID Old PSD Code New PSD Code HOI

Old PSD Code
');
2426: fnd_file.put_line(fnd_file.output,'');
2427: fnd_file.put_line(fnd_file.output,'');
2428: fnd_file.put_line(fnd_file.output,'');
2429: fnd_file.put_line(fnd_file.output,'');
2430: fnd_file.put_line(fnd_file.output,'');
2431: fnd_file.put_line(fnd_file.output,'');
2432:
2433: OPEN get_gre_update_details(l_id,p_mode,l_date);
Line 2430: fnd_file.put_line(fnd_file.output,'
');
2426: fnd_file.put_line(fnd_file.output,'
');
2427: fnd_file.put_line(fnd_file.output,'');
2428: fnd_file.put_line(fnd_file.output,'');
2429: fnd_file.put_line(fnd_file.output,'');
2430: fnd_file.put_line(fnd_file.output,'');
2431: fnd_file.put_line(fnd_file.output,'');
2432:
2433: OPEN get_gre_update_details(l_id,p_mode,l_date);
2434: FETCH get_gre_update_details INTO l_gre_name, l_gre_id, l_old_jurisdiction_code,l_new_jurisdiction_code,l_table_name;
Line 2431: fnd_file.put_line(fnd_file.output,'
');
2427: fnd_file.put_line(fnd_file.output,'
');
2428: fnd_file.put_line(fnd_file.output,'');
2429: fnd_file.put_line(fnd_file.output,'');
2430: fnd_file.put_line(fnd_file.output,'');
2431: fnd_file.put_line(fnd_file.output,'');
2432:
2433: OPEN get_gre_update_details(l_id,p_mode,l_date);
2434: FETCH get_gre_update_details INTO l_gre_name, l_gre_id, l_old_jurisdiction_code,l_new_jurisdiction_code,l_table_name;
2435:
Line 2460: fnd_file.put_line(fnd_file.output,'
');
2456: ELSE
2457:
2458: /*New GRE/New PSD Code so print the existing GRE details first*/
2459:
2460: fnd_file.put_line(fnd_file.output,'
');
2461: fnd_file.put_line(fnd_file.output,'');
2462:
2463: l_print_gre_name := l_gre_name;
2464: l_print_gre_id := l_gre_id;
Line 2461: fnd_file.put_line(fnd_file.output,'
');
2457:
2458: /*New GRE/New PSD Code so print the existing GRE details first*/
2459:
2460: fnd_file.put_line(fnd_file.output,'
');
2461: fnd_file.put_line(fnd_file.output,'');
2462:
2463: l_print_gre_name := l_gre_name;
2464: l_print_gre_id := l_gre_id;
2465: l_print_old_juri_code := l_old_jurisdiction_code;
Line 2483: fnd_file.put_line(fnd_file.output,'
');
2479: IF (get_gre_update_details%NOTFOUND) THEN
2480:
2481: /*No more records exist. Print the last GRE details*/
2482:
2483: fnd_file.put_line(fnd_file.output,'
');
2484: fnd_file.put_line(fnd_file.output,'');
2485: END IF;
2486:
2487: END LOOP;
Line 2484: fnd_file.put_line(fnd_file.output,'
');
2480:
2481: /*No more records exist. Print the last GRE details*/
2482:
2483: fnd_file.put_line(fnd_file.output,'
');
2484: fnd_file.put_line(fnd_file.output,'');
2485: END IF;
2486:
2487: END LOOP;
2488:
Line 2491: fnd_file.put_line(fnd_file.output,'
Governement Reporting Entity Details PSD Code Details Tables Updated
GRE Name GRE ID Old PSD Code New PSD Code HOI

New PSD Code
Governement Reporting Entity Details PSD Code Details Tables Updated
GRE Name GRE ID Old PSD Code New PSD Code HOI

HOI

GRE Name GRE ID Old PSD Code New PSD Code HOI

'||l_print_gre_name||' '||l_print_gre_id||' '||l_print_old_juri_code||' '||l_print_new_juri_code||'
'||l_print_gre_name||' '||l_print_gre_id||' '||l_print_old_juri_code||' '||l_print_new_juri_code||' '||l_hr_organization_information||'

'||l_hr_organization_information||'

'||l_print_gre_name||' '||l_print_gre_id||' '||l_print_old_juri_code||' '||l_print_new_juri_code||' '||l_hr_organization_information||'

'||l_print_gre_name||' '||l_print_gre_id||' '||l_print_old_juri_code||' '||l_print_new_juri_code||'
'||l_print_gre_name||' '||l_print_gre_id||' '||l_print_old_juri_code||' '||l_print_new_juri_code||' '||l_hr_organization_information||'

'||l_hr_organization_information||'

'||l_print_gre_name||' '||l_print_gre_id||' '||l_print_old_juri_code||' '||l_print_new_juri_code||' '||l_hr_organization_information||'

');

2487: END LOOP;
2488:
2489: CLOSE get_gre_update_details;
2490:
2491: fnd_file.put_line(fnd_file.output,'');
2492:
2493: /* End of GRE Information Update related details printing*/
2494:
2495: IF p_mode = 'UPGRADE' AND l_upgrade_needed = 'Y' THEN

Line 2502: fnd_file.put_line(fnd_file.output,'
Employees for which processing ended in error
');

2498:
2499: OPEN get_emp_in_error(l_id,p_mode,l_date);
2500: FETCH get_emp_in_error INTO l_full_name,l_emp_assignment_id;
2501:
2502: fnd_file.put_line(fnd_file.output,'
Employees for which processing ended in error
');
2503:
2504: IF get_emp_in_error%FOUND THEN
2505:
2506: fnd_file.put_line(fnd_file.output,'');
Line 2506: fnd_file.put_line(fnd_file.output,'

');
2502: fnd_file.put_line(fnd_file.output,'
Employees for which processing ended in error
');
2503:
2504: IF get_emp_in_error%FOUND THEN
2505:
2506: fnd_file.put_line(fnd_file.output,'

');
2507: fnd_file.put_line(fnd_file.output,'');
2508: fnd_file.put_line(fnd_file.output,'');
2509:
2510: WHILE (get_emp_in_error%FOUND)
Line 2507: fnd_file.put_line(fnd_file.output,'
');
2503:
2504: IF get_emp_in_error%FOUND THEN
2505:
2506: fnd_file.put_line(fnd_file.output,'
Employee Details
Full Name Assignment ID

Employee Details
');
2507: fnd_file.put_line(fnd_file.output,'');
2508: fnd_file.put_line(fnd_file.output,'');
2509:
2510: WHILE (get_emp_in_error%FOUND)
2511: LOOP
Line 2508: fnd_file.put_line(fnd_file.output,'
');
2504: IF get_emp_in_error%FOUND THEN
2505:
2506: fnd_file.put_line(fnd_file.output,'

Employee Details
Full Name Assignment ID

Full Name Assignment ID

');
2507: fnd_file.put_line(fnd_file.output,'');
2508: fnd_file.put_line(fnd_file.output,'');
2509:
2510: WHILE (get_emp_in_error%FOUND)
2511: LOOP
2512:
Line 2513: fnd_file.put_line(fnd_file.output,'
');
2509:
2510: WHILE (get_emp_in_error%FOUND)
2511: LOOP
2512:
2513: fnd_file.put_line(fnd_file.output,'
');
2514: FETCH get_emp_in_error INTO l_full_name,l_emp_assignment_id;
2515:
2516: END LOOP;
2517:
Line 2518: fnd_file.put_line(fnd_file.output,'
Employee Details
Full Name Assignment ID

'||l_full_name||' '||l_emp_assignment_id||'

'||l_full_name||' '||l_emp_assignment_id||'

');

2514: FETCH get_emp_in_error INTO l_full_name,l_emp_assignment_id;
2515:
2516: END LOOP;
2517:
2518: fnd_file.put_line(fnd_file.output,'');
2519:
2520: ELSE
2521:
2522: fnd_file.put_line(fnd_file.output,'
No Assignments in Error
');

Line 2522: fnd_file.put_line(fnd_file.output,'
No Assignments in Error
');

2518: fnd_file.put_line(fnd_file.output,'');
2519:
2520: ELSE
2521:
2522: fnd_file.put_line(fnd_file.output,'
No Assignments in Error
');
2523:
2524: END IF;
2525:
2526: CLOSE get_emp_in_error;

Line 2536: fnd_file.put_line(fnd_file.output,'
Government Reporting Entities for which processing ended in error
');

2532:
2533: OPEN get_gre_in_error(l_id,p_mode,l_date);
2534: FETCH get_gre_in_error INTO l_gre_name,l_gre_id;
2535:
2536: fnd_file.put_line(fnd_file.output,'
Government Reporting Entities for which processing ended in error
');
2537:
2538: IF get_gre_in_error%FOUND THEN
2539:
2540: fnd_file.put_line(fnd_file.output,'');
Line 2540: fnd_file.put_line(fnd_file.output,'

');
2536: fnd_file.put_line(fnd_file.output,'
Government Reporting Entities for which processing ended in error
');
2537:
2538: IF get_gre_in_error%FOUND THEN
2539:
2540: fnd_file.put_line(fnd_file.output,'

');
2541: fnd_file.put_line(fnd_file.output,'');
2542: fnd_file.put_line(fnd_file.output,'');
2543:
2544: WHILE (get_gre_in_error%FOUND)
Line 2541: fnd_file.put_line(fnd_file.output,'
');
2537:
2538: IF get_gre_in_error%FOUND THEN
2539:
2540: fnd_file.put_line(fnd_file.output,'
GRE Details
GRE Name GRE ID

GRE Details
');
2541: fnd_file.put_line(fnd_file.output,'');
2542: fnd_file.put_line(fnd_file.output,'');
2543:
2544: WHILE (get_gre_in_error%FOUND)
2545: LOOP
Line 2542: fnd_file.put_line(fnd_file.output,'
');
2538: IF get_gre_in_error%FOUND THEN
2539:
2540: fnd_file.put_line(fnd_file.output,'

GRE Details
GRE Name GRE ID

GRE Name GRE ID

');
2541: fnd_file.put_line(fnd_file.output,'');
2542: fnd_file.put_line(fnd_file.output,'');
2543:
2544: WHILE (get_gre_in_error%FOUND)
2545: LOOP
2546:
Line 2547: fnd_file.put_line(fnd_file.output,'
');
2543:
2544: WHILE (get_gre_in_error%FOUND)
2545: LOOP
2546:
2547: fnd_file.put_line(fnd_file.output,'
');
2548: FETCH get_gre_in_error INTO l_gre_name,l_gre_id;
2549:
2550: END LOOP;
2551:
Line 2552: fnd_file.put_line(fnd_file.output,'
GRE Details
GRE Name GRE ID

'||l_gre_name||' '||l_gre_id||'

'||l_gre_name||' '||l_gre_id||'

');

2548: FETCH get_gre_in_error INTO l_gre_name,l_gre_id;
2549:
2550: END LOOP;
2551:
2552: fnd_file.put_line(fnd_file.output,'');
2553:
2554: ELSE
2555:
2556: fnd_file.put_line(fnd_file.output,'
No GREs in Error
');

Line 2556: fnd_file.put_line(fnd_file.output,'
No GREs in Error
');

2552: fnd_file.put_line(fnd_file.output,'');
2553:
2554: ELSE
2555:
2556: fnd_file.put_line(fnd_file.output,'
No GREs in Error
');
2557:
2558: END IF;
2559:
2560: CLOSE get_gre_in_error;

Line 2568: fnd_file.put_line(fnd_file.output,'
Summary
');

2564: END IF;
2565:
2566: /*Start printing Summary Section*/
2567:
2568: fnd_file.put_line(fnd_file.output,'
Summary
');
2569:
2570: /* Printing Assignments Summary */
2571:
2572: OPEN get_emp_counts(l_id,p_mode,l_date,'ALL');

Line 2576: fnd_file.put_line(fnd_file.output,'
Number of Assignments identified for Upgrade : '||l_total_assignments||'
');

2572: OPEN get_emp_counts(l_id,p_mode,l_date,'ALL');
2573: FETCH get_emp_counts INTO l_total_assignments;
2574: CLOSE get_emp_counts;
2575:
2576: fnd_file.put_line(fnd_file.output,'
Number of Assignments identified for Upgrade : '||l_total_assignments||'
');
2577:
2578: IF p_mode = 'UPGRADE' THEN
2579:
2580: /* Print the Number of Employees processed*/

Line 2592: fnd_file.put_line(fnd_file.output,'
Number of Assignments Upgraded successfully : '||l_success_assignments||'
');

2588: CLOSE get_emp_counts;
2589:
2590: l_not_process_assignments := l_total_assignments - l_success_assignments - l_error_assignments;
2591:
2592: fnd_file.put_line(fnd_file.output,'
Number of Assignments Upgraded successfully : '||l_success_assignments||'
');
2593: fnd_file.put_line(fnd_file.output,'
Number of Assignments ended in Error : '||l_error_assignments||'
');
2594: fnd_file.put_line(fnd_file.output,'
Number of Assignments yet to be processed : '||l_not_process_assignments||'
');
2595:
2596: /* End of Printing the Number of Employees processed*/

Line 2593: fnd_file.put_line(fnd_file.output,'
Number of Assignments ended in Error : '||l_error_assignments||'
');

2589:
2590: l_not_process_assignments := l_total_assignments - l_success_assignments - l_error_assignments;
2591:
2592: fnd_file.put_line(fnd_file.output,'
Number of Assignments Upgraded successfully : '||l_success_assignments||'
');
2593: fnd_file.put_line(fnd_file.output,'
Number of Assignments ended in Error : '||l_error_assignments||'
');
2594: fnd_file.put_line(fnd_file.output,'
Number of Assignments yet to be processed : '||l_not_process_assignments||'
');
2595:
2596: /* End of Printing the Number of Employees processed*/
2597:

Line 2594: fnd_file.put_line(fnd_file.output,'
Number of Assignments yet to be processed : '||l_not_process_assignments||'
');

2590: l_not_process_assignments := l_total_assignments - l_success_assignments - l_error_assignments;
2591:
2592: fnd_file.put_line(fnd_file.output,'
Number of Assignments Upgraded successfully : '||l_success_assignments||'
');
2593: fnd_file.put_line(fnd_file.output,'
Number of Assignments ended in Error : '||l_error_assignments||'
');
2594: fnd_file.put_line(fnd_file.output,'
Number of Assignments yet to be processed : '||l_not_process_assignments||'
');
2595:
2596: /* End of Printing the Number of Employees processed*/
2597:
2598: END IF;

Line 2607: fnd_file.put_line(fnd_file.output,'
Number of GREs identified for Upgrade : '||l_total_gre_changes||'
');

2603: OPEN get_gre_counts(l_id,p_mode,l_date,'ALL');
2604: FETCH get_gre_counts INTO l_total_gre_changes;
2605: CLOSE get_gre_counts;
2606:
2607: fnd_file.put_line(fnd_file.output,'
Number of GREs identified for Upgrade : '||l_total_gre_changes||'
');
2608:
2609: IF p_mode = 'UPGRADE' THEN
2610:
2611: /* Print the Number of GREs processed*/

Line 2623: fnd_file.put_line(fnd_file.output,'
Number of GREs Upgraded successfully : '||l_success_gre_changes||'
');

2619: CLOSE get_gre_counts;
2620:
2621: l_not_process_gre_changes := l_total_gre_changes - l_success_gre_changes - l_error_gre_changes;
2622:
2623: fnd_file.put_line(fnd_file.output,'
Number of GREs Upgraded successfully : '||l_success_gre_changes||'
');
2624: fnd_file.put_line(fnd_file.output,'
Number of GREs ended in Error : '||l_error_gre_changes||'
');
2625: fnd_file.put_line(fnd_file.output,'
Number of GREs yet to be processed : '||l_not_process_gre_changes||'
');
2626:
2627: /* End of Printing the Number of GREs processed*/

Line 2624: fnd_file.put_line(fnd_file.output,'
Number of GREs ended in Error : '||l_error_gre_changes||'
');

2620:
2621: l_not_process_gre_changes := l_total_gre_changes - l_success_gre_changes - l_error_gre_changes;
2622:
2623: fnd_file.put_line(fnd_file.output,'
Number of GREs Upgraded successfully : '||l_success_gre_changes||'
');
2624: fnd_file.put_line(fnd_file.output,'
Number of GREs ended in Error : '||l_error_gre_changes||'
');
2625: fnd_file.put_line(fnd_file.output,'
Number of GREs yet to be processed : '||l_not_process_gre_changes||'
');
2626:
2627: /* End of Printing the Number of GREs processed*/
2628: END IF;

Line 2625: fnd_file.put_line(fnd_file.output,'
Number of GREs yet to be processed : '||l_not_process_gre_changes||'
');

2621: l_not_process_gre_changes := l_total_gre_changes - l_success_gre_changes - l_error_gre_changes;
2622:
2623: fnd_file.put_line(fnd_file.output,'
Number of GREs Upgraded successfully : '||l_success_gre_changes||'
');
2624: fnd_file.put_line(fnd_file.output,'
Number of GREs ended in Error : '||l_error_gre_changes||'
');
2625: fnd_file.put_line(fnd_file.output,'
Number of GREs yet to be processed : '||l_not_process_gre_changes||'
');
2626:
2627: /* End of Printing the Number of GREs processed*/
2628: END IF;
2629:

Line 2648: fnd_file.put_line(fnd_file.output,'
Employer PSD Codes related data in FF_ARCHIVE_ITEMS table has been successfully updated
');

2644: and l_total_gre_changes = l_success_gre_changes
2645: and l_total_ff_arch_changes = l_success_ff_arch_changes) THEN
2646:
2647: IF(l_total_ff_arch_changes<>0) THEN
2648: fnd_file.put_line(fnd_file.output,'
Employer PSD Codes related data in FF_ARCHIVE_ITEMS table has been successfully updated
');
2649: END IF;
2650:
2651: fnd_file.put_line(fnd_file.output,'
Upgrade Process completed successfully
');
2652:

Line 2651: fnd_file.put_line(fnd_file.output,'
Upgrade Process completed successfully
');

2647: IF(l_total_ff_arch_changes<>0) THEN
2648: fnd_file.put_line(fnd_file.output,'
Employer PSD Codes related data in FF_ARCHIVE_ITEMS table has been successfully updated
');
2649: END IF;
2650:
2651: fnd_file.put_line(fnd_file.output,'
Upgrade Process completed successfully
');
2652:
2653: ELSE
2654: IF(l_error_ff_arch_changes<>0) THEN
2655: fnd_file.put_line(fnd_file.output,'
Employer PSD Codes related data in FF_ARCHIVE_ITEMS table not updated successfully
');

Line 2655: fnd_file.put_line(fnd_file.output,'
Employer PSD Codes related data in FF_ARCHIVE_ITEMS table not updated successfully
');

2651: fnd_file.put_line(fnd_file.output,'
Upgrade Process completed successfully
');
2652:
2653: ELSE
2654: IF(l_error_ff_arch_changes<>0) THEN
2655: fnd_file.put_line(fnd_file.output,'
Employer PSD Codes related data in FF_ARCHIVE_ITEMS table not updated successfully
');
2656: END IF;
2657:
2658: fnd_file.put_line(fnd_file.output,'
Upgrade Process incomplete.Verify assignments/GREs in error and rerun the Upgrade process
');
2659:

Line 2658: fnd_file.put_line(fnd_file.output,'
Upgrade Process incomplete.Verify assignments/GREs in error and rerun the Upgrade process
');

2654: IF(l_error_ff_arch_changes<>0) THEN
2655: fnd_file.put_line(fnd_file.output,'
Employer PSD Codes related data in FF_ARCHIVE_ITEMS table not updated successfully
');
2656: END IF;
2657:
2658: fnd_file.put_line(fnd_file.output,'
Upgrade Process incomplete.Verify assignments/GREs in error and rerun the Upgrade process
');
2659:
2660: END IF;
2661:
2662: ELSE

Line 2664: fnd_file.put_line(fnd_file.output,'
Generate Process completed successfully
');

2660: END IF;
2661:
2662: ELSE
2663:
2664: fnd_file.put_line(fnd_file.output,'
Generate Process completed successfully
');
2665:
2666: END IF;
2667:
2668: /* End of Summary section */

Line 2672: fnd_file.put_line(fnd_file.output,'
No PSDCODE Changes found that need upgrade
');

2668: /* End of Summary section */
2669:
2670: ELSE
2671:
2672: fnd_file.put_line(fnd_file.output,'
No PSDCODE Changes found that need upgrade
');
2673: fnd_file.put_line(fnd_file.output,'
No Processing required
');
2674:
2675: END IF; /* l_upgrade_needed IF*/
2676:

Line 2673: fnd_file.put_line(fnd_file.output,'
No Processing required
');

2669:
2670: ELSE
2671:
2672: fnd_file.put_line(fnd_file.output,'
No PSDCODE Changes found that need upgrade
');
2673: fnd_file.put_line(fnd_file.output,'
No Processing required
');
2674:
2675: END IF; /* l_upgrade_needed IF*/
2676:
2677: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.generate_output');

Balance Name	Dimension Name
'\|\|l_balance_name\|\|'
'\|\|l_balance_name\|\|'	'\|\|l_dimension_name\|\|'
'\|\|l_dimension_name\|\|'
'\|\|l_balance_name\|\|'	'\|\|l_dimension_name\|\|'

Business Group ID	Business Group Name
'\|\|l_business_group_id\|\|'
'\|\|l_business_group_id\|\|'	'\|\|l_business_group_name\|\|'
'\|\|l_business_group_name\|\|'
'\|\|l_business_group_id\|\|'	'\|\|l_business_group_name\|\|'

Jurisdiction Code	School District Code	Old PSDCODE	New PSDCODE
'\|\|l_jurisdiction_code\|\|'	'\|\|l_school_dsts_code\|\|'	'\|\|l_old_psd_code\|\|'	'\|\|l_new_psd_code\|\|'
'\|\|l_jurisdiction_code\|\|'	'\|\|l_school_dsts_code\|\|'	'\|\|l_old_psd_code\|\|'	'\|\|l_new_psd_code\|\|'

Employee Details		Jurisdiction Details		Tables Updated
Full Name	Assignment ID	Old Jurisdiction Code
Employee Details		Jurisdiction Details		Tables Updated

Governement Reporting Entity Details		PSD Code Details		Tables Updated
GRE Name	GRE ID	Old PSD Code
Governement Reporting Entity Details		PSD Code Details		Tables Updated

Employee Details
Full Name	Assignment ID
'\|\|l_full_name\|\|'	'\|\|l_emp_assignment_id\|\|'
'\|\|l_full_name\|\|'	'\|\|l_emp_assignment_id\|\|'

GRE Details
GRE Name	GRE ID
'\|\|l_gre_name\|\|'	'\|\|l_gre_id\|\|'
'\|\|l_gre_name\|\|'	'\|\|l_gre_id\|\|'

APPS.PAY_US_PSD_UPGRADE_PKG dependencies on FND_FILE

Line 225: fnd_file.put_line(fnd_file.log,'UPGRADE Mode can be executed only after running the process in GENERATE Mode successfully.');

Line 226: fnd_file.put_line(fnd_file.log,'Not able to find the PAY_PATCH_STATUS entry corresponding to GENERATE Mode execution.');

Line 260: fnd_file.put_line(fnd_file.log,'Inconsistent state of Upgrade Process. Raise error');

Line 261: fnd_file.put_line(fnd_file.log,'Too Many rows of Upgrade Process found');

Line 291: fnd_file.put_line(fnd_file.log,'Incomplete Upgrade Run Exists. Run the Process in UPGRADE mode');

Line 419: fnd_file.put_line(fnd_file.log,'PSDCODE changes entries found for Upgrade');

Line 420: fnd_file.put_line(fnd_file.log,'Processing required');

Line 445: fnd_file.put_line(fnd_file.log,'No PSDCODE changes entries for Upgrade');

Line 446: fnd_file.put_line(fnd_file.log,'No Processing required');

Line 996: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_psd_upgrade_pkg.generate_assignment for Assignment ID '||p_assignment_id);

Line 997: fnd_file.put_line(fnd_file.log,'SQLERRM = ' || SQLERRM);

Line 1163: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_psd_upgrade_pkg.upgrade_assignment for Assignment ID '||p_assignment_id);

Line 1408: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_psd_upgrade_pkg.action_creation');

Line 1409: fnd_file.put_line(fnd_file.log,sqlerrm);

Line 1496: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_psd_upgrade_pkg.archive_code for Assignment Action ID '||p_xfr_action_id);

Line 1497: fnd_file.put_line(fnd_file.log,'Error '||sqlerrm);

Line 1598: fnd_file.put_line(fnd_file.output,'

Run Balance Invalidation

Run Balance Invalidation

Line 1602: fnd_file.put_line(fnd_file.output,' Run Balances related to below listed Defined Balances will be invalidated.');

Run Balance Invalidation

Line 1603: fnd_file.put_line(fnd_file.output,' Need to Run Generate Run Balances Concurrent Program to regenerate them after UPRADE Mode Run. ');

Line 1607: fnd_file.put_line(fnd_file.output,' Run Balances related to below listed Defined Balances are invalidated.');

Line 1608: fnd_file.put_line(fnd_file.output,' Need to Run Generate Run Balances Concurrent Program to regenerate them.');

Line 1612: fnd_file.put_line(fnd_file.output,'

Line 1613: fnd_file.put_line(fnd_file.output,'

Line 1614: fnd_file.put_line(fnd_file.output,'

Line 1622: fnd_file.put_line(fnd_file.output,'

Line 1623: fnd_file.put_line(fnd_file.output,'

Line 1629: fnd_file.put_line(fnd_file.output,'

Line 1635: fnd_file.put_line(fnd_file.output,' Below table indicates the Business Groups for which Run Balances will be invalidated. ');

Line 1639: fnd_file.put_line(fnd_file.output,' Below table indicates the Business Groups for which Run Balances are invalidated. ');

Line 1643: fnd_file.put_line(fnd_file.output,'

Line 1644: fnd_file.put_line(fnd_file.output,'

Line 1645: fnd_file.put_line(fnd_file.output,'

Line 1654: fnd_file.put_line(fnd_file.output,'

Line 1655: fnd_file.put_line(fnd_file.output,'

Line 2221: fnd_file.put_line(fnd_file.output,'PSDCODE Upgrade Details');

PSDCODE Upgrade Details

Line 2222: fnd_file.put_line(fnd_file.output,'

PSDCODE Upgrade Details

PSDCODE Upgrade Details

Line 2234: fnd_file.put_line(fnd_file.output,' Process Date : '||to_char(l_date,'DD-MON-YYYY HH:MM:SS')||' ');

List of PSDCODES that needs upgrade

Line 2235: fnd_file.put_line(fnd_file.output,' Process Mode : '||p_mode||' ');

List of PSDCODES that needs upgrade

Line 2236: fnd_file.put_line(fnd_file.output,'

List of PSDCODES that needs upgrade

List of PSDCODES that needs upgrade

Line 2237: fnd_file.put_line(fnd_file.output,'

List of PSDCODES that needs upgrade

Line 2238: fnd_file.put_line(fnd_file.output,'

List of PSDCODES that needs upgrade

Line 2239: fnd_file.put_line(fnd_file.output,'

List of PSDCODES that needs upgrade

Line 2240: fnd_file.put_line(fnd_file.output,'

List of PSDCODES that needs upgrade

Line 2241: fnd_file.put_line(fnd_file.output,'

Line 2249: fnd_file.put_line(fnd_file.output,'

Line 2257: fnd_file.put_line(fnd_file.output,'

Line 2262: fnd_file.put_line(fnd_file.output,'

List down employees for whom Jurisdiction code and relevant tables are to be updated

List down employees for whom Jurisdiction code and relevant tables are to be updated

List down employees for whom Jurisdiction code and relevant tables were updated

Line 2264: fnd_file.put_line(fnd_file.output,'

List down employees for whom Jurisdiction code and relevant tables were updated

List down employees for whom Jurisdiction code and relevant tables are to be updated

List down employees for whom Jurisdiction code and relevant tables were updated

Abbrevations for Table Names

Line 2267: fnd_file.put_line(fnd_file.output,'

Abbrevations for Table Names

List down employees for whom Jurisdiction code and relevant tables were updated

Abbrevations for Table Names

Line 2268: fnd_file.put_line(fnd_file.output,'

List down employees for whom Jurisdiction code and relevant tables were updated

Abbrevations for Table Names

Line 2269: fnd_file.put_line(fnd_file.output,'

Abbrevations for Table Names

Line 2270: fnd_file.put_line(fnd_file.output,'

Line 1602: fnd_file.put_line(fnd_file.output,'
Run Balances related to below listed Defined Balances will be invalidated.
');

Line 1603: fnd_file.put_line(fnd_file.output,'
Need to Run Generate Run Balances Concurrent Program to regenerate them after UPRADE Mode Run.
');

Line 1607: fnd_file.put_line(fnd_file.output,'
Run Balances related to below listed Defined Balances are invalidated.
');

Line 1608: fnd_file.put_line(fnd_file.output,'
Need to Run Generate Run Balances Concurrent Program to regenerate them.
');

Line 1635: fnd_file.put_line(fnd_file.output,'
Below table indicates the Business Groups for which Run Balances will be invalidated.
');

Line 1639: fnd_file.put_line(fnd_file.output,'
Below table indicates the Business Groups for which Run Balances are invalidated.
');

Line 2234: fnd_file.put_line(fnd_file.output,'
Process Date : '||to_char(l_date,'DD-MON-YYYY HH:MM:SS')||'
');

Line 2235: fnd_file.put_line(fnd_file.output,'
Process Mode : '||p_mode||'
');