eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_PAYROLL_RULES dependencies on FND_MESSAGE

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

165: --
166: l_span_start := hr_gbbal.span_start(l_cur_eff_start);
167: l_span_end := hr_gbbal.span_end(l_cur_eff_start);
168: --
169: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
170: fnd_message.set_token('TAX_YEAR',
171: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
172: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
173: fnd_message.raise_error;

Line 170: fnd_message.set_token('TAX_YEAR',

166: l_span_start := hr_gbbal.span_start(l_cur_eff_start);
167: l_span_end := hr_gbbal.span_end(l_cur_eff_start);
168: --
169: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
170: fnd_message.set_token('TAX_YEAR',
171: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
172: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
173: fnd_message.raise_error;
174: END IF;

Line 173: fnd_message.raise_error;

169: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
170: fnd_message.set_token('TAX_YEAR',
171: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
172: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
173: fnd_message.raise_error;
174: END IF;
175: --
176: hr_utility.trace('Change as at the start date is ok, Checking end date');
177: --

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

198: --
199: l_span_start := hr_gbbal.span_start(l_cur_eff_end);
200: l_span_end := hr_gbbal.span_end(l_cur_eff_end);
201: --
202: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
203: fnd_message.set_token('TAX_YEAR',
204: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
205: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
206: fnd_message.raise_error;

Line 203: fnd_message.set_token('TAX_YEAR',

199: l_span_start := hr_gbbal.span_start(l_cur_eff_end);
200: l_span_end := hr_gbbal.span_end(l_cur_eff_end);
201: --
202: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
203: fnd_message.set_token('TAX_YEAR',
204: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
205: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
206: fnd_message.raise_error;
207: END IF;

Line 206: fnd_message.raise_error;

202: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
203: fnd_message.set_token('TAX_YEAR',
204: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
205: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
206: fnd_message.raise_error;
207: END IF;
208: --
209: hr_utility.trace('Change as at the end date is ok too.');
210: --

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

223: fetch csr_term_asg_future_act_exists into l_found;
224: if csr_term_asg_future_act_exists%notfound then
225: close csr_term_asg_exists;
226: close csr_term_asg_future_act_exists;
227: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
228: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_cur_eff_start));
229: fnd_message.set_token('ASSG_NO', l_assg_no); --Bug Fix 7343780
230: fnd_message.raise_error;
231: end if;

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

224: if csr_term_asg_future_act_exists%notfound then
225: close csr_term_asg_exists;
226: close csr_term_asg_future_act_exists;
227: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
228: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_cur_eff_start));
229: fnd_message.set_token('ASSG_NO', l_assg_no); --Bug Fix 7343780
230: fnd_message.raise_error;
231: end if;
232: close csr_term_asg_future_act_exists;

Line 229: fnd_message.set_token('ASSG_NO', l_assg_no); --Bug Fix 7343780

225: close csr_term_asg_exists;
226: close csr_term_asg_future_act_exists;
227: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
228: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_cur_eff_start));
229: fnd_message.set_token('ASSG_NO', l_assg_no); --Bug Fix 7343780
230: fnd_message.raise_error;
231: end if;
232: close csr_term_asg_future_act_exists;
233: end if;

Line 230: fnd_message.raise_error;

226: close csr_term_asg_future_act_exists;
227: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
228: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_cur_eff_start));
229: fnd_message.set_token('ASSG_NO', l_assg_no); --Bug Fix 7343780
230: fnd_message.raise_error;
231: end if;
232: close csr_term_asg_future_act_exists;
233: end if;
234: close csr_term_asg_exists;

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

247: fetch csr_term_asg_future_act_exists into l_found;
248: if csr_term_asg_future_act_exists%notfound then
249: close csr_term_asg_exists;
250: close csr_term_asg_future_act_exists;
251: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
252: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_cur_eff_end+1));
253: fnd_message.set_token('ASSG_NO', l_assg_no); --Bug Fix 7343780
254: fnd_message.raise_error;
255: end if;

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

248: if csr_term_asg_future_act_exists%notfound then
249: close csr_term_asg_exists;
250: close csr_term_asg_future_act_exists;
251: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
252: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_cur_eff_end+1));
253: fnd_message.set_token('ASSG_NO', l_assg_no); --Bug Fix 7343780
254: fnd_message.raise_error;
255: end if;
256: close csr_term_asg_future_act_exists;

Line 253: fnd_message.set_token('ASSG_NO', l_assg_no); --Bug Fix 7343780

249: close csr_term_asg_exists;
250: close csr_term_asg_future_act_exists;
251: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
252: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_cur_eff_end+1));
253: fnd_message.set_token('ASSG_NO', l_assg_no); --Bug Fix 7343780
254: fnd_message.raise_error;
255: end if;
256: close csr_term_asg_future_act_exists;
257: end if;

Line 254: fnd_message.raise_error;

250: close csr_term_asg_future_act_exists;
251: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
252: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_cur_eff_end+1));
253: fnd_message.set_token('ASSG_NO', l_assg_no); --Bug Fix 7343780
254: fnd_message.raise_error;
255: end if;
256: close csr_term_asg_future_act_exists;
257: end if;
258: close csr_term_asg_exists;

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

281: --
282: l_span_start := hr_gbbal.span_start(p_effective_date);
283: l_span_end := hr_gbbal.span_end(p_effective_date);
284: --
285: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
286: fnd_message.set_token('TAX_YEAR',
287: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
288: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
289: fnd_message.raise_error;

Line 286: fnd_message.set_token('TAX_YEAR',

282: l_span_start := hr_gbbal.span_start(p_effective_date);
283: l_span_end := hr_gbbal.span_end(p_effective_date);
284: --
285: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
286: fnd_message.set_token('TAX_YEAR',
287: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
288: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
289: fnd_message.raise_error;
290: END IF;

Line 289: fnd_message.raise_error;

285: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
286: fnd_message.set_token('TAX_YEAR',
287: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
288: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
289: fnd_message.raise_error;
290: END IF;
291: --
292: hr_utility.trace('Change as at the new effective date ok, no need to check as at the effective end date');
293: --

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

306: fetch csr_term_asg_future_act_exists into l_found;
307: if csr_term_asg_future_act_exists%notfound then
308: close csr_term_asg_exists;
309: close csr_term_asg_future_act_exists;
310: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
311: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(p_effective_date));
312: fnd_message.set_token('ASSG_NO', l_assg_no); --Bug Fix 7343780
313: fnd_message.raise_error;
314: end if;

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

307: if csr_term_asg_future_act_exists%notfound then
308: close csr_term_asg_exists;
309: close csr_term_asg_future_act_exists;
310: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
311: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(p_effective_date));
312: fnd_message.set_token('ASSG_NO', l_assg_no); --Bug Fix 7343780
313: fnd_message.raise_error;
314: end if;
315: close csr_term_asg_future_act_exists;

Line 312: fnd_message.set_token('ASSG_NO', l_assg_no); --Bug Fix 7343780

308: close csr_term_asg_exists;
309: close csr_term_asg_future_act_exists;
310: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
311: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(p_effective_date));
312: fnd_message.set_token('ASSG_NO', l_assg_no); --Bug Fix 7343780
313: fnd_message.raise_error;
314: end if;
315: close csr_term_asg_future_act_exists;
316: end if;

Line 313: fnd_message.raise_error;

309: close csr_term_asg_future_act_exists;
310: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
311: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(p_effective_date));
312: fnd_message.set_token('ASSG_NO', l_assg_no); --Bug Fix 7343780
313: fnd_message.raise_error;
314: end if;
315: close csr_term_asg_future_act_exists;
316: end if;
317: close csr_term_asg_exists;

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

339: --
340: l_span_start := hr_gbbal.span_start(p_effective_date);
341: l_span_end := hr_gbbal.span_end(p_effective_date);
342: --
343: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
344: fnd_message.set_token('TAX_YEAR',
345: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
346: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
347: fnd_message.raise_error;

Line 344: fnd_message.set_token('TAX_YEAR',

340: l_span_start := hr_gbbal.span_start(p_effective_date);
341: l_span_end := hr_gbbal.span_end(p_effective_date);
342: --
343: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
344: fnd_message.set_token('TAX_YEAR',
345: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
346: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
347: fnd_message.raise_error;
348: END IF;

Line 347: fnd_message.raise_error;

343: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
344: fnd_message.set_token('TAX_YEAR',
345: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
346: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
347: fnd_message.raise_error;
348: END IF;
349: --
350: hr_utility.trace('Change as at the new effective date ok, Checking as at the effective end date');
351: --

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

373: --
374: l_span_start := hr_gbbal.span_start(l_cur_eff_end);
375: l_span_end := hr_gbbal.span_end(l_cur_eff_end);
376: --
377: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
378: fnd_message.set_token('TAX_YEAR',
379: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
380: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
381: fnd_message.raise_error;

Line 378: fnd_message.set_token('TAX_YEAR',

374: l_span_start := hr_gbbal.span_start(l_cur_eff_end);
375: l_span_end := hr_gbbal.span_end(l_cur_eff_end);
376: --
377: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
378: fnd_message.set_token('TAX_YEAR',
379: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
380: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
381: fnd_message.raise_error;
382: END IF;

Line 381: fnd_message.raise_error;

377: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
378: fnd_message.set_token('TAX_YEAR',
379: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
380: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
381: fnd_message.raise_error;
382: END IF;
383: --
384: hr_utility.trace('Change as at the end date is ok too.');
385: --

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

398: fetch csr_term_asg_future_act_exists into l_found;
399: if csr_term_asg_future_act_exists%notfound then
400: close csr_term_asg_exists;
401: close csr_term_asg_future_act_exists;
402: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
403: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(p_effective_date));
404: fnd_message.set_token('ASSG_NO', l_assg_no); --Bug Fix 7343780
405: fnd_message.raise_error;
406: end if;

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

399: if csr_term_asg_future_act_exists%notfound then
400: close csr_term_asg_exists;
401: close csr_term_asg_future_act_exists;
402: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
403: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(p_effective_date));
404: fnd_message.set_token('ASSG_NO', l_assg_no); --Bug Fix 7343780
405: fnd_message.raise_error;
406: end if;
407: close csr_term_asg_future_act_exists;

Line 404: fnd_message.set_token('ASSG_NO', l_assg_no); --Bug Fix 7343780

400: close csr_term_asg_exists;
401: close csr_term_asg_future_act_exists;
402: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
403: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(p_effective_date));
404: fnd_message.set_token('ASSG_NO', l_assg_no); --Bug Fix 7343780
405: fnd_message.raise_error;
406: end if;
407: close csr_term_asg_future_act_exists;
408: end if;

Line 405: fnd_message.raise_error;

401: close csr_term_asg_future_act_exists;
402: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
403: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(p_effective_date));
404: fnd_message.set_token('ASSG_NO', l_assg_no); --Bug Fix 7343780
405: fnd_message.raise_error;
406: end if;
407: close csr_term_asg_future_act_exists;
408: end if;
409: close csr_term_asg_exists;

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

422: fetch csr_term_asg_future_act_exists into l_found;
423: if csr_term_asg_future_act_exists%notfound then
424: close csr_term_asg_exists;
425: close csr_term_asg_future_act_exists;
426: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
427: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_cur_eff_end+1));
428: fnd_message.set_token('ASSG_NO', l_assg_no); --Bug Fix 7343780
429: fnd_message.raise_error;
430: end if;

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

423: if csr_term_asg_future_act_exists%notfound then
424: close csr_term_asg_exists;
425: close csr_term_asg_future_act_exists;
426: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
427: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_cur_eff_end+1));
428: fnd_message.set_token('ASSG_NO', l_assg_no); --Bug Fix 7343780
429: fnd_message.raise_error;
430: end if;
431: close csr_term_asg_future_act_exists;

Line 428: fnd_message.set_token('ASSG_NO', l_assg_no); --Bug Fix 7343780

424: close csr_term_asg_exists;
425: close csr_term_asg_future_act_exists;
426: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
427: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_cur_eff_end+1));
428: fnd_message.set_token('ASSG_NO', l_assg_no); --Bug Fix 7343780
429: fnd_message.raise_error;
430: end if;
431: close csr_term_asg_future_act_exists;
432: end if;

Line 429: fnd_message.raise_error;

425: close csr_term_asg_future_act_exists;
426: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
427: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_cur_eff_end+1));
428: fnd_message.set_token('ASSG_NO', l_assg_no); --Bug Fix 7343780
429: fnd_message.raise_error;
430: end if;
431: close csr_term_asg_future_act_exists;
432: end if;
433: close csr_term_asg_exists;

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

589: --
590: l_span_start := hr_gbbal.span_start(l_next_eff_end);
591: l_span_end := hr_gbbal.span_end(l_next_eff_end);
592: --
593: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
594: fnd_message.set_token('TAX_YEAR',
595: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
596: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
597: fnd_message.raise_error;

Line 594: fnd_message.set_token('TAX_YEAR',

590: l_span_start := hr_gbbal.span_start(l_next_eff_end);
591: l_span_end := hr_gbbal.span_end(l_next_eff_end);
592: --
593: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
594: fnd_message.set_token('TAX_YEAR',
595: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
596: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
597: fnd_message.raise_error;
598: END IF;

Line 597: fnd_message.raise_error;

593: fnd_message.set_name('PAY', 'HR_78126_INCONSISTENT_PAYE_REF');
594: fnd_message.set_token('TAX_YEAR',
595: substr(fnd_date.date_to_canonical(l_span_start), 1, 4)||'-'||
596: substr(fnd_date.date_to_canonical(l_span_end), 1, 4));
597: fnd_message.raise_error;
598: END IF;
599: --
600:
601: -- START CHECK - Termination Assignment exists at the Effective start date

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

612: fetch csr_term_asg_future_act_exists into l_found;
613: if csr_term_asg_future_act_exists%notfound then
614: close csr_term_asg_exists;
615: close csr_term_asg_future_act_exists;
616: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
617: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_next_eff_end+1));
618: fnd_message.set_token('ASSG_NO', l_assg_no); --Bug Fix 7343780
619: fnd_message.raise_error;
620: end if;

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

613: if csr_term_asg_future_act_exists%notfound then
614: close csr_term_asg_exists;
615: close csr_term_asg_future_act_exists;
616: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
617: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_next_eff_end+1));
618: fnd_message.set_token('ASSG_NO', l_assg_no); --Bug Fix 7343780
619: fnd_message.raise_error;
620: end if;
621: close csr_term_asg_future_act_exists;

Line 618: fnd_message.set_token('ASSG_NO', l_assg_no); --Bug Fix 7343780

614: close csr_term_asg_exists;
615: close csr_term_asg_future_act_exists;
616: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
617: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_next_eff_end+1));
618: fnd_message.set_token('ASSG_NO', l_assg_no); --Bug Fix 7343780
619: fnd_message.raise_error;
620: end if;
621: close csr_term_asg_future_act_exists;
622: end if;

Line 619: fnd_message.raise_error;

615: close csr_term_asg_future_act_exists;
616: fnd_message.set_name('PAY', 'HR_GB_78131_TERM_ASSIGN_EXIST');
617: fnd_message.set_token('EFF_DATE', fnd_date.date_to_displaydate(l_next_eff_end+1));
618: fnd_message.set_token('ASSG_NO', l_assg_no); --Bug Fix 7343780
619: fnd_message.raise_error;
620: end if;
621: close csr_term_asg_future_act_exists;
622: end if;
623: close csr_term_asg_exists;