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_STREAMS_WF dependencies on WF_ENGINE

Line 78: IF (funcmode <> wf_engine.eng_run) THEN

74:
75: BEGIN
76: -- Do nothing in cancel or timeout mode
77:
78: IF (funcmode <> wf_engine.eng_run) THEN
79: resultout := wf_engine.eng_null;
80: RETURN;
81: END IF;
82: --

Line 79: resultout := wf_engine.eng_null;

75: BEGIN
76: -- Do nothing in cancel or timeout mode
77:
78: IF (funcmode <> wf_engine.eng_run) THEN
79: resultout := wf_engine.eng_null;
80: RETURN;
81: END IF;
82: --
83: -- We need to determine which parameters are required and which are optional

Line 85: l_transaction_number := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'PARAMETER1');

81: END IF;
82: --
83: -- We need to determine which parameters are required and which are optional
84: --
85: l_transaction_number := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'PARAMETER1');
86: IF ( l_transaction_number IS NULL ) THEN
87: wf_core.token('OKL_TRANSACTION_NUMBER','NULL');
88: wf_core.RAISE('WFSQL_ARGS');
89: END IF;

Line 94: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER2');

90:
91: --
92: -- params2..10 optional
93: --
94: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER2');
95: parameter3 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER3');
96: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER4');
97: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER5');
98: parameter6 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER6');

Line 95: parameter3 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER3');

91: --
92: -- params2..10 optional
93: --
94: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER2');
95: parameter3 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER3');
96: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER4');
97: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER5');
98: parameter6 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER6');
99: parameter7 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER7');

Line 96: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER4');

92: -- params2..10 optional
93: --
94: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER2');
95: parameter3 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER3');
96: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER4');
97: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER5');
98: parameter6 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER6');
99: parameter7 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER7');
100: parameter8 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER8');

Line 97: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER5');

93: --
94: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER2');
95: parameter3 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER3');
96: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER4');
97: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER5');
98: parameter6 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER6');
99: parameter7 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER7');
100: parameter8 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER8');
101: parameter9 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER9');

Line 98: parameter6 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER6');

94: parameter2 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER2');
95: parameter3 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER3');
96: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER4');
97: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER5');
98: parameter6 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER6');
99: parameter7 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER7');
100: parameter8 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER8');
101: parameter9 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER9');
102: parameter10 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER10');

Line 99: parameter7 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER7');

95: parameter3 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER3');
96: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER4');
97: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER5');
98: parameter6 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER6');
99: parameter7 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER7');
100: parameter8 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER8');
101: parameter9 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER9');
102: parameter10 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER10');
103:

Line 100: parameter8 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER8');

96: parameter4 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER4');
97: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER5');
98: parameter6 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER6');
99: parameter7 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER7');
100: parameter8 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER8');
101: parameter9 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER9');
102: parameter10 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER10');
103:
104: -- Invoke Process Stream Results API

Line 101: parameter9 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER9');

97: parameter5 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER5');
98: parameter6 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER6');
99: parameter7 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER7');
100: parameter8 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER8');
101: parameter9 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER9');
102: parameter10 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER10');
103:
104: -- Invoke Process Stream Results API
105: FOR strm_interfaces_data in strm_interfaces_data_csr(l_transaction_number)

Line 102: parameter10 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER10');

98: parameter6 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER6');
99: parameter7 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER7');
100: parameter8 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER8');
101: parameter9 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER9');
102: parameter10 := Wf_Engine.GetActivityAttrText(itemtype, itemkey,actid, 'PARAMETER10');
103:
104: -- Invoke Process Stream Results API
105: FOR strm_interfaces_data in strm_interfaces_data_csr(l_transaction_number)
106: LOOP

Line 178: wf_engine.SetItemAttrText(itemtype,itemkey,l_attr_name, l_error_msg);

174:
175: -- commented for using REPORT ERROR API
176: -- l_error_msg := 'Errors while processing results, please refer to log file ' || 'OKLSTXMLG_' || l_transaction_number || '.log' || ' for more details';
177: l_error_msg := ' ';
178: wf_engine.SetItemAttrText(itemtype,itemkey,l_attr_name, l_error_msg);
179:
180: l_error_message_tbl(1) := 'Errors while processing Streams Results :- ';
181:
182: Okl_Streams_Util.LOG_MESSAGE(p_msgs_tbl => l_error_message_tbl,

Line 209: resultout := wf_engine.eng_completed || ':' || 'F';

205: x_return_status => l_return_status
206: );
207:
208:
209: resultout := wf_engine.eng_completed || ':' || 'F';
210: ELSE
211: resultout := wf_engine.eng_completed || ':' || 'T';
212: END IF;
213:

Line 211: resultout := wf_engine.eng_completed || ':' || 'T';

207:
208:
209: resultout := wf_engine.eng_completed || ':' || 'F';
210: ELSE
211: resultout := wf_engine.eng_completed || ':' || 'T';
212: END IF;
213:
214: EXCEPTION
215: WHEN OTHERS THEN

Line 252: IF (funcmode <> wf_engine.eng_run) THEN

248: l_file_name VARCHAR2(100);
249:
250: BEGIN
251: -- Do nothing in cancel or timeout mode
252: IF (funcmode <> wf_engine.eng_run) THEN
253: resultout := wf_engine.eng_null;
254: RETURN;
255: END IF;
256:

Line 253: resultout := wf_engine.eng_null;

249:
250: BEGIN
251: -- Do nothing in cancel or timeout mode
252: IF (funcmode <> wf_engine.eng_run) THEN
253: resultout := wf_engine.eng_null;
254: RETURN;
255: END IF;
256:
257: l_document_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'OKL_REQUEST_ID');

Line 257: l_document_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'OKL_REQUEST_ID');

253: resultout := wf_engine.eng_null;
254: RETURN;
255: END IF;
256:
257: l_document_id := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'OKL_REQUEST_ID');
258: IF ( l_document_id IS NULL ) THEN
259: wf_core.token('OKL_REQUEST_ID','NULL');
260: wf_core.RAISE('WFSQL_ARGS');
261: END IF;

Line 263: l_msg_name := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'OKL_ERROR_MSG');

259: wf_core.token('OKL_REQUEST_ID','NULL');
260: wf_core.RAISE('WFSQL_ARGS');
261: END IF;
262:
263: l_msg_name := Wf_Engine.GetActivityAttrText(itemtype, itemkey, actid, 'OKL_ERROR_MSG');
264: IF ( l_document_id IS NULL ) THEN
265: wf_core.token('OKL_DOCUMENT_ID','NULL');
266: wf_core.RAISE('WFSQL_ARGS');
267: END IF;

Line 300: wf_engine.SetItemAttrText(itemtype,itemkey,l_attr_name,l_error_msg);

296: ELSE
297: l_error_msg := l_error_msg || l_new_line || l_msg_text;
298: END IF;
299: END LOOP;
300: wf_engine.SetItemAttrText(itemtype,itemkey,l_attr_name,l_error_msg);
301: resultout := wf_engine.eng_completed||':'|| 'F';
302: ELSE
303: resultout := wf_engine.eng_completed||':'|| 'T';
304: END IF;

Line 301: resultout := wf_engine.eng_completed||':'|| 'F';

297: l_error_msg := l_error_msg || l_new_line || l_msg_text;
298: END IF;
299: END LOOP;
300: wf_engine.SetItemAttrText(itemtype,itemkey,l_attr_name,l_error_msg);
301: resultout := wf_engine.eng_completed||':'|| 'F';
302: ELSE
303: resultout := wf_engine.eng_completed||':'|| 'T';
304: END IF;
305:

Line 303: resultout := wf_engine.eng_completed||':'|| 'T';

299: END LOOP;
300: wf_engine.SetItemAttrText(itemtype,itemkey,l_attr_name,l_error_msg);
301: resultout := wf_engine.eng_completed||':'|| 'F';
302: ELSE
303: resultout := wf_engine.eng_completed||':'|| 'T';
304: END IF;
305:
306: EXCEPTION
307: WHEN OTHERS THEN