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_TPC_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_tpc_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_tpc_bus.g_training_plan_cost_id := p_training_plan_cost_id;
144: ota_tpc_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_ddf';
183: --
184: begin
185: hr_utility.set_location('Entering:'||l_proc,10);
186: --
187: if ((p_rec.training_plan_cost_id is not null) and (
188: nvl(ota_tpc_shd.g_old_rec.information_category, hr_api.g_varchar2) <>
189: nvl(p_rec.information_category, hr_api.g_varchar2) or

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

253: -- a) During update, the structure column value or any
254: -- of the attribute values have actually changed.
255: -- b) During insert.
256: --
257: hr_utility.set_location('Step:'||l_proc,20);
258: hr_dflex_utility.ins_or_upd_descflex_attribs
259: (p_appl_short_name => 'OTA'
260: ,p_descflex_name => 'Training Plan Costs Developer'
261: ,p_attribute_category => p_rec.information_category

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

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

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

359: --
360: l_proc varchar2(72) := g_package || 'chk_df';
361: --
362: begin
363: hr_utility.set_location('Entering:'||l_proc,10);
364: --
365: if ((p_rec.training_plan_cost_id is not null) and (
366: nvl(ota_tpc_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
367: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

Line 435: hr_utility.set_location(' Step :'|| l_proc,15);

431: -- a) During update, the structure column value or any
432: -- of the attribute values have actually changed.
433: -- b) During insert.
434: --
435: hr_utility.set_location(' Step :'|| l_proc,15);
436: hr_dflex_utility.ins_or_upd_descflex_attribs
437: (p_appl_short_name => 'OTA'
438: ,p_descflex_name => 'OTA_TRAINING_PLAN_COSTS'
439: ,p_attribute_category => p_rec.attribute_category

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

499: ,p_attribute30_value => p_rec.attribute30
500: );
501: end if;
502: --
503: hr_utility.set_location(' Leaving:'||l_proc,20);
504: end chk_df;
505: --
506: -- ----------------------------------------------------------------------------
507: -- |-----------------------< chk_non_updateable_args >------------------------|

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

553: fnd_message.set_token('STEP ', '5');
554: fnd_message.raise_error;
555: END IF;
556: --
557: hr_utility.set_location(' Step:'|| l_proc, 10);
558: if nvl(p_rec.business_group_id, hr_api.g_number) <>
559: nvl(ota_tpc_shd.g_old_rec.business_group_id, hr_api.g_number) then
560: l_argument := 'business_group_id';
561: raise l_error;

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

560: l_argument := 'business_group_id';
561: raise l_error;
562: end if;
563: --
564: hr_utility.set_location(' Step:'|| l_proc, 20);
565: if nvl(p_rec.tp_measurement_type_id, hr_api.g_number) <>
566: nvl(ota_tpc_shd.g_old_rec.tp_measurement_type_id, hr_api.g_number) then
567: l_argument := 'tp_measurement_type_id';
568: raise l_error;

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

567: l_argument := 'tp_measurement_type_id';
568: raise l_error;
569: end if;
570: --
571: hr_utility.set_location(' Step:'|| l_proc, 30);
572: if nvl(p_rec.training_plan_id, hr_api.g_number) <>
573: nvl(ota_tpc_shd.g_old_rec.training_plan_id, hr_api.g_number) then
574: l_argument := 'training_plan_id';
575: raise l_error;

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

574: l_argument := 'training_plan_id';
575: raise l_error;
576: end if;
577: --
578: hr_utility.set_location(' Step:'|| l_proc, 40);
579: if nvl(p_rec.booking_id, hr_api.g_number) <>
580: nvl(ota_tpc_shd.g_old_rec.booking_id, hr_api.g_number) then
581: l_argument := 'booking_id';
582: raise l_error;

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

581: l_argument := 'booking_id';
582: raise l_error;
583: end if;
584: --
585: hr_utility.set_location(' Step:'|| l_proc, 50);
586: if nvl(p_rec.event_id, hr_api.g_number) <>
587: nvl(ota_tpc_shd.g_old_rec.event_id, hr_api.g_number) then
588: l_argument := 'event_id';
589: raise l_error;

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

608: --
609: l_proc varchar2(72) := g_package||'insert_validate';
610: --
611: Begin
612: hr_utility.set_location('Entering:'||l_proc, 5);
613: --
614: -- Call all supporting business operations
615: --
616: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

614: -- Call all supporting business operations
615: --
616: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
617: --
618: hr_utility.set_location(' Step:'|| l_proc, 10);
619: ota_tpc_bus1.chk_tp_measurement_type_id(
620: p_tp_measurement_type_id => p_rec.tp_measurement_type_id
621: ,p_business_group_id => p_rec.business_group_id);
622: --

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

619: ota_tpc_bus1.chk_tp_measurement_type_id(
620: p_tp_measurement_type_id => p_rec.tp_measurement_type_id
621: ,p_business_group_id => p_rec.business_group_id);
622: --
623: hr_utility.set_location(' Step:'|| l_proc, 20);
624: ota_tpc_bus1.chk_training_plan_id (
625: p_training_plan_id => p_rec.training_plan_id
626: ,p_business_group_id => p_rec.business_group_id);
627: --

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

624: ota_tpc_bus1.chk_training_plan_id (
625: p_training_plan_id => p_rec.training_plan_id
626: ,p_business_group_id => p_rec.business_group_id);
627: --
628: hr_utility.set_location(' Step:'|| l_proc, 30);
629: ota_tpc_bus1.chk_booking_id (
630: p_booking_id => p_rec.booking_id
631: ,p_business_group_id => p_rec.business_group_id);
632: --

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

629: ota_tpc_bus1.chk_booking_id (
630: p_booking_id => p_rec.booking_id
631: ,p_business_group_id => p_rec.business_group_id);
632: --
633: hr_utility.set_location(' Step:'|| l_proc, 40);
634: ota_tpc_bus1.chk_event_id (
635: p_event_id => p_rec.event_id
636: ,p_training_plan_id => p_rec.training_plan_id
637: ,p_business_group_id => p_rec.business_group_id);

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

635: p_event_id => p_rec.event_id
636: ,p_training_plan_id => p_rec.training_plan_id
637: ,p_business_group_id => p_rec.business_group_id);
638: --
639: hr_utility.set_location(' Step:'|| l_proc, 50);
640: ota_tpc_bus1.chk_booking_event (
641: p_booking_id => p_rec.booking_id
642: ,p_event_id => p_rec.event_id
643: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id

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

642: ,p_event_id => p_rec.event_id
643: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id
644: ,p_business_group_id => p_rec.business_group_id);
645: --
646: hr_utility.set_location(' Step:'|| l_proc, 60);
647: ota_tpc_bus1.chk_unique (
648: p_event_id => p_rec.event_id
649: ,p_booking_id => p_rec.booking_id
650: ,p_training_plan_id => p_rec.training_plan_id

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

649: ,p_booking_id => p_rec.booking_id
650: ,p_training_plan_id => p_rec.training_plan_id
651: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id);
652: --
653: hr_utility.set_location(' Step:'|| l_proc, 70);
654: ota_tpc_bus1.chk_currency_value (
655: p_currency_code => p_rec.currency_code
656: ,p_training_plan_cost_id => p_rec.training_plan_cost_id
657: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id

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

663: ota_tpc_bus.chk_ddf(p_rec);
664: --
665: ota_tpc_bus.chk_df(p_rec);
666: --
667: hr_utility.set_location(' Leaving:'||l_proc, 10);
668: End insert_validate;
669: --
670: -- ----------------------------------------------------------------------------
671: -- |---------------------------< update_validate >----------------------------|

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

677: --
678: l_proc varchar2(72) := g_package||'update_validate';
679: --
680: Begin
681: hr_utility.set_location('Entering:'||l_proc, 5);
682: --
683: -- Call all supporting business operations
684: --
685: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp

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

688: (p_effective_date => p_effective_date
689: ,p_rec => p_rec
690: );
691: --
692: hr_utility.set_location(' Step:'|| l_proc, 10);
693: --
694: hr_utility.set_location(' Step:'|| l_proc, 20);
695: ota_tpc_bus1.chk_currency_value (
696: p_currency_code => p_rec.currency_code

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

690: );
691: --
692: hr_utility.set_location(' Step:'|| l_proc, 10);
693: --
694: hr_utility.set_location(' Step:'|| l_proc, 20);
695: ota_tpc_bus1.chk_currency_value (
696: p_currency_code => p_rec.currency_code
697: ,p_training_plan_cost_id => p_rec.training_plan_cost_id
698: ,p_tp_measurement_type_id => p_rec.tp_measurement_type_id

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

704: ota_tpc_bus.chk_ddf(p_rec);
705: --
706: ota_tpc_bus.chk_df(p_rec);
707: --
708: hr_utility.set_location(' Leaving:'||l_proc, 30);
709: End update_validate;
710: --
711: -- ----------------------------------------------------------------------------
712: -- |---------------------------< delete_validate >----------------------------|

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

717: --
718: l_proc varchar2(72) := g_package||'delete_validate';
719: --
720: Begin
721: hr_utility.set_location('Entering:'||l_proc, 5);
722: --
723: -- Call all supporting business operations
724: --
725: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

721: hr_utility.set_location('Entering:'||l_proc, 5);
722: --
723: -- Call all supporting business operations
724: --
725: hr_utility.set_location(' Leaving:'||l_proc, 10);
726: End delete_validate;
727: --
728: end ota_tpc_bus;