DBA Data[Home] [Help]

APPS.GMIVDBL dependencies on FND_MSG_PUB

Line 310: FND_MSG_PUB.ADD;

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;
314: RETURN FALSE;

Line 407: FND_MSG_PUB.ADD;

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;
411:

Line 828: --Do not add error using fnd_msg_pub.add

824:
825: EXCEPTION
826: WHEN NO_DATA_FOUND THEN
827: --Jalaj Srivastava Bug 1977956
828: --Do not add error using fnd_msg_pub.add
829: --This is a expected error.
830:
831: GMIGUTL.DB_ERRNUM := SQLCODE;
832: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 840: FND_MSG_PUB.ADD;

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;
844: RETURN FALSE;

Line 985: FND_MSG_PUB.ADD;

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;
989: RETURN FALSE;

Line 1007: --Do not add error using fnd_msg_pub.add

1003:
1004: EXCEPTION
1005: WHEN NO_DATA_FOUND THEN
1006: --Jalaj Srivastava Bug 1977956
1007: --Do not add error using fnd_msg_pub.add
1008: --This is a expected error.
1009:
1010: GMIGUTL.DB_ERRNUM := SQLCODE;
1011: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 1019: FND_MSG_PUB.ADD;

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;
1023: RETURN FALSE;

Line 1065: FND_MSG_PUB.ADD;

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;
1069: RETURN FALSE;

Line 1086: --Do not add error using fnd_msg_pub.add

1082:
1083: EXCEPTION
1084: WHEN NO_DATA_FOUND THEN
1085: --Jalaj Srivastava Bug 1977956
1086: --Do not add error using fnd_msg_pub.add
1087: --This is a expected error.
1088:
1089: GMIGUTL.DB_ERRNUM := SQLCODE;
1090: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 1098: FND_MSG_PUB.ADD;

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;
1102: RETURN FALSE;

Line 1146: FND_MSG_PUB.ADD;

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;
1150: RETURN FALSE;

Line 1167: --Do not add error using fnd_msg_pub.add

1163:
1164: EXCEPTION
1165: WHEN NO_DATA_FOUND THEN
1166: --Jalaj Srivastava Bug 1977956
1167: --Do not add error using fnd_msg_pub.add
1168: --This is a expected error.
1169:
1170: GMIGUTL.DB_ERRNUM := SQLCODE;
1171: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 1179: FND_MSG_PUB.ADD;

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;
1183: RETURN FALSE;

Line 1200: --Do not add error using fnd_msg_pub.add

1196:
1197: EXCEPTION
1198: WHEN NO_DATA_FOUND THEN
1199: --Jalaj Srivastava Bug 1977956
1200: --Do not add error using fnd_msg_pub.add
1201: --This is a expected error.
1202:
1203: GMIGUTL.DB_ERRNUM := SQLCODE;
1204: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 1212: FND_MSG_PUB.ADD;

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;
1216: RETURN FALSE;

Line 1343: FND_MSG_PUB.ADD;

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;
1347: RETURN FALSE;

Line 1372: --Do not add error using fnd_msg_pub.add

1368:
1369: EXCEPTION
1370: WHEN NO_DATA_FOUND THEN
1371: --Jalaj Srivastava Bug 1977956
1372: --Do not add error using fnd_msg_pub.add
1373: --This is a expected error.
1374:
1375: GMIGUTL.DB_ERRNUM := SQLCODE;
1376: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 1384: FND_MSG_PUB.ADD;

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;
1388: RETURN FALSE;

Line 1486: FND_MSG_PUB.ADD;

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;
1490: RETURN FALSE;

Line 1507: --Do not add error using fnd_msg_pub.add

1503:
1504: EXCEPTION
1505: WHEN NO_DATA_FOUND THEN
1506: --Jalaj Srivastava Bug 1977956
1507: --Do not add error using fnd_msg_pub.add
1508: --This is a expected error.
1509:
1510: GMIGUTL.DB_ERRNUM := SQLCODE;
1511: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 1519: FND_MSG_PUB.ADD;

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;
1523: RETURN FALSE;

Line 1627: FND_MSG_PUB.ADD;

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;
1631: RETURN FALSE;

Line 1648: --Do not add error using fnd_msg_pub.add

1644:
1645: EXCEPTION
1646: WHEN NO_DATA_FOUND THEN
1647: --Jalaj Srivastava Bug 1977956
1648: --Do not add error using fnd_msg_pub.add
1649: --This is a expected error.
1650:
1651: GMIGUTL.DB_ERRNUM := SQLCODE;
1652: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 1660: FND_MSG_PUB.ADD;

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;
1664: RETURN FALSE;

Line 1681: --Do not add error using fnd_msg_pub.add

1677:
1678: EXCEPTION
1679: WHEN NO_DATA_FOUND THEN
1680: --Jalaj Srivastava Bug 1977956
1681: --Do not add error using fnd_msg_pub.add
1682: --This is a expected error.
1683:
1684: GMIGUTL.DB_ERRNUM := SQLCODE;
1685: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 1693: FND_MSG_PUB.ADD;

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;
1697: RETURN FALSE;

Line 1719: --Do not add error using fnd_msg_pub.add

1715:
1716: EXCEPTION
1717: WHEN NO_DATA_FOUND THEN
1718: --Jalaj Srivastava Bug 1977956
1719: --Do not add error using fnd_msg_pub.add
1720: --This is a expected error.
1721:
1722: GMIGUTL.DB_ERRNUM := SQLCODE;
1723: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 1731: FND_MSG_PUB.ADD;

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;
1735: RETURN FALSE;

Line 1767: FND_MSG_PUB.ADD;

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;
1771: RETURN FALSE;

Line 1788: --Do not add error using fnd_msg_pub.add

1784:
1785: EXCEPTION
1786: WHEN NO_DATA_FOUND THEN
1787: --Jalaj Srivastava Bug 1977956
1788: --Do not add error using fnd_msg_pub.add
1789: --This is a expected error.
1790:
1791: GMIGUTL.DB_ERRNUM := SQLCODE;
1792: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 1800: FND_MSG_PUB.ADD;

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;
1804: RETURN FALSE;

Line 1821: --Do not add error using fnd_msg_pub.add

1817:
1818: EXCEPTION
1819: WHEN NO_DATA_FOUND THEN
1820: --Jalaj Srivastava Bug 1977956
1821: --Do not add error using fnd_msg_pub.add
1822: --This is a expected error.
1823:
1824: GMIGUTL.DB_ERRNUM := SQLCODE;
1825: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 1833: FND_MSG_PUB.ADD;

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;
1837: RETURN FALSE;

Line 1855: --Do not add error using fnd_msg_pub.add

1851:
1852: EXCEPTION
1853: WHEN NO_DATA_FOUND THEN
1854: --Jalaj Srivastava Bug 1977956
1855: --Do not add error using fnd_msg_pub.add
1856: --This is a expected error.
1857:
1858: GMIGUTL.DB_ERRNUM := SQLCODE;
1859: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 1867: FND_MSG_PUB.ADD;

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;
1871: RETURN FALSE;

Line 1890: --Do not add error using fnd_msg_pub.add

1886:
1887: EXCEPTION
1888: WHEN NO_DATA_FOUND THEN
1889: --Jalaj Srivastava Bug 1977956
1890: --Do not add error using fnd_msg_pub.add
1891: --This is a expected error.
1892:
1893: GMIGUTL.DB_ERRNUM := SQLCODE;
1894: GMIGUTL.DB_ERRMSG:= SQLERRM;

Line 1902: FND_MSG_PUB.ADD;

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;
1906: RETURN FALSE;

Line 2068: FND_MSG_PUB.ADD;

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;
2072: RETURN FALSE;

Line 2163: FND_MSG_PUB.ADD;

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;
2167: RETURN FALSE;