DBA Data[Home] [Help]

APPS.AS_STATUSES_PKG dependencies on FND_MESSAGE

Line 239: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');

235: open c;
236: fetch c into recinfo;
237: if (c%notfound) then
238: close c;
239: fnd_message.set_name('FND', 'FORM_RECORD_DELETED');
240: app_exception.raise_exception;
241: end if;
242: close c;
243: if ( (recinfo.ENABLED_FLAG = X_ENABLED_FLAG)

Line 295: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

291: OR ((recinfo.ATTRIBUTE15 is null) AND (X_ATTRIBUTE15 is null)))
292: ) then
293: null;
294: else
295: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
296: app_exception.raise_exception;
297: end if;
298:
299: for tlinfo in c1 loop

Line 308: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');

304: OR ((tlinfo.DESCRIPTION is null) AND (X_DESCRIPTION is null)))
305: ) then
306: null;
307: else
308: fnd_message.set_name('FND', 'FORM_RECORD_CHANGED');
309: app_exception.raise_exception;
310: end if;
311: end if;
312: end loop;

Line 1015: errbuf := fnd_message.get;

1011: -- If request submission failed, exit with error.
1012: --
1013: IF (l_req_id = 0) THEN
1014:
1015: errbuf := fnd_message.get;
1016: retcode := 2;
1017: RETURN;
1018:
1019: END IF;

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

1066: ROLLBACK;
1067:
1068: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1069:
1070: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1071: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1072: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1073: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1074: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);

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

1067:
1068: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1069:
1070: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1071: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1072: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1073: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1074: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);
1075: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,

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

1068: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1069:
1070: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1071: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1072: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1073: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1074: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);
1075: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
1076: l_api_name||':'||sqlcode||':'||sqlerrm);

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

1069:
1070: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1071: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1072: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1073: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1074: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);
1075: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
1076: l_api_name||':'||sqlcode||':'||sqlerrm);
1077: END IF;

Line 1493: errbuf := fnd_message.get;

1489: -- If request submission failed, exit with error.
1490: --
1491: IF (l_req_id = 0) THEN
1492:
1493: errbuf := fnd_message.get;
1494: retcode := 2;
1495: RETURN;
1496:
1497: END IF;

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

1544: ROLLBACK;
1545:
1546: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1547:
1548: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1549: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1550: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1551: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1552: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);

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

1545:
1546: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1547:
1548: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1549: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1550: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1551: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1552: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);
1553: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,

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

1546: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1547:
1548: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1549: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1550: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1551: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1552: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);
1553: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
1554: l_api_name||':'||sqlcode||':'||sqlerrm);

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

1547:
1548: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
1549: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
1550: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
1551: FND_MESSAGE.Set_Token('REASON', SQLERRM);
1552: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);
1553: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
1554: l_api_name||':'||sqlcode||':'||sqlerrm);
1555: END IF;

Line 1944: errbuf := fnd_message.get;

1940: -- If request submission failed, exit with error.
1941: --
1942: IF (l_req_id = 0) THEN
1943:
1944: errbuf := fnd_message.get;
1945: retcode := 2;
1946: RETURN;
1947:
1948: END IF;

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

1996: ROLLBACK;
1997:
1998: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1999:
2000: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2001: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2002: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2003: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2004: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);

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

1997:
1998: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1999:
2000: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2001: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2002: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2003: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2004: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);
2005: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,

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

1998: IF (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1999:
2000: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2001: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2002: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2003: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2004: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);
2005: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2006: l_api_name||':'||sqlcode||':'||sqlerrm);

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

1999:
2000: FND_MESSAGE.Set_Name('FND', 'SQL_PLSQL_ERROR');
2001: FND_MESSAGE.Set_Token('ROUTINE', l_api_name);
2002: FND_MESSAGE.Set_Token('ERRNO', SQLCODE);
2003: FND_MESSAGE.Set_Token('REASON', SQLERRM);
2004: FND_LOG.MESSAGE(FND_LOG.LEVEL_UNEXPECTED, l_module_name, true);
2005: FND_LOG.STRING(FND_LOG.LEVEL_UNEXPECTED, l_module_name,
2006: l_api_name||':'||sqlcode||':'||sqlerrm);
2007: END IF;