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 98: l_return_status VARCHAR2(1):= FND_API.G_RET_STS_SUCCESS;

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

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

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

Line 140: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 160: RAISE FND_API.G_EXC_ERROR;

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

Line 170: RAISE FND_API.G_EXC_ERROR;

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

Line 180: RAISE FND_API.G_EXC_ERROR;

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

Line 251: WHEN FND_API.G_EXC_ERROR THEN

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

Line 349: IF l_validation_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 353: IF l_validation_status <> FND_API.G_RET_STS_SUCCESS THEN

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

Line 438: WHEN FND_API.G_EXC_ERROR THEN

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

Line 444: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 446: x_return_status := FND_API.G_RET_STS_ERROR;

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

Line 458: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 462: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 494: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 671: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 1260: RAISE FND_API.G_EXC_ERROR;

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

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

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

Line 1394: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

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

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

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

Line 1813: IF p_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

Line 1814: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1815: ELSIF p_return_status = FND_API.G_RET_STS_ERROR THEN

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

Line 1816: RAISE FND_API.G_EXC_ERROR;

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