DBA Data[Home] [Help]

APPS.GMD_COMPOSITE_RESULTS_PVT dependencies on GMD_API_PUB

Line 201: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_COMPOSITE_RESULTS');

197: last_update_login = NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID)
198: WHERE composite_result_id = p_composite_result_id
199: ;
200: ELSE
201: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_COMPOSITE_RESULTS');
202: RETURN FALSE;
203: END IF;
204:
205: IF (SQL%FOUND) THEN

Line 208: GMD_API_PUB.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_COMPOSITE_RESULTS');

204:
205: IF (SQL%FOUND) THEN
206: RETURN TRUE;
207: ELSE
208: GMD_API_PUB.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_COMPOSITE_RESULTS');
209: RETURN FALSE;
210: END IF;
211:
212: EXCEPTION

Line 214: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',

210: END IF;
211:
212: EXCEPTION
213: WHEN locked_by_other_user THEN
214: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',
215: 'TABLE_NAME', 'GMD_COMPOSITE_RESULTS',
216: 'RECORD','Inventory Spec Validity Rule',
217: 'KEY', p_composite_result_id);
218: RETURN FALSE;

Line 244: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_COMPOSITE_RESULTS');

240: FROM gmd_composite_results
241: WHERE composite_result_id = p_composite_result_id
242: FOR UPDATE NOWAIT;
243: ELSE
244: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_COMPOSITE_RESULTS');
245: RETURN FALSE;
246: END IF;
247:
248: RETURN TRUE;

Line 252: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',

248: RETURN TRUE;
249:
250: EXCEPTION
251: WHEN locked_by_other_user THEN
252: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',
253: 'TABLE_NAME', 'GMD_COMPOSITE_RESULTS',
254: 'RECORD','Inventory Spec Validity Rule',
255: 'KEY', p_composite_result_id);
256: RETURN FALSE;

Line 281: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_COMPOSITE_RESULTS');

277: FROM gmd_composite_results
278: WHERE composite_result_id = p_composite_results.composite_result_id
279: ;
280: ELSE
281: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_COMPOSITE_RESULTS');
282: RETURN FALSE;
283: END IF;
284:
285: RETURN TRUE;

Line 290: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_COMPOSITE_RESULTS');

286:
287: EXCEPTION
288: WHEN NO_DATA_FOUND
289: THEN
290: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_COMPOSITE_RESULTS');
291: RETURN FALSE;
292: WHEN OTHERS
293: THEN
294: fnd_msg_pub.add_exc_msg ('GMD_COMPOSITE_RESULTS_PVT', 'FETCH_ROW');