APPS.OKC_UTIL dependencies on OKC_UTIL

Line 1: PACKAGE BODY OKC_UTIL AS

1: PACKAGE BODY OKC_UTIL AS
2: /* $Header: OKCUTILB.pls 120.2 2005/07/21 00:10:03 mmadhavi noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:

Line 88: okc_debug.Set_Indentation('OKC_UTIL');

84:
85: BEGIN
86:
87: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
88: okc_debug.Set_Indentation('OKC_UTIL');
89: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,l_module||l_api_name,'Entered Dff_Displayed');
90: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,l_module||l_api_name,'p_application_short_name' ||p_application_short_name);
91: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE ,l_module||l_api_name,'p_dff_name' ||p_dff_name);
92: END IF;

Line 148: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_module||l_api_name,'leaving OKC_UTIL.Dff_Displayed with error');

144:
145: EXCEPTION
146: WHEN OTHERS THEN
147: IF ( FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
148: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED ,l_module||l_api_name,'leaving OKC_UTIL.Dff_Displayed with error');
149: END IF;
150:
151: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
152: FND_MSG_PUB.Add_Exc_Msg(l_module,l_api_name);

Line 2204: okc_debug.Set_Indentation('OKC_UTIL');

2200: ) RETURN VARCHAR2 Is
2201: l_return_status VARCHAR2(1) := 'S';
2202: BEGIN
2203: IF (l_debug = 'Y') THEN
2204: okc_debug.Set_Indentation('OKC_UTIL');
2205: okc_debug.log('1000: Entered Copy_Articles_Varied_Text', 2);
2206: okc_debug.log('1001: p_article_id: '||p_article_id, 2);
2207: okc_debug.log('1002: p_sae_id: '||p_sae_id, 2);
2208: END IF;

Line 2824: --Also, when the okc_util.print_trace is called it DOESNOT go through the

2820: --In the Non-apps mode the value of g_profile_log_level in the okc_debug API
2821: --is set to 0. However in the subsequent call to the Fnd_Log.test procedure
2822: --the value of G_CURRENT_RUNTIME_LEVEL is used.Hence we need to set its value
2823: --to 1 by executing the fnd_log_repository.init procedure call,as done below.
2824: --Also, when the okc_util.print_trace is called it DOESNOT go through the
2825: --looping in the set connection context procedure in the OKC_DEBUG package, so
2826: --g_profile_log_level is never set and it is defaulted to 0
2827: --
2828:

Line 3144: select sum(OKC_UTIL.get_prcnt('OKC','OKC_K_GRPINGS','CGP_PARENT_ID',g.id)) into d

3140: Function grp_dense(p_grp_like varchar2) return number is
3141: d number;
3142: v number := fnd_profile.value('OKC_PERCENT_FOR_IDX');
3143: begin
3144: select sum(OKC_UTIL.get_prcnt('OKC','OKC_K_GRPINGS','CGP_PARENT_ID',g.id)) into d
3145: from okc_k_groups_tl g
3146: where g.name like p_grp_like and g.language=userenv('LANG');
3147: if (d is NULL or d<=v) then return 0;
3148: else return 1;

Line 3516: END OKC_UTIL;

3512: BULK COLLECT INTO g_language_code
3513: FROM fnd_languages
3514: WHERE installed_flag IN ( 'I', 'B' );
3515:
3516: END OKC_UTIL;