63: --
64: -- The primary key is invalid therefore we must error
65: --
66: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
67: hr_multi_message.add
68: (p_associated_column1
69: => nvl(p_associated_column1,'INPUT_VALUE_ID')
70: );
71: --
290: ,p_from_date => p_validation_start_date
291: ,p_to_date => p_validation_end_date))) Then
292: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
293: fnd_message.set_token('TABLE_NAME','element types');
294: hr_multi_message.add
295: (p_associated_column1 => pay_ivl_shd.g_tab_nam || '.ELEMENT_TYPE_ID');
296: End If;
297: --
298: Exception
400: ,p_to_date => p_validation_end_date
401: )) Then
402: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
403: fnd_message.set_token('TABLE_NAME','acty base rt');
404: hr_multi_message.add;
405: End If;
406: If (dt_api.rows_exist
407: (p_base_table_name => 'pay_link_input_values_f'
408: ,p_base_key_column => 'input_value_id'
412: ,p_to_date => p_validation_end_date
413: )) Then
414: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
415: fnd_message.set_token('TABLE_NAME','link input values');
416: hr_multi_message.add;
417: End If;
418: --
419: End If;
420: --
1995: -- after validating the set of important attributes,
1996: -- if Multiple Message Detection is enabled and at least
1997: -- one error has been found then abort further validation.
1998: --
1999: hr_multi_message.end_validation_set;
2000: END IF;
2001:
2002: pay_ivl_bus.chk_other_insert_val
2003: (p_element_type_id => p_rec.element_type_id
2136: -- After validating the set of important attributes,
2137: -- if Multiple Message Detection is enabled and at least
2138: -- one error has been found then abort further validation.
2139: --
2140: hr_multi_message.end_validation_set;
2141:
2142: END IF;
2143:
2144: pay_ivl_bus.chk_other_upd_val
2302: -- After validating the set of important attributes,
2303: -- if Multiple Message Detection is enabled and at least
2304: -- one error has been found then abort further validation.
2305: --
2306: hr_multi_message.end_validation_set;
2307:
2308: END IF;
2309:
2310: pay_ivl_bus.chk_delete_allowed