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

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

163: FROM
164: dual;
165:
166: Begin
167: hr_utility.set_location('Entering:'||l_proc, 5);
168: --
169: OPEN c_sysdate;
170: FETCH c_sysdate INTO l_sysdate;
171: CLOSE c_sysdate;

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

185: IF c_people%found then */
186: OPEN C_USER;
187: FETCH C_USER INTO l_user_name;
188: IF p_daemon_type = 'C' THEN
189: hr_utility.set_location('Entering:'||l_proc, 10);
190:
191: -- Bug # 2707198
192:
193: OTA_INITIALIZATION_WF.INITIALIZE_CANCEL_ORDER (

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

249: p_full_name => l_full_name);
250: */
251:
252: ELSIF p_daemon_type = 'D' THEN
253: hr_utility.set_location('Entering:'||l_proc, 15);
254: ota_evt_upd.upd(
255: p_Event_id => l_Event_Id
256: ,P_Business_Group_id => l_event_Business_group_id
257: ,P_Object_version_number => l_event_ovn

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

259: ,p_Line_id => Null
260: ,p_Org_id => Null
261: ,P_validate => False);
262:
263: hr_utility.set_location('Entering:'||l_proc, 20);
264:
265:
266: OTA_INITIALIZATION_WF.INITIALIZE_CANCEL_ORDER (
267: p_itemtype => 'OTWF',

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

273: p_status => 'D',
274: p_full_name => l_full_name);
275:
276: ELSIF p_daemon_type = 'P' THEN
277: hr_utility.set_location('Entering:'||l_proc, 15);
278: ota_evt_upd.upd(
279: p_Event_id => l_Event_Id
280: ,P_Business_Group_id => l_event_Business_group_id
281: ,P_Object_version_number => l_event_ovn

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

283: ,p_Line_id => Null
284: ,p_Org_id => Null
285: ,P_validate => False);
286:
287: hr_utility.set_location('Entering:'||l_proc, 20);
288:
289: END IF;
290: CLOSE C_USER;
291: /* END IF;

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

294: CLOSE C_EVENT;
295:
296: ELSIF p_uom = 'ENR' THEN
297:
298: hr_utility.set_location('Entering:'||l_proc, 25);
299: BEGIN
300: OPEN C_ENROLLMENT;
301: FETCH c_enrollment into
302: l_booking_id,

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

334: FETCH c_booking_status into
335: l_booking_status_type;
336: IF c_booking_status%found then
337: IF l_booking_status_type not in('A','C') then
338: hr_utility.set_location('Entering:'||l_proc, 30);
339: ota_tdb_api_upd2.update_enrollment(
340: p_booking_id => l_booking_id
341: ,p_object_version_number => l_enr_ovn
342: ,p_event_id => l_event_id

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

360: RAISE;
361: END;
362: END IF;
363: --
364: hr_utility.set_location(' Leaving:'||l_proc, 40);
365: EXCEPTION WHEN
366: OTHERS THEN
367: x_return_status := 'E';
368: RAISE;

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

553:
554:
555: BEGIN
556:
557: hr_utility.set_location('Entering:'|| l_proc, 5);
558: -- l_status_name := Fnd_profile.value('OM_DEFAULT_ENROLLMENT_CANCELLED_STATUS');
559: l_status_id := Fnd_profile.value('OM_DEFAULT_ENROLLMENT_CANCELLED_STATUS');
560: l_auto_waitlist := Fnd_profile.value('OTA_AUTO_WAITLIST_ACTIVE');
561:

Line 571: hr_utility.set_location(l_proc, 10);

567: END IF;
568:
569: OPEN C_ENROLLMENT;
570: LOOP
571: hr_utility.set_location(l_proc, 10);
572:
573: FETCH c_enrollment into
574: l_event_id,
575: l_booking_id,

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

598: IF c_lines%found THEN
599:
600: IF l_line_transfer_status <> 'ST' THEN
601: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cancelling Finance Line for booking id : ' || l_booking_id);
602: hr_utility.set_location('Entering:'|| l_proc, 10);
603: BEGIN
604: ota_tfl_api_upd.upd(
605: p_finance_line_id => l_finance_line_id,
606: p_date_raised => l_date_raised,

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

629:
630: IF l_header_transfer_status <> 'ST' THEN
631: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cancelling Finance Header for booking id : ' || l_booking_id);
632: BEGIN
633: hr_utility.set_location('Entering:'|| l_proc, 30);
634: ota_tfh_api_upd.upd( p_finance_header_id => l_finance_header_id
635: ,p_object_version_number => l_header_ovn
636: ,p_cancelled_flag => 'Y'
637: ,p_validate => False

Line 660: hr_utility.set_location('Entering:'|| l_proc, 40);

656:
657: IF l_status_id is not null THEN
658: BEGIN
659: FND_FILE.PUT_LINE(FND_FILE.LOG,'Updating booking id : ' || l_booking_id);
660: hr_utility.set_location('Entering:'|| l_proc, 40);
661: ota_tdb_shd.lck(l_booking_id,l_enr_ovn);
662: ota_tdb_api_upd2.Update_Enrollment(
663: p_booking_id => l_booking_id
664: ,p_booking_status_type_id => l_status_id

Line 696: hr_utility.set_location('Entering:'|| l_proc, 45);

692:
693: ELSIF l_daemon_type = 'P' THEN
694: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Daemon type :' || l_daemon_type );
695: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing booking id : ' || l_booking_id);
696: hr_utility.set_location('Entering:'|| l_proc, 45);
697: BEGIN
698: FND_FILE.PUT_LINE(FND_FILE.LOG,'Updating booking id : ' || l_booking_id);
699: ota_tdb_shd.lck(l_booking_id,l_enr_ovn);
700: ota_tdb_api_upd2.Update_Enrollment(

Line 727: hr_utility.set_location('Entering:'|| l_proc, 47);

723:
724: ELSIF l_daemon_type = 'D' THEN
725: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Daemon type :' || l_daemon_type );
726: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing booking id : ' || l_booking_id);
727: hr_utility.set_location('Entering:'|| l_proc, 47);
728: IF l_status_id is not null THEN
729:
730: BEGIN
731: FND_FILE.PUT_LINE(FND_FILE.LOG,'Updating booking id : ' || l_booking_id);

Line 771: hr_utility.set_location('Entering:'|| l_proc, 50);

767: ELSIF l_daemon_type = 'W' THEN
768: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Daemon type :' || l_daemon_type );
769: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing booking id : ' || l_booking_id);
770:
771: hr_utility.set_location('Entering:'|| l_proc, 50);
772: BEGIN
773: FND_FILE.PUT_LINE(FND_FILE.LOG,'Updating booking id : ' || l_booking_id);
774: ota_tdb_shd.lck(l_booking_id,l_enr_ovn);
775: ota_tdb_api_upd2.Update_Enrollment(

Line 799: hr_utility.set_location('Entering:'|| l_proc, 55); -- err location added for bug#1632104

795:
796: ELSIF l_daemon_type = 'E' THEN -- added for bug #1632104
797: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Daemon type :' || l_daemon_type );
798: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing booking id : ' || l_booking_id);
799: hr_utility.set_location('Entering:'|| l_proc, 55); -- err location added for bug#1632104
800: BEGIN
801: FND_FILE.PUT_LINE(FND_FILE.LOG,'Updating booking id : ' || l_booking_id);
802: ota_tdb_shd.lck(l_booking_id,l_enr_ovn);
803: ota_tdb_api_upd2.Update_Enrollment(

Line 861: hr_utility.set_location('Entering:'|| l_proc, 60);

857:
858: IF l_daemon_type in ('D','C','W') THEN
859: FND_FILE.PUT_LINE(FND_FILE.LOG,'Auto waitlist processing for Daemon Type:' ||l_daemon_type );
860: FND_FILE.PUT_LINE(FND_FILE.LOG,'Auto waitlist processing for Event:' ||l_event_id);
861: hr_utility.set_location('Entering:'|| l_proc, 60);
862: OTA_OM_TDB_WAITLIST_API.AUTO_ENROLL_FROM_WAITLIST
863: (p_validate => false
864: ,p_business_group_id => l_enr_business_group_id
865: ,p_event_id => l_event_id

Line 871: hr_utility.set_location('Entering:'|| l_proc, 60);

867:
868: ELSIF l_daemon_type = 'E' THEN -- added for bug #1632104
869: FND_FILE.PUT_LINE(FND_FILE.LOG,'Auto waitlist processing for Daemon Type:' ||l_daemon_type );
870: FND_FILE.PUT_LINE(FND_FILE.LOG,'Auto waitlist processing for old Event:' ||l_old_event_id);
871: hr_utility.set_location('Entering:'|| l_proc, 60);
872: OTA_OM_TDB_WAITLIST_API.AUTO_ENROLL_FROM_WAITLIST
873: (p_validate => false
874: ,p_business_group_id => l_enr_business_group_id
875: ,p_event_id => l_old_event_id

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

909: -- fnd_message.raise_error;
910: rollback to Cancel_enrollment;
911: -- A validation or unexpected error has occured
912: --
913: hr_utility.set_location(' Leaving:'||l_proc, 80);
914: END;
915: END LOOP;
916: CLOSE C_enrollment;
917: hr_utility.set_location('Leaving:'|| l_proc, 70);

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

913: hr_utility.set_location(' Leaving:'||l_proc, 80);
914: END;
915: END LOOP;
916: CLOSE C_enrollment;
917: hr_utility.set_location('Leaving:'|| l_proc, 70);
918: exception
919: when e_validation_error then
920: --
921: l_err_num := SQLCODE;

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

930: -- A validation or unexpected error has occured
931: --
932:
933: -- rollback to Cancel_enrollment;
934: hr_utility.set_location(' Leaving:'||l_proc, 80);
935:
936: when others then
937: --
938: l_err_num := SQLCODE;

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

947: -- A validation or unexpected error has occured
948: --
949:
950: --rollback to Cancel_enrollment;
951: hr_utility.set_location(' Leaving:'||l_proc, 80);
952:
953: END cancel_enrollment;
954:
955:

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

1042: WHERE booking_id = l_booking_id;
1043:
1044:
1045: BEGIN
1046: hr_utility.set_location('Entering:'|| l_proc, 5);
1047: x_return_status := 'S';
1048: IF p_uom = 'EVT' AND p_operation = 'UPDATE' THEN
1049:
1050: OPEN C_event;

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

1053: l_event_ovn,
1054: l_max_attendee;
1055: IF c_event%found THEN
1056: IF l_max_attendee < p_max_attendee THEN
1057: hr_utility.set_location('Entering:'||l_proc, 10);
1058: ota_evt_upd.upd(
1059: p_Event_id => l_Event_Id
1060: ,P_Business_Group_id => l_event_Business_group_id
1061: ,P_Object_version_number => l_event_ovn

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

1104:
1105: END IF;
1106: END IF;
1107: CLOSE c_event;
1108: hr_utility.set_location(' Leaving:'||l_proc, 20);
1109: END IF;
1110: EXCEPTION
1111: WHEN OTHERS THEN
1112: x_return_status := 'E';