APPS.GMD_INVENTORY_SPEC_VRS_PVT dependencies on GMD_API_PUB

Line 218: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_INVENTORY_SPEC_VRS');

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

Line 225: GMD_API_PUB.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_INVENTORY_SPEC_VRS');

221:
222: IF (SQL%FOUND) THEN
223: RETURN TRUE;
224: ELSE
225: GMD_API_PUB.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_INVENTORY_SPEC_VRS');
226: RETURN FALSE;
227: END IF;
228:
229: EXCEPTION

Line 231: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',

227: END IF;
228:
229: EXCEPTION
230: WHEN locked_by_other_user THEN
231: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',
232: 'TABLE_NAME', 'GMD_INVENTORY_SPEC_VRS',
233: 'RECORD','Inventory Spec Validity Rule',
234: 'KEY', p_spec_vr_id);
235: RETURN FALSE;

Line 261: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_INVENTORY_SPEC_VRS');

257: FROM gmd_inventory_spec_vrs
258: WHERE spec_vr_id = p_spec_vr_id
259: FOR UPDATE NOWAIT;
260: ELSE
261: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_INVENTORY_SPEC_VRS');
262: RETURN FALSE;
263: END IF;
264:
265: RETURN TRUE;

Line 269: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',

265: RETURN TRUE;
266:
267: EXCEPTION
268: WHEN locked_by_other_user THEN
269: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',
270: 'TABLE_NAME', 'GMD_INVENTORY_SPEC_VRS',
271: 'RECORD','Inventory Spec Validity Rule',
272: 'KEY', p_spec_vr_id);
273: RETURN FALSE;

Line 298: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_INVENTORY_SPEC_VRS');

294: FROM gmd_inventory_spec_vrs
295: WHERE spec_vr_id = p_inventory_spec_vrs.spec_vr_id
296: ;
297: ELSE
298: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_INVENTORY_SPEC_VRS');
299: RETURN FALSE;
300: END IF;
301:
302: RETURN TRUE;

Line 307: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_INVENTORY_SPEC_VRS');

303:
304: EXCEPTION
305: WHEN NO_DATA_FOUND
306: THEN
307: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_INVENTORY_SPEC_VRS');
308: RETURN FALSE;
309: WHEN OTHERS
310: THEN
311: fnd_msg_pub.add_exc_msg ('GMD_INVENTORY_SPEC_VRS_PVT', 'FETCH_ROW');