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

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

10: --
11: l_package VARCHAR2(80) := g_package || '.init_comp_object_list_globals';
12: --
13: BEGIN
14: hr_utility.set_location('Entering ' || l_package, 10);
15: --
16: g_prev_lf_evt_ocrd_dt := NULL;
17: g_prev_per_org_id := NULL;
18: --

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

15: --
16: g_prev_lf_evt_ocrd_dt := NULL;
17: g_prev_per_org_id := NULL;
18: --
19: hr_utility.set_location('Leaving ' || l_package, 10);
20: END init_comp_object_list_globals;
21: --
22: FUNCTION set_flag_bit_val(
23: p_business_group_id IN NUMBER

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

154: and otp.business_group_id = :business_group_id' ;
155: --
156: BEGIN
157: --
158: hr_utility.set_location('Entering ' || l_package, 10);
159: --
160: IF p_drvbl_fctr_prtn_elig_flag = 'Y' THEN
161: --
162: ben_elp_cache.cobcep_getdets(p_business_group_id=> p_business_group_id

Line 269: hr_utility.set_location('Attempting to set drvbl_fctr_apls_rts_flag ' ||

265: END IF;
266: --
267: END IF;
268: --
269: hr_utility.set_location('Attempting to set drvbl_fctr_apls_rts_flag ' ||
270: l_package
271: ,10);
272: --
273: -- OIPLIP are special cases so we have to check if there are rates attached

Line 513: hr_utility.set_location('l_flag_bit_val '|| l_flag_bit_val, 10);

509: --
510: END IF;
511: --
512: END IF;
513: hr_utility.set_location('l_flag_bit_val '|| l_flag_bit_val, 10);
514: --
515: -- If there is a derived factor attached to a comp object and the
516: -- derivable factor parameter is 'NONE', set the derivable factor
517: -- parameter to 'ASC' so the derived factor is evaluated.

Line 521: hr_utility.set_location('g_derivable_factors '|| ben_manage_life_events.g_derivable_factors, 10);

517: -- parameter to 'ASC' so the derived factor is evaluated.
518: -- Bug 2894200.
519: --
520: if (l_flag_bit_val <> 0) AND (ben_manage_life_events.g_derivable_factors = 'NONE') then
521: hr_utility.set_location('g_derivable_factors '|| ben_manage_life_events.g_derivable_factors, 10);
522: ben_manage_life_events.g_derivable_factors := 'ASC';
523: fnd_message.set_name('BEN','BEN_93605_RESET_DRVD_FCTR_PARM');
524: benutils.write(p_text => fnd_message.get);
525: end if;

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

525: end if;
526: --
527: RETURN l_flag_bit_val;
528: --
529: hr_utility.set_location('Leaving ' || l_package, 10);
530: --
531: END set_flag_bit_val;
532: --
533: PROCEDURE load_cache(

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

551: l_count NUMBER;
552: --
553: BEGIN
554: --
555: hr_utility.set_location('Entering ' || l_package, 10);
556: --
557: -- Load cache with comp object details
558: --
559: IF NOT ben_manage_life_events.g_cache_proc_object.EXISTS(1) THEN

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

596: p_flag_bit_val;
597: ben_manage_life_events.g_cache_proc_object(l_count).oiplip_flag_bit_val :=
598: p_oiplip_flag_bit_val;
599: --
600: hr_utility.set_location('Leaving ' || l_package, 10);
601: --
602: END load_cache;
603: --
604: PROCEDURE cache_working_data(

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

622: AND hr.lookup_code IN ('PLIP', 'PGM', 'PLTYP', 'PTIP', 'PL', 'OIPL');
623: --
624: BEGIN
625: --
626: hr_utility.set_location('Entering ' || l_package, 10);
627: --
628: -- Set up cache details for all comp object types
629: --
630: OPEN c_comp_object_meanings;

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

667: CLOSE c_comp_object_meanings;
668: --
669: ben_manage_life_events.g_cached_objects := TRUE;
670: --
671: hr_utility.set_location('Leaving ' || l_package, 10);
672: --
673: END cache_working_data;
674: --
675: PROCEDURE write_multi_session_cache(

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

1744:
1745: --
1746: BEGIN
1747: --
1748: hr_utility.set_location('Entering ' || l_package, 10);
1749: hr_utility.set_location('date ' || p_effective_date, 10);
1750: --
1751: -- PB : Helathnet change :
1752: -- Get the person organization id, if it changes then

Line 1749: hr_utility.set_location('date ' || p_effective_date, 10);

1745: --
1746: BEGIN
1747: --
1748: hr_utility.set_location('Entering ' || l_package, 10);
1749: hr_utility.set_location('date ' || p_effective_date, 10);
1750: --
1751: -- PB : Helathnet change :
1752: -- Get the person organization id, if it changes then
1753: -- comp object list needs to be rebuilt.

Line 1764: hr_utility.set_location('l_ass.assignment_id ' || l_ass_rec.assignment_id, 111);

1760: --
1761: ben_person_object.get_object(p_person_id => p_person_id,
1762: p_rec => l_ass_rec);
1763: --
1764: hr_utility.set_location('l_ass.assignment_id ' || l_ass_rec.assignment_id, 111);
1765: l_per_org_id := l_ass_rec.organization_id;
1766: --
1767: -- Check if the organization id for the comp object
1768: -- cache has changed since the previous call to build

Line 1790: hr_utility.set_location('g_prev_per_org_id ' || l_ass_rec.assignment_id, 111);

1786: --
1787: END IF;
1788: --
1789: END IF;
1790: hr_utility.set_location('g_prev_per_org_id ' || l_ass_rec.assignment_id, 111);
1791: --
1792: -- Check if the effective date for the comp object
1793: -- cache has changed since the previous call to build
1794: -- comp object. If there is no change then we do not need

Line 1840: hr_utility.set_location('Clear caches ' || l_package, 10);

1836: if l_date_changed or
1837: p_lmt_prpnip_by_org_flag = 'N'
1838: then
1839: --
1840: hr_utility.set_location('Clear caches ' || l_package, 10);
1841: --
1842: ben_comp_object_list1.refresh_eff_date_caches;
1843: --
1844: hr_utility.set_location('Done Clear caches ' || l_package, 10);

Line 1844: hr_utility.set_location('Done Clear caches ' || l_package, 10);

1840: hr_utility.set_location('Clear caches ' || l_package, 10);
1841: --
1842: ben_comp_object_list1.refresh_eff_date_caches;
1843: --
1844: hr_utility.set_location('Done Clear caches ' || l_package, 10);
1845: --
1846: end if;
1847: --
1848: -- Check if the comp object list exists in the multi session cache

Line 2015: hr_utility.set_location('fetched multi cache ' , 111);

2011: OPEN c_multisesscache(c_effective_date=> p_effective_date
2012: ,c_business_group_id => p_business_group_id);
2013: FETCH c_multisesscache INTO l_comp_obj_cache_id, l_timestamp;
2014: --
2015: hr_utility.set_location('fetched multi cache ' , 111);
2016: IF c_multisesscache%FOUND THEN
2017: -- cache exists
2018: -- check if cache has only unrestricted programs
2019: --

Line 2020: hr_utility.set_location('found multi cache ' , 111);

2016: IF c_multisesscache%FOUND THEN
2017: -- cache exists
2018: -- check if cache has only unrestricted programs
2019: --
2020: hr_utility.set_location('found multi cache ' , 111);
2021: open c_unres_cache_only ;
2022: fetch c_unres_cache_only into l_unres_cache_only ;
2023: if c_unres_cache_only%FOUND then
2024: --

Line 2031: hr_utility.set_location(' reset rebuild list pgms ' , 111);

2027: null ;
2028: else
2029: -- only unrst pgms exist
2030: -- reset l_rebuild_list to TRUE
2031: hr_utility.set_location(' reset rebuild list pgms ' , 111);
2032: l_rebuild_list := TRUE;
2033: end if;
2034: --
2035: else

Line 2049: hr_utility.set_location(' reset rebuild list plans ' , 112);

2045: null ;
2046: else
2047: -- only unrst plns exist
2048: -- reset l_rebuild_list to TRUE
2049: hr_utility.set_location(' reset rebuild list plans ' , 112);
2050: l_rebuild_list := TRUE;
2051: end if;
2052: --
2053: end if ;

Line 2072: hr_utility.set_location('rebuild cache ' || l_package, 111);

2068: --
2069: -- End # bug 3330283
2070: */
2071: --
2072: hr_utility.set_location('rebuild cache ' || l_package, 111);
2073: IF l_rebuild_list
2074: OR l_bypass_cache THEN
2075: --
2076: -- Flush all existing multi session cache information

Line 2093: hr_utility.set_location(l_package || ' Opening c_pgm loop ', 11);

2089: end if;
2090: --
2091: IF p_no_programs = 'N' and p_mode not in ('I','D') THEN -- irec -- ICM
2092: --
2093: hr_utility.set_location(l_package || ' Opening c_pgm loop ', 11);
2094: OPEN c_pgm;
2095: hr_utility.set_location(l_package || ' Opened c_pgm loop ', 11);
2096: --
2097: LOOP

Line 2095: hr_utility.set_location(l_package || ' Opened c_pgm loop ', 11);

2091: IF p_no_programs = 'N' and p_mode not in ('I','D') THEN -- irec -- ICM
2092: --
2093: hr_utility.set_location(l_package || ' Opening c_pgm loop ', 11);
2094: OPEN c_pgm;
2095: hr_utility.set_location(l_package || ' Opened c_pgm loop ', 11);
2096: --
2097: LOOP
2098: --
2099: hr_utility.set_location(l_package || ' Start c_pgm loop ', 12);

Line 2099: hr_utility.set_location(l_package || ' Start c_pgm loop ', 12);

2095: hr_utility.set_location(l_package || ' Opened c_pgm loop ', 11);
2096: --
2097: LOOP
2098: --
2099: hr_utility.set_location(l_package || ' Start c_pgm loop ', 12);
2100: FETCH c_pgm INTO l_pgm;
2101: hr_utility.set_location(l_package || ' Fetch c_pgm loop ', 14);
2102: EXIT WHEN c_pgm%NOTFOUND;
2103: --

Line 2101: hr_utility.set_location(l_package || ' Fetch c_pgm loop ', 14);

2097: LOOP
2098: --
2099: hr_utility.set_location(l_package || ' Start c_pgm loop ', 12);
2100: FETCH c_pgm INTO l_pgm;
2101: hr_utility.set_location(l_package || ' Fetch c_pgm loop ', 14);
2102: EXIT WHEN c_pgm%NOTFOUND;
2103: --
2104: l_pgm_id := l_pgm.pgm_id;
2105: --

Line 2106: hr_utility.set_location(l_package || ' c_pgm LC ', 16);

2102: EXIT WHEN c_pgm%NOTFOUND;
2103: --
2104: l_pgm_id := l_pgm.pgm_id;
2105: --
2106: hr_utility.set_location(l_package || ' c_pgm LC ', 16);
2107: --
2108: -- Only set the flag bit if we have rates or profiles attached
2109: --
2110: IF l_pgm.drvbl_fctr_prtn_elig_flag = 'Y'

Line 2137: hr_utility.set_location(l_package || ' Start c_pln loop ', 20);

2133: ,p_flag_bit_val => l_flag_bit_val
2134: ,p_oiplip_flag_bit_val => 0
2135: ,p_trk_inelig_per_flag => l_pgm.trk_inelig_per_flag);
2136: --
2137: hr_utility.set_location(l_package || ' Start c_pln loop ', 20);
2138: ben_pln_cache.bgpcpp_getdets(p_business_group_id=> p_business_group_id
2139: ,p_effective_date => p_effective_date
2140: ,p_mode => p_mode
2141: ,p_pgm_id => l_pgm_id

Line 2153: hr_utility.set_location(l_package || ' Fetch c_pln loop ', 22);

2149: -- ,p_popl_enrt_typ_cycl_id => p_popl_enrt_typ_cycl_id
2150: --
2151: ,p_inst_set => l_plninst_set
2152: );
2153: hr_utility.set_location(l_package || ' Fetch c_pln loop ', 22);
2154: --
2155: IF l_plninst_set.COUNT > 0 THEN
2156: --
2157: FOR plnelenum IN l_plninst_set.FIRST .. l_plninst_set.LAST LOOP

Line 2163: hr_utility.set_location(l_package || ' Dn PLN OSR ', 16);

2159: l_pln := l_plninst_set(plnelenum);
2160: l_pl_id := l_plninst_set(plnelenum).pl_id;
2161: l_ptp_opt_typ_cd := l_plninst_set(plnelenum).ptp_opt_typ_cd;
2162: --
2163: hr_utility.set_location(l_package || ' Dn PLN OSR ', 16);
2164: --
2165: -- In collective agreement mode only process CAGR opt types
2166: --
2167: if l_ptp_opt_typ_cd <> 'CAGR'

Line 2180: hr_utility.set_location(l_package || ' open c_ptip ', 16);

2176: -- plan in program we are dealing with
2177: -- There will ALWAYS be a PLIP_ID but we cannot guarantee
2178: -- a PTIP id.
2179: --
2180: hr_utility.set_location(l_package || ' open c_ptip ', 16);
2181: OPEN c_ptip;
2182: --
2183: FETCH c_ptip INTO l_ptip;
2184: --

Line 2217: hr_utility.set_location(l_package || ' open c_plip ', 16);

2213: ,p_flag_bit_val => l_flag_bit_val
2214: ,p_oiplip_flag_bit_val => 0
2215: ,p_trk_inelig_per_flag => l_ptip.trk_inelig_per_flag);
2216: --
2217: hr_utility.set_location(l_package || ' open c_plip ', 16);
2218: OPEN c_plip;
2219: --
2220: FETCH c_plip INTO l_plip;
2221: --

Line 2306: hr_utility.set_location(l_package || ' c_oipl load_cache '

2302: --
2303: l_cop := l_copinst_set(copelenum);
2304: l_oipl_id := l_copinst_set(copelenum).oipl_id;
2305: --
2306: hr_utility.set_location(l_package || ' c_oipl load_cache '
2307: ,15);
2308: --
2309: -- Only set the flag bit if we have rates or profiles attached
2310: --

Line 2373: hr_utility.set_location(l_package || ' End c_oipl loop ', 20);

2369: ,p_flag_bit_val => l_flag_bit_val
2370: ,p_oiplip_flag_bit_val => l_oiplip_flag_bit_val
2371: ,p_trk_inelig_per_flag => l_cop.trk_inelig_per_flag);
2372: --
2373: hr_utility.set_location(l_package || ' End c_oipl loop ', 20);
2374: END LOOP;
2375: --
2376: END IF;
2377: --

Line 2380: hr_utility.set_location(l_package || ' End c_pln loop ', 20);

2376: END IF;
2377: --
2378: END IF;
2379: --
2380: hr_utility.set_location(l_package || ' End c_pln loop ', 20);
2381: END LOOP;
2382: --
2383: END IF;
2384: --

Line 2385: hr_utility.set_location(l_package || ' End c_pgm loop ', 15);

2381: END LOOP;
2382: --
2383: END IF;
2384: --
2385: hr_utility.set_location(l_package || ' End c_pgm loop ', 15);
2386: END LOOP;
2387: --
2388: CLOSE c_pgm;
2389: --

Line 2391: hr_utility.set_location(l_package || ' Done c_pgm ', 20);

2387: --
2388: CLOSE c_pgm;
2389: --
2390: END IF;
2391: hr_utility.set_location(l_package || ' Done c_pgm ', 20);
2392: --
2393: -- get the stragglers, the plans that aren't in a program
2394: -- added p_no_programs = N so that if only programs, plnip are not included
2395: IF (p_mode <> 'G') and

Line 2405: hr_utility.set_location(l_package || ' Start c_pln_nip ', 30);

2401: OPEN c_pln_nip;
2402: --
2403: LOOP
2404: --
2405: hr_utility.set_location(l_package || ' Start c_pln_nip ', 30);
2406: FETCH c_pln_nip INTO l_pln;
2407: hr_utility.set_location(l_package || ' Fetch c_pln_nip = '||
2408: l_pln.pl_id, 32);
2409: EXIT WHEN c_pln_nip%NOTFOUND;

Line 2407: hr_utility.set_location(l_package || ' Fetch c_pln_nip = '||

2403: LOOP
2404: --
2405: hr_utility.set_location(l_package || ' Start c_pln_nip ', 30);
2406: FETCH c_pln_nip INTO l_pln;
2407: hr_utility.set_location(l_package || ' Fetch c_pln_nip = '||
2408: l_pln.pl_id, 32);
2409: EXIT WHEN c_pln_nip%NOTFOUND;
2410: l_pl_id := l_pln.pl_id;
2411: l_ptp_opt_typ_cd := l_pln.ptp_opt_typ_cd;

Line 2413: hr_utility.set_location(l_package || ' PLNNIP LC ', 16);

2409: EXIT WHEN c_pln_nip%NOTFOUND;
2410: l_pl_id := l_pln.pl_id;
2411: l_ptp_opt_typ_cd := l_pln.ptp_opt_typ_cd;
2412: --
2413: hr_utility.set_location(l_package || ' PLNNIP LC ', 16);
2414: --
2415: -- In collective agreement mode only process CAGR opt types
2416: --
2417: if l_ptp_opt_typ_cd <> 'CAGR'

Line 2455: hr_utility.set_location(l_package || ' fetch c_oipl 1', 20);

2451: ,p_flag_bit_val => l_flag_bit_val
2452: ,p_oiplip_flag_bit_val => 0
2453: ,p_trk_inelig_per_flag => l_pln.trk_inelig_per_flag);
2454: --
2455: hr_utility.set_location(l_package || ' fetch c_oipl 1', 20);
2456: ben_cop_cache.bgpcop_getdets(p_effective_date=> p_effective_date
2457: ,p_business_group_id => p_business_group_id
2458: ,p_pl_id => l_pl_id
2459: ,p_opt_id => p_opt_id

Line 2465: hr_utility.set_location(l_package || ' Dn fetch c_oipl 1', 20);

2461: ,p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2462: ,p_mode => p_mode
2463: --
2464: ,p_inst_set => l_copinst_set);
2465: hr_utility.set_location(l_package || ' Dn fetch c_oipl 1', 20);
2466: hr_utility.set_location(' Number of oipls' || l_copinst_set.COUNT
2467: ,20);
2468: --
2469: IF l_copinst_set.COUNT > 0 THEN

Line 2466: hr_utility.set_location(' Number of oipls' || l_copinst_set.COUNT

2462: ,p_mode => p_mode
2463: --
2464: ,p_inst_set => l_copinst_set);
2465: hr_utility.set_location(l_package || ' Dn fetch c_oipl 1', 20);
2466: hr_utility.set_location(' Number of oipls' || l_copinst_set.COUNT
2467: ,20);
2468: --
2469: IF l_copinst_set.COUNT > 0 THEN
2470: --

Line 2476: hr_utility.set_location(l_package || ' OIPL2 LC ', 16);

2472: --
2473: l_cop := l_copinst_set(copelenum);
2474: l_oipl_id := l_copinst_set(copelenum).oipl_id;
2475: --
2476: hr_utility.set_location(l_package || ' OIPL2 LC ', 16);
2477: --
2478: -- Only set the flag bit if we have rates or profiles attached
2479: --
2480: IF l_cop.drvbl_fctr_prtn_elig_flag = 'Y'

Line 2511: hr_utility.set_location(l_package || ' close c_oipl: ', 34);

2507: ,p_trk_inelig_per_flag => l_cop.trk_inelig_per_flag);
2508: --
2509: END LOOP;
2510: --
2511: hr_utility.set_location(l_package || ' close c_oipl: ', 34);
2512: END IF;
2513: --
2514: END IF;
2515: --

Line 2521: hr_utility.set_location(l_package || ' Done c_pln_nip ', 30);

2517: --
2518: CLOSE c_pln_nip;
2519: --
2520: END IF;
2521: hr_utility.set_location(l_package || ' Done c_pln_nip ', 30);
2522: --
2523: -- Always check for cobra programs last if mode is unrestricted or
2524: -- life event
2525: --

Line 2531: hr_utility.set_location(l_package || ' fetch c_pgm2 ', 30);

2527: OPEN c_pgm2;
2528: --
2529: LOOP
2530: --
2531: hr_utility.set_location(l_package || ' fetch c_pgm2 ', 30);
2532: FETCH c_pgm2 INTO l_pgm;
2533: hr_utility.set_location(l_package || ' fetched c_pgm2 ', 30);
2534: EXIT WHEN c_pgm2%NOTFOUND;
2535: --

Line 2533: hr_utility.set_location(l_package || ' fetched c_pgm2 ', 30);

2529: LOOP
2530: --
2531: hr_utility.set_location(l_package || ' fetch c_pgm2 ', 30);
2532: FETCH c_pgm2 INTO l_pgm;
2533: hr_utility.set_location(l_package || ' fetched c_pgm2 ', 30);
2534: EXIT WHEN c_pgm2%NOTFOUND;
2535: --
2536: l_pgm_id := l_pgm.pgm_id;
2537: --

Line 2539: hr_utility.set_location(l_package || ' PGM2 LC ', 16);

2535: --
2536: l_pgm_id := l_pgm.pgm_id;
2537: --
2538: --
2539: hr_utility.set_location(l_package || ' PGM2 LC ', 16);
2540: --
2541: -- Only set the flag bit if we have rates or profiles attached
2542: --
2543: IF l_pgm.drvbl_fctr_prtn_elig_flag = 'Y'

Line 2600: hr_utility.set_location('PTIP being cached ' || l_ptip.ptip_id

2596: FETCH c_ptip INTO l_ptip;
2597: --
2598: CLOSE c_ptip;
2599: --
2600: hr_utility.set_location('PTIP being cached ' || l_ptip.ptip_id
2601: ,10);
2602: --
2603: -- Only set the flag bit if we have rates or profiles attached
2604: --

Line 2672: hr_utility.set_location(l_package || ' PLN2 LC ', 16);

2668: ,p_flag_bit_val => l_flag_bit_val
2669: ,p_oiplip_flag_bit_val => 0
2670: ,p_trk_inelig_per_flag => l_plip.trk_inelig_per_flag);
2671: --
2672: hr_utility.set_location(l_package || ' PLN2 LC ', 16);
2673: --
2674: -- Only set the flag bit if we have rates or profiles attached
2675: --
2676: IF l_pln.drvbl_fctr_prtn_elig_flag = 'Y'

Line 2713: hr_utility.set_location(l_package || ' c_oipl2 LC ', 30);

2709: FETCH c_oipl2 INTO l_cop;
2710: EXIT WHEN c_oipl2%NOTFOUND;
2711: l_oipl_id := l_cop.oipl_id;
2712: --
2713: hr_utility.set_location(l_package || ' c_oipl2 LC ', 30);
2714: --
2715: -- Only set the flag bit if we have rates or profiles attached
2716: --
2717: IF l_cop.drvbl_fctr_prtn_elig_flag = 'Y'

Line 2741: --hr_utility.set_location('l_plip.plip_id:'||to_char(l_plip.plip_id), 1999);

2737: --RCHASE Add for bug 1531030. Was not getting oiplip info.
2738: l_oiplip_flag_bit_val := 0;
2739: --
2740: OPEN c_oiplip;
2741: --hr_utility.set_location('l_plip.plip_id:'||to_char(l_plip.plip_id), 1999);
2742: --hr_utility.set_location('l_cop.oipl_id:'||to_char(l_cop.oipl_id), 1999);
2743: --hr_utility.set_location('l_oipl_id:'||to_char(l_oipl_id), 1999);
2744: --
2745: FETCH c_oiplip INTO l_oiplip;

Line 2742: --hr_utility.set_location('l_cop.oipl_id:'||to_char(l_cop.oipl_id), 1999);

2738: l_oiplip_flag_bit_val := 0;
2739: --
2740: OPEN c_oiplip;
2741: --hr_utility.set_location('l_plip.plip_id:'||to_char(l_plip.plip_id), 1999);
2742: --hr_utility.set_location('l_cop.oipl_id:'||to_char(l_cop.oipl_id), 1999);
2743: --hr_utility.set_location('l_oipl_id:'||to_char(l_oipl_id), 1999);
2744: --
2745: FETCH c_oiplip INTO l_oiplip;
2746: --

Line 2743: --hr_utility.set_location('l_oipl_id:'||to_char(l_oipl_id), 1999);

2739: --
2740: OPEN c_oiplip;
2741: --hr_utility.set_location('l_plip.plip_id:'||to_char(l_plip.plip_id), 1999);
2742: --hr_utility.set_location('l_cop.oipl_id:'||to_char(l_cop.oipl_id), 1999);
2743: --hr_utility.set_location('l_oipl_id:'||to_char(l_oipl_id), 1999);
2744: --
2745: FETCH c_oiplip INTO l_oiplip;
2746: --
2747: IF c_oiplip%FOUND THEN

Line 2748: --hr_utility.set_location('OIPLIP_ID:'||to_char(l_oiplip.oiplip_id), 1999);

2744: --
2745: FETCH c_oiplip INTO l_oiplip;
2746: --
2747: IF c_oiplip%FOUND THEN
2748: --hr_utility.set_location('OIPLIP_ID:'||to_char(l_oiplip.oiplip_id), 1999);
2749: --
2750: -- Try and derive bit value for oiplip record
2751: --
2752: l_oiplip_flag_bit_val :=

Line 2763: --hr_utility.set_location('l_oiplip_flag_bit_val:'||l_oiplip_flag_bit_val, 1999);

2759: ,p_oipl_id => NULL
2760: ,p_oiplip_id => l_oiplip.oiplip_id
2761: ,p_plip_id => NULL
2762: ,p_ptip_id => NULL);
2763: --hr_utility.set_location('l_oiplip_flag_bit_val:'||l_oiplip_flag_bit_val, 1999);
2764: --
2765: END IF;
2766: --
2767: CLOSE c_oiplip;

Line 2769: --hr_utility.set_location('Loading Cache:', 1999);

2765: END IF;
2766: --
2767: CLOSE c_oiplip;
2768: --
2769: --hr_utility.set_location('Loading Cache:', 1999);
2770: load_cache(p_oipl_id => l_oipl_id
2771: ,p_oiplip_id => l_oiplip.oiplip_id
2772: ,p_par_pgm_id => l_pgm_id
2773: ,p_par_ptip_id => l_ptip.ptip_id

Line 2781: --hr_utility.set_location(l_package || ' End c_oipl loop ', 20);

2777: ,p_flag_bit_val => l_flag_bit_val
2778: ,p_oiplip_flag_bit_val => l_oiplip_flag_bit_val
2779: ,p_trk_inelig_per_flag => l_cop.trk_inelig_per_flag);
2780: --
2781: --hr_utility.set_location(l_package || ' End c_oipl loop ', 20);
2782: --
2783: --RCHASE End Add
2784: --RCHASE
2785: --load_cache(p_oipl_id => l_oipl_id

Line 2849: hr_utility.set_location(l_package || ' Done c_pgm2 ', 40);

2845: );
2846: --
2847: end if;
2848: --
2849: hr_utility.set_location(l_package || ' Done c_pgm2 ', 40);
2850: IF NOT ben_manage_life_events.g_cache_proc_object.EXISTS(1) THEN
2851: --
2852: -- Different exceptions for different modes, if selection then this is
2853: -- a critical error, if anything else then its not a critical error

Line 2869: hr_utility.set_location(l_package || ' cache_working_data ', 60);

2865: END IF;
2866: --
2867: END IF;
2868: --
2869: hr_utility.set_location(l_package || ' cache_working_data ', 60);
2870: cache_working_data(p_business_group_id=> p_business_group_id
2871: ,p_effective_date => p_effective_date);
2872: --
2873: hr_utility.set_location('Leaving ' || l_package, 100);

Line 2873: hr_utility.set_location('Leaving ' || l_package, 100);

2869: hr_utility.set_location(l_package || ' cache_working_data ', 60);
2870: cache_working_data(p_business_group_id=> p_business_group_id
2871: ,p_effective_date => p_effective_date);
2872: --
2873: hr_utility.set_location('Leaving ' || l_package, 100);
2874: --
2875: END build_comp_object_list;
2876: --
2877: /* GSP Rate Sync */

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

2933: begin
2934: --
2935: l_proc := g_package || '.build_gsp_rate_sync_coobj_list';
2936: --
2937: hr_utility.set_location('Entering ' || l_proc, 10);
2938: --
2939: if p_plip_id is not null
2940: then
2941: --

Line 2942: hr_utility.set_location('Populate g_cache_proc_object for PGM_ID = ' || p_pgm_id, 15);

2938: --
2939: if p_plip_id is not null
2940: then
2941: --
2942: hr_utility.set_location('Populate g_cache_proc_object for PGM_ID = ' || p_pgm_id, 15);
2943: --
2944: -- Clear the comp object list
2945: --
2946: ben_manage_life_events.g_cache_proc_object.delete;

Line 2985: hr_utility.set_location('Populate g_cache_proc_object for PLIP_ID = ' || p_plip_id, 15);

2981: end if;
2982: --
2983: close c_pgm;
2984: --
2985: hr_utility.set_location('Populate g_cache_proc_object for PLIP_ID = ' || p_plip_id, 15);
2986: --
2987: open c_plip (p_plip_id);
2988: --
2989: fetch c_plip into l_drvbl_fctr_prtn_elig_flag, l_drvbl_fctr_apls_rts_flag, l_trk_inelig_per_flag;

Line 3027: hr_utility.set_location('Populate g_cache_proc_object for PL_ID = ' || p_pl_id, 15);

3023: end if; /* c_plip%found */
3024: --
3025: close c_plip;
3026: --
3027: hr_utility.set_location('Populate g_cache_proc_object for PL_ID = ' || p_pl_id, 15);
3028: --
3029: open c_pln (p_pl_id);
3030: --
3031: fetch c_pln into l_drvbl_fctr_prtn_elig_flag, l_drvbl_fctr_apls_rts_flag, l_trk_inelig_per_flag;

Line 3072: hr_utility.set_location('Populate g_cache_proc_object for OIPL_ID = ' || p_oipl_id, 25);

3068: --
3069: if p_oipl_id is not null
3070: then
3071: --
3072: hr_utility.set_location('Populate g_cache_proc_object for OIPL_ID = ' || p_oipl_id, 25);
3073: --
3074: open c_oipl (p_oipl_id);
3075: --
3076: fetch c_oipl into l_drvbl_fctr_prtn_elig_flag, l_drvbl_fctr_apls_rts_flag, l_trk_inelig_per_flag;

Line 3132: hr_utility.set_location('Leaving ' || l_proc, 20);

3128: end if; /* p_oipl_id is not null */
3129: end if; /* p_plip_id is not null */
3130:
3131: --
3132: hr_utility.set_location('Leaving ' || l_proc, 20);
3133: --
3134: end build_gsp_rate_sync_coobj_list;
3135: END ben_comp_object_list;