DBA Data[Home] [Help]

APPS.BEN_ENROLMENT_REQUIREMENTS2 dependencies on FND_MESSAGE

Line 62: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');

58: );
59: FETCH c_asg INTO l_asg_id, l_org_id;
60: IF c_asg%NOTFOUND THEN
61: CLOSE c_asg;
62: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
63: fnd_message.set_token('PROC', 'ben_enrolment_requirements2.get_asg_dets');
64: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
65: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_leodt));
66: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effdt));

Line 63: fnd_message.set_token('PROC', 'ben_enrolment_requirements2.get_asg_dets');

59: FETCH c_asg INTO l_asg_id, l_org_id;
60: IF c_asg%NOTFOUND THEN
61: CLOSE c_asg;
62: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
63: fnd_message.set_token('PROC', 'ben_enrolment_requirements2.get_asg_dets');
64: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
65: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_leodt));
66: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effdt));
67: RAISE ben_manage_life_events.g_record_error;

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

60: IF c_asg%NOTFOUND THEN
61: CLOSE c_asg;
62: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
63: fnd_message.set_token('PROC', 'ben_enrolment_requirements2.get_asg_dets');
64: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
65: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_leodt));
66: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effdt));
67: RAISE ben_manage_life_events.g_record_error;
68: END IF;

Line 65: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_leodt));

61: CLOSE c_asg;
62: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
63: fnd_message.set_token('PROC', 'ben_enrolment_requirements2.get_asg_dets');
64: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
65: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_leodt));
66: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effdt));
67: RAISE ben_manage_life_events.g_record_error;
68: END IF;
69: CLOSE c_asg;

Line 66: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effdt));

62: fnd_message.set_name('BEN', 'BEN_92106_PRTT_NO_ASGN');
63: fnd_message.set_token('PROC', 'ben_enrolment_requirements2.get_asg_dets');
64: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
65: fnd_message.set_token('LF_EVT_OCRD_DT', TO_CHAR(p_leodt));
66: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effdt));
67: RAISE ben_manage_life_events.g_record_error;
68: END IF;
69: CLOSE c_asg;
70: --

Line 159: fnd_message.set_name('BEN', 'BEN_91272_PER_IN_LER_MISSING');

155: --
156: IF c_per_in_ler_info%NOTFOUND THEN
157: CLOSE c_per_in_ler_info;
158: --
159: fnd_message.set_name('BEN', 'BEN_91272_PER_IN_LER_MISSING');
160: fnd_message.set_token('PROC', 'ben_enrolment_requirements2.get_perpiller_dets');
161: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
162: fnd_message.set_token('LER_ID', TO_CHAR(p_ler_id));
163: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effdt));

Line 160: fnd_message.set_token('PROC', 'ben_enrolment_requirements2.get_perpiller_dets');

156: IF c_per_in_ler_info%NOTFOUND THEN
157: CLOSE c_per_in_ler_info;
158: --
159: fnd_message.set_name('BEN', 'BEN_91272_PER_IN_LER_MISSING');
160: fnd_message.set_token('PROC', 'ben_enrolment_requirements2.get_perpiller_dets');
161: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
162: fnd_message.set_token('LER_ID', TO_CHAR(p_ler_id));
163: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effdt));
164: fnd_message.set_token('BG_ID', TO_CHAR(p_bgp_id));

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

157: CLOSE c_per_in_ler_info;
158: --
159: fnd_message.set_name('BEN', 'BEN_91272_PER_IN_LER_MISSING');
160: fnd_message.set_token('PROC', 'ben_enrolment_requirements2.get_perpiller_dets');
161: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
162: fnd_message.set_token('LER_ID', TO_CHAR(p_ler_id));
163: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effdt));
164: fnd_message.set_token('BG_ID', TO_CHAR(p_bgp_id));
165: RAISE ben_manage_life_events.g_record_error;

Line 162: fnd_message.set_token('LER_ID', TO_CHAR(p_ler_id));

158: --
159: fnd_message.set_name('BEN', 'BEN_91272_PER_IN_LER_MISSING');
160: fnd_message.set_token('PROC', 'ben_enrolment_requirements2.get_perpiller_dets');
161: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
162: fnd_message.set_token('LER_ID', TO_CHAR(p_ler_id));
163: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effdt));
164: fnd_message.set_token('BG_ID', TO_CHAR(p_bgp_id));
165: RAISE ben_manage_life_events.g_record_error;
166: --

Line 163: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effdt));

159: fnd_message.set_name('BEN', 'BEN_91272_PER_IN_LER_MISSING');
160: fnd_message.set_token('PROC', 'ben_enrolment_requirements2.get_perpiller_dets');
161: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
162: fnd_message.set_token('LER_ID', TO_CHAR(p_ler_id));
163: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effdt));
164: fnd_message.set_token('BG_ID', TO_CHAR(p_bgp_id));
165: RAISE ben_manage_life_events.g_record_error;
166: --
167: END IF;

Line 164: fnd_message.set_token('BG_ID', TO_CHAR(p_bgp_id));

160: fnd_message.set_token('PROC', 'ben_enrolment_requirements2.get_perpiller_dets');
161: fnd_message.set_token('PERSON_ID', TO_CHAR(p_person_id));
162: fnd_message.set_token('LER_ID', TO_CHAR(p_ler_id));
163: fnd_message.set_token('EFFECTIVE_DATE', TO_CHAR(p_effdt));
164: fnd_message.set_token('BG_ID', TO_CHAR(p_bgp_id));
165: RAISE ben_manage_life_events.g_record_error;
166: --
167: END IF;
168: CLOSE c_per_in_ler_info;