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 523: hr_utility.set_location('l_flag_bit_val '|| l_flag_bit_val, 10);

519: --
520: END IF;
521: --
522: END IF;
523: hr_utility.set_location('l_flag_bit_val '|| l_flag_bit_val, 10);
524: --
525: -- If there is a derived factor attached to a comp object and the
526: -- derivable factor parameter is 'NONE', set the derivable factor
527: -- parameter to 'ASC' so the derived factor is evaluated.

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

527: -- parameter to 'ASC' so the derived factor is evaluated.
528: -- Bug 2894200.
529: --
530: if (l_flag_bit_val <> 0) AND (ben_manage_life_events.g_derivable_factors = 'NONE') then
531: hr_utility.set_location('g_derivable_factors '|| ben_manage_life_events.g_derivable_factors, 10);
532: ben_manage_life_events.g_derivable_factors := 'ASC';
533: fnd_message.set_name('BEN','BEN_93605_RESET_DRVD_FCTR_PARM');
534: benutils.write(p_text => fnd_message.get);
535: end if;

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

535: end if;
536: --
537: RETURN l_flag_bit_val;
538: --
539: hr_utility.set_location('Leaving ' || l_package, 10);
540: --
541: END set_flag_bit_val;
542: --
543: PROCEDURE load_cache(

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

561: l_count NUMBER;
562: --
563: BEGIN
564: --
565: hr_utility.set_location('Entering ' || l_package, 10);
566: --
567: -- Load cache with comp object details
568: --
569: IF NOT ben_manage_life_events.g_cache_proc_object.EXISTS(1) THEN

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

606: p_flag_bit_val;
607: ben_manage_life_events.g_cache_proc_object(l_count).oiplip_flag_bit_val :=
608: p_oiplip_flag_bit_val;
609: --
610: hr_utility.set_location('Leaving ' || l_package, 10);
611: --
612: END load_cache;
613: --
614: PROCEDURE cache_working_data(

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

632: AND hr.lookup_code IN ('PLIP', 'PGM', 'PLTYP', 'PTIP', 'PL', 'OIPL');
633: --
634: BEGIN
635: --
636: hr_utility.set_location('Entering ' || l_package, 10);
637: --
638: -- Set up cache details for all comp object types
639: --
640: OPEN c_comp_object_meanings;

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

677: CLOSE c_comp_object_meanings;
678: --
679: ben_manage_life_events.g_cached_objects := TRUE;
680: --
681: hr_utility.set_location('Leaving ' || l_package, 10);
682: --
683: END cache_working_data;
684: --
685: PROCEDURE write_multi_session_cache(

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

1761:
1762: --
1763: BEGIN
1764: --
1765: hr_utility.set_location('Entering ' || l_package, 10);
1766: hr_utility.set_location('date ' || p_effective_date, 10);
1767: --
1768: -- PB : Helathnet change :
1769: -- Get the person organization id, if it changes then

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

1762: --
1763: BEGIN
1764: --
1765: hr_utility.set_location('Entering ' || l_package, 10);
1766: hr_utility.set_location('date ' || p_effective_date, 10);
1767: --
1768: -- PB : Helathnet change :
1769: -- Get the person organization id, if it changes then
1770: -- comp object list needs to be rebuilt.

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

1777: --
1778: ben_person_object.get_object(p_person_id => p_person_id,
1779: p_rec => l_ass_rec);
1780: --
1781: hr_utility.set_location('l_ass.assignment_id ' || l_ass_rec.assignment_id, 111);
1782: l_per_org_id := l_ass_rec.organization_id;
1783: --
1784: -- Check if the organization id for the comp object
1785: -- cache has changed since the previous call to build

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

1803: --
1804: END IF;
1805: --
1806: END IF;
1807: hr_utility.set_location('g_prev_per_org_id ' || l_ass_rec.assignment_id, 111);
1808: --
1809: -- Check if the effective date for the comp object
1810: -- cache has changed since the previous call to build
1811: -- comp object. If there is no change then we do not need

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

1853: if l_date_changed or
1854: p_lmt_prpnip_by_org_flag = 'N'
1855: then
1856: --
1857: hr_utility.set_location('Clear caches ' || l_package, 10);
1858: --
1859: ben_comp_object_list1.refresh_eff_date_caches;
1860: --
1861: hr_utility.set_location('Done Clear caches ' || l_package, 10);

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

1857: hr_utility.set_location('Clear caches ' || l_package, 10);
1858: --
1859: ben_comp_object_list1.refresh_eff_date_caches;
1860: --
1861: hr_utility.set_location('Done Clear caches ' || l_package, 10);
1862: --
1863: end if;
1864: --
1865: -- Check if the comp object list exists in the multi session cache

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

2031: OPEN c_multisesscache(c_effective_date=> p_effective_date
2032: ,c_business_group_id => p_business_group_id);
2033: FETCH c_multisesscache INTO l_comp_obj_cache_id, l_timestamp;
2034: --
2035: hr_utility.set_location('fetched multi cache ' , 111);
2036: IF c_multisesscache%FOUND THEN
2037: -- cache exists
2038: -- check if cache has only unrestricted programs
2039: --

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

2036: IF c_multisesscache%FOUND THEN
2037: -- cache exists
2038: -- check if cache has only unrestricted programs
2039: --
2040: hr_utility.set_location('found multi cache ' , 111);
2041: open c_unres_cache_only ;
2042: fetch c_unres_cache_only into l_unres_cache_only ;
2043: if c_unres_cache_only%FOUND then
2044: --

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

2047: null ;
2048: else
2049: -- only unrst pgms exist
2050: -- reset l_rebuild_list to TRUE
2051: hr_utility.set_location(' reset rebuild list pgms ' , 111);
2052: l_rebuild_list := TRUE;
2053: end if;
2054: --
2055: else

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

2065: null ;
2066: else
2067: -- only unrst plns exist
2068: -- reset l_rebuild_list to TRUE
2069: hr_utility.set_location(' reset rebuild list plans ' , 112);
2070: l_rebuild_list := TRUE;
2071: end if;
2072: --
2073: end if ;

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

2088: --
2089: -- End # bug 3330283
2090: */
2091: --
2092: hr_utility.set_location('rebuild cache ' || l_package, 111);
2093: IF l_rebuild_list
2094: OR l_bypass_cache THEN
2095: --
2096: -- Flush all existing multi session cache information

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

2109: end if;
2110: --
2111: IF p_no_programs = 'N' and p_mode not in ('I','D') THEN -- irec -- ICM
2112: --
2113: hr_utility.set_location(l_package || ' Opening c_pgm loop ', 11);
2114: OPEN c_pgm;
2115: hr_utility.set_location(l_package || ' Opened c_pgm loop ', 11);
2116: --
2117: LOOP

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

2111: IF p_no_programs = 'N' and p_mode not in ('I','D') THEN -- irec -- ICM
2112: --
2113: hr_utility.set_location(l_package || ' Opening c_pgm loop ', 11);
2114: OPEN c_pgm;
2115: hr_utility.set_location(l_package || ' Opened c_pgm loop ', 11);
2116: --
2117: LOOP
2118: --
2119: hr_utility.set_location(l_package || ' Start c_pgm loop ', 12);

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

2115: hr_utility.set_location(l_package || ' Opened c_pgm loop ', 11);
2116: --
2117: LOOP
2118: --
2119: hr_utility.set_location(l_package || ' Start c_pgm loop ', 12);
2120: FETCH c_pgm INTO l_pgm;
2121: hr_utility.set_location(l_package || ' Fetch c_pgm loop ', 14);
2122: EXIT WHEN c_pgm%NOTFOUND;
2123: --

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

2117: LOOP
2118: --
2119: hr_utility.set_location(l_package || ' Start c_pgm loop ', 12);
2120: FETCH c_pgm INTO l_pgm;
2121: hr_utility.set_location(l_package || ' Fetch c_pgm loop ', 14);
2122: EXIT WHEN c_pgm%NOTFOUND;
2123: --
2124: l_pgm_id := l_pgm.pgm_id;
2125: --

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

2122: EXIT WHEN c_pgm%NOTFOUND;
2123: --
2124: l_pgm_id := l_pgm.pgm_id;
2125: --
2126: hr_utility.set_location(l_package || ' c_pgm LC ', 16);
2127: --
2128: -- Only set the flag bit if we have rates or profiles attached
2129: --
2130: IF l_pgm.drvbl_fctr_prtn_elig_flag = 'Y'

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

2153: ,p_flag_bit_val => l_flag_bit_val
2154: ,p_oiplip_flag_bit_val => 0
2155: ,p_trk_inelig_per_flag => l_pgm.trk_inelig_per_flag);
2156: --
2157: hr_utility.set_location(l_package || ' Start c_pln loop ', 20);
2158: ben_pln_cache.bgpcpp_getdets(p_business_group_id=> p_business_group_id
2159: ,p_effective_date => p_effective_date
2160: ,p_mode => p_mode
2161: ,p_pgm_id => l_pgm_id

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

2169: -- ,p_popl_enrt_typ_cycl_id => p_popl_enrt_typ_cycl_id
2170: --
2171: ,p_inst_set => l_plninst_set
2172: );
2173: hr_utility.set_location(l_package || ' Fetch c_pln loop ', 22);
2174: --
2175: IF l_plninst_set.COUNT > 0 THEN
2176: --
2177: FOR plnelenum IN l_plninst_set.FIRST .. l_plninst_set.LAST LOOP

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

2179: l_pln := l_plninst_set(plnelenum);
2180: l_pl_id := l_plninst_set(plnelenum).pl_id;
2181: l_ptp_opt_typ_cd := l_plninst_set(plnelenum).ptp_opt_typ_cd;
2182: --
2183: hr_utility.set_location(l_package || ' Dn PLN OSR ', 16);
2184: --
2185: -- In collective agreement mode only process CAGR opt types
2186: --
2187: if l_ptp_opt_typ_cd <> 'CAGR'

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

2196: -- plan in program we are dealing with
2197: -- There will ALWAYS be a PLIP_ID but we cannot guarantee
2198: -- a PTIP id.
2199: --
2200: hr_utility.set_location(l_package || ' open c_ptip ', 16);
2201: OPEN c_ptip;
2202: --
2203: FETCH c_ptip INTO l_ptip;
2204: --

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

2233: ,p_flag_bit_val => l_flag_bit_val
2234: ,p_oiplip_flag_bit_val => 0
2235: ,p_trk_inelig_per_flag => l_ptip.trk_inelig_per_flag);
2236: --
2237: hr_utility.set_location(l_package || ' open c_plip ', 16);
2238: OPEN c_plip;
2239: --
2240: FETCH c_plip INTO l_plip;
2241: --

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

2322: --
2323: l_cop := l_copinst_set(copelenum);
2324: l_oipl_id := l_copinst_set(copelenum).oipl_id;
2325: --
2326: hr_utility.set_location(l_package || ' c_oipl load_cache '
2327: ,15);
2328: --
2329: -- Only set the flag bit if we have rates or profiles attached
2330: --

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

2389: ,p_flag_bit_val => l_flag_bit_val
2390: ,p_oiplip_flag_bit_val => l_oiplip_flag_bit_val
2391: ,p_trk_inelig_per_flag => l_cop.trk_inelig_per_flag);
2392: --
2393: hr_utility.set_location(l_package || ' End c_oipl loop ', 20);
2394: END LOOP;
2395: --
2396: END IF;
2397: --

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

2396: END IF;
2397: --
2398: END IF;
2399: --
2400: hr_utility.set_location(l_package || ' End c_pln loop ', 20);
2401: END LOOP;
2402: --
2403: END IF;
2404: --

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

2401: END LOOP;
2402: --
2403: END IF;
2404: --
2405: hr_utility.set_location(l_package || ' End c_pgm loop ', 15);
2406: END LOOP;
2407: --
2408: CLOSE c_pgm;
2409: --

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

2407: --
2408: CLOSE c_pgm;
2409: --
2410: END IF;
2411: hr_utility.set_location(l_package || ' Done c_pgm ', 20);
2412: --
2413: -- get the stragglers, the plans that aren't in a program
2414: -- added p_no_programs = N so that if only programs, plnip are not included
2415: IF (p_mode <> 'G') and

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

2421: OPEN c_pln_nip;
2422: --
2423: LOOP
2424: --
2425: hr_utility.set_location(l_package || ' Start c_pln_nip ', 30);
2426: FETCH c_pln_nip INTO l_pln;
2427: hr_utility.set_location(l_package || ' Fetch c_pln_nip = '||
2428: l_pln.pl_id, 32);
2429: EXIT WHEN c_pln_nip%NOTFOUND;

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

2423: LOOP
2424: --
2425: hr_utility.set_location(l_package || ' Start c_pln_nip ', 30);
2426: FETCH c_pln_nip INTO l_pln;
2427: hr_utility.set_location(l_package || ' Fetch c_pln_nip = '||
2428: l_pln.pl_id, 32);
2429: EXIT WHEN c_pln_nip%NOTFOUND;
2430: l_pl_id := l_pln.pl_id;
2431: l_ptp_opt_typ_cd := l_pln.ptp_opt_typ_cd;

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

2429: EXIT WHEN c_pln_nip%NOTFOUND;
2430: l_pl_id := l_pln.pl_id;
2431: l_ptp_opt_typ_cd := l_pln.ptp_opt_typ_cd;
2432: --
2433: hr_utility.set_location(l_package || ' PLNNIP LC ', 16);
2434: --
2435: -- In collective agreement mode only process CAGR opt types
2436: --
2437: if l_ptp_opt_typ_cd <> 'CAGR'

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

2471: ,p_flag_bit_val => l_flag_bit_val
2472: ,p_oiplip_flag_bit_val => 0
2473: ,p_trk_inelig_per_flag => l_pln.trk_inelig_per_flag);
2474: --
2475: hr_utility.set_location(l_package || ' fetch c_oipl 1', 20);
2476: ben_cop_cache.bgpcop_getdets(p_effective_date=> p_effective_date
2477: ,p_business_group_id => p_business_group_id
2478: ,p_pl_id => l_pl_id
2479: ,p_opt_id => p_opt_id

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

2481: ,p_vrbl_rt_prfl_id => p_vrbl_rt_prfl_id
2482: ,p_mode => p_mode
2483: --
2484: ,p_inst_set => l_copinst_set);
2485: hr_utility.set_location(l_package || ' Dn fetch c_oipl 1', 20);
2486: hr_utility.set_location(' Number of oipls' || l_copinst_set.COUNT
2487: ,20);
2488: --
2489: IF l_copinst_set.COUNT > 0 THEN

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

2482: ,p_mode => p_mode
2483: --
2484: ,p_inst_set => l_copinst_set);
2485: hr_utility.set_location(l_package || ' Dn fetch c_oipl 1', 20);
2486: hr_utility.set_location(' Number of oipls' || l_copinst_set.COUNT
2487: ,20);
2488: --
2489: IF l_copinst_set.COUNT > 0 THEN
2490: --

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

2492: --
2493: l_cop := l_copinst_set(copelenum);
2494: l_oipl_id := l_copinst_set(copelenum).oipl_id;
2495: --
2496: hr_utility.set_location(l_package || ' OIPL2 LC ', 16);
2497: --
2498: -- Only set the flag bit if we have rates or profiles attached
2499: --
2500: IF l_cop.drvbl_fctr_prtn_elig_flag = 'Y'

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

2527: ,p_trk_inelig_per_flag => l_cop.trk_inelig_per_flag);
2528: --
2529: END LOOP;
2530: --
2531: hr_utility.set_location(l_package || ' close c_oipl: ', 34);
2532: END IF;
2533: --
2534: END IF;
2535: --

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

2537: --
2538: CLOSE c_pln_nip;
2539: --
2540: END IF;
2541: hr_utility.set_location(l_package || ' Done c_pln_nip ', 30);
2542: --
2543: -- Always check for cobra programs last if mode is unrestricted or
2544: -- life event
2545: --

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

2547: OPEN c_pgm2;
2548: --
2549: LOOP
2550: --
2551: hr_utility.set_location(l_package || ' fetch c_pgm2 ', 30);
2552: FETCH c_pgm2 INTO l_pgm;
2553: hr_utility.set_location(l_package || ' fetched c_pgm2 ', 30);
2554: EXIT WHEN c_pgm2%NOTFOUND;
2555: --

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

2549: LOOP
2550: --
2551: hr_utility.set_location(l_package || ' fetch c_pgm2 ', 30);
2552: FETCH c_pgm2 INTO l_pgm;
2553: hr_utility.set_location(l_package || ' fetched c_pgm2 ', 30);
2554: EXIT WHEN c_pgm2%NOTFOUND;
2555: --
2556: l_pgm_id := l_pgm.pgm_id;
2557: --

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

2555: --
2556: l_pgm_id := l_pgm.pgm_id;
2557: --
2558: --
2559: hr_utility.set_location(l_package || ' PGM2 LC ', 16);
2560: --
2561: -- Only set the flag bit if we have rates or profiles attached
2562: --
2563: IF l_pgm.drvbl_fctr_prtn_elig_flag = 'Y'

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

2616: FETCH c_ptip INTO l_ptip;
2617: --
2618: CLOSE c_ptip;
2619: --
2620: hr_utility.set_location('PTIP being cached ' || l_ptip.ptip_id
2621: ,10);
2622: --
2623: -- Only set the flag bit if we have rates or profiles attached
2624: --

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

2688: ,p_flag_bit_val => l_flag_bit_val
2689: ,p_oiplip_flag_bit_val => 0
2690: ,p_trk_inelig_per_flag => l_plip.trk_inelig_per_flag);
2691: --
2692: hr_utility.set_location(l_package || ' PLN2 LC ', 16);
2693: --
2694: -- Only set the flag bit if we have rates or profiles attached
2695: --
2696: IF l_pln.drvbl_fctr_prtn_elig_flag = 'Y'

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

2729: FETCH c_oipl2 INTO l_cop;
2730: EXIT WHEN c_oipl2%NOTFOUND;
2731: l_oipl_id := l_cop.oipl_id;
2732: --
2733: hr_utility.set_location(l_package || ' c_oipl2 LC ', 30);
2734: --
2735: -- Only set the flag bit if we have rates or profiles attached
2736: --
2737: IF l_cop.drvbl_fctr_prtn_elig_flag = 'Y'

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

2757: --RCHASE Add for bug 1531030. Was not getting oiplip info.
2758: l_oiplip_flag_bit_val := 0;
2759: --
2760: OPEN c_oiplip;
2761: --hr_utility.set_location('l_plip.plip_id:'||to_char(l_plip.plip_id), 1999);
2762: --hr_utility.set_location('l_cop.oipl_id:'||to_char(l_cop.oipl_id), 1999);
2763: --hr_utility.set_location('l_oipl_id:'||to_char(l_oipl_id), 1999);
2764: --
2765: FETCH c_oiplip INTO l_oiplip;

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

2758: l_oiplip_flag_bit_val := 0;
2759: --
2760: OPEN c_oiplip;
2761: --hr_utility.set_location('l_plip.plip_id:'||to_char(l_plip.plip_id), 1999);
2762: --hr_utility.set_location('l_cop.oipl_id:'||to_char(l_cop.oipl_id), 1999);
2763: --hr_utility.set_location('l_oipl_id:'||to_char(l_oipl_id), 1999);
2764: --
2765: FETCH c_oiplip INTO l_oiplip;
2766: --

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

2759: --
2760: OPEN c_oiplip;
2761: --hr_utility.set_location('l_plip.plip_id:'||to_char(l_plip.plip_id), 1999);
2762: --hr_utility.set_location('l_cop.oipl_id:'||to_char(l_cop.oipl_id), 1999);
2763: --hr_utility.set_location('l_oipl_id:'||to_char(l_oipl_id), 1999);
2764: --
2765: FETCH c_oiplip INTO l_oiplip;
2766: --
2767: IF c_oiplip%FOUND THEN

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

2764: --
2765: FETCH c_oiplip INTO l_oiplip;
2766: --
2767: IF c_oiplip%FOUND THEN
2768: --hr_utility.set_location('OIPLIP_ID:'||to_char(l_oiplip.oiplip_id), 1999);
2769: --
2770: -- Try and derive bit value for oiplip record
2771: --
2772: l_oiplip_flag_bit_val :=

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

2779: ,p_oipl_id => NULL
2780: ,p_oiplip_id => l_oiplip.oiplip_id
2781: ,p_plip_id => NULL
2782: ,p_ptip_id => NULL);
2783: --hr_utility.set_location('l_oiplip_flag_bit_val:'||l_oiplip_flag_bit_val, 1999);
2784: --
2785: END IF;
2786: --
2787: CLOSE c_oiplip;

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

2785: END IF;
2786: --
2787: CLOSE c_oiplip;
2788: --
2789: --hr_utility.set_location('Loading Cache:', 1999);
2790: load_cache(p_oipl_id => l_oipl_id
2791: ,p_oiplip_id => l_oiplip.oiplip_id
2792: ,p_par_pgm_id => l_pgm_id
2793: ,p_par_ptip_id => l_ptip.ptip_id

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

2797: ,p_flag_bit_val => l_flag_bit_val
2798: ,p_oiplip_flag_bit_val => l_oiplip_flag_bit_val
2799: ,p_trk_inelig_per_flag => l_cop.trk_inelig_per_flag);
2800: --
2801: --hr_utility.set_location(l_package || ' End c_oipl loop ', 20);
2802: --
2803: --RCHASE End Add
2804: --RCHASE
2805: --load_cache(p_oipl_id => l_oipl_id

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

2865: );
2866: --
2867: end if;
2868: --
2869: hr_utility.set_location(l_package || ' Done c_pgm2 ', 40);
2870: IF NOT ben_manage_life_events.g_cache_proc_object.EXISTS(1) THEN
2871: --
2872: -- Different exceptions for different modes, if selection then this is
2873: -- a critical error, if anything else then its not a critical error

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

2885: END IF;
2886: --
2887: END IF;
2888: --
2889: hr_utility.set_location(l_package || ' cache_working_data ', 60);
2890: cache_working_data(p_business_group_id=> p_business_group_id
2891: ,p_effective_date => p_effective_date);
2892: --
2893: hr_utility.set_location('Leaving ' || l_package, 100);

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

2889: hr_utility.set_location(l_package || ' cache_working_data ', 60);
2890: cache_working_data(p_business_group_id=> p_business_group_id
2891: ,p_effective_date => p_effective_date);
2892: --
2893: hr_utility.set_location('Leaving ' || l_package, 100);
2894: --
2895: END build_comp_object_list;
2896: --
2897: /* GSP Rate Sync */

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

2953: begin
2954: --
2955: l_proc := g_package || '.build_gsp_rate_sync_coobj_list';
2956: --
2957: hr_utility.set_location('Entering ' || l_proc, 10);
2958: --
2959: if p_plip_id is not null
2960: then
2961: --

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

2958: --
2959: if p_plip_id is not null
2960: then
2961: --
2962: hr_utility.set_location('Populate g_cache_proc_object for PGM_ID = ' || p_pgm_id, 15);
2963: --
2964: -- Clear the comp object list
2965: --
2966: ben_manage_life_events.g_cache_proc_object.delete;

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

3001: end if;
3002: --
3003: close c_pgm;
3004: --
3005: hr_utility.set_location('Populate g_cache_proc_object for PLIP_ID = ' || p_plip_id, 15);
3006: --
3007: open c_plip (p_plip_id);
3008: --
3009: fetch c_plip into l_drvbl_fctr_prtn_elig_flag, l_drvbl_fctr_apls_rts_flag, l_trk_inelig_per_flag;

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

3043: end if; /* c_plip%found */
3044: --
3045: close c_plip;
3046: --
3047: hr_utility.set_location('Populate g_cache_proc_object for PL_ID = ' || p_pl_id, 15);
3048: --
3049: open c_pln (p_pl_id);
3050: --
3051: fetch c_pln into l_drvbl_fctr_prtn_elig_flag, l_drvbl_fctr_apls_rts_flag, l_trk_inelig_per_flag;

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

3088: --
3089: if p_oipl_id is not null
3090: then
3091: --
3092: hr_utility.set_location('Populate g_cache_proc_object for OIPL_ID = ' || p_oipl_id, 25);
3093: --
3094: open c_oipl (p_oipl_id);
3095: --
3096: fetch c_oipl into l_drvbl_fctr_prtn_elig_flag, l_drvbl_fctr_apls_rts_flag, l_trk_inelig_per_flag;

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

3148: end if; /* p_oipl_id is not null */
3149: end if; /* p_plip_id is not null */
3150:
3151: --
3152: hr_utility.set_location('Leaving ' || l_proc, 20);
3153: --
3154: end build_gsp_rate_sync_coobj_list;
3155: END ben_comp_object_list;