107: WHERE event_spec_disp_id = p_event_spec_disp_id
108: AND result_id = p_result_id
109: ;
110: ELSE
111: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SPEC_RESULTS');
112: RETURN FALSE;
113: END IF;
114:
115: IF (SQL%FOUND) THEN
114:
115: IF (SQL%FOUND) THEN
116: RETURN TRUE;
117: ELSE
118: GMD_API_PUB.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SPEC_RESULTS');
119: RETURN FALSE;
120: END IF;
121:
122: EXCEPTION
120: END IF;
121:
122: EXCEPTION
123: WHEN locked_by_other_user THEN
124: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',
125: 'TABLE_NAME', 'GMD_SPEC_RESULTS',
126: 'RECORD','Result',
127: 'KEY', p_event_spec_disp_id);
128: RETURN FALSE;
157: WHERE event_spec_disp_id = p_event_spec_disp_id
158: AND result_id = p_result_id
159: FOR UPDATE NOWAIT;
160: ELSE
161: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SPEC_RESULTS');
162: RETURN FALSE;
163: END IF;
164:
165: RETURN TRUE;
165: RETURN TRUE;
166:
167: EXCEPTION
168: WHEN locked_by_other_user THEN
169: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',
170: 'TABLE_NAME', 'GMD_SPEC_RESULTS',
171: 'RECORD','Result',
172: 'KEY', p_event_spec_disp_id);
173: RETURN FALSE;
196: WHERE event_spec_disp_id = p_spec_results.event_spec_disp_id
197: AND result_id = p_spec_results.result_id
198: ;
199: ELSE
200: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SPEC_RESULTS');
201: RETURN FALSE;
202: END IF;
203:
204: -- BUG 2690469
208:
209: EXCEPTION
210: WHEN NO_DATA_FOUND
211: THEN
212: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SPEC_RESULTS');
213: RETURN FALSE;
214: WHEN OTHERS
215: THEN
216: fnd_msg_pub.add_exc_msg ('GMD_SPEC_RESULTS_PVT', 'FETCH_ROW');