[Home] [Help]
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,'WRKPLC_VLDTN_ID')
64: );
65: --
238: End If;
239: Close Vldtn_Name;
240: Exception
241: when app_exception.application_exception then
242: if hr_multi_message.exception_add
243: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTNS.Validation_Name'
244: ) then
245: hr_utility.set_location(' Leaving:'||l_proc,60);
246: raise;
259: hr_utility.raise_error;
260: End If;
261: Exception
262: when app_exception.application_exception then
263: if hr_multi_message.exception_add
264: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTNS.Employment_Type'
265: ) then
266: hr_utility.set_location(' Leaving:'||l_proc,60);
267: raise;
280: hr_utility.raise_error;
281: End If;
282: Exception
283: when app_exception.application_exception then
284: if hr_multi_message.exception_add
285: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTNS.REMUNERATION_REGULATION') then
286: hr_utility.set_location(' Leaving:'||l_proc,60);
287: raise;
288: end if;
309: End If;
310: Close Del;
311: Exception
312: when app_exception.application_exception then
313: if hr_multi_message.exception_add
314: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTNS.WRKPLC_VLDTN_ID'
315: ) then
316: hr_utility.set_location(' Leaving:'||l_proc,60);
317: raise;
342: -- After validating the set of important attributes,
343: -- if Multiple Message detection is enabled and at least
344: -- one error has been found then abort further validation.
345: --
346: hr_multi_message.end_validation_set;
347:
348: hr_utility.set_location('Entering:'||l_proc, 10);
349:
350: Chk_Unique_Validation_Name(P_Rec);
390: --
391:
392: hr_utility.set_location('Entering:'||l_proc, 10);
393:
394: hr_multi_message.end_validation_set;
395:
396: Chk_Unique_Validation_Name(P_Rec);
397: --
398: -- Validate Dependent Attributes