DBA Data[Home] [Help]

APPS.RCV_SLA_MRC_UPDATE_PKG dependencies on FND_API

Line 62: x_retcode := FND_API.G_RET_STS_SUCCESS;

58: l_upg_batch_id := X_upg_batch_id;
59:
60: l_je_category_name := X_je_category_name;
61:
62: x_retcode := FND_API.G_RET_STS_SUCCESS;
63:
64: insert all
65: when (line_id=1) then
66: into xla_ae_headers (

Line 348: WHEN fnd_api.g_exc_unexpected_error THEN

344: END IF;
345:
346: EXCEPTION
347:
348: WHEN fnd_api.g_exc_unexpected_error THEN
349: ROLLBACK;
350: X_retcode := FND_API.g_ret_sts_unexp_error;
351: IF l_exceptionlog THEN
352: fnd_msg_pub.add_exc_msg(

Line 350: X_retcode := FND_API.g_ret_sts_unexp_error;

346: EXCEPTION
347:
348: WHEN fnd_api.g_exc_unexpected_error THEN
349: ROLLBACK;
350: X_retcode := FND_API.g_ret_sts_unexp_error;
351: IF l_exceptionlog THEN
352: fnd_msg_pub.add_exc_msg(
353: p_pkg_name => 'RCV_SLA_MRC_UPDATE_PKG',
354: p_procedure_name => 'Update_Receiving_MRC_Subledger',

Line 364: WHEN fnd_api.g_exc_error THEN

360: 'An exception has occurred.'
361: );
362: END IF;
363: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
364: WHEN fnd_api.g_exc_error THEN
365: ROLLBACK;
366: X_retcode := FND_API.g_ret_sts_error;
367: IF l_errorLog THEN
368: fnd_message.set_name('BOM','CST_ERROR');

Line 366: X_retcode := FND_API.g_ret_sts_error;

362: END IF;
363: X_errbuf:=l_module||'.'||l_stmt_num||': An exception has occurred.';
364: WHEN fnd_api.g_exc_error THEN
365: ROLLBACK;
366: X_retcode := FND_API.g_ret_sts_error;
367: IF l_errorLog THEN
368: fnd_message.set_name('BOM','CST_ERROR');
369: fnd_message.set_token('SQLERRM',SQLERRM);
370: fnd_msg_pub.add;

Line 380: X_retcode := FND_API.g_ret_sts_unexp_error;

376: END IF;
377: X_errbuf:=l_module||'.'||l_stmt_num||': '|| SQLERRM;
378: WHEN OTHERS THEN
379: ROLLBACK;
380: X_retcode := FND_API.g_ret_sts_unexp_error;
381: IF (FND_LOG.LEVEL_UNEXPECTED >= G_LOG_LEVEL) THEN
382: fnd_message.set_name('BOM','CST_UNEXPECTED');
383: fnd_message.set_token('SQLERRM',SQLERRM);
384: fnd_msg_pub.add;