eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_SCH_CONC_REQUESTS dependencies on FND_API

Line 88: l_out_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

84: -- Begin : ER 13114460
85: l_msg_count NUMBER;
86: l_msg_data VARCHAR2(2000);
87: l_result VARCHAR2(30);
88: l_out_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
89: -- End : ER 13114460
90:
91: BEGIN
92:

Line 110: , p_init_msg_list => FND_API.G_FALSE

106: -- Begin : ER 13114460
107:
108: OE_Holds_PUB.Check_Holds
109: ( p_api_version => 1.0
110: , p_init_msg_list => FND_API.G_FALSE
111: , p_commit => FND_API.G_FALSE
112: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
113: , x_return_status => l_out_return_status
114: , x_msg_count => l_msg_count

Line 111: , p_commit => FND_API.G_FALSE

107:
108: OE_Holds_PUB.Check_Holds
109: ( p_api_version => 1.0
110: , p_init_msg_list => FND_API.G_FALSE
111: , p_commit => FND_API.G_FALSE
112: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
113: , x_return_status => l_out_return_status
114: , x_msg_count => l_msg_count
115: , x_msg_data => l_msg_data

Line 112: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

108: OE_Holds_PUB.Check_Holds
109: ( p_api_version => 1.0
110: , p_init_msg_list => FND_API.G_FALSE
111: , p_commit => FND_API.G_FALSE
112: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
113: , x_return_status => l_out_return_status
114: , x_msg_count => l_msg_count
115: , x_msg_data => l_msg_data
116: , p_line_id => p_line_id

Line 131: IF (l_out_return_status <> FND_API.G_RET_STS_SUCCESS) THEN

127: oe_debug_pub.add( 'AFTER CALLING CHECK HOLDS: ' ||
128: L_OUT_RETURN_STATUS , 1 ) ;
129: END IF;
130:
131: IF (l_out_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
132: IF l_out_return_status = FND_API.G_RET_STS_ERROR THEN
133: RAISE FND_API.G_EXC_ERROR;
134: ELSE
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 132: IF l_out_return_status = FND_API.G_RET_STS_ERROR THEN

128: L_OUT_RETURN_STATUS , 1 ) ;
129: END IF;
130:
131: IF (l_out_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
132: IF l_out_return_status = FND_API.G_RET_STS_ERROR THEN
133: RAISE FND_API.G_EXC_ERROR;
134: ELSE
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136: END IF;

Line 133: RAISE FND_API.G_EXC_ERROR;

129: END IF;
130:
131: IF (l_out_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
132: IF l_out_return_status = FND_API.G_RET_STS_ERROR THEN
133: RAISE FND_API.G_EXC_ERROR;
134: ELSE
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136: END IF;
137: END IF;

Line 135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

131: IF (l_out_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
132: IF l_out_return_status = FND_API.G_RET_STS_ERROR THEN
133: RAISE FND_API.G_EXC_ERROR;
134: ELSE
135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136: END IF;
137: END IF;
138:
139: IF (l_result = FND_API.G_TRUE) THEN

Line 139: IF (l_result = FND_API.G_TRUE) THEN

135: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
136: END IF;
137: END IF;
138:
139: IF (l_result = FND_API.G_TRUE) THEN
140: RETURN FALSE;
141: END IF;
142:
143: -- End : ER 13114460

Line 153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

149: oe_debug_pub.add( 'RETURNING FALSE 1 ' , 1 ) ;
150: END IF;
151: RETURN FALSE;
152: WHEN OTHERS THEN
153: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
154: END Line_Eligible;
155:
156: /*-----------------------------------------------------------------
157: PROCEDURE : Request

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

210: l_cursor_id INTEGER;
211: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
212: l_found BOOLEAN;
213: l_header_id NUMBER;
214: l_init_msg_list VARCHAR2(1) := FND_API.G_FALSE;
215: l_item_type_code VARCHAR2(30);
216: l_line_id NUMBER;
217: l_line_rec OE_ORDER_PUB.Line_Rec_Type;
218: l_line_request_date_high DATE;

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

1099: -- Define a save point
1100: SAVEPOINT Schedule_Line;
1101:
1102: IF l_rec_processed > 1 THEN
1103: -- Initially this will be set to FND_API.G_TRUE
1104: l_init_msg_list := FND_API.G_FALSE;
1105: END IF;
1106:
1107: oe_line_util.lock_row

Line 1104: l_init_msg_list := FND_API.G_FALSE;

1100: SAVEPOINT Schedule_Line;
1101:
1102: IF l_rec_processed > 1 THEN
1103: -- Initially this will be set to FND_API.G_TRUE
1104: l_init_msg_list := FND_API.G_FALSE;
1105: END IF;
1106:
1107: oe_line_util.lock_row
1108: (x_return_status => l_return_status

Line 1159: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1155: g_failed_records := 0;
1156:
1157: Oe_Order_Pvt.Lines
1158: (p_init_msg_list => l_init_msg_list,
1159: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1160: p_control_rec => l_control_rec,
1161: p_x_line_tbl => l_line_tbl,
1162: p_x_old_line_tbl => l_old_line_tbl,
1163: x_return_status => l_return_status);

Line 1170: IF l_return_status IN (FND_API.G_RET_STS_ERROR,

1166: oe_debug_pub.add('Oe_Order_Pvt.Lines returns with - '
1167: || l_return_status);
1168: END IF;
1169:
1170: IF l_return_status IN (FND_API.G_RET_STS_ERROR,
1171: FND_API.G_RET_STS_UNEXP_ERROR) THEN
1172: IF l_debug_level > 0 THEN
1173: oe_debug_pub.add('#### FAILURE #### LINE_ID - '
1174: || to_char(l_line_id) || ' ####');

Line 1171: FND_API.G_RET_STS_UNEXP_ERROR) THEN

1167: || l_return_status);
1168: END IF;
1169:
1170: IF l_return_status IN (FND_API.G_RET_STS_ERROR,
1171: FND_API.G_RET_STS_UNEXP_ERROR) THEN
1172: IF l_debug_level > 0 THEN
1173: oe_debug_pub.add('#### FAILURE #### LINE_ID - '
1174: || to_char(l_line_id) || ' ####');
1175: END IF;

Line 1236: AND l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1232: oe_debug_pub.add('Return Status After Schedule_Multi_lines '||l_return_status,1);
1233: END IF;
1234:
1235: IF NVL(l_booked_flag,'N') ='Y'
1236: AND l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1237:
1238: IF l_debug_level > 0 THEN
1239: oe_debug_pub.add('It is a Booked Order' );
1240: END IF;

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

1301: END IF;
1302:
1303: --Bug 13810638
1304: IF l_return_status IN
1305: (FND_API.G_RET_STS_ERROR,FND_API.G_RET_STS_UNEXP_ERROR)
1306: THEN
1307: ROLLBACK TO SAVEPOINT Schedule_Line;
1308: IF l_debug_level > 0 THEN
1309: oe_debug_pub.add('#### FAILURE #### LINE_ID - '

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

1376: END IF;
1377:
1378: --Bug 13810638
1379: IF l_return_status IN
1380: (FND_API.G_RET_STS_ERROR,FND_API.G_RET_STS_UNEXP_ERROR)
1381: THEN
1382: ROLLBACK TO SAVEPOINT Schedule_Line;
1383: IF l_debug_level > 0 THEN
1384: oe_debug_pub.add('#### FAILURE #### LINE_ID - '

Line 1453: l_init_msg_list := FND_API.G_FALSE;

1449: -- Define a save point
1450: SAVEPOINT Schedule_Line;
1451:
1452: IF l_rec_processed > 1 THEN
1453: l_init_msg_list := FND_API.G_FALSE;
1454: END IF;
1455:
1456: oe_line_util.lock_row
1457: (x_return_status => l_return_status

Line 1501: (p_validation_level => FND_API.G_VALID_LEVEL_FULL,

1497: g_process_records := 0;
1498: g_failed_records := 0;
1499:
1500: Oe_Order_Pvt.Lines
1501: (p_validation_level => FND_API.G_VALID_LEVEL_FULL,
1502: p_init_msg_list => l_init_msg_list,
1503: p_control_rec => l_control_rec,
1504: p_x_line_tbl => l_line_tbl,
1505: p_x_old_line_tbl => l_old_line_tbl,

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

1510: || l_return_status);
1511: END IF;
1512:
1513: IF l_return_status IN
1514: (FND_API.G_RET_STS_ERROR,FND_API.G_RET_STS_UNEXP_ERROR)
1515: THEN
1516: ROLLBACK TO SAVEPOINT Schedule_Line;
1517: IF l_debug_level > 0 THEN
1518: oe_debug_pub.add('#### FAILURE #### LINE_ID - '

Line 1540: AND l_return_status = FND_API.G_RET_STS_SUCCESS THEN

1536: END IF;
1537: END IF; -- line eligible
1538:
1539: IF l_process_order = TRUE
1540: AND l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1541: IF l_debug_level > 0 THEN
1542: oe_debug_pub.add('After Call to Process Order ',1);
1543: END IF;
1544: BEGIN

Line 1573: IF l_return_status IN (FND_API.G_RET_STS_ERROR,

1569:
1570: OE_DELAYED_REQUESTS_PVT.Process_Delayed_Requests
1571: (x_return_status => l_return_status);
1572:
1573: IF l_return_status IN (FND_API.G_RET_STS_ERROR,
1574: FND_API.G_RET_STS_UNEXP_ERROR) THEN
1575: IF l_debug_level > 0 THEN
1576: oe_debug_pub.add('#### FAILURE #### LINE_ID - '
1577: || to_char(l_line_id) || ' ####');

Line 1574: FND_API.G_RET_STS_UNEXP_ERROR) THEN

1570: OE_DELAYED_REQUESTS_PVT.Process_Delayed_Requests
1571: (x_return_status => l_return_status);
1572:
1573: IF l_return_status IN (FND_API.G_RET_STS_ERROR,
1574: FND_API.G_RET_STS_UNEXP_ERROR) THEN
1575: IF l_debug_level > 0 THEN
1576: oe_debug_pub.add('#### FAILURE #### LINE_ID - '
1577: || to_char(l_line_id) || ' ####');
1578: END IF;

Line 1643: WHEN FND_API.G_EXC_ERROR THEN

1639: RETCODE := 1;
1640: END IF;
1641:
1642: EXCEPTION
1643: WHEN FND_API.G_EXC_ERROR THEN
1644: fnd_file.put_line(FND_FILE.LOG,
1645: 'Error executing Scheduling, Exception:G_EXC_ERROR');
1646:
1647: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1647: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1643: WHEN FND_API.G_EXC_ERROR THEN
1644: fnd_file.put_line(FND_FILE.LOG,
1645: 'Error executing Scheduling, Exception:G_EXC_ERROR');
1646:
1647: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1648: fnd_file.put_line(FND_FILE.LOG,
1649: 'Error executing Scheduling, Exception:G_EXC_UNEXPECTED_ERROR');
1650:
1651: WHEN OTHERS THEN