DBA Data[Home] [Help]

APPS.OE_ATP dependencies on FND_API

Line 43: (p_line_atp_rec.inventory_item_id = FND_API.G_MISS_NUM)

39: IF l_debug_level > 0 THEN
40: oe_debug_pub.add( 'R1' , 3 ) ;
41: END IF;
42: IF (p_line_atp_rec.inventory_item_id IS null) OR
43: (p_line_atp_rec.inventory_item_id = FND_API.G_MISS_NUM)
44: THEN
45: null;
46: goto end_atp_check;
47: END IF;

Line 53: (p_line_atp_rec.ordered_quantity = FND_API.G_MISS_NUM) OR

49: IF l_debug_level > 0 THEN
50: oe_debug_pub.add( 'R2' , 3 ) ;
51: END IF;
52: IF (p_line_atp_rec.ordered_quantity IS null) OR
53: (p_line_atp_rec.ordered_quantity = FND_API.G_MISS_NUM) OR
54: (p_line_atp_rec.ordered_quantity <= 0) OR
55: (p_line_atp_rec.line_category_code = 'RETURN')
56: THEN
57: IF l_debug_level > 0 THEN

Line 67: (p_line_atp_rec.order_quantity_uom = FND_API.G_MISS_CHAR)

63: IF l_debug_level > 0 THEN
64: oe_debug_pub.add( 'R3' , 3 ) ;
65: END IF;
66: IF (p_line_atp_rec.order_quantity_uom IS null) OR
67: (p_line_atp_rec.order_quantity_uom = FND_API.G_MISS_CHAR)
68: THEN
69: null;
70: goto end_atp_check;
71: END IF;

Line 77: (p_line_atp_rec.request_date = FND_API.G_MISS_DATE)

73: IF l_debug_level > 0 THEN
74: oe_debug_pub.add( 'R4' , 3 ) ;
75: END IF;
76: IF (p_line_atp_rec.request_date IS null) OR
77: (p_line_atp_rec.request_date = FND_API.G_MISS_DATE)
78: THEN
79: null;
80: goto end_atp_check;
81: END IF;

Line 97: (p_line_atp_rec.shipped_quantity <> FND_API.G_MISS_NUM) THEN

93: goto end_atp_check;
94: END IF;
95:
96: IF (p_line_atp_rec.shipped_quantity is not null) AND
97: (p_line_atp_rec.shipped_quantity <> FND_API.G_MISS_NUM) THEN
98: IF l_debug_level > 0 THEN
99: oe_debug_pub.add( 'LINE IS SHIPPED' , 3 ) ;
100: END IF;
101: goto end_atp_check;

Line 127: (p_line_atp_rec.ship_from_org_id = FND_API.G_MISS_NUM)

123:
124: --Added for Bug 2549166
125:
126: IF (p_line_atp_rec.ship_from_org_id IS null) OR
127: (p_line_atp_rec.ship_from_org_id = FND_API.G_MISS_NUM)
128: THEN
129: null;
130: goto end_atp_check;
131: ELSE

Line 171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

167: END IF;
168:
169: -- start 3431595
170: IF p_line_atp_rec.p_pa_call then
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
172: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ACTION_NOT_ALLOWED');
173: FND_MESSAGE.SET_TOKEN('ACTION',OE_SCHEDULE_UTIL.OESCH_ACT_ATP_CHECK);
174:
175: IF p_line_atp_rec.line_type_id is not null THEN

Line 220: p_validate => FND_API.G_FALSE,

216: END IF;
217:
218: OE_SCHEDULE_UTIL.atp_check(
219: p_old_line_rec => l_old_line_rec,
220: p_validate => FND_API.G_FALSE,
221: p_x_line_rec => l_line_rec,
222: x_atp_tbl => l_atp_tbl,
223: x_return_status => x_return_status);
224:

Line 226: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

222: x_atp_tbl => l_atp_tbl,
223: x_return_status => x_return_status);
224:
225:
226: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
228: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
229: RAISE FND_API.G_EXC_ERROR;
230: END IF;

Line 227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

223: x_return_status => x_return_status);
224:
225:
226: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
228: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
229: RAISE FND_API.G_EXC_ERROR;
230: END IF;
231:

Line 228: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

224:
225:
226: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
228: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
229: RAISE FND_API.G_EXC_ERROR;
230: END IF;
231:
232: IF l_debug_level > 0 THEN

Line 229: RAISE FND_API.G_EXC_ERROR;

225:
226: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
227: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
228: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
229: RAISE FND_API.G_EXC_ERROR;
230: END IF;
231:
232: IF l_debug_level > 0 THEN
233: oe_debug_pub.add( 'PRINTING THE ATP RECORD' , 3 ) ;

Line 245: WHEN FND_API.G_EXC_ERROR THEN

241: oe_debug_pub.add( 'EXITING ATP_CHECK' || X_RETURN_STATUS , 1 ) ;
242: END IF;
243:
244: EXCEPTION
245: WHEN FND_API.G_EXC_ERROR THEN
246:
247: x_return_status := FND_API.G_RET_STS_ERROR;
248:
249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 247: x_return_status := FND_API.G_RET_STS_ERROR;

243:
244: EXCEPTION
245: WHEN FND_API.G_EXC_ERROR THEN
246:
247: x_return_status := FND_API.G_RET_STS_ERROR;
248:
249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
250:
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

245: WHEN FND_API.G_EXC_ERROR THEN
246:
247: x_return_status := FND_API.G_RET_STS_ERROR;
248:
249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
250:
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252:
253: WHEN OTHERS THEN

Line 251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

247: x_return_status := FND_API.G_RET_STS_ERROR;
248:
249: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
250:
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252:
253: WHEN OTHERS THEN
254:
255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252:
253: WHEN OTHERS THEN
254:
255: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
256:
257: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
258: THEN
259: FND_MSG_PUB.Add_Exc_Msg

Line 340: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

336: (p_group_req_rec => l_group_req_rec,
337: x_atp_tbl => l_out_atp_tbl,
338: x_return_status => l_return_status);
339:
340: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
342: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
343: RAISE FND_API.G_EXC_ERROR;
344: END IF;

Line 341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

337: x_atp_tbl => l_out_atp_tbl,
338: x_return_status => l_return_status);
339:
340: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
342: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
343: RAISE FND_API.G_EXC_ERROR;
344: END IF;
345: END IF;

Line 342: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

338: x_return_status => l_return_status);
339:
340: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
342: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
343: RAISE FND_API.G_EXC_ERROR;
344: END IF;
345: END IF;
346:

Line 343: RAISE FND_API.G_EXC_ERROR;

339:
340: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
342: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
343: RAISE FND_API.G_EXC_ERROR;
344: END IF;
345: END IF;
346:
347: -- Perform ATP Inquiry for Standard Lines

Line 364: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

360: ,x_return_status => l_return_status
361: );
362: */
363:
364: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
366: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
367: RAISE FND_API.G_EXC_ERROR;
368: END IF;

Line 365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

361: );
362: */
363:
364: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
366: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
367: RAISE FND_API.G_EXC_ERROR;
368: END IF;
369:

Line 366: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

362: */
363:
364: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
366: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
367: RAISE FND_API.G_EXC_ERROR;
368: END IF;
369:
370: x_atp_tbl(1) := l_out_atp_rec;

Line 367: RAISE FND_API.G_EXC_ERROR;

363:
364: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
365: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
366: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
367: RAISE FND_API.G_EXC_ERROR;
368: END IF;
369:
370: x_atp_tbl(1) := l_out_atp_rec;
371:

Line 377: WHEN FND_API.G_EXC_ERROR THEN

373: oe_debug_pub.add( 'EXITING ATP_INQUIRY' , 1 ) ;
374: END IF;
375:
376: EXCEPTION
377: WHEN FND_API.G_EXC_ERROR THEN
378:
379: x_return_status := FND_API.G_RET_STS_ERROR;
380:
381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 379: x_return_status := FND_API.G_RET_STS_ERROR;

375:
376: EXCEPTION
377: WHEN FND_API.G_EXC_ERROR THEN
378:
379: x_return_status := FND_API.G_RET_STS_ERROR;
380:
381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
382:
383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

377: WHEN FND_API.G_EXC_ERROR THEN
378:
379: x_return_status := FND_API.G_RET_STS_ERROR;
380:
381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
382:
383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
384:
385: WHEN OTHERS THEN

Line 383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

379: x_return_status := FND_API.G_RET_STS_ERROR;
380:
381: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
382:
383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
384:
385: WHEN OTHERS THEN
386:
387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

383: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
384:
385: WHEN OTHERS THEN
386:
387: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
388:
389: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
390: THEN
391: FND_MSG_PUB.Add_Exc_Msg