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 1773: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

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

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

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

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

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

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

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

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

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

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

Line 1868: OE_MSG_PUB.set_msg_context(

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

Line 1911: OE_MSG_PUB.set_msg_context(

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 2233: OE_MSG_PUB.set_msg_context(

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

Line 2289: OE_MSG_PUB.update_msg_context(

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

Line 2304: OE_MSG_PUB.update_msg_context(

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

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

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

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

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

Line 2352: OE_MSG_PUB.update_msg_context(

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

Line 2387: OE_MSG_PUB.update_msg_context(

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

Line 2420: OE_MSG_PUB.update_msg_context(

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

Line 2452: OE_MSG_PUB.update_msg_context(

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

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

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

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

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

Line 2511: OE_MSG_PUB.update_msg_context(

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

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

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

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

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

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

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

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

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

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

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

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

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