DBA Data[Home] [Help]

APPS.PAY_PRG_PROCESS_EVENTS dependencies on FND_CONCURRENT

Line 35: L_SUB_REQTAB fnd_concurrent.requests_tab_type;

31: l_status_code varchar2(80);
32: l_dev_phase varchar2(15);
33: l_message varchar2(255);
34:
35: L_SUB_REQTAB fnd_concurrent.requests_tab_type;
36: req_data varchar2(10);
37: submit_req boolean;
38:
39: l_prg_appid number;

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

197: end if;
198:
199: else
200:
201: l_sub_reqtab := fnd_concurrent.get_sub_requests(fnd_global.conc_request_id);
202:
203: x_retcode := FND_API.G_RET_STS_SUCCESS;
204:
205: for i IN 1..l_sub_reqtab.COUNT()

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

225: EXCEPTION
226: WHEN submit_conc_failed THEN
227: X_retcode := FND_API.g_ret_sts_unexp_error;
228: X_errbuf:=l_module||'.'||l_stmt_num||': Submit concurrent request failed.';
229: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
230:
231: WHEN fnd_api.g_exc_unexpected_error THEN
232: X_retcode := FND_API.g_ret_sts_unexp_error;
233:

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

232: X_retcode := FND_API.g_ret_sts_unexp_error;
233:
234:
235: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
236: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
237:
238: WHEN fnd_api.g_exc_error THEN
239: X_retcode := FND_API.g_ret_sts_error;
240:

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

238: WHEN fnd_api.g_exc_error THEN
239: X_retcode := FND_API.g_ret_sts_error;
240:
241: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
242: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
243:
244: WHEN OTHERS THEN
245: X_retcode := FND_API.g_ret_sts_unexp_error;
246: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;

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

243:
244: WHEN OTHERS THEN
245: X_retcode := FND_API.g_ret_sts_unexp_error;
246: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
247: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
248:
249: END Purge_process_events_PAY_MGR;
250:
251: ----------------------------------------------------------------------------------------

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

395:
396: WHEN purge_events_exception THEN
397: ROLLBACK;
398: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
399: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
400:
401: WHEN fnd_api.g_exc_unexpected_error THEN
402: ROLLBACK;
403: X_retcode := FND_API.g_ret_sts_unexp_error;

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

401: WHEN fnd_api.g_exc_unexpected_error THEN
402: ROLLBACK;
403: X_retcode := FND_API.g_ret_sts_unexp_error;
404: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
405: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
406:
407: WHEN fnd_api.g_exc_error THEN
408: ROLLBACK;
409: X_retcode := FND_API.g_ret_sts_error;

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

407: WHEN fnd_api.g_exc_error THEN
408: ROLLBACK;
409: X_retcode := FND_API.g_ret_sts_error;
410: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
411: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
412:
413: WHEN OTHERS THEN
414: ROLLBACK;
415: X_retcode := FND_API.g_ret_sts_unexp_error;

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

413: WHEN OTHERS THEN
414: ROLLBACK;
415: X_retcode := FND_API.g_ret_sts_unexp_error;
416: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
417: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
418:
419: END Purge_process_events_PAY_WKR;
420:
421: