744: EXCEPTION
745: WHEN OTHERS THEN
746: BEGIN
747: SELECT ROUTINGSTEP_NO INTO l_step_no
748: FROM fm_rout_dtl
749: WHERE routingstep_id = p_wip_spec_rec.step_id
750: AND routing_id = p_wip_spec_rec.routing_id;
751:
752: EXCEPTION WHEN OTHERS THEN
755: END;
756: ELSIF p_wip_spec_rec.routing_id IS NOT NULL THEN
757: BEGIN
758: SELECT ROUTINGSTEP_NO INTO l_step_no
759: FROM fm_rout_dtl
760: WHERE routingstep_id = p_wip_spec_rec.step_id
761: AND routing_id = p_wip_spec_rec.routing_id ;
762:
763: EXCEPTION