DBA Data[Home] [Help]

APPS.OTA_SKILL_PROVISION_API dependencies on HR_UTILITY

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

46: l_proc varchar2(72) := g_package||' Create Skill Provision';
47: l_skill_provision_id number;
48: l_object_version_number number;
49: begin
50: hr_utility.set_location('Entering:'|| l_proc, 10);
51: --
52: -- Issue a savepoint
53: --
54: savepoint CREATE_SKILL_PROVISION;

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

176: --
177: p_skill_provision_id := l_skill_provision_id;
178: p_object_version_number := l_object_version_number;
179: --
180: hr_utility.set_location(' Leaving:'||l_proc, 70);
181: exception
182: when hr_api.validate_enabled then
183: --
184: -- As the Validate_Enabled exception has been raised

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

191: -- when validation only mode is being used.)
192: --
193: p_skill_provision_id := null;
194: p_object_version_number := null;
195: hr_utility.set_location(' Leaving:'||l_proc, 80);
196: when others then
197: --
198: -- A validation or unexpected error has occured
199: --

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

199: --
200: rollback to CREATE_SKILL_PROVISION;
201: p_skill_provision_id := null;
202: p_object_version_number := null;
203: hr_utility.set_location(' Leaving:'||l_proc, 90);
204: raise;
205: end create_skill_provision;
206: -- ----------------------------------------------------------------------------
207: -- |-------------------------< UPDATE_SKILL_PROVISION >-------------------------|

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

243: --
244: l_proc varchar2(72) := g_package||' Update Skill Provision';
245: l_object_version_number number := p_object_version_number;
246: begin
247: hr_utility.set_location('Entering:'|| l_proc, 10);
248: --
249: -- Issue a savepoint
250: --
251: savepoint UPDATE_SKILL_PROVISION;

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

370: end if;
371: --
372: -- Set all output arguments
373: --
374: hr_utility.set_location(' Leaving:'||l_proc, 70);
375: exception
376: when hr_api.validate_enabled then
377: --
378: -- As the Validate_Enabled exception has been raised

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

384: -- (Any key or derived arguments must be set to null
385: -- when validation only mode is being used.)
386: --
387: p_object_version_number := null;
388: hr_utility.set_location(' Leaving:'||l_proc, 80);
389: when others then
390: --
391: -- A validation or unexpected error has occured
392: --

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

391: -- A validation or unexpected error has occured
392: --
393: rollback to UPDATE_SKILL_PROVISION;
394: p_object_version_number := l_object_version_number;
395: hr_utility.set_location(' Leaving:'||l_proc, 90);
396: raise;
397: end update_skill_provision;
398: --
399: -- ----------------------------------------------------------------------------

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

412: l_proc varchar2(72) := g_package||' Delete Skill Provision';
413: --
414: --
415: begin
416: hr_utility.set_location('Entering:'|| l_proc, 10);
417: --
418: -- Issue a savepoint
419: --
420: savepoint DELETE_SKILL_PROVISION;

Line 472: hr_utility.set_location(' Leaving:'||l_proc, 170);

468: --
469: -- Set all output arguments
470: --
471: --
472: hr_utility.set_location(' Leaving:'||l_proc, 170);
473: exception
474: when hr_api.validate_enabled then
475: --
476: -- As the Validate_Enabled exception has been raised

Line 485: hr_utility.set_location(' Leaving:'||l_proc, 180);

481: -- Only set output warning arguments
482: -- (Any key or derived arguments must be set to null
483: -- when validation only mode is being used.)
484: --
485: hr_utility.set_location(' Leaving:'||l_proc, 180);
486: when others then
487: --
488: -- A validation or unexpected error has occured
489: --

Line 491: hr_utility.set_location(' Leaving:'||l_proc, 190);

487: --
488: -- A validation or unexpected error has occured
489: --
490: rollback to DELETE_SKILL_PROVISION;
491: hr_utility.set_location(' Leaving:'||l_proc, 190);
492: raise;
493: end delete_skill_provision;
494: --
495: end ota_skill_provision_api;