eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AS_STATUSES_PKG dependencies on FND_API

Line 681: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

677: Create_Temp_Index('AS_ACCESSES_ALL_ALL','ACCESS_ID,DELETE_FLAG,LEAD_ID',G_INDEX_SUFFIX2);
678: EXCEPTION
679: WHEN others THEN
680: ERRBUF := SQLERRM;
681: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
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));

Line 1120: RAISE FND_API.G_EXC_ERROR;

1116: G_BATCH_SIZE := NVL(p_batch_size,10000);
1117:
1118: IF Upper(X_STATUS_CODE) <> 'ALL' AND UPPER(NVL(X_OPEN_FLAG,'X')) NOT IN ('Y','N') THEN
1119: Write_log (l_module, 1, 'Invalid input for Status Flag!');
1120: RAISE FND_API.G_EXC_ERROR;
1121: END IF;
1122:
1123: IF Upper(X_STATUS_CODE) <> 'ALL' THEN
1124: Open Get_flag_from_Input(X_OPEN_FLAG,X_STATUS_CODE);

Line 1129: RAISE FND_API.G_EXC_ERROR;

1125: Fetch Get_flag_from_Input INTO l_lead_flag,l_opp_flag;
1126: IF (Get_flag_from_Input%NOTFOUND) THEN
1127: Write_log (l_module, 1, 'Combination of Status Code and Open Flag is not valid! Please note that the status code is case sensitive.');
1128: Close Get_flag_from_Input;
1129: RAISE FND_API.G_EXC_ERROR;
1130: ELSE
1131: Close Get_flag_from_Input;
1132: END IF;
1133: END IF;

Line 1250: WHEN FND_API.G_EXC_ERROR THEN

1246: end if;
1247:
1248:
1249: EXCEPTION
1250: WHEN FND_API.G_EXC_ERROR THEN
1251: ERRBUF := ERRBUF || sqlerrm;
1252: RETCODE := FND_API.G_RET_STS_ERROR;
1253: ROLLBACK;
1254: Write_log (l_module, 1, 'Error in as_statuses_pkg.update_oppty_accesses');

Line 1252: RETCODE := FND_API.G_RET_STS_ERROR;

1248:
1249: EXCEPTION
1250: WHEN FND_API.G_EXC_ERROR THEN
1251: ERRBUF := ERRBUF || sqlerrm;
1252: RETCODE := FND_API.G_RET_STS_ERROR;
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));

Line 1261: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
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');

Line 1263: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

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
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

Line 1272: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

1268: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
1269: END IF ;
1270: WHEN others THEN
1271: ERRBUF := SQLERRM;
1272: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
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));

Line 1600: RAISE FND_API.G_EXC_ERROR;

1596: BEGIN
1597:
1598: IF Upper(X_STATUS_CODE) <> 'ALL' AND UPPER(NVL(X_OPEN_FLAG,'X')) NOT IN ('Y','N') THEN
1599: Write_log (l_module, 1, 'Invalid input for Status Flag!');
1600: RAISE FND_API.G_EXC_ERROR;
1601: END IF;
1602:
1603: IF Upper(X_STATUS_CODE) <> 'ALL' THEN
1604: Open Get_flag_from_Input(X_OPEN_FLAG,X_STATUS_CODE);

Line 1609: RAISE FND_API.G_EXC_ERROR;

1605: Fetch Get_flag_from_Input INTO l_lead_flag;
1606: IF (Get_flag_from_Input%NOTFOUND) THEN
1607: Write_log (l_module, 1, 'Combination of Status Code and Open Flag is not valid! Please note that the status code is case sensitive.');
1608: Close Get_flag_from_Input;
1609: RAISE FND_API.G_EXC_ERROR;
1610: ELSE
1611: Close Get_flag_from_Input;
1612: END IF;
1613: END IF;

Line 1704: WHEN FND_API.G_EXC_ERROR THEN

1700:
1701:
1702:
1703: EXCEPTION
1704: WHEN FND_API.G_EXC_ERROR THEN
1705: ERRBUF := ERRBUF || sqlerrm;
1706: RETCODE := FND_API.G_RET_STS_ERROR;
1707: ROLLBACK;
1708: Write_log (l_module, 1, 'Error in as_statuses_pkg.update_leads_accesses');

Line 1706: RETCODE := FND_API.G_RET_STS_ERROR;

1702:
1703: EXCEPTION
1704: WHEN FND_API.G_EXC_ERROR THEN
1705: ERRBUF := ERRBUF || sqlerrm;
1706: RETCODE := FND_API.G_RET_STS_ERROR;
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));

Line 1715: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
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');

Line 1717: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

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
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

Line 1726: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

1722: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
1723: END IF ;
1724: WHEN others THEN
1725: ERRBUF := SQLERRM;
1726: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
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));

Line 2053: RAISE FND_API.G_EXC_ERROR;

2049: BEGIN
2050:
2051: IF Upper(X_STATUS_CODE) <> 'ALL' AND UPPER(NVL(X_OPEN_FLAG,'X')) NOT IN ('Y','N') THEN
2052: Write_log (l_module, 1, 'Invalid input for Status Flag!');
2053: RAISE FND_API.G_EXC_ERROR;
2054: END IF;
2055:
2056: IF Upper(X_STATUS_CODE) <> 'ALL' THEN
2057: Open Get_flag_from_Input(X_OPEN_FLAG,X_STATUS_CODE);

Line 2062: RAISE FND_API.G_EXC_ERROR;

2058: Fetch Get_flag_from_Input INTO l_opp_flag;
2059: IF (Get_flag_from_Input%NOTFOUND) THEN
2060: Write_log (l_module, 1, 'Combination of Status Code and Open Flag is not valid!');
2061: Close Get_flag_from_Input;
2062: RAISE FND_API.G_EXC_ERROR;
2063: ELSE
2064: Close Get_flag_from_Input;
2065: END IF;
2066: END IF;

Line 2154: WHEN FND_API.G_EXC_ERROR THEN

2150:
2151:
2152:
2153: EXCEPTION
2154: WHEN FND_API.G_EXC_ERROR THEN
2155: ERRBUF := ERRBUF || sqlerrm;
2156: RETCODE := FND_API.G_RET_STS_ERROR;
2157: ROLLBACK;
2158: Write_log (l_module, 1, 'Error in as_statuses_pkg.update_oppty_accesses');

Line 2156: RETCODE := FND_API.G_RET_STS_ERROR;

2152:
2153: EXCEPTION
2154: WHEN FND_API.G_EXC_ERROR THEN
2155: ERRBUF := ERRBUF || sqlerrm;
2156: RETCODE := FND_API.G_RET_STS_ERROR;
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));

Line 2165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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
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');

Line 2167: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

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
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

Line 2176: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;

2172: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
2173: END IF ;
2174: WHEN others THEN
2175: ERRBUF := SQLERRM;
2176: RETCODE := FND_API.G_RET_STS_UNEXP_ERROR;
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));