DBA Data[Home] [Help]

APPS.ASN_MIG_SALES_TEAM_PVT dependencies on FND_MESSAGE

Line 948: errbuf := fnd_message.get;

944: -- If request submission failed, exit with error.
945: --
946: IF (l_req_id = 0) THEN
947:
948: errbuf := fnd_message.get;
949: retcode := 2;
950: RETURN;
951:
952: END IF;

Line 1003: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

999: ROLLBACK;
1000:
1001: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1002:
1003: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1004: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1005: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1006: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1007: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);

Line 1004: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

1000:
1001: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1002:
1003: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1004: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1005: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1006: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1007: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);
1008: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,

Line 1005: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

1001: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1002:
1003: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1004: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1005: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1006: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1007: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);
1008: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
1009: l_api_name||':'||sqlcode||':'||sqlerrm);

Line 1006: FND_MESSAGE.Set_Token('REASON', SQLERRM);

1002:
1003: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1004: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1005: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1006: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1007: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);
1008: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
1009: l_api_name||':'||sqlcode||':'||sqlerrm);
1010: END IF;

Line 1411: errbuf := fnd_message.get;

1407: -- If request submission failed, exit with error.
1408: --
1409: IF (l_req_id = 0) THEN
1410:
1411: errbuf := fnd_message.get;
1412: retcode := 2;
1413: RETURN;
1414:
1415: END IF;

Line 1467: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

1463: ROLLBACK;
1464:
1465: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1466:
1467: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1468: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1469: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1470: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1471: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);

Line 1468: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

1464:
1465: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1466:
1467: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1468: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1469: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1470: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1471: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);
1472: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,

Line 1469: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

1465: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1466:
1467: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1468: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1469: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1470: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1471: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);
1472: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
1473: l_api_name||':'||sqlcode||':'||sqlerrm);

Line 1470: FND_MESSAGE.Set_Token('REASON', SQLERRM);

1466:
1467: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1468: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1469: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1470: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1471: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);
1472: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
1473: l_api_name||':'||sqlcode||':'||sqlerrm);
1474: END IF;

Line 1694: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');

1690: ROLLBACK;
1691:
1692: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1693:
1694: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1695: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1696: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1697: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1698: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);

Line 1695: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);

1691:
1692: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1693:
1694: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1695: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1696: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1697: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1698: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);
1699: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,

Line 1696: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);

1692: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1693:
1694: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1695: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1696: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1697: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1698: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);
1699: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
1700: l_api_name||':'||sqlcode||':'||sqlerrm);

Line 1697: FND_MESSAGE.Set_Token('REASON', SQLERRM);

1693:
1694: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1695: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1696: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1697: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1698: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);
1699: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
1700: l_api_name||':'||sqlcode||':'||sqlerrm);
1701: END IF;