DBA Data[Home] [Help]

APPS.PQH_BDGT_POOL_REALLOCTIONS_SWI dependencies on HR_UTILITY

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

27: --
28: -- Other variables
29: l_proc varchar2(72) := g_package ||'create_realloc_txn_dtl';
30: Begin
31: hr_utility.set_location(' Entering:' || l_proc,10);
32: --
33: -- Issue a savepoint
34: --
35: savepoint create_realloc_txn_dtl_swi;

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

74: -- messages of any type exist in the Multiple Message List.
75: -- Also disable Multiple Message Detection.
76: --
77: p_return_status := hr_multi_message.get_return_status_disable;
78: hr_utility.set_location(' Leaving:' || l_proc,20);
79: --
80: exception
81: when hr_multi_message.error_message_exist then
82: --

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

90: --
91: p_txn_detail_id := null;
92: p_object_version_number := null;
93: p_return_status := hr_multi_message.get_return_status_disable;
94: hr_utility.set_location(' Leaving:' || l_proc, 30);
95: when others then
96: --
97: -- When Multiple Message Detection is enabled catch
98: -- any Application specific or other unexpected

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

101: -- error.
102: --
103: rollback to create_realloc_txn_dtl_swi;
104: if hr_multi_message.unexpected_error_add(l_proc) then
105: hr_utility.set_location(' Leaving:' || l_proc,40);
106: raise;
107: end if;
108: --
109: -- Reset IN OUT and set OUT parameters

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

110: --
111: p_txn_detail_id := null;
112: p_object_version_number := null;
113: p_return_status := hr_multi_message.get_return_status_disable;
114: hr_utility.set_location(' Leaving:' || l_proc,50);
115: end create_realloc_txn_dtl;
116: -- ----------------------------------------------------------------------------
117: -- |-----------------------< create_realloc_txn_period >----------------------|
118: -- ----------------------------------------------------------------------------

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

139: --
140: -- Other variables
141: l_proc varchar2(72) := g_package ||'create_realloc_txn_period';
142: Begin
143: hr_utility.set_location(' Entering:' || l_proc,10);
144: --
145: -- Issue a savepoint
146: --
147: savepoint create_realloc_txn_period_swi;

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

190: -- messages of any type exist in the Multiple Message List.
191: -- Also disable Multiple Message Detection.
192: --
193: p_return_status := hr_multi_message.get_return_status_disable;
194: hr_utility.set_location(' Leaving:' || l_proc,20);
195: --
196: exception
197: when hr_multi_message.error_message_exist then
198: --

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

206: --
207: p_reallocation_period_id := null;
208: p_object_version_number := null;
209: p_return_status := hr_multi_message.get_return_status_disable;
210: hr_utility.set_location(' Leaving:' || l_proc, 30);
211: when others then
212: --
213: -- When Multiple Message Detection is enabled catch
214: -- any Application specific or other unexpected

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

217: -- error.
218: --
219: rollback to create_realloc_txn_period_swi;
220: if hr_multi_message.unexpected_error_add(l_proc) then
221: hr_utility.set_location(' Leaving:' || l_proc,40);
222: raise;
223: end if;
224: --
225: -- Reset IN OUT and set OUT parameters

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

226: --
227: p_reallocation_period_id := null;
228: p_object_version_number := null;
229: p_return_status := hr_multi_message.get_return_status_disable;
230: hr_utility.set_location(' Leaving:' || l_proc,50);
231: end create_realloc_txn_period;
232: -- ----------------------------------------------------------------------------
233: -- |------------------------< delete_realloc_txn_dtl >------------------------|
234: -- ----------------------------------------------------------------------------

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

246: --
247: -- Other variables
248: l_proc varchar2(72) := g_package ||'delete_realloc_txn_dtl';
249: Begin
250: hr_utility.set_location(' Entering:' || l_proc,10);
251: --
252: -- Issue a savepoint
253: --
254: savepoint delete_realloc_txn_dtl_swi;

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

288: -- messages of any type exist in the Multiple Message List.
289: -- Also disable Multiple Message Detection.
290: --
291: p_return_status := hr_multi_message.get_return_status_disable;
292: hr_utility.set_location(' Leaving:' || l_proc,20);
293: --
294: exception
295: when hr_multi_message.error_message_exist then
296: --

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

302: --
303: -- Reset IN OUT parameters and set OUT parameters
304: --
305: p_return_status := hr_multi_message.get_return_status_disable;
306: hr_utility.set_location(' Leaving:' || l_proc, 30);
307: when others then
308: --
309: -- When Multiple Message Detection is enabled catch
310: -- any Application specific or other unexpected

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

313: -- error.
314: --
315: rollback to delete_realloc_txn_dtl_swi;
316: if hr_multi_message.unexpected_error_add(l_proc) then
317: hr_utility.set_location(' Leaving:' || l_proc,40);
318: raise;
319: end if;
320: --
321: -- Reset IN OUT and set OUT parameters

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

320: --
321: -- Reset IN OUT and set OUT parameters
322: --
323: p_return_status := hr_multi_message.get_return_status_disable;
324: hr_utility.set_location(' Leaving:' || l_proc,50);
325: end delete_realloc_txn_dtl;
326: -- ----------------------------------------------------------------------------
327: -- |-----------------------< delete_realloc_txn_period >----------------------|
328: -- ----------------------------------------------------------------------------

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

340: --
341: -- Other variables
342: l_proc varchar2(72) := g_package ||'delete_realloc_txn_period';
343: Begin
344: hr_utility.set_location(' Entering:' || l_proc,10);
345: --
346: -- Issue a savepoint
347: --
348: savepoint delete_realloc_txn_period_swi;

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

382: -- messages of any type exist in the Multiple Message List.
383: -- Also disable Multiple Message Detection.
384: --
385: p_return_status := hr_multi_message.get_return_status_disable;
386: hr_utility.set_location(' Leaving:' || l_proc,20);
387: --
388: exception
389: when hr_multi_message.error_message_exist then
390: --

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

396: --
397: -- Reset IN OUT parameters and set OUT parameters
398: --
399: p_return_status := hr_multi_message.get_return_status_disable;
400: hr_utility.set_location(' Leaving:' || l_proc, 30);
401: when others then
402: --
403: -- When Multiple Message Detection is enabled catch
404: -- any Application specific or other unexpected

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

407: -- error.
408: --
409: rollback to delete_realloc_txn_period_swi;
410: if hr_multi_message.unexpected_error_add(l_proc) then
411: hr_utility.set_location(' Leaving:' || l_proc,40);
412: raise;
413: end if;
414: --
415: -- Reset IN OUT and set OUT parameters

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

414: --
415: -- Reset IN OUT and set OUT parameters
416: --
417: p_return_status := hr_multi_message.get_return_status_disable;
418: hr_utility.set_location(' Leaving:' || l_proc,50);
419: end delete_realloc_txn_period;
420: -- ----------------------------------------------------------------------------
421: -- |------------------------< update_realloc_txn_dtl >------------------------|
422: -- ----------------------------------------------------------------------------

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

440: --
441: -- Other variables
442: l_proc varchar2(72) := g_package ||'update_realloc_txn_dtl';
443: Begin
444: hr_utility.set_location(' Entering:' || l_proc,10);
445: --
446: -- Issue a savepoint
447: --
448: savepoint update_realloc_txn_dtl_swi;

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

488: -- messages of any type exist in the Multiple Message List.
489: -- Also disable Multiple Message Detection.
490: --
491: p_return_status := hr_multi_message.get_return_status_disable;
492: hr_utility.set_location(' Leaving:' || l_proc,20);
493: --
494: exception
495: when hr_multi_message.error_message_exist then
496: --

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

503: -- Reset IN OUT parameters and set OUT parameters
504: --
505: p_object_version_number := l_object_version_number;
506: p_return_status := hr_multi_message.get_return_status_disable;
507: hr_utility.set_location(' Leaving:' || l_proc, 30);
508: when others then
509: --
510: -- When Multiple Message Detection is enabled catch
511: -- any Application specific or other unexpected

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

514: -- error.
515: --
516: rollback to update_realloc_txn_dtl_swi;
517: if hr_multi_message.unexpected_error_add(l_proc) then
518: hr_utility.set_location(' Leaving:' || l_proc,40);
519: raise;
520: end if;
521: --
522: -- Reset IN OUT and set OUT parameters

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

522: -- Reset IN OUT and set OUT parameters
523: --
524: p_object_version_number := l_object_version_number;
525: p_return_status := hr_multi_message.get_return_status_disable;
526: hr_utility.set_location(' Leaving:' || l_proc,50);
527: end update_realloc_txn_dtl;
528: -- ----------------------------------------------------------------------------
529: -- |-----------------------< update_realloc_txn_period >----------------------|
530: -- ----------------------------------------------------------------------------

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

552: --
553: -- Other variables
554: l_proc varchar2(72) := g_package ||'update_realloc_txn_period';
555: Begin
556: hr_utility.set_location(' Entering:' || l_proc,10);
557: --
558: -- Issue a savepoint
559: --
560: savepoint update_realloc_txn_period_swi;

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

604: -- messages of any type exist in the Multiple Message List.
605: -- Also disable Multiple Message Detection.
606: --
607: p_return_status := hr_multi_message.get_return_status_disable;
608: hr_utility.set_location(' Leaving:' || l_proc,20);
609: --
610: exception
611: when hr_multi_message.error_message_exist then
612: --

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

619: -- Reset IN OUT parameters and set OUT parameters
620: --
621: p_object_version_number := l_object_version_number;
622: p_return_status := hr_multi_message.get_return_status_disable;
623: hr_utility.set_location(' Leaving:' || l_proc, 30);
624: when others then
625: --
626: -- When Multiple Message Detection is enabled catch
627: -- any Application specific or other unexpected

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

630: -- error.
631: --
632: rollback to update_realloc_txn_period_swi;
633: if hr_multi_message.unexpected_error_add(l_proc) then
634: hr_utility.set_location(' Leaving:' || l_proc,40);
635: raise;
636: end if;
637: --
638: -- Reset IN OUT and set OUT parameters

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

638: -- Reset IN OUT and set OUT parameters
639: --
640: p_object_version_number := l_object_version_number;
641: p_return_status := hr_multi_message.get_return_status_disable;
642: hr_utility.set_location(' Leaving:' || l_proc,50);
643: end update_realloc_txn_period;
644: end pqh_bdgt_pool_realloctions_swi;