3: --
4: -- Package variables
5: --
6: g_package varchar2(33) := 'pqh_fr_stat_situations_swi.';
7: g_debug boolean := hr_utility.debug_enabled;
8:
9: --
10: -- ----------------------------------------------------------------------------
11: -- |----------------------< create_statutory_situation >----------------------|
58: l_statutory_situation_id number;
59: l_proc varchar2(72) := g_package ||'create_statutory_situation';
60: Begin
61:
62: g_debug := hr_utility.debug_enabled;
63:
64: if g_debug then
65: --
66: hr_utility.set_location(' Entering:' || l_proc,10);
62: g_debug := hr_utility.debug_enabled;
63:
64: if g_debug then
65: --
66: hr_utility.set_location(' Entering:' || l_proc,10);
67: --
68: End if;
69: --
70: -- Issue a savepoint
145: p_return_status := hr_multi_message.get_return_status_disable;
146:
147: if g_debug then
148: --
149: hr_utility.set_location(' Leaving:' || l_proc,20);
150: --
151: End if;
152:
153: --
167: p_return_status := hr_multi_message.get_return_status_disable;
168:
169: if g_debug then
170: --
171: hr_utility.set_location(' Leaving:' || l_proc, 30);
172: --
173: End if;
174:
175: when others then
183: rollback to create_statutory_situation_swi;
184: if hr_multi_message.unexpected_error_add(l_proc) then
185: if g_debug then
186: --
187: hr_utility.set_location(' Leaving:' || l_proc,40);
188: --
189: End if;
190: raise;
191: end if;
197: p_return_status := hr_multi_message.get_return_status_disable;
198:
199: if g_debug then
200: --
201: hr_utility.set_location(' Leaving:' || l_proc,50);
202: --
203: End if;
204:
205: end create_statutory_situation;
228: where statutory_situation_id = p_statutory_situation_id;
229:
230: Begin
231:
232: g_debug := hr_utility.debug_enabled;
233:
234: if g_debug then
235: --
236: hr_utility.set_location(' Entering:' || l_proc,10);
232: g_debug := hr_utility.debug_enabled;
233:
234: if g_debug then
235: --
236: hr_utility.set_location(' Entering:' || l_proc,10);
237: --
238: End if;
239:
240: --
295: --
296: p_return_status := hr_multi_message.get_return_status_disable;
297: if g_debug then
298: --
299: hr_utility.set_location(' Leaving:' || l_proc,20);
300: --
301: End if;
302: --
303: exception
314: p_return_status := hr_multi_message.get_return_status_disable;
315:
316: if g_debug then
317: --
318: hr_utility.set_location(' Leaving:' || l_proc, 30);
319: --
320: End if;
321:
322: when others then
330: rollback to delete_statutory_situation_swi;
331: if hr_multi_message.unexpected_error_add(l_proc) then
332: if g_debug then
333: --
334: hr_utility.set_location(' Leaving:' || l_proc,40);
335: --
336: End if;
337:
338: raise;
342: --
343: p_return_status := hr_multi_message.get_return_status_disable;
344: if g_debug then
345: --
346: hr_utility.set_location(' Leaving:' || l_proc,50);
347: --
348: End if;
349:
350: end delete_statutory_situation;
399: -- Other variables
400: l_proc varchar2(72) := g_package ||'update_statutory_situation';
401: Begin
402:
403: g_debug := hr_utility.debug_enabled;
404:
405: if g_debug then
406: --
407: hr_utility.set_location(' Entering:' || l_proc,10);
403: g_debug := hr_utility.debug_enabled;
404:
405: if g_debug then
406: --
407: hr_utility.set_location(' Entering:' || l_proc,10);
408: --
409: End if;
410: --
411: -- Issue a savepoint
483: p_return_status := hr_multi_message.get_return_status_disable;
484:
485: if g_debug then
486: --
487: hr_utility.set_location(' Leaving:' || l_proc,20);
488: --
489: End if;
490:
491: --
504: p_return_status := hr_multi_message.get_return_status_disable;
505:
506: if g_debug then
507: --
508: hr_utility.set_location(' Leaving:' || l_proc, 30);
509: --
510: End if;
511:
512: when others then
520: rollback to update_statutory_situation_swi;
521: if hr_multi_message.unexpected_error_add(l_proc) then
522: if g_debug then
523: --
524: hr_utility.set_location(' Leaving:' || l_proc,40);
525: --
526: End if;
527:
528: raise;
535: p_return_status := hr_multi_message.get_return_status_disable;
536:
537: if g_debug then
538: --
539: hr_utility.set_location(' Leaving:' || l_proc,50);
540: --
541: end if;
542:
543: end update_statutory_situation;