471: CLOSE Cemp;
472:
473: IF x_emp_found = FALSE THEN
474: FND_MESSAGE.SET_NAME('WIP', 'WIP_RELEASE_VALID_EMPLOYEE');
475: APP_EXCEPTION.RAISE_EXCEPTION;
476: END IF;
477:
478: OPEN Cops;
479: FETCH Cops INTO X_dummy;
481: CLOSE Cops;
482:
483: IF x_no_loc_found = TRUE THEN
484: FND_MESSAGE.SET_NAME('WIP', 'WIP_RELEASE_PO_MOVE');
485: APP_EXCEPTION.RAISE_EXCEPTION;
486: END IF;
487:
488: IF P_Repetitive_Schedule_Id IS NULL THEN
489: OPEN Cproject;