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_GB_ROLLBACK dependencies on HR_UTILITY

Line 44: hr_utility.set_location('Entering: '||l_proc,1);

40: FROM per_assignment_extra_info
41: WHERE assignment_id = p_assig_id
42: AND information_type = p_type;
43: BEGIN
44: hr_utility.set_location('Entering: '||l_proc,1);
45: OPEN csr_ovn;
46: FETCH csr_ovn INTO l_ovn, p_aei_id;
47: CLOSE csr_ovn;
48: RETURN l_ovn;

Line 49: hr_utility.set_location('Leaving: '||l_proc,999);

45: OPEN csr_ovn;
46: FETCH csr_ovn INTO l_ovn, p_aei_id;
47: CLOSE csr_ovn;
48: RETURN l_ovn;
49: hr_utility.set_location('Leaving: '||l_proc,999);
50: END;
51:
52: PROCEDURE restored(
53: p_pactid IN NUMBER,

Line 118: hr_utility.set_location('Entering: '||l_proc,1);

114:
115: l_asgact_rec csr_archive_asgact_details%rowtype;
116: l_report_type varchar2(50);
117: BEGIN
118: hr_utility.set_location('Entering: '||l_proc,1);
119: hr_utility.set_location('p_pactid: '||p_pactid,1);
120: hr_utility.set_location('p_asgactid: '||p_asgactid,1);
121:
122: OPEN csr_report_type;

Line 119: hr_utility.set_location('p_pactid: '||p_pactid,1);

115: l_asgact_rec csr_archive_asgact_details%rowtype;
116: l_report_type varchar2(50);
117: BEGIN
118: hr_utility.set_location('Entering: '||l_proc,1);
119: hr_utility.set_location('p_pactid: '||p_pactid,1);
120: hr_utility.set_location('p_asgactid: '||p_asgactid,1);
121:
122: OPEN csr_report_type;
123: FETCH csr_report_type INTO l_report_type;

Line 120: hr_utility.set_location('p_asgactid: '||p_asgactid,1);

116: l_report_type varchar2(50);
117: BEGIN
118: hr_utility.set_location('Entering: '||l_proc,1);
119: hr_utility.set_location('p_pactid: '||p_pactid,1);
120: hr_utility.set_location('p_asgactid: '||p_asgactid,1);
121:
122: OPEN csr_report_type;
123: FETCH csr_report_type INTO l_report_type;
124: CLOSE csr_report_type;

Line 126: hr_utility.set_location('l_report_type: '||l_report_type,1);

122: OPEN csr_report_type;
123: FETCH csr_report_type INTO l_report_type;
124: CLOSE csr_report_type;
125:
126: hr_utility.set_location('l_report_type: '||l_report_type,1);
127:
128: IF (NVL(l_report_type,'XXX') = 'RTI_FPS_REP') THEN
129:
130: IF (p_asgactid is null) THEN

Line 133: hr_utility.set_location('Inside csr_archive_details cursor',1);

129:
130: IF (p_asgactid is null) THEN
131: FOR archive_rec IN csr_archive_details
132: LOOP
133: hr_utility.set_location('Inside csr_archive_details cursor',1);
134: -- Number of Periods Covered
135: l_ovn := get_version(archive_rec.assignment_id,'GB_PAY_RTI',l_aei_id);
136: IF l_ovn IS NOT NULL THEN
137: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_PAY_RTI',

Line 180: hr_utility.set_location('Inside csr_archive_asgact_details cursor',1);

176: ELSE -- for IF (p_asgactid is null) THEN condition
177:
178: OPEN csr_archive_asgact_details;
179: FETCH csr_archive_asgact_details into l_asgact_rec;
180: hr_utility.set_location('Inside csr_archive_asgact_details cursor',1);
181: l_ovn := get_version(l_asgact_rec.assignment_id,'GB_PAY_RTI',l_aei_id);
182: IF l_ovn IS NOT NULL THEN
183: hr_assignment_extra_info_api.update_assignment_extra_info (p_validate => false, p_object_version_number => l_ovn, p_assignment_extra_info_id => l_aei_id, p_aei_information_category => 'GB_PAY_RTI',
184: p_aei_information1 => l_asgact_rec.action_information20);

Line 293: hr_utility.set_location('Entering: '||l_proc,1);

289:
290: l_asgact_rec csr_asgs_asgact_processed%rowtype;
291:
292: BEGIN
293: hr_utility.set_location('Entering: '||l_proc,1);
294: hr_utility.set_location('p_pactid: '||p_pactid,1);
295: hr_utility.set_location('p_asgactid: '||p_asgactid,1);
296:
297: open csr_fetch_details;

Line 294: hr_utility.set_location('p_pactid: '||p_pactid,1);

290: l_asgact_rec csr_asgs_asgact_processed%rowtype;
291:
292: BEGIN
293: hr_utility.set_location('Entering: '||l_proc,1);
294: hr_utility.set_location('p_pactid: '||p_pactid,1);
295: hr_utility.set_location('p_asgactid: '||p_asgactid,1);
296:
297: open csr_fetch_details;
298: fetch csr_fetch_details into l_effective_date,l_tax_ref;

Line 295: hr_utility.set_location('p_asgactid: '||p_asgactid,1);

291:
292: BEGIN
293: hr_utility.set_location('Entering: '||l_proc,1);
294: hr_utility.set_location('p_pactid: '||p_pactid,1);
295: hr_utility.set_location('p_asgactid: '||p_asgactid,1);
296:
297: open csr_fetch_details;
298: fetch csr_fetch_details into l_effective_date,l_tax_ref;
299: close csr_fetch_details;

Line 362: hr_utility.set_location('Leaving eas_restored: '||p_pactid,1);

358: end if;
359:
360:
361:
362: hr_utility.set_location('Leaving eas_restored: '||p_pactid,1);
363: END eas_restored;
364: ---
365: ---
366: PROCEDURE eas13_restored(

Line 408: hr_utility.set_location('Entering: '||l_proc,1);

404:
405: l_asgact_rec csr_asgs_asgact_processed%rowtype;
406:
407: BEGIN
408: hr_utility.set_location('Entering: '||l_proc,1);
409: hr_utility.set_location('p_pactid: '||p_pactid,1);
410: hr_utility.set_location('p_asgactid: '||p_asgactid,1);
411:
412:

Line 409: hr_utility.set_location('p_pactid: '||p_pactid,1);

405: l_asgact_rec csr_asgs_asgact_processed%rowtype;
406:
407: BEGIN
408: hr_utility.set_location('Entering: '||l_proc,1);
409: hr_utility.set_location('p_pactid: '||p_pactid,1);
410: hr_utility.set_location('p_asgactid: '||p_asgactid,1);
411:
412:
413: IF (p_asgactid is null) THEN

Line 410: hr_utility.set_location('p_asgactid: '||p_asgactid,1);

406:
407: BEGIN
408: hr_utility.set_location('Entering: '||l_proc,1);
409: hr_utility.set_location('p_pactid: '||p_pactid,1);
410: hr_utility.set_location('p_asgactid: '||p_asgactid,1);
411:
412:
413: IF (p_asgactid is null) THEN
414: FOR archive_rec IN csr_asgs_processed

Line 442: hr_utility.set_location('Leaving eas_restored: '||p_pactid,1);

438:
439: END IF;
440: close csr_asgs_asgact_processed;
441: END IF;
442: hr_utility.set_location('Leaving eas_restored: '||p_pactid,1);
443: END eas13_restored;
444: ---
445: ---
446: /*Below procedure is created to implement GB related rollback changes when records are

Line 463: hr_utility.set_location('Entering: '||l_proc,1);

459:
460: l_report_type varchar2(50);
461:
462: BEGIN
463: hr_utility.set_location('Entering: '||l_proc,1);
464: hr_utility.set_location('p_pactid : ' || p_pactid, 10);
465:
466: OPEN csr_report_type;
467: FETCH csr_report_type INTO l_report_type;

Line 464: hr_utility.set_location('p_pactid : ' || p_pactid, 10);

460: l_report_type varchar2(50);
461:
462: BEGIN
463: hr_utility.set_location('Entering: '||l_proc,1);
464: hr_utility.set_location('p_pactid : ' || p_pactid, 10);
465:
466: OPEN csr_report_type;
467: FETCH csr_report_type INTO l_report_type;
468: CLOSE csr_report_type;

Line 470: hr_utility.set_location('l_report_type: '||l_report_type,1);

466: OPEN csr_report_type;
467: FETCH csr_report_type INTO l_report_type;
468: CLOSE csr_report_type;
469:
470: hr_utility.set_location('l_report_type: '||l_report_type,1);
471: if l_report_type = 'RTI_FPS_REP'
472: then
473: restored(p_pactid);
474: end if;

Line 490: hr_utility.set_location('Leaving: '||l_proc,999);

486: end if;
487:
488: --restored(p_pactid);
489:
490: hr_utility.set_location('Leaving: '||l_proc,999);
491: END gb_pay_rollback;
492: ---
493:
494: /*Below procedure is created to implement GB related rollback changes when records are

Line 511: hr_utility.set_location('Entering: '||l_proc,1);

507: WHERE payroll_action_id = p_pactid;
508:
509: l_report_type varchar2(50);
510: BEGIN
511: hr_utility.set_location('Entering: '||l_proc,1);
512: hr_utility.set_location('p_pactid : ' || p_pactid, 10);
513: hr_utility.set_location('p_asgactid : ' || p_asgactid, 10);
514:
515: OPEN csr_report_type;

Line 512: hr_utility.set_location('p_pactid : ' || p_pactid, 10);

508:
509: l_report_type varchar2(50);
510: BEGIN
511: hr_utility.set_location('Entering: '||l_proc,1);
512: hr_utility.set_location('p_pactid : ' || p_pactid, 10);
513: hr_utility.set_location('p_asgactid : ' || p_asgactid, 10);
514:
515: OPEN csr_report_type;
516: FETCH csr_report_type INTO l_report_type;

Line 513: hr_utility.set_location('p_asgactid : ' || p_asgactid, 10);

509: l_report_type varchar2(50);
510: BEGIN
511: hr_utility.set_location('Entering: '||l_proc,1);
512: hr_utility.set_location('p_pactid : ' || p_pactid, 10);
513: hr_utility.set_location('p_asgactid : ' || p_asgactid, 10);
514:
515: OPEN csr_report_type;
516: FETCH csr_report_type INTO l_report_type;
517: CLOSE csr_report_type;

Line 519: hr_utility.set_location('l_report_type: '||l_report_type,1);

515: OPEN csr_report_type;
516: FETCH csr_report_type INTO l_report_type;
517: CLOSE csr_report_type;
518:
519: hr_utility.set_location('l_report_type: '||l_report_type,1);
520: if l_report_type = 'RTI_FPS_REP'
521: then
522: restored(p_pactid, p_asgactid);
523: end if;

Line 538: hr_utility.set_location('Leaving: '||l_proc,999);

534: eas13_restored(p_pactid, p_asgactid);
535: end if;
536: --restored(p_pactid, p_asgactid);
537:
538: hr_utility.set_location('Leaving: '||l_proc,999);
539: END gb_asg_rollback;
540: ---
541: END PAY_GB_ROLLBACK;