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,
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:
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:
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:
130: l_gl_date);
131:
132: -- batch_date
133:
134: wf_engine.setitemattrdate(itemtype,
135: itemkey,
136: 'BATCH_DATE',
137: l_batch_date);
138:
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
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:
150: l_recipient_id);
151:
152: -- invoice_flag
153:
154: wf_engine.setitemattrtext(itemtype,
155: itemkey,
156: 'INVOICE_FLAG',
157: l_invoice_flag);
158:
157: l_invoice_flag);
158:
159: -- transaction amount
160:
161: wf_engine.setitemattrnumber(itemtype,
162: itemkey,
163: 'TRX_AMT',
164: l_trx_amt);
165:
165:
166:
167: -- Currency
168:
169: wf_engine.setitemattrtext(itemtype,
170: itemkey,
171: 'CURRENCY',
172: l_currency);
173:
172: l_currency);
173:
174: -- recipient name
175:
176: wf_engine.setitemattrtext(itemtype,
177: itemkey,
178: 'RECIPIENT_NAME',
179: l_recipient_name);
180:
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:
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
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:
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
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:
234: end if;
235:
236: -- set the status code
237:
238: wf_engine.setitemattrtext(itemtype,
239: itemkey,
240: 'STATUS',
241: l_status_code);
242:
239: itemkey,
240: 'STATUS',
241: l_status_code);
242:
243: wf_engine.setitemattrnumber(itemtype,
244: itemkey,
245: 'BATCH_ID',
246: l_batch_id);
247:
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:
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:
317: BEGIN
318:
319: -- get the attribute values
320:
321: l_trx_id := wf_engine.GetItemAttrNumber( itemtype
322: , itemkey
323: , 'TRX_ID'
324: );
325:
322: , itemkey
323: , 'TRX_ID'
324: );
325:
326: l_batch_id := wf_engine.GetItemAttrNumber( itemtype
327: , itemkey
328: , 'BATCH_ID'
329: );
330:
327: , itemkey
328: , 'BATCH_ID'
329: );
330:
331: l_status := wf_engine.GetItemAttrText( itemtype
332: ,itemkey
333: , 'STATUS'
334: );
335:
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,
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),
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:
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:
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
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:
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:
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: */
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,
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
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:
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
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:
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: */
1318: RETURN;
1319: END IF;
1320: */
1321:
1322: resultout := wf_engine.eng_null;
1323: RETURN;
1324:
1325: EXCEPTION
1326: WHEN OTHERS THEN