DBA Data[Home] [Help]

APPS.FM_ROUT_DEP_DBL dependencies on FND_MESSAGE

Line 109: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

105: );
106: RETURN TRUE;
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;

Line 110: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

106: RETURN TRUE;
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:

Line 197: FND_MESSAGE.SET_NAME('GMD', 'GMD_MISSING_KEY_VALUES');

193: AND dep_routingstep_no = p_out_dep.dep_routingstep_no
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;

Line 204: FND_MESSAGE.SET_NAME('GMD', 'GMD_NO_DEPEND_GIVEN_KEYS');

200: END IF;
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');

Line 208: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

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);
210: FND_MSG_PUB.ADD;
211: RETURN FALSE;
212: END fetch_row;

Line 209: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

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);
210: FND_MSG_PUB.ADD;
211: RETURN FALSE;
212: END fetch_row;
213:

Line 258: FND_MESSAGE.SET_NAME('GMD', 'GMD_MISSING_KEY_VALUES');

254: AND dep_routingstep_no = p_out_dep.dep_routingstep_no
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

Line 265: FND_MESSAGE.SET_NAME('GMD', 'GMD_NO_DEPEND_GIVEN_KEYS');

261: END IF;
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

Line 271: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

267: RETURN FALSE;
268: END IF;
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;

Line 272: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

268: END IF;
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:

Line 348: FND_MESSAGE.SET_NAME('GMD', 'GMD_MISSING_KEY_VALUES');

344: AND dep_routingstep_no = p_out_dep.dep_routingstep_no
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

Line 355: FND_MESSAGE.SET_NAME('GMD', 'GMD_NO_DEPEND_GIVEN_KEYS');

351: END IF;
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

Line 361: FND_MESSAGE.SET_NAME('GMD', 'GMD_DEPEND_LOCK_FAILURE');

357: RETURN FALSE;
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');

Line 365: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');

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);
367: FND_MSG_PUB.ADD;
368: RETURN FALSE;
369: END update_row;

Line 366: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);

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);
367: FND_MSG_PUB.ADD;
368: RETURN FALSE;
369: END update_row;
370: