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_MSG_PUB

Line 532: FOR j in 1..FND_MSG_PUB.Count_Msg LOOP

528: nCntMdaItm := nCntMdaItm + 1;
529: EXCEPTION
530: WHEN e_Errors THEN
531: l_msg_data := '';
532: FOR j in 1..FND_MSG_PUB.Count_Msg LOOP
533: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_msg_index => j,
534: p_encoded=>'F');
535: END LOOP;
536: UPDATE jtf_ih_media_items_stg SET Status_Fl = v_Status_Fl0, Session_Date = SYSDATE, Session_No = nSessionNo

Line 533: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_msg_index => j,

529: EXCEPTION
530: WHEN e_Errors THEN
531: l_msg_data := '';
532: FOR j in 1..FND_MSG_PUB.Count_Msg LOOP
533: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_msg_index => j,
534: p_encoded=>'F');
535: END LOOP;
536: UPDATE jtf_ih_media_items_stg SET Status_Fl = v_Status_Fl0, Session_Date = SYSDATE, Session_No = nSessionNo
537: WHERE Media_ID = l_media_id_stg AND (Session_No IN (nSessionNo,v_Session_no) OR Session_No IS NULL);

Line 659: FOR j in 1..FND_MSG_PUB.Count_Msg LOOP

655: nCntActiv := nCntActiv + SQL%ROWCOUNT;
656: EXCEPTION
657: WHEN e_Errors THEN
658: l_msg_data := '';
659: FOR j in 1..FND_MSG_PUB.Count_Msg LOOP
660: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_msg_index => j, p_encoded=>'F');
661: END LOOP;
662: UPDATE jtf_ih_interactions_stg SET Status_Fl = v_Status_Fl0, Session_Date = SYSDATE, Session_No = nSessionNo
663: WHERE Interaction_ID = l_interaction_stg AND (Session_No IN (nSessionNo,v_Session_no) OR Session_No IS NULL);

Line 660: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_msg_index => j, p_encoded=>'F');

656: EXCEPTION
657: WHEN e_Errors THEN
658: l_msg_data := '';
659: FOR j in 1..FND_MSG_PUB.Count_Msg LOOP
660: l_msg_data := l_msg_data || FND_MSG_PUB.Get(p_msg_index => j, p_encoded=>'F');
661: END LOOP;
662: UPDATE jtf_ih_interactions_stg SET Status_Fl = v_Status_Fl0, Session_Date = SYSDATE, Session_No = nSessionNo
663: WHERE Interaction_ID = l_interaction_stg AND (Session_No IN (nSessionNo,v_Session_no) OR Session_No IS NULL);
664: Insert_Interaction_Log(l_interaction_stg, l_msg_data, nSessionNo);