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.BEN_IRC_UTIL dependencies on HR_UTILITY

Line 275: hr_utility.set_location('Entering:'||l_proc, 5);

271:
272: --
273: begin
274: --
275: hr_utility.set_location('Entering:'||l_proc, 5);
276: -- dbms_output.put_line('Entering');
277: --
278: -- Get the last updated date from pil record for IREC LE run
279: --

Line 310: hr_utility.set_location('l_per_last_upd_date is '||l_per_last_upd_date, 999);

306: open c_per_last_upd_date(l_pil_last_upd_date);
307: fetch c_per_last_upd_date into l_per_last_upd_date;
308: close c_per_last_upd_date;
309: --
310: hr_utility.set_location('l_per_last_upd_date is '||l_per_last_upd_date, 999);
311: hr_utility.set_location('l_pil_last_upd_date is '||l_pil_last_upd_date, 999);
312: --
313: if (nvl(l_per_last_upd_date,l_pil_last_upd_date) > l_pil_last_upd_date) then
314: l_run_benmngle := 'Y' ;

Line 311: hr_utility.set_location('l_pil_last_upd_date is '||l_pil_last_upd_date, 999);

307: fetch c_per_last_upd_date into l_per_last_upd_date;
308: close c_per_last_upd_date;
309: --
310: hr_utility.set_location('l_per_last_upd_date is '||l_per_last_upd_date, 999);
311: hr_utility.set_location('l_pil_last_upd_date is '||l_pil_last_upd_date, 999);
312: --
313: if (nvl(l_per_last_upd_date,l_pil_last_upd_date) > l_pil_last_upd_date) then
314: l_run_benmngle := 'Y' ;
315: return l_run_benmngle;

Line 611: hr_utility.set_location (' Entering ben_irc_util.void_or_restore_life_event ',

607: 3.Update person_life_event (PIL)
608: 4.update potential Life event (PPL)
609: 5.update pil_electbl_choice_popl (PEL)
610: ***/
611: hr_utility.set_location (' Entering ben_irc_util.void_or_restore_life_event ',
612: 10
613: );
614: /***
615: p_void_per_in_ler_id As null

Line 619: hr_utility.set_location ('p_void_per_in_ler_id is NULL ', 888);

615: p_void_per_in_ler_id As null
616: ***/
617: IF p_void_per_in_ler_id IS NULL
618: THEN
619: hr_utility.set_location ('p_void_per_in_ler_id is NULL ', 888);
620: OPEN c_get_pil;
621:
622: LOOP
623: FETCH c_get_pil INTO l_get_pil;

Line 627: hr_utility.set_location ('Voiding starts ', 999);

623: FETCH c_get_pil INTO l_get_pil;
624: EXIT WHEN c_get_pil%NOTFOUND;
625: /*** Update PIl,PEL,PPL
626: ***/
627: hr_utility.set_location ('Voiding starts ', 999);
628: hr_utility.set_location ('Before update_person_life_event ', 9901);
629: ben_person_life_event_api.update_person_life_event (p_per_in_ler_id => l_get_pil.per_in_ler_id,
630: p_bckt_per_in_ler_id => NULL,
631: p_per_in_ler_stat_cd => 'VOIDD',

Line 628: hr_utility.set_location ('Before update_person_life_event ', 9901);

624: EXIT WHEN c_get_pil%NOTFOUND;
625: /*** Update PIl,PEL,PPL
626: ***/
627: hr_utility.set_location ('Voiding starts ', 999);
628: hr_utility.set_location ('Before update_person_life_event ', 9901);
629: ben_person_life_event_api.update_person_life_event (p_per_in_ler_id => l_get_pil.per_in_ler_id,
630: p_bckt_per_in_ler_id => NULL,
631: p_per_in_ler_stat_cd => 'VOIDD',
632: p_prvs_stat_cd => l_get_pil.per_in_ler_stat_cd,

Line 642: hr_utility.set_location ('Before update_ptnl_ler_for_per_perf ',

638: );
639: OPEN c_ptnl (l_get_pil.ptnl_ler_for_per_id);
640: FETCH c_ptnl INTO l_ptnl;
641: CLOSE c_ptnl;
642: hr_utility.set_location ('Before update_ptnl_ler_for_per_perf ',
643: 9902);
644: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf (p_validate => FALSE,
645: p_ptnl_ler_for_per_id => l_ptnl.ptnl_ler_for_per_id,
646: p_ptnl_ler_for_per_stat_cd => 'VOIDD',

Line 658: hr_utility.set_location ('Before update_pil_elctbl_chc_popl ', 9903);

654: p_program_update_date => SYSDATE,
655: p_voidd_dt => p_effective_date
656: );
657: OPEN c_pil_elctbl_chc_popl (l_get_pil.per_in_ler_id);
658: hr_utility.set_location ('Before update_pil_elctbl_chc_popl ', 9903);
659:
660: LOOP
661: FETCH c_pil_elctbl_chc_popl INTO l_pel_pk_id,
662: l_pel_object_version_number;

Line 673: hr_utility.set_location ('After update_pil_elctbl_chc_popl ', 9904);

669: p_effective_date => p_effective_date
670: );
671: END LOOP;
672:
673: hr_utility.set_location ('After update_pil_elctbl_chc_popl ', 9904);
674: CLOSE c_pil_elctbl_chc_popl;
675: END LOOP;
676:
677: CLOSE c_get_pil;

Line 686: hr_utility.set_location ('p_void_per_in_ler_id is NOT NULL ', 888);

682: ***/
683: IF p_void_per_in_ler_id IS NOT NULL
684: THEN
685: -- Step 1
686: hr_utility.set_location ('p_void_per_in_ler_id is NOT NULL ', 888);
687: OPEN c_pil (p_void_per_in_ler_id);
688: FETCH c_pil INTO l_pil;
689: CLOSE c_pil;
690:

Line 716: hr_utility.set_location ('Voiding starts ', 222);

712:
713: IF l_pil.per_in_ler_stat_cd <> 'VOIDD'
714: THEN
715: --step 3
716: hr_utility.set_location ('Voiding starts ', 222);
717: hr_utility.set_location ('Before update_person_life_event ', 111);
718: ben_person_life_event_api.update_person_life_event (p_per_in_ler_id => p_void_per_in_ler_id,
719: p_bckt_per_in_ler_id => NULL,
720: p_per_in_ler_stat_cd => 'VOIDD',

Line 717: hr_utility.set_location ('Before update_person_life_event ', 111);

713: IF l_pil.per_in_ler_stat_cd <> 'VOIDD'
714: THEN
715: --step 3
716: hr_utility.set_location ('Voiding starts ', 222);
717: hr_utility.set_location ('Before update_person_life_event ', 111);
718: ben_person_life_event_api.update_person_life_event (p_per_in_ler_id => p_void_per_in_ler_id,
719: p_bckt_per_in_ler_id => NULL,
720: p_per_in_ler_stat_cd => 'VOIDD',
721: p_prvs_stat_cd => l_pil.per_in_ler_stat_cd,

Line 728: hr_utility.set_location ('After update_person_life_event ', 111);

724: p_procd_dt => l_procd_dt,
725: p_strtd_dt => l_strtd_dt,
726: p_voidd_dt => l_voidd_dt
727: );
728: hr_utility.set_location ('After update_person_life_event ', 111);
729: -- step 4
730: OPEN c_ptnl (l_pil.ptnl_ler_for_per_id);
731: FETCH c_ptnl INTO l_ptnl;
732: CLOSE c_ptnl;

Line 733: hr_utility.set_location ('Before update_ptnl_ler_for_per_perf ', 111);

729: -- step 4
730: OPEN c_ptnl (l_pil.ptnl_ler_for_per_id);
731: FETCH c_ptnl INTO l_ptnl;
732: CLOSE c_ptnl;
733: hr_utility.set_location ('Before update_ptnl_ler_for_per_perf ', 111);
734: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf (p_validate => FALSE,
735: p_ptnl_ler_for_per_id => l_ptnl.ptnl_ler_for_per_id,
736: p_ptnl_ler_for_per_stat_cd => 'VOIDD',
737: p_person_id => l_ptnl.person_id,

Line 747: hr_utility.set_location ('After update_ptnl_ler_for_per_perf ', 111);

743: p_request_id => fnd_global.conc_request_id,
744: p_program_update_date => SYSDATE,
745: p_voidd_dt => p_effective_date
746: );
747: hr_utility.set_location ('After update_ptnl_ler_for_per_perf ', 111);
748: -- step 5
749: OPEN c_pil_elctbl_chc_popl (p_void_per_in_ler_id);
750: hr_utility.set_location ('Before update_pil_elctbl_chc_popl ', 111);
751:

Line 750: hr_utility.set_location ('Before update_pil_elctbl_chc_popl ', 111);

746: );
747: hr_utility.set_location ('After update_ptnl_ler_for_per_perf ', 111);
748: -- step 5
749: OPEN c_pil_elctbl_chc_popl (p_void_per_in_ler_id);
750: hr_utility.set_location ('Before update_pil_elctbl_chc_popl ', 111);
751:
752: LOOP
753: FETCH c_pil_elctbl_chc_popl INTO l_pel_pk_id,
754: l_pel_object_version_number;

Line 765: hr_utility.set_location ('After update_pil_elctbl_chc_popl ', 111);

761: p_effective_date => p_effective_date
762: );
763: END LOOP;
764:
765: hr_utility.set_location ('After update_pil_elctbl_chc_popl ', 111);
766: CLOSE c_pil_elctbl_chc_popl;
767: END IF; --l_pil.per_in_ler_stat_cd <> 'VOIDD'
768: END IF; --p_void_per_in_ler_id IS NOT NULL
769:

Line 822: hr_utility.set_location ('Restoring starts ', 222);

818:
819: IF l_pil.per_in_ler_stat_cd NOT IN ('STRTD', 'VOIDD')
820: THEN
821: -- Step 4
822: hr_utility.set_location ('Restoring starts ', 222);
823: hr_utility.set_location ('Before update_person_life_event ', 222);
824: ben_person_life_event_api.update_person_life_event (p_per_in_ler_id => p_restore_per_in_ler_id,
825: p_bckt_per_in_ler_id => NULL,
826: p_per_in_ler_stat_cd => 'STRTD',

Line 823: hr_utility.set_location ('Before update_person_life_event ', 222);

819: IF l_pil.per_in_ler_stat_cd NOT IN ('STRTD', 'VOIDD')
820: THEN
821: -- Step 4
822: hr_utility.set_location ('Restoring starts ', 222);
823: hr_utility.set_location ('Before update_person_life_event ', 222);
824: ben_person_life_event_api.update_person_life_event (p_per_in_ler_id => p_restore_per_in_ler_id,
825: p_bckt_per_in_ler_id => NULL,
826: p_per_in_ler_stat_cd => 'STRTD',
827: p_prvs_stat_cd => l_pil.per_in_ler_stat_cd,

Line 834: hr_utility.set_location ('After update_person_life_event ', 222);

830: p_procd_dt => l_procd_dt,
831: p_strtd_dt => l_strtd_dt,
832: p_voidd_dt => l_voidd_dt
833: );
834: hr_utility.set_location ('After update_person_life_event ', 222);
835: -- step 5
836: OPEN c_ptnl (l_pil.ptnl_ler_for_per_id);
837: FETCH c_ptnl INTO l_ptnl;
838: CLOSE c_ptnl;

Line 839: hr_utility.set_location ('Before update_ptnl_ler_for_per_perf ', 222);

835: -- step 5
836: OPEN c_ptnl (l_pil.ptnl_ler_for_per_id);
837: FETCH c_ptnl INTO l_ptnl;
838: CLOSE c_ptnl;
839: hr_utility.set_location ('Before update_ptnl_ler_for_per_perf ', 222);
840: ben_ptnl_ler_for_per_api.update_ptnl_ler_for_per_perf (p_validate => FALSE,
841: p_ptnl_ler_for_per_id => l_ptnl.ptnl_ler_for_per_id,
842: p_ptnl_ler_for_per_stat_cd => 'PROCD',
843: p_lf_evt_ocrd_dt => l_pil.lf_evt_ocrd_dt,

Line 854: hr_utility.set_location ('After update_ptnl_ler_for_per_perf ', 222);

850: p_program_id => fnd_global.conc_program_id,
851: p_request_id => fnd_global.conc_request_id,
852: p_program_update_date => SYSDATE
853: );
854: hr_utility.set_location ('After update_ptnl_ler_for_per_perf ', 222);
855: -- step 6
856: OPEN c_pil_elctbl_chc_popl (l_pil.per_in_ler_id);
857: hr_utility.set_location ('Before update_pil_elctbl_chc_popl ', 222);
858:

Line 857: hr_utility.set_location ('Before update_pil_elctbl_chc_popl ', 222);

853: );
854: hr_utility.set_location ('After update_ptnl_ler_for_per_perf ', 222);
855: -- step 6
856: OPEN c_pil_elctbl_chc_popl (l_pil.per_in_ler_id);
857: hr_utility.set_location ('Before update_pil_elctbl_chc_popl ', 222);
858:
859: LOOP
860: FETCH c_pil_elctbl_chc_popl INTO l_pel_pk_id,
861: l_pel_object_version_number;

Line 871: hr_utility.set_location ('After update_pil_elctbl_chc_popl ', 222);

867: p_effective_date => p_effective_date
868: );
869: END LOOP;
870:
871: hr_utility.set_location ('After update_pil_elctbl_chc_popl ', 222);
872: CLOSE c_pil_elctbl_chc_popl;
873: END IF;
874: END IF; --IF p_restore_per_in_ler_id IS NOT NULL
875:

Line 876: hr_utility.set_location ('Leaving ben_irc_util.void_or_restore_life_event',

872: CLOSE c_pil_elctbl_chc_popl;
873: END IF;
874: END IF; --IF p_restore_per_in_ler_id IS NOT NULL
875:
876: hr_utility.set_location ('Leaving ben_irc_util.void_or_restore_life_event',
877: 20
878: );
879: END void_or_restore_life_event;
880: