DBA Data[Home] [Help]

APPS.GL_EBI_PUB dependencies on FND_API

Line 24: x_return_status := FND_API.G_RET_STS_SUCCESS;

20: l_param_name VARCHAR2(30):='AUTO_ADJUST_TO_DATE';
21: l_auto_adjust_to_date VARCHAR2(30):='FALSE';
22: BEGIN
23: FND_MSG_PUB.initialize();
24: x_return_status := FND_API.G_RET_STS_SUCCESS;
25:
26: IF(p_name_value_tbl IS NOT NULL AND p_name_value_tbl.COUNT > 0) THEN
27: FOR i IN p_name_value_tbl.FIRST..p_name_value_tbl.LAST LOOP
28: IF (UPPER(p_name_value_tbl(i).param_name) = UPPER(l_param_name))THEN

Line 193: IF p_commit = FND_API.g_true THEN

189: '', '', '', '', '', '', '', '', '', '',
190: '');
191: x_request_id := l_request_id;
192:
193: IF p_commit = FND_API.g_true THEN
194: COMMIT;
195: END IF;
196:
197: IF l_request_id = 0 THEN

Line 199: RAISE FND_API.g_exc_error;

195: END IF;
196:
197: IF l_request_id = 0 THEN
198: FND_MESSAGE.RETRIEVE(x_msg_data);
199: RAISE FND_API.g_exc_error;
200: END IF;
201:
202:
203: EXCEPTION

Line 204: WHEN FND_API.g_exc_error THEN

200: END IF;
201:
202:
203: EXCEPTION
204: WHEN FND_API.g_exc_error THEN
205: x_return_status := FND_API.g_ret_sts_error;
206: WHEN OTHERS THEN
207: x_return_status := FND_API.g_ret_sts_unexp_error;
208: x_msg_data := SQLERRM ||' at process_currency_exc_rate_list';

Line 205: x_return_status := FND_API.g_ret_sts_error;

201:
202:
203: EXCEPTION
204: WHEN FND_API.g_exc_error THEN
205: x_return_status := FND_API.g_ret_sts_error;
206: WHEN OTHERS THEN
207: x_return_status := FND_API.g_ret_sts_unexp_error;
208: x_msg_data := SQLERRM ||' at process_currency_exc_rate_list';
209: END process_currency_exc_rate_list;

Line 207: x_return_status := FND_API.g_ret_sts_unexp_error;

203: EXCEPTION
204: WHEN FND_API.g_exc_error THEN
205: x_return_status := FND_API.g_ret_sts_error;
206: WHEN OTHERS THEN
207: x_return_status := FND_API.g_ret_sts_unexp_error;
208: x_msg_data := SQLERRM ||' at process_currency_exc_rate_list';
209: END process_currency_exc_rate_list;
210:
211: PROCEDURE purge_currency_exc_rate_list(

Line 258: x_return_status := FND_API.G_RET_STS_SUCCESS;

254: BATCH_NUMBER = p_integration_id;
255:
256: l_err_msg VARCHAR2(32000);
257: BEGIN
258: x_return_status := FND_API.G_RET_STS_SUCCESS;
259:
260: OPEN c_get_err_rows(p_integration_id);
261: FETCH c_get_err_rows BULK COLLECT INTO x_daily_rates_tbl;
262: CLOSE c_get_err_rows;

Line 265: x_return_status := FND_API.g_ret_sts_error;

261: FETCH c_get_err_rows BULK COLLECT INTO x_daily_rates_tbl;
262: CLOSE c_get_err_rows;
263:
264: IF x_daily_rates_tbl IS NOT NULL AND x_daily_rates_tbl.COUNT >0 THEN
265: x_return_status := FND_API.g_ret_sts_error;
266:
267: FOR i IN x_daily_rates_tbl.FIRST..x_daily_rates_tbl.LAST LOOP
268:
269: l_err_msg := 'From Currency-'||x_daily_rates_tbl(i).FROM_CURRENCY||' To Currency-'||

Line 285: IF p_commit = FND_API.g_true THEN

281: DELETE FROM gl_daily_rates_interface WHERE batch_number = p_integration_id;
282:
283: END IF;
284:
285: IF p_commit = FND_API.g_true THEN
286: COMMIT;
287: END IF;
288:
289: EXCEPTION

Line 291: x_return_status := FND_API.g_ret_sts_unexp_error;

287: END IF;
288:
289: EXCEPTION
290: WHEN OTHERS THEN
291: x_return_status := FND_API.g_ret_sts_unexp_error;
292: x_msg_data := SQLERRM ||' at purge_currency_exc_rate_list';
293:
294: IF (c_get_err_rows%ISOPEN) THEN
295: CLOSE c_get_err_rows;

Line 324: x_return_status := FND_API.G_RET_STS_SUCCESS;

320: l_resp_id NUMBER;
321: l_apps_id NUMBER;
322:
323: BEGIN
324: x_return_status := FND_API.G_RET_STS_SUCCESS;
325:
326: IF p_acct_period_tbl IS NOT NULL AND p_acct_period_tbl.COUNT >0 THEN
327:
328: FOR i IN p_acct_period_tbl.FIRST..p_acct_period_tbl.LAST LOOP

Line 350: IF l_ret_status <> FND_API.g_ret_sts_success THEN

346: ,errbuf => l_err_msg
347: ,retcode => l_ret_code
348: );
349:
350: IF l_ret_status <> FND_API.g_ret_sts_success THEN
351: x_return_status := FND_API.g_ret_sts_error;
352: IF x_msg_data IS NULL THEN
353: x_msg_data := l_err_msg || FND_GLOBAL.newline;
354: ELSE

Line 351: x_return_status := FND_API.g_ret_sts_error;

347: ,retcode => l_ret_code
348: );
349:
350: IF l_ret_status <> FND_API.g_ret_sts_success THEN
351: x_return_status := FND_API.g_ret_sts_error;
352: IF x_msg_data IS NULL THEN
353: x_msg_data := l_err_msg || FND_GLOBAL.newline;
354: ELSE
355: x_msg_data := x_msg_data || l_err_msg || FND_GLOBAL.newline;

Line 362: IF p_commit = FND_API.g_true THEN

358:
359: END LOOP;
360: END IF;
361:
362: IF p_commit = FND_API.g_true THEN
363: COMMIT;
364: END IF;
365:
366: EXCEPTION

Line 368: x_return_status := FND_API.g_ret_sts_unexp_error;

364: END IF;
365:
366: EXCEPTION
367: WHEN OTHERS THEN
368: x_return_status := FND_API.g_ret_sts_unexp_error;
369: x_msg_data := SQLERRM ||' at process_accounting_period_list';
370: END process_accounting_period_list;
371:
372: END GL_EBI_PUB;