APPS.GMD_CUSTOMER_SPEC_VRS_PVT dependencies on GMD_API_PUB

Line 204: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_CUSTOMER_SPEC_VRS');

200: last_update_login = NVL(p_last_update_login,FND_GLOBAL.LOGIN_ID)
201: WHERE spec_vr_id = p_spec_vr_id
202: ;
203: ELSE
204: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_CUSTOMER_SPEC_VRS');
205: RETURN FALSE;
206: END IF;
207:
208: IF (SQL%FOUND) THEN

Line 211: GMD_API_PUB.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_CUSTOMER_SPEC_VRS');

207:
208: IF (SQL%FOUND) THEN
209: RETURN TRUE;
210: ELSE
211: GMD_API_PUB.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_CUSTOMER_SPEC_VRS');
212: RETURN FALSE;
213: END IF;
214:
215: EXCEPTION

Line 217: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',

213: END IF;
214:
215: EXCEPTION
216: WHEN locked_by_other_user THEN
217: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',
218: 'TABLE_NAME', 'GMD_CUSTOMER_SPEC_VRS',
219: 'RECORD','Customer Spec Validity Rule',
220: 'KEY', p_spec_vr_id);
221: RETURN FALSE;

Line 248: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_CUSTOMER_SPEC_VRS');

244: FROM gmd_customer_spec_vrs
245: WHERE spec_vr_id = p_spec_vr_id
246: FOR UPDATE NOWAIT;
247: ELSE
248: GMD_API_PUB.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_CUSTOMER_SPEC_VRS');
249: RETURN FALSE;
250: END IF;
251:
252: RETURN TRUE;

Line 256: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',

252: RETURN TRUE;
253:
254: EXCEPTION
255: WHEN locked_by_other_user THEN
256: GMD_API_PUB.log_message('GMD_RECORD_LOCKED',
257: 'TABLE_NAME', 'GMD_CUSTOMER_SPEC_VRS',
258: 'RECORD','Customer Spec Validity Rule',
259: 'KEY', p_spec_vr_id);
260: RETURN FALSE;

Line 285: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_CUSTOMER_SPEC_VRS');

281: FROM gmd_customer_spec_vrs
282: WHERE spec_vr_id = p_customer_spec_vrs.spec_vr_id
283: ;
284: ELSE
285: gmd_api_pub.log_message('GMD_NO_KEYS','TABLE_NAME', 'GMD_CUSTOMER_SPEC_VRS');
286: RETURN FALSE;
287: END IF;
288:
289: RETURN TRUE;

Line 294: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_CUSTOMER_SPEC_VRS');

290:
291: EXCEPTION
292: WHEN NO_DATA_FOUND
293: THEN
294: gmd_api_pub.log_message('GMD_NO_DATA_FOUND','TABLE_NAME', 'GMD_CUSTOMER_SPEC_VRS');
295: RETURN FALSE;
296: WHEN OTHERS
297: THEN
298: fnd_msg_pub.add_exc_msg ('GMD_CUSTOMER_SPEC_VRS_PVT', 'FETCH_ROW');