274: END IF;
275: CLOSE c1;
276:
277: IF p_name = 'GMD_UNEXPECTED_ERROR' THEN
278: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
279: FND_MESSAGE.SET_TOKEN('ERROR', l_rec.db_error);
280: ELSE
281: FND_MESSAGE.set_name(NVL(l_rec.msg_app_short_name, 'GMA'), p_name);
282:
275: CLOSE c1;
276:
277: IF p_name = 'GMD_UNEXPECTED_ERROR' THEN
278: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
279: FND_MESSAGE.SET_TOKEN('ERROR', l_rec.db_error);
280: ELSE
281: FND_MESSAGE.set_name(NVL(l_rec.msg_app_short_name, 'GMA'), p_name);
282:
283: IF (l_rec.param1 IS not NULL) THEN
277: IF p_name = 'GMD_UNEXPECTED_ERROR' THEN
278: FND_MESSAGE.SET_NAME('GMD', 'GMD_UNEXPECTED_ERROR');
279: FND_MESSAGE.SET_TOKEN('ERROR', l_rec.db_error);
280: ELSE
281: FND_MESSAGE.set_name(NVL(l_rec.msg_app_short_name, 'GMA'), p_name);
282:
283: IF (l_rec.param1 IS not NULL) THEN
284: FND_MESSAGE.set_token(NVL(l_rec.token1, 'PARAM1'),l_rec.param1);
285: ELSIF (p_name IN ('GMA_MIGRATION_TABLE_SUCCESS', 'GMA_MIGRATION_TABLE_SUCCESS_RW')) THEN
280: ELSE
281: FND_MESSAGE.set_name(NVL(l_rec.msg_app_short_name, 'GMA'), p_name);
282:
283: IF (l_rec.param1 IS not NULL) THEN
284: FND_MESSAGE.set_token(NVL(l_rec.token1, 'PARAM1'),l_rec.param1);
285: ELSIF (p_name IN ('GMA_MIGRATION_TABLE_SUCCESS', 'GMA_MIGRATION_TABLE_SUCCESS_RW')) THEN
286: FND_MESSAGE.set_token('TABLE_NAME', l_rec.table_name);
287: END IF;
288:
282:
283: IF (l_rec.param1 IS not NULL) THEN
284: FND_MESSAGE.set_token(NVL(l_rec.token1, 'PARAM1'),l_rec.param1);
285: ELSIF (p_name IN ('GMA_MIGRATION_TABLE_SUCCESS', 'GMA_MIGRATION_TABLE_SUCCESS_RW')) THEN
286: FND_MESSAGE.set_token('TABLE_NAME', l_rec.table_name);
287: END IF;
288:
289: IF (l_rec.param2 IS not NULL) THEN
290: FND_MESSAGE.set_token(NVL(l_rec.token2, 'PARAM2'),l_rec.param2);
286: FND_MESSAGE.set_token('TABLE_NAME', l_rec.table_name);
287: END IF;
288:
289: IF (l_rec.param2 IS not NULL) THEN
290: FND_MESSAGE.set_token(NVL(l_rec.token2, 'PARAM2'),l_rec.param2);
291: END IF;
292:
293: IF (l_rec.param3 IS not NULL) THEN
294: FND_MESSAGE.set_token(NVL(l_rec.token3, 'PARAM3'),l_rec.param3);
290: FND_MESSAGE.set_token(NVL(l_rec.token2, 'PARAM2'),l_rec.param2);
291: END IF;
292:
293: IF (l_rec.param3 IS not NULL) THEN
294: FND_MESSAGE.set_token(NVL(l_rec.token3, 'PARAM3'),l_rec.param3);
295: END IF;
296:
297: IF (l_rec.param4 IS not NULL) THEN
298: FND_MESSAGE.set_token(NVL(l_rec.token4, 'PARAM4'),l_rec.param4);
294: FND_MESSAGE.set_token(NVL(l_rec.token3, 'PARAM3'),l_rec.param3);
295: END IF;
296:
297: IF (l_rec.param4 IS not NULL) THEN
298: FND_MESSAGE.set_token(NVL(l_rec.token4, 'PARAM4'),l_rec.param4);
299: END IF;
300:
301: IF (l_rec.param5 IS not NULL) THEN
302: FND_MESSAGE.set_token(NVL(l_rec.token5, 'PARAM5'),l_rec.param5);
298: FND_MESSAGE.set_token(NVL(l_rec.token4, 'PARAM4'),l_rec.param4);
299: END IF;
300:
301: IF (l_rec.param5 IS not NULL) THEN
302: FND_MESSAGE.set_token(NVL(l_rec.token5, 'PARAM5'),l_rec.param5);
303: END IF;
304:
305: IF (l_rec.param6 IS not NULL) THEN
306: FND_MESSAGE.set_token(NVL(l_rec.token6, 'PARAM6'),l_rec.param6);
302: FND_MESSAGE.set_token(NVL(l_rec.token5, 'PARAM5'),l_rec.param5);
303: END IF;
304:
305: IF (l_rec.param6 IS not NULL) THEN
306: FND_MESSAGE.set_token(NVL(l_rec.token6, 'PARAM6'),l_rec.param6);
307: END IF;
308: END IF;
309:
310: RETURN FND_MESSAGE.GET;
306: FND_MESSAGE.set_token(NVL(l_rec.token6, 'PARAM6'),l_rec.param6);
307: END IF;
308: END IF;
309:
310: RETURN FND_MESSAGE.GET;
311:
312: EXCEPTION
313: WHEN MISSING_DATA THEN
314: RETURN (p_name);