APPS.GMD_SAMPLES_PVT dependencies on GMD_API_PUB

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

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

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

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

Line 337: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',

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

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

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

Line 387: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',

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

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

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

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

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