DBA Data[Home] [Help]

APPS.PO_WF_PO_CHARGE_ACC dependencies on WF_ENGINE

Line 47: if (funcmode <> wf_engine.eng_run) then

43:
44:
45: -- Do nothing in cancel or timeout mode
46: --
47: if (funcmode <> wf_engine.eng_run) then
48:
49: result := wf_engine.eng_null;
50: return;
51:

Line 49: result := wf_engine.eng_null;

45: -- Do nothing in cancel or timeout mode
46: --
47: if (funcmode <> wf_engine.eng_run) then
48:
49: result := wf_engine.eng_null;
50: return;
51:
52: end if;
53:

Line 137: if (funcmode <> wf_engine.eng_run) then

133:
134:
135: -- Do nothing in cancel or timeout mode
136: --
137: if (funcmode <> wf_engine.eng_run) then
138:
139: result := wf_engine.eng_null;
140: return;
141:

Line 139: result := wf_engine.eng_null;

135: -- Do nothing in cancel or timeout mode
136: --
137: if (funcmode <> wf_engine.eng_run) then
138:
139: result := wf_engine.eng_null;
140: return;
141:
142: end if;
143:

Line 496: if (funcmode <> wf_engine.eng_run) then

492:
493:
494: -- Do nothing in cancel or timeout mode
495: --
496: if (funcmode <> wf_engine.eng_run) then
497:
498: result := wf_engine.eng_null;
499: return;
500:

Line 498: result := wf_engine.eng_null;

494: -- Do nothing in cancel or timeout mode
495: --
496: if (funcmode <> wf_engine.eng_run) then
497:
498: result := wf_engine.eng_null;
499: return;
500:
501: end if;
502:

Line 638: if (funcmode <> wf_engine.eng_run) then

634:
635:
636: -- Do nothing in cancel or timeout mode
637: --
638: if (funcmode <> wf_engine.eng_run) then
639:
640: result := wf_engine.eng_null;
641: return;
642:

Line 640: result := wf_engine.eng_null;

636: -- Do nothing in cancel or timeout mode
637: --
638: if (funcmode <> wf_engine.eng_run) then
639:
640: result := wf_engine.eng_null;
641: return;
642:
643: end if;
644:

Line 706: if (funcmode <> wf_engine.eng_run) then

702: END IF;
703:
704: -- Do nothing in cancel or timeout mode
705: --
706: if (funcmode <> wf_engine.eng_run) then
707:
708: result := wf_engine.eng_null;
709: return;
710:

Line 708: result := wf_engine.eng_null;

704: -- Do nothing in cancel or timeout mode
705: --
706: if (funcmode <> wf_engine.eng_run) then
707:
708: result := wf_engine.eng_null;
709: return;
710:
711: end if;
712:

Line 966: if (funcmode <> wf_engine.eng_run) then

962:
963:
964: -- Do nothing in cancel or timeout mode
965: --
966: if (funcmode <> wf_engine.eng_run) then
967:
968: result := wf_engine.eng_null;
969: return;
970:

Line 968: result := wf_engine.eng_null;

964: -- Do nothing in cancel or timeout mode
965: --
966: if (funcmode <> wf_engine.eng_run) then
967:
968: result := wf_engine.eng_null;
969: return;
970:
971: end if;
972:

Line 1168: if (funcmode <> wf_engine.eng_run) then

1164:
1165:
1166: -- Do nothing in cancel or timeout mode
1167: --
1168: if (funcmode <> wf_engine.eng_run) then
1169:
1170: result := wf_engine.eng_null;
1171: return;
1172:

Line 1170: result := wf_engine.eng_null;

1166: -- Do nothing in cancel or timeout mode
1167: --
1168: if (funcmode <> wf_engine.eng_run) then
1169:
1170: result := wf_engine.eng_null;
1171: return;
1172:
1173: end if;
1174:

Line 1399: IF (funcmode <> WF_ENGINE.eng_run) THEN

1395: BEGIN
1396: l_progress := '010';
1397:
1398: -- Do nothing in cancel or timeout mode
1399: IF (funcmode <> WF_ENGINE.eng_run) THEN
1400: result := WF_ENGINE.eng_null;
1401: RETURN;
1402: END IF;
1403:

Line 1400: result := WF_ENGINE.eng_null;

1396: l_progress := '010';
1397:
1398: -- Do nothing in cancel or timeout mode
1399: IF (funcmode <> WF_ENGINE.eng_run) THEN
1400: result := WF_ENGINE.eng_null;
1401: RETURN;
1402: END IF;
1403:
1404: l_progress := '020';

Line 1416: result := WF_ENGINE.eng_completed || ':N';

1412:
1413: IF (l_account_gen_flow_type IS NULL OR
1414: l_account_gen_flow_type = PO_WF_BUILD_ACCOUNT_INIT.g_po_accounts)
1415: THEN
1416: result := WF_ENGINE.eng_completed || ':N';
1417: ELSE
1418: result := WF_ENGINE.eng_completed || ':Y';
1419: END IF;
1420:

Line 1418: result := WF_ENGINE.eng_completed || ':Y';

1414: l_account_gen_flow_type = PO_WF_BUILD_ACCOUNT_INIT.g_po_accounts)
1415: THEN
1416: result := WF_ENGINE.eng_completed || ':N';
1417: ELSE
1418: result := WF_ENGINE.eng_completed || ':Y';
1419: END IF;
1420:
1421: IF (g_po_wf_debug = 'Y') THEN
1422: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

Line 1464: IF (funcmode <> WF_ENGINE.eng_run) THEN

1460: l_progress WF_ITEM_ACTIVITY_STATUSES.error_stack%TYPE; -- VARCHAR2(4000)
1461: l_is_SPS_distribution VARCHAR2(1);
1462: BEGIN
1463: -- Do nothing in cancel or timeout mode
1464: IF (funcmode <> WF_ENGINE.eng_run) THEN
1465: result := WF_ENGINE.eng_null;
1466: RETURN;
1467: END IF;
1468:

Line 1465: result := WF_ENGINE.eng_null;

1461: l_is_SPS_distribution VARCHAR2(1);
1462: BEGIN
1463: -- Do nothing in cancel or timeout mode
1464: IF (funcmode <> WF_ENGINE.eng_run) THEN
1465: result := WF_ENGINE.eng_null;
1466: RETURN;
1467: END IF;
1468:
1469: l_progress := '010';

Line 1477: result := WF_ENGINE.eng_completed || ':N';

1473: aname => 'IS_SPS_DISTRIBUTION');
1474:
1475: l_progress := '020';
1476: IF (l_is_SPS_distribution IS NULL) THEN
1477: result := WF_ENGINE.eng_completed || ':N';
1478: ELSE
1479: result := WF_ENGINE.eng_completed || ':' || l_is_SPS_distribution;
1480: END IF;
1481:

Line 1479: result := WF_ENGINE.eng_completed || ':' || l_is_SPS_distribution;

1475: l_progress := '020';
1476: IF (l_is_SPS_distribution IS NULL) THEN
1477: result := WF_ENGINE.eng_completed || ':N';
1478: ELSE
1479: result := WF_ENGINE.eng_completed || ':' || l_is_SPS_distribution;
1480: END IF;
1481:
1482: IF (g_po_wf_debug = 'Y') THEN
1483: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

Line 1827: IF (funcmode <> WF_ENGINE.eng_run) THEN

1823: BEGIN
1824: l_progress := '010';
1825:
1826: -- Do nothing in cancel or timeout mode
1827: IF (funcmode <> WF_ENGINE.eng_run) THEN
1828: result := WF_ENGINE.eng_null;
1829: RETURN;
1830: END IF;
1831:

Line 1828: result := WF_ENGINE.eng_null;

1824: l_progress := '010';
1825:
1826: -- Do nothing in cancel or timeout mode
1827: IF (funcmode <> WF_ENGINE.eng_run) THEN
1828: result := WF_ENGINE.eng_null;
1829: RETURN;
1830: END IF;
1831:
1832: l_progress := '020';

Line 1909: result := WF_ENGINE.eng_completed || ':FAILURE';

1905: END IF;
1906:
1907: l_progress := '130';
1908: IF (l_SPS_charge_account_id IS NULL) THEN
1909: result := WF_ENGINE.eng_completed || ':FAILURE';
1910: RETURN;
1911: END IF;
1912: END IF; -- IF (l_item_id IS NULL) OR
1913: -- (is_shopfloor_enabled_item(l_item_id, l_logical_inv_org_id)) --)

Line 1922: result := WF_ENGINE.eng_completed || ':SUCCESS';

1918: aname => 'TEMP_ACCOUNT_ID',
1919: avalue => l_SPS_charge_account_id);
1920:
1921: l_progress := '150';
1922: result := WF_ENGINE.eng_completed || ':SUCCESS';
1923:
1924: l_progress := '160';
1925:
1926: IF (g_po_wf_debug = 'Y') THEN

Line 1981: IF (funcmode <> WF_ENGINE.eng_run) THEN

1977: BEGIN
1978: l_progress := '010';
1979:
1980: -- Do nothing in cancel or timeout mode
1981: IF (funcmode <> WF_ENGINE.eng_run) THEN
1982: result := WF_ENGINE.eng_null;
1983: RETURN;
1984: END IF;
1985:

Line 1982: result := WF_ENGINE.eng_null;

1978: l_progress := '010';
1979:
1980: -- Do nothing in cancel or timeout mode
1981: IF (funcmode <> WF_ENGINE.eng_run) THEN
1982: result := WF_ENGINE.eng_null;
1983: RETURN;
1984: END IF;
1985:
1986: l_progress := '020';

Line 1996: result := WF_ENGINE.eng_completed || ':Y';

1992: l_progress := '030';
1993: IF l_dest_charge_account_id IS NULL OR
1994: l_dest_charge_account_id = 0 OR
1995: l_dest_charge_account_id = -1 THEN
1996: result := WF_ENGINE.eng_completed || ':Y';
1997: ELSE
1998: IF (g_po_wf_debug = 'Y') THEN
1999: l_temp_acc_id := PO_WF_UTIL_PKG.GetItemAttrNumber(
2000: itemtype => itemtype,

Line 2019: result := WF_ENGINE.eng_completed || ':N';

2015: itemkey => itemkey,
2016: aname => 'TEMP_ACCOUNT_ID',
2017: avalue => l_dest_charge_account_id);
2018: l_progress := '050';
2019: result := WF_ENGINE.eng_completed || ':N';
2020: END IF;
2021:
2022: IF (g_po_wf_debug = 'Y') THEN
2023: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

Line 2073: IF (funcmode <> WF_ENGINE.eng_run) THEN

2069: BEGIN
2070: l_progress := '010';
2071:
2072: -- Do nothing in cancel or timeout mode
2073: IF (funcmode <> WF_ENGINE.eng_run) THEN
2074: result := WF_ENGINE.eng_null;
2075: RETURN;
2076: END IF;
2077:

Line 2074: result := WF_ENGINE.eng_null;

2070: l_progress := '010';
2071:
2072: -- Do nothing in cancel or timeout mode
2073: IF (funcmode <> WF_ENGINE.eng_run) THEN
2074: result := WF_ENGINE.eng_null;
2075: RETURN;
2076: END IF;
2077:
2078: --

Line 2088: result := WF_ENGINE.eng_completed || ':N';

2084: itemkey => itemkey,
2085: aname => 'IS_SPS_DISTRIBUTION' );
2086:
2087: IF nvl( l_is_sps_distribution, 'N' ) = 'N' THEN
2088: result := WF_ENGINE.eng_completed || ':N';
2089: RETURN;
2090: END IF;
2091: --
2092:

Line 2109: result := WF_ENGINE.eng_completed || ':N';

2105:
2106: l_progress := '040';
2107: IF (l_ship_to_ou_coa_id IS NULL) OR
2108: (l_ship_to_ou_coa_id <> l_pou_coa_id) THEN
2109: result := WF_ENGINE.eng_completed || ':N';
2110: ELSE
2111: result := WF_ENGINE.eng_completed || ':Y';
2112: END IF;
2113:

Line 2111: result := WF_ENGINE.eng_completed || ':Y';

2107: IF (l_ship_to_ou_coa_id IS NULL) OR
2108: (l_ship_to_ou_coa_id <> l_pou_coa_id) THEN
2109: result := WF_ENGINE.eng_completed || ':N';
2110: ELSE
2111: result := WF_ENGINE.eng_completed || ':Y';
2112: END IF;
2113:
2114: IF (g_po_wf_debug = 'Y') THEN
2115: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,

Line 2160: wf_engine.SetItemAttrNumber( itemtype => itemtype,

2156: -- Commented out the code below as it was leading to Stale Data Error in BWC.
2157: -- LAST_UPDATE_LOGIN was going as -1 into UDA tables (po_lines_all_ext_b)
2158: /*
2159: l_progress := '010';
2160: wf_engine.SetItemAttrNumber( itemtype => itemtype,
2161: itemkey => itemkey,
2162: aname =>'RESPONSIBILITY_ID',
2163: avalue => fnd_global.resp_id);
2164: l_progress := '020';

Line 2175: result := WF_ENGINE.eng_completed || ':Y';

2171: resp_id => NULL,
2172: resp_appl_id => fnd_global.resp_appl_id);
2173: l_progress := '030';
2174: */
2175: result := WF_ENGINE.eng_completed || ':Y';
2176: EXCEPTION
2177: WHEN OTHERS THEN
2178: WF_CORE.context('PO_WF_PO_CHARGE_ACC','SET_NULL_RESP_ID',l_progress);
2179: raise;

Line 2211: l_resp_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,

2207: -- LAST_UPDATE_LOGIN was going as -1 into UDA tables (po_lines_all_ext_b)
2208: /*
2209: l_resp_id :=NULL;
2210: l_progress := '010';
2211: l_resp_id := wf_engine.GetItemAttrNumber( itemtype => itemtype,
2212: itemkey => itemkey,
2213: aname => 'RESPONSIBILITY_ID');
2214: l_progress := '020';
2215: IF (g_po_wf_debug = 'Y') THEN

Line 2225: result := WF_ENGINE.eng_completed || ':Y';

2221: resp_id => l_resp_id,
2222: resp_appl_id => fnd_global.resp_appl_id);
2223: l_progress := '030';
2224: */
2225: result := WF_ENGINE.eng_completed || ':Y';
2226: EXCEPTION
2227: WHEN OTHERS THEN
2228: WF_CORE.context('PO_WF_PO_CHARGE_ACC','RESET_RESP_ID',l_progress);
2229: RAISE;

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

2283: BEGIN
2284:
2285: l_progress := '010';
2286: -- Do nothing in cancel or timeout mode
2287: IF (funcmode <> wf_engine.eng_run) THEN
2288: result := wf_engine.eng_null;
2289: RETURN;
2290: END IF;
2291:

Line 2288: result := wf_engine.eng_null;

2284:
2285: l_progress := '010';
2286: -- Do nothing in cancel or timeout mode
2287: IF (funcmode <> wf_engine.eng_run) THEN
2288: result := wf_engine.eng_null;
2289: RETURN;
2290: END IF;
2291:
2292: l_progress := '020';

Line 2306: result := wf_engine.eng_null;

2302: END IF;
2303:
2304: -- Do nothing if FND_FLEX_STATUS is INVALID
2305: IF (l_flex_status = 'INVALID') THEN
2306: result := wf_engine.eng_null;
2307: RETURN;
2308: END IF;
2309:
2310: --Begin Bug 9645501

Line 2362: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_STATUS','INVALID');

2358: PO_WF_DEBUG_PKG.insert_debug(itemtype, itemkey,
2359: 'PO_WF_PO_CHARGE_ACC.validate_combination: l_is_combination_valid is false');
2360: END IF;
2361:
2362: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_STATUS','INVALID');
2363: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_MESSAGE',
2364: fnd_flex_keyval.encoded_error_message);
2365: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_CCID','0');
2366: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_DATA','');

Line 2363: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_MESSAGE',

2359: 'PO_WF_PO_CHARGE_ACC.validate_combination: l_is_combination_valid is false');
2360: END IF;
2361:
2362: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_STATUS','INVALID');
2363: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_MESSAGE',
2364: fnd_flex_keyval.encoded_error_message);
2365: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_CCID','0');
2366: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_DATA','');
2367: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_DESCRIPTIONS','');

Line 2365: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_CCID','0');

2361:
2362: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_STATUS','INVALID');
2363: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_MESSAGE',
2364: fnd_flex_keyval.encoded_error_message);
2365: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_CCID','0');
2366: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_DATA','');
2367: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_DESCRIPTIONS','');
2368: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_NEW','N');
2369: END IF;

Line 2366: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_DATA','');

2362: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_STATUS','INVALID');
2363: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_MESSAGE',
2364: fnd_flex_keyval.encoded_error_message);
2365: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_CCID','0');
2366: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_DATA','');
2367: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_DESCRIPTIONS','');
2368: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_NEW','N');
2369: END IF;
2370:

Line 2367: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_DESCRIPTIONS','');

2363: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_MESSAGE',
2364: fnd_flex_keyval.encoded_error_message);
2365: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_CCID','0');
2366: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_DATA','');
2367: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_DESCRIPTIONS','');
2368: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_NEW','N');
2369: END IF;
2370:
2371: result := wf_engine.eng_completed || ':' || wf_engine.eng_null;

Line 2368: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_NEW','N');

2364: fnd_flex_keyval.encoded_error_message);
2365: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_CCID','0');
2366: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_DATA','');
2367: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_DESCRIPTIONS','');
2368: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_NEW','N');
2369: END IF;
2370:
2371: result := wf_engine.eng_completed || ':' || wf_engine.eng_null;
2372: END validate_combination;

Line 2371: result := wf_engine.eng_completed || ':' || wf_engine.eng_null;

2367: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_DESCRIPTIONS','');
2368: wf_engine.setitemattrtext(itemtype,itemkey,'FND_FLEX_NEW','N');
2369: END IF;
2370:
2371: result := wf_engine.eng_completed || ':' || wf_engine.eng_null;
2372: END validate_combination;
2373:
2374: END PO_WF_PO_CHARGE_ACC;