DBA Data[Home] [Help]

APPS.OTA_GENERAL dependencies on FND_MESSAGE

Line 265: fnd_message.set_name('OTA', 'OTA_13312_GEN_DATE_ORDER');

261: Begin
262: --
263: If p_end_date is not null then
264: if p_start_date > p_end_date then
265: fnd_message.set_name('OTA', 'OTA_13312_GEN_DATE_ORDER');
266: fnd_message.raise_error;
267: end if;
268: end if;
269: --

Line 266: fnd_message.raise_error;

262: --
263: If p_end_date is not null then
264: if p_start_date > p_end_date then
265: fnd_message.set_name('OTA', 'OTA_13312_GEN_DATE_ORDER');
266: fnd_message.raise_error;
267: end if;
268: end if;
269: --
270: End check_start_end_dates;

Line 302: fnd_message.set_name('OTA', 'OTA_13314_GEN_CS_PS');

298: --
299: If nvl( p_child_start, hr_api.g_sot) < p_par_start Then
300: --
301: -- ** TEMP ** Add error message with the following text.
302: fnd_message.set_name('OTA', 'OTA_13314_GEN_CS_PS');
303: fnd_message.raise_error;
304: --
305: End if;
306: --

Line 303: fnd_message.raise_error;

299: If nvl( p_child_start, hr_api.g_sot) < p_par_start Then
300: --
301: -- ** TEMP ** Add error message with the following text.
302: fnd_message.set_name('OTA', 'OTA_13314_GEN_CS_PS');
303: fnd_message.raise_error;
304: --
305: End if;
306: --
307: -- Child enddate is earlier than parent startdate

Line 312: fnd_message.set_name('OTA', 'OTA_13314_GEN_CS_PS');

308: --
309: If nvl( p_child_end, hr_api.g_eot) < p_par_start Then
310: --
311: -- ** TEMP ** Add error message with the following text.
312: fnd_message.set_name('OTA', 'OTA_13314_GEN_CS_PS');
313: fnd_message.raise_error;
314: --
315: End if;
316: --

Line 313: fnd_message.raise_error;

309: If nvl( p_child_end, hr_api.g_eot) < p_par_start Then
310: --
311: -- ** TEMP ** Add error message with the following text.
312: fnd_message.set_name('OTA', 'OTA_13314_GEN_CS_PS');
313: fnd_message.raise_error;
314: --
315: End if;
316: --
317: End if;

Line 328: fnd_message.set_name('OTA', 'OTA_13314_GEN_CS_PS');

324: --
325: If nvl( p_child_start, hr_api.g_sot) > p_par_end Then
326: --
327: -- ** TEMP ** Add error message with the following text.
328: fnd_message.set_name('OTA', 'OTA_13314_GEN_CS_PS');
329: fnd_message.raise_error;
330: --
331: End if;
332: --

Line 329: fnd_message.raise_error;

325: If nvl( p_child_start, hr_api.g_sot) > p_par_end Then
326: --
327: -- ** TEMP ** Add error message with the following text.
328: fnd_message.set_name('OTA', 'OTA_13314_GEN_CS_PS');
329: fnd_message.raise_error;
330: --
331: End if;
332: --
333: -- Child enddate is later than parent enddate

Line 338: fnd_message.set_name('OTA', 'OTA_13314_GEN_CS_PS');

334: --
335: If nvl( p_child_end, hr_api.g_eot) > p_par_end Then
336: --
337: -- ** TEMP ** Add error message with the following text.
338: fnd_message.set_name('OTA', 'OTA_13314_GEN_CS_PS');
339: fnd_message.raise_error;
340: --
341: End if;
342: --

Line 339: fnd_message.raise_error;

335: If nvl( p_child_end, hr_api.g_eot) > p_par_end Then
336: --
337: -- ** TEMP ** Add error message with the following text.
338: fnd_message.set_name('OTA', 'OTA_13314_GEN_CS_PS');
339: fnd_message.raise_error;
340: --
341: End if;
342: --
343: End if;

Line 436: fnd_message.set_name('OTA', 'OTA_13316_GEN_TIMES_ORDER');

432: Begin
433: --
434: if p_start_time is null AND p_end_time is NOT null then
435: --
436: fnd_message.set_name('OTA', 'OTA_13316_GEN_TIMES_ORDER');
437: fnd_message.raise_error;
438: --
439: elsif p_start_time is NOT null AND p_end_time is null then
440: --

Line 437: fnd_message.raise_error;

433: --
434: if p_start_time is null AND p_end_time is NOT null then
435: --
436: fnd_message.set_name('OTA', 'OTA_13316_GEN_TIMES_ORDER');
437: fnd_message.raise_error;
438: --
439: elsif p_start_time is NOT null AND p_end_time is null then
440: --
441: fnd_message.set_name('OTA', 'OTA_13316_GEN_TIMES_ORDER');

Line 441: fnd_message.set_name('OTA', 'OTA_13316_GEN_TIMES_ORDER');

437: fnd_message.raise_error;
438: --
439: elsif p_start_time is NOT null AND p_end_time is null then
440: --
441: fnd_message.set_name('OTA', 'OTA_13316_GEN_TIMES_ORDER');
442: fnd_message.raise_error;
443: --
444: elsif substr( p_start_time, 1, 2) = substr( p_end_time, 1, 2) then
445: --

Line 442: fnd_message.raise_error;

438: --
439: elsif p_start_time is NOT null AND p_end_time is null then
440: --
441: fnd_message.set_name('OTA', 'OTA_13316_GEN_TIMES_ORDER');
442: fnd_message.raise_error;
443: --
444: elsif substr( p_start_time, 1, 2) = substr( p_end_time, 1, 2) then
445: --
446: if substr( p_start_time, 4, 2) > substr( p_end_time, 4, 2) then

Line 448: fnd_message.set_name('OTA', 'OTA_13316_GEN_TIMES_ORDER');

444: elsif substr( p_start_time, 1, 2) = substr( p_end_time, 1, 2) then
445: --
446: if substr( p_start_time, 4, 2) > substr( p_end_time, 4, 2) then
447: --
448: fnd_message.set_name('OTA', 'OTA_13316_GEN_TIMES_ORDER');
449: fnd_message.raise_error;
450: --
451: end if;
452: --

Line 449: fnd_message.raise_error;

445: --
446: if substr( p_start_time, 4, 2) > substr( p_end_time, 4, 2) then
447: --
448: fnd_message.set_name('OTA', 'OTA_13316_GEN_TIMES_ORDER');
449: fnd_message.raise_error;
450: --
451: end if;
452: --
453: elsif substr( p_start_time, 1, 2) > substr( p_end_time, 1, 2) then

Line 455: fnd_message.set_name('OTA', 'OTA_13316_GEN_TIMES_ORDER');

451: end if;
452: --
453: elsif substr( p_start_time, 1, 2) > substr( p_end_time, 1, 2) then
454: --
455: fnd_message.set_name('OTA', 'OTA_13316_GEN_TIMES_ORDER');
456: fnd_message.raise_error;
457: --
458: end if;
459: --

Line 456: fnd_message.raise_error;

452: --
453: elsif substr( p_start_time, 1, 2) > substr( p_end_time, 1, 2) then
454: --
455: fnd_message.set_name('OTA', 'OTA_13316_GEN_TIMES_ORDER');
456: fnd_message.raise_error;
457: --
458: end if;
459: --
460: End check_start_end_time;