DBA Data[Home] [Help]

APPS.OTA_TMT_API dependencies on HR_UTILITY

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

61: l_tp_measurement_type_id number;
62: l_object_version_number number;
63: l_effective_date date;
64: begin
65: hr_utility.set_location('Entering:'|| l_proc, 10);
66: --
67: -- Issue a savepoint
68: --
69: savepoint create_measure;

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

239: --
240: p_tp_measurement_type_id := l_tp_measurement_type_id;
241: p_object_version_number := l_object_version_number;
242: --
243: hr_utility.set_location(' Leaving:'||l_proc, 70);
244: exception
245: when hr_api.validate_enabled then
246: --
247: -- As the Validate_Enabled exception has been raised

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

254: -- when validation only mode is being used.)
255: --
256: p_tp_measurement_type_id := null;
257: p_object_version_number := null;
258: hr_utility.set_location(' Leaving:'||l_proc, 80);
259: when others then
260: --
261: -- A validation or unexpected error has occured
262: --

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

262: --
263: rollback to create_measure;
264: p_tp_measurement_type_id := null;
265: p_object_version_number := null;
266: hr_utility.set_location(' Leaving:'||l_proc, 90);
267: raise;
268: end create_measure;
269: -- ----------------------------------------------------------------------------
270: -- |-------------------------< UPDATE_MEASURE >-------------------------------|

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

319: l_proc varchar2(72) := g_package||' Update Measure';
320: l_object_version_number number := p_object_version_number;
321: l_effective_date date;
322: begin
323: hr_utility.set_location('Entering:'|| l_proc, 10);
324: --
325: -- Issue a savepoint
326: --
327: savepoint update_measure;

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

492: -- Set all output arguments
493: --
494: p_object_version_number := l_object_version_number;
495: --
496: hr_utility.set_location(' Leaving:'||l_proc, 70);
497: exception
498: when hr_api.validate_enabled then
499: --
500: -- As the Validate_Enabled exception has been raised

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

506: -- (Any key or derived arguments must be set to null
507: -- when validation only mode is being used.)
508: --
509: p_object_version_number := null;
510: hr_utility.set_location(' Leaving:'||l_proc, 80);
511: when others then
512: --
513: -- A validation or unexpected error has occured
514: --

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

513: -- A validation or unexpected error has occured
514: --
515: rollback to update_measure;
516: p_object_version_number := l_object_version_number;
517: hr_utility.set_location(' Leaving:'||l_proc, 90);
518: raise;
519: end update_measure;
520: --
521: -- ----------------------------------------------------------------------------

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

554: and pb.budget_id = pbv.budget_id
555: and pb.budget_type_code = 'OTA_BUDGET';
556: --
557: begin
558: hr_utility.set_location('Entering:'|| l_proc, 10);
559: --
560: -- Issue a savepoint
561: --
562: savepoint delete_measure;

Line 587: hr_utility.set_location(' Step:'|| l_proc, 60);

583: --
584: --
585: -- Process Logic
586: --
587: hr_utility.set_location(' Step:'|| l_proc, 60);
588: ota_tmt_del.del
589: (p_tp_measurement_type_id => p_tp_measurement_type_id
590: ,p_object_version_number => p_object_version_number
591: );

Line 592: hr_utility.set_location(' Step:'|| l_proc, 65);

588: ota_tmt_del.del
589: (p_tp_measurement_type_id => p_tp_measurement_type_id
590: ,p_object_version_number => p_object_version_number
591: );
592: hr_utility.set_location(' Step:'|| l_proc, 65);
593: --
594: -- The business rules only allow deletion of the measure if no
595: -- PER_BUDGET_VALUES records exist For the business group.
596: -- An exception would have been raised by the chk_ procedures

Line 603: hr_utility.set_location(' Step:'|| l_proc, 70);

599: --
600: -- Delete the per_budget_version records (if any exist)
601: --
602: FOR l_loop IN csr_get_budget_version_rowid LOOP
603: hr_utility.set_location(' Step:'|| l_proc, 70);
604: PER_BUDGET_VERSION_RULES_PKG.Delete_Row(X_Rowid => l_loop.row_id);
605: END LOOP;
606: --
607: -- Delete the per_budgets records (if any exist)

Line 610: hr_utility.set_location(' Step:'|| l_proc, 80);

606: --
607: -- Delete the per_budgets records (if any exist)
608: --
609: FOR l_loop IN csr_get_budget_rowid LOOP
610: hr_utility.set_location(' Step:'|| l_proc, 80);
611: per_budgets_pkg.delete_row(X_Rowid => l_loop.row_id);
612: END LOOP;
613: --
614: -- Call After Process User Hook

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

634: --
635: -- Set all output arguments
636: --
637: --
638: hr_utility.set_location(' Leaving:'||l_proc, 170);
639: exception
640: when hr_api.validate_enabled then
641: --
642: -- As the Validate_Enabled exception has been raised

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

647: -- Only set output warning arguments
648: -- (Any key or derived arguments must be set to null
649: -- when validation only mode is being used.)
650: --
651: hr_utility.set_location(' Leaving:'||l_proc, 180);
652: when others then
653: --
654: -- A validation or unexpected error has occured
655: --

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

653: --
654: -- A validation or unexpected error has occured
655: --
656: rollback to delete_measure;
657: hr_utility.set_location(' Leaving:'||l_proc, 190);
658: raise;
659: end delete_measure;
660: --
661: end ota_tmt_api;