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 2584: and ppl.ler_id <> ben_manage_life_events.g_ler_id

2580: and ppl.business_group_id = p_business_group_id
2581: and ppl.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
2582: and ler.business_group_id = ppl.business_group_id
2583: and ppl.ptnl_ler_for_per_stat_cd not in ('VOIDD')
2584: and ppl.ler_id <> ben_manage_life_events.g_ler_id
2585: --
2586: -- CWB Changes
2587: --
2588: and ler.typ_cd not in ( 'COMP', 'ABS', 'GSP', 'IREC') --iRec

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

2619: ben_ler_f ler
2620: where ppl.person_id = p_person_id
2621: and ppl.business_group_id = p_business_group_id
2622: and ppl.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
2623: and ppl.ler_id <> ben_manage_life_events.g_ler_id
2624: and ppl.ler_id = ler.ler_id
2625: and p_effective_date
2626: between ler.effective_start_date
2627: and ler.effective_end_date

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

2648: where pil.business_group_id = p_business_group_id
2649: and pil.person_id = p_person_id
2650: and (pil.lf_evt_ocrd_dt > p_lf_evt_ocrd_dt -- 5727737/5677090: Need to backout all Future LEs
2651: or (pil.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
2652: and pil.ler_id <> ben_manage_life_events.g_ler_id))
2653: and pil.ler_id = ler.ler_id
2654: and p_effective_date
2655: between ler.effective_start_date
2656: and ler.effective_end_date

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

2735: --
2736: -- More than one winner so return an error
2737: --
2738: fnd_message.set_name('BEN','BEN_91794_DUP_WINNERS');
2739: ben_manage_life_events.g_rec.rep_typ_cd := 'ERROR';
2740: ben_manage_life_events.g_rec.person_id := p_person_id;
2741: ben_manage_life_events.g_rec.ler_id := null;
2742: ben_manage_life_events.g_rec.error_message_code := 'BEN_91794_DUP_WINNERS';
2743: ben_manage_life_events.g_rec.text := fnd_message.get;

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

2736: -- More than one winner so return an error
2737: --
2738: fnd_message.set_name('BEN','BEN_91794_DUP_WINNERS');
2739: ben_manage_life_events.g_rec.rep_typ_cd := 'ERROR';
2740: ben_manage_life_events.g_rec.person_id := p_person_id;
2741: ben_manage_life_events.g_rec.ler_id := null;
2742: ben_manage_life_events.g_rec.error_message_code := 'BEN_91794_DUP_WINNERS';
2743: ben_manage_life_events.g_rec.text := fnd_message.get;
2744: fnd_message.set_name('BEN','BEN_91794_DUP_WINNERS');

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

2737: --
2738: fnd_message.set_name('BEN','BEN_91794_DUP_WINNERS');
2739: ben_manage_life_events.g_rec.rep_typ_cd := 'ERROR';
2740: ben_manage_life_events.g_rec.person_id := p_person_id;
2741: ben_manage_life_events.g_rec.ler_id := null;
2742: ben_manage_life_events.g_rec.error_message_code := 'BEN_91794_DUP_WINNERS';
2743: ben_manage_life_events.g_rec.text := fnd_message.get;
2744: fnd_message.set_name('BEN','BEN_91794_DUP_WINNERS');
2745: fnd_message.set_token('PROC',l_proc);

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

2738: fnd_message.set_name('BEN','BEN_91794_DUP_WINNERS');
2739: ben_manage_life_events.g_rec.rep_typ_cd := 'ERROR';
2740: ben_manage_life_events.g_rec.person_id := p_person_id;
2741: ben_manage_life_events.g_rec.ler_id := null;
2742: ben_manage_life_events.g_rec.error_message_code := 'BEN_91794_DUP_WINNERS';
2743: ben_manage_life_events.g_rec.text := fnd_message.get;
2744: fnd_message.set_name('BEN','BEN_91794_DUP_WINNERS');
2745: fnd_message.set_token('PROC',l_proc);
2746: fnd_message.set_token('PERSON_ID',p_person_id);

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

2739: ben_manage_life_events.g_rec.rep_typ_cd := 'ERROR';
2740: ben_manage_life_events.g_rec.person_id := p_person_id;
2741: ben_manage_life_events.g_rec.ler_id := null;
2742: ben_manage_life_events.g_rec.error_message_code := 'BEN_91794_DUP_WINNERS';
2743: ben_manage_life_events.g_rec.text := fnd_message.get;
2744: fnd_message.set_name('BEN','BEN_91794_DUP_WINNERS');
2745: fnd_message.set_token('PROC',l_proc);
2746: fnd_message.set_token('PERSON_ID',p_person_id);
2747: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

Line 2748: raise ben_manage_life_events.g_record_error;

2744: fnd_message.set_name('BEN','BEN_91794_DUP_WINNERS');
2745: fnd_message.set_token('PROC',l_proc);
2746: fnd_message.set_token('PERSON_ID',p_person_id);
2747: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
2748: raise ben_manage_life_events.g_record_error;
2749: --
2750: -- No winners, but more than one potential?
2751: --
2752: elsif l_num_winners = 0 and

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

2753: l_num_recs > 1 then
2754: --
2755: -- Potential life events clash, so error.
2756: --
2757: ben_manage_life_events.g_rec.rep_typ_cd := 'ERROR';
2758: ben_manage_life_events.g_rec.person_id := p_person_id;
2759: ben_manage_life_events.g_rec.ler_id := null;
2760: ben_manage_life_events.g_rec.error_message_code := 'BEN_92337_DUPLICATE_PTNL_LE';
2761: ben_manage_life_events.g_rec.text := fnd_message.get;

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

2754: --
2755: -- Potential life events clash, so error.
2756: --
2757: ben_manage_life_events.g_rec.rep_typ_cd := 'ERROR';
2758: ben_manage_life_events.g_rec.person_id := p_person_id;
2759: ben_manage_life_events.g_rec.ler_id := null;
2760: ben_manage_life_events.g_rec.error_message_code := 'BEN_92337_DUPLICATE_PTNL_LE';
2761: ben_manage_life_events.g_rec.text := fnd_message.get;
2762: fnd_message.set_name('BEN','BEN_92337_DUPLICATE_PTNL_LE');

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

2755: -- Potential life events clash, so error.
2756: --
2757: ben_manage_life_events.g_rec.rep_typ_cd := 'ERROR';
2758: ben_manage_life_events.g_rec.person_id := p_person_id;
2759: ben_manage_life_events.g_rec.ler_id := null;
2760: ben_manage_life_events.g_rec.error_message_code := 'BEN_92337_DUPLICATE_PTNL_LE';
2761: ben_manage_life_events.g_rec.text := fnd_message.get;
2762: fnd_message.set_name('BEN','BEN_92337_DUPLICATE_PTNL_LE');
2763: fnd_message.set_token('PROC',l_proc);

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

2756: --
2757: ben_manage_life_events.g_rec.rep_typ_cd := 'ERROR';
2758: ben_manage_life_events.g_rec.person_id := p_person_id;
2759: ben_manage_life_events.g_rec.ler_id := null;
2760: ben_manage_life_events.g_rec.error_message_code := 'BEN_92337_DUPLICATE_PTNL_LE';
2761: ben_manage_life_events.g_rec.text := fnd_message.get;
2762: fnd_message.set_name('BEN','BEN_92337_DUPLICATE_PTNL_LE');
2763: fnd_message.set_token('PROC',l_proc);
2764: fnd_message.set_token('PERSON_ID',p_person_id);

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

2757: ben_manage_life_events.g_rec.rep_typ_cd := 'ERROR';
2758: ben_manage_life_events.g_rec.person_id := p_person_id;
2759: ben_manage_life_events.g_rec.ler_id := null;
2760: ben_manage_life_events.g_rec.error_message_code := 'BEN_92337_DUPLICATE_PTNL_LE';
2761: ben_manage_life_events.g_rec.text := fnd_message.get;
2762: fnd_message.set_name('BEN','BEN_92337_DUPLICATE_PTNL_LE');
2763: fnd_message.set_token('PROC',l_proc);
2764: fnd_message.set_token('PERSON_ID',p_person_id);
2765: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

Line 2766: raise ben_manage_life_events.g_record_error;

2762: fnd_message.set_name('BEN','BEN_92337_DUPLICATE_PTNL_LE');
2763: fnd_message.set_token('PROC',l_proc);
2764: fnd_message.set_token('PERSON_ID',p_person_id);
2765: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
2766: raise ben_manage_life_events.g_record_error;
2767: --
2768: elsif l_num_winners = 1 then
2769: --
2770: l_search_ptnl_ler_for_per_id := l_win_ptnl_ler_for_per_id;

Line 2819: raise ben_manage_life_events.g_record_error;

2815: fnd_message.set_name('BEN','BEN_92144_NO_LIFE_EVENTS');
2816: fnd_message.set_token('PROC',l_proc);
2817: fnd_message.set_token('PERSON_ID',p_person_id);
2818: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
2819: raise ben_manage_life_events.g_record_error;
2820: --
2821: end if;
2822: --
2823: open c2;

Line 2848: raise ben_manage_life_events.g_life_event_after;

2844: -- For BENAUTHE retreival purpose.
2845: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
2846: fnd_message.set_token('LE_NAME',l_win_ler_name);
2847: fnd_message.set_token('PROC',l_proc);
2848: raise ben_manage_life_events.g_life_event_after;
2849: --
2850: end if;
2851: --
2852: close c2;

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

2883: ptn.lf_evt_ocrd_dt,
2884: 'SCHEDDA',
2885: ptn.lf_evt_ocrd_dt,
2886: p_effective_date)
2887: and ptn.ler_id <> ben_manage_life_events.g_ler_id
2888: and ptn.ptnl_ler_for_per_stat_cd not in ('PROCD','VOIDD');
2889: --
2890: -- CWB Changes End
2891: --

Line 2918: raise ben_manage_life_events.g_life_event_after;

2914: fnd_message.set_name('BEN','BEN_92144_NO_LIFE_EVENTS');
2915: fnd_message.set_token('PROC',l_proc);
2916: fnd_message.set_token('PERSON_ID',p_person_id);
2917: fnd_message.set_token('LF_EVT_OCRD_DT',l_min_lf_evt_ocrd_dt);
2918: raise ben_manage_life_events.g_life_event_after;
2919: --
2920: end if;
2921: --
2922: close c1;

Line 2973: raise ben_manage_life_events.g_life_event_after;

2969: -- For BENAUTHE retreival purpose.
2970: fnd_message.set_name('BEN','BEN_94209_MAN_LER_EXISTIS');
2971: -- fnd_message.set_token('LE_NAME',l_potent.name);
2972: -- fnd_message.set_token('PROC',l_proc);
2973: raise ben_manage_life_events.g_life_event_after;
2974: --
2975: end if;
2976: --
2977: -- If there is a rule attached lets evaluate it and handle the returned

Line 3029: raise ben_manage_life_events.g_life_event_after;

3025: --
3026: fnd_message.set_name('BEN','BEN_92536_PERSON_HAS_NO_PPL');
3027: fnd_message.set_token('PERSON_ID',p_person_id);
3028: fnd_message.set_token('PROC',l_proc);
3029: raise ben_manage_life_events.g_life_event_after;
3030: --
3031: end if;
3032: --
3033: -- Now we have manipulated all potentials, check whether the remaining

Line 3129: raise ben_manage_life_events.g_record_error;

3125: --
3126: fnd_message.set_name('BEN','BEN_92145_MODE_LE_DIFFER');
3127: fnd_message.set_token('MODE',l_use_mode);
3128: --
3129: raise ben_manage_life_events.g_record_error;
3130: --
3131: end if;
3132: --
3133: -- Bug 4872042

Line 3279: raise ben_manage_life_events.g_life_event_after;

3275: g_rec.business_group_id := p_business_group_id;
3276: g_rec.effective_date := p_effective_date;
3277: benutils.write(p_rec => g_rec);
3278: --
3279: raise ben_manage_life_events.g_life_event_after;
3280: --
3281: end if;
3282: --
3283: close c_check_deadlock_pil;

Line 3383: raise ben_manage_life_events.g_life_event_after;

3379: fnd_message.set_name('BEN','BEN_91797_PTNL_AFTER_ACTIVE');
3380: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',l_ptnl_rec.lf_evt_ocrd_dt);
3381: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',
3382: l_current_per_in_ler.lf_evt_ocrd_dt);
3383: raise ben_manage_life_events.g_life_event_after;
3384: --
3385: end if;
3386: --
3387:

Line 3561: raise ben_manage_life_events.g_life_event_after;

3557: -- For BENAUTHE retreival purpose.
3558: --
3559: fnd_message.set_name('BEN','BEN_94025_IREC_OFFER_PROCESSED');
3560: benutils.write(p_text => fnd_message.get);
3561: raise ben_manage_life_events.g_life_event_after;
3562: --
3563: elsif l_pil_rec.per_in_ler_id is not null and
3564: l_pil_rec.per_in_ler_stat_cd = 'STRTD' then
3565: --