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

2366: --
2367: -- Account for cases where formula returns an unknown
2368: -- variable name
2369: --
2370: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM');
2371: fnd_message.set_token('PROC',l_proc);
2372: fnd_message.set_token('FORMULA',p_rule_id);
2373: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
2374: fnd_message.raise_error;

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

2367: -- Account for cases where formula returns an unknown
2368: -- variable name
2369: --
2370: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM');
2371: fnd_message.set_token('PROC',l_proc);
2372: fnd_message.set_token('FORMULA',p_rule_id);
2373: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
2374: fnd_message.raise_error;
2375: --

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

2368: -- variable name
2369: --
2370: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM');
2371: fnd_message.set_token('PROC',l_proc);
2372: fnd_message.set_token('FORMULA',p_rule_id);
2373: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
2374: fnd_message.raise_error;
2375: --
2376: end if;

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

2369: --
2370: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM');
2371: fnd_message.set_token('PROC',l_proc);
2372: fnd_message.set_token('FORMULA',p_rule_id);
2373: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
2374: fnd_message.raise_error;
2375: --
2376: end if;
2377: if (l_mnl_dt is not null or

Line 2374: fnd_message.raise_error;

2370: fnd_message.set_name('BEN','BEN_92310_FORMULA_RET_PARAM');
2371: fnd_message.set_token('PROC',l_proc);
2372: fnd_message.set_token('FORMULA',p_rule_id);
2373: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
2374: fnd_message.raise_error;
2375: --
2376: end if;
2377: if (l_mnl_dt is not null or
2378: (l_ptnl_ler_for_per_stat_cd is not null and l_ptnl_ler_for_per_stat_cd = 'MNL')) then

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

2386: exception
2387: --
2388: when others then
2389: --
2390: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2391: fnd_message.set_token('PROC',l_proc);
2392: fnd_message.set_token('FORMULA',p_rule_id);
2393: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
2394: fnd_message.raise_error;

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

2387: --
2388: when others then
2389: --
2390: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2391: fnd_message.set_token('PROC',l_proc);
2392: fnd_message.set_token('FORMULA',p_rule_id);
2393: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
2394: fnd_message.raise_error;
2395: --

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

2388: when others then
2389: --
2390: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2391: fnd_message.set_token('PROC',l_proc);
2392: fnd_message.set_token('FORMULA',p_rule_id);
2393: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
2394: fnd_message.raise_error;
2395: --
2396: end;

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

2389: --
2390: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2391: fnd_message.set_token('PROC',l_proc);
2392: fnd_message.set_token('FORMULA',p_rule_id);
2393: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
2394: fnd_message.raise_error;
2395: --
2396: end;
2397: --

Line 2394: fnd_message.raise_error;

2390: fnd_message.set_name('BEN','BEN_92311_FORMULA_VAL_PARAM');
2391: fnd_message.set_token('PROC',l_proc);
2392: fnd_message.set_token('FORMULA',p_rule_id);
2393: fnd_message.set_token('PARAMETER',l_outputs(l_count).name);
2394: fnd_message.raise_error;
2395: --
2396: end;
2397: --
2398: end loop;

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

2401: -- hr_utility.set_location('life_event_status_code '||l_ptnl_ler_for_per_stat_cd, 15);
2402: --
2403: if l_happened not in ('Y','N') then
2404: --
2405: fnd_message.set_name('BEN','BEN_92143_LIFE_EVENT_HAPPENED');
2406: fnd_message.set_token('PROC',l_proc);
2407: fnd_message.raise_error;
2408: --
2409: end if;

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

2402: --
2403: if l_happened not in ('Y','N') then
2404: --
2405: fnd_message.set_name('BEN','BEN_92143_LIFE_EVENT_HAPPENED');
2406: fnd_message.set_token('PROC',l_proc);
2407: fnd_message.raise_error;
2408: --
2409: end if;
2410: --

Line 2407: fnd_message.raise_error;

2403: if l_happened not in ('Y','N') then
2404: --
2405: fnd_message.set_name('BEN','BEN_92143_LIFE_EVENT_HAPPENED');
2406: fnd_message.set_token('PROC',l_proc);
2407: fnd_message.raise_error;
2408: --
2409: end if;
2410: --
2411: if l_happened = 'Y' then

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

2447:
2448: -- Test for valid l_ptnl_ler_for_per_stat_cd
2449: if l_ptnl_ler_for_per_stat_cd not in ('DTCTD','MNL','UNPROCD') then
2450: -- hr_utility.set_location('Invalid stat code returned from rule.',10);
2451: fnd_message.set_name('BEN','BEN_92162_INV_PPL_STCD_TRANS');
2452: fnd_message.raise_error;
2453: end if;
2454:
2455: --

Line 2452: fnd_message.raise_error;

2448: -- Test for valid l_ptnl_ler_for_per_stat_cd
2449: if l_ptnl_ler_for_per_stat_cd not in ('DTCTD','MNL','UNPROCD') then
2450: -- hr_utility.set_location('Invalid stat code returned from rule.',10);
2451: fnd_message.set_name('BEN','BEN_92162_INV_PPL_STCD_TRANS');
2452: fnd_message.raise_error;
2453: end if;
2454:
2455: --
2456: -- First lets create the new ptnl ler for per

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

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

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

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

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

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

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

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

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

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);
2748: raise ben_manage_life_events.g_record_error;
2749: --
2750: -- No winners, but more than one potential?
2751: --

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

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

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

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

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

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);
2766: raise ben_manage_life_events.g_record_error;
2767: --
2768: elsif l_num_winners = 1 then

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

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);
2766: raise ben_manage_life_events.g_record_error;
2767: --
2768: elsif l_num_winners = 1 then
2769: --

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

2811: l_win_ler_name := l_ler_name;
2812: --
2813: elsif l_num_recs = 0 then
2814: --
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;

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

2812: --
2813: elsif l_num_recs = 0 then
2814: --
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: --

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

2813: elsif l_num_recs = 0 then
2814: --
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;

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

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

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

2836: l_mnl_savepoint_established := false;
2837: l_mnl_savepoint_preestablish:=false;
2838: end if;
2839: ---
2840: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
2841: fnd_message.set_token('LE_NAME',l_win_ler_name);
2842: fnd_message.set_token('PROC',l_proc);
2843: benutils.write(p_text => fnd_message.get);
2844: -- For BENAUTHE retreival purpose.

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

2837: l_mnl_savepoint_preestablish:=false;
2838: end if;
2839: ---
2840: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
2841: fnd_message.set_token('LE_NAME',l_win_ler_name);
2842: fnd_message.set_token('PROC',l_proc);
2843: benutils.write(p_text => fnd_message.get);
2844: -- For BENAUTHE retreival purpose.
2845: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');

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

2838: end if;
2839: ---
2840: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
2841: fnd_message.set_token('LE_NAME',l_win_ler_name);
2842: fnd_message.set_token('PROC',l_proc);
2843: benutils.write(p_text => fnd_message.get);
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);

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

2839: ---
2840: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
2841: fnd_message.set_token('LE_NAME',l_win_ler_name);
2842: fnd_message.set_token('PROC',l_proc);
2843: benutils.write(p_text => fnd_message.get);
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);

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

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

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

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

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

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

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

2904: --
2905: if l_min_lf_evt_ocrd_dt is null then
2906: --
2907: close c1;
2908: fnd_message.set_name('BEN','BEN_92144_NO_LIFE_EVENTS');
2909: fnd_message.set_token('PROC',l_proc);
2910: fnd_message.set_token('PERSON_ID',p_person_id);
2911: fnd_message.set_token('LF_EVT_OCRD_DT',l_min_lf_evt_ocrd_dt);
2912: benutils.write(p_text => fnd_message.get);

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

2905: if l_min_lf_evt_ocrd_dt is null then
2906: --
2907: close c1;
2908: fnd_message.set_name('BEN','BEN_92144_NO_LIFE_EVENTS');
2909: fnd_message.set_token('PROC',l_proc);
2910: fnd_message.set_token('PERSON_ID',p_person_id);
2911: fnd_message.set_token('LF_EVT_OCRD_DT',l_min_lf_evt_ocrd_dt);
2912: benutils.write(p_text => fnd_message.get);
2913: -- For BENAUTHE retreival purpose.

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

2906: --
2907: close c1;
2908: fnd_message.set_name('BEN','BEN_92144_NO_LIFE_EVENTS');
2909: fnd_message.set_token('PROC',l_proc);
2910: fnd_message.set_token('PERSON_ID',p_person_id);
2911: fnd_message.set_token('LF_EVT_OCRD_DT',l_min_lf_evt_ocrd_dt);
2912: benutils.write(p_text => fnd_message.get);
2913: -- For BENAUTHE retreival purpose.
2914: fnd_message.set_name('BEN','BEN_92144_NO_LIFE_EVENTS');

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

2907: close c1;
2908: fnd_message.set_name('BEN','BEN_92144_NO_LIFE_EVENTS');
2909: fnd_message.set_token('PROC',l_proc);
2910: fnd_message.set_token('PERSON_ID',p_person_id);
2911: fnd_message.set_token('LF_EVT_OCRD_DT',l_min_lf_evt_ocrd_dt);
2912: benutils.write(p_text => fnd_message.get);
2913: -- For BENAUTHE retreival purpose.
2914: fnd_message.set_name('BEN','BEN_92144_NO_LIFE_EVENTS');
2915: fnd_message.set_token('PROC',l_proc);

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

2908: fnd_message.set_name('BEN','BEN_92144_NO_LIFE_EVENTS');
2909: fnd_message.set_token('PROC',l_proc);
2910: fnd_message.set_token('PERSON_ID',p_person_id);
2911: fnd_message.set_token('LF_EVT_OCRD_DT',l_min_lf_evt_ocrd_dt);
2912: benutils.write(p_text => fnd_message.get);
2913: -- For BENAUTHE retreival purpose.
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);

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

2910: fnd_message.set_token('PERSON_ID',p_person_id);
2911: fnd_message.set_token('LF_EVT_OCRD_DT',l_min_lf_evt_ocrd_dt);
2912: benutils.write(p_text => fnd_message.get);
2913: -- For BENAUTHE retreival purpose.
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;

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

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

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

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

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

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

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

2961: -- stop the process.
2962: --
2963: if l_potent.ptnl_ler_for_per_stat_cd = 'MNL' then
2964: --
2965: fnd_message.set_name('BEN','BEN_94209_MAN_LER_EXISTIS');
2966: -- fnd_message.set_token('LE_NAME',l_potent.name);
2967: -- fnd_message.set_token('PROC',l_proc);
2968: benutils.write(p_text => fnd_message.get);
2969: -- For BENAUTHE retreival purpose.

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

2962: --
2963: if l_potent.ptnl_ler_for_per_stat_cd = 'MNL' then
2964: --
2965: fnd_message.set_name('BEN','BEN_94209_MAN_LER_EXISTIS');
2966: -- fnd_message.set_token('LE_NAME',l_potent.name);
2967: -- fnd_message.set_token('PROC',l_proc);
2968: benutils.write(p_text => fnd_message.get);
2969: -- For BENAUTHE retreival purpose.
2970: fnd_message.set_name('BEN','BEN_94209_MAN_LER_EXISTIS');

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

2963: if l_potent.ptnl_ler_for_per_stat_cd = 'MNL' then
2964: --
2965: fnd_message.set_name('BEN','BEN_94209_MAN_LER_EXISTIS');
2966: -- fnd_message.set_token('LE_NAME',l_potent.name);
2967: -- fnd_message.set_token('PROC',l_proc);
2968: benutils.write(p_text => fnd_message.get);
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);

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

2964: --
2965: fnd_message.set_name('BEN','BEN_94209_MAN_LER_EXISTIS');
2966: -- fnd_message.set_token('LE_NAME',l_potent.name);
2967: -- fnd_message.set_token('PROC',l_proc);
2968: benutils.write(p_text => fnd_message.get);
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);

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

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

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

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

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

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

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

3015: -- Person already has a scheduled life event that has been run on this day
3016: -- We don't want to add to the error count so lets just process the next
3017: -- person. The life event could be strtd or procd we don't care.
3018: --
3019: fnd_message.set_name('BEN','BEN_92536_PERSON_HAS_NO_PPL');
3020: fnd_message.set_token('PERSON_ID',p_person_id);
3021: fnd_message.set_token('PROC',l_proc);
3022: benutils.write(fnd_message.get);
3023: --

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

3016: -- We don't want to add to the error count so lets just process the next
3017: -- person. The life event could be strtd or procd we don't care.
3018: --
3019: fnd_message.set_name('BEN','BEN_92536_PERSON_HAS_NO_PPL');
3020: fnd_message.set_token('PERSON_ID',p_person_id);
3021: fnd_message.set_token('PROC',l_proc);
3022: benutils.write(fnd_message.get);
3023: --
3024: -- For BENAUTHE

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

3017: -- person. The life event could be strtd or procd we don't care.
3018: --
3019: fnd_message.set_name('BEN','BEN_92536_PERSON_HAS_NO_PPL');
3020: fnd_message.set_token('PERSON_ID',p_person_id);
3021: fnd_message.set_token('PROC',l_proc);
3022: benutils.write(fnd_message.get);
3023: --
3024: -- For BENAUTHE
3025: --

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

3018: --
3019: fnd_message.set_name('BEN','BEN_92536_PERSON_HAS_NO_PPL');
3020: fnd_message.set_token('PERSON_ID',p_person_id);
3021: fnd_message.set_token('PROC',l_proc);
3022: benutils.write(fnd_message.get);
3023: --
3024: -- For BENAUTHE
3025: --
3026: fnd_message.set_name('BEN','BEN_92536_PERSON_HAS_NO_PPL');

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

3022: benutils.write(fnd_message.get);
3023: --
3024: -- For BENAUTHE
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: --

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

3023: --
3024: -- For BENAUTHE
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;

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

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

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

3122: savepoint process_life_event_savepoint;
3123: --
3124: end if;
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: --

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

3123: --
3124: end if;
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;

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

3248: ,p_request_id => fnd_global.conc_request_id
3249: ,p_program_update_date => sysdate
3250: ,p_mnl_dt => p_effective_date);
3251: --
3252: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
3253: fnd_message.set_token('LE_NAME',l_potent.name);
3254: fnd_message.set_token('PROC',l_proc);
3255: benutils.write(p_text => fnd_message.get);
3256: -- For BENAUTHE retreival purpose.

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

3249: ,p_program_update_date => sysdate
3250: ,p_mnl_dt => p_effective_date);
3251: --
3252: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
3253: fnd_message.set_token('LE_NAME',l_potent.name);
3254: fnd_message.set_token('PROC',l_proc);
3255: benutils.write(p_text => fnd_message.get);
3256: -- For BENAUTHE retreival purpose.
3257: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');

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

3250: ,p_mnl_dt => p_effective_date);
3251: --
3252: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
3253: fnd_message.set_token('LE_NAME',l_potent.name);
3254: fnd_message.set_token('PROC',l_proc);
3255: benutils.write(p_text => fnd_message.get);
3256: -- For BENAUTHE retreival purpose.
3257: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
3258: fnd_message.set_token('LE_NAME',l_potent.name);

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

3251: --
3252: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
3253: fnd_message.set_token('LE_NAME',l_potent.name);
3254: fnd_message.set_token('PROC',l_proc);
3255: benutils.write(p_text => fnd_message.get);
3256: -- For BENAUTHE retreival purpose.
3257: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
3258: fnd_message.set_token('LE_NAME',l_potent.name);
3259: fnd_message.set_token('PROC',l_proc);

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

3253: fnd_message.set_token('LE_NAME',l_potent.name);
3254: fnd_message.set_token('PROC',l_proc);
3255: benutils.write(p_text => fnd_message.get);
3256: -- For BENAUTHE retreival purpose.
3257: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
3258: fnd_message.set_token('LE_NAME',l_potent.name);
3259: fnd_message.set_token('PROC',l_proc);
3260: g_rec.person_id := p_person_id;
3261: g_rec.ler_id := l_ptnl_rec.ler_id;

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

3254: fnd_message.set_token('PROC',l_proc);
3255: benutils.write(p_text => fnd_message.get);
3256: -- For BENAUTHE retreival purpose.
3257: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
3258: fnd_message.set_token('LE_NAME',l_potent.name);
3259: fnd_message.set_token('PROC',l_proc);
3260: g_rec.person_id := p_person_id;
3261: g_rec.ler_id := l_ptnl_rec.ler_id;
3262: g_rec.lf_evt_ocrd_dt := l_ptnl_rec.lf_evt_ocrd_dt;

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

3255: benutils.write(p_text => fnd_message.get);
3256: -- For BENAUTHE retreival purpose.
3257: fnd_message.set_name('BEN','BEN_92396_LIFE_EVENT_MANUAL');
3258: fnd_message.set_token('LE_NAME',l_potent.name);
3259: fnd_message.set_token('PROC',l_proc);
3260: g_rec.person_id := p_person_id;
3261: g_rec.ler_id := l_ptnl_rec.ler_id;
3262: g_rec.lf_evt_ocrd_dt := l_ptnl_rec.lf_evt_ocrd_dt;
3263: g_rec.replcd_flag := 'N';

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

3348: else
3349: --
3350: -- Potential is after per in ler so leave ptnl as is
3351: --
3352: fnd_message.set_name('BEN','BEN_91797_PTNL_AFTER_ACTIVE');
3353: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',l_ptnl_rec.lf_evt_ocrd_dt);
3354: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',
3355: l_current_per_in_ler.lf_evt_ocrd_dt);
3356: benutils.write(p_text => fnd_message.get);

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

3349: --
3350: -- Potential is after per in ler so leave ptnl as is
3351: --
3352: fnd_message.set_name('BEN','BEN_91797_PTNL_AFTER_ACTIVE');
3353: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',l_ptnl_rec.lf_evt_ocrd_dt);
3354: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',
3355: l_current_per_in_ler.lf_evt_ocrd_dt);
3356: benutils.write(p_text => fnd_message.get);
3357: --

Line 3354: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',

3350: -- Potential is after per in ler so leave ptnl as is
3351: --
3352: fnd_message.set_name('BEN','BEN_91797_PTNL_AFTER_ACTIVE');
3353: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',l_ptnl_rec.lf_evt_ocrd_dt);
3354: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',
3355: l_current_per_in_ler.lf_evt_ocrd_dt);
3356: benutils.write(p_text => fnd_message.get);
3357: --
3358: g_rec.person_id := p_person_id;

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

3352: fnd_message.set_name('BEN','BEN_91797_PTNL_AFTER_ACTIVE');
3353: fnd_message.set_token('PTNL_LF_EVT_OCRD_DT',l_ptnl_rec.lf_evt_ocrd_dt);
3354: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',
3355: l_current_per_in_ler.lf_evt_ocrd_dt);
3356: benutils.write(p_text => fnd_message.get);
3357: --
3358: g_rec.person_id := p_person_id;
3359: g_rec.ler_id := l_ptnl_rec.ler_id;
3360: g_rec.lf_evt_ocrd_dt := l_ptnl_rec.lf_evt_ocrd_dt;

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

3375: --
3376: benutils.write(p_rec => g_rec);
3377: --
3378: -- For BENAUTHE retreival purpose.
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;

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

3376: benutils.write(p_rec => g_rec);
3377: --
3378: -- For BENAUTHE retreival purpose.
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: --

Line 3381: fnd_message.set_token('ACTIVE_LF_EVT_OCRD_DT',

3377: --
3378: -- For BENAUTHE retreival purpose.
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;

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

3530: -- Offer is already processed, so you can't initiate the offer again.
3531: -- Error out.
3532: --
3533: -- hr_utility.set_location('** ERROR SUP',9909);
3534: fnd_message.set_name('BEN','BEN_94025_IREC_OFFER_PROCESSED');
3535: benutils.write(p_text => fnd_message.get);
3536: --
3537: g_rec.person_id := p_person_id;
3538: g_rec.ler_id := l_pil_rec.ler_id;

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

3531: -- Error out.
3532: --
3533: -- hr_utility.set_location('** ERROR SUP',9909);
3534: fnd_message.set_name('BEN','BEN_94025_IREC_OFFER_PROCESSED');
3535: benutils.write(p_text => fnd_message.get);
3536: --
3537: g_rec.person_id := p_person_id;
3538: g_rec.ler_id := l_pil_rec.ler_id;
3539: g_rec.lf_evt_ocrd_dt := p_lf_evt_ocrd_dt;

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

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

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

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