210: last_update_date = SYSDATE
211: WHERE result_id = p_result_id
212: ;
213: ELSE
214: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_RESULTS');
215: RETURN FALSE;
216: END IF;
217:
218: IF (SQL%FOUND) THEN
217:
218: IF (SQL%FOUND) THEN
219: RETURN TRUE;
220: ELSE
221: GMD_API_PUB.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_RESULTS');
222: RETURN FALSE;
223: END IF;
224:
225: EXCEPTION
223: END IF;
224:
225: EXCEPTION
226: WHEN locked_by_other_user THEN
227: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',
228: 'TABLE_NAME', 'GMD_RESULTS',
229: 'RECORD','Result',
230: 'KEY', p_result_id);
231: RETURN FALSE;
254: FROM gmd_results
255: WHERE result_id = p_result_id
256: FOR UPDATE NOWAIT;
257: ELSE
258: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_RESULTS');
259: RETURN FALSE;
260: END IF;
261:
262: RETURN TRUE;
262: RETURN TRUE;
263:
264: EXCEPTION
265: WHEN locked_by_other_user THEN
266: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',
267: 'TABLE_NAME', 'GMD_RESULTS',
268: 'RECORD','Result',
269: 'KEY', p_result_id);
270: RETURN FALSE;
306: AND sample_id = p_results.sample_id
307: AND test_replicate_cnt = p_results.test_replicate_cnt;
308:
309: ELSE
310: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_RESULTS');
311: RETURN FALSE;
312: END IF;
313:
314: RETURN TRUE;
315:
316: EXCEPTION
317: WHEN NO_DATA_FOUND
318: THEN
319: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_RESULTS');
320: RETURN FALSE;
321: WHEN OTHERS
322: THEN
323: fnd_msg_pub.add_exc_msg ('GMD_RESULTS_PVT', 'FETCH_ROW');