DBA Data[Home] [Help]

APPS.PQH_RANK_PROCESS_APPROVAL_API dependencies on HR_UTILITY

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

29: l_rank_process_approval_id pqh_rank_process_approvals.rank_process_approval_id%Type;
30: l_proc constant varchar2(72):= g_package||'create_rank_process_approval';
31: begin
32:
33: hr_utility.set_location('Entering:'|| l_proc, 10);
34: --
35: -- Issue a savepoint
36: --
37: savepoint CREATE_RANK_PROCESS_APPROVAL;

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

109: --
110: p_rank_process_approval_id := l_rank_process_approval_id;
111: p_object_version_number := l_object_version_number;
112: --
113: hr_utility.set_location(' Leaving:'||l_proc, 70);
114: exception
115: when hr_api.validate_enabled then
116: --
117: -- As the Validate_Enabled exception has been raised

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

124: -- when validation only mode is being used.)
125: --
126: p_rank_process_approval_id := null;
127: p_object_version_number := null;
128: hr_utility.set_location(' Leaving:'||l_proc, 80);
129: when others then
130: --
131: -- A validation or unexpected error has occured
132: --

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

136: -- OUT parameters, including warnings, to null
137: --
138: p_rank_process_approval_id := null;
139: p_object_version_number := null;
140: hr_utility.set_location(' Leaving:'||l_proc, 90);
141: raise;
142: end create_rank_process_approval;
143: --
144: -- ----------------------------------------------------------------------------

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

164: l_effective_date date;
165: l_proc constant varchar2(72):= g_package||'update_rank_process_approval';
166: begin
167:
168: hr_utility.set_location('Entering:'|| l_proc, 10);
169: --
170: -- Issue a savepoint
171: savepoint UPDATE_RANK_PROCESS_APPROVAL;
172: --

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

248: -- Set all IN OUT and OUT parameters with out values
249: --
250: p_object_version_number := l_object_version_number;
251: --
252: hr_utility.set_location(' Leaving:'||l_proc, 70);
253:
254: exception
255: when hr_api.validate_enabled then
256: --

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

263: -- (Any key or derived arguments must be set to null
264: -- when validation only mode is being used.)
265: --
266: p_object_version_number := l_object_version_number;
267: hr_utility.set_location(' Leaving:'||l_proc, 80);
268: when others then
269: --
270: -- A validation or unexpected error has occured
271: --

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

274: -- Reset IN OUT parameters and set all
275: -- OUT parameters, including warnings, to null
276: --
277: p_object_version_number := l_object_version_number;
278: hr_utility.set_location(' Leaving:'||l_proc, 90);
279: raise;
280: end update_rank_process_approval;
281: --
282: -- ----------------------------------------------------------------------------

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

295: l_effective_date date;
296: l_proc constant varchar2(72) := g_package||'delete_rank_process_approval';
297: begin
298:
299: hr_utility.set_location('Entering:'|| l_proc, 10);
300: --
301: -- Issue a savepoint
302: savepoint DELETE_RANK_PROCESS_APPROVAL;
303: --

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

354: raise hr_api.validate_enabled;
355: end if;
356: --
357: --
358: hr_utility.set_location(' Leaving:'||l_proc, 70);
359:
360: exception
361: when hr_api.validate_enabled then
362: --

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

364: -- we must rollback to the savepoint
365: --
366: rollback to DELETE_RANK_PROCESS_APPROVAL;
367: --
368: hr_utility.set_location(' Leaving:'||l_proc, 80);
369: when others then
370: --
371: -- A validation or unexpected error has occured
372: --

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

371: -- A validation or unexpected error has occured
372: --
373: rollback to DELETE_RANK_PROCESS_APPROVAL;
374: --
375: hr_utility.set_location(' Leaving:'||l_proc, 90);
376: raise;
377: end delete_rank_process_approval;
378: --
379: end pqh_rank_process_approval_api;