[Home] [Help]
66: --
67: -- The primary key is invalid therefore we must error
68: --
69: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
70: hr_multi_message.add
71: (p_associated_column1
72: => nvl(p_associated_column1,'SECURITY_PROFILE_ID')
73: ,p_associated_column2
74: => nvl(p_associated_column2,'PAYROLL_ID')
273: -- Only proceed with validation when the Multiple Message List
274: -- does not already contain an error associated with the
275: -- below columns.
276: --
277: IF hr_multi_message.no_exclusive_error
278: (p_check_column1 => pay_spr_shd.g_tab_nam||'.SECURITY_PROFILE_ID'
279: ,p_associated_column1 => pay_spr_shd.g_tab_nam||'.SECURITY_PROFILE_ID'
280: ,p_check_column2 => pay_spr_shd.g_tab_nam||'.PAYROLL_ID'
281: ,p_associated_column2 => pay_spr_shd.g_tab_nam||'.PAYROLL_ID')
309: -- Multiple Message List and associate the error with the above columns.
310: --
311: WHEN app_exception.application_exception THEN
312:
313: IF hr_multi_message.exception_add
314: (p_same_associated_columns => 'Y') THEN
315:
316: hr_utility.set_location(' Leaving:'|| l_proc, 50);
317: RAISE;
348: -- Only proceed with validation when the Multiple Message List
349: -- does not already contain an error associated with the
350: -- below columns.
351: --
352: IF hr_multi_message.no_exclusive_error
353: (p_check_column1 => pay_spr_shd.g_tab_nam||'.SECURITY_PROFILE_ID'
354: ,p_associated_column1 => pay_spr_shd.g_tab_nam||'.SECURITY_PROFILE_ID')
355: THEN
356:
382: -- Multiple Message List and associate the error with the above columns.
383: --
384: WHEN app_exception.application_exception THEN
385:
386: IF hr_multi_message.exception_add
387: (p_same_associated_columns => 'Y') THEN
388:
389: hr_utility.set_location(' Leaving:'|| l_proc, 50);
390: RAISE;
514: -- After validating the set of important attributes,
515: -- if Multiple Message detection is enabled and at least
516: -- one error has been found then abort further validation.
517: --
518: hr_multi_message.end_validation_set;
519:
520: --
521: -- Validate Dependent Attributes.
522: -- First check for a duplicate payroll in this security profile.