4: -- Package variables
5: --
6: g_package varchar2(33) := 'pqh_fr_stat_sit_rules_swi.';
7:
8: g_debug boolean := hr_utility.debug_enabled;
9:
10: --
11: -- ----------------------------------------------------------------------------
12: -- |----------------------< create_stat_situation_rule >----------------------|
38: Begin
39:
40: if g_debug then
41: --
42: hr_utility.set_location(' Entering:' || l_proc,10);
43: --
44: End if;
45:
46: --
101: p_return_status := hr_multi_message.get_return_status_disable;
102:
103: if g_debug then
104: --
105: hr_utility.set_location(' Leaving:' || l_proc,20);
106: --
107: End if;
108: --
109: exception
121: p_return_status := hr_multi_message.get_return_status_disable;
122:
123: if g_debug then
124: --
125: hr_utility.set_location(' Leaving:' || l_proc, 30);
126: --
127: End if;
128:
129: when others then
138: if hr_multi_message.unexpected_error_add(l_proc) then
139:
140: if g_debug then
141: --
142: hr_utility.set_location(' Leaving:' || l_proc,40);
143: --
144: End if;
145:
146: raise;
152: p_return_status := hr_multi_message.get_return_status_disable;
153:
154: if g_debug then
155: --
156: hr_utility.set_location(' Leaving:' || l_proc,50);
157: --
158: End if;
159:
160: end create_stat_situation_rule;
178: Begin
179:
180: if g_debug then
181: --
182: hr_utility.set_location(' Entering:' || l_proc,10);
183: --
184: End if;
185:
186: --
226: p_return_status := hr_multi_message.get_return_status_disable;
227:
228: if g_debug then
229: --
230: hr_utility.set_location(' Leaving:' || l_proc,20);
231: --
232: End if;
233:
234: --
246: p_return_status := hr_multi_message.get_return_status_disable;
247:
248: if g_debug then
249: --
250: hr_utility.set_location(' Leaving:' || l_proc, 30);
251: --
252: End if;
253:
254: when others then
262: rollback to delete_stat_situation_rule_swi;
263: if hr_multi_message.unexpected_error_add(l_proc) then
264: if g_debug then
265: --
266: hr_utility.set_location(' Leaving:' || l_proc,40);
267: --
268: End if;
269:
270: raise;
275: p_return_status := hr_multi_message.get_return_status_disable;
276:
277: if g_debug then
278: --
279: hr_utility.set_location(' Leaving:' || l_proc,50);
280: --
281: End if;
282:
283: end delete_stat_situation_rule;
311: Begin
312:
313: if g_debug then
314: --
315: hr_utility.set_location(' Entering:' || l_proc,10);
316: --
317: End if;
318:
319: --
369: p_return_status := hr_multi_message.get_return_status_disable;
370:
371: if g_debug then
372: --
373: hr_utility.set_location(' Leaving:' || l_proc,20);
374: --
375: End if;
376:
377: --
390: p_return_status := hr_multi_message.get_return_status_disable;
391:
392: if g_debug then
393: --
394: hr_utility.set_location(' Leaving:' || l_proc, 30);
395: --
396: End if;
397:
398: when others then
407: if hr_multi_message.unexpected_error_add(l_proc) then
408:
409: if g_debug then
410: --
411: hr_utility.set_location(' Leaving:' || l_proc,40);
412: --
413: End if;
414:
415: raise;
421: p_return_status := hr_multi_message.get_return_status_disable;
422:
423: if g_debug then
424: --
425: hr_utility.set_location(' Leaving:' || l_proc,50);
426: --
427: End if;
428:
429: end update_stat_situation_rule;