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 OE_MSG_PUB

Line 331: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

327: end if;
328:
329: EXCEPTION
330: WHEN OTHERS THEN
331: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
332: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'CALL_WF_PURGE');
333: END IF;
334: IF l_debug_level > 0 THEN
335: oe_debug_pub.add( 'OTHERS IN CALL_WF_PURGE MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;

Line 332: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'CALL_WF_PURGE');

328:
329: EXCEPTION
330: WHEN OTHERS THEN
331: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
332: OE_MSG_PUB.Add_Exc_Msg (G_PKG_NAME, 'CALL_WF_PURGE');
333: END IF;
334: IF l_debug_level > 0 THEN
335: oe_debug_pub.add( 'OTHERS IN CALL_WF_PURGE MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
336: END IF;

Line 428: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

424: end if;
425: EXCEPTION
426:
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);

Line 429: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'start_order_import');

425: EXCEPTION
426:
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,

Line 558: OE_MSG_PUB.set_msg_context(

554: oe_debug_pub.add( 'L_CHANGE_SEQUENCE IS ' || L_CHANGE_SEQUENCE ) ;
555: END IF;
556:
557: -- start exception management
558: OE_MSG_PUB.set_msg_context(
559: p_entity_code => 'ELECMSG_'||p_itemtype
560: ,p_entity_id => p_itemkey
561: ,p_header_id => null
562: ,p_line_id => null

Line 644: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

640: wf_engine.SetItemAttrText (itemtype => p_itemtype,
641: itemkey => p_itemkey,
642: aname => 'ORDER_IMPORTED',
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);

Line 645: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'is_oi_complete');

641: itemkey => p_itemkey,
642: aname => 'ORDER_IMPORTED',
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,

Line 742: OE_MSG_PUB.set_msg_context(

738: );
739: End If;
740:
741: -- start bug 3688227
742: OE_MSG_PUB.set_msg_context(
743: p_entity_code => 'ELECMSG_'||p_itemtype
744: ,p_entity_ref => null
745: ,p_entity_id => p_itemkey
746: ,p_header_id => null

Line 882: OE_MSG_PUB.update_msg_context(

878: END IF;
879:
880: -- bug 3688227
881: IF l_header_id IS NOT NULL AND l_header_id <> FND_API.G_MISS_NUM THEN
882: OE_MSG_PUB.update_msg_context(
883: p_header_id => l_header_id
884: );
885: END IF;
886: -- end bug 3688227

Line 937: oe_msg_pub.add;

933: if l_order_imported = G_WFR_INCOMPLETE Then
934: fnd_message.set_name ('ONT', 'OE_OI_CUST_NOT_FOUND');
935: fnd_message.set_token ('OPT_TABLE', 'in oe_headers_interface');
936: fnd_message.set_token ('DOC_ID', l_orig_sys_document_ref);
937: oe_msg_pub.add;
938: else
939: fnd_message.set_name ('ONT', 'OE_OI_CUST_NOT_FOUND');
940: fnd_message.set_token ('OPT_TABLE', 'in oe_order_headers');
941: fnd_message.set_token ('DOC_ID', l_header_id);

Line 942: oe_msg_pub.add;

938: else
939: fnd_message.set_name ('ONT', 'OE_OI_CUST_NOT_FOUND');
940: fnd_message.set_token ('OPT_TABLE', 'in oe_order_headers');
941: fnd_message.set_token ('DOC_ID', l_header_id);
942: oe_msg_pub.add;
943: end if;
944: null;
945: End;
946:

Line 1097: oe_msg_pub.add;

1093: p_x_result := 'COMPLETE:ERROR';
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';

Line 1103: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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
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);

Line 1104: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'set_delivery_data');

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
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,

Line 1202: OE_MSG_PUB.set_msg_context(

1198: aname => 'PARAMETER7');
1199: End If;
1200:
1201: -- start bug 3688227
1202: OE_MSG_PUB.set_msg_context(
1203: p_entity_code => 'ELECMSG_'||p_itemtype
1204: ,p_entity_ref => null
1205: ,p_entity_id => p_itemkey
1206: ,p_header_id => null

Line 1274: OE_MSG_PUB.update_msg_context(

1270: End If;
1271:
1272: -- start exception management
1273: If l_header_id is not null then
1274: OE_MSG_PUB.update_msg_context(
1275: p_header_id => l_header_id
1276: );
1277: End If;
1278: -- end exception management

Line 1339: oe_msg_pub.add;

1335: END IF;
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

Line 1348: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1344: p_x_result := FND_API.G_RET_STS_UNEXP_ERROR ;
1345: ELSE
1346: p_x_result := 'N';
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);

Line 1349: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'IS_Partner_Setup');

1345: ELSE
1346: p_x_result := 'N';
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,

Line 1458: OE_MSG_PUB.set_msg_context(

1454: , 'ORIG_SYS_DOCUMENT_REF'
1455: );
1456: -- end exception management
1457: -- start bug 3688227
1458: OE_MSG_PUB.set_msg_context(
1459: p_entity_code => 'ELECMSG_'||p_itemtype
1460: ,p_entity_ref => null
1461: ,p_entity_id => p_itemkey
1462: ,p_header_id => l_header_id

Line 1522: OE_MSG_PUB.set_msg_context(

1518: oe_debug_pub.add( 'OEXWFOI: REF ='||L_ORIG_SYS_DOCUMENT_REF ) ;
1519: END IF;
1520:
1521: -- start bug 3688227
1522: OE_MSG_PUB.set_msg_context(
1523: p_entity_code => 'ELECMSG_'||p_itemtype
1524: ,p_entity_ref => null
1525: ,p_entity_id => p_itemkey
1526: ,p_header_id => null

Line 1589: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1585: p_x_result := 'COMPLETE:ERROR';
1586: ELSE
1587: p_x_result := G_WFR_INCOMPLETE;
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);

Line 1590: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'process_xml_acknowledgment_wf');

1586: ELSE
1587: p_x_result := G_WFR_INCOMPLETE;
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,

Line 1648: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1644: WHEN NO_DATA_FOUND THEN
1645: x_return_status := FND_API.G_RET_STS_ERROR;
1646: WHEN OTHERS THEN
1647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1648: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1649: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Get_Activity_Result');
1650: END IF;
1651: IF l_debug_level > 0 THEN
1652: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;

Line 1649: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Get_Activity_Result');

1645: x_return_status := FND_API.G_RET_STS_ERROR;
1646: WHEN OTHERS THEN
1647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1648: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1649: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Get_Activity_Result');
1650: END IF;
1651: IF l_debug_level > 0 THEN
1652: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
1653: END IF;

Line 1693: OE_MSG_PUB.set_msg_context(

1689:
1690: -- start bug 3688227
1691: -- this message context should be header, since this activity will
1692: -- be called from the order workflow
1693: OE_MSG_PUB.set_msg_context(
1694: p_entity_code => 'HEADER'
1695: ,p_entity_ref => null
1696: ,p_entity_id => null
1697: ,p_header_id => to_number(p_itemkey)

Line 1774: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1770: if l_return_status = fnd_api.g_ret_sts_success then
1771: p_x_result := 'COMPLETE:COMPLETE';
1772: else
1773: p_x_result := 'COMPLETE:ERROR';
1774: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1775: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Raise_Event_Showso_Wf');
1776: END IF;
1777: IF l_debug_level > 0 THEN
1778: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;

Line 1775: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Raise_Event_Showso_Wf');

1771: p_x_result := 'COMPLETE:COMPLETE';
1772: else
1773: p_x_result := 'COMPLETE:ERROR';
1774: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1775: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Raise_Event_Showso_Wf');
1776: END IF;
1777: IF l_debug_level > 0 THEN
1778: oe_debug_pub.add( 'ERROR MESSAGE : '||SUBSTR ( SQLERRM , 1 , 200 ) , 1 ) ;
1779: END IF;

Line 1804: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1800: end if;
1801: Exception
1802: When Others Then
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);

Line 1805: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Raise_Event_Showso_Wf');

1801: Exception
1802: When Others Then
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,

Line 1862: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1858: from oe_order_headers
1859: where header_id = l_header_id;
1860: exception
1861: when others then
1862: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1863: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'set_user_key');
1864: END IF;
1865: -- in this case, we do the best we can, and just use the customer and transaction type for the user key
1866: end;

Line 1863: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'set_user_key');

1859: where header_id = l_header_id;
1860: exception
1861: when others then
1862: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1863: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'set_user_key');
1864: END IF;
1865: -- in this case, we do the best we can, and just use the customer and transaction type for the user key
1866: end;
1867:

Line 1869: OE_MSG_PUB.set_msg_context(

1865: -- in this case, we do the best we can, and just use the customer and transaction type for the user key
1866: end;
1867:
1868: -- start exception management
1869: OE_MSG_PUB.set_msg_context(
1870: p_entity_code => 'ELECMSG_'||p_itemtype
1871: ,p_entity_id => to_number(p_itemkey)
1872: ,p_header_id => l_header_id
1873: ,p_line_id => null

Line 1912: OE_MSG_PUB.set_msg_context(

1908: p_itemkey,
1909: 'PARAMETER7'
1910: );
1911: -- start exception management
1912: OE_MSG_PUB.set_msg_context(
1913: p_entity_code => 'ELECMSG_'||p_itemtype
1914: ,p_entity_id => p_itemkey
1915: ,p_header_id => null
1916: ,p_line_id => null

Line 1985: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1981: end if;
1982: Exception
1983: When Others Then
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);

Line 1986: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'set_user_key');

1982: Exception
1983: When Others Then
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,

Line 2035: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2031: IF l_debug_level > 0 THEN
2032: oe_debug_pub.add( 'NO DATA FOUND IN IS_CBOD_OUT_REQD , RETURNING FALSE I.E. DO NOT SEND CBOD' ) ;
2033: END IF;
2034: p_x_result := 'F';
2035: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2036: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'is_cbod_out_reqd');
2037: END IF;
2038: When OTHERS then
2039: IF l_debug_level > 0 THEN

Line 2036: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'is_cbod_out_reqd');

2032: oe_debug_pub.add( 'NO DATA FOUND IN IS_CBOD_OUT_REQD , RETURNING FALSE I.E. DO NOT SEND CBOD' ) ;
2033: END IF;
2034: p_x_result := 'F';
2035: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2036: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'is_cbod_out_reqd');
2037: END IF;
2038: When OTHERS then
2039: IF l_debug_level > 0 THEN
2040: oe_debug_pub.add( 'OTHERS IN IS_CBOD_OUT_REQD , RETURNING FALSE I.E. DO NOT SEND CBOD' ) ;

Line 2043: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2039: IF l_debug_level > 0 THEN
2040: oe_debug_pub.add( 'OTHERS IN IS_CBOD_OUT_REQD , RETURNING FALSE I.E. DO NOT SEND CBOD' ) ;
2041: END IF;
2042: p_x_result := 'F';
2043: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2044: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'is_cbod_out_reqd');
2045: END IF;
2046: End;
2047: IF l_debug_level > 0 THEN

Line 2044: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'is_cbod_out_reqd');

2040: oe_debug_pub.add( 'OTHERS IN IS_CBOD_OUT_REQD , RETURNING FALSE I.E. DO NOT SEND CBOD' ) ;
2041: END IF;
2042: p_x_result := 'F';
2043: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
2044: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'is_cbod_out_reqd');
2045: END IF;
2046: End;
2047: IF l_debug_level > 0 THEN
2048: oe_debug_pub.add( 'L_CONFIRMATION : '|| L_CONFIRMATION ) ;

Line 2164: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2160: end if;
2161: Exception
2162: WHEN OTHERS then
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);

Line 2165: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'set_cbod_event_key');

2161: Exception
2162: WHEN OTHERS then
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,

Line 2234: OE_MSG_PUB.set_msg_context(

2230:
2231: -- bug 3688227
2232: -- start bug 3688227
2233: -- this is all the info we have at this point
2234: OE_MSG_PUB.set_msg_context(
2235: p_entity_code => 'ELECMSG_'||p_itemtype
2236: ,p_entity_id => p_itemkey
2237: ,p_order_source_id => OE_ACKNOWLEDGMENT_PUB.G_XML_ORDER_SOURCE_ID
2238: );

Line 2290: OE_MSG_PUB.update_msg_context(

2286: , p_itemkey
2287: , 'HEADER_ID'
2288: );
2289: -- start bug 3688227
2290: OE_MSG_PUB.update_msg_context(
2291: p_header_id => l_header_id
2292: );
2293: -- end bug 3688227
2294:

Line 2305: OE_MSG_PUB.update_msg_context(

2301: Into l_orig_sys_document_ref
2302: From oe_order_headers
2303: Where header_id = l_header_id;
2304: -- start bug 3688227
2305: OE_MSG_PUB.update_msg_context(
2306: p_orig_sys_document_ref => l_orig_sys_document_ref
2307: );
2308: -- end bug 3688227
2309: Exception

Line 2313: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2309: Exception
2310: When Others Then
2311: p_x_result := 'COMPLETE:ERROR';
2312: p_x_result := FND_API.G_RET_STS_UNEXP_ERROR ;
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;

Line 2314: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Raise_Event_Xmlint_Wf');

2310: When Others Then
2311: p_x_result := 'COMPLETE:ERROR';
2312: p_x_result := FND_API.G_RET_STS_UNEXP_ERROR ;
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;

Line 2353: OE_MSG_PUB.update_msg_context(

2349: , p_itemkey
2350: , 'PARAMETER2'
2351: );
2352: -- start bug 3688227
2353: OE_MSG_PUB.update_msg_context(
2354: p_orig_sys_document_ref => l_orig_sys_document_ref
2355: );
2356: -- end bug 3688227
2357:

Line 2388: OE_MSG_PUB.update_msg_context(

2384: , p_itemkey
2385: , 'ORIG_SYS_DOCUMENT_REF'
2386: );
2387: -- start bug 3688227
2388: OE_MSG_PUB.update_msg_context(
2389: p_orig_sys_document_ref => l_orig_sys_document_ref
2390: );
2391: -- end bug 3688227
2392:

Line 2421: OE_MSG_PUB.update_msg_context(

2417: , p_itemkey
2418: , 'PARAMETER7'
2419: , TRUE);
2420: -- start bug 3688227
2421: OE_MSG_PUB.update_msg_context(
2422: p_change_sequence => l_change_sequence
2423: );
2424: -- end bug 3688227
2425: END IF;

Line 2453: OE_MSG_PUB.update_msg_context(

2449: And order_source_id = Oe_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID;
2450:
2451:
2452: -- start bug 4195533
2453: OE_MSG_PUB.update_msg_context(
2454: p_header_id => l_header_id
2455: );
2456: -- end bug 4195533
2457:

Line 2462: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2458: Exception
2459: When Others Then
2460: p_x_result := 'COMPLETE:ERROR';
2461: p_x_result := FND_API.G_RET_STS_UNEXP_ERROR ;
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;

Line 2463: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Raise_Event_Xmlint_Wf');

2459: When Others Then
2460: p_x_result := 'COMPLETE:ERROR';
2461: p_x_result := FND_API.G_RET_STS_UNEXP_ERROR ;
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;

Line 2512: OE_MSG_PUB.update_msg_context(

2508: And order_source_id = Oe_Acknowledgment_Pub.G_XML_ORDER_SOURCE_ID;
2509:
2510: -- start bug 4195533
2511: IF l_failure_ack_flag = 'N' THEN
2512: OE_MSG_PUB.update_msg_context(
2513: p_header_id => l_header_id
2514: );
2515: END IF;
2516: -- end bug 4195533

Line 2526: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2522:
2523: When Others Then
2524: p_x_result := 'COMPLETE:ERROR';
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;

Line 2527: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Raise_Event_Xmlint_Wf');

2523: When Others Then
2524: p_x_result := 'COMPLETE:ERROR';
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

Line 2753: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2749: Exception
2750: When Others Then
2751: p_x_result := 'COMPLETE:ERROR';
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);

Line 2754: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Raise_Event_Xmlint_Wf');

2750: When Others Then
2751: p_x_result := 'COMPLETE:ERROR';
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,

Line 2848: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

2844: When Others Then
2845: l_error_code := SQLCODE;
2846: l_error_msg := SQLERRM;
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);

Line 2849: OE_MSG_PUB.Add_Exc_Msg ( G_PKG_NAME, 'Is_OAG_or_RosettaNet');

2845: l_error_code := SQLCODE;
2846: l_error_msg := SQLERRM;
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,