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 7680: l_request UTL_HTTP.REQ;

7676: l_count NUMBER :=0 ;
7677: l_count1 NUMBER :=0 ;
7678: l_ticket_number VARCHAR2(2000);
7679: l_ticket_valid BOOLEAN:= FALSE;
7680: l_request UTL_HTTP.REQ;
7681: l_response UTL_HTTP.RESP;
7682: l_out_value VARCHAR2(32000);
7683: l_ibu_url VARCHAR2(2000);
7684: l_host VARCHAR2(2000);

Line 7681: l_response UTL_HTTP.RESP;

7677: l_count1 NUMBER :=0 ;
7678: l_ticket_number VARCHAR2(2000);
7679: l_ticket_valid BOOLEAN:= FALSE;
7680: l_request UTL_HTTP.REQ;
7681: l_response UTL_HTTP.RESP;
7682: l_out_value VARCHAR2(32000);
7683: l_ibu_url VARCHAR2(2000);
7684: l_host VARCHAR2(2000);
7685: l_request_number VARCHAR2(240);

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

7739: END IF;
7740:
7741: -- bug 5661159
7742: IF lower(substr(nvl(l_host, ''), 1, 5)) = 'https' THEN
7743: UTL_HTTP.SET_WALLET('file:' || FND_PROFILE.Value('FND_DB_WALLET_DIR'));
7744: END IF;
7745: -- bug 5661159_eof
7746:
7747: l_request := UTL_HTTP.BEGIN_REQUEST(l_host||l_ibu_url);

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

7743: UTL_HTTP.SET_WALLET('file:' || FND_PROFILE.Value('FND_DB_WALLET_DIR'));
7744: END IF;
7745: -- bug 5661159_eof
7746:
7747: l_request := UTL_HTTP.BEGIN_REQUEST(l_host||l_ibu_url);
7748:
7749: l_response := UTL_HTTP.Get_Response(l_request);
7750:
7751: LOOP

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

7745: -- bug 5661159_eof
7746:
7747: l_request := UTL_HTTP.BEGIN_REQUEST(l_host||l_ibu_url);
7748:
7749: l_response := UTL_HTTP.Get_Response(l_request);
7750:
7751: LOOP
7752: l_count := l_count + 1 ;
7753: UTL_HTTP.READ_LINE(l_response, l_out_value,TRUE);

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

7749: l_response := UTL_HTTP.Get_Response(l_request);
7750:
7751: LOOP
7752: l_count := l_count + 1 ;
7753: UTL_HTTP.READ_LINE(l_response, l_out_value,TRUE);
7754:
7755: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
7756: IF (FND_LOG.TEST(FND_LOG.LEVEL_PROCEDURE, 'cs.plsql.CS_WF_AUTO_NTFY_UPDATE_PKG.SET_HTML_NOTIFICATION_DETAILS')) THEN
7757: dbg_msg := ('l_count : '||l_count||' l_count1'||l_count1);

Line 7957: UTL_HTTP.End_Response(l_response);

7953: END IF;
7954:
7955: END LOOP;
7956:
7957: UTL_HTTP.End_Response(l_response);
7958:
7959: EXCEPTION
7960: WHEN UTL_HTTP.END_OF_BODY THEN
7961: UTL_HTTP.End_Response(l_response);

Line 7960: WHEN UTL_HTTP.END_OF_BODY THEN

7956:
7957: UTL_HTTP.End_Response(l_response);
7958:
7959: EXCEPTION
7960: WHEN UTL_HTTP.END_OF_BODY THEN
7961: UTL_HTTP.End_Response(l_response);
7962: WHEN OTHERS THEN
7963: WF_CORE.Context('CS_WF_AUTO_NTFY_UPDATE_PKG', 'Verify_Notify_Rules_Done',
7964: p_itemtype, p_itemkey, p_actid, p_funmode);

Line 7961: UTL_HTTP.End_Response(l_response);

7957: UTL_HTTP.End_Response(l_response);
7958:
7959: EXCEPTION
7960: WHEN UTL_HTTP.END_OF_BODY THEN
7961: UTL_HTTP.End_Response(l_response);
7962: WHEN OTHERS THEN
7963: WF_CORE.Context('CS_WF_AUTO_NTFY_UPDATE_PKG', 'Verify_Notify_Rules_Done',
7964: p_itemtype, p_itemkey, p_actid, p_funmode);
7965: RAISE;