DBA Data[Home] [Help]

APPS.PQH_ASSIGN_ACCOMMODATIONS_API dependencies on HR_UTILITY

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

104: l_effective_start_date pqh_assign_accommodations_f.effective_start_date%TYPE;
105: l_effective_end_date pqh_assign_accommodations_f.effective_end_date%TYPE;
106: --
107: begin
108: hr_utility.set_location('Entering:'|| l_proc, 10);
109: --
110: -- Issue a savepoint
111: --
112: savepoint CREATE_ASSIGN_ACCOMMODATION;

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

405: p_object_version_number := l_object_version_number;
406: p_effective_start_date := l_effective_start_date;
407: p_effective_end_date := l_effective_end_date;
408: --
409: hr_utility.set_location(' Leaving:'||l_proc, 70);
410: exception
411: when hr_api.validate_enabled then
412: --
413: -- As the Validate_Enabled exception has been raised

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

422: p_assignment_acco_id := null;
423: p_object_version_number := null;
424: p_effective_start_date := null;
425: p_effective_end_date := null;
426: hr_utility.set_location(' Leaving:'||l_proc, 80);
427: when others then
428: p_assignment_acco_id := null;
429: p_object_version_number := null;
430: p_effective_start_date := null;

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

433: --
434: -- A validation or unexpected error has occured
435: --
436: rollback to CREATE_ASSIGN_ACCOMMODATION;
437: hr_utility.set_location(' Leaving:'||l_proc, 90);
438: raise;
439: end create_assign_accommodation;
440: --
441: --

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

538: l_effective_end_date pqh_assign_accommodations_f.effective_end_date%TYPE;
539: l_object_version_number number := p_object_version_number;
540: --
541: begin
542: hr_utility.set_location('Entering:'|| l_proc, 10);
543: --
544: -- Issue a savepoint
545: --
546: savepoint UPDATE_ASSIGN_ACCOMMODATION;

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

843: p_object_version_number := p_object_version_number;
844: p_effective_start_date := l_effective_start_date;
845: p_effective_end_date := l_effective_end_date;
846: --
847: hr_utility.set_location(' Leaving:'||l_proc, 70);
848: exception
849: when hr_api.validate_enabled then
850: --
851: -- As the Validate_Enabled exception has been raised

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

860: p_object_version_number := l_object_version_number;
861: p_effective_start_date := null;
862: p_effective_end_date := null;
863:
864: hr_utility.set_location(' Leaving:'||l_proc, 80);
865: when others then
866: p_object_version_number := l_object_version_number;
867: p_effective_start_date := null;
868: p_effective_end_date := null;

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

869: --
870: -- A validation or unexpected error has occured
871: --
872: rollback to UPDATE_ASSIGN_ACCOMMODATION;
873: hr_utility.set_location(' Leaving:'||l_proc, 90);
874: raise;
875: end update_assign_accommodation;
876: --
877: --

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

898: l_object_version_number number := p_object_version_number;
899:
900: --
901: begin
902: hr_utility.set_location('Entering:'|| l_proc, 10);
903: --
904: -- Issue a savepoint
905: --
906: savepoint DELETE_ASSIGN_ACCOMMODATION;

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

974: p_effective_start_date := l_effective_start_date;
975: p_effective_end_date := l_effective_end_date;
976: --
977: --
978: hr_utility.set_location(' Leaving:'||l_proc, 70);
979: exception
980: when hr_api.validate_enabled then
981: --
982: -- As the Validate_Enabled exception has been raised

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

991: p_object_version_number := l_object_version_number;
992: p_effective_start_date := null;
993: p_effective_end_date := null;
994: --
995: hr_utility.set_location(' Leaving:'||l_proc, 80);
996: when others then
997: p_object_version_number := l_object_version_number;
998: p_effective_start_date := null;
999: p_effective_end_date := null;

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

1000: --
1001: -- A validation or unexpected error has occured
1002: --
1003: rollback to DELETE_ASSIGN_ACCOMMODATION;
1004: hr_utility.set_location(' Leaving:'||l_proc, 90);
1005: raise;
1006: end delete_assign_accommodation;
1007: --
1008: end pqh_assign_accommodations_api;