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_COST_TRANSFER_TO_GL_PKG dependencies on FND_FILE

Line 363: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entering Finance Header :'

359: -- Main Loop for ota_finance_headers table
360: --
361: FOR ota_fh_row IN ota_fh_csr
362: LOOP
363: FND_FILE.PUT_LINE(FND_FILE.LOG,'Entering Finance Header :'
364: ||to_char(ota_fh_row.finance_header_id));
365:
366: l_success := 'T';
367: --

Line 422: FND_FILE.PUT_LINE(FND_FILE.LOG,'Insert into GL interface table for Paying cost center:' || ','

418: l_amount := 0;
419: end if;
420: --
421: if ota_fh_row.paying_cost_center is not null then
422: FND_FILE.PUT_LINE(FND_FILE.LOG,'Insert into GL interface table for Paying cost center:' || ','
423: ||ota_fh_row.paying_cost_center);
424: ota_tfh_api_shd.lck(ota_fh_row.finance_header_id,ota_fh_row.object_version_number); ---*** Bug#2820365
425: l_success := otagli (ota_fh_row.finance_header_id,
426: ota_fh_row.paying_cost_center,

Line 447: FND_FILE.PUT_LINE(FND_FILE.LOG,'Insert into GL interface table for Recieving cost center,'

443: l_amount := 0;
444: end if;
445:
446: --
447: FND_FILE.PUT_LINE(FND_FILE.LOG,'Insert into GL interface table for Recieving cost center,'
448: ||ota_fh_row.receiving_cost_center);
449: ota_tfh_api_shd.lck(ota_fh_row.finance_header_id,ota_fh_row.object_version_number); ---*** Bug#2820365
450: l_success := otagli (ota_fh_row.finance_header_id,
451: ota_fh_row.receiving_cost_center,

Line 485: FND_FILE.PUT_LINE(FND_FILE.LOG,'This Finance Header' || ','

481:
482:
483: --
484: else
485: FND_FILE.PUT_LINE(FND_FILE.LOG,'This Finance Header' || ','
486: ||to_char(ota_fh_row.finance_header_id)||' doesnot have paying cost center' );
487:
488: end if;
489: end if;

Line 494: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rollback for :'

490: end if;
491: CLOSE fl;
492:
493: IF l_success = 'F' then
494: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rollback for :'
495: ||to_char(ota_fh_row.finance_header_id));
496: ROLLBACK TO GL_TRANSFER;
497: ELSE
498: FND_FILE.PUT_LINE(FND_FILE.LOG,'Commiting for :'

Line 498: FND_FILE.PUT_LINE(FND_FILE.LOG,'Commiting for :'

494: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rollback for :'
495: ||to_char(ota_fh_row.finance_header_id));
496: ROLLBACK TO GL_TRANSFER;
497: ELSE
498: FND_FILE.PUT_LINE(FND_FILE.LOG,'Commiting for :'
499: ||to_char(ota_fh_row.finance_header_id));
500: COMMIT;
501: END IF;
502: end if;

Line 529: FND_FILE.PUT_LINE(FND_FILE.LOG,'Insert into GL interface table for Paying cost center:' || ','

525: l_amount := 0;
526: end if;
527: --
528: if ota_fh_row.paying_cost_center is not null then
529: FND_FILE.PUT_LINE(FND_FILE.LOG,'Insert into GL interface table for Paying cost center:' || ','
530: ||ota_fh_row.paying_cost_center);
531: ota_tfh_api_shd.lck(ota_fh_row.finance_header_id,ota_fh_row.object_version_number); ---*** Bug#2820365
532: l_success := otagli (ota_fh_row.finance_header_id,
533: ota_fh_row.paying_cost_center,

Line 554: FND_FILE.PUT_LINE(FND_FILE.LOG,'Insert into GL interface table for Recieving cost center,'

550: l_amount := 0;
551: end if;
552:
553: --
554: FND_FILE.PUT_LINE(FND_FILE.LOG,'Insert into GL interface table for Recieving cost center,'
555: ||ota_fh_row.receiving_cost_center);
556: ota_tfh_api_shd.lck(ota_fh_row.finance_header_id,ota_fh_row.object_version_number); ---*** Bug#2820365
557: l_success := otagli (ota_fh_row.finance_header_id,
558: ota_fh_row.receiving_cost_center,

Line 590: FND_FILE.PUT_LINE(FND_FILE.LOG,'This Finance Header' || ','

586: end if;
587:
588: --
589: else
590: FND_FILE.PUT_LINE(FND_FILE.LOG,'This Finance Header' || ','
591: ||to_char(ota_fh_row.finance_header_id)||' doesnot have paying cost center' );
592:
593: end if;
594: end if;

Line 599: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rollback for :'

595: end if;
596: CLOSE fl_resource;
597:
598: IF l_success = 'F' then
599: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rollback for :'
600: ||to_char(ota_fh_row.finance_header_id));
601: ROLLBACK TO GL_TRANSFER;
602: ELSE
603: FND_FILE.PUT_LINE(FND_FILE.LOG,'Commiting for :'

Line 603: FND_FILE.PUT_LINE(FND_FILE.LOG,'Commiting for :'

599: FND_FILE.PUT_LINE(FND_FILE.LOG,'Rollback for :'
600: ||to_char(ota_fh_row.finance_header_id));
601: ROLLBACK TO GL_TRANSFER;
602: ELSE
603: FND_FILE.PUT_LINE(FND_FILE.LOG,'Commiting for :'
604: ||to_char(ota_fh_row.finance_header_id));
605: COMMIT;
606: END IF;
607:

Line 612: FND_FILE.PUT_LINE(FND_FILE.LOG,'This Finance Header ' ||to_char(ota_fh_row.finance_header_id)||

608: end if;
609: CLOSE fl_check;
610:
611: ELSIF l_booking_id <> 0 and l_resource_booking_id <> 0 THEN
612: FND_FILE.PUT_LINE(FND_FILE.LOG,'This Finance Header ' ||to_char(ota_fh_row.finance_header_id)||
613: ' has not transferred to GL because it includes ');
614:
615: FND_FILE.PUT_LINE(FND_FILE.LOG,'both Enrollment and Resource Booking finance lines. You must submit ');
616:

Line 615: FND_FILE.PUT_LINE(FND_FILE.LOG,'both Enrollment and Resource Booking finance lines. You must submit ');

611: ELSIF l_booking_id <> 0 and l_resource_booking_id <> 0 THEN
612: FND_FILE.PUT_LINE(FND_FILE.LOG,'This Finance Header ' ||to_char(ota_fh_row.finance_header_id)||
613: ' has not transferred to GL because it includes ');
614:
615: FND_FILE.PUT_LINE(FND_FILE.LOG,'both Enrollment and Resource Booking finance lines. You must submit ');
616:
617: FND_FILE.PUT_LINE(FND_FILE.LOG,'Resource Booking and Enrollment lines under separate finance headers.');
618:
619: end if;

Line 617: FND_FILE.PUT_LINE(FND_FILE.LOG,'Resource Booking and Enrollment lines under separate finance headers.');

613: ' has not transferred to GL because it includes ');
614:
615: FND_FILE.PUT_LINE(FND_FILE.LOG,'both Enrollment and Resource Booking finance lines. You must submit ');
616:
617: FND_FILE.PUT_LINE(FND_FILE.LOG,'Resource Booking and Enrollment lines under separate finance headers.');
618:
619: end if;
620: ----------------------------*** Code (end ) added for Bug#2457158 ***------------------
621:

Line 627: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in Updating Finance header' || ','

623: WHEN l_finance_header_error then
624: l_err_num := SQLCODE;
625: l_err_msg := SUBSTR(SQLERRM, 1, 100);
626:
627: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in Updating Finance header' || ','
628: ||to_char(ota_fh_row.finance_header_id)||','|| l_err_msg);
629:
630: -- fnd_message.raise_error;
631: ROLLBACK TO GL_TRANSFER;

Line 636: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in Updating Finance line for header ' || ','

632: WHEN l_finance_line_error then
633: l_err_num := SQLCODE;
634: l_err_msg := SUBSTR(SQLERRM, 1, 100);
635:
636: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in Updating Finance line for header ' || ','
637: ||to_char(ota_fh_row.finance_header_id)||','|| l_err_msg);
638:
639: -- fnd_message.raise_error;
640: ROLLBACK TO GL_TRANSFER;

Line 645: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in creating GL ' || ','

641: WHEN l_cost_center_error then
642: l_err_num := SQLCODE;
643: l_err_msg := SUBSTR(SQLERRM, 1, 100);
644:
645: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in creating GL ' || ','
646: ||to_char(ota_fh_row.finance_header_id) ||','|| l_err_msg);
647:
648: -- fnd_message.raise_error;
649: ROLLBACK TO GL_TRANSFER;

Line 654: FND_FILE.PUT_LINE(FND_FILE.LOG,'When Others Error occured in ' || ','

650: WHEN OTHERS then
651: l_err_num := SQLCODE;
652: l_err_msg := SUBSTR(SQLERRM, 1, 100);
653:
654: FND_FILE.PUT_LINE(FND_FILE.LOG,'When Others Error occured in ' || ','
655: ||to_char(ota_fh_row.finance_header_id)||','||l_err_msg);
656:
657: -- fnd_message.raise_error;
658:

Line 678: FND_FILE.PUT_LINE(FND_FILE.LOG,'L_Cost_Center_error occured:' || ','

674:
675: --
676: v_err_num := SQLCODE;
677: v_err_msg := SUBSTR(SQLERRM, 1, 100);
678: FND_FILE.PUT_LINE(FND_FILE.LOG,'L_Cost_Center_error occured:' || ','
679: ||v_err_msg);
680: --
681: --
682: -- fnd_message.raise_error;

Line 699: FND_FILE.PUT_LINE(FND_FILE.LOG,'When Others Error occured : ' || ','

695: --
696: v_err_num := SQLCODE;
697: v_err_msg := SUBSTR(SQLERRM, 1, 100);
698:
699: FND_FILE.PUT_LINE(FND_FILE.LOG,'When Others Error occured : ' || ','
700: ||v_err_msg);
701: --
702: --
703: -- fnd_message.raise_error;

Line 728: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inserting in Insert to GL interface ');

724: --
725: -- Insert to gl interface
726: --
727: BEGIN
728: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inserting in Insert to GL interface ');
729: --
730: INSERT INTO gl_interface
731: (STATUS
732: ,LEDGER_ID -- Bug#6763652

Line 992: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in Inserting into GL interface '||' '||

988: WHEN OTHERS THEN
989: l_err_num := SQLCODE;
990: l_err_msg := SUBSTR(SQLERRM, 1, 100);
991: --
992: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in Inserting into GL interface '||' '||
993: to_char(p_finance_header_id)||','||l_err_msg);
994:
995: l_success := 'F';
996: return(l_success);

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

1064: --
1065: --
1066: l_err_num := SQLCODE;
1067: l_err_msg := SUBSTR(SQLERRM, 1, 100);
1068: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' ||
1069: 'Updating finance header'||' '||
1070: to_char(p_finance_header_id)||','||l_err_msg);
1071: l_success := 'F';
1072: --

Line 1190: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inserting into Update Finance Line ');

1186:
1187:
1188: --
1189: BEGIN
1190: FND_FILE.PUT_LINE(FND_FILE.LOG,'Inserting into Update Finance Line ');
1191: --
1192: FOR fl_rec IN fl LOOP
1193: l_date_raised := fl_rec.date_raised;
1194: l_sequence_number := fl_rec.sequence_number;

Line 1207: FND_FILE.PUT_LINE(FND_FILE.LOG,'Updating Finance line: ' ||

1203: p_transfer_date => sysdate,
1204: p_validate => false,
1205: p_transaction_type => 'UPDATE'); */
1206:
1207: FND_FILE.PUT_LINE(FND_FILE.LOG,'Updating Finance line: ' ||
1208: to_char(fl_rec.finance_line_id));
1209:
1210: UPDATE ota_finance_lines
1211: SET last_update_date = SYSDATE

Line 1225: FND_FILE.PUT_LINE(FND_FILE.LOG,'Updating Finance line: ' ||

1221: FOR fl_rec IN fl_resource LOOP
1222: l_date_raised := fl_rec.date_raised;
1223: l_sequence_number := fl_rec.sequence_number;
1224: l_line_ovn := fl_rec.object_version_number;
1225: FND_FILE.PUT_LINE(FND_FILE.LOG,'Updating Finance line: ' ||
1226: to_char(fl_rec.finance_line_id));
1227:
1228: UPDATE ota_finance_lines
1229: SET last_update_date = SYSDATE

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

1244: --
1245: l_err_num := SQLCODE;
1246: l_err_msg := SUBSTR(SQLERRM, 1, 100);
1247: --
1248: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error occured in ' ||
1249: 'Updating finance lines for header'||' '||
1250: to_char(p_finance_header_id)||','||l_err_msg);
1251:
1252: --