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 201: g_debug boolean := hr_utility.debug_enabled;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2031: g_debug := hr_utility.debug_enabled;

2027:
2028: l_get_rate c_get_rate%rowtype;
2029: -------Bug 8394662
2030: BEGIN
2031: g_debug := hr_utility.debug_enabled;
2032: if g_debug then
2033: hr_utility.set_location('Entering ' || l_package, 10);
2034: end if;
2035: IF (p_effective_date IS NULL) THEN

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

2029: -------Bug 8394662
2030: BEGIN
2031: g_debug := hr_utility.debug_enabled;
2032: if g_debug then
2033: hr_utility.set_location('Entering ' || l_package, 10);
2034: end if;
2035: IF (p_effective_date IS NULL) THEN
2036: if g_debug then
2037: hr_utility.set_location('BEN_91552_BENRATES_INPT_EFFDT', 10);

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

2033: hr_utility.set_location('Entering ' || l_package, 10);
2034: end if;
2035: IF (p_effective_date IS NULL) THEN
2036: if g_debug then
2037: hr_utility.set_location('BEN_91552_BENRATES_INPT_EFFDT', 10);
2038: end if;
2039: fnd_message.set_name('BEN', 'BEN_91552_BENRATES_INPT_EFFDT');
2040: fnd_message.set_token('PACKAGE', l_package);
2041: fnd_message.set_token('PERSON_ID', p_person_id);

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

2086: (p_elig_per_elctbl_chc_id => p_elig_per_elctbl_chc_id
2087: ,p_per_in_ler_id => p_per_in_ler_id
2088: ,p_inst_row => l_currepe_row
2089: );
2090: -- hr_utility.set_location('EPE '||l_currepe_row.elig_per_elctbl_chc_id,45);
2091: -- hr_utility.set_location(' comp_lvl_cd '||l_currepe_row.comp_lvl_cd ,45);
2092: --
2093: -- l_currepe_set(1) := l_currepe_row ;
2094: --

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

2087: ,p_per_in_ler_id => p_per_in_ler_id
2088: ,p_inst_row => l_currepe_row
2089: );
2090: -- hr_utility.set_location('EPE '||l_currepe_row.elig_per_elctbl_chc_id,45);
2091: -- hr_utility.set_location(' comp_lvl_cd '||l_currepe_row.comp_lvl_cd ,45);
2092: --
2093: -- l_currepe_set(1) := l_currepe_row ;
2094: --
2095: end if;

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

2113: --
2114: for epe_elenum in l_currepe_set.first..l_currepe_set.last loop
2115: --
2116: if g_debug then
2117: hr_utility.set_location('St EPE loop ' || l_package, 10);
2118: end if;
2119: --
2120: l_currepe_row := l_currepe_set(epe_elenum);
2121: --

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

2165: --
2166: -- Get the cached elig per opt info
2167: --
2168: if g_debug then
2169: hr_utility.set_location('PILEPO cache ' || l_package, 10);
2170: end if;
2171: ben_pep_cache.get_pilepo_dets(
2172: p_person_id => p_person_id,
2173: p_business_group_id => l_currepe_row.business_group_id,

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

2176: p_pl_id => l_currepe_row.pl_id,
2177: p_opt_id => l_currepe_row.opt_id,
2178: p_inst_row => l_epo_row);
2179: if g_debug then
2180: hr_utility.set_location('Dn PILEPO cache ' || l_package, 10);
2181: end if;
2182: --
2183: l_currepe_row.prtn_strt_dt := l_epo_row.prtn_strt_dt;
2184: l_currepe_row.prtn_ovridn_flag := l_epo_row.prtn_ovridn_flag;

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

2203: l_currepe_row.rt_los_val,
2204: l_currepe_row.rt_hrs_wkd_val,
2205: l_currepe_row.rt_cmbn_age_n_los_val;
2206: if g_debug then
2207: hr_utility.set_location('plan,opt,rt'||l_currepe_row.pl_id||l_currepe_row.opt_id||l_currepe_row.rt_los_val, 111);
2208: end if;
2209:
2210: CLOSE c_current_plnipepoelig;
2211: --

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

2217: --
2218: -- Get the cached elig per info
2219: --
2220: if g_debug then
2221: hr_utility.set_location('PILPEP cache ' || l_package, 10);
2222: end if;
2223: ben_pep_cache.get_pilpep_dets(
2224: p_person_id => p_person_id,
2225: p_business_group_id => l_currepe_row.business_group_id,

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

2227: p_pgm_id => l_currepe_row.pgm_id,
2228: p_pl_id => l_currepe_row.pl_id,
2229: p_inst_row => l_pep_row);
2230: if g_debug then
2231: hr_utility.set_location('Dn PILPEP cache ' || l_package, 10);
2232: end if;
2233: --
2234: l_currepe_row.prtn_strt_dt := l_pep_row.prtn_strt_dt;
2235: l_currepe_row.prtn_ovridn_flag := l_pep_row.prtn_ovridn_flag;

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

2278: ben_manage_life_events.g_fonm_cvg_strt_dt <> l_currepe_row.fonm_cvg_strt_dt then
2279: ben_manage_life_events.g_fonm_cvg_strt_dt := l_currepe_row.fonm_cvg_strt_dt ;
2280: end if ;
2281:
2282: hr_utility.set_location ('fonm cvg '||ben_manage_life_events.g_fonm_cvg_strt_dt ,10);
2283: else
2284: ben_manage_life_events.fonm := 'N';
2285: ben_manage_life_events.g_fonm_rt_strt_dt := null;
2286: ben_manage_life_events.g_fonm_cvg_strt_dt := null;

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

2285: ben_manage_life_events.g_fonm_rt_strt_dt := null;
2286: ben_manage_life_events.g_fonm_cvg_strt_dt := null;
2287: end if;
2288:
2289: hr_utility.set_location ('fonm ?'||ben_manage_life_events.fonm,10);
2290:
2291: if ben_manage_life_events.fonm = 'Y' then
2292: hr_utility.set_location ('BDD_RACD '||l_package,10);
2293: hr_utility.set_location ('inside .. '||l_package,10);

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

2288:
2289: hr_utility.set_location ('fonm ?'||ben_manage_life_events.fonm,10);
2290:
2291: if ben_manage_life_events.fonm = 'Y' then
2292: hr_utility.set_location ('BDD_RACD '||l_package,10);
2293: hr_utility.set_location ('inside .. '||l_package,10);
2294: ---Get the Corresponding Rate ID,Bug 8394662
2295: open c_get_rate(l_currepe_row.pgm_id,l_currepe_row.pl_id,l_currepe_row.opt_id,l_currepe_row.business_group_id);
2296: fetch c_get_rate into l_get_rate;

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

2289: hr_utility.set_location ('fonm ?'||ben_manage_life_events.fonm,10);
2290:
2291: if ben_manage_life_events.fonm = 'Y' then
2292: hr_utility.set_location ('BDD_RACD '||l_package,10);
2293: hr_utility.set_location ('inside .. '||l_package,10);
2294: ---Get the Corresponding Rate ID,Bug 8394662
2295: open c_get_rate(l_currepe_row.pgm_id,l_currepe_row.pl_id,l_currepe_row.opt_id,l_currepe_row.business_group_id);
2296: fetch c_get_rate into l_get_rate;
2297: close c_get_rate;

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

2327: ,p_rt_end_dt => l_dummy_date
2328: ,p_rt_end_dt_cd => l_dummy_char
2329: ,p_rt_end_dt_rl => l_dummy_num
2330: );
2331: hr_utility.set_location ('Dn BDD_RACD '||l_package,10);
2332: --
2333: -- If previous rate start date and current date is different then
2334: -- clear the caches.
2335: --

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

2467: c1.asn_on_enrt_flag;
2468: END LOOP;
2469: ELSE
2470: if g_debug then
2471: hr_utility.set_location('BEN_91553_BENRATES_UNKN_COMP ', 10);
2472: end if;
2473: fnd_message.set_name('BEN', 'BEN_91553_BENRATES_UNKN_COMP');
2474: fnd_message.set_token('PACKAGE', l_package);
2475: fnd_message.set_token('PERSON_ID', TO_CHAR(l_currepe_row.person_id));

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

2489: TO_CHAR(l_currepe_row.cmbn_ptip_opt_id));
2490: fnd_message.raise_error;
2491: END IF;
2492: if g_debug then
2493: hr_utility.set_location('Call ben_rates ' || l_package, 10);
2494: end if;
2495: -- call ben_rates providing at least 1 row exists
2496: IF l_acty_base_rt_id_table.COUNT > 0
2497: OR l_asn_on_enrt_flag_table.COUNT > 0 THEN

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

2562: --
2563: ELSE -- This is for suspended pen or pending workflow epe records
2564: --
2565: if g_debug then
2566: hr_utility.set_location( ' l_currepe_row.elig_per_elctbl_chc_id'||l_currepe_row.elig_per_elctbl_chc_id , 15);
2567: hr_utility.set_location( 'Suspended pen or in_pndg_wkflow_flag is Y ' ,15);
2568: hr_utility.set_location('Leaving ' || l_package, 10);
2569: end if;
2570: --

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

2563: ELSE -- This is for suspended pen or pending workflow epe records
2564: --
2565: if g_debug then
2566: hr_utility.set_location( ' l_currepe_row.elig_per_elctbl_chc_id'||l_currepe_row.elig_per_elctbl_chc_id , 15);
2567: hr_utility.set_location( 'Suspended pen or in_pndg_wkflow_flag is Y ' ,15);
2568: hr_utility.set_location('Leaving ' || l_package, 10);
2569: end if;
2570: --
2571: null ;

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

2564: --
2565: if g_debug then
2566: hr_utility.set_location( ' l_currepe_row.elig_per_elctbl_chc_id'||l_currepe_row.elig_per_elctbl_chc_id , 15);
2567: hr_utility.set_location( 'Suspended pen or in_pndg_wkflow_flag is Y ' ,15);
2568: hr_utility.set_location('Leaving ' || l_package, 10);
2569: end if;
2570: --
2571: null ;
2572: --

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

2573: END IF;
2574: --
2575: END LOOP;
2576: if g_debug then
2577: hr_utility.set_location('Leaving ' || l_package, 10);
2578: end if;
2579: --
2580: end if;
2581: --