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

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

50: --
51: l_proc varchar2(72) := g_package || 'chk_ddf';
52: --
53: begin
54: hr_utility.set_location('Entering:'||l_proc,10);
55: --
56: if ((p_rec.event_id is not null) and (
57: nvl(ota_evt_shd.g_old_rec.evt_information_category, hr_api.g_varchar2) <>
58: nvl(p_rec.evt_information_category, hr_api.g_varchar2) or

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

149: ,p_attribute20_value => p_rec.evt_information20
150: );
151: end if;
152: --
153: hr_utility.set_location(' Leaving:'||l_proc,20);
154: end chk_ddf;
155:
156: --
157: --

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

183: l_proc varchar2(72) := g_package||'set_security_group_id';
184: --
185: BEGIN
186: --
187: hr_utility.set_location('Entering:'|| l_proc, 10);
188: --
189: -- Ensure that all the mandatory parameter are not null
190: --
191: hr_api.mandatory_arg_error

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

217: (p_security_group_id => l_security_group_id
218: );
219:
220: END IF;
221: hr_utility.set_location(' Leaving:'|| l_proc, 20);
222: --
223: END set_security_group_id;
224: --added for eBS by asud
225:

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

269: l_proc varchar2(72) := g_package||'return_legislation_code';
270: l_legislation_code varchar2(150);
271: --
272: Begin
273: hr_utility.set_location('Entering:'||l_proc, 5);
274: --
275: -- Ensure that all the mandatory parameters are not null
276: --
277: hr_api.mandatory_arg_error (p_api_name => l_proc,

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

283: close csr_leg_code;
284: --
285: -- The primary key is invalid therefore we must error out
286: --
287: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
288: hr_utility.raise_error;
289: end if;
290: --
291: close csr_leg_code;

Line 288: hr_utility.raise_error;

284: --
285: -- The primary key is invalid therefore we must error out
286: --
287: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
288: hr_utility.raise_error;
289: end if;
290: --
291: close csr_leg_code;
292: return l_legislation_code;

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

290: --
291: close csr_leg_code;
292: return l_legislation_code;
293: --
294: hr_utility.set_location(' Leaving:'||l_proc, 10);
295: --
296: End return_legislation_code;
297: --
298: --

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

421: --
422:
423: begin
424: --
425: hr_utility.set_location('Entering '||l_proc,10);
426: --
427: if ( p_price_basis is not null and p_price_basis ='N') then
428:
429: OPEN evt_associations_cr('Y','N');

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

469:
470: END IF;
471:
472: --
473: hr_utility.set_location('Leaving '||l_proc,10);
474: --
475: EXCEPTION
476: WHEN app_exception.application_exception THEN
477: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PRICE_BASIS',

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

475: EXCEPTION
476: WHEN app_exception.application_exception THEN
477: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PRICE_BASIS',
478: p_associated_column2 => 'OTA_EVENTS.STANDARD_PRICE') THEN
479: hr_utility.set_location(' Leaving:'||l_proc, 40);
480: RAISE;
481: END IF;
482: hr_utility.set_location(' Leaving:'||l_proc, 50);
483:

Line 482: hr_utility.set_location(' Leaving:'||l_proc, 50);

478: p_associated_column2 => 'OTA_EVENTS.STANDARD_PRICE') THEN
479: hr_utility.set_location(' Leaving:'||l_proc, 40);
480: RAISE;
481: END IF;
482: hr_utility.set_location(' Leaving:'||l_proc, 50);
483:
484: end check_price_basis;
485: --
486: -- ----------------------------------------------------------------------------

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

498: l_proc varchar2(30) := 'check_pricing';
499: --
500: begin
501: --
502: hr_utility.set_location('Entering '||l_proc,10);
503: --
504: if ( p_pricing_type is not null and p_pricing_type ='S' and (p_amount is null or p_currency_code is null)) then
505: fnd_message.set_name('OTA','OTA_13440_EVT_CURR_PB');
506: fnd_message.raise_error;

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

511: fnd_message.raise_error;
512: end if;
513:
514: --
515: hr_utility.set_location('Leaving '||l_proc,10);
516: --
517: EXCEPTION
518: WHEN app_exception.application_exception THEN
519: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PRICE_BASIS',

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

517: EXCEPTION
518: WHEN app_exception.application_exception THEN
519: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PRICE_BASIS',
520: p_associated_column2 => 'OTA_EVENTS.STANDARD_PRICE') THEN
521: hr_utility.set_location(' Leaving:'||l_proc, 40);
522: RAISE;
523: END IF;
524: hr_utility.set_location(' Leaving:'||l_proc, 50);
525:

Line 524: hr_utility.set_location(' Leaving:'||l_proc, 50);

520: p_associated_column2 => 'OTA_EVENTS.STANDARD_PRICE') THEN
521: hr_utility.set_location(' Leaving:'||l_proc, 40);
522: RAISE;
523: END IF;
524: hr_utility.set_location(' Leaving:'||l_proc, 50);
525:
526: end check_pricing;
527: --
528: -- ----------------------------------------------------------------------------

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

549: and evt.event_status = 'P';
550: --
551: begin
552: --
553: hr_utility.set_location(' Entering:'||l_proc,10);
554: --
555: open c1;
556: --
557: fetch c1 into l_dummy;

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

564: end if;
565: --
566: close c1;
567: --
568: hr_utility.set_location(' Leaving:'||l_proc,10);
569: return l_found;
570: --
571: end status_change_normal;
572: -- ----------------------------------------------------------------------------

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

589: l_course_start_date date;
590: l_course_end_date date;
591: begin
592: --
593: hr_utility.set_location(' Entering:'||l_proc,10);
594: l_course_start_date := p_course_start_date;
595: l_course_end_date := p_course_end_date;
596: if l_course_start_date is null then
597: l_course_start_date := p_enrollment_start_date;

Line 645: hr_utility.set_location(' Exitting:'||l_proc,10);

641: End if;*/
642: --
643: End if;
644: --
645: hr_utility.set_location(' Exitting:'||l_proc,10);
646: --
647: End enrollment_dates_event_valid;
648: --
649: -- ----------------------------------------------------------------------------

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

663: l_proc varchar2(30) := 'enrollment_after_event_end';
664: l_course_end_date date;
665: begin
666: --
667: hr_utility.set_location(' Entering:'||l_proc,10);
668: l_course_end_date := p_course_end_date;
669: if l_course_end_date is null then
670: l_course_end_date := p_enrollment_end_date;
671: end if;

Line 672: hr_utility.set_location('Course End Date '||to_char(l_course_end_date),10);

668: l_course_end_date := p_course_end_date;
669: if l_course_end_date is null then
670: l_course_end_date := p_enrollment_end_date;
671: end if;
672: hr_utility.set_location('Course End Date '||to_char(l_course_end_date),10);
673: hr_utility.set_location('Enrolment End Date '||to_char(p_enrollment_end_date),10);
674: --
675: -- Existing date for the parent enddate <= enrollment enddate
676: --

Line 673: hr_utility.set_location('Enrolment End Date '||to_char(p_enrollment_end_date),10);

669: if l_course_end_date is null then
670: l_course_end_date := p_enrollment_end_date;
671: end if;
672: hr_utility.set_location('Course End Date '||to_char(l_course_end_date),10);
673: hr_utility.set_location('Enrolment End Date '||to_char(p_enrollment_end_date),10);
674: --
675: -- Existing date for the parent enddate <= enrollment enddate
676: --
677: If l_course_end_date is not null Then

Line 682: hr_utility.set_location('Enrollment > Course ',10);

678: --
679: -- Enrollment enddate is later than course enddate
680: --
681: If nvl(p_enrollment_end_date, l_course_end_date) > l_course_end_date Then
682: hr_utility.set_location('Enrollment > Course ',10);
683: return true;
684: End if;
685: End If;
686: hr_utility.set_location(' Exitting:'||l_proc,10);

Line 686: hr_utility.set_location(' Exitting:'||l_proc,10);

682: hr_utility.set_location('Enrollment > Course ',10);
683: return true;
684: End if;
685: End If;
686: hr_utility.set_location(' Exitting:'||l_proc,10);
687: return false;
688: --
689: End enrollment_after_event_end;
690: --

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

702: --
703: l_proc varchar2(30) := 'check_event_status';
704: begin
705: --
706: hr_utility.set_location(' Entering:'||l_proc,10);
707: if (p_event_status <> 'P' AND p_event_status <> 'A') OR p_event_type <> 'SELFPACED' then
708: if p_course_end_date is null then
709: fnd_message.set_name('OTA','OTA_13480_END_DATE_NULL');
710: fnd_message.raise_error;

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

709: fnd_message.set_name('OTA','OTA_13480_END_DATE_NULL');
710: fnd_message.raise_error;
711: end if;
712: end if;
713: hr_utility.set_location(' Leaving:'||l_proc,10);
714: EXCEPTION
715: WHEN app_exception.application_exception THEN
716: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.EVENT_STATUS') THEN
717: hr_utility.set_location(' Leaving:'||l_proc, 40);

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

713: hr_utility.set_location(' Leaving:'||l_proc,10);
714: EXCEPTION
715: WHEN app_exception.application_exception THEN
716: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.EVENT_STATUS') THEN
717: hr_utility.set_location(' Leaving:'||l_proc, 40);
718: RAISE;
719: END IF;
720: hr_utility.set_location(' Leaving:'||l_proc, 50);
721:

Line 720: hr_utility.set_location(' Leaving:'||l_proc, 50);

716: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.EVENT_STATUS') THEN
717: hr_utility.set_location(' Leaving:'||l_proc, 40);
718: RAISE;
719: END IF;
720: hr_utility.set_location(' Leaving:'||l_proc, 50);
721:
722: end check_event_status;
723: --
724: -- ----------------------------------------------------------------------------

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

753: p_end_time);
754: --
755: begin
756: --
757: hr_utility.set_location(' Entering:'||l_proc,10);
758: --
759: open c1;
760: --
761: fetch c1 into l_dummy;

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

766: end if;
767: --
768: close c1;
769: --
770: hr_utility.set_location(' Leaving:'||l_proc,10);
771: --
772: return l_found;
773: --
774: end resources_affected;

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

801: select null
802: from ota_event_associations
803: where event_id = p_event_id;
804: begin
805: hr_utility.set_location(' Entering:'||l_proc,10);
806: --
807: if p_public_event_flag = 'N' then
808: open get_enrollments;
809: fetch get_enrollments into l_exists;

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

826: end if;
827: close get_tea;
828: end if;
829: --
830: hr_utility.set_location(' Leaving:'||l_proc,10);
831: EXCEPTION
832: WHEN app_exception.application_exception THEN
833: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PUBLIC_EVENT_FLAG') THEN
834: hr_utility.set_location(' Leaving:'||l_proc, 40);

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

830: hr_utility.set_location(' Leaving:'||l_proc,10);
831: EXCEPTION
832: WHEN app_exception.application_exception THEN
833: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PUBLIC_EVENT_FLAG') THEN
834: hr_utility.set_location(' Leaving:'||l_proc, 40);
835: RAISE;
836: END IF;
837: hr_utility.set_location(' Leaving:'||l_proc, 50);
838:

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

833: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PUBLIC_EVENT_FLAG') THEN
834: hr_utility.set_location(' Leaving:'||l_proc, 40);
835: RAISE;
836: END IF;
837: hr_utility.set_location(' Leaving:'||l_proc, 50);
838:
839: end check_public_event_flag;
840: --
841: -- ----------------------------------------------------------------------------

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

861: from ota_offerings
862: where offering_id = p_parent_offering_id;
863: begin
864: --
865: hr_utility.set_location(' Entering:'||l_proc,10);
866: open check_dates;
867: loop
868: fetch check_dates into l_start_date, l_end_date;
869: exit when check_dates%notfound;

Line 883: hr_utility.set_location(' Exitting:'||l_proc,10);

879: p_enrollment_end_date);
880: end loop;
881: close check_dates;
882:
883: hr_utility.set_location(' Exitting:'||l_proc,10);
884: --
885: EXCEPTION
886: WHEN app_exception.application_exception THEN
887: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.ENROLMENT_START_DATE',

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

885: EXCEPTION
886: WHEN app_exception.application_exception THEN
887: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.ENROLMENT_START_DATE',
888: p_associated_column2 => 'OTA_EVENTS.ENROLMENT_END_DATE') THEN
889: hr_utility.set_location(' Leaving:'||l_proc, 40);
890: RAISE;
891: END IF;
892: hr_utility.set_location(' Leaving:'||l_proc, 50);
893:

Line 892: hr_utility.set_location(' Leaving:'||l_proc, 50);

888: p_associated_column2 => 'OTA_EVENTS.ENROLMENT_END_DATE') THEN
889: hr_utility.set_location(' Leaving:'||l_proc, 40);
890: RAISE;
891: END IF;
892: hr_utility.set_location(' Leaving:'||l_proc, 50);
893:
894: End enrollment_dates_are_valid;
895:
896: /*--changes made for eBS by asud

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

906: from ota_activity_versions_v
907: where activity_version_id = p_activity_version_id;
908: begin
909: --
910: hr_utility.set_location(' Entering:'||l_proc,10);
911: open check_dates;
912: loop
913: fetch check_dates into l_start_date, l_end_date;
914: exit when check_dates%notfound;

Line 928: hr_utility.set_location(' Exitting:'||l_proc,10);

924: p_enrollment_end_date);
925: end loop;
926: close check_dates;
927:
928: hr_utility.set_location(' Exitting:'||l_proc,10);
929: --
930: End enrollment_dates_are_valid;
931: */--changes made for eBS by asud
932: -------------------------------------------------------------------

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

949: --
950: v_proc varchar2(72) := g_package||'check_enrollment_dates';
951: --
952: Begin
953: hr_utility.set_location('Entering:'||v_proc, 5);
954: --
955: -- Existing date for the parent startdate => Boundary parent startdate
956: --
957: --

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

980: -- This isn't a problem
981: --
982: End if;
983: --
984: hr_utility.set_location(' Leaving:'||v_proc, 10);
985:
986:
987: End check_enrollment_dates;
988:

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

1000: p_course_start_time IN ota_events.course_start_time%TYPE)
1001: is
1002: l_proc varchar2(30) := 'chk_start_date';
1003: begin
1004: hr_utility.set_location('Entering:'||l_proc,10);
1005:
1006: if p_course_start_time is not null and p_course_start_date is null
1007: then
1008: fnd_message.set_name('OTA','OTA_13065_CLASS_START_DATE');

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

1007: then
1008: fnd_message.set_name('OTA','OTA_13065_CLASS_START_DATE');
1009: fnd_message.raise_error;
1010: end if;
1011: hr_utility.set_location('Leaving:'||l_proc,20);
1012:
1013: EXCEPTION
1014: WHEN app_exception.application_exception THEN
1015: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN

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

1012:
1013: EXCEPTION
1014: WHEN app_exception.application_exception THEN
1015: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN
1016: hr_utility.set_location(' Leaving:'||l_proc, 40);
1017: RAISE;
1018: END IF;
1019: hr_utility.set_location(' Leaving:'||l_proc, 50);
1020:

Line 1019: hr_utility.set_location(' Leaving:'||l_proc, 50);

1015: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN
1016: hr_utility.set_location(' Leaving:'||l_proc, 40);
1017: RAISE;
1018: END IF;
1019: hr_utility.set_location(' Leaving:'||l_proc, 50);
1020:
1021: end chk_start_date;
1022: -------------------------------------------------------------------
1023: --

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

1033: p_course_end_time IN ota_events.course_end_time%TYPE)
1034: is
1035: l_proc varchar2(30) := 'chk_end_date';
1036: begin
1037: hr_utility.set_location('Entering:'||l_proc,10);
1038: if p_course_end_time is not null and p_course_end_date is null
1039: then
1040: fnd_message.set_name('OTA','OTA_443613_CLASS_END_DATE');
1041: fnd_message.raise_error;

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

1039: then
1040: fnd_message.set_name('OTA','OTA_443613_CLASS_END_DATE');
1041: fnd_message.raise_error;
1042: end if;
1043: hr_utility.set_location('Leaving:'||l_proc,20);
1044:
1045: EXCEPTION
1046: WHEN app_exception.application_exception THEN
1047: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_END_TIME') THEN

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

1044:
1045: EXCEPTION
1046: WHEN app_exception.application_exception THEN
1047: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_END_TIME') THEN
1048: hr_utility.set_location(' Leaving:'||l_proc, 40);
1049: RAISE;
1050: END IF;
1051: hr_utility.set_location(' Leaving:'||l_proc, 50);
1052:

Line 1051: hr_utility.set_location(' Leaving:'||l_proc, 50);

1047: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_END_TIME') THEN
1048: hr_utility.set_location(' Leaving:'||l_proc, 40);
1049: RAISE;
1050: END IF;
1051: hr_utility.set_location(' Leaving:'||l_proc, 50);
1052:
1053: end CHK_END_DATE;
1054: -------------------------------------------------------------------
1055: --

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

1090: where activity_version_id = l_act_vrsn_id;
1091:
1092: begin
1093: --
1094: hr_utility.set_location(' Entering:'||l_proc,10);
1095: hr_utility.trace('p_parent_offering_id'||p_parent_offering_id);
1096: hr_utility.trace('p_course_start_date'||p_course_start_date);
1097: hr_utility.trace('p_course_end_date'||p_course_end_date);
1098: hr_utility.trace('p_event_status'||p_event_status);

Line 1095: hr_utility.trace('p_parent_offering_id'||p_parent_offering_id);

1091:
1092: begin
1093: --
1094: hr_utility.set_location(' Entering:'||l_proc,10);
1095: hr_utility.trace('p_parent_offering_id'||p_parent_offering_id);
1096: hr_utility.trace('p_course_start_date'||p_course_start_date);
1097: hr_utility.trace('p_course_end_date'||p_course_end_date);
1098: hr_utility.trace('p_event_status'||p_event_status);
1099: /*

Line 1096: hr_utility.trace('p_course_start_date'||p_course_start_date);

1092: begin
1093: --
1094: hr_utility.set_location(' Entering:'||l_proc,10);
1095: hr_utility.trace('p_parent_offering_id'||p_parent_offering_id);
1096: hr_utility.trace('p_course_start_date'||p_course_start_date);
1097: hr_utility.trace('p_course_end_date'||p_course_end_date);
1098: hr_utility.trace('p_event_status'||p_event_status);
1099: /*
1100: if p_event_status <> 'P' then

Line 1097: hr_utility.trace('p_course_end_date'||p_course_end_date);

1093: --
1094: hr_utility.set_location(' Entering:'||l_proc,10);
1095: hr_utility.trace('p_parent_offering_id'||p_parent_offering_id);
1096: hr_utility.trace('p_course_start_date'||p_course_start_date);
1097: hr_utility.trace('p_course_end_date'||p_course_end_date);
1098: hr_utility.trace('p_event_status'||p_event_status);
1099: /*
1100: if p_event_status <> 'P' then
1101: if p_course_start_date is null or

Line 1098: hr_utility.trace('p_event_status'||p_event_status);

1094: hr_utility.set_location(' Entering:'||l_proc,10);
1095: hr_utility.trace('p_parent_offering_id'||p_parent_offering_id);
1096: hr_utility.trace('p_course_start_date'||p_course_start_date);
1097: hr_utility.trace('p_course_end_date'||p_course_end_date);
1098: hr_utility.trace('p_event_status'||p_event_status);
1099: /*
1100: if p_event_status <> 'P' then
1101: if p_course_start_date is null or
1102: p_course_end_date is null then

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

1213: end if;
1214: --
1215: -- added for bug 3619563
1216: --
1217: hr_utility.set_location(' Exiting:'||l_proc,10);
1218: end COURSE_DATES_ARE_VALID;
1219: /*--changes made for eBS by asud
1220: procedure COURSE_DATES_ARE_VALID (p_activity_version_id in number,
1221: p_course_start_date in date,

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

1233: from ota_activity_versions
1234: where activity_version_id = p_activity_version_id;
1235: begin
1236: --
1237: hr_utility.set_location(' Entering:'||l_proc,10);
1238: hr_utility.trace('p_activity_version_id'||p_activity_version_id);
1239: hr_utility.trace('p_course_start_date'||p_course_start_date);
1240: hr_utility.trace('p_course_end_date'||p_course_end_date);
1241: hr_utility.trace('p_event_status'||p_event_status);

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

1234: where activity_version_id = p_activity_version_id;
1235: begin
1236: --
1237: hr_utility.set_location(' Entering:'||l_proc,10);
1238: hr_utility.trace('p_activity_version_id'||p_activity_version_id);
1239: hr_utility.trace('p_course_start_date'||p_course_start_date);
1240: hr_utility.trace('p_course_end_date'||p_course_end_date);
1241: hr_utility.trace('p_event_status'||p_event_status);
1242: if p_event_status <> 'P' then

Line 1239: hr_utility.trace('p_course_start_date'||p_course_start_date);

1235: begin
1236: --
1237: hr_utility.set_location(' Entering:'||l_proc,10);
1238: hr_utility.trace('p_activity_version_id'||p_activity_version_id);
1239: hr_utility.trace('p_course_start_date'||p_course_start_date);
1240: hr_utility.trace('p_course_end_date'||p_course_end_date);
1241: hr_utility.trace('p_event_status'||p_event_status);
1242: if p_event_status <> 'P' then
1243: if p_course_start_date is null or

Line 1240: hr_utility.trace('p_course_end_date'||p_course_end_date);

1236: --
1237: hr_utility.set_location(' Entering:'||l_proc,10);
1238: hr_utility.trace('p_activity_version_id'||p_activity_version_id);
1239: hr_utility.trace('p_course_start_date'||p_course_start_date);
1240: hr_utility.trace('p_course_end_date'||p_course_end_date);
1241: hr_utility.trace('p_event_status'||p_event_status);
1242: if p_event_status <> 'P' then
1243: if p_course_start_date is null or
1244: p_course_end_date is null then

Line 1241: hr_utility.trace('p_event_status'||p_event_status);

1237: hr_utility.set_location(' Entering:'||l_proc,10);
1238: hr_utility.trace('p_activity_version_id'||p_activity_version_id);
1239: hr_utility.trace('p_course_start_date'||p_course_start_date);
1240: hr_utility.trace('p_course_end_date'||p_course_end_date);
1241: hr_utility.trace('p_event_status'||p_event_status);
1242: if p_event_status <> 'P' then
1243: if p_course_start_date is null or
1244: p_course_end_date is null then
1245: fnd_message.set_name('OTA','OTA_13533_EVT_DATES_NULL');

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

1279: fnd_message.set_name('OTA','OTA_13534_EVT_INVALID_DATES');
1280: fnd_message.raise_error;
1281: end if;
1282: --
1283: hr_utility.set_location(' Exiting:'||l_proc,10);
1284: end COURSE_DATES_ARE_VALID;
1285: --
1286: */--changes made for eBS by asud
1287: -- -----------------------------------------------------------------

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

1315: , p_timezone)
1316: not between nvl(p_enrolment_start_date,hr_api.g_sot) and nvl(p_enrolment_end_date +1,hr_api.g_eot);
1317: begin
1318: --
1319: hr_utility.set_location(' Entering:'||l_proc,10);
1320: --
1321: if p_event_type <> 'SESSION' or p_event_type <> 'PROGRAMME' then
1322: --
1323: open check_dates;

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

1330: close check_dates;
1331: --
1332: end if;
1333: --
1334: hr_utility.set_location(' Exiting:'||l_proc,10);
1335: --
1336: end bookings_valid;
1337: --
1338: -- ----------------------------------------------------------------------------

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

1361: where event_id = p_event_id;
1362: --
1363: begin
1364: --
1365: hr_utility.set_location(' Entering:'||l_proc,10);
1366: --
1367: open c_check_dates;
1368: loop
1369: fetch c_check_dates into l_start_date, l_end_date;

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

1397: end loop;
1398: --
1399: close c_check_dates;
1400: --
1401: hr_utility.set_location(' Exiting:'||l_proc,10);
1402: --
1403: end booking_deal_valid;
1404: --
1405: -- ----------------------------------------------------------------------------

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

1433: and event_type = 'SESSION';
1434: */
1435: begin
1436: --
1437: hr_utility.set_location(' Entering:'||l_proc,10);
1438: --
1439: /*
1440: open check_course_null_dates;
1441: fetch check_course_null_dates into l_dummy;

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

1458: fnd_message.set_name('OTA', 'OTA_13482_SESSION_CONFLICT');
1459: fnd_message.raise_error;
1460: end if;
1461: close check_dates;
1462: hr_utility.set_location(' Leaving:'||l_proc,10);
1463: end session_valid;
1464: --------------------------------------------------------------------------------
1465: --
1466: -- ----------------------------------------------------------------------------

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

1496: or (EVT.EVENT_ID <> P_EVENT_ID));
1497: --
1498: begin
1499: --
1500: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
1501: --
1502: -- Check arguments
1503: --
1504: HR_API.MANDATORY_ARG_ERROR (

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

1517: into G_DUMMY;
1518: W_TITLE_IS_UNIQUE := C1%notfound;
1519: close C1;
1520: --
1521: HR_UTILITY.SET_LOCATION (W_PROC, 10);
1522: return W_TITLE_IS_UNIQUE;
1523: --
1524: end UNIQUE_EVENT_TITLE;
1525: --

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

1541: := G_PACKAGE || 'CHECK_TITLE_IS_UNIQUE';
1542: --
1543: begin
1544: --
1545: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
1546: --
1547: -- Do not perform the uniqueness check unless inserting, or updating
1548: -- with a value different from the current value (and not just changing
1549: -- case)

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

1560: end if;
1561: --
1562: end if;
1563: --
1564: HR_UTILITY.SET_LOCATION (' Leaving:' || W_PROC, 10);
1565: --
1566: EXCEPTION
1567: WHEN app_exception.application_exception THEN
1568: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.TITLE') THEN

Line 1569: hr_utility.set_location(' Leaving:'||W_PROC, 40);

1565: --
1566: EXCEPTION
1567: WHEN app_exception.application_exception THEN
1568: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.TITLE') THEN
1569: hr_utility.set_location(' Leaving:'||W_PROC, 40);
1570: RAISE;
1571: END IF;
1572: hr_utility.set_location(' Leaving:'||W_PROC, 50);
1573:

Line 1572: hr_utility.set_location(' Leaving:'||W_PROC, 50);

1568: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.TITLE') THEN
1569: hr_utility.set_location(' Leaving:'||W_PROC, 40);
1570: RAISE;
1571: END IF;
1572: hr_utility.set_location(' Leaving:'||W_PROC, 50);
1573:
1574: end CHECK_TITLE_IS_UNIQUE;
1575: --
1576: -- ----------------------------------------------------------------------------

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

1605: w_proc constant varchar2(72) := G_PACKAGE||'check_session_time';
1606:
1607: BEGIN
1608:
1609: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
1610: --
1611: -- Check parameters
1612: --
1613: HR_API.MANDATORY_ARG_ERROR (

Line 1620: HR_UTILITY.TRACE ('Parent: ' || to_char (P_PARENT_EVENT_ID));

1616: P_ARGUMENT_VALUE => P_PARENT_EVENT_ID);
1617: --
1618: --
1619: --
1620: HR_UTILITY.TRACE ('Parent: ' || to_char (P_PARENT_EVENT_ID));
1621: --bug 3451221
1622: IF (p_session_start_date IS NOT NULL AND
1623: p_session_start_time IS NOT NULL AND
1624: p_session_end_time IS NOT NULL) THEN

Line 1685: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 10);

1681: fnd_message.raise_error;
1682: END IF;
1683: END IF;
1684: END IF;
1685: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 10);
1686:
1687: EXCEPTION
1688: WHEN app_exception.application_exception THEN
1689: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN

Line 1690: hr_utility.set_location(' Leaving:'||w_proc, 60);

1686:
1687: EXCEPTION
1688: WHEN app_exception.application_exception THEN
1689: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN
1690: hr_utility.set_location(' Leaving:'||w_proc, 60);
1691: RAISE;
1692: END IF;
1693: hr_utility.set_location(' Leaving:'||w_proc, 70);
1694: END check_session_time;

Line 1693: hr_utility.set_location(' Leaving:'||w_proc, 70);

1689: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN
1690: hr_utility.set_location(' Leaving:'||w_proc, 60);
1691: RAISE;
1692: END IF;
1693: hr_utility.set_location(' Leaving:'||w_proc, 70);
1694: END check_session_time;
1695:
1696: --------------------------------------------------------------------------------
1697: -- ----------------------------------------------------------------------------

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

1719: L_COURSE_SPANS_SESSIONS boolean;
1720: --
1721: begin
1722: --
1723: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
1724: --
1725: -- Check parameters
1726: --
1727: HR_API.MANDATORY_ARG_ERROR (

Line 1738: HR_UTILITY.TRACE ('Start date: ' || to_char (L_COURSE_START_DATE));

1734: P_PARENT_EVENT_ID,
1735: L_COURSE_START_DATE,
1736: L_COURSE_END_DATE);
1737: --
1738: HR_UTILITY.TRACE ('Start date: ' || to_char (L_COURSE_START_DATE));
1739: HR_UTILITY.TRACE (' End date: ' || to_char (L_COURSE_END_DATE));
1740: --
1741: -- check if course start and end date are null
1742: -- if null then set them to start and end of time

Line 1739: HR_UTILITY.TRACE (' End date: ' || to_char (L_COURSE_END_DATE));

1735: L_COURSE_START_DATE,
1736: L_COURSE_END_DATE);
1737: --
1738: HR_UTILITY.TRACE ('Start date: ' || to_char (L_COURSE_START_DATE));
1739: HR_UTILITY.TRACE (' End date: ' || to_char (L_COURSE_END_DATE));
1740: --
1741: -- check if course start and end date are null
1742: -- if null then set them to start and end of time
1743: --

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

1786: and p_course_end_date;
1787: --
1788: begin
1789: --
1790: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
1791: --
1792: -- Check parameters
1793: --
1794: HR_API.MANDATORY_ARG_ERROR (

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

1804: l_sessions_invalidated := csr_invalid_sessions%found;
1805: close csr_invalid_sessions;
1806: end if;
1807: --
1808: HR_UTILITY.SET_LOCATION (W_PROC,10);
1809: --
1810: return NOT l_sessions_invalidated;
1811: --
1812: end course_dates_span_sessions;

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

1842: w_proc constant varchar2(72) := G_PACKAGE||'check_class_session_times';
1843:
1844: BEGIN
1845:
1846: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
1847: -- --
1848: --
1849: --
1850: HR_UTILITY.TRACE ('Parent: ' || to_char (P_EVENT_ID));

Line 1850: HR_UTILITY.TRACE ('Parent: ' || to_char (P_EVENT_ID));

1846: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
1847: -- --
1848: --
1849: --
1850: HR_UTILITY.TRACE ('Parent: ' || to_char (P_EVENT_ID));
1851:
1852: OPEN get_ssn_times_cr;
1853: LOOP
1854: FETCH get_ssn_times_cr INTO l_ssn_start_date,

Line 1902: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 10);

1898:
1899: END LOOP;
1900: CLOSE get_ssn_times_cr;
1901:
1902: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 10);
1903:
1904: EXCEPTION
1905: WHEN app_exception.application_exception THEN
1906: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN

Line 1907: hr_utility.set_location(' Leaving:'||w_proc, 60);

1903:
1904: EXCEPTION
1905: WHEN app_exception.application_exception THEN
1906: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN
1907: hr_utility.set_location(' Leaving:'||w_proc, 60);
1908: RAISE;
1909: END IF;
1910: hr_utility.set_location(' Leaving:'||w_proc, 70);
1911: END check_class_session_times;

Line 1910: hr_utility.set_location(' Leaving:'||w_proc, 70);

1906: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN
1907: hr_utility.set_location(' Leaving:'||w_proc, 60);
1908: RAISE;
1909: END IF;
1910: hr_utility.set_location(' Leaving:'||w_proc, 70);
1911: END check_class_session_times;
1912:
1913: -- ----------------------------------------------------------------------------
1914: -- -----------------------< CHECK_UPDATED_COURSE_DATES >-----------------------

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

1958: end course_dates_have_changed;
1959: --
1960: begin
1961: --
1962: HR_UTILITY.SET_LOCATION ('Entering:'||W_PROC,5);
1963: --
1964: check_parameters;
1965: --
1966: if course_dates_have_changed

Line 1984: hr_utility.set_location(' Leaving:'||w_proc, 40);

1980: EXCEPTION
1981: WHEN app_exception.application_exception THEN
1982: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_DATE',
1983: p_associated_column2 => 'OTA_EVENTS.COURSE_END_DATE') THEN
1984: hr_utility.set_location(' Leaving:'||w_proc, 40);
1985: RAISE;
1986: END IF;
1987: hr_utility.set_location(' Leaving:'||w_proc, 50);
1988:

Line 1987: hr_utility.set_location(' Leaving:'||w_proc, 50);

1983: p_associated_column2 => 'OTA_EVENTS.COURSE_END_DATE') THEN
1984: hr_utility.set_location(' Leaving:'||w_proc, 40);
1985: RAISE;
1986: END IF;
1987: hr_utility.set_location(' Leaving:'||w_proc, 50);
1988:
1989: end check_updated_course_dates;
1990: --
1991: -- ----------------------------------------------------------------------------

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

1999: --
2000: v_proc varchar2(72) := g_package||'check_cost_vals';
2001: begin
2002: --
2003: hr_utility.set_location('Entering:'|| v_proc, 5);
2004: --
2005: if (p_budget_cost is not null or p_actual_cost is not null) and
2006: p_budget_currency_code is null then
2007: --

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

2009: fnd_message.raise_error;
2010: --
2011: end if;
2012: --
2013: hr_utility.set_location(' Leaving:'|| v_proc, 10);
2014: --
2015: EXCEPTION
2016: WHEN app_exception.application_exception THEN
2017: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.BUDGET_COST',

Line 2020: hr_utility.set_location(' Leaving:'||v_proc, 40);

2016: WHEN app_exception.application_exception THEN
2017: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.BUDGET_COST',
2018: p_associated_column2 => 'OTA_EVENTS.BUDGET_CURRENCY_CODE',
2019: p_associated_column3 => 'OTA_EVENTS.ACTUAL_COST') THEN
2020: hr_utility.set_location(' Leaving:'||v_proc, 40);
2021: RAISE;
2022: END IF;
2023: hr_utility.set_location(' Leaving:'||v_proc, 50);
2024: end check_cost_vals;

Line 2023: hr_utility.set_location(' Leaving:'||v_proc, 50);

2019: p_associated_column3 => 'OTA_EVENTS.ACTUAL_COST') THEN
2020: hr_utility.set_location(' Leaving:'||v_proc, 40);
2021: RAISE;
2022: END IF;
2023: hr_utility.set_location(' Leaving:'||v_proc, 50);
2024: end check_cost_vals;
2025: --
2026: -- ----------------------------------------------------------------------------
2027: -- ------------------------< CHECK_SESSION_WITHIN_COURSE >---------------------

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

2042: := G_PACKAGE || 'CHECK_SESSION_WITHIN_COURSE';
2043: --
2044: begin
2045: --
2046: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
2047: --
2048: -- Check parameters
2049: --
2050: HR_API.MANDATORY_ARG_ERROR (

Line 2064: HR_UTILITY.TRACE ('Parent: ' || to_char (P_PARENT_EVENT_ID));

2060: --
2061: if not ( (OTA_EVT_SHD.API_UPDATING (P_EVENT_ID, P_OBJECT_VERSION_NUMBER))
2062: and (OTA_EVT_SHD.G_OLD_REC.COURSE_START_DATE = P_COURSE_START_DATE)) then
2063: --
2064: HR_UTILITY.TRACE ('Parent: ' || to_char (P_PARENT_EVENT_ID));
2065: --
2066: if ( (P_EVENT_TYPE = 'SESSION')
2067: and (not COURSE_DATES_SPAN_SESSIONS (
2068: P_PARENT_EVENT_ID => P_PARENT_EVENT_ID,

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

2071: end if;
2072: --
2073: end if;
2074: --
2075: HR_UTILITY.SET_LOCATION (' Leaving:' || W_PROC, 10);
2076: --
2077: EXCEPTION
2078: WHEN app_exception.application_exception THEN
2079: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_DATE') THEN

Line 2080: hr_utility.set_location(' Leaving:'||w_proc, 40);

2076: --
2077: EXCEPTION
2078: WHEN app_exception.application_exception THEN
2079: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_DATE') THEN
2080: hr_utility.set_location(' Leaving:'||w_proc, 40);
2081: RAISE;
2082: END IF;
2083: hr_utility.set_location(' Leaving:'||w_proc, 50);
2084: end CHECK_SESSION_WITHIN_COURSE;

Line 2083: hr_utility.set_location(' Leaving:'||w_proc, 50);

2079: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_DATE') THEN
2080: hr_utility.set_location(' Leaving:'||w_proc, 40);
2081: RAISE;
2082: END IF;
2083: hr_utility.set_location(' Leaving:'||w_proc, 50);
2084: end CHECK_SESSION_WITHIN_COURSE;
2085: --
2086: -- ----------------------------------------------------------------------------
2087: -- -----------------------< VALID_PARENT_EVENT >-------------------------------

Line 2105: HR_UTILITY.SET_LOCATION ('Entering:' || G_PACKAGE || 'VALID_PARENT_EVENT', 5);

2101: W_VALID_PARENT boolean;
2102: --
2103: begin
2104: --
2105: HR_UTILITY.SET_LOCATION ('Entering:' || G_PACKAGE || 'VALID_PARENT_EVENT', 5);
2106: --
2107: -- Check parameters
2108: --
2109: HR_API.MANDATORY_ARG_ERROR (

Line 2128: HR_UTILITY.TRACE ('Parent exists: True');

2124: P_EVENT_ID => P_PARENT_EVENT_ID,
2125: P_EVENT_EXISTS => W_PARENT_ID_EXISTS);
2126: --
2127: if (W_PARENT_ID_EXISTS) then
2128: HR_UTILITY.TRACE ('Parent exists: True');
2129: else
2130: HR_UTILITY.TRACE ('Parent exists: Fales');
2131: end if;
2132: HR_UTILITY.TRACE ('Business grps: ' || to_char (P_BUSINESS_GROUP_ID)

Line 2130: HR_UTILITY.TRACE ('Parent exists: Fales');

2126: --
2127: if (W_PARENT_ID_EXISTS) then
2128: HR_UTILITY.TRACE ('Parent exists: True');
2129: else
2130: HR_UTILITY.TRACE ('Parent exists: Fales');
2131: end if;
2132: HR_UTILITY.TRACE ('Business grps: ' || to_char (P_BUSINESS_GROUP_ID)
2133: || '/' || to_char (G_FETCHED_REC.BUSINESS_GROUP_ID));
2134: HR_UTILITY.TRACE ('Types: ' || P_EVENT_TYPE

Line 2132: HR_UTILITY.TRACE ('Business grps: ' || to_char (P_BUSINESS_GROUP_ID)

2128: HR_UTILITY.TRACE ('Parent exists: True');
2129: else
2130: HR_UTILITY.TRACE ('Parent exists: Fales');
2131: end if;
2132: HR_UTILITY.TRACE ('Business grps: ' || to_char (P_BUSINESS_GROUP_ID)
2133: || '/' || to_char (G_FETCHED_REC.BUSINESS_GROUP_ID));
2134: HR_UTILITY.TRACE ('Types: ' || P_EVENT_TYPE
2135: || '/' || G_FETCHED_REC.EVENT_TYPE);
2136: W_VALID_PARENT :=

Line 2134: HR_UTILITY.TRACE ('Types: ' || P_EVENT_TYPE

2130: HR_UTILITY.TRACE ('Parent exists: Fales');
2131: end if;
2132: HR_UTILITY.TRACE ('Business grps: ' || to_char (P_BUSINESS_GROUP_ID)
2133: || '/' || to_char (G_FETCHED_REC.BUSINESS_GROUP_ID));
2134: HR_UTILITY.TRACE ('Types: ' || P_EVENT_TYPE
2135: || '/' || G_FETCHED_REC.EVENT_TYPE);
2136: W_VALID_PARENT :=
2137: (W_PARENT_ID_EXISTS)
2138: and (P_BUSINESS_GROUP_ID

Line 2152: HR_UTILITY.SET_LOCATION ( ' Leaving:' || G_PACKAGE || 'VALID_PARENT_EVENT', 10);

2148: = 'PROGRAMME')));
2149: --
2150: end if;
2151: --
2152: HR_UTILITY.SET_LOCATION ( ' Leaving:' || G_PACKAGE || 'VALID_PARENT_EVENT', 10);
2153: return W_VALID_PARENT;
2154: --
2155: end VALID_PARENT_EVENT;
2156: --

Line 2170: HR_UTILITY.SET_LOCATION (

2166: P_OBJECT_VERSION_NUMBER in number default null
2167: ) is
2168: begin
2169: --
2170: HR_UTILITY.SET_LOCATION (
2171: 'Entering:' || G_PACKAGE || 'CHECK_PARENT_EVENT_IS_VALID',
2172: 5);
2173: --
2174: if ( (P_PARENT_EVENT_ID is not null )

Line 2187: HR_UTILITY.SET_LOCATION (

2183: end if;
2184: --
2185: end if;
2186: --
2187: HR_UTILITY.SET_LOCATION (
2188: ' Leaving:' || G_PACKAGE || 'CHECK_PARENT_EVENT_IS_VALID',
2189: 10);
2190: --
2191: end CHECK_PARENT_EVENT_IS_VALID;

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

2337: from ota_event_associations
2338: where event_id = p_event_id;
2339: --
2340: begin
2341: hr_utility.set_location ('Entering:'||l_proc,5);
2342: --
2343: if p_event_id is not null and
2344: l_price_basis_changed then
2345: --

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

2362: close get_event_associations;
2363: --
2364: end if;
2365: --
2366: hr_utility.set_location ('Leaving:'||l_proc,10);
2367: EXCEPTION
2368: WHEN app_exception.application_exception THEN
2369: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PRICE_BASIS') THEN
2370: hr_utility.set_location(' Leaving:'||l_proc, 40);

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

2366: hr_utility.set_location ('Leaving:'||l_proc,10);
2367: EXCEPTION
2368: WHEN app_exception.application_exception THEN
2369: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PRICE_BASIS') THEN
2370: hr_utility.set_location(' Leaving:'||l_proc, 40);
2371: RAISE;
2372: END IF;
2373: hr_utility.set_location(' Leaving:'||l_proc, 50);
2374: end price_basis_change;

Line 2373: hr_utility.set_location(' Leaving:'||l_proc, 50);

2369: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PRICE_BASIS') THEN
2370: hr_utility.set_location(' Leaving:'||l_proc, 40);
2371: RAISE;
2372: END IF;
2373: hr_utility.set_location(' Leaving:'||l_proc, 50);
2374: end price_basis_change;
2375: --
2376: -- ----------------------------------------------------------------------------
2377: -- -------------------------< check_timezone >-----------------------------

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

2488:
2489: --
2490: begin
2491: --
2492: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
2493: --
2494: -- Check only non-static domains (constraints trap the static ones)
2495: --
2496: OTA_GENERAL.CHECK_DOMAIN_VALUE (

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

2763: check_timezone(p_rec.timezone);
2764: END IF;
2765:
2766:
2767: HR_UTILITY.SET_LOCATION (' Leaving:' || W_PROC, 10);
2768: --
2769: end VALIDITY_CHECKS;
2770: --
2771: -- ----------------------------------------------------------------------------

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

2867: l_proc varchar2(72) := g_package||'check_child_entities';
2868: l_dummy varchar2(1);
2869: --
2870: Begin
2871: hr_utility.set_location('Entering:'||l_proc, 5);
2872: --
2873: -- Determine if the event has training_plan_cost records
2874: open c_get_tpc_rows;
2875: fetch c_get_tpc_rows into l_dummy;

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

3036: end if;
3037: close c_conference_details;
3038:
3039:
3040: hr_utility.set_location(' Leaving:'||l_proc, 10);
3041: EXCEPTION
3042: WHEN app_exception.application_exception THEN
3043: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.EVENT_ID') THEN
3044: hr_utility.set_location(' Leaving:'||l_proc, 70);

Line 3044: hr_utility.set_location(' Leaving:'||l_proc, 70);

3040: hr_utility.set_location(' Leaving:'||l_proc, 10);
3041: EXCEPTION
3042: WHEN app_exception.application_exception THEN
3043: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.EVENT_ID') THEN
3044: hr_utility.set_location(' Leaving:'||l_proc, 70);
3045: RAISE;
3046: END IF;
3047: hr_utility.set_location(' Leaving:'||l_proc, 80);
3048: End check_child_entities;

Line 3047: hr_utility.set_location(' Leaving:'||l_proc, 80);

3043: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.EVENT_ID') THEN
3044: hr_utility.set_location(' Leaving:'||l_proc, 70);
3045: RAISE;
3046: END IF;
3047: hr_utility.set_location(' Leaving:'||l_proc, 80);
3048: End check_child_entities;
3049: --
3050: --
3051: -- ----------------------------------------------------------------------------

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

3072: and tfl.cancelled_flag = 'N';
3073: --
3074: begin
3075: --
3076: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
3077: --
3078: open csr_st_finance_lines;
3079: fetch csr_st_finance_lines into g_dummy;
3080: l_st_finance_lines := csr_st_finance_lines%found;

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

3079: fetch csr_st_finance_lines into g_dummy;
3080: l_st_finance_lines := csr_st_finance_lines%found;
3081: close csr_st_finance_lines;
3082: --
3083: HR_UTILITY.SET_LOCATION (W_PROC,10);
3084: --
3085: return l_st_finance_lines;
3086: --
3087: end check_for_st_finance_lines;

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

3126:
3127:
3128: Begin
3129: --
3130: hr_utility.set_location('Entering:'||l_proc, 5);
3131: --
3132:
3133: if (((p_event_id is not null) and
3134: nvl(ota_evt_shd.g_old_rec.owner_id,hr_api.g_number) <>

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

3137:
3138: IF p_owner_id is not null then
3139:
3140: If l_single_business_group_id is not null then
3141: hr_utility.set_location('Entering:'||l_proc, 10);
3142: OPEN c_people_cross;
3143: FETCH c_people_cross into l_exist;
3144: if c_people_cross%notfound then
3145: close c_people_cross;

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

3147: fnd_message.raise_error;
3148: end if;
3149: close c_people_cross;
3150: else
3151: hr_utility.set_location('Entering:'||l_proc, 20);
3152: OPEN c_people;
3153: FETCH c_people into l_exist;
3154: if c_people%notfound then
3155: close c_people;

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

3157: fnd_message.raise_error;
3158: end if;
3159: close c_people;
3160: end if;
3161: hr_utility.set_location('Leaving:'||l_proc, 40);
3162: END IF;
3163: End if;
3164: EXCEPTION
3165: WHEN app_exception.application_exception THEN

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

3163: End if;
3164: EXCEPTION
3165: WHEN app_exception.application_exception THEN
3166: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.OWNER_ID') THEN
3167: hr_utility.set_location(' Leaving:'||l_proc, 40);
3168: RAISE;
3169: END IF;
3170: hr_utility.set_location(' Leaving:'||l_proc, 50);
3171: end check_owner_id;

Line 3170: hr_utility.set_location(' Leaving:'||l_proc, 50);

3166: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.OWNER_ID') THEN
3167: hr_utility.set_location(' Leaving:'||l_proc, 40);
3168: RAISE;
3169: END IF;
3170: hr_utility.set_location(' Leaving:'||l_proc, 50);
3171: end check_owner_id;
3172:
3173: -- ----------------------------------------------------------------------------
3174: -- |---------------------------< check_line_id >---------------------------|

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

3190: from oe_order_lines_all
3191: where line_id = p_line_id;
3192:
3193: Begin
3194: hr_utility.set_location('Entering:'||l_proc, 5);
3195:
3196: if (((p_event_id is not null) and
3197: nvl(ota_evt_shd.g_old_rec.line_id,hr_api.g_number) <>
3198: nvl(p_line_id,hr_api.g_number))

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

3197: nvl(ota_evt_shd.g_old_rec.line_id,hr_api.g_number) <>
3198: nvl(p_line_id,hr_api.g_number))
3199: or (p_event_id is null)) then
3200: --
3201: hr_utility.set_location('Entering:'||l_proc, 10);
3202: if (p_line_id is not null) then
3203: hr_utility.set_location('Entering:'||l_proc, 15);
3204: open csr_order_line;
3205: fetch csr_order_line into l_exists;

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

3199: or (p_event_id is null)) then
3200: --
3201: hr_utility.set_location('Entering:'||l_proc, 10);
3202: if (p_line_id is not null) then
3203: hr_utility.set_location('Entering:'||l_proc, 15);
3204: open csr_order_line;
3205: fetch csr_order_line into l_exists;
3206: if csr_order_line%notfound then
3207: close csr_order_line;

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

3208: fnd_message.set_name('OTA','OTA_13888_TDB_LINE_INVALID');
3209: fnd_message.raise_error;
3210: end if;
3211: close csr_order_line;
3212: hr_utility.set_location('Entering:'||l_proc, 20);
3213: end if;
3214: end if;
3215: hr_utility.set_location('Entering:'||l_proc, 30);
3216: EXCEPTION

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

3211: close csr_order_line;
3212: hr_utility.set_location('Entering:'||l_proc, 20);
3213: end if;
3214: end if;
3215: hr_utility.set_location('Entering:'||l_proc, 30);
3216: EXCEPTION
3217: WHEN app_exception.application_exception THEN
3218: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LINE_ID') THEN
3219: hr_utility.set_location(' Leaving:'||l_proc, 40);

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

3215: hr_utility.set_location('Entering:'||l_proc, 30);
3216: EXCEPTION
3217: WHEN app_exception.application_exception THEN
3218: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LINE_ID') THEN
3219: hr_utility.set_location(' Leaving:'||l_proc, 40);
3220: RAISE;
3221: END IF;
3222: hr_utility.set_location(' Leaving:'||l_proc, 50);
3223: end check_line_id;

Line 3222: hr_utility.set_location(' Leaving:'||l_proc, 50);

3218: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LINE_ID') THEN
3219: hr_utility.set_location(' Leaving:'||l_proc, 40);
3220: RAISE;
3221: END IF;
3222: hr_utility.set_location(' Leaving:'||l_proc, 50);
3223: end check_line_id;
3224:
3225: -- ----------------------------------------------------------------------------
3226: -- |---------------------------< chk_status_changed >----------------------|

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

3255: l_err_msg VARCHAR2(1000) := '';
3256:
3257: --
3258: Begin
3259: hr_utility.set_location('Entering:'||l_proc, 5);
3260: --
3261: IF p_line_id is not null THEN
3262: IF l_event_status_changed THEN
3263: IF p_event_status = 'A' THEN

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

3261: IF p_line_id is not null THEN
3262: IF l_event_status_changed THEN
3263: IF p_event_status = 'A' THEN
3264:
3265: hr_utility.set_location('Entering:'||l_proc, 10);
3266:
3267: ota_utility.check_invoice(
3268: p_line_id => p_line_id,
3269: p_org_id => p_org_id,

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

3271: IF fnd_installation.get(660, 660, l_ins_status, l_industry) THEN
3272: BEGIN
3273: IF l_exist = 'Y' THEN
3274: Begin
3275: hr_utility.set_location('Entering:'||l_proc, 15);
3276:
3277: /* l_dynamicSqlString := '
3278: ota_om_upd_api.create_rma(
3279: :p_Line_id,

Line 3286: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

3282: USING IN p_line_id,
3283: IN p_org_id;*/
3284: ota_om_upd_api.create_rma(p_line_id,p_org_id);
3285: exception when others then
3286: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3287: hr_utility.set_message_token('PROCEDURE', l_proc);
3288: hr_utility.set_message_token('STEP','15');
3289: hr_utility.raise_error;
3290:

Line 3287: hr_utility.set_message_token('PROCEDURE', l_proc);

3283: IN p_org_id;*/
3284: ota_om_upd_api.create_rma(p_line_id,p_org_id);
3285: exception when others then
3286: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3287: hr_utility.set_message_token('PROCEDURE', l_proc);
3288: hr_utility.set_message_token('STEP','15');
3289: hr_utility.raise_error;
3290:
3291: End;

Line 3288: hr_utility.set_message_token('STEP','15');

3284: ota_om_upd_api.create_rma(p_line_id,p_org_id);
3285: exception when others then
3286: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3287: hr_utility.set_message_token('PROCEDURE', l_proc);
3288: hr_utility.set_message_token('STEP','15');
3289: hr_utility.raise_error;
3290:
3291: End;
3292: ELSE

Line 3289: hr_utility.raise_error;

3285: exception when others then
3286: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3287: hr_utility.set_message_token('PROCEDURE', l_proc);
3288: hr_utility.set_message_token('STEP','15');
3289: hr_utility.raise_error;
3290:
3291: End;
3292: ELSE
3293: Begin

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

3290:
3291: End;
3292: ELSE
3293: Begin
3294: hr_utility.set_location('Entering:'||l_proc, 20);
3295: /*l_dynamicSqlString := '
3296: ota_om_upd_api.cancel_order(
3297: p_Line_id,
3298: p_org_id);' ;

Line 3304: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');

3300: USING IN p_line_id,
3301: IN p_org_id;*/
3302: ota_om_upd_api.cancel_order(p_line_id,p_org_id);
3303: exception when others then
3304: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3305: hr_utility.set_message_token('PROCEDURE', l_proc);
3306: hr_utility.set_message_token('STEP','20');
3307: hr_utility.raise_error;
3308:

Line 3305: hr_utility.set_message_token('PROCEDURE', l_proc);

3301: IN p_org_id;*/
3302: ota_om_upd_api.cancel_order(p_line_id,p_org_id);
3303: exception when others then
3304: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3305: hr_utility.set_message_token('PROCEDURE', l_proc);
3306: hr_utility.set_message_token('STEP','20');
3307: hr_utility.raise_error;
3308:
3309: End;

Line 3306: hr_utility.set_message_token('STEP','20');

3302: ota_om_upd_api.cancel_order(p_line_id,p_org_id);
3303: exception when others then
3304: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3305: hr_utility.set_message_token('PROCEDURE', l_proc);
3306: hr_utility.set_message_token('STEP','20');
3307: hr_utility.raise_error;
3308:
3309: End;
3310:

Line 3307: hr_utility.raise_error;

3303: exception when others then
3304: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3305: hr_utility.set_message_token('PROCEDURE', l_proc);
3306: hr_utility.set_message_token('STEP','20');
3307: hr_utility.raise_error;
3308:
3309: End;
3310:
3311: END IF;

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

3329: END IF;
3330: END IF;
3331:
3332:
3333: hr_utility.set_location('Leaving:'||l_proc, 10);
3334: /*EXCEPTION WHEN OTHERS
3335: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;*/
3336:
3337: end chk_status_changed;

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

3351: l_proc varchar2(72) := g_package||'chk_order_line_exist';
3352:
3353:
3354: Begin
3355: hr_utility.set_location('Entering:'||l_proc, 5);
3356:
3357: if p_line_id is not null then
3358: fnd_message.set_name('OTA','OTA_13896_EVT_ORDER_LINE_EXIST');
3359: fnd_message.raise_error;

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

3356:
3357: if p_line_id is not null then
3358: fnd_message.set_name('OTA','OTA_13896_EVT_ORDER_LINE_EXIST');
3359: fnd_message.raise_error;
3360: hr_utility.set_location('Entering:'||l_proc, 20);
3361:
3362: end if;
3363: hr_utility.set_location('Leaving:'||l_proc, 30);
3364: EXCEPTION

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

3359: fnd_message.raise_error;
3360: hr_utility.set_location('Entering:'||l_proc, 20);
3361:
3362: end if;
3363: hr_utility.set_location('Leaving:'||l_proc, 30);
3364: EXCEPTION
3365: WHEN app_exception.application_exception THEN
3366: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LINE_ID') THEN
3367: hr_utility.set_location(' Leaving:'||l_proc, 40);

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

3363: hr_utility.set_location('Leaving:'||l_proc, 30);
3364: EXCEPTION
3365: WHEN app_exception.application_exception THEN
3366: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LINE_ID') THEN
3367: hr_utility.set_location(' Leaving:'||l_proc, 40);
3368: RAISE;
3369: END IF;
3370: hr_utility.set_location(' Leaving:'||l_proc, 50);
3371: end chk_order_line_exist;

Line 3370: hr_utility.set_location(' Leaving:'||l_proc, 50);

3366: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LINE_ID') THEN
3367: hr_utility.set_location(' Leaving:'||l_proc, 40);
3368: RAISE;
3369: END IF;
3370: hr_utility.set_location(' Leaving:'||l_proc, 50);
3371: end chk_order_line_exist;
3372:
3373:
3374: -- ----------------------------------------------------------------------------

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

3395: From HR_ALL_ORGANIZATION_UNITS
3396: Where organization_id = p_training_center_id;
3397:
3398: Begin
3399: hr_utility.set_location('Entering:'||l_proc, 5);
3400: if (((p_event_id is not null) and
3401: nvl(ota_evt_shd.g_old_rec.training_center_id,hr_api.g_number) <>
3402: nvl(p_training_center_id,hr_api.g_number))
3403: or (p_event_id is null)) then

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

3401: nvl(ota_evt_shd.g_old_rec.training_center_id,hr_api.g_number) <>
3402: nvl(p_training_center_id,hr_api.g_number))
3403: or (p_event_id is null)) then
3404: --
3405: hr_utility.set_location('Entering:'||l_proc, 10);
3406: if (p_training_center_id is not null) then
3407: hr_utility.set_location('Entering:'||l_proc, 15);
3408: open c_training_center;
3409: fetch c_training_center into l_exists;

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

3403: or (p_event_id is null)) then
3404: --
3405: hr_utility.set_location('Entering:'||l_proc, 10);
3406: if (p_training_center_id is not null) then
3407: hr_utility.set_location('Entering:'||l_proc, 15);
3408: open c_training_center;
3409: fetch c_training_center into l_exists;
3410: if c_training_center%notfound then
3411: close c_training_center;

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

3412: fnd_message.set_name('OTA','OTA_13907_TSR_TRNCTR_NOT_EXIST');
3413: fnd_message.raise_error;
3414: end if;
3415: close c_training_center;
3416: hr_utility.set_location('Entering:'||l_proc, 20);
3417: end if;
3418: end if;
3419: hr_utility.set_location('Entering:'||l_proc, 30);
3420: EXCEPTION

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

3415: close c_training_center;
3416: hr_utility.set_location('Entering:'||l_proc, 20);
3417: end if;
3418: end if;
3419: hr_utility.set_location('Entering:'||l_proc, 30);
3420: EXCEPTION
3421: WHEN app_exception.application_exception THEN
3422: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.TRAINING_CENTER_ID') THEN
3423: hr_utility.set_location(' Leaving:'||l_proc, 40);

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

3419: hr_utility.set_location('Entering:'||l_proc, 30);
3420: EXCEPTION
3421: WHEN app_exception.application_exception THEN
3422: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.TRAINING_CENTER_ID') THEN
3423: hr_utility.set_location(' Leaving:'||l_proc, 40);
3424: RAISE;
3425: END IF;
3426: hr_utility.set_location(' Leaving:'||l_proc, 50);
3427: end;

Line 3426: hr_utility.set_location(' Leaving:'||l_proc, 50);

3422: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.TRAINING_CENTER_ID') THEN
3423: hr_utility.set_location(' Leaving:'||l_proc, 40);
3424: RAISE;
3425: END IF;
3426: hr_utility.set_location(' Leaving:'||l_proc, 50);
3427: end;
3428:
3429: -- ----------------------------------------------------------------------------
3430: -- |-----------------------------< chk_location >---------------------------|

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

3452: Where loc.location_id = p_location_id
3453: and nvl(loc.inactive_date,to_date('31-12-4712','DD-MM-YYYY')) >= nvl(p_course_end_date,sysdate);
3454:
3455: Begin
3456: hr_utility.set_location('Entering:'||l_proc, 5);
3457:
3458: if (((p_event_id is not null) and
3459: nvl(ota_evt_shd.g_old_rec.location_id,hr_api.g_number) <>
3460: nvl(p_location_id,hr_api.g_number))

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

3459: nvl(ota_evt_shd.g_old_rec.location_id,hr_api.g_number) <>
3460: nvl(p_location_id,hr_api.g_number))
3461: or (p_event_id is null)) then
3462: --
3463: hr_utility.set_location('Entering:'||l_proc, 10);
3464: if (p_location_id is not null) then
3465: hr_utility.set_location('Entering:'||l_proc, 15);
3466: open c_location;
3467: fetch c_location into l_exists;

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

3461: or (p_event_id is null)) then
3462: --
3463: hr_utility.set_location('Entering:'||l_proc, 10);
3464: if (p_location_id is not null) then
3465: hr_utility.set_location('Entering:'||l_proc, 15);
3466: open c_location;
3467: fetch c_location into l_exists;
3468: if c_location%notfound then
3469: close c_location;

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

3470: fnd_message.set_name('OTA','OTA_13908_TSR_LOC_NOT_EXIST');
3471: fnd_message.raise_error;
3472: end if;
3473: close c_location;
3474: hr_utility.set_location('Entering:'||l_proc, 20);
3475: end if;
3476: end if;
3477: hr_utility.set_location('Entering:'||l_proc, 30);
3478: EXCEPTION

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

3473: close c_location;
3474: hr_utility.set_location('Entering:'||l_proc, 20);
3475: end if;
3476: end if;
3477: hr_utility.set_location('Entering:'||l_proc, 30);
3478: EXCEPTION
3479: WHEN app_exception.application_exception THEN
3480: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LOCATION_ID') THEN
3481: hr_utility.set_location(' Leaving:'||l_proc, 40);

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

3477: hr_utility.set_location('Entering:'||l_proc, 30);
3478: EXCEPTION
3479: WHEN app_exception.application_exception THEN
3480: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LOCATION_ID') THEN
3481: hr_utility.set_location(' Leaving:'||l_proc, 40);
3482: RAISE;
3483: END IF;
3484: hr_utility.set_location(' Leaving:'||l_proc, 50);
3485: end;

Line 3484: hr_utility.set_location(' Leaving:'||l_proc, 50);

3480: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LOCATION_ID') THEN
3481: hr_utility.set_location(' Leaving:'||l_proc, 40);
3482: RAISE;
3483: END IF;
3484: hr_utility.set_location(' Leaving:'||l_proc, 50);
3485: end;
3486:
3487: --
3488: -- ----------------------------------------------------------------------------

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

3512: where offering_id = p_offering_id;
3513:
3514: Begin
3515:
3516: hr_utility.set_location('Entering:'||l_proc, 5);
3517:
3518: if (((p_event_id is not null) and
3519: nvl(ota_evt_shd.g_old_rec.offering_id,hr_api.g_number) <>
3520: nvl(p_offering_id,hr_api.g_number))

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

3519: nvl(ota_evt_shd.g_old_rec.offering_id,hr_api.g_number) <>
3520: nvl(p_offering_id,hr_api.g_number))
3521: or (p_event_id is null)) then
3522: --
3523: hr_utility.set_location('Entering:'||l_proc, 10);
3524: if (p_offering_id is not null) then
3525: hr_utility.set_location('Entering:'||l_proc, 15);
3526: open csr_offering;
3527: fetch csr_offering into l_exists;

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

3521: or (p_event_id is null)) then
3522: --
3523: hr_utility.set_location('Entering:'||l_proc, 10);
3524: if (p_offering_id is not null) then
3525: hr_utility.set_location('Entering:'||l_proc, 15);
3526: open csr_offering;
3527: fetch csr_offering into l_exists;
3528: if csr_offering%found then
3529: ota_evt_shd.constraint_error(p_constraint_name =>'OTA_EVENTS_UK4');

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

3528: if csr_offering%found then
3529: ota_evt_shd.constraint_error(p_constraint_name =>'OTA_EVENTS_UK4');
3530: end if;
3531: close csr_offering;
3532: hr_utility.set_location('Leaving:'||l_proc, 20);
3533: end if;
3534: end if;
3535: hr_utility.set_location('Leaving:'||l_proc, 30);
3536: EXCEPTION

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

3531: close csr_offering;
3532: hr_utility.set_location('Leaving:'||l_proc, 20);
3533: end if;
3534: end if;
3535: hr_utility.set_location('Leaving:'||l_proc, 30);
3536: EXCEPTION
3537: WHEN app_exception.application_exception THEN
3538: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.OFFERING_ID') THEN
3539: hr_utility.set_location(' Leaving:'||l_proc, 70);

Line 3539: hr_utility.set_location(' Leaving:'||l_proc, 70);

3535: hr_utility.set_location('Leaving:'||l_proc, 30);
3536: EXCEPTION
3537: WHEN app_exception.application_exception THEN
3538: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.OFFERING_ID') THEN
3539: hr_utility.set_location(' Leaving:'||l_proc, 70);
3540: RAISE;
3541: END IF;
3542: hr_utility.set_location(' Leaving:'||l_proc, 80);
3543: End;

Line 3542: hr_utility.set_location(' Leaving:'||l_proc, 80);

3538: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.OFFERING_ID') THEN
3539: hr_utility.set_location(' Leaving:'||l_proc, 70);
3540: RAISE;
3541: END IF;
3542: hr_utility.set_location(' Leaving:'||l_proc, 80);
3543: End;
3544:
3545: --
3546: -- ----------------------------------------------------------------------------

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

3572: AND act.activity_version_id = p_activity_version_id;
3573:
3574: Begin
3575:
3576: hr_utility.set_location('Entering:'||l_proc, 5);
3577: open csr_offering;
3578: fetch csr_offering into l_exists;
3579: if csr_offering%notfound then
3580: close csr_offering;

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

3581: fnd_message.set_name('OTA','OTA_443321_EVT_OFF_INVALID_ACT');
3582: fnd_message.raise_error;
3583: end if;
3584: close csr_offering;
3585: hr_utility.set_location('Leaving:'||l_proc, 20);
3586: EXCEPTION
3587: WHEN app_exception.application_exception THEN
3588: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.ACTIVITY_VERSION_ID') THEN
3589: hr_utility.set_location(' Leaving:'||l_proc, 70);

Line 3589: hr_utility.set_location(' Leaving:'||l_proc, 70);

3585: hr_utility.set_location('Leaving:'||l_proc, 20);
3586: EXCEPTION
3587: WHEN app_exception.application_exception THEN
3588: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.ACTIVITY_VERSION_ID') THEN
3589: hr_utility.set_location(' Leaving:'||l_proc, 70);
3590: RAISE;
3591: END IF;
3592: hr_utility.set_location(' Leaving:'||l_proc, 80);
3593: End chk_activity_version_id;

Line 3592: hr_utility.set_location(' Leaving:'||l_proc, 80);

3588: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.ACTIVITY_VERSION_ID') THEN
3589: hr_utility.set_location(' Leaving:'||l_proc, 70);
3590: RAISE;
3591: END IF;
3592: hr_utility.set_location(' Leaving:'||l_proc, 80);
3593: End chk_activity_version_id;
3594:
3595: --
3596: -- ----------------------------------------------------------------------------

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

3621: AND trunc(sysdate) BETWEEN p.effective_start_date AND p.effective_end_date
3622: AND f.user_id = to_number(fnd_profile.value('USER_ID'));
3623:
3624: BEGIN
3625: hr_utility.set_location('Entering:'||l_proc, 5);
3626:
3627: OPEN csr_org;
3628: FETCH csr_org INTO l_username;
3629: if csr_org%notfound then

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

3642: fnd_message.set_name('OTA', 'OTA_EVT_SECURE');
3643: fnd_message.raise_error;
3644: END IF;
3645: CLOSE csr_org;*/
3646: hr_utility.set_location('Leaving:'||l_proc, 20);
3647:
3648: EXCEPTION
3649: WHEN app_exception.application_exception THEN
3650: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.SECURE_EVENT_FLAG') THEN

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

3647:
3648: EXCEPTION
3649: WHEN app_exception.application_exception THEN
3650: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.SECURE_EVENT_FLAG') THEN
3651: hr_utility.set_location('Leaving:'||l_proc, 40);
3652: RAISE;
3653: END IF;
3654: hr_utility.set_location('Leaving:'||l_proc, 50);
3655: END chk_secure_event_flag;

Line 3654: hr_utility.set_location('Leaving:'||l_proc, 50);

3650: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.SECURE_EVENT_FLAG') THEN
3651: hr_utility.set_location('Leaving:'||l_proc, 40);
3652: RAISE;
3653: END IF;
3654: hr_utility.set_location('Leaving:'||l_proc, 50);
3655: END chk_secure_event_flag;
3656: --
3657: -- ----------------------------------------------------------------------------
3658: -- |---------------------------< insert_validate >----------------------------|

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

3663: l_proc varchar2(72) := g_package||'insert_validate';
3664: --
3665: Begin
3666: --
3667: hr_utility.set_location('Entering:'||l_proc, 5);
3668: --modified for eBS by asud
3669: /*
3670: -- Call all supporting business operations
3671: --

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

3673: --
3674: VALIDITY_CHECKS (
3675: P_REC => P_REC);
3676: --
3677: hr_utility.set_location(' Leaving:'||l_proc, 10);
3678: --*/
3679: --modified for eBS by asud
3680: -- Call all supporting business operations
3681: -- Validate Important Attributes

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

3694: -- bug 4348022
3695:
3696: ota_evt_bus.chk_ddf(p_rec);
3697: --
3698: hr_utility.set_location(' Leaving:'||l_proc, 10);
3699:
3700: End insert_validate;
3701: --
3702: -- ----------------------------------------------------------------------------

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

3712: := ota_general.value_changed(ota_evt_shd.g_old_rec.organization_id, p_rec.organization_id);
3713: --
3714: Begin
3715: --
3716: hr_utility.set_location('Entering:'||l_proc, 5);
3717: --
3718: -- Call all supporting business operations
3719: --
3720: /*

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

3722: --
3723: VALIDITY_CHECKS (
3724: P_REC => P_REC);
3725: --
3726: hr_utility.set_location(' Leaving:'||l_proc, 10);
3727: --
3728: */
3729: -- Validate Important Attributes
3730: hr_api.validate_bus_grp_id(p_business_group_id => p_rec.business_group_id,

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

3755: -- bug 4348022
3756:
3757: ota_evt_bus.chk_ddf(p_rec);
3758: --
3759: hr_utility.set_location(' Leaving:'||l_proc, 10);
3760: --
3761:
3762: End update_validate;
3763: --

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

3768: --
3769: l_proc varchar2(72) := g_package||'delete_validate';
3770: --
3771: Begin
3772: hr_utility.set_location('Entering:'||l_proc, 5);
3773: --
3774: -- Call all supporting business operations
3775: check_child_entities (p_event_id => p_rec.event_id);
3776: chk_Order_line_exist(ota_evt_shd.g_old_rec.line_id

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

3779: IF ota_evt_shd.g_old_rec.secure_event_flag = 'Y' THEN
3780: chk_secure_event_flag(p_organization_id => ota_evt_shd.g_old_rec.organization_id);
3781: END IF;
3782: --
3783: hr_utility.set_location(' Leaving:'||l_proc, 10);
3784: End delete_validate;
3785: --
3786: end ota_evt_bus;