DBA Data[Home] [Help]

APPS.CST_PERIODSUMMARY_PVT dependencies on FND_CONCURRENT

Line 62: l_return_val := FND_CONCURRENT.Wait_For_Request(

58: FND_FILE.put_line(FND_FILE.LOG, 'Organization ID: ' || p_org_id);
59: FND_FILE.put_line(FND_FILE.LOG, 'Accounting Period ID: ' || p_period_id);
60:
61: l_stmt_num := 10;
62: l_return_val := FND_CONCURRENT.Wait_For_Request(
63: request_id => p_request_id,
64: interval => 60,
65: max_wait => 0,
66: phase => l_phase,

Line 263: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);

259: WHERE organization_id = p_org_id
260: AND acct_period_id = p_period_id;
261: l_message := 'Transfer to GL (request_id '||p_request_id||') completed with error';
262: FND_FILE.put_line(FND_FILE.LOG,l_message);
263: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);
264: END IF;
265:
266: EXCEPTION
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 278: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);

274: UPDATE org_acct_periods
275: SET open_flag = 'Y'
276: WHERE organization_id = p_org_id
277: AND acct_period_id = p_period_id;
278: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);
279: WHEN l_untransferred_dist THEN
280: ROLLBACK TO WaitOn_Request_PVT;
281: l_message := 'There exist(s) '|| l_count || ' untransferred distribution(s) in ' || l_untransferred_table;
282: FND_FILE.put_line(FND_FILE.LOG,l_message);

Line 287: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);

283: UPDATE org_acct_periods
284: SET open_flag = 'Y'
285: WHERE organization_id = p_org_id
286: AND acct_period_id = p_period_id;
287: l_conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',l_message);
288: WHEN COULD_NOT_LAUNCH_REC_RPT THEN
289: ROLLBACK TO WaitOn_Request_PVT;
290: FND_FILE.put_line(FND_FILE.LOG, 'could not launch reconciliation report');
291: WHEN OTHERS THEN