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.CS_WF_AUTO_NTFY_UPDATE_PKG dependencies on UTL_HTTP

Line 7616: l_request UTL_HTTP.REQ;

7612: l_count NUMBER :=0 ;
7613: l_count1 NUMBER :=0 ;
7614: l_ticket_number VARCHAR2(2000);
7615: l_ticket_valid BOOLEAN:= FALSE;
7616: l_request UTL_HTTP.REQ;
7617: l_response UTL_HTTP.RESP;
7618: l_out_value VARCHAR2(32000);
7619: l_ibu_url VARCHAR2(2000);
7620: l_host VARCHAR2(2000);

Line 7617: l_response UTL_HTTP.RESP;

7613: l_count1 NUMBER :=0 ;
7614: l_ticket_number VARCHAR2(2000);
7615: l_ticket_valid BOOLEAN:= FALSE;
7616: l_request UTL_HTTP.REQ;
7617: l_response UTL_HTTP.RESP;
7618: l_out_value VARCHAR2(32000);
7619: l_ibu_url VARCHAR2(2000);
7620: l_host VARCHAR2(2000);
7621: l_request_number VARCHAR2(240);

Line 7679: UTL_HTTP.SET_WALLET('file:' || FND_PROFILE.Value('FND_DB_WALLET_DIR'));

7675: END IF;
7676:
7677: -- bug 5661159
7678: IF lower(substr(nvl(l_host, ''), 1, 5)) = 'https' THEN
7679: UTL_HTTP.SET_WALLET('file:' || FND_PROFILE.Value('FND_DB_WALLET_DIR'));
7680: END IF;
7681: -- bug 5661159_eof
7682:
7683: l_request := UTL_HTTP.BEGIN_REQUEST(l_host||l_ibu_url);

Line 7683: l_request := UTL_HTTP.BEGIN_REQUEST(l_host||l_ibu_url);

7679: UTL_HTTP.SET_WALLET('file:' || FND_PROFILE.Value('FND_DB_WALLET_DIR'));
7680: END IF;
7681: -- bug 5661159_eof
7682:
7683: l_request := UTL_HTTP.BEGIN_REQUEST(l_host||l_ibu_url);
7684:
7685: l_response := UTL_HTTP.Get_Response(l_request);
7686:
7687: LOOP

Line 7685: l_response := UTL_HTTP.Get_Response(l_request);

7681: -- bug 5661159_eof
7682:
7683: l_request := UTL_HTTP.BEGIN_REQUEST(l_host||l_ibu_url);
7684:
7685: l_response := UTL_HTTP.Get_Response(l_request);
7686:
7687: LOOP
7688: l_count := l_count + 1 ;
7689: UTL_HTTP.READ_LINE(l_response, l_out_value,TRUE);

Line 7689: UTL_HTTP.READ_LINE(l_response, l_out_value,TRUE);

7685: l_response := UTL_HTTP.Get_Response(l_request);
7686:
7687: LOOP
7688: l_count := l_count + 1 ;
7689: UTL_HTTP.READ_LINE(l_response, l_out_value,TRUE);
7690:
7691: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
7692: IF (FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_WF_AUTO_NTFY_UPDATE_PKG.SET_HTML_NOTIFICATION_DETAILS')) THEN
7693: dbg_msg := ('l_count : '||l_count||' l_count1'||l_count1);

Line 7893: UTL_HTTP.End_Response(l_response);

7889: END IF;
7890:
7891: END LOOP;
7892:
7893: UTL_HTTP.End_Response(l_response);
7894:
7895: EXCEPTION
7896: WHEN UTL_HTTP.END_OF_BODY THEN
7897: UTL_HTTP.End_Response(l_response);

Line 7896: WHEN UTL_HTTP.END_OF_BODY THEN

7892:
7893: UTL_HTTP.End_Response(l_response);
7894:
7895: EXCEPTION
7896: WHEN UTL_HTTP.END_OF_BODY THEN
7897: UTL_HTTP.End_Response(l_response);
7898: WHEN OTHERS THEN
7899: WF_CORE.Context('CS_WF_AUTO_NTFY_UPDATE_PKG', 'Verify_Notify_Rules_Done',
7900: p_itemtype, p_itemkey, p_actid, p_funmode);

Line 7897: UTL_HTTP.End_Response(l_response);

7893: UTL_HTTP.End_Response(l_response);
7894:
7895: EXCEPTION
7896: WHEN UTL_HTTP.END_OF_BODY THEN
7897: UTL_HTTP.End_Response(l_response);
7898: WHEN OTHERS THEN
7899: WF_CORE.Context('CS_WF_AUTO_NTFY_UPDATE_PKG', 'Verify_Notify_Rules_Done',
7900: p_itemtype, p_itemkey, p_actid, p_funmode);
7901: RAISE;