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.

[Home] [Help]

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 780: hr_utility.set_location('Entering:'||l_proc, 5);

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

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

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

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

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

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

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

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

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

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

811: fnd_message.set_name('OTA','OTA_13906_TSR_TRAIN_NOT_EXIST');
812: fnd_message.raise_error;
813: end if;
814: close c_trainer;
815: hr_utility.set_location('Leaving:'||l_proc, 30);
816: end if;
817: end if;
818: end if;
819: hr_utility.set_location('Leaving:'||l_proc, 35);

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

815: hr_utility.set_location('Leaving:'||l_proc, 30);
816: end if;
817: end if;
818: end if;
819: hr_utility.set_location('Leaving:'||l_proc, 35);
820:
821: end;
822: --
823: -- ----------------------------------------------------------------------------

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

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

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

955: );
956: END IF;
957:
958: --
959: hr_utility.set_location(' Leaving:'||l_proc,20);
960: END chk_df;
961:
962:
963: --

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

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

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

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

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

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

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

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

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

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

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

1126: --
1127: -- Call all supporting business operations
1128: delete_validate2(p_rec);
1129: --
1130: hr_utility.set_location(' Leaving:'||l_proc, 10);
1131: End delete_validate;
1132: --
1133:
1134: -- ----------------------------------------------------------------------------

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

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

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

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

Line 1198: hr_utility.raise_error;

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

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

1200: --
1201: close csr_leg_code;
1202: return l_legislation_code;
1203: --
1204: hr_utility.set_location(' Leaving:'||l_proc, 10);
1205: --
1206: End return_legislation_code;
1207:
1208: end ota_tsr_bus;