DBA Data[Home] [Help]

APPS.OE_OEOL_SCH dependencies on FND_API

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

240: l_msg_count NUMBER;
241: l_msg_data VARCHAR2(2000);
242: l_atp_tbl OE_ATP.atp_tbl_type;
243: l_result Varchar2(30);
244: l_out_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
245: l_line_id NUMBER := 0;
246: l_top_model_line_id NUMBER := 0;
247: l_item_type_code VARCHAR2(30);
248: l_line_category_code VARCHAR2(30);

Line 338: l_result := FND_API.G_TRUE;

334:
335: IF OE_BULK_HOLDS_PVT.G_Line_Holds_Tbl.EXISTS(OE_BULK_WF_UTIL.G_LINE_INDEX)
336: AND OE_BULK_HOLDS_PVT.G_Line_Holds_Tbl(OE_BULK_WF_UTIL.G_LINE_INDEX).On_Scheduling_Hold = 'Y'
337: THEN
338: l_result := FND_API.G_TRUE;
339: END IF;
340:
341: ELSE -- If not BULK mode.
342:

Line 687: , p_init_msg_list => FND_API.G_FALSE

683: END IF;
684:
685: OE_Holds_PUB.Check_Holds
686: ( p_api_version => 1.0
687: , p_init_msg_list => FND_API.G_FALSE
688: , p_commit => FND_API.G_FALSE
689: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
690: , x_return_status => l_out_return_status
691: , x_msg_count => l_msg_count

Line 688: , p_commit => FND_API.G_FALSE

684:
685: OE_Holds_PUB.Check_Holds
686: ( p_api_version => 1.0
687: , p_init_msg_list => FND_API.G_FALSE
688: , p_commit => FND_API.G_FALSE
689: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
690: , x_return_status => l_out_return_status
691: , x_msg_count => l_msg_count
692: , x_msg_data => l_msg_data

Line 689: , p_validation_level => FND_API.G_VALID_LEVEL_FULL

685: OE_Holds_PUB.Check_Holds
686: ( p_api_version => 1.0
687: , p_init_msg_list => FND_API.G_FALSE
688: , p_commit => FND_API.G_FALSE
689: , p_validation_level => FND_API.G_VALID_LEVEL_FULL
690: , x_return_status => l_out_return_status
691: , x_msg_count => l_msg_count
692: , x_msg_data => l_msg_data
693: , p_line_id => l_line_id

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

703: IF l_debug_level > 0 THEN
704: oe_debug_pub.add( 'AFTER CALLING CHECK HOLDS'||L_OUT_RETURN_STATUS||'/'||L_RESULT , 1 ) ;
705: END IF;
706:
707: IF (l_out_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
708: IF l_out_return_status = FND_API.G_RET_STS_ERROR THEN
709: RAISE FND_API.G_EXC_ERROR;
710: ELSE
711: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 708: IF l_out_return_status = FND_API.G_RET_STS_ERROR THEN

704: oe_debug_pub.add( 'AFTER CALLING CHECK HOLDS'||L_OUT_RETURN_STATUS||'/'||L_RESULT , 1 ) ;
705: END IF;
706:
707: IF (l_out_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
708: IF l_out_return_status = FND_API.G_RET_STS_ERROR THEN
709: RAISE FND_API.G_EXC_ERROR;
710: ELSE
711: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
712: END IF;

Line 709: RAISE FND_API.G_EXC_ERROR;

705: END IF;
706:
707: IF (l_out_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
708: IF l_out_return_status = FND_API.G_RET_STS_ERROR THEN
709: RAISE FND_API.G_EXC_ERROR;
710: ELSE
711: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
712: END IF;
713: END IF;

Line 711: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

707: IF (l_out_return_status <> FND_API.G_RET_STS_SUCCESS) THEN
708: IF l_out_return_status = FND_API.G_RET_STS_ERROR THEN
709: RAISE FND_API.G_EXC_ERROR;
710: ELSE
711: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
712: END IF;
713: END IF;
714:
715: END IF; -- End IF BULK Mode

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

713: END IF;
714:
715: END IF; -- End IF BULK Mode
716:
717: IF (l_result = FND_API.G_TRUE) THEN
718: IF l_debug_level > 0 THEN
719: oe_debug_pub.add( 'LINE IS ON HOLD' , 1 ) ;
720: END IF;
721: ROLLBACK TO Before_Lock;

Line 913: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

909: IF l_debug_level > 0 THEN
910: oe_debug_pub.add( 'L_RETURN_STATUS IS ' || L_RETURN_STATUS , 1 ) ;
911: END IF;
912:
913: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
914: IF l_debug_level > 0 THEN
915: oe_debug_pub.add( 'SCHEDULING WORFKLOW EXP ERRORS' , 1 ) ;
916: END IF;
917: resultout := 'COMPLETE:INCOMPLETE';

Line 934: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

930: END IF;
931: END IF;
932:
933: return;
934: ELSIF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
935: IF l_debug_level > 0 THEN
936: oe_debug_pub.add( 'SCHEDULING WORFKLOW UN-EXP ERRORS' , 1 ) ;
937: END IF;
938: resultout := 'COMPLETE:INCOMPLETE';

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

1462: END IF;
1463:
1464:
1465: -- Fix for the bug2097383
1466: IF ll_drop_ship_tbl(1).return_status <> FND_API.G_RET_STS_SUCCESS THEN
1467:
1468: -- #5873209, do not call fnd api, instead just set the retcode (in OEXCDSPB.pls)
1469: /*IF ll_drop_ship_tbl(1).return_status = 'E' THEN
1470: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING','');

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

1464:
1465: -- Fix for the bug2097383
1466: IF ll_drop_ship_tbl(1).return_status <> FND_API.G_RET_STS_SUCCESS THEN
1467:
1468: -- #5873209, do not call fnd api, instead just set the retcode (in OEXCDSPB.pls)
1469: /*IF ll_drop_ship_tbl(1).return_status = 'E' THEN
1470: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING','');
1471: ELSIF ll_drop_ship_tbl(1).return_status='U' THEN
1472: l_temp := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','');