DBA Data[Home] [Help]

APPS.OTA_SKILL_PROVISION_SWI dependencies on HR_UTILITY

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

48: -- Other variables
49: l_skill_provision_id number;
50: l_proc varchar2(72) := g_package ||'create_skill_provision';
51: Begin
52: hr_utility.set_location(' Entering:' || l_proc,10);
53: --
54: -- Issue a savepoint
55: --
56: savepoint create_skill_provision_swi;

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

118: -- messages of any type exist in the Multiple Message List.
119: -- Also disable Multiple Message Detection.
120: --
121: p_return_status := hr_multi_message.get_return_status_disable;
122: hr_utility.set_location(' Leaving:' || l_proc,20);
123: --
124: exception
125: when hr_multi_message.error_message_exist then
126: --

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

133: -- Reset IN OUT parameters and set OUT parameters
134: --
135: p_object_version_number := null;
136: p_return_status := hr_multi_message.get_return_status_disable;
137: hr_utility.set_location(' Leaving:' || l_proc, 30);
138: when others then
139: --
140: -- When Multiple Message Detection is enabled catch
141: -- any Application specific or other unexpected

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

144: -- error.
145: --
146: rollback to create_skill_provision_swi;
147: if hr_multi_message.unexpected_error_add(l_proc) then
148: hr_utility.set_location(' Leaving:' || l_proc,40);
149: raise;
150: end if;
151: --
152: -- Reset IN OUT and set OUT parameters

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

152: -- Reset IN OUT and set OUT parameters
153: --
154: p_object_version_number := null;
155: p_return_status := hr_multi_message.get_return_status_disable;
156: hr_utility.set_location(' Leaving:' || l_proc,50);
157: end create_skill_provision;
158: -- ----------------------------------------------------------------------------
159: -- |------------------------< delete_skill_provision >------------------------|
160: -- ----------------------------------------------------------------------------

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

172: --
173: -- Other variables
174: l_proc varchar2(72) := g_package ||'delete_skill_provision';
175: Begin
176: hr_utility.set_location(' Entering:' || l_proc,10);
177: --
178: -- Issue a savepoint
179: --
180: savepoint delete_skill_provision_swi;

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

214: -- messages of any type exist in the Multiple Message List.
215: -- Also disable Multiple Message Detection.
216: --
217: p_return_status := hr_multi_message.get_return_status_disable;
218: hr_utility.set_location(' Leaving:' || l_proc,20);
219: --
220: exception
221: when hr_multi_message.error_message_exist then
222: --

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

228: --
229: -- Reset IN OUT parameters and set OUT parameters
230: --
231: p_return_status := hr_multi_message.get_return_status_disable;
232: hr_utility.set_location(' Leaving:' || l_proc, 30);
233: when others then
234: --
235: -- When Multiple Message Detection is enabled catch
236: -- any Application specific or other unexpected

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

239: -- error.
240: --
241: rollback to delete_skill_provision_swi;
242: if hr_multi_message.unexpected_error_add(l_proc) then
243: hr_utility.set_location(' Leaving:' || l_proc,40);
244: raise;
245: end if;
246: --
247: -- Reset IN OUT and set OUT parameters

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

246: --
247: -- Reset IN OUT and set OUT parameters
248: --
249: p_return_status := hr_multi_message.get_return_status_disable;
250: hr_utility.set_location(' Leaving:' || l_proc,50);
251: end delete_skill_provision;
252: -- ----------------------------------------------------------------------------
253: -- |------------------------< update_skill_provision >------------------------|
254: -- ----------------------------------------------------------------------------

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

292: --
293: -- Other variables
294: l_proc varchar2(72) := g_package ||'update_skill_provision';
295: Begin
296: hr_utility.set_location(' Entering:' || l_proc,10);
297: --
298: -- Issue a savepoint
299: --
300: savepoint update_skill_provision_swi;

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

360: -- messages of any type exist in the Multiple Message List.
361: -- Also disable Multiple Message Detection.
362: --
363: p_return_status := hr_multi_message.get_return_status_disable;
364: hr_utility.set_location(' Leaving:' || l_proc,20);
365: --
366: exception
367: when hr_multi_message.error_message_exist then
368: --

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

375: -- Reset IN OUT parameters and set OUT parameters
376: --
377: p_object_version_number := l_object_version_number;
378: p_return_status := hr_multi_message.get_return_status_disable;
379: hr_utility.set_location(' Leaving:' || l_proc, 30);
380: when others then
381: --
382: -- When Multiple Message Detection is enabled catch
383: -- any Application specific or other unexpected

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

386: -- error.
387: --
388: rollback to update_skill_provision_swi;
389: if hr_multi_message.unexpected_error_add(l_proc) then
390: hr_utility.set_location(' Leaving:' || l_proc,40);
391: raise;
392: end if;
393: --
394: -- Reset IN OUT and set OUT parameters

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

394: -- Reset IN OUT and set OUT parameters
395: --
396: p_object_version_number := l_object_version_number;
397: p_return_status := hr_multi_message.get_return_status_disable;
398: hr_utility.set_location(' Leaving:' || l_proc,50);
399: end update_skill_provision;
400: end ota_skill_provision_swi;