APPS.GMD_SAMPLING_EVENTS_PVT dependencies on GMD_API_PUB

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

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

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

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

Line 205: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',

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

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

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

Line 244: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',

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

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

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

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

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