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 341: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 342: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 343: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 344: RAISE FND_API.G_EXC_ERROR;

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

Line 365: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 367: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 368: RAISE FND_API.G_EXC_ERROR;

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

Line 378: WHEN FND_API.G_EXC_ERROR THEN

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

Line 380: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 382: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 384: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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