APPS.GMD_WIP_SPEC_VRS_PVT dependencies on GMD_API_PUB

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

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

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

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

Line 259: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',

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

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

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

Line 298: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',

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

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

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

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

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