57: --
58: -- The primary key is invalid therefore we must error
59: --
60: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
61: hr_multi_message.add
62: (p_associated_column1
63: => nvl(p_associated_column1,'ELEMENT_TYPE_ID')
64: );
65: --
643: ,p_to_date => p_validation_end_date
644: )) Then
645: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
646: fnd_message.set_token('TABLE_NAME','input values');
647: hr_multi_message.add;
648: End If;
649: If (dt_api.rows_exist
650: (p_base_table_name => 'ben_acty_base_rt_f'
651: ,p_base_key_column => 'element_type_id'
654: ,p_to_date => p_validation_end_date
655: )) Then
656: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
657: fnd_message.set_token('TABLE_NAME','acty base rt');
658: hr_multi_message.add;
659: End If;
660: If (dt_api.rows_exist
661: (p_base_table_name => 'pay_element_links_f'
662: ,p_base_key_column => 'element_type_id'
665: ,p_to_date => p_validation_end_date
666: )) Then
667: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
668: fnd_message.set_token('TABLE_NAME','element links');
669: hr_multi_message.add;
670: End If;
671: If (dt_api.rows_exist
672: (p_base_table_name => 'pay_element_type_usages_f'
673: ,p_base_key_column => 'element_type_id'
676: ,p_to_date => p_validation_end_date
677: )) Then
678: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
679: fnd_message.set_token('TABLE_NAME','element type usages');
680: hr_multi_message.add;
681: End If;
682: --
683: End If;
684: --
2988: -- after validating the set of important attributes,
2989: -- if Multiple Message Detection is enabled and at least
2990: -- one error has been found then abort further validation.
2991: --
2992: hr_multi_message.end_validation_set;
2993: END IF;
2994: IF hr_startup_data_api_support.g_startup_mode NOT IN ('STARTUP') THEN
2995: --
2996: -- Validate Dependent Attributes
3176: -- After validating the set of important attributes,
3177: -- if Multiple Message Detection is enabled and at least
3178: -- one error has been found then abort further validation.
3179: --
3180: hr_multi_message.end_validation_set;
3181: END IF;
3182: IF hr_startup_data_api_support.g_startup_mode NOT IN ('STARTUP') THEN
3183: --
3184: --
3372: -- After validating the set of important attributes,
3373: -- if Multiple Message Detection is enabled and at least
3374: -- one error has been found then abort further validation.
3375: --
3376: hr_multi_message.end_validation_set;
3377: END IF;
3378: --
3379: chk_delete_allowed
3380: (p_rec.element_type_id