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 HR_UTILITY

Line 54: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.l_upgrade_needed');

50: l_count NUMBER;
51:
52: BEGIN
53:
54: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.l_upgrade_needed');
55:
56: /*Populate the details only for the first time. This function if passed with NULL values for all
57: parameters indicates if we have any PSDCODEs that need upgrade by giving TRUE or FALSE. If
58: a specific PSDCODE Change details are passed as input, indication will be given if the UPGRADE

Line 67: hr_utility.trace('Populating the PL/SQL Table');

63: so that any subsequent runs does not try to load the data. */
64:
65: IF NOT g_psdcode_changes_population THEN
66:
67: hr_utility.trace('Populating the PL/SQL Table');
68:
69: OPEN get_upgrade_needed_psdcodes;
70: FETCH get_upgrade_needed_psdcodes INTO l_psdcode_change,l_state_code,l_county_code,l_city_code;
71:

Line 96: hr_utility.trace('NULL Parameter Call to the function');

92: l_count := tab_psdcode_upgrade_changes.COUNT;
93:
94: IF p_state_code IS NULL AND l_count > 0 THEN
95:
96: hr_utility.trace('NULL Parameter Call to the function');
97:
98: l_upgrade_needed := 'Y';
99:
100: ELSIF l_count > 0 THEN

Line 102: hr_utility.trace('Checking if Upgrade Needed for '||p_state_code||'-'||p_county_code||'-'||p_city_code||' and PSDCODE '||p_psdcode_change);

98: l_upgrade_needed := 'Y';
99:
100: ELSIF l_count > 0 THEN
101:
102: hr_utility.trace('Checking if Upgrade Needed for '||p_state_code||'-'||p_county_code||'-'||p_city_code||' and PSDCODE '||p_psdcode_change);
103:
104: l_index := p_state_code||'-'||p_county_code||'-'||p_city_code||'-'||substr(p_psdcode_change,15,5);
105:
106: /*Check if the PSDCODE needs an upgrade. The presence of the PSDCODE related record

Line 118: hr_utility.trace('Returning '||l_upgrade_needed);

114: END IF;
115:
116: END IF;
117:
118: hr_utility.trace('Returning '||l_upgrade_needed);
119:
120: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.l_upgrade_needed');
121:
122: RETURN l_upgrade_needed;

Line 120: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.l_upgrade_needed');

116: END IF;
117:
118: hr_utility.trace('Returning '||l_upgrade_needed);
119:
120: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.l_upgrade_needed');
121:
122: RETURN l_upgrade_needed;
123:
124: END upgrade_needed;

Line 143: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.get_pay_patch_status_entry');

139: l_status pay_patch_status.status%TYPE;
140:
141: BEGIN
142:
143: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.get_pay_patch_status_entry');
144:
145: l_mode := p_mode;
146:
147: /*Get the PAY_PATCH_STATUS ID of the Previous Successful execution of

Line 157: hr_utility.trace('Previous successful upgrade ID :'||l_prev_upgrade_id);

153: WHERE patch_name LIKE 'PSDUPGRADE%'
154: AND description = 'UPGRADE'
155: AND status = 'C';
156:
157: hr_utility.trace('Previous successful upgrade ID :'||l_prev_upgrade_id);
158:
159: IF l_mode = 'UPGRADE' THEN
160:
161: BEGIN /*Start of UPGRADE Mode*/

Line 168: hr_utility.trace('Check if there are any incomplete Upgrade Runs');

164: one unsuccessful run in UPGRADE mode. If we find multiple runs in Unsuccessful
165: state, it needs to be analyzed why the second run did not set right the first
166: one.*/
167:
168: hr_utility.trace('Check if there are any incomplete Upgrade Runs');
169:
170: SELECT id,phase,applied_date
171: INTO l_id,l_phase,l_date
172: FROM pay_patch_status

Line 204: hr_utility.trace('Get the Generate Run pay_patch_status table ID');

200: WHEN NO_DATA_FOUND THEN
201:
202: BEGIN
203:
204: hr_utility.trace('Get the Generate Run pay_patch_status table ID');
205:
206: SELECT MAX(pps.id)
207: INTO l_generate_id
208: FROM pay_patch_status pps

Line 223: hr_utility.trace('UPGRADE Mode can be executed only after running the process in GENERATE Mode successfully.');

219: EXCEPTION
220:
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;

Line 224: hr_utility.trace('Not able to find the PAY_PATCH_STATUS entry corresponding to GENERATE Mode execution.');

220:
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:

Line 227: hr_utility.raise_error;

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:
231: SELECT pay_patch_status_s.NEXTVAL,

Line 243: hr_utility.trace('Created UPGRADE pay_patch_status entry with ID : '||l_id);

239: (id,patch_number,patch_name,phase,status,applied_date,legislation_code,description)
240: VALUES
241: (l_id,'1111111',l_patch_name,'UPGRADE',l_status,l_date,'US',l_mode);
242:
243: hr_utility.trace('Created UPGRADE pay_patch_status entry with ID : '||l_id);
244:
245: UPDATE /*+PARALLEL*/ pay_us_geo_update
246: SET id = l_id,
247: process_date = l_date,

Line 258: hr_utility.trace('Inconsistent state of Upgrade Process. Raise error');

254: AND assignment_id <> -1;
255:
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;

Line 259: hr_utility.trace('Too Many rows of Upgrade Process found');

255:
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:

Line 262: hr_utility.raise_error;

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:
266: /*End of UPGRADE Mode*/

Line 272: hr_utility.trace('Executing stepts For GENERATE Mode');

268: ELSIF l_mode = 'GENERATE' THEN
269:
270: /*Start of GENERATE Mode*/
271:
272: hr_utility.trace('Executing stepts For GENERATE Mode');
273:
274: /*Check if there is an incomplete Upgrade Run. If Upgrade run already
275: started and is in incomplete state, then we should not run the Generate
276: Mode*/

Line 280: hr_utility.trace('Checking if there are any incomplete UPGRADE Runs from earlier');

276: Mode*/
277:
278: BEGIN
279:
280: hr_utility.trace('Checking if there are any incomplete UPGRADE Runs from earlier');
281:
282: SELECT id,phase,applied_date
283: INTO l_id,l_phase,l_date
284: FROM pay_patch_status

Line 290: hr_utility.trace('Incomplete Upgrade Run Exists. Run the Process in UPGRADE mode');

286: AND description = 'UPGRADE'
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

Line 292: hr_utility.raise_error;

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:
296: WHEN NO_DATA_FOUND THEN

Line 298: hr_utility.trace('No incomplete UPGRADE Runs from earlier');

294: EXCEPTION
295:
296: WHEN NO_DATA_FOUND THEN
297:
298: hr_utility.trace('No incomplete UPGRADE Runs from earlier');
299:
300: END;
301:
302: /*Delete Data from earlier GENERATE run before starting the current one*/

Line 304: hr_utility.trace('Delete any Data generated earlier before the current one');

300: END;
301:
302: /*Delete Data from earlier GENERATE run before starting the current one*/
303:
304: hr_utility.trace('Delete any Data generated earlier before the current one');
305:
306: DELETE FROM pay_us_geo_update
307: WHERE process_type = 'PA'
308: AND process_mode = 'GENERATE'

Line 340: hr_utility.trace('Created GENERATE pay_patch_status entry with ID : '||l_id);

336: (id,patch_number,patch_name,phase,status,applied_date,legislation_code,description)
337: VALUES
338: (l_id,'1111111',l_patch_name,'VALIDATE',l_status,l_date,'US',l_mode);
339:
340: hr_utility.trace('Created GENERATE pay_patch_status entry with ID : '||l_id);
341:
342: /*End of GENARATE Mode*/
343:
344: END IF; /*l_mode IF */

Line 346: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.get_pay_patch_status_entry');

342: /*End of GENARATE Mode*/
343:
344: END IF; /*l_mode IF */
345:
346: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.get_pay_patch_status_entry');
347:
348: RETURN l_id;
349:
350: END get_pay_patch_status_entry;

Line 360: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.create_jsd_element_set');

356: l_element_set_id pay_element_sets.element_set_id%TYPE;
357:
358: BEGIN
359:
360: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.create_jsd_element_set');
361:
362: /*Create the Element set for Elements having Jurisdiction Code as Input Value*/
363:
364: SELECT pay_element_sets_s.nextval

Line 397: hr_utility.trace('Created Element Set with Name : US_JSD_ELEMENTS_'||p_pay_patch_status_id||', Element Set ID :'||l_element_set_id);

393: >= TO_DATE('01-01-2012','DD-MM-YYYY')
394: AND piv.element_type_id = pet.element_type_id
395: AND piv.name = 'Jurisdiction';
396:
397: hr_utility.trace('Created Element Set with Name : US_JSD_ELEMENTS_'||p_pay_patch_status_id||', Element Set ID :'||l_element_set_id);
398:
399: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.create_jsd_element_set');
400:
401: END create_jsd_element_set;

Line 399: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.create_jsd_element_set');

395: AND piv.name = 'Jurisdiction';
396:
397: hr_utility.trace('Created Element Set with Name : US_JSD_ELEMENTS_'||p_pay_patch_status_id||', Element Set ID :'||l_element_set_id);
398:
399: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.create_jsd_element_set');
400:
401: END create_jsd_element_set;
402:
403: PROCEDURE perform_initial_setup(p_payroll_action_id NUMBER) IS

Line 411: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.perform_initial_setup');

407: l_pay_patch_status_id pay_patch_status.id%TYPE;
408:
409: BEGIN
410:
411: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.perform_initial_setup');
412:
413: l_upgrade_needed := upgrade_needed();
414:
415: IF l_upgrade_needed = 'Y' THEN

Line 417: hr_utility.trace('PSDCODE changes entries found for Upgrade');

413: l_upgrade_needed := upgrade_needed();
414:
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:

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

414:
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*/

Line 429: hr_utility.trace('Mode of Execution ' ||l_mode);

425: INTO l_mode
426: FROM pay_payroll_actions ppa
427: WHERE ppa.payroll_action_id = p_payroll_action_id;
428:
429: hr_utility.trace('Mode of Execution ' ||l_mode);
430:
431: l_pay_patch_status_id := get_pay_patch_status_entry(l_mode);
432:
433: hr_utility.trace('PAY_PATCH_STATUS Entry for processing : ' ||l_pay_patch_status_id);

Line 433: hr_utility.trace('PAY_PATCH_STATUS Entry for processing : ' ||l_pay_patch_status_id);

429: hr_utility.trace('Mode of Execution ' ||l_mode);
430:
431: l_pay_patch_status_id := get_pay_patch_status_entry(l_mode);
432:
433: hr_utility.trace('PAY_PATCH_STATUS Entry for processing : ' ||l_pay_patch_status_id);
434:
435: IF l_mode = 'GENERATE' THEN
436:
437: create_jsd_element_set(l_pay_patch_status_id);

Line 443: hr_utility.trace('No PSDCODE changes entries for Upgrade');

439: END IF;
440:
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:

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

440:
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*/

Line 450: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.perform_initial_setup');

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');
451:
452: END perform_initial_setup;
453:
454: PROCEDURE generate_assignment(p_assignment_id per_all_assignments_f.assignment_id%TYPE,

Line 542: hr_utility.trace('Inside pay_us_psd_upgrade_pkg.generate_assignment for Assignment ID :'||p_assignment_id);

538: l_archive_item_id NUMBER; -- Added for bug 14213838.
539:
540: BEGIN
541:
542: hr_utility.trace('Inside pay_us_psd_upgrade_pkg.generate_assignment for Assignment ID :'||p_assignment_id);
543:
544: SELECT person_id
545: INTO l_person_id
546: FROM per_all_assignments_f

Line 590: hr_utility.trace('Done with PAY_US_ASG_REPORTING');

586: pumg.county_code,
587: pumg.old_city_code,
588: pumg.city_name)='Y';
589:
590: hr_utility.trace('Done with PAY_US_ASG_REPORTING');
591:
592: /*End of PAY_US_ASG_REPORTING Section*/
593:
594: /*Start of PAY_ELEMENT_ENTRY_VALUES_F Section*/

Line 643: hr_utility.trace('Done with PAY_ELEMENT_ENTRY_VALUES_F');

639: pumg.county_code,
640: pumg.old_city_code,
641: pumg.city_name)='Y';
642:
643: hr_utility.trace('Done with PAY_ELEMENT_ENTRY_VALUES_F');
644:
645: /*End of PAY_ELEMENT_ENTRY_VALUES_F Section*/
646:
647: /* For tables PAY_RUN_RESULTS,PAY_RUN_RESULT_VALUES, first

Line 767: hr_utility.trace('Done with PAY_RUN_RESULTS,PAY_RUN_RESULT_VALUES');

763: END IF;
764:
765: CLOSE get_assignment_actions;
766:
767: hr_utility.trace('Done with PAY_RUN_RESULTS,PAY_RUN_RESULT_VALUES');
768:
769: /*Start of PAY_ACTION_INFORMATION Section*/
770:
771: OPEN get_archive_asg_actions(p_assignment_id);

Line 779: hr_utility.trace('id'||p_id);

775:
776: FOR i IN tab_assignment_action_id.FIRST..tab_assignment_action_id.LAST
777: LOOP
778:
779: hr_utility.trace('id'||p_id);
780: hr_utility.trace('asg id'||p_assignment_id);
781: hr_utility.trace('mode'||p_mode);
782: hr_utility.trace('archive action id'||tab_assignment_action_id(i));
783:

Line 780: hr_utility.trace('asg id'||p_assignment_id);

776: FOR i IN tab_assignment_action_id.FIRST..tab_assignment_action_id.LAST
777: LOOP
778:
779: hr_utility.trace('id'||p_id);
780: hr_utility.trace('asg id'||p_assignment_id);
781: hr_utility.trace('mode'||p_mode);
782: hr_utility.trace('archive action id'||tab_assignment_action_id(i));
783:
784: INSERT INTO pay_us_geo_update

Line 781: hr_utility.trace('mode'||p_mode);

777: LOOP
778:
779: hr_utility.trace('id'||p_id);
780: hr_utility.trace('asg id'||p_assignment_id);
781: hr_utility.trace('mode'||p_mode);
782: hr_utility.trace('archive action id'||tab_assignment_action_id(i));
783:
784: INSERT INTO pay_us_geo_update
785: (id,

Line 782: hr_utility.trace('archive action id'||tab_assignment_action_id(i));

778:
779: hr_utility.trace('id'||p_id);
780: hr_utility.trace('asg id'||p_assignment_id);
781: hr_utility.trace('mode'||p_mode);
782: hr_utility.trace('archive action id'||tab_assignment_action_id(i));
783:
784: INSERT INTO pay_us_geo_update
785: (id,
786: assignment_id,

Line 828: hr_utility.trace('Done with PAY_ACTION_INFORMATION');

824: END IF; /* tab_assignment_action_id.COUNT IF */
825:
826: CLOSE get_archive_asg_actions;
827:
828: hr_utility.trace('Done with PAY_ACTION_INFORMATION');
829:
830: /*End of PAY_ACTION_INFORMATION Section*/
831:
832: -- Added for bug 14213838.

Line 843: hr_utility.trace('id'||p_id);

839:
840: FOR i IN tab_assignment_action_id.FIRST..tab_assignment_action_id.LAST
841: LOOP
842:
843: hr_utility.trace('id'||p_id);
844: hr_utility.trace('asg id'||p_assignment_id);
845: hr_utility.trace('mode'||p_mode);
846: hr_utility.trace('archive action id'||tab_assignment_action_id(i));
847:

Line 844: hr_utility.trace('asg id'||p_assignment_id);

840: FOR i IN tab_assignment_action_id.FIRST..tab_assignment_action_id.LAST
841: LOOP
842:
843: hr_utility.trace('id'||p_id);
844: hr_utility.trace('asg id'||p_assignment_id);
845: hr_utility.trace('mode'||p_mode);
846: hr_utility.trace('archive action id'||tab_assignment_action_id(i));
847:
848:

Line 845: hr_utility.trace('mode'||p_mode);

841: LOOP
842:
843: hr_utility.trace('id'||p_id);
844: hr_utility.trace('asg id'||p_assignment_id);
845: hr_utility.trace('mode'||p_mode);
846: hr_utility.trace('archive action id'||tab_assignment_action_id(i));
847:
848:
849: OPEN get_psd_archive_item_id(tab_assignment_action_id(i));

Line 846: hr_utility.trace('archive action id'||tab_assignment_action_id(i));

842:
843: hr_utility.trace('id'||p_id);
844: hr_utility.trace('asg id'||p_assignment_id);
845: hr_utility.trace('mode'||p_mode);
846: hr_utility.trace('archive action id'||tab_assignment_action_id(i));
847:
848:
849: OPEN get_psd_archive_item_id(tab_assignment_action_id(i));
850: LOOP

Line 896: hr_utility.trace('Done with ff_archive_items_contexts');

892: END IF; /* tab_assignment_action_id.COUNT IF */
893:
894: CLOSE get_psd_archive_asg_actions;
895:
896: hr_utility.trace('Done with ff_archive_items_contexts');
897:
898: /*End of FF_ARCHIVE_ITEM_CONTEXTS Section*/
899:
900: /*Check if the assignment is attached to Jurisdiction Code which has multiple school districts

Line 990: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.generate_assignment');

986: /*UPGRADE Mode Ends*/
987:
988: END IF;
989:
990: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.generate_assignment');
991:
992: EXCEPTION
993:
994: WHEN OTHERS THEN

Line 998: hr_utility.trace('Exception raised in pay_us_psdcode_upgrade_pkg.generate_assignment');

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;
1002:

Line 999: hr_utility.trace('SQLERRM = ' || SQLERRM);

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;
1002:
1003: PROCEDURE upgrade_assignment(p_assignment_id per_all_assignments_f.assignment_id%TYPE,

Line 1052: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.upgrade_assignment for '||p_assignment_id);

1048: l_table_order NUMBER;
1049:
1050: BEGIN
1051:
1052: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.upgrade_assignment for '||p_assignment_id);
1053:
1054: OPEN get_emp_upgrade_details(p_id,p_mode,p_date,p_assignment_id);
1055: FETCH get_emp_upgrade_details INTO l_table_name,l_table_value_id,
1056: l_old_jurisdiction_code,l_new_jurisdiction_code,l_table_order;

Line 1149: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.upgrade_assignment');

1145: END IF;
1146:
1147: CLOSE get_emp_upgrade_details;
1148:
1149: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.upgrade_assignment');
1150:
1151: EXCEPTION
1152:
1153: WHEN OTHERS THEN

Line 1164: hr_utility.trace('Exception raised in pay_us_psdcode_upgrade_pkg.upgrade_assignment');

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:
1168: END upgrade_assignment;

Line 1165: hr_utility.trace('SQLERRM = ' || SQLERRM);

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:
1168: END upgrade_assignment;
1169:

Line 1166: hr_utility.raise_error;

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:
1168: END upgrade_assignment;
1169:
1170: PROCEDURE range_cursor (pactid IN NUMBER,

Line 1182: hr_utility.trace('Entered pay_us_psd_upgrade_pkg.range_cursor');

1178: l_date DATE;
1179:
1180: BEGIN
1181:
1182: hr_utility.trace('Entered pay_us_psd_upgrade_pkg.range_cursor');
1183:
1184: /*Range cursor will be determined based on the necessity for upgrade*/
1185:
1186: hr_utility.trace('Doing Initial Setup');

Line 1186: hr_utility.trace('Doing Initial Setup');

1182: hr_utility.trace('Entered pay_us_psd_upgrade_pkg.range_cursor');
1183:
1184: /*Range cursor will be determined based on the necessity for upgrade*/
1185:
1186: hr_utility.trace('Doing Initial Setup');
1187:
1188: perform_initial_setup(pactid);
1189:
1190: hr_utility.trace('End of Initial Setup');

Line 1190: hr_utility.trace('End of Initial Setup');

1186: hr_utility.trace('Doing Initial Setup');
1187:
1188: perform_initial_setup(pactid);
1189:
1190: hr_utility.trace('End of Initial Setup');
1191:
1192: l_upgrade_needed := upgrade_needed();
1193:
1194: IF l_upgrade_needed = 'Y' THEN

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

1255: AND :pactid IS NOT NULL';
1256:
1257: END IF;
1258:
1259: hr_utility.trace('Range Cursor is');
1260: hr_utility.trace(sqlstr);
1261:
1262: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.range_cursor');
1263:

Line 1260: hr_utility.trace(sqlstr);

1256:
1257: END IF;
1258:
1259: hr_utility.trace('Range Cursor is');
1260: hr_utility.trace(sqlstr);
1261:
1262: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.range_cursor');
1263:
1264: END range_cursor;

Line 1262: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.range_cursor');

1258:
1259: hr_utility.trace('Range Cursor is');
1260: hr_utility.trace(sqlstr);
1261:
1262: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.range_cursor');
1263:
1264: END range_cursor;
1265:
1266: PROCEDURE action_creation (pactid IN NUMBER,

Line 1326: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.action_creation');

1322: l_date DATE;
1323:
1324: BEGIN
1325:
1326: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.action_creation');
1327: hr_utility.trace('Action Creation called with below details');
1328: hr_utility.trace('pactid :'||pactid);
1329: hr_utility.trace('stperson :'||stperson);
1330: hr_utility.trace('endperson :'||endperson);

Line 1327: hr_utility.trace('Action Creation called with below details');

1323:
1324: BEGIN
1325:
1326: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.action_creation');
1327: hr_utility.trace('Action Creation called with below details');
1328: hr_utility.trace('pactid :'||pactid);
1329: hr_utility.trace('stperson :'||stperson);
1330: hr_utility.trace('endperson :'||endperson);
1331: hr_utility.trace('chunk :'||chunk);

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

1324: BEGIN
1325:
1326: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.action_creation');
1327: hr_utility.trace('Action Creation called with below details');
1328: hr_utility.trace('pactid :'||pactid);
1329: hr_utility.trace('stperson :'||stperson);
1330: hr_utility.trace('endperson :'||endperson);
1331: hr_utility.trace('chunk :'||chunk);
1332:

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

1325:
1326: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.action_creation');
1327: hr_utility.trace('Action Creation called with below details');
1328: hr_utility.trace('pactid :'||pactid);
1329: hr_utility.trace('stperson :'||stperson);
1330: hr_utility.trace('endperson :'||endperson);
1331: hr_utility.trace('chunk :'||chunk);
1332:
1333: OPEN c_mode(pactid);

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

1326: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.action_creation');
1327: hr_utility.trace('Action Creation called with below details');
1328: hr_utility.trace('pactid :'||pactid);
1329: hr_utility.trace('stperson :'||stperson);
1330: hr_utility.trace('endperson :'||endperson);
1331: hr_utility.trace('chunk :'||chunk);
1332:
1333: OPEN c_mode(pactid);
1334:

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

1327: hr_utility.trace('Action Creation called with below details');
1328: hr_utility.trace('pactid :'||pactid);
1329: hr_utility.trace('stperson :'||stperson);
1330: hr_utility.trace('endperson :'||endperson);
1331: hr_utility.trace('chunk :'||chunk);
1332:
1333: OPEN c_mode(pactid);
1334:
1335: FETCH c_mode INTO l_mode;

Line 1339: hr_utility.trace('l_mode is '|| l_mode );

1335: FETCH c_mode INTO l_mode;
1336:
1337: CLOSE c_mode;
1338:
1339: hr_utility.trace('l_mode is '|| l_mode );
1340:
1341: IF l_mode = 'GENERATE' THEN
1342:
1343: OPEN c_generate_assignments(stperson,endperson);

Line 1360: hr_utility.trace('Created Assignment Action Id : '||l_locking_action_id||' for Assignment : '||l_assignment_id);

1356: pactid => pactid,
1357: chunk => chunk,
1358: object_type => 'ASG');
1359:
1360: hr_utility.trace('Created Assignment Action Id : '||l_locking_action_id||' for Assignment : '||l_assignment_id);
1361:
1362: FETCH c_generate_assignments INTO l_assignment_id;
1363:
1364: END LOOP;

Line 1394: hr_utility.trace('Created Assignment Action Id : '||l_locking_action_id||' for Assignment : '||l_assignment_id);

1390: pactid => pactid,
1391: chunk => chunk,
1392: object_type => 'ASG');
1393:
1394: hr_utility.trace('Created Assignment Action Id : '||l_locking_action_id||' for Assignment : '||l_assignment_id);
1395:
1396: FETCH c_upgrade_assignments INTO l_assignment_id;
1397:
1398: END LOOP;

Line 1402: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.action_creation');

1398: END LOOP;
1399:
1400: END IF;
1401:
1402: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.action_creation');
1403:
1404: EXCEPTION
1405:
1406: WHEN OTHERS THEN

Line 1442: hr_utility.trace('Inside pay_us_psd_upgrade_pkg.archive_code for Assignment Action ID : '||p_xfr_action_id);

1438: BEGIN
1439:
1440: l_upgrade_needed := upgrade_needed();
1441:
1442: hr_utility.trace('Inside pay_us_psd_upgrade_pkg.archive_code for Assignment Action ID : '||p_xfr_action_id);
1443:
1444: OPEN c_xfr_info (p_xfr_action_id);
1445:
1446: FETCH c_xfr_info into l_payroll_action_id,

Line 1456: hr_utility.trace(' Mode : '||l_mode);

1452: OPEN c_mode(l_payroll_action_id);
1453: FETCH c_mode into l_mode;
1454: close c_mode;
1455:
1456: hr_utility.trace(' Mode : '||l_mode);
1457:
1458: SELECT id,applied_date
1459: INTO l_id,l_date
1460: FROM pay_patch_status

Line 1466: hr_utility.trace(' PAY_PATCH_STATUS Id : '||l_id);

1462: AND legislation_code = 'US'
1463: AND status = 'P'
1464: AND description = l_mode;
1465:
1466: hr_utility.trace(' PAY_PATCH_STATUS Id : '||l_id);
1467:
1468: /*l_object_id will be assignment_id */
1469:
1470: IF l_mode = 'GENERATE' THEN

Line 1478: hr_utility.trace(' Element Set Id : '||l_element_set_id);

1474: FROM pay_element_sets
1475: WHERE element_set_name = 'US_JSD_ELEMENTS_'||l_id
1476: AND legislation_code = 'US';
1477:
1478: hr_utility.trace(' Element Set Id : '||l_element_set_id);
1479:
1480: hr_utility.trace(' Object Type ASG , Calling Generate_Assignment '||l_object_id);
1481: generate_assignment(l_object_id,l_id,l_date,l_mode,l_element_set_id);
1482:

Line 1480: hr_utility.trace(' Object Type ASG , Calling Generate_Assignment '||l_object_id);

1476: AND legislation_code = 'US';
1477:
1478: hr_utility.trace(' Element Set Id : '||l_element_set_id);
1479:
1480: hr_utility.trace(' Object Type ASG , Calling Generate_Assignment '||l_object_id);
1481: generate_assignment(l_object_id,l_id,l_date,l_mode,l_element_set_id);
1482:
1483: ELSE
1484:

Line 1485: hr_utility.trace(' Object Type ASG , Calling Upgrade_Assignment '||l_object_id);

1481: generate_assignment(l_object_id,l_id,l_date,l_mode,l_element_set_id);
1482:
1483: ELSE
1484:
1485: hr_utility.trace(' Object Type ASG , Calling Upgrade_Assignment '||l_object_id);
1486: upgrade_assignment(l_object_id,l_id,l_date,l_mode);
1487:
1488: END IF;
1489:

Line 1490: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.archive_code for Assignment Action ID : '||p_xfr_action_id);

1486: upgrade_assignment(l_object_id,l_id,l_date,l_mode);
1487:
1488: END IF;
1489:
1490: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.archive_code for Assignment Action ID : '||p_xfr_action_id);
1491:
1492: EXCEPTION
1493:
1494: WHEN OTHERS THEN

Line 1498: hr_utility.raise_error;

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:
1502: PROCEDURE invalidate_run_balances(p_mode VARCHAR2) IS

Line 1580: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.invalidate_run_balances');

1576: l_balance_load_date DATE;
1577:
1578: BEGIN
1579:
1580: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.invalidate_run_balances');
1581:
1582: l_print_business_group_id := -1;
1583:
1584: SELECT id,applied_date

Line 1674: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.invalidate_run_balances');

1670: END LOOP;
1671:
1672: CLOSE get_run_balance_details;
1673:
1674: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.invalidate_run_balances');
1675:
1676: END invalidate_run_balances;
1677:
1678: PROCEDURE deinitialization (p_payroll_action_id IN NUMBER) IS

Line 1751: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.deinitialization');

1747: l_er_psd_entity_id NUMBER;
1748:
1749: BEGIN
1750:
1751: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.deinitialization');
1752:
1753: OPEN c_mode(p_payroll_action_id);
1754: FETCH c_mode into l_mode;
1755: close c_mode;

Line 1820: hr_utility.trace('Done with FF_ARCHIVE_ITEMS');

1816: END LOOP;
1817:
1818: CLOSE get_psd_pact_id;
1819:
1820: hr_utility.trace('Done with FF_ARCHIVE_ITEMS');
1821: /*End of FF_ARCHIVE_ITEMS Section*/
1822:
1823: -- Added for bug 14213838.
1824: /*Start of HR_ORGANIZATION_INFORMATION Section*/

Line 1859: hr_utility.trace('Done with HR_ORGANIZATION_INFORMATION');

1855: pumg.county_code,
1856: pumg.old_city_code,
1857: pumg.city_name)='Y';
1858:
1859: hr_utility.trace('Done with HR_ORGANIZATION_INFORMATION');
1860:
1861: /*End of HR_ORGANIZATION_INFORMATION Section*/
1862: pay_us_psd_upgrade_pkg.generate_output(l_mode);
1863:

Line 2030: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.deinitialization');

2026: pay_us_psd_upgrade_pkg.generate_output(l_mode);
2027:
2028: END IF; /* l_upgrade_needed IF*/
2029:
2030: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.deinitialization');
2031:
2032: END deinitialization;
2033:
2034: PROCEDURE generate_output(p_mode VARCHAR2) IS

Line 2217: hr_utility.trace('Entering pay_us_psd_upgrade_pkg.generate_output');

2213: l_not_process_ff_arch_changes NUMBER;
2214:
2215: BEGIN
2216:
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');

Line 2677: hr_utility.trace('Leaving pay_us_psd_upgrade_pkg.generate_output');

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');
2678:
2679: END generate_output;
2680:
2681: END pay_us_psd_upgrade_pkg;