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));
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;
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;
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;
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: --
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));
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));
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;
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: --
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;
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;