APPS.GMD_SAMPLES_PVT dependencies on GMD_API_PUB

Line 327: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SAMPLES');

323: WHERE organization_id = p_organization_id
324: AND sample_no = p_sample_no
325: ;
326: ELSE
327: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SAMPLES');
328: RETURN FALSE;
329: END IF;
330:
331: IF (SQL%FOUND) THEN

Line 334: GMD_API_PUB.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SAMPLES');

330:
331: IF (SQL%FOUND) THEN
332: RETURN TRUE;
333: ELSE
334: GMD_API_PUB.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SAMPLES');
335: RETURN FALSE;
336: END IF;
337:
338: EXCEPTION

Line 340: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',

336: END IF;
337:
338: EXCEPTION
339: WHEN locked_by_other_user THEN
340: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',
341: 'TABLE_NAME', 'GMD_SAMPLES',
342: 'RECORD','Sample',
343: 'KEY', p_organization_id || p_sample_no);
344: RETURN FALSE;

Line 382: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SAMPLES');

378: WHERE organization_id = p_organization_id
379: AND sample_no = p_sample_no
380: FOR UPDATE NOWAIT;
381: ELSE
382: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SAMPLES');
383: RETURN FALSE;
384: END IF;
385:
386: RETURN TRUE;

Line 390: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',

386: RETURN TRUE;
387:
388: EXCEPTION
389: WHEN locked_by_other_user THEN
390: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',
391: 'TABLE_NAME', 'GMD_SAMPLES',
392: 'RECORD','Sampling Event',
393: 'KEY', p_organization_id || p_sample_no);
394: RETURN FALSE;

Line 430: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SAMPLES');

426: AND sample_no = p_samples.sample_no
427: ;
428: RETURN TRUE;
429: ELSE
430: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SAMPLES');
431: RETURN FALSE;
432: END IF;
433:
434: RETURN FALSE;

Line 439: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SAMPLES');

435:
436: EXCEPTION
437: WHEN NO_DATA_FOUND
438: THEN
439: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SAMPLES');
440: RETURN FALSE;
441: WHEN OTHERS
442: THEN
443: fnd_msg_pub.add_exc_msg ('GMD_SAMPLES_PVT', 'FETCH_ROW');