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 213: if ben_manage_life_events.fonm = 'Y' then

209: -- then set the g_elig_change_dt to effective_date -1
210: --
211: if (p_elig_change_dt <= p_effective_date) then
212: /* Bug 8856039: Even in FONM setup, the coverage end date should be based on life event occurred date */
213: if ben_manage_life_events.fonm = 'Y' then
214: hr_utility.set_location ('fonm case: g_effective_date '||g_effective_date,11);
215: g_elig_change_dt := g_effective_date - 1; -- life event occurred date - 1
216: else
217: g_elig_change_dt := p_elig_change_dt;

Line 651: if ben_manage_life_events.fonm = 'Y'

647: g_dpnt_cvg_strt_dt := p_dpnt_cvg_strt_dt;
648: g_effective_date := nvl(p_lf_evt_ocrd_dt, p_effective_date);
649: -- fonm
650: l_effective_date := nvl(p_lf_evt_ocrd_dt, p_effective_date);
651: if ben_manage_life_events.fonm = 'Y'
652: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
653: --
654: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
655: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;

Line 652: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

648: g_effective_date := nvl(p_lf_evt_ocrd_dt, p_effective_date);
649: -- fonm
650: l_effective_date := nvl(p_lf_evt_ocrd_dt, p_effective_date);
651: if ben_manage_life_events.fonm = 'Y'
652: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
653: --
654: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
655: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
656:

Line 654: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;

650: l_effective_date := nvl(p_lf_evt_ocrd_dt, p_effective_date);
651: if ben_manage_life_events.fonm = 'Y'
652: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
653: --
654: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
655: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
656:
657: --
658: hr_utility.set_location ('Fonm Date '||g_effective_date ,10);

Line 907: raise ben_manage_life_events.g_record_error;

903: hr_utility.set_location ('BEN_91482_INVALID_ADDRESS ',10);
904: fnd_message.set_name('BEN','BEN_91482_INVALID_ADDRESS');
905: fnd_message.set_token('PROC',l_proc);
906: fnd_message.set_token('CONT_PER_ID',to_char(p_contact_person_id));
907: raise ben_manage_life_events.g_record_error;
908: --
909: elsif c_add%notfound and
910: l_contact.rltd_per_rsds_w_dsgntr_flag='Y' then
911: --

Line 922: raise ben_manage_life_events.g_record_error;

918: hr_utility.set_location ('BEN_91482_INVALID_ADDRESS - c_add2 ',10);
919: fnd_message.set_name('BEN','BEN_91482_INVALID_ADDRESS');
920: fnd_message.set_token('PROC',l_proc);
921: fnd_message.set_token('CONT_PER_ID',to_char(l_contact.person_id));
922: raise ben_manage_life_events.g_record_error;
923: --
924: end if;
925: --
926: close c_add2;

Line 1315: --raise ben_manage_life_events.g_record_error;

1311: hr_utility.set_location ('contact '|| l_contact.rltd_per_rsds_w_dsgntr_flag ,10);
1312: --fnd_message.set_name('BEN','BEN_91482_INVALID_ADDRESS');
1313: --fnd_message.set_token('PROC',l_proc);
1314: --fnd_message.set_token('CONT_PER_ID',to_char(p_contact_person_id));
1315: --raise ben_manage_life_events.g_record_error;
1316:
1317: elsif c_add%notfound and l_contact.rltd_per_rsds_w_dsgntr_flag='Y' then
1318: --
1319: open c_add2

Line 1331: --raise ben_manage_life_events.g_record_error;

1327: hr_utility.set_location ('BEN_91482_INVALID_ADDRESS - c_add2 ',10);
1328: --fnd_message.set_name('BEN','BEN_91482_INVALID_ADDRESS');
1329: --fnd_message.set_token('PROC',l_proc);
1330: --fnd_message.set_token('CONT_PER_ID',to_char(l_contact.person_id));
1331: --raise ben_manage_life_events.g_record_error;
1332: --
1333: end if;
1334: --
1335: close c_add2;

Line 1681: if ben_manage_life_events.fonm = 'Y'

1677: --
1678:
1679: -- fonm
1680: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
1681: if ben_manage_life_events.fonm = 'Y'
1682: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
1683: --
1684: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
1685: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;

Line 1682: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

1678:
1679: -- fonm
1680: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
1681: if ben_manage_life_events.fonm = 'Y'
1682: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
1683: --
1684: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
1685: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
1686:

Line 1684: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;

1680: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
1681: if ben_manage_life_events.fonm = 'Y'
1682: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
1683: --
1684: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
1685: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
1686:
1687: --
1688: hr_utility.set_location ('Fonm Date '||l_effective_date ,10);

Line 1925: if ben_manage_life_events.fonm = 'Y'

1921: --
1922:
1923: -- fonm
1924: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
1925: if ben_manage_life_events.fonm = 'Y'
1926: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
1927: --
1928: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
1929: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;

Line 1926: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

1922:
1923: -- fonm
1924: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
1925: if ben_manage_life_events.fonm = 'Y'
1926: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
1927: --
1928: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
1929: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
1930:

Line 1928: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;

1924: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
1925: if ben_manage_life_events.fonm = 'Y'
1926: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
1927: --
1928: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
1929: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
1930:
1931: --
1932: hr_utility.set_location ('Fonm Date '||l_effective_date ,10);

Line 2009: if ben_manage_life_events.fonm = 'Y'

2005: hr_utility.set_location('Entering: '||l_proc,10);
2006: --
2007: -- fonm
2008: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2009: if ben_manage_life_events.fonm = 'Y'
2010: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2011: --
2012: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2013: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;

Line 2010: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

2006: --
2007: -- fonm
2008: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2009: if ben_manage_life_events.fonm = 'Y'
2010: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2011: --
2012: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2013: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
2014:

Line 2012: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;

2008: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2009: if ben_manage_life_events.fonm = 'Y'
2010: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2011: --
2012: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2013: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
2014:
2015: --
2016: hr_utility.set_location ('Fonm Date '||l_effective_date ,10);

Line 2093: if ben_manage_life_events.fonm = 'Y'

2089: hr_utility.set_location('Entering: '||l_proc,10);
2090: --
2091: -- fonm
2092: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2093: if ben_manage_life_events.fonm = 'Y'
2094: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2095: --
2096: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2097: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;

Line 2094: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

2090: --
2091: -- fonm
2092: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2093: if ben_manage_life_events.fonm = 'Y'
2094: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2095: --
2096: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2097: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
2098:

Line 2096: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;

2092: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2093: if ben_manage_life_events.fonm = 'Y'
2094: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2095: --
2096: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2097: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
2098:
2099: --
2100: hr_utility.set_location ('Fonm Date '||l_effective_date ,10);

Line 2190: if ben_manage_life_events.fonm = 'Y'

2186: hr_utility.set_location('Entering: '||l_proc,10);
2187: --
2188: -- fonm
2189: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2190: if ben_manage_life_events.fonm = 'Y'
2191: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2192: --
2193: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2194: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;

Line 2191: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

2187: --
2188: -- fonm
2189: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2190: if ben_manage_life_events.fonm = 'Y'
2191: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2192: --
2193: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2194: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
2195:

Line 2193: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;

2189: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2190: if ben_manage_life_events.fonm = 'Y'
2191: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2192: --
2193: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2194: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
2195:
2196: --
2197: hr_utility.set_location ('Fonm Date '||l_effective_date ,10);

Line 2283: if ben_manage_life_events.fonm = 'Y'

2279:
2280: --
2281: -- fonm
2282: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2283: if ben_manage_life_events.fonm = 'Y'
2284: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2285: --
2286: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2287: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;

Line 2284: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

2280: --
2281: -- fonm
2282: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2283: if ben_manage_life_events.fonm = 'Y'
2284: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2285: --
2286: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2287: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
2288:

Line 2286: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;

2282: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2283: if ben_manage_life_events.fonm = 'Y'
2284: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2285: --
2286: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2287: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
2288:
2289: --
2290: hr_utility.set_location ('Fonm Date '||l_effective_date ,10);

Line 2378: if ben_manage_life_events.fonm = 'Y'

2374: hr_utility.set_location('Entering : '||l_proc,10);
2375: --
2376: -- fonm
2377: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2378: if ben_manage_life_events.fonm = 'Y'
2379: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2380: --
2381: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2382: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;

Line 2379: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

2375: --
2376: -- fonm
2377: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2378: if ben_manage_life_events.fonm = 'Y'
2379: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2380: --
2381: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2382: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
2383:

Line 2381: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;

2377: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2378: if ben_manage_life_events.fonm = 'Y'
2379: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2380: --
2381: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2382: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
2383:
2384: --
2385: hr_utility.set_location ('Fonm Date '||l_effective_date ,10);

Line 2519: if ben_manage_life_events.fonm = 'Y'

2515: hr_utility.set_location('Entering: '||l_proc,10);
2516: --
2517: -- fonm
2518: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2519: if ben_manage_life_events.fonm = 'Y'
2520: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2521: --
2522: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2523: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;

Line 2520: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

2516: --
2517: -- fonm
2518: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2519: if ben_manage_life_events.fonm = 'Y'
2520: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2521: --
2522: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2523: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
2524:

Line 2522: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;

2518: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2519: if ben_manage_life_events.fonm = 'Y'
2520: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2521: --
2522: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2523: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
2524:
2525: --
2526: hr_utility.set_location ('Fonm Date '||l_effective_date ,10);

Line 2648: if ben_manage_life_events.fonm = 'Y'

2644: hr_utility.set_location('dsgntr_id: '||p_dsgntr_id,10);
2645: --
2646: -- fonm
2647: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2648: if ben_manage_life_events.fonm = 'Y'
2649: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2650: --
2651: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2652: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;

Line 2649: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then

2645: --
2646: -- fonm
2647: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2648: if ben_manage_life_events.fonm = 'Y'
2649: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2650: --
2651: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2652: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
2653:

Line 2651: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;

2647: l_effective_date := nvl(p_lf_evt_ocrd_dt,p_effective_date ) ;
2648: if ben_manage_life_events.fonm = 'Y'
2649: and ben_manage_life_events.g_fonm_cvg_strt_dt is not null then
2650: --
2651: l_fonm_cvg_strt_dt := ben_manage_life_events.g_fonm_cvg_strt_dt ;
2652: l_effective_date := nvl(l_fonm_cvg_strt_dt,l_effective_date ) ;
2653:
2654: --
2655: hr_utility.set_location ('Fonm Date '||l_effective_date ,10);