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.M4U_XML_GENPROCESS_OUT dependencies on WF_ENGINE

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

100: cln_debug_pub.Add('---------------------------------------------',1);
101: END IF;
102:
103: -- if funcmode is not null then exit
104: IF (funcmode <> wf_engine.eng_run) THEN
105: resultout := wf_engine.eng_null;
106: IF (l_Debug_Level <= 2) THEN
107: cln_debug_pub.Add('M4U:====== Exiting create_collab_setattr - Normal : resultout - ' || resultout,2);
108: END IF;

Line 105: resultout := wf_engine.eng_null;

101: END IF;
102:
103: -- if funcmode is not null then exit
104: IF (funcmode <> wf_engine.eng_run) THEN
105: resultout := wf_engine.eng_null;
106: IF (l_Debug_Level <= 2) THEN
107: cln_debug_pub.Add('M4U:====== Exiting create_collab_setattr - Normal : resultout - ' || resultout,2);
108: END IF;
109: RETURN;

Line 112: l_event_key := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_EVENT_KEY',TRUE);

108: END IF;
109: RETURN;
110: END IF;
111:
112: l_event_key := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_EVENT_KEY',TRUE);
113: IF (l_Debug_Level <= 1) THEN
114: cln_debug_pub.Add('ECX Event Key ----'||l_event_key,1);
115: END IF;
116:

Line 117: l_ecx_parameter1 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_PARAMETER1',TRUE);

113: IF (l_Debug_Level <= 1) THEN
114: cln_debug_pub.Add('ECX Event Key ----'||l_event_key,1);
115: END IF;
116:
117: l_ecx_parameter1 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_PARAMETER1',TRUE);
118: IF (l_Debug_Level <= 1) THEN
119: cln_debug_pub.Add('ECX Parameter1 ----'||l_ecx_parameter1,1);
120: END IF;
121:

Line 122: l_ecx_parameter2 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_PARAMETER2',TRUE);

118: IF (l_Debug_Level <= 1) THEN
119: cln_debug_pub.Add('ECX Parameter1 ----'||l_ecx_parameter1,1);
120: END IF;
121:
122: l_ecx_parameter2 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_PARAMETER2',TRUE);
123: IF (l_Debug_Level <= 1) THEN
124: cln_debug_pub.Add('ECX Parameter2 ----'||l_ecx_parameter2,1);
125: END IF;
126:

Line 127: l_ecx_parameter3 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_PARAMETER3',TRUE);

123: IF (l_Debug_Level <= 1) THEN
124: cln_debug_pub.Add('ECX Parameter2 ----'||l_ecx_parameter2,1);
125: END IF;
126:
127: l_ecx_parameter3 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_PARAMETER3',TRUE);
128: IF (l_Debug_Level <= 1) THEN
129: cln_debug_pub.Add('ECX Parameter3 ----'||l_ecx_parameter3,1);
130: END IF;
131:

Line 132: l_ecx_parameter4 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_PARAMETER4',TRUE);

128: IF (l_Debug_Level <= 1) THEN
129: cln_debug_pub.Add('ECX Parameter3 ----'||l_ecx_parameter3,1);
130: END IF;
131:
132: l_ecx_parameter4 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_PARAMETER4',TRUE);
133: IF (l_Debug_Level <= 1) THEN
134: cln_debug_pub.Add('ECX Parameter4 ----'||l_ecx_parameter4,1);
135: END IF;
136:

Line 137: l_ecx_parameter5 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_PARAMETER5',TRUE);

133: IF (l_Debug_Level <= 1) THEN
134: cln_debug_pub.Add('ECX Parameter4 ----'||l_ecx_parameter4,1);
135: END IF;
136:
137: l_ecx_parameter5 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_PARAMETER5',TRUE);
138: IF (l_Debug_Level <= 1) THEN
139: cln_debug_pub.Add('ECX Parameter5 ----'||l_ecx_parameter5,1);
140: END IF;
141:

Line 142: l_xmlg_transaction_type := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_TRANSACTION_TYPE',TRUE);

138: IF (l_Debug_Level <= 1) THEN
139: cln_debug_pub.Add('ECX Parameter5 ----'||l_ecx_parameter5,1);
140: END IF;
141:
142: l_xmlg_transaction_type := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_TRANSACTION_TYPE',TRUE);
143: IF (l_Debug_Level <= 1) THEN
144: cln_debug_pub.Add('XMLG Ext Transaction Type ----'||l_xmlg_transaction_type, 1);
145: END IF;
146:

Line 147: l_xmlg_transaction_subtype := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_TRANSACTION_SUBTYPE',TRUE);

143: IF (l_Debug_Level <= 1) THEN
144: cln_debug_pub.Add('XMLG Ext Transaction Type ----'||l_xmlg_transaction_type, 1);
145: END IF;
146:
147: l_xmlg_transaction_subtype := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_TRANSACTION_SUBTYPE',TRUE);
148: IF (l_Debug_Level <= 1) THEN
149: cln_debug_pub.Add('XMLG Ext Transaction Sub Type ----'||l_xmlg_transaction_subtype, 1);
150: END IF;
151:

Line 152: l_coll_type := wf_engine.GetItemAttrText(itemtype, itemkey, 'M4U_CLN_COLL_TYPE',TRUE);

148: IF (l_Debug_Level <= 1) THEN
149: cln_debug_pub.Add('XMLG Ext Transaction Sub Type ----'||l_xmlg_transaction_subtype, 1);
150: END IF;
151:
152: l_coll_type := wf_engine.GetItemAttrText(itemtype, itemkey, 'M4U_CLN_COLL_TYPE',TRUE);
153: IF (l_Debug_Level <= 1) THEN
154: cln_debug_pub.Add('COLLABORATION TYPE ----'||l_coll_type,1);
155: END IF;
156:

Line 157: l_doc_type := wf_engine.GetItemAttrText(itemtype, itemkey, 'M4U_CLN_DOC_TYPE',TRUE);

153: IF (l_Debug_Level <= 1) THEN
154: cln_debug_pub.Add('COLLABORATION TYPE ----'||l_coll_type,1);
155: END IF;
156:
157: l_doc_type := wf_engine.GetItemAttrText(itemtype, itemkey, 'M4U_CLN_DOC_TYPE',TRUE);
158: IF (l_Debug_Level <= 1) THEN
159: cln_debug_pub.Add('DOCUMENT TYPE ----'||l_doc_type,1);
160: END IF;
161:

Line 162: l_doc_owner := wf_engine.GetItemAttrText(itemtype, itemkey, 'M4U_DOC_OWNER',TRUE);

158: IF (l_Debug_Level <= 1) THEN
159: cln_debug_pub.Add('DOCUMENT TYPE ----'||l_doc_type,1);
160: END IF;
161:
162: l_doc_owner := wf_engine.GetItemAttrText(itemtype, itemkey, 'M4U_DOC_OWNER',TRUE);
163: IF (l_Debug_Level <= 1) THEN
164: cln_debug_pub.Add('DOCUMENT OWNER ----'||l_doc_owner,1);
165: END IF;
166:

Line 167: l_doc_no := wf_engine.GetItemAttrText(itemtype, itemkey, 'M4U_DOC_NO',TRUE);

163: IF (l_Debug_Level <= 1) THEN
164: cln_debug_pub.Add('DOCUMENT OWNER ----'||l_doc_owner,1);
165: END IF;
166:
167: l_doc_no := wf_engine.GetItemAttrText(itemtype, itemkey, 'M4U_DOC_NO',TRUE);
168: IF (l_Debug_Level <= 1) THEN
169: cln_debug_pub.Add('DOCUMENT NUMBER ----'||l_doc_no,1);
170: END IF;
171:

Line 172: l_xmlg_document_id := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_DOCUMENT_ID',TRUE);

168: IF (l_Debug_Level <= 1) THEN
169: cln_debug_pub.Add('DOCUMENT NUMBER ----'||l_doc_no,1);
170: END IF;
171:
172: l_xmlg_document_id := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_DOCUMENT_ID',TRUE);
173: IF (l_Debug_Level <= 1) THEN
174: cln_debug_pub.Add('ECX DOCUMENT ID ----'||l_xmlg_document_id,1);
175: END IF;
176:

Line 177: l_partner_doc_no := wf_engine.GetItemAttrText(itemtype, itemkey, 'M4U_PARTNER_DOC_NO',TRUE);

173: IF (l_Debug_Level <= 1) THEN
174: cln_debug_pub.Add('ECX DOCUMENT ID ----'||l_xmlg_document_id,1);
175: END IF;
176:
177: l_partner_doc_no := wf_engine.GetItemAttrText(itemtype, itemkey, 'M4U_PARTNER_DOC_NO',TRUE);
178: IF (l_Debug_Level <= 1) THEN
179: cln_debug_pub.Add('PARTNER DOCUMENT NUMBER ----'||l_partner_doc_no,1);
180: END IF;
181:

Line 182: l_owner_role := wf_engine.GetItemAttrText(itemtype, itemkey, 'M4U_OWNER_ROLE',TRUE);

178: IF (l_Debug_Level <= 1) THEN
179: cln_debug_pub.Add('PARTNER DOCUMENT NUMBER ----'||l_partner_doc_no,1);
180: END IF;
181:
182: l_owner_role := wf_engine.GetItemAttrText(itemtype, itemkey, 'M4U_OWNER_ROLE',TRUE);
183: IF (l_Debug_Level <= 1) THEN
184: cln_debug_pub.Add('OWNER ROLE ----'||l_owner_role,1);
185: END IF;
186:

Line 187: l_create_msg_text := wf_engine.GetItemAttrText(itemtype, itemkey, 'MESSAGE_TEXT',TRUE);

183: IF (l_Debug_Level <= 1) THEN
184: cln_debug_pub.Add('OWNER ROLE ----'||l_owner_role,1);
185: END IF;
186:
187: l_create_msg_text := wf_engine.GetItemAttrText(itemtype, itemkey, 'MESSAGE_TEXT',TRUE);
188: IF (l_Debug_Level <= 1) THEN
189: cln_debug_pub.Add('Message Text ----'||l_create_msg_text, 1);
190: END IF;
191:

Line 192: l_attribute1 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ATTRIBUTE1',TRUE);

188: IF (l_Debug_Level <= 1) THEN
189: cln_debug_pub.Add('Message Text ----'||l_create_msg_text, 1);
190: END IF;
191:
192: l_attribute1 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ATTRIBUTE1',TRUE);
193: IF (l_Debug_Level <= 1) THEN
194: cln_debug_pub.Add('ATTRIBUTE1 ----'||l_attribute1, 1);
195: END IF;
196:

Line 197: l_attribute2 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ATTRIBUTE2',TRUE);

193: IF (l_Debug_Level <= 1) THEN
194: cln_debug_pub.Add('ATTRIBUTE1 ----'||l_attribute1, 1);
195: END IF;
196:
197: l_attribute2 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ATTRIBUTE2',TRUE);
198: IF (l_Debug_Level <= 1) THEN
199: cln_debug_pub.Add('ATTRIBUTE2 ----'||l_attribute2, 1);
200: END IF;
201:

Line 202: l_attribute3 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ATTRIBUTE3',TRUE);

198: IF (l_Debug_Level <= 1) THEN
199: cln_debug_pub.Add('ATTRIBUTE2 ----'||l_attribute2, 1);
200: END IF;
201:
202: l_attribute3 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ATTRIBUTE3',TRUE);
203: IF (l_Debug_Level <= 1) THEN
204: cln_debug_pub.Add('ATTRIBUTE3 ----'||l_attribute3, 1);
205: END IF;
206:

Line 207: l_attribute4 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ATTRIBUTE4',TRUE);

203: IF (l_Debug_Level <= 1) THEN
204: cln_debug_pub.Add('ATTRIBUTE3 ----'||l_attribute3, 1);
205: END IF;
206:
207: l_attribute4 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ATTRIBUTE4',TRUE);
208: IF (l_Debug_Level <= 1) THEN
209: cln_debug_pub.Add('ATTRIBUTE4 ----'||l_attribute4, 1);
210: END IF;
211:

Line 212: l_attribute5 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ATTRIBUTE5',TRUE);

208: IF (l_Debug_Level <= 1) THEN
209: cln_debug_pub.Add('ATTRIBUTE4 ----'||l_attribute4, 1);
210: END IF;
211:
212: l_attribute5 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ATTRIBUTE5',TRUE);
213: IF (l_Debug_Level <= 1) THEN
214: cln_debug_pub.Add('ATTRIBUTE5 ----'||l_attribute5, 1);
215: END IF;
216:

Line 217: l_attribute6 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ATTRIBUTE6',TRUE);

213: IF (l_Debug_Level <= 1) THEN
214: cln_debug_pub.Add('ATTRIBUTE5 ----'||l_attribute5, 1);
215: END IF;
216:
217: l_attribute6 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ATTRIBUTE6',TRUE);
218: IF (l_Debug_Level <= 1) THEN
219: cln_debug_pub.Add('ATTRIBUTE6 ----'||l_attribute6, 1);
220: END IF;
221:

Line 222: l_attribute7 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ATTRIBUTE7',TRUE);

218: IF (l_Debug_Level <= 1) THEN
219: cln_debug_pub.Add('ATTRIBUTE6 ----'||l_attribute6, 1);
220: END IF;
221:
222: l_attribute7 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ATTRIBUTE7',TRUE);
223: IF (l_Debug_Level <= 1) THEN
224: cln_debug_pub.Add('ATTRIBUTE7 ----'||l_attribute7, 1);
225: END IF;
226:

Line 227: l_attribute8 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ATTRIBUTE8',TRUE);

223: IF (l_Debug_Level <= 1) THEN
224: cln_debug_pub.Add('ATTRIBUTE7 ----'||l_attribute7, 1);
225: END IF;
226:
227: l_attribute8 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ATTRIBUTE8',TRUE);
228: IF (l_Debug_Level <= 1) THEN
229: cln_debug_pub.Add('ATTRIBUTE8 ----'||l_attribute8, 1);
230: END IF;
231:

Line 232: l_attribute9 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ATTRIBUTE9',TRUE);

228: IF (l_Debug_Level <= 1) THEN
229: cln_debug_pub.Add('ATTRIBUTE8 ----'||l_attribute8, 1);
230: END IF;
231:
232: l_attribute9 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ATTRIBUTE9',TRUE);
233: IF (l_Debug_Level <= 1) THEN
234: cln_debug_pub.Add('ATTRIBUTE9 ----'||l_attribute9, 1);
235: END IF;
236:

Line 237: l_attribute10 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ATTRIBUTE10',TRUE);

233: IF (l_Debug_Level <= 1) THEN
234: cln_debug_pub.Add('ATTRIBUTE9 ----'||l_attribute9, 1);
235: END IF;
236:
237: l_attribute10 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ATTRIBUTE10',TRUE);
238: IF (l_Debug_Level <= 1) THEN
239: cln_debug_pub.Add('ATTRIBUTE10 ----'||l_attribute10, 1);
240: END IF;
241:

Line 242: l_attribute11 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ATTRIBUTE11',TRUE);

238: IF (l_Debug_Level <= 1) THEN
239: cln_debug_pub.Add('ATTRIBUTE10 ----'||l_attribute10, 1);
240: END IF;
241:
242: l_attribute11 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ATTRIBUTE11',TRUE);
243: IF (l_Debug_Level <= 1) THEN
244: cln_debug_pub.Add('ATTRIBUTE11 ----'||l_attribute11, 1);
245: END IF;
246:

Line 247: l_attribute12 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ATTRIBUTE12',TRUE);

243: IF (l_Debug_Level <= 1) THEN
244: cln_debug_pub.Add('ATTRIBUTE11 ----'||l_attribute11, 1);
245: END IF;
246:
247: l_attribute12 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ATTRIBUTE12',TRUE);
248: IF (l_Debug_Level <= 1) THEN
249: cln_debug_pub.Add('ATTRIBUTE12 ----'||l_attribute12, 1);
250: END IF;
251:

Line 252: l_attribute13 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ATTRIBUTE13',TRUE);

248: IF (l_Debug_Level <= 1) THEN
249: cln_debug_pub.Add('ATTRIBUTE12 ----'||l_attribute12, 1);
250: END IF;
251:
252: l_attribute13 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ATTRIBUTE13',TRUE);
253: IF (l_Debug_Level <= 1) THEN
254: cln_debug_pub.Add('ATTRIBUTE13 ----'||l_attribute13, 1);
255: END IF;
256:

Line 257: l_attribute14 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ATTRIBUTE14',TRUE);

253: IF (l_Debug_Level <= 1) THEN
254: cln_debug_pub.Add('ATTRIBUTE13 ----'||l_attribute13, 1);
255: END IF;
256:
257: l_attribute14 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ATTRIBUTE14',TRUE);
258: IF (l_Debug_Level <= 1) THEN
259: cln_debug_pub.Add('ATTRIBUTE14 ----'||l_attribute14, 1);
260: END IF;
261:

Line 262: l_attribute15 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ATTRIBUTE15',TRUE);

258: IF (l_Debug_Level <= 1) THEN
259: cln_debug_pub.Add('ATTRIBUTE14 ----'||l_attribute14, 1);
260: END IF;
261:
262: l_attribute15 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ATTRIBUTE15',TRUE);
263: IF (l_Debug_Level <= 1) THEN
264: cln_debug_pub.Add('ATTRIBUTE15 ----'||l_attribute15, 1);
265: END IF;
266:

Line 267: l_dattribute1 := m4u_ucc_utils.CONVERT_TO_DATE(wf_engine.GetItemAttrText(itemtype, itemkey, 'DATTRIBUTE1',TRUE));

263: IF (l_Debug_Level <= 1) THEN
264: cln_debug_pub.Add('ATTRIBUTE15 ----'||l_attribute15, 1);
265: END IF;
266:
267: l_dattribute1 := m4u_ucc_utils.CONVERT_TO_DATE(wf_engine.GetItemAttrText(itemtype, itemkey, 'DATTRIBUTE1',TRUE));
268: IF (l_Debug_Level <= 1) THEN
269: cln_debug_pub.Add('DATTRIBUTE1 ----'||l_dattribute1, 1);
270: END IF;
271:

Line 272: l_dattribute2 := m4u_ucc_utils.CONVERT_TO_DATE(wf_engine.GetItemAttrText(itemtype, itemkey, 'DATTRIBUTE2',TRUE));

268: IF (l_Debug_Level <= 1) THEN
269: cln_debug_pub.Add('DATTRIBUTE1 ----'||l_dattribute1, 1);
270: END IF;
271:
272: l_dattribute2 := m4u_ucc_utils.CONVERT_TO_DATE(wf_engine.GetItemAttrText(itemtype, itemkey, 'DATTRIBUTE2',TRUE));
273: IF (l_Debug_Level <= 1) THEN
274: cln_debug_pub.Add('DATTRIBUTE2 ----'||l_dattribute2, 1);
275: END IF;
276:

Line 277: l_dattribute3 := m4u_ucc_utils.CONVERT_TO_DATE(wf_engine.GetItemAttrText(itemtype, itemkey, 'DATTRIBUTE3',TRUE));

273: IF (l_Debug_Level <= 1) THEN
274: cln_debug_pub.Add('DATTRIBUTE2 ----'||l_dattribute2, 1);
275: END IF;
276:
277: l_dattribute3 := m4u_ucc_utils.CONVERT_TO_DATE(wf_engine.GetItemAttrText(itemtype, itemkey, 'DATTRIBUTE3',TRUE));
278: IF (l_Debug_Level <= 1) THEN
279: cln_debug_pub.Add('DATTRIBUTE3 ----'||l_dattribute3, 1);
280: END IF;
281:

Line 282: l_dattribute4 := m4u_ucc_utils.CONVERT_TO_DATE(wf_engine.GetItemAttrText(itemtype, itemkey, 'DATTRIBUTE4',TRUE));

278: IF (l_Debug_Level <= 1) THEN
279: cln_debug_pub.Add('DATTRIBUTE3 ----'||l_dattribute3, 1);
280: END IF;
281:
282: l_dattribute4 := m4u_ucc_utils.CONVERT_TO_DATE(wf_engine.GetItemAttrText(itemtype, itemkey, 'DATTRIBUTE4',TRUE));
283: IF (l_Debug_Level <= 1) THEN
284: cln_debug_pub.Add('DATTRIBUTE4 ----'||l_dattribute4, 1);
285: END IF;
286:

Line 287: l_dattribute5 := m4u_ucc_utils.CONVERT_TO_DATE(wf_engine.GetItemAttrText(itemtype, itemkey, 'DATTRIBUTE5',TRUE));

283: IF (l_Debug_Level <= 1) THEN
284: cln_debug_pub.Add('DATTRIBUTE4 ----'||l_dattribute4, 1);
285: END IF;
286:
287: l_dattribute5 := m4u_ucc_utils.CONVERT_TO_DATE(wf_engine.GetItemAttrText(itemtype, itemkey, 'DATTRIBUTE5',TRUE));
288: IF (l_Debug_Level <= 1) THEN
289: cln_debug_pub.Add('DATTRIBUTE5 ----'||l_dattribute5, 1);
290: END IF;
291:

Line 303: wf_engine.setItemAttrtext(

299: IF (l_Debug_Level <= 1) THEN
300: cln_debug_pub.Add('----- Set WF Item Attributes ----- ',1);
301: END IF;
302:
303: wf_engine.setItemAttrtext(
304: itemtype => itemtype,
305: itemkey => itemkey,
306: aname => 'ECX_PARTY_SITE_ID',
307: avalue => m4u_ucc_utils.g_party_site_id);

Line 313: wf_engine.setItemAttrtext(

309: IF (l_Debug_Level <= 1) THEN
310: cln_debug_pub.Add(' Item Attribute - ECX_PARTY_SITE_ID set',1);
311: END IF;
312:
313: wf_engine.setItemAttrtext(
314: itemtype => itemtype,
315: itemkey => itemkey,
316: aname => 'ECX_PARTY_ID',
317: avalue => m4u_ucc_utils.g_party_id);

Line 323: wf_engine.setItemAttrtext(

319: IF (l_Debug_Level <= 1) THEN
320: cln_debug_pub.Add(' Item Attribute - ECX_PARTY_ID set',1);
321: END IF;
322:
323: wf_engine.setItemAttrtext(
324: itemtype => itemtype,
325: itemkey => itemkey,
326: aname => 'ECX_PARTY_TYPE',
327: avalue => m4u_ucc_utils.c_party_type);

Line 333: wf_engine.setItemAttrtext(

329: IF (l_Debug_Level <= 1) THEN
330: cln_debug_pub.Add(' Item Attribute - ECX_PARTY_TYPE set',1);
331: END IF;
332:
333: wf_engine.setItemAttrtext(
334: itemtype => itemtype,
335: itemkey => itemkey,
336: aname => 'M4U_XML_VALIDATION_REQUIRED',
337: avalue => fnd_profile.value('M4U_XML_VALIDATION_REQUIRED'));

Line 409: resultout := wf_engine.eng_completed || ':SUCCESS';

405: END IF;
406:
407:
408: IF l_return_status = 'S' THEN
409: resultout := wf_engine.eng_completed || ':SUCCESS';
410: l_truncated_key := SUBSTR(l_event_key,1,10);
411:
412: IF (l_Debug_Level <= 1) THEN
413: cln_debug_pub.add('Truncated Key Value - '||l_truncated_key,1);

Line 435: resultout := wf_engine.eng_completed || ':FAIL';

431: cln_debug_pub.Add(' l_msg_count - '|| l_msg_count, 1);
432: END IF;
433: END IF;
434: ELSE
435: resultout := wf_engine.eng_completed || ':FAIL';
436:
437: FND_MESSAGE.SET_NAME('CLN','M4U_CREATE_COLL_FAILURE');
438: /* 'Create Collaboration Failed. Details are
439: Colllaboration type : COLLTYPE

Line 452: wf_engine.setItemAttrtext(

448: CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR(l_fnd_msg );
449: RETURN;
450: END IF;
451:
452: wf_engine.setItemAttrtext(
453: itemtype => itemtype,
454: itemkey => itemkey,
455: aname => 'ECX_PARAMETER1',
456: avalue => l_coll_id);

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

605: cln_debug_pub.Add('---------------------------------------------',1);
606: END IF;
607:
608: -- if funcmode is not null then exit
609: IF (funcmode <> wf_engine.eng_run) THEN
610: resultout := wf_engine.eng_null;
611: IF (l_Debug_Level <= 2) THEN
612: cln_debug_pub.Add('M4U:====== Exiting update_collab_setattr - Normal : resultout - ' || resultout,2);
613: END IF;

Line 610: resultout := wf_engine.eng_null;

606: END IF;
607:
608: -- if funcmode is not null then exit
609: IF (funcmode <> wf_engine.eng_run) THEN
610: resultout := wf_engine.eng_null;
611: IF (l_Debug_Level <= 2) THEN
612: cln_debug_pub.Add('M4U:====== Exiting update_collab_setattr - Normal : resultout - ' || resultout,2);
613: END IF;
614: RETURN;

Line 617: l_event_key := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_EVENT_KEY',TRUE);

613: END IF;
614: RETURN;
615: END IF;
616:
617: l_event_key := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_EVENT_KEY',TRUE);
618: IF (l_Debug_Level <= 1) THEN
619: cln_debug_pub.Add('Ecx Event Key ----'||l_event_key,1);
620: END IF;
621:

Line 623: l_ecx_parameter1 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_PARAMETER1',TRUE);

619: cln_debug_pub.Add('Ecx Event Key ----'||l_event_key,1);
620: END IF;
621:
622: -- ECX Parameter1 contains the collaboration ID
623: l_ecx_parameter1 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_PARAMETER1',TRUE);
624: IF (l_Debug_Level <= 1) THEN
625: cln_debug_pub.Add('ECX Parameter1 ----'||l_ecx_parameter1,1);
626: END IF;
627:

Line 628: l_ecx_parameter2 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_PARAMETER2',TRUE);

624: IF (l_Debug_Level <= 1) THEN
625: cln_debug_pub.Add('ECX Parameter1 ----'||l_ecx_parameter1,1);
626: END IF;
627:
628: l_ecx_parameter2 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_PARAMETER2',TRUE);
629: IF (l_Debug_Level <= 1) THEN
630: cln_debug_pub.Add('ECX Parameter2 ----'||l_ecx_parameter2,1);
631: END IF;
632:

Line 633: l_ecx_parameter3 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_PARAMETER3',TRUE);

629: IF (l_Debug_Level <= 1) THEN
630: cln_debug_pub.Add('ECX Parameter2 ----'||l_ecx_parameter2,1);
631: END IF;
632:
633: l_ecx_parameter3 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_PARAMETER3',TRUE);
634: IF (l_Debug_Level <= 1) THEN
635: cln_debug_pub.Add('ECX Parameter3 ----'||l_ecx_parameter3,1);
636: END IF;
637:

Line 638: l_ecx_parameter4 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_PARAMETER4',TRUE);

634: IF (l_Debug_Level <= 1) THEN
635: cln_debug_pub.Add('ECX Parameter3 ----'||l_ecx_parameter3,1);
636: END IF;
637:
638: l_ecx_parameter4 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_PARAMETER4',TRUE);
639: IF (l_Debug_Level <= 1) THEN
640: cln_debug_pub.Add('ECX Parameter4 ----'||l_ecx_parameter4,1);
641: END IF;
642:

Line 643: l_ecx_parameter5 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_PARAMETER5',TRUE);

639: IF (l_Debug_Level <= 1) THEN
640: cln_debug_pub.Add('ECX Parameter4 ----'||l_ecx_parameter4,1);
641: END IF;
642:
643: l_ecx_parameter5 := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_PARAMETER5',TRUE);
644: IF (l_Debug_Level <= 1) THEN
645: cln_debug_pub.Add('ECX Parameter5 ----'||l_ecx_parameter5,1);
646: END IF;
647:

Line 648: l_coll_type := wf_engine.GetItemAttrText(itemtype, itemkey, 'M4U_CLN_COLL_TYPE',TRUE);

644: IF (l_Debug_Level <= 1) THEN
645: cln_debug_pub.Add('ECX Parameter5 ----'||l_ecx_parameter5,1);
646: END IF;
647:
648: l_coll_type := wf_engine.GetItemAttrText(itemtype, itemkey, 'M4U_CLN_COLL_TYPE',TRUE);
649: IF (l_Debug_Level <= 1) THEN
650: cln_debug_pub.Add('COLLABORATION TYPE ----'||l_coll_type,1);
651: END IF;
652:

Line 653: l_doc_type := wf_engine.GetItemAttrText(itemtype, itemkey, 'M4U_CLN_DOC_TYPE',TRUE);

649: IF (l_Debug_Level <= 1) THEN
650: cln_debug_pub.Add('COLLABORATION TYPE ----'||l_coll_type,1);
651: END IF;
652:
653: l_doc_type := wf_engine.GetItemAttrText(itemtype, itemkey, 'M4U_CLN_DOC_TYPE',TRUE);
654: IF (l_Debug_Level <= 1) THEN
655: cln_debug_pub.Add('DOCUMENT TYPE ----'||l_doc_type,1);
656: END IF;
657:

Line 658: l_xmlg_transaction_type := wf_engine.GetItemAttrText(itemtype, itemkey,'ECX_TRANSACTION_TYPE',TRUE);

654: IF (l_Debug_Level <= 1) THEN
655: cln_debug_pub.Add('DOCUMENT TYPE ----'||l_doc_type,1);
656: END IF;
657:
658: l_xmlg_transaction_type := wf_engine.GetItemAttrText(itemtype, itemkey,'ECX_TRANSACTION_TYPE',TRUE);
659: IF (l_Debug_Level <= 1) THEN
660: cln_debug_pub.Add('ECX Transaction Type ----'||l_xmlg_transaction_type, 1);
661: END IF;
662:

Line 663: l_xmlg_transaction_subtype := wf_engine.GetItemAttrText(itemtype, itemkey,'ECX_TRANSACTION_SUBTYPE',TRUE);

659: IF (l_Debug_Level <= 1) THEN
660: cln_debug_pub.Add('ECX Transaction Type ----'||l_xmlg_transaction_type, 1);
661: END IF;
662:
663: l_xmlg_transaction_subtype := wf_engine.GetItemAttrText(itemtype, itemkey,'ECX_TRANSACTION_SUBTYPE',TRUE);
664: IF (l_Debug_Level <= 1) THEN
665: cln_debug_pub.Add('ECX Transaction Sub Type ----'||l_xmlg_transaction_subtype, 1);
666: END IF;
667:

Line 668: l_msg_text := wf_engine.GetItemAttrText(itemtype, itemkey,'MESSAGE_TEXT',TRUE);

664: IF (l_Debug_Level <= 1) THEN
665: cln_debug_pub.Add('ECX Transaction Sub Type ----'||l_xmlg_transaction_subtype, 1);
666: END IF;
667:
668: l_msg_text := wf_engine.GetItemAttrText(itemtype, itemkey,'MESSAGE_TEXT',TRUE);
669: IF (l_Debug_Level <= 1) THEN
670: cln_debug_pub.Add('Message Text ----'||l_msg_text, 1);
671: END IF;
672:

Line 673: l_attribute1 := wf_engine.GetItemAttrText(itemtype, itemkey,'ATTRIBUTE1',TRUE);

669: IF (l_Debug_Level <= 1) THEN
670: cln_debug_pub.Add('Message Text ----'||l_msg_text, 1);
671: END IF;
672:
673: l_attribute1 := wf_engine.GetItemAttrText(itemtype, itemkey,'ATTRIBUTE1',TRUE);
674: IF (l_Debug_Level <= 1) THEN
675: cln_debug_pub.Add('ATTRIBUTE1 ----'||l_attribute1, 1);
676: END IF;
677:

Line 678: l_attribute2 := wf_engine.GetItemAttrText(itemtype, itemkey,'ATTRIBUTE2',TRUE);

674: IF (l_Debug_Level <= 1) THEN
675: cln_debug_pub.Add('ATTRIBUTE1 ----'||l_attribute1, 1);
676: END IF;
677:
678: l_attribute2 := wf_engine.GetItemAttrText(itemtype, itemkey,'ATTRIBUTE2',TRUE);
679: IF (l_Debug_Level <= 1) THEN
680: cln_debug_pub.Add('ATTRIBUTE2 ----'||l_attribute2, 1);
681: END IF;
682:

Line 683: l_attribute3 := wf_engine.GetItemAttrText(itemtype, itemkey,'ATTRIBUTE3',TRUE);

679: IF (l_Debug_Level <= 1) THEN
680: cln_debug_pub.Add('ATTRIBUTE2 ----'||l_attribute2, 1);
681: END IF;
682:
683: l_attribute3 := wf_engine.GetItemAttrText(itemtype, itemkey,'ATTRIBUTE3',TRUE);
684: IF (l_Debug_Level <= 1) THEN
685: cln_debug_pub.Add('ATTRIBUTE3 ----'||l_attribute3, 1);
686: END IF;
687:

Line 688: l_attribute4 := wf_engine.GetItemAttrText(itemtype, itemkey,'ATTRIBUTE4',TRUE);

684: IF (l_Debug_Level <= 1) THEN
685: cln_debug_pub.Add('ATTRIBUTE3 ----'||l_attribute3, 1);
686: END IF;
687:
688: l_attribute4 := wf_engine.GetItemAttrText(itemtype, itemkey,'ATTRIBUTE4',TRUE);
689: IF (l_Debug_Level <= 1) THEN
690: cln_debug_pub.Add('ATTRIBUTE4 ----'||l_attribute4, 1);
691: END IF;
692:

Line 693: l_attribute5 := wf_engine.GetItemAttrText(itemtype, itemkey,'ATTRIBUTE5',TRUE);

689: IF (l_Debug_Level <= 1) THEN
690: cln_debug_pub.Add('ATTRIBUTE4 ----'||l_attribute4, 1);
691: END IF;
692:
693: l_attribute5 := wf_engine.GetItemAttrText(itemtype, itemkey,'ATTRIBUTE5',TRUE);
694: IF (l_Debug_Level <= 1) THEN
695: cln_debug_pub.Add('ATTRIBUTE5 ----'||l_attribute5, 1);
696: END IF;
697:

Line 698: l_attribute6 := wf_engine.GetItemAttrText(itemtype, itemkey,'ATTRIBUTE6',TRUE);

694: IF (l_Debug_Level <= 1) THEN
695: cln_debug_pub.Add('ATTRIBUTE5 ----'||l_attribute5, 1);
696: END IF;
697:
698: l_attribute6 := wf_engine.GetItemAttrText(itemtype, itemkey,'ATTRIBUTE6',TRUE);
699: IF (l_Debug_Level <= 1) THEN
700: cln_debug_pub.Add('ATTRIBUTE6 ----'||l_attribute6, 1);
701: END IF;
702:

Line 703: l_attribute7 := wf_engine.GetItemAttrText(itemtype, itemkey,'ATTRIBUTE7',TRUE);

699: IF (l_Debug_Level <= 1) THEN
700: cln_debug_pub.Add('ATTRIBUTE6 ----'||l_attribute6, 1);
701: END IF;
702:
703: l_attribute7 := wf_engine.GetItemAttrText(itemtype, itemkey,'ATTRIBUTE7',TRUE);
704: IF (l_Debug_Level <= 1) THEN
705: cln_debug_pub.Add('ATTRIBUTE7 ----'||l_attribute7, 1);
706: END IF;
707:

Line 708: l_attribute8 := wf_engine.GetItemAttrText(itemtype, itemkey,'ATTRIBUTE8',TRUE);

704: IF (l_Debug_Level <= 1) THEN
705: cln_debug_pub.Add('ATTRIBUTE7 ----'||l_attribute7, 1);
706: END IF;
707:
708: l_attribute8 := wf_engine.GetItemAttrText(itemtype, itemkey,'ATTRIBUTE8',TRUE);
709: IF (l_Debug_Level <= 1) THEN
710: cln_debug_pub.Add('ATTRIBUTE8 ----'||l_attribute8, 1);
711: END IF;
712:

Line 713: l_attribute9 := wf_engine.GetItemAttrText(itemtype, itemkey,'ATTRIBUTE9',TRUE);

709: IF (l_Debug_Level <= 1) THEN
710: cln_debug_pub.Add('ATTRIBUTE8 ----'||l_attribute8, 1);
711: END IF;
712:
713: l_attribute9 := wf_engine.GetItemAttrText(itemtype, itemkey,'ATTRIBUTE9',TRUE);
714: IF (l_Debug_Level <= 1) THEN
715: cln_debug_pub.Add('ATTRIBUTE9 ----'||l_attribute9, 1);
716: END IF;
717:

Line 718: l_attribute10 := wf_engine.GetItemAttrText(itemtype, itemkey,'ATTRIBUTE10',TRUE);

714: IF (l_Debug_Level <= 1) THEN
715: cln_debug_pub.Add('ATTRIBUTE9 ----'||l_attribute9, 1);
716: END IF;
717:
718: l_attribute10 := wf_engine.GetItemAttrText(itemtype, itemkey,'ATTRIBUTE10',TRUE);
719: IF (l_Debug_Level <= 1) THEN
720: cln_debug_pub.Add('ATTRIBUTE10 ----'||l_attribute10, 1);
721: END IF;
722:

Line 723: l_attribute11 := wf_engine.GetItemAttrText(itemtype, itemkey,'ATTRIBUTE11',TRUE);

719: IF (l_Debug_Level <= 1) THEN
720: cln_debug_pub.Add('ATTRIBUTE10 ----'||l_attribute10, 1);
721: END IF;
722:
723: l_attribute11 := wf_engine.GetItemAttrText(itemtype, itemkey,'ATTRIBUTE11',TRUE);
724: IF (l_Debug_Level <= 1) THEN
725: cln_debug_pub.Add('ATTRIBUTE11 ----'||l_attribute11, 1);
726: END IF;
727:

Line 728: l_attribute12 := wf_engine.GetItemAttrText(itemtype, itemkey,'ATTRIBUTE12',TRUE);

724: IF (l_Debug_Level <= 1) THEN
725: cln_debug_pub.Add('ATTRIBUTE11 ----'||l_attribute11, 1);
726: END IF;
727:
728: l_attribute12 := wf_engine.GetItemAttrText(itemtype, itemkey,'ATTRIBUTE12',TRUE);
729: IF (l_Debug_Level <= 1) THEN
730: cln_debug_pub.Add('ATTRIBUTE12 ----'||l_attribute12, 1);
731: END IF;
732:

Line 733: l_attribute13 := wf_engine.GetItemAttrText(itemtype, itemkey,'ATTRIBUTE13',TRUE);

729: IF (l_Debug_Level <= 1) THEN
730: cln_debug_pub.Add('ATTRIBUTE12 ----'||l_attribute12, 1);
731: END IF;
732:
733: l_attribute13 := wf_engine.GetItemAttrText(itemtype, itemkey,'ATTRIBUTE13',TRUE);
734: IF (l_Debug_Level <= 1) THEN
735: cln_debug_pub.Add('ATTRIBUTE13 ----'||l_attribute13, 1);
736: END IF;
737:

Line 738: l_attribute14 := wf_engine.GetItemAttrText(itemtype, itemkey,'ATTRIBUTE14',TRUE);

734: IF (l_Debug_Level <= 1) THEN
735: cln_debug_pub.Add('ATTRIBUTE13 ----'||l_attribute13, 1);
736: END IF;
737:
738: l_attribute14 := wf_engine.GetItemAttrText(itemtype, itemkey,'ATTRIBUTE14',TRUE);
739: IF (l_Debug_Level <= 1) THEN
740: cln_debug_pub.Add('ATTRIBUTE14 ----'||l_attribute14, 1);
741: END IF;
742:

Line 743: l_attribute15 := wf_engine.GetItemAttrText(itemtype, itemkey,'ATTRIBUTE15',TRUE);

739: IF (l_Debug_Level <= 1) THEN
740: cln_debug_pub.Add('ATTRIBUTE14 ----'||l_attribute14, 1);
741: END IF;
742:
743: l_attribute15 := wf_engine.GetItemAttrText(itemtype, itemkey,'ATTRIBUTE15',TRUE);
744: IF (l_Debug_Level <= 1) THEN
745: cln_debug_pub.Add('ATTRIBUTE15 ----'||l_attribute15, 1);
746: END IF;
747:

Line 748: l_dattribute1 := m4u_ucc_utils.CONVERT_TO_DATE(wf_engine.GetItemAttrText(itemtype, itemkey,'DATTRIBUTE1',TRUE));

744: IF (l_Debug_Level <= 1) THEN
745: cln_debug_pub.Add('ATTRIBUTE15 ----'||l_attribute15, 1);
746: END IF;
747:
748: l_dattribute1 := m4u_ucc_utils.CONVERT_TO_DATE(wf_engine.GetItemAttrText(itemtype, itemkey,'DATTRIBUTE1',TRUE));
749: IF (l_Debug_Level <= 1) THEN
750: cln_debug_pub.Add('DATTRIBUTE1 ----'||l_dattribute1, 1);
751: END IF;
752:

Line 753: l_dattribute2 := m4u_ucc_utils.CONVERT_TO_DATE(wf_engine.GetItemAttrText(itemtype, itemkey,'DATTRIBUTE2',TRUE));

749: IF (l_Debug_Level <= 1) THEN
750: cln_debug_pub.Add('DATTRIBUTE1 ----'||l_dattribute1, 1);
751: END IF;
752:
753: l_dattribute2 := m4u_ucc_utils.CONVERT_TO_DATE(wf_engine.GetItemAttrText(itemtype, itemkey,'DATTRIBUTE2',TRUE));
754: IF (l_Debug_Level <= 1) THEN
755: cln_debug_pub.Add('DATTRIBUTE2 ----'||l_dattribute2, 1);
756: END IF;
757:

Line 758: l_dattribute3 := m4u_ucc_utils.CONVERT_TO_DATE(wf_engine.GetItemAttrText(itemtype, itemkey,'DATTRIBUTE3',TRUE));

754: IF (l_Debug_Level <= 1) THEN
755: cln_debug_pub.Add('DATTRIBUTE2 ----'||l_dattribute2, 1);
756: END IF;
757:
758: l_dattribute3 := m4u_ucc_utils.CONVERT_TO_DATE(wf_engine.GetItemAttrText(itemtype, itemkey,'DATTRIBUTE3',TRUE));
759: IF (l_Debug_Level <= 1) THEN
760: cln_debug_pub.Add('DATTRIBUTE3 ----'||l_dattribute3, 1);
761: END IF;
762:

Line 763: l_dattribute4 := m4u_ucc_utils.CONVERT_TO_DATE(wf_engine.GetItemAttrText(itemtype, itemkey,'DATTRIBUTE4',TRUE));

759: IF (l_Debug_Level <= 1) THEN
760: cln_debug_pub.Add('DATTRIBUTE3 ----'||l_dattribute3, 1);
761: END IF;
762:
763: l_dattribute4 := m4u_ucc_utils.CONVERT_TO_DATE(wf_engine.GetItemAttrText(itemtype, itemkey,'DATTRIBUTE4',TRUE));
764: IF (l_Debug_Level <= 1) THEN
765: cln_debug_pub.Add('DATTRIBUTE4 ----'||l_dattribute4, 1);
766: END IF;
767:

Line 768: l_dattribute5 := m4u_ucc_utils.CONVERT_TO_DATE(wf_engine.GetItemAttrText(itemtype, itemkey,'DATTRIBUTE5',TRUE));

764: IF (l_Debug_Level <= 1) THEN
765: cln_debug_pub.Add('DATTRIBUTE4 ----'||l_dattribute4, 1);
766: END IF;
767:
768: l_dattribute5 := m4u_ucc_utils.CONVERT_TO_DATE(wf_engine.GetItemAttrText(itemtype, itemkey,'DATTRIBUTE5',TRUE));
769: IF (l_Debug_Level <= 1) THEN
770: cln_debug_pub.Add('DATTRIBUTE5 ----'||l_dattribute5, 1);
771: END IF;
772:

Line 773: l_xmlg_message_id := wf_engine.GetItemAttrText(itemtype, itemkey,'ECX_MSGID_ATTR',TRUE);

769: IF (l_Debug_Level <= 1) THEN
770: cln_debug_pub.Add('DATTRIBUTE5 ----'||l_dattribute5, 1);
771: END IF;
772:
773: l_xmlg_message_id := wf_engine.GetItemAttrText(itemtype, itemkey,'ECX_MSGID_ATTR',TRUE);
774: IF (l_debug_Level <= 1) THEN
775: cln_debug_pub.Add('XMLG Message ID ----' || l_xmlg_message_id,1);
776: END IF;
777:

Line 778: l_xmlg_document_id := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_DOCUMENT_ID',TRUE);

774: IF (l_debug_Level <= 1) THEN
775: cln_debug_pub.Add('XMLG Message ID ----' || l_xmlg_message_id,1);
776: END IF;
777:
778: l_xmlg_document_id := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_DOCUMENT_ID',TRUE);
779: IF (l_debug_Level <= 1) THEN
780: cln_debug_pub.Add('XMLG Document ID ----' || l_xmlg_document_id,1);
781: END IF;
782:

Line 784: l_wf_error_msg := wf_engine.GetItemAttrText(itemtype, itemkey, 'M4U_ERROR_MSG',TRUE );

780: cln_debug_pub.Add('XMLG Document ID ----' || l_xmlg_document_id,1);
781: END IF;
782:
783: -- This attribute when filled is used for add messages screen
784: l_wf_error_msg := wf_engine.GetItemAttrText(itemtype, itemkey, 'M4U_ERROR_MSG',TRUE );
785: IF (l_debug_Level <= 1) THEN
786: cln_debug_pub.Add('WF Error Msg ----' || l_wf_error_msg,1);
787: END IF;
788:

Line 791: l_fnd_msg_key := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,'M4U_FND_MSG',TRUE);

787: END IF;
788:
789: -- This attribute is used for puttg up prefix to generic msgs that can be used
790: -- in the collaboration event details screen
791: l_fnd_msg_key := wf_engine.GetActivityAttrText(itemtype, itemkey, actid,'M4U_FND_MSG',TRUE);
792: IF (l_debug_Level <= 1) THEN
793: cln_debug_pub.Add('Message Prefix ----' || l_fnd_msg_key,1);
794: END IF;
795:

Line 799: l_wf_error_type := wf_engine.GetActivityAttrText(itemtype, itemkey,actid, 'M4U_ERROR_TYPE',TRUE);

795:
796: -- check if error type is set at Activity level
797: -- else check at item level, doing this because some of the WF activities involving the
798: -- java files do not set item_attribute M4U_ERROR_TYPE. This is specific to different Updates
799: l_wf_error_type := wf_engine.GetActivityAttrText(itemtype, itemkey,actid, 'M4U_ERROR_TYPE',TRUE);
800: if(l_wf_error_type IS NULL) THEN
801: l_wf_error_type := wf_engine.GetItemAttrText(itemtype, itemkey, 'M4U_ERROR_TYPE',TRUE);
802: END IF;
803:

Line 801: l_wf_error_type := wf_engine.GetItemAttrText(itemtype, itemkey, 'M4U_ERROR_TYPE',TRUE);

797: -- else check at item level, doing this because some of the WF activities involving the
798: -- java files do not set item_attribute M4U_ERROR_TYPE. This is specific to different Updates
799: l_wf_error_type := wf_engine.GetActivityAttrText(itemtype, itemkey,actid, 'M4U_ERROR_TYPE',TRUE);
800: if(l_wf_error_type IS NULL) THEN
801: l_wf_error_type := wf_engine.GetItemAttrText(itemtype, itemkey, 'M4U_ERROR_TYPE',TRUE);
802: END IF;
803:
804: IF (l_debug_Level <= 1) THEN
805: cln_debug_pub.Add('l_wf_error_type ----' || l_wf_error_type,1);

Line 824: wf_engine.setItemAttrtext(

820: l_fnd_msg_key := l_fnd_msg_key || '_FAILURE';
821: l_coll_status := 'ERROR';
822: l_doc_status := 'ERROR';
823:
824: wf_engine.setItemAttrtext(
825: itemtype => itemtype,
826: itemkey => itemkey,
827: aname => 'M4U_ERROR_FLAG',
828: avalue => 'Y');

Line 872: resultout := wf_engine.eng_completed || ':FAIL';

868: END IF;
869:
870:
871: IF l_return_status <> 'S' THEN
872: resultout := wf_engine.eng_completed || ':FAIL';
873:
874: FND_MESSAGE.SET_NAME('CLN','M4U_UPDATE_COLL_FAILURE');
875: /* 'Update Collaboration Failed. Details are
876: Collaboration type : COLLTYPE

Line 893: wf_engine.setItemAttrtext(

889: FND_MESSAGE.SET_TOKEN('FAILURE_REASON',l_msg_data);
890:
891: l_fnd_msg := FND_MESSAGE.GET;
892:
893: wf_engine.setItemAttrtext(
894: itemtype => itemtype,
895: itemkey => itemkey,
896: aname => 'M4U_ERROR_FLAG',
897: avalue => 'Y');

Line 997: wf_engine.setItemAttrtext(

993:
994:
995: l_fnd_msg := FND_MESSAGE.GET;
996:
997: wf_engine.setItemAttrtext(
998: itemtype => itemtype,
999: itemkey => itemkey,
1000: aname => 'M4U_ERROR_FLAG',
1001: avalue => 'Y');

Line 1015: wf_engine.setItemAttrtext(

1011: END IF;
1012: END IF;
1013:
1014: -- this nullfies the value stored in the message for update collaboration
1015: wf_engine.setItemAttrtext(
1016: itemtype => itemtype,
1017: itemkey => itemkey,
1018: aname => 'M4U_ERROR_TYPE',
1019: avalue => NULL);

Line 1026: wf_engine.setItemAttrtext(

1022: cln_debug_pub.Add('M4U_ERROR_TYPE set to NULL',1);
1023: END IF;
1024:
1025: -- this nullfies the value stored in the message for add messages table
1026: wf_engine.setItemAttrtext(
1027: itemtype => itemtype,
1028: itemkey => itemkey,
1029: aname => 'M4U_ERROR_MSG',
1030: avalue => NULL);

Line 1036: resultout := wf_engine.eng_completed;

1032: IF (l_debug_Level <= 1) THEN
1033: cln_debug_pub.Add('M4U_ERROR_MSG set to NULL',1);
1034: END IF;
1035:
1036: resultout := wf_engine.eng_completed;
1037:
1038: IF (l_Debug_Level <= 2) THEN
1039: cln_debug_pub.Add('====== Exiting m4u_xml_genprocess_out.update_collab_setattr - Normal : resultout-' || resultout,2);
1040: END IF;

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

1167: cln_debug_pub.Add('---------------------------------------------',1);
1168: END IF;
1169:
1170: -- if funcmode is not null then exit
1171: IF (funcmode <> wf_engine.eng_run) THEN
1172: resultout := wf_engine.eng_null;
1173: IF (l_Debug_Level <= 2) THEN
1174: cln_debug_pub.Add('M4U:====== Exiting create_batchcollab_setattr - Normal : resultout - ' || resultout,2);
1175: END IF;

Line 1172: resultout := wf_engine.eng_null;

1168: END IF;
1169:
1170: -- if funcmode is not null then exit
1171: IF (funcmode <> wf_engine.eng_run) THEN
1172: resultout := wf_engine.eng_null;
1173: IF (l_Debug_Level <= 2) THEN
1174: cln_debug_pub.Add('M4U:====== Exiting create_batchcollab_setattr - Normal : resultout - ' || resultout,2);
1175: END IF;
1176: RETURN;

Line 1180: l_xmlg_transaction_type := wf_engine.GetItemAttrText(itemtype, itemkey,'ECX_TRANSACTION_TYPE',TRUE);

1176: RETURN;
1177: END IF;
1178:
1179: -- Pramaters obtained with the event from EGO
1180: l_xmlg_transaction_type := wf_engine.GetItemAttrText(itemtype, itemkey,'ECX_TRANSACTION_TYPE',TRUE);
1181: IF (l_Debug_Level <= 1) THEN
1182: cln_debug_pub.Add('ECX Transaction Type ----'||l_xmlg_transaction_type, 1);
1183: END IF;
1184:

Line 1185: l_xmlg_transaction_subtype := wf_engine.GetItemAttrText(itemtype, itemkey,'ECX_TRANSACTION_SUBTYPE',TRUE);

1181: IF (l_Debug_Level <= 1) THEN
1182: cln_debug_pub.Add('ECX Transaction Type ----'||l_xmlg_transaction_type, 1);
1183: END IF;
1184:
1185: l_xmlg_transaction_subtype := wf_engine.GetItemAttrText(itemtype, itemkey,'ECX_TRANSACTION_SUBTYPE',TRUE);
1186: IF (l_Debug_Level <= 1) THEN
1187: cln_debug_pub.Add('ECX Transaction Sub Type ----'||l_xmlg_transaction_subtype, 1);
1188: END IF;
1189:

Line 1190: l_ego_batch_id := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_PARAMETER2',TRUE);

1186: IF (l_Debug_Level <= 1) THEN
1187: cln_debug_pub.Add('ECX Transaction Sub Type ----'||l_xmlg_transaction_subtype, 1);
1188: END IF;
1189:
1190: l_ego_batch_id := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_PARAMETER2',TRUE);
1191: IF (l_Debug_Level <= 1) THEN
1192: cln_debug_pub.Add('EGO batch id ----'|| l_ego_batch_id , 1);
1193: END IF;
1194:

Line 1195: l_ego_subbatch_id := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_PARAMETER1',TRUE);

1191: IF (l_Debug_Level <= 1) THEN
1192: cln_debug_pub.Add('EGO batch id ----'|| l_ego_batch_id , 1);
1193: END IF;
1194:
1195: l_ego_subbatch_id := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_PARAMETER1',TRUE);
1196: IF (l_Debug_Level <= 1) THEN
1197: cln_debug_pub.Add('EGO subbatch id ----'|| l_ego_subbatch_id , 1);
1198: END IF;
1199:

Line 1200: l_event_type := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_PARAMETER3',TRUE);

1196: IF (l_Debug_Level <= 1) THEN
1197: cln_debug_pub.Add('EGO subbatch id ----'|| l_ego_subbatch_id , 1);
1198: END IF;
1199:
1200: l_event_type := wf_engine.GetItemAttrText(itemtype, itemkey, 'ECX_PARAMETER3',TRUE);
1201: IF (l_Debug_Level <= 1) THEN
1202: cln_debug_pub.Add('Event Type ----'|| l_event_type , 1);
1203: END IF;
1204:

Line 1205: l_coll_type := wf_engine.GetItemAttrText(itemtype, itemkey, 'M4U_CLN_COLL_TYPE',TRUE);

1201: IF (l_Debug_Level <= 1) THEN
1202: cln_debug_pub.Add('Event Type ----'|| l_event_type , 1);
1203: END IF;
1204:
1205: l_coll_type := wf_engine.GetItemAttrText(itemtype, itemkey, 'M4U_CLN_COLL_TYPE',TRUE);
1206: IF (l_Debug_Level <= 1) THEN
1207: cln_debug_pub.Add('Collaboration Type ----'|| l_coll_type , 1);
1208: END IF;
1209:

Line 1210: l_doc_type := wf_engine.GetItemAttrText(itemtype, itemkey, 'M4U_CLN_DOC_TYPE',TRUE);

1206: IF (l_Debug_Level <= 1) THEN
1207: cln_debug_pub.Add('Collaboration Type ----'|| l_coll_type , 1);
1208: END IF;
1209:
1210: l_doc_type := wf_engine.GetItemAttrText(itemtype, itemkey, 'M4U_CLN_DOC_TYPE',TRUE);
1211: IF (l_Debug_Level <= 1) THEN
1212: cln_debug_pub.Add('DOCUMENT TYPE ----'||l_doc_type,1);
1213: END IF;
1214:

Line 1228: wf_engine.setItemAttrtext(

1224: IF (l_Debug_Level <= 1) THEN
1225: cln_debug_pub.Add('----- Set WF Item Attributes ----- ',1);
1226: END IF;
1227:
1228: wf_engine.setItemAttrtext(
1229: itemtype => itemtype,
1230: itemkey => itemkey,
1231: aname => 'ECX_PARTY_SITE_ID',
1232: avalue => m4u_ucc_utils.g_party_site_id);

Line 1238: wf_engine.setItemAttrtext(

1234: IF (l_Debug_Level <= 1) THEN
1235: cln_debug_pub.Add(' Item Attribute - ECX_PARTY_SITE_ID set',1);
1236: END IF;
1237:
1238: wf_engine.setItemAttrtext(
1239: itemtype => itemtype,
1240: itemkey => itemkey,
1241: aname => 'ECX_PARTY_ID',
1242: avalue => m4u_ucc_utils.g_party_id);

Line 1248: wf_engine.setItemAttrtext(

1244: IF (l_Debug_Level <= 1) THEN
1245: cln_debug_pub.Add(' Item Attribute - ECX_PARTY_ID set',1);
1246: END IF;
1247:
1248: wf_engine.setItemAttrtext(
1249: itemtype => itemtype,
1250: itemkey => itemkey,
1251: aname => 'ECX_PARTY_TYPE',
1252: avalue => m4u_ucc_utils.c_party_type);

Line 1258: wf_engine.setItemAttrtext(

1254: IF (l_Debug_Level <= 1) THEN
1255: cln_debug_pub.Add(' Item Attribute - ECX_PARTY_TYPE set',1);
1256: END IF;
1257:
1258: wf_engine.setItemAttrtext(
1259: itemtype => itemtype,
1260: itemkey => itemkey,
1261: aname => 'M4U_XML_VALIDATION_REQUIRED',
1262: avalue => fnd_profile.value('M4U_XML_VALIDATION_REQUIRED'));

Line 1305: wf_engine.setItemAttrtext(

1301: */
1302: -- here the doc type is hardcoded to M4U_RCIR which would need a change
1303: l_coll_type := 'M4U_RCIR'||'_'||l_event_action;
1304:
1305: wf_engine.setItemAttrtext(
1306: itemtype => itemtype,
1307: itemkey => itemkey,
1308: aname => 'M4U_CLN_COLL_TYPE',
1309: avalue => l_coll_type);

Line 1315: wf_engine.setItemAttrtext(

1311: IF (l_Debug_Level <= 1) THEN
1312: cln_debug_pub.Add('M4U_CLN_DOC_TYPE - ' || l_doc_type, 1);
1313: END IF;
1314:
1315: wf_engine.setItemAttrtext(
1316: itemtype => itemtype,
1317: itemkey => itemkey,
1318: aname => 'ECX_DOCUMENT_ID',
1319: avalue => l_xmlg_document_id);

Line 1394: resultout := wf_engine.eng_completed || ':FAIL';

1390: cln_debug_pub.Add(' x_msg_count - '|| x_msg_count, 1);
1391: END IF;
1392:
1393: ELSE
1394: resultout := wf_engine.eng_completed || ':FAIL';
1395:
1396: wf_engine.setItemAttrtext(
1397: itemtype => itemtype,
1398: itemkey => itemkey,

Line 1396: wf_engine.setItemAttrtext(

1392:
1393: ELSE
1394: resultout := wf_engine.eng_completed || ':FAIL';
1395:
1396: wf_engine.setItemAttrtext(
1397: itemtype => itemtype,
1398: itemkey => itemkey,
1399: aname => 'M4U_ERROR_FLAG',
1400: avalue => 'Y');

Line 1429: resultout := wf_engine.eng_completed||':SUCCESS';

1425: IF (l_debug_Level <= 2) THEN
1426: cln_debug_pub.Add('========= Exiting create_batchcollab_setattr == ',2);
1427: END IF;
1428:
1429: resultout := wf_engine.eng_completed||':SUCCESS';
1430:
1431: EXCEPTION
1432: WHEN OTHERS THEN
1433: l_error_code :=SQLCODE;

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

1536: END IF;
1537:
1538:
1539: -- if funcmode is not null then exit
1540: IF (funcmode <> wf_engine.eng_run) THEN
1541: resultout := wf_engine.eng_null;
1542: IF (l_Debug_Level <= 2) THEN
1543: cln_debug_pub.Add('====== Exiting m4u_xml_genprocess_out.update_cln_collaborations - Normal : resultout-' || resultout,2);
1544: END IF;

Line 1541: resultout := wf_engine.eng_null;

1537:
1538:
1539: -- if funcmode is not null then exit
1540: IF (funcmode <> wf_engine.eng_run) THEN
1541: resultout := wf_engine.eng_null;
1542: IF (l_Debug_Level <= 2) THEN
1543: cln_debug_pub.Add('====== Exiting m4u_xml_genprocess_out.update_cln_collaborations - Normal : resultout-' || resultout,2);
1544: END IF;
1545: RETURN;

Line 1548: l_ego_batch_id := wf_engine.GetItemAttrText(itemtype,itemkey,'ECX_PARAMETER2',TRUE);

1544: END IF;
1545: RETURN;
1546: END IF;
1547:
1548: l_ego_batch_id := wf_engine.GetItemAttrText(itemtype,itemkey,'ECX_PARAMETER2',TRUE);
1549:
1550: IF (l_Debug_Level <= 1) THEN
1551: cln_debug_pub.Add('WF Attributes retreived are', 1);
1552: cln_debug_pub.Add('l_ego_batch_id ----'|| l_ego_batch_id , 1);

Line 1556: l_ego_subbatch_id := wf_engine.GetItemAttrText(itemtype,itemkey,'ECX_PARAMETER4',TRUE);

1552: cln_debug_pub.Add('l_ego_batch_id ----'|| l_ego_batch_id , 1);
1553: END IF;
1554:
1555:
1556: l_ego_subbatch_id := wf_engine.GetItemAttrText(itemtype,itemkey,'ECX_PARAMETER4',TRUE);
1557:
1558: IF (l_Debug_Level <= 1) THEN
1559: cln_debug_pub.Add('l_ego_subbatch_id ----'|| l_ego_subbatch_id , 1);
1560: END IF;

Line 1562: l_xmlg_transaction_type := wf_engine.GetItemAttrText(itemtype,itemkey,'ECX_TRANSACTION_TYPE',TRUE);

1558: IF (l_Debug_Level <= 1) THEN
1559: cln_debug_pub.Add('l_ego_subbatch_id ----'|| l_ego_subbatch_id , 1);
1560: END IF;
1561:
1562: l_xmlg_transaction_type := wf_engine.GetItemAttrText(itemtype,itemkey,'ECX_TRANSACTION_TYPE',TRUE);
1563:
1564: IF (l_Debug_Level <= 1) THEN
1565: cln_debug_pub.Add('ECX l_xmlg_transaction_type ----'|| l_xmlg_transaction_type , 1);
1566: END IF;

Line 1568: l_xmlg_transaction_subtype := wf_engine.GetItemAttrText(itemtype,itemkey,'ECX_TRANSACTION_SUBTYPE',TRUE);

1564: IF (l_Debug_Level <= 1) THEN
1565: cln_debug_pub.Add('ECX l_xmlg_transaction_type ----'|| l_xmlg_transaction_type , 1);
1566: END IF;
1567:
1568: l_xmlg_transaction_subtype := wf_engine.GetItemAttrText(itemtype,itemkey,'ECX_TRANSACTION_SUBTYPE',TRUE);
1569:
1570: IF (l_Debug_Level <= 1) THEN
1571: cln_debug_pub.Add('ECX l_xmlg_transaction_subtype ----'|| l_xmlg_transaction_subtype , 1);
1572: END IF;

Line 1574: l_ecx_doc_id := wf_engine.GetItemAttrText(itemtype,itemkey,'ECX_DOCUMENT_ID', TRUE);

1570: IF (l_Debug_Level <= 1) THEN
1571: cln_debug_pub.Add('ECX l_xmlg_transaction_subtype ----'|| l_xmlg_transaction_subtype , 1);
1572: END IF;
1573:
1574: l_ecx_doc_id := wf_engine.GetItemAttrText(itemtype,itemkey,'ECX_DOCUMENT_ID', TRUE);
1575:
1576: IF (l_Debug_Level <= 1) THEN
1577: cln_debug_pub.Add('ECX l_ecx_doc_id ----'|| l_ecx_doc_id , 1);
1578: END IF;

Line 1580: l_ecx_msgid := wf_engine.GetItemAttrText(itemtype,itemkey,'ECX_MSGID_ATTR', TRUE);

1576: IF (l_Debug_Level <= 1) THEN
1577: cln_debug_pub.Add('ECX l_ecx_doc_id ----'|| l_ecx_doc_id , 1);
1578: END IF;
1579:
1580: l_ecx_msgid := wf_engine.GetItemAttrText(itemtype,itemkey,'ECX_MSGID_ATTR', TRUE);
1581:
1582: IF (l_Debug_Level <= 1) THEN
1583: cln_debug_pub.Add('ECX l_ecx_msgid ----'|| l_ecx_msgid, 1);
1584: END IF;

Line 1587: l_wf_error_msg := wf_engine.GetItemAttrText(itemtype,itemkey,'M4U_ERROR_MSG',TRUE);

1583: cln_debug_pub.Add('ECX l_ecx_msgid ----'|| l_ecx_msgid, 1);
1584: END IF;
1585:
1586: /* following values will be available only if there is schema validation or adapter issues */
1587: l_wf_error_msg := wf_engine.GetItemAttrText(itemtype,itemkey,'M4U_ERROR_MSG',TRUE);
1588:
1589: IF (l_Debug_Level <= 1) THEN
1590: cln_debug_pub.Add('l_wf_error_msg ----'|| l_wf_error_msg, 1);
1591: END IF;

Line 1593: l_wf_error_flag := wf_engine.GetItemAttrText(itemtype,itemkey,'M4U_ERROR_FLAG',TRUE);

1589: IF (l_Debug_Level <= 1) THEN
1590: cln_debug_pub.Add('l_wf_error_msg ----'|| l_wf_error_msg, 1);
1591: END IF;
1592:
1593: l_wf_error_flag := wf_engine.GetItemAttrText(itemtype,itemkey,'M4U_ERROR_FLAG',TRUE);
1594:
1595: IF (l_Debug_Level <= 1) THEN
1596: cln_debug_pub.Add('l_wf_error_flag ----'|| l_wf_error_flag, 1);
1597: END IF;

Line 1599: l_fnd_msg_key := wf_engine.GetActivityAttrText(itemtype, itemkey,actid,'M4U_FND_MSG',TRUE);

1595: IF (l_Debug_Level <= 1) THEN
1596: cln_debug_pub.Add('l_wf_error_flag ----'|| l_wf_error_flag, 1);
1597: END IF;
1598:
1599: l_fnd_msg_key := wf_engine.GetActivityAttrText(itemtype, itemkey,actid,'M4U_FND_MSG',TRUE);
1600:
1601: IF (l_Debug_Level <= 1) THEN
1602: cln_debug_pub.Add('l_fnd_msg_key ----'|| l_fnd_msg_key , 1);
1603: END IF;

Line 1605: l_cln_doc_type := wf_engine.GetItemAttrText(itemtype,itemkey,'M4U_CLN_DOC_TYPE',TRUE);

1601: IF (l_Debug_Level <= 1) THEN
1602: cln_debug_pub.Add('l_fnd_msg_key ----'|| l_fnd_msg_key , 1);
1603: END IF;
1604:
1605: l_cln_doc_type := wf_engine.GetItemAttrText(itemtype,itemkey,'M4U_CLN_DOC_TYPE',TRUE);
1606:
1607: IF (l_Debug_Level <= 1) THEN
1608: cln_debug_pub.Add('l_cln_doc_type ----'|| l_cln_doc_type , 1);
1609: END IF;

Line 1611: l_cln_coll_type := wf_engine.GetItemAttrText(itemtype,itemkey,'M4U_CLN_COLL_TYPE',TRUE);

1607: IF (l_Debug_Level <= 1) THEN
1608: cln_debug_pub.Add('l_cln_doc_type ----'|| l_cln_doc_type , 1);
1609: END IF;
1610:
1611: l_cln_coll_type := wf_engine.GetItemAttrText(itemtype,itemkey,'M4U_CLN_COLL_TYPE',TRUE);
1612:
1613: IF (l_Debug_Level <= 1) THEN
1614: cln_debug_pub.Add('l_cln_coll_type ----'|| l_cln_coll_type , 1);
1615: END IF;

Line 1621: l_wf_error_type := wf_engine.GetActivityAttrText(itemtype, itemkey,actid, 'M4U_ERROR_TYPE',TRUE);

1617: -- check if error type is set at Activity level
1618: -- else check at item level, doing this because some of the WF activities,
1619: -- do not set item_attribute M4U_ERROR_TYPE
1620: -- so setting Activity Attribute in the WF in those cases.
1621: l_wf_error_type := wf_engine.GetActivityAttrText(itemtype, itemkey,actid, 'M4U_ERROR_TYPE',TRUE);
1622:
1623: if(l_wf_error_type IS NULL) THEN
1624: l_wf_error_type := wf_engine.GetItemAttrText(itemtype, itemkey, 'M4U_ERROR_TYPE',TRUE);
1625: END IF;

Line 1624: l_wf_error_type := wf_engine.GetItemAttrText(itemtype, itemkey, 'M4U_ERROR_TYPE',TRUE);

1620: -- so setting Activity Attribute in the WF in those cases.
1621: l_wf_error_type := wf_engine.GetActivityAttrText(itemtype, itemkey,actid, 'M4U_ERROR_TYPE',TRUE);
1622:
1623: if(l_wf_error_type IS NULL) THEN
1624: l_wf_error_type := wf_engine.GetItemAttrText(itemtype, itemkey, 'M4U_ERROR_TYPE',TRUE);
1625: END IF;
1626:
1627: IF (l_Debug_Level <= 1) THEN
1628: cln_debug_pub.Add('l_wf_error_type ----'|| l_wf_error_type , 1);

Line 1644: wf_engine.setItemAttrtext(

1640: l_fnd_msg_key := l_fnd_msg_key || '_FAILURE';
1641: l_coll_status := 'ERROR';
1642: l_doc_status := 'ERROR';
1643:
1644: wf_engine.setItemAttrtext(
1645: itemtype => itemtype,
1646: itemkey => itemkey,
1647: aname => 'M4U_ERROR_FLAG',
1648: avalue => 'Y');

Line 1693: wf_engine.setItemAttrtext(

1689: IF x_return_status <> 'S' THEN
1690: FND_MESSAGE.SET_NAME('CLN','M4U_OUT_UPDATE_COLL_FAILURE');
1691: l_fnd_msg_key := FND_MESSAGE.GET;
1692:
1693: wf_engine.setItemAttrtext(
1694: itemtype => itemtype,
1695: itemkey => itemkey,
1696: aname => 'M4U_ERROR_FLAG',
1697: avalue => 'Y');

Line 1703: resultout := wf_engine.eng_completed || ':FAIL';

1699: IF (l_Debug_Level <= 1) THEN
1700: cln_debug_pub.Add('M4U_ERROR_FLAG set to Y', 1);
1701: END IF;
1702:
1703: resultout := wf_engine.eng_completed || ':FAIL';
1704: x_msg_data := 'Workflow - ' || itemtype || '/' || itemkey || ' - ' || x_msg_data;
1705:
1706: CLN_NP_PROCESSOR_PKG.NOTIFY_ADMINISTRATOR
1707: ( l_fnd_msg_key

Line 1778: wf_engine.setItemAttrtext(

1774:
1775: END IF;
1776: END LOOP;
1777:
1778: wf_engine.setItemAttrtext(
1779: itemtype => itemtype,
1780: itemkey => itemkey,
1781: aname => 'M4U_ERROR_TYPE',
1782: avalue => NULL);

Line 1788: wf_engine.setItemAttrtext(

1784: IF (l_Debug_Level <= 1) THEN
1785: cln_debug_pub.Add('M4U_ERROR_TYPE set to NULL', 1);
1786: END IF;
1787:
1788: wf_engine.setItemAttrtext(
1789: itemtype => itemtype,
1790: itemkey => itemkey,
1791: aname => 'M4U_ERROR_MSG',
1792: avalue => NULL);

Line 1798: resultout := wf_engine.eng_completed || ':SUCCESS';

1794: IF (l_Debug_Level <= 1) THEN
1795: cln_debug_pub.Add('M4U_ERROR_MSG set to NULL', 1);
1796: END IF;
1797:
1798: resultout := wf_engine.eng_completed || ':SUCCESS';
1799:
1800: IF (l_Debug_Level <= 1) THEN
1801: cln_debug_pub.Add('==========Exiting update_batchcollab_setattr ======', 2);
1802: END IF;

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

1881:
1882:
1883:
1884: -- if funcmode is not null then exit
1885: IF (funcmode <> wf_engine.eng_run) THEN
1886:
1887: IF (l_Debug_Level <= 1) THEN
1888: cln_debug_pub.Add('l_error_type - ' || l_error_type,1);
1889: END IF;

Line 1891: resultout := wf_engine.eng_null;

1887: IF (l_Debug_Level <= 1) THEN
1888: cln_debug_pub.Add('l_error_type - ' || l_error_type,1);
1889: END IF;
1890:
1891: resultout := wf_engine.eng_null;
1892: IF (l_Debug_Level <= 2) THEN
1893: cln_debug_pub.Add('====== Exiting m4u_xml_genprocess_out.set_aq_correlation - Normal : resultout-' || resultout,2);
1894: END IF;
1895: RETURN;

Line 1899: l_error_type := wf_engine.GetItemAttrText(itemtype, itemkey, 'M4U_ERROR_FLAG',TRUE);

1895: RETURN;
1896: END IF;
1897:
1898:
1899: l_error_type := wf_engine.GetItemAttrText(itemtype, itemkey, 'M4U_ERROR_FLAG',TRUE);
1900:
1901:
1902: IF (l_Debug_Level <= 1) THEN
1903: cln_debug_pub.Add('l_error_type - ' || l_error_type,1);

Line 1921: l_event := wf_engine.GetItemAttrEvent(itemtype, itemkey, 'ECX_EVENT_MESSAGE');

1917: cln_debug_pub.Add('l_correlation_id - ' || l_correlation_id,1);
1918: END IF;
1919:
1920: BEGIN
1921: l_event := wf_engine.GetItemAttrEvent(itemtype, itemkey, 'ECX_EVENT_MESSAGE');
1922: EXCEPTION
1923: WHEN others THEN
1924: NULL;
1925: END;

Line 1948: wf_engine.SetItemAttrEvent(itemtype, itemkey, 'ECX_EVENT_MESSAGE', l_event);

1944: END IF;
1945: END LOOP;
1946:
1947: l_event.setParameterList(l_param_list);
1948: wf_engine.SetItemAttrEvent(itemtype, itemkey, 'ECX_EVENT_MESSAGE', l_event);
1949:
1950: IF (l_Debug_Level <= 1) THEN
1951: cln_debug_pub.Add('ECX_EVENT_MESSAGE initialised',1);
1952: END IF;

Line 1954: wf_engine.SetItemAttrText(itemtype,itemkey, 'M4U_SEND_MODE',l_correlation_id);

1950: IF (l_Debug_Level <= 1) THEN
1951: cln_debug_pub.Add('ECX_EVENT_MESSAGE initialised',1);
1952: END IF;
1953:
1954: wf_engine.SetItemAttrText(itemtype,itemkey, 'M4U_SEND_MODE',l_correlation_id);
1955:
1956: IF (l_Debug_Level <= 1) THEN
1957: cln_debug_pub.Add('M4U_SEND_MODE - ' || l_correlation_id,1);
1958: END IF;

Line 1962: resultout := wf_engine.eng_completed;

1958: END IF;
1959:
1960:
1961: /* Y or N value if Y use the UCCnet adapter */
1962: resultout := wf_engine.eng_completed;
1963:
1964: IF (l_Debug_Level <= 2) THEN
1965: cln_debug_pub.Add('=========== Exiting m4u_xml_genprocess_out.set_aq_correlation =========== ',2);
1966: END IF;

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

2030: cln_debug_pub.Add('funcmode - ' || funcmode , 2);
2031: END IF;
2032:
2033: -- Do nothing in cancel or timeout mode
2034: IF (funcmode <> wf_engine.eng_run) THEN
2035: resultout := wf_engine.eng_null;
2036: IF (l_Debug_Level <= 2) THEN
2037: cln_debug_pub.Add('==========Exiting m4u_xml_genprocess_out.check_send_method ======', 2);
2038: END IF;

Line 2035: resultout := wf_engine.eng_null;

2031: END IF;
2032:
2033: -- Do nothing in cancel or timeout mode
2034: IF (funcmode <> wf_engine.eng_run) THEN
2035: resultout := wf_engine.eng_null;
2036: IF (l_Debug_Level <= 2) THEN
2037: cln_debug_pub.Add('==========Exiting m4u_xml_genprocess_out.check_send_method ======', 2);
2038: END IF;
2039: RETURN;

Line 2043: l_send_method := wf_engine.GetItemAttrText(itemtype, itemkey, 'M4U_SEND_MODE',TRUE);

2039: RETURN;
2040: END IF;
2041:
2042: /* Y or N depending on whether validation is required */
2043: l_send_method := wf_engine.GetItemAttrText(itemtype, itemkey, 'M4U_SEND_MODE',TRUE);
2044:
2045: IF (l_Debug_Level <= 1) THEN
2046: cln_debug_pub.Add('l_send_method - ' || l_send_method, 2);
2047: END IF;

Line 2049: resultout := wf_engine.eng_completed||':' || l_send_method;

2045: IF (l_Debug_Level <= 1) THEN
2046: cln_debug_pub.Add('l_send_method - ' || l_send_method, 2);
2047: END IF;
2048:
2049: resultout := wf_engine.eng_completed||':' || l_send_method;
2050: EXCEPTION
2051: WHEN OTHERS THEN
2052: l_error_code :=SQLCODE;
2053: l_error_msg :=' Workflow - ' || itemtype || '/' || itemkey || ' - ' || SQLERRM;

Line 2113: l_group_identifier := wf_engine.GetItemAttrText(

2109: l_ecxmsg := null;
2110: l_queue_name := 'ecx_outbound';
2111: l_wait_time := DBMS_AQ.NO_WAIT;
2112:
2113: l_group_identifier := wf_engine.GetItemAttrText(
2114: itemtype,
2115: itemkey,
2116: 'M4U_SEND_MODE',
2117: TRUE);

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

2127: cln_debug_pub.Add('actid - ' || actid , 2);
2128: cln_debug_pub.Add('funcmode - ' || funcmode , 2);
2129: END IF;
2130:
2131: IF (funcmode <> wf_engine.eng_run) THEN
2132: resultout := wf_engine.eng_null;
2133: IF (l_Debug_Level <= 2) THEN
2134: cln_debug_pub.Add('=========== Exiting m4u_xml_genprocess_out.dequeue_ucc_message =========== ',2);
2135: END IF;

Line 2132: resultout := wf_engine.eng_null;

2128: cln_debug_pub.Add('funcmode - ' || funcmode , 2);
2129: END IF;
2130:
2131: IF (funcmode <> wf_engine.eng_run) THEN
2132: resultout := wf_engine.eng_null;
2133: IF (l_Debug_Level <= 2) THEN
2134: cln_debug_pub.Add('=========== Exiting m4u_xml_genprocess_out.dequeue_ucc_message =========== ',2);
2135: END IF;
2136: RETURN;

Line 2140: l_event := wf_engine.GetItemAttrEvent(itemtype, itemkey, 'ECX_EVENT_MESSAGE');

2136: RETURN;
2137: END IF;
2138:
2139: BEGIN
2140: l_event := wf_engine.GetItemAttrEvent(itemtype, itemkey, 'ECX_EVENT_MESSAGE');
2141: EXCEPTION
2142: WHEN others THEN
2143: NULL;
2144: END;

Line 2177: resultout := wf_engine.eng_completed;

2173: IF (l_Debug_Level <= 2) THEN
2174: cln_debug_pub.Add('=========== Exiting m4u_xml_genprocess_out.dequeue_ucc_message normal =========== ',2);
2175: END IF;
2176:
2177: resultout := wf_engine.eng_completed;
2178:
2179: EXCEPTION
2180: WHEN OTHERS THEN
2181: l_error_code :=SQLCODE;

Line 2201: resultout := wf_engine.eng_completed;

2197: IF (l_Debug_Level <= 2) THEN
2198: cln_debug_pub.Add('=========== Exiting m4u_xml_genprocess_out.dequeue_ucc_message exception =========== ',2);
2199: END IF;
2200:
2201: resultout := wf_engine.eng_completed;
2202: Wf_Core.Context('m4u_xml_genprocess_out','dequeue_ucc_message ',
2203: itemtype, itemkey, to_char(actid), funcmode);
2204:
2205: END;

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

2253: cln_debug_pub.Add('---------------------------------------------',1);
2254: END IF;
2255:
2256: -- if funcmode is not null then exit
2257: IF (funcmode <> wf_engine.eng_run) THEN
2258: resultout := wf_engine.eng_null;
2259: IF (l_Debug_Level <= 2) THEN
2260: cln_debug_pub.Add('====== Exiting raise_payload_event - Normal : resultout-' || resultout,2);
2261: END IF;

Line 2258: resultout := wf_engine.eng_null;

2254: END IF;
2255:
2256: -- if funcmode is not null then exit
2257: IF (funcmode <> wf_engine.eng_run) THEN
2258: resultout := wf_engine.eng_null;
2259: IF (l_Debug_Level <= 2) THEN
2260: cln_debug_pub.Add('====== Exiting raise_payload_event - Normal : resultout-' || resultout,2);
2261: END IF;
2262: RETURN;

Line 2265: l_data_event := wf_engine.GetActivityAttrEvent(

2261: END IF;
2262: RETURN;
2263: END IF;
2264:
2265: l_data_event := wf_engine.GetActivityAttrEvent(
2266: itemtype => itemtype,
2267: itemkey => itemkey,
2268: actid => actid,
2269: name => 'EVENT_DATA');

Line 2274: l_raise_event_name := wf_engine.GetActivityAttrText(

2270: IF (l_Debug_Level <= 1) THEN
2271: cln_debug_pub.Add('EVENT_DATA obtained', 1);
2272: END IF;
2273:
2274: l_raise_event_name := wf_engine.GetActivityAttrText(
2275: itemtype => itemtype,
2276: itemkey => itemkey,
2277: actid => actid,
2278: aname => 'EVENT_NAME',

Line 2284: l_raise_event_key := wf_engine.GetActivityAttrText(

2280: IF (l_Debug_Level <= 1) THEN
2281: cln_debug_pub.Add('EVENT_NAME - ' || l_raise_event_name, 1);
2282: END IF;
2283:
2284: l_raise_event_key := wf_engine.GetActivityAttrText(
2285: itemtype => itemtype,
2286: itemkey => itemkey,
2287: actid => actid,
2288: aname => 'EVENT_KEY',

Line 2314: resultout := wf_engine.eng_completed || ':FAIL';

2310: END IF;
2311:
2312: IF l_clob_xml_payload IS NULL
2313: THEN
2314: resultout := wf_engine.eng_completed || ':FAIL';
2315:
2316: IF (l_debug_Level <= 2) THEN
2317: cln_debug_pub.Add('clob payload is null, exiting rasie_payload_event', 1);
2318: END IF;

Line 2320: wf_engine.setItemAttrtext(

2316: IF (l_debug_Level <= 2) THEN
2317: cln_debug_pub.Add('clob payload is null, exiting rasie_payload_event', 1);
2318: END IF;
2319:
2320: wf_engine.setItemAttrtext(
2321: itemtype => itemtype,
2322: itemkey => itemkey,
2323: aname => 'M4U_ERROR_FLAG',
2324: avalue => 'Y');

Line 2343: resultout := wf_engine.eng_completed || ':SUCCESS';

2339: p_event_key => l_raise_event_key,
2340: p_event_data => l_clob_xml_payload,
2341: p_parameters => l_event_params);
2342:
2343: resultout := wf_engine.eng_completed || ':SUCCESS';
2344:
2345: IF (l_Debug_Level <= 2) THEN
2346: cln_debug_pub.Add('====== exiting m4u_xml_genprocess_out.raise_payload_event - normal : resultout-' || resultout,2);
2347: END IF;