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

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

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

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

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

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

60: FROM pay_payroll_actions
61: WHERE payroll_action_id = p_pactid;
62:
63: BEGIN
64: hr_utility.set_location('Entering: '||l_proc,1);
65:
66: OPEN csr_report_type;
67: FETCH csr_report_type INTO l_report_type;
68: CLOSE csr_report_type;

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

66: OPEN csr_report_type;
67: FETCH csr_report_type INTO l_report_type;
68: CLOSE csr_report_type;
69:
70: hr_utility.set_location('l_report_type: '||l_report_type,1);
71:
72: hr_utility.set_location('Leaving: '||l_proc,999);
73:
74: RETURN l_report_type;

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

68: CLOSE csr_report_type;
69:
70: hr_utility.set_location('l_report_type: '||l_report_type,1);
71:
72: hr_utility.set_location('Leaving: '||l_proc,999);
73:
74: RETURN l_report_type;
75:
76: END;

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

140:
141: l_asgact_rec csr_archive_asgact_details%rowtype;
142: l_report_type varchar2(50);
143: BEGIN
144: hr_utility.set_location('Entering: '||l_proc,1);
145: hr_utility.set_location('p_pactid: '||p_pactid,1);
146: hr_utility.set_location('p_asgactid: '||p_asgactid,1);
147:
148: OPEN csr_report_type;

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

141: l_asgact_rec csr_archive_asgact_details%rowtype;
142: l_report_type varchar2(50);
143: BEGIN
144: hr_utility.set_location('Entering: '||l_proc,1);
145: hr_utility.set_location('p_pactid: '||p_pactid,1);
146: hr_utility.set_location('p_asgactid: '||p_asgactid,1);
147:
148: OPEN csr_report_type;
149: FETCH csr_report_type INTO l_report_type;

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

142: l_report_type varchar2(50);
143: BEGIN
144: hr_utility.set_location('Entering: '||l_proc,1);
145: hr_utility.set_location('p_pactid: '||p_pactid,1);
146: hr_utility.set_location('p_asgactid: '||p_asgactid,1);
147:
148: OPEN csr_report_type;
149: FETCH csr_report_type INTO l_report_type;
150: CLOSE csr_report_type;

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

148: OPEN csr_report_type;
149: FETCH csr_report_type INTO l_report_type;
150: CLOSE csr_report_type;
151:
152: hr_utility.set_location('l_report_type: '||l_report_type,1);
153:
154: IF (NVL(l_report_type,'XXX') = 'RTI_FPS_REP') OR (NVL(l_report_type,'XXX') = 'RTI_FPS_REP_13') THEN
155:
156: IF (p_asgactid is null) THEN

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

303:
304: l_asgact_rec csr_archive_asgact_details%rowtype;
305: l_report_type varchar2(50);
306: BEGIN
307: hr_utility.set_location('Entering: '||l_proc,1);
308: hr_utility.set_location('p_pactid: '||p_pactid,1);
309: hr_utility.set_location('p_asgactid: '||p_asgactid,1);
310:
311: OPEN csr_report_type;

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

304: l_asgact_rec csr_archive_asgact_details%rowtype;
305: l_report_type varchar2(50);
306: BEGIN
307: hr_utility.set_location('Entering: '||l_proc,1);
308: hr_utility.set_location('p_pactid: '||p_pactid,1);
309: hr_utility.set_location('p_asgactid: '||p_asgactid,1);
310:
311: OPEN csr_report_type;
312: FETCH csr_report_type INTO l_report_type;

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

305: l_report_type varchar2(50);
306: BEGIN
307: hr_utility.set_location('Entering: '||l_proc,1);
308: hr_utility.set_location('p_pactid: '||p_pactid,1);
309: hr_utility.set_location('p_asgactid: '||p_asgactid,1);
310:
311: OPEN csr_report_type;
312: FETCH csr_report_type INTO l_report_type;
313: CLOSE csr_report_type;

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

311: OPEN csr_report_type;
312: FETCH csr_report_type INTO l_report_type;
313: CLOSE csr_report_type;
314:
315: hr_utility.set_location('l_report_type: '||l_report_type,1);
316:
317: IF (NVL(l_report_type,'XXX') = 'RTI_EYU_REP_13') THEN
318:
319: IF (p_asgactid is null) THEN

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

439: )
440: and l_effective_date between pay.EFFECTIVE_START_DATE and pay.EFFECTIVE_END_DATE;
441:
442: BEGIN
443: hr_utility.set_location('Entering: '||l_proc,1);
444: hr_utility.set_location('p_pactid: '||p_pactid,1);
445: hr_utility.set_location('p_asgactid: '||p_asgactid,1);
446:
447: open csr_fetch_details;

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

440: and l_effective_date between pay.EFFECTIVE_START_DATE and pay.EFFECTIVE_END_DATE;
441:
442: BEGIN
443: hr_utility.set_location('Entering: '||l_proc,1);
444: hr_utility.set_location('p_pactid: '||p_pactid,1);
445: hr_utility.set_location('p_asgactid: '||p_asgactid,1);
446:
447: open csr_fetch_details;
448: fetch csr_fetch_details into l_effective_date,l_tax_ref;

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

441:
442: BEGIN
443: hr_utility.set_location('Entering: '||l_proc,1);
444: hr_utility.set_location('p_pactid: '||p_pactid,1);
445: hr_utility.set_location('p_asgactid: '||p_asgactid,1);
446:
447: open csr_fetch_details;
448: fetch csr_fetch_details into l_effective_date,l_tax_ref;
449: close csr_fetch_details;

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

477:
478: END LOOP;
479:
480:
481: hr_utility.set_location('Leaving eas_restored: '||p_pactid,1);
482: END eas_restored;
483: ---
484: ---
485:

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

514: and prev.REPORT_TYPE = 'RTI_EAS_REP');
515:
516:
517: BEGIN
518: hr_utility.set_location('Entering: '||l_proc,1);
519: hr_utility.set_location('p_pactid: '||p_pactid,1);
520: hr_utility.set_location('p_asgactid: '||p_asgactid,1);
521:
522:

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

515:
516:
517: BEGIN
518: hr_utility.set_location('Entering: '||l_proc,1);
519: hr_utility.set_location('p_pactid: '||p_pactid,1);
520: hr_utility.set_location('p_asgactid: '||p_asgactid,1);
521:
522:
523:

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

516:
517: BEGIN
518: hr_utility.set_location('Entering: '||l_proc,1);
519: hr_utility.set_location('p_pactid: '||p_pactid,1);
520: hr_utility.set_location('p_asgactid: '||p_asgactid,1);
521:
522:
523:
524: FOR archive_rec IN csr_asgs_processed

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

531: IF (l_ovn IS NOT NULL and l_prev_eas is null)THEN
532: 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_RTI_ASG_DETAILS', p_aei_information8 => 'N');
533: END IF;
534: END LOOP;
535: hr_utility.set_location('Leaving eas_restored: '||p_pactid,1);
536: END eas13_restored;
537: ---
538: ---
539:

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

580: WHERE pei.assignment_id = l_assignment_id
581: AND pei.information_type = 'GB_P46';
582:
583: BEGIN
584: hr_utility.set_location('Entering: '||l_proc,1);
585: if p_type = 'GB WNU EDI' then
586: hr_utility.set_location(p_type,10);
587: for archive_rec in csr_archive_details loop
588: hr_utility.set_location(p_type,20);

Line 586: hr_utility.set_location(p_type,10);

582:
583: BEGIN
584: hr_utility.set_location('Entering: '||l_proc,1);
585: if p_type = 'GB WNU EDI' then
586: hr_utility.set_location(p_type,10);
587: for archive_rec in csr_archive_details loop
588: hr_utility.set_location(p_type,20);
589: l_ovn := get_version(archive_rec.assignment_id,'GB_WNU',l_aei_id);
590: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then

Line 588: hr_utility.set_location(p_type,20);

584: hr_utility.set_location('Entering: '||l_proc,1);
585: if p_type = 'GB WNU EDI' then
586: hr_utility.set_location(p_type,10);
587: for archive_rec in csr_archive_details loop
588: hr_utility.set_location(p_type,20);
589: l_ovn := get_version(archive_rec.assignment_id,'GB_WNU',l_aei_id);
590: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then
591: hr_utility.set_location(p_type,30);
592: hr_assignment_extra_info_api.update_assignment_extra_info

Line 591: hr_utility.set_location(p_type,30);

587: for archive_rec in csr_archive_details loop
588: hr_utility.set_location(p_type,20);
589: l_ovn := get_version(archive_rec.assignment_id,'GB_WNU',l_aei_id);
590: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then
591: hr_utility.set_location(p_type,30);
592: hr_assignment_extra_info_api.update_assignment_extra_info
593: (p_validate => false,
594: p_object_version_number => l_ovn,
595: p_assignment_extra_info_id => l_aei_id,

Line 605: hr_utility.set_location(p_type,10);

601: end loop;
602: end if;
603:
604: if p_type = 'GB P45(3) EDI' then
605: hr_utility.set_location(p_type,10);
606: for archive_rec in csr_archive_details loop
607: hr_utility.set_location(p_type,20);
608: l_ovn := get_version(archive_rec.assignment_id,'GB_P45_3',l_aei_id);
609: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then

Line 607: hr_utility.set_location(p_type,20);

603:
604: if p_type = 'GB P45(3) EDI' then
605: hr_utility.set_location(p_type,10);
606: for archive_rec in csr_archive_details loop
607: hr_utility.set_location(p_type,20);
608: l_ovn := get_version(archive_rec.assignment_id,'GB_P45_3',l_aei_id);
609: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then
610: hr_utility.set_location(p_type,30);
611: hr_assignment_extra_info_api.update_assignment_extra_info

Line 610: hr_utility.set_location(p_type,30);

606: for archive_rec in csr_archive_details loop
607: hr_utility.set_location(p_type,20);
608: l_ovn := get_version(archive_rec.assignment_id,'GB_P45_3',l_aei_id);
609: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then
610: hr_utility.set_location(p_type,30);
611: hr_assignment_extra_info_api.update_assignment_extra_info
612: (p_validate => false,
613: p_object_version_number => l_ovn,
614: p_assignment_extra_info_id => l_aei_id,

Line 622: hr_utility.set_location(p_type,10);

618: end loop;
619: end if;
620: /* EOY Changes P45(3) Version 6 Starts */
621: if p_type = 'GB P45(3) EDI' then
622: hr_utility.set_location(p_type,10);
623: for archive_rec in csr_archive_details loop
624: hr_utility.set_location(p_type,20);
625: l_ovn := get_version(archive_rec.assignment_id,'GB_P45_3',l_aei_id);
626: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then

Line 624: hr_utility.set_location(p_type,20);

620: /* EOY Changes P45(3) Version 6 Starts */
621: if p_type = 'GB P45(3) EDI' then
622: hr_utility.set_location(p_type,10);
623: for archive_rec in csr_archive_details loop
624: hr_utility.set_location(p_type,20);
625: l_ovn := get_version(archive_rec.assignment_id,'GB_P45_3',l_aei_id);
626: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then
627: hr_utility.set_location(p_type,30);
628: hr_assignment_extra_info_api.update_assignment_extra_info

Line 627: hr_utility.set_location(p_type,30);

623: for archive_rec in csr_archive_details loop
624: hr_utility.set_location(p_type,20);
625: l_ovn := get_version(archive_rec.assignment_id,'GB_P45_3',l_aei_id);
626: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then
627: hr_utility.set_location(p_type,30);
628: hr_assignment_extra_info_api.update_assignment_extra_info
629: (p_validate => false,
630: p_object_version_number => l_ovn,
631: p_assignment_extra_info_id => l_aei_id,

Line 640: hr_utility.set_location(p_type,10);

636: end if;
637: /* EOY Changes P45(3) Version 6 Ends */
638:
639: if p_type = 'GB P46 EDI' then
640: hr_utility.set_location(p_type,10);
641: for archive_rec in csr_archive_details loop
642: hr_utility.set_location(p_type,20);
643: l_ovn := get_version(archive_rec.assignment_id,'GB_P46',l_aei_id);
644: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then

Line 642: hr_utility.set_location(p_type,20);

638:
639: if p_type = 'GB P46 EDI' then
640: hr_utility.set_location(p_type,10);
641: for archive_rec in csr_archive_details loop
642: hr_utility.set_location(p_type,20);
643: l_ovn := get_version(archive_rec.assignment_id,'GB_P46',l_aei_id);
644: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then
645: hr_utility.set_location(p_type,30);
646: hr_assignment_extra_info_api.update_assignment_extra_info

Line 645: hr_utility.set_location(p_type,30);

641: for archive_rec in csr_archive_details loop
642: hr_utility.set_location(p_type,20);
643: l_ovn := get_version(archive_rec.assignment_id,'GB_P46',l_aei_id);
644: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then
645: hr_utility.set_location(p_type,30);
646: hr_assignment_extra_info_api.update_assignment_extra_info
647: (p_validate => false,
648: p_object_version_number => l_ovn,
649: p_assignment_extra_info_id => l_aei_id,

Line 659: hr_utility.set_location(p_type,10);

655:
656: /*Changes for P46EXP_Ver6 starts*/
657:
658: if p_type = 'GB P46EXP EDI' then
659: hr_utility.set_location(p_type,10);
660: for archive_rec in csr_archive_details loop
661: hr_utility.set_location(p_type,20);
662: l_ovn := get_version(archive_rec.assignment_id,'GB_P46EXP',l_aei_id);
663: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then

Line 661: hr_utility.set_location(p_type,20);

657:
658: if p_type = 'GB P46EXP EDI' then
659: hr_utility.set_location(p_type,10);
660: for archive_rec in csr_archive_details loop
661: hr_utility.set_location(p_type,20);
662: l_ovn := get_version(archive_rec.assignment_id,'GB_P46EXP',l_aei_id);
663: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then
664: hr_utility.set_location(p_type,30);
665: hr_assignment_extra_info_api.update_assignment_extra_info

Line 664: hr_utility.set_location(p_type,30);

660: for archive_rec in csr_archive_details loop
661: hr_utility.set_location(p_type,20);
662: l_ovn := get_version(archive_rec.assignment_id,'GB_P46EXP',l_aei_id);
663: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then
664: hr_utility.set_location(p_type,30);
665: hr_assignment_extra_info_api.update_assignment_extra_info
666: (p_validate => false,
667: p_object_version_number => l_ovn,
668: p_assignment_extra_info_id => l_aei_id,

Line 679: hr_utility.set_location(p_type,10);

675: /*Changes for P46EXP_Ver6 End*/
676:
677: IF p_type = 'GB P46_5 EDI'
678: THEN
679: hr_utility.set_location(p_type,10);
680: FOR archive_rec IN csr_archive_details
681: LOOP
682: FOR asg_extra IN csr_extra_details(archive_rec.assignment_id)
683: LOOP

Line 737: hr_utility.set_location(p_type,10);

733: END LOOP;
734: END IF;
735:
736: if p_type = 'GB P46 PENNOT EDI' then ---GB P46 Pension EDI
737: hr_utility.set_location(p_type,10);
738: for archive_rec in csr_archive_details loop
739: hr_utility.set_location(p_type,20);
740: l_ovn := get_version(archive_rec.assignment_id,'GB_P46PENNOT',l_aei_id);
741: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then

Line 739: hr_utility.set_location(p_type,20);

735:
736: if p_type = 'GB P46 PENNOT EDI' then ---GB P46 Pension EDI
737: hr_utility.set_location(p_type,10);
738: for archive_rec in csr_archive_details loop
739: hr_utility.set_location(p_type,20);
740: l_ovn := get_version(archive_rec.assignment_id,'GB_P46PENNOT',l_aei_id);
741: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then
742: hr_utility.set_location(p_type,30);
743: hr_assignment_extra_info_api.update_assignment_extra_info

Line 742: hr_utility.set_location(p_type,30);

738: for archive_rec in csr_archive_details loop
739: hr_utility.set_location(p_type,20);
740: l_ovn := get_version(archive_rec.assignment_id,'GB_P46PENNOT',l_aei_id);
741: if l_ovn is not null and not(l_ovn <> archive_rec.action_information1) then
742: hr_utility.set_location(p_type,30);
743: hr_assignment_extra_info_api.update_assignment_extra_info
744: (p_validate => false,
745: p_object_version_number => l_ovn,
746: p_assignment_extra_info_id => l_aei_id,

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

748: p_aei_information1 => 'Y');
749: end if;
750: end loop;
751: end if;
752: hr_utility.set_location('Leaving: '||l_proc,999);
753: END;
754: ---
755:
756: PROCEDURE gb_rollback(

Line 769: --hr_utility.trace_on(null, 'hyd_tra');

765: l_proc CONSTANT VARCHAR2(50):= 'gb_rollback';
766: l_id NUMBER;
767: l_report_type VARCHAR2(50);
768: BEGIN
769: --hr_utility.trace_on(null, 'hyd_tra');
770: hr_utility.set_location('Entering: '||l_proc,1);
771: hr_utility.set_location('Year : ' || p_year, 10);
772: hr_utility.set_location('p_actid : ' || p_actid, 10);
773:

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

766: l_id NUMBER;
767: l_report_type VARCHAR2(50);
768: BEGIN
769: --hr_utility.trace_on(null, 'hyd_tra');
770: hr_utility.set_location('Entering: '||l_proc,1);
771: hr_utility.set_location('Year : ' || p_year, 10);
772: hr_utility.set_location('p_actid : ' || p_actid, 10);
773:
774: l_report_type := get_report_type(p_actid);

Line 771: hr_utility.set_location('Year : ' || p_year, 10);

767: l_report_type VARCHAR2(50);
768: BEGIN
769: --hr_utility.trace_on(null, 'hyd_tra');
770: hr_utility.set_location('Entering: '||l_proc,1);
771: hr_utility.set_location('Year : ' || p_year, 10);
772: hr_utility.set_location('p_actid : ' || p_actid, 10);
773:
774: l_report_type := get_report_type(p_actid);
775:

Line 772: hr_utility.set_location('p_actid : ' || p_actid, 10);

768: BEGIN
769: --hr_utility.trace_on(null, 'hyd_tra');
770: hr_utility.set_location('Entering: '||l_proc,1);
771: hr_utility.set_location('Year : ' || p_year, 10);
772: hr_utility.set_location('p_actid : ' || p_actid, 10);
773:
774: l_report_type := get_report_type(p_actid);
775:
776: hr_utility.set_location('l_report_type: '||l_report_type,10);

Line 776: hr_utility.set_location('l_report_type: '||l_report_type,10);

772: hr_utility.set_location('p_actid : ' || p_actid, 10);
773:
774: l_report_type := get_report_type(p_actid);
775:
776: hr_utility.set_location('l_report_type: '||l_report_type,10);
777:
778: if l_report_type = 'GBEDIWNU' or l_report_type = 'GBEDIWNU3' or l_report_type = 'GBEDIWNU3ET' then -- 5398360 --Added GBEDIWNU3ET for bug 9186359
779: edi_restored('GB WNU EDI',p_actid);
780: end if;

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

843: argument7 => p_asgset, -- assignmenet_set
844: argument8 => 'PAYROLL_ACTION_ID='||p_actid,
845: argument9 => 'ASG_SET_ID='||p_asgset);
846:
847: hr_utility.set_location('Leaving: '||l_proc,999);
848: END gb_rollback;
849:
850: END PAY_GB_ROLLBACK_PKG;