DBA Data[Home] [Help]

APPS.PQH_TXN_JOB_REQUIREMENTS_API dependencies on HR_UTILITY

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

56: l_proc varchar2(72) := g_package||'CREATE_TXN_JOB_REQUIREMENT';
57: l_txn_job_requirement_id PQH_TXN_JOB_REQUIREMENTS.TXN_JOB_REQUIREMENT_ID%TYPE;
58: l_object_version_number PQH_TXN_JOB_REQUIREMENTS.object_version_number%TYPE;
59: begin
60: hr_utility.set_location('Entering:'|| l_proc, 10);
61: --
62: -- Issue a savepoint
63: --
64: savepoint CREATE_TXN_JOB_REQUIREMENT;

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

224: --
225: p_txn_job_requirement_id := l_txn_job_requirement_id;
226: p_object_version_number := l_object_version_number;
227: --
228: hr_utility.set_location(' Leaving:'||l_proc, 70);
229: exception
230: when hr_api.validate_enabled then
231: --
232: -- As the Validate_Enabled exception has been raised

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

239: -- when validation only mode is being used.)
240: --
241: p_txn_job_requirement_id := null;
242: p_object_version_number := null;
243: hr_utility.set_location(' Leaving:'||l_proc, 80);
244: when others then
245: p_txn_job_requirement_id := null;
246: p_object_version_number := null;
247: --

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

247: --
248: -- A validation or unexpected error has occured
249: --
250: rollback to CREATE_TXN_JOB_REQUIREMENT;
251: hr_utility.set_location(' Leaving:'||l_proc, 90);
252: raise;
253: end CREATE_TXN_JOB_REQUIREMENT;
254: --
255: -- ----------------------------------------------------------------------------

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

302:
303: l_proc varchar2(72) := g_package||'UPDATE_TXN_JOB_REQUIREMENT';
304: l_object_version_number PQH_TXN_JOB_REQUIREMENTS.object_version_number%TYPE;
305: begin
306: hr_utility.set_location('Entering:'|| l_proc, 10);
307: --
308: -- Issue a savepoint
309: --
310: savepoint UPDATE_TXN_JOB_REQUIREMENT;

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

471: -- Set all output arguments
472: --
473: p_object_version_number := l_object_version_number;
474: --
475: hr_utility.set_location(' Leaving:'||l_proc, 70);
476: exception
477: when hr_api.validate_enabled then
478: --
479: -- As the Validate_Enabled exception has been raised

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

485: -- (Any key or derived arguments must be set to null
486: -- when validation only mode is being used.)
487: --
488: p_object_version_number := null;
489: hr_utility.set_location(' Leaving:'||l_proc, 80);
490: when others then
491: p_object_version_number := l_object_version_number;
492: --
493: -- A validation or unexpected error has occured

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

492: --
493: -- A validation or unexpected error has occured
494: --
495: rollback to UPDATE_TXN_JOB_REQUIREMENT;
496: hr_utility.set_location(' Leaving:'||l_proc, 90);
497: raise;
498: end UPDATE_TXN_JOB_REQUIREMENT;
499: --
500: -- ----------------------------------------------------------------------------

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

513:
514: l_proc varchar2(72) := g_package||'DELETE_TXN_JOB_REQUIREMENT';
515: l_object_version_number PQH_TXN_JOB_REQUIREMENTS.object_version_number%TYPE;
516: begin
517: hr_utility.set_location('Entering:'|| l_proc, 10);
518: --
519: -- Issue a savepoint
520: --
521: savepoint DELETE_TXN_JOB_REQUIREMENT;

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

579: --
580: -- Set all output arguments
581: --
582: --
583: hr_utility.set_location(' Leaving:'||l_proc, 70);
584: exception
585: when hr_api.validate_enabled then
586: --
587: -- As the Validate_Enabled exception has been raised

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

592: -- Only set output warning arguments
593: -- (Any key or derived arguments must be set to null
594: -- when validation only mode is being used.)
595: --
596: hr_utility.set_location(' Leaving:'||l_proc, 80);
597: when others then
598: --
599: -- A validation or unexpected error has occured
600: --

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

598: --
599: -- A validation or unexpected error has occured
600: --
601: rollback to DELETE_TXN_JOB_REQUIREMENT;
602: hr_utility.set_location(' Leaving:'||l_proc, 90);
603: raise;
604: end DELETE_TXN_JOB_REQUIREMENT;
605: --
606: end PQH_TXN_JOB_REQUIREMENTS_API;