DBA Data[Home] [Help]

APPS.PQH_WORKSHEETS_API dependencies on HR_UTILITY

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

34: l_object_version_number pqh_worksheets.object_version_number%TYPE;
35: --
36: begin
37: --
38: hr_utility.set_location('Entering:'|| l_proc, 10);
39: --
40: -- Issue a savepoint if operating in validation only mode
41: --
42: savepoint create_WORKSHEET;

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

40: -- Issue a savepoint if operating in validation only mode
41: --
42: savepoint create_WORKSHEET;
43: --
44: hr_utility.set_location(l_proc, 20);
45: --
46: -- Process Logic
47: --
48: begin

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

125: -- End of API User Hook for the after hook of create_WORKSHEET
126: --
127: end;
128: --
129: hr_utility.set_location(l_proc, 60);
130: --
131: -- When in validation only mode raise the Validate_Enabled exception
132: --
133: if p_validate then

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

138: --
139: p_worksheet_id := l_worksheet_id;
140: p_object_version_number := l_object_version_number;
141: --
142: hr_utility.set_location(' Leaving:'||l_proc, 70);
143: --
144: exception
145: --
146: when hr_api.validate_enabled then

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

155: -- when validation only mode is being used.)
156: --
157: p_worksheet_id := null;
158: p_object_version_number := null;
159: hr_utility.set_location(' Leaving:'||l_proc, 80);
160: --
161: when others then
162: p_worksheet_id := null;
163: p_object_version_number := null;

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

196: l_object_version_number pqh_worksheets.object_version_number%TYPE;
197: --
198: begin
199: --
200: hr_utility.set_location('Entering:'|| l_proc, 10);
201: --
202: -- Issue a savepoint if operating in validation only mode
203: --
204: savepoint update_WORKSHEET;

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

202: -- Issue a savepoint if operating in validation only mode
203: --
204: savepoint update_WORKSHEET;
205: --
206: hr_utility.set_location(l_proc, 20);
207: --
208: -- Process Logic
209: --
210: l_object_version_number := p_object_version_number;

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

290: -- End of API User Hook for the after hook of update_WORKSHEET
291: --
292: end;
293: --
294: hr_utility.set_location(l_proc, 60);
295: --
296: -- When in validation only mode raise the Validate_Enabled exception
297: --
298: if p_validate then

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

302: -- Set all output arguments
303: --
304: p_object_version_number := l_object_version_number;
305: --
306: hr_utility.set_location(' Leaving:'||l_proc, 70);
307: --
308: exception
309: --
310: when hr_api.validate_enabled then

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

317: -- Only set output warning arguments
318: -- (Any key or derived arguments must be set to null
319: -- when validation only mode is being used.)
320: --
321: hr_utility.set_location(' Leaving:'||l_proc, 80);
322: --
323: when others then
324: p_object_version_number := l_object_version_number;
325: --

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

346: l_object_version_number pqh_worksheets.object_version_number%TYPE;
347: --
348: begin
349: --
350: hr_utility.set_location('Entering:'|| l_proc, 10);
351: --
352: -- Issue a savepoint if operating in validation only mode
353: --
354: savepoint delete_WORKSHEET;

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

352: -- Issue a savepoint if operating in validation only mode
353: --
354: savepoint delete_WORKSHEET;
355: --
356: hr_utility.set_location(l_proc, 20);
357: --
358: -- Process Logic
359: --
360: l_object_version_number := p_object_version_number;

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

408: -- End of API User Hook for the after hook of delete_WORKSHEET
409: --
410: end;
411: --
412: hr_utility.set_location(l_proc, 60);
413: --
414: -- When in validation only mode raise the Validate_Enabled exception
415: --
416: if p_validate then

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

416: if p_validate then
417: raise hr_api.validate_enabled;
418: end if;
419: --
420: hr_utility.set_location(' Leaving:'||l_proc, 70);
421: --
422: exception
423: --
424: when hr_api.validate_enabled then

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

458: l_proc varchar2(72) := g_package||'lck';
459: --
460: begin
461: --
462: hr_utility.set_location('Entering:'|| l_proc, 10);
463: --
464: pqh_wks_shd.lck
465: (
466: p_worksheet_id => p_worksheet_id

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

466: p_worksheet_id => p_worksheet_id
467: ,p_object_version_number => p_object_version_number
468: );
469: --
470: hr_utility.set_location(' Leaving:'||l_proc, 70);
471: --
472: end lck;
473: --
474: end pqh_WORKSHEETS_api;