APPS.GMD_SUPPLIER_SPEC_VRS_PVT dependencies on GMD_API_PUB

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

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

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

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

Line 237: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',

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

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

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

Line 276: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',

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

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

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

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

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