877: oe_debug_pub.add( 'L_ORDER_IMPORTED = '||L_ORDER_IMPORTED ) ;
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;
1090:
1091: EXCEPTION
1092: WHEN NO_DATA_FOUND THEN
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;
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
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',
1328: end if;
1329: EXCEPTION
1330: WHEN NO_DATA_FOUND THEN
1331: IF OE_Code_Control.Get_Code_Release_Level < '110510' THEN
1332: p_x_result := FND_API.G_RET_STS_ERROR;
1333: ELSE
1334: p_x_result := 'N';
1335: END IF;
1336: fnd_message.set_name ('ONT', 'OE_OI_CUST_NOT_FOUND');
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
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
1633: AND wias.ITEM_TYPE = p_itemtype
1634: AND wpa.ACTIVITY_NAME = p_activity_name
1635: AND wias.PROCESS_ACTIVITY = wpa.INSTANCE_ID;
1636:
1637: x_return_status := FND_API.G_RET_STS_SUCCESS;
1638:
1639: IF l_debug_level > 0 THEN
1640: oe_debug_pub.add( 'EXITING OE_OI_WF.GET_ACTIVITY_RESULT '||X_ACTIVITY_RESULT||'/'||X_RETURN_STATUS , 1 ) ;
1641: END IF;
1641: END IF;
1642:
1643: EXCEPTION
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');
1643: EXCEPTION
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
1750: p_party_site_id => l_party_site_id,
1751: p_commit_flag => 'N',
1752: x_return_status => l_return_status);
1753: ELSE
1754: l_return_status := fnd_api.g_ret_sts_success;
1755: END IF;
1756: ELSE
1757: l_return_status := fnd_api.g_ret_sts_success;
1758: END IF;
1753: ELSE
1754: l_return_status := fnd_api.g_ret_sts_success;
1755: END IF;
1756: ELSE
1757: l_return_status := fnd_api.g_ret_sts_success;
1758: END IF;
1759: Elsif p_itemtype = Oe_Globals.G_WFI_LIN Then
1760: Oe_Acknowledgment_Pub.Raise_Event_Showso
1761: (p_header_id => Null,
1765: p_itemtype => p_itemtype,
1766: x_return_status => l_return_status);
1767: End If;
1768:
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
2307: -- end bug 3688227
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
2456:
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
2520: l_document_num := NULL;
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;
2747: end if;
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',