103: oe_debug_pub.add( 'RETURNING FALSE 1 ' , 1 ) ;
104: END IF;
105: RETURN FALSE;
106: WHEN OTHERS THEN
107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
108: END Line_Eligible;
109:
110: /*-----------------------------------------------------------------
111: PROCEDURE : Request
156: l_cursor_id INTEGER;
157: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
158: l_found BOOLEAN;
159: l_header_id NUMBER;
160: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
161: l_item_type_code VARCHAR2(30);
162: l_line_id NUMBER;
163: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
164: l_line_request_date_high DATE;
913: -- Define a save point
914: SAVEPOINT Schedule_Line;
915:
916: IF l_rec_processed > 1 THEN
917: -- Initially this will be set to FND_API.G_TRUE
918: l_init_msg_list := FND_API.G_FALSE;
919: END IF;
920:
921: oe_line_util.lock_row
914: SAVEPOINT Schedule_Line;
915:
916: IF l_rec_processed > 1 THEN
917: -- Initially this will be set to FND_API.G_TRUE
918: l_init_msg_list := FND_API.G_FALSE;
919: END IF;
920:
921: oe_line_util.lock_row
922: (x_return_status => l_return_status
969: g_failed_records := 0;
970:
971: Oe_Order_Pvt.Lines
972: (p_init_msg_list => l_init_msg_list,
973: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
974: p_control_rec => l_control_rec,
975: p_x_line_tbl => l_line_tbl,
976: p_x_old_line_tbl => l_old_line_tbl,
977: x_return_status => l_return_status);
980: oe_debug_pub.add('Oe_Order_Pvt.Lines returns with - '
981: || l_return_status);
982: END IF;
983:
984: IF l_return_status IN (FND_API.G_RET_STS_ERROR,
985: FND_API.G_RET_STS_UNEXP_ERROR) THEN
986: IF l_debug_level > 0 THEN
987: oe_debug_pub.add('#### FAILURE #### LINE_ID - '
988: || to_char(l_line_id) || ' ####');
981: || l_return_status);
982: END IF;
983:
984: IF l_return_status IN (FND_API.G_RET_STS_ERROR,
985: FND_API.G_RET_STS_UNEXP_ERROR) THEN
986: IF l_debug_level > 0 THEN
987: oe_debug_pub.add('#### FAILURE #### LINE_ID - '
988: || to_char(l_line_id) || ' ####');
989: END IF;
1041: oe_debug_pub.add('Return Status After Schedule_Multi_lines '||l_return_status,1);
1042: END IF;
1043:
1044: IF NVL(l_booked_flag,'N') ='Y'
1045: AND l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1046:
1047: IF l_debug_level > 0 THEN
1048: oe_debug_pub.add('It is a Booked Order' );
1049: END IF;
1225: -- Define a save point
1226: SAVEPOINT Schedule_Line;
1227:
1228: IF l_rec_processed > 1 THEN
1229: l_init_msg_list := FND_API.G_FALSE;
1230: END IF;
1231:
1232: oe_line_util.lock_row
1233: (x_return_status => l_return_status
1273: g_process_records := 0;
1274: g_failed_records := 0;
1275:
1276: Oe_Order_Pvt.Lines
1277: (p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1278: p_init_msg_list => l_init_msg_list,
1279: p_control_rec => l_control_rec,
1280: p_x_line_tbl => l_line_tbl,
1281: p_x_old_line_tbl => l_old_line_tbl,
1286: || l_return_status);
1287: END IF;
1288:
1289: IF l_return_status IN
1290: (FND_API.G_RET_STS_ERROR,FND_API.G_RET_STS_UNEXP_ERROR)
1291: THEN
1292: ROLLBACK TO SAVEPOINT Schedule_Line;
1293: IF l_debug_level > 0 THEN
1294: oe_debug_pub.add('#### FAILURE #### LINE_ID - '
1312: END IF;
1313: END IF; -- line eligible
1314:
1315: IF l_process_order = TRUE
1316: AND l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1317: IF l_debug_level > 0 THEN
1318: oe_debug_pub.add('After Call to Process Order ',1);
1319: END IF;
1320: BEGIN
1345:
1346: OE_DELAYED_REQUESTS_PVT.Process_Delayed_Requests
1347: (x_return_status => l_return_status);
1348:
1349: IF l_return_status IN (FND_API.G_RET_STS_ERROR,
1350: FND_API.G_RET_STS_UNEXP_ERROR) THEN
1351: IF l_debug_level > 0 THEN
1352: oe_debug_pub.add('#### FAILURE #### LINE_ID - '
1353: || to_char(l_line_id) || ' ####');
1346: OE_DELAYED_REQUESTS_PVT.Process_Delayed_Requests
1347: (x_return_status => l_return_status);
1348:
1349: IF l_return_status IN (FND_API.G_RET_STS_ERROR,
1350: FND_API.G_RET_STS_UNEXP_ERROR) THEN
1351: IF l_debug_level > 0 THEN
1352: oe_debug_pub.add('#### FAILURE #### LINE_ID - '
1353: || to_char(l_line_id) || ' ####');
1354: END IF;
1412: RETCODE := 1;
1413: END IF;
1414:
1415: EXCEPTION
1416: WHEN FND_API.G_EXC_ERROR THEN
1417: fnd_file.put_line(FND_FILE.LOG,
1418: 'Error executing Scheduling, Exception:G_EXC_ERROR');
1419:
1420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1416: WHEN FND_API.G_EXC_ERROR THEN
1417: fnd_file.put_line(FND_FILE.LOG,
1418: 'Error executing Scheduling, Exception:G_EXC_ERROR');
1419:
1420: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1421: fnd_file.put_line(FND_FILE.LOG,
1422: 'Error executing Scheduling, Exception:G_EXC_UNEXPECTED_ERROR');
1423:
1424: WHEN OTHERS THEN