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 1704: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 10);

1700: fnd_message.set_name('OTA','OTA_13563_EVT_SESSION_TIME');
1701: fnd_message.raise_error;
1702: END IF;
1703: END IF;
1704: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 10);
1705:
1706: EXCEPTION
1707: WHEN app_exception.application_exception THEN
1708: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN

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

1705:
1706: EXCEPTION
1707: WHEN app_exception.application_exception THEN
1708: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN
1709: hr_utility.set_location(' Leaving:'||w_proc, 60);
1710: RAISE;
1711: END IF;
1712: hr_utility.set_location(' Leaving:'||w_proc, 70);
1713: END check_session_time;

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

1708: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN
1709: hr_utility.set_location(' Leaving:'||w_proc, 60);
1710: RAISE;
1711: END IF;
1712: hr_utility.set_location(' Leaving:'||w_proc, 70);
1713: END check_session_time;
1714:
1715: --------------------------------------------------------------------------------
1716: -- ----------------------------------------------------------------------------

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

1738: L_COURSE_SPANS_SESSIONS boolean;
1739: --
1740: begin
1741: --
1742: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
1743: --
1744: -- Check parameters
1745: --
1746: HR_API.MANDATORY_ARG_ERROR (

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

1753: P_PARENT_EVENT_ID,
1754: L_COURSE_START_DATE,
1755: L_COURSE_END_DATE);
1756: --
1757: HR_UTILITY.TRACE ('Start date: ' || to_char (L_COURSE_START_DATE));
1758: HR_UTILITY.TRACE (' End date: ' || to_char (L_COURSE_END_DATE));
1759: --
1760: -- check if course start and end date are null
1761: -- if null then set them to start and end of time

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

1754: L_COURSE_START_DATE,
1755: L_COURSE_END_DATE);
1756: --
1757: HR_UTILITY.TRACE ('Start date: ' || to_char (L_COURSE_START_DATE));
1758: HR_UTILITY.TRACE (' End date: ' || to_char (L_COURSE_END_DATE));
1759: --
1760: -- check if course start and end date are null
1761: -- if null then set them to start and end of time
1762: --

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

1805: and p_course_end_date;
1806: --
1807: begin
1808: --
1809: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
1810: --
1811: -- Check parameters
1812: --
1813: HR_API.MANDATORY_ARG_ERROR (

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

1823: l_sessions_invalidated := csr_invalid_sessions%found;
1824: close csr_invalid_sessions;
1825: end if;
1826: --
1827: HR_UTILITY.SET_LOCATION (W_PROC,10);
1828: --
1829: return NOT l_sessions_invalidated;
1830: --
1831: end course_dates_span_sessions;

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

1861: w_proc constant varchar2(72) := G_PACKAGE||'check_class_session_times';
1862:
1863: BEGIN
1864:
1865: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
1866: -- --
1867: --
1868: --
1869: HR_UTILITY.TRACE ('Parent: ' || to_char (P_EVENT_ID));

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

1865: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
1866: -- --
1867: --
1868: --
1869: HR_UTILITY.TRACE ('Parent: ' || to_char (P_EVENT_ID));
1870:
1871: OPEN get_ssn_times_cr;
1872: LOOP
1873: FETCH get_ssn_times_cr INTO l_ssn_start_date,

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

1917:
1918: END LOOP;
1919: CLOSE get_ssn_times_cr;
1920:
1921: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 10);
1922:
1923: EXCEPTION
1924: WHEN app_exception.application_exception THEN
1925: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN

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

1922:
1923: EXCEPTION
1924: WHEN app_exception.application_exception THEN
1925: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN
1926: hr_utility.set_location(' Leaving:'||w_proc, 60);
1927: RAISE;
1928: END IF;
1929: hr_utility.set_location(' Leaving:'||w_proc, 70);
1930: END check_class_session_times;

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

1925: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_TIME') THEN
1926: hr_utility.set_location(' Leaving:'||w_proc, 60);
1927: RAISE;
1928: END IF;
1929: hr_utility.set_location(' Leaving:'||w_proc, 70);
1930: END check_class_session_times;
1931:
1932: -- ----------------------------------------------------------------------------
1933: -- -----------------------< CHECK_UPDATED_COURSE_DATES >-----------------------

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

1977: end course_dates_have_changed;
1978: --
1979: begin
1980: --
1981: HR_UTILITY.SET_LOCATION ('Entering:'||W_PROC,5);
1982: --
1983: check_parameters;
1984: --
1985: if course_dates_have_changed

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

1999: EXCEPTION
2000: WHEN app_exception.application_exception THEN
2001: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_DATE',
2002: p_associated_column2 => 'OTA_EVENTS.COURSE_END_DATE') THEN
2003: hr_utility.set_location(' Leaving:'||w_proc, 40);
2004: RAISE;
2005: END IF;
2006: hr_utility.set_location(' Leaving:'||w_proc, 50);
2007:

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

2002: p_associated_column2 => 'OTA_EVENTS.COURSE_END_DATE') THEN
2003: hr_utility.set_location(' Leaving:'||w_proc, 40);
2004: RAISE;
2005: END IF;
2006: hr_utility.set_location(' Leaving:'||w_proc, 50);
2007:
2008: end check_updated_course_dates;
2009: --
2010: -- ----------------------------------------------------------------------------

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

2018: --
2019: v_proc varchar2(72) := g_package||'check_cost_vals';
2020: begin
2021: --
2022: hr_utility.set_location('Entering:'|| v_proc, 5);
2023: --
2024: if (p_budget_cost is not null or p_actual_cost is not null) and
2025: p_budget_currency_code is null then
2026: --

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

2028: fnd_message.raise_error;
2029: --
2030: end if;
2031: --
2032: hr_utility.set_location(' Leaving:'|| v_proc, 10);
2033: --
2034: EXCEPTION
2035: WHEN app_exception.application_exception THEN
2036: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.BUDGET_COST',

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

2035: WHEN app_exception.application_exception THEN
2036: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.BUDGET_COST',
2037: p_associated_column2 => 'OTA_EVENTS.BUDGET_CURRENCY_CODE',
2038: p_associated_column3 => 'OTA_EVENTS.ACTUAL_COST') THEN
2039: hr_utility.set_location(' Leaving:'||v_proc, 40);
2040: RAISE;
2041: END IF;
2042: hr_utility.set_location(' Leaving:'||v_proc, 50);
2043: end check_cost_vals;

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

2038: p_associated_column3 => 'OTA_EVENTS.ACTUAL_COST') THEN
2039: hr_utility.set_location(' Leaving:'||v_proc, 40);
2040: RAISE;
2041: END IF;
2042: hr_utility.set_location(' Leaving:'||v_proc, 50);
2043: end check_cost_vals;
2044: --
2045: -- ----------------------------------------------------------------------------
2046: -- ------------------------< CHECK_SESSION_WITHIN_COURSE >---------------------

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

2061: := G_PACKAGE || 'CHECK_SESSION_WITHIN_COURSE';
2062: --
2063: begin
2064: --
2065: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
2066: --
2067: -- Check parameters
2068: --
2069: HR_API.MANDATORY_ARG_ERROR (

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

2079: --
2080: if not ( (OTA_EVT_SHD.API_UPDATING (P_EVENT_ID, P_OBJECT_VERSION_NUMBER))
2081: and (OTA_EVT_SHD.G_OLD_REC.COURSE_START_DATE = P_COURSE_START_DATE)) then
2082: --
2083: HR_UTILITY.TRACE ('Parent: ' || to_char (P_PARENT_EVENT_ID));
2084: --
2085: if ( (P_EVENT_TYPE = 'SESSION')
2086: and (not COURSE_DATES_SPAN_SESSIONS (
2087: P_PARENT_EVENT_ID => P_PARENT_EVENT_ID,

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

2090: end if;
2091: --
2092: end if;
2093: --
2094: HR_UTILITY.SET_LOCATION (' Leaving:' || W_PROC, 10);
2095: --
2096: EXCEPTION
2097: WHEN app_exception.application_exception THEN
2098: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_DATE') THEN

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

2095: --
2096: EXCEPTION
2097: WHEN app_exception.application_exception THEN
2098: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_DATE') THEN
2099: hr_utility.set_location(' Leaving:'||w_proc, 40);
2100: RAISE;
2101: END IF;
2102: hr_utility.set_location(' Leaving:'||w_proc, 50);
2103: end CHECK_SESSION_WITHIN_COURSE;

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

2098: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.COURSE_START_DATE') THEN
2099: hr_utility.set_location(' Leaving:'||w_proc, 40);
2100: RAISE;
2101: END IF;
2102: hr_utility.set_location(' Leaving:'||w_proc, 50);
2103: end CHECK_SESSION_WITHIN_COURSE;
2104: --
2105: -- ----------------------------------------------------------------------------
2106: -- -----------------------< VALID_PARENT_EVENT >-------------------------------

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

2120: W_VALID_PARENT boolean;
2121: --
2122: begin
2123: --
2124: HR_UTILITY.SET_LOCATION ('Entering:' || G_PACKAGE || 'VALID_PARENT_EVENT', 5);
2125: --
2126: -- Check parameters
2127: --
2128: HR_API.MANDATORY_ARG_ERROR (

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

2143: P_EVENT_ID => P_PARENT_EVENT_ID,
2144: P_EVENT_EXISTS => W_PARENT_ID_EXISTS);
2145: --
2146: if (W_PARENT_ID_EXISTS) then
2147: HR_UTILITY.TRACE ('Parent exists: True');
2148: else
2149: HR_UTILITY.TRACE ('Parent exists: Fales');
2150: end if;
2151: HR_UTILITY.TRACE ('Business grps: ' || to_char (P_BUSINESS_GROUP_ID)

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

2145: --
2146: if (W_PARENT_ID_EXISTS) then
2147: HR_UTILITY.TRACE ('Parent exists: True');
2148: else
2149: HR_UTILITY.TRACE ('Parent exists: Fales');
2150: end if;
2151: HR_UTILITY.TRACE ('Business grps: ' || to_char (P_BUSINESS_GROUP_ID)
2152: || '/' || to_char (G_FETCHED_REC.BUSINESS_GROUP_ID));
2153: HR_UTILITY.TRACE ('Types: ' || P_EVENT_TYPE

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

2147: HR_UTILITY.TRACE ('Parent exists: True');
2148: else
2149: HR_UTILITY.TRACE ('Parent exists: Fales');
2150: end if;
2151: HR_UTILITY.TRACE ('Business grps: ' || to_char (P_BUSINESS_GROUP_ID)
2152: || '/' || to_char (G_FETCHED_REC.BUSINESS_GROUP_ID));
2153: HR_UTILITY.TRACE ('Types: ' || P_EVENT_TYPE
2154: || '/' || G_FETCHED_REC.EVENT_TYPE);
2155: W_VALID_PARENT :=

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

2149: HR_UTILITY.TRACE ('Parent exists: Fales');
2150: end if;
2151: HR_UTILITY.TRACE ('Business grps: ' || to_char (P_BUSINESS_GROUP_ID)
2152: || '/' || to_char (G_FETCHED_REC.BUSINESS_GROUP_ID));
2153: HR_UTILITY.TRACE ('Types: ' || P_EVENT_TYPE
2154: || '/' || G_FETCHED_REC.EVENT_TYPE);
2155: W_VALID_PARENT :=
2156: (W_PARENT_ID_EXISTS)
2157: and (P_BUSINESS_GROUP_ID

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

2167: = 'PROGRAMME')));
2168: --
2169: end if;
2170: --
2171: HR_UTILITY.SET_LOCATION ( ' Leaving:' || G_PACKAGE || 'VALID_PARENT_EVENT', 10);
2172: return W_VALID_PARENT;
2173: --
2174: end VALID_PARENT_EVENT;
2175: --

Line 2189: HR_UTILITY.SET_LOCATION (

2185: P_OBJECT_VERSION_NUMBER in number default null
2186: ) is
2187: begin
2188: --
2189: HR_UTILITY.SET_LOCATION (
2190: 'Entering:' || G_PACKAGE || 'CHECK_PARENT_EVENT_IS_VALID',
2191: 5);
2192: --
2193: if ( (P_PARENT_EVENT_ID is not null )

Line 2206: HR_UTILITY.SET_LOCATION (

2202: end if;
2203: --
2204: end if;
2205: --
2206: HR_UTILITY.SET_LOCATION (
2207: ' Leaving:' || G_PACKAGE || 'CHECK_PARENT_EVENT_IS_VALID',
2208: 10);
2209: --
2210: end CHECK_PARENT_EVENT_IS_VALID;

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

2356: from ota_event_associations
2357: where event_id = p_event_id;
2358: --
2359: begin
2360: hr_utility.set_location ('Entering:'||l_proc,5);
2361: --
2362: if p_event_id is not null and
2363: l_price_basis_changed then
2364: --

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

2381: close get_event_associations;
2382: --
2383: end if;
2384: --
2385: hr_utility.set_location ('Leaving:'||l_proc,10);
2386: EXCEPTION
2387: WHEN app_exception.application_exception THEN
2388: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PRICE_BASIS') THEN
2389: hr_utility.set_location(' Leaving:'||l_proc, 40);

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

2385: hr_utility.set_location ('Leaving:'||l_proc,10);
2386: EXCEPTION
2387: WHEN app_exception.application_exception THEN
2388: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PRICE_BASIS') THEN
2389: hr_utility.set_location(' Leaving:'||l_proc, 40);
2390: RAISE;
2391: END IF;
2392: hr_utility.set_location(' Leaving:'||l_proc, 50);
2393: end price_basis_change;

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

2388: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.PRICE_BASIS') THEN
2389: hr_utility.set_location(' Leaving:'||l_proc, 40);
2390: RAISE;
2391: END IF;
2392: hr_utility.set_location(' Leaving:'||l_proc, 50);
2393: end price_basis_change;
2394: --
2395: -- ----------------------------------------------------------------------------
2396: -- -------------------------< check_timezone >-----------------------------

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

2507:
2508: --
2509: begin
2510: --
2511: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
2512: --
2513: -- Check only non-static domains (constraints trap the static ones)
2514: --
2515: OTA_GENERAL.CHECK_DOMAIN_VALUE (

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

2783: check_timezone(p_rec.timezone);
2784: END IF;
2785:
2786:
2787: HR_UTILITY.SET_LOCATION (' Leaving:' || W_PROC, 10);
2788: --
2789: end VALIDITY_CHECKS;
2790: --
2791: -- ----------------------------------------------------------------------------

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

2887: l_proc varchar2(72) := g_package||'check_child_entities';
2888: l_dummy varchar2(1);
2889: --
2890: Begin
2891: hr_utility.set_location('Entering:'||l_proc, 5);
2892: --
2893: -- Determine if the event has training_plan_cost records
2894: open c_get_tpc_rows;
2895: fetch c_get_tpc_rows into l_dummy;

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

3056: end if;
3057: close c_conference_details;
3058:
3059:
3060: hr_utility.set_location(' Leaving:'||l_proc, 10);
3061: EXCEPTION
3062: WHEN app_exception.application_exception THEN
3063: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.EVENT_ID') THEN
3064: hr_utility.set_location(' Leaving:'||l_proc, 70);

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

3060: hr_utility.set_location(' Leaving:'||l_proc, 10);
3061: EXCEPTION
3062: WHEN app_exception.application_exception THEN
3063: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.EVENT_ID') THEN
3064: hr_utility.set_location(' Leaving:'||l_proc, 70);
3065: RAISE;
3066: END IF;
3067: hr_utility.set_location(' Leaving:'||l_proc, 80);
3068: End check_child_entities;

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

3063: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.EVENT_ID') THEN
3064: hr_utility.set_location(' Leaving:'||l_proc, 70);
3065: RAISE;
3066: END IF;
3067: hr_utility.set_location(' Leaving:'||l_proc, 80);
3068: End check_child_entities;
3069: --
3070: --
3071: -- ----------------------------------------------------------------------------

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

3092: and tfl.cancelled_flag = 'N';
3093: --
3094: begin
3095: --
3096: HR_UTILITY.SET_LOCATION ('Entering:' || W_PROC, 5);
3097: --
3098: open csr_st_finance_lines;
3099: fetch csr_st_finance_lines into g_dummy;
3100: l_st_finance_lines := csr_st_finance_lines%found;

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

3099: fetch csr_st_finance_lines into g_dummy;
3100: l_st_finance_lines := csr_st_finance_lines%found;
3101: close csr_st_finance_lines;
3102: --
3103: HR_UTILITY.SET_LOCATION (W_PROC,10);
3104: --
3105: return l_st_finance_lines;
3106: --
3107: end check_for_st_finance_lines;

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

3146:
3147:
3148: Begin
3149: --
3150: hr_utility.set_location('Entering:'||l_proc, 5);
3151: --
3152:
3153: if (((p_event_id is not null) and
3154: nvl(ota_evt_shd.g_old_rec.owner_id,hr_api.g_number) <>

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

3157:
3158: IF p_owner_id is not null then
3159:
3160: If l_single_business_group_id is not null then
3161: hr_utility.set_location('Entering:'||l_proc, 10);
3162: OPEN c_people_cross;
3163: FETCH c_people_cross into l_exist;
3164: if c_people_cross%notfound then
3165: close c_people_cross;

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

3167: fnd_message.raise_error;
3168: end if;
3169: close c_people_cross;
3170: else
3171: hr_utility.set_location('Entering:'||l_proc, 20);
3172: OPEN c_people;
3173: FETCH c_people into l_exist;
3174: if c_people%notfound then
3175: close c_people;

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

3177: fnd_message.raise_error;
3178: end if;
3179: close c_people;
3180: end if;
3181: hr_utility.set_location('Leaving:'||l_proc, 40);
3182: END IF;
3183: End if;
3184: EXCEPTION
3185: WHEN app_exception.application_exception THEN

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

3183: End if;
3184: EXCEPTION
3185: WHEN app_exception.application_exception THEN
3186: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.OWNER_ID') THEN
3187: hr_utility.set_location(' Leaving:'||l_proc, 40);
3188: RAISE;
3189: END IF;
3190: hr_utility.set_location(' Leaving:'||l_proc, 50);
3191: end check_owner_id;

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

3186: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.OWNER_ID') THEN
3187: hr_utility.set_location(' Leaving:'||l_proc, 40);
3188: RAISE;
3189: END IF;
3190: hr_utility.set_location(' Leaving:'||l_proc, 50);
3191: end check_owner_id;
3192:
3193: -- ----------------------------------------------------------------------------
3194: -- |---------------------------< check_line_id >---------------------------|

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

3210: from oe_order_lines_all
3211: where line_id = p_line_id;
3212:
3213: Begin
3214: hr_utility.set_location('Entering:'||l_proc, 5);
3215:
3216: if (((p_event_id is not null) and
3217: nvl(ota_evt_shd.g_old_rec.line_id,hr_api.g_number) <>
3218: nvl(p_line_id,hr_api.g_number))

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

3217: nvl(ota_evt_shd.g_old_rec.line_id,hr_api.g_number) <>
3218: nvl(p_line_id,hr_api.g_number))
3219: or (p_event_id is null)) then
3220: --
3221: hr_utility.set_location('Entering:'||l_proc, 10);
3222: if (p_line_id is not null) then
3223: hr_utility.set_location('Entering:'||l_proc, 15);
3224: open csr_order_line;
3225: fetch csr_order_line into l_exists;

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

3219: or (p_event_id is null)) then
3220: --
3221: hr_utility.set_location('Entering:'||l_proc, 10);
3222: if (p_line_id is not null) then
3223: hr_utility.set_location('Entering:'||l_proc, 15);
3224: open csr_order_line;
3225: fetch csr_order_line into l_exists;
3226: if csr_order_line%notfound then
3227: close csr_order_line;

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

3228: fnd_message.set_name('OTA','OTA_13888_TDB_LINE_INVALID');
3229: fnd_message.raise_error;
3230: end if;
3231: close csr_order_line;
3232: hr_utility.set_location('Entering:'||l_proc, 20);
3233: end if;
3234: end if;
3235: hr_utility.set_location('Entering:'||l_proc, 30);
3236: EXCEPTION

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

3231: close csr_order_line;
3232: hr_utility.set_location('Entering:'||l_proc, 20);
3233: end if;
3234: end if;
3235: hr_utility.set_location('Entering:'||l_proc, 30);
3236: EXCEPTION
3237: WHEN app_exception.application_exception THEN
3238: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LINE_ID') THEN
3239: hr_utility.set_location(' Leaving:'||l_proc, 40);

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

3235: hr_utility.set_location('Entering:'||l_proc, 30);
3236: EXCEPTION
3237: WHEN app_exception.application_exception THEN
3238: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LINE_ID') THEN
3239: hr_utility.set_location(' Leaving:'||l_proc, 40);
3240: RAISE;
3241: END IF;
3242: hr_utility.set_location(' Leaving:'||l_proc, 50);
3243: end check_line_id;

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

3238: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LINE_ID') THEN
3239: hr_utility.set_location(' Leaving:'||l_proc, 40);
3240: RAISE;
3241: END IF;
3242: hr_utility.set_location(' Leaving:'||l_proc, 50);
3243: end check_line_id;
3244:
3245: -- ----------------------------------------------------------------------------
3246: -- |---------------------------< chk_status_changed >----------------------|

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

3275: l_err_msg VARCHAR2(1000) := '';
3276:
3277: --
3278: Begin
3279: hr_utility.set_location('Entering:'||l_proc, 5);
3280: --
3281: IF p_line_id is not null THEN
3282: IF l_event_status_changed THEN
3283: IF p_event_status = 'A' THEN

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

3281: IF p_line_id is not null THEN
3282: IF l_event_status_changed THEN
3283: IF p_event_status = 'A' THEN
3284:
3285: hr_utility.set_location('Entering:'||l_proc, 10);
3286:
3287: ota_utility.check_invoice(
3288: p_line_id => p_line_id,
3289: p_org_id => p_org_id,

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

3291: IF fnd_installation.get(660, 660, l_ins_status, l_industry) THEN
3292: BEGIN
3293: IF l_exist = 'Y' THEN
3294: Begin
3295: hr_utility.set_location('Entering:'||l_proc, 15);
3296:
3297: /* l_dynamicSqlString := '
3298: ota_om_upd_api.create_rma(
3299: :p_Line_id,

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

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

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

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

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

3304: ota_om_upd_api.create_rma(p_line_id,p_org_id);
3305: exception when others then
3306: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3307: hr_utility.set_message_token('PROCEDURE', l_proc);
3308: hr_utility.set_message_token('STEP','15');
3309: hr_utility.raise_error;
3310:
3311: End;
3312: ELSE

Line 3309: hr_utility.raise_error;

3305: exception when others then
3306: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3307: hr_utility.set_message_token('PROCEDURE', l_proc);
3308: hr_utility.set_message_token('STEP','15');
3309: hr_utility.raise_error;
3310:
3311: End;
3312: ELSE
3313: Begin

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

3310:
3311: End;
3312: ELSE
3313: Begin
3314: hr_utility.set_location('Entering:'||l_proc, 20);
3315: /*l_dynamicSqlString := '
3316: ota_om_upd_api.cancel_order(
3317: p_Line_id,
3318: p_org_id);' ;

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

3320: USING IN p_line_id,
3321: IN p_org_id;*/
3322: ota_om_upd_api.cancel_order(p_line_id,p_org_id);
3323: exception when others then
3324: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3325: hr_utility.set_message_token('PROCEDURE', l_proc);
3326: hr_utility.set_message_token('STEP','20');
3327: hr_utility.raise_error;
3328:

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

3321: IN p_org_id;*/
3322: ota_om_upd_api.cancel_order(p_line_id,p_org_id);
3323: exception when others then
3324: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3325: hr_utility.set_message_token('PROCEDURE', l_proc);
3326: hr_utility.set_message_token('STEP','20');
3327: hr_utility.raise_error;
3328:
3329: End;

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

3322: ota_om_upd_api.cancel_order(p_line_id,p_org_id);
3323: exception when others then
3324: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3325: hr_utility.set_message_token('PROCEDURE', l_proc);
3326: hr_utility.set_message_token('STEP','20');
3327: hr_utility.raise_error;
3328:
3329: End;
3330:

Line 3327: hr_utility.raise_error;

3323: exception when others then
3324: hr_utility.set_message(801, 'HR_6153_ALL_PROCEDURE_FAIL');
3325: hr_utility.set_message_token('PROCEDURE', l_proc);
3326: hr_utility.set_message_token('STEP','20');
3327: hr_utility.raise_error;
3328:
3329: End;
3330:
3331: END IF;

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

3349: END IF;
3350: END IF;
3351:
3352:
3353: hr_utility.set_location('Leaving:'||l_proc, 10);
3354: /*EXCEPTION WHEN OTHERS
3355: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;*/
3356:
3357: end chk_status_changed;

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

3371: l_proc varchar2(72) := g_package||'chk_order_line_exist';
3372:
3373:
3374: Begin
3375: hr_utility.set_location('Entering:'||l_proc, 5);
3376:
3377: if p_line_id is not null then
3378: fnd_message.set_name('OTA','OTA_13896_EVT_ORDER_LINE_EXIST');
3379: fnd_message.raise_error;

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

3376:
3377: if p_line_id is not null then
3378: fnd_message.set_name('OTA','OTA_13896_EVT_ORDER_LINE_EXIST');
3379: fnd_message.raise_error;
3380: hr_utility.set_location('Entering:'||l_proc, 20);
3381:
3382: end if;
3383: hr_utility.set_location('Leaving:'||l_proc, 30);
3384: EXCEPTION

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

3379: fnd_message.raise_error;
3380: hr_utility.set_location('Entering:'||l_proc, 20);
3381:
3382: end if;
3383: hr_utility.set_location('Leaving:'||l_proc, 30);
3384: EXCEPTION
3385: WHEN app_exception.application_exception THEN
3386: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LINE_ID') THEN
3387: hr_utility.set_location(' Leaving:'||l_proc, 40);

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

3383: hr_utility.set_location('Leaving:'||l_proc, 30);
3384: EXCEPTION
3385: WHEN app_exception.application_exception THEN
3386: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LINE_ID') THEN
3387: hr_utility.set_location(' Leaving:'||l_proc, 40);
3388: RAISE;
3389: END IF;
3390: hr_utility.set_location(' Leaving:'||l_proc, 50);
3391: end chk_order_line_exist;

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

3386: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LINE_ID') THEN
3387: hr_utility.set_location(' Leaving:'||l_proc, 40);
3388: RAISE;
3389: END IF;
3390: hr_utility.set_location(' Leaving:'||l_proc, 50);
3391: end chk_order_line_exist;
3392:
3393:
3394: -- ----------------------------------------------------------------------------

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

3415: From HR_ALL_ORGANIZATION_UNITS
3416: Where organization_id = p_training_center_id;
3417:
3418: Begin
3419: hr_utility.set_location('Entering:'||l_proc, 5);
3420: if (((p_event_id is not null) and
3421: nvl(ota_evt_shd.g_old_rec.training_center_id,hr_api.g_number) <>
3422: nvl(p_training_center_id,hr_api.g_number))
3423: or (p_event_id is null)) then

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

3421: nvl(ota_evt_shd.g_old_rec.training_center_id,hr_api.g_number) <>
3422: nvl(p_training_center_id,hr_api.g_number))
3423: or (p_event_id is null)) then
3424: --
3425: hr_utility.set_location('Entering:'||l_proc, 10);
3426: if (p_training_center_id is not null) then
3427: hr_utility.set_location('Entering:'||l_proc, 15);
3428: open c_training_center;
3429: fetch c_training_center into l_exists;

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

3423: or (p_event_id is null)) then
3424: --
3425: hr_utility.set_location('Entering:'||l_proc, 10);
3426: if (p_training_center_id is not null) then
3427: hr_utility.set_location('Entering:'||l_proc, 15);
3428: open c_training_center;
3429: fetch c_training_center into l_exists;
3430: if c_training_center%notfound then
3431: close c_training_center;

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

3432: fnd_message.set_name('OTA','OTA_13907_TSR_TRNCTR_NOT_EXIST');
3433: fnd_message.raise_error;
3434: end if;
3435: close c_training_center;
3436: hr_utility.set_location('Entering:'||l_proc, 20);
3437: end if;
3438: end if;
3439: hr_utility.set_location('Entering:'||l_proc, 30);
3440: EXCEPTION

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

3435: close c_training_center;
3436: hr_utility.set_location('Entering:'||l_proc, 20);
3437: end if;
3438: end if;
3439: hr_utility.set_location('Entering:'||l_proc, 30);
3440: EXCEPTION
3441: WHEN app_exception.application_exception THEN
3442: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.TRAINING_CENTER_ID') THEN
3443: hr_utility.set_location(' Leaving:'||l_proc, 40);

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

3439: hr_utility.set_location('Entering:'||l_proc, 30);
3440: EXCEPTION
3441: WHEN app_exception.application_exception THEN
3442: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.TRAINING_CENTER_ID') THEN
3443: hr_utility.set_location(' Leaving:'||l_proc, 40);
3444: RAISE;
3445: END IF;
3446: hr_utility.set_location(' Leaving:'||l_proc, 50);
3447: end;

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

3442: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.TRAINING_CENTER_ID') THEN
3443: hr_utility.set_location(' Leaving:'||l_proc, 40);
3444: RAISE;
3445: END IF;
3446: hr_utility.set_location(' Leaving:'||l_proc, 50);
3447: end;
3448:
3449: -- ----------------------------------------------------------------------------
3450: -- |-----------------------------< chk_location >---------------------------|

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

3472: Where loc.location_id = p_location_id
3473: and nvl(loc.inactive_date,to_date('31-12-4712','DD-MM-YYYY')) >= nvl(p_course_end_date,sysdate);
3474:
3475: Begin
3476: hr_utility.set_location('Entering:'||l_proc, 5);
3477:
3478: if (((p_event_id is not null) and
3479: nvl(ota_evt_shd.g_old_rec.location_id,hr_api.g_number) <>
3480: nvl(p_location_id,hr_api.g_number))

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

3479: nvl(ota_evt_shd.g_old_rec.location_id,hr_api.g_number) <>
3480: nvl(p_location_id,hr_api.g_number))
3481: or (p_event_id is null)) then
3482: --
3483: hr_utility.set_location('Entering:'||l_proc, 10);
3484: if (p_location_id is not null) then
3485: hr_utility.set_location('Entering:'||l_proc, 15);
3486: open c_location;
3487: fetch c_location into l_exists;

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

3481: or (p_event_id is null)) then
3482: --
3483: hr_utility.set_location('Entering:'||l_proc, 10);
3484: if (p_location_id is not null) then
3485: hr_utility.set_location('Entering:'||l_proc, 15);
3486: open c_location;
3487: fetch c_location into l_exists;
3488: if c_location%notfound then
3489: close c_location;

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

3490: fnd_message.set_name('OTA','OTA_13908_TSR_LOC_NOT_EXIST');
3491: fnd_message.raise_error;
3492: end if;
3493: close c_location;
3494: hr_utility.set_location('Entering:'||l_proc, 20);
3495: end if;
3496: end if;
3497: hr_utility.set_location('Entering:'||l_proc, 30);
3498: EXCEPTION

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

3493: close c_location;
3494: hr_utility.set_location('Entering:'||l_proc, 20);
3495: end if;
3496: end if;
3497: hr_utility.set_location('Entering:'||l_proc, 30);
3498: EXCEPTION
3499: WHEN app_exception.application_exception THEN
3500: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LOCATION_ID') THEN
3501: hr_utility.set_location(' Leaving:'||l_proc, 40);

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

3497: hr_utility.set_location('Entering:'||l_proc, 30);
3498: EXCEPTION
3499: WHEN app_exception.application_exception THEN
3500: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LOCATION_ID') THEN
3501: hr_utility.set_location(' Leaving:'||l_proc, 40);
3502: RAISE;
3503: END IF;
3504: hr_utility.set_location(' Leaving:'||l_proc, 50);
3505: end;

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

3500: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.LOCATION_ID') THEN
3501: hr_utility.set_location(' Leaving:'||l_proc, 40);
3502: RAISE;
3503: END IF;
3504: hr_utility.set_location(' Leaving:'||l_proc, 50);
3505: end;
3506:
3507: --
3508: -- ----------------------------------------------------------------------------

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

3532: where offering_id = p_offering_id;
3533:
3534: Begin
3535:
3536: hr_utility.set_location('Entering:'||l_proc, 5);
3537:
3538: if (((p_event_id is not null) and
3539: nvl(ota_evt_shd.g_old_rec.offering_id,hr_api.g_number) <>
3540: nvl(p_offering_id,hr_api.g_number))

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

3539: nvl(ota_evt_shd.g_old_rec.offering_id,hr_api.g_number) <>
3540: nvl(p_offering_id,hr_api.g_number))
3541: or (p_event_id is null)) then
3542: --
3543: hr_utility.set_location('Entering:'||l_proc, 10);
3544: if (p_offering_id is not null) then
3545: hr_utility.set_location('Entering:'||l_proc, 15);
3546: open csr_offering;
3547: fetch csr_offering into l_exists;

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

3541: or (p_event_id is null)) then
3542: --
3543: hr_utility.set_location('Entering:'||l_proc, 10);
3544: if (p_offering_id is not null) then
3545: hr_utility.set_location('Entering:'||l_proc, 15);
3546: open csr_offering;
3547: fetch csr_offering into l_exists;
3548: if csr_offering%found then
3549: ota_evt_shd.constraint_error(p_constraint_name =>'OTA_EVENTS_UK4');

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

3548: if csr_offering%found then
3549: ota_evt_shd.constraint_error(p_constraint_name =>'OTA_EVENTS_UK4');
3550: end if;
3551: close csr_offering;
3552: hr_utility.set_location('Leaving:'||l_proc, 20);
3553: end if;
3554: end if;
3555: hr_utility.set_location('Leaving:'||l_proc, 30);
3556: EXCEPTION

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

3551: close csr_offering;
3552: hr_utility.set_location('Leaving:'||l_proc, 20);
3553: end if;
3554: end if;
3555: hr_utility.set_location('Leaving:'||l_proc, 30);
3556: EXCEPTION
3557: WHEN app_exception.application_exception THEN
3558: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.OFFERING_ID') THEN
3559: hr_utility.set_location(' Leaving:'||l_proc, 70);

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

3555: hr_utility.set_location('Leaving:'||l_proc, 30);
3556: EXCEPTION
3557: WHEN app_exception.application_exception THEN
3558: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.OFFERING_ID') THEN
3559: hr_utility.set_location(' Leaving:'||l_proc, 70);
3560: RAISE;
3561: END IF;
3562: hr_utility.set_location(' Leaving:'||l_proc, 80);
3563: End;

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

3558: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.OFFERING_ID') THEN
3559: hr_utility.set_location(' Leaving:'||l_proc, 70);
3560: RAISE;
3561: END IF;
3562: hr_utility.set_location(' Leaving:'||l_proc, 80);
3563: End;
3564:
3565: --
3566: -- ----------------------------------------------------------------------------

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

3592: AND act.activity_version_id = p_activity_version_id;
3593:
3594: Begin
3595:
3596: hr_utility.set_location('Entering:'||l_proc, 5);
3597: open csr_offering;
3598: fetch csr_offering into l_exists;
3599: if csr_offering%notfound then
3600: close csr_offering;

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

3601: fnd_message.set_name('OTA','OTA_443321_EVT_OFF_INVALID_ACT');
3602: fnd_message.raise_error;
3603: end if;
3604: close csr_offering;
3605: hr_utility.set_location('Leaving:'||l_proc, 20);
3606: EXCEPTION
3607: WHEN app_exception.application_exception THEN
3608: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.ACTIVITY_VERSION_ID') THEN
3609: hr_utility.set_location(' Leaving:'||l_proc, 70);

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

3605: hr_utility.set_location('Leaving:'||l_proc, 20);
3606: EXCEPTION
3607: WHEN app_exception.application_exception THEN
3608: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.ACTIVITY_VERSION_ID') THEN
3609: hr_utility.set_location(' Leaving:'||l_proc, 70);
3610: RAISE;
3611: END IF;
3612: hr_utility.set_location(' Leaving:'||l_proc, 80);
3613: End chk_activity_version_id;

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

3608: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.ACTIVITY_VERSION_ID') THEN
3609: hr_utility.set_location(' Leaving:'||l_proc, 70);
3610: RAISE;
3611: END IF;
3612: hr_utility.set_location(' Leaving:'||l_proc, 80);
3613: End chk_activity_version_id;
3614:
3615: --
3616: -- ----------------------------------------------------------------------------

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

3641: AND trunc(sysdate) BETWEEN p.effective_start_date AND p.effective_end_date
3642: AND f.user_id = to_number(fnd_profile.value('USER_ID'));
3643:
3644: BEGIN
3645: hr_utility.set_location('Entering:'||l_proc, 5);
3646:
3647: OPEN csr_org;
3648: FETCH csr_org INTO l_username;
3649: if csr_org%notfound then

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

3662: fnd_message.set_name('OTA', 'OTA_EVT_SECURE');
3663: fnd_message.raise_error;
3664: END IF;
3665: CLOSE csr_org;*/
3666: hr_utility.set_location('Leaving:'||l_proc, 20);
3667:
3668: EXCEPTION
3669: WHEN app_exception.application_exception THEN
3670: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.SECURE_EVENT_FLAG') THEN

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

3667:
3668: EXCEPTION
3669: WHEN app_exception.application_exception THEN
3670: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.SECURE_EVENT_FLAG') THEN
3671: hr_utility.set_location('Leaving:'||l_proc, 40);
3672: RAISE;
3673: END IF;
3674: hr_utility.set_location('Leaving:'||l_proc, 50);
3675: END chk_secure_event_flag;

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

3670: IF hr_multi_message.exception_add(p_associated_column1 => 'OTA_EVENTS.SECURE_EVENT_FLAG') THEN
3671: hr_utility.set_location('Leaving:'||l_proc, 40);
3672: RAISE;
3673: END IF;
3674: hr_utility.set_location('Leaving:'||l_proc, 50);
3675: END chk_secure_event_flag;
3676: --
3677: -- ----------------------------------------------------------------------------
3678: -- |---------------------------< insert_validate >----------------------------|

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

3683: l_proc varchar2(72) := g_package||'insert_validate';
3684: --
3685: Begin
3686: --
3687: hr_utility.set_location('Entering:'||l_proc, 5);
3688: --modified for eBS by asud
3689: /*
3690: -- Call all supporting business operations
3691: --

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

3693: --
3694: VALIDITY_CHECKS (
3695: P_REC => P_REC);
3696: --
3697: hr_utility.set_location(' Leaving:'||l_proc, 10);
3698: --*/
3699: --modified for eBS by asud
3700: -- Call all supporting business operations
3701: -- Validate Important Attributes

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

3714: -- bug 4348022
3715:
3716: ota_evt_bus.chk_ddf(p_rec);
3717: --
3718: hr_utility.set_location(' Leaving:'||l_proc, 10);
3719:
3720: End insert_validate;
3721: --
3722: -- ----------------------------------------------------------------------------

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

3732: := ota_general.value_changed(ota_evt_shd.g_old_rec.organization_id, p_rec.organization_id);
3733: --
3734: Begin
3735: --
3736: hr_utility.set_location('Entering:'||l_proc, 5);
3737: --
3738: -- Call all supporting business operations
3739: --
3740: /*

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

3742: --
3743: VALIDITY_CHECKS (
3744: P_REC => P_REC);
3745: --
3746: hr_utility.set_location(' Leaving:'||l_proc, 10);
3747: --
3748: */
3749: -- Validate Important Attributes
3750: hr_api.validate_bus_grp_id(p_business_group_id => p_rec.business_group_id,

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

3775: -- bug 4348022
3776:
3777: ota_evt_bus.chk_ddf(p_rec);
3778: --
3779: hr_utility.set_location(' Leaving:'||l_proc, 10);
3780: --
3781:
3782: End update_validate;
3783: --

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

3788: --
3789: l_proc varchar2(72) := g_package||'delete_validate';
3790: --
3791: Begin
3792: hr_utility.set_location('Entering:'||l_proc, 5);
3793: --
3794: -- Call all supporting business operations
3795: check_child_entities (p_event_id => p_rec.event_id);
3796: chk_Order_line_exist(ota_evt_shd.g_old_rec.line_id

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

3799: IF ota_evt_shd.g_old_rec.secure_event_flag = 'Y' THEN
3800: chk_secure_event_flag(p_organization_id => ota_evt_shd.g_old_rec.organization_id);
3801: END IF;
3802: --
3803: hr_utility.set_location(' Leaving:'||l_proc, 10);
3804: End delete_validate;
3805: --
3806: end ota_evt_bus;