[Home] [Help]
33: OPEN org;
34: FETCH org INTO l_org_id;
35: CLOSE org;
36:
37: wf_engine.setitemattrnumber(
38: p_item_type,
39: p_item_key,
40: 'ORG_ID',
41: l_org_id);
102: arp_standard.debug('restore_context: ' || g_debug_mesg);
103: END IF;
104: ----------------------------------------------------------
105:
106: l_org_id := wf_engine.GetItemAttrNumber(
107: itemtype => c_item_type,
108: itemkey => p_item_key,
109: aname => 'ORG_ID');
110:
157: OPEN c;
158: FETCH c INTO l_org_id;
159: CLOSE c;
160:
161: wf_engine.SetItemAttrNumber(
162: itemtype => c_item_type,
163: itemkey => p_item_key,
164: aname => 'ORG_ID',
165: avalue => l_org_id);
234: arp_standard.debug('VALIDATE_FIRST_APPROVER: ' || g_debug_mesg);
235: END IF;
236: ----------------------------------------------------------
237:
238: l_employee_id := wf_engine.getitemattrnumber(
239: itemtype => c_item_type,
240: itemkey => p_item_key,
241: aname => 'NON_DEFAULT_START_PERSON_ID');
242:
259: FETCH mgr INTO l_manager_employee_id;
260: CLOSE mgr;
261:
262: -- now set the manager as the first approver.
263: wf_engine.setitemattrnumber(
264: itemtype => c_item_type,
265: itemkey => p_item_key,
266: aname => 'NON_DEFAULT_START_PERSON_ID',
267: avalue => l_manager_employee_id);
473: l_approver_display_name);
474:
475: IF l_approver_user_name IS NOT NULL THEN
476:
477: wf_engine.SetItemAttrNumber(p_item_type,
478: p_item_key,
479: 'APPROVER_ID',
480: p_user_id);
481:
478: p_item_key,
479: 'APPROVER_ID',
480: p_user_id);
481:
482: wf_engine.SetItemAttrText(p_item_type,
483: p_item_key,
484: 'APPROVER_USER_NAME',
485: l_approver_user_name);
486:
483: p_item_key,
484: 'APPROVER_USER_NAME',
485: l_approver_user_name);
486:
487: wf_engine.SetItemAttrText(p_item_type,
488: p_item_key,
489: 'APPROVER_DISPLAY_NAME',
490: l_approver_display_name);
491:
534: l_responder_display_name wf_users.display_name%TYPE;
535:
536: BEGIN
537:
538: l_responder_user_name := wf_engine.context_text;
539:
540: OPEN c(l_responder_user_name);
541: FETCH c INTO l_responder_user_id;
542: CLOSE c;
549: IF p_funcmode = 'TRANSFER' OR p_funcmode = 'FORWARD' THEN
550:
551: -- insert the reassignment note here
552:
553: l_document_id := wf_engine.GetItemAttrNumber(
554: itemtype => p_item_type,
555: itemkey => p_item_key,
556: aname => 'WORKFLOW_DOCUMENT_ID');
557:
554: itemtype => p_item_type,
555: itemkey => p_item_key,
556: aname => 'WORKFLOW_DOCUMENT_ID');
557:
558: l_customer_trx_id := wf_engine.GetItemAttrNumber(
559: itemtype => p_item_type,
560: itemkey => p_item_key,
561: aname => 'CUSTOMER_TRX_ID');
562:
576: x_note_id => l_note_id);
577:
578: ELSIF (p_funcmode = 'RESPOND') THEN
579:
580: wf_engine.setitemattrtext(
581: itemtype => p_item_type,
582: itemkey => p_item_key,
583: aname => 'DEBUG',
584: avalue => '2: ' || l_responder_user_name);
584: avalue => '2: ' || l_responder_user_name);
585:
586: -- insert the reassignment note here
587:
588: wf_engine.SetItemAttrNumber(
589: itemtype => p_item_type,
590: itemkey => p_item_key,
591: aname => 'APPROVER_ID',
592: avalue => l_responder_user_id);
590: itemkey => p_item_key,
591: aname => 'APPROVER_ID',
592: avalue => l_responder_user_id);
593:
594: wf_engine.SetItemAttrText(
595: itemtype => p_item_type,
596: itemkey => p_item_key,
597: aname => 'APPROVER_USER_NAME',
598: avalue => l_responder_user_name);
596: itemkey => p_item_key,
597: aname => 'APPROVER_USER_NAME',
598: avalue => l_responder_user_name);
599:
600: wf_engine.SetItemAttrText(
601: itemtype => p_item_type,
602: itemkey => p_item_key,
603: aname => 'APPROVER_DISPLAY_NAME',
604: avalue => l_responder_display_name);
634: arp_standard.debug('CheckUserInTable: ' || g_debug_mesg);
635: END IF;
636: ----------------------------------------------------------
637:
638: l_reason_code := wf_engine.GetItemAttrText(
639: p_item_type,
640: p_item_key,
641: 'REASON');
642:
639: p_item_type,
640: p_item_key,
641: 'REASON');
642:
643: l_currency_code := wf_engine.GetItemAttrText(
644: p_item_type,
645: p_item_key,
646: 'CURRENCY_CODE');
647:
749: END IF;
750:
751: END IF;
752:
753: wf_engine.SetItemAttrNumber(
754: itemtype => p_item_type,
755: itemkey => p_item_key,
756: aname => 'PERSON_ID',
757: avalue => l_approver_employee_id);
799: l_next_approver ame_util.approverrecord;
800:
801: BEGIN
802:
803: l_transaction_type := wf_engine.GetItemAttrText(
804: itemtype => p_item_type,
805: itemkey => p_item_key,
806: aname => 'CURRENT_HUB');
807:
882: l_manager_employee_id fnd_user.employee_id%TYPE;
883:
884: BEGIN
885:
886: l_manager_employee_id := wf_engine.getitemattrnumber(
887: itemtype => p_item_type,
888: itemkey => p_item_key,
889: aname => 'MANAGER_ID');
890:
913:
914: g_debug_mesg := 'Retrieved the next approver';
915:
916: -- reset the scalation related attributes.
917: wf_engine.setitemattrnumber(
918: itemtype => p_item_type,
919: itemkey => p_item_key,
920: aname => 'MANAGER_ID',
921: avalue => -9999);
919: itemkey => p_item_key,
920: aname => 'MANAGER_ID',
921: avalue => -9999);
922:
923: wf_engine.setitemattrnumber(
924: itemtype => p_item_type,
925: itemkey => p_item_key,
926: aname => 'ESCALATION_COUNT',
927: avalue => 0);
1036: );
1037:
1038: IF l_customer_trx_id <> -1 then
1039:
1040: wf_engine.SetItemAttrNumber(
1041: p_item_type,
1042: p_item_key,
1043: 'WORKFLOW_DOCUMENT_ID',
1044: l_workflow_document_id);
1042: p_item_key,
1043: 'WORKFLOW_DOCUMENT_ID',
1044: l_workflow_document_id);
1045:
1046: wf_engine.SetItemAttrNumber(
1047: p_item_type,
1048: p_item_key,
1049: 'CUSTOMER_TRX_ID',
1050: l_customer_trx_id);
1048: p_item_key,
1049: 'CUSTOMER_TRX_ID',
1050: l_customer_trx_id);
1051:
1052: wf_engine.SetItemAttrNumber(
1053: p_item_type,
1054: p_item_key,
1055: 'TOTAL_CREDIT_TO_INVOICE',
1056: l_amount);
1054: p_item_key,
1055: 'TOTAL_CREDIT_TO_INVOICE',
1056: l_amount);
1057:
1058: wf_engine.SetItemAttrNumber(
1059: p_item_type,
1060: p_item_key,
1061: 'TOTAL_CREDIT_TO_LINES',
1062: l_line_amount);
1060: p_item_key,
1061: 'TOTAL_CREDIT_TO_LINES',
1062: l_line_amount);
1063:
1064: wf_engine.SetItemAttrNumber(
1065: p_item_type,
1066: p_item_key,
1067: 'TOTAL_CREDIT_TO_TAX',
1068: l_tax_amount);
1066: p_item_key,
1067: 'TOTAL_CREDIT_TO_TAX',
1068: l_tax_amount);
1069:
1070: wf_engine.SetItemAttrNumber(
1071: p_item_type,
1072: p_item_key,
1073: 'TOTAL_CREDIT_TO_FREIGHT',
1074: l_freight_amount);
1072: p_item_key,
1073: 'TOTAL_CREDIT_TO_FREIGHT',
1074: l_freight_amount);
1075:
1076: wf_engine.SetItemAttrText(
1077: p_item_type,
1078: p_item_key,
1079: 'REASON',
1080: l_reason_code);
1078: p_item_key,
1079: 'REASON',
1080: l_reason_code);
1081:
1082: wf_engine.SetItemAttrText(
1083: p_item_type,
1084: p_item_key,
1085: 'REASON_MEANING',
1086: l_reason_meaning);
1084: p_item_key,
1085: 'REASON_MEANING',
1086: l_reason_meaning);
1087:
1088: wf_engine.SetItemAttrText(
1089: p_item_type,
1090: p_item_key,
1091: 'COMMENTS',
1092: l_comments);
1090: p_item_key,
1091: 'COMMENTS',
1092: l_comments);
1093:
1094: wf_engine.SetItemAttrNumber(
1095: p_item_type,
1096: p_item_key,
1097: 'REQUESTOR_ID',
1098: l_requestor_id);
1096: p_item_key,
1097: 'REQUESTOR_ID',
1098: l_requestor_id);
1099:
1100: wf_engine.SetItemAttrText(
1101: p_item_type,
1102: p_item_key,
1103: 'ORIG_TRX_NUMBER',
1104: l_orig_trx_number);
1102: p_item_key,
1103: 'ORIG_TRX_NUMBER',
1104: l_orig_trx_number);
1105:
1106: wf_engine.SetItemAttrText(
1107: p_item_type,
1108: p_item_key,
1109: 'TAX_EX_CERT_NUM',
1110: l_tax_ex_cert_num);
1108: p_item_key,
1109: 'TAX_EX_CERT_NUM',
1110: l_tax_ex_cert_num);
1111:
1112: wf_engine.SetItemAttrText(
1113: p_item_type,
1114: p_item_key,
1115: 'INTERNAL_COMMENTS',
1116: l_internal_comment);
1163: END if;
1164: END if;
1165: END if;*/
1166:
1167: wf_engine.SetItemAttrText(
1168: p_item_type,
1169: p_item_key,
1170: 'REQUESTOR_USER_NAME',
1171: l_requestor_user_name);
1169: p_item_key,
1170: 'REQUESTOR_USER_NAME',
1171: l_requestor_user_name);
1172:
1173: wf_engine.SetItemAttrText(
1174: p_item_type,
1175: p_item_key,
1176: 'REQUESTOR_DISPLAY_NAME',
1177: l_requestor_display_name);
1187: l_original_freight_amount,
1188: l_original_total ,
1189: l_currency_code);
1190:
1191: wf_engine.SetItemAttrNumber(
1192: p_item_type,
1193: p_item_key,
1194: 'ORIGINAL_LINE_AMOUNT',
1195: l_original_line_amount);
1193: p_item_key,
1194: 'ORIGINAL_LINE_AMOUNT',
1195: l_original_line_amount);
1196:
1197: wf_engine.SetItemAttrNumber(
1198: p_item_type,
1199: p_item_key,
1200: 'ORIGINAL_TAX_AMOUNT',
1201: l_original_tax_amount);
1199: p_item_key,
1200: 'ORIGINAL_TAX_AMOUNT',
1201: l_original_tax_amount);
1202:
1203: wf_engine.SetItemAttrNumber(
1204: p_item_type,
1205: p_item_key,
1206: 'ORIGINAL_FREIGHT_AMOUNT',
1207: l_original_freight_amount);
1205: p_item_key,
1206: 'ORIGINAL_FREIGHT_AMOUNT',
1207: l_original_freight_amount);
1208:
1209: wf_engine.SetItemAttrNumber(
1210: p_item_type,
1211: p_item_key,
1212: 'ORIGINAL_TOTAL',
1213: l_original_total);
1211: p_item_key,
1212: 'ORIGINAL_TOTAL',
1213: l_original_total);
1214:
1215: wf_engine.SetItemAttrText(
1216: p_item_type,
1217: p_item_key,
1218: 'CURRENCY_CODE',
1219: l_currency_code);
1368: fnd_message.set_name('AR', 'ARW_INV_MSG10');
1369: l_tax_disclaimer := fnd_message.get;
1370: END IF;
1371:
1372: wf_engine.SetItemAttrText(p_item_type,
1373: p_item_key,
1374: 'TAX_DISCLAIMER',
1375: l_tax_disclaimer);
1376:
1506:
1507: ------------------------------------------------------------
1508: g_debug_mesg := 'Get requested trx id ';
1509: ------------------------------------------------------------
1510: l_customer_trx_id := wf_engine.GetItemAttrNumber(
1511: p_item_type,
1512: p_item_key,
1513: 'CUSTOMER_TRX_ID');
1514:
1536: ----------------------------------------------------------------------
1537: g_debug_mesg := 'Set value for customer_id(name) in workflow process';
1538: -----------------------------------------------------------------------
1539:
1540: wf_engine.SetItemAttrNumber(p_item_type,
1541: p_item_key,
1542: 'CUSTOMER_ID',
1543: l_customer_id);
1544:
1542: 'CUSTOMER_ID',
1543: l_customer_id);
1544:
1545:
1546: wf_engine.SetItemAttrText(p_item_type,
1547: p_item_key,
1548: 'CUSTOMER_NAME',
1549: l_bill_to_customer_name);
1550:
1549: l_bill_to_customer_name);
1550:
1551: -- set the bill to and ship to customer info.
1552:
1553: wf_engine.SetItemAttrText(p_item_type,
1554: p_item_key,
1555: 'BILL_TO_CUSTOMER_NAME',
1556: l_bill_to_customer_name);
1557:
1556: l_bill_to_customer_name);
1557:
1558: -- Bug Fix 1882580. Since l_bill_to_customer_number is changed
1559: -- from number to VARCHAR2, replaced the function in call to
1560: -- wf_engine fom SetItemAttrNumber to SetItemAttrText
1561:
1562: wf_engine.SetItemAttrText(p_item_type,
1563: p_item_key,
1564: 'BILL_TO_CUSTOMER_NUMBER',
1558: -- Bug Fix 1882580. Since l_bill_to_customer_number is changed
1559: -- from number to VARCHAR2, replaced the function in call to
1560: -- wf_engine fom SetItemAttrNumber to SetItemAttrText
1561:
1562: wf_engine.SetItemAttrText(p_item_type,
1563: p_item_key,
1564: 'BILL_TO_CUSTOMER_NUMBER',
1565: l_bill_to_customer_number);
1566:
1563: p_item_key,
1564: 'BILL_TO_CUSTOMER_NUMBER',
1565: l_bill_to_customer_number);
1566:
1567: wf_engine.SetItemAttrText(p_item_type,
1568: p_item_key,
1569: 'SHIP_TO_CUSTOMER_NAME',
1570: l_ship_to_customer_name);
1571:
1570: l_ship_to_customer_name);
1571:
1572: -- Bug Fix 1882580. Since l_bill_to_customer_number is changed
1573: -- from number to VARCHAR2, replaced the function in call to
1574: -- wf_engine fom SetItemAttrNumber to SetItemAttrText
1575:
1576: wf_engine.SetItemAttrText(p_item_type,
1577: p_item_key,
1578: 'SHIP_TO_CUSTOMER_NUMBER',
1572: -- Bug Fix 1882580. Since l_bill_to_customer_number is changed
1573: -- from number to VARCHAR2, replaced the function in call to
1574: -- wf_engine fom SetItemAttrNumber to SetItemAttrText
1575:
1576: wf_engine.SetItemAttrText(p_item_type,
1577: p_item_key,
1578: 'SHIP_TO_CUSTOMER_NUMBER',
1579: l_ship_to_customer_number);
1580:
1579: l_ship_to_customer_number);
1580:
1581: -- set the trx number
1582:
1583: wf_engine.SetItemAttrText(p_item_type,
1584: p_item_key,
1585: 'TRX_NUMBER',
1586: l_trx_number);
1587:
1589:
1590: ----------------------------------------------------------------------
1591: g_debug_mesg := 'Set value for bill_to_site_use_id in workflow process';
1592: -----------------------------------------------------------------------
1593: wf_engine.SetItemAttrNumber(p_item_type,
1594: p_item_key,
1595: 'BILL_TO_SITE_USE_ID',
1596: l_bill_to_site_use_id);
1597:
1598:
1599:
1600: -- set the URL site
1601:
1602: l_request_id := wf_engine.GetItemAttrNumber(
1603: p_item_type,
1604: p_item_key,
1605: 'WORKFLOW_DOCUMENT_ID');
1606:
1607: OPEN c;
1608: FETCH c INTO l_request_url, l_trans_url, l_act_url;
1609: CLOSE c;
1610:
1611: wf_engine.SetItemAttrText(p_item_type,
1612: p_item_key,
1613: 'REQUEST_URL',
1614: l_request_url);
1615:
1612: p_item_key,
1613: 'REQUEST_URL',
1614: l_request_url);
1615:
1616: wf_engine.SetItemAttrText(p_item_type,
1617: p_item_key,
1618: 'TRANSACTION_NUMBER_URL',
1619: l_trans_url);
1620:
1617: p_item_key,
1618: 'TRANSACTION_NUMBER_URL',
1619: l_trans_url);
1620:
1621: wf_engine.SetItemAttrText(p_item_type,
1622: p_item_key,
1623: 'TRANSACTION_ACTIVITY_URL',
1624: l_act_url);
1625:
1787: -----------------------------------------------------------------
1788: g_debug_mesg := 'Get the value of customer_trx_id(customer id)';
1789: -----------------------------------------------------------------
1790:
1791: l_customer_trx_id := wf_engine.GetItemAttrNumber(
1792: itemtype => p_item_type,
1793: itemkey => p_item_key,
1794: aname => 'CUSTOMER_TRX_ID');
1795:
1792: itemtype => p_item_type,
1793: itemkey => p_item_key,
1794: aname => 'CUSTOMER_TRX_ID');
1795:
1796: l_customer_id := wf_engine.getitemattrnumber(
1797: itemtype => p_item_type,
1798: itemkey => p_item_key,
1799: aname => 'CUSTOMER_ID');
1800:
1801: ----------------------------------------------------------------------
1802: g_debug_mesg := 'get value of bill_to_site_use_id from workflow process';
1803: -----------------------------------------------------------------------
1804:
1805: l_bill_to_site_use_id := wf_engine.getitemattrnumber(
1806: itemtype => p_item_type,
1807: itemkey => p_item_key,
1808: aname => 'BILL_TO_SITE_USE_ID');
1809:
1824: p_result := 'COMPLETE:F';
1825: RETURN;
1826: END IF;
1827:
1828: wf_engine.SetItemAttrText(
1829: itemtype => p_item_type,
1830: itemkey => p_item_key,
1831: aname => 'CURRENT_HUB',
1832: avalue => c_collector_transaction_type);
1838: ----------------------------------------------------------------
1839: g_debug_mesg := 'Set value for collector in workflow process';
1840: ----------------------------------------------------------------
1841:
1842: wf_engine.SetItemAttrNumber(
1843: itemtype => p_item_type,
1844: itemkey => p_item_key,
1845: aname => 'COLLECTOR_EMPLOYEE_ID',
1846: avalue => l_collector_employee_id);
1844: itemkey => p_item_key,
1845: aname => 'COLLECTOR_EMPLOYEE_ID',
1846: avalue => l_collector_employee_id);
1847:
1848: wf_engine.SetItemAttrNumber(
1849: itemtype => p_item_type,
1850: itemkey => p_item_key,
1851: aname => 'COLLECTOR_ID',
1852: avalue => l_collector_id);
1850: itemkey => p_item_key,
1851: aname => 'COLLECTOR_ID',
1852: avalue => l_collector_id);
1853:
1854: wf_engine.SetItemAttrText(
1855: itemtype => p_item_type,
1856: itemkey => p_item_key,
1857: aname => 'COLLECTOR_NAME',
1858: avalue => l_collector_name);
1874: -----------------------------------------------------------------
1875: p_result := 'COMPLETE:F';
1876: RETURN;
1877: ELSE
1878: wf_engine.SetItemAttrText(
1879: itemtype => p_item_type,
1880: itemkey => p_item_key,
1881: aname => 'COLLECTOR_USER_NAME',
1882: avalue => l_collector_user_name);
1880: itemkey => p_item_key,
1881: aname => 'COLLECTOR_USER_NAME',
1882: avalue => l_collector_user_name);
1883:
1884: wf_engine.SetItemAttrText(
1885: itemtype => p_item_type,
1886: itemkey => p_item_key,
1887: aname => 'COLLECTOR_DISPLAY_NAME',
1888: avalue => l_collector_display_name);
1886: itemkey => p_item_key,
1887: aname => 'COLLECTOR_DISPLAY_NAME',
1888: avalue => l_collector_display_name);
1889:
1890: wf_engine.SetItemAttrText(
1891: itemtype => p_item_type,
1892: itemkey => p_item_key,
1893: aname => 'APPROVER_ID',
1894: avalue => l_collector_user_id);
1892: itemkey => p_item_key,
1893: aname => 'APPROVER_ID',
1894: avalue => l_collector_user_id);
1895:
1896: wf_engine.SetItemAttrText(
1897: itemtype => p_item_type,
1898: itemkey => p_item_key,
1899: aname => 'APPROVER_USER_NAME',
1900: avalue => l_collector_user_name);
1898: itemkey => p_item_key,
1899: aname => 'APPROVER_USER_NAME',
1900: avalue => l_collector_user_name);
1901:
1902: wf_engine.SetItemAttrText(
1903: itemtype => p_item_type,
1904: itemkey => p_item_key,
1905: aname => 'APPROVER_DISPLAY_NAME',
1906: avalue => l_collector_display_name);
1998:
1999: -- Bug 991922 : check if message body needs to say rule is required
2000: -- get additional info to determine if rule is required
2001:
2002: l_customer_trx_id := wf_engine.getitemattrnumber(
2003: itemtype => p_item_type,
2004: itemkey => p_item_key,
2005: aname => 'CUSTOMER_TRX_ID');
2006:
2003: itemtype => p_item_type,
2004: itemkey => p_item_key,
2005: aname => 'CUSTOMER_TRX_ID');
2006:
2007: l_credit_accounting_rule := wf_engine.getitemattrtext(
2008: itemtype => p_item_type,
2009: itemkey => p_item_key,
2010: aname => 'CREDIT_ACCOUNTING_RULE');
2011:
2008: itemtype => p_item_type,
2009: itemkey => p_item_key,
2010: aname => 'CREDIT_ACCOUNTING_RULE');
2011:
2012: l_reason_code := wf_engine.getitemattrtext(
2013: itemtype => p_item_type,
2014: itemkey => p_item_key,
2015: aname => 'REASON');
2016:
2013: itemtype => p_item_type,
2014: itemkey => p_item_key,
2015: aname => 'REASON');
2016:
2017: l_currency_code := wf_engine.GetItemAttrText(
2018: itemtype => p_item_type,
2019: itemkey => p_item_key,
2020: aname => 'CURRENCY_CODE');
2021:
2032: name => 'ARW_NEED_RULE');
2033:
2034: l_need_rule_mesg := fnd_message.get;
2035:
2036: wf_engine.SetItemAttrText(
2037: itemtype => p_item_type,
2038: itemkey => p_item_key,
2039: aname => 'INVALID_RULE_MESG',
2040: avalue => l_need_rule_mesg);
2109: -- RUN mode - normal process execution
2110: --
2111: IF (p_funcmode = 'RUN') THEN
2112:
2113: l_approval_path := wf_engine.getitemattrtext(
2114: itemtype => p_item_type,
2115: itemkey => p_item_key,
2116: aname => 'APPROVAL_PATH');
2117:
2247: -- if so then the last approver has timed out and we do not know who to
2248: -- send the approval to. So, we should error out and send notification
2249: -- to SYSADMIN.
2250:
2251: l_timeout_occured := wf_engine.GetItemAttrText(
2252: itemtype => p_item_type,
2253: itemkey => p_item_key,
2254: aname => 'TIMEOUT_OCCURRED');
2255:
2269: -- Bug # 3865317.
2270: -- We need to reset a flag to indicate that we are no
2271: -- longer in a timeout mode.
2272:
2273: wf_engine.setitemattrtext(
2274: itemtype => p_item_type,
2275: itemkey => p_item_key,
2276: aname => 'TIMEOUT_OCCURRED',
2277: avalue => 'N');
2275: itemkey => p_item_key,
2276: aname => 'TIMEOUT_OCCURRED',
2277: avalue => 'N');
2278:
2279: l_escalation_count := wf_engine.getitemattrnumber(
2280: itemtype => p_item_type,
2281: itemkey => p_item_key,
2282: aname => 'ESCALATION_COUNT');
2283:
2296:
2297: IF l_approver_user_id IS NULL THEN
2298:
2299: -- end of hub, reset the scalation related attributes.
2300: wf_engine.setitemattrnumber(
2301: itemtype => p_item_type,
2302: itemkey => p_item_key,
2303: aname => 'MANAGER_ID',
2304: avalue => -9999);
2302: itemkey => p_item_key,
2303: aname => 'MANAGER_ID',
2304: avalue => -9999);
2305:
2306: wf_engine.setitemattrnumber(
2307: itemtype => p_item_type,
2308: itemkey => p_item_key,
2309: aname => 'ESCALATION_COUNT',
2310: avalue => 0);
2412: -- RUN mode - normal process execution
2413: --
2414: IF (p_funcmode = 'RUN') THEN
2415:
2416: l_approver_user_name := wf_engine.GetItemAttrText(
2417: itemtype => p_item_type,
2418: itemkey => p_item_key,
2419: aname => 'ROLE');
2420:
2430: --
2431: -- If this is not populated here supervisory and job level
2432: -- hierarchy would not work.
2433:
2434: wf_engine.setitemattrnumber(
2435: itemtype => p_item_type,
2436: itemkey => p_item_key,
2437: aname => 'NON_DEFAULT_START_PERSON_ID',
2438: avalue => l_employee_id);
2664: -- if so then the last approver has timed out and we do not know who to
2665: -- send the approval to. So, we should error out and send notification
2666: -- to SYSADMIN.
2667:
2668: l_timeout_occured := wf_engine.GetItemAttrText(
2669: itemtype => p_item_type,
2670: itemkey => p_item_key,
2671: aname => 'TIMEOUT_OCCURRED');
2672:
2686: -- Bug # 3865317.
2687: -- We need to reset a flag to indicate that we are no
2688: -- longer in a timeout mode.
2689:
2690: wf_engine.setitemattrtext(
2691: itemtype => p_item_type,
2692: itemkey => p_item_key,
2693: aname => 'TIMEOUT_OCCURRED',
2694: avalue => 'N');
2692: itemkey => p_item_key,
2693: aname => 'TIMEOUT_OCCURRED',
2694: avalue => 'N');
2695:
2696: l_escalation_count := wf_engine.getitemattrnumber(
2697: itemtype => p_item_type,
2698: itemkey => p_item_key,
2699: aname => 'ESCALATION_COUNT');
2700:
2712:
2713: IF l_approver_user_id IS NULL THEN
2714:
2715: -- end of hub, reset the scalation related attributes.
2716: wf_engine.setitemattrnumber(
2717: itemtype => p_item_type,
2718: itemkey => p_item_key,
2719: aname => 'MANAGER_ID',
2720: avalue => -9999);
2718: itemkey => p_item_key,
2719: aname => 'MANAGER_ID',
2720: avalue => -9999);
2721:
2722: wf_engine.setitemattrnumber(
2723: itemtype => p_item_type,
2724: itemkey => p_item_key,
2725: aname => 'ESCALATION_COUNT',
2726: avalue => 0);
2729: p_result := 'COMPLETE:F';
2730: RETURN;
2731: END IF;
2732:
2733: wf_engine.SetItemAttrNumber(
2734: itemtype => p_item_type,
2735: itemkey => p_item_key,
2736: aname => 'PERSON_ID',
2737: avalue => l_approver_employee_id);
2855: -- However, for Limits Only path, to work around a AME limitation
2856: -- we must pass approved status to AME, so that AME does not try
2857: -- to find a manager and error out.
2858:
2859: l_approval_path := wf_engine.getitemattrtext(
2860: itemtype => p_item_type,
2861: itemkey => p_item_key,
2862: aname => 'APPROVAL_PATH');
2863:
2860: itemtype => p_item_type,
2861: itemkey => p_item_key,
2862: aname => 'APPROVAL_PATH');
2863:
2864: l_transaction_type := wf_engine.GetItemAttrText(
2865: itemtype => p_item_type,
2866: itemkey => p_item_key,
2867: aname => 'CURRENT_HUB');
2868:
2889: -- to his/her manager and he/she too may not respond. In that case
2890: -- notification has be to sent to the manager's manager in a recursive
2891: -- manner.
2892:
2893: l_escalation_count := wf_engine.getitemattrnumber(
2894: itemtype => p_item_type,
2895: itemkey => p_item_key,
2896: aname => 'ESCALATION_COUNT');
2897:
2896: aname => 'ESCALATION_COUNT');
2897:
2898: IF l_escalation_count=0 THEN
2899:
2900: l_nonresponsive_user_id := wf_engine.getitemattrnumber(
2901: itemtype => p_item_type,
2902: itemkey => p_item_key,
2903: aname => 'APPROVER_ID');
2904:
2904:
2905: l_nonresponsive_employee_id := get_employee_id(l_nonresponsive_user_id);
2906:
2907: ELSE
2908: l_nonresponsive_employee_id := wf_engine.getitemattrnumber(
2909: itemtype => p_item_type,
2910: itemkey => p_item_key,
2911: aname => 'MANAGER_ID');
2912: END IF;
2912: END IF;
2913:
2914: l_escalation_count := l_escalation_count + 1;
2915:
2916: wf_engine.setitemattrnumber(
2917: itemtype => p_item_type,
2918: itemkey => p_item_key,
2919: aname => 'ESCALATION_COUNT',
2920: avalue => l_escalation_count);
2931: to_char(l_nonresponsive_employee_id),
2932: l_nonresponsive_user_name,
2933: l_nonresponsive_display_name);
2934:
2935: wf_engine.setitemattrnumber(
2936: itemtype => p_item_type,
2937: itemkey => p_item_key,
2938: aname => 'FORWARD_FROM_ID',
2939: avalue => l_nonresponsive_user_id);
2937: itemkey => p_item_key,
2938: aname => 'FORWARD_FROM_ID',
2939: avalue => l_nonresponsive_user_id);
2940:
2941: wf_engine.setitemattrtext(
2942: itemtype => p_item_type,
2943: itemkey => p_item_key,
2944: aname => 'FORWARD_FROM_USER_NAME',
2945: avalue => l_nonresponsive_user_name);
2943: itemkey => p_item_key,
2944: aname => 'FORWARD_FROM_USER_NAME',
2945: avalue => l_nonresponsive_user_name);
2946:
2947: wf_engine.setitemattrtext(
2948: itemtype => p_item_type,
2949: itemkey => p_item_key,
2950: aname => 'FORWARD_FROM_DISPLAY_NAME',
2951: avalue => l_nonresponsive_display_name);
2964: p_result := 'COMPLETE:F';
2965: RETURN;
2966:
2967: ELSE
2968: wf_engine.setitemattrnumber(
2969: itemtype => p_item_type,
2970: itemkey => p_item_key,
2971: aname => 'MANAGER_ID',
2972: avalue => l_manager_employee_id);
2976: to_char(l_manager_employee_id),
2977: l_manager_user_name,
2978: l_manager_display_name);
2979:
2980: wf_engine.setitemattrtext(
2981: itemtype => p_item_type,
2982: itemkey => p_item_key,
2983: aname => 'MANAGER_USER_NAME',
2984: avalue => l_manager_user_name);
2982: itemkey => p_item_key,
2983: aname => 'MANAGER_USER_NAME',
2984: avalue => l_manager_user_name);
2985:
2986: wf_engine.setitemattrtext(
2987: itemtype => p_item_type,
2988: itemkey => p_item_key,
2989: aname => 'MANAGER_DISPLAY_NAME',
2990: avalue => l_manager_display_name);
3057: g_debug_mesg := 'Get the user name of collector';
3058: ------------------------------------------------------------
3059:
3060:
3061: l_collector_employee_id := wf_engine.GetItemAttrNumber(
3062: p_item_type,
3063: p_item_key,
3064: 'COLLECTOR_EMPLOYEE_ID');
3065: wf_engine.SetItemAttrNumber(p_item_type,
3061: l_collector_employee_id := wf_engine.GetItemAttrNumber(
3062: p_item_type,
3063: p_item_key,
3064: 'COLLECTOR_EMPLOYEE_ID');
3065: wf_engine.SetItemAttrNumber(p_item_type,
3066: p_item_key,
3067: 'FORWARD_FROM_ID',
3068: l_collector_employee_id);
3069:
3070:
3071:
3072:
3073:
3074: l_collector_user_name := wf_engine.GetItemAttrText(p_item_type,
3075: p_item_key,
3076: 'COLLECTOR_USER_NAME');
3077: wf_engine.SetItemAttrText(p_item_type,
3078: p_item_key,
3073:
3074: l_collector_user_name := wf_engine.GetItemAttrText(p_item_type,
3075: p_item_key,
3076: 'COLLECTOR_USER_NAME');
3077: wf_engine.SetItemAttrText(p_item_type,
3078: p_item_key,
3079: 'FORWARD_FROM_USER_NAME',
3080: l_collector_user_name);
3081:
3079: 'FORWARD_FROM_USER_NAME',
3080: l_collector_user_name);
3081:
3082:
3083: l_collector_display_name := wf_engine.GetItemAttrText(p_item_type,
3084: p_item_key,
3085: 'COLLECTOR_DISPLAY_NAME');
3086: wf_engine.SetItemAttrText(p_item_type,
3087: p_item_key,
3082:
3083: l_collector_display_name := wf_engine.GetItemAttrText(p_item_type,
3084: p_item_key,
3085: 'COLLECTOR_DISPLAY_NAME');
3086: wf_engine.SetItemAttrText(p_item_type,
3087: p_item_key,
3088: 'FORWARD_FROM_DISPLAY_NAME',
3089: l_collector_display_name);
3090:
3091: -- Add the collector user name in front of notes field.
3092:
3093:
3094:
3095: l_approver_notes := wf_engine.GetItemAttrText(p_item_type,
3096: p_item_key,
3097: 'APPROVER_NOTES');
3098:
3099: l_notes := l_collector_user_name ||
3098:
3099: l_notes := l_collector_user_name ||
3100: ': ' || l_approver_notes || CRLF;
3101:
3102: wf_engine.SetItemAttrText(p_item_type,
3103: p_item_key,
3104: 'NOTES',
3105: l_notes);
3106:
3107: -- Initialize the approver_notes
3108:
3109: l_approver_notes := NULL;
3110:
3111: wf_engine.SetItemAttrText(p_item_type,
3112: p_item_key,
3113: 'APPROVER_NOTES',
3114: l_approver_notes);
3115:
3114: l_approver_notes);
3115:
3116:
3117: -- end of hub, reset the scalation related attributes.
3118: wf_engine.setitemattrnumber(
3119: itemtype => p_item_type,
3120: itemkey => p_item_key,
3121: aname => 'MANAGER_ID',
3122: avalue => -9999);
3120: itemkey => p_item_key,
3121: aname => 'MANAGER_ID',
3122: avalue => -9999);
3123:
3124: wf_engine.setitemattrnumber(
3125: itemtype => p_item_type,
3126: itemkey => p_item_key,
3127: aname => 'ESCALATION_COUNT',
3128: avalue => 0);
3194: ------------------------------------------------------------
3195: g_debug_mesg := 'Get the user name of approver';
3196: ------------------------------------------------------------
3197:
3198: l_approver_id := wf_engine.GetItemAttrNumber(
3199: p_item_type,
3200: p_item_key,
3201: 'APPROVER_ID');
3202:
3199: p_item_type,
3200: p_item_key,
3201: 'APPROVER_ID');
3202:
3203: wf_engine.SetItemAttrNumber(
3204: p_item_type,
3205: p_item_key,
3206: 'FORWARD_TO_ID',
3207: l_approver_id);
3205: p_item_key,
3206: 'FORWARD_TO_ID',
3207: l_approver_id);
3208:
3209: l_approver_user_name := wf_engine.GetItemAttrText(
3210: p_item_type,
3211: p_item_key,
3212: 'APPROVER_USER_NAME');
3213:
3210: p_item_type,
3211: p_item_key,
3212: 'APPROVER_USER_NAME');
3213:
3214: wf_engine.SetItemAttrText(
3215: p_item_type,
3216: p_item_key,
3217: 'FORWARD_TO_USER_NAME',
3218: l_approver_user_name);
3217: 'FORWARD_TO_USER_NAME',
3218: l_approver_user_name);
3219:
3220:
3221: l_approver_display_name := wf_engine.GetItemAttrText(
3222: p_item_type,
3223: p_item_key,
3224: 'APPROVER_DISPLAY_NAME');
3225:
3222: p_item_type,
3223: p_item_key,
3224: 'APPROVER_DISPLAY_NAME');
3225:
3226: wf_engine.SetItemAttrText(
3227: p_item_type,
3228: p_item_key,
3229: 'FORWARD_TO_DISPLAY_NAME',
3230: l_approver_display_name);
3300: ------------------------------------------------------------
3301: g_debug_mesg := 'Get the user name of forward from user';
3302: ------------------------------------------------------------
3303:
3304: l_forward_from_user_name := wf_engine.GetItemAttrText(
3305: p_item_type,
3306: p_item_key,
3307: 'FORWARD_FROM_USER_NAME');
3308:
3391: ------------------------------------------------------------
3392:
3393:
3394:
3395: l_approver_id := wf_engine.GetItemAttrNumber(p_item_type,
3396: p_item_key,
3397: 'APPROVER_ID');
3398: wf_engine.SetItemAttrNumber(p_item_type,
3399: p_item_key,
3394:
3395: l_approver_id := wf_engine.GetItemAttrNumber(p_item_type,
3396: p_item_key,
3397: 'APPROVER_ID');
3398: wf_engine.SetItemAttrNumber(p_item_type,
3399: p_item_key,
3400: 'FORWARD_FROM_ID',
3401: l_approver_id);
3402:
3401: l_approver_id);
3402:
3403:
3404:
3405: l_approver_user_name := wf_engine.GetItemAttrText(p_item_type,
3406: p_item_key,
3407: 'APPROVER_USER_NAME');
3408: wf_engine.SetItemAttrText(p_item_type,
3409: p_item_key,
3404:
3405: l_approver_user_name := wf_engine.GetItemAttrText(p_item_type,
3406: p_item_key,
3407: 'APPROVER_USER_NAME');
3408: wf_engine.SetItemAttrText(p_item_type,
3409: p_item_key,
3410: 'FORWARD_FROM_USER_NAME',
3411: l_approver_user_name);
3412:
3410: 'FORWARD_FROM_USER_NAME',
3411: l_approver_user_name);
3412:
3413:
3414: l_approver_display_name := wf_engine.GetItemAttrText(p_item_type,
3415: p_item_key,
3416: 'APPROVER_DISPLAY_NAME');
3417: wf_engine.SetItemAttrText(p_item_type,
3418: p_item_key,
3413:
3414: l_approver_display_name := wf_engine.GetItemAttrText(p_item_type,
3415: p_item_key,
3416: 'APPROVER_DISPLAY_NAME');
3417: wf_engine.SetItemAttrText(p_item_type,
3418: p_item_key,
3419: 'FORWARD_FROM_DISPLAY_NAME',
3420: l_approver_display_name);
3421:
3420: l_approver_display_name);
3421:
3422: -- Add the approver user name in front of notes field.
3423:
3424: l_notes := wf_engine.GetItemAttrText(p_item_type,
3425: p_item_key,
3426: 'NOTES');
3427:
3428: l_approver_notes := wf_engine.GetItemAttrText(p_item_type,
3424: l_notes := wf_engine.GetItemAttrText(p_item_type,
3425: p_item_key,
3426: 'NOTES');
3427:
3428: l_approver_notes := wf_engine.GetItemAttrText(p_item_type,
3429: p_item_key,
3430: 'APPROVER_NOTES');
3431:
3432:
3432:
3433: l_notes := l_notes || l_approver_user_name ||
3434: ': ' || l_approver_notes || CRLF;
3435:
3436: wf_engine.SetItemAttrText(p_item_type,
3437: p_item_key,
3438: 'NOTES',
3439: l_notes);
3440:
3441: -- Initialize the approver_notes
3442:
3443: l_approver_notes := NULL;
3444:
3445: wf_engine.SetItemAttrText(p_item_type,
3446: p_item_key,
3447: 'APPROVER_NOTES',
3448: l_approver_notes);
3449:
3598: -- RUN mode - normal process execution
3599: --
3600: IF (p_funcmode = 'RUN') then
3601:
3602: l_customer_trx_id := wf_engine.GetItemAttrNumber(
3603: p_item_type,
3604: p_item_key,
3605: 'CUSTOMER_TRX_ID');
3606:
3603: p_item_type,
3604: p_item_key,
3605: 'CUSTOMER_TRX_ID');
3606:
3607: l_request_id := WF_ENGINE.GetItemAttrNumber(
3608: p_item_type,
3609: p_item_key,
3610: 'WORKFLOW_DOCUMENT_ID');
3611:
3705:
3706: END LOOP;
3707: END;
3708:
3709: l_reason_code := wf_engine.GetItemAttrText(
3710: p_item_type,
3711: p_item_key,
3712: 'REASON');
3713:
3710: p_item_type,
3711: p_item_key,
3712: 'REASON');
3713:
3714: l_currency_code := wf_engine.GetItemAttrText(
3715: p_item_type,
3716: p_item_key,
3717: 'CURRENCY_CODE');
3718:
3716: p_item_key,
3717: 'CURRENCY_CODE');
3718:
3719: l_total_credit_to_invoice
3720: := wf_engine.GetItemAttrNumber(
3721: p_item_type,
3722: p_item_key,
3723: 'TOTAL_CREDIT_TO_INVOICE');
3724:
3723: 'TOTAL_CREDIT_TO_INVOICE');
3724:
3725:
3726:
3727: l_approver_id := wf_engine.GetItemAttrNumber(p_item_type,
3728: p_item_key,
3729: 'APPROVER_ID');
3730:
3731: CheckFinalApprover(l_reason_code,
3831: p_result := 'COMPLETE:F';
3832: RETURN;
3833: END IF;
3834:
3835: wf_engine.SetItemAttrText(
3836: itemtype => c_item_type,
3837: itemkey => p_item_key,
3838: aname => 'CURRENT_HUB',
3839: avalue => c_receivable_transaction_type);
3923: g_debug_mesg := 'Find user in Receivable role who responded to
3924: the notification';
3925: -----------------------------------------------------------------
3926:
3927: l_notification_id := wf_engine.context_nid;
3928: l_approver_user_name := wf_engine.context_text;
3929:
3930: SELECT orig_system_id, display_name
3931: INTO l_approver_id, l_approver_display_name
3924: the notification';
3925: -----------------------------------------------------------------
3926:
3927: l_notification_id := wf_engine.context_nid;
3928: l_approver_user_name := wf_engine.context_text;
3929:
3930: SELECT orig_system_id, display_name
3931: INTO l_approver_id, l_approver_display_name
3932: FROM wf_users
3932: FROM wf_users
3933: WHERE orig_system = 'PER'
3934: AND name = l_approver_user_name;
3935:
3936: wf_engine.SetItemAttrText(p_item_type,
3937: p_item_key,
3938: 'APPROVER_ID',
3939: l_approver_id);
3940:
3937: p_item_key,
3938: 'APPROVER_ID',
3939: l_approver_id);
3940:
3941: wf_engine.SetItemAttrText(p_item_type,
3942: p_item_key,
3943: 'APPROVER_USER_NAME',
3944: l_approver_user_name);
3945:
3942: p_item_key,
3943: 'APPROVER_USER_NAME',
3944: l_approver_user_name);
3945:
3946: wf_engine.SetItemAttrText(p_item_type,
3947: p_item_key,
3948: 'APPROVER_DISPLAY_NAME',
3949: l_approver_display_name);
3950:
4030: --
4031: IF (p_funcmode = 'RUN') then
4032:
4033:
4034: l_document_id := wf_engine.GetItemAttrNumber(
4035: p_item_type,
4036: p_item_key,
4037: 'WORKFLOW_DOCUMENT_ID');
4038:
4036: p_item_key,
4037: 'WORKFLOW_DOCUMENT_ID');
4038:
4039: l_requestor_user_name
4040: := wf_engine.GetItemAttrText(
4041: p_item_type,
4042: p_item_key,
4043: 'REQUESTOR_USER_NAME');
4044:
4042: p_item_key,
4043: 'REQUESTOR_USER_NAME');
4044:
4045:
4046: l_reason_code := wf_engine.GetItemAttrText(
4047: p_item_type,
4048: p_item_key,
4049: 'REASON');
4050:
4049: 'REASON');
4050:
4051:
4052: l_total_credit_to_invoice
4053: := wf_engine.GetItemAttrNumber(
4054: p_item_type,
4055: p_item_key,
4056: 'TOTAL_CREDIT_TO_INVOICE');
4057:
4055: p_item_key,
4056: 'TOTAL_CREDIT_TO_INVOICE');
4057:
4058:
4059: l_customer_trx_id := wf_engine.GetItemAttrNumber(
4060: p_item_type,
4061: p_item_key,
4062: 'CUSTOMER_TRX_ID');
4063:
4060: p_item_type,
4061: p_item_key,
4062: 'CUSTOMER_TRX_ID');
4063:
4064: l_comments := wf_engine.GetItemAttrText(
4065: p_item_type,
4066: p_item_key,
4067: 'COMMENTS');
4068:
4066: p_item_key,
4067: 'COMMENTS');
4068:
4069: /*7367350 Retrieve internal comment*/
4070: l_internal_comment := wf_engine.GetItemAttrText(
4071: p_item_type,
4072: p_item_key,
4073: 'INTERNAL_COMMENTS');
4074:
4197: -- RUN mode - normal process execution
4198: --
4199: IF (p_funcmode = 'RUN') then
4200:
4201: l_document_id := wf_engine.GetItemAttrNumber(
4202: p_item_type,
4203: p_item_key,
4204: 'WORKFLOW_DOCUMENT_ID');
4205:
4202: p_item_type,
4203: p_item_key,
4204: 'WORKFLOW_DOCUMENT_ID');
4205:
4206: l_customer_trx_id := wf_engine.GetItemAttrNumber(
4207: p_item_type,
4208: p_item_key,
4209: 'CUSTOMER_TRX_ID');
4210:
4208: p_item_key,
4209: 'CUSTOMER_TRX_ID');
4210:
4211: l_approver_display_name
4212: := wf_engine.GetItemAttrText(
4213: p_item_type,
4214: p_item_key,
4215: 'APPROVER_DISPLAY_NAME');
4216:
4213: p_item_type,
4214: p_item_key,
4215: 'APPROVER_DISPLAY_NAME');
4216:
4217: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4218:
4219: fnd_message.set_name('AR', 'AR_WF_APPROVAL_REMINDER');
4220: fnd_message.set_token('APPROVER', l_approver_display_name);
4221: -- bug fix 1122477
4303: --
4304: IF (p_funcmode = 'RUN') then
4305:
4306:
4307: l_document_id := wf_engine.GetItemAttrNumber(
4308: p_item_type,
4309: p_item_key,
4310: 'WORKFLOW_DOCUMENT_ID');
4311:
4308: p_item_type,
4309: p_item_key,
4310: 'WORKFLOW_DOCUMENT_ID');
4311:
4312: l_customer_trx_id := wf_engine.GetItemAttrNumber(
4313: p_item_type,
4314: p_item_key,
4315: 'CUSTOMER_TRX_ID');
4316:
4314: p_item_key,
4315: 'CUSTOMER_TRX_ID');
4316:
4317: l_manager_user_name
4318: := wf_engine.GetItemAttrText(
4319: p_item_type,
4320: p_item_key,
4321: 'MANAGER_USER_NAME');
4322:
4319: p_item_type,
4320: p_item_key,
4321: 'MANAGER_USER_NAME');
4322:
4323: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4324:
4325: fnd_message.set_name('AR', 'AR_WF_APPROVAL_ESCALATION');
4326: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4327: fnd_message.set_token('APPROVER', l_manager_user_name);
4409: -- RUN mode - normal process execution
4410: --
4411: IF (p_funcmode = 'RUN') then
4412:
4413: l_document_id := wf_engine.GetItemAttrNumber(
4414: p_item_type,
4415: p_item_key,
4416: 'WORKFLOW_DOCUMENT_ID');
4417:
4414: p_item_type,
4415: p_item_key,
4416: 'WORKFLOW_DOCUMENT_ID');
4417:
4418: l_customer_trx_id := wf_engine.GetItemAttrNumber(
4419: p_item_type,
4420: p_item_key,
4421: 'CUSTOMER_TRX_ID');
4422:
4420: p_item_key,
4421: 'CUSTOMER_TRX_ID');
4422:
4423: l_receivable_role
4424: := wf_engine.GetItemAttrText(
4425: p_item_type,
4426: p_item_key,
4427: 'RECEIVABLE_ROLE');
4428: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4424: := wf_engine.GetItemAttrText(
4425: p_item_type,
4426: p_item_key,
4427: 'RECEIVABLE_ROLE');
4428: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4429: SELECT display_name INTO l_role_display_name
4430: FROM wf_roles
4431: WHERE name = l_receivable_role;
4432:
4530: restore_context(p_item_key);
4531: l_last_updated_by := ARP_GLOBAL.user_id;
4532: l_last_update_login := ARP_GLOBAL.last_update_login ;
4533:
4534: l_document_id := wf_engine.GetItemAttrNumber(
4535: p_item_type,
4536: p_item_key,
4537: 'WORKFLOW_DOCUMENT_ID');
4538:
4535: p_item_type,
4536: p_item_key,
4537: 'WORKFLOW_DOCUMENT_ID');
4538:
4539: l_customer_trx_id := wf_engine.GetItemAttrNumber(
4540: p_item_type,
4541: p_item_key,
4542: 'CUSTOMER_TRX_ID');
4543:
4541: p_item_key,
4542: 'CUSTOMER_TRX_ID');
4543:
4544: l_receivable_role
4545: := wf_engine.GetItemAttrText(
4546: p_item_type,
4547: p_item_key,
4548: 'RECEIVABLE_ROLE');
4549: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4545: := wf_engine.GetItemAttrText(
4546: p_item_type,
4547: p_item_key,
4548: 'RECEIVABLE_ROLE');
4549: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4550:
4551: SELECT display_name INTO l_role_display_name
4552: FROM wf_roles
4553: WHERE name = l_receivable_role;
4647: --
4648: IF (p_funcmode = 'RUN') then
4649:
4650:
4651: l_document_id := wf_engine.GetItemAttrNumber(
4652: p_item_type,
4653: p_item_key,
4654: 'WORKFLOW_DOCUMENT_ID');
4655:
4652: p_item_type,
4653: p_item_key,
4654: 'WORKFLOW_DOCUMENT_ID');
4655:
4656: l_customer_trx_id := wf_engine.GetItemAttrNumber(
4657: p_item_type,
4658: p_item_key,
4659: 'CUSTOMER_TRX_ID');
4660:
4658: p_item_key,
4659: 'CUSTOMER_TRX_ID');
4660:
4661: l_approver_display_name
4662: := wf_engine.GetItemAttrText(
4663: p_item_type,
4664: p_item_key,
4665: 'APPROVER_DISPLAY_NAME');
4666:
4663: p_item_type,
4664: p_item_key,
4665: 'APPROVER_DISPLAY_NAME');
4666:
4667: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4668:
4669: fnd_message.set_name('AR', 'AR_WF_REQUEST_APPROVAL');
4670: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4671: fnd_message.set_token('APPROVER', l_approver_display_name);
4766: --
4767: IF (p_funcmode = 'RUN') then
4768:
4769:
4770: l_document_id := wf_engine.GetItemAttrNumber(
4771: p_item_type,
4772: p_item_key,
4773: 'WORKFLOW_DOCUMENT_ID');
4774:
4771: p_item_type,
4772: p_item_key,
4773: 'WORKFLOW_DOCUMENT_ID');
4774:
4775: l_customer_trx_id := wf_engine.GetItemAttrNumber(
4776: p_item_type,
4777: p_item_key,
4778: 'CUSTOMER_TRX_ID');
4779:
4777: p_item_key,
4778: 'CUSTOMER_TRX_ID');
4779:
4780: l_approver_display_name
4781: := wf_engine.GetItemAttrText(
4782: p_item_type,
4783: p_item_key,
4784: 'APPROVER_DISPLAY_NAME');
4785: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4781: := wf_engine.GetItemAttrText(
4782: p_item_type,
4783: p_item_key,
4784: 'APPROVER_DISPLAY_NAME');
4785: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4786:
4787:
4788: fnd_message.set_name('AR', 'AR_WF_APPROVED_RESPONSE');
4789: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4823: arp_standard.debug('InsertApprovedResponseNotes: ' || g_debug_mesg);
4824: END IF;
4825: ---------------------------------------------------------------------------
4826:
4827: wf_engine.SetItemAttrText(
4828: itemtype => p_item_type,
4829: itemkey => p_item_key,
4830: aname => 'CURRENT_HUB',
4831: avalue => c_approvals_transaction_type);
4919: -- RUN mode - normal process execution
4920: --
4921: IF (p_funcmode = 'RUN') then
4922:
4923: l_document_id := wf_engine.GetItemAttrNumber(
4924: p_item_type,
4925: p_item_key,
4926: 'WORKFLOW_DOCUMENT_ID');
4927:
4924: p_item_type,
4925: p_item_key,
4926: 'WORKFLOW_DOCUMENT_ID');
4927:
4928: l_customer_trx_id := wf_engine.GetItemAttrNumber(
4929: p_item_type,
4930: p_item_key,
4931: 'CUSTOMER_TRX_ID');
4932:
4930: p_item_key,
4931: 'CUSTOMER_TRX_ID');
4932:
4933: l_approver_display_name
4934: := wf_engine.GetItemAttrText(
4935: p_item_type,
4936: p_item_key,
4937: 'APPROVER_DISPLAY_NAME');
4938:
4935: p_item_type,
4936: p_item_key,
4937: 'APPROVER_DISPLAY_NAME');
4938:
4939: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4940:
4941: fnd_message.set_name('AR', 'AR_WF_REJECTED_RESPONSE');
4942: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4943: fnd_message.set_token('APPROVER', l_approver_display_name);
4987: arp_standard.debug('InsertRejectedResponseNotes: ' || g_debug_mesg);
4988: END IF;
4989: -------------------------------------------------------------------------
4990:
4991: wf_engine.SetItemAttrText(
4992: itemtype => p_item_type,
4993: itemkey => p_item_key,
4994: aname => 'CURRENT_HUB',
4995: avalue => c_approvals_transaction_type);
5064: --
5065: IF (p_funcmode = 'RUN') then
5066:
5067:
5068: l_document_id := wf_engine.GetItemAttrNumber(
5069: p_item_type,
5070: p_item_key,
5071: 'WORKFLOW_DOCUMENT_ID');
5072:
5069: p_item_type,
5070: p_item_key,
5071: 'WORKFLOW_DOCUMENT_ID');
5072:
5073: l_credit_memo_number := wf_engine.GetItemAttrText(
5074: p_item_type,
5075: p_item_key,
5076: 'CREDIT_MEMO_NUMBER');
5077:
5074: p_item_type,
5075: p_item_key,
5076: 'CREDIT_MEMO_NUMBER');
5077:
5078: l_customer_trx_id := wf_engine.GetItemAttrNumber(
5079: p_item_type,
5080: p_item_key,
5081: 'CUSTOMER_TRX_ID');
5082:
5079: p_item_type,
5080: p_item_key,
5081: 'CUSTOMER_TRX_ID');
5082:
5083: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
5084: /* Get trx number for CM and the insert into note text */
5085:
5086:
5087: fnd_message.set_name('AR', 'AR_WF_COMPLETED_SUCCESSFUL');
5177: -- RUN mode - normal process execution
5178: --
5179: IF (p_funcmode = 'RUN') then
5180:
5181: l_reason_code := wf_engine.GetItemAttrText(
5182: p_item_type,
5183: p_item_key,
5184: 'REASON');
5185:
5182: p_item_type,
5183: p_item_key,
5184: 'REASON');
5185:
5186: l_currency_code := wf_engine.GetItemAttrText(
5187: p_item_type,
5188: p_item_key,
5189: 'CURRENCY_CODE');
5190:
5188: p_item_key,
5189: 'CURRENCY_CODE');
5190:
5191: l_entered_amount_display
5192: := wf_engine.GetItemAttrNumber(
5193: p_item_type,
5194: p_item_key,
5195: 'ENTERED_AMOUNT_DISPLAY');
5196:
5193: p_item_type,
5194: p_item_key,
5195: 'ENTERED_AMOUNT_DISPLAY');
5196:
5197: l_customer_id := wf_engine.GetItemAttrNumber(
5198: p_item_type,
5199: p_item_key,
5200: 'CUSTOMER_ID');
5201:
5198: p_item_type,
5199: p_item_key,
5200: 'CUSTOMER_ID');
5201:
5202: l_collector_id := wf_engine.GetItemAttrNumber(
5203: p_item_type,
5204: p_item_key,
5205: 'COLLECTOR_ID');
5206:
5204: p_item_key,
5205: 'COLLECTOR_ID');
5206:
5207:
5208: l_customer_trx_id := wf_engine.GetItemAttrNumber(
5209: p_item_type,
5210: p_item_key,
5211: 'CUSTOMER_TRX_ID');
5212:
5209: p_item_type,
5210: p_item_key,
5211: 'CUSTOMER_TRX_ID');
5212:
5213: l_bill_to_site_use_id := wf_engine.GetItemAttrNumber(
5214: p_item_type,
5215: p_item_key,
5216: 'BILL_TO_SITE_USE_ID');
5217:
5409: l_last_update_login := ARP_GLOBAL.last_update_login ;
5410:
5411: -- call transaction API here
5412:
5413: l_customer_trx_id := wf_engine.GetItemAttrNumber(
5414: p_item_type,
5415: p_item_key,
5416: 'CUSTOMER_TRX_ID');
5417:
5414: p_item_type,
5415: p_item_key,
5416: 'CUSTOMER_TRX_ID');
5417:
5418: l_amount := wf_engine.GetItemAttrNumber(
5419: p_item_type,
5420: p_item_key,
5421: 'ORIGINAL_TOTAL');
5422:
5419: p_item_type,
5420: p_item_key,
5421: 'ORIGINAL_TOTAL');
5422:
5423: l_request_id := wf_engine.GetItemAttrNumber(
5424: p_item_type,
5425: p_item_key,
5426: 'WORKFLOW_DOCUMENT_ID');
5427:
5424: p_item_type,
5425: p_item_key,
5426: 'WORKFLOW_DOCUMENT_ID');
5427:
5428: l_batch_source_name := wf_engine.GetItemAttrText(
5429: p_item_type,
5430: p_item_key,
5431: 'BATCH_SOURCE_NAME');
5432:
5430: p_item_key,
5431: 'BATCH_SOURCE_NAME');
5432:
5433:
5434: l_credit_method_installments := wf_engine.GetItemAttrText(
5435: p_item_type,
5436: p_item_key,
5437: 'CREDIT_INSTALLMENT_RULE');
5438:
5435: p_item_type,
5436: p_item_key,
5437: 'CREDIT_INSTALLMENT_RULE');
5438:
5439: l_credit_method_rules := wf_engine.GetItemAttrText(
5440: p_item_type,
5441: p_item_key,
5442: 'CREDIT_ACCOUNTING_RULE');
5443:
5450:
5451: fnd_message.set_name('AR', 'AR_WF_NO_BATCH');
5452: l_cm_creation_error := fnd_message.get;
5453:
5454: wf_engine.SetItemAttrText(p_item_type,
5455: p_item_key,
5456: 'CM_CREATION_ERROR',
5457: l_cm_creation_error);
5458:
5495: EXCEPTION
5496: WHEN OTHERS THEN
5497: p_result := 'COMPLETE:F';
5498: l_cm_creation_error := 'Could not find the request';
5499: wf_engine.SetItemAttrText(p_item_type,
5500: p_item_key,
5501: 'CM_CREATION_ERROR',
5502: l_cm_creation_error);
5503: RETURN;
5539: SELECT trx_number INTO l_credit_memo_number
5540: FROM ra_customer_trx
5541: WHERE customer_trx_id = l_credit_memo_id;
5542:
5543: wf_engine.SetItemAttrText(p_item_type,
5544: p_item_key,
5545: 'CREDIT_MEMO_NUMBER',
5546: l_credit_memo_number);
5547:
5548: EXCEPTION
5549: WHEN OTHERS THEN
5550: p_result := 'COMPLETE:F';
5551: l_cm_creation_error := 'Could not find the credit memo';
5552: wf_engine.SetItemAttrText(p_item_type,
5553: p_item_key,
5554: 'CM_CREATION_ERROR',
5555: l_cm_creation_error);
5556: RETURN;
5564: l_cm_creation_error := l_cm_creation_error ||
5565: l_error_tab(i).translated_message || CRLF;
5566: END LOOP;
5567:
5568: wf_engine.SetItemAttrText(p_item_type,
5569: p_item_key,
5570: 'CM_CREATION_ERROR',
5571: l_cm_creation_error);
5572:
5693: ------------------------------------------------------------
5694: g_debug_mesg := 'Get the user value of rules';
5695: ------------------------------------------------------------
5696:
5697: l_customer_trx_id := wf_engine.GetItemAttrNumber(
5698: p_item_type,
5699: p_item_key,
5700: 'CUSTOMER_TRX_ID');
5701:
5698: p_item_type,
5699: p_item_key,
5700: 'CUSTOMER_TRX_ID');
5701:
5702: l_credit_installment_rule := wf_engine.GetItemAttrText(
5703: p_item_type,
5704: p_item_key,
5705: 'CREDIT_INSTALLMENT_RULE');
5706:
5703: p_item_type,
5704: p_item_key,
5705: 'CREDIT_INSTALLMENT_RULE');
5706:
5707: l_credit_accounting_rule := wf_engine.GetItemAttrText(
5708: p_item_type,
5709: p_item_key,
5710: 'CREDIT_ACCOUNTING_RULE');
5711:
5708: p_item_type,
5709: p_item_key,
5710: 'CREDIT_ACCOUNTING_RULE');
5711:
5712: l_invalid_rule_value := wf_engine.GetItemAttrText(
5713: p_item_type,
5714: p_item_key,
5715: 'INVALID_RULE_VALUE');
5716:
5713: p_item_type,
5714: p_item_key,
5715: 'INVALID_RULE_VALUE');
5716:
5717: l_invalid_rule_mesg := wf_engine.GetItemAttrText(
5718: p_item_type,
5719: p_item_key,
5720: 'INVALID_RULE_MESG');
5721:
5732: IF l_count > 1 then
5733:
5734: IF l_credit_installment_rule not in ('LIFO', 'FIFO', 'PRORATE') then
5735: -- invalid credit method
5736: wf_engine.SetItemAttrText(p_item_type,
5737: p_item_key,
5738: 'INVALID_RULE_MESG',
5739: l_invalid_rule_value);
5740: p_result := 'COMPLETE:F';
5750: IF l_invoicing_rule_id is not NULL then
5751:
5752: IF l_credit_accounting_rule not in ('LIFO', 'PRORATE','UNIT') THEN
5753: -- invalid credit method
5754: wf_engine.SetItemAttrText(p_item_type,
5755: p_item_key,
5756: 'INVALID_RULE_MESG',
5757: l_invalid_rule_value);
5758: p_result := 'COMPLETE:F';
5763: -- the credit methods are valid
5764: IF l_invalid_rule_mesg is NOT NULL THEN
5765:
5766: l_invalid_rule_mesg := NULL;
5767: wf_engine.SetItemAttrText(p_item_type,
5768: p_item_key,
5769: 'INVALID_RULE_MESG',
5770: l_invalid_rule_mesg);
5771: END if;
5854: IF (p_funcmode = 'RUN') THEN
5855:
5856: restore_context(p_item_key);
5857:
5858: l_customer_trx_id := wf_engine.GetItemAttrNumber(
5859: itemtype => p_item_type,
5860: itemkey => p_item_key,
5861: aname => 'CUSTOMER_TRX_ID');
5862:
5874: p_result := 'COMPLETE:N';
5875: RETURN;
5876: END IF;
5877:
5878: wf_engine.SetItemAttrText(
5879: itemtype =>p_item_type,
5880: itemkey => p_item_key,
5881: aname => 'SALESREP_USER_NAME',
5882: avalue => l_user_name);
5880: itemkey => p_item_key,
5881: aname => 'SALESREP_USER_NAME',
5882: avalue => l_user_name);
5883:
5884: l_requestor_user_name := wf_engine.GetItemAttrText(
5885: itemtype => p_item_type,
5886: itemkey => p_item_key,
5887: aname => 'REQUESTOR_USER_NAME');
5888:
5936: arp_standard.debug('check_first_approver: ' || g_debug_mesg);
5937: END IF;
5938: ----------------------------------------------------------
5939:
5940: l_approval_path := wf_engine.getitemattrtext(
5941: itemtype => p_item_type,
5942: itemkey => p_item_key,
5943: aname => 'APPROVAL_PATH');
5944:
5941: itemtype => p_item_type,
5942: itemkey => p_item_key,
5943: aname => 'APPROVAL_PATH');
5944:
5945: l_approver_user_name := wf_engine.GetItemAttrText(
5946: itemtype => p_item_type,
5947: itemkey => p_item_key,
5948: aname => 'ROLE');
5949:
6021: arp_standard.debug('on_account_credit_memo: ' || g_debug_mesg);
6022: END IF;
6023: ----------------------------------------------------------
6024:
6025: l_credit_memo_number := wf_engine.getitemattrtext(
6026: itemtype => p_item_type,
6027: itemkey => p_item_key,
6028: aname => 'CREDIT_MEMO_NUMBER');
6029:
6084: IF (p_funcmode = 'RUN') THEN
6085:
6086: restore_context(p_item_key);
6087:
6088: l_requestor_user_name := wf_engine.GetItemAttrText(
6089: itemtype => p_item_type,
6090: itemkey => p_item_key,
6091: aname => 'REQUESTOR_USER_NAME');
6092:
6089: itemtype => p_item_type,
6090: itemkey => p_item_key,
6091: aname => 'REQUESTOR_USER_NAME');
6092:
6093: l_collector_user_name := wf_engine.GetItemAttrText(
6094: itemtype => p_item_type,
6095: itemkey => p_item_key,
6096: aname => 'COLLECTOR_USER_NAME');
6097:
6148: IF (p_funcmode = 'RUN') THEN
6149:
6150: l_profile_value := NVL(fnd_profile.value('AR_CMWF_TIME_OUT'), 'MANAGER');
6151:
6152: wf_engine.setitemattrtext(
6153: itemtype => p_item_type,
6154: itemkey => p_item_key,
6155: aname => 'DEBUG',
6156: avalue => 'Profile: ' || l_profile_value);
6162: -- proceed in that direction. To do that all we need to is flag
6163: -- that we are in the timeout mode and simply put a value of "N"
6164: -- (next) in the result attribute.
6165:
6166: wf_engine.setitemattrtext(
6167: itemtype => p_item_type,
6168: itemkey => p_item_key,
6169: aname => 'TIMEOUT_OCCURRED',
6170: avalue => 'Y');