DBA Data[Home] [Help]

APPS.MSC_E1APS_UTIL dependencies on UTL_HTTP

Line 15: http_req utl_http.req;

11: ScenarioParam IN VARCHAR2,
12: WsUrl IN VARCHAR2 )
13: RETURN VARCHAR2 AS soap_request VARCHAR2(30000);
14: soap_respond VARCHAR2(30000);
15: http_req utl_http.req;
16: http_resp utl_http.resp;
17: StartIndex INTEGER;
18: EndIndex INTEGER;
19: returnStr VARCHAR2(2000);

Line 16: http_resp utl_http.resp;

12: WsUrl IN VARCHAR2 )
13: RETURN VARCHAR2 AS soap_request VARCHAR2(30000);
14: soap_respond VARCHAR2(30000);
15: http_req utl_http.req;
16: http_resp utl_http.resp;
17: StartIndex INTEGER;
18: EndIndex INTEGER;
19: returnStr VARCHAR2(2000);
20: Time_Out INTEGER;

Line 45: UTL_HTTP.set_transfer_timeout(Time_Out);

41: || ScenarioVersion || ''
42: || ScenarioParam || '
/env:Body>';
43:
44: Time_Out := fnd_profile.value('MSC_E1APS_WS_TIME_OUT');
45: UTL_HTTP.set_transfer_timeout(Time_Out);
46: -- UTL_HTTP.set_transfer_timeout(36000);
47:
48: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
49: utl_http.set_header(http_req, 'Content-Type', 'text/xml');

Line 46: -- UTL_HTTP.set_transfer_timeout(36000);

42: || ScenarioParam || '/env:Body>';
43:
44: Time_Out := fnd_profile.value('MSC_E1APS_WS_TIME_OUT');
45: UTL_HTTP.set_transfer_timeout(Time_Out);
46: -- UTL_HTTP.set_transfer_timeout(36000);
47:
48: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
49: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
50: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));

Line 48: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );

44: Time_Out := fnd_profile.value('MSC_E1APS_WS_TIME_OUT');
45: UTL_HTTP.set_transfer_timeout(Time_Out);
46: -- UTL_HTTP.set_transfer_timeout(36000);
47:
48: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
49: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
50: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
51: utl_http.set_header(http_req, 'SOAPAction', '');
52: utl_http.write_text(http_req, soap_request);

Line 49: utl_http.set_header(http_req, 'Content-Type', 'text/xml');

45: UTL_HTTP.set_transfer_timeout(Time_Out);
46: -- UTL_HTTP.set_transfer_timeout(36000);
47:
48: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
49: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
50: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
51: utl_http.set_header(http_req, 'SOAPAction', '');
52: utl_http.write_text(http_req, soap_request);
53: http_resp:= utl_http.get_response(http_req);

Line 50: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));

46: -- UTL_HTTP.set_transfer_timeout(36000);
47:
48: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
49: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
50: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
51: utl_http.set_header(http_req, 'SOAPAction', '');
52: utl_http.write_text(http_req, soap_request);
53: http_resp:= utl_http.get_response(http_req);
54: utl_http.read_text(http_resp, soap_respond);

Line 51: utl_http.set_header(http_req, 'SOAPAction', '');

47:
48: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
49: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
50: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
51: utl_http.set_header(http_req, 'SOAPAction', '');
52: utl_http.write_text(http_req, soap_request);
53: http_resp:= utl_http.get_response(http_req);
54: utl_http.read_text(http_resp, soap_respond);
55: utl_http.end_response(http_resp);

Line 52: utl_http.write_text(http_req, soap_request);

48: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
49: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
50: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
51: utl_http.set_header(http_req, 'SOAPAction', '');
52: utl_http.write_text(http_req, soap_request);
53: http_resp:= utl_http.get_response(http_req);
54: utl_http.read_text(http_resp, soap_respond);
55: utl_http.end_response(http_resp);
56: SELECT instr(soap_respond,'')

Line 53: http_resp:= utl_http.get_response(http_req);

49: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
50: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
51: utl_http.set_header(http_req, 'SOAPAction', '');
52: utl_http.write_text(http_req, soap_request);
53: http_resp:= utl_http.get_response(http_req);
54: utl_http.read_text(http_resp, soap_respond);
55: utl_http.end_response(http_resp);
56: SELECT instr(soap_respond,'')
57: INTO StartIndex

Line 54: utl_http.read_text(http_resp, soap_respond);

50: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
51: utl_http.set_header(http_req, 'SOAPAction', '');
52: utl_http.write_text(http_req, soap_request);
53: http_resp:= utl_http.get_response(http_req);
54: utl_http.read_text(http_resp, soap_respond);
55: utl_http.end_response(http_resp);
56: SELECT instr(soap_respond,'')
57: INTO StartIndex
58: FROM dual;

Line 55: utl_http.end_response(http_resp);

51: utl_http.set_header(http_req, 'SOAPAction', '');
52: utl_http.write_text(http_req, soap_request);
53: http_resp:= utl_http.get_response(http_req);
54: utl_http.read_text(http_resp, soap_respond);
55: utl_http.end_response(http_resp);
56: SELECT instr(soap_respond,'')
57: INTO StartIndex
58: FROM dual;
59:

Line 82: http_req utl_http.req;

78: FUNCTION MSC_E1APS_ODIInitialize ( WsUrl IN VARCHAR2,
79: BaseDate INTEGER )
80: RETURN VARCHAR2 AS soap_request VARCHAR2(30000);
81: soap_respond VARCHAR2(30000);
82: http_req utl_http.req;
83: http_resp utl_http.resp;
84: StartIndex INTEGER;
85: EndIndex INTEGER;
86: SessionNum VARCHAR2(10);

Line 83: http_resp utl_http.resp;

79: BaseDate INTEGER )
80: RETURN VARCHAR2 AS soap_request VARCHAR2(30000);
81: soap_respond VARCHAR2(30000);
82: http_req utl_http.req;
83: http_resp utl_http.resp;
84: StartIndex INTEGER;
85: EndIndex INTEGER;
86: SessionNum VARCHAR2(10);
87: ErrMessage VARCHAR2(1900);

Line 118: UTL_HTTP.set_transfer_timeout(Time_Out);

114: || 'LOADPARAMETERSDATATOWORKREPPKG001'
115: || '/env:Body>';
116:
117: Time_Out := fnd_profile.value('MSC_E1APS_WS_TIME_OUT');
118: UTL_HTTP.set_transfer_timeout(Time_Out);
119: -- UTL_HTTP.set_transfer_timeout(36000);
120: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
121: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
122: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));

Line 119: -- UTL_HTTP.set_transfer_timeout(36000);

115: || '/env:Body>';
116:
117: Time_Out := fnd_profile.value('MSC_E1APS_WS_TIME_OUT');
118: UTL_HTTP.set_transfer_timeout(Time_Out);
119: -- UTL_HTTP.set_transfer_timeout(36000);
120: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
121: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
122: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
123: utl_http.set_header(http_req, 'SOAPAction', '');

Line 120: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );

116:
117: Time_Out := fnd_profile.value('MSC_E1APS_WS_TIME_OUT');
118: UTL_HTTP.set_transfer_timeout(Time_Out);
119: -- UTL_HTTP.set_transfer_timeout(36000);
120: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
121: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
122: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
123: utl_http.set_header(http_req, 'SOAPAction', '');
124: utl_http.write_text(http_req, soap_request);

Line 121: utl_http.set_header(http_req, 'Content-Type', 'text/xml');

117: Time_Out := fnd_profile.value('MSC_E1APS_WS_TIME_OUT');
118: UTL_HTTP.set_transfer_timeout(Time_Out);
119: -- UTL_HTTP.set_transfer_timeout(36000);
120: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
121: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
122: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
123: utl_http.set_header(http_req, 'SOAPAction', '');
124: utl_http.write_text(http_req, soap_request);
125: http_resp:= utl_http.get_response(http_req);

Line 122: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));

118: UTL_HTTP.set_transfer_timeout(Time_Out);
119: -- UTL_HTTP.set_transfer_timeout(36000);
120: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
121: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
122: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
123: utl_http.set_header(http_req, 'SOAPAction', '');
124: utl_http.write_text(http_req, soap_request);
125: http_resp:= utl_http.get_response(http_req);
126: utl_http.read_text(http_resp, soap_respond);

Line 123: utl_http.set_header(http_req, 'SOAPAction', '');

119: -- UTL_HTTP.set_transfer_timeout(36000);
120: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
121: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
122: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
123: utl_http.set_header(http_req, 'SOAPAction', '');
124: utl_http.write_text(http_req, soap_request);
125: http_resp:= utl_http.get_response(http_req);
126: utl_http.read_text(http_resp, soap_respond);
127: utl_http.end_response(http_resp);

Line 124: utl_http.write_text(http_req, soap_request);

120: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
121: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
122: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
123: utl_http.set_header(http_req, 'SOAPAction', '');
124: utl_http.write_text(http_req, soap_request);
125: http_resp:= utl_http.get_response(http_req);
126: utl_http.read_text(http_resp, soap_respond);
127: utl_http.end_response(http_resp);
128: SELECT instr(soap_respond,'')

Line 125: http_resp:= utl_http.get_response(http_req);

121: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
122: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
123: utl_http.set_header(http_req, 'SOAPAction', '');
124: utl_http.write_text(http_req, soap_request);
125: http_resp:= utl_http.get_response(http_req);
126: utl_http.read_text(http_resp, soap_respond);
127: utl_http.end_response(http_resp);
128: SELECT instr(soap_respond,'')
129: INTO StartIndex

Line 126: utl_http.read_text(http_resp, soap_respond);

122: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
123: utl_http.set_header(http_req, 'SOAPAction', '');
124: utl_http.write_text(http_req, soap_request);
125: http_resp:= utl_http.get_response(http_req);
126: utl_http.read_text(http_resp, soap_respond);
127: utl_http.end_response(http_resp);
128: SELECT instr(soap_respond,'')
129: INTO StartIndex
130: FROM dual;

Line 127: utl_http.end_response(http_resp);

123: utl_http.set_header(http_req, 'SOAPAction', '');
124: utl_http.write_text(http_req, soap_request);
125: http_resp:= utl_http.get_response(http_req);
126: utl_http.read_text(http_resp, soap_respond);
127: utl_http.end_response(http_resp);
128: SELECT instr(soap_respond,'')
129: INTO StartIndex
130: FROM dual;
131:

Line 190: UTL_HTTP.set_transfer_timeout(Time_Out);

186: ||'UPDATEVARIABLE001'
187: ||'E1TOAPSPROJECT.PVD_BASE_DATE='||BaseDate ||'
/env:Body>';
188:
189: Time_Out := fnd_profile.value('MSC_E1APS_WS_TIME_OUT');
190: UTL_HTTP.set_transfer_timeout(Time_Out);
191: --UTL_HTTP.set_transfer_timeout(36000);
192: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
193: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
194: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));

Line 191: --UTL_HTTP.set_transfer_timeout(36000);

187: ||'E1TOAPSPROJECT.PVD_BASE_DATE='||BaseDate ||'/env:Body>';
188:
189: Time_Out := fnd_profile.value('MSC_E1APS_WS_TIME_OUT');
190: UTL_HTTP.set_transfer_timeout(Time_Out);
191: --UTL_HTTP.set_transfer_timeout(36000);
192: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
193: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
194: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
195: utl_http.set_header(http_req, 'SOAPAction', '');

Line 192: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );

188:
189: Time_Out := fnd_profile.value('MSC_E1APS_WS_TIME_OUT');
190: UTL_HTTP.set_transfer_timeout(Time_Out);
191: --UTL_HTTP.set_transfer_timeout(36000);
192: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
193: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
194: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
195: utl_http.set_header(http_req, 'SOAPAction', '');
196: utl_http.write_text(http_req, soap_request);

Line 193: utl_http.set_header(http_req, 'Content-Type', 'text/xml');

189: Time_Out := fnd_profile.value('MSC_E1APS_WS_TIME_OUT');
190: UTL_HTTP.set_transfer_timeout(Time_Out);
191: --UTL_HTTP.set_transfer_timeout(36000);
192: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
193: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
194: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
195: utl_http.set_header(http_req, 'SOAPAction', '');
196: utl_http.write_text(http_req, soap_request);
197: http_resp:= utl_http.get_response(http_req);

Line 194: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));

190: UTL_HTTP.set_transfer_timeout(Time_Out);
191: --UTL_HTTP.set_transfer_timeout(36000);
192: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
193: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
194: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
195: utl_http.set_header(http_req, 'SOAPAction', '');
196: utl_http.write_text(http_req, soap_request);
197: http_resp:= utl_http.get_response(http_req);
198: utl_http.read_text(http_resp, soap_respond);

Line 195: utl_http.set_header(http_req, 'SOAPAction', '');

191: --UTL_HTTP.set_transfer_timeout(36000);
192: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
193: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
194: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
195: utl_http.set_header(http_req, 'SOAPAction', '');
196: utl_http.write_text(http_req, soap_request);
197: http_resp:= utl_http.get_response(http_req);
198: utl_http.read_text(http_resp, soap_respond);
199: utl_http.end_response(http_resp);

Line 196: utl_http.write_text(http_req, soap_request);

192: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
193: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
194: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
195: utl_http.set_header(http_req, 'SOAPAction', '');
196: utl_http.write_text(http_req, soap_request);
197: http_resp:= utl_http.get_response(http_req);
198: utl_http.read_text(http_resp, soap_respond);
199: utl_http.end_response(http_resp);
200: SELECT instr(soap_respond,'')

Line 197: http_resp:= utl_http.get_response(http_req);

193: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
194: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
195: utl_http.set_header(http_req, 'SOAPAction', '');
196: utl_http.write_text(http_req, soap_request);
197: http_resp:= utl_http.get_response(http_req);
198: utl_http.read_text(http_resp, soap_respond);
199: utl_http.end_response(http_resp);
200: SELECT instr(soap_respond,'')
201: INTO StartIndex

Line 198: utl_http.read_text(http_resp, soap_respond);

194: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
195: utl_http.set_header(http_req, 'SOAPAction', '');
196: utl_http.write_text(http_req, soap_request);
197: http_resp:= utl_http.get_response(http_req);
198: utl_http.read_text(http_resp, soap_respond);
199: utl_http.end_response(http_resp);
200: SELECT instr(soap_respond,'')
201: INTO StartIndex
202: FROM dual;

Line 199: utl_http.end_response(http_resp);

195: utl_http.set_header(http_req, 'SOAPAction', '');
196: utl_http.write_text(http_req, soap_request);
197: http_resp:= utl_http.get_response(http_req);
198: utl_http.read_text(http_resp, soap_respond);
199: utl_http.end_response(http_resp);
200: SELECT instr(soap_respond,'')
201: INTO StartIndex
202: FROM dual;
203:

Line 266: UTL_HTTP.set_transfer_timeout(Time_Out);

262: || 'SYNCHRONIZE_XML001'
263: || '/env:Body>';
264:
265: Time_Out := fnd_profile.value('MSC_E1APS_WS_TIME_OUT');
266: UTL_HTTP.set_transfer_timeout(Time_Out);
267: -- UTL_HTTP.set_transfer_timeout(36000);
268: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
269: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
270: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));

Line 267: -- UTL_HTTP.set_transfer_timeout(36000);

263: || '/env:Body>';
264:
265: Time_Out := fnd_profile.value('MSC_E1APS_WS_TIME_OUT');
266: UTL_HTTP.set_transfer_timeout(Time_Out);
267: -- UTL_HTTP.set_transfer_timeout(36000);
268: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
269: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
270: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
271: utl_http.set_header(http_req, 'SOAPAction', '');

Line 268: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );

264:
265: Time_Out := fnd_profile.value('MSC_E1APS_WS_TIME_OUT');
266: UTL_HTTP.set_transfer_timeout(Time_Out);
267: -- UTL_HTTP.set_transfer_timeout(36000);
268: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
269: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
270: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
271: utl_http.set_header(http_req, 'SOAPAction', '');
272: utl_http.write_text(http_req, soap_request);

Line 269: utl_http.set_header(http_req, 'Content-Type', 'text/xml');

265: Time_Out := fnd_profile.value('MSC_E1APS_WS_TIME_OUT');
266: UTL_HTTP.set_transfer_timeout(Time_Out);
267: -- UTL_HTTP.set_transfer_timeout(36000);
268: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
269: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
270: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
271: utl_http.set_header(http_req, 'SOAPAction', '');
272: utl_http.write_text(http_req, soap_request);
273: http_resp:= utl_http.get_response(http_req);

Line 270: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));

266: UTL_HTTP.set_transfer_timeout(Time_Out);
267: -- UTL_HTTP.set_transfer_timeout(36000);
268: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
269: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
270: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
271: utl_http.set_header(http_req, 'SOAPAction', '');
272: utl_http.write_text(http_req, soap_request);
273: http_resp:= utl_http.get_response(http_req);
274: utl_http.read_text(http_resp, soap_respond);

Line 271: utl_http.set_header(http_req, 'SOAPAction', '');

267: -- UTL_HTTP.set_transfer_timeout(36000);
268: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
269: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
270: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
271: utl_http.set_header(http_req, 'SOAPAction', '');
272: utl_http.write_text(http_req, soap_request);
273: http_resp:= utl_http.get_response(http_req);
274: utl_http.read_text(http_resp, soap_respond);
275: utl_http.end_response(http_resp);

Line 272: utl_http.write_text(http_req, soap_request);

268: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
269: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
270: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
271: utl_http.set_header(http_req, 'SOAPAction', '');
272: utl_http.write_text(http_req, soap_request);
273: http_resp:= utl_http.get_response(http_req);
274: utl_http.read_text(http_resp, soap_respond);
275: utl_http.end_response(http_resp);
276: SELECT instr(soap_respond,'')

Line 273: http_resp:= utl_http.get_response(http_req);

269: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
270: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
271: utl_http.set_header(http_req, 'SOAPAction', '');
272: utl_http.write_text(http_req, soap_request);
273: http_resp:= utl_http.get_response(http_req);
274: utl_http.read_text(http_resp, soap_respond);
275: utl_http.end_response(http_resp);
276: SELECT instr(soap_respond,'')
277: INTO StartIndex

Line 274: utl_http.read_text(http_resp, soap_respond);

270: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
271: utl_http.set_header(http_req, 'SOAPAction', '');
272: utl_http.write_text(http_req, soap_request);
273: http_resp:= utl_http.get_response(http_req);
274: utl_http.read_text(http_resp, soap_respond);
275: utl_http.end_response(http_resp);
276: SELECT instr(soap_respond,'')
277: INTO StartIndex
278: FROM dual;

Line 275: utl_http.end_response(http_resp);

271: utl_http.set_header(http_req, 'SOAPAction', '');
272: utl_http.write_text(http_req, soap_request);
273: http_resp:= utl_http.get_response(http_req);
274: utl_http.read_text(http_resp, soap_respond);
275: utl_http.end_response(http_resp);
276: SELECT instr(soap_respond,'')
277: INTO StartIndex
278: FROM dual;
279:

Line 391: utl_http.request('''

387: l_schema_name := msd_dem_common_utilities.get_app_id_text ('MSD_DEM_DEMANTRA_OBJECT_ID', l_wf_lookup_code, 1, 'schema_name');
388: l_schema_name := trim(l_schema_name);
389: l_sql := NULL;
390: l_sql := 'SELECT
391: utl_http.request('''
392: ||l_url
393: ||'/WorkflowServer?action=run_proc&user='
394: ||l_user_name
395: ||'&password='

Line 736: http_req utl_http.req;

732: ScenarioParam IN VARCHAR2,
733: WsUrl IN VARCHAR2 )
734: RETURN VARCHAR2 AS soap_request VARCHAR2(30000);
735: soap_respond VARCHAR2(30000);
736: http_req utl_http.req;
737: http_resp utl_http.resp;
738: StartIndex INTEGER;
739: EndIndex INTEGER;
740: returnStr VARCHAR2(2000);

Line 737: http_resp utl_http.resp;

733: WsUrl IN VARCHAR2 )
734: RETURN VARCHAR2 AS soap_request VARCHAR2(30000);
735: soap_respond VARCHAR2(30000);
736: http_req utl_http.req;
737: http_resp utl_http.resp;
738: StartIndex INTEGER;
739: EndIndex INTEGER;
740: returnStr VARCHAR2(2000);
741: Time_Out INTEGER;

Line 760: UTL_HTTP.set_transfer_timeout(Time_Out);

756: || ''
757: ||'';
758:
759: Time_Out := fnd_profile.value('MSC_E1APS_WS_TIME_OUT');
760: UTL_HTTP.set_transfer_timeout(Time_Out);
761: -- UTL_HTTP.set_transfer_timeout(36000);
762:
763: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
764: utl_http.set_header(http_req, 'Content-Type', 'text/xml');

Line 761: -- UTL_HTTP.set_transfer_timeout(36000);

757: ||'';
758:
759: Time_Out := fnd_profile.value('MSC_E1APS_WS_TIME_OUT');
760: UTL_HTTP.set_transfer_timeout(Time_Out);
761: -- UTL_HTTP.set_transfer_timeout(36000);
762:
763: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
764: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
765: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));

Line 763: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );

759: Time_Out := fnd_profile.value('MSC_E1APS_WS_TIME_OUT');
760: UTL_HTTP.set_transfer_timeout(Time_Out);
761: -- UTL_HTTP.set_transfer_timeout(36000);
762:
763: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
764: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
765: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
766: utl_http.set_header(http_req, 'SOAPAction', '');
767: utl_http.write_text(http_req, soap_request);

Line 764: utl_http.set_header(http_req, 'Content-Type', 'text/xml');

760: UTL_HTTP.set_transfer_timeout(Time_Out);
761: -- UTL_HTTP.set_transfer_timeout(36000);
762:
763: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
764: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
765: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
766: utl_http.set_header(http_req, 'SOAPAction', '');
767: utl_http.write_text(http_req, soap_request);
768: http_resp:= utl_http.get_response(http_req);

Line 765: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));

761: -- UTL_HTTP.set_transfer_timeout(36000);
762:
763: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
764: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
765: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
766: utl_http.set_header(http_req, 'SOAPAction', '');
767: utl_http.write_text(http_req, soap_request);
768: http_resp:= utl_http.get_response(http_req);
769: utl_http.read_text(http_resp, soap_respond);

Line 766: utl_http.set_header(http_req, 'SOAPAction', '');

762:
763: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
764: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
765: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
766: utl_http.set_header(http_req, 'SOAPAction', '');
767: utl_http.write_text(http_req, soap_request);
768: http_resp:= utl_http.get_response(http_req);
769: utl_http.read_text(http_resp, soap_respond);
770: utl_http.end_response(http_resp);

Line 767: utl_http.write_text(http_req, soap_request);

763: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
764: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
765: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
766: utl_http.set_header(http_req, 'SOAPAction', '');
767: utl_http.write_text(http_req, soap_request);
768: http_resp:= utl_http.get_response(http_req);
769: utl_http.read_text(http_resp, soap_respond);
770: utl_http.end_response(http_resp);
771: SELECT instr(soap_respond,'')

Line 768: http_resp:= utl_http.get_response(http_req);

764: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
765: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
766: utl_http.set_header(http_req, 'SOAPAction', '');
767: utl_http.write_text(http_req, soap_request);
768: http_resp:= utl_http.get_response(http_req);
769: utl_http.read_text(http_resp, soap_respond);
770: utl_http.end_response(http_resp);
771: SELECT instr(soap_respond,'')
772: INTO StartIndex

Line 769: utl_http.read_text(http_resp, soap_respond);

765: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
766: utl_http.set_header(http_req, 'SOAPAction', '');
767: utl_http.write_text(http_req, soap_request);
768: http_resp:= utl_http.get_response(http_req);
769: utl_http.read_text(http_resp, soap_respond);
770: utl_http.end_response(http_resp);
771: SELECT instr(soap_respond,'')
772: INTO StartIndex
773: FROM dual;

Line 770: utl_http.end_response(http_resp);

766: utl_http.set_header(http_req, 'SOAPAction', '');
767: utl_http.write_text(http_req, soap_request);
768: http_resp:= utl_http.get_response(http_req);
769: utl_http.read_text(http_resp, soap_respond);
770: utl_http.end_response(http_resp);
771: SELECT instr(soap_respond,'')
772: INTO StartIndex
773: FROM dual;
774:

Line 796: http_req utl_http.req;

792: FUNCTION MSC_E1APS_ODIInitialize10g ( WsUrl IN VARCHAR2,
793: BaseDate INTEGER )
794: RETURN VARCHAR2 AS soap_request VARCHAR2(30000);
795: soap_respond VARCHAR2(30000);
796: http_req utl_http.req;
797: http_resp utl_http.resp;
798: StartIndex INTEGER;
799: EndIndex INTEGER;
800: SessionNum VARCHAR2(10);

Line 797: http_resp utl_http.resp;

793: BaseDate INTEGER )
794: RETURN VARCHAR2 AS soap_request VARCHAR2(30000);
795: soap_respond VARCHAR2(30000);
796: http_req utl_http.req;
797: http_resp utl_http.resp;
798: StartIndex INTEGER;
799: EndIndex INTEGER;
800: SessionNum VARCHAR2(10);
801: ErrMessage VARCHAR2(1900);

Line 822: UTL_HTTP.set_transfer_timeout(Time_Out);

818: || ''
819: ||'';
820:
821: Time_Out := fnd_profile.value('MSC_E1APS_WS_TIME_OUT');
822: UTL_HTTP.set_transfer_timeout(Time_Out);
823: -- UTL_HTTP.set_transfer_timeout(36000);
824: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
825: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
826: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));

Line 823: -- UTL_HTTP.set_transfer_timeout(36000);

819: ||'';
820:
821: Time_Out := fnd_profile.value('MSC_E1APS_WS_TIME_OUT');
822: UTL_HTTP.set_transfer_timeout(Time_Out);
823: -- UTL_HTTP.set_transfer_timeout(36000);
824: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
825: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
826: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
827: utl_http.set_header(http_req, 'SOAPAction', '');

Line 824: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );

820:
821: Time_Out := fnd_profile.value('MSC_E1APS_WS_TIME_OUT');
822: UTL_HTTP.set_transfer_timeout(Time_Out);
823: -- UTL_HTTP.set_transfer_timeout(36000);
824: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
825: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
826: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
827: utl_http.set_header(http_req, 'SOAPAction', '');
828: utl_http.write_text(http_req, soap_request);

Line 825: utl_http.set_header(http_req, 'Content-Type', 'text/xml');

821: Time_Out := fnd_profile.value('MSC_E1APS_WS_TIME_OUT');
822: UTL_HTTP.set_transfer_timeout(Time_Out);
823: -- UTL_HTTP.set_transfer_timeout(36000);
824: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
825: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
826: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
827: utl_http.set_header(http_req, 'SOAPAction', '');
828: utl_http.write_text(http_req, soap_request);
829: http_resp:= utl_http.get_response(http_req);

Line 826: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));

822: UTL_HTTP.set_transfer_timeout(Time_Out);
823: -- UTL_HTTP.set_transfer_timeout(36000);
824: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
825: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
826: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
827: utl_http.set_header(http_req, 'SOAPAction', '');
828: utl_http.write_text(http_req, soap_request);
829: http_resp:= utl_http.get_response(http_req);
830: utl_http.read_text(http_resp, soap_respond);

Line 827: utl_http.set_header(http_req, 'SOAPAction', '');

823: -- UTL_HTTP.set_transfer_timeout(36000);
824: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
825: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
826: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
827: utl_http.set_header(http_req, 'SOAPAction', '');
828: utl_http.write_text(http_req, soap_request);
829: http_resp:= utl_http.get_response(http_req);
830: utl_http.read_text(http_resp, soap_respond);
831: utl_http.end_response(http_resp);

Line 828: utl_http.write_text(http_req, soap_request);

824: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
825: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
826: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
827: utl_http.set_header(http_req, 'SOAPAction', '');
828: utl_http.write_text(http_req, soap_request);
829: http_resp:= utl_http.get_response(http_req);
830: utl_http.read_text(http_resp, soap_respond);
831: utl_http.end_response(http_resp);
832: SELECT instr(soap_respond,'')

Line 829: http_resp:= utl_http.get_response(http_req);

825: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
826: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
827: utl_http.set_header(http_req, 'SOAPAction', '');
828: utl_http.write_text(http_req, soap_request);
829: http_resp:= utl_http.get_response(http_req);
830: utl_http.read_text(http_resp, soap_respond);
831: utl_http.end_response(http_resp);
832: SELECT instr(soap_respond,'')
833: INTO StartIndex

Line 830: utl_http.read_text(http_resp, soap_respond);

826: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
827: utl_http.set_header(http_req, 'SOAPAction', '');
828: utl_http.write_text(http_req, soap_request);
829: http_resp:= utl_http.get_response(http_req);
830: utl_http.read_text(http_resp, soap_respond);
831: utl_http.end_response(http_resp);
832: SELECT instr(soap_respond,'')
833: INTO StartIndex
834: FROM dual;

Line 831: utl_http.end_response(http_resp);

827: utl_http.set_header(http_req, 'SOAPAction', '');
828: utl_http.write_text(http_req, soap_request);
829: http_resp:= utl_http.get_response(http_req);
830: utl_http.read_text(http_resp, soap_respond);
831: utl_http.end_response(http_resp);
832: SELECT instr(soap_respond,'')
833: INTO StartIndex
834: FROM dual;
835:

Line 889: UTL_HTTP.set_transfer_timeout(Time_Out);

885: || 'E1TOAPSPROJECT.PVD_BASE_DATE='||BaseDate ||''
886: || ''
887: || ''
888: ||'';
889: UTL_HTTP.set_transfer_timeout(Time_Out);
890: --UTL_HTTP.set_transfer_timeout(36000);
891: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
892: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
893: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));

Line 890: --UTL_HTTP.set_transfer_timeout(36000);

886: || ''
887: || ''
888: ||'';
889: UTL_HTTP.set_transfer_timeout(Time_Out);
890: --UTL_HTTP.set_transfer_timeout(36000);
891: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
892: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
893: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
894: utl_http.set_header(http_req, 'SOAPAction', '');

Line 891: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );

887: || ''
888: ||'';
889: UTL_HTTP.set_transfer_timeout(Time_Out);
890: --UTL_HTTP.set_transfer_timeout(36000);
891: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
892: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
893: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
894: utl_http.set_header(http_req, 'SOAPAction', '');
895: utl_http.write_text(http_req, soap_request);

Line 892: utl_http.set_header(http_req, 'Content-Type', 'text/xml');

888: ||'';
889: UTL_HTTP.set_transfer_timeout(Time_Out);
890: --UTL_HTTP.set_transfer_timeout(36000);
891: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
892: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
893: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
894: utl_http.set_header(http_req, 'SOAPAction', '');
895: utl_http.write_text(http_req, soap_request);
896: http_resp:= utl_http.get_response(http_req);

Line 893: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));

889: UTL_HTTP.set_transfer_timeout(Time_Out);
890: --UTL_HTTP.set_transfer_timeout(36000);
891: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
892: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
893: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
894: utl_http.set_header(http_req, 'SOAPAction', '');
895: utl_http.write_text(http_req, soap_request);
896: http_resp:= utl_http.get_response(http_req);
897: utl_http.read_text(http_resp, soap_respond);

Line 894: utl_http.set_header(http_req, 'SOAPAction', '');

890: --UTL_HTTP.set_transfer_timeout(36000);
891: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
892: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
893: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
894: utl_http.set_header(http_req, 'SOAPAction', '');
895: utl_http.write_text(http_req, soap_request);
896: http_resp:= utl_http.get_response(http_req);
897: utl_http.read_text(http_resp, soap_respond);
898: utl_http.end_response(http_resp);

Line 895: utl_http.write_text(http_req, soap_request);

891: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
892: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
893: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
894: utl_http.set_header(http_req, 'SOAPAction', '');
895: utl_http.write_text(http_req, soap_request);
896: http_resp:= utl_http.get_response(http_req);
897: utl_http.read_text(http_resp, soap_respond);
898: utl_http.end_response(http_resp);
899: SELECT instr(soap_respond,'')

Line 896: http_resp:= utl_http.get_response(http_req);

892: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
893: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
894: utl_http.set_header(http_req, 'SOAPAction', '');
895: utl_http.write_text(http_req, soap_request);
896: http_resp:= utl_http.get_response(http_req);
897: utl_http.read_text(http_resp, soap_respond);
898: utl_http.end_response(http_resp);
899: SELECT instr(soap_respond,'')
900: INTO StartIndex

Line 897: utl_http.read_text(http_resp, soap_respond);

893: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
894: utl_http.set_header(http_req, 'SOAPAction', '');
895: utl_http.write_text(http_req, soap_request);
896: http_resp:= utl_http.get_response(http_req);
897: utl_http.read_text(http_resp, soap_respond);
898: utl_http.end_response(http_resp);
899: SELECT instr(soap_respond,'')
900: INTO StartIndex
901: FROM dual;

Line 898: utl_http.end_response(http_resp);

894: utl_http.set_header(http_req, 'SOAPAction', '');
895: utl_http.write_text(http_req, soap_request);
896: http_resp:= utl_http.get_response(http_req);
897: utl_http.read_text(http_resp, soap_respond);
898: utl_http.end_response(http_resp);
899: SELECT instr(soap_respond,'')
900: INTO StartIndex
901: FROM dual;
902:

Line 958: UTL_HTTP.set_transfer_timeout(Time_Out);

954: || ''
955: ||'';
956:
957: Time_Out := fnd_profile.value('MSC_E1APS_WS_TIME_OUT');
958: UTL_HTTP.set_transfer_timeout(Time_Out);
959: -- UTL_HTTP.set_transfer_timeout(36000);
960: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
961: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
962: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));

Line 959: -- UTL_HTTP.set_transfer_timeout(36000);

955: ||'';
956:
957: Time_Out := fnd_profile.value('MSC_E1APS_WS_TIME_OUT');
958: UTL_HTTP.set_transfer_timeout(Time_Out);
959: -- UTL_HTTP.set_transfer_timeout(36000);
960: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
961: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
962: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
963: utl_http.set_header(http_req, 'SOAPAction', '');

Line 960: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );

956:
957: Time_Out := fnd_profile.value('MSC_E1APS_WS_TIME_OUT');
958: UTL_HTTP.set_transfer_timeout(Time_Out);
959: -- UTL_HTTP.set_transfer_timeout(36000);
960: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
961: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
962: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
963: utl_http.set_header(http_req, 'SOAPAction', '');
964: utl_http.write_text(http_req, soap_request);

Line 961: utl_http.set_header(http_req, 'Content-Type', 'text/xml');

957: Time_Out := fnd_profile.value('MSC_E1APS_WS_TIME_OUT');
958: UTL_HTTP.set_transfer_timeout(Time_Out);
959: -- UTL_HTTP.set_transfer_timeout(36000);
960: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
961: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
962: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
963: utl_http.set_header(http_req, 'SOAPAction', '');
964: utl_http.write_text(http_req, soap_request);
965: http_resp:= utl_http.get_response(http_req);

Line 962: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));

958: UTL_HTTP.set_transfer_timeout(Time_Out);
959: -- UTL_HTTP.set_transfer_timeout(36000);
960: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
961: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
962: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
963: utl_http.set_header(http_req, 'SOAPAction', '');
964: utl_http.write_text(http_req, soap_request);
965: http_resp:= utl_http.get_response(http_req);
966: utl_http.read_text(http_resp, soap_respond);

Line 963: utl_http.set_header(http_req, 'SOAPAction', '');

959: -- UTL_HTTP.set_transfer_timeout(36000);
960: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
961: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
962: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
963: utl_http.set_header(http_req, 'SOAPAction', '');
964: utl_http.write_text(http_req, soap_request);
965: http_resp:= utl_http.get_response(http_req);
966: utl_http.read_text(http_resp, soap_respond);
967: utl_http.end_response(http_resp);

Line 964: utl_http.write_text(http_req, soap_request);

960: http_req:= utl_http.begin_request ( WsUrl, 'POST', 'HTTP/1.1' );
961: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
962: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
963: utl_http.set_header(http_req, 'SOAPAction', '');
964: utl_http.write_text(http_req, soap_request);
965: http_resp:= utl_http.get_response(http_req);
966: utl_http.read_text(http_resp, soap_respond);
967: utl_http.end_response(http_resp);
968: SELECT instr(soap_respond,'')

Line 965: http_resp:= utl_http.get_response(http_req);

961: utl_http.set_header(http_req, 'Content-Type', 'text/xml');
962: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
963: utl_http.set_header(http_req, 'SOAPAction', '');
964: utl_http.write_text(http_req, soap_request);
965: http_resp:= utl_http.get_response(http_req);
966: utl_http.read_text(http_resp, soap_respond);
967: utl_http.end_response(http_resp);
968: SELECT instr(soap_respond,'')
969: INTO StartIndex

Line 966: utl_http.read_text(http_resp, soap_respond);

962: utl_http.set_header(http_req, 'Content-Length', LENGTH(soap_request));
963: utl_http.set_header(http_req, 'SOAPAction', '');
964: utl_http.write_text(http_req, soap_request);
965: http_resp:= utl_http.get_response(http_req);
966: utl_http.read_text(http_resp, soap_respond);
967: utl_http.end_response(http_resp);
968: SELECT instr(soap_respond,'')
969: INTO StartIndex
970: FROM dual;

Line 967: utl_http.end_response(http_resp);

963: utl_http.set_header(http_req, 'SOAPAction', '');
964: utl_http.write_text(http_req, soap_request);
965: http_resp:= utl_http.get_response(http_req);
966: utl_http.read_text(http_resp, soap_respond);
967: utl_http.end_response(http_resp);
968: SELECT instr(soap_respond,'')
969: INTO StartIndex
970: FROM dual;
971: