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

Line 20: -- step must be performed. A call to wf_engine.CompleteActivty

16: -- - DEFERED
17: -- execution should be defered to background
18: -- - NOTIFIED[::]
19: -- activity has notified an external entity that this
20: -- step must be performed. A call to wf_engine.CompleteActivty
21: -- will signal when this step is complete. Optional
22: -- return of notification ID and assigned user.
23: -- - ERROR[:]
24: -- function encountered an error.

Line 69: wf_engine.setitemattrnumber(

65: OPEN org;
66: FETCH org INTO l_org_id;
67: CLOSE org;
68:
69: wf_engine.setitemattrnumber(
70: p_item_type,
71: p_item_key,
72: 'ORG_ID',
73: l_org_id);

Line 201: WF_ENGINE.SetItemAttrNumber(p_item_type,

197:
198:
199: if l_customer_trx_id <> -1 then
200:
201: WF_ENGINE.SetItemAttrNumber(p_item_type,
202: p_item_key,
203: 'WORKFLOW_DOCUMENT_ID',
204: l_workflow_document_id);
205:

Line 207: WF_ENGINE.SetItemAttrNumber(p_item_type,

203: 'WORKFLOW_DOCUMENT_ID',
204: l_workflow_document_id);
205:
206:
207: WF_ENGINE.SetItemAttrNumber(p_item_type,
208: p_item_key,
209: 'CUSTOMER_TRX_ID',
210: l_customer_trx_id);
211:

Line 212: WF_ENGINE.SetItemAttrNumber(p_item_type,

208: p_item_key,
209: 'CUSTOMER_TRX_ID',
210: l_customer_trx_id);
211:
212: WF_ENGINE.SetItemAttrNumber(p_item_type,
213: p_item_key,
214: 'TOTAL_CREDIT_TO_INVOICE',
215: l_amount);
216:

Line 217: WF_ENGINE.SetItemAttrNumber(p_item_type,

213: p_item_key,
214: 'TOTAL_CREDIT_TO_INVOICE',
215: l_amount);
216:
217: WF_ENGINE.SetItemAttrNumber(p_item_type,
218: p_item_key,
219: 'TOTAL_CREDIT_TO_LINES',
220: l_line_amount);
221:

Line 222: WF_ENGINE.SetItemAttrNumber(p_item_type,

218: p_item_key,
219: 'TOTAL_CREDIT_TO_LINES',
220: l_line_amount);
221:
222: WF_ENGINE.SetItemAttrNumber(p_item_type,
223: p_item_key,
224: 'TOTAL_CREDIT_TO_TAX',
225: l_tax_amount);
226:

Line 227: WF_ENGINE.SetItemAttrNumber(p_item_type,

223: p_item_key,
224: 'TOTAL_CREDIT_TO_TAX',
225: l_tax_amount);
226:
227: WF_ENGINE.SetItemAttrNumber(p_item_type,
228: p_item_key,
229: 'TOTAL_CREDIT_TO_FREIGHT',
230: l_freight_amount);
231:

Line 232: WF_ENGINE.SetItemAttrText(p_item_type,

228: p_item_key,
229: 'TOTAL_CREDIT_TO_FREIGHT',
230: l_freight_amount);
231:
232: WF_ENGINE.SetItemAttrText(p_item_type,
233: p_item_key,
234: 'REASON',
235: l_reason_code);
236:

Line 237: WF_ENGINE.SetItemAttrText(p_item_type,

233: p_item_key,
234: 'REASON',
235: l_reason_code);
236:
237: WF_ENGINE.SetItemAttrText(p_item_type,
238: p_item_key,
239: 'REASON_MEANING',
240: l_reason_meaning);
241:

Line 242: WF_ENGINE.SetItemAttrText(p_item_type,

238: p_item_key,
239: 'REASON_MEANING',
240: l_reason_meaning);
241:
242: WF_ENGINE.SetItemAttrText(p_item_type,
243: p_item_key,
244: 'COMMENTS',
245: l_comments);
246:

Line 248: WF_ENGINE.SetItemAttrNumber(p_item_type,

244: 'COMMENTS',
245: l_comments);
246:
247:
248: WF_ENGINE.SetItemAttrNumber(p_item_type,
249: p_item_key,
250: 'REQUESTOR_ID',
251: l_requestor_id);
252:

Line 253: WF_ENGINE.SetItemAttrText(p_item_type,

249: p_item_key,
250: 'REQUESTOR_ID',
251: l_requestor_id);
252:
253: WF_ENGINE.SetItemAttrText(p_item_type,
254: p_item_key,
255: 'ORIG_TRX_NUMBER',
256: l_orig_trx_number);
257:

Line 258: WF_ENGINE.SetItemAttrText(p_item_type,

254: p_item_key,
255: 'ORIG_TRX_NUMBER',
256: l_orig_trx_number);
257:
258: WF_ENGINE.SetItemAttrText(p_item_type,
259: p_item_key,
260: 'TAX_EX_CERT_NUM',
261: l_tax_ex_cert_num);
262: /*7367350 set attribute*/

Line 263: wf_engine.SetItemAttrText(p_item_type,

259: p_item_key,
260: 'TAX_EX_CERT_NUM',
261: l_tax_ex_cert_num);
262: /*7367350 set attribute*/
263: wf_engine.SetItemAttrText(p_item_type,
264: p_item_key,
265: 'INTERNAL_COMMENTS',
266: l_internal_comment);
267:

Line 286: WF_ENGINE.SetItemAttrText(p_item_type,

282: end if;
283: end if;
284:
285:
286: WF_ENGINE.SetItemAttrText(p_item_type,
287: p_item_key,
288: 'REQUESTOR_USER_NAME',
289: l_requestor_user_name);
290:

Line 291: WF_ENGINE.SetItemAttrText(p_item_type,

287: p_item_key,
288: 'REQUESTOR_USER_NAME',
289: l_requestor_user_name);
290:
291: WF_ENGINE.SetItemAttrText(p_item_type,
292: p_item_key,
293: 'REQUESTOR_DISPLAY_NAME',
294: l_requestor_display_name);
295:

Line 307: WF_ENGINE.SetItemAttrNumber(p_item_type,

303: l_original_freight_amount,
304: l_original_total ,
305: l_currency_code);
306:
307: WF_ENGINE.SetItemAttrNumber(p_item_type,
308: p_item_key,
309: 'ORIGINAL_LINE_AMOUNT',
310: l_original_line_amount);
311:

Line 312: WF_ENGINE.SetItemAttrNumber(p_item_type,

308: p_item_key,
309: 'ORIGINAL_LINE_AMOUNT',
310: l_original_line_amount);
311:
312: WF_ENGINE.SetItemAttrNumber(p_item_type,
313: p_item_key,
314: 'ORIGINAL_TAX_AMOUNT',
315: l_original_tax_amount);
316:

Line 318: WF_ENGINE.SetItemAttrNumber(p_item_type,

314: 'ORIGINAL_TAX_AMOUNT',
315: l_original_tax_amount);
316:
317:
318: WF_ENGINE.SetItemAttrNumber(p_item_type,
319: p_item_key,
320: 'ORIGINAL_FREIGHT_AMOUNT',
321: l_original_freight_amount);
322:

Line 323: WF_ENGINE.SetItemAttrNumber(p_item_type,

319: p_item_key,
320: 'ORIGINAL_FREIGHT_AMOUNT',
321: l_original_freight_amount);
322:
323: WF_ENGINE.SetItemAttrNumber(p_item_type,
324: p_item_key,
325: 'ORIGINAL_TOTAL',
326: l_original_total);
327:

Line 328: WF_ENGINE.SetItemAttrText(p_item_type,

324: p_item_key,
325: 'ORIGINAL_TOTAL',
326: l_original_total);
327:
328: WF_ENGINE.SetItemAttrText(p_item_type,
329: p_item_key,
330: 'CURRENCY_CODE',
331: l_currency_code);
332: p_result := 'COMPLETE:T';

Line 478: WF_ENGINE.SetItemAttrText(p_item_type,

474: fnd_message.set_name('AR', 'ARW_INV_MSG10');
475: l_tax_disclaimer := fnd_message.get;
476: end if;
477:
478: WF_ENGINE.SetItemAttrText(p_item_type,
479: p_item_key,
480: 'TAX_DISCLAIMER',
481: l_tax_disclaimer);
482:

Line 579: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(

575:
576: ------------------------------------------------------------
577: l_debug_mesg := 'Get requested trx id ';
578: ------------------------------------------------------------
579: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(
580: p_item_type,
581: p_item_key,
582: 'CUSTOMER_TRX_ID');
583:

Line 616: WF_ENGINE.SetItemAttrNumber(p_item_type,

612: ----------------------------------------------------------------------
613: l_debug_mesg := 'Set value for customer_id(name) in workflow process';
614: -----------------------------------------------------------------------
615:
616: WF_ENGINE.SetItemAttrNumber(p_item_type,
617: p_item_key,
618: 'CUSTOMER_ID',
619: l_customer_id);
620:

Line 622: WF_ENGINE.SetItemAttrText(p_item_type,

618: 'CUSTOMER_ID',
619: l_customer_id);
620:
621:
622: WF_ENGINE.SetItemAttrText(p_item_type,
623: p_item_key,
624: 'CUSTOMER_NAME',
625: l_bill_to_customer_name);
626:

Line 629: WF_ENGINE.SetItemAttrText(p_item_type,

625: l_bill_to_customer_name);
626:
627: -- set the bill to and ship to customer info.
628:
629: WF_ENGINE.SetItemAttrText(p_item_type,
630: p_item_key,
631: 'BILL_TO_CUSTOMER_NAME',
632: l_bill_to_customer_name);
633:

Line 636: WF_ENGINE fom SetItemAttrNumber to SetItemAttrText

632: l_bill_to_customer_name);
633:
634: /* Bug Fix 1882580. Since l_bill_to_customer_number is changed
635: from number to varchar2, replaced the function in call to
636: WF_ENGINE fom SetItemAttrNumber to SetItemAttrText
637: */
638:
639: WF_ENGINE.SetItemAttrText(p_item_type,
640: p_item_key,

Line 639: WF_ENGINE.SetItemAttrText(p_item_type,

635: from number to varchar2, replaced the function in call to
636: WF_ENGINE fom SetItemAttrNumber to SetItemAttrText
637: */
638:
639: WF_ENGINE.SetItemAttrText(p_item_type,
640: p_item_key,
641: 'BILL_TO_CUSTOMER_NUMBER',
642: l_bill_to_customer_number);
643:

Line 644: WF_ENGINE.SetItemAttrText(p_item_type,

640: p_item_key,
641: 'BILL_TO_CUSTOMER_NUMBER',
642: l_bill_to_customer_number);
643:
644: WF_ENGINE.SetItemAttrText(p_item_type,
645: p_item_key,
646: 'SHIP_TO_CUSTOMER_NAME',
647: l_ship_to_customer_name);
648:

Line 651: WF_ENGINE fom SetItemAttrNumber to SetItemAttrText

647: l_ship_to_customer_name);
648:
649: /* Bug Fix 1882580. Since l_bill_to_customer_number is changed
650: from number to varchar2, replaced the function in call to
651: WF_ENGINE fom SetItemAttrNumber to SetItemAttrText
652: */
653: WF_ENGINE.SetItemAttrText(p_item_type,
654: p_item_key,
655: 'SHIP_TO_CUSTOMER_NUMBER',

Line 653: WF_ENGINE.SetItemAttrText(p_item_type,

649: /* Bug Fix 1882580. Since l_bill_to_customer_number is changed
650: from number to varchar2, replaced the function in call to
651: WF_ENGINE fom SetItemAttrNumber to SetItemAttrText
652: */
653: WF_ENGINE.SetItemAttrText(p_item_type,
654: p_item_key,
655: 'SHIP_TO_CUSTOMER_NUMBER',
656: l_ship_to_customer_number);
657:

Line 660: WF_ENGINE.SetItemAttrText(p_item_type,

656: l_ship_to_customer_number);
657:
658: -- set the trx number
659:
660: WF_ENGINE.SetItemAttrText(p_item_type,
661: p_item_key,
662: 'TRX_NUMBER',
663: l_trx_number);
664:

Line 670: WF_ENGINE.SetItemAttrNumber(p_item_type,

666:
667: ----------------------------------------------------------------------
668: l_debug_mesg := 'Set value for bill_to_site_use_id in workflow process';
669: -----------------------------------------------------------------------
670: WF_ENGINE.SetItemAttrNumber(p_item_type,
671: p_item_key,
672: 'BILL_TO_SITE_USE_ID',
673: l_bill_to_site_use_id);
674:

Line 679: l_request_id := WF_ENGINE.GetItemAttrNumber(

675:
676:
677: -- set the URL site
678:
679: l_request_id := WF_ENGINE.GetItemAttrNumber(
680: p_item_type,
681: p_item_key,
682: 'WORKFLOW_DOCUMENT_ID');
683:

Line 692: WF_ENGINE.SetItemAttrText(p_item_type,

688:
689: l_request_url := l_url;
690:
691:
692: WF_ENGINE.SetItemAttrText(p_item_type,
693: p_item_key,
694: 'REQUEST_URL',
695: l_request_url);
696:

Line 706: WF_ENGINE.SetItemAttrText(p_item_type,

702: from ra_cm_requests
703: where request_id = p_item_key;
704:
705:
706: WF_ENGINE.SetItemAttrText(p_item_type,
707: p_item_key,
708: 'TRANSACTION_NUMBER_URL',
709: l_trans_url);
710:

Line 718: WF_ENGINE.SetItemAttrText(p_item_type,

714: from ra_cm_requests
715: where request_id =p_item_key;
716:
717:
718: WF_ENGINE.SetItemAttrText(p_item_type,
719: p_item_key,
720: 'TRANSACTION_ACTIVITY_URL',
721: l_act_url);
722:

Line 867: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(

863:
864: -----------------------------------------------------------------
865: l_debug_mesg := 'Get the value of customer_trx_id(customer id)';
866: -----------------------------------------------------------------
867: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(
868: p_item_type,
869: p_item_key,
870: 'CUSTOMER_TRX_ID');
871:

Line 873: l_customer_id := WF_ENGINE.GetItemAttrNumber(

869: p_item_key,
870: 'CUSTOMER_TRX_ID');
871:
872:
873: l_customer_id := WF_ENGINE.GetItemAttrNumber(
874: p_item_type,
875: p_item_key,
876: 'CUSTOMER_ID');
877:

Line 882: l_bill_to_site_use_id := WF_ENGINE.GetItemAttrNumber(

878:
879: ----------------------------------------------------------------------
880: l_debug_mesg := 'get value of bill_to_site_use_id from workflow process';
881: -----------------------------------------------------------------------
882: l_bill_to_site_use_id := WF_ENGINE.GetItemAttrNumber(
883: p_item_type,
884: p_item_key,
885: 'BILL_TO_SITE_USE_ID');
886:

Line 907: WF_ENGINE.SetItemAttrNumber(p_item_type,

903: ----------------------------------------------------------------
904: l_debug_mesg := 'Set value for collector in workflow process';
905: ----------------------------------------------------------------
906:
907: WF_ENGINE.SetItemAttrNumber(p_item_type,
908: p_item_key,
909: 'COLLECTOR_EMPLOYEE_ID',
910: l_collector_employee_id);
911:

Line 912: WF_ENGINE.SetItemAttrNumber(p_item_type,

908: p_item_key,
909: 'COLLECTOR_EMPLOYEE_ID',
910: l_collector_employee_id);
911:
912: WF_ENGINE.SetItemAttrNumber(p_item_type,
913: p_item_key,
914: 'COLLECTOR_ID',
915: l_collector_id);
916:

Line 917: WF_ENGINE.SetItemAttrText(p_item_type,

913: p_item_key,
914: 'COLLECTOR_ID',
915: l_collector_id);
916:
917: WF_ENGINE.SetItemAttrText(p_item_type,
918: p_item_key,
919: 'COLLECTOR_NAME',
920: l_collector_name);
921:

Line 938: WF_ENGINE.SetItemAttrText(p_item_type,

934: -----------------------------------------------------------------
935: p_result := 'COMPLETE:F';
936: return;
937: else
938: WF_ENGINE.SetItemAttrText(p_item_type,
939: p_item_key,
940: 'COLLECTOR_USER_NAME',
941: l_collector_user_name);
942:

Line 943: WF_ENGINE.SetItemAttrText(p_item_type,

939: p_item_key,
940: 'COLLECTOR_USER_NAME',
941: l_collector_user_name);
942:
943: WF_ENGINE.SetItemAttrText(p_item_type,
944: p_item_key,
945: 'COLLECTOR_DISPLAY_NAME',
946: l_collector_display_name);
947: end if;

Line 1088: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(

1084: ------------------------------------------------------------
1085:
1086: /* Bug 991922 : get additional information to determine if rule is required */
1087:
1088: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(
1089: p_item_type,
1090: p_item_key,
1091: 'CUSTOMER_TRX_ID');
1092:

Line 1093: l_credit_accounting_rule := WF_ENGINE.GetItemAttrText(

1089: p_item_type,
1090: p_item_key,
1091: 'CUSTOMER_TRX_ID');
1092:
1093: l_credit_accounting_rule := WF_ENGINE.GetItemAttrText(
1094: p_item_type,
1095: p_item_key,
1096: 'CREDIT_ACCOUNTING_RULE');
1097:

Line 1098: l_reason_code := WF_ENGINE.GetItemAttrText(

1094: p_item_type,
1095: p_item_key,
1096: 'CREDIT_ACCOUNTING_RULE');
1097:
1098: l_reason_code := WF_ENGINE.GetItemAttrText(
1099: p_item_type,
1100: p_item_key,
1101: 'REASON');
1102:

Line 1103: l_currency_code := WF_ENGINE.GetItemAttrText(

1099: p_item_type,
1100: p_item_key,
1101: 'REASON');
1102:
1103: l_currency_code := WF_ENGINE.GetItemAttrText(
1104: p_item_type,
1105: p_item_key,
1106: 'CURRENCY_CODE');
1107:

Line 1119: WF_ENGINE.SetItemAttrText(p_item_type,

1115: -----------------------------------------
1116: l_debug_mesg := 'No first approver found';
1117: ------------------------------------------
1118:
1119: WF_ENGINE.SetItemAttrText(p_item_type,
1120: p_item_key,
1121: 'ROLE',
1122: '');
1123:

Line 1135: l_approver_user_name := WF_ENGINE.GetItemAttrText(p_item_type,

1131: p_item_type,
1132: p_item_key,
1133: 'Y');
1134:
1135: l_approver_user_name := WF_ENGINE.GetItemAttrText(p_item_type,
1136: p_item_key,
1137: 'APPROVER_USER_NAME');
1138: IF l_approver_user_name IS NULL THEN
1139: p_result := 'COMPLETE:F';

Line 1143: WF_ENGINE.SetItemAttrText(p_item_type,

1139: p_result := 'COMPLETE:F';
1140: return;
1141: ELSE
1142:
1143: WF_ENGINE.SetItemAttrText(p_item_type,
1144: p_item_key,
1145: 'ROLE',
1146: l_approver_user_name);
1147:

Line 1149: l_collector_user_name := WF_ENGINE.GetItemAttrText(p_item_type,

1145: 'ROLE',
1146: l_approver_user_name);
1147:
1148:
1149: l_collector_user_name := WF_ENGINE.GetItemAttrText(p_item_type,
1150: p_item_key,
1151: 'COLLECTOR_USER_NAME');
1152:
1153: WF_ENGINE.SetItemAttrText(p_item_type,

Line 1153: WF_ENGINE.SetItemAttrText(p_item_type,

1149: l_collector_user_name := WF_ENGINE.GetItemAttrText(p_item_type,
1150: p_item_key,
1151: 'COLLECTOR_USER_NAME');
1152:
1153: WF_ENGINE.SetItemAttrText(p_item_type,
1154: p_item_key,
1155: 'APPROVER_USER_NAME',
1156: l_collector_user_name);
1157:

Line 1161: l_collector_display_name := WF_ENGINE.GetItemAttrText(p_item_type,

1157:
1158: -- Bug 1331562 : set approver_display_name to collector's name, so that details
1159: -- inserted into Notes are accurate
1160:
1161: l_collector_display_name := WF_ENGINE.GetItemAttrText(p_item_type,
1162: p_item_key,
1163: 'COLLECTOR_DISPLAY_NAME');
1164: WF_ENGINE.SetItemAttrText(p_item_type,
1165: p_item_key,

Line 1164: WF_ENGINE.SetItemAttrText(p_item_type,

1160:
1161: l_collector_display_name := WF_ENGINE.GetItemAttrText(p_item_type,
1162: p_item_key,
1163: 'COLLECTOR_DISPLAY_NAME');
1164: WF_ENGINE.SetItemAttrText(p_item_type,
1165: p_item_key,
1166: 'APPROVER_DISPLAY_NAME',
1167: l_collector_display_name);
1168:

Line 1172: l_collector_employee_id := WF_ENGINE.GetItemAttrText(p_item_type,

1168:
1169: /* Bug 3195343 Getting the collector_employee_id , from which the
1170: user_id is obtained .Set this user_id as the APPROVER_ID. */
1171:
1172: l_collector_employee_id := WF_ENGINE.GetItemAttrText(p_item_type,
1173: p_item_key,
1174: 'COLLECTOR_EMPLOYEE_ID');
1175: Open c1;
1176: Fetch c1 into l_collector_user_id ;

Line 1179: WF_ENGINE.SetItemAttrText(p_item_type,

1175: Open c1;
1176: Fetch c1 into l_collector_user_id ;
1177: Close c1;
1178:
1179: WF_ENGINE.SetItemAttrText(p_item_type,
1180: p_item_key,
1181: 'APPROVER_ID',
1182: l_collector_user_id);
1183:

Line 1198: WF_ENGINE.SetItemAttrText(p_item_type,

1194:
1195: fnd_message.set_name('AR', 'ARW_NEED_RULE');
1196: l_need_rule_mesg := fnd_message.get;
1197:
1198: WF_ENGINE.SetItemAttrText(p_item_type,
1199: p_item_key,
1200: 'INVALID_RULE_MESG',
1201: l_need_rule_mesg);
1202: end if;

Line 1270: l_approver_name := WF_ENGINE.GetItemAttrText(p_item_type,

1266: ------------------------------------------------------------
1267: l_debug_mesg := 'Get the user name of selected role';
1268: ------------------------------------------------------------
1269:
1270: l_approver_name := WF_ENGINE.GetItemAttrText(p_item_type,
1271: p_item_key,
1272: 'ROLE');
1273:
1274: IF l_approver_name IS NULL THEN

Line 1279: l_reason_code := WF_ENGINE.GetItemAttrText(

1275: p_result := 'COMPLETE:N';
1276: RETURN;
1277: END IF;
1278:
1279: l_reason_code := WF_ENGINE.GetItemAttrText(
1280: p_item_type,
1281: p_item_key,
1282: 'REASON');
1283:

Line 1284: l_currency_code := WF_ENGINE.GetItemAttrText(

1280: p_item_type,
1281: p_item_key,
1282: 'REASON');
1283:
1284: l_currency_code := WF_ENGINE.GetItemAttrText(
1285: p_item_type,
1286: p_item_key,
1287: 'CURRENCY_CODE');
1288:

Line 1366: l_reason_code := WF_ENGINE.GetItemAttrText(

1362: -- RUN mode - normal process execution
1363: --
1364: if (p_funcmode = 'RUN') then
1365:
1366: l_reason_code := WF_ENGINE.GetItemAttrText(
1367: p_item_type,
1368: p_item_key,
1369: 'REASON');
1370:

Line 1371: l_currency_code := WF_ENGINE.GetItemAttrText(

1367: p_item_type,
1368: p_item_key,
1369: 'REASON');
1370:
1371: l_currency_code := WF_ENGINE.GetItemAttrText(
1372: p_item_type,
1373: p_item_key,
1374: 'CURRENCY_CODE');
1375:

Line 1377: l_approver_count := WF_ENGINE.GetItemAttrNumber(

1373: p_item_key,
1374: 'CURRENCY_CODE');
1375:
1376:
1377: l_approver_count := WF_ENGINE.GetItemAttrNumber(
1378: p_item_type,
1379: p_item_key,
1380: 'FIND_APPROVER_COUNT');
1381:

Line 1401: WF_ENGINE.SetItemAttrNumber(p_item_type,

1397: else
1398: -- found the first approver
1399: l_count := 1;
1400:
1401: WF_ENGINE.SetItemAttrNumber(p_item_type,
1402: p_item_key,
1403: 'FIND_APPROVER_COUNT',
1404: l_count);
1405:

Line 1438: WF_ENGINE.SetItemAttrNumber(p_item_type,

1434: p_result := 'COMPLETE:F';
1435: return;
1436: else
1437:
1438: WF_ENGINE.SetItemAttrNumber(p_item_type,
1439: p_item_key,
1440: 'FIND_APPROVER_COUNT',
1441: l_approver_count);
1442:

Line 1518: l_approver_user_name := WF_ENGINE.GetItemAttrText(p_item_type,

1514: ------------------------------------------------------------
1515: l_debug_mesg := 'Retreiving info for Non-Primary Approver';
1516: ------------------------------------------------------------
1517:
1518: l_approver_user_name := WF_ENGINE.GetItemAttrText(p_item_type,
1519: p_item_key,
1520: 'ROLE');
1521:
1522: select employee_id, user_id into l_employee_id, l_approver_id

Line 1607: l_approver_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

1603: ------------------------------------------------------------
1604: l_debug_info := 'Retreiving info for Next Non-Primary Approver';
1605: ------------------------------------------------------------
1606:
1607: l_approver_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
1608: p_item_key,
1609: 'APPROVER_ID');
1610: BEGIN
1611: select employee_id into l_employee_id

Line 1763: l_reason_code := WF_ENGINE.GetItemAttrText(

1759: ------------------------------------------------------------
1760: l_debug_mesg := 'Checking if User exists in Approval Limits Table';
1761: ------------------------------------------------------------
1762:
1763: l_reason_code := WF_ENGINE.GetItemAttrText(
1764: p_item_type,
1765: p_item_key,
1766: 'REASON');
1767:

Line 1768: l_currency_code := WF_ENGINE.GetItemAttrText(

1764: p_item_type,
1765: p_item_key,
1766: 'REASON');
1767:
1768: l_currency_code := WF_ENGINE.GetItemAttrText(
1769: p_item_type,
1770: p_item_key,
1771: 'CURRENCY_CODE');
1772:

Line 1933: WF_ENGINE.SetItemAttrNumber(p_item_type,

1929: l_approver_display_name);
1930:
1931: IF l_approver_user_name IS NOT NULL THEN
1932:
1933: WF_ENGINE.SetItemAttrNumber(p_item_type,
1934: p_item_key,
1935: 'APPROVER_ID',
1936: p_user_id);
1937:

Line 1938: WF_ENGINE.SetItemAttrText(p_item_type,

1934: p_item_key,
1935: 'APPROVER_ID',
1936: p_user_id);
1937:
1938: WF_ENGINE.SetItemAttrText(p_item_type,
1939: p_item_key,
1940: 'APPROVER_USER_NAME',
1941: l_approver_user_name);
1942:

Line 1943: WF_ENGINE.SetItemAttrText(p_item_type,

1939: p_item_key,
1940: 'APPROVER_USER_NAME',
1941: l_approver_user_name);
1942:
1943: WF_ENGINE.SetItemAttrText(p_item_type,
1944: p_item_key,
1945: 'APPROVER_DISPLAY_NAME',
1946: l_approver_display_name);
1947: END IF;

Line 1960: WF_ENGINE.SetItemAttrNumber(p_item_type,

1956: l_manager_display_name);
1957:
1958: IF l_manager_name IS NOT NULL THEN
1959:
1960: WF_ENGINE.SetItemAttrNumber(p_item_type,
1961: p_item_key,
1962: 'MANAGER_ID',
1963: p_user_id);
1964:

Line 1965: WF_ENGINE.SetItemAttrText(p_item_type,

1961: p_item_key,
1962: 'MANAGER_ID',
1963: p_user_id);
1964:
1965: WF_ENGINE.SetItemAttrText(p_item_type,
1966: p_item_key,
1967: 'MANAGER_USER_NAME',
1968: l_manager_name);
1969:

Line 1970: WF_ENGINE.SetItemAttrText(p_item_type,

1966: p_item_key,
1967: 'MANAGER_USER_NAME',
1968: l_manager_name);
1969:
1970: WF_ENGINE.SetItemAttrText(p_item_type,
1971: p_item_key,
1972: 'MANAGER_DISPLAY_NAME',
1973: l_manager_display_name);
1974:

Line 1975: WF_ENGINE.SetItemAttrNumber(p_item_type,

1971: p_item_key,
1972: 'MANAGER_DISPLAY_NAME',
1973: l_manager_display_name);
1974:
1975: WF_ENGINE.SetItemAttrNumber(p_item_type,
1976: p_item_key,
1977: 'APPROVER_ID',
1978: p_user_id);
1979:

Line 1980: WF_ENGINE.SetItemAttrText(p_item_type,

1976: p_item_key,
1977: 'APPROVER_ID',
1978: p_user_id);
1979:
1980: WF_ENGINE.SetItemAttrText(p_item_type,
1981: p_item_key,
1982: 'APPROVER_USER_NAME',
1983: l_manager_name);
1984:

Line 1985: WF_ENGINE.SetItemAttrText(p_item_type,

1981: p_item_key,
1982: 'APPROVER_USER_NAME',
1983: l_manager_name);
1984:
1985: WF_ENGINE.SetItemAttrText(p_item_type,
1986: p_item_key,
1987: 'APPROVER_DISPLAY_NAME',
1988: l_manager_display_name);
1989:

Line 2087: l_escalation_count := WF_ENGINE.GetItemAttrNumber(

2083: -------------------------------------------------------
2084: l_debug_info := 'Trying to retrieve employee manager';
2085: -------------------------------------------------------
2086:
2087: l_escalation_count := WF_ENGINE.GetItemAttrNumber(
2088: p_item_type,
2089: p_item_key,
2090: 'ESCALATION_COUNT');
2091:

Line 2095: l_approver_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

2091:
2092: /* Bug 3195343 Changes l_employee_id to l_approver_id */
2093: IF l_escalation_count=0 THEN
2094:
2095: l_approver_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
2096: p_item_key,
2097: 'APPROVER_ID');
2098: ELSE
2099:

Line 2100: l_approver_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

2096: p_item_key,
2097: 'APPROVER_ID');
2098: ELSE
2099:
2100: l_approver_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
2101: p_item_key,
2102: 'MANAGER_ID');
2103:
2104: END IF;

Line 2125: WF_ENGINE.SetItemAttrNumber( p_item_type,

2121: p_result := 'COMPLETE:T';
2122:
2123: l_escalation_count := l_escalation_count + 1;
2124:
2125: WF_ENGINE.SetItemAttrNumber( p_item_type,
2126: p_item_key,
2127: 'ESCALATION_COUNT',
2128: l_escalation_count);
2129:

Line 2136: WF_ENGINE.SetItemAttrNumber(p_item_type,

2132: Open c2;
2133: Fetch c2 into l_manager_user_id ;
2134: Close c2;
2135:
2136: WF_ENGINE.SetItemAttrNumber(p_item_type,
2137: p_item_key,
2138: 'MANAGER_ID',
2139: l_manager_user_id);
2140:

Line 2146: WF_ENGINE.SetItemAttrText(p_item_type,

2142: to_char(l_manager_id),
2143: l_manager_user_name,
2144: l_manager_display_name);
2145:
2146: WF_ENGINE.SetItemAttrText(p_item_type,
2147: p_item_key,
2148: 'MANAGER_USER_NAME',
2149: l_manager_user_name);
2150:

Line 2151: WF_ENGINE.SetItemAttrText(p_item_type,

2147: p_item_key,
2148: 'MANAGER_USER_NAME',
2149: l_manager_user_name);
2150:
2151: WF_ENGINE.SetItemAttrText(p_item_type,
2152: p_item_key,
2153: 'MANAGER_DISPLAY_NAME',
2154: l_manager_display_name);
2155:

Line 2226: l_collector_employee_id := WF_ENGINE.GetItemAttrNumber(

2222: l_debug_mesg := 'Record collector as approver';
2223: ------------------------------------------------------------
2224:
2225:
2226: l_collector_employee_id := WF_ENGINE.GetItemAttrNumber(
2227: p_item_type,
2228: p_item_key,
2229: 'COLLECTOR_EMPLOYEE_ID');
2230:

Line 2236: WF_ENGINE.SetItemAttrNumber(p_item_type,

2232: Open c1;
2233: Fetch c1 into l_collector_user_id;
2234: Close c1;
2235:
2236: WF_ENGINE.SetItemAttrNumber(p_item_type,
2237: p_item_key,
2238: 'APPROVER_ID',
2239: l_collector_user_id);
2240:

Line 2241: l_collector_user_name := WF_ENGINE.GetItemAttrText(p_item_type,

2237: p_item_key,
2238: 'APPROVER_ID',
2239: l_collector_user_id);
2240:
2241: l_collector_user_name := WF_ENGINE.GetItemAttrText(p_item_type,
2242: p_item_key,
2243: 'COLLECTOR_USER_NAME');
2244: WF_ENGINE.SetItemAttrText(p_item_type,
2245: p_item_key,

Line 2244: WF_ENGINE.SetItemAttrText(p_item_type,

2240:
2241: l_collector_user_name := WF_ENGINE.GetItemAttrText(p_item_type,
2242: p_item_key,
2243: 'COLLECTOR_USER_NAME');
2244: WF_ENGINE.SetItemAttrText(p_item_type,
2245: p_item_key,
2246: 'APPROVER_USER_NAME',
2247: l_collector_user_name);
2248:

Line 2250: l_collector_display_name := WF_ENGINE.GetItemAttrText(p_item_type,

2246: 'APPROVER_USER_NAME',
2247: l_collector_user_name);
2248:
2249:
2250: l_collector_display_name := WF_ENGINE.GetItemAttrText(p_item_type,
2251: p_item_key,
2252: 'COLLECTOR_DISPLAY_NAME');
2253: WF_ENGINE.SetItemAttrText(p_item_type,
2254: p_item_key,

Line 2253: WF_ENGINE.SetItemAttrText(p_item_type,

2249:
2250: l_collector_display_name := WF_ENGINE.GetItemAttrText(p_item_type,
2251: p_item_key,
2252: 'COLLECTOR_DISPLAY_NAME');
2253: WF_ENGINE.SetItemAttrText(p_item_type,
2254: p_item_key,
2255: 'APPROVER_DISPLAY_NAME',
2256: l_collector_display_name);
2257:

Line 2330: l_collector_employee_id := WF_ENGINE.GetItemAttrNumber(

2326: l_debug_mesg := 'Get the user name of collector';
2327: ------------------------------------------------------------
2328:
2329:
2330: l_collector_employee_id := WF_ENGINE.GetItemAttrNumber(
2331: p_item_type,
2332: p_item_key,
2333: 'COLLECTOR_EMPLOYEE_ID');
2334: WF_ENGINE.SetItemAttrNumber(p_item_type,

Line 2334: WF_ENGINE.SetItemAttrNumber(p_item_type,

2330: l_collector_employee_id := WF_ENGINE.GetItemAttrNumber(
2331: p_item_type,
2332: p_item_key,
2333: 'COLLECTOR_EMPLOYEE_ID');
2334: WF_ENGINE.SetItemAttrNumber(p_item_type,
2335: p_item_key,
2336: 'FORWARD_FROM_ID',
2337: l_collector_employee_id);
2338:

Line 2343: l_collector_user_name := WF_ENGINE.GetItemAttrText(p_item_type,

2339:
2340:
2341:
2342:
2343: l_collector_user_name := WF_ENGINE.GetItemAttrText(p_item_type,
2344: p_item_key,
2345: 'COLLECTOR_USER_NAME');
2346: WF_ENGINE.SetItemAttrText(p_item_type,
2347: p_item_key,

Line 2346: WF_ENGINE.SetItemAttrText(p_item_type,

2342:
2343: l_collector_user_name := WF_ENGINE.GetItemAttrText(p_item_type,
2344: p_item_key,
2345: 'COLLECTOR_USER_NAME');
2346: WF_ENGINE.SetItemAttrText(p_item_type,
2347: p_item_key,
2348: 'FORWARD_FROM_USER_NAME',
2349: l_collector_user_name);
2350:

Line 2352: l_collector_display_name := WF_ENGINE.GetItemAttrText(p_item_type,

2348: 'FORWARD_FROM_USER_NAME',
2349: l_collector_user_name);
2350:
2351:
2352: l_collector_display_name := WF_ENGINE.GetItemAttrText(p_item_type,
2353: p_item_key,
2354: 'COLLECTOR_DISPLAY_NAME');
2355: WF_ENGINE.SetItemAttrText(p_item_type,
2356: p_item_key,

Line 2355: WF_ENGINE.SetItemAttrText(p_item_type,

2351:
2352: l_collector_display_name := WF_ENGINE.GetItemAttrText(p_item_type,
2353: p_item_key,
2354: 'COLLECTOR_DISPLAY_NAME');
2355: WF_ENGINE.SetItemAttrText(p_item_type,
2356: p_item_key,
2357: 'FORWARD_FROM_DISPLAY_NAME',
2358: l_collector_display_name);
2359:

Line 2364: l_approver_notes := WF_ENGINE.GetItemAttrText(p_item_type,

2360: -- Add the collector user name in front of notes field.
2361:
2362:
2363:
2364: l_approver_notes := WF_ENGINE.GetItemAttrText(p_item_type,
2365: p_item_key,
2366: 'APPROVER_NOTES');
2367:
2368: l_notes := l_collector_user_name ||

Line 2372: WF_ENGINE.SetItemAttrText(p_item_type,

2368: l_notes := l_collector_user_name ||
2369: ': ' || l_approver_notes || CRLF;
2370:
2371:
2372: WF_ENGINE.SetItemAttrText(p_item_type,
2373: p_item_key,
2374: 'NOTES',
2375: l_notes);
2376:

Line 2381: WF_ENGINE.SetItemAttrText(p_item_type,

2377: -- Initialize the approver_notes
2378:
2379: l_approver_notes := NULL;
2380:
2381: WF_ENGINE.SetItemAttrText(p_item_type,
2382: p_item_key,
2383: 'APPROVER_NOTES',
2384: l_approver_notes);
2385:

Line 2447: l_approver_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

2443: ------------------------------------------------------------
2444: l_debug_mesg := 'Get the user name of approver';
2445: ------------------------------------------------------------
2446:
2447: l_approver_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
2448: p_item_key,
2449: 'APPROVER_ID');
2450: WF_ENGINE.SetItemAttrNumber(p_item_type,
2451: p_item_key,

Line 2450: WF_ENGINE.SetItemAttrNumber(p_item_type,

2446:
2447: l_approver_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
2448: p_item_key,
2449: 'APPROVER_ID');
2450: WF_ENGINE.SetItemAttrNumber(p_item_type,
2451: p_item_key,
2452: 'FORWARD_TO_ID',
2453: l_approver_id);
2454:

Line 2457: l_approver_user_name := WF_ENGINE.GetItemAttrText(p_item_type,

2453: l_approver_id);
2454:
2455:
2456:
2457: l_approver_user_name := WF_ENGINE.GetItemAttrText(p_item_type,
2458: p_item_key,
2459: 'APPROVER_USER_NAME');
2460: WF_ENGINE.SetItemAttrText(p_item_type,
2461: p_item_key,

Line 2460: WF_ENGINE.SetItemAttrText(p_item_type,

2456:
2457: l_approver_user_name := WF_ENGINE.GetItemAttrText(p_item_type,
2458: p_item_key,
2459: 'APPROVER_USER_NAME');
2460: WF_ENGINE.SetItemAttrText(p_item_type,
2461: p_item_key,
2462: 'FORWARD_TO_USER_NAME',
2463: l_approver_user_name);
2464:

Line 2466: l_approver_display_name := WF_ENGINE.GetItemAttrText(p_item_type,

2462: 'FORWARD_TO_USER_NAME',
2463: l_approver_user_name);
2464:
2465:
2466: l_approver_display_name := WF_ENGINE.GetItemAttrText(p_item_type,
2467: p_item_key,
2468: 'APPROVER_DISPLAY_NAME');
2469: WF_ENGINE.SetItemAttrText(p_item_type,
2470: p_item_key,

Line 2469: WF_ENGINE.SetItemAttrText(p_item_type,

2465:
2466: l_approver_display_name := WF_ENGINE.GetItemAttrText(p_item_type,
2467: p_item_key,
2468: 'APPROVER_DISPLAY_NAME');
2469: WF_ENGINE.SetItemAttrText(p_item_type,
2470: p_item_key,
2471: 'FORWARD_TO_DISPLAY_NAME',
2472: l_approver_display_name);
2473:

Line 2536: l_forward_from_user_name := WF_ENGINE.GetItemAttrText(

2532: ------------------------------------------------------------
2533: l_debug_mesg := 'Get the user name of forward from user';
2534: ------------------------------------------------------------
2535:
2536: l_forward_from_user_name := WF_ENGINE.GetItemAttrText(
2537: p_item_type,
2538: p_item_key,
2539: 'FORWARD_FROM_USER_NAME');
2540:

Line 2614: l_approver_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

2610: ------------------------------------------------------------
2611:
2612:
2613:
2614: l_approver_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
2615: p_item_key,
2616: 'APPROVER_ID');
2617: WF_ENGINE.SetItemAttrNumber(p_item_type,
2618: p_item_key,

Line 2617: WF_ENGINE.SetItemAttrNumber(p_item_type,

2613:
2614: l_approver_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
2615: p_item_key,
2616: 'APPROVER_ID');
2617: WF_ENGINE.SetItemAttrNumber(p_item_type,
2618: p_item_key,
2619: 'FORWARD_FROM_ID',
2620: l_approver_id);
2621:

Line 2624: l_approver_user_name := WF_ENGINE.GetItemAttrText(p_item_type,

2620: l_approver_id);
2621:
2622:
2623:
2624: l_approver_user_name := WF_ENGINE.GetItemAttrText(p_item_type,
2625: p_item_key,
2626: 'APPROVER_USER_NAME');
2627: WF_ENGINE.SetItemAttrText(p_item_type,
2628: p_item_key,

Line 2627: WF_ENGINE.SetItemAttrText(p_item_type,

2623:
2624: l_approver_user_name := WF_ENGINE.GetItemAttrText(p_item_type,
2625: p_item_key,
2626: 'APPROVER_USER_NAME');
2627: WF_ENGINE.SetItemAttrText(p_item_type,
2628: p_item_key,
2629: 'FORWARD_FROM_USER_NAME',
2630: l_approver_user_name);
2631:

Line 2633: l_approver_display_name := WF_ENGINE.GetItemAttrText(p_item_type,

2629: 'FORWARD_FROM_USER_NAME',
2630: l_approver_user_name);
2631:
2632:
2633: l_approver_display_name := WF_ENGINE.GetItemAttrText(p_item_type,
2634: p_item_key,
2635: 'APPROVER_DISPLAY_NAME');
2636: WF_ENGINE.SetItemAttrText(p_item_type,
2637: p_item_key,

Line 2636: WF_ENGINE.SetItemAttrText(p_item_type,

2632:
2633: l_approver_display_name := WF_ENGINE.GetItemAttrText(p_item_type,
2634: p_item_key,
2635: 'APPROVER_DISPLAY_NAME');
2636: WF_ENGINE.SetItemAttrText(p_item_type,
2637: p_item_key,
2638: 'FORWARD_FROM_DISPLAY_NAME',
2639: l_approver_display_name);
2640:

Line 2643: l_notes := WF_ENGINE.GetItemAttrText(p_item_type,

2639: l_approver_display_name);
2640:
2641: -- Add the approver user name in front of notes field.
2642:
2643: l_notes := WF_ENGINE.GetItemAttrText(p_item_type,
2644: p_item_key,
2645: 'NOTES');
2646:
2647: l_approver_notes := WF_ENGINE.GetItemAttrText(p_item_type,

Line 2647: l_approver_notes := WF_ENGINE.GetItemAttrText(p_item_type,

2643: l_notes := WF_ENGINE.GetItemAttrText(p_item_type,
2644: p_item_key,
2645: 'NOTES');
2646:
2647: l_approver_notes := WF_ENGINE.GetItemAttrText(p_item_type,
2648: p_item_key,
2649: 'APPROVER_NOTES');
2650:
2651:

Line 2656: WF_ENGINE.SetItemAttrText(p_item_type,

2652: l_notes := l_notes || l_approver_user_name ||
2653: ': ' || l_approver_notes || CRLF;
2654:
2655:
2656: WF_ENGINE.SetItemAttrText(p_item_type,
2657: p_item_key,
2658: 'NOTES',
2659: l_notes);
2660:

Line 2665: WF_ENGINE.SetItemAttrText(p_item_type,

2661: -- Initialize the approver_notes
2662:
2663: l_approver_notes := NULL;
2664:
2665: WF_ENGINE.SetItemAttrText(p_item_type,
2666: p_item_key,
2667: 'APPROVER_NOTES',
2668: l_approver_notes);
2669:

Line 2732: l_reason_code := WF_ENGINE.GetItemAttrText(

2728: -- RUN mode - normal process execution
2729: --
2730: if (p_funcmode = 'RUN') then
2731:
2732: l_reason_code := WF_ENGINE.GetItemAttrText(
2733: p_item_type,
2734: p_item_key,
2735: 'REASON');
2736:

Line 2737: l_currency_code := WF_ENGINE.GetItemAttrText(

2733: p_item_type,
2734: p_item_key,
2735: 'REASON');
2736:
2737: l_currency_code := WF_ENGINE.GetItemAttrText(
2738: p_item_type,
2739: p_item_key,
2740: 'CURRENCY_CODE');
2741:

Line 2742: l_total_credit_to_invoice:= WF_ENGINE.GetItemAttrNumber(

2738: p_item_type,
2739: p_item_key,
2740: 'CURRENCY_CODE');
2741:
2742: l_total_credit_to_invoice:= WF_ENGINE.GetItemAttrNumber(
2743: p_item_type,
2744: p_item_key,
2745: 'TOTAL_CREDIT_TO_INVOICE');
2746:

Line 2749: l_approver_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

2745: 'TOTAL_CREDIT_TO_INVOICE');
2746:
2747:
2748:
2749: l_approver_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
2750: p_item_key,
2751: 'APPROVER_ID');
2752: /*
2753: CheckFinalApprover(l_reason_code,

Line 2889: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(

2885: -- RUN mode - normal process execution
2886: --
2887: if (p_funcmode = 'RUN') then
2888:
2889: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(
2890: p_item_type,
2891: p_item_key,
2892: 'CUSTOMER_TRX_ID');
2893:

Line 2894: l_request_id := WF_ENGINE.GetItemAttrNumber(

2890: p_item_type,
2891: p_item_key,
2892: 'CUSTOMER_TRX_ID');
2893:
2894: l_request_id := WF_ENGINE.GetItemAttrNumber(
2895: p_item_type,
2896: p_item_key,
2897: 'WORKFLOW_DOCUMENT_ID');
2898:

Line 2946: l_reason_code := WF_ENGINE.GetItemAttrText(

2942:
2943: END LOOP;
2944: END;
2945:
2946: l_reason_code := WF_ENGINE.GetItemAttrText(
2947: p_item_type,
2948: p_item_key,
2949: 'REASON');
2950:

Line 2951: l_currency_code := WF_ENGINE.GetItemAttrText(

2947: p_item_type,
2948: p_item_key,
2949: 'REASON');
2950:
2951: l_currency_code := WF_ENGINE.GetItemAttrText(
2952: p_item_type,
2953: p_item_key,
2954: 'CURRENCY_CODE');
2955:

Line 2957: := WF_ENGINE.GetItemAttrNumber(

2953: p_item_key,
2954: 'CURRENCY_CODE');
2955:
2956: l_total_credit_to_invoice
2957: := WF_ENGINE.GetItemAttrNumber(
2958: p_item_type,
2959: p_item_key,
2960: 'TOTAL_CREDIT_TO_INVOICE');
2961:

Line 2964: l_approver_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

2960: 'TOTAL_CREDIT_TO_INVOICE');
2961:
2962:
2963:
2964: l_approver_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
2965: p_item_key,
2966: 'APPROVER_ID');
2967:
2968: CheckFinalApprover(l_reason_code,

Line 3040: l_receivable_role := WF_ENGINE.GetItemAttrText(p_item_type,

3036: -----------------------------------------------------------------
3037: l_debug_mesg := 'Check if Receivable Approver has been defined';
3038: -----------------------------------------------------------------
3039:
3040: l_receivable_role := WF_ENGINE.GetItemAttrText(p_item_type,
3041: p_item_key,
3042: 'RECEIVABLE_ROLE');
3043:
3044: IF l_receivable_role IS NOT NULL THEN

Line 3050: WF_ENGINE.SetItemAttrText(p_item_type,

3046: SELECT display_name,orig_system_id INTO l_role_display_name, l_role_id
3047: FROM wf_roles
3048: WHERE name = l_receivable_role;
3049:
3050: WF_ENGINE.SetItemAttrText(p_item_type,
3051: p_item_key,
3052: 'APPROVER_USER_NAME',
3053: l_receivable_role);
3054:

Line 3055: WF_ENGINE.SetItemAttrText(p_item_type,

3051: p_item_key,
3052: 'APPROVER_USER_NAME',
3053: l_receivable_role);
3054:
3055: WF_ENGINE.SetItemAttrText(p_item_type,
3056: p_item_key,
3057: 'APPROVER_DISPLAY_NAME',
3058: l_role_display_name);
3059:

Line 3060: WF_ENGINE.SetItemAttrNumber(p_item_type,

3056: p_item_key,
3057: 'APPROVER_DISPLAY_NAME',
3058: l_role_display_name);
3059:
3060: WF_ENGINE.SetItemAttrNumber(p_item_type,
3061: p_item_key,
3062: 'APPROVER_ID',
3063: l_role_id);
3064:

Line 3134: l_notification_id := wf_engine.context_nid;

3130: l_debug_mesg := 'Find user in Receivable role who responded to
3131: the notification';
3132: -----------------------------------------------------------------
3133:
3134: l_notification_id := wf_engine.context_nid;
3135: l_approver_user_name := wf_engine.context_text;
3136:
3137: SELECT orig_system_id, display_name
3138: INTO l_approver_id, l_approver_display_name

Line 3135: l_approver_user_name := wf_engine.context_text;

3131: the notification';
3132: -----------------------------------------------------------------
3133:
3134: l_notification_id := wf_engine.context_nid;
3135: l_approver_user_name := wf_engine.context_text;
3136:
3137: SELECT orig_system_id, display_name
3138: INTO l_approver_id, l_approver_display_name
3139: FROM wf_users

Line 3143: WF_ENGINE.SetItemAttrText(p_item_type,

3139: FROM wf_users
3140: WHERE orig_system = 'PER'
3141: AND name = l_approver_user_name;
3142:
3143: WF_ENGINE.SetItemAttrText(p_item_type,
3144: p_item_key,
3145: 'APPROVER_ID',
3146: l_approver_id);
3147:

Line 3148: WF_ENGINE.SetItemAttrText(p_item_type,

3144: p_item_key,
3145: 'APPROVER_ID',
3146: l_approver_id);
3147:
3148: WF_ENGINE.SetItemAttrText(p_item_type,
3149: p_item_key,
3150: 'APPROVER_USER_NAME',
3151: l_approver_user_name);
3152:

Line 3153: WF_ENGINE.SetItemAttrText(p_item_type,

3149: p_item_key,
3150: 'APPROVER_USER_NAME',
3151: l_approver_user_name);
3152:
3153: WF_ENGINE.SetItemAttrText(p_item_type,
3154: p_item_key,
3155: 'APPROVER_DISPLAY_NAME',
3156: l_approver_display_name);
3157:

Line 3233: l_document_id := WF_ENGINE.GetItemAttrNumber(

3229: --
3230: if (p_funcmode = 'RUN') then
3231:
3232:
3233: l_document_id := WF_ENGINE.GetItemAttrNumber(
3234: p_item_type,
3235: p_item_key,
3236: 'WORKFLOW_DOCUMENT_ID');
3237:

Line 3239: := WF_ENGINE.GetItemAttrText(

3235: p_item_key,
3236: 'WORKFLOW_DOCUMENT_ID');
3237:
3238: l_requestor_user_name
3239: := WF_ENGINE.GetItemAttrText(
3240: p_item_type,
3241: p_item_key,
3242: 'REQUESTOR_USER_NAME');
3243:

Line 3245: l_reason_code := WF_ENGINE.GetItemAttrText(

3241: p_item_key,
3242: 'REQUESTOR_USER_NAME');
3243:
3244:
3245: l_reason_code := WF_ENGINE.GetItemAttrText(
3246: p_item_type,
3247: p_item_key,
3248: 'REASON');
3249:

Line 3252: := WF_ENGINE.GetItemAttrNumber(

3248: 'REASON');
3249:
3250:
3251: l_total_credit_to_invoice
3252: := WF_ENGINE.GetItemAttrNumber(
3253: p_item_type,
3254: p_item_key,
3255: 'TOTAL_CREDIT_TO_INVOICE');
3256:

Line 3258: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(

3254: p_item_key,
3255: 'TOTAL_CREDIT_TO_INVOICE');
3256:
3257:
3258: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(
3259: p_item_type,
3260: p_item_key,
3261: 'CUSTOMER_TRX_ID');
3262:

Line 3263: l_comments := WF_ENGINE.GetItemAttrText(

3259: p_item_type,
3260: p_item_key,
3261: 'CUSTOMER_TRX_ID');
3262:
3263: l_comments := WF_ENGINE.GetItemAttrText(
3264: p_item_type,
3265: p_item_key,
3266: 'COMMENTS');
3267: l_internal_comment := wf_engine.GetItemAttrText(

Line 3267: l_internal_comment := wf_engine.GetItemAttrText(

3263: l_comments := WF_ENGINE.GetItemAttrText(
3264: p_item_type,
3265: p_item_key,
3266: 'COMMENTS');
3267: l_internal_comment := wf_engine.GetItemAttrText(
3268: p_item_type,
3269: p_item_key,
3270: 'INTERNAL_COMMENTS');
3271:

Line 3386: l_document_id := WF_ENGINE.GetItemAttrNumber(

3382: --
3383: if (p_funcmode = 'RUN') then
3384:
3385:
3386: l_document_id := WF_ENGINE.GetItemAttrNumber(
3387: p_item_type,
3388: p_item_key,
3389: 'WORKFLOW_DOCUMENT_ID');
3390:

Line 3391: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(

3387: p_item_type,
3388: p_item_key,
3389: 'WORKFLOW_DOCUMENT_ID');
3390:
3391: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(
3392: p_item_type,
3393: p_item_key,
3394: 'CUSTOMER_TRX_ID');
3395:

Line 3397: := WF_ENGINE.GetItemAttrText(

3393: p_item_key,
3394: 'CUSTOMER_TRX_ID');
3395:
3396: l_approver_display_name
3397: := WF_ENGINE.GetItemAttrText(
3398: p_item_type,
3399: p_item_key,
3400: 'APPROVER_DISPLAY_NAME');
3401:

Line 3402: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /5119049/

3398: p_item_type,
3399: p_item_key,
3400: 'APPROVER_DISPLAY_NAME');
3401:
3402: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
3403:
3404: fnd_message.set_name('AR', 'AR_WF_APPROVAL_REMINDER');
3405: fnd_message.set_token('APPROVER', l_approver_display_name);
3406: -- bug fix 1122477

Line 3425: WF_ENGINE.SetItemAttrNumber( p_item_type,

3421:
3422: /* Bug 3195343 Initialise the escalation_count attribute for the
3423: Primary approver. */
3424:
3425: WF_ENGINE.SetItemAttrNumber( p_item_type,
3426: p_item_key,
3427: 'ESCALATION_COUNT',
3428: 0 ) ;
3429: p_result := 'COMPLETE:T';

Line 3491: l_document_id := WF_ENGINE.GetItemAttrNumber(

3487: --
3488: if (p_funcmode = 'RUN') then
3489:
3490:
3491: l_document_id := WF_ENGINE.GetItemAttrNumber(
3492: p_item_type,
3493: p_item_key,
3494: 'WORKFLOW_DOCUMENT_ID');
3495:

Line 3496: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(

3492: p_item_type,
3493: p_item_key,
3494: 'WORKFLOW_DOCUMENT_ID');
3495:
3496: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(
3497: p_item_type,
3498: p_item_key,
3499: 'CUSTOMER_TRX_ID');
3500:

Line 3502: := WF_ENGINE.GetItemAttrText(

3498: p_item_key,
3499: 'CUSTOMER_TRX_ID');
3500:
3501: l_manager_user_name
3502: := WF_ENGINE.GetItemAttrText(
3503: p_item_type,
3504: p_item_key,
3505: 'MANAGER_USER_NAME');
3506:

Line 3507: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /5119049/

3503: p_item_type,
3504: p_item_key,
3505: 'MANAGER_USER_NAME');
3506:
3507: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
3508:
3509: fnd_message.set_name('AR', 'AR_WF_APPROVAL_ESCALATION');
3510: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3511: fnd_message.set_token('APPROVER', l_manager_user_name);

Line 3591: l_document_id := WF_ENGINE.GetItemAttrNumber(

3587: --
3588: if (p_funcmode = 'RUN') then
3589:
3590:
3591: l_document_id := WF_ENGINE.GetItemAttrNumber(
3592: p_item_type,
3593: p_item_key,
3594: 'WORKFLOW_DOCUMENT_ID');
3595:

Line 3596: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(

3592: p_item_type,
3593: p_item_key,
3594: 'WORKFLOW_DOCUMENT_ID');
3595:
3596: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(
3597: p_item_type,
3598: p_item_key,
3599: 'CUSTOMER_TRX_ID');
3600:

Line 3602: := WF_ENGINE.GetItemAttrText(

3598: p_item_key,
3599: 'CUSTOMER_TRX_ID');
3600:
3601: l_receivable_role
3602: := WF_ENGINE.GetItemAttrText(
3603: p_item_type,
3604: p_item_key,
3605: 'RECEIVABLE_ROLE');
3606: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/

Line 3606: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /5119049/

3602: := WF_ENGINE.GetItemAttrText(
3603: p_item_type,
3604: p_item_key,
3605: 'RECEIVABLE_ROLE');
3606: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
3607: SELECT display_name INTO l_role_display_name
3608: FROM wf_roles
3609: WHERE name = l_receivable_role;
3610:

Line 3706: l_document_id := WF_ENGINE.GetItemAttrNumber(

3702: --
3703: if (p_funcmode = 'RUN') then
3704:
3705:
3706: l_document_id := WF_ENGINE.GetItemAttrNumber(
3707: p_item_type,
3708: p_item_key,
3709: 'WORKFLOW_DOCUMENT_ID');
3710:

Line 3711: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(

3707: p_item_type,
3708: p_item_key,
3709: 'WORKFLOW_DOCUMENT_ID');
3710:
3711: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(
3712: p_item_type,
3713: p_item_key,
3714: 'CUSTOMER_TRX_ID');
3715:

Line 3717: := WF_ENGINE.GetItemAttrText(

3713: p_item_key,
3714: 'CUSTOMER_TRX_ID');
3715:
3716: l_receivable_role
3717: := WF_ENGINE.GetItemAttrText(
3718: p_item_type,
3719: p_item_key,
3720: 'RECEIVABLE_ROLE');
3721: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/

Line 3721: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /5119049/

3717: := WF_ENGINE.GetItemAttrText(
3718: p_item_type,
3719: p_item_key,
3720: 'RECEIVABLE_ROLE');
3721: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
3722:
3723: SELECT display_name INTO l_role_display_name
3724: FROM wf_roles
3725: WHERE name = l_receivable_role;

Line 3818: l_document_id := WF_ENGINE.GetItemAttrNumber(

3814: --
3815: if (p_funcmode = 'RUN') then
3816:
3817:
3818: l_document_id := WF_ENGINE.GetItemAttrNumber(
3819: p_item_type,
3820: p_item_key,
3821: 'WORKFLOW_DOCUMENT_ID');
3822:

Line 3823: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(

3819: p_item_type,
3820: p_item_key,
3821: 'WORKFLOW_DOCUMENT_ID');
3822:
3823: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(
3824: p_item_type,
3825: p_item_key,
3826: 'CUSTOMER_TRX_ID');
3827:

Line 3829: := WF_ENGINE.GetItemAttrText(

3825: p_item_key,
3826: 'CUSTOMER_TRX_ID');
3827:
3828: l_approver_display_name
3829: := WF_ENGINE.GetItemAttrText(
3830: p_item_type,
3831: p_item_key,
3832: 'APPROVER_DISPLAY_NAME');
3833:

Line 3834: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /5119049/

3830: p_item_type,
3831: p_item_key,
3832: 'APPROVER_DISPLAY_NAME');
3833:
3834: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
3835:
3836: fnd_message.set_name('AR', 'AR_WF_REQUEST_APPROVAL');
3837: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3838: fnd_message.set_token('APPROVER', l_approver_display_name);

Line 3916: l_document_id := WF_ENGINE.GetItemAttrNumber(

3912: --
3913: if (p_funcmode = 'RUN') then
3914:
3915:
3916: l_document_id := WF_ENGINE.GetItemAttrNumber(
3917: p_item_type,
3918: p_item_key,
3919: 'WORKFLOW_DOCUMENT_ID');
3920:

Line 3921: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(

3917: p_item_type,
3918: p_item_key,
3919: 'WORKFLOW_DOCUMENT_ID');
3920:
3921: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(
3922: p_item_type,
3923: p_item_key,
3924: 'CUSTOMER_TRX_ID');
3925:

Line 3927: := WF_ENGINE.GetItemAttrText(

3923: p_item_key,
3924: 'CUSTOMER_TRX_ID');
3925:
3926: l_approver_display_name
3927: := WF_ENGINE.GetItemAttrText(
3928: p_item_type,
3929: p_item_key,
3930: 'APPROVER_DISPLAY_NAME');
3931:

Line 3932: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /5119049/

3928: p_item_type,
3929: p_item_key,
3930: 'APPROVER_DISPLAY_NAME');
3931:
3932: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
3933:
3934: fnd_message.set_name('AR', 'AR_WF_APPROVED_RESPONSE');
3935: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3936: fnd_message.set_token('APPROVER', l_approver_display_name);

Line 4029: l_document_id := WF_ENGINE.GetItemAttrNumber(

4025: --
4026: if (p_funcmode = 'RUN') then
4027:
4028:
4029: l_document_id := WF_ENGINE.GetItemAttrNumber(
4030: p_item_type,
4031: p_item_key,
4032: 'WORKFLOW_DOCUMENT_ID');
4033:

Line 4034: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(

4030: p_item_type,
4031: p_item_key,
4032: 'WORKFLOW_DOCUMENT_ID');
4033:
4034: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(
4035: p_item_type,
4036: p_item_key,
4037: 'CUSTOMER_TRX_ID');
4038:

Line 4040: := WF_ENGINE.GetItemAttrText(

4036: p_item_key,
4037: 'CUSTOMER_TRX_ID');
4038:
4039: l_approver_display_name
4040: := WF_ENGINE.GetItemAttrText(
4041: p_item_type,
4042: p_item_key,
4043: 'APPROVER_DISPLAY_NAME');
4044: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/

Line 4044: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /5119049/

4040: := WF_ENGINE.GetItemAttrText(
4041: p_item_type,
4042: p_item_key,
4043: 'APPROVER_DISPLAY_NAME');
4044: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4045:
4046:
4047: fnd_message.set_name('AR', 'AR_WF_REJECTED_RESPONSE');
4048: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));

Line 4140: l_document_id := WF_ENGINE.GetItemAttrNumber(

4136: --
4137: if (p_funcmode = 'RUN') then
4138:
4139:
4140: l_document_id := WF_ENGINE.GetItemAttrNumber(
4141: p_item_type,
4142: p_item_key,
4143: 'WORKFLOW_DOCUMENT_ID');
4144:

Line 4145: l_credit_memo_number := WF_ENGINE.GetItemAttrText(

4141: p_item_type,
4142: p_item_key,
4143: 'WORKFLOW_DOCUMENT_ID');
4144:
4145: l_credit_memo_number := WF_ENGINE.GetItemAttrText(
4146: p_item_type,
4147: p_item_key,
4148: 'CREDIT_MEMO_NUMBER');
4149:

Line 4150: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(

4146: p_item_type,
4147: p_item_key,
4148: 'CREDIT_MEMO_NUMBER');
4149:
4150: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(
4151: p_item_type,
4152: p_item_key,
4153: 'CUSTOMER_TRX_ID');
4154: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/

Line 4154: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /5119049/

4150: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(
4151: p_item_type,
4152: p_item_key,
4153: 'CUSTOMER_TRX_ID');
4154: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4155:
4156: /* Get trx number for CM and the insert into note text */
4157:
4158:

Line 4249: l_reason_code := WF_ENGINE.GetItemAttrText(

4245: -- RUN mode - normal process execution
4246: --
4247: if (p_funcmode = 'RUN') then
4248:
4249: l_reason_code := WF_ENGINE.GetItemAttrText(
4250: p_item_type,
4251: p_item_key,
4252: 'REASON');
4253:

Line 4254: l_currency_code := WF_ENGINE.GetItemAttrText(

4250: p_item_type,
4251: p_item_key,
4252: 'REASON');
4253:
4254: l_currency_code := WF_ENGINE.GetItemAttrText(
4255: p_item_type,
4256: p_item_key,
4257: 'CURRENCY_CODE');
4258:

Line 4260: := WF_ENGINE.GetItemAttrNumber(

4256: p_item_key,
4257: 'CURRENCY_CODE');
4258:
4259: l_entered_amount_display
4260: := WF_ENGINE.GetItemAttrNumber(
4261: p_item_type,
4262: p_item_key,
4263: 'ENTERED_AMOUNT_DISPLAY');
4264:

Line 4265: l_customer_id := WF_ENGINE.GetItemAttrNumber(

4261: p_item_type,
4262: p_item_key,
4263: 'ENTERED_AMOUNT_DISPLAY');
4264:
4265: l_customer_id := WF_ENGINE.GetItemAttrNumber(
4266: p_item_type,
4267: p_item_key,
4268: 'CUSTOMER_ID');
4269:

Line 4270: l_collector_id := WF_ENGINE.GetItemAttrNumber(

4266: p_item_type,
4267: p_item_key,
4268: 'CUSTOMER_ID');
4269:
4270: l_collector_id := WF_ENGINE.GetItemAttrNumber(
4271: p_item_type,
4272: p_item_key,
4273: 'COLLECTOR_ID');
4274:

Line 4276: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(

4272: p_item_key,
4273: 'COLLECTOR_ID');
4274:
4275:
4276: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(
4277: p_item_type,
4278: p_item_key,
4279: 'CUSTOMER_TRX_ID');
4280:

Line 4281: l_bill_to_site_use_id := WF_ENGINE.GetItemAttrNumber(

4277: p_item_type,
4278: p_item_key,
4279: 'CUSTOMER_TRX_ID');
4280:
4281: l_bill_to_site_use_id := WF_ENGINE.GetItemAttrNumber(
4282: p_item_type,
4283: p_item_key,
4284: 'BILL_TO_SITE_USE_ID');
4285:

Line 4437: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(

4433: if (p_funcmode = 'RUN') then
4434:
4435: -- call transaction API here
4436:
4437: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(
4438: p_item_type,
4439: p_item_key,
4440: 'CUSTOMER_TRX_ID');
4441:

Line 4442: l_amount := WF_ENGINE.GetItemAttrNumber(

4438: p_item_type,
4439: p_item_key,
4440: 'CUSTOMER_TRX_ID');
4441:
4442: l_amount := WF_ENGINE.GetItemAttrNumber(
4443: p_item_type,
4444: p_item_key,
4445: 'ORIGINAL_TOTAL');
4446:

Line 4447: l_request_id := WF_ENGINE.GetItemAttrNumber(

4443: p_item_type,
4444: p_item_key,
4445: 'ORIGINAL_TOTAL');
4446:
4447: l_request_id := WF_ENGINE.GetItemAttrNumber(
4448: p_item_type,
4449: p_item_key,
4450: 'WORKFLOW_DOCUMENT_ID');
4451:

Line 4452: l_batch_source_name := WF_ENGINE.GetItemAttrText(

4448: p_item_type,
4449: p_item_key,
4450: 'WORKFLOW_DOCUMENT_ID');
4451:
4452: l_batch_source_name := WF_ENGINE.GetItemAttrText(
4453: p_item_type,
4454: p_item_key,
4455: 'BATCH_SOURCE_NAME');
4456:

Line 4458: l_credit_method_installments := WF_ENGINE.GetItemAttrText(

4454: p_item_key,
4455: 'BATCH_SOURCE_NAME');
4456:
4457:
4458: l_credit_method_installments := WF_ENGINE.GetItemAttrText(
4459: p_item_type,
4460: p_item_key,
4461: 'CREDIT_INSTALLMENT_RULE');
4462:

Line 4463: l_credit_method_rules := WF_ENGINE.GetItemAttrText(

4459: p_item_type,
4460: p_item_key,
4461: 'CREDIT_INSTALLMENT_RULE');
4462:
4463: l_credit_method_rules := WF_ENGINE.GetItemAttrText(
4464: p_item_type,
4465: p_item_key,
4466: 'CREDIT_ACCOUNTING_RULE');
4467:

Line 4475: WF_ENGINE.SetItemAttrText(p_item_type,

4471:
4472: fnd_message.set_name('AR', 'AR_WF_NO_BATCH');
4473: l_cm_creation_error := fnd_message.get;
4474:
4475: WF_ENGINE.SetItemAttrText(p_item_type,
4476: p_item_key,
4477: 'CM_CREATION_ERROR',
4478: l_cm_creation_error);
4479:

Line 4516: WF_ENGINE.SetItemAttrText(p_item_type,

4512: exception
4513: when others then
4514: p_result := 'COMPLETE:F';
4515: l_cm_creation_error := 'Could not find the request';
4516: WF_ENGINE.SetItemAttrText(p_item_type,
4517: p_item_key,
4518: 'CM_CREATION_ERROR',
4519: l_cm_creation_error);
4520: return;

Line 4546: WF_ENGINE.SetItemAttrText(p_item_type,

4542: into l_credit_memo_number
4543: from ra_customer_trx
4544: where customer_trx_id = l_credit_memo_id;
4545:
4546: WF_ENGINE.SetItemAttrText(p_item_type,
4547: p_item_key,
4548: 'CREDIT_MEMO_NUMBER',
4549: l_credit_memo_number);
4550:

Line 4556: WF_ENGINE.SetItemAttrText(p_item_type,

4552: exception
4553: when others then
4554: p_result := 'COMPLETE:F';
4555: l_cm_creation_error := 'Could not find the credit memo';
4556: WF_ENGINE.SetItemAttrText(p_item_type,
4557: p_item_key,
4558: 'CM_CREATION_ERROR',
4559: l_cm_creation_error);
4560: return;

Line 4568: WF_ENGINE.SetItemAttrText(p_item_type,

4564: FOR i IN 1..l_error_tab.COUNT LOOP
4565: l_cm_creation_error := l_cm_creation_error || l_error_tab(i).translated_message || CRLF;
4566: END LOOP;
4567:
4568: WF_ENGINE.SetItemAttrText(p_item_type,
4569: p_item_key,
4570: 'CM_CREATION_ERROR',
4571: l_cm_creation_error);
4572:

Line 4650: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(

4646: ------------------------------------------------------------
4647: l_debug_mesg := 'Get the user value of rules';
4648: ------------------------------------------------------------
4649:
4650: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(
4651: p_item_type,
4652: p_item_key,
4653: 'CUSTOMER_TRX_ID');
4654:

Line 4656: l_credit_installment_rule := WF_ENGINE.GetItemAttrText(

4652: p_item_key,
4653: 'CUSTOMER_TRX_ID');
4654:
4655:
4656: l_credit_installment_rule := WF_ENGINE.GetItemAttrText(
4657: p_item_type,
4658: p_item_key,
4659: 'CREDIT_INSTALLMENT_RULE');
4660:

Line 4661: l_credit_accounting_rule := WF_ENGINE.GetItemAttrText(

4657: p_item_type,
4658: p_item_key,
4659: 'CREDIT_INSTALLMENT_RULE');
4660:
4661: l_credit_accounting_rule := WF_ENGINE.GetItemAttrText(
4662: p_item_type,
4663: p_item_key,
4664: 'CREDIT_ACCOUNTING_RULE');
4665:

Line 4666: l_invalid_rule_value := WF_ENGINE.GetItemAttrText(

4662: p_item_type,
4663: p_item_key,
4664: 'CREDIT_ACCOUNTING_RULE');
4665:
4666: l_invalid_rule_value := WF_ENGINE.GetItemAttrText(
4667: p_item_type,
4668: p_item_key,
4669: 'INVALID_RULE_VALUE');
4670:

Line 4671: l_invalid_rule_mesg := WF_ENGINE.GetItemAttrText(

4667: p_item_type,
4668: p_item_key,
4669: 'INVALID_RULE_VALUE');
4670:
4671: l_invalid_rule_mesg := WF_ENGINE.GetItemAttrText(
4672: p_item_type,
4673: p_item_key,
4674: 'INVALID_RULE_MESG');
4675:

Line 4689: WF_ENGINE.SetItemAttrText(p_item_type,

4685: if l_count > 1 then
4686:
4687: if l_credit_installment_rule not in ('LIFO', 'FIFO', 'PRORATE') then
4688: -- invalid credit method
4689: WF_ENGINE.SetItemAttrText(p_item_type,
4690: p_item_key,
4691: 'INVALID_RULE_MESG',
4692: l_invalid_rule_value);
4693: p_result := 'COMPLETE:F';

Line 4706: WF_ENGINE.SetItemAttrText(p_item_type,

4702: if l_invoicing_rule_id is not NULL then
4703:
4704: if l_credit_accounting_rule not in ('LIFO', 'PRORATE','UNIT') then
4705: -- invalid credit method
4706: WF_ENGINE.SetItemAttrText(p_item_type,
4707: p_item_key,
4708: 'INVALID_RULE_MESG',
4709: l_invalid_rule_value);
4710: p_result := 'COMPLETE:F';

Line 4718: WF_ENGINE.SetItemAttrText(p_item_type,

4714:
4715: -- the credit methods are valid
4716: if l_invalid_rule_mesg is not NULL then
4717: l_invalid_rule_mesg := NULL;
4718: WF_ENGINE.SetItemAttrText(p_item_type,
4719: p_item_key,
4720: 'INVALID_RULE_MESG',
4721: l_invalid_rule_mesg);
4722: end if;