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
1004: IF l_debug_level > 0 THEN
1005: oe_debug_pub.add( 'DELETING oe_schedule_lines_temp ' , 1 ) ;
1006: END IF;
1001: IF l_return_status = FND_API.G_RET_STS_SUCCESS THEN
1002: -- Clear oe_schedule_lines_temp table.
1003: BEGIN
1004: IF l_debug_level > 0 THEN
1005: oe_debug_pub.add( 'DELETING oe_schedule_lines_temp ' , 1 ) ;
1006: END IF;
1007: DELETE FROM oe_schedule_lines_temp;
1008: EXCEPTION
1009: WHEN OTHERS THEN
1003: BEGIN
1004: IF l_debug_level > 0 THEN
1005: oe_debug_pub.add( 'DELETING oe_schedule_lines_temp ' , 1 ) ;
1006: END IF;
1007: DELETE FROM oe_schedule_lines_temp;
1008: EXCEPTION
1009: WHEN OTHERS THEN
1010: NULL;
1011: END;