DBA Data[Home] [Help]

APPS.OTA_COURSE_PREREQUISITE_SWI dependencies on HR_UTILITY

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

29: l_activity_version_id number;
30: l_prerequisite_course_id number;
31: l_proc varchar2(72) := g_package ||'create_course_prerequisite';
32: Begin
33: hr_utility.set_location(' Entering:' || l_proc,10);
34: --
35: -- Issue a savepoint
36: --
37: savepoint create_course_prerequisite_swi;

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

80: -- messages of any type exist in the Multiple Message List.
81: -- Also disable Multiple Message Detection.
82: --
83: p_return_status := hr_multi_message.get_return_status_disable;
84: hr_utility.set_location(' Leaving:' || l_proc,20);
85: --
86: exception
87: when hr_multi_message.error_message_exist then
88: --

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

95: -- Reset IN OUT parameters and set OUT parameters
96: --
97: p_object_version_number := null;
98: p_return_status := hr_multi_message.get_return_status_disable;
99: hr_utility.set_location(' Leaving:' || l_proc, 30);
100: when others then
101: --
102: -- When Multiple Message Detection is enabled catch
103: -- any Application specific or other unexpected

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

106: -- error.
107: --
108: rollback to create_course_prerequisite_swi;
109: if hr_multi_message.unexpected_error_add(l_proc) then
110: hr_utility.set_location(' Leaving:' || l_proc,40);
111: raise;
112: end if;
113: --
114: -- Reset IN OUT and set OUT parameters

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

114: -- Reset IN OUT and set OUT parameters
115: --
116: p_object_version_number := null;
117: p_return_status := hr_multi_message.get_return_status_disable;
118: hr_utility.set_location(' Leaving:' || l_proc,50);
119: end create_course_prerequisite;
120: -- ----------------------------------------------------------------------------
121: -- |----------------------< update_course_prerequisite >----------------------|
122: -- ----------------------------------------------------------------------------

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

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

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

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

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

201: -- Reset IN OUT parameters and set OUT parameters
202: --
203: p_object_version_number := null;
204: p_return_status := hr_multi_message.get_return_status_disable;
205: hr_utility.set_location(' Leaving:' || l_proc, 30);
206: when others then
207: --
208: -- When Multiple Message Detection is enabled catch
209: -- any Application specific or other unexpected

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

212: -- error.
213: --
214: rollback to update_course_prerequisite_swi;
215: if hr_multi_message.unexpected_error_add(l_proc) then
216: hr_utility.set_location(' Leaving:' || l_proc,40);
217: raise;
218: end if;
219: --
220: -- Reset IN OUT and set OUT parameters

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

220: -- Reset IN OUT and set OUT parameters
221: --
222: p_object_version_number := null;
223: p_return_status := hr_multi_message.get_return_status_disable;
224: hr_utility.set_location(' Leaving:' || l_proc,50);
225: end update_course_prerequisite;
226: -- ----------------------------------------------------------------------------
227: -- |----------------------< delete_course_prerequisite >----------------------|
228: -- ----------------------------------------------------------------------------

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

241: --
242: -- Other variables
243: l_proc varchar2(72) := g_package ||'delete_course_prerequisite';
244: Begin
245: hr_utility.set_location(' Entering:' || l_proc,10);
246: --
247: -- Issue a savepoint
248: --
249: savepoint delete_course_prerequisite_swi;

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

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

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

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

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

309: -- error.
310: --
311: rollback to delete_course_prerequisite_swi;
312: if hr_multi_message.unexpected_error_add(l_proc) then
313: hr_utility.set_location(' Leaving:' || l_proc,40);
314: raise;
315: end if;
316: --
317: -- Reset IN OUT and set OUT parameters

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

316: --
317: -- Reset IN OUT and set OUT parameters
318: --
319: p_return_status := hr_multi_message.get_return_status_disable;
320: hr_utility.set_location(' Leaving:' || l_proc,50);
321: end delete_course_prerequisite;
322: end ota_course_prerequisite_swi;