[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:
155: OPEN c;
156: FETCH c INTO l_org_id;
157: CLOSE c;
158:
159: wf_engine.SetItemAttrNumber(
160: itemtype => c_item_type,
161: itemkey => p_item_key,
162: aname => 'ORG_ID',
163: avalue => l_org_id);
232: arp_standard.debug('VALIDATE_FIRST_APPROVER: ' || g_debug_mesg);
233: END IF;
234: ----------------------------------------------------------
235:
236: l_employee_id := wf_engine.getitemattrnumber(
237: itemtype => c_item_type,
238: itemkey => p_item_key,
239: aname => 'NON_DEFAULT_START_PERSON_ID');
240:
257: FETCH mgr INTO l_manager_employee_id;
258: CLOSE mgr;
259:
260: -- now set the manager as the first approver.
261: wf_engine.setitemattrnumber(
262: itemtype => c_item_type,
263: itemkey => p_item_key,
264: aname => 'NON_DEFAULT_START_PERSON_ID',
265: avalue => l_manager_employee_id);
471: l_approver_display_name);
472:
473: IF l_approver_user_name IS NOT NULL THEN
474:
475: wf_engine.SetItemAttrNumber(p_item_type,
476: p_item_key,
477: 'APPROVER_ID',
478: p_user_id);
479:
476: p_item_key,
477: 'APPROVER_ID',
478: p_user_id);
479:
480: wf_engine.SetItemAttrText(p_item_type,
481: p_item_key,
482: 'APPROVER_USER_NAME',
483: l_approver_user_name);
484:
481: p_item_key,
482: 'APPROVER_USER_NAME',
483: l_approver_user_name);
484:
485: wf_engine.SetItemAttrText(p_item_type,
486: p_item_key,
487: 'APPROVER_DISPLAY_NAME',
488: l_approver_display_name);
489:
532: l_responder_display_name wf_users.display_name%TYPE;
533:
534: BEGIN
535:
536: l_responder_user_name := wf_engine.context_text;
537:
538: OPEN c(l_responder_user_name);
539: FETCH c INTO l_responder_user_id;
540: CLOSE c;
547: IF p_funcmode = 'TRANSFER' OR p_funcmode = 'FORWARD' THEN
548:
549: -- insert the reassignment note here
550:
551: l_document_id := wf_engine.GetItemAttrNumber(
552: itemtype => p_item_type,
553: itemkey => p_item_key,
554: aname => 'WORKFLOW_DOCUMENT_ID');
555:
552: itemtype => p_item_type,
553: itemkey => p_item_key,
554: aname => 'WORKFLOW_DOCUMENT_ID');
555:
556: l_customer_trx_id := wf_engine.GetItemAttrNumber(
557: itemtype => p_item_type,
558: itemkey => p_item_key,
559: aname => 'CUSTOMER_TRX_ID');
560:
574: x_note_id => l_note_id);
575:
576: ELSIF (p_funcmode = 'RESPOND') THEN
577:
578: wf_engine.setitemattrtext(
579: itemtype => p_item_type,
580: itemkey => p_item_key,
581: aname => 'DEBUG',
582: avalue => '2: ' || l_responder_user_name);
582: avalue => '2: ' || l_responder_user_name);
583:
584: -- insert the reassignment note here
585:
586: wf_engine.SetItemAttrNumber(
587: itemtype => p_item_type,
588: itemkey => p_item_key,
589: aname => 'APPROVER_ID',
590: avalue => l_responder_user_id);
588: itemkey => p_item_key,
589: aname => 'APPROVER_ID',
590: avalue => l_responder_user_id);
591:
592: wf_engine.SetItemAttrText(
593: itemtype => p_item_type,
594: itemkey => p_item_key,
595: aname => 'APPROVER_USER_NAME',
596: avalue => l_responder_user_name);
594: itemkey => p_item_key,
595: aname => 'APPROVER_USER_NAME',
596: avalue => l_responder_user_name);
597:
598: wf_engine.SetItemAttrText(
599: itemtype => p_item_type,
600: itemkey => p_item_key,
601: aname => 'APPROVER_DISPLAY_NAME',
602: avalue => l_responder_display_name);
632: arp_standard.debug('CheckUserInTable: ' || g_debug_mesg);
633: END IF;
634: ----------------------------------------------------------
635:
636: l_reason_code := wf_engine.GetItemAttrText(
637: p_item_type,
638: p_item_key,
639: 'REASON');
640:
637: p_item_type,
638: p_item_key,
639: 'REASON');
640:
641: l_currency_code := wf_engine.GetItemAttrText(
642: p_item_type,
643: p_item_key,
644: 'CURRENCY_CODE');
645:
747: END IF;
748:
749: END IF;
750:
751: wf_engine.SetItemAttrNumber(
752: itemtype => p_item_type,
753: itemkey => p_item_key,
754: aname => 'PERSON_ID',
755: avalue => l_approver_employee_id);
797: l_next_approver ame_util.approverrecord;
798:
799: BEGIN
800:
801: l_transaction_type := wf_engine.GetItemAttrText(
802: itemtype => p_item_type,
803: itemkey => p_item_key,
804: aname => 'CURRENT_HUB');
805:
880: l_manager_employee_id fnd_user.employee_id%TYPE;
881:
882: BEGIN
883:
884: l_manager_employee_id := wf_engine.getitemattrnumber(
885: itemtype => p_item_type,
886: itemkey => p_item_key,
887: aname => 'MANAGER_ID');
888:
911:
912: g_debug_mesg := 'Retrieved the next approver';
913:
914: -- reset the scalation related attributes.
915: wf_engine.setitemattrnumber(
916: itemtype => p_item_type,
917: itemkey => p_item_key,
918: aname => 'MANAGER_ID',
919: avalue => -9999);
917: itemkey => p_item_key,
918: aname => 'MANAGER_ID',
919: avalue => -9999);
920:
921: wf_engine.setitemattrnumber(
922: itemtype => p_item_type,
923: itemkey => p_item_key,
924: aname => 'ESCALATION_COUNT',
925: avalue => 0);
1029: );
1030:
1031: IF l_customer_trx_id <> -1 then
1032:
1033: wf_engine.SetItemAttrNumber(
1034: p_item_type,
1035: p_item_key,
1036: 'WORKFLOW_DOCUMENT_ID',
1037: l_workflow_document_id);
1035: p_item_key,
1036: 'WORKFLOW_DOCUMENT_ID',
1037: l_workflow_document_id);
1038:
1039: wf_engine.SetItemAttrNumber(
1040: p_item_type,
1041: p_item_key,
1042: 'CUSTOMER_TRX_ID',
1043: l_customer_trx_id);
1041: p_item_key,
1042: 'CUSTOMER_TRX_ID',
1043: l_customer_trx_id);
1044:
1045: wf_engine.SetItemAttrNumber(
1046: p_item_type,
1047: p_item_key,
1048: 'TOTAL_CREDIT_TO_INVOICE',
1049: l_amount);
1047: p_item_key,
1048: 'TOTAL_CREDIT_TO_INVOICE',
1049: l_amount);
1050:
1051: wf_engine.SetItemAttrNumber(
1052: p_item_type,
1053: p_item_key,
1054: 'TOTAL_CREDIT_TO_LINES',
1055: l_line_amount);
1053: p_item_key,
1054: 'TOTAL_CREDIT_TO_LINES',
1055: l_line_amount);
1056:
1057: wf_engine.SetItemAttrNumber(
1058: p_item_type,
1059: p_item_key,
1060: 'TOTAL_CREDIT_TO_TAX',
1061: l_tax_amount);
1059: p_item_key,
1060: 'TOTAL_CREDIT_TO_TAX',
1061: l_tax_amount);
1062:
1063: wf_engine.SetItemAttrNumber(
1064: p_item_type,
1065: p_item_key,
1066: 'TOTAL_CREDIT_TO_FREIGHT',
1067: l_freight_amount);
1065: p_item_key,
1066: 'TOTAL_CREDIT_TO_FREIGHT',
1067: l_freight_amount);
1068:
1069: wf_engine.SetItemAttrText(
1070: p_item_type,
1071: p_item_key,
1072: 'REASON',
1073: l_reason_code);
1071: p_item_key,
1072: 'REASON',
1073: l_reason_code);
1074:
1075: wf_engine.SetItemAttrText(
1076: p_item_type,
1077: p_item_key,
1078: 'REASON_MEANING',
1079: l_reason_meaning);
1077: p_item_key,
1078: 'REASON_MEANING',
1079: l_reason_meaning);
1080:
1081: wf_engine.SetItemAttrText(
1082: p_item_type,
1083: p_item_key,
1084: 'COMMENTS',
1085: l_comments);
1083: p_item_key,
1084: 'COMMENTS',
1085: l_comments);
1086:
1087: wf_engine.SetItemAttrNumber(
1088: p_item_type,
1089: p_item_key,
1090: 'REQUESTOR_ID',
1091: l_requestor_id);
1089: p_item_key,
1090: 'REQUESTOR_ID',
1091: l_requestor_id);
1092:
1093: wf_engine.SetItemAttrText(
1094: p_item_type,
1095: p_item_key,
1096: 'ORIG_TRX_NUMBER',
1097: l_orig_trx_number);
1095: p_item_key,
1096: 'ORIG_TRX_NUMBER',
1097: l_orig_trx_number);
1098:
1099: wf_engine.SetItemAttrText(
1100: p_item_type,
1101: p_item_key,
1102: 'TAX_EX_CERT_NUM',
1103: l_tax_ex_cert_num);
1101: p_item_key,
1102: 'TAX_EX_CERT_NUM',
1103: l_tax_ex_cert_num);
1104:
1105: wf_engine.SetItemAttrText(
1106: p_item_type,
1107: p_item_key,
1108: 'INTERNAL_COMMENTS',
1109: l_internal_comment);
1124: END if;
1125: END if;
1126: END if;
1127:
1128: wf_engine.SetItemAttrText(
1129: p_item_type,
1130: p_item_key,
1131: 'REQUESTOR_USER_NAME',
1132: l_requestor_user_name);
1130: p_item_key,
1131: 'REQUESTOR_USER_NAME',
1132: l_requestor_user_name);
1133:
1134: wf_engine.SetItemAttrText(
1135: p_item_type,
1136: p_item_key,
1137: 'REQUESTOR_DISPLAY_NAME',
1138: l_requestor_display_name);
1148: l_original_freight_amount,
1149: l_original_total ,
1150: l_currency_code);
1151:
1152: wf_engine.SetItemAttrNumber(
1153: p_item_type,
1154: p_item_key,
1155: 'ORIGINAL_LINE_AMOUNT',
1156: l_original_line_amount);
1154: p_item_key,
1155: 'ORIGINAL_LINE_AMOUNT',
1156: l_original_line_amount);
1157:
1158: wf_engine.SetItemAttrNumber(
1159: p_item_type,
1160: p_item_key,
1161: 'ORIGINAL_TAX_AMOUNT',
1162: l_original_tax_amount);
1160: p_item_key,
1161: 'ORIGINAL_TAX_AMOUNT',
1162: l_original_tax_amount);
1163:
1164: wf_engine.SetItemAttrNumber(
1165: p_item_type,
1166: p_item_key,
1167: 'ORIGINAL_FREIGHT_AMOUNT',
1168: l_original_freight_amount);
1166: p_item_key,
1167: 'ORIGINAL_FREIGHT_AMOUNT',
1168: l_original_freight_amount);
1169:
1170: wf_engine.SetItemAttrNumber(
1171: p_item_type,
1172: p_item_key,
1173: 'ORIGINAL_TOTAL',
1174: l_original_total);
1172: p_item_key,
1173: 'ORIGINAL_TOTAL',
1174: l_original_total);
1175:
1176: wf_engine.SetItemAttrText(
1177: p_item_type,
1178: p_item_key,
1179: 'CURRENCY_CODE',
1180: l_currency_code);
1327: fnd_message.set_name('AR', 'ARW_INV_MSG10');
1328: l_tax_disclaimer := fnd_message.get;
1329: END IF;
1330:
1331: wf_engine.SetItemAttrText(p_item_type,
1332: p_item_key,
1333: 'TAX_DISCLAIMER',
1334: l_tax_disclaimer);
1335:
1465:
1466: ------------------------------------------------------------
1467: g_debug_mesg := 'Get requested trx id ';
1468: ------------------------------------------------------------
1469: l_customer_trx_id := wf_engine.GetItemAttrNumber(
1470: p_item_type,
1471: p_item_key,
1472: 'CUSTOMER_TRX_ID');
1473:
1495: ----------------------------------------------------------------------
1496: g_debug_mesg := 'Set value for customer_id(name) in workflow process';
1497: -----------------------------------------------------------------------
1498:
1499: wf_engine.SetItemAttrNumber(p_item_type,
1500: p_item_key,
1501: 'CUSTOMER_ID',
1502: l_customer_id);
1503:
1501: 'CUSTOMER_ID',
1502: l_customer_id);
1503:
1504:
1505: wf_engine.SetItemAttrText(p_item_type,
1506: p_item_key,
1507: 'CUSTOMER_NAME',
1508: l_bill_to_customer_name);
1509:
1508: l_bill_to_customer_name);
1509:
1510: -- set the bill to and ship to customer info.
1511:
1512: wf_engine.SetItemAttrText(p_item_type,
1513: p_item_key,
1514: 'BILL_TO_CUSTOMER_NAME',
1515: l_bill_to_customer_name);
1516:
1515: l_bill_to_customer_name);
1516:
1517: -- Bug Fix 1882580. Since l_bill_to_customer_number is changed
1518: -- from number to VARCHAR2, replaced the function in call to
1519: -- wf_engine fom SetItemAttrNumber to SetItemAttrText
1520:
1521: wf_engine.SetItemAttrText(p_item_type,
1522: p_item_key,
1523: 'BILL_TO_CUSTOMER_NUMBER',
1517: -- Bug Fix 1882580. Since l_bill_to_customer_number is changed
1518: -- from number to VARCHAR2, replaced the function in call to
1519: -- wf_engine fom SetItemAttrNumber to SetItemAttrText
1520:
1521: wf_engine.SetItemAttrText(p_item_type,
1522: p_item_key,
1523: 'BILL_TO_CUSTOMER_NUMBER',
1524: l_bill_to_customer_number);
1525:
1522: p_item_key,
1523: 'BILL_TO_CUSTOMER_NUMBER',
1524: l_bill_to_customer_number);
1525:
1526: wf_engine.SetItemAttrText(p_item_type,
1527: p_item_key,
1528: 'SHIP_TO_CUSTOMER_NAME',
1529: l_ship_to_customer_name);
1530:
1529: l_ship_to_customer_name);
1530:
1531: -- Bug Fix 1882580. Since l_bill_to_customer_number is changed
1532: -- from number to VARCHAR2, replaced the function in call to
1533: -- wf_engine fom SetItemAttrNumber to SetItemAttrText
1534:
1535: wf_engine.SetItemAttrText(p_item_type,
1536: p_item_key,
1537: 'SHIP_TO_CUSTOMER_NUMBER',
1531: -- Bug Fix 1882580. Since l_bill_to_customer_number is changed
1532: -- from number to VARCHAR2, replaced the function in call to
1533: -- wf_engine fom SetItemAttrNumber to SetItemAttrText
1534:
1535: wf_engine.SetItemAttrText(p_item_type,
1536: p_item_key,
1537: 'SHIP_TO_CUSTOMER_NUMBER',
1538: l_ship_to_customer_number);
1539:
1538: l_ship_to_customer_number);
1539:
1540: -- set the trx number
1541:
1542: wf_engine.SetItemAttrText(p_item_type,
1543: p_item_key,
1544: 'TRX_NUMBER',
1545: l_trx_number);
1546:
1548:
1549: ----------------------------------------------------------------------
1550: g_debug_mesg := 'Set value for bill_to_site_use_id in workflow process';
1551: -----------------------------------------------------------------------
1552: wf_engine.SetItemAttrNumber(p_item_type,
1553: p_item_key,
1554: 'BILL_TO_SITE_USE_ID',
1555: l_bill_to_site_use_id);
1556:
1557:
1558:
1559: -- set the URL site
1560:
1561: l_request_id := wf_engine.GetItemAttrNumber(
1562: p_item_type,
1563: p_item_key,
1564: 'WORKFLOW_DOCUMENT_ID');
1565:
1566: OPEN c;
1567: FETCH c INTO l_request_url, l_trans_url, l_act_url;
1568: CLOSE c;
1569:
1570: wf_engine.SetItemAttrText(p_item_type,
1571: p_item_key,
1572: 'REQUEST_URL',
1573: l_request_url);
1574:
1571: p_item_key,
1572: 'REQUEST_URL',
1573: l_request_url);
1574:
1575: wf_engine.SetItemAttrText(p_item_type,
1576: p_item_key,
1577: 'TRANSACTION_NUMBER_URL',
1578: l_trans_url);
1579:
1576: p_item_key,
1577: 'TRANSACTION_NUMBER_URL',
1578: l_trans_url);
1579:
1580: wf_engine.SetItemAttrText(p_item_type,
1581: p_item_key,
1582: 'TRANSACTION_ACTIVITY_URL',
1583: l_act_url);
1584:
1746: -----------------------------------------------------------------
1747: g_debug_mesg := 'Get the value of customer_trx_id(customer id)';
1748: -----------------------------------------------------------------
1749:
1750: l_customer_trx_id := wf_engine.GetItemAttrNumber(
1751: itemtype => p_item_type,
1752: itemkey => p_item_key,
1753: aname => 'CUSTOMER_TRX_ID');
1754:
1751: itemtype => p_item_type,
1752: itemkey => p_item_key,
1753: aname => 'CUSTOMER_TRX_ID');
1754:
1755: l_customer_id := wf_engine.getitemattrnumber(
1756: itemtype => p_item_type,
1757: itemkey => p_item_key,
1758: aname => 'CUSTOMER_ID');
1759:
1760: ----------------------------------------------------------------------
1761: g_debug_mesg := 'get value of bill_to_site_use_id from workflow process';
1762: -----------------------------------------------------------------------
1763:
1764: l_bill_to_site_use_id := wf_engine.getitemattrnumber(
1765: itemtype => p_item_type,
1766: itemkey => p_item_key,
1767: aname => 'BILL_TO_SITE_USE_ID');
1768:
1783: p_result := 'COMPLETE:F';
1784: RETURN;
1785: END IF;
1786:
1787: wf_engine.SetItemAttrText(
1788: itemtype => p_item_type,
1789: itemkey => p_item_key,
1790: aname => 'CURRENT_HUB',
1791: avalue => c_collector_transaction_type);
1797: ----------------------------------------------------------------
1798: g_debug_mesg := 'Set value for collector in workflow process';
1799: ----------------------------------------------------------------
1800:
1801: wf_engine.SetItemAttrNumber(
1802: itemtype => p_item_type,
1803: itemkey => p_item_key,
1804: aname => 'COLLECTOR_EMPLOYEE_ID',
1805: avalue => l_collector_employee_id);
1803: itemkey => p_item_key,
1804: aname => 'COLLECTOR_EMPLOYEE_ID',
1805: avalue => l_collector_employee_id);
1806:
1807: wf_engine.SetItemAttrNumber(
1808: itemtype => p_item_type,
1809: itemkey => p_item_key,
1810: aname => 'COLLECTOR_ID',
1811: avalue => l_collector_id);
1809: itemkey => p_item_key,
1810: aname => 'COLLECTOR_ID',
1811: avalue => l_collector_id);
1812:
1813: wf_engine.SetItemAttrText(
1814: itemtype => p_item_type,
1815: itemkey => p_item_key,
1816: aname => 'COLLECTOR_NAME',
1817: avalue => l_collector_name);
1833: -----------------------------------------------------------------
1834: p_result := 'COMPLETE:F';
1835: RETURN;
1836: ELSE
1837: wf_engine.SetItemAttrText(
1838: itemtype => p_item_type,
1839: itemkey => p_item_key,
1840: aname => 'COLLECTOR_USER_NAME',
1841: avalue => l_collector_user_name);
1839: itemkey => p_item_key,
1840: aname => 'COLLECTOR_USER_NAME',
1841: avalue => l_collector_user_name);
1842:
1843: wf_engine.SetItemAttrText(
1844: itemtype => p_item_type,
1845: itemkey => p_item_key,
1846: aname => 'COLLECTOR_DISPLAY_NAME',
1847: avalue => l_collector_display_name);
1845: itemkey => p_item_key,
1846: aname => 'COLLECTOR_DISPLAY_NAME',
1847: avalue => l_collector_display_name);
1848:
1849: wf_engine.SetItemAttrText(
1850: itemtype => p_item_type,
1851: itemkey => p_item_key,
1852: aname => 'APPROVER_ID',
1853: avalue => l_collector_user_id);
1851: itemkey => p_item_key,
1852: aname => 'APPROVER_ID',
1853: avalue => l_collector_user_id);
1854:
1855: wf_engine.SetItemAttrText(
1856: itemtype => p_item_type,
1857: itemkey => p_item_key,
1858: aname => 'APPROVER_USER_NAME',
1859: avalue => l_collector_user_name);
1857: itemkey => p_item_key,
1858: aname => 'APPROVER_USER_NAME',
1859: avalue => l_collector_user_name);
1860:
1861: wf_engine.SetItemAttrText(
1862: itemtype => p_item_type,
1863: itemkey => p_item_key,
1864: aname => 'APPROVER_DISPLAY_NAME',
1865: avalue => l_collector_display_name);
1957:
1958: -- Bug 991922 : check if message body needs to say rule is required
1959: -- get additional info to determine if rule is required
1960:
1961: l_customer_trx_id := wf_engine.getitemattrnumber(
1962: itemtype => p_item_type,
1963: itemkey => p_item_key,
1964: aname => 'CUSTOMER_TRX_ID');
1965:
1962: itemtype => p_item_type,
1963: itemkey => p_item_key,
1964: aname => 'CUSTOMER_TRX_ID');
1965:
1966: l_credit_accounting_rule := wf_engine.getitemattrtext(
1967: itemtype => p_item_type,
1968: itemkey => p_item_key,
1969: aname => 'CREDIT_ACCOUNTING_RULE');
1970:
1967: itemtype => p_item_type,
1968: itemkey => p_item_key,
1969: aname => 'CREDIT_ACCOUNTING_RULE');
1970:
1971: l_reason_code := wf_engine.getitemattrtext(
1972: itemtype => p_item_type,
1973: itemkey => p_item_key,
1974: aname => 'REASON');
1975:
1972: itemtype => p_item_type,
1973: itemkey => p_item_key,
1974: aname => 'REASON');
1975:
1976: l_currency_code := wf_engine.GetItemAttrText(
1977: itemtype => p_item_type,
1978: itemkey => p_item_key,
1979: aname => 'CURRENCY_CODE');
1980:
1991: name => 'ARW_NEED_RULE');
1992:
1993: l_need_rule_mesg := fnd_message.get;
1994:
1995: wf_engine.SetItemAttrText(
1996: itemtype => p_item_type,
1997: itemkey => p_item_key,
1998: aname => 'INVALID_RULE_MESG',
1999: avalue => l_need_rule_mesg);
2068: -- RUN mode - normal process execution
2069: --
2070: IF (p_funcmode = 'RUN') THEN
2071:
2072: l_approval_path := wf_engine.getitemattrtext(
2073: itemtype => p_item_type,
2074: itemkey => p_item_key,
2075: aname => 'APPROVAL_PATH');
2076:
2206: -- if so then the last approver has timed out and we do not know who to
2207: -- send the approval to. So, we should error out and send notification
2208: -- to SYSADMIN.
2209:
2210: l_timeout_occured := wf_engine.GetItemAttrText(
2211: itemtype => p_item_type,
2212: itemkey => p_item_key,
2213: aname => 'TIMEOUT_OCCURRED');
2214:
2228: -- Bug # 3865317.
2229: -- We need to reset a flag to indicate that we are no
2230: -- longer in a timeout mode.
2231:
2232: wf_engine.setitemattrtext(
2233: itemtype => p_item_type,
2234: itemkey => p_item_key,
2235: aname => 'TIMEOUT_OCCURRED',
2236: avalue => 'N');
2234: itemkey => p_item_key,
2235: aname => 'TIMEOUT_OCCURRED',
2236: avalue => 'N');
2237:
2238: l_escalation_count := wf_engine.getitemattrnumber(
2239: itemtype => p_item_type,
2240: itemkey => p_item_key,
2241: aname => 'ESCALATION_COUNT');
2242:
2255:
2256: IF l_approver_user_id IS NULL THEN
2257:
2258: -- end of hub, reset the scalation related attributes.
2259: wf_engine.setitemattrnumber(
2260: itemtype => p_item_type,
2261: itemkey => p_item_key,
2262: aname => 'MANAGER_ID',
2263: avalue => -9999);
2261: itemkey => p_item_key,
2262: aname => 'MANAGER_ID',
2263: avalue => -9999);
2264:
2265: wf_engine.setitemattrnumber(
2266: itemtype => p_item_type,
2267: itemkey => p_item_key,
2268: aname => 'ESCALATION_COUNT',
2269: avalue => 0);
2371: -- RUN mode - normal process execution
2372: --
2373: IF (p_funcmode = 'RUN') THEN
2374:
2375: l_approver_user_name := wf_engine.GetItemAttrText(
2376: itemtype => p_item_type,
2377: itemkey => p_item_key,
2378: aname => 'ROLE');
2379:
2389: --
2390: -- If this is not populated here supervisory and job level
2391: -- hierarchy would not work.
2392:
2393: wf_engine.setitemattrnumber(
2394: itemtype => p_item_type,
2395: itemkey => p_item_key,
2396: aname => 'NON_DEFAULT_START_PERSON_ID',
2397: avalue => l_employee_id);
2623: -- if so then the last approver has timed out and we do not know who to
2624: -- send the approval to. So, we should error out and send notification
2625: -- to SYSADMIN.
2626:
2627: l_timeout_occured := wf_engine.GetItemAttrText(
2628: itemtype => p_item_type,
2629: itemkey => p_item_key,
2630: aname => 'TIMEOUT_OCCURRED');
2631:
2645: -- Bug # 3865317.
2646: -- We need to reset a flag to indicate that we are no
2647: -- longer in a timeout mode.
2648:
2649: wf_engine.setitemattrtext(
2650: itemtype => p_item_type,
2651: itemkey => p_item_key,
2652: aname => 'TIMEOUT_OCCURRED',
2653: avalue => 'N');
2651: itemkey => p_item_key,
2652: aname => 'TIMEOUT_OCCURRED',
2653: avalue => 'N');
2654:
2655: l_escalation_count := wf_engine.getitemattrnumber(
2656: itemtype => p_item_type,
2657: itemkey => p_item_key,
2658: aname => 'ESCALATION_COUNT');
2659:
2671:
2672: IF l_approver_user_id IS NULL THEN
2673:
2674: -- end of hub, reset the scalation related attributes.
2675: wf_engine.setitemattrnumber(
2676: itemtype => p_item_type,
2677: itemkey => p_item_key,
2678: aname => 'MANAGER_ID',
2679: avalue => -9999);
2677: itemkey => p_item_key,
2678: aname => 'MANAGER_ID',
2679: avalue => -9999);
2680:
2681: wf_engine.setitemattrnumber(
2682: itemtype => p_item_type,
2683: itemkey => p_item_key,
2684: aname => 'ESCALATION_COUNT',
2685: avalue => 0);
2688: p_result := 'COMPLETE:F';
2689: RETURN;
2690: END IF;
2691:
2692: wf_engine.SetItemAttrNumber(
2693: itemtype => p_item_type,
2694: itemkey => p_item_key,
2695: aname => 'PERSON_ID',
2696: avalue => l_approver_employee_id);
2814: -- However, for Limits Only path, to work around a AME limitation
2815: -- we must pass approved status to AME, so that AME does not try
2816: -- to find a manager and error out.
2817:
2818: l_approval_path := wf_engine.getitemattrtext(
2819: itemtype => p_item_type,
2820: itemkey => p_item_key,
2821: aname => 'APPROVAL_PATH');
2822:
2819: itemtype => p_item_type,
2820: itemkey => p_item_key,
2821: aname => 'APPROVAL_PATH');
2822:
2823: l_transaction_type := wf_engine.GetItemAttrText(
2824: itemtype => p_item_type,
2825: itemkey => p_item_key,
2826: aname => 'CURRENT_HUB');
2827:
2848: -- to his/her manager and he/she too may not respond. In that case
2849: -- notification has be to sent to the manager's manager in a recursive
2850: -- manner.
2851:
2852: l_escalation_count := wf_engine.getitemattrnumber(
2853: itemtype => p_item_type,
2854: itemkey => p_item_key,
2855: aname => 'ESCALATION_COUNT');
2856:
2855: aname => 'ESCALATION_COUNT');
2856:
2857: IF l_escalation_count=0 THEN
2858:
2859: l_nonresponsive_user_id := wf_engine.getitemattrnumber(
2860: itemtype => p_item_type,
2861: itemkey => p_item_key,
2862: aname => 'APPROVER_ID');
2863:
2863:
2864: l_nonresponsive_employee_id := get_employee_id(l_nonresponsive_user_id);
2865:
2866: ELSE
2867: l_nonresponsive_employee_id := wf_engine.getitemattrnumber(
2868: itemtype => p_item_type,
2869: itemkey => p_item_key,
2870: aname => 'MANAGER_ID');
2871: END IF;
2871: END IF;
2872:
2873: l_escalation_count := l_escalation_count + 1;
2874:
2875: wf_engine.setitemattrnumber(
2876: itemtype => p_item_type,
2877: itemkey => p_item_key,
2878: aname => 'ESCALATION_COUNT',
2879: avalue => l_escalation_count);
2890: to_char(l_nonresponsive_employee_id),
2891: l_nonresponsive_user_name,
2892: l_nonresponsive_display_name);
2893:
2894: wf_engine.setitemattrnumber(
2895: itemtype => p_item_type,
2896: itemkey => p_item_key,
2897: aname => 'FORWARD_FROM_ID',
2898: avalue => l_nonresponsive_user_id);
2896: itemkey => p_item_key,
2897: aname => 'FORWARD_FROM_ID',
2898: avalue => l_nonresponsive_user_id);
2899:
2900: wf_engine.setitemattrtext(
2901: itemtype => p_item_type,
2902: itemkey => p_item_key,
2903: aname => 'FORWARD_FROM_USER_NAME',
2904: avalue => l_nonresponsive_user_name);
2902: itemkey => p_item_key,
2903: aname => 'FORWARD_FROM_USER_NAME',
2904: avalue => l_nonresponsive_user_name);
2905:
2906: wf_engine.setitemattrtext(
2907: itemtype => p_item_type,
2908: itemkey => p_item_key,
2909: aname => 'FORWARD_FROM_DISPLAY_NAME',
2910: avalue => l_nonresponsive_display_name);
2923: p_result := 'COMPLETE:F';
2924: RETURN;
2925:
2926: ELSE
2927: wf_engine.setitemattrnumber(
2928: itemtype => p_item_type,
2929: itemkey => p_item_key,
2930: aname => 'MANAGER_ID',
2931: avalue => l_manager_employee_id);
2935: to_char(l_manager_employee_id),
2936: l_manager_user_name,
2937: l_manager_display_name);
2938:
2939: wf_engine.setitemattrtext(
2940: itemtype => p_item_type,
2941: itemkey => p_item_key,
2942: aname => 'MANAGER_USER_NAME',
2943: avalue => l_manager_user_name);
2941: itemkey => p_item_key,
2942: aname => 'MANAGER_USER_NAME',
2943: avalue => l_manager_user_name);
2944:
2945: wf_engine.setitemattrtext(
2946: itemtype => p_item_type,
2947: itemkey => p_item_key,
2948: aname => 'MANAGER_DISPLAY_NAME',
2949: avalue => l_manager_display_name);
3016: g_debug_mesg := 'Get the user name of collector';
3017: ------------------------------------------------------------
3018:
3019:
3020: l_collector_employee_id := wf_engine.GetItemAttrNumber(
3021: p_item_type,
3022: p_item_key,
3023: 'COLLECTOR_EMPLOYEE_ID');
3024: wf_engine.SetItemAttrNumber(p_item_type,
3020: l_collector_employee_id := wf_engine.GetItemAttrNumber(
3021: p_item_type,
3022: p_item_key,
3023: 'COLLECTOR_EMPLOYEE_ID');
3024: wf_engine.SetItemAttrNumber(p_item_type,
3025: p_item_key,
3026: 'FORWARD_FROM_ID',
3027: l_collector_employee_id);
3028:
3029:
3030:
3031:
3032:
3033: l_collector_user_name := wf_engine.GetItemAttrText(p_item_type,
3034: p_item_key,
3035: 'COLLECTOR_USER_NAME');
3036: wf_engine.SetItemAttrText(p_item_type,
3037: p_item_key,
3032:
3033: l_collector_user_name := wf_engine.GetItemAttrText(p_item_type,
3034: p_item_key,
3035: 'COLLECTOR_USER_NAME');
3036: wf_engine.SetItemAttrText(p_item_type,
3037: p_item_key,
3038: 'FORWARD_FROM_USER_NAME',
3039: l_collector_user_name);
3040:
3038: 'FORWARD_FROM_USER_NAME',
3039: l_collector_user_name);
3040:
3041:
3042: l_collector_display_name := wf_engine.GetItemAttrText(p_item_type,
3043: p_item_key,
3044: 'COLLECTOR_DISPLAY_NAME');
3045: wf_engine.SetItemAttrText(p_item_type,
3046: p_item_key,
3041:
3042: l_collector_display_name := wf_engine.GetItemAttrText(p_item_type,
3043: p_item_key,
3044: 'COLLECTOR_DISPLAY_NAME');
3045: wf_engine.SetItemAttrText(p_item_type,
3046: p_item_key,
3047: 'FORWARD_FROM_DISPLAY_NAME',
3048: l_collector_display_name);
3049:
3050: -- Add the collector user name in front of notes field.
3051:
3052:
3053:
3054: l_approver_notes := wf_engine.GetItemAttrText(p_item_type,
3055: p_item_key,
3056: 'APPROVER_NOTES');
3057:
3058: l_notes := l_collector_user_name ||
3057:
3058: l_notes := l_collector_user_name ||
3059: ': ' || l_approver_notes || CRLF;
3060:
3061: wf_engine.SetItemAttrText(p_item_type,
3062: p_item_key,
3063: 'NOTES',
3064: l_notes);
3065:
3066: -- Initialize the approver_notes
3067:
3068: l_approver_notes := NULL;
3069:
3070: wf_engine.SetItemAttrText(p_item_type,
3071: p_item_key,
3072: 'APPROVER_NOTES',
3073: l_approver_notes);
3074:
3073: l_approver_notes);
3074:
3075:
3076: -- end of hub, reset the scalation related attributes.
3077: wf_engine.setitemattrnumber(
3078: itemtype => p_item_type,
3079: itemkey => p_item_key,
3080: aname => 'MANAGER_ID',
3081: avalue => -9999);
3079: itemkey => p_item_key,
3080: aname => 'MANAGER_ID',
3081: avalue => -9999);
3082:
3083: wf_engine.setitemattrnumber(
3084: itemtype => p_item_type,
3085: itemkey => p_item_key,
3086: aname => 'ESCALATION_COUNT',
3087: avalue => 0);
3153: ------------------------------------------------------------
3154: g_debug_mesg := 'Get the user name of approver';
3155: ------------------------------------------------------------
3156:
3157: l_approver_id := wf_engine.GetItemAttrNumber(
3158: p_item_type,
3159: p_item_key,
3160: 'APPROVER_ID');
3161:
3158: p_item_type,
3159: p_item_key,
3160: 'APPROVER_ID');
3161:
3162: wf_engine.SetItemAttrNumber(
3163: p_item_type,
3164: p_item_key,
3165: 'FORWARD_TO_ID',
3166: l_approver_id);
3164: p_item_key,
3165: 'FORWARD_TO_ID',
3166: l_approver_id);
3167:
3168: l_approver_user_name := wf_engine.GetItemAttrText(
3169: p_item_type,
3170: p_item_key,
3171: 'APPROVER_USER_NAME');
3172:
3169: p_item_type,
3170: p_item_key,
3171: 'APPROVER_USER_NAME');
3172:
3173: wf_engine.SetItemAttrText(
3174: p_item_type,
3175: p_item_key,
3176: 'FORWARD_TO_USER_NAME',
3177: l_approver_user_name);
3176: 'FORWARD_TO_USER_NAME',
3177: l_approver_user_name);
3178:
3179:
3180: l_approver_display_name := wf_engine.GetItemAttrText(
3181: p_item_type,
3182: p_item_key,
3183: 'APPROVER_DISPLAY_NAME');
3184:
3181: p_item_type,
3182: p_item_key,
3183: 'APPROVER_DISPLAY_NAME');
3184:
3185: wf_engine.SetItemAttrText(
3186: p_item_type,
3187: p_item_key,
3188: 'FORWARD_TO_DISPLAY_NAME',
3189: l_approver_display_name);
3259: ------------------------------------------------------------
3260: g_debug_mesg := 'Get the user name of forward from user';
3261: ------------------------------------------------------------
3262:
3263: l_forward_from_user_name := wf_engine.GetItemAttrText(
3264: p_item_type,
3265: p_item_key,
3266: 'FORWARD_FROM_USER_NAME');
3267:
3350: ------------------------------------------------------------
3351:
3352:
3353:
3354: l_approver_id := wf_engine.GetItemAttrNumber(p_item_type,
3355: p_item_key,
3356: 'APPROVER_ID');
3357: wf_engine.SetItemAttrNumber(p_item_type,
3358: p_item_key,
3353:
3354: l_approver_id := wf_engine.GetItemAttrNumber(p_item_type,
3355: p_item_key,
3356: 'APPROVER_ID');
3357: wf_engine.SetItemAttrNumber(p_item_type,
3358: p_item_key,
3359: 'FORWARD_FROM_ID',
3360: l_approver_id);
3361:
3360: l_approver_id);
3361:
3362:
3363:
3364: l_approver_user_name := wf_engine.GetItemAttrText(p_item_type,
3365: p_item_key,
3366: 'APPROVER_USER_NAME');
3367: wf_engine.SetItemAttrText(p_item_type,
3368: p_item_key,
3363:
3364: l_approver_user_name := wf_engine.GetItemAttrText(p_item_type,
3365: p_item_key,
3366: 'APPROVER_USER_NAME');
3367: wf_engine.SetItemAttrText(p_item_type,
3368: p_item_key,
3369: 'FORWARD_FROM_USER_NAME',
3370: l_approver_user_name);
3371:
3369: 'FORWARD_FROM_USER_NAME',
3370: l_approver_user_name);
3371:
3372:
3373: l_approver_display_name := wf_engine.GetItemAttrText(p_item_type,
3374: p_item_key,
3375: 'APPROVER_DISPLAY_NAME');
3376: wf_engine.SetItemAttrText(p_item_type,
3377: p_item_key,
3372:
3373: l_approver_display_name := wf_engine.GetItemAttrText(p_item_type,
3374: p_item_key,
3375: 'APPROVER_DISPLAY_NAME');
3376: wf_engine.SetItemAttrText(p_item_type,
3377: p_item_key,
3378: 'FORWARD_FROM_DISPLAY_NAME',
3379: l_approver_display_name);
3380:
3379: l_approver_display_name);
3380:
3381: -- Add the approver user name in front of notes field.
3382:
3383: l_notes := wf_engine.GetItemAttrText(p_item_type,
3384: p_item_key,
3385: 'NOTES');
3386:
3387: l_approver_notes := wf_engine.GetItemAttrText(p_item_type,
3383: l_notes := wf_engine.GetItemAttrText(p_item_type,
3384: p_item_key,
3385: 'NOTES');
3386:
3387: l_approver_notes := wf_engine.GetItemAttrText(p_item_type,
3388: p_item_key,
3389: 'APPROVER_NOTES');
3390:
3391:
3391:
3392: l_notes := l_notes || l_approver_user_name ||
3393: ': ' || l_approver_notes || CRLF;
3394:
3395: wf_engine.SetItemAttrText(p_item_type,
3396: p_item_key,
3397: 'NOTES',
3398: l_notes);
3399:
3400: -- Initialize the approver_notes
3401:
3402: l_approver_notes := NULL;
3403:
3404: wf_engine.SetItemAttrText(p_item_type,
3405: p_item_key,
3406: 'APPROVER_NOTES',
3407: l_approver_notes);
3408:
3546: -- RUN mode - normal process execution
3547: --
3548: IF (p_funcmode = 'RUN') then
3549:
3550: l_customer_trx_id := wf_engine.GetItemAttrNumber(
3551: p_item_type,
3552: p_item_key,
3553: 'CUSTOMER_TRX_ID');
3554:
3551: p_item_type,
3552: p_item_key,
3553: 'CUSTOMER_TRX_ID');
3554:
3555: l_request_id := WF_ENGINE.GetItemAttrNumber(
3556: p_item_type,
3557: p_item_key,
3558: 'WORKFLOW_DOCUMENT_ID');
3559:
3605:
3606: END LOOP;
3607: END;
3608:
3609: l_reason_code := wf_engine.GetItemAttrText(
3610: p_item_type,
3611: p_item_key,
3612: 'REASON');
3613:
3610: p_item_type,
3611: p_item_key,
3612: 'REASON');
3613:
3614: l_currency_code := wf_engine.GetItemAttrText(
3615: p_item_type,
3616: p_item_key,
3617: 'CURRENCY_CODE');
3618:
3616: p_item_key,
3617: 'CURRENCY_CODE');
3618:
3619: l_total_credit_to_invoice
3620: := wf_engine.GetItemAttrNumber(
3621: p_item_type,
3622: p_item_key,
3623: 'TOTAL_CREDIT_TO_INVOICE');
3624:
3623: 'TOTAL_CREDIT_TO_INVOICE');
3624:
3625:
3626:
3627: l_approver_id := wf_engine.GetItemAttrNumber(p_item_type,
3628: p_item_key,
3629: 'APPROVER_ID');
3630:
3631: CheckFinalApprover(l_reason_code,
3731: p_result := 'COMPLETE:F';
3732: RETURN;
3733: END IF;
3734:
3735: wf_engine.SetItemAttrText(
3736: itemtype => c_item_type,
3737: itemkey => p_item_key,
3738: aname => 'CURRENT_HUB',
3739: avalue => c_receivable_transaction_type);
3823: g_debug_mesg := 'Find user in Receivable role who responded to
3824: the notification';
3825: -----------------------------------------------------------------
3826:
3827: l_notification_id := wf_engine.context_nid;
3828: l_approver_user_name := wf_engine.context_text;
3829:
3830: SELECT orig_system_id, display_name
3831: INTO l_approver_id, l_approver_display_name
3824: the notification';
3825: -----------------------------------------------------------------
3826:
3827: l_notification_id := wf_engine.context_nid;
3828: l_approver_user_name := wf_engine.context_text;
3829:
3830: SELECT orig_system_id, display_name
3831: INTO l_approver_id, l_approver_display_name
3832: FROM wf_users
3832: FROM wf_users
3833: WHERE orig_system = 'PER'
3834: AND name = l_approver_user_name;
3835:
3836: wf_engine.SetItemAttrText(p_item_type,
3837: p_item_key,
3838: 'APPROVER_ID',
3839: l_approver_id);
3840:
3837: p_item_key,
3838: 'APPROVER_ID',
3839: l_approver_id);
3840:
3841: wf_engine.SetItemAttrText(p_item_type,
3842: p_item_key,
3843: 'APPROVER_USER_NAME',
3844: l_approver_user_name);
3845:
3842: p_item_key,
3843: 'APPROVER_USER_NAME',
3844: l_approver_user_name);
3845:
3846: wf_engine.SetItemAttrText(p_item_type,
3847: p_item_key,
3848: 'APPROVER_DISPLAY_NAME',
3849: l_approver_display_name);
3850:
3930: --
3931: IF (p_funcmode = 'RUN') then
3932:
3933:
3934: l_document_id := wf_engine.GetItemAttrNumber(
3935: p_item_type,
3936: p_item_key,
3937: 'WORKFLOW_DOCUMENT_ID');
3938:
3936: p_item_key,
3937: 'WORKFLOW_DOCUMENT_ID');
3938:
3939: l_requestor_user_name
3940: := wf_engine.GetItemAttrText(
3941: p_item_type,
3942: p_item_key,
3943: 'REQUESTOR_USER_NAME');
3944:
3942: p_item_key,
3943: 'REQUESTOR_USER_NAME');
3944:
3945:
3946: l_reason_code := wf_engine.GetItemAttrText(
3947: p_item_type,
3948: p_item_key,
3949: 'REASON');
3950:
3949: 'REASON');
3950:
3951:
3952: l_total_credit_to_invoice
3953: := wf_engine.GetItemAttrNumber(
3954: p_item_type,
3955: p_item_key,
3956: 'TOTAL_CREDIT_TO_INVOICE');
3957:
3955: p_item_key,
3956: 'TOTAL_CREDIT_TO_INVOICE');
3957:
3958:
3959: l_customer_trx_id := wf_engine.GetItemAttrNumber(
3960: p_item_type,
3961: p_item_key,
3962: 'CUSTOMER_TRX_ID');
3963:
3960: p_item_type,
3961: p_item_key,
3962: 'CUSTOMER_TRX_ID');
3963:
3964: l_comments := wf_engine.GetItemAttrText(
3965: p_item_type,
3966: p_item_key,
3967: 'COMMENTS');
3968:
3966: p_item_key,
3967: 'COMMENTS');
3968:
3969: /*7367350 Retrieve internal comment*/
3970: l_internal_comment := wf_engine.GetItemAttrText(
3971: p_item_type,
3972: p_item_key,
3973: 'INTERNAL_COMMENTS');
3974:
4097: -- RUN mode - normal process execution
4098: --
4099: IF (p_funcmode = 'RUN') then
4100:
4101: l_document_id := wf_engine.GetItemAttrNumber(
4102: p_item_type,
4103: p_item_key,
4104: 'WORKFLOW_DOCUMENT_ID');
4105:
4102: p_item_type,
4103: p_item_key,
4104: 'WORKFLOW_DOCUMENT_ID');
4105:
4106: l_customer_trx_id := wf_engine.GetItemAttrNumber(
4107: p_item_type,
4108: p_item_key,
4109: 'CUSTOMER_TRX_ID');
4110:
4108: p_item_key,
4109: 'CUSTOMER_TRX_ID');
4110:
4111: l_approver_display_name
4112: := wf_engine.GetItemAttrText(
4113: p_item_type,
4114: p_item_key,
4115: 'APPROVER_DISPLAY_NAME');
4116:
4113: p_item_type,
4114: p_item_key,
4115: 'APPROVER_DISPLAY_NAME');
4116:
4117: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4118:
4119: fnd_message.set_name('AR', 'AR_WF_APPROVAL_REMINDER');
4120: fnd_message.set_token('APPROVER', l_approver_display_name);
4121: -- bug fix 1122477
4203: --
4204: IF (p_funcmode = 'RUN') then
4205:
4206:
4207: l_document_id := wf_engine.GetItemAttrNumber(
4208: p_item_type,
4209: p_item_key,
4210: 'WORKFLOW_DOCUMENT_ID');
4211:
4208: p_item_type,
4209: p_item_key,
4210: 'WORKFLOW_DOCUMENT_ID');
4211:
4212: l_customer_trx_id := wf_engine.GetItemAttrNumber(
4213: p_item_type,
4214: p_item_key,
4215: 'CUSTOMER_TRX_ID');
4216:
4214: p_item_key,
4215: 'CUSTOMER_TRX_ID');
4216:
4217: l_manager_user_name
4218: := wf_engine.GetItemAttrText(
4219: p_item_type,
4220: p_item_key,
4221: 'MANAGER_USER_NAME');
4222:
4219: p_item_type,
4220: p_item_key,
4221: 'MANAGER_USER_NAME');
4222:
4223: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4224:
4225: fnd_message.set_name('AR', 'AR_WF_APPROVAL_ESCALATION');
4226: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4227: fnd_message.set_token('APPROVER', l_manager_user_name);
4309: -- RUN mode - normal process execution
4310: --
4311: IF (p_funcmode = 'RUN') then
4312:
4313: l_document_id := wf_engine.GetItemAttrNumber(
4314: p_item_type,
4315: p_item_key,
4316: 'WORKFLOW_DOCUMENT_ID');
4317:
4314: p_item_type,
4315: p_item_key,
4316: 'WORKFLOW_DOCUMENT_ID');
4317:
4318: l_customer_trx_id := wf_engine.GetItemAttrNumber(
4319: p_item_type,
4320: p_item_key,
4321: 'CUSTOMER_TRX_ID');
4322:
4320: p_item_key,
4321: 'CUSTOMER_TRX_ID');
4322:
4323: l_receivable_role
4324: := wf_engine.GetItemAttrText(
4325: p_item_type,
4326: p_item_key,
4327: 'RECEIVABLE_ROLE');
4328: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4324: := wf_engine.GetItemAttrText(
4325: p_item_type,
4326: p_item_key,
4327: 'RECEIVABLE_ROLE');
4328: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4329: SELECT display_name INTO l_role_display_name
4330: FROM wf_roles
4331: WHERE name = l_receivable_role;
4332:
4430: -- restore_context(p_item_key);
4431: l_last_updated_by := ARP_GLOBAL.user_id;
4432: l_last_update_login := ARP_GLOBAL.last_update_login ;
4433:
4434: l_document_id := wf_engine.GetItemAttrNumber(
4435: p_item_type,
4436: p_item_key,
4437: 'WORKFLOW_DOCUMENT_ID');
4438:
4435: p_item_type,
4436: p_item_key,
4437: 'WORKFLOW_DOCUMENT_ID');
4438:
4439: l_customer_trx_id := wf_engine.GetItemAttrNumber(
4440: p_item_type,
4441: p_item_key,
4442: 'CUSTOMER_TRX_ID');
4443:
4441: p_item_key,
4442: 'CUSTOMER_TRX_ID');
4443:
4444: l_receivable_role
4445: := wf_engine.GetItemAttrText(
4446: p_item_type,
4447: p_item_key,
4448: 'RECEIVABLE_ROLE');
4449: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4445: := wf_engine.GetItemAttrText(
4446: p_item_type,
4447: p_item_key,
4448: 'RECEIVABLE_ROLE');
4449: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4450:
4451: SELECT display_name INTO l_role_display_name
4452: FROM wf_roles
4453: WHERE name = l_receivable_role;
4547: --
4548: IF (p_funcmode = 'RUN') then
4549:
4550:
4551: l_document_id := wf_engine.GetItemAttrNumber(
4552: p_item_type,
4553: p_item_key,
4554: 'WORKFLOW_DOCUMENT_ID');
4555:
4552: p_item_type,
4553: p_item_key,
4554: 'WORKFLOW_DOCUMENT_ID');
4555:
4556: l_customer_trx_id := wf_engine.GetItemAttrNumber(
4557: p_item_type,
4558: p_item_key,
4559: 'CUSTOMER_TRX_ID');
4560:
4558: p_item_key,
4559: 'CUSTOMER_TRX_ID');
4560:
4561: l_approver_display_name
4562: := wf_engine.GetItemAttrText(
4563: p_item_type,
4564: p_item_key,
4565: 'APPROVER_DISPLAY_NAME');
4566:
4563: p_item_type,
4564: p_item_key,
4565: 'APPROVER_DISPLAY_NAME');
4566:
4567: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4568:
4569: fnd_message.set_name('AR', 'AR_WF_REQUEST_APPROVAL');
4570: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4571: fnd_message.set_token('APPROVER', l_approver_display_name);
4666: --
4667: IF (p_funcmode = 'RUN') then
4668:
4669:
4670: l_document_id := wf_engine.GetItemAttrNumber(
4671: p_item_type,
4672: p_item_key,
4673: 'WORKFLOW_DOCUMENT_ID');
4674:
4671: p_item_type,
4672: p_item_key,
4673: 'WORKFLOW_DOCUMENT_ID');
4674:
4675: l_customer_trx_id := wf_engine.GetItemAttrNumber(
4676: p_item_type,
4677: p_item_key,
4678: 'CUSTOMER_TRX_ID');
4679:
4677: p_item_key,
4678: 'CUSTOMER_TRX_ID');
4679:
4680: l_approver_display_name
4681: := wf_engine.GetItemAttrText(
4682: p_item_type,
4683: p_item_key,
4684: 'APPROVER_DISPLAY_NAME');
4685: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4681: := wf_engine.GetItemAttrText(
4682: p_item_type,
4683: p_item_key,
4684: 'APPROVER_DISPLAY_NAME');
4685: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4686:
4687:
4688: fnd_message.set_name('AR', 'AR_WF_APPROVED_RESPONSE');
4689: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4723: arp_standard.debug('InsertApprovedResponseNotes: ' || g_debug_mesg);
4724: END IF;
4725: ---------------------------------------------------------------------------
4726:
4727: wf_engine.SetItemAttrText(
4728: itemtype => p_item_type,
4729: itemkey => p_item_key,
4730: aname => 'CURRENT_HUB',
4731: avalue => c_approvals_transaction_type);
4819: -- RUN mode - normal process execution
4820: --
4821: IF (p_funcmode = 'RUN') then
4822:
4823: l_document_id := wf_engine.GetItemAttrNumber(
4824: p_item_type,
4825: p_item_key,
4826: 'WORKFLOW_DOCUMENT_ID');
4827:
4824: p_item_type,
4825: p_item_key,
4826: 'WORKFLOW_DOCUMENT_ID');
4827:
4828: l_customer_trx_id := wf_engine.GetItemAttrNumber(
4829: p_item_type,
4830: p_item_key,
4831: 'CUSTOMER_TRX_ID');
4832:
4830: p_item_key,
4831: 'CUSTOMER_TRX_ID');
4832:
4833: l_approver_display_name
4834: := wf_engine.GetItemAttrText(
4835: p_item_type,
4836: p_item_key,
4837: 'APPROVER_DISPLAY_NAME');
4838:
4835: p_item_type,
4836: p_item_key,
4837: 'APPROVER_DISPLAY_NAME');
4838:
4839: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4840:
4841: fnd_message.set_name('AR', 'AR_WF_REJECTED_RESPONSE');
4842: fnd_message.set_token('REQUEST_ID', to_char(l_document_id));
4843: fnd_message.set_token('APPROVER', l_approver_display_name);
4887: arp_standard.debug('InsertRejectedResponseNotes: ' || g_debug_mesg);
4888: END IF;
4889: -------------------------------------------------------------------------
4890:
4891: wf_engine.SetItemAttrText(
4892: itemtype => p_item_type,
4893: itemkey => p_item_key,
4894: aname => 'CURRENT_HUB',
4895: avalue => c_approvals_transaction_type);
4964: --
4965: IF (p_funcmode = 'RUN') then
4966:
4967:
4968: l_document_id := wf_engine.GetItemAttrNumber(
4969: p_item_type,
4970: p_item_key,
4971: 'WORKFLOW_DOCUMENT_ID');
4972:
4969: p_item_type,
4970: p_item_key,
4971: 'WORKFLOW_DOCUMENT_ID');
4972:
4973: l_credit_memo_number := wf_engine.GetItemAttrText(
4974: p_item_type,
4975: p_item_key,
4976: 'CREDIT_MEMO_NUMBER');
4977:
4974: p_item_type,
4975: p_item_key,
4976: 'CREDIT_MEMO_NUMBER');
4977:
4978: l_customer_trx_id := wf_engine.GetItemAttrNumber(
4979: p_item_type,
4980: p_item_key,
4981: 'CUSTOMER_TRX_ID');
4982:
4979: p_item_type,
4980: p_item_key,
4981: 'CUSTOMER_TRX_ID');
4982:
4983: l_notes := wf_engine.GetItemAttrText( p_item_type, p_item_key,'NOTES'); /*5119049*/
4984: /* Get trx number for CM and the insert into note text */
4985:
4986:
4987: fnd_message.set_name('AR', 'AR_WF_COMPLETED_SUCCESSFUL');
5077: -- RUN mode - normal process execution
5078: --
5079: IF (p_funcmode = 'RUN') then
5080:
5081: l_reason_code := wf_engine.GetItemAttrText(
5082: p_item_type,
5083: p_item_key,
5084: 'REASON');
5085:
5082: p_item_type,
5083: p_item_key,
5084: 'REASON');
5085:
5086: l_currency_code := wf_engine.GetItemAttrText(
5087: p_item_type,
5088: p_item_key,
5089: 'CURRENCY_CODE');
5090:
5088: p_item_key,
5089: 'CURRENCY_CODE');
5090:
5091: l_entered_amount_display
5092: := wf_engine.GetItemAttrNumber(
5093: p_item_type,
5094: p_item_key,
5095: 'ENTERED_AMOUNT_DISPLAY');
5096:
5093: p_item_type,
5094: p_item_key,
5095: 'ENTERED_AMOUNT_DISPLAY');
5096:
5097: l_customer_id := wf_engine.GetItemAttrNumber(
5098: p_item_type,
5099: p_item_key,
5100: 'CUSTOMER_ID');
5101:
5098: p_item_type,
5099: p_item_key,
5100: 'CUSTOMER_ID');
5101:
5102: l_collector_id := wf_engine.GetItemAttrNumber(
5103: p_item_type,
5104: p_item_key,
5105: 'COLLECTOR_ID');
5106:
5104: p_item_key,
5105: 'COLLECTOR_ID');
5106:
5107:
5108: l_customer_trx_id := wf_engine.GetItemAttrNumber(
5109: p_item_type,
5110: p_item_key,
5111: 'CUSTOMER_TRX_ID');
5112:
5109: p_item_type,
5110: p_item_key,
5111: 'CUSTOMER_TRX_ID');
5112:
5113: l_bill_to_site_use_id := wf_engine.GetItemAttrNumber(
5114: p_item_type,
5115: p_item_key,
5116: 'BILL_TO_SITE_USE_ID');
5117:
5294: l_last_update_login := ARP_GLOBAL.last_update_login ;
5295:
5296: -- call transaction API here
5297:
5298: l_customer_trx_id := wf_engine.GetItemAttrNumber(
5299: p_item_type,
5300: p_item_key,
5301: 'CUSTOMER_TRX_ID');
5302:
5299: p_item_type,
5300: p_item_key,
5301: 'CUSTOMER_TRX_ID');
5302:
5303: l_amount := wf_engine.GetItemAttrNumber(
5304: p_item_type,
5305: p_item_key,
5306: 'ORIGINAL_TOTAL');
5307:
5304: p_item_type,
5305: p_item_key,
5306: 'ORIGINAL_TOTAL');
5307:
5308: l_request_id := wf_engine.GetItemAttrNumber(
5309: p_item_type,
5310: p_item_key,
5311: 'WORKFLOW_DOCUMENT_ID');
5312:
5309: p_item_type,
5310: p_item_key,
5311: 'WORKFLOW_DOCUMENT_ID');
5312:
5313: l_batch_source_name := wf_engine.GetItemAttrText(
5314: p_item_type,
5315: p_item_key,
5316: 'BATCH_SOURCE_NAME');
5317:
5315: p_item_key,
5316: 'BATCH_SOURCE_NAME');
5317:
5318:
5319: l_credit_method_installments := wf_engine.GetItemAttrText(
5320: p_item_type,
5321: p_item_key,
5322: 'CREDIT_INSTALLMENT_RULE');
5323:
5320: p_item_type,
5321: p_item_key,
5322: 'CREDIT_INSTALLMENT_RULE');
5323:
5324: l_credit_method_rules := wf_engine.GetItemAttrText(
5325: p_item_type,
5326: p_item_key,
5327: 'CREDIT_ACCOUNTING_RULE');
5328:
5335:
5336: fnd_message.set_name('AR', 'AR_WF_NO_BATCH');
5337: l_cm_creation_error := fnd_message.get;
5338:
5339: wf_engine.SetItemAttrText(p_item_type,
5340: p_item_key,
5341: 'CM_CREATION_ERROR',
5342: l_cm_creation_error);
5343:
5380: EXCEPTION
5381: WHEN OTHERS THEN
5382: p_result := 'COMPLETE:F';
5383: l_cm_creation_error := 'Could not find the request';
5384: wf_engine.SetItemAttrText(p_item_type,
5385: p_item_key,
5386: 'CM_CREATION_ERROR',
5387: l_cm_creation_error);
5388: RETURN;
5410: SELECT trx_number INTO l_credit_memo_number
5411: FROM ra_customer_trx
5412: WHERE customer_trx_id = l_credit_memo_id;
5413:
5414: wf_engine.SetItemAttrText(p_item_type,
5415: p_item_key,
5416: 'CREDIT_MEMO_NUMBER',
5417: l_credit_memo_number);
5418:
5419: EXCEPTION
5420: WHEN OTHERS THEN
5421: p_result := 'COMPLETE:F';
5422: l_cm_creation_error := 'Could not find the credit memo';
5423: wf_engine.SetItemAttrText(p_item_type,
5424: p_item_key,
5425: 'CM_CREATION_ERROR',
5426: l_cm_creation_error);
5427: RETURN;
5435: l_cm_creation_error := l_cm_creation_error ||
5436: l_error_tab(i).translated_message || CRLF;
5437: END LOOP;
5438:
5439: wf_engine.SetItemAttrText(p_item_type,
5440: p_item_key,
5441: 'CM_CREATION_ERROR',
5442: l_cm_creation_error);
5443:
5564: ------------------------------------------------------------
5565: g_debug_mesg := 'Get the user value of rules';
5566: ------------------------------------------------------------
5567:
5568: l_customer_trx_id := wf_engine.GetItemAttrNumber(
5569: p_item_type,
5570: p_item_key,
5571: 'CUSTOMER_TRX_ID');
5572:
5569: p_item_type,
5570: p_item_key,
5571: 'CUSTOMER_TRX_ID');
5572:
5573: l_credit_installment_rule := wf_engine.GetItemAttrText(
5574: p_item_type,
5575: p_item_key,
5576: 'CREDIT_INSTALLMENT_RULE');
5577:
5574: p_item_type,
5575: p_item_key,
5576: 'CREDIT_INSTALLMENT_RULE');
5577:
5578: l_credit_accounting_rule := wf_engine.GetItemAttrText(
5579: p_item_type,
5580: p_item_key,
5581: 'CREDIT_ACCOUNTING_RULE');
5582:
5579: p_item_type,
5580: p_item_key,
5581: 'CREDIT_ACCOUNTING_RULE');
5582:
5583: l_invalid_rule_value := wf_engine.GetItemAttrText(
5584: p_item_type,
5585: p_item_key,
5586: 'INVALID_RULE_VALUE');
5587:
5584: p_item_type,
5585: p_item_key,
5586: 'INVALID_RULE_VALUE');
5587:
5588: l_invalid_rule_mesg := wf_engine.GetItemAttrText(
5589: p_item_type,
5590: p_item_key,
5591: 'INVALID_RULE_MESG');
5592:
5603: IF l_count > 1 then
5604:
5605: IF l_credit_installment_rule not in ('LIFO', 'FIFO', 'PRORATE') then
5606: -- invalid credit method
5607: wf_engine.SetItemAttrText(p_item_type,
5608: p_item_key,
5609: 'INVALID_RULE_MESG',
5610: l_invalid_rule_value);
5611: p_result := 'COMPLETE:F';
5621: IF l_invoicing_rule_id is not NULL then
5622:
5623: IF l_credit_accounting_rule not in ('LIFO', 'PRORATE','UNIT') THEN
5624: -- invalid credit method
5625: wf_engine.SetItemAttrText(p_item_type,
5626: p_item_key,
5627: 'INVALID_RULE_MESG',
5628: l_invalid_rule_value);
5629: p_result := 'COMPLETE:F';
5634: -- the credit methods are valid
5635: IF l_invalid_rule_mesg is NOT NULL THEN
5636:
5637: l_invalid_rule_mesg := NULL;
5638: wf_engine.SetItemAttrText(p_item_type,
5639: p_item_key,
5640: 'INVALID_RULE_MESG',
5641: l_invalid_rule_mesg);
5642: END if;
5725: IF (p_funcmode = 'RUN') THEN
5726:
5727: -- restore_context(p_item_key);
5728:
5729: l_customer_trx_id := wf_engine.GetItemAttrNumber(
5730: itemtype => p_item_type,
5731: itemkey => p_item_key,
5732: aname => 'CUSTOMER_TRX_ID');
5733:
5745: p_result := 'COMPLETE:N';
5746: RETURN;
5747: END IF;
5748:
5749: wf_engine.SetItemAttrText(
5750: itemtype =>p_item_type,
5751: itemkey => p_item_key,
5752: aname => 'SALESREP_USER_NAME',
5753: avalue => l_user_name);
5751: itemkey => p_item_key,
5752: aname => 'SALESREP_USER_NAME',
5753: avalue => l_user_name);
5754:
5755: l_requestor_user_name := wf_engine.GetItemAttrText(
5756: itemtype => p_item_type,
5757: itemkey => p_item_key,
5758: aname => 'REQUESTOR_USER_NAME');
5759:
5807: arp_standard.debug('check_first_approver: ' || g_debug_mesg);
5808: END IF;
5809: ----------------------------------------------------------
5810:
5811: l_approval_path := wf_engine.getitemattrtext(
5812: itemtype => p_item_type,
5813: itemkey => p_item_key,
5814: aname => 'APPROVAL_PATH');
5815:
5812: itemtype => p_item_type,
5813: itemkey => p_item_key,
5814: aname => 'APPROVAL_PATH');
5815:
5816: l_approver_user_name := wf_engine.GetItemAttrText(
5817: itemtype => p_item_type,
5818: itemkey => p_item_key,
5819: aname => 'ROLE');
5820:
5892: arp_standard.debug('on_account_credit_memo: ' || g_debug_mesg);
5893: END IF;
5894: ----------------------------------------------------------
5895:
5896: l_credit_memo_number := wf_engine.getitemattrtext(
5897: itemtype => p_item_type,
5898: itemkey => p_item_key,
5899: aname => 'CREDIT_MEMO_NUMBER');
5900:
5955: IF (p_funcmode = 'RUN') THEN
5956:
5957: -- restore_context(p_item_key);
5958:
5959: l_requestor_user_name := wf_engine.GetItemAttrText(
5960: itemtype => p_item_type,
5961: itemkey => p_item_key,
5962: aname => 'REQUESTOR_USER_NAME');
5963:
5960: itemtype => p_item_type,
5961: itemkey => p_item_key,
5962: aname => 'REQUESTOR_USER_NAME');
5963:
5964: l_collector_user_name := wf_engine.GetItemAttrText(
5965: itemtype => p_item_type,
5966: itemkey => p_item_key,
5967: aname => 'COLLECTOR_USER_NAME');
5968:
6019: IF (p_funcmode = 'RUN') THEN
6020:
6021: l_profile_value := NVL(fnd_profile.value('AR_CMWF_TIME_OUT'), 'MANAGER');
6022:
6023: wf_engine.setitemattrtext(
6024: itemtype => p_item_type,
6025: itemkey => p_item_key,
6026: aname => 'DEBUG',
6027: avalue => 'Profile: ' || l_profile_value);
6033: -- proceed in that direction. To do that all we need to is flag
6034: -- that we are in the timeout mode and simply put a value of "N"
6035: -- (next) in the result attribute.
6036:
6037: wf_engine.setitemattrtext(
6038: itemtype => p_item_type,
6039: itemkey => p_item_key,
6040: aname => 'TIMEOUT_OCCURRED',
6041: avalue => 'Y');