DBA Data[Home] [Help]

APPS.PAY_SLA_UPDATE_PKG dependencies on FND_API

Line 227: IF NOT FND_API.Compatible_API_Call (

223: raise_application_error(-20001, 'SUBMIT_SUBREQUESTS() must be called from a concurrent request');
224: end if;
225:
226: -- Standard call to check for call compatibility
227: IF NOT FND_API.Compatible_API_Call (
228: l_api_version,
229: 1.0,
230: l_api_name,
231: G_PKG_NAME ) THEN

Line 232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

228: l_api_version,
229: 1.0,
230: l_api_name,
231: G_PKG_NAME ) THEN
232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
233: END IF;
234:
235: x_retcode := FND_API.G_RET_STS_SUCCESS;
236:

Line 235: x_retcode := FND_API.G_RET_STS_SUCCESS;

231: G_PKG_NAME ) THEN
232: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
233: END IF;
234:
235: x_retcode := FND_API.G_RET_STS_SUCCESS;
236:
237: l_product :='PAY';
238:
239: l_stmt_num :=10;

Line 322: x_retcode := FND_API.G_RET_STS_SUCCESS;

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()
325: loop
326:

Line 328: X_retcode := FND_API.g_ret_sts_unexp_error;

324: for i IN 1..l_sub_reqtab.COUNT()
325: loop
326:
327: if (l_sub_reqtab(i).dev_status <> 'NORMAL') then
328: X_retcode := FND_API.g_ret_sts_unexp_error;
329: end if;
330:
331: end loop;
332:

Line 333: if (X_retcode = FND_API.G_RET_STS_SUCCESS) then

329: end if;
330:
331: end loop;
332:
333: if (X_retcode = FND_API.G_RET_STS_SUCCESS) then
334: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');
335: fnd_file.put_line(FND_FILE.LOG,'-------------------Upgrade of Historical Payroll data to Subledger Accounting---------');
336: fnd_file.put_line(FND_FILE.LOG,'--------------------------------------------------------------------------------------');
337: fnd_file.put_line(FND_FILE.LOG,'Parameters:');

Line 368: X_retcode := FND_API.g_ret_sts_unexp_error;

364: End if;
365:
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

Line 372: WHEN fnd_api.g_exc_unexpected_error 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:
375: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
376: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);

Line 373: 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:
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:

Line 378: WHEN fnd_api.g_exc_error THEN

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:
381: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
382: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);

Line 379: X_retcode := FND_API.g_ret_sts_error;

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:
381: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
382: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
383:

Line 385: X_retcode := FND_API.g_ret_sts_unexp_error;

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;
387: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
388:
389: END Update_Proc_PAY_MGR;

Line 495: if (X_retcode <>FND_API.G_RET_STS_SUCCESS) then

491: If lv_debug_enabled then
492: fnd_file.put_line(fnd_file.log,'After calling Update_Payroll_Subledger');
493: End if;
494:
495: if (X_retcode <>FND_API.G_RET_STS_SUCCESS) then
496: raise update_subledger_exception;
497: end if;
498:
499: l_rows_processed := X_batch_size;

Line 538: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 540: X_retcode := FND_API.g_ret_sts_unexp_error;

536: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
537:
538: WHEN fnd_api.g_exc_unexpected_error THEN
539: ROLLBACK;
540: X_retcode := FND_API.g_ret_sts_unexp_error;
541: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
542: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
543:
544: WHEN fnd_api.g_exc_error THEN

Line 544: WHEN fnd_api.g_exc_error THEN

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

Line 546: X_retcode := FND_API.g_ret_sts_error;

542: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
543:
544: WHEN fnd_api.g_exc_error THEN
545: ROLLBACK;
546: X_retcode := FND_API.g_ret_sts_error;
547: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
548: l_conc_status:=FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR',X_errbuf);
549:
550: WHEN OTHERS THEN

Line 552: X_retcode := FND_API.g_ret_sts_unexp_error;

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