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_LME_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_lme_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_lme_bus.g_lp_member_enrollment_id := p_lp_member_enrollment_id;
154: ota_lme_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_member_enrollment_id is not null) and (
198: nvl(ota_lme_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
199: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

335: ,p_attribute30_value => p_rec.attribute30
336: );
337: end if;
338: --
339: hr_utility.set_location(' Leaving:'||l_proc,20);
340: end chk_df;
341: --
342: -- ----------------------------------------------------------------------------
343: -- |-----------------------< chk_non_updateable_args >------------------------|

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

406: l_proc VARCHAR2(72) := g_package||'chk_member_status_code';
407: l_api_updating boolean;
408:
409: BEGIN
410: hr_utility.set_location(' Leaving:'||l_proc, 10);
411: --
412: -- check mandatory parameters has been set
413: --
414: hr_api.mandatory_arg_error

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

425: NVL(ota_lme_shd.g_old_rec.member_status_code,hr_api.g_varchar2) <>
426: NVL(p_member_status_code, hr_api.g_varchar2))
427: OR NOT l_api_updating AND p_member_status_code IS NOT NULL) THEN
428:
429: hr_utility.set_location(' Leaving:'||l_proc, 20);
430: --
431:
432: IF p_member_status_code IS NOT NULL THEN
433: IF hr_api.not_exists_in_hr_lookups

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

436: ,p_lookup_code => p_member_status_code) THEN
437: fnd_message.set_name('OTA','OTA_13843_TPM_BAD_STATUS');
438: fnd_message.raise_error;
439: END IF;
440: hr_utility.set_location(' Leaving:'||l_proc, 30);
441:
442: END IF;
443:
444: END IF;

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

441:
442: END IF;
443:
444: END IF;
445: hr_utility.set_location(' Leaving:'||l_proc, 40);
446:
447: EXCEPTION
448:
449: WHEN app_exception.application_exception THEN

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

450:
451: IF hr_multi_message.exception_add
452: (p_associated_column1 => 'OTA_LP_MEMBER_ENROLLMENTS.MEMBER_STATUS_CODE') THEN
453:
454: hr_utility.set_location(' Leaving:'||l_proc, 42);
455: RAISE;
456: END IF;
457:
458: hr_utility.set_location(' Leaving:'||l_proc, 44);

Line 458: hr_utility.set_location(' Leaving:'||l_proc, 44);

454: hr_utility.set_location(' Leaving:'||l_proc, 42);
455: RAISE;
456: END IF;
457:
458: hr_utility.set_location(' Leaving:'||l_proc, 44);
459:
460: END chk_member_status_code;
461: --
462: -- ----------------------------------------------------------------------------

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

481: BEGIN
482: --
483: -- check mandatory parameters have been set
484: --
485: hr_utility.set_location('Entering:'||l_proc, 5);
486: hr_api.mandatory_arg_error
487: (p_api_name => l_proc
488: ,p_argument => 'p_lp_enrollment_id'
489: ,p_argument_value => p_lp_enrollment_id

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

491: --
492: OPEN csr_get_path_source;
493: FETCH csr_get_path_source INTO l_path_source_code;
494: CLOSE csr_get_path_source;
495: hr_utility.set_location(' Leaving:'||l_proc, 20);
496: --
497: RETURN l_path_source_code;
498: END get_path_source_code;
499: --

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

507: --
508: l_proc varchar2(72) := g_package||'insert_validate';
509: --
510: Begin
511: hr_utility.set_location('Entering:'||l_proc, 5);
512: --
513: -- Call all supporting business operations
514: --
515: hr_api.validate_bus_grp_id

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

529: IF get_path_source_code(p_rec.lp_enrollment_id) NOT IN ('CATALOG', 'TALENT_MGMT') THEN
530: ota_lme_bus.chk_df(p_rec);
531: END IF;
532: --
533: hr_utility.set_location(' Leaving:'||l_proc, 10);
534: End insert_validate;
535: --
536: -- ----------------------------------------------------------------------------
537: -- |---------------------------< update_validate >----------------------------|

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

543: --
544: l_proc varchar2(72) := g_package||'update_validate';
545: --
546: Begin
547: hr_utility.set_location('Entering:'||l_proc, 5);
548: --
549: -- Call all supporting business operations
550: --
551: hr_api.validate_bus_grp_id

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

570: IF get_path_source_code(p_rec.lp_enrollment_id) NOT IN ('CATALOG', 'TALENT_MGMT') THEN
571: ota_lme_bus.chk_df(p_rec);
572: END IF;
573: --
574: hr_utility.set_location(' Leaving:'||l_proc, 10);
575: End update_validate;
576: --
577: -- ----------------------------------------------------------------------------
578: -- |---------------------------< delete_validate >----------------------------|

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

583: --
584: l_proc varchar2(72) := g_package||'delete_validate';
585: --
586: Begin
587: hr_utility.set_location('Entering:'||l_proc, 5);
588: --
589: -- Call all supporting business operations
590: --
591: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

587: hr_utility.set_location('Entering:'||l_proc, 5);
588: --
589: -- Call all supporting business operations
590: --
591: hr_utility.set_location(' Leaving:'||l_proc, 10);
592: End delete_validate;
593: --
594: end ota_lme_bus;