DBA Data[Home] [Help]

APPS.GMIVDBL dependencies on FND_MESSAGE

Line 308: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');

304: EXCEPTION
305: WHEN OTHERS THEN
306: -- Bug 1764383
307: -- Added code to return sqlerrm in case of unexpected database errors.
308: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
309: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
310: FND_MSG_PUB.ADD;
311:
312: GMIGUTL.DB_ERRNUM := SQLCODE;

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

305: WHEN OTHERS THEN
306: -- Bug 1764383
307: -- Added code to return sqlerrm in case of unexpected database errors.
308: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
309: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
310: FND_MSG_PUB.ADD;
311:
312: GMIGUTL.DB_ERRNUM := SQLCODE;
313: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 405: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');

401: END LOOP;
402: EXCEPTION
403: WHEN OTHERS THEN
404:
405: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
406: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
407: FND_MSG_PUB.ADD;
408:
409: GMIGUTL.DB_ERRNUM := SQLCODE;

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

402: EXCEPTION
403: WHEN OTHERS THEN
404:
405: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
406: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
407: FND_MSG_PUB.ADD;
408:
409: GMIGUTL.DB_ERRNUM := SQLCODE;
410: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 838: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');

834:
835: WHEN OTHERS THEN
836: -- Bug 1764383
837: -- Added code to return sqlerrm in case of unexpected database errors.
838: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
839: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
840: FND_MSG_PUB.ADD;
841:
842: GMIGUTL.DB_ERRNUM := SQLCODE;

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

835: WHEN OTHERS THEN
836: -- Bug 1764383
837: -- Added code to return sqlerrm in case of unexpected database errors.
838: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
839: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
840: FND_MSG_PUB.ADD;
841:
842: GMIGUTL.DB_ERRNUM := SQLCODE;
843: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 983: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');

979: EXCEPTION
980: WHEN OTHERS THEN
981: -- Bug 1764383
982: -- Added code to return sqlerrm in case of unexpected database errors.
983: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
984: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
985: FND_MSG_PUB.ADD;
986:
987: GMIGUTL.DB_ERRNUM := SQLCODE;

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

980: WHEN OTHERS THEN
981: -- Bug 1764383
982: -- Added code to return sqlerrm in case of unexpected database errors.
983: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
984: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
985: FND_MSG_PUB.ADD;
986:
987: GMIGUTL.DB_ERRNUM := SQLCODE;
988: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 1017: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');

1013:
1014: WHEN OTHERS THEN
1015: -- Bug 1764383
1016: -- Added code to return sqlerrm in case of unexpected database errors.
1017: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1018: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1019: FND_MSG_PUB.ADD;
1020:
1021: GMIGUTL.DB_ERRNUM := SQLCODE;

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

1014: WHEN OTHERS THEN
1015: -- Bug 1764383
1016: -- Added code to return sqlerrm in case of unexpected database errors.
1017: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1018: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1019: FND_MSG_PUB.ADD;
1020:
1021: GMIGUTL.DB_ERRNUM := SQLCODE;
1022: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 1063: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');

1059: EXCEPTION
1060: WHEN OTHERS THEN
1061: -- Bug 1764383
1062: -- Added code to return sqlerrm in case of unexpected database errors.
1063: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1064: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1065: FND_MSG_PUB.ADD;
1066:
1067: GMIGUTL.DB_ERRNUM := SQLCODE;

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

1060: WHEN OTHERS THEN
1061: -- Bug 1764383
1062: -- Added code to return sqlerrm in case of unexpected database errors.
1063: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1064: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1065: FND_MSG_PUB.ADD;
1066:
1067: GMIGUTL.DB_ERRNUM := SQLCODE;
1068: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 1096: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');

1092:
1093: WHEN OTHERS THEN
1094: -- Bug 1764383
1095: -- Added code to return sqlerrm in case of unexpected database errors.
1096: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1097: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1098: FND_MSG_PUB.ADD;
1099:
1100: GMIGUTL.DB_ERRNUM := SQLCODE;

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

1093: WHEN OTHERS THEN
1094: -- Bug 1764383
1095: -- Added code to return sqlerrm in case of unexpected database errors.
1096: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1097: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1098: FND_MSG_PUB.ADD;
1099:
1100: GMIGUTL.DB_ERRNUM := SQLCODE;
1101: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 1144: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');

1140: EXCEPTION
1141: WHEN OTHERS THEN
1142: -- Bug 1764383
1143: -- Added code to return sqlerrm in case of unexpected database errors.
1144: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1145: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1146: FND_MSG_PUB.ADD;
1147:
1148: GMIGUTL.DB_ERRNUM := SQLCODE;

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

1141: WHEN OTHERS THEN
1142: -- Bug 1764383
1143: -- Added code to return sqlerrm in case of unexpected database errors.
1144: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1145: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1146: FND_MSG_PUB.ADD;
1147:
1148: GMIGUTL.DB_ERRNUM := SQLCODE;
1149: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 1177: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');

1173:
1174: WHEN OTHERS THEN
1175: -- Bug 1764383
1176: -- Added code to return sqlerrm in case of unexpected database errors.
1177: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1178: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1179: FND_MSG_PUB.ADD;
1180:
1181: GMIGUTL.DB_ERRNUM := SQLCODE;

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

1174: WHEN OTHERS THEN
1175: -- Bug 1764383
1176: -- Added code to return sqlerrm in case of unexpected database errors.
1177: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1178: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1179: FND_MSG_PUB.ADD;
1180:
1181: GMIGUTL.DB_ERRNUM := SQLCODE;
1182: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 1210: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');

1206:
1207: WHEN OTHERS THEN
1208: -- Bug 1764383
1209: -- Added code to return sqlerrm in case of unexpected database errors.
1210: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1211: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1212: FND_MSG_PUB.ADD;
1213:
1214: GMIGUTL.DB_ERRNUM := SQLCODE;

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

1207: WHEN OTHERS THEN
1208: -- Bug 1764383
1209: -- Added code to return sqlerrm in case of unexpected database errors.
1210: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1211: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1212: FND_MSG_PUB.ADD;
1213:
1214: GMIGUTL.DB_ERRNUM := SQLCODE;
1215: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 1341: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');

1337: EXCEPTION
1338: WHEN OTHERS THEN
1339: -- Bug 1764383
1340: -- Added code to return sqlerrm in case of unexpected database errors.
1341: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1342: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1343: FND_MSG_PUB.ADD;
1344:
1345: GMIGUTL.DB_ERRNUM := SQLCODE;

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

1338: WHEN OTHERS THEN
1339: -- Bug 1764383
1340: -- Added code to return sqlerrm in case of unexpected database errors.
1341: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1342: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1343: FND_MSG_PUB.ADD;
1344:
1345: GMIGUTL.DB_ERRNUM := SQLCODE;
1346: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 1382: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');

1378:
1379: WHEN OTHERS THEN
1380: -- Bug 1764383
1381: -- Added code to return sqlerrm in case of unexpected database errors.
1382: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1383: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1384: FND_MSG_PUB.ADD;
1385:
1386: GMIGUTL.DB_ERRNUM := SQLCODE;

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

1379: WHEN OTHERS THEN
1380: -- Bug 1764383
1381: -- Added code to return sqlerrm in case of unexpected database errors.
1382: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1383: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1384: FND_MSG_PUB.ADD;
1385:
1386: GMIGUTL.DB_ERRNUM := SQLCODE;
1387: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 1484: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');

1480: EXCEPTION
1481: WHEN OTHERS THEN
1482: -- Bug 1764383
1483: -- Added code to return sqlerrm in case of unexpected database errors.
1484: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1485: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1486: FND_MSG_PUB.ADD;
1487:
1488: GMIGUTL.DB_ERRNUM := SQLCODE;

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

1481: WHEN OTHERS THEN
1482: -- Bug 1764383
1483: -- Added code to return sqlerrm in case of unexpected database errors.
1484: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1485: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1486: FND_MSG_PUB.ADD;
1487:
1488: GMIGUTL.DB_ERRNUM := SQLCODE;
1489: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 1517: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');

1513:
1514: WHEN OTHERS THEN
1515: -- Bug 1764383
1516: -- Added code to return sqlerrm in case of unexpected database errors.
1517: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1518: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1519: FND_MSG_PUB.ADD;
1520:
1521: GMIGUTL.DB_ERRNUM := SQLCODE;

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

1514: WHEN OTHERS THEN
1515: -- Bug 1764383
1516: -- Added code to return sqlerrm in case of unexpected database errors.
1517: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1518: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1519: FND_MSG_PUB.ADD;
1520:
1521: GMIGUTL.DB_ERRNUM := SQLCODE;
1522: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 1625: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');

1621: EXCEPTION
1622: WHEN OTHERS THEN
1623: -- Bug 1764383
1624: -- Added code to return sqlerrm in case of unexpected database errors.
1625: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1626: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1627: FND_MSG_PUB.ADD;
1628:
1629: GMIGUTL.DB_ERRNUM := SQLCODE;

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

1622: WHEN OTHERS THEN
1623: -- Bug 1764383
1624: -- Added code to return sqlerrm in case of unexpected database errors.
1625: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1626: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1627: FND_MSG_PUB.ADD;
1628:
1629: GMIGUTL.DB_ERRNUM := SQLCODE;
1630: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 1658: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');

1654:
1655: WHEN OTHERS THEN
1656: -- Bug 1764383
1657: -- Added code to return sqlerrm in case of unexpected database errors.
1658: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1659: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1660: FND_MSG_PUB.ADD;
1661:
1662: GMIGUTL.DB_ERRNUM := SQLCODE;

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

1655: WHEN OTHERS THEN
1656: -- Bug 1764383
1657: -- Added code to return sqlerrm in case of unexpected database errors.
1658: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1659: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1660: FND_MSG_PUB.ADD;
1661:
1662: GMIGUTL.DB_ERRNUM := SQLCODE;
1663: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 1691: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');

1687:
1688: WHEN OTHERS THEN
1689: -- Bug 1764383
1690: -- Added code to return sqlerrm in case of unexpected database errors.
1691: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1692: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1693: FND_MSG_PUB.ADD;
1694:
1695: GMIGUTL.DB_ERRNUM := SQLCODE;

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

1688: WHEN OTHERS THEN
1689: -- Bug 1764383
1690: -- Added code to return sqlerrm in case of unexpected database errors.
1691: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1692: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1693: FND_MSG_PUB.ADD;
1694:
1695: GMIGUTL.DB_ERRNUM := SQLCODE;
1696: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 1729: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');

1725:
1726: WHEN OTHERS THEN
1727: -- Bug 1764383
1728: -- Added code to return sqlerrm in case of unexpected database errors.
1729: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1730: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1731: FND_MSG_PUB.ADD;
1732:
1733: GMIGUTL.DB_ERRNUM := SQLCODE;

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

1726: WHEN OTHERS THEN
1727: -- Bug 1764383
1728: -- Added code to return sqlerrm in case of unexpected database errors.
1729: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1730: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1731: FND_MSG_PUB.ADD;
1732:
1733: GMIGUTL.DB_ERRNUM := SQLCODE;
1734: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 1765: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');

1761:
1762: WHEN OTHERS THEN
1763: -- Bug 1764383
1764: -- Added code to return sqlerrm in case of unexpected database errors.
1765: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1766: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1767: FND_MSG_PUB.ADD;
1768:
1769: GMIGUTL.DB_ERRNUM := SQLCODE;

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

1762: WHEN OTHERS THEN
1763: -- Bug 1764383
1764: -- Added code to return sqlerrm in case of unexpected database errors.
1765: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1766: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1767: FND_MSG_PUB.ADD;
1768:
1769: GMIGUTL.DB_ERRNUM := SQLCODE;
1770: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 1798: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');

1794:
1795: WHEN OTHERS THEN
1796: -- Bug 1764383
1797: -- Added code to return sqlerrm in case of unexpected database errors.
1798: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1799: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1800: FND_MSG_PUB.ADD;
1801:
1802: GMIGUTL.DB_ERRNUM := SQLCODE;

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

1795: WHEN OTHERS THEN
1796: -- Bug 1764383
1797: -- Added code to return sqlerrm in case of unexpected database errors.
1798: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1799: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1800: FND_MSG_PUB.ADD;
1801:
1802: GMIGUTL.DB_ERRNUM := SQLCODE;
1803: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 1831: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');

1827:
1828: WHEN OTHERS THEN
1829: -- Bug 1764383
1830: -- Added code to return sqlerrm in case of unexpected database errors.
1831: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1832: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1833: FND_MSG_PUB.ADD;
1834:
1835: GMIGUTL.DB_ERRNUM := SQLCODE;

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

1828: WHEN OTHERS THEN
1829: -- Bug 1764383
1830: -- Added code to return sqlerrm in case of unexpected database errors.
1831: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1832: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1833: FND_MSG_PUB.ADD;
1834:
1835: GMIGUTL.DB_ERRNUM := SQLCODE;
1836: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 1865: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');

1861:
1862: WHEN OTHERS THEN
1863: -- Bug 1764383
1864: -- Added code to return sqlerrm in case of unexpected database errors.
1865: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1866: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1867: FND_MSG_PUB.ADD;
1868:
1869: GMIGUTL.DB_ERRNUM := SQLCODE;

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

1862: WHEN OTHERS THEN
1863: -- Bug 1764383
1864: -- Added code to return sqlerrm in case of unexpected database errors.
1865: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1866: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1867: FND_MSG_PUB.ADD;
1868:
1869: GMIGUTL.DB_ERRNUM := SQLCODE;
1870: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 1900: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');

1896:
1897: WHEN OTHERS THEN
1898: -- Bug 1764383
1899: -- Added code to return sqlerrm in case of unexpected database errors.
1900: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1901: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1902: FND_MSG_PUB.ADD;
1903:
1904: GMIGUTL.DB_ERRNUM := SQLCODE;

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

1897: WHEN OTHERS THEN
1898: -- Bug 1764383
1899: -- Added code to return sqlerrm in case of unexpected database errors.
1900: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
1901: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
1902: FND_MSG_PUB.ADD;
1903:
1904: GMIGUTL.DB_ERRNUM := SQLCODE;
1905: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 2066: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');

2062: EXCEPTION
2063: WHEN OTHERS THEN
2064: -- Bug 1764383
2065: -- Added code to return sqlerrm in case of unexpected database errors.
2066: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
2067: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2068: FND_MSG_PUB.ADD;
2069:
2070: GMIGUTL.DB_ERRNUM := SQLCODE;

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

2063: WHEN OTHERS THEN
2064: -- Bug 1764383
2065: -- Added code to return sqlerrm in case of unexpected database errors.
2066: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
2067: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2068: FND_MSG_PUB.ADD;
2069:
2070: GMIGUTL.DB_ERRNUM := SQLCODE;
2071: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 2161: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');

2157: EXCEPTION
2158: WHEN OTHERS THEN
2159: -- Bug 1764383
2160: -- Added code to return sqlerrm in case of unexpected database errors.
2161: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
2162: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2163: FND_MSG_PUB.ADD;
2164:
2165: GMIGUTL.DB_ERRNUM := SQLCODE;

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

2158: WHEN OTHERS THEN
2159: -- Bug 1764383
2160: -- Added code to return sqlerrm in case of unexpected database errors.
2161: FND_MESSAGE.SET_NAME('GMI', 'GMI_UNEXPECTED_ERROR');
2162: FND_MESSAGE.SET_TOKEN('ERROR', sqlerrm);
2163: FND_MSG_PUB.ADD;
2164:
2165: GMIGUTL.DB_ERRNUM := SQLCODE;
2166: GMIGUTL.DB_ERRMSG:= SQLERRM;