DBA Data[Home] [Help]

APPS.OE_SCH_CONC_REQUESTS dependencies on FND_API

Line 107: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 160: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;

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;

Line 917: -- Initially this will be set to FND_API.G_TRUE

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

Line 918: l_init_msg_list := FND_API.G_FALSE;

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

Line 973: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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);

Line 984: IF l_return_status IN (FND_API.G_RET_STS_ERROR,

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) || ' ####');

Line 985: FND_API.G_RET_STS_UNEXP_ERROR) THEN

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;

Line 1045: AND l_return_status = FND_API.G_RET_STS_SUCCESS THEN

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;

Line 1229: l_init_msg_list := FND_API.G_FALSE;

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

Line 1277: (p_validation_level => FND_API.G_VALID_LEVEL_FULL,

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,

Line 1290: (FND_API.G_RET_STS_ERROR,FND_API.G_RET_STS_UNEXP_ERROR)

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 - '

Line 1316: AND l_return_status = FND_API.G_RET_STS_SUCCESS THEN

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

Line 1349: IF l_return_status IN (FND_API.G_RET_STS_ERROR,

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) || ' ####');

Line 1350: FND_API.G_RET_STS_UNEXP_ERROR) THEN

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;

Line 1416: WHEN FND_API.G_EXC_ERROR THEN

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

Line 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