DBA Data[Home] [Help]

APPS.OE_PO_CALLBACK_UTIL dependencies on FND_API

Line 130: IF Not FND_API.Compatible_API_Call (L_API_Version,

126: Begin
127: --
128: SavePoint Update_Req_Info_GRP;
129: --
130: IF Not FND_API.Compatible_API_Call (L_API_Version,
131: P_API_Version,
132: L_API_Name,
133: G_PKG_Name) Then
134: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 134: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

130: IF Not FND_API.Compatible_API_Call (L_API_Version,
131: P_API_Version,
132: L_API_Name,
133: G_PKG_Name) Then
134: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
135: End If;
136: --
137: FND_PROFILE.Get('SO_SOURCE_CODE',G_OE_SOURCE_CODE); -- Returns OE's profile
138: -- value for SO_SOURCE_CODE

Line 142: P_Return_Status := FND_API.G_RET_STS_SUCCESS;

138: -- value for SO_SOURCE_CODE
139: If P_Interface_Source_Code = G_OE_Source_Code Then
140: Null;
141: Else -- Interface source code is not an OE interface source code
142: P_Return_Status := FND_API.G_RET_STS_SUCCESS;
143: Return;
144: End If;
145: --
146: If Valid_Drop_Ship_Source_Id(P_INTERFACE_SOURCE_LINE_ID) Then

Line 150: P_Return_Status := FND_API.G_RET_STS_ERROR;

146: If Valid_Drop_Ship_Source_Id(P_INTERFACE_SOURCE_LINE_ID) Then
147: Null;
148: Else -- The drop ship source ID does not exist. Serious Error!
149: Rollback to Update_Req_INfo_GRP;
150: P_Return_Status := FND_API.G_RET_STS_ERROR;
151: Return;
152: End If;
153: --
154: Open L_SO_Drop_Ship_Source_Csr(P_INTERFACE_SOURCE_LINE_ID);

Line 190: P_Return_Status := FND_API.G_RET_STS_SUCCESS;

186: P_Line_Location_ID => Null);
187: End If;
188: End If;
189: Close L_SO_Drop_Ship_Source_Csr;
190: P_Return_Status := FND_API.G_RET_STS_SUCCESS;
191: Exception
192: When Others Then
193: Rollback to Update_Req_INfo_Grp;
194: P_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 194: P_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

190: P_Return_Status := FND_API.G_RET_STS_SUCCESS;
191: Exception
192: When Others Then
193: Rollback to Update_Req_INfo_Grp;
194: P_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
195: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) Then
196: FND_MSG_PUB.Add_Exc_Msg(G_PKG_Name,L_API_Name);
197: End If;
198: FND_MSG_PUB.Count_And_Get (P_Count => P_MSG_Count,

Line 238: IF Not FND_API.Compatible_API_Call (L_API_Version,

234: Begin
235: --
236: SavePoint UPDATE_ALL_REQS_IN_PROCESS;
237: --
238: IF Not FND_API.Compatible_API_Call (L_API_Version,
239: P_API_Version,
240: L_API_Name,
241: G_PKG_Name) Then
242: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 242: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

238: IF Not FND_API.Compatible_API_Call (L_API_Version,
239: P_API_Version,
240: L_API_Name,
241: G_PKG_Name) Then
242: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
243: End If;
244: --
245: Open L_PO_Req_Interface_CSR;
246: Loop

Line 252: P_Return_Status := FND_API.G_RET_STS_SUCCESS;

248: L_Interface_Source_Line_Id,
249: L_Requisition_Header_Id,
250: L_Requisition_Line_Id;
251: If L_PO_Req_Interface_CSR%NotFound Then
252: P_Return_Status := FND_API.G_RET_STS_SUCCESS;
253: Exit;
254: End If;
255:
256: Update_Req_Info(1.0,

Line 265: If L_Return_Status = FND_API.G_RET_STS_SUCCESS Then

261: L_Interface_Source_Line_ID,
262: L_Requisition_Header_ID,
263: L_Requisition_Line_ID);
264: P_Return_Status := L_Return_Status ;
265: If L_Return_Status = FND_API.G_RET_STS_SUCCESS Then
266: Null;
267: Else
268: Close L_PO_Req_Interface_CSR;
269: Exit;

Line 277: P_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

273:
274: Exception
275: When Others Then
276: Rollback to UPDATE_ALL_REQS_IN_PROCESS;
277: P_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
278: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) Then
279: FND_MSG_PUB.Add_Exc_Msg(G_PKG_Name,L_API_Name);
280: End If;
281: FND_MSG_PUB.Count_And_Get (P_Count => P_MSG_Count,

Line 321: IF Not FND_API.Compatible_API_Call (L_API_Version,

317: And Requisition_Header_ID = P_Req_Header_ID
318: For Update of PO_Header_ID;
319: Begin
320: SavePoint Update_PO_Info_GRP;
321: IF Not FND_API.Compatible_API_Call (L_API_Version,
322: P_API_Version,
323: L_API_Name,
324: G_PKG_Name) THen
325: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

Line 325: Raise FND_API.G_EXC_UNEXPECTED_ERROR;

321: IF Not FND_API.Compatible_API_Call (L_API_Version,
322: P_API_Version,
323: L_API_Name,
324: G_PKG_Name) THen
325: Raise FND_API.G_EXC_UNEXPECTED_ERROR;
326: End If;
327: --
328: Open L_SO_Drop_Ship_SOurce_Csr(P_REQ_LINE_ID,P_REQ_HEADER_ID);
329: Fetch L_So_Drop_Ship_Source_Csr Into G_Drop_Ship_Source_ID,

Line 367: P_Return_Status := FND_API.G_RET_STS_SUCCESS;

363: P_PO_Release_Id => P_PO_Release_ID);
364: End If;
365: End If;
366: Close L_SO_Drop_Ship_Source_Csr;
367: P_Return_Status := FND_API.G_RET_STS_SUCCESS;
368: Exception
369: When Others Then
370: Rollback to Update_PO_Info_GRP;
371: P_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 371: P_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;

367: P_Return_Status := FND_API.G_RET_STS_SUCCESS;
368: Exception
369: When Others Then
370: Rollback to Update_PO_Info_GRP;
371: P_Return_Status := FND_API.G_RET_STS_UNEXP_ERROR;
372: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) Then
373: FND_MSG_PUB.Add_Exc_Msg(G_PKG_Name,L_API_Name);
374: End If;
375: FND_MSG_PUB.Count_And_Get (P_Count => P_MSG_Count,