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,'EVENT_GROUP_USAGE_ID')
67: );
68: --
295: hr_utility.set_location(' Leaving:'|| l_proc, 20);
296:
297: exception
298: when app_exception.application_exception then
299: if hr_multi_message.exception_add
300: (p_associated_column1 => 'PAY_EVENT_GROUP_USAGES.ELEMENT_SET_ID'
301: ) then
302: raise;
303: end if;
393: hr_utility.set_location(' Leaving:'|| l_proc, 20);
394:
395: exception
396: when app_exception.application_exception then
397: if hr_multi_message.exception_add
398: (p_associated_column1 => 'PAY_EVENT_GROUP_USAGES.EVENT_GROUP_ID'
399: ) then
400: raise;
401: end if;
469: begin
470:
471: hr_utility.set_location('Entering:'|| l_proc, 10);
472:
473: if hr_multi_message.no_exclusive_error
474: (p_check_column1 => 'PAY_EVENT_GROUP_USAGES.EVENT_GROUP_ID'
475: ,p_check_column2 => 'PAY_EVENT_GROUP_USAGES.ELEMENT_SET_ID'
476: ,p_associated_column1 => 'PAY_EVENT_GROUP_USAGES.EVENT_GROUP_ID'
477: ,p_associated_column2 => 'PAY_EVENT_GROUP_USAGES.ELEMENT_SET_ID'
493:
494: exception
495:
496: when app_exception.application_exception then
497: if hr_multi_message.exception_add
498: (p_associated_column1 => 'PAY_EVENT_GROUP_USAGES.EVENT_GROUP_ID',
499: p_associated_column2 => 'PAY_EVENT_GROUP_USAGES.ELEMENT_SET_ID') then
500: raise;
501: end if;
562: hr_utility.set_location(' Leaving:'|| l_proc, 20);
563: --
564: exception
565: when app_exception.application_exception then
566: if hr_multi_message.exception_add
567: (p_associated_column1 => 'PAY_EVENT_GROUP_USAGES.LEGISLATION_CODE'
568: ) then
569: raise;
570: end if;
609: -- after validating the set of important attributes,
610: -- if Multiple Message Detection is enabled and at least
611: -- one error has been found then abort further validation.
612: --
613: hr_multi_message.end_validation_set;
614: END IF;
615: --
616: if hr_startup_data_api_support.g_startup_mode not in ('GENERIC','USER') then
617:
619: -- Validate Important Attributes
620: --
621: chk_legislation_code(p_legislation_code => p_rec.legislation_code);
622: --
623: hr_multi_message.end_validation_set;
624:
625: end if;
626: --
627: --
677: -- After validating the set of important attributes,
678: -- if Multiple Message Detection is enabled and at least
679: -- one error has been found then abort further validation.
680: --
681: hr_multi_message.end_validation_set;
682: END IF;
683: --
684: -- Call all supporting business operations
685: --