DBA Data[Home] [Help]

APPS.PQP_VEHICLE_ALLOCATIONS_API dependencies on HR_UTILITY

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

85: l_proc varchar2(72) := g_package||'CREATE_VEHICLE_ALLOCATION';
86: l_effective_date date;
87: l_fuel_card pqp_vehicle_allocations_f.fuel_card%TYPE;
88: begin
89: hr_utility.set_location('Entering:'|| l_proc, 10);
90: --
91: -- Issue a savepoint
92: --
93: savepoint CREATE_VEHICLE_ALLOCATION;

Line 94: hr_utility.set_location(l_proc, 20);

90: --
91: -- Issue a savepoint
92: --
93: savepoint CREATE_VEHICLE_ALLOCATION;
94: hr_utility.set_location(l_proc, 20);
95: --
96: --Truncate date parameter
97: l_effective_date :=TRUNC(p_effective_date);
98:

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

410: p_object_version_number := p_object_version_number;
411: p_effective_start_date := p_effective_start_date;
412: p_effective_end_date := p_effective_end_date ;
413: --
414: hr_utility.set_location(' Leaving:'||l_proc, 70);
415: exception
416: when hr_api.validate_enabled then
417: --
418: -- As the Validate_Enabled exception has been raised

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

427: p_vehicle_allocation_id := null;
428: p_object_version_number := null;
429: p_effective_start_date := null;
430: p_effective_end_date := null ;
431: hr_utility.set_location(' Leaving:'||l_proc, 80);
432: when others then
433: --
434: -- A validation or unexpected error has occured
435: --

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

443: p_object_version_number := null;
444: p_effective_start_date := null;
445: p_effective_end_date := null ;
446:
447: hr_utility.set_location(' Leaving:'||l_proc, 90);
448: raise;
449: end create_vehicle_allocation;
450: --
451:

Line 537: hr_utility.set_location(l_proc, 20);

533: -- Issue a savepoint
534: --
535: savepoint update_vehicle_allocation;
536:
537: hr_utility.set_location(l_proc, 20);
538: --Truncate effective date parameter
539: l_effective_date :=TRUNC(p_effective_date);
540:
541: --If fuel card is NULL then make it 'N';

Line 848: hr_utility.set_location(l_proc, 60);

844: ,p_hook_type => 'AP'
845: );
846: end;
847:
848: hr_utility.set_location(l_proc, 60);
849: --
850: -- When in validation only mode raise the Validate_Enabled exception
851: --
852: if p_validate then

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

856: -- Set all output arguments
857: --
858: p_effective_start_date := p_effective_start_date;
859: p_effective_end_date := p_effective_end_date ;
860: hr_utility.set_location(' Leaving:'||l_proc, 70);
861: exception
862: when hr_api.validate_enabled then
863: --
864: -- As the Validate_Enabled exception has been raised

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

871: -- when validation only mode is being used.)
872: --
873: p_effective_start_date := null;
874: p_effective_end_date := null;
875: hr_utility.set_location(' Leaving:'||l_proc, 80);
876: when others then
877: --
878: -- A validation or unexpected error has occured
879: --

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

879: --
880: rollback to update_vehicle_allocation;
881: p_effective_start_date := null;
882: p_effective_end_date := null;
883: hr_utility.set_location(' Leaving:'||l_proc, 90);
884: raise;
885: END update_vehicle_allocation;
886: --
887: -- ----------------------------------------------------------------------------

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

901: l_effective_date date;
902:
903: BEGIN
904:
905: hr_utility.set_location('Entering:'|| l_proc, 10);
906: --
907: -- Issue a savepoint
908: --
909: savepoint delete_vehicle_allocation;

Line 911: hr_utility.set_location(l_proc, 20);

907: -- Issue a savepoint
908: --
909: savepoint delete_vehicle_allocation;
910: --
911: hr_utility.set_location(l_proc, 20);
912: --truncate effective_date parameter
913: l_effective_date :=TRUNC(p_effective_date);
914:
915: --

Line 978: hr_utility.set_location(l_proc, 60);

974: (p_module_name => 'PQP_VEHICLE_ALLOCATIONS_API'
975: ,p_hook_type => 'AP'
976: );
977: end;
978: hr_utility.set_location(l_proc, 60);
979: --
980: -- When in validation only mode raise the Validate_Enabled exception
981: --
982: if p_validate then

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

988: --
989: p_object_version_number := p_object_version_number;
990: p_effective_start_date := p_effective_start_date;
991: p_effective_end_date := p_effective_end_date ;
992: hr_utility.set_location(' Leaving:'||l_proc, 70);
993: exception
994: when hr_api.validate_enabled then
995: --
996: -- As the Validate_Enabled exception has been raised

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

1005: p_object_version_number := null;
1006: p_effective_start_date := null;
1007: p_effective_end_date := null ;
1008:
1009: hr_utility.set_location(' Leaving:'||l_proc, 80);
1010: when others then
1011: --
1012: -- A validation or unexpected error has occured
1013: --

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

1015: p_object_version_number := null;
1016: p_effective_start_date := null;
1017: p_effective_end_date := null ;
1018:
1019: hr_utility.set_location(' Leaving:'||l_proc, 90);
1020: raise;
1021:
1022: END delete_vehicle_allocation;
1023: