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 AS_STATUSES_PKG

Line 1: package body AS_STATUSES_PKG as

1: package body AS_STATUSES_PKG as
2: /* #$Header: asxtstab.pls 120.4 2007/03/16 08:13:57 snsarava ship $ */
3:
4: G_SCHEMA_NAME VARCHAR2(32) := null;
5:

Line 491: AS_STATUSES_PKG.UPDATE_ROW(

487: user_id := 1;
488: end if;
489:
490: begin
491: AS_STATUSES_PKG.UPDATE_ROW(
492: X_STATUS_CODE => X_STATUS_CODE,
493: X_ENABLED_FLAG => X_ENABLED_FLAG,
494: X_LEAD_FLAG => X_LEAD_FLAG,
495: X_OPP_FLAG => X_OPP_FLAG,

Line 527: AS_STATUSES_PKG.INSERT_ROW(

523: );
524:
525: exception
526: when NO_DATA_FOUND then
527: AS_STATUSES_PKG.INSERT_ROW(
528: X_ROWID => row_id,
529: X_STATUS_CODE => X_STATUS_CODE,
530: X_ENABLED_FLAG => X_ENABLED_FLAG,
531: X_LEAD_FLAG => X_LEAD_FLAG,

Line 821: 'as.plsql.as_statuses_pkg.update_accesses_Main';

817: IS
818: l_api_name CONSTANT VARCHAR2(30) :=
819: 'update_accesses_Main';
820: l_module_name CONSTANT VARCHAR2(256) :=
821: 'as.plsql.as_statuses_pkg.update_accesses_Main';
822: l_msg_count NUMBER;
823: l_msg_data VARCHAR2(2000);
824: l_req_id NUMBER;
825: l_request_data VARCHAR2(30);

Line 1254: Write_log (l_module, 1, 'Error in as_statuses_pkg.update_oppty_accesses');

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));
1257: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
1258: IF l_status = TRUE THEN

Line 1265: Write_Log(l_module, 1, 'Unexpected error in as_statuses_pkg.update_oppty_accesses');

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
1268: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
1269: END IF ;

Line 1274: Write_Log(l_module, 1, 'Exception: others in as_statuses_pkg.update_oppty_accesses');

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));
1277: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
1278: IF l_status = TRUE THEN

Line 1300: 'as.plsql.as_statuses_pkg.update_leads_Main';

1296: IS
1297: l_api_name CONSTANT VARCHAR2(30) :=
1298: 'update_leads_Main';
1299: l_module_name CONSTANT VARCHAR2(256) :=
1300: 'as.plsql.as_statuses_pkg.update_leads_Main';
1301: l_msg_count NUMBER;
1302: l_msg_data VARCHAR2(2000);
1303: l_req_id NUMBER;
1304: l_request_data VARCHAR2(30);

Line 1708: Write_log (l_module, 1, 'Error in as_statuses_pkg.update_leads_accesses');

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));
1711: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
1712: IF l_status = TRUE THEN

Line 1719: Write_Log(l_module, 1, 'Unexpected error in as_statuses_pkg.update_leads_accesses');

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
1722: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
1723: END IF ;

Line 1728: Write_Log(l_module, 1, 'Exception: others in as_statuses_pkg.update_leads_accesses');

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));
1731: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
1732: IF l_status = TRUE THEN

Line 1752: 'as.plsql.as_statuses_pkg.update_oppty_Main';

1748: IS
1749: l_api_name CONSTANT VARCHAR2(30) :=
1750: 'update_oppty_Main';
1751: l_module_name CONSTANT VARCHAR2(256) :=
1752: 'as.plsql.as_statuses_pkg.update_oppty_Main';
1753: l_msg_count NUMBER;
1754: l_msg_data VARCHAR2(2000);
1755: l_req_id NUMBER;
1756: l_request_data VARCHAR2(30);

Line 2158: Write_log (l_module, 1, 'Error in as_statuses_pkg.update_oppty_accesses');

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));
2161: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
2162: IF l_status = TRUE THEN

Line 2169: Write_Log(l_module, 1, 'Unexpected error in as_statuses_pkg.update_oppty_accesses');

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
2172: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
2173: END IF ;

Line 2178: Write_Log(l_module, 1, 'Exception: others in as_statuses_pkg.update_oppty_accesses');

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));
2181: l_status := fnd_concurrent.set_completion_status('ERROR',sqlerrm);
2182: IF l_status = TRUE THEN

Line 2187: end AS_STATUSES_PKG;

2183: FND_FILE.PUT_LINE(FND_FILE.LOG,'Error, cannot complete Concurrent Program') ;
2184: END IF ;
2185: end UPDATE_OPPTY_ACCESSES;
2186:
2187: end AS_STATUSES_PKG;