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 HR_UTILITY

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 21: hr_utility.trace('Check for the number of User Defined Cities Upgrades');

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');
22:
23: l_upgrade_needed := 'Y';
24:
25: SELECT DECODE(count(0),0,'N','Y')

Line 38: hr_utility.trace('Upgrade Needed : '||l_upgrade_needed);

34: AND pugu.process_date = pps.applied_date
35: AND pugu.process_type = pps.process_type
36: AND pugu.process_mode = pps.phase;
37:
38: hr_utility.trace('Upgrade Needed : '||l_upgrade_needed);
39:
40: IF l_upgrade_needed = 'Y' THEN
41:
42: hr_utility.trace('User Defined City changes entries found for Upgrade');

Line 42: hr_utility.trace('User Defined City changes entries found for Upgrade');

38: hr_utility.trace('Upgrade Needed : '||l_upgrade_needed);
39:
40: IF l_upgrade_needed = 'Y' THEN
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');

Line 43: hr_utility.trace('Processing required');

39:
40: IF l_upgrade_needed = 'Y' THEN
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:

Line 48: hr_utility.trace('Start of Initial Setup');

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*/
51:
52: SELECT pay_us_geo_upd_pkg.get_parameter('MODE',ppa.legislative_parameters)

Line 124: hr_utility.trace('Created PAY_PATCH_STATUS Entry with ID :'||l_id);

120: AND pumg.old_city_code = substr(pugu.old_juri_code,8,4)
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,

Line 149: hr_utility.trace('No User Defined City changes entries for Upgrade');

145: ORDER BY paf.person_id';
146:
147: ELSE
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');

Line 150: hr_utility.trace('No Processing required');

146:
147: ELSE
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:

Line 162: hr_utility.trace('Range Cursor is');

158: AND :pactid IS NOT NULL';
159:
160: END IF; /*l_upgrade_needed IF*/
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:

Line 163: hr_utility.trace(sqlstr);

159:
160: END IF; /*l_upgrade_needed IF*/
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

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 173: hr_utility.raise_error;

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:
177: PROCEDURE action_creation (pactid IN NUMBER,

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 213: hr_utility.trace('Action Creation called with below details');

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);
217: hr_utility.trace('chunk :'||chunk);

Line 214: hr_utility.trace('pactid :'||pactid);

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);
217: hr_utility.trace('chunk :'||chunk);
218:

Line 215: hr_utility.trace('stperson :'||stperson);

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);
217: hr_utility.trace('chunk :'||chunk);
218:
219: OPEN c_get_assignments(stperson,endperson);

Line 216: hr_utility.trace('endperson :'||endperson);

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);
217: hr_utility.trace('chunk :'||chunk);
218:
219: OPEN c_get_assignments(stperson,endperson);
220: FETCH c_get_assignments INTO l_assignment_id;

Line 217: hr_utility.trace('chunk :'||chunk);

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);
217: hr_utility.trace('chunk :'||chunk);
218:
219: OPEN c_get_assignments(stperson,endperson);
220: FETCH c_get_assignments INTO l_assignment_id;
221:

Line 236: hr_utility.trace('Assignment Action '||l_assignment_action_id||' for Assignment '||l_assignment_id);

232: pactid => pactid,
233: chunk => chunk,
234: object_type => 'ASG');
235:
236: hr_utility.trace('Assignment Action '||l_assignment_action_id||' for Assignment '||l_assignment_id);
237:
238: FETCH c_get_assignments INTO l_assignment_id;
239:
240: END LOOP;

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 253: hr_utility.raise_error;

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:
257: PROCEDURE archive_code (p_xfr_action_id IN NUMBER,

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 296: hr_utility.trace('for Assignment Action ID : '||p_xfr_action_id);

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;
300: CLOSE c_assignment_id;

Line 310: hr_utility.trace('Calling Geocode Upgrade for Assignment '||l_assignment_id);

306: OPEN c_patch_details(l_mode);
307: FETCH c_patch_details INTO l_id,l_patch_name;
308: CLOSE c_patch_details;
309:
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');

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 315: hr_utility.trace('for Assignment Action ID : '||p_xfr_action_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:
319: WHEN OTHERS THEN

Line 325: hr_utility.raise_error;

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:
329: PROCEDURE deinitialization (p_payroll_action_id IN NUMBER) IS

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 387: hr_utility.trace('Check for the number of User Defined Cities Upgrades');

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);
390: FETCH c_mode into l_mode;
391: close c_mode;

Line 612: hr_utility.raise_error;

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:
616: END IF; /* l_mode IF */

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 633: hr_utility.raise_error;

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:
637: PROCEDURE generate_output(p_mode VARCHAR2,p_upgrade_needed VARCHAR2) IS

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 973: hr_utility.raise_error;

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