DBA Data[Home] [Help]

APPS.OE_FULFILL_WF dependencies on FND_API

Line 133: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 207: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

Line 227: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 251: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 252: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 253: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 254: RAISE FND_API.G_EXC_ERROR;

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

Line 270: WHEN FND_API.G_EXC_ERROR THEN

266: OE_DEBUG_PUB.Add('Exiting Complete Fulfill Eligible Line ');
267: END IF;
268:
269: EXCEPTION
270: WHEN FND_API.G_EXC_ERROR THEN
271: x_return_status := FND_API.G_RET_STS_ERROR;
272:
273: IF l_debug_level > 0 THEN
274: OE_DEBUG_PUB.Add('Expected Error in Fulfill Eligible'||sqlerrm);

Line 271: x_return_status := FND_API.G_RET_STS_ERROR;

267: END IF;
268:
269: EXCEPTION
270: WHEN FND_API.G_EXC_ERROR THEN
271: x_return_status := FND_API.G_RET_STS_ERROR;
272:
273: IF l_debug_level > 0 THEN
274: OE_DEBUG_PUB.Add('Expected Error in Fulfill Eligible'||sqlerrm);
275: END IF;

Line 276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

272:
273: IF l_debug_level > 0 THEN
274: OE_DEBUG_PUB.Add('Expected Error in Fulfill Eligible'||sqlerrm);
275: END IF;
276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
278:
279: IF l_debug_level > 0 THEN
280: OE_DEBUG_PUB.Add('Un Expected Error in Fulfill Eligible');

Line 277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

273: IF l_debug_level > 0 THEN
274: OE_DEBUG_PUB.Add('Expected Error in Fulfill Eligible'||sqlerrm);
275: END IF;
276: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
277: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
278:
279: IF l_debug_level > 0 THEN
280: OE_DEBUG_PUB.Add('Un Expected Error in Fulfill Eligible');
281: END IF;

Line 283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 402: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

398: --resultout := 'DEFERRED:'||to_char(sysdate+0.02, wf_engine.date_format); --bug 4189737
399: resultout := 'DEFERRED';
400: OE_STANDARD_WF.Clear_Msg_Context;
401: return;
402: ELSIF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
403: app_exception.raise_exception;
404: END IF;
405: IF l_debug_level > 0 THEN
406: oe_debug_pub.add( '*** completed fulfillment *** for line '||l_line_id,1);