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

Line 9: g_debug boolean := hr_utility.debug_enabled;

5: -- | Private Global Definitions |
6: -- --------------------------------------------------------------------------
7: --
8: g_package varchar2(33):=' ben_cwb_single_per_process_pkg.';
9: g_debug boolean := hr_utility.debug_enabled;
10: --
11: -- --------------------------------------------------------------------------
12: -- |----------------------< process >---------------------|
13: -- --------------------------------------------------------------------------

Line 543: hr_utility.set_location('Entering:'|| l_proc, 10);

539: l_proc varchar2(72) := g_package||'detect_method_and_warnings';
540: begin
541: --
542: if g_debug then
543: hr_utility.set_location('Entering:'|| l_proc, 10);
544: end if;
545: --
546: -- find the person type of the person
547: open csr_person_type(p_person_id, p_search_date);

Line 552: hr_utility.set_location(l_proc, 20);

548: fetch csr_person_type into p_person_type;
549: close csr_person_type;
550: --
551: if g_debug then
552: hr_utility.set_location(l_proc, 20);
553: end if;
554: --
555: -- Detect method
556: --

Line 565: hr_utility.set_location(l_proc, 30);

561: ,l_post_process_stat_cd
562: ,l_rates_id;
563: --
564: if g_debug then
565: hr_utility.set_location(l_proc, 30);
566: end if;
567: --
568: -- check whether the pil is present and has the status 'PROCESSED'
569: if (csr_pil_details%found) then

Line 572: hr_utility.set_location(l_proc, 40);

568: -- check whether the pil is present and has the status 'PROCESSED'
569: if (csr_pil_details%found) then
570: --
571: if g_debug then
572: hr_utility.set_location(l_proc, 40);
573: end if;
574: --
575: -- pil is present
576: if (l_post_process_stat_cd = 'PR') then

Line 602: hr_utility.set_location(l_proc, 50);

598: close csr_pds_details;
599: else
600: --
601: if g_debug then
602: hr_utility.set_location(l_proc, 50);
603: end if;
604: --
605: -- the person is going to processed for the first time.
606: -- check normal processing or special processing

Line 611: hr_utility.set_location(l_proc, 60);

607: if (p_person_type = 'EMP') then
608: -- check the pds details as on lf_evt_dt
609: --
610: if g_debug then
611: hr_utility.set_location(l_proc, 60);
612: end if;
613: --
614: open csr_pds_details(p_person_id, p_lf_evt_dt);
615: fetch csr_pds_details into l_date_start

Line 633: hr_utility.set_location(l_proc, 70);

629: close csr_pds_details;
630: else -- the person is 'CWK'
631: --
632: if g_debug then
633: hr_utility.set_location(l_proc, 70);
634: end if;
635: --
636: -- check the pds details as on lf_evt_dt
637: open csr_pdp_details(p_person_id, p_lf_evt_dt);

Line 661: hr_utility.set_location(l_proc, 80);

657: --
658: close csr_pil_details;
659: --
660: if g_debug then
661: hr_utility.set_location(l_proc, 80);
662: end if;
663: --
664: -- Detect the employement period and warnings
665:

Line 693: hr_utility.set_location(l_proc, 90);

689: --
690: end if;
691: --
692: if g_debug then
693: hr_utility.set_location(l_proc, 90);
694: end if;
695: --
696: -- find the eff_date in this order : data_freeze_date, lf_evt_dt
697: l_eff_date := p_data_freeze_date;

Line 704: hr_utility.set_location(l_proc, 100);

700: end if;
701: --
702: --
703: if g_debug then
704: hr_utility.set_location(l_proc, 100);
705: end if;
706: --
707: -- set the warnings
708: open csr_other_details(p_person_id, l_eff_date);

Line 734: hr_utility.set_location(l_proc, 110);

730: close csr_other_details;
731: --
732: --
733: if g_debug then
734: hr_utility.set_location(l_proc, 110);
735: end if;
736: --
737: l_date_start := null; l_act_term_date := null;
738: l_final_proc_date := null; l_proj_term_date := null;

Line 760: hr_utility.set_location(l_proc, 120);

756: end if;
757: --
758: --
759: if g_debug then
760: hr_utility.set_location(l_proc, 120);
761: end if;
762: --
763: l_term_date := l_act_term_date;
764: if l_term_date is null then

Line 773: hr_utility.set_location(l_proc, 130);

769: end if;
770: --
771: --
772: if g_debug then
773: hr_utility.set_location(l_proc, 130);
774: end if;
775: --
776: if l_term_date is not null then
777: if l_term_date <= l_eff_date then

Line 786: hr_utility.set_location(l_proc, 140);

782: end if;
783: --
784: --
785: if g_debug then
786: hr_utility.set_location(l_proc, 140);
787: end if;
788: --
789: -- set the p_method_display with lookup value
790: select meaning into p_method_display

Line 804: hr_utility.set_location(p_method,10);

800: and lookup_code = 'ONGOING';
801: end if;
802: --
803: if g_debug then
804: hr_utility.set_location(p_method,10);
805: hr_utility.set_location(p_start_date,20);
806: hr_utility.set_location(p_term_date,30);
807: hr_utility.set_location(p_no_payroll_warn,40);
808: hr_utility.set_location(p_no_salary_warn,50);

Line 805: hr_utility.set_location(p_start_date,20);

801: end if;
802: --
803: if g_debug then
804: hr_utility.set_location(p_method,10);
805: hr_utility.set_location(p_start_date,20);
806: hr_utility.set_location(p_term_date,30);
807: hr_utility.set_location(p_no_payroll_warn,40);
808: hr_utility.set_location(p_no_salary_warn,50);
809: hr_utility.set_location(p_no_supervisor_warn,60);

Line 806: hr_utility.set_location(p_term_date,30);

802: --
803: if g_debug then
804: hr_utility.set_location(p_method,10);
805: hr_utility.set_location(p_start_date,20);
806: hr_utility.set_location(p_term_date,30);
807: hr_utility.set_location(p_no_payroll_warn,40);
808: hr_utility.set_location(p_no_salary_warn,50);
809: hr_utility.set_location(p_no_supervisor_warn,60);
810: hr_utility.set_location(p_no_position_warn,70);

Line 807: hr_utility.set_location(p_no_payroll_warn,40);

803: if g_debug then
804: hr_utility.set_location(p_method,10);
805: hr_utility.set_location(p_start_date,20);
806: hr_utility.set_location(p_term_date,30);
807: hr_utility.set_location(p_no_payroll_warn,40);
808: hr_utility.set_location(p_no_salary_warn,50);
809: hr_utility.set_location(p_no_supervisor_warn,60);
810: hr_utility.set_location(p_no_position_warn,70);
811: hr_utility.set_location(p_no_paybasis_warn,80);

Line 808: hr_utility.set_location(p_no_salary_warn,50);

804: hr_utility.set_location(p_method,10);
805: hr_utility.set_location(p_start_date,20);
806: hr_utility.set_location(p_term_date,30);
807: hr_utility.set_location(p_no_payroll_warn,40);
808: hr_utility.set_location(p_no_salary_warn,50);
809: hr_utility.set_location(p_no_supervisor_warn,60);
810: hr_utility.set_location(p_no_position_warn,70);
811: hr_utility.set_location(p_no_paybasis_warn,80);
812: hr_utility.set_location(p_past_term_warn,90);

Line 809: hr_utility.set_location(p_no_supervisor_warn,60);

805: hr_utility.set_location(p_start_date,20);
806: hr_utility.set_location(p_term_date,30);
807: hr_utility.set_location(p_no_payroll_warn,40);
808: hr_utility.set_location(p_no_salary_warn,50);
809: hr_utility.set_location(p_no_supervisor_warn,60);
810: hr_utility.set_location(p_no_position_warn,70);
811: hr_utility.set_location(p_no_paybasis_warn,80);
812: hr_utility.set_location(p_past_term_warn,90);
813: hr_utility.set_location(p_future_term_warn,100);

Line 810: hr_utility.set_location(p_no_position_warn,70);

806: hr_utility.set_location(p_term_date,30);
807: hr_utility.set_location(p_no_payroll_warn,40);
808: hr_utility.set_location(p_no_salary_warn,50);
809: hr_utility.set_location(p_no_supervisor_warn,60);
810: hr_utility.set_location(p_no_position_warn,70);
811: hr_utility.set_location(p_no_paybasis_warn,80);
812: hr_utility.set_location(p_past_term_warn,90);
813: hr_utility.set_location(p_future_term_warn,100);
814: hr_utility.set_location(p_curr_absence_warn,110);

Line 811: hr_utility.set_location(p_no_paybasis_warn,80);

807: hr_utility.set_location(p_no_payroll_warn,40);
808: hr_utility.set_location(p_no_salary_warn,50);
809: hr_utility.set_location(p_no_supervisor_warn,60);
810: hr_utility.set_location(p_no_position_warn,70);
811: hr_utility.set_location(p_no_paybasis_warn,80);
812: hr_utility.set_location(p_past_term_warn,90);
813: hr_utility.set_location(p_future_term_warn,100);
814: hr_utility.set_location(p_curr_absence_warn,110);
815: hr_utility.set_location(p_future_absence_warn,120);

Line 812: hr_utility.set_location(p_past_term_warn,90);

808: hr_utility.set_location(p_no_salary_warn,50);
809: hr_utility.set_location(p_no_supervisor_warn,60);
810: hr_utility.set_location(p_no_position_warn,70);
811: hr_utility.set_location(p_no_paybasis_warn,80);
812: hr_utility.set_location(p_past_term_warn,90);
813: hr_utility.set_location(p_future_term_warn,100);
814: hr_utility.set_location(p_curr_absence_warn,110);
815: hr_utility.set_location(p_future_absence_warn,120);
816: hr_utility.set_location(p_person_type,120);

Line 813: hr_utility.set_location(p_future_term_warn,100);

809: hr_utility.set_location(p_no_supervisor_warn,60);
810: hr_utility.set_location(p_no_position_warn,70);
811: hr_utility.set_location(p_no_paybasis_warn,80);
812: hr_utility.set_location(p_past_term_warn,90);
813: hr_utility.set_location(p_future_term_warn,100);
814: hr_utility.set_location(p_curr_absence_warn,110);
815: hr_utility.set_location(p_future_absence_warn,120);
816: hr_utility.set_location(p_person_type,120);
817: end if;

Line 814: hr_utility.set_location(p_curr_absence_warn,110);

810: hr_utility.set_location(p_no_position_warn,70);
811: hr_utility.set_location(p_no_paybasis_warn,80);
812: hr_utility.set_location(p_past_term_warn,90);
813: hr_utility.set_location(p_future_term_warn,100);
814: hr_utility.set_location(p_curr_absence_warn,110);
815: hr_utility.set_location(p_future_absence_warn,120);
816: hr_utility.set_location(p_person_type,120);
817: end if;
818: --

Line 815: hr_utility.set_location(p_future_absence_warn,120);

811: hr_utility.set_location(p_no_paybasis_warn,80);
812: hr_utility.set_location(p_past_term_warn,90);
813: hr_utility.set_location(p_future_term_warn,100);
814: hr_utility.set_location(p_curr_absence_warn,110);
815: hr_utility.set_location(p_future_absence_warn,120);
816: hr_utility.set_location(p_person_type,120);
817: end if;
818: --
819: if g_debug then

Line 816: hr_utility.set_location(p_person_type,120);

812: hr_utility.set_location(p_past_term_warn,90);
813: hr_utility.set_location(p_future_term_warn,100);
814: hr_utility.set_location(p_curr_absence_warn,110);
815: hr_utility.set_location(p_future_absence_warn,120);
816: hr_utility.set_location(p_person_type,120);
817: end if;
818: --
819: if g_debug then
820: hr_utility.set_location(' Leaving:'|| l_proc, 999);

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

816: hr_utility.set_location(p_person_type,120);
817: end if;
818: --
819: if g_debug then
820: hr_utility.set_location(' Leaving:'|| l_proc, 999);
821: end if;
822: --
823: end;
824: -- --------------------------------------------------------------------------

Line 873: hr_utility.set_location('Entering:'|| l_proc, 10);

869: ben_batch_utils.write(p_backout_and_process_flag);
870: ben_batch_utils.write('-');
871:
872: if g_debug then
873: hr_utility.set_location('Entering:'|| l_proc, 10);
874: hr_utility.set_location('p_effective_date :'||p_effective_date,20);
875: hr_utility.set_location('p_person_id :'||p_person_id,30);
876: hr_utility.set_location('p_business_group_id :'||p_business_group_id,40);
877: hr_utility.set_location('p_group_pl_id :'||p_group_pl_id, 50);

Line 874: hr_utility.set_location('p_effective_date :'||p_effective_date,20);

870: ben_batch_utils.write('-');
871:
872: if g_debug then
873: hr_utility.set_location('Entering:'|| l_proc, 10);
874: hr_utility.set_location('p_effective_date :'||p_effective_date,20);
875: hr_utility.set_location('p_person_id :'||p_person_id,30);
876: hr_utility.set_location('p_business_group_id :'||p_business_group_id,40);
877: hr_utility.set_location('p_group_pl_id :'||p_group_pl_id, 50);
878: hr_utility.set_location('p_lf_evt_ocrd_dt :'||p_lf_evt_ocrd_dt, 60);

Line 875: hr_utility.set_location('p_person_id :'||p_person_id,30);

871:
872: if g_debug then
873: hr_utility.set_location('Entering:'|| l_proc, 10);
874: hr_utility.set_location('p_effective_date :'||p_effective_date,20);
875: hr_utility.set_location('p_person_id :'||p_person_id,30);
876: hr_utility.set_location('p_business_group_id :'||p_business_group_id,40);
877: hr_utility.set_location('p_group_pl_id :'||p_group_pl_id, 50);
878: hr_utility.set_location('p_lf_evt_ocrd_dt :'||p_lf_evt_ocrd_dt, 60);
879: hr_utility.set_location('p_clone_all_data :'||p_clone_all_data_flag,70);

Line 876: hr_utility.set_location('p_business_group_id :'||p_business_group_id,40);

872: if g_debug then
873: hr_utility.set_location('Entering:'|| l_proc, 10);
874: hr_utility.set_location('p_effective_date :'||p_effective_date,20);
875: hr_utility.set_location('p_person_id :'||p_person_id,30);
876: hr_utility.set_location('p_business_group_id :'||p_business_group_id,40);
877: hr_utility.set_location('p_group_pl_id :'||p_group_pl_id, 50);
878: hr_utility.set_location('p_lf_evt_ocrd_dt :'||p_lf_evt_ocrd_dt, 60);
879: hr_utility.set_location('p_clone_all_data :'||p_clone_all_data_flag,70);
880: hr_utility.set_location('p_backout_and_process_flag :'

Line 877: hr_utility.set_location('p_group_pl_id :'||p_group_pl_id, 50);

873: hr_utility.set_location('Entering:'|| l_proc, 10);
874: hr_utility.set_location('p_effective_date :'||p_effective_date,20);
875: hr_utility.set_location('p_person_id :'||p_person_id,30);
876: hr_utility.set_location('p_business_group_id :'||p_business_group_id,40);
877: hr_utility.set_location('p_group_pl_id :'||p_group_pl_id, 50);
878: hr_utility.set_location('p_lf_evt_ocrd_dt :'||p_lf_evt_ocrd_dt, 60);
879: hr_utility.set_location('p_clone_all_data :'||p_clone_all_data_flag,70);
880: hr_utility.set_location('p_backout_and_process_flag :'
881: ||p_backout_and_process_flag, 80);

Line 878: hr_utility.set_location('p_lf_evt_ocrd_dt :'||p_lf_evt_ocrd_dt, 60);

874: hr_utility.set_location('p_effective_date :'||p_effective_date,20);
875: hr_utility.set_location('p_person_id :'||p_person_id,30);
876: hr_utility.set_location('p_business_group_id :'||p_business_group_id,40);
877: hr_utility.set_location('p_group_pl_id :'||p_group_pl_id, 50);
878: hr_utility.set_location('p_lf_evt_ocrd_dt :'||p_lf_evt_ocrd_dt, 60);
879: hr_utility.set_location('p_clone_all_data :'||p_clone_all_data_flag,70);
880: hr_utility.set_location('p_backout_and_process_flag :'
881: ||p_backout_and_process_flag, 80);
882: end if;

Line 879: hr_utility.set_location('p_clone_all_data :'||p_clone_all_data_flag,70);

875: hr_utility.set_location('p_person_id :'||p_person_id,30);
876: hr_utility.set_location('p_business_group_id :'||p_business_group_id,40);
877: hr_utility.set_location('p_group_pl_id :'||p_group_pl_id, 50);
878: hr_utility.set_location('p_lf_evt_ocrd_dt :'||p_lf_evt_ocrd_dt, 60);
879: hr_utility.set_location('p_clone_all_data :'||p_clone_all_data_flag,70);
880: hr_utility.set_location('p_backout_and_process_flag :'
881: ||p_backout_and_process_flag, 80);
882: end if;
883:

Line 880: hr_utility.set_location('p_backout_and_process_flag :'

876: hr_utility.set_location('p_business_group_id :'||p_business_group_id,40);
877: hr_utility.set_location('p_group_pl_id :'||p_group_pl_id, 50);
878: hr_utility.set_location('p_lf_evt_ocrd_dt :'||p_lf_evt_ocrd_dt, 60);
879: hr_utility.set_location('p_clone_all_data :'||p_clone_all_data_flag,70);
880: hr_utility.set_location('p_backout_and_process_flag :'
881: ||p_backout_and_process_flag, 80);
882: end if;
883:
884: ben_manage_cwb_life_events.global_online_process_w(

Line 895: hr_utility.set_location(l_proc, 20);

891: ,p_clone_all_data_flag => p_clone_all_data_flag
892: ,p_backout_and_process_flag => p_backout_and_process_flag);
893: --
894: if g_debug then
895: hr_utility.set_location(l_proc, 20);
896: end if;
897: --
898: -- find the group_per_in_ler_id and elig_status of the person
899: begin

Line 952: hr_utility.set_location(l_proc, 30);

948: and rownum = 1;
949: --
950: --
951: if g_debug then
952: hr_utility.set_location(l_proc, 30);
953: end if;
954: --
955: -- set the values to out parameters
956: p_group_per_in_ler_id := l_group_per_in_ler_id;

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

965: exception
966: when others then
967: --
968: if g_debug then
969: hr_utility.set_location(' Leaving:'|| l_proc, 49);
970: end if;
971: --
972: p_group_per_in_ler_id := -1;
973: end;

Line 976: hr_utility.set_location(' Leaving:'|| l_proc, 99);

972: p_group_per_in_ler_id := -1;
973: end;
974: --
975: if g_debug then
976: hr_utility.set_location(' Leaving:'|| l_proc, 99);
977: end if;
978: --
979: end;
980: end BEN_CWB_SINGLE_PER_PROCESS_PKG;