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 498: if (X_retcode <>FND_API.G_RET_STS_SUCCESS) then

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

Line 541: WHEN fnd_api.g_exc_unexpected_error THEN

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

Line 543: X_retcode := FND_API.g_ret_sts_unexp_error;

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

Line 547: WHEN fnd_api.g_exc_error THEN

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

Line 549: X_retcode := FND_API.g_ret_sts_error;

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

Line 555: X_retcode := FND_API.g_ret_sts_unexp_error;

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