DBA Data[Home] [Help]

APPS.OTA_CERT_MEMBER_SWI dependencies on HR_UTILITY

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

52: -- Other variables
53: l_certification_member_id number;
54: l_proc varchar2(72) := g_package ||'create_certification_member';
55: Begin
56: hr_utility.set_location(' Entering:' || l_proc,10);
57: --
58: -- Issue a savepoint
59: --
60: savepoint create_cert_member_swi;

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

126: -- messages of any type exist in the Multiple Message List.
127: -- Also disable Multiple Message Detection.
128: --
129: p_return_status := hr_multi_message.get_return_status_disable;
130: hr_utility.set_location(' Leaving:' || l_proc,20);
131: --
132: exception
133: when hr_multi_message.error_message_exist then
134: --

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

141: -- Reset IN OUT parameters and set OUT parameters
142: --
143: p_object_version_number := null;
144: p_return_status := hr_multi_message.get_return_status_disable;
145: hr_utility.set_location(' Leaving:' || l_proc, 30);
146: when others then
147: --
148: -- When Multiple Message Detection is enabled catch
149: -- any Application specific or other unexpected

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

152: -- error.
153: --
154: rollback to create_cert_member_swi;
155: if hr_multi_message.unexpected_error_add(l_proc) then
156: hr_utility.set_location(' Leaving:' || l_proc,40);
157: raise;
158: end if;
159: --
160: -- Reset IN OUT and set OUT parameters

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

160: -- Reset IN OUT and set OUT parameters
161: --
162: p_object_version_number := null;
163: p_return_status := hr_multi_message.get_return_status_disable;
164: hr_utility.set_location(' Leaving:' || l_proc,50);
165: end create_certification_member;
166: -- ----------------------------------------------------------------------------
167: -- |----------------------< update_certification_member >---------------------|
168: -- ----------------------------------------------------------------------------

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

208: --
209: -- Other variables
210: l_proc varchar2(72) := g_package ||'update_certification_member';
211: Begin
212: hr_utility.set_location(' Entering:' || l_proc,10);
213: --
214: -- Issue a savepoint
215: --
216: savepoint update_cert_member_swi;

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

278: -- messages of any type exist in the Multiple Message List.
279: -- Also disable Multiple Message Detection.
280: --
281: p_return_status := hr_multi_message.get_return_status_disable;
282: hr_utility.set_location(' Leaving:' || l_proc,20);
283: --
284: exception
285: when hr_multi_message.error_message_exist then
286: --

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

293: -- Reset IN OUT parameters and set OUT parameters
294: --
295: p_object_version_number := l_object_version_number;
296: p_return_status := hr_multi_message.get_return_status_disable;
297: hr_utility.set_location(' Leaving:' || l_proc, 30);
298: when others then
299: --
300: -- When Multiple Message Detection is enabled catch
301: -- any Application specific or other unexpected

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

304: -- error.
305: --
306: rollback to update_cert_member_swi;
307: if hr_multi_message.unexpected_error_add(l_proc) then
308: hr_utility.set_location(' Leaving:' || l_proc,40);
309: raise;
310: end if;
311: --
312: -- Reset IN OUT and set OUT parameters

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

312: -- Reset IN OUT and set OUT parameters
313: --
314: p_object_version_number := l_object_version_number;
315: p_return_status := hr_multi_message.get_return_status_disable;
316: hr_utility.set_location(' Leaving:' || l_proc,50);
317: end update_certification_member;
318: -- ----------------------------------------------------------------------------
319: -- |----------------------< delete_certification_member >---------------------|
320: -- ----------------------------------------------------------------------------

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

332: --
333: -- Other variables
334: l_proc varchar2(72) := g_package ||'delete_certification_member';
335: Begin
336: hr_utility.set_location(' Entering:' || l_proc,10);
337: --
338: -- Issue a savepoint
339: --
340: savepoint delete_cert_member_swi;

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

374: -- messages of any type exist in the Multiple Message List.
375: -- Also disable Multiple Message Detection.
376: --
377: p_return_status := hr_multi_message.get_return_status_disable;
378: hr_utility.set_location(' Leaving:' || l_proc,20);
379: --
380: exception
381: when hr_multi_message.error_message_exist then
382: --

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

388: --
389: -- Reset IN OUT parameters and set OUT parameters
390: --
391: p_return_status := hr_multi_message.get_return_status_disable;
392: hr_utility.set_location(' Leaving:' || l_proc, 30);
393: when others then
394: --
395: -- When Multiple Message Detection is enabled catch
396: -- any Application specific or other unexpected

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

399: -- error.
400: --
401: rollback to delete_cert_member_swi;
402: if hr_multi_message.unexpected_error_add(l_proc) then
403: hr_utility.set_location(' Leaving:' || l_proc,40);
404: raise;
405: end if;
406: --
407: -- Reset IN OUT and set OUT parameters

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

406: --
407: -- Reset IN OUT and set OUT parameters
408: --
409: p_return_status := hr_multi_message.get_return_status_disable;
410: hr_utility.set_location(' Leaving:' || l_proc,50);
411: end delete_certification_member;
412:
413: FUNCTION check_cmb_enrollments_exist
414: (p_cert_member_id in number