28: -- Other variables
29: l_global_index_id number;
30: l_proc varchar2(72) := g_package ||'create_global_index';
31: Begin
32: hr_utility.set_location(' Entering:' || l_proc,10);
33: --
34: -- Issue a savepoint
35: --
36: savepoint create_global_index_swi;
78: -- messages of any type exist in the Multiple Message List.
79: -- Also disable Multiple Message Detection.
80: --
81: p_return_status := hr_multi_message.get_return_status_disable;
82: hr_utility.set_location(' Leaving:' || l_proc,20);
83: --
84: exception
85: when hr_multi_message.error_message_exist then
86: --
96: p_effective_start_date := null;
97: p_effective_end_date := null;
98: p_global_index_id := null;
99: p_return_status := hr_multi_message.get_return_status_disable;
100: hr_utility.set_location(' Leaving:' || l_proc, 30);
101: when others then
102: --
103: -- When Multiple Message Detection is enabled catch
104: -- any Application specific or other unexpected
107: -- error.
108: --
109: rollback to create_global_index_swi;
110: if hr_multi_message.unexpected_error_add(l_proc) then
111: hr_utility.set_location(' Leaving:' || l_proc,40);
112: raise;
113: end if;
114: --
115: -- Reset IN OUT and set OUT parameters
119: p_effective_end_date := null;
120: p_global_index_id := null;
121:
122: p_return_status := hr_multi_message.get_return_status_disable;
123: hr_utility.set_location(' Leaving:' || l_proc,50);
124: end create_global_index;
125: -- ----------------------------------------------------------------------------
126: -- |---------------------------< create_indemnity_rate >--------------------------|
127: -- ----------------------------------------------------------------------------
145: --
146: -- Other variables
147: l_proc varchar2(72) := g_package ||'create_indemnity_rate';
148: Begin
149: hr_utility.set_location(' Entering:' || l_proc,10);
150: --
151: -- Issue a savepoint
152: --
153: savepoint create_indemnity_rate_swi;
193: -- messages of any type exist in the Multiple Message List.
194: -- Also disable Multiple Message Detection.
195: --
196: p_return_status := hr_multi_message.get_return_status_disable;
197: hr_utility.set_location(' Leaving:' || l_proc,20);
198: --
199: exception
200: when hr_multi_message.error_message_exist then
201: --
211: p_object_version_number := null;
212: p_effective_start_date := null;
213: p_effective_end_date := null;
214: p_return_status := hr_multi_message.get_return_status_disable;
215: hr_utility.set_location(' Leaving:' || l_proc, 30);
216: when others then
217: --
218: -- When Multiple Message Detection is enabled catch
219: -- any Application specific or other unexpected
222: -- error.
223: --
224: rollback to create_indemnity_rate_swi;
225: if hr_multi_message.unexpected_error_add(l_proc) then
226: hr_utility.set_location(' Leaving:' || l_proc,40);
227: raise;
228: end if;
229: --
230: -- Reset IN OUT and set OUT parameters
234: p_effective_start_date := null;
235: p_effective_end_date := null;
236:
237: p_return_status := hr_multi_message.get_return_status_disable;
238: hr_utility.set_location(' Leaving:' || l_proc,50);
239: end create_indemnity_rate;
240: -- ----------------------------------------------------------------------------
241: -- |-------------------------< delete_global_index >------------------------|
242: -- ----------------------------------------------------------------------------
259: --
260: -- Other variables
261: l_proc varchar2(72) := g_package ||'delete_global_index';
262: Begin
263: hr_utility.set_location(' Entering:' || l_proc,10);
264: --
265: -- Issue a savepoint
266: --
267: savepoint delete_global_index_swi;
306: -- messages of any type exist in the Multiple Message List.
307: -- Also disable Multiple Message Detection.
308: --
309: p_return_status := hr_multi_message.get_return_status_disable;
310: hr_utility.set_location(' Leaving:' || l_proc,20);
311: --
312: exception
313: when hr_multi_message.error_message_exist then
314: --
323: p_object_version_number := l_object_version_number;
324: p_effective_start_date := null;
325: p_effective_end_date := null;
326: p_return_status := hr_multi_message.get_return_status_disable;
327: hr_utility.set_location(' Leaving:' || l_proc, 30);
328: when others then
329: --
330: -- When Multiple Message Detection is enabled catch
331: -- any Application specific or other unexpected
334: -- error.
335: --
336: rollback to delete_global_index_swi;
337: if hr_multi_message.unexpected_error_add(l_proc) then
338: hr_utility.set_location(' Leaving:' || l_proc,40);
339: raise;
340: end if;
341: --
342: -- Reset IN OUT and set OUT parameters
344: p_object_version_number := l_object_version_number;
345: p_effective_start_date := null;
346: p_effective_end_date := null;
347: p_return_status := hr_multi_message.get_return_status_disable;
348: hr_utility.set_location(' Leaving:' || l_proc,50);
349: end delete_global_index;
350: -- ----------------------------------------------------------------------------
351: -- |---------------------------< delete_indemnity_rate >--------------------------|
352: -- ----------------------------------------------------------------------------
369: --
370: -- Other variables
371: l_proc varchar2(72) := g_package ||'delete_indemnity_rate';
372: Begin
373: hr_utility.set_location(' Entering:' || l_proc,10);
374: --
375: -- Issue a savepoint
376: --
377: savepoint delete_indemnity_rate_swi;
416: -- messages of any type exist in the Multiple Message List.
417: -- Also disable Multiple Message Detection.
418: --
419: p_return_status := hr_multi_message.get_return_status_disable;
420: hr_utility.set_location(' Leaving:' || l_proc,20);
421: --
422: exception
423: when hr_multi_message.error_message_exist then
424: --
433: p_object_version_number := l_object_version_number;
434: p_effective_start_date := null;
435: p_effective_end_date := null;
436: p_return_status := hr_multi_message.get_return_status_disable;
437: hr_utility.set_location(' Leaving:' || l_proc, 30);
438: when others then
439: --
440: -- When Multiple Message Detection is enabled catch
441: -- any Application specific or other unexpected
444: -- error.
445: --
446: rollback to delete_indemnity_rate_swi;
447: if hr_multi_message.unexpected_error_add(l_proc) then
448: hr_utility.set_location(' Leaving:' || l_proc,40);
449: raise;
450: end if;
451: --
452: -- Reset IN OUT and set OUT parameters
454: p_object_version_number := l_object_version_number;
455: p_effective_start_date := null;
456: p_effective_end_date := null;
457: p_return_status := hr_multi_message.get_return_status_disable;
458: hr_utility.set_location(' Leaving:' || l_proc,50);
459: end delete_indemnity_rate;
460: -- ----------------------------------------------------------------------------
461: -- |-------------------------< update_global_index >------------------------|
462: -- ----------------------------------------------------------------------------
481: --
482: -- Other variables
483: l_proc varchar2(72) := g_package ||'update_global_index';
484: Begin
485: hr_utility.set_location(' Entering:' || l_proc,10);
486: --
487: -- Issue a savepoint
488: --
489: savepoint update_global_index_swi;
530: -- messages of any type exist in the Multiple Message List.
531: -- Also disable Multiple Message Detection.
532: --
533: p_return_status := hr_multi_message.get_return_status_disable;
534: hr_utility.set_location(' Leaving:' || l_proc,20);
535: --
536: exception
537: when hr_multi_message.error_message_exist then
538: --
547: p_object_version_number := l_object_version_number;
548: p_effective_start_date := null;
549: p_effective_end_date := null;
550: p_return_status := hr_multi_message.get_return_status_disable;
551: hr_utility.set_location(' Leaving:' || l_proc, 30);
552: when others then
553: --
554: -- When Multiple Message Detection is enabled catch
555: -- any Application specific or other unexpected
558: -- error.
559: --
560: rollback to update_global_index_swi;
561: if hr_multi_message.unexpected_error_add(l_proc) then
562: hr_utility.set_location(' Leaving:' || l_proc,40);
563: raise;
564: end if;
565: --
566: -- Reset IN OUT and set OUT parameters
568: p_object_version_number := l_object_version_number;
569: p_effective_start_date := null;
570: p_effective_end_date := null;
571: p_return_status := hr_multi_message.get_return_status_disable;
572: hr_utility.set_location(' Leaving:' || l_proc,50);
573: end update_global_index;
574: -- ----------------------------------------------------------------------------
575: -- |---------------------------< update_indemnity_rate >--------------------------|
576: -- ----------------------------------------------------------------------------
596: --
597: -- Other variables
598: l_proc varchar2(72) := g_package ||'update_indemnity_rate';
599: Begin
600: hr_utility.set_location(' Entering:' || l_proc,10);
601: --
602: -- Issue a savepoint
603: --
604: savepoint update_indemnity_rate_swi;
647: -- messages of any type exist in the Multiple Message List.
648: -- Also disable Multiple Message Detection.
649: --
650: p_return_status := hr_multi_message.get_return_status_disable;
651: hr_utility.set_location(' Leaving:' || l_proc,20);
652: --
653: exception
654: when hr_multi_message.error_message_exist then
655: --
664: p_object_version_number := l_object_version_number;
665: p_effective_start_date := null;
666: p_effective_end_date := null;
667: p_return_status := hr_multi_message.get_return_status_disable;
668: hr_utility.set_location(' Leaving:' || l_proc, 30);
669: when others then
670: --
671: -- When Multiple Message Detection is enabled catch
672: -- any Application specific or other unexpected
675: -- error.
676: --
677: rollback to update_indemnity_rate_swi;
678: if hr_multi_message.unexpected_error_add(l_proc) then
679: hr_utility.set_location(' Leaving:' || l_proc,40);
680: raise;
681: end if;
682: --
683: -- Reset IN OUT and set OUT parameters
685: p_object_version_number := l_object_version_number;
686: p_effective_start_date := null;
687: p_effective_end_date := null;
688: p_return_status := hr_multi_message.get_return_status_disable;
689: hr_utility.set_location(' Leaving:' || l_proc,50);
690: end update_indemnity_rate;
691: end pqh_fr_global_payscale_swi;