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

Line 129: to hr_utility. set_location

125: 20-dec-01 ikasire 115.43 added dbdrv lines
126: 22-feb-02 pbodla 115.44 Bug 2234582 : Some times null
127: second parameter is giving error.
128: Explicit second parameter is passed
129: to hr_utility. set_location
130: 15-may-02 ikasire 115.45 Bug 2200139 added a new parameter
131: p_elig_per_elctbl_chc_id to the main
132: procedure to called from override
133: process.For other processes it is

Line 143: 13-feb-02 vsethi 115.53 Enclosed all hr_utility debug calls inside if

139: to new column ord_num on ben_acty_base_rt_f
140: 28-Oct-02 kmahendr 115.51 Land O Lakes performance fix - cursor c_enrt_rt
141: split into two.
142: 26-Dec-02 rpillay 115.52 NOCOPY changes
143: 13-feb-02 vsethi 115.53 Enclosed all hr_utility debug calls inside if
144: 13-feb-02 kmahendr 115.54 Added a parameter to call -acty_base_rt.main
145: 15-Apr-02 tjesumic 115.55 # 2897152 When the Std. Rate Calc Method code
146: is No Standard Values Used' NSVU and all vapro
147: attached to the rate are failed then no rate

Line 199: g_debug boolean := hr_utility.debug_enabled;

195: ----------------------------------------------------------------------------------------------
196: g_package VARCHAR2(80) := 'ben_determine_rates';
197: g_rec benutils.g_batch_rate_rec;
198: --
199: g_debug boolean := hr_utility.debug_enabled;
200: --
201: TYPE g_acty_base_rt_id_table IS TABLE OF ben_acty_base_rt_f.acty_base_rt_id%TYPE
202: INDEX BY BINARY_INTEGER;
203: TYPE g_asn_on_enrt_flag_table IS TABLE OF ben_acty_base_rt_f.asn_on_enrt_flag%TYPE

Line 290: hr_utility.set_location('Inside procedure Old Rate ', 0000);

286: l_elctbl_chc_id NUMBER;
287: BEGIN
288: --
289: if g_debug then
290: hr_utility.set_location('Inside procedure Old Rate ', 0000);
291: hr_utility.set_location('elig per elctbl chc id ' || p_elig_per_elctbl_chc_id,0000);
292: hr_utility.set_location('acty base rate id ' || p_acty_base_rt_id, 0000);
293: end if;
294: OPEN c_per_in_ler;

Line 291: hr_utility.set_location('elig per elctbl chc id ' || p_elig_per_elctbl_chc_id,0000);

287: BEGIN
288: --
289: if g_debug then
290: hr_utility.set_location('Inside procedure Old Rate ', 0000);
291: hr_utility.set_location('elig per elctbl chc id ' || p_elig_per_elctbl_chc_id,0000);
292: hr_utility.set_location('acty base rate id ' || p_acty_base_rt_id, 0000);
293: end if;
294: OPEN c_per_in_ler;
295: FETCH c_per_in_ler INTO l_per_in_ler;

Line 292: hr_utility.set_location('acty base rate id ' || p_acty_base_rt_id, 0000);

288: --
289: if g_debug then
290: hr_utility.set_location('Inside procedure Old Rate ', 0000);
291: hr_utility.set_location('elig per elctbl chc id ' || p_elig_per_elctbl_chc_id,0000);
292: hr_utility.set_location('acty base rate id ' || p_acty_base_rt_id, 0000);
293: end if;
294: OPEN c_per_in_ler;
295: FETCH c_per_in_ler INTO l_per_in_ler;
296: CLOSE c_per_in_ler;

Line 571: hr_utility.set_location('Entering ' || l_package, 10);

567: end if;
568: --
569: FOR i IN p_acty_base_rt_id_table.FIRST .. p_acty_base_rt_id_table.LAST LOOP
570: if g_debug then
571: hr_utility.set_location('Entering ' || l_package, 10);
572: end if;
573: --
574:
575: -- Bug: 3234092 Changes begin **********************************************

Line 580: hr_utility.set_location(' ben_env_object: Mode ' || l_env.mode_cd, 10);

576: l_eval_sal_rule := false;
577: ben_env_object.get(p_rec => l_env);
578: --
579: if g_debug then
580: hr_utility.set_location(' ben_env_object: Mode ' || l_env.mode_cd, 10);
581: end if;
582: --
583: -- If mode='G' (gsp) and pgm_typ_cd for the pgm-record is 'GSP'
584: -- and formula is defined at pgm-level

Line 592: hr_utility.set_location('l_pgm_rec.pgm_typ_cd ' || l_pgm_rec.pgm_typ_cd, 20);

588: open c_pgm;
589: fetch c_pgm INTO l_pgm_rec;
590: --
591: if g_debug then
592: hr_utility.set_location('l_pgm_rec.pgm_typ_cd ' || l_pgm_rec.pgm_typ_cd, 20);
593: hr_utility.set_location('l_pgm_rec.salary_calc_mthd_cd ' || l_pgm_rec.salary_calc_mthd_cd, 20);
594: hr_utility.set_location('l_pgm_rec.salary_calc_mthd_rl ' || l_pgm_rec.salary_calc_mthd_rl, 20);
595: end if;
596: --

Line 593: hr_utility.set_location('l_pgm_rec.salary_calc_mthd_cd ' || l_pgm_rec.salary_calc_mthd_cd, 20);

589: fetch c_pgm INTO l_pgm_rec;
590: --
591: if g_debug then
592: hr_utility.set_location('l_pgm_rec.pgm_typ_cd ' || l_pgm_rec.pgm_typ_cd, 20);
593: hr_utility.set_location('l_pgm_rec.salary_calc_mthd_cd ' || l_pgm_rec.salary_calc_mthd_cd, 20);
594: hr_utility.set_location('l_pgm_rec.salary_calc_mthd_rl ' || l_pgm_rec.salary_calc_mthd_rl, 20);
595: end if;
596: --
597: if (c_pgm%FOUND) THEN

Line 594: hr_utility.set_location('l_pgm_rec.salary_calc_mthd_rl ' || l_pgm_rec.salary_calc_mthd_rl, 20);

590: --
591: if g_debug then
592: hr_utility.set_location('l_pgm_rec.pgm_typ_cd ' || l_pgm_rec.pgm_typ_cd, 20);
593: hr_utility.set_location('l_pgm_rec.salary_calc_mthd_cd ' || l_pgm_rec.salary_calc_mthd_cd, 20);
594: hr_utility.set_location('l_pgm_rec.salary_calc_mthd_rl ' || l_pgm_rec.salary_calc_mthd_rl, 20);
595: end if;
596: --
597: if (c_pgm%FOUND) THEN
598: if (l_pgm_rec.pgm_typ_cd = 'GSP' and l_pgm_rec.salary_calc_mthd_cd = 'RULE'

Line 664: hr_utility.set_location(' p_asg_row.assignment_id ' || p_asg_row.assignment_id, 20);

660:
661: -- GSP issue raised by hallmark cards 30/3/05
662: -- contexts are passed using in parameters now instead of local variable
663: --
664: hr_utility.set_location(' p_asg_row.assignment_id ' || p_asg_row.assignment_id, 20);
665: hr_utility.set_location(' p_asg_row.organization_id ' || p_asg_row.organization_id, 20);
666: --
667: l_rate_outputs := benutils.formula
668: (p_formula_id => l_pgm_rec.salary_calc_mthd_rl,

Line 665: hr_utility.set_location(' p_asg_row.organization_id ' || p_asg_row.organization_id, 20);

661: -- GSP issue raised by hallmark cards 30/3/05
662: -- contexts are passed using in parameters now instead of local variable
663: --
664: hr_utility.set_location(' p_asg_row.assignment_id ' || p_asg_row.assignment_id, 20);
665: hr_utility.set_location(' p_asg_row.organization_id ' || p_asg_row.organization_id, 20);
666: --
667: l_rate_outputs := benutils.formula
668: (p_formula_id => l_pgm_rec.salary_calc_mthd_rl,
669: p_effective_date => p_effective_date,

Line 685: hr_utility.set_location(' val(i) from Formula ' || l_val(i), 20);

681: --
682: l_val(i) := l_rate_outputs(l_rate_outputs.first).value;
683: --
684: if g_debug then
685: hr_utility.set_location(' val(i) from Formula ' || l_val(i), 20);
686: end if;
687: --
688: -- set all other values to NULL
689: l_mn_elcn_val(i) := NULL;

Line 744: hr_utility.set_location(' l_acty_typ_cd ' || l_acty_typ_cd(i), 20);

740: end if;
741: close c_abr;
742: --
743: if g_debug then
744: hr_utility.set_location(' l_acty_typ_cd ' || l_acty_typ_cd(i), 20);
745: end if;
746: ELSE
747: -- In all other cases evaluate rates, the usual way
748: if g_debug then

Line 749: hr_utility.set_location(' calculate rate the usual way ' , 20);

745: end if;
746: ELSE
747: -- In all other cases evaluate rates, the usual way
748: if g_debug then
749: hr_utility.set_location(' calculate rate the usual way ' , 20);
750: end if;
751: --
752: -- Bug: 3234092 Changes end **********************************************
753: ben_determine_activity_base_rt.main(

Line 990: hr_utility.set_location('ben_rates_old ' || l_package, 10);

986: --
987: -- call procedure ben_rates_old to get old value
988: --
989: if g_debug then
990: hr_utility.set_location('ben_rates_old ' || l_package, 10);
991: end if;
992: ben_rates_old(
993: p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id,
994: p_enrt_bnft_id => p_enrt_bnft_id,

Line 1004: hr_utility.set_location('Dn ben_rates_old ' || l_package, 10);

1000: p_pl_id => p_pl_id,
1001: p_oipl_id => p_oipl_id,
1002: p_old_val => l_old_val);
1003: if g_debug then
1004: hr_utility.set_location('Dn ben_rates_old ' || l_package, 10);
1005: end if;
1006: --
1007: -- Bug 2234582 : Some times null second parameter is giving error.
1008: -- explicit second parameter is passed to hr_utility. set_location

Line 1008: -- explicit second parameter is passed to hr_utility. set_location

1004: hr_utility.set_location('Dn ben_rates_old ' || l_package, 10);
1005: end if;
1006: --
1007: -- Bug 2234582 : Some times null second parameter is giving error.
1008: -- explicit second parameter is passed to hr_utility. set_location
1009: --
1010: if g_debug then
1011: hr_utility.set_location('Old Rate ' || l_old_val, 11);
1012: end if;

Line 1011: hr_utility.set_location('Old Rate ' || l_old_val, 11);

1007: -- Bug 2234582 : Some times null second parameter is giving error.
1008: -- explicit second parameter is passed to hr_utility. set_location
1009: --
1010: if g_debug then
1011: hr_utility.set_location('Old Rate ' || l_old_val, 11);
1012: end if;
1013: --
1014: g_rec.person_id := p_person_id;
1015: g_rec.pgm_id := p_pgm_id;

Line 1040: hr_utility.set_location('mlt_cd ' || l_rt_mlt_cd(i), 10);

1036: -- 2897152 if the dt mlt cd is NSVU and vapro fail
1037: --- null value add to a pl/sql table so this can be
1038: --- delted in latter
1039: if g_debug then
1040: hr_utility.set_location('mlt_cd ' || l_rt_mlt_cd(i), 10);
1041: hr_utility.set_location('value ' || l_val(i), 10);
1042: end if ;
1043:
1044: if l_rt_mlt_cd(i)= 'NSVU' and l_val(i) is null then

Line 1041: hr_utility.set_location('value ' || l_val(i), 10);

1037: --- null value add to a pl/sql table so this can be
1038: --- delted in latter
1039: if g_debug then
1040: hr_utility.set_location('mlt_cd ' || l_rt_mlt_cd(i), 10);
1041: hr_utility.set_location('value ' || l_val(i), 10);
1042: end if ;
1043:
1044: if l_rt_mlt_cd(i)= 'NSVU' and l_val(i) is null then
1045: l_nsuv_lst(l_nsuv_num) := i ;

Line 1051: hr_utility.set_location('After write', 000);

1047: end if ;
1048:
1049: --
1050: if g_debug then
1051: hr_utility.set_location('After write', 000);
1052: end if;
1053:
1054: END LOOP;
1055:

Line 1102: hr_utility.set_location('l_nsuv_num ' || l_nsuv_num, 10);

1098: --
1099: end if;
1100: --
1101: if g_debug then
1102: hr_utility.set_location('l_nsuv_num ' || l_nsuv_num, 10);
1103: hr_utility.set_location('Done BDABRT_MN ' || l_package, 10);
1104: end if;
1105:
1106: --

Line 1103: hr_utility.set_location('Done BDABRT_MN ' || l_package, 10);

1099: end if;
1100: --
1101: if g_debug then
1102: hr_utility.set_location('l_nsuv_num ' || l_nsuv_num, 10);
1103: hr_utility.set_location('Done BDABRT_MN ' || l_package, 10);
1104: end if;
1105:
1106: --
1107: -- Since enrt_bnft_id and elig_per_elctbl_chc_id are

Line 1129: hr_utility.set_location('Insert ECR: ' || l_package, 5);

1125: END IF;
1126:
1127: --
1128: if g_debug then
1129: hr_utility.set_location('Insert ECR: ' || l_package, 5);
1130: end if;
1131:
1132: --
1133: -- GLOBALCWB : No need to populate the ben_enrt_rt table.

Line 1601: hr_utility.set_location('after Insert ' , 5);

1597: end if;
1598:
1599: --
1600: if g_debug then
1601: hr_utility.set_location('after Insert ' , 5);
1602: end if;
1603:
1604: -- 2897152 when the date mult code is NSVU and rate does not have any
1605: -- values then no rate will be created . so the

Line 1619: hr_utility.set_location(' COUNT ' || l_nsuv_lst.COUNT , 99 );

1615: --
1616: if l_nsuv_lst.COUNT > 0 then
1617:
1618: if g_debug then
1619: hr_utility.set_location(' COUNT ' || l_nsuv_lst.COUNT , 99 );
1620: hr_utility.set_location(' Deleting ' , 99 );
1621: end if;
1622: for i in l_nsuv_lst.FIRST .. l_nsuv_lst.LAST Loop
1623: l_nsuv_num := l_nsuv_lst(i) ;

Line 1620: hr_utility.set_location(' Deleting ' , 99 );

1616: if l_nsuv_lst.COUNT > 0 then
1617:
1618: if g_debug then
1619: hr_utility.set_location(' COUNT ' || l_nsuv_lst.COUNT , 99 );
1620: hr_utility.set_location(' Deleting ' , 99 );
1621: end if;
1622: for i in l_nsuv_lst.FIRST .. l_nsuv_lst.LAST Loop
1623: l_nsuv_num := l_nsuv_lst(i) ;
1624: if p_acty_base_rt_id_table.EXISTS(l_nsuv_num)

Line 1628: hr_utility.set_location(' enrt rt_id '||l_enrt_rt_id_tab(l_nsuv_num) , 99 );

1624: if p_acty_base_rt_id_table.EXISTS(l_nsuv_num)
1625: and l_rt_mlt_cd(l_nsuv_num) = 'NSVU'
1626: and l_val(l_nsuv_num) is null then
1627: if g_debug then
1628: hr_utility.set_location(' enrt rt_id '||l_enrt_rt_id_tab(l_nsuv_num) , 99 );
1629: end if ;
1630:
1631: Delete from Ben_enrt_rt
1632: where val is null

Line 1713: hr_utility.set_location('Leaving ' || l_package, 10);

1709: End loop ;
1710: end if;
1711: --
1712: if g_debug then
1713: hr_utility.set_location('Leaving ' || l_package, 10);
1714: end if;
1715: --
1716: END ben_rates;
1717: --

Line 2015: g_debug := hr_utility.debug_enabled;

2011: --
2012: l_asg_benass_row per_all_assignments_f%ROWTYPE;
2013: --
2014: BEGIN
2015: g_debug := hr_utility.debug_enabled;
2016: if g_debug then
2017: hr_utility.set_location('Entering ' || l_package, 10);
2018: end if;
2019: IF (p_effective_date IS NULL) THEN

Line 2017: hr_utility.set_location('Entering ' || l_package, 10);

2013: --
2014: BEGIN
2015: g_debug := hr_utility.debug_enabled;
2016: if g_debug then
2017: hr_utility.set_location('Entering ' || l_package, 10);
2018: end if;
2019: IF (p_effective_date IS NULL) THEN
2020: if g_debug then
2021: hr_utility.set_location('BEN_91552_BENRATES_INPT_EFFDT', 10);

Line 2021: hr_utility.set_location('BEN_91552_BENRATES_INPT_EFFDT', 10);

2017: hr_utility.set_location('Entering ' || l_package, 10);
2018: end if;
2019: IF (p_effective_date IS NULL) THEN
2020: if g_debug then
2021: hr_utility.set_location('BEN_91552_BENRATES_INPT_EFFDT', 10);
2022: end if;
2023: fnd_message.set_name('BEN', 'BEN_91552_BENRATES_INPT_EFFDT');
2024: fnd_message.set_token('PACKAGE', l_package);
2025: fnd_message.set_token('PERSON_ID', p_person_id);

Line 2074: -- hr_utility.set_location('EPE '||l_currepe_row.elig_per_elctbl_chc_id,45);

2070: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
2071: ,p_per_in_ler_id => p_per_in_ler_id
2072: ,p_inst_row => l_currepe_row
2073: );
2074: -- hr_utility.set_location('EPE '||l_currepe_row.elig_per_elctbl_chc_id,45);
2075: -- hr_utility.set_location(' comp_lvl_cd '||l_currepe_row.comp_lvl_cd ,45);
2076: --
2077: -- l_currepe_set(1) := l_currepe_row ;
2078: --

Line 2075: -- hr_utility.set_location(' comp_lvl_cd '||l_currepe_row.comp_lvl_cd ,45);

2071: ,p_per_in_ler_id => p_per_in_ler_id
2072: ,p_inst_row => l_currepe_row
2073: );
2074: -- hr_utility.set_location('EPE '||l_currepe_row.elig_per_elctbl_chc_id,45);
2075: -- hr_utility.set_location(' comp_lvl_cd '||l_currepe_row.comp_lvl_cd ,45);
2076: --
2077: -- l_currepe_set(1) := l_currepe_row ;
2078: --
2079: end if;

Line 2101: hr_utility.set_location('St EPE loop ' || l_package, 10);

2097: --
2098: for epe_elenum in l_currepe_set.first..l_currepe_set.last loop
2099: --
2100: if g_debug then
2101: hr_utility.set_location('St EPE loop ' || l_package, 10);
2102: end if;
2103: --
2104: l_currepe_row := l_currepe_set(epe_elenum);
2105: --

Line 2153: hr_utility.set_location('PILEPO cache ' || l_package, 10);

2149: --
2150: -- Get the cached elig per opt info
2151: --
2152: if g_debug then
2153: hr_utility.set_location('PILEPO cache ' || l_package, 10);
2154: end if;
2155: ben_pep_cache.get_pilepo_dets(
2156: p_person_id => p_person_id,
2157: p_business_group_id => l_currepe_row.business_group_id,

Line 2164: hr_utility.set_location('Dn PILEPO cache ' || l_package, 10);

2160: p_pl_id => l_currepe_row.pl_id,
2161: p_opt_id => l_currepe_row.opt_id,
2162: p_inst_row => l_epo_row);
2163: if g_debug then
2164: hr_utility.set_location('Dn PILEPO cache ' || l_package, 10);
2165: end if;
2166: --
2167: l_currepe_row.prtn_strt_dt := l_epo_row.prtn_strt_dt;
2168: l_currepe_row.prtn_ovridn_flag := l_epo_row.prtn_ovridn_flag;

Line 2191: hr_utility.set_location('plan,opt,rt'||l_currepe_row.pl_id||l_currepe_row.opt_id||l_currepe_row.rt_los_val, 111);

2187: l_currepe_row.rt_los_val,
2188: l_currepe_row.rt_hrs_wkd_val,
2189: l_currepe_row.rt_cmbn_age_n_los_val;
2190: if g_debug then
2191: hr_utility.set_location('plan,opt,rt'||l_currepe_row.pl_id||l_currepe_row.opt_id||l_currepe_row.rt_los_val, 111);
2192: end if;
2193:
2194: CLOSE c_current_plnipepoelig;
2195: --

Line 2205: hr_utility.set_location('PILPEP cache ' || l_package, 10);

2201: --
2202: -- Get the cached elig per info
2203: --
2204: if g_debug then
2205: hr_utility.set_location('PILPEP cache ' || l_package, 10);
2206: end if;
2207: ben_pep_cache.get_pilpep_dets(
2208: p_person_id => p_person_id,
2209: p_business_group_id => l_currepe_row.business_group_id,

Line 2215: hr_utility.set_location('Dn PILPEP cache ' || l_package, 10);

2211: p_pgm_id => l_currepe_row.pgm_id,
2212: p_pl_id => l_currepe_row.pl_id,
2213: p_inst_row => l_pep_row);
2214: if g_debug then
2215: hr_utility.set_location('Dn PILPEP cache ' || l_package, 10);
2216: end if;
2217: --
2218: l_currepe_row.prtn_strt_dt := l_pep_row.prtn_strt_dt;
2219: l_currepe_row.prtn_ovridn_flag := l_pep_row.prtn_ovridn_flag;

Line 2266: hr_utility.set_location ('fonm cvg '||ben_manage_life_events.g_fonm_cvg_strt_dt ,10);

2262: ben_manage_life_events.g_fonm_cvg_strt_dt <> l_currepe_row.fonm_cvg_strt_dt then
2263: ben_manage_life_events.g_fonm_cvg_strt_dt := l_currepe_row.fonm_cvg_strt_dt ;
2264: end if ;
2265:
2266: hr_utility.set_location ('fonm cvg '||ben_manage_life_events.g_fonm_cvg_strt_dt ,10);
2267: else
2268: ben_manage_life_events.fonm := 'N';
2269: ben_manage_life_events.g_fonm_rt_strt_dt := null;
2270: ben_manage_life_events.g_fonm_cvg_strt_dt := null;

Line 2273: hr_utility.set_location ('fonm ?'||ben_manage_life_events.fonm,10);

2269: ben_manage_life_events.g_fonm_rt_strt_dt := null;
2270: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
2271: end if;
2272:
2273: hr_utility.set_location ('fonm ?'||ben_manage_life_events.fonm,10);
2274:
2275: if ben_manage_life_events.fonm = 'Y' then
2276: hr_utility.set_location ('BDD_RACD '||l_package,10);
2277: hr_utility.set_location ('inside .. '||l_package,10);

Line 2276: hr_utility.set_location ('BDD_RACD '||l_package,10);

2272:
2273: hr_utility.set_location ('fonm ?'||ben_manage_life_events.fonm,10);
2274:
2275: if ben_manage_life_events.fonm = 'Y' then
2276: hr_utility.set_location ('BDD_RACD '||l_package,10);
2277: hr_utility.set_location ('inside .. '||l_package,10);
2278: ben_determine_date.rate_and_coverage_dates
2279: (p_cache_mode => TRUE
2280: ,p_par_ptip_id => l_currepe_row.ptip_id

Line 2277: hr_utility.set_location ('inside .. '||l_package,10);

2273: hr_utility.set_location ('fonm ?'||ben_manage_life_events.fonm,10);
2274:
2275: if ben_manage_life_events.fonm = 'Y' then
2276: hr_utility.set_location ('BDD_RACD '||l_package,10);
2277: hr_utility.set_location ('inside .. '||l_package,10);
2278: ben_determine_date.rate_and_coverage_dates
2279: (p_cache_mode => TRUE
2280: ,p_par_ptip_id => l_currepe_row.ptip_id
2281: ,p_par_plip_id => l_currepe_row.plip_id

Line 2311: hr_utility.set_location ('Dn BDD_RACD '||l_package,10);

2307: ,p_rt_end_dt => l_dummy_date
2308: ,p_rt_end_dt_cd => l_dummy_char
2309: ,p_rt_end_dt_rl => l_dummy_num
2310: );
2311: hr_utility.set_location ('Dn BDD_RACD '||l_package,10);
2312: --
2313: -- If previous rate start date and current date is different then
2314: -- clear the caches.
2315: --

Line 2451: hr_utility.set_location('BEN_91553_BENRATES_UNKN_COMP ', 10);

2447: c1.asn_on_enrt_flag;
2448: END LOOP;
2449: ELSE
2450: if g_debug then
2451: hr_utility.set_location('BEN_91553_BENRATES_UNKN_COMP ', 10);
2452: end if;
2453: fnd_message.set_name('BEN', 'BEN_91553_BENRATES_UNKN_COMP');
2454: fnd_message.set_token('PACKAGE', l_package);
2455: fnd_message.set_token('PERSON_ID', TO_CHAR(l_currepe_row.person_id));

Line 2473: hr_utility.set_location('Call ben_rates ' || l_package, 10);

2469: TO_CHAR(l_currepe_row.cmbn_ptip_opt_id));
2470: fnd_message.raise_error;
2471: END IF;
2472: if g_debug then
2473: hr_utility.set_location('Call ben_rates ' || l_package, 10);
2474: end if;
2475: -- call ben_rates providing at least 1 row exists
2476: IF l_acty_base_rt_id_table.COUNT > 0
2477: OR l_asn_on_enrt_flag_table.COUNT > 0 THEN

Line 2546: hr_utility.set_location( ' l_currepe_row.elig_per_elctbl_chc_id'||l_currepe_row.elig_per_elctbl_chc_id , 15);

2542: --
2543: ELSE -- This is for suspended pen or pending workflow epe records
2544: --
2545: if g_debug then
2546: hr_utility.set_location( ' l_currepe_row.elig_per_elctbl_chc_id'||l_currepe_row.elig_per_elctbl_chc_id , 15);
2547: hr_utility.set_location( 'Suspended pen or in_pndg_wkflow_flag is Y ' ,15);
2548: hr_utility.set_location('Leaving ' || l_package, 10);
2549: end if;
2550: --

Line 2547: hr_utility.set_location( 'Suspended pen or in_pndg_wkflow_flag is Y ' ,15);

2543: ELSE -- This is for suspended pen or pending workflow epe records
2544: --
2545: if g_debug then
2546: hr_utility.set_location( ' l_currepe_row.elig_per_elctbl_chc_id'||l_currepe_row.elig_per_elctbl_chc_id , 15);
2547: hr_utility.set_location( 'Suspended pen or in_pndg_wkflow_flag is Y ' ,15);
2548: hr_utility.set_location('Leaving ' || l_package, 10);
2549: end if;
2550: --
2551: null ;

Line 2548: hr_utility.set_location('Leaving ' || l_package, 10);

2544: --
2545: if g_debug then
2546: hr_utility.set_location( ' l_currepe_row.elig_per_elctbl_chc_id'||l_currepe_row.elig_per_elctbl_chc_id , 15);
2547: hr_utility.set_location( 'Suspended pen or in_pndg_wkflow_flag is Y ' ,15);
2548: hr_utility.set_location('Leaving ' || l_package, 10);
2549: end if;
2550: --
2551: null ;
2552: --

Line 2557: hr_utility.set_location('Leaving ' || l_package, 10);

2553: END IF;
2554: --
2555: END LOOP;
2556: if g_debug then
2557: hr_utility.set_location('Leaving ' || l_package, 10);
2558: end if;
2559: --
2560: end if;
2561: --