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.7 2005/12/09 05:02:20 kmuruges 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 1806: WF_CORE.Context('OE_ORDER_IMPORT_WF', 'RAISE_EVENT_SHOWSO_WF',

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2871: END OE_ORDER_IMPORT_WF;

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