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

Line 264: IF (funcmode <> wf_engine.eng_run) THEN

260: l_esigner_exists VARCHAR2(1);
261:
262: BEGIN
263:
264: IF (funcmode <> wf_engine.eng_run) THEN
265: resultout := wf_engine.eng_null;
266: RETURN;
267: END IF;
268:

Line 265: resultout := wf_engine.eng_null;

261:
262: BEGIN
263:
264: IF (funcmode <> wf_engine.eng_run) THEN
265: resultout := wf_engine.eng_null;
266: RETURN;
267: END IF;
268:
269: --Set the global attributes in the po wrapper function

Line 291: resultout := wf_engine.eng_completed||':'||'INVALID_APPROVER';

287: -- Check if there is any AME exception. If yes, then return 'invalid approver'
288: l_ame_exception := po_wf_util_pkg.GetItemAttrText( aname => 'AME_EXCEPTION');
289:
290: IF l_ame_exception IS NOT NULL THEN
291: resultout := wf_engine.eng_completed||':'||'INVALID_APPROVER';
292: RETURN;
293: END IF;
294:
295: l_document_type := po_wf_util_pkg.GetItemAttrText( aname => 'DOCUMENT_TYPE');

Line 356: resultout:= wf_engine.eng_completed||':'||'VALID_ESIGNER';

352: IF (g_po_wf_debug = 'Y') THEN
353: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' BEFORE update_pending_signature');
354: END IF;
355: update_pending_signature(itemtype, itemkey, l_document_id);
356: resultout:= wf_engine.eng_completed||':'||'VALID_ESIGNER';
357: RETURN;
358: END IF; -- l_esigner_flag = 'Y'
359: END IF; -- l_esigner_exists = 'N'
360:

Line 383: resultout := wf_engine.eng_completed||':'||'INVALID_APPROVER';

379: -- If the count is zero then verify the approval process is completed or not.
380:
381: IF ( g_next_approvers.count > 0 ) THEN
382: IF( 'N' = l_position_has_valid_approvers ) THEN
383: resultout := wf_engine.eng_completed||':'||'INVALID_APPROVER';
384: ELSE
385: resultout:= wf_engine.eng_completed||':'||'VALID_APPROVER';
386: END IF; -- l_position_has_valid_approvers IF
387: ELSE

Line 385: resultout:= wf_engine.eng_completed||':'||'VALID_APPROVER';

381: IF ( g_next_approvers.count > 0 ) THEN
382: IF( 'N' = l_position_has_valid_approvers ) THEN
383: resultout := wf_engine.eng_completed||':'||'INVALID_APPROVER';
384: ELSE
385: resultout:= wf_engine.eng_completed||':'||'VALID_APPROVER';
386: END IF; -- l_position_has_valid_approvers IF
387: ELSE
388: IF (l_completeYNO IN ('X','Y')) THEN
389: -- Check whether if signer existed. If yes, we need to end with Signer Complete process.

Line 392: resultout := wf_engine.eng_completed||':'||'NO_NEXT_APPROVER';

388: IF (l_completeYNO IN ('X','Y')) THEN
389: -- Check whether if signer existed. If yes, we need to end with Signer Complete process.
390: -- Else on normal approval process.
391: IF (l_esigner_exists = 'N') THEN
392: resultout := wf_engine.eng_completed||':'||'NO_NEXT_APPROVER';
393: ELSE
394: resultout := wf_engine.eng_completed||':'||'NO_NEXT_APPROVER_ESIGNER';
395: END IF;
396: ELSE

Line 394: resultout := wf_engine.eng_completed||':'||'NO_NEXT_APPROVER_ESIGNER';

390: -- Else on normal approval process.
391: IF (l_esigner_exists = 'N') THEN
392: resultout := wf_engine.eng_completed||':'||'NO_NEXT_APPROVER';
393: ELSE
394: resultout := wf_engine.eng_completed||':'||'NO_NEXT_APPROVER_ESIGNER';
395: END IF;
396: ELSE
397: resultout:= wf_engine.eng_completed||':'||'';
398: END IF; -- l_completeYNO IF

Line 397: resultout:= wf_engine.eng_completed||':'||'';

393: ELSE
394: resultout := wf_engine.eng_completed||':'||'NO_NEXT_APPROVER_ESIGNER';
395: END IF;
396: ELSE
397: resultout:= wf_engine.eng_completed||':'||'';
398: END IF; -- l_completeYNO IF
399: END IF; --g_next_approvers.count > 0 IF
400:
401: RETURN;

Line 411: resultout:= wf_engine.eng_completed||':'||'INVALID_APPROVER';

407: PO_REQAPPROVAL_INIT1.send_error_notif(itemType, itemkey, l_preparer_user_name, l_doc_string, sqlerrm, l_progress, l_document_id);
408: IF (g_po_wf_debug = 'Y') THEN
409: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress);
410: END IF;
411: resultout:= wf_engine.eng_completed||':'||'INVALID_APPROVER';
412: RETURN;
413: END get_next_approvers;
414:
415: --------------------------------------------------------------------------------

Line 453: IF (funcmode <> wf_engine.eng_run) THEN

449: l_api_name VARCHAR2(500) := 'is_ame_exception';
450: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
451: BEGIN
452:
453: IF (funcmode <> wf_engine.eng_run) THEN
454: resultout := wf_engine.eng_null;
455: RETURN;
456: END IF;
457:

Line 454: resultout := wf_engine.eng_null;

450: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
451: BEGIN
452:
453: IF (funcmode <> wf_engine.eng_run) THEN
454: resultout := wf_engine.eng_null;
455: RETURN;
456: END IF;
457:
458: --Set the global attributes in the po wrapper function

Line 466: resultout := wf_engine.eng_completed || ':' ||'Y';

462: l_progress := '010';
463: l_ame_exception :=PO_WF_UTIL_PKG.GetItemAttrText (aname => 'AME_EXCEPTION');
464:
465: IF l_ame_exception IS NOT NULL THEN
466: resultout := wf_engine.eng_completed || ':' ||'Y';
467: ELSE
468: resultout := wf_engine.eng_completed || ':' ||'N';
469: END IF;
470:

Line 468: resultout := wf_engine.eng_completed || ':' ||'N';

464:
465: IF l_ame_exception IS NOT NULL THEN
466: resultout := wf_engine.eng_completed || ':' ||'Y';
467: ELSE
468: resultout := wf_engine.eng_completed || ':' ||'N';
469: END IF;
470:
471: EXCEPTION
472: WHEN OTHERS THEN

Line 715: n_varname wf_engine.nametabtyp;

711: l_orig_system VARCHAR2(48);
712: l_org_id NUMBER;
713: l_functional_currency VARCHAR2(30);
714: l_transaction_type po_document_types.ame_transaction_type%TYPE;
715: n_varname wf_engine.nametabtyp;
716: n_varval wf_engine.numtabtyp;
717: t_po_varname wf_engine.nametabtyp;
718: t_po_varval wf_engine.texttabtyp;
719: l_no_positionholder EXCEPTION;

Line 716: n_varval wf_engine.numtabtyp;

712: l_org_id NUMBER;
713: l_functional_currency VARCHAR2(30);
714: l_transaction_type po_document_types.ame_transaction_type%TYPE;
715: n_varname wf_engine.nametabtyp;
716: n_varval wf_engine.numtabtyp;
717: t_po_varname wf_engine.nametabtyp;
718: t_po_varval wf_engine.texttabtyp;
719: l_no_positionholder EXCEPTION;
720: l_preparer_user_name fnd_user.user_name%TYPE;

Line 717: t_po_varname wf_engine.nametabtyp;

713: l_functional_currency VARCHAR2(30);
714: l_transaction_type po_document_types.ame_transaction_type%TYPE;
715: n_varname wf_engine.nametabtyp;
716: n_varval wf_engine.numtabtyp;
717: t_po_varname wf_engine.nametabtyp;
718: t_po_varval wf_engine.texttabtyp;
719: l_no_positionholder EXCEPTION;
720: l_preparer_user_name fnd_user.user_name%TYPE;
721: l_doc_string VARCHAR2(200);

Line 718: t_po_varval wf_engine.texttabtyp;

714: l_transaction_type po_document_types.ame_transaction_type%TYPE;
715: n_varname wf_engine.nametabtyp;
716: n_varval wf_engine.numtabtyp;
717: t_po_varname wf_engine.nametabtyp;
718: t_po_varval wf_engine.texttabtyp;
719: l_no_positionholder EXCEPTION;
720: l_preparer_user_name fnd_user.user_name%TYPE;
721: l_doc_string VARCHAR2(200);
722: l_start_block_activity VARCHAR2(1);

Line 737: IF (funcmode <> wf_engine.eng_run) THEN

733: l_userkey PO_HEADERS_ALL.SEGMENT1%TYPE;
734:
735: BEGIN
736:
737: IF (funcmode <> wf_engine.eng_run) THEN
738: resultout := wf_engine.eng_null;
739: RETURN;
740: END IF;
741:

Line 738: resultout := wf_engine.eng_null;

734:
735: BEGIN
736:
737: IF (funcmode <> wf_engine.eng_run) THEN
738: resultout := wf_engine.eng_null;
739: RETURN;
740: END IF;
741:
742: --Set the global attributes in the po wrapper function

Line 781: wf_engine.CreateProcess ( itemtype => itemtype,

777: INTO l_item_key
778: FROM sys.dual;
779:
780: --Create the parallel process
781: wf_engine.CreateProcess ( itemtype => itemtype,
782: itemkey => l_item_key,
783: process => 'PARALLEL_APPROVAL_PROCESS');
784: --Set parent attributes
785: wf_engine.SetItemParent ( itemtype => itemtype,

Line 785: wf_engine.SetItemParent ( itemtype => itemtype,

781: wf_engine.CreateProcess ( itemtype => itemtype,
782: itemkey => l_item_key,
783: process => 'PARALLEL_APPROVAL_PROCESS');
784: --Set parent attributes
785: wf_engine.SetItemParent ( itemtype => itemtype,
786: itemkey => l_item_key,
787: parent_itemtype => itemtype,
788: parent_itemkey => itemkey,
789: parent_context => NULL );

Line 1014: wf_engine.SetItemAttrTextarray (itemtype, l_item_key, t_po_varname, t_po_varval);

1010: t_po_varval (41) := po_wf_util_pkg.GetItemAttrText (aname => 'REQUIRES_ESIGN_MSG');
1011:
1012: --Set the item attributes from the array
1013: l_progress := '080';
1014: wf_engine.SetItemAttrTextarray (itemtype, l_item_key, t_po_varname, t_po_varval);
1015:
1016: l_progress := '090';
1017: n_varname (1) := 'DOCUMENT_ID';
1018: n_varval (1) := l_document_id;

Line 1056: wf_engine.SetItemAttrNumberArray (itemtype, l_item_key, n_varname, n_varval);

1052: n_varval (9) := po_wf_util_pkg.GetItemAttrNumber (aname => 'DRAFT_ID');
1053: n_varname (10) := 'REVISION_NUMBER';
1054: n_varval (10) := po_wf_util_pkg.GetItemAttrNumber (aname => 'REVISION_NUMBER');
1055:
1056: wf_engine.SetItemAttrNumberArray (itemtype, l_item_key, n_varname, n_varval);
1057:
1058: l_progress := '100';
1059:
1060: wf_engine.SetItemOwner(

Line 1060: wf_engine.SetItemOwner(

1056: wf_engine.SetItemAttrNumberArray (itemtype, l_item_key, n_varname, n_varval);
1057:
1058: l_progress := '100';
1059:
1060: wf_engine.SetItemOwner(
1061: itemtype => itemtype,
1062: itemkey => l_item_key,
1063: owner => l_owner_user_name);
1064:

Line 1065: wf_engine.SetItemUserKey(

1061: itemtype => itemtype,
1062: itemkey => l_item_key,
1063: owner => l_owner_user_name);
1064:
1065: wf_engine.SetItemUserKey(
1066: itemtype => itemtype,
1067: itemkey => l_item_key,
1068: userkey => l_userkey);
1069:

Line 1071: wf_engine.StartProcess (itemtype => itemtype ,itemkey => l_item_key);

1067: itemkey => l_item_key,
1068: userkey => l_userkey);
1069:
1070: --Kick off the process
1071: wf_engine.StartProcess (itemtype => itemtype ,itemkey => l_item_key);
1072:
1073: --Move to the next index
1074: l_approver_index := g_next_approvers.next (l_approver_index);
1075:

Line 1081: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

1077:
1078: l_progress := '110';
1079:
1080: IF l_start_block_activity = 'Y' THEN
1081: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
1082: ELSE
1083: resultout := wf_engine.eng_completed || ':' || '';
1084: END IF;
1085:

Line 1083: resultout := wf_engine.eng_completed || ':' || '';

1079:
1080: IF l_start_block_activity = 'Y' THEN
1081: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
1082: ELSE
1083: resultout := wf_engine.eng_completed || ':' || '';
1084: END IF;
1085:
1086: -- After routing is done, delete approver list
1087: g_next_approvers.delete;

Line 1135: IF (funcmode <> wf_engine.eng_run) THEN

1131: IS
1132: l_approver_category VARCHAR2(100);
1133: BEGIN
1134:
1135: IF (funcmode <> wf_engine.eng_run) THEN
1136: resultout := wf_engine.eng_null;
1137: RETURN;
1138: END IF;
1139:

Line 1136: resultout := wf_engine.eng_null;

1132: l_approver_category VARCHAR2(100);
1133: BEGIN
1134:
1135: IF (funcmode <> wf_engine.eng_run) THEN
1136: resultout := wf_engine.eng_null;
1137: RETURN;
1138: END IF;
1139:
1140: --Set the global attributes in the po wrapper function

Line 1146: resultout := wf_engine.eng_completed || ':' || l_approver_category;

1142: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
1143:
1144: --Logic is check for workflow attribute 'APPROVER_CATEGORY' and pass it ahead
1145: l_approver_category := po_wf_util_pkg.GetItemAttrText (aname => 'APPROVER_CATEGORY');
1146: resultout := wf_engine.eng_completed || ':' || l_approver_category;
1147:
1148: END determine_approver_category;
1149: --------------------------------------------------------------------------------
1150: --Start of Comments

Line 1397: IF (funcmode <> wf_engine.eng_run) THEN

1393: l_api_name VARCHAR2(500) := 'process_response_exception';
1394: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
1395: BEGIN
1396:
1397: IF (funcmode <> wf_engine.eng_run) THEN
1398: resultout := wf_engine.eng_null;
1399: RETURN;
1400: END IF;
1401:

Line 1398: resultout := wf_engine.eng_null;

1394: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
1395: BEGIN
1396:
1397: IF (funcmode <> wf_engine.eng_run) THEN
1398: resultout := wf_engine.eng_null;
1399: RETURN;
1400: END IF;
1401:
1402: --Set the global attributes in the po wrapper function

Line 1420: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

1416:
1417: -- Call process_response_internal with 'EXCEPTION'
1418: process_response_internal(itemtype, itemkey, 'EXCEPTION');
1419: po_wf_util_pkg.SetItemAttrText(aname => 'AME_SUB_APPROVAL_RESPONSE', avalue => 'EXCEPTION');
1420: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
1421: RETURN;
1422: END Process_Response_Exception;
1423:
1424: --------------------------------------------------------------------------------

Line 1469: IF (funcmode <> wf_engine.eng_run) THEN

1465: l_api_name VARCHAR2(500) := 'insert_action_history';
1466: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
1467: BEGIN
1468:
1469: IF (funcmode <> wf_engine.eng_run) THEN
1470: resultout := wf_engine.eng_null;
1471: RETURN;
1472: END IF;
1473:

Line 1470: resultout := wf_engine.eng_null;

1466: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
1467: BEGIN
1468:
1469: IF (funcmode <> wf_engine.eng_run) THEN
1470: resultout := wf_engine.eng_null;
1471: RETURN;
1472: END IF;
1473:
1474: --Set the global attributes in the po wrapper function

Line 1517: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

1513:
1514: --Reset the FORWARD_TO_USERNAME_RESPONSE and NOTE attributes
1515: po_wf_util_pkg.SetItemAttrText( aname => 'FORWARD_TO_USERNAME_RESPONSE', avalue => NULL);
1516: po_wf_util_pkg.SetItemAttrText( aname => 'NOTE', avalue => NULL);
1517: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
1518:
1519: RETURN;
1520:
1521: EXCEPTION

Line 1581: IF (funcmode <> wf_engine.eng_run) THEN

1577: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
1578:
1579: BEGIN
1580:
1581: IF (funcmode <> wf_engine.eng_run) THEN
1582: resultout := wf_engine.eng_null;
1583: RETURN;
1584: END IF;
1585:

Line 1582: resultout := wf_engine.eng_null;

1578:
1579: BEGIN
1580:
1581: IF (funcmode <> wf_engine.eng_run) THEN
1582: resultout := wf_engine.eng_null;
1583: RETURN;
1584: END IF;
1585:
1586: --Set the global attributes in the po wrapper function

Line 1625: resultout := wf_engine.eng_completed||':'||'ACTIVITY_PERFORMED';

1621: p_current_approver => l_current_approver);
1622:
1623: l_progress := '030';
1624: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_RESPONSE', avalue => 'FORWARD' );
1625: resultout := wf_engine.eng_completed||':'||'ACTIVITY_PERFORMED';
1626:
1627: EXCEPTION
1628: WHEN OTHERS THEN
1629: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

Line 1687: IF (funcmode <> wf_engine.eng_run) THEN

1683: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
1684:
1685: BEGIN
1686:
1687: IF (funcmode <> wf_engine.eng_run) THEN
1688: resultout := wf_engine.eng_null;
1689: RETURN;
1690: END IF;
1691:

Line 1688: resultout := wf_engine.eng_null;

1684:
1685: BEGIN
1686:
1687: IF (funcmode <> wf_engine.eng_run) THEN
1688: resultout := wf_engine.eng_null;
1689: RETURN;
1690: END IF;
1691:
1692: --Set the global attributes in the po wrapper function

Line 1748: resultout := wf_engine.eng_completed||':'||'ACTIVITY_PERFORMED';

1744: p_note =>l_note,
1745: p_current_approver => l_current_approver);
1746:
1747: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_RESPONSE', avalue => 'APPROVED' );
1748: resultout := wf_engine.eng_completed||':'||'ACTIVITY_PERFORMED';
1749: RETURN;
1750:
1751: EXCEPTION
1752: WHEN OTHERS THEN

Line 1810: IF (funcmode <> wf_engine.eng_run) THEN

1806: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
1807:
1808: BEGIN
1809:
1810: IF (funcmode <> wf_engine.eng_run) THEN
1811: resultout := wf_engine.eng_null;
1812: RETURN;
1813: END IF;
1814:

Line 1811: resultout := wf_engine.eng_null;

1807:
1808: BEGIN
1809:
1810: IF (funcmode <> wf_engine.eng_run) THEN
1811: resultout := wf_engine.eng_null;
1812: RETURN;
1813: END IF;
1814:
1815: --Set the global attributes in the po wrapper function

Line 1871: resultout := wf_engine.eng_completed||':'|| 'ACTIVITY_PERFORMED';

1867: p_note =>l_note,
1868: p_current_approver => l_current_approver);
1869:
1870: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_RESPONSE', avalue => 'REJECTED' );
1871: resultout := wf_engine.eng_completed||':'|| 'ACTIVITY_PERFORMED';
1872:
1873: EXCEPTION
1874: WHEN OTHERS THEN
1875: l_doc_string := PO_REQAPPROVAL_INIT1.get_error_doc(itemType, itemkey);

Line 1931: IF (funcmode <> wf_engine.eng_run) THEN

1927: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
1928:
1929: BEGIN
1930:
1931: IF (funcmode <> wf_engine.eng_run) THEN
1932: resultout := wf_engine.eng_null;
1933: RETURN;
1934: END IF;
1935:

Line 1932: resultout := wf_engine.eng_null;

1928:
1929: BEGIN
1930:
1931: IF (funcmode <> wf_engine.eng_run) THEN
1932: resultout := wf_engine.eng_null;
1933: RETURN;
1934: END IF;
1935:
1936: --Set the global attributes in the po wrapper function

Line 1978: resultout := wf_engine.eng_completed||':'||'ACTIVITY_PERFORMED';

1974: p_action => l_action,
1975: p_note =>l_note,
1976: p_current_approver => l_current_approver);
1977:
1978: resultout := wf_engine.eng_completed||':'||'ACTIVITY_PERFORMED';
1979: RETURN;
1980:
1981: EXCEPTION
1982: WHEN OTHERS THEN

Line 2039: IF (funcmode <> wf_engine.eng_run) THEN

2035: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
2036:
2037: BEGIN
2038:
2039: IF (funcmode <> wf_engine.eng_run) THEN
2040: resultout := wf_engine.eng_null;
2041: RETURN;
2042: END IF;
2043:

Line 2040: resultout := wf_engine.eng_null;

2036:
2037: BEGIN
2038:
2039: IF (funcmode <> wf_engine.eng_run) THEN
2040: resultout := wf_engine.eng_null;
2041: RETURN;
2042: END IF;
2043:
2044: --Set the global attributes in the po wrapper function

Line 2086: resultout := wf_engine.eng_completed||':'||'ACTIVITY_PERFORMED';

2082: p_action => l_action,
2083: p_note => l_note,
2084: p_current_approver => l_current_approver);
2085:
2086: resultout := wf_engine.eng_completed||':'||'ACTIVITY_PERFORMED';
2087: RETURN;
2088:
2089: EXCEPTION
2090: WHEN OTHERS THEN

Line 2141: IF (funcmode <> wf_engine.eng_run) THEN

2137: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
2138:
2139: BEGIN
2140:
2141: IF (funcmode <> wf_engine.eng_run) THEN
2142: resultout := wf_engine.eng_null;
2143: RETURN;
2144: END IF;
2145:

Line 2142: resultout := wf_engine.eng_null;

2138:
2139: BEGIN
2140:
2141: IF (funcmode <> wf_engine.eng_run) THEN
2142: resultout := wf_engine.eng_null;
2143: RETURN;
2144: END IF;
2145:
2146: --Set the global attributes in the po wrapper function

Line 2195: resultout := wf_engine.eng_completed||':'||'ACTIVITY_PERFORMED';

2191: IF (g_po_wf_debug = 'Y') THEN
2192: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Process_Response_App_Forward completed');
2193: END IF;
2194:
2195: resultout := wf_engine.eng_completed||':'||'ACTIVITY_PERFORMED';
2196: RETURN;
2197:
2198: END Process_Response_App_Forward;
2199:

Line 2239: IF (funcmode <> wf_engine.eng_run) THEN

2235: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
2236:
2237: BEGIN
2238:
2239: IF (funcmode <> wf_engine.eng_run) THEN
2240: resultout := wf_engine.eng_null;
2241: RETURN;
2242: END IF;
2243:

Line 2240: resultout := wf_engine.eng_null;

2236:
2237: BEGIN
2238:
2239: IF (funcmode <> wf_engine.eng_run) THEN
2240: resultout := wf_engine.eng_null;
2241: RETURN;
2242: END IF;
2243:
2244: --Set the global attributes in the po wrapper function

Line 2290: resultout := wf_engine.eng_completed||':'||'ACTIVITY_PERFORMED';

2286: IF (g_po_wf_debug = 'Y') THEN
2287: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Completed');
2288: END IF;
2289:
2290: resultout := wf_engine.eng_completed||':'||'ACTIVITY_PERFORMED';
2291: RETURN;
2292:
2293: END Process_Response_Approve;
2294:

Line 2334: IF (funcmode <> wf_engine.eng_run) THEN

2330: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
2331:
2332: BEGIN
2333:
2334: IF (funcmode <> wf_engine.eng_run) THEN
2335: resultout := wf_engine.eng_null;
2336: RETURN;
2337: END IF;
2338:

Line 2335: resultout := wf_engine.eng_null;

2331:
2332: BEGIN
2333:
2334: IF (funcmode <> wf_engine.eng_run) THEN
2335: resultout := wf_engine.eng_null;
2336: RETURN;
2337: END IF;
2338:
2339: --Set the global attributes in the po wrapper function

Line 2387: resultout := wf_engine.eng_completed||':'||'ACTIVITY_PERFORMED';

2383: IF (g_po_wf_debug = 'Y') THEN
2384: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Completed');
2385: END IF;
2386:
2387: resultout := wf_engine.eng_completed||':'||'ACTIVITY_PERFORMED';
2388: RETURN;
2389:
2390: END Process_Response_Reject;
2391:

Line 2430: IF (funcmode <> wf_engine.eng_run) THEN

2426: l_api_name VARCHAR2(500) := 'process_response_forward';
2427: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
2428: BEGIN
2429:
2430: IF (funcmode <> wf_engine.eng_run) THEN
2431: resultout := wf_engine.eng_null;
2432: RETURN;
2433: END IF;
2434:

Line 2431: resultout := wf_engine.eng_null;

2427: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
2428: BEGIN
2429:
2430: IF (funcmode <> wf_engine.eng_run) THEN
2431: resultout := wf_engine.eng_null;
2432: RETURN;
2433: END IF;
2434:
2435: --Set the global attributes in the po wrapper function

Line 2481: resultout := wf_engine.eng_completed||':'||'ACTIVITY_PERFORMED';

2477: IF (g_po_wf_debug = 'Y') THEN
2478: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Completed');
2479: END IF;
2480:
2481: resultout := wf_engine.eng_completed||':'||'ACTIVITY_PERFORMED';
2482: RETURN;
2483:
2484: END Process_Response_Forward;
2485:

Line 2525: IF (funcmode <> wf_engine.eng_run) THEN

2521: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
2522:
2523: BEGIN
2524:
2525: IF (funcmode <> wf_engine.eng_run) THEN
2526: resultout := wf_engine.eng_null;
2527: RETURN;
2528: END IF;
2529:

Line 2526: resultout := wf_engine.eng_null;

2522:
2523: BEGIN
2524:
2525: IF (funcmode <> wf_engine.eng_run) THEN
2526: resultout := wf_engine.eng_null;
2527: RETURN;
2528: END IF;
2529:
2530: --Set the global attributes in the po wrapper function

Line 2574: wf_engine.CompleteActivity (itemtype => l_parent_item_type,

2570: po_wf_util_pkg.SetItemAttrText( aname => 'APPROVER_DISPLAY_NAME', avalue => l_child_approver_display_name );
2571:
2572: l_progress := '040';
2573:
2574: wf_engine.CompleteActivity (itemtype => l_parent_item_type,
2575: itemkey => l_parent_item_key,
2576: activity => 'BLOCK',
2577: result => NULL);
2578:

Line 2583: resultout := wf_engine.eng_completed||':'||'ACTIVITY_PERFORMED';

2579: IF (g_po_wf_debug = 'Y') THEN
2580: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Completed');
2581: END IF;
2582:
2583: resultout := wf_engine.eng_completed||':'||'ACTIVITY_PERFORMED';
2584: RETURN;
2585:
2586: END Process_Response_Timeout;
2587:

Line 2624: IF (funcmode <> wf_engine.eng_run) THEN

2620: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
2621:
2622: BEGIN
2623:
2624: IF (funcmode <> wf_engine.eng_run) THEN
2625: resultout := wf_engine.eng_null;
2626: RETURN;
2627: END IF;
2628:

Line 2625: resultout := wf_engine.eng_null;

2621:
2622: BEGIN
2623:
2624: IF (funcmode <> wf_engine.eng_run) THEN
2625: resultout := wf_engine.eng_null;
2626: RETURN;
2627: END IF;
2628:
2629: --Set the global attributes in the po wrapper function

Line 2652: resultout := wf_engine.eng_completed||':'||'ACTIVITY_PERFORMED';

2648: ELSIF l_no_reminder = 2 THEN
2649: po_wf_util_pkg.SetItemAttrText( aname => 'REMINDER_TEXT', avalue => 'Second Reminder' );
2650: END IF;
2651:
2652: resultout := wf_engine.eng_completed||':'||'ACTIVITY_PERFORMED';
2653: RETURN;
2654:
2655: END Increment_No_Reminder_Attr;
2656:

Line 2717: l_nid := wf_engine.context_nid;

2713: --Set the global attributes in the po wrapper function
2714: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
2715: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
2716:
2717: l_nid := wf_engine.context_nid;
2718: po_wf_util_pkg.SetItemAttrNumber( aname => 'NOTIFICATION_ID', avalue => l_nid);
2719:
2720: l_progress := '010';
2721: IF (g_po_wf_debug = 'Y') THEN

Line 2753: --If function mode in 'FORWARD','QUESTION','ANSWER', then fetch l_new_recipient_id from wf_engine.context_new_role.

2749: l_document_subtype := PO_WF_UTIL_PKG.GetItemAttrText ( aname => 'DOCUMENT_SUBTYPE');
2750: l_approval_group_id := po_wf_util_pkg.GetItemAttrNumber( aname => 'APPROVAL_GROUP_ID');
2751: l_revision_num := po_wf_util_pkg.GetItemAttrNumber( aname => 'REVISION_NUMBER');
2752:
2753: --If function mode in 'FORWARD','QUESTION','ANSWER', then fetch l_new_recipient_id from wf_engine.context_new_role.
2754: --Else fetch it from original_recipient.
2755: IF (funcmode <> 'TIMEOUT') THEN
2756:
2757: l_progress := '030';

Line 2758: wf_directory.GetRoleOrigSysInfo (wf_engine.context_new_role, l_origsys, l_new_recipient_id);

2754: --Else fetch it from original_recipient.
2755: IF (funcmode <> 'TIMEOUT') THEN
2756:
2757: l_progress := '030';
2758: wf_directory.GetRoleOrigSysInfo (wf_engine.context_new_role, l_origsys, l_new_recipient_id);
2759:
2760: ELSE
2761:
2762: l_progress := '040';

Line 2768: WHERE notification_id = WF_ENGINE.context_nid

2764: SELECT original_recipient,
2765: DECODE(more_info_role, NULL, recipient_role, more_info_role)
2766: INTO l_original_recipient, l_current_recipient_role
2767: FROM wf_notifications
2768: WHERE notification_id = WF_ENGINE.context_nid
2769: AND (more_info_role IS NOT NULL OR recipient_role <> original_recipient );
2770: EXCEPTION
2771: WHEN OTHERS THEN
2772: l_original_recipient := NULL;

Line 2797: wf_directory.getroleorigsysinfo (wf_engine.context_more_info_role, l_origsys, l_current_recipient_id);

2793: l_progress := '060';
2794:
2795: --Fetch the current recepient id
2796: IF (funcmode = 'ANSWER') THEN
2797: wf_directory.getroleorigsysinfo (wf_engine.context_more_info_role, l_origsys, l_current_recipient_id);
2798: ELSIF (funcmode = 'TIMEOUT') THEN
2799: Wf_Directory.GetRoleOrigSysInfo(l_current_recipient_role, l_origsys, l_current_recipient_id);
2800: ELSE
2801: wf_directory.getroleorigsysinfo (wf_engine.context_recipient_role, l_origsys, l_current_recipient_id);

Line 2801: wf_directory.getroleorigsysinfo (wf_engine.context_recipient_role, l_origsys, l_current_recipient_id);

2797: wf_directory.getroleorigsysinfo (wf_engine.context_more_info_role, l_origsys, l_current_recipient_id);
2798: ELSIF (funcmode = 'TIMEOUT') THEN
2799: Wf_Directory.GetRoleOrigSysInfo(l_current_recipient_role, l_origsys, l_current_recipient_id);
2800: ELSE
2801: wf_directory.getroleorigsysinfo (wf_engine.context_recipient_role, l_origsys, l_current_recipient_id);
2802: END IF;
2803:
2804: l_progress := '070';
2805: IF (g_po_wf_debug = 'Y') THEN

Line 2824: p_note => wf_engine.context_user_comment,

2820: p_draft_id => l_draft_id,
2821: p_document_type => l_document_type,
2822: p_document_subtype => l_document_subtype,
2823: p_action => l_action,
2824: p_note => wf_engine.context_user_comment,
2825: p_current_approver => l_current_recipient_id );
2826: --Insert null action record into action_history for l_new_recipient_id
2827: InsertActionHistoryPoAme(
2828: p_document_id => l_document_id,

Line 2841: resultout := wf_engine.eng_completed || ':' || wf_engine.eng_null;

2837:
2838: l_progress := '090';
2839:
2840: IF (funcmode <> 'TIMEOUT') THEN
2841: resultout := wf_engine.eng_completed || ':' || wf_engine.eng_null;
2842: END IF;
2843: RETURN;
2844:
2845: END IF; --IF(l_action IS NOT NULL) THEN

Line 2852: l_nid := wf_engine.context_nid;

2848: -- Preserve the response context
2849: IF (funcmode = 'RESPOND') THEN
2850:
2851: l_progress := '100';
2852: l_nid := wf_engine.context_nid;
2853: po_wf_util_pkg.SetItemAttrNumber( aname => 'NOTIFICATION_ID', avalue => l_nid);
2854:
2855: SELECT fu.user_id
2856: INTO l_responder_id

Line 2862: IF (wf_engine.preserved_context = TRUE) THEN

2858: wf_notifications wfn
2859: WHERE wfn.notification_id = l_nid
2860: AND wfn.original_recipient = fu.user_name;
2861:
2862: IF (wf_engine.preserved_context = TRUE) THEN
2863: l_preserved_ctx := 'TRUE';
2864: ELSE
2865: l_preserved_ctx := 'FALSE';
2866: END IF;

Line 2942: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;

2938: END IF; --IF (l_session_resp_id IS NULL) THEN
2939: END IF; --IF (l_responder_id <> l_session_user_id) THEN
2940: END IF; --IF (l_responder_id IS NOT NULL) THEN
2941:
2942: resultout := wf_engine.eng_completed||':'||wf_engine.eng_null;
2943:
2944: l_progress := '150';
2945: IF (g_po_wf_debug = 'Y') THEN
2946: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' Completed');

Line 2956: resultout := wf_engine.eng_completed;

2952:
2953: IF (funcmode = 'TRANSFER') THEN
2954: fnd_message.set_name ('PO','PO_WF_NOTIF_NO_TRANSFER');
2955: app_exception.raise_exception;
2956: resultout := wf_engine.eng_completed;
2957: RETURN;
2958: END IF;
2959:
2960: END post_approval_notif;

Line 3012: IF (funcmode <> wf_engine.eng_run) THEN

3008: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
3009:
3010: BEGIN
3011:
3012: IF (funcmode <> wf_engine.eng_run) THEN
3013: resultout := wf_engine.eng_null;
3014: RETURN;
3015: END IF;
3016:

Line 3013: resultout := wf_engine.eng_null;

3009:
3010: BEGIN
3011:
3012: IF (funcmode <> wf_engine.eng_run) THEN
3013: resultout := wf_engine.eng_null;
3014: RETURN;
3015: END IF;
3016:
3017: --Set the global attributes in the po wrapper function

Line 3230: IF (funcmode <> wf_engine.eng_run) THEN

3226: GROUP BY fl.file_name, dbms_lob.getlength(fl.file_data)
3227: ORDER BY fl.file_name;
3228:
3229: BEGIN
3230: IF (funcmode <> wf_engine.eng_run) THEN
3231: resultout := wf_engine.eng_null;
3232: RETURN;
3233: END IF;
3234:

Line 3231: resultout := wf_engine.eng_null;

3227: ORDER BY fl.file_name;
3228:
3229: BEGIN
3230: IF (funcmode <> wf_engine.eng_run) THEN
3231: resultout := wf_engine.eng_null;
3232: RETURN;
3233: END IF;
3234:
3235: --Set the global attributes in the po wrapper function

Line 3603: IF (funcmode <> wf_engine.eng_run) THEN

3599: l_api_name VARCHAR2(500) := 'forward_unable_to_reserve';
3600: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
3601:
3602: BEGIN
3603: IF (funcmode <> wf_engine.eng_run) THEN
3604: resultout := wf_engine.eng_null;
3605: RETURN;
3606: END IF;
3607:

Line 3604: resultout := wf_engine.eng_null;

3600: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
3601:
3602: BEGIN
3603: IF (funcmode <> wf_engine.eng_run) THEN
3604: resultout := wf_engine.eng_null;
3605: RETURN;
3606: END IF;
3607:
3608: --Set the global attributes in the po wrapper function

Line 3666: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

3662: p_employee_id => l_current_approver,
3663: p_approval_group_id => l_approval_group_id,
3664: p_action => NULL);
3665:
3666: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
3667:
3668: END forward_unable_to_reserve;
3669:
3670: --------------------------------------------------------------------------------

Line 3749: IF (funcmode <> wf_engine.eng_run) THEN

3745: l_draft_id NUMBER;
3746:
3747: BEGIN
3748:
3749: IF (funcmode <> wf_engine.eng_run) THEN
3750: resultout := wf_engine.eng_null;
3751: RETURN;
3752: END IF;
3753:

Line 3750: resultout := wf_engine.eng_null;

3746:
3747: BEGIN
3748:
3749: IF (funcmode <> wf_engine.eng_run) THEN
3750: resultout := wf_engine.eng_null;
3751: RETURN;
3752: END IF;
3753:
3754: --Set the global attributes in the po wrapper function

Line 3928: wf_engine.AbortProcess(l_child_wf_cur.item_type ,l_child_wf_cur.item_key);

3924: ||' l_child_wf_cur.item_key:'||l_child_wf_cur.item_key);
3925: END IF;
3926:
3927: l_progress := '060';
3928: wf_engine.AbortProcess(l_child_wf_cur.item_type ,l_child_wf_cur.item_key);
3929:
3930: END IF;
3931:
3932: END LOOP; --l_child_wf

Line 3966: wf_engine.AbortProcess(l_child_wf_cur.item_type ,l_child_wf_cur.item_key);

3962: IF (g_po_wf_debug = 'Y') THEN
3963: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head||':'||l_progress||' child item_key:'||l_child_wf_cur.item_key);
3964: END IF;
3965:
3966: wf_engine.AbortProcess(l_child_wf_cur.item_type ,l_child_wf_cur.item_key);
3967:
3968: -- update the action history table
3969: IF l_approver_category = 'REVIEWER' THEN
3970: fnd_message.set_name('PO', 'PO_ALREADY_REVIEW_REJECTED');

Line 3999: wf_engine.CompleteActivity(

3995: END IF; --IF l_approver_response = 'APPROVED'
3996:
3997: l_progress := '110';
3998:
3999: wf_engine.CompleteActivity(
4000: itemtype => l_parent_item_type,
4001: itemkey => l_parent_item_key,
4002: activity => 'BLOCK',
4003: result => NULL);

Line 4005: resultout := wf_engine.eng_completed||':'||'ACTIVITY_PERFORMED';

4001: itemkey => l_parent_item_key,
4002: activity => 'BLOCK',
4003: result => NULL);
4004:
4005: resultout := wf_engine.eng_completed||':'||'ACTIVITY_PERFORMED';
4006: RETURN;
4007:
4008: EXCEPTION
4009: WHEN OTHERS THEN

Line 4055: IF (funcmode <> wf_engine.eng_run) THEN

4051: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
4052:
4053: BEGIN
4054:
4055: IF (funcmode <> wf_engine.eng_run) THEN
4056: resultout := wf_engine.eng_null;
4057: RETURN;
4058: END IF;
4059:

Line 4056: resultout := wf_engine.eng_null;

4052:
4053: BEGIN
4054:
4055: IF (funcmode <> wf_engine.eng_run) THEN
4056: resultout := wf_engine.eng_null;
4057: RETURN;
4058: END IF;
4059:
4060: --Set the global attributes in the po wrapper function

Line 4081: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

4077: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
4078: itemkey => l_parent_item_key,
4079: aname => 'AME_SUB_APPROVAL_RESPONSE',
4080: avalue => 'FAILED_VERIFICATION');
4081: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
4082:
4083: END update_resp_verf_failed;
4084:
4085: --------------------------------------------------------------------------------

Line 4120: IF (funcmode <> wf_engine.eng_run) THEN

4116: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
4117:
4118: BEGIN
4119:
4120: IF (funcmode <> wf_engine.eng_run) THEN
4121: resultout := wf_engine.eng_null;
4122: RETURN;
4123: END IF;
4124:

Line 4121: resultout := wf_engine.eng_null;

4117:
4118: BEGIN
4119:
4120: IF (funcmode <> wf_engine.eng_run) THEN
4121: resultout := wf_engine.eng_null;
4122: RETURN;
4123: END IF;
4124:
4125: --Set the global attributes in the po wrapper function

Line 4146: resultout := wf_engine.eng_completed||':'||'ACTIVITY_PERFORMED';

4142: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
4143: itemkey => l_parent_item_key,
4144: aname => 'AME_SUB_APPROVAL_RESPONSE',
4145: avalue => 'FALIED_VERIFICATION_REJECT');
4146: resultout := wf_engine.eng_completed||':'||'ACTIVITY_PERFORMED';
4147:
4148: END update_resp_verf_failed_reject;
4149:
4150: --------------------------------------------------------------------------------

Line 4185: IF (funcmode <> wf_engine.eng_run) THEN

4181: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
4182:
4183: BEGIN
4184:
4185: IF (funcmode <> wf_engine.eng_run) THEN
4186: resultout := wf_engine.eng_null;
4187: RETURN;
4188: END IF;
4189:

Line 4186: resultout := wf_engine.eng_null;

4182:
4183: BEGIN
4184:
4185: IF (funcmode <> wf_engine.eng_run) THEN
4186: resultout := wf_engine.eng_null;
4187: RETURN;
4188: END IF;
4189:
4190: --Set the global attributes in the po wrapper function

Line 4201: resultout := wf_engine.eng_completed || ':' || l_ame_sub_approval_response;

4197: END IF;
4198:
4199: l_ame_sub_approval_response := po_wf_util_pkg.GetItemAttrText( aname => 'AME_SUB_APPROVAL_RESPONSE');
4200:
4201: resultout := wf_engine.eng_completed || ':' || l_ame_sub_approval_response;
4202:
4203: END get_ame_sub_approval_response;
4204:
4205: --------------------------------------------------------------------------------

Line 4250: IF (funcmode <> wf_engine.eng_run) THEN

4246: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
4247:
4248: BEGIN
4249:
4250: IF (funcmode <> wf_engine.eng_run) THEN
4251: resultout := wf_engine.eng_null;
4252: RETURN;
4253: END IF;
4254:

Line 4251: resultout := wf_engine.eng_null;

4247:
4248: BEGIN
4249:
4250: IF (funcmode <> wf_engine.eng_run) THEN
4251: resultout := wf_engine.eng_null;
4252: RETURN;
4253: END IF;
4254:
4255: --Set the global attributes in the po wrapper function

Line 4346: IF (funcmode <> wf_engine.eng_run) THEN

4342: l_api_name VARCHAR2(500) := 'ame_is_forward_to_valid';
4343: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
4344: BEGIN
4345:
4346: IF (funcmode <> wf_engine.eng_run) THEN
4347: resultout := wf_engine.eng_null;
4348: RETURN;
4349: END IF;
4350:

Line 4347: resultout := wf_engine.eng_null;

4343: l_log_head VARCHAR2(500) := g_module_prefix||l_api_name;
4344: BEGIN
4345:
4346: IF (funcmode <> wf_engine.eng_run) THEN
4347: resultout := wf_engine.eng_null;
4348: RETURN;
4349: END IF;
4350:
4351: --Set the global attributes in the po wrapper function

Line 4384: resultout := wf_engine.eng_completed||':'||'Y';

4380: fnd_message.set_name ('PO','PO_WF_NOTIF_REQUIRES_APPROVAL');
4381: l_error_msg := fnd_message.get;
4382: po_wf_util_pkg.SetItemAttrText ( aname => 'REQUIRES_APPROVAL_MSG' , avalue => l_error_msg);
4383: po_wf_util_pkg.SetItemAttrText ( aname => 'WRONG_FORWARD_TO_MSG' , avalue => '');
4384: resultout := wf_engine.eng_completed||':'||'Y';
4385: EXCEPTION
4386: WHEN NO_DATA_FOUND THEN
4387: --+ Set the error message in WRONG_FORWARD_TO_MSG so that it will be shown to the user
4388: --+ Set the Subject of the Approval notification to "Invalid forward-to"

Line 4395: resultout := wf_engine.eng_completed || ':' || 'N';

4391: fnd_message.set_name ('PO','PO_WF_NOTIF_INVALID_FORWARD');
4392: l_error_msg := fnd_message.get;
4393: po_wf_util_pkg.SetItemAttrText ( aname => 'REQUIRES_APPROVAL_MSG' , avalue => '');
4394: po_wf_util_pkg.SetItemAttrText ( aname => 'WRONG_FORWARD_TO_MSG' , avalue => l_error_msg);
4395: resultout := wf_engine.eng_completed || ':' || 'N';
4396: END;
4397: END ame_is_forward_to_valid;
4398:
4399: --------------------------------------------------------------------------------

Line 4463: WF_Engine.AbortProcess(itemtype => wf_rec.item_type,

4459: p_message => 'Aborting workflow : ' || wf_rec.item_type ||
4460: ' - ' || wf_rec.item_key);
4461: END IF;
4462:
4463: WF_Engine.AbortProcess(itemtype => wf_rec.item_type,
4464: itemkey =>wf_rec.item_key,
4465: verify_lock => TRUE );
4466:
4467: end if;

Line 5186: IF (funcmode <> wf_engine.eng_run) THEN

5182: IS
5183: l_is_fyi_approver VARCHAR2(1);
5184: BEGIN
5185:
5186: IF (funcmode <> wf_engine.eng_run) THEN
5187: resultout := wf_engine.eng_null;
5188: RETURN;
5189: END IF;
5190:

Line 5187: resultout := wf_engine.eng_null;

5183: l_is_fyi_approver VARCHAR2(1);
5184: BEGIN
5185:
5186: IF (funcmode <> wf_engine.eng_run) THEN
5187: resultout := wf_engine.eng_null;
5188: RETURN;
5189: END IF;
5190:
5191: --Set the global attributes in the po wrapper function

Line 5200: resultout := wf_engine.eng_completed || ':' || 'Y';

5196: --Fetch 'IS_FYI_APPROVER' value which is set in launch_parralel_approval
5197: l_is_fyi_approver := po_wf_util_pkg.GetItemAttrText (aname => 'IS_FYI_APPROVER');
5198:
5199: IF l_is_fyi_approver = 'Y' THEN
5200: resultout := wf_engine.eng_completed || ':' || 'Y';
5201: ELSE
5202: resultout := wf_engine.eng_completed || ':' || 'N';
5203: END IF;
5204:

Line 5202: resultout := wf_engine.eng_completed || ':' || 'N';

5198:
5199: IF l_is_fyi_approver = 'Y' THEN
5200: resultout := wf_engine.eng_completed || ':' || 'Y';
5201: ELSE
5202: resultout := wf_engine.eng_completed || ':' || 'N';
5203: END IF;
5204:
5205: END is_fyi_approver;
5206:

Line 5510: IF (funcmode <> wf_engine.eng_run) THEN

5506: BEGIN
5507: -- Logic :
5508: -- + Set worflow attribute for 'ESIGNER_RESPONSE' as ACCEPTED
5509:
5510: IF (funcmode <> wf_engine.eng_run) THEN
5511: resultout := wf_engine.eng_null;
5512: RETURN;
5513: END IF;
5514:

Line 5511: resultout := wf_engine.eng_null;

5507: -- Logic :
5508: -- + Set worflow attribute for 'ESIGNER_RESPONSE' as ACCEPTED
5509:
5510: IF (funcmode <> wf_engine.eng_run) THEN
5511: resultout := wf_engine.eng_null;
5512: RETURN;
5513: END IF;
5514:
5515: --Set the global attributes in the po wrapper function

Line 5520: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

5516: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
5517: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
5518:
5519: po_wf_util_pkg.SetItemAttrText (aname => 'ESIGNER_RESPONSE', avalue => 'ACCEPTED');
5520: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
5521:
5522: END set_esigner_response_accepted;
5523:
5524: --------------------------------------------------------------------------------

Line 5556: IF (funcmode <> wf_engine.eng_run) THEN

5552: BEGIN
5553: -- Logic :
5554: -- + Set worflow attribute for 'ESIGNER_RESPONSE' as REJECTED
5555:
5556: IF (funcmode <> wf_engine.eng_run) THEN
5557: resultout := wf_engine.eng_null;
5558: RETURN;
5559: END IF;
5560:

Line 5557: resultout := wf_engine.eng_null;

5553: -- Logic :
5554: -- + Set worflow attribute for 'ESIGNER_RESPONSE' as REJECTED
5555:
5556: IF (funcmode <> wf_engine.eng_run) THEN
5557: resultout := wf_engine.eng_null;
5558: RETURN;
5559: END IF;
5560:
5561: --Set the global attributes in the po wrapper function

Line 5566: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';

5562: PO_WF_UTIL_PKG.G_ITEM_TYPE := itemtype;
5563: PO_WF_UTIL_PKG.G_ITEM_KEY := itemkey;
5564:
5565: po_wf_util_pkg.SetItemAttrText (aname => 'ESIGNER_RESPONSE', avalue => 'REJECTED');
5566: resultout := wf_engine.eng_completed || ':' || 'ACTIVITY_PERFORMED';
5567:
5568: END set_esigner_response_rejected;
5569:
5570: -------------------------------------------------------------------------------

Line 5836: IF (funcmode <> wf_engine.eng_run) THEN

5832: BEGIN
5833: -- Logic :
5834: -- + Check worflow attribute for 'E_SIGNER_EXISTS' and return
5835:
5836: IF (funcmode <> wf_engine.eng_run) THEN
5837: resultout := wf_engine.eng_null;
5838: RETURN;
5839: END IF;
5840:

Line 5837: resultout := wf_engine.eng_null;

5833: -- Logic :
5834: -- + Check worflow attribute for 'E_SIGNER_EXISTS' and return
5835:
5836: IF (funcmode <> wf_engine.eng_run) THEN
5837: resultout := wf_engine.eng_null;
5838: RETURN;
5839: END IF;
5840:
5841: --Set the global attributes in the po wrapper function

Line 5850: resultout := wf_engine.eng_completed || ':' || l_esigner_exists;

5846: l_esigner_exists := po_wf_util_pkg.GetItemAttrText (aname => 'E_SIGNER_EXISTS');
5847: IF (g_po_wf_debug = 'Y') THEN
5848: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, 'PO_AME_WF_PVT.check_for_esigner_exists: ' || l_esigner_exists);
5849: END IF;
5850: resultout := wf_engine.eng_completed || ':' || l_esigner_exists;
5851:
5852: END check_for_esigner_exists;
5853:
5854: --------------------------------------------------------------------------------

Line 6225: resultout := wf_engine.eng_completed;

6221: IF (g_po_wf_debug = 'Y') THEN
6222: PO_WF_DEBUG_PKG.insert_debug(itemtype,itemkey, l_log_head || ' 002 result : ' || l_result);
6223: END IF;
6224:
6225: resultout := wf_engine.eng_completed;
6226: END trigger_approval_workflow;
6227:
6228: -------------------------------------------------------------------------------
6229: --Start of Comments

Line 6303: resultout := wf_engine.eng_completed;

6299: END IF;
6300:
6301: END IF;
6302:
6303: resultout := wf_engine.eng_completed;
6304:
6305: END suppress_existing_esigners;
6306:
6307: -------------------------------------------------------------------------------

Line 6459: resultout := wf_engine.eng_completed;

6455: p_item_type => itemtype,
6456: p_item_key => itemkey,
6457: x_return_message => l_return_message);
6458:
6459: resultout := wf_engine.eng_completed;
6460:
6461: END complete_ame_transaction;
6462:
6463: END PO_AME_WF_PVT;