37: l_object_version_number pqh_budget_periods.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_budget_period;
43: -- Issue a savepoint if operating in validation only mode
44: --
45: savepoint create_budget_period;
46: --
47: hr_utility.set_location(l_proc, 20);
48: --
49: -- Process Logic
50: --
51: begin
137: -- End of API User Hook for the after hook of create_budget_period
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
150: --
151: p_budget_period_id := l_budget_period_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
167: -- when validation only mode is being used.)
168: --
169: p_budget_period_id := null;
170: p_object_version_number := null;
171: hr_utility.set_location(' Leaving:'||l_proc, 80);
172: --
173: when others then
174: p_budget_period_id := null;
175: p_object_version_number := null;
211: l_object_version_number pqh_budget_periods.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_budget_period;
217: -- Issue a savepoint if operating in validation only mode
218: --
219: savepoint update_budget_period;
220: --
221: hr_utility.set_location(l_proc, 20);
222: --
223: -- Process Logic
224: --
225: l_object_version_number := p_object_version_number;
314: -- End of API User Hook for the after hook of update_budget_period
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
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
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: --
369: l_object_version_number pqh_budget_periods.object_version_number%TYPE;
370: --
371: begin
372: --
373: hr_utility.set_location('Entering:'|| l_proc, 10);
374: --
375: -- Issue a savepoint if operating in validation only mode
376: --
377: savepoint delete_budget_period;
375: -- Issue a savepoint if operating in validation only mode
376: --
377: savepoint delete_budget_period;
378: --
379: hr_utility.set_location(l_proc, 20);
380: --
381: -- Process Logic
382: --
383: l_object_version_number := p_object_version_number;
428: -- End of API User Hook for the after hook of delete_budget_period
429: --
430: end;
431: --
432: hr_utility.set_location(l_proc, 60);
433: --
434: -- When in validation only mode raise the Validate_Enabled exception
435: --
436: if p_validate then
436: if p_validate then
437: raise hr_api.validate_enabled;
438: end if;
439: --
440: hr_utility.set_location(' Leaving:'||l_proc, 70);
441: --
442: exception
443: --
444: when hr_api.validate_enabled then
478: l_proc varchar2(72) := g_package||'lck';
479: --
480: begin
481: --
482: hr_utility.set_location('Entering:'|| l_proc, 10);
483: --
484: pqh_bpr_shd.lck
485: (
486: p_budget_period_id => p_budget_period_id
486: p_budget_period_id => p_budget_period_id
487: ,p_object_version_number => p_object_version_number
488: );
489: --
490: hr_utility.set_location(' Leaving:'||l_proc, 70);
491: --
492: end lck;
493: --
494: end pqh_budget_periods_api;