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

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

64: l_legislation_code varchar2(150);
65: --
66: begin
67: --
68: hr_utility.set_location('Entering:'|| l_proc, 10);
69: --
70: -- Ensure that all the mandatory parameter are not null
71: --
72: hr_api.mandatory_arg_error

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

104: --
105: hr_api.set_legislation_context(l_legislation_code);
106: end if;
107: --
108: hr_utility.set_location(' Leaving:'|| l_proc, 20);
109: --
110: end set_security_group_id;
111: --
112: -- added for bug#4310348 by jbharath

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

120: l_proc varchar2(72) := g_package||'constraint_error2';
121: --
122: Begin
123: --
124: hr_utility.set_location('Entering:'||l_proc, 5);
125: --
126: if p_constraint_name = 'startdate_is_mandatory' then
127: fnd_message.set_name('OTA','OTA_13457_GEN_MAND_START_DATE');
128: elsif p_constraint_name = 'end_precedes_start' then

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

185: End If;
186: --
187: fnd_message.raise_error;
188: --
189: hr_utility.set_location(' Leaving:'||l_proc, 10);
190:
191: End constraint_error2;
192: --======================================================================
193: --======================================================================

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

367: end chkp;
368: ---------------
369: Begin
370: --
371: hr_utility.set_location('Entering:'||l_proc, 5);
372: --
373: l_api_updating := OTA_TSR_SHD.api_updating (
374: p_supplied_resource_id => p_tsr_id,
375: p_object_version_number => p_ovn );

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

379: if OTA_TSR_SHD.g_old_rec.resource_type <> p_resource_type then
380: constraint_error2('resource_type_is_not_updatable');
381: end if;
382: --
383: hr_utility.set_location(' Leaving:'||l_proc, 10);
384: --
385: End check_type_update;
386: --
387: -- ----------------------------------------------------------------------------

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

405: l_proc varchar2(72) := g_package||'check_usage_dates';
406: l_dummy varchar2(1);
407: --
408: Begin
409: hr_utility.set_location('Entering:'||l_proc, 5);
410: --
411: open c_invalid_usage;
412: fetch c_invalid_usage into l_dummy;
413: if c_invalid_usage%found then

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

419: end if;
420: --
421: close c_invalid_usage;
422: --
423: hr_utility.set_location(' Leaving:'||l_proc, 10);
424: End check_usage_dates;
425: --
426: -- ----------------------------------------------------------------------------
427: -- |--------------------------< check_booking_dates >-------------------------|

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

442: l_proc varchar2(72) := g_package||'check_booking_dates';
443: l_dummy varchar2(1);
444: --
445: Begin
446: hr_utility.set_location('Entering:'||l_proc, 5);
447: --
448: open c_invalid_bookings;
449: fetch c_invalid_bookings into l_dummy;
450: --

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

454: end if;
455: --
456: close c_invalid_bookings;
457: --
458: hr_utility.set_location(' Leaving:'||l_proc, 10);
459: End check_booking_dates;
460: --**************************************************************
461: --**************************************************************
462: procedure check_tsr_new_dates

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

566: l_proc varchar2(72) := g_package||'check_bookings';
567: l_dummy varchar2(1);
568: --
569: Begin
570: hr_utility.set_location('Entering:'||l_proc, 5);
571: --
572: open c_bookings;
573: fetch c_bookings into l_dummy;
574: --

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

578: end if;
579: --
580: close c_bookings;
581: --
582: hr_utility.set_location(' Leaving:'||l_proc, 10);
583: End del_check_bookings;
584: --
585: -- ----------------------------------------------------------------------------
586: -- |--------------------------< check_usages >------------------------------|

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

598: l_proc varchar2(72) := g_package||'check_usages';
599: l_dummy varchar2(1);
600: --
601: Begin
602: hr_utility.set_location('Entering:'||l_proc, 5);
603: --
604: open c_usages;
605: fetch c_usages into l_dummy;
606: --

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

610: end if;
611: --
612: close c_usages;
613: --
614: hr_utility.set_location(' Leaving:'||l_proc, 10);
615: End del_check_usages;
616:
617: /** Added for globalization **/
618: -- ----------------------------------------------------------------------------

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

638: From HR_ALL_ORGANIZATION_UNITS
639: Where organization_id = p_training_center_id;
640:
641: Begin
642: hr_utility.set_location('Entering:'||l_proc, 5);
643: if (((p_supplied_resource_id is not null) and
644: nvl(ota_tsr_shd.g_old_rec.training_center_id,hr_api.g_number) <>
645: nvl(p_training_center_id,hr_api.g_number))
646: or (p_supplied_resource_id is null)) then

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

644: nvl(ota_tsr_shd.g_old_rec.training_center_id,hr_api.g_number) <>
645: nvl(p_training_center_id,hr_api.g_number))
646: or (p_supplied_resource_id is null)) then
647: --
648: hr_utility.set_location('Entering:'||l_proc, 10);
649: if (p_training_center_id is not null) then
650: hr_utility.set_location('Entering:'||l_proc, 15);
651: open c_training_center;
652: fetch c_training_center into l_exists;

Line 650: hr_utility.set_location('Entering:'||l_proc, 15);

646: or (p_supplied_resource_id is null)) then
647: --
648: hr_utility.set_location('Entering:'||l_proc, 10);
649: if (p_training_center_id is not null) then
650: hr_utility.set_location('Entering:'||l_proc, 15);
651: open c_training_center;
652: fetch c_training_center into l_exists;
653: if c_training_center%notfound then
654: close c_training_center;

Line 659: hr_utility.set_location('Entering:'||l_proc, 20);

655: fnd_message.set_name('OTA','OTA_13907_TSR_TRNCTR_NOT_EXIST');
656: fnd_message.raise_error;
657: end if;
658: close c_training_center;
659: hr_utility.set_location('Entering:'||l_proc, 20);
660: end if;
661: end if;
662: hr_utility.set_location('Entering:'||l_proc, 30);
663:

Line 662: hr_utility.set_location('Entering:'||l_proc, 30);

658: close c_training_center;
659: hr_utility.set_location('Entering:'||l_proc, 20);
660: end if;
661: end if;
662: hr_utility.set_location('Entering:'||l_proc, 30);
663:
664: end;
665:
666: -- ----------------------------------------------------------------------------

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

687: From HR_LOCATIONS_ALL loc
688: Where loc.location_id = p_location_id ;
689:
690: Begin
691: hr_utility.set_location('Entering:'||l_proc, 5);
692:
693: if (((p_supplied_resource_id is not null) and
694: nvl(ota_tsr_shd.g_old_rec.location_id,hr_api.g_number) <>
695: nvl(p_location_id,hr_api.g_number))

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

694: nvl(ota_tsr_shd.g_old_rec.location_id,hr_api.g_number) <>
695: nvl(p_location_id,hr_api.g_number))
696: or (p_supplied_resource_id is null)) then
697: --
698: hr_utility.set_location('Entering:'||l_proc, 10);
699: if (p_location_id is not null) then
700: hr_utility.set_location('Entering:'||l_proc, 15);
701: open c_location;
702: fetch c_location into l_exists;

Line 700: hr_utility.set_location('Entering:'||l_proc, 15);

696: or (p_supplied_resource_id is null)) then
697: --
698: hr_utility.set_location('Entering:'||l_proc, 10);
699: if (p_location_id is not null) then
700: hr_utility.set_location('Entering:'||l_proc, 15);
701: open c_location;
702: fetch c_location into l_exists;
703: if c_location%notfound then
704: close c_location;

Line 709: hr_utility.set_location('Entering:'||l_proc, 20);

705: fnd_message.set_name('OTA','OTA_13908_TSR_LOC_NOT_EXIST');
706: fnd_message.raise_error;
707: end if;
708: close c_location;
709: hr_utility.set_location('Entering:'||l_proc, 20);
710: end if;
711: end if;
712: hr_utility.set_location('Entering:'||l_proc, 30);
713:

Line 712: hr_utility.set_location('Entering:'||l_proc, 30);

708: close c_location;
709: hr_utility.set_location('Entering:'||l_proc, 20);
710: end if;
711: end if;
712: hr_utility.set_location('Entering:'||l_proc, 30);
713:
714: end;
715:
716: -- ----------------------------------------------------------------------------

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

780:
781: --Bug 1991061
782:
783: Begin
784: hr_utility.set_location('Entering:'||l_proc, 5);
785:
786: if (((p_supplied_resource_id is not null) and
787: nvl(ota_tsr_shd.g_old_rec.trainer_id,hr_api.g_number) <>
788: nvl(p_trainer_id,hr_api.g_number))

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

792: nvl(ota_tsr_shd.g_old_rec.end_date, hr_api.g_date) <>
793: nvl(p_end_date, hr_api.g_date)
794: then
795: --
796: hr_utility.set_location('Entering:'||l_proc, 10);
797: if (p_trainer_id is not null) then
798: if l_global_business_group_id is not null then
799: hr_utility.set_location('Entering:'||l_proc, 15);
800: open c_trainer_global;

Line 799: hr_utility.set_location('Entering:'||l_proc, 15);

795: --
796: hr_utility.set_location('Entering:'||l_proc, 10);
797: if (p_trainer_id is not null) then
798: if l_global_business_group_id is not null then
799: hr_utility.set_location('Entering:'||l_proc, 15);
800: open c_trainer_global;
801: fetch c_trainer_global into l_exists;
802: if c_trainer_global%notfound then
803: close c_trainer_global;

Line 808: hr_utility.set_location('leaving:'||l_proc, 20);

804: fnd_message.set_name('OTA','OTA_13906_TSR_TRAIN_NOT_EXIST');
805: fnd_message.raise_error;
806: end if;
807: close c_trainer_global;
808: hr_utility.set_location('leaving:'||l_proc, 20);
809: else
810: hr_utility.set_location('Entering:'||l_proc, 25);
811: open c_trainer;
812: fetch c_trainer into l_exists;

Line 810: hr_utility.set_location('Entering:'||l_proc, 25);

806: end if;
807: close c_trainer_global;
808: hr_utility.set_location('leaving:'||l_proc, 20);
809: else
810: hr_utility.set_location('Entering:'||l_proc, 25);
811: open c_trainer;
812: fetch c_trainer into l_exists;
813: if c_trainer%notfound then
814: close c_trainer;

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

815: fnd_message.set_name('OTA','OTA_13906_TSR_TRAIN_NOT_EXIST');
816: fnd_message.raise_error;
817: end if;
818: close c_trainer;
819: hr_utility.set_location('Leaving:'||l_proc, 30);
820: end if;
821: end if;
822: end if;
823: hr_utility.set_location('Leaving:'||l_proc, 35);

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

819: hr_utility.set_location('Leaving:'||l_proc, 30);
820: end if;
821: end if;
822: end if;
823: hr_utility.set_location('Leaving:'||l_proc, 35);
824:
825: end;
826: --
827: -- ----------------------------------------------------------------------------

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

858: --
859: l_proc varchar2(72) := g_package || 'chk_df';
860: --
861: BEGIN
862: hr_utility.set_location('Entering:'||l_proc,10);
863: --
864: IF ((p_rec.supplied_resource_id IS NOT NULL) AND (
865: NVL(ota_tsr_shd.g_old_rec.tsr_information_category, hr_api.g_varchar2) <>
866: NVL(p_rec.tsr_information_category, hr_api.g_varchar2) OR

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

959: );
960: END IF;
961:
962: --
963: hr_utility.set_location(' Leaving:'||l_proc,20);
964: END chk_df;
965:
966:
967: --

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

1088: --
1089: l_proc varchar2(72) := g_package||'insert_validate';
1090: --
1091: Begin
1092: hr_utility.set_location('Entering:'||l_proc, 5);
1093: --
1094: -- Call all supporting business operations
1095: insert_validate2(p_rec);
1096: --

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

1096: --
1097: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1098: --
1099: ota_tsr_bus.chk_df(p_rec);
1100: hr_utility.set_location(' Leaving:'||l_proc, 10);
1101: End insert_validate;
1102: --
1103: -- ----------------------------------------------------------------------------
1104: -- |---------------------------< update_validate >----------------------------|

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

1107: --
1108: l_proc varchar2(72) := g_package||'update_validate';
1109: --
1110: Begin
1111: hr_utility.set_location('Entering:'||l_proc, 5);
1112: --
1113: -- Call all supporting business operations
1114: update_validate2(p_rec);
1115: --

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

1114: update_validate2(p_rec);
1115: --
1116: hr_api.validate_bus_grp_id(p_rec.business_group_id); -- Validate Bus Grp
1117: --
1118: hr_utility.set_location(' Leaving:'||l_proc, 10);
1119: End update_validate;
1120: --
1121: -- ----------------------------------------------------------------------------
1122: -- |---------------------------< delete_validate >----------------------------|

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

1125: --
1126: l_proc varchar2(72) := g_package||'delete_validate';
1127: --
1128: Begin
1129: hr_utility.set_location('Entering:'||l_proc, 5);
1130: --
1131: -- Call all supporting business operations
1132: delete_validate2(p_rec);
1133: --

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

1130: --
1131: -- Call all supporting business operations
1132: delete_validate2(p_rec);
1133: --
1134: hr_utility.set_location(' Leaving:'||l_proc, 10);
1135: End delete_validate;
1136: --
1137:
1138: -- ----------------------------------------------------------------------------

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

1183: l_proc varchar2(72) := g_package||'return_legislation_code';
1184: l_legislation_code varchar2(150);
1185: --
1186: Begin
1187: hr_utility.set_location('Entering:'||l_proc, 5);
1188: --
1189: -- Ensure that all the mandatory parameters are not null
1190: --
1191: hr_api.mandatory_arg_error (p_api_name => l_proc,

Line 1201: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');

1197: close csr_leg_code;
1198: --
1199: -- The primary key is invalid therefore we must error out
1200: --
1201: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1202: hr_utility.raise_error;
1203: end if;
1204: --
1205: close csr_leg_code;

Line 1202: hr_utility.raise_error;

1198: --
1199: -- The primary key is invalid therefore we must error out
1200: --
1201: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
1202: hr_utility.raise_error;
1203: end if;
1204: --
1205: close csr_leg_code;
1206: return l_legislation_code;

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

1204: --
1205: close csr_leg_code;
1206: return l_legislation_code;
1207: --
1208: hr_utility.set_location(' Leaving:'||l_proc, 10);
1209: --
1210: End return_legislation_code;
1211:
1212: end ota_tsr_bus;