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

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

12: , p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
13: , p_old_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
14: )
15: IS
16: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
17: l_dummy VARCHAR2(10) := NULL;
18: l_see_eng_items NUMBER := 0;
19: l_schedule_group_id NUMBER := NULL;
20: --bug 3906891: use l_flow_schedule_rec instead of p_flow_schedule_rec

Line 30: l_return_status := FND_API.G_RET_STS_ERROR;

26:
27: IF l_flow_schedule_rec.organization_id IS NULL
28: THEN
29:
30: l_return_status := FND_API.G_RET_STS_ERROR;
31:
32: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
33: THEN
34:

Line 45: l_return_status := FND_API.G_RET_STS_ERROR;

41:
42: IF l_flow_schedule_rec.wip_entity_id IS NULL
43: THEN
44:
45: l_return_status := FND_API.G_RET_STS_ERROR;
46:
47: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
48: THEN
49:

Line 64: l_return_status := FND_API.G_RET_STS_ERROR;

60:
61: IF l_flow_schedule_rec.scheduled_flag IS NULL
62: THEN
63:
64: l_return_status := FND_API.G_RET_STS_ERROR;
65:
66: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
67: THEN
68:

Line 79: l_return_status := FND_API.G_RET_STS_ERROR;

75:
76: IF l_flow_schedule_rec.primary_item_id IS NULL
77: THEN
78:
79: l_return_status := FND_API.G_RET_STS_ERROR;
80:
81: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
82: THEN
83:

Line 94: l_return_status := FND_API.G_RET_STS_ERROR;

90:
91: IF l_flow_schedule_rec.class_code IS NULL
92: THEN
93:
94: l_return_status := FND_API.G_RET_STS_ERROR;
95:
96: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
97: THEN
98:

Line 109: l_return_status := FND_API.G_RET_STS_ERROR;

105:
106: IF l_flow_schedule_rec.scheduled_completion_date IS NULL
107: THEN
108:
109: l_return_status := FND_API.G_RET_STS_ERROR;
110:
111: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
112: THEN
113:

Line 124: l_return_status := FND_API.G_RET_STS_ERROR;

120:
121: IF l_flow_schedule_rec.planned_quantity IS NULL
122: THEN
123:
124: l_return_status := FND_API.G_RET_STS_ERROR;
125:
126: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
127: THEN
128:

Line 139: l_return_status := FND_API.G_RET_STS_ERROR;

135:
136: IF l_flow_schedule_rec.quantity_completed IS NULL
137: THEN
138:
139: l_return_status := FND_API.G_RET_STS_ERROR;
140:
141: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
142: THEN
143:

Line 154: l_return_status := FND_API.G_RET_STS_ERROR;

150:
151: IF l_flow_schedule_rec.scheduled_start_date IS NULL
152: THEN
153:
154: l_return_status := FND_API.G_RET_STS_ERROR;
155:
156: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
157: THEN
158:

Line 169: l_return_status := FND_API.G_RET_STS_ERROR;

165:
166: IF l_flow_schedule_rec.status IS NULL
167: THEN
168:
169: l_return_status := FND_API.G_RET_STS_ERROR;
170:
171: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
172: THEN
173:

Line 184: l_return_status := FND_API.G_RET_STS_ERROR;

180:
181: IF l_flow_schedule_rec.schedule_number IS NULL
182: THEN
183:
184: l_return_status := FND_API.G_RET_STS_ERROR;
185:
186: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
187: THEN
188:

Line 198: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

194: END IF;
195:
196: -- Return Error if a required attribute is missing.
197:
198: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
199:
200: RAISE FND_API.G_EXC_ERROR;
201:
202: END IF;

Line 200: RAISE FND_API.G_EXC_ERROR;

196: -- Return Error if a required attribute is missing.
197:
198: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
199:
200: RAISE FND_API.G_EXC_ERROR;
201:
202: END IF;
203:
204: --

Line 231: l_return_status := FND_API.G_RET_STS_ERROR;

227: EXCEPTION
228:
229: WHEN NO_DATA_FOUND THEN
230:
231: l_return_status := FND_API.G_RET_STS_ERROR;
232:
233: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
234: THEN
235:

Line 245: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

241: END IF;
242:
243: WHEN OTHERS THEN
244:
245: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
246:
247: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
248: THEN
249:

Line 256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

252: , 'Record Validation - Alternate Bom Designator'
253: );
254: END IF;
255:
256: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
257:
258: END;
259:
260: END IF;

Line 281: l_return_status := FND_API.G_RET_STS_ERROR;

277: EXCEPTION
278:
279: WHEN NO_DATA_FOUND THEN
280:
281: l_return_status := FND_API.G_RET_STS_ERROR;
282:
283: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
284: THEN
285:

Line 295: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

291: END IF;
292:
293: WHEN OTHERS THEN
294:
295: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
296:
297: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
298: THEN
299:

Line 306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

302: , 'Record Validation - Alternate Routing Designator'
303: );
304: END IF;
305:
306: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
307:
308: END;
309:
310: END IF;

Line 332: l_return_status := FND_API.G_RET_STS_ERROR;

328: EXCEPTION
329:
330: WHEN NO_DATA_FOUND THEN
331:
332: l_return_status := FND_API.G_RET_STS_ERROR;
333:
334: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
335: THEN
336:

Line 346: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

342: END IF;
343:
344: WHEN OTHERS THEN
345:
346: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
347:
348: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
349: THEN
350:

Line 357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

353: , 'Record Validation - Bom Revison'
354: );
355: END IF;
356:
357: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
358:
359: END;
360:
361: END IF;

Line 377: IF l_flow_schedule_rec.schedule_group_id = FND_API.G_MISS_NUM

373: THEN
374:
375: BEGIN
376:
377: IF l_flow_schedule_rec.schedule_group_id = FND_API.G_MISS_NUM
378: THEN
379: l_schedule_group_id := NULL;
380: ELSE
381: l_schedule_group_id := l_flow_schedule_rec.schedule_group_id;

Line 402: l_return_status := FND_API.G_RET_STS_ERROR;

398: EXCEPTION
399:
400: WHEN NO_DATA_FOUND THEN
401:
402: l_return_status := FND_API.G_RET_STS_ERROR;
403:
404: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
405: THEN
406:

Line 416: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

412: END IF;
413:
414: WHEN OTHERS THEN
415:
416: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
417:
418: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
419: THEN
420:

Line 427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

423: , 'Record Validation - Build Sequence'
424: );
425: END IF;
426:
427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
428:
429: END;
430:
431: END IF;

Line 459: l_return_status := FND_API.G_RET_STS_ERROR;

455: EXCEPTION
456:
457: WHEN NO_DATA_FOUND THEN
458:
459: l_return_status := FND_API.G_RET_STS_ERROR;
460:
461: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
462: THEN
463:

Line 473: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

469: END IF;
470:
471: WHEN OTHERS THEN
472:
473: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
474:
475: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
476: THEN
477:

Line 484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

480: , 'Record Validation - Class Code'
481: );
482: END IF;
483:
484: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
485:
486: END;
487:
488: END IF;

Line 509: l_return_status := FND_API.G_RET_STS_ERROR;

505: EXCEPTION
506:
507: WHEN NO_DATA_FOUND THEN
508:
509: l_return_status := FND_API.G_RET_STS_ERROR;
510:
511: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
512: THEN
513:

Line 523: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

519: END IF;
520:
521: WHEN OTHERS THEN
522:
523: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
524:
525: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
526: THEN
527:

Line 534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

530: , 'Record Validation - Completion Locator Id'
531: );
532: END IF;
533:
534: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
535:
536: END;
537:
538: END IF;

Line 559: l_return_status := FND_API.G_RET_STS_ERROR;

555: EXCEPTION
556:
557: WHEN NO_DATA_FOUND THEN
558:
559: l_return_status := FND_API.G_RET_STS_ERROR;
560:
561: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
562: THEN
563:

Line 573: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

569: END IF;
570:
571: WHEN OTHERS THEN
572:
573: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
574:
575: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
576: THEN
577:

Line 584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

580: , 'Record Validation - Completion Subinventory'
581: );
582: END IF;
583:
584: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
585:
586: END;
587:
588: END IF;

Line 596: (nvl(l_flow_schedule_rec.demand_source_line,FND_API.G_MISS_CHAR)<>

592: IF (l_flow_schedule_rec.demand_source_line <>
593: p_old_flow_schedule_rec.demand_source_line OR
594: l_flow_schedule_rec.demand_source_delivery <>
595: p_old_flow_schedule_rec.demand_source_delivery) AND /* Bug 3539807 - Added the AND-ed condn. */
596: (nvl(l_flow_schedule_rec.demand_source_line,FND_API.G_MISS_CHAR)<>
597: FND_API.G_MISS_CHAR OR
598: nvl(l_flow_schedule_rec.demand_source_delivery,FND_API.G_MISS_CHAR)<>
599: FND_API.G_MISS_CHAR)
600: THEN

Line 597: FND_API.G_MISS_CHAR OR

593: p_old_flow_schedule_rec.demand_source_line OR
594: l_flow_schedule_rec.demand_source_delivery <>
595: p_old_flow_schedule_rec.demand_source_delivery) AND /* Bug 3539807 - Added the AND-ed condn. */
596: (nvl(l_flow_schedule_rec.demand_source_line,FND_API.G_MISS_CHAR)<>
597: FND_API.G_MISS_CHAR OR
598: nvl(l_flow_schedule_rec.demand_source_delivery,FND_API.G_MISS_CHAR)<>
599: FND_API.G_MISS_CHAR)
600: THEN
601: BEGIN

Line 598: nvl(l_flow_schedule_rec.demand_source_delivery,FND_API.G_MISS_CHAR)<>

594: l_flow_schedule_rec.demand_source_delivery <>
595: p_old_flow_schedule_rec.demand_source_delivery) AND /* Bug 3539807 - Added the AND-ed condn. */
596: (nvl(l_flow_schedule_rec.demand_source_line,FND_API.G_MISS_CHAR)<>
597: FND_API.G_MISS_CHAR OR
598: nvl(l_flow_schedule_rec.demand_source_delivery,FND_API.G_MISS_CHAR)<>
599: FND_API.G_MISS_CHAR)
600: THEN
601: BEGIN
602:

Line 599: FND_API.G_MISS_CHAR)

595: p_old_flow_schedule_rec.demand_source_delivery) AND /* Bug 3539807 - Added the AND-ed condn. */
596: (nvl(l_flow_schedule_rec.demand_source_line,FND_API.G_MISS_CHAR)<>
597: FND_API.G_MISS_CHAR OR
598: nvl(l_flow_schedule_rec.demand_source_delivery,FND_API.G_MISS_CHAR)<>
599: FND_API.G_MISS_CHAR)
600: THEN
601: BEGIN
602:
603: SELECT 'VALID'

Line 621: l_return_status := FND_API.G_RET_STS_ERROR;

617: EXCEPTION
618:
619: WHEN NO_DATA_FOUND THEN
620:
621: l_return_status := FND_API.G_RET_STS_ERROR;
622:
623: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
624: THEN
625:

Line 635: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

631: END IF;
632:
633: WHEN OTHERS THEN
634:
635: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
636:
637: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
638: THEN
639:

Line 646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

642: , 'Record Validation - Demand Sources'
643: );
644: END IF;
645:
646: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
647:
648: END;
649:
650: END IF;

Line 667: l_return_status := FND_API.G_RET_STS_ERROR;

663: EXCEPTION
664:
665: WHEN NO_DATA_FOUND THEN
666:
667: l_return_status := FND_API.G_RET_STS_ERROR;
668:
669: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
670: THEN
671:

Line 681: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

677: END IF;
678:
679: WHEN OTHERS THEN
680:
681: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
682:
683: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
684: THEN
685:

Line 692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

688: , 'Record Validation - Line Id'
689: );
690: END IF;
691:
692: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
693:
694: END;
695:
696: END IF;

Line 720: l_return_status := FND_API.G_RET_STS_ERROR;

716: EXCEPTION
717:
718: WHEN NO_DATA_FOUND THEN
719:
720: l_return_status := FND_API.G_RET_STS_ERROR;
721:
722: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
723: THEN
724:

Line 734: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

730: END IF;
731:
732: WHEN OTHERS THEN
733:
734: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
735:
736: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
737: THEN
738:

Line 745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

741: , 'Record Validation - Primary Item Id'
742: );
743: END IF;
744:
745: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
746:
747: END;
748:
749: END IF;

Line 772: l_return_status := FND_API.G_RET_STS_ERROR;

768: EXCEPTION
769:
770: WHEN NO_DATA_FOUND THEN
771:
772: l_return_status := FND_API.G_RET_STS_ERROR;
773:
774: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
775: THEN
776:

Line 786: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

782: END IF;
783:
784: WHEN OTHERS THEN
785:
786: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
787:
788: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
789: THEN
790:

Line 797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

793: , 'Record Validation - Routing Revision'
794: );
795: END IF;
796:
797: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
798:
799: END;
800:
801: END IF;

Line 819: l_return_status := FND_API.G_RET_STS_ERROR;

815: EXCEPTION
816:
817: WHEN NO_DATA_FOUND THEN
818:
819: l_return_status := FND_API.G_RET_STS_ERROR;
820:
821: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
822: THEN
823:

Line 833: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

829: END IF;
830:
831: WHEN OTHERS THEN
832:
833: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
834:
835: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
836: THEN
837:

Line 844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

840: , 'Record Validation - Schedule Group Id'
841: );
842: END IF;
843:
844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
845:
846: END;
847:
848: END IF;

Line 866: l_return_status := FND_API.G_RET_STS_ERROR;

862: EXCEPTION
863:
864: WHEN NO_DATA_FOUND THEN
865:
866: l_return_status := FND_API.G_RET_STS_ERROR;
867:
868: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
869: THEN
870:

Line 880: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

876: END IF;
877:
878: WHEN OTHERS THEN
879:
880: l_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
881:
882: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
883: THEN
884:

Line 891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

887: , 'Record Validation - Task Id'
888: );
889: END IF;
890:
891: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
892:
893: END;
894:
895: END IF;

Line 903: WHEN FND_API.G_EXC_ERROR THEN

899: x_return_status := l_return_status;
900:
901: EXCEPTION
902:
903: WHEN FND_API.G_EXC_ERROR THEN
904:
905: x_return_status := FND_API.G_RET_STS_ERROR;
906:
907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 905: x_return_status := FND_API.G_RET_STS_ERROR;

901: EXCEPTION
902:
903: WHEN FND_API.G_EXC_ERROR THEN
904:
905: x_return_status := FND_API.G_RET_STS_ERROR;
906:
907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
908:
909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

903: WHEN FND_API.G_EXC_ERROR THEN
904:
905: x_return_status := FND_API.G_RET_STS_ERROR;
906:
907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
908:
909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
910:
911: WHEN OTHERS THEN

Line 909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

905: x_return_status := FND_API.G_RET_STS_ERROR;
906:
907: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
908:
909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
910:
911: WHEN OTHERS THEN
912:
913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

909: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
910:
911: WHEN OTHERS THEN
912:
913: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
914:
915: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
916: THEN
917: FND_MSG_PUB.Add_Exc_Msg

Line 937: x_return_status := FND_API.G_RET_STS_SUCCESS;

933: --bug 3906891: use l_flow_schedule_rec instead of p_flow_schedule_rec
934: l_flow_schedule_rec MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type := MRP_Flow_Schedule_Util.Convert_Miss_To_Null (p_flow_schedule_rec);
935: BEGIN
936:
937: x_return_status := FND_API.G_RET_STS_SUCCESS;
938:
939: -- Validate flow_schedule attributes
940:
941: IF l_flow_schedule_rec.alternate_bom_designator IS NOT NULL AND

Line 947: x_return_status := FND_API.G_RET_STS_ERROR;

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:
951: IF l_flow_schedule_rec.alternate_routing_desig IS NOT NULL AND

Line 957: x_return_status := FND_API.G_RET_STS_ERROR;

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:
961: IF l_flow_schedule_rec.bom_revision IS NOT NULL AND

Line 967: x_return_status := FND_API.G_RET_STS_ERROR;

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:
971: IF l_flow_schedule_rec.bom_revision_date IS NOT NULL AND

Line 977: x_return_status := FND_API.G_RET_STS_ERROR;

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:
981: IF l_flow_schedule_rec.build_sequence IS NOT NULL AND

Line 987: x_return_status := FND_API.G_RET_STS_ERROR;

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:
991: IF l_flow_schedule_rec.class_code IS NOT NULL AND

Line 997: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1001: IF l_flow_schedule_rec.completion_locator_id IS NOT NULL AND

Line 1007: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1011: IF l_flow_schedule_rec.completion_subinventory IS NOT NULL AND

Line 1017: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1021: IF l_flow_schedule_rec.created_by IS NOT NULL AND

Line 1027: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1031: IF l_flow_schedule_rec.creation_date IS NOT NULL AND

Line 1037: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1041: IF l_flow_schedule_rec.date_closed IS NOT NULL AND

Line 1047: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1051: IF l_flow_schedule_rec.demand_class IS NOT NULL AND

Line 1057: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1061: IF l_flow_schedule_rec.demand_source_delivery IS NOT NULL AND

Line 1067: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1071: IF l_flow_schedule_rec.demand_source_header_id IS NOT NULL AND

Line 1077: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1081: IF l_flow_schedule_rec.demand_source_line IS NOT NULL AND

Line 1087: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1091: IF l_flow_schedule_rec.demand_source_type IS NOT NULL AND

Line 1097: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1101: IF l_flow_schedule_rec.last_updated_by IS NOT NULL AND

Line 1107: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1111: IF l_flow_schedule_rec.last_update_date IS NOT NULL AND

Line 1117: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1121: IF l_flow_schedule_rec.last_update_login IS NOT NULL AND

Line 1127: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1131: IF l_flow_schedule_rec.line_id IS NOT NULL AND

Line 1137: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1141: IF l_flow_schedule_rec.material_account IS NOT NULL AND

Line 1147: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1151: IF l_flow_schedule_rec.material_overhead_account IS NOT NULL AND

Line 1157: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1161: IF l_flow_schedule_rec.material_variance_account IS NOT NULL AND

Line 1167: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1171: IF l_flow_schedule_rec.mps_net_quantity IS NOT NULL AND

Line 1177: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1181: IF l_flow_schedule_rec.mps_scheduled_comp_date IS NOT NULL AND

Line 1187: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1191: IF l_flow_schedule_rec.organization_id IS NOT NULL AND

Line 1197: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1201: IF l_flow_schedule_rec.outside_processing_acct IS NOT NULL AND

Line 1207: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1211: IF l_flow_schedule_rec.outside_proc_var_acct IS NOT NULL AND

Line 1217: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1221: IF l_flow_schedule_rec.overhead_account IS NOT NULL AND

Line 1227: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1231: IF l_flow_schedule_rec.overhead_variance_account IS NOT NULL AND

Line 1237: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1241: IF l_flow_schedule_rec.planned_quantity IS NOT NULL AND

Line 1247: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1251: IF l_flow_schedule_rec.primary_item_id IS NOT NULL AND

Line 1257: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1261: IF l_flow_schedule_rec.program_application_id IS NOT NULL AND

Line 1267: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1271: IF l_flow_schedule_rec.program_id IS NOT NULL AND

Line 1277: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1281: IF l_flow_schedule_rec.program_update_date IS NOT NULL AND

Line 1287: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1291: IF l_flow_schedule_rec.project_id IS NOT NULL AND

Line 1297: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1301: IF l_flow_schedule_rec.quantity_completed IS NOT NULL AND

Line 1307: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1311: IF l_flow_schedule_rec.request_id IS NOT NULL AND

Line 1317: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1321: IF l_flow_schedule_rec.resource_account IS NOT NULL AND

Line 1327: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1331: IF l_flow_schedule_rec.resource_variance_account IS NOT NULL AND

Line 1337: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1341: IF l_flow_schedule_rec.routing_revision IS NOT NULL AND

Line 1347: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1351: IF l_flow_schedule_rec.routing_revision_date IS NOT NULL AND

Line 1357: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1361: IF l_flow_schedule_rec.scheduled_completion_date IS NOT NULL AND

Line 1367: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1371: IF l_flow_schedule_rec.scheduled_flag IS NOT NULL AND

Line 1377: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1381: IF l_flow_schedule_rec.scheduled_start_date IS NOT NULL AND

Line 1387: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1391: IF l_flow_schedule_rec.schedule_group_id IS NOT NULL AND

Line 1397: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1401: IF l_flow_schedule_rec.schedule_number IS NOT NULL AND

Line 1407: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1411: IF l_flow_schedule_rec.status IS NOT NULL AND

Line 1417: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1421: IF l_flow_schedule_rec.std_cost_adjustment_acct IS NOT NULL AND

Line 1427: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1431: IF l_flow_schedule_rec.task_id IS NOT NULL AND

Line 1437: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1441: IF l_flow_schedule_rec.wip_entity_id IS NOT NULL AND

Line 1447: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1451: IF l_flow_schedule_rec.end_item_unit_number IS NOT NULL AND

Line 1457: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1461: IF l_flow_schedule_rec.quantity_scrapped IS NOT NULL AND

Line 1467: x_return_status := FND_API.G_RET_STS_ERROR;

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:
1471: IF (l_flow_schedule_rec.attribute1 IS NOT NULL AND

Line 1609: x_return_status := FND_API.G_RET_STS_ERROR;

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;
1613:

Line 1618: WHEN FND_API.G_EXC_ERROR THEN

1614: -- Done validating attributes
1615:
1616: EXCEPTION
1617:
1618: WHEN FND_API.G_EXC_ERROR THEN
1619:
1620: x_return_status := FND_API.G_RET_STS_ERROR;
1621:
1622: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1620: x_return_status := FND_API.G_RET_STS_ERROR;

1616: EXCEPTION
1617:
1618: WHEN FND_API.G_EXC_ERROR THEN
1619:
1620: x_return_status := FND_API.G_RET_STS_ERROR;
1621:
1622: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1623:
1624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1622: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1618: WHEN FND_API.G_EXC_ERROR THEN
1619:
1620: x_return_status := FND_API.G_RET_STS_ERROR;
1621:
1622: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1623:
1624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1625:
1626: WHEN OTHERS THEN

Line 1624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1620: x_return_status := FND_API.G_RET_STS_ERROR;
1621:
1622: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1623:
1624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1625:
1626: WHEN OTHERS THEN
1627:
1628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1624: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1625:
1626: WHEN OTHERS THEN
1627:
1628: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1629:
1630: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1631: THEN
1632: FND_MSG_PUB.Add_Exc_Msg

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

1643: ( x_return_status OUT NOCOPY VARCHAR2
1644: , p_flow_schedule_rec IN MRP_Flow_Schedule_PVT.Flow_Schedule_PVT_Rec_Type
1645: )
1646: IS
1647: l_return_status VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
1648: BEGIN
1649:
1650: -- Validate entity delete.
1651:

Line 1660: WHEN FND_API.G_EXC_ERROR THEN

1656: x_return_status := l_return_status;
1657:
1658: EXCEPTION
1659:
1660: WHEN FND_API.G_EXC_ERROR THEN
1661:
1662: x_return_status := FND_API.G_RET_STS_ERROR;
1663:
1664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1662: x_return_status := FND_API.G_RET_STS_ERROR;

1658: EXCEPTION
1659:
1660: WHEN FND_API.G_EXC_ERROR THEN
1661:
1662: x_return_status := FND_API.G_RET_STS_ERROR;
1663:
1664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1665:
1666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1660: WHEN FND_API.G_EXC_ERROR THEN
1661:
1662: x_return_status := FND_API.G_RET_STS_ERROR;
1663:
1664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1665:
1666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1667:
1668: WHEN OTHERS THEN

Line 1666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1662: x_return_status := FND_API.G_RET_STS_ERROR;
1663:
1664: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1665:
1666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1667:
1668: WHEN OTHERS THEN
1669:
1670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 1670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

1666: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1667:
1668: WHEN OTHERS THEN
1669:
1670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1671:
1672: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1673: THEN
1674: FND_MSG_PUB.Add_Exc_Msg