APPS.BEN_DETERMINE_DATE dependencies on FND_MESSAGE

Line 114: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');

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;

Line 115: fnd_message.set_token('DATE_CODE',p_date_cd);

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

Line 116: fnd_message.set_token('L_PROC',l_proc);

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

Line 117: fnd_message.raise_error;

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

Line 241: fnd_message.set_name('BEN','BEN_94441_ENROL_ST_DT_RANGE');

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,calendar_aware=>2));
243: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_sot,calendar_aware=>2));
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);

Line 242: fnd_message.set_token('PARMA',l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2));

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,calendar_aware=>2));
243: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_sot,calendar_aware=>2));
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

Line 243: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_sot,calendar_aware=>2));

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,calendar_aware=>2));
243: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_sot,calendar_aware=>2));
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'

Line 244: fnd_message.set_token('PARMC','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );

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,calendar_aware=>2));
243: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_sot,calendar_aware=>2));
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

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

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,calendar_aware=>2));
243: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_sot,calendar_aware=>2));
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,calendar_aware=>2)

Line 255: fnd_message.set_name('BEN','BEN_94464_ENROL_ED_DT_RANGE');

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,calendar_aware=>2));
257: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_eot,calendar_aware=>2));
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);

Line 256: fnd_message.set_token('PARMA',l_formula_type_name|| ' ' || fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2));

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,calendar_aware=>2));
257: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_eot,calendar_aware=>2));
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

Line 257: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_eot,calendar_aware=>2));

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,calendar_aware=>2));
257: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_eot,calendar_aware=>2));
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'

Line 258: fnd_message.set_token('PARMC','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );

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,calendar_aware=>2));
257: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_eot,calendar_aware=>2));
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

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

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,calendar_aware=>2));
257: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_eot,calendar_aware=>2));
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,calendar_aware=>2)

Line 271: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');

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,calendar_aware=>2));
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,calendar_aware=>2));
275: benutils.write(p_text=>fnd_message.get);

Line 272: fnd_message.set_token('PARMA',l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2));

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,calendar_aware=>2));
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,calendar_aware=>2));
275: benutils.write(p_text=>fnd_message.get);
276: ben_warnings.load_warning

Line 273: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name);

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,calendar_aware=>2));
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,calendar_aware=>2));
275: benutils.write(p_text=>fnd_message.get);
276: ben_warnings.load_warning
277: (p_application_short_name => 'BEN'

Line 274: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt,calendar_aware=>2));

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,calendar_aware=>2));
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,calendar_aware=>2));
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

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

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,calendar_aware=>2));
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,calendar_aware=>2));
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,calendar_aware=>2)

Line 290: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');

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,calendar_aware=>2));
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,calendar_aware=>2));
294:

Line 291: fnd_message.set_token('PARMA',l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2));

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,calendar_aware=>2));
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,calendar_aware=>2));
294:
295: g_dep_rec.text := fnd_message.get;

Line 292: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name);

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,calendar_aware=>2));
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,calendar_aware=>2));
294:
295: g_dep_rec.text := fnd_message.get;
296: g_dep_rec.rep_typ_cd := 'WARNING';

Line 293: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt,calendar_aware=>2));

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,calendar_aware=>2));
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,calendar_aware=>2));
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';

Line 295: g_dep_rec.text := fnd_message.get;

291: fnd_message.set_token('PARMA',l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2));
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,calendar_aware=>2));
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;

Line 320: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');

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,calendar_aware=>2));
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,calendar_aware=>2));
324:

Line 321: fnd_message.set_token('PARMA',substr(l_formula_type_name,1,10) ||' '||'Coverage End Date'|| ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2));

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,calendar_aware=>2));
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,calendar_aware=>2));
324:
325: benutils.write(p_text=>fnd_message.get);

Line 322: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );

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,calendar_aware=>2));
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,calendar_aware=>2));
324:
325: benutils.write(p_text=>fnd_message.get);
326: ben_warnings.load_warning

Line 323: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt,calendar_aware=>2));

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,calendar_aware=>2));
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,calendar_aware=>2));
324:
325: benutils.write(p_text=>fnd_message.get);
326: ben_warnings.load_warning
327: (p_application_short_name => 'BEN'

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

321: fnd_message.set_token('PARMA',substr(l_formula_type_name,1,10) ||' '||'Coverage End Date'|| ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2));
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,calendar_aware=>2));
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,calendar_aware=>2)

Line 342: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');

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,calendar_aware=>2));
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,calendar_aware=>2));
346:

Line 343: fnd_message.set_token('PARMA',l_formula_type_name|| ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2));

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,calendar_aware=>2));
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,calendar_aware=>2));
346:
347: benutils.write(p_text=>fnd_message.get);

Line 344: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );

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,calendar_aware=>2));
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,calendar_aware=>2));
346:
347: benutils.write(p_text=>fnd_message.get);
348: ben_warnings.load_warning

Line 345: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt,calendar_aware=>2));

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,calendar_aware=>2));
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,calendar_aware=>2));
346:
347: benutils.write(p_text=>fnd_message.get);
348: ben_warnings.load_warning
349: (p_application_short_name => 'BEN'

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

343: fnd_message.set_token('PARMA',l_formula_type_name|| ' ' ||fnd_date.date_to_displaydate(p_computed_Date,calendar_aware=>2));
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,calendar_aware=>2));
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,calendar_aware=>2)

Line 433: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_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;

Line 434: fnd_message.set_token('DATE_CODE',p_date_cd);

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

Line 435: fnd_message.set_token('L_PROC',l_proc);

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

Line 436: fnd_message.raise_error;

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

Line 486: fnd_message.set_name('BEN','BEN_91530_CANNOT_FIND_AED_DATE');

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;

Line 487: fnd_message.raise_error;

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

Line 549: fnd_message.set_name('BEN','BEN_92391_CANT_FIND_RCRD_DATE');

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

Line 550: fnd_message.raise_error;

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: /*

Line 564: fnd_message.set_name('BEN','BEN_92391_CANT_FIND_RCRD_DATE');

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

Line 565: fnd_message.raise_error;

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: */

Line 1214: fnd_message.set_name('BEN','BEN_91529_CANNOT_FIND_ELEC_CHC');

1210: close c_per_elig_elctbl_chc;
1211: if g_debug then
1212: hr_utility.set_location('BEN_91529_CANNOT_FIND_ELEC_CHC',40);
1213: end if;
1214: fnd_message.set_name('BEN','BEN_91529_CANNOT_FIND_ELEC_CHC');
1215: fnd_message.set_token('L_PROC',l_proc);
1216: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
1217: fnd_message.raise_error;
1218: end if;

Line 1215: fnd_message.set_token('L_PROC',l_proc);

1211: if g_debug then
1212: hr_utility.set_location('BEN_91529_CANNOT_FIND_ELEC_CHC',40);
1213: end if;
1214: fnd_message.set_name('BEN','BEN_91529_CANNOT_FIND_ELEC_CHC');
1215: fnd_message.set_token('L_PROC',l_proc);
1216: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
1217: fnd_message.raise_error;
1218: end if;
1219: close c_per_elig_elctbl_chc;

Line 1216: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);

1212: hr_utility.set_location('BEN_91529_CANNOT_FIND_ELEC_CHC',40);
1213: end if;
1214: fnd_message.set_name('BEN','BEN_91529_CANNOT_FIND_ELEC_CHC');
1215: fnd_message.set_token('L_PROC',l_proc);
1216: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
1217: fnd_message.raise_error;
1218: end if;
1219: close c_per_elig_elctbl_chc;
1220:

Line 1217: fnd_message.raise_error;

1213: end if;
1214: fnd_message.set_name('BEN','BEN_91529_CANNOT_FIND_ELEC_CHC');
1215: fnd_message.set_token('L_PROC',l_proc);
1216: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
1217: fnd_message.raise_error;
1218: end if;
1219: close c_per_elig_elctbl_chc;
1220:
1221: else

Line 1388: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');

1384: close c_cm_enrt_perd_strt_dt;
1385: if g_debug then
1386: hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',40);
1387: end if;
1388: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
1389: fnd_message.set_token('DATE_CODE',p_date_cd);
1390: fnd_message.set_token('L_PROC',l_proc);
1391: fnd_message.raise_error;
1392: --

Line 1389: fnd_message.set_token('DATE_CODE',p_date_cd);

1385: if g_debug then
1386: hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',40);
1387: end if;
1388: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
1389: fnd_message.set_token('DATE_CODE',p_date_cd);
1390: fnd_message.set_token('L_PROC',l_proc);
1391: fnd_message.raise_error;
1392: --
1393: end if;

Line 1390: fnd_message.set_token('L_PROC',l_proc);

1386: hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',40);
1387: end if;
1388: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
1389: fnd_message.set_token('DATE_CODE',p_date_cd);
1390: fnd_message.set_token('L_PROC',l_proc);
1391: fnd_message.raise_error;
1392: --
1393: end if;
1394: --

Line 1391: fnd_message.raise_error;

1387: end if;
1388: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
1389: fnd_message.set_token('DATE_CODE',p_date_cd);
1390: fnd_message.set_token('L_PROC',l_proc);
1391: fnd_message.raise_error;
1392: --
1393: end if;
1394: --
1395: end if;

Line 1523: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');

1519: close c_pay_period_for_date;
1520: if g_debug then
1521: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',15);
1522: end if;
1523: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1524: fnd_message.set_token('DATE_CODE',p_date_cd);
1525: fnd_message.set_token('L_PROC',l_proc);
1526: fnd_message.set_token('PERSON_ID',l_person_id);
1527: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

Line 1524: fnd_message.set_token('DATE_CODE',p_date_cd);

1520: if g_debug then
1521: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',15);
1522: end if;
1523: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1524: fnd_message.set_token('DATE_CODE',p_date_cd);
1525: fnd_message.set_token('L_PROC',l_proc);
1526: fnd_message.set_token('PERSON_ID',l_person_id);
1527: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1528: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 1525: fnd_message.set_token('L_PROC',l_proc);

1521: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',15);
1522: end if;
1523: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1524: fnd_message.set_token('DATE_CODE',p_date_cd);
1525: fnd_message.set_token('L_PROC',l_proc);
1526: fnd_message.set_token('PERSON_ID',l_person_id);
1527: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1528: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1529: fnd_message.raise_error;

Line 1526: fnd_message.set_token('PERSON_ID',l_person_id);

1522: end if;
1523: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1524: fnd_message.set_token('DATE_CODE',p_date_cd);
1525: fnd_message.set_token('L_PROC',l_proc);
1526: fnd_message.set_token('PERSON_ID',l_person_id);
1527: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1528: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1529: fnd_message.raise_error;
1530: end if;

Line 1527: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

1523: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1524: fnd_message.set_token('DATE_CODE',p_date_cd);
1525: fnd_message.set_token('L_PROC',l_proc);
1526: fnd_message.set_token('PERSON_ID',l_person_id);
1527: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1528: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1529: fnd_message.raise_error;
1530: end if;
1531: close c_pay_period_for_date;

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

1524: fnd_message.set_token('DATE_CODE',p_date_cd);
1525: fnd_message.set_token('L_PROC',l_proc);
1526: fnd_message.set_token('PERSON_ID',l_person_id);
1527: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1528: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1529: fnd_message.raise_error;
1530: end if;
1531: close c_pay_period_for_date;
1532:

Line 1529: fnd_message.raise_error;

1525: fnd_message.set_token('L_PROC',l_proc);
1526: fnd_message.set_token('PERSON_ID',l_person_id);
1527: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1528: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1529: fnd_message.raise_error;
1530: end if;
1531: close c_pay_period_for_date;
1532:
1533: if p_date_cd = 'FDLPPPPYAES' then

Line 1561: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');

1557: close c_pay_period_for_date;
1558: if g_debug then
1559: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',15);
1560: end if;
1561: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1562: fnd_message.set_token('DATE_CODE',p_date_cd);
1563: fnd_message.set_token('L_PROC',l_proc);
1564: fnd_message.set_token('PERSON_ID',l_person_id);
1565: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

Line 1562: fnd_message.set_token('DATE_CODE',p_date_cd);

1558: if g_debug then
1559: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',15);
1560: end if;
1561: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1562: fnd_message.set_token('DATE_CODE',p_date_cd);
1563: fnd_message.set_token('L_PROC',l_proc);
1564: fnd_message.set_token('PERSON_ID',l_person_id);
1565: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1566: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 1563: fnd_message.set_token('L_PROC',l_proc);

1559: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',15);
1560: end if;
1561: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1562: fnd_message.set_token('DATE_CODE',p_date_cd);
1563: fnd_message.set_token('L_PROC',l_proc);
1564: fnd_message.set_token('PERSON_ID',l_person_id);
1565: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1566: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1567: fnd_message.raise_error;

Line 1564: fnd_message.set_token('PERSON_ID',l_person_id);

1560: end if;
1561: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1562: fnd_message.set_token('DATE_CODE',p_date_cd);
1563: fnd_message.set_token('L_PROC',l_proc);
1564: fnd_message.set_token('PERSON_ID',l_person_id);
1565: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1566: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1567: fnd_message.raise_error;
1568: end if;

Line 1565: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

1561: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1562: fnd_message.set_token('DATE_CODE',p_date_cd);
1563: fnd_message.set_token('L_PROC',l_proc);
1564: fnd_message.set_token('PERSON_ID',l_person_id);
1565: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1566: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1567: fnd_message.raise_error;
1568: end if;
1569: close c_pay_period_for_date;

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

1562: fnd_message.set_token('DATE_CODE',p_date_cd);
1563: fnd_message.set_token('L_PROC',l_proc);
1564: fnd_message.set_token('PERSON_ID',l_person_id);
1565: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1566: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1567: fnd_message.raise_error;
1568: end if;
1569: close c_pay_period_for_date;
1570:

Line 1567: fnd_message.raise_error;

1563: fnd_message.set_token('L_PROC',l_proc);
1564: fnd_message.set_token('PERSON_ID',l_person_id);
1565: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1566: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1567: fnd_message.raise_error;
1568: end if;
1569: close c_pay_period_for_date;
1570:
1571: else

Line 1599: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');

1595: close c_pay_period_for_date;
1596: if g_debug then
1597: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',25);
1598: end if;
1599: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1600: fnd_message.set_token('DATE_CODE',p_date_cd);
1601: fnd_message.set_token('L_PROC',l_proc);
1602: fnd_message.set_token('PERSON_ID',l_person_id);
1603: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

Line 1600: fnd_message.set_token('DATE_CODE',p_date_cd);

1596: if g_debug then
1597: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',25);
1598: end if;
1599: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1600: fnd_message.set_token('DATE_CODE',p_date_cd);
1601: fnd_message.set_token('L_PROC',l_proc);
1602: fnd_message.set_token('PERSON_ID',l_person_id);
1603: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1604: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 1601: fnd_message.set_token('L_PROC',l_proc);

1597: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',25);
1598: end if;
1599: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1600: fnd_message.set_token('DATE_CODE',p_date_cd);
1601: fnd_message.set_token('L_PROC',l_proc);
1602: fnd_message.set_token('PERSON_ID',l_person_id);
1603: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1604: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1605: fnd_message.raise_error;

Line 1602: fnd_message.set_token('PERSON_ID',l_person_id);

1598: end if;
1599: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1600: fnd_message.set_token('DATE_CODE',p_date_cd);
1601: fnd_message.set_token('L_PROC',l_proc);
1602: fnd_message.set_token('PERSON_ID',l_person_id);
1603: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1604: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1605: fnd_message.raise_error;
1606: end if;

Line 1603: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

1599: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1600: fnd_message.set_token('DATE_CODE',p_date_cd);
1601: fnd_message.set_token('L_PROC',l_proc);
1602: fnd_message.set_token('PERSON_ID',l_person_id);
1603: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1604: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1605: fnd_message.raise_error;
1606: end if;
1607: close c_pay_period_for_date;

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

1600: fnd_message.set_token('DATE_CODE',p_date_cd);
1601: fnd_message.set_token('L_PROC',l_proc);
1602: fnd_message.set_token('PERSON_ID',l_person_id);
1603: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1604: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1605: fnd_message.raise_error;
1606: end if;
1607: close c_pay_period_for_date;
1608: end if;

Line 1605: fnd_message.raise_error;

1601: fnd_message.set_token('L_PROC',l_proc);
1602: fnd_message.set_token('PERSON_ID',l_person_id);
1603: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1604: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1605: fnd_message.raise_error;
1606: end if;
1607: close c_pay_period_for_date;
1608: end if;
1609: end if ;

Line 1865: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');

1861: l_enrt_cvg_strt_dt is not null then
1862: if g_debug then
1863: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',80);
1864: end if;
1865: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1866: fnd_message.set_token('DATE_CODE',p_date_cd);
1867: fnd_message.set_token('L_PROC',l_proc);
1868: fnd_message.set_token('PERSON_ID',l_person_id);
1869: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

Line 1866: fnd_message.set_token('DATE_CODE',p_date_cd);

1862: if g_debug then
1863: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',80);
1864: end if;
1865: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1866: fnd_message.set_token('DATE_CODE',p_date_cd);
1867: fnd_message.set_token('L_PROC',l_proc);
1868: fnd_message.set_token('PERSON_ID',l_person_id);
1869: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1870: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 1867: fnd_message.set_token('L_PROC',l_proc);

1863: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',80);
1864: end if;
1865: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1866: fnd_message.set_token('DATE_CODE',p_date_cd);
1867: fnd_message.set_token('L_PROC',l_proc);
1868: fnd_message.set_token('PERSON_ID',l_person_id);
1869: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1870: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1871: fnd_message.raise_error;

Line 1868: fnd_message.set_token('PERSON_ID',l_person_id);

1864: end if;
1865: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1866: fnd_message.set_token('DATE_CODE',p_date_cd);
1867: fnd_message.set_token('L_PROC',l_proc);
1868: fnd_message.set_token('PERSON_ID',l_person_id);
1869: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1870: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1871: fnd_message.raise_error;
1872: end if;

Line 1869: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

1865: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1866: fnd_message.set_token('DATE_CODE',p_date_cd);
1867: fnd_message.set_token('L_PROC',l_proc);
1868: fnd_message.set_token('PERSON_ID',l_person_id);
1869: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1870: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1871: fnd_message.raise_error;
1872: end if;
1873: close c_pay_period_for_date;

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

1866: fnd_message.set_token('DATE_CODE',p_date_cd);
1867: fnd_message.set_token('L_PROC',l_proc);
1868: fnd_message.set_token('PERSON_ID',l_person_id);
1869: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1870: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1871: fnd_message.raise_error;
1872: end if;
1873: close c_pay_period_for_date;
1874: end if;

Line 1871: fnd_message.raise_error;

1867: fnd_message.set_token('L_PROC',l_proc);
1868: fnd_message.set_token('PERSON_ID',l_person_id);
1869: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1870: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1871: fnd_message.raise_error;
1872: end if;
1873: close c_pay_period_for_date;
1874: end if;
1875:

Line 1903: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');

1899: close c_next_pay_period;
1900: if g_debug then
1901: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',40);
1902: end if;
1903: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1904: fnd_message.set_token('DATE_CODE',p_date_cd);
1905: fnd_message.set_token('L_PROC',l_proc);
1906: fnd_message.set_token('PERSON_ID',l_person_id);
1907: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

Line 1904: fnd_message.set_token('DATE_CODE',p_date_cd);

1900: if g_debug then
1901: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',40);
1902: end if;
1903: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1904: fnd_message.set_token('DATE_CODE',p_date_cd);
1905: fnd_message.set_token('L_PROC',l_proc);
1906: fnd_message.set_token('PERSON_ID',l_person_id);
1907: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1908: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 1905: fnd_message.set_token('L_PROC',l_proc);

1901: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',40);
1902: end if;
1903: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1904: fnd_message.set_token('DATE_CODE',p_date_cd);
1905: fnd_message.set_token('L_PROC',l_proc);
1906: fnd_message.set_token('PERSON_ID',l_person_id);
1907: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1908: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1909: fnd_message.raise_error;

Line 1906: fnd_message.set_token('PERSON_ID',l_person_id);

1902: end if;
1903: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1904: fnd_message.set_token('DATE_CODE',p_date_cd);
1905: fnd_message.set_token('L_PROC',l_proc);
1906: fnd_message.set_token('PERSON_ID',l_person_id);
1907: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1908: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1909: fnd_message.raise_error;
1910: end if;

Line 1907: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

1903: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1904: fnd_message.set_token('DATE_CODE',p_date_cd);
1905: fnd_message.set_token('L_PROC',l_proc);
1906: fnd_message.set_token('PERSON_ID',l_person_id);
1907: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1908: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1909: fnd_message.raise_error;
1910: end if;
1911: close c_next_pay_period;

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

1904: fnd_message.set_token('DATE_CODE',p_date_cd);
1905: fnd_message.set_token('L_PROC',l_proc);
1906: fnd_message.set_token('PERSON_ID',l_person_id);
1907: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1908: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1909: fnd_message.raise_error;
1910: end if;
1911: close c_next_pay_period;
1912:

Line 1909: fnd_message.raise_error;

1905: fnd_message.set_token('L_PROC',l_proc);
1906: fnd_message.set_token('PERSON_ID',l_person_id);
1907: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1908: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1909: fnd_message.raise_error;
1910: end if;
1911: close c_next_pay_period;
1912:
1913: if p_date_cd = 'LESFDPPAD' and

Line 1969: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');

1965: hr_utility.set_location('l_next_pay_period.start_date'||l_next_pay_period.start_date,20);
1966: end if;
1967: if c_next_pay_period%notfound then
1968: close c_next_pay_period;
1969: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1970: fnd_message.set_token('DATE_CODE',p_date_cd);
1971: fnd_message.set_token('L_PROC',l_proc);
1972: fnd_message.set_token('PERSON_ID',l_person_id);
1973: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

Line 1970: fnd_message.set_token('DATE_CODE',p_date_cd);

1966: end if;
1967: if c_next_pay_period%notfound then
1968: close c_next_pay_period;
1969: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1970: fnd_message.set_token('DATE_CODE',p_date_cd);
1971: fnd_message.set_token('L_PROC',l_proc);
1972: fnd_message.set_token('PERSON_ID',l_person_id);
1973: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1974: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 1971: fnd_message.set_token('L_PROC',l_proc);

1967: if c_next_pay_period%notfound then
1968: close c_next_pay_period;
1969: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1970: fnd_message.set_token('DATE_CODE',p_date_cd);
1971: fnd_message.set_token('L_PROC',l_proc);
1972: fnd_message.set_token('PERSON_ID',l_person_id);
1973: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1974: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1975: fnd_message.raise_error;

Line 1972: fnd_message.set_token('PERSON_ID',l_person_id);

1968: close c_next_pay_period;
1969: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1970: fnd_message.set_token('DATE_CODE',p_date_cd);
1971: fnd_message.set_token('L_PROC',l_proc);
1972: fnd_message.set_token('PERSON_ID',l_person_id);
1973: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1974: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1975: fnd_message.raise_error;
1976: end if;

Line 1973: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

1969: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1970: fnd_message.set_token('DATE_CODE',p_date_cd);
1971: fnd_message.set_token('L_PROC',l_proc);
1972: fnd_message.set_token('PERSON_ID',l_person_id);
1973: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1974: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1975: fnd_message.raise_error;
1976: end if;
1977: close c_next_pay_period;

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

1970: fnd_message.set_token('DATE_CODE',p_date_cd);
1971: fnd_message.set_token('L_PROC',l_proc);
1972: fnd_message.set_token('PERSON_ID',l_person_id);
1973: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1974: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1975: fnd_message.raise_error;
1976: end if;
1977: close c_next_pay_period;
1978: if p_date_cd = 'FDPPFED' then

Line 1975: fnd_message.raise_error;

1971: fnd_message.set_token('L_PROC',l_proc);
1972: fnd_message.set_token('PERSON_ID',l_person_id);
1973: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1974: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1975: fnd_message.raise_error;
1976: end if;
1977: close c_next_pay_period;
1978: if p_date_cd = 'FDPPFED' then
1979: p_returned_date := l_next_pay_period.start_date;

Line 1995: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');

1991: open c_pay_period;
1992: fetch c_pay_period into l_pay_period;
1993: if c_pay_period%notfound then
1994: close c_pay_period;
1995: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1996: fnd_message.set_token('DATE_CODE',p_date_cd);
1997: fnd_message.set_token('PERSON_ID',l_person_id);
1998: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1999: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 1996: fnd_message.set_token('DATE_CODE',p_date_cd);

1992: fetch c_pay_period into l_pay_period;
1993: if c_pay_period%notfound then
1994: close c_pay_period;
1995: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1996: fnd_message.set_token('DATE_CODE',p_date_cd);
1997: fnd_message.set_token('PERSON_ID',l_person_id);
1998: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1999: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2000: fnd_message.raise_error;

Line 1997: fnd_message.set_token('PERSON_ID',l_person_id);

1993: if c_pay_period%notfound then
1994: close c_pay_period;
1995: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1996: fnd_message.set_token('DATE_CODE',p_date_cd);
1997: fnd_message.set_token('PERSON_ID',l_person_id);
1998: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1999: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2000: fnd_message.raise_error;
2001: end if;

Line 1998: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

1994: close c_pay_period;
1995: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1996: fnd_message.set_token('DATE_CODE',p_date_cd);
1997: fnd_message.set_token('PERSON_ID',l_person_id);
1998: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1999: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2000: fnd_message.raise_error;
2001: end if;
2002: close c_pay_period ;

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

1995: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1996: fnd_message.set_token('DATE_CODE',p_date_cd);
1997: fnd_message.set_token('PERSON_ID',l_person_id);
1998: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1999: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2000: fnd_message.raise_error;
2001: end if;
2002: close c_pay_period ;
2003: --

Line 2000: fnd_message.raise_error;

1996: fnd_message.set_token('DATE_CODE',p_date_cd);
1997: fnd_message.set_token('PERSON_ID',l_person_id);
1998: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1999: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2000: fnd_message.raise_error;
2001: end if;
2002: close c_pay_period ;
2003: --
2004: if l_event_date = l_pay_period.start_date then

Line 2014: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');

2010: fetch c_next_pay_period into l_next_pay_period;
2011: --
2012: if c_next_pay_period%notfound then
2013: close c_next_pay_period;
2014: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2015: fnd_message.set_token('DATE_CODE',p_date_cd);
2016: fnd_message.set_token('PERSON_ID',l_person_id);
2017: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2018: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 2015: fnd_message.set_token('DATE_CODE',p_date_cd);

2011: --
2012: if c_next_pay_period%notfound then
2013: close c_next_pay_period;
2014: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2015: fnd_message.set_token('DATE_CODE',p_date_cd);
2016: fnd_message.set_token('PERSON_ID',l_person_id);
2017: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2018: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2019: fnd_message.raise_error;

Line 2016: fnd_message.set_token('PERSON_ID',l_person_id);

2012: if c_next_pay_period%notfound then
2013: close c_next_pay_period;
2014: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2015: fnd_message.set_token('DATE_CODE',p_date_cd);
2016: fnd_message.set_token('PERSON_ID',l_person_id);
2017: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2018: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2019: fnd_message.raise_error;
2020: end if;

Line 2017: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

2013: close c_next_pay_period;
2014: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2015: fnd_message.set_token('DATE_CODE',p_date_cd);
2016: fnd_message.set_token('PERSON_ID',l_person_id);
2017: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2018: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2019: fnd_message.raise_error;
2020: end if;
2021: close c_next_pay_period;

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

2014: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2015: fnd_message.set_token('DATE_CODE',p_date_cd);
2016: fnd_message.set_token('PERSON_ID',l_person_id);
2017: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2018: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2019: fnd_message.raise_error;
2020: end if;
2021: close c_next_pay_period;
2022: p_returned_date := l_next_pay_period.start_date;

Line 2019: fnd_message.raise_error;

2015: fnd_message.set_token('DATE_CODE',p_date_cd);
2016: fnd_message.set_token('PERSON_ID',l_person_id);
2017: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2018: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2019: fnd_message.raise_error;
2020: end if;
2021: close c_next_pay_period;
2022: p_returned_date := l_next_pay_period.start_date;
2023: hr_utility.set_location('l_pay_period.start_date '|| l_next_pay_period.start_date,20);

Line 2039: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');

2035: open c_pay_period;
2036: fetch c_pay_period into l_pay_period;
2037: if c_pay_period%notfound then
2038: close c_pay_period;
2039: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2040: fnd_message.set_token('DATE_CODE',p_date_cd);
2041: fnd_message.set_token('PERSON_ID',l_person_id);
2042: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2043: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 2040: fnd_message.set_token('DATE_CODE',p_date_cd);

2036: fetch c_pay_period into l_pay_period;
2037: if c_pay_period%notfound then
2038: close c_pay_period;
2039: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2040: fnd_message.set_token('DATE_CODE',p_date_cd);
2041: fnd_message.set_token('PERSON_ID',l_person_id);
2042: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2043: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2044: fnd_message.raise_error;

Line 2041: fnd_message.set_token('PERSON_ID',l_person_id);

2037: if c_pay_period%notfound then
2038: close c_pay_period;
2039: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2040: fnd_message.set_token('DATE_CODE',p_date_cd);
2041: fnd_message.set_token('PERSON_ID',l_person_id);
2042: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2043: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2044: fnd_message.raise_error;
2045: end if;

Line 2042: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

2038: close c_pay_period;
2039: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2040: fnd_message.set_token('DATE_CODE',p_date_cd);
2041: fnd_message.set_token('PERSON_ID',l_person_id);
2042: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2043: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2044: fnd_message.raise_error;
2045: end if;
2046: close c_pay_period ;

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

2039: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2040: fnd_message.set_token('DATE_CODE',p_date_cd);
2041: fnd_message.set_token('PERSON_ID',l_person_id);
2042: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2043: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2044: fnd_message.raise_error;
2045: end if;
2046: close c_pay_period ;
2047: --

Line 2044: fnd_message.raise_error;

2040: fnd_message.set_token('DATE_CODE',p_date_cd);
2041: fnd_message.set_token('PERSON_ID',l_person_id);
2042: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2043: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2044: fnd_message.raise_error;
2045: end if;
2046: close c_pay_period ;
2047: --
2048: if l_event_date = l_pay_period.end_date then

Line 2058: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');

2054: fetch c_next_pay_period into l_next_pay_period;
2055: --
2056: if c_next_pay_period%notfound then
2057: close c_next_pay_period;
2058: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2059: fnd_message.set_token('DATE_CODE',p_date_cd);
2060: fnd_message.set_token('PERSON_ID',l_person_id);
2061: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2062: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 2059: fnd_message.set_token('DATE_CODE',p_date_cd);

2055: --
2056: if c_next_pay_period%notfound then
2057: close c_next_pay_period;
2058: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2059: fnd_message.set_token('DATE_CODE',p_date_cd);
2060: fnd_message.set_token('PERSON_ID',l_person_id);
2061: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2062: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2063: fnd_message.raise_error;

Line 2060: fnd_message.set_token('PERSON_ID',l_person_id);

2056: if c_next_pay_period%notfound then
2057: close c_next_pay_period;
2058: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2059: fnd_message.set_token('DATE_CODE',p_date_cd);
2060: fnd_message.set_token('PERSON_ID',l_person_id);
2061: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2062: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2063: fnd_message.raise_error;
2064: end if;

Line 2061: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

2057: close c_next_pay_period;
2058: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2059: fnd_message.set_token('DATE_CODE',p_date_cd);
2060: fnd_message.set_token('PERSON_ID',l_person_id);
2061: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2062: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2063: fnd_message.raise_error;
2064: end if;
2065: close c_next_pay_period;

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

2058: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2059: fnd_message.set_token('DATE_CODE',p_date_cd);
2060: fnd_message.set_token('PERSON_ID',l_person_id);
2061: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2062: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2063: fnd_message.raise_error;
2064: end if;
2065: close c_next_pay_period;
2066: p_returned_date := l_next_pay_period.end_date;

Line 2063: fnd_message.raise_error;

2059: fnd_message.set_token('DATE_CODE',p_date_cd);
2060: fnd_message.set_token('PERSON_ID',l_person_id);
2061: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2062: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
2063: fnd_message.raise_error;
2064: end if;
2065: close c_next_pay_period;
2066: p_returned_date := l_next_pay_period.end_date;
2067: hr_utility.set_location('l_pay_period.end_date '|| l_next_pay_period.end_date,20);

Line 2674: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');

2670: close c_pay_period_for_date;
2671: if g_debug then
2672: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',45);
2673: end if;
2674: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2675: fnd_message.set_token('DATE_CODE',p_date_cd);
2676: fnd_message.set_token('L_PROC',l_proc);
2677: fnd_message.set_token('PERSON_ID',l_person_id);
2678: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

Line 2675: fnd_message.set_token('DATE_CODE',p_date_cd);

2671: if g_debug then
2672: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',45);
2673: end if;
2674: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2675: fnd_message.set_token('DATE_CODE',p_date_cd);
2676: fnd_message.set_token('L_PROC',l_proc);
2677: fnd_message.set_token('PERSON_ID',l_person_id);
2678: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2679: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);

Line 2676: fnd_message.set_token('L_PROC',l_proc);

2672: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',45);
2673: end if;
2674: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2675: fnd_message.set_token('DATE_CODE',p_date_cd);
2676: fnd_message.set_token('L_PROC',l_proc);
2677: fnd_message.set_token('PERSON_ID',l_person_id);
2678: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2679: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);
2680: fnd_message.raise_error;

Line 2677: fnd_message.set_token('PERSON_ID',l_person_id);

2673: end if;
2674: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2675: fnd_message.set_token('DATE_CODE',p_date_cd);
2676: fnd_message.set_token('L_PROC',l_proc);
2677: fnd_message.set_token('PERSON_ID',l_person_id);
2678: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2679: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);
2680: fnd_message.raise_error;
2681:

Line 2678: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

2674: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2675: fnd_message.set_token('DATE_CODE',p_date_cd);
2676: fnd_message.set_token('L_PROC',l_proc);
2677: fnd_message.set_token('PERSON_ID',l_person_id);
2678: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2679: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);
2680: fnd_message.raise_error;
2681:
2682: end if;

Line 2679: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);

2675: fnd_message.set_token('DATE_CODE',p_date_cd);
2676: fnd_message.set_token('L_PROC',l_proc);
2677: fnd_message.set_token('PERSON_ID',l_person_id);
2678: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2679: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);
2680: fnd_message.raise_error;
2681:
2682: end if;
2683: close c_pay_period_for_date;

Line 2680: fnd_message.raise_error;

2676: fnd_message.set_token('L_PROC',l_proc);
2677: fnd_message.set_token('PERSON_ID',l_person_id);
2678: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2679: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);
2680: fnd_message.raise_error;
2681:
2682: end if;
2683: close c_pay_period_for_date;
2684:

Line 2702: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');

2698: close c_next_pay_period;
2699: if g_debug then
2700: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',55);
2701: end if;
2702: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2703: fnd_message.set_token('DATE_CODE',p_date_cd);
2704: fnd_message.set_token('L_PROC',l_proc);
2705: fnd_message.set_token('PERSON_ID',l_person_id);
2706: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

Line 2703: fnd_message.set_token('DATE_CODE',p_date_cd);

2699: if g_debug then
2700: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',55);
2701: end if;
2702: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2703: fnd_message.set_token('DATE_CODE',p_date_cd);
2704: fnd_message.set_token('L_PROC',l_proc);
2705: fnd_message.set_token('PERSON_ID',l_person_id);
2706: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2707: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);

Line 2704: fnd_message.set_token('L_PROC',l_proc);

2700: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',55);
2701: end if;
2702: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2703: fnd_message.set_token('DATE_CODE',p_date_cd);
2704: fnd_message.set_token('L_PROC',l_proc);
2705: fnd_message.set_token('PERSON_ID',l_person_id);
2706: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2707: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);
2708: fnd_message.raise_error;

Line 2705: fnd_message.set_token('PERSON_ID',l_person_id);

2701: end if;
2702: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2703: fnd_message.set_token('DATE_CODE',p_date_cd);
2704: fnd_message.set_token('L_PROC',l_proc);
2705: fnd_message.set_token('PERSON_ID',l_person_id);
2706: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2707: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);
2708: fnd_message.raise_error;
2709: end if;

Line 2706: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

2702: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2703: fnd_message.set_token('DATE_CODE',p_date_cd);
2704: fnd_message.set_token('L_PROC',l_proc);
2705: fnd_message.set_token('PERSON_ID',l_person_id);
2706: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2707: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);
2708: fnd_message.raise_error;
2709: end if;
2710: close c_next_pay_period;

Line 2707: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);

2703: fnd_message.set_token('DATE_CODE',p_date_cd);
2704: fnd_message.set_token('L_PROC',l_proc);
2705: fnd_message.set_token('PERSON_ID',l_person_id);
2706: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2707: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);
2708: fnd_message.raise_error;
2709: end if;
2710: close c_next_pay_period;
2711:

Line 2708: fnd_message.raise_error;

2704: fnd_message.set_token('L_PROC',l_proc);
2705: fnd_message.set_token('PERSON_ID',l_person_id);
2706: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2707: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);
2708: fnd_message.raise_error;
2709: end if;
2710: close c_next_pay_period;
2711:
2712: p_returned_date := l_next_pay_period.start_date;

Line 2757: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');

2753: else
2754: if g_debug then
2755: hr_utility.set_location('BEN_92489_CANNOT_CALC_DATE',55);
2756: end if;
2757: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
2758: fnd_message.set_token('DATE_CODE',p_date_cd);
2759: fnd_message.set_token('L_PROC',l_proc);
2760: fnd_message.raise_error;
2761: --

Line 2758: fnd_message.set_token('DATE_CODE',p_date_cd);

2754: if g_debug then
2755: hr_utility.set_location('BEN_92489_CANNOT_CALC_DATE',55);
2756: end if;
2757: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
2758: fnd_message.set_token('DATE_CODE',p_date_cd);
2759: fnd_message.set_token('L_PROC',l_proc);
2760: fnd_message.raise_error;
2761: --
2762: end if;

Line 2759: fnd_message.set_token('L_PROC',l_proc);

2755: hr_utility.set_location('BEN_92489_CANNOT_CALC_DATE',55);
2756: end if;
2757: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
2758: fnd_message.set_token('DATE_CODE',p_date_cd);
2759: fnd_message.set_token('L_PROC',l_proc);
2760: fnd_message.raise_error;
2761: --
2762: end if;
2763: --

Line 2760: fnd_message.raise_error;

2756: end if;
2757: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
2758: fnd_message.set_token('DATE_CODE',p_date_cd);
2759: fnd_message.set_token('L_PROC',l_proc);
2760: fnd_message.raise_error;
2761: --
2762: end if;
2763: --
2764: p_returned_date:= l_start_date;

Line 2803: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');

2799: close c_oipl_popl_lim_yr;
2800: --
2801: else
2802: -- hr_utility.set_location('BEN_92489_CANNOT_CALC_DATE',55);
2803: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
2804: fnd_message.set_token('DATE_CODE',p_date_cd);
2805: fnd_message.set_token('L_PROC',l_proc);
2806: fnd_message.raise_error;
2807: --

Line 2804: fnd_message.set_token('DATE_CODE',p_date_cd);

2800: --
2801: else
2802: -- hr_utility.set_location('BEN_92489_CANNOT_CALC_DATE',55);
2803: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
2804: fnd_message.set_token('DATE_CODE',p_date_cd);
2805: fnd_message.set_token('L_PROC',l_proc);
2806: fnd_message.raise_error;
2807: --
2808: end if;

Line 2805: fnd_message.set_token('L_PROC',l_proc);

2801: else
2802: -- hr_utility.set_location('BEN_92489_CANNOT_CALC_DATE',55);
2803: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
2804: fnd_message.set_token('DATE_CODE',p_date_cd);
2805: fnd_message.set_token('L_PROC',l_proc);
2806: fnd_message.raise_error;
2807: --
2808: end if;
2809: --

Line 2806: fnd_message.raise_error;

2802: -- hr_utility.set_location('BEN_92489_CANNOT_CALC_DATE',55);
2803: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
2804: fnd_message.set_token('DATE_CODE',p_date_cd);
2805: fnd_message.set_token('L_PROC',l_proc);
2806: fnd_message.raise_error;
2807: --
2808: end if;
2809: --
2810: p_returned_date:= l_end_date;

Line 3135: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');

3131: if c_pay_period%notfound then
3132:
3133: close c_pay_period;
3134: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',65);
3135: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3136: fnd_message.set_token('DATE_CODE',p_date_cd);
3137: fnd_message.set_token('L_PROC',l_proc);
3138: fnd_message.set_token('PERSON_ID',l_person_id);
3139: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

Line 3136: fnd_message.set_token('DATE_CODE',p_date_cd);

3132:
3133: close c_pay_period;
3134: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',65);
3135: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3136: fnd_message.set_token('DATE_CODE',p_date_cd);
3137: fnd_message.set_token('L_PROC',l_proc);
3138: fnd_message.set_token('PERSON_ID',l_person_id);
3139: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3140: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 3137: fnd_message.set_token('L_PROC',l_proc);

3133: close c_pay_period;
3134: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',65);
3135: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3136: fnd_message.set_token('DATE_CODE',p_date_cd);
3137: fnd_message.set_token('L_PROC',l_proc);
3138: fnd_message.set_token('PERSON_ID',l_person_id);
3139: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3140: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3141: fnd_message.raise_error;

Line 3138: fnd_message.set_token('PERSON_ID',l_person_id);

3134: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',65);
3135: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3136: fnd_message.set_token('DATE_CODE',p_date_cd);
3137: fnd_message.set_token('L_PROC',l_proc);
3138: fnd_message.set_token('PERSON_ID',l_person_id);
3139: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3140: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3141: fnd_message.raise_error;
3142:

Line 3139: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

3135: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3136: fnd_message.set_token('DATE_CODE',p_date_cd);
3137: fnd_message.set_token('L_PROC',l_proc);
3138: fnd_message.set_token('PERSON_ID',l_person_id);
3139: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3140: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3141: fnd_message.raise_error;
3142:
3143: end if;

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

3136: fnd_message.set_token('DATE_CODE',p_date_cd);
3137: fnd_message.set_token('L_PROC',l_proc);
3138: fnd_message.set_token('PERSON_ID',l_person_id);
3139: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3140: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3141: fnd_message.raise_error;
3142:
3143: end if;
3144:

Line 3141: fnd_message.raise_error;

3137: fnd_message.set_token('L_PROC',l_proc);
3138: fnd_message.set_token('PERSON_ID',l_person_id);
3139: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3140: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3141: fnd_message.raise_error;
3142:
3143: end if;
3144:
3145: close c_pay_period ;

Line 3182: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');

3178: if c_pay_period%notfound then
3179:
3180: close c_pay_period;
3181: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',70);
3182: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3183: fnd_message.set_token('DATE_CODE',p_date_cd);
3184: fnd_message.set_token('L_PROC',l_proc);
3185: fnd_message.set_token('PERSON_ID',l_person_id);
3186: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

Line 3183: fnd_message.set_token('DATE_CODE',p_date_cd);

3179:
3180: close c_pay_period;
3181: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',70);
3182: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3183: fnd_message.set_token('DATE_CODE',p_date_cd);
3184: fnd_message.set_token('L_PROC',l_proc);
3185: fnd_message.set_token('PERSON_ID',l_person_id);
3186: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3187: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 3184: fnd_message.set_token('L_PROC',l_proc);

3180: close c_pay_period;
3181: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',70);
3182: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3183: fnd_message.set_token('DATE_CODE',p_date_cd);
3184: fnd_message.set_token('L_PROC',l_proc);
3185: fnd_message.set_token('PERSON_ID',l_person_id);
3186: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3187: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3188: fnd_message.raise_error;

Line 3185: fnd_message.set_token('PERSON_ID',l_person_id);

3181: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',70);
3182: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3183: fnd_message.set_token('DATE_CODE',p_date_cd);
3184: fnd_message.set_token('L_PROC',l_proc);
3185: fnd_message.set_token('PERSON_ID',l_person_id);
3186: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3187: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3188: fnd_message.raise_error;
3189:

Line 3186: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

3182: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3183: fnd_message.set_token('DATE_CODE',p_date_cd);
3184: fnd_message.set_token('L_PROC',l_proc);
3185: fnd_message.set_token('PERSON_ID',l_person_id);
3186: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3187: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3188: fnd_message.raise_error;
3189:
3190: end if;

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

3183: fnd_message.set_token('DATE_CODE',p_date_cd);
3184: fnd_message.set_token('L_PROC',l_proc);
3185: fnd_message.set_token('PERSON_ID',l_person_id);
3186: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3187: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3188: fnd_message.raise_error;
3189:
3190: end if;
3191:

Line 3188: fnd_message.raise_error;

3184: fnd_message.set_token('L_PROC',l_proc);
3185: fnd_message.set_token('PERSON_ID',l_person_id);
3186: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3187: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3188: fnd_message.raise_error;
3189:
3190: end if;
3191:
3192: close c_pay_period ;

Line 3754: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');

3750: l_end_date;
3751: --
3752: if c_pay_period_for_date%notfound then
3753: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',95);
3754: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3755: fnd_message.set_token('DATE_CODE',p_date_cd);
3756: fnd_message.set_token('L_PROC',l_proc);
3757: fnd_message.set_token('PERSON_ID',l_person_id);
3758: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

Line 3755: fnd_message.set_token('DATE_CODE',p_date_cd);

3751: --
3752: if c_pay_period_for_date%notfound then
3753: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',95);
3754: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3755: fnd_message.set_token('DATE_CODE',p_date_cd);
3756: fnd_message.set_token('L_PROC',l_proc);
3757: fnd_message.set_token('PERSON_ID',l_person_id);
3758: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3759: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 3756: fnd_message.set_token('L_PROC',l_proc);

3752: if c_pay_period_for_date%notfound then
3753: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',95);
3754: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3755: fnd_message.set_token('DATE_CODE',p_date_cd);
3756: fnd_message.set_token('L_PROC',l_proc);
3757: fnd_message.set_token('PERSON_ID',l_person_id);
3758: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3759: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3760: fnd_message.raise_error;

Line 3757: fnd_message.set_token('PERSON_ID',l_person_id);

3753: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',95);
3754: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3755: fnd_message.set_token('DATE_CODE',p_date_cd);
3756: fnd_message.set_token('L_PROC',l_proc);
3757: fnd_message.set_token('PERSON_ID',l_person_id);
3758: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3759: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3760: fnd_message.raise_error;
3761: --

Line 3758: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

3754: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3755: fnd_message.set_token('DATE_CODE',p_date_cd);
3756: fnd_message.set_token('L_PROC',l_proc);
3757: fnd_message.set_token('PERSON_ID',l_person_id);
3758: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3759: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3760: fnd_message.raise_error;
3761: --
3762: end if;

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

3755: fnd_message.set_token('DATE_CODE',p_date_cd);
3756: fnd_message.set_token('L_PROC',l_proc);
3757: fnd_message.set_token('PERSON_ID',l_person_id);
3758: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3759: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3760: fnd_message.raise_error;
3761: --
3762: end if;
3763: --

Line 3760: fnd_message.raise_error;

3756: fnd_message.set_token('L_PROC',l_proc);
3757: fnd_message.set_token('PERSON_ID',l_person_id);
3758: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3759: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3760: fnd_message.raise_error;
3761: --
3762: end if;
3763: --
3764: p_returned_date:=l_end_date;

Line 3798: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');

3794: l_end_date;
3795: --
3796: if c_pay_period_for_date%notfound then
3797: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',100);
3798: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3799: fnd_message.set_token('DATE_CODE',p_date_cd);
3800: fnd_message.set_token('L_PROC',l_proc);
3801: fnd_message.set_token('PERSON_ID',l_person_id);
3802: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

Line 3799: fnd_message.set_token('DATE_CODE',p_date_cd);

3795: --
3796: if c_pay_period_for_date%notfound then
3797: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',100);
3798: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3799: fnd_message.set_token('DATE_CODE',p_date_cd);
3800: fnd_message.set_token('L_PROC',l_proc);
3801: fnd_message.set_token('PERSON_ID',l_person_id);
3802: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3803: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 3800: fnd_message.set_token('L_PROC',l_proc);

3796: if c_pay_period_for_date%notfound then
3797: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',100);
3798: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3799: fnd_message.set_token('DATE_CODE',p_date_cd);
3800: fnd_message.set_token('L_PROC',l_proc);
3801: fnd_message.set_token('PERSON_ID',l_person_id);
3802: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3803: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3804: fnd_message.raise_error;

Line 3801: fnd_message.set_token('PERSON_ID',l_person_id);

3797: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',100);
3798: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3799: fnd_message.set_token('DATE_CODE',p_date_cd);
3800: fnd_message.set_token('L_PROC',l_proc);
3801: fnd_message.set_token('PERSON_ID',l_person_id);
3802: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3803: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3804: fnd_message.raise_error;
3805: end if;

Line 3802: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

3798: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3799: fnd_message.set_token('DATE_CODE',p_date_cd);
3800: fnd_message.set_token('L_PROC',l_proc);
3801: fnd_message.set_token('PERSON_ID',l_person_id);
3802: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3803: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3804: fnd_message.raise_error;
3805: end if;
3806: --

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

3799: fnd_message.set_token('DATE_CODE',p_date_cd);
3800: fnd_message.set_token('L_PROC',l_proc);
3801: fnd_message.set_token('PERSON_ID',l_person_id);
3802: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3803: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3804: fnd_message.raise_error;
3805: end if;
3806: --
3807: p_returned_date:=l_start_date;

Line 3804: fnd_message.raise_error;

3800: fnd_message.set_token('L_PROC',l_proc);
3801: fnd_message.set_token('PERSON_ID',l_person_id);
3802: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3803: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3804: fnd_message.raise_error;
3805: end if;
3806: --
3807: p_returned_date:=l_start_date;
3808: --

Line 3842: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');

3838: l_end_date;
3839: --
3840: if c_pay_period_for_date%notfound then
3841: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',105);
3842: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3843: fnd_message.set_token('DATE_CODE',p_date_cd);
3844: fnd_message.set_token('L_PROC',l_proc);
3845: fnd_message.set_token('PERSON_ID',l_person_id);
3846: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

Line 3843: fnd_message.set_token('DATE_CODE',p_date_cd);

3839: --
3840: if c_pay_period_for_date%notfound then
3841: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',105);
3842: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3843: fnd_message.set_token('DATE_CODE',p_date_cd);
3844: fnd_message.set_token('L_PROC',l_proc);
3845: fnd_message.set_token('PERSON_ID',l_person_id);
3846: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3847: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 3844: fnd_message.set_token('L_PROC',l_proc);

3840: if c_pay_period_for_date%notfound then
3841: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',105);
3842: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3843: fnd_message.set_token('DATE_CODE',p_date_cd);
3844: fnd_message.set_token('L_PROC',l_proc);
3845: fnd_message.set_token('PERSON_ID',l_person_id);
3846: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3847: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3848: fnd_message.raise_error;

Line 3845: fnd_message.set_token('PERSON_ID',l_person_id);

3841: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',105);
3842: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3843: fnd_message.set_token('DATE_CODE',p_date_cd);
3844: fnd_message.set_token('L_PROC',l_proc);
3845: fnd_message.set_token('PERSON_ID',l_person_id);
3846: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3847: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3848: fnd_message.raise_error;
3849: end if;

Line 3846: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

3842: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3843: fnd_message.set_token('DATE_CODE',p_date_cd);
3844: fnd_message.set_token('L_PROC',l_proc);
3845: fnd_message.set_token('PERSON_ID',l_person_id);
3846: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3847: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3848: fnd_message.raise_error;
3849: end if;
3850: --

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

3843: fnd_message.set_token('DATE_CODE',p_date_cd);
3844: fnd_message.set_token('L_PROC',l_proc);
3845: fnd_message.set_token('PERSON_ID',l_person_id);
3846: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3847: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3848: fnd_message.raise_error;
3849: end if;
3850: --
3851: p_returned_date:=l_start_date;

Line 3848: fnd_message.raise_error;

3844: fnd_message.set_token('L_PROC',l_proc);
3845: fnd_message.set_token('PERSON_ID',l_person_id);
3846: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3847: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3848: fnd_message.raise_error;
3849: end if;
3850: --
3851: p_returned_date:=l_start_date;
3852: --

Line 4251: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');

4247: if c_pay_period%notfound then
4248: --
4249: close c_pay_period;
4250: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',110);
4251: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4252: fnd_message.set_token('DATE_CODE',p_date_cd);
4253: fnd_message.set_token('L_PROC',l_proc);
4254: fnd_message.set_token('PERSON_ID',l_person_id);
4255: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

Line 4252: fnd_message.set_token('DATE_CODE',p_date_cd);

4248: --
4249: close c_pay_period;
4250: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',110);
4251: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4252: fnd_message.set_token('DATE_CODE',p_date_cd);
4253: fnd_message.set_token('L_PROC',l_proc);
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);

Line 4253: fnd_message.set_token('L_PROC',l_proc);

4249: close c_pay_period;
4250: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',110);
4251: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4252: fnd_message.set_token('DATE_CODE',p_date_cd);
4253: fnd_message.set_token('L_PROC',l_proc);
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;

Line 4254: fnd_message.set_token('PERSON_ID',l_person_id);

4250: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',110);
4251: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4252: fnd_message.set_token('DATE_CODE',p_date_cd);
4253: fnd_message.set_token('L_PROC',l_proc);
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: --

Line 4255: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

4251: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4252: fnd_message.set_token('DATE_CODE',p_date_cd);
4253: fnd_message.set_token('L_PROC',l_proc);
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: --
4259: end if;

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

4252: fnd_message.set_token('DATE_CODE',p_date_cd);
4253: fnd_message.set_token('L_PROC',l_proc);
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: --
4259: end if;
4260: --

Line 4257: fnd_message.raise_error;

4253: fnd_message.set_token('L_PROC',l_proc);
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: --
4259: end if;
4260: --
4261: p_returned_date := l_pay_period.start_date;

Line 4285: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');

4281: --
4282: if c_pay_period%notfound then
4283: close c_pay_period;
4284: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',115);
4285: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4286: fnd_message.set_token('DATE_CODE',p_date_cd);
4287: fnd_message.set_token('L_PROC',l_proc);
4288: fnd_message.set_token('PERSON_ID',l_person_id);
4289: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

Line 4286: fnd_message.set_token('DATE_CODE',p_date_cd);

4282: if c_pay_period%notfound then
4283: close c_pay_period;
4284: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',115);
4285: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4286: fnd_message.set_token('DATE_CODE',p_date_cd);
4287: fnd_message.set_token('L_PROC',l_proc);
4288: fnd_message.set_token('PERSON_ID',l_person_id);
4289: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4290: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 4287: fnd_message.set_token('L_PROC',l_proc);

4283: close c_pay_period;
4284: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',115);
4285: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4286: fnd_message.set_token('DATE_CODE',p_date_cd);
4287: fnd_message.set_token('L_PROC',l_proc);
4288: fnd_message.set_token('PERSON_ID',l_person_id);
4289: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4290: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4291: fnd_message.raise_error;

Line 4288: fnd_message.set_token('PERSON_ID',l_person_id);

4284: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',115);
4285: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4286: fnd_message.set_token('DATE_CODE',p_date_cd);
4287: fnd_message.set_token('L_PROC',l_proc);
4288: fnd_message.set_token('PERSON_ID',l_person_id);
4289: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4290: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4291: fnd_message.raise_error;
4292: end if;

Line 4289: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

4285: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4286: fnd_message.set_token('DATE_CODE',p_date_cd);
4287: fnd_message.set_token('L_PROC',l_proc);
4288: fnd_message.set_token('PERSON_ID',l_person_id);
4289: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4290: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4291: fnd_message.raise_error;
4292: end if;
4293: p_returned_date := l_pay_period.end_date;

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

4286: fnd_message.set_token('DATE_CODE',p_date_cd);
4287: fnd_message.set_token('L_PROC',l_proc);
4288: fnd_message.set_token('PERSON_ID',l_person_id);
4289: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4290: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4291: fnd_message.raise_error;
4292: end if;
4293: p_returned_date := l_pay_period.end_date;
4294: close c_pay_period ;

Line 4291: fnd_message.raise_error;

4287: fnd_message.set_token('L_PROC',l_proc);
4288: fnd_message.set_token('PERSON_ID',l_person_id);
4289: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4290: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4291: fnd_message.raise_error;
4292: end if;
4293: p_returned_date := l_pay_period.end_date;
4294: close c_pay_period ;
4295: --

Line 4319: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');

4315: close c_pay_period;
4316: if g_debug then
4317: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',115);
4318: end if;
4319: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4320: fnd_message.set_token('DATE_CODE',p_date_cd);
4321: fnd_message.set_token('L_PROC',l_proc);
4322: fnd_message.set_token('PERSON_ID',l_person_id);
4323: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

Line 4320: fnd_message.set_token('DATE_CODE',p_date_cd);

4316: if g_debug then
4317: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',115);
4318: end if;
4319: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4320: fnd_message.set_token('DATE_CODE',p_date_cd);
4321: fnd_message.set_token('L_PROC',l_proc);
4322: fnd_message.set_token('PERSON_ID',l_person_id);
4323: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4324: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 4321: fnd_message.set_token('L_PROC',l_proc);

4317: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',115);
4318: end if;
4319: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4320: fnd_message.set_token('DATE_CODE',p_date_cd);
4321: fnd_message.set_token('L_PROC',l_proc);
4322: fnd_message.set_token('PERSON_ID',l_person_id);
4323: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4324: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4325: fnd_message.raise_error;

Line 4322: fnd_message.set_token('PERSON_ID',l_person_id);

4318: end if;
4319: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4320: fnd_message.set_token('DATE_CODE',p_date_cd);
4321: fnd_message.set_token('L_PROC',l_proc);
4322: fnd_message.set_token('PERSON_ID',l_person_id);
4323: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4324: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4325: fnd_message.raise_error;
4326: end if;

Line 4323: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

4319: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4320: fnd_message.set_token('DATE_CODE',p_date_cd);
4321: fnd_message.set_token('L_PROC',l_proc);
4322: fnd_message.set_token('PERSON_ID',l_person_id);
4323: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4324: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4325: fnd_message.raise_error;
4326: end if;
4327: --

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

4320: fnd_message.set_token('DATE_CODE',p_date_cd);
4321: fnd_message.set_token('L_PROC',l_proc);
4322: fnd_message.set_token('PERSON_ID',l_person_id);
4323: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4324: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4325: fnd_message.raise_error;
4326: end if;
4327: --
4328: p_returned_date := l_pay_period.end_date;

Line 4325: fnd_message.raise_error;

4321: fnd_message.set_token('L_PROC',l_proc);
4322: fnd_message.set_token('PERSON_ID',l_person_id);
4323: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4324: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4325: fnd_message.raise_error;
4326: end if;
4327: --
4328: p_returned_date := l_pay_period.end_date;
4329: close c_pay_period ;

Line 4350: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');

4346: --
4347: if c_next_pay_period%notfound then
4348: close c_next_pay_period;
4349: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',120);
4350: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4351: fnd_message.set_token('DATE_CODE',p_date_cd);
4352: fnd_message.set_token('PERSON_ID',l_person_id);
4353: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4354: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 4351: fnd_message.set_token('DATE_CODE',p_date_cd);

4347: if c_next_pay_period%notfound then
4348: close c_next_pay_period;
4349: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',120);
4350: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4351: fnd_message.set_token('DATE_CODE',p_date_cd);
4352: fnd_message.set_token('PERSON_ID',l_person_id);
4353: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4354: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4355: fnd_message.raise_error;

Line 4352: fnd_message.set_token('PERSON_ID',l_person_id);

4348: close c_next_pay_period;
4349: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',120);
4350: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4351: fnd_message.set_token('DATE_CODE',p_date_cd);
4352: fnd_message.set_token('PERSON_ID',l_person_id);
4353: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4354: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4355: fnd_message.raise_error;
4356: end if;

Line 4353: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

4349: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',120);
4350: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4351: fnd_message.set_token('DATE_CODE',p_date_cd);
4352: fnd_message.set_token('PERSON_ID',l_person_id);
4353: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4354: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4355: fnd_message.raise_error;
4356: end if;
4357: close c_next_pay_period;

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

4350: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4351: fnd_message.set_token('DATE_CODE',p_date_cd);
4352: fnd_message.set_token('PERSON_ID',l_person_id);
4353: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4354: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4355: fnd_message.raise_error;
4356: end if;
4357: close c_next_pay_period;
4358:

Line 4355: fnd_message.raise_error;

4351: fnd_message.set_token('DATE_CODE',p_date_cd);
4352: fnd_message.set_token('PERSON_ID',l_person_id);
4353: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4354: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4355: fnd_message.raise_error;
4356: end if;
4357: close c_next_pay_period;
4358:
4359: p_returned_date := l_next_pay_period.start_date;

Line 4593: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');

4589: --
4590: if c_pil_popl%notfound then
4591: close c_pil_popl;
4592: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',81);
4593: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4594: fnd_message.set_token('DATE_CODE',p_date_cd);
4595: fnd_message.set_token('L_PROC',l_proc);
4596: fnd_message.raise_error;
4597: end if;

Line 4594: fnd_message.set_token('DATE_CODE',p_date_cd);

4590: if c_pil_popl%notfound then
4591: close c_pil_popl;
4592: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',81);
4593: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4594: fnd_message.set_token('DATE_CODE',p_date_cd);
4595: fnd_message.set_token('L_PROC',l_proc);
4596: fnd_message.raise_error;
4597: end if;
4598: --

Line 4595: fnd_message.set_token('L_PROC',l_proc);

4591: close c_pil_popl;
4592: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',81);
4593: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4594: fnd_message.set_token('DATE_CODE',p_date_cd);
4595: fnd_message.set_token('L_PROC',l_proc);
4596: fnd_message.raise_error;
4597: end if;
4598: --
4599: close c_pil_popl;

Line 4596: fnd_message.raise_error;

4592: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',81);
4593: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4594: fnd_message.set_token('DATE_CODE',p_date_cd);
4595: fnd_message.set_token('L_PROC',l_proc);
4596: fnd_message.raise_error;
4597: end if;
4598: --
4599: close c_pil_popl;
4600: --

Line 4618: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');

4614: fetch c_cm_enrt_perd_end_dt into l_cm_date;
4615: if c_cm_enrt_perd_end_dt%notfound then
4616: close c_cm_enrt_perd_end_dt;
4617: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',86);
4618: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4619: fnd_message.set_token('DATE_CODE',p_date_cd);
4620: fnd_message.set_token('L_PROC',l_proc);
4621: fnd_message.raise_error;
4622: end if;

Line 4619: fnd_message.set_token('DATE_CODE',p_date_cd);

4615: if c_cm_enrt_perd_end_dt%notfound then
4616: close c_cm_enrt_perd_end_dt;
4617: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',86);
4618: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4619: fnd_message.set_token('DATE_CODE',p_date_cd);
4620: fnd_message.set_token('L_PROC',l_proc);
4621: fnd_message.raise_error;
4622: end if;
4623: --

Line 4620: fnd_message.set_token('L_PROC',l_proc);

4616: close c_cm_enrt_perd_end_dt;
4617: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',86);
4618: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4619: fnd_message.set_token('DATE_CODE',p_date_cd);
4620: fnd_message.set_token('L_PROC',l_proc);
4621: fnd_message.raise_error;
4622: end if;
4623: --
4624: close c_cm_enrt_perd_end_dt;

Line 4621: fnd_message.raise_error;

4617: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',86);
4618: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4619: fnd_message.set_token('DATE_CODE',p_date_cd);
4620: fnd_message.set_token('L_PROC',l_proc);
4621: fnd_message.raise_error;
4622: end if;
4623: --
4624: close c_cm_enrt_perd_end_dt;
4625: --

Line 4640: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');

4636: fetch c_cm_enrt_perd_end_dt into l_cm_date;
4637: if c_cm_enrt_perd_end_dt%notfound then
4638: close c_cm_enrt_perd_end_dt;
4639: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',87);
4640: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4641: fnd_message.set_token('DATE_CODE',p_date_cd);
4642: fnd_message.set_token('L_PROC',l_proc);
4643: fnd_message.raise_error;
4644: end if;

Line 4641: fnd_message.set_token('DATE_CODE',p_date_cd);

4637: if c_cm_enrt_perd_end_dt%notfound then
4638: close c_cm_enrt_perd_end_dt;
4639: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',87);
4640: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4641: fnd_message.set_token('DATE_CODE',p_date_cd);
4642: fnd_message.set_token('L_PROC',l_proc);
4643: fnd_message.raise_error;
4644: end if;
4645: --

Line 4642: fnd_message.set_token('L_PROC',l_proc);

4638: close c_cm_enrt_perd_end_dt;
4639: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',87);
4640: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4641: fnd_message.set_token('DATE_CODE',p_date_cd);
4642: fnd_message.set_token('L_PROC',l_proc);
4643: fnd_message.raise_error;
4644: end if;
4645: --
4646: close c_cm_enrt_perd_end_dt;

Line 4643: fnd_message.raise_error;

4639: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',87);
4640: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4641: fnd_message.set_token('DATE_CODE',p_date_cd);
4642: fnd_message.set_token('L_PROC',l_proc);
4643: fnd_message.raise_error;
4644: end if;
4645: --
4646: close c_cm_enrt_perd_end_dt;
4647: --

Line 4661: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');

4657: fetch c_cm_enrt_perd_end_dt into l_cm_date;
4658: if c_cm_enrt_perd_end_dt%notfound then
4659: close c_cm_enrt_perd_end_dt;
4660: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',89);
4661: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4662: fnd_message.set_token('DATE_CODE',p_date_cd);
4663: fnd_message.set_token('L_PROC',l_proc);
4664: fnd_message.raise_error;
4665: end if;

Line 4662: fnd_message.set_token('DATE_CODE',p_date_cd);

4658: if c_cm_enrt_perd_end_dt%notfound then
4659: close c_cm_enrt_perd_end_dt;
4660: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',89);
4661: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4662: fnd_message.set_token('DATE_CODE',p_date_cd);
4663: fnd_message.set_token('L_PROC',l_proc);
4664: fnd_message.raise_error;
4665: end if;
4666: --

Line 4663: fnd_message.set_token('L_PROC',l_proc);

4659: close c_cm_enrt_perd_end_dt;
4660: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',89);
4661: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4662: fnd_message.set_token('DATE_CODE',p_date_cd);
4663: fnd_message.set_token('L_PROC',l_proc);
4664: fnd_message.raise_error;
4665: end if;
4666: --
4667: close c_cm_enrt_perd_end_dt;

Line 4664: fnd_message.raise_error;

4660: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',89);
4661: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4662: fnd_message.set_token('DATE_CODE',p_date_cd);
4663: fnd_message.set_token('L_PROC',l_proc);
4664: fnd_message.raise_error;
4665: end if;
4666: --
4667: close c_cm_enrt_perd_end_dt;
4668: --

Line 4682: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');

4678: fetch c_cm_enrt_perd_end_dt into l_cm_date;
4679: if c_cm_enrt_perd_end_dt%notfound then
4680: close c_cm_enrt_perd_end_dt;
4681: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',90);
4682: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4683: fnd_message.set_token('DATE_CODE',p_date_cd);
4684: fnd_message.set_token('L_PROC',l_proc);
4685: fnd_message.raise_error;
4686: end if;

Line 4683: fnd_message.set_token('DATE_CODE',p_date_cd);

4679: if c_cm_enrt_perd_end_dt%notfound then
4680: close c_cm_enrt_perd_end_dt;
4681: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',90);
4682: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4683: fnd_message.set_token('DATE_CODE',p_date_cd);
4684: fnd_message.set_token('L_PROC',l_proc);
4685: fnd_message.raise_error;
4686: end if;
4687: --

Line 4684: fnd_message.set_token('L_PROC',l_proc);

4680: close c_cm_enrt_perd_end_dt;
4681: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',90);
4682: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4683: fnd_message.set_token('DATE_CODE',p_date_cd);
4684: fnd_message.set_token('L_PROC',l_proc);
4685: fnd_message.raise_error;
4686: end if;
4687: --
4688: close c_cm_enrt_perd_end_dt;

Line 4685: fnd_message.raise_error;

4681: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',90);
4682: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4683: fnd_message.set_token('DATE_CODE',p_date_cd);
4684: fnd_message.set_token('L_PROC',l_proc);
4685: fnd_message.raise_error;
4686: end if;
4687: --
4688: close c_cm_enrt_perd_end_dt;
4689: --

Line 4703: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');

4699: fetch c_cm_enrt_perd_end_dt into l_cm_date;
4700: if c_cm_enrt_perd_end_dt%notfound then
4701: close c_cm_enrt_perd_end_dt;
4702: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',91);
4703: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4704: fnd_message.set_token('DATE_CODE',p_date_cd);
4705: fnd_message.set_token('L_PROC',l_proc);
4706: fnd_message.raise_error;
4707: end if;

Line 4704: fnd_message.set_token('DATE_CODE',p_date_cd);

4700: if c_cm_enrt_perd_end_dt%notfound then
4701: close c_cm_enrt_perd_end_dt;
4702: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',91);
4703: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4704: fnd_message.set_token('DATE_CODE',p_date_cd);
4705: fnd_message.set_token('L_PROC',l_proc);
4706: fnd_message.raise_error;
4707: end if;
4708: --

Line 4705: fnd_message.set_token('L_PROC',l_proc);

4701: close c_cm_enrt_perd_end_dt;
4702: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',91);
4703: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4704: fnd_message.set_token('DATE_CODE',p_date_cd);
4705: fnd_message.set_token('L_PROC',l_proc);
4706: fnd_message.raise_error;
4707: end if;
4708: --
4709: close c_cm_enrt_perd_end_dt;

Line 4706: fnd_message.raise_error;

4702: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',91);
4703: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4704: fnd_message.set_token('DATE_CODE',p_date_cd);
4705: fnd_message.set_token('L_PROC',l_proc);
4706: fnd_message.raise_error;
4707: end if;
4708: --
4709: close c_cm_enrt_perd_end_dt;
4710: --

Line 4725: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');

4721: fetch c_cm_dflt_asnd_dt into l_cm_date;
4722: if c_cm_dflt_asnd_dt%notfound then
4723: close c_cm_dflt_asnd_dt;
4724: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',92);
4725: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4726: fnd_message.set_token('DATE_CODE',p_date_cd);
4727: fnd_message.set_token('L_PROC',l_proc);
4728: fnd_message.raise_error;
4729: end if;

Line 4726: fnd_message.set_token('DATE_CODE',p_date_cd);

4722: if c_cm_dflt_asnd_dt%notfound then
4723: close c_cm_dflt_asnd_dt;
4724: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',92);
4725: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4726: fnd_message.set_token('DATE_CODE',p_date_cd);
4727: fnd_message.set_token('L_PROC',l_proc);
4728: fnd_message.raise_error;
4729: end if;
4730: --

Line 4727: fnd_message.set_token('L_PROC',l_proc);

4723: close c_cm_dflt_asnd_dt;
4724: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',92);
4725: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4726: fnd_message.set_token('DATE_CODE',p_date_cd);
4727: fnd_message.set_token('L_PROC',l_proc);
4728: fnd_message.raise_error;
4729: end if;
4730: --
4731: close c_cm_dflt_asnd_dt;

Line 4728: fnd_message.raise_error;

4724: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',92);
4725: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4726: fnd_message.set_token('DATE_CODE',p_date_cd);
4727: fnd_message.set_token('L_PROC',l_proc);
4728: fnd_message.raise_error;
4729: end if;
4730: --
4731: close c_cm_dflt_asnd_dt;
4732: --

Line 4746: fnd_message.set_name('BEN', 'BEN_91386_FIRST_INELIG');

4742: fetch c_cm_elig_prtn_strt_dt into l_cm_date;
4743: if c_cm_elig_prtn_strt_dt%notfound then
4744: close c_cm_elig_prtn_strt_dt;
4745: -- hr_utility.set_location('BEN_91386_FIRST_INELIG',81);
4746: fnd_message.set_name('BEN', 'BEN_91386_FIRST_INELIG');
4747: fnd_message.set_token('DATE_CODE',p_date_cd);
4748: fnd_message.set_token('PROC',l_proc);
4749: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4750: fnd_message.set_token('BG_ID',to_char(p_business_group_id));

Line 4747: fnd_message.set_token('DATE_CODE',p_date_cd);

4743: if c_cm_elig_prtn_strt_dt%notfound then
4744: close c_cm_elig_prtn_strt_dt;
4745: -- hr_utility.set_location('BEN_91386_FIRST_INELIG',81);
4746: fnd_message.set_name('BEN', 'BEN_91386_FIRST_INELIG');
4747: fnd_message.set_token('DATE_CODE',p_date_cd);
4748: fnd_message.set_token('PROC',l_proc);
4749: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4750: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4751: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

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

4744: close c_cm_elig_prtn_strt_dt;
4745: -- hr_utility.set_location('BEN_91386_FIRST_INELIG',81);
4746: fnd_message.set_name('BEN', 'BEN_91386_FIRST_INELIG');
4747: fnd_message.set_token('DATE_CODE',p_date_cd);
4748: fnd_message.set_token('PROC',l_proc);
4749: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4750: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4751: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4752: fnd_message.raise_error;

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

4745: -- hr_utility.set_location('BEN_91386_FIRST_INELIG',81);
4746: fnd_message.set_name('BEN', 'BEN_91386_FIRST_INELIG');
4747: fnd_message.set_token('DATE_CODE',p_date_cd);
4748: fnd_message.set_token('PROC',l_proc);
4749: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4750: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4751: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4752: fnd_message.raise_error;
4753: end if;

Line 4750: fnd_message.set_token('BG_ID',to_char(p_business_group_id));

4746: fnd_message.set_name('BEN', 'BEN_91386_FIRST_INELIG');
4747: fnd_message.set_token('DATE_CODE',p_date_cd);
4748: fnd_message.set_token('PROC',l_proc);
4749: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4750: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4751: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4752: fnd_message.raise_error;
4753: end if;
4754: close c_cm_elig_prtn_strt_dt;

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

4747: fnd_message.set_token('DATE_CODE',p_date_cd);
4748: fnd_message.set_token('PROC',l_proc);
4749: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4750: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4751: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4752: fnd_message.raise_error;
4753: end if;
4754: close c_cm_elig_prtn_strt_dt;
4755: --

Line 4752: fnd_message.raise_error;

4748: fnd_message.set_token('PROC',l_proc);
4749: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4750: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4751: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4752: fnd_message.raise_error;
4753: end if;
4754: close c_cm_elig_prtn_strt_dt;
4755: --
4756: p_returned_date := l_cm_date - 14;

Line 4767: fnd_message.set_name('BEN', 'BEN_91386_FIRST_INELIG');

4763: fetch c_cm_elig_prtn_end_dt into l_cm_date;
4764: if c_cm_elig_prtn_end_dt%notfound then
4765: close c_cm_elig_prtn_end_dt;
4766: -- hr_utility.set_location('BEN_91386_FIRST_INELIG',93);
4767: fnd_message.set_name('BEN', 'BEN_91386_FIRST_INELIG');
4768: fnd_message.set_token('DATE_CODE',p_date_cd);
4769: fnd_message.set_token('PROC',l_proc);
4770: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4771: fnd_message.set_token('BG_ID',to_char(p_business_group_id));

Line 4768: fnd_message.set_token('DATE_CODE',p_date_cd);

4764: if c_cm_elig_prtn_end_dt%notfound then
4765: close c_cm_elig_prtn_end_dt;
4766: -- hr_utility.set_location('BEN_91386_FIRST_INELIG',93);
4767: fnd_message.set_name('BEN', 'BEN_91386_FIRST_INELIG');
4768: fnd_message.set_token('DATE_CODE',p_date_cd);
4769: fnd_message.set_token('PROC',l_proc);
4770: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4771: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4772: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

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

4765: close c_cm_elig_prtn_end_dt;
4766: -- hr_utility.set_location('BEN_91386_FIRST_INELIG',93);
4767: fnd_message.set_name('BEN', 'BEN_91386_FIRST_INELIG');
4768: fnd_message.set_token('DATE_CODE',p_date_cd);
4769: fnd_message.set_token('PROC',l_proc);
4770: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4771: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4772: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4773: fnd_message.raise_error;

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

4766: -- hr_utility.set_location('BEN_91386_FIRST_INELIG',93);
4767: fnd_message.set_name('BEN', 'BEN_91386_FIRST_INELIG');
4768: fnd_message.set_token('DATE_CODE',p_date_cd);
4769: fnd_message.set_token('PROC',l_proc);
4770: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4771: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4772: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4773: fnd_message.raise_error;
4774: end if;

Line 4771: fnd_message.set_token('BG_ID',to_char(p_business_group_id));

4767: fnd_message.set_name('BEN', 'BEN_91386_FIRST_INELIG');
4768: fnd_message.set_token('DATE_CODE',p_date_cd);
4769: fnd_message.set_token('PROC',l_proc);
4770: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4771: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4772: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4773: fnd_message.raise_error;
4774: end if;
4775: close c_cm_elig_prtn_end_dt;

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

4768: fnd_message.set_token('DATE_CODE',p_date_cd);
4769: fnd_message.set_token('PROC',l_proc);
4770: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4771: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4772: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4773: fnd_message.raise_error;
4774: end if;
4775: close c_cm_elig_prtn_end_dt;
4776: --

Line 4773: fnd_message.raise_error;

4769: fnd_message.set_token('PROC',l_proc);
4770: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4771: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4772: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4773: fnd_message.raise_error;
4774: end if;
4775: close c_cm_elig_prtn_end_dt;
4776: --
4777: p_returned_date := l_cm_date - 14;

Line 4790: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');

4786: fetch c_cm_enrt_perd_end_dt into l_cm_date;
4787: if c_cm_enrt_perd_end_dt%notfound then
4788: close c_cm_enrt_perd_end_dt;
4789: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',88);
4790: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4791: fnd_message.set_token('DATE_CODE',p_date_cd);
4792: fnd_message.set_token('L_PROC',l_proc);
4793: fnd_message.raise_error;
4794: end if;

Line 4791: fnd_message.set_token('DATE_CODE',p_date_cd);

4787: if c_cm_enrt_perd_end_dt%notfound then
4788: close c_cm_enrt_perd_end_dt;
4789: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',88);
4790: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4791: fnd_message.set_token('DATE_CODE',p_date_cd);
4792: fnd_message.set_token('L_PROC',l_proc);
4793: fnd_message.raise_error;
4794: end if;
4795: --

Line 4792: fnd_message.set_token('L_PROC',l_proc);

4788: close c_cm_enrt_perd_end_dt;
4789: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',88);
4790: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4791: fnd_message.set_token('DATE_CODE',p_date_cd);
4792: fnd_message.set_token('L_PROC',l_proc);
4793: fnd_message.raise_error;
4794: end if;
4795: --
4796: close c_cm_enrt_perd_end_dt;

Line 4793: fnd_message.raise_error;

4789: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',88);
4790: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4791: fnd_message.set_token('DATE_CODE',p_date_cd);
4792: fnd_message.set_token('L_PROC',l_proc);
4793: fnd_message.raise_error;
4794: end if;
4795: --
4796: close c_cm_enrt_perd_end_dt;
4797: --

Line 4810: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');

4806: fetch c_cm_auto_asnd_dt into l_cm_date;
4807: if c_cm_auto_asnd_dt%notfound then
4808: close c_cm_auto_asnd_dt;
4809: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',98);
4810: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4811: fnd_message.set_token('DATE_CODE',p_date_cd);
4812: fnd_message.set_token('L_PROC',l_proc);
4813: fnd_message.raise_error;
4814: end if;

Line 4811: fnd_message.set_token('DATE_CODE',p_date_cd);

4807: if c_cm_auto_asnd_dt%notfound then
4808: close c_cm_auto_asnd_dt;
4809: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',98);
4810: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4811: fnd_message.set_token('DATE_CODE',p_date_cd);
4812: fnd_message.set_token('L_PROC',l_proc);
4813: fnd_message.raise_error;
4814: end if;
4815: close c_cm_auto_asnd_dt;

Line 4812: fnd_message.set_token('L_PROC',l_proc);

4808: close c_cm_auto_asnd_dt;
4809: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',98);
4810: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4811: fnd_message.set_token('DATE_CODE',p_date_cd);
4812: fnd_message.set_token('L_PROC',l_proc);
4813: fnd_message.raise_error;
4814: end if;
4815: close c_cm_auto_asnd_dt;
4816: --

Line 4813: fnd_message.raise_error;

4809: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',98);
4810: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4811: fnd_message.set_token('DATE_CODE',p_date_cd);
4812: fnd_message.set_token('L_PROC',l_proc);
4813: fnd_message.raise_error;
4814: end if;
4815: close c_cm_auto_asnd_dt;
4816: --
4817: p_returned_date := l_cm_date;

Line 4913: fnd_message.set_name('BEN','BEN_92380_CANNOT_CALC_LFDPPCF');

4909: --
4910: close c_pay_period_for_date;
4911: -- hr_utility.set_location('BEN_92380_CANNOT_CALC_LFDPPCF',96);
4912: -- hr_utility.set_location('l_lf_evt_ocrd_dt'||to_char(l_lf_evt_ocrd_dt),96);
4913: fnd_message.set_name('BEN','BEN_92380_CANNOT_CALC_LFDPPCF');
4914: fnd_message.set_token('L_PROC',l_proc);
4915: fnd_message.set_token('PERSON_ID',l_person_id);
4916: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4917: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 4914: fnd_message.set_token('L_PROC',l_proc);

4910: close c_pay_period_for_date;
4911: -- hr_utility.set_location('BEN_92380_CANNOT_CALC_LFDPPCF',96);
4912: -- hr_utility.set_location('l_lf_evt_ocrd_dt'||to_char(l_lf_evt_ocrd_dt),96);
4913: fnd_message.set_name('BEN','BEN_92380_CANNOT_CALC_LFDPPCF');
4914: fnd_message.set_token('L_PROC',l_proc);
4915: fnd_message.set_token('PERSON_ID',l_person_id);
4916: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4917: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4918: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);

Line 4915: fnd_message.set_token('PERSON_ID',l_person_id);

4911: -- hr_utility.set_location('BEN_92380_CANNOT_CALC_LFDPPCF',96);
4912: -- hr_utility.set_location('l_lf_evt_ocrd_dt'||to_char(l_lf_evt_ocrd_dt),96);
4913: fnd_message.set_name('BEN','BEN_92380_CANNOT_CALC_LFDPPCF');
4914: fnd_message.set_token('L_PROC',l_proc);
4915: fnd_message.set_token('PERSON_ID',l_person_id);
4916: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4917: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4918: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);
4919: fnd_message.raise_error;

Line 4916: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

4912: -- hr_utility.set_location('l_lf_evt_ocrd_dt'||to_char(l_lf_evt_ocrd_dt),96);
4913: fnd_message.set_name('BEN','BEN_92380_CANNOT_CALC_LFDPPCF');
4914: fnd_message.set_token('L_PROC',l_proc);
4915: fnd_message.set_token('PERSON_ID',l_person_id);
4916: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4917: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4918: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);
4919: fnd_message.raise_error;
4920: --

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

4913: fnd_message.set_name('BEN','BEN_92380_CANNOT_CALC_LFDPPCF');
4914: fnd_message.set_token('L_PROC',l_proc);
4915: fnd_message.set_token('PERSON_ID',l_person_id);
4916: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4917: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4918: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);
4919: fnd_message.raise_error;
4920: --
4921: end if;

Line 4918: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);

4914: fnd_message.set_token('L_PROC',l_proc);
4915: fnd_message.set_token('PERSON_ID',l_person_id);
4916: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4917: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4918: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);
4919: fnd_message.raise_error;
4920: --
4921: end if;
4922: --

Line 4919: fnd_message.raise_error;

4915: fnd_message.set_token('PERSON_ID',l_person_id);
4916: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4917: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4918: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);
4919: fnd_message.raise_error;
4920: --
4921: end if;
4922: --
4923: close c_pay_period_for_date;

Line 4937: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');

4933: --
4934: if c_next_pay_period%notfound then
4935: close c_next_pay_period;
4936: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',125);
4937: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4938: fnd_message.set_token('DATE_CODE',p_date_cd);
4939: fnd_message.set_token('PERSON_ID',l_person_id);
4940: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4941: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 4938: fnd_message.set_token('DATE_CODE',p_date_cd);

4934: if c_next_pay_period%notfound then
4935: close c_next_pay_period;
4936: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',125);
4937: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4938: fnd_message.set_token('DATE_CODE',p_date_cd);
4939: fnd_message.set_token('PERSON_ID',l_person_id);
4940: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4941: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4942: fnd_message.raise_error;

Line 4939: fnd_message.set_token('PERSON_ID',l_person_id);

4935: close c_next_pay_period;
4936: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',125);
4937: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4938: fnd_message.set_token('DATE_CODE',p_date_cd);
4939: fnd_message.set_token('PERSON_ID',l_person_id);
4940: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4941: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4942: fnd_message.raise_error;
4943: end if;

Line 4940: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

4936: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',125);
4937: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4938: fnd_message.set_token('DATE_CODE',p_date_cd);
4939: fnd_message.set_token('PERSON_ID',l_person_id);
4940: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4941: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4942: fnd_message.raise_error;
4943: end if;
4944: --

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

4937: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4938: fnd_message.set_token('DATE_CODE',p_date_cd);
4939: fnd_message.set_token('PERSON_ID',l_person_id);
4940: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4941: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4942: fnd_message.raise_error;
4943: end if;
4944: --
4945: p_returned_date := l_next_pay_period.start_date;

Line 4942: fnd_message.raise_error;

4938: fnd_message.set_token('DATE_CODE',p_date_cd);
4939: fnd_message.set_token('PERSON_ID',l_person_id);
4940: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4941: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4942: fnd_message.raise_error;
4943: end if;
4944: --
4945: p_returned_date := l_next_pay_period.start_date;
4946: --

Line 4963: fnd_message.set_name('BEN','BEN_92380_CANNOT_CALC_LFDPPCF');

4959: --
4960: close c_pay_period_for_date;
4961: -- hr_utility.set_location('BEN_92380_CANNOT_CALC_LFDPPCF',97);
4962: -- hr_utility.set_location('l_recorded_date'||to_char(l_recorded_date),97);
4963: fnd_message.set_name('BEN','BEN_92380_CANNOT_CALC_LFDPPCF');
4964: fnd_message.set_token('L_PROC',l_proc);
4965: fnd_message.set_token('PERSON_ID',l_person_id);
4966: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4967: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 4964: fnd_message.set_token('L_PROC',l_proc);

4960: close c_pay_period_for_date;
4961: -- hr_utility.set_location('BEN_92380_CANNOT_CALC_LFDPPCF',97);
4962: -- hr_utility.set_location('l_recorded_date'||to_char(l_recorded_date),97);
4963: fnd_message.set_name('BEN','BEN_92380_CANNOT_CALC_LFDPPCF');
4964: fnd_message.set_token('L_PROC',l_proc);
4965: fnd_message.set_token('PERSON_ID',l_person_id);
4966: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4967: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4968: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);

Line 4965: fnd_message.set_token('PERSON_ID',l_person_id);

4961: -- hr_utility.set_location('BEN_92380_CANNOT_CALC_LFDPPCF',97);
4962: -- hr_utility.set_location('l_recorded_date'||to_char(l_recorded_date),97);
4963: fnd_message.set_name('BEN','BEN_92380_CANNOT_CALC_LFDPPCF');
4964: fnd_message.set_token('L_PROC',l_proc);
4965: fnd_message.set_token('PERSON_ID',l_person_id);
4966: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4967: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4968: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);
4969: fnd_message.raise_error;

Line 4966: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

4962: -- hr_utility.set_location('l_recorded_date'||to_char(l_recorded_date),97);
4963: fnd_message.set_name('BEN','BEN_92380_CANNOT_CALC_LFDPPCF');
4964: fnd_message.set_token('L_PROC',l_proc);
4965: fnd_message.set_token('PERSON_ID',l_person_id);
4966: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4967: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4968: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);
4969: fnd_message.raise_error;
4970: --

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

4963: fnd_message.set_name('BEN','BEN_92380_CANNOT_CALC_LFDPPCF');
4964: fnd_message.set_token('L_PROC',l_proc);
4965: fnd_message.set_token('PERSON_ID',l_person_id);
4966: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4967: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4968: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);
4969: fnd_message.raise_error;
4970: --
4971: end if;

Line 4968: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);

4964: fnd_message.set_token('L_PROC',l_proc);
4965: fnd_message.set_token('PERSON_ID',l_person_id);
4966: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4967: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4968: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);
4969: fnd_message.raise_error;
4970: --
4971: end if;
4972: --

Line 4969: fnd_message.raise_error;

4965: fnd_message.set_token('PERSON_ID',l_person_id);
4966: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4967: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4968: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);
4969: fnd_message.raise_error;
4970: --
4971: end if;
4972: --
4973: close c_pay_period_for_date;

Line 4989: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');

4985: --
4986: if c_next_pay_period%notfound then
4987: close c_next_pay_period;
4988: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',130);
4989: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4990: fnd_message.set_token('DATE_CODE',p_date_cd);
4991: fnd_message.set_token('PERSON_ID',l_person_id);
4992: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4993: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 4990: fnd_message.set_token('DATE_CODE',p_date_cd);

4986: if c_next_pay_period%notfound then
4987: close c_next_pay_period;
4988: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',130);
4989: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4990: fnd_message.set_token('DATE_CODE',p_date_cd);
4991: fnd_message.set_token('PERSON_ID',l_person_id);
4992: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4993: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4994: fnd_message.raise_error;

Line 4991: fnd_message.set_token('PERSON_ID',l_person_id);

4987: close c_next_pay_period;
4988: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',130);
4989: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4990: fnd_message.set_token('DATE_CODE',p_date_cd);
4991: fnd_message.set_token('PERSON_ID',l_person_id);
4992: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4993: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4994: fnd_message.raise_error;
4995: end if;

Line 4992: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

4988: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',130);
4989: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4990: fnd_message.set_token('DATE_CODE',p_date_cd);
4991: fnd_message.set_token('PERSON_ID',l_person_id);
4992: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4993: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4994: fnd_message.raise_error;
4995: end if;
4996: --

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

4989: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4990: fnd_message.set_token('DATE_CODE',p_date_cd);
4991: fnd_message.set_token('PERSON_ID',l_person_id);
4992: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4993: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4994: fnd_message.raise_error;
4995: end if;
4996: --
4997: p_returned_date := l_next_pay_period.start_date;

Line 4994: fnd_message.raise_error;

4990: fnd_message.set_token('DATE_CODE',p_date_cd);
4991: fnd_message.set_token('PERSON_ID',l_person_id);
4992: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4993: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4994: fnd_message.raise_error;
4995: end if;
4996: --
4997: p_returned_date := l_next_pay_period.start_date;
4998: --

Line 5262: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');

5258: fetch c_cm_dflt_asnd_dt into l_cm_date;
5259: if c_cm_dflt_asnd_dt%notfound then
5260: close c_cm_dflt_asnd_dt;
5261: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',96);
5262: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
5263: fnd_message.set_token('DATE_CODE',p_date_cd);
5264: fnd_message.set_token('L_PROC',l_proc);
5265: fnd_message.raise_error;
5266: end if;

Line 5263: fnd_message.set_token('DATE_CODE',p_date_cd);

5259: if c_cm_dflt_asnd_dt%notfound then
5260: close c_cm_dflt_asnd_dt;
5261: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',96);
5262: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
5263: fnd_message.set_token('DATE_CODE',p_date_cd);
5264: fnd_message.set_token('L_PROC',l_proc);
5265: fnd_message.raise_error;
5266: end if;
5267: close c_cm_dflt_asnd_dt;

Line 5264: fnd_message.set_token('L_PROC',l_proc);

5260: close c_cm_dflt_asnd_dt;
5261: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',96);
5262: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
5263: fnd_message.set_token('DATE_CODE',p_date_cd);
5264: fnd_message.set_token('L_PROC',l_proc);
5265: fnd_message.raise_error;
5266: end if;
5267: close c_cm_dflt_asnd_dt;
5268: --

Line 5265: fnd_message.raise_error;

5261: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',96);
5262: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
5263: fnd_message.set_token('DATE_CODE',p_date_cd);
5264: fnd_message.set_token('L_PROC',l_proc);
5265: fnd_message.raise_error;
5266: end if;
5267: close c_cm_dflt_asnd_dt;
5268: --
5269: p_returned_date := l_cm_date;

Line 5282: fnd_message.set_name('BEN', 'BEN_92381_ELIG_PER_NOT_FOUND');

5278: fetch c_cm_elig_prtn_strt_dt into l_cm_date;
5279: if c_cm_elig_prtn_strt_dt%notfound then
5280: close c_cm_elig_prtn_strt_dt;
5281: -- hr_utility.set_location('BEN_92381_ELIG_PER_NOT_FOUND',96);
5282: fnd_message.set_name('BEN', 'BEN_92381_ELIG_PER_NOT_FOUND');
5283: fnd_message.set_token('PROC',l_proc);
5284: fnd_message.set_token('DATE_CODE',p_date_cd);
5285: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5286: fnd_message.set_token('BG_ID',to_char(p_business_group_id));

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

5279: if c_cm_elig_prtn_strt_dt%notfound then
5280: close c_cm_elig_prtn_strt_dt;
5281: -- hr_utility.set_location('BEN_92381_ELIG_PER_NOT_FOUND',96);
5282: fnd_message.set_name('BEN', 'BEN_92381_ELIG_PER_NOT_FOUND');
5283: fnd_message.set_token('PROC',l_proc);
5284: fnd_message.set_token('DATE_CODE',p_date_cd);
5285: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5286: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5287: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

Line 5284: fnd_message.set_token('DATE_CODE',p_date_cd);

5280: close c_cm_elig_prtn_strt_dt;
5281: -- hr_utility.set_location('BEN_92381_ELIG_PER_NOT_FOUND',96);
5282: fnd_message.set_name('BEN', 'BEN_92381_ELIG_PER_NOT_FOUND');
5283: fnd_message.set_token('PROC',l_proc);
5284: fnd_message.set_token('DATE_CODE',p_date_cd);
5285: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5286: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5287: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5288: fnd_message.raise_error;

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

5281: -- hr_utility.set_location('BEN_92381_ELIG_PER_NOT_FOUND',96);
5282: fnd_message.set_name('BEN', 'BEN_92381_ELIG_PER_NOT_FOUND');
5283: fnd_message.set_token('PROC',l_proc);
5284: fnd_message.set_token('DATE_CODE',p_date_cd);
5285: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5286: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5287: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5288: fnd_message.raise_error;
5289: end if;

Line 5286: fnd_message.set_token('BG_ID',to_char(p_business_group_id));

5282: fnd_message.set_name('BEN', 'BEN_92381_ELIG_PER_NOT_FOUND');
5283: fnd_message.set_token('PROC',l_proc);
5284: fnd_message.set_token('DATE_CODE',p_date_cd);
5285: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5286: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5287: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5288: fnd_message.raise_error;
5289: end if;
5290: close c_cm_elig_prtn_strt_dt;

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

5283: fnd_message.set_token('PROC',l_proc);
5284: fnd_message.set_token('DATE_CODE',p_date_cd);
5285: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5286: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5287: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5288: fnd_message.raise_error;
5289: end if;
5290: close c_cm_elig_prtn_strt_dt;
5291: --

Line 5288: fnd_message.raise_error;

5284: fnd_message.set_token('DATE_CODE',p_date_cd);
5285: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5286: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5287: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5288: fnd_message.raise_error;
5289: end if;
5290: close c_cm_elig_prtn_strt_dt;
5291: --
5292: p_returned_date := l_cm_date;

Line 5305: fnd_message.set_name('BEN', 'BEN_92381_ELIG_PER_NOT_FOUND');

5301: fetch c_cm_elig_prtn_end_dt into l_cm_date;
5302: if c_cm_elig_prtn_end_dt%notfound then
5303: close c_cm_elig_prtn_end_dt;
5304: -- hr_utility.set_location('BEN_92381_ELIG_PER_NOT_FOUND',98);
5305: fnd_message.set_name('BEN', 'BEN_92381_ELIG_PER_NOT_FOUND');
5306: fnd_message.set_token('PROC',l_proc);
5307: fnd_message.set_token('DATE_CODE',p_date_cd);
5308: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5309: fnd_message.set_token('BG_ID',to_char(p_business_group_id));

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

5302: if c_cm_elig_prtn_end_dt%notfound then
5303: close c_cm_elig_prtn_end_dt;
5304: -- hr_utility.set_location('BEN_92381_ELIG_PER_NOT_FOUND',98);
5305: fnd_message.set_name('BEN', 'BEN_92381_ELIG_PER_NOT_FOUND');
5306: fnd_message.set_token('PROC',l_proc);
5307: fnd_message.set_token('DATE_CODE',p_date_cd);
5308: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5309: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5310: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

Line 5307: fnd_message.set_token('DATE_CODE',p_date_cd);

5303: close c_cm_elig_prtn_end_dt;
5304: -- hr_utility.set_location('BEN_92381_ELIG_PER_NOT_FOUND',98);
5305: fnd_message.set_name('BEN', 'BEN_92381_ELIG_PER_NOT_FOUND');
5306: fnd_message.set_token('PROC',l_proc);
5307: fnd_message.set_token('DATE_CODE',p_date_cd);
5308: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5309: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5310: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5311: fnd_message.raise_error;

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

5304: -- hr_utility.set_location('BEN_92381_ELIG_PER_NOT_FOUND',98);
5305: fnd_message.set_name('BEN', 'BEN_92381_ELIG_PER_NOT_FOUND');
5306: fnd_message.set_token('PROC',l_proc);
5307: fnd_message.set_token('DATE_CODE',p_date_cd);
5308: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5309: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5310: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5311: fnd_message.raise_error;
5312: end if;

Line 5309: fnd_message.set_token('BG_ID',to_char(p_business_group_id));

5305: fnd_message.set_name('BEN', 'BEN_92381_ELIG_PER_NOT_FOUND');
5306: fnd_message.set_token('PROC',l_proc);
5307: fnd_message.set_token('DATE_CODE',p_date_cd);
5308: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5309: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5310: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5311: fnd_message.raise_error;
5312: end if;
5313: close c_cm_elig_prtn_end_dt;

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

5306: fnd_message.set_token('PROC',l_proc);
5307: fnd_message.set_token('DATE_CODE',p_date_cd);
5308: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5309: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5310: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5311: fnd_message.raise_error;
5312: end if;
5313: close c_cm_elig_prtn_end_dt;
5314: --

Line 5311: fnd_message.raise_error;

5307: fnd_message.set_token('DATE_CODE',p_date_cd);
5308: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5309: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5310: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5311: fnd_message.raise_error;
5312: end if;
5313: close c_cm_elig_prtn_end_dt;
5314: --
5315: p_returned_date := l_cm_date;

Line 5327: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');

5323: open c_cm_enrt_perd_end_dt;
5324: fetch c_cm_enrt_perd_end_dt into l_cm_date;
5325: if c_cm_enrt_perd_end_dt%notfound then
5326: close c_cm_enrt_perd_end_dt;
5327: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
5328: fnd_message.set_token('DATE_CODE',p_date_cd);
5329: fnd_message.set_token('L_PROC',l_proc);
5330: fnd_message.raise_error;
5331: end if;

Line 5328: fnd_message.set_token('DATE_CODE',p_date_cd);

5324: fetch c_cm_enrt_perd_end_dt into l_cm_date;
5325: if c_cm_enrt_perd_end_dt%notfound then
5326: close c_cm_enrt_perd_end_dt;
5327: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
5328: fnd_message.set_token('DATE_CODE',p_date_cd);
5329: fnd_message.set_token('L_PROC',l_proc);
5330: fnd_message.raise_error;
5331: end if;
5332: close c_cm_enrt_perd_end_dt;

Line 5329: fnd_message.set_token('L_PROC',l_proc);

5325: if c_cm_enrt_perd_end_dt%notfound then
5326: close c_cm_enrt_perd_end_dt;
5327: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
5328: fnd_message.set_token('DATE_CODE',p_date_cd);
5329: fnd_message.set_token('L_PROC',l_proc);
5330: fnd_message.raise_error;
5331: end if;
5332: close c_cm_enrt_perd_end_dt;
5333: --

Line 5330: fnd_message.raise_error;

5326: close c_cm_enrt_perd_end_dt;
5327: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
5328: fnd_message.set_token('DATE_CODE',p_date_cd);
5329: fnd_message.set_token('L_PROC',l_proc);
5330: fnd_message.raise_error;
5331: end if;
5332: close c_cm_enrt_perd_end_dt;
5333: --
5334: p_returned_date := l_cm_date;

Line 5475: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');

5471: fetch c_pay_period into l_pay_period;
5472: if c_pay_period%notfound then
5473: close c_pay_period;
5474: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',135);
5475: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5476: fnd_message.set_token('DATE_CODE',p_date_cd);
5477: fnd_message.set_token('PERSON_ID',l_person_id);
5478: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5479: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 5476: fnd_message.set_token('DATE_CODE',p_date_cd);

5472: if c_pay_period%notfound then
5473: close c_pay_period;
5474: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',135);
5475: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5476: fnd_message.set_token('DATE_CODE',p_date_cd);
5477: fnd_message.set_token('PERSON_ID',l_person_id);
5478: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5479: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5480: fnd_message.raise_error;

Line 5477: fnd_message.set_token('PERSON_ID',l_person_id);

5473: close c_pay_period;
5474: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',135);
5475: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5476: fnd_message.set_token('DATE_CODE',p_date_cd);
5477: fnd_message.set_token('PERSON_ID',l_person_id);
5478: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5479: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5480: fnd_message.raise_error;
5481: end if;

Line 5478: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

5474: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',135);
5475: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5476: fnd_message.set_token('DATE_CODE',p_date_cd);
5477: fnd_message.set_token('PERSON_ID',l_person_id);
5478: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5479: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5480: fnd_message.raise_error;
5481: end if;
5482: --

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

5475: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5476: fnd_message.set_token('DATE_CODE',p_date_cd);
5477: fnd_message.set_token('PERSON_ID',l_person_id);
5478: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5479: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5480: fnd_message.raise_error;
5481: end if;
5482: --
5483: close c_pay_period ;

Line 5480: fnd_message.raise_error;

5476: fnd_message.set_token('DATE_CODE',p_date_cd);
5477: fnd_message.set_token('PERSON_ID',l_person_id);
5478: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5479: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5480: fnd_message.raise_error;
5481: end if;
5482: --
5483: close c_pay_period ;
5484: --

Line 5497: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');

5493: --
5494: if c_next_pay_period%notfound then
5495: close c_next_pay_period;
5496: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',140);
5497: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5498: fnd_message.set_token('DATE_CODE',p_date_cd);
5499: fnd_message.set_token('PERSON_ID',l_person_id);
5500: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5501: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 5498: fnd_message.set_token('DATE_CODE',p_date_cd);

5494: if c_next_pay_period%notfound then
5495: close c_next_pay_period;
5496: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',140);
5497: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5498: fnd_message.set_token('DATE_CODE',p_date_cd);
5499: fnd_message.set_token('PERSON_ID',l_person_id);
5500: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5501: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5502: fnd_message.raise_error;

Line 5499: fnd_message.set_token('PERSON_ID',l_person_id);

5495: close c_next_pay_period;
5496: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',140);
5497: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5498: fnd_message.set_token('DATE_CODE',p_date_cd);
5499: fnd_message.set_token('PERSON_ID',l_person_id);
5500: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5501: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5502: fnd_message.raise_error;
5503: end if;

Line 5500: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

5496: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',140);
5497: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5498: fnd_message.set_token('DATE_CODE',p_date_cd);
5499: fnd_message.set_token('PERSON_ID',l_person_id);
5500: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5501: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5502: fnd_message.raise_error;
5503: end if;
5504: --

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

5497: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5498: fnd_message.set_token('DATE_CODE',p_date_cd);
5499: fnd_message.set_token('PERSON_ID',l_person_id);
5500: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5501: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5502: fnd_message.raise_error;
5503: end if;
5504: --
5505: p_returned_date := l_next_pay_period.start_date;

Line 5502: fnd_message.raise_error;

5498: fnd_message.set_token('DATE_CODE',p_date_cd);
5499: fnd_message.set_token('PERSON_ID',l_person_id);
5500: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5501: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5502: fnd_message.raise_error;
5503: end if;
5504: --
5505: p_returned_date := l_next_pay_period.start_date;
5506: --

Line 5913: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');

5909: if c_pay_period_for_date%notfound then
5910: --
5911: close c_pay_period_for_date;
5912: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',145);
5913: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5914: fnd_message.set_token('DATE_CODE',p_date_cd);
5915: fnd_message.set_token('PERSON_ID',l_person_id);
5916: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5917: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 5914: fnd_message.set_token('DATE_CODE',p_date_cd);

5910: --
5911: close c_pay_period_for_date;
5912: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',145);
5913: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5914: fnd_message.set_token('DATE_CODE',p_date_cd);
5915: fnd_message.set_token('PERSON_ID',l_person_id);
5916: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5917: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5918: fnd_message.raise_error;

Line 5915: fnd_message.set_token('PERSON_ID',l_person_id);

5911: close c_pay_period_for_date;
5912: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',145);
5913: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5914: fnd_message.set_token('DATE_CODE',p_date_cd);
5915: fnd_message.set_token('PERSON_ID',l_person_id);
5916: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5917: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5918: fnd_message.raise_error;
5919: --

Line 5916: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

5912: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',145);
5913: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5914: fnd_message.set_token('DATE_CODE',p_date_cd);
5915: fnd_message.set_token('PERSON_ID',l_person_id);
5916: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5917: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5918: fnd_message.raise_error;
5919: --
5920: end if;

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

5913: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5914: fnd_message.set_token('DATE_CODE',p_date_cd);
5915: fnd_message.set_token('PERSON_ID',l_person_id);
5916: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5917: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5918: fnd_message.raise_error;
5919: --
5920: end if;
5921: --

Line 5918: fnd_message.raise_error;

5914: fnd_message.set_token('DATE_CODE',p_date_cd);
5915: fnd_message.set_token('PERSON_ID',l_person_id);
5916: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5917: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5918: fnd_message.raise_error;
5919: --
5920: end if;
5921: --
5922: close c_pay_period_for_date;

Line 5954: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');

5950: if c_pre_pay_period%notfound then
5951: --
5952: close c_pre_pay_period;
5953: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',150);
5954: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5955: fnd_message.set_token('DATE_CODE',p_date_cd);
5956: fnd_message.set_token('PERSON_ID',l_person_id);
5957: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5958: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 5955: fnd_message.set_token('DATE_CODE',p_date_cd);

5951: --
5952: close c_pre_pay_period;
5953: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',150);
5954: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5955: fnd_message.set_token('DATE_CODE',p_date_cd);
5956: fnd_message.set_token('PERSON_ID',l_person_id);
5957: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5958: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5959: fnd_message.raise_error;

Line 5956: fnd_message.set_token('PERSON_ID',l_person_id);

5952: close c_pre_pay_period;
5953: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',150);
5954: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5955: fnd_message.set_token('DATE_CODE',p_date_cd);
5956: fnd_message.set_token('PERSON_ID',l_person_id);
5957: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5958: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5959: fnd_message.raise_error;
5960: --

Line 5957: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

5953: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',150);
5954: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5955: fnd_message.set_token('DATE_CODE',p_date_cd);
5956: fnd_message.set_token('PERSON_ID',l_person_id);
5957: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5958: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5959: fnd_message.raise_error;
5960: --
5961: end if;

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

5954: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5955: fnd_message.set_token('DATE_CODE',p_date_cd);
5956: fnd_message.set_token('PERSON_ID',l_person_id);
5957: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5958: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5959: fnd_message.raise_error;
5960: --
5961: end if;
5962: --

Line 5959: fnd_message.raise_error;

5955: fnd_message.set_token('DATE_CODE',p_date_cd);
5956: fnd_message.set_token('PERSON_ID',l_person_id);
5957: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5958: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5959: fnd_message.raise_error;
5960: --
5961: end if;
5962: --
5963: close c_pre_pay_period;

Line 6207: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');

6203: l_end_date;
6204: --
6205: if c_pay_period_for_date%notfound then
6206: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',160);
6207: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6208: fnd_message.set_token('DATE_CODE',p_date_cd);
6209: fnd_message.set_token('PERSON_ID',l_person_id);
6210: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6211: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 6208: fnd_message.set_token('DATE_CODE',p_date_cd);

6204: --
6205: if c_pay_period_for_date%notfound then
6206: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',160);
6207: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6208: fnd_message.set_token('DATE_CODE',p_date_cd);
6209: fnd_message.set_token('PERSON_ID',l_person_id);
6210: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6211: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6212: fnd_message.raise_error;

Line 6209: fnd_message.set_token('PERSON_ID',l_person_id);

6205: if c_pay_period_for_date%notfound then
6206: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',160);
6207: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6208: fnd_message.set_token('DATE_CODE',p_date_cd);
6209: fnd_message.set_token('PERSON_ID',l_person_id);
6210: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6211: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6212: fnd_message.raise_error;
6213: --

Line 6210: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

6206: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',160);
6207: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6208: fnd_message.set_token('DATE_CODE',p_date_cd);
6209: fnd_message.set_token('PERSON_ID',l_person_id);
6210: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6211: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6212: fnd_message.raise_error;
6213: --
6214: end if;

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

6207: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6208: fnd_message.set_token('DATE_CODE',p_date_cd);
6209: fnd_message.set_token('PERSON_ID',l_person_id);
6210: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6211: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6212: fnd_message.raise_error;
6213: --
6214: end if;
6215: --

Line 6212: fnd_message.raise_error;

6208: fnd_message.set_token('DATE_CODE',p_date_cd);
6209: fnd_message.set_token('PERSON_ID',l_person_id);
6210: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6211: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6212: fnd_message.raise_error;
6213: --
6214: end if;
6215: --
6216: close c_pay_period_for_date;

Line 6242: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');

6238: l_end_date;
6239: --
6240: if c_pay_period_for_date%notfound then
6241: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',165);
6242: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6243: fnd_message.set_token('DATE_CODE',p_date_cd);
6244: fnd_message.set_token('PERSON_ID',l_person_id);
6245: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6246: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 6243: fnd_message.set_token('DATE_CODE',p_date_cd);

6239: --
6240: if c_pay_period_for_date%notfound then
6241: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',165);
6242: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6243: fnd_message.set_token('DATE_CODE',p_date_cd);
6244: fnd_message.set_token('PERSON_ID',l_person_id);
6245: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6246: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6247: fnd_message.raise_error;

Line 6244: fnd_message.set_token('PERSON_ID',l_person_id);

6240: if c_pay_period_for_date%notfound then
6241: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',165);
6242: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6243: fnd_message.set_token('DATE_CODE',p_date_cd);
6244: fnd_message.set_token('PERSON_ID',l_person_id);
6245: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6246: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6247: fnd_message.raise_error;
6248: --

Line 6245: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

6241: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',165);
6242: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6243: fnd_message.set_token('DATE_CODE',p_date_cd);
6244: fnd_message.set_token('PERSON_ID',l_person_id);
6245: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6246: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6247: fnd_message.raise_error;
6248: --
6249: end if;

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

6242: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6243: fnd_message.set_token('DATE_CODE',p_date_cd);
6244: fnd_message.set_token('PERSON_ID',l_person_id);
6245: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6246: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6247: fnd_message.raise_error;
6248: --
6249: end if;
6250: --

Line 6247: fnd_message.raise_error;

6243: fnd_message.set_token('DATE_CODE',p_date_cd);
6244: fnd_message.set_token('PERSON_ID',l_person_id);
6245: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6246: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6247: fnd_message.raise_error;
6248: --
6249: end if;
6250: --
6251: close c_pay_period_for_date;

Line 6549: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');

6545: fetch c_pay_period into l_pay_period;
6546: if c_pay_period%notfound then
6547: close c_pay_period;
6548: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',170);
6549: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6550: fnd_message.set_token('DATE_CODE',p_date_cd);
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);

Line 6550: fnd_message.set_token('DATE_CODE',p_date_cd);

6546: if c_pay_period%notfound then
6547: close c_pay_period;
6548: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',170);
6549: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6550: fnd_message.set_token('DATE_CODE',p_date_cd);
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;

Line 6551: fnd_message.set_token('PERSON_ID',l_person_id);

6547: close c_pay_period;
6548: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',170);
6549: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6550: fnd_message.set_token('DATE_CODE',p_date_cd);
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: end if;

Line 6552: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

6548: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',170);
6549: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6550: fnd_message.set_token('DATE_CODE',p_date_cd);
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: end if;
6556: p_returned_date := l_pay_period.end_date;

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

6549: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6550: fnd_message.set_token('DATE_CODE',p_date_cd);
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: end if;
6556: p_returned_date := l_pay_period.end_date;
6557: close c_pay_period ;

Line 6554: fnd_message.raise_error;

6550: fnd_message.set_token('DATE_CODE',p_date_cd);
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: end if;
6556: p_returned_date := l_pay_period.end_date;
6557: close c_pay_period ;
6558: --

Line 6590: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');

6586: --
6587: if c_next_pay_period%notfound then
6588: close c_next_pay_period;
6589: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',170);
6590: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6591: fnd_message.set_token('DATE_CODE',p_date_cd);
6592: fnd_message.set_token('PERSON_ID',l_person_id);
6593: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6594: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 6591: fnd_message.set_token('DATE_CODE',p_date_cd);

6587: if c_next_pay_period%notfound then
6588: close c_next_pay_period;
6589: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',170);
6590: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6591: fnd_message.set_token('DATE_CODE',p_date_cd);
6592: fnd_message.set_token('PERSON_ID',l_person_id);
6593: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6594: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6595: fnd_message.raise_error;

Line 6592: fnd_message.set_token('PERSON_ID',l_person_id);

6588: close c_next_pay_period;
6589: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',170);
6590: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6591: fnd_message.set_token('DATE_CODE',p_date_cd);
6592: fnd_message.set_token('PERSON_ID',l_person_id);
6593: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6594: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6595: fnd_message.raise_error;
6596: end if;

Line 6593: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

6589: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',170);
6590: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6591: fnd_message.set_token('DATE_CODE',p_date_cd);
6592: fnd_message.set_token('PERSON_ID',l_person_id);
6593: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6594: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6595: fnd_message.raise_error;
6596: end if;
6597: p_returned_date := l_next_pay_period.start_date;

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

6590: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6591: fnd_message.set_token('DATE_CODE',p_date_cd);
6592: fnd_message.set_token('PERSON_ID',l_person_id);
6593: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6594: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6595: fnd_message.raise_error;
6596: end if;
6597: p_returned_date := l_next_pay_period.start_date;
6598: close c_next_pay_period;

Line 6595: fnd_message.raise_error;

6591: fnd_message.set_token('DATE_CODE',p_date_cd);
6592: fnd_message.set_token('PERSON_ID',l_person_id);
6593: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6594: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6595: fnd_message.raise_error;
6596: end if;
6597: p_returned_date := l_next_pay_period.start_date;
6598: close c_next_pay_period;
6599: --

Line 6664: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');

6660: if g_debug then
6661: hr_utility.set_location(' Hire date ' || l_hire_date, 99 );
6662: end if;
6663: if l_hire_date is null then
6664: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
6665: fnd_message.set_token('DATE_CODE',p_date_cd);
6666: fnd_message.set_token('L_PROC',l_proc);
6667: fnd_message.raise_error;
6668: end if ;

Line 6665: fnd_message.set_token('DATE_CODE',p_date_cd);

6661: hr_utility.set_location(' Hire date ' || l_hire_date, 99 );
6662: end if;
6663: if l_hire_date is null then
6664: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
6665: fnd_message.set_token('DATE_CODE',p_date_cd);
6666: fnd_message.set_token('L_PROC',l_proc);
6667: fnd_message.raise_error;
6668: end if ;
6669: if g_debug then

Line 6666: fnd_message.set_token('L_PROC',l_proc);

6662: end if;
6663: if l_hire_date is null then
6664: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
6665: fnd_message.set_token('DATE_CODE',p_date_cd);
6666: fnd_message.set_token('L_PROC',l_proc);
6667: fnd_message.raise_error;
6668: end if ;
6669: if g_debug then
6670: hr_utility.set_location(' Hire date ' || l_hire_date, 99 );

Line 6667: fnd_message.raise_error;

6663: if l_hire_date is null then
6664: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
6665: fnd_message.set_token('DATE_CODE',p_date_cd);
6666: fnd_message.set_token('L_PROC',l_proc);
6667: fnd_message.raise_error;
6668: end if ;
6669: if g_debug then
6670: hr_utility.set_location(' Hire date ' || l_hire_date, 99 );
6671: end if;

Line 6694: fnd_message.set_name('BEN','FUTURE_DATE_CD_DO_NOT_USE');

6690: 'FDLY','FDQ','FDSY', 'LFSEMES'
6691: ) then
6692:
6693: -- hr_utility.set_location('Future Date Code: '||p_date_cd , 222);
6694: fnd_message.set_name('BEN','FUTURE_DATE_CD_DO_NOT_USE');
6695: fnd_message.set_token('DATE_CODE',p_date_cd);
6696: fnd_message.raise_error;
6697:
6698: elsif p_date_cd in ('FDPPFCDE','FDPPFCDEL') then

Line 6695: fnd_message.set_token('DATE_CODE',p_date_cd);

6691: ) then
6692:
6693: -- hr_utility.set_location('Future Date Code: '||p_date_cd , 222);
6694: fnd_message.set_name('BEN','FUTURE_DATE_CD_DO_NOT_USE');
6695: fnd_message.set_token('DATE_CODE',p_date_cd);
6696: fnd_message.raise_error;
6697:
6698: elsif p_date_cd in ('FDPPFCDE','FDPPFCDEL') then
6699: --

Line 6696: fnd_message.raise_error;

6692:
6693: -- hr_utility.set_location('Future Date Code: '||p_date_cd , 222);
6694: fnd_message.set_name('BEN','FUTURE_DATE_CD_DO_NOT_USE');
6695: fnd_message.set_token('DATE_CODE',p_date_cd);
6696: fnd_message.raise_error;
6697:
6698: elsif p_date_cd in ('FDPPFCDE','FDPPFCDEL') then
6699: --
6700: if g_debug then

Line 6727: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');

6723: if c_pay_period_for_check%notfound then
6724: --
6725: close c_pay_period_for_check;
6726: --
6727: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6728: fnd_message.set_token('DATE_CODE',p_date_cd);
6729: fnd_message.set_token('L_PROC',l_proc);
6730: fnd_message.set_token('PERSON_ID',l_person_id);
6731: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

Line 6728: fnd_message.set_token('DATE_CODE',p_date_cd);

6724: --
6725: close c_pay_period_for_check;
6726: --
6727: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6728: fnd_message.set_token('DATE_CODE',p_date_cd);
6729: fnd_message.set_token('L_PROC',l_proc);
6730: fnd_message.set_token('PERSON_ID',l_person_id);
6731: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6732: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 6729: fnd_message.set_token('L_PROC',l_proc);

6725: close c_pay_period_for_check;
6726: --
6727: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6728: fnd_message.set_token('DATE_CODE',p_date_cd);
6729: fnd_message.set_token('L_PROC',l_proc);
6730: fnd_message.set_token('PERSON_ID',l_person_id);
6731: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6732: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6733: fnd_message.raise_error;

Line 6730: fnd_message.set_token('PERSON_ID',l_person_id);

6726: --
6727: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6728: fnd_message.set_token('DATE_CODE',p_date_cd);
6729: fnd_message.set_token('L_PROC',l_proc);
6730: fnd_message.set_token('PERSON_ID',l_person_id);
6731: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6732: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6733: fnd_message.raise_error;
6734: --

Line 6731: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

6727: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6728: fnd_message.set_token('DATE_CODE',p_date_cd);
6729: fnd_message.set_token('L_PROC',l_proc);
6730: fnd_message.set_token('PERSON_ID',l_person_id);
6731: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6732: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6733: fnd_message.raise_error;
6734: --
6735: end if;

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

6728: fnd_message.set_token('DATE_CODE',p_date_cd);
6729: fnd_message.set_token('L_PROC',l_proc);
6730: fnd_message.set_token('PERSON_ID',l_person_id);
6731: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6732: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6733: fnd_message.raise_error;
6734: --
6735: end if;
6736: else

Line 6733: fnd_message.raise_error;

6729: fnd_message.set_token('L_PROC',l_proc);
6730: fnd_message.set_token('PERSON_ID',l_person_id);
6731: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6732: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6733: fnd_message.raise_error;
6734: --
6735: end if;
6736: else
6737: -- rehire and new hire validation

Line 6781: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');

6777: if c_pay_period_for_check_end %notfound then
6778: --
6779: close c_pay_period_for_check_end ;
6780: --
6781: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6782: fnd_message.set_token('DATE_CODE',p_date_cd);
6783: fnd_message.set_token('L_PROC',l_proc);
6784: fnd_message.set_token('PERSON_ID',l_person_id);
6785: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

Line 6782: fnd_message.set_token('DATE_CODE',p_date_cd);

6778: --
6779: close c_pay_period_for_check_end ;
6780: --
6781: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6782: fnd_message.set_token('DATE_CODE',p_date_cd);
6783: fnd_message.set_token('L_PROC',l_proc);
6784: fnd_message.set_token('PERSON_ID',l_person_id);
6785: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6786: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

Line 6783: fnd_message.set_token('L_PROC',l_proc);

6779: close c_pay_period_for_check_end ;
6780: --
6781: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6782: fnd_message.set_token('DATE_CODE',p_date_cd);
6783: fnd_message.set_token('L_PROC',l_proc);
6784: fnd_message.set_token('PERSON_ID',l_person_id);
6785: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6786: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6787: fnd_message.raise_error;

Line 6784: fnd_message.set_token('PERSON_ID',l_person_id);

6780: --
6781: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6782: fnd_message.set_token('DATE_CODE',p_date_cd);
6783: fnd_message.set_token('L_PROC',l_proc);
6784: fnd_message.set_token('PERSON_ID',l_person_id);
6785: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6786: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6787: fnd_message.raise_error;
6788: --

Line 6785: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

6781: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6782: fnd_message.set_token('DATE_CODE',p_date_cd);
6783: fnd_message.set_token('L_PROC',l_proc);
6784: fnd_message.set_token('PERSON_ID',l_person_id);
6785: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6786: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6787: fnd_message.raise_error;
6788: --
6789: end if;

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

6782: fnd_message.set_token('DATE_CODE',p_date_cd);
6783: fnd_message.set_token('L_PROC',l_proc);
6784: fnd_message.set_token('PERSON_ID',l_person_id);
6785: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6786: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6787: fnd_message.raise_error;
6788: --
6789: end if;
6790: end if;

Line 6787: fnd_message.raise_error;

6783: fnd_message.set_token('L_PROC',l_proc);
6784: fnd_message.set_token('PERSON_ID',l_person_id);
6785: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6786: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6787: fnd_message.raise_error;
6788: --
6789: end if;
6790: end if;
6791: --

Line 6797: fnd_message.set_name('BEN','BEN_91534_BEN_UNKNOWN_DATE_CD');

6793: p_returned_date := l_end_date;
6794: else
6795:
6796: hr_utility.set_location('Unknown Date Code: '||p_date_cd , 222);
6797: fnd_message.set_name('BEN','BEN_91534_BEN_UNKNOWN_DATE_CD');
6798: fnd_message.set_token('DATE_CODE',p_date_cd);
6799: fnd_message.set_token('L_PROC',l_proc);
6800: fnd_message.raise_error;
6801:

Line 6798: fnd_message.set_token('DATE_CODE',p_date_cd);

6794: else
6795:
6796: hr_utility.set_location('Unknown Date Code: '||p_date_cd , 222);
6797: fnd_message.set_name('BEN','BEN_91534_BEN_UNKNOWN_DATE_CD');
6798: fnd_message.set_token('DATE_CODE',p_date_cd);
6799: fnd_message.set_token('L_PROC',l_proc);
6800: fnd_message.raise_error;
6801:
6802: end if;

Line 6799: fnd_message.set_token('L_PROC',l_proc);

6795:
6796: hr_utility.set_location('Unknown Date Code: '||p_date_cd , 222);
6797: fnd_message.set_name('BEN','BEN_91534_BEN_UNKNOWN_DATE_CD');
6798: fnd_message.set_token('DATE_CODE',p_date_cd);
6799: fnd_message.set_token('L_PROC',l_proc);
6800: fnd_message.raise_error;
6801:
6802: end if;
6803: --

Line 6800: fnd_message.raise_error;

6796: hr_utility.set_location('Unknown Date Code: '||p_date_cd , 222);
6797: fnd_message.set_name('BEN','BEN_91534_BEN_UNKNOWN_DATE_CD');
6798: fnd_message.set_token('DATE_CODE',p_date_cd);
6799: fnd_message.set_token('L_PROC',l_proc);
6800: fnd_message.raise_error;
6801:
6802: end if;
6803: --
6804: if g_debug then

Line 7634: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');

7630: hr_utility.set_location('l_oipl_id '||l_oipl_id,19);
7631: end if;
7632: if c_epe_info%notfound then
7633: close c_epe_info;
7634: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
7635: --fnd_message.set_token('ID', to_char(p_business_group_id));
7636: fnd_message.set_token('ID', to_char(p_elig_per_elctbl_chc_id));
7637: fnd_message.set_token('PROC',l_proc);
7638: fnd_message.raise_error;

Line 7635: --fnd_message.set_token('ID', to_char(p_business_group_id));

7631: end if;
7632: if c_epe_info%notfound then
7633: close c_epe_info;
7634: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
7635: --fnd_message.set_token('ID', to_char(p_business_group_id));
7636: fnd_message.set_token('ID', to_char(p_elig_per_elctbl_chc_id));
7637: fnd_message.set_token('PROC',l_proc);
7638: fnd_message.raise_error;
7639: end if;

Line 7636: fnd_message.set_token('ID', to_char(p_elig_per_elctbl_chc_id));

7632: if c_epe_info%notfound then
7633: close c_epe_info;
7634: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
7635: --fnd_message.set_token('ID', to_char(p_business_group_id));
7636: fnd_message.set_token('ID', to_char(p_elig_per_elctbl_chc_id));
7637: fnd_message.set_token('PROC',l_proc);
7638: fnd_message.raise_error;
7639: end if;
7640: if g_debug then

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

7633: close c_epe_info;
7634: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
7635: --fnd_message.set_token('ID', to_char(p_business_group_id));
7636: fnd_message.set_token('ID', to_char(p_elig_per_elctbl_chc_id));
7637: fnd_message.set_token('PROC',l_proc);
7638: fnd_message.raise_error;
7639: end if;
7640: if g_debug then
7641: hr_utility.set_location(l_proc , 40);

Line 7638: fnd_message.raise_error;

7634: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
7635: --fnd_message.set_token('ID', to_char(p_business_group_id));
7636: fnd_message.set_token('ID', to_char(p_elig_per_elctbl_chc_id));
7637: fnd_message.set_token('PROC',l_proc);
7638: fnd_message.raise_error;
7639: end if;
7640: if g_debug then
7641: hr_utility.set_location(l_proc , 40);
7642: end if;

Line 8248: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');

8244: l_rt_strt_dt_cd is null then
8245: if g_debug then
8246: hr_utility.set_location('BEN_91455_RT_STRT_DT_NOT_FOUND' , 540);
8247: end if;
8248: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
8249: fnd_message.set_token('PLAN_ID',l_pln_name);
8250: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8251: fnd_message.set_token('PGM_ID',l_pgm_name);
8252: fnd_message.set_token('OIPL_ID',l_opt_name);

Line 8249: fnd_message.set_token('PLAN_ID',l_pln_name);

8245: if g_debug then
8246: hr_utility.set_location('BEN_91455_RT_STRT_DT_NOT_FOUND' , 540);
8247: end if;
8248: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
8249: fnd_message.set_token('PLAN_ID',l_pln_name);
8250: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8251: fnd_message.set_token('PGM_ID',l_pgm_name);
8252: fnd_message.set_token('OIPL_ID',l_opt_name);
8253: fnd_message.raise_error;

Line 8250: fnd_message.set_token('PERSON_ID',to_char(l_person_id));

8246: hr_utility.set_location('BEN_91455_RT_STRT_DT_NOT_FOUND' , 540);
8247: end if;
8248: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
8249: fnd_message.set_token('PLAN_ID',l_pln_name);
8250: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8251: fnd_message.set_token('PGM_ID',l_pgm_name);
8252: fnd_message.set_token('OIPL_ID',l_opt_name);
8253: fnd_message.raise_error;
8254: elsif p_which_dates_cd in ('R','B') and

Line 8251: fnd_message.set_token('PGM_ID',l_pgm_name);

8247: end if;
8248: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
8249: fnd_message.set_token('PLAN_ID',l_pln_name);
8250: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8251: fnd_message.set_token('PGM_ID',l_pgm_name);
8252: fnd_message.set_token('OIPL_ID',l_opt_name);
8253: fnd_message.raise_error;
8254: elsif p_which_dates_cd in ('R','B') and
8255: l_rt_end_dt_cd is null then

Line 8252: fnd_message.set_token('OIPL_ID',l_opt_name);

8248: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
8249: fnd_message.set_token('PLAN_ID',l_pln_name);
8250: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8251: fnd_message.set_token('PGM_ID',l_pgm_name);
8252: fnd_message.set_token('OIPL_ID',l_opt_name);
8253: fnd_message.raise_error;
8254: elsif p_which_dates_cd in ('R','B') and
8255: l_rt_end_dt_cd is null then
8256: if g_debug then

Line 8253: fnd_message.raise_error;

8249: fnd_message.set_token('PLAN_ID',l_pln_name);
8250: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8251: fnd_message.set_token('PGM_ID',l_pgm_name);
8252: fnd_message.set_token('OIPL_ID',l_opt_name);
8253: fnd_message.raise_error;
8254: elsif p_which_dates_cd in ('R','B') and
8255: l_rt_end_dt_cd is null then
8256: if g_debug then
8257: hr_utility.set_location('BEN_91703_NOT_DET_RATE_END_DT' , 550);

Line 8259: fnd_message.set_name('BEN','BEN_91703_NOT_DET_RATE_END_DT');

8255: l_rt_end_dt_cd is null then
8256: if g_debug then
8257: hr_utility.set_location('BEN_91703_NOT_DET_RATE_END_DT' , 550);
8258: end if;
8259: fnd_message.set_name('BEN','BEN_91703_NOT_DET_RATE_END_DT');
8260: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8261: fnd_message.set_token('PGM_ID',l_pgm_name);
8262: fnd_message.set_token('PL_ID',l_pln_name);
8263: fnd_message.set_token('OIPL_ID',l_opt_name);

Line 8260: fnd_message.set_token('PERSON_ID',to_char(l_person_id));

8256: if g_debug then
8257: hr_utility.set_location('BEN_91703_NOT_DET_RATE_END_DT' , 550);
8258: end if;
8259: fnd_message.set_name('BEN','BEN_91703_NOT_DET_RATE_END_DT');
8260: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8261: fnd_message.set_token('PGM_ID',l_pgm_name);
8262: fnd_message.set_token('PL_ID',l_pln_name);
8263: fnd_message.set_token('OIPL_ID',l_opt_name);
8264: fnd_message.raise_error;

Line 8261: fnd_message.set_token('PGM_ID',l_pgm_name);

8257: hr_utility.set_location('BEN_91703_NOT_DET_RATE_END_DT' , 550);
8258: end if;
8259: fnd_message.set_name('BEN','BEN_91703_NOT_DET_RATE_END_DT');
8260: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8261: fnd_message.set_token('PGM_ID',l_pgm_name);
8262: fnd_message.set_token('PL_ID',l_pln_name);
8263: fnd_message.set_token('OIPL_ID',l_opt_name);
8264: fnd_message.raise_error;
8265: elsif p_which_dates_cd in ('C','B') and

Line 8262: fnd_message.set_token('PL_ID',l_pln_name);

8258: end if;
8259: fnd_message.set_name('BEN','BEN_91703_NOT_DET_RATE_END_DT');
8260: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8261: fnd_message.set_token('PGM_ID',l_pgm_name);
8262: fnd_message.set_token('PL_ID',l_pln_name);
8263: fnd_message.set_token('OIPL_ID',l_opt_name);
8264: fnd_message.raise_error;
8265: elsif p_which_dates_cd in ('C','B') and
8266: l_enrt_cvg_strt_dt_cd is null then

Line 8263: fnd_message.set_token('OIPL_ID',l_opt_name);

8259: fnd_message.set_name('BEN','BEN_91703_NOT_DET_RATE_END_DT');
8260: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8261: fnd_message.set_token('PGM_ID',l_pgm_name);
8262: fnd_message.set_token('PL_ID',l_pln_name);
8263: fnd_message.set_token('OIPL_ID',l_opt_name);
8264: fnd_message.raise_error;
8265: elsif p_which_dates_cd in ('C','B') and
8266: l_enrt_cvg_strt_dt_cd is null then
8267: if g_debug then

Line 8264: fnd_message.raise_error;

8260: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8261: fnd_message.set_token('PGM_ID',l_pgm_name);
8262: fnd_message.set_token('PL_ID',l_pln_name);
8263: fnd_message.set_token('OIPL_ID',l_opt_name);
8264: fnd_message.raise_error;
8265: elsif p_which_dates_cd in ('C','B') and
8266: l_enrt_cvg_strt_dt_cd is null then
8267: if g_debug then
8268: hr_utility.set_location('BEN_91453_CVG_STRT_DT_NOT_FOUN' , 560);

Line 8270: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');

8266: l_enrt_cvg_strt_dt_cd is null then
8267: if g_debug then
8268: hr_utility.set_location('BEN_91453_CVG_STRT_DT_NOT_FOUN' , 560);
8269: end if;
8270: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
8271: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8272: fnd_message.set_token('PGM_ID',l_pgm_name);
8273: fnd_message.set_token('PLAN_ID',l_pln_name);
8274: fnd_message.set_token('OIPL_ID',l_opt_name);

Line 8271: fnd_message.set_token('PERSON_ID',to_char(l_person_id));

8267: if g_debug then
8268: hr_utility.set_location('BEN_91453_CVG_STRT_DT_NOT_FOUN' , 560);
8269: end if;
8270: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
8271: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8272: fnd_message.set_token('PGM_ID',l_pgm_name);
8273: fnd_message.set_token('PLAN_ID',l_pln_name);
8274: fnd_message.set_token('OIPL_ID',l_opt_name);
8275: fnd_message.raise_error;

Line 8272: fnd_message.set_token('PGM_ID',l_pgm_name);

8268: hr_utility.set_location('BEN_91453_CVG_STRT_DT_NOT_FOUN' , 560);
8269: end if;
8270: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
8271: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8272: fnd_message.set_token('PGM_ID',l_pgm_name);
8273: fnd_message.set_token('PLAN_ID',l_pln_name);
8274: fnd_message.set_token('OIPL_ID',l_opt_name);
8275: fnd_message.raise_error;
8276: elsif p_which_dates_cd in ('C','B') and

Line 8273: fnd_message.set_token('PLAN_ID',l_pln_name);

8269: end if;
8270: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
8271: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8272: fnd_message.set_token('PGM_ID',l_pgm_name);
8273: fnd_message.set_token('PLAN_ID',l_pln_name);
8274: fnd_message.set_token('OIPL_ID',l_opt_name);
8275: fnd_message.raise_error;
8276: elsif p_which_dates_cd in ('C','B') and
8277: l_enrt_cvg_end_dt_cd is null then

Line 8274: fnd_message.set_token('OIPL_ID',l_opt_name);

8270: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
8271: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8272: fnd_message.set_token('PGM_ID',l_pgm_name);
8273: fnd_message.set_token('PLAN_ID',l_pln_name);
8274: fnd_message.set_token('OIPL_ID',l_opt_name);
8275: fnd_message.raise_error;
8276: elsif p_which_dates_cd in ('C','B') and
8277: l_enrt_cvg_end_dt_cd is null then
8278: if g_debug then

Line 8275: fnd_message.raise_error;

8271: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8272: fnd_message.set_token('PGM_ID',l_pgm_name);
8273: fnd_message.set_token('PLAN_ID',l_pln_name);
8274: fnd_message.set_token('OIPL_ID',l_opt_name);
8275: fnd_message.raise_error;
8276: elsif p_which_dates_cd in ('C','B') and
8277: l_enrt_cvg_end_dt_cd is null then
8278: if g_debug then
8279: hr_utility.set_location(l_proc , 570);

Line 8281: fnd_message.set_name('BEN','BEN_91702_NOT_DET_CVG_END_DT');

8277: l_enrt_cvg_end_dt_cd is null then
8278: if g_debug then
8279: hr_utility.set_location(l_proc , 570);
8280: end if;
8281: fnd_message.set_name('BEN','BEN_91702_NOT_DET_CVG_END_DT');
8282: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8283: fnd_message.set_token('PGM_ID',l_pgm_name);
8284: fnd_message.set_token('PL_ID',l_pln_name);
8285: fnd_message.set_token('OIPL_ID',l_opt_name);

Line 8282: fnd_message.set_token('PERSON_ID',to_char(l_person_id));

8278: if g_debug then
8279: hr_utility.set_location(l_proc , 570);
8280: end if;
8281: fnd_message.set_name('BEN','BEN_91702_NOT_DET_CVG_END_DT');
8282: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8283: fnd_message.set_token('PGM_ID',l_pgm_name);
8284: fnd_message.set_token('PL_ID',l_pln_name);
8285: fnd_message.set_token('OIPL_ID',l_opt_name);
8286: fnd_message.raise_error;

Line 8283: fnd_message.set_token('PGM_ID',l_pgm_name);

8279: hr_utility.set_location(l_proc , 570);
8280: end if;
8281: fnd_message.set_name('BEN','BEN_91702_NOT_DET_CVG_END_DT');
8282: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8283: fnd_message.set_token('PGM_ID',l_pgm_name);
8284: fnd_message.set_token('PL_ID',l_pln_name);
8285: fnd_message.set_token('OIPL_ID',l_opt_name);
8286: fnd_message.raise_error;
8287: end if;

Line 8284: fnd_message.set_token('PL_ID',l_pln_name);

8280: end if;
8281: fnd_message.set_name('BEN','BEN_91702_NOT_DET_CVG_END_DT');
8282: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8283: fnd_message.set_token('PGM_ID',l_pgm_name);
8284: fnd_message.set_token('PL_ID',l_pln_name);
8285: fnd_message.set_token('OIPL_ID',l_opt_name);
8286: fnd_message.raise_error;
8287: end if;
8288: --

Line 8285: fnd_message.set_token('OIPL_ID',l_opt_name);

8281: fnd_message.set_name('BEN','BEN_91702_NOT_DET_CVG_END_DT');
8282: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8283: fnd_message.set_token('PGM_ID',l_pgm_name);
8284: fnd_message.set_token('PL_ID',l_pln_name);
8285: fnd_message.set_token('OIPL_ID',l_opt_name);
8286: fnd_message.raise_error;
8287: end if;
8288: --
8289: end if;

Line 8286: fnd_message.raise_error;

8282: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8283: fnd_message.set_token('PGM_ID',l_pgm_name);
8284: fnd_message.set_token('PL_ID',l_pln_name);
8285: fnd_message.set_token('OIPL_ID',l_opt_name);
8286: fnd_message.raise_error;
8287: end if;
8288: --
8289: end if;
8290: --

Line 8592: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');

8588: l_rt_strt_dt is null then
8589: if g_debug then
8590: hr_utility.set_location('BEN_91455_RT_STRT_DT_NOT_FOUND',37);
8591: end if;
8592: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
8593: fnd_message.set_token('PLAN_ID',l_pln_name);
8594: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8595: fnd_message.set_token('PGM_ID',l_pgm_name);
8596: fnd_message.set_token('OIPL_ID',l_opt_name);

Line 8593: fnd_message.set_token('PLAN_ID',l_pln_name);

8589: if g_debug then
8590: hr_utility.set_location('BEN_91455_RT_STRT_DT_NOT_FOUND',37);
8591: end if;
8592: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
8593: fnd_message.set_token('PLAN_ID',l_pln_name);
8594: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8595: fnd_message.set_token('PGM_ID',l_pgm_name);
8596: fnd_message.set_token('OIPL_ID',l_opt_name);
8597: fnd_message.raise_error;

Line 8594: fnd_message.set_token('PERSON_ID',to_char(l_person_id));

8590: hr_utility.set_location('BEN_91455_RT_STRT_DT_NOT_FOUND',37);
8591: end if;
8592: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
8593: fnd_message.set_token('PLAN_ID',l_pln_name);
8594: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8595: fnd_message.set_token('PGM_ID',l_pgm_name);
8596: fnd_message.set_token('OIPL_ID',l_opt_name);
8597: fnd_message.raise_error;
8598: elsif p_which_dates_cd in ('R','B') and

Line 8595: fnd_message.set_token('PGM_ID',l_pgm_name);

8591: end if;
8592: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
8593: fnd_message.set_token('PLAN_ID',l_pln_name);
8594: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8595: fnd_message.set_token('PGM_ID',l_pgm_name);
8596: fnd_message.set_token('OIPL_ID',l_opt_name);
8597: fnd_message.raise_error;
8598: elsif p_which_dates_cd in ('R','B') and
8599: l_rt_end_dt is null then

Line 8596: fnd_message.set_token('OIPL_ID',l_opt_name);

8592: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
8593: fnd_message.set_token('PLAN_ID',l_pln_name);
8594: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8595: fnd_message.set_token('PGM_ID',l_pgm_name);
8596: fnd_message.set_token('OIPL_ID',l_opt_name);
8597: fnd_message.raise_error;
8598: elsif p_which_dates_cd in ('R','B') and
8599: l_rt_end_dt is null then
8600: if g_debug then

Line 8597: fnd_message.raise_error;

8593: fnd_message.set_token('PLAN_ID',l_pln_name);
8594: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8595: fnd_message.set_token('PGM_ID',l_pgm_name);
8596: fnd_message.set_token('OIPL_ID',l_opt_name);
8597: fnd_message.raise_error;
8598: elsif p_which_dates_cd in ('R','B') and
8599: l_rt_end_dt is null then
8600: if g_debug then
8601: hr_utility.set_location('BEN_91703_NOT_DET_RATE_END_DT',37);

Line 8603: fnd_message.set_name('BEN','BEN_91703_NOT_DET_RATE_END_DT');

8599: l_rt_end_dt is null then
8600: if g_debug then
8601: hr_utility.set_location('BEN_91703_NOT_DET_RATE_END_DT',37);
8602: end if;
8603: fnd_message.set_name('BEN','BEN_91703_NOT_DET_RATE_END_DT');
8604: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8605: fnd_message.set_token('PGM_ID',l_pgm_name);
8606: fnd_message.set_token('PL_ID',l_pln_name);
8607: fnd_message.set_token('OIPL_ID',l_opt_name);

Line 8604: fnd_message.set_token('PERSON_ID',to_char(l_person_id));

8600: if g_debug then
8601: hr_utility.set_location('BEN_91703_NOT_DET_RATE_END_DT',37);
8602: end if;
8603: fnd_message.set_name('BEN','BEN_91703_NOT_DET_RATE_END_DT');
8604: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8605: fnd_message.set_token('PGM_ID',l_pgm_name);
8606: fnd_message.set_token('PL_ID',l_pln_name);
8607: fnd_message.set_token('OIPL_ID',l_opt_name);
8608: fnd_message.raise_error;

Line 8605: fnd_message.set_token('PGM_ID',l_pgm_name);

8601: hr_utility.set_location('BEN_91703_NOT_DET_RATE_END_DT',37);
8602: end if;
8603: fnd_message.set_name('BEN','BEN_91703_NOT_DET_RATE_END_DT');
8604: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8605: fnd_message.set_token('PGM_ID',l_pgm_name);
8606: fnd_message.set_token('PL_ID',l_pln_name);
8607: fnd_message.set_token('OIPL_ID',l_opt_name);
8608: fnd_message.raise_error;
8609: elsif p_which_dates_cd in ('C','B') and

Line 8606: fnd_message.set_token('PL_ID',l_pln_name);

8602: end if;
8603: fnd_message.set_name('BEN','BEN_91703_NOT_DET_RATE_END_DT');
8604: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8605: fnd_message.set_token('PGM_ID',l_pgm_name);
8606: fnd_message.set_token('PL_ID',l_pln_name);
8607: fnd_message.set_token('OIPL_ID',l_opt_name);
8608: fnd_message.raise_error;
8609: elsif p_which_dates_cd in ('C','B') and
8610: l_enrt_cvg_strt_dt is null then

Line 8607: fnd_message.set_token('OIPL_ID',l_opt_name);

8603: fnd_message.set_name('BEN','BEN_91703_NOT_DET_RATE_END_DT');
8604: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8605: fnd_message.set_token('PGM_ID',l_pgm_name);
8606: fnd_message.set_token('PL_ID',l_pln_name);
8607: fnd_message.set_token('OIPL_ID',l_opt_name);
8608: fnd_message.raise_error;
8609: elsif p_which_dates_cd in ('C','B') and
8610: l_enrt_cvg_strt_dt is null then
8611: if g_debug then

Line 8608: fnd_message.raise_error;

8604: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8605: fnd_message.set_token('PGM_ID',l_pgm_name);
8606: fnd_message.set_token('PL_ID',l_pln_name);
8607: fnd_message.set_token('OIPL_ID',l_opt_name);
8608: fnd_message.raise_error;
8609: elsif p_which_dates_cd in ('C','B') and
8610: l_enrt_cvg_strt_dt is null then
8611: if g_debug then
8612: hr_utility.set_location('BEN_91453_CVG_STRT_DT_NOT_FOUN',37);

Line 8614: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');

8610: l_enrt_cvg_strt_dt is null then
8611: if g_debug then
8612: hr_utility.set_location('BEN_91453_CVG_STRT_DT_NOT_FOUN',37);
8613: end if;
8614: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
8615: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8616: fnd_message.set_token('PGM_ID',l_pgm_name);
8617: fnd_message.set_token('PLAN_ID',l_pln_name);
8618: fnd_message.set_token('OIPL_ID',l_opt_name);

Line 8615: fnd_message.set_token('PERSON_ID',to_char(l_person_id));

8611: if g_debug then
8612: hr_utility.set_location('BEN_91453_CVG_STRT_DT_NOT_FOUN',37);
8613: end if;
8614: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
8615: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8616: fnd_message.set_token('PGM_ID',l_pgm_name);
8617: fnd_message.set_token('PLAN_ID',l_pln_name);
8618: fnd_message.set_token('OIPL_ID',l_opt_name);
8619: fnd_message.raise_error;

Line 8616: fnd_message.set_token('PGM_ID',l_pgm_name);

8612: hr_utility.set_location('BEN_91453_CVG_STRT_DT_NOT_FOUN',37);
8613: end if;
8614: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
8615: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8616: fnd_message.set_token('PGM_ID',l_pgm_name);
8617: fnd_message.set_token('PLAN_ID',l_pln_name);
8618: fnd_message.set_token('OIPL_ID',l_opt_name);
8619: fnd_message.raise_error;
8620: elsif p_which_dates_cd in ('C','B') and

Line 8617: fnd_message.set_token('PLAN_ID',l_pln_name);

8613: end if;
8614: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
8615: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8616: fnd_message.set_token('PGM_ID',l_pgm_name);
8617: fnd_message.set_token('PLAN_ID',l_pln_name);
8618: fnd_message.set_token('OIPL_ID',l_opt_name);
8619: fnd_message.raise_error;
8620: elsif p_which_dates_cd in ('C','B') and
8621: l_enrt_cvg_end_dt is null then

Line 8618: fnd_message.set_token('OIPL_ID',l_opt_name);

8614: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
8615: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8616: fnd_message.set_token('PGM_ID',l_pgm_name);
8617: fnd_message.set_token('PLAN_ID',l_pln_name);
8618: fnd_message.set_token('OIPL_ID',l_opt_name);
8619: fnd_message.raise_error;
8620: elsif p_which_dates_cd in ('C','B') and
8621: l_enrt_cvg_end_dt is null then
8622: if g_debug then

Line 8619: fnd_message.raise_error;

8615: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8616: fnd_message.set_token('PGM_ID',l_pgm_name);
8617: fnd_message.set_token('PLAN_ID',l_pln_name);
8618: fnd_message.set_token('OIPL_ID',l_opt_name);
8619: fnd_message.raise_error;
8620: elsif p_which_dates_cd in ('C','B') and
8621: l_enrt_cvg_end_dt is null then
8622: if g_debug then
8623: hr_utility.set_location('BEN_91702_NOT_DET_CVG_END_DT',37);

Line 8625: fnd_message.set_name('BEN','BEN_91702_NOT_DET_CVG_END_DT');

8621: l_enrt_cvg_end_dt is null then
8622: if g_debug then
8623: hr_utility.set_location('BEN_91702_NOT_DET_CVG_END_DT',37);
8624: end if;
8625: fnd_message.set_name('BEN','BEN_91702_NOT_DET_CVG_END_DT');
8626: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8627: fnd_message.set_token('PGM_ID',l_pgm_name);
8628: fnd_message.set_token('PL_ID',l_pln_name);
8629: fnd_message.set_token('OIPL_ID',l_opt_name);

Line 8626: fnd_message.set_token('PERSON_ID',to_char(l_person_id));

8622: if g_debug then
8623: hr_utility.set_location('BEN_91702_NOT_DET_CVG_END_DT',37);
8624: end if;
8625: fnd_message.set_name('BEN','BEN_91702_NOT_DET_CVG_END_DT');
8626: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8627: fnd_message.set_token('PGM_ID',l_pgm_name);
8628: fnd_message.set_token('PL_ID',l_pln_name);
8629: fnd_message.set_token('OIPL_ID',l_opt_name);
8630: fnd_message.raise_error;

Line 8627: fnd_message.set_token('PGM_ID',l_pgm_name);

8623: hr_utility.set_location('BEN_91702_NOT_DET_CVG_END_DT',37);
8624: end if;
8625: fnd_message.set_name('BEN','BEN_91702_NOT_DET_CVG_END_DT');
8626: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8627: fnd_message.set_token('PGM_ID',l_pgm_name);
8628: fnd_message.set_token('PL_ID',l_pln_name);
8629: fnd_message.set_token('OIPL_ID',l_opt_name);
8630: fnd_message.raise_error;
8631: end if;

Line 8628: fnd_message.set_token('PL_ID',l_pln_name);

8624: end if;
8625: fnd_message.set_name('BEN','BEN_91702_NOT_DET_CVG_END_DT');
8626: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8627: fnd_message.set_token('PGM_ID',l_pgm_name);
8628: fnd_message.set_token('PL_ID',l_pln_name);
8629: fnd_message.set_token('OIPL_ID',l_opt_name);
8630: fnd_message.raise_error;
8631: end if;
8632:

Line 8629: fnd_message.set_token('OIPL_ID',l_opt_name);

8625: fnd_message.set_name('BEN','BEN_91702_NOT_DET_CVG_END_DT');
8626: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8627: fnd_message.set_token('PGM_ID',l_pgm_name);
8628: fnd_message.set_token('PL_ID',l_pln_name);
8629: fnd_message.set_token('OIPL_ID',l_opt_name);
8630: fnd_message.raise_error;
8631: end if;
8632:
8633: end if;

Line 8630: fnd_message.raise_error;

8626: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8627: fnd_message.set_token('PGM_ID',l_pgm_name);
8628: fnd_message.set_token('PL_ID',l_pln_name);
8629: fnd_message.set_token('OIPL_ID',l_opt_name);
8630: fnd_message.raise_error;
8631: end if;
8632:
8633: end if;
8634: --