DBA Data[Home] [Help]

APPS.PQP_ERG_API dependencies on HR_UTILITY

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

31: l_object_version_number number;
32: l_output_format pqp_exception_report_groups.output_format%TYPE;
33:
34: begin
35: hr_utility.set_location('Entering:'|| l_proc, 10);
36: --
37: -- Issue a savepoint
38: --
39: savepoint create_exception_group;

Line 41: hr_utility.set_location(l_proc, 20);

37: -- Issue a savepoint
38: --
39: savepoint create_exception_group;
40:
41: hr_utility.set_location(l_proc, 20);
42: --
43: -- Call Before Process User Hook
44: --
45: l_output_format :=p_output_format;

Line 62: hr_utility.set_location(l_proc, 30);

58: (p_module_name => 'create_exception_group'
59: ,p_hook_type => 'BP'
60: );
61: end;
62: hr_utility.set_location(l_proc, 30);
63: --
64: -- Validation in addition to Row Handlers
65: --
66: hr_utility.set_location(l_proc, 40);

Line 66: hr_utility.set_location(l_proc, 40);

62: hr_utility.set_location(l_proc, 30);
63: --
64: -- Validation in addition to Row Handlers
65: --
66: hr_utility.set_location(l_proc, 40);
67: --
68: -- Process Logic
69: --
70: IF p_output_format ='TXT' THEN

Line 86: hr_utility.set_location(l_proc, 50);

82: ,p_object_version_number => l_object_version_number
83: ,p_output_format => l_output_format
84: );
85:
86: hr_utility.set_location(l_proc, 50);
87: --
88: -- Call After Process User Hook
89: --
90: begin

Line 108: hr_utility.set_location(l_proc, 60);

104: (p_module_name => 'create_exception_group'
105: ,p_hook_type => 'AP'
106: );
107: end;
108: hr_utility.set_location(l_proc, 60);
109: --
110: -- When in validation only mode raise the Validate_Enabled exception
111: --
112: if p_validate then

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

117: --
118: p_exception_group_id := l_exception_group_id;
119: p_object_version_number := l_object_version_number;
120: --
121: hr_utility.set_location(' Leaving:'||l_proc, 70);
122: exception
123: when hr_api.validate_enabled then
124: --
125: -- As the Validate_Enabled exception has been raised

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

132: -- when validation only mode is being used.)
133: --
134: p_exception_group_id := null;
135: p_object_version_number := null;
136: hr_utility.set_location(' Leaving:'||l_proc, 80);
137: when others then
138: --
139: -- A validation or unexpected error has occured
140: --

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

140: --
141: rollback to create_exception_group;
142: p_exception_group_id := null;
143: p_object_version_number := null;
144: hr_utility.set_location(' Leaving:'||l_proc, 90);
145: raise;
146: end create_exception_group;
147: --
148: -- ----------------------------------------------------------------------------

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

170: l_object_version_number number;
171:
172: l_output_format pqp_exception_report_groups.output_format%TYPE;
173: begin
174: hr_utility.set_location('Entering:'|| l_proc, 10);
175: --
176: -- Issue a savepoint
177: --
178: savepoint update_exception_group;

Line 180: hr_utility.set_location(l_proc, 20);

176: -- Issue a savepoint
177: --
178: savepoint update_exception_group;
179:
180: hr_utility.set_location(l_proc, 20);
181: --
182: -- Call Before Process User Hook
183: --
184: l_output_format:=p_output_format;

Line 203: hr_utility.set_location(l_proc, 30);

199: (p_module_name => 'update_exception_group'
200: ,p_hook_type => 'BP'
201: );
202: end;
203: hr_utility.set_location(l_proc, 30);
204: --
205: -- Validation in addition to Row Handlers
206: --
207: hr_utility.set_location(l_proc, 40);

Line 207: hr_utility.set_location(l_proc, 40);

203: hr_utility.set_location(l_proc, 30);
204: --
205: -- Validation in addition to Row Handlers
206: --
207: hr_utility.set_location(l_proc, 40);
208: --
209: -- Process Logic
210: --
211: l_object_version_number := p_object_version_number;

Line 229: hr_utility.set_location(l_proc, 50);

225: ,p_object_version_number => l_object_version_number
226: ,p_output_format => l_output_format
227: );
228:
229: hr_utility.set_location(l_proc, 50);
230: --
231: -- Call After Process User Hook
232: --
233: begin

Line 251: hr_utility.set_location(l_proc, 60);

247: (p_module_name => 'update_exception_group'
248: ,p_hook_type => 'AP'
249: );
250: end;
251: hr_utility.set_location(l_proc, 60);
252: --
253: -- When in validation only mode raise the Validate_Enabled exception
254: --
255: if p_validate then

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

259: -- Set all output arguments
260: --
261: p_object_version_number := l_object_version_number;
262: --
263: hr_utility.set_location(' Leaving:'||l_proc, 70);
264: exception
265: when hr_api.validate_enabled then
266: --
267: -- As the Validate_Enabled exception has been raised

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

273: -- (Any key or derived arguments must be set to null
274: -- when validation only mode is being used.)
275: --
276: p_object_version_number := null;
277: hr_utility.set_location(' Leaving:'||l_proc, 80);
278: when others then
279: --
280: -- A validation or unexpected error has occured
281: --

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

280: -- A validation or unexpected error has occured
281: --
282: rollback to update_exception_group;
283: p_object_version_number := l_object_version_number ;
284: hr_utility.set_location(' Leaving:'||l_proc, 90);
285: raise;
286: end update_exception_group;
287: --
288: -- ----------------------------------------------------------------------------

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

301:
302: l_proc varchar2(72) := g_package||'delete_exception_group';
303:
304: begin
305: hr_utility.set_location('Entering:'|| l_proc, 10);
306: --
307: -- Issue a savepoint
308: --
309: savepoint delete_exception_group;

Line 311: hr_utility.set_location(l_proc, 20);

307: -- Issue a savepoint
308: --
309: savepoint delete_exception_group;
310: --
311: hr_utility.set_location(l_proc, 20);
312: --
313: -- Call Before Process User Hook
314: --
315: begin

Line 327: hr_utility.set_location(l_proc, 30);

323: (p_module_name => 'delete_exception_group'
324: ,p_hook_type => 'BP'
325: );
326: end;
327: hr_utility.set_location(l_proc, 30);
328: --
329: -- Validation in addition to Row Handlers
330: --
331:

Line 334: hr_utility.set_location(l_proc, 40);

330: --
331:
332:
333:
334: hr_utility.set_location(l_proc, 40);
335: --
336: -- Process Logic
337: --
338:

Line 345: hr_utility.set_location(l_proc, 50);

341: p_exception_group_id => p_exception_group_id
342: ,p_object_version_number => p_object_version_number
343: );
344:
345: hr_utility.set_location(l_proc, 50);
346: --
347: -- Call After Process User Hook
348: --
349: begin

Line 361: hr_utility.set_location(l_proc, 60);

357: (p_module_name => 'delete_exception_group'
358: ,p_hook_type => 'AP'
359: );
360: end;
361: hr_utility.set_location(l_proc, 60);
362: --
363: -- When in validation only mode raise the Validate_Enabled exception
364: --
365: if p_validate then

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

368: --
369: -- Set all output arguments
370: --
371: --
372: hr_utility.set_location(' Leaving:'||l_proc, 70);
373: exception
374: when hr_api.validate_enabled then
375: --
376: -- As the Validate_Enabled exception has been raised

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

381: -- Only set output warning arguments
382: -- (Any key or derived arguments must be set to null
383: -- when validation only mode is being used.)
384: --
385: hr_utility.set_location(' Leaving:'||l_proc, 80);
386: when others then
387: --
388: -- A validation or unexpected error has occured
389: --

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

387: --
388: -- A validation or unexpected error has occured
389: --
390: rollback to delete_exception_group;
391: hr_utility.set_location(' Leaving:'||l_proc, 90);
392: raise;
393: end delete_exception_group;
394: --
395: -- ----------------------------------------------------------------------------

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

417: -- Local variable declaration
418: l_proc varchar2(72) := g_package||'delete_exception_group';
419:
420: begin
421: hr_utility.set_location('Entering:'|| l_proc, 10);
422: --
423: -- Process Logic
424: --
425: For r_GrpDets in c_GrpDets

Line 436: hr_utility.set_location(l_proc, 20);

432: );
433:
434: End Loop; -- 1
435: --
436: hr_utility.set_location(l_proc, 20);
437: -- Set all output arguments
438: --
439: --
440: hr_utility.set_location(' Leaving:'||l_proc, 30);

Line 440: hr_utility.set_location(' Leaving:'||l_proc, 30);

436: hr_utility.set_location(l_proc, 20);
437: -- Set all output arguments
438: --
439: --
440: hr_utility.set_location(' Leaving:'||l_proc, 30);
441: exception
442: when others then
443: --
444: -- A validation or unexpected error has occured

Line 446: hr_utility.set_location(' Leaving:'||l_proc, 40);

442: when others then
443: --
444: -- A validation or unexpected error has occured
445: --
446: hr_utility.set_location(' Leaving:'||l_proc, 40);
447: raise;
448: end delete_exception_group;
449: --
450: end pqp_erg_api;