[Home] [Help]
565: l_line_rec.top_model_line_id := l_top_model_line_id;
566: l_line_rec.request_date := l_request_date;
567: l_line_rec.ship_from_org_id := l_ship_from_org_id;
568:
569: OE_Schedule_Util.Handle_External_Lines
570: (p_x_line_rec => l_line_rec);
571:
572: EXCEPTION
573: WHEN OTHERS THEN
947: ,p_source_document_type_id => l_line_rec.source_document_type_id);
948:
949: l_old_line_rec := l_line_rec;
950: -- l_line_rec.schedule_action_code := OE_ORDER_SCH_UTIL.OESCH_ACT_SCHEDULE;
951: l_line_rec.schedule_action_code := OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE;
952: l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
953:
954: -- Added this savepoint logic to fix bug 2129583.
955: SAVEPOINT Schedule_line;
972: l_line_count := 1;
973: OE_GROUP_SCH_UTIL.Schedule_Multi_lines
974: (p_selected_line_tbl => l_selected_line_tbl,
975: p_line_count => l_line_count,
976: p_sch_action => OE_SCHEDULE_UTIL.OESCH_ACT_SCHEDULE,
977: x_atp_tbl => l_atp_tbl,
978: x_return_status => l_return_status,
979: x_msg_count => l_msg_count,
980: x_msg_data => l_msg_data);
980: x_msg_data => l_msg_data);
981:
982: ELSIF l_schedule_status_code is null THEN
983: IF l_debug_level > 0 THEN
984: oe_debug_pub.add( 'BEFORE CALLING OE_SCHEDULE_UTIL ' , 1 ) ;
985: END IF;
986: OE_SCHEDULE_UTIL.Schedule_Line
987: (p_x_line_rec => l_line_rec
988: ,p_old_line_rec => l_old_line_rec
982: ELSIF l_schedule_status_code is null THEN
983: IF l_debug_level > 0 THEN
984: oe_debug_pub.add( 'BEFORE CALLING OE_SCHEDULE_UTIL ' , 1 ) ;
985: END IF;
986: OE_SCHEDULE_UTIL.Schedule_Line
987: (p_x_line_rec => l_line_rec
988: ,p_old_line_rec => l_old_line_rec
989: ,p_caller => OE_SCHEDULE_UTIL.SCH_EXTERNAL
990: ,x_return_status => l_return_status);
985: END IF;
986: OE_SCHEDULE_UTIL.Schedule_Line
987: (p_x_line_rec => l_line_rec
988: ,p_old_line_rec => l_old_line_rec
989: ,p_caller => OE_SCHEDULE_UTIL.SCH_EXTERNAL
990: ,x_return_status => l_return_status);
991: END IF;
992: IF l_debug_level > 0 THEN
993: oe_debug_pub.add( 'L_RETURN_STATUS IS ' || L_RETURN_STATUS , 1 ) ;
994: END IF;
995: --11825106
996: IF l_ship_set_id IS NULL AND
997: l_Arrival_set_id IS NULL AND
998: oe_schedule_util.OESCH_SET_SCHEDULING = 'N' THEN
999: oe_schedule_util.OESCH_SET_SCHEDULING := 'Y' ;
1000: END IF;
1001: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1002: -- Clear oe_schedule_lines_temp table.
995: --11825106
996: IF l_ship_set_id IS NULL AND
997: l_Arrival_set_id IS NULL AND
998: oe_schedule_util.OESCH_SET_SCHEDULING = 'N' THEN
999: oe_schedule_util.OESCH_SET_SCHEDULING := 'Y' ;
1000: END IF;
1001: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1002: -- Clear oe_schedule_lines_temp table.
1003: BEGIN
1015: END IF;
1016: resultout := 'COMPLETE:INCOMPLETE';
1017: --8731703
1018: -- Rollback the demand for success lines.
1019: OE_SCHEDULE_UTIL.CALL_MRP_ROLLBACK (x_return_status => l_return_status);
1020: IF l_debug_level > 0 THEN
1021: oe_debug_pub.add( 'MRP Rollback result '||l_return_status , 1 ) ;
1022: END IF;
1023: -- moved this line up to for the bug fix 2884452
1064: IF l_line_rec.top_model_line_id = l_line_rec.line_id
1065: OR l_line_rec.ato_line_id = l_line_rec.line_id
1066: OR (NVL(l_line_rec.ship_model_complete_flag,'N') = 'N'
1067: AND l_line_rec.item_type_code IN('MODEL','CLASS','KIT'))
1068: AND oe_schedule_util.OESCH_SET_SCHEDULING = 'Y' -- 11825106
1069: THEN
1070: IF OE_GLOBALS.Equal(l_line_rec.line_id,
1071: sch_cached_line_id)
1072: THEN -- To refresh the cached values
1082: g_skip_check := FALSE;
1083: END IF;
1084: --
1085: --11825106
1086: IF oe_schedule_util.OESCH_SET_SCHEDULING = 'Y' THEN
1087: resultout := 'COMPLETE:COMPLETE';
1088: OE_STANDARD_WF.Clear_Msg_Context;
1089:
1090: Bulk_Mode_Copy_Sch_Attribs
1097: OE_STANDARD_WF.Clear_Msg_Context;
1098: --commit; /* Added this line to fix the bug 2884452 */
1099: OE_Delayed_Requests_PVT.Clear_Request
1100: (x_return_status => l_return_status);
1101: --oe_schedule_util.OESCH_SET_SCHEDULING :='Y';
1102: END IF;
1103: return;
1104: end if;
1105: