DBA Data[Home] [Help]

APPS.GMD_SAMPLING_EVENTS_PVT dependencies on GMD_API_PUB

Line 194: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SAMPLING_EVENTS');

190: DELETE gmd_sampling_events
191: WHERE sampling_event_id = p_sampling_event_id
192: ;
193: ELSE
194: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SAMPLING_EVENTS');
195: RETURN FALSE;
196: END IF;
197:
198: IF (SQL%FOUND) THEN

Line 201: GMD_API_PUB.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SAMPLING_EVENTS');

197:
198: IF (SQL%FOUND) THEN
199: RETURN TRUE;
200: ELSE
201: GMD_API_PUB.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SAMPLING_EVENTS');
202: RETURN FALSE;
203: END IF;
204:
205: EXCEPTION

Line 207: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',

203: END IF;
204:
205: EXCEPTION
206: WHEN locked_by_other_user THEN
207: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',
208: 'TABLE_NAME', 'GMD_SAMPLING_EVENTS',
209: 'RECORD','Sampling Event',
210: 'KEY', p_sampling_event_id);
211: RETURN FALSE;

Line 238: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SAMPLING_EVENTS');

234: FROM gmd_sampling_events
235: WHERE sampling_event_id = p_sampling_event_id
236: FOR UPDATE NOWAIT;
237: ELSE
238: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SAMPLING_EVENTS');
239: RETURN FALSE;
240: END IF;
241:
242: RETURN TRUE;

Line 246: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',

242: RETURN TRUE;
243:
244: EXCEPTION
245: WHEN locked_by_other_user THEN
246: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',
247: 'TABLE_NAME', 'GMD_SAMPLING_EVENTS',
248: 'RECORD','Sampling Event',
249: 'KEY', p_sampling_event_id);
250: RETURN FALSE;

Line 276: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SAMPLING_EVENTS');

272: WHERE sampling_event_id = p_sampling_events.sampling_event_id
273: ;
274: RETURN TRUE;
275: ELSE
276: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SAMPLING_EVENTS');
277: RETURN FALSE;
278: END IF;
279:
280: EXCEPTION

Line 283: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SAMPLING_EVENTS');

279:
280: EXCEPTION
281: WHEN NO_DATA_FOUND
282: THEN
283: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SAMPLING_EVENTS');
284: RETURN FALSE;
285: WHEN OTHERS
286: THEN
287: fnd_msg_pub.add_exc_msg ('GMD_SAMPLING_EVENTS_PVT', 'FETCH_ROW');