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 FND_FILE

Line 562: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Start test of concurrent program');

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:
562: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Start test of concurrent program');
563: IF l_single_business_group_id is not null then
564: l_business_group_id := l_single_business_group_id;
565: ELSE
566: l_business_group_id := fnd_profile.value('PER_BUSINESS_GROUP_ID');

Line 589: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Daemon type :' || l_daemon_type );

585: BEGIN
586: savepoint Cancel_enrollment;
587: l_return_status := 'T';
588: IF l_daemon_type = 'C' then
589: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Daemon type :' || l_daemon_type );
590: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing booking id : ' || l_booking_id);
591: OPEN c_lines;
592: FETCH c_lines INTO l_Finance_Line_id,
593: l_Finance_header_id,

Line 590: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing booking id : ' || l_booking_id);

586: savepoint Cancel_enrollment;
587: l_return_status := 'T';
588: IF l_daemon_type = 'C' then
589: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Daemon type :' || l_daemon_type );
590: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing booking id : ' || l_booking_id);
591: OPEN c_lines;
592: FETCH c_lines INTO l_Finance_Line_id,
593: l_Finance_header_id,
594: l_line_transfer_Status,

Line 601: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cancelling Finance Line for booking id : ' || l_booking_id);

597: l_Date_raised ;
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,

Line 616: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc||' '||

612: p_transaction_type => 'UPDATE');
613: exception when others then
614: l_err_num := SQLCODE;
615: l_err_msg := SUBSTR(SQLERRM, 1, 100);
616: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc||' '||
617: 'Booking Id :'||to_char(l_booking_id)||','||
618: 'Finance_line_id :'||to_char(l_finance_line_id)||','||l_err_msg);
619: l_return_status := 'F';
620: END;

Line 631: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cancelling Finance Header for booking id : ' || l_booking_id);

627: l_header_Transfer_status;
628: IF c_header%found THEN
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

Line 642: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc||' '||

638: ,p_Transaction_type => 'UPDATE');
639: exception when others then
640: l_err_num := SQLCODE;
641: l_err_msg := SUBSTR(SQLERRM, 1, 100);
642: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc||' '||
643: 'Booking Id :'||to_char(l_booking_id)||','||
644: 'Finance_header_id :'||to_char(l_finance_header_id)||','||l_err_msg);
645: l_return_status := 'F';
646: END;

Line 659: FND_FILE.PUT_LINE(FND_FILE.LOG,'Updating booking id : ' || l_booking_id);

655: CLOSE C_lines;
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

Line 680: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc||' '||

676: ,p_status_change_comments => null); /* Bug# 3469326 */
677: exception when others then
678: l_err_num := SQLCODE;
679: l_err_msg := SUBSTR(SQLERRM, 1, 500);
680: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc||' '||
681: to_char(l_booking_id)||','||l_err_msg);
682: l_return_status := 'F';
683:
684: END;

Line 686: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc||' '||

682: l_return_status := 'F';
683:
684: END;
685: ELSE
686: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc||' '||
687: to_char(l_booking_id)||','||'OTA:OM Default Enrollment Cancalled Status profile '||
688: 'value has not been defined yet' );
689: l_return_status := 'F';
690:

Line 694: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Daemon type :' || l_daemon_type );

690:
691: END IF;
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);

Line 695: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing booking id : ' || l_booking_id);

691: END IF;
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);

Line 698: FND_FILE.PUT_LINE(FND_FILE.LOG,'Updating booking id : ' || l_booking_id);

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(
701: p_booking_id => l_booking_id
702: ,p_booking_status_type_id => l_booking_status_type_id

Line 718: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc||' '||

714: ,p_status_change_comments => null); /* Bug# 3469326 */
715: EXCEPTION WHEN OTHERS THEN
716: l_err_num := SQLCODE;
717: l_err_msg := SUBSTR(SQLERRM, 1, 500);
718: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc||' '||
719: to_char(l_booking_id)||','||l_err_msg);
720: l_return_status := 'F';
721: END;
722: /** Created for Bug 1576558 **/

Line 725: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Daemon type :' || l_daemon_type );

721: END;
722: /** Created for Bug 1576558 **/
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:

Line 726: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing booking id : ' || l_booking_id);

722: /** Created for Bug 1576558 **/
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

Line 731: FND_FILE.PUT_LINE(FND_FILE.LOG,'Updating 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);
732: ota_tdb_shd.lck(l_booking_id,l_enr_ovn);
733: ota_tdb_api_upd2.Update_Enrollment(
734: p_booking_id => l_booking_id
735: ,p_booking_status_type_id => l_status_id

Line 754: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc||' '||

750:
751: EXCEPTION WHEN OTHERS THEN
752: l_err_num := SQLCODE;
753: l_err_msg := SUBSTR(SQLERRM, 1, 500);
754: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc||' '||
755: to_char(l_booking_id)||','||l_err_msg);
756: l_return_status := 'F';
757: END;
758: ELSE

Line 759: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc||' '||

755: to_char(l_booking_id)||','||l_err_msg);
756: l_return_status := 'F';
757: END;
758: ELSE
759: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc||' '||
760: to_char(l_booking_id)||','||'OTA:OM Default Enrollment Cancalled Status profile '||
761: 'value has not been defined yet' );
762: l_return_status := 'F';
763:

Line 768: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Daemon type :' || l_daemon_type );

764: END IF;
765: /** End Created for Bug 1576558 **/
766:
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

Line 769: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing booking id : ' || l_booking_id);

765: /** End Created for Bug 1576558 **/
766:
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);

Line 773: FND_FILE.PUT_LINE(FND_FILE.LOG,'Updating booking id : ' || l_booking_id);

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(
776: p_booking_id => l_booking_id
777: ,p_booking_status_type_id => l_booking_status_type_id

Line 791: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc||' '||

787: ,p_status_change_comments => null); /* Bug# 3469326 */
788: EXCEPTION WHEN OTHERS THEN
789: l_err_num := SQLCODE;
790: l_err_msg := SUBSTR(SQLERRM, 1, 100);
791: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc||' '||
792: to_char(l_booking_id)||','||l_err_msg);
793: l_return_status := 'F';
794: END;
795:

Line 797: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing Daemon type :' || l_daemon_type );

793: l_return_status := 'F';
794: END;
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);

Line 798: FND_FILE.PUT_LINE(FND_FILE.LOG,'Processing booking id : ' || l_booking_id);

794: END;
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);

Line 801: FND_FILE.PUT_LINE(FND_FILE.LOG,'Updating booking id : ' || l_booking_id);

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(
804: p_booking_id => l_booking_id
805: ,p_booking_status_type_id => l_booking_status_type_id

Line 820: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc||' '||

816: ,p_status_change_comments => null); /* Bug# 3469326 */
817: EXCEPTION WHEN OTHERS THEN
818: l_err_num := SQLCODE;
819: l_err_msg := SUBSTR(SQLERRM, 1, 100);
820: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc||' '||
821: to_char(l_booking_id)||','||l_err_msg);
822: l_return_status := 'F';
823: END;
824:

Line 828: FND_FILE.PUT_LINE(FND_FILE.LOG,'Auto Waitlist profile value is :' || l_auto_waitlist );

824:
825: END IF;
826: IF l_return_status = 'T' then
827: IF l_auto_waitlist = 'Y' THEN
828: FND_FILE.PUT_LINE(FND_FILE.LOG,'Auto Waitlist profile value is :' || l_auto_waitlist );
829: IF l_daemon_type in ('D','C','W','E') THEN -- modified for bug #1632104
830:
831: IF l_daemon_type in ('D','C','W') THEN
832: FND_FILE.PUT_LINE(FND_FILE.LOG,'Daemon type :' ||l_daemon_type );

Line 832: FND_FILE.PUT_LINE(FND_FILE.LOG,'Daemon type :' ||l_daemon_type );

828: FND_FILE.PUT_LINE(FND_FILE.LOG,'Auto Waitlist profile value is :' || l_auto_waitlist );
829: IF l_daemon_type in ('D','C','W','E') THEN -- modified for bug #1632104
830:
831: IF l_daemon_type in ('D','C','W') THEN
832: FND_FILE.PUT_LINE(FND_FILE.LOG,'Daemon type :' ||l_daemon_type );
833: OPEN c_event_date(l_event_id);
834: FETCH c_event_date into l_event_date,l_owner_id;
835: CLOSE c_event_date;
836:

Line 842: FND_FILE.PUT_LINE(FND_FILE.LOG,'Daemon type :' ||l_daemon_type );

838: FETCH c_sysdate INTO l_sysdate;
839: CLOSE c_sysdate;
840:
841: ELSIF l_daemon_type = 'E' THEN -- added for bug #1632104
842: FND_FILE.PUT_LINE(FND_FILE.LOG,'Daemon type :' ||l_daemon_type );
843: OPEN c_event_date(l_old_event_id);
844: FETCH c_event_date into l_event_date,l_owner_id;
845: CLOSE c_event_date;
846:

Line 859: FND_FILE.PUT_LINE(FND_FILE.LOG,'Auto waitlist processing for Daemon Type:' ||l_daemon_type );

855:
856: IF l_different_hours > nvl(l_cancel_hours,0) THEN
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

Line 860: FND_FILE.PUT_LINE(FND_FILE.LOG,'Auto waitlist processing for Event:' ||l_event_id);

856: IF l_different_hours > nvl(l_cancel_hours,0) THEN
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

Line 869: FND_FILE.PUT_LINE(FND_FILE.LOG,'Auto waitlist processing for Daemon Type:' ||l_daemon_type );

865: ,p_event_id => l_event_id
866: ,p_return_status => l_return_status);
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

Line 870: FND_FILE.PUT_LINE(FND_FILE.LOG,'Auto waitlist processing for old Event:' ||l_old_event_id);

866: ,p_return_status => l_return_status);
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

Line 881: FND_FILE.PUT_LINE(FND_FILE.LOG,'Please do a manual waitlist for Event :'|| l_old_event_id );

877:
878: END IF;
879: /* ELSE
880: IF l_daemon_type = 'E'
881: FND_FILE.PUT_LINE(FND_FILE.LOG,'Please do a manual waitlist for Event :'|| l_old_event_id );
882: ELSE
883: IF l_daemon_type in ('D','C','W') then
884: FND_FILE.PUT_LINE(FND_FILE.LOG,'Please do a manual waitlist for Event :'|| l_event_id );
885: END IF;

Line 884: FND_FILE.PUT_LINE(FND_FILE.LOG,'Please do a manual waitlist for Event :'|| l_event_id );

880: IF l_daemon_type = 'E'
881: FND_FILE.PUT_LINE(FND_FILE.LOG,'Please do a manual waitlist for Event :'|| l_old_event_id );
882: ELSE
883: IF l_daemon_type in ('D','C','W') then
884: FND_FILE.PUT_LINE(FND_FILE.LOG,'Please do a manual waitlist for Event :'|| l_event_id );
885: END IF;
886: END IF; */
887: END IF;
888:

Line 893: FND_FILE.PUT_LINE(FND_FILE.LOG,'Committing for Booking_id :' ||l_booking_id);

889: END IF;
890: END IF;
891: END IF;
892: IF l_return_status = 'T' THEN
893: FND_FILE.PUT_LINE(FND_FILE.LOG,'Committing for Booking_id :' ||l_booking_id);
894: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------');
895: COMMIT;
896: ELSE
897: rollback to Cancel_enrollment;

Line 894: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------');

890: END IF;
891: END IF;
892: IF l_return_status = 'T' THEN
893: FND_FILE.PUT_LINE(FND_FILE.LOG,'Committing for Booking_id :' ||l_booking_id);
894: FND_FILE.PUT_LINE(FND_FILE.LOG,'-------------------------------------------');
895: COMMIT;
896: ELSE
897: rollback to Cancel_enrollment;
898: END IF;

Line 906: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc||' '||

902: l_err_num := SQLCODE;
903: l_err_msg := SUBSTR(SQLERRM, 1, 500);
904: --
905: --
906: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc||' '||
907: to_char(l_booking_id)||','||l_err_msg);
908:
909: -- fnd_message.raise_error;
910: rollback to Cancel_enrollment;

Line 925: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc||' '||

921: l_err_num := SQLCODE;
922: l_err_msg := SUBSTR(SQLERRM, 1, 100);
923: --
924: --
925: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc||' '||
926: to_char(l_booking_id)||','||l_err_msg);
927:
928: fnd_message.raise_error;
929:

Line 942: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc||' '||

938: l_err_num := SQLCODE;
939: l_err_msg := SUBSTR(SQLERRM, 1, 500);
940: --
941: --
942: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc||' '||
943: to_char(l_booking_id)||','||l_err_msg);
944:
945: fnd_message.raise_error;
946:

Line 1171: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc

1167: ota_cancel_api.cancel_enrollment(p_user_id,
1168: p_login_id);
1169: EXCEPTION
1170: when others then
1171: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' || l_proc
1172: ||','||SUBSTR(SQLERRM, 1, 500));
1173:
1174: END;
1175: