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.

[Home] [Help]

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

User Defined City Upgrade Details

');
784:
785: IF p_upgrade_needed = 'Y' THEN
786:

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

User Defined City Upgrade Details

');

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

User Defined City Upgrade Details

');
784:
785: IF p_upgrade_needed = 'Y' THEN
786:
787: SELECT id,applied_date

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

799: AND pps1.legislation_code = 'US');
800:
801: /* Start of Employee Update related details printing*/
802:
803: fnd_file.put_line(fnd_file.output,'

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

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

Process Mode : '||p_mode||'

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

List of User Defined Cities that needs upgrade

');
806: fnd_file.put_line(fnd_file.output,'');
807: fnd_file.put_line(fnd_file.output,'');

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

800:
801: /* Start of Employee Update related details printing*/
802:
803: fnd_file.put_line(fnd_file.output,'

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

');
804: fnd_file.put_line(fnd_file.output,'
Process Mode : '||p_mode||'
');
805: fnd_file.put_line(fnd_file.output,'

List of User Defined Cities that needs upgrade

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

State Name

');
807: fnd_file.put_line(fnd_file.output,'');
808: fnd_file.put_line(fnd_file.output,'');

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

List of User Defined Cities that needs upgrade

');

801: /* Start of Employee Update related details printing*/
802:
803: fnd_file.put_line(fnd_file.output,'

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

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

Process Mode : '||p_mode||'

');
805: fnd_file.put_line(fnd_file.output,'
List of User Defined Cities that needs upgrade
');
806: fnd_file.put_line(fnd_file.output,'

State Name	State Abbrev

');
807: fnd_file.put_line(fnd_file.output,'');
808: fnd_file.put_line(fnd_file.output,'');
809: fnd_file.put_line(fnd_file.output,'');

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

State Name	State Abbrev	County Name

');

802:
803: fnd_file.put_line(fnd_file.output,'

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

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

Process Mode : '||p_mode||'

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

List of User Defined Cities that needs upgrade

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

');
807: fnd_file.put_line(fnd_file.output,'');
808: fnd_file.put_line(fnd_file.output,'');
809: fnd_file.put_line(fnd_file.output,'');
810: fnd_file.put_line(fnd_file.output,'');

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

');

803: fnd_file.put_line(fnd_file.output,'

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

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

Process Mode : '||p_mode||'

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

List of User Defined Cities that needs upgrade

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

State Name	State Abbrev	County Name	City Name
State Name

');
807: fnd_file.put_line(fnd_file.output,'');
808: fnd_file.put_line(fnd_file.output,'');
809: fnd_file.put_line(fnd_file.output,'');
810: fnd_file.put_line(fnd_file.output,'');
811: fnd_file.put_line(fnd_file.output,'');

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

');

804: fnd_file.put_line(fnd_file.output,'

Process Mode : '||p_mode||'

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

List of User Defined Cities that needs upgrade

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

State Name	State Abbrev	County Name	City Name	Old User Defined Code	State Abbrev

');
807: fnd_file.put_line(fnd_file.output,'');
808: fnd_file.put_line(fnd_file.output,'');
809: fnd_file.put_line(fnd_file.output,'');
810: fnd_file.put_line(fnd_file.output,'');
811: fnd_file.put_line(fnd_file.output,'');
812: fnd_file.put_line(fnd_file.output,'');

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

');

805: fnd_file.put_line(fnd_file.output,'

List of User Defined Cities that needs upgrade

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

State Name	State Abbrev	County Name	City Name	Old User Defined Code	New Jurisdiction Code	County Name

');
807: fnd_file.put_line(fnd_file.output,'');
808: fnd_file.put_line(fnd_file.output,'');
809: fnd_file.put_line(fnd_file.output,'');
810: fnd_file.put_line(fnd_file.output,'');
811: fnd_file.put_line(fnd_file.output,'');
812: fnd_file.put_line(fnd_file.output,'');
813:

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

');

806: fnd_file.put_line(fnd_file.output,'

State Name	State Abbrev	County Name	City Name	Old User Defined Code	New Jurisdiction Code	City Name

');
807: fnd_file.put_line(fnd_file.output,'');
808: fnd_file.put_line(fnd_file.output,'');
809: fnd_file.put_line(fnd_file.output,'');
810: fnd_file.put_line(fnd_file.output,'');
811: fnd_file.put_line(fnd_file.output,'');
812: fnd_file.put_line(fnd_file.output,'');
813:
814: OPEN get_user_city_update_details;

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

');

807: fnd_file.put_line(fnd_file.output,'

');
808: fnd_file.put_line(fnd_file.output,'');
809: fnd_file.put_line(fnd_file.output,'');
810: fnd_file.put_line(fnd_file.output,'');
811: fnd_file.put_line(fnd_file.output,'');
812: fnd_file.put_line(fnd_file.output,'');
813:
814: OPEN get_user_city_update_details;
815: FETCH get_user_city_update_details INTO

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

');

808: fnd_file.put_line(fnd_file.output,'

');
809: fnd_file.put_line(fnd_file.output,'');
810: fnd_file.put_line(fnd_file.output,'');
811: fnd_file.put_line(fnd_file.output,'');
812: fnd_file.put_line(fnd_file.output,'');
813:
814: OPEN get_user_city_update_details;
815: FETCH get_user_city_update_details INTO
816: l_state_name,l_state_abbrev,l_county_name,

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

');
825:
826: FETCH get_user_city_update_details INTO

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

State Name	State Abbrev	County Name	City Name	Old User Defined Code	New Jurisdiction Code	Old User Defined Code
State Name	State Abbrev	County Name	City Name	Old User Defined Code	New Jurisdiction Code	New Jurisdiction Code	State Abbrev	County Name	City Name	Old User Defined Code	New Jurisdiction Code
'\|\|l_state_name\|\|'	'\|\|l_state_abbrev\|\| 818: 819: WHILE (get_user_city_update_details%FOUND) 820: LOOP 821: 822: fnd_file.put_line(fnd_file.output,'
'\|\|l_state_name\|\|'	'\|\|l_state_abbrev\|\| 823: '	'\|\|l_county_name\|\|'	'\|\|l_city_name\|\| 824: '	'\|\|l_old_juri_code\|\|'	'\|\|l_new_juri_code\|\|'

');

832: CLOSE get_user_city_update_details;
833:
834: /* Start of Successful Employees printing section */
835:
836: fnd_file.put_line(fnd_file.output,'');
837:
838: IF p_mode = 'DEBUG' THEN
839: fnd_file.put_line(fnd_file.output,'

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

');
840: ELSE

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

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

');

835:
836: fnd_file.put_line(fnd_file.output,'');
837:
838: IF p_mode = 'DEBUG' THEN
839: fnd_file.put_line(fnd_file.output,'

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

');
840: ELSE
841: fnd_file.put_line(fnd_file.output,'

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

');
842: END IF;
843:

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

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

');

837:
838: IF p_mode = 'DEBUG' THEN
839: fnd_file.put_line(fnd_file.output,'

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

');
840: ELSE
841: fnd_file.put_line(fnd_file.output,'
List down employees for whom Jurisdiction code and relevant tables were updated
');
842: END IF;
843:
844: fnd_file.put_line(fnd_file.output,'

Update Details

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

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

Update Details

');

840: ELSE
841: fnd_file.put_line(fnd_file.output,'

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

');
842: END IF;
843:
844: fnd_file.put_line(fnd_file.output,'
Update Details
');
845: fnd_file.put_line(fnd_file.output,'

');
846: fnd_file.put_line(fnd_file.output,'');
847: fnd_file.put_line(fnd_file.output,'');
848: fnd_file.put_line(fnd_file.output,'');

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

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

');

841: fnd_file.put_line(fnd_file.output,'

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

');
842: END IF;
843:
844: fnd_file.put_line(fnd_file.output,'

Update Details

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

');
846: fnd_file.put_line(fnd_file.output,'');
847: fnd_file.put_line(fnd_file.output,'');
848: fnd_file.put_line(fnd_file.output,'');
849: fnd_file.put_line(fnd_file.output,'');

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

');

842: END IF;
843:
844: fnd_file.put_line(fnd_file.output,'

Update Details

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

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

');
846: fnd_file.put_line(fnd_file.output,'');
847: fnd_file.put_line(fnd_file.output,'');
848: fnd_file.put_line(fnd_file.output,'');
849: fnd_file.put_line(fnd_file.output,'');
850: fnd_file.put_line(fnd_file.output,'');

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

');

843:
844: fnd_file.put_line(fnd_file.output,'

Update Details

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

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

');
846: fnd_file.put_line(fnd_file.output,'');
847: fnd_file.put_line(fnd_file.output,'');
848: fnd_file.put_line(fnd_file.output,'');
849: fnd_file.put_line(fnd_file.output,'');
850: fnd_file.put_line(fnd_file.output,'');
851:

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

');

844: fnd_file.put_line(fnd_file.output,'

Update Details

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

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

');
846: fnd_file.put_line(fnd_file.output,'');
847: fnd_file.put_line(fnd_file.output,'');
848: fnd_file.put_line(fnd_file.output,'');
849: fnd_file.put_line(fnd_file.output,'');
850: fnd_file.put_line(fnd_file.output,'');
851:
852: OPEN get_succesful_employees(l_id,p_mode);

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

');

845: fnd_file.put_line(fnd_file.output,'

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

');
846: fnd_file.put_line(fnd_file.output,'');
847: fnd_file.put_line(fnd_file.output,'');
848: fnd_file.put_line(fnd_file.output,'');
849: fnd_file.put_line(fnd_file.output,'');
850: fnd_file.put_line(fnd_file.output,'');
851:
852: OPEN get_succesful_employees(l_id,p_mode);
853: FETCH get_succesful_employees

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

');

846: fnd_file.put_line(fnd_file.output,'

');
847: fnd_file.put_line(fnd_file.output,'');
848: fnd_file.put_line(fnd_file.output,'');
849: fnd_file.put_line(fnd_file.output,'');
850: fnd_file.put_line(fnd_file.output,'');
851:
852: OPEN get_succesful_employees(l_id,p_mode);
853: FETCH get_succesful_employees
854: INTO l_person_id,l_assignment_id,l_old_juri_code,

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

');
872:

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

');

872:
873: WHILE (get_updated_tables%FOUND)
874: LOOP
875:
876: fnd_file.put_line(fnd_file.output,'

');
877: FETCH get_updated_tables INTO l_table_name;
878:
879: END LOOP; /* get_updated_tables LOOP */
880:

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

Employee Details		Jurisdiction Details		Tables Updated
Full Name	Assignment ID	Old Jurisdiction Code	New Jurisdiction Code	Tables Updated
New Jurisdiction Code
Employee Details		Jurisdiction Details		Tables Updated
Full Name	Assignment ID	Old Jurisdiction Code	New Jurisdiction Code	Tables Updated
'\|\|l_full_name\|\| 864: OPEN get_updated_tables(l_id,p_mode,l_person_id, 865: l_assignment_id,l_old_juri_code,l_new_juri_code); 866: FETCH get_updated_tables INTO l_table_name; 867: 868: fnd_file.put_line(fnd_file.output,'
'\|\|l_full_name\|\| 869: '	'\|\|l_assignment_id\|\| 870: '	'\|\|l_old_juri_code\|\| 871: '	'\|\|l_new_juri_code\|\|'	'\|\|l_table_name\|\|'
'\|\|l_table_name\|\|'

');

887: END LOOP; /* get_succesful_employees LOOP */
888:
889: CLOSE get_succesful_employees;
890:
891: fnd_file.put_line(fnd_file.output,'');
892:
893: /* End of Successful Employees printing section */
894:
895: /* Start of Errored Employees printing section */

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

Employees for which processing ended in error

');

893: /* End of Successful Employees printing section */
894:
895: /* Start of Errored Employees printing section */
896:
897: fnd_file.put_line(fnd_file.output,'

Employees for which processing ended in error

');
898:
899: OPEN get_emp_in_error(l_id,p_mode);
900: FETCH get_emp_in_error INTO l_full_name,l_assignment_id;
901:

Line 904: fnd_file.put_line(fnd_file.output,'');
900: FETCH get_emp_in_error INTO l_full_name,l_assignment_id;
901:
902: IF get_emp_in_error%FOUND THEN
903:
904: fnd_file.put_line(fnd_file.output,'

');
905: fnd_file.put_line(fnd_file.output,'');
906: fnd_file.put_line(fnd_file.output,'');
907:
908: WHILE (get_emp_in_error%FOUND)
Line 905: fnd_file.put_line(fnd_file.output,'
');
901:
902: IF get_emp_in_error%FOUND THEN
903:
904: fnd_file.put_line(fnd_file.output,'
Employee Details
Full Name Assignment ID

Employee Details
');
905: fnd_file.put_line(fnd_file.output,'');
906: fnd_file.put_line(fnd_file.output,'');
907:
908: WHILE (get_emp_in_error%FOUND)
909: LOOP
Line 906: fnd_file.put_line(fnd_file.output,'
');
902: IF get_emp_in_error%FOUND THEN
903:
904: fnd_file.put_line(fnd_file.output,'

Employee Details
Full Name Assignment ID

Full Name Assignment ID

');
905: fnd_file.put_line(fnd_file.output,'');
906: fnd_file.put_line(fnd_file.output,'');
907:
908: WHILE (get_emp_in_error%FOUND)
909: LOOP
910:
Line 911: fnd_file.put_line(fnd_file.output,'
');
907:
908: WHILE (get_emp_in_error%FOUND)
909: LOOP
910:
911: fnd_file.put_line(fnd_file.output,'
');
912: FETCH get_emp_in_error INTO l_full_name,l_assignment_id;
913:
914: END LOOP;
915:
Line 916: fnd_file.put_line(fnd_file.output,'
Employee Details
Full Name Assignment ID

'||l_full_name||' '||l_assignment_id||'

'||l_full_name||' '||l_assignment_id||'

');

Employee Details
Full Name	Assignment ID
Employee Details

Employee Details
Full Name	Assignment ID
Full Name	Assignment ID

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

912: FETCH get_emp_in_error INTO l_full_name,l_assignment_id;
913:
914: END LOOP;
915:
916: fnd_file.put_line(fnd_file.output,'');
917:
918: ELSE
919:
920: fnd_file.put_line(fnd_file.output,'

No Assignments in Error

');

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

916: fnd_file.put_line(fnd_file.output,'');
917:
918: ELSE
919:
920: fnd_file.put_line(fnd_file.output,'

No Assignments in Error

');
921:
922: END IF;
923:
924: CLOSE get_emp_in_error;

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

Summary

');

924: CLOSE get_emp_in_error;
925:
926: /*Start printing Summary Section*/
927:
928: fnd_file.put_line(fnd_file.output,'

Summary

');
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,'

Upgrade Process completed successfully

');
948:
949: ELSE
950:
951: fnd_file.put_line(fnd_file.output,'

Upgrade Process incomplete.Verify assignments in error and rerun the Upgrade process

');

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

947: fnd_file.put_line(fnd_file.output,'

Upgrade Process completed successfully

');
948:
949: ELSE
950:
951: fnd_file.put_line(fnd_file.output,'
Upgrade Process incomplete.Verify assignments in error and rerun the Upgrade process
');
952:
953: END IF;
954:
955: /* End of Summary section */

Line 959: fnd_file.put_line(fnd_file.output,'
No User Defined City Changes found that need upgrade
');

955: /* End of Summary section */
956:
957: ELSE
958:
959: fnd_file.put_line(fnd_file.output,'

No User Defined City Changes found that need upgrade

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

No Processing required

');
961:
962: END IF; /* l_upgrade_needed IF*/
963:

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

956:
957: ELSE
958:
959: fnd_file.put_line(fnd_file.output,'

No User Defined City Changes found that need upgrade

');
960: fnd_file.put_line(fnd_file.output,'
No Processing required
');
961:
962: END IF; /* l_upgrade_needed IF*/
963:
964: hr_utility.trace('Leaving pay_us_user_city_upgrade_pkg.generate_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:

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');

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

Line 125: fnd_file.put_line(fnd_file.log,'Created PAY_PATCH_STATUS Entry with ID :'||l_id);

Line 152: fnd_file.put_line(fnd_file.log,'No User Defined City changes entries for Upgrade');

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

Line 171: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_user_city_upgrade_pkg.range_cursor');

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

Line 251: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_user_city_upgrade_pkg.action_creation');

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

Line 321: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_user_city_upgrade_pkg.archive_code');

Line 322: fnd_file.put_line(fnd_file.log,'Assignment Action ID : '||p_xfr_action_id);

Line 323: fnd_file.put_line(fnd_file.log,'Assignment ID : '||l_assignment_id);

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

Line 611: fnd_file.put_line(fnd_file.log,'User Defined City Upgrade Process completed in error.');

Line 631: fnd_file.put_line(fnd_file.log,'Exception raised in pay_us_user_city_upgrade_pkg.deinitialization');

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

Line 782: fnd_file.put_line(fnd_file.output,'User Defined City Upgrade Details');

User Defined City Upgrade Details

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

User Defined City Upgrade Details

User Defined City Upgrade Details

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

List of User Defined Cities that needs upgrade

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

List of User Defined Cities that needs upgrade

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

List of User Defined Cities that needs upgrade

List of User Defined Cities that needs upgrade

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

List of User Defined Cities that needs upgrade

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

List of User Defined Cities that needs upgrade

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

List of User Defined Cities that needs upgrade

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

List of User Defined Cities that needs upgrade

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

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

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

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

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

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

Line 839: 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 841: 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

Update Details

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

Update Details

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

Update Details

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

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

Update Details

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

Update Details

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

Update Details

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

Update Details

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

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

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

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

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

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

Employees for which processing ended in error

Employees for which processing ended in error

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

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

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

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

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

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

Summary

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

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

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

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

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

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

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

Line 959: fnd_file.put_line(fnd_file.output,'
No User Defined City Changes found that need upgrade
');

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