DBA Data[Home] [Help]

APPS.PAY_GB_PAYROLL_RULES dependencies on FND_MESSAGE

Line 163: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');

159: --
160: l_span_start := hr_gbbal.span_start(l_cur_eff_start);
161: l_span_end := hr_gbbal.span_end(l_cur_eff_start);
162: --
163: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
164: fnd_message.set_token('TAX_YEAR',
165: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
166: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
167: fnd_message.raise_error;

Line 164: fnd_message.set_token('TAX_YEAR',

160: l_span_start := hr_gbbal.span_start(l_cur_eff_start);
161: l_span_end := hr_gbbal.span_end(l_cur_eff_start);
162: --
163: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
164: fnd_message.set_token('TAX_YEAR',
165: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
166: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
167: fnd_message.raise_error;
168: END IF;

Line 167: fnd_message.raise_error;

163: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
164: fnd_message.set_token('TAX_YEAR',
165: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
166: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
167: fnd_message.raise_error;
168: END IF;
169: --
170: hr_utility.trace('Change as at the start date is ok, Checking end date');
171: --

Line 196: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');

192: --
193: l_span_start := hr_gbbal.span_start(l_cur_eff_end);
194: l_span_end := hr_gbbal.span_end(l_cur_eff_end);
195: --
196: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
197: fnd_message.set_token('TAX_YEAR',
198: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
199: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
200: fnd_message.raise_error;

Line 197: fnd_message.set_token('TAX_YEAR',

193: l_span_start := hr_gbbal.span_start(l_cur_eff_end);
194: l_span_end := hr_gbbal.span_end(l_cur_eff_end);
195: --
196: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
197: fnd_message.set_token('TAX_YEAR',
198: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
199: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
200: fnd_message.raise_error;
201: END IF;

Line 200: fnd_message.raise_error;

196: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
197: fnd_message.set_token('TAX_YEAR',
198: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
199: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
200: fnd_message.raise_error;
201: END IF;
202: --
203: hr_utility.trace('Change as at the end date is ok too.');
204: --

Line 218: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');

214: fetch csr_term_asg_future_act_exists into l_found;
215: if csr_term_asg_future_act_exists%notfound then
216: close csr_term_asg_exists;
217: close csr_term_asg_future_act_exists;
218: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
219: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_cur_eff_start));
220: fnd_message.raise_error;
221: end if;
222: close csr_term_asg_future_act_exists;

Line 219: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_cur_eff_start));

215: if csr_term_asg_future_act_exists%notfound then
216: close csr_term_asg_exists;
217: close csr_term_asg_future_act_exists;
218: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
219: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_cur_eff_start));
220: fnd_message.raise_error;
221: end if;
222: close csr_term_asg_future_act_exists;
223: end if;

Line 220: fnd_message.raise_error;

216: close csr_term_asg_exists;
217: close csr_term_asg_future_act_exists;
218: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
219: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_cur_eff_start));
220: fnd_message.raise_error;
221: end if;
222: close csr_term_asg_future_act_exists;
223: end if;
224: close csr_term_asg_exists;

Line 238: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');

234: fetch csr_term_asg_future_act_exists into l_found;
235: if csr_term_asg_future_act_exists%notfound then
236: close csr_term_asg_exists;
237: close csr_term_asg_future_act_exists;
238: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
239: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_cur_eff_end+1));
240: fnd_message.raise_error;
241: end if;
242: close csr_term_asg_future_act_exists;

Line 239: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_cur_eff_end+1));

235: if csr_term_asg_future_act_exists%notfound then
236: close csr_term_asg_exists;
237: close csr_term_asg_future_act_exists;
238: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
239: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_cur_eff_end+1));
240: fnd_message.raise_error;
241: end if;
242: close csr_term_asg_future_act_exists;
243: end if;

Line 240: fnd_message.raise_error;

236: close csr_term_asg_exists;
237: close csr_term_asg_future_act_exists;
238: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
239: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_cur_eff_end+1));
240: fnd_message.raise_error;
241: end if;
242: close csr_term_asg_future_act_exists;
243: end if;
244: close csr_term_asg_exists;

Line 271: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');

267: --
268: l_span_start := hr_gbbal.span_start(p_effective_date);
269: l_span_end := hr_gbbal.span_end(p_effective_date);
270: --
271: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
272: fnd_message.set_token('TAX_YEAR',
273: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
274: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
275: fnd_message.raise_error;

Line 272: fnd_message.set_token('TAX_YEAR',

268: l_span_start := hr_gbbal.span_start(p_effective_date);
269: l_span_end := hr_gbbal.span_end(p_effective_date);
270: --
271: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
272: fnd_message.set_token('TAX_YEAR',
273: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
274: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
275: fnd_message.raise_error;
276: END IF;

Line 275: fnd_message.raise_error;

271: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
272: fnd_message.set_token('TAX_YEAR',
273: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
274: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
275: fnd_message.raise_error;
276: END IF;
277: --
278: hr_utility.trace('Change as at the new effective date ok, no need to check as at the effective end date');
279: --

Line 293: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');

289: fetch csr_term_asg_future_act_exists into l_found;
290: if csr_term_asg_future_act_exists%notfound then
291: close csr_term_asg_exists;
292: close csr_term_asg_future_act_exists;
293: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
294: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(p_effective_date));
295: fnd_message.raise_error;
296: end if;
297: close csr_term_asg_future_act_exists;

Line 294: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(p_effective_date));

290: if csr_term_asg_future_act_exists%notfound then
291: close csr_term_asg_exists;
292: close csr_term_asg_future_act_exists;
293: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
294: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(p_effective_date));
295: fnd_message.raise_error;
296: end if;
297: close csr_term_asg_future_act_exists;
298: end if;

Line 295: fnd_message.raise_error;

291: close csr_term_asg_exists;
292: close csr_term_asg_future_act_exists;
293: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
294: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(p_effective_date));
295: fnd_message.raise_error;
296: end if;
297: close csr_term_asg_future_act_exists;
298: end if;
299: close csr_term_asg_exists;

Line 325: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');

321: --
322: l_span_start := hr_gbbal.span_start(p_effective_date);
323: l_span_end := hr_gbbal.span_end(p_effective_date);
324: --
325: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
326: fnd_message.set_token('TAX_YEAR',
327: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
328: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
329: fnd_message.raise_error;

Line 326: fnd_message.set_token('TAX_YEAR',

322: l_span_start := hr_gbbal.span_start(p_effective_date);
323: l_span_end := hr_gbbal.span_end(p_effective_date);
324: --
325: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
326: fnd_message.set_token('TAX_YEAR',
327: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
328: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
329: fnd_message.raise_error;
330: END IF;

Line 329: fnd_message.raise_error;

325: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
326: fnd_message.set_token('TAX_YEAR',
327: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
328: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
329: fnd_message.raise_error;
330: END IF;
331: --
332: hr_utility.trace('Change as at the new effective date ok, Checking as at the effective end date');
333: --

Line 359: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');

355: --
356: l_span_start := hr_gbbal.span_start(l_cur_eff_end);
357: l_span_end := hr_gbbal.span_end(l_cur_eff_end);
358: --
359: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
360: fnd_message.set_token('TAX_YEAR',
361: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
362: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
363: fnd_message.raise_error;

Line 360: fnd_message.set_token('TAX_YEAR',

356: l_span_start := hr_gbbal.span_start(l_cur_eff_end);
357: l_span_end := hr_gbbal.span_end(l_cur_eff_end);
358: --
359: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
360: fnd_message.set_token('TAX_YEAR',
361: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
362: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
363: fnd_message.raise_error;
364: END IF;

Line 363: fnd_message.raise_error;

359: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
360: fnd_message.set_token('TAX_YEAR',
361: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
362: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
363: fnd_message.raise_error;
364: END IF;
365: --
366: hr_utility.trace('Change as at the end date is ok too.');
367: --

Line 381: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');

377: fetch csr_term_asg_future_act_exists into l_found;
378: if csr_term_asg_future_act_exists%notfound then
379: close csr_term_asg_exists;
380: close csr_term_asg_future_act_exists;
381: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
382: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(p_effective_date));
383: fnd_message.raise_error;
384: end if;
385: close csr_term_asg_future_act_exists;

Line 382: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(p_effective_date));

378: if csr_term_asg_future_act_exists%notfound then
379: close csr_term_asg_exists;
380: close csr_term_asg_future_act_exists;
381: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
382: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(p_effective_date));
383: fnd_message.raise_error;
384: end if;
385: close csr_term_asg_future_act_exists;
386: end if;

Line 383: fnd_message.raise_error;

379: close csr_term_asg_exists;
380: close csr_term_asg_future_act_exists;
381: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
382: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(p_effective_date));
383: fnd_message.raise_error;
384: end if;
385: close csr_term_asg_future_act_exists;
386: end if;
387: close csr_term_asg_exists;

Line 401: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');

397: fetch csr_term_asg_future_act_exists into l_found;
398: if csr_term_asg_future_act_exists%notfound then
399: close csr_term_asg_exists;
400: close csr_term_asg_future_act_exists;
401: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
402: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_cur_eff_end+1));
403: fnd_message.raise_error;
404: end if;
405: close csr_term_asg_future_act_exists;

Line 402: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_cur_eff_end+1));

398: if csr_term_asg_future_act_exists%notfound then
399: close csr_term_asg_exists;
400: close csr_term_asg_future_act_exists;
401: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
402: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_cur_eff_end+1));
403: fnd_message.raise_error;
404: end if;
405: close csr_term_asg_future_act_exists;
406: end if;

Line 403: fnd_message.raise_error;

399: close csr_term_asg_exists;
400: close csr_term_asg_future_act_exists;
401: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
402: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_cur_eff_end+1));
403: fnd_message.raise_error;
404: end if;
405: close csr_term_asg_future_act_exists;
406: end if;
407: close csr_term_asg_exists;

Line 561: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');

557: --
558: l_span_start := hr_gbbal.span_start(l_next_eff_end);
559: l_span_end := hr_gbbal.span_end(l_next_eff_end);
560: --
561: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
562: fnd_message.set_token('TAX_YEAR',
563: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
564: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
565: fnd_message.raise_error;

Line 562: fnd_message.set_token('TAX_YEAR',

558: l_span_start := hr_gbbal.span_start(l_next_eff_end);
559: l_span_end := hr_gbbal.span_end(l_next_eff_end);
560: --
561: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
562: fnd_message.set_token('TAX_YEAR',
563: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
564: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
565: fnd_message.raise_error;
566: END IF;

Line 565: fnd_message.raise_error;

561: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
562: fnd_message.set_token('TAX_YEAR',
563: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
564: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
565: fnd_message.raise_error;
566: END IF;
567: --
568:
569: -- START CHECK - Termination Assignment exists at the Effective start date

Line 581: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');

577: fetch csr_term_asg_future_act_exists into l_found;
578: if csr_term_asg_future_act_exists%notfound then
579: close csr_term_asg_exists;
580: close csr_term_asg_future_act_exists;
581: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
582: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_next_eff_end+1));
583: fnd_message.raise_error;
584: end if;
585: close csr_term_asg_future_act_exists;

Line 582: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_next_eff_end+1));

578: if csr_term_asg_future_act_exists%notfound then
579: close csr_term_asg_exists;
580: close csr_term_asg_future_act_exists;
581: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
582: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_next_eff_end+1));
583: fnd_message.raise_error;
584: end if;
585: close csr_term_asg_future_act_exists;
586: end if;

Line 583: fnd_message.raise_error;

579: close csr_term_asg_exists;
580: close csr_term_asg_future_act_exists;
581: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
582: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_next_eff_end+1));
583: fnd_message.raise_error;
584: end if;
585: close csr_term_asg_future_act_exists;
586: end if;
587: close csr_term_asg_exists;