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

Line 91: and pfl.ler_id <> ben_manage_life_events.g_ler_id

87: -- 9999 Do we need to filter based on effective_date, as all potentials
88: -- need to be processed. Also first void all potentials which are not
89: -- processed and are corrections.
90: --
91: and pfl.ler_id <> ben_manage_life_events.g_ler_id
92: and ler.typ_cd = 'ABS'
93: order by pfl.lf_evt_ocrd_dt asc,
94: decode(ler.lf_evt_oper_cd,'DELETE',3,'START',2,1) desc;
95:

Line 118: and ptn.ler_id <> ben_manage_life_events.g_ler_id

114: and ler.effective_end_date
115: and ler.typ_cd = 'ABS'
116: and ptn.business_group_id = p_business_group_id
117: and ptn.lf_evt_ocrd_dt <= p_effective_date
118: and ptn.ler_id <> ben_manage_life_events.g_ler_id
119: and ptn.ptnl_ler_for_per_stat_cd not in ('PROCD','VOIDD');
120: --
121: cursor c_get_ptnl_for_aba is
122: select ptn.ptnl_ler_for_per_id

Line 203: and pil.ler_id <> ben_manage_life_events.g_ler_id -- 9999 what is this?

199: ben_ler_f ler
200: where pil.business_group_id = p_business_group_id
201: and pil.person_id = p_person_id
202: and pil.lf_evt_ocrd_dt >= p_min_lf_evt_ocrd_dt
203: and pil.ler_id <> ben_manage_life_events.g_ler_id -- 9999 what is this?
204: and pil.ler_id = ler.ler_id
205: and (pil.ler_id = p_ler_id or p_ler_id = -1)
206: and p_effective_date
207: between ler.effective_start_date

Line 398: raise ben_manage_life_events.g_life_event_after;

394: --
395: fnd_message.set_name('BEN','BEN_92536_PERSON_HAS_NO_PPL');
396: fnd_message.set_token('PERSON_ID',p_person_id);
397: fnd_message.set_token('PROC',l_proc);
398: raise ben_manage_life_events.g_life_event_after;
399: --
400: end if;
401: --
402: -- Check any more potential exists for the winner type of absence.

Line 590: raise ben_manage_life_events.g_life_event_after;

586: p_created_ler_id := l_winning_ptnl_rec.ler_id;
587:
588: if not l_create_per_in_ler then
589: hr_utility.set_location('Leaving:'|| l_proc, 10);
590: raise ben_manage_life_events.g_life_event_after;
591: end if;
592:
593:
594: --Start 6086392

Line 632: when ben_manage_life_events.g_life_event_after then

628: hr_utility.set_location('Leaving:'|| l_proc, 10);
629: --
630: -- bug 5987235
631: Exception
632: when ben_manage_life_events.g_life_event_after then
633: hr_utility.set_location('PTNLE Absence eval Exception g_life_event_after', 121);
634: ben_evaluate_ptnl_lf_evt.g_bckdt_pil_tbl.delete;
635: raise ben_manage_life_events.g_life_event_after;
636: when others then

Line 635: raise ben_manage_life_events.g_life_event_after;

631: Exception
632: when ben_manage_life_events.g_life_event_after then
633: hr_utility.set_location('PTNLE Absence eval Exception g_life_event_after', 121);
634: ben_evaluate_ptnl_lf_evt.g_bckdt_pil_tbl.delete;
635: raise ben_manage_life_events.g_life_event_after;
636: when others then
637: hr_utility.set_location('PTNLE Absence eval Exception ', 121);
638: ben_evaluate_ptnl_lf_evt.g_bckdt_pil_tbl.delete;
639: fnd_message.raise_error;

Line 888: raise ben_manage_life_events.g_life_event_after;

884: fnd_message.set_name('BEN','BEN_91797_PTNL_AFTER_ACTIVE');
885: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
886: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',
887: l_pil_rec.lf_evt_ocrd_dt);
888: raise ben_manage_life_events.g_life_event_after;
889: --
890: else
891: --
892: hr_utility.set_location('Case C ',10);

Line 928: raise ben_manage_life_events.g_life_event_after;

924: fnd_message.set_name('BEN','BEN_92864_CWB_PTNL_AFTR_ACTIVE');
925: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
926: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',
927: l_pil_rec.lf_evt_ocrd_dt);
928: raise ben_manage_life_events.g_life_event_after;
929: --
930: --
931: end if;
932: --

Line 978: and pfl.ler_id <> ben_manage_life_events.g_ler_id

974: and p_effective_date
975: between ler.effective_start_date
976: and ler.effective_end_date
977: and pfl.lf_evt_ocrd_dt <= p_effective_date
978: and pfl.ler_id <> ben_manage_life_events.g_ler_id
979: and ler.typ_cd = 'GSP'
980: order by pfl.lf_evt_ocrd_dt asc;
981: --
982: -- GSP Rate Sync

Line 1003: and pil.ler_id <> ben_manage_life_events.g_ler_id

999: or
1000: (pil.per_in_ler_stat_cd = 'PROCD'
1001: and pil.lf_evt_ocrd_dt >= p_lf_evt_ocrd_dt)
1002: )
1003: and pil.ler_id <> ben_manage_life_events.g_ler_id
1004: and pil.ler_id = ler.ler_id
1005: and p_effective_date
1006: between ler.effective_start_date
1007: and ler.effective_end_date

Line 1061: raise ben_manage_life_events.g_life_event_after;

1057: -- For BENAUTHE retreival purpose.
1058: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
1059: fnd_message.set_token('LE_NAME',l_potent.name);
1060: fnd_message.set_token('PROC',l_proc);
1061: raise ben_manage_life_events.g_life_event_after;
1062: --
1063: end if;
1064: --
1065: end loop;

Line 1089: raise ben_manage_life_events.g_life_event_after;

1085: --
1086: fnd_message.set_name('BEN','BEN_92536_PERSON_HAS_NO_PPL');
1087: fnd_message.set_token('PERSON_ID',p_person_id);
1088: fnd_message.set_token('PROC',l_proc);
1089: raise ben_manage_life_events.g_life_event_after;
1090: --
1091: end if;
1092: --
1093: open get_gs_proc_strt_le(l_min_ptnl.lf_evt_ocrd_dt);

Line 1132: raise ben_manage_life_events.g_life_event_after;

1128: fnd_message.set_name('BEN','BEN_91797_PTNL_AFTER_ACTIVE');
1129: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',l_min_ptnl.lf_evt_ocrd_dt);
1130: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',
1131: l_pil_rec.lf_evt_ocrd_dt);
1132: raise ben_manage_life_events.g_life_event_after;
1133: --
1134: elsif l_pil_rec.per_in_ler_stat_cd = 'PROCD' then
1135: --
1136: -- 99999 check the messages above and here.

Line 1170: raise ben_manage_life_events.g_life_event_after;

1166: -- For BENAUTHE retreival purpose.
1167: fnd_message.set_name('BEN','BEN_94092_PTNL_BEFORE_PROCD');
1168: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',l_min_ptnl.lf_evt_ocrd_dt);
1169: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',l_pil_rec.lf_evt_ocrd_dt);
1170: raise ben_manage_life_events.g_life_event_after;
1171: --
1172: else
1173: --
1174: -- GSP Rate Sync

Line 1192: raise ben_manage_life_events.g_life_event_after;

1188: fnd_message.set_name('BEN','BEN_94091_NO_GSP_PROG_PROCD');
1189: benutils.write(fnd_message.get);
1190: --
1191: fnd_message.set_name('BEN','BEN_94091_NO_GSP_PROG_PROCD');
1192: raise ben_manage_life_events.g_life_event_after;
1193: --
1194: end if;
1195: --
1196: close c_gsp_prog_procd_exists;

Line 1310: and pfl.ler_id <> ben_manage_life_events.g_ler_id

1306: and pfl.lf_evt_ocrd_dt <= decode(p_mode,
1307: 'C',
1308: pfl.lf_evt_ocrd_dt,
1309: p_effective_date)
1310: and pfl.ler_id <> ben_manage_life_events.g_ler_id
1311: --
1312: -- CWB Changes
1313: --
1314: and ler.typ_cd not in ( 'COMP', 'ABS', 'GSP', 'IREC') -- iRec

Line 1332: and pil.ler_id <> ben_manage_life_events.g_ler_id

1328: where pil.person_id = p_person_id
1329: and pil.per_in_ler_stat_cd in ('STRTD','PROCD')
1330: and pil.lf_evt_ocrd_dt >= p_lf_evt_ocrd_dt
1331: and pil.per_in_ler_id <> p_curr_per_in_ler_id
1332: and pil.ler_id <> ben_manage_life_events.g_ler_id
1333: --
1334: -- CWB Changes
1335: --
1336: and pil.ler_id = ler.ler_id

Line 1370: and pil.ler_id <> ben_manage_life_events.g_ler_id

1366: from ben_per_in_ler pil,
1367: ben_ler_f ler
1368: where pil.person_id = p_person_id
1369: and pil.per_in_ler_stat_cd = 'STRTD'
1370: and pil.ler_id <> ben_manage_life_events.g_ler_id
1371: and pil.ler_id = ler.ler_id
1372: and cv_lf_evt_ocrd_dt
1373: between ler.effective_start_date
1374: and ler.effective_end_date

Line 1395: and pil.ler_id <> ben_manage_life_events.g_ler_id

1391: ben_ler_f ler
1392: where pil.person_id = p_person_id
1393: and pil.per_in_ler_stat_cd = 'PROCD'
1394: and pil.lf_evt_ocrd_dt >= cv_lf_evt_ocrd_dt
1395: and pil.ler_id <> ben_manage_life_events.g_ler_id
1396: and pil.ler_id = ler.ler_id
1397: -- GRADE/STEP
1398: and ler.typ_cd not in ( 'COMP', 'ABS', 'GSP', 'IREC')-- iRec
1399: and cv_lf_evt_ocrd_dt

Line 1430: and pil.ler_id <> ben_manage_life_events.g_ler_id

1426: from ben_per_in_ler pil,
1427: ben_ler_f ler
1428: where pil.person_id = p_person_id
1429: and pil.per_in_ler_stat_cd in ( 'PROCD', 'STRTD')
1430: and pil.ler_id <> ben_manage_life_events.g_ler_id
1431: and pil.lf_evt_ocrd_dt = cv_lf_evt_ocrd_dt
1432: and pil.ler_id = ler.ler_id
1433: and cv_lf_evt_ocrd_dt
1434: between ler.effective_start_date

Line 1665: and ptn.ler_id <> ben_manage_life_events.g_ler_id

1661: between ler.effective_start_date
1662: and ler.effective_end_date
1663: and ptn.business_group_id = ler.business_group_id
1664: and ptn.person_id = p_person_id
1665: and ptn.ler_id <> ben_manage_life_events.g_ler_id
1666: -- CWB Changes
1667: and ler.typ_cd not in ( 'COMP', 'ABS', 'GSP','IREC') --iRec
1668: and ptn.lf_evt_ocrd_dt <= decode(ler.typ_cd, --Bug 5703825
1669: 'SCHEDDO',

Line 1987: raise ben_manage_life_events.g_record_error;

1983: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
1984: fnd_message.set_token('RL',
1985: 'tmlns_perd_rl :'||l_potent.tmlns_perd_rl);
1986: fnd_message.set_token('PROC',l_proc);
1987: raise ben_manage_life_events.g_record_error;
1988: --
1989: end if;
1990: --
1991: end if;

Line 2153: raise ben_manage_life_events.g_record_error;

2149: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');
2150: fnd_message.set_token('RL',
2151: 'tmlns_perd_rl :'||l_potent.tmlns_perd_rl);
2152: fnd_message.set_token('PROC',l_proc);
2153: raise ben_manage_life_events.g_record_error;
2154: --
2155: end if;
2156: --
2157: end if;

Line 2194: raise ben_manage_life_events.g_life_event_after;

2190: -- a message back to the user.
2191: --
2192: ben_on_line_lf_evt.g_ptnls_voidd_flag := TRUE;
2193: --
2194: raise ben_manage_life_events.g_life_event_after;
2195: --
2196: elsif l_npv_ptnl_cnt <> 0 and l_curr_voidd_ptnl_cnt <> 0 and
2197: l_curr_voidd_ptnl_cnt <> l_npv_ptnl_cnt then
2198: --

Line 2219: raise ben_manage_life_events.g_life_event_after;

2215: --
2216: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
2217: fnd_message.set_token('LE_NAME',l_mnl_ler_name);
2218: fnd_message.set_token('PROC',l_proc);
2219: raise ben_manage_life_events.g_life_event_after;
2220: --
2221: end if;
2222: --
2223: hr_utility.set_location('Leaving:'|| l_proc, 10);

Line 2295: and ptn.ler_id <> ben_manage_life_events.g_ler_id

2291: ptn.lf_evt_ocrd_dt,
2292: 'SCHEDDA',
2293: ptn.lf_evt_ocrd_dt,
2294: p_effective_date)
2295: and ptn.ler_id <> ben_manage_life_events.g_ler_id
2296: and ptn.ptnl_ler_for_per_stat_cd not in ('PROCD','VOIDD');
2297:
2298: cursor c_ler(p_ler_id number) is
2299: SELECT name

Line 2348: raise ben_manage_life_events.g_life_event_after;

2344: fnd_message.set_token('CURRENT_LE',l_current_ler);
2345: fnd_message.set_token('NEW_LE',l_new_ler);
2346: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
2347: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2348: raise ben_manage_life_events.g_life_event_after;
2349: --
2350: end if;
2351: --
2352: close c1;

Line 2714: and ppl.ler_id <> ben_manage_life_events.g_ler_id

2710: and ppl.business_group_id = p_business_group_id
2711: and ppl.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
2712: and ler.business_group_id = ppl.business_group_id
2713: and ppl.ptnl_ler_for_per_stat_cd not in ('VOIDD')
2714: and ppl.ler_id <> ben_manage_life_events.g_ler_id
2715: --
2716: -- CWB Changes
2717: --
2718: and ler.typ_cd not in ( 'COMP', 'ABS', 'GSP', 'IREC') --iRec

Line 2753: and ppl.ler_id <> ben_manage_life_events.g_ler_id

2749: ben_ler_f ler
2750: where ppl.person_id = p_person_id
2751: and ppl.business_group_id = p_business_group_id
2752: and ppl.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
2753: and ppl.ler_id <> ben_manage_life_events.g_ler_id
2754: and ppl.ler_id = ler.ler_id
2755: and p_effective_date
2756: between ler.effective_start_date
2757: and ler.effective_end_date

Line 2782: and pil.ler_id <> ben_manage_life_events.g_ler_id))

2778: where pil.business_group_id = p_business_group_id
2779: and pil.person_id = p_person_id
2780: and (pil.lf_evt_ocrd_dt > p_lf_evt_ocrd_dt -- 5727737/5677090: Need to backout all Future LEs
2781: or (pil.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
2782: and pil.ler_id <> ben_manage_life_events.g_ler_id))
2783: and pil.ler_id = ler.ler_id
2784: and p_effective_date
2785: between ler.effective_start_date
2786: and ler.effective_end_date

Line 2869: ben_manage_life_events.g_rec.rep_typ_cd := 'ERROR';

2865: --
2866: -- More than one winner so return an error
2867: --
2868: fnd_message.set_name('BEN','BEN_91794_DUP_WINNERS');
2869: ben_manage_life_events.g_rec.rep_typ_cd := 'ERROR';
2870: ben_manage_life_events.g_rec.person_id := p_person_id;
2871: ben_manage_life_events.g_rec.ler_id := null;
2872: ben_manage_life_events.g_rec.error_message_code := 'BEN_91794_DUP_WINNERS';
2873: ben_manage_life_events.g_rec.text := fnd_message.get;

Line 2870: ben_manage_life_events.g_rec.person_id := p_person_id;

2866: -- More than one winner so return an error
2867: --
2868: fnd_message.set_name('BEN','BEN_91794_DUP_WINNERS');
2869: ben_manage_life_events.g_rec.rep_typ_cd := 'ERROR';
2870: ben_manage_life_events.g_rec.person_id := p_person_id;
2871: ben_manage_life_events.g_rec.ler_id := null;
2872: ben_manage_life_events.g_rec.error_message_code := 'BEN_91794_DUP_WINNERS';
2873: ben_manage_life_events.g_rec.text := fnd_message.get;
2874: fnd_message.set_name('BEN','BEN_91794_DUP_WINNERS');

Line 2871: ben_manage_life_events.g_rec.ler_id := null;

2867: --
2868: fnd_message.set_name('BEN','BEN_91794_DUP_WINNERS');
2869: ben_manage_life_events.g_rec.rep_typ_cd := 'ERROR';
2870: ben_manage_life_events.g_rec.person_id := p_person_id;
2871: ben_manage_life_events.g_rec.ler_id := null;
2872: ben_manage_life_events.g_rec.error_message_code := 'BEN_91794_DUP_WINNERS';
2873: ben_manage_life_events.g_rec.text := fnd_message.get;
2874: fnd_message.set_name('BEN','BEN_91794_DUP_WINNERS');
2875: fnd_message.set_token('PROC',l_proc);

Line 2872: ben_manage_life_events.g_rec.error_message_code := 'BEN_91794_DUP_WINNERS';

2868: fnd_message.set_name('BEN','BEN_91794_DUP_WINNERS');
2869: ben_manage_life_events.g_rec.rep_typ_cd := 'ERROR';
2870: ben_manage_life_events.g_rec.person_id := p_person_id;
2871: ben_manage_life_events.g_rec.ler_id := null;
2872: ben_manage_life_events.g_rec.error_message_code := 'BEN_91794_DUP_WINNERS';
2873: ben_manage_life_events.g_rec.text := fnd_message.get;
2874: fnd_message.set_name('BEN','BEN_91794_DUP_WINNERS');
2875: fnd_message.set_token('PROC',l_proc);
2876: fnd_message.set_token('PERSON_ID',p_person_id);

Line 2873: ben_manage_life_events.g_rec.text := fnd_message.get;

2869: ben_manage_life_events.g_rec.rep_typ_cd := 'ERROR';
2870: ben_manage_life_events.g_rec.person_id := p_person_id;
2871: ben_manage_life_events.g_rec.ler_id := null;
2872: ben_manage_life_events.g_rec.error_message_code := 'BEN_91794_DUP_WINNERS';
2873: ben_manage_life_events.g_rec.text := fnd_message.get;
2874: fnd_message.set_name('BEN','BEN_91794_DUP_WINNERS');
2875: fnd_message.set_token('PROC',l_proc);
2876: fnd_message.set_token('PERSON_ID',p_person_id);
2877: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

Line 2878: raise ben_manage_life_events.g_record_error;

2874: fnd_message.set_name('BEN','BEN_91794_DUP_WINNERS');
2875: fnd_message.set_token('PROC',l_proc);
2876: fnd_message.set_token('PERSON_ID',p_person_id);
2877: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
2878: raise ben_manage_life_events.g_record_error;
2879: --
2880: -- No winners, but more than one potential?
2881: --
2882: elsif l_num_winners = 0 and

Line 2887: ben_manage_life_events.g_rec.rep_typ_cd := 'ERROR';

2883: l_num_recs > 1 then
2884: --
2885: -- Potential life events clash, so error.
2886: --
2887: ben_manage_life_events.g_rec.rep_typ_cd := 'ERROR';
2888: ben_manage_life_events.g_rec.person_id := p_person_id;
2889: ben_manage_life_events.g_rec.ler_id := null;
2890: ben_manage_life_events.g_rec.error_message_code := 'BEN_92337_DUPLICATE_PTNL_LE';
2891: ben_manage_life_events.g_rec.text := fnd_message.get;

Line 2888: ben_manage_life_events.g_rec.person_id := p_person_id;

2884: --
2885: -- Potential life events clash, so error.
2886: --
2887: ben_manage_life_events.g_rec.rep_typ_cd := 'ERROR';
2888: ben_manage_life_events.g_rec.person_id := p_person_id;
2889: ben_manage_life_events.g_rec.ler_id := null;
2890: ben_manage_life_events.g_rec.error_message_code := 'BEN_92337_DUPLICATE_PTNL_LE';
2891: ben_manage_life_events.g_rec.text := fnd_message.get;
2892: fnd_message.set_name('BEN','BEN_92337_DUPLICATE_PTNL_LE');

Line 2889: ben_manage_life_events.g_rec.ler_id := null;

2885: -- Potential life events clash, so error.
2886: --
2887: ben_manage_life_events.g_rec.rep_typ_cd := 'ERROR';
2888: ben_manage_life_events.g_rec.person_id := p_person_id;
2889: ben_manage_life_events.g_rec.ler_id := null;
2890: ben_manage_life_events.g_rec.error_message_code := 'BEN_92337_DUPLICATE_PTNL_LE';
2891: ben_manage_life_events.g_rec.text := fnd_message.get;
2892: fnd_message.set_name('BEN','BEN_92337_DUPLICATE_PTNL_LE');
2893: fnd_message.set_token('PROC',l_proc);

Line 2890: ben_manage_life_events.g_rec.error_message_code := 'BEN_92337_DUPLICATE_PTNL_LE';

2886: --
2887: ben_manage_life_events.g_rec.rep_typ_cd := 'ERROR';
2888: ben_manage_life_events.g_rec.person_id := p_person_id;
2889: ben_manage_life_events.g_rec.ler_id := null;
2890: ben_manage_life_events.g_rec.error_message_code := 'BEN_92337_DUPLICATE_PTNL_LE';
2891: ben_manage_life_events.g_rec.text := fnd_message.get;
2892: fnd_message.set_name('BEN','BEN_92337_DUPLICATE_PTNL_LE');
2893: fnd_message.set_token('PROC',l_proc);
2894: fnd_message.set_token('PERSON_ID',p_person_id);

Line 2891: ben_manage_life_events.g_rec.text := fnd_message.get;

2887: ben_manage_life_events.g_rec.rep_typ_cd := 'ERROR';
2888: ben_manage_life_events.g_rec.person_id := p_person_id;
2889: ben_manage_life_events.g_rec.ler_id := null;
2890: ben_manage_life_events.g_rec.error_message_code := 'BEN_92337_DUPLICATE_PTNL_LE';
2891: ben_manage_life_events.g_rec.text := fnd_message.get;
2892: fnd_message.set_name('BEN','BEN_92337_DUPLICATE_PTNL_LE');
2893: fnd_message.set_token('PROC',l_proc);
2894: fnd_message.set_token('PERSON_ID',p_person_id);
2895: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

Line 2896: raise ben_manage_life_events.g_record_error;

2892: fnd_message.set_name('BEN','BEN_92337_DUPLICATE_PTNL_LE');
2893: fnd_message.set_token('PROC',l_proc);
2894: fnd_message.set_token('PERSON_ID',p_person_id);
2895: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
2896: raise ben_manage_life_events.g_record_error;
2897: --
2898: elsif l_num_winners = 1 then
2899: --
2900: l_search_ptnl_ler_for_per_id := l_win_ptnl_ler_for_per_id;

Line 2949: raise ben_manage_life_events.g_record_error;

2945: fnd_message.set_name('BEN','BEN_92144_NO_LIFE_EVENTS');
2946: fnd_message.set_token('PROC',l_proc);
2947: fnd_message.set_token('PERSON_ID',p_person_id);
2948: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
2949: raise ben_manage_life_events.g_record_error;
2950: --
2951: end if;
2952: --
2953: open c2;

Line 2978: raise ben_manage_life_events.g_life_event_after;

2974: -- For BENAUTHE retreival purpose.
2975: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
2976: fnd_message.set_token('LE_NAME',l_win_ler_name);
2977: fnd_message.set_token('PROC',l_proc);
2978: raise ben_manage_life_events.g_life_event_after;
2979: --
2980: end if;
2981: --
2982: close c2;

Line 3017: and ptn.ler_id <> ben_manage_life_events.g_ler_id

3013: ptn.lf_evt_ocrd_dt,
3014: 'SCHEDDA',
3015: ptn.lf_evt_ocrd_dt,
3016: p_effective_date)
3017: and ptn.ler_id <> ben_manage_life_events.g_ler_id
3018: and ptn.ptnl_ler_for_per_stat_cd not in ('PROCD','VOIDD');
3019: --
3020: -- CWB Changes End
3021: --

Line 3048: raise ben_manage_life_events.g_life_event_after;

3044: fnd_message.set_name('BEN','BEN_92144_NO_LIFE_EVENTS');
3045: fnd_message.set_token('PROC',l_proc);
3046: fnd_message.set_token('PERSON_ID',p_person_id);
3047: fnd_message.set_token('LF_EVT_OCRD_DT',l_min_lf_evt_ocrd_dt);
3048: raise ben_manage_life_events.g_life_event_after;
3049: --
3050: end if;
3051: --
3052: close c1;

Line 3103: raise ben_manage_life_events.g_life_event_after;

3099: -- For BENAUTHE retreival purpose.
3100: fnd_message.set_name('BEN','BEN_94209_MAN_LER_EXISTIS');
3101: -- fnd_message.set_token('LE_NAME',l_potent.name);
3102: -- fnd_message.set_token('PROC',l_proc);
3103: raise ben_manage_life_events.g_life_event_after;
3104: --
3105: end if;
3106: --
3107: -- If there is a rule attached lets evaluate it and handle the returned

Line 3159: raise ben_manage_life_events.g_life_event_after;

3155: --
3156: fnd_message.set_name('BEN','BEN_92536_PERSON_HAS_NO_PPL');
3157: fnd_message.set_token('PERSON_ID',p_person_id);
3158: fnd_message.set_token('PROC',l_proc);
3159: raise ben_manage_life_events.g_life_event_after;
3160: --
3161: end if;
3162: --
3163: -- Now we have manipulated all potentials, check whether the remaining

Line 3259: raise ben_manage_life_events.g_record_error;

3255: --
3256: fnd_message.set_name('BEN','BEN_92145_MODE_LE_DIFFER');
3257: fnd_message.set_token('MODE',l_use_mode);
3258: --
3259: raise ben_manage_life_events.g_record_error;
3260: --
3261: end if;
3262: --
3263: -- Bug 4872042

Line 3409: raise ben_manage_life_events.g_life_event_after;

3405: g_rec.business_group_id := p_business_group_id;
3406: g_rec.effective_date := p_effective_date;
3407: benutils.write(p_rec => g_rec);
3408: --
3409: raise ben_manage_life_events.g_life_event_after;
3410: --
3411: end if;
3412: --
3413: close c_check_deadlock_pil;

Line 3513: raise ben_manage_life_events.g_life_event_after;

3509: fnd_message.set_name('BEN','BEN_91797_PTNL_AFTER_ACTIVE');
3510: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',l_ptnl_rec.lf_evt_ocrd_dt);
3511: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',
3512: l_current_per_in_ler.lf_evt_ocrd_dt);
3513: raise ben_manage_life_events.g_life_event_after;
3514: --
3515: end if;
3516: --
3517:

Line 3691: raise ben_manage_life_events.g_life_event_after;

3687: -- For BENAUTHE retreival purpose.
3688: --
3689: fnd_message.set_name('BEN','BEN_94025_IREC_OFFER_PROCESSED');
3690: benutils.write(p_text => fnd_message.get);
3691: raise ben_manage_life_events.g_life_event_after;
3692: --
3693: elsif l_pil_rec.per_in_ler_id is not null and
3694: l_pil_rec.per_in_ler_stat_cd = 'STRTD' then
3695: --