DBA Data[Home] [Help]

APPS.PQH_ACCOMMODATIONS_API dependencies on HR_UTILITY

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

118: l_effective_start_date pqh_accommodations_f.effective_start_date%TYPE;
119: l_effective_end_date pqh_accommodations_f.effective_end_date%TYPE;
120: --
121: begin
122: hr_utility.set_location('Entering:'|| l_proc, 10);
123: --
124: -- Issue a savepoint
125: --
126: savepoint CREATE_ACCOMMODATION;

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

461: p_object_version_number := l_object_version_number;
462: p_effective_start_date := l_effective_start_date;
463: p_effective_end_date := l_effective_end_date;
464: --
465: hr_utility.set_location(' Leaving:'||l_proc, 70);
466: exception
467: when hr_api.validate_enabled then
468: --
469: -- As the Validate_Enabled exception has been raised

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

478: p_accommodation_id := null;
479: p_object_version_number := null;
480: p_effective_start_date := null;
481: p_effective_end_date := null;
482: hr_utility.set_location(' Leaving:'||l_proc, 80);
483: when others then
484: --
485: -- A validation or unexpected error has occured
486: --

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

489: p_effective_start_date := null;
490: p_effective_end_date := null;
491:
492: rollback to CREATE_ACCOMMODATION;
493: hr_utility.set_location(' Leaving:'||l_proc, 90);
494: raise;
495: end create_accommodation;
496: --
497: --

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

608: l_effective_end_date pqh_accommodations_f.effective_end_date%TYPE;
609: l_object_version_number number := p_object_version_number;
610: --
611: begin
612: hr_utility.set_location('Entering:'|| l_proc, 10);
613: --
614: -- Issue a savepoint
615: --
616: savepoint UPDATE_ACCOMMODATION;

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

955: p_object_version_number := p_object_version_number;
956: p_effective_start_date := l_effective_start_date;
957: p_effective_end_date := l_effective_end_date;
958: --
959: hr_utility.set_location(' Leaving:'||l_proc, 70);
960: exception
961: when hr_api.validate_enabled then
962: --
963: -- As the Validate_Enabled exception has been raised

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

972: p_object_version_number := l_object_version_number;
973: p_effective_start_date := null;
974: p_effective_end_date := null;
975:
976: hr_utility.set_location(' Leaving:'||l_proc, 80);
977: when others then
978: --
979: -- A validation or unexpected error has occured
980: --

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

983: p_effective_start_date := null;
984: p_effective_end_date := null;
985:
986: rollback to UPDATE_ACCOMMODATION;
987: hr_utility.set_location(' Leaving:'||l_proc, 90);
988: raise;
989: end update_accommodation;
990: --
991: --

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

1011: l_effective_end_date pqh_accommodations_f.effective_end_date%TYPE;
1012: l_object_version_number number := p_object_version_number;
1013: --
1014: begin
1015: hr_utility.set_location('Entering:'|| l_proc, 10);
1016: --
1017: -- Issue a savepoint
1018: --
1019: savepoint DELETE_ACCOMMODATION;

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

1087: p_effective_start_date := l_effective_start_date;
1088: p_effective_end_date := l_effective_end_date;
1089: --
1090: --
1091: hr_utility.set_location(' Leaving:'||l_proc, 70);
1092: exception
1093: when hr_api.validate_enabled then
1094: --
1095: -- As the Validate_Enabled exception has been raised

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

1104: p_object_version_number := l_object_version_number;
1105: p_effective_start_date := null;
1106: p_effective_end_date := null;
1107: --
1108: hr_utility.set_location(' Leaving:'||l_proc, 80);
1109: when others then
1110: --
1111: -- A validation or unexpected error has occured
1112: --

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

1114: p_effective_start_date := null;
1115: p_effective_end_date := null;
1116:
1117: rollback to DELETE_ACCOMMODATION;
1118: hr_utility.set_location(' Leaving:'||l_proc, 90);
1119: raise;
1120: end delete_accommodation;
1121: --
1122: end pqh_accommodations_api;