APPS.GMD_WIP_SPEC_VRS_PVT dependencies on GMD_API_PUB

Line 249: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_WIP_SPEC_VRS');

245: last_update_login = NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID)
246: WHERE spec_vr_id = p_spec_vr_id
247: ;
248: ELSE
249: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_WIP_SPEC_VRS');
250: RETURN FALSE;
251: END IF;
252:
253: IF (SQL%FOUND) THEN

Line 256: GMD_API_PUB.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_WIP_SPEC_VRS');

252:
253: IF (SQL%FOUND) THEN
254: RETURN TRUE;
255: ELSE
256: GMD_API_PUB.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_WIP_SPEC_VRS');
257: RETURN FALSE;
258: END IF;
259:
260: EXCEPTION

Line 262: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',

258: END IF;
259:
260: EXCEPTION
261: WHEN locked_by_other_user THEN
262: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',
263: 'TABLE_NAME', 'GMD_WIP_SPEC_VRS',
264: 'RECORD','WIP Spec Validity Rule',
265: 'KEY', p_spec_vr_id);
266: RETURN FALSE;

Line 293: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_WIP_SPEC_VRS');

289: FROM gmd_wip_spec_vrs
290: WHERE spec_vr_id = p_spec_vr_id
291: FOR UPDATE NOWAIT;
292: ELSE
293: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_WIP_SPEC_VRS');
294: RETURN FALSE;
295: END IF;
296:
297: RETURN TRUE;

Line 301: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',

297: RETURN TRUE;
298:
299: EXCEPTION
300: WHEN locked_by_other_user THEN
301: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',
302: 'TABLE_NAME', 'GMD_WIP_SPEC_VRS',
303: 'RECORD','WIP Spec Validity Rule',
304: 'KEY', p_spec_vr_id);
305: RETURN FALSE;

Line 330: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_WIP_SPEC_VRS');

326: FROM gmd_wip_spec_vrs
327: WHERE spec_vr_id = p_wip_spec_vrs.spec_vr_id
328: ;
329: ELSE
330: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_WIP_SPEC_VRS');
331: RETURN FALSE;
332: END IF;
333:
334: RETURN TRUE;

Line 339: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_WIP_SPEC_VRS');

335:
336: EXCEPTION
337: WHEN NO_DATA_FOUND
338: THEN
339: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_WIP_SPEC_VRS');
340: RETURN FALSE;
341: WHEN OTHERS
342: THEN
343: fnd_msg_pub.add_exc_msg ('GMD_WIP_SPEC_VRS_PVT', 'FETCH_ROW');