APPS.PAY_US_USER_CITY_UPGRADE_PKG dependencies on FND_FILE
Line 45: fnd_file.put_line(fnd_file.log,'User Defined City changes entries found for Upgrade');
41:
42: hr_utility.trace('User Defined City changes entries found for Upgrade');
43: hr_utility.trace('Processing required');
44: 45: fnd_file.put_line(fnd_file.log,'User Defined City changes entries found for Upgrade'); 46: fnd_file.put_line(fnd_file.log,'Processing required');
47:
48: hr_utility.trace('Start of Initial Setup');
49:
Line 46: fnd_file.put_line(fnd_file.log,'Processing required');
42: hr_utility.trace('User Defined City changes entries found for Upgrade');
43: hr_utility.trace('Processing required');
44:
45: fnd_file.put_line(fnd_file.log,'User Defined City changes entries found for Upgrade'); 46: fnd_file.put_line(fnd_file.log,'Processing required'); 47:
48: hr_utility.trace('Start of Initial Setup');
49:
50: /*Get the MODE of Execution for the User Defined City Upgrade Process*/
Line 125: fnd_file.put_line(fnd_file.log,'Created PAY_PATCH_STATUS Entry with ID :'||l_id);
121: AND pumg.process_type = 'D'
122: AND pumg.patch_name = l_patch_name);
123:
124: hr_utility.trace('Created PAY_PATCH_STATUS Entry with ID :'||l_id); 125: fnd_file.put_line(fnd_file.log,'Created PAY_PATCH_STATUS Entry with ID :'||l_id); 126:
127: sqlstr := ' SELECT DISTINCT paf.person_id
128: FROM per_all_assignments_f paf,
129: pay_us_emp_city_tax_rules_f pect,
Line 152: fnd_file.put_line(fnd_file.log,'No User Defined City changes entries for Upgrade');
148:
149: hr_utility.trace('No User Defined City changes entries for Upgrade');
150: hr_utility.trace('No Processing required');
151: 152: fnd_file.put_line(fnd_file.log,'No User Defined City changes entries for Upgrade'); 153: fnd_file.put_line(fnd_file.log,'No Processing required');
154:
155: sqlstr := ' SELECT distinct paf.person_id
156: FROM per_all_assignments_f paf
Line 153: fnd_file.put_line(fnd_file.log,'No Processing required');
149: hr_utility.trace('No User Defined City changes entries for Upgrade');
150: hr_utility.trace('No Processing required');
151:
152: fnd_file.put_line(fnd_file.log,'No User Defined City changes entries for Upgrade'); 153: fnd_file.put_line(fnd_file.log,'No Processing required'); 154:
155: sqlstr := ' SELECT distinct paf.person_id
156: FROM per_all_assignments_f paf
157: WHERE 1=2
Line 171: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_user_city_upgrade_pkg.range_cursor');
167: EXCEPTION
168:
169: WHEN OTHERS THEN
170: 171: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_user_city_upgrade_pkg.range_cursor'); 172: fnd_file.put_line(fnd_file.log,'Error '||sqlerrm);
173: hr_utility.raise_error;
174:
175: END range_cursor;
Line 172: fnd_file.put_line(fnd_file.log,'Error '||sqlerrm);
168:
169: WHEN OTHERS THEN
170:
171: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_user_city_upgrade_pkg.range_cursor'); 172: fnd_file.put_line(fnd_file.log,'Error '||sqlerrm); 173: hr_utility.raise_error;
174:
175: END range_cursor;
176:
Line 251: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_user_city_upgrade_pkg.action_creation');
247:
248: WHEN OTHERS THEN
249:
250: hr_utility.trace('Exception raised in pay_us_user_city_upgrade_pkg.action_creation'); 251: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_user_city_upgrade_pkg.action_creation'); 252: fnd_file.put_line(fnd_file.log,sqlerrm);
253: hr_utility.raise_error;
254:
255: END action_creation;
Line 252: fnd_file.put_line(fnd_file.log,sqlerrm);
248: WHEN OTHERS THEN
249:
250: hr_utility.trace('Exception raised in pay_us_user_city_upgrade_pkg.action_creation');
251: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_user_city_upgrade_pkg.action_creation'); 252: fnd_file.put_line(fnd_file.log,sqlerrm); 253: hr_utility.raise_error;
254:
255: END action_creation;
256:
Line 321: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_user_city_upgrade_pkg.archive_code');
317: EXCEPTION
318:
319: WHEN OTHERS THEN
320: 321: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_user_city_upgrade_pkg.archive_code'); 322: fnd_file.put_line(fnd_file.log,'Assignment Action ID : '||p_xfr_action_id);
323: fnd_file.put_line(fnd_file.log,'Assignment ID : '||l_assignment_id);
324: fnd_file.put_line(fnd_file.log,'Error '||sqlerrm);
325: hr_utility.raise_error;
Line 322: fnd_file.put_line(fnd_file.log,'Assignment Action ID : '||p_xfr_action_id);
318:
319: WHEN OTHERS THEN
320:
321: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_user_city_upgrade_pkg.archive_code'); 322: fnd_file.put_line(fnd_file.log,'Assignment Action ID : '||p_xfr_action_id); 323: fnd_file.put_line(fnd_file.log,'Assignment ID : '||l_assignment_id);
324: fnd_file.put_line(fnd_file.log,'Error '||sqlerrm);
325: hr_utility.raise_error;
326:
Line 323: fnd_file.put_line(fnd_file.log,'Assignment ID : '||l_assignment_id);
319: WHEN OTHERS THEN
320:
321: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_user_city_upgrade_pkg.archive_code');
322: fnd_file.put_line(fnd_file.log,'Assignment Action ID : '||p_xfr_action_id); 323: fnd_file.put_line(fnd_file.log,'Assignment ID : '||l_assignment_id); 324: fnd_file.put_line(fnd_file.log,'Error '||sqlerrm);
325: hr_utility.raise_error;
326:
327: END archive_code;
Line 324: fnd_file.put_line(fnd_file.log,'Error '||sqlerrm);
320:
321: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_user_city_upgrade_pkg.archive_code');
322: fnd_file.put_line(fnd_file.log,'Assignment Action ID : '||p_xfr_action_id);
323: fnd_file.put_line(fnd_file.log,'Assignment ID : '||l_assignment_id); 324: fnd_file.put_line(fnd_file.log,'Error '||sqlerrm); 325: hr_utility.raise_error;
326:
327: END archive_code;
328:
Line 611: fnd_file.put_line(fnd_file.log,'User Defined City Upgrade Process completed in error.');
607: AND id = l_id
608: AND status = 'P'
609: AND description = l_mode;
610: 611: fnd_file.put_line(fnd_file.log,'User Defined City Upgrade Process completed in error.'); 612: hr_utility.raise_error;
613:
614: END IF; /*l_total_assignments = l_success_assignments IF*/
615:
Line 631: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_user_city_upgrade_pkg.deinitialization');
627:
628: WHEN OTHERS THEN
629:
630: hr_utility.trace('Exception raised in pay_us_user_city_upgrade_pkg.deinitialization'); 631: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_user_city_upgrade_pkg.deinitialization'); 632: fnd_file.put_line(fnd_file.log,sqlerrm);
633: hr_utility.raise_error;
634:
635: END deinitialization;
Line 632: fnd_file.put_line(fnd_file.log,sqlerrm);
628: WHEN OTHERS THEN
629:
630: hr_utility.trace('Exception raised in pay_us_user_city_upgrade_pkg.deinitialization');
631: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_user_city_upgrade_pkg.deinitialization'); 632: fnd_file.put_line(fnd_file.log,sqlerrm); 633: hr_utility.raise_error;
634:
635: END deinitialization;
636:
Line 782: fnd_file.put_line(fnd_file.output,'User Defined City Upgrade Details');
778: BEGIN
779:
780: hr_utility.trace('Entering pay_us_user_city_upgrade_pkg.generate_output');
781: 782: fnd_file.put_line(fnd_file.output,'User Defined City Upgrade Details'); 783: fnd_file.put_line(fnd_file.output,'
'); 929:
930: /* Print the Number of Employees processed*/
931:
932: OPEN get_emp_counts(l_id,p_mode,'C',l_process_type);
Line 940: fnd_file.put_line(fnd_file.output,'
Number of Assignments Upgraded successfully : '||l_success_assignments||'
');
936: OPEN get_emp_counts(l_id,p_mode,'E',l_process_type);
937: FETCH get_emp_counts INTO l_error_assignments;
938: CLOSE get_emp_counts;
939: 940: fnd_file.put_line(fnd_file.output,'
Number of Assignments Upgraded successfully : '||l_success_assignments||'
');
941: fnd_file.put_line(fnd_file.output,'
Number of Assignments ended in Error : '||l_error_assignments||'
');
942:
943: /* End of Printing the Number of Employees processed*/
944:
Line 941: fnd_file.put_line(fnd_file.output,'
Number of Assignments ended in Error : '||l_error_assignments||'
');
937: FETCH get_emp_counts INTO l_error_assignments;
938: CLOSE get_emp_counts;
939:
940: fnd_file.put_line(fnd_file.output,'
Number of Assignments Upgraded successfully : '||l_success_assignments||'
'); 941: fnd_file.put_line(fnd_file.output,'
Number of Assignments ended in Error : '||l_error_assignments||'
');
942:
943: /* End of Printing the Number of Employees processed*/
944:
945: IF (l_error_assignments = 0) THEN
Line 947: fnd_file.put_line(fnd_file.output,'
Upgrade Process completed successfully
');
943: /* End of Printing the Number of Employees processed*/
944:
945: IF (l_error_assignments = 0) THEN
946: 947: fnd_file.put_line(fnd_file.output,'
Line 971: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_user_city_upgrade_pkg.generate_output');
967:
968: WHEN OTHERS THEN
969:
970: hr_utility.trace('Exception raised in pay_us_user_city_upgrade_pkg.generate_output'); 971: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_user_city_upgrade_pkg.generate_output'); 972: fnd_file.put_line(fnd_file.log,sqlerrm);
973: hr_utility.raise_error;
974:
975: END generate_output;
Line 972: fnd_file.put_line(fnd_file.log,sqlerrm);
968: WHEN OTHERS THEN
969:
970: hr_utility.trace('Exception raised in pay_us_user_city_upgrade_pkg.generate_output');
971: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_user_city_upgrade_pkg.generate_output'); 972: fnd_file.put_line(fnd_file.log,sqlerrm); 973: hr_utility.raise_error;
974:
975: END generate_output;
976: