DBA Data[Home] [Help]

APPS.ARI_UTILITIES dependencies on WF_ENGINE

Line 159: WF_ENGINE.CREATEPROCESS('ARIPRNTF',

155: -----------------------------------------------------------------------------------------
156: IF (PG_DEBUG = 'Y') THEN
157: arp_standard.debug(l_debug_info);
158: END IF;
159: WF_ENGINE.CREATEPROCESS('ARIPRNTF',
160: p_request_id,
161: 'ARI_PRINT_NOTIFICATION_PROCESS');
162:
163: /*------------------------------------------------------------------+

Line 166: WF_ENGINE.SetItemAttrText('ARIPRNTF',

162:
163: /*------------------------------------------------------------------+
164: | Set the notification subject to the message fetched previously |
165: +------------------------------------------------------------------*/
166: WF_ENGINE.SetItemAttrText('ARIPRNTF',
167: p_request_id,
168: 'ARI_MSG_SUBJ',
169: l_subject);
170:

Line 174: /*WF_ENGINE.SetItemAttrText('ARIPRNTF',

170:
171: /*---------------------------------------------------------------+
172: | Set the notification body to the message fetched previously |
173: +---------------------------------------------------------------*/
174: /*WF_ENGINE.SetItemAttrText('ARIPRNTF',
175: p_request_id,
176: 'AR_MESSAGE_BODY',
177: l_body);*/
178:

Line 182: WF_ENGINE.SetItemAttrText('ARIPRNTF',

178:
179: /*-----------------------------------------------------------+
180: | Set the recipient to the user name passed in as parameter |
181: +-----------------------------------------------------------*/
182: WF_ENGINE.SetItemAttrText('ARIPRNTF',
183: p_request_id,
184: 'ARI_MSG_RECIPIENT',
185: p_user_name);
186:

Line 191: WF_ENGINE.SetItemAttrText('ARIPRNTF',

187: /*-----------------------------------------------------------+
188: | Set the sender to System Administrator's role |
189: | Check Workflow ER 3720065 |
190: +-----------------------------------------------------------*/
191: WF_ENGINE.SetItemAttrText('ARIPRNTF',
192: p_request_id,
193: '#FROM_ROLE',
194: 'SYSADMIN');
195:

Line 199: WF_ENGINE.SetItemAttrText('ARIPRNTF',

195:
196: /*-----------------------------------------------------------+
197: | Set the customer name attribute |
198: +-----------------------------------------------------------*/
199: WF_ENGINE.SetItemAttrText('ARIPRNTF',
200: p_request_id,
201: 'ARI_NOTIFICATION_CUSTOMER_NAME',
202: p_customer_name);
203:

Line 207: WF_ENGINE.SetItemAttrText('ARIPRNTF',

203:
204: /*-----------------------------------------------------------+
205: | Set the current concurrent request id |
206: +-----------------------------------------------------------*/
207: WF_ENGINE.SetItemAttrText('ARIPRNTF',
208: p_request_id,
209: 'ARI_NOTIFICATION_CONC_REQ_ID',
210: p_request_id);
211:

Line 215: WF_ENGINE.SetItemAttrText('ARIPRNTF',

211:
212: /*-----------------------------------------------------------+
213: | Set the number of requests |
214: +-----------------------------------------------------------*/
215: WF_ENGINE.SetItemAttrText('ARIPRNTF',
216: p_request_id,
217: 'ARI_NOTIFICATION_NUM_REQUESTS',
218: p_requests);
219:

Line 223: WF_ENGINE.SetItemAttrText('ARIPRNTF',

219:
220: /*------------------------------------------------------------------+
221: | Set the URL param for the embedded framework region |
222: +------------------------------------------------------------------*/
223: WF_ENGINE.SetItemAttrText('ARIPRNTF',
224: p_request_id,
225: 'ARI_NOTIFICATION_REQUEST_IDS',
226: p_parameter);
227:

Line 234: WF_ENGINE.STARTPROCESS('ARIPRNTF',

230: -----------------------------------------------------------------------------------------
231: IF (PG_DEBUG = 'Y') THEN
232: arp_standard.debug(l_debug_info);
233: END IF;
234: WF_ENGINE.STARTPROCESS('ARIPRNTF',
235: p_request_id);
236:
237: EXCEPTION
238: WHEN OTHERS THEN

Line 2147: WF_ENGINE.CREATEPROCESS(l_itemtype,

2143: --------------------------------------------------------------------
2144: l_debug_info := 'creating workflow process';
2145: --------------------------------------------------------------------
2146:
2147: WF_ENGINE.CREATEPROCESS(l_itemtype,
2148: l_customer_trx_id,
2149: 'ARI_INVOICE_NTF_PROCESS');
2150:
2151: ----------------------------------------------------------------------------

Line 2158: WF_ENGINE.SetItemAttrText(l_itemtype,

2154:
2155: ----------------------------------------------------------------------------
2156: l_debug_info := 'Set ARI_CUSTOMER_TRX_ID parameter';
2157: ----------------------------------------------------------------------------
2158: WF_ENGINE.SetItemAttrText(l_itemtype,
2159: l_customer_trx_id,
2160: 'ARI_CUSTOMER_TRX_ID',
2161: l_customer_trx_id);
2162:

Line 2167: WF_ENGINE.SetItemAttrText(l_itemtype,

2163: ----------------------------------------------------------------------------
2164: l_debug_info := 'Set ARI_TRX_NUM parameter';
2165: ----------------------------------------------------------------------------
2166:
2167: WF_ENGINE.SetItemAttrText(l_itemtype,
2168: l_customer_trx_id,
2169: 'ARI_TRX_NUMBER',
2170: l_trx_number);
2171:

Line 2176: WF_ENGINE.SetItemAttrText(l_itemtype,

2172: ----------------------------------------------------------------------------
2173: l_debug_info := 'Set ARI_CUST_ACCT_NUM parameter';
2174: ----------------------------------------------------------------------------
2175:
2176: WF_ENGINE.SetItemAttrText(l_itemtype,
2177: l_customer_trx_id,
2178: 'ARI_CUST_ACCT_NUM',
2179: l_customer_acct_number);
2180:

Line 2185: WF_ENGINE.SetItemAttrText(l_itemtype,

2181: ----------------------------------------------------------------------------
2182: l_debug_info := 'Set ARI_CUST_ACCT_ID parameter';
2183: ----------------------------------------------------------------------------
2184:
2185: WF_ENGINE.SetItemAttrText(l_itemtype,
2186: l_customer_trx_id,
2187: 'ARI_CUST_ACCT_ID',
2188: l_customer_id);
2189:

Line 2194: WF_ENGINE.SetItemAttrText(l_itemtype,

2190: ----------------------------------------------------------------------------
2191: l_debug_info := 'Set ARI_CUST_ACCT_NAME parameter';
2192: ----------------------------------------------------------------------------
2193:
2194: WF_ENGINE.SetItemAttrText(l_itemtype,
2195: l_customer_trx_id,
2196: 'ARI_CUST_ACCT_NAME',
2197: l_customer_acct_name);
2198:

Line 2203: WF_ENGINE.SetItemAttrText(l_itemtype,

2199: ----------------------------------------------------------------------------
2200: l_debug_info := 'Set ARI_CUST_ACCT_SITE_NUM parameter';
2201: ----------------------------------------------------------------------------
2202:
2203: WF_ENGINE.SetItemAttrText(l_itemtype,
2204: l_customer_trx_id,
2205: 'ARI_CUST_ACCT_SITE_ID',
2206: l_customer_acct_site_id);
2207:

Line 2216: WF_ENGINE.StartProcess(l_itemtype,l_customer_trx_id);

2212: IF (PG_DEBUG = 'Y') THEN
2213: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'End time:' || TO_CHAR(SYSDATE, 'HH24:MI:SSSSS') || '+');
2214: END IF;
2215:
2216: WF_ENGINE.StartProcess(l_itemtype,l_customer_trx_id);
2217:
2218:
2219: RETURN 'SUCCESS';
2220:

Line 2529: l_customer_trx_id:= wf_engine.GetItemAttrText(itemtype => l_itemtype,

2525: -----------------------------------------------------------
2526: l_debug_info := 'Retrieve ARI_CUSTOMER_TRX_ID Item Attribute';
2527: -----------------------------------------------------------
2528:
2529: l_customer_trx_id:= wf_engine.GetItemAttrText(itemtype => l_itemtype,
2530: itemkey => l_itemkey,
2531: aname => 'ARI_CUSTOMER_TRX_ID');
2532: IF (PG_DEBUG = 'Y') THEN
2533: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'ARI_CUSTOMER_TRX_ID ::' || l_customer_trx_id );

Line 2540: l_trx_number:= wf_engine.GetItemAttrText(itemtype => l_itemtype,

2536: -----------------------------------------------------------
2537: l_debug_info := 'Retrieve ARI_TRX_NUM Item Attribute';
2538: -----------------------------------------------------------
2539:
2540: l_trx_number:= wf_engine.GetItemAttrText(itemtype => l_itemtype,
2541: itemkey => l_itemkey,
2542: aname => 'ARI_TRX_NUMBER');
2543: IF (PG_DEBUG = 'Y') THEN
2544: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'ARI_TRX_NUMBER ::' || l_trx_number);

Line 2551: p_customer_id:= wf_engine.GetItemAttrText(itemtype => l_itemtype,

2547: -----------------------------------------------------------
2548: l_debug_info := 'Retrieve ARI_CUST_ACCT_NUM Item Attribute';
2549: -----------------------------------------------------------
2550:
2551: p_customer_id:= wf_engine.GetItemAttrText(itemtype => l_itemtype,
2552: itemkey => l_itemkey,
2553: aname => 'ARI_CUST_ACCT_ID');
2554: IF (PG_DEBUG = 'Y') THEN
2555: arp_standard.debug(G_PKG_NAME || l_procedure_name || 'ARI_CUST_ACCT_ID ::' || p_customer_id );

Line 2562: p_customer_acct_site_id := wf_engine.GetItemAttrText(itemtype => l_itemtype,

2558: ---------------------------------------------------------------
2559: l_debug_info := 'Retrieve ARI_CUST_ACCT_SITE_ID Item Attribute';
2560: ----------------------------------------------------------------
2561:
2562: p_customer_acct_site_id := wf_engine.GetItemAttrText(itemtype => l_itemtype,
2563: itemkey => l_itemkey,
2564: aname => 'ARI_CUST_ACCT_SITE_ID');
2565:
2566: IF (PG_DEBUG = 'Y') THEN

Line 2657: WF_ENGINE.SetItemAttrText(l_itemtype,

2653: --------------------------------------------------------------
2654: l_debug_info := 'Set AR_NOTIFY_ROLES Item Attribute';
2655: --------------------------------------------------------------
2656:
2657: WF_ENGINE.SetItemAttrText(l_itemtype,
2658: l_customer_trx_id,
2659: 'ARI_NOTIFY_ROLES',
2660: l_adhoc_user_name);
2661:

Line 2669: WF_ENGINE.SetItemAttrText(l_itemtype,

2665: --------------------------------------------------------------
2666: l_debug_info := 'Set ARI_TRX_NUM Item Attribute';
2667: --------------------------------------------------------------
2668:
2669: WF_ENGINE.SetItemAttrText(l_itemtype,
2670: l_customer_trx_id,
2671: 'ARI_TRX_NUMBER',
2672: l_trx_number);
2673:

Line 2682: WF_ENGINE.SetItemAttrText(l_itemtype,

2678: --------------------------------------------------------------
2679: l_debug_info := 'Set ARI_TRX_AMT_DUE Item Attribute';
2680: --------------------------------------------------------------
2681:
2682: WF_ENGINE.SetItemAttrText(l_itemtype,
2683: l_customer_trx_id,
2684: 'ARI_TRX_AMT_DUE',
2685: l_trx_amt_due);
2686:

Line 2695: WF_ENGINE.SetItemAttrText(l_itemtype,

2691: --------------------------------------------------------------
2692: l_debug_info := 'Set ARI_INV_CUR_CODE Item Attribute';
2693: --------------------------------------------------------------
2694:
2695: WF_ENGINE.SetItemAttrText(l_itemtype,
2696: l_customer_trx_id,
2697: 'ARI_TRX_CUR_CODE',
2698: l_trx_curr_code);
2699:

Line 2708: WF_ENGINE.SetItemAttrText(l_itemtype,

2704: --------------------------------------------------------------
2705: l_debug_info := 'Set ARI_TRX_DUE_DATE Item Attribute';
2706: --------------------------------------------------------------
2707:
2708: WF_ENGINE.SetItemAttrText(l_itemtype,
2709: l_customer_trx_id,
2710: 'ARI_TRX_DUE_DATE',
2711: l_trx_due_date);
2712:

Line 2721: WF_ENGINE.SetItemAttrText(l_itemtype,

2717: --------------------------------------------------------------
2718: l_debug_info := 'Set ARI_TRX_PAY_TERM Item Attribute';
2719: --------------------------------------------------------------
2720:
2721: WF_ENGINE.SetItemAttrText(l_itemtype,
2722: l_customer_trx_id,
2723: 'ARI_TRX_PAY_TERM',
2724: l_trx_term_name);
2725:

Line 2734: WF_ENGINE.SetItemAttrText(l_itemtype,

2730: --------------------------------------------------------------
2731: l_debug_info := 'Set ARI_TRX_PAY_TERM_DESC Item Attribute';
2732: --------------------------------------------------------------
2733:
2734: WF_ENGINE.SetItemAttrText(l_itemtype,
2735: l_customer_trx_id,
2736: 'ARI_TRX_PAY_TERM_DESC',
2737: l_trx_term_desc);
2738:

Line 2837: l_customer_trx_id := wf_engine.getitemattrnumber(l_item_type, p_dispute_id, 'CUSTOMER_TRX_ID');

2833: FETCH c_item_type INTO l_item_type;
2834: CLOSE c_item_type;
2835:
2836: IF l_item_type IS NOT NULL THEN
2837: l_customer_trx_id := wf_engine.getitemattrnumber(l_item_type, p_dispute_id, 'CUSTOMER_TRX_ID');
2838: END IF;
2839:
2840: SELECT total_amount * -1
2841: INTO remove_from_dispute_amt

Line 2879: wf_engine.SetItemAttrText(l_item_type, p_dispute_id, 'NOTES', p_cancel_comments);

2875: p_attribute15 => NULL);
2876:
2877: END LOOP;
2878:
2879: wf_engine.SetItemAttrText(l_item_type, p_dispute_id, 'NOTES', p_cancel_comments);
2880:
2881: wf_engine.itemstatus(itemtype => l_item_type, itemkey => p_dispute_id, status => l_status, result => l_result);
2882:
2883: IF l_status <> wf_engine.eng_completed THEN

Line 2881: wf_engine.itemstatus(itemtype => l_item_type, itemkey => p_dispute_id, status => l_status, result => l_result);

2877: END LOOP;
2878:
2879: wf_engine.SetItemAttrText(l_item_type, p_dispute_id, 'NOTES', p_cancel_comments);
2880:
2881: wf_engine.itemstatus(itemtype => l_item_type, itemkey => p_dispute_id, status => l_status, result => l_result);
2882:
2883: IF l_status <> wf_engine.eng_completed THEN
2884: wf_engine.abortprocess(itemtype => l_item_type, itemkey => p_dispute_id);
2885: wf_engine.itemstatus(itemtype => l_item_type, itemkey => p_dispute_id, status => l_status, result => l_result);

Line 2883: IF l_status <> wf_engine.eng_completed THEN

2879: wf_engine.SetItemAttrText(l_item_type, p_dispute_id, 'NOTES', p_cancel_comments);
2880:
2881: wf_engine.itemstatus(itemtype => l_item_type, itemkey => p_dispute_id, status => l_status, result => l_result);
2882:
2883: IF l_status <> wf_engine.eng_completed THEN
2884: wf_engine.abortprocess(itemtype => l_item_type, itemkey => p_dispute_id);
2885: wf_engine.itemstatus(itemtype => l_item_type, itemkey => p_dispute_id, status => l_status, result => l_result);
2886: END IF;
2887:

Line 2884: wf_engine.abortprocess(itemtype => l_item_type, itemkey => p_dispute_id);

2880:
2881: wf_engine.itemstatus(itemtype => l_item_type, itemkey => p_dispute_id, status => l_status, result => l_result);
2882:
2883: IF l_status <> wf_engine.eng_completed THEN
2884: wf_engine.abortprocess(itemtype => l_item_type, itemkey => p_dispute_id);
2885: wf_engine.itemstatus(itemtype => l_item_type, itemkey => p_dispute_id, status => l_status, result => l_result);
2886: END IF;
2887:
2888: l_last_updated_by := arp_global.user_id;

Line 2885: wf_engine.itemstatus(itemtype => l_item_type, itemkey => p_dispute_id, status => l_status, result => l_result);

2881: wf_engine.itemstatus(itemtype => l_item_type, itemkey => p_dispute_id, status => l_status, result => l_result);
2882:
2883: IF l_status <> wf_engine.eng_completed THEN
2884: wf_engine.abortprocess(itemtype => l_item_type, itemkey => p_dispute_id);
2885: wf_engine.itemstatus(itemtype => l_item_type, itemkey => p_dispute_id, status => l_status, result => l_result);
2886: END IF;
2887:
2888: l_last_updated_by := arp_global.user_id;
2889: l_last_update_login := arp_global.last_update_login;

Line 2890: l_document_id := wf_engine.getitemattrnumber(l_item_type, p_dispute_id, 'WORKFLOW_DOCUMENT_ID');

2886: END IF;
2887:
2888: l_last_updated_by := arp_global.user_id;
2889: l_last_update_login := arp_global.last_update_login;
2890: l_document_id := wf_engine.getitemattrnumber(l_item_type, p_dispute_id, 'WORKFLOW_DOCUMENT_ID');
2891: l_customer_trx_id := wf_engine.getitemattrnumber(l_item_type, p_dispute_id, 'CUSTOMER_TRX_ID');
2892:
2893:
2894: if l_customer_trx_id is null then

Line 2891: l_customer_trx_id := wf_engine.getitemattrnumber(l_item_type, p_dispute_id, 'CUSTOMER_TRX_ID');

2887:
2888: l_last_updated_by := arp_global.user_id;
2889: l_last_update_login := arp_global.last_update_login;
2890: l_document_id := wf_engine.getitemattrnumber(l_item_type, p_dispute_id, 'WORKFLOW_DOCUMENT_ID');
2891: l_customer_trx_id := wf_engine.getitemattrnumber(l_item_type, p_dispute_id, 'CUSTOMER_TRX_ID');
2892:
2893:
2894: if l_customer_trx_id is null then
2895: SELECT customer_trx_id

Line 2901: l_notes := wf_engine.getitemattrtext(l_item_type, p_dispute_id, 'NOTES');

2897: FROM ra_cm_requests
2898: WHERE request_id = l_document_id;
2899: end if;
2900:
2901: l_notes := wf_engine.getitemattrtext(l_item_type, p_dispute_id, 'NOTES');
2902: fnd_message.set_name('AR', 'AR_WF_REJECTED_RESPONSE');
2903: fnd_message.set_token('REQUEST_ID', to_char(p_dispute_id));
2904: fnd_message.set_token('APPROVER', fnd_global.user_id);
2905: l_note_text := fnd_message.GET;