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.CST_SLA_UPDATE_PKG dependencies on FND_CONCURRENT

Line 86: L_SUB_REQTAB fnd_concurrent.requests_tab_type;

82: l_wip_dev_status varchar2(80);
83: l_rcv_dev_status varchar2(80);
84: l_message varchar2(255);
85:
86: L_SUB_REQTAB fnd_concurrent.requests_tab_type;
87: req_data varchar2(10);
88: submit_req boolean;
89:
90: CST_UPGRADE_RUNNING exception;

Line 129: FROM fnd_concurrent_requests fcr,

125: l_reqid_count := 0;
126:
127: SELECT min(fcr.request_id)
128: into l_reqid_count
129: FROM fnd_concurrent_requests fcr,
130: fnd_concurrent_programs fcp
131: WHERE fcp.concurrent_program_name = l_program_name
132: AND fcp.application_id = l_prg_appid
133: AND fcr.concurrent_program_id = fcp.concurrent_program_id

Line 130: fnd_concurrent_programs fcp

126:
127: SELECT min(fcr.request_id)
128: into l_reqid_count
129: FROM fnd_concurrent_requests fcr,
130: fnd_concurrent_programs fcp
131: WHERE fcp.concurrent_program_name = l_program_name
132: AND fcp.application_id = l_prg_appid
133: AND fcr.concurrent_program_id = fcp.concurrent_program_id
134: AND fcr.program_application_id = fcp.application_id

Line 221: l_sub_reqtab := fnd_concurrent.get_sub_requests(

217: --
218: -- restart case
219: --
220:
221: l_sub_reqtab := fnd_concurrent.get_sub_requests(
222: fnd_global.conc_request_id);
223:
224: x_retcode := FND_API.G_RET_STS_SUCCESS;
225:

Line 295: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);

291: 'Another Costing Upgrade Manager is running.'
292: );
293: END IF;
294: X_errbuf:=l_module||'.'||l_stmt_num||': Another Costing Upgrade Manager is running.';
295: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
296:
297: WHEN submit_conc_failed THEN
298: X_retcode := FND_API.g_ret_sts_unexp_error;
299: IF l_exceptionlog THEN

Line 312: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);

308: 'Submit concurrent request failed.'
309: );
310: END IF;
311: X_errbuf:=l_module||'.'||l_stmt_num||': Submit concurrent request failed.';
312: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
313:
314: WHEN fnd_api.g_exc_unexpected_error THEN
315: X_retcode := FND_API.g_ret_sts_unexp_error;
316: IF l_exceptionlog THEN

Line 329: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);

325: 'An exception has occurred.'
326: );
327: END IF;
328: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
329: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
330:
331: WHEN fnd_api.g_exc_error THEN
332: X_retcode := FND_API.g_ret_sts_error;
333: IF l_errorLog THEN

Line 344: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);

340: FALSE
341: );
342: END IF;
343: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
344: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
345:
346: WHEN OTHERS THEN
347: X_retcode := FND_API.g_ret_sts_unexp_error;
348: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN

Line 359: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);

355: FALSE
356: );
357: END IF;
358: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
359: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
360:
361: END Update_Proc_MGR;
362:
363: -------------------------------------------------------------------------------------

Line 552: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);

548: 'An exception has occurred.'
549: );
550: END IF;
551: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
552: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
553:
554: WHEN fnd_api.g_exc_error THEN
555: X_retcode := FND_API.g_ret_sts_error;
556: IF l_errorLog THEN

Line 567: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);

563: FALSE
564: );
565: END IF;
566: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
567: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
568:
569: WHEN OTHERS THEN
570: X_retcode := FND_API.g_ret_sts_unexp_error;
571: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN

Line 582: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);

578: FALSE
579: );
580: END IF;
581: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
582: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
583:
584: END Update_Proc_INV_MGR;
585:
586: -------------------------------------------------------------------------------------

Line 774: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);

770: 'An exception has occurred.'
771: );
772: END IF;
773: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
774: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
775:
776: WHEN fnd_api.g_exc_error THEN
777: X_retcode := FND_API.g_ret_sts_error;
778: IF l_errorLog THEN

Line 789: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);

785: FALSE
786: );
787: END IF;
788: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
789: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
790:
791: WHEN OTHERS THEN
792: X_retcode := FND_API.g_ret_sts_unexp_error;
793: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN

Line 804: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);

800: FALSE
801: );
802: END IF;
803: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
804: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
805:
806: END Update_Proc_WIP_MGR;
807:
808: -------------------------------------------------------------------------------------

Line 995: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);

991: 'An exception has occurred.'
992: );
993: END IF;
994: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
995: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
996:
997: WHEN fnd_api.g_exc_error THEN
998: X_retcode := FND_API.g_ret_sts_error;
999: IF l_errorLog THEN

Line 1010: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);

1006: FALSE
1007: );
1008: END IF;
1009: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
1010: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
1011:
1012: WHEN OTHERS THEN
1013: X_retcode := FND_API.g_ret_sts_unexp_error;
1014: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN

Line 1025: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);

1021: FALSE
1022: );
1023: END IF;
1024: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
1025: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
1026:
1027: END Update_Proc_RCV_MGR;
1028:
1029:

Line 1228: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);

1224: FALSE
1225: );
1226: END IF;
1227: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
1228: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
1229:
1230: WHEN fnd_api.g_exc_unexpected_error THEN
1231: ROLLBACK;
1232: X_retcode := FND_API.g_ret_sts_unexp_error;

Line 1246: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);

1242: 'An exception has occurred.'
1243: );
1244: END IF;
1245: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
1246: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
1247:
1248: WHEN fnd_api.g_exc_error THEN
1249: ROLLBACK;
1250: X_retcode := FND_API.g_ret_sts_error;

Line 1262: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);

1258: FALSE
1259: );
1260: END IF;
1261: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
1262: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
1263:
1264: WHEN OTHERS THEN
1265: ROLLBACK;
1266: X_retcode := FND_API.g_ret_sts_unexp_error;

Line 1278: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);

1274: FALSE
1275: );
1276: END IF;
1277: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
1278: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
1279:
1280: END Update_Proc_INV_WKR;
1281:
1282: -------------------------------------------------------------------------------------

Line 1478: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);

1474: FALSE
1475: );
1476: END IF;
1477: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
1478: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
1479:
1480: WHEN fnd_api.g_exc_unexpected_error THEN
1481: ROLLBACK;
1482: X_retcode := FND_API.g_ret_sts_unexp_error;

Line 1496: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);

1492: 'An exception has occurred.'
1493: );
1494: END IF;
1495: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
1496: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
1497:
1498: WHEN fnd_api.g_exc_error THEN
1499: ROLLBACK;
1500: X_retcode := FND_API.g_ret_sts_error;

Line 1512: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);

1508: FALSE
1509: );
1510: END IF;
1511: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
1512: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
1513:
1514: WHEN OTHERS THEN
1515: ROLLBACK;
1516: X_retcode := FND_API.g_ret_sts_unexp_error;

Line 1528: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);

1524: FALSE
1525: );
1526: END IF;
1527: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
1528: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
1529:
1530: END Update_Proc_WIP_WKR;
1531:
1532: -------------------------------------------------------------------------------------

Line 1751: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);

1747: FALSE
1748: );
1749: END IF;
1750: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
1751: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
1752:
1753: WHEN fnd_api.g_exc_unexpected_error THEN
1754: ROLLBACK;
1755: X_retcode := FND_API.g_ret_sts_unexp_error;

Line 1769: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);

1765: 'An exception has occurred.'
1766: );
1767: END IF;
1768: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
1769: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
1770:
1771: WHEN fnd_api.g_exc_error THEN
1772: ROLLBACK;
1773: X_retcode := FND_API.g_ret_sts_error;

Line 1799: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);

1795: FALSE
1796: );
1797: END IF;
1798: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
1799: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
1800:
1801: END Update_Proc_RCV_WKR;
1802:
1803: -------------------------------------------------------------------------------------