DBA Data[Home] [Help]

APPS.PQH_DE_CASE_GROUPS_API dependencies on HR_UTILITY

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

38: L_Effective_Date Date;
39: l_CASE_GROUP_ID PQH_DE_CASE_GROUPS.CASE_GROUP_ID%TYPE;
40:
41: begin
42: hr_utility.set_location('Entering:'|| l_proc, 10);
43: --
44: -- Issue a savepoint
45: --
46: savepoint Insert_CASE_GROUPS;

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

149: P_CASE_GROUP_ID := l_CASE_GROUP_ID;
150: p_object_version_number := l_object_version_number;
151:
152: --
153: hr_utility.set_location(' Leaving:'||l_proc, 70);
154: exception
155: when hr_api.validate_enabled then
156: --
157: -- As the Validate_Enabled exception has been raised

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

164: -- when validation only mode is being used.)
165: --
166: p_CASE_GROUP_ID := null;
167: p_object_version_number := null;
168: hr_utility.set_location(' Leaving:'||l_proc, 80);
169:
170: when others then
171: p_CASE_GROUP_ID := null;
172: p_object_version_number := null;

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

173: --
174: -- A validation or unexpected error has occured
175: --
176: rollback to Insert_CASE_GROUPS;
177: hr_utility.set_location(' Leaving:'||l_proc, 90);
178: raise;
179: end Insert_CASE_GROUPS;
180:
181: --

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

207: l_object_Version_Number PQH_DE_CASE_GROUPS.OBJECT_VERSION_NUMBER%TYPE := P_Object_version_Number;
208: L_Effective_Date Date;
209:
210: Begin
211: hr_utility.set_location('Entering:'|| l_proc, 10);
212: --
213: -- Issue a savepoint
214: --
215: savepoint Update_CASE_GROUPS;

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

314:
315: p_object_version_number := l_object_version_number;
316:
317: --
318: hr_utility.set_location(' Leaving:'||l_proc, 70);
319: exception
320: when hr_api.validate_enabled then
321: --
322: -- As the Validate_Enabled exception has been raised

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

327: -- Only set output warning arguments
328: -- (Any key or derived arguments must be set to null
329: -- when validation only mode is being used.)
330: --
331: hr_utility.set_location(' Leaving:'||l_proc, 80);
332:
333: when others then
334: p_object_version_number := l_object_version_number;
335: --

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

335: --
336: -- A validation or unexpected error has occured
337: --
338: rollback to Update_CASE_GROUPS;
339: hr_utility.set_location(' Leaving:'||l_proc, 90);
340: raise;
341: end Update_CASE_GROUPS;
342:
343: --

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

354: --
355: l_proc varchar2(72) := g_package||'delete_CASE_GROUPS';
356: --
357: begin
358: hr_utility.set_location('Entering:'|| l_proc, 10);
359: --
360: -- Issue a savepoint
361: --
362: savepoint delete_CASE_GROUPS;

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

405: end if;
406: --
407: -- Set all output arguments
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 422: hr_utility.set_location(' Leaving:'||l_proc, 80);

418: -- Only set output warning arguments
419: -- (Any key or derived arguments must be set to null
420: -- when validation only mode is being used.)
421: --
422: hr_utility.set_location(' Leaving:'||l_proc, 80);
423: when others then
424: --
425: -- A validation or unexpected error has occured
426: --

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

424: --
425: -- A validation or unexpected error has occured
426: --
427: rollback to delete_CASE_GROUPS;
428: hr_utility.set_location(' Leaving:'||l_proc, 90);
429: raise;
430: end delete_CASE_GROUPS;
431:
432: end PQH_DE_CASE_GROUPS_API;