715:
716: /* Added for Bug 6807835 */
717:
718: --
719: -- Set L_OSFM_BATCH_ID to the next Sequence of WSM_LOT_JOB_INTERFACE_S.
720: --
721:
722: BEGIN
723: SELECT WSM_LOT_JOB_INTERFACE_S.NEXTVAL
719: -- Set L_OSFM_BATCH_ID to the next Sequence of WSM_LOT_JOB_INTERFACE_S.
720: --
721:
722: BEGIN
723: SELECT WSM_LOT_JOB_INTERFACE_S.NEXTVAL
724: INTO l_osfm_batch_id
725: FROM SYS.DUAL;
726: EXCEPTION
727: WHEN no_data_found THEN
725: FROM SYS.DUAL;
726: EXCEPTION
727: WHEN no_data_found THEN
728: IF G_TRACE_ON = 1 THEN
729: print_debug('Exception: WSM_LOT_JOB_INTERFACE_S.NEXTVAL is not defined'
730: , l_proc
731: , 9);
732: END IF;
733: RAISE fnd_api.g_exc_error;