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

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

247: l_msg_count NUMBER;
248: l_msg_data VARCHAR2(2000);
249: l_atp_tbl OE_ATP.atp_tbl_type;
250: l_result Varchar2(30);
251: l_out_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
252: l_line_id NUMBER := 0;
253: l_top_model_line_id NUMBER := 0;
254: l_item_type_code VARCHAR2(30);
255: l_line_category_code VARCHAR2(30);

Line 352: l_result := FND_API.G_TRUE;

348:
349: IF OE_BULK_HOLDS_PVT.G_Line_Holds_Tbl.EXISTS(OE_BULK_WF_UTIL.G_LINE_INDEX)
350: AND OE_BULK_HOLDS_PVT.G_Line_Holds_Tbl(OE_BULK_WF_UTIL.G_LINE_INDEX).On_Scheduling_Hold = 'Y'
351: THEN
352: l_result := FND_API.G_TRUE;
353: END IF;
354:
355: ELSE -- If not BULK mode.
356:

Line 739: , p_init_msg_list => FND_API.G_FALSE

735: END IF;
736:
737: OE_Holds_PUB.Check_Holds
738: ( p_api_version => 1.0
739: , p_init_msg_list => FND_API.G_FALSE
740: , p_commit => FND_API.G_FALSE
741: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
742: , x_return_status => l_out_return_status
743: , x_msg_count => l_msg_count

Line 740: , p_commit => FND_API.G_FALSE

736:
737: OE_Holds_PUB.Check_Holds
738: ( p_api_version => 1.0
739: , p_init_msg_list => FND_API.G_FALSE
740: , p_commit => FND_API.G_FALSE
741: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
742: , x_return_status => l_out_return_status
743: , x_msg_count => l_msg_count
744: , x_msg_data => l_msg_data

Line 741: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

737: OE_Holds_PUB.Check_Holds
738: ( p_api_version => 1.0
739: , p_init_msg_list => FND_API.G_FALSE
740: , p_commit => FND_API.G_FALSE
741: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
742: , x_return_status => l_out_return_status
743: , x_msg_count => l_msg_count
744: , x_msg_data => l_msg_data
745: , p_line_id => l_line_id

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

755: IF l_debug_level > 0 THEN
756: oe_debug_pub.add( 'AFTER CALLING CHECK HOLDS'||L_OUT_RETURN_STATUS||'/'||L_RESULT , 1 ) ;
757: END IF;
758:
759: IF (l_out_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
760: IF l_out_return_status = FND_API.G_RET_STS_ERROR THEN
761: RAISE FND_API.G_EXC_ERROR;
762: ELSE
763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 760: IF l_out_return_status = FND_API.G_RET_STS_ERROR THEN

756: oe_debug_pub.add( 'AFTER CALLING CHECK HOLDS'||L_OUT_RETURN_STATUS||'/'||L_RESULT , 1 ) ;
757: END IF;
758:
759: IF (l_out_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
760: IF l_out_return_status = FND_API.G_RET_STS_ERROR THEN
761: RAISE FND_API.G_EXC_ERROR;
762: ELSE
763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
764: END IF;

Line 761: RAISE FND_API.G_EXC_ERROR;

757: END IF;
758:
759: IF (l_out_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
760: IF l_out_return_status = FND_API.G_RET_STS_ERROR THEN
761: RAISE FND_API.G_EXC_ERROR;
762: ELSE
763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
764: END IF;
765: END IF;

Line 763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

759: IF (l_out_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
760: IF l_out_return_status = FND_API.G_RET_STS_ERROR THEN
761: RAISE FND_API.G_EXC_ERROR;
762: ELSE
763: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
764: END IF;
765: END IF;
766: ELSE -- ER 13114460
767: IF l_debug_level > 0 THEN

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

770: END IF;
771:
772: END IF; -- End IF BULK Mode
773:
774: IF (l_result = FND_API.G_TRUE) THEN
775: IF l_debug_level > 0 THEN
776: oe_debug_pub.add( 'LINE IS ON HOLD' , 1 ) ;
777: END IF;
778: ROLLBACK TO Before_Lock;

Line 1001: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

997: l_Arrival_set_id IS NULL AND
998: oe_schedule_util.OESCH_SET_SCHEDULING = 'N' THEN
999: oe_schedule_util.OESCH_SET_SCHEDULING := 'Y' ;
1000: END IF;
1001: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1002: -- Clear oe_schedule_lines_temp table.
1003: BEGIN
1004: IF l_debug_level > 0 THEN
1005: oe_debug_pub.add( 'DELETING oe_schedule_lines_temp ' , 1 ) ;

Line 1012: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1008: EXCEPTION
1009: WHEN OTHERS THEN
1010: NULL;
1011: END;
1012: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1013: IF l_debug_level > 0 THEN
1014: oe_debug_pub.add( 'SCHEDULING WORFKLOW EXP ERRORS' , 1 ) ;
1015: END IF;
1016: resultout := 'COMPLETE:INCOMPLETE';

Line 1039: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1035: END IF;
1036: END IF;
1037:
1038: return;
1039: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1040: IF l_debug_level > 0 THEN
1041: oe_debug_pub.add( 'SCHEDULING WORFKLOW UN-EXP ERRORS' , 1 ) ;
1042: END IF;
1043: resultout := 'COMPLETE:INCOMPLETE';

Line 1587: IF ll_drop_ship_tbl(1).return_status <> FND_API.G_RET_STS_SUCCESS THEN

1583: END IF;
1584:
1585:
1586: -- Fix for the bug2097383
1587: IF ll_drop_ship_tbl(1).return_status <> FND_API.G_RET_STS_SUCCESS THEN
1588:
1589: -- #5873209, do not call fnd api, instead just set the retcode (in OEXCDSPB.pls)
1590: /*IF ll_drop_ship_tbl(1).return_status = 'E' THEN
1591: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING','');

Line 1589: -- #5873209, do not call fnd api, instead just set the retcode (in OEXCDSPB.pls)

1585:
1586: -- Fix for the bug2097383
1587: IF ll_drop_ship_tbl(1).return_status <> FND_API.G_RET_STS_SUCCESS THEN
1588:
1589: -- #5873209, do not call fnd api, instead just set the retcode (in OEXCDSPB.pls)
1590: /*IF ll_drop_ship_tbl(1).return_status = 'E' THEN
1591: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING','');
1592: ELSIF ll_drop_ship_tbl(1).return_status='U' THEN
1593: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');