DBA Data[Home] [Help]

APPS.FUN_INITIATOR_WF_PKG dependencies on WF_ENGINE

Line 65: l_batch_id := wf_engine.getitemattrnumber(itemtype,

61:
62: -- Note the attributes BATCH_ID and TRX_ID are set
63: -- by the receiving event
64:
65: l_batch_id := wf_engine.getitemattrnumber(itemtype,
66: itemkey,
67: 'BATCH_ID');
68:
69: l_trx_id := wf_engine.getitemattrnumber(itemtype,

Line 69: l_trx_id := wf_engine.getitemattrnumber(itemtype,

65: l_batch_id := wf_engine.getitemattrnumber(itemtype,
66: itemkey,
67: 'BATCH_ID');
68:
69: l_trx_id := wf_engine.getitemattrnumber(itemtype,
70: itemkey,
71: 'TRX_ID');
72: l_user_env_lang := wf_engine.GetItemAttrText
73: (itemtype => itemtype,

Line 72: l_user_env_lang := wf_engine.GetItemAttrText

68:
69: l_trx_id := wf_engine.getitemattrnumber(itemtype,
70: itemkey,
71: 'TRX_ID');
72: l_user_env_lang := wf_engine.GetItemAttrText
73: (itemtype => itemtype,
74: itemkey => itemkey,
75: aname => 'USER_LANG');
76:

Line 144: wf_engine.setitemattrtext(itemtype,

140:
141: -- set the attribute
142:
143: -- batch number
144: wf_engine.setitemattrtext(itemtype,
145: itemkey,
146: 'BATCH_NUMBER',
147: l_batch_number);
148:

Line 150: wf_engine.setitemattrdate(itemtype,

146: 'BATCH_NUMBER',
147: l_batch_number);
148:
149: -- gl_date
150: wf_engine.setitemattrdate(itemtype,
151: itemkey,
152: 'GL_DATE',
153: l_gl_date);
154:

Line 157: wf_engine.setitemattrdate(itemtype,

153: l_gl_date);
154:
155: -- batch_date
156:
157: wf_engine.setitemattrdate(itemtype,
158: itemkey,
159: 'BATCH_DATE',
160: l_batch_date);
161:

Line 164: wf_engine.setitemattrnumber(itemtype,

160: l_batch_date);
161:
162: -- initiator_id
163:
164: wf_engine.setitemattrnumber(itemtype,
165: itemkey,
166: 'INITIATOR_ID',
167: l_initiator_id);
168: -- recipient_id

Line 170: wf_engine.setitemattrnumber(itemtype,

166: 'INITIATOR_ID',
167: l_initiator_id);
168: -- recipient_id
169:
170: wf_engine.setitemattrnumber(itemtype,
171: itemkey,
172: 'RECIPIENT_ID',
173: l_recipient_id);
174:

Line 177: wf_engine.setitemattrtext(itemtype,

173: l_recipient_id);
174:
175: -- invoice_flag
176:
177: wf_engine.setitemattrtext(itemtype,
178: itemkey,
179: 'INVOICE_FLAG',
180: l_invoice_flag);
181:

Line 184: wf_engine.setitemattrnumber(itemtype,

180: l_invoice_flag);
181:
182: -- transaction amount
183:
184: wf_engine.setitemattrnumber(itemtype,
185: itemkey,
186: 'TRX_AMT',
187: l_trx_amt);
188:

Line 192: wf_engine.setitemattrtext(itemtype,

188:
189:
190: -- Currency
191:
192: wf_engine.setitemattrtext(itemtype,
193: itemkey,
194: 'CURRENCY',
195: l_currency);
196:

Line 199: wf_engine.setitemattrtext(itemtype,

195: l_currency);
196:
197: -- recipient name
198:
199: wf_engine.setitemattrtext(itemtype,
200: itemkey,
201: 'RECIPIENT_NAME',
202: l_recipient_name);
203:

Line 205: wf_engine.SetItemAttrText(itemtype => itemtype,

201: 'RECIPIENT_NAME',
202: l_recipient_name);
203:
204: -- Added by JMARY for bug 11880642 (From Role)
205: wf_engine.SetItemAttrText(itemtype => itemtype,
206: itemkey => itemkey,
207: aname => '#FROM_ROLE',
208: avalue => l_initiator_person);
209:

Line 214: wf_engine.setitemattrtext(itemtype,

210:
211:
212: /* Start of changes for AME Uptake, 3671923. Bidisha S, 29 Jun 2004 */
213:
214: wf_engine.setitemattrtext(itemtype,
215: itemkey,
216: 'INITIATOR_NAME',
217: l_initiator_name);
218:

Line 219: wf_engine.setitemattrtext(itemtype,

215: itemkey,
216: 'INITIATOR_NAME',
217: l_initiator_name);
218:
219: wf_engine.setitemattrtext(itemtype,
220: itemkey,
221: 'TRX_NUMBER',
222: l_trx_number);
223: -- Contact information

Line 226: -- wf_engine.setitemattrtext(itemtype,

222: l_trx_number);
223: -- Contact information
224: --l_role_name :=FUN_WF_COMMON.get_contact_role(l_initiator_id);
225:
226: -- wf_engine.setitemattrtext(itemtype,
227: -- itemkey,
228: -- 'CONTACT',
229: -- l_role_name);
230:

Line 236: l_event_name := rtrim(ltrim(lower(wf_engine.getitemattrtext(itemtype,

232:
233:
234: -- Get the status code from the event name
235:
236: l_event_name := rtrim(ltrim(lower(wf_engine.getitemattrtext(itemtype,
237: itemkey,
238: 'EVENT_NAME')), ' '), ' ');
239:
240: -- Case check

Line 252: wf_engine.setitemattrtext(itemtype,

248: -- set the event key for the AR/GL transfer event
249: l_event_key :=FUN_INITIATOR_WF_PKG.generate_key(p_batch_id =>l_batch_id,
250: p_trx_id => l_trx_id);
251:
252: wf_engine.setitemattrtext(itemtype,
253: itemkey,
254: 'TRANSFER_KEY',
255: l_event_key);
256:

Line 267: wf_engine.setitemattrtext(itemtype,

263: end if;
264:
265: -- set the status code
266:
267: wf_engine.setitemattrtext(itemtype,
268: itemkey,
269: 'STATUS',
270: l_status_code);
271:

Line 272: wf_engine.setitemattrnumber(itemtype,

268: itemkey,
269: 'STATUS',
270: l_status_code);
271:
272: wf_engine.setitemattrnumber(itemtype,
273: itemkey,
274: 'BATCH_ID',
275: l_batch_id);
276:

Line 277: wf_engine.setitemattrnumber(itemtype,

273: itemkey,
274: 'BATCH_ID',
275: l_batch_id);
276:
277: wf_engine.setitemattrnumber(itemtype,
278: itemkey,
279: 'TRX_ID',
280: l_trx_id);
281:

Line 282: wf_engine.setitemattrnumber(itemtype,

278: itemkey,
279: 'TRX_ID',
280: l_trx_id);
281:
282: wf_engine.setitemattrnumber(itemtype,
283: itemkey,
284: 'PARTY_ID',
285: l_initiator_id);
286: wf_engine.setitemattrtext(itemtype,

Line 286: wf_engine.setitemattrtext(itemtype,

282: wf_engine.setitemattrnumber(itemtype,
283: itemkey,
284: 'PARTY_ID',
285: l_initiator_id);
286: wf_engine.setitemattrtext(itemtype,
287: itemkey,
288: 'USER_LANG',
289: l_user_env_lang);
290:

Line 354: l_trx_id := wf_engine.GetItemAttrNumber( itemtype

350: BEGIN
351:
352: -- get the attribute values
353:
354: l_trx_id := wf_engine.GetItemAttrNumber( itemtype
355: , itemkey
356: , 'TRX_ID'
357: );
358:

Line 359: l_batch_id := wf_engine.GetItemAttrNumber( itemtype

355: , itemkey
356: , 'TRX_ID'
357: );
358:
359: l_batch_id := wf_engine.GetItemAttrNumber( itemtype
360: , itemkey
361: , 'BATCH_ID'
362: );
363:

Line 364: l_status := wf_engine.GetItemAttrText( itemtype

360: , itemkey
361: , 'BATCH_ID'
362: );
363:
364: l_status := wf_engine.GetItemAttrText( itemtype
365: ,itemkey
366: , 'STATUS'
367: );
368:

Line 573: l_batch_id := wf_engine.getitemattrnumber(itemtype,

569: if(funcmode='RUN') then
570:
571: -- get the batch_id from the item attributes
572:
573: l_batch_id := wf_engine.getitemattrnumber(itemtype,
574: itemkey,
575: 'BATCH_ID');
576:
577: l_trx_id := wf_engine.getitemattrnumber(itemtype,

Line 577: l_trx_id := wf_engine.getitemattrnumber(itemtype,

573: l_batch_id := wf_engine.getitemattrnumber(itemtype,
574: itemkey,
575: 'BATCH_ID');
576:
577: l_trx_id := wf_engine.getitemattrnumber(itemtype,
578: itemkey,
579: 'TRX_ID');
580: WF_EVENT.AddParameterToList(p_name=>'BATCH_ID',
581: p_value=>to_char(l_batch_id),

Line 592: wf_engine.setitemattrtext(itemtype,

588: p_parameterlist =>l_parameter_list
589: );
590:
591:
592: wf_engine.setitemattrtext(itemtype,
593: itemkey,
594: 'ERROR_MSG',
595: 'Number of Lines' || l_count || 'Trx:' || l_trx_id || 'Test1');
596:

Line 621: wf_engine.setitemattrtext(itemtype,

617: exit when c_info%NOTFOUND;
618: END LOOP;
619: CLOSE c_info;
620:
621: wf_engine.setitemattrtext(itemtype,
622: itemkey,
623: 'ERROR_MSG',
624: 'Number of Lines' || l_count || 'init:' || l_initiator_id || 'Test2');
625:

Line 738: wf_engine.setitemattrtext(itemtype,

734: l_line.orig_system_bill_customer_id:=l_customer_id;
735: l_line.orig_system_bill_address_id :=l_address_id;
736:
737: -- insert the line into the AR interface table
738: wf_engine.setitemattrtext(itemtype,
739: itemkey,
740: 'ERROR_MSG',
741: 'SOURCE:' || l_line.batch_source_name
742: || 'LINE TYPE: ' || l_line.line_type

Line 865: wf_engine.setitemattrtext(itemtype,

861: '-3',
862: l_line.ORG_ID
863: );
864:
865: wf_engine.setitemattrtext(itemtype,
866: itemkey,
867: 'ERROR_MSG',
868: 'Number of Lines: After Insert' || l_count || 'ORG:' || l_line.org_id || 'Test2.75');
869:

Line 874: wf_engine.setitemattrtext(itemtype,

870: END LOOP;
871:
872: close c_line;
873:
874: wf_engine.setitemattrtext(itemtype,
875: itemkey,
876: 'ERROR_MSG',
877: 'Number of Lines' || l_count || 'Test3');
878:

Line 962: wf_engine.setitemattrtext(itemtype,

958:
959:
960: -- Do we need commit? No
961: /*
962: wf_engine.setitemattrtext(itemtype,
963: itemkey,
964: 'ERROR_MSG',
965: 'Number of Lines' || l_count || 'Trx:' || l_trx_id || 'Test');
966: */

Line 1049: l_trx_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1045:
1046:
1047: l_status:=FND_API.G_RET_STS_SUCCESS;
1048:
1049: l_trx_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1050: itemkey => itemkey,
1051: aname => 'TRX_ID');
1052:
1053: l_batch_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 1053: l_batch_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

1049: l_trx_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1050: itemkey => itemkey,
1051: aname => 'TRX_ID');
1052:
1053: l_batch_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
1054: itemkey => itemkey,
1055: aname => 'BATCH_ID');
1056:
1057: -- call transaction API to check the ar setup

Line 1087: wf_engine.setitemattrnumber( itemtype => itemtype,

1083:
1084: -- Bug: 7319371 END
1085:
1086:
1087: wf_engine.setitemattrnumber( itemtype => itemtype,
1088: itemkey => itemkey,
1089: aname => 'TRX_AMT',
1090: avalue => l_trx_amt);
1091:

Line 1101: wf_engine.setitemattrtext(itemtype,

1097: l_message :=FUN_WF_COMMON.concat_msg_stack(l_message_count);
1098:
1099: -- set the item attribute ERROR_MSG
1100:
1101: wf_engine.setitemattrtext(itemtype,
1102: itemkey,
1103: 'ERROR_MSG',
1104: l_message);
1105: -- return false

Line 1389: l_request_id := wf_engine.GetItemAttrNumber(

1385: /*
1386: IF (funcmode = 'RUN') THEN
1387: fnd_msg_pub.initialize;
1388:
1389: l_request_id := wf_engine.GetItemAttrNumber(
1390: itemtype => itemtype,
1391: itemkey => itemkey,
1392: aname => 'REQUEST_ID');
1393:

Line 1397: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;

1393:
1394: update_trx_headers(l_request_id);
1395:
1396: commit;
1397: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
1398:
1399: RETURN;
1400: END IF;
1401: */

Line 1403: resultout := wf_engine.eng_null;

1399: RETURN;
1400: END IF;
1401: */
1402:
1403: resultout := wf_engine.eng_null;
1404: RETURN;
1405:
1406: EXCEPTION
1407: WHEN OTHERS THEN