471:
472: lv_output := dbms_lock.request(lv_handle, 6, 32767, TRUE);
473:
474: if(lv_output <> 0) then
475: FND_MESSAGE.SET_NAME('MRP', 'GEN-LOCK-WARNING');
476: FND_MESSAGE.SET_TOKEN('EVENT', 'RELEASE PLANNED ORDERS');
477: lv_error_stmt := FND_MESSAGE.GET;
478: raise_application_error(-20000, lv_error_stmt);
479: end if;
472: lv_output := dbms_lock.request(lv_handle, 6, 32767, TRUE);
473:
474: if(lv_output <> 0) then
475: FND_MESSAGE.SET_NAME('MRP', 'GEN-LOCK-WARNING');
476: FND_MESSAGE.SET_TOKEN('EVENT', 'RELEASE PLANNED ORDERS');
477: lv_error_stmt := FND_MESSAGE.GET;
478: raise_application_error(-20000, lv_error_stmt);
479: end if;
480:
473:
474: if(lv_output <> 0) then
475: FND_MESSAGE.SET_NAME('MRP', 'GEN-LOCK-WARNING');
476: FND_MESSAGE.SET_TOKEN('EVENT', 'RELEASE PLANNED ORDERS');
477: lv_error_stmt := FND_MESSAGE.GET;
478: raise_application_error(-20000, lv_error_stmt);
479: end if;
480:
481: -- Get the hour uom code
603:
604:
605:
606: IF lv_ret_code=-1 THEN --custom hook returned error
607: FND_MESSAGE.SET_NAME('MSC','MSC_ERROR_REL_CUSTOM_HOOK');
608: RAISE_APPLICATION_ERROR(-20000,FND_MESSAGE.GET||lv_error_buf,TRUE);
609: END IF;
610: */
611:
604:
605:
606: IF lv_ret_code=-1 THEN --custom hook returned error
607: FND_MESSAGE.SET_NAME('MSC','MSC_ERROR_REL_CUSTOM_HOOK');
608: RAISE_APPLICATION_ERROR(-20000,FND_MESSAGE.GET||lv_error_buf,TRUE);
609: END IF;
610: */
611:
612: