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 1780: OE_STANDARD_WF.Save_Messages;

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

Line 1781: OE_STANDARD_WF.Clear_Msg_Context;

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

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

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

Line 1811: OE_STANDARD_WF.Save_Messages;

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

Line 1812: OE_STANDARD_WF.Clear_Msg_Context;

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

Line 1840: OE_STANDARD_WF.Set_Msg_Context(p_actid);

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

Line 1961: OE_STANDARD_WF.Save_Messages;

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

Line 1962: OE_STANDARD_WF.Clear_Msg_Context;

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

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

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

Line 1992: OE_STANDARD_WF.Save_Messages;

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

Line 1993: OE_STANDARD_WF.Clear_Msg_Context;

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

Line 2016: OE_STANDARD_WF.Set_Msg_Context(p_actid);

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

Line 2060: OE_STANDARD_WF.Save_Messages;

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

Line 2061: OE_STANDARD_WF.Clear_Msg_Context;

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

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

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

Line 2087: OE_STANDARD_WF.Save_Messages;

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

Line 2088: OE_STANDARD_WF.Clear_Msg_Context;

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

Line 2105: OE_STANDARD_WF.Set_Msg_Context(p_actid);

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

Line 2108: OE_STANDARD_WF.Save_Messages;

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

Line 2109: OE_STANDARD_WF.Clear_Msg_Context;

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

Line 2130: OE_STANDARD_WF.Set_Msg_Context(p_actid);

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

Line 2140: OE_STANDARD_WF.Save_Messages;

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

Line 2141: OE_STANDARD_WF.Clear_Msg_Context;

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

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

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

Line 2171: OE_STANDARD_WF.Save_Messages;

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

Line 2172: OE_STANDARD_WF.Clear_Msg_Context;

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

Line 2214: l_standard_desc VARCHAR2(80);

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

Line 2228: OE_STANDARD_WF.Set_Msg_Context(p_actid);

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

Line 2316: -- OE_STANDARD_WF.Save_Messages;

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

Line 2317: -- OE_STANDARD_WF.Clear_Msg_Context;

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

Line 2465: -- OE_STANDARD_WF.Save_Messages;

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

Line 2466: -- OE_STANDARD_WF.Clear_Msg_Context;

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

Line 2528: OE_STANDARD_WF.Save_Messages;

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

Line 2529: OE_STANDARD_WF.Clear_Msg_Context;

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

Line 2617: SELECT standard_desc

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

Line 2618: INTO l_standard_desc

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

Line 2619: FROM ecx_standards_vl

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

Line 2620: WHERE standard_code = 'ROSETTANET';

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

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

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

Line 2728: OE_STANDARD_WF.Save_Messages;

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

Line 2729: OE_STANDARD_WF.Clear_Msg_Context;

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

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

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

Line 2760: OE_STANDARD_WF.Save_Messages;

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

Line 2761: OE_STANDARD_WF.Clear_Msg_Context;

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

Line 2777: l_standard_code Varchar2(30);

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

Line 2815: SELECT standard_code

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

Line 2816: INTO l_standard_code

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

Line 2825: if (l_standard_code = 'ROSETTANET')

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

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

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

Line 2855: OE_STANDARD_WF.Save_Messages;

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

Line 2856: OE_STANDARD_WF.Clear_Msg_Context;

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