DBA Data[Home] [Help]

APPS.OTA_CERT_ENROLLMENT_SWI dependencies on HR_UTILITY

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

56: -- Other variables
57: l_cert_enrollment_id number;
58: l_proc varchar2(72) := g_package ||'create_cert_enrollment';
59: Begin
60: hr_utility.set_location(' Entering:' || l_proc,10);
61: --
62: -- Issue a savepoint
63: --
64: savepoint create_cert_enrollment_swi;

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

134: -- messages of any type exist in the Multiple Message List.
135: -- Also disable Multiple Message Detection.
136: --
137: p_return_status := hr_multi_message.get_return_status_disable;
138: hr_utility.set_location(' Leaving:' || l_proc,20);
139: --
140: exception
141: when hr_multi_message.error_message_exist then
142: --

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

149: -- Reset IN OUT parameters and set OUT parameters
150: --
151: p_object_version_number := null;
152: p_return_status := hr_multi_message.get_return_status_disable;
153: hr_utility.set_location(' Leaving:' || l_proc, 30);
154: when others then
155: --
156: -- When Multiple Message Detection is enabled catch
157: -- any Application specific or other unexpected

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

160: -- error.
161: --
162: rollback to create_cert_enrollment_swi;
163: if hr_multi_message.unexpected_error_add(l_proc) then
164: hr_utility.set_location(' Leaving:' || l_proc,40);
165: raise;
166: end if;
167: --
168: -- Reset IN OUT and set OUT parameters

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

168: -- Reset IN OUT and set OUT parameters
169: --
170: p_object_version_number := null;
171: p_return_status := hr_multi_message.get_return_status_disable;
172: hr_utility.set_location(' Leaving:' || l_proc,50);
173: end create_cert_enrollment;
174: -- ----------------------------------------------------------------------------
175: -- |------------------------< update_cert_enrollment >------------------------|
176: -- ----------------------------------------------------------------------------

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

222: --
223: -- Other variables
224: l_proc varchar2(72) := g_package ||'update_cert_enrollment';
225: Begin
226: hr_utility.set_location(' Entering:' || l_proc,10);
227: --
228: -- Issue a savepoint
229: --
230: savepoint update_cert_enrollment_swi;

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

298: -- messages of any type exist in the Multiple Message List.
299: -- Also disable Multiple Message Detection.
300: --
301: p_return_status := hr_multi_message.get_return_status_disable;
302: hr_utility.set_location(' Leaving:' || l_proc,20);
303: --
304: exception
305: when hr_multi_message.error_message_exist then
306: --

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

313: -- Reset IN OUT parameters and set OUT parameters
314: --
315: p_object_version_number := l_object_version_number;
316: p_return_status := hr_multi_message.get_return_status_disable;
317: hr_utility.set_location(' Leaving:' || l_proc, 30);
318: when others then
319: --
320: -- When Multiple Message Detection is enabled catch
321: -- any Application specific or other unexpected

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

324: -- error.
325: --
326: rollback to update_cert_enrollment_swi;
327: if hr_multi_message.unexpected_error_add(l_proc) then
328: hr_utility.set_location(' Leaving:' || l_proc,40);
329: raise;
330: end if;
331: --
332: -- Reset IN OUT and set OUT parameters

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

332: -- Reset IN OUT and set OUT parameters
333: --
334: p_object_version_number := l_object_version_number;
335: p_return_status := hr_multi_message.get_return_status_disable;
336: hr_utility.set_location(' Leaving:' || l_proc,50);
337: end update_cert_enrollment;
338: -- ----------------------------------------------------------------------------
339: -- |------------------------< delete_cert_enrollment >------------------------|
340: -- ----------------------------------------------------------------------------

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

352: --
353: -- Other variables
354: l_proc varchar2(72) := g_package ||'delete_cert_enrollment';
355: Begin
356: hr_utility.set_location(' Entering:' || l_proc,10);
357: --
358: -- Issue a savepoint
359: --
360: savepoint delete_cert_enrollment_swi;

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

394: -- messages of any type exist in the Multiple Message List.
395: -- Also disable Multiple Message Detection.
396: --
397: p_return_status := hr_multi_message.get_return_status_disable;
398: hr_utility.set_location(' Leaving:' || l_proc,20);
399: --
400: exception
401: when hr_multi_message.error_message_exist then
402: --

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

408: --
409: -- Reset IN OUT parameters and set OUT parameters
410: --
411: p_return_status := hr_multi_message.get_return_status_disable;
412: hr_utility.set_location(' Leaving:' || l_proc, 30);
413: when others then
414: --
415: -- When Multiple Message Detection is enabled catch
416: -- any Application specific or other unexpected

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

419: -- error.
420: --
421: rollback to delete_cert_enrollment_swi;
422: if hr_multi_message.unexpected_error_add(l_proc) then
423: hr_utility.set_location(' Leaving:' || l_proc,40);
424: raise;
425: end if;
426: --
427: -- Reset IN OUT and set OUT parameters

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

426: --
427: -- Reset IN OUT and set OUT parameters
428: --
429: p_return_status := hr_multi_message.get_return_status_disable;
430: hr_utility.set_location(' Leaving:' || l_proc,50);
431: end delete_cert_enrollment;
432:
433: -- ----------------------------------------------------------------------------
434: -- |--------------------------< SUBSCRIBE_TO_CERTIFICATION>--------------------|

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

533: -- messages of any type exist in the Multiple Message List.
534: -- Also disable Multiple Message Detection.
535: --
536: p_return_status := hr_multi_message.get_return_status_disable;
537: hr_utility.set_location(' Leaving:' || l_proc,20);
538:
539: exception
540: when hr_multi_message.error_message_exist then
541: --

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

549: --
550: p_cert_enrollment_id := null;
551: p_certification_status_code := null;
552: p_return_status := hr_multi_message.get_return_status_disable;
553: hr_utility.set_location(' Leaving:' || l_proc, 30);
554:
555: when hr_api.validate_enabled then
556: --
557: -- As the Validate_Enabled exception has been raised

Line 568: hr_utility.set_location(' Leaving:'||l_proc, 80);

564: -- when validation only mode is being used.)
565: --
566: p_cert_enrollment_id := null;
567: p_certification_status_code := null;
568: hr_utility.set_location(' Leaving:'||l_proc, 80);
569: when others then
570: --
571: -- When Multiple Message Detection is enabled catch
572: -- any Application specific or other unexpected

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

575: -- error.
576: --
577: rollback to create_cert_subscription_swi;
578: if hr_multi_message.unexpected_error_add(l_proc) then
579: hr_utility.set_location(' Leaving:' || l_proc,40);
580: raise;
581: end if;
582: --
583: -- Reset IN OUT and set OUT parameters

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

584: --
585: p_cert_enrollment_id := null;
586: p_certification_status_code := null;
587: p_return_status := hr_multi_message.get_return_status_disable;
588: hr_utility.set_location(' Leaving:' || l_proc,50);
589: END subscribe_to_certification;
590:
591: end ota_cert_enrollment_swi;
592: