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.MRP_WFS_FORM_FLOW_SCHEDULE dependencies on FND_API

Line 196: , p_init_msg_list => FND_API.G_TRUE

192: -- Call MRP_Flow_Schedule_PVT.Process_flow_schedule
193:
194: MRP_Flow_Schedule_PVT.Process_flow_schedule
195: ( p_api_version_number => 1.0
196: , p_init_msg_list => FND_API.G_TRUE
197: , x_return_status => l_return_status
198: , x_msg_count => x_msg_count
199: , x_msg_data => x_msg_data
200: , p_control_rec => l_control_rec

Line 206: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

202: , p_old_flow_schedule_rec => l_p_old_flow_schedule_rec
203: , x_flow_schedule_rec => l_x_flow_schedule_rec
204: );
205:
206: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
208: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
209: RAISE FND_API.G_EXC_ERROR;
210: END IF;

Line 207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

203: , x_flow_schedule_rec => l_x_flow_schedule_rec
204: );
205:
206: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
208: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
209: RAISE FND_API.G_EXC_ERROR;
210: END IF;
211:

Line 208: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

204: );
205:
206: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
208: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
209: RAISE FND_API.G_EXC_ERROR;
210: END IF;
211:
212:

Line 209: RAISE FND_API.G_EXC_ERROR;

205:
206: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
207: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
208: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
209: RAISE FND_API.G_EXC_ERROR;
210: END IF;
211:
212:
213: -- Load OUT parameters.

Line 294: l_x_flow_schedule_rec.db_flag := FND_API.G_FALSE;

290:
291: -- Write to cache.
292: -- Set db_flag to False before writing to cache
293:
294: l_x_flow_schedule_rec.db_flag := FND_API.G_FALSE;
295:
296: Write_flow_schedule
297: ( p_flow_schedule_rec => l_x_flow_schedule_rec
298: );

Line 302: x_return_status := FND_API.G_RET_STS_SUCCESS;

298: );
299:
300: -- Set return status.
301:
302: x_return_status := FND_API.G_RET_STS_SUCCESS;
303:
304: -- Get message count and data
305:
306: FND_MSG_PUB.Count_And_Get

Line 314: WHEN FND_API.G_EXC_ERROR THEN

310:
311:
312: EXCEPTION
313:
314: WHEN FND_API.G_EXC_ERROR THEN
315:
316: x_return_status := FND_API.G_RET_STS_ERROR;
317:
318: -- Get message count and data

Line 316: x_return_status := FND_API.G_RET_STS_ERROR;

312: EXCEPTION
313:
314: WHEN FND_API.G_EXC_ERROR THEN
315:
316: x_return_status := FND_API.G_RET_STS_ERROR;
317:
318: -- Get message count and data
319:
320: FND_MSG_PUB.Count_And_Get

Line 325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

321: ( p_count => x_msg_count
322: , p_data => x_msg_data
323: );
324:
325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
326:
327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
328:
329: -- Get message count and data

Line 327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

323: );
324:
325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
326:
327: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
328:
329: -- Get message count and data
330:
331: FND_MSG_PUB.Count_And_Get

Line 338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

334: );
335:
336: WHEN OTHERS THEN
337:
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
339:
340: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
341: THEN
342: FND_MSG_PUB.Add_Exc_Msg

Line 625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

621: , 'Unrecognized attribute'
622: );
623: END IF;
624:
625: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
626:
627: END IF;
628:
629: -- Set Operation.

Line 631: IF FND_API.To_Boolean(l_flow_schedule_rec.db_flag) THEN

627: END IF;
628:
629: -- Set Operation.
630:
631: IF FND_API.To_Boolean(l_flow_schedule_rec.db_flag) THEN
632: l_flow_schedule_rec.operation := MRP_GLOBALS.G_OPR_UPDATE;
633: ELSE
634: l_flow_schedule_rec.operation := MRP_GLOBALS.G_OPR_CREATE;
635: END IF;

Line 641: , p_init_msg_list => FND_API.G_TRUE

637: -- Call MRP_Flow_Schedule_PVT.Process_flow_schedule
638:
639: MRP_Flow_Schedule_PVT.Process_flow_schedule
640: ( p_api_version_number => 1.0
641: , p_init_msg_list => FND_API.G_TRUE
642: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
643: , x_return_status => l_return_status
644: , x_msg_count => x_msg_count
645: , x_msg_data => x_msg_data

Line 642: , p_validation_level => FND_API.G_VALID_LEVEL_NONE

638:
639: MRP_Flow_Schedule_PVT.Process_flow_schedule
640: ( p_api_version_number => 1.0
641: , p_init_msg_list => FND_API.G_TRUE
642: , p_validation_level => FND_API.G_VALID_LEVEL_NONE
643: , x_return_status => l_return_status
644: , x_msg_count => x_msg_count
645: , x_msg_data => x_msg_data
646: , p_control_rec => l_control_rec

Line 652: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

648: , p_old_flow_schedule_rec => l_old_flow_schedule_rec
649: , x_flow_schedule_rec => l_x_flow_schedule_rec
650: );
651:
652: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
654: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
655: RAISE FND_API.G_EXC_ERROR;
656: END IF;

Line 653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

649: , x_flow_schedule_rec => l_x_flow_schedule_rec
650: );
651:
652: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
654: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
655: RAISE FND_API.G_EXC_ERROR;
656: END IF;
657:

Line 654: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

650: );
651:
652: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
654: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
655: RAISE FND_API.G_EXC_ERROR;
656: END IF;
657:
658:

Line 655: RAISE FND_API.G_EXC_ERROR;

651:
652: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
653: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
654: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
655: RAISE FND_API.G_EXC_ERROR;
656: END IF;
657:
658:
659: -- Init OUT parameters to missing.

Line 1127: x_return_status := FND_API.G_RET_STS_SUCCESS;

1123: );
1124:
1125: -- Set return status.
1126:
1127: x_return_status := FND_API.G_RET_STS_SUCCESS;
1128:
1129: -- Get message count and data
1130:
1131: FND_MSG_PUB.Count_And_Get

Line 1139: WHEN FND_API.G_EXC_ERROR THEN

1135:
1136:
1137: EXCEPTION
1138:
1139: WHEN FND_API.G_EXC_ERROR THEN
1140:
1141: x_return_status := FND_API.G_RET_STS_ERROR;
1142:
1143: -- Get message count and data

Line 1141: x_return_status := FND_API.G_RET_STS_ERROR;

1137: EXCEPTION
1138:
1139: WHEN FND_API.G_EXC_ERROR THEN
1140:
1141: x_return_status := FND_API.G_RET_STS_ERROR;
1142:
1143: -- Get message count and data
1144:
1145: FND_MSG_PUB.Count_And_Get

Line 1150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1146: ( p_count => x_msg_count
1147: , p_data => x_msg_data
1148: );
1149:
1150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1151:
1152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1153:
1154: -- Get message count and data

Line 1152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1148: );
1149:
1150: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1151:
1152: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1153:
1154: -- Get message count and data
1155:
1156: FND_MSG_PUB.Count_And_Get

Line 1163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1159: );
1160:
1161: WHEN OTHERS THEN
1162:
1163: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1164:
1165: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1166: THEN
1167: FND_MSG_PUB.Add_Exc_Msg

Line 1193: l_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;

1189: l_flow_schedule_rec MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type:= p_flow_schedule_rec;
1190: BEGIN
1191:
1192: IF l_flow_schedule_rec.alternate_bom_designator IS NULL THEN
1193: l_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
1194: END IF;
1195:
1196: IF l_flow_schedule_rec.alternate_routing_desig IS NULL THEN
1197: l_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;

Line 1197: l_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;

1193: l_flow_schedule_rec.alternate_bom_designator := FND_API.G_MISS_CHAR;
1194: END IF;
1195:
1196: IF l_flow_schedule_rec.alternate_routing_desig IS NULL THEN
1197: l_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
1198: END IF;
1199:
1200: IF l_flow_schedule_rec.attribute1 IS NULL THEN
1201: l_flow_schedule_rec.attribute1 := FND_API.G_MISS_CHAR;

Line 1201: l_flow_schedule_rec.attribute1 := FND_API.G_MISS_CHAR;

1197: l_flow_schedule_rec.alternate_routing_desig := FND_API.G_MISS_CHAR;
1198: END IF;
1199:
1200: IF l_flow_schedule_rec.attribute1 IS NULL THEN
1201: l_flow_schedule_rec.attribute1 := FND_API.G_MISS_CHAR;
1202: END IF;
1203:
1204: IF l_flow_schedule_rec.attribute10 IS NULL THEN
1205: l_flow_schedule_rec.attribute10 := FND_API.G_MISS_CHAR;

Line 1205: l_flow_schedule_rec.attribute10 := FND_API.G_MISS_CHAR;

1201: l_flow_schedule_rec.attribute1 := FND_API.G_MISS_CHAR;
1202: END IF;
1203:
1204: IF l_flow_schedule_rec.attribute10 IS NULL THEN
1205: l_flow_schedule_rec.attribute10 := FND_API.G_MISS_CHAR;
1206: END IF;
1207:
1208: IF l_flow_schedule_rec.attribute11 IS NULL THEN
1209: l_flow_schedule_rec.attribute11 := FND_API.G_MISS_CHAR;

Line 1209: l_flow_schedule_rec.attribute11 := FND_API.G_MISS_CHAR;

1205: l_flow_schedule_rec.attribute10 := FND_API.G_MISS_CHAR;
1206: END IF;
1207:
1208: IF l_flow_schedule_rec.attribute11 IS NULL THEN
1209: l_flow_schedule_rec.attribute11 := FND_API.G_MISS_CHAR;
1210: END IF;
1211:
1212: IF l_flow_schedule_rec.attribute12 IS NULL THEN
1213: l_flow_schedule_rec.attribute12 := FND_API.G_MISS_CHAR;

Line 1213: l_flow_schedule_rec.attribute12 := FND_API.G_MISS_CHAR;

1209: l_flow_schedule_rec.attribute11 := FND_API.G_MISS_CHAR;
1210: END IF;
1211:
1212: IF l_flow_schedule_rec.attribute12 IS NULL THEN
1213: l_flow_schedule_rec.attribute12 := FND_API.G_MISS_CHAR;
1214: END IF;
1215:
1216: IF l_flow_schedule_rec.attribute13 IS NULL THEN
1217: l_flow_schedule_rec.attribute13 := FND_API.G_MISS_CHAR;

Line 1217: l_flow_schedule_rec.attribute13 := FND_API.G_MISS_CHAR;

1213: l_flow_schedule_rec.attribute12 := FND_API.G_MISS_CHAR;
1214: END IF;
1215:
1216: IF l_flow_schedule_rec.attribute13 IS NULL THEN
1217: l_flow_schedule_rec.attribute13 := FND_API.G_MISS_CHAR;
1218: END IF;
1219:
1220: IF l_flow_schedule_rec.attribute14 IS NULL THEN
1221: l_flow_schedule_rec.attribute14 := FND_API.G_MISS_CHAR;

Line 1221: l_flow_schedule_rec.attribute14 := FND_API.G_MISS_CHAR;

1217: l_flow_schedule_rec.attribute13 := FND_API.G_MISS_CHAR;
1218: END IF;
1219:
1220: IF l_flow_schedule_rec.attribute14 IS NULL THEN
1221: l_flow_schedule_rec.attribute14 := FND_API.G_MISS_CHAR;
1222: END IF;
1223:
1224: IF l_flow_schedule_rec.attribute15 IS NULL THEN
1225: l_flow_schedule_rec.attribute15 := FND_API.G_MISS_CHAR;

Line 1225: l_flow_schedule_rec.attribute15 := FND_API.G_MISS_CHAR;

1221: l_flow_schedule_rec.attribute14 := FND_API.G_MISS_CHAR;
1222: END IF;
1223:
1224: IF l_flow_schedule_rec.attribute15 IS NULL THEN
1225: l_flow_schedule_rec.attribute15 := FND_API.G_MISS_CHAR;
1226: END IF;
1227:
1228: IF l_flow_schedule_rec.attribute2 IS NULL THEN
1229: l_flow_schedule_rec.attribute2 := FND_API.G_MISS_CHAR;

Line 1229: l_flow_schedule_rec.attribute2 := FND_API.G_MISS_CHAR;

1225: l_flow_schedule_rec.attribute15 := FND_API.G_MISS_CHAR;
1226: END IF;
1227:
1228: IF l_flow_schedule_rec.attribute2 IS NULL THEN
1229: l_flow_schedule_rec.attribute2 := FND_API.G_MISS_CHAR;
1230: END IF;
1231:
1232: IF l_flow_schedule_rec.attribute3 IS NULL THEN
1233: l_flow_schedule_rec.attribute3 := FND_API.G_MISS_CHAR;

Line 1233: l_flow_schedule_rec.attribute3 := FND_API.G_MISS_CHAR;

1229: l_flow_schedule_rec.attribute2 := FND_API.G_MISS_CHAR;
1230: END IF;
1231:
1232: IF l_flow_schedule_rec.attribute3 IS NULL THEN
1233: l_flow_schedule_rec.attribute3 := FND_API.G_MISS_CHAR;
1234: END IF;
1235:
1236: IF l_flow_schedule_rec.attribute4 IS NULL THEN
1237: l_flow_schedule_rec.attribute4 := FND_API.G_MISS_CHAR;

Line 1237: l_flow_schedule_rec.attribute4 := FND_API.G_MISS_CHAR;

1233: l_flow_schedule_rec.attribute3 := FND_API.G_MISS_CHAR;
1234: END IF;
1235:
1236: IF l_flow_schedule_rec.attribute4 IS NULL THEN
1237: l_flow_schedule_rec.attribute4 := FND_API.G_MISS_CHAR;
1238: END IF;
1239:
1240: IF l_flow_schedule_rec.attribute5 IS NULL THEN
1241: l_flow_schedule_rec.attribute5 := FND_API.G_MISS_CHAR;

Line 1241: l_flow_schedule_rec.attribute5 := FND_API.G_MISS_CHAR;

1237: l_flow_schedule_rec.attribute4 := FND_API.G_MISS_CHAR;
1238: END IF;
1239:
1240: IF l_flow_schedule_rec.attribute5 IS NULL THEN
1241: l_flow_schedule_rec.attribute5 := FND_API.G_MISS_CHAR;
1242: END IF;
1243:
1244: IF l_flow_schedule_rec.attribute6 IS NULL THEN
1245: l_flow_schedule_rec.attribute6 := FND_API.G_MISS_CHAR;

Line 1245: l_flow_schedule_rec.attribute6 := FND_API.G_MISS_CHAR;

1241: l_flow_schedule_rec.attribute5 := FND_API.G_MISS_CHAR;
1242: END IF;
1243:
1244: IF l_flow_schedule_rec.attribute6 IS NULL THEN
1245: l_flow_schedule_rec.attribute6 := FND_API.G_MISS_CHAR;
1246: END IF;
1247:
1248: IF l_flow_schedule_rec.attribute7 IS NULL THEN
1249: l_flow_schedule_rec.attribute7 := FND_API.G_MISS_CHAR;

Line 1249: l_flow_schedule_rec.attribute7 := FND_API.G_MISS_CHAR;

1245: l_flow_schedule_rec.attribute6 := FND_API.G_MISS_CHAR;
1246: END IF;
1247:
1248: IF l_flow_schedule_rec.attribute7 IS NULL THEN
1249: l_flow_schedule_rec.attribute7 := FND_API.G_MISS_CHAR;
1250: END IF;
1251:
1252: IF l_flow_schedule_rec.attribute8 IS NULL THEN
1253: l_flow_schedule_rec.attribute8 := FND_API.G_MISS_CHAR;

Line 1253: l_flow_schedule_rec.attribute8 := FND_API.G_MISS_CHAR;

1249: l_flow_schedule_rec.attribute7 := FND_API.G_MISS_CHAR;
1250: END IF;
1251:
1252: IF l_flow_schedule_rec.attribute8 IS NULL THEN
1253: l_flow_schedule_rec.attribute8 := FND_API.G_MISS_CHAR;
1254: END IF;
1255:
1256: IF l_flow_schedule_rec.attribute9 IS NULL THEN
1257: l_flow_schedule_rec.attribute9 := FND_API.G_MISS_CHAR;

Line 1257: l_flow_schedule_rec.attribute9 := FND_API.G_MISS_CHAR;

1253: l_flow_schedule_rec.attribute8 := FND_API.G_MISS_CHAR;
1254: END IF;
1255:
1256: IF l_flow_schedule_rec.attribute9 IS NULL THEN
1257: l_flow_schedule_rec.attribute9 := FND_API.G_MISS_CHAR;
1258: END IF;
1259:
1260: IF l_flow_schedule_rec.attribute_category IS NULL THEN
1261: l_flow_schedule_rec.attribute_category := FND_API.G_MISS_CHAR;

Line 1261: l_flow_schedule_rec.attribute_category := FND_API.G_MISS_CHAR;

1257: l_flow_schedule_rec.attribute9 := FND_API.G_MISS_CHAR;
1258: END IF;
1259:
1260: IF l_flow_schedule_rec.attribute_category IS NULL THEN
1261: l_flow_schedule_rec.attribute_category := FND_API.G_MISS_CHAR;
1262: END IF;
1263:
1264: IF l_flow_schedule_rec.bom_revision IS NULL THEN
1265: l_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;

Line 1265: l_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;

1261: l_flow_schedule_rec.attribute_category := FND_API.G_MISS_CHAR;
1262: END IF;
1263:
1264: IF l_flow_schedule_rec.bom_revision IS NULL THEN
1265: l_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
1266: END IF;
1267:
1268: IF l_flow_schedule_rec.bom_revision_date IS NULL THEN
1269: l_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;

Line 1269: l_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;

1265: l_flow_schedule_rec.bom_revision := FND_API.G_MISS_CHAR;
1266: END IF;
1267:
1268: IF l_flow_schedule_rec.bom_revision_date IS NULL THEN
1269: l_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
1270: END IF;
1271:
1272: IF l_flow_schedule_rec.build_sequence IS NULL THEN
1273: l_flow_schedule_rec.build_sequence := FND_API.G_MISS_NUM;

Line 1273: l_flow_schedule_rec.build_sequence := FND_API.G_MISS_NUM;

1269: l_flow_schedule_rec.bom_revision_date := FND_API.G_MISS_DATE;
1270: END IF;
1271:
1272: IF l_flow_schedule_rec.build_sequence IS NULL THEN
1273: l_flow_schedule_rec.build_sequence := FND_API.G_MISS_NUM;
1274: END IF;
1275:
1276: IF l_flow_schedule_rec.class_code IS NULL THEN
1277: l_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;

Line 1277: l_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;

1273: l_flow_schedule_rec.build_sequence := FND_API.G_MISS_NUM;
1274: END IF;
1275:
1276: IF l_flow_schedule_rec.class_code IS NULL THEN
1277: l_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
1278: END IF;
1279:
1280: IF l_flow_schedule_rec.completion_locator_id IS NULL THEN
1281: l_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;

Line 1281: l_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;

1277: l_flow_schedule_rec.class_code := FND_API.G_MISS_CHAR;
1278: END IF;
1279:
1280: IF l_flow_schedule_rec.completion_locator_id IS NULL THEN
1281: l_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
1282: END IF;
1283:
1284: IF l_flow_schedule_rec.completion_subinventory IS NULL THEN
1285: l_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;

Line 1285: l_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;

1281: l_flow_schedule_rec.completion_locator_id := FND_API.G_MISS_NUM;
1282: END IF;
1283:
1284: IF l_flow_schedule_rec.completion_subinventory IS NULL THEN
1285: l_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
1286: END IF;
1287:
1288: IF l_flow_schedule_rec.created_by IS NULL THEN
1289: l_flow_schedule_rec.created_by := FND_API.G_MISS_NUM;

Line 1289: l_flow_schedule_rec.created_by := FND_API.G_MISS_NUM;

1285: l_flow_schedule_rec.completion_subinventory := FND_API.G_MISS_CHAR;
1286: END IF;
1287:
1288: IF l_flow_schedule_rec.created_by IS NULL THEN
1289: l_flow_schedule_rec.created_by := FND_API.G_MISS_NUM;
1290: END IF;
1291:
1292: IF l_flow_schedule_rec.creation_date IS NULL THEN
1293: l_flow_schedule_rec.creation_date := FND_API.G_MISS_DATE;

Line 1293: l_flow_schedule_rec.creation_date := FND_API.G_MISS_DATE;

1289: l_flow_schedule_rec.created_by := FND_API.G_MISS_NUM;
1290: END IF;
1291:
1292: IF l_flow_schedule_rec.creation_date IS NULL THEN
1293: l_flow_schedule_rec.creation_date := FND_API.G_MISS_DATE;
1294: END IF;
1295:
1296: IF l_flow_schedule_rec.date_closed IS NULL THEN
1297: l_flow_schedule_rec.date_closed := FND_API.G_MISS_DATE;

Line 1297: l_flow_schedule_rec.date_closed := FND_API.G_MISS_DATE;

1293: l_flow_schedule_rec.creation_date := FND_API.G_MISS_DATE;
1294: END IF;
1295:
1296: IF l_flow_schedule_rec.date_closed IS NULL THEN
1297: l_flow_schedule_rec.date_closed := FND_API.G_MISS_DATE;
1298: END IF;
1299:
1300: IF l_flow_schedule_rec.demand_class IS NULL THEN
1301: l_flow_schedule_rec.demand_class := FND_API.G_MISS_CHAR;

Line 1301: l_flow_schedule_rec.demand_class := FND_API.G_MISS_CHAR;

1297: l_flow_schedule_rec.date_closed := FND_API.G_MISS_DATE;
1298: END IF;
1299:
1300: IF l_flow_schedule_rec.demand_class IS NULL THEN
1301: l_flow_schedule_rec.demand_class := FND_API.G_MISS_CHAR;
1302: END IF;
1303:
1304: IF l_flow_schedule_rec.demand_source_delivery IS NULL THEN
1305: l_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;

Line 1305: l_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;

1301: l_flow_schedule_rec.demand_class := FND_API.G_MISS_CHAR;
1302: END IF;
1303:
1304: IF l_flow_schedule_rec.demand_source_delivery IS NULL THEN
1305: l_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
1306: END IF;
1307:
1308: IF l_flow_schedule_rec.demand_source_header_id IS NULL THEN
1309: l_flow_schedule_rec.demand_source_header_id := FND_API.G_MISS_NUM;

Line 1309: l_flow_schedule_rec.demand_source_header_id := FND_API.G_MISS_NUM;

1305: l_flow_schedule_rec.demand_source_delivery := FND_API.G_MISS_CHAR;
1306: END IF;
1307:
1308: IF l_flow_schedule_rec.demand_source_header_id IS NULL THEN
1309: l_flow_schedule_rec.demand_source_header_id := FND_API.G_MISS_NUM;
1310: END IF;
1311:
1312: IF l_flow_schedule_rec.demand_source_line IS NULL THEN
1313: l_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;

Line 1313: l_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;

1309: l_flow_schedule_rec.demand_source_header_id := FND_API.G_MISS_NUM;
1310: END IF;
1311:
1312: IF l_flow_schedule_rec.demand_source_line IS NULL THEN
1313: l_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
1314: END IF;
1315:
1316: IF l_flow_schedule_rec.demand_source_type IS NULL THEN
1317: l_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;

Line 1317: l_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;

1313: l_flow_schedule_rec.demand_source_line := FND_API.G_MISS_CHAR;
1314: END IF;
1315:
1316: IF l_flow_schedule_rec.demand_source_type IS NULL THEN
1317: l_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;
1318: END IF;
1319:
1320: IF l_flow_schedule_rec.last_updated_by IS NULL THEN
1321: l_flow_schedule_rec.last_updated_by := FND_API.G_MISS_NUM;

Line 1321: l_flow_schedule_rec.last_updated_by := FND_API.G_MISS_NUM;

1317: l_flow_schedule_rec.demand_source_type := FND_API.G_MISS_NUM;
1318: END IF;
1319:
1320: IF l_flow_schedule_rec.last_updated_by IS NULL THEN
1321: l_flow_schedule_rec.last_updated_by := FND_API.G_MISS_NUM;
1322: END IF;
1323:
1324: IF l_flow_schedule_rec.last_update_date IS NULL THEN
1325: l_flow_schedule_rec.last_update_date := FND_API.G_MISS_DATE;

Line 1325: l_flow_schedule_rec.last_update_date := FND_API.G_MISS_DATE;

1321: l_flow_schedule_rec.last_updated_by := FND_API.G_MISS_NUM;
1322: END IF;
1323:
1324: IF l_flow_schedule_rec.last_update_date IS NULL THEN
1325: l_flow_schedule_rec.last_update_date := FND_API.G_MISS_DATE;
1326: END IF;
1327:
1328: IF l_flow_schedule_rec.last_update_login IS NULL THEN
1329: l_flow_schedule_rec.last_update_login := FND_API.G_MISS_NUM;

Line 1329: l_flow_schedule_rec.last_update_login := FND_API.G_MISS_NUM;

1325: l_flow_schedule_rec.last_update_date := FND_API.G_MISS_DATE;
1326: END IF;
1327:
1328: IF l_flow_schedule_rec.last_update_login IS NULL THEN
1329: l_flow_schedule_rec.last_update_login := FND_API.G_MISS_NUM;
1330: END IF;
1331:
1332: IF l_flow_schedule_rec.line_id IS NULL THEN
1333: l_flow_schedule_rec.line_id := FND_API.G_MISS_NUM;

Line 1333: l_flow_schedule_rec.line_id := FND_API.G_MISS_NUM;

1329: l_flow_schedule_rec.last_update_login := FND_API.G_MISS_NUM;
1330: END IF;
1331:
1332: IF l_flow_schedule_rec.line_id IS NULL THEN
1333: l_flow_schedule_rec.line_id := FND_API.G_MISS_NUM;
1334: END IF;
1335:
1336: IF l_flow_schedule_rec.material_account IS NULL THEN
1337: l_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;

Line 1337: l_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;

1333: l_flow_schedule_rec.line_id := FND_API.G_MISS_NUM;
1334: END IF;
1335:
1336: IF l_flow_schedule_rec.material_account IS NULL THEN
1337: l_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
1338: END IF;
1339:
1340: IF l_flow_schedule_rec.material_overhead_account IS NULL THEN
1341: l_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;

Line 1341: l_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;

1337: l_flow_schedule_rec.material_account := FND_API.G_MISS_NUM;
1338: END IF;
1339:
1340: IF l_flow_schedule_rec.material_overhead_account IS NULL THEN
1341: l_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
1342: END IF;
1343:
1344: IF l_flow_schedule_rec.material_variance_account IS NULL THEN
1345: l_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;

Line 1345: l_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;

1341: l_flow_schedule_rec.material_overhead_account := FND_API.G_MISS_NUM;
1342: END IF;
1343:
1344: IF l_flow_schedule_rec.material_variance_account IS NULL THEN
1345: l_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
1346: END IF;
1347:
1348: IF l_flow_schedule_rec.mps_net_quantity IS NULL THEN
1349: l_flow_schedule_rec.mps_net_quantity := FND_API.G_MISS_NUM;

Line 1349: l_flow_schedule_rec.mps_net_quantity := FND_API.G_MISS_NUM;

1345: l_flow_schedule_rec.material_variance_account := FND_API.G_MISS_NUM;
1346: END IF;
1347:
1348: IF l_flow_schedule_rec.mps_net_quantity IS NULL THEN
1349: l_flow_schedule_rec.mps_net_quantity := FND_API.G_MISS_NUM;
1350: END IF;
1351:
1352: IF l_flow_schedule_rec.mps_scheduled_comp_date IS NULL THEN
1353: l_flow_schedule_rec.mps_scheduled_comp_date := FND_API.G_MISS_DATE;

Line 1353: l_flow_schedule_rec.mps_scheduled_comp_date := FND_API.G_MISS_DATE;

1349: l_flow_schedule_rec.mps_net_quantity := FND_API.G_MISS_NUM;
1350: END IF;
1351:
1352: IF l_flow_schedule_rec.mps_scheduled_comp_date IS NULL THEN
1353: l_flow_schedule_rec.mps_scheduled_comp_date := FND_API.G_MISS_DATE;
1354: END IF;
1355:
1356: IF l_flow_schedule_rec.organization_id IS NULL THEN
1357: l_flow_schedule_rec.organization_id := FND_API.G_MISS_NUM;

Line 1357: l_flow_schedule_rec.organization_id := FND_API.G_MISS_NUM;

1353: l_flow_schedule_rec.mps_scheduled_comp_date := FND_API.G_MISS_DATE;
1354: END IF;
1355:
1356: IF l_flow_schedule_rec.organization_id IS NULL THEN
1357: l_flow_schedule_rec.organization_id := FND_API.G_MISS_NUM;
1358: END IF;
1359:
1360: IF l_flow_schedule_rec.outside_processing_acct IS NULL THEN
1361: l_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;

Line 1361: l_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;

1357: l_flow_schedule_rec.organization_id := FND_API.G_MISS_NUM;
1358: END IF;
1359:
1360: IF l_flow_schedule_rec.outside_processing_acct IS NULL THEN
1361: l_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
1362: END IF;
1363:
1364: IF l_flow_schedule_rec.outside_proc_var_acct IS NULL THEN
1365: l_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;

Line 1365: l_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;

1361: l_flow_schedule_rec.outside_processing_acct := FND_API.G_MISS_NUM;
1362: END IF;
1363:
1364: IF l_flow_schedule_rec.outside_proc_var_acct IS NULL THEN
1365: l_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
1366: END IF;
1367:
1368: IF l_flow_schedule_rec.overhead_account IS NULL THEN
1369: l_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;

Line 1369: l_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;

1365: l_flow_schedule_rec.outside_proc_var_acct := FND_API.G_MISS_NUM;
1366: END IF;
1367:
1368: IF l_flow_schedule_rec.overhead_account IS NULL THEN
1369: l_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
1370: END IF;
1371:
1372: IF l_flow_schedule_rec.overhead_variance_account IS NULL THEN
1373: l_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;

Line 1373: l_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;

1369: l_flow_schedule_rec.overhead_account := FND_API.G_MISS_NUM;
1370: END IF;
1371:
1372: IF l_flow_schedule_rec.overhead_variance_account IS NULL THEN
1373: l_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
1374: END IF;
1375:
1376: IF l_flow_schedule_rec.planned_quantity IS NULL THEN
1377: l_flow_schedule_rec.planned_quantity := FND_API.G_MISS_NUM;

Line 1377: l_flow_schedule_rec.planned_quantity := FND_API.G_MISS_NUM;

1373: l_flow_schedule_rec.overhead_variance_account := FND_API.G_MISS_NUM;
1374: END IF;
1375:
1376: IF l_flow_schedule_rec.planned_quantity IS NULL THEN
1377: l_flow_schedule_rec.planned_quantity := FND_API.G_MISS_NUM;
1378: END IF;
1379:
1380: IF l_flow_schedule_rec.primary_item_id IS NULL THEN
1381: l_flow_schedule_rec.primary_item_id := FND_API.G_MISS_NUM;

Line 1381: l_flow_schedule_rec.primary_item_id := FND_API.G_MISS_NUM;

1377: l_flow_schedule_rec.planned_quantity := FND_API.G_MISS_NUM;
1378: END IF;
1379:
1380: IF l_flow_schedule_rec.primary_item_id IS NULL THEN
1381: l_flow_schedule_rec.primary_item_id := FND_API.G_MISS_NUM;
1382: END IF;
1383:
1384: IF l_flow_schedule_rec.program_application_id IS NULL THEN
1385: l_flow_schedule_rec.program_application_id := FND_API.G_MISS_NUM;

Line 1385: l_flow_schedule_rec.program_application_id := FND_API.G_MISS_NUM;

1381: l_flow_schedule_rec.primary_item_id := FND_API.G_MISS_NUM;
1382: END IF;
1383:
1384: IF l_flow_schedule_rec.program_application_id IS NULL THEN
1385: l_flow_schedule_rec.program_application_id := FND_API.G_MISS_NUM;
1386: END IF;
1387:
1388: IF l_flow_schedule_rec.program_id IS NULL THEN
1389: l_flow_schedule_rec.program_id := FND_API.G_MISS_NUM;

Line 1389: l_flow_schedule_rec.program_id := FND_API.G_MISS_NUM;

1385: l_flow_schedule_rec.program_application_id := FND_API.G_MISS_NUM;
1386: END IF;
1387:
1388: IF l_flow_schedule_rec.program_id IS NULL THEN
1389: l_flow_schedule_rec.program_id := FND_API.G_MISS_NUM;
1390: END IF;
1391:
1392: IF l_flow_schedule_rec.program_update_date IS NULL THEN
1393: l_flow_schedule_rec.program_update_date := FND_API.G_MISS_DATE;

Line 1393: l_flow_schedule_rec.program_update_date := FND_API.G_MISS_DATE;

1389: l_flow_schedule_rec.program_id := FND_API.G_MISS_NUM;
1390: END IF;
1391:
1392: IF l_flow_schedule_rec.program_update_date IS NULL THEN
1393: l_flow_schedule_rec.program_update_date := FND_API.G_MISS_DATE;
1394: END IF;
1395:
1396: IF l_flow_schedule_rec.project_id IS NULL THEN
1397: l_flow_schedule_rec.project_id := FND_API.G_MISS_NUM;

Line 1397: l_flow_schedule_rec.project_id := FND_API.G_MISS_NUM;

1393: l_flow_schedule_rec.program_update_date := FND_API.G_MISS_DATE;
1394: END IF;
1395:
1396: IF l_flow_schedule_rec.project_id IS NULL THEN
1397: l_flow_schedule_rec.project_id := FND_API.G_MISS_NUM;
1398: END IF;
1399:
1400: IF l_flow_schedule_rec.quantity_completed IS NULL THEN
1401: l_flow_schedule_rec.quantity_completed := FND_API.G_MISS_NUM;

Line 1401: l_flow_schedule_rec.quantity_completed := FND_API.G_MISS_NUM;

1397: l_flow_schedule_rec.project_id := FND_API.G_MISS_NUM;
1398: END IF;
1399:
1400: IF l_flow_schedule_rec.quantity_completed IS NULL THEN
1401: l_flow_schedule_rec.quantity_completed := FND_API.G_MISS_NUM;
1402: END IF;
1403:
1404: IF l_flow_schedule_rec.request_id IS NULL THEN
1405: l_flow_schedule_rec.request_id := FND_API.G_MISS_NUM;

Line 1405: l_flow_schedule_rec.request_id := FND_API.G_MISS_NUM;

1401: l_flow_schedule_rec.quantity_completed := FND_API.G_MISS_NUM;
1402: END IF;
1403:
1404: IF l_flow_schedule_rec.request_id IS NULL THEN
1405: l_flow_schedule_rec.request_id := FND_API.G_MISS_NUM;
1406: END IF;
1407:
1408: IF l_flow_schedule_rec.resource_account IS NULL THEN
1409: l_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;

Line 1409: l_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;

1405: l_flow_schedule_rec.request_id := FND_API.G_MISS_NUM;
1406: END IF;
1407:
1408: IF l_flow_schedule_rec.resource_account IS NULL THEN
1409: l_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
1410: END IF;
1411:
1412: IF l_flow_schedule_rec.resource_variance_account IS NULL THEN
1413: l_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;

Line 1413: l_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;

1409: l_flow_schedule_rec.resource_account := FND_API.G_MISS_NUM;
1410: END IF;
1411:
1412: IF l_flow_schedule_rec.resource_variance_account IS NULL THEN
1413: l_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
1414: END IF;
1415:
1416: IF l_flow_schedule_rec.routing_revision IS NULL THEN
1417: l_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;

Line 1417: l_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;

1413: l_flow_schedule_rec.resource_variance_account := FND_API.G_MISS_NUM;
1414: END IF;
1415:
1416: IF l_flow_schedule_rec.routing_revision IS NULL THEN
1417: l_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
1418: END IF;
1419:
1420: IF l_flow_schedule_rec.routing_revision_date IS NULL THEN
1421: l_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;

Line 1421: l_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;

1417: l_flow_schedule_rec.routing_revision := FND_API.G_MISS_CHAR;
1418: END IF;
1419:
1420: IF l_flow_schedule_rec.routing_revision_date IS NULL THEN
1421: l_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
1422: END IF;
1423:
1424: IF l_flow_schedule_rec.scheduled_completion_date IS NULL THEN
1425: l_flow_schedule_rec.scheduled_completion_date := FND_API.G_MISS_DATE;

Line 1425: l_flow_schedule_rec.scheduled_completion_date := FND_API.G_MISS_DATE;

1421: l_flow_schedule_rec.routing_revision_date := FND_API.G_MISS_DATE;
1422: END IF;
1423:
1424: IF l_flow_schedule_rec.scheduled_completion_date IS NULL THEN
1425: l_flow_schedule_rec.scheduled_completion_date := FND_API.G_MISS_DATE;
1426: END IF;
1427:
1428: IF l_flow_schedule_rec.scheduled_flag IS NULL THEN
1429: l_flow_schedule_rec.scheduled_flag := FND_API.G_MISS_NUM;

Line 1429: l_flow_schedule_rec.scheduled_flag := FND_API.G_MISS_NUM;

1425: l_flow_schedule_rec.scheduled_completion_date := FND_API.G_MISS_DATE;
1426: END IF;
1427:
1428: IF l_flow_schedule_rec.scheduled_flag IS NULL THEN
1429: l_flow_schedule_rec.scheduled_flag := FND_API.G_MISS_NUM;
1430: END IF;
1431:
1432: IF l_flow_schedule_rec.scheduled_start_date IS NULL THEN
1433: l_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;

Line 1433: l_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;

1429: l_flow_schedule_rec.scheduled_flag := FND_API.G_MISS_NUM;
1430: END IF;
1431:
1432: IF l_flow_schedule_rec.scheduled_start_date IS NULL THEN
1433: l_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;
1434: END IF;
1435:
1436: IF l_flow_schedule_rec.schedule_group_id IS NULL THEN
1437: l_flow_schedule_rec.schedule_group_id := FND_API.G_MISS_NUM;

Line 1437: l_flow_schedule_rec.schedule_group_id := FND_API.G_MISS_NUM;

1433: l_flow_schedule_rec.scheduled_start_date := FND_API.G_MISS_DATE;
1434: END IF;
1435:
1436: IF l_flow_schedule_rec.schedule_group_id IS NULL THEN
1437: l_flow_schedule_rec.schedule_group_id := FND_API.G_MISS_NUM;
1438: END IF;
1439:
1440: IF l_flow_schedule_rec.schedule_number IS NULL THEN
1441: l_flow_schedule_rec.schedule_number := FND_API.G_MISS_CHAR;

Line 1441: l_flow_schedule_rec.schedule_number := FND_API.G_MISS_CHAR;

1437: l_flow_schedule_rec.schedule_group_id := FND_API.G_MISS_NUM;
1438: END IF;
1439:
1440: IF l_flow_schedule_rec.schedule_number IS NULL THEN
1441: l_flow_schedule_rec.schedule_number := FND_API.G_MISS_CHAR;
1442: END IF;
1443:
1444: IF l_flow_schedule_rec.status IS NULL THEN
1445: l_flow_schedule_rec.status := FND_API.G_MISS_NUM;

Line 1445: l_flow_schedule_rec.status := FND_API.G_MISS_NUM;

1441: l_flow_schedule_rec.schedule_number := FND_API.G_MISS_CHAR;
1442: END IF;
1443:
1444: IF l_flow_schedule_rec.status IS NULL THEN
1445: l_flow_schedule_rec.status := FND_API.G_MISS_NUM;
1446: END IF;
1447:
1448: IF l_flow_schedule_rec.std_cost_adjustment_acct IS NULL THEN
1449: l_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;

Line 1449: l_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;

1445: l_flow_schedule_rec.status := FND_API.G_MISS_NUM;
1446: END IF;
1447:
1448: IF l_flow_schedule_rec.std_cost_adjustment_acct IS NULL THEN
1449: l_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
1450: END IF;
1451:
1452: IF l_flow_schedule_rec.task_id IS NULL THEN
1453: l_flow_schedule_rec.task_id := FND_API.G_MISS_NUM;

Line 1453: l_flow_schedule_rec.task_id := FND_API.G_MISS_NUM;

1449: l_flow_schedule_rec.std_cost_adjustment_acct := FND_API.G_MISS_NUM;
1450: END IF;
1451:
1452: IF l_flow_schedule_rec.task_id IS NULL THEN
1453: l_flow_schedule_rec.task_id := FND_API.G_MISS_NUM;
1454: END IF;
1455:
1456: IF l_flow_schedule_rec.wip_entity_id IS NULL THEN
1457: l_flow_schedule_rec.wip_entity_id := FND_API.G_MISS_NUM;

Line 1457: l_flow_schedule_rec.wip_entity_id := FND_API.G_MISS_NUM;

1453: l_flow_schedule_rec.task_id := FND_API.G_MISS_NUM;
1454: END IF;
1455:
1456: IF l_flow_schedule_rec.wip_entity_id IS NULL THEN
1457: l_flow_schedule_rec.wip_entity_id := FND_API.G_MISS_NUM;
1458: END IF;
1459:
1460: IF l_flow_schedule_rec.end_item_unit_number IS NULL THEN
1461: l_flow_schedule_rec.end_item_unit_number := FND_API.G_MISS_CHAR;

Line 1461: l_flow_schedule_rec.end_item_unit_number := FND_API.G_MISS_CHAR;

1457: l_flow_schedule_rec.wip_entity_id := FND_API.G_MISS_NUM;
1458: END IF;
1459:
1460: IF l_flow_schedule_rec.end_item_unit_number IS NULL THEN
1461: l_flow_schedule_rec.end_item_unit_number := FND_API.G_MISS_CHAR;
1462: END IF;
1463:
1464: IF l_flow_schedule_rec.quantity_scrapped IS NULL THEN
1465: l_flow_schedule_rec.quantity_scrapped := FND_API.G_MISS_NUM;

Line 1465: l_flow_schedule_rec.quantity_scrapped := FND_API.G_MISS_NUM;

1461: l_flow_schedule_rec.end_item_unit_number := FND_API.G_MISS_CHAR;
1462: END IF;
1463:
1464: IF l_flow_schedule_rec.quantity_scrapped IS NULL THEN
1465: l_flow_schedule_rec.quantity_scrapped := FND_API.G_MISS_NUM;
1466: END IF;
1467:
1468: RETURN l_flow_schedule_rec;
1469:

Line 1523: IF FND_API.To_Boolean(l_flow_schedule_rec.db_flag) THEN

1519: );
1520:
1521: -- Set Operation.
1522:
1523: IF FND_API.To_Boolean(l_flow_schedule_rec.db_flag) THEN
1524: l_flow_schedule_rec.operation := MRP_GLOBALS.G_OPR_UPDATE;
1525: ELSE
1526: l_flow_schedule_rec.operation := MRP_GLOBALS.G_OPR_CREATE;
1527: END IF;

Line 1532: , p_init_msg_list => FND_API.G_TRUE

1528:
1529: -- Call MRP_Flow_Schedule_PVT.Process_flow_schedule
1530: MRP_Flow_Schedule_PVT.Process_flow_schedule
1531: ( p_api_version_number => 1.0
1532: , p_init_msg_list => FND_API.G_TRUE
1533: , x_return_status => l_return_status
1534: , x_msg_count => x_msg_count
1535: , x_msg_data => x_msg_data
1536: , p_control_rec => l_control_rec

Line 1542: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1538: , p_old_flow_schedule_rec => l_old_flow_schedule_rec
1539: , x_flow_schedule_rec => l_x_flow_schedule_rec
1540: );
1541:
1542: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1544: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1545: RAISE FND_API.G_EXC_ERROR;
1546: END IF;

Line 1543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1539: , x_flow_schedule_rec => l_x_flow_schedule_rec
1540: );
1541:
1542: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1544: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1545: RAISE FND_API.G_EXC_ERROR;
1546: END IF;
1547:

Line 1544: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1540: );
1541:
1542: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1544: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1545: RAISE FND_API.G_EXC_ERROR;
1546: END IF;
1547:
1548: -- Load OUT parameters.

Line 1545: RAISE FND_API.G_EXC_ERROR;

1541:
1542: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1543: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1544: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1545: RAISE FND_API.G_EXC_ERROR;
1546: END IF;
1547:
1548: -- Load OUT parameters.
1549:

Line 1568: x_return_status := FND_API.G_RET_STS_SUCCESS;

1564:
1565:
1566: -- Set return status.
1567:
1568: x_return_status := FND_API.G_RET_STS_SUCCESS;
1569:
1570: -- Get message count and data
1571:
1572: FND_MSG_PUB.Count_And_Get

Line 1580: WHEN FND_API.G_EXC_ERROR THEN

1576:
1577:
1578: EXCEPTION
1579:
1580: WHEN FND_API.G_EXC_ERROR THEN
1581:
1582: x_return_status := FND_API.G_RET_STS_ERROR;
1583:
1584: -- Get message count and data

Line 1582: x_return_status := FND_API.G_RET_STS_ERROR;

1578: EXCEPTION
1579:
1580: WHEN FND_API.G_EXC_ERROR THEN
1581:
1582: x_return_status := FND_API.G_RET_STS_ERROR;
1583:
1584: -- Get message count and data
1585:
1586: FND_MSG_PUB.Count_And_Get

Line 1591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1587: ( p_count => x_msg_count
1588: , p_data => x_msg_data
1589: );
1590:
1591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1592:
1593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1594:
1595: -- Get message count and data

Line 1593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1589: );
1590:
1591: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1592:
1593: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1594:
1595: -- Get message count and data
1596:
1597: FND_MSG_PUB.Count_And_Get

Line 1604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1600: );
1601:
1602: WHEN OTHERS THEN
1603:
1604: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1605:
1606: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1607: THEN
1608: FND_MSG_PUB.Add_Exc_Msg

Line 1670: , p_init_msg_list => FND_API.G_TRUE

1666: -- Call MRP_Flow_Schedule_PVT.Process_flow_schedule
1667:
1668: MRP_Flow_Schedule_PVT.Process_flow_schedule
1669: ( p_api_version_number => 1.0
1670: , p_init_msg_list => FND_API.G_TRUE
1671: , x_return_status => l_return_status
1672: , x_msg_count => x_msg_count
1673: , x_msg_data => x_msg_data
1674: , p_control_rec => l_control_rec

Line 1680: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1676: , p_old_flow_schedule_rec => l_p_old_flow_schedule_rec
1677: , x_flow_schedule_rec => l_x_flow_schedule_rec
1678: );
1679:
1680: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1682: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1683: RAISE FND_API.G_EXC_ERROR;
1684: END IF;

Line 1681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1677: , x_flow_schedule_rec => l_x_flow_schedule_rec
1678: );
1679:
1680: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1682: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1683: RAISE FND_API.G_EXC_ERROR;
1684: END IF;
1685:

Line 1682: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1678: );
1679:
1680: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1682: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1683: RAISE FND_API.G_EXC_ERROR;
1684: END IF;
1685:
1686:

Line 1683: RAISE FND_API.G_EXC_ERROR;

1679:
1680: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1681: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1682: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1683: RAISE FND_API.G_EXC_ERROR;
1684: END IF;
1685:
1686:
1687: -- Clear flow_schedule record cache

Line 1693: x_return_status := FND_API.G_RET_STS_SUCCESS;

1689: Clear_flow_schedule;
1690:
1691: -- Set return status.
1692:
1693: x_return_status := FND_API.G_RET_STS_SUCCESS;
1694:
1695: -- Get message count and data
1696:
1697: FND_MSG_PUB.Count_And_Get

Line 1705: WHEN FND_API.G_EXC_ERROR THEN

1701:
1702:
1703: EXCEPTION
1704:
1705: WHEN FND_API.G_EXC_ERROR THEN
1706:
1707: x_return_status := FND_API.G_RET_STS_ERROR;
1708:
1709: -- Get message count and data

Line 1707: x_return_status := FND_API.G_RET_STS_ERROR;

1703: EXCEPTION
1704:
1705: WHEN FND_API.G_EXC_ERROR THEN
1706:
1707: x_return_status := FND_API.G_RET_STS_ERROR;
1708:
1709: -- Get message count and data
1710:
1711: FND_MSG_PUB.Count_And_Get

Line 1716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1712: ( p_count => x_msg_count
1713: , p_data => x_msg_data
1714: );
1715:
1716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1717:
1718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1719:
1720: -- Get message count and data

Line 1718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1714: );
1715:
1716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1717:
1718: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1719:
1720: -- Get message count and data
1721:
1722: FND_MSG_PUB.Count_And_Get

Line 1729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1725: );
1726:
1727: WHEN OTHERS THEN
1728:
1729: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1730:
1731: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1732: THEN
1733: FND_MSG_PUB.Add_Exc_Msg

Line 1784: , p_init_msg_list => FND_API.G_TRUE

1780: -- Call MRP_Flow_Schedule_PVT.Process_flow_schedule
1781:
1782: MRP_Flow_Schedule_PVT.Process_flow_schedule
1783: ( p_api_version_number => 1.0
1784: , p_init_msg_list => FND_API.G_TRUE
1785: , x_return_status => l_return_status
1786: , x_msg_count => x_msg_count
1787: , x_msg_data => x_msg_data
1788: , p_control_rec => l_control_rec

Line 1794: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1790: , p_flow_schedule_rec => l_p_flow_schedule_rec
1791: , p_old_flow_schedule_rec => l_p_old_flow_schedule_rec
1792: );
1793:
1794: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1796: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1797: RAISE FND_API.G_EXC_ERROR;
1798: END IF;

Line 1795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1791: , p_old_flow_schedule_rec => l_p_old_flow_schedule_rec
1792: );
1793:
1794: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1796: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1797: RAISE FND_API.G_EXC_ERROR;
1798: END IF;
1799:

Line 1796: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1792: );
1793:
1794: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1796: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1797: RAISE FND_API.G_EXC_ERROR;
1798: END IF;
1799:
1800:

Line 1797: RAISE FND_API.G_EXC_ERROR;

1793:
1794: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1795: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1796: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1797: RAISE FND_API.G_EXC_ERROR;
1798: END IF;
1799:
1800:
1801: -- Set return status.

Line 1803: x_return_status := FND_API.G_RET_STS_SUCCESS;

1799:
1800:
1801: -- Set return status.
1802:
1803: x_return_status := FND_API.G_RET_STS_SUCCESS;
1804:
1805: -- Get message count and data
1806:
1807: FND_MSG_PUB.Count_And_Get

Line 1815: WHEN FND_API.G_EXC_ERROR THEN

1811:
1812:
1813: EXCEPTION
1814:
1815: WHEN FND_API.G_EXC_ERROR THEN
1816:
1817: x_return_status := FND_API.G_RET_STS_ERROR;
1818:
1819: -- Get message count and data

Line 1817: x_return_status := FND_API.G_RET_STS_ERROR;

1813: EXCEPTION
1814:
1815: WHEN FND_API.G_EXC_ERROR THEN
1816:
1817: x_return_status := FND_API.G_RET_STS_ERROR;
1818:
1819: -- Get message count and data
1820:
1821: FND_MSG_PUB.Count_And_Get

Line 1826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1822: ( p_count => x_msg_count
1823: , p_data => x_msg_data
1824: );
1825:
1826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1827:
1828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1829:
1830: -- Get message count and data

Line 1828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1824: );
1825:
1826: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1827:
1828: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1829:
1830: -- Get message count and data
1831:
1832: FND_MSG_PUB.Count_And_Get

Line 1839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1835: );
1836:
1837: WHEN OTHERS THEN
1838:
1839: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1840:
1841: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1842: THEN
1843: FND_MSG_PUB.Add_Exc_Msg

Line 1895: , p_init_msg_list => FND_API.G_TRUE

1891: -- Call MRP_Flow_Schedule_PVT.Process_flow_schedule
1892:
1893: MRP_Flow_Schedule_PVT.Process_flow_schedule
1894: ( p_api_version_number => 1.0
1895: , p_init_msg_list => FND_API.G_TRUE
1896: , x_return_status => l_return_status
1897: , x_msg_count => x_msg_count
1898: , x_msg_data => x_msg_data
1899: , p_control_rec => l_control_rec

Line 1905: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

1901: , p_flow_schedule_rec => l_p_flow_schedule_rec
1902: , p_old_flow_schedule_rec => l_p_old_flow_schedule_rec
1903: );
1904:
1905: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1907: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1908: RAISE FND_API.G_EXC_ERROR;
1909: END IF;

Line 1906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1902: , p_old_flow_schedule_rec => l_p_old_flow_schedule_rec
1903: );
1904:
1905: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1907: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1908: RAISE FND_API.G_EXC_ERROR;
1909: END IF;
1910:

Line 1907: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN

1903: );
1904:
1905: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1907: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1908: RAISE FND_API.G_EXC_ERROR;
1909: END IF;
1910:
1911:

Line 1908: RAISE FND_API.G_EXC_ERROR;

1904:
1905: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1906: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1907: ELSIF l_return_status = FND_API.G_RET_STS_ERROR THEN
1908: RAISE FND_API.G_EXC_ERROR;
1909: END IF;
1910:
1911:
1912: -- Set return status.

Line 1914: x_return_status := FND_API.G_RET_STS_SUCCESS;

1910:
1911:
1912: -- Set return status.
1913:
1914: x_return_status := FND_API.G_RET_STS_SUCCESS;
1915:
1916: -- Get message count and data
1917:
1918: FND_MSG_PUB.Count_And_Get

Line 1926: WHEN FND_API.G_EXC_ERROR THEN

1922:
1923:
1924: EXCEPTION
1925:
1926: WHEN FND_API.G_EXC_ERROR THEN
1927:
1928: x_return_status := FND_API.G_RET_STS_ERROR;
1929:
1930: -- Get message count and data

Line 1928: x_return_status := FND_API.G_RET_STS_ERROR;

1924: EXCEPTION
1925:
1926: WHEN FND_API.G_EXC_ERROR THEN
1927:
1928: x_return_status := FND_API.G_RET_STS_ERROR;
1929:
1930: -- Get message count and data
1931:
1932: FND_MSG_PUB.Count_And_Get

Line 1937: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1933: ( p_count => x_msg_count
1934: , p_data => x_msg_data
1935: );
1936:
1937: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1938:
1939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1940:
1941: -- Get message count and data

Line 1939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1935: );
1936:
1937: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1938:
1939: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1940:
1941: -- Get message count and data
1942:
1943: FND_MSG_PUB.Count_And_Get

Line 1950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

1946: );
1947:
1948: WHEN OTHERS THEN
1949:
1950: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1951:
1952: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1953: THEN
1954: FND_MSG_PUB.Add_Exc_Msg

Line 2131: , p_init_msg_list => FND_API.G_TRUE

2127: -- Call MRP_Flow_Schedule_PVT.Lock_flow_schedule
2128:
2129: MRP_Flow_Schedule_PVT.Lock_flow_schedule
2130: ( p_api_version_number => 1.0
2131: , p_init_msg_list => FND_API.G_TRUE
2132: , x_return_status => l_return_status
2133: , x_msg_count => x_msg_count
2134: , x_msg_data => x_msg_data
2135: , p_flow_schedule_rec => l_flow_schedule_rec

Line 2139: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN

2135: , p_flow_schedule_rec => l_flow_schedule_rec
2136: , x_flow_schedule_rec => l_x_flow_schedule_rec
2137: );
2138:
2139: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2140:
2141: -- Set DB flag and write record to cache.
2142:
2143: l_x_flow_schedule_rec.db_flag := FND_API.G_TRUE;

Line 2143: l_x_flow_schedule_rec.db_flag := FND_API.G_TRUE;

2139: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
2140:
2141: -- Set DB flag and write record to cache.
2142:
2143: l_x_flow_schedule_rec.db_flag := FND_API.G_TRUE;
2144:
2145: Write_flow_schedule
2146: ( p_flow_schedule_rec => l_x_flow_schedule_rec
2147: , p_db_record => TRUE

Line 2180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2176: , 'Lock_Row'
2177: );
2178: END IF;
2179:
2180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2181:
2182: -- Get message count and data
2183:
2184: FND_MSG_PUB.Count_And_Get

Line 2352: , p_init_msg_list => FND_API.G_TRUE

2348: -- Call MRP_Flow_Schedule_PVT.Process_Flow_Schedule
2349:
2350: MRP_Flow_Schedule_PVT.Process_Flow_Schedule
2351: ( p_api_version_number => 1.0
2352: , p_init_msg_list => FND_API.G_TRUE
2353: , x_return_status => l_return_status
2354: , x_msg_count => x_msg_count
2355: , x_msg_data => x_msg_data
2356: , p_control_rec => l_control_rec

Line 2386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2382: , 'Create_Flow_Schedule'
2383: );
2384: END IF;
2385:
2386: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2387:
2388: -- Get message count and data
2389:
2390: FND_MSG_PUB.Count_And_Get

Line 2434: g_flow_schedule_rec.db_flag := FND_API.G_TRUE;

2430: g_flow_schedule_rec := MRP_Flow_Schedule_Util.Query_Row
2431: ( p_wip_entity_id => p_wip_entity_id
2432: );
2433:
2434: g_flow_schedule_rec.db_flag := FND_API.G_TRUE;
2435:
2436: -- Load DB record
2437:
2438: g_db_flow_schedule_rec := g_flow_schedule_rec;

Line 2541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

2537:
2538: EXCEPTION
2539: WHEN OTHERS THEN
2540:
2541: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
2542:
2543: END get_default_dff;
2544:
2545: PROCEDURE Create_Raw_Flow_Schedules

Line 2821: l_return_status := FND_API.G_RET_STS_SUCCESS;

2817: BEGIN
2818:
2819: x_created_count := 0;
2820: x_lock_count := 0;
2821: l_return_status := FND_API.G_RET_STS_SUCCESS;
2822:
2823:
2824: l_line_id := p_LINE_ID;
2825: l_organization_id := p_ORGANIZATION_ID;

Line 2913: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

2909: l_msg_data
2910: );
2911:
2912: -- Check return status
2913: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
2914: x_return_status := l_return_status;
2915: x_msg_count := l_msg_count;
2916: x_msg_data := l_msg_data;
2917:

Line 2918: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

2914: x_return_status := l_return_status;
2915: x_msg_count := l_msg_count;
2916: x_msg_data := l_msg_data;
2917:
2918: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2920: ELSE
2921: RAISE FND_API.G_EXC_ERROR;
2922: END IF;

Line 2919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2915: x_msg_count := l_msg_count;
2916: x_msg_data := l_msg_data;
2917:
2918: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2920: ELSE
2921: RAISE FND_API.G_EXC_ERROR;
2922: END IF;
2923: END IF;

Line 2921: RAISE FND_API.G_EXC_ERROR;

2917:
2918: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
2919: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2920: ELSE
2921: RAISE FND_API.G_EXC_ERROR;
2922: END IF;
2923: END IF;
2924:
2925: ELSE

Line 2964: p_alternate_bom_designator => FND_API.G_MISS_CHAR,

2960: (
2961: x_return_status => l_return_status,
2962: x_msg_count => l_msg_count,
2963: x_msg_data => l_msg_data,
2964: p_alternate_bom_designator => FND_API.G_MISS_CHAR,
2965: p_alternate_routing_desig => FND_API.G_MISS_CHAR,
2966: p_attribute1 => l_attribute1,
2967: p_attribute10 => l_attribute10,
2968: p_attribute11 => l_attribute11,

Line 2965: p_alternate_routing_desig => FND_API.G_MISS_CHAR,

2961: x_return_status => l_return_status,
2962: x_msg_count => l_msg_count,
2963: x_msg_data => l_msg_data,
2964: p_alternate_bom_designator => FND_API.G_MISS_CHAR,
2965: p_alternate_routing_desig => FND_API.G_MISS_CHAR,
2966: p_attribute1 => l_attribute1,
2967: p_attribute10 => l_attribute10,
2968: p_attribute11 => l_attribute11,
2969: p_attribute12 => l_attribute12,

Line 2981: p_attribute_category => FND_API.G_MISS_CHAR,

2977: p_attribute6 => l_attribute6,
2978: p_attribute7 => l_attribute7,
2979: p_attribute8 => l_attribute8,
2980: p_attribute9 => l_attribute9,
2981: p_attribute_category => FND_API.G_MISS_CHAR,
2982: p_bom_revision => FND_API.G_MISS_CHAR,
2983: p_bom_revision_date => FND_API.G_MISS_DATE,
2984: p_build_sequence => FND_API.G_MISS_NUM,
2985: p_class_code => FND_API.G_MISS_CHAR,

Line 2982: p_bom_revision => FND_API.G_MISS_CHAR,

2978: p_attribute7 => l_attribute7,
2979: p_attribute8 => l_attribute8,
2980: p_attribute9 => l_attribute9,
2981: p_attribute_category => FND_API.G_MISS_CHAR,
2982: p_bom_revision => FND_API.G_MISS_CHAR,
2983: p_bom_revision_date => FND_API.G_MISS_DATE,
2984: p_build_sequence => FND_API.G_MISS_NUM,
2985: p_class_code => FND_API.G_MISS_CHAR,
2986: p_completion_locator_id => FND_API.G_MISS_NUM,

Line 2983: p_bom_revision_date => FND_API.G_MISS_DATE,

2979: p_attribute8 => l_attribute8,
2980: p_attribute9 => l_attribute9,
2981: p_attribute_category => FND_API.G_MISS_CHAR,
2982: p_bom_revision => FND_API.G_MISS_CHAR,
2983: p_bom_revision_date => FND_API.G_MISS_DATE,
2984: p_build_sequence => FND_API.G_MISS_NUM,
2985: p_class_code => FND_API.G_MISS_CHAR,
2986: p_completion_locator_id => FND_API.G_MISS_NUM,
2987: p_completion_subinventory => FND_API.G_MISS_CHAR,

Line 2984: p_build_sequence => FND_API.G_MISS_NUM,

2980: p_attribute9 => l_attribute9,
2981: p_attribute_category => FND_API.G_MISS_CHAR,
2982: p_bom_revision => FND_API.G_MISS_CHAR,
2983: p_bom_revision_date => FND_API.G_MISS_DATE,
2984: p_build_sequence => FND_API.G_MISS_NUM,
2985: p_class_code => FND_API.G_MISS_CHAR,
2986: p_completion_locator_id => FND_API.G_MISS_NUM,
2987: p_completion_subinventory => FND_API.G_MISS_CHAR,
2988: p_created_by => FND_API.G_MISS_NUM,

Line 2985: p_class_code => FND_API.G_MISS_CHAR,

2981: p_attribute_category => FND_API.G_MISS_CHAR,
2982: p_bom_revision => FND_API.G_MISS_CHAR,
2983: p_bom_revision_date => FND_API.G_MISS_DATE,
2984: p_build_sequence => FND_API.G_MISS_NUM,
2985: p_class_code => FND_API.G_MISS_CHAR,
2986: p_completion_locator_id => FND_API.G_MISS_NUM,
2987: p_completion_subinventory => FND_API.G_MISS_CHAR,
2988: p_created_by => FND_API.G_MISS_NUM,
2989: p_creation_date => FND_API.G_MISS_DATE,

Line 2986: p_completion_locator_id => FND_API.G_MISS_NUM,

2982: p_bom_revision => FND_API.G_MISS_CHAR,
2983: p_bom_revision_date => FND_API.G_MISS_DATE,
2984: p_build_sequence => FND_API.G_MISS_NUM,
2985: p_class_code => FND_API.G_MISS_CHAR,
2986: p_completion_locator_id => FND_API.G_MISS_NUM,
2987: p_completion_subinventory => FND_API.G_MISS_CHAR,
2988: p_created_by => FND_API.G_MISS_NUM,
2989: p_creation_date => FND_API.G_MISS_DATE,
2990: p_date_closed => FND_API.G_MISS_DATE,

Line 2987: p_completion_subinventory => FND_API.G_MISS_CHAR,

2983: p_bom_revision_date => FND_API.G_MISS_DATE,
2984: p_build_sequence => FND_API.G_MISS_NUM,
2985: p_class_code => FND_API.G_MISS_CHAR,
2986: p_completion_locator_id => FND_API.G_MISS_NUM,
2987: p_completion_subinventory => FND_API.G_MISS_CHAR,
2988: p_created_by => FND_API.G_MISS_NUM,
2989: p_creation_date => FND_API.G_MISS_DATE,
2990: p_date_closed => FND_API.G_MISS_DATE,
2991: p_demand_class => l_demand_class,

Line 2988: p_created_by => FND_API.G_MISS_NUM,

2984: p_build_sequence => FND_API.G_MISS_NUM,
2985: p_class_code => FND_API.G_MISS_CHAR,
2986: p_completion_locator_id => FND_API.G_MISS_NUM,
2987: p_completion_subinventory => FND_API.G_MISS_CHAR,
2988: p_created_by => FND_API.G_MISS_NUM,
2989: p_creation_date => FND_API.G_MISS_DATE,
2990: p_date_closed => FND_API.G_MISS_DATE,
2991: p_demand_class => l_demand_class,
2992: p_demand_source_delivery => l_demand_source_delivery,

Line 2989: p_creation_date => FND_API.G_MISS_DATE,

2985: p_class_code => FND_API.G_MISS_CHAR,
2986: p_completion_locator_id => FND_API.G_MISS_NUM,
2987: p_completion_subinventory => FND_API.G_MISS_CHAR,
2988: p_created_by => FND_API.G_MISS_NUM,
2989: p_creation_date => FND_API.G_MISS_DATE,
2990: p_date_closed => FND_API.G_MISS_DATE,
2991: p_demand_class => l_demand_class,
2992: p_demand_source_delivery => l_demand_source_delivery,
2993: p_demand_source_header_id => l_demand_source_header_id,

Line 2990: p_date_closed => FND_API.G_MISS_DATE,

2986: p_completion_locator_id => FND_API.G_MISS_NUM,
2987: p_completion_subinventory => FND_API.G_MISS_CHAR,
2988: p_created_by => FND_API.G_MISS_NUM,
2989: p_creation_date => FND_API.G_MISS_DATE,
2990: p_date_closed => FND_API.G_MISS_DATE,
2991: p_demand_class => l_demand_class,
2992: p_demand_source_delivery => l_demand_source_delivery,
2993: p_demand_source_header_id => l_demand_source_header_id,
2994: p_demand_source_line => l_demand_source_line,

Line 2996: p_last_updated_by => FND_API.G_MISS_NUM,

2992: p_demand_source_delivery => l_demand_source_delivery,
2993: p_demand_source_header_id => l_demand_source_header_id,
2994: p_demand_source_line => l_demand_source_line,
2995: p_demand_source_type => l_demand_source_type,
2996: p_last_updated_by => FND_API.G_MISS_NUM,
2997: p_last_update_date => FND_API.G_MISS_DATE,
2998: p_last_update_login => FND_API.G_MISS_NUM,
2999: p_line_id => l_line_id,
3000: p_material_account => FND_API.G_MISS_NUM,

Line 2997: p_last_update_date => FND_API.G_MISS_DATE,

2993: p_demand_source_header_id => l_demand_source_header_id,
2994: p_demand_source_line => l_demand_source_line,
2995: p_demand_source_type => l_demand_source_type,
2996: p_last_updated_by => FND_API.G_MISS_NUM,
2997: p_last_update_date => FND_API.G_MISS_DATE,
2998: p_last_update_login => FND_API.G_MISS_NUM,
2999: p_line_id => l_line_id,
3000: p_material_account => FND_API.G_MISS_NUM,
3001: p_material_overhead_account => FND_API.G_MISS_NUM,

Line 2998: p_last_update_login => FND_API.G_MISS_NUM,

2994: p_demand_source_line => l_demand_source_line,
2995: p_demand_source_type => l_demand_source_type,
2996: p_last_updated_by => FND_API.G_MISS_NUM,
2997: p_last_update_date => FND_API.G_MISS_DATE,
2998: p_last_update_login => FND_API.G_MISS_NUM,
2999: p_line_id => l_line_id,
3000: p_material_account => FND_API.G_MISS_NUM,
3001: p_material_overhead_account => FND_API.G_MISS_NUM,
3002: p_material_variance_account => FND_API.G_MISS_NUM,

Line 3000: p_material_account => FND_API.G_MISS_NUM,

2996: p_last_updated_by => FND_API.G_MISS_NUM,
2997: p_last_update_date => FND_API.G_MISS_DATE,
2998: p_last_update_login => FND_API.G_MISS_NUM,
2999: p_line_id => l_line_id,
3000: p_material_account => FND_API.G_MISS_NUM,
3001: p_material_overhead_account => FND_API.G_MISS_NUM,
3002: p_material_variance_account => FND_API.G_MISS_NUM,
3003: p_mps_net_quantity => FND_API.G_MISS_NUM,
3004: p_mps_scheduled_comp_date => FND_API.G_MISS_DATE,

Line 3001: p_material_overhead_account => FND_API.G_MISS_NUM,

2997: p_last_update_date => FND_API.G_MISS_DATE,
2998: p_last_update_login => FND_API.G_MISS_NUM,
2999: p_line_id => l_line_id,
3000: p_material_account => FND_API.G_MISS_NUM,
3001: p_material_overhead_account => FND_API.G_MISS_NUM,
3002: p_material_variance_account => FND_API.G_MISS_NUM,
3003: p_mps_net_quantity => FND_API.G_MISS_NUM,
3004: p_mps_scheduled_comp_date => FND_API.G_MISS_DATE,
3005: p_organization_id => l_organization_id,

Line 3002: p_material_variance_account => FND_API.G_MISS_NUM,

2998: p_last_update_login => FND_API.G_MISS_NUM,
2999: p_line_id => l_line_id,
3000: p_material_account => FND_API.G_MISS_NUM,
3001: p_material_overhead_account => FND_API.G_MISS_NUM,
3002: p_material_variance_account => FND_API.G_MISS_NUM,
3003: p_mps_net_quantity => FND_API.G_MISS_NUM,
3004: p_mps_scheduled_comp_date => FND_API.G_MISS_DATE,
3005: p_organization_id => l_organization_id,
3006: p_outside_processing_acct => FND_API.G_MISS_NUM,

Line 3003: p_mps_net_quantity => FND_API.G_MISS_NUM,

2999: p_line_id => l_line_id,
3000: p_material_account => FND_API.G_MISS_NUM,
3001: p_material_overhead_account => FND_API.G_MISS_NUM,
3002: p_material_variance_account => FND_API.G_MISS_NUM,
3003: p_mps_net_quantity => FND_API.G_MISS_NUM,
3004: p_mps_scheduled_comp_date => FND_API.G_MISS_DATE,
3005: p_organization_id => l_organization_id,
3006: p_outside_processing_acct => FND_API.G_MISS_NUM,
3007: p_outside_proc_var_acct => FND_API.G_MISS_NUM,

Line 3004: p_mps_scheduled_comp_date => FND_API.G_MISS_DATE,

3000: p_material_account => FND_API.G_MISS_NUM,
3001: p_material_overhead_account => FND_API.G_MISS_NUM,
3002: p_material_variance_account => FND_API.G_MISS_NUM,
3003: p_mps_net_quantity => FND_API.G_MISS_NUM,
3004: p_mps_scheduled_comp_date => FND_API.G_MISS_DATE,
3005: p_organization_id => l_organization_id,
3006: p_outside_processing_acct => FND_API.G_MISS_NUM,
3007: p_outside_proc_var_acct => FND_API.G_MISS_NUM,
3008: p_overhead_account => FND_API.G_MISS_NUM,

Line 3006: p_outside_processing_acct => FND_API.G_MISS_NUM,

3002: p_material_variance_account => FND_API.G_MISS_NUM,
3003: p_mps_net_quantity => FND_API.G_MISS_NUM,
3004: p_mps_scheduled_comp_date => FND_API.G_MISS_DATE,
3005: p_organization_id => l_organization_id,
3006: p_outside_processing_acct => FND_API.G_MISS_NUM,
3007: p_outside_proc_var_acct => FND_API.G_MISS_NUM,
3008: p_overhead_account => FND_API.G_MISS_NUM,
3009: p_overhead_variance_account => FND_API.G_MISS_NUM,
3010: p_planned_quantity => l_planned_quantity,

Line 3007: p_outside_proc_var_acct => FND_API.G_MISS_NUM,

3003: p_mps_net_quantity => FND_API.G_MISS_NUM,
3004: p_mps_scheduled_comp_date => FND_API.G_MISS_DATE,
3005: p_organization_id => l_organization_id,
3006: p_outside_processing_acct => FND_API.G_MISS_NUM,
3007: p_outside_proc_var_acct => FND_API.G_MISS_NUM,
3008: p_overhead_account => FND_API.G_MISS_NUM,
3009: p_overhead_variance_account => FND_API.G_MISS_NUM,
3010: p_planned_quantity => l_planned_quantity,
3011: p_primary_item_id => l_primary_item_id,

Line 3008: p_overhead_account => FND_API.G_MISS_NUM,

3004: p_mps_scheduled_comp_date => FND_API.G_MISS_DATE,
3005: p_organization_id => l_organization_id,
3006: p_outside_processing_acct => FND_API.G_MISS_NUM,
3007: p_outside_proc_var_acct => FND_API.G_MISS_NUM,
3008: p_overhead_account => FND_API.G_MISS_NUM,
3009: p_overhead_variance_account => FND_API.G_MISS_NUM,
3010: p_planned_quantity => l_planned_quantity,
3011: p_primary_item_id => l_primary_item_id,
3012: p_program_application_id => FND_API.G_MISS_NUM,

Line 3009: p_overhead_variance_account => FND_API.G_MISS_NUM,

3005: p_organization_id => l_organization_id,
3006: p_outside_processing_acct => FND_API.G_MISS_NUM,
3007: p_outside_proc_var_acct => FND_API.G_MISS_NUM,
3008: p_overhead_account => FND_API.G_MISS_NUM,
3009: p_overhead_variance_account => FND_API.G_MISS_NUM,
3010: p_planned_quantity => l_planned_quantity,
3011: p_primary_item_id => l_primary_item_id,
3012: p_program_application_id => FND_API.G_MISS_NUM,
3013: p_program_id => FND_API.G_MISS_NUM,

Line 3012: p_program_application_id => FND_API.G_MISS_NUM,

3008: p_overhead_account => FND_API.G_MISS_NUM,
3009: p_overhead_variance_account => FND_API.G_MISS_NUM,
3010: p_planned_quantity => l_planned_quantity,
3011: p_primary_item_id => l_primary_item_id,
3012: p_program_application_id => FND_API.G_MISS_NUM,
3013: p_program_id => FND_API.G_MISS_NUM,
3014: p_program_update_date => FND_API.G_MISS_DATE,
3015: p_project_id => l_project_id,
3016: p_quantity_completed => FND_API.G_MISS_NUM,

Line 3013: p_program_id => FND_API.G_MISS_NUM,

3009: p_overhead_variance_account => FND_API.G_MISS_NUM,
3010: p_planned_quantity => l_planned_quantity,
3011: p_primary_item_id => l_primary_item_id,
3012: p_program_application_id => FND_API.G_MISS_NUM,
3013: p_program_id => FND_API.G_MISS_NUM,
3014: p_program_update_date => FND_API.G_MISS_DATE,
3015: p_project_id => l_project_id,
3016: p_quantity_completed => FND_API.G_MISS_NUM,
3017: p_request_id => USERENV('SESSIONID'), -- bug 4529167

Line 3014: p_program_update_date => FND_API.G_MISS_DATE,

3010: p_planned_quantity => l_planned_quantity,
3011: p_primary_item_id => l_primary_item_id,
3012: p_program_application_id => FND_API.G_MISS_NUM,
3013: p_program_id => FND_API.G_MISS_NUM,
3014: p_program_update_date => FND_API.G_MISS_DATE,
3015: p_project_id => l_project_id,
3016: p_quantity_completed => FND_API.G_MISS_NUM,
3017: p_request_id => USERENV('SESSIONID'), -- bug 4529167
3018: p_resource_account => FND_API.G_MISS_NUM,

Line 3016: p_quantity_completed => FND_API.G_MISS_NUM,

3012: p_program_application_id => FND_API.G_MISS_NUM,
3013: p_program_id => FND_API.G_MISS_NUM,
3014: p_program_update_date => FND_API.G_MISS_DATE,
3015: p_project_id => l_project_id,
3016: p_quantity_completed => FND_API.G_MISS_NUM,
3017: p_request_id => USERENV('SESSIONID'), -- bug 4529167
3018: p_resource_account => FND_API.G_MISS_NUM,
3019: p_resource_variance_account => FND_API.G_MISS_NUM,
3020: p_routing_revision => FND_API.G_MISS_CHAR,

Line 3018: p_resource_account => FND_API.G_MISS_NUM,

3014: p_program_update_date => FND_API.G_MISS_DATE,
3015: p_project_id => l_project_id,
3016: p_quantity_completed => FND_API.G_MISS_NUM,
3017: p_request_id => USERENV('SESSIONID'), -- bug 4529167
3018: p_resource_account => FND_API.G_MISS_NUM,
3019: p_resource_variance_account => FND_API.G_MISS_NUM,
3020: p_routing_revision => FND_API.G_MISS_CHAR,
3021: p_routing_revision_date => FND_API.G_MISS_DATE,
3022: p_scheduled_completion_date => l_scheduled_completion_date,

Line 3019: p_resource_variance_account => FND_API.G_MISS_NUM,

3015: p_project_id => l_project_id,
3016: p_quantity_completed => FND_API.G_MISS_NUM,
3017: p_request_id => USERENV('SESSIONID'), -- bug 4529167
3018: p_resource_account => FND_API.G_MISS_NUM,
3019: p_resource_variance_account => FND_API.G_MISS_NUM,
3020: p_routing_revision => FND_API.G_MISS_CHAR,
3021: p_routing_revision_date => FND_API.G_MISS_DATE,
3022: p_scheduled_completion_date => l_scheduled_completion_date,
3023: p_scheduled_flag => l_scheduled_flag,

Line 3020: p_routing_revision => FND_API.G_MISS_CHAR,

3016: p_quantity_completed => FND_API.G_MISS_NUM,
3017: p_request_id => USERENV('SESSIONID'), -- bug 4529167
3018: p_resource_account => FND_API.G_MISS_NUM,
3019: p_resource_variance_account => FND_API.G_MISS_NUM,
3020: p_routing_revision => FND_API.G_MISS_CHAR,
3021: p_routing_revision_date => FND_API.G_MISS_DATE,
3022: p_scheduled_completion_date => l_scheduled_completion_date,
3023: p_scheduled_flag => l_scheduled_flag,
3024: p_scheduled_start_date => FND_API.G_MISS_DATE,

Line 3021: p_routing_revision_date => FND_API.G_MISS_DATE,

3017: p_request_id => USERENV('SESSIONID'), -- bug 4529167
3018: p_resource_account => FND_API.G_MISS_NUM,
3019: p_resource_variance_account => FND_API.G_MISS_NUM,
3020: p_routing_revision => FND_API.G_MISS_CHAR,
3021: p_routing_revision_date => FND_API.G_MISS_DATE,
3022: p_scheduled_completion_date => l_scheduled_completion_date,
3023: p_scheduled_flag => l_scheduled_flag,
3024: p_scheduled_start_date => FND_API.G_MISS_DATE,
3025: p_schedule_group_id => l_schedule_group_id,

Line 3024: p_scheduled_start_date => FND_API.G_MISS_DATE,

3020: p_routing_revision => FND_API.G_MISS_CHAR,
3021: p_routing_revision_date => FND_API.G_MISS_DATE,
3022: p_scheduled_completion_date => l_scheduled_completion_date,
3023: p_scheduled_flag => l_scheduled_flag,
3024: p_scheduled_start_date => FND_API.G_MISS_DATE,
3025: p_schedule_group_id => l_schedule_group_id,
3026: p_schedule_number => l_schedule_number,
3027: p_status => FND_API.G_MISS_NUM,
3028: p_std_cost_adjustment_acct => FND_API.G_MISS_NUM,

Line 3027: p_status => FND_API.G_MISS_NUM,

3023: p_scheduled_flag => l_scheduled_flag,
3024: p_scheduled_start_date => FND_API.G_MISS_DATE,
3025: p_schedule_group_id => l_schedule_group_id,
3026: p_schedule_number => l_schedule_number,
3027: p_status => FND_API.G_MISS_NUM,
3028: p_std_cost_adjustment_acct => FND_API.G_MISS_NUM,
3029: p_task_id => l_task_id,
3030: p_wip_entity_id => l_wip_entity_id,
3031: p_end_item_unit_number => l_end_item_unit_number,

Line 3028: p_std_cost_adjustment_acct => FND_API.G_MISS_NUM,

3024: p_scheduled_start_date => FND_API.G_MISS_DATE,
3025: p_schedule_group_id => l_schedule_group_id,
3026: p_schedule_number => l_schedule_number,
3027: p_status => FND_API.G_MISS_NUM,
3028: p_std_cost_adjustment_acct => FND_API.G_MISS_NUM,
3029: p_task_id => l_task_id,
3030: p_wip_entity_id => l_wip_entity_id,
3031: p_end_item_unit_number => l_end_item_unit_number,
3032: p_quantity_scrapped => FND_API.G_MISS_NUM,

Line 3032: p_quantity_scrapped => FND_API.G_MISS_NUM,

3028: p_std_cost_adjustment_acct => FND_API.G_MISS_NUM,
3029: p_task_id => l_task_id,
3030: p_wip_entity_id => l_wip_entity_id,
3031: p_end_item_unit_number => l_end_item_unit_number,
3032: p_quantity_scrapped => FND_API.G_MISS_NUM,
3033: x_wip_entity_id => l_wip_entity_id2
3034: );
3035:
3036: -- Check return status

Line 3037: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3033: x_wip_entity_id => l_wip_entity_id2
3034: );
3035:
3036: -- Check return status
3037: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3038: x_return_status := l_return_status;
3039: x_msg_count := l_msg_count;
3040: x_msg_data := l_msg_data;
3041:

Line 3042: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

3038: x_return_status := l_return_status;
3039: x_msg_count := l_msg_count;
3040: x_msg_data := l_msg_data;
3041:
3042: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3044: ELSE
3045: RAISE FND_API.G_EXC_ERROR;
3046: END IF;

Line 3043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3039: x_msg_count := l_msg_count;
3040: x_msg_data := l_msg_data;
3041:
3042: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3044: ELSE
3045: RAISE FND_API.G_EXC_ERROR;
3046: END IF;
3047: END IF;

Line 3045: RAISE FND_API.G_EXC_ERROR;

3041:
3042: IF l_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
3043: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3044: ELSE
3045: RAISE FND_API.G_EXC_ERROR;
3046: END IF;
3047: END IF;
3048:
3049: --fix bug#3235193

Line 3101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

3097: ,'Create_Schedules'
3098: );
3099: END IF;
3100:
3101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3102:
3103: -- Get message count and data
3104:
3105: FND_MSG_PUB.Count_And_Get