DBA Data[Home] [Help]

APPS.PER_POS_STRUCTURE_VERSION_API dependencies on HR_UTILITY

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

30: l_pos_structure_version_id per_pos_Structure_versions.pos_structure_version_id%TYPE;
31: l_object_version_number per_pos_structure_versions.object_version_number%TYPE;
32: --
33: BEGIN
34: hr_utility.set_location('Entering:'|| l_proc, 10);
35: --
36: -- Issue a savepoint
37: --
38: savepoint create_pos_structure_version;

Line 66: hr_utility.set_location(l_proc, 20);

62: end;
63:
64: --
65: --
66: hr_utility.set_location(l_proc, 20);
67: --
68: -- Process Logic
69: --
70: per_psv_ins.ins

Line 86: hr_utility.set_location(l_proc, 60);

82: ,p_object_version_number => l_object_version_number
83: ,p_gap_warning => p_gap_warning
84: );
85: --
86: hr_utility.set_location(l_proc, 60);
87: --
88: -- When in validation only mode raise the Validate_Enabled exception
89: --
90: IF p_validate THEN

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

95: --
96: p_pos_structure_version_id := l_pos_structure_version_id;
97: p_object_version_number := l_object_version_number;
98: --
99: hr_utility.set_location(' Leaving:'||l_proc, 70);
100: --
101:
102:
103:

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

141: -- when validation only mode is being used.)
142: --
143: p_pos_structure_version_id := NULL;
144: p_object_version_number := NULL;
145: hr_utility.set_location(' Leaving:'||l_proc, 80);
146: WHEN OTHERS THEN
147: --
148: -- A validation or unexpected error has occurred
149: p_pos_structure_version_id := NULL;

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

149: p_pos_structure_version_id := NULL;
150: p_object_version_number := NULL;
151: p_gap_warning := NULL;
152: ROLLBACK TO create_pos_structure_version;
153: hr_utility.set_location(' Leaving:'||l_proc, 90);
154: RAISE;
155: --
156: END create_pos_structure_version;
157:

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

212: ,p_hook_type => 'BP'
213: );
214: end;
215: --
216: hr_utility.set_location('Entering:'|| l_proc, 10);
217: --
218: --
219: hr_utility.set_location(l_proc, 20);
220: --

Line 219: hr_utility.set_location(l_proc, 20);

215: --
216: hr_utility.set_location('Entering:'|| l_proc, 10);
217: --
218: --
219: hr_utility.set_location(l_proc, 20);
220: --
221: --
222: -- Process Logic
223: --

Line 246: hr_utility.set_location(l_proc, 60);

242: --
243: --
244: --
245: --
246: hr_utility.set_location(l_proc, 60);
247: --
248: -- When in validation only mode raise the Validate_Enabled exception
249: --
250: IF p_validate THEN

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

255: -- never reached, so p_object_version_number is passed back unchanged.
256: --
257: p_object_version_number := l_object_version_number;
258: --
259: hr_utility.set_location(' Leaving:'||l_proc, 70);
260: --
261:
262: begin
263: per_pos_structure_version_bk2.update_pos_structure_version_a

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

295: -- Only set output warning arguments
296: -- (Any key or derived arguments must be set to null
297: -- when validation only mode is being used.)
298:
299: hr_utility.set_location(' Leaving:'||l_proc, 80);
300: WHEN OTHERS THEN
301: --
302: -- A validation or unexpected error has occurred
303: p_gap_warning := NULL;

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

302: -- A validation or unexpected error has occurred
303: p_gap_warning := NULL;
304: p_object_version_number := l_temp_ovn;
305: ROLLBACK TO update_pos_structure_version;
306: hr_utility.set_location(' Leaving:'||l_proc, 90);
307: RAISE;
308: --
309: --
310: END update_pos_structure_version;

Line 356: hr_utility.set_location( l_proc, 30);

352: -- =============
353: --
354: -- Need to lock main table to maintain the locking ladder order
355: --
356: hr_utility.set_location( l_proc, 30);
357: per_psv_shd.lck (p_pos_structure_version_id => p_pos_structure_version_id,
358: p_object_version_number => p_object_version_number );
359: --
360: hr_utility.set_location( l_proc, 40);

Line 360: hr_utility.set_location( l_proc, 40);

356: hr_utility.set_location( l_proc, 30);
357: per_psv_shd.lck (p_pos_structure_version_id => p_pos_structure_version_id,
358: p_object_version_number => p_object_version_number );
359: --
360: hr_utility.set_location( l_proc, 40);
361: per_psv_del.del ( p_pos_structure_version_id => p_pos_structure_version_id,
362: p_object_version_number => p_object_version_number );
363: --
364: --

Line 365: hr_utility.set_location(' Leaving:'||l_proc, 60);

361: per_psv_del.del ( p_pos_structure_version_id => p_pos_structure_version_id,
362: p_object_version_number => p_object_version_number );
363: --
364: --
365: hr_utility.set_location(' Leaving:'||l_proc, 60);
366: --
367: -- When in validation only mode raise the Validate_Enabled exception
368: --
369: IF p_validate THEN

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

399: -- Only set output warning arguments
400: -- (Any key or derived arguments must be set to null
401: -- when validation only mode is being used.)
402: --
403: hr_utility.set_location(' Leaving:'||l_proc, 80);
404: WHEN OTHERS THEN
405: --
406: -- A validation or unexpected error has occurred
407: ROLLBACK TO delete_pos_structure_version;

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

404: WHEN OTHERS THEN
405: --
406: -- A validation or unexpected error has occurred
407: ROLLBACK TO delete_pos_structure_version;
408: hr_utility.set_location(' Leaving:'||l_proc, 90);
409: RAISE;
410: --
411: end delete_pos_structure_version;
412: --