DBA Data[Home] [Help]

APPS.OE_FULFILL_WF dependencies on FND_API

Line 135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

131: END IF;
132: END IF;
133:
134: ELSE
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136: -- item type is not a line
137: END IF;
138:
139: END IF; -- End for 'RUN' mode

Line 209: x_return_status := FND_API.G_RET_STS_SUCCESS;

205: --
206:
207: BEGIN
208:
209: x_return_status := FND_API.G_RET_STS_SUCCESS;
210:
211: -- Check whether the line is eligible to Fulfill
212:
213: IF l_debug_level > 0 THEN

Line 229: x_return_status := FND_API.G_RET_STS_ERROR;

225: AND WIAS.item_key = to_char(p_line_id)
226: AND WIAS.activity_status = 'NOTIFIED' ;
227: EXCEPTION
228: WHEN NO_DATA_FOUND THEN
229: x_return_status := FND_API.G_RET_STS_ERROR;
230:
231: IF l_debug_level > 0 THEN
232: OE_DEBUG_PUB.Add('Line Not Eligible for Fulfillment');
233: END IF;

Line 253: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

249: IF l_debug_level > 0 THEN
250: oe_debug_pub.add('After Calling Lock Row'||l_return_status);
251: END IF;
252:
253: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
256: RAISE FND_API.G_EXC_ERROR;
257: END IF;

Line 254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

250: oe_debug_pub.add('After Calling Lock Row'||l_return_status);
251: END IF;
252:
253: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
256: RAISE FND_API.G_EXC_ERROR;
257: END IF;
258:

Line 255: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

251: END IF;
252:
253: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
256: RAISE FND_API.G_EXC_ERROR;
257: END IF;
258:
259: -- Complete the work flow Fulfill Line Eligible Activity

Line 256: RAISE FND_API.G_EXC_ERROR;

252:
253: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
255: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
256: RAISE FND_API.G_EXC_ERROR;
257: END IF;
258:
259: -- Complete the work flow Fulfill Line Eligible Activity
260: BEGIN --14599978

Line 278: WHEN FND_API.G_EXC_ERROR THEN

274: OE_DEBUG_PUB.Add('Exiting Complete Fulfill Eligible Line ');
275: END IF;
276:
277: EXCEPTION
278: WHEN FND_API.G_EXC_ERROR THEN
279: x_return_status := FND_API.G_RET_STS_ERROR;
280:
281: IF l_debug_level > 0 THEN
282: OE_DEBUG_PUB.Add('Expected Error in Fulfill Eligible'||sqlerrm);

Line 279: x_return_status := FND_API.G_RET_STS_ERROR;

275: END IF;
276:
277: EXCEPTION
278: WHEN FND_API.G_EXC_ERROR THEN
279: x_return_status := FND_API.G_RET_STS_ERROR;
280:
281: IF l_debug_level > 0 THEN
282: OE_DEBUG_PUB.Add('Expected Error in Fulfill Eligible'||sqlerrm);
283: END IF;

Line 284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

280:
281: IF l_debug_level > 0 THEN
282: OE_DEBUG_PUB.Add('Expected Error in Fulfill Eligible'||sqlerrm);
283: END IF;
284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
286:
287: IF l_debug_level > 0 THEN
288: OE_DEBUG_PUB.Add('Un Expected Error in Fulfill Eligible');

Line 285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

281: IF l_debug_level > 0 THEN
282: OE_DEBUG_PUB.Add('Expected Error in Fulfill Eligible'||sqlerrm);
283: END IF;
284: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
285: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
286:
287: IF l_debug_level > 0 THEN
288: OE_DEBUG_PUB.Add('Un Expected Error in Fulfill Eligible');
289: END IF;

Line 291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

287: IF l_debug_level > 0 THEN
288: OE_DEBUG_PUB.Add('Un Expected Error in Fulfill Eligible');
289: END IF;
290: WHEN OTHERS THEN
291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
292:
293: IF l_debug_level > 0 THEN
294: OE_DEBUG_PUB.Add('Un Expected Error in Fulfill Eligible'||sqlerrm);
295: END IF;

Line 410: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

406: --resultout := 'DEFERRED:'||to_char(sysdate+0.02, wf_engine.date_format); --bug 4189737
407: resultout := 'DEFERRED';
408: OE_STANDARD_WF.Clear_Msg_Context;
409: return;
410: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
411: app_exception.raise_exception;
412: END IF;
413: IF l_debug_level > 0 THEN
414: oe_debug_pub.add( '*** completed fulfillment *** for line '||l_line_id,1);