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 FND_PROFILE

Line 4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');

1: PACKAGE BODY OKC_UTIL AS
2: /* $Header: OKCUTILB.pls 120.4 2010/08/09 06:03:27 spingali noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:
6: l_Null_Val_Exception EXCEPTION;
7:
8: -- This is a body global variable storing the value of

Line 1649: l_multiorg VARCHAR2(1) := NVL(FND_PROFILE.VALUE('OKC_VIEW_K_BY_ORG'),'N');

1645: l_orig_sys_source_code okc_k_headers_v.orig_system_source_code%TYPE;
1646: l_ret_status Varchar2(1) ;
1647: l_k_check Varchar2(1);
1648:
1649: l_multiorg VARCHAR2(1) := NVL(FND_PROFILE.VALUE('OKC_VIEW_K_BY_ORG'),'N');
1650: l_authoring_org_id number;
1651: l_org_id number := NVL(FND_PROFILE.VALUE('ORG_ID'), -99);
1652:
1653: exception_modify_access Exception;

Line 1651: l_org_id number := NVL(FND_PROFILE.VALUE('ORG_ID'), -99);

1647: l_k_check Varchar2(1);
1648:
1649: l_multiorg VARCHAR2(1) := NVL(FND_PROFILE.VALUE('OKC_VIEW_K_BY_ORG'),'N');
1650: l_authoring_org_id number;
1651: l_org_id number := NVL(FND_PROFILE.VALUE('ORG_ID'), -99);
1652:
1653: exception_modify_access Exception;
1654: exception_read_access Exception;
1655: exception_no_access Exception;

Line 2316: where g.set_of_books_id=NVL(fnd_profile.value('GL_SET_OF_BKS_ID'),0);

2312: select g.short_name||decode(g.mrc_sob_type_code, 'N', NULL,
2313: decode(l_multi_cur, 'N', NULL,
2314: ': ' || g.currency_code))
2315: from okx_set_of_books_v g
2316: where g.set_of_books_id=NVL(fnd_profile.value('GL_SET_OF_BKS_ID'),0);
2317: Cursor C2 IS
2318: select g.short_name||decode(g.mrc_sob_type_code, 'N', NULL,
2319: decode(l_multi_cur, 'N', NULL,
2320: ': ' || g.currency_code))

Line 2322: where o.id1=NVL(fnd_profile.value('ORG_ID'),0)

2318: select g.short_name||decode(g.mrc_sob_type_code, 'N', NULL,
2319: decode(l_multi_cur, 'N', NULL,
2320: ': ' || g.currency_code))
2321: from okx_set_of_books_v g, okx_organization_defs_v o
2322: where o.id1=NVL(fnd_profile.value('ORG_ID'),0)
2323: and g.set_of_books_id = to_number(o.set_of_books_id)
2324: and o.organization_type= 'OPERATING_UNIT'
2325: and o.information_type= 'Operating Unit Information' ;
2326: BEGIN

Line 2544: IF SUBSTR(LTRIM(RTRIM(FND_PROFILE.VALUE('AFLOG_ENABLED'))),1,1) = 'Y'

2540: --
2541: PROCEDURE Reset_trace_context
2542: IS
2543: BEGIN
2544: IF SUBSTR(LTRIM(RTRIM(FND_PROFILE.VALUE('AFLOG_ENABLED'))),1,1) = 'Y'
2545: THEN -- Disable the log_enabled mode i.e. stop debugging mode
2546: FND_PROFILE.PUT('AFLOG_ENABLED','N');
2547: END IF;
2548:

Line 2546: FND_PROFILE.PUT('AFLOG_ENABLED','N');

2542: IS
2543: BEGIN
2544: IF SUBSTR(LTRIM(RTRIM(FND_PROFILE.VALUE('AFLOG_ENABLED'))),1,1) = 'Y'
2545: THEN -- Disable the log_enabled mode i.e. stop debugging mode
2546: FND_PROFILE.PUT('AFLOG_ENABLED','N');
2547: END IF;
2548:
2549: EXCEPTION
2550: WHEN OTHERS THEN

Line 2802: l_init_profile_log_enabled := FND_PROFILE.VALUE('AFLOG_ENABLED');

2798: l_trace_flag := TRUE;
2799:
2800: -- Obtain the initial profile settings so that it can be reset later.
2801:
2802: l_init_profile_log_enabled := FND_PROFILE.VALUE('AFLOG_ENABLED');
2803: l_init_profile_module_level:= FND_PROFILE.VALUE('AFLOG_LEVEL');
2804: l_init_profile_module_name := FND_PROFILE.VALUE('AFLOG_MODULE');
2805:
2806: l_user_id := fnd_global.user_id; -- obtain the user ID

Line 2803: l_init_profile_module_level:= FND_PROFILE.VALUE('AFLOG_LEVEL');

2799:
2800: -- Obtain the initial profile settings so that it can be reset later.
2801:
2802: l_init_profile_log_enabled := FND_PROFILE.VALUE('AFLOG_ENABLED');
2803: l_init_profile_module_level:= FND_PROFILE.VALUE('AFLOG_LEVEL');
2804: l_init_profile_module_name := FND_PROFILE.VALUE('AFLOG_MODULE');
2805:
2806: l_user_id := fnd_global.user_id; -- obtain the user ID
2807:

Line 2804: l_init_profile_module_name := FND_PROFILE.VALUE('AFLOG_MODULE');

2800: -- Obtain the initial profile settings so that it can be reset later.
2801:
2802: l_init_profile_log_enabled := FND_PROFILE.VALUE('AFLOG_ENABLED');
2803: l_init_profile_module_level:= FND_PROFILE.VALUE('AFLOG_LEVEL');
2804: l_init_profile_module_name := FND_PROFILE.VALUE('AFLOG_MODULE');
2805:
2806: l_user_id := fnd_global.user_id; -- obtain the user ID
2807:
2808: IF l_user_id = -1 -- Non-Apps Mode.

Line 2816: FND_PROFILE.PUT('AFLOG_ENABLED','Y'); -- Enable the log

2812: END IF;
2813:
2814: -- Set the profile values
2815:
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

Line 2817: FND_PROFILE.PUT('AFLOG_LEVEL',1); -- Set the debug level

2813:
2814: -- Set the profile values
2815:
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

Line 2818: FND_PROFILE.PUT('AFLOG_MODULE','OKC'); -- Set the module name

2814: -- Set the profile values
2815:
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

Line 2855: FND_PROFILE.PUT('AFLOG_ENABLED','Y');

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);
2857: FND_PROFILE.PUT('AFLOG_MODULE','OKC');
2858:
2859: FND_LOG_REPOSITORY.INIT(OKC_DEBUG.g_session_id,l_user_id);

Line 2856: FND_PROFILE.PUT('AFLOG_LEVEL',1);

2852: OKC_DEBUG.set_connection_context;
2853: END IF;
2854:
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:

Line 2857: FND_PROFILE.PUT('AFLOG_MODULE','OKC');

2853: END IF;
2854:
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

Line 2880: FND_PROFILE.PUT('AFLOG_ENABLED',l_init_profile_log_enabled);

2876: -- Reset the profile values since the Initialization is already
2877: -- done (mandatory step in case our API is called by an external
2878: -- API which may have different settings from ours)
2879:
2880: FND_PROFILE.PUT('AFLOG_ENABLED',l_init_profile_log_enabled);
2881: FND_PROFILE.PUT('AFLOG_LEVEL',l_init_profile_module_level);
2882: FND_PROFILE.PUT('AFLOG_MODULE',l_init_profile_module_name);
2883:
2884: -- Set up the oracle trace enable to true and print out the DB trace file info

Line 2881: FND_PROFILE.PUT('AFLOG_LEVEL',l_init_profile_module_level);

2877: -- done (mandatory step in case our API is called by an external
2878: -- API which may have different settings from ours)
2879:
2880: FND_PROFILE.PUT('AFLOG_ENABLED',l_init_profile_log_enabled);
2881: FND_PROFILE.PUT('AFLOG_LEVEL',l_init_profile_module_level);
2882: FND_PROFILE.PUT('AFLOG_MODULE',l_init_profile_module_name);
2883:
2884: -- Set up the oracle trace enable to true and print out the DB trace file info
2885:

Line 2882: FND_PROFILE.PUT('AFLOG_MODULE',l_init_profile_module_name);

2878: -- API which may have different settings from ours)
2879:
2880: FND_PROFILE.PUT('AFLOG_ENABLED',l_init_profile_log_enabled);
2881: FND_PROFILE.PUT('AFLOG_LEVEL',l_init_profile_module_level);
2882: FND_PROFILE.PUT('AFLOG_MODULE',l_init_profile_module_name);
2883:
2884: -- Set up the oracle trace enable to true and print out the DB trace file info
2885:
2886: END IF;

Line 3142: v number := fnd_profile.value('OKC_PERCENT_FOR_IDX');

3138: -- returns 0 if small group, and 1 if not
3139:
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');