APPS.FM_ROUT_DEP_DBL dependencies on FND_MSG_PUB

Line 111: FND_MSG_PUB.ADD;

107: EXCEPTION
108: WHEN OTHERS THEN
109: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
110: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
111: FND_MSG_PUB.ADD;
112: RETURN FALSE;
113: END insert_row;
114:
115:

Line 198: FND_MSG_PUB.ADD;

194: AND routing_id = p_out_dep.routing_id
195: ;
196: ELSE
197: FND_MESSAGE.SET_NAME('GMD', 'GMD_MISSING_KEY_VALUES');
198: FND_MSG_PUB.ADD;
199: RETURN FALSE;
200: END IF;
201: RETURN TRUE;
202: EXCEPTION

Line 205: FND_MSG_PUB.ADD;

201: RETURN TRUE;
202: EXCEPTION
203: WHEN NO_DATA_FOUND THEN
204: FND_MESSAGE.SET_NAME('GMD', 'GMD_NO_DEPEND_GIVEN_KEYS');
205: FND_MSG_PUB.ADD;
206: RETURN FALSE;
207: WHEN OTHERS THEN
208: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
209: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

Line 210: FND_MSG_PUB.ADD;

206: RETURN FALSE;
207: WHEN OTHERS THEN
208: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
209: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
210: FND_MSG_PUB.ADD;
211: RETURN FALSE;
212: END fetch_row;
213:
214:

Line 259: FND_MSG_PUB.ADD;

255: AND routing_id = p_out_dep.routing_id
256: ;
257: ELSE
258: FND_MESSAGE.SET_NAME('GMD', 'GMD_MISSING_KEY_VALUES');
259: FND_MSG_PUB.ADD;
260: RETURN FALSE;
261: END IF;
262: IF SQL%FOUND THEN
263: RETURN TRUE;

Line 266: FND_MSG_PUB.ADD;

262: IF SQL%FOUND THEN
263: RETURN TRUE;
264: ELSE
265: FND_MESSAGE.SET_NAME('GMD', 'GMD_NO_DEPEND_GIVEN_KEYS');
266: FND_MSG_PUB.ADD;
267: RETURN FALSE;
268: END IF;
269: EXCEPTION
270: WHEN OTHERS THEN

Line 273: FND_MSG_PUB.ADD;

269: EXCEPTION
270: WHEN OTHERS THEN
271: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
272: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
273: FND_MSG_PUB.ADD;
274: RETURN FALSE;
275: END delete_row;
276:
277:

Line 349: FND_MSG_PUB.ADD;

345: AND routing_id = p_out_dep.routing_id
346: AND last_update_date = p_out_dep.last_update_date;
347: ELSE
348: FND_MESSAGE.SET_NAME('GMD', 'GMD_MISSING_KEY_VALUES');
349: FND_MSG_PUB.ADD;
350: RETURN FALSE;
351: END IF;
352: IF SQL%FOUND THEN
353: RETURN TRUE;

Line 356: FND_MSG_PUB.ADD;

352: IF SQL%FOUND THEN
353: RETURN TRUE;
354: ELSE
355: FND_MESSAGE.SET_NAME('GMD', 'GMD_NO_DEPEND_GIVEN_KEYS');
356: FND_MSG_PUB.ADD;
357: RETURN FALSE;
358: END IF;
359: EXCEPTION
360: WHEN NO_DATA_FOUND THEN

Line 362: FND_MSG_PUB.ADD;

358: END IF;
359: EXCEPTION
360: WHEN NO_DATA_FOUND THEN
361: FND_MESSAGE.SET_NAME('GMD', 'GMD_DEPEND_LOCK_FAILURE');
362: FND_MSG_PUB.ADD;
363: RETURN FALSE;
364: WHEN OTHERS THEN
365: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
366: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

Line 367: FND_MSG_PUB.ADD;

363: RETURN FALSE;
364: WHEN OTHERS THEN
365: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
366: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
367: FND_MSG_PUB.ADD;
368: RETURN FALSE;
369: END update_row;
370:
371: