APPS.GMD_SUPPLIER_SPEC_VRS_PVT dependencies on GMD_API_PUB

Line 221: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SUPPLIER_SPEC_VRS');

217: last_update_login = NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID)
218: WHERE spec_vr_id = p_spec_vr_id
219: ;
220: ELSE
221: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SUPPLIER_SPEC_VRS');
222: RETURN FALSE;
223: END IF;
224:
225: IF (SQL%FOUND) THEN

Line 228: GMD_API_PUB.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SUPPLIER_SPEC_VRS');

224:
225: IF (SQL%FOUND) THEN
226: RETURN TRUE;
227: ELSE
228: GMD_API_PUB.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SUPPLIER_SPEC_VRS');
229: RETURN FALSE;
230: END IF;
231:
232: EXCEPTION

Line 234: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',

230: END IF;
231:
232: EXCEPTION
233: WHEN locked_by_other_user THEN
234: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',
235: 'TABLE_NAME', 'GMD_SUPPLIER_SPEC_VRS',
236: 'RECORD','Supplier Spec Validity Rule',
237: 'KEY', p_spec_vr_id);
238: RETURN FALSE;

Line 265: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SUPPLIER_SPEC_VRS');

261: FROM gmd_supplier_spec_vrs
262: WHERE spec_vr_id = p_spec_vr_id
263: FOR UPDATE NOWAIT;
264: ELSE
265: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SUPPLIER_SPEC_VRS');
266: RETURN FALSE;
267: END IF;
268:
269: RETURN TRUE;

Line 273: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',

269: RETURN TRUE;
270:
271: EXCEPTION
272: WHEN locked_by_other_user THEN
273: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',
274: 'TABLE_NAME', 'GMD_SUPPLIER_SPEC_VRS',
275: 'RECORD','Supplier Spec Validity Rule',
276: 'KEY', p_spec_vr_id);
277: RETURN FALSE;

Line 302: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SUPPLIER_SPEC_VRS');

298: FROM gmd_supplier_spec_vrs
299: WHERE spec_vr_id = p_supplier_spec_vrs.spec_vr_id
300: ;
301: ELSE
302: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_SUPPLIER_SPEC_VRS');
303: RETURN FALSE;
304: END IF;
305:
306: RETURN TRUE;

Line 311: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SUPPLIER_SPEC_VRS');

307:
308: EXCEPTION
309: WHEN NO_DATA_FOUND
310: THEN
311: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_SUPPLIER_SPEC_VRS');
312: RETURN FALSE;
313: WHEN OTHERS
314: THEN
315: fnd_msg_pub.add_exc_msg ('GMD_SUPPLIER_SPEC_VRS_PVT', 'FETCH_ROW');