DBA Data[Home] [Help]

APPS.PQH_FR_STAT_SITUATIONS_SWI dependencies on HR_UTILITY

Line 7: g_debug boolean := hr_utility.debug_enabled;

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 >----------------------|

Line 62: g_debug := hr_utility.debug_enabled;

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);

Line 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

Line 149: hr_utility.set_location(' Leaving:' || l_proc,20);

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: --

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

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

Line 187: hr_utility.set_location(' Leaving:' || l_proc,40);

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;

Line 201: hr_utility.set_location(' Leaving:' || l_proc,50);

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;

Line 232: g_debug := hr_utility.debug_enabled;

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);

Line 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: --

Line 299: hr_utility.set_location(' Leaving:' || l_proc,20);

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

Line 318: hr_utility.set_location(' Leaving:' || l_proc, 30);

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

Line 334: hr_utility.set_location(' Leaving:' || l_proc,40);

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;

Line 346: hr_utility.set_location(' Leaving:' || l_proc,50);

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;

Line 403: g_debug := hr_utility.debug_enabled;

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);

Line 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

Line 487: hr_utility.set_location(' Leaving:' || l_proc,20);

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: --

Line 508: hr_utility.set_location(' Leaving:' || l_proc, 30);

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

Line 524: hr_utility.set_location(' Leaving:' || l_proc,40);

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;

Line 539: hr_utility.set_location(' Leaving:' || l_proc,50);

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;