APPS.CST_PERIODSUMMARY_PVT dependencies on FND_FILE

Line 57: FND_FILE.put_line(FND_FILE.LOG, 'Waiting for request ID: ' || p_request_id);

53: THEN
54: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
55: END IF;
56:
57: FND_FILE.put_line(FND_FILE.LOG, 'Waiting for request ID: ' || p_request_id);
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;

Line 58: FND_FILE.put_line(FND_FILE.LOG, 'Organization ID: ' || p_org_id);

54: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
55: END IF;
56:
57: FND_FILE.put_line(FND_FILE.LOG, 'Waiting for request ID: ' || p_request_id);
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(

Line 59: FND_FILE.put_line(FND_FILE.LOG, 'Accounting Period ID: ' || p_period_id);

55: END IF;
56:
57: FND_FILE.put_line(FND_FILE.LOG, 'Waiting for request ID: ' || p_request_id);
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,

Line 262: FND_FILE.put_line(FND_FILE.LOG,l_message);

258: SET open_flag = 'Y'
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

Line 269: FND_FILE.put_line(FND_FILE.LOG, 'API not compatible');

265:
266: EXCEPTION
267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268: ROLLBACK TO WaitOn_Request_PVT;
269: FND_FILE.put_line(FND_FILE.LOG, 'API not compatible');
270: WHEN l_unprocessed_txn THEN
271: ROLLBACK TO WaitOn_Request_PVT;
272: l_message := 'There exist(s) '|| l_count || ' unprocessed transaction(s) in ' || l_unprocessed_table;
273: FND_FILE.put_line(FND_FILE.LOG,l_message);

Line 273: FND_FILE.put_line(FND_FILE.LOG,l_message);

269: FND_FILE.put_line(FND_FILE.LOG, 'API not compatible');
270: WHEN l_unprocessed_txn THEN
271: ROLLBACK TO WaitOn_Request_PVT;
272: l_message := 'There exist(s) '|| l_count || ' unprocessed transaction(s) in ' || l_unprocessed_table;
273: FND_FILE.put_line(FND_FILE.LOG,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;

Line 282: FND_FILE.put_line(FND_FILE.LOG,l_message);

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);
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;

Line 290: FND_FILE.put_line(FND_FILE.LOG, 'could not launch reconciliation report');

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
292: ROLLBACK TO WaitOn_Request_PVT;
293: FND_FILE.put_line(FND_FILE.LOG, l_stmt_num||':'||SQLERRM);
294: END WaitOn_Request;

Line 293: FND_FILE.put_line(FND_FILE.LOG, l_stmt_num||':'||SQLERRM);

289: ROLLBACK TO WaitOn_Request_PVT;
290: FND_FILE.put_line(FND_FILE.LOG, 'could not launch reconciliation report');
291: WHEN OTHERS THEN
292: ROLLBACK TO WaitOn_Request_PVT;
293: FND_FILE.put_line(FND_FILE.LOG, l_stmt_num||':'||SQLERRM);
294: END WaitOn_Request;
295:
296: END CST_PeriodSummary_PVT;