[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_VER_ID')
64: );
65: --
254: End If;
255: Close Tariff_Contract;
256: Exception
257: when app_exception.application_exception then
258: if hr_multi_message.exception_add
259: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTN_VERS.TARIFF_CONTRACT_CODE'
260: ) then
261: hr_utility.set_location(' Leaving:'||l_proc,60);
262: raise;
297: End If;
298: Close Tariff_Group;
299: Exception
300: when app_exception.application_exception then
301: if hr_multi_message.exception_add
302: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTN_VERS.TARIFF_GROUP_CODE'
303: ) then
304: hr_utility.set_location(' Leaving:'||l_proc,60);
305: raise;
395: End If;
396: End If;
397: Exception
398: when app_exception.application_exception then
399: if hr_multi_message.exception_add
400: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTN_VERS.DERIVED_GRADE_ID'
401: ) then
402: hr_utility.set_location(' Leaving:'||l_proc,60);
403: raise;
424: End If;
425: End If;
426: Exception
427: when app_exception.application_exception then
428: if hr_multi_message.exception_add
429: (p_associated_column1 => 'PQH_DE_WRKPLC_VLDTN_VERS.FREEZE'
430: ) then
431: hr_utility.set_location(' Leaving:'||l_proc,60);
432: raise;
461: -- After validating the set of important attributes,
462: -- if Multiple Message detection is enabled and at least
463: -- one error has been found then abort further validation.
464: --
465: hr_multi_message.end_validation_set;
466:
467:
468: Ckh_Tariff_Contract(p_effective_date, p_rec);
469:
504: -- After validating the set of important attributes,
505: -- if Multiple Message detection is enabled and at least
506: -- one error has been found then abort further validation.
507: --
508: hr_multi_message.end_validation_set;
509: --
510: -- Validate Dependent Attributes
511: --
512: chk_non_updateable_args