DBA Data[Home] [Help]

APPS.OE_ORDER_IMPORT_WF dependencies on FND_API

Line 881: IF l_header_id IS NOT NULL AND l_header_id <> FND_API.G_MISS_NUM THEN

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;

Line 1094: p_x_result := FND_API.G_RET_STS_ERROR;

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;

Line 1102: p_x_result := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1332: p_x_result := FND_API.G_RET_STS_ERROR;

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

Line 1344: p_x_result := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1637: x_return_status := FND_API.G_RET_STS_SUCCESS;

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;

Line 1645: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 1647: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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

Line 1754: l_return_status := fnd_api.g_ret_sts_success;

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;

Line 1757: l_return_status := fnd_api.g_ret_sts_success;

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,

Line 1770: if l_return_status = fnd_api.g_ret_sts_success then

1766: p_commit_flag => 'N', --12985628 added p_commit_flag as 'N' to avoid p COMMIT when this activity is used in Line workflow
1767: x_return_status => l_return_status);
1768: End If;
1769:
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

Line 2312: p_x_result := FND_API.G_RET_STS_UNEXP_ERROR ;

2308: -- end bug 3688227
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

Line 2461: p_x_result := FND_API.G_RET_STS_UNEXP_ERROR ;

2457:
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

Line 2525: p_x_result := FND_API.G_RET_STS_UNEXP_ERROR ;

2521: l_document_num := NULL;
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;

Line 2752: p_x_result := FND_API.G_RET_STS_UNEXP_ERROR ;

2748: end if;
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',