DBA Data[Home] [Help]

APPS.MRP_VALIDATE_FLOW_SCHEDULE dependencies on MRP_VALIDATE

Line 1: PACKAGE BODY MRP_Validate_Flow_Schedule AS

1: PACKAGE BODY MRP_Validate_Flow_Schedule AS
2: /* $Header: MRPLSCNB.pls 120.0 2005/05/27 11:12:39 appldev noship $ */
3:
4: -- Global constant holding the package name
5:

Line 6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MRP_Validate_Flow_Schedule';

2: /* $Header: MRPLSCNB.pls 120.0 2005/05/27 11:12:39 appldev noship $ */
3:
4: -- Global constant holding the package name
5:
6: G_PKG_NAME CONSTANT VARCHAR2(30) := 'MRP_Validate_Flow_Schedule';
7:
8: -- Procedure Entity
9:
10: PROCEDURE Entity

Line 946: IF NOT MRP_Validate.Alternate_Bom_Designator(l_flow_schedule_rec.alternate_bom_designator) THEN

942: ( l_flow_schedule_rec.alternate_bom_designator <>
943: p_old_flow_schedule_rec.alternate_bom_designator OR
944: p_old_flow_schedule_rec.alternate_bom_designator IS NULL )
945: THEN
946: IF NOT MRP_Validate.Alternate_Bom_Designator(l_flow_schedule_rec.alternate_bom_designator) THEN
947: x_return_status := FND_API.G_RET_STS_ERROR;
948: END IF;
949: END IF;
950:

Line 956: IF NOT MRP_Validate.Alternate_Routing_Desig(l_flow_schedule_rec.alternate_routing_desig) THEN

952: ( l_flow_schedule_rec.alternate_routing_desig <>
953: p_old_flow_schedule_rec.alternate_routing_desig OR
954: p_old_flow_schedule_rec.alternate_routing_desig IS NULL )
955: THEN
956: IF NOT MRP_Validate.Alternate_Routing_Desig(l_flow_schedule_rec.alternate_routing_desig) THEN
957: x_return_status := FND_API.G_RET_STS_ERROR;
958: END IF;
959: END IF;
960:

Line 966: IF NOT MRP_Validate.Bom_Revision(l_flow_schedule_rec.bom_revision) THEN

962: ( l_flow_schedule_rec.bom_revision <>
963: p_old_flow_schedule_rec.bom_revision OR
964: p_old_flow_schedule_rec.bom_revision IS NULL )
965: THEN
966: IF NOT MRP_Validate.Bom_Revision(l_flow_schedule_rec.bom_revision) THEN
967: x_return_status := FND_API.G_RET_STS_ERROR;
968: END IF;
969: END IF;
970:

Line 976: IF NOT MRP_Validate.Bom_Revision_Date(l_flow_schedule_rec.bom_revision_date) THEN

972: ( l_flow_schedule_rec.bom_revision_date <>
973: p_old_flow_schedule_rec.bom_revision_date OR
974: p_old_flow_schedule_rec.bom_revision_date IS NULL )
975: THEN
976: IF NOT MRP_Validate.Bom_Revision_Date(l_flow_schedule_rec.bom_revision_date) THEN
977: x_return_status := FND_API.G_RET_STS_ERROR;
978: END IF;
979: END IF;
980:

Line 986: IF NOT MRP_Validate.Build_Sequence(l_flow_schedule_rec.build_sequence) THEN

982: ( l_flow_schedule_rec.build_sequence <>
983: p_old_flow_schedule_rec.build_sequence OR
984: p_old_flow_schedule_rec.build_sequence IS NULL )
985: THEN
986: IF NOT MRP_Validate.Build_Sequence(l_flow_schedule_rec.build_sequence) THEN
987: x_return_status := FND_API.G_RET_STS_ERROR;
988: END IF;
989: END IF;
990:

Line 996: IF NOT MRP_Validate.Class(l_flow_schedule_rec.class_code) THEN

992: ( l_flow_schedule_rec.class_code <>
993: p_old_flow_schedule_rec.class_code OR
994: p_old_flow_schedule_rec.class_code IS NULL )
995: THEN
996: IF NOT MRP_Validate.Class(l_flow_schedule_rec.class_code) THEN
997: x_return_status := FND_API.G_RET_STS_ERROR;
998: END IF;
999: END IF;
1000:

Line 1006: IF NOT MRP_Validate.Completion_Locator(l_flow_schedule_rec.completion_locator_id) THEN

1002: ( l_flow_schedule_rec.completion_locator_id <>
1003: p_old_flow_schedule_rec.completion_locator_id OR
1004: p_old_flow_schedule_rec.completion_locator_id IS NULL )
1005: THEN
1006: IF NOT MRP_Validate.Completion_Locator(l_flow_schedule_rec.completion_locator_id) THEN
1007: x_return_status := FND_API.G_RET_STS_ERROR;
1008: END IF;
1009: END IF;
1010:

Line 1016: IF NOT MRP_Validate.Completion_Subinventory(l_flow_schedule_rec.completion_subinventory) THEN

1012: ( l_flow_schedule_rec.completion_subinventory <>
1013: p_old_flow_schedule_rec.completion_subinventory OR
1014: p_old_flow_schedule_rec.completion_subinventory IS NULL )
1015: THEN
1016: IF NOT MRP_Validate.Completion_Subinventory(l_flow_schedule_rec.completion_subinventory) THEN
1017: x_return_status := FND_API.G_RET_STS_ERROR;
1018: END IF;
1019: END IF;
1020:

Line 1026: IF NOT MRP_Validate.Created_By(l_flow_schedule_rec.created_by) THEN

1022: ( l_flow_schedule_rec.created_by <>
1023: p_old_flow_schedule_rec.created_by OR
1024: p_old_flow_schedule_rec.created_by IS NULL )
1025: THEN
1026: IF NOT MRP_Validate.Created_By(l_flow_schedule_rec.created_by) THEN
1027: x_return_status := FND_API.G_RET_STS_ERROR;
1028: END IF;
1029: END IF;
1030:

Line 1036: IF NOT MRP_Validate.Creation_Date(l_flow_schedule_rec.creation_date) THEN

1032: ( l_flow_schedule_rec.creation_date <>
1033: p_old_flow_schedule_rec.creation_date OR
1034: p_old_flow_schedule_rec.creation_date IS NULL )
1035: THEN
1036: IF NOT MRP_Validate.Creation_Date(l_flow_schedule_rec.creation_date) THEN
1037: x_return_status := FND_API.G_RET_STS_ERROR;
1038: END IF;
1039: END IF;
1040:

Line 1046: IF NOT MRP_Validate.Date_Closed(l_flow_schedule_rec.date_closed) THEN

1042: ( l_flow_schedule_rec.date_closed <>
1043: p_old_flow_schedule_rec.date_closed OR
1044: p_old_flow_schedule_rec.date_closed IS NULL )
1045: THEN
1046: IF NOT MRP_Validate.Date_Closed(l_flow_schedule_rec.date_closed) THEN
1047: x_return_status := FND_API.G_RET_STS_ERROR;
1048: END IF;
1049: END IF;
1050:

Line 1056: IF NOT MRP_Validate.Demand_Class(l_flow_schedule_rec.demand_class) THEN

1052: ( l_flow_schedule_rec.demand_class <>
1053: p_old_flow_schedule_rec.demand_class OR
1054: p_old_flow_schedule_rec.demand_class IS NULL )
1055: THEN
1056: IF NOT MRP_Validate.Demand_Class(l_flow_schedule_rec.demand_class) THEN
1057: x_return_status := FND_API.G_RET_STS_ERROR;
1058: END IF;
1059: END IF;
1060:

Line 1066: IF NOT MRP_Validate.Demand_Source_Delivery(l_flow_schedule_rec.demand_source_delivery) THEN

1062: ( l_flow_schedule_rec.demand_source_delivery <>
1063: p_old_flow_schedule_rec.demand_source_delivery OR
1064: p_old_flow_schedule_rec.demand_source_delivery IS NULL )
1065: THEN
1066: IF NOT MRP_Validate.Demand_Source_Delivery(l_flow_schedule_rec.demand_source_delivery) THEN
1067: x_return_status := FND_API.G_RET_STS_ERROR;
1068: END IF;
1069: END IF;
1070:

Line 1076: IF NOT MRP_Validate.Demand_Source_Header(l_flow_schedule_rec.demand_source_header_id) THEN

1072: ( l_flow_schedule_rec.demand_source_header_id <>
1073: p_old_flow_schedule_rec.demand_source_header_id OR
1074: p_old_flow_schedule_rec.demand_source_header_id IS NULL )
1075: THEN
1076: IF NOT MRP_Validate.Demand_Source_Header(l_flow_schedule_rec.demand_source_header_id) THEN
1077: x_return_status := FND_API.G_RET_STS_ERROR;
1078: END IF;
1079: END IF;
1080:

Line 1086: IF NOT MRP_Validate.Demand_Source_Line(l_flow_schedule_rec.demand_source_line) THEN

1082: ( l_flow_schedule_rec.demand_source_line <>
1083: p_old_flow_schedule_rec.demand_source_line OR
1084: p_old_flow_schedule_rec.demand_source_line IS NULL )
1085: THEN
1086: IF NOT MRP_Validate.Demand_Source_Line(l_flow_schedule_rec.demand_source_line) THEN
1087: x_return_status := FND_API.G_RET_STS_ERROR;
1088: END IF;
1089: END IF;
1090:

Line 1096: IF NOT MRP_Validate.Demand_Source_Type(l_flow_schedule_rec.demand_source_type) THEN

1092: ( l_flow_schedule_rec.demand_source_type <>
1093: p_old_flow_schedule_rec.demand_source_type OR
1094: p_old_flow_schedule_rec.demand_source_type IS NULL )
1095: THEN
1096: IF NOT MRP_Validate.Demand_Source_Type(l_flow_schedule_rec.demand_source_type) THEN
1097: x_return_status := FND_API.G_RET_STS_ERROR;
1098: END IF;
1099: END IF;
1100:

Line 1106: IF NOT MRP_Validate.Last_Updated_By(l_flow_schedule_rec.last_updated_by) THEN

1102: ( l_flow_schedule_rec.last_updated_by <>
1103: p_old_flow_schedule_rec.last_updated_by OR
1104: p_old_flow_schedule_rec.last_updated_by IS NULL )
1105: THEN
1106: IF NOT MRP_Validate.Last_Updated_By(l_flow_schedule_rec.last_updated_by) THEN
1107: x_return_status := FND_API.G_RET_STS_ERROR;
1108: END IF;
1109: END IF;
1110:

Line 1116: IF NOT MRP_Validate.Last_Update_Date(l_flow_schedule_rec.last_update_date) THEN

1112: ( l_flow_schedule_rec.last_update_date <>
1113: p_old_flow_schedule_rec.last_update_date OR
1114: p_old_flow_schedule_rec.last_update_date IS NULL )
1115: THEN
1116: IF NOT MRP_Validate.Last_Update_Date(l_flow_schedule_rec.last_update_date) THEN
1117: x_return_status := FND_API.G_RET_STS_ERROR;
1118: END IF;
1119: END IF;
1120:

Line 1126: IF NOT MRP_Validate.Last_Update_Login(l_flow_schedule_rec.last_update_login) THEN

1122: ( l_flow_schedule_rec.last_update_login <>
1123: p_old_flow_schedule_rec.last_update_login OR
1124: p_old_flow_schedule_rec.last_update_login IS NULL )
1125: THEN
1126: IF NOT MRP_Validate.Last_Update_Login(l_flow_schedule_rec.last_update_login) THEN
1127: x_return_status := FND_API.G_RET_STS_ERROR;
1128: END IF;
1129: END IF;
1130:

Line 1136: IF NOT MRP_Validate.Line(l_flow_schedule_rec.line_id) THEN

1132: ( l_flow_schedule_rec.line_id <>
1133: p_old_flow_schedule_rec.line_id OR
1134: p_old_flow_schedule_rec.line_id IS NULL )
1135: THEN
1136: IF NOT MRP_Validate.Line(l_flow_schedule_rec.line_id) THEN
1137: x_return_status := FND_API.G_RET_STS_ERROR;
1138: END IF;
1139: END IF;
1140:

Line 1146: IF NOT MRP_Validate.Material_Account(l_flow_schedule_rec.material_account) THEN

1142: ( l_flow_schedule_rec.material_account <>
1143: p_old_flow_schedule_rec.material_account OR
1144: p_old_flow_schedule_rec.material_account IS NULL )
1145: THEN
1146: IF NOT MRP_Validate.Material_Account(l_flow_schedule_rec.material_account) THEN
1147: x_return_status := FND_API.G_RET_STS_ERROR;
1148: END IF;
1149: END IF;
1150:

Line 1156: IF NOT MRP_Validate.Material_Overhead_Account(l_flow_schedule_rec.material_overhead_account) THEN

1152: ( l_flow_schedule_rec.material_overhead_account <>
1153: p_old_flow_schedule_rec.material_overhead_account OR
1154: p_old_flow_schedule_rec.material_overhead_account IS NULL )
1155: THEN
1156: IF NOT MRP_Validate.Material_Overhead_Account(l_flow_schedule_rec.material_overhead_account) THEN
1157: x_return_status := FND_API.G_RET_STS_ERROR;
1158: END IF;
1159: END IF;
1160:

Line 1166: IF NOT MRP_Validate.Material_Variance_Account(l_flow_schedule_rec.material_variance_account) THEN

1162: ( l_flow_schedule_rec.material_variance_account <>
1163: p_old_flow_schedule_rec.material_variance_account OR
1164: p_old_flow_schedule_rec.material_variance_account IS NULL )
1165: THEN
1166: IF NOT MRP_Validate.Material_Variance_Account(l_flow_schedule_rec.material_variance_account) THEN
1167: x_return_status := FND_API.G_RET_STS_ERROR;
1168: END IF;
1169: END IF;
1170:

Line 1176: IF NOT MRP_Validate.Mps_Net_Quantity(l_flow_schedule_rec.mps_net_quantity) THEN

1172: ( l_flow_schedule_rec.mps_net_quantity <>
1173: p_old_flow_schedule_rec.mps_net_quantity OR
1174: p_old_flow_schedule_rec.mps_net_quantity IS NULL )
1175: THEN
1176: IF NOT MRP_Validate.Mps_Net_Quantity(l_flow_schedule_rec.mps_net_quantity) THEN
1177: x_return_status := FND_API.G_RET_STS_ERROR;
1178: END IF;
1179: END IF;
1180:

Line 1186: IF NOT MRP_Validate.Mps_Scheduled_Comp_Date(l_flow_schedule_rec.mps_scheduled_comp_date) THEN

1182: ( l_flow_schedule_rec.mps_scheduled_comp_date <>
1183: p_old_flow_schedule_rec.mps_scheduled_comp_date OR
1184: p_old_flow_schedule_rec.mps_scheduled_comp_date IS NULL )
1185: THEN
1186: IF NOT MRP_Validate.Mps_Scheduled_Comp_Date(l_flow_schedule_rec.mps_scheduled_comp_date) THEN
1187: x_return_status := FND_API.G_RET_STS_ERROR;
1188: END IF;
1189: END IF;
1190:

Line 1196: IF NOT MRP_Validate.Organization(l_flow_schedule_rec.organization_id) THEN

1192: ( l_flow_schedule_rec.organization_id <>
1193: p_old_flow_schedule_rec.organization_id OR
1194: p_old_flow_schedule_rec.organization_id IS NULL )
1195: THEN
1196: IF NOT MRP_Validate.Organization(l_flow_schedule_rec.organization_id) THEN
1197: x_return_status := FND_API.G_RET_STS_ERROR;
1198: END IF;
1199: END IF;
1200:

Line 1206: IF NOT MRP_Validate.Outside_Processing_Acct(l_flow_schedule_rec.outside_processing_acct) THEN

1202: ( l_flow_schedule_rec.outside_processing_acct <>
1203: p_old_flow_schedule_rec.outside_processing_acct OR
1204: p_old_flow_schedule_rec.outside_processing_acct IS NULL )
1205: THEN
1206: IF NOT MRP_Validate.Outside_Processing_Acct(l_flow_schedule_rec.outside_processing_acct) THEN
1207: x_return_status := FND_API.G_RET_STS_ERROR;
1208: END IF;
1209: END IF;
1210:

Line 1216: IF NOT MRP_Validate.Outside_Proc_Var_Acct(l_flow_schedule_rec.outside_proc_var_acct) THEN

1212: ( l_flow_schedule_rec.outside_proc_var_acct <>
1213: p_old_flow_schedule_rec.outside_proc_var_acct OR
1214: p_old_flow_schedule_rec.outside_proc_var_acct IS NULL )
1215: THEN
1216: IF NOT MRP_Validate.Outside_Proc_Var_Acct(l_flow_schedule_rec.outside_proc_var_acct) THEN
1217: x_return_status := FND_API.G_RET_STS_ERROR;
1218: END IF;
1219: END IF;
1220:

Line 1226: IF NOT MRP_Validate.Overhead_Account(l_flow_schedule_rec.overhead_account) THEN

1222: ( l_flow_schedule_rec.overhead_account <>
1223: p_old_flow_schedule_rec.overhead_account OR
1224: p_old_flow_schedule_rec.overhead_account IS NULL )
1225: THEN
1226: IF NOT MRP_Validate.Overhead_Account(l_flow_schedule_rec.overhead_account) THEN
1227: x_return_status := FND_API.G_RET_STS_ERROR;
1228: END IF;
1229: END IF;
1230:

Line 1236: IF NOT MRP_Validate.Overhead_Variance_Account(l_flow_schedule_rec.overhead_variance_account) THEN

1232: ( l_flow_schedule_rec.overhead_variance_account <>
1233: p_old_flow_schedule_rec.overhead_variance_account OR
1234: p_old_flow_schedule_rec.overhead_variance_account IS NULL )
1235: THEN
1236: IF NOT MRP_Validate.Overhead_Variance_Account(l_flow_schedule_rec.overhead_variance_account) THEN
1237: x_return_status := FND_API.G_RET_STS_ERROR;
1238: END IF;
1239: END IF;
1240:

Line 1246: IF NOT MRP_Validate.Planned_Quantity(l_flow_schedule_rec.planned_quantity) THEN

1242: ( l_flow_schedule_rec.planned_quantity <>
1243: p_old_flow_schedule_rec.planned_quantity OR
1244: p_old_flow_schedule_rec.planned_quantity IS NULL )
1245: THEN
1246: IF NOT MRP_Validate.Planned_Quantity(l_flow_schedule_rec.planned_quantity) THEN
1247: x_return_status := FND_API.G_RET_STS_ERROR;
1248: END IF;
1249: END IF;
1250:

Line 1256: IF NOT MRP_Validate.Primary_Item(l_flow_schedule_rec.primary_item_id) THEN

1252: ( l_flow_schedule_rec.primary_item_id <>
1253: p_old_flow_schedule_rec.primary_item_id OR
1254: p_old_flow_schedule_rec.primary_item_id IS NULL )
1255: THEN
1256: IF NOT MRP_Validate.Primary_Item(l_flow_schedule_rec.primary_item_id) THEN
1257: x_return_status := FND_API.G_RET_STS_ERROR;
1258: END IF;
1259: END IF;
1260:

Line 1266: IF NOT MRP_Validate.Program_Application(l_flow_schedule_rec.program_application_id) THEN

1262: ( l_flow_schedule_rec.program_application_id <>
1263: p_old_flow_schedule_rec.program_application_id OR
1264: p_old_flow_schedule_rec.program_application_id IS NULL )
1265: THEN
1266: IF NOT MRP_Validate.Program_Application(l_flow_schedule_rec.program_application_id) THEN
1267: x_return_status := FND_API.G_RET_STS_ERROR;
1268: END IF;
1269: END IF;
1270:

Line 1276: IF NOT MRP_Validate.Program(l_flow_schedule_rec.program_id) THEN

1272: ( l_flow_schedule_rec.program_id <>
1273: p_old_flow_schedule_rec.program_id OR
1274: p_old_flow_schedule_rec.program_id IS NULL )
1275: THEN
1276: IF NOT MRP_Validate.Program(l_flow_schedule_rec.program_id) THEN
1277: x_return_status := FND_API.G_RET_STS_ERROR;
1278: END IF;
1279: END IF;
1280:

Line 1286: IF NOT MRP_Validate.Program_Update_Date(l_flow_schedule_rec.program_update_date) THEN

1282: ( l_flow_schedule_rec.program_update_date <>
1283: p_old_flow_schedule_rec.program_update_date OR
1284: p_old_flow_schedule_rec.program_update_date IS NULL )
1285: THEN
1286: IF NOT MRP_Validate.Program_Update_Date(l_flow_schedule_rec.program_update_date) THEN
1287: x_return_status := FND_API.G_RET_STS_ERROR;
1288: END IF;
1289: END IF;
1290:

Line 1296: IF NOT MRP_Validate.Project(l_flow_schedule_rec.project_id) THEN

1292: ( l_flow_schedule_rec.project_id <>
1293: p_old_flow_schedule_rec.project_id OR
1294: p_old_flow_schedule_rec.project_id IS NULL )
1295: THEN
1296: IF NOT MRP_Validate.Project(l_flow_schedule_rec.project_id) THEN
1297: x_return_status := FND_API.G_RET_STS_ERROR;
1298: END IF;
1299: END IF;
1300:

Line 1306: IF NOT MRP_Validate.Quantity_Completed(l_flow_schedule_rec.quantity_completed) THEN

1302: ( l_flow_schedule_rec.quantity_completed <>
1303: p_old_flow_schedule_rec.quantity_completed OR
1304: p_old_flow_schedule_rec.quantity_completed IS NULL )
1305: THEN
1306: IF NOT MRP_Validate.Quantity_Completed(l_flow_schedule_rec.quantity_completed) THEN
1307: x_return_status := FND_API.G_RET_STS_ERROR;
1308: END IF;
1309: END IF;
1310:

Line 1316: IF NOT MRP_Validate.Request(l_flow_schedule_rec.request_id) THEN

1312: ( l_flow_schedule_rec.request_id <>
1313: p_old_flow_schedule_rec.request_id OR
1314: p_old_flow_schedule_rec.request_id IS NULL )
1315: THEN
1316: IF NOT MRP_Validate.Request(l_flow_schedule_rec.request_id) THEN
1317: x_return_status := FND_API.G_RET_STS_ERROR;
1318: END IF;
1319: END IF;
1320:

Line 1326: IF NOT MRP_Validate.Resource_Account(l_flow_schedule_rec.resource_account) THEN

1322: ( l_flow_schedule_rec.resource_account <>
1323: p_old_flow_schedule_rec.resource_account OR
1324: p_old_flow_schedule_rec.resource_account IS NULL )
1325: THEN
1326: IF NOT MRP_Validate.Resource_Account(l_flow_schedule_rec.resource_account) THEN
1327: x_return_status := FND_API.G_RET_STS_ERROR;
1328: END IF;
1329: END IF;
1330:

Line 1336: IF NOT MRP_Validate.Resource_Variance_Account(l_flow_schedule_rec.resource_variance_account) THEN

1332: ( l_flow_schedule_rec.resource_variance_account <>
1333: p_old_flow_schedule_rec.resource_variance_account OR
1334: p_old_flow_schedule_rec.resource_variance_account IS NULL )
1335: THEN
1336: IF NOT MRP_Validate.Resource_Variance_Account(l_flow_schedule_rec.resource_variance_account) THEN
1337: x_return_status := FND_API.G_RET_STS_ERROR;
1338: END IF;
1339: END IF;
1340:

Line 1346: IF NOT MRP_Validate.Routing_Revision(l_flow_schedule_rec.routing_revision) THEN

1342: ( l_flow_schedule_rec.routing_revision <>
1343: p_old_flow_schedule_rec.routing_revision OR
1344: p_old_flow_schedule_rec.routing_revision IS NULL )
1345: THEN
1346: IF NOT MRP_Validate.Routing_Revision(l_flow_schedule_rec.routing_revision) THEN
1347: x_return_status := FND_API.G_RET_STS_ERROR;
1348: END IF;
1349: END IF;
1350:

Line 1356: IF NOT MRP_Validate.Routing_Revision_Date(l_flow_schedule_rec.routing_revision_date) THEN

1352: ( l_flow_schedule_rec.routing_revision_date <>
1353: p_old_flow_schedule_rec.routing_revision_date OR
1354: p_old_flow_schedule_rec.routing_revision_date IS NULL )
1355: THEN
1356: IF NOT MRP_Validate.Routing_Revision_Date(l_flow_schedule_rec.routing_revision_date) THEN
1357: x_return_status := FND_API.G_RET_STS_ERROR;
1358: END IF;
1359: END IF;
1360:

Line 1366: IF NOT MRP_Validate.Scheduled_Completion_Date(l_flow_schedule_rec.scheduled_completion_date) THEN

1362: ( l_flow_schedule_rec.scheduled_completion_date <>
1363: p_old_flow_schedule_rec.scheduled_completion_date OR
1364: p_old_flow_schedule_rec.scheduled_completion_date IS NULL )
1365: THEN
1366: IF NOT MRP_Validate.Scheduled_Completion_Date(l_flow_schedule_rec.scheduled_completion_date) THEN
1367: x_return_status := FND_API.G_RET_STS_ERROR;
1368: END IF;
1369: END IF;
1370:

Line 1376: IF NOT MRP_Validate.Scheduled(l_flow_schedule_rec.scheduled_flag) THEN

1372: ( l_flow_schedule_rec.scheduled_flag <>
1373: p_old_flow_schedule_rec.scheduled_flag OR
1374: p_old_flow_schedule_rec.scheduled_flag IS NULL )
1375: THEN
1376: IF NOT MRP_Validate.Scheduled(l_flow_schedule_rec.scheduled_flag) THEN
1377: x_return_status := FND_API.G_RET_STS_ERROR;
1378: END IF;
1379: END IF;
1380:

Line 1386: IF NOT MRP_Validate.Scheduled_Start_Date(l_flow_schedule_rec.scheduled_start_date) THEN

1382: ( l_flow_schedule_rec.scheduled_start_date <>
1383: p_old_flow_schedule_rec.scheduled_start_date OR
1384: p_old_flow_schedule_rec.scheduled_start_date IS NULL )
1385: THEN
1386: IF NOT MRP_Validate.Scheduled_Start_Date(l_flow_schedule_rec.scheduled_start_date) THEN
1387: x_return_status := FND_API.G_RET_STS_ERROR;
1388: END IF;
1389: END IF;
1390:

Line 1396: IF NOT MRP_Validate.Schedule_Group(l_flow_schedule_rec.schedule_group_id) THEN

1392: ( l_flow_schedule_rec.schedule_group_id <>
1393: p_old_flow_schedule_rec.schedule_group_id OR
1394: p_old_flow_schedule_rec.schedule_group_id IS NULL )
1395: THEN
1396: IF NOT MRP_Validate.Schedule_Group(l_flow_schedule_rec.schedule_group_id) THEN
1397: x_return_status := FND_API.G_RET_STS_ERROR;
1398: END IF;
1399: END IF;
1400:

Line 1406: IF NOT MRP_Validate.Schedule_Number(l_flow_schedule_rec.schedule_number) THEN

1402: ( l_flow_schedule_rec.schedule_number <>
1403: p_old_flow_schedule_rec.schedule_number OR
1404: p_old_flow_schedule_rec.schedule_number IS NULL )
1405: THEN
1406: IF NOT MRP_Validate.Schedule_Number(l_flow_schedule_rec.schedule_number) THEN
1407: x_return_status := FND_API.G_RET_STS_ERROR;
1408: END IF;
1409: END IF;
1410:

Line 1416: IF NOT MRP_Validate.Status(l_flow_schedule_rec.status) THEN

1412: ( l_flow_schedule_rec.status <>
1413: p_old_flow_schedule_rec.status OR
1414: p_old_flow_schedule_rec.status IS NULL )
1415: THEN
1416: IF NOT MRP_Validate.Status(l_flow_schedule_rec.status) THEN
1417: x_return_status := FND_API.G_RET_STS_ERROR;
1418: END IF;
1419: END IF;
1420:

Line 1426: IF NOT MRP_Validate.Std_Cost_Adjustment_Acct(l_flow_schedule_rec.std_cost_adjustment_acct) THEN

1422: ( l_flow_schedule_rec.std_cost_adjustment_acct <>
1423: p_old_flow_schedule_rec.std_cost_adjustment_acct OR
1424: p_old_flow_schedule_rec.std_cost_adjustment_acct IS NULL )
1425: THEN
1426: IF NOT MRP_Validate.Std_Cost_Adjustment_Acct(l_flow_schedule_rec.std_cost_adjustment_acct) THEN
1427: x_return_status := FND_API.G_RET_STS_ERROR;
1428: END IF;
1429: END IF;
1430:

Line 1436: IF NOT MRP_Validate.Task(l_flow_schedule_rec.task_id) THEN

1432: ( l_flow_schedule_rec.task_id <>
1433: p_old_flow_schedule_rec.task_id OR
1434: p_old_flow_schedule_rec.task_id IS NULL )
1435: THEN
1436: IF NOT MRP_Validate.Task(l_flow_schedule_rec.task_id) THEN
1437: x_return_status := FND_API.G_RET_STS_ERROR;
1438: END IF;
1439: END IF;
1440:

Line 1446: IF NOT MRP_Validate.Wip_Entity(l_flow_schedule_rec.wip_entity_id) THEN

1442: ( l_flow_schedule_rec.wip_entity_id <>
1443: p_old_flow_schedule_rec.wip_entity_id OR
1444: p_old_flow_schedule_rec.wip_entity_id IS NULL )
1445: THEN
1446: IF NOT MRP_Validate.Wip_Entity(l_flow_schedule_rec.wip_entity_id) THEN
1447: x_return_status := FND_API.G_RET_STS_ERROR;
1448: END IF;
1449: END IF;
1450:

Line 1456: IF NOT MRP_Validate.End_Item_Unit_Number(l_flow_schedule_rec.end_item_unit_number) THEN

1452: ( l_flow_schedule_rec.end_item_unit_number <>
1453: p_old_flow_schedule_rec.end_item_unit_number OR
1454: p_old_flow_schedule_rec.end_item_unit_number IS NULL )
1455: THEN
1456: IF NOT MRP_Validate.End_Item_Unit_Number(l_flow_schedule_rec.end_item_unit_number) THEN
1457: x_return_status := FND_API.G_RET_STS_ERROR;
1458: END IF;
1459: END IF;
1460:

Line 1466: IF NOT MRP_Validate.Quantity_Scrapped(l_flow_schedule_rec.quantity_scrapped) THEN

1462: ( l_flow_schedule_rec.quantity_scrapped <>
1463: p_old_flow_schedule_rec.quantity_scrapped OR
1464: p_old_flow_schedule_rec.quantity_scrapped IS NULL )
1465: THEN
1466: IF NOT MRP_Validate.Quantity_Scrapped(l_flow_schedule_rec.quantity_scrapped) THEN
1467: x_return_status := FND_API.G_RET_STS_ERROR;
1468: END IF;
1469: END IF;
1470:

Line 1608: IF NOT MRP_Validate.Desc_Flex( 'WIP_FLOW_SCHEDULE' ) THEN

1604: */
1605:
1606: -- Validate descriptive flexfield.
1607:
1608: IF NOT MRP_Validate.Desc_Flex( 'WIP_FLOW_SCHEDULE' ) THEN
1609: x_return_status := FND_API.G_RET_STS_ERROR;
1610: END IF;
1611:
1612: END IF;

Line 1682: END MRP_Validate_Flow_Schedule;

1678: END IF;
1679:
1680: END Entity_Delete;
1681:
1682: END MRP_Validate_Flow_Schedule;