619: resultout := 'COMPLETE:INCOMPLETE';
620: OE_STANDARD_WF.Save_Messages;
621: OE_STANDARD_WF.Clear_Msg_Context;
622: --5166476
623: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
624: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
625: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
626: END IF;
627:
620: OE_STANDARD_WF.Save_Messages;
621: OE_STANDARD_WF.Clear_Msg_Context;
622: --5166476
623: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
624: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
625: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
626: END IF;
627:
628: OE_Delayed_Requests_PVT.Clear_Request
621: OE_STANDARD_WF.Clear_Msg_Context;
622: --5166476
623: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
624: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
625: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
626: END IF;
627:
628: OE_Delayed_Requests_PVT.Clear_Request
629: (x_return_status => l_return_status);
634: resultout := 'COMPLETE:INCOMPLETE';
635: OE_STANDARD_WF.Save_Messages;
636: OE_STANDARD_WF.Clear_Msg_Context;
637: --5166476
638: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
639: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
640: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
641: END IF;
642:
635: OE_STANDARD_WF.Save_Messages;
636: OE_STANDARD_WF.Clear_Msg_Context;
637: --5166476
638: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
639: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
640: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
641: END IF;
642:
643: OE_Delayed_Requests_PVT.Clear_Request
636: OE_STANDARD_WF.Clear_Msg_Context;
637: --5166476
638: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
639: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
640: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
641: END IF;
642:
643: OE_Delayed_Requests_PVT.Clear_Request
644: (x_return_status => l_return_status);
659: resultout := 'COMPLETE:INCOMPLETE';
660: OE_STANDARD_WF.Save_Messages;
661: OE_STANDARD_WF.Clear_Msg_Context;
662: --5166476
663: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
664: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
665: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
666: END IF;
667:
660: OE_STANDARD_WF.Save_Messages;
661: OE_STANDARD_WF.Clear_Msg_Context;
662: --5166476
663: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
664: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
665: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
666: END IF;
667:
668: OE_Delayed_Requests_PVT.Clear_Request
661: OE_STANDARD_WF.Clear_Msg_Context;
662: --5166476
663: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
664: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
665: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
666: END IF;
667:
668: OE_Delayed_Requests_PVT.Clear_Request
669: (x_return_status => l_return_status);
672: IF Is_Scheduling_Eligible(l_ato_line_id) THEN ---- Bug3083995
673: ROLLBACK TO Before_Lock;
674: resultout := 'COMPLETE:INCOMPLETE';
675: --5166476
676: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
677: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
678: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
679: END IF;
680:
673: ROLLBACK TO Before_Lock;
674: resultout := 'COMPLETE:INCOMPLETE';
675: --5166476
676: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
677: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
678: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
679: END IF;
680:
681: OE_STANDARD_WF.Save_Messages;
674: resultout := 'COMPLETE:INCOMPLETE';
675: --5166476
676: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
677: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
678: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
679: END IF;
680:
681: OE_STANDARD_WF.Save_Messages;
682: OE_STANDARD_WF.Clear_Msg_Context;
699: resultout := 'COMPLETE:INCOMPLETE';
700: OE_STANDARD_WF.Save_Messages;
701: OE_STANDARD_WF.Clear_Msg_Context;
702: --5166476
703: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
704: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
705: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
706: END IF;
707:
700: OE_STANDARD_WF.Save_Messages;
701: OE_STANDARD_WF.Clear_Msg_Context;
702: --5166476
703: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
704: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
705: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
706: END IF;
707:
708: OE_Delayed_Requests_PVT.Clear_Request
701: OE_STANDARD_WF.Clear_Msg_Context;
702: --5166476
703: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
704: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
705: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
706: END IF;
707:
708: OE_Delayed_Requests_PVT.Clear_Request
709: (x_return_status => l_return_status);
712: IF Is_Scheduling_Eligible(l_link_to_line_id) THEN -- Bug3083995
713: ROLLBACK TO Before_Lock;
714: resultout := 'COMPLETE:INCOMPLETE';
715: --5166476
716: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
717: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
718: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
719: END IF;
720:
713: ROLLBACK TO Before_Lock;
714: resultout := 'COMPLETE:INCOMPLETE';
715: --5166476
716: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
717: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
718: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
719: END IF;
720:
721: OE_STANDARD_WF.Save_Messages;
714: resultout := 'COMPLETE:INCOMPLETE';
715: --5166476
716: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
717: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
718: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
719: END IF;
720:
721: OE_STANDARD_WF.Save_Messages;
722: OE_STANDARD_WF.Clear_Msg_Context;
728:
729: END IF;
730: END IF; -- 3565621
731: --
732: IF NVL(OE_SCH_CONC_REQUESTS.g_checked_for_holds, 'N') <> 'Y' THEN -- ER 13114460
733: IF l_debug_level > 0 THEN
734: oe_debug_pub.add( 'CALLING CHECK HOLDS' , 1 ) ;
735: END IF;
736:
1027: --commit; /* Added this line to fix the bug 2884452 */
1028: OE_Delayed_Requests_PVT.Clear_Request
1029: (x_return_status => l_return_status);
1030: --5122730
1031: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN
1032: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476
1033: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_rec.line_id) := 'N';
1034: OE_SCH_CONC_REQUESTS.g_recorded := 'Y';
1035: END IF;
1028: OE_Delayed_Requests_PVT.Clear_Request
1029: (x_return_status => l_return_status);
1030: --5122730
1031: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN
1032: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476
1033: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_rec.line_id) := 'N';
1034: OE_SCH_CONC_REQUESTS.g_recorded := 'Y';
1035: END IF;
1036: END IF;
1029: (x_return_status => l_return_status);
1030: --5122730
1031: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN
1032: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476
1033: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_rec.line_id) := 'N';
1034: OE_SCH_CONC_REQUESTS.g_recorded := 'Y';
1035: END IF;
1036: END IF;
1037:
1030: --5122730
1031: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN
1032: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476
1033: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_rec.line_id) := 'N';
1034: OE_SCH_CONC_REQUESTS.g_recorded := 'Y';
1035: END IF;
1036: END IF;
1037:
1038: return;
1049: OE_Delayed_Requests_PVT.Clear_Request
1050: (x_return_status => l_return_status);
1051: -- app_exception.raise_exception;
1052: --5122730
1053: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN
1054: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476
1055: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_rec.line_id) := 'N';
1056: OE_SCH_CONC_REQUESTS.g_recorded := 'Y';
1057: END IF;
1050: (x_return_status => l_return_status);
1051: -- app_exception.raise_exception;
1052: --5122730
1053: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN
1054: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476
1055: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_rec.line_id) := 'N';
1056: OE_SCH_CONC_REQUESTS.g_recorded := 'Y';
1057: END IF;
1058: END IF;
1051: -- app_exception.raise_exception;
1052: --5122730
1053: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN
1054: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476
1055: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_rec.line_id) := 'N';
1056: OE_SCH_CONC_REQUESTS.g_recorded := 'Y';
1057: END IF;
1058: END IF;
1059: return;
1052: --5122730
1053: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN
1054: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476
1055: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_rec.line_id) := 'N';
1056: OE_SCH_CONC_REQUESTS.g_recorded := 'Y';
1057: END IF;
1058: END IF;
1059: return;
1060: END IF;