APPS.FM_ROUT_DEP_DBL dependencies on FND_MSG_PUB

Line 110: FND_MSG_PUB.ADD;

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

Line 197: FND_MSG_PUB.ADD;

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

Line 204: FND_MSG_PUB.ADD;

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

Line 209: FND_MSG_PUB.ADD;

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

Line 258: FND_MSG_PUB.ADD;

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

Line 265: FND_MSG_PUB.ADD;

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

Line 272: FND_MSG_PUB.ADD;

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

Line 348: FND_MSG_PUB.ADD;

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

Line 355: FND_MSG_PUB.ADD;

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

Line 361: FND_MSG_PUB.ADD;

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

Line 366: FND_MSG_PUB.ADD;

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