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_EVALUATE_DPNT_ELG_PROFILES dependencies on BEN_MANAGE_LIFE_EVENTS

Line 643: if ben_manage_life_events.fonm = 'Y'

639: g_dpnt_cvg_strt_dt := p_dpnt_cvg_strt_dt;
640: g_effective_date := nvl(p_lf_evt_ocrd_dt, p_effective_date);
641: -- fonm
642: l_effective_date := nvl(p_lf_evt_ocrd_dt, p_effective_date);
643: if ben_manage_life_events.fonm = 'Y'
644: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
645: --
646: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
647: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;

Line 644: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

640: g_effective_date := nvl(p_lf_evt_ocrd_dt, p_effective_date);
641: -- fonm
642: l_effective_date := nvl(p_lf_evt_ocrd_dt, p_effective_date);
643: if ben_manage_life_events.fonm = 'Y'
644: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
645: --
646: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
647: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
648:

Line 646: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;

642: l_effective_date := nvl(p_lf_evt_ocrd_dt, p_effective_date);
643: if ben_manage_life_events.fonm = 'Y'
644: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
645: --
646: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
647: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
648:
649: --
650: hr_utility.set_location ('Fonm Date '||g_effective_date ,10);

Line 899: raise ben_manage_life_events.g_record_error;

895: hr_utility.set_location ('BEN_91482_INVALID_ADDRESS ',10);
896: fnd_message.set_name('BEN','BEN_91482_INVALID_ADDRESS');
897: fnd_message.set_token('PROC',l_proc);
898: fnd_message.set_token('CONT_PER_ID',to_char(p_contact_person_id));
899: raise ben_manage_life_events.g_record_error;
900: --
901: elsif c_add%notfound and
902: l_contact.rltd_per_rsds_w_dsgntr_flag='Y' then
903: --

Line 914: raise ben_manage_life_events.g_record_error;

910: hr_utility.set_location ('BEN_91482_INVALID_ADDRESS - c_add2 ',10);
911: fnd_message.set_name('BEN','BEN_91482_INVALID_ADDRESS');
912: fnd_message.set_token('PROC',l_proc);
913: fnd_message.set_token('CONT_PER_ID',to_char(l_contact.person_id));
914: raise ben_manage_life_events.g_record_error;
915: --
916: end if;
917: --
918: close c_add2;

Line 1307: --raise ben_manage_life_events.g_record_error;

1303: hr_utility.set_location ('contact '|| l_contact.rltd_per_rsds_w_dsgntr_flag ,10);
1304: --fnd_message.set_name('BEN','BEN_91482_INVALID_ADDRESS');
1305: --fnd_message.set_token('PROC',l_proc);
1306: --fnd_message.set_token('CONT_PER_ID',to_char(p_contact_person_id));
1307: --raise ben_manage_life_events.g_record_error;
1308:
1309: elsif c_add%notfound and l_contact.rltd_per_rsds_w_dsgntr_flag='Y' then
1310: --
1311: open c_add2

Line 1323: --raise ben_manage_life_events.g_record_error;

1319: hr_utility.set_location ('BEN_91482_INVALID_ADDRESS - c_add2 ',10);
1320: --fnd_message.set_name('BEN','BEN_91482_INVALID_ADDRESS');
1321: --fnd_message.set_token('PROC',l_proc);
1322: --fnd_message.set_token('CONT_PER_ID',to_char(l_contact.person_id));
1323: --raise ben_manage_life_events.g_record_error;
1324: --
1325: end if;
1326: --
1327: close c_add2;

Line 1648: if ben_manage_life_events.fonm = 'Y'

1644: --
1645:
1646: -- fonm
1647: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
1648: if ben_manage_life_events.fonm = 'Y'
1649: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
1650: --
1651: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
1652: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;

Line 1649: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

1645:
1646: -- fonm
1647: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
1648: if ben_manage_life_events.fonm = 'Y'
1649: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
1650: --
1651: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
1652: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
1653:

Line 1651: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;

1647: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
1648: if ben_manage_life_events.fonm = 'Y'
1649: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
1650: --
1651: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
1652: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
1653:
1654: --
1655: hr_utility.set_location ('Fonm Date '||l_effective_date ,10);

Line 1892: if ben_manage_life_events.fonm = 'Y'

1888: --
1889:
1890: -- fonm
1891: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
1892: if ben_manage_life_events.fonm = 'Y'
1893: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
1894: --
1895: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
1896: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;

Line 1893: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

1889:
1890: -- fonm
1891: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
1892: if ben_manage_life_events.fonm = 'Y'
1893: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
1894: --
1895: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
1896: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
1897:

Line 1895: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;

1891: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
1892: if ben_manage_life_events.fonm = 'Y'
1893: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
1894: --
1895: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
1896: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
1897:
1898: --
1899: hr_utility.set_location ('Fonm Date '||l_effective_date ,10);

Line 1976: if ben_manage_life_events.fonm = 'Y'

1972: hr_utility.set_location('Entering: '||l_proc,10);
1973: --
1974: -- fonm
1975: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
1976: if ben_manage_life_events.fonm = 'Y'
1977: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
1978: --
1979: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
1980: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;

Line 1977: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

1973: --
1974: -- fonm
1975: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
1976: if ben_manage_life_events.fonm = 'Y'
1977: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
1978: --
1979: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
1980: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
1981:

Line 1979: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;

1975: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
1976: if ben_manage_life_events.fonm = 'Y'
1977: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
1978: --
1979: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
1980: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
1981:
1982: --
1983: hr_utility.set_location ('Fonm Date '||l_effective_date ,10);

Line 2060: if ben_manage_life_events.fonm = 'Y'

2056: hr_utility.set_location('Entering: '||l_proc,10);
2057: --
2058: -- fonm
2059: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2060: if ben_manage_life_events.fonm = 'Y'
2061: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2062: --
2063: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2064: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;

Line 2061: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

2057: --
2058: -- fonm
2059: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2060: if ben_manage_life_events.fonm = 'Y'
2061: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2062: --
2063: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2064: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
2065:

Line 2063: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;

2059: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2060: if ben_manage_life_events.fonm = 'Y'
2061: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2062: --
2063: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2064: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
2065:
2066: --
2067: hr_utility.set_location ('Fonm Date '||l_effective_date ,10);

Line 2157: if ben_manage_life_events.fonm = 'Y'

2153: hr_utility.set_location('Entering: '||l_proc,10);
2154: --
2155: -- fonm
2156: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2157: if ben_manage_life_events.fonm = 'Y'
2158: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2159: --
2160: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2161: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;

Line 2158: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

2154: --
2155: -- fonm
2156: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2157: if ben_manage_life_events.fonm = 'Y'
2158: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2159: --
2160: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2161: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
2162:

Line 2160: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;

2156: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2157: if ben_manage_life_events.fonm = 'Y'
2158: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2159: --
2160: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2161: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
2162:
2163: --
2164: hr_utility.set_location ('Fonm Date '||l_effective_date ,10);

Line 2250: if ben_manage_life_events.fonm = 'Y'

2246:
2247: --
2248: -- fonm
2249: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2250: if ben_manage_life_events.fonm = 'Y'
2251: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2252: --
2253: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2254: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;

Line 2251: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

2247: --
2248: -- fonm
2249: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2250: if ben_manage_life_events.fonm = 'Y'
2251: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2252: --
2253: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2254: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
2255:

Line 2253: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;

2249: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2250: if ben_manage_life_events.fonm = 'Y'
2251: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2252: --
2253: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2254: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
2255:
2256: --
2257: hr_utility.set_location ('Fonm Date '||l_effective_date ,10);

Line 2345: if ben_manage_life_events.fonm = 'Y'

2341: hr_utility.set_location('Entering : '||l_proc,10);
2342: --
2343: -- fonm
2344: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2345: if ben_manage_life_events.fonm = 'Y'
2346: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2347: --
2348: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2349: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;

Line 2346: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

2342: --
2343: -- fonm
2344: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2345: if ben_manage_life_events.fonm = 'Y'
2346: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2347: --
2348: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2349: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
2350:

Line 2348: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;

2344: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2345: if ben_manage_life_events.fonm = 'Y'
2346: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2347: --
2348: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2349: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
2350:
2351: --
2352: hr_utility.set_location ('Fonm Date '||l_effective_date ,10);

Line 2486: if ben_manage_life_events.fonm = 'Y'

2482: hr_utility.set_location('Entering: '||l_proc,10);
2483: --
2484: -- fonm
2485: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2486: if ben_manage_life_events.fonm = 'Y'
2487: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2488: --
2489: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2490: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;

Line 2487: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

2483: --
2484: -- fonm
2485: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2486: if ben_manage_life_events.fonm = 'Y'
2487: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2488: --
2489: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2490: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
2491:

Line 2489: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;

2485: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2486: if ben_manage_life_events.fonm = 'Y'
2487: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2488: --
2489: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2490: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
2491:
2492: --
2493: hr_utility.set_location ('Fonm Date '||l_effective_date ,10);

Line 2615: if ben_manage_life_events.fonm = 'Y'

2611: hr_utility.set_location('dsgntr_id: '||p_dsgntr_id,10);
2612: --
2613: -- fonm
2614: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2615: if ben_manage_life_events.fonm = 'Y'
2616: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2617: --
2618: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2619: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;

Line 2616: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

2612: --
2613: -- fonm
2614: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2615: if ben_manage_life_events.fonm = 'Y'
2616: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2617: --
2618: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2619: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
2620:

Line 2618: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;

2614: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2615: if ben_manage_life_events.fonm = 'Y'
2616: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2617: --
2618: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2619: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
2620:
2621: --
2622: hr_utility.set_location ('Fonm Date '||l_effective_date ,10);