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.OE_ORDER_IMPORT_WF dependencies on STANDARD

Line 386: OE_STANDARD_WF.Set_Msg_Context(p_actid);

382: -- { If the Profile option ONT_TRANSACTION_PROCESSING is not set or not
383: -- SYNCHRONOUS then no need to start the concurrent process as this will
384: -- be done by user, in BATCH/ASYNCHRONOUS
385:
386: OE_STANDARD_WF.Set_Msg_Context(p_actid);
387: If nvl(l_sync, 'SYNCHRONOUS') = 'ASYNCHRONOUS' Then
388: IF l_debug_level > 0 THEN
389: oe_debug_pub.add( 'NO NEED TO START THE CONC. PROGRAM AS PROFILE IS NOT SET' ) ;
390: END IF;

Line 402: OE_STANDARD_WF.Save_Messages;

398: itemkey => p_itemkey,
399: aname => 'OM_DEBUG_LEVEL',
400: avalue => l_debug_level);
401: -- }
402: OE_STANDARD_WF.Save_Messages;
403: OE_STANDARD_WF.Clear_Msg_Context;
404: IF l_debug_level > 0 THEN
405: oe_debug_pub.add( 'EXITING START_ORDER_IMPORT' ) ;
406: END IF;

Line 403: OE_STANDARD_WF.Clear_Msg_Context;

399: aname => 'OM_DEBUG_LEVEL',
400: avalue => l_debug_level);
401: -- }
402: OE_STANDARD_WF.Save_Messages;
403: OE_STANDARD_WF.Clear_Msg_Context;
404: IF l_debug_level > 0 THEN
405: oe_debug_pub.add( 'EXITING START_ORDER_IMPORT' ) ;
406: END IF;
407:

Line 433: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => p_actid,

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);
436: OE_STANDARD_WF.Save_Messages;
437: OE_STANDARD_WF.Clear_Msg_Context;

Line 436: OE_STANDARD_WF.Save_Messages;

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);
436: OE_STANDARD_WF.Save_Messages;
437: OE_STANDARD_WF.Clear_Msg_Context;
438: IF l_debug_level > 0 THEN
439: oe_debug_pub.add( 'IN EXCEPTION ' || SQLERRM ) ;
440: END IF;

Line 437: OE_STANDARD_WF.Clear_Msg_Context;

433: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => p_actid,
434: p_itemtype => p_itemtype,
435: p_itemkey => p_itemkey);
436: OE_STANDARD_WF.Save_Messages;
437: OE_STANDARD_WF.Clear_Msg_Context;
438: IF l_debug_level > 0 THEN
439: oe_debug_pub.add( 'IN EXCEPTION ' || SQLERRM ) ;
440: END IF;
441: IF l_debug_level > 0 THEN

Line 479: OE_STANDARD_WF.Set_Msg_Context(p_actid);

475: IF p_funcmode = 'RUN' THEN
476: IF l_debug_level > 0 THEN
477: oe_debug_pub.add( 'ENTERING IS_OI_COMPLETE' ) ;
478: END IF;
479: OE_STANDARD_WF.Set_Msg_Context(p_actid);
480:
481: get_activity_result( p_itemtype => p_itemtype
482: , p_itemkey => p_itemkey
483: , p_activity_name => 'RUN_ORDER_IMPORT'

Line 611: OE_STANDARD_WF.Save_Messages;

607: aname => 'REQ_ID',
608: avalue => l_request_id);
609: End If;
610:
611: OE_STANDARD_WF.Save_Messages;
612: OE_STANDARD_WF.Clear_Msg_Context;
613: IF l_debug_level > 0 THEN
614: oe_debug_pub.add( 'EXITING IS_OI_COMPLETE' ) ;
615: END IF;

Line 612: OE_STANDARD_WF.Clear_Msg_Context;

608: avalue => l_request_id);
609: End If;
610:
611: OE_STANDARD_WF.Save_Messages;
612: OE_STANDARD_WF.Clear_Msg_Context;
613: IF l_debug_level > 0 THEN
614: oe_debug_pub.add( 'EXITING IS_OI_COMPLETE' ) ;
615: END IF;
616: END IF;

Line 649: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => p_actid,

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);
652: OE_STANDARD_WF.Save_Messages;
653: OE_STANDARD_WF.Clear_Msg_Context;

Line 652: OE_STANDARD_WF.Save_Messages;

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);
652: OE_STANDARD_WF.Save_Messages;
653: OE_STANDARD_WF.Clear_Msg_Context;
654: IF l_debug_level > 0 THEN
655: oe_debug_pub.add( 'IN EXCEPTION ' || SQLERRM ) ;
656:

Line 653: OE_STANDARD_WF.Clear_Msg_Context;

649: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => p_actid,
650: p_itemtype => p_itemtype,
651: p_itemkey => p_itemkey);
652: OE_STANDARD_WF.Save_Messages;
653: OE_STANDARD_WF.Clear_Msg_Context;
654: IF l_debug_level > 0 THEN
655: oe_debug_pub.add( 'IN EXCEPTION ' || SQLERRM ) ;
656:
657: oe_debug_pub.add( 'EXITING IS_OI_COMPLETE WITH OTHERS EXCEPTION' ) ;

Line 703: OE_STANDARD_WF.Set_Msg_Context(p_actid);

699: IF l_debug_level > 0 THEN
700: oe_debug_pub.add( 'P_ITEMKEY => ' || P_ITEMKEY ) ;
701: END IF;
702: --ecx_debug.g_debug_level := 3;
703: OE_STANDARD_WF.Set_Msg_Context(p_actid);
704: l_start_from_flow := wf_engine.GetItemAttrText( p_itemtype
705: , p_itemkey
706: , 'START_FROM_FLOW'
707: );

Line 1067: OE_STANDARD_WF.Save_Messages;

1063:
1064: End If;
1065:
1066: p_x_result := 'COMPLETE:COMPLETE';
1067: OE_STANDARD_WF.Save_Messages;
1068: OE_STANDARD_WF.Clear_Msg_Context;
1069: IF l_debug_level > 0 THEN
1070: oe_debug_pub.add( 'EXITING SET_DELIVERY_DATA' ) ;
1071: END IF;

Line 1068: OE_STANDARD_WF.Clear_Msg_Context;

1064: End If;
1065:
1066: p_x_result := 'COMPLETE:COMPLETE';
1067: OE_STANDARD_WF.Save_Messages;
1068: OE_STANDARD_WF.Clear_Msg_Context;
1069: IF l_debug_level > 0 THEN
1070: oe_debug_pub.add( 'EXITING SET_DELIVERY_DATA' ) ;
1071: END IF;
1072:

Line 1098: OE_STANDARD_WF.Save_Messages;

1094: p_x_result := FND_API.G_RET_STS_ERROR;
1095: fnd_message.set_name ('ONT', 'OE_OI_CUST_SITE_NOT_FOUND');
1096: fnd_message.set_token ('CUST_ID', l_party_id);
1097: oe_msg_pub.add;
1098: OE_STANDARD_WF.Save_Messages;
1099: OE_STANDARD_WF.Clear_Msg_Context;
1100: WHEN OTHERS THEN
1101: p_x_result := 'COMPLETE:ERROR';
1102: p_x_result := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1099: OE_STANDARD_WF.Clear_Msg_Context;

1095: fnd_message.set_name ('ONT', 'OE_OI_CUST_SITE_NOT_FOUND');
1096: fnd_message.set_token ('CUST_ID', l_party_id);
1097: oe_msg_pub.add;
1098: OE_STANDARD_WF.Save_Messages;
1099: OE_STANDARD_WF.Clear_Msg_Context;
1100: WHEN OTHERS THEN
1101: p_x_result := 'COMPLETE:ERROR';
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

Line 1108: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => p_actid,

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);
1111: OE_STANDARD_WF.Save_Messages;
1112: OE_STANDARD_WF.Clear_Msg_Context;

Line 1111: OE_STANDARD_WF.Save_Messages;

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);
1111: OE_STANDARD_WF.Save_Messages;
1112: OE_STANDARD_WF.Clear_Msg_Context;
1113: IF l_debug_level > 0 THEN
1114: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
1115: END IF;

Line 1112: OE_STANDARD_WF.Clear_Msg_Context;

1108: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => p_actid,
1109: p_itemtype => p_itemtype,
1110: p_itemkey => p_itemkey);
1111: OE_STANDARD_WF.Save_Messages;
1112: OE_STANDARD_WF.Clear_Msg_Context;
1113: IF l_debug_level > 0 THEN
1114: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
1115: END IF;
1116: RAISE;

Line 1168: OE_STANDARD_WF.Set_Msg_Context(p_actid);

1164: oe_debug_pub.add( 'CUSTOMER KEY PROFILE SETTING = '||l_customer_key_profile ) ;
1165: END IF;
1166: End If;
1167:
1168: OE_STANDARD_WF.Set_Msg_Context(p_actid);
1169: If p_itemtype = G_WFI_ORDER_IMPORT Then
1170: l_order_imported := wf_engine.GetItemAttrText
1171: (itemtype => p_itemtype,
1172: itemkey => p_itemkey,

Line 1309: OE_STANDARD_WF.Save_Messages;

1305: 'ECX_PARTY_SITE_ID',
1306: l_party_site_id);
1307: END IF;
1308: p_x_result := l_is_delivery_reqd;
1309: OE_STANDARD_WF.Save_Messages;
1310: OE_STANDARD_WF.Clear_Msg_Context;
1311:
1312: END IF;
1313: --

Line 1310: OE_STANDARD_WF.Clear_Msg_Context;

1306: l_party_site_id);
1307: END IF;
1308: p_x_result := l_is_delivery_reqd;
1309: OE_STANDARD_WF.Save_Messages;
1310: OE_STANDARD_WF.Clear_Msg_Context;
1311:
1312: END IF;
1313: --
1314: -- CANCEL mode - activity 'compensation'

Line 1340: OE_STANDARD_WF.Save_Messages;

1336: fnd_message.set_name ('ONT', 'OE_OI_CUST_NOT_FOUND');
1337: fnd_message.set_token ('OPT_TABLE', '');
1338: fnd_message.set_token ('DOC_ID', nvl(l_orig_sys_document_ref,p_itemkey));
1339: oe_msg_pub.add;
1340: OE_STANDARD_WF.Save_Messages;
1341: OE_STANDARD_WF.Clear_Msg_Context;
1342: WHEN OTHERS THEN
1343: IF OE_Code_Control.Get_Code_Release_Level < '110510' THEN
1344: p_x_result := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1341: OE_STANDARD_WF.Clear_Msg_Context;

1337: fnd_message.set_token ('OPT_TABLE', '');
1338: fnd_message.set_token ('DOC_ID', nvl(l_orig_sys_document_ref,p_itemkey));
1339: oe_msg_pub.add;
1340: OE_STANDARD_WF.Save_Messages;
1341: OE_STANDARD_WF.Clear_Msg_Context;
1342: WHEN OTHERS THEN
1343: IF OE_Code_Control.Get_Code_Release_Level < '110510' THEN
1344: p_x_result := FND_API.G_RET_STS_UNEXP_ERROR ;
1345: ELSE

Line 1353: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => p_actid,

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);
1356: OE_STANDARD_WF.Save_Messages;
1357: OE_STANDARD_WF.Clear_Msg_Context;

Line 1356: OE_STANDARD_WF.Save_Messages;

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);
1356: OE_STANDARD_WF.Save_Messages;
1357: OE_STANDARD_WF.Clear_Msg_Context;
1358: IF l_debug_level > 0 THEN
1359: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
1360: END IF;

Line 1357: OE_STANDARD_WF.Clear_Msg_Context;

1353: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => p_actid,
1354: p_itemtype => p_itemtype,
1355: p_itemkey => p_itemkey);
1356: OE_STANDARD_WF.Save_Messages;
1357: OE_STANDARD_WF.Clear_Msg_Context;
1358: IF l_debug_level > 0 THEN
1359: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
1360: END IF;
1361: RAISE;

Line 1393: OE_STANDARD_WF.Set_Msg_Context(p_actid);

1389: IF p_funcmode = 'RUN' THEN
1390: IF l_debug_level > 0 THEN
1391: oe_debug_pub.add( 'ENTERING OEXWFOI.PROCESS_XML_ACKNOWLEDGMENT_WF' ) ;
1392: END IF;
1393: OE_STANDARD_WF.Set_Msg_Context(p_actid);
1394:
1395: l_start_from_flow := wf_engine.GetItemAttrText( p_itemtype
1396: , p_itemkey
1397: , 'START_FROM_FLOW'

Line 1562: OE_STANDARD_WF.Save_Messages;

1558: p_x_result := 'COMPLETE:COMPLETE';
1559: ELSE
1560: p_x_result := G_WFR_COMPLETE;
1561: END IF;
1562: OE_STANDARD_WF.Save_Messages;
1563: OE_STANDARD_WF.Clear_Msg_Context;
1564:
1565: END IF;
1566: --

Line 1563: OE_STANDARD_WF.Clear_Msg_Context;

1559: ELSE
1560: p_x_result := G_WFR_COMPLETE;
1561: END IF;
1562: OE_STANDARD_WF.Save_Messages;
1563: OE_STANDARD_WF.Clear_Msg_Context;
1564:
1565: END IF;
1566: --
1567: -- CANCEL mode - activity 'compensation'

Line 1594: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => p_actid,

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);
1597: OE_STANDARD_WF.Save_Messages;
1598: OE_STANDARD_WF.Clear_Msg_Context;

Line 1597: OE_STANDARD_WF.Save_Messages;

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);
1597: OE_STANDARD_WF.Save_Messages;
1598: OE_STANDARD_WF.Clear_Msg_Context;
1599: IF l_debug_level > 0 THEN
1600: oe_debug_pub.add( 'EXITING WITH WHEN OTHERS EXCEPTION' ) ;
1601: END IF;

Line 1598: OE_STANDARD_WF.Clear_Msg_Context;

1594: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => p_actid,
1595: p_itemtype => p_itemtype,
1596: p_itemkey => p_itemkey);
1597: OE_STANDARD_WF.Save_Messages;
1598: OE_STANDARD_WF.Clear_Msg_Context;
1599: IF l_debug_level > 0 THEN
1600: oe_debug_pub.add( 'EXITING WITH WHEN OTHERS EXCEPTION' ) ;
1601: END IF;
1602: RAISE;

Line 1683: OE_STANDARD_WF.Set_Msg_Context(p_actid);

1679: --
1680: Begin
1681:
1682: IF p_funcmode = 'RUN' THEN
1683: OE_STANDARD_WF.Set_Msg_Context(p_actid);
1684: If p_itemtype = Oe_Globals.G_WFI_HDR Then
1685: SELECT order_source_id, orig_sys_document_ref, sold_to_org_id, change_sequence, order_number, order_type_id, org_id
1686: INTO l_order_source_id, l_orig_sys_document_ref, l_sold_to_org_id, l_change_sequence, l_order_number, l_order_type_id, l_org_id
1687: FROM oe_order_headers

Line 1781: OE_STANDARD_WF.Save_Messages;

1777: IF l_debug_level > 0 THEN
1778: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
1779: END IF;
1780: end if;
1781: OE_STANDARD_WF.Save_Messages;
1782: OE_STANDARD_WF.Clear_Msg_Context;
1783:
1784: END IF;
1785: --

Line 1782: OE_STANDARD_WF.Clear_Msg_Context;

1778: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
1779: END IF;
1780: end if;
1781: OE_STANDARD_WF.Save_Messages;
1782: OE_STANDARD_WF.Clear_Msg_Context;
1783:
1784: END IF;
1785: --
1786: -- CANCEL mode - activity 'compensation'

Line 1809: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => p_actid,

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);
1812: OE_STANDARD_WF.Save_Messages;
1813: OE_STANDARD_WF.Clear_Msg_Context;

Line 1812: OE_STANDARD_WF.Save_Messages;

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);
1812: OE_STANDARD_WF.Save_Messages;
1813: OE_STANDARD_WF.Clear_Msg_Context;
1814: IF l_debug_level > 0 THEN
1815: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
1816: END IF;

Line 1813: OE_STANDARD_WF.Clear_Msg_Context;

1809: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => p_actid,
1810: p_itemtype => p_itemtype,
1811: p_itemkey => p_itemkey);
1812: OE_STANDARD_WF.Save_Messages;
1813: OE_STANDARD_WF.Clear_Msg_Context;
1814: IF l_debug_level > 0 THEN
1815: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
1816: END IF;
1817: RAISE;

Line 1841: OE_STANDARD_WF.Set_Msg_Context(p_actid);

1837: --
1838: Begin
1839:
1840: IF p_funcmode = 'RUN' THEN
1841: OE_STANDARD_WF.Set_Msg_Context(p_actid);
1842: IF l_debug_level > 0 THEN
1843: oe_debug_pub.add( 'ENTERING SET_USER_KEY' ) ;
1844: END IF;
1845:

Line 1962: OE_STANDARD_WF.Save_Messages;

1958: IF l_debug_level > 0 THEN
1959: oe_debug_pub.add( 'EXITING SET_USER_KEY' ) ;
1960: END IF;
1961:
1962: OE_STANDARD_WF.Save_Messages;
1963: OE_STANDARD_WF.Clear_Msg_Context;
1964:
1965: END IF;
1966: --

Line 1963: OE_STANDARD_WF.Clear_Msg_Context;

1959: oe_debug_pub.add( 'EXITING SET_USER_KEY' ) ;
1960: END IF;
1961:
1962: OE_STANDARD_WF.Save_Messages;
1963: OE_STANDARD_WF.Clear_Msg_Context;
1964:
1965: END IF;
1966: --
1967: -- CANCEL mode - activity 'compensation'

Line 1990: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => p_actid,

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);
1993: OE_STANDARD_WF.Save_Messages;
1994: OE_STANDARD_WF.Clear_Msg_Context;

Line 1993: OE_STANDARD_WF.Save_Messages;

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);
1993: OE_STANDARD_WF.Save_Messages;
1994: OE_STANDARD_WF.Clear_Msg_Context;
1995: RAISE;
1996: End Set_User_Key;
1997:

Line 1994: OE_STANDARD_WF.Clear_Msg_Context;

1990: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => p_actid,
1991: p_itemtype => p_itemtype,
1992: p_itemkey => p_itemkey);
1993: OE_STANDARD_WF.Save_Messages;
1994: OE_STANDARD_WF.Clear_Msg_Context;
1995: RAISE;
1996: End Set_User_Key;
1997:
1998: Procedure Is_CBOD_Out_Reqd

Line 2017: OE_STANDARD_WF.Set_Msg_Context(p_actid);

2013: IF p_funcmode = 'RUN' THEN
2014: IF l_debug_level > 0 THEN
2015: oe_debug_pub.add( 'ENTERING IS_CBOD_OUT_REQD' ) ;
2016: END IF;
2017: OE_STANDARD_WF.Set_Msg_Context(p_actid);
2018: l_message_id := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
2019: itemkey => p_itemkey,
2020: aname => 'PARAMETER5');
2021: IF l_debug_level > 0 THEN

Line 2061: OE_STANDARD_WF.Save_Messages;

2057: --p_x_result := 'F';
2058: IF l_debug_level > 0 THEN
2059: oe_debug_pub.add( 'RETURN VALUE FOR IS_CBOD_OUT_REQD: ' || P_X_RESULT ) ;
2060: END IF;
2061: OE_STANDARD_WF.Save_Messages;
2062: OE_STANDARD_WF.Clear_Msg_Context;
2063:
2064: END IF;
2065: --

Line 2062: OE_STANDARD_WF.Clear_Msg_Context;

2058: IF l_debug_level > 0 THEN
2059: oe_debug_pub.add( 'RETURN VALUE FOR IS_CBOD_OUT_REQD: ' || P_X_RESULT ) ;
2060: END IF;
2061: OE_STANDARD_WF.Save_Messages;
2062: OE_STANDARD_WF.Clear_Msg_Context;
2063:
2064: END IF;
2065: --
2066: -- CANCEL mode - activity 'compensation'

Line 2085: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => p_actid,

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);
2088: OE_STANDARD_WF.Save_Messages;
2089: OE_STANDARD_WF.Clear_Msg_Context;

Line 2088: OE_STANDARD_WF.Save_Messages;

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);
2088: OE_STANDARD_WF.Save_Messages;
2089: OE_STANDARD_WF.Clear_Msg_Context;
2090: RAISE;
2091: End Is_CBOD_Out_Reqd;
2092:

Line 2089: OE_STANDARD_WF.Clear_Msg_Context;

2085: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => p_actid,
2086: p_itemtype => p_itemtype,
2087: p_itemkey => p_itemkey);
2088: OE_STANDARD_WF.Save_Messages;
2089: OE_STANDARD_WF.Clear_Msg_Context;
2090: RAISE;
2091: End Is_CBOD_Out_Reqd;
2092:
2093: /* This function is no longer used but we might use it in the future */

Line 2106: OE_STANDARD_WF.Set_Msg_Context(p_actid);

2102: --
2103: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2104: --
2105: Begin
2106: OE_STANDARD_WF.Set_Msg_Context(p_actid);
2107:
2108: p_x_result := 'COMPLETE:COMPLETE'; --need this to avoid runtime error
2109: OE_STANDARD_WF.Save_Messages;
2110: OE_STANDARD_WF.Clear_Msg_Context;

Line 2109: OE_STANDARD_WF.Save_Messages;

2105: Begin
2106: OE_STANDARD_WF.Set_Msg_Context(p_actid);
2107:
2108: p_x_result := 'COMPLETE:COMPLETE'; --need this to avoid runtime error
2109: OE_STANDARD_WF.Save_Messages;
2110: OE_STANDARD_WF.Clear_Msg_Context;
2111: End Populate_CBOD_Out_Globals;
2112:
2113: Procedure Set_CBOD_EVENT_KEY

Line 2110: OE_STANDARD_WF.Clear_Msg_Context;

2106: OE_STANDARD_WF.Set_Msg_Context(p_actid);
2107:
2108: p_x_result := 'COMPLETE:COMPLETE'; --need this to avoid runtime error
2109: OE_STANDARD_WF.Save_Messages;
2110: OE_STANDARD_WF.Clear_Msg_Context;
2111: End Populate_CBOD_Out_Globals;
2112:
2113: Procedure Set_CBOD_EVENT_KEY
2114: ( p_itemtype in varchar2,

Line 2131: OE_STANDARD_WF.Set_Msg_Context(p_actid);

2127: /* l_event_key_num := wf_engine.GetItemAttrNumber (itemtype => p_itemtype,
2128: itemkey => p_itemkey,
2129: aname => 'PARAMETER5');
2130: */
2131: OE_STANDARD_WF.Set_Msg_Context(p_actid);
2132: select oe_xml_message_seq_s.nextval
2133: into l_event_key_num
2134: from dual;
2135:

Line 2141: OE_STANDARD_WF.Save_Messages;

2137: itemkey => p_itemkey,
2138: aname => 'CBOD_EVENT_KEY',
2139: avalue => to_char(l_event_key_num));
2140: p_x_result := to_char(l_event_key_num);
2141: OE_STANDARD_WF.Save_Messages;
2142: OE_STANDARD_WF.Clear_Msg_Context;
2143:
2144: END IF;
2145: --

Line 2142: OE_STANDARD_WF.Clear_Msg_Context;

2138: aname => 'CBOD_EVENT_KEY',
2139: avalue => to_char(l_event_key_num));
2140: p_x_result := to_char(l_event_key_num);
2141: OE_STANDARD_WF.Save_Messages;
2142: OE_STANDARD_WF.Clear_Msg_Context;
2143:
2144: END IF;
2145: --
2146: -- CANCEL mode - activity 'compensation'

Line 2169: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => p_actid,

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);
2172: OE_STANDARD_WF.Save_Messages;
2173: OE_STANDARD_WF.Clear_Msg_Context;

Line 2172: OE_STANDARD_WF.Save_Messages;

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);
2172: OE_STANDARD_WF.Save_Messages;
2173: OE_STANDARD_WF.Clear_Msg_Context;
2174: RAISE;
2175: End Set_cbod_event_key;
2176:

Line 2173: OE_STANDARD_WF.Clear_Msg_Context;

2169: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => p_actid,
2170: p_itemtype => p_itemtype,
2171: p_itemkey => p_itemkey);
2172: OE_STANDARD_WF.Save_Messages;
2173: OE_STANDARD_WF.Clear_Msg_Context;
2174: RAISE;
2175: End Set_cbod_event_key;
2176:
2177:

Line 2215: l_standard_desc VARCHAR2(80);

2211: l_txn_token Varchar2(50);
2212: l_document_disposition VARCHAR2(20);
2213: l_customer_key_profile VARCHAR2(1) := 'N';
2214: l_response_flag VARCHAR2(1);
2215: l_standard_desc VARCHAR2(80);
2216: l_failure_ack_flag VARCHAR2(10) := 'N';
2217: --
2218: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2219: --

Line 2229: OE_STANDARD_WF.Set_Msg_Context(p_actid);

2225: oe_debug_pub.add( 'P_ITEMKEY => ' || P_ITEMKEY ) ;
2226: oe_debug_pub.add( 'P_ITEMTYPE => ' || P_ITEMTYPE ) ;
2227: END IF;
2228:
2229: OE_STANDARD_WF.Set_Msg_Context(p_actid);
2230:
2231: -- bug 3688227
2232: -- start bug 3688227
2233: -- this is all the info we have at this point

Line 2317: -- OE_STANDARD_WF.Save_Messages;

2313: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2314: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Raise_Event_Xmlint_Wf');
2315: END IF;
2316: -- start data fix project
2317: -- OE_STANDARD_WF.Save_Messages;
2318: -- OE_STANDARD_WF.Clear_Msg_Context;
2319: -- end data fix project
2320: End;
2321:

Line 2318: -- OE_STANDARD_WF.Clear_Msg_Context;

2314: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Raise_Event_Xmlint_Wf');
2315: END IF;
2316: -- start data fix project
2317: -- OE_STANDARD_WF.Save_Messages;
2318: -- OE_STANDARD_WF.Clear_Msg_Context;
2319: -- end data fix project
2320: End;
2321:
2322: l_xml_message_id := wf_engine.GetItemAttrText( p_itemtype

Line 2466: -- OE_STANDARD_WF.Save_Messages;

2462: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2463: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Raise_Event_Xmlint_Wf');
2464: END IF;
2465: -- start data fix project
2466: -- OE_STANDARD_WF.Save_Messages;
2467: -- OE_STANDARD_WF.Clear_Msg_Context;
2468: -- end data fix project
2469: IF l_debug_level > 0 THEN
2470: oe_debug_pub.add( 'EXCEPTION IN RAISE_EVENT_XMLINT...SELECTING DOCUMENT NUMBER FOR ' || P_ITEMTYPE ) ;

Line 2467: -- OE_STANDARD_WF.Clear_Msg_Context;

2463: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Raise_Event_Xmlint_Wf');
2464: END IF;
2465: -- start data fix project
2466: -- OE_STANDARD_WF.Save_Messages;
2467: -- OE_STANDARD_WF.Clear_Msg_Context;
2468: -- end data fix project
2469: IF l_debug_level > 0 THEN
2470: oe_debug_pub.add( 'EXCEPTION IN RAISE_EVENT_XMLINT...SELECTING DOCUMENT NUMBER FOR ' || P_ITEMTYPE ) ;
2471: END IF;

Line 2529: OE_STANDARD_WF.Save_Messages;

2525: p_x_result := FND_API.G_RET_STS_UNEXP_ERROR ;
2526: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2527: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Raise_Event_Xmlint_Wf');
2528: END IF;
2529: OE_STANDARD_WF.Save_Messages;
2530: OE_STANDARD_WF.Clear_Msg_Context;
2531: IF l_debug_level > 0 THEN
2532: oe_debug_pub.add( 'EXCEPTION IN RAISE_EVENT_XMLINT...SELECTING DOCUMENT NUMBER' ) ;
2533: END IF;

Line 2530: OE_STANDARD_WF.Clear_Msg_Context;

2526: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2527: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Raise_Event_Xmlint_Wf');
2528: END IF;
2529: OE_STANDARD_WF.Save_Messages;
2530: OE_STANDARD_WF.Clear_Msg_Context;
2531: IF l_debug_level > 0 THEN
2532: oe_debug_pub.add( 'EXCEPTION IN RAISE_EVENT_XMLINT...SELECTING DOCUMENT NUMBER' ) ;
2533: END IF;
2534: Return;

Line 2618: SELECT standard_desc

2614: 'PROCESSING_STATUS',
2615: TRUE);
2616: IF l_setup_status = 'ROSETTANET_SENT' Then
2617: Begin
2618: SELECT standard_desc
2619: INTO l_standard_desc
2620: FROM ecx_standards_vl
2621: WHERE standard_code = 'ROSETTANET';
2622: Exception

Line 2619: INTO l_standard_desc

2615: TRUE);
2616: IF l_setup_status = 'ROSETTANET_SENT' Then
2617: Begin
2618: SELECT standard_desc
2619: INTO l_standard_desc
2620: FROM ecx_standards_vl
2621: WHERE standard_code = 'ROSETTANET';
2622: Exception
2623: When Others Then

Line 2620: FROM ecx_standards_vl

2616: IF l_setup_status = 'ROSETTANET_SENT' Then
2617: Begin
2618: SELECT standard_desc
2619: INTO l_standard_desc
2620: FROM ecx_standards_vl
2621: WHERE standard_code = 'ROSETTANET';
2622: Exception
2623: When Others Then
2624: null;

Line 2621: WHERE standard_code = 'ROSETTANET';

2617: Begin
2618: SELECT standard_desc
2619: INTO l_standard_desc
2620: FROM ecx_standards_vl
2621: WHERE standard_code = 'ROSETTANET';
2622: Exception
2623: When Others Then
2624: null;
2625: End;

Line 2627: fnd_message.set_token ('TRANSACTION', l_standard_desc);

2623: When Others Then
2624: null;
2625: End;
2626: fnd_message.set_name('ONT', 'OE_OA_ACKNOWLEDGMENT_SENT');
2627: fnd_message.set_token ('TRANSACTION', l_standard_desc);
2628: l_message_text := fnd_message.get;
2629: Else
2630: IF (l_transaction_type = Oe_Acknowledgment_Pub.G_TRANSACTION_POA) Then
2631: fnd_message.set_name('ONT', 'OE_OA_ACKNOWLEDGMENT_SENT');

Line 2729: OE_STANDARD_WF.Save_Messages;

2725: p_x_result := 'COMPLETE:COMPLETE';
2726:
2727:
2728: -- start data fix project
2729: OE_STANDARD_WF.Save_Messages;
2730: OE_STANDARD_WF.Clear_Msg_Context;
2731: -- end data fix project
2732: END IF;
2733: --

Line 2730: OE_STANDARD_WF.Clear_Msg_Context;

2726:
2727:
2728: -- start data fix project
2729: OE_STANDARD_WF.Save_Messages;
2730: OE_STANDARD_WF.Clear_Msg_Context;
2731: -- end data fix project
2732: END IF;
2733: --
2734: -- CANCEL mode - activity 'compensation'

Line 2758: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => p_actid,

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);
2761: OE_STANDARD_WF.Save_Messages;
2762: OE_STANDARD_WF.Clear_Msg_Context;

Line 2761: OE_STANDARD_WF.Save_Messages;

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);
2761: OE_STANDARD_WF.Save_Messages;
2762: OE_STANDARD_WF.Clear_Msg_Context;
2763: IF l_debug_level > 0 THEN
2764: oe_debug_pub.add( 'WHEN OTHERS EXCEPTION IN RAISE_EVENT_XMLINT_WF'||SQLERRM ) ;
2765: END IF;

Line 2762: OE_STANDARD_WF.Clear_Msg_Context;

2758: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => p_actid,
2759: p_itemtype => p_itemtype,
2760: p_itemkey => p_itemkey);
2761: OE_STANDARD_WF.Save_Messages;
2762: OE_STANDARD_WF.Clear_Msg_Context;
2763: IF l_debug_level > 0 THEN
2764: oe_debug_pub.add( 'WHEN OTHERS EXCEPTION IN RAISE_EVENT_XMLINT_WF'||SQLERRM ) ;
2765: END IF;
2766: RAISE;

Line 2778: l_standard_code Varchar2(30);

2774: p_funcmode IN Varchar2,
2775: p_x_result IN OUT NOCOPY Varchar2
2776: )
2777: Is
2778: l_standard_code Varchar2(30);
2779: l_party_id Number;
2780: l_party_site_id Number;
2781: l_error_code Number;
2782: l_error_msg Varchar2(1000);

Line 2816: SELECT standard_code

2812: l_party_site_id := to_number(wf_engine.GetItemAttrText (p_itemtype,
2813: p_itemkey,
2814: 'ECX_PARTY_SITE_ID'));
2815:
2816: SELECT standard_code
2817: INTO l_standard_code
2818: FROM ecx_tp_details_v
2819: WHERE tp_header_id = (SELECT tp_header_id FROM ecx_tp_headers
2820: WHERE party_id = l_party_id

Line 2817: INTO l_standard_code

2813: p_itemkey,
2814: 'ECX_PARTY_SITE_ID'));
2815:
2816: SELECT standard_code
2817: INTO l_standard_code
2818: FROM ecx_tp_details_v
2819: WHERE tp_header_id = (SELECT tp_header_id FROM ecx_tp_headers
2820: WHERE party_id = l_party_id
2821: AND party_site_id = l_party_site_id

Line 2826: if (l_standard_code = 'ROSETTANET')

2822: AND party_type = 'C')
2823: AND transaction_type ='ONT'
2824: AND transaction_subtype = 'POA';
2825:
2826: if (l_standard_code = 'ROSETTANET')
2827: then
2828: -- Reached Here. Successful execution.
2829: p_x_result:= 'ROSETTANET';
2830: else -- default will be OAG

Line 2853: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => p_actid,

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);
2856: OE_STANDARD_WF.Save_Messages;
2857: OE_STANDARD_WF.Clear_Msg_Context;

Line 2856: OE_STANDARD_WF.Save_Messages;

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);
2856: OE_STANDARD_WF.Save_Messages;
2857: OE_STANDARD_WF.Clear_Msg_Context;
2858: IF l_debug_level > 0 THEN
2859: oe_debug_pub.add( 'ERROR CODE : ' || l_error_code || ', ERROR MESSAGE : '||SUBSTR ( l_error_msg , 1 , 200 ) , 1 ) ;
2860: END IF;

Line 2857: OE_STANDARD_WF.Clear_Msg_Context;

2853: OE_STANDARD_WF.Add_Error_Activity_Msg(p_actid => p_actid,
2854: p_itemtype => p_itemtype,
2855: p_itemkey => p_itemkey);
2856: OE_STANDARD_WF.Save_Messages;
2857: OE_STANDARD_WF.Clear_Msg_Context;
2858: IF l_debug_level > 0 THEN
2859: oe_debug_pub.add( 'ERROR CODE : ' || l_error_code || ', ERROR MESSAGE : '||SUBSTR ( l_error_msg , 1 , 200 ) , 1 ) ;
2860: END IF;
2861: -- Start of CLN debugs