69: --
70: -- The primary key is invalid therefore we must error
71: --
72: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
73: hr_multi_message.add
74: (p_associated_column1
75: => nvl(p_associated_column1,'ACTIVITY_VERSION_ID')
76: ,p_associated_column2
77: => nvl(p_associated_column2,'PREREQUISITE_COURSE_ID')
274: --
275: hr_utility.set_location(' Leaving:'|| l_proc, 10);
276: Exception
277: WHEN app_exception.application_exception THEN
278: IF hr_multi_message.exception_add(
279: p_associated_column1 => 'OTA_COURSE_PREREQUISITES.activity_version_id',
280: p_associated_column2 => 'OTA_COURSE_PREREQUISITES.prerequisite_course_id')
281: THEN
282: hr_utility.set_location(' Leaving:'||l_proc, 22);
323: hr_utility.set_location(' Leaving:'|| l_proc, 10);
324:
325: Exception
326: WHEN app_exception.application_exception THEN
327: IF hr_multi_message.exception_add(
328: p_associated_column1 => 'OTA_COURSE_PREREQUISITES.prerequisite_course_id')
329: THEN
330:
331: hr_utility.set_location(' Leaving:'||l_proc, 22);
380: hr_utility.set_location(' Leaving:'|| l_proc, 10);
381:
382: Exception
383: WHEN app_exception.application_exception THEN
384: IF hr_multi_message.exception_add(
385: p_associated_column1 => 'OTA_COURSE_PREREQUISITES.activity_version_id',
386: p_associated_column2 => 'OTA_COURSE_PREREQUISITES.prerequisite_course_id')
387: THEN
388:
439:
440: Exception
441: WHEN app_exception.application_exception THEN
442:
443: IF hr_multi_message.exception_add(
444: p_associated_column1 => 'OTA_COURSE_PREREQUISITES.prerequisite_course_id')
445: THEN
446:
447: hr_utility.set_location(' Leaving:'||l_proc, 22);
504:
505: Exception
506: WHEN app_exception.application_exception THEN
507:
508: IF hr_multi_message.exception_add(
509: p_associated_column1 => 'OTA_COURSE_PREREQUISITES.activity_version_id',
510: p_associated_column2 => 'OTA_COURSE_PREREQUISITES.prerequisite_course_id')
511: THEN
512:
542: -- After validating the set of important attributes,
543: -- if Multiple Message detection is enabled and at least
544: -- one error has been found then abort further validation.
545: --
546: hr_multi_message.end_validation_set;
547: --
548: -- Validate Dependent Attributes
549:
550: check_unique_key( p_rec.activity_version_id
588: -- After validating the set of important attributes,
589: -- if Multiple Message detection is enabled and at least
590: -- one error has been found then abort further validation.
591: --
592: hr_multi_message.end_validation_set;
593: --
594: -- Validate Dependent Attributes
595: --
596: chk_non_updateable_args