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);
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;
41: || ScenarioVersion || '
42: || ScenarioParam || '
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');
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));
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);
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);
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);
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);
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,'
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
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;
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:
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);
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);
114: || 'LOADPARAMETERSDATATOWORKREPPKG
115: || '
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));
115: || '
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', '');
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);
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);
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);
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);
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,'
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
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;
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:
186: ||'UPDATEVARIABLE
187: ||'E1TOAPSPROJECT.PVD_BASE_DATE='||BaseDate ||'
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));
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', '');
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);
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);
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);
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);
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,'
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
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;
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:
262: || 'SYNCHRONIZE_XML
263: || '
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));
263: || '
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', '');
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);
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);
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);
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);
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,'
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
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;
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:
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='
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);
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;
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');
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));
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);
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);
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);
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);
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,'
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
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;
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:
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);
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);
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));
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', '');
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);
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);
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);
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);
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,'
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
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;
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:
885: || '
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));
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', '');
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);
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);
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);
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);
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,'
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
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;
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:
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));
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', '');
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);
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);
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);
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);
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,'
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
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;
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: