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.QP_JAVA_ENGINE dependencies on QP_PREQ_GRP

Line 37: --l_profile_names QP_PREQ_GRP.VARCHAR_TYPE;

33: (APP_ENABLED_FLAG <> 'N' or
34: RESP_ENABLED_FLAG <>'N' or
35: USER_ENABLED_FLAG <>'N');
36:
37: --l_profile_names QP_PREQ_GRP.VARCHAR_TYPE;
38:
39: BEGIN
40: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
41:

Line 40: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

36:
37: --l_profile_names QP_PREQ_GRP.VARCHAR_TYPE;
38:
39: BEGIN
40: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
41:
42: x_status_code := FND_API.G_RET_STS_SUCCESS;
43:
44: IF G_PROFILE_NAMES.count = 0 THEN

Line 46: QP_PREQ_GRP.engine_debug('G_PROFILE_NAMES cache is empty and needs warming it up.');

42: x_status_code := FND_API.G_RET_STS_SUCCESS;
43:
44: IF G_PROFILE_NAMES.count = 0 THEN
45: IF l_debug = FND_API.G_TRUE THEN
46: QP_PREQ_GRP.engine_debug('G_PROFILE_NAMES cache is empty and needs warming it up.');
47: END IF;
48: OPEN qp_profs_cur;
49: G_PROFILE_NAMES.delete;
50: FETCH qp_profs_cur BULK COLLECT INTO

Line 59: QP_PREQ_GRP.engine_debug('G_PROFILE_NAMES cache has been warmed up and reuse it.');

55: G_PROFILE_VALUES(i) := FND_PROFILE.value(G_PROFILE_NAMES(i));
56: END LOOP;
57: ELSE
58: IF l_debug = FND_API.G_TRUE THEN
59: QP_PREQ_GRP.engine_debug('G_PROFILE_NAMES cache has been warmed up and reuse it.');
60: END IF;
61: END IF;
62:
63: IF l_debug = FND_API.G_TRUE THEN

Line 67: --QP_PREQ_GRP.engine_debug('profile name:'||l_profile_names(i)||' value:'||FND_PROFILE.value(l_profile_names(i)));

63: IF l_debug = FND_API.G_TRUE THEN
64: --FOR i in l_profile_names.FIRST..l_profile_names.LAST
65: FOR i in G_PROFILE_NAMES.FIRST..G_PROFILE_NAMES.LAST
66: LOOP
67: --QP_PREQ_GRP.engine_debug('profile name:'||l_profile_names(i)||' value:'||FND_PROFILE.value(l_profile_names(i)));
68: QP_PREQ_GRP.engine_debug('profile name:'||G_PROFILE_NAMES(i)||' value:'||G_PROFILE_VALUES(i));
69: END LOOP;
70: END IF;
71:

Line 68: QP_PREQ_GRP.engine_debug('profile name:'||G_PROFILE_NAMES(i)||' value:'||G_PROFILE_VALUES(i));

64: --FOR i in l_profile_names.FIRST..l_profile_names.LAST
65: FOR i in G_PROFILE_NAMES.FIRST..G_PROFILE_NAMES.LAST
66: LOOP
67: --QP_PREQ_GRP.engine_debug('profile name:'||l_profile_names(i)||' value:'||FND_PROFILE.value(l_profile_names(i)));
68: QP_PREQ_GRP.engine_debug('profile name:'||G_PROFILE_NAMES(i)||' value:'||G_PROFILE_VALUES(i));
69: END LOOP;
70: END IF;
71:
72: --FORALL i in l_profile_names.FIRST..l_profile_names.LAST

Line 89: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN

85: EXCEPTION
86: WHEN OTHERS THEN
87: x_status_code := FND_API.G_RET_STS_ERROR;
88: x_status_text :=l_routine||' '||SQLERRM;
89: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
90: QP_PREQ_GRP.engine_debug(l_routine||' '||SQLERRM);
91: QP_PREQ_GRP.engine_debug(SQLERRM);
92: END IF;
93: END;

Line 90: QP_PREQ_GRP.engine_debug(l_routine||' '||SQLERRM);

86: WHEN OTHERS THEN
87: x_status_code := FND_API.G_RET_STS_ERROR;
88: x_status_text :=l_routine||' '||SQLERRM;
89: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
90: QP_PREQ_GRP.engine_debug(l_routine||' '||SQLERRM);
91: QP_PREQ_GRP.engine_debug(SQLERRM);
92: END IF;
93: END;
94:

Line 91: QP_PREQ_GRP.engine_debug(SQLERRM);

87: x_status_code := FND_API.G_RET_STS_ERROR;
88: x_status_text :=l_routine||' '||SQLERRM;
89: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
90: QP_PREQ_GRP.engine_debug(l_routine||' '||SQLERRM);
91: QP_PREQ_GRP.engine_debug(SQLERRM);
92: END IF;
93: END;
94:
95: /*+----------------------------------------------------------------------

Line 110: QP_PREQ_GRP.engine_debug('G_PROFILE_STR is empty and needs initialization.');

106: prof_pattern varchar2(32767);
107: BEGIN
108: IF(G_PROFILE_STR IS NULL) THEN
109: IF l_debug = FND_API.G_TRUE THEN
110: QP_PREQ_GRP.engine_debug('G_PROFILE_STR is empty and needs initialization.');
111: END IF;
112:
113: --prof_str := G_PARAM_NAME_PROFL_PATN||'=';
114: G_PROFILE_STR := G_PARAM_NAME_PROFL_PATN||'=';

Line 151: FUNCTION Get_Ctrl_String(p_control_rec IN QP_PREQ_GRP.CONTROL_RECORD_TYPE)

147: | This function contructs parameter string for Control Record based on
148: | p_control_rec information, which will be used for UTL_HTTP call
149: +----------------------------------------------------------------------
150: */
151: FUNCTION Get_Ctrl_String(p_control_rec IN QP_PREQ_GRP.CONTROL_RECORD_TYPE)
152: RETURN varchar2 IS
153: p_ctrl_str varchar2(32767);
154: p_control_pattern varchar2(32767);
155:

Line 178: --debug control from QP_PREQ_GRP.G_DEBUG_ENGINE

174:
175: p_control_pattern := p_control_pattern||p_control_rec.MANUAL_DISCOUNT_FLAG||G_PATN_SEPERATOR;
176:
177: --p_control_pattern := p_control_pattern||p_control_rec.DEBUG_FLAG||G_PATN_SEPERATOR;
178: --debug control from QP_PREQ_GRP.G_DEBUG_ENGINE
179: p_control_pattern := p_control_pattern||QP_PREQ_GRP.G_DEBUG_ENGINE||G_PATN_SEPERATOR;
180:
181: p_control_pattern := p_control_pattern||p_control_rec.SOURCE_ORDER_AMOUNT_FLAG||G_PATN_SEPERATOR;
182:

Line 179: p_control_pattern := p_control_pattern||QP_PREQ_GRP.G_DEBUG_ENGINE||G_PATN_SEPERATOR;

175: p_control_pattern := p_control_pattern||p_control_rec.MANUAL_DISCOUNT_FLAG||G_PATN_SEPERATOR;
176:
177: --p_control_pattern := p_control_pattern||p_control_rec.DEBUG_FLAG||G_PATN_SEPERATOR;
178: --debug control from QP_PREQ_GRP.G_DEBUG_ENGINE
179: p_control_pattern := p_control_pattern||QP_PREQ_GRP.G_DEBUG_ENGINE||G_PATN_SEPERATOR;
180:
181: p_control_pattern := p_control_pattern||p_control_rec.SOURCE_ORDER_AMOUNT_FLAG||G_PATN_SEPERATOR;
182:
183: p_control_pattern := p_control_pattern||p_control_rec.MANUAL_ADJUSTMENTS_CALL_FLAG||G_PATN_SEPERATOR;

Line 208: p_control_rec IN QP_PREQ_GRP.CONTROL_RECORD_TYPE,

204: RETURN p_ctrl_str;
205: END Get_Ctrl_String;
206:
207: PROCEDURE REQUEST_PRICE(request_id IN NUMBER,
208: p_control_rec IN QP_PREQ_GRP.CONTROL_RECORD_TYPE,
209: x_return_status OUT NOCOPY VARCHAR2,
210: x_return_status_text OUT NOCOPY VARCHAR2)
211: IS
212: l_routine VARCHAR2(240):='Routine:QP_JAVA_ENGINE.REQUEST_PRICE';

Line 226: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;

222: l_session_id number := FND_GLOBAL.SESSION_ID;
223:
224: E_ROUTINE_ERRORS EXCEPTION;
225: BEGIN
226: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
227:
228: IF l_debug = FND_API.G_TRUE THEN
229: l_pricing_start_time := dbms_utility.get_time;
230: QP_PREQ_GRP.engine_debug('Inside ' || l_routine);

Line 230: QP_PREQ_GRP.engine_debug('Inside ' || l_routine);

226: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
227:
228: IF l_debug = FND_API.G_TRUE THEN
229: l_pricing_start_time := dbms_utility.get_time;
230: QP_PREQ_GRP.engine_debug('Inside ' || l_routine);
231: QP_PREQ_GRP.engine_debug('calc_flag:' ||p_control_rec.CALCULATE_FLAG);
232: END IF;
233:
234: /*Construct request parameter string CtrlPatn*/

Line 231: QP_PREQ_GRP.engine_debug('calc_flag:' ||p_control_rec.CALCULATE_FLAG);

227:
228: IF l_debug = FND_API.G_TRUE THEN
229: l_pricing_start_time := dbms_utility.get_time;
230: QP_PREQ_GRP.engine_debug('Inside ' || l_routine);
231: QP_PREQ_GRP.engine_debug('calc_flag:' ||p_control_rec.CALCULATE_FLAG);
232: END IF;
233:
234: /*Construct request parameter string CtrlPatn*/
235: p_ctrl_str := Get_Ctrl_String(p_control_rec);

Line 237: QP_PREQ_GRP.engine_debug('Ctrl_Str:'||p_ctrl_str);

233:
234: /*Construct request parameter string CtrlPatn*/
235: p_ctrl_str := Get_Ctrl_String(p_control_rec);
236: IF l_debug = FND_API.G_TRUE THEN
237: QP_PREQ_GRP.engine_debug('Ctrl_Str:'||p_ctrl_str);
238: END IF;
239:
240: /*Store QP Profiles*/
241: Insert_Profs2_AT(request_id, l_return_status,l_status_text);

Line 252: url_param_string := url_param_string||'n1='||QP_PREQ_GRP.G_INT_LINES_NO||G_HARD_CHAR||'n2='||QP_PREQ_GRP.G_INT_LDETS_NO||G_HARD_CHAR||'n3='||QP_PREQ_GRP.G_INT_ATTRS_NO||G_HARD_CHAR||'n4='||QP_PREQ_GRP.G_INT_RELS_NO;

248:
249: /*Send Request To Java Engine*/
250: url_param_string := G_PARAM_NAME_REQUEST_ID||'='||request_id||G_HARD_CHAR||p_ctrl_str||G_HARD_CHAR||QP_JAVA_ENGINE_UTIL_PUB.G_PARAM_NAME_ACTION||'='||l_action_type||G_HARD_CHAR;
251:
252: url_param_string := url_param_string||'n1='||QP_PREQ_GRP.G_INT_LINES_NO||G_HARD_CHAR||'n2='||QP_PREQ_GRP.G_INT_LDETS_NO||G_HARD_CHAR||'n3='||QP_PREQ_GRP.G_INT_ATTRS_NO||G_HARD_CHAR||'n4='||QP_PREQ_GRP.G_INT_RELS_NO;
253:
254: IF(QP_PREQ_GRP.G_INT_LINES_NO < G_JPE_LINES_THRESHOLD) THEN
255: QP_JAVA_ENGINE_UTIL_PUB.Send_Java_Engine_Request(url_param_string, l_return_status,l_status_text, 60, FND_API.G_FALSE, FND_API.G_TRUE);
256: ELSE

Line 254: IF(QP_PREQ_GRP.G_INT_LINES_NO < G_JPE_LINES_THRESHOLD) THEN

250: url_param_string := G_PARAM_NAME_REQUEST_ID||'='||request_id||G_HARD_CHAR||p_ctrl_str||G_HARD_CHAR||QP_JAVA_ENGINE_UTIL_PUB.G_PARAM_NAME_ACTION||'='||l_action_type||G_HARD_CHAR;
251:
252: url_param_string := url_param_string||'n1='||QP_PREQ_GRP.G_INT_LINES_NO||G_HARD_CHAR||'n2='||QP_PREQ_GRP.G_INT_LDETS_NO||G_HARD_CHAR||'n3='||QP_PREQ_GRP.G_INT_ATTRS_NO||G_HARD_CHAR||'n4='||QP_PREQ_GRP.G_INT_RELS_NO;
253:
254: IF(QP_PREQ_GRP.G_INT_LINES_NO < G_JPE_LINES_THRESHOLD) THEN
255: QP_JAVA_ENGINE_UTIL_PUB.Send_Java_Engine_Request(url_param_string, l_return_status,l_status_text, 60, FND_API.G_FALSE, FND_API.G_TRUE);
256: ELSE
257: QP_JAVA_ENGINE_UTIL_PUB.Send_Java_Engine_Request(url_param_string, l_return_status,l_status_text, -1, FND_API.G_TRUE, FND_API.G_TRUE);
258: END IF;

Line 267: QP_PREQ_GRP.engine_debug('Total time in '||l_routine||': '||(l_pricing_end_time - l_pricing_start_time)/100);

263: x_return_status_text := substr(l_status_text, 1, 240);
264:
265: IF l_debug = FND_API.G_TRUE THEN
266: l_pricing_end_time := dbms_utility.get_time;
267: QP_PREQ_GRP.engine_debug('Total time in '||l_routine||': '||(l_pricing_end_time - l_pricing_start_time)/100);
268: END IF;
269:
270: IF l_debug = FND_API.G_TRUE THEN
271: QP_PREQ_GRP.engine_debug('Request Id:'||request_id||' has finished with status_code='||x_return_status||' status_text='||x_return_status_text);

Line 271: QP_PREQ_GRP.engine_debug('Request Id:'||request_id||' has finished with status_code='||x_return_status||' status_text='||x_return_status_text);

267: QP_PREQ_GRP.engine_debug('Total time in '||l_routine||': '||(l_pricing_end_time - l_pricing_start_time)/100);
268: END IF;
269:
270: IF l_debug = FND_API.G_TRUE THEN
271: QP_PREQ_GRP.engine_debug('Request Id:'||request_id||' has finished with status_code='||x_return_status||' status_text='||x_return_status_text);
272: END IF;
273: EXCEPTION
274: WHEN E_ROUTINE_ERRORS THEN
275: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN

Line 275: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN

271: QP_PREQ_GRP.engine_debug('Request Id:'||request_id||' has finished with status_code='||x_return_status||' status_text='||x_return_status_text);
272: END IF;
273: EXCEPTION
274: WHEN E_ROUTINE_ERRORS THEN
275: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
276: QP_PREQ_GRP.engine_debug(l_routine||': '||l_status_text);
277: END IF;
278: x_return_status := FND_API.G_RET_STS_ERROR;
279: --x_return_status_text := l_routine||': '||l_status_text;

Line 276: QP_PREQ_GRP.engine_debug(l_routine||': '||l_status_text);

272: END IF;
273: EXCEPTION
274: WHEN E_ROUTINE_ERRORS THEN
275: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
276: QP_PREQ_GRP.engine_debug(l_routine||': '||l_status_text);
277: END IF;
278: x_return_status := FND_API.G_RET_STS_ERROR;
279: --x_return_status_text := l_routine||': '||l_status_text;
280: x_return_status_text := l_status_text;

Line 287: QP_PREQ_GRP.engine_debug('Request Id:'||request_id||' failed unexpectedly!' );

283: FND_MESSAGE.SET_NAME('QP','QP_JPE_UNEXPECTED_ERROR');
284: x_return_status_text := FND_MESSAGE.get;
285: --x_return_status_text := 'Java Engine call failed unexpectedly. Please contact system administrator!';
286: IF l_debug = FND_API.G_TRUE THEN
287: QP_PREQ_GRP.engine_debug('Request Id:'||request_id||' failed unexpectedly!' );
288: END IF;
289: END;
290: END QP_JAVA_ENGINE;