DBA Data[Home] [Help]

APPS.AS_STATUSES_PKG dependencies on FND_CONCURRENT

Line 686: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);

682: ROLLBACK;
683: Write_Log(l_module, 1, 'Exception: Problem in index creation.');
684: Write_Log(l_module, 1, 'SQLCODE ' || to_char(SQLCODE) ||
685: ' SQLERRM ' || substr(SQLERRM, 1, 100));
686: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
687: IF l_status = TRUE THEN
688: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
689: END IF ;
690: END PRE_UPDATE;

Line 1257: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);

1253: ROLLBACK;
1254: Write_log (l_module, 1, 'Error in as_statuses_pkg.update_oppty_accesses');
1255: Write_log (l_module, 1, 'SQLCODE ' || to_char(SQLCODE) ||
1256: ' SQLERRM ' || substr(SQLERRM, 1, 100));
1257: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
1258: IF l_status = TRUE THEN
1259: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
1260: END IF ;
1261: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1266: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);

1262: ERRBUF := ERRBUF||sqlerrm;
1263: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
1264: ROLLBACK;
1265: Write_Log(l_module, 1, 'Unexpected error in as_statuses_pkg.update_oppty_accesses');
1266: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
1267: IF l_status = TRUE THEN
1268: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
1269: END IF ;
1270: WHEN others THEN

Line 1277: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);

1273: ROLLBACK;
1274: Write_Log(l_module, 1, 'Exception: others in as_statuses_pkg.update_oppty_accesses');
1275: Write_Log(l_module, 1, 'SQLCODE ' || to_char(SQLCODE) ||
1276: ' SQLERRM ' || substr(SQLERRM, 1, 100));
1277: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
1278: IF l_status = TRUE THEN
1279: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
1280: END IF ;
1281: end UPDATE_ACCESSES_SUB;

Line 1711: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);

1707: ROLLBACK;
1708: Write_log (l_module, 1, 'Error in as_statuses_pkg.update_leads_accesses');
1709: Write_log (l_module, 1, 'SQLCODE ' || to_char(SQLCODE) ||
1710: ' SQLERRM ' || substr(SQLERRM, 1, 100));
1711: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
1712: IF l_status = TRUE THEN
1713: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
1714: END IF ;
1715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1720: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);

1716: ERRBUF := ERRBUF||sqlerrm;
1717: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
1718: ROLLBACK;
1719: Write_Log(l_module, 1, 'Unexpected error in as_statuses_pkg.update_leads_accesses');
1720: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
1721: IF l_status = TRUE THEN
1722: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
1723: END IF ;
1724: WHEN others THEN

Line 1731: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);

1727: ROLLBACK;
1728: Write_Log(l_module, 1, 'Exception: others in as_statuses_pkg.update_leads_accesses');
1729: Write_Log(l_module, 1, 'SQLCODE ' || to_char(SQLCODE) ||
1730: ' SQLERRM ' || substr(SQLERRM, 1, 100));
1731: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
1732: IF l_status = TRUE THEN
1733: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
1734: END IF ;
1735: end UPDATE_LEADS_ACCESSES;

Line 2161: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);

2157: ROLLBACK;
2158: Write_log (l_module, 1, 'Error in as_statuses_pkg.update_oppty_accesses');
2159: Write_log (l_module, 1, 'SQLCODE ' || to_char(SQLCODE) ||
2160: ' SQLERRM ' || substr(SQLERRM, 1, 100));
2161: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
2162: IF l_status = TRUE THEN
2163: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
2164: END IF ;
2165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2170: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);

2166: ERRBUF := ERRBUF||sqlerrm;
2167: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
2168: ROLLBACK;
2169: Write_Log(l_module, 1, 'Unexpected error in as_statuses_pkg.update_oppty_accesses');
2170: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
2171: IF l_status = TRUE THEN
2172: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
2173: END IF ;
2174: WHEN others THEN

Line 2181: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);

2177: ROLLBACK;
2178: Write_Log(l_module, 1, 'Exception: others in as_statuses_pkg.update_oppty_accesses');
2179: Write_Log(l_module, 1, 'SQLCODE ' || to_char(SQLCODE) ||
2180: ' SQLERRM ' || substr(SQLERRM, 1, 100));
2181: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
2182: IF l_status = TRUE THEN
2183: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
2184: END IF ;
2185: end UPDATE_OPPTY_ACCESSES;