DBA Data[Home] [Help]

APPS.HR_POS_HIERARCHY_ELE_API dependencies on HR_UTILITY

Line 62: hr_utility.set_location('Entering:'|| l_proc, 10);

58:
59: --end changes for bug 6139893
60:
61: begin
62: hr_utility.set_location('Entering:'|| l_proc, 10);
63: --
64: -- Issue a savepoint
65: --
66: savepoint create_pos_hierarchy_ele;

Line 103: hr_utility.set_message(801,'PER_7421_POS_PARENT_BELOW');

99: fetch chk_child_sub_node into l_chk;
100:
101: if chk_child_sub_node%found THEN
102: close chk_child_sub_node;
103: hr_utility.set_message(801,'PER_7421_POS_PARENT_BELOW');
104: hr_utility.raise_error;
105: ELSE
106: CLOSE chk_child_sub_node;
107: END if;

Line 104: hr_utility.raise_error;

100:
101: if chk_child_sub_node%found THEN
102: close chk_child_sub_node;
103: hr_utility.set_message(801,'PER_7421_POS_PARENT_BELOW');
104: hr_utility.raise_error;
105: ELSE
106: CLOSE chk_child_sub_node;
107: END if;
108: ---

Line 174: hr_utility.set_location(' Leaving:'||l_proc, 70);

170: --
171: -- Set all output arguments
172: -- use values returned from ins (PZWALKER)
173: --
174: hr_utility.set_location(' Leaving:'||l_proc, 70);
175: exception
176: when hr_api.validate_enabled then
177: --
178: -- As the Validate_Enabled exception has been raised

Line 189: hr_utility.set_location(' Leaving:'||l_proc, 80);

185: -- when validation only mode is being used.)
186: --
187: p_pos_structure_element_id := null;
188: p_object_version_number := null;
189: hr_utility.set_location(' Leaving:'||l_proc, 80);
190: when others then
191: --
192: -- A validation or unexpected error has occured
193: --

Line 197: hr_utility.set_location(' Leaving:'||l_proc, 90);

193: --
194: p_pos_structure_element_id := null;
195: p_object_version_number := null;
196: rollback to create_pos_hierarchy_ele;
197: hr_utility.set_location(' Leaving:'||l_proc, 90);
198: raise;
199: end create_pos_hierarchy_ele;
200: --
201: --

Line 223: hr_utility.set_location('Entering:'|| l_proc, 10);

219: l_object_version_number per_pos_structure_elements
220: .object_version_number%TYPE;
221: l_temp_ovn number := p_object_version_number;
222: begin
223: hr_utility.set_location('Entering:'|| l_proc, 10);
224: --
225: l_object_version_number := p_object_version_number;
226: --
227: -- Issue a savepoint

Line 291: hr_utility.set_location(' Leaving:'||l_proc, 70);

287: -- Set all output arguments
288: --
289: p_object_version_number := l_object_version_number;
290: --
291: hr_utility.set_location(' Leaving:'||l_proc, 70);
292: exception
293: when hr_api.validate_enabled then
294: --
295: -- As the Validate_Enabled exception has been raised

Line 305: hr_utility.set_location(' Leaving:'||l_proc, 80);

301: -- (Any key or derived arguments must be set to null
302: -- when validation only mode is being used.)
303: --
304: p_object_version_number := p_object_version_number;
305: hr_utility.set_location(' Leaving:'||l_proc, 80);
306: when others then
307: --
308: -- A validation or unexpected error has occured
309: --

Line 312: hr_utility.set_location(' Leaving:'||l_proc, 90);

308: -- A validation or unexpected error has occured
309: --
310: p_object_version_number := l_temp_ovn;
311: rollback to update_pos_hierarchy_ele;
312: hr_utility.set_location(' Leaving:'||l_proc, 90);
313: raise;
314: end update_pos_hierarchy_ele;
315: --
316: -- ----------------------------------------------------------------------------

Line 331: hr_utility.set_location('Entering:'|| l_proc, 10);

327: -- Declare cursors and local variables
328: --
329: l_proc varchar2(72) := g_package||'delete_pos_hierarchy_ele';
330: begin
331: hr_utility.set_location('Entering:'|| l_proc, 10);
332: --
333: --
334: -- Issue a savepoint
335: --

Line 392: hr_utility.set_location(' Leaving:'||l_proc, 70);

388: --
389: -- Set all output arguments
390: --
391: --
392: hr_utility.set_location(' Leaving:'||l_proc, 70);
393: exception
394: when hr_api.validate_enabled then
395: --
396: -- As the Validate_Enabled exception has been raised

Line 405: hr_utility.set_location(' Leaving:'||l_proc, 80);

401: -- Only set output warning arguments
402: -- (Any key or derived arguments must be set to null
403: -- when validation only mode is being used.)
404: --
405: hr_utility.set_location(' Leaving:'||l_proc, 80);
406: when others then
407: --
408: -- A validation or unexpected error has occured
409: --

Line 411: hr_utility.set_location(' Leaving:'||l_proc, 90);

407: --
408: -- A validation or unexpected error has occured
409: --
410: rollback to delete_pos_hierarchy_ele;
411: hr_utility.set_location(' Leaving:'||l_proc, 90);
412: raise;
413: end delete_pos_hierarchy_ele;
414: --
415: --