237: fnd_message.raise_error;
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);
258: hr_utility.set_message(8302, 'PQH_DE_EMPTYP_VALDTN_DEF');
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);
279: hr_utility.set_message(8302, 'PQH_DE_REMRGU_VALDTN_DEF');
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;
308: hr_utility.raise_error;
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);