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:
1035: IF (QP_JAVA_ENGINE_UTIL_PUB.JAVA_ENGINE_RUNNING <> 'Y') THEN
1036: RAISE JAVA_ENGINE_NOT_RUNNING_ERROR;
1037: END IF;
1038:
1039: IF (p_list_header_id IS NULL AND
1054: end if;
1055: --update_cat_no_prod_pricing;
1056:
1057: l_url_param_string := 'Action=synchronize'||
1058: qp_java_engine_util_pub.G_HARD_CHAR||'concRequestId='||nvl(FND_GLOBAL.CONC_REQUEST_ID, -1)||
1059: qp_java_engine_util_pub.G_HARD_CHAR||'listHeaderId='||nvl(p_list_header_id, -1)||
1060: qp_java_engine_util_pub.G_HARD_CHAR||'priceFormulaId='||nvl(p_price_formula_id, -1)||
1061: qp_java_engine_util_pub.G_HARD_CHAR||'currencyHeaderId='||nvl(p_currency_header_id, -1)||
1062: qp_java_engine_util_pub.G_HARD_CHAR||'allOthers='||nvl(p_all_others, 'N')||
1055: --update_cat_no_prod_pricing;
1056:
1057: l_url_param_string := 'Action=synchronize'||
1058: qp_java_engine_util_pub.G_HARD_CHAR||'concRequestId='||nvl(FND_GLOBAL.CONC_REQUEST_ID, -1)||
1059: qp_java_engine_util_pub.G_HARD_CHAR||'listHeaderId='||nvl(p_list_header_id, -1)||
1060: qp_java_engine_util_pub.G_HARD_CHAR||'priceFormulaId='||nvl(p_price_formula_id, -1)||
1061: qp_java_engine_util_pub.G_HARD_CHAR||'currencyHeaderId='||nvl(p_currency_header_id, -1)||
1062: qp_java_engine_util_pub.G_HARD_CHAR||'allOthers='||nvl(p_all_others, 'N')||
1063: qp_java_engine_util_pub.G_HARD_CHAR||'fullCache='||nvl(p_full_cache, 'N');
1056:
1057: l_url_param_string := 'Action=synchronize'||
1058: qp_java_engine_util_pub.G_HARD_CHAR||'concRequestId='||nvl(FND_GLOBAL.CONC_REQUEST_ID, -1)||
1059: qp_java_engine_util_pub.G_HARD_CHAR||'listHeaderId='||nvl(p_list_header_id, -1)||
1060: qp_java_engine_util_pub.G_HARD_CHAR||'priceFormulaId='||nvl(p_price_formula_id, -1)||
1061: qp_java_engine_util_pub.G_HARD_CHAR||'currencyHeaderId='||nvl(p_currency_header_id, -1)||
1062: qp_java_engine_util_pub.G_HARD_CHAR||'allOthers='||nvl(p_all_others, 'N')||
1063: qp_java_engine_util_pub.G_HARD_CHAR||'fullCache='||nvl(p_full_cache, 'N');
1064: qp_java_engine_util_pub.send_java_engine_request(l_url_param_string,
1057: l_url_param_string := 'Action=synchronize'||
1058: qp_java_engine_util_pub.G_HARD_CHAR||'concRequestId='||nvl(FND_GLOBAL.CONC_REQUEST_ID, -1)||
1059: qp_java_engine_util_pub.G_HARD_CHAR||'listHeaderId='||nvl(p_list_header_id, -1)||
1060: qp_java_engine_util_pub.G_HARD_CHAR||'priceFormulaId='||nvl(p_price_formula_id, -1)||
1061: qp_java_engine_util_pub.G_HARD_CHAR||'currencyHeaderId='||nvl(p_currency_header_id, -1)||
1062: qp_java_engine_util_pub.G_HARD_CHAR||'allOthers='||nvl(p_all_others, 'N')||
1063: qp_java_engine_util_pub.G_HARD_CHAR||'fullCache='||nvl(p_full_cache, 'N');
1064: qp_java_engine_util_pub.send_java_engine_request(l_url_param_string,
1065: l_return_status,
1058: qp_java_engine_util_pub.G_HARD_CHAR||'concRequestId='||nvl(FND_GLOBAL.CONC_REQUEST_ID, -1)||
1059: qp_java_engine_util_pub.G_HARD_CHAR||'listHeaderId='||nvl(p_list_header_id, -1)||
1060: qp_java_engine_util_pub.G_HARD_CHAR||'priceFormulaId='||nvl(p_price_formula_id, -1)||
1061: qp_java_engine_util_pub.G_HARD_CHAR||'currencyHeaderId='||nvl(p_currency_header_id, -1)||
1062: qp_java_engine_util_pub.G_HARD_CHAR||'allOthers='||nvl(p_all_others, 'N')||
1063: qp_java_engine_util_pub.G_HARD_CHAR||'fullCache='||nvl(p_full_cache, 'N');
1064: qp_java_engine_util_pub.send_java_engine_request(l_url_param_string,
1065: l_return_status,
1066: l_return_status_text,
1059: qp_java_engine_util_pub.G_HARD_CHAR||'listHeaderId='||nvl(p_list_header_id, -1)||
1060: qp_java_engine_util_pub.G_HARD_CHAR||'priceFormulaId='||nvl(p_price_formula_id, -1)||
1061: qp_java_engine_util_pub.G_HARD_CHAR||'currencyHeaderId='||nvl(p_currency_header_id, -1)||
1062: qp_java_engine_util_pub.G_HARD_CHAR||'allOthers='||nvl(p_all_others, 'N')||
1063: qp_java_engine_util_pub.G_HARD_CHAR||'fullCache='||nvl(p_full_cache, 'N');
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,
1060: qp_java_engine_util_pub.G_HARD_CHAR||'priceFormulaId='||nvl(p_price_formula_id, -1)||
1061: qp_java_engine_util_pub.G_HARD_CHAR||'currencyHeaderId='||nvl(p_currency_header_id, -1)||
1062: qp_java_engine_util_pub.G_HARD_CHAR||'allOthers='||nvl(p_all_others, 'N')||
1063: qp_java_engine_util_pub.G_HARD_CHAR||'fullCache='||nvl(p_full_cache, 'N');
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);
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'||
1076: qp_java_engine_util_pub.G_HARD_CHAR||'concRequestId='||nvl(FND_GLOBAL.CONC_REQUEST_ID, -1)||
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);
1073: LOOP
1074: DBMS_LOCK.SLEEP(L_STATUS_REQUEST_INTERVAL);
1075: l_url_param_string := 'Action=synchronize'||
1076: qp_java_engine_util_pub.G_HARD_CHAR||'concRequestId='||nvl(FND_GLOBAL.CONC_REQUEST_ID, -1)||
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
1074: DBMS_LOCK.SLEEP(L_STATUS_REQUEST_INTERVAL);
1075: l_url_param_string := 'Action=synchronize'||
1076: qp_java_engine_util_pub.G_HARD_CHAR||'concRequestId='||nvl(FND_GLOBAL.CONC_REQUEST_ID, -1)||
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;
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:
1174: IF (QP_JAVA_ENGINE_UTIL_PUB.JAVA_ENGINE_RUNNING <> 'Y') THEN
1175: RAISE JAVA_ENGINE_NOT_RUNNING_ERROR;
1176: END IF;
1177:
1178: l_url_param_string := 'Action=manage'||
1175: RAISE JAVA_ENGINE_NOT_RUNNING_ERROR;
1176: END IF;
1177:
1178: l_url_param_string := 'Action=manage'||
1179: qp_java_engine_util_pub.G_HARD_CHAR||'manageAction='||nvl(p_manage_action, '-1')||
1180: qp_java_engine_util_pub.G_HARD_CHAR||'dumpType='||nvl(p_dump_type, '-1')||
1181: qp_java_engine_util_pub.G_HARD_CHAR||'dumpInput1='||nvl(p_dump_input1, '-1')||
1182: qp_java_engine_util_pub.G_HARD_CHAR||'dumpInput2='||nvl(p_dump_input2, '-1')||
1183: qp_java_engine_util_pub.G_HARD_CHAR||'dumpInput3='||nvl(p_dump_input3, '-1');
1176: END IF;
1177:
1178: l_url_param_string := 'Action=manage'||
1179: qp_java_engine_util_pub.G_HARD_CHAR||'manageAction='||nvl(p_manage_action, '-1')||
1180: qp_java_engine_util_pub.G_HARD_CHAR||'dumpType='||nvl(p_dump_type, '-1')||
1181: qp_java_engine_util_pub.G_HARD_CHAR||'dumpInput1='||nvl(p_dump_input1, '-1')||
1182: qp_java_engine_util_pub.G_HARD_CHAR||'dumpInput2='||nvl(p_dump_input2, '-1')||
1183: qp_java_engine_util_pub.G_HARD_CHAR||'dumpInput3='||nvl(p_dump_input3, '-1');
1184: qp_java_engine_util_pub.send_java_engine_request(l_url_param_string,
1177:
1178: l_url_param_string := 'Action=manage'||
1179: qp_java_engine_util_pub.G_HARD_CHAR||'manageAction='||nvl(p_manage_action, '-1')||
1180: qp_java_engine_util_pub.G_HARD_CHAR||'dumpType='||nvl(p_dump_type, '-1')||
1181: qp_java_engine_util_pub.G_HARD_CHAR||'dumpInput1='||nvl(p_dump_input1, '-1')||
1182: qp_java_engine_util_pub.G_HARD_CHAR||'dumpInput2='||nvl(p_dump_input2, '-1')||
1183: qp_java_engine_util_pub.G_HARD_CHAR||'dumpInput3='||nvl(p_dump_input3, '-1');
1184: qp_java_engine_util_pub.send_java_engine_request(l_url_param_string,
1185: l_return_status,
1178: l_url_param_string := 'Action=manage'||
1179: qp_java_engine_util_pub.G_HARD_CHAR||'manageAction='||nvl(p_manage_action, '-1')||
1180: qp_java_engine_util_pub.G_HARD_CHAR||'dumpType='||nvl(p_dump_type, '-1')||
1181: qp_java_engine_util_pub.G_HARD_CHAR||'dumpInput1='||nvl(p_dump_input1, '-1')||
1182: qp_java_engine_util_pub.G_HARD_CHAR||'dumpInput2='||nvl(p_dump_input2, '-1')||
1183: qp_java_engine_util_pub.G_HARD_CHAR||'dumpInput3='||nvl(p_dump_input3, '-1');
1184: qp_java_engine_util_pub.send_java_engine_request(l_url_param_string,
1185: l_return_status,
1186: l_return_status_text,
1179: qp_java_engine_util_pub.G_HARD_CHAR||'manageAction='||nvl(p_manage_action, '-1')||
1180: qp_java_engine_util_pub.G_HARD_CHAR||'dumpType='||nvl(p_dump_type, '-1')||
1181: qp_java_engine_util_pub.G_HARD_CHAR||'dumpInput1='||nvl(p_dump_input1, '-1')||
1182: qp_java_engine_util_pub.G_HARD_CHAR||'dumpInput2='||nvl(p_dump_input2, '-1')||
1183: qp_java_engine_util_pub.G_HARD_CHAR||'dumpInput3='||nvl(p_dump_input3, '-1');
1184: qp_java_engine_util_pub.send_java_engine_request(l_url_param_string,
1185: l_return_status,
1186: l_return_status_text,
1187: l_return_details,
1180: qp_java_engine_util_pub.G_HARD_CHAR||'dumpType='||nvl(p_dump_type, '-1')||
1181: qp_java_engine_util_pub.G_HARD_CHAR||'dumpInput1='||nvl(p_dump_input1, '-1')||
1182: qp_java_engine_util_pub.G_HARD_CHAR||'dumpInput2='||nvl(p_dump_input2, '-1')||
1183: qp_java_engine_util_pub.G_HARD_CHAR||'dumpInput3='||nvl(p_dump_input3, '-1');
1184: qp_java_engine_util_pub.send_java_engine_request(l_url_param_string,
1185: l_return_status,
1186: l_return_status_text,
1187: l_return_details,
1188: TRUE);