DBA Data[Home] [Help]

APPS.QP_JAVA_ENGINE_UTIL_PUB dependencies on FND_PROFILE

Line 8: --G_INTERNAL_J VARCHAR2(32767) := nvl(FND_PROFILE.VALUE('QP_INTERNAL_11510_J'), 'QWERTY');

4: l_debug VARCHAR2(3);-- := QP_PREQ_GRP.G_DEBUG_ENGINE;
5: transferTimeout PLS_INTEGER := NULL;
6: defaultTimeout PLS_INTEGER := NULL;
7: eightI_env VARCHAR2(3);
8: --G_INTERNAL_J VARCHAR2(32767) := nvl(FND_PROFILE.VALUE('QP_INTERNAL_11510_J'), 'QWERTY');
9: --G_ENGINE_TYPE VARCHAR2(10) := nvl(FND_PROFILE.VALUE('QP_PRICING_ENGINE_TYPE'), 'PLSQL');
10: --G_ENGINE_URL VARCHAR2(1000) := FND_PROFILE.VALUE('QP_PRICING_ENGINE_URL');
11: --G_ICX_SESSION_ID VARCHAR2(1000) := FND_PROFILE.VALUE('ICX_SESSION_ID');
12: G_WALLET_PATH VARCHAR2(32767);

Line 9: --G_ENGINE_TYPE VARCHAR2(10) := nvl(FND_PROFILE.VALUE('QP_PRICING_ENGINE_TYPE'), 'PLSQL');

5: transferTimeout PLS_INTEGER := NULL;
6: defaultTimeout PLS_INTEGER := NULL;
7: eightI_env VARCHAR2(3);
8: --G_INTERNAL_J VARCHAR2(32767) := nvl(FND_PROFILE.VALUE('QP_INTERNAL_11510_J'), 'QWERTY');
9: --G_ENGINE_TYPE VARCHAR2(10) := nvl(FND_PROFILE.VALUE('QP_PRICING_ENGINE_TYPE'), 'PLSQL');
10: --G_ENGINE_URL VARCHAR2(1000) := FND_PROFILE.VALUE('QP_PRICING_ENGINE_URL');
11: --G_ICX_SESSION_ID VARCHAR2(1000) := FND_PROFILE.VALUE('ICX_SESSION_ID');
12: G_WALLET_PATH VARCHAR2(32767);
13: G_WALLET_PASSWORD VARCHAR2(100);

Line 10: --G_ENGINE_URL VARCHAR2(1000) := FND_PROFILE.VALUE('QP_PRICING_ENGINE_URL');

6: defaultTimeout PLS_INTEGER := NULL;
7: eightI_env VARCHAR2(3);
8: --G_INTERNAL_J VARCHAR2(32767) := nvl(FND_PROFILE.VALUE('QP_INTERNAL_11510_J'), 'QWERTY');
9: --G_ENGINE_TYPE VARCHAR2(10) := nvl(FND_PROFILE.VALUE('QP_PRICING_ENGINE_TYPE'), 'PLSQL');
10: --G_ENGINE_URL VARCHAR2(1000) := FND_PROFILE.VALUE('QP_PRICING_ENGINE_URL');
11: --G_ICX_SESSION_ID VARCHAR2(1000) := FND_PROFILE.VALUE('ICX_SESSION_ID');
12: G_WALLET_PATH VARCHAR2(32767);
13: G_WALLET_PASSWORD VARCHAR2(100);
14: G_PROXY_SERVER VARCHAR2(200);

Line 11: --G_ICX_SESSION_ID VARCHAR2(1000) := FND_PROFILE.VALUE('ICX_SESSION_ID');

7: eightI_env VARCHAR2(3);
8: --G_INTERNAL_J VARCHAR2(32767) := nvl(FND_PROFILE.VALUE('QP_INTERNAL_11510_J'), 'QWERTY');
9: --G_ENGINE_TYPE VARCHAR2(10) := nvl(FND_PROFILE.VALUE('QP_PRICING_ENGINE_TYPE'), 'PLSQL');
10: --G_ENGINE_URL VARCHAR2(1000) := FND_PROFILE.VALUE('QP_PRICING_ENGINE_URL');
11: --G_ICX_SESSION_ID VARCHAR2(1000) := FND_PROFILE.VALUE('ICX_SESSION_ID');
12: G_WALLET_PATH VARCHAR2(32767);
13: G_WALLET_PASSWORD VARCHAR2(100);
14: G_PROXY_SERVER VARCHAR2(200);
15:

Line 28: l_internal := nvl(FND_PROFILE.VALUE('QP_INTERNAL_11510_J'), 'QWERTY_1');

24: */
25: FUNCTION Java_Engine_Installed RETURN VARCHAR2 IS
26: l_internal varchar2(32767);
27: BEGIN
28: l_internal := nvl(FND_PROFILE.VALUE('QP_INTERNAL_11510_J'), 'QWERTY_1');
29:
30: IF(l_internal = 'QWERTY') THEN
31: --IF(G_INTERNAL_J = 'QWERTY') THEN
32: RETURN 'Y'; --- changed to 'Y' to resolve the issues for the delayed request and pattern upgrade

Line 51: l_internal := nvl(FND_PROFILE.VALUE('QP_INTERNAL_11510_J'), 'QWERTY');

47: FUNCTION Java_Engine_Running RETURN VARCHAR2 IS
48: l_engine_type varchar2(10);
49: l_internal varchar2(32767);
50: BEGIN
51: l_internal := nvl(FND_PROFILE.VALUE('QP_INTERNAL_11510_J'), 'QWERTY');
52: l_engine_type := nvl(FND_PROFILE.VALUE('QP_PRICING_ENGINE_TYPE'), 'PLSQL');
53:
54: IF(l_internal = 'QWERTY') THEN
55: --IF(G_INTERNAL_J = 'QWERTY') THEN

Line 52: l_engine_type := nvl(FND_PROFILE.VALUE('QP_PRICING_ENGINE_TYPE'), 'PLSQL');

48: l_engine_type varchar2(10);
49: l_internal varchar2(32767);
50: BEGIN
51: l_internal := nvl(FND_PROFILE.VALUE('QP_INTERNAL_11510_J'), 'QWERTY');
52: l_engine_type := nvl(FND_PROFILE.VALUE('QP_PRICING_ENGINE_TYPE'), 'PLSQL');
53:
54: IF(l_internal = 'QWERTY') THEN
55: --IF(G_INTERNAL_J = 'QWERTY') THEN
56: RETURN 'N';

Line 81: l_engine_url := FND_PROFILE.VALUE('QP_PRICING_ENGINE_URL');

77: j number;
78: l_debug varchar2(3);
79: BEGIN
80: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
81: l_engine_url := FND_PROFILE.VALUE('QP_PRICING_ENGINE_URL');
82:
83: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
84: IF l_debug = FND_API.G_TRUE THEN
85: QP_PREQ_GRP.engine_debug('QP_PRICING_ENGINE_URL value:'||l_engine_url);

Line 132: p_ctxt_str := p_ctxt_str||G_PARAM_NAME_ICX_SESSION_ID||'='||FND_PROFILE.VALUE('ICX_SESSION_ID');

128: p_ctxt_str := p_ctxt_str||G_HARD_CHAR;
129: p_ctxt_str := p_ctxt_str||G_PARAM_NAME_LOGIN_ID||'='||FND_GLOBAL.LOGIN_ID;
130: p_ctxt_str := p_ctxt_str||G_HARD_CHAR;
131: --p_ctxt_str := p_ctxt_str||G_PARAM_NAME_ICX_SESSION_ID||'='||ICX_SEC.G_SESSION_ID;
132: p_ctxt_str := p_ctxt_str||G_PARAM_NAME_ICX_SESSION_ID||'='||FND_PROFILE.VALUE('ICX_SESSION_ID');
133: --p_ctxt_str := p_ctxt_str||G_PARAM_NAME_ICX_SESSION_ID||'='||G_ICX_SESSION_ID;
134: p_ctxt_str := p_ctxt_str||G_HARD_CHAR;
135: p_ctxt_str := p_ctxt_str||G_PARAM_NAME_CALL_TYPE||'=DB';
136: p_ctxt_str := p_ctxt_str||G_HARD_CHAR;

Line 279: G_WALLET_PATH :=nvl(G_WALLET_PATH,'file:/'||FND_PROFILE.VALUE('FND_DB_WALLET_DIR'));

275: IF(is_SSL_Enabled(p_url_string) = 'Y') THEN
276: IF l_debug = FND_API.G_TRUE THEN
277: QP_PREQ_GRP.engine_debug('SSL is enabled.');
278: END IF;
279: G_WALLET_PATH :=nvl(G_WALLET_PATH,'file:/'||FND_PROFILE.VALUE('FND_DB_WALLET_DIR'));
280: G_WALLET_PASSWORD :=nvl(G_WALLET_PASSWORD,FND_PROFILE.VALUE('QP_WALLET_PASSWORD'));
281: G_PROXY_SERVER := nvl(G_PROXY_SERVER,FND_PROFILE.VALUE('QP_PROXY_SERVER'));
282: IF l_debug = FND_API.G_TRUE THEN
283: QP_PREQ_GRP.engine_debug('wallet_path:'||G_WALLET_PATH||' wallet_password:'||G_WALLET_PASSWORD);

Line 280: G_WALLET_PASSWORD :=nvl(G_WALLET_PASSWORD,FND_PROFILE.VALUE('QP_WALLET_PASSWORD'));

276: IF l_debug = FND_API.G_TRUE THEN
277: QP_PREQ_GRP.engine_debug('SSL is enabled.');
278: END IF;
279: G_WALLET_PATH :=nvl(G_WALLET_PATH,'file:/'||FND_PROFILE.VALUE('FND_DB_WALLET_DIR'));
280: G_WALLET_PASSWORD :=nvl(G_WALLET_PASSWORD,FND_PROFILE.VALUE('QP_WALLET_PASSWORD'));
281: G_PROXY_SERVER := nvl(G_PROXY_SERVER,FND_PROFILE.VALUE('QP_PROXY_SERVER'));
282: IF l_debug = FND_API.G_TRUE THEN
283: QP_PREQ_GRP.engine_debug('wallet_path:'||G_WALLET_PATH||' wallet_password:'||G_WALLET_PASSWORD);
284: QP_PREQ_GRP.engine_debug('proxy server:'||G_PROXY_SERVER);

Line 281: G_PROXY_SERVER := nvl(G_PROXY_SERVER,FND_PROFILE.VALUE('QP_PROXY_SERVER'));

277: QP_PREQ_GRP.engine_debug('SSL is enabled.');
278: END IF;
279: G_WALLET_PATH :=nvl(G_WALLET_PATH,'file:/'||FND_PROFILE.VALUE('FND_DB_WALLET_DIR'));
280: G_WALLET_PASSWORD :=nvl(G_WALLET_PASSWORD,FND_PROFILE.VALUE('QP_WALLET_PASSWORD'));
281: G_PROXY_SERVER := nvl(G_PROXY_SERVER,FND_PROFILE.VALUE('QP_PROXY_SERVER'));
282: IF l_debug = FND_API.G_TRUE THEN
283: QP_PREQ_GRP.engine_debug('wallet_path:'||G_WALLET_PATH||' wallet_password:'||G_WALLET_PASSWORD);
284: QP_PREQ_GRP.engine_debug('proxy server:'||G_PROXY_SERVER);
285: END IF;

Line 298: G_PROXY_SERVER := nvl(G_PROXY_SERVER, FND_PROFILE.VALUE('QP_PROXY_SERVER'));

294: ELSE
295: IF l_debug = FND_API.G_TRUE THEN
296: QP_PREQ_GRP.engine_debug('SSL is disabled.');
297: END IF;
298: G_PROXY_SERVER := nvl(G_PROXY_SERVER, FND_PROFILE.VALUE('QP_PROXY_SERVER'));
299: IF(G_PROXY_SERVER <> null) THEN
300: IF l_debug = FND_API.G_TRUE THEN
301: QP_PREQ_GRP.engine_debug('proxy server:'||G_PROXY_SERVER);
302: END IF;

Line 873: transferTimeout := FND_PROFILE.VALUE('QP_UTL_HTTP_TIMEOUT');

869: end Send_Java_Request;
870:
871: BEGIN
872: BEGIN
873: transferTimeout := FND_PROFILE.VALUE('QP_UTL_HTTP_TIMEOUT');
874: eightI_env := FND_API.G_FALSE;
875: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.GET_TRANSFER_TIMEOUT(:1); END;' USING IN OUT defaultTimeout;
876: IF l_debug = FND_API.G_TRUE THEN
877: QP_PREQ_GRP.engine_debug('transferTimeout='||transferTimeout||'sec defaultTimeout='||defaultTimeout||'sec.');