DBA Data[Home] [Help]

APPS.OE_ORDER_IMPORT_WF dependencies on OE_ORDER_IMPORT_WF

Line 1: PACKAGE BODY OE_ORDER_IMPORT_WF AS

1: PACKAGE BODY OE_ORDER_IMPORT_WF AS
2: /* $Header: OEXWFOIB.pls 120.8 2011/09/16 11:52:47 slagiset ship $ */
3:
4: PROCEDURE OEOI_SELECTOR
5: ( p_itemtype in varchar2,

Line 117: WF_CORE.Context('OE_ORDER_IMPORT_WF', 'OEOI_SELECTOR',

113: -- p_funcmode }
114:
115: EXCEPTION
116: WHEN OTHERS THEN NULL;
117: WF_CORE.Context('OE_ORDER_IMPORT_WF', 'OEOI_SELECTOR',
118: p_itemtype, p_itemkey, p_actid, p_funcmode);
119: RAISE;
120:
121: END OEOI_SELECTOR;

Line 303: WF_CORE.Context('OE_ORDER_IMPORT_WF', 'OEOA_SELECTOR',

299: -- p_funcmode }
300:
301: EXCEPTION
302: WHEN OTHERS THEN NULL;
303: WF_CORE.Context('OE_ORDER_IMPORT_WF', 'OEOA_SELECTOR',
304: p_itemtype, p_itemkey, p_actid, p_funcmode);
305: RAISE;
306:
307: END OEOA_SELECTOR;

Line 431: WF_CORE.Context('OE_ORDER_IMPORT_WF', 'START_ORDER_IMPORT',

427: WHEN OTHERS THEN
428: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
429: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'start_order_import');
430: END IF;
431: WF_CORE.Context('OE_ORDER_IMPORT_WF', 'START_ORDER_IMPORT',
432: p_itemtype, p_itemkey, p_actid, p_funcmode);
433: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => p_actid,
434: p_itemtype => p_itemtype,
435: p_itemkey => p_itemkey);

Line 647: WF_CORE.Context('OE_ORDER_IMPORT_WF', 'IS_OI_COMPLETE',

643: avalue => p_x_result);
644: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
645: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'is_oi_complete');
646: END IF;
647: WF_CORE.Context('OE_ORDER_IMPORT_WF', 'IS_OI_COMPLETE',
648: p_itemtype, p_itemkey, p_actid, p_funcmode);
649: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => p_actid,
650: p_itemtype => p_itemtype,
651: p_itemkey => p_itemkey);

Line 1049: (itemtype => OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT,

1045:
1046: If p_itemtype = G_WFI_ORDER_ACK Then
1047: If (l_start_from_flow = G_WFI_ORDER_IMPORT) Then
1048: l_parameter2 := wf_engine.GetItemAttrNumber
1049: (itemtype => OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT,
1050: itemkey => p_itemkey,
1051: aname => 'REQ_ID');
1052: Elsif (l_start_from_flow = G_WFI_IMPORT_PGM) Then
1053: l_parameter2 := wf_engine.GetItemAttrNumber

Line 1054: (itemtype => OE_ORDER_IMPORT_WF.G_WFI_ORDER_ACK,

1050: itemkey => p_itemkey,
1051: aname => 'REQ_ID');
1052: Elsif (l_start_from_flow = G_WFI_IMPORT_PGM) Then
1053: l_parameter2 := wf_engine.GetItemAttrNumber
1054: (itemtype => OE_ORDER_IMPORT_WF.G_WFI_ORDER_ACK,
1055: itemkey => p_itemkey,
1056: aname => 'REQ_ID');
1057: End If;
1058:

Line 1106: WF_CORE.Context('OE_ORDER_IMPORT_WF', 'SET_DELIVERY_DATA',

1102: p_x_result := FND_API.G_RET_STS_UNEXP_ERROR ;
1103: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1104: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'set_delivery_data');
1105: END IF;
1106: WF_CORE.Context('OE_ORDER_IMPORT_WF', 'SET_DELIVERY_DATA',
1107: p_itemtype, p_itemkey, p_actid, p_funcmode);
1108: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => p_actid,
1109: p_itemtype => p_itemtype,
1110: p_itemkey => p_itemkey);

Line 1351: WF_CORE.Context('OE_ORDER_IMPORT_WF', 'IS_PARTNER_SETUP',

1347: END IF;
1348: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1349: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'IS_Partner_Setup');
1350: END IF;
1351: WF_CORE.Context('OE_ORDER_IMPORT_WF', 'IS_PARTNER_SETUP',
1352: p_itemtype, p_itemkey, p_actid, p_funcmode);
1353: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => p_actid,
1354: p_itemtype => p_itemtype,
1355: p_itemkey => p_itemkey);

Line 1496: If l_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT then

1492: p_change_sequence => l_change_sequence,
1493: x_return_status => l_return_status);
1494: Else
1495:
1496: If l_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT then
1497: l_request_id := wf_engine.GetItemAttrNumber
1498: (itemtype => OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT,
1499: itemkey => p_itemkey,
1500: aname => 'REQ_ID');

Line 1498: (itemtype => OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT,

1494: Else
1495:
1496: If l_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT then
1497: l_request_id := wf_engine.GetItemAttrNumber
1498: (itemtype => OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT,
1499: itemkey => p_itemkey,
1500: aname => 'REQ_ID');
1501: Elsif l_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM then
1502: l_request_id := wf_engine.GetItemAttrNumber

Line 1501: Elsif l_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM then

1497: l_request_id := wf_engine.GetItemAttrNumber
1498: (itemtype => OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT,
1499: itemkey => p_itemkey,
1500: aname => 'REQ_ID');
1501: Elsif l_start_from_flow = OE_ORDER_IMPORT_WF.G_WFI_IMPORT_PGM then
1502: l_request_id := wf_engine.GetItemAttrNumber
1503: (itemtype => p_itemtype,
1504: itemkey => p_itemkey,
1505: aname => 'REQ_ID');

Line 1592: WF_CORE.Context('OE_ORDER_IMPORT_WF', 'PROCESS_XML_ACKNOWLEDGMENT_WF',

1588: END IF;
1589: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1590: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'process_xml_acknowledgment_wf');
1591: END IF;
1592: WF_CORE.Context('OE_ORDER_IMPORT_WF', 'PROCESS_XML_ACKNOWLEDGMENT_WF',
1593: p_itemtype, p_itemkey, p_actid, p_funcmode);
1594: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => p_actid,
1595: p_itemtype => p_itemtype,
1596: p_itemkey => p_itemkey);

Line 1807: WF_CORE.Context('OE_ORDER_IMPORT_WF', 'RAISE_EVENT_SHOWSO_WF',

1803: p_x_result := 'COMPLETE:ERROR';
1804: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1805: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Raise_Event_Showso_Wf');
1806: END IF;
1807: WF_CORE.Context('OE_ORDER_IMPORT_WF', 'RAISE_EVENT_SHOWSO_WF',
1808: p_itemtype, p_itemkey, p_actid, p_funcmode);
1809: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => p_actid,
1810: p_itemtype => p_itemtype,
1811: p_itemkey => p_itemkey);

Line 1846: if (p_itemtype = OE_ORDER_IMPORT_WF.G_WFI_SHOW_SO) then

1842: IF l_debug_level > 0 THEN
1843: oe_debug_pub.add( 'ENTERING SET_USER_KEY' ) ;
1844: END IF;
1845:
1846: if (p_itemtype = OE_ORDER_IMPORT_WF.G_WFI_SHOW_SO) then
1847: l_header_id := wf_engine.GetItemAttrNumber(p_itemtype,
1848: p_itemkey,
1849: 'HEADER_ID'
1850: );

Line 1892: elsif (p_itemtype = OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT) then

1888: End If;
1889: IF l_debug_level > 0 THEN
1890: oe_debug_pub.add( 'USER_KEY = '||L_USER_KEY ) ;
1891: END IF;
1892: elsif (p_itemtype = OE_ORDER_IMPORT_WF.G_WFI_ORDER_IMPORT) then
1893: l_orig_sys_document_ref := wf_engine.GetItemAttrText(p_itemtype,
1894: p_itemkey,
1895: 'PARAMETER2'
1896: );

Line 1988: WF_CORE.Context('OE_ORDER_IMPORT_WF', 'SET_USER_KEY',

1984: p_x_result := 'COMPLETE:ERROR';
1985: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1986: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'set_user_key');
1987: END IF;
1988: WF_CORE.Context('OE_ORDER_IMPORT_WF', 'SET_USER_KEY',
1989: p_itemtype, p_itemkey, p_actid, p_funcmode);
1990: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => p_actid,
1991: p_itemtype => p_itemtype,
1992: p_itemkey => p_itemkey);

Line 2083: WF_CORE.Context('OE_ORDER_IMPORT_WF', 'IS_CBOD_OUT_REQD',

2079: return;
2080: end if;
2081: Exception
2082: When Others Then
2083: WF_CORE.Context('OE_ORDER_IMPORT_WF', 'IS_CBOD_OUT_REQD',
2084: p_itemtype, p_itemkey, p_actid, p_funcmode);
2085: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => p_actid,
2086: p_itemtype => p_itemtype,
2087: p_itemkey => p_itemkey);

Line 2167: WF_CORE.Context('OE_ORDER_IMPORT_WF', 'SET_CBOD_EVENT_KEY',

2163: p_x_result := NULL;
2164: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2165: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'set_cbod_event_key');
2166: END IF;
2167: WF_CORE.Context('OE_ORDER_IMPORT_WF', 'SET_CBOD_EVENT_KEY',
2168: p_itemtype, p_itemkey, p_actid, p_funcmode);
2169: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => p_actid,
2170: p_itemtype => p_itemtype,
2171: p_itemkey => p_itemkey);

Line 2756: WF_CORE.Context('OE_ORDER_IMPORT_WF', 'RAISE_EVENT_XMLINT_WF',

2752: p_x_result := FND_API.G_RET_STS_UNEXP_ERROR ;
2753: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2754: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Raise_Event_Xmlint_Wf');
2755: END IF;
2756: WF_CORE.Context('OE_ORDER_IMPORT_WF', 'RAISE_EVENT_XMLINT_WF',
2757: p_itemtype, p_itemkey, p_actid, p_funcmode);
2758: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => p_actid,
2759: p_itemtype => p_itemtype,
2760: p_itemkey => p_itemkey);

Line 2789: oe_debug_pub.Add('ENTERING OE_ORDER_IMPORT_WF.IS_OAG_OR_ROSETTANET');

2785:
2786: Begin
2787:
2788: IF (l_debug_level > 0) THEN
2789: oe_debug_pub.Add('ENTERING OE_ORDER_IMPORT_WF.IS_OAG_OR_ROSETTANET');
2790: oe_debug_pub.Add('With the following parameters:');
2791: oe_debug_pub.Add('itemtype:' || p_itemtype);
2792: oe_debug_pub.Add('itemkey:' || p_itemkey);
2793: oe_debug_pub.Add('actid:' || p_actid);

Line 2798: cln_debug_pub.Add('ENTERING OE_ORDER_IMPORT_WF.IS_OAG_OR_ROSETTANET',1);

2794: oe_debug_pub.Add('funcmode:' || p_funcmode);
2795: END IF;
2796: -- Start of CLN debugs
2797: IF (l_debug_level_cln <= 1) THEN
2798: cln_debug_pub.Add('ENTERING OE_ORDER_IMPORT_WF.IS_OAG_OR_ROSETTANET',1);
2799: cln_debug_pub.Add('With the following parameters:', 1);
2800: cln_debug_pub.Add('itemtype:' || p_itemtype, 1);
2801: cln_debug_pub.Add('itemkey:' || p_itemkey, 1);
2802: cln_debug_pub.Add('actid:' || p_actid, 1);

Line 2851: WF_CORE.Context('OE_ORDER_IMPORT_WF', 'IS_OAG_OR_ROSETTANET',

2847: p_x_result := 'COMPLETE:ERROR';
2848: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2849: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Is_OAG_or_RosettaNet');
2850: END IF;
2851: WF_CORE.Context('OE_ORDER_IMPORT_WF', 'IS_OAG_OR_ROSETTANET',
2852: p_itemtype, p_itemkey, p_actid, p_funcmode);
2853: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => p_actid,
2854: p_itemtype => p_itemtype,
2855: p_itemkey => p_itemkey);

Line 2872: END OE_ORDER_IMPORT_WF;

2868:
2869: RAISE;
2870: End Is_OAG_or_RosettaNet;
2871:
2872: END OE_ORDER_IMPORT_WF;