DBA Data[Home] [Help]

APPS.OTA_CERT_PRD_ENROLLMENT_SWI dependencies on HR_UTILITY

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

52: -- Other variables
53: l_cert_prd_enrollment_id number;
54: l_proc varchar2(72) := g_package ||'create_cert_prd_enrollment';
55: Begin
56: hr_utility.set_location(' Entering:' || l_proc,10);
57: --
58: -- Issue a savepoint
59: --
60: savepoint create_cert_prd_enrollment_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_prd_enrollment_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_cert_prd_enrollment;
166: -- ----------------------------------------------------------------------------
167: -- |----------------------< update_cert_prd_enrollment >----------------------|
168: -- ----------------------------------------------------------------------------

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

210: --
211: -- Other variables
212: l_proc varchar2(72) := g_package ||'update_cert_prd_enrollment';
213: Begin
214: hr_utility.set_location(' Entering:' || l_proc,10);
215: --
216: -- Issue a savepoint
217: --
218: savepoint update_cert_prd_enrollment_swi;

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

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

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

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

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

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

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

316: -- Reset IN OUT and set OUT parameters
317: --
318: p_object_version_number := l_object_version_number;
319: p_return_status := hr_multi_message.get_return_status_disable;
320: hr_utility.set_location(' Leaving:' || l_proc,50);
321: end update_cert_prd_enrollment;
322: -- ----------------------------------------------------------------------------
323: -- |----------------------< delete_cert_prd_enrollment >----------------------|
324: -- ----------------------------------------------------------------------------

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

336: --
337: -- Other variables
338: l_proc varchar2(72) := g_package ||'delete_cert_prd_enrollment';
339: Begin
340: hr_utility.set_location(' Entering:' || l_proc,10);
341: --
342: -- Issue a savepoint
343: --
344: savepoint delete_cert_prd_enrollment_swi;

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

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

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

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

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

403: -- error.
404: --
405: rollback to delete_cert_prd_enrollment_swi;
406: if hr_multi_message.unexpected_error_add(l_proc) then
407: hr_utility.set_location(' Leaving:' || l_proc,40);
408: raise;
409: end if;
410: --
411: -- Reset IN OUT and set OUT parameters

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

410: --
411: -- Reset IN OUT and set OUT parameters
412: --
413: p_return_status := hr_multi_message.get_return_status_disable;
414: hr_utility.set_location(' Leaving:' || l_proc,50);
415: end delete_cert_prd_enrollment;
416:
417: -- ----------------------------------------------------------------------------
418: -- |----------------------< renew_cert_prd_enrollment >----------------------|

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

453: -- messages of any type exist in the Multiple Message List.
454: -- Also disable Multiple Message Detection.
455: --
456: p_return_status := hr_multi_message.get_return_status_disable;
457: hr_utility.set_location(' Leaving:' || l_proc,20);
458:
459: exception
460: when hr_multi_message.error_message_exist then
461: --

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

469: --
470: p_cert_prd_enrollment_id := null;
471: p_certification_status_code := null;
472: p_return_status := hr_multi_message.get_return_status_disable;
473: hr_utility.set_location(' Leaving:' || l_proc, 30);
474:
475: when hr_api.validate_enabled then
476: --
477: -- As the Validate_Enabled exception has been raised

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

484: -- when validation only mode is being used.)
485: --
486: p_cert_prd_enrollment_id := null;
487: p_certification_status_code := null;
488: hr_utility.set_location(' Leaving:'||l_proc, 80);
489: when others then
490: --
491: -- When Multiple Message Detection is enabled catch
492: -- any Application specific or other unexpected

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

495: -- error.
496: --
497: rollback to renew_cert_prd_enrollment_swi;
498: if hr_multi_message.unexpected_error_add(l_proc) then
499: hr_utility.set_location(' Leaving:' || l_proc,40);
500: raise;
501: end if;
502: --
503: -- Reset IN OUT and set OUT parameters

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

504: --
505: p_cert_prd_enrollment_id := null;
506: p_certification_status_code := null;
507: p_return_status := hr_multi_message.get_return_status_disable;
508: hr_utility.set_location(' Leaving:' || l_proc,50);
509: END renew_cert_prd_enrollment;
510:
511: end ota_cert_prd_enrollment_swi;