DBA Data[Home] [Help]

APPS.PQH_RANK_PROCESS_API dependencies on HR_UTILITY

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

35: l_rank_process_id pqh_rank_processes.rank_process_id%Type;
36: l_proc constant varchar2(72):= g_package||'create_rank_process';
37: begin
38:
39: hr_utility.set_location('Entering:'|| l_proc, 10);
40: --
41: -- Issue a savepoint
42: --
43: savepoint CREATE_RANK_PROCESS;

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

134: --
135: p_object_version_number := l_object_version_number;
136: p_rank_process_id := l_rank_process_id;
137: --
138: hr_utility.set_location(' Leaving:'||l_proc, 70);
139: exception
140: when hr_api.validate_enabled then
141: --
142: -- As the Validate_Enabled exception has been raised

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

149: -- when validation only mode is being used.)
150: --
151: p_rank_process_id := null;
152: p_object_version_number := null;
153: hr_utility.set_location(' Leaving:'||l_proc, 80);
154: when others then
155: --
156: -- A validation or unexpected error has occured
157: --

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

161: -- OUT parameters, including warnings, to null
162: --
163: p_rank_process_id := null;
164: p_object_version_number := null;
165: hr_utility.set_location(' Leaving:'||l_proc, 90);
166: raise;
167: end create_rank_process;
168: --
169: -- ----------------------------------------------------------------------------

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

196: --l_rank_process_id pqh_rank_processes.rank_process_id%Type;
197: l_proc constant varchar2(72):= g_package||'update_rank_process';
198: begin
199:
200: hr_utility.set_location('Entering:'|| l_proc, 10);
201: --
202: -- Issue a savepoint
203: savepoint UPDATE_RANK_PROCESS;
204: --

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

299: -- Set all IN OUT and OUT parameters with out values
300: --
301: p_object_version_number := l_object_version_number;
302: --
303: hr_utility.set_location(' Leaving:'||l_proc, 70);
304:
305: exception
306: when hr_api.validate_enabled then
307: --

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

314: -- (Any key or derived arguments must be set to null
315: -- when validation only mode is being used.)
316: --
317: p_object_version_number := l_object_version_number;
318: hr_utility.set_location(' Leaving:'||l_proc, 80);
319: when others then
320: --
321: -- A validation or unexpected error has occured
322: --

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

325: -- Reset IN OUT parameters and set all
326: -- OUT parameters, including warnings, to null
327: --
328: p_object_version_number := l_object_version_number;
329: hr_utility.set_location(' Leaving:'||l_proc, 90);
330: raise;
331: end update_rank_process;
332: --
333: -- ----------------------------------------------------------------------------

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

347: l_effective_date date;
348: l_proc constant varchar2(72):= g_package||'delete_rank_process';
349: begin
350:
351: hr_utility.set_location('Entering:'|| l_proc, 10);
352: --
353: -- Issue a savepoint
354: savepoint DELETE_RANK_PROCESS;
355: --

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

406: raise hr_api.validate_enabled;
407: end if;
408: --
409: --
410: hr_utility.set_location(' Leaving:'||l_proc, 70);
411:
412: exception
413: when hr_api.validate_enabled then
414: --

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

416: -- we must rollback to the savepoint
417: --
418: rollback to DELETE_RANK_PROCESS;
419: --
420: hr_utility.set_location(' Leaving:'||l_proc, 80);
421: when others then
422: --
423: -- A validation or unexpected error has occured
424: --

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

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