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_TMT_BUS dependencies on HR_UTILITY

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

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

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

69: hr_api.set_security_group_id
70: (p_security_group_id => l_security_group_id
71: );
72: --
73: hr_utility.set_location(' Leaving:'|| l_proc, 20);
74: --
75: end set_security_group_id;
76: --
77: -- ---------------------------------------------------------------------------

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

98: l_proc varchar2(72) := g_package||'return_legislation_code';
99: --
100: Begin
101: --
102: hr_utility.set_location('Entering:'|| l_proc, 10);
103: --
104: -- Ensure that all the mandatory parameter are not null
105: --
106: hr_api.mandatory_arg_error

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

116: -- call to this function. Just return the value in the global
117: -- variable.
118: --
119: l_legislation_code := ota_tmt_bus.g_legislation_code;
120: hr_utility.set_location(l_proc, 20);
121: else
122: --
123: -- The ID is different to the last call to this function
124: -- or this is the first call to this function.

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

133: close csr_leg_code;
134: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
135: fnd_message.raise_error;
136: end if;
137: hr_utility.set_location(l_proc,30);
138: --
139: -- Set the global variables so the values are
140: -- available for the next call to this function.
141: --

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

142: close csr_leg_code;
143: ota_tmt_bus.g_tp_measurement_type_id := p_tp_measurement_type_id;
144: ota_tmt_bus.g_legislation_code := l_legislation_code;
145: end if;
146: hr_utility.set_location(' Leaving:'|| l_proc, 40);
147: return l_legislation_code;
148: end return_legislation_code;
149: --
150: -- ----------------------------------------------------------------------------

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

181: --
182: l_proc varchar2(72) := g_package || 'chk_df';
183: --
184: begin
185: hr_utility.set_location('Entering:'||l_proc,10);
186: --
187: if ((p_rec.tp_measurement_type_id is not null) and (
188: nvl(ota_tmt_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
189: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

320: ,p_attribute30_value => p_rec.attribute30
321: );
322: end if;
323: --
324: hr_utility.set_location(' Leaving:'||l_proc,20);
325: end chk_df;
326: --
327: -- ----------------------------------------------------------------------------
328: -- |-----------------------< chk_non_updateable_args >------------------------|

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

375: fnd_message.raise_error;
376: END IF;
377: --
378: --
379: hr_utility.set_location(' Step:'|| l_proc, 10);
380: if nvl(p_rec.business_group_id, hr_api.g_number) <>
381: nvl(ota_tmt_shd.g_old_rec.business_group_id, hr_api.g_number) then
382: l_argument := 'business_group_id';
383: raise l_error;

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

382: l_argument := 'business_group_id';
383: raise l_error;
384: end if;
385: --
386: hr_utility.set_location(' Step:'|| l_proc, 20);
387: if nvl(p_rec.tp_measurement_type_id, hr_api.g_number) <>
388: nvl(ota_tmt_shd.g_old_rec.tp_measurement_type_id, hr_api.g_number) then
389: l_argument := 'tp_measurement_type_id';
390: raise l_error;

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

389: l_argument := 'tp_measurement_type_id';
390: raise l_error;
391: end if;
392: --
393: hr_utility.set_location(' Step:'|| l_proc, 30);
394: if nvl(p_rec.tp_measurement_code, hr_api.g_varchar2) <>
395: nvl(ota_tmt_shd.g_old_rec.tp_measurement_code, hr_api.g_varchar2) then
396: l_argument := 'tp_measurement_code';
397: raise l_error;

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

421: l_proc varchar2(72) := g_package||'insert_validate';
422: l_legislation_code per_business_groups.legislation_code%TYPE;
423: --
424: Begin
425: hr_utility.set_location('Entering:'||l_proc, 5);
426: --
427: -- Call all supporting business operations
428: --
429: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

427: -- Call all supporting business operations
428: --
429: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
430: --
431: hr_utility.set_location(' Step:'|| l_proc, 10);
432: ota_tmt_bus1.chk_tp_measurement_code(
433: p_effective_date => p_effective_date
434: ,p_tp_measurement_code => p_rec.tp_measurement_code
435: ,p_business_group_id => p_rec.business_group_id);

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

433: p_effective_date => p_effective_date
434: ,p_tp_measurement_code => p_rec.tp_measurement_code
435: ,p_business_group_id => p_rec.business_group_id);
436: --
437: hr_utility.set_location(' Step:'|| l_proc, 20);
438: ota_tmt_bus1.chk_unit(
439: p_effective_date => p_effective_date
440: ,p_unit => p_rec.unit
441: ,p_business_group_id => p_rec.business_group_id

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

440: ,p_unit => p_rec.unit
441: ,p_business_group_id => p_rec.business_group_id
442: ,p_object_version_number => p_rec.object_version_number
443: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id);
444: hr_utility.set_location(' Step:'|| l_proc, 30);
445: ota_tmt_bus1.chk_budget_level(
446: p_effective_date => p_effective_date
447: ,p_business_group_id => p_rec.business_group_id
448: ,p_budget_level => p_rec.budget_level

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

448: ,p_budget_level => p_rec.budget_level
449: ,p_tp_measurement_code => p_rec.tp_measurement_code
450: ,p_object_version_number => p_rec.object_version_number
451: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id);
452: hr_utility.set_location(' Step:'|| l_proc, 40);
453: ota_tmt_bus1.chk_cost_level(
454: p_effective_date => p_effective_date
455: ,p_business_group_id => p_rec.business_group_id
456: ,p_cost_level => p_rec.cost_level

Line 459: hr_utility.set_location(' Step:'|| l_proc, 50);

455: ,p_business_group_id => p_rec.business_group_id
456: ,p_cost_level => p_rec.cost_level
457: ,p_object_version_number => p_rec.object_version_number
458: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id);
459: hr_utility.set_location(' Step:'|| l_proc, 50);
460: ota_tmt_bus1.chk_budget_cost_combination(
461: p_budget_level => p_rec.budget_level
462: ,p_cost_level => p_rec.cost_level
463: ,p_object_version_number => p_rec.object_version_number

Line 465: hr_utility.set_location(' Step:'|| l_proc, 60);

461: p_budget_level => p_rec.budget_level
462: ,p_cost_level => p_rec.cost_level
463: ,p_object_version_number => p_rec.object_version_number
464: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id);
465: hr_utility.set_location(' Step:'|| l_proc, 60);
466: ota_tmt_bus1.chk_many_budget_values_flag(
467: p_effective_date => p_effective_date
468: ,p_business_group_id => p_rec.business_group_id
469: ,p_many_budget_values_flag => p_rec.many_budget_values_flag

Line 473: hr_utility.set_location(' Step:'|| l_proc, 70);

469: ,p_many_budget_values_flag => p_rec.many_budget_values_flag
470: ,p_tp_measurement_code => p_rec.tp_measurement_code
471: ,p_object_version_number => p_rec.object_version_number
472: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id);
473: hr_utility.set_location(' Step:'|| l_proc, 70);
474: ota_tmt_bus1.chk_item_type_usage_id(
475: p_item_type_usage_id => p_rec.item_type_usage_id
476: ,p_business_group_id => p_rec.business_group_id
477: ,p_object_version_number => p_rec.object_version_number

Line 480: hr_utility.set_location(' Step:'|| l_proc, 80);

476: ,p_business_group_id => p_rec.business_group_id
477: ,p_object_version_number => p_rec.object_version_number
478: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id);
479: --
480: hr_utility.set_location(' Step:'|| l_proc, 80);
481: open csr_leg_code;
482: fetch csr_leg_code into l_legislation_code;
483: close csr_leg_code;
484: hr_utility.set_location(' Step:'|| l_proc, 90);

Line 484: hr_utility.set_location(' Step:'|| l_proc, 90);

480: hr_utility.set_location(' Step:'|| l_proc, 80);
481: open csr_leg_code;
482: fetch csr_leg_code into l_legislation_code;
483: close csr_leg_code;
484: hr_utility.set_location(' Step:'|| l_proc, 90);
485: ota_tmt_bus1.chk_legislative_setup(
486: p_legislation_code => l_legislation_code
487: ,p_tp_measurement_code => p_rec.tp_measurement_code
488: ,p_unit => p_rec.unit

Line 497: hr_utility.set_location(' Leaving:'||l_proc, 100);

493: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id);
494: --
495: ota_tmt_bus.chk_df(p_rec);
496: --
497: hr_utility.set_location(' Leaving:'||l_proc, 100);
498: End insert_validate;
499: --
500: -- ----------------------------------------------------------------------------
501: -- |---------------------------< update_validate >----------------------------|

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

512: l_legislation_code per_business_groups.legislation_code%TYPE;
513: l_proc varchar2(72) := g_package||'update_validate';
514: --
515: Begin
516: hr_utility.set_location('Entering:'||l_proc, 5);
517: --
518: -- Call all supporting business operations
519: --
520: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

522: chk_non_updateable_args(p_effective_date => p_effective_date
523: ,p_rec => p_rec);
524: --
525: --
526: hr_utility.set_location(' Step:'|| l_proc, 10);
527: ota_tmt_bus1.chk_unit(
528: p_effective_date => p_effective_date
529: ,p_unit => p_rec.unit
530: ,p_business_group_id => p_rec.business_group_id

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

529: ,p_unit => p_rec.unit
530: ,p_business_group_id => p_rec.business_group_id
531: ,p_object_version_number => p_rec.object_version_number
532: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id);
533: hr_utility.set_location(' Step:'|| l_proc, 20);
534: ota_tmt_bus1.chk_budget_level(
535: p_effective_date => p_effective_date
536: ,p_business_group_id => p_rec.business_group_id
537: ,p_budget_level => p_rec.budget_level

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

537: ,p_budget_level => p_rec.budget_level
538: ,p_tp_measurement_code => p_rec.tp_measurement_code
539: ,p_object_version_number => p_rec.object_version_number
540: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id);
541: hr_utility.set_location(' Step:'|| l_proc, 30);
542: ota_tmt_bus1.chk_cost_level(
543: p_effective_date => p_effective_date
544: ,p_business_group_id => p_rec.business_group_id
545: ,p_cost_level => p_rec.cost_level

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

544: ,p_business_group_id => p_rec.business_group_id
545: ,p_cost_level => p_rec.cost_level
546: ,p_object_version_number => p_rec.object_version_number
547: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id);
548: hr_utility.set_location(' Step:'|| l_proc, 40);
549: ota_tmt_bus1.chk_budget_cost_combination(
550: p_budget_level => p_rec.budget_level
551: ,p_cost_level => p_rec.cost_level
552: ,p_object_version_number => p_rec.object_version_number

Line 554: hr_utility.set_location(' Step:'|| l_proc, 50);

550: p_budget_level => p_rec.budget_level
551: ,p_cost_level => p_rec.cost_level
552: ,p_object_version_number => p_rec.object_version_number
553: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id);
554: hr_utility.set_location(' Step:'|| l_proc, 50);
555: ota_tmt_bus1.chk_many_budget_values_flag(
556: p_effective_date => p_effective_date
557: ,p_business_group_id => p_rec.business_group_id
558: ,p_many_budget_values_flag => p_rec.many_budget_values_flag

Line 562: hr_utility.set_location(' Step:'|| l_proc, 60);

558: ,p_many_budget_values_flag => p_rec.many_budget_values_flag
559: ,p_tp_measurement_code => p_rec.tp_measurement_code
560: ,p_object_version_number => p_rec.object_version_number
561: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id);
562: hr_utility.set_location(' Step:'|| l_proc, 60);
563: ota_tmt_bus1.chk_item_type_usage_id(
564: p_item_type_usage_id => p_rec.item_type_usage_id
565: ,p_business_group_id => p_rec.business_group_id
566: ,p_object_version_number => p_rec.object_version_number

Line 569: hr_utility.set_location(' Step:'|| l_proc, 70);

565: ,p_business_group_id => p_rec.business_group_id
566: ,p_object_version_number => p_rec.object_version_number
567: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id);
568: --
569: hr_utility.set_location(' Step:'|| l_proc, 70);
570: open csr_leg_code;
571: fetch csr_leg_code into l_legislation_code;
572: close csr_leg_code;
573: hr_utility.set_location(' Step:'|| l_proc, 80);

Line 573: hr_utility.set_location(' Step:'|| l_proc, 80);

569: hr_utility.set_location(' Step:'|| l_proc, 70);
570: open csr_leg_code;
571: fetch csr_leg_code into l_legislation_code;
572: close csr_leg_code;
573: hr_utility.set_location(' Step:'|| l_proc, 80);
574: ota_tmt_bus1.chk_legislative_setup(
575: p_legislation_code => l_legislation_code
576: ,p_tp_measurement_code => p_rec.tp_measurement_code
577: ,p_unit => p_rec.unit

Line 586: hr_utility.set_location(' Leaving:'||l_proc, 90);

582: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id);
583: --
584: ota_tmt_bus.chk_df(p_rec);
585: --
586: hr_utility.set_location(' Leaving:'||l_proc, 90);
587: End update_validate;
588: --
589: -- ----------------------------------------------------------------------------
590: -- |---------------------------< delete_validate >----------------------------|

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

595: --
596: l_proc varchar2(72) := g_package||'delete_validate';
597: --
598: Begin
599: hr_utility.set_location('Entering:'||l_proc, 5);
600: --
601: -- Call all supporting business operations
602: --
603: hr_utility.set_location(' Step:'|| l_proc, 10);

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

599: hr_utility.set_location('Entering:'||l_proc, 5);
600: --
601: -- Call all supporting business operations
602: --
603: hr_utility.set_location(' Step:'|| l_proc, 10);
604: ota_tmt_bus1.chk_del_tp_measurement_code(
605: p_tp_measurement_code => ota_tmt_shd.g_old_rec.tp_measurement_code
606: ,p_tp_measurement_type_id => ota_tmt_shd.g_old_rec.tp_measurement_type_id
607: ,p_business_group_id => ota_tmt_shd.g_old_rec.business_group_id);

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

604: ota_tmt_bus1.chk_del_tp_measurement_code(
605: p_tp_measurement_code => ota_tmt_shd.g_old_rec.tp_measurement_code
606: ,p_tp_measurement_type_id => ota_tmt_shd.g_old_rec.tp_measurement_type_id
607: ,p_business_group_id => ota_tmt_shd.g_old_rec.business_group_id);
608: hr_utility.set_location(' Step:'|| l_proc, 20);
609: ota_tmt_bus1.chk_del_tp_measurement_type_id(
610: p_tp_measurement_type_id => ota_tmt_shd.g_old_rec.tp_measurement_type_id);
611: hr_utility.set_location(' Leaving:'||l_proc, 10);
612: End delete_validate;

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

607: ,p_business_group_id => ota_tmt_shd.g_old_rec.business_group_id);
608: hr_utility.set_location(' Step:'|| l_proc, 20);
609: ota_tmt_bus1.chk_del_tp_measurement_type_id(
610: p_tp_measurement_type_id => ota_tmt_shd.g_old_rec.tp_measurement_type_id);
611: hr_utility.set_location(' Leaving:'||l_proc, 10);
612: End delete_validate;
613: --
614: end ota_tmt_bus;