DBA Data[Home] [Help]

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));
243: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_sot));
244: fnd_message.set_token('PARMC','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
245: benutils.write(p_text=>fnd_message.get);

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

238:
239: if l_formula_type_id in (-27,-28,-29,-30,-504,-503,-66,-67) then
240: if p_computed_Date <= hr_api.g_sot then
241: fnd_message.set_name('BEN','BEN_94441_ENROL_ST_DT_RANGE');
242: fnd_message.set_token('PARMA',l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date));
243: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_sot));
244: fnd_message.set_token('PARMC','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
245: benutils.write(p_text=>fnd_message.get);
246: ben_warnings.load_warning

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

239: if l_formula_type_id in (-27,-28,-29,-30,-504,-503,-66,-67) then
240: if p_computed_Date <= hr_api.g_sot then
241: fnd_message.set_name('BEN','BEN_94441_ENROL_ST_DT_RANGE');
242: fnd_message.set_token('PARMA',l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date));
243: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_sot));
244: fnd_message.set_token('PARMC','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
245: benutils.write(p_text=>fnd_message.get);
246: ben_warnings.load_warning
247: (p_application_short_name => 'BEN'

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));
243: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_sot));
244: fnd_message.set_token('PARMC','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
245: benutils.write(p_text=>fnd_message.get);
246: ben_warnings.load_warning
247: (p_application_short_name => 'BEN'
248: ,p_message_name => l_message_name1

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));
243: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_sot));
244: fnd_message.set_token('PARMC','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
245: benutils.write(p_text=>fnd_message.get);
246: ben_warnings.load_warning
247: (p_application_short_name => 'BEN'
248: ,p_message_name => l_message_name1
249: ,p_parma => l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date)

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));
257: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_eot));
258: fnd_message.set_token('PARMC','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
259: benutils.write(p_text=>fnd_message.get);

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

252: ,p_person_id => p_person_id
253: );
254: elsif p_computed_Date >= hr_api.g_eot then
255: fnd_message.set_name('BEN','BEN_94464_ENROL_ED_DT_RANGE');
256: fnd_message.set_token('PARMA',l_formula_type_name|| ' ' || fnd_date.date_to_displaydate(p_computed_Date));
257: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_eot));
258: fnd_message.set_token('PARMC','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
259: benutils.write(p_text=>fnd_message.get);
260: ben_warnings.load_warning

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

253: );
254: elsif p_computed_Date >= hr_api.g_eot then
255: fnd_message.set_name('BEN','BEN_94464_ENROL_ED_DT_RANGE');
256: fnd_message.set_token('PARMA',l_formula_type_name|| ' ' || fnd_date.date_to_displaydate(p_computed_Date));
257: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_eot));
258: fnd_message.set_token('PARMC','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
259: benutils.write(p_text=>fnd_message.get);
260: ben_warnings.load_warning
261: (p_application_short_name => 'BEN'

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));
257: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_eot));
258: fnd_message.set_token('PARMC','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
259: benutils.write(p_text=>fnd_message.get);
260: ben_warnings.load_warning
261: (p_application_short_name => 'BEN'
262: ,p_message_name => l_message_name2

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));
257: fnd_message.set_token('PARMB',fnd_date.date_to_displaydate(hr_api.g_eot));
258: fnd_message.set_token('PARMC','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
259: benutils.write(p_text=>fnd_message.get);
260: ben_warnings.load_warning
261: (p_application_short_name => 'BEN'
262: ,p_message_name => l_message_name2
263: ,p_parma => l_formula_type_name|| ' ' || fnd_date.date_to_displaydate(p_computed_Date)

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));
273: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name);
274: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
275: benutils.write(p_text=>fnd_message.get);

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

268:
269: elsif l_formula_type_id in (-29,-66,-67) then
270: if p_computed_Date < p_lf_evt_ocrd_dt then
271: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');
272: fnd_message.set_token('PARMA',l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date));
273: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name);
274: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
275: benutils.write(p_text=>fnd_message.get);
276: ben_warnings.load_warning

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));
273: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name);
274: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
275: benutils.write(p_text=>fnd_message.get);
276: ben_warnings.load_warning
277: (p_application_short_name => 'BEN'

Line 274: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));

270: if p_computed_Date < p_lf_evt_ocrd_dt then
271: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');
272: fnd_message.set_token('PARMA',l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date));
273: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name);
274: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
275: benutils.write(p_text=>fnd_message.get);
276: ben_warnings.load_warning
277: (p_application_short_name => 'BEN'
278: ,p_message_name => l_message_name3

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));
273: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name);
274: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
275: benutils.write(p_text=>fnd_message.get);
276: ben_warnings.load_warning
277: (p_application_short_name => 'BEN'
278: ,p_message_name => l_message_name3
279: ,p_parma => l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date)

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));
292: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name);
293: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
294:

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

287:
288: elsif l_formula_type_id in (-27,-28) then
289: if p_computed_Date < p_lf_evt_ocrd_dt then
290: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');
291: fnd_message.set_token('PARMA',l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date));
292: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name);
293: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
294:
295: g_dep_rec.text := fnd_message.get;

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));
292: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name);
293: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
294:
295: g_dep_rec.text := fnd_message.get;
296: g_dep_rec.rep_typ_cd := 'WARNING';

Line 293: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));

289: if p_computed_Date < p_lf_evt_ocrd_dt then
290: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');
291: fnd_message.set_token('PARMA',l_formula_type_name || ' ' ||fnd_date.date_to_displaydate(p_computed_Date));
292: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name);
293: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
294:
295: g_dep_rec.text := fnd_message.get;
296: g_dep_rec.rep_typ_cd := 'WARNING';
297: g_dep_rec.error_message_code :='BEN_93964_ENRO_DT_LT_LE_OCD_DT';

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));
292: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name);
293: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
294:
295: g_dep_rec.text := fnd_message.get;
296: g_dep_rec.rep_typ_cd := 'WARNING';
297: g_dep_rec.error_message_code :='BEN_93964_ENRO_DT_LT_LE_OCD_DT';
298: g_dep_rec.national_identifier :=l_national_identifier;
299: g_dep_rec.person_id :=p_person_id;

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));
322: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
323: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
324:

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

317: --Bug 5076010
318: elsif l_formula_type_id = -30 then
319: if p_computed_Date < p_lf_evt_ocrd_dt then
320: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');
321: fnd_message.set_token('PARMA',substr(l_formula_type_name,1,10) ||' '||'Coverage End Date'|| ' ' ||fnd_date.date_to_displaydate(p_computed_Date));
322: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
323: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
324:
325: benutils.write(p_text=>fnd_message.get);

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));
322: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
323: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
324:
325: benutils.write(p_text=>fnd_message.get);
326: ben_warnings.load_warning

Line 323: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));

319: if p_computed_Date < p_lf_evt_ocrd_dt then
320: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');
321: fnd_message.set_token('PARMA',substr(l_formula_type_name,1,10) ||' '||'Coverage End Date'|| ' ' ||fnd_date.date_to_displaydate(p_computed_Date));
322: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
323: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
324:
325: benutils.write(p_text=>fnd_message.get);
326: ben_warnings.load_warning
327: (p_application_short_name => 'BEN'

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));
322: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
323: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
324:
325: benutils.write(p_text=>fnd_message.get);
326: ben_warnings.load_warning
327: (p_application_short_name => 'BEN'
328: ,p_message_name => l_message_name3
329: ,p_parma => substr(l_formula_type_name,1,10) ||' '||'Coverage End Date'|| ' ' ||fnd_date.date_to_displaydate(p_computed_Date)

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));
344: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
345: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
346:

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

339: fetch c_mode into l_dummy;
340: if c_mode%found then
341: if p_computed_Date < p_lf_evt_ocrd_dt then
342: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');
343: fnd_message.set_token('PARMA',l_formula_type_name|| ' ' ||fnd_date.date_to_displaydate(p_computed_Date));
344: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
345: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
346:
347: benutils.write(p_text=>fnd_message.get);

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));
344: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
345: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
346:
347: benutils.write(p_text=>fnd_message.get);
348: ben_warnings.load_warning

Line 345: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));

341: if p_computed_Date < p_lf_evt_ocrd_dt then
342: fnd_message.set_name('BEN','BEN_93964_ENRO_DT_LT_LE_OCD_DT');
343: fnd_message.set_token('PARMA',l_formula_type_name|| ' ' ||fnd_date.date_to_displaydate(p_computed_Date));
344: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
345: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
346:
347: benutils.write(p_text=>fnd_message.get);
348: ben_warnings.load_warning
349: (p_application_short_name => 'BEN'

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));
344: fnd_message.set_token('PARMB','Program:'||' '|| l_pgm_name ||' '||'-'||' '||'Plan:'||' '|| l_pl_name ||' '||'-'||' '||'Option:'||' '|| l_opt_name );
345: fnd_message.set_token('PARMC',fnd_date.date_to_displaydate(p_lf_evt_ocrd_dt));
346:
347: benutils.write(p_text=>fnd_message.get);
348: ben_warnings.load_warning
349: (p_application_short_name => 'BEN'
350: ,p_message_name => l_message_name3
351: ,p_parma => l_formula_type_name|| ' ' ||fnd_date.date_to_displaydate(p_computed_Date)

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

1162: close c_per_elig_elctbl_chc;
1163: if g_debug then
1164: hr_utility.set_location('BEN_91529_CANNOT_FIND_ELEC_CHC',40);
1165: end if;
1166: fnd_message.set_name('BEN','BEN_91529_CANNOT_FIND_ELEC_CHC');
1167: fnd_message.set_token('L_PROC',l_proc);
1168: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
1169: fnd_message.raise_error;
1170: end if;

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

1163: if g_debug then
1164: hr_utility.set_location('BEN_91529_CANNOT_FIND_ELEC_CHC',40);
1165: end if;
1166: fnd_message.set_name('BEN','BEN_91529_CANNOT_FIND_ELEC_CHC');
1167: fnd_message.set_token('L_PROC',l_proc);
1168: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
1169: fnd_message.raise_error;
1170: end if;
1171: close c_per_elig_elctbl_chc;

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

1164: hr_utility.set_location('BEN_91529_CANNOT_FIND_ELEC_CHC',40);
1165: end if;
1166: fnd_message.set_name('BEN','BEN_91529_CANNOT_FIND_ELEC_CHC');
1167: fnd_message.set_token('L_PROC',l_proc);
1168: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
1169: fnd_message.raise_error;
1170: end if;
1171: close c_per_elig_elctbl_chc;
1172:

Line 1169: fnd_message.raise_error;

1165: end if;
1166: fnd_message.set_name('BEN','BEN_91529_CANNOT_FIND_ELEC_CHC');
1167: fnd_message.set_token('L_PROC',l_proc);
1168: fnd_message.set_token('ELIG_PER_ELCTBL_CHC_ID',p_elig_per_elctbl_chc_id);
1169: fnd_message.raise_error;
1170: end if;
1171: close c_per_elig_elctbl_chc;
1172:
1173: else

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

1319: close c_cm_enrt_perd_strt_dt;
1320: if g_debug then
1321: hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',40);
1322: end if;
1323: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
1324: fnd_message.set_token('DATE_CODE',p_date_cd);
1325: fnd_message.set_token('L_PROC',l_proc);
1326: fnd_message.raise_error;
1327: --

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

1320: if g_debug then
1321: hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',40);
1322: end if;
1323: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
1324: fnd_message.set_token('DATE_CODE',p_date_cd);
1325: fnd_message.set_token('L_PROC',l_proc);
1326: fnd_message.raise_error;
1327: --
1328: end if;

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

1321: hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',40);
1322: end if;
1323: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
1324: fnd_message.set_token('DATE_CODE',p_date_cd);
1325: fnd_message.set_token('L_PROC',l_proc);
1326: fnd_message.raise_error;
1327: --
1328: end if;
1329: --

Line 1326: fnd_message.raise_error;

1322: end if;
1323: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
1324: fnd_message.set_token('DATE_CODE',p_date_cd);
1325: fnd_message.set_token('L_PROC',l_proc);
1326: fnd_message.raise_error;
1327: --
1328: end if;
1329: --
1330: end if;

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

1454: close c_pay_period_for_date;
1455: if g_debug then
1456: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',15);
1457: end if;
1458: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1459: fnd_message.set_token('DATE_CODE',p_date_cd);
1460: fnd_message.set_token('L_PROC',l_proc);
1461: fnd_message.set_token('PERSON_ID',l_person_id);
1462: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

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

1455: if g_debug then
1456: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',15);
1457: end if;
1458: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1459: fnd_message.set_token('DATE_CODE',p_date_cd);
1460: fnd_message.set_token('L_PROC',l_proc);
1461: fnd_message.set_token('PERSON_ID',l_person_id);
1462: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1463: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

1456: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',15);
1457: end if;
1458: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1459: fnd_message.set_token('DATE_CODE',p_date_cd);
1460: fnd_message.set_token('L_PROC',l_proc);
1461: fnd_message.set_token('PERSON_ID',l_person_id);
1462: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1463: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1464: fnd_message.raise_error;

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

1457: end if;
1458: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1459: fnd_message.set_token('DATE_CODE',p_date_cd);
1460: fnd_message.set_token('L_PROC',l_proc);
1461: fnd_message.set_token('PERSON_ID',l_person_id);
1462: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1463: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1464: fnd_message.raise_error;
1465: end if;

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

1458: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1459: fnd_message.set_token('DATE_CODE',p_date_cd);
1460: fnd_message.set_token('L_PROC',l_proc);
1461: fnd_message.set_token('PERSON_ID',l_person_id);
1462: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1463: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1464: fnd_message.raise_error;
1465: end if;
1466: close c_pay_period_for_date;

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

1459: fnd_message.set_token('DATE_CODE',p_date_cd);
1460: fnd_message.set_token('L_PROC',l_proc);
1461: fnd_message.set_token('PERSON_ID',l_person_id);
1462: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1463: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1464: fnd_message.raise_error;
1465: end if;
1466: close c_pay_period_for_date;
1467:

Line 1464: fnd_message.raise_error;

1460: fnd_message.set_token('L_PROC',l_proc);
1461: fnd_message.set_token('PERSON_ID',l_person_id);
1462: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1463: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1464: fnd_message.raise_error;
1465: end if;
1466: close c_pay_period_for_date;
1467:
1468: if p_date_cd = 'FDLPPPPYAES' then

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

1492: close c_pay_period_for_date;
1493: if g_debug then
1494: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',15);
1495: end if;
1496: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1497: fnd_message.set_token('DATE_CODE',p_date_cd);
1498: fnd_message.set_token('L_PROC',l_proc);
1499: fnd_message.set_token('PERSON_ID',l_person_id);
1500: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

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

1493: if g_debug then
1494: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',15);
1495: end if;
1496: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1497: fnd_message.set_token('DATE_CODE',p_date_cd);
1498: fnd_message.set_token('L_PROC',l_proc);
1499: fnd_message.set_token('PERSON_ID',l_person_id);
1500: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1501: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

1494: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',15);
1495: end if;
1496: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1497: fnd_message.set_token('DATE_CODE',p_date_cd);
1498: fnd_message.set_token('L_PROC',l_proc);
1499: fnd_message.set_token('PERSON_ID',l_person_id);
1500: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1501: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1502: fnd_message.raise_error;

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

1495: end if;
1496: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1497: fnd_message.set_token('DATE_CODE',p_date_cd);
1498: fnd_message.set_token('L_PROC',l_proc);
1499: fnd_message.set_token('PERSON_ID',l_person_id);
1500: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1501: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1502: fnd_message.raise_error;
1503: end if;

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

1496: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1497: fnd_message.set_token('DATE_CODE',p_date_cd);
1498: fnd_message.set_token('L_PROC',l_proc);
1499: fnd_message.set_token('PERSON_ID',l_person_id);
1500: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1501: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1502: fnd_message.raise_error;
1503: end if;
1504: close c_pay_period_for_date;

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

1497: fnd_message.set_token('DATE_CODE',p_date_cd);
1498: fnd_message.set_token('L_PROC',l_proc);
1499: fnd_message.set_token('PERSON_ID',l_person_id);
1500: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1501: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1502: fnd_message.raise_error;
1503: end if;
1504: close c_pay_period_for_date;
1505:

Line 1502: fnd_message.raise_error;

1498: fnd_message.set_token('L_PROC',l_proc);
1499: fnd_message.set_token('PERSON_ID',l_person_id);
1500: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1501: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1502: fnd_message.raise_error;
1503: end if;
1504: close c_pay_period_for_date;
1505:
1506: else

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

1530: close c_pay_period_for_date;
1531: if g_debug then
1532: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',25);
1533: end if;
1534: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1535: fnd_message.set_token('DATE_CODE',p_date_cd);
1536: fnd_message.set_token('L_PROC',l_proc);
1537: fnd_message.set_token('PERSON_ID',l_person_id);
1538: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

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

1531: if g_debug then
1532: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',25);
1533: end if;
1534: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1535: fnd_message.set_token('DATE_CODE',p_date_cd);
1536: fnd_message.set_token('L_PROC',l_proc);
1537: fnd_message.set_token('PERSON_ID',l_person_id);
1538: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1539: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

1532: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',25);
1533: end if;
1534: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1535: fnd_message.set_token('DATE_CODE',p_date_cd);
1536: fnd_message.set_token('L_PROC',l_proc);
1537: fnd_message.set_token('PERSON_ID',l_person_id);
1538: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1539: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1540: fnd_message.raise_error;

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

1533: end if;
1534: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1535: fnd_message.set_token('DATE_CODE',p_date_cd);
1536: fnd_message.set_token('L_PROC',l_proc);
1537: fnd_message.set_token('PERSON_ID',l_person_id);
1538: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1539: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1540: fnd_message.raise_error;
1541: end if;

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

1534: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1535: fnd_message.set_token('DATE_CODE',p_date_cd);
1536: fnd_message.set_token('L_PROC',l_proc);
1537: fnd_message.set_token('PERSON_ID',l_person_id);
1538: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1539: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1540: fnd_message.raise_error;
1541: end if;
1542: close c_pay_period_for_date;

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

1535: fnd_message.set_token('DATE_CODE',p_date_cd);
1536: fnd_message.set_token('L_PROC',l_proc);
1537: fnd_message.set_token('PERSON_ID',l_person_id);
1538: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1539: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1540: fnd_message.raise_error;
1541: end if;
1542: close c_pay_period_for_date;
1543: end if;

Line 1540: fnd_message.raise_error;

1536: fnd_message.set_token('L_PROC',l_proc);
1537: fnd_message.set_token('PERSON_ID',l_person_id);
1538: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1539: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1540: fnd_message.raise_error;
1541: end if;
1542: close c_pay_period_for_date;
1543: end if;
1544: end if ;

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

1763: l_enrt_cvg_strt_dt is not null then
1764: if g_debug then
1765: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',80);
1766: end if;
1767: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1768: fnd_message.set_token('DATE_CODE',p_date_cd);
1769: fnd_message.set_token('L_PROC',l_proc);
1770: fnd_message.set_token('PERSON_ID',l_person_id);
1771: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

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

1764: if g_debug then
1765: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',80);
1766: end if;
1767: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1768: fnd_message.set_token('DATE_CODE',p_date_cd);
1769: fnd_message.set_token('L_PROC',l_proc);
1770: fnd_message.set_token('PERSON_ID',l_person_id);
1771: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1772: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

1765: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',80);
1766: end if;
1767: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1768: fnd_message.set_token('DATE_CODE',p_date_cd);
1769: fnd_message.set_token('L_PROC',l_proc);
1770: fnd_message.set_token('PERSON_ID',l_person_id);
1771: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1772: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1773: fnd_message.raise_error;

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

1766: end if;
1767: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1768: fnd_message.set_token('DATE_CODE',p_date_cd);
1769: fnd_message.set_token('L_PROC',l_proc);
1770: fnd_message.set_token('PERSON_ID',l_person_id);
1771: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1772: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1773: fnd_message.raise_error;
1774: end if;

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

1767: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1768: fnd_message.set_token('DATE_CODE',p_date_cd);
1769: fnd_message.set_token('L_PROC',l_proc);
1770: fnd_message.set_token('PERSON_ID',l_person_id);
1771: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1772: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1773: fnd_message.raise_error;
1774: end if;
1775: close c_pay_period_for_date;

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

1768: fnd_message.set_token('DATE_CODE',p_date_cd);
1769: fnd_message.set_token('L_PROC',l_proc);
1770: fnd_message.set_token('PERSON_ID',l_person_id);
1771: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1772: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1773: fnd_message.raise_error;
1774: end if;
1775: close c_pay_period_for_date;
1776: end if;

Line 1773: fnd_message.raise_error;

1769: fnd_message.set_token('L_PROC',l_proc);
1770: fnd_message.set_token('PERSON_ID',l_person_id);
1771: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1772: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1773: fnd_message.raise_error;
1774: end if;
1775: close c_pay_period_for_date;
1776: end if;
1777:

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

1801: close c_next_pay_period;
1802: if g_debug then
1803: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',40);
1804: end if;
1805: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1806: fnd_message.set_token('DATE_CODE',p_date_cd);
1807: fnd_message.set_token('L_PROC',l_proc);
1808: fnd_message.set_token('PERSON_ID',l_person_id);
1809: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

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

1802: if g_debug then
1803: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',40);
1804: end if;
1805: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1806: fnd_message.set_token('DATE_CODE',p_date_cd);
1807: fnd_message.set_token('L_PROC',l_proc);
1808: fnd_message.set_token('PERSON_ID',l_person_id);
1809: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1810: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

1803: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',40);
1804: end if;
1805: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1806: fnd_message.set_token('DATE_CODE',p_date_cd);
1807: fnd_message.set_token('L_PROC',l_proc);
1808: fnd_message.set_token('PERSON_ID',l_person_id);
1809: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1810: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1811: fnd_message.raise_error;

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

1804: end if;
1805: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1806: fnd_message.set_token('DATE_CODE',p_date_cd);
1807: fnd_message.set_token('L_PROC',l_proc);
1808: fnd_message.set_token('PERSON_ID',l_person_id);
1809: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1810: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1811: fnd_message.raise_error;
1812: end if;

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

1805: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1806: fnd_message.set_token('DATE_CODE',p_date_cd);
1807: fnd_message.set_token('L_PROC',l_proc);
1808: fnd_message.set_token('PERSON_ID',l_person_id);
1809: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1810: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1811: fnd_message.raise_error;
1812: end if;
1813: close c_next_pay_period;

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

1806: fnd_message.set_token('DATE_CODE',p_date_cd);
1807: fnd_message.set_token('L_PROC',l_proc);
1808: fnd_message.set_token('PERSON_ID',l_person_id);
1809: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1810: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1811: fnd_message.raise_error;
1812: end if;
1813: close c_next_pay_period;
1814:

Line 1811: fnd_message.raise_error;

1807: fnd_message.set_token('L_PROC',l_proc);
1808: fnd_message.set_token('PERSON_ID',l_person_id);
1809: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1810: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1811: fnd_message.raise_error;
1812: end if;
1813: close c_next_pay_period;
1814:
1815: if p_date_cd = 'LESFDPPAD' and

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

1867: hr_utility.set_location('l_next_pay_period.start_date'||l_next_pay_period.start_date,20);
1868: end if;
1869: if c_next_pay_period%notfound then
1870: close c_next_pay_period;
1871: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1872: fnd_message.set_token('DATE_CODE',p_date_cd);
1873: fnd_message.set_token('L_PROC',l_proc);
1874: fnd_message.set_token('PERSON_ID',l_person_id);
1875: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

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

1868: end if;
1869: if c_next_pay_period%notfound then
1870: close c_next_pay_period;
1871: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1872: fnd_message.set_token('DATE_CODE',p_date_cd);
1873: fnd_message.set_token('L_PROC',l_proc);
1874: fnd_message.set_token('PERSON_ID',l_person_id);
1875: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1876: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

1869: if c_next_pay_period%notfound then
1870: close c_next_pay_period;
1871: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1872: fnd_message.set_token('DATE_CODE',p_date_cd);
1873: fnd_message.set_token('L_PROC',l_proc);
1874: fnd_message.set_token('PERSON_ID',l_person_id);
1875: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1876: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1877: fnd_message.raise_error;

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

1870: close c_next_pay_period;
1871: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1872: fnd_message.set_token('DATE_CODE',p_date_cd);
1873: fnd_message.set_token('L_PROC',l_proc);
1874: fnd_message.set_token('PERSON_ID',l_person_id);
1875: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1876: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1877: fnd_message.raise_error;
1878: end if;

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

1871: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1872: fnd_message.set_token('DATE_CODE',p_date_cd);
1873: fnd_message.set_token('L_PROC',l_proc);
1874: fnd_message.set_token('PERSON_ID',l_person_id);
1875: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1876: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1877: fnd_message.raise_error;
1878: end if;
1879: close c_next_pay_period;

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

1872: fnd_message.set_token('DATE_CODE',p_date_cd);
1873: fnd_message.set_token('L_PROC',l_proc);
1874: fnd_message.set_token('PERSON_ID',l_person_id);
1875: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1876: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1877: fnd_message.raise_error;
1878: end if;
1879: close c_next_pay_period;
1880: if p_date_cd = 'FDPPFED' then

Line 1877: fnd_message.raise_error;

1873: fnd_message.set_token('L_PROC',l_proc);
1874: fnd_message.set_token('PERSON_ID',l_person_id);
1875: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1876: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1877: fnd_message.raise_error;
1878: end if;
1879: close c_next_pay_period;
1880: if p_date_cd = 'FDPPFED' then
1881: p_returned_date := l_next_pay_period.start_date;

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

1893: open c_pay_period;
1894: fetch c_pay_period into l_pay_period;
1895: if c_pay_period%notfound then
1896: close c_pay_period;
1897: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1898: fnd_message.set_token('DATE_CODE',p_date_cd);
1899: fnd_message.set_token('PERSON_ID',l_person_id);
1900: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1901: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

1894: fetch c_pay_period into l_pay_period;
1895: if c_pay_period%notfound then
1896: close c_pay_period;
1897: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1898: fnd_message.set_token('DATE_CODE',p_date_cd);
1899: fnd_message.set_token('PERSON_ID',l_person_id);
1900: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1901: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1902: fnd_message.raise_error;

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

1895: if c_pay_period%notfound then
1896: close c_pay_period;
1897: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1898: fnd_message.set_token('DATE_CODE',p_date_cd);
1899: fnd_message.set_token('PERSON_ID',l_person_id);
1900: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1901: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1902: fnd_message.raise_error;
1903: end if;

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

1896: close c_pay_period;
1897: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1898: fnd_message.set_token('DATE_CODE',p_date_cd);
1899: fnd_message.set_token('PERSON_ID',l_person_id);
1900: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1901: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1902: fnd_message.raise_error;
1903: end if;
1904: close c_pay_period ;

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

1897: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1898: fnd_message.set_token('DATE_CODE',p_date_cd);
1899: fnd_message.set_token('PERSON_ID',l_person_id);
1900: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1901: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1902: fnd_message.raise_error;
1903: end if;
1904: close c_pay_period ;
1905: --

Line 1902: fnd_message.raise_error;

1898: fnd_message.set_token('DATE_CODE',p_date_cd);
1899: fnd_message.set_token('PERSON_ID',l_person_id);
1900: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1901: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1902: fnd_message.raise_error;
1903: end if;
1904: close c_pay_period ;
1905: --
1906: if l_event_date = l_pay_period.start_date then

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

1912: fetch c_next_pay_period into l_next_pay_period;
1913: --
1914: if c_next_pay_period%notfound then
1915: close c_next_pay_period;
1916: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1917: fnd_message.set_token('DATE_CODE',p_date_cd);
1918: fnd_message.set_token('PERSON_ID',l_person_id);
1919: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1920: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

1913: --
1914: if c_next_pay_period%notfound then
1915: close c_next_pay_period;
1916: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1917: fnd_message.set_token('DATE_CODE',p_date_cd);
1918: fnd_message.set_token('PERSON_ID',l_person_id);
1919: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1920: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1921: fnd_message.raise_error;

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

1914: if c_next_pay_period%notfound then
1915: close c_next_pay_period;
1916: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1917: fnd_message.set_token('DATE_CODE',p_date_cd);
1918: fnd_message.set_token('PERSON_ID',l_person_id);
1919: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1920: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1921: fnd_message.raise_error;
1922: end if;

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

1915: close c_next_pay_period;
1916: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1917: fnd_message.set_token('DATE_CODE',p_date_cd);
1918: fnd_message.set_token('PERSON_ID',l_person_id);
1919: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1920: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1921: fnd_message.raise_error;
1922: end if;
1923: close c_next_pay_period;

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

1916: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1917: fnd_message.set_token('DATE_CODE',p_date_cd);
1918: fnd_message.set_token('PERSON_ID',l_person_id);
1919: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1920: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1921: fnd_message.raise_error;
1922: end if;
1923: close c_next_pay_period;
1924: p_returned_date := l_next_pay_period.start_date;

Line 1921: fnd_message.raise_error;

1917: fnd_message.set_token('DATE_CODE',p_date_cd);
1918: fnd_message.set_token('PERSON_ID',l_person_id);
1919: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1920: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1921: fnd_message.raise_error;
1922: end if;
1923: close c_next_pay_period;
1924: p_returned_date := l_next_pay_period.start_date;
1925: hr_utility.set_location('l_pay_period.start_date '|| l_next_pay_period.start_date,20);

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

1937: open c_pay_period;
1938: fetch c_pay_period into l_pay_period;
1939: if c_pay_period%notfound then
1940: close c_pay_period;
1941: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1942: fnd_message.set_token('DATE_CODE',p_date_cd);
1943: fnd_message.set_token('PERSON_ID',l_person_id);
1944: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1945: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

1938: fetch c_pay_period into l_pay_period;
1939: if c_pay_period%notfound then
1940: close c_pay_period;
1941: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1942: fnd_message.set_token('DATE_CODE',p_date_cd);
1943: fnd_message.set_token('PERSON_ID',l_person_id);
1944: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1945: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1946: fnd_message.raise_error;

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

1939: if c_pay_period%notfound then
1940: close c_pay_period;
1941: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1942: fnd_message.set_token('DATE_CODE',p_date_cd);
1943: fnd_message.set_token('PERSON_ID',l_person_id);
1944: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1945: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1946: fnd_message.raise_error;
1947: end if;

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

1940: close c_pay_period;
1941: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1942: fnd_message.set_token('DATE_CODE',p_date_cd);
1943: fnd_message.set_token('PERSON_ID',l_person_id);
1944: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1945: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1946: fnd_message.raise_error;
1947: end if;
1948: close c_pay_period ;

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

1941: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1942: fnd_message.set_token('DATE_CODE',p_date_cd);
1943: fnd_message.set_token('PERSON_ID',l_person_id);
1944: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1945: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1946: fnd_message.raise_error;
1947: end if;
1948: close c_pay_period ;
1949: --

Line 1946: fnd_message.raise_error;

1942: fnd_message.set_token('DATE_CODE',p_date_cd);
1943: fnd_message.set_token('PERSON_ID',l_person_id);
1944: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1945: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1946: fnd_message.raise_error;
1947: end if;
1948: close c_pay_period ;
1949: --
1950: if l_event_date = l_pay_period.end_date then

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

1956: fetch c_next_pay_period into l_next_pay_period;
1957: --
1958: if c_next_pay_period%notfound then
1959: close c_next_pay_period;
1960: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1961: fnd_message.set_token('DATE_CODE',p_date_cd);
1962: fnd_message.set_token('PERSON_ID',l_person_id);
1963: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1964: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

1957: --
1958: if c_next_pay_period%notfound then
1959: close c_next_pay_period;
1960: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1961: fnd_message.set_token('DATE_CODE',p_date_cd);
1962: fnd_message.set_token('PERSON_ID',l_person_id);
1963: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1964: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1965: fnd_message.raise_error;

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

1958: if c_next_pay_period%notfound then
1959: close c_next_pay_period;
1960: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1961: fnd_message.set_token('DATE_CODE',p_date_cd);
1962: fnd_message.set_token('PERSON_ID',l_person_id);
1963: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1964: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1965: fnd_message.raise_error;
1966: end if;

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

1959: close c_next_pay_period;
1960: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1961: fnd_message.set_token('DATE_CODE',p_date_cd);
1962: fnd_message.set_token('PERSON_ID',l_person_id);
1963: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1964: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1965: fnd_message.raise_error;
1966: end if;
1967: close c_next_pay_period;

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

1960: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
1961: fnd_message.set_token('DATE_CODE',p_date_cd);
1962: fnd_message.set_token('PERSON_ID',l_person_id);
1963: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1964: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1965: fnd_message.raise_error;
1966: end if;
1967: close c_next_pay_period;
1968: p_returned_date := l_next_pay_period.end_date;

Line 1965: fnd_message.raise_error;

1961: fnd_message.set_token('DATE_CODE',p_date_cd);
1962: fnd_message.set_token('PERSON_ID',l_person_id);
1963: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
1964: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
1965: fnd_message.raise_error;
1966: end if;
1967: close c_next_pay_period;
1968: p_returned_date := l_next_pay_period.end_date;
1969: hr_utility.set_location('l_pay_period.end_date '|| l_next_pay_period.end_date,20);

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

2572: close c_pay_period_for_date;
2573: if g_debug then
2574: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',45);
2575: end if;
2576: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2577: fnd_message.set_token('DATE_CODE',p_date_cd);
2578: fnd_message.set_token('L_PROC',l_proc);
2579: fnd_message.set_token('PERSON_ID',l_person_id);
2580: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

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

2573: if g_debug then
2574: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',45);
2575: end if;
2576: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2577: fnd_message.set_token('DATE_CODE',p_date_cd);
2578: fnd_message.set_token('L_PROC',l_proc);
2579: fnd_message.set_token('PERSON_ID',l_person_id);
2580: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2581: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);

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

2574: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',45);
2575: end if;
2576: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2577: fnd_message.set_token('DATE_CODE',p_date_cd);
2578: fnd_message.set_token('L_PROC',l_proc);
2579: fnd_message.set_token('PERSON_ID',l_person_id);
2580: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2581: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);
2582: fnd_message.raise_error;

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

2575: end if;
2576: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2577: fnd_message.set_token('DATE_CODE',p_date_cd);
2578: fnd_message.set_token('L_PROC',l_proc);
2579: fnd_message.set_token('PERSON_ID',l_person_id);
2580: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2581: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);
2582: fnd_message.raise_error;
2583:

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

2576: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2577: fnd_message.set_token('DATE_CODE',p_date_cd);
2578: fnd_message.set_token('L_PROC',l_proc);
2579: fnd_message.set_token('PERSON_ID',l_person_id);
2580: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2581: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);
2582: fnd_message.raise_error;
2583:
2584: end if;

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

2577: fnd_message.set_token('DATE_CODE',p_date_cd);
2578: fnd_message.set_token('L_PROC',l_proc);
2579: fnd_message.set_token('PERSON_ID',l_person_id);
2580: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2581: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);
2582: fnd_message.raise_error;
2583:
2584: end if;
2585: close c_pay_period_for_date;

Line 2582: fnd_message.raise_error;

2578: fnd_message.set_token('L_PROC',l_proc);
2579: fnd_message.set_token('PERSON_ID',l_person_id);
2580: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2581: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);
2582: fnd_message.raise_error;
2583:
2584: end if;
2585: close c_pay_period_for_date;
2586:

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

2600: close c_next_pay_period;
2601: if g_debug then
2602: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',55);
2603: end if;
2604: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2605: fnd_message.set_token('DATE_CODE',p_date_cd);
2606: fnd_message.set_token('L_PROC',l_proc);
2607: fnd_message.set_token('PERSON_ID',l_person_id);
2608: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

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

2601: if g_debug then
2602: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',55);
2603: end if;
2604: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2605: fnd_message.set_token('DATE_CODE',p_date_cd);
2606: fnd_message.set_token('L_PROC',l_proc);
2607: fnd_message.set_token('PERSON_ID',l_person_id);
2608: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2609: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);

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

2602: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',55);
2603: end if;
2604: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2605: fnd_message.set_token('DATE_CODE',p_date_cd);
2606: fnd_message.set_token('L_PROC',l_proc);
2607: fnd_message.set_token('PERSON_ID',l_person_id);
2608: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2609: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);
2610: fnd_message.raise_error;

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

2603: end if;
2604: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2605: fnd_message.set_token('DATE_CODE',p_date_cd);
2606: fnd_message.set_token('L_PROC',l_proc);
2607: fnd_message.set_token('PERSON_ID',l_person_id);
2608: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2609: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);
2610: fnd_message.raise_error;
2611: end if;

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

2604: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
2605: fnd_message.set_token('DATE_CODE',p_date_cd);
2606: fnd_message.set_token('L_PROC',l_proc);
2607: fnd_message.set_token('PERSON_ID',l_person_id);
2608: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2609: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);
2610: fnd_message.raise_error;
2611: end if;
2612: close c_next_pay_period;

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

2605: fnd_message.set_token('DATE_CODE',p_date_cd);
2606: fnd_message.set_token('L_PROC',l_proc);
2607: fnd_message.set_token('PERSON_ID',l_person_id);
2608: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2609: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);
2610: fnd_message.raise_error;
2611: end if;
2612: close c_next_pay_period;
2613:

Line 2610: fnd_message.raise_error;

2606: fnd_message.set_token('L_PROC',l_proc);
2607: fnd_message.set_token('PERSON_ID',l_person_id);
2608: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
2609: fnd_message.set_token('EFFECTIVE_DATE',l_cmpltd_dt);
2610: fnd_message.raise_error;
2611: end if;
2612: close c_next_pay_period;
2613:
2614: p_returned_date := l_next_pay_period.start_date;

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

2655: else
2656: if g_debug then
2657: hr_utility.set_location('BEN_92489_CANNOT_CALC_DATE',55);
2658: end if;
2659: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
2660: fnd_message.set_token('DATE_CODE',p_date_cd);
2661: fnd_message.set_token('L_PROC',l_proc);
2662: fnd_message.raise_error;
2663: --

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

2656: if g_debug then
2657: hr_utility.set_location('BEN_92489_CANNOT_CALC_DATE',55);
2658: end if;
2659: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
2660: fnd_message.set_token('DATE_CODE',p_date_cd);
2661: fnd_message.set_token('L_PROC',l_proc);
2662: fnd_message.raise_error;
2663: --
2664: end if;

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

2657: hr_utility.set_location('BEN_92489_CANNOT_CALC_DATE',55);
2658: end if;
2659: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
2660: fnd_message.set_token('DATE_CODE',p_date_cd);
2661: fnd_message.set_token('L_PROC',l_proc);
2662: fnd_message.raise_error;
2663: --
2664: end if;
2665: --

Line 2662: fnd_message.raise_error;

2658: end if;
2659: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
2660: fnd_message.set_token('DATE_CODE',p_date_cd);
2661: fnd_message.set_token('L_PROC',l_proc);
2662: fnd_message.raise_error;
2663: --
2664: end if;
2665: --
2666: p_returned_date:= l_start_date;

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

2701: close c_oipl_popl_lim_yr;
2702: --
2703: else
2704: -- hr_utility.set_location('BEN_92489_CANNOT_CALC_DATE',55);
2705: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
2706: fnd_message.set_token('DATE_CODE',p_date_cd);
2707: fnd_message.set_token('L_PROC',l_proc);
2708: fnd_message.raise_error;
2709: --

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

2702: --
2703: else
2704: -- hr_utility.set_location('BEN_92489_CANNOT_CALC_DATE',55);
2705: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
2706: fnd_message.set_token('DATE_CODE',p_date_cd);
2707: fnd_message.set_token('L_PROC',l_proc);
2708: fnd_message.raise_error;
2709: --
2710: end if;

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

2703: else
2704: -- hr_utility.set_location('BEN_92489_CANNOT_CALC_DATE',55);
2705: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
2706: fnd_message.set_token('DATE_CODE',p_date_cd);
2707: fnd_message.set_token('L_PROC',l_proc);
2708: fnd_message.raise_error;
2709: --
2710: end if;
2711: --

Line 2708: fnd_message.raise_error;

2704: -- hr_utility.set_location('BEN_92489_CANNOT_CALC_DATE',55);
2705: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
2706: fnd_message.set_token('DATE_CODE',p_date_cd);
2707: fnd_message.set_token('L_PROC',l_proc);
2708: fnd_message.raise_error;
2709: --
2710: end if;
2711: --
2712: p_returned_date:= l_end_date;

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

3033: if c_pay_period%notfound then
3034:
3035: close c_pay_period;
3036: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',65);
3037: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3038: fnd_message.set_token('DATE_CODE',p_date_cd);
3039: fnd_message.set_token('L_PROC',l_proc);
3040: fnd_message.set_token('PERSON_ID',l_person_id);
3041: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

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

3034:
3035: close c_pay_period;
3036: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',65);
3037: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3038: fnd_message.set_token('DATE_CODE',p_date_cd);
3039: fnd_message.set_token('L_PROC',l_proc);
3040: fnd_message.set_token('PERSON_ID',l_person_id);
3041: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3042: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

3035: close c_pay_period;
3036: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',65);
3037: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3038: fnd_message.set_token('DATE_CODE',p_date_cd);
3039: fnd_message.set_token('L_PROC',l_proc);
3040: fnd_message.set_token('PERSON_ID',l_person_id);
3041: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3042: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3043: fnd_message.raise_error;

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

3036: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',65);
3037: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3038: fnd_message.set_token('DATE_CODE',p_date_cd);
3039: fnd_message.set_token('L_PROC',l_proc);
3040: fnd_message.set_token('PERSON_ID',l_person_id);
3041: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3042: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3043: fnd_message.raise_error;
3044:

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

3037: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3038: fnd_message.set_token('DATE_CODE',p_date_cd);
3039: fnd_message.set_token('L_PROC',l_proc);
3040: fnd_message.set_token('PERSON_ID',l_person_id);
3041: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3042: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3043: fnd_message.raise_error;
3044:
3045: end if;

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

3038: fnd_message.set_token('DATE_CODE',p_date_cd);
3039: fnd_message.set_token('L_PROC',l_proc);
3040: fnd_message.set_token('PERSON_ID',l_person_id);
3041: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3042: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3043: fnd_message.raise_error;
3044:
3045: end if;
3046:

Line 3043: fnd_message.raise_error;

3039: fnd_message.set_token('L_PROC',l_proc);
3040: fnd_message.set_token('PERSON_ID',l_person_id);
3041: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3042: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3043: fnd_message.raise_error;
3044:
3045: end if;
3046:
3047: close c_pay_period ;

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

3080: if c_pay_period%notfound then
3081:
3082: close c_pay_period;
3083: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',70);
3084: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3085: fnd_message.set_token('DATE_CODE',p_date_cd);
3086: fnd_message.set_token('L_PROC',l_proc);
3087: fnd_message.set_token('PERSON_ID',l_person_id);
3088: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

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

3081:
3082: close c_pay_period;
3083: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',70);
3084: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3085: fnd_message.set_token('DATE_CODE',p_date_cd);
3086: fnd_message.set_token('L_PROC',l_proc);
3087: fnd_message.set_token('PERSON_ID',l_person_id);
3088: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3089: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

3082: close c_pay_period;
3083: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',70);
3084: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3085: fnd_message.set_token('DATE_CODE',p_date_cd);
3086: fnd_message.set_token('L_PROC',l_proc);
3087: fnd_message.set_token('PERSON_ID',l_person_id);
3088: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3089: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3090: fnd_message.raise_error;

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

3083: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',70);
3084: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3085: fnd_message.set_token('DATE_CODE',p_date_cd);
3086: fnd_message.set_token('L_PROC',l_proc);
3087: fnd_message.set_token('PERSON_ID',l_person_id);
3088: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3089: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3090: fnd_message.raise_error;
3091:

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

3084: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3085: fnd_message.set_token('DATE_CODE',p_date_cd);
3086: fnd_message.set_token('L_PROC',l_proc);
3087: fnd_message.set_token('PERSON_ID',l_person_id);
3088: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3089: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3090: fnd_message.raise_error;
3091:
3092: end if;

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

3085: fnd_message.set_token('DATE_CODE',p_date_cd);
3086: fnd_message.set_token('L_PROC',l_proc);
3087: fnd_message.set_token('PERSON_ID',l_person_id);
3088: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3089: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3090: fnd_message.raise_error;
3091:
3092: end if;
3093:

Line 3090: fnd_message.raise_error;

3086: fnd_message.set_token('L_PROC',l_proc);
3087: fnd_message.set_token('PERSON_ID',l_person_id);
3088: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3089: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3090: fnd_message.raise_error;
3091:
3092: end if;
3093:
3094: close c_pay_period ;

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

3652: l_end_date;
3653: --
3654: if c_pay_period_for_date%notfound then
3655: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',95);
3656: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3657: fnd_message.set_token('DATE_CODE',p_date_cd);
3658: fnd_message.set_token('L_PROC',l_proc);
3659: fnd_message.set_token('PERSON_ID',l_person_id);
3660: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

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

3653: --
3654: if c_pay_period_for_date%notfound then
3655: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',95);
3656: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3657: fnd_message.set_token('DATE_CODE',p_date_cd);
3658: fnd_message.set_token('L_PROC',l_proc);
3659: fnd_message.set_token('PERSON_ID',l_person_id);
3660: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3661: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

3654: if c_pay_period_for_date%notfound then
3655: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',95);
3656: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3657: fnd_message.set_token('DATE_CODE',p_date_cd);
3658: fnd_message.set_token('L_PROC',l_proc);
3659: fnd_message.set_token('PERSON_ID',l_person_id);
3660: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3661: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3662: fnd_message.raise_error;

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

3655: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',95);
3656: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3657: fnd_message.set_token('DATE_CODE',p_date_cd);
3658: fnd_message.set_token('L_PROC',l_proc);
3659: fnd_message.set_token('PERSON_ID',l_person_id);
3660: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3661: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3662: fnd_message.raise_error;
3663: --

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

3656: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3657: fnd_message.set_token('DATE_CODE',p_date_cd);
3658: fnd_message.set_token('L_PROC',l_proc);
3659: fnd_message.set_token('PERSON_ID',l_person_id);
3660: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3661: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3662: fnd_message.raise_error;
3663: --
3664: end if;

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

3657: fnd_message.set_token('DATE_CODE',p_date_cd);
3658: fnd_message.set_token('L_PROC',l_proc);
3659: fnd_message.set_token('PERSON_ID',l_person_id);
3660: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3661: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3662: fnd_message.raise_error;
3663: --
3664: end if;
3665: --

Line 3662: fnd_message.raise_error;

3658: fnd_message.set_token('L_PROC',l_proc);
3659: fnd_message.set_token('PERSON_ID',l_person_id);
3660: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3661: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3662: fnd_message.raise_error;
3663: --
3664: end if;
3665: --
3666: p_returned_date:=l_end_date;

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

3696: l_end_date;
3697: --
3698: if c_pay_period_for_date%notfound then
3699: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',100);
3700: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3701: fnd_message.set_token('DATE_CODE',p_date_cd);
3702: fnd_message.set_token('L_PROC',l_proc);
3703: fnd_message.set_token('PERSON_ID',l_person_id);
3704: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

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

3697: --
3698: if c_pay_period_for_date%notfound then
3699: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',100);
3700: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3701: fnd_message.set_token('DATE_CODE',p_date_cd);
3702: fnd_message.set_token('L_PROC',l_proc);
3703: fnd_message.set_token('PERSON_ID',l_person_id);
3704: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3705: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

3698: if c_pay_period_for_date%notfound then
3699: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',100);
3700: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3701: fnd_message.set_token('DATE_CODE',p_date_cd);
3702: fnd_message.set_token('L_PROC',l_proc);
3703: fnd_message.set_token('PERSON_ID',l_person_id);
3704: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3705: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3706: fnd_message.raise_error;

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

3699: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',100);
3700: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3701: fnd_message.set_token('DATE_CODE',p_date_cd);
3702: fnd_message.set_token('L_PROC',l_proc);
3703: fnd_message.set_token('PERSON_ID',l_person_id);
3704: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3705: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3706: fnd_message.raise_error;
3707: end if;

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

3700: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3701: fnd_message.set_token('DATE_CODE',p_date_cd);
3702: fnd_message.set_token('L_PROC',l_proc);
3703: fnd_message.set_token('PERSON_ID',l_person_id);
3704: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3705: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3706: fnd_message.raise_error;
3707: end if;
3708: --

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

3701: fnd_message.set_token('DATE_CODE',p_date_cd);
3702: fnd_message.set_token('L_PROC',l_proc);
3703: fnd_message.set_token('PERSON_ID',l_person_id);
3704: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3705: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3706: fnd_message.raise_error;
3707: end if;
3708: --
3709: p_returned_date:=l_start_date;

Line 3706: fnd_message.raise_error;

3702: fnd_message.set_token('L_PROC',l_proc);
3703: fnd_message.set_token('PERSON_ID',l_person_id);
3704: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3705: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3706: fnd_message.raise_error;
3707: end if;
3708: --
3709: p_returned_date:=l_start_date;
3710: --

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

3740: l_end_date;
3741: --
3742: if c_pay_period_for_date%notfound then
3743: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',105);
3744: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3745: fnd_message.set_token('DATE_CODE',p_date_cd);
3746: fnd_message.set_token('L_PROC',l_proc);
3747: fnd_message.set_token('PERSON_ID',l_person_id);
3748: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

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

3741: --
3742: if c_pay_period_for_date%notfound then
3743: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',105);
3744: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3745: fnd_message.set_token('DATE_CODE',p_date_cd);
3746: fnd_message.set_token('L_PROC',l_proc);
3747: fnd_message.set_token('PERSON_ID',l_person_id);
3748: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3749: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

3742: if c_pay_period_for_date%notfound then
3743: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',105);
3744: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3745: fnd_message.set_token('DATE_CODE',p_date_cd);
3746: fnd_message.set_token('L_PROC',l_proc);
3747: fnd_message.set_token('PERSON_ID',l_person_id);
3748: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3749: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3750: fnd_message.raise_error;

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

3743: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',105);
3744: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3745: fnd_message.set_token('DATE_CODE',p_date_cd);
3746: fnd_message.set_token('L_PROC',l_proc);
3747: fnd_message.set_token('PERSON_ID',l_person_id);
3748: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3749: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3750: fnd_message.raise_error;
3751: end if;

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

3744: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
3745: fnd_message.set_token('DATE_CODE',p_date_cd);
3746: fnd_message.set_token('L_PROC',l_proc);
3747: fnd_message.set_token('PERSON_ID',l_person_id);
3748: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3749: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3750: fnd_message.raise_error;
3751: end if;
3752: --

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

3745: fnd_message.set_token('DATE_CODE',p_date_cd);
3746: fnd_message.set_token('L_PROC',l_proc);
3747: fnd_message.set_token('PERSON_ID',l_person_id);
3748: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3749: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3750: fnd_message.raise_error;
3751: end if;
3752: --
3753: p_returned_date:=l_start_date;

Line 3750: fnd_message.raise_error;

3746: fnd_message.set_token('L_PROC',l_proc);
3747: fnd_message.set_token('PERSON_ID',l_person_id);
3748: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
3749: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
3750: fnd_message.raise_error;
3751: end if;
3752: --
3753: p_returned_date:=l_start_date;
3754: --

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

4149: if c_pay_period%notfound then
4150: --
4151: close c_pay_period;
4152: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',110);
4153: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4154: fnd_message.set_token('DATE_CODE',p_date_cd);
4155: fnd_message.set_token('L_PROC',l_proc);
4156: fnd_message.set_token('PERSON_ID',l_person_id);
4157: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

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

4150: --
4151: close c_pay_period;
4152: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',110);
4153: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4154: fnd_message.set_token('DATE_CODE',p_date_cd);
4155: fnd_message.set_token('L_PROC',l_proc);
4156: fnd_message.set_token('PERSON_ID',l_person_id);
4157: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4158: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

4151: close c_pay_period;
4152: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',110);
4153: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4154: fnd_message.set_token('DATE_CODE',p_date_cd);
4155: fnd_message.set_token('L_PROC',l_proc);
4156: fnd_message.set_token('PERSON_ID',l_person_id);
4157: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4158: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4159: fnd_message.raise_error;

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

4152: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',110);
4153: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4154: fnd_message.set_token('DATE_CODE',p_date_cd);
4155: fnd_message.set_token('L_PROC',l_proc);
4156: fnd_message.set_token('PERSON_ID',l_person_id);
4157: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4158: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4159: fnd_message.raise_error;
4160: --

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

4153: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4154: fnd_message.set_token('DATE_CODE',p_date_cd);
4155: fnd_message.set_token('L_PROC',l_proc);
4156: fnd_message.set_token('PERSON_ID',l_person_id);
4157: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4158: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4159: fnd_message.raise_error;
4160: --
4161: end if;

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

4154: fnd_message.set_token('DATE_CODE',p_date_cd);
4155: fnd_message.set_token('L_PROC',l_proc);
4156: fnd_message.set_token('PERSON_ID',l_person_id);
4157: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4158: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4159: fnd_message.raise_error;
4160: --
4161: end if;
4162: --

Line 4159: fnd_message.raise_error;

4155: fnd_message.set_token('L_PROC',l_proc);
4156: fnd_message.set_token('PERSON_ID',l_person_id);
4157: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4158: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4159: fnd_message.raise_error;
4160: --
4161: end if;
4162: --
4163: p_returned_date := l_pay_period.start_date;

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

4183: --
4184: if c_pay_period%notfound then
4185: close c_pay_period;
4186: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',115);
4187: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4188: fnd_message.set_token('DATE_CODE',p_date_cd);
4189: fnd_message.set_token('L_PROC',l_proc);
4190: fnd_message.set_token('PERSON_ID',l_person_id);
4191: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

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

4184: if c_pay_period%notfound then
4185: close c_pay_period;
4186: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',115);
4187: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4188: fnd_message.set_token('DATE_CODE',p_date_cd);
4189: fnd_message.set_token('L_PROC',l_proc);
4190: fnd_message.set_token('PERSON_ID',l_person_id);
4191: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4192: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

4185: close c_pay_period;
4186: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',115);
4187: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4188: fnd_message.set_token('DATE_CODE',p_date_cd);
4189: fnd_message.set_token('L_PROC',l_proc);
4190: fnd_message.set_token('PERSON_ID',l_person_id);
4191: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4192: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4193: fnd_message.raise_error;

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

4186: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',115);
4187: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4188: fnd_message.set_token('DATE_CODE',p_date_cd);
4189: fnd_message.set_token('L_PROC',l_proc);
4190: fnd_message.set_token('PERSON_ID',l_person_id);
4191: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4192: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4193: fnd_message.raise_error;
4194: end if;

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

4187: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4188: fnd_message.set_token('DATE_CODE',p_date_cd);
4189: fnd_message.set_token('L_PROC',l_proc);
4190: fnd_message.set_token('PERSON_ID',l_person_id);
4191: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4192: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4193: fnd_message.raise_error;
4194: end if;
4195: p_returned_date := l_pay_period.end_date;

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

4188: fnd_message.set_token('DATE_CODE',p_date_cd);
4189: fnd_message.set_token('L_PROC',l_proc);
4190: fnd_message.set_token('PERSON_ID',l_person_id);
4191: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4192: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4193: fnd_message.raise_error;
4194: end if;
4195: p_returned_date := l_pay_period.end_date;
4196: close c_pay_period ;

Line 4193: fnd_message.raise_error;

4189: fnd_message.set_token('L_PROC',l_proc);
4190: fnd_message.set_token('PERSON_ID',l_person_id);
4191: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4192: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4193: fnd_message.raise_error;
4194: end if;
4195: p_returned_date := l_pay_period.end_date;
4196: close c_pay_period ;
4197: --

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

4217: close c_pay_period;
4218: if g_debug then
4219: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',115);
4220: end if;
4221: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4222: fnd_message.set_token('DATE_CODE',p_date_cd);
4223: fnd_message.set_token('L_PROC',l_proc);
4224: fnd_message.set_token('PERSON_ID',l_person_id);
4225: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

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

4218: if g_debug then
4219: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',115);
4220: end if;
4221: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4222: fnd_message.set_token('DATE_CODE',p_date_cd);
4223: fnd_message.set_token('L_PROC',l_proc);
4224: fnd_message.set_token('PERSON_ID',l_person_id);
4225: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4226: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

4219: hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',115);
4220: end if;
4221: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4222: fnd_message.set_token('DATE_CODE',p_date_cd);
4223: fnd_message.set_token('L_PROC',l_proc);
4224: fnd_message.set_token('PERSON_ID',l_person_id);
4225: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4226: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4227: fnd_message.raise_error;

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

4220: end if;
4221: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4222: fnd_message.set_token('DATE_CODE',p_date_cd);
4223: fnd_message.set_token('L_PROC',l_proc);
4224: fnd_message.set_token('PERSON_ID',l_person_id);
4225: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4226: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4227: fnd_message.raise_error;
4228: end if;

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

4221: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4222: fnd_message.set_token('DATE_CODE',p_date_cd);
4223: fnd_message.set_token('L_PROC',l_proc);
4224: fnd_message.set_token('PERSON_ID',l_person_id);
4225: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4226: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4227: fnd_message.raise_error;
4228: end if;
4229: --

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

4222: fnd_message.set_token('DATE_CODE',p_date_cd);
4223: fnd_message.set_token('L_PROC',l_proc);
4224: fnd_message.set_token('PERSON_ID',l_person_id);
4225: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4226: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4227: fnd_message.raise_error;
4228: end if;
4229: --
4230: p_returned_date := l_pay_period.end_date;

Line 4227: fnd_message.raise_error;

4223: fnd_message.set_token('L_PROC',l_proc);
4224: fnd_message.set_token('PERSON_ID',l_person_id);
4225: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4226: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4227: fnd_message.raise_error;
4228: end if;
4229: --
4230: p_returned_date := l_pay_period.end_date;
4231: close c_pay_period ;

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

4248: --
4249: if c_next_pay_period%notfound then
4250: close c_next_pay_period;
4251: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',120);
4252: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4253: fnd_message.set_token('DATE_CODE',p_date_cd);
4254: fnd_message.set_token('PERSON_ID',l_person_id);
4255: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4256: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

4249: if c_next_pay_period%notfound then
4250: close c_next_pay_period;
4251: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',120);
4252: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4253: fnd_message.set_token('DATE_CODE',p_date_cd);
4254: fnd_message.set_token('PERSON_ID',l_person_id);
4255: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4256: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4257: fnd_message.raise_error;

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

4250: close c_next_pay_period;
4251: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',120);
4252: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4253: fnd_message.set_token('DATE_CODE',p_date_cd);
4254: fnd_message.set_token('PERSON_ID',l_person_id);
4255: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4256: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4257: fnd_message.raise_error;
4258: end if;

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

4251: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',120);
4252: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4253: fnd_message.set_token('DATE_CODE',p_date_cd);
4254: fnd_message.set_token('PERSON_ID',l_person_id);
4255: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4256: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4257: fnd_message.raise_error;
4258: end if;
4259: close c_next_pay_period;

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

4252: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4253: fnd_message.set_token('DATE_CODE',p_date_cd);
4254: fnd_message.set_token('PERSON_ID',l_person_id);
4255: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4256: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4257: fnd_message.raise_error;
4258: end if;
4259: close c_next_pay_period;
4260:

Line 4257: fnd_message.raise_error;

4253: fnd_message.set_token('DATE_CODE',p_date_cd);
4254: fnd_message.set_token('PERSON_ID',l_person_id);
4255: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4256: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4257: fnd_message.raise_error;
4258: end if;
4259: close c_next_pay_period;
4260:
4261: p_returned_date := l_next_pay_period.start_date;

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

4491: --
4492: if c_pil_popl%notfound then
4493: close c_pil_popl;
4494: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',81);
4495: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4496: fnd_message.set_token('DATE_CODE',p_date_cd);
4497: fnd_message.set_token('L_PROC',l_proc);
4498: fnd_message.raise_error;
4499: end if;

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

4492: if c_pil_popl%notfound then
4493: close c_pil_popl;
4494: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',81);
4495: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4496: fnd_message.set_token('DATE_CODE',p_date_cd);
4497: fnd_message.set_token('L_PROC',l_proc);
4498: fnd_message.raise_error;
4499: end if;
4500: --

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

4493: close c_pil_popl;
4494: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',81);
4495: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4496: fnd_message.set_token('DATE_CODE',p_date_cd);
4497: fnd_message.set_token('L_PROC',l_proc);
4498: fnd_message.raise_error;
4499: end if;
4500: --
4501: close c_pil_popl;

Line 4498: fnd_message.raise_error;

4494: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',81);
4495: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4496: fnd_message.set_token('DATE_CODE',p_date_cd);
4497: fnd_message.set_token('L_PROC',l_proc);
4498: fnd_message.raise_error;
4499: end if;
4500: --
4501: close c_pil_popl;
4502: --

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

4516: fetch c_cm_enrt_perd_end_dt into l_cm_date;
4517: if c_cm_enrt_perd_end_dt%notfound then
4518: close c_cm_enrt_perd_end_dt;
4519: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',86);
4520: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4521: fnd_message.set_token('DATE_CODE',p_date_cd);
4522: fnd_message.set_token('L_PROC',l_proc);
4523: fnd_message.raise_error;
4524: end if;

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

4517: if c_cm_enrt_perd_end_dt%notfound then
4518: close c_cm_enrt_perd_end_dt;
4519: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',86);
4520: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4521: fnd_message.set_token('DATE_CODE',p_date_cd);
4522: fnd_message.set_token('L_PROC',l_proc);
4523: fnd_message.raise_error;
4524: end if;
4525: --

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

4518: close c_cm_enrt_perd_end_dt;
4519: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',86);
4520: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4521: fnd_message.set_token('DATE_CODE',p_date_cd);
4522: fnd_message.set_token('L_PROC',l_proc);
4523: fnd_message.raise_error;
4524: end if;
4525: --
4526: close c_cm_enrt_perd_end_dt;

Line 4523: fnd_message.raise_error;

4519: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',86);
4520: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4521: fnd_message.set_token('DATE_CODE',p_date_cd);
4522: fnd_message.set_token('L_PROC',l_proc);
4523: fnd_message.raise_error;
4524: end if;
4525: --
4526: close c_cm_enrt_perd_end_dt;
4527: --

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

4538: fetch c_cm_enrt_perd_end_dt into l_cm_date;
4539: if c_cm_enrt_perd_end_dt%notfound then
4540: close c_cm_enrt_perd_end_dt;
4541: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',87);
4542: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4543: fnd_message.set_token('DATE_CODE',p_date_cd);
4544: fnd_message.set_token('L_PROC',l_proc);
4545: fnd_message.raise_error;
4546: end if;

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

4539: if c_cm_enrt_perd_end_dt%notfound then
4540: close c_cm_enrt_perd_end_dt;
4541: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',87);
4542: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4543: fnd_message.set_token('DATE_CODE',p_date_cd);
4544: fnd_message.set_token('L_PROC',l_proc);
4545: fnd_message.raise_error;
4546: end if;
4547: --

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

4540: close c_cm_enrt_perd_end_dt;
4541: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',87);
4542: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4543: fnd_message.set_token('DATE_CODE',p_date_cd);
4544: fnd_message.set_token('L_PROC',l_proc);
4545: fnd_message.raise_error;
4546: end if;
4547: --
4548: close c_cm_enrt_perd_end_dt;

Line 4545: fnd_message.raise_error;

4541: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',87);
4542: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4543: fnd_message.set_token('DATE_CODE',p_date_cd);
4544: fnd_message.set_token('L_PROC',l_proc);
4545: fnd_message.raise_error;
4546: end if;
4547: --
4548: close c_cm_enrt_perd_end_dt;
4549: --

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

4559: fetch c_cm_enrt_perd_end_dt into l_cm_date;
4560: if c_cm_enrt_perd_end_dt%notfound then
4561: close c_cm_enrt_perd_end_dt;
4562: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',89);
4563: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4564: fnd_message.set_token('DATE_CODE',p_date_cd);
4565: fnd_message.set_token('L_PROC',l_proc);
4566: fnd_message.raise_error;
4567: end if;

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

4560: if c_cm_enrt_perd_end_dt%notfound then
4561: close c_cm_enrt_perd_end_dt;
4562: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',89);
4563: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4564: fnd_message.set_token('DATE_CODE',p_date_cd);
4565: fnd_message.set_token('L_PROC',l_proc);
4566: fnd_message.raise_error;
4567: end if;
4568: --

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

4561: close c_cm_enrt_perd_end_dt;
4562: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',89);
4563: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4564: fnd_message.set_token('DATE_CODE',p_date_cd);
4565: fnd_message.set_token('L_PROC',l_proc);
4566: fnd_message.raise_error;
4567: end if;
4568: --
4569: close c_cm_enrt_perd_end_dt;

Line 4566: fnd_message.raise_error;

4562: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',89);
4563: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4564: fnd_message.set_token('DATE_CODE',p_date_cd);
4565: fnd_message.set_token('L_PROC',l_proc);
4566: fnd_message.raise_error;
4567: end if;
4568: --
4569: close c_cm_enrt_perd_end_dt;
4570: --

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

4580: fetch c_cm_enrt_perd_end_dt into l_cm_date;
4581: if c_cm_enrt_perd_end_dt%notfound then
4582: close c_cm_enrt_perd_end_dt;
4583: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',90);
4584: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4585: fnd_message.set_token('DATE_CODE',p_date_cd);
4586: fnd_message.set_token('L_PROC',l_proc);
4587: fnd_message.raise_error;
4588: end if;

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

4581: if c_cm_enrt_perd_end_dt%notfound then
4582: close c_cm_enrt_perd_end_dt;
4583: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',90);
4584: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4585: fnd_message.set_token('DATE_CODE',p_date_cd);
4586: fnd_message.set_token('L_PROC',l_proc);
4587: fnd_message.raise_error;
4588: end if;
4589: --

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

4582: close c_cm_enrt_perd_end_dt;
4583: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',90);
4584: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4585: fnd_message.set_token('DATE_CODE',p_date_cd);
4586: fnd_message.set_token('L_PROC',l_proc);
4587: fnd_message.raise_error;
4588: end if;
4589: --
4590: close c_cm_enrt_perd_end_dt;

Line 4587: fnd_message.raise_error;

4583: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',90);
4584: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4585: fnd_message.set_token('DATE_CODE',p_date_cd);
4586: fnd_message.set_token('L_PROC',l_proc);
4587: fnd_message.raise_error;
4588: end if;
4589: --
4590: close c_cm_enrt_perd_end_dt;
4591: --

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

4601: fetch c_cm_enrt_perd_end_dt into l_cm_date;
4602: if c_cm_enrt_perd_end_dt%notfound then
4603: close c_cm_enrt_perd_end_dt;
4604: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',91);
4605: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4606: fnd_message.set_token('DATE_CODE',p_date_cd);
4607: fnd_message.set_token('L_PROC',l_proc);
4608: fnd_message.raise_error;
4609: end if;

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

4602: if c_cm_enrt_perd_end_dt%notfound then
4603: close c_cm_enrt_perd_end_dt;
4604: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',91);
4605: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4606: fnd_message.set_token('DATE_CODE',p_date_cd);
4607: fnd_message.set_token('L_PROC',l_proc);
4608: fnd_message.raise_error;
4609: end if;
4610: --

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

4603: close c_cm_enrt_perd_end_dt;
4604: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',91);
4605: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4606: fnd_message.set_token('DATE_CODE',p_date_cd);
4607: fnd_message.set_token('L_PROC',l_proc);
4608: fnd_message.raise_error;
4609: end if;
4610: --
4611: close c_cm_enrt_perd_end_dt;

Line 4608: fnd_message.raise_error;

4604: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',91);
4605: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4606: fnd_message.set_token('DATE_CODE',p_date_cd);
4607: fnd_message.set_token('L_PROC',l_proc);
4608: fnd_message.raise_error;
4609: end if;
4610: --
4611: close c_cm_enrt_perd_end_dt;
4612: --

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

4623: fetch c_cm_dflt_asnd_dt into l_cm_date;
4624: if c_cm_dflt_asnd_dt%notfound then
4625: close c_cm_dflt_asnd_dt;
4626: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',92);
4627: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4628: fnd_message.set_token('DATE_CODE',p_date_cd);
4629: fnd_message.set_token('L_PROC',l_proc);
4630: fnd_message.raise_error;
4631: end if;

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

4624: if c_cm_dflt_asnd_dt%notfound then
4625: close c_cm_dflt_asnd_dt;
4626: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',92);
4627: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4628: fnd_message.set_token('DATE_CODE',p_date_cd);
4629: fnd_message.set_token('L_PROC',l_proc);
4630: fnd_message.raise_error;
4631: end if;
4632: --

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

4625: close c_cm_dflt_asnd_dt;
4626: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',92);
4627: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4628: fnd_message.set_token('DATE_CODE',p_date_cd);
4629: fnd_message.set_token('L_PROC',l_proc);
4630: fnd_message.raise_error;
4631: end if;
4632: --
4633: close c_cm_dflt_asnd_dt;

Line 4630: fnd_message.raise_error;

4626: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',92);
4627: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4628: fnd_message.set_token('DATE_CODE',p_date_cd);
4629: fnd_message.set_token('L_PROC',l_proc);
4630: fnd_message.raise_error;
4631: end if;
4632: --
4633: close c_cm_dflt_asnd_dt;
4634: --

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

4644: fetch c_cm_elig_prtn_strt_dt into l_cm_date;
4645: if c_cm_elig_prtn_strt_dt%notfound then
4646: close c_cm_elig_prtn_strt_dt;
4647: -- hr_utility.set_location('BEN_91386_FIRST_INELIG',81);
4648: fnd_message.set_name('BEN', 'BEN_91386_FIRST_INELIG');
4649: fnd_message.set_token('DATE_CODE',p_date_cd);
4650: fnd_message.set_token('PROC',l_proc);
4651: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4652: fnd_message.set_token('BG_ID',to_char(p_business_group_id));

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

4645: if c_cm_elig_prtn_strt_dt%notfound then
4646: close c_cm_elig_prtn_strt_dt;
4647: -- hr_utility.set_location('BEN_91386_FIRST_INELIG',81);
4648: fnd_message.set_name('BEN', 'BEN_91386_FIRST_INELIG');
4649: fnd_message.set_token('DATE_CODE',p_date_cd);
4650: fnd_message.set_token('PROC',l_proc);
4651: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4652: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4653: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

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

4646: close c_cm_elig_prtn_strt_dt;
4647: -- hr_utility.set_location('BEN_91386_FIRST_INELIG',81);
4648: fnd_message.set_name('BEN', 'BEN_91386_FIRST_INELIG');
4649: fnd_message.set_token('DATE_CODE',p_date_cd);
4650: fnd_message.set_token('PROC',l_proc);
4651: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4652: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4653: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4654: fnd_message.raise_error;

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

4647: -- hr_utility.set_location('BEN_91386_FIRST_INELIG',81);
4648: fnd_message.set_name('BEN', 'BEN_91386_FIRST_INELIG');
4649: fnd_message.set_token('DATE_CODE',p_date_cd);
4650: fnd_message.set_token('PROC',l_proc);
4651: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4652: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4653: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4654: fnd_message.raise_error;
4655: end if;

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

4648: fnd_message.set_name('BEN', 'BEN_91386_FIRST_INELIG');
4649: fnd_message.set_token('DATE_CODE',p_date_cd);
4650: fnd_message.set_token('PROC',l_proc);
4651: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4652: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4653: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4654: fnd_message.raise_error;
4655: end if;
4656: close c_cm_elig_prtn_strt_dt;

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

4649: fnd_message.set_token('DATE_CODE',p_date_cd);
4650: fnd_message.set_token('PROC',l_proc);
4651: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4652: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4653: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4654: fnd_message.raise_error;
4655: end if;
4656: close c_cm_elig_prtn_strt_dt;
4657: --

Line 4654: fnd_message.raise_error;

4650: fnd_message.set_token('PROC',l_proc);
4651: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4652: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4653: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4654: fnd_message.raise_error;
4655: end if;
4656: close c_cm_elig_prtn_strt_dt;
4657: --
4658: p_returned_date := l_cm_date - 14;

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

4665: fetch c_cm_elig_prtn_end_dt into l_cm_date;
4666: if c_cm_elig_prtn_end_dt%notfound then
4667: close c_cm_elig_prtn_end_dt;
4668: -- hr_utility.set_location('BEN_91386_FIRST_INELIG',93);
4669: fnd_message.set_name('BEN', 'BEN_91386_FIRST_INELIG');
4670: fnd_message.set_token('DATE_CODE',p_date_cd);
4671: fnd_message.set_token('PROC',l_proc);
4672: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4673: fnd_message.set_token('BG_ID',to_char(p_business_group_id));

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

4666: if c_cm_elig_prtn_end_dt%notfound then
4667: close c_cm_elig_prtn_end_dt;
4668: -- hr_utility.set_location('BEN_91386_FIRST_INELIG',93);
4669: fnd_message.set_name('BEN', 'BEN_91386_FIRST_INELIG');
4670: fnd_message.set_token('DATE_CODE',p_date_cd);
4671: fnd_message.set_token('PROC',l_proc);
4672: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4673: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4674: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

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

4667: close c_cm_elig_prtn_end_dt;
4668: -- hr_utility.set_location('BEN_91386_FIRST_INELIG',93);
4669: fnd_message.set_name('BEN', 'BEN_91386_FIRST_INELIG');
4670: fnd_message.set_token('DATE_CODE',p_date_cd);
4671: fnd_message.set_token('PROC',l_proc);
4672: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4673: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4674: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4675: fnd_message.raise_error;

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

4668: -- hr_utility.set_location('BEN_91386_FIRST_INELIG',93);
4669: fnd_message.set_name('BEN', 'BEN_91386_FIRST_INELIG');
4670: fnd_message.set_token('DATE_CODE',p_date_cd);
4671: fnd_message.set_token('PROC',l_proc);
4672: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4673: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4674: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4675: fnd_message.raise_error;
4676: end if;

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

4669: fnd_message.set_name('BEN', 'BEN_91386_FIRST_INELIG');
4670: fnd_message.set_token('DATE_CODE',p_date_cd);
4671: fnd_message.set_token('PROC',l_proc);
4672: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4673: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4674: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4675: fnd_message.raise_error;
4676: end if;
4677: close c_cm_elig_prtn_end_dt;

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

4670: fnd_message.set_token('DATE_CODE',p_date_cd);
4671: fnd_message.set_token('PROC',l_proc);
4672: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4673: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4674: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4675: fnd_message.raise_error;
4676: end if;
4677: close c_cm_elig_prtn_end_dt;
4678: --

Line 4675: fnd_message.raise_error;

4671: fnd_message.set_token('PROC',l_proc);
4672: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
4673: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
4674: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
4675: fnd_message.raise_error;
4676: end if;
4677: close c_cm_elig_prtn_end_dt;
4678: --
4679: p_returned_date := l_cm_date - 14;

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

4688: fetch c_cm_enrt_perd_end_dt into l_cm_date;
4689: if c_cm_enrt_perd_end_dt%notfound then
4690: close c_cm_enrt_perd_end_dt;
4691: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',88);
4692: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4693: fnd_message.set_token('DATE_CODE',p_date_cd);
4694: fnd_message.set_token('L_PROC',l_proc);
4695: fnd_message.raise_error;
4696: end if;

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

4689: if c_cm_enrt_perd_end_dt%notfound then
4690: close c_cm_enrt_perd_end_dt;
4691: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',88);
4692: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4693: fnd_message.set_token('DATE_CODE',p_date_cd);
4694: fnd_message.set_token('L_PROC',l_proc);
4695: fnd_message.raise_error;
4696: end if;
4697: --

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

4690: close c_cm_enrt_perd_end_dt;
4691: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',88);
4692: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4693: fnd_message.set_token('DATE_CODE',p_date_cd);
4694: fnd_message.set_token('L_PROC',l_proc);
4695: fnd_message.raise_error;
4696: end if;
4697: --
4698: close c_cm_enrt_perd_end_dt;

Line 4695: fnd_message.raise_error;

4691: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',88);
4692: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4693: fnd_message.set_token('DATE_CODE',p_date_cd);
4694: fnd_message.set_token('L_PROC',l_proc);
4695: fnd_message.raise_error;
4696: end if;
4697: --
4698: close c_cm_enrt_perd_end_dt;
4699: --

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

4708: fetch c_cm_auto_asnd_dt into l_cm_date;
4709: if c_cm_auto_asnd_dt%notfound then
4710: close c_cm_auto_asnd_dt;
4711: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',98);
4712: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4713: fnd_message.set_token('DATE_CODE',p_date_cd);
4714: fnd_message.set_token('L_PROC',l_proc);
4715: fnd_message.raise_error;
4716: end if;

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

4709: if c_cm_auto_asnd_dt%notfound then
4710: close c_cm_auto_asnd_dt;
4711: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',98);
4712: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4713: fnd_message.set_token('DATE_CODE',p_date_cd);
4714: fnd_message.set_token('L_PROC',l_proc);
4715: fnd_message.raise_error;
4716: end if;
4717: close c_cm_auto_asnd_dt;

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

4710: close c_cm_auto_asnd_dt;
4711: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',98);
4712: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4713: fnd_message.set_token('DATE_CODE',p_date_cd);
4714: fnd_message.set_token('L_PROC',l_proc);
4715: fnd_message.raise_error;
4716: end if;
4717: close c_cm_auto_asnd_dt;
4718: --

Line 4715: fnd_message.raise_error;

4711: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',98);
4712: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
4713: fnd_message.set_token('DATE_CODE',p_date_cd);
4714: fnd_message.set_token('L_PROC',l_proc);
4715: fnd_message.raise_error;
4716: end if;
4717: close c_cm_auto_asnd_dt;
4718: --
4719: p_returned_date := l_cm_date;

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

4811: --
4812: close c_pay_period_for_date;
4813: -- hr_utility.set_location('BEN_92380_CANNOT_CALC_LFDPPCF',96);
4814: -- hr_utility.set_location('l_lf_evt_ocrd_dt'||to_char(l_lf_evt_ocrd_dt),96);
4815: fnd_message.set_name('BEN','BEN_92380_CANNOT_CALC_LFDPPCF');
4816: fnd_message.set_token('L_PROC',l_proc);
4817: fnd_message.set_token('PERSON_ID',l_person_id);
4818: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4819: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

4812: close c_pay_period_for_date;
4813: -- hr_utility.set_location('BEN_92380_CANNOT_CALC_LFDPPCF',96);
4814: -- hr_utility.set_location('l_lf_evt_ocrd_dt'||to_char(l_lf_evt_ocrd_dt),96);
4815: fnd_message.set_name('BEN','BEN_92380_CANNOT_CALC_LFDPPCF');
4816: fnd_message.set_token('L_PROC',l_proc);
4817: fnd_message.set_token('PERSON_ID',l_person_id);
4818: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4819: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4820: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);

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

4813: -- hr_utility.set_location('BEN_92380_CANNOT_CALC_LFDPPCF',96);
4814: -- hr_utility.set_location('l_lf_evt_ocrd_dt'||to_char(l_lf_evt_ocrd_dt),96);
4815: fnd_message.set_name('BEN','BEN_92380_CANNOT_CALC_LFDPPCF');
4816: fnd_message.set_token('L_PROC',l_proc);
4817: fnd_message.set_token('PERSON_ID',l_person_id);
4818: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4819: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4820: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);
4821: fnd_message.raise_error;

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

4814: -- hr_utility.set_location('l_lf_evt_ocrd_dt'||to_char(l_lf_evt_ocrd_dt),96);
4815: fnd_message.set_name('BEN','BEN_92380_CANNOT_CALC_LFDPPCF');
4816: fnd_message.set_token('L_PROC',l_proc);
4817: fnd_message.set_token('PERSON_ID',l_person_id);
4818: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4819: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4820: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);
4821: fnd_message.raise_error;
4822: --

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

4815: fnd_message.set_name('BEN','BEN_92380_CANNOT_CALC_LFDPPCF');
4816: fnd_message.set_token('L_PROC',l_proc);
4817: fnd_message.set_token('PERSON_ID',l_person_id);
4818: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4819: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4820: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);
4821: fnd_message.raise_error;
4822: --
4823: end if;

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

4816: fnd_message.set_token('L_PROC',l_proc);
4817: fnd_message.set_token('PERSON_ID',l_person_id);
4818: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4819: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4820: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);
4821: fnd_message.raise_error;
4822: --
4823: end if;
4824: --

Line 4821: fnd_message.raise_error;

4817: fnd_message.set_token('PERSON_ID',l_person_id);
4818: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4819: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4820: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);
4821: fnd_message.raise_error;
4822: --
4823: end if;
4824: --
4825: close c_pay_period_for_date;

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

4835: --
4836: if c_next_pay_period%notfound then
4837: close c_next_pay_period;
4838: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',125);
4839: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4840: fnd_message.set_token('DATE_CODE',p_date_cd);
4841: fnd_message.set_token('PERSON_ID',l_person_id);
4842: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4843: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

4836: if c_next_pay_period%notfound then
4837: close c_next_pay_period;
4838: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',125);
4839: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4840: fnd_message.set_token('DATE_CODE',p_date_cd);
4841: fnd_message.set_token('PERSON_ID',l_person_id);
4842: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4843: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4844: fnd_message.raise_error;

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

4837: close c_next_pay_period;
4838: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',125);
4839: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4840: fnd_message.set_token('DATE_CODE',p_date_cd);
4841: fnd_message.set_token('PERSON_ID',l_person_id);
4842: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4843: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4844: fnd_message.raise_error;
4845: end if;

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

4838: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',125);
4839: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4840: fnd_message.set_token('DATE_CODE',p_date_cd);
4841: fnd_message.set_token('PERSON_ID',l_person_id);
4842: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4843: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4844: fnd_message.raise_error;
4845: end if;
4846: --

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

4839: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4840: fnd_message.set_token('DATE_CODE',p_date_cd);
4841: fnd_message.set_token('PERSON_ID',l_person_id);
4842: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4843: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4844: fnd_message.raise_error;
4845: end if;
4846: --
4847: p_returned_date := l_next_pay_period.start_date;

Line 4844: fnd_message.raise_error;

4840: fnd_message.set_token('DATE_CODE',p_date_cd);
4841: fnd_message.set_token('PERSON_ID',l_person_id);
4842: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4843: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4844: fnd_message.raise_error;
4845: end if;
4846: --
4847: p_returned_date := l_next_pay_period.start_date;
4848: --

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

4861: --
4862: close c_pay_period_for_date;
4863: -- hr_utility.set_location('BEN_92380_CANNOT_CALC_LFDPPCF',97);
4864: -- hr_utility.set_location('l_recorded_date'||to_char(l_recorded_date),97);
4865: fnd_message.set_name('BEN','BEN_92380_CANNOT_CALC_LFDPPCF');
4866: fnd_message.set_token('L_PROC',l_proc);
4867: fnd_message.set_token('PERSON_ID',l_person_id);
4868: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4869: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

4862: close c_pay_period_for_date;
4863: -- hr_utility.set_location('BEN_92380_CANNOT_CALC_LFDPPCF',97);
4864: -- hr_utility.set_location('l_recorded_date'||to_char(l_recorded_date),97);
4865: fnd_message.set_name('BEN','BEN_92380_CANNOT_CALC_LFDPPCF');
4866: fnd_message.set_token('L_PROC',l_proc);
4867: fnd_message.set_token('PERSON_ID',l_person_id);
4868: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4869: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4870: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);

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

4863: -- hr_utility.set_location('BEN_92380_CANNOT_CALC_LFDPPCF',97);
4864: -- hr_utility.set_location('l_recorded_date'||to_char(l_recorded_date),97);
4865: fnd_message.set_name('BEN','BEN_92380_CANNOT_CALC_LFDPPCF');
4866: fnd_message.set_token('L_PROC',l_proc);
4867: fnd_message.set_token('PERSON_ID',l_person_id);
4868: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4869: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4870: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);
4871: fnd_message.raise_error;

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

4864: -- hr_utility.set_location('l_recorded_date'||to_char(l_recorded_date),97);
4865: fnd_message.set_name('BEN','BEN_92380_CANNOT_CALC_LFDPPCF');
4866: fnd_message.set_token('L_PROC',l_proc);
4867: fnd_message.set_token('PERSON_ID',l_person_id);
4868: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4869: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4870: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);
4871: fnd_message.raise_error;
4872: --

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

4865: fnd_message.set_name('BEN','BEN_92380_CANNOT_CALC_LFDPPCF');
4866: fnd_message.set_token('L_PROC',l_proc);
4867: fnd_message.set_token('PERSON_ID',l_person_id);
4868: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4869: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4870: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);
4871: fnd_message.raise_error;
4872: --
4873: end if;

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

4866: fnd_message.set_token('L_PROC',l_proc);
4867: fnd_message.set_token('PERSON_ID',l_person_id);
4868: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4869: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4870: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);
4871: fnd_message.raise_error;
4872: --
4873: end if;
4874: --

Line 4871: fnd_message.raise_error;

4867: fnd_message.set_token('PERSON_ID',l_person_id);
4868: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4869: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4870: fnd_message.set_token('LF_EVT_OCRD_DT',l_lf_evt_ocrd_dt);
4871: fnd_message.raise_error;
4872: --
4873: end if;
4874: --
4875: close c_pay_period_for_date;

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

4887: --
4888: if c_next_pay_period%notfound then
4889: close c_next_pay_period;
4890: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',130);
4891: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4892: fnd_message.set_token('DATE_CODE',p_date_cd);
4893: fnd_message.set_token('PERSON_ID',l_person_id);
4894: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4895: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

4888: if c_next_pay_period%notfound then
4889: close c_next_pay_period;
4890: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',130);
4891: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4892: fnd_message.set_token('DATE_CODE',p_date_cd);
4893: fnd_message.set_token('PERSON_ID',l_person_id);
4894: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4895: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4896: fnd_message.raise_error;

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

4889: close c_next_pay_period;
4890: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',130);
4891: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4892: fnd_message.set_token('DATE_CODE',p_date_cd);
4893: fnd_message.set_token('PERSON_ID',l_person_id);
4894: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4895: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4896: fnd_message.raise_error;
4897: end if;

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

4890: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',130);
4891: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4892: fnd_message.set_token('DATE_CODE',p_date_cd);
4893: fnd_message.set_token('PERSON_ID',l_person_id);
4894: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4895: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4896: fnd_message.raise_error;
4897: end if;
4898: --

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

4891: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
4892: fnd_message.set_token('DATE_CODE',p_date_cd);
4893: fnd_message.set_token('PERSON_ID',l_person_id);
4894: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4895: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4896: fnd_message.raise_error;
4897: end if;
4898: --
4899: p_returned_date := l_next_pay_period.start_date;

Line 4896: fnd_message.raise_error;

4892: fnd_message.set_token('DATE_CODE',p_date_cd);
4893: fnd_message.set_token('PERSON_ID',l_person_id);
4894: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
4895: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
4896: fnd_message.raise_error;
4897: end if;
4898: --
4899: p_returned_date := l_next_pay_period.start_date;
4900: --

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

5080: fetch c_cm_dflt_asnd_dt into l_cm_date;
5081: if c_cm_dflt_asnd_dt%notfound then
5082: close c_cm_dflt_asnd_dt;
5083: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',96);
5084: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
5085: fnd_message.set_token('DATE_CODE',p_date_cd);
5086: fnd_message.set_token('L_PROC',l_proc);
5087: fnd_message.raise_error;
5088: end if;

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

5081: if c_cm_dflt_asnd_dt%notfound then
5082: close c_cm_dflt_asnd_dt;
5083: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',96);
5084: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
5085: fnd_message.set_token('DATE_CODE',p_date_cd);
5086: fnd_message.set_token('L_PROC',l_proc);
5087: fnd_message.raise_error;
5088: end if;
5089: close c_cm_dflt_asnd_dt;

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

5082: close c_cm_dflt_asnd_dt;
5083: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',96);
5084: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
5085: fnd_message.set_token('DATE_CODE',p_date_cd);
5086: fnd_message.set_token('L_PROC',l_proc);
5087: fnd_message.raise_error;
5088: end if;
5089: close c_cm_dflt_asnd_dt;
5090: --

Line 5087: fnd_message.raise_error;

5083: -- hr_utility.set_location('BEN_91942_PEL_NOT_FOUND',96);
5084: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
5085: fnd_message.set_token('DATE_CODE',p_date_cd);
5086: fnd_message.set_token('L_PROC',l_proc);
5087: fnd_message.raise_error;
5088: end if;
5089: close c_cm_dflt_asnd_dt;
5090: --
5091: p_returned_date := l_cm_date;

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

5100: fetch c_cm_elig_prtn_strt_dt into l_cm_date;
5101: if c_cm_elig_prtn_strt_dt%notfound then
5102: close c_cm_elig_prtn_strt_dt;
5103: -- hr_utility.set_location('BEN_92381_ELIG_PER_NOT_FOUND',96);
5104: fnd_message.set_name('BEN', 'BEN_92381_ELIG_PER_NOT_FOUND');
5105: fnd_message.set_token('PROC',l_proc);
5106: fnd_message.set_token('DATE_CODE',p_date_cd);
5107: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5108: fnd_message.set_token('BG_ID',to_char(p_business_group_id));

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

5101: if c_cm_elig_prtn_strt_dt%notfound then
5102: close c_cm_elig_prtn_strt_dt;
5103: -- hr_utility.set_location('BEN_92381_ELIG_PER_NOT_FOUND',96);
5104: fnd_message.set_name('BEN', 'BEN_92381_ELIG_PER_NOT_FOUND');
5105: fnd_message.set_token('PROC',l_proc);
5106: fnd_message.set_token('DATE_CODE',p_date_cd);
5107: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5108: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5109: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

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

5102: close c_cm_elig_prtn_strt_dt;
5103: -- hr_utility.set_location('BEN_92381_ELIG_PER_NOT_FOUND',96);
5104: fnd_message.set_name('BEN', 'BEN_92381_ELIG_PER_NOT_FOUND');
5105: fnd_message.set_token('PROC',l_proc);
5106: fnd_message.set_token('DATE_CODE',p_date_cd);
5107: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5108: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5109: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5110: fnd_message.raise_error;

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

5103: -- hr_utility.set_location('BEN_92381_ELIG_PER_NOT_FOUND',96);
5104: fnd_message.set_name('BEN', 'BEN_92381_ELIG_PER_NOT_FOUND');
5105: fnd_message.set_token('PROC',l_proc);
5106: fnd_message.set_token('DATE_CODE',p_date_cd);
5107: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5108: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5109: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5110: fnd_message.raise_error;
5111: end if;

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

5104: fnd_message.set_name('BEN', 'BEN_92381_ELIG_PER_NOT_FOUND');
5105: fnd_message.set_token('PROC',l_proc);
5106: fnd_message.set_token('DATE_CODE',p_date_cd);
5107: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5108: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5109: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5110: fnd_message.raise_error;
5111: end if;
5112: close c_cm_elig_prtn_strt_dt;

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

5105: fnd_message.set_token('PROC',l_proc);
5106: fnd_message.set_token('DATE_CODE',p_date_cd);
5107: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5108: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5109: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5110: fnd_message.raise_error;
5111: end if;
5112: close c_cm_elig_prtn_strt_dt;
5113: --

Line 5110: fnd_message.raise_error;

5106: fnd_message.set_token('DATE_CODE',p_date_cd);
5107: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5108: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5109: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5110: fnd_message.raise_error;
5111: end if;
5112: close c_cm_elig_prtn_strt_dt;
5113: --
5114: p_returned_date := l_cm_date;

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

5123: fetch c_cm_elig_prtn_end_dt into l_cm_date;
5124: if c_cm_elig_prtn_end_dt%notfound then
5125: close c_cm_elig_prtn_end_dt;
5126: -- hr_utility.set_location('BEN_92381_ELIG_PER_NOT_FOUND',98);
5127: fnd_message.set_name('BEN', 'BEN_92381_ELIG_PER_NOT_FOUND');
5128: fnd_message.set_token('PROC',l_proc);
5129: fnd_message.set_token('DATE_CODE',p_date_cd);
5130: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5131: fnd_message.set_token('BG_ID',to_char(p_business_group_id));

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

5124: if c_cm_elig_prtn_end_dt%notfound then
5125: close c_cm_elig_prtn_end_dt;
5126: -- hr_utility.set_location('BEN_92381_ELIG_PER_NOT_FOUND',98);
5127: fnd_message.set_name('BEN', 'BEN_92381_ELIG_PER_NOT_FOUND');
5128: fnd_message.set_token('PROC',l_proc);
5129: fnd_message.set_token('DATE_CODE',p_date_cd);
5130: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5131: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5132: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));

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

5125: close c_cm_elig_prtn_end_dt;
5126: -- hr_utility.set_location('BEN_92381_ELIG_PER_NOT_FOUND',98);
5127: fnd_message.set_name('BEN', 'BEN_92381_ELIG_PER_NOT_FOUND');
5128: fnd_message.set_token('PROC',l_proc);
5129: fnd_message.set_token('DATE_CODE',p_date_cd);
5130: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5131: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5132: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5133: fnd_message.raise_error;

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

5126: -- hr_utility.set_location('BEN_92381_ELIG_PER_NOT_FOUND',98);
5127: fnd_message.set_name('BEN', 'BEN_92381_ELIG_PER_NOT_FOUND');
5128: fnd_message.set_token('PROC',l_proc);
5129: fnd_message.set_token('DATE_CODE',p_date_cd);
5130: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5131: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5132: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5133: fnd_message.raise_error;
5134: end if;

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

5127: fnd_message.set_name('BEN', 'BEN_92381_ELIG_PER_NOT_FOUND');
5128: fnd_message.set_token('PROC',l_proc);
5129: fnd_message.set_token('DATE_CODE',p_date_cd);
5130: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5131: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5132: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5133: fnd_message.raise_error;
5134: end if;
5135: close c_cm_elig_prtn_end_dt;

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

5128: fnd_message.set_token('PROC',l_proc);
5129: fnd_message.set_token('DATE_CODE',p_date_cd);
5130: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5131: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5132: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5133: fnd_message.raise_error;
5134: end if;
5135: close c_cm_elig_prtn_end_dt;
5136: --

Line 5133: fnd_message.raise_error;

5129: fnd_message.set_token('DATE_CODE',p_date_cd);
5130: fnd_message.set_token('PERSON_ID',to_char(p_person_id));
5131: fnd_message.set_token('BG_ID',to_char(p_business_group_id));
5132: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
5133: fnd_message.raise_error;
5134: end if;
5135: close c_cm_elig_prtn_end_dt;
5136: --
5137: p_returned_date := l_cm_date;

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

5145: open c_cm_enrt_perd_end_dt;
5146: fetch c_cm_enrt_perd_end_dt into l_cm_date;
5147: if c_cm_enrt_perd_end_dt%notfound then
5148: close c_cm_enrt_perd_end_dt;
5149: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
5150: fnd_message.set_token('DATE_CODE',p_date_cd);
5151: fnd_message.set_token('L_PROC',l_proc);
5152: fnd_message.raise_error;
5153: end if;

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

5146: fetch c_cm_enrt_perd_end_dt into l_cm_date;
5147: if c_cm_enrt_perd_end_dt%notfound then
5148: close c_cm_enrt_perd_end_dt;
5149: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
5150: fnd_message.set_token('DATE_CODE',p_date_cd);
5151: fnd_message.set_token('L_PROC',l_proc);
5152: fnd_message.raise_error;
5153: end if;
5154: close c_cm_enrt_perd_end_dt;

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

5147: if c_cm_enrt_perd_end_dt%notfound then
5148: close c_cm_enrt_perd_end_dt;
5149: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
5150: fnd_message.set_token('DATE_CODE',p_date_cd);
5151: fnd_message.set_token('L_PROC',l_proc);
5152: fnd_message.raise_error;
5153: end if;
5154: close c_cm_enrt_perd_end_dt;
5155: --

Line 5152: fnd_message.raise_error;

5148: close c_cm_enrt_perd_end_dt;
5149: fnd_message.set_name('BEN', 'BEN_91942_PEL_NOT_FOUND');
5150: fnd_message.set_token('DATE_CODE',p_date_cd);
5151: fnd_message.set_token('L_PROC',l_proc);
5152: fnd_message.raise_error;
5153: end if;
5154: close c_cm_enrt_perd_end_dt;
5155: --
5156: p_returned_date := l_cm_date;

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

5292: fetch c_pay_period into l_pay_period;
5293: if c_pay_period%notfound then
5294: close c_pay_period;
5295: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',135);
5296: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5297: fnd_message.set_token('DATE_CODE',p_date_cd);
5298: fnd_message.set_token('PERSON_ID',l_person_id);
5299: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5300: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

5293: if c_pay_period%notfound then
5294: close c_pay_period;
5295: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',135);
5296: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5297: fnd_message.set_token('DATE_CODE',p_date_cd);
5298: fnd_message.set_token('PERSON_ID',l_person_id);
5299: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5300: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5301: fnd_message.raise_error;

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

5294: close c_pay_period;
5295: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',135);
5296: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5297: fnd_message.set_token('DATE_CODE',p_date_cd);
5298: fnd_message.set_token('PERSON_ID',l_person_id);
5299: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5300: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5301: fnd_message.raise_error;
5302: end if;

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

5295: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',135);
5296: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5297: fnd_message.set_token('DATE_CODE',p_date_cd);
5298: fnd_message.set_token('PERSON_ID',l_person_id);
5299: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5300: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5301: fnd_message.raise_error;
5302: end if;
5303: --

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

5296: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5297: fnd_message.set_token('DATE_CODE',p_date_cd);
5298: fnd_message.set_token('PERSON_ID',l_person_id);
5299: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5300: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5301: fnd_message.raise_error;
5302: end if;
5303: --
5304: close c_pay_period ;

Line 5301: fnd_message.raise_error;

5297: fnd_message.set_token('DATE_CODE',p_date_cd);
5298: fnd_message.set_token('PERSON_ID',l_person_id);
5299: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5300: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5301: fnd_message.raise_error;
5302: end if;
5303: --
5304: close c_pay_period ;
5305: --

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

5314: --
5315: if c_next_pay_period%notfound then
5316: close c_next_pay_period;
5317: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',140);
5318: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5319: fnd_message.set_token('DATE_CODE',p_date_cd);
5320: fnd_message.set_token('PERSON_ID',l_person_id);
5321: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5322: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

5315: if c_next_pay_period%notfound then
5316: close c_next_pay_period;
5317: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',140);
5318: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5319: fnd_message.set_token('DATE_CODE',p_date_cd);
5320: fnd_message.set_token('PERSON_ID',l_person_id);
5321: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5322: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5323: fnd_message.raise_error;

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

5316: close c_next_pay_period;
5317: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',140);
5318: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5319: fnd_message.set_token('DATE_CODE',p_date_cd);
5320: fnd_message.set_token('PERSON_ID',l_person_id);
5321: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5322: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5323: fnd_message.raise_error;
5324: end if;

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

5317: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',140);
5318: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5319: fnd_message.set_token('DATE_CODE',p_date_cd);
5320: fnd_message.set_token('PERSON_ID',l_person_id);
5321: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5322: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5323: fnd_message.raise_error;
5324: end if;
5325: --

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

5318: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5319: fnd_message.set_token('DATE_CODE',p_date_cd);
5320: fnd_message.set_token('PERSON_ID',l_person_id);
5321: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5322: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5323: fnd_message.raise_error;
5324: end if;
5325: --
5326: p_returned_date := l_next_pay_period.start_date;

Line 5323: fnd_message.raise_error;

5319: fnd_message.set_token('DATE_CODE',p_date_cd);
5320: fnd_message.set_token('PERSON_ID',l_person_id);
5321: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5322: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5323: fnd_message.raise_error;
5324: end if;
5325: --
5326: p_returned_date := l_next_pay_period.start_date;
5327: --

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

5730: if c_pay_period_for_date%notfound then
5731: --
5732: close c_pay_period_for_date;
5733: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',145);
5734: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5735: fnd_message.set_token('DATE_CODE',p_date_cd);
5736: fnd_message.set_token('PERSON_ID',l_person_id);
5737: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5738: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

5731: --
5732: close c_pay_period_for_date;
5733: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',145);
5734: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5735: fnd_message.set_token('DATE_CODE',p_date_cd);
5736: fnd_message.set_token('PERSON_ID',l_person_id);
5737: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5738: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5739: fnd_message.raise_error;

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

5732: close c_pay_period_for_date;
5733: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',145);
5734: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5735: fnd_message.set_token('DATE_CODE',p_date_cd);
5736: fnd_message.set_token('PERSON_ID',l_person_id);
5737: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5738: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5739: fnd_message.raise_error;
5740: --

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

5733: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',145);
5734: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5735: fnd_message.set_token('DATE_CODE',p_date_cd);
5736: fnd_message.set_token('PERSON_ID',l_person_id);
5737: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5738: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5739: fnd_message.raise_error;
5740: --
5741: end if;

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

5734: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5735: fnd_message.set_token('DATE_CODE',p_date_cd);
5736: fnd_message.set_token('PERSON_ID',l_person_id);
5737: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5738: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5739: fnd_message.raise_error;
5740: --
5741: end if;
5742: --

Line 5739: fnd_message.raise_error;

5735: fnd_message.set_token('DATE_CODE',p_date_cd);
5736: fnd_message.set_token('PERSON_ID',l_person_id);
5737: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5738: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5739: fnd_message.raise_error;
5740: --
5741: end if;
5742: --
5743: close c_pay_period_for_date;

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

5771: if c_pre_pay_period%notfound then
5772: --
5773: close c_pre_pay_period;
5774: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',150);
5775: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5776: fnd_message.set_token('DATE_CODE',p_date_cd);
5777: fnd_message.set_token('PERSON_ID',l_person_id);
5778: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5779: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

5772: --
5773: close c_pre_pay_period;
5774: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',150);
5775: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5776: fnd_message.set_token('DATE_CODE',p_date_cd);
5777: fnd_message.set_token('PERSON_ID',l_person_id);
5778: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5779: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5780: fnd_message.raise_error;

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

5773: close c_pre_pay_period;
5774: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',150);
5775: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5776: fnd_message.set_token('DATE_CODE',p_date_cd);
5777: fnd_message.set_token('PERSON_ID',l_person_id);
5778: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5779: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5780: fnd_message.raise_error;
5781: --

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

5774: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',150);
5775: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5776: fnd_message.set_token('DATE_CODE',p_date_cd);
5777: fnd_message.set_token('PERSON_ID',l_person_id);
5778: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5779: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5780: fnd_message.raise_error;
5781: --
5782: end if;

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

5775: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
5776: fnd_message.set_token('DATE_CODE',p_date_cd);
5777: fnd_message.set_token('PERSON_ID',l_person_id);
5778: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5779: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5780: fnd_message.raise_error;
5781: --
5782: end if;
5783: --

Line 5780: fnd_message.raise_error;

5776: fnd_message.set_token('DATE_CODE',p_date_cd);
5777: fnd_message.set_token('PERSON_ID',l_person_id);
5778: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
5779: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
5780: fnd_message.raise_error;
5781: --
5782: end if;
5783: --
5784: close c_pre_pay_period;

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

6024: l_end_date;
6025: --
6026: if c_pay_period_for_date%notfound then
6027: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',160);
6028: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6029: fnd_message.set_token('DATE_CODE',p_date_cd);
6030: fnd_message.set_token('PERSON_ID',l_person_id);
6031: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6032: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

6025: --
6026: if c_pay_period_for_date%notfound then
6027: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',160);
6028: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6029: fnd_message.set_token('DATE_CODE',p_date_cd);
6030: fnd_message.set_token('PERSON_ID',l_person_id);
6031: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6032: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6033: fnd_message.raise_error;

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

6026: if c_pay_period_for_date%notfound then
6027: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',160);
6028: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6029: fnd_message.set_token('DATE_CODE',p_date_cd);
6030: fnd_message.set_token('PERSON_ID',l_person_id);
6031: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6032: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6033: fnd_message.raise_error;
6034: --

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

6027: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',160);
6028: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6029: fnd_message.set_token('DATE_CODE',p_date_cd);
6030: fnd_message.set_token('PERSON_ID',l_person_id);
6031: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6032: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6033: fnd_message.raise_error;
6034: --
6035: end if;

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

6028: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6029: fnd_message.set_token('DATE_CODE',p_date_cd);
6030: fnd_message.set_token('PERSON_ID',l_person_id);
6031: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6032: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6033: fnd_message.raise_error;
6034: --
6035: end if;
6036: --

Line 6033: fnd_message.raise_error;

6029: fnd_message.set_token('DATE_CODE',p_date_cd);
6030: fnd_message.set_token('PERSON_ID',l_person_id);
6031: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6032: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6033: fnd_message.raise_error;
6034: --
6035: end if;
6036: --
6037: close c_pay_period_for_date;

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

6059: l_end_date;
6060: --
6061: if c_pay_period_for_date%notfound then
6062: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',165);
6063: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6064: fnd_message.set_token('DATE_CODE',p_date_cd);
6065: fnd_message.set_token('PERSON_ID',l_person_id);
6066: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6067: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

6060: --
6061: if c_pay_period_for_date%notfound then
6062: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',165);
6063: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6064: fnd_message.set_token('DATE_CODE',p_date_cd);
6065: fnd_message.set_token('PERSON_ID',l_person_id);
6066: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6067: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6068: fnd_message.raise_error;

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

6061: if c_pay_period_for_date%notfound then
6062: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',165);
6063: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6064: fnd_message.set_token('DATE_CODE',p_date_cd);
6065: fnd_message.set_token('PERSON_ID',l_person_id);
6066: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6067: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6068: fnd_message.raise_error;
6069: --

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

6062: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',165);
6063: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6064: fnd_message.set_token('DATE_CODE',p_date_cd);
6065: fnd_message.set_token('PERSON_ID',l_person_id);
6066: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6067: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6068: fnd_message.raise_error;
6069: --
6070: end if;

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

6063: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6064: fnd_message.set_token('DATE_CODE',p_date_cd);
6065: fnd_message.set_token('PERSON_ID',l_person_id);
6066: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6067: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6068: fnd_message.raise_error;
6069: --
6070: end if;
6071: --

Line 6068: fnd_message.raise_error;

6064: fnd_message.set_token('DATE_CODE',p_date_cd);
6065: fnd_message.set_token('PERSON_ID',l_person_id);
6066: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6067: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6068: fnd_message.raise_error;
6069: --
6070: end if;
6071: --
6072: close c_pay_period_for_date;

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

6366: fetch c_pay_period into l_pay_period;
6367: if c_pay_period%notfound then
6368: close c_pay_period;
6369: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',170);
6370: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6371: fnd_message.set_token('DATE_CODE',p_date_cd);
6372: fnd_message.set_token('PERSON_ID',l_person_id);
6373: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6374: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

6367: if c_pay_period%notfound then
6368: close c_pay_period;
6369: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',170);
6370: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6371: fnd_message.set_token('DATE_CODE',p_date_cd);
6372: fnd_message.set_token('PERSON_ID',l_person_id);
6373: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6374: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6375: fnd_message.raise_error;

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

6368: close c_pay_period;
6369: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',170);
6370: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6371: fnd_message.set_token('DATE_CODE',p_date_cd);
6372: fnd_message.set_token('PERSON_ID',l_person_id);
6373: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6374: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6375: fnd_message.raise_error;
6376: end if;

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

6369: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',170);
6370: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6371: fnd_message.set_token('DATE_CODE',p_date_cd);
6372: fnd_message.set_token('PERSON_ID',l_person_id);
6373: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6374: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6375: fnd_message.raise_error;
6376: end if;
6377: p_returned_date := l_pay_period.end_date;

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

6370: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6371: fnd_message.set_token('DATE_CODE',p_date_cd);
6372: fnd_message.set_token('PERSON_ID',l_person_id);
6373: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6374: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6375: fnd_message.raise_error;
6376: end if;
6377: p_returned_date := l_pay_period.end_date;
6378: close c_pay_period ;

Line 6375: fnd_message.raise_error;

6371: fnd_message.set_token('DATE_CODE',p_date_cd);
6372: fnd_message.set_token('PERSON_ID',l_person_id);
6373: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6374: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6375: fnd_message.raise_error;
6376: end if;
6377: p_returned_date := l_pay_period.end_date;
6378: close c_pay_period ;
6379: --

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

6407: --
6408: if c_next_pay_period%notfound then
6409: close c_next_pay_period;
6410: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',170);
6411: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6412: fnd_message.set_token('DATE_CODE',p_date_cd);
6413: fnd_message.set_token('PERSON_ID',l_person_id);
6414: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6415: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

6408: if c_next_pay_period%notfound then
6409: close c_next_pay_period;
6410: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',170);
6411: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6412: fnd_message.set_token('DATE_CODE',p_date_cd);
6413: fnd_message.set_token('PERSON_ID',l_person_id);
6414: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6415: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6416: fnd_message.raise_error;

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

6409: close c_next_pay_period;
6410: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',170);
6411: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6412: fnd_message.set_token('DATE_CODE',p_date_cd);
6413: fnd_message.set_token('PERSON_ID',l_person_id);
6414: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6415: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6416: fnd_message.raise_error;
6417: end if;

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

6410: -- hr_utility.set_location('BEN_91477_PAY_PERIOD_MISSING',170);
6411: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6412: fnd_message.set_token('DATE_CODE',p_date_cd);
6413: fnd_message.set_token('PERSON_ID',l_person_id);
6414: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6415: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6416: fnd_message.raise_error;
6417: end if;
6418: p_returned_date := l_next_pay_period.start_date;

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

6411: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6412: fnd_message.set_token('DATE_CODE',p_date_cd);
6413: fnd_message.set_token('PERSON_ID',l_person_id);
6414: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6415: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6416: fnd_message.raise_error;
6417: end if;
6418: p_returned_date := l_next_pay_period.start_date;
6419: close c_next_pay_period;

Line 6416: fnd_message.raise_error;

6412: fnd_message.set_token('DATE_CODE',p_date_cd);
6413: fnd_message.set_token('PERSON_ID',l_person_id);
6414: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6415: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6416: fnd_message.raise_error;
6417: end if;
6418: p_returned_date := l_next_pay_period.start_date;
6419: close c_next_pay_period;
6420: --

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

6481: if g_debug then
6482: hr_utility.set_location(' Hire date ' || l_hire_date, 99 );
6483: end if;
6484: if l_hire_date is null then
6485: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
6486: fnd_message.set_token('DATE_CODE',p_date_cd);
6487: fnd_message.set_token('L_PROC',l_proc);
6488: fnd_message.raise_error;
6489: end if ;

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

6482: hr_utility.set_location(' Hire date ' || l_hire_date, 99 );
6483: end if;
6484: if l_hire_date is null then
6485: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
6486: fnd_message.set_token('DATE_CODE',p_date_cd);
6487: fnd_message.set_token('L_PROC',l_proc);
6488: fnd_message.raise_error;
6489: end if ;
6490: if g_debug then

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

6483: end if;
6484: if l_hire_date is null then
6485: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
6486: fnd_message.set_token('DATE_CODE',p_date_cd);
6487: fnd_message.set_token('L_PROC',l_proc);
6488: fnd_message.raise_error;
6489: end if ;
6490: if g_debug then
6491: hr_utility.set_location(' Hire date ' || l_hire_date, 99 );

Line 6488: fnd_message.raise_error;

6484: if l_hire_date is null then
6485: fnd_message.set_name('BEN','BEN_92489_CANNOT_CALC_DATE');
6486: fnd_message.set_token('DATE_CODE',p_date_cd);
6487: fnd_message.set_token('L_PROC',l_proc);
6488: fnd_message.raise_error;
6489: end if ;
6490: if g_debug then
6491: hr_utility.set_location(' Hire date ' || l_hire_date, 99 );
6492: end if;

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

6511: 'FDLY','FDQ','FDSY', 'LFSEMES'
6512: ) then
6513:
6514: -- hr_utility.set_location('Future Date Code: '||p_date_cd , 222);
6515: fnd_message.set_name('BEN','FUTURE_DATE_CD_DO_NOT_USE');
6516: fnd_message.set_token('DATE_CODE',p_date_cd);
6517: fnd_message.raise_error;
6518:
6519: elsif p_date_cd in ('FDPPFCDE','FDPPFCDEL') then

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

6512: ) then
6513:
6514: -- hr_utility.set_location('Future Date Code: '||p_date_cd , 222);
6515: fnd_message.set_name('BEN','FUTURE_DATE_CD_DO_NOT_USE');
6516: fnd_message.set_token('DATE_CODE',p_date_cd);
6517: fnd_message.raise_error;
6518:
6519: elsif p_date_cd in ('FDPPFCDE','FDPPFCDEL') then
6520: --

Line 6517: fnd_message.raise_error;

6513:
6514: -- hr_utility.set_location('Future Date Code: '||p_date_cd , 222);
6515: fnd_message.set_name('BEN','FUTURE_DATE_CD_DO_NOT_USE');
6516: fnd_message.set_token('DATE_CODE',p_date_cd);
6517: fnd_message.raise_error;
6518:
6519: elsif p_date_cd in ('FDPPFCDE','FDPPFCDEL') then
6520: --
6521: if g_debug then

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

6544: if c_pay_period_for_check%notfound then
6545: --
6546: close c_pay_period_for_check;
6547: --
6548: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6549: fnd_message.set_token('DATE_CODE',p_date_cd);
6550: fnd_message.set_token('L_PROC',l_proc);
6551: fnd_message.set_token('PERSON_ID',l_person_id);
6552: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

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

6545: --
6546: close c_pay_period_for_check;
6547: --
6548: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6549: fnd_message.set_token('DATE_CODE',p_date_cd);
6550: fnd_message.set_token('L_PROC',l_proc);
6551: fnd_message.set_token('PERSON_ID',l_person_id);
6552: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6553: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

6546: close c_pay_period_for_check;
6547: --
6548: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6549: fnd_message.set_token('DATE_CODE',p_date_cd);
6550: fnd_message.set_token('L_PROC',l_proc);
6551: fnd_message.set_token('PERSON_ID',l_person_id);
6552: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6553: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6554: fnd_message.raise_error;

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

6547: --
6548: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6549: fnd_message.set_token('DATE_CODE',p_date_cd);
6550: fnd_message.set_token('L_PROC',l_proc);
6551: fnd_message.set_token('PERSON_ID',l_person_id);
6552: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6553: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6554: fnd_message.raise_error;
6555: --

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

6548: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6549: fnd_message.set_token('DATE_CODE',p_date_cd);
6550: fnd_message.set_token('L_PROC',l_proc);
6551: fnd_message.set_token('PERSON_ID',l_person_id);
6552: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6553: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6554: fnd_message.raise_error;
6555: --
6556: end if;

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

6549: fnd_message.set_token('DATE_CODE',p_date_cd);
6550: fnd_message.set_token('L_PROC',l_proc);
6551: fnd_message.set_token('PERSON_ID',l_person_id);
6552: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6553: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6554: fnd_message.raise_error;
6555: --
6556: end if;
6557: else

Line 6554: fnd_message.raise_error;

6550: fnd_message.set_token('L_PROC',l_proc);
6551: fnd_message.set_token('PERSON_ID',l_person_id);
6552: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6553: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6554: fnd_message.raise_error;
6555: --
6556: end if;
6557: else
6558: -- rehire and new hire validation

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

6598: if c_pay_period_for_check_end %notfound then
6599: --
6600: close c_pay_period_for_check_end ;
6601: --
6602: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6603: fnd_message.set_token('DATE_CODE',p_date_cd);
6604: fnd_message.set_token('L_PROC',l_proc);
6605: fnd_message.set_token('PERSON_ID',l_person_id);
6606: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);

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

6599: --
6600: close c_pay_period_for_check_end ;
6601: --
6602: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6603: fnd_message.set_token('DATE_CODE',p_date_cd);
6604: fnd_message.set_token('L_PROC',l_proc);
6605: fnd_message.set_token('PERSON_ID',l_person_id);
6606: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6607: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);

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

6600: close c_pay_period_for_check_end ;
6601: --
6602: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6603: fnd_message.set_token('DATE_CODE',p_date_cd);
6604: fnd_message.set_token('L_PROC',l_proc);
6605: fnd_message.set_token('PERSON_ID',l_person_id);
6606: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6607: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6608: fnd_message.raise_error;

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

6601: --
6602: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6603: fnd_message.set_token('DATE_CODE',p_date_cd);
6604: fnd_message.set_token('L_PROC',l_proc);
6605: fnd_message.set_token('PERSON_ID',l_person_id);
6606: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6607: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6608: fnd_message.raise_error;
6609: --

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

6602: fnd_message.set_name('BEN','BEN_91477_PAY_PERIOD_MISSING');
6603: fnd_message.set_token('DATE_CODE',p_date_cd);
6604: fnd_message.set_token('L_PROC',l_proc);
6605: fnd_message.set_token('PERSON_ID',l_person_id);
6606: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6607: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6608: fnd_message.raise_error;
6609: --
6610: end if;

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

6603: fnd_message.set_token('DATE_CODE',p_date_cd);
6604: fnd_message.set_token('L_PROC',l_proc);
6605: fnd_message.set_token('PERSON_ID',l_person_id);
6606: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6607: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6608: fnd_message.raise_error;
6609: --
6610: end if;
6611: end if;

Line 6608: fnd_message.raise_error;

6604: fnd_message.set_token('L_PROC',l_proc);
6605: fnd_message.set_token('PERSON_ID',l_person_id);
6606: fnd_message.set_token('BUSINESS_GROUP_ID',l_business_group_id);
6607: fnd_message.set_token('EFFECTIVE_DATE',p_effective_date);
6608: fnd_message.raise_error;
6609: --
6610: end if;
6611: end if;
6612: --

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

6614: p_returned_date := l_end_date;
6615: else
6616:
6617: hr_utility.set_location('Unknown Date Code: '||p_date_cd , 222);
6618: fnd_message.set_name('BEN','BEN_91534_BEN_UNKNOWN_DATE_CD');
6619: fnd_message.set_token('DATE_CODE',p_date_cd);
6620: fnd_message.set_token('L_PROC',l_proc);
6621: fnd_message.raise_error;
6622:

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

6615: else
6616:
6617: hr_utility.set_location('Unknown Date Code: '||p_date_cd , 222);
6618: fnd_message.set_name('BEN','BEN_91534_BEN_UNKNOWN_DATE_CD');
6619: fnd_message.set_token('DATE_CODE',p_date_cd);
6620: fnd_message.set_token('L_PROC',l_proc);
6621: fnd_message.raise_error;
6622:
6623: end if;

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

6616:
6617: hr_utility.set_location('Unknown Date Code: '||p_date_cd , 222);
6618: fnd_message.set_name('BEN','BEN_91534_BEN_UNKNOWN_DATE_CD');
6619: fnd_message.set_token('DATE_CODE',p_date_cd);
6620: fnd_message.set_token('L_PROC',l_proc);
6621: fnd_message.raise_error;
6622:
6623: end if;
6624: --

Line 6621: fnd_message.raise_error;

6617: hr_utility.set_location('Unknown Date Code: '||p_date_cd , 222);
6618: fnd_message.set_name('BEN','BEN_91534_BEN_UNKNOWN_DATE_CD');
6619: fnd_message.set_token('DATE_CODE',p_date_cd);
6620: fnd_message.set_token('L_PROC',l_proc);
6621: fnd_message.raise_error;
6622:
6623: end if;
6624: --
6625: if g_debug then

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

7429: hr_utility.set_location('l_oipl_id '||l_oipl_id,19);
7430: end if;
7431: if c_epe_info%notfound then
7432: close c_epe_info;
7433: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
7434: --fnd_message.set_token('ID', to_char(p_business_group_id));
7435: fnd_message.set_token('ID', to_char(p_elig_per_elctbl_chc_id));
7436: fnd_message.set_token('PROC',l_proc);
7437: fnd_message.raise_error;

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

7430: end if;
7431: if c_epe_info%notfound then
7432: close c_epe_info;
7433: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
7434: --fnd_message.set_token('ID', to_char(p_business_group_id));
7435: fnd_message.set_token('ID', to_char(p_elig_per_elctbl_chc_id));
7436: fnd_message.set_token('PROC',l_proc);
7437: fnd_message.raise_error;
7438: end if;

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

7431: if c_epe_info%notfound then
7432: close c_epe_info;
7433: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
7434: --fnd_message.set_token('ID', to_char(p_business_group_id));
7435: fnd_message.set_token('ID', to_char(p_elig_per_elctbl_chc_id));
7436: fnd_message.set_token('PROC',l_proc);
7437: fnd_message.raise_error;
7438: end if;
7439: if g_debug then

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

7432: close c_epe_info;
7433: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
7434: --fnd_message.set_token('ID', to_char(p_business_group_id));
7435: fnd_message.set_token('ID', to_char(p_elig_per_elctbl_chc_id));
7436: fnd_message.set_token('PROC',l_proc);
7437: fnd_message.raise_error;
7438: end if;
7439: if g_debug then
7440: hr_utility.set_location(l_proc , 40);

Line 7437: fnd_message.raise_error;

7433: fnd_message.set_name('BEN','BEN_91457_ELCTBL_CHC_NOT_FOUND');
7434: --fnd_message.set_token('ID', to_char(p_business_group_id));
7435: fnd_message.set_token('ID', to_char(p_elig_per_elctbl_chc_id));
7436: fnd_message.set_token('PROC',l_proc);
7437: fnd_message.raise_error;
7438: end if;
7439: if g_debug then
7440: hr_utility.set_location(l_proc , 40);
7441: end if;

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

8043: l_rt_strt_dt_cd is null then
8044: if g_debug then
8045: hr_utility.set_location('BEN_91455_RT_STRT_DT_NOT_FOUND' , 540);
8046: end if;
8047: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
8048: fnd_message.set_token('PLAN_ID',l_pln_name);
8049: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8050: fnd_message.set_token('PGM_ID',l_pgm_name);
8051: fnd_message.set_token('OIPL_ID',l_opt_name);

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

8044: if g_debug then
8045: hr_utility.set_location('BEN_91455_RT_STRT_DT_NOT_FOUND' , 540);
8046: end if;
8047: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
8048: fnd_message.set_token('PLAN_ID',l_pln_name);
8049: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8050: fnd_message.set_token('PGM_ID',l_pgm_name);
8051: fnd_message.set_token('OIPL_ID',l_opt_name);
8052: fnd_message.raise_error;

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

8045: hr_utility.set_location('BEN_91455_RT_STRT_DT_NOT_FOUND' , 540);
8046: end if;
8047: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
8048: fnd_message.set_token('PLAN_ID',l_pln_name);
8049: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8050: fnd_message.set_token('PGM_ID',l_pgm_name);
8051: fnd_message.set_token('OIPL_ID',l_opt_name);
8052: fnd_message.raise_error;
8053: elsif p_which_dates_cd in ('R','B') and

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

8046: end if;
8047: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
8048: fnd_message.set_token('PLAN_ID',l_pln_name);
8049: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8050: fnd_message.set_token('PGM_ID',l_pgm_name);
8051: fnd_message.set_token('OIPL_ID',l_opt_name);
8052: fnd_message.raise_error;
8053: elsif p_which_dates_cd in ('R','B') and
8054: l_rt_end_dt_cd is null then

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

8047: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
8048: fnd_message.set_token('PLAN_ID',l_pln_name);
8049: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8050: fnd_message.set_token('PGM_ID',l_pgm_name);
8051: fnd_message.set_token('OIPL_ID',l_opt_name);
8052: fnd_message.raise_error;
8053: elsif p_which_dates_cd in ('R','B') and
8054: l_rt_end_dt_cd is null then
8055: if g_debug then

Line 8052: fnd_message.raise_error;

8048: fnd_message.set_token('PLAN_ID',l_pln_name);
8049: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8050: fnd_message.set_token('PGM_ID',l_pgm_name);
8051: fnd_message.set_token('OIPL_ID',l_opt_name);
8052: fnd_message.raise_error;
8053: elsif p_which_dates_cd in ('R','B') and
8054: l_rt_end_dt_cd is null then
8055: if g_debug then
8056: hr_utility.set_location('BEN_91703_NOT_DET_RATE_END_DT' , 550);

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

8054: l_rt_end_dt_cd is null then
8055: if g_debug then
8056: hr_utility.set_location('BEN_91703_NOT_DET_RATE_END_DT' , 550);
8057: end if;
8058: fnd_message.set_name('BEN','BEN_91703_NOT_DET_RATE_END_DT');
8059: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8060: fnd_message.set_token('PGM_ID',l_pgm_name);
8061: fnd_message.set_token('PL_ID',l_pln_name);
8062: fnd_message.set_token('OIPL_ID',l_opt_name);

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

8055: if g_debug then
8056: hr_utility.set_location('BEN_91703_NOT_DET_RATE_END_DT' , 550);
8057: end if;
8058: fnd_message.set_name('BEN','BEN_91703_NOT_DET_RATE_END_DT');
8059: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8060: fnd_message.set_token('PGM_ID',l_pgm_name);
8061: fnd_message.set_token('PL_ID',l_pln_name);
8062: fnd_message.set_token('OIPL_ID',l_opt_name);
8063: fnd_message.raise_error;

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

8056: hr_utility.set_location('BEN_91703_NOT_DET_RATE_END_DT' , 550);
8057: end if;
8058: fnd_message.set_name('BEN','BEN_91703_NOT_DET_RATE_END_DT');
8059: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8060: fnd_message.set_token('PGM_ID',l_pgm_name);
8061: fnd_message.set_token('PL_ID',l_pln_name);
8062: fnd_message.set_token('OIPL_ID',l_opt_name);
8063: fnd_message.raise_error;
8064: elsif p_which_dates_cd in ('C','B') and

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

8057: end if;
8058: fnd_message.set_name('BEN','BEN_91703_NOT_DET_RATE_END_DT');
8059: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8060: fnd_message.set_token('PGM_ID',l_pgm_name);
8061: fnd_message.set_token('PL_ID',l_pln_name);
8062: fnd_message.set_token('OIPL_ID',l_opt_name);
8063: fnd_message.raise_error;
8064: elsif p_which_dates_cd in ('C','B') and
8065: l_enrt_cvg_strt_dt_cd is null then

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

8058: fnd_message.set_name('BEN','BEN_91703_NOT_DET_RATE_END_DT');
8059: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8060: fnd_message.set_token('PGM_ID',l_pgm_name);
8061: fnd_message.set_token('PL_ID',l_pln_name);
8062: fnd_message.set_token('OIPL_ID',l_opt_name);
8063: fnd_message.raise_error;
8064: elsif p_which_dates_cd in ('C','B') and
8065: l_enrt_cvg_strt_dt_cd is null then
8066: if g_debug then

Line 8063: fnd_message.raise_error;

8059: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8060: fnd_message.set_token('PGM_ID',l_pgm_name);
8061: fnd_message.set_token('PL_ID',l_pln_name);
8062: fnd_message.set_token('OIPL_ID',l_opt_name);
8063: fnd_message.raise_error;
8064: elsif p_which_dates_cd in ('C','B') and
8065: l_enrt_cvg_strt_dt_cd is null then
8066: if g_debug then
8067: hr_utility.set_location('BEN_91453_CVG_STRT_DT_NOT_FOUN' , 560);

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

8065: l_enrt_cvg_strt_dt_cd is null then
8066: if g_debug then
8067: hr_utility.set_location('BEN_91453_CVG_STRT_DT_NOT_FOUN' , 560);
8068: end if;
8069: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
8070: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8071: fnd_message.set_token('PGM_ID',l_pgm_name);
8072: fnd_message.set_token('PLAN_ID',l_pln_name);
8073: fnd_message.set_token('OIPL_ID',l_opt_name);

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

8066: if g_debug then
8067: hr_utility.set_location('BEN_91453_CVG_STRT_DT_NOT_FOUN' , 560);
8068: end if;
8069: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
8070: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8071: fnd_message.set_token('PGM_ID',l_pgm_name);
8072: fnd_message.set_token('PLAN_ID',l_pln_name);
8073: fnd_message.set_token('OIPL_ID',l_opt_name);
8074: fnd_message.raise_error;

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

8067: hr_utility.set_location('BEN_91453_CVG_STRT_DT_NOT_FOUN' , 560);
8068: end if;
8069: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
8070: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8071: fnd_message.set_token('PGM_ID',l_pgm_name);
8072: fnd_message.set_token('PLAN_ID',l_pln_name);
8073: fnd_message.set_token('OIPL_ID',l_opt_name);
8074: fnd_message.raise_error;
8075: elsif p_which_dates_cd in ('C','B') and

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

8068: end if;
8069: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
8070: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8071: fnd_message.set_token('PGM_ID',l_pgm_name);
8072: fnd_message.set_token('PLAN_ID',l_pln_name);
8073: fnd_message.set_token('OIPL_ID',l_opt_name);
8074: fnd_message.raise_error;
8075: elsif p_which_dates_cd in ('C','B') and
8076: l_enrt_cvg_end_dt_cd is null then

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

8069: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
8070: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8071: fnd_message.set_token('PGM_ID',l_pgm_name);
8072: fnd_message.set_token('PLAN_ID',l_pln_name);
8073: fnd_message.set_token('OIPL_ID',l_opt_name);
8074: fnd_message.raise_error;
8075: elsif p_which_dates_cd in ('C','B') and
8076: l_enrt_cvg_end_dt_cd is null then
8077: if g_debug then

Line 8074: fnd_message.raise_error;

8070: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8071: fnd_message.set_token('PGM_ID',l_pgm_name);
8072: fnd_message.set_token('PLAN_ID',l_pln_name);
8073: fnd_message.set_token('OIPL_ID',l_opt_name);
8074: fnd_message.raise_error;
8075: elsif p_which_dates_cd in ('C','B') and
8076: l_enrt_cvg_end_dt_cd is null then
8077: if g_debug then
8078: hr_utility.set_location(l_proc , 570);

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

8076: l_enrt_cvg_end_dt_cd is null then
8077: if g_debug then
8078: hr_utility.set_location(l_proc , 570);
8079: end if;
8080: fnd_message.set_name('BEN','BEN_91702_NOT_DET_CVG_END_DT');
8081: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8082: fnd_message.set_token('PGM_ID',l_pgm_name);
8083: fnd_message.set_token('PL_ID',l_pln_name);
8084: fnd_message.set_token('OIPL_ID',l_opt_name);

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

8077: if g_debug then
8078: hr_utility.set_location(l_proc , 570);
8079: end if;
8080: fnd_message.set_name('BEN','BEN_91702_NOT_DET_CVG_END_DT');
8081: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8082: fnd_message.set_token('PGM_ID',l_pgm_name);
8083: fnd_message.set_token('PL_ID',l_pln_name);
8084: fnd_message.set_token('OIPL_ID',l_opt_name);
8085: fnd_message.raise_error;

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

8078: hr_utility.set_location(l_proc , 570);
8079: end if;
8080: fnd_message.set_name('BEN','BEN_91702_NOT_DET_CVG_END_DT');
8081: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8082: fnd_message.set_token('PGM_ID',l_pgm_name);
8083: fnd_message.set_token('PL_ID',l_pln_name);
8084: fnd_message.set_token('OIPL_ID',l_opt_name);
8085: fnd_message.raise_error;
8086: end if;

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

8079: end if;
8080: fnd_message.set_name('BEN','BEN_91702_NOT_DET_CVG_END_DT');
8081: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8082: fnd_message.set_token('PGM_ID',l_pgm_name);
8083: fnd_message.set_token('PL_ID',l_pln_name);
8084: fnd_message.set_token('OIPL_ID',l_opt_name);
8085: fnd_message.raise_error;
8086: end if;
8087: --

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

8080: fnd_message.set_name('BEN','BEN_91702_NOT_DET_CVG_END_DT');
8081: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8082: fnd_message.set_token('PGM_ID',l_pgm_name);
8083: fnd_message.set_token('PL_ID',l_pln_name);
8084: fnd_message.set_token('OIPL_ID',l_opt_name);
8085: fnd_message.raise_error;
8086: end if;
8087: --
8088: end if;

Line 8085: fnd_message.raise_error;

8081: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8082: fnd_message.set_token('PGM_ID',l_pgm_name);
8083: fnd_message.set_token('PL_ID',l_pln_name);
8084: fnd_message.set_token('OIPL_ID',l_opt_name);
8085: fnd_message.raise_error;
8086: end if;
8087: --
8088: end if;
8089: --

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

8376: l_rt_strt_dt is null then
8377: if g_debug then
8378: hr_utility.set_location('BEN_91455_RT_STRT_DT_NOT_FOUND',37);
8379: end if;
8380: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
8381: fnd_message.set_token('PLAN_ID',l_pln_name);
8382: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8383: fnd_message.set_token('PGM_ID',l_pgm_name);
8384: fnd_message.set_token('OIPL_ID',l_opt_name);

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

8377: if g_debug then
8378: hr_utility.set_location('BEN_91455_RT_STRT_DT_NOT_FOUND',37);
8379: end if;
8380: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
8381: fnd_message.set_token('PLAN_ID',l_pln_name);
8382: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8383: fnd_message.set_token('PGM_ID',l_pgm_name);
8384: fnd_message.set_token('OIPL_ID',l_opt_name);
8385: fnd_message.raise_error;

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

8378: hr_utility.set_location('BEN_91455_RT_STRT_DT_NOT_FOUND',37);
8379: end if;
8380: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
8381: fnd_message.set_token('PLAN_ID',l_pln_name);
8382: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8383: fnd_message.set_token('PGM_ID',l_pgm_name);
8384: fnd_message.set_token('OIPL_ID',l_opt_name);
8385: fnd_message.raise_error;
8386: elsif p_which_dates_cd in ('R','B') and

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

8379: end if;
8380: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
8381: fnd_message.set_token('PLAN_ID',l_pln_name);
8382: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8383: fnd_message.set_token('PGM_ID',l_pgm_name);
8384: fnd_message.set_token('OIPL_ID',l_opt_name);
8385: fnd_message.raise_error;
8386: elsif p_which_dates_cd in ('R','B') and
8387: l_rt_end_dt is null then

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

8380: fnd_message.set_name('BEN','BEN_91455_RT_STRT_DT_NOT_FOUND');
8381: fnd_message.set_token('PLAN_ID',l_pln_name);
8382: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8383: fnd_message.set_token('PGM_ID',l_pgm_name);
8384: fnd_message.set_token('OIPL_ID',l_opt_name);
8385: fnd_message.raise_error;
8386: elsif p_which_dates_cd in ('R','B') and
8387: l_rt_end_dt is null then
8388: if g_debug then

Line 8385: fnd_message.raise_error;

8381: fnd_message.set_token('PLAN_ID',l_pln_name);
8382: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8383: fnd_message.set_token('PGM_ID',l_pgm_name);
8384: fnd_message.set_token('OIPL_ID',l_opt_name);
8385: fnd_message.raise_error;
8386: elsif p_which_dates_cd in ('R','B') and
8387: l_rt_end_dt is null then
8388: if g_debug then
8389: hr_utility.set_location('BEN_91703_NOT_DET_RATE_END_DT',37);

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

8387: l_rt_end_dt is null then
8388: if g_debug then
8389: hr_utility.set_location('BEN_91703_NOT_DET_RATE_END_DT',37);
8390: end if;
8391: fnd_message.set_name('BEN','BEN_91703_NOT_DET_RATE_END_DT');
8392: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8393: fnd_message.set_token('PGM_ID',l_pgm_name);
8394: fnd_message.set_token('PL_ID',l_pln_name);
8395: fnd_message.set_token('OIPL_ID',l_opt_name);

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

8388: if g_debug then
8389: hr_utility.set_location('BEN_91703_NOT_DET_RATE_END_DT',37);
8390: end if;
8391: fnd_message.set_name('BEN','BEN_91703_NOT_DET_RATE_END_DT');
8392: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8393: fnd_message.set_token('PGM_ID',l_pgm_name);
8394: fnd_message.set_token('PL_ID',l_pln_name);
8395: fnd_message.set_token('OIPL_ID',l_opt_name);
8396: fnd_message.raise_error;

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

8389: hr_utility.set_location('BEN_91703_NOT_DET_RATE_END_DT',37);
8390: end if;
8391: fnd_message.set_name('BEN','BEN_91703_NOT_DET_RATE_END_DT');
8392: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8393: fnd_message.set_token('PGM_ID',l_pgm_name);
8394: fnd_message.set_token('PL_ID',l_pln_name);
8395: fnd_message.set_token('OIPL_ID',l_opt_name);
8396: fnd_message.raise_error;
8397: elsif p_which_dates_cd in ('C','B') and

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

8390: end if;
8391: fnd_message.set_name('BEN','BEN_91703_NOT_DET_RATE_END_DT');
8392: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8393: fnd_message.set_token('PGM_ID',l_pgm_name);
8394: fnd_message.set_token('PL_ID',l_pln_name);
8395: fnd_message.set_token('OIPL_ID',l_opt_name);
8396: fnd_message.raise_error;
8397: elsif p_which_dates_cd in ('C','B') and
8398: l_enrt_cvg_strt_dt is null then

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

8391: fnd_message.set_name('BEN','BEN_91703_NOT_DET_RATE_END_DT');
8392: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8393: fnd_message.set_token('PGM_ID',l_pgm_name);
8394: fnd_message.set_token('PL_ID',l_pln_name);
8395: fnd_message.set_token('OIPL_ID',l_opt_name);
8396: fnd_message.raise_error;
8397: elsif p_which_dates_cd in ('C','B') and
8398: l_enrt_cvg_strt_dt is null then
8399: if g_debug then

Line 8396: fnd_message.raise_error;

8392: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8393: fnd_message.set_token('PGM_ID',l_pgm_name);
8394: fnd_message.set_token('PL_ID',l_pln_name);
8395: fnd_message.set_token('OIPL_ID',l_opt_name);
8396: fnd_message.raise_error;
8397: elsif p_which_dates_cd in ('C','B') and
8398: l_enrt_cvg_strt_dt is null then
8399: if g_debug then
8400: hr_utility.set_location('BEN_91453_CVG_STRT_DT_NOT_FOUN',37);

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

8398: l_enrt_cvg_strt_dt is null then
8399: if g_debug then
8400: hr_utility.set_location('BEN_91453_CVG_STRT_DT_NOT_FOUN',37);
8401: end if;
8402: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
8403: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8404: fnd_message.set_token('PGM_ID',l_pgm_name);
8405: fnd_message.set_token('PLAN_ID',l_pln_name);
8406: fnd_message.set_token('OIPL_ID',l_opt_name);

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

8399: if g_debug then
8400: hr_utility.set_location('BEN_91453_CVG_STRT_DT_NOT_FOUN',37);
8401: end if;
8402: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
8403: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8404: fnd_message.set_token('PGM_ID',l_pgm_name);
8405: fnd_message.set_token('PLAN_ID',l_pln_name);
8406: fnd_message.set_token('OIPL_ID',l_opt_name);
8407: fnd_message.raise_error;

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

8400: hr_utility.set_location('BEN_91453_CVG_STRT_DT_NOT_FOUN',37);
8401: end if;
8402: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
8403: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8404: fnd_message.set_token('PGM_ID',l_pgm_name);
8405: fnd_message.set_token('PLAN_ID',l_pln_name);
8406: fnd_message.set_token('OIPL_ID',l_opt_name);
8407: fnd_message.raise_error;
8408: elsif p_which_dates_cd in ('C','B') and

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

8401: end if;
8402: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
8403: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8404: fnd_message.set_token('PGM_ID',l_pgm_name);
8405: fnd_message.set_token('PLAN_ID',l_pln_name);
8406: fnd_message.set_token('OIPL_ID',l_opt_name);
8407: fnd_message.raise_error;
8408: elsif p_which_dates_cd in ('C','B') and
8409: l_enrt_cvg_end_dt is null then

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

8402: fnd_message.set_name('BEN','BEN_91453_CVG_STRT_DT_NOT_FOUN');
8403: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8404: fnd_message.set_token('PGM_ID',l_pgm_name);
8405: fnd_message.set_token('PLAN_ID',l_pln_name);
8406: fnd_message.set_token('OIPL_ID',l_opt_name);
8407: fnd_message.raise_error;
8408: elsif p_which_dates_cd in ('C','B') and
8409: l_enrt_cvg_end_dt is null then
8410: if g_debug then

Line 8407: fnd_message.raise_error;

8403: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8404: fnd_message.set_token('PGM_ID',l_pgm_name);
8405: fnd_message.set_token('PLAN_ID',l_pln_name);
8406: fnd_message.set_token('OIPL_ID',l_opt_name);
8407: fnd_message.raise_error;
8408: elsif p_which_dates_cd in ('C','B') and
8409: l_enrt_cvg_end_dt is null then
8410: if g_debug then
8411: hr_utility.set_location('BEN_91702_NOT_DET_CVG_END_DT',37);

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

8409: l_enrt_cvg_end_dt is null then
8410: if g_debug then
8411: hr_utility.set_location('BEN_91702_NOT_DET_CVG_END_DT',37);
8412: end if;
8413: fnd_message.set_name('BEN','BEN_91702_NOT_DET_CVG_END_DT');
8414: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8415: fnd_message.set_token('PGM_ID',l_pgm_name);
8416: fnd_message.set_token('PL_ID',l_pln_name);
8417: fnd_message.set_token('OIPL_ID',l_opt_name);

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

8410: if g_debug then
8411: hr_utility.set_location('BEN_91702_NOT_DET_CVG_END_DT',37);
8412: end if;
8413: fnd_message.set_name('BEN','BEN_91702_NOT_DET_CVG_END_DT');
8414: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8415: fnd_message.set_token('PGM_ID',l_pgm_name);
8416: fnd_message.set_token('PL_ID',l_pln_name);
8417: fnd_message.set_token('OIPL_ID',l_opt_name);
8418: fnd_message.raise_error;

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

8411: hr_utility.set_location('BEN_91702_NOT_DET_CVG_END_DT',37);
8412: end if;
8413: fnd_message.set_name('BEN','BEN_91702_NOT_DET_CVG_END_DT');
8414: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8415: fnd_message.set_token('PGM_ID',l_pgm_name);
8416: fnd_message.set_token('PL_ID',l_pln_name);
8417: fnd_message.set_token('OIPL_ID',l_opt_name);
8418: fnd_message.raise_error;
8419: end if;

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

8412: end if;
8413: fnd_message.set_name('BEN','BEN_91702_NOT_DET_CVG_END_DT');
8414: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8415: fnd_message.set_token('PGM_ID',l_pgm_name);
8416: fnd_message.set_token('PL_ID',l_pln_name);
8417: fnd_message.set_token('OIPL_ID',l_opt_name);
8418: fnd_message.raise_error;
8419: end if;
8420:

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

8413: fnd_message.set_name('BEN','BEN_91702_NOT_DET_CVG_END_DT');
8414: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8415: fnd_message.set_token('PGM_ID',l_pgm_name);
8416: fnd_message.set_token('PL_ID',l_pln_name);
8417: fnd_message.set_token('OIPL_ID',l_opt_name);
8418: fnd_message.raise_error;
8419: end if;
8420:
8421: end if;

Line 8418: fnd_message.raise_error;

8414: fnd_message.set_token('PERSON_ID',to_char(l_person_id));
8415: fnd_message.set_token('PGM_ID',l_pgm_name);
8416: fnd_message.set_token('PL_ID',l_pln_name);
8417: fnd_message.set_token('OIPL_ID',l_opt_name);
8418: fnd_message.raise_error;
8419: end if;
8420:
8421: end if;
8422: --