[Home] [Help]
68: -- Other variables
69: l_certification_id number;
70: l_proc varchar2(72) := g_package ||'create_certification';
71: Begin
72: hr_utility.set_location(' Entering:' || l_proc,10);
73: --
74: -- Issue a savepoint
75: --
76: savepoint create_certification_swi;
164: -- messages of any type exist in the Multiple Message List.
165: -- Also disable Multiple Message Detection.
166: --
167: p_return_status := hr_multi_message.get_return_status_disable;
168: hr_utility.set_location(' Leaving:' || l_proc,20);
169: --
170: exception
171: when hr_multi_message.error_message_exist then
172: --
179: -- Reset IN OUT parameters and set OUT parameters
180: --
181: p_object_version_number := null;
182: p_return_status := hr_multi_message.get_return_status_disable;
183: hr_utility.set_location(' Leaving:' || l_proc, 30);
184: when others then
185: --
186: -- When Multiple Message Detection is enabled catch
187: -- any Application specific or other unexpected
190: -- error.
191: --
192: rollback to create_certification_swi;
193: if hr_multi_message.unexpected_error_add(l_proc) then
194: hr_utility.set_location(' Leaving:' || l_proc,40);
195: raise;
196: end if;
197: --
198: -- Reset IN OUT and set OUT parameters
198: -- Reset IN OUT and set OUT parameters
199: --
200: p_object_version_number := null;
201: p_return_status := hr_multi_message.get_return_status_disable;
202: hr_utility.set_location(' Leaving:' || l_proc,50);
203: end create_certification;
204: -- ----------------------------------------------------------------------------
205: -- |-------------------------< update_certification >-------------------------|
206: -- ----------------------------------------------------------------------------
264: --
265: -- Other variables
266: l_proc varchar2(72) := g_package ||'update_certification';
267: Begin
268: hr_utility.set_location(' Entering:' || l_proc,10);
269: --
270: -- Issue a savepoint
271: --
272: savepoint update_certification_swi;
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: --
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
386: -- error.
387: --
388: rollback to update_certification_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
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_certification;
400: -- ----------------------------------------------------------------------------
401: -- |-------------------------< delete_certification >-------------------------|
402: -- ----------------------------------------------------------------------------
414: --
415: -- Other variables
416: l_proc varchar2(72) := g_package ||'delete_certification';
417: Begin
418: hr_utility.set_location(' Entering:' || l_proc,10);
419: --
420: -- Issue a savepoint
421: --
422: savepoint delete_certification_swi;
456: -- messages of any type exist in the Multiple Message List.
457: -- Also disable Multiple Message Detection.
458: --
459: p_return_status := hr_multi_message.get_return_status_disable;
460: hr_utility.set_location(' Leaving:' || l_proc,20);
461: --
462: exception
463: when hr_multi_message.error_message_exist then
464: --
470: --
471: -- Reset IN OUT parameters and set OUT parameters
472: --
473: p_return_status := hr_multi_message.get_return_status_disable;
474: hr_utility.set_location(' Leaving:' || l_proc, 30);
475: when others then
476: --
477: -- When Multiple Message Detection is enabled catch
478: -- any Application specific or other unexpected
481: -- error.
482: --
483: rollback to delete_certification_swi;
484: if hr_multi_message.unexpected_error_add(l_proc) then
485: hr_utility.set_location(' Leaving:' || l_proc,40);
486: raise;
487: end if;
488: --
489: -- Reset IN OUT and set OUT parameters
488: --
489: -- Reset IN OUT and set OUT parameters
490: --
491: p_return_status := hr_multi_message.get_return_status_disable;
492: hr_utility.set_location(' Leaving:' || l_proc,50);
493: end delete_certification;
494:
495: -- ----------------------------------------------------------------------------
496: -- |-------------------------< check_crt_enrollments_exist >------------------------|
583: OPEN csr_name;
584: FETCH csr_name INTO l_exists;
585: IF csr_name%FOUND THEN
586: CLOSE csr_name;
587: hr_utility.set_location(' Step:'|| l_proc, 10);
588: fnd_message.set_name('OTA', 'OTA_443810_CERT_UNIQUE_NAME');
589: fnd_message.raise_error;
590: ELSE
591: CLOSE csr_name;
588: fnd_message.set_name('OTA', 'OTA_443810_CERT_UNIQUE_NAME');
589: fnd_message.raise_error;
590: ELSE
591: CLOSE csr_name;
592: hr_utility.set_location(' Step:'|| l_proc, 20);
593: END IF;
594:
595:
596:
600:
601: IF hr_multi_message.exception_add
602: (p_associated_column1 => 'OTA_CERTIFICATIONS_TL.NAME') THEN
603:
604: hr_utility.set_location(' Leaving:'||l_proc, 92);
605: RAISE;
606:
607: END IF;
608:
605: RAISE;
606:
607: END IF;
608:
609: hr_utility.set_location(' Leaving:'||l_proc, 94);
610:
611: END check_duplicate_name;
612:
613: