172: --
173: Begin
174: hr_utility.set_location('Entering:'||l_proc, 5);
175: --
176: hr_api.mandatory_arg_error
177: (p_api_name => l_proc
178: ,p_argument => 'POSTING_CONTENT_ID'
179: ,p_argument_value => p_posting_content_id
180: );
178: ,p_argument => 'POSTING_CONTENT_ID'
179: ,p_argument_value => p_posting_content_id
180: );
181: hr_utility.set_location(l_proc,6);
182: hr_api.mandatory_arg_error
183: (p_api_name => l_proc
184: ,p_argument => 'LANGUAGE'
185: ,p_argument_value => p_language
186: );
229: --
230: -- We need to trap the ORA LOCK exception
231: --
232: Exception
233: When HR_Api.Object_Locked then
234: --
235: -- The object is locked therefore we need to supply a meaningful
236: -- error message.
237: --
622: --
623: hr_utility.set_location(' Leaving:'||l_proc, 100);
624: --
625: Exception
626: When hr_api.check_integrity_violated Then
627: -- A check constraint has been violated
628: --
629: irc_ipt_shd.constraint_error
630: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
626: When hr_api.check_integrity_violated Then
627: -- A check constraint has been violated
628: --
629: irc_ipt_shd.constraint_error
630: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
631: When hr_api.parent_integrity_violated Then
632: -- Parent integrity has been violated
633: --
634: irc_ipt_shd.constraint_error
627: -- A check constraint has been violated
628: --
629: irc_ipt_shd.constraint_error
630: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
631: When hr_api.parent_integrity_violated Then
632: -- Parent integrity has been violated
633: --
634: irc_ipt_shd.constraint_error
635: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
631: When hr_api.parent_integrity_violated Then
632: -- Parent integrity has been violated
633: --
634: irc_ipt_shd.constraint_error
635: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
636: When hr_api.unique_integrity_violated Then
637: -- Unique integrity has been violated
638: --
639: irc_ipt_shd.constraint_error
632: -- Parent integrity has been violated
633: --
634: irc_ipt_shd.constraint_error
635: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
636: When hr_api.unique_integrity_violated Then
637: -- Unique integrity has been violated
638: --
639: irc_ipt_shd.constraint_error
640: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
636: When hr_api.unique_integrity_violated Then
637: -- Unique integrity has been violated
638: --
639: irc_ipt_shd.constraint_error
640: (p_constraint_name => hr_api.strip_constraint_name(SQLERRM));
641: When Others Then
642: --
643: Raise;
644: End clob_dml;