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_CACHE_PVT dependencies on FND_API

Line 645: IF l_debug = FND_API.G_TRUE THEN

641: l_avg_cache_key_size(ck_type) := round(l_total_cache_key_size(ck_type)/l_calc_cnt);
642: l_total_cache_key_size(ck_type) := l_avg_cache_key_size(ck_type) * l_cache_key_cnt;
643:
644: /* julin: debug
645: IF l_debug = FND_API.G_TRUE THEN
646: dbms_output.put_line('ck_type: ' || ck_type);
647: dbms_output.put_line('l_cache_key_stat_cnt: ' || l_cache_key_stat_cnt);
648: dbms_output.put_line('l_cache_key_increment: ' || l_cache_key_increment);
649: dbms_output.put_line('l_max_cache_key_size(ck_type): ' || l_max_cache_key_size(ck_type));

Line 913: IF l_debug = FND_API.G_TRUE THEN

909: l_cat_no_prod_cat_tbl number_tbl_type;
910:
911: BEGIN
912:
913: IF l_debug = FND_API.G_TRUE THEN
914: dbms_output.put_line('qp_java_engine_cache_pub.update_cat_no_prod_pricing');
915: END IF;
916:
917: DELETE FROM qp_cache_cat_no_prod_pricing;

Line 925: IF l_debug = FND_API.G_TRUE THEN

921: l_cat_no_prod_type_tbl,
922: l_cat_no_prod_cat_tbl;
923: CLOSE cat_no_prod_mod_csr;
924:
925: IF l_debug = FND_API.G_TRUE THEN
926: dbms_output.put_line('l_cat_no_prod_type_tbl: ' || l_cat_no_prod_type_tbl.count);
927: END IF;
928:
929: forall i in 1..l_cat_no_prod_type_tbl.last

Line 944: IF l_debug = FND_API.G_TRUE THEN

940: l_cat_no_prod_type_tbl,
941: l_cat_no_prod_cat_tbl;
942: CLOSE cat_no_prod_price_csr;
943:
944: IF l_debug = FND_API.G_TRUE THEN
945: dbms_output.put_line('l_cat_no_prod_type_tbl: ' || l_cat_no_prod_type_tbl.count);
946: END IF;
947:
948: forall i in 1..l_cat_no_prod_type_tbl.last

Line 1030: IF l_debug = FND_API.G_TRUE THEN

1026: BEGIN
1027:
1028: QP_PREQ_GRP.Set_QP_Debug;
1029: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
1030: IF l_debug = FND_API.G_TRUE THEN
1031: l_output_file := OE_DEBUG_PUB.SET_DEBUG_MODE('FILE');
1032: FND_FILE.PUT_LINE( FND_FILE.LOG, 'The output file is : ' || l_output_file );
1033: END IF;
1034:

Line 1068: FND_API.G_TRUE);

1064: qp_java_engine_util_pub.send_java_engine_request(l_url_param_string,
1065: l_return_status,
1066: l_return_status_text,
1067: L_TRANSFER_TIMEOUT,
1068: FND_API.G_TRUE);
1069:
1070: l_status_request_cnt := 0;
1071: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1072: IF (l_return_status_text = 'UTL_TCP.END_OF_INPUT') THEN

Line 1071: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN

1067: L_TRANSFER_TIMEOUT,
1068: FND_API.G_TRUE);
1069:
1070: l_status_request_cnt := 0;
1071: IF (l_return_status = FND_API.G_RET_STS_ERROR) THEN
1072: IF (l_return_status_text = 'UTL_TCP.END_OF_INPUT') THEN
1073: LOOP
1074: DBMS_LOCK.SLEEP(L_STATUS_REQUEST_INTERVAL);
1075: l_url_param_string := 'Action=synchronize'||

Line 1081: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1077: qp_java_engine_util_pub.G_HARD_CHAR||'statusRequest=Y';
1078: qp_java_engine_util_pub.send_java_engine_request(l_url_param_string,
1079: l_return_status,
1080: l_return_status_text);
1081: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1082: RAISE E_ROUTINE_ERRORS;
1083: END IF;
1084: EXIT WHEN l_return_status_text = 'COMPLETED';
1085: IF l_status_request_cnt > L_MAX_STATUS_REQUESTS THEN

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

1105: FND_MESSAGE.SET_NAME('QP','QP_JAVA_ENGINE_SYNC_PARAM_REQD');
1106: err_buff := FND_MESSAGE.GET;
1107: retcode := 2;
1108: WHEN E_ROUTINE_ERRORS THEN
1109: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
1110: QP_PREQ_GRP.engine_debug(l_routine||'l_return_status_text:'||l_return_status_text);
1111: QP_PREQ_GRP.engine_debug(l_routine||'SQLERRM:'||SQLERRM);
1112: END IF;
1113: FND_MESSAGE.SET_NAME('QP','QP_JAVA_ENGINE_CACHE_ERROR');

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

1118: WHEN MAX_STATUS_REQUESTS_REACHED THEN
1119: err_buff := 'Request has exceeded '||(L_MAX_STATUS_REQUESTS*L_STATUS_REQUEST_INTERVAL)||' seconds.';
1120: retcode := 1;
1121: WHEN OTHERS THEN
1122: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
1123: QP_PREQ_GRP.engine_debug(l_routine||'l_return_status_text:'||l_return_status_text);
1124: QP_PREQ_GRP.engine_debug(l_routine||'SQLERRM:'||SQLERRM);
1125: END IF;
1126: FND_MESSAGE.SET_NAME('QP','QP_JAVA_ENGINE_CACHE_ERROR');

Line 1169: IF l_debug = FND_API.G_TRUE THEN

1165: p_full_cache => 'N' );
1166: ELSE
1167: QP_PREQ_GRP.Set_QP_Debug;
1168: l_debug := QP_PREQ_GRP.G_DEBUG_ENGINE;
1169: IF l_debug = FND_API.G_TRUE THEN
1170: l_output_file := OE_DEBUG_PUB.SET_DEBUG_MODE('FILE');
1171: FND_FILE.PUT_LINE( FND_FILE.LOG, 'The output file is : ' || l_output_file );
1172: END IF;
1173:

Line 1190: IF l_return_status = FND_API.G_RET_STS_ERROR THEN

1186: l_return_status_text,
1187: l_return_details,
1188: TRUE);
1189:
1190: IF l_return_status = FND_API.G_RET_STS_ERROR THEN
1191: RAISE E_ROUTINE_ERRORS;
1192: END IF;
1193:
1194: FND_FILE.NEW_LINE( FND_FILE.LOG );

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

1217: --err_buff := err_buff || ' ' || l_return_status_text;
1218: FND_FILE.PUT_LINE( FND_FILE.LOG, l_return_status_text );
1219: retcode := 2;
1220: WHEN OTHERS THEN
1221: IF QP_PREQ_GRP.G_DEBUG_ENGINE = FND_API.G_TRUE THEN
1222: QP_PREQ_GRP.engine_debug(l_routine||' '||l_return_status_text);
1223: END IF;
1224: FND_FILE.PUT_LINE( FND_FILE.LOG, SQLERRM);
1225: FND_MESSAGE.SET_NAME('QP','QP_JAVA_ENGINE_CACHE_ERROR');