119:
120: EXCEPTION
121: WHEN FND_API.G_EXC_ERROR THEN
122: IF (x_msg_data IS NULL) THEN
123: FND_MSG_PUB.Count_And_Get
124: ( p_encoded => FND_API.G_FALSE
125: , p_count => x_msg_count
126: , p_data => x_msg_data
127: );
128: END IF;
129: x_return_status := FND_API.G_RET_STS_ERROR;
130: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
131: IF (x_msg_data IS NULL) THEN
132: FND_MSG_PUB.Count_And_Get
133: ( p_encoded => FND_API.G_FALSE
134: , p_count => x_msg_count
135: , p_data => x_msg_data
136: );
264:
265: EXCEPTION
266: WHEN FND_API.G_EXC_ERROR THEN
267: IF (x_msg_data IS NULL) THEN
268: FND_MSG_PUB.Count_And_Get
269: ( p_encoded => FND_API.G_FALSE
270: , p_count => x_msg_count
271: , p_data => x_msg_data
272: );
273: END IF;
274: x_return_status := FND_API.G_RET_STS_ERROR;
275: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
276: IF (x_msg_data IS NULL) THEN
277: FND_MSG_PUB.Count_And_Get
278: ( p_encoded => FND_API.G_FALSE
279: , p_count => x_msg_count
280: , p_data => x_msg_data
281: );
329:
330: EXCEPTION
331: WHEN FND_API.G_EXC_ERROR THEN
332: IF (x_msg_data IS NULL) THEN
333: FND_MSG_PUB.Count_And_Get
334: ( p_encoded => FND_API.G_FALSE
335: , p_count => x_msg_count
336: , p_data => x_msg_data
337: );
338: END IF;
339: x_return_status := FND_API.G_RET_STS_ERROR;
340: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
341: IF (x_msg_data IS NULL) THEN
342: FND_MSG_PUB.Count_And_Get
343: ( p_encoded => FND_API.G_FALSE
344: , p_count => x_msg_count
345: , p_data => x_msg_data
346: );
389:
390: EXCEPTION
391: WHEN FND_API.G_EXC_ERROR THEN
392: IF (x_msg_data IS NULL) THEN
393: FND_MSG_PUB.Count_And_Get
394: ( p_encoded => FND_API.G_FALSE
395: , p_count => x_msg_count
396: , p_data => x_msg_data
397: );
398: END IF;
399: x_return_status := FND_API.G_RET_STS_ERROR;
400: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
401: IF (x_msg_data IS NULL) THEN
402: FND_MSG_PUB.Count_And_Get
403: ( p_encoded => FND_API.G_FALSE
404: , p_count => x_msg_count
405: , p_data => x_msg_data
406: );
452:
453: EXCEPTION
454: WHEN FND_API.G_EXC_ERROR THEN
455: IF (x_msg_data IS NULL) THEN
456: FND_MSG_PUB.Count_And_Get
457: ( p_encoded => FND_API.G_FALSE
458: , p_count => x_msg_count
459: , p_data => x_msg_data
460: );
461: END IF;
462: x_return_status := FND_API.G_RET_STS_ERROR;
463: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
464: IF (x_msg_data IS NULL) THEN
465: FND_MSG_PUB.Count_And_Get
466: ( p_encoded => FND_API.G_FALSE
467: , p_count => x_msg_count
468: , p_data => x_msg_data
469: );
514:
515: EXCEPTION
516: WHEN FND_API.G_EXC_ERROR THEN
517: IF (x_msg_data IS NULL) THEN
518: FND_MSG_PUB.Count_And_Get
519: ( p_encoded => FND_API.G_FALSE
520: , p_count => x_msg_count
521: , p_data => x_msg_data
522: );
523: END IF;
524: x_return_status := FND_API.G_RET_STS_ERROR;
525: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
526: IF (x_msg_data IS NULL) THEN
527: FND_MSG_PUB.Count_And_Get
528: ( p_encoded => FND_API.G_FALSE
529: , p_count => x_msg_count
530: , p_data => x_msg_data
531: );
563: x_return_status := FND_API.G_RET_STS_SUCCESS;
564: EXCEPTION
565: WHEN FND_API.G_EXC_ERROR THEN
566: IF (x_msg_data IS NULL) THEN
567: FND_MSG_PUB.Count_And_Get
568: ( p_encoded => FND_API.G_FALSE
569: , p_count => x_msg_count
570: , p_data => x_msg_data
571: );
572: END IF;
573: x_return_status := FND_API.G_RET_STS_ERROR;
574: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
575: IF (x_msg_data IS NULL) THEN
576: FND_MSG_PUB.Count_And_Get
577: ( p_encoded => FND_API.G_FALSE
578: , p_count => x_msg_count
579: , p_data => x_msg_data
580: );
613: x_return_status := FND_API.G_RET_STS_SUCCESS;
614: EXCEPTION
615: WHEN FND_API.G_EXC_ERROR THEN
616: IF (x_msg_data IS NULL) THEN
617: FND_MSG_PUB.Count_And_Get
618: ( p_encoded => FND_API.G_FALSE
619: , p_count => x_msg_count
620: , p_data => x_msg_data
621: );
622: END IF;
623: x_return_status := FND_API.G_RET_STS_ERROR;
624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
625: IF (x_msg_data IS NULL) THEN
626: FND_MSG_PUB.Count_And_Get
627: ( p_encoded => FND_API.G_FALSE
628: , p_count => x_msg_count
629: , p_data => x_msg_data
630: );
738:
739: EXCEPTION
740: WHEN FND_API.G_EXC_ERROR THEN
741: IF (x_msg_data IS NULL) THEN
742: FND_MSG_PUB.Count_And_Get
743: ( p_encoded => FND_API.G_FALSE
744: , p_count => x_msg_count
745: , p_data => x_msg_data
746: );
747: END IF;
748: x_return_status := FND_API.G_RET_STS_ERROR;
749: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
750: IF (x_msg_data IS NULL) THEN
751: FND_MSG_PUB.Count_And_Get
752: ( p_encoded => FND_API.G_FALSE
753: , p_count => x_msg_count
754: , p_data => x_msg_data
755: );
853:
854: EXCEPTION
855: WHEN FND_API.G_EXC_ERROR THEN
856: IF (x_msg_data IS NULL) THEN
857: FND_MSG_PUB.Count_And_Get
858: ( p_encoded => FND_API.G_FALSE
859: , p_count => x_msg_count
860: , p_data => x_msg_data
861: );
862: END IF;
863: x_return_status := FND_API.G_RET_STS_ERROR;
864: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
865: IF (x_msg_data IS NULL) THEN
866: FND_MSG_PUB.Count_And_Get
867: ( p_encoded => FND_API.G_FALSE
868: , p_count => x_msg_count
869: , p_data => x_msg_data
870: );
919:
920: EXCEPTION
921: WHEN FND_API.G_EXC_ERROR THEN
922: IF (x_msg_data IS NULL) THEN
923: FND_MSG_PUB.Count_And_Get
924: ( p_encoded => FND_API.G_FALSE
925: , p_count => x_msg_count
926: , p_data => x_msg_data
927: );
928: END IF;
929: x_return_status := FND_API.G_RET_STS_ERROR;
930: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
931: IF (x_msg_data IS NULL) THEN
932: FND_MSG_PUB.Count_And_Get
933: ( p_encoded => FND_API.G_FALSE
934: , p_count => x_msg_count
935: , p_data => x_msg_data
936: );
979:
980: EXCEPTION
981: WHEN FND_API.G_EXC_ERROR THEN
982: IF (x_msg_data IS NULL) THEN
983: FND_MSG_PUB.Count_And_Get
984: ( p_encoded => FND_API.G_FALSE
985: , p_count => x_msg_count
986: , p_data => x_msg_data
987: );
988: END IF;
989: x_return_status := FND_API.G_RET_STS_ERROR;
990: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
991: IF (x_msg_data IS NULL) THEN
992: FND_MSG_PUB.Count_And_Get
993: ( p_encoded => FND_API.G_FALSE
994: , p_count => x_msg_count
995: , p_data => x_msg_data
996: );
1038:
1039: EXCEPTION
1040: WHEN FND_API.G_EXC_ERROR THEN
1041: IF (x_msg_data IS NULL) THEN
1042: FND_MSG_PUB.Count_And_Get
1043: ( p_encoded => FND_API.G_FALSE
1044: , p_count => x_msg_count
1045: , p_data => x_msg_data
1046: );
1047: END IF;
1048: x_return_status := FND_API.G_RET_STS_ERROR;
1049: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1050: IF (x_msg_data IS NULL) THEN
1051: FND_MSG_PUB.Count_And_Get
1052: ( p_encoded => FND_API.G_FALSE
1053: , p_count => x_msg_count
1054: , p_data => x_msg_data
1055: );
1095:
1096: EXCEPTION
1097: WHEN FND_API.G_EXC_ERROR THEN
1098: IF (x_msg_data IS NULL) THEN
1099: FND_MSG_PUB.Count_And_Get
1100: ( p_encoded => FND_API.G_FALSE
1101: , p_count => x_msg_count
1102: , p_data => x_msg_data
1103: );
1104: END IF;
1105: x_return_status := FND_API.G_RET_STS_ERROR;
1106: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1107: IF (x_msg_data IS NULL) THEN
1108: FND_MSG_PUB.Count_And_Get
1109: ( p_encoded => FND_API.G_FALSE
1110: , p_count => x_msg_count
1111: , p_data => x_msg_data
1112: );
1160:
1161: EXCEPTION
1162: WHEN FND_API.G_EXC_ERROR THEN
1163: IF (x_msg_data IS NULL) THEN
1164: FND_MSG_PUB.Count_And_Get
1165: ( p_encoded => FND_API.G_FALSE
1166: , p_count => x_msg_count
1167: , p_data => x_msg_data
1168: );
1169: END IF;
1170: x_return_status := FND_API.G_RET_STS_ERROR;
1171: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1172: IF (x_msg_data IS NULL) THEN
1173: FND_MSG_PUB.Count_And_Get
1174: ( p_encoded => FND_API.G_FALSE
1175: , p_count => x_msg_count
1176: , p_data => x_msg_data
1177: );
1233:
1234: EXCEPTION
1235: WHEN FND_API.G_EXC_ERROR THEN
1236: IF (x_msg_data IS NULL) THEN
1237: FND_MSG_PUB.Count_And_Get
1238: ( p_encoded => FND_API.G_FALSE
1239: , p_count => x_msg_count
1240: , p_data => x_msg_data
1241: );
1242: END IF;
1243: x_return_status := FND_API.G_RET_STS_ERROR;
1244: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1245: IF (x_msg_data IS NULL) THEN
1246: FND_MSG_PUB.Count_And_Get
1247: ( p_encoded => FND_API.G_FALSE
1248: , p_count => x_msg_count
1249: , p_data => x_msg_data
1250: );
1289:
1290: EXCEPTION
1291: WHEN FND_API.G_EXC_ERROR THEN
1292: IF (x_msg_data IS NULL) THEN
1293: FND_MSG_PUB.Count_And_Get
1294: ( p_encoded => FND_API.G_FALSE
1295: , p_count => x_msg_count
1296: , p_data => x_msg_data
1297: );
1298: END IF;
1299: x_return_status := FND_API.G_RET_STS_ERROR;
1300: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1301: IF (x_msg_data IS NULL) THEN
1302: FND_MSG_PUB.Count_And_Get
1303: ( p_encoded => FND_API.G_FALSE
1304: , p_count => x_msg_count
1305: , p_data => x_msg_data
1306: );
1343:
1344: EXCEPTION
1345: WHEN FND_API.G_EXC_ERROR THEN
1346: IF (x_msg_data IS NULL) THEN
1347: FND_MSG_PUB.Count_And_Get
1348: ( p_encoded => FND_API.G_FALSE
1349: , p_count => x_msg_count
1350: , p_data => x_msg_data
1351: );
1352: END IF;
1353: x_return_status := FND_API.G_RET_STS_ERROR;
1354: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1355: IF (x_msg_data IS NULL) THEN
1356: FND_MSG_PUB.Count_And_Get
1357: ( p_encoded => FND_API.G_FALSE
1358: , p_count => x_msg_count
1359: , p_data => x_msg_data
1360: );
1397:
1398: EXCEPTION
1399: WHEN FND_API.G_EXC_ERROR THEN
1400: IF (x_msg_data IS NULL) THEN
1401: FND_MSG_PUB.Count_And_Get
1402: ( p_encoded => FND_API.G_FALSE
1403: , p_count => x_msg_count
1404: , p_data => x_msg_data
1405: );
1406: END IF;
1407: x_return_status := FND_API.G_RET_STS_ERROR;
1408: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1409: IF (x_msg_data IS NULL) THEN
1410: FND_MSG_PUB.Count_And_Get
1411: ( p_encoded => FND_API.G_FALSE
1412: , p_count => x_msg_count
1413: , p_data => x_msg_data
1414: );
1455:
1456: EXCEPTION
1457: WHEN FND_API.G_EXC_ERROR THEN
1458: x_return_status := FND_API.G_RET_STS_ERROR;
1459: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1460: ,p_data => x_msg_data);
1461: RAISE;
1462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1460: ,p_data => x_msg_data);
1461: RAISE;
1462: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1464: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1465: ,p_data => x_msg_data);
1466: RAISE;
1467: WHEN NO_DATA_FOUND THEN
1468: x_return_status := FND_API.G_RET_STS_ERROR;
1465: ,p_data => x_msg_data);
1466: RAISE;
1467: WHEN NO_DATA_FOUND THEN
1468: x_return_status := FND_API.G_RET_STS_ERROR;
1469: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1470: ,p_data => x_msg_data);
1471: RAISE;
1472: WHEN OTHERS THEN
1473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1470: ,p_data => x_msg_data);
1471: RAISE;
1472: WHEN OTHERS THEN
1473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1474: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1475: ,p_data => x_msg_data);
1476: RAISE;
1477:
1478: END Translate_Measure;
1502:
1503: EXCEPTION
1504: WHEN FND_API.G_EXC_ERROR THEN
1505: x_return_status := FND_API.G_RET_STS_ERROR;
1506: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1507: ,p_data => x_msg_data);
1508:
1509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1507: ,p_data => x_msg_data);
1508:
1509: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1510: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1511: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1512: ,p_data => x_msg_data);
1513: WHEN NO_DATA_FOUND THEN
1514: x_return_status := FND_API.G_RET_STS_ERROR;
1515: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1511: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1512: ,p_data => x_msg_data);
1513: WHEN NO_DATA_FOUND THEN
1514: x_return_status := FND_API.G_RET_STS_ERROR;
1515: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1516: ,p_data => x_msg_data);
1517: WHEN OTHERS THEN
1518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1519: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1515: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1516: ,p_data => x_msg_data);
1517: WHEN OTHERS THEN
1518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1519: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count
1520: ,p_data => x_msg_data);
1521: END Translate_Measure_By_Lang;
1522:
1523: FUNCTION Get_DataSet_Name(