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_ASYNC_PVT dependencies on FND_PROFILE

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

1: package body OKC_ASYNC_PVT as
2: /* $Header: OKCRASNB.pls 120.3 2005/12/14 22:11:36 npalepu noship $ */
3:
4: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
5:
6: G_MUTE_PROFILE CONSTANT VARCHAR2(30) := 'OKC_SUPPRESS_EMAILS';
7: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
8: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_ASYNC_PVT';

Line 1065: l_timeout_minutes := fnd_profile.value('OKC_ALERT_TIMEOUT');

1061: -- RUN mode - normal process execution
1062: --
1063: /* MSENGUPT: Introduced the following code to re-read and reset the profile option in case of timeouts due to errors */
1064: if (funcmode <> 'RUN') then
1065: l_timeout_minutes := fnd_profile.value('OKC_ALERT_TIMEOUT');
1066: if l_timeout_minutes IS NOT NULL then
1067: wf_engine.SetItemAttrNumber (itemtype, itemkey, 'P_TIMEOUT_MINUTES', L_TIMEOUT_MINUTES);
1068: end if;
1069: end if;

Line 2053: l_timeout_minutes := fnd_profile.value('OKC_ALERT_TIMEOUT');

2049: /* MSENGUPT: The following code is changed from the previous version to make it more effucient. ie. read c_wf_timeout only
2050: if l_timeout_minutes from profile options is NULL...... very less likely */
2051: -- determine the value of p_timeout_minutes
2052: If l_timeout_minutes IS NULL THEN
2053: l_timeout_minutes := fnd_profile.value('OKC_ALERT_TIMEOUT');
2054: IF l_timeout_minutes IS NULL THEN
2055: -- get the defualt value for p_timeout_minutes from the OKCALERT workflow
2056: OPEN c_wf_timeout;
2057: FETCH c_wf_timeout INTO l_wf_timeout_minutes;

Line 2318: l_p_value := FND_PROFILE.VALUE_SPECIFIC

2314: if (funcmode = 'RUN') then
2315: open c1(l_user_name);
2316: fetch c1 into l_user_id;
2317: close c1;
2318: l_p_value := FND_PROFILE.VALUE_SPECIFIC
2319: (NAME => G_MUTE_PROFILE||'_'||l_ntf_type,
2320: USER_ID => l_user_id,
2321: RESPONSIBILITY_ID => NULL,
2322: APPLICATION_ID => NULL);

Line 2324: l_p_value := FND_PROFILE.VALUE_SPECIFIC

2320: USER_ID => l_user_id,
2321: RESPONSIBILITY_ID => NULL,
2322: APPLICATION_ID => NULL);
2323: if (l_p_value is NULL) then
2324: l_p_value := FND_PROFILE.VALUE_SPECIFIC
2325: (NAME => G_MUTE_PROFILE,
2326: USER_ID => l_user_id,
2327: RESPONSIBILITY_ID=> NULL,
2328: APPLICATION_ID => NULL);

Line 2419: l_p_value := FND_PROFILE.VALUE_SPECIFIC

2415: if (funcmode = 'RUN') then
2416: open c1(l_user_name);
2417: fetch c1 into l_user_id;
2418: close c1;
2419: l_p_value := FND_PROFILE.VALUE_SPECIFIC
2420: (NAME => G_MUTE_PROFILE||'_'||l_ntf_type,
2421: USER_ID => l_user_id,
2422: RESPONSIBILITY_ID=> NULL,
2423: APPLICATION_ID => NULL);

Line 2425: l_p_value := FND_PROFILE.VALUE_SPECIFIC

2421: USER_ID => l_user_id,
2422: RESPONSIBILITY_ID=> NULL,
2423: APPLICATION_ID => NULL);
2424: if (l_p_value is NULL) then
2425: l_p_value := FND_PROFILE.VALUE_SPECIFIC
2426: (NAME => G_MUTE_PROFILE,
2427: USER_ID => l_user_id,
2428: RESPONSIBILITY_ID=> NULL,
2429: APPLICATION_ID => NULL);

Line 2527: l_p_value := FND_PROFILE.VALUE_SPECIFIC

2523: if (funcmode = 'RUN') then
2524: open c1(l_user_name);
2525: fetch c1 into l_user_id;
2526: close c1;
2527: l_p_value := FND_PROFILE.VALUE_SPECIFIC
2528: (NAME => G_MUTE_PROFILE||'_'||l_ntf_type,
2529: USER_ID => l_user_id,
2530: RESPONSIBILITY_ID=> NULL,
2531: APPLICATION_ID => NULL);

Line 2533: l_p_value := FND_PROFILE.VALUE_SPECIFIC

2529: USER_ID => l_user_id,
2530: RESPONSIBILITY_ID=> NULL,
2531: APPLICATION_ID => NULL);
2532: if (l_p_value is NULL) then
2533: l_p_value := FND_PROFILE.VALUE_SPECIFIC
2534: (NAME => G_MUTE_PROFILE,
2535: USER_ID => l_user_id,
2536: RESPONSIBILITY_ID=> NULL,
2537: APPLICATION_ID => NULL);

Line 2637: l_p_value := FND_PROFILE.VALUE_SPECIFIC

2633: if (funcmode = 'RUN') then
2634: open c1(l_user_name);
2635: fetch c1 into l_user_id;
2636: close c1;
2637: l_p_value := FND_PROFILE.VALUE_SPECIFIC
2638: (NAME => G_MUTE_PROFILE||'_'||l_ntf_type,
2639: USER_ID => l_user_id,
2640: RESPONSIBILITY_ID=> NULL,
2641: APPLICATION_ID => NULL);

Line 2643: l_p_value := FND_PROFILE.VALUE_SPECIFIC

2639: USER_ID => l_user_id,
2640: RESPONSIBILITY_ID=> NULL,
2641: APPLICATION_ID => NULL);
2642: if (l_p_value is NULL) then
2643: l_p_value := FND_PROFILE.VALUE_SPECIFIC
2644: (NAME => G_MUTE_PROFILE,
2645: USER_ID => l_user_id,
2646: RESPONSIBILITY_ID=> NULL,
2647: APPLICATION_ID => NULL);

Line 2747: l_p_value := FND_PROFILE.VALUE_SPECIFIC

2743: if (funcmode = 'RUN') then
2744: open c1(l_user_name);
2745: fetch c1 into l_user_id;
2746: close c1;
2747: l_p_value := FND_PROFILE.VALUE_SPECIFIC
2748: (NAME => G_MUTE_PROFILE||'_'||l_ntf_type,
2749: USER_ID => l_user_id,
2750: RESPONSIBILITY_ID=> NULL,
2751: APPLICATION_ID => NULL);

Line 2753: l_p_value := FND_PROFILE.VALUE_SPECIFIC

2749: USER_ID => l_user_id,
2750: RESPONSIBILITY_ID=> NULL,
2751: APPLICATION_ID => NULL);
2752: if (l_p_value is NULL) then
2753: l_p_value := FND_PROFILE.VALUE_SPECIFIC
2754: (NAME => G_MUTE_PROFILE,
2755: USER_ID => l_user_id,
2756: RESPONSIBILITY_ID=> NULL,
2757: APPLICATION_ID => NULL);

Line 2857: l_p_value := FND_PROFILE.VALUE_SPECIFIC

2853: if (funcmode = 'RUN') then
2854: open c1(l_user_name);
2855: fetch c1 into l_user_id;
2856: close c1;
2857: l_p_value := FND_PROFILE.VALUE_SPECIFIC
2858: (NAME => G_MUTE_PROFILE||'_'||l_ntf_type,
2859: USER_ID => l_user_id,
2860: RESPONSIBILITY_ID=> NULL,
2861: APPLICATION_ID => NULL);

Line 2863: l_p_value := FND_PROFILE.VALUE_SPECIFIC

2859: USER_ID => l_user_id,
2860: RESPONSIBILITY_ID=> NULL,
2861: APPLICATION_ID => NULL);
2862: if (l_p_value is NULL) then
2863: l_p_value := FND_PROFILE.VALUE_SPECIFIC
2864: (NAME => G_MUTE_PROFILE,
2865: USER_ID => l_user_id,
2866: RESPONSIBILITY_ID=> NULL,
2867: APPLICATION_ID => NULL);