APPS.GMD_MONITORING_SPEC_VRS_PVT dependencies on GMD_API_PUB

Line 190: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_MONITORING_SPEC_VRS');

186: last_update_login = NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID)
187: WHERE spec_vr_id = p_spec_vr_id
188: ;
189: ELSE
190: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_MONITORING_SPEC_VRS');
191: RETURN FALSE;
192: END IF;
193:
194: IF (SQL%FOUND) THEN

Line 197: GMD_API_PUB.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_MONITORING_SPEC_VRS');

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

Line 203: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',

199: END IF;
200:
201: EXCEPTION
202: WHEN locked_by_other_user THEN
203: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',
204: 'TABLE_NAME', 'GMD_MONITORING_SPEC_VRS',
205: 'RECORD','monitoring Spec Validity Rule',
206: 'KEY', p_spec_vr_id);
207: RETURN FALSE;

Line 234: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_MONITORING_SPEC_VRS');

230: FROM gmd_monitoring_spec_vrs
231: WHERE spec_vr_id = p_spec_vr_id
232: FOR UPDATE NOWAIT;
233: ELSE
234: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_MONITORING_SPEC_VRS');
235: RETURN FALSE;
236: END IF;
237:
238: RETURN TRUE;

Line 242: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',

238: RETURN TRUE;
239:
240: EXCEPTION
241: WHEN locked_by_other_user THEN
242: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',
243: 'TABLE_NAME', 'GMD_MONITORING_SPEC_VRS',
244: 'RECORD','monitoring Spec Validity Rule',
245: 'KEY', p_spec_vr_id);
246: RETURN FALSE;

Line 271: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_MONITORING_SPEC_VRS');

267: FROM gmd_monitoring_spec_vrs
268: WHERE spec_vr_id = p_monitoring_spec_vrs.spec_vr_id
269: ;
270: ELSE
271: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_MONITORING_SPEC_VRS');
272: RETURN FALSE;
273: END IF;
274:
275: RETURN TRUE;

Line 280: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_MONITORING_SPEC_VRS');

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