DBA Data[Home] [Help]

APPS.PAY_SLA_UPDATE_PKG dependencies on FND_CONCURRENT

Line 161: L_SUB_REQTAB fnd_concurrent.requests_tab_type;

157: l_status_code varchar2(80);
158: l_dev_phase varchar2(15);
159: l_message varchar2(255);
160:
161: L_SUB_REQTAB fnd_concurrent.requests_tab_type;
162: req_data varchar2(10);
163: submit_req boolean;
164:
165: PAY_UPGRADE_RUNNING exception;

Line 320: l_sub_reqtab := fnd_concurrent.get_sub_requests(fnd_global.conc_request_id);

316: end;
317: end if;
318: else
319:
320: l_sub_reqtab := fnd_concurrent.get_sub_requests(fnd_global.conc_request_id);
321:
322: x_retcode := FND_API.G_RET_STS_SUCCESS;
323:
324: for i IN 1..l_sub_reqtab.COUNT()

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

366: EXCEPTION
367: WHEN submit_conc_failed THEN
368: X_retcode := FND_API.g_ret_sts_unexp_error;
369: X_errbuf:=l_module||'.'||l_stmt_num||': Submit concurrent request failed.';
370: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
371:
372: WHEN fnd_api.g_exc_unexpected_error THEN
373: X_retcode := FND_API.g_ret_sts_unexp_error;
374:

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

372: WHEN fnd_api.g_exc_unexpected_error THEN
373: X_retcode := FND_API.g_ret_sts_unexp_error;
374:
375: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
376: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
377:
378: WHEN fnd_api.g_exc_error THEN
379: X_retcode := FND_API.g_ret_sts_error;
380:

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

378: WHEN fnd_api.g_exc_error THEN
379: X_retcode := FND_API.g_ret_sts_error;
380:
381: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
382: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
383:
384: WHEN OTHERS THEN
385: X_retcode := FND_API.g_ret_sts_unexp_error;
386: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;

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

383:
384: WHEN OTHERS THEN
385: X_retcode := FND_API.g_ret_sts_unexp_error;
386: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
387: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
388:
389: END Update_Proc_PAY_MGR;
390:
391: ----------------------------------------------------------------------------------------

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

535: EXCEPTION
536: WHEN update_subledger_exception THEN
537: ROLLBACK;
538: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
539: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
540:
541: WHEN fnd_api.g_exc_unexpected_error THEN
542: ROLLBACK;
543: X_retcode := FND_API.g_ret_sts_unexp_error;

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

541: WHEN fnd_api.g_exc_unexpected_error THEN
542: ROLLBACK;
543: X_retcode := FND_API.g_ret_sts_unexp_error;
544: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
545: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
546:
547: WHEN fnd_api.g_exc_error THEN
548: ROLLBACK;
549: X_retcode := FND_API.g_ret_sts_error;

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

547: WHEN fnd_api.g_exc_error THEN
548: ROLLBACK;
549: X_retcode := FND_API.g_ret_sts_error;
550: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
551: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
552:
553: WHEN OTHERS THEN
554: ROLLBACK;
555: X_retcode := FND_API.g_ret_sts_unexp_error;

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

553: WHEN OTHERS THEN
554: ROLLBACK;
555: X_retcode := FND_API.g_ret_sts_unexp_error;
556: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
557: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
558:
559: END Update_Proc_PAY_WKR;
560:
561: ----------------------------------------------------------------------------------------