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 JTF_IH_IMPORT

Line 1: PACKAGE BODY JTF_IH_IMPORT AS

1: PACKAGE BODY JTF_IH_IMPORT AS
2: /* $Header: JTFIHIMB.pls 115.50 2004/07/28 12:35:11 nchouras ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JTF_IH_IMPORT';
5: -- Program History

Line 4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JTF_IH_IMPORT';

1: PACKAGE BODY JTF_IH_IMPORT AS
2: /* $Header: JTFIHIMB.pls 115.50 2004/07/28 12:35:11 nchouras ship $ */
3:
4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'JTF_IH_IMPORT';
5: -- Program History
6: -- 08/01/01 - Added one more status for Status_Fl: 0 - The Record is not tested or tested or imported with errors
7: -- 1 - The Record was tested sucesseful
8: -- 2 - The Record was imported

Line 62: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_ERROR');

58: RETURN FALSE;
59: END IF;
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;

Line 136: SELECT JTF_IH_IMPORT_S1.NEXTVAL into nNxtSessionNo FROM DUAL;

132: END IF;
133: -- Get next session number.
134: --
135: -- dbms_output.put_line('Sessuib No:'||to_char(pnSessionNo));
136: SELECT JTF_IH_IMPORT_S1.NEXTVAL into nNxtSessionNo FROM DUAL;
137: if pnSessionNo IS NULL then
138: pnSessionNo := 0;
139: end if;
140: -- dbms_output.put_line('Current number Session is '||to_char(nNxtSessionNo));

Line 160: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_DUP_INTERACTION');

156:
157: -- dbms_output.put_line('Looking for Activities for current Interaction ');
158: IF ChkDuplicate('INTERACTION', curInteraction.Interaction_ID,pnSessionNo ) THEN
159: --dbms_output.put_line('Interaction has Duplicates!');
160: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_DUP_INTERACTION');
161: l_Message := FND_MESSAGE.GET;
162: RAISE e_ErrorInteraction;
163: END IF;
164:

Line 171: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_NO_ACTIVITY');

167: IF nCount = 0 THEN
168: -- dbms_output.put_line('Activities were not found for Interaction No: '||curInteraction.Interaction_ID);
169: UPDATE jtf_ih_interactions_stg SET Status_Fl = v_Status_Fl0, Session_Date = SYSDATE, Session_No = nNxtSessionNo
170: WHERE Interaction_ID = curInteraction.Interaction_ID and (Session_No = pnSessionNo OR Session_No IS NULL OR Session_No = v_Session_no);
171: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_NO_ACTIVITY');
172: l_Message := FND_MESSAGE.GET;
173: Insert_Interaction_Log(curInteraction.Interaction_ID, l_Message, nNxtSessionNo);
174: ELSE
175: FOR curActivity IN (SELECT Activity_ID, Media_ID FROM jtf_ih_activities_stg WHERE

Line 183: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_NO_MEDIAITEM');

179: /* Looking for Media_ID in the JTF_IH_MEDIA_ITEM_STG */
180: SELECT Count(*) INTO nCount FROM jtf_ih_media_items_stg
181: WHERE Media_ID = curActivity.Media_ID AND (Session_No IN (pnSessionNo, v_Session_no) OR Session_No IS NULL);
182: IF nCount = 0 THEN
183: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_NO_MEDIAITEM');
184: l_Message := FND_MESSAGE.GET;
185: raise e_ErrorInteraction;
186: END IF;
187: END IF;

Line 234: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_DUP_MEDIA_ITEM');

230: UPDATE jtf_ih_media_items_stg SET Status_Fl = v_Status_Fl1, Session_No = nNxtSessionNo, Session_Date = SYSDATE
231: WHERE Media_ID = sMedia_ID_Stg AND (Session_No = pnSessionNo OR Session_No IS NULL OR Session_No = v_Session_no);
232: EXCEPTION
233: WHEN e_ErrorMediaItem THEN
234: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_DUP_MEDIA_ITEM');
235: l_Message := FND_MESSAGE.GET;
236: --dbms_output.put_line('sMedia_ID_Stg = '||sMedia_ID_Stg);
237: UPDATE jtf_ih_media_items_stg SET Status_Fl = v_Status_Fl0, Session_Date = SYSDATE, Session_No = nNxtSessionNo
238: WHERE Media_Id = sMedia_ID_Stg and (Session_No = pnSessionNo OR Session_No IS NULL OR Session_No = v_Session_no);

Line 246: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_SESS_ERR');

242: COMMIT;
243: EXCEPTION
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

Line 252: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_ERROR');

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');
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;

Line 560: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_ERROR');

556: --nErr_InterCnt := nErr_InterCnt + 1;
557: END LOOP;
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;

Line 674: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_ERROR');

670: AND (Session_No IN (nSessionNo,v_Session_no) OR Session_No IS NULL)) LOOP
671: Insert_Activity_Log(currActivErr.Activity_ID,currActivErr.Interaction_ID, l_msg_data, nSessionNo);
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;

Line 682: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_REPORT');

678: END LOOP;
679: CLOSE curInteraction;
680: COMMIT;
681:
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);

Line 701: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_DONE_WITH_ERRORS');

697: SELECT COUNT(*) INTO nErr_MediaCnt FROM
698: (SELECT media_id FROM jtf_ih_media_items_stg_log
699: WHERE session_no = nSessionNo);
700: IF (nErr_InterCnt <> 0) OR (nErr_ActivCnt<> 0) OR (nErr_MediaCnt <> 0) THEN
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);

Line 711: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_ERROR');

707: --DBMS_OUTPUT.PUT_LINE(FND_MESSAGE.GET);
708: EXCEPTION
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

Line 717: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_ERROR');

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');
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

Line 725: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_ERROR');

721: -- If exception occurs in the Test module then rollback
722: -- w/o messages, because they are already there
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;

Line 880: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_ERROR');

876: FROM jtf_ih_interactions_stg WHERE interaction_id = nInteraction
877: AND session_no = nSessionNo;
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;

Line 950: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_ERROR');

946: WHERE Media_Id = nMediaID AND session_no = nSessionNo;
947:
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;

Line 1095: FND_MESSAGE.SET_NAME('JTF','JTF_IH_IMPORT_ERROR');

1091: AND Interaction_Id = nInteractionID
1092: AND session_no = nSessionNo;
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;