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_LPE_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_lpe_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_lpe_bus.g_lp_enrollment_id := p_lp_enrollment_id;
154: ota_lpe_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.lp_enrollment_id is not null) and (
198: nvl(ota_lpe_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

330: ,p_attribute30_value => p_rec.attribute30
331: );
332: end if;
333: --
334: hr_utility.set_location(' Leaving:'||l_proc,20);
335: end chk_df;
336: --
337: -- ----------------------------------------------------------------------------
338: -- |-----------------------< chk_non_updateable_args >------------------------|

Line 412: hr_utility.set_location('Entering:'|| v_proc, 5);

408: where lps.learning_path_id = p_learning_path_id;
409: --
410: Begin
411: --
412: hr_utility.set_location('Entering:'|| v_proc, 5);
413: --
414: Open csr_is_catalog_lp;
415: fetch csr_is_catalog_lp into l_path_source_code;
416: close csr_is_catalog_lp;

Line 418: hr_utility.set_location(' Leaving:'|| v_proc, 10);

414: Open csr_is_catalog_lp;
415: fetch csr_is_catalog_lp into l_path_source_code;
416: close csr_is_catalog_lp;
417: --
418: hr_utility.set_location(' Leaving:'|| v_proc, 10);
419: --
420: RETURN l_path_source_code;
421:
422: End get_path_source_code;

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

431: l_proc varchar2(72) := g_package||'chk_person_contact';
432:
433: --
434: Begin
435: hr_utility.set_location('Entering:'||l_proc, 5);
436: IF ( p_person_id IS NULL AND p_contact_id IS NULL) OR
437: ( p_person_id IS NOT NULL AND p_contact_id IS NOT NULL) THEN
438: fnd_message.set_name('OTA', 'OTA_13077_TPE_PRSN_OR_CNTCT');
439: fnd_message.raise_error;

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

437: ( p_person_id IS NOT NULL AND p_contact_id IS NOT NULL) THEN
438: fnd_message.set_name('OTA', 'OTA_13077_TPE_PRSN_OR_CNTCT');
439: fnd_message.raise_error;
440: END IF;
441: hr_utility.set_location('Leaving:'||l_proc, 10);
442: End chk_person_contact;
443:
444: -- ----------------------------------------------------------------------------
445: -- |-----------------------------------------------------------|

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

458: FROM PER_ALL_PEOPLE_F
459: WHERE person_id = p_person_id;
460: BEGIN
461: --
462: hr_utility.set_location(' Step:'|| l_proc, 20);
463:
464: IF p_person_id IS NOT NULL THEN
465: OPEN csr_person_id;
466: FETCH csr_person_id INTO l_exists;

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

465: OPEN csr_person_id;
466: FETCH csr_person_id INTO l_exists;
467: IF csr_person_id%NOTFOUND THEN
468: CLOSE csr_person_id;
469: hr_utility.set_location(' Step:'|| l_proc, 40);
470: fnd_message.set_name('OTA', 'OTA_13884_NHS_PERSON_INVALID');
471: fnd_message.raise_error;
472: ELSE
473: CLOSE csr_person_id;

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

473: CLOSE csr_person_id;
474: END IF;
475: END IF;
476: --
477: hr_utility.set_location(' Leaving:'||l_proc, 50);
478:
479: --MULTI MESSAGE SUPPORT
480: EXCEPTION
481:

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

481:
482: WHEN app_exception.application_exception THEN
483: IF hr_multi_message.exception_add(
484: p_associated_column1 => 'OTA_LP_ENROLLMENTS.PERSON_ID') THEN
485: hr_utility.set_location(' Leaving:'||l_proc, 52);
486: RAISE;
487:
488: END IF;
489: hr_utility.set_location(' Leaving:'||l_proc, 55);

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

485: hr_utility.set_location(' Leaving:'||l_proc, 52);
486: RAISE;
487:
488: END IF;
489: hr_utility.set_location(' Leaving:'||l_proc, 55);
490:
491: END chk_person_id;
492:
493: -- ----------------------------------------------------------------------------

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

504: BEGIN
505: --
506: -- check mandatory parameters have been set
507: --
508: hr_utility.set_location(' Step:'|| l_proc, 10);
509: hr_api.mandatory_arg_error
510: (p_api_name => l_proc
511: ,p_argument => 'p_path_status_code'
512: ,p_argument_value => p_path_status_code

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

511: ,p_argument => 'p_path_status_code'
512: ,p_argument_value => p_path_status_code
513: );
514: --
515: hr_utility.set_location(' Step:'|| l_proc, 20);
516: IF hr_api.not_exists_in_hr_lookups
517: (p_effective_date => p_effective_date
518: ,p_lookup_type => 'OTA_LEARNING_PATH_STATUS'
519: ,p_lookup_code => p_path_status_code

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

522: fnd_message.set_name('OTA', 'OTA_13864_TPS_BAD_PLAN_STATUS');
523: fnd_message.raise_error;
524: END IF;
525: --
526: hr_utility.set_location(' Leaving:'||l_proc, 30);
527:
528: --MULTI MESSAGE SUPPORT
529: EXCEPTION
530: WHEN app_exception.application_exception THEN

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

529: EXCEPTION
530: WHEN app_exception.application_exception THEN
531: IF hr_multi_message.exception_add(
532: p_associated_column1 => 'OTA_LP_ENROLLMENTS.PATH_STATUS_CODE') THEN
533: hr_utility.set_location(' Leaving:'||l_proc, 32);
534: RAISE;
535:
536: END IF;
537: hr_utility.set_location(' Leaving:'||l_proc, 35);

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

533: hr_utility.set_location(' Leaving:'||l_proc, 32);
534: RAISE;
535:
536: END IF;
537: hr_utility.set_location(' Leaving:'||l_proc, 35);
538:
539: END chk_path_status_code;
540: --
541: -- ----------------------------------------------------------------------------

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

552: BEGIN
553: --
554: -- check mandatory parameters have been set
555: --
556: hr_utility.set_location(' Step:'|| l_proc, 10);
557: hr_api.mandatory_arg_error
558: (p_api_name => l_proc
559: ,p_argument => 'p_enrollment_source_code'
560: ,p_argument_value => p_enrollment_source_code

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

559: ,p_argument => 'p_enrollment_source_code'
560: ,p_argument_value => p_enrollment_source_code
561: );
562: --
563: hr_utility.set_location(' Step:'|| l_proc, 20);
564: IF hr_api.not_exists_in_hr_lookups
565: (p_effective_date => p_effective_date
566: ,p_lookup_type => 'OTA_TRAINING_PLAN_SOURCE'
567: ,p_lookup_code => p_enrollment_source_code

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

570: fnd_message.set_name('OTA', 'OTA_13176_TPM_PLN_SRC_INVLD');
571: fnd_message.raise_error;
572: END IF;
573: --
574: hr_utility.set_location(' Leaving:'||l_proc, 30);
575:
576: --MULTI MESSAGE SUPPORT
577: EXCEPTION
578: WHEN app_exception.application_exception THEN

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

577: EXCEPTION
578: WHEN app_exception.application_exception THEN
579: IF hr_multi_message.exception_add(
580: p_associated_column1 => 'OTA_LP_ENROLLMENTS.ENROLLMENT_SOURCE_CODE') THEN
581: hr_utility.set_location(' Leaving:'||l_proc, 32);
582: RAISE;
583:
584: END IF;
585: hr_utility.set_location(' Leaving:'||l_proc, 35);

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

581: hr_utility.set_location(' Leaving:'||l_proc, 32);
582: RAISE;
583:
584: END IF;
585: hr_utility.set_location(' Leaving:'||l_proc, 35);
586:
587: END chk_enrollment_source_code;
588: --
589: --

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

606: BEGIN
607: --
608: -- check mandatory parameters have been set
609: --
610: hr_utility.set_location(' Step:'|| l_proc, 10);
611: hr_api.mandatory_arg_error
612: (p_api_name => l_proc
613: ,p_argument => 'p_lp_enrollment_id'
614: ,p_argument_value => p_lp_enrollment_id

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

619: OPEN csr_lp_enr_id;
620: FETCH csr_lp_enr_id INTO l_exists;
621: IF csr_lp_enr_id%FOUND THEN
622: CLOSE csr_lp_enr_id;
623: hr_utility.set_location(' Step:'|| l_proc, 10);
624: fnd_message.set_name('OTA', 'OTA_13078_LPS_LPM_EXIST');
625: fnd_message.raise_error;
626: ELSE
627: CLOSE csr_lp_enr_id;

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

627: CLOSE csr_lp_enr_id;
628: END IF;
629:
630:
631: hr_utility.set_location(' Leaving:'||l_proc, 20);
632:
633: END chk_del_lp_enrollment_id;
634:
635: --

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

668: BEGIN
669: --
670: -- check mandatory parameters have been set
671: --
672: hr_utility.set_location(' Step:'|| l_proc, 10);
673: hr_api.mandatory_arg_error
674: (p_api_name => l_proc
675: ,p_argument => 'p_learning_path_id'
676: ,p_argument_value => p_learning_path_id

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

691: p_person_id => p_person_id
692: ,p_customer_id => NULL
693: ,p_contact_id => p_contact_id);
694:
695: hr_utility.set_location(' Step:'|| l_proc, 10);
696: fnd_message.set_name('OTA', 'OTA_443908_LRNR_DUPL_SUBSC_ERR');
697: fnd_message.set_token('LEARNER_NAME', l_person_name);
698: fnd_message.set_token('OBJECT_TYPE', l_object_type);
699: fnd_message.raise_error;

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

701: CLOSE csr_lp_enr_id;
702: END IF;
703:
704:
705: hr_utility.set_location(' Leaving:'||l_proc, 20);
706:
707: END check_duplicate_subscription;
708: -- ----------------------------------------------------------------------------
709: -- |-------------------------------------------------------|

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

715: --
716: l_proc varchar2(72) := g_package||'insert_validate';
717: --
718: Begin
719: hr_utility.set_location('Entering:'||l_proc, 5);
720: --
721: -- Call all supporting business operations
722: --
723: hr_api.validate_bus_grp_id

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

753: ota_lpe_bus.chk_df(p_rec);
754: END IF;
755:
756: --
757: hr_utility.set_location(' Leaving:'||l_proc, 10);
758: End insert_validate;
759: --
760: -- ----------------------------------------------------------------------------
761: -- |---------------------------< update_validate >----------------------------|

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

767: --
768: l_proc varchar2(72) := g_package||'update_validate';
769: --
770: Begin
771: hr_utility.set_location('Entering:'||l_proc, 5);
772: --
773: -- Call all supporting business operations
774: --
775: hr_api.validate_bus_grp_id

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

806: IF get_path_source_code(p_rec.learning_path_id) NOT IN ('CATALOG', 'TALENT_MGMT') THEN
807: ota_lpe_bus.chk_df(p_rec);
808: END IF;
809: --
810: hr_utility.set_location(' Leaving:'||l_proc, 10);
811: End update_validate;
812: --
813: -- ----------------------------------------------------------------------------
814: -- |---------------------------< delete_validate >----------------------------|

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

819: --
820: l_proc varchar2(72) := g_package||'delete_validate';
821: --
822: Begin
823: hr_utility.set_location('Entering:'||l_proc, 5);
824: --
825: -- Call all supporting business operations
826: --
827: chk_del_lp_enrollment_id(p_lp_enrollment_id => p_rec.lp_enrollment_id);

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

825: -- Call all supporting business operations
826: --
827: chk_del_lp_enrollment_id(p_lp_enrollment_id => p_rec.lp_enrollment_id);
828:
829: hr_utility.set_location(' Leaving:'||l_proc, 10);
830: End delete_validate;
831: --
832: end ota_lpe_bus;