538:
539: OE_STANDARD_WF.Save_Messages;
540: OE_STANDARD_WF.Clear_Msg_Context;
541:
542: OE_Delayed_Requests_PVT.Clear_Request
543: (x_return_status => l_return_status);
544:
545: RETURN;
546: END;
550:
551: OE_STANDARD_WF.Save_Messages;
552: OE_STANDARD_WF.Clear_Msg_Context;
553:
554: OE_Delayed_Requests_PVT.Clear_Request
555: (x_return_status => l_return_status);
556: return;
557:
558: END IF;
580: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
581: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
582: END IF;
583:
584: OE_Delayed_Requests_PVT.Clear_Request
585: (x_return_status => l_return_status);
586: return;
587: END IF;
588: IF Is_Scheduling_Eligible(l_top_model_line_id) THEN -- Bug3083995
595: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
596: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
597: END IF;
598:
599: OE_Delayed_Requests_PVT.Clear_Request
600: (x_return_status => l_return_status);
601: return;
602: END IF;
603:
617: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
618: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
619: END IF;
620:
621: OE_Delayed_Requests_PVT.Clear_Request
622: (x_return_status => l_return_status);
623: return;
624: END IF;
625: IF Is_Scheduling_Eligible(l_ato_line_id) THEN ---- Bug3083995
633:
634: OE_STANDARD_WF.Save_Messages;
635: OE_STANDARD_WF.Clear_Msg_Context;
636:
637: OE_Delayed_Requests_PVT.Clear_Request
638: (x_return_status => l_return_status);
639: return;
640: END IF;
641: ELSIF NVL(l_ship_model_complete_flag,'N') = 'N'
653: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
654: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
655: END IF;
656:
657: OE_Delayed_Requests_PVT.Clear_Request
658: (x_return_status => l_return_status);
659: return;
660: END IF;
661: IF Is_Scheduling_Eligible(l_link_to_line_id) THEN -- Bug3083995
669:
670: OE_STANDARD_WF.Save_Messages;
671: OE_STANDARD_WF.Clear_Msg_Context;
672:
673: OE_Delayed_Requests_PVT.Clear_Request
674: (x_return_status => l_return_status);
675: return;
676: END IF;
677:
733: resultout := 'COMPLETE:ON_HOLD';
734: OE_STANDARD_WF.Save_Messages;
735: OE_STANDARD_WF.Clear_Msg_Context;
736:
737: OE_Delayed_Requests_PVT.Clear_Request
738: (x_return_status => l_return_status);
739: return;
740: END IF;
741:
815: resultout := 'COMPLETE:INCOMPLETE';
816: OE_STANDARD_WF.Save_Messages;
817: OE_STANDARD_WF.Clear_Msg_Context;
818:
819: OE_Delayed_Requests_PVT.Clear_Request
820: (x_return_status => l_return_status);
821: return;
822: EXCEPTION
823: WHEN NO_DATA_FOUND THEN
858: resultout := 'COMPLETE:INCOMPLETE';
859: OE_STANDARD_WF.Save_Messages;
860: OE_STANDARD_WF.Clear_Msg_Context;
861:
862: OE_Delayed_Requests_PVT.Clear_Request
863: (x_return_status => l_return_status);
864: return;
865: EXCEPTION
866: WHEN NO_DATA_FOUND THEN
919: ROLLBACK TO SAVEPOINT Schedule_line;
920: OE_STANDARD_WF.Save_Messages;
921: OE_STANDARD_WF.Clear_Msg_Context;
922: --commit; /* Added this line to fix the bug 2884452 */
923: OE_Delayed_Requests_PVT.Clear_Request
924: (x_return_status => l_return_status);
925: --5122730
926: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN
927: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476
940: ROLLBACK TO SAVEPOINT Schedule_line;
941: OE_STANDARD_WF.Save_Messages;
942: OE_STANDARD_WF.Clear_Msg_Context;
943: --commit; /* Added this line to fix the bug 2884452 */
944: OE_Delayed_Requests_PVT.Clear_Request
945: (x_return_status => l_return_status);
946: -- app_exception.raise_exception;
947: --5122730
948: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN