DBA Data[Home] [Help]

APPS.PER_SECONDARY_ASS_STATUSES_PKG dependencies on HR_UTILITY

Line 462: hr_utility.set_message(801,'HR_6436_EMP_STATUS_STAT_EXIST');

458: open c;
459: fetch c into l_exists;
460: if c%found then
461: close c;
462: hr_utility.set_message(801,'HR_6436_EMP_STATUS_STAT_EXIST');
463: hr_utility.raise_error;
464: end if;
465: close c;
466: end check_unique_row;

Line 463: hr_utility.raise_error;

459: fetch c into l_exists;
460: if c%found then
461: close c;
462: hr_utility.set_message(801,'HR_6436_EMP_STATUS_STAT_EXIST');
463: hr_utility.raise_error;
464: end if;
465: close c;
466: end check_unique_row;
467: --

Line 492: hr_utility.set_message(801,'HR_6464_EMP_STATUS_ASS_DATE');

488: fetch c into l_exists;
489: if c%notfound then
490: close c;
491: if p_date_type = 'S' then
492: hr_utility.set_message(801,'HR_6464_EMP_STATUS_ASS_DATE');
493: else
494: hr_utility.set_message(801,'HR_6851_EMP_STATUS_END_DATE');
495: end if;
496: hr_utility.raise_error;

Line 494: hr_utility.set_message(801,'HR_6851_EMP_STATUS_END_DATE');

490: close c;
491: if p_date_type = 'S' then
492: hr_utility.set_message(801,'HR_6464_EMP_STATUS_ASS_DATE');
493: else
494: hr_utility.set_message(801,'HR_6851_EMP_STATUS_END_DATE');
495: end if;
496: hr_utility.raise_error;
497: end if;
498: close c;

Line 496: hr_utility.raise_error;

492: hr_utility.set_message(801,'HR_6464_EMP_STATUS_ASS_DATE');
493: else
494: hr_utility.set_message(801,'HR_6851_EMP_STATUS_END_DATE');
495: end if;
496: hr_utility.raise_error;
497: end if;
498: close c;
499: end validate_date;
500: --

Line 506: hr_utility.set_message(801,'HR_6021_ALL_START_END_DATE');

502: procedure validate_start_end_date(p_start_date date
503: ,p_end_date date) is
504: begin
505: if p_start_date > p_end_date then
506: hr_utility.set_message(801,'HR_6021_ALL_START_END_DATE');
507: hr_utility.raise_error;
508: end if;
509: end validate_start_end_date;
510: --

Line 507: hr_utility.raise_error;

503: ,p_end_date date) is
504: begin
505: if p_start_date > p_end_date then
506: hr_utility.set_message(801,'HR_6021_ALL_START_END_DATE');
507: hr_utility.raise_error;
508: end if;
509: end validate_start_end_date;
510: --
511: --