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_PROCESS_OPTIONS_PVT dependencies on FND_API

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

95: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
96: )
97: IS
98: l_model_line_rec OE_Order_Pub.Line_Rec_Type;
99: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
100: l_validation_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
101: l_options_tbl OE_Process_Options_Pvt.Selected_Options_Tbl_Type;
102: l_db_options_tbl OE_Process_Options_Pvt.SELECTED_OPTIONS_TBL_TYPE;
103: l_bom_validation_tbl OE_CONFIG_VALIDATION_PVT.VALIDATE_OPTIONS_TBL_TYPE;

Line 100: l_validation_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

96: )
97: IS
98: l_model_line_rec OE_Order_Pub.Line_Rec_Type;
99: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
100: l_validation_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
101: l_options_tbl OE_Process_Options_Pvt.Selected_Options_Tbl_Type;
102: l_db_options_tbl OE_Process_Options_Pvt.SELECTED_OPTIONS_TBL_TYPE;
103: l_bom_validation_tbl OE_CONFIG_VALIDATION_PVT.VALIDATE_OPTIONS_TBL_TYPE;
104: l_count NUMBER;

Line 141: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

137: ( p_line_id => p_top_model_line_id
138: ,p_x_line_rec => l_model_line_rec
139: ,x_return_status => l_return_status);
140:
141: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
142: FND_MESSAGE.Set_Name('ONT', 'OE_ORDER_OBJECT_LOCKED');
143: OE_MSG_PUB.Add;
144: END IF;
145:

Line 161: RAISE FND_API.G_EXC_ERROR;

157:
158: IF l_debug_level > 0 then
159: oe_debug_pub.add('model line is closed', 1);
160: END IF;
161: RAISE FND_API.G_EXC_ERROR;
162: END IF;
163:
164: IF l_model_line_rec.fulfilled_flag = 'Y' THEN
165: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_MODEL_FULFILLED');

Line 171: RAISE FND_API.G_EXC_ERROR;

167: OE_MSG_PUB.Add;
168: IF l_debug_level > 0 then
169: oe_debug_pub.add('model line is fulfilled', 1);
170: END IF;
171: RAISE FND_API.G_EXC_ERROR;
172: END IF;
173:
174: IF nvl(l_model_line_rec.model_remnant_flag, 'N') = 'Y' THEN
175: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_REMNANT_NO_CHANGES');

Line 181: RAISE FND_API.G_EXC_ERROR;

177: OE_MSG_PUB.Add;
178: IF l_debug_level > 0 then
179: oe_debug_pub.add('remnant model', 1);
180: END IF;
181: RAISE FND_API.G_EXC_ERROR;
182: END IF;
183: END IF;
184:
185:

Line 252: WHEN FND_API.G_EXC_ERROR THEN

248: oe_debug_pub.add
249: ('CONTINUE: '|| L_OPTIONS_TBL ( L_INDEX ) .COMPONENT_CODE , 2 ) ;
250: END IF;
251: EXCEPTION
252: WHEN FND_API.G_EXC_ERROR THEN
253: l_count := l_count + 1;
254: l_options_tbl(l_count) := l_db_options_tbl(I);
255:
256: IF l_debug_level > 0 THEN

Line 350: IF l_validation_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

346: IF l_debug_level > 0 THEN
347: oe_debug_pub.add( 'VALIDATION STATUS '|| L_VALIDATION_STATUS , 1 ) ;
348: END IF;
349:
350: IF l_validation_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
352: END IF;
353:
354: IF l_validation_status <> FND_API.G_RET_STS_SUCCESS THEN

Line 351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

347: oe_debug_pub.add( 'VALIDATION STATUS '|| L_VALIDATION_STATUS , 1 ) ;
348: END IF;
349:
350: IF l_validation_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
352: END IF;
353:
354: IF l_validation_status <> FND_API.G_RET_STS_SUCCESS THEN
355: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_VALIDATION_FAILURE');

Line 354: IF l_validation_status <> FND_API.G_RET_STS_SUCCESS THEN

350: IF l_validation_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
352: END IF;
353:
354: IF l_validation_status <> FND_API.G_RET_STS_SUCCESS THEN
355: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_VALIDATION_FAILURE');
356: OE_Msg_Pub.Add;
357: END IF; -- status = success
358:

Line 439: WHEN FND_API.G_EXC_ERROR THEN

435: EXCEPTION
436:
437: -- IMP please read procedure description.
438:
439: WHEN FND_API.G_EXC_ERROR THEN
440: IF l_debug_level > 0 THEN
441: oe_debug_pub.add( 'EXCEPTION IN PROCESS_CONFIG_OPTIONS'|| SQLERRM ,1);
442: END IF;
443:

Line 445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

441: oe_debug_pub.add( 'EXCEPTION IN PROCESS_CONFIG_OPTIONS'|| SQLERRM ,1);
442: END IF;
443:
444: IF p_ui_flag = 'Y' THEN
445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
446: ELSE
447: x_return_status := FND_API.G_RET_STS_ERROR;
448: END IF;
449:

Line 447: x_return_status := FND_API.G_RET_STS_ERROR;

443:
444: IF p_ui_flag = 'Y' THEN
445: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
446: ELSE
447: x_return_status := FND_API.G_RET_STS_ERROR;
448: END IF;
449:
450: oe_msg_pub.count_and_get
451: ( p_count => x_msg_count

Line 459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

455: oe_debug_pub.add( 'NO. OF MESSAGES ' || X_MSG_COUNT , 3 ) ;
456: oe_debug_pub.add( 'MESSAGES ' || X_MSG_DATA , 3 ) ;
457: END IF;
458:
459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
460: IF l_debug_level > 0 THEN
461: oe_debug_pub.add('EXCEPTION IN PROCESS_CONFIG_OPTIONS'|| SQLERRM ,1);
462: END IF;
463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

459: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
460: IF l_debug_level > 0 THEN
461: oe_debug_pub.add('EXCEPTION IN PROCESS_CONFIG_OPTIONS'|| SQLERRM ,1);
462: END IF;
463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464:
465: oe_msg_pub.count_and_get
466: ( p_count => x_msg_count
467: , p_data => x_msg_data);

Line 495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

491: IF l_debug_level > 0 THEN
492: oe_debug_pub.add( 'NO. OF MESSAGES ' || X_MSG_COUNT , 3 ) ;
493: oe_debug_pub.add( 'MESSAGES ' || X_MSG_DATA , 3 ) ;
494: END IF;
495: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
496:
497: END Process_Config_Options;
498:
499:

Line 672: RAISE FND_API.G_EXC_ERROR;

668:
669: I := p_options_tbl.NEXT(I);
670: END LOOP;
671:
672: RAISE FND_API.G_EXC_ERROR;
673: EXCEPTION
674: WHEN OTHERS THEN
675: IF l_debug_level > 0 THEN
676: oe_debug_pub.add('EXCEPTION IN FIND_MATCHING_COMP_INDEX'|| SQLERRM ,1);

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

721: l_line_del_rec OE_ORDER_PUB.Line_Rec_Type;
722: l_old_line_rec OE_ORDER_PUB.Line_Rec_Type;
723: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
724: l_model_qty NUMBER;
725: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
726: I NUMBER;
727: l_line_count NUMBER;
728: l_class_line_rec OE_ORDER_PUB.Line_Rec_Type;
729: l_class_line_count NUMBER;

Line 1261: RAISE FND_API.G_EXC_ERROR;

1257: WHERE inventory_item_id = p_x_options_tbl(I).inventory_item_id
1258: AND organization_id = l_validation_org;
1259: EXCEPTION
1260: WHEN NO_DATA_FOUND THEN
1261: RAISE FND_API.G_EXC_ERROR;
1262: END;
1263:
1264: I := p_x_options_tbl.NEXT(I);
1265: END LOOP;

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

1341: )
1342: IS
1343: l_outer_index NUMBER;
1344: l_inner_index NUMBER;
1345: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
1346: --
1347: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1348: --
1349: BEGIN

Line 1395: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1391: IF l_debug_level > 0 THEN
1392: oe_debug_pub.add( 'DUPLICATE EXIST' , 1 ) ;
1393: END IF;
1394:
1395: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1396:
1397: FND_MESSAGE.Set_Name('ONT', 'OE_CONFIG_DUPLICATE_COMPONENT');
1398: FND_MESSAGE.Set_Token
1399: ('ITEM', p_options_tbl(l_outer_index).ordered_item);

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

1577: l_top_bill_sequence_id NUMBER;
1578: l_disable_code NUMBER := 1;
1579: l_msg_count NUMBER;
1580: l_msg_data VARCHAR2(2000);
1581: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;
1582:
1583: --
1584: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1585: --

Line 1814: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1810: --
1811: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1812: --
1813: BEGIN
1814: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1816: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
1817: RAISE FND_API.G_EXC_ERROR;
1818: END IF;

Line 1815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1811: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1812: --
1813: BEGIN
1814: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1816: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
1817: RAISE FND_API.G_EXC_ERROR;
1818: END IF;
1819: END Handle_Ret_Status;

Line 1816: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN

1812: --
1813: BEGIN
1814: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1816: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
1817: RAISE FND_API.G_EXC_ERROR;
1818: END IF;
1819: END Handle_Ret_Status;
1820:

Line 1817: RAISE FND_API.G_EXC_ERROR;

1813: BEGIN
1814: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1815: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1816: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN
1817: RAISE FND_API.G_EXC_ERROR;
1818: END IF;
1819: END Handle_Ret_Status;
1820:
1821: