[Home] [Help]
60: --
61: -- The primary key is invalid therefore we must error
62: --
63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
64: hr_multi_message.add
65: (p_associated_column1
66: => nvl(p_associated_column1,'CERTIFICATION_MEMBER_ID')
67: );
68: --
381:
382: Begin
383: hr_utility.set_location(' Entering:' || l_proc,10);
384: --
385: IF hr_multi_message.no_exclusive_error
386: (p_check_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
387: ,p_check_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
388: ,p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
389: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
430: hr_utility.set_location(' Leaving:' || l_proc,10);
431:
432: Exception
433: when app_exception.application_exception then
434: IF hr_multi_message.exception_add
435: (p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
436: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
437: ) THEN
438: raise;
473:
474: Begin
475: hr_utility.set_location(' Entering:' || l_proc,10);
476: --
477: IF hr_multi_message.no_exclusive_error
478: (p_check_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
479: ,p_check_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
480: ,p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
481: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
522: hr_utility.set_location(' Leaving:' || l_proc,10);
523:
524: Exception
525: when app_exception.application_exception then
526: IF hr_multi_message.exception_add
527: (p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
528: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
529: ) THEN
530: raise;
571:
572: Begin
573: hr_utility.set_location(' Entering:' || l_proc,10);
574: --
575: IF hr_multi_message.no_exclusive_error
576: (p_check_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
577: ,p_check_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
578: ,p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
579: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
599: hr_utility.set_location(' Leaving:' || l_proc,10);
600:
601: Exception
602: when app_exception.application_exception then
603: IF hr_multi_message.exception_add
604: (p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
605: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
606: ) THEN
607: raise;
653: --
654:
655: p_return_status := 'S';
656:
657: IF hr_multi_message.no_exclusive_error
658: (p_check_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
659: ,p_check_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
660: ,p_associated_column1 => 'OTA_CERTIFICATION_MEMBERS.START_DATE_ACTIVE'
661: ,p_associated_column2 => 'OTA_CERTIFICATION_MEMBERS.END_DATE_ACTIVE'
798: -- After validating the set of important attributes,
799: -- if Multiple Message detection is enabled and at least
800: -- one error has been found then abort further validation.
801: --
802: hr_multi_message.end_validation_set;
803: hr_utility.set_location(' Step:'|| l_proc,10);
804: --
805: -- Validate Dependent Attributes
806: --
848: -- After validating the set of important attributes,
849: -- if Multiple Message detection is enabled and at least
850: -- one error has been found then abort further validation.
851: --
852: hr_multi_message.end_validation_set;
853: --
854: -- Validate Dependent Attributes
855: --
856: chk_non_updateable_args