DBA Data[Home] [Help]

APPS.OE_RSCH_SETS_CONC_REQUESTS dependencies on FND_API

Line 86: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

82: IF l_debug_level > 0 THEN
83: oe_debug_pub.add( 'AFTER CALLING PROCESS_INCLUDED_ITEMS ' , 1 ) ;
84: END IF;
85:
86: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
87: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
88: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
89: RAISE FND_API.G_EXC_ERROR;
90: END IF;

Line 87: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

83: oe_debug_pub.add( 'AFTER CALLING PROCESS_INCLUDED_ITEMS ' , 1 ) ;
84: END IF;
85:
86: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
87: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
88: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
89: RAISE FND_API.G_EXC_ERROR;
90: END IF;
91:

Line 88: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

84: END IF;
85:
86: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
87: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
88: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
89: RAISE FND_API.G_EXC_ERROR;
90: END IF;
91:
92: OE_Config_Util.Query_Included_Items

Line 89: RAISE FND_API.G_EXC_ERROR;

85:
86: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
87: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
88: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
89: RAISE FND_API.G_EXC_ERROR;
90: END IF;
91:
92: OE_Config_Util.Query_Included_Items
93: (p_line_id => p_x_line_tbl(I).line_id,

Line 123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

119: EXCEPTION
120:
121: WHEN OTHERS THEN
122:
123: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
124: END;
125: END LOOP;
126:
127: IF l_debug_level > 0 THEN

Line 171: IF l_line_tbl(I).reserved_quantity = FND_API.G_MISS_NUM

167: x_old_line_tbl(I).reserved_quantity2 := l_line_tbl(I).reserved_quantity2; */
168:
169: END IF;
170:
171: IF l_line_tbl(I).reserved_quantity = FND_API.G_MISS_NUM
172: OR l_line_tbl(I).reserved_quantity IS NULL THEN
173: l_line_tbl(I).reserved_quantity := 0;
174: END IF;
175: IF x_old_line_tbl(I).reserved_quantity = FND_API.G_MISS_NUM

Line 175: IF x_old_line_tbl(I).reserved_quantity = FND_API.G_MISS_NUM

171: IF l_line_tbl(I).reserved_quantity = FND_API.G_MISS_NUM
172: OR l_line_tbl(I).reserved_quantity IS NULL THEN
173: l_line_tbl(I).reserved_quantity := 0;
174: END IF;
175: IF x_old_line_tbl(I).reserved_quantity = FND_API.G_MISS_NUM
176: OR x_old_line_tbl(I).reserved_quantity IS NULL THEN
177: x_old_line_tbl(I).reserved_quantity := 0;
178: END IF;
179:

Line 180: IF l_line_tbl(I).reserved_quantity2 = FND_API.G_MISS_NUM -- INVCONV

176: OR x_old_line_tbl(I).reserved_quantity IS NULL THEN
177: x_old_line_tbl(I).reserved_quantity := 0;
178: END IF;
179:
180: IF l_line_tbl(I).reserved_quantity2 = FND_API.G_MISS_NUM -- INVCONV
181: OR l_line_tbl(I).reserved_quantity2 IS NULL THEN
182: l_line_tbl(I).reserved_quantity2 := 0;
183: END IF;
184: IF x_old_line_tbl(I).reserved_quantity2 = FND_API.G_MISS_NUM -- INVCONV

Line 184: IF x_old_line_tbl(I).reserved_quantity2 = FND_API.G_MISS_NUM -- INVCONV

180: IF l_line_tbl(I).reserved_quantity2 = FND_API.G_MISS_NUM -- INVCONV
181: OR l_line_tbl(I).reserved_quantity2 IS NULL THEN
182: l_line_tbl(I).reserved_quantity2 := 0;
183: END IF;
184: IF x_old_line_tbl(I).reserved_quantity2 = FND_API.G_MISS_NUM -- INVCONV
185: OR x_old_line_tbl(I).reserved_quantity2 IS NULL THEN
186: x_old_line_tbl(I).reserved_quantity2 := 0;
187: END IF;
188:

Line 229: WHEN FND_API.G_EXC_ERROR THEN

225: oe_debug_pub.add( 'EXITING SCHEDULE_SET_OF_LINES' , 1 ) ;
226: END IF;
227:
228: EXCEPTION
229: WHEN FND_API.G_EXC_ERROR THEN
230:
231: x_return_status := FND_API.G_RET_STS_ERROR;
232:
233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 231: x_return_status := FND_API.G_RET_STS_ERROR;

227:
228: EXCEPTION
229: WHEN FND_API.G_EXC_ERROR THEN
230:
231: x_return_status := FND_API.G_RET_STS_ERROR;
232:
233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
234:
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

229: WHEN FND_API.G_EXC_ERROR THEN
230:
231: x_return_status := FND_API.G_RET_STS_ERROR;
232:
233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
234:
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
236:
237: WHEN OTHERS THEN

Line 235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

231: x_return_status := FND_API.G_RET_STS_ERROR;
232:
233: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
234:
235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
236:
237: WHEN OTHERS THEN
238:
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

235: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
236:
237: WHEN OTHERS THEN
238:
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
240:
241: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
242: THEN
243: OE_MSG_PUB.Add_Exc_Msg

Line 300: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

296:
297: l_start_date DATE;
298: l_end_date DATE;
299: l_set_line_tbl OE_Order_PUB.Line_Tbl_Type;
300: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
301: l_line_rec OE_Order_PUB.Line_Rec_Type;
302: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
303: l_control_rec OE_GLOBALS.control_rec_type;
304: g_set_recursive_flag BOOLEAN := FALSE;

Line 410: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

406: -- Write the message to the database
407:
408: END LOOP;
409:
410: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
411: IF l_debug_level > 0 THEN
412: oe_debug_pub.add( 'INSIDE THE UNEXPECTED ERROR FOR THE FOLLOWING DATA:' ) ;
413: oe_debug_pub.add( 'ORDER NUMBER:'||GET_LINE_SET.ORDER_NUMBER ||' AND '||
414: 'SHIP SET:'||GET_LINE_SET.SHIP_SET_ID||' HAS FAILED RESCHEDULING' ) ;

Line 419: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

415: oe_debug_pub.add( SUBSTR ( SQLERRM , 1 , 2000 ) ) ;
416: END IF;
417: ROLLBACK TO SAVEPOINT Process_lines_in_set;
418:
419: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
420: IF l_debug_level > 0 THEN
421: oe_debug_pub.add( 'INSIDE THE EXPECTED ERROR FOR THE FOLLOWING DATA :' ) ;
422: oe_debug_pub.add( 'ORDER NUMBER:'||GET_LINE_SET.ORDER_NUMBER ||' AND '||
423: 'SHIP SET:'||GET_LINE_SET.SHIP_SET_ID||' HAS FAILED RESCHEDULING' ) ;

Line 427: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

423: 'SHIP SET:'||GET_LINE_SET.SHIP_SET_ID||' HAS FAILED RESCHEDULING' ) ;
424: END IF;
425: ROLLBACK TO SAVEPOINT Process_lines_in_set;
426:
427: ELSIF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
428:
429: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
430: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
431: