eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_MRV_UTIL dependencies on FND_API

Line 21: g_false CONSTANT VARCHAR2 (1) := fnd_api.g_false;

17: g_app_name CONSTANT VARCHAR2 (3) := okc_api.g_app_name;
18: ------------------------------------------------------------------------------
19: -- GLOBAL CONSTANTS
20: ------------------------------------------------------------------------------
21: g_false CONSTANT VARCHAR2 (1) := fnd_api.g_false;
22: g_true CONSTANT VARCHAR2 (1) := fnd_api.g_true;
23: g_ret_sts_success CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_success;
24: g_ret_sts_error CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_error;
25: g_ret_sts_unexp_error CONSTANT VARCHAR2 (1)

Line 22: g_true CONSTANT VARCHAR2 (1) := fnd_api.g_true;

18: ------------------------------------------------------------------------------
19: -- GLOBAL CONSTANTS
20: ------------------------------------------------------------------------------
21: g_false CONSTANT VARCHAR2 (1) := fnd_api.g_false;
22: g_true CONSTANT VARCHAR2 (1) := fnd_api.g_true;
23: g_ret_sts_success CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_success;
24: g_ret_sts_error CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_error;
25: g_ret_sts_unexp_error CONSTANT VARCHAR2 (1)
26: := fnd_api.g_ret_sts_unexp_error;

Line 23: g_ret_sts_success CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_success;

19: -- GLOBAL CONSTANTS
20: ------------------------------------------------------------------------------
21: g_false CONSTANT VARCHAR2 (1) := fnd_api.g_false;
22: g_true CONSTANT VARCHAR2 (1) := fnd_api.g_true;
23: g_ret_sts_success CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_success;
24: g_ret_sts_error CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_error;
25: g_ret_sts_unexp_error CONSTANT VARCHAR2 (1)
26: := fnd_api.g_ret_sts_unexp_error;
27: g_unexpected_error CONSTANT VARCHAR2 (200) := 'OKC_UNEXPECTED_ERROR';

Line 24: g_ret_sts_error CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_error;

20: ------------------------------------------------------------------------------
21: g_false CONSTANT VARCHAR2 (1) := fnd_api.g_false;
22: g_true CONSTANT VARCHAR2 (1) := fnd_api.g_true;
23: g_ret_sts_success CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_success;
24: g_ret_sts_error CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_error;
25: g_ret_sts_unexp_error CONSTANT VARCHAR2 (1)
26: := fnd_api.g_ret_sts_unexp_error;
27: g_unexpected_error CONSTANT VARCHAR2 (200) := 'OKC_UNEXPECTED_ERROR';
28: g_sqlerrm_token CONSTANT VARCHAR2 (200) := 'ERROR_MESSAGE';

Line 26: := fnd_api.g_ret_sts_unexp_error;

22: g_true CONSTANT VARCHAR2 (1) := fnd_api.g_true;
23: g_ret_sts_success CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_success;
24: g_ret_sts_error CONSTANT VARCHAR2 (1) := fnd_api.g_ret_sts_error;
25: g_ret_sts_unexp_error CONSTANT VARCHAR2 (1)
26: := fnd_api.g_ret_sts_unexp_error;
27: g_unexpected_error CONSTANT VARCHAR2 (200) := 'OKC_UNEXPECTED_ERROR';
28: g_sqlerrm_token CONSTANT VARCHAR2 (200) := 'ERROR_MESSAGE';
29: g_sqlcode_token CONSTANT VARCHAR2 (200) := 'ERROR_CODE';
30: g_amend_code_deleted CONSTANT VARCHAR2 (30) := 'DELETED';

Line 340: IF FND_API.to_Boolean( p_init_msg_list ) THEN

336: -- Standard Start of API savepoint
337: SAVEPOINT g_update_uda_attr_xml_GRP;
338:
339: -- Initialize message list if p_init_msg_list is set to TRUE.
340: IF FND_API.to_Boolean( p_init_msg_list ) THEN
341: FND_MSG_PUB.initialize;
342: END IF;
343:
344:

Line 350: p_init_msg_list => FND_API.G_FALSE,

346: IF p_mode='AMEND' THEN
347:
348: OKC_K_ARTICLES_GRP.update_article(
349: p_api_version =>1,
350: p_init_msg_list => FND_API.G_FALSE,
351: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
352: p_validate_commit => FND_API.G_FALSE,
353: p_validation_string => NULL,
354: p_commit => FND_API.G_FALSE,

Line 351: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

347:
348: OKC_K_ARTICLES_GRP.update_article(
349: p_api_version =>1,
350: p_init_msg_list => FND_API.G_FALSE,
351: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
352: p_validate_commit => FND_API.G_FALSE,
353: p_validation_string => NULL,
354: p_commit => FND_API.G_FALSE,
355: p_mode => p_mode,

Line 352: p_validate_commit => FND_API.G_FALSE,

348: OKC_K_ARTICLES_GRP.update_article(
349: p_api_version =>1,
350: p_init_msg_list => FND_API.G_FALSE,
351: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
352: p_validate_commit => FND_API.G_FALSE,
353: p_validation_string => NULL,
354: p_commit => FND_API.G_FALSE,
355: p_mode => p_mode,
356: x_return_status => x_return_status,

Line 354: p_commit => FND_API.G_FALSE,

350: p_init_msg_list => FND_API.G_FALSE,
351: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
352: p_validate_commit => FND_API.G_FALSE,
353: p_validation_string => NULL,
354: p_commit => FND_API.G_FALSE,
355: p_mode => p_mode,
356: x_return_status => x_return_status,
357: x_msg_count => x_msg_count,
358: x_msg_data => x_msg_data,

Line 367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

363: p_lock_terms_yn => p_locking_enabled
364: );
365: --------------------------------------------
366: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
368: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
369: RAISE FND_API.G_EXC_ERROR ;
370: END IF;
371: --------------------------------------------

Line 369: RAISE FND_API.G_EXC_ERROR ;

365: --------------------------------------------
366: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
367: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
368: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
369: RAISE FND_API.G_EXC_ERROR ;
370: END IF;
371: --------------------------------------------
372:
373: END IF; -- mode = AMEND

Line 383: WHEN FND_API.G_EXC_ERROR THEN

379: get_uda_attr_xml (p_cat_id, p_variable_code, p_attr_group_id)
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:

Line 392: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

388: ROLLBACK TO g_update_uda_attr_xml_GRP;
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:

Line 647: p_commit => fnd_api.g_false,

643: p_old_dtlevel_col_value_pairs => l_dtlevel_col_value_pairs,
644: p_new_pk_col_value_pairs => to_pk_col_value_pairs,
645: p_new_data_level_id => l_main_data_level_id,
646: p_new_dtlevel_col_value_pairs => l_dtlevel_col_value_pairs,
647: p_commit => fnd_api.g_false,
648: x_return_status => x_return_status,
649: x_errorcode => x_errorcode,
650: x_msg_count => x_msg_count,
651: x_msg_data => x_msg_data