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 FND_API

Line 42: x_status_code := FND_API.G_RET_STS_SUCCESS;

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
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.');

Line 45: IF l_debug = FND_API.G_TRUE THEN

41:
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;

Line 58: IF l_debug = FND_API.G_TRUE THEN

54: LOOP
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:

Line 63: 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
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)));

Line 87: x_status_code := FND_API.G_RET_STS_ERROR;

83: );
84: COMMIT;
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);

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 109: IF l_debug = FND_API.G_TRUE THEN

105: --prof_str varchar2(32767);
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||'=';

Line 228: IF l_debug = FND_API.G_TRUE THEN

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);
231: QP_PREQ_GRP.engine_debug('calc_flag:' ||p_control_rec.CALCULATE_FLAG);
232: END IF;

Line 236: IF l_debug = FND_API.G_TRUE THEN

232: END IF;
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*/

Line 242: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

238: END IF;
239:
240: /*Store QP Profiles*/
241: Insert_Profs2_AT(request_id, l_return_status,l_status_text);
242: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
243: RAISE E_ROUTINE_ERRORS;
244: END IF;
245:
246: --/*Construct request parameter string ContextConfig*/

Line 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);

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;
259: --IF l_return_status = FND_API.G_RET_STS_ERROR THEN

Line 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);

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;
259: --IF l_return_status = FND_API.G_RET_STS_ERROR THEN
260: --RAISE E_ROUTINE_ERRORS;
261: --END IF;

Line 259: --IF l_return_status = FND_API.G_RET_STS_ERROR 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;
259: --IF l_return_status = FND_API.G_RET_STS_ERROR THEN
260: --RAISE E_ROUTINE_ERRORS;
261: --END IF;
262: x_return_status := l_return_status;
263: x_return_status_text := substr(l_status_text, 1, 240);

Line 265: IF l_debug = FND_API.G_TRUE THEN

261: --END IF;
262: x_return_status := l_return_status;
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:

Line 270: 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);
272: END IF;
273: EXCEPTION
274: WHEN E_ROUTINE_ERRORS 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 278: x_return_status := FND_API.G_RET_STS_ERROR;

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;
281: WHEN OTHERS THEN
282: x_return_status := FND_API.G_RET_STS_ERROR;

Line 282: x_return_status := FND_API.G_RET_STS_ERROR;

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;
281: WHEN OTHERS THEN
282: x_return_status := FND_API.G_RET_STS_ERROR;
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

Line 286: IF l_debug = FND_API.G_TRUE THEN

282: x_return_status := FND_API.G_RET_STS_ERROR;
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;