[Home] [Help]
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,'GRADE_SPINE_ID')
67: );
68: --
1054: ,p_to_date => p_validation_end_date
1055: )) Then
1056: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
1057: fnd_message.set_token('TABLE_NAME','spinal point steps');
1058: hr_multi_message.add;
1059: End If;
1060: If (dt_api.rows_exist
1061: (p_base_table_name => 'per_cagr_entitlement_lines_f'
1062: ,p_base_key_column => 'grade_spine_id'
1065: ,p_to_date => p_validation_end_date
1066: )) Then
1067: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
1068: fnd_message.set_token('TABLE_NAME','cagr entitlement lines');
1069: hr_multi_message.add;
1070: End If;
1071: */
1072: --
1073: End If;
1123: -- After validating the set of important attributes,
1124: -- if Multiple Message detection is enabled and at least
1125: -- one error has been found then abort further validation.
1126: --
1127: hr_multi_message.end_validation_set;
1128:
1129: --
1130: -- Validate Dependent Attributes
1131: --
1224: -- After validating the set of important attributes,
1225: -- if Multiple Message detection is enabled and at least
1226: -- one error has been found then abort further validation.
1227: --
1228: hr_multi_message.end_validation_set;
1229: --
1230: -- Validate Dependent Attributes
1231: --
1232: -- Call the datetrack update integrity operation
1248: -- After validating the set of important attributes,
1249: -- if Multiple Message detection is enabled and at least
1250: -- one error has been found then abort further validation.
1251: --
1252: hr_multi_message.end_validation_set;
1253:
1254: --
1255: -- Validate Dependent Attributes
1256: --