575: resultout := 'COMPLETE:INCOMPLETE';
576: OE_STANDARD_WF.Save_Messages;
577: OE_STANDARD_WF.Clear_Msg_Context;
578: --5166476
579: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
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:
576: OE_STANDARD_WF.Save_Messages;
577: OE_STANDARD_WF.Clear_Msg_Context;
578: --5166476
579: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
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
577: OE_STANDARD_WF.Clear_Msg_Context;
578: --5166476
579: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
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);
590: resultout := 'COMPLETE:INCOMPLETE';
591: OE_STANDARD_WF.Save_Messages;
592: OE_STANDARD_WF.Clear_Msg_Context;
593: --5166476
594: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
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:
591: OE_STANDARD_WF.Save_Messages;
592: OE_STANDARD_WF.Clear_Msg_Context;
593: --5166476
594: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
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
592: OE_STANDARD_WF.Clear_Msg_Context;
593: --5166476
594: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
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);
612: resultout := 'COMPLETE:INCOMPLETE';
613: OE_STANDARD_WF.Save_Messages;
614: OE_STANDARD_WF.Clear_Msg_Context;
615: --5166476
616: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
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:
613: OE_STANDARD_WF.Save_Messages;
614: OE_STANDARD_WF.Clear_Msg_Context;
615: --5166476
616: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
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
614: OE_STANDARD_WF.Clear_Msg_Context;
615: --5166476
616: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
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);
625: IF Is_Scheduling_Eligible(l_ato_line_id) THEN ---- Bug3083995
626: ROLLBACK TO Before_Lock;
627: resultout := 'COMPLETE:INCOMPLETE';
628: --5166476
629: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
630: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
631: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
632: END IF;
633:
626: ROLLBACK TO Before_Lock;
627: resultout := 'COMPLETE:INCOMPLETE';
628: --5166476
629: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
630: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
631: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
632: END IF;
633:
634: OE_STANDARD_WF.Save_Messages;
627: resultout := 'COMPLETE:INCOMPLETE';
628: --5166476
629: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
630: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
631: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
632: END IF;
633:
634: OE_STANDARD_WF.Save_Messages;
635: OE_STANDARD_WF.Clear_Msg_Context;
648: resultout := 'COMPLETE:INCOMPLETE';
649: OE_STANDARD_WF.Save_Messages;
650: OE_STANDARD_WF.Clear_Msg_Context;
651: --5166476
652: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
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:
649: OE_STANDARD_WF.Save_Messages;
650: OE_STANDARD_WF.Clear_Msg_Context;
651: --5166476
652: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
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
650: OE_STANDARD_WF.Clear_Msg_Context;
651: --5166476
652: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
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);
661: IF Is_Scheduling_Eligible(l_link_to_line_id) THEN -- Bug3083995
662: ROLLBACK TO Before_Lock;
663: resultout := 'COMPLETE:INCOMPLETE';
664: --5166476
665: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
666: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
667: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
668: END IF;
669:
662: ROLLBACK TO Before_Lock;
663: resultout := 'COMPLETE:INCOMPLETE';
664: --5166476
665: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
666: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
667: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
668: END IF;
669:
670: OE_STANDARD_WF.Save_Messages;
663: resultout := 'COMPLETE:INCOMPLETE';
664: --5166476
665: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN
666: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_id) := 'N';
667: OE_SCH_CONC_REQUESTS.g_recorded :='Y';
668: END IF;
669:
670: OE_STANDARD_WF.Save_Messages;
671: 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
928: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_rec.line_id) := 'N';
929: OE_SCH_CONC_REQUESTS.g_recorded := 'Y';
930: END IF;
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
928: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_rec.line_id) := 'N';
929: OE_SCH_CONC_REQUESTS.g_recorded := 'Y';
930: END IF;
931: END IF;
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
928: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_rec.line_id) := 'N';
929: OE_SCH_CONC_REQUESTS.g_recorded := 'Y';
930: END IF;
931: END IF;
932:
925: --5122730
926: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN
927: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476
928: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_rec.line_id) := 'N';
929: OE_SCH_CONC_REQUESTS.g_recorded := 'Y';
930: END IF;
931: END IF;
932:
933: return;
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
949: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476
950: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_rec.line_id) := 'N';
951: OE_SCH_CONC_REQUESTS.g_recorded := 'Y';
952: END IF;
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
949: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476
950: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_rec.line_id) := 'N';
951: OE_SCH_CONC_REQUESTS.g_recorded := 'Y';
952: END IF;
953: END IF;
946: -- app_exception.raise_exception;
947: --5122730
948: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN
949: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476
950: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_rec.line_id) := 'N';
951: OE_SCH_CONC_REQUESTS.g_recorded := 'Y';
952: END IF;
953: END IF;
954: return;
947: --5122730
948: IF OE_SCH_CONC_REQUESTS.g_conc_program = 'Y' THEN
949: IF OE_SCH_CONC_REQUESTS.g_recorded = 'N' THEN -- 5166476
950: OE_SCH_CONC_REQUESTS.OE_line_status_Tbl(l_line_rec.line_id) := 'N';
951: OE_SCH_CONC_REQUESTS.g_recorded := 'Y';
952: END IF;
953: END IF;
954: return;
955: END IF;