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