APPS.OKC_MRV_UTIL dependencies on FND_LOG

Line 33: g_stmt_level NUMBER := fnd_log.level_statement;

29: g_sqlcode_token CONSTANT VARCHAR2 (200) := 'ERROR_CODE';
30: g_amend_code_deleted CONSTANT VARCHAR2 (30) := 'DELETED';
31: g_amend_code_added CONSTANT VARCHAR2 (30) := 'ADDED';
32: g_amend_code_updated CONSTANT VARCHAR2 (30) := 'UPDATED';
33: g_stmt_level NUMBER := fnd_log.level_statement;
34:
35: /*==============================================================
36: PRIVATE PROCEDURES
37: =============================================================*/

Line 384: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

380: WHERE cat_id = p_cat_id AND variable_code = p_variable_code;
381:
382: EXCEPTION
383: WHEN FND_API.G_EXC_ERROR THEN
384: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
385: fnd_log.STRING (g_stmt_level,g_pkg_name,'300: Leaving update_uda_attr_xml: OKC_API.G_EXCEPTION_ERROR Exception');
386: END IF;
387:
388: ROLLBACK TO g_update_uda_attr_xml_GRP;

Line 385: fnd_log.STRING (g_stmt_level,g_pkg_name,'300: Leaving update_uda_attr_xml: OKC_API.G_EXCEPTION_ERROR Exception');

381:
382: EXCEPTION
383: WHEN FND_API.G_EXC_ERROR THEN
384: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
385: fnd_log.STRING (g_stmt_level,g_pkg_name,'300: Leaving update_uda_attr_xml: OKC_API.G_EXCEPTION_ERROR Exception');
386: END IF;
387:
388: ROLLBACK TO g_update_uda_attr_xml_GRP;
389: x_return_status := G_RET_STS_ERROR ;

Line 393: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

389: x_return_status := G_RET_STS_ERROR ;
390: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
391:
392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
393: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
394: fnd_log.STRING (g_stmt_level,g_pkg_name,'400: Leaving update_uda_attr_xml: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
395: END IF;
396:
397:

Line 394: fnd_log.STRING (g_stmt_level,g_pkg_name,'400: Leaving update_uda_attr_xml: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');

390: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
391:
392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
393: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
394: fnd_log.STRING (g_stmt_level,g_pkg_name,'400: Leaving update_uda_attr_xml: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
395: END IF;
396:
397:
398: ROLLBACK TO g_update_uda_attr_xml_GRP;

Line 403: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

399: x_return_status := G_RET_STS_UNEXP_ERROR ;
400: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
401:
402: WHEN OTHERS THEN
403: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
404: fnd_log.STRING (g_stmt_level,g_pkg_name,'500: Leaving update_uda_attr_xml: '||sqlerrm);
405: END IF;
406:
407: OKC_API.SET_MESSAGE(

Line 404: fnd_log.STRING (g_stmt_level,g_pkg_name,'500: Leaving update_uda_attr_xml: '||sqlerrm);

400: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
401:
402: WHEN OTHERS THEN
403: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
404: fnd_log.STRING (g_stmt_level,g_pkg_name,'500: Leaving update_uda_attr_xml: '||sqlerrm);
405: END IF;
406:
407: OKC_API.SET_MESSAGE(
408: p_app_name => G_APP_NAME,