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 FND_MESSAGE

Line 388: fnd_message.set_name('BEN','BEN_92536_PERSON_HAS_NO_PPL');

384: --
385: -- All the absences are deleted, no winner is found then we need to just
386: -- commit the data and move on with next person.
387: -- 9999 change the message.
388: fnd_message.set_name('BEN','BEN_92536_PERSON_HAS_NO_PPL');
389: fnd_message.set_token('PERSON_ID',p_person_id);
390: fnd_message.set_token('PROC',l_proc);
391: benutils.write(fnd_message.get);
392: --

Line 389: fnd_message.set_token('PERSON_ID',p_person_id);

385: -- All the absences are deleted, no winner is found then we need to just
386: -- commit the data and move on with next person.
387: -- 9999 change the message.
388: fnd_message.set_name('BEN','BEN_92536_PERSON_HAS_NO_PPL');
389: fnd_message.set_token('PERSON_ID',p_person_id);
390: fnd_message.set_token('PROC',l_proc);
391: benutils.write(fnd_message.get);
392: --
393: -- For BENAUTHE

Line 390: fnd_message.set_token('PROC',l_proc);

386: -- commit the data and move on with next person.
387: -- 9999 change the message.
388: fnd_message.set_name('BEN','BEN_92536_PERSON_HAS_NO_PPL');
389: fnd_message.set_token('PERSON_ID',p_person_id);
390: fnd_message.set_token('PROC',l_proc);
391: benutils.write(fnd_message.get);
392: --
393: -- For BENAUTHE
394: --

Line 391: benutils.write(fnd_message.get);

387: -- 9999 change the message.
388: fnd_message.set_name('BEN','BEN_92536_PERSON_HAS_NO_PPL');
389: fnd_message.set_token('PERSON_ID',p_person_id);
390: fnd_message.set_token('PROC',l_proc);
391: benutils.write(fnd_message.get);
392: --
393: -- For BENAUTHE
394: --
395: fnd_message.set_name('BEN','BEN_92536_PERSON_HAS_NO_PPL');

Line 395: fnd_message.set_name('BEN','BEN_92536_PERSON_HAS_NO_PPL');

391: benutils.write(fnd_message.get);
392: --
393: -- For BENAUTHE
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: --

Line 396: fnd_message.set_token('PERSON_ID',p_person_id);

392: --
393: -- For BENAUTHE
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;

Line 397: fnd_message.set_token('PROC',l_proc);

393: -- For BENAUTHE
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: --

Line 639: fnd_message.raise_error;

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;
640: -- end bug 5987235
641: end absences_eval_ptnl_per_for_ler;
642: --
643: -- ----------------------------------------------------------------------------

Line 857: fnd_message.set_name('BEN','BEN_91797_PTNL_AFTER_ACTIVE');

853: hr_utility.set_location('Case B ',10);
854: --
855: -- Case B : Potential is after active per in ler. First complete it.
856: --
857: fnd_message.set_name('BEN','BEN_91797_PTNL_AFTER_ACTIVE');
858: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
859: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',
860: l_pil_rec.lf_evt_ocrd_dt);
861: benutils.write(p_text => fnd_message.get);

Line 858: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

854: --
855: -- Case B : Potential is after active per in ler. First complete it.
856: --
857: fnd_message.set_name('BEN','BEN_91797_PTNL_AFTER_ACTIVE');
858: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
859: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',
860: l_pil_rec.lf_evt_ocrd_dt);
861: benutils.write(p_text => fnd_message.get);
862: --

Line 859: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',

855: -- Case B : Potential is after active per in ler. First complete it.
856: --
857: fnd_message.set_name('BEN','BEN_91797_PTNL_AFTER_ACTIVE');
858: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
859: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',
860: l_pil_rec.lf_evt_ocrd_dt);
861: benutils.write(p_text => fnd_message.get);
862: --
863: g_rec.person_id := p_person_id;

Line 861: benutils.write(p_text => fnd_message.get);

857: fnd_message.set_name('BEN','BEN_91797_PTNL_AFTER_ACTIVE');
858: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
859: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',
860: l_pil_rec.lf_evt_ocrd_dt);
861: benutils.write(p_text => fnd_message.get);
862: --
863: g_rec.person_id := p_person_id;
864: g_rec.ler_id := l_pil_rec.ler_id;
865: g_rec.lf_evt_ocrd_dt := p_lf_evt_ocrd_dt;

Line 884: fnd_message.set_name('BEN','BEN_91797_PTNL_AFTER_ACTIVE');

880: --
881: benutils.write(p_rec => g_rec);
882: --
883: -- For BENAUTHE retreival purpose.
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;

Line 885: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

881: benutils.write(p_rec => g_rec);
882: --
883: -- For BENAUTHE retreival purpose.
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: --

Line 886: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',

882: --
883: -- For BENAUTHE retreival purpose.
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

Line 897: fnd_message.set_name('BEN','BEN_92864_CWB_PTNL_AFTR_ACTIVE');

893: --
894: -- Case C : Processed or active per in ler is in future for the given
895: -- ler so error out. You can't go back and run.
896: --
897: fnd_message.set_name('BEN','BEN_92864_CWB_PTNL_AFTR_ACTIVE');
898: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
899: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',
900: l_pil_rec.lf_evt_ocrd_dt);
901: benutils.write(p_text => fnd_message.get);

Line 898: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

894: -- Case C : Processed or active per in ler is in future for the given
895: -- ler so error out. You can't go back and run.
896: --
897: fnd_message.set_name('BEN','BEN_92864_CWB_PTNL_AFTR_ACTIVE');
898: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
899: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',
900: l_pil_rec.lf_evt_ocrd_dt);
901: benutils.write(p_text => fnd_message.get);
902: --

Line 899: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',

895: -- ler so error out. You can't go back and run.
896: --
897: fnd_message.set_name('BEN','BEN_92864_CWB_PTNL_AFTR_ACTIVE');
898: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
899: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',
900: l_pil_rec.lf_evt_ocrd_dt);
901: benutils.write(p_text => fnd_message.get);
902: --
903: g_rec.person_id := p_person_id;

Line 901: benutils.write(p_text => fnd_message.get);

897: fnd_message.set_name('BEN','BEN_92864_CWB_PTNL_AFTR_ACTIVE');
898: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
899: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',
900: l_pil_rec.lf_evt_ocrd_dt);
901: benutils.write(p_text => fnd_message.get);
902: --
903: g_rec.person_id := p_person_id;
904: g_rec.ler_id := l_pil_rec.ler_id;
905: g_rec.lf_evt_ocrd_dt := p_lf_evt_ocrd_dt;

Line 924: fnd_message.set_name('BEN','BEN_92864_CWB_PTNL_AFTR_ACTIVE');

920: --
921: benutils.write(p_rec => g_rec);
922: --
923: -- For BENAUTHE retreival purpose.
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;

Line 925: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

921: benutils.write(p_rec => g_rec);
922: --
923: -- For BENAUTHE retreival purpose.
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: --

Line 926: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',

922: --
923: -- For BENAUTHE retreival purpose.
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: --

Line 1053: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');

1049: --
1050: if l_potent.ptnl_ler_for_per_stat_cd = 'MNL' then
1051: --
1052: -- Need to comeup with new messages???? 99999
1053: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
1054: fnd_message.set_token('LE_NAME',l_potent.name);
1055: fnd_message.set_token('PROC',l_proc);
1056: benutils.write(p_text => fnd_message.get);
1057: -- For BENAUTHE retreival purpose.

Line 1054: fnd_message.set_token('LE_NAME',l_potent.name);

1050: if l_potent.ptnl_ler_for_per_stat_cd = 'MNL' then
1051: --
1052: -- Need to comeup with new messages???? 99999
1053: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
1054: fnd_message.set_token('LE_NAME',l_potent.name);
1055: fnd_message.set_token('PROC',l_proc);
1056: benutils.write(p_text => fnd_message.get);
1057: -- For BENAUTHE retreival purpose.
1058: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');

Line 1055: fnd_message.set_token('PROC',l_proc);

1051: --
1052: -- Need to comeup with new messages???? 99999
1053: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
1054: fnd_message.set_token('LE_NAME',l_potent.name);
1055: fnd_message.set_token('PROC',l_proc);
1056: benutils.write(p_text => fnd_message.get);
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);

Line 1056: benutils.write(p_text => fnd_message.get);

1052: -- Need to comeup with new messages???? 99999
1053: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
1054: fnd_message.set_token('LE_NAME',l_potent.name);
1055: fnd_message.set_token('PROC',l_proc);
1056: benutils.write(p_text => fnd_message.get);
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);

Line 1058: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');

1054: fnd_message.set_token('LE_NAME',l_potent.name);
1055: fnd_message.set_token('PROC',l_proc);
1056: benutils.write(p_text => fnd_message.get);
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: --

Line 1059: fnd_message.set_token('LE_NAME',l_potent.name);

1055: fnd_message.set_token('PROC',l_proc);
1056: benutils.write(p_text => fnd_message.get);
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;

Line 1060: fnd_message.set_token('PROC',l_proc);

1056: benutils.write(p_text => fnd_message.get);
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: --

Line 1079: fnd_message.set_name('BEN','BEN_92536_PERSON_HAS_NO_PPL');

1075: --
1076: -- We don't want to add to the error count so lets just process the next
1077: -- person. The life event could be strtd or procd we don't care.
1078: --
1079: fnd_message.set_name('BEN','BEN_92536_PERSON_HAS_NO_PPL');
1080: fnd_message.set_token('PERSON_ID',p_person_id);
1081: fnd_message.set_token('PROC',l_proc);
1082: benutils.write(fnd_message.get);
1083: --

Line 1080: fnd_message.set_token('PERSON_ID',p_person_id);

1076: -- We don't want to add to the error count so lets just process the next
1077: -- person. The life event could be strtd or procd we don't care.
1078: --
1079: fnd_message.set_name('BEN','BEN_92536_PERSON_HAS_NO_PPL');
1080: fnd_message.set_token('PERSON_ID',p_person_id);
1081: fnd_message.set_token('PROC',l_proc);
1082: benutils.write(fnd_message.get);
1083: --
1084: -- For BENAUTHE

Line 1081: fnd_message.set_token('PROC',l_proc);

1077: -- person. The life event could be strtd or procd we don't care.
1078: --
1079: fnd_message.set_name('BEN','BEN_92536_PERSON_HAS_NO_PPL');
1080: fnd_message.set_token('PERSON_ID',p_person_id);
1081: fnd_message.set_token('PROC',l_proc);
1082: benutils.write(fnd_message.get);
1083: --
1084: -- For BENAUTHE
1085: --

Line 1082: benutils.write(fnd_message.get);

1078: --
1079: fnd_message.set_name('BEN','BEN_92536_PERSON_HAS_NO_PPL');
1080: fnd_message.set_token('PERSON_ID',p_person_id);
1081: fnd_message.set_token('PROC',l_proc);
1082: benutils.write(fnd_message.get);
1083: --
1084: -- For BENAUTHE
1085: --
1086: fnd_message.set_name('BEN','BEN_92536_PERSON_HAS_NO_PPL');

Line 1086: fnd_message.set_name('BEN','BEN_92536_PERSON_HAS_NO_PPL');

1082: benutils.write(fnd_message.get);
1083: --
1084: -- For BENAUTHE
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: --

Line 1087: fnd_message.set_token('PERSON_ID',p_person_id);

1083: --
1084: -- For BENAUTHE
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;

Line 1088: fnd_message.set_token('PROC',l_proc);

1084: -- For BENAUTHE
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: --

Line 1101: fnd_message.set_name('BEN','BEN_91797_PTNL_AFTER_ACTIVE');

1097: if l_pil_rec.per_in_ler_stat_cd = 'STRTD' then
1098: --
1099: -- Potential is after per in ler so leave ptnl as is
1100: --
1101: fnd_message.set_name('BEN','BEN_91797_PTNL_AFTER_ACTIVE');
1102: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',l_min_ptnl.lf_evt_ocrd_dt);
1103: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',
1104: l_pil_rec.lf_evt_ocrd_dt);
1105: benutils.write(p_text => fnd_message.get);

Line 1102: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',l_min_ptnl.lf_evt_ocrd_dt);

1098: --
1099: -- Potential is after per in ler so leave ptnl as is
1100: --
1101: fnd_message.set_name('BEN','BEN_91797_PTNL_AFTER_ACTIVE');
1102: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',l_min_ptnl.lf_evt_ocrd_dt);
1103: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',
1104: l_pil_rec.lf_evt_ocrd_dt);
1105: benutils.write(p_text => fnd_message.get);
1106: --

Line 1103: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',

1099: -- Potential is after per in ler so leave ptnl as is
1100: --
1101: fnd_message.set_name('BEN','BEN_91797_PTNL_AFTER_ACTIVE');
1102: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',l_min_ptnl.lf_evt_ocrd_dt);
1103: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',
1104: l_pil_rec.lf_evt_ocrd_dt);
1105: benutils.write(p_text => fnd_message.get);
1106: --
1107: g_rec.person_id := p_person_id;

Line 1105: benutils.write(p_text => fnd_message.get);

1101: fnd_message.set_name('BEN','BEN_91797_PTNL_AFTER_ACTIVE');
1102: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',l_min_ptnl.lf_evt_ocrd_dt);
1103: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',
1104: l_pil_rec.lf_evt_ocrd_dt);
1105: benutils.write(p_text => fnd_message.get);
1106: --
1107: g_rec.person_id := p_person_id;
1108: g_rec.ler_id := l_min_ptnl.ler_id;
1109: g_rec.lf_evt_ocrd_dt := l_min_ptnl.lf_evt_ocrd_dt;

Line 1128: fnd_message.set_name('BEN','BEN_91797_PTNL_AFTER_ACTIVE');

1124: --
1125: benutils.write(p_rec => g_rec);
1126: --
1127: -- For BENAUTHE retreival purpose.
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;

Line 1129: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',l_min_ptnl.lf_evt_ocrd_dt);

1125: benutils.write(p_rec => g_rec);
1126: --
1127: -- For BENAUTHE retreival purpose.
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: --

Line 1130: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',

1126: --
1127: -- For BENAUTHE retreival purpose.
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

Line 1140: fnd_message.set_name('BEN','BEN_94092_PTNL_BEFORE_PROCD');

1136: -- 99999 check the messages above and here.
1137: --
1138: -- Potential is after per in ler so leave ptnl as is
1139: --
1140: fnd_message.set_name('BEN','BEN_94092_PTNL_BEFORE_PROCD');
1141: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',l_min_ptnl.lf_evt_ocrd_dt);
1142: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',
1143: l_pil_rec.lf_evt_ocrd_dt);
1144: benutils.write(p_text => fnd_message.get);

Line 1141: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',l_min_ptnl.lf_evt_ocrd_dt);

1137: --
1138: -- Potential is after per in ler so leave ptnl as is
1139: --
1140: fnd_message.set_name('BEN','BEN_94092_PTNL_BEFORE_PROCD');
1141: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',l_min_ptnl.lf_evt_ocrd_dt);
1142: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',
1143: l_pil_rec.lf_evt_ocrd_dt);
1144: benutils.write(p_text => fnd_message.get);
1145: --

Line 1142: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',

1138: -- Potential is after per in ler so leave ptnl as is
1139: --
1140: fnd_message.set_name('BEN','BEN_94092_PTNL_BEFORE_PROCD');
1141: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',l_min_ptnl.lf_evt_ocrd_dt);
1142: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',
1143: l_pil_rec.lf_evt_ocrd_dt);
1144: benutils.write(p_text => fnd_message.get);
1145: --
1146: g_rec.person_id := p_person_id;

Line 1144: benutils.write(p_text => fnd_message.get);

1140: fnd_message.set_name('BEN','BEN_94092_PTNL_BEFORE_PROCD');
1141: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',l_min_ptnl.lf_evt_ocrd_dt);
1142: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',
1143: l_pil_rec.lf_evt_ocrd_dt);
1144: benutils.write(p_text => fnd_message.get);
1145: --
1146: g_rec.person_id := p_person_id;
1147: g_rec.ler_id := l_min_ptnl.ler_id;
1148: g_rec.lf_evt_ocrd_dt := l_min_ptnl.lf_evt_ocrd_dt;

Line 1167: fnd_message.set_name('BEN','BEN_94092_PTNL_BEFORE_PROCD');

1163: --
1164: benutils.write(p_rec => g_rec);
1165: --
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: --

Line 1168: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',l_min_ptnl.lf_evt_ocrd_dt);

1164: benutils.write(p_rec => g_rec);
1165: --
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

Line 1169: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',l_pil_rec.lf_evt_ocrd_dt);

1165: --
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: --

Line 1188: fnd_message.set_name('BEN','BEN_94091_NO_GSP_PROG_PROCD');

1184: -- GSP Rate Sync is being processed for a person who is never processed for GSP Prog in the past
1185: close c_gsp_prog_procd_exists;
1186: hr_utility.set_location('GSP Rate Sync processed withouth GSP Prog', 9);
1187: --
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;

Line 1189: benutils.write(fnd_message.get);

1185: close c_gsp_prog_procd_exists;
1186: hr_utility.set_location('GSP Rate Sync processed withouth GSP Prog', 9);
1187: --
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: --

Line 1191: fnd_message.set_name('BEN','BEN_94091_NO_GSP_PROG_PROCD');

1187: --
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: --

Line 1817: fnd_message.set_name('BEN','BEN_92098_LIFE_EVENT_VOIDED');

1813: ,p_program_update_date => sysdate
1814: ,p_voidd_dt => p_effective_date);
1815: --
1816: l_curr_voidd_ptnl_cnt := l_curr_voidd_ptnl_cnt + 1;-- added during iRec
1817: fnd_message.set_name('BEN','BEN_92098_LIFE_EVENT_VOIDED');
1818: fnd_message.set_token('LF_EVT',l_potent.name);
1819: fnd_message.set_token('LF_EVT_OCRD_DT',l_potent.lf_evt_ocrd_dt);
1820: benutils.write(p_text => fnd_message.get);
1821: --

Line 1818: fnd_message.set_token('LF_EVT',l_potent.name);

1814: ,p_voidd_dt => p_effective_date);
1815: --
1816: l_curr_voidd_ptnl_cnt := l_curr_voidd_ptnl_cnt + 1;-- added during iRec
1817: fnd_message.set_name('BEN','BEN_92098_LIFE_EVENT_VOIDED');
1818: fnd_message.set_token('LF_EVT',l_potent.name);
1819: fnd_message.set_token('LF_EVT_OCRD_DT',l_potent.lf_evt_ocrd_dt);
1820: benutils.write(p_text => fnd_message.get);
1821: --
1822: g_rec.person_id := p_person_id;

Line 1819: fnd_message.set_token('LF_EVT_OCRD_DT',l_potent.lf_evt_ocrd_dt);

1815: --
1816: l_curr_voidd_ptnl_cnt := l_curr_voidd_ptnl_cnt + 1;-- added during iRec
1817: fnd_message.set_name('BEN','BEN_92098_LIFE_EVENT_VOIDED');
1818: fnd_message.set_token('LF_EVT',l_potent.name);
1819: fnd_message.set_token('LF_EVT_OCRD_DT',l_potent.lf_evt_ocrd_dt);
1820: benutils.write(p_text => fnd_message.get);
1821: --
1822: g_rec.person_id := p_person_id;
1823: g_rec.ler_id := l_potent.ler_id;

Line 1820: benutils.write(p_text => fnd_message.get);

1816: l_curr_voidd_ptnl_cnt := l_curr_voidd_ptnl_cnt + 1;-- added during iRec
1817: fnd_message.set_name('BEN','BEN_92098_LIFE_EVENT_VOIDED');
1818: fnd_message.set_token('LF_EVT',l_potent.name);
1819: fnd_message.set_token('LF_EVT_OCRD_DT',l_potent.lf_evt_ocrd_dt);
1820: benutils.write(p_text => fnd_message.get);
1821: --
1822: g_rec.person_id := p_person_id;
1823: g_rec.ler_id := l_potent.ler_id;
1824: g_rec.lf_evt_ocrd_dt := l_potent.lf_evt_ocrd_dt;

Line 1872: fnd_message.set_name('BEN','BEN_92098_LIFE_EVENT_VOIDED');

1868: ,p_program_update_date => sysdate
1869: ,p_voidd_dt => p_effective_date);
1870: --
1871: l_curr_voidd_ptnl_cnt := l_curr_voidd_ptnl_cnt + 1;-- + added during iREC
1872: fnd_message.set_name('BEN','BEN_92098_LIFE_EVENT_VOIDED');
1873: fnd_message.set_token('LF_EVT',l_potent.name);
1874: fnd_message.set_token('LF_EVT_OCRD_DT',l_potent.lf_evt_ocrd_dt);
1875: benutils.write(p_text => fnd_message.get);
1876: --

Line 1873: fnd_message.set_token('LF_EVT',l_potent.name);

1869: ,p_voidd_dt => p_effective_date);
1870: --
1871: l_curr_voidd_ptnl_cnt := l_curr_voidd_ptnl_cnt + 1;-- + added during iREC
1872: fnd_message.set_name('BEN','BEN_92098_LIFE_EVENT_VOIDED');
1873: fnd_message.set_token('LF_EVT',l_potent.name);
1874: fnd_message.set_token('LF_EVT_OCRD_DT',l_potent.lf_evt_ocrd_dt);
1875: benutils.write(p_text => fnd_message.get);
1876: --
1877: g_rec.person_id := p_person_id;

Line 1874: fnd_message.set_token('LF_EVT_OCRD_DT',l_potent.lf_evt_ocrd_dt);

1870: --
1871: l_curr_voidd_ptnl_cnt := l_curr_voidd_ptnl_cnt + 1;-- + added during iREC
1872: fnd_message.set_name('BEN','BEN_92098_LIFE_EVENT_VOIDED');
1873: fnd_message.set_token('LF_EVT',l_potent.name);
1874: fnd_message.set_token('LF_EVT_OCRD_DT',l_potent.lf_evt_ocrd_dt);
1875: benutils.write(p_text => fnd_message.get);
1876: --
1877: g_rec.person_id := p_person_id;
1878: g_rec.ler_id := l_potent.ler_id;

Line 1875: benutils.write(p_text => fnd_message.get);

1871: l_curr_voidd_ptnl_cnt := l_curr_voidd_ptnl_cnt + 1;-- + added during iREC
1872: fnd_message.set_name('BEN','BEN_92098_LIFE_EVENT_VOIDED');
1873: fnd_message.set_token('LF_EVT',l_potent.name);
1874: fnd_message.set_token('LF_EVT_OCRD_DT',l_potent.lf_evt_ocrd_dt);
1875: benutils.write(p_text => fnd_message.get);
1876: --
1877: g_rec.person_id := p_person_id;
1878: g_rec.ler_id := l_potent.ler_id;
1879: g_rec.lf_evt_ocrd_dt := l_potent.lf_evt_ocrd_dt;

Line 1956: fnd_message.set_name('BEN','BEN_92098_LIFE_EVENT_VOIDED');

1952: ,p_program_update_date => sysdate
1953: ,p_voidd_dt => p_effective_date);
1954: --
1955: l_curr_voidd_ptnl_cnt := l_curr_voidd_ptnl_cnt + 1;
1956: fnd_message.set_name('BEN','BEN_92098_LIFE_EVENT_VOIDED');
1957: fnd_message.set_token('LF_EVT',l_potent.name);
1958: fnd_message.set_token('LF_EVT_OCRD_DT',l_potent.lf_evt_ocrd_dt);
1959: benutils.write(p_text => fnd_message.get);
1960: --

Line 1957: fnd_message.set_token('LF_EVT',l_potent.name);

1953: ,p_voidd_dt => p_effective_date);
1954: --
1955: l_curr_voidd_ptnl_cnt := l_curr_voidd_ptnl_cnt + 1;
1956: fnd_message.set_name('BEN','BEN_92098_LIFE_EVENT_VOIDED');
1957: fnd_message.set_token('LF_EVT',l_potent.name);
1958: fnd_message.set_token('LF_EVT_OCRD_DT',l_potent.lf_evt_ocrd_dt);
1959: benutils.write(p_text => fnd_message.get);
1960: --
1961: g_rec.person_id := p_person_id;

Line 1958: fnd_message.set_token('LF_EVT_OCRD_DT',l_potent.lf_evt_ocrd_dt);

1954: --
1955: l_curr_voidd_ptnl_cnt := l_curr_voidd_ptnl_cnt + 1;
1956: fnd_message.set_name('BEN','BEN_92098_LIFE_EVENT_VOIDED');
1957: fnd_message.set_token('LF_EVT',l_potent.name);
1958: fnd_message.set_token('LF_EVT_OCRD_DT',l_potent.lf_evt_ocrd_dt);
1959: benutils.write(p_text => fnd_message.get);
1960: --
1961: g_rec.person_id := p_person_id;
1962: g_rec.ler_id := l_potent.ler_id;

Line 1959: benutils.write(p_text => fnd_message.get);

1955: l_curr_voidd_ptnl_cnt := l_curr_voidd_ptnl_cnt + 1;
1956: fnd_message.set_name('BEN','BEN_92098_LIFE_EVENT_VOIDED');
1957: fnd_message.set_token('LF_EVT',l_potent.name);
1958: fnd_message.set_token('LF_EVT_OCRD_DT',l_potent.lf_evt_ocrd_dt);
1959: benutils.write(p_text => fnd_message.get);
1960: --
1961: g_rec.person_id := p_person_id;
1962: g_rec.ler_id := l_potent.ler_id;
1963: g_rec.lf_evt_ocrd_dt := l_potent.lf_evt_ocrd_dt;

Line 1983: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');

1979: benutils.write(p_rec => g_rec);
1980: --
1981: elsif l_outputs(l_outputs.first).value <> 'N' then
1982: --
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;

Line 1984: fnd_message.set_token('RL',

1980: --
1981: elsif l_outputs(l_outputs.first).value <> 'N' then
1982: --
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: --

Line 1986: fnd_message.set_token('PROC',l_proc);

1982: --
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: --

Line 2117: fnd_message.set_name('BEN','BEN_92098_LIFE_EVENT_VOIDED');

2113: --
2114: --
2115: /* Bug 4217795
2116: l_curr_voidd_ptnl_cnt := l_curr_voidd_ptnl_cnt + 1; -- + added during irec
2117: fnd_message.set_name('BEN','BEN_92098_LIFE_EVENT_VOIDED');
2118: fnd_message.set_token('LF_EVT',l_potent.name);
2119: fnd_message.set_token('LF_EVT_OCRD_DT',l_potent.lf_evt_ocrd_dt);
2120: benutils.write(p_text => fnd_message.get);
2121: --

Line 2118: fnd_message.set_token('LF_EVT',l_potent.name);

2114: --
2115: /* Bug 4217795
2116: l_curr_voidd_ptnl_cnt := l_curr_voidd_ptnl_cnt + 1; -- + added during irec
2117: fnd_message.set_name('BEN','BEN_92098_LIFE_EVENT_VOIDED');
2118: fnd_message.set_token('LF_EVT',l_potent.name);
2119: fnd_message.set_token('LF_EVT_OCRD_DT',l_potent.lf_evt_ocrd_dt);
2120: benutils.write(p_text => fnd_message.get);
2121: --
2122: g_rec.person_id := p_person_id;

Line 2119: fnd_message.set_token('LF_EVT_OCRD_DT',l_potent.lf_evt_ocrd_dt);

2115: /* Bug 4217795
2116: l_curr_voidd_ptnl_cnt := l_curr_voidd_ptnl_cnt + 1; -- + added during irec
2117: fnd_message.set_name('BEN','BEN_92098_LIFE_EVENT_VOIDED');
2118: fnd_message.set_token('LF_EVT',l_potent.name);
2119: fnd_message.set_token('LF_EVT_OCRD_DT',l_potent.lf_evt_ocrd_dt);
2120: benutils.write(p_text => fnd_message.get);
2121: --
2122: g_rec.person_id := p_person_id;
2123: g_rec.ler_id := p_ler_id;

Line 2120: benutils.write(p_text => fnd_message.get);

2116: l_curr_voidd_ptnl_cnt := l_curr_voidd_ptnl_cnt + 1; -- + added during irec
2117: fnd_message.set_name('BEN','BEN_92098_LIFE_EVENT_VOIDED');
2118: fnd_message.set_token('LF_EVT',l_potent.name);
2119: fnd_message.set_token('LF_EVT_OCRD_DT',l_potent.lf_evt_ocrd_dt);
2120: benutils.write(p_text => fnd_message.get);
2121: --
2122: g_rec.person_id := p_person_id;
2123: g_rec.ler_id := p_ler_id;
2124: g_rec.lf_evt_ocrd_dt := l_potent.lf_evt_ocrd_dt;

Line 2149: fnd_message.set_name('BEN','BEN_91329_FORMULA_RETURN');

2145: null;
2146: --
2147: elsif l_outputs(l_outputs.first).value <> 'N' then
2148: --
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;

Line 2150: fnd_message.set_token('RL',

2146: --
2147: elsif l_outputs(l_outputs.first).value <> 'N' then
2148: --
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: --

Line 2152: fnd_message.set_token('PROC',l_proc);

2148: --
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: --

Line 2185: fnd_message.set_name('BEN','BEN_92400_ALL_PTNL_VOIDD');

2181: --
2182: if l_npv_ptnl_cnt <> 0 and
2183: l_curr_voidd_ptnl_cnt = l_npv_ptnl_cnt then
2184: --
2185: fnd_message.set_name('BEN','BEN_92400_ALL_PTNL_VOIDD');
2186: benutils.write(p_text => fnd_message.get);
2187: --
2188: -- Mark a global indicating some of the potentials are
2189: -- made voidd. This flag is used by benptnle to display

Line 2186: benutils.write(p_text => fnd_message.get);

2182: if l_npv_ptnl_cnt <> 0 and
2183: l_curr_voidd_ptnl_cnt = l_npv_ptnl_cnt then
2184: --
2185: fnd_message.set_name('BEN','BEN_92400_ALL_PTNL_VOIDD');
2186: benutils.write(p_text => fnd_message.get);
2187: --
2188: -- Mark a global indicating some of the potentials are
2189: -- made voidd. This flag is used by benptnle to display
2190: -- a message back to the user.

Line 2211: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');

2207: -- 6129827 : If timeliness sets all potentials to Manual/Voided
2208: -- then exit immediately.
2209: if (l_npv_ptnl_cnt <> 0) and (l_npv_ptnl_cnt = l_mnl_ptnl_cnt + l_curr_voidd_ptnl_cnt) then
2210: --
2211: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
2212: fnd_message.set_token('LE_NAME',l_mnl_ler_name);
2213: fnd_message.set_token('PROC',l_proc);
2214: benutils.write(p_text => fnd_message.get);
2215: --

Line 2212: fnd_message.set_token('LE_NAME',l_mnl_ler_name);

2208: -- then exit immediately.
2209: if (l_npv_ptnl_cnt <> 0) and (l_npv_ptnl_cnt = l_mnl_ptnl_cnt + l_curr_voidd_ptnl_cnt) then
2210: --
2211: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
2212: fnd_message.set_token('LE_NAME',l_mnl_ler_name);
2213: fnd_message.set_token('PROC',l_proc);
2214: benutils.write(p_text => fnd_message.get);
2215: --
2216: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');

Line 2213: fnd_message.set_token('PROC',l_proc);

2209: if (l_npv_ptnl_cnt <> 0) and (l_npv_ptnl_cnt = l_mnl_ptnl_cnt + l_curr_voidd_ptnl_cnt) then
2210: --
2211: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
2212: fnd_message.set_token('LE_NAME',l_mnl_ler_name);
2213: fnd_message.set_token('PROC',l_proc);
2214: benutils.write(p_text => fnd_message.get);
2215: --
2216: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
2217: fnd_message.set_token('LE_NAME',l_mnl_ler_name);

Line 2214: benutils.write(p_text => fnd_message.get);

2210: --
2211: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
2212: fnd_message.set_token('LE_NAME',l_mnl_ler_name);
2213: fnd_message.set_token('PROC',l_proc);
2214: benutils.write(p_text => fnd_message.get);
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);

Line 2216: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');

2212: fnd_message.set_token('LE_NAME',l_mnl_ler_name);
2213: fnd_message.set_token('PROC',l_proc);
2214: benutils.write(p_text => fnd_message.get);
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: --

Line 2217: fnd_message.set_token('LE_NAME',l_mnl_ler_name);

2213: fnd_message.set_token('PROC',l_proc);
2214: benutils.write(p_text => fnd_message.get);
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;

Line 2218: fnd_message.set_token('PROC',l_proc);

2214: benutils.write(p_text => fnd_message.get);
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: --

Line 2335: --fnd_message.set_name('BEN','BEN_94750_NO_LIFE_EVENTS');--AMN Bug 14680386

2331: open c_ler(p_new_ler_id);
2332: fetch c_ler into l_new_ler;
2333: close c_ler;
2334:
2335: --fnd_message.set_name('BEN','BEN_94750_NO_LIFE_EVENTS');--AMN Bug 14680386
2336: fnd_message.set_name('BEN','BEN_94752_NO_LIFE_EVENTS');--AMN Bug 14680386
2337: fnd_message.set_token('CURRENT_LE',l_current_ler);
2338: fnd_message.set_token('NEW_LE',l_new_ler);
2339: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

Line 2336: fnd_message.set_name('BEN','BEN_94752_NO_LIFE_EVENTS');--AMN Bug 14680386

2332: fetch c_ler into l_new_ler;
2333: close c_ler;
2334:
2335: --fnd_message.set_name('BEN','BEN_94750_NO_LIFE_EVENTS');--AMN Bug 14680386
2336: fnd_message.set_name('BEN','BEN_94752_NO_LIFE_EVENTS');--AMN Bug 14680386
2337: fnd_message.set_token('CURRENT_LE',l_current_ler);
2338: fnd_message.set_token('NEW_LE',l_new_ler);
2339: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
2340: --fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);AMN Bug 14680386

Line 2337: fnd_message.set_token('CURRENT_LE',l_current_ler);

2333: close c_ler;
2334:
2335: --fnd_message.set_name('BEN','BEN_94750_NO_LIFE_EVENTS');--AMN Bug 14680386
2336: fnd_message.set_name('BEN','BEN_94752_NO_LIFE_EVENTS');--AMN Bug 14680386
2337: fnd_message.set_token('CURRENT_LE',l_current_ler);
2338: fnd_message.set_token('NEW_LE',l_new_ler);
2339: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
2340: --fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);AMN Bug 14680386
2341: benutils.write(p_text => fnd_message.get);

Line 2338: fnd_message.set_token('NEW_LE',l_new_ler);

2334:
2335: --fnd_message.set_name('BEN','BEN_94750_NO_LIFE_EVENTS');--AMN Bug 14680386
2336: fnd_message.set_name('BEN','BEN_94752_NO_LIFE_EVENTS');--AMN Bug 14680386
2337: fnd_message.set_token('CURRENT_LE',l_current_ler);
2338: fnd_message.set_token('NEW_LE',l_new_ler);
2339: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
2340: --fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);AMN Bug 14680386
2341: benutils.write(p_text => fnd_message.get);
2342: -- For BENAUTHE retreival purpose.

Line 2339: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

2335: --fnd_message.set_name('BEN','BEN_94750_NO_LIFE_EVENTS');--AMN Bug 14680386
2336: fnd_message.set_name('BEN','BEN_94752_NO_LIFE_EVENTS');--AMN Bug 14680386
2337: fnd_message.set_token('CURRENT_LE',l_current_ler);
2338: fnd_message.set_token('NEW_LE',l_new_ler);
2339: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
2340: --fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);AMN Bug 14680386
2341: benutils.write(p_text => fnd_message.get);
2342: -- For BENAUTHE retreival purpose.
2343: fnd_message.set_name('BEN','BEN_94750_NO_LIFE_EVENTS');

Line 2340: --fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);AMN Bug 14680386

2336: fnd_message.set_name('BEN','BEN_94752_NO_LIFE_EVENTS');--AMN Bug 14680386
2337: fnd_message.set_token('CURRENT_LE',l_current_ler);
2338: fnd_message.set_token('NEW_LE',l_new_ler);
2339: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
2340: --fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);AMN Bug 14680386
2341: benutils.write(p_text => fnd_message.get);
2342: -- For BENAUTHE retreival purpose.
2343: fnd_message.set_name('BEN','BEN_94750_NO_LIFE_EVENTS');
2344: fnd_message.set_token('CURRENT_LE',l_current_ler);

Line 2341: benutils.write(p_text => fnd_message.get);

2337: fnd_message.set_token('CURRENT_LE',l_current_ler);
2338: fnd_message.set_token('NEW_LE',l_new_ler);
2339: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
2340: --fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);AMN Bug 14680386
2341: benutils.write(p_text => fnd_message.get);
2342: -- For BENAUTHE retreival purpose.
2343: fnd_message.set_name('BEN','BEN_94750_NO_LIFE_EVENTS');
2344: fnd_message.set_token('CURRENT_LE',l_current_ler);
2345: fnd_message.set_token('NEW_LE',l_new_ler);

Line 2343: fnd_message.set_name('BEN','BEN_94750_NO_LIFE_EVENTS');

2339: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);
2340: --fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);AMN Bug 14680386
2341: benutils.write(p_text => fnd_message.get);
2342: -- For BENAUTHE retreival purpose.
2343: fnd_message.set_name('BEN','BEN_94750_NO_LIFE_EVENTS');
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);

Line 2344: fnd_message.set_token('CURRENT_LE',l_current_ler);

2340: --fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);AMN Bug 14680386
2341: benutils.write(p_text => fnd_message.get);
2342: -- For BENAUTHE retreival purpose.
2343: fnd_message.set_name('BEN','BEN_94750_NO_LIFE_EVENTS');
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;

Line 2345: fnd_message.set_token('NEW_LE',l_new_ler);

2341: benutils.write(p_text => fnd_message.get);
2342: -- For BENAUTHE retreival purpose.
2343: fnd_message.set_name('BEN','BEN_94750_NO_LIFE_EVENTS');
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: --

Line 2346: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

2342: -- For BENAUTHE retreival purpose.
2343: fnd_message.set_name('BEN','BEN_94750_NO_LIFE_EVENTS');
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;

Line 2347: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

2343: fnd_message.set_name('BEN','BEN_94750_NO_LIFE_EVENTS');
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: --

Line 2477: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM');

2473: --
2474: -- Account for cases where formula returns an unknown
2475: -- variable name
2476: --
2477: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM');
2478: fnd_message.set_token('PROC',l_proc);
2479: fnd_message.set_token('FORMULA',p_rule_id);
2480: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
2481: fnd_message.raise_error;

Line 2478: fnd_message.set_token('PROC',l_proc);

2474: -- Account for cases where formula returns an unknown
2475: -- variable name
2476: --
2477: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM');
2478: fnd_message.set_token('PROC',l_proc);
2479: fnd_message.set_token('FORMULA',p_rule_id);
2480: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
2481: fnd_message.raise_error;
2482: --

Line 2479: fnd_message.set_token('FORMULA',p_rule_id);

2475: -- variable name
2476: --
2477: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM');
2478: fnd_message.set_token('PROC',l_proc);
2479: fnd_message.set_token('FORMULA',p_rule_id);
2480: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
2481: fnd_message.raise_error;
2482: --
2483: end if;

Line 2480: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);

2476: --
2477: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM');
2478: fnd_message.set_token('PROC',l_proc);
2479: fnd_message.set_token('FORMULA',p_rule_id);
2480: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
2481: fnd_message.raise_error;
2482: --
2483: end if;
2484: if (l_mnl_dt is not null or

Line 2481: fnd_message.raise_error;

2477: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM');
2478: fnd_message.set_token('PROC',l_proc);
2479: fnd_message.set_token('FORMULA',p_rule_id);
2480: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
2481: fnd_message.raise_error;
2482: --
2483: end if;
2484: if (l_mnl_dt is not null or
2485: (l_ptnl_ler_for_per_stat_cd is not null and l_ptnl_ler_for_per_stat_cd = 'MNL')) then

Line 2497: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');

2493: exception
2494: --
2495: when others then
2496: --
2497: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2498: fnd_message.set_token('PROC',l_proc);
2499: fnd_message.set_token('FORMULA',p_rule_id);
2500: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
2501: fnd_message.raise_error;

Line 2498: fnd_message.set_token('PROC',l_proc);

2494: --
2495: when others then
2496: --
2497: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2498: fnd_message.set_token('PROC',l_proc);
2499: fnd_message.set_token('FORMULA',p_rule_id);
2500: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
2501: fnd_message.raise_error;
2502: --

Line 2499: fnd_message.set_token('FORMULA',p_rule_id);

2495: when others then
2496: --
2497: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2498: fnd_message.set_token('PROC',l_proc);
2499: fnd_message.set_token('FORMULA',p_rule_id);
2500: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
2501: fnd_message.raise_error;
2502: --
2503: end;

Line 2500: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);

2496: --
2497: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2498: fnd_message.set_token('PROC',l_proc);
2499: fnd_message.set_token('FORMULA',p_rule_id);
2500: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
2501: fnd_message.raise_error;
2502: --
2503: end;
2504: --

Line 2501: fnd_message.raise_error;

2497: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2498: fnd_message.set_token('PROC',l_proc);
2499: fnd_message.set_token('FORMULA',p_rule_id);
2500: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
2501: fnd_message.raise_error;
2502: --
2503: end;
2504: --
2505: end loop;

Line 2512: fnd_message.set_name('BEN','BEN_92143_LIFE_EVENT_HAPPENED');

2508: -- hr_utility.set_location('life_event_status_code '||l_ptnl_ler_for_per_stat_cd, 15);
2509: --
2510: if l_happened not in ('Y','N') then
2511: --
2512: fnd_message.set_name('BEN','BEN_92143_LIFE_EVENT_HAPPENED');
2513: fnd_message.set_token('PROC',l_proc);
2514: fnd_message.raise_error;
2515: --
2516: end if;

Line 2513: fnd_message.set_token('PROC',l_proc);

2509: --
2510: if l_happened not in ('Y','N') then
2511: --
2512: fnd_message.set_name('BEN','BEN_92143_LIFE_EVENT_HAPPENED');
2513: fnd_message.set_token('PROC',l_proc);
2514: fnd_message.raise_error;
2515: --
2516: end if;
2517: --

Line 2514: fnd_message.raise_error;

2510: if l_happened not in ('Y','N') then
2511: --
2512: fnd_message.set_name('BEN','BEN_92143_LIFE_EVENT_HAPPENED');
2513: fnd_message.set_token('PROC',l_proc);
2514: fnd_message.raise_error;
2515: --
2516: end if;
2517: --
2518: if l_happened = 'Y' then

Line 2558: fnd_message.set_name('BEN','BEN_92162_INV_PPL_STCD_TRANS');

2554:
2555: -- Test for valid l_ptnl_ler_for_per_stat_cd
2556: if l_ptnl_ler_for_per_stat_cd not in ('DTCTD','MNL','UNPROCD') then
2557: -- hr_utility.set_location('Invalid stat code returned from rule.',10);
2558: fnd_message.set_name('BEN','BEN_92162_INV_PPL_STCD_TRANS');
2559: fnd_message.raise_error;
2560: end if;
2561:
2562: --

Line 2559: fnd_message.raise_error;

2555: -- Test for valid l_ptnl_ler_for_per_stat_cd
2556: if l_ptnl_ler_for_per_stat_cd not in ('DTCTD','MNL','UNPROCD') then
2557: -- hr_utility.set_location('Invalid stat code returned from rule.',10);
2558: fnd_message.set_name('BEN','BEN_92162_INV_PPL_STCD_TRANS');
2559: fnd_message.raise_error;
2560: end if;
2561:
2562: --
2563: -- First lets create the new ptnl ler for per

Line 2868: fnd_message.set_name('BEN','BEN_91794_DUP_WINNERS');

2864: if l_num_winners > 1 then
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';

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 2874: fnd_message.set_name('BEN','BEN_91794_DUP_WINNERS');

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);
2878: raise ben_manage_life_events.g_record_error;

Line 2875: fnd_message.set_token('PROC',l_proc);

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);
2878: raise ben_manage_life_events.g_record_error;
2879: --

Line 2876: fnd_message.set_token('PERSON_ID',p_person_id);

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);
2878: raise ben_manage_life_events.g_record_error;
2879: --
2880: -- No winners, but more than one potential?

Line 2877: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

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);
2878: raise ben_manage_life_events.g_record_error;
2879: --
2880: -- No winners, but more than one potential?
2881: --

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 2892: fnd_message.set_name('BEN','BEN_92337_DUPLICATE_PTNL_LE');

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);
2896: raise ben_manage_life_events.g_record_error;

Line 2893: fnd_message.set_token('PROC',l_proc);

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);
2896: raise ben_manage_life_events.g_record_error;
2897: --

Line 2894: fnd_message.set_token('PERSON_ID',p_person_id);

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);
2896: raise ben_manage_life_events.g_record_error;
2897: --
2898: elsif l_num_winners = 1 then

Line 2895: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

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);
2896: raise ben_manage_life_events.g_record_error;
2897: --
2898: elsif l_num_winners = 1 then
2899: --

Line 2945: fnd_message.set_name('BEN','BEN_92144_NO_LIFE_EVENTS');

2941: l_win_ler_name := l_ler_name;
2942: --
2943: elsif l_num_recs = 0 then
2944: --
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;

Line 2946: fnd_message.set_token('PROC',l_proc);

2942: --
2943: elsif l_num_recs = 0 then
2944: --
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: --

Line 2947: fnd_message.set_token('PERSON_ID',p_person_id);

2943: elsif l_num_recs = 0 then
2944: --
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;

Line 2948: fnd_message.set_token('LF_EVT_OCRD_DT',p_lf_evt_ocrd_dt);

2944: --
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: --

Line 2970: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');

2966: l_mnl_savepoint_established := false;
2967: l_mnl_savepoint_preestablish:=false;
2968: end if;
2969: ---
2970: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
2971: fnd_message.set_token('LE_NAME',l_win_ler_name);
2972: fnd_message.set_token('PROC',l_proc);
2973: benutils.write(p_text => fnd_message.get);
2974: -- For BENAUTHE retreival purpose.

Line 2971: fnd_message.set_token('LE_NAME',l_win_ler_name);

2967: l_mnl_savepoint_preestablish:=false;
2968: end if;
2969: ---
2970: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
2971: fnd_message.set_token('LE_NAME',l_win_ler_name);
2972: fnd_message.set_token('PROC',l_proc);
2973: benutils.write(p_text => fnd_message.get);
2974: -- For BENAUTHE retreival purpose.
2975: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');

Line 2972: fnd_message.set_token('PROC',l_proc);

2968: end if;
2969: ---
2970: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
2971: fnd_message.set_token('LE_NAME',l_win_ler_name);
2972: fnd_message.set_token('PROC',l_proc);
2973: benutils.write(p_text => fnd_message.get);
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);

Line 2973: benutils.write(p_text => fnd_message.get);

2969: ---
2970: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
2971: fnd_message.set_token('LE_NAME',l_win_ler_name);
2972: fnd_message.set_token('PROC',l_proc);
2973: benutils.write(p_text => fnd_message.get);
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);

Line 2975: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');

2971: fnd_message.set_token('LE_NAME',l_win_ler_name);
2972: fnd_message.set_token('PROC',l_proc);
2973: benutils.write(p_text => fnd_message.get);
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: --

Line 2976: fnd_message.set_token('LE_NAME',l_win_ler_name);

2972: fnd_message.set_token('PROC',l_proc);
2973: benutils.write(p_text => fnd_message.get);
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;

Line 2977: fnd_message.set_token('PROC',l_proc);

2973: benutils.write(p_text => fnd_message.get);
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: --

Line 3038: fnd_message.set_name('BEN','BEN_92144_NO_LIFE_EVENTS');

3034: --
3035: if l_min_lf_evt_ocrd_dt is null then
3036: --
3037: close c1;
3038: fnd_message.set_name('BEN','BEN_92144_NO_LIFE_EVENTS');
3039: fnd_message.set_token('PROC',l_proc);
3040: fnd_message.set_token('PERSON_ID',p_person_id);
3041: fnd_message.set_token('LF_EVT_OCRD_DT',l_min_lf_evt_ocrd_dt);
3042: benutils.write(p_text => fnd_message.get);

Line 3039: fnd_message.set_token('PROC',l_proc);

3035: if l_min_lf_evt_ocrd_dt is null then
3036: --
3037: close c1;
3038: fnd_message.set_name('BEN','BEN_92144_NO_LIFE_EVENTS');
3039: fnd_message.set_token('PROC',l_proc);
3040: fnd_message.set_token('PERSON_ID',p_person_id);
3041: fnd_message.set_token('LF_EVT_OCRD_DT',l_min_lf_evt_ocrd_dt);
3042: benutils.write(p_text => fnd_message.get);
3043: -- For BENAUTHE retreival purpose.

Line 3040: fnd_message.set_token('PERSON_ID',p_person_id);

3036: --
3037: close c1;
3038: fnd_message.set_name('BEN','BEN_92144_NO_LIFE_EVENTS');
3039: fnd_message.set_token('PROC',l_proc);
3040: fnd_message.set_token('PERSON_ID',p_person_id);
3041: fnd_message.set_token('LF_EVT_OCRD_DT',l_min_lf_evt_ocrd_dt);
3042: benutils.write(p_text => fnd_message.get);
3043: -- For BENAUTHE retreival purpose.
3044: fnd_message.set_name('BEN','BEN_92144_NO_LIFE_EVENTS');

Line 3041: fnd_message.set_token('LF_EVT_OCRD_DT',l_min_lf_evt_ocrd_dt);

3037: close c1;
3038: fnd_message.set_name('BEN','BEN_92144_NO_LIFE_EVENTS');
3039: fnd_message.set_token('PROC',l_proc);
3040: fnd_message.set_token('PERSON_ID',p_person_id);
3041: fnd_message.set_token('LF_EVT_OCRD_DT',l_min_lf_evt_ocrd_dt);
3042: benutils.write(p_text => fnd_message.get);
3043: -- For BENAUTHE retreival purpose.
3044: fnd_message.set_name('BEN','BEN_92144_NO_LIFE_EVENTS');
3045: fnd_message.set_token('PROC',l_proc);

Line 3042: benutils.write(p_text => fnd_message.get);

3038: fnd_message.set_name('BEN','BEN_92144_NO_LIFE_EVENTS');
3039: fnd_message.set_token('PROC',l_proc);
3040: fnd_message.set_token('PERSON_ID',p_person_id);
3041: fnd_message.set_token('LF_EVT_OCRD_DT',l_min_lf_evt_ocrd_dt);
3042: benutils.write(p_text => fnd_message.get);
3043: -- For BENAUTHE retreival purpose.
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);

Line 3044: fnd_message.set_name('BEN','BEN_92144_NO_LIFE_EVENTS');

3040: fnd_message.set_token('PERSON_ID',p_person_id);
3041: fnd_message.set_token('LF_EVT_OCRD_DT',l_min_lf_evt_ocrd_dt);
3042: benutils.write(p_text => fnd_message.get);
3043: -- For BENAUTHE retreival purpose.
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;

Line 3045: fnd_message.set_token('PROC',l_proc);

3041: fnd_message.set_token('LF_EVT_OCRD_DT',l_min_lf_evt_ocrd_dt);
3042: benutils.write(p_text => fnd_message.get);
3043: -- For BENAUTHE retreival purpose.
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: --

Line 3046: fnd_message.set_token('PERSON_ID',p_person_id);

3042: benutils.write(p_text => fnd_message.get);
3043: -- For BENAUTHE retreival purpose.
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;

Line 3047: fnd_message.set_token('LF_EVT_OCRD_DT',l_min_lf_evt_ocrd_dt);

3043: -- For BENAUTHE retreival purpose.
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: --

Line 3095: fnd_message.set_name('BEN','BEN_94209_MAN_LER_EXISTIS');

3091: -- stop the process.
3092: --
3093: if l_potent.ptnl_ler_for_per_stat_cd = 'MNL' then
3094: --
3095: fnd_message.set_name('BEN','BEN_94209_MAN_LER_EXISTIS');
3096: -- fnd_message.set_token('LE_NAME',l_potent.name);
3097: -- fnd_message.set_token('PROC',l_proc);
3098: benutils.write(p_text => fnd_message.get);
3099: -- For BENAUTHE retreival purpose.

Line 3096: -- fnd_message.set_token('LE_NAME',l_potent.name);

3092: --
3093: if l_potent.ptnl_ler_for_per_stat_cd = 'MNL' then
3094: --
3095: fnd_message.set_name('BEN','BEN_94209_MAN_LER_EXISTIS');
3096: -- fnd_message.set_token('LE_NAME',l_potent.name);
3097: -- fnd_message.set_token('PROC',l_proc);
3098: benutils.write(p_text => fnd_message.get);
3099: -- For BENAUTHE retreival purpose.
3100: fnd_message.set_name('BEN','BEN_94209_MAN_LER_EXISTIS');

Line 3097: -- fnd_message.set_token('PROC',l_proc);

3093: if l_potent.ptnl_ler_for_per_stat_cd = 'MNL' then
3094: --
3095: fnd_message.set_name('BEN','BEN_94209_MAN_LER_EXISTIS');
3096: -- fnd_message.set_token('LE_NAME',l_potent.name);
3097: -- fnd_message.set_token('PROC',l_proc);
3098: benutils.write(p_text => fnd_message.get);
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);

Line 3098: benutils.write(p_text => fnd_message.get);

3094: --
3095: fnd_message.set_name('BEN','BEN_94209_MAN_LER_EXISTIS');
3096: -- fnd_message.set_token('LE_NAME',l_potent.name);
3097: -- fnd_message.set_token('PROC',l_proc);
3098: benutils.write(p_text => fnd_message.get);
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);

Line 3100: fnd_message.set_name('BEN','BEN_94209_MAN_LER_EXISTIS');

3096: -- fnd_message.set_token('LE_NAME',l_potent.name);
3097: -- fnd_message.set_token('PROC',l_proc);
3098: benutils.write(p_text => fnd_message.get);
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: --

Line 3101: -- fnd_message.set_token('LE_NAME',l_potent.name);

3097: -- fnd_message.set_token('PROC',l_proc);
3098: benutils.write(p_text => fnd_message.get);
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;

Line 3102: -- fnd_message.set_token('PROC',l_proc);

3098: benutils.write(p_text => fnd_message.get);
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: --

Line 3149: fnd_message.set_name('BEN','BEN_92536_PERSON_HAS_NO_PPL');

3145: -- Person already has a scheduled life event that has been run on this day
3146: -- We don't want to add to the error count so lets just process the next
3147: -- person. The life event could be strtd or procd we don't care.
3148: --
3149: fnd_message.set_name('BEN','BEN_92536_PERSON_HAS_NO_PPL');
3150: fnd_message.set_token('PERSON_ID',p_person_id);
3151: fnd_message.set_token('PROC',l_proc);
3152: benutils.write(fnd_message.get);
3153: --

Line 3150: fnd_message.set_token('PERSON_ID',p_person_id);

3146: -- We don't want to add to the error count so lets just process the next
3147: -- person. The life event could be strtd or procd we don't care.
3148: --
3149: fnd_message.set_name('BEN','BEN_92536_PERSON_HAS_NO_PPL');
3150: fnd_message.set_token('PERSON_ID',p_person_id);
3151: fnd_message.set_token('PROC',l_proc);
3152: benutils.write(fnd_message.get);
3153: --
3154: -- For BENAUTHE

Line 3151: fnd_message.set_token('PROC',l_proc);

3147: -- person. The life event could be strtd or procd we don't care.
3148: --
3149: fnd_message.set_name('BEN','BEN_92536_PERSON_HAS_NO_PPL');
3150: fnd_message.set_token('PERSON_ID',p_person_id);
3151: fnd_message.set_token('PROC',l_proc);
3152: benutils.write(fnd_message.get);
3153: --
3154: -- For BENAUTHE
3155: --

Line 3152: benutils.write(fnd_message.get);

3148: --
3149: fnd_message.set_name('BEN','BEN_92536_PERSON_HAS_NO_PPL');
3150: fnd_message.set_token('PERSON_ID',p_person_id);
3151: fnd_message.set_token('PROC',l_proc);
3152: benutils.write(fnd_message.get);
3153: --
3154: -- For BENAUTHE
3155: --
3156: fnd_message.set_name('BEN','BEN_92536_PERSON_HAS_NO_PPL');

Line 3156: fnd_message.set_name('BEN','BEN_92536_PERSON_HAS_NO_PPL');

3152: benutils.write(fnd_message.get);
3153: --
3154: -- For BENAUTHE
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: --

Line 3157: fnd_message.set_token('PERSON_ID',p_person_id);

3153: --
3154: -- For BENAUTHE
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;

Line 3158: fnd_message.set_token('PROC',l_proc);

3154: -- For BENAUTHE
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: --

Line 3256: fnd_message.set_name('BEN','BEN_92145_MODE_LE_DIFFER');

3252: savepoint process_life_event_savepoint;
3253: --
3254: end if;
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: --

Line 3257: fnd_message.set_token('MODE',l_use_mode);

3253: --
3254: end if;
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;

Line 3382: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');

3378: ,p_request_id => fnd_global.conc_request_id
3379: ,p_program_update_date => sysdate
3380: ,p_mnl_dt => p_effective_date);
3381: --
3382: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
3383: fnd_message.set_token('LE_NAME',l_potent.name);
3384: fnd_message.set_token('PROC',l_proc);
3385: benutils.write(p_text => fnd_message.get);
3386: -- For BENAUTHE retreival purpose.

Line 3383: fnd_message.set_token('LE_NAME',l_potent.name);

3379: ,p_program_update_date => sysdate
3380: ,p_mnl_dt => p_effective_date);
3381: --
3382: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
3383: fnd_message.set_token('LE_NAME',l_potent.name);
3384: fnd_message.set_token('PROC',l_proc);
3385: benutils.write(p_text => fnd_message.get);
3386: -- For BENAUTHE retreival purpose.
3387: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');

Line 3384: fnd_message.set_token('PROC',l_proc);

3380: ,p_mnl_dt => p_effective_date);
3381: --
3382: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
3383: fnd_message.set_token('LE_NAME',l_potent.name);
3384: fnd_message.set_token('PROC',l_proc);
3385: benutils.write(p_text => fnd_message.get);
3386: -- For BENAUTHE retreival purpose.
3387: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
3388: fnd_message.set_token('LE_NAME',l_potent.name);

Line 3385: benutils.write(p_text => fnd_message.get);

3381: --
3382: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
3383: fnd_message.set_token('LE_NAME',l_potent.name);
3384: fnd_message.set_token('PROC',l_proc);
3385: benutils.write(p_text => fnd_message.get);
3386: -- For BENAUTHE retreival purpose.
3387: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
3388: fnd_message.set_token('LE_NAME',l_potent.name);
3389: fnd_message.set_token('PROC',l_proc);

Line 3387: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');

3383: fnd_message.set_token('LE_NAME',l_potent.name);
3384: fnd_message.set_token('PROC',l_proc);
3385: benutils.write(p_text => fnd_message.get);
3386: -- For BENAUTHE retreival purpose.
3387: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
3388: fnd_message.set_token('LE_NAME',l_potent.name);
3389: fnd_message.set_token('PROC',l_proc);
3390: g_rec.person_id := p_person_id;
3391: g_rec.ler_id := l_ptnl_rec.ler_id;

Line 3388: fnd_message.set_token('LE_NAME',l_potent.name);

3384: fnd_message.set_token('PROC',l_proc);
3385: benutils.write(p_text => fnd_message.get);
3386: -- For BENAUTHE retreival purpose.
3387: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
3388: fnd_message.set_token('LE_NAME',l_potent.name);
3389: fnd_message.set_token('PROC',l_proc);
3390: g_rec.person_id := p_person_id;
3391: g_rec.ler_id := l_ptnl_rec.ler_id;
3392: g_rec.lf_evt_ocrd_dt := l_ptnl_rec.lf_evt_ocrd_dt;

Line 3389: fnd_message.set_token('PROC',l_proc);

3385: benutils.write(p_text => fnd_message.get);
3386: -- For BENAUTHE retreival purpose.
3387: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
3388: fnd_message.set_token('LE_NAME',l_potent.name);
3389: fnd_message.set_token('PROC',l_proc);
3390: g_rec.person_id := p_person_id;
3391: g_rec.ler_id := l_ptnl_rec.ler_id;
3392: g_rec.lf_evt_ocrd_dt := l_ptnl_rec.lf_evt_ocrd_dt;
3393: g_rec.replcd_flag := 'N';

Line 3482: fnd_message.set_name('BEN','BEN_91797_PTNL_AFTER_ACTIVE');

3478: else
3479: --
3480: -- Potential is after per in ler so leave ptnl as is
3481: --
3482: fnd_message.set_name('BEN','BEN_91797_PTNL_AFTER_ACTIVE');
3483: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',l_ptnl_rec.lf_evt_ocrd_dt);
3484: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',
3485: l_current_per_in_ler.lf_evt_ocrd_dt);
3486: benutils.write(p_text => fnd_message.get);

Line 3483: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',l_ptnl_rec.lf_evt_ocrd_dt);

3479: --
3480: -- Potential is after per in ler so leave ptnl as is
3481: --
3482: fnd_message.set_name('BEN','BEN_91797_PTNL_AFTER_ACTIVE');
3483: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',l_ptnl_rec.lf_evt_ocrd_dt);
3484: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',
3485: l_current_per_in_ler.lf_evt_ocrd_dt);
3486: benutils.write(p_text => fnd_message.get);
3487: --

Line 3484: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',

3480: -- Potential is after per in ler so leave ptnl as is
3481: --
3482: fnd_message.set_name('BEN','BEN_91797_PTNL_AFTER_ACTIVE');
3483: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',l_ptnl_rec.lf_evt_ocrd_dt);
3484: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',
3485: l_current_per_in_ler.lf_evt_ocrd_dt);
3486: benutils.write(p_text => fnd_message.get);
3487: --
3488: g_rec.person_id := p_person_id;

Line 3486: benutils.write(p_text => fnd_message.get);

3482: fnd_message.set_name('BEN','BEN_91797_PTNL_AFTER_ACTIVE');
3483: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',l_ptnl_rec.lf_evt_ocrd_dt);
3484: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',
3485: l_current_per_in_ler.lf_evt_ocrd_dt);
3486: benutils.write(p_text => fnd_message.get);
3487: --
3488: g_rec.person_id := p_person_id;
3489: g_rec.ler_id := l_ptnl_rec.ler_id;
3490: g_rec.lf_evt_ocrd_dt := l_ptnl_rec.lf_evt_ocrd_dt;

Line 3509: fnd_message.set_name('BEN','BEN_91797_PTNL_AFTER_ACTIVE');

3505: --
3506: benutils.write(p_rec => g_rec);
3507: --
3508: -- For BENAUTHE retreival purpose.
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;

Line 3510: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',l_ptnl_rec.lf_evt_ocrd_dt);

3506: benutils.write(p_rec => g_rec);
3507: --
3508: -- For BENAUTHE retreival purpose.
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: --

Line 3511: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',

3507: --
3508: -- For BENAUTHE retreival purpose.
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;

Line 3664: fnd_message.set_name('BEN','BEN_94025_IREC_OFFER_PROCESSED');

3660: -- Offer is already processed, so you can't initiate the offer again.
3661: -- Error out.
3662: --
3663: -- hr_utility.set_location('** ERROR SUP',9909);
3664: fnd_message.set_name('BEN','BEN_94025_IREC_OFFER_PROCESSED');
3665: benutils.write(p_text => fnd_message.get);
3666: --
3667: g_rec.person_id := p_person_id;
3668: g_rec.ler_id := l_pil_rec.ler_id;

Line 3665: benutils.write(p_text => fnd_message.get);

3661: -- Error out.
3662: --
3663: -- hr_utility.set_location('** ERROR SUP',9909);
3664: fnd_message.set_name('BEN','BEN_94025_IREC_OFFER_PROCESSED');
3665: benutils.write(p_text => fnd_message.get);
3666: --
3667: g_rec.person_id := p_person_id;
3668: g_rec.ler_id := l_pil_rec.ler_id;
3669: g_rec.lf_evt_ocrd_dt := p_lf_evt_ocrd_dt;

Line 3689: fnd_message.set_name('BEN','BEN_94025_IREC_OFFER_PROCESSED');

3685: benutils.write(p_rec => g_rec);
3686: --
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

Line 3690: benutils.write(p_text => fnd_message.get);

3686: --
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