1391: ELSIF (SUBSTR(p_message_code, 1, 3) = 'OZF') THEN
1392: l_product_code := 'OZF';
1393: END IF;
1394:
1395: FND_MESSAGE.SET_NAME (l_product_code,p_message_code);
1396:
1397: FOR c_token IN c_get_rectype LOOP
1398:
1399: IF (c_token.param_type = 'LOOKUP') THEN
1409:
1410: FETCH l_meaning_cursor INTO l_lookup_text;
1411: CLOSE l_meaning_cursor;
1412:
1413: FND_MESSAGE.SET_TOKEN(c_token.param_name , l_lookup_text);
1414:
1415: ELSIF (c_token.param_type = 'MESSAGE') THEN
1416:
1417: FND_MESSAGE.SET_TOKEN(c_token.param_name
1413: FND_MESSAGE.SET_TOKEN(c_token.param_name , l_lookup_text);
1414:
1415: ELSIF (c_token.param_type = 'MESSAGE') THEN
1416:
1417: FND_MESSAGE.SET_TOKEN(c_token.param_name
1418: , FND_MESSAGE.GET_STRING(l_product_code,c_token.param_value));
1419:
1420: ELSIF (c_token.param_type = 'NOTE') THEN
1421:
1414:
1415: ELSIF (c_token.param_type = 'MESSAGE') THEN
1416:
1417: FND_MESSAGE.SET_TOKEN(c_token.param_name
1418: , FND_MESSAGE.GET_STRING(l_product_code,c_token.param_value));
1419:
1420: ELSIF (c_token.param_type = 'NOTE') THEN
1421:
1422: l_note_text := null;
1431:
1432: IF l_note_text IS NULL THEN
1433: l_note_text := '';
1434: ELSE
1435: l_note_text := FND_MESSAGE.GET_STRING(l_product_code,'PV_NOTE_TEXT')
1436: || ': ' || l_note_text;
1437: END IF;
1438:
1439: FND_MESSAGE.SET_TOKEN(c_token.param_name, l_note_text);
1435: l_note_text := FND_MESSAGE.GET_STRING(l_product_code,'PV_NOTE_TEXT')
1436: || ': ' || l_note_text;
1437: END IF;
1438:
1439: FND_MESSAGE.SET_TOKEN(c_token.param_name, l_note_text);
1440:
1441: ELSE
1442: FND_MESSAGE.SET_TOKEN(c_token.param_name , c_token.param_value);
1443: END IF;
1438:
1439: FND_MESSAGE.SET_TOKEN(c_token.param_name, l_note_text);
1440:
1441: ELSE
1442: FND_MESSAGE.SET_TOKEN(c_token.param_name , c_token.param_value);
1443: END IF;
1444:
1445: END LOOP;
1446: l_msg_text := FND_MESSAGE.GET;
1442: FND_MESSAGE.SET_TOKEN(c_token.param_name , c_token.param_value);
1443: END IF;
1444:
1445: END LOOP;
1446: l_msg_text := FND_MESSAGE.GET;
1447:
1448: RETURN l_msg_text;
1449:
1450: END get_message_from_param;