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 207: WF_ENGINE.SetItemAttrNumber(p_item_type,

203:
204:
205: if l_customer_trx_id <> -1 then
206:
207: WF_ENGINE.SetItemAttrNumber(p_item_type,
208: p_item_key,
209: 'WORKFLOW_DOCUMENT_ID',
210: l_workflow_document_id);
211:

Line 213: WF_ENGINE.SetItemAttrNumber(p_item_type,

209: 'WORKFLOW_DOCUMENT_ID',
210: l_workflow_document_id);
211:
212:
213: WF_ENGINE.SetItemAttrNumber(p_item_type,
214: p_item_key,
215: 'CUSTOMER_TRX_ID',
216: l_customer_trx_id);
217:

Line 218: WF_ENGINE.SetItemAttrNumber(p_item_type,

214: p_item_key,
215: 'CUSTOMER_TRX_ID',
216: l_customer_trx_id);
217:
218: WF_ENGINE.SetItemAttrNumber(p_item_type,
219: p_item_key,
220: 'TOTAL_CREDIT_TO_INVOICE',
221: l_amount);
222:

Line 223: WF_ENGINE.SetItemAttrNumber(p_item_type,

219: p_item_key,
220: 'TOTAL_CREDIT_TO_INVOICE',
221: l_amount);
222:
223: WF_ENGINE.SetItemAttrNumber(p_item_type,
224: p_item_key,
225: 'TOTAL_CREDIT_TO_LINES',
226: l_line_amount);
227:

Line 228: WF_ENGINE.SetItemAttrNumber(p_item_type,

224: p_item_key,
225: 'TOTAL_CREDIT_TO_LINES',
226: l_line_amount);
227:
228: WF_ENGINE.SetItemAttrNumber(p_item_type,
229: p_item_key,
230: 'TOTAL_CREDIT_TO_TAX',
231: l_tax_amount);
232:

Line 233: WF_ENGINE.SetItemAttrNumber(p_item_type,

229: p_item_key,
230: 'TOTAL_CREDIT_TO_TAX',
231: l_tax_amount);
232:
233: WF_ENGINE.SetItemAttrNumber(p_item_type,
234: p_item_key,
235: 'TOTAL_CREDIT_TO_FREIGHT',
236: l_freight_amount);
237:

Line 238: WF_ENGINE.SetItemAttrText(p_item_type,

234: p_item_key,
235: 'TOTAL_CREDIT_TO_FREIGHT',
236: l_freight_amount);
237:
238: WF_ENGINE.SetItemAttrText(p_item_type,
239: p_item_key,
240: 'REASON',
241: l_reason_code);
242:

Line 243: WF_ENGINE.SetItemAttrText(p_item_type,

239: p_item_key,
240: 'REASON',
241: l_reason_code);
242:
243: WF_ENGINE.SetItemAttrText(p_item_type,
244: p_item_key,
245: 'REASON_MEANING',
246: l_reason_meaning);
247:

Line 248: WF_ENGINE.SetItemAttrText(p_item_type,

244: p_item_key,
245: 'REASON_MEANING',
246: l_reason_meaning);
247:
248: WF_ENGINE.SetItemAttrText(p_item_type,
249: p_item_key,
250: 'COMMENTS',
251: l_comments);
252:

Line 254: WF_ENGINE.SetItemAttrNumber(p_item_type,

250: 'COMMENTS',
251: l_comments);
252:
253:
254: WF_ENGINE.SetItemAttrNumber(p_item_type,
255: p_item_key,
256: 'REQUESTOR_ID',
257: l_requestor_id);
258:

Line 259: WF_ENGINE.SetItemAttrText(p_item_type,

255: p_item_key,
256: 'REQUESTOR_ID',
257: l_requestor_id);
258:
259: WF_ENGINE.SetItemAttrText(p_item_type,
260: p_item_key,
261: 'ORIG_TRX_NUMBER',
262: l_orig_trx_number);
263:

Line 264: WF_ENGINE.SetItemAttrText(p_item_type,

260: p_item_key,
261: 'ORIG_TRX_NUMBER',
262: l_orig_trx_number);
263:
264: WF_ENGINE.SetItemAttrText(p_item_type,
265: p_item_key,
266: 'TAX_EX_CERT_NUM',
267: l_tax_ex_cert_num);
268: /*7367350 set attribute*/

Line 269: wf_engine.SetItemAttrText(p_item_type,

265: p_item_key,
266: 'TAX_EX_CERT_NUM',
267: l_tax_ex_cert_num);
268: /*7367350 set attribute*/
269: wf_engine.SetItemAttrText(p_item_type,
270: p_item_key,
271: 'INTERNAL_COMMENTS',
272: l_internal_comment);
273:

Line 324: WF_ENGINE.SetItemAttrText(p_item_type,

320: end if;
321: end if;*/
322:
323:
324: WF_ENGINE.SetItemAttrText(p_item_type,
325: p_item_key,
326: 'REQUESTOR_USER_NAME',
327: l_requestor_user_name);
328:

Line 329: WF_ENGINE.SetItemAttrText(p_item_type,

325: p_item_key,
326: 'REQUESTOR_USER_NAME',
327: l_requestor_user_name);
328:
329: WF_ENGINE.SetItemAttrText(p_item_type,
330: p_item_key,
331: 'REQUESTOR_DISPLAY_NAME',
332: l_requestor_display_name);
333:

Line 345: WF_ENGINE.SetItemAttrNumber(p_item_type,

341: l_original_freight_amount,
342: l_original_total ,
343: l_currency_code);
344:
345: WF_ENGINE.SetItemAttrNumber(p_item_type,
346: p_item_key,
347: 'ORIGINAL_LINE_AMOUNT',
348: l_original_line_amount);
349:

Line 350: WF_ENGINE.SetItemAttrNumber(p_item_type,

346: p_item_key,
347: 'ORIGINAL_LINE_AMOUNT',
348: l_original_line_amount);
349:
350: WF_ENGINE.SetItemAttrNumber(p_item_type,
351: p_item_key,
352: 'ORIGINAL_TAX_AMOUNT',
353: l_original_tax_amount);
354:

Line 356: WF_ENGINE.SetItemAttrNumber(p_item_type,

352: 'ORIGINAL_TAX_AMOUNT',
353: l_original_tax_amount);
354:
355:
356: WF_ENGINE.SetItemAttrNumber(p_item_type,
357: p_item_key,
358: 'ORIGINAL_FREIGHT_AMOUNT',
359: l_original_freight_amount);
360:

Line 361: WF_ENGINE.SetItemAttrNumber(p_item_type,

357: p_item_key,
358: 'ORIGINAL_FREIGHT_AMOUNT',
359: l_original_freight_amount);
360:
361: WF_ENGINE.SetItemAttrNumber(p_item_type,
362: p_item_key,
363: 'ORIGINAL_TOTAL',
364: l_original_total);
365:

Line 366: WF_ENGINE.SetItemAttrText(p_item_type,

362: p_item_key,
363: 'ORIGINAL_TOTAL',
364: l_original_total);
365:
366: WF_ENGINE.SetItemAttrText(p_item_type,
367: p_item_key,
368: 'CURRENCY_CODE',
369: l_currency_code);
370: p_result := 'COMPLETE:T';

Line 519: WF_ENGINE.SetItemAttrText(p_item_type,

515: fnd_message.set_name('AR', 'ARW_INV_MSG10');
516: l_tax_disclaimer := fnd_message.get;
517: end if;
518:
519: WF_ENGINE.SetItemAttrText(p_item_type,
520: p_item_key,
521: 'TAX_DISCLAIMER',
522: l_tax_disclaimer);
523:

Line 620: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(

616:
617: ------------------------------------------------------------
618: l_debug_mesg := 'Get requested trx id ';
619: ------------------------------------------------------------
620: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(
621: p_item_type,
622: p_item_key,
623: 'CUSTOMER_TRX_ID');
624:

Line 657: WF_ENGINE.SetItemAttrNumber(p_item_type,

653: ----------------------------------------------------------------------
654: l_debug_mesg := 'Set value for customer_id(name) in workflow process';
655: -----------------------------------------------------------------------
656:
657: WF_ENGINE.SetItemAttrNumber(p_item_type,
658: p_item_key,
659: 'CUSTOMER_ID',
660: l_customer_id);
661:

Line 663: WF_ENGINE.SetItemAttrText(p_item_type,

659: 'CUSTOMER_ID',
660: l_customer_id);
661:
662:
663: WF_ENGINE.SetItemAttrText(p_item_type,
664: p_item_key,
665: 'CUSTOMER_NAME',
666: l_bill_to_customer_name);
667:

Line 670: WF_ENGINE.SetItemAttrText(p_item_type,

666: l_bill_to_customer_name);
667:
668: -- set the bill to and ship to customer info.
669:
670: WF_ENGINE.SetItemAttrText(p_item_type,
671: p_item_key,
672: 'BILL_TO_CUSTOMER_NAME',
673: l_bill_to_customer_name);
674:

Line 677: WF_ENGINE fom SetItemAttrNumber to SetItemAttrText

673: l_bill_to_customer_name);
674:
675: /* Bug Fix 1882580. Since l_bill_to_customer_number is changed
676: from number to varchar2, replaced the function in call to
677: WF_ENGINE fom SetItemAttrNumber to SetItemAttrText
678: */
679:
680: WF_ENGINE.SetItemAttrText(p_item_type,
681: p_item_key,

Line 680: WF_ENGINE.SetItemAttrText(p_item_type,

676: from number to varchar2, replaced the function in call to
677: WF_ENGINE fom SetItemAttrNumber to SetItemAttrText
678: */
679:
680: WF_ENGINE.SetItemAttrText(p_item_type,
681: p_item_key,
682: 'BILL_TO_CUSTOMER_NUMBER',
683: l_bill_to_customer_number);
684:

Line 685: WF_ENGINE.SetItemAttrText(p_item_type,

681: p_item_key,
682: 'BILL_TO_CUSTOMER_NUMBER',
683: l_bill_to_customer_number);
684:
685: WF_ENGINE.SetItemAttrText(p_item_type,
686: p_item_key,
687: 'SHIP_TO_CUSTOMER_NAME',
688: l_ship_to_customer_name);
689:

Line 692: WF_ENGINE fom SetItemAttrNumber to SetItemAttrText

688: l_ship_to_customer_name);
689:
690: /* Bug Fix 1882580. Since l_bill_to_customer_number is changed
691: from number to varchar2, replaced the function in call to
692: WF_ENGINE fom SetItemAttrNumber to SetItemAttrText
693: */
694: WF_ENGINE.SetItemAttrText(p_item_type,
695: p_item_key,
696: 'SHIP_TO_CUSTOMER_NUMBER',

Line 694: WF_ENGINE.SetItemAttrText(p_item_type,

690: /* Bug Fix 1882580. Since l_bill_to_customer_number is changed
691: from number to varchar2, replaced the function in call to
692: WF_ENGINE fom SetItemAttrNumber to SetItemAttrText
693: */
694: WF_ENGINE.SetItemAttrText(p_item_type,
695: p_item_key,
696: 'SHIP_TO_CUSTOMER_NUMBER',
697: l_ship_to_customer_number);
698:

Line 701: WF_ENGINE.SetItemAttrText(p_item_type,

697: l_ship_to_customer_number);
698:
699: -- set the trx number
700:
701: WF_ENGINE.SetItemAttrText(p_item_type,
702: p_item_key,
703: 'TRX_NUMBER',
704: l_trx_number);
705:

Line 711: WF_ENGINE.SetItemAttrNumber(p_item_type,

707:
708: ----------------------------------------------------------------------
709: l_debug_mesg := 'Set value for bill_to_site_use_id in workflow process';
710: -----------------------------------------------------------------------
711: WF_ENGINE.SetItemAttrNumber(p_item_type,
712: p_item_key,
713: 'BILL_TO_SITE_USE_ID',
714: l_bill_to_site_use_id);
715:

Line 720: l_request_id := WF_ENGINE.GetItemAttrNumber(

716:
717:
718: -- set the URL site
719:
720: l_request_id := WF_ENGINE.GetItemAttrNumber(
721: p_item_type,
722: p_item_key,
723: 'WORKFLOW_DOCUMENT_ID');
724:

Line 733: WF_ENGINE.SetItemAttrText(p_item_type,

729:
730: l_request_url := l_url;
731:
732:
733: WF_ENGINE.SetItemAttrText(p_item_type,
734: p_item_key,
735: 'REQUEST_URL',
736: l_request_url);
737:

Line 747: WF_ENGINE.SetItemAttrText(p_item_type,

743: from ra_cm_requests
744: where request_id = p_item_key;
745:
746:
747: WF_ENGINE.SetItemAttrText(p_item_type,
748: p_item_key,
749: 'TRANSACTION_NUMBER_URL',
750: l_trans_url);
751:

Line 759: WF_ENGINE.SetItemAttrText(p_item_type,

755: from ra_cm_requests
756: where request_id =p_item_key;
757:
758:
759: WF_ENGINE.SetItemAttrText(p_item_type,
760: p_item_key,
761: 'TRANSACTION_ACTIVITY_URL',
762: l_act_url);
763:

Line 908: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(

904:
905: -----------------------------------------------------------------
906: l_debug_mesg := 'Get the value of customer_trx_id(customer id)';
907: -----------------------------------------------------------------
908: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(
909: p_item_type,
910: p_item_key,
911: 'CUSTOMER_TRX_ID');
912:

Line 914: l_customer_id := WF_ENGINE.GetItemAttrNumber(

910: p_item_key,
911: 'CUSTOMER_TRX_ID');
912:
913:
914: l_customer_id := WF_ENGINE.GetItemAttrNumber(
915: p_item_type,
916: p_item_key,
917: 'CUSTOMER_ID');
918:

Line 923: l_bill_to_site_use_id := WF_ENGINE.GetItemAttrNumber(

919:
920: ----------------------------------------------------------------------
921: l_debug_mesg := 'get value of bill_to_site_use_id from workflow process';
922: -----------------------------------------------------------------------
923: l_bill_to_site_use_id := WF_ENGINE.GetItemAttrNumber(
924: p_item_type,
925: p_item_key,
926: 'BILL_TO_SITE_USE_ID');
927:

Line 948: WF_ENGINE.SetItemAttrNumber(p_item_type,

944: ----------------------------------------------------------------
945: l_debug_mesg := 'Set value for collector in workflow process';
946: ----------------------------------------------------------------
947:
948: WF_ENGINE.SetItemAttrNumber(p_item_type,
949: p_item_key,
950: 'COLLECTOR_EMPLOYEE_ID',
951: l_collector_employee_id);
952:

Line 953: WF_ENGINE.SetItemAttrNumber(p_item_type,

949: p_item_key,
950: 'COLLECTOR_EMPLOYEE_ID',
951: l_collector_employee_id);
952:
953: WF_ENGINE.SetItemAttrNumber(p_item_type,
954: p_item_key,
955: 'COLLECTOR_ID',
956: l_collector_id);
957:

Line 958: WF_ENGINE.SetItemAttrText(p_item_type,

954: p_item_key,
955: 'COLLECTOR_ID',
956: l_collector_id);
957:
958: WF_ENGINE.SetItemAttrText(p_item_type,
959: p_item_key,
960: 'COLLECTOR_NAME',
961: l_collector_name);
962:

Line 979: WF_ENGINE.SetItemAttrText(p_item_type,

975: -----------------------------------------------------------------
976: p_result := 'COMPLETE:F';
977: return;
978: else
979: WF_ENGINE.SetItemAttrText(p_item_type,
980: p_item_key,
981: 'COLLECTOR_USER_NAME',
982: l_collector_user_name);
983:

Line 984: WF_ENGINE.SetItemAttrText(p_item_type,

980: p_item_key,
981: 'COLLECTOR_USER_NAME',
982: l_collector_user_name);
983:
984: WF_ENGINE.SetItemAttrText(p_item_type,
985: p_item_key,
986: 'COLLECTOR_DISPLAY_NAME',
987: l_collector_display_name);
988: end if;

Line 1129: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(

1125: ------------------------------------------------------------
1126:
1127: /* Bug 991922 : get additional information to determine if rule is required */
1128:
1129: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(
1130: p_item_type,
1131: p_item_key,
1132: 'CUSTOMER_TRX_ID');
1133:

Line 1134: l_credit_accounting_rule := WF_ENGINE.GetItemAttrText(

1130: p_item_type,
1131: p_item_key,
1132: 'CUSTOMER_TRX_ID');
1133:
1134: l_credit_accounting_rule := WF_ENGINE.GetItemAttrText(
1135: p_item_type,
1136: p_item_key,
1137: 'CREDIT_ACCOUNTING_RULE');
1138:

Line 1139: l_reason_code := WF_ENGINE.GetItemAttrText(

1135: p_item_type,
1136: p_item_key,
1137: 'CREDIT_ACCOUNTING_RULE');
1138:
1139: l_reason_code := WF_ENGINE.GetItemAttrText(
1140: p_item_type,
1141: p_item_key,
1142: 'REASON');
1143:

Line 1144: l_currency_code := WF_ENGINE.GetItemAttrText(

1140: p_item_type,
1141: p_item_key,
1142: 'REASON');
1143:
1144: l_currency_code := WF_ENGINE.GetItemAttrText(
1145: p_item_type,
1146: p_item_key,
1147: 'CURRENCY_CODE');
1148:

Line 1160: WF_ENGINE.SetItemAttrText(p_item_type,

1156: -----------------------------------------
1157: l_debug_mesg := 'No first approver found';
1158: ------------------------------------------
1159:
1160: WF_ENGINE.SetItemAttrText(p_item_type,
1161: p_item_key,
1162: 'ROLE',
1163: '');
1164:

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

1172: p_item_type,
1173: p_item_key,
1174: 'Y');
1175:
1176: l_approver_user_name := WF_ENGINE.GetItemAttrText(p_item_type,
1177: p_item_key,
1178: 'APPROVER_USER_NAME');
1179: IF l_approver_user_name IS NULL THEN
1180: p_result := 'COMPLETE:F';

Line 1184: WF_ENGINE.SetItemAttrText(p_item_type,

1180: p_result := 'COMPLETE:F';
1181: return;
1182: ELSE
1183:
1184: WF_ENGINE.SetItemAttrText(p_item_type,
1185: p_item_key,
1186: 'ROLE',
1187: l_approver_user_name);
1188:

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

1186: 'ROLE',
1187: l_approver_user_name);
1188:
1189:
1190: l_collector_user_name := WF_ENGINE.GetItemAttrText(p_item_type,
1191: p_item_key,
1192: 'COLLECTOR_USER_NAME');
1193:
1194: WF_ENGINE.SetItemAttrText(p_item_type,

Line 1194: WF_ENGINE.SetItemAttrText(p_item_type,

1190: l_collector_user_name := WF_ENGINE.GetItemAttrText(p_item_type,
1191: p_item_key,
1192: 'COLLECTOR_USER_NAME');
1193:
1194: WF_ENGINE.SetItemAttrText(p_item_type,
1195: p_item_key,
1196: 'APPROVER_USER_NAME',
1197: l_collector_user_name);
1198:

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

1198:
1199: -- Bug 1331562 : set approver_display_name to collector's name, so that details
1200: -- inserted into Notes are accurate
1201:
1202: l_collector_display_name := WF_ENGINE.GetItemAttrText(p_item_type,
1203: p_item_key,
1204: 'COLLECTOR_DISPLAY_NAME');
1205: WF_ENGINE.SetItemAttrText(p_item_type,
1206: p_item_key,

Line 1205: WF_ENGINE.SetItemAttrText(p_item_type,

1201:
1202: l_collector_display_name := WF_ENGINE.GetItemAttrText(p_item_type,
1203: p_item_key,
1204: 'COLLECTOR_DISPLAY_NAME');
1205: WF_ENGINE.SetItemAttrText(p_item_type,
1206: p_item_key,
1207: 'APPROVER_DISPLAY_NAME',
1208: l_collector_display_name);
1209:

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

1209:
1210: /* Bug 3195343 Getting the collector_employee_id , from which the
1211: user_id is obtained .Set this user_id as the APPROVER_ID. */
1212:
1213: l_collector_employee_id := WF_ENGINE.GetItemAttrText(p_item_type,
1214: p_item_key,
1215: 'COLLECTOR_EMPLOYEE_ID');
1216: Open c1;
1217: Fetch c1 into l_collector_user_id ;

Line 1220: WF_ENGINE.SetItemAttrText(p_item_type,

1216: Open c1;
1217: Fetch c1 into l_collector_user_id ;
1218: Close c1;
1219:
1220: WF_ENGINE.SetItemAttrText(p_item_type,
1221: p_item_key,
1222: 'APPROVER_ID',
1223: l_collector_user_id);
1224:

Line 1239: WF_ENGINE.SetItemAttrText(p_item_type,

1235:
1236: fnd_message.set_name('AR', 'ARW_NEED_RULE');
1237: l_need_rule_mesg := fnd_message.get;
1238:
1239: WF_ENGINE.SetItemAttrText(p_item_type,
1240: p_item_key,
1241: 'INVALID_RULE_MESG',
1242: l_need_rule_mesg);
1243: end if;

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

1307: ------------------------------------------------------------
1308: l_debug_mesg := 'Get the user name of selected role';
1309: ------------------------------------------------------------
1310:
1311: l_approver_name := WF_ENGINE.GetItemAttrText(p_item_type,
1312: p_item_key,
1313: 'ROLE');
1314:
1315: IF l_approver_name IS NULL THEN

Line 1320: l_reason_code := WF_ENGINE.GetItemAttrText(

1316: p_result := 'COMPLETE:N';
1317: RETURN;
1318: END IF;
1319:
1320: l_reason_code := WF_ENGINE.GetItemAttrText(
1321: p_item_type,
1322: p_item_key,
1323: 'REASON');
1324:

Line 1325: l_currency_code := WF_ENGINE.GetItemAttrText(

1321: p_item_type,
1322: p_item_key,
1323: 'REASON');
1324:
1325: l_currency_code := WF_ENGINE.GetItemAttrText(
1326: p_item_type,
1327: p_item_key,
1328: 'CURRENCY_CODE');
1329:

Line 1407: l_reason_code := WF_ENGINE.GetItemAttrText(

1403: -- RUN mode - normal process execution
1404: --
1405: if (p_funcmode = 'RUN') then
1406:
1407: l_reason_code := WF_ENGINE.GetItemAttrText(
1408: p_item_type,
1409: p_item_key,
1410: 'REASON');
1411:

Line 1412: l_currency_code := WF_ENGINE.GetItemAttrText(

1408: p_item_type,
1409: p_item_key,
1410: 'REASON');
1411:
1412: l_currency_code := WF_ENGINE.GetItemAttrText(
1413: p_item_type,
1414: p_item_key,
1415: 'CURRENCY_CODE');
1416:

Line 1418: l_approver_count := WF_ENGINE.GetItemAttrNumber(

1414: p_item_key,
1415: 'CURRENCY_CODE');
1416:
1417:
1418: l_approver_count := WF_ENGINE.GetItemAttrNumber(
1419: p_item_type,
1420: p_item_key,
1421: 'FIND_APPROVER_COUNT');
1422:

Line 1442: WF_ENGINE.SetItemAttrNumber(p_item_type,

1438: else
1439: -- found the first approver
1440: l_count := 1;
1441:
1442: WF_ENGINE.SetItemAttrNumber(p_item_type,
1443: p_item_key,
1444: 'FIND_APPROVER_COUNT',
1445: l_count);
1446:

Line 1479: WF_ENGINE.SetItemAttrNumber(p_item_type,

1475: p_result := 'COMPLETE:F';
1476: return;
1477: else
1478:
1479: WF_ENGINE.SetItemAttrNumber(p_item_type,
1480: p_item_key,
1481: 'FIND_APPROVER_COUNT',
1482: l_approver_count);
1483:

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

1555: ------------------------------------------------------------
1556: l_debug_mesg := 'Retreiving info for Non-Primary Approver';
1557: ------------------------------------------------------------
1558:
1559: l_approver_user_name := WF_ENGINE.GetItemAttrText(p_item_type,
1560: p_item_key,
1561: 'ROLE');
1562:
1563: select employee_id, user_id into l_employee_id, l_approver_id

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

1644: ------------------------------------------------------------
1645: l_debug_info := 'Retreiving info for Next Non-Primary Approver';
1646: ------------------------------------------------------------
1647:
1648: l_approver_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
1649: p_item_key,
1650: 'APPROVER_ID');
1651: BEGIN
1652: select employee_id into l_employee_id

Line 1804: l_reason_code := WF_ENGINE.GetItemAttrText(

1800: ------------------------------------------------------------
1801: l_debug_mesg := 'Checking if User exists in Approval Limits Table';
1802: ------------------------------------------------------------
1803:
1804: l_reason_code := WF_ENGINE.GetItemAttrText(
1805: p_item_type,
1806: p_item_key,
1807: 'REASON');
1808:

Line 1809: l_currency_code := WF_ENGINE.GetItemAttrText(

1805: p_item_type,
1806: p_item_key,
1807: 'REASON');
1808:
1809: l_currency_code := WF_ENGINE.GetItemAttrText(
1810: p_item_type,
1811: p_item_key,
1812: 'CURRENCY_CODE');
1813:

Line 1974: WF_ENGINE.SetItemAttrNumber(p_item_type,

1970: l_approver_display_name);
1971:
1972: IF l_approver_user_name IS NOT NULL THEN
1973:
1974: WF_ENGINE.SetItemAttrNumber(p_item_type,
1975: p_item_key,
1976: 'APPROVER_ID',
1977: p_user_id);
1978:

Line 1979: WF_ENGINE.SetItemAttrText(p_item_type,

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

Line 1984: WF_ENGINE.SetItemAttrText(p_item_type,

1980: p_item_key,
1981: 'APPROVER_USER_NAME',
1982: l_approver_user_name);
1983:
1984: WF_ENGINE.SetItemAttrText(p_item_type,
1985: p_item_key,
1986: 'APPROVER_DISPLAY_NAME',
1987: l_approver_display_name);
1988: END IF;

Line 2001: WF_ENGINE.SetItemAttrNumber(p_item_type,

1997: l_manager_display_name);
1998:
1999: IF l_manager_name IS NOT NULL THEN
2000:
2001: WF_ENGINE.SetItemAttrNumber(p_item_type,
2002: p_item_key,
2003: 'MANAGER_ID',
2004: p_user_id);
2005:

Line 2006: WF_ENGINE.SetItemAttrText(p_item_type,

2002: p_item_key,
2003: 'MANAGER_ID',
2004: p_user_id);
2005:
2006: WF_ENGINE.SetItemAttrText(p_item_type,
2007: p_item_key,
2008: 'MANAGER_USER_NAME',
2009: l_manager_name);
2010:

Line 2011: WF_ENGINE.SetItemAttrText(p_item_type,

2007: p_item_key,
2008: 'MANAGER_USER_NAME',
2009: l_manager_name);
2010:
2011: WF_ENGINE.SetItemAttrText(p_item_type,
2012: p_item_key,
2013: 'MANAGER_DISPLAY_NAME',
2014: l_manager_display_name);
2015:

Line 2016: WF_ENGINE.SetItemAttrNumber(p_item_type,

2012: p_item_key,
2013: 'MANAGER_DISPLAY_NAME',
2014: l_manager_display_name);
2015:
2016: WF_ENGINE.SetItemAttrNumber(p_item_type,
2017: p_item_key,
2018: 'APPROVER_ID',
2019: p_user_id);
2020:

Line 2021: WF_ENGINE.SetItemAttrText(p_item_type,

2017: p_item_key,
2018: 'APPROVER_ID',
2019: p_user_id);
2020:
2021: WF_ENGINE.SetItemAttrText(p_item_type,
2022: p_item_key,
2023: 'APPROVER_USER_NAME',
2024: l_manager_name);
2025:

Line 2026: WF_ENGINE.SetItemAttrText(p_item_type,

2022: p_item_key,
2023: 'APPROVER_USER_NAME',
2024: l_manager_name);
2025:
2026: WF_ENGINE.SetItemAttrText(p_item_type,
2027: p_item_key,
2028: 'APPROVER_DISPLAY_NAME',
2029: l_manager_display_name);
2030:

Line 2128: l_escalation_count := WF_ENGINE.GetItemAttrNumber(

2124: -------------------------------------------------------
2125: l_debug_info := 'Trying to retrieve employee manager';
2126: -------------------------------------------------------
2127:
2128: l_escalation_count := WF_ENGINE.GetItemAttrNumber(
2129: p_item_type,
2130: p_item_key,
2131: 'ESCALATION_COUNT');
2132:

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

2132:
2133: /* Bug 3195343 Changes l_employee_id to l_approver_id */
2134: IF l_escalation_count=0 THEN
2135:
2136: l_approver_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
2137: p_item_key,
2138: 'APPROVER_ID');
2139: ELSE
2140:

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

2137: p_item_key,
2138: 'APPROVER_ID');
2139: ELSE
2140:
2141: l_approver_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
2142: p_item_key,
2143: 'MANAGER_ID');
2144:
2145: END IF;

Line 2166: WF_ENGINE.SetItemAttrNumber( p_item_type,

2162: p_result := 'COMPLETE:T';
2163:
2164: l_escalation_count := l_escalation_count + 1;
2165:
2166: WF_ENGINE.SetItemAttrNumber( p_item_type,
2167: p_item_key,
2168: 'ESCALATION_COUNT',
2169: l_escalation_count);
2170:

Line 2177: WF_ENGINE.SetItemAttrNumber(p_item_type,

2173: Open c2;
2174: Fetch c2 into l_manager_user_id ;
2175: Close c2;
2176:
2177: WF_ENGINE.SetItemAttrNumber(p_item_type,
2178: p_item_key,
2179: 'MANAGER_ID',
2180: l_manager_user_id);
2181:

Line 2187: WF_ENGINE.SetItemAttrText(p_item_type,

2183: to_char(l_manager_id),
2184: l_manager_user_name,
2185: l_manager_display_name);
2186:
2187: WF_ENGINE.SetItemAttrText(p_item_type,
2188: p_item_key,
2189: 'MANAGER_USER_NAME',
2190: l_manager_user_name);
2191:

Line 2192: WF_ENGINE.SetItemAttrText(p_item_type,

2188: p_item_key,
2189: 'MANAGER_USER_NAME',
2190: l_manager_user_name);
2191:
2192: WF_ENGINE.SetItemAttrText(p_item_type,
2193: p_item_key,
2194: 'MANAGER_DISPLAY_NAME',
2195: l_manager_display_name);
2196:

Line 2267: l_collector_employee_id := WF_ENGINE.GetItemAttrNumber(

2263: l_debug_mesg := 'Record collector as approver';
2264: ------------------------------------------------------------
2265:
2266:
2267: l_collector_employee_id := WF_ENGINE.GetItemAttrNumber(
2268: p_item_type,
2269: p_item_key,
2270: 'COLLECTOR_EMPLOYEE_ID');
2271:

Line 2277: WF_ENGINE.SetItemAttrNumber(p_item_type,

2273: Open c1;
2274: Fetch c1 into l_collector_user_id;
2275: Close c1;
2276:
2277: WF_ENGINE.SetItemAttrNumber(p_item_type,
2278: p_item_key,
2279: 'APPROVER_ID',
2280: l_collector_user_id);
2281:

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

2278: p_item_key,
2279: 'APPROVER_ID',
2280: l_collector_user_id);
2281:
2282: l_collector_user_name := WF_ENGINE.GetItemAttrText(p_item_type,
2283: p_item_key,
2284: 'COLLECTOR_USER_NAME');
2285: WF_ENGINE.SetItemAttrText(p_item_type,
2286: p_item_key,

Line 2285: WF_ENGINE.SetItemAttrText(p_item_type,

2281:
2282: l_collector_user_name := WF_ENGINE.GetItemAttrText(p_item_type,
2283: p_item_key,
2284: 'COLLECTOR_USER_NAME');
2285: WF_ENGINE.SetItemAttrText(p_item_type,
2286: p_item_key,
2287: 'APPROVER_USER_NAME',
2288: l_collector_user_name);
2289:

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

2287: 'APPROVER_USER_NAME',
2288: l_collector_user_name);
2289:
2290:
2291: l_collector_display_name := WF_ENGINE.GetItemAttrText(p_item_type,
2292: p_item_key,
2293: 'COLLECTOR_DISPLAY_NAME');
2294: WF_ENGINE.SetItemAttrText(p_item_type,
2295: p_item_key,

Line 2294: WF_ENGINE.SetItemAttrText(p_item_type,

2290:
2291: l_collector_display_name := WF_ENGINE.GetItemAttrText(p_item_type,
2292: p_item_key,
2293: 'COLLECTOR_DISPLAY_NAME');
2294: WF_ENGINE.SetItemAttrText(p_item_type,
2295: p_item_key,
2296: 'APPROVER_DISPLAY_NAME',
2297: l_collector_display_name);
2298:

Line 2371: l_collector_employee_id := WF_ENGINE.GetItemAttrNumber(

2367: l_debug_mesg := 'Get the user name of collector';
2368: ------------------------------------------------------------
2369:
2370:
2371: l_collector_employee_id := WF_ENGINE.GetItemAttrNumber(
2372: p_item_type,
2373: p_item_key,
2374: 'COLLECTOR_EMPLOYEE_ID');
2375: WF_ENGINE.SetItemAttrNumber(p_item_type,

Line 2375: WF_ENGINE.SetItemAttrNumber(p_item_type,

2371: l_collector_employee_id := WF_ENGINE.GetItemAttrNumber(
2372: p_item_type,
2373: p_item_key,
2374: 'COLLECTOR_EMPLOYEE_ID');
2375: WF_ENGINE.SetItemAttrNumber(p_item_type,
2376: p_item_key,
2377: 'FORWARD_FROM_ID',
2378: l_collector_employee_id);
2379:

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

2380:
2381:
2382:
2383:
2384: l_collector_user_name := WF_ENGINE.GetItemAttrText(p_item_type,
2385: p_item_key,
2386: 'COLLECTOR_USER_NAME');
2387: WF_ENGINE.SetItemAttrText(p_item_type,
2388: p_item_key,

Line 2387: WF_ENGINE.SetItemAttrText(p_item_type,

2383:
2384: l_collector_user_name := WF_ENGINE.GetItemAttrText(p_item_type,
2385: p_item_key,
2386: 'COLLECTOR_USER_NAME');
2387: WF_ENGINE.SetItemAttrText(p_item_type,
2388: p_item_key,
2389: 'FORWARD_FROM_USER_NAME',
2390: l_collector_user_name);
2391:

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

2389: 'FORWARD_FROM_USER_NAME',
2390: l_collector_user_name);
2391:
2392:
2393: l_collector_display_name := WF_ENGINE.GetItemAttrText(p_item_type,
2394: p_item_key,
2395: 'COLLECTOR_DISPLAY_NAME');
2396: WF_ENGINE.SetItemAttrText(p_item_type,
2397: p_item_key,

Line 2396: WF_ENGINE.SetItemAttrText(p_item_type,

2392:
2393: l_collector_display_name := WF_ENGINE.GetItemAttrText(p_item_type,
2394: p_item_key,
2395: 'COLLECTOR_DISPLAY_NAME');
2396: WF_ENGINE.SetItemAttrText(p_item_type,
2397: p_item_key,
2398: 'FORWARD_FROM_DISPLAY_NAME',
2399: l_collector_display_name);
2400:

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

2401: -- Add the collector user name in front of notes field.
2402:
2403:
2404:
2405: l_approver_notes := WF_ENGINE.GetItemAttrText(p_item_type,
2406: p_item_key,
2407: 'APPROVER_NOTES');
2408:
2409: l_notes := l_collector_user_name ||

Line 2413: WF_ENGINE.SetItemAttrText(p_item_type,

2409: l_notes := l_collector_user_name ||
2410: ': ' || l_approver_notes || CRLF;
2411:
2412:
2413: WF_ENGINE.SetItemAttrText(p_item_type,
2414: p_item_key,
2415: 'NOTES',
2416: l_notes);
2417:

Line 2422: WF_ENGINE.SetItemAttrText(p_item_type,

2418: -- Initialize the approver_notes
2419:
2420: l_approver_notes := NULL;
2421:
2422: WF_ENGINE.SetItemAttrText(p_item_type,
2423: p_item_key,
2424: 'APPROVER_NOTES',
2425: l_approver_notes);
2426:

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

2484: ------------------------------------------------------------
2485: l_debug_mesg := 'Get the user name of approver';
2486: ------------------------------------------------------------
2487:
2488: l_approver_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
2489: p_item_key,
2490: 'APPROVER_ID');
2491: WF_ENGINE.SetItemAttrNumber(p_item_type,
2492: p_item_key,

Line 2491: WF_ENGINE.SetItemAttrNumber(p_item_type,

2487:
2488: l_approver_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
2489: p_item_key,
2490: 'APPROVER_ID');
2491: WF_ENGINE.SetItemAttrNumber(p_item_type,
2492: p_item_key,
2493: 'FORWARD_TO_ID',
2494: l_approver_id);
2495:

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

2494: l_approver_id);
2495:
2496:
2497:
2498: l_approver_user_name := WF_ENGINE.GetItemAttrText(p_item_type,
2499: p_item_key,
2500: 'APPROVER_USER_NAME');
2501: WF_ENGINE.SetItemAttrText(p_item_type,
2502: p_item_key,

Line 2501: WF_ENGINE.SetItemAttrText(p_item_type,

2497:
2498: l_approver_user_name := WF_ENGINE.GetItemAttrText(p_item_type,
2499: p_item_key,
2500: 'APPROVER_USER_NAME');
2501: WF_ENGINE.SetItemAttrText(p_item_type,
2502: p_item_key,
2503: 'FORWARD_TO_USER_NAME',
2504: l_approver_user_name);
2505:

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

2503: 'FORWARD_TO_USER_NAME',
2504: l_approver_user_name);
2505:
2506:
2507: l_approver_display_name := WF_ENGINE.GetItemAttrText(p_item_type,
2508: p_item_key,
2509: 'APPROVER_DISPLAY_NAME');
2510: WF_ENGINE.SetItemAttrText(p_item_type,
2511: p_item_key,

Line 2510: WF_ENGINE.SetItemAttrText(p_item_type,

2506:
2507: l_approver_display_name := WF_ENGINE.GetItemAttrText(p_item_type,
2508: p_item_key,
2509: 'APPROVER_DISPLAY_NAME');
2510: WF_ENGINE.SetItemAttrText(p_item_type,
2511: p_item_key,
2512: 'FORWARD_TO_DISPLAY_NAME',
2513: l_approver_display_name);
2514:

Line 2577: l_forward_from_user_name := WF_ENGINE.GetItemAttrText(

2573: ------------------------------------------------------------
2574: l_debug_mesg := 'Get the user name of forward from user';
2575: ------------------------------------------------------------
2576:
2577: l_forward_from_user_name := WF_ENGINE.GetItemAttrText(
2578: p_item_type,
2579: p_item_key,
2580: 'FORWARD_FROM_USER_NAME');
2581:

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

2651: ------------------------------------------------------------
2652:
2653:
2654:
2655: l_approver_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
2656: p_item_key,
2657: 'APPROVER_ID');
2658: WF_ENGINE.SetItemAttrNumber(p_item_type,
2659: p_item_key,

Line 2658: WF_ENGINE.SetItemAttrNumber(p_item_type,

2654:
2655: l_approver_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
2656: p_item_key,
2657: 'APPROVER_ID');
2658: WF_ENGINE.SetItemAttrNumber(p_item_type,
2659: p_item_key,
2660: 'FORWARD_FROM_ID',
2661: l_approver_id);
2662:

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

2661: l_approver_id);
2662:
2663:
2664:
2665: l_approver_user_name := WF_ENGINE.GetItemAttrText(p_item_type,
2666: p_item_key,
2667: 'APPROVER_USER_NAME');
2668: WF_ENGINE.SetItemAttrText(p_item_type,
2669: p_item_key,

Line 2668: WF_ENGINE.SetItemAttrText(p_item_type,

2664:
2665: l_approver_user_name := WF_ENGINE.GetItemAttrText(p_item_type,
2666: p_item_key,
2667: 'APPROVER_USER_NAME');
2668: WF_ENGINE.SetItemAttrText(p_item_type,
2669: p_item_key,
2670: 'FORWARD_FROM_USER_NAME',
2671: l_approver_user_name);
2672:

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

2670: 'FORWARD_FROM_USER_NAME',
2671: l_approver_user_name);
2672:
2673:
2674: l_approver_display_name := WF_ENGINE.GetItemAttrText(p_item_type,
2675: p_item_key,
2676: 'APPROVER_DISPLAY_NAME');
2677: WF_ENGINE.SetItemAttrText(p_item_type,
2678: p_item_key,

Line 2677: WF_ENGINE.SetItemAttrText(p_item_type,

2673:
2674: l_approver_display_name := WF_ENGINE.GetItemAttrText(p_item_type,
2675: p_item_key,
2676: 'APPROVER_DISPLAY_NAME');
2677: WF_ENGINE.SetItemAttrText(p_item_type,
2678: p_item_key,
2679: 'FORWARD_FROM_DISPLAY_NAME',
2680: l_approver_display_name);
2681:

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

2680: l_approver_display_name);
2681:
2682: -- Add the approver user name in front of notes field.
2683:
2684: l_notes := WF_ENGINE.GetItemAttrText(p_item_type,
2685: p_item_key,
2686: 'NOTES');
2687:
2688: l_approver_notes := WF_ENGINE.GetItemAttrText(p_item_type,

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

2684: l_notes := WF_ENGINE.GetItemAttrText(p_item_type,
2685: p_item_key,
2686: 'NOTES');
2687:
2688: l_approver_notes := WF_ENGINE.GetItemAttrText(p_item_type,
2689: p_item_key,
2690: 'APPROVER_NOTES');
2691:
2692:

Line 2697: WF_ENGINE.SetItemAttrText(p_item_type,

2693: l_notes := l_notes || l_approver_user_name ||
2694: ': ' || l_approver_notes || CRLF;
2695:
2696:
2697: WF_ENGINE.SetItemAttrText(p_item_type,
2698: p_item_key,
2699: 'NOTES',
2700: l_notes);
2701:

Line 2706: WF_ENGINE.SetItemAttrText(p_item_type,

2702: -- Initialize the approver_notes
2703:
2704: l_approver_notes := NULL;
2705:
2706: WF_ENGINE.SetItemAttrText(p_item_type,
2707: p_item_key,
2708: 'APPROVER_NOTES',
2709: l_approver_notes);
2710:

Line 2773: l_reason_code := WF_ENGINE.GetItemAttrText(

2769: -- RUN mode - normal process execution
2770: --
2771: if (p_funcmode = 'RUN') then
2772:
2773: l_reason_code := WF_ENGINE.GetItemAttrText(
2774: p_item_type,
2775: p_item_key,
2776: 'REASON');
2777:

Line 2778: l_currency_code := WF_ENGINE.GetItemAttrText(

2774: p_item_type,
2775: p_item_key,
2776: 'REASON');
2777:
2778: l_currency_code := WF_ENGINE.GetItemAttrText(
2779: p_item_type,
2780: p_item_key,
2781: 'CURRENCY_CODE');
2782:

Line 2783: l_total_credit_to_invoice:= WF_ENGINE.GetItemAttrNumber(

2779: p_item_type,
2780: p_item_key,
2781: 'CURRENCY_CODE');
2782:
2783: l_total_credit_to_invoice:= WF_ENGINE.GetItemAttrNumber(
2784: p_item_type,
2785: p_item_key,
2786: 'TOTAL_CREDIT_TO_INVOICE');
2787:

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

2786: 'TOTAL_CREDIT_TO_INVOICE');
2787:
2788:
2789:
2790: l_approver_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
2791: p_item_key,
2792: 'APPROVER_ID');
2793: /* Bug 9464009 Un comment wrongly commented code.*/
2794: CheckFinalApprover(l_reason_code,

Line 2941: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(

2937: -- RUN mode - normal process execution
2938: --
2939: if (p_funcmode = 'RUN') then
2940:
2941: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(
2942: p_item_type,
2943: p_item_key,
2944: 'CUSTOMER_TRX_ID');
2945:

Line 2946: l_request_id := WF_ENGINE.GetItemAttrNumber(

2942: p_item_type,
2943: p_item_key,
2944: 'CUSTOMER_TRX_ID');
2945:
2946: l_request_id := WF_ENGINE.GetItemAttrNumber(
2947: p_item_type,
2948: p_item_key,
2949: 'WORKFLOW_DOCUMENT_ID');
2950:

Line 3049: l_reason_code := WF_ENGINE.GetItemAttrText(

3045:
3046: END LOOP;
3047: END;
3048:
3049: l_reason_code := WF_ENGINE.GetItemAttrText(
3050: p_item_type,
3051: p_item_key,
3052: 'REASON');
3053:

Line 3054: l_currency_code := WF_ENGINE.GetItemAttrText(

3050: p_item_type,
3051: p_item_key,
3052: 'REASON');
3053:
3054: l_currency_code := WF_ENGINE.GetItemAttrText(
3055: p_item_type,
3056: p_item_key,
3057: 'CURRENCY_CODE');
3058:

Line 3060: := WF_ENGINE.GetItemAttrNumber(

3056: p_item_key,
3057: 'CURRENCY_CODE');
3058:
3059: l_total_credit_to_invoice
3060: := WF_ENGINE.GetItemAttrNumber(
3061: p_item_type,
3062: p_item_key,
3063: 'TOTAL_CREDIT_TO_INVOICE');
3064:

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

3063: 'TOTAL_CREDIT_TO_INVOICE');
3064:
3065:
3066:
3067: l_approver_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
3068: p_item_key,
3069: 'APPROVER_ID');
3070:
3071: /* Bug 9464009 check for dispute removal as below and comment check for final approval check*/

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

3143: -----------------------------------------------------------------
3144: l_debug_mesg := 'Check if Receivable Approver has been defined';
3145: -----------------------------------------------------------------
3146:
3147: l_receivable_role := WF_ENGINE.GetItemAttrText(p_item_type,
3148: p_item_key,
3149: 'RECEIVABLE_ROLE');
3150:
3151: IF l_receivable_role IS NOT NULL THEN

Line 3157: WF_ENGINE.SetItemAttrText(p_item_type,

3153: SELECT display_name,orig_system_id INTO l_role_display_name, l_role_id
3154: FROM wf_roles
3155: WHERE name = l_receivable_role;
3156:
3157: WF_ENGINE.SetItemAttrText(p_item_type,
3158: p_item_key,
3159: 'APPROVER_USER_NAME',
3160: l_receivable_role);
3161:

Line 3162: WF_ENGINE.SetItemAttrText(p_item_type,

3158: p_item_key,
3159: 'APPROVER_USER_NAME',
3160: l_receivable_role);
3161:
3162: WF_ENGINE.SetItemAttrText(p_item_type,
3163: p_item_key,
3164: 'APPROVER_DISPLAY_NAME',
3165: l_role_display_name);
3166:

Line 3167: WF_ENGINE.SetItemAttrNumber(p_item_type,

3163: p_item_key,
3164: 'APPROVER_DISPLAY_NAME',
3165: l_role_display_name);
3166:
3167: WF_ENGINE.SetItemAttrNumber(p_item_type,
3168: p_item_key,
3169: 'APPROVER_ID',
3170: l_role_id);
3171:

Line 3241: l_notification_id := wf_engine.context_nid;

3237: l_debug_mesg := 'Find user in Receivable role who responded to
3238: the notification';
3239: -----------------------------------------------------------------
3240:
3241: l_notification_id := wf_engine.context_nid;
3242: l_approver_user_name := wf_engine.context_text;
3243:
3244: SELECT orig_system_id, display_name
3245: INTO l_approver_id, l_approver_display_name

Line 3242: l_approver_user_name := wf_engine.context_text;

3238: the notification';
3239: -----------------------------------------------------------------
3240:
3241: l_notification_id := wf_engine.context_nid;
3242: l_approver_user_name := wf_engine.context_text;
3243:
3244: SELECT orig_system_id, display_name
3245: INTO l_approver_id, l_approver_display_name
3246: FROM wf_users

Line 3250: WF_ENGINE.SetItemAttrText(p_item_type,

3246: FROM wf_users
3247: WHERE orig_system = 'PER'
3248: AND name = l_approver_user_name;
3249:
3250: WF_ENGINE.SetItemAttrText(p_item_type,
3251: p_item_key,
3252: 'APPROVER_ID',
3253: l_approver_id);
3254:

Line 3255: WF_ENGINE.SetItemAttrText(p_item_type,

3251: p_item_key,
3252: 'APPROVER_ID',
3253: l_approver_id);
3254:
3255: WF_ENGINE.SetItemAttrText(p_item_type,
3256: p_item_key,
3257: 'APPROVER_USER_NAME',
3258: l_approver_user_name);
3259:

Line 3260: WF_ENGINE.SetItemAttrText(p_item_type,

3256: p_item_key,
3257: 'APPROVER_USER_NAME',
3258: l_approver_user_name);
3259:
3260: WF_ENGINE.SetItemAttrText(p_item_type,
3261: p_item_key,
3262: 'APPROVER_DISPLAY_NAME',
3263: l_approver_display_name);
3264:

Line 3340: l_document_id := WF_ENGINE.GetItemAttrNumber(

3336: --
3337: if (p_funcmode = 'RUN') then
3338:
3339:
3340: l_document_id := WF_ENGINE.GetItemAttrNumber(
3341: p_item_type,
3342: p_item_key,
3343: 'WORKFLOW_DOCUMENT_ID');
3344:

Line 3346: := WF_ENGINE.GetItemAttrText(

3342: p_item_key,
3343: 'WORKFLOW_DOCUMENT_ID');
3344:
3345: l_requestor_user_name
3346: := WF_ENGINE.GetItemAttrText(
3347: p_item_type,
3348: p_item_key,
3349: 'REQUESTOR_USER_NAME');
3350:

Line 3352: l_reason_code := WF_ENGINE.GetItemAttrText(

3348: p_item_key,
3349: 'REQUESTOR_USER_NAME');
3350:
3351:
3352: l_reason_code := WF_ENGINE.GetItemAttrText(
3353: p_item_type,
3354: p_item_key,
3355: 'REASON');
3356:

Line 3359: := WF_ENGINE.GetItemAttrNumber(

3355: 'REASON');
3356:
3357:
3358: l_total_credit_to_invoice
3359: := WF_ENGINE.GetItemAttrNumber(
3360: p_item_type,
3361: p_item_key,
3362: 'TOTAL_CREDIT_TO_INVOICE');
3363:

Line 3365: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(

3361: p_item_key,
3362: 'TOTAL_CREDIT_TO_INVOICE');
3363:
3364:
3365: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(
3366: p_item_type,
3367: p_item_key,
3368: 'CUSTOMER_TRX_ID');
3369:

Line 3370: l_comments := WF_ENGINE.GetItemAttrText(

3366: p_item_type,
3367: p_item_key,
3368: 'CUSTOMER_TRX_ID');
3369:
3370: l_comments := WF_ENGINE.GetItemAttrText(
3371: p_item_type,
3372: p_item_key,
3373: 'COMMENTS');
3374: l_internal_comment := wf_engine.GetItemAttrText(

Line 3374: l_internal_comment := wf_engine.GetItemAttrText(

3370: l_comments := WF_ENGINE.GetItemAttrText(
3371: p_item_type,
3372: p_item_key,
3373: 'COMMENTS');
3374: l_internal_comment := wf_engine.GetItemAttrText(
3375: p_item_type,
3376: p_item_key,
3377: 'INTERNAL_COMMENTS');
3378:

Line 3493: l_document_id := WF_ENGINE.GetItemAttrNumber(

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

Line 3498: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(

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

Line 3504: := WF_ENGINE.GetItemAttrText(

3500: p_item_key,
3501: 'CUSTOMER_TRX_ID');
3502:
3503: l_approver_display_name
3504: := WF_ENGINE.GetItemAttrText(
3505: p_item_type,
3506: p_item_key,
3507: 'APPROVER_DISPLAY_NAME');
3508:

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

3505: p_item_type,
3506: p_item_key,
3507: 'APPROVER_DISPLAY_NAME');
3508:
3509: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
3510:
3511: fnd_message.set_name('AR', 'AR_WF_APPROVAL_REMINDER');
3512: fnd_message.set_token('APPROVER', l_approver_display_name);
3513: -- bug fix 1122477

Line 3532: WF_ENGINE.SetItemAttrNumber( p_item_type,

3528:
3529: /* Bug 3195343 Initialise the escalation_count attribute for the
3530: Primary approver. */
3531:
3532: WF_ENGINE.SetItemAttrNumber( p_item_type,
3533: p_item_key,
3534: 'ESCALATION_COUNT',
3535: 0 ) ;
3536: p_result := 'COMPLETE:T';

Line 3598: l_document_id := WF_ENGINE.GetItemAttrNumber(

3594: --
3595: if (p_funcmode = 'RUN') then
3596:
3597:
3598: l_document_id := WF_ENGINE.GetItemAttrNumber(
3599: p_item_type,
3600: p_item_key,
3601: 'WORKFLOW_DOCUMENT_ID');
3602:

Line 3603: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(

3599: p_item_type,
3600: p_item_key,
3601: 'WORKFLOW_DOCUMENT_ID');
3602:
3603: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(
3604: p_item_type,
3605: p_item_key,
3606: 'CUSTOMER_TRX_ID');
3607:

Line 3609: := WF_ENGINE.GetItemAttrText(

3605: p_item_key,
3606: 'CUSTOMER_TRX_ID');
3607:
3608: l_manager_user_name
3609: := WF_ENGINE.GetItemAttrText(
3610: p_item_type,
3611: p_item_key,
3612: 'MANAGER_USER_NAME');
3613:

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

3610: p_item_type,
3611: p_item_key,
3612: 'MANAGER_USER_NAME');
3613:
3614: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
3615:
3616: fnd_message.set_name('AR', 'AR_WF_APPROVAL_ESCALATION');
3617: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3618: fnd_message.set_token('APPROVER', l_manager_user_name);

Line 3698: l_document_id := WF_ENGINE.GetItemAttrNumber(

3694: --
3695: if (p_funcmode = 'RUN') then
3696:
3697:
3698: l_document_id := WF_ENGINE.GetItemAttrNumber(
3699: p_item_type,
3700: p_item_key,
3701: 'WORKFLOW_DOCUMENT_ID');
3702:

Line 3703: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(

3699: p_item_type,
3700: p_item_key,
3701: 'WORKFLOW_DOCUMENT_ID');
3702:
3703: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(
3704: p_item_type,
3705: p_item_key,
3706: 'CUSTOMER_TRX_ID');
3707:

Line 3709: := WF_ENGINE.GetItemAttrText(

3705: p_item_key,
3706: 'CUSTOMER_TRX_ID');
3707:
3708: l_receivable_role
3709: := WF_ENGINE.GetItemAttrText(
3710: p_item_type,
3711: p_item_key,
3712: 'RECEIVABLE_ROLE');
3713: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/

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

3709: := WF_ENGINE.GetItemAttrText(
3710: p_item_type,
3711: p_item_key,
3712: 'RECEIVABLE_ROLE');
3713: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
3714: SELECT display_name INTO l_role_display_name
3715: FROM wf_roles
3716: WHERE name = l_receivable_role;
3717:

Line 3813: l_document_id := WF_ENGINE.GetItemAttrNumber(

3809: --
3810: if (p_funcmode = 'RUN') then
3811:
3812:
3813: l_document_id := WF_ENGINE.GetItemAttrNumber(
3814: p_item_type,
3815: p_item_key,
3816: 'WORKFLOW_DOCUMENT_ID');
3817:

Line 3818: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(

3814: p_item_type,
3815: p_item_key,
3816: 'WORKFLOW_DOCUMENT_ID');
3817:
3818: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(
3819: p_item_type,
3820: p_item_key,
3821: 'CUSTOMER_TRX_ID');
3822:

Line 3824: := WF_ENGINE.GetItemAttrText(

3820: p_item_key,
3821: 'CUSTOMER_TRX_ID');
3822:
3823: l_receivable_role
3824: := WF_ENGINE.GetItemAttrText(
3825: p_item_type,
3826: p_item_key,
3827: 'RECEIVABLE_ROLE');
3828: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/

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

3824: := WF_ENGINE.GetItemAttrText(
3825: p_item_type,
3826: p_item_key,
3827: 'RECEIVABLE_ROLE');
3828: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
3829:
3830: SELECT display_name INTO l_role_display_name
3831: FROM wf_roles
3832: WHERE name = l_receivable_role;

Line 3925: l_document_id := WF_ENGINE.GetItemAttrNumber(

3921: --
3922: if (p_funcmode = 'RUN') then
3923:
3924:
3925: l_document_id := WF_ENGINE.GetItemAttrNumber(
3926: p_item_type,
3927: p_item_key,
3928: 'WORKFLOW_DOCUMENT_ID');
3929:

Line 3930: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(

3926: p_item_type,
3927: p_item_key,
3928: 'WORKFLOW_DOCUMENT_ID');
3929:
3930: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(
3931: p_item_type,
3932: p_item_key,
3933: 'CUSTOMER_TRX_ID');
3934:

Line 3936: := WF_ENGINE.GetItemAttrText(

3932: p_item_key,
3933: 'CUSTOMER_TRX_ID');
3934:
3935: l_approver_display_name
3936: := WF_ENGINE.GetItemAttrText(
3937: p_item_type,
3938: p_item_key,
3939: 'APPROVER_DISPLAY_NAME');
3940:

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

3937: p_item_type,
3938: p_item_key,
3939: 'APPROVER_DISPLAY_NAME');
3940:
3941: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
3942:
3943: fnd_message.set_name('AR', 'AR_WF_REQUEST_APPROVAL');
3944: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
3945: fnd_message.set_token('APPROVER', l_approver_display_name);

Line 4023: l_document_id := WF_ENGINE.GetItemAttrNumber(

4019: --
4020: if (p_funcmode = 'RUN') then
4021:
4022:
4023: l_document_id := WF_ENGINE.GetItemAttrNumber(
4024: p_item_type,
4025: p_item_key,
4026: 'WORKFLOW_DOCUMENT_ID');
4027:

Line 4028: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(

4024: p_item_type,
4025: p_item_key,
4026: 'WORKFLOW_DOCUMENT_ID');
4027:
4028: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(
4029: p_item_type,
4030: p_item_key,
4031: 'CUSTOMER_TRX_ID');
4032:

Line 4034: := WF_ENGINE.GetItemAttrText(

4030: p_item_key,
4031: 'CUSTOMER_TRX_ID');
4032:
4033: l_approver_display_name
4034: := WF_ENGINE.GetItemAttrText(
4035: p_item_type,
4036: p_item_key,
4037: 'APPROVER_DISPLAY_NAME');
4038:

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

4035: p_item_type,
4036: p_item_key,
4037: 'APPROVER_DISPLAY_NAME');
4038:
4039: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4040:
4041: fnd_message.set_name('AR', 'AR_WF_APPROVED_RESPONSE');
4042: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4043: fnd_message.set_token('APPROVER', l_approver_display_name);

Line 4136: l_document_id := WF_ENGINE.GetItemAttrNumber(

4132: --
4133: if (p_funcmode = 'RUN') then
4134:
4135:
4136: l_document_id := WF_ENGINE.GetItemAttrNumber(
4137: p_item_type,
4138: p_item_key,
4139: 'WORKFLOW_DOCUMENT_ID');
4140:

Line 4141: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(

4137: p_item_type,
4138: p_item_key,
4139: 'WORKFLOW_DOCUMENT_ID');
4140:
4141: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(
4142: p_item_type,
4143: p_item_key,
4144: 'CUSTOMER_TRX_ID');
4145:

Line 4147: := WF_ENGINE.GetItemAttrText(

4143: p_item_key,
4144: 'CUSTOMER_TRX_ID');
4145:
4146: l_approver_display_name
4147: := WF_ENGINE.GetItemAttrText(
4148: p_item_type,
4149: p_item_key,
4150: 'APPROVER_DISPLAY_NAME');
4151: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/

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

4147: := WF_ENGINE.GetItemAttrText(
4148: p_item_type,
4149: p_item_key,
4150: 'APPROVER_DISPLAY_NAME');
4151: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4152:
4153:
4154: fnd_message.set_name('AR', 'AR_WF_REJECTED_RESPONSE');
4155: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));

Line 4247: l_document_id := WF_ENGINE.GetItemAttrNumber(

4243: --
4244: if (p_funcmode = 'RUN') then
4245:
4246:
4247: l_document_id := WF_ENGINE.GetItemAttrNumber(
4248: p_item_type,
4249: p_item_key,
4250: 'WORKFLOW_DOCUMENT_ID');
4251:

Line 4252: l_credit_memo_number := WF_ENGINE.GetItemAttrText(

4248: p_item_type,
4249: p_item_key,
4250: 'WORKFLOW_DOCUMENT_ID');
4251:
4252: l_credit_memo_number := WF_ENGINE.GetItemAttrText(
4253: p_item_type,
4254: p_item_key,
4255: 'CREDIT_MEMO_NUMBER');
4256:

Line 4257: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(

4253: p_item_type,
4254: p_item_key,
4255: 'CREDIT_MEMO_NUMBER');
4256:
4257: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(
4258: p_item_type,
4259: p_item_key,
4260: 'CUSTOMER_TRX_ID');
4261: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/

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

4257: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(
4258: p_item_type,
4259: p_item_key,
4260: 'CUSTOMER_TRX_ID');
4261: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4262:
4263: /* Get trx number for CM and the insert into note text */
4264:
4265:

Line 4356: l_reason_code := WF_ENGINE.GetItemAttrText(

4352: -- RUN mode - normal process execution
4353: --
4354: if (p_funcmode = 'RUN') then
4355:
4356: l_reason_code := WF_ENGINE.GetItemAttrText(
4357: p_item_type,
4358: p_item_key,
4359: 'REASON');
4360:

Line 4361: l_currency_code := WF_ENGINE.GetItemAttrText(

4357: p_item_type,
4358: p_item_key,
4359: 'REASON');
4360:
4361: l_currency_code := WF_ENGINE.GetItemAttrText(
4362: p_item_type,
4363: p_item_key,
4364: 'CURRENCY_CODE');
4365:

Line 4367: := WF_ENGINE.GetItemAttrNumber(

4363: p_item_key,
4364: 'CURRENCY_CODE');
4365:
4366: l_entered_amount_display
4367: := WF_ENGINE.GetItemAttrNumber(
4368: p_item_type,
4369: p_item_key,
4370: 'ENTERED_AMOUNT_DISPLAY');
4371:

Line 4372: l_customer_id := WF_ENGINE.GetItemAttrNumber(

4368: p_item_type,
4369: p_item_key,
4370: 'ENTERED_AMOUNT_DISPLAY');
4371:
4372: l_customer_id := WF_ENGINE.GetItemAttrNumber(
4373: p_item_type,
4374: p_item_key,
4375: 'CUSTOMER_ID');
4376:

Line 4377: l_collector_id := WF_ENGINE.GetItemAttrNumber(

4373: p_item_type,
4374: p_item_key,
4375: 'CUSTOMER_ID');
4376:
4377: l_collector_id := WF_ENGINE.GetItemAttrNumber(
4378: p_item_type,
4379: p_item_key,
4380: 'COLLECTOR_ID');
4381:

Line 4383: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(

4379: p_item_key,
4380: 'COLLECTOR_ID');
4381:
4382:
4383: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(
4384: p_item_type,
4385: p_item_key,
4386: 'CUSTOMER_TRX_ID');
4387:

Line 4388: l_bill_to_site_use_id := WF_ENGINE.GetItemAttrNumber(

4384: p_item_type,
4385: p_item_key,
4386: 'CUSTOMER_TRX_ID');
4387:
4388: l_bill_to_site_use_id := WF_ENGINE.GetItemAttrNumber(
4389: p_item_type,
4390: p_item_key,
4391: 'BILL_TO_SITE_USE_ID');
4392:

Line 4559: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(

4555: if (p_funcmode = 'RUN') then
4556:
4557: -- call transaction API here
4558:
4559: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(
4560: p_item_type,
4561: p_item_key,
4562: 'CUSTOMER_TRX_ID');
4563:

Line 4564: l_amount := WF_ENGINE.GetItemAttrNumber(

4560: p_item_type,
4561: p_item_key,
4562: 'CUSTOMER_TRX_ID');
4563:
4564: l_amount := WF_ENGINE.GetItemAttrNumber(
4565: p_item_type,
4566: p_item_key,
4567: 'ORIGINAL_TOTAL');
4568:

Line 4569: l_request_id := WF_ENGINE.GetItemAttrNumber(

4565: p_item_type,
4566: p_item_key,
4567: 'ORIGINAL_TOTAL');
4568:
4569: l_request_id := WF_ENGINE.GetItemAttrNumber(
4570: p_item_type,
4571: p_item_key,
4572: 'WORKFLOW_DOCUMENT_ID');
4573:

Line 4574: l_batch_source_name := WF_ENGINE.GetItemAttrText(

4570: p_item_type,
4571: p_item_key,
4572: 'WORKFLOW_DOCUMENT_ID');
4573:
4574: l_batch_source_name := WF_ENGINE.GetItemAttrText(
4575: p_item_type,
4576: p_item_key,
4577: 'BATCH_SOURCE_NAME');
4578:

Line 4580: l_credit_method_installments := WF_ENGINE.GetItemAttrText(

4576: p_item_key,
4577: 'BATCH_SOURCE_NAME');
4578:
4579:
4580: l_credit_method_installments := WF_ENGINE.GetItemAttrText(
4581: p_item_type,
4582: p_item_key,
4583: 'CREDIT_INSTALLMENT_RULE');
4584:

Line 4585: l_credit_method_rules := WF_ENGINE.GetItemAttrText(

4581: p_item_type,
4582: p_item_key,
4583: 'CREDIT_INSTALLMENT_RULE');
4584:
4585: l_credit_method_rules := WF_ENGINE.GetItemAttrText(
4586: p_item_type,
4587: p_item_key,
4588: 'CREDIT_ACCOUNTING_RULE');
4589:

Line 4597: WF_ENGINE.SetItemAttrText(p_item_type,

4593:
4594: fnd_message.set_name('AR', 'AR_WF_NO_BATCH');
4595: l_cm_creation_error := fnd_message.get;
4596:
4597: WF_ENGINE.SetItemAttrText(p_item_type,
4598: p_item_key,
4599: 'CM_CREATION_ERROR',
4600: l_cm_creation_error);
4601:

Line 4638: WF_ENGINE.SetItemAttrText(p_item_type,

4634: exception
4635: when others then
4636: p_result := 'COMPLETE:F';
4637: l_cm_creation_error := 'Could not find the request';
4638: WF_ENGINE.SetItemAttrText(p_item_type,
4639: p_item_key,
4640: 'CM_CREATION_ERROR',
4641: l_cm_creation_error);
4642: return;

Line 4682: WF_ENGINE.SetItemAttrText(p_item_type,

4678: into l_credit_memo_number
4679: from ra_customer_trx
4680: where customer_trx_id = l_credit_memo_id;
4681:
4682: WF_ENGINE.SetItemAttrText(p_item_type,
4683: p_item_key,
4684: 'CREDIT_MEMO_NUMBER',
4685: l_credit_memo_number);
4686:

Line 4692: WF_ENGINE.SetItemAttrText(p_item_type,

4688: exception
4689: when others then
4690: p_result := 'COMPLETE:F';
4691: l_cm_creation_error := 'Could not find the credit memo';
4692: WF_ENGINE.SetItemAttrText(p_item_type,
4693: p_item_key,
4694: 'CM_CREATION_ERROR',
4695: l_cm_creation_error);
4696: return;

Line 4704: WF_ENGINE.SetItemAttrText(p_item_type,

4700: FOR i IN 1..l_error_tab.COUNT LOOP
4701: l_cm_creation_error := l_cm_creation_error || l_error_tab(i).translated_message || CRLF;
4702: END LOOP;
4703:
4704: WF_ENGINE.SetItemAttrText(p_item_type,
4705: p_item_key,
4706: 'CM_CREATION_ERROR',
4707: l_cm_creation_error);
4708:

Line 4786: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(

4782: ------------------------------------------------------------
4783: l_debug_mesg := 'Get the user value of rules';
4784: ------------------------------------------------------------
4785:
4786: l_customer_trx_id := WF_ENGINE.GetItemAttrNumber(
4787: p_item_type,
4788: p_item_key,
4789: 'CUSTOMER_TRX_ID');
4790:

Line 4792: l_credit_installment_rule := WF_ENGINE.GetItemAttrText(

4788: p_item_key,
4789: 'CUSTOMER_TRX_ID');
4790:
4791:
4792: l_credit_installment_rule := WF_ENGINE.GetItemAttrText(
4793: p_item_type,
4794: p_item_key,
4795: 'CREDIT_INSTALLMENT_RULE');
4796:

Line 4797: l_credit_accounting_rule := WF_ENGINE.GetItemAttrText(

4793: p_item_type,
4794: p_item_key,
4795: 'CREDIT_INSTALLMENT_RULE');
4796:
4797: l_credit_accounting_rule := WF_ENGINE.GetItemAttrText(
4798: p_item_type,
4799: p_item_key,
4800: 'CREDIT_ACCOUNTING_RULE');
4801:

Line 4802: l_invalid_rule_value := WF_ENGINE.GetItemAttrText(

4798: p_item_type,
4799: p_item_key,
4800: 'CREDIT_ACCOUNTING_RULE');
4801:
4802: l_invalid_rule_value := WF_ENGINE.GetItemAttrText(
4803: p_item_type,
4804: p_item_key,
4805: 'INVALID_RULE_VALUE');
4806:

Line 4807: l_invalid_rule_mesg := WF_ENGINE.GetItemAttrText(

4803: p_item_type,
4804: p_item_key,
4805: 'INVALID_RULE_VALUE');
4806:
4807: l_invalid_rule_mesg := WF_ENGINE.GetItemAttrText(
4808: p_item_type,
4809: p_item_key,
4810: 'INVALID_RULE_MESG');
4811:

Line 4825: WF_ENGINE.SetItemAttrText(p_item_type,

4821: if l_count > 1 then
4822:
4823: if l_credit_installment_rule not in ('LIFO', 'FIFO', 'PRORATE') then
4824: -- invalid credit method
4825: WF_ENGINE.SetItemAttrText(p_item_type,
4826: p_item_key,
4827: 'INVALID_RULE_MESG',
4828: l_invalid_rule_value);
4829: p_result := 'COMPLETE:F';

Line 4842: WF_ENGINE.SetItemAttrText(p_item_type,

4838: if l_invoicing_rule_id is not NULL then
4839:
4840: if l_credit_accounting_rule not in ('LIFO', 'PRORATE','UNIT') then
4841: -- invalid credit method
4842: WF_ENGINE.SetItemAttrText(p_item_type,
4843: p_item_key,
4844: 'INVALID_RULE_MESG',
4845: l_invalid_rule_value);
4846: p_result := 'COMPLETE:F';

Line 4854: WF_ENGINE.SetItemAttrText(p_item_type,

4850:
4851: -- the credit methods are valid
4852: if l_invalid_rule_mesg is not NULL then
4853: l_invalid_rule_mesg := NULL;
4854: WF_ENGINE.SetItemAttrText(p_item_type,
4855: p_item_key,
4856: 'INVALID_RULE_MESG',
4857: l_invalid_rule_mesg);
4858: end if;