DBA Data[Home] [Help]

APPS.PQH_WORKSHEET_BUDGET_SETS_API dependencies on HR_UTILITY

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

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

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

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

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

137: -- End of API User Hook for the after hook of create_WORKSHEET_BUDGET_SET
138: --
139: end;
140: --
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_worksheet_budget_set_id := l_worksheet_budget_set_id;
152: p_object_version_number := l_object_version_number;
153: --
154: hr_utility.set_location(' Leaving:'||l_proc, 70);
155: --
156: exception
157: --
158: when hr_api.validate_enabled then

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

167: -- when validation only mode is being used.)
168: --
169: p_worksheet_budget_set_id := null;
170: p_object_version_number := null;
171: hr_utility.set_location(' Leaving:'||l_proc, 80);
172: --
173: when others then
174: p_worksheet_budget_set_id := null;
175: p_object_version_number := null;

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

211: l_object_version_number pqh_worksheet_budget_sets.object_version_number%TYPE;
212: --
213: begin
214: --
215: hr_utility.set_location('Entering:'|| l_proc, 10);
216: --
217: -- Issue a savepoint if operating in validation only mode
218: --
219: savepoint update_WORKSHEET_BUDGET_SET;

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

217: -- Issue a savepoint if operating in validation only mode
218: --
219: savepoint update_WORKSHEET_BUDGET_SET;
220: --
221: hr_utility.set_location(l_proc, 20);
222: --
223: -- Process Logic
224: --
225: l_object_version_number := p_object_version_number;

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

314: -- End of API User Hook for the after hook of update_WORKSHEET_BUDGET_SET
315: --
316: end;
317: --
318: hr_utility.set_location(l_proc, 60);
319: --
320: -- When in validation only mode raise the Validate_Enabled exception
321: --
322: if p_validate then

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

326: -- Set all output arguments
327: --
328: p_object_version_number := l_object_version_number;
329: --
330: hr_utility.set_location(' Leaving:'||l_proc, 70);
331: --
332: exception
333: --
334: when hr_api.validate_enabled then

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

341: -- Only set output warning arguments
342: -- (Any key or derived arguments must be set to null
343: -- when validation only mode is being used.)
344: --
345: hr_utility.set_location(' Leaving:'||l_proc, 80);
346: --
347: when others then
348: p_object_version_number := l_object_version_number;
349: --

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

370: l_object_version_number pqh_worksheet_budget_sets.object_version_number%TYPE;
371: --
372: begin
373: --
374: hr_utility.set_location('Entering:'|| l_proc, 10);
375: --
376: -- Issue a savepoint if operating in validation only mode
377: --
378: savepoint delete_WORKSHEET_BUDGET_SET;

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

376: -- Issue a savepoint if operating in validation only mode
377: --
378: savepoint delete_WORKSHEET_BUDGET_SET;
379: --
380: hr_utility.set_location(l_proc, 20);
381: --
382: -- Process Logic
383: --
384: l_object_version_number := p_object_version_number;

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

432: -- End of API User Hook for the after hook of delete_WORKSHEET_BUDGET_SET
433: --
434: end;
435: --
436: hr_utility.set_location(l_proc, 60);
437: --
438: -- When in validation only mode raise the Validate_Enabled exception
439: --
440: if p_validate then

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

440: if p_validate then
441: raise hr_api.validate_enabled;
442: end if;
443: --
444: hr_utility.set_location(' Leaving:'||l_proc, 70);
445: --
446: exception
447: --
448: when hr_api.validate_enabled then

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

482: l_proc varchar2(72) := g_package||'lck';
483: --
484: begin
485: --
486: hr_utility.set_location('Entering:'|| l_proc, 10);
487: --
488: PQH_WST_shd.lck
489: (
490: p_worksheet_budget_set_id => p_worksheet_budget_set_id

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

490: p_worksheet_budget_set_id => p_worksheet_budget_set_id
491: ,p_object_version_number => p_object_version_number
492: );
493: --
494: hr_utility.set_location(' Leaving:'||l_proc, 70);
495: --
496: end lck;
497: --
498: end pqh_WORKSHEET_BUDGET_SETS_api;