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