110: if g_debug then
111: hr_utility.set_location('BEN_92489_CANNOT_CALC_DATE',55);
112: end if;
113:
114: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
115: fnd_message.set_token('DATE_CODE',p_date_cd);
116: fnd_message.set_token('L_PROC',l_proc);
117: fnd_message.raise_error;
118: end if;
111: hr_utility.set_location('BEN_92489_CANNOT_CALC_DATE',55);
112: end if;
113:
114: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
115: fnd_message.set_token('DATE_CODE',p_date_cd);
116: fnd_message.set_token('L_PROC',l_proc);
117: fnd_message.raise_error;
118: end if;
119: else
112: end if;
113:
114: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
115: fnd_message.set_token('DATE_CODE',p_date_cd);
116: fnd_message.set_token('L_PROC',l_proc);
117: fnd_message.raise_error;
118: end if;
119: else
120: p_start_date := to_date('01/01/'||to_char(l_effective_date,'YYYY'),'dd/mm/rrrr');
113:
114: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
115: fnd_message.set_token('DATE_CODE',p_date_cd);
116: fnd_message.set_token('L_PROC',l_proc);
117: fnd_message.raise_error;
118: end if;
119: else
120: p_start_date := to_date('01/01/'||to_char(l_effective_date,'YYYY'),'dd/mm/rrrr');
121: p_end_date := to_date('31/12/'||to_char(l_effective_date,'YYYY'),'dd/mm/rrrr');
237: end if;
238:
239: if l_formula_type_id in (-27,-28,-29,-30,-504,-503,-66,-67) then
240: if p_computed_Date <= hr_api.g_sot then
241: fnd_message.set_name('BEN','BEN_94441_ENROL_ST_DT_RANGE');
242: fnd_message.set_token('PARMA',l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date));
243: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_sot));
244: fnd_message.set_token('PARMC','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
245: benutils.write(p_text=>fnd_message.get);
238:
239: if l_formula_type_id in (-27,-28,-29,-30,-504,-503,-66,-67) then
240: if p_computed_Date <= hr_api.g_sot then
241: fnd_message.set_name('BEN','BEN_94441_ENROL_ST_DT_RANGE');
242: fnd_message.set_token('PARMA',l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date));
243: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_sot));
244: fnd_message.set_token('PARMC','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
245: benutils.write(p_text=>fnd_message.get);
246: ben_warnings.load_warning
239: if l_formula_type_id in (-27,-28,-29,-30,-504,-503,-66,-67) then
240: if p_computed_Date <= hr_api.g_sot then
241: fnd_message.set_name('BEN','BEN_94441_ENROL_ST_DT_RANGE');
242: fnd_message.set_token('PARMA',l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date));
243: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_sot));
244: fnd_message.set_token('PARMC','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
245: benutils.write(p_text=>fnd_message.get);
246: ben_warnings.load_warning
247: (p_application_short_name => 'BEN'
240: if p_computed_Date <= hr_api.g_sot then
241: fnd_message.set_name('BEN','BEN_94441_ENROL_ST_DT_RANGE');
242: fnd_message.set_token('PARMA',l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date));
243: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_sot));
244: fnd_message.set_token('PARMC','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
245: benutils.write(p_text=>fnd_message.get);
246: ben_warnings.load_warning
247: (p_application_short_name => 'BEN'
248: ,p_message_name => l_message_name1
241: fnd_message.set_name('BEN','BEN_94441_ENROL_ST_DT_RANGE');
242: fnd_message.set_token('PARMA',l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date));
243: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_sot));
244: fnd_message.set_token('PARMC','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
245: benutils.write(p_text=>fnd_message.get);
246: ben_warnings.load_warning
247: (p_application_short_name => 'BEN'
248: ,p_message_name => l_message_name1
249: ,p_parma => l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date)
251: ,p_parmc => 'Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name
252: ,p_person_id => p_person_id
253: );
254: elsif p_computed_Date >= hr_api.g_eot then
255: fnd_message.set_name('BEN','BEN_94464_ENROL_ED_DT_RANGE');
256: fnd_message.set_token('PARMA',l_formula_type_name|| ' ' || fnd_date.date_to_displaydate(p_computed_Date));
257: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_eot));
258: fnd_message.set_token('PARMC','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
259: benutils.write(p_text=>fnd_message.get);
252: ,p_person_id => p_person_id
253: );
254: elsif p_computed_Date >= hr_api.g_eot then
255: fnd_message.set_name('BEN','BEN_94464_ENROL_ED_DT_RANGE');
256: fnd_message.set_token('PARMA',l_formula_type_name|| ' ' || fnd_date.date_to_displaydate(p_computed_Date));
257: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_eot));
258: fnd_message.set_token('PARMC','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
259: benutils.write(p_text=>fnd_message.get);
260: ben_warnings.load_warning
253: );
254: elsif p_computed_Date >= hr_api.g_eot then
255: fnd_message.set_name('BEN','BEN_94464_ENROL_ED_DT_RANGE');
256: fnd_message.set_token('PARMA',l_formula_type_name|| ' ' || fnd_date.date_to_displaydate(p_computed_Date));
257: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_eot));
258: fnd_message.set_token('PARMC','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
259: benutils.write(p_text=>fnd_message.get);
260: ben_warnings.load_warning
261: (p_application_short_name => 'BEN'
254: elsif p_computed_Date >= hr_api.g_eot then
255: fnd_message.set_name('BEN','BEN_94464_ENROL_ED_DT_RANGE');
256: fnd_message.set_token('PARMA',l_formula_type_name|| ' ' || fnd_date.date_to_displaydate(p_computed_Date));
257: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_eot));
258: fnd_message.set_token('PARMC','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
259: benutils.write(p_text=>fnd_message.get);
260: ben_warnings.load_warning
261: (p_application_short_name => 'BEN'
262: ,p_message_name => l_message_name2
255: fnd_message.set_name('BEN','BEN_94464_ENROL_ED_DT_RANGE');
256: fnd_message.set_token('PARMA',l_formula_type_name|| ' ' || fnd_date.date_to_displaydate(p_computed_Date));
257: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_eot));
258: fnd_message.set_token('PARMC','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
259: benutils.write(p_text=>fnd_message.get);
260: ben_warnings.load_warning
261: (p_application_short_name => 'BEN'
262: ,p_message_name => l_message_name2
263: ,p_parma => l_formula_type_name|| ' ' || fnd_date.date_to_displaydate(p_computed_Date)
267: );
268:
269: elsif l_formula_type_id in (-29,-66,-67) then
270: if p_computed_Date < p_lf_evt_ocrd_dt then
271: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');
272: fnd_message.set_token('PARMA',l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date));
273: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name);
274: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
275: benutils.write(p_text=>fnd_message.get);
268:
269: elsif l_formula_type_id in (-29,-66,-67) then
270: if p_computed_Date < p_lf_evt_ocrd_dt then
271: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');
272: fnd_message.set_token('PARMA',l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date));
273: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name);
274: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
275: benutils.write(p_text=>fnd_message.get);
276: ben_warnings.load_warning
269: elsif l_formula_type_id in (-29,-66,-67) then
270: if p_computed_Date < p_lf_evt_ocrd_dt then
271: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');
272: fnd_message.set_token('PARMA',l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date));
273: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name);
274: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
275: benutils.write(p_text=>fnd_message.get);
276: ben_warnings.load_warning
277: (p_application_short_name => 'BEN'
270: if p_computed_Date < p_lf_evt_ocrd_dt then
271: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');
272: fnd_message.set_token('PARMA',l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date));
273: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name);
274: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
275: benutils.write(p_text=>fnd_message.get);
276: ben_warnings.load_warning
277: (p_application_short_name => 'BEN'
278: ,p_message_name => l_message_name3
271: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');
272: fnd_message.set_token('PARMA',l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date));
273: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name);
274: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
275: benutils.write(p_text=>fnd_message.get);
276: ben_warnings.load_warning
277: (p_application_short_name => 'BEN'
278: ,p_message_name => l_message_name3
279: ,p_parma => l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date)
286: --Bug 5070692
287:
288: elsif l_formula_type_id in (-27,-28) then
289: if p_computed_Date < p_lf_evt_ocrd_dt then
290: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');
291: fnd_message.set_token('PARMA',l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date));
292: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name);
293: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
294:
287:
288: elsif l_formula_type_id in (-27,-28) then
289: if p_computed_Date < p_lf_evt_ocrd_dt then
290: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');
291: fnd_message.set_token('PARMA',l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date));
292: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name);
293: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
294:
295: g_dep_rec.text := fnd_message.get;
288: elsif l_formula_type_id in (-27,-28) then
289: if p_computed_Date < p_lf_evt_ocrd_dt then
290: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');
291: fnd_message.set_token('PARMA',l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date));
292: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name);
293: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
294:
295: g_dep_rec.text := fnd_message.get;
296: g_dep_rec.rep_typ_cd := 'WARNING';
289: if p_computed_Date < p_lf_evt_ocrd_dt then
290: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');
291: fnd_message.set_token('PARMA',l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date));
292: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name);
293: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
294:
295: g_dep_rec.text := fnd_message.get;
296: g_dep_rec.rep_typ_cd := 'WARNING';
297: g_dep_rec.error_message_code :='BEN_93964_ENRO_DT_LT_LE_OCD_DT';
291: fnd_message.set_token('PARMA',l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date));
292: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name);
293: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
294:
295: g_dep_rec.text := fnd_message.get;
296: g_dep_rec.rep_typ_cd := 'WARNING';
297: g_dep_rec.error_message_code :='BEN_93964_ENRO_DT_LT_LE_OCD_DT';
298: g_dep_rec.national_identifier :=l_national_identifier;
299: g_dep_rec.person_id :=p_person_id;
316:
317: --Bug 5076010
318: elsif l_formula_type_id = -30 then
319: if p_computed_Date < p_lf_evt_ocrd_dt then
320: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');
321: fnd_message.set_token('PARMA',substr(l_formula_type_name,1,10) ||' '||'Coverage End Date'|| ' ' ||fnd_date.date_to_displaydate(p_computed_Date));
322: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
323: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
324:
317: --Bug 5076010
318: elsif l_formula_type_id = -30 then
319: if p_computed_Date < p_lf_evt_ocrd_dt then
320: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');
321: fnd_message.set_token('PARMA',substr(l_formula_type_name,1,10) ||' '||'Coverage End Date'|| ' ' ||fnd_date.date_to_displaydate(p_computed_Date));
322: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
323: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
324:
325: benutils.write(p_text=>fnd_message.get);
318: elsif l_formula_type_id = -30 then
319: if p_computed_Date < p_lf_evt_ocrd_dt then
320: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');
321: fnd_message.set_token('PARMA',substr(l_formula_type_name,1,10) ||' '||'Coverage End Date'|| ' ' ||fnd_date.date_to_displaydate(p_computed_Date));
322: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
323: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
324:
325: benutils.write(p_text=>fnd_message.get);
326: ben_warnings.load_warning
319: if p_computed_Date < p_lf_evt_ocrd_dt then
320: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');
321: fnd_message.set_token('PARMA',substr(l_formula_type_name,1,10) ||' '||'Coverage End Date'|| ' ' ||fnd_date.date_to_displaydate(p_computed_Date));
322: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
323: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
324:
325: benutils.write(p_text=>fnd_message.get);
326: ben_warnings.load_warning
327: (p_application_short_name => 'BEN'
321: fnd_message.set_token('PARMA',substr(l_formula_type_name,1,10) ||' '||'Coverage End Date'|| ' ' ||fnd_date.date_to_displaydate(p_computed_Date));
322: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
323: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
324:
325: benutils.write(p_text=>fnd_message.get);
326: ben_warnings.load_warning
327: (p_application_short_name => 'BEN'
328: ,p_message_name => l_message_name3
329: ,p_parma => substr(l_formula_type_name,1,10) ||' '||'Coverage End Date'|| ' ' ||fnd_date.date_to_displaydate(p_computed_Date)
338: open c_mode;
339: fetch c_mode into l_dummy;
340: if c_mode%found then
341: if p_computed_Date < p_lf_evt_ocrd_dt then
342: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');
343: fnd_message.set_token('PARMA',l_formula_type_name|| ' ' ||fnd_date.date_to_displaydate(p_computed_Date));
344: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
345: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
346:
339: fetch c_mode into l_dummy;
340: if c_mode%found then
341: if p_computed_Date < p_lf_evt_ocrd_dt then
342: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');
343: fnd_message.set_token('PARMA',l_formula_type_name|| ' ' ||fnd_date.date_to_displaydate(p_computed_Date));
344: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
345: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
346:
347: benutils.write(p_text=>fnd_message.get);
340: if c_mode%found then
341: if p_computed_Date < p_lf_evt_ocrd_dt then
342: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');
343: fnd_message.set_token('PARMA',l_formula_type_name|| ' ' ||fnd_date.date_to_displaydate(p_computed_Date));
344: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
345: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
346:
347: benutils.write(p_text=>fnd_message.get);
348: ben_warnings.load_warning
341: if p_computed_Date < p_lf_evt_ocrd_dt then
342: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');
343: fnd_message.set_token('PARMA',l_formula_type_name|| ' ' ||fnd_date.date_to_displaydate(p_computed_Date));
344: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
345: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
346:
347: benutils.write(p_text=>fnd_message.get);
348: ben_warnings.load_warning
349: (p_application_short_name => 'BEN'
343: fnd_message.set_token('PARMA',l_formula_type_name|| ' ' ||fnd_date.date_to_displaydate(p_computed_Date));
344: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
345: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
346:
347: benutils.write(p_text=>fnd_message.get);
348: ben_warnings.load_warning
349: (p_application_short_name => 'BEN'
350: ,p_message_name => l_message_name3
351: ,p_parma => l_formula_type_name|| ' ' ||fnd_date.date_to_displaydate(p_computed_Date)
429: else
430: if g_debug then
431: hr_utility.set_location('BEN_92489_CANNOT_CALC_DATE',55);
432: end if;
433: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
434: fnd_message.set_token('DATE_CODE',p_date_cd);
435: fnd_message.set_token('L_PROC',l_proc);
436: fnd_message.raise_error;
437: end if;
430: if g_debug then
431: hr_utility.set_location('BEN_92489_CANNOT_CALC_DATE',55);
432: end if;
433: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
434: fnd_message.set_token('DATE_CODE',p_date_cd);
435: fnd_message.set_token('L_PROC',l_proc);
436: fnd_message.raise_error;
437: end if;
438: else
431: hr_utility.set_location('BEN_92489_CANNOT_CALC_DATE',55);
432: end if;
433: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
434: fnd_message.set_token('DATE_CODE',p_date_cd);
435: fnd_message.set_token('L_PROC',l_proc);
436: fnd_message.raise_error;
437: end if;
438: else
439: p_start_date := to_date('01/01/'||to_char(l_effective_date,'YYYY'),'dd/mm/rrrr');
432: end if;
433: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
434: fnd_message.set_token('DATE_CODE',p_date_cd);
435: fnd_message.set_token('L_PROC',l_proc);
436: fnd_message.raise_error;
437: end if;
438: else
439: p_start_date := to_date('01/01/'||to_char(l_effective_date,'YYYY'),'dd/mm/rrrr');
440: p_end_date := to_date('31/12/'||to_char(l_effective_date,'YYYY'),'dd/mm/rrrr');
482: close c_per_in_ler;
483: if g_debug then
484: hr_utility.set_location('BEN_91530_CANNOT_FIND_AED_DATE',40);
485: end if;
486: fnd_message.set_name('BEN','BEN_91530_CANNOT_FIND_AED_DATE');
487: fnd_message.raise_error;
488: end if;
489: close c_per_in_ler;
490: end if;
483: if g_debug then
484: hr_utility.set_location('BEN_91530_CANNOT_FIND_AED_DATE',40);
485: end if;
486: fnd_message.set_name('BEN','BEN_91530_CANNOT_FIND_AED_DATE');
487: fnd_message.raise_error;
488: end if;
489: close c_per_in_ler;
490: end if;
491: --
545: l_recorded_date := l_pil_row.ntfn_dt;
546: --
547: if l_pil_row.per_in_ler_id is null then
548: --
549: fnd_message.set_name('BEN','BEN_92391_CANT_FIND_RCRD_DATE');
550: fnd_message.raise_error;
551: --
552: end if;
553: --
546: --
547: if l_pil_row.per_in_ler_id is null then
548: --
549: fnd_message.set_name('BEN','BEN_92391_CANT_FIND_RCRD_DATE');
550: fnd_message.raise_error;
551: --
552: end if;
553: --
554: /*
560: close c_per_in_ler;
561: if g_debug then
562: hr_utility.set_location('BEN_92391_CANT_FIND_RCRD_DATE',40);
563: end if;
564: fnd_message.set_name('BEN','BEN_92391_CANT_FIND_RCRD_DATE');
565: fnd_message.raise_error;
566: end if;
567: close c_per_in_ler;
568: --
561: if g_debug then
562: hr_utility.set_location('BEN_92391_CANT_FIND_RCRD_DATE',40);
563: end if;
564: fnd_message.set_name('BEN','BEN_92391_CANT_FIND_RCRD_DATE');
565: fnd_message.raise_error;
566: end if;
567: close c_per_in_ler;
568: --
569: */
1162: close c_per_elig_elctbl_chc;
1163: if g_debug then
1164: hr_utility.set_location('BEN_91529_CANNOT_FIND_ELEC_CHC',40);
1165: end if;
1166: fnd_message.set_name('BEN','BEN_91529_CANNOT_FIND_ELEC_CHC');
1167: fnd_message.set_token('L_PROC',l_proc);
1168: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
1169: fnd_message.raise_error;
1170: end if;
1163: if g_debug then
1164: hr_utility.set_location('BEN_91529_CANNOT_FIND_ELEC_CHC',40);
1165: end if;
1166: fnd_message.set_name('BEN','BEN_91529_CANNOT_FIND_ELEC_CHC');
1167: fnd_message.set_token('L_PROC',l_proc);
1168: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
1169: fnd_message.raise_error;
1170: end if;
1171: close c_per_elig_elctbl_chc;
1164: hr_utility.set_location('BEN_91529_CANNOT_FIND_ELEC_CHC',40);
1165: end if;
1166: fnd_message.set_name('BEN','BEN_91529_CANNOT_FIND_ELEC_CHC');
1167: fnd_message.set_token('L_PROC',l_proc);
1168: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
1169: fnd_message.raise_error;
1170: end if;
1171: close c_per_elig_elctbl_chc;
1172:
1165: end if;
1166: fnd_message.set_name('BEN','BEN_91529_CANNOT_FIND_ELEC_CHC');
1167: fnd_message.set_token('L_PROC',l_proc);
1168: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
1169: fnd_message.raise_error;
1170: end if;
1171: close c_per_elig_elctbl_chc;
1172:
1173: else
1319: close c_cm_enrt_perd_strt_dt;
1320: if g_debug then
1321: hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',40);
1322: end if;
1323: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
1324: fnd_message.set_token('DATE_CODE',p_date_cd);
1325: fnd_message.set_token('L_PROC',l_proc);
1326: fnd_message.raise_error;
1327: --
1320: if g_debug then
1321: hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',40);
1322: end if;
1323: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
1324: fnd_message.set_token('DATE_CODE',p_date_cd);
1325: fnd_message.set_token('L_PROC',l_proc);
1326: fnd_message.raise_error;
1327: --
1328: end if;
1321: hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',40);
1322: end if;
1323: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
1324: fnd_message.set_token('DATE_CODE',p_date_cd);
1325: fnd_message.set_token('L_PROC',l_proc);
1326: fnd_message.raise_error;
1327: --
1328: end if;
1329: --
1322: end if;
1323: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
1324: fnd_message.set_token('DATE_CODE',p_date_cd);
1325: fnd_message.set_token('L_PROC',l_proc);
1326: fnd_message.raise_error;
1327: --
1328: end if;
1329: --
1330: end if;
1454: close c_pay_period_for_date;
1455: if g_debug then
1456: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',15);
1457: end if;
1458: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1459: fnd_message.set_token('DATE_CODE',p_date_cd);
1460: fnd_message.set_token('L_PROC',l_proc);
1461: fnd_message.set_token('PERSON_ID',l_person_id);
1462: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1455: if g_debug then
1456: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',15);
1457: end if;
1458: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1459: fnd_message.set_token('DATE_CODE',p_date_cd);
1460: fnd_message.set_token('L_PROC',l_proc);
1461: fnd_message.set_token('PERSON_ID',l_person_id);
1462: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1463: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1456: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',15);
1457: end if;
1458: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1459: fnd_message.set_token('DATE_CODE',p_date_cd);
1460: fnd_message.set_token('L_PROC',l_proc);
1461: fnd_message.set_token('PERSON_ID',l_person_id);
1462: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1463: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1464: fnd_message.raise_error;
1457: end if;
1458: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1459: fnd_message.set_token('DATE_CODE',p_date_cd);
1460: fnd_message.set_token('L_PROC',l_proc);
1461: fnd_message.set_token('PERSON_ID',l_person_id);
1462: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1463: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1464: fnd_message.raise_error;
1465: end if;
1458: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1459: fnd_message.set_token('DATE_CODE',p_date_cd);
1460: fnd_message.set_token('L_PROC',l_proc);
1461: fnd_message.set_token('PERSON_ID',l_person_id);
1462: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1463: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1464: fnd_message.raise_error;
1465: end if;
1466: close c_pay_period_for_date;
1459: fnd_message.set_token('DATE_CODE',p_date_cd);
1460: fnd_message.set_token('L_PROC',l_proc);
1461: fnd_message.set_token('PERSON_ID',l_person_id);
1462: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1463: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1464: fnd_message.raise_error;
1465: end if;
1466: close c_pay_period_for_date;
1467:
1460: fnd_message.set_token('L_PROC',l_proc);
1461: fnd_message.set_token('PERSON_ID',l_person_id);
1462: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1463: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1464: fnd_message.raise_error;
1465: end if;
1466: close c_pay_period_for_date;
1467:
1468: if p_date_cd = 'FDLPPPPYAES' then
1492: close c_pay_period_for_date;
1493: if g_debug then
1494: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',15);
1495: end if;
1496: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1497: fnd_message.set_token('DATE_CODE',p_date_cd);
1498: fnd_message.set_token('L_PROC',l_proc);
1499: fnd_message.set_token('PERSON_ID',l_person_id);
1500: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1493: if g_debug then
1494: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',15);
1495: end if;
1496: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1497: fnd_message.set_token('DATE_CODE',p_date_cd);
1498: fnd_message.set_token('L_PROC',l_proc);
1499: fnd_message.set_token('PERSON_ID',l_person_id);
1500: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1501: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1494: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',15);
1495: end if;
1496: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1497: fnd_message.set_token('DATE_CODE',p_date_cd);
1498: fnd_message.set_token('L_PROC',l_proc);
1499: fnd_message.set_token('PERSON_ID',l_person_id);
1500: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1501: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1502: fnd_message.raise_error;
1495: end if;
1496: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1497: fnd_message.set_token('DATE_CODE',p_date_cd);
1498: fnd_message.set_token('L_PROC',l_proc);
1499: fnd_message.set_token('PERSON_ID',l_person_id);
1500: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1501: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1502: fnd_message.raise_error;
1503: end if;
1496: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1497: fnd_message.set_token('DATE_CODE',p_date_cd);
1498: fnd_message.set_token('L_PROC',l_proc);
1499: fnd_message.set_token('PERSON_ID',l_person_id);
1500: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1501: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1502: fnd_message.raise_error;
1503: end if;
1504: close c_pay_period_for_date;
1497: fnd_message.set_token('DATE_CODE',p_date_cd);
1498: fnd_message.set_token('L_PROC',l_proc);
1499: fnd_message.set_token('PERSON_ID',l_person_id);
1500: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1501: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1502: fnd_message.raise_error;
1503: end if;
1504: close c_pay_period_for_date;
1505:
1498: fnd_message.set_token('L_PROC',l_proc);
1499: fnd_message.set_token('PERSON_ID',l_person_id);
1500: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1501: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1502: fnd_message.raise_error;
1503: end if;
1504: close c_pay_period_for_date;
1505:
1506: else
1530: close c_pay_period_for_date;
1531: if g_debug then
1532: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',25);
1533: end if;
1534: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1535: fnd_message.set_token('DATE_CODE',p_date_cd);
1536: fnd_message.set_token('L_PROC',l_proc);
1537: fnd_message.set_token('PERSON_ID',l_person_id);
1538: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1531: if g_debug then
1532: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',25);
1533: end if;
1534: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1535: fnd_message.set_token('DATE_CODE',p_date_cd);
1536: fnd_message.set_token('L_PROC',l_proc);
1537: fnd_message.set_token('PERSON_ID',l_person_id);
1538: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1539: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1532: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',25);
1533: end if;
1534: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1535: fnd_message.set_token('DATE_CODE',p_date_cd);
1536: fnd_message.set_token('L_PROC',l_proc);
1537: fnd_message.set_token('PERSON_ID',l_person_id);
1538: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1539: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1540: fnd_message.raise_error;
1533: end if;
1534: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1535: fnd_message.set_token('DATE_CODE',p_date_cd);
1536: fnd_message.set_token('L_PROC',l_proc);
1537: fnd_message.set_token('PERSON_ID',l_person_id);
1538: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1539: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1540: fnd_message.raise_error;
1541: end if;
1534: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1535: fnd_message.set_token('DATE_CODE',p_date_cd);
1536: fnd_message.set_token('L_PROC',l_proc);
1537: fnd_message.set_token('PERSON_ID',l_person_id);
1538: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1539: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1540: fnd_message.raise_error;
1541: end if;
1542: close c_pay_period_for_date;
1535: fnd_message.set_token('DATE_CODE',p_date_cd);
1536: fnd_message.set_token('L_PROC',l_proc);
1537: fnd_message.set_token('PERSON_ID',l_person_id);
1538: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1539: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1540: fnd_message.raise_error;
1541: end if;
1542: close c_pay_period_for_date;
1543: end if;
1536: fnd_message.set_token('L_PROC',l_proc);
1537: fnd_message.set_token('PERSON_ID',l_person_id);
1538: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1539: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1540: fnd_message.raise_error;
1541: end if;
1542: close c_pay_period_for_date;
1543: end if;
1544: end if ;
1763: l_enrt_cvg_strt_dt is not null then
1764: if g_debug then
1765: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',80);
1766: end if;
1767: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1768: fnd_message.set_token('DATE_CODE',p_date_cd);
1769: fnd_message.set_token('L_PROC',l_proc);
1770: fnd_message.set_token('PERSON_ID',l_person_id);
1771: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1764: if g_debug then
1765: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',80);
1766: end if;
1767: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1768: fnd_message.set_token('DATE_CODE',p_date_cd);
1769: fnd_message.set_token('L_PROC',l_proc);
1770: fnd_message.set_token('PERSON_ID',l_person_id);
1771: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1772: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1765: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',80);
1766: end if;
1767: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1768: fnd_message.set_token('DATE_CODE',p_date_cd);
1769: fnd_message.set_token('L_PROC',l_proc);
1770: fnd_message.set_token('PERSON_ID',l_person_id);
1771: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1772: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1773: fnd_message.raise_error;
1766: end if;
1767: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1768: fnd_message.set_token('DATE_CODE',p_date_cd);
1769: fnd_message.set_token('L_PROC',l_proc);
1770: fnd_message.set_token('PERSON_ID',l_person_id);
1771: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1772: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1773: fnd_message.raise_error;
1774: end if;
1767: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1768: fnd_message.set_token('DATE_CODE',p_date_cd);
1769: fnd_message.set_token('L_PROC',l_proc);
1770: fnd_message.set_token('PERSON_ID',l_person_id);
1771: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1772: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1773: fnd_message.raise_error;
1774: end if;
1775: close c_pay_period_for_date;
1768: fnd_message.set_token('DATE_CODE',p_date_cd);
1769: fnd_message.set_token('L_PROC',l_proc);
1770: fnd_message.set_token('PERSON_ID',l_person_id);
1771: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1772: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1773: fnd_message.raise_error;
1774: end if;
1775: close c_pay_period_for_date;
1776: end if;
1769: fnd_message.set_token('L_PROC',l_proc);
1770: fnd_message.set_token('PERSON_ID',l_person_id);
1771: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1772: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1773: fnd_message.raise_error;
1774: end if;
1775: close c_pay_period_for_date;
1776: end if;
1777:
1801: close c_next_pay_period;
1802: if g_debug then
1803: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',40);
1804: end if;
1805: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1806: fnd_message.set_token('DATE_CODE',p_date_cd);
1807: fnd_message.set_token('L_PROC',l_proc);
1808: fnd_message.set_token('PERSON_ID',l_person_id);
1809: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1802: if g_debug then
1803: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',40);
1804: end if;
1805: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1806: fnd_message.set_token('DATE_CODE',p_date_cd);
1807: fnd_message.set_token('L_PROC',l_proc);
1808: fnd_message.set_token('PERSON_ID',l_person_id);
1809: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1810: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1803: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',40);
1804: end if;
1805: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1806: fnd_message.set_token('DATE_CODE',p_date_cd);
1807: fnd_message.set_token('L_PROC',l_proc);
1808: fnd_message.set_token('PERSON_ID',l_person_id);
1809: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1810: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1811: fnd_message.raise_error;
1804: end if;
1805: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1806: fnd_message.set_token('DATE_CODE',p_date_cd);
1807: fnd_message.set_token('L_PROC',l_proc);
1808: fnd_message.set_token('PERSON_ID',l_person_id);
1809: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1810: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1811: fnd_message.raise_error;
1812: end if;
1805: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1806: fnd_message.set_token('DATE_CODE',p_date_cd);
1807: fnd_message.set_token('L_PROC',l_proc);
1808: fnd_message.set_token('PERSON_ID',l_person_id);
1809: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1810: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1811: fnd_message.raise_error;
1812: end if;
1813: close c_next_pay_period;
1806: fnd_message.set_token('DATE_CODE',p_date_cd);
1807: fnd_message.set_token('L_PROC',l_proc);
1808: fnd_message.set_token('PERSON_ID',l_person_id);
1809: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1810: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1811: fnd_message.raise_error;
1812: end if;
1813: close c_next_pay_period;
1814:
1807: fnd_message.set_token('L_PROC',l_proc);
1808: fnd_message.set_token('PERSON_ID',l_person_id);
1809: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1810: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1811: fnd_message.raise_error;
1812: end if;
1813: close c_next_pay_period;
1814:
1815: if p_date_cd = 'LESFDPPAD' and
1867: hr_utility.set_location('l_next_pay_period.start_date'||l_next_pay_period.start_date,20);
1868: end if;
1869: if c_next_pay_period%notfound then
1870: close c_next_pay_period;
1871: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1872: fnd_message.set_token('DATE_CODE',p_date_cd);
1873: fnd_message.set_token('L_PROC',l_proc);
1874: fnd_message.set_token('PERSON_ID',l_person_id);
1875: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1868: end if;
1869: if c_next_pay_period%notfound then
1870: close c_next_pay_period;
1871: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1872: fnd_message.set_token('DATE_CODE',p_date_cd);
1873: fnd_message.set_token('L_PROC',l_proc);
1874: fnd_message.set_token('PERSON_ID',l_person_id);
1875: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1876: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1869: if c_next_pay_period%notfound then
1870: close c_next_pay_period;
1871: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1872: fnd_message.set_token('DATE_CODE',p_date_cd);
1873: fnd_message.set_token('L_PROC',l_proc);
1874: fnd_message.set_token('PERSON_ID',l_person_id);
1875: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1876: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1877: fnd_message.raise_error;
1870: close c_next_pay_period;
1871: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1872: fnd_message.set_token('DATE_CODE',p_date_cd);
1873: fnd_message.set_token('L_PROC',l_proc);
1874: fnd_message.set_token('PERSON_ID',l_person_id);
1875: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1876: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1877: fnd_message.raise_error;
1878: end if;
1871: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1872: fnd_message.set_token('DATE_CODE',p_date_cd);
1873: fnd_message.set_token('L_PROC',l_proc);
1874: fnd_message.set_token('PERSON_ID',l_person_id);
1875: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1876: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1877: fnd_message.raise_error;
1878: end if;
1879: close c_next_pay_period;
1872: fnd_message.set_token('DATE_CODE',p_date_cd);
1873: fnd_message.set_token('L_PROC',l_proc);
1874: fnd_message.set_token('PERSON_ID',l_person_id);
1875: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1876: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1877: fnd_message.raise_error;
1878: end if;
1879: close c_next_pay_period;
1880: if p_date_cd = 'FDPPFED' then
1873: fnd_message.set_token('L_PROC',l_proc);
1874: fnd_message.set_token('PERSON_ID',l_person_id);
1875: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1876: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1877: fnd_message.raise_error;
1878: end if;
1879: close c_next_pay_period;
1880: if p_date_cd = 'FDPPFED' then
1881: p_returned_date := l_next_pay_period.start_date;
1893: open c_pay_period;
1894: fetch c_pay_period into l_pay_period;
1895: if c_pay_period%notfound then
1896: close c_pay_period;
1897: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1898: fnd_message.set_token('DATE_CODE',p_date_cd);
1899: fnd_message.set_token('PERSON_ID',l_person_id);
1900: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1901: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1894: fetch c_pay_period into l_pay_period;
1895: if c_pay_period%notfound then
1896: close c_pay_period;
1897: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1898: fnd_message.set_token('DATE_CODE',p_date_cd);
1899: fnd_message.set_token('PERSON_ID',l_person_id);
1900: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1901: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1902: fnd_message.raise_error;
1895: if c_pay_period%notfound then
1896: close c_pay_period;
1897: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1898: fnd_message.set_token('DATE_CODE',p_date_cd);
1899: fnd_message.set_token('PERSON_ID',l_person_id);
1900: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1901: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1902: fnd_message.raise_error;
1903: end if;
1896: close c_pay_period;
1897: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1898: fnd_message.set_token('DATE_CODE',p_date_cd);
1899: fnd_message.set_token('PERSON_ID',l_person_id);
1900: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1901: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1902: fnd_message.raise_error;
1903: end if;
1904: close c_pay_period ;
1897: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1898: fnd_message.set_token('DATE_CODE',p_date_cd);
1899: fnd_message.set_token('PERSON_ID',l_person_id);
1900: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1901: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1902: fnd_message.raise_error;
1903: end if;
1904: close c_pay_period ;
1905: --
1898: fnd_message.set_token('DATE_CODE',p_date_cd);
1899: fnd_message.set_token('PERSON_ID',l_person_id);
1900: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1901: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1902: fnd_message.raise_error;
1903: end if;
1904: close c_pay_period ;
1905: --
1906: if l_event_date = l_pay_period.start_date then
1912: fetch c_next_pay_period into l_next_pay_period;
1913: --
1914: if c_next_pay_period%notfound then
1915: close c_next_pay_period;
1916: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1917: fnd_message.set_token('DATE_CODE',p_date_cd);
1918: fnd_message.set_token('PERSON_ID',l_person_id);
1919: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1920: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1913: --
1914: if c_next_pay_period%notfound then
1915: close c_next_pay_period;
1916: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1917: fnd_message.set_token('DATE_CODE',p_date_cd);
1918: fnd_message.set_token('PERSON_ID',l_person_id);
1919: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1920: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1921: fnd_message.raise_error;
1914: if c_next_pay_period%notfound then
1915: close c_next_pay_period;
1916: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1917: fnd_message.set_token('DATE_CODE',p_date_cd);
1918: fnd_message.set_token('PERSON_ID',l_person_id);
1919: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1920: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1921: fnd_message.raise_error;
1922: end if;
1915: close c_next_pay_period;
1916: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1917: fnd_message.set_token('DATE_CODE',p_date_cd);
1918: fnd_message.set_token('PERSON_ID',l_person_id);
1919: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1920: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1921: fnd_message.raise_error;
1922: end if;
1923: close c_next_pay_period;
1916: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1917: fnd_message.set_token('DATE_CODE',p_date_cd);
1918: fnd_message.set_token('PERSON_ID',l_person_id);
1919: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1920: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1921: fnd_message.raise_error;
1922: end if;
1923: close c_next_pay_period;
1924: p_returned_date := l_next_pay_period.start_date;
1917: fnd_message.set_token('DATE_CODE',p_date_cd);
1918: fnd_message.set_token('PERSON_ID',l_person_id);
1919: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1920: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1921: fnd_message.raise_error;
1922: end if;
1923: close c_next_pay_period;
1924: p_returned_date := l_next_pay_period.start_date;
1925: hr_utility.set_location('l_pay_period.start_date '|| l_next_pay_period.start_date,20);
1937: open c_pay_period;
1938: fetch c_pay_period into l_pay_period;
1939: if c_pay_period%notfound then
1940: close c_pay_period;
1941: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1942: fnd_message.set_token('DATE_CODE',p_date_cd);
1943: fnd_message.set_token('PERSON_ID',l_person_id);
1944: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1945: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1938: fetch c_pay_period into l_pay_period;
1939: if c_pay_period%notfound then
1940: close c_pay_period;
1941: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1942: fnd_message.set_token('DATE_CODE',p_date_cd);
1943: fnd_message.set_token('PERSON_ID',l_person_id);
1944: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1945: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1946: fnd_message.raise_error;
1939: if c_pay_period%notfound then
1940: close c_pay_period;
1941: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1942: fnd_message.set_token('DATE_CODE',p_date_cd);
1943: fnd_message.set_token('PERSON_ID',l_person_id);
1944: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1945: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1946: fnd_message.raise_error;
1947: end if;
1940: close c_pay_period;
1941: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1942: fnd_message.set_token('DATE_CODE',p_date_cd);
1943: fnd_message.set_token('PERSON_ID',l_person_id);
1944: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1945: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1946: fnd_message.raise_error;
1947: end if;
1948: close c_pay_period ;
1941: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1942: fnd_message.set_token('DATE_CODE',p_date_cd);
1943: fnd_message.set_token('PERSON_ID',l_person_id);
1944: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1945: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1946: fnd_message.raise_error;
1947: end if;
1948: close c_pay_period ;
1949: --
1942: fnd_message.set_token('DATE_CODE',p_date_cd);
1943: fnd_message.set_token('PERSON_ID',l_person_id);
1944: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1945: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1946: fnd_message.raise_error;
1947: end if;
1948: close c_pay_period ;
1949: --
1950: if l_event_date = l_pay_period.end_date then
1956: fetch c_next_pay_period into l_next_pay_period;
1957: --
1958: if c_next_pay_period%notfound then
1959: close c_next_pay_period;
1960: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1961: fnd_message.set_token('DATE_CODE',p_date_cd);
1962: fnd_message.set_token('PERSON_ID',l_person_id);
1963: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1964: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1957: --
1958: if c_next_pay_period%notfound then
1959: close c_next_pay_period;
1960: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1961: fnd_message.set_token('DATE_CODE',p_date_cd);
1962: fnd_message.set_token('PERSON_ID',l_person_id);
1963: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1964: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1965: fnd_message.raise_error;
1958: if c_next_pay_period%notfound then
1959: close c_next_pay_period;
1960: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1961: fnd_message.set_token('DATE_CODE',p_date_cd);
1962: fnd_message.set_token('PERSON_ID',l_person_id);
1963: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1964: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1965: fnd_message.raise_error;
1966: end if;
1959: close c_next_pay_period;
1960: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1961: fnd_message.set_token('DATE_CODE',p_date_cd);
1962: fnd_message.set_token('PERSON_ID',l_person_id);
1963: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1964: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1965: fnd_message.raise_error;
1966: end if;
1967: close c_next_pay_period;
1960: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1961: fnd_message.set_token('DATE_CODE',p_date_cd);
1962: fnd_message.set_token('PERSON_ID',l_person_id);
1963: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1964: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1965: fnd_message.raise_error;
1966: end if;
1967: close c_next_pay_period;
1968: p_returned_date := l_next_pay_period.end_date;
1961: fnd_message.set_token('DATE_CODE',p_date_cd);
1962: fnd_message.set_token('PERSON_ID',l_person_id);
1963: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1964: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1965: fnd_message.raise_error;
1966: end if;
1967: close c_next_pay_period;
1968: p_returned_date := l_next_pay_period.end_date;
1969: hr_utility.set_location('l_pay_period.end_date '|| l_next_pay_period.end_date,20);
2572: close c_pay_period_for_date;
2573: if g_debug then
2574: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',45);
2575: end if;
2576: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2577: fnd_message.set_token('DATE_CODE',p_date_cd);
2578: fnd_message.set_token('L_PROC',l_proc);
2579: fnd_message.set_token('PERSON_ID',l_person_id);
2580: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2573: if g_debug then
2574: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',45);
2575: end if;
2576: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2577: fnd_message.set_token('DATE_CODE',p_date_cd);
2578: fnd_message.set_token('L_PROC',l_proc);
2579: fnd_message.set_token('PERSON_ID',l_person_id);
2580: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2581: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);
2574: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',45);
2575: end if;
2576: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2577: fnd_message.set_token('DATE_CODE',p_date_cd);
2578: fnd_message.set_token('L_PROC',l_proc);
2579: fnd_message.set_token('PERSON_ID',l_person_id);
2580: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2581: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);
2582: fnd_message.raise_error;
2575: end if;
2576: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2577: fnd_message.set_token('DATE_CODE',p_date_cd);
2578: fnd_message.set_token('L_PROC',l_proc);
2579: fnd_message.set_token('PERSON_ID',l_person_id);
2580: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2581: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);
2582: fnd_message.raise_error;
2583:
2576: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2577: fnd_message.set_token('DATE_CODE',p_date_cd);
2578: fnd_message.set_token('L_PROC',l_proc);
2579: fnd_message.set_token('PERSON_ID',l_person_id);
2580: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2581: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);
2582: fnd_message.raise_error;
2583:
2584: end if;
2577: fnd_message.set_token('DATE_CODE',p_date_cd);
2578: fnd_message.set_token('L_PROC',l_proc);
2579: fnd_message.set_token('PERSON_ID',l_person_id);
2580: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2581: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);
2582: fnd_message.raise_error;
2583:
2584: end if;
2585: close c_pay_period_for_date;
2578: fnd_message.set_token('L_PROC',l_proc);
2579: fnd_message.set_token('PERSON_ID',l_person_id);
2580: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2581: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);
2582: fnd_message.raise_error;
2583:
2584: end if;
2585: close c_pay_period_for_date;
2586:
2600: close c_next_pay_period;
2601: if g_debug then
2602: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',55);
2603: end if;
2604: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2605: fnd_message.set_token('DATE_CODE',p_date_cd);
2606: fnd_message.set_token('L_PROC',l_proc);
2607: fnd_message.set_token('PERSON_ID',l_person_id);
2608: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2601: if g_debug then
2602: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',55);
2603: end if;
2604: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2605: fnd_message.set_token('DATE_CODE',p_date_cd);
2606: fnd_message.set_token('L_PROC',l_proc);
2607: fnd_message.set_token('PERSON_ID',l_person_id);
2608: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2609: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);
2602: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',55);
2603: end if;
2604: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2605: fnd_message.set_token('DATE_CODE',p_date_cd);
2606: fnd_message.set_token('L_PROC',l_proc);
2607: fnd_message.set_token('PERSON_ID',l_person_id);
2608: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2609: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);
2610: fnd_message.raise_error;
2603: end if;
2604: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2605: fnd_message.set_token('DATE_CODE',p_date_cd);
2606: fnd_message.set_token('L_PROC',l_proc);
2607: fnd_message.set_token('PERSON_ID',l_person_id);
2608: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2609: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);
2610: fnd_message.raise_error;
2611: end if;
2604: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2605: fnd_message.set_token('DATE_CODE',p_date_cd);
2606: fnd_message.set_token('L_PROC',l_proc);
2607: fnd_message.set_token('PERSON_ID',l_person_id);
2608: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2609: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);
2610: fnd_message.raise_error;
2611: end if;
2612: close c_next_pay_period;
2605: fnd_message.set_token('DATE_CODE',p_date_cd);
2606: fnd_message.set_token('L_PROC',l_proc);
2607: fnd_message.set_token('PERSON_ID',l_person_id);
2608: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2609: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);
2610: fnd_message.raise_error;
2611: end if;
2612: close c_next_pay_period;
2613:
2606: fnd_message.set_token('L_PROC',l_proc);
2607: fnd_message.set_token('PERSON_ID',l_person_id);
2608: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2609: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);
2610: fnd_message.raise_error;
2611: end if;
2612: close c_next_pay_period;
2613:
2614: p_returned_date := l_next_pay_period.start_date;
2655: else
2656: if g_debug then
2657: hr_utility.set_location('BEN_92489_CANNOT_CALC_DATE',55);
2658: end if;
2659: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
2660: fnd_message.set_token('DATE_CODE',p_date_cd);
2661: fnd_message.set_token('L_PROC',l_proc);
2662: fnd_message.raise_error;
2663: --
2656: if g_debug then
2657: hr_utility.set_location('BEN_92489_CANNOT_CALC_DATE',55);
2658: end if;
2659: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
2660: fnd_message.set_token('DATE_CODE',p_date_cd);
2661: fnd_message.set_token('L_PROC',l_proc);
2662: fnd_message.raise_error;
2663: --
2664: end if;
2657: hr_utility.set_location('BEN_92489_CANNOT_CALC_DATE',55);
2658: end if;
2659: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
2660: fnd_message.set_token('DATE_CODE',p_date_cd);
2661: fnd_message.set_token('L_PROC',l_proc);
2662: fnd_message.raise_error;
2663: --
2664: end if;
2665: --
2658: end if;
2659: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
2660: fnd_message.set_token('DATE_CODE',p_date_cd);
2661: fnd_message.set_token('L_PROC',l_proc);
2662: fnd_message.raise_error;
2663: --
2664: end if;
2665: --
2666: p_returned_date:= l_start_date;
2701: close c_oipl_popl_lim_yr;
2702: --
2703: else
2704: -- hr_utility.set_location('BEN_92489_CANNOT_CALC_DATE',55);
2705: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
2706: fnd_message.set_token('DATE_CODE',p_date_cd);
2707: fnd_message.set_token('L_PROC',l_proc);
2708: fnd_message.raise_error;
2709: --
2702: --
2703: else
2704: -- hr_utility.set_location('BEN_92489_CANNOT_CALC_DATE',55);
2705: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
2706: fnd_message.set_token('DATE_CODE',p_date_cd);
2707: fnd_message.set_token('L_PROC',l_proc);
2708: fnd_message.raise_error;
2709: --
2710: end if;
2703: else
2704: -- hr_utility.set_location('BEN_92489_CANNOT_CALC_DATE',55);
2705: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
2706: fnd_message.set_token('DATE_CODE',p_date_cd);
2707: fnd_message.set_token('L_PROC',l_proc);
2708: fnd_message.raise_error;
2709: --
2710: end if;
2711: --
2704: -- hr_utility.set_location('BEN_92489_CANNOT_CALC_DATE',55);
2705: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
2706: fnd_message.set_token('DATE_CODE',p_date_cd);
2707: fnd_message.set_token('L_PROC',l_proc);
2708: fnd_message.raise_error;
2709: --
2710: end if;
2711: --
2712: p_returned_date:= l_end_date;
3033: if c_pay_period%notfound then
3034:
3035: close c_pay_period;
3036: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',65);
3037: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3038: fnd_message.set_token('DATE_CODE',p_date_cd);
3039: fnd_message.set_token('L_PROC',l_proc);
3040: fnd_message.set_token('PERSON_ID',l_person_id);
3041: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3034:
3035: close c_pay_period;
3036: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',65);
3037: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3038: fnd_message.set_token('DATE_CODE',p_date_cd);
3039: fnd_message.set_token('L_PROC',l_proc);
3040: fnd_message.set_token('PERSON_ID',l_person_id);
3041: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3042: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3035: close c_pay_period;
3036: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',65);
3037: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3038: fnd_message.set_token('DATE_CODE',p_date_cd);
3039: fnd_message.set_token('L_PROC',l_proc);
3040: fnd_message.set_token('PERSON_ID',l_person_id);
3041: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3042: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3043: fnd_message.raise_error;
3036: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',65);
3037: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3038: fnd_message.set_token('DATE_CODE',p_date_cd);
3039: fnd_message.set_token('L_PROC',l_proc);
3040: fnd_message.set_token('PERSON_ID',l_person_id);
3041: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3042: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3043: fnd_message.raise_error;
3044:
3037: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3038: fnd_message.set_token('DATE_CODE',p_date_cd);
3039: fnd_message.set_token('L_PROC',l_proc);
3040: fnd_message.set_token('PERSON_ID',l_person_id);
3041: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3042: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3043: fnd_message.raise_error;
3044:
3045: end if;
3038: fnd_message.set_token('DATE_CODE',p_date_cd);
3039: fnd_message.set_token('L_PROC',l_proc);
3040: fnd_message.set_token('PERSON_ID',l_person_id);
3041: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3042: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3043: fnd_message.raise_error;
3044:
3045: end if;
3046:
3039: fnd_message.set_token('L_PROC',l_proc);
3040: fnd_message.set_token('PERSON_ID',l_person_id);
3041: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3042: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3043: fnd_message.raise_error;
3044:
3045: end if;
3046:
3047: close c_pay_period ;
3080: if c_pay_period%notfound then
3081:
3082: close c_pay_period;
3083: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',70);
3084: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3085: fnd_message.set_token('DATE_CODE',p_date_cd);
3086: fnd_message.set_token('L_PROC',l_proc);
3087: fnd_message.set_token('PERSON_ID',l_person_id);
3088: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3081:
3082: close c_pay_period;
3083: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',70);
3084: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3085: fnd_message.set_token('DATE_CODE',p_date_cd);
3086: fnd_message.set_token('L_PROC',l_proc);
3087: fnd_message.set_token('PERSON_ID',l_person_id);
3088: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3089: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3082: close c_pay_period;
3083: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',70);
3084: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3085: fnd_message.set_token('DATE_CODE',p_date_cd);
3086: fnd_message.set_token('L_PROC',l_proc);
3087: fnd_message.set_token('PERSON_ID',l_person_id);
3088: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3089: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3090: fnd_message.raise_error;
3083: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',70);
3084: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3085: fnd_message.set_token('DATE_CODE',p_date_cd);
3086: fnd_message.set_token('L_PROC',l_proc);
3087: fnd_message.set_token('PERSON_ID',l_person_id);
3088: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3089: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3090: fnd_message.raise_error;
3091:
3084: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3085: fnd_message.set_token('DATE_CODE',p_date_cd);
3086: fnd_message.set_token('L_PROC',l_proc);
3087: fnd_message.set_token('PERSON_ID',l_person_id);
3088: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3089: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3090: fnd_message.raise_error;
3091:
3092: end if;
3085: fnd_message.set_token('DATE_CODE',p_date_cd);
3086: fnd_message.set_token('L_PROC',l_proc);
3087: fnd_message.set_token('PERSON_ID',l_person_id);
3088: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3089: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3090: fnd_message.raise_error;
3091:
3092: end if;
3093:
3086: fnd_message.set_token('L_PROC',l_proc);
3087: fnd_message.set_token('PERSON_ID',l_person_id);
3088: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3089: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3090: fnd_message.raise_error;
3091:
3092: end if;
3093:
3094: close c_pay_period ;
3652: l_end_date;
3653: --
3654: if c_pay_period_for_date%notfound then
3655: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',95);
3656: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3657: fnd_message.set_token('DATE_CODE',p_date_cd);
3658: fnd_message.set_token('L_PROC',l_proc);
3659: fnd_message.set_token('PERSON_ID',l_person_id);
3660: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3653: --
3654: if c_pay_period_for_date%notfound then
3655: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',95);
3656: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3657: fnd_message.set_token('DATE_CODE',p_date_cd);
3658: fnd_message.set_token('L_PROC',l_proc);
3659: fnd_message.set_token('PERSON_ID',l_person_id);
3660: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3661: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3654: if c_pay_period_for_date%notfound then
3655: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',95);
3656: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3657: fnd_message.set_token('DATE_CODE',p_date_cd);
3658: fnd_message.set_token('L_PROC',l_proc);
3659: fnd_message.set_token('PERSON_ID',l_person_id);
3660: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3661: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3662: fnd_message.raise_error;
3655: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',95);
3656: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3657: fnd_message.set_token('DATE_CODE',p_date_cd);
3658: fnd_message.set_token('L_PROC',l_proc);
3659: fnd_message.set_token('PERSON_ID',l_person_id);
3660: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3661: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3662: fnd_message.raise_error;
3663: --
3656: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3657: fnd_message.set_token('DATE_CODE',p_date_cd);
3658: fnd_message.set_token('L_PROC',l_proc);
3659: fnd_message.set_token('PERSON_ID',l_person_id);
3660: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3661: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3662: fnd_message.raise_error;
3663: --
3664: end if;
3657: fnd_message.set_token('DATE_CODE',p_date_cd);
3658: fnd_message.set_token('L_PROC',l_proc);
3659: fnd_message.set_token('PERSON_ID',l_person_id);
3660: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3661: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3662: fnd_message.raise_error;
3663: --
3664: end if;
3665: --
3658: fnd_message.set_token('L_PROC',l_proc);
3659: fnd_message.set_token('PERSON_ID',l_person_id);
3660: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3661: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3662: fnd_message.raise_error;
3663: --
3664: end if;
3665: --
3666: p_returned_date:=l_end_date;
3696: l_end_date;
3697: --
3698: if c_pay_period_for_date%notfound then
3699: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',100);
3700: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3701: fnd_message.set_token('DATE_CODE',p_date_cd);
3702: fnd_message.set_token('L_PROC',l_proc);
3703: fnd_message.set_token('PERSON_ID',l_person_id);
3704: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3697: --
3698: if c_pay_period_for_date%notfound then
3699: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',100);
3700: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3701: fnd_message.set_token('DATE_CODE',p_date_cd);
3702: fnd_message.set_token('L_PROC',l_proc);
3703: fnd_message.set_token('PERSON_ID',l_person_id);
3704: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3705: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3698: if c_pay_period_for_date%notfound then
3699: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',100);
3700: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3701: fnd_message.set_token('DATE_CODE',p_date_cd);
3702: fnd_message.set_token('L_PROC',l_proc);
3703: fnd_message.set_token('PERSON_ID',l_person_id);
3704: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3705: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3706: fnd_message.raise_error;
3699: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',100);
3700: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3701: fnd_message.set_token('DATE_CODE',p_date_cd);
3702: fnd_message.set_token('L_PROC',l_proc);
3703: fnd_message.set_token('PERSON_ID',l_person_id);
3704: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3705: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3706: fnd_message.raise_error;
3707: end if;
3700: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3701: fnd_message.set_token('DATE_CODE',p_date_cd);
3702: fnd_message.set_token('L_PROC',l_proc);
3703: fnd_message.set_token('PERSON_ID',l_person_id);
3704: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3705: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3706: fnd_message.raise_error;
3707: end if;
3708: --
3701: fnd_message.set_token('DATE_CODE',p_date_cd);
3702: fnd_message.set_token('L_PROC',l_proc);
3703: fnd_message.set_token('PERSON_ID',l_person_id);
3704: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3705: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3706: fnd_message.raise_error;
3707: end if;
3708: --
3709: p_returned_date:=l_start_date;
3702: fnd_message.set_token('L_PROC',l_proc);
3703: fnd_message.set_token('PERSON_ID',l_person_id);
3704: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3705: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3706: fnd_message.raise_error;
3707: end if;
3708: --
3709: p_returned_date:=l_start_date;
3710: --
3740: l_end_date;
3741: --
3742: if c_pay_period_for_date%notfound then
3743: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',105);
3744: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3745: fnd_message.set_token('DATE_CODE',p_date_cd);
3746: fnd_message.set_token('L_PROC',l_proc);
3747: fnd_message.set_token('PERSON_ID',l_person_id);
3748: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3741: --
3742: if c_pay_period_for_date%notfound then
3743: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',105);
3744: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3745: fnd_message.set_token('DATE_CODE',p_date_cd);
3746: fnd_message.set_token('L_PROC',l_proc);
3747: fnd_message.set_token('PERSON_ID',l_person_id);
3748: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3749: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3742: if c_pay_period_for_date%notfound then
3743: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',105);
3744: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3745: fnd_message.set_token('DATE_CODE',p_date_cd);
3746: fnd_message.set_token('L_PROC',l_proc);
3747: fnd_message.set_token('PERSON_ID',l_person_id);
3748: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3749: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3750: fnd_message.raise_error;
3743: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',105);
3744: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3745: fnd_message.set_token('DATE_CODE',p_date_cd);
3746: fnd_message.set_token('L_PROC',l_proc);
3747: fnd_message.set_token('PERSON_ID',l_person_id);
3748: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3749: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3750: fnd_message.raise_error;
3751: end if;
3744: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3745: fnd_message.set_token('DATE_CODE',p_date_cd);
3746: fnd_message.set_token('L_PROC',l_proc);
3747: fnd_message.set_token('PERSON_ID',l_person_id);
3748: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3749: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3750: fnd_message.raise_error;
3751: end if;
3752: --
3745: fnd_message.set_token('DATE_CODE',p_date_cd);
3746: fnd_message.set_token('L_PROC',l_proc);
3747: fnd_message.set_token('PERSON_ID',l_person_id);
3748: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3749: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3750: fnd_message.raise_error;
3751: end if;
3752: --
3753: p_returned_date:=l_start_date;
3746: fnd_message.set_token('L_PROC',l_proc);
3747: fnd_message.set_token('PERSON_ID',l_person_id);
3748: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3749: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3750: fnd_message.raise_error;
3751: end if;
3752: --
3753: p_returned_date:=l_start_date;
3754: --
4149: if c_pay_period%notfound then
4150: --
4151: close c_pay_period;
4152: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',110);
4153: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4154: fnd_message.set_token('DATE_CODE',p_date_cd);
4155: fnd_message.set_token('L_PROC',l_proc);
4156: fnd_message.set_token('PERSON_ID',l_person_id);
4157: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4150: --
4151: close c_pay_period;
4152: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',110);
4153: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4154: fnd_message.set_token('DATE_CODE',p_date_cd);
4155: fnd_message.set_token('L_PROC',l_proc);
4156: fnd_message.set_token('PERSON_ID',l_person_id);
4157: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4158: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4151: close c_pay_period;
4152: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',110);
4153: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4154: fnd_message.set_token('DATE_CODE',p_date_cd);
4155: fnd_message.set_token('L_PROC',l_proc);
4156: fnd_message.set_token('PERSON_ID',l_person_id);
4157: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4158: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4159: fnd_message.raise_error;
4152: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',110);
4153: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4154: fnd_message.set_token('DATE_CODE',p_date_cd);
4155: fnd_message.set_token('L_PROC',l_proc);
4156: fnd_message.set_token('PERSON_ID',l_person_id);
4157: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4158: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4159: fnd_message.raise_error;
4160: --
4153: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4154: fnd_message.set_token('DATE_CODE',p_date_cd);
4155: fnd_message.set_token('L_PROC',l_proc);
4156: fnd_message.set_token('PERSON_ID',l_person_id);
4157: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4158: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4159: fnd_message.raise_error;
4160: --
4161: end if;
4154: fnd_message.set_token('DATE_CODE',p_date_cd);
4155: fnd_message.set_token('L_PROC',l_proc);
4156: fnd_message.set_token('PERSON_ID',l_person_id);
4157: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4158: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4159: fnd_message.raise_error;
4160: --
4161: end if;
4162: --
4155: fnd_message.set_token('L_PROC',l_proc);
4156: fnd_message.set_token('PERSON_ID',l_person_id);
4157: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4158: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4159: fnd_message.raise_error;
4160: --
4161: end if;
4162: --
4163: p_returned_date := l_pay_period.start_date;
4183: --
4184: if c_pay_period%notfound then
4185: close c_pay_period;
4186: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',115);
4187: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4188: fnd_message.set_token('DATE_CODE',p_date_cd);
4189: fnd_message.set_token('L_PROC',l_proc);
4190: fnd_message.set_token('PERSON_ID',l_person_id);
4191: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4184: if c_pay_period%notfound then
4185: close c_pay_period;
4186: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',115);
4187: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4188: fnd_message.set_token('DATE_CODE',p_date_cd);
4189: fnd_message.set_token('L_PROC',l_proc);
4190: fnd_message.set_token('PERSON_ID',l_person_id);
4191: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4192: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4185: close c_pay_period;
4186: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',115);
4187: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4188: fnd_message.set_token('DATE_CODE',p_date_cd);
4189: fnd_message.set_token('L_PROC',l_proc);
4190: fnd_message.set_token('PERSON_ID',l_person_id);
4191: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4192: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4193: fnd_message.raise_error;
4186: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',115);
4187: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4188: fnd_message.set_token('DATE_CODE',p_date_cd);
4189: fnd_message.set_token('L_PROC',l_proc);
4190: fnd_message.set_token('PERSON_ID',l_person_id);
4191: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4192: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4193: fnd_message.raise_error;
4194: end if;
4187: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4188: fnd_message.set_token('DATE_CODE',p_date_cd);
4189: fnd_message.set_token('L_PROC',l_proc);
4190: fnd_message.set_token('PERSON_ID',l_person_id);
4191: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4192: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4193: fnd_message.raise_error;
4194: end if;
4195: p_returned_date := l_pay_period.end_date;
4188: fnd_message.set_token('DATE_CODE',p_date_cd);
4189: fnd_message.set_token('L_PROC',l_proc);
4190: fnd_message.set_token('PERSON_ID',l_person_id);
4191: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4192: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4193: fnd_message.raise_error;
4194: end if;
4195: p_returned_date := l_pay_period.end_date;
4196: close c_pay_period ;
4189: fnd_message.set_token('L_PROC',l_proc);
4190: fnd_message.set_token('PERSON_ID',l_person_id);
4191: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4192: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4193: fnd_message.raise_error;
4194: end if;
4195: p_returned_date := l_pay_period.end_date;
4196: close c_pay_period ;
4197: --
4217: close c_pay_period;
4218: if g_debug then
4219: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',115);
4220: end if;
4221: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4222: fnd_message.set_token('DATE_CODE',p_date_cd);
4223: fnd_message.set_token('L_PROC',l_proc);
4224: fnd_message.set_token('PERSON_ID',l_person_id);
4225: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4218: if g_debug then
4219: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',115);
4220: end if;
4221: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4222: fnd_message.set_token('DATE_CODE',p_date_cd);
4223: fnd_message.set_token('L_PROC',l_proc);
4224: fnd_message.set_token('PERSON_ID',l_person_id);
4225: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4226: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4219: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',115);
4220: end if;
4221: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4222: fnd_message.set_token('DATE_CODE',p_date_cd);
4223: fnd_message.set_token('L_PROC',l_proc);
4224: fnd_message.set_token('PERSON_ID',l_person_id);
4225: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4226: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4227: fnd_message.raise_error;
4220: end if;
4221: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4222: fnd_message.set_token('DATE_CODE',p_date_cd);
4223: fnd_message.set_token('L_PROC',l_proc);
4224: fnd_message.set_token('PERSON_ID',l_person_id);
4225: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4226: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4227: fnd_message.raise_error;
4228: end if;
4221: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4222: fnd_message.set_token('DATE_CODE',p_date_cd);
4223: fnd_message.set_token('L_PROC',l_proc);
4224: fnd_message.set_token('PERSON_ID',l_person_id);
4225: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4226: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4227: fnd_message.raise_error;
4228: end if;
4229: --
4222: fnd_message.set_token('DATE_CODE',p_date_cd);
4223: fnd_message.set_token('L_PROC',l_proc);
4224: fnd_message.set_token('PERSON_ID',l_person_id);
4225: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4226: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4227: fnd_message.raise_error;
4228: end if;
4229: --
4230: p_returned_date := l_pay_period.end_date;
4223: fnd_message.set_token('L_PROC',l_proc);
4224: fnd_message.set_token('PERSON_ID',l_person_id);
4225: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4226: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4227: fnd_message.raise_error;
4228: end if;
4229: --
4230: p_returned_date := l_pay_period.end_date;
4231: close c_pay_period ;
4248: --
4249: if c_next_pay_period%notfound then
4250: close c_next_pay_period;
4251: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',120);
4252: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4253: fnd_message.set_token('DATE_CODE',p_date_cd);
4254: fnd_message.set_token('PERSON_ID',l_person_id);
4255: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4256: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4249: if c_next_pay_period%notfound then
4250: close c_next_pay_period;
4251: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',120);
4252: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4253: fnd_message.set_token('DATE_CODE',p_date_cd);
4254: fnd_message.set_token('PERSON_ID',l_person_id);
4255: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4256: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4257: fnd_message.raise_error;
4250: close c_next_pay_period;
4251: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',120);
4252: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4253: fnd_message.set_token('DATE_CODE',p_date_cd);
4254: fnd_message.set_token('PERSON_ID',l_person_id);
4255: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4256: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4257: fnd_message.raise_error;
4258: end if;
4251: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',120);
4252: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4253: fnd_message.set_token('DATE_CODE',p_date_cd);
4254: fnd_message.set_token('PERSON_ID',l_person_id);
4255: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4256: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4257: fnd_message.raise_error;
4258: end if;
4259: close c_next_pay_period;
4252: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4253: fnd_message.set_token('DATE_CODE',p_date_cd);
4254: fnd_message.set_token('PERSON_ID',l_person_id);
4255: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4256: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4257: fnd_message.raise_error;
4258: end if;
4259: close c_next_pay_period;
4260:
4253: fnd_message.set_token('DATE_CODE',p_date_cd);
4254: fnd_message.set_token('PERSON_ID',l_person_id);
4255: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4256: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4257: fnd_message.raise_error;
4258: end if;
4259: close c_next_pay_period;
4260:
4261: p_returned_date := l_next_pay_period.start_date;
4491: --
4492: if c_pil_popl%notfound then
4493: close c_pil_popl;
4494: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',81);
4495: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4496: fnd_message.set_token('DATE_CODE',p_date_cd);
4497: fnd_message.set_token('L_PROC',l_proc);
4498: fnd_message.raise_error;
4499: end if;
4492: if c_pil_popl%notfound then
4493: close c_pil_popl;
4494: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',81);
4495: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4496: fnd_message.set_token('DATE_CODE',p_date_cd);
4497: fnd_message.set_token('L_PROC',l_proc);
4498: fnd_message.raise_error;
4499: end if;
4500: --
4493: close c_pil_popl;
4494: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',81);
4495: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4496: fnd_message.set_token('DATE_CODE',p_date_cd);
4497: fnd_message.set_token('L_PROC',l_proc);
4498: fnd_message.raise_error;
4499: end if;
4500: --
4501: close c_pil_popl;
4494: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',81);
4495: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4496: fnd_message.set_token('DATE_CODE',p_date_cd);
4497: fnd_message.set_token('L_PROC',l_proc);
4498: fnd_message.raise_error;
4499: end if;
4500: --
4501: close c_pil_popl;
4502: --
4516: fetch c_cm_enrt_perd_end_dt into l_cm_date;
4517: if c_cm_enrt_perd_end_dt%notfound then
4518: close c_cm_enrt_perd_end_dt;
4519: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',86);
4520: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4521: fnd_message.set_token('DATE_CODE',p_date_cd);
4522: fnd_message.set_token('L_PROC',l_proc);
4523: fnd_message.raise_error;
4524: end if;
4517: if c_cm_enrt_perd_end_dt%notfound then
4518: close c_cm_enrt_perd_end_dt;
4519: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',86);
4520: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4521: fnd_message.set_token('DATE_CODE',p_date_cd);
4522: fnd_message.set_token('L_PROC',l_proc);
4523: fnd_message.raise_error;
4524: end if;
4525: --
4518: close c_cm_enrt_perd_end_dt;
4519: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',86);
4520: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4521: fnd_message.set_token('DATE_CODE',p_date_cd);
4522: fnd_message.set_token('L_PROC',l_proc);
4523: fnd_message.raise_error;
4524: end if;
4525: --
4526: close c_cm_enrt_perd_end_dt;
4519: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',86);
4520: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4521: fnd_message.set_token('DATE_CODE',p_date_cd);
4522: fnd_message.set_token('L_PROC',l_proc);
4523: fnd_message.raise_error;
4524: end if;
4525: --
4526: close c_cm_enrt_perd_end_dt;
4527: --
4538: fetch c_cm_enrt_perd_end_dt into l_cm_date;
4539: if c_cm_enrt_perd_end_dt%notfound then
4540: close c_cm_enrt_perd_end_dt;
4541: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',87);
4542: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4543: fnd_message.set_token('DATE_CODE',p_date_cd);
4544: fnd_message.set_token('L_PROC',l_proc);
4545: fnd_message.raise_error;
4546: end if;
4539: if c_cm_enrt_perd_end_dt%notfound then
4540: close c_cm_enrt_perd_end_dt;
4541: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',87);
4542: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4543: fnd_message.set_token('DATE_CODE',p_date_cd);
4544: fnd_message.set_token('L_PROC',l_proc);
4545: fnd_message.raise_error;
4546: end if;
4547: --
4540: close c_cm_enrt_perd_end_dt;
4541: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',87);
4542: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4543: fnd_message.set_token('DATE_CODE',p_date_cd);
4544: fnd_message.set_token('L_PROC',l_proc);
4545: fnd_message.raise_error;
4546: end if;
4547: --
4548: close c_cm_enrt_perd_end_dt;
4541: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',87);
4542: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4543: fnd_message.set_token('DATE_CODE',p_date_cd);
4544: fnd_message.set_token('L_PROC',l_proc);
4545: fnd_message.raise_error;
4546: end if;
4547: --
4548: close c_cm_enrt_perd_end_dt;
4549: --
4559: fetch c_cm_enrt_perd_end_dt into l_cm_date;
4560: if c_cm_enrt_perd_end_dt%notfound then
4561: close c_cm_enrt_perd_end_dt;
4562: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',89);
4563: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4564: fnd_message.set_token('DATE_CODE',p_date_cd);
4565: fnd_message.set_token('L_PROC',l_proc);
4566: fnd_message.raise_error;
4567: end if;
4560: if c_cm_enrt_perd_end_dt%notfound then
4561: close c_cm_enrt_perd_end_dt;
4562: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',89);
4563: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4564: fnd_message.set_token('DATE_CODE',p_date_cd);
4565: fnd_message.set_token('L_PROC',l_proc);
4566: fnd_message.raise_error;
4567: end if;
4568: --
4561: close c_cm_enrt_perd_end_dt;
4562: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',89);
4563: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4564: fnd_message.set_token('DATE_CODE',p_date_cd);
4565: fnd_message.set_token('L_PROC',l_proc);
4566: fnd_message.raise_error;
4567: end if;
4568: --
4569: close c_cm_enrt_perd_end_dt;
4562: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',89);
4563: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4564: fnd_message.set_token('DATE_CODE',p_date_cd);
4565: fnd_message.set_token('L_PROC',l_proc);
4566: fnd_message.raise_error;
4567: end if;
4568: --
4569: close c_cm_enrt_perd_end_dt;
4570: --
4580: fetch c_cm_enrt_perd_end_dt into l_cm_date;
4581: if c_cm_enrt_perd_end_dt%notfound then
4582: close c_cm_enrt_perd_end_dt;
4583: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',90);
4584: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4585: fnd_message.set_token('DATE_CODE',p_date_cd);
4586: fnd_message.set_token('L_PROC',l_proc);
4587: fnd_message.raise_error;
4588: end if;
4581: if c_cm_enrt_perd_end_dt%notfound then
4582: close c_cm_enrt_perd_end_dt;
4583: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',90);
4584: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4585: fnd_message.set_token('DATE_CODE',p_date_cd);
4586: fnd_message.set_token('L_PROC',l_proc);
4587: fnd_message.raise_error;
4588: end if;
4589: --
4582: close c_cm_enrt_perd_end_dt;
4583: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',90);
4584: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4585: fnd_message.set_token('DATE_CODE',p_date_cd);
4586: fnd_message.set_token('L_PROC',l_proc);
4587: fnd_message.raise_error;
4588: end if;
4589: --
4590: close c_cm_enrt_perd_end_dt;
4583: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',90);
4584: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4585: fnd_message.set_token('DATE_CODE',p_date_cd);
4586: fnd_message.set_token('L_PROC',l_proc);
4587: fnd_message.raise_error;
4588: end if;
4589: --
4590: close c_cm_enrt_perd_end_dt;
4591: --
4601: fetch c_cm_enrt_perd_end_dt into l_cm_date;
4602: if c_cm_enrt_perd_end_dt%notfound then
4603: close c_cm_enrt_perd_end_dt;
4604: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',91);
4605: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4606: fnd_message.set_token('DATE_CODE',p_date_cd);
4607: fnd_message.set_token('L_PROC',l_proc);
4608: fnd_message.raise_error;
4609: end if;
4602: if c_cm_enrt_perd_end_dt%notfound then
4603: close c_cm_enrt_perd_end_dt;
4604: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',91);
4605: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4606: fnd_message.set_token('DATE_CODE',p_date_cd);
4607: fnd_message.set_token('L_PROC',l_proc);
4608: fnd_message.raise_error;
4609: end if;
4610: --
4603: close c_cm_enrt_perd_end_dt;
4604: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',91);
4605: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4606: fnd_message.set_token('DATE_CODE',p_date_cd);
4607: fnd_message.set_token('L_PROC',l_proc);
4608: fnd_message.raise_error;
4609: end if;
4610: --
4611: close c_cm_enrt_perd_end_dt;
4604: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',91);
4605: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4606: fnd_message.set_token('DATE_CODE',p_date_cd);
4607: fnd_message.set_token('L_PROC',l_proc);
4608: fnd_message.raise_error;
4609: end if;
4610: --
4611: close c_cm_enrt_perd_end_dt;
4612: --
4623: fetch c_cm_dflt_asnd_dt into l_cm_date;
4624: if c_cm_dflt_asnd_dt%notfound then
4625: close c_cm_dflt_asnd_dt;
4626: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',92);
4627: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4628: fnd_message.set_token('DATE_CODE',p_date_cd);
4629: fnd_message.set_token('L_PROC',l_proc);
4630: fnd_message.raise_error;
4631: end if;
4624: if c_cm_dflt_asnd_dt%notfound then
4625: close c_cm_dflt_asnd_dt;
4626: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',92);
4627: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4628: fnd_message.set_token('DATE_CODE',p_date_cd);
4629: fnd_message.set_token('L_PROC',l_proc);
4630: fnd_message.raise_error;
4631: end if;
4632: --
4625: close c_cm_dflt_asnd_dt;
4626: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',92);
4627: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4628: fnd_message.set_token('DATE_CODE',p_date_cd);
4629: fnd_message.set_token('L_PROC',l_proc);
4630: fnd_message.raise_error;
4631: end if;
4632: --
4633: close c_cm_dflt_asnd_dt;
4626: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',92);
4627: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4628: fnd_message.set_token('DATE_CODE',p_date_cd);
4629: fnd_message.set_token('L_PROC',l_proc);
4630: fnd_message.raise_error;
4631: end if;
4632: --
4633: close c_cm_dflt_asnd_dt;
4634: --
4644: fetch c_cm_elig_prtn_strt_dt into l_cm_date;
4645: if c_cm_elig_prtn_strt_dt%notfound then
4646: close c_cm_elig_prtn_strt_dt;
4647: -- hr_utility.set_location('BEN_91386_FIRST_INELIG',81);
4648: fnd_message.set_name('BEN', 'BEN_91386_FIRST_INELIG');
4649: fnd_message.set_token('DATE_CODE',p_date_cd);
4650: fnd_message.set_token('PROC',l_proc);
4651: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4652: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4645: if c_cm_elig_prtn_strt_dt%notfound then
4646: close c_cm_elig_prtn_strt_dt;
4647: -- hr_utility.set_location('BEN_91386_FIRST_INELIG',81);
4648: fnd_message.set_name('BEN', 'BEN_91386_FIRST_INELIG');
4649: fnd_message.set_token('DATE_CODE',p_date_cd);
4650: fnd_message.set_token('PROC',l_proc);
4651: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4652: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4653: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4646: close c_cm_elig_prtn_strt_dt;
4647: -- hr_utility.set_location('BEN_91386_FIRST_INELIG',81);
4648: fnd_message.set_name('BEN', 'BEN_91386_FIRST_INELIG');
4649: fnd_message.set_token('DATE_CODE',p_date_cd);
4650: fnd_message.set_token('PROC',l_proc);
4651: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4652: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4653: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4654: fnd_message.raise_error;
4647: -- hr_utility.set_location('BEN_91386_FIRST_INELIG',81);
4648: fnd_message.set_name('BEN', 'BEN_91386_FIRST_INELIG');
4649: fnd_message.set_token('DATE_CODE',p_date_cd);
4650: fnd_message.set_token('PROC',l_proc);
4651: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4652: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4653: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4654: fnd_message.raise_error;
4655: end if;
4648: fnd_message.set_name('BEN', 'BEN_91386_FIRST_INELIG');
4649: fnd_message.set_token('DATE_CODE',p_date_cd);
4650: fnd_message.set_token('PROC',l_proc);
4651: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4652: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4653: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4654: fnd_message.raise_error;
4655: end if;
4656: close c_cm_elig_prtn_strt_dt;
4649: fnd_message.set_token('DATE_CODE',p_date_cd);
4650: fnd_message.set_token('PROC',l_proc);
4651: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4652: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4653: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4654: fnd_message.raise_error;
4655: end if;
4656: close c_cm_elig_prtn_strt_dt;
4657: --
4650: fnd_message.set_token('PROC',l_proc);
4651: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4652: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4653: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4654: fnd_message.raise_error;
4655: end if;
4656: close c_cm_elig_prtn_strt_dt;
4657: --
4658: p_returned_date := l_cm_date - 14;
4665: fetch c_cm_elig_prtn_end_dt into l_cm_date;
4666: if c_cm_elig_prtn_end_dt%notfound then
4667: close c_cm_elig_prtn_end_dt;
4668: -- hr_utility.set_location('BEN_91386_FIRST_INELIG',93);
4669: fnd_message.set_name('BEN', 'BEN_91386_FIRST_INELIG');
4670: fnd_message.set_token('DATE_CODE',p_date_cd);
4671: fnd_message.set_token('PROC',l_proc);
4672: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4673: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4666: if c_cm_elig_prtn_end_dt%notfound then
4667: close c_cm_elig_prtn_end_dt;
4668: -- hr_utility.set_location('BEN_91386_FIRST_INELIG',93);
4669: fnd_message.set_name('BEN', 'BEN_91386_FIRST_INELIG');
4670: fnd_message.set_token('DATE_CODE',p_date_cd);
4671: fnd_message.set_token('PROC',l_proc);
4672: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4673: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4674: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4667: close c_cm_elig_prtn_end_dt;
4668: -- hr_utility.set_location('BEN_91386_FIRST_INELIG',93);
4669: fnd_message.set_name('BEN', 'BEN_91386_FIRST_INELIG');
4670: fnd_message.set_token('DATE_CODE',p_date_cd);
4671: fnd_message.set_token('PROC',l_proc);
4672: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4673: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4674: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4675: fnd_message.raise_error;
4668: -- hr_utility.set_location('BEN_91386_FIRST_INELIG',93);
4669: fnd_message.set_name('BEN', 'BEN_91386_FIRST_INELIG');
4670: fnd_message.set_token('DATE_CODE',p_date_cd);
4671: fnd_message.set_token('PROC',l_proc);
4672: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4673: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4674: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4675: fnd_message.raise_error;
4676: end if;
4669: fnd_message.set_name('BEN', 'BEN_91386_FIRST_INELIG');
4670: fnd_message.set_token('DATE_CODE',p_date_cd);
4671: fnd_message.set_token('PROC',l_proc);
4672: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4673: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4674: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4675: fnd_message.raise_error;
4676: end if;
4677: close c_cm_elig_prtn_end_dt;
4670: fnd_message.set_token('DATE_CODE',p_date_cd);
4671: fnd_message.set_token('PROC',l_proc);
4672: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4673: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4674: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4675: fnd_message.raise_error;
4676: end if;
4677: close c_cm_elig_prtn_end_dt;
4678: --
4671: fnd_message.set_token('PROC',l_proc);
4672: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4673: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4674: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4675: fnd_message.raise_error;
4676: end if;
4677: close c_cm_elig_prtn_end_dt;
4678: --
4679: p_returned_date := l_cm_date - 14;
4688: fetch c_cm_enrt_perd_end_dt into l_cm_date;
4689: if c_cm_enrt_perd_end_dt%notfound then
4690: close c_cm_enrt_perd_end_dt;
4691: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',88);
4692: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4693: fnd_message.set_token('DATE_CODE',p_date_cd);
4694: fnd_message.set_token('L_PROC',l_proc);
4695: fnd_message.raise_error;
4696: end if;
4689: if c_cm_enrt_perd_end_dt%notfound then
4690: close c_cm_enrt_perd_end_dt;
4691: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',88);
4692: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4693: fnd_message.set_token('DATE_CODE',p_date_cd);
4694: fnd_message.set_token('L_PROC',l_proc);
4695: fnd_message.raise_error;
4696: end if;
4697: --
4690: close c_cm_enrt_perd_end_dt;
4691: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',88);
4692: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4693: fnd_message.set_token('DATE_CODE',p_date_cd);
4694: fnd_message.set_token('L_PROC',l_proc);
4695: fnd_message.raise_error;
4696: end if;
4697: --
4698: close c_cm_enrt_perd_end_dt;
4691: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',88);
4692: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4693: fnd_message.set_token('DATE_CODE',p_date_cd);
4694: fnd_message.set_token('L_PROC',l_proc);
4695: fnd_message.raise_error;
4696: end if;
4697: --
4698: close c_cm_enrt_perd_end_dt;
4699: --
4708: fetch c_cm_auto_asnd_dt into l_cm_date;
4709: if c_cm_auto_asnd_dt%notfound then
4710: close c_cm_auto_asnd_dt;
4711: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',98);
4712: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4713: fnd_message.set_token('DATE_CODE',p_date_cd);
4714: fnd_message.set_token('L_PROC',l_proc);
4715: fnd_message.raise_error;
4716: end if;
4709: if c_cm_auto_asnd_dt%notfound then
4710: close c_cm_auto_asnd_dt;
4711: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',98);
4712: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4713: fnd_message.set_token('DATE_CODE',p_date_cd);
4714: fnd_message.set_token('L_PROC',l_proc);
4715: fnd_message.raise_error;
4716: end if;
4717: close c_cm_auto_asnd_dt;
4710: close c_cm_auto_asnd_dt;
4711: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',98);
4712: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4713: fnd_message.set_token('DATE_CODE',p_date_cd);
4714: fnd_message.set_token('L_PROC',l_proc);
4715: fnd_message.raise_error;
4716: end if;
4717: close c_cm_auto_asnd_dt;
4718: --
4711: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',98);
4712: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4713: fnd_message.set_token('DATE_CODE',p_date_cd);
4714: fnd_message.set_token('L_PROC',l_proc);
4715: fnd_message.raise_error;
4716: end if;
4717: close c_cm_auto_asnd_dt;
4718: --
4719: p_returned_date := l_cm_date;
4811: --
4812: close c_pay_period_for_date;
4813: -- hr_utility.set_location('BEN_92380_CANNOT_CALC_LFDPPCF',96);
4814: -- hr_utility.set_location('l_lf_evt_ocrd_dt'||to_char(l_lf_evt_ocrd_dt),96);
4815: fnd_message.set_name('BEN','BEN_92380_CANNOT_CALC_LFDPPCF');
4816: fnd_message.set_token('L_PROC',l_proc);
4817: fnd_message.set_token('PERSON_ID',l_person_id);
4818: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4819: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4812: close c_pay_period_for_date;
4813: -- hr_utility.set_location('BEN_92380_CANNOT_CALC_LFDPPCF',96);
4814: -- hr_utility.set_location('l_lf_evt_ocrd_dt'||to_char(l_lf_evt_ocrd_dt),96);
4815: fnd_message.set_name('BEN','BEN_92380_CANNOT_CALC_LFDPPCF');
4816: fnd_message.set_token('L_PROC',l_proc);
4817: fnd_message.set_token('PERSON_ID',l_person_id);
4818: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4819: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4820: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);
4813: -- hr_utility.set_location('BEN_92380_CANNOT_CALC_LFDPPCF',96);
4814: -- hr_utility.set_location('l_lf_evt_ocrd_dt'||to_char(l_lf_evt_ocrd_dt),96);
4815: fnd_message.set_name('BEN','BEN_92380_CANNOT_CALC_LFDPPCF');
4816: fnd_message.set_token('L_PROC',l_proc);
4817: fnd_message.set_token('PERSON_ID',l_person_id);
4818: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4819: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4820: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);
4821: fnd_message.raise_error;
4814: -- hr_utility.set_location('l_lf_evt_ocrd_dt'||to_char(l_lf_evt_ocrd_dt),96);
4815: fnd_message.set_name('BEN','BEN_92380_CANNOT_CALC_LFDPPCF');
4816: fnd_message.set_token('L_PROC',l_proc);
4817: fnd_message.set_token('PERSON_ID',l_person_id);
4818: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4819: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4820: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);
4821: fnd_message.raise_error;
4822: --
4815: fnd_message.set_name('BEN','BEN_92380_CANNOT_CALC_LFDPPCF');
4816: fnd_message.set_token('L_PROC',l_proc);
4817: fnd_message.set_token('PERSON_ID',l_person_id);
4818: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4819: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4820: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);
4821: fnd_message.raise_error;
4822: --
4823: end if;
4816: fnd_message.set_token('L_PROC',l_proc);
4817: fnd_message.set_token('PERSON_ID',l_person_id);
4818: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4819: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4820: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);
4821: fnd_message.raise_error;
4822: --
4823: end if;
4824: --
4817: fnd_message.set_token('PERSON_ID',l_person_id);
4818: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4819: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4820: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);
4821: fnd_message.raise_error;
4822: --
4823: end if;
4824: --
4825: close c_pay_period_for_date;
4835: --
4836: if c_next_pay_period%notfound then
4837: close c_next_pay_period;
4838: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',125);
4839: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4840: fnd_message.set_token('DATE_CODE',p_date_cd);
4841: fnd_message.set_token('PERSON_ID',l_person_id);
4842: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4843: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4836: if c_next_pay_period%notfound then
4837: close c_next_pay_period;
4838: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',125);
4839: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4840: fnd_message.set_token('DATE_CODE',p_date_cd);
4841: fnd_message.set_token('PERSON_ID',l_person_id);
4842: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4843: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4844: fnd_message.raise_error;
4837: close c_next_pay_period;
4838: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',125);
4839: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4840: fnd_message.set_token('DATE_CODE',p_date_cd);
4841: fnd_message.set_token('PERSON_ID',l_person_id);
4842: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4843: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4844: fnd_message.raise_error;
4845: end if;
4838: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',125);
4839: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4840: fnd_message.set_token('DATE_CODE',p_date_cd);
4841: fnd_message.set_token('PERSON_ID',l_person_id);
4842: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4843: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4844: fnd_message.raise_error;
4845: end if;
4846: --
4839: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4840: fnd_message.set_token('DATE_CODE',p_date_cd);
4841: fnd_message.set_token('PERSON_ID',l_person_id);
4842: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4843: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4844: fnd_message.raise_error;
4845: end if;
4846: --
4847: p_returned_date := l_next_pay_period.start_date;
4840: fnd_message.set_token('DATE_CODE',p_date_cd);
4841: fnd_message.set_token('PERSON_ID',l_person_id);
4842: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4843: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4844: fnd_message.raise_error;
4845: end if;
4846: --
4847: p_returned_date := l_next_pay_period.start_date;
4848: --
4861: --
4862: close c_pay_period_for_date;
4863: -- hr_utility.set_location('BEN_92380_CANNOT_CALC_LFDPPCF',97);
4864: -- hr_utility.set_location('l_recorded_date'||to_char(l_recorded_date),97);
4865: fnd_message.set_name('BEN','BEN_92380_CANNOT_CALC_LFDPPCF');
4866: fnd_message.set_token('L_PROC',l_proc);
4867: fnd_message.set_token('PERSON_ID',l_person_id);
4868: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4869: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4862: close c_pay_period_for_date;
4863: -- hr_utility.set_location('BEN_92380_CANNOT_CALC_LFDPPCF',97);
4864: -- hr_utility.set_location('l_recorded_date'||to_char(l_recorded_date),97);
4865: fnd_message.set_name('BEN','BEN_92380_CANNOT_CALC_LFDPPCF');
4866: fnd_message.set_token('L_PROC',l_proc);
4867: fnd_message.set_token('PERSON_ID',l_person_id);
4868: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4869: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4870: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);
4863: -- hr_utility.set_location('BEN_92380_CANNOT_CALC_LFDPPCF',97);
4864: -- hr_utility.set_location('l_recorded_date'||to_char(l_recorded_date),97);
4865: fnd_message.set_name('BEN','BEN_92380_CANNOT_CALC_LFDPPCF');
4866: fnd_message.set_token('L_PROC',l_proc);
4867: fnd_message.set_token('PERSON_ID',l_person_id);
4868: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4869: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4870: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);
4871: fnd_message.raise_error;
4864: -- hr_utility.set_location('l_recorded_date'||to_char(l_recorded_date),97);
4865: fnd_message.set_name('BEN','BEN_92380_CANNOT_CALC_LFDPPCF');
4866: fnd_message.set_token('L_PROC',l_proc);
4867: fnd_message.set_token('PERSON_ID',l_person_id);
4868: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4869: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4870: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);
4871: fnd_message.raise_error;
4872: --
4865: fnd_message.set_name('BEN','BEN_92380_CANNOT_CALC_LFDPPCF');
4866: fnd_message.set_token('L_PROC',l_proc);
4867: fnd_message.set_token('PERSON_ID',l_person_id);
4868: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4869: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4870: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);
4871: fnd_message.raise_error;
4872: --
4873: end if;
4866: fnd_message.set_token('L_PROC',l_proc);
4867: fnd_message.set_token('PERSON_ID',l_person_id);
4868: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4869: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4870: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);
4871: fnd_message.raise_error;
4872: --
4873: end if;
4874: --
4867: fnd_message.set_token('PERSON_ID',l_person_id);
4868: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4869: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4870: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);
4871: fnd_message.raise_error;
4872: --
4873: end if;
4874: --
4875: close c_pay_period_for_date;
4887: --
4888: if c_next_pay_period%notfound then
4889: close c_next_pay_period;
4890: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',130);
4891: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4892: fnd_message.set_token('DATE_CODE',p_date_cd);
4893: fnd_message.set_token('PERSON_ID',l_person_id);
4894: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4895: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4888: if c_next_pay_period%notfound then
4889: close c_next_pay_period;
4890: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',130);
4891: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4892: fnd_message.set_token('DATE_CODE',p_date_cd);
4893: fnd_message.set_token('PERSON_ID',l_person_id);
4894: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4895: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4896: fnd_message.raise_error;
4889: close c_next_pay_period;
4890: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',130);
4891: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4892: fnd_message.set_token('DATE_CODE',p_date_cd);
4893: fnd_message.set_token('PERSON_ID',l_person_id);
4894: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4895: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4896: fnd_message.raise_error;
4897: end if;
4890: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',130);
4891: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4892: fnd_message.set_token('DATE_CODE',p_date_cd);
4893: fnd_message.set_token('PERSON_ID',l_person_id);
4894: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4895: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4896: fnd_message.raise_error;
4897: end if;
4898: --
4891: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4892: fnd_message.set_token('DATE_CODE',p_date_cd);
4893: fnd_message.set_token('PERSON_ID',l_person_id);
4894: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4895: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4896: fnd_message.raise_error;
4897: end if;
4898: --
4899: p_returned_date := l_next_pay_period.start_date;
4892: fnd_message.set_token('DATE_CODE',p_date_cd);
4893: fnd_message.set_token('PERSON_ID',l_person_id);
4894: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4895: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4896: fnd_message.raise_error;
4897: end if;
4898: --
4899: p_returned_date := l_next_pay_period.start_date;
4900: --
5080: fetch c_cm_dflt_asnd_dt into l_cm_date;
5081: if c_cm_dflt_asnd_dt%notfound then
5082: close c_cm_dflt_asnd_dt;
5083: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',96);
5084: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
5085: fnd_message.set_token('DATE_CODE',p_date_cd);
5086: fnd_message.set_token('L_PROC',l_proc);
5087: fnd_message.raise_error;
5088: end if;
5081: if c_cm_dflt_asnd_dt%notfound then
5082: close c_cm_dflt_asnd_dt;
5083: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',96);
5084: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
5085: fnd_message.set_token('DATE_CODE',p_date_cd);
5086: fnd_message.set_token('L_PROC',l_proc);
5087: fnd_message.raise_error;
5088: end if;
5089: close c_cm_dflt_asnd_dt;
5082: close c_cm_dflt_asnd_dt;
5083: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',96);
5084: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
5085: fnd_message.set_token('DATE_CODE',p_date_cd);
5086: fnd_message.set_token('L_PROC',l_proc);
5087: fnd_message.raise_error;
5088: end if;
5089: close c_cm_dflt_asnd_dt;
5090: --
5083: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',96);
5084: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
5085: fnd_message.set_token('DATE_CODE',p_date_cd);
5086: fnd_message.set_token('L_PROC',l_proc);
5087: fnd_message.raise_error;
5088: end if;
5089: close c_cm_dflt_asnd_dt;
5090: --
5091: p_returned_date := l_cm_date;
5100: fetch c_cm_elig_prtn_strt_dt into l_cm_date;
5101: if c_cm_elig_prtn_strt_dt%notfound then
5102: close c_cm_elig_prtn_strt_dt;
5103: -- hr_utility.set_location('BEN_92381_ELIG_PER_NOT_FOUND',96);
5104: fnd_message.set_name('BEN', 'BEN_92381_ELIG_PER_NOT_FOUND');
5105: fnd_message.set_token('PROC',l_proc);
5106: fnd_message.set_token('DATE_CODE',p_date_cd);
5107: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5108: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5101: if c_cm_elig_prtn_strt_dt%notfound then
5102: close c_cm_elig_prtn_strt_dt;
5103: -- hr_utility.set_location('BEN_92381_ELIG_PER_NOT_FOUND',96);
5104: fnd_message.set_name('BEN', 'BEN_92381_ELIG_PER_NOT_FOUND');
5105: fnd_message.set_token('PROC',l_proc);
5106: fnd_message.set_token('DATE_CODE',p_date_cd);
5107: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5108: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5109: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5102: close c_cm_elig_prtn_strt_dt;
5103: -- hr_utility.set_location('BEN_92381_ELIG_PER_NOT_FOUND',96);
5104: fnd_message.set_name('BEN', 'BEN_92381_ELIG_PER_NOT_FOUND');
5105: fnd_message.set_token('PROC',l_proc);
5106: fnd_message.set_token('DATE_CODE',p_date_cd);
5107: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5108: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5109: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5110: fnd_message.raise_error;
5103: -- hr_utility.set_location('BEN_92381_ELIG_PER_NOT_FOUND',96);
5104: fnd_message.set_name('BEN', 'BEN_92381_ELIG_PER_NOT_FOUND');
5105: fnd_message.set_token('PROC',l_proc);
5106: fnd_message.set_token('DATE_CODE',p_date_cd);
5107: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5108: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5109: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5110: fnd_message.raise_error;
5111: end if;
5104: fnd_message.set_name('BEN', 'BEN_92381_ELIG_PER_NOT_FOUND');
5105: fnd_message.set_token('PROC',l_proc);
5106: fnd_message.set_token('DATE_CODE',p_date_cd);
5107: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5108: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5109: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5110: fnd_message.raise_error;
5111: end if;
5112: close c_cm_elig_prtn_strt_dt;
5105: fnd_message.set_token('PROC',l_proc);
5106: fnd_message.set_token('DATE_CODE',p_date_cd);
5107: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5108: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5109: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5110: fnd_message.raise_error;
5111: end if;
5112: close c_cm_elig_prtn_strt_dt;
5113: --
5106: fnd_message.set_token('DATE_CODE',p_date_cd);
5107: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5108: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5109: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5110: fnd_message.raise_error;
5111: end if;
5112: close c_cm_elig_prtn_strt_dt;
5113: --
5114: p_returned_date := l_cm_date;
5123: fetch c_cm_elig_prtn_end_dt into l_cm_date;
5124: if c_cm_elig_prtn_end_dt%notfound then
5125: close c_cm_elig_prtn_end_dt;
5126: -- hr_utility.set_location('BEN_92381_ELIG_PER_NOT_FOUND',98);
5127: fnd_message.set_name('BEN', 'BEN_92381_ELIG_PER_NOT_FOUND');
5128: fnd_message.set_token('PROC',l_proc);
5129: fnd_message.set_token('DATE_CODE',p_date_cd);
5130: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5131: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5124: if c_cm_elig_prtn_end_dt%notfound then
5125: close c_cm_elig_prtn_end_dt;
5126: -- hr_utility.set_location('BEN_92381_ELIG_PER_NOT_FOUND',98);
5127: fnd_message.set_name('BEN', 'BEN_92381_ELIG_PER_NOT_FOUND');
5128: fnd_message.set_token('PROC',l_proc);
5129: fnd_message.set_token('DATE_CODE',p_date_cd);
5130: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5131: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5132: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5125: close c_cm_elig_prtn_end_dt;
5126: -- hr_utility.set_location('BEN_92381_ELIG_PER_NOT_FOUND',98);
5127: fnd_message.set_name('BEN', 'BEN_92381_ELIG_PER_NOT_FOUND');
5128: fnd_message.set_token('PROC',l_proc);
5129: fnd_message.set_token('DATE_CODE',p_date_cd);
5130: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5131: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5132: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5133: fnd_message.raise_error;
5126: -- hr_utility.set_location('BEN_92381_ELIG_PER_NOT_FOUND',98);
5127: fnd_message.set_name('BEN', 'BEN_92381_ELIG_PER_NOT_FOUND');
5128: fnd_message.set_token('PROC',l_proc);
5129: fnd_message.set_token('DATE_CODE',p_date_cd);
5130: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5131: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5132: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5133: fnd_message.raise_error;
5134: end if;
5127: fnd_message.set_name('BEN', 'BEN_92381_ELIG_PER_NOT_FOUND');
5128: fnd_message.set_token('PROC',l_proc);
5129: fnd_message.set_token('DATE_CODE',p_date_cd);
5130: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5131: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5132: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5133: fnd_message.raise_error;
5134: end if;
5135: close c_cm_elig_prtn_end_dt;
5128: fnd_message.set_token('PROC',l_proc);
5129: fnd_message.set_token('DATE_CODE',p_date_cd);
5130: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5131: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5132: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5133: fnd_message.raise_error;
5134: end if;
5135: close c_cm_elig_prtn_end_dt;
5136: --
5129: fnd_message.set_token('DATE_CODE',p_date_cd);
5130: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5131: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5132: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5133: fnd_message.raise_error;
5134: end if;
5135: close c_cm_elig_prtn_end_dt;
5136: --
5137: p_returned_date := l_cm_date;
5145: open c_cm_enrt_perd_end_dt;
5146: fetch c_cm_enrt_perd_end_dt into l_cm_date;
5147: if c_cm_enrt_perd_end_dt%notfound then
5148: close c_cm_enrt_perd_end_dt;
5149: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
5150: fnd_message.set_token('DATE_CODE',p_date_cd);
5151: fnd_message.set_token('L_PROC',l_proc);
5152: fnd_message.raise_error;
5153: end if;
5146: fetch c_cm_enrt_perd_end_dt into l_cm_date;
5147: if c_cm_enrt_perd_end_dt%notfound then
5148: close c_cm_enrt_perd_end_dt;
5149: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
5150: fnd_message.set_token('DATE_CODE',p_date_cd);
5151: fnd_message.set_token('L_PROC',l_proc);
5152: fnd_message.raise_error;
5153: end if;
5154: close c_cm_enrt_perd_end_dt;
5147: if c_cm_enrt_perd_end_dt%notfound then
5148: close c_cm_enrt_perd_end_dt;
5149: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
5150: fnd_message.set_token('DATE_CODE',p_date_cd);
5151: fnd_message.set_token('L_PROC',l_proc);
5152: fnd_message.raise_error;
5153: end if;
5154: close c_cm_enrt_perd_end_dt;
5155: --
5148: close c_cm_enrt_perd_end_dt;
5149: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
5150: fnd_message.set_token('DATE_CODE',p_date_cd);
5151: fnd_message.set_token('L_PROC',l_proc);
5152: fnd_message.raise_error;
5153: end if;
5154: close c_cm_enrt_perd_end_dt;
5155: --
5156: p_returned_date := l_cm_date;
5292: fetch c_pay_period into l_pay_period;
5293: if c_pay_period%notfound then
5294: close c_pay_period;
5295: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',135);
5296: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5297: fnd_message.set_token('DATE_CODE',p_date_cd);
5298: fnd_message.set_token('PERSON_ID',l_person_id);
5299: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5300: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5293: if c_pay_period%notfound then
5294: close c_pay_period;
5295: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',135);
5296: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5297: fnd_message.set_token('DATE_CODE',p_date_cd);
5298: fnd_message.set_token('PERSON_ID',l_person_id);
5299: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5300: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5301: fnd_message.raise_error;
5294: close c_pay_period;
5295: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',135);
5296: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5297: fnd_message.set_token('DATE_CODE',p_date_cd);
5298: fnd_message.set_token('PERSON_ID',l_person_id);
5299: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5300: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5301: fnd_message.raise_error;
5302: end if;
5295: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',135);
5296: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5297: fnd_message.set_token('DATE_CODE',p_date_cd);
5298: fnd_message.set_token('PERSON_ID',l_person_id);
5299: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5300: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5301: fnd_message.raise_error;
5302: end if;
5303: --
5296: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5297: fnd_message.set_token('DATE_CODE',p_date_cd);
5298: fnd_message.set_token('PERSON_ID',l_person_id);
5299: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5300: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5301: fnd_message.raise_error;
5302: end if;
5303: --
5304: close c_pay_period ;
5297: fnd_message.set_token('DATE_CODE',p_date_cd);
5298: fnd_message.set_token('PERSON_ID',l_person_id);
5299: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5300: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5301: fnd_message.raise_error;
5302: end if;
5303: --
5304: close c_pay_period ;
5305: --
5314: --
5315: if c_next_pay_period%notfound then
5316: close c_next_pay_period;
5317: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',140);
5318: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5319: fnd_message.set_token('DATE_CODE',p_date_cd);
5320: fnd_message.set_token('PERSON_ID',l_person_id);
5321: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5322: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5315: if c_next_pay_period%notfound then
5316: close c_next_pay_period;
5317: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',140);
5318: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5319: fnd_message.set_token('DATE_CODE',p_date_cd);
5320: fnd_message.set_token('PERSON_ID',l_person_id);
5321: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5322: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5323: fnd_message.raise_error;
5316: close c_next_pay_period;
5317: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',140);
5318: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5319: fnd_message.set_token('DATE_CODE',p_date_cd);
5320: fnd_message.set_token('PERSON_ID',l_person_id);
5321: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5322: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5323: fnd_message.raise_error;
5324: end if;
5317: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',140);
5318: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5319: fnd_message.set_token('DATE_CODE',p_date_cd);
5320: fnd_message.set_token('PERSON_ID',l_person_id);
5321: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5322: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5323: fnd_message.raise_error;
5324: end if;
5325: --
5318: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5319: fnd_message.set_token('DATE_CODE',p_date_cd);
5320: fnd_message.set_token('PERSON_ID',l_person_id);
5321: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5322: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5323: fnd_message.raise_error;
5324: end if;
5325: --
5326: p_returned_date := l_next_pay_period.start_date;
5319: fnd_message.set_token('DATE_CODE',p_date_cd);
5320: fnd_message.set_token('PERSON_ID',l_person_id);
5321: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5322: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5323: fnd_message.raise_error;
5324: end if;
5325: --
5326: p_returned_date := l_next_pay_period.start_date;
5327: --
5730: if c_pay_period_for_date%notfound then
5731: --
5732: close c_pay_period_for_date;
5733: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',145);
5734: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5735: fnd_message.set_token('DATE_CODE',p_date_cd);
5736: fnd_message.set_token('PERSON_ID',l_person_id);
5737: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5738: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5731: --
5732: close c_pay_period_for_date;
5733: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',145);
5734: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5735: fnd_message.set_token('DATE_CODE',p_date_cd);
5736: fnd_message.set_token('PERSON_ID',l_person_id);
5737: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5738: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5739: fnd_message.raise_error;
5732: close c_pay_period_for_date;
5733: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',145);
5734: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5735: fnd_message.set_token('DATE_CODE',p_date_cd);
5736: fnd_message.set_token('PERSON_ID',l_person_id);
5737: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5738: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5739: fnd_message.raise_error;
5740: --
5733: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',145);
5734: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5735: fnd_message.set_token('DATE_CODE',p_date_cd);
5736: fnd_message.set_token('PERSON_ID',l_person_id);
5737: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5738: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5739: fnd_message.raise_error;
5740: --
5741: end if;
5734: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5735: fnd_message.set_token('DATE_CODE',p_date_cd);
5736: fnd_message.set_token('PERSON_ID',l_person_id);
5737: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5738: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5739: fnd_message.raise_error;
5740: --
5741: end if;
5742: --
5735: fnd_message.set_token('DATE_CODE',p_date_cd);
5736: fnd_message.set_token('PERSON_ID',l_person_id);
5737: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5738: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5739: fnd_message.raise_error;
5740: --
5741: end if;
5742: --
5743: close c_pay_period_for_date;
5771: if c_pre_pay_period%notfound then
5772: --
5773: close c_pre_pay_period;
5774: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',150);
5775: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5776: fnd_message.set_token('DATE_CODE',p_date_cd);
5777: fnd_message.set_token('PERSON_ID',l_person_id);
5778: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5779: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5772: --
5773: close c_pre_pay_period;
5774: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',150);
5775: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5776: fnd_message.set_token('DATE_CODE',p_date_cd);
5777: fnd_message.set_token('PERSON_ID',l_person_id);
5778: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5779: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5780: fnd_message.raise_error;
5773: close c_pre_pay_period;
5774: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',150);
5775: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5776: fnd_message.set_token('DATE_CODE',p_date_cd);
5777: fnd_message.set_token('PERSON_ID',l_person_id);
5778: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5779: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5780: fnd_message.raise_error;
5781: --
5774: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',150);
5775: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5776: fnd_message.set_token('DATE_CODE',p_date_cd);
5777: fnd_message.set_token('PERSON_ID',l_person_id);
5778: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5779: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5780: fnd_message.raise_error;
5781: --
5782: end if;
5775: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5776: fnd_message.set_token('DATE_CODE',p_date_cd);
5777: fnd_message.set_token('PERSON_ID',l_person_id);
5778: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5779: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5780: fnd_message.raise_error;
5781: --
5782: end if;
5783: --
5776: fnd_message.set_token('DATE_CODE',p_date_cd);
5777: fnd_message.set_token('PERSON_ID',l_person_id);
5778: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5779: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5780: fnd_message.raise_error;
5781: --
5782: end if;
5783: --
5784: close c_pre_pay_period;
6024: l_end_date;
6025: --
6026: if c_pay_period_for_date%notfound then
6027: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',160);
6028: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6029: fnd_message.set_token('DATE_CODE',p_date_cd);
6030: fnd_message.set_token('PERSON_ID',l_person_id);
6031: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6032: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6025: --
6026: if c_pay_period_for_date%notfound then
6027: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',160);
6028: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6029: fnd_message.set_token('DATE_CODE',p_date_cd);
6030: fnd_message.set_token('PERSON_ID',l_person_id);
6031: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6032: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6033: fnd_message.raise_error;
6026: if c_pay_period_for_date%notfound then
6027: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',160);
6028: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6029: fnd_message.set_token('DATE_CODE',p_date_cd);
6030: fnd_message.set_token('PERSON_ID',l_person_id);
6031: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6032: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6033: fnd_message.raise_error;
6034: --
6027: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',160);
6028: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6029: fnd_message.set_token('DATE_CODE',p_date_cd);
6030: fnd_message.set_token('PERSON_ID',l_person_id);
6031: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6032: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6033: fnd_message.raise_error;
6034: --
6035: end if;
6028: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6029: fnd_message.set_token('DATE_CODE',p_date_cd);
6030: fnd_message.set_token('PERSON_ID',l_person_id);
6031: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6032: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6033: fnd_message.raise_error;
6034: --
6035: end if;
6036: --
6029: fnd_message.set_token('DATE_CODE',p_date_cd);
6030: fnd_message.set_token('PERSON_ID',l_person_id);
6031: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6032: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6033: fnd_message.raise_error;
6034: --
6035: end if;
6036: --
6037: close c_pay_period_for_date;
6059: l_end_date;
6060: --
6061: if c_pay_period_for_date%notfound then
6062: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',165);
6063: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6064: fnd_message.set_token('DATE_CODE',p_date_cd);
6065: fnd_message.set_token('PERSON_ID',l_person_id);
6066: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6067: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6060: --
6061: if c_pay_period_for_date%notfound then
6062: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',165);
6063: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6064: fnd_message.set_token('DATE_CODE',p_date_cd);
6065: fnd_message.set_token('PERSON_ID',l_person_id);
6066: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6067: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6068: fnd_message.raise_error;
6061: if c_pay_period_for_date%notfound then
6062: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',165);
6063: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6064: fnd_message.set_token('DATE_CODE',p_date_cd);
6065: fnd_message.set_token('PERSON_ID',l_person_id);
6066: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6067: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6068: fnd_message.raise_error;
6069: --
6062: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',165);
6063: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6064: fnd_message.set_token('DATE_CODE',p_date_cd);
6065: fnd_message.set_token('PERSON_ID',l_person_id);
6066: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6067: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6068: fnd_message.raise_error;
6069: --
6070: end if;
6063: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6064: fnd_message.set_token('DATE_CODE',p_date_cd);
6065: fnd_message.set_token('PERSON_ID',l_person_id);
6066: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6067: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6068: fnd_message.raise_error;
6069: --
6070: end if;
6071: --
6064: fnd_message.set_token('DATE_CODE',p_date_cd);
6065: fnd_message.set_token('PERSON_ID',l_person_id);
6066: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6067: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6068: fnd_message.raise_error;
6069: --
6070: end if;
6071: --
6072: close c_pay_period_for_date;
6366: fetch c_pay_period into l_pay_period;
6367: if c_pay_period%notfound then
6368: close c_pay_period;
6369: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',170);
6370: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6371: fnd_message.set_token('DATE_CODE',p_date_cd);
6372: fnd_message.set_token('PERSON_ID',l_person_id);
6373: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6374: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6367: if c_pay_period%notfound then
6368: close c_pay_period;
6369: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',170);
6370: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6371: fnd_message.set_token('DATE_CODE',p_date_cd);
6372: fnd_message.set_token('PERSON_ID',l_person_id);
6373: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6374: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6375: fnd_message.raise_error;
6368: close c_pay_period;
6369: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',170);
6370: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6371: fnd_message.set_token('DATE_CODE',p_date_cd);
6372: fnd_message.set_token('PERSON_ID',l_person_id);
6373: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6374: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6375: fnd_message.raise_error;
6376: end if;
6369: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',170);
6370: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6371: fnd_message.set_token('DATE_CODE',p_date_cd);
6372: fnd_message.set_token('PERSON_ID',l_person_id);
6373: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6374: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6375: fnd_message.raise_error;
6376: end if;
6377: p_returned_date := l_pay_period.end_date;
6370: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6371: fnd_message.set_token('DATE_CODE',p_date_cd);
6372: fnd_message.set_token('PERSON_ID',l_person_id);
6373: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6374: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6375: fnd_message.raise_error;
6376: end if;
6377: p_returned_date := l_pay_period.end_date;
6378: close c_pay_period ;
6371: fnd_message.set_token('DATE_CODE',p_date_cd);
6372: fnd_message.set_token('PERSON_ID',l_person_id);
6373: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6374: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6375: fnd_message.raise_error;
6376: end if;
6377: p_returned_date := l_pay_period.end_date;
6378: close c_pay_period ;
6379: --
6407: --
6408: if c_next_pay_period%notfound then
6409: close c_next_pay_period;
6410: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',170);
6411: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6412: fnd_message.set_token('DATE_CODE',p_date_cd);
6413: fnd_message.set_token('PERSON_ID',l_person_id);
6414: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6415: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6408: if c_next_pay_period%notfound then
6409: close c_next_pay_period;
6410: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',170);
6411: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6412: fnd_message.set_token('DATE_CODE',p_date_cd);
6413: fnd_message.set_token('PERSON_ID',l_person_id);
6414: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6415: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6416: fnd_message.raise_error;
6409: close c_next_pay_period;
6410: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',170);
6411: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6412: fnd_message.set_token('DATE_CODE',p_date_cd);
6413: fnd_message.set_token('PERSON_ID',l_person_id);
6414: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6415: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6416: fnd_message.raise_error;
6417: end if;
6410: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',170);
6411: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6412: fnd_message.set_token('DATE_CODE',p_date_cd);
6413: fnd_message.set_token('PERSON_ID',l_person_id);
6414: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6415: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6416: fnd_message.raise_error;
6417: end if;
6418: p_returned_date := l_next_pay_period.start_date;
6411: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6412: fnd_message.set_token('DATE_CODE',p_date_cd);
6413: fnd_message.set_token('PERSON_ID',l_person_id);
6414: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6415: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6416: fnd_message.raise_error;
6417: end if;
6418: p_returned_date := l_next_pay_period.start_date;
6419: close c_next_pay_period;
6412: fnd_message.set_token('DATE_CODE',p_date_cd);
6413: fnd_message.set_token('PERSON_ID',l_person_id);
6414: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6415: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6416: fnd_message.raise_error;
6417: end if;
6418: p_returned_date := l_next_pay_period.start_date;
6419: close c_next_pay_period;
6420: --
6481: if g_debug then
6482: hr_utility.set_location(' Hire date ' || l_hire_date, 99 );
6483: end if;
6484: if l_hire_date is null then
6485: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
6486: fnd_message.set_token('DATE_CODE',p_date_cd);
6487: fnd_message.set_token('L_PROC',l_proc);
6488: fnd_message.raise_error;
6489: end if ;
6482: hr_utility.set_location(' Hire date ' || l_hire_date, 99 );
6483: end if;
6484: if l_hire_date is null then
6485: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
6486: fnd_message.set_token('DATE_CODE',p_date_cd);
6487: fnd_message.set_token('L_PROC',l_proc);
6488: fnd_message.raise_error;
6489: end if ;
6490: if g_debug then
6483: end if;
6484: if l_hire_date is null then
6485: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
6486: fnd_message.set_token('DATE_CODE',p_date_cd);
6487: fnd_message.set_token('L_PROC',l_proc);
6488: fnd_message.raise_error;
6489: end if ;
6490: if g_debug then
6491: hr_utility.set_location(' Hire date ' || l_hire_date, 99 );
6484: if l_hire_date is null then
6485: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
6486: fnd_message.set_token('DATE_CODE',p_date_cd);
6487: fnd_message.set_token('L_PROC',l_proc);
6488: fnd_message.raise_error;
6489: end if ;
6490: if g_debug then
6491: hr_utility.set_location(' Hire date ' || l_hire_date, 99 );
6492: end if;
6511: 'FDLY','FDQ','FDSY', 'LFSEMES'
6512: ) then
6513:
6514: -- hr_utility.set_location('Future Date Code: '||p_date_cd , 222);
6515: fnd_message.set_name('BEN','FUTURE_DATE_CD_DO_NOT_USE');
6516: fnd_message.set_token('DATE_CODE',p_date_cd);
6517: fnd_message.raise_error;
6518:
6519: elsif p_date_cd in ('FDPPFCDE','FDPPFCDEL') then
6512: ) then
6513:
6514: -- hr_utility.set_location('Future Date Code: '||p_date_cd , 222);
6515: fnd_message.set_name('BEN','FUTURE_DATE_CD_DO_NOT_USE');
6516: fnd_message.set_token('DATE_CODE',p_date_cd);
6517: fnd_message.raise_error;
6518:
6519: elsif p_date_cd in ('FDPPFCDE','FDPPFCDEL') then
6520: --
6513:
6514: -- hr_utility.set_location('Future Date Code: '||p_date_cd , 222);
6515: fnd_message.set_name('BEN','FUTURE_DATE_CD_DO_NOT_USE');
6516: fnd_message.set_token('DATE_CODE',p_date_cd);
6517: fnd_message.raise_error;
6518:
6519: elsif p_date_cd in ('FDPPFCDE','FDPPFCDEL') then
6520: --
6521: if g_debug then
6544: if c_pay_period_for_check%notfound then
6545: --
6546: close c_pay_period_for_check;
6547: --
6548: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6549: fnd_message.set_token('DATE_CODE',p_date_cd);
6550: fnd_message.set_token('L_PROC',l_proc);
6551: fnd_message.set_token('PERSON_ID',l_person_id);
6552: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6545: --
6546: close c_pay_period_for_check;
6547: --
6548: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6549: fnd_message.set_token('DATE_CODE',p_date_cd);
6550: fnd_message.set_token('L_PROC',l_proc);
6551: fnd_message.set_token('PERSON_ID',l_person_id);
6552: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6553: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6546: close c_pay_period_for_check;
6547: --
6548: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6549: fnd_message.set_token('DATE_CODE',p_date_cd);
6550: fnd_message.set_token('L_PROC',l_proc);
6551: fnd_message.set_token('PERSON_ID',l_person_id);
6552: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6553: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6554: fnd_message.raise_error;
6547: --
6548: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6549: fnd_message.set_token('DATE_CODE',p_date_cd);
6550: fnd_message.set_token('L_PROC',l_proc);
6551: fnd_message.set_token('PERSON_ID',l_person_id);
6552: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6553: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6554: fnd_message.raise_error;
6555: --
6548: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6549: fnd_message.set_token('DATE_CODE',p_date_cd);
6550: fnd_message.set_token('L_PROC',l_proc);
6551: fnd_message.set_token('PERSON_ID',l_person_id);
6552: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6553: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6554: fnd_message.raise_error;
6555: --
6556: end if;
6549: fnd_message.set_token('DATE_CODE',p_date_cd);
6550: fnd_message.set_token('L_PROC',l_proc);
6551: fnd_message.set_token('PERSON_ID',l_person_id);
6552: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6553: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6554: fnd_message.raise_error;
6555: --
6556: end if;
6557: else
6550: fnd_message.set_token('L_PROC',l_proc);
6551: fnd_message.set_token('PERSON_ID',l_person_id);
6552: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6553: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6554: fnd_message.raise_error;
6555: --
6556: end if;
6557: else
6558: -- rehire and new hire validation
6598: if c_pay_period_for_check_end %notfound then
6599: --
6600: close c_pay_period_for_check_end ;
6601: --
6602: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6603: fnd_message.set_token('DATE_CODE',p_date_cd);
6604: fnd_message.set_token('L_PROC',l_proc);
6605: fnd_message.set_token('PERSON_ID',l_person_id);
6606: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6599: --
6600: close c_pay_period_for_check_end ;
6601: --
6602: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6603: fnd_message.set_token('DATE_CODE',p_date_cd);
6604: fnd_message.set_token('L_PROC',l_proc);
6605: fnd_message.set_token('PERSON_ID',l_person_id);
6606: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6607: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6600: close c_pay_period_for_check_end ;
6601: --
6602: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6603: fnd_message.set_token('DATE_CODE',p_date_cd);
6604: fnd_message.set_token('L_PROC',l_proc);
6605: fnd_message.set_token('PERSON_ID',l_person_id);
6606: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6607: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6608: fnd_message.raise_error;
6601: --
6602: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6603: fnd_message.set_token('DATE_CODE',p_date_cd);
6604: fnd_message.set_token('L_PROC',l_proc);
6605: fnd_message.set_token('PERSON_ID',l_person_id);
6606: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6607: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6608: fnd_message.raise_error;
6609: --
6602: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6603: fnd_message.set_token('DATE_CODE',p_date_cd);
6604: fnd_message.set_token('L_PROC',l_proc);
6605: fnd_message.set_token('PERSON_ID',l_person_id);
6606: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6607: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6608: fnd_message.raise_error;
6609: --
6610: end if;
6603: fnd_message.set_token('DATE_CODE',p_date_cd);
6604: fnd_message.set_token('L_PROC',l_proc);
6605: fnd_message.set_token('PERSON_ID',l_person_id);
6606: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6607: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6608: fnd_message.raise_error;
6609: --
6610: end if;
6611: end if;
6604: fnd_message.set_token('L_PROC',l_proc);
6605: fnd_message.set_token('PERSON_ID',l_person_id);
6606: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6607: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6608: fnd_message.raise_error;
6609: --
6610: end if;
6611: end if;
6612: --
6614: p_returned_date := l_end_date;
6615: else
6616:
6617: hr_utility.set_location('Unknown Date Code: '||p_date_cd , 222);
6618: fnd_message.set_name('BEN','BEN_91534_BEN_UNKNOWN_DATE_CD');
6619: fnd_message.set_token('DATE_CODE',p_date_cd);
6620: fnd_message.set_token('L_PROC',l_proc);
6621: fnd_message.raise_error;
6622:
6615: else
6616:
6617: hr_utility.set_location('Unknown Date Code: '||p_date_cd , 222);
6618: fnd_message.set_name('BEN','BEN_91534_BEN_UNKNOWN_DATE_CD');
6619: fnd_message.set_token('DATE_CODE',p_date_cd);
6620: fnd_message.set_token('L_PROC',l_proc);
6621: fnd_message.raise_error;
6622:
6623: end if;
6616:
6617: hr_utility.set_location('Unknown Date Code: '||p_date_cd , 222);
6618: fnd_message.set_name('BEN','BEN_91534_BEN_UNKNOWN_DATE_CD');
6619: fnd_message.set_token('DATE_CODE',p_date_cd);
6620: fnd_message.set_token('L_PROC',l_proc);
6621: fnd_message.raise_error;
6622:
6623: end if;
6624: --
6617: hr_utility.set_location('Unknown Date Code: '||p_date_cd , 222);
6618: fnd_message.set_name('BEN','BEN_91534_BEN_UNKNOWN_DATE_CD');
6619: fnd_message.set_token('DATE_CODE',p_date_cd);
6620: fnd_message.set_token('L_PROC',l_proc);
6621: fnd_message.raise_error;
6622:
6623: end if;
6624: --
6625: if g_debug then
7429: hr_utility.set_location('l_oipl_id '||l_oipl_id,19);
7430: end if;
7431: if c_epe_info%notfound then
7432: close c_epe_info;
7433: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
7434: --fnd_message.set_token('ID', to_char(p_business_group_id));
7435: fnd_message.set_token('ID', to_char(p_elig_per_elctbl_chc_id));
7436: fnd_message.set_token('PROC',l_proc);
7437: fnd_message.raise_error;
7430: end if;
7431: if c_epe_info%notfound then
7432: close c_epe_info;
7433: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
7434: --fnd_message.set_token('ID', to_char(p_business_group_id));
7435: fnd_message.set_token('ID', to_char(p_elig_per_elctbl_chc_id));
7436: fnd_message.set_token('PROC',l_proc);
7437: fnd_message.raise_error;
7438: end if;
7431: if c_epe_info%notfound then
7432: close c_epe_info;
7433: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
7434: --fnd_message.set_token('ID', to_char(p_business_group_id));
7435: fnd_message.set_token('ID', to_char(p_elig_per_elctbl_chc_id));
7436: fnd_message.set_token('PROC',l_proc);
7437: fnd_message.raise_error;
7438: end if;
7439: if g_debug then
7432: close c_epe_info;
7433: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
7434: --fnd_message.set_token('ID', to_char(p_business_group_id));
7435: fnd_message.set_token('ID', to_char(p_elig_per_elctbl_chc_id));
7436: fnd_message.set_token('PROC',l_proc);
7437: fnd_message.raise_error;
7438: end if;
7439: if g_debug then
7440: hr_utility.set_location(l_proc , 40);
7433: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
7434: --fnd_message.set_token('ID', to_char(p_business_group_id));
7435: fnd_message.set_token('ID', to_char(p_elig_per_elctbl_chc_id));
7436: fnd_message.set_token('PROC',l_proc);
7437: fnd_message.raise_error;
7438: end if;
7439: if g_debug then
7440: hr_utility.set_location(l_proc , 40);
7441: end if;
8043: l_rt_strt_dt_cd is null then
8044: if g_debug then
8045: hr_utility.set_location('BEN_91455_RT_STRT_DT_NOT_FOUND' , 540);
8046: end if;
8047: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
8048: fnd_message.set_token('PLAN_ID',l_pln_name);
8049: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8050: fnd_message.set_token('PGM_ID',l_pgm_name);
8051: fnd_message.set_token('OIPL_ID',l_opt_name);
8044: if g_debug then
8045: hr_utility.set_location('BEN_91455_RT_STRT_DT_NOT_FOUND' , 540);
8046: end if;
8047: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
8048: fnd_message.set_token('PLAN_ID',l_pln_name);
8049: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8050: fnd_message.set_token('PGM_ID',l_pgm_name);
8051: fnd_message.set_token('OIPL_ID',l_opt_name);
8052: fnd_message.raise_error;
8045: hr_utility.set_location('BEN_91455_RT_STRT_DT_NOT_FOUND' , 540);
8046: end if;
8047: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
8048: fnd_message.set_token('PLAN_ID',l_pln_name);
8049: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8050: fnd_message.set_token('PGM_ID',l_pgm_name);
8051: fnd_message.set_token('OIPL_ID',l_opt_name);
8052: fnd_message.raise_error;
8053: elsif p_which_dates_cd in ('R','B') and
8046: end if;
8047: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
8048: fnd_message.set_token('PLAN_ID',l_pln_name);
8049: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8050: fnd_message.set_token('PGM_ID',l_pgm_name);
8051: fnd_message.set_token('OIPL_ID',l_opt_name);
8052: fnd_message.raise_error;
8053: elsif p_which_dates_cd in ('R','B') and
8054: l_rt_end_dt_cd is null then
8047: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
8048: fnd_message.set_token('PLAN_ID',l_pln_name);
8049: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8050: fnd_message.set_token('PGM_ID',l_pgm_name);
8051: fnd_message.set_token('OIPL_ID',l_opt_name);
8052: fnd_message.raise_error;
8053: elsif p_which_dates_cd in ('R','B') and
8054: l_rt_end_dt_cd is null then
8055: if g_debug then
8048: fnd_message.set_token('PLAN_ID',l_pln_name);
8049: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8050: fnd_message.set_token('PGM_ID',l_pgm_name);
8051: fnd_message.set_token('OIPL_ID',l_opt_name);
8052: fnd_message.raise_error;
8053: elsif p_which_dates_cd in ('R','B') and
8054: l_rt_end_dt_cd is null then
8055: if g_debug then
8056: hr_utility.set_location('BEN_91703_NOT_DET_RATE_END_DT' , 550);
8054: l_rt_end_dt_cd is null then
8055: if g_debug then
8056: hr_utility.set_location('BEN_91703_NOT_DET_RATE_END_DT' , 550);
8057: end if;
8058: fnd_message.set_name('BEN','BEN_91703_NOT_DET_RATE_END_DT');
8059: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8060: fnd_message.set_token('PGM_ID',l_pgm_name);
8061: fnd_message.set_token('PL_ID',l_pln_name);
8062: fnd_message.set_token('OIPL_ID',l_opt_name);
8055: if g_debug then
8056: hr_utility.set_location('BEN_91703_NOT_DET_RATE_END_DT' , 550);
8057: end if;
8058: fnd_message.set_name('BEN','BEN_91703_NOT_DET_RATE_END_DT');
8059: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8060: fnd_message.set_token('PGM_ID',l_pgm_name);
8061: fnd_message.set_token('PL_ID',l_pln_name);
8062: fnd_message.set_token('OIPL_ID',l_opt_name);
8063: fnd_message.raise_error;
8056: hr_utility.set_location('BEN_91703_NOT_DET_RATE_END_DT' , 550);
8057: end if;
8058: fnd_message.set_name('BEN','BEN_91703_NOT_DET_RATE_END_DT');
8059: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8060: fnd_message.set_token('PGM_ID',l_pgm_name);
8061: fnd_message.set_token('PL_ID',l_pln_name);
8062: fnd_message.set_token('OIPL_ID',l_opt_name);
8063: fnd_message.raise_error;
8064: elsif p_which_dates_cd in ('C','B') and
8057: end if;
8058: fnd_message.set_name('BEN','BEN_91703_NOT_DET_RATE_END_DT');
8059: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8060: fnd_message.set_token('PGM_ID',l_pgm_name);
8061: fnd_message.set_token('PL_ID',l_pln_name);
8062: fnd_message.set_token('OIPL_ID',l_opt_name);
8063: fnd_message.raise_error;
8064: elsif p_which_dates_cd in ('C','B') and
8065: l_enrt_cvg_strt_dt_cd is null then
8058: fnd_message.set_name('BEN','BEN_91703_NOT_DET_RATE_END_DT');
8059: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8060: fnd_message.set_token('PGM_ID',l_pgm_name);
8061: fnd_message.set_token('PL_ID',l_pln_name);
8062: fnd_message.set_token('OIPL_ID',l_opt_name);
8063: fnd_message.raise_error;
8064: elsif p_which_dates_cd in ('C','B') and
8065: l_enrt_cvg_strt_dt_cd is null then
8066: if g_debug then
8059: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8060: fnd_message.set_token('PGM_ID',l_pgm_name);
8061: fnd_message.set_token('PL_ID',l_pln_name);
8062: fnd_message.set_token('OIPL_ID',l_opt_name);
8063: fnd_message.raise_error;
8064: elsif p_which_dates_cd in ('C','B') and
8065: l_enrt_cvg_strt_dt_cd is null then
8066: if g_debug then
8067: hr_utility.set_location('BEN_91453_CVG_STRT_DT_NOT_FOUN' , 560);
8065: l_enrt_cvg_strt_dt_cd is null then
8066: if g_debug then
8067: hr_utility.set_location('BEN_91453_CVG_STRT_DT_NOT_FOUN' , 560);
8068: end if;
8069: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
8070: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8071: fnd_message.set_token('PGM_ID',l_pgm_name);
8072: fnd_message.set_token('PLAN_ID',l_pln_name);
8073: fnd_message.set_token('OIPL_ID',l_opt_name);
8066: if g_debug then
8067: hr_utility.set_location('BEN_91453_CVG_STRT_DT_NOT_FOUN' , 560);
8068: end if;
8069: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
8070: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8071: fnd_message.set_token('PGM_ID',l_pgm_name);
8072: fnd_message.set_token('PLAN_ID',l_pln_name);
8073: fnd_message.set_token('OIPL_ID',l_opt_name);
8074: fnd_message.raise_error;
8067: hr_utility.set_location('BEN_91453_CVG_STRT_DT_NOT_FOUN' , 560);
8068: end if;
8069: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
8070: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8071: fnd_message.set_token('PGM_ID',l_pgm_name);
8072: fnd_message.set_token('PLAN_ID',l_pln_name);
8073: fnd_message.set_token('OIPL_ID',l_opt_name);
8074: fnd_message.raise_error;
8075: elsif p_which_dates_cd in ('C','B') and
8068: end if;
8069: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
8070: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8071: fnd_message.set_token('PGM_ID',l_pgm_name);
8072: fnd_message.set_token('PLAN_ID',l_pln_name);
8073: fnd_message.set_token('OIPL_ID',l_opt_name);
8074: fnd_message.raise_error;
8075: elsif p_which_dates_cd in ('C','B') and
8076: l_enrt_cvg_end_dt_cd is null then
8069: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
8070: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8071: fnd_message.set_token('PGM_ID',l_pgm_name);
8072: fnd_message.set_token('PLAN_ID',l_pln_name);
8073: fnd_message.set_token('OIPL_ID',l_opt_name);
8074: fnd_message.raise_error;
8075: elsif p_which_dates_cd in ('C','B') and
8076: l_enrt_cvg_end_dt_cd is null then
8077: if g_debug then
8070: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8071: fnd_message.set_token('PGM_ID',l_pgm_name);
8072: fnd_message.set_token('PLAN_ID',l_pln_name);
8073: fnd_message.set_token('OIPL_ID',l_opt_name);
8074: fnd_message.raise_error;
8075: elsif p_which_dates_cd in ('C','B') and
8076: l_enrt_cvg_end_dt_cd is null then
8077: if g_debug then
8078: hr_utility.set_location(l_proc , 570);
8076: l_enrt_cvg_end_dt_cd is null then
8077: if g_debug then
8078: hr_utility.set_location(l_proc , 570);
8079: end if;
8080: fnd_message.set_name('BEN','BEN_91702_NOT_DET_CVG_END_DT');
8081: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8082: fnd_message.set_token('PGM_ID',l_pgm_name);
8083: fnd_message.set_token('PL_ID',l_pln_name);
8084: fnd_message.set_token('OIPL_ID',l_opt_name);
8077: if g_debug then
8078: hr_utility.set_location(l_proc , 570);
8079: end if;
8080: fnd_message.set_name('BEN','BEN_91702_NOT_DET_CVG_END_DT');
8081: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8082: fnd_message.set_token('PGM_ID',l_pgm_name);
8083: fnd_message.set_token('PL_ID',l_pln_name);
8084: fnd_message.set_token('OIPL_ID',l_opt_name);
8085: fnd_message.raise_error;
8078: hr_utility.set_location(l_proc , 570);
8079: end if;
8080: fnd_message.set_name('BEN','BEN_91702_NOT_DET_CVG_END_DT');
8081: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8082: fnd_message.set_token('PGM_ID',l_pgm_name);
8083: fnd_message.set_token('PL_ID',l_pln_name);
8084: fnd_message.set_token('OIPL_ID',l_opt_name);
8085: fnd_message.raise_error;
8086: end if;
8079: end if;
8080: fnd_message.set_name('BEN','BEN_91702_NOT_DET_CVG_END_DT');
8081: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8082: fnd_message.set_token('PGM_ID',l_pgm_name);
8083: fnd_message.set_token('PL_ID',l_pln_name);
8084: fnd_message.set_token('OIPL_ID',l_opt_name);
8085: fnd_message.raise_error;
8086: end if;
8087: --
8080: fnd_message.set_name('BEN','BEN_91702_NOT_DET_CVG_END_DT');
8081: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8082: fnd_message.set_token('PGM_ID',l_pgm_name);
8083: fnd_message.set_token('PL_ID',l_pln_name);
8084: fnd_message.set_token('OIPL_ID',l_opt_name);
8085: fnd_message.raise_error;
8086: end if;
8087: --
8088: end if;
8081: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8082: fnd_message.set_token('PGM_ID',l_pgm_name);
8083: fnd_message.set_token('PL_ID',l_pln_name);
8084: fnd_message.set_token('OIPL_ID',l_opt_name);
8085: fnd_message.raise_error;
8086: end if;
8087: --
8088: end if;
8089: --
8376: l_rt_strt_dt is null then
8377: if g_debug then
8378: hr_utility.set_location('BEN_91455_RT_STRT_DT_NOT_FOUND',37);
8379: end if;
8380: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
8381: fnd_message.set_token('PLAN_ID',l_pln_name);
8382: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8383: fnd_message.set_token('PGM_ID',l_pgm_name);
8384: fnd_message.set_token('OIPL_ID',l_opt_name);
8377: if g_debug then
8378: hr_utility.set_location('BEN_91455_RT_STRT_DT_NOT_FOUND',37);
8379: end if;
8380: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
8381: fnd_message.set_token('PLAN_ID',l_pln_name);
8382: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8383: fnd_message.set_token('PGM_ID',l_pgm_name);
8384: fnd_message.set_token('OIPL_ID',l_opt_name);
8385: fnd_message.raise_error;
8378: hr_utility.set_location('BEN_91455_RT_STRT_DT_NOT_FOUND',37);
8379: end if;
8380: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
8381: fnd_message.set_token('PLAN_ID',l_pln_name);
8382: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8383: fnd_message.set_token('PGM_ID',l_pgm_name);
8384: fnd_message.set_token('OIPL_ID',l_opt_name);
8385: fnd_message.raise_error;
8386: elsif p_which_dates_cd in ('R','B') and
8379: end if;
8380: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
8381: fnd_message.set_token('PLAN_ID',l_pln_name);
8382: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8383: fnd_message.set_token('PGM_ID',l_pgm_name);
8384: fnd_message.set_token('OIPL_ID',l_opt_name);
8385: fnd_message.raise_error;
8386: elsif p_which_dates_cd in ('R','B') and
8387: l_rt_end_dt is null then
8380: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
8381: fnd_message.set_token('PLAN_ID',l_pln_name);
8382: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8383: fnd_message.set_token('PGM_ID',l_pgm_name);
8384: fnd_message.set_token('OIPL_ID',l_opt_name);
8385: fnd_message.raise_error;
8386: elsif p_which_dates_cd in ('R','B') and
8387: l_rt_end_dt is null then
8388: if g_debug then
8381: fnd_message.set_token('PLAN_ID',l_pln_name);
8382: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8383: fnd_message.set_token('PGM_ID',l_pgm_name);
8384: fnd_message.set_token('OIPL_ID',l_opt_name);
8385: fnd_message.raise_error;
8386: elsif p_which_dates_cd in ('R','B') and
8387: l_rt_end_dt is null then
8388: if g_debug then
8389: hr_utility.set_location('BEN_91703_NOT_DET_RATE_END_DT',37);
8387: l_rt_end_dt is null then
8388: if g_debug then
8389: hr_utility.set_location('BEN_91703_NOT_DET_RATE_END_DT',37);
8390: end if;
8391: fnd_message.set_name('BEN','BEN_91703_NOT_DET_RATE_END_DT');
8392: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8393: fnd_message.set_token('PGM_ID',l_pgm_name);
8394: fnd_message.set_token('PL_ID',l_pln_name);
8395: fnd_message.set_token('OIPL_ID',l_opt_name);
8388: if g_debug then
8389: hr_utility.set_location('BEN_91703_NOT_DET_RATE_END_DT',37);
8390: end if;
8391: fnd_message.set_name('BEN','BEN_91703_NOT_DET_RATE_END_DT');
8392: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8393: fnd_message.set_token('PGM_ID',l_pgm_name);
8394: fnd_message.set_token('PL_ID',l_pln_name);
8395: fnd_message.set_token('OIPL_ID',l_opt_name);
8396: fnd_message.raise_error;
8389: hr_utility.set_location('BEN_91703_NOT_DET_RATE_END_DT',37);
8390: end if;
8391: fnd_message.set_name('BEN','BEN_91703_NOT_DET_RATE_END_DT');
8392: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8393: fnd_message.set_token('PGM_ID',l_pgm_name);
8394: fnd_message.set_token('PL_ID',l_pln_name);
8395: fnd_message.set_token('OIPL_ID',l_opt_name);
8396: fnd_message.raise_error;
8397: elsif p_which_dates_cd in ('C','B') and
8390: end if;
8391: fnd_message.set_name('BEN','BEN_91703_NOT_DET_RATE_END_DT');
8392: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8393: fnd_message.set_token('PGM_ID',l_pgm_name);
8394: fnd_message.set_token('PL_ID',l_pln_name);
8395: fnd_message.set_token('OIPL_ID',l_opt_name);
8396: fnd_message.raise_error;
8397: elsif p_which_dates_cd in ('C','B') and
8398: l_enrt_cvg_strt_dt is null then
8391: fnd_message.set_name('BEN','BEN_91703_NOT_DET_RATE_END_DT');
8392: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8393: fnd_message.set_token('PGM_ID',l_pgm_name);
8394: fnd_message.set_token('PL_ID',l_pln_name);
8395: fnd_message.set_token('OIPL_ID',l_opt_name);
8396: fnd_message.raise_error;
8397: elsif p_which_dates_cd in ('C','B') and
8398: l_enrt_cvg_strt_dt is null then
8399: if g_debug then
8392: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8393: fnd_message.set_token('PGM_ID',l_pgm_name);
8394: fnd_message.set_token('PL_ID',l_pln_name);
8395: fnd_message.set_token('OIPL_ID',l_opt_name);
8396: fnd_message.raise_error;
8397: elsif p_which_dates_cd in ('C','B') and
8398: l_enrt_cvg_strt_dt is null then
8399: if g_debug then
8400: hr_utility.set_location('BEN_91453_CVG_STRT_DT_NOT_FOUN',37);
8398: l_enrt_cvg_strt_dt is null then
8399: if g_debug then
8400: hr_utility.set_location('BEN_91453_CVG_STRT_DT_NOT_FOUN',37);
8401: end if;
8402: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
8403: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8404: fnd_message.set_token('PGM_ID',l_pgm_name);
8405: fnd_message.set_token('PLAN_ID',l_pln_name);
8406: fnd_message.set_token('OIPL_ID',l_opt_name);
8399: if g_debug then
8400: hr_utility.set_location('BEN_91453_CVG_STRT_DT_NOT_FOUN',37);
8401: end if;
8402: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
8403: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8404: fnd_message.set_token('PGM_ID',l_pgm_name);
8405: fnd_message.set_token('PLAN_ID',l_pln_name);
8406: fnd_message.set_token('OIPL_ID',l_opt_name);
8407: fnd_message.raise_error;
8400: hr_utility.set_location('BEN_91453_CVG_STRT_DT_NOT_FOUN',37);
8401: end if;
8402: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
8403: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8404: fnd_message.set_token('PGM_ID',l_pgm_name);
8405: fnd_message.set_token('PLAN_ID',l_pln_name);
8406: fnd_message.set_token('OIPL_ID',l_opt_name);
8407: fnd_message.raise_error;
8408: elsif p_which_dates_cd in ('C','B') and
8401: end if;
8402: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
8403: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8404: fnd_message.set_token('PGM_ID',l_pgm_name);
8405: fnd_message.set_token('PLAN_ID',l_pln_name);
8406: fnd_message.set_token('OIPL_ID',l_opt_name);
8407: fnd_message.raise_error;
8408: elsif p_which_dates_cd in ('C','B') and
8409: l_enrt_cvg_end_dt is null then
8402: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
8403: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8404: fnd_message.set_token('PGM_ID',l_pgm_name);
8405: fnd_message.set_token('PLAN_ID',l_pln_name);
8406: fnd_message.set_token('OIPL_ID',l_opt_name);
8407: fnd_message.raise_error;
8408: elsif p_which_dates_cd in ('C','B') and
8409: l_enrt_cvg_end_dt is null then
8410: if g_debug then
8403: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8404: fnd_message.set_token('PGM_ID',l_pgm_name);
8405: fnd_message.set_token('PLAN_ID',l_pln_name);
8406: fnd_message.set_token('OIPL_ID',l_opt_name);
8407: fnd_message.raise_error;
8408: elsif p_which_dates_cd in ('C','B') and
8409: l_enrt_cvg_end_dt is null then
8410: if g_debug then
8411: hr_utility.set_location('BEN_91702_NOT_DET_CVG_END_DT',37);
8409: l_enrt_cvg_end_dt is null then
8410: if g_debug then
8411: hr_utility.set_location('BEN_91702_NOT_DET_CVG_END_DT',37);
8412: end if;
8413: fnd_message.set_name('BEN','BEN_91702_NOT_DET_CVG_END_DT');
8414: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8415: fnd_message.set_token('PGM_ID',l_pgm_name);
8416: fnd_message.set_token('PL_ID',l_pln_name);
8417: fnd_message.set_token('OIPL_ID',l_opt_name);
8410: if g_debug then
8411: hr_utility.set_location('BEN_91702_NOT_DET_CVG_END_DT',37);
8412: end if;
8413: fnd_message.set_name('BEN','BEN_91702_NOT_DET_CVG_END_DT');
8414: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8415: fnd_message.set_token('PGM_ID',l_pgm_name);
8416: fnd_message.set_token('PL_ID',l_pln_name);
8417: fnd_message.set_token('OIPL_ID',l_opt_name);
8418: fnd_message.raise_error;
8411: hr_utility.set_location('BEN_91702_NOT_DET_CVG_END_DT',37);
8412: end if;
8413: fnd_message.set_name('BEN','BEN_91702_NOT_DET_CVG_END_DT');
8414: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8415: fnd_message.set_token('PGM_ID',l_pgm_name);
8416: fnd_message.set_token('PL_ID',l_pln_name);
8417: fnd_message.set_token('OIPL_ID',l_opt_name);
8418: fnd_message.raise_error;
8419: end if;
8412: end if;
8413: fnd_message.set_name('BEN','BEN_91702_NOT_DET_CVG_END_DT');
8414: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8415: fnd_message.set_token('PGM_ID',l_pgm_name);
8416: fnd_message.set_token('PL_ID',l_pln_name);
8417: fnd_message.set_token('OIPL_ID',l_opt_name);
8418: fnd_message.raise_error;
8419: end if;
8420:
8413: fnd_message.set_name('BEN','BEN_91702_NOT_DET_CVG_END_DT');
8414: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8415: fnd_message.set_token('PGM_ID',l_pgm_name);
8416: fnd_message.set_token('PL_ID',l_pln_name);
8417: fnd_message.set_token('OIPL_ID',l_opt_name);
8418: fnd_message.raise_error;
8419: end if;
8420:
8421: end if;
8414: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8415: fnd_message.set_token('PGM_ID',l_pgm_name);
8416: fnd_message.set_token('PL_ID',l_pln_name);
8417: fnd_message.set_token('OIPL_ID',l_opt_name);
8418: fnd_message.raise_error;
8419: end if;
8420:
8421: end if;
8422: --