DBA Data[Home] [Help]

APPS.PQP_EXR_API dependencies on HR_UTILITY

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

37: l_object_version_number number;
38: l_language_code varchar2(30);
39:
40: begin
41: hr_utility.set_location('Entering:'|| l_proc, 10);
42: --
43: -- Issue a savepoint
44: --
45: savepoint create_exception_report;

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

43: -- Issue a savepoint
44: --
45: savepoint create_exception_report;
46:
47: hr_utility.set_location(l_proc, 20);
48:
49: l_language_code := p_language_code;
50: hr_api.validate_language_code(p_language_code => l_language_code);
51:

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

73: (p_module_name => 'create_exception_report'
74: ,p_hook_type => 'BP'
75: );
76: end;
77: hr_utility.set_location(l_proc, 30);
78: --
79: -- Validation in addition to Row Handlers
80: --
81:

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

80: --
81:
82:
83:
84: hr_utility.set_location(l_proc, 40);
85: --
86: -- Process Logic
87: --
88:

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

109: ,p_exception_report_id => l_exception_report_id
110: ,p_exception_report_name => p_exception_report_name
111: );
112:
113: hr_utility.set_location(l_proc, 50);
114: --
115: -- Call After Process User Hook
116: --
117: begin

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

137: (p_module_name => 'create_exception_report'
138: ,p_hook_type => 'AP'
139: );
140: end;
141: hr_utility.set_location(l_proc, 60);
142: --
143: -- When in validation only mode raise the Validate_Enabled exception
144: --
145: if p_validate then

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

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

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

165: -- when validation only mode is being used.)
166: --
167: p_exception_report_id := null;
168: p_object_version_number := null;
169: hr_utility.set_location(' Leaving:'||l_proc, 80);
170: when others then
171: --
172: -- A validation or unexpected error has occured
173: --

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

173: --
174: rollback to create_exception_report;
175: p_exception_report_id := null;
176: p_object_version_number := null;
177: hr_utility.set_location(' Leaving:'||l_proc, 90);
178: raise;
179: end create_exception_report;
180: --
181: -- ----------------------------------------------------------------------------

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

209: l_proc varchar2(72) := g_package||'update_exception_report';
210: l_object_version_number number;
211: l_language_code varchar2(30);
212: begin
213: hr_utility.set_location('Entering:'|| l_proc, 10);
214: --
215: -- Issue a savepoint
216: --
217: savepoint update_exception_report;

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

215: -- Issue a savepoint
216: --
217: savepoint update_exception_report;
218:
219: hr_utility.set_location(l_proc, 20);
220:
221: l_language_code := p_language_code;
222: hr_api.validate_language_code(p_language_code => l_language_code);
223:

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

247: (p_module_name => 'update_exception_report'
248: ,p_hook_type => 'BP'
249: );
250: end;
251: hr_utility.set_location(l_proc, 30);
252: --
253: -- Validation in addition to Row Handlers
254: --
255:

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

254: --
255:
256:
257:
258: hr_utility.set_location(l_proc, 40);
259: --
260: -- Process Logic
261: --
262: l_object_version_number := p_object_version_number;

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

284: ,p_exception_report_id => p_exception_report_id
285: ,p_exception_report_name => p_exception_report_name
286: );
287:
288: hr_utility.set_location(l_proc, 50);
289: --
290: -- Call After Process User Hook
291: --
292: begin

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

312: (p_module_name => 'update_exception_report'
313: ,p_hook_type => 'AP'
314: );
315: end;
316: hr_utility.set_location(l_proc, 60);
317: --
318: -- When in validation only mode raise the Validate_Enabled exception
319: --
320: if p_validate then

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

324: -- Set all output arguments
325: --
326: p_object_version_number := l_object_version_number;
327: --
328: hr_utility.set_location(' Leaving:'||l_proc, 70);
329: exception
330: when hr_api.validate_enabled then
331: --
332: -- As the Validate_Enabled exception has been raised

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

338: -- (Any key or derived arguments must be set to null
339: -- when validation only mode is being used.)
340: --
341: p_object_version_number := null;
342: hr_utility.set_location(' Leaving:'||l_proc, 80);
343: when others then
344: --
345: -- A validation or unexpected error has occured
346: --

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

344: --
345: -- A validation or unexpected error has occured
346: --
347: rollback to update_exception_report;
348: hr_utility.set_location(' Leaving:'||l_proc, 90);
349: p_object_version_number := null;
350: raise;
351: end update_exception_report;
352: --

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

371: l_business_group_id number;
372: l_proc varchar2(72) := g_package||'delete_exception_report';
373:
374: begin
375: hr_utility.set_location('Entering:'|| l_proc, 10);
376: --
377: -- Issue a savepoint
378: --
379: savepoint delete_exception_report;

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

377: -- Issue a savepoint
378: --
379: savepoint delete_exception_report;
380: --
381: hr_utility.set_location(l_proc, 20);
382: --
383: -- Call Before Process User Hook
384: --
385: open csr_bg_id(p_exception_report_id);

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

399: (p_module_name => 'delete_exception_report'
400: ,p_hook_type => 'BP'
401: );
402: end;
403: hr_utility.set_location(l_proc, 30);
404: --
405: -- Validation in addition to Row Handlers
406: --
407:

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

404: --
405: -- Validation in addition to Row Handlers
406: --
407:
408: hr_utility.set_location(l_proc, 40);
409: --
410: -- Process Logic
411: --
412:

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

420: ,p_object_version_number => p_object_version_number
421: );
422:
423:
424: hr_utility.set_location(l_proc, 50);
425: --
426: -- Call After Process User Hook
427: --
428: begin

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

437: (p_module_name => 'delete_exception_report'
438: ,p_hook_type => 'AP'
439: );
440: end;
441: hr_utility.set_location(l_proc, 60);
442: --
443: -- When in validation only mode raise the Validate_Enabled exception
444: --
445: if p_validate then

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

448: --
449: -- Set all output arguments
450: --
451: --
452: hr_utility.set_location(' Leaving:'||l_proc, 70);
453: exception
454: when hr_api.validate_enabled then
455: --
456: -- As the Validate_Enabled exception has been raised

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

461: -- Only set output warning arguments
462: -- (Any key or derived arguments must be set to null
463: -- when validation only mode is being used.)
464: --
465: hr_utility.set_location(' Leaving:'||l_proc, 80);
466: when others then
467: --
468: -- A validation or unexpected error has occured
469: --

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

467: --
468: -- A validation or unexpected error has occured
469: --
470: rollback to delete_exception_report;
471: hr_utility.set_location(' Leaving:'||l_proc, 90);
472: raise;
473: end delete_exception_report;
474: --
475: end pqp_exr_api;