eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_WEB_RECEIPTS_WF dependencies on WF_ENGINE

Line 435: /*RaiseAbortedEvent(WF_ENGINE.GetItemAttrNumber(p_item_type,

431:
432: ----------------------------------------------------------
433: l_debug_info := 'Raise Aborted event';
434: ----------------------------------------------------------
435: /*RaiseAbortedEvent(WF_ENGINE.GetItemAttrNumber(p_item_type,
436: p_item_key,
437: 'EXPENSE_REPORT_ID'));*/
438: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
439: p_item_key,

Line 438: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

434: ----------------------------------------------------------
435: /*RaiseAbortedEvent(WF_ENGINE.GetItemAttrNumber(p_item_type,
436: p_item_key,
437: 'EXPENSE_REPORT_ID'));*/
438: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
439: p_item_key,
440: 'EXPENSE_REPORT_ID');
441:
442: l_event_key := GenerateEventKey(l_report_header_id, C_ABORTED_EVENT_KEY);

Line 444: l_receipt_type := WF_ENGINE.GetActivityAttrText(p_item_type,

440: 'EXPENSE_REPORT_ID');
441:
442: l_event_key := GenerateEventKey(l_report_header_id, C_ABORTED_EVENT_KEY);
443:
444: l_receipt_type := WF_ENGINE.GetActivityAttrText(p_item_type,
445: p_item_key,
446: p_actid,
447: 'ABORT_RECEIPT_TYPE');
448: IF (NOT EventKeyExists(l_event_key)) THEN

Line 501: l_textNameArr Wf_Engine.NameTabTyp;

497: p_item_key IN VARCHAR2) IS
498: ------------------------------------------------------------------------
499: l_debug_info VARCHAR2(200);
500:
501: l_textNameArr Wf_Engine.NameTabTyp;
502: l_numNameArr Wf_Engine.NameTabTyp;
503: l_textValArr Wf_Engine.TextTabTyp;
504: l_numValArr Wf_Engine.NumTabTyp;
505: iText NUMBER :=0;

Line 502: l_numNameArr Wf_Engine.NameTabTyp;

498: ------------------------------------------------------------------------
499: l_debug_info VARCHAR2(200);
500:
501: l_textNameArr Wf_Engine.NameTabTyp;
502: l_numNameArr Wf_Engine.NameTabTyp;
503: l_textValArr Wf_Engine.TextTabTyp;
504: l_numValArr Wf_Engine.NumTabTyp;
505: iText NUMBER :=0;
506: iNum NUMBER :=0;

Line 503: l_textValArr Wf_Engine.TextTabTyp;

499: l_debug_info VARCHAR2(200);
500:
501: l_textNameArr Wf_Engine.NameTabTyp;
502: l_numNameArr Wf_Engine.NameTabTyp;
503: l_textValArr Wf_Engine.TextTabTyp;
504: l_numValArr Wf_Engine.NumTabTyp;
505: iText NUMBER :=0;
506: iNum NUMBER :=0;
507:

Line 504: l_numValArr Wf_Engine.NumTabTyp;

500:
501: l_textNameArr Wf_Engine.NameTabTyp;
502: l_numNameArr Wf_Engine.NameTabTyp;
503: l_textValArr Wf_Engine.TextTabTyp;
504: l_numValArr Wf_Engine.NumTabTyp;
505: iText NUMBER :=0;
506: iNum NUMBER :=0;
507:
508: l_org_id number;

Line 595: WF_ENGINE.SetItemOwner(p_item_type, p_item_key, l_preparer_name);

591:
592: ----------------------------------------------------------
593: l_debug_info := 'Set the Preparer as the Owner of Receipts Mgmt Workflow Process.';
594: ----------------------------------------------------------
595: WF_ENGINE.SetItemOwner(p_item_type, p_item_key, l_preparer_name);
596:
597: ----------------------------------------------------------
598: l_debug_info := 'Set Item User Key to Invoice Number for easier query ';
599: ----------------------------------------------------------

Line 600: WF_ENGINE.SetItemUserKey(p_item_type,

596:
597: ----------------------------------------------------------
598: l_debug_info := 'Set Item User Key to Invoice Number for easier query ';
599: ----------------------------------------------------------
600: WF_ENGINE.SetItemUserKey(p_item_type,
601: p_item_key,
602: l_invoice_num);
603:
604: --------------------------------------------------------

Line 664: WF_ENGINE.SetItemAttrDate(p_item_type, p_item_key, 'EXPENSE_REPORT_SUBMIT_DATE', l_report_submitted_date);

660:
661: ----------------------------------------------------------
662: l_debug_info := 'Set EXPENSE_REPORT_SUBMIT_DATE Item Attribute';
663: ----------------------------------------------------------
664: WF_ENGINE.SetItemAttrDate(p_item_type, p_item_key, 'EXPENSE_REPORT_SUBMIT_DATE', l_report_submitted_date);
665:
666: ----------------------------------------------------------
667: l_debug_info := 'Check Notification Rule';
668: ----------------------------------------------------------

Line 770: WF_ENGINE.SetItemAttrNumberArray(p_item_type, p_item_key, l_numNameArr, l_numValArr);

766:
767: -----------------------------------------------------
768: l_debug_info := 'Set all number item attributes';
769: -----------------------------------------------------
770: WF_ENGINE.SetItemAttrNumberArray(p_item_type, p_item_key, l_numNameArr, l_numValArr);
771:
772: -----------------------------------------------------
773: l_debug_info := 'Set all text item attributes';
774: -----------------------------------------------------

Line 775: WF_ENGINE.SetItemAttrTextArray(p_item_type, p_item_key, l_textNameArr, l_textValArr);

771:
772: -----------------------------------------------------
773: l_debug_info := 'Set all text item attributes';
774: -----------------------------------------------------
775: WF_ENGINE.SetItemAttrTextArray(p_item_type, p_item_key, l_textNameArr, l_textValArr);
776:
777:
778: if (l_is_notif_rule_setup = 'Y') then
779:

Line 831: WF_ENGINE.SetItemAttrText(p_item_type,

827: Init(p_item_type, p_item_key);
828:
829: BEGIN
830: IF (INSTR(l_item_key,'both') <> 0) THEN
831: WF_ENGINE.SetItemAttrText(p_item_type,
832: p_item_key,
833: 'OVERDUE_TYPE_REQUIRED',
834: 'BOTH');
835: ELSIF (INSTR(l_item_key,'original') <> 0) THEN

Line 836: WF_ENGINE.SetItemAttrText(p_item_type,

832: p_item_key,
833: 'OVERDUE_TYPE_REQUIRED',
834: 'BOTH');
835: ELSIF (INSTR(l_item_key,'original') <> 0) THEN
836: WF_ENGINE.SetItemAttrText(p_item_type,
837: p_item_key,
838: 'OVERDUE_TYPE_REQUIRED',
839: 'ORIGINAL');
840: ELSIF (INSTR(l_item_key,'image') <> 0) THEN

Line 841: WF_ENGINE.SetItemAttrText(p_item_type,

837: p_item_key,
838: 'OVERDUE_TYPE_REQUIRED',
839: 'ORIGINAL');
840: ELSIF (INSTR(l_item_key,'image') <> 0) THEN
841: WF_ENGINE.SetItemAttrText(p_item_type,
842: p_item_key,
843: 'OVERDUE_TYPE_REQUIRED',
844: 'IMAGE');
845: END IF;

Line 890: WF_ENGINE.SetItemAttrText(p_item_type,

886: Init(p_item_type, p_item_key);
887:
888: BEGIN
889: IF (INSTR(l_item_key,'both') <> 0) THEN
890: WF_ENGINE.SetItemAttrText(p_item_type,
891: p_item_key,
892: 'MISSING_TYPE_REQUIRED',
893: 'BOTH');
894: ELSIF (INSTR(l_item_key,'original') <> 0) THEN

Line 895: WF_ENGINE.SetItemAttrText(p_item_type,

891: p_item_key,
892: 'MISSING_TYPE_REQUIRED',
893: 'BOTH');
894: ELSIF (INSTR(l_item_key,'original') <> 0) THEN
895: WF_ENGINE.SetItemAttrText(p_item_type,
896: p_item_key,
897: 'MISSING_TYPE_REQUIRED',
898: 'ORIGINAL');
899: ELSIF (INSTR(l_item_key,'image') <> 0) THEN

Line 900: WF_ENGINE.SetItemAttrText(p_item_type,

896: p_item_key,
897: 'MISSING_TYPE_REQUIRED',
898: 'ORIGINAL');
899: ELSIF (INSTR(l_item_key,'image') <> 0) THEN
900: WF_ENGINE.SetItemAttrText(p_item_type,
901: p_item_key,
902: 'MISSING_TYPE_REQUIRED',
903: 'IMAGE');
904: END IF;

Line 1200: WF_ENGINE.AbortProcess(p_item_type,

1196: l_debug_info := 'Abort event process and use the item key as the result';
1197: ----------------------------------------------------------
1198: begin
1199:
1200: WF_ENGINE.AbortProcess(p_item_type,
1201: l_found_item_key,
1202: null,
1203: wf_engine.eng_force);
1204:

Line 1203: wf_engine.eng_force);

1199:
1200: WF_ENGINE.AbortProcess(p_item_type,
1201: l_found_item_key,
1202: null,
1203: wf_engine.eng_force);
1204:
1205: exception
1206: when others then null;
1207: end;

Line 1246: WF_ENGINE.SetItemAttrText(p_item_type,

1242: Init(p_item_type, p_item_key);
1243:
1244: BEGIN
1245: IF (INSTR(l_item_key,'image') <> 0) THEN
1246: WF_ENGINE.SetItemAttrText(p_item_type,
1247: p_item_key,
1248: 'RECEIVED_TYPE_REQUIRED',
1249: 'IMAGE');
1250: ELSE

Line 1251: WF_ENGINE.SetItemAttrText(p_item_type,

1247: p_item_key,
1248: 'RECEIVED_TYPE_REQUIRED',
1249: 'IMAGE');
1250: ELSE
1251: WF_ENGINE.SetItemAttrText(p_item_type,
1252: p_item_key,
1253: 'RECEIVED_TYPE_REQUIRED',
1254: 'ORIGINAL');
1255: END IF;

Line 1362: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

1358:
1359: ------------------------------------------------------------
1360: l_debug_info := 'Retrieve Expense_Report_ID Item Attribute';
1361: ------------------------------------------------------------
1362: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
1363: p_item_key,
1364: 'EXPENSE_REPORT_ID');
1365:
1366: ------------------------------------------------------------

Line 1447: l_receipts_status := WF_ENGINE.GetActivityAttrText(p_item_type,

1443:
1444: -------------------------------------------------------------------
1445: l_debug_info := 'Retrieve Activity Attr Receipts Status';
1446: -------------------------------------------------------------------
1447: l_receipts_status := WF_ENGINE.GetActivityAttrText(p_item_type,
1448: p_item_key,
1449: p_actid,
1450: 'RECEIPTS_STATUS');
1451:

Line 1455: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

1451:
1452: ------------------------------------------------------------
1453: l_debug_info := 'Retrieve Expense_Report_ID Item Attribute';
1454: ------------------------------------------------------------
1455: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
1456: p_item_key,
1457: 'EXPENSE_REPORT_ID');
1458:
1459: ------------------------------------------------------------

Line 1500: l_report_submitted_date := WF_ENGINE.GetItemAttrDate(p_item_type,

1496: DAYS_OVERDUE is the diff between notif sent date and date the
1497: the expense report receipts package became overdue
1498: notif sent date - (report submission date + NOTIF_RULE_DAYS_OVERDUE)
1499: */
1500: l_report_submitted_date := WF_ENGINE.GetItemAttrDate(p_item_type,
1501: p_item_key,
1502: 'EXPENSE_REPORT_SUBMIT_DATE');
1503:
1504: l_notif_rule_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,

Line 1504: l_notif_rule_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,

1500: l_report_submitted_date := WF_ENGINE.GetItemAttrDate(p_item_type,
1501: p_item_key,
1502: 'EXPENSE_REPORT_SUBMIT_DATE');
1503:
1504: l_notif_rule_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,
1505: p_item_key,
1506: 'NOTIF_RULE_DAYS_OVERDUE');
1507:
1508: l_days_overdue := trunc(sysdate) - (trunc(l_report_submitted_date));-- + l_notif_rule_days_overdue);

Line 1513: WF_ENGINE.SetItemAttrNumber(p_item_type, p_item_key, 'DAYS_OVERDUE', l_days_overdue);

1509:
1510: ----------------------------------------------------------
1511: l_debug_info := 'Set DAYS_OVERDUE Item Attribute';
1512: ----------------------------------------------------------
1513: WF_ENGINE.SetItemAttrNumber(p_item_type, p_item_key, 'DAYS_OVERDUE', l_days_overdue);
1514:
1515: ------------------------------------------------------------
1516: l_debug_info := 'Retrieve Expense_Report_ID Item Attribute';
1517: ------------------------------------------------------------

Line 1518: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

1514:
1515: ------------------------------------------------------------
1516: l_debug_info := 'Retrieve Expense_Report_ID Item Attribute';
1517: ------------------------------------------------------------
1518: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
1519: p_item_key,
1520: 'EXPENSE_REPORT_ID');
1521:
1522: ------------------------------------------------------------

Line 1602: l_missing_decl_reqd := WF_ENGINE.GetItemAttrText(p_item_type,

1598:
1599: ----------------------------------------------------------
1600: l_debug_info := 'Check if Missing Declaration is required';
1601: ----------------------------------------------------------
1602: l_missing_decl_reqd := WF_ENGINE.GetItemAttrText(p_item_type,
1603: p_item_key,
1604: 'NOTIF_RULE_MISSING_DECL_REQD');
1605:
1606: if (nvl(l_missing_decl_reqd, C_NOT_REQUIRED) = C_REQUIRED) then

Line 1646: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

1642: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start CheckNotifyReceived');
1643:
1644: IF (p_funmode = 'RUN') THEN
1645:
1646: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
1647: p_item_key,
1648: 'EXPENSE_REPORT_ID');
1649:
1650: ------------------------------------------------------------

Line 1658: l_notif_received := WF_ENGINE.GetItemAttrText(p_item_type,

1654:
1655: ----------------------------------------------------------
1656: l_debug_info := 'Check if Notify Receipts Received is enabled';
1657: ----------------------------------------------------------
1658: l_notif_received := WF_ENGINE.GetItemAttrText(p_item_type,
1659: p_item_key,
1660: 'NOTIF_RULE_NOTIF_RECEIVED');
1661:
1662: ----------------------------------------------------------

Line 1665: l_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,

1661:
1662: ----------------------------------------------------------
1663: l_debug_info := 'Check if Days Overdue';
1664: ----------------------------------------------------------
1665: l_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,
1666: p_item_key,
1667: 'DAYS_OVERDUE');
1668:
1669:

Line 1712: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

1708:
1709: ------------------------------------------------------------
1710: l_debug_info := 'Retrieve Expense_Report_ID Item Attribute';
1711: ------------------------------------------------------------
1712: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
1713: p_item_key,
1714: 'EXPENSE_REPORT_ID');
1715:
1716: ------------------------------------------------------------

Line 1759: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

1755:
1756: ------------------------------------------------------------
1757: l_debug_info := 'Retrieve Expense_Report_ID Item Attribute';
1758: ------------------------------------------------------------
1759: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
1760: p_item_key,
1761: 'EXPENSE_REPORT_ID');
1762:
1763: ------------------------------------------------------------

Line 1892: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

1888:
1889: ------------------------------------------------------------
1890: l_debug_info := 'Retrieve Expense_Report_ID Item Attribute';
1891: ------------------------------------------------------------
1892: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
1893: p_item_key,
1894: 'EXPENSE_REPORT_ID');
1895:
1896: ----------------------------------------------------------

Line 1900: WF_ENGINE.CompleteActivityInternalName(C_APEXP,

1896: ----------------------------------------------------------
1897: l_debug_info := 'Complete Missing or Policy Shortpay Process';
1898: ----------------------------------------------------------
1899: begin
1900: WF_ENGINE.CompleteActivityInternalName(C_APEXP,
1901: l_report_header_id,
1902: p_activity,
1903: p_result);
1904:

Line 2082: l_org_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

2078:
2079: -------------------------------------------------------------------
2080: l_debug_info := 'Check AP_EXPENSE_PARAMS.NOTE_LANGUAGE_CODE';
2081: -------------------------------------------------------------------
2082: l_org_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
2083: p_item_key,
2084: 'ORG_ID');
2085: begin
2086: select note_language_code

Line 2119: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

2115:
2116: ------------------------------------------------------------
2117: l_debug_info := 'Retrieve Expense_Report_ID Item Attribute';
2118: ------------------------------------------------------------
2119: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
2120: p_item_key,
2121: 'EXPENSE_REPORT_ID');
2122:
2123: -------------------------------------------------------------------

Line 2126: l_result_type := WF_ENGINE.GetActivityAttrText(p_item_type,

2122:
2123: -------------------------------------------------------------------
2124: l_debug_info := 'Retrieve Activity Attr Result Type';
2125: -------------------------------------------------------------------
2126: l_result_type := WF_ENGINE.GetActivityAttrText(p_item_type,
2127: p_item_key,
2128: p_actid,
2129: 'RESULT_TYPE');
2130: -- bug 6361555

Line 2175: l_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,

2171:
2172: BEGIN
2173: IF (l_result_type = 'APWRECPT_OVERDUE_RESPONSE') THEN
2174: l_message_name := 'OIE_NOTES_OVERDUE_RESPONSE';
2175: l_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,
2176: p_item_key,
2177: 'DAYS_OVERDUE');
2178:
2179: FND_MESSAGE.SET_NAME('SQLAP', l_message_name);

Line 2186: l_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,

2182: END IF;
2183:
2184: IF (l_result_type = 'APWRECPT_IMG_OVERDUE_RESPONSE') THEN
2185: l_message_name := 'OIE_NOTES_IMG_OVERDUE_RESPONSE';
2186: l_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,
2187: p_item_key,
2188: 'IMAGE_DAYS_OVERDUE');
2189: FND_MESSAGE.SET_NAME('SQLAP', l_message_name);
2190: FND_MESSAGE.SET_TOKEN('DAYS_OVERDUE', to_char(l_days_overdue));

Line 2202: l_result_code := WF_ENGINE.GetActivityAttrText(p_item_type,

2198:
2199: -------------------------------------------------------------------
2200: l_debug_info := 'Retrieve Activity Attr Result Code';
2201: -------------------------------------------------------------------
2202: l_result_code := WF_ENGINE.GetActivityAttrText(p_item_type,
2203: p_item_key,
2204: p_actid,
2205: 'RESULT_CODE');
2206:

Line 2210: l_response := WF_ENGINE.GetActivityAttrText(p_item_type,

2206:
2207: -------------------------------------------------------------------
2208: l_debug_info := 'Retrieve Activity Attr Response';
2209: -------------------------------------------------------------------
2210: l_response := WF_ENGINE.GetActivityAttrText(p_item_type,
2211: p_item_key,
2212: p_actid,
2213: 'RESPONSE');
2214:

Line 2239: WF_ENGINE.SetItemAttrText(p_item_type,

2235: l_debug_info := 'clear Item Attribute PREPARER_RESPONSE';
2236: -- this assumes preparer response, if we need to change this
2237: -- later then change Activity Attr RESPONSE to pass item attr
2238: ---------------------------------------------------------
2239: WF_ENGINE.SetItemAttrText(p_item_type,
2240: p_item_key,
2241: 'PREPARER_RESPONSE',
2242: '');
2243:

Line 2249: l_fnd_message := WF_ENGINE.GetActivityAttrText(p_item_type,

2245:
2246: -------------------------------------------------------------------
2247: l_debug_info := 'Retrieve Activity Attr FND Message';
2248: -------------------------------------------------------------------
2249: l_fnd_message := WF_ENGINE.GetActivityAttrText(p_item_type,
2250: p_item_key,
2251: p_actid,
2252: 'FND_MESSAGE');
2253: if (l_fnd_message in ('APWRECPT_OVERDUE_SENT','APWRECPT_IMG_OVERDUE_SENT',

Line 2259: l_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,

2255: 'APWRECPT_RECEIVED_SENT','APWRECPT_IMG_RECEIVED_SENT')) then
2256:
2257: if (l_fnd_message in ('APWRECPT_OVERDUE_SENT','APWRECPT_MISSING_SENT')) then
2258:
2259: l_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,
2260: p_item_key,
2261: 'DAYS_OVERDUE');
2262: FND_MESSAGE.SET_NAME('SQLAP', l_fnd_message);
2263: FND_MESSAGE.SET_TOKEN('DAYS_OVERDUE', to_char(l_days_overdue));

Line 2267: l_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,

2263: FND_MESSAGE.SET_TOKEN('DAYS_OVERDUE', to_char(l_days_overdue));
2264:
2265: elsif (l_fnd_message in ('APWRECPT_IMG_OVERDUE_SENT','APWRECPT_IMG_MISSING_SENT')) then
2266:
2267: l_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,
2268: p_item_key,
2269: 'IMAGE_DAYS_OVERDUE');
2270: FND_MESSAGE.SET_NAME('SQLAP', l_fnd_message);
2271: FND_MESSAGE.SET_TOKEN('DAYS_OVERDUE', to_char(l_days_overdue));

Line 2344: l_org_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

2340: BEGIN
2341:
2342: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start CallbackFunction');
2343:
2344: l_org_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
2345: p_item_key,
2346: 'ORG_ID');
2347:
2348: if (l_org_id is null) then

Line 2350: l_expense_report_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

2346: 'ORG_ID');
2347:
2348: if (l_org_id is null) then
2349: -- EXPENSE_REPORT_ID item attribute should exist
2350: l_expense_report_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
2351: p_item_key,
2352: 'EXPENSE_REPORT_ID');
2353:
2354: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(l_expense_report_id, l_org_id) <> TRUE) THEN

Line 2358: WF_ENGINE.SetItemAttrNumber(p_item_type,

2354: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(l_expense_report_id, l_org_id) <> TRUE) THEN
2355: l_org_id := NULL;
2356: END IF;
2357:
2358: WF_ENGINE.SetItemAttrNumber(p_item_type,
2359: p_item_key,
2360: 'ORG_ID',
2361: l_org_id);
2362: end if;

Line 2927: WF_ENGINE.CreateProcess(l_item_type, l_item_key , 'INFORM_MANAGER_OVERDUE');

2923:
2924: IF (l_supervisor_id IS NOT NULL) THEN
2925: l_item_key := l_item_key || '-' || l_supervisor_id;
2926: fnd_file.put_line(fnd_file.log, 'Create Process ' || l_item_key);
2927: WF_ENGINE.CreateProcess(l_item_type, l_item_key , 'INFORM_MANAGER_OVERDUE');
2928:
2929:
2930: IF (AP_WEB_EXPENSE_WF.CheckSurrogateManager(l_supervisor_id, l_supervisor_id, p_surrogate_mgr_id)) THEN
2931: WF_DIRECTORY.GetUserName('PER',

Line 2943: WF_ENGINE.SetItemAttrText(l_item_type,

2939: l_supName,
2940: l_supDisplayName);
2941: fnd_file.put_line(fnd_file.log, 'Sending Notifications to Supervisor ' || l_supName);
2942: END IF;
2943: WF_ENGINE.SetItemAttrText(l_item_type,
2944: l_item_key,
2945: 'SUPERVISOR',
2946: l_supName);
2947: WF_ENGINE.SetItemAttrNumber(l_item_type,

Line 2947: WF_ENGINE.SetItemAttrNumber(l_item_type,

2943: WF_ENGINE.SetItemAttrText(l_item_type,
2944: l_item_key,
2945: 'SUPERVISOR',
2946: l_supName);
2947: WF_ENGINE.SetItemAttrNumber(l_item_type,
2948: l_item_key,
2949: 'SUPERVISOR_ID',
2950: l_supervisor_id);
2951: WF_ENGINE.SetItemAttrNumber(l_item_type,

Line 2951: WF_ENGINE.SetItemAttrNumber(l_item_type,

2947: WF_ENGINE.SetItemAttrNumber(l_item_type,
2948: l_item_key,
2949: 'SUPERVISOR_ID',
2950: l_supervisor_id);
2951: WF_ENGINE.SetItemAttrNumber(l_item_type,
2952: l_item_key,
2953: 'OVERDUE_REQUEST_ID',
2954: FND_GLOBAL.CONC_REQUEST_ID);
2955: WF_ENGINE.StartProcess(l_item_type, l_item_key);

Line 2955: WF_ENGINE.StartProcess(l_item_type, l_item_key);

2951: WF_ENGINE.SetItemAttrNumber(l_item_type,
2952: l_item_key,
2953: 'OVERDUE_REQUEST_ID',
2954: FND_GLOBAL.CONC_REQUEST_ID);
2955: WF_ENGINE.StartProcess(l_item_type, l_item_key);
2956: fnd_file.put_line(fnd_file.log, 'Start Process ' || l_item_key);
2957: END IF;
2958: end loop;
2959: fnd_file.put_line(fnd_file.log, 'Done Processing Notifications to the management');

Line 3004: l_img_missing_event := WF_ENGINE.GetActivityAttrText(p_item_type,

3000: l_result_type VARCHAR2(50);
3001: BEGIN
3002: IF (p_funmode = 'RUN') THEN
3003:
3004: l_img_missing_event := WF_ENGINE.GetActivityAttrText(p_item_type,
3005: p_item_key,
3006: p_actid,
3007: 'IMAGE_MISSING_EVENT');
3008: BEGIN

Line 3010: l_result_type := WF_ENGINE.GetItemAttrText(p_item_type,

3006: p_actid,
3007: 'IMAGE_MISSING_EVENT');
3008: BEGIN
3009: IF (l_img_missing_event = 'Y') THEN
3010: l_result_type := WF_ENGINE.GetItemAttrText(p_item_type,
3011: p_item_key,
3012: 'MISSING_TYPE_REQUIRED');
3013: ELSE
3014: l_result_type := WF_ENGINE.GetItemAttrText(p_item_type,

Line 3014: l_result_type := WF_ENGINE.GetItemAttrText(p_item_type,

3010: l_result_type := WF_ENGINE.GetItemAttrText(p_item_type,
3011: p_item_key,
3012: 'MISSING_TYPE_REQUIRED');
3013: ELSE
3014: l_result_type := WF_ENGINE.GetItemAttrText(p_item_type,
3015: p_item_key,
3016: 'OVERDUE_TYPE_REQUIRED');
3017: END IF;
3018: EXCEPTION

Line 3051: l_report_submitted_date := WF_ENGINE.GetItemAttrDate(p_item_type,

3047: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(l_expense_report_id, l_org_id) <> TRUE) THEN
3048: l_org_id := NULL;
3049: END IF;
3050:
3051: l_report_submitted_date := WF_ENGINE.GetItemAttrDate(p_item_type,
3052: p_item_key,
3053: 'EXPENSE_REPORT_SUBMIT_DATE');
3054:
3055: AP_WEB_AUDIT_UTILS.get_rule(l_org_id, l_report_submitted_date, C_RECEIPT_RULE, l_receipt_rule);

Line 3058: l_img_missing_event := WF_ENGINE.GetActivityAttrText(p_item_type,

3054:
3055: AP_WEB_AUDIT_UTILS.get_rule(l_org_id, l_report_submitted_date, C_RECEIPT_RULE, l_receipt_rule);
3056:
3057: BEGIN
3058: l_img_missing_event := WF_ENGINE.GetActivityAttrText(p_item_type,
3059: p_item_key,
3060: p_actid,
3061: 'IMAGE_MISSING_EVENT');
3062: EXCEPTION

Line 3182: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

3178: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_RECEIPTS_WF', 'start CheckNotifyImageReceived');
3179:
3180: IF (p_funmode = 'RUN') THEN
3181:
3182: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
3183: p_item_key,
3184: 'EXPENSE_REPORT_ID');
3185:
3186: ------------------------------------------------------------

Line 3194: l_notif_received := WF_ENGINE.GetItemAttrText(p_item_type,

3190:
3191: ----------------------------------------------------------
3192: l_debug_info := 'Check if Notify Receipts Received is enabled';
3193: ----------------------------------------------------------
3194: l_notif_received := WF_ENGINE.GetItemAttrText(p_item_type,
3195: p_item_key,
3196: 'NOTIF_RULE_NOTIF_RECEIVED');
3197:
3198: ----------------------------------------------------------

Line 3201: l_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,

3197:
3198: ----------------------------------------------------------
3199: l_debug_info := 'Check if Days Overdue';
3200: ----------------------------------------------------------
3201: l_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,
3202: p_item_key,
3203: 'IMAGE_DAYS_OVERDUE');
3204:
3205:

Line 3247: l_receipts_status := WF_ENGINE.GetActivityAttrText(p_item_type,

3243:
3244: -------------------------------------------------------------------
3245: l_debug_info := 'Retrieve Activity Attr Receipts Status';
3246: -------------------------------------------------------------------
3247: l_receipts_status := WF_ENGINE.GetActivityAttrText(p_item_type,
3248: p_item_key,
3249: p_actid,
3250: 'IMAGE_RECEIPTS_STATUS');
3251:

Line 3255: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

3251:
3252: ------------------------------------------------------------
3253: l_debug_info := 'Retrieve Expense_Report_ID Item Attribute';
3254: ------------------------------------------------------------
3255: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
3256: p_item_key,
3257: 'EXPENSE_REPORT_ID');
3258:
3259: ------------------------------------------------------------

Line 3335: l_report_submitted_date := WF_ENGINE.GetItemAttrDate(p_item_type,

3331: DAYS_OVERDUE is the diff between notif sent date and date the
3332: the expense report receipts package became overdue
3333: notif sent date - (report submission date + NOTIF_RULE_DAYS_OVERDUE)
3334: */
3335: l_report_submitted_date := WF_ENGINE.GetItemAttrDate(p_item_type,
3336: p_item_key,
3337: 'EXPENSE_REPORT_SUBMIT_DATE');
3338:
3339:

Line 3340: l_notif_image_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,

3336: p_item_key,
3337: 'EXPENSE_REPORT_SUBMIT_DATE');
3338:
3339:
3340: l_notif_image_days_overdue := WF_ENGINE.GetItemAttrNumber(p_item_type,
3341: p_item_key,
3342: 'NOTIF_IMAGE_DAYS_OVERDUE');
3343:
3344: l_img_days_overdue := trunc(sysdate) - (trunc(l_report_submitted_date) );--+ l_notif_image_days_overdue);

Line 3350: WF_ENGINE.SetItemAttrNumber(p_item_type, p_item_key, 'IMAGE_DAYS_OVERDUE', l_img_days_overdue);

3346: ----------------------------------------------------------
3347: l_debug_info := 'Set IMAGE_DAYS_OVERDUE Item Attribute';
3348: ----------------------------------------------------------
3349:
3350: WF_ENGINE.SetItemAttrNumber(p_item_type, p_item_key, 'IMAGE_DAYS_OVERDUE', l_img_days_overdue);
3351:
3352: ------------------------------------------------------------
3353: l_debug_info := 'Retrieve Expense_Report_ID Item Attribute';
3354: ------------------------------------------------------------

Line 3355: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

3351:
3352: ------------------------------------------------------------
3353: l_debug_info := 'Retrieve Expense_Report_ID Item Attribute';
3354: ------------------------------------------------------------
3355: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
3356: p_item_key,
3357: 'EXPENSE_REPORT_ID');
3358:
3359: l_receipts_status := GetImageReceiptsStatus(l_report_header_id);

Line 3399: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

3395:
3396: ------------------------------------------------------------
3397: l_debug_info := 'Retrieve Expense_Report_ID Item Attribute';
3398: ------------------------------------------------------------
3399: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
3400: p_item_key,
3401: 'EXPENSE_REPORT_ID');
3402:
3403: ------------------------------------------------------------

Line 3508: l_report_submitted_date := WF_ENGINE.GetItemAttrDate(p_item_type,

3504: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(l_expense_report_id, l_org_id) <> TRUE) THEN
3505: l_org_id := NULL;
3506: END IF;
3507:
3508: l_report_submitted_date := WF_ENGINE.GetItemAttrDate(p_item_type,
3509: p_item_key,
3510: 'EXPENSE_REPORT_SUBMIT_DATE');
3511:
3512: AP_WEB_AUDIT_UTILS.get_rule(l_org_id, l_report_submitted_date, C_RECEIPT_RULE, l_receipt_rule);

Line 3536: l_AMEEnabled := WF_ENGINE.GetItemAttrText(C_APEXP,

3532: 'NonValidatedWebExpense')) THEN
3533: NULL;
3534: END IF;
3535: BEGIN
3536: l_AMEEnabled := WF_ENGINE.GetItemAttrText(C_APEXP,
3537: l_item_key,
3538: 'AME_ENABLED');
3539: IF (l_AMEEnabled = 'Y') THEN
3540: --Bug 4425821: Uptake AME parallel approvers

Line 3564: wf_engine.AbortProcess (itemtype => C_APEXP,

3560: AP_WEB_DB_EXPLINE_PKG.resetAPflags(l_expense_report_id);
3561: --AP_WEB_RECEIPTS_WF.RaiseAbortedEvent(l_expense_report_id);
3562:
3563: BEGIN
3564: wf_engine.AbortProcess (itemtype => C_APEXP,
3565: itemkey => l_item_key,
3566: cascade => TRUE);
3567: wf_purge.Items(itemtype => C_APEXP,
3568: itemkey => l_item_key);

Line 3624: l_report_submitted_date := WF_ENGINE.GetItemAttrDate(p_item_type,

3620: IF (AP_WEB_DB_EXPRPT_PKG.GetOrgIdByReportHeaderId(l_expense_report_id, l_org_id) <> TRUE) THEN
3621: l_org_id := NULL;
3622: END IF;
3623:
3624: l_report_submitted_date := WF_ENGINE.GetItemAttrDate(p_item_type,
3625: p_item_key,
3626: 'EXPENSE_REPORT_SUBMIT_DATE');
3627:
3628: AP_WEB_AUDIT_UTILS.get_rule(l_org_id, l_report_submitted_date, C_RECEIPT_RULE, l_receipt_rule);

Line 3658: l_result := WF_ENGINE.GetItemAttrText(p_item_type,

3654:
3655: BEGIN
3656: IF (p_funmode = 'RUN') THEN
3657: BEGIN
3658: l_result := WF_ENGINE.GetItemAttrText(p_item_type,
3659: p_item_key,
3660: 'RECEIVED_TYPE_REQUIRED');
3661: EXCEPTION
3662: WHEN OTHERS THEN

Line 3701: l_process_type := WF_ENGINE.GetActivityAttrText(p_item_type,

3697: l_result VARCHAR2(30);
3698:
3699: BEGIN
3700: IF (p_funmode = 'RUN') THEN
3701: l_process_type := WF_ENGINE.GetActivityAttrText(p_item_type,
3702: p_item_key,
3703: p_actid,
3704: 'PROCESS_TYPE');
3705:

Line 3707: l_result_type := WF_ENGINE.GetItemAttrText(p_item_type,

3703: p_actid,
3704: 'PROCESS_TYPE');
3705:
3706: IF (l_process_type = 'RECEIVED') THEN
3707: l_result_type := WF_ENGINE.GetItemAttrText(p_item_type,
3708: p_item_key,
3709: 'RECEIVED_TYPE_REQUIRED');
3710: ELSIF(l_process_type = 'OVERDUE') THEN
3711: l_result_type := WF_ENGINE.GetItemAttrText(p_item_type,

Line 3711: l_result_type := WF_ENGINE.GetItemAttrText(p_item_type,

3707: l_result_type := WF_ENGINE.GetItemAttrText(p_item_type,
3708: p_item_key,
3709: 'RECEIVED_TYPE_REQUIRED');
3710: ELSIF(l_process_type = 'OVERDUE') THEN
3711: l_result_type := WF_ENGINE.GetItemAttrText(p_item_type,
3712: p_item_key,
3713: 'OVERDUE_TYPE_REQUIRED');
3714: l_result_type := 'COMPLETE:'||l_result_type;
3715: ELSIF(l_process_type = 'MISSING') THEN

Line 3716: l_result_type := WF_ENGINE.GetItemAttrText(p_item_type,

3712: p_item_key,
3713: 'OVERDUE_TYPE_REQUIRED');
3714: l_result_type := 'COMPLETE:'||l_result_type;
3715: ELSIF(l_process_type = 'MISSING') THEN
3716: l_result_type := WF_ENGINE.GetItemAttrText(p_item_type,
3717: p_item_key,
3718: 'MISSING_TYPE_REQUIRED');
3719: l_result_type := 'COMPLETE:'||l_result_type;
3720: END IF;

Line 3788: l_receipts_status := WF_ENGINE.GetActivityAttrText(p_item_type,

3784: l_report_header_id NUMBER;
3785: l_event_key wf_items.item_key%type;
3786: BEGIN
3787: IF (p_funmode = 'RUN') THEN
3788: l_receipts_status := WF_ENGINE.GetActivityAttrText(p_item_type,
3789: p_item_key,
3790: p_actid,
3791: 'ORIG_RECEIPT_STATUS');
3792:

Line 3793: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

3789: p_item_key,
3790: p_actid,
3791: 'ORIG_RECEIPT_STATUS');
3792:
3793: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
3794: p_item_key,
3795: 'EXPENSE_REPORT_ID');
3796: IF (nvl(GetReceiptsStatus(l_report_header_id), 'NOT_REQUIRED') NOT IN ('NOT_REQUIRED', 'RECEIVED')) THEN
3797: SetReceiptsStatus(l_report_header_id, l_receipts_status);

Line 3828: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,

3824: l_wf_status_code VARCHAR2(1);
3825: l_report_header_id NUMBER;
3826: BEGIN
3827: IF (p_funmode = 'RUN') THEN
3828: l_report_header_id := WF_ENGINE.GetItemAttrNumber(p_item_type,
3829: p_item_key,
3830: 'EXPENSE_REPORT_ID');
3831: SELECT nvl(workflow_approved_flag, 1) INTO l_wf_status_code
3832: FROM ap_expense_report_headers_all