DBA Data[Home] [Help]

APPS.PQH_FR_GLOBAL_PAYSCALE_SWI dependencies on HR_UTILITY

Line 32: hr_utility.set_location(' Entering:' || l_proc,10);

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;

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

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

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

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

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

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

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

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

Line 149: hr_utility.set_location(' Entering:' || l_proc,10);

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;

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

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

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

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

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

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

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

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

Line 263: hr_utility.set_location(' Entering:' || l_proc,10);

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;

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

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

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

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

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

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

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

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

Line 373: hr_utility.set_location(' Entering:' || l_proc,10);

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;

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

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

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

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

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

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

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

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

Line 485: hr_utility.set_location(' Entering:' || l_proc,10);

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;

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

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

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

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

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

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

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

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

Line 600: hr_utility.set_location(' Entering:' || l_proc,10);

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;

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

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

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

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

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

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

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

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;