17: --
18: Begin
19: hr_utility.set_location('Entering:'||l_proc, 5);
20: --
21: If (p_constraint_name = 'PAY_ELEMENT_TEMPLATES_PK') Then
22: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
23: hr_utility.set_message_token('PROCEDURE', l_proc);
24: hr_utility.set_message_token('STEP','5');
25: hr_utility.raise_error;
118: configuration_information28,
119: configuration_information29,
120: configuration_information30,
121: object_version_number
122: from pay_element_templates
123: where template_id = p_template_id;
124: --
125: l_proc varchar2(72) := g_package||'api_updating';
126: l_fct_ret boolean;
259: configuration_information28,
260: configuration_information29,
261: configuration_information30,
262: object_version_number
263: from pay_element_templates
264: where template_id = p_template_id
265: for update nowait;
266: --
267: l_proc varchar2(72) := g_package||'lck';
308: -- The object is locked therefore we need to supply a meaningful
309: -- error message.
310: --
311: hr_utility.set_message(801, 'HR_7165_OBJECT_LOCKED');
312: hr_utility.set_message_token('TABLE_NAME', 'pay_element_templates');
313: hr_utility.raise_error;
314: End lck;
315: --
316: -- ----------------------------------------------------------------------------