APPS.GMD_INVENTORY_SPEC_VRS_PVT dependencies on GMD_API_PUB

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

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

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

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

Line 228: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',

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

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

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

Line 266: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',

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

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

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

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

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