DBA Data[Home] [Help]

APPS.OTA_TPS_API dependencies on HR_UTILITY

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

81: select person_id,learning_path_id
82: from ota_training_plans
83: where training_plan_id = crs_id;
84: begin
85: hr_utility.set_location('Entering:'|| l_proc, 10);
86: --
87: -- Issue a savepoint
88: --
89: savepoint CREATE_TRAINING_PLAN;

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

300: p_learningpath_ids => l_learning_path_id,
301: p_itemkey =>l_item_key);
302: end if;
303: --
304: hr_utility.set_location(' Leaving:'||l_proc, 70);
305: exception
306: when hr_api.validate_enabled then
307: --
308: -- As the Validate_Enabled exception has been raised

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

315: -- when validation only mode is being used.)
316: --
317: p_training_plan_id := null;
318: p_object_version_number := null;
319: hr_utility.set_location(' Leaving:'||l_proc, 80);
320: when others then
321: --
322: -- A validation or unexpected error has occured
323: --

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

323: --
324: rollback to CREATE_TRAINING_PLAN;
325: p_training_plan_id := null;
326: p_object_version_number := null;
327: hr_utility.set_location(' Leaving:'||l_proc, 90);
328: raise;
329: end create_training_plan;
330: -- ----------------------------------------------------------------------------
331: -- |-------------------------< UPDATE_TRAINING_PLAN >-------------------------|

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

399: from ota_training_plans
400: where training_plan_id = p_training_plan_id;
401:
402: begin
403: hr_utility.set_location('Entering:'|| l_proc, 10);
404: --
405: -- Issue a savepoint
406: --
407: savepoint UPDATE_TRAINING_PLAN;

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

604: end if;
605: --
606: -- Set all output arguments
607: --
608: hr_utility.set_location(' Leaving:'||l_proc, 70);
609: exception
610: when hr_api.validate_enabled then
611: --
612: -- As the Validate_Enabled exception has been raised

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

618: -- (Any key or derived arguments must be set to null
619: -- when validation only mode is being used.)
620: --
621: p_object_version_number := null;
622: hr_utility.set_location(' Leaving:'||l_proc, 80);
623: when others then
624: --
625: -- A validation or unexpected error has occured
626: --

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

625: -- A validation or unexpected error has occured
626: --
627: rollback to UPDATE_TRAINING_PLAN;
628: p_object_version_number := l_object_version_number;
629: hr_utility.set_location(' Leaving:'||l_proc, 90);
630: raise;
631: end update_training_plan;
632: --
633: -- ----------------------------------------------------------------------------

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

646: l_budget_version_id number;
647: --
648: --
649: begin
650: hr_utility.set_location('Entering:'|| l_proc, 10);
651: --
652: -- Issue a savepoint
653: --
654: savepoint DELETE_TRAINING_PLAN;

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

704: --
705: -- Set all output arguments
706: --
707: --
708: hr_utility.set_location(' Leaving:'||l_proc, 170);
709: exception
710: when hr_api.validate_enabled then
711: --
712: -- As the Validate_Enabled exception has been raised

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

717: -- Only set output warning arguments
718: -- (Any key or derived arguments must be set to null
719: -- when validation only mode is being used.)
720: --
721: hr_utility.set_location(' Leaving:'||l_proc, 180);
722: when others then
723: --
724: -- A validation or unexpected error has occured
725: --

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

723: --
724: -- A validation or unexpected error has occured
725: --
726: rollback to DELETE_TRAINING_PLAN;
727: hr_utility.set_location(' Leaving:'||l_proc, 190);
728: raise;
729: end delete_training_plan;
730: --
731: end ota_tps_api;