DBA Data[Home] [Help]

APPS.PQP_VEH_ALLOC_EXTRA_INFO_API dependencies on HR_UTILITY

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

79: l_in_out_parameter number;
80: l_effective_date date;
81: l_proc varchar2(72) := g_package||'CREATE_VEH_ALLOC_EXTRA_INFO';
82: begin
83: hr_utility.set_location('Entering:'|| l_proc, 10);
84: --
85: -- Issue a savepoint
86: --
87: savepoint CREATE_VEH_ALLOC_EXTRA_INFO;

Line 171: hr_utility.set_location('Entering row handler:'|| p_vaei_information9, 10);

167: --
168: -- Validation in addition to Row Handlers
169: --
170:
171: hr_utility.set_location('Entering row handler:'|| p_vaei_information9, 10);
172: pqp_vai_ins.ins
173: ( p_vehicle_allocation_id =>p_vehicle_allocation_id
174: ,p_information_type =>p_information_type
175: ,p_vaei_attribute_category =>p_vaei_attribute_category

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

321: --
322: p_veh_alloc_extra_info_id :=p_veh_alloc_extra_info_id;
323: p_object_version_number :=p_object_version_number;
324: --
325: hr_utility.set_location(' Leaving:'||l_proc, 70);
326: exception
327: when hr_api.validate_enabled then
328: --
329: -- As the Validate_Enabled exception has been raised

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

336: -- when validation only mode is being used.)
337: --
338: p_veh_alloc_extra_info_id :=null;
339: p_object_version_number :=null;
340: hr_utility.set_location(' Leaving:'||l_proc, 80);
341: when others then
342: --
343: -- A validation or unexpected error has occured
344: --

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

348: -- OUT parameters, including warnings, to null
349: --
350: p_veh_alloc_extra_info_id :=null;
351: p_object_version_number :=null;
352: hr_utility.set_location(' Leaving:'||l_proc, 90);
353: raise;
354: end create_veh_alloc_extra_info;
355:
356: -- ----------------------------------------------------------------------------

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

425: l_effective_date date;
426: l_proc varchar2(72) := g_package||'UPDATE_VEH_ALLOC_EXTRA_INFO';
427: begin
428:
429: hr_utility.set_location('Entering:'|| l_proc, 10);
430: --
431: -- Issue a savepoint
432: --
433: savepoint UPDATE_VEH_ALLOC_EXTRA_INFO;

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

667: --
668: -- Set all IN OUT and OUT parameters with out values
669: --
670: --
671: hr_utility.set_location(' Leaving:'||l_proc, 70);
672: exception
673: when hr_api.validate_enabled then
674: --
675: -- As the Validate_Enabled exception has been raised

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

680: -- Reset IN OUT parameters and set OUT parameters
681: -- (Any key or derived arguments must be set to null
682: -- when validation only mode is being used.)
683: --
684: hr_utility.set_location(' Leaving:'||l_proc, 80);
685: when others then
686: --
687: -- A validation or unexpected error has occured
688: --

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

690: --
691: -- Reset IN OUT parameters and set all
692: -- OUT parameters, including warnings, to null
693: --
694: hr_utility.set_location(' Leaving:'||l_proc, 90);
695: raise;
696: end update_veh_alloc_extra_info;
697: -- ----------------------------------------------------------------------------
698: -- |--------------------< DELETE_VEH_ALLOC_EXTRA_INFO >--------------------|

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

715: l_proc varchar2(72) := g_package||'DELETE_VEH_ALLOC_EXTRA_INFO';
716:
717: begin
718:
719: hr_utility.set_location('Entering:'|| l_proc, 10);
720: --
721: -- Issue a savepoint
722: --
723: savepoint delete_veh_alloc_extra_info;

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

783: --
784: -- Set all IN OUT and OUT parameters with out values
785: --
786: --
787: hr_utility.set_location(' Leaving:'||l_proc, 70);
788: exception
789: when hr_api.validate_enabled then
790: --
791: -- As the Validate_Enabled exception has been raised

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

796: -- Reset IN OUT parameters and set OUT parameters
797: -- (Any key or derived arguments must be set to null
798: -- when validation only mode is being used.)
799: --
800: hr_utility.set_location(' Leaving:'||l_proc, 80);
801: when others then
802: --
803: -- A validation or unexpected error has occured
804: --

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

806: --
807: -- Reset IN OUT parameters and set all
808: -- OUT parameters, including warnings, to null
809: --
810: hr_utility.set_location(' Leaving:'||l_proc, 90);
811: raise;
812: end delete_veh_alloc_extra_info;
813: end PQP_VEH_ALLOC_EXTRA_INFO_API;