DBA Data[Home] [Help]

APPS.GMD_SAMPLE_SPEC_DISP_PVT dependencies on GMD_API_PUB

Line 99: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SAMPLE_SPEC_DISP');

95: WHERE event_spec_disp_id = p_event_spec_disp_id
96: AND sample_id = p_sample_id
97: ;
98: ELSE
99: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SAMPLE_SPEC_DISP');
100: RETURN FALSE;
101: END IF;
102:
103: IF (SQL%FOUND) THEN

Line 106: GMD_API_PUB.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SAMPLE_SPEC_DISP');

102:
103: IF (SQL%FOUND) THEN
104: RETURN TRUE;
105: ELSE
106: GMD_API_PUB.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SAMPLE_SPEC_DISP');
107: RETURN FALSE;
108: END IF;
109:
110: EXCEPTION

Line 112: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',

108: END IF;
109:
110: EXCEPTION
111: WHEN locked_by_other_user THEN
112: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',
113: 'TABLE_NAME', 'GMD_SAMPLE_SPEC_DISP',
114: 'RECORD','Result',
115: 'KEY', p_event_spec_disp_id);
116: RETURN FALSE;

Line 149: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SAMPLE_SPEC_DISP');

145: WHERE event_spec_disp_id = p_event_spec_disp_id
146: AND sample_id = p_sample_id
147: FOR UPDATE NOWAIT;
148: ELSE
149: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SAMPLE_SPEC_DISP');
150: RETURN FALSE;
151: END IF;
152:
153: RETURN TRUE;

Line 157: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',

153: RETURN TRUE;
154:
155: EXCEPTION
156: WHEN locked_by_other_user THEN
157: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',
158: 'TABLE_NAME', 'GMD_SAMPLE_SPEC_DISP',
159: 'RECORD','Result',
160: 'KEY', p_event_spec_disp_id);
161: RETURN FALSE;

Line 189: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SAMPLE_SPEC_DISP');

185: AND sample_id = p_sample_spec_disp.sample_id
186: ;
187: RETURN TRUE;
188: ELSE
189: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SAMPLE_SPEC_DISP');
190: RETURN FALSE;
191: END IF;
192:
193: RETURN TRUE;

Line 198: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SAMPLE_SPEC_DISP');

194:
195: EXCEPTION
196: WHEN NO_DATA_FOUND
197: THEN
198: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SAMPLE_SPEC_DISP');
199: RETURN FALSE;
200: WHEN OTHERS
201: THEN
202: fnd_msg_pub.add_exc_msg ('GMD_SAMPLE_SPEC_DISP_PVT', 'FETCH_ROW');