984: p_all_others => 'N',
985: p_full_cache => 'N' );
986:
987: IF (retcode = 0) THEN
988: FND_MESSAGE.SET_NAME('QP','QP_JAVA_ENGINE_WARMUP_SUCCESS');
989: err_buff := FND_MESSAGE.GET;
990: END IF;
991:
992: EXCEPTION
985: p_full_cache => 'N' );
986:
987: IF (retcode = 0) THEN
988: FND_MESSAGE.SET_NAME('QP','QP_JAVA_ENGINE_WARMUP_SUCCESS');
989: err_buff := FND_MESSAGE.GET;
990: END IF;
991:
992: EXCEPTION
993: WHEN OTHERS THEN
990: END IF;
991:
992: EXCEPTION
993: WHEN OTHERS THEN
994: FND_MESSAGE.SET_NAME('QP','QP_JAVA_ENGINE_CACHE_ERROR');
995: err_buff := err_buff || FND_MESSAGE.GET;
996: FND_FILE.PUT_LINE( FND_FILE.LOG, l_routine);
997: retcode := 2;
998: END WARM_UP;
991:
992: EXCEPTION
993: WHEN OTHERS THEN
994: FND_MESSAGE.SET_NAME('QP','QP_JAVA_ENGINE_CACHE_ERROR');
995: err_buff := err_buff || FND_MESSAGE.GET;
996: FND_FILE.PUT_LINE( FND_FILE.LOG, l_routine);
997: retcode := 2;
998: END WARM_UP;
999:
1091: RAISE E_ROUTINE_ERRORS;
1092: END IF;
1093: END IF;
1094:
1095: FND_MESSAGE.SET_NAME('QP','QP_JAVA_ENGINE_SYNC_SUCCESS');
1096: err_buff := FND_MESSAGE.GET;
1097: retcode := 0;
1098:
1099: EXCEPTION
1092: END IF;
1093: END IF;
1094:
1095: FND_MESSAGE.SET_NAME('QP','QP_JAVA_ENGINE_SYNC_SUCCESS');
1096: err_buff := FND_MESSAGE.GET;
1097: retcode := 0;
1098:
1099: EXCEPTION
1100: WHEN JAVA_ENGINE_NOT_RUNNING_ERROR THEN
1097: retcode := 0;
1098:
1099: EXCEPTION
1100: WHEN JAVA_ENGINE_NOT_RUNNING_ERROR THEN
1101: FND_MESSAGE.SET_NAME('QP','QP_JAVA_ENGINE_NOT_RUNNING');
1102: err_buff := FND_MESSAGE.GET;
1103: retcode := 2;
1104: WHEN NO_PARAMS_ERROR THEN
1105: FND_MESSAGE.SET_NAME('QP','QP_JAVA_ENGINE_SYNC_PARAM_REQD');
1098:
1099: EXCEPTION
1100: WHEN JAVA_ENGINE_NOT_RUNNING_ERROR THEN
1101: FND_MESSAGE.SET_NAME('QP','QP_JAVA_ENGINE_NOT_RUNNING');
1102: err_buff := FND_MESSAGE.GET;
1103: retcode := 2;
1104: WHEN NO_PARAMS_ERROR THEN
1105: FND_MESSAGE.SET_NAME('QP','QP_JAVA_ENGINE_SYNC_PARAM_REQD');
1106: err_buff := FND_MESSAGE.GET;
1101: FND_MESSAGE.SET_NAME('QP','QP_JAVA_ENGINE_NOT_RUNNING');
1102: err_buff := FND_MESSAGE.GET;
1103: retcode := 2;
1104: WHEN NO_PARAMS_ERROR 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
1102: err_buff := FND_MESSAGE.GET;
1103: retcode := 2;
1104: WHEN NO_PARAMS_ERROR 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);
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');
1114: err_buff := '(' || l_return_status || ') ';
1115: err_buff := err_buff || FND_MESSAGE.GET;
1116: FND_FILE.PUT_LINE( FND_FILE.LOG, l_return_status_text );
1117: retcode := 2;
1111: QP_PREQ_GRP.engine_debug(l_routine||'SQLERRM:'||SQLERRM);
1112: END IF;
1113: FND_MESSAGE.SET_NAME('QP','QP_JAVA_ENGINE_CACHE_ERROR');
1114: err_buff := '(' || l_return_status || ') ';
1115: err_buff := err_buff || FND_MESSAGE.GET;
1116: FND_FILE.PUT_LINE( FND_FILE.LOG, l_return_status_text );
1117: retcode := 2;
1118: WHEN MAX_STATUS_REQUESTS_REACHED THEN
1119: err_buff := 'Request has exceeded '||(L_MAX_STATUS_REQUESTS*L_STATUS_REQUEST_INTERVAL)||' seconds.';
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');
1127: err_buff := '(' || l_return_status || ') ';
1128: err_buff := err_buff || FND_MESSAGE.GET;
1129: FND_FILE.PUT_LINE( FND_FILE.LOG, l_return_status_text );
1130: retcode := 2;
1124: QP_PREQ_GRP.engine_debug(l_routine||'SQLERRM:'||SQLERRM);
1125: END IF;
1126: FND_MESSAGE.SET_NAME('QP','QP_JAVA_ENGINE_CACHE_ERROR');
1127: err_buff := '(' || l_return_status || ') ';
1128: err_buff := err_buff || FND_MESSAGE.GET;
1129: FND_FILE.PUT_LINE( FND_FILE.LOG, l_return_status_text );
1130: retcode := 2;
1131: END SYNCHRONIZE;
1132:
1199:
1200: END IF;
1201:
1202: IF (retcode = 0) THEN
1203: FND_MESSAGE.SET_NAME('QP','QP_JAVA_ENGINE_MANAGE_SUCCESS');
1204: err_buff := FND_MESSAGE.GET;
1205: retcode := 0;
1206: END IF;
1207:
1200: END IF;
1201:
1202: IF (retcode = 0) THEN
1203: FND_MESSAGE.SET_NAME('QP','QP_JAVA_ENGINE_MANAGE_SUCCESS');
1204: err_buff := FND_MESSAGE.GET;
1205: retcode := 0;
1206: END IF;
1207:
1208: EXCEPTION
1206: END IF;
1207:
1208: EXCEPTION
1209: WHEN JAVA_ENGINE_NOT_RUNNING_ERROR THEN
1210: FND_MESSAGE.SET_NAME('QP','QP_JAVA_ENGINE_NOT_RUNNING');
1211: err_buff := FND_MESSAGE.GET;
1212: retcode := 2;
1213: WHEN E_ROUTINE_ERRORS THEN
1214: FND_MESSAGE.SET_NAME('QP','QP_JAVA_ENGINE_CACHE_ERROR');
1207:
1208: EXCEPTION
1209: WHEN JAVA_ENGINE_NOT_RUNNING_ERROR THEN
1210: FND_MESSAGE.SET_NAME('QP','QP_JAVA_ENGINE_NOT_RUNNING');
1211: err_buff := FND_MESSAGE.GET;
1212: retcode := 2;
1213: WHEN E_ROUTINE_ERRORS THEN
1214: FND_MESSAGE.SET_NAME('QP','QP_JAVA_ENGINE_CACHE_ERROR');
1215: err_buff := '(' || l_return_status || ') ';
1210: FND_MESSAGE.SET_NAME('QP','QP_JAVA_ENGINE_NOT_RUNNING');
1211: err_buff := FND_MESSAGE.GET;
1212: retcode := 2;
1213: WHEN E_ROUTINE_ERRORS THEN
1214: FND_MESSAGE.SET_NAME('QP','QP_JAVA_ENGINE_CACHE_ERROR');
1215: err_buff := '(' || l_return_status || ') ';
1216: err_buff := err_buff || FND_MESSAGE.GET;
1217: --err_buff := err_buff || ' ' || l_return_status_text;
1218: FND_FILE.PUT_LINE( FND_FILE.LOG, l_return_status_text );
1212: retcode := 2;
1213: WHEN E_ROUTINE_ERRORS THEN
1214: FND_MESSAGE.SET_NAME('QP','QP_JAVA_ENGINE_CACHE_ERROR');
1215: err_buff := '(' || l_return_status || ') ';
1216: err_buff := err_buff || FND_MESSAGE.GET;
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');
1226: err_buff := '(' || l_return_status || ') ';
1227: err_buff := err_buff || FND_MESSAGE.GET;
1228: --err_buff := err_buff || ' ' || l_return_status_text;
1229: FND_FILE.PUT_LINE( FND_FILE.LOG, 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');
1226: err_buff := '(' || l_return_status || ') ';
1227: err_buff := err_buff || FND_MESSAGE.GET;
1228: --err_buff := err_buff || ' ' || l_return_status_text;
1229: FND_FILE.PUT_LINE( FND_FILE.LOG, l_return_status_text );
1230: retcode := 2;
1231: END MANAGE;