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

Line 25: ,p_post_process IN VARCHAR2 DEFAULT FND_API.G_FALSE

21:
22: PROCEDURE Handle_Unreserve
23: ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
24: ,p_old_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
25: ,p_post_process IN VARCHAR2 DEFAULT FND_API.G_FALSE
26: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
27:
28: PROCEDURE Reserve_Group
29: ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type

Line 246: x_return_status := FND_API.G_RET_STS_SUCCESS;

242: IF l_debug_level > 0 THEN
243: oe_debug_pub.add( 'ENTERING LOG_CONFIG_SCH_REQUEST' , 3 ) ;
244: END IF;
245:
246: x_return_status := FND_API.G_RET_STS_SUCCESS;
247:
248: -- the validate config flag is set to N in all 3 procedures
249: -- 1. Cascade_Changes
250: -- 2. Validate_Configuration

Line 475: ,p_delete => FND_API.G_TRUE

471: END IF;
472:
473: OE_DELAYED_REQUESTS_PVT.Process_Request_for_Entity
474: (p_entity_code => OE_GLOBALS.G_ENTITY_LINE
475: ,p_delete => FND_API.G_TRUE
476: ,x_return_status => x_return_status );
477:
478:
479: IF l_debug_level > 0 THEN

Line 483: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

479: IF l_debug_level > 0 THEN
480: oe_debug_pub.add( 'After calling request for entity ' || X_RETURN_STATUS , 1 ) ;
481: END IF;
482:
483: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
485: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
486: RAISE FND_API.G_EXC_ERROR;
487: END IF;

Line 484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

480: oe_debug_pub.add( 'After calling request for entity ' || X_RETURN_STATUS , 1 ) ;
481: END IF;
482:
483: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
485: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
486: RAISE FND_API.G_EXC_ERROR;
487: END IF;
488:

Line 485: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

481: END IF;
482:
483: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
485: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
486: RAISE FND_API.G_EXC_ERROR;
487: END IF;
488:
489: OE_Order_PVT.Process_Requests_And_Notify

Line 486: RAISE FND_API.G_EXC_ERROR;

482:
483: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
485: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
486: RAISE FND_API.G_EXC_ERROR;
487: END IF;
488:
489: OE_Order_PVT.Process_Requests_And_Notify
490: ( x_return_status => x_return_status);

Line 496: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

492: IF l_debug_level > 0 THEN
493: oe_debug_pub.add( '1 RETURN_STATUS IS ' || X_RETURN_STATUS , 1 ) ;
494: END IF;
495:
496: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
498: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
499: RAISE FND_API.G_EXC_ERROR;
500: END IF;

Line 497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

493: oe_debug_pub.add( '1 RETURN_STATUS IS ' || X_RETURN_STATUS , 1 ) ;
494: END IF;
495:
496: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
498: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
499: RAISE FND_API.G_EXC_ERROR;
500: END IF;
501:

Line 498: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

494: END IF;
495:
496: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
498: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
499: RAISE FND_API.G_EXC_ERROR;
500: END IF;
501:
502: END IF;

Line 499: RAISE FND_API.G_EXC_ERROR;

495:
496: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
497: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
498: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
499: RAISE FND_API.G_EXC_ERROR;
500: END IF;
501:
502: END IF;
503:

Line 510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

506: END IF;
507:
508: EXCEPTION
509: WHEN OTHERS THEN
510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
511: IF l_debug_level > 0 THEN
512: oe_debug_pub.add( 'LOG_CONFIG_SCH_REQUEST ERROR '|| SQLERRM , 1 ) ;
513: END IF;
514:

Line 787: x_return_status := FND_API.G_RET_STS_SUCCESS;

783: --
784: BEGIN
785: Print_Time('entering Schedule_SMC ' || p_request_rec.entity_id);
786:
787: x_return_status := FND_API.G_RET_STS_SUCCESS;
788: -- 2882255
789: IF p_request_rec.param1 = Oe_Schedule_Util.OESCH_ACT_SCHEDULE
790: OR p_request_rec.param1 = Oe_Schedule_Util.OESCH_ACT_DEMAND THEN
791: l_send_cancel_lines := 'N';

Line 807: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

803: ,x_line_tbl => l_line_tbl
804: ,x_return_status => x_return_status);
805:
806:
807: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
809: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
810: RAISE FND_API.G_EXC_ERROR;
811: END IF;

Line 808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

804: ,x_return_status => x_return_status);
805:
806:
807: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
809: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
810: RAISE FND_API.G_EXC_ERROR;
811: END IF;
812:

Line 809: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

805:
806:
807: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
809: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
810: RAISE FND_API.G_EXC_ERROR;
811: END IF;
812:
813: l_old_line_tbl := l_line_tbl;

Line 810: RAISE FND_API.G_EXC_ERROR;

806:
807: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
809: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
810: RAISE FND_API.G_EXC_ERROR;
811: END IF;
812:
813: l_old_line_tbl := l_line_tbl;
814:

Line 848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

844: END;
845:
846: Print_Time('leaving Schedule_SMC ' || p_request_rec.entity_id);
847: EXCEPTION
848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
849: IF l_debug_level > 0 THEN
850: oe_debug_pub.add( 'UNEXP ERROR IN SCHEDULE_SMC' , 1 ) ;
851: END IF;
852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

848: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
849: IF l_debug_level > 0 THEN
850: oe_debug_pub.add( 'UNEXP ERROR IN SCHEDULE_SMC' , 1 ) ;
851: END IF;
852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
854:
855: WHEN FND_API.G_EXC_ERROR THEN
856: IF l_debug_level > 0 THEN

Line 853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

849: IF l_debug_level > 0 THEN
850: oe_debug_pub.add( 'UNEXP ERROR IN SCHEDULE_SMC' , 1 ) ;
851: END IF;
852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
854:
855: WHEN FND_API.G_EXC_ERROR THEN
856: IF l_debug_level > 0 THEN
857: oe_debug_pub.add( 'EXC ERROR IN SCHEDULE_SMC' , 1 ) ;

Line 855: WHEN FND_API.G_EXC_ERROR THEN

851: END IF;
852: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
854:
855: WHEN FND_API.G_EXC_ERROR THEN
856: IF l_debug_level > 0 THEN
857: oe_debug_pub.add( 'EXC ERROR IN SCHEDULE_SMC' , 1 ) ;
858: END IF;
859: x_return_status := FND_API.G_RET_STS_ERROR;

Line 859: x_return_status := FND_API.G_RET_STS_ERROR;

855: WHEN FND_API.G_EXC_ERROR THEN
856: IF l_debug_level > 0 THEN
857: oe_debug_pub.add( 'EXC ERROR IN SCHEDULE_SMC' , 1 ) ;
858: END IF;
859: x_return_status := FND_API.G_RET_STS_ERROR;
860: RAISE FND_API.G_EXC_ERROR;
861:
862: WHEN OTHERS THEN
863: IF l_debug_level > 0 THEN

Line 860: RAISE FND_API.G_EXC_ERROR;

856: IF l_debug_level > 0 THEN
857: oe_debug_pub.add( 'EXC ERROR IN SCHEDULE_SMC' , 1 ) ;
858: END IF;
859: x_return_status := FND_API.G_RET_STS_ERROR;
860: RAISE FND_API.G_EXC_ERROR;
861:
862: WHEN OTHERS THEN
863: IF l_debug_level > 0 THEN
864: oe_debug_pub.add( 'OTHERS ERROR IN SCHEDULE_SMC '|| SQLERRM , 1 ) ;

Line 866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

862: WHEN OTHERS THEN
863: IF l_debug_level > 0 THEN
864: oe_debug_pub.add( 'OTHERS ERROR IN SCHEDULE_SMC '|| SQLERRM , 1 ) ;
865: END IF;
866: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
867: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
868: THEN
869: OE_MSG_PUB.Add_Exc_Msg
870: ( G_PKG_NAME

Line 874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

870: ( G_PKG_NAME
871: ,'Schedule_SMC'
872: );
873: END IF;
874: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
875: END Schedule_SMC;
876:
877:
878: /*------------------------------------------------------------

Line 935: x_return_status := FND_API.G_RET_STS_SUCCESS;

931: --
932: BEGIN
933:
934: Print_Time('Entering Schedule_ATO ' || p_request_rec.entity_id);
935: x_return_status := FND_API.G_RET_STS_SUCCESS;
936: -- 2882255
937: IF p_request_rec.param1 = Oe_Schedule_Util.OESCH_ACT_SCHEDULE
938: OR p_request_rec.param1 = Oe_Schedule_Util.OESCH_ACT_DEMAND THEN
939: l_send_cancel_lines := 'N';

Line 1046: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1042:
1043: Print_Time('Exiting Schedule_ATO');
1044:
1045: EXCEPTION
1046: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1047: IF l_debug_level > 0 THEN
1048: oe_debug_pub.add( 'UNEXP ERROR IN SCHEDULE_ATO' , 1 ) ;
1049: END IF;
1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1046: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1047: IF l_debug_level > 0 THEN
1048: oe_debug_pub.add( 'UNEXP ERROR IN SCHEDULE_ATO' , 1 ) ;
1049: END IF;
1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1052:
1053: WHEN FND_API.G_EXC_ERROR THEN
1054: IF l_debug_level > 0 THEN

Line 1051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1047: IF l_debug_level > 0 THEN
1048: oe_debug_pub.add( 'UNEXP ERROR IN SCHEDULE_ATO' , 1 ) ;
1049: END IF;
1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1052:
1053: WHEN FND_API.G_EXC_ERROR THEN
1054: IF l_debug_level > 0 THEN
1055: oe_debug_pub.add( 'EXC ERROR IN SCHEDULE_ATO' , 1 ) ;

Line 1053: WHEN FND_API.G_EXC_ERROR THEN

1049: END IF;
1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1051: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1052:
1053: WHEN FND_API.G_EXC_ERROR THEN
1054: IF l_debug_level > 0 THEN
1055: oe_debug_pub.add( 'EXC ERROR IN SCHEDULE_ATO' , 1 ) ;
1056: END IF;
1057: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1057: x_return_status := FND_API.G_RET_STS_ERROR;

1053: WHEN FND_API.G_EXC_ERROR THEN
1054: IF l_debug_level > 0 THEN
1055: oe_debug_pub.add( 'EXC ERROR IN SCHEDULE_ATO' , 1 ) ;
1056: END IF;
1057: x_return_status := FND_API.G_RET_STS_ERROR;
1058: RAISE FND_API.G_EXC_ERROR;
1059:
1060: WHEN OTHERS THEN
1061: IF l_debug_level > 0 THEN

Line 1058: RAISE FND_API.G_EXC_ERROR;

1054: IF l_debug_level > 0 THEN
1055: oe_debug_pub.add( 'EXC ERROR IN SCHEDULE_ATO' , 1 ) ;
1056: END IF;
1057: x_return_status := FND_API.G_RET_STS_ERROR;
1058: RAISE FND_API.G_EXC_ERROR;
1059:
1060: WHEN OTHERS THEN
1061: IF l_debug_level > 0 THEN
1062: oe_debug_pub.add( 'OTHERS ERROR IN SCHEDULE_ATO '|| SQLERRM , 1 ) ;

Line 1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1060: WHEN OTHERS THEN
1061: IF l_debug_level > 0 THEN
1062: oe_debug_pub.add( 'OTHERS ERROR IN SCHEDULE_ATO '|| SQLERRM , 1 ) ;
1063: END IF;
1064: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1065: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1066: THEN
1067: OE_MSG_PUB.Add_Exc_Msg
1068: ( G_PKG_NAME

Line 1072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1068: ( G_PKG_NAME
1069: ,'Schedule_ATO'
1070: );
1071: END IF;
1072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1073: END Schedule_ATO;
1074:
1075:
1076: /*------------------------------------------------------------

Line 1145: IF l_line_tbl(J).reserved_quantity = FND_API.G_MISS_NUM THEN

1141: p_line_id => l_line_tbl(J).line_id,
1142: p_org_id => l_line_tbl(J).ship_from_org_id);
1143: END IF;
1144:
1145: IF l_line_tbl(J).reserved_quantity = FND_API.G_MISS_NUM THEN
1146: l_line_tbl(J).reserved_quantity := 0;
1147: END IF;
1148:
1149: l_old_line_tbl(J) := l_line_tbl(J);

Line 1207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1203: END;
1204:
1205: Print_Time('leaving schedule_nonsmc');
1206: EXCEPTION
1207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1208: IF l_debug_level > 0 THEN
1209: oe_debug_pub.add( 'UNEXP ERROR IN SCHEDULE_NONSMC' , 1 ) ;
1210: END IF;
1211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1207: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1208: IF l_debug_level > 0 THEN
1209: oe_debug_pub.add( 'UNEXP ERROR IN SCHEDULE_NONSMC' , 1 ) ;
1210: END IF;
1211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1213:
1214: WHEN FND_API.G_EXC_ERROR THEN
1215: IF l_debug_level > 0 THEN

Line 1212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1208: IF l_debug_level > 0 THEN
1209: oe_debug_pub.add( 'UNEXP ERROR IN SCHEDULE_NONSMC' , 1 ) ;
1210: END IF;
1211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1213:
1214: WHEN FND_API.G_EXC_ERROR THEN
1215: IF l_debug_level > 0 THEN
1216: oe_debug_pub.add( 'EXC ERROR IN SCHEDULE_NONSMC' , 1 ) ;

Line 1214: WHEN FND_API.G_EXC_ERROR THEN

1210: END IF;
1211: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1212: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1213:
1214: WHEN FND_API.G_EXC_ERROR THEN
1215: IF l_debug_level > 0 THEN
1216: oe_debug_pub.add( 'EXC ERROR IN SCHEDULE_NONSMC' , 1 ) ;
1217: END IF;
1218: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1218: x_return_status := FND_API.G_RET_STS_ERROR;

1214: WHEN FND_API.G_EXC_ERROR THEN
1215: IF l_debug_level > 0 THEN
1216: oe_debug_pub.add( 'EXC ERROR IN SCHEDULE_NONSMC' , 1 ) ;
1217: END IF;
1218: x_return_status := FND_API.G_RET_STS_ERROR;
1219: RAISE FND_API.G_EXC_ERROR;
1220:
1221: WHEN OTHERS THEN
1222: IF l_debug_level > 0 THEN

Line 1219: RAISE FND_API.G_EXC_ERROR;

1215: IF l_debug_level > 0 THEN
1216: oe_debug_pub.add( 'EXC ERROR IN SCHEDULE_NONSMC' , 1 ) ;
1217: END IF;
1218: x_return_status := FND_API.G_RET_STS_ERROR;
1219: RAISE FND_API.G_EXC_ERROR;
1220:
1221: WHEN OTHERS THEN
1222: IF l_debug_level > 0 THEN
1223: oe_debug_pub.add( 'OTHERS IN SCHEDULE_NONSMC '|| SQLERRM , 1 ) ;

Line 1225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1221: WHEN OTHERS THEN
1222: IF l_debug_level > 0 THEN
1223: oe_debug_pub.add( 'OTHERS IN SCHEDULE_NONSMC '|| SQLERRM , 1 ) ;
1224: END IF;
1225: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1226: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1227: THEN
1228: OE_MSG_PUB.Add_Exc_Msg
1229: ( G_PKG_NAME

Line 1233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1229: ( G_PKG_NAME
1230: ,'Schedule_NONSMC'
1231: );
1232: END IF;
1233: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1234: END Schedule_NONSMC;
1235:
1236:
1237: /*----------------------------------------------------------

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

1253: L NUMBER := 0;
1254: l_done BOOLEAN;
1255: l_unreserve_flag VARCHAR2(1);
1256: l_send_cancel_lines VARCHAR2(1); -- 2882255
1257: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1258: --
1259: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1260: --
1261: BEGIN

Line 1283: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1279: ,p_send_cancel_lines => l_send_cancel_lines -- 'Y' 2882255
1280: ,x_line_tbl => l_inc_items_tbl
1281: ,x_return_status => l_return_status);
1282:
1283: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1285: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1286: RAISE FND_API.G_EXC_ERROR;
1287: END IF;

Line 1284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1280: ,x_line_tbl => l_inc_items_tbl
1281: ,x_return_status => l_return_status);
1282:
1283: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1285: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1286: RAISE FND_API.G_EXC_ERROR;
1287: END IF;
1288:

Line 1285: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1281: ,x_return_status => l_return_status);
1282:
1283: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1285: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1286: RAISE FND_API.G_EXC_ERROR;
1287: END IF;
1288:
1289: IF l_inc_items_tbl.COUNT > 0 THEN

Line 1286: RAISE FND_API.G_EXC_ERROR;

1282:
1283: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1284: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1285: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1286: RAISE FND_API.G_EXC_ERROR;
1287: END IF;
1288:
1289: IF l_inc_items_tbl.COUNT > 0 THEN
1290:

Line 1420: x_return_status := FND_API.G_RET_STS_SUCCESS;

1416: --
1417: BEGIN
1418: Print_Time('entering Process_Group');
1419:
1420: x_return_status := FND_API.G_RET_STS_SUCCESS;
1421:
1422: IF p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNSCHEDULE OR
1423: p_sch_action = OE_SCHEDULE_UTIL.OESCH_ACT_UNRESERVE
1424: THEN

Line 1496: ,p_post_process => FND_API.G_TRUE

1492:
1493: Handle_Unreserve
1494: (p_x_line_tbl => p_x_line_tbl
1495: ,p_old_line_tbl => p_old_line_tbl
1496: ,p_post_process => FND_API.G_TRUE
1497: ,x_return_status => x_return_status);
1498:
1499: END IF;
1500:

Line 1513: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1509: ,p_sch_action => p_sch_action
1510: ,p_caller => OE_SCHEDULE_UTIL.SCH_EXTERNAL
1511: ,x_return_status => x_return_status);
1512:
1513: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1515: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1516: RAISE FND_API.G_EXC_ERROR;
1517: END IF;

Line 1514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1510: ,p_caller => OE_SCHEDULE_UTIL.SCH_EXTERNAL
1511: ,x_return_status => x_return_status);
1512:
1513: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1515: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1516: RAISE FND_API.G_EXC_ERROR;
1517: END IF;
1518: ELSE

Line 1515: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

1511: ,x_return_status => x_return_status);
1512:
1513: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1515: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1516: RAISE FND_API.G_EXC_ERROR;
1517: END IF;
1518: ELSE
1519: IF l_debug_level > 0 THEN

Line 1516: RAISE FND_API.G_EXC_ERROR;

1512:
1513: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1514: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1515: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1516: RAISE FND_API.G_EXC_ERROR;
1517: END IF;
1518: ELSE
1519: IF l_debug_level > 0 THEN
1520: oe_debug_pub.add( 'NO NEED TO CALL LINES' , 3 ) ;

Line 1541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1537:
1538: Print_Time('leaving Process_Group');
1539:
1540: EXCEPTION
1541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1544:
1545: WHEN FND_API.G_EXC_ERROR THEN

Line 1542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1538: Print_Time('leaving Process_Group');
1539:
1540: EXCEPTION
1541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1544:
1545: WHEN FND_API.G_EXC_ERROR THEN
1546: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1539:
1540: EXCEPTION
1541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1544:
1545: WHEN FND_API.G_EXC_ERROR THEN
1546: x_return_status := FND_API.G_RET_STS_ERROR;
1547:

Line 1545: WHEN FND_API.G_EXC_ERROR THEN

1541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1544:
1545: WHEN FND_API.G_EXC_ERROR THEN
1546: x_return_status := FND_API.G_RET_STS_ERROR;
1547:
1548: IF p_caller <> 'UI_ACTION' AND
1549: p_caller <> 'SCHEDULE_ATO'

Line 1546: x_return_status := FND_API.G_RET_STS_ERROR;

1542: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1544:
1545: WHEN FND_API.G_EXC_ERROR THEN
1546: x_return_status := FND_API.G_RET_STS_ERROR;
1547:
1548: IF p_caller <> 'UI_ACTION' AND
1549: p_caller <> 'SCHEDULE_ATO'
1550: THEN

Line 1562: --RAISE FND_API.G_EXC_ERROR;

1558: END IF;
1559: END IF;
1560:
1561: -- do not raise, caller wants to handle: sets
1562: --RAISE FND_API.G_EXC_ERROR;
1563:
1564: WHEN OTHERS THEN
1565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1566: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

Line 1565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1561: -- do not raise, caller wants to handle: sets
1562: --RAISE FND_API.G_EXC_ERROR;
1563:
1564: WHEN OTHERS THEN
1565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1566: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1567: THEN
1568: OE_MSG_PUB.Add_Exc_Msg
1569: ( G_PKG_NAME

Line 1573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1569: ( G_PKG_NAME
1570: ,'Process_Group'
1571: );
1572: END IF;
1573: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1574:
1575: END Process_Group;
1576:
1577:

Line 1618: x_return_status := FND_API.G_RET_STS_SUCCESS;

1614: BEGIN
1615:
1616: Print_Time('entering Call_Mrp');
1617:
1618: x_return_status := FND_API.G_RET_STS_SUCCESS;
1619:
1620: OE_Schedule_Util.Load_MRP_request_from_tbl
1621: ( p_line_tbl => p_x_line_tbl
1622: ,p_old_line_tbl => p_old_line_tbl

Line 1660: IF x_return_status = FND_API.G_RET_STS_ERROR THEN

1656: l_mrp_called := TRUE;
1657:
1658: Print_Time('After MRPs ATP API: ' || x_return_status);
1659:
1660: IF x_return_status = FND_API.G_RET_STS_ERROR THEN
1661:
1662: OE_SCHEDULE_UTIL.Display_sch_errors
1663: (p_atp_rec => l_out_mtp_atp_rec,
1664: p_line_tbl => p_x_line_tbl);

Line 1670: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN

1666: END IF;
1667:
1668: END IF; -- Moved for 1955004
1669:
1670: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
1671: -- the call to MRP was successful, so load the results
1672:
1673: IF l_debug_level > 0 THEN
1674: oe_debug_pub.add( 'CALLING LOAD_RESULTS' , 1 ) ;

Line 1727: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1723:
1724: OE_SCHEDULE_UTIL.OE_inactive_demand_tbl.DELETE
1725: (p_x_line_tbl(I).line_id);
1726:
1727: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1729: END IF;
1730:
1731: ELSE

Line 1728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1724: OE_SCHEDULE_UTIL.OE_inactive_demand_tbl.DELETE
1725: (p_x_line_tbl(I).line_id);
1726:
1727: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1729: END IF;
1730:
1731: ELSE
1732: -- this row must have been a part of the Call_ATP call that

Line 1745: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1741: END IF;
1742:
1743: END IF;
1744:
1745: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1747: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1748: RAISE FND_API.G_EXC_ERROR;
1749: END IF;

Line 1746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1742:
1743: END IF;
1744:
1745: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1747: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1748: RAISE FND_API.G_EXC_ERROR;
1749: END IF;
1750:

Line 1747: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

1743: END IF;
1744:
1745: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1747: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1748: RAISE FND_API.G_EXC_ERROR;
1749: END IF;
1750:
1751: Print_Time('leaving Call_Mrp');

Line 1748: RAISE FND_API.G_EXC_ERROR;

1744:
1745: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1746: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1747: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
1748: RAISE FND_API.G_EXC_ERROR;
1749: END IF;
1750:
1751: Print_Time('leaving Call_Mrp');
1752:

Line 1820: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1816: ,p_quantity2_to_unreserve => nvl(p_line_tbl(I).reserved_quantity2, 0) -- INVCONV
1817: ,x_return_status => l_return_status);
1818: END IF; -- 2595661
1819:
1820: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1822: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1823: RAISE FND_API.G_EXC_ERROR;
1824: END IF;

Line 1821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1817: ,x_return_status => l_return_status);
1818: END IF; -- 2595661
1819:
1820: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1822: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1823: RAISE FND_API.G_EXC_ERROR;
1824: END IF;
1825:

Line 1822: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1818: END IF; -- 2595661
1819:
1820: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1822: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1823: RAISE FND_API.G_EXC_ERROR;
1824: END IF;
1825:
1826: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESCHEDULE THEN

Line 1823: RAISE FND_API.G_EXC_ERROR;

1819:
1820: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1821: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1822: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1823: RAISE FND_API.G_EXC_ERROR;
1824: END IF;
1825:
1826: IF p_sch_action = OE_Schedule_Util.OESCH_ACT_RESCHEDULE THEN
1827:

Line 2061: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2057: ,p_quantity2_to_Reserve => p_x_line_tbl(I).reserved_quantity2 -- INVCONV
2058: ,p_rsv_update => l_rsv_update
2059: ,x_return_status => l_return_status);
2060:
2061: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2063: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2064: IF l_debug_level > 0 THEN
2065: oe_debug_pub.add( 'RESERVE LINE EXPECTED ERROR , IGNORE' , 1 ) ;

Line 2062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2058: ,p_rsv_update => l_rsv_update
2059: ,x_return_status => l_return_status);
2060:
2061: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2063: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2064: IF l_debug_level > 0 THEN
2065: oe_debug_pub.add( 'RESERVE LINE EXPECTED ERROR , IGNORE' , 1 ) ;
2066: END IF;

Line 2063: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2059: ,x_return_status => l_return_status);
2060:
2061: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2063: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2064: IF l_debug_level > 0 THEN
2065: oe_debug_pub.add( 'RESERVE LINE EXPECTED ERROR , IGNORE' , 1 ) ;
2066: END IF;
2067: END IF;

Line 2191: ,p_post_process IN VARCHAR2 DEFAULT FND_API.G_FALSE

2187: -----------------------------------------------------------------*/
2188: PROCEDURE Handle_Unreserve
2189: ( p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
2190: ,p_old_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_Tbl_Type
2191: ,p_post_process IN VARCHAR2 DEFAULT FND_API.G_FALSE
2192: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2)
2193: IS
2194: l_qty NUMBER;
2195: l_qty2 NUMBER; -- INVCONV

Line 2204: IF p_post_process = FND_API.G_TRUE THEN

2200: BEGIN
2201:
2202: Print_Time('entering Handle_Unreserve');
2203:
2204: IF p_post_process = FND_API.G_TRUE THEN
2205:
2206: IF l_debug_level > 0 THEN
2207: oe_debug_pub.add( 'ENTERING POST PROCESS' , 1 ) ;
2208: END IF;

Line 2342: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2338: ,p_sch_action => p_request_rec.param1
2339: ,x_return_status => l_return_status);
2340:
2341:
2342: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2344: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2345: RAISE FND_API.G_EXC_ERROR;
2346: END IF;

Line 2343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2339: ,x_return_status => l_return_status);
2340:
2341:
2342: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2344: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2345: RAISE FND_API.G_EXC_ERROR;
2346: END IF;
2347: */

Line 2344: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2340:
2341:
2342: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2344: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2345: RAISE FND_API.G_EXC_ERROR;
2346: END IF;
2347: */
2348: IF l_debug_level > 0 THEN

Line 2345: RAISE FND_API.G_EXC_ERROR;

2341:
2342: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2343: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2344: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2345: RAISE FND_API.G_EXC_ERROR;
2346: END IF;
2347: */
2348: IF l_debug_level > 0 THEN
2349: oe_debug_pub.add( '-------ENTITY ' || P_REQUEST_REC.ENTITY_ID , 4 ) ;

Line 2383: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2379: ,p_sch_action => p_request_rec.param1
2380: ,x_return_status => l_return_status);
2381:
2382:
2383: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2384: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2385: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2386: RAISE FND_API.G_EXC_ERROR;
2387: END IF;

Line 2384: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2380: ,x_return_status => l_return_status);
2381:
2382:
2383: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2384: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2385: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2386: RAISE FND_API.G_EXC_ERROR;
2387: END IF;
2388:

Line 2385: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2381:
2382:
2383: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2384: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2385: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2386: RAISE FND_API.G_EXC_ERROR;
2387: END IF;
2388:
2389: IF p_request_rec.request_type <> OE_GLOBALS.G_SCHEDULE_NONSMC

Line 2386: RAISE FND_API.G_EXC_ERROR;

2382:
2383: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2384: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2385: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2386: RAISE FND_API.G_EXC_ERROR;
2387: END IF;
2388:
2389: IF p_request_rec.request_type <> OE_GLOBALS.G_SCHEDULE_NONSMC
2390: AND NOT (p_request_rec.request_type = OE_GLOBALS.G_SCHEDULE_ATO

Line 2551: x_return_status := FND_API.G_RET_STS_SUCCESS;

2547: IF l_debug_level > 0 THEN
2548: oe_debug_pub.add( 'ENTERING SAVE_SCH '|| P_X_LINE_TBL.COUNT , 1 ) ;
2549: END IF;
2550:
2551: x_return_status := FND_API.G_RET_STS_SUCCESS;
2552:
2553: /*Initiliazed the x_return_status for bug 7555835. Since x_return_status is not initialized
2554: in the begining of the API,In certain flows, like when only schedule ship date is changed,
2555: it is not getting initialized at all. Due to this, this API is returning return status as null.

Line 2913: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2909: , p_request_type => OE_GLOBALS.G_UPDATE_REQUISITION
2910: , x_return_status => l_return_status
2911: );
2912:
2913: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2915: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2916: RAISE FND_API.G_EXC_ERROR;
2917: END IF;

Line 2914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2910: , x_return_status => l_return_status
2911: );
2912:
2913: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2915: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2916: RAISE FND_API.G_EXC_ERROR;
2917: END IF;
2918:

Line 2915: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

2911: );
2912:
2913: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2915: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2916: RAISE FND_API.G_EXC_ERROR;
2917: END IF;
2918:
2919:

Line 2916: RAISE FND_API.G_EXC_ERROR;

2912:
2913: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2914: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2915: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
2916: RAISE FND_API.G_EXC_ERROR;
2917: END IF;
2918:
2919:
2920: ELSE -- Added for IR ISO Tracking bug 7667702

Line 2979: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2975: ,p_control_rec => l_control_rec
2976: ,p_caller => p_caller
2977: ,x_return_status => x_return_status);
2978:
2979: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2981: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2982: RAISE FND_API.G_EXC_ERROR;
2983: END IF;

Line 2980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2976: ,p_caller => p_caller
2977: ,x_return_status => x_return_status);
2978:
2979: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2981: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2982: RAISE FND_API.G_EXC_ERROR;
2983: END IF;
2984:

Line 2981: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

2977: ,x_return_status => x_return_status);
2978:
2979: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2981: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2982: RAISE FND_API.G_EXC_ERROR;
2983: END IF;
2984:
2985: IF p_caller = OE_Schedule_Util.SCH_INTERNAL THEN

Line 2982: RAISE FND_API.G_EXC_ERROR;

2978:
2979: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2980: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2981: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
2982: RAISE FND_API.G_EXC_ERROR;
2983: END IF;
2984:
2985: IF p_caller = OE_Schedule_Util.SCH_INTERNAL THEN
2986: l_process_requests := FALSE;

Line 3002: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2998: IF l_debug_level > 0 THEN
2999: oe_debug_pub.add( 'PRN RETURN_STATUS ' || X_RETURN_STATUS , 1 ) ;
3000: END IF;
3001:
3002: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3004: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3005: RAISE FND_API.G_EXC_ERROR;
3006: END IF;

Line 3003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2999: oe_debug_pub.add( 'PRN RETURN_STATUS ' || X_RETURN_STATUS , 1 ) ;
3000: END IF;
3001:
3002: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3004: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3005: RAISE FND_API.G_EXC_ERROR;
3006: END IF;
3007:

Line 3004: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

3000: END IF;
3001:
3002: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3004: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3005: RAISE FND_API.G_EXC_ERROR;
3006: END IF;
3007:
3008: END IF;

Line 3005: RAISE FND_API.G_EXC_ERROR;

3001:
3002: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3003: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3004: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3005: RAISE FND_API.G_EXC_ERROR;
3006: END IF;
3007:
3008: END IF;
3009:

Line 3055: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3051: ,p_old_line_rec => p_old_line_rec
3052: ,x_result => l_sec_result
3053: ,x_return_status => l_return_status );
3054:
3055: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3057: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3058: RAISE FND_API.G_EXC_ERROR;
3059: END IF;

Line 3056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3052: ,x_result => l_sec_result
3053: ,x_return_status => l_return_status );
3054:
3055: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3057: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3058: RAISE FND_API.G_EXC_ERROR;
3059: END IF;
3060:

Line 3057: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3053: ,x_return_status => l_return_status );
3054:
3055: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3057: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3058: RAISE FND_API.G_EXC_ERROR;
3059: END IF;
3060:
3061: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';

Line 3058: RAISE FND_API.G_EXC_ERROR;

3054:
3055: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3056: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3057: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3058: RAISE FND_API.G_EXC_ERROR;
3059: END IF;
3060:
3061: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
3062: IF l_debug_level > 0 THEN

Line 3071: RAISE FND_API.G_EXC_ERROR;

3067: IF l_sec_result = OE_PC_GLOBALS.YES THEN
3068: IF l_debug_level > 0 THEN
3069: oe_debug_pub.add( 'CONSTRAINT FOUND' , 4 ) ;
3070: END IF;
3071: RAISE FND_API.G_EXC_ERROR;
3072: END IF;
3073:
3074:
3075: IF NOT OE_GLOBALS.Equal(p_x_line_rec.ship_from_org_id,

Line 3180: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3176: IF l_debug_level > 0 THEN
3177: oe_debug_pub.add( 'AFTER LOG_SCHEDULING REQS' || L_RETURN_STATUS , 1 ) ;
3178: END IF;
3179:
3180: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3182: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3183: RAISE FND_API.G_EXC_ERROR;
3184: END IF;

Line 3181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3177: oe_debug_pub.add( 'AFTER LOG_SCHEDULING REQS' || L_RETURN_STATUS , 1 ) ;
3178: END IF;
3179:
3180: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3182: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3183: RAISE FND_API.G_EXC_ERROR;
3184: END IF;
3185:

Line 3182: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3178: END IF;
3179:
3180: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3182: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3183: RAISE FND_API.G_EXC_ERROR;
3184: END IF;
3185:
3186: IF l_debug_level > 0 THEN

Line 3183: RAISE FND_API.G_EXC_ERROR;

3179:
3180: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3182: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3183: RAISE FND_API.G_EXC_ERROR;
3184: END IF;
3185:
3186: IF l_debug_level > 0 THEN
3187: oe_debug_pub.add( 'BEFORE DOING DIRECT UPDATE' , 1 ) ;

Line 3201: AND p_x_line_rec.shipping_method_code <> FND_API.G_MISS_CHAR)

3197: END IF;
3198:
3199: -- Start 2806483
3200: IF (p_x_line_rec.shipping_method_code IS NOT NULL
3201: AND p_x_line_rec.shipping_method_code <> FND_API.G_MISS_CHAR)
3202: AND NOT OE_GLOBALS.EQUAL(p_x_line_rec.shipping_method_code
3203: ,p_old_line_rec.shipping_method_code)
3204: THEN
3205:

Line 3256: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3252: oe_debug_pub.add( 'UPDATE_GLOBAL RETURN STATUS FROM OE_SCHEDULE_UTIL.PROCESS_LINE IS: ' || L_RETURN_STATUS ) ;
3253: oe_debug_pub.add( 'GLOBAL PICTURE INDEX IS: ' || L_INDEX , 1 ) ;
3254: END IF;
3255:
3256: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3257: IF l_debug_level > 0 THEN
3258: oe_debug_pub.add( 'RR: UNEXP ERRORED OUT' , 1 ) ;
3259: END IF;
3260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 3260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3256: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3257: IF l_debug_level > 0 THEN
3258: oe_debug_pub.add( 'RR: UNEXP ERRORED OUT' , 1 ) ;
3259: END IF;
3260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3261: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3262: IF l_debug_level > 0 THEN
3263: oe_debug_pub.add( 'RR: ERRORED OUT' , 1 ) ;
3264: END IF;

Line 3261: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3257: IF l_debug_level > 0 THEN
3258: oe_debug_pub.add( 'RR: UNEXP ERRORED OUT' , 1 ) ;
3259: END IF;
3260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3261: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3262: IF l_debug_level > 0 THEN
3263: oe_debug_pub.add( 'RR: ERRORED OUT' , 1 ) ;
3264: END IF;
3265: RAISE FND_API.G_EXC_ERROR;

Line 3265: RAISE FND_API.G_EXC_ERROR;

3261: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3262: IF l_debug_level > 0 THEN
3263: oe_debug_pub.add( 'RR: ERRORED OUT' , 1 ) ;
3264: END IF;
3265: RAISE FND_API.G_EXC_ERROR;
3266: END IF;
3267: IF l_index is not NULL THEN
3268: --update Global Picture directly
3269: OE_ORDER_UTIL.g_line_tbl(l_index).ship_from_org_id := p_x_line_rec.ship_from_org_id;

Line 3330: x_return_status := FND_API.G_RET_STS_SUCCESS;

3326: --
3327: BEGIN
3328: Print_Time('entering Update_Reservation');
3329:
3330: x_return_status := FND_API.G_RET_STS_SUCCESS;
3331:
3332: IF OE_GLOBALS.Equal(p_line_rec.schedule_ship_date,
3333: p_old_line_rec.schedule_ship_date) OR
3334: p_line_rec.schedule_ship_date IS NULL OR -- bug 3542464

Line 3344: l_rsv_rec.reservation_id := fnd_api.g_miss_num;

3340: END IF;
3341: RETURN;
3342: END IF;
3343:
3344: l_rsv_rec.reservation_id := fnd_api.g_miss_num;
3345:
3346: l_sales_order_id := OE_SCHEDULE_UTIL.Get_mtl_sales_order_id
3347: (p_line_rec.header_id);
3348:

Line 3359: , p_init_msg_lst => fnd_api.g_true

3355: END IF;
3356:
3357: Inv_Reservation_Pub.Query_Reservation
3358: ( p_api_version_number => 1.0
3359: , p_init_msg_lst => fnd_api.g_true
3360: , x_return_status => x_return_status
3361: , x_msg_count => l_msg_count
3362: , x_msg_data => l_msg_data
3363: , p_query_input => l_rsv_rec

Line 3374: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3370: IF l_debug_level > 0 THEN
3371: oe_debug_pub.add( 'AFTER INVS QUERY_RESERVATION: ' || X_RETURN_STATUS , 1 ) ;
3372: END IF;
3373:
3374: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3376: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3377: RAISE FND_API.G_EXC_ERROR;
3378: END IF;

Line 3375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3371: oe_debug_pub.add( 'AFTER INVS QUERY_RESERVATION: ' || X_RETURN_STATUS , 1 ) ;
3372: END IF;
3373:
3374: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3376: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3377: RAISE FND_API.G_EXC_ERROR;
3378: END IF;
3379:

Line 3376: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

3372: END IF;
3373:
3374: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3376: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3377: RAISE FND_API.G_EXC_ERROR;
3378: END IF;
3379:
3380: IF l_debug_level > 0 THEN

Line 3377: RAISE FND_API.G_EXC_ERROR;

3373:
3374: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3375: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3376: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3377: RAISE FND_API.G_EXC_ERROR;
3378: END IF;
3379:
3380: IF l_debug_level > 0 THEN
3381: oe_debug_pub.add( 'RESERVATION REC COUNT: ' || L_RSV_TBL.COUNT , 1 ) ;

Line 3397: , p_init_msg_lst => fnd_api.g_true

3393: END IF;
3394:
3395: Inv_Reservation_Pub.Update_Reservation
3396: ( p_api_version_number => 1.0
3397: , p_init_msg_lst => fnd_api.g_true
3398: , x_return_status => x_return_status
3399: , x_msg_count => l_msg_count
3400: , x_msg_data => l_msg_data
3401: , p_original_rsv_rec => l_rsv_tbl(I)

Line 3405: , p_validation_flag => fnd_api.g_true

3401: , p_original_rsv_rec => l_rsv_tbl(I)
3402: , p_to_rsv_rec => l_rsv_rec
3403: , p_original_serial_number => l_dummy_sn -- no serial contorl
3404: , p_to_serial_number => l_dummy_sn -- no serial control
3405: , p_validation_flag => fnd_api.g_true
3406: , p_over_reservation_flag => 2 ); -- Added this for 4715544
3407:
3408: IF l_debug_level > 0 THEN
3409: oe_debug_pub.add( 'AFTER UPDATE_RESERVATION: '||X_RETURN_STATUS , 1 ) ;

Line 3412: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3408: IF l_debug_level > 0 THEN
3409: oe_debug_pub.add( 'AFTER UPDATE_RESERVATION: '||X_RETURN_STATUS , 1 ) ;
3410: END IF;
3411:
3412: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3414:
3415: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3416: IF l_msg_data is not null THEN

Line 3413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3409: oe_debug_pub.add( 'AFTER UPDATE_RESERVATION: '||X_RETURN_STATUS , 1 ) ;
3410: END IF;
3411:
3412: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3414:
3415: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3416: IF l_msg_data is not null THEN
3417:

Line 3415: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN

3411:
3412: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3413: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3414:
3415: ELSIF x_return_status = FND_API.G_RET_STS_ERROR THEN
3416: IF l_msg_data is not null THEN
3417:
3418: OE_MSG_PUB.set_msg_context
3419: ( p_entity_code => 'LINE'

Line 3439: RAISE FND_API.G_EXC_ERROR;

3435: IF l_debug_level > 0 THEN
3436: oe_debug_pub.add( 'ERROR : '|| L_BUFFER , 1 ) ;
3437: END IF;
3438: END IF;
3439: RAISE FND_API.G_EXC_ERROR;
3440: END IF;
3441:
3442: I := l_rsv_tbl.NEXT(I);
3443: END LOOP;

Line 3477: p_ship_set_id IN NUMBER := FND_API.G_MISS_NUM,

3473: selected by 2nd part.
3474: ---------------------------------------------------------------*/
3475: Procedure Query_Set_Lines
3476: (p_header_id IN NUMBER,
3477: p_ship_set_id IN NUMBER := FND_API.G_MISS_NUM,
3478: p_arrival_set_id IN NUMBER := FND_API.G_MISS_NUM,
3479: p_model_line_id IN NUMBER := FND_API.G_MISS_NUM,
3480: p_link_to_line_id IN NUMBER := FND_API.G_MISS_NUM,
3481: p_sch_action IN VARCHAR2,

Line 3478: p_arrival_set_id IN NUMBER := FND_API.G_MISS_NUM,

3474: ---------------------------------------------------------------*/
3475: Procedure Query_Set_Lines
3476: (p_header_id IN NUMBER,
3477: p_ship_set_id IN NUMBER := FND_API.G_MISS_NUM,
3478: p_arrival_set_id IN NUMBER := FND_API.G_MISS_NUM,
3479: p_model_line_id IN NUMBER := FND_API.G_MISS_NUM,
3480: p_link_to_line_id IN NUMBER := FND_API.G_MISS_NUM,
3481: p_sch_action IN VARCHAR2,
3482: p_send_cancel_lines IN VARCHAR2 := 'N',

Line 3479: p_model_line_id IN NUMBER := FND_API.G_MISS_NUM,

3475: Procedure Query_Set_Lines
3476: (p_header_id IN NUMBER,
3477: p_ship_set_id IN NUMBER := FND_API.G_MISS_NUM,
3478: p_arrival_set_id IN NUMBER := FND_API.G_MISS_NUM,
3479: p_model_line_id IN NUMBER := FND_API.G_MISS_NUM,
3480: p_link_to_line_id IN NUMBER := FND_API.G_MISS_NUM,
3481: p_sch_action IN VARCHAR2,
3482: p_send_cancel_lines IN VARCHAR2 := 'N',
3483: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,

Line 3480: p_link_to_line_id IN NUMBER := FND_API.G_MISS_NUM,

3476: (p_header_id IN NUMBER,
3477: p_ship_set_id IN NUMBER := FND_API.G_MISS_NUM,
3478: p_arrival_set_id IN NUMBER := FND_API.G_MISS_NUM,
3479: p_model_line_id IN NUMBER := FND_API.G_MISS_NUM,
3480: p_link_to_line_id IN NUMBER := FND_API.G_MISS_NUM,
3481: p_sch_action IN VARCHAR2,
3482: p_send_cancel_lines IN VARCHAR2 := 'N',
3483: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,
3484: x_return_status OUT NOCOPY VARCHAR2)

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

3483: x_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,
3484: x_return_status OUT NOCOPY VARCHAR2)
3485: IS
3486: l_sales_order_id NUMBER;
3487: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
3488: l_sch_gloabl_value VARCHAR2(1);
3489: I NUMBER;
3490:
3491: CURSOR inc_parents is

Line 3509: x_return_status := FND_API.G_RET_STS_SUCCESS;

3505: --
3506: BEGIN
3507: Print_Time('Entering Query_Set_Lines '|| p_sch_action);
3508:
3509: x_return_status := FND_API.G_RET_STS_SUCCESS;
3510:
3511: IF p_link_to_line_id <> FND_API.G_MISS_NUM AND
3512: (p_ship_set_id <> FND_API.G_MISS_NUM OR
3513: p_arrival_set_id <> FND_API.G_MISS_NUM OR

Line 3511: IF p_link_to_line_id <> FND_API.G_MISS_NUM AND

3507: Print_Time('Entering Query_Set_Lines '|| p_sch_action);
3508:
3509: x_return_status := FND_API.G_RET_STS_SUCCESS;
3510:
3511: IF p_link_to_line_id <> FND_API.G_MISS_NUM AND
3512: (p_ship_set_id <> FND_API.G_MISS_NUM OR
3513: p_arrival_set_id <> FND_API.G_MISS_NUM OR
3514: p_model_line_id <> FND_API.G_MISS_NUM )
3515: THEN

Line 3512: (p_ship_set_id <> FND_API.G_MISS_NUM OR

3508:
3509: x_return_status := FND_API.G_RET_STS_SUCCESS;
3510:
3511: IF p_link_to_line_id <> FND_API.G_MISS_NUM AND
3512: (p_ship_set_id <> FND_API.G_MISS_NUM OR
3513: p_arrival_set_id <> FND_API.G_MISS_NUM OR
3514: p_model_line_id <> FND_API.G_MISS_NUM )
3515: THEN
3516: IF l_debug_level > 0 THEN

Line 3513: p_arrival_set_id <> FND_API.G_MISS_NUM OR

3509: x_return_status := FND_API.G_RET_STS_SUCCESS;
3510:
3511: IF p_link_to_line_id <> FND_API.G_MISS_NUM AND
3512: (p_ship_set_id <> FND_API.G_MISS_NUM OR
3513: p_arrival_set_id <> FND_API.G_MISS_NUM OR
3514: p_model_line_id <> FND_API.G_MISS_NUM )
3515: THEN
3516: IF l_debug_level > 0 THEN
3517: oe_debug_pub.add( 'INCORRECT IN PARAMETERS' , 1 ) ;

Line 3514: p_model_line_id <> FND_API.G_MISS_NUM )

3510:
3511: IF p_link_to_line_id <> FND_API.G_MISS_NUM AND
3512: (p_ship_set_id <> FND_API.G_MISS_NUM OR
3513: p_arrival_set_id <> FND_API.G_MISS_NUM OR
3514: p_model_line_id <> FND_API.G_MISS_NUM )
3515: THEN
3516: IF l_debug_level > 0 THEN
3517: oe_debug_pub.add( 'INCORRECT IN PARAMETERS' , 1 ) ;
3518: END IF;

Line 3519: RAISE FND_API.G_EXC_ERROR;

3515: THEN
3516: IF l_debug_level > 0 THEN
3517: oe_debug_pub.add( 'INCORRECT IN PARAMETERS' , 1 ) ;
3518: END IF;
3519: RAISE FND_API.G_EXC_ERROR;
3520: END IF;
3521:
3522:
3523: IF nvl(p_sch_action, 'A' ) <> OE_Schedule_Util.OESCH_ACT_UNSCHEDULE

Line 3546: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3542: (p_line_id => parentrec.line_id,
3543: p_freeze => FALSE);
3544:
3545:
3546: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3548: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3549: RAISE FND_API.G_EXC_ERROR;
3550: END IF;

Line 3547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3543: p_freeze => FALSE);
3544:
3545:
3546: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3548: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3549: RAISE FND_API.G_EXC_ERROR;
3550: END IF;
3551: END LOOP;

Line 3548: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

3544:
3545:
3546: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3548: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3549: RAISE FND_API.G_EXC_ERROR;
3550: END IF;
3551: END LOOP;
3552:

Line 3549: RAISE FND_API.G_EXC_ERROR;

3545:
3546: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3548: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
3549: RAISE FND_API.G_EXC_ERROR;
3550: END IF;
3551: END LOOP;
3552:
3553: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := l_sch_gloabl_value;

Line 3558: IF p_arrival_set_id <> FND_API.G_MISS_NUM THEN

3554: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
3555: END IF;
3556:
3557:
3558: IF p_arrival_set_id <> FND_API.G_MISS_NUM THEN
3559: IF l_debug_level > 0 THEN
3560: oe_debug_pub.add( 'ARRIVAL SET ID '|| P_ARRIVAL_SET_ID , 3 ) ;
3561: END IF;
3562:

Line 3567: ELSIF p_ship_set_id <> FND_API.G_MISS_NUM THEN

3563: OE_Set_Util.Query_Set_Rows
3564: (p_set_id => p_arrival_set_id,
3565: x_line_tbl => x_line_tbl);
3566:
3567: ELSIF p_ship_set_id <> FND_API.G_MISS_NUM THEN
3568: IF l_debug_level > 0 THEN
3569: oe_debug_pub.add( 'SHIP SET ID '|| P_SHIP_SET_ID , 3 ) ;
3570: END IF;
3571:

Line 3576: ELSIF p_model_line_id <> FND_API.G_MISS_NUM THEN

3572: OE_Set_Util.Query_Set_Rows
3573: (p_set_id => p_ship_set_id,
3574: x_line_tbl => x_line_tbl);
3575:
3576: ELSIF p_model_line_id <> FND_API.G_MISS_NUM THEN
3577: IF l_debug_level > 0 THEN
3578: oe_debug_pub.add( 'P_TOP_MODEL_LINE_ID '|| P_MODEL_LINE_ID , 3 ) ;
3579: END IF;
3580:

Line 3587: ELSIF p_link_to_line_id <> FND_API.G_MISS_NUM THEN

3583: p_send_cancel_lines => p_send_cancel_lines,
3584: p_source_type => OE_Globals.G_SOURCE_INTERNAL,
3585: x_line_tbl => x_line_tbl);
3586:
3587: ELSIF p_link_to_line_id <> FND_API.G_MISS_NUM THEN
3588: IF l_debug_level > 0 THEN
3589: oe_debug_pub.add( 'P_LINK_TO_LINE_ID '|| P_LINK_TO_LINE_ID , 3 ) ;
3590: END IF;
3591:

Line 3637: x_line_tbl(I).reserved_quantity = FND_API.G_MISS_NUM

3633: END IF;
3634:
3635:
3636: IF x_line_tbl(I).reserved_quantity is NULL OR
3637: x_line_tbl(I).reserved_quantity = FND_API.G_MISS_NUM
3638: THEN
3639: x_line_tbl(I).reserved_quantity := 0;
3640: ELSE
3641: IF l_debug_level > 0 THEN

Line 3650: x_line_tbl(I).reserved_quantity2 = FND_API.G_MISS_NUM

3646: END IF;
3647: END IF;
3648:
3649: IF x_line_tbl(I).reserved_quantity2 is NULL OR -- INVCONV
3650: x_line_tbl(I).reserved_quantity2 = FND_API.G_MISS_NUM
3651: THEN
3652: x_line_tbl(I).reserved_quantity2 := 0;
3653: ELSE
3654: IF l_debug_level > 0 THEN

Line 3669: WHEN FND_API.G_EXC_ERROR THEN

3665: Print_Time('Exiting Query_Set_Lines');
3666:
3667: EXCEPTION
3668:
3669: WHEN FND_API.G_EXC_ERROR THEN
3670: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
3671: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
3672: IF l_debug_level > 0 THEN
3673: oe_debug_pub.add( 'EXC ERROR IN Query_Set_Lines' , 1 ) ;

Line 3675: x_return_status := FND_API.G_RET_STS_ERROR;

3671: OE_ORDER_SCH_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';
3672: IF l_debug_level > 0 THEN
3673: oe_debug_pub.add( 'EXC ERROR IN Query_Set_Lines' , 1 ) ;
3674: END IF;
3675: x_return_status := FND_API.G_RET_STS_ERROR;
3676:
3677: WHEN OTHERS THEN
3678:
3679: OE_SCHEDULE_UTIL.OESCH_PERFORM_SCHEDULING := 'Y';

Line 3689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3685: ( G_PKG_NAME
3686: ,'Query_Set_Lines'
3687: );
3688: END IF;
3689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3691:
3692: END Query_Set_Lines;
3693:

Line 3690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3686: ,'Query_Set_Lines'
3687: );
3688: END IF;
3689: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3690: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3691:
3692: END Query_Set_Lines;
3693:
3694:

Line 3844: x_return_status := FND_API.G_RET_STS_ERROR;

3840: THEN
3841:
3842: FND_MESSAGE.SET_NAME('ONT','OE_SCH_ATO_WHSE_REQD');
3843: OE_MSG_PUB.Add;
3844: x_return_status := FND_API.G_RET_STS_ERROR;
3845:
3846: RETURN;
3847:
3848: END IF;

Line 3857: x_return_status := FND_API.G_RET_STS_ERROR;

3853: THEN
3854:
3855: FND_MESSAGE.SET_NAME('ONT','OE_SCH_RES_NO_CONFIG');
3856: OE_MSG_PUB.Add;
3857: x_return_status := FND_API.G_RET_STS_ERROR;
3858:
3859: RETURN;
3860:
3861: END IF;