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_USER_CITY_UPGRADE_PKG dependencies on PAY_US_USER_CITY_UPGRADE_PKG

Line 1: PACKAGE BODY pay_us_user_city_upgrade_pkg AS

1: PACKAGE BODY pay_us_user_city_upgrade_pkg AS
2: /*$Header: pyususru.pkb 120.0.12020000.1 2012/07/17 04:15:57 emunisek noship $*/
3:
4: PROCEDURE range_cursor (pactid IN NUMBER,
5: sqlstr OUT NOCOPY VARCHAR2) IS

Line 17: hr_utility.trace('Entered pay_us_user_city_upgrade_pkg.range_cursor');

13: l_mode VARCHAR2(8);
14:
15: BEGIN
16:
17: hr_utility.trace('Entered pay_us_user_city_upgrade_pkg.range_cursor');
18:
19: /*Range cursor will be determined based on the necessity for upgrade*/
20:
21: hr_utility.trace('Check for the number of User Defined Cities Upgrades');

Line 165: hr_utility.trace('Leaving pay_us_user_city_upgrade_pkg.range_cursor');

161:
162: hr_utility.trace('Range Cursor is');
163: hr_utility.trace(sqlstr);
164:
165: hr_utility.trace('Leaving pay_us_user_city_upgrade_pkg.range_cursor');
166:
167: EXCEPTION
168:
169: WHEN OTHERS THEN

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 212: hr_utility.trace('Entering pay_us_user_city_upgrade_pkg.action_creation');

208: l_assignment_action_id NUMBER;
209:
210: BEGIN
211:
212: hr_utility.trace('Entering pay_us_user_city_upgrade_pkg.action_creation');
213: hr_utility.trace('Action Creation called with below details');
214: hr_utility.trace('pactid :'||pactid);
215: hr_utility.trace('stperson :'||stperson);
216: hr_utility.trace('endperson :'||endperson);

Line 244: hr_utility.trace('Leaving pay_us_user_city_upgrade_pkg.action_creation');

240: END LOOP;
241:
242: CLOSE c_get_assignments;
243:
244: hr_utility.trace('Leaving pay_us_user_city_upgrade_pkg.action_creation');
245:
246: EXCEPTION
247:
248: WHEN OTHERS THEN

Line 250: hr_utility.trace('Exception raised in pay_us_user_city_upgrade_pkg.action_creation');

246: EXCEPTION
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:

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 295: hr_utility.trace('Inside pay_us_user_city_upgrade_pkg.archive_code');

291: l_patch_name pay_patch_status.patch_name%TYPE;
292:
293: BEGIN
294:
295: hr_utility.trace('Inside pay_us_user_city_upgrade_pkg.archive_code');
296: hr_utility.trace('for Assignment Action ID : '||p_xfr_action_id);
297:
298: OPEN c_assignment_id (p_xfr_action_id);
299: FETCH c_assignment_id into l_payroll_action_id,l_assignment_id;

Line 314: hr_utility.trace('Leaving pay_us_user_city_upgrade_pkg.archive_code');

310: hr_utility.trace('Calling Geocode Upgrade for Assignment '||l_assignment_id);
311:
312: pay_us_geo_upd_pkg.upgrade_geocodes(l_assignment_id,l_assignment_id,l_id,l_mode,l_patch_name);
313:
314: hr_utility.trace('Leaving pay_us_user_city_upgrade_pkg.archive_code');
315: hr_utility.trace('for Assignment Action ID : '||p_xfr_action_id);
316:
317: EXCEPTION
318:

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 385: hr_utility.trace('Entering pay_us_user_city_upgrade_pkg.deinitialization');

381: l_primary_flag pay_us_city_names.primary_flag%TYPE;
382:
383: BEGIN
384:
385: hr_utility.trace('Entering pay_us_user_city_upgrade_pkg.deinitialization');
386:
387: hr_utility.trace('Check for the number of User Defined Cities Upgrades');
388:
389: OPEN c_mode(p_payroll_action_id);

Line 426: pay_us_user_city_upgrade_pkg.generate_output(l_mode,l_upgrade_needed);

422: AND pps1.legislation_code = 'US');
423:
424: IF l_mode = 'DEBUG' THEN
425:
426: pay_us_user_city_upgrade_pkg.generate_output(l_mode,l_upgrade_needed);
427:
428: UPDATE pay_patch_status
429: SET status = 'C'
430: WHERE legislation_code = 'US'

Line 442: pay_us_user_city_upgrade_pkg.generate_output(l_mode,l_upgrade_needed);

438: been using D PROCESS_TYPE for User Defined City Upgrade changes*/
439:
440: l_process_type := 'D';
441:
442: pay_us_user_city_upgrade_pkg.generate_output(l_mode,l_upgrade_needed);
443:
444: OPEN get_emp_counts(l_id,l_mode,'ALL',l_process_type);
445: FETCH get_emp_counts INTO l_total_assignments;
446: CLOSE get_emp_counts;

Line 620: pay_us_user_city_upgrade_pkg.generate_output(l_mode,l_upgrade_needed);

616: END IF; /* l_mode IF */
617:
618: ELSE
619:
620: pay_us_user_city_upgrade_pkg.generate_output(l_mode,l_upgrade_needed);
621:
622: END IF; /* l_upgrade_needed IF*/
623:
624: hr_utility.trace('Leaving pay_us_user_city_upgrade_pkg.deinitialization');

Line 624: hr_utility.trace('Leaving pay_us_user_city_upgrade_pkg.deinitialization');

620: pay_us_user_city_upgrade_pkg.generate_output(l_mode,l_upgrade_needed);
621:
622: END IF; /* l_upgrade_needed IF*/
623:
624: hr_utility.trace('Leaving pay_us_user_city_upgrade_pkg.deinitialization');
625:
626: EXCEPTION
627:
628: WHEN OTHERS THEN

Line 630: hr_utility.trace('Exception raised in pay_us_user_city_upgrade_pkg.deinitialization');

626: EXCEPTION
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:

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 780: hr_utility.trace('Entering pay_us_user_city_upgrade_pkg.generate_output');

776: l_not_process_assignments NUMBER;
777:
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:

Line 964: hr_utility.trace('Leaving pay_us_user_city_upgrade_pkg.generate_output');

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');
965:
966: EXCEPTION
967:
968: WHEN OTHERS THEN

Line 970: hr_utility.trace('Exception raised in pay_us_user_city_upgrade_pkg.generate_output');

966: EXCEPTION
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:

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 977: END pay_us_user_city_upgrade_pkg;

973: hr_utility.raise_error;
974:
975: END generate_output;
976:
977: END pay_us_user_city_upgrade_pkg;