DBA Data[Home] [Help]

APPS.IRC_RECRUITING_SITES_SWI dependencies on HR_UTILITY

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

70: -- Other variables
71: l_recruiting_site_id number;
72: l_proc varchar2(72) := g_package ||'create_recruiting_site';
73: Begin
74: hr_utility.set_location(' Entering:' || l_proc,10);
75: --
76: -- Issue a savepoint
77: --
78: savepoint create_recruiting_site_swi;

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

162: -- messages of any type exist in the Multiple Message List.
163: -- Also disable Multiple Message Detection.
164: --
165: p_return_status := hr_multi_message.get_return_status_disable;
166: hr_utility.set_location(' Leaving:' || l_proc,20);
167: --
168: exception
169: when hr_multi_message.error_message_exist then
170: --

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

177: -- Reset IN OUT parameters and set OUT parameters
178: --
179: p_object_version_number := null;
180: p_return_status := hr_multi_message.get_return_status_disable;
181: hr_utility.set_location(' Leaving:' || l_proc, 30);
182: when others then
183: --
184: -- When Multiple Message Detection is enabled catch
185: -- any Application specific or other unexpected

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

188: -- error.
189: --
190: rollback to create_recruiting_site_swi;
191: if hr_multi_message.unexpected_error_add(l_proc) then
192: hr_utility.set_location(' Leaving:' || l_proc,40);
193: raise;
194: end if;
195: --
196: -- Reset IN OUT and set OUT parameters

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

196: -- Reset IN OUT and set OUT parameters
197: --
198: p_object_version_number := null;
199: p_return_status := hr_multi_message.get_return_status_disable;
200: hr_utility.set_location(' Leaving:' || l_proc,50);
201: end create_recruiting_site;
202: -- ----------------------------------------------------------------------------
203: -- |------------------------< delete_recruiting_site >------------------------|
204: -- ----------------------------------------------------------------------------

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

222: select object_version_number
223: from irc_all_recruiting_sites
224: where recruiting_site_id = p_recruiting_site_id;
225: Begin
226: hr_utility.set_location(' Entering:' || l_proc,10);
227: --
228: -- Issue a savepoint
229: --
230: savepoint delete_recruiting_site_swi;

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

271: -- messages of any type exist in the Multiple Message List.
272: -- Also disable Multiple Message Detection.
273: --
274: p_return_status := hr_multi_message.get_return_status_disable;
275: hr_utility.set_location(' Leaving:' || l_proc,20);
276: --
277: exception
278: when hr_multi_message.error_message_exist then
279: --

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

285: --
286: -- Reset IN OUT parameters and set OUT parameters
287: --
288: p_return_status := hr_multi_message.get_return_status_disable;
289: hr_utility.set_location(' Leaving:' || l_proc, 30);
290: when others then
291: --
292: -- When Multiple Message Detection is enabled catch
293: -- any Application specific or other unexpected

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

296: -- error.
297: --
298: rollback to delete_recruiting_site_swi;
299: if hr_multi_message.unexpected_error_add(l_proc) then
300: hr_utility.set_location(' Leaving:' || l_proc,40);
301: raise;
302: end if;
303: --
304: -- Reset IN OUT and set OUT parameters

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

303: --
304: -- Reset IN OUT and set OUT parameters
305: --
306: p_return_status := hr_multi_message.get_return_status_disable;
307: hr_utility.set_location(' Leaving:' || l_proc,50);
308: end delete_recruiting_site;
309: -- ----------------------------------------------------------------------------
310: -- |------------------------< update_recruiting_site >------------------------|
311: -- ----------------------------------------------------------------------------

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

371: --
372: -- Other variables
373: l_proc varchar2(72) := g_package ||'update_recruiting_site';
374: Begin
375: hr_utility.set_location(' Entering:' || l_proc,10);
376: --
377: -- Issue a savepoint
378: --
379: savepoint update_recruiting_site_swi;

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

461: -- messages of any type exist in the Multiple Message List.
462: -- Also disable Multiple Message Detection.
463: --
464: p_return_status := hr_multi_message.get_return_status_disable;
465: hr_utility.set_location(' Leaving:' || l_proc,20);
466: --
467: exception
468: when hr_multi_message.error_message_exist then
469: --

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

476: -- Reset IN OUT parameters and set OUT parameters
477: --
478: p_object_version_number := l_object_version_number;
479: p_return_status := hr_multi_message.get_return_status_disable;
480: hr_utility.set_location(' Leaving:' || l_proc, 30);
481: when others then
482: --
483: -- When Multiple Message Detection is enabled catch
484: -- any Application specific or other unexpected

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

487: -- error.
488: --
489: rollback to update_recruiting_site_swi;
490: if hr_multi_message.unexpected_error_add(l_proc) then
491: hr_utility.set_location(' Leaving:' || l_proc,40);
492: raise;
493: end if;
494: --
495: -- Reset IN OUT and set OUT parameters

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

495: -- Reset IN OUT and set OUT parameters
496: --
497: p_object_version_number := l_object_version_number;
498: p_return_status := hr_multi_message.get_return_status_disable;
499: hr_utility.set_location(' Leaving:' || l_proc,50);
500: end update_recruiting_site;
501: end irc_recruiting_sites_swi;