DBA Data[Home] [Help]

APPS.HR_POS_HIERARCHY_ELE_API dependencies on HR_UTILITY

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

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

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

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

Line 103: hr_utility.raise_error;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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