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

Line 25: g_debug BOOLEAN := hr_utility.debug_enabled;

21: ----------------------------------------------------------------------------------------------*/
22: --
23: g_benefit_action_id NUMBER;
24: g_package VARCHAR2 (80) := 'ben_icm_life_events';
25: g_debug BOOLEAN := hr_utility.debug_enabled;
26:
27: ----------------------------------------------------------------------------------------------
28: --
29: PROCEDURE insert_into_icd (

Line 80: g_debug := hr_utility.debug_enabled;

76: l_bnf_rqd_flag VARCHAR2 (30) := 'N';
77: --
78: BEGIN
79: --
80: g_debug := hr_utility.debug_enabled;
81:
82: --
83: IF (g_debug)
84: THEN

Line 85: hr_utility.set_location ('Entering insert_into_icd ', 213);

81:
82: --
83: IF (g_debug)
84: THEN
85: hr_utility.set_location ('Entering insert_into_icd ', 213);
86: END IF;
87:
88: --
89: OPEN c_next_val;

Line 221: hr_utility.set_location ('Leaving Insert_Into_Icd ', 213);

217:
218: --
219: IF (g_debug)
220: THEN
221: hr_utility.set_location ('Leaving Insert_Into_Icd ', 213);
222: END IF;
223: --
224: EXCEPTION
225: --

Line 231: hr_utility.set_location ('SQLERRM' || SUBSTR (SQLERRM, 1, 50),

227: THEN
228: --
229: IF (g_debug)
230: THEN
231: hr_utility.set_location ('SQLERRM' || SUBSTR (SQLERRM, 1, 50),
232: 121
233: );
234: hr_utility.set_location ('SQLERRM' || SUBSTR (SQLERRM, 51, 100),
235: 121

Line 234: hr_utility.set_location ('SQLERRM' || SUBSTR (SQLERRM, 51, 100),

230: THEN
231: hr_utility.set_location ('SQLERRM' || SUBSTR (SQLERRM, 1, 50),
232: 121
233: );
234: hr_utility.set_location ('SQLERRM' || SUBSTR (SQLERRM, 51, 100),
235: 121
236: );
237: END IF;
238:

Line 286: g_debug := hr_utility.debug_enabled;

282: --
283: l_opt_id c_opt_id%ROWTYPE;
284: --
285: BEGIN
286: g_debug := hr_utility.debug_enabled;
287:
288: IF g_debug
289: THEN
290: hr_utility.set_location ('Entering create_icd_rates ', 213);

Line 290: hr_utility.set_location ('Entering create_icd_rates ', 213);

286: g_debug := hr_utility.debug_enabled;
287:
288: IF g_debug
289: THEN
290: hr_utility.set_location ('Entering create_icd_rates ', 213);
291: END IF;
292:
293: l_icd_count := ben_determine_activity_base_rt.l_icd_chc_rates_tab.COUNT;
294:

Line 297: hr_utility.set_location ('l_icd_count' || l_icd_count, 31);

293: l_icd_count := ben_determine_activity_base_rt.l_icd_chc_rates_tab.COUNT;
294:
295: IF g_debug
296: THEN
297: hr_utility.set_location ('l_icd_count' || l_icd_count, 31);
298: END IF;
299:
300: --
301: --For Plan Level Rates

Line 313: hr_utility.set_location ('cache1' || cache1, 111);

309: cache1 := ben_icm_life_events.g_cache_pep_object.COUNT;
310:
311: IF g_debug
312: THEN
313: hr_utility.set_location ('cache1' || cache1, 111);
314: END IF;
315:
316: --
317: cache11 := 1;

Line 324: hr_utility.set_location ('cache1' || cache1, 112);

320: LOOP
321: --
322: IF g_debug
323: THEN
324: hr_utility.set_location ('cache1' || cache1, 112);
325: hr_utility.set_location
326: ( 'ben_determine_activity_base_rt.l_icd_chc_rates_tab(l_icd_count).pl_id'
327: || TO_CHAR
328: (ben_determine_activity_base_rt.l_icd_chc_rates_tab

Line 325: hr_utility.set_location

321: --
322: IF g_debug
323: THEN
324: hr_utility.set_location ('cache1' || cache1, 112);
325: hr_utility.set_location
326: ( 'ben_determine_activity_base_rt.l_icd_chc_rates_tab(l_icd_count).pl_id'
327: || TO_CHAR
328: (ben_determine_activity_base_rt.l_icd_chc_rates_tab
329: (l_icd_count).pl_id

Line 333: hr_utility.set_location

329: (l_icd_count).pl_id
330: ),
331: 12
332: );
333: hr_utility.set_location
334: ( 'ben_icm_life_events.g_cache_pep_object (cache11).pl_id'
335: || TO_CHAR
336: (ben_icm_life_events.g_cache_pep_object (cache11).pl_id
337: ),

Line 431: hr_utility.set_location ('cache1 ' || cache1, 333);

427:
428: --
429: IF g_debug
430: THEN
431: hr_utility.set_location ('cache1 ' || cache1, 333);
432: hr_utility.set_location ('cache11 ' || cache11, 333);
433: END IF;
434: END LOOP;
435: --

Line 432: hr_utility.set_location ('cache11 ' || cache11, 333);

428: --
429: IF g_debug
430: THEN
431: hr_utility.set_location ('cache1 ' || cache1, 333);
432: hr_utility.set_location ('cache11 ' || cache11, 333);
433: END IF;
434: END LOOP;
435: --
436: END IF;

Line 443: hr_utility.set_location ('l_icd_count ' || l_icd_count, 333);

439: l_icd_count := l_icd_count - 1;
440:
441: IF g_debug
442: THEN
443: hr_utility.set_location ('l_icd_count ' || l_icd_count, 333);
444: END IF;
445: --
446: END LOOP;
447:

Line 455: hr_utility.set_location ('l_icd_count' || l_icd_count, 33);

451: l_icd_count := ben_determine_activity_base_rt.l_icd_chc_rates_tab.COUNT;
452:
453: IF g_debug
454: THEN
455: hr_utility.set_location ('l_icd_count' || l_icd_count, 33);
456: END IF;
457:
458: j := 1;
459:

Line 473: hr_utility.set_location ('rtagarra cache1' || cache1, 115);

469: cache1 := ben_icm_life_events.g_cache_epo_object.COUNT;
470:
471: IF g_debug
472: THEN
473: hr_utility.set_location ('rtagarra cache1' || cache1, 115);
474: END IF;
475:
476: cache11 := 1;
477:

Line 483: hr_utility.set_location

479: LOOP
480: --
481: IF g_debug
482: THEN
483: hr_utility.set_location
484: ( 'l_icd_chc_rates_tab(l_icd_count).opt_id'
485: || ben_determine_activity_base_rt.l_icd_chc_rates_tab
486: (l_icd_count).opt_id,
487: 12

Line 489: hr_utility.set_location

485: || ben_determine_activity_base_rt.l_icd_chc_rates_tab
486: (l_icd_count).opt_id,
487: 12
488: );
489: hr_utility.set_location
490: ( 'g_cache_epo_object (cache11).opt_id'
491: || ben_icm_life_events.g_cache_epo_object (cache11).opt_id,
492: 12
493: );

Line 494: hr_utility.set_location

490: ( 'g_cache_epo_object (cache11).opt_id'
491: || ben_icm_life_events.g_cache_epo_object (cache11).opt_id,
492: 12
493: );
494: hr_utility.set_location
495: ( 'l_icd_chc_rates_tab(l_icd_count).opt_id'
496: || ben_determine_activity_base_rt.l_icd_chc_rates_tab
497: (l_icd_count).oipl_id,
498: 12

Line 501: hr_utility.set_location

497: (l_icd_count).oipl_id,
498: 12
499: );
500: --
501: hr_utility.set_location
502: ( 'g_cache_epo_pl_id'
503: || ben_icm_life_events.g_cache_epo_object (cache11).p_pl_id,
504: 431234
505: );

Line 520: hr_utility.set_location ('l_opt_id.pl_id' || l_opt_id.pl_id,

516:
517: --
518: IF g_debug
519: THEN
520: hr_utility.set_location ('l_opt_id.pl_id' || l_opt_id.pl_id,
521: 13
522: );
523: END IF;
524: IF l_opt_id.opt_id =

Line 594: hr_utility.set_location ('Deleting ICD Rates', 321);

590: THEN
591: --
592: IF g_debug
593: THEN
594: hr_utility.set_location ('Deleting ICD Rates', 321);
595: END IF;
596:
597: DELETE FROM ben_icd_chc_rates
598: WHERE person_id = p_person_id

Line 616: hr_utility.set_location ('cache1 ' || cache1, 333);

612: END IF;
613:
614: IF g_debug
615: THEN
616: hr_utility.set_location ('cache1 ' || cache1, 333);
617: hr_utility.set_location ('cache11 ' || cache11, 333);
618: END IF;
619:
620: j := j + 1;

Line 617: hr_utility.set_location ('cache11 ' || cache11, 333);

613:
614: IF g_debug
615: THEN
616: hr_utility.set_location ('cache1 ' || cache1, 333);
617: hr_utility.set_location ('cache11 ' || cache11, 333);
618: END IF;
619:
620: j := j + 1;
621: l_icd_count := l_icd_count - 1;

Line 628: hr_utility.set_location ('Leaving create_icd_rates ', 213);

624:
625: --
626: IF g_debug
627: THEN
628: hr_utility.set_location ('Leaving create_icd_rates ', 213);
629: END IF;
630: EXCEPTION
631: --
632: WHEN OTHERS

Line 637: hr_utility.set_location ('SQLERRM' || SUBSTR (SQLERRM, 1, 50),

633: THEN
634: --
635: IF g_debug
636: THEN
637: hr_utility.set_location ('SQLERRM' || SUBSTR (SQLERRM, 1, 50),
638: 121
639: );
640: END IF;
641:

Line 694: g_debug := hr_utility.debug_enabled;

690: l_epo_ovn NUMBER;*/
691: --
692: BEGIN
693: --
694: g_debug := hr_utility.debug_enabled;
695: IF g_debug
696: THEN
697: hr_utility.set_location ('RTAGARRA: Entering CREATE_PEP_EPO_REC',
698: 12121

Line 697: hr_utility.set_location ('RTAGARRA: Entering CREATE_PEP_EPO_REC',

693: --
694: g_debug := hr_utility.debug_enabled;
695: IF g_debug
696: THEN
697: hr_utility.set_location ('RTAGARRA: Entering CREATE_PEP_EPO_REC',
698: 12121
699: );
700: END IF;
701:

Line 709: hr_utility.set_location ('l_pep_count ' || l_pep_count, 12121);

705:
706: --
707: IF g_debug
708: THEN
709: hr_utility.set_location ('l_pep_count ' || l_pep_count, 12121);
710: hr_utility.set_location ('l_count2 ' || l_count2, 12121);
711: END IF;
712:
713: WHILE l_pep_count > 0

Line 710: hr_utility.set_location ('l_count2 ' || l_count2, 12121);

706: --
707: IF g_debug
708: THEN
709: hr_utility.set_location ('l_pep_count ' || l_pep_count, 12121);
710: hr_utility.set_location ('l_count2 ' || l_count2, 12121);
711: END IF;
712:
713: WHILE l_pep_count > 0
714: LOOP

Line 732: hr_utility.set_location ('Still ELig or Still Inelig', 31);

728: THEN
729: --
730: IF g_debug
731: THEN
732: hr_utility.set_location ('Still ELig or Still Inelig', 31);
733: END IF;
734: --
735: ben_eligible_person_perf_api.update_perf_eligible_person
736: (p_validate => FALSE,

Line 833: hr_utility.set_location ('Insert Mode for PEP' ||ben_icm_life_events.g_cache_pep_object (l_count).object_version_number, 1234);

829: THEN
830: --
831: IF g_debug
832: THEN
833: hr_utility.set_location ('Insert Mode for PEP' ||ben_icm_life_events.g_cache_pep_object (l_count).object_version_number, 1234);
834: END IF;
835:
836: --
837: INSERT INTO ben_elig_per_f

Line 973: hr_utility.set_location ('Newly Ineligible', 123);

969: THEN
970: --
971: IF g_debug
972: THEN
973: hr_utility.set_location ('Newly Ineligible', 123);
974: END IF;
975:
976: --
977: ben_eligible_person_perf_api.update_perf_eligible_person

Line 1076: hr_utility.set_location ('Newly Eligible', 121);

1072: THEN
1073: --
1074: IF g_debug
1075: THEN
1076: hr_utility.set_location ('Newly Eligible', 121);
1077: END IF;
1078:
1079: --
1080: ben_eligible_person_perf_api.update_perf_eligible_person

Line 1210: hr_utility.set_location ('Still ELig or Still Inelig'|| ben_icm_life_events.g_cache_epo_object(v_count).elig_per_opt_id, 125);

1206: THEN
1207: --
1208: IF g_debug
1209: THEN
1210: hr_utility.set_location ('Still ELig or Still Inelig'|| ben_icm_life_events.g_cache_epo_object(v_count).elig_per_opt_id, 125);
1211: END IF;
1212: --
1213: ben_eligible_person_perf_api.update_perf_elig_person_option
1214: (p_validate => FALSE,

Line 1337: hr_utility.set_location ('Insert Mode for EPO' || ben_icm_life_events.g_cache_epo_object (v_count).elig_per_opt_id, 1234);

1333: -- AND l_trk_inelig_per_flag = 'Y'
1334: THEN
1335: IF g_debug
1336: THEN
1337: hr_utility.set_location ('Insert Mode for EPO' || ben_icm_life_events.g_cache_epo_object (v_count).elig_per_opt_id, 1234);
1338: END IF;
1339:
1340: INSERT INTO ben_elig_per_opt_f
1341: (elig_per_opt_id,

Line 1454: hr_utility.set_location ('Newly Ineligible', 125);

1450: ELSIF ben_icm_life_events.g_cache_epo_object (v_count).p_newly_inelig
1451: THEN
1452: IF g_debug
1453: THEN
1454: hr_utility.set_location ('Newly Ineligible', 125);
1455: END IF;
1456:
1457: --
1458: ben_eligible_person_perf_api.update_perf_elig_person_option

Line 1580: hr_utility.set_location ('Newly Eligible', 125);

1576: ELSIF ben_icm_life_events.g_cache_epo_object (v_count).p_newly_elig
1577: THEN
1578: IF g_debug
1579: THEN
1580: hr_utility.set_location ('Newly Eligible', 125);
1581: END IF;
1582:
1583: --
1584: /* IF l_trk_inelig_per_flag <> 'Y'

Line 1823: hr_utility.set_location ('l_count2' || l_count2, 12);

1819: l_count2 := l_count2 - 1;
1820:
1821: IF g_debug
1822: THEN
1823: hr_utility.set_location ('l_count2' || l_count2, 12);
1824: END IF;
1825: END LOOP;
1826:
1827: IF g_debug

Line 1829: hr_utility.set_location ('Leaving CREATE_PEP_EPO_REC', 123);

1825: END LOOP;
1826:
1827: IF g_debug
1828: THEN
1829: hr_utility.set_location ('Leaving CREATE_PEP_EPO_REC', 123);
1830: END IF;
1831: EXCEPTION
1832: WHEN OTHERS
1833: THEN

Line 1836: hr_utility.set_location ('SQLERRM' || substr(SQLERRM,1,30), 123);

1832: WHEN OTHERS
1833: THEN
1834: IF g_debug
1835: THEN
1836: hr_utility.set_location ('SQLERRM' || substr(SQLERRM,1,30), 123);
1837: hr_utility.set_location ('SQLERRM' || substr(SQLERRM,31,60), 1234);
1838: END IF;
1839: RAISE;
1840: ROLLBACK TO elig_per_cache_savepont;

Line 1837: hr_utility.set_location ('SQLERRM' || substr(SQLERRM,31,60), 1234);

1833: THEN
1834: IF g_debug
1835: THEN
1836: hr_utility.set_location ('SQLERRM' || substr(SQLERRM,1,30), 123);
1837: hr_utility.set_location ('SQLERRM' || substr(SQLERRM,31,60), 1234);
1838: END IF;
1839: RAISE;
1840: ROLLBACK TO elig_per_cache_savepont;
1841: ben_icm_life_events.g_cache_pep_object.DELETE;

Line 1900: g_debug := hr_utility.debug_enabled;

1896: l_msg VARCHAR2(2000);
1897: --
1898: BEGIN
1899: --
1900: g_debug := hr_utility.debug_enabled;
1901: -- hr_utility.trace_on(null,'rtagarra');
1902: IF g_debug
1903: THEN
1904: hr_utility.set_location ('Entering ' || l_proc, 10);

Line 1901: -- hr_utility.trace_on(null,'rtagarra');

1897: --
1898: BEGIN
1899: --
1900: g_debug := hr_utility.debug_enabled;
1901: -- hr_utility.trace_on(null,'rtagarra');
1902: IF g_debug
1903: THEN
1904: hr_utility.set_location ('Entering ' || l_proc, 10);
1905: END IF;

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

1900: g_debug := hr_utility.debug_enabled;
1901: -- hr_utility.trace_on(null,'rtagarra');
1902: IF g_debug
1903: THEN
1904: hr_utility.set_location ('Entering ' || l_proc, 10);
1905: END IF;
1906:
1907: --
1908: DELETE FROM ben_icd_chc_rates

Line 1963: hr_utility.set_location ('After process', 10);

1959:
1960: --
1961: IF g_debug
1962: THEN
1963: hr_utility.set_location ('After process', 10);
1964: hr_utility.set_location ('Before get_parameter', 21);
1965: END IF;
1966:
1967: --

Line 1964: hr_utility.set_location ('Before get_parameter', 21);

1960: --
1961: IF g_debug
1962: THEN
1963: hr_utility.set_location ('After process', 10);
1964: hr_utility.set_location ('Before get_parameter', 21);
1965: END IF;
1966:
1967: --
1968: benutils.get_parameter (p_business_group_id => p_business_group_id,

Line 1980: hr_utility.set_location ('After get_parameter', 22);

1976: -- Set up benefits environment
1977: --
1978: IF g_debug
1979: THEN
1980: hr_utility.set_location ('After get_parameter', 22);
1981: hr_utility.set_location ('Before clear_init_benmngle_caches', 23);
1982: END IF;
1983:
1984: --

Line 1981: hr_utility.set_location ('Before clear_init_benmngle_caches', 23);

1977: --
1978: IF g_debug
1979: THEN
1980: hr_utility.set_location ('After get_parameter', 22);
1981: hr_utility.set_location ('Before clear_init_benmngle_caches', 23);
1982: END IF;
1983:
1984: --
1985: --

Line 1999: hr_utility.set_location ('After clear_init_benmngle_caches', 24);

1995:
1996: --
1997: IF g_debug
1998: THEN
1999: hr_utility.set_location ('After clear_init_benmngle_caches', 24);
2000: hr_utility.set_location ('Before Build Comp Object List', 30);
2001: END IF;
2002:
2003: --

Line 2000: hr_utility.set_location ('Before Build Comp Object List', 30);

1996: --
1997: IF g_debug
1998: THEN
1999: hr_utility.set_location ('After clear_init_benmngle_caches', 24);
2000: hr_utility.set_location ('Before Build Comp Object List', 30);
2001: END IF;
2002:
2003: --
2004: ben_comp_object_list.flush_multi_session_cache

Line 2032: hr_utility.set_location ('After build comp object', 32);

2028:
2029: --
2030: IF g_debug
2031: THEN
2032: hr_utility.set_location ('After build comp object', 32);
2033: --
2034: hr_utility.set_location ('Before evaluate life events', 45);
2035: --
2036: END IF;

Line 2034: hr_utility.set_location ('Before evaluate life events', 45);

2030: IF g_debug
2031: THEN
2032: hr_utility.set_location ('After build comp object', 32);
2033: --
2034: hr_utility.set_location ('Before evaluate life events', 45);
2035: --
2036: END IF;
2037:
2038: ben_manage_life_events.evaluate_life_events

Line 2053: hr_utility.set_location ('After evaluate life events', 50);

2049:
2050: --
2051: IF g_debug
2052: THEN
2053: hr_utility.set_location ('After evaluate life events', 50);
2054: END IF;
2055:
2056: --
2057: g_benefit_action_id := benutils.g_benefit_action_id;

Line 2070: hr_utility.set_location ('Before Person Header', 52);

2066:
2067: --
2068: IF g_debug
2069: THEN
2070: hr_utility.set_location ('Before Person Header', 52);
2071: END IF;
2072:
2073: --
2074: ben_manage_life_events.person_header

Line 2086: hr_utility.set_location ('After Person Header', 52);

2082:
2083: --
2084: IF g_debug
2085: THEN
2086: hr_utility.set_location ('After Person Header', 52);
2087: --
2088: hr_utility.set_location ('Before process comp objects', 55);
2089: --
2090: END IF;

Line 2088: hr_utility.set_location ('Before process comp objects', 55);

2084: IF g_debug
2085: THEN
2086: hr_utility.set_location ('After Person Header', 52);
2087: --
2088: hr_utility.set_location ('Before process comp objects', 55);
2089: --
2090: END IF;
2091:
2092: ben_manage_life_events.process_comp_objects

Line 2112: hr_utility.set_location (temp1 || '-->' || temp2 || '<--', 124);

2108: temp2 := ben_icm_life_events.g_cache_epo_object.COUNT;
2109:
2110: IF g_debug
2111: THEN
2112: hr_utility.set_location (temp1 || '-->' || temp2 || '<--', 124);
2113: END IF;
2114:
2115: --
2116: ROLLBACK TO icm_life_events_savepoint;

Line 2137: hr_utility.set_location ('Leaving ' || l_proc, 30);

2133: --
2134: IF g_debug
2135: THEN
2136: --
2137: hr_utility.set_location ('Leaving ' || l_proc, 30);
2138: --
2139: END IF;
2140: --
2141: EXCEPTION

Line 2147: hr_utility.set_location ('Leaving ' || l_proc, 31);

2143: WHEN app_exception.application_exception
2144: THEN
2145: IF g_debug
2146: THEN
2147: hr_utility.set_location ('Leaving ' || l_proc, 31);
2148: END IF;
2149: --
2150: l_msg := fnd_message.get;
2151: fnd_message.set_name('BEN','BEN_94875_ICD_BENMNGLE_ERROR');

Line 2164: hr_utility.set_location ('Leaving ' || SUBSTR (SQLERRM, 1, 50),

2160: THEN
2161: --
2162: IF g_debug
2163: THEN
2164: hr_utility.set_location ('Leaving ' || SUBSTR (SQLERRM, 1, 50),
2165: 32
2166: );
2167: hr_utility.set_location ('Leaving ' || SUBSTR (SQLERRM, 51, 100),
2168: 32

Line 2167: hr_utility.set_location ('Leaving ' || SUBSTR (SQLERRM, 51, 100),

2163: THEN
2164: hr_utility.set_location ('Leaving ' || SUBSTR (SQLERRM, 1, 50),
2165: 32
2166: );
2167: hr_utility.set_location ('Leaving ' || SUBSTR (SQLERRM, 51, 100),
2168: 32
2169: );
2170: END IF;
2171: l_msg := fnd_message.get;