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_UTIL dependencies on OKC_DEBUG

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 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 2205: okc_debug.log('1000: Entered Copy_Articles_Varied_Text', 2);

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;
2209: UPDATE okc_article_versions

Line 2206: okc_debug.log('1001: p_article_id: '||p_article_id, 2);

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;
2209: UPDATE okc_article_versions
2210: SET article_text

Line 2207: okc_debug.log('1002: p_sae_id: '||p_sae_id, 2);

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;
2209: UPDATE okc_article_versions
2210: SET article_text
2211: = (SELECT article_text FROM okc_article_versions

Line 2222: okc_debug.log('1010: Leaving Copy_Articles_Varied_Text', 2);

2218: WHERE article_version_id
2219: =(SELECT article_version_id
2220: FROM okc_k_articles_b WHERE id = p_article_id);
2221: IF (l_debug = 'Y') THEN
2222: okc_debug.log('1010: Leaving Copy_Articles_Varied_Text', 2);
2223: okc_debug.Reset_Indentation;
2224: END IF;
2225: return l_return_status;
2226: EXCEPTION

Line 2223: okc_debug.Reset_Indentation;

2219: =(SELECT article_version_id
2220: FROM okc_k_articles_b WHERE id = p_article_id);
2221: IF (l_debug = 'Y') THEN
2222: okc_debug.log('1010: Leaving Copy_Articles_Varied_Text', 2);
2223: okc_debug.Reset_Indentation;
2224: END IF;
2225: return l_return_status;
2226: EXCEPTION
2227: When OTHERS Then

Line 2229: okc_debug.log('1020: Leaving Copy_Articles_Varied_Text because of an exception: '||sqlerrm, 2);

2225: return l_return_status;
2226: EXCEPTION
2227: When OTHERS Then
2228: IF (l_debug = 'Y') THEN
2229: okc_debug.log('1020: Leaving Copy_Articles_Varied_Text because of an exception: '||sqlerrm, 2);
2230: okc_debug.Reset_Indentation;
2231: END IF;
2232: OKC_API.SET_MESSAGE(
2233: p_app_name => G_APP_NAME,

Line 2230: okc_debug.Reset_Indentation;

2226: EXCEPTION
2227: When OTHERS Then
2228: IF (l_debug = 'Y') THEN
2229: okc_debug.log('1020: Leaving Copy_Articles_Varied_Text because of an exception: '||sqlerrm, 2);
2230: okc_debug.Reset_Indentation;
2231: END IF;
2232: OKC_API.SET_MESSAGE(
2233: p_app_name => G_APP_NAME,
2234: p_msg_name => G_UNEXPECTED_ERROR,

Line 2690: -- The print trace procedure serves as a wrapper to the OKC_DEBUG API.

2686: l_mesg VARCHAR2(1900);
2687: l_level NUMBER;
2688: l_db_module VARCHAR2(200);
2689:
2690: -- The print trace procedure serves as a wrapper to the OKC_DEBUG API.
2691:
2692: BEGIN
2693:
2694: l_indent :=p_indent;

Line 2702: OKC_DEBUG.log(l_mesg,l_level,l_db_module);

2698: l_mesg:=LPAD(p_trace_line, LENGTH(p_trace_line)+(4*p_indent), ' ');
2699:
2700: IF l_trace_flag THEN -- If true, write into fnd_log_messages
2701: IF (l_debug = 'Y') THEN
2702: OKC_DEBUG.log(l_mesg,l_level,l_db_module);
2703: END IF;
2704: ELSE -- write into log file for the conc.program
2705:
2706: IF l_log_flag AND l_trace_file.id IS NOT NULL THEN

Line 2811: OKC_DEBUG.g_session_id := sys_context('USERENV','SESSIONID');

2807:
2808: IF l_user_id = -1 -- Non-Apps Mode.
2809: THEN
2810: IF (l_debug = 'Y') THEN
2811: OKC_DEBUG.g_session_id := sys_context('USERENV','SESSIONID');
2812: END IF;
2813:
2814: -- Set the profile values
2815:

Line 2820: --In the Non-apps mode the value of g_profile_log_level in the okc_debug API

2816: FND_PROFILE.PUT('AFLOG_ENABLED','Y'); -- Enable the log
2817: FND_PROFILE.PUT('AFLOG_LEVEL',1); -- Set the debug level
2818: FND_PROFILE.PUT('AFLOG_MODULE','OKC'); -- Set the module name
2819: --
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

Line 2825: --looping in the set connection context procedure in the OKC_DEBUG package, so

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:
2829: -- Initialize the current runtime level

Line 2831: FND_LOG_REPOSITORY.INIT(OKC_DEBUG.g_session_id,l_user_id);

2827: --
2828:
2829: -- Initialize the current runtime level
2830:
2831: FND_LOG_REPOSITORY.INIT(OKC_DEBUG.g_session_id,l_user_id);
2832: -- Bug 1996039 Initializing aso debug
2833: aso_debug_pub.debug_on;
2834: aso_debug_pub.initialize;
2835: l_file :=aso_DEBUG_PUB.Set_Debug_Mode('FILE');

Line 2848: --g_profile_log_level value (p_level of okc_debug.log will be then greater

2844: --but since the set connection context is already
2845: --executed (to run apps_initialize) and has set up g_profile_log_level,
2846: --we need now to explicitly call fnd_log_repository.init to assign the
2847: --new value of G_CURRENT_RUNTIME_LEVEL, which is then used to initialize
2848: --g_profile_log_level value (p_level of okc_debug.log will be then greater
2849: --or equal to g_profile_log_level)
2850: --
2851: IF (l_debug = 'Y') THEN
2852: OKC_DEBUG.set_connection_context;

Line 2852: OKC_DEBUG.set_connection_context;

2848: --g_profile_log_level value (p_level of okc_debug.log will be then greater
2849: --or equal to g_profile_log_level)
2850: --
2851: IF (l_debug = 'Y') THEN
2852: OKC_DEBUG.set_connection_context;
2853: END IF;
2854:
2855: FND_PROFILE.PUT('AFLOG_ENABLED','Y');
2856: FND_PROFILE.PUT('AFLOG_LEVEL',1);

Line 2859: FND_LOG_REPOSITORY.INIT(OKC_DEBUG.g_session_id,l_user_id);

2855: FND_PROFILE.PUT('AFLOG_ENABLED','Y');
2856: FND_PROFILE.PUT('AFLOG_LEVEL',1);
2857: FND_PROFILE.PUT('AFLOG_MODULE','OKC');
2858:
2859: FND_LOG_REPOSITORY.INIT(OKC_DEBUG.g_session_id,l_user_id);
2860:
2861: IF (l_debug = 'Y') THEN
2862: OKC_DEBUG.g_profile_log_level := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
2863: END IF;

Line 2862: OKC_DEBUG.g_profile_log_level := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;

2858:
2859: FND_LOG_REPOSITORY.INIT(OKC_DEBUG.g_session_id,l_user_id);
2860:
2861: IF (l_debug = 'Y') THEN
2862: OKC_DEBUG.g_profile_log_level := Fnd_Log.G_CURRENT_RUNTIME_LEVEL;
2863: END IF;
2864: -- Bug 1996039 Initializing aso debug
2865: aso_debug_pub.debug_on;
2866: aso_debug_pub.initialize;

Line 3314: okc_debug.log('11400: Entering Prepare_Contract_Terms ', 2);

3310: SELECT TEMPLATE_ID FROM okc_terms_templates_all
3311: WHERE template_name = l_tmpl_name and org_id=l_org_id;
3312: BEGIN
3313: IF (l_debug = 'Y') THEN
3314: okc_debug.log('11400: Entering Prepare_Contract_Terms ', 2);
3315: END IF;
3316: x_return_status:=OKC_API.G_RET_STS_SUCCESS;
3317: OKC_TERMS_UTIL_GRP.Get_Contract_Document_Type_id(
3318: p_api_version => 1,

Line 3436: okc_debug.log('900: Leaving Prepare_Contract_Terms.', 2);

3432: END IF;
3433: END IF;
3434:
3435: IF (l_debug = 'Y') THEN
3436: okc_debug.log('900: Leaving Prepare_Contract_Terms.', 2);
3437: END IF;
3438:
3439: EXCEPTION
3440:

Line 3443: okc_debug.log('500: Leaving Prepare_Contract_Terms because of FND_API.G_EXC_UNEXPECTED_ERROR ', 2);

3439: EXCEPTION
3440:
3441: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3442: IF (l_debug = 'Y') THEN
3443: okc_debug.log('500: Leaving Prepare_Contract_Terms because of FND_API.G_EXC_UNEXPECTED_ERROR ', 2);
3444: END IF;
3445:
3446: IF get_doc_usage_crs%ISOPEN THEN
3447: CLOSE get_doc_usage_crs;

Line 3462: okc_debug.log('500: Leaving Prepare_Contract_Terms because of FND_API.G_EXC_ERROR. ', 2);

3458: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
3459:
3460: WHEN FND_API.G_EXC_ERROR THEN
3461: IF (l_debug = 'Y') THEN
3462: okc_debug.log('500: Leaving Prepare_Contract_Terms because of FND_API.G_EXC_ERROR. ', 2);
3463: END IF;
3464:
3465: IF get_doc_usage_crs%ISOPEN THEN
3466: CLOSE get_doc_usage_crs;

Line 3481: okc_debug.log('500: Leaving Prepare_Contract_Terms because of EXCEPTION: '||sqlerrm, 2);

3477: x_return_status := FND_API.G_RET_STS_ERROR ;
3478:
3479: WHEN OTHERS THEN
3480: IF (l_debug = 'Y') THEN
3481: okc_debug.log('500: Leaving Prepare_Contract_Terms because of EXCEPTION: '||sqlerrm, 2);
3482: END IF;
3483:
3484: IF get_doc_usage_crs%ISOPEN THEN
3485: CLOSE get_doc_usage_crs;