APPS.PQH_DE_LEVEL_NUMBERS_API dependencies on HR_UTILITY

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

25: L_Effective_Date Date;
26: l_LEVEL_NUMBER_ID PQH_DE_LEVEL_NUMBERS.LEVEL_NUMBER_ID%TYPE;
27:
28: begin
29: hr_utility.set_location('Entering:'|| l_proc, 10);
30: --
31: -- Issue a savepoint
32: --
33: savepoint Insert_LEVEL_NUMBERS;

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

97: P_LEVEL_NUMBER_ID := l_LEVEL_NUMBER_ID;
98: p_object_version_number := l_object_version_number;
99:
100: --
101: hr_utility.set_location(' Leaving:'||l_proc, 70);
102: exception
103: when hr_api.validate_enabled then
104: --
105: -- As the Validate_Enabled exception has been raised

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

112: -- when validation only mode is being used.)
113: --
114: p_LEVEL_NUMBER_ID := null;
115: p_object_version_number := null;
116: hr_utility.set_location(' Leaving:'||l_proc, 80);
117:
118: when others then
119: p_LEVEL_NUMBER_ID := null;
120: p_object_version_number := null;

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

121: --
122: -- A validation or unexpected error has occured
123: --
124: rollback to Insert_LEVEL_NUMBERS;
125: hr_utility.set_location(' Leaving:'||l_proc, 90);
126: raise;
127: end Insert_LEVEL_NUMBERS;
128:
129: --

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

143: l_object_Version_Number PQH_DE_LEVEL_NUMBERS.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;
144: L_Effective_Date Date;
145:
146: Begin
147: hr_utility.set_location('Entering:'|| l_proc, 10);
148: --
149: -- Issue a savepoint
150: --
151: savepoint Update_LEVEL_NUMBERS;

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

215:
216: p_object_version_number := l_object_version_number;
217:
218: --
219: hr_utility.set_location(' Leaving:'||l_proc, 70);
220: exception
221: when hr_api.validate_enabled then
222: --
223: -- As the Validate_Enabled exception has been raised

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

228: -- Only set output warning arguments
229: -- (Any key or derived arguments must be set to null
230: -- when validation only mode is being used.)
231: --
232: hr_utility.set_location(' Leaving:'||l_proc, 80);
233:
234: when others then
235: p_object_version_number := l_object_version_number;
236: --

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

236: --
237: -- A validation or unexpected error has occured
238: --
239: rollback to Update_LEVEL_NUMBERS;
240: hr_utility.set_location(' Leaving:'||l_proc, 90);
241: raise;
242: end Update_LEVEL_NUMBERS;
243:
244: --

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

256: --
257: l_proc varchar2(72) := g_package||'delete_LEVEL_NUMBERS';
258: --
259: begin
260: hr_utility.set_location('Entering:'|| l_proc, 10);
261: --
262: -- Issue a savepoint
263: --
264: savepoint delete_LEVEL_NUMBERS;

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

308: end if;
309: --
310: -- Set all output arguments
311: --
312: hr_utility.set_location(' Leaving:'||l_proc, 70);
313: exception
314: when hr_api.validate_enabled then
315: --
316: -- As the Validate_Enabled exception has been raised

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

321: -- Only set output warning arguments
322: -- (Any key or derived arguments must be set to null
323: -- when validation only mode is being used.)
324: --
325: hr_utility.set_location(' Leaving:'||l_proc, 80);
326: when others then
327: --
328: -- A validation or unexpected error has occured
329: --

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

327: --
328: -- A validation or unexpected error has occured
329: --
330: rollback to delete_LEVEL_NUMBERS;
331: hr_utility.set_location(' Leaving:'||l_proc, 90);
332: raise;
333: end delete_LEVEL_NUMBERS;
334:
335: end PQH_DE_LEVEL_NUMBERS_API;