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_OFF_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_off_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_off_bus.g_offering_id := p_offering_id;
154: ota_off_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 166: -- hr_utility.

162: -- ----------------------------------------------------------------------------
163: --
164: -- Description:
165: -- Passes the error information to the procedure set_message of package
166: -- hr_utility.
167: --
168: Procedure call_error_message
169: (
170: p_error_appl varchar2

Line 178: hr_utility.set_location('Entering:'|| v_proc, 5);

174: v_proc varchar2(72) := g_package||'call_error_message';
175: --
176: Begin
177: --
178: hr_utility.set_location('Entering:'|| v_proc, 5);
179: --
180: -- ** TEMP ** Add error message with the following text.
181: --
182: fnd_message.set_name ( p_error_appl ,p_error_txt);

Line 185: hr_utility.set_location(' Leaving:'|| v_proc, 10);

181: --
182: fnd_message.set_name ( p_error_appl ,p_error_txt);
183: fnd_message.raise_error;
184: --
185: hr_utility.set_location(' Leaving:'|| v_proc, 10);
186: --
187: End call_error_message;
188: --
189: -- ----------------------------------------------------------------------------

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

220: --
221: l_proc varchar2(72) := g_package || 'chk_df';
222: --
223: begin
224: hr_utility.set_location('Entering:'||l_proc,10);
225: --
226: if ((p_rec.offering_id is not null) and (
227: nvl(ota_off_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
228: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

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

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

406: v_start_date date;
407: v_end_date date;
408:
409: Begin
410: hr_utility.set_location(' Entering:' || l_proc,10);
411: --
412:
413: OPEN cur_dm_start_end_date;
414: FETCH cur_dm_start_end_date into v_start_date, v_end_date;

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

430:
431: --
432: CLOSE cur_dm_start_end_date;
433:
434: hr_utility.set_location(' Leaving:' || l_proc,10);
435: Exception
436: when app_exception.application_exception then
437: IF hr_multi_message.exception_add
438: (p_associated_column1 => 'OTA_OFFERINGS.START_DATE'

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

437: IF hr_multi_message.exception_add
438: (p_associated_column1 => 'OTA_OFFERINGS.START_DATE'
439: ,p_associated_column2 => 'OTA_OFFERINGS.END_DATE'
440: ) THEN
441: hr_utility.set_location(' Leaving:'|| l_proc,20);
442: raise;
443: END IF;
444:
445: hr_utility.set_location(' Leaving:'|| l_proc,30);

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

441: hr_utility.set_location(' Leaving:'|| l_proc,20);
442: raise;
443: END IF;
444:
445: hr_utility.set_location(' Leaving:'|| l_proc,30);
446: --
447: End Chk_Dm_Start_End_Date;
448: --
449: -- ----------------------------------------------------------------------------

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

473: from ota_events
474: where parent_offering_id = p_offering_id;
475: begin
476: --
477: hr_utility.set_location(' Entering:'||l_proc,10);
478: hr_utility.trace('p_offering_id'||p_offering_id);
479: hr_utility.trace('p_start_date'||p_start_date);
480: hr_utility.trace('p_end_date'||p_end_date);
481:

Line 478: hr_utility.trace('p_offering_id'||p_offering_id);

474: where parent_offering_id = p_offering_id;
475: begin
476: --
477: hr_utility.set_location(' Entering:'||l_proc,10);
478: hr_utility.trace('p_offering_id'||p_offering_id);
479: hr_utility.trace('p_start_date'||p_start_date);
480: hr_utility.trace('p_end_date'||p_end_date);
481:
482: --

Line 479: hr_utility.trace('p_start_date'||p_start_date);

475: begin
476: --
477: hr_utility.set_location(' Entering:'||l_proc,10);
478: hr_utility.trace('p_offering_id'||p_offering_id);
479: hr_utility.trace('p_start_date'||p_start_date);
480: hr_utility.trace('p_end_date'||p_end_date);
481:
482: --
483: l_start_date := p_start_date;

Line 480: hr_utility.trace('p_end_date'||p_end_date);

476: --
477: hr_utility.set_location(' Entering:'||l_proc,10);
478: hr_utility.trace('p_offering_id'||p_offering_id);
479: hr_utility.trace('p_start_date'||p_start_date);
480: hr_utility.trace('p_end_date'||p_end_date);
481:
482: --
483: l_start_date := p_start_date;
484: l_end_date := p_end_date;

Line 522: hr_utility.set_location(' Exiting:'||l_proc,10);

518: fnd_message.raise_error;
519: end if;
520: end loop;
521: --
522: hr_utility.set_location(' Exiting:'||l_proc,10);
523: Exception
524: WHEN app_exception.application_exception THEN
525:
526: IF hr_multi_message.exception_add(

Line 531: --hr_utility.set_location(' Leaving:'||v_proc, 22);

527: p_associated_column1 => 'OTA_OFFERINGS.START_DATE',
528: p_associated_column2 => 'OTA_OFFERINGS.END_DATE')
529: THEN
530:
531: --hr_utility.set_location(' Leaving:'||v_proc, 22);
532: RAISE;
533:
534: END IF;
535: end CLASS_DATES_ARE_VALID;

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

558: from ota_activity_versions
559: where activity_version_id = p_activity_version_id;
560: begin
561: --
562: hr_utility.set_location(' Entering:'||l_proc,10);
563: hr_utility.trace('p_activity_version_id'||p_activity_version_id);
564: hr_utility.trace('p_offering_start_date'||p_offering_start_date);
565: hr_utility.trace('p_offering_end_date'||p_offering_end_date);
566: --

Line 563: hr_utility.trace('p_activity_version_id'||p_activity_version_id);

559: where activity_version_id = p_activity_version_id;
560: begin
561: --
562: hr_utility.set_location(' Entering:'||l_proc,10);
563: hr_utility.trace('p_activity_version_id'||p_activity_version_id);
564: hr_utility.trace('p_offering_start_date'||p_offering_start_date);
565: hr_utility.trace('p_offering_end_date'||p_offering_end_date);
566: --
567: open check_dates;

Line 564: hr_utility.trace('p_offering_start_date'||p_offering_start_date);

560: begin
561: --
562: hr_utility.set_location(' Entering:'||l_proc,10);
563: hr_utility.trace('p_activity_version_id'||p_activity_version_id);
564: hr_utility.trace('p_offering_start_date'||p_offering_start_date);
565: hr_utility.trace('p_offering_end_date'||p_offering_end_date);
566: --
567: open check_dates;
568: fetch check_dates into l_start_date, l_end_date;

Line 565: hr_utility.trace('p_offering_end_date'||p_offering_end_date);

561: --
562: hr_utility.set_location(' Entering:'||l_proc,10);
563: hr_utility.trace('p_activity_version_id'||p_activity_version_id);
564: hr_utility.trace('p_offering_start_date'||p_offering_start_date);
565: hr_utility.trace('p_offering_end_date'||p_offering_end_date);
566: --
567: open check_dates;
568: fetch check_dates into l_start_date, l_end_date;
569: close check_dates;

Line 602: hr_utility.set_location(' Exiting:'||l_proc,10);

598: fnd_message.set_name('OTA','OTA_443316_OFF_INVALID_DATES');
599: fnd_message.raise_error;
600: end if;
601: --
602: hr_utility.set_location(' Exiting:'||l_proc,10);
603: Exception
604: WHEN app_exception.application_exception THEN
605:
606: IF hr_multi_message.exception_add(

Line 611: --hr_utility.set_location(' Leaving:'||v_proc, 22);

607: p_associated_column1 => 'OTA_OFFERINGS.START_DATE',
608: p_associated_column2 => 'OTA_OFFERINGS.END_DATE')
609: THEN
610:
611: --hr_utility.set_location(' Leaving:'||v_proc, 22);
612: RAISE;
613:
614: END IF;
615: end OFFERING_DATES_ARE_VALID;

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

625: l_proc VARCHAR2(72) := g_package||'chk_competency_update_level';
626: l_api_updating boolean;
627:
628: BEGIN
629: hr_utility.set_location(' Leaving:'||l_proc, 10);
630: --
631: -- check mandatory parameters has been set
632: --
633: hr_api.mandatory_arg_error

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

644: NVL(ota_off_shd.g_old_rec.competency_update_level,hr_api.g_varchar2) <>
645: NVL(p_competency_update_level, hr_api.g_varchar2))
646: OR NOT l_api_updating AND p_competency_update_level IS NOT NULL) THEN
647:
648: hr_utility.set_location(' Leaving:'||l_proc, 20);
649: --
650:
651: IF p_competency_update_level IS NOT NULL THEN
652: IF hr_api.not_exists_in_hr_lookups

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

655: ,p_lookup_code => p_competency_update_level) THEN
656: fnd_message.set_name('OTA','OTA_443411_COMP_UPD_LEV_INVLD');
657: fnd_message.raise_error;
658: END IF;
659: hr_utility.set_location(' Leaving:'||l_proc, 30);
660:
661: END IF;
662:
663: END IF;

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

660:
661: END IF;
662:
663: END IF;
664: hr_utility.set_location(' Leaving:'||l_proc, 40);
665:
666: EXCEPTION
667:
668: WHEN app_exception.application_exception THEN

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

669:
670: IF hr_multi_message.exception_add
671: (p_associated_column1 => 'OTA_OFFERINGS.COMPETENCY_UPDATE_LEVEL') THEN
672:
673: hr_utility.set_location(' Leaving:'||l_proc, 42);
674: RAISE;
675: END IF;
676:
677: hr_utility.set_location(' Leaving:'||l_proc, 44);

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

673: hr_utility.set_location(' Leaving:'||l_proc, 42);
674: RAISE;
675: END IF;
676:
677: hr_utility.set_location(' Leaving:'||l_proc, 44);
678:
679: END chk_competency_update_level;
680:
681: --

Line 700: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);

696: := G_PACKAGE || 'CHECK_UNIQUE';
697: --
698: begin
699: --
700: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
701: --
702: -- Do not perform the uniqueness check unless inserting, or updating
703: -- with a value different from the current value (and not just changing
704: -- case)

Line 717: HR_UTILITY.SET_LOCATION (' Leaving:' || W_PROC, 10);

713: fnd_message.raise_error;
714: --
715: end if;
716: --
717: HR_UTILITY.SET_LOCATION (' Leaving:' || W_PROC, 10);
718: --
719: Exception
720: WHEN app_exception.application_exception THEN
721:

Line 727: --hr_utility.set_location(' Leaving:'||v_proc, 22);

723: p_associated_column1 => 'OTA_OFFERINGS.BUSINESS_GROUP_ID',
724: p_associated_column2 => 'OTA_OFFERINGS.DELIVERY_MODE_ID')
725: THEN
726:
727: --hr_utility.set_location(' Leaving:'||v_proc, 22);
728: RAISE;
729:
730: END IF;
731:

Line 767: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);

763: l_num number(10);
764: --
765: begin
766: --
767: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
768: --
769: -- Check arguments
770: --
771: HR_API.MANDATORY_ARG_ERROR (

Line 788: HR_UTILITY.SET_LOCATION (W_PROC, 10);

784: into l_num;
785: W_TITLE_IS_UNIQUE := C1%notfound;
786: close C1;
787: --
788: HR_UTILITY.SET_LOCATION (W_PROC, 10);
789: return W_TITLE_IS_UNIQUE;
790: --
791: end UNIQUE_OFFERING_TITLE;
792: --

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

815: l_test_id ota_learning_objects.test_id%TYPE;
816:
817: Begin
818: --
819: hr_utility.set_location('Entering:'||l_proc, 5);
820: --
821: OPEN c_is_test;
822: FETCH c_is_test into l_test_id;
823: CLOSE c_is_test;

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

833: fnd_message.raise_error;
834: END IF;
835:
836: END IF;
837: hr_utility.set_location('Leaving:'||l_proc, 40);
838:
839:
840: Exception
841: WHEN app_exception.application_exception THEN

Line 848: hr_utility.set_location(' Leaving:'||l_proc, 22);

844: p_associated_column1 => 'OTA_OFFERINGS.PLAYER_TOOLBAR_FLAG',
845: p_associated_column2 => 'OTA_OFFERINGS.PLAYER_TOOLBAR_BITSET')
846: THEN
847:
848: hr_utility.set_location(' Leaving:'||l_proc, 22);
849: RAISE;
850:
851: END IF;
852: end check_is_test_selected;

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

884: --l_cross_business_group varchar2(1):= FND_PROFILE.VALUE('HR_CROSS_BUSINESS_GROUP');
885: l_single_business_group_id number := FND_PROFILE.VALUE('OTA_HR_GLOBAL_BUSINESS_GROUP_ID');
886: Begin
887: --
888: hr_utility.set_location('Entering:'||l_proc, 5);
889: --
890: if (((p_offering_id is not null) and
891: nvl(ota_off_shd.g_old_rec.owner_id,hr_api.g_number) <>
892: nvl(p_owner_id,hr_api.g_number))

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

892: nvl(p_owner_id,hr_api.g_number))
893: or (p_offering_id is null)) then
894: IF p_owner_id is not null then
895: If l_single_business_group_id is not null then
896: hr_utility.set_location('Entering:'||l_proc, 10);
897: OPEN c_people_cross;
898: FETCH c_people_cross into l_exist;
899: if c_people_cross%notfound then
900: close c_people_cross;

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

902: fnd_message.raise_error;
903: end if;
904: close c_people_cross;
905: else
906: hr_utility.set_location('Entering:'||l_proc, 20);
907: OPEN c_people;
908: FETCH c_people into l_exist;
909: if c_people%notfound then
910: close c_people;

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

912: fnd_message.raise_error;
913: end if;
914: close c_people;
915: end if;
916: hr_utility.set_location('Leaving:'||l_proc, 40);
917: END IF;
918: End if;
919: Exception
920: WHEN app_exception.application_exception THEN

Line 926: --hr_utility.set_location(' Leaving:'||v_proc, 22);

922: IF hr_multi_message.exception_add(
923: p_associated_column1 => 'OTA_OFFERINGS.OWNER_ID')
924: THEN
925:
926: --hr_utility.set_location(' Leaving:'||v_proc, 22);
927: RAISE;
928:
929: END IF;
930: end check_owner_id;

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

957: v_online_flag ota_category_usages.online_flag%TYPE;
958: l_iln_rco_id varchar2(50);
959:
960: Begin
961: hr_utility.set_location(' Entering:' || l_proc,10);
962: --
963:
964: OPEN cur_dm_online_flag;
965: FETCH cur_dm_online_flag into v_online_flag;

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

976:
977: --
978: CLOSE cur_dm_online_flag;
979:
980: hr_utility.set_location(' Leaving:' || l_proc,10);
981: Exception
982: when app_exception.application_exception then
983: IF hr_multi_message.exception_add
984: (p_associated_column1 => 'OTA_OFFERINGS.LEARNING_OBJECT_ID'

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

982: when app_exception.application_exception then
983: IF hr_multi_message.exception_add
984: (p_associated_column1 => 'OTA_OFFERINGS.LEARNING_OBJECT_ID'
985: ) THEN
986: hr_utility.set_location(' Leaving:'|| l_proc,20);
987: raise;
988: END IF;
989:
990: hr_utility.set_location(' Leaving:'|| l_proc,30);

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

986: hr_utility.set_location(' Leaving:'|| l_proc,20);
987: raise;
988: END IF;
989:
990: hr_utility.set_location(' Leaving:'|| l_proc,30);
991: --
992: End chk_dm_online_flag;
993:
994: ---------------------------------------------------------------------

Line 1040: --hr_utility.set_location(' Leaving:'||v_proc, 22);

1036: ,p_associated_column2 => 'OTA_OFFERINGS.MAXIMUM_INTERNAL_ATTENDEES'
1037: ,p_associated_column3 => 'OTA_OFFERINGS.MINIMUM_ATTENDEES')
1038: THEN
1039:
1040: --hr_utility.set_location(' Leaving:'||v_proc, 22);
1041: RAISE;
1042:
1043: END IF;
1044:

Line 1069: --hr_utility.set_location(' Leaving:'||v_proc, 22);

1065: p_associated_column1 => 'OTA_OFFERINGS.DURATION'
1066: ,p_associated_column2 => 'OTA_OFFERINGS.DURATION_UNITS')
1067: THEN
1068:
1069: --hr_utility.set_location(' Leaving:'||v_proc, 22);
1070: RAISE;
1071:
1072: END IF;
1073: end check_duration;

Line 1111: --hr_utility.set_location(' Leaving:'||v_proc, 22);

1107: ,p_associated_column2 => 'OTA_OFFERINGS.BUDGET_COST'
1108: ,p_associated_column3 => 'OTA_OFFERINGS.STANDARD_PRICE')
1109: THEN
1110:
1111: --hr_utility.set_location(' Leaving:'||v_proc, 22);
1112: RAISE;
1113:
1114: END IF;
1115: end check_amount;

Line 1127: hr_utility.set_location('Entering:'|| v_proc, 5);

1123: --
1124: v_proc varchar2(72) := g_package||'check_vendor';
1125: begin
1126: --
1127: hr_utility.set_location('Entering:'|| v_proc, 5);
1128: --
1129: ota_general.check_vendor_is_valid(p_vendor_id,p_date);
1130: --
1131: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 1131: hr_utility.set_location(' Leaving:'|| v_proc, 10);

1127: hr_utility.set_location('Entering:'|| v_proc, 5);
1128: --
1129: ota_general.check_vendor_is_valid(p_vendor_id,p_date);
1130: --
1131: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1132: --
1133: exception
1134: when app_exception.application_exception then
1135: if hr_multi_message.exception_add

Line 1138: hr_utility.set_location(' Leaving:'|| v_proc,70);

1134: when app_exception.application_exception then
1135: if hr_multi_message.exception_add
1136: (p_associated_column1 => 'OTA_OFFERINGS.VENDOR_ID'
1137: ) then
1138: hr_utility.set_location(' Leaving:'|| v_proc,70);
1139: raise;
1140: end if;
1141: hr_utility.set_location(' Leaving:'|| v_proc,80);
1142: end check_vendor;

Line 1141: hr_utility.set_location(' Leaving:'|| v_proc,80);

1137: ) then
1138: hr_utility.set_location(' Leaving:'|| v_proc,70);
1139: raise;
1140: end if;
1141: hr_utility.set_location(' Leaving:'|| v_proc,80);
1142: end check_vendor;
1143: --
1144: -- ----------------------------------------------------------------------------
1145: -- |-----------------------< Chk_Inventory_Course >---------------------------|

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

1172: l_proc varchar2(72) := g_package ||'Chk_Inventory_Course';
1173: l_inv_org_flag varchar2(10);
1174:
1175: Begin
1176: hr_utility.set_location(' Entering:' || l_proc,10);
1177: --
1178: OPEN Cur_Inventory_Course;
1179: FETCH Cur_Inventory_Course into l_inv_org_flag;
1180: --

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

1188: --
1189: CLOSE Cur_Inventory_Course;
1190: End If;
1191: --
1192: hr_utility.set_location(' Leaving:' || l_proc,10);
1193: Exception
1194: When app_exception.application_exception Then
1195: --
1196: If hr_multi_message.exception_add

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

1196: If hr_multi_message.exception_add
1197: (p_associated_column1 => 'OTA_OFFERINGS.DELIVERY_MODE_ID'
1198: ) Then
1199: --
1200: hr_utility.set_location(' Leaving:'|| l_proc,20);
1201: raise;
1202: --
1203: End If;
1204: --

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

1201: raise;
1202: --
1203: End If;
1204: --
1205: hr_utility.set_location(' Leaving:'|| l_proc,30);
1206: --
1207: End Chk_Inventory_Course;
1208: --
1209:

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

1339: --
1340: l_proc varchar2(72) := g_package||'insert_validate';
1341: --
1342: Begin
1343: hr_utility.set_location('Entering:'||l_proc, 5);
1344: --
1345: -- Call all supporting business operations
1346: --
1347: hr_api.validate_bus_grp_id

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

1370:
1371: ota_off_bus.chk_df(p_rec);
1372:
1373: --
1374: hr_utility.set_location(' Leaving:'||l_proc, 10);
1375: End insert_validate;
1376: --
1377: -- ----------------------------------------------------------------------------
1378: -- |---------------------------< update_validate >----------------------------|

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

1389: p_rec.owner_id);
1390:
1391: --
1392: Begin
1393: hr_utility.set_location('Entering:'||l_proc, 5);
1394: --
1395: -- Call all supporting business operations
1396: --
1397: hr_api.validate_bus_grp_id

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

1429:
1430: ota_off_bus.chk_df(p_rec);
1431:
1432: --
1433: hr_utility.set_location(' Leaving:'||l_proc, 10);
1434: End update_validate;
1435: --
1436: -- ----------------------------------------------------------------------------
1437: -- |---------------------------< delete_validate >----------------------------|

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

1442: --
1443: l_proc varchar2(72) := g_package||'delete_validate';
1444: --
1445: Begin
1446: hr_utility.set_location('Entering:'||l_proc, 5);
1447: --
1448: -- Call all supporting business operations
1449: --
1450: check_if_evt_exists( p_offering_id => p_rec.offering_id );

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

1448: -- Call all supporting business operations
1449: --
1450: check_if_evt_exists( p_offering_id => p_rec.offering_id );
1451: check_if_comp_exists( p_offering_id => p_rec.offering_id );
1452: hr_utility.set_location(' Leaving:'||l_proc, 10);
1453: End delete_validate;
1454: --
1455: -- ----------------------------------------------------------------------------
1456: -- |-------------------------< check_if_evt_exists >--------------------------|

Line 1480: hr_utility.set_location('Entering:'|| v_proc, 5);

1476: where evt.parent_offering_id = p_offering_id;
1477: --
1478: Begin
1479: --
1480: hr_utility.set_location('Entering:'|| v_proc, 5);
1481: --
1482: Open sel_evt_exists;
1483: fetch sel_evt_exists into v_exists;
1484: --

Line 1499: hr_utility.set_location(' Leaving:'|| v_proc, 10);

1495: end if;
1496: --
1497: close sel_evt_exists;
1498: --
1499: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1500: --
1501: End check_if_evt_exists;
1502: --
1503: --

Line 1530: hr_utility.set_location('Entering:'|| v_proc, 5);

1526: and comp.type = 'OTA_OFFERING'; --bug 3691224
1527: --
1528: Begin
1529: --
1530: hr_utility.set_location('Entering:'|| v_proc, 5);
1531: --
1532: Open sel_comp_exists;
1533: fetch sel_comp_exists into v_exists;
1534: --

Line 1549: hr_utility.set_location(' Leaving:'|| v_proc, 10);

1545: end if;
1546: --
1547: close sel_comp_exists;
1548: --
1549: hr_utility.set_location(' Leaving:'|| v_proc, 10);
1550: --
1551: End check_if_comp_exists;
1552: --
1553: end ota_off_bus;