eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_CRE_BUS dependencies on HR_UTILITY

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

39: l_legislation_code varchar2(150);
40: --
41: begin
42: --
43: hr_utility.set_location('Entering:'|| l_proc, 10);
44: --
45: -- Ensure that all the mandatory parameter are not null
46: --
47: hr_api.mandatory_arg_error

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

79: --
80: hr_api.set_legislation_context(l_legislation_code);
81: end if;
82: --
83: hr_utility.set_location(' Leaving:'|| l_proc, 20);
84: --
85: end set_security_group_id;
86: --
87: -- ---------------------------------------------------------------------------

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

108: l_proc varchar2(72) := g_package||'return_legislation_code';
109: --
110: Begin
111: --
112: hr_utility.set_location('Entering:'|| l_proc, 10);
113: --
114: -- Ensure that all the mandatory parameter are not null
115: --
116: hr_api.mandatory_arg_error

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

126: -- call to this function. Just return the value in the global
127: -- variable.
128: --
129: l_legislation_code := ota_cre_bus.g_legislation_code;
130: hr_utility.set_location(l_proc, 20);
131: else
132: --
133: -- The ID is different to the last call to this function
134: -- or this is the first call to this function.

Line 147: hr_utility.set_location(l_proc,30);

143: close csr_leg_code;
144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
145: fnd_message.raise_error;
146: end if;
147: hr_utility.set_location(l_proc,30);
148: --
149: -- Set the global variables so the values are
150: -- available for the next call to this function.
151: --

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

152: close csr_leg_code;
153: ota_cre_bus.g_cert_enrollment_id := p_cert_enrollment_id;
154: ota_cre_bus.g_legislation_code := l_legislation_code;
155: end if;
156: hr_utility.set_location(' Leaving:'|| l_proc, 40);
157: return l_legislation_code;
158: end return_legislation_code;
159: --
160: -- ----------------------------------------------------------------------------

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

191: --
192: l_proc varchar2(72) := g_package || 'chk_df';
193: --
194: begin
195: hr_utility.set_location('Entering:'||l_proc,10);
196: --
197: if ((p_rec.cert_enrollment_id is not null) and (
198: nvl(ota_cre_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

290: ,p_attribute20_value => p_rec.attribute20
291: );
292: end if;
293: --
294: hr_utility.set_location(' Leaving:'||l_proc,20);
295: end chk_df;
296: --
297: -- ----------------------------------------------------------------------------
298: -- |-----------------------< chk_non_updateable_args >------------------------|

Line 362: hr_utility.set_location('Entering:'||l_proc, 5);

358: l_proc varchar2(72) := g_package||'chk_person_contact';
359:
360: --
361: Begin
362: hr_utility.set_location('Entering:'||l_proc, 5);
363: IF ( p_person_id IS NULL AND p_contact_id IS NULL) OR
364: ( p_person_id IS NOT NULL AND p_contact_id IS NOT NULL) THEN
365: fnd_message.set_name('OTA', 'OTA_13077_TPE_PRSN_OR_CNTCT');
366: fnd_message.raise_error;

Line 368: hr_utility.set_location('Leaving:'||l_proc, 10);

364: ( p_person_id IS NOT NULL AND p_contact_id IS NOT NULL) THEN
365: fnd_message.set_name('OTA', 'OTA_13077_TPE_PRSN_OR_CNTCT');
366: fnd_message.raise_error;
367: END IF;
368: hr_utility.set_location('Leaving:'||l_proc, 10);
369: End chk_person_contact;
370:
371: -- ----------------------------------------------------------------------------
372: -- |-----------------------------------------------------------|

Line 389: hr_utility.set_location(' Step:'|| l_proc, 20);

385: FROM PER_ALL_PEOPLE_F
386: WHERE person_id = p_person_id;
387: BEGIN
388: --
389: hr_utility.set_location(' Step:'|| l_proc, 20);
390:
391: IF p_person_id IS NOT NULL THEN
392: OPEN csr_person_id;
393: FETCH csr_person_id INTO l_exists;

Line 396: hr_utility.set_location(' Step:'|| l_proc, 40);

392: OPEN csr_person_id;
393: FETCH csr_person_id INTO l_exists;
394: IF csr_person_id%NOTFOUND THEN
395: CLOSE csr_person_id;
396: hr_utility.set_location(' Step:'|| l_proc, 40);
397: fnd_message.set_name('OTA', 'OTA_13884_NHS_PERSON_INVALID');
398: fnd_message.raise_error;
399: ELSE
400: CLOSE csr_person_id;

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

400: CLOSE csr_person_id;
401: END IF;
402: END IF;
403: --
404: hr_utility.set_location(' Leaving:'||l_proc, 50);
405:
406: --MULTI MESSAGE SUPPORT
407: EXCEPTION
408:

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

408:
409: WHEN app_exception.application_exception THEN
410: IF hr_multi_message.exception_add(
411: p_associated_column1 => 'OTA_CERT_ENROLLMENTS.PERSON_ID') THEN
412: hr_utility.set_location(' Leaving:'||l_proc, 52);
413: RAISE;
414:
415: END IF;
416: hr_utility.set_location(' Leaving:'||l_proc, 55);

Line 416: hr_utility.set_location(' Leaving:'||l_proc, 55);

412: hr_utility.set_location(' Leaving:'||l_proc, 52);
413: RAISE;
414:
415: END IF;
416: hr_utility.set_location(' Leaving:'||l_proc, 55);
417:
418: END chk_person_id;
419:
420: --

Line 436: hr_utility.set_location(' Step:'|| l_proc, 10);

432: BEGIN
433: --
434: -- check mandatory parameters have been set
435: --
436: hr_utility.set_location(' Step:'|| l_proc, 10);
437: hr_api.mandatory_arg_error
438: (p_api_name => l_proc
439: ,p_argument => 'p_certification_status_code'
440: ,p_argument_value => p_certification_status_code

Line 443: hr_utility.set_location(' Step:'|| l_proc, 20);

439: ,p_argument => 'p_certification_status_code'
440: ,p_argument_value => p_certification_status_code
441: );
442: --
443: hr_utility.set_location(' Step:'|| l_proc, 20);
444: IF hr_api.not_exists_in_hr_lookups
445: (p_effective_date => p_effective_date
446: ,p_lookup_type => 'OTA_CERT_ENROLL_STATUS'
447: ,p_lookup_code => p_certification_status_code

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

450: fnd_message.set_name('OTA', 'OTA_443665_CRE_STAT_INVALID');
451: fnd_message.raise_error;
452: END IF;
453: --
454: hr_utility.set_location(' Leaving:'||l_proc, 30);
455:
456: --MULTI MESSAGE SUPPORT
457: EXCEPTION
458: WHEN app_exception.application_exception THEN

Line 461: hr_utility.set_location(' Leaving:'||l_proc, 32);

457: EXCEPTION
458: WHEN app_exception.application_exception THEN
459: IF hr_multi_message.exception_add(
460: p_associated_column1 => 'OTA_CERT_ENROLLMENTS.CERTIFICATION_STATUS_CODE') THEN
461: hr_utility.set_location(' Leaving:'||l_proc, 32);
462: RAISE;
463:
464: END IF;
465: hr_utility.set_location(' Leaving:'||l_proc, 35);

Line 465: hr_utility.set_location(' Leaving:'||l_proc, 35);

461: hr_utility.set_location(' Leaving:'||l_proc, 32);
462: RAISE;
463:
464: END IF;
465: hr_utility.set_location(' Leaving:'||l_proc, 35);
466:
467: END chk_certification_status_code;
468:
469: --

Line 498: hr_utility.set_location(' Step:'|| l_proc, 10);

494: BEGIN
495: --
496: -- check mandatory parameters have been set
497: --
498: hr_utility.set_location(' Step:'|| l_proc, 10);
499: hr_api.mandatory_arg_error
500: (p_api_name => l_proc
501: ,p_argument => 'p_cert_enrollment_id'
502: ,p_argument_value => p_cert_enrollment_id

Line 511: hr_utility.set_location(' Step:'|| l_proc, 20);

507: OPEN csr_cert_prd_enr_id;
508: FETCH csr_cert_prd_enr_id INTO l_exists;
509: IF csr_cert_prd_enr_id%FOUND THEN
510: CLOSE csr_cert_prd_enr_id;
511: hr_utility.set_location(' Step:'|| l_proc, 20);
512: fnd_message.set_name('OTA', 'OTA_443818_NO_DEL_HAS_CHILD');
513: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', 'Certification Period Enrollment');
514: fnd_message.raise_error;
515: ELSE

Line 524: hr_utility.set_location(' Step:'|| l_proc, 30);

520: FETCH csr_cert_enr_status INTO l_cert_enroll_status;
521: IF csr_cert_enr_status%FOUND THEN
522: CLOSE csr_cert_enr_status;
523: IF l_cert_enroll_status= 'AWAITING_APPROVAL' then
524: hr_utility.set_location(' Step:'|| l_proc, 30);
525: fnd_message.set_name('OTA', 'OTA_443920_CRT_NO_DEL_APV_WAIT');
526: fnd_message.raise_error;
527: END IF;
528: ELSE

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

528: ELSE
529: CLOSE csr_cert_enr_status;
530: END IF;
531:
532: hr_utility.set_location(' Leaving:'||l_proc, 40);
533:
534: END chk_del_cert_enrollment_id;
535:
536: --

Line 574: hr_utility.set_location(' Step:'|| l_proc, 10);

570: BEGIN
571: --
572: -- check mandatory parameters have been set
573: --
574: hr_utility.set_location(' Step:'|| l_proc, 10);
575: hr_api.mandatory_arg_error
576: (p_api_name => l_proc
577: ,p_argument => 'p_certification_id'
578: ,p_argument_value => p_certification_id

Line 597: hr_utility.set_location(' Step:'|| l_proc, 10);

593: p_person_id => p_person_id
594: ,p_customer_id => NULL
595: ,p_contact_id => p_contact_id);
596:
597: hr_utility.set_location(' Step:'|| l_proc, 10);
598: fnd_message.set_name('OTA', 'OTA_443908_LRNR_DUPL_SUBSC_ERR');
599: fnd_message.set_token('LEARNER_NAME', l_person_name);
600: fnd_message.set_token('OBJECT_TYPE', l_object_type);
601: fnd_message.raise_error;

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

603: CLOSE csr_cert_enr_id;
604: END IF;
605:
606:
607: hr_utility.set_location(' Leaving:'||l_proc, 20);
608:
609: END check_duplicate_subscription;
610:
611: -- ----------------------------------------------------------------------------

Line 638: hr_utility.set_location(' Step:'|| l_proc, 10);

634: BEGIN
635: --
636: -- check mandatory parameters have been set
637: --
638: hr_utility.set_location(' Step:'|| l_proc, 10);
639: hr_api.mandatory_arg_error
640: (p_api_name => l_proc
641: ,p_argument => 'p_certification_id'
642: ,p_argument_value => p_certification_id

Line 654: hr_utility.set_location(' Step:'|| l_proc, 20);

650: CLOSE csr_crt;
651:
652: if (rec_crt.initial_completion_date is not null and trunc(sysdate) > rec_crt.initial_completion_date) then
653: --throw error for subscriptions beyond the due date.
654: hr_utility.set_location(' Step:'|| l_proc, 20);
655: fnd_message.set_name('OTA', 'OTA_443958_CRT_DUE_DATE_PASSED');
656: FND_MESSAGE.SET_TOKEN ('DUE_DATE', rec_crt.INITIAL_COMPLETION_DATE);
657: fnd_message.raise_error;
658: end if;

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

656: FND_MESSAGE.SET_TOKEN ('DUE_DATE', rec_crt.INITIAL_COMPLETION_DATE);
657: fnd_message.raise_error;
658: end if;
659:
660: hr_utility.set_location(' Leaving:'||l_proc, 20);
661:
662: END check_due_date_passed;
663: -- ----------------------------------------------------------------------------
664: -- |---------------------------< insert_validate >----------------------------|

Line 674: hr_utility.set_location('Entering:'||l_proc, 5);

670: --
671: l_proc varchar2(72) := g_package||'insert_validate';
672: --
673: Begin
674: hr_utility.set_location('Entering:'||l_proc, 5);
675: --
676: -- Call all supporting business operations
677: --
678: -- Validate Important Attributes

Line 712: hr_utility.set_location(' Leaving:'||l_proc, 10);

708: check_due_date_passed(p_certification_id => p_rec.certification_id);
709: --
710: ota_cre_bus.chk_df(p_rec);
711: --
712: hr_utility.set_location(' Leaving:'||l_proc, 10);
713: End insert_validate;
714: --
715: -- ----------------------------------------------------------------------------
716: -- |---------------------------< update_validate >----------------------------|

Line 726: hr_utility.set_location('Entering:'||l_proc, 5);

722: --
723: l_proc varchar2(72) := g_package||'update_validate';
724: --
725: Begin
726: hr_utility.set_location('Entering:'||l_proc, 5);
727: --
728: -- Call all supporting business operations
729: --
730: -- Validate Important Attributes

Line 764: hr_utility.set_location(' Leaving:'||l_proc, 10);

760: --
761: --
762: ota_cre_bus.chk_df(p_rec);
763: --
764: hr_utility.set_location(' Leaving:'||l_proc, 10);
765: End update_validate;
766: --
767: -- ----------------------------------------------------------------------------
768: -- |---------------------------< delete_validate >----------------------------|

Line 777: hr_utility.set_location('Entering:'||l_proc, 5);

773: --
774: l_proc varchar2(72) := g_package||'delete_validate';
775: --
776: Begin
777: hr_utility.set_location('Entering:'||l_proc, 5);
778: --
779: -- Call all supporting business operations
780:
781: chk_del_cert_enrollment_id(p_cert_enrollment_id => p_rec.cert_enrollment_id);

Line 784: hr_utility.set_location(' Leaving:'||l_proc, 10);

780:
781: chk_del_cert_enrollment_id(p_cert_enrollment_id => p_rec.cert_enrollment_id);
782:
783: --
784: hr_utility.set_location(' Leaving:'||l_proc, 10);
785: End delete_validate;
786: --
787: end ota_cre_bus;