DBA Data[Home] [Help]

APPS.PQH_WORKSHEET_PERIODS_API dependencies on HR_UTILITY

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

38: l_object_version_number pqh_worksheet_periods.object_version_number%TYPE;
39: --
40: begin
41: --
42: hr_utility.set_location('Entering:'|| l_proc, 10);
43: --
44: -- Issue a savepoint if operating in validation only mode
45: --
46: savepoint create_WORKSHEET_PERIOD;

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

44: -- Issue a savepoint if operating in validation only mode
45: --
46: savepoint create_WORKSHEET_PERIOD;
47: --
48: hr_utility.set_location(l_proc, 20);
49: --
50: -- Process Logic
51: --
52: begin

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

141: -- End of API User Hook for the after hook of create_WORKSHEET_PERIOD
142: --
143: end;
144: --
145: hr_utility.set_location(l_proc, 60);
146: --
147: -- When in validation only mode raise the Validate_Enabled exception
148: --
149: if p_validate then

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

154: --
155: p_worksheet_period_id := l_worksheet_period_id;
156: p_object_version_number := l_object_version_number;
157: --
158: hr_utility.set_location(' Leaving:'||l_proc, 70);
159: --
160: exception
161: --
162: when hr_api.validate_enabled then

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

171: -- when validation only mode is being used.)
172: --
173: p_worksheet_period_id := null;
174: p_object_version_number := null;
175: hr_utility.set_location(' Leaving:'||l_proc, 80);
176: --
177: when others then
178: p_worksheet_period_id := null;
179: p_object_version_number := null;

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

216: l_object_version_number pqh_worksheet_periods.object_version_number%TYPE;
217: --
218: begin
219: --
220: hr_utility.set_location('Entering:'|| l_proc, 10);
221: --
222: -- Issue a savepoint if operating in validation only mode
223: --
224: savepoint update_WORKSHEET_PERIOD;

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

222: -- Issue a savepoint if operating in validation only mode
223: --
224: savepoint update_WORKSHEET_PERIOD;
225: --
226: hr_utility.set_location(l_proc, 20);
227: --
228: -- Process Logic
229: --
230: l_object_version_number := p_object_version_number;

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

322: -- End of API User Hook for the after hook of update_WORKSHEET_PERIOD
323: --
324: end;
325: --
326: hr_utility.set_location(l_proc, 60);
327: --
328: -- When in validation only mode raise the Validate_Enabled exception
329: --
330: if p_validate then

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

334: -- Set all output arguments
335: --
336: p_object_version_number := l_object_version_number;
337: --
338: hr_utility.set_location(' Leaving:'||l_proc, 70);
339: --
340: exception
341: --
342: when hr_api.validate_enabled then

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

349: -- Only set output warning arguments
350: -- (Any key or derived arguments must be set to null
351: -- when validation only mode is being used.)
352: --
353: hr_utility.set_location(' Leaving:'||l_proc, 80);
354: --
355: when others then
356: p_object_version_number := l_object_version_number;
357: --

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

378: l_object_version_number pqh_worksheet_periods.object_version_number%TYPE;
379: --
380: begin
381: --
382: hr_utility.set_location('Entering:'|| l_proc, 10);
383: --
384: -- Issue a savepoint if operating in validation only mode
385: --
386: savepoint delete_WORKSHEET_PERIOD;

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

384: -- Issue a savepoint if operating in validation only mode
385: --
386: savepoint delete_WORKSHEET_PERIOD;
387: --
388: hr_utility.set_location(l_proc, 20);
389: --
390: -- Process Logic
391: --
392: l_object_version_number := p_object_version_number;

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

440: -- End of API User Hook for the after hook of delete_WORKSHEET_PERIOD
441: --
442: end;
443: --
444: hr_utility.set_location(l_proc, 60);
445: --
446: -- When in validation only mode raise the Validate_Enabled exception
447: --
448: if p_validate then

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

448: if p_validate then
449: raise hr_api.validate_enabled;
450: end if;
451: --
452: hr_utility.set_location(' Leaving:'||l_proc, 70);
453: --
454: exception
455: --
456: when hr_api.validate_enabled then

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

490: l_proc varchar2(72) := g_package||'lck';
491: --
492: begin
493: --
494: hr_utility.set_location('Entering:'|| l_proc, 10);
495: --
496: pqh_wpr_shd.lck
497: (
498: p_worksheet_period_id => p_worksheet_period_id

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

498: p_worksheet_period_id => p_worksheet_period_id
499: ,p_object_version_number => p_object_version_number
500: );
501: --
502: hr_utility.set_location(' Leaving:'||l_proc, 70);
503: --
504: end lck;
505: --
506: end pqh_WORKSHEET_PERIODS_api;