DBA Data[Home] [Help]

APPS.FUN_INITIATOR_WF_PKG dependencies on WF_ENGINE

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

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

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

63: l_batch_id := wf_engine.getitemattrnumber(itemtype,
64: itemkey,
65: 'BATCH_ID');
66:
67: l_trx_id := wf_engine.getitemattrnumber(itemtype,
68: itemkey,
69: 'TRX_ID');
70:
71:

Line 121: wf_engine.setitemattrtext(itemtype,

117: END;
118: -- set the attribute
119:
120: -- batch number
121: wf_engine.setitemattrtext(itemtype,
122: itemkey,
123: 'BATCH_NUMBER',
124: l_batch_number);
125:

Line 127: wf_engine.setitemattrdate(itemtype,

123: 'BATCH_NUMBER',
124: l_batch_number);
125:
126: -- gl_date
127: wf_engine.setitemattrdate(itemtype,
128: itemkey,
129: 'GL_DATE',
130: l_gl_date);
131:

Line 134: wf_engine.setitemattrdate(itemtype,

130: l_gl_date);
131:
132: -- batch_date
133:
134: wf_engine.setitemattrdate(itemtype,
135: itemkey,
136: 'BATCH_DATE',
137: l_batch_date);
138:

Line 141: wf_engine.setitemattrnumber(itemtype,

137: l_batch_date);
138:
139: -- initiator_id
140:
141: wf_engine.setitemattrnumber(itemtype,
142: itemkey,
143: 'INITIATOR_ID',
144: l_initiator_id);
145: -- recipient_id

Line 147: wf_engine.setitemattrnumber(itemtype,

143: 'INITIATOR_ID',
144: l_initiator_id);
145: -- recipient_id
146:
147: wf_engine.setitemattrnumber(itemtype,
148: itemkey,
149: 'RECIPIENT_ID',
150: l_recipient_id);
151:

Line 154: wf_engine.setitemattrtext(itemtype,

150: l_recipient_id);
151:
152: -- invoice_flag
153:
154: wf_engine.setitemattrtext(itemtype,
155: itemkey,
156: 'INVOICE_FLAG',
157: l_invoice_flag);
158:

Line 161: wf_engine.setitemattrnumber(itemtype,

157: l_invoice_flag);
158:
159: -- transaction amount
160:
161: wf_engine.setitemattrnumber(itemtype,
162: itemkey,
163: 'TRX_AMT',
164: l_trx_amt);
165:

Line 169: wf_engine.setitemattrtext(itemtype,

165:
166:
167: -- Currency
168:
169: wf_engine.setitemattrtext(itemtype,
170: itemkey,
171: 'CURRENCY',
172: l_currency);
173:

Line 176: wf_engine.setitemattrtext(itemtype,

172: l_currency);
173:
174: -- recipient name
175:
176: wf_engine.setitemattrtext(itemtype,
177: itemkey,
178: 'RECIPIENT_NAME',
179: l_recipient_name);
180:

Line 185: wf_engine.setitemattrtext(itemtype,

181:
182:
183: /* Start of changes for AME Uptake, 3671923. Bidisha S, 29 Jun 2004 */
184:
185: wf_engine.setitemattrtext(itemtype,
186: itemkey,
187: 'INITIATOR_NAME',
188: l_initiator_name);
189:

Line 190: wf_engine.setitemattrtext(itemtype,

186: itemkey,
187: 'INITIATOR_NAME',
188: l_initiator_name);
189:
190: wf_engine.setitemattrtext(itemtype,
191: itemkey,
192: 'TRX_NUMBER',
193: l_trx_number);
194: -- Contact information

Line 197: -- wf_engine.setitemattrtext(itemtype,

193: l_trx_number);
194: -- Contact information
195: --l_role_name :=FUN_WF_COMMON.get_contact_role(l_initiator_id);
196:
197: -- wf_engine.setitemattrtext(itemtype,
198: -- itemkey,
199: -- 'CONTACT',
200: -- l_role_name);
201:

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

203:
204:
205: -- Get the status code from the event name
206:
207: l_event_name := rtrim(ltrim(lower(wf_engine.getitemattrtext(itemtype,
208: itemkey,
209: 'EVENT_NAME')), ' '), ' ');
210:
211: -- Case check

Line 223: wf_engine.setitemattrtext(itemtype,

219: -- set the event key for the AR/GL transfer event
220: l_event_key :=FUN_INITIATOR_WF_PKG.generate_key(p_batch_id =>l_batch_id,
221: p_trx_id => l_trx_id);
222:
223: wf_engine.setitemattrtext(itemtype,
224: itemkey,
225: 'TRANSFER_KEY',
226: l_event_key);
227:

Line 238: wf_engine.setitemattrtext(itemtype,

234: end if;
235:
236: -- set the status code
237:
238: wf_engine.setitemattrtext(itemtype,
239: itemkey,
240: 'STATUS',
241: l_status_code);
242:

Line 243: wf_engine.setitemattrnumber(itemtype,

239: itemkey,
240: 'STATUS',
241: l_status_code);
242:
243: wf_engine.setitemattrnumber(itemtype,
244: itemkey,
245: 'BATCH_ID',
246: l_batch_id);
247:

Line 248: wf_engine.setitemattrnumber(itemtype,

244: itemkey,
245: 'BATCH_ID',
246: l_batch_id);
247:
248: wf_engine.setitemattrnumber(itemtype,
249: itemkey,
250: 'TRX_ID',
251: l_trx_id);
252:

Line 253: wf_engine.setitemattrnumber(itemtype,

249: itemkey,
250: 'TRX_ID',
251: l_trx_id);
252:
253: wf_engine.setitemattrnumber(itemtype,
254: itemkey,
255: 'PARTY_ID',
256: l_initiator_id);
257:

Line 321: l_trx_id := wf_engine.GetItemAttrNumber( itemtype

317: BEGIN
318:
319: -- get the attribute values
320:
321: l_trx_id := wf_engine.GetItemAttrNumber( itemtype
322: , itemkey
323: , 'TRX_ID'
324: );
325:

Line 326: l_batch_id := wf_engine.GetItemAttrNumber( itemtype

322: , itemkey
323: , 'TRX_ID'
324: );
325:
326: l_batch_id := wf_engine.GetItemAttrNumber( itemtype
327: , itemkey
328: , 'BATCH_ID'
329: );
330:

Line 331: l_status := wf_engine.GetItemAttrText( itemtype

327: , itemkey
328: , 'BATCH_ID'
329: );
330:
331: l_status := wf_engine.GetItemAttrText( itemtype
332: ,itemkey
333: , 'STATUS'
334: );
335:

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

520: if(funcmode='RUN') then
521:
522: -- get the batch_id from the item attributes
523:
524: l_batch_id := wf_engine.getitemattrnumber(itemtype,
525: itemkey,
526: 'BATCH_ID');
527:
528: l_trx_id := wf_engine.getitemattrnumber(itemtype,

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

524: l_batch_id := wf_engine.getitemattrnumber(itemtype,
525: itemkey,
526: 'BATCH_ID');
527:
528: l_trx_id := wf_engine.getitemattrnumber(itemtype,
529: itemkey,
530: 'TRX_ID');
531: WF_EVENT.AddParameterToList(p_name=>'BATCH_ID',
532: p_value=>to_char(l_batch_id),

Line 543: wf_engine.setitemattrtext(itemtype,

539: p_parameterlist =>l_parameter_list
540: );
541:
542:
543: wf_engine.setitemattrtext(itemtype,
544: itemkey,
545: 'ERROR_MSG',
546: 'Number of Lines' || l_count || 'Trx:' || l_trx_id || 'Test1');
547:

Line 572: wf_engine.setitemattrtext(itemtype,

568: exit when c_info%NOTFOUND;
569: END LOOP;
570: CLOSE c_info;
571:
572: wf_engine.setitemattrtext(itemtype,
573: itemkey,
574: 'ERROR_MSG',
575: 'Number of Lines' || l_count || 'init:' || l_initiator_id || 'Test2');
576:

Line 661: wf_engine.setitemattrtext(itemtype,

657: l_line.orig_system_bill_customer_id:=l_customer_id;
658: l_line.orig_system_bill_address_id :=l_address_id;
659:
660: -- insert the line into the AR interface table
661: wf_engine.setitemattrtext(itemtype,
662: itemkey,
663: 'ERROR_MSG',
664: 'SOURCE:' || l_line.batch_source_name
665: || 'LINE TYPE: ' || l_line.line_type

Line 788: wf_engine.setitemattrtext(itemtype,

784: '-3',
785: l_line.ORG_ID
786: );
787:
788: wf_engine.setitemattrtext(itemtype,
789: itemkey,
790: 'ERROR_MSG',
791: 'Number of Lines: After Insert' || l_count || 'ORG:' || l_line.org_id || 'Test2.75');
792:

Line 797: wf_engine.setitemattrtext(itemtype,

793: END LOOP;
794:
795: close c_line;
796:
797: wf_engine.setitemattrtext(itemtype,
798: itemkey,
799: 'ERROR_MSG',
800: 'Number of Lines' || l_count || 'Test3');
801:

Line 883: wf_engine.setitemattrtext(itemtype,

879:
880:
881: -- Do we need commit? No
882: /*
883: wf_engine.setitemattrtext(itemtype,
884: itemkey,
885: 'ERROR_MSG',
886: 'Number of Lines' || l_count || 'Trx:' || l_trx_id || 'Test');
887: */

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

966:
967:
968: l_status:=FND_API.G_RET_STS_SUCCESS;
969:
970: l_trx_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
971: itemkey => itemkey,
972: aname => 'TRX_ID');
973:
974: l_batch_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

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

970: l_trx_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
971: itemkey => itemkey,
972: aname => 'TRX_ID');
973:
974: l_batch_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,
975: itemkey => itemkey,
976: aname => 'BATCH_ID');
977:
978: -- call transaction API to check the ar setup

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

1004:
1005: -- Bug: 7319371 END
1006:
1007:
1008: wf_engine.setitemattrnumber( itemtype => itemtype,
1009: itemkey => itemkey,
1010: aname => 'TRX_AMT',
1011: avalue => l_trx_amt);
1012:

Line 1022: wf_engine.setitemattrtext(itemtype,

1018: l_message :=FUN_WF_COMMON.concat_msg_stack(l_message_count);
1019:
1020: -- set the item attribute ERROR_MSG
1021:
1022: wf_engine.setitemattrtext(itemtype,
1023: itemkey,
1024: 'ERROR_MSG',
1025: l_message);
1026: -- return false

Line 1308: l_request_id := wf_engine.GetItemAttrNumber(

1304: /*
1305: IF (funcmode = 'RUN') THEN
1306: fnd_msg_pub.initialize;
1307:
1308: l_request_id := wf_engine.GetItemAttrNumber(
1309: itemtype => itemtype,
1310: itemkey => itemkey,
1311: aname => 'REQUEST_ID');
1312:

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

1312:
1313: update_trx_headers(l_request_id);
1314:
1315: commit;
1316: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
1317:
1318: RETURN;
1319: END IF;
1320: */

Line 1322: resultout := wf_engine.eng_null;

1318: RETURN;
1319: END IF;
1320: */
1321:
1322: resultout := wf_engine.eng_null;
1323: RETURN;
1324:
1325: EXCEPTION
1326: WHEN OTHERS THEN