622: --anraj, validation to check whether atleast one task is in planning
623: OPEN c_any_task_in_planning(p_visit_id);
624: FETCH c_any_task_in_planning INTO l_dummy;
625: IF c_any_task_in_planning%NOTFOUND THEN
626: Fnd_Message.SET_NAME('AHL','AHL_LTP_CHK_AVL_ALL_NONE_PLAN');
627: Fnd_Msg_Pub.ADD;
628: CLOSE c_any_task_in_planning;
629: RAISE Fnd_Api.G_EXC_ERROR;
630: END IF;
1169: --anraj, validation to check whether atleast one task is in planning
1170: OPEN c_any_task_in_planning(p_visit_id);
1171: FETCH c_any_task_in_planning INTO l_dummy;
1172: IF c_any_task_in_planning%NOTFOUND THEN
1173: Fnd_Message.SET_NAME('AHL','AHL_LTP_SCHEDULE_ALL_NONE_PLAN');
1174: Fnd_Msg_Pub.ADD;
1175: CLOSE c_any_task_in_planning;
1176: RAISE Fnd_Api.G_EXC_ERROR;
1177: END IF;