4224:
4225: IF (p_osfm_batch_id is null) THEN
4226:
4227: --
4228: -- Set L_OSFM_BATCH_ID to the next Sequence of WSM_LOT_JOB_INTERFACE_S.
4229: --
4230:
4231: BEGIN
4232: SELECT WSM_LOT_JOB_INTERFACE_S.NEXTVAL
4228: -- Set L_OSFM_BATCH_ID to the next Sequence of WSM_LOT_JOB_INTERFACE_S.
4229: --
4230:
4231: BEGIN
4232: SELECT WSM_LOT_JOB_INTERFACE_S.NEXTVAL
4233: INTO l_osfm_batch_id
4234: FROM SYS.DUAL;
4235: EXCEPTION
4236: WHEN no_data_found THEN
4234: FROM SYS.DUAL;
4235: EXCEPTION
4236: WHEN no_data_found THEN
4237: IF G_TRACE_ON = 1 THEN
4238: print_debug('Exception: WSM_LOT_JOB_INTERFACE_S.NEXTVAL is not defined'
4239: , 're_wip'
4240: , 9);
4241: END IF;
4242: RAISE wip_exc;