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

Line 15: request utl_http.req;

11: G_IS_DEBUG_PROCEDURE_ON BOOLEAN;
12:
13: PROCEDURE transport(p_transaction_number IN NUMBER)
14: IS
15: request utl_http.req;
16: response utl_http.resp;
17:
18: CURSOR c_tp IS
19: SELECT p.party_id, tp.tp_header_id, tp.party_site_id, tp.party_type

Line 16: response utl_http.resp;

12:
13: PROCEDURE transport(p_transaction_number IN NUMBER)
14: IS
15: request utl_http.req;
16: response utl_http.resp;
17:
18: CURSOR c_tp IS
19: SELECT p.party_id, tp.tp_header_id, tp.party_site_id, tp.party_type
20: FROM ecx_tp_headers tp

Line 79: utl_http.set_transfer_timeout(l_max_timeout);

75:
76: ----------------------------------------------------------------------------------
77: -- 1. Send the outbound xml to Proxy Server
78: ----------------------------------------------------------------------------------
79: utl_http.set_transfer_timeout(l_max_timeout);
80: -- bug8209104 start
81: IF upper(rec2.protocol_type) = 'HTTPS' THEN
82: IF(G_IS_DEBUG_PROCEDURE_ON) THEN
83: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': calling UTL_HTTP.SET_WALLET');

Line 83: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': calling UTL_HTTP.SET_WALLET');

79: utl_http.set_transfer_timeout(l_max_timeout);
80: -- bug8209104 start
81: IF upper(rec2.protocol_type) = 'HTTPS' THEN
82: IF(G_IS_DEBUG_PROCEDURE_ON) THEN
83: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': calling UTL_HTTP.SET_WALLET');
84: END IF;
85:
86: l_path := 'file:' || fnd_profile.value('FND_DB_WALLET_DIR');
87: l_password := fnd_preference.eget('#INTERNAL','WF_WEBSERVICES','EWALLETPWD', 'WFWS_PWD');

Line 89: UTL_HTTP.SET_WALLET (l_path, l_password);

85:
86: l_path := 'file:' || fnd_profile.value('FND_DB_WALLET_DIR');
87: l_password := fnd_preference.eget('#INTERNAL','WF_WEBSERVICES','EWALLETPWD', 'WFWS_PWD');
88:
89: UTL_HTTP.SET_WALLET (l_path, l_password);
90:
91: END IF;
92: -- bug8209104 end
93:

Line 94: -- request := utl_http.begin_request(l_url, 'POST', 'HTTP/1.0'); -- commented bug8209104

90:
91: END IF;
92: -- bug8209104 end
93:
94: -- request := utl_http.begin_request(l_url, 'POST', 'HTTP/1.0'); -- commented bug8209104
95: IF(G_IS_DEBUG_PROCEDURE_ON) THEN
96: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': calling utl_http.begin_request');
97: END IF;
98: request := utl_http.begin_request(url=>l_url, method=>'POST'); -- added bug8209104

Line 96: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': calling utl_http.begin_request');

92: -- bug8209104 end
93:
94: -- request := utl_http.begin_request(l_url, 'POST', 'HTTP/1.0'); -- commented bug8209104
95: IF(G_IS_DEBUG_PROCEDURE_ON) THEN
96: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': calling utl_http.begin_request');
97: END IF;
98: request := utl_http.begin_request(url=>l_url, method=>'POST'); -- added bug8209104
99: IF(G_IS_DEBUG_PROCEDURE_ON) THEN
100: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': calling utl_http.set_header');

Line 98: request := utl_http.begin_request(url=>l_url, method=>'POST'); -- added bug8209104

94: -- request := utl_http.begin_request(l_url, 'POST', 'HTTP/1.0'); -- commented bug8209104
95: IF(G_IS_DEBUG_PROCEDURE_ON) THEN
96: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': calling utl_http.begin_request');
97: END IF;
98: request := utl_http.begin_request(url=>l_url, method=>'POST'); -- added bug8209104
99: IF(G_IS_DEBUG_PROCEDURE_ON) THEN
100: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': calling utl_http.set_header');
101: END IF;
102: utl_http.set_header(request, 'Content-Type', 'application/x-www-form-urlencoded');

Line 100: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': calling utl_http.set_header');

96: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': calling utl_http.begin_request');
97: END IF;
98: request := utl_http.begin_request(url=>l_url, method=>'POST'); -- added bug8209104
99: IF(G_IS_DEBUG_PROCEDURE_ON) THEN
100: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': calling utl_http.set_header');
101: END IF;
102: utl_http.set_header(request, 'Content-Type', 'application/x-www-form-urlencoded');
103: utl_http.set_header(request, 'Content-Length', lengthb(l_parameter_data));
104: utl_http.write_text(request, l_parameter_data);

Line 102: utl_http.set_header(request, 'Content-Type', 'application/x-www-form-urlencoded');

98: request := utl_http.begin_request(url=>l_url, method=>'POST'); -- added bug8209104
99: IF(G_IS_DEBUG_PROCEDURE_ON) THEN
100: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': calling utl_http.set_header');
101: END IF;
102: utl_http.set_header(request, 'Content-Type', 'application/x-www-form-urlencoded');
103: utl_http.set_header(request, 'Content-Length', lengthb(l_parameter_data));
104: utl_http.write_text(request, l_parameter_data);
105:
106: ----------------------------------------------------------------------------------

Line 103: utl_http.set_header(request, 'Content-Length', lengthb(l_parameter_data));

99: IF(G_IS_DEBUG_PROCEDURE_ON) THEN
100: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': calling utl_http.set_header');
101: END IF;
102: utl_http.set_header(request, 'Content-Type', 'application/x-www-form-urlencoded');
103: utl_http.set_header(request, 'Content-Length', lengthb(l_parameter_data));
104: utl_http.write_text(request, l_parameter_data);
105:
106: ----------------------------------------------------------------------------------
107: -- 2. Get response from Proxy Server

Line 104: utl_http.write_text(request, l_parameter_data);

100: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': calling utl_http.set_header');
101: END IF;
102: utl_http.set_header(request, 'Content-Type', 'application/x-www-form-urlencoded');
103: utl_http.set_header(request, 'Content-Length', lengthb(l_parameter_data));
104: utl_http.write_text(request, l_parameter_data);
105:
106: ----------------------------------------------------------------------------------
107: -- 2. Get response from Proxy Server
108: ----------------------------------------------------------------------------------

Line 109: response := utl_http.get_response(request);

105:
106: ----------------------------------------------------------------------------------
107: -- 2. Get response from Proxy Server
108: ----------------------------------------------------------------------------------
109: response := utl_http.get_response(request);
110: utl_http.read_text(response, inbound_buffer);
111: utl_http.end_response(response);
112:
113: IF(G_IS_DEBUG_PROCEDURE_ON) THEN

Line 110: utl_http.read_text(response, inbound_buffer);

106: ----------------------------------------------------------------------------------
107: -- 2. Get response from Proxy Server
108: ----------------------------------------------------------------------------------
109: response := utl_http.get_response(request);
110: utl_http.read_text(response, inbound_buffer);
111: utl_http.end_response(response);
112:
113: IF(G_IS_DEBUG_PROCEDURE_ON) THEN
114: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': end okl_esg_transport_pvt.transport');

Line 111: utl_http.end_response(response);

107: -- 2. Get response from Proxy Server
108: ----------------------------------------------------------------------------------
109: response := utl_http.get_response(request);
110: utl_http.read_text(response, inbound_buffer);
111: utl_http.end_response(response);
112:
113: IF(G_IS_DEBUG_PROCEDURE_ON) THEN
114: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_PROCEDURE, l_module, p_transaction_number||': end okl_esg_transport_pvt.transport');
115: END IF;