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.JTF_IH_IMPORT dependencies on FND_FILE

Line 64: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

60: EXCEPTION
61: WHEN OTHERS THEN
62: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_ERROR');
63: FND_MESSAGE.SET_TOKEN('ERRORMSG', SQLERRM);
64: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
65: --dbms_output.put_line('RETURN FALSE');
66: RETURN FALSE;
67: END;
68:

Line 248: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

244: WHEN excNoSessionNo THEN
245: --dbms_output.put_line('Session number not found');
246: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_SESS_ERR');
247: FND_MESSAGE.SET_TOKEN('SESSN', pnSessionNo);
248: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
249: --DBMS_OUTPUT.PUT_LINE(FND_MESSAGE.GET);
250: WHEN OTHERS THEN
251: -- dbms_output.put_line(To_Char(SQLCODE)||' : '||SQLERRM);
252: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_ERROR');

Line 254: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

250: WHEN OTHERS THEN
251: -- dbms_output.put_line(To_Char(SQLCODE)||' : '||SQLERRM);
252: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_ERROR');
253: FND_MESSAGE.SET_TOKEN('ERRORMSG', SQLERRM);
254: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
255: --DBMS_OUTPUT.PUT_LINE(FND_MESSAGE.GET);
256: END;
257:
258: PROCEDURE GO_IMPORT(ERRBUF OUT NOCOPY VARCHAR2, RETCODE OUT NOCOPY VARCHAR2) AS

Line 562: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

558: COMMIT;
559: WHEN OTHERS THEN
560: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_ERROR');
561: FND_MESSAGE.SET_TOKEN('ERRORMSG', SQLERRM);
562: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
563: END;
564: END LOOP;
565: CLOSE curMediaItem;
566: COMMIT;

Line 676: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

672: END LOOP;
673: WHEN OTHERS THEN
674: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_ERROR');
675: FND_MESSAGE.SET_TOKEN('ERRORMSG', SQLERRM);
676: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
677: END;
678: END LOOP;
679: CLOSE curInteraction;
680: COMMIT;

Line 686: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

682: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_REPORT');
683: FND_MESSAGE.SET_TOKEN('INTERACTIONS', to_char(nCntInter));
684: FND_MESSAGE.SET_TOKEN('ACTIVITIES', to_char(nCntActiv));
685: FND_MESSAGE.SET_TOKEN('MEDIAITEMS', to_char(nCntMdaItm));
686: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
687:
688: -- If import has any errors then show message about them
689: SELECT COUNT(*) INTO nErr_InterCnt FROM
690: (SELECT interaction_id FROM jtf_ih_interactions_stg_log

Line 705: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

701: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_DONE_WITH_ERRORS');
702: FND_MESSAGE.SET_TOKEN('INTERACTIONS', to_char(nErr_InterCnt));
703: FND_MESSAGE.SET_TOKEN('ACTIVITIES', to_char(nErr_ActivCnt));
704: FND_MESSAGE.SET_TOKEN('MEDIAITEMS', to_char(nErr_MediaCnt));
705: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
706: END IF;
707: --DBMS_OUTPUT.PUT_LINE(FND_MESSAGE.GET);
708: EXCEPTION
709: WHEN excNoSessionNo THEN

Line 713: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

709: WHEN excNoSessionNo THEN
710: -- dbms_output.put_line('Session number not found.');
711: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_ERROR');
712: FND_MESSAGE.SET_TOKEN('ERRORMSG', 'Session number not found.');
713: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
714: --DBMS_OUTPUT.PUT_LINE(FND_MESSAGE.GET);
715: WHEN NO_DATA_FOUND THEN
716: -- dbms_output.put_line('Data not found.');
717: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_ERROR');

Line 719: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

715: WHEN NO_DATA_FOUND THEN
716: -- dbms_output.put_line('Data not found.');
717: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_ERROR');
718: FND_MESSAGE.SET_TOKEN('ERRORMSG', SQLERRM);
719: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
720: --DBMS_OUTPUT.PUT_LINE(FND_MESSAGE.GET);
721: -- If exception occurs in the Test module then rollback
722: -- w/o messages, because they are already there
723: WHEN OTHERS THEN

Line 727: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

723: WHEN OTHERS THEN
724: -- dbms_output.put_line(To_Char(SQLCODE)||' : '||SQLERRM);
725: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_ERROR');
726: FND_MESSAGE.SET_TOKEN('ERRORMSG', SQLERRM);
727: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
728: --DBMS_OUTPUT.PUT_LINE(FND_MESSAGE.GET);
729: END;
730:
731:

Line 882: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

878: EXCEPTION
879: WHEN OTHERS THEN
880: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_ERROR');
881: FND_MESSAGE.SET_TOKEN('ERRORMSG', SQLERRM);
882: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
883: --dbms_output.put_line(FND_MESSAGE.GET);
884: END;
885:
886: -- Program History

Line 952: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

948: EXCEPTION
949: WHEN OTHERS THEN
950: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_ERROR');
951: FND_MESSAGE.SET_TOKEN('ERRORMSG', SQLERRM);
952: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
953: --dbms_output.put_line(FND_MESSAGE.GET);
954: END;
955:
956: -- Program History

Line 1097: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);

1093: EXCEPTION
1094: WHEN OTHERS THEN
1095: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_ERROR');
1096: FND_MESSAGE.SET_TOKEN('ERRORMSG', SQLERRM);
1097: FND_FILE.PUT_LINE(FND_FILE.LOG,FND_MESSAGE.GET);
1098: --dbms_output.put_line(FND_MESSAGE.GET);
1099: END;
1100: END;