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.CZ_CF_API dependencies on UTL_HTTP

Line 1217: -----utl_http_request_failed error from network API during batch validation

1213: end;
1214:
1215: -----------------------------------------
1216: -----This procedure is used as a workaround for bug# 2687938 which is
1217: -----utl_http_request_failed error from network API during batch validation
1218: ------although the logs show that the validation was successful
1219:
1220: -------Changes to this procedure is made for SSL implementation
1221: -------Changes are implemented as suggested in bug# 3594440, 3785732,3785687

Line 1232: l_cookies UTL_HTTP.COOKIE_TABLE;

1228: PRAGMA AUTONOMOUS_TRANSACTION;
1229: l_ssl_profile_option VARCHAR2(2000); ----SSL profile option value, if ssl then 'https'
1230: l_wallet_path VARCHAR2(2000); ----directory path of the wallet
1231: l_wallet_passwd VARCHAR2(2000) := NULL; ---- password is not necessary for the default wallet
1232: l_cookies UTL_HTTP.COOKIE_TABLE;
1233: l_cookie UTL_HTTP.COOKIE;
1234: l_start_index NUMBER;
1235: l_end_index NUMBER;
1236:

Line 1233: l_cookie UTL_HTTP.COOKIE;

1229: l_ssl_profile_option VARCHAR2(2000); ----SSL profile option value, if ssl then 'https'
1230: l_wallet_path VARCHAR2(2000); ----directory path of the wallet
1231: l_wallet_passwd VARCHAR2(2000) := NULL; ---- password is not necessary for the default wallet
1232: l_cookies UTL_HTTP.COOKIE_TABLE;
1233: l_cookie UTL_HTTP.COOKIE;
1234: l_start_index NUMBER;
1235: l_end_index NUMBER;
1236:
1237: BEGIN

Line 1243: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.SET_TRANSFER_TIMEOUT(:1); END;' USING IN transferTimeout;

1239: l_wallet_path := FND_PROFILE.VALUE('FND_DB_WALLET_DIR');
1240: l_wallet_path := 'file:'||l_wallet_path ;
1241:
1242: IF (transferTimeout IS NOT NULL AND defaultTimeout IS NOT NULL) THEN
1243: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.SET_TRANSFER_TIMEOUT(:1); END;' USING IN transferTimeout;
1244: END IF;
1245: --vsingava 14 Jul '09 bug7674190
1246: IF(p_model_routing_enabled_for_bv = TRUE) THEN
1247: IF pool_identifier IS NULL THEN

Line 1259: UTL_HTTP.GET_COOKIES(l_cookies);

1255: END IF;
1256: l_start_index := l_end_index;
1257: l_end_index := INSTR(FinalURL, '/', l_start_index+1);
1258: l_cookie.path := SUBSTR(FinalURL, l_start_index, l_end_index-l_start_index);
1259: UTL_HTTP.GET_COOKIES(l_cookies);
1260: l_cookie.name := 'czPoolToken';
1261: l_cookie.value := pool_identifier;
1262: l_cookie.expire := SYSDATE+99999;
1263: --l_cookie.path :='/OA_HTML';

Line 1271: utl_http.clear_cookies;

1267: l_cookie.secure := FALSE;
1268: END IF;
1269: l_cookie.version := 1;
1270: l_cookies(l_cookies.count+1) := l_cookie;
1271: utl_http.clear_cookies;
1272: utl_http.add_cookies(l_cookies);
1273: END IF;
1274: --vsingava 14 Jul '09 bug7674190
1275: -----if the FinalURL is SSL then

Line 1272: utl_http.add_cookies(l_cookies);

1268: END IF;
1269: l_cookie.version := 1;
1270: l_cookies(l_cookies.count+1) := l_cookie;
1271: utl_http.clear_cookies;
1272: utl_http.add_cookies(l_cookies);
1273: END IF;
1274: --vsingava 14 Jul '09 bug7674190
1275: -----if the FinalURL is SSL then
1276: -----pass in the wallet path and wallet passwd

Line 1279: config_messages := UTL_HTTP.request_pieces(url => FinalURL,

1275: -----if the FinalURL is SSL then
1276: -----pass in the wallet path and wallet passwd
1277: -----otherwise pass in the URL only
1278: IF (UPPER(TRIM(FinalURL)) LIKE ('HTTPS%')) THEN
1279: config_messages := UTL_HTTP.request_pieces(url => FinalURL,
1280: wallet_path => l_wallet_path,
1281: wallet_password => l_wallet_passwd);
1282: ELSE
1283: config_messages := UTL_HTTP.request_pieces(url => FinalURL);

Line 1283: config_messages := UTL_HTTP.request_pieces(url => FinalURL);

1279: config_messages := UTL_HTTP.request_pieces(url => FinalURL,
1280: wallet_path => l_wallet_path,
1281: wallet_password => l_wallet_passwd);
1282: ELSE
1283: config_messages := UTL_HTTP.request_pieces(url => FinalURL);
1284: END IF;
1285:
1286: IF (transferTimeout IS NOT NULL AND defaultTimeout IS NOT NULL) THEN
1287: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.SET_TRANSFER_TIMEOUT(:1); END;' USING IN defaultTimeout;

Line 1287: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.SET_TRANSFER_TIMEOUT(:1); END;' USING IN defaultTimeout;

1283: config_messages := UTL_HTTP.request_pieces(url => FinalURL);
1284: END IF;
1285:
1286: IF (transferTimeout IS NOT NULL AND defaultTimeout IS NOT NULL) THEN
1287: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.SET_TRANSFER_TIMEOUT(:1); END;' USING IN defaultTimeout;
1288: END IF;
1289: COMMIT;
1290: EXCEPTION
1291: WHEN MODEL_POOL_EFFINITY_EXC THEN

Line 1541: UTL_HTTP.get_detailed_excp_support (detailed_excp_flag);

1537: detailed_excp_flag boolean;
1538: -- n0 integer; n1 integer; n2 integer; msg varchar2(255);
1539:
1540: BEGIN
1541: UTL_HTTP.get_detailed_excp_support (detailed_excp_flag);
1542:
1543: IF detailed_excp_flag<>true
1544: THEN
1545: UTL_HTTP.set_detailed_excp_support(enable =>TRUE);

Line 1545: UTL_HTTP.set_detailed_excp_support(enable =>TRUE);

1541: UTL_HTTP.get_detailed_excp_support (detailed_excp_flag);
1542:
1543: IF detailed_excp_flag<>true
1544: THEN
1545: UTL_HTTP.set_detailed_excp_support(enable =>TRUE);
1546: END IF;
1547:
1548: --Need to avoid this if possible
1549: l_init_message := p_init_msg;

Line 1691: WHEN UTL_HTTP.INIT_FAILED THEN

1687: x_validation_status := CONFIG_PROCESSED_NO_TERMINATE;
1688: END IF;
1689:
1690: EXCEPTION
1691: WHEN UTL_HTTP.INIT_FAILED THEN
1692: v_detailed_error_message:=' SQLCODE:'||UTL_HTTP.GET_DETAILED_SQLCODE||' ERROR:'||UTL_HTTP.GET_DETAILED_SQLERRM;
1693: x_validation_status := UTL_HTTP_INIT_FAILED;
1694:
1695: IF detailed_excp_flag<>true

Line 1692: v_detailed_error_message:=' SQLCODE:'||UTL_HTTP.GET_DETAILED_SQLCODE||' ERROR:'||UTL_HTTP.GET_DETAILED_SQLERRM;

1688: END IF;
1689:
1690: EXCEPTION
1691: WHEN UTL_HTTP.INIT_FAILED THEN
1692: v_detailed_error_message:=' SQLCODE:'||UTL_HTTP.GET_DETAILED_SQLCODE||' ERROR:'||UTL_HTTP.GET_DETAILED_SQLERRM;
1693: x_validation_status := UTL_HTTP_INIT_FAILED;
1694:
1695: IF detailed_excp_flag<>true
1696: THEN

Line 1693: x_validation_status := UTL_HTTP_INIT_FAILED;

1689:
1690: EXCEPTION
1691: WHEN UTL_HTTP.INIT_FAILED THEN
1692: v_detailed_error_message:=' SQLCODE:'||UTL_HTTP.GET_DETAILED_SQLCODE||' ERROR:'||UTL_HTTP.GET_DETAILED_SQLERRM;
1693: x_validation_status := UTL_HTTP_INIT_FAILED;
1694:
1695: IF detailed_excp_flag<>true
1696: THEN
1697: UTL_HTTP.set_detailed_excp_support(enable =>FALSE);

Line 1697: UTL_HTTP.set_detailed_excp_support(enable =>FALSE);

1693: x_validation_status := UTL_HTTP_INIT_FAILED;
1694:
1695: IF detailed_excp_flag<>true
1696: THEN
1697: UTL_HTTP.set_detailed_excp_support(enable =>FALSE);
1698: END IF;
1699:
1700: WHEN UTL_HTTP.REQUEST_FAILED OR UTL_HTTP.BAD_ARGUMENT
1701: OR UTL_HTTP.BAD_URL OR UTL_HTTP.PROTOCOL_ERROR

Line 1700: WHEN UTL_HTTP.REQUEST_FAILED OR UTL_HTTP.BAD_ARGUMENT

1696: THEN
1697: UTL_HTTP.set_detailed_excp_support(enable =>FALSE);
1698: END IF;
1699:
1700: WHEN UTL_HTTP.REQUEST_FAILED OR UTL_HTTP.BAD_ARGUMENT
1701: OR UTL_HTTP.BAD_URL OR UTL_HTTP.PROTOCOL_ERROR
1702: OR UTL_HTTP.UNKNOWN_SCHEME OR UTL_HTTP.HEADER_NOT_FOUND
1703: OR UTL_HTTP.END_OF_BODY OR UTL_HTTP.ILLEGAL_CALL
1704: OR UTL_HTTP.HTTP_CLIENT_ERROR OR UTL_HTTP.HTTP_SERVER_ERROR

Line 1701: OR UTL_HTTP.BAD_URL OR UTL_HTTP.PROTOCOL_ERROR

1697: UTL_HTTP.set_detailed_excp_support(enable =>FALSE);
1698: END IF;
1699:
1700: WHEN UTL_HTTP.REQUEST_FAILED OR UTL_HTTP.BAD_ARGUMENT
1701: OR UTL_HTTP.BAD_URL OR UTL_HTTP.PROTOCOL_ERROR
1702: OR UTL_HTTP.UNKNOWN_SCHEME OR UTL_HTTP.HEADER_NOT_FOUND
1703: OR UTL_HTTP.END_OF_BODY OR UTL_HTTP.ILLEGAL_CALL
1704: OR UTL_HTTP.HTTP_CLIENT_ERROR OR UTL_HTTP.HTTP_SERVER_ERROR
1705: OR UTL_HTTP.TOO_MANY_REQUESTS OR UTL_HTTP.PARTIAL_MULTIBYTE_CHAR

Line 1702: OR UTL_HTTP.UNKNOWN_SCHEME OR UTL_HTTP.HEADER_NOT_FOUND

1698: END IF;
1699:
1700: WHEN UTL_HTTP.REQUEST_FAILED OR UTL_HTTP.BAD_ARGUMENT
1701: OR UTL_HTTP.BAD_URL OR UTL_HTTP.PROTOCOL_ERROR
1702: OR UTL_HTTP.UNKNOWN_SCHEME OR UTL_HTTP.HEADER_NOT_FOUND
1703: OR UTL_HTTP.END_OF_BODY OR UTL_HTTP.ILLEGAL_CALL
1704: OR UTL_HTTP.HTTP_CLIENT_ERROR OR UTL_HTTP.HTTP_SERVER_ERROR
1705: OR UTL_HTTP.TOO_MANY_REQUESTS OR UTL_HTTP.PARTIAL_MULTIBYTE_CHAR
1706: OR UTL_HTTP.TRANSFER_TIMEOUT THEN

Line 1703: OR UTL_HTTP.END_OF_BODY OR UTL_HTTP.ILLEGAL_CALL

1699:
1700: WHEN UTL_HTTP.REQUEST_FAILED OR UTL_HTTP.BAD_ARGUMENT
1701: OR UTL_HTTP.BAD_URL OR UTL_HTTP.PROTOCOL_ERROR
1702: OR UTL_HTTP.UNKNOWN_SCHEME OR UTL_HTTP.HEADER_NOT_FOUND
1703: OR UTL_HTTP.END_OF_BODY OR UTL_HTTP.ILLEGAL_CALL
1704: OR UTL_HTTP.HTTP_CLIENT_ERROR OR UTL_HTTP.HTTP_SERVER_ERROR
1705: OR UTL_HTTP.TOO_MANY_REQUESTS OR UTL_HTTP.PARTIAL_MULTIBYTE_CHAR
1706: OR UTL_HTTP.TRANSFER_TIMEOUT THEN
1707: v_detailed_error_message:=' SQLCODE:'||UTL_HTTP.GET_DETAILED_SQLCODE||' ERROR:'||UTL_HTTP.GET_DETAILED_SQLERRM;

Line 1704: OR UTL_HTTP.HTTP_CLIENT_ERROR OR UTL_HTTP.HTTP_SERVER_ERROR

1700: WHEN UTL_HTTP.REQUEST_FAILED OR UTL_HTTP.BAD_ARGUMENT
1701: OR UTL_HTTP.BAD_URL OR UTL_HTTP.PROTOCOL_ERROR
1702: OR UTL_HTTP.UNKNOWN_SCHEME OR UTL_HTTP.HEADER_NOT_FOUND
1703: OR UTL_HTTP.END_OF_BODY OR UTL_HTTP.ILLEGAL_CALL
1704: OR UTL_HTTP.HTTP_CLIENT_ERROR OR UTL_HTTP.HTTP_SERVER_ERROR
1705: OR UTL_HTTP.TOO_MANY_REQUESTS OR UTL_HTTP.PARTIAL_MULTIBYTE_CHAR
1706: OR UTL_HTTP.TRANSFER_TIMEOUT THEN
1707: v_detailed_error_message:=' SQLCODE:'||UTL_HTTP.GET_DETAILED_SQLCODE||' ERROR:'||UTL_HTTP.GET_DETAILED_SQLERRM;
1708: x_validation_status:=UTL_HTTP_REQUEST_FAILED;

Line 1705: OR UTL_HTTP.TOO_MANY_REQUESTS OR UTL_HTTP.PARTIAL_MULTIBYTE_CHAR

1701: OR UTL_HTTP.BAD_URL OR UTL_HTTP.PROTOCOL_ERROR
1702: OR UTL_HTTP.UNKNOWN_SCHEME OR UTL_HTTP.HEADER_NOT_FOUND
1703: OR UTL_HTTP.END_OF_BODY OR UTL_HTTP.ILLEGAL_CALL
1704: OR UTL_HTTP.HTTP_CLIENT_ERROR OR UTL_HTTP.HTTP_SERVER_ERROR
1705: OR UTL_HTTP.TOO_MANY_REQUESTS OR UTL_HTTP.PARTIAL_MULTIBYTE_CHAR
1706: OR UTL_HTTP.TRANSFER_TIMEOUT THEN
1707: v_detailed_error_message:=' SQLCODE:'||UTL_HTTP.GET_DETAILED_SQLCODE||' ERROR:'||UTL_HTTP.GET_DETAILED_SQLERRM;
1708: x_validation_status:=UTL_HTTP_REQUEST_FAILED;
1709:

Line 1706: OR UTL_HTTP.TRANSFER_TIMEOUT THEN

1702: OR UTL_HTTP.UNKNOWN_SCHEME OR UTL_HTTP.HEADER_NOT_FOUND
1703: OR UTL_HTTP.END_OF_BODY OR UTL_HTTP.ILLEGAL_CALL
1704: OR UTL_HTTP.HTTP_CLIENT_ERROR OR UTL_HTTP.HTTP_SERVER_ERROR
1705: OR UTL_HTTP.TOO_MANY_REQUESTS OR UTL_HTTP.PARTIAL_MULTIBYTE_CHAR
1706: OR UTL_HTTP.TRANSFER_TIMEOUT THEN
1707: v_detailed_error_message:=' SQLCODE:'||UTL_HTTP.GET_DETAILED_SQLCODE||' ERROR:'||UTL_HTTP.GET_DETAILED_SQLERRM;
1708: x_validation_status:=UTL_HTTP_REQUEST_FAILED;
1709:
1710: IF detailed_excp_flag<>true

Line 1707: v_detailed_error_message:=' SQLCODE:'||UTL_HTTP.GET_DETAILED_SQLCODE||' ERROR:'||UTL_HTTP.GET_DETAILED_SQLERRM;

1703: OR UTL_HTTP.END_OF_BODY OR UTL_HTTP.ILLEGAL_CALL
1704: OR UTL_HTTP.HTTP_CLIENT_ERROR OR UTL_HTTP.HTTP_SERVER_ERROR
1705: OR UTL_HTTP.TOO_MANY_REQUESTS OR UTL_HTTP.PARTIAL_MULTIBYTE_CHAR
1706: OR UTL_HTTP.TRANSFER_TIMEOUT THEN
1707: v_detailed_error_message:=' SQLCODE:'||UTL_HTTP.GET_DETAILED_SQLCODE||' ERROR:'||UTL_HTTP.GET_DETAILED_SQLERRM;
1708: x_validation_status:=UTL_HTTP_REQUEST_FAILED;
1709:
1710: IF detailed_excp_flag<>true
1711: THEN

Line 1708: x_validation_status:=UTL_HTTP_REQUEST_FAILED;

1704: OR UTL_HTTP.HTTP_CLIENT_ERROR OR UTL_HTTP.HTTP_SERVER_ERROR
1705: OR UTL_HTTP.TOO_MANY_REQUESTS OR UTL_HTTP.PARTIAL_MULTIBYTE_CHAR
1706: OR UTL_HTTP.TRANSFER_TIMEOUT THEN
1707: v_detailed_error_message:=' SQLCODE:'||UTL_HTTP.GET_DETAILED_SQLCODE||' ERROR:'||UTL_HTTP.GET_DETAILED_SQLERRM;
1708: x_validation_status:=UTL_HTTP_REQUEST_FAILED;
1709:
1710: IF detailed_excp_flag<>true
1711: THEN
1712: UTL_HTTP.set_detailed_excp_support(enable =>FALSE);

Line 1712: UTL_HTTP.set_detailed_excp_support(enable =>FALSE);

1708: x_validation_status:=UTL_HTTP_REQUEST_FAILED;
1709:
1710: IF detailed_excp_flag<>true
1711: THEN
1712: UTL_HTTP.set_detailed_excp_support(enable =>FALSE);
1713: END IF;
1714:
1715: WHEN MISSING_CALLING_APPL_ID THEN
1716: v_detailed_error_message := 'Batch validation message does not carry calling_application_id param.';

Line 1720: UTL_HTTP.set_detailed_excp_support(enable =>FALSE);

1716: v_detailed_error_message := 'Batch validation message does not carry calling_application_id param.';
1717: x_validation_status := CONFIG_EXCEPTION;
1718: IF detailed_excp_flag<>true
1719: THEN
1720: UTL_HTTP.set_detailed_excp_support(enable =>FALSE);
1721: END IF;
1722:
1723: WHEN OTHERS THEN
1724: IF detailed_excp_flag<>true

Line 1726: UTL_HTTP.set_detailed_excp_support(enable =>FALSE);

1722:
1723: WHEN OTHERS THEN
1724: IF detailed_excp_flag<>true
1725: THEN
1726: UTL_HTTP.set_detailed_excp_support(enable =>FALSE);
1727: END IF;
1728:
1729: IF sqlcode='-12545'
1730: then

Line 1731: x_validation_status:=UTL_HTTP_REQUEST_FAILED;

1727: END IF;
1728:
1729: IF sqlcode='-12545'
1730: then
1731: x_validation_status:=UTL_HTTP_REQUEST_FAILED;
1732: ELSE
1733: RAISE;
1734: END IF;
1735: END validate; -- pvt

Line 2253: ELSIF l_validation_status = UTL_HTTP_INIT_FAILED THEN

2249: fnd_message.set_name('CZ', 'CZ_BV_ERR_INIT_MSG');
2250: fnd_message.SET_TOKEN('ERROR_MSG', v_detailed_error_message);
2251: fnd_msg_pub.add;
2252: RAISE FND_API.G_EXC_ERROR;
2253: ELSIF l_validation_status = UTL_HTTP_INIT_FAILED THEN
2254: fnd_message.set_name('CZ', 'CZ_BV_ERR_HTTP_INIT');
2255: fnd_message.SET_TOKEN('ERROR_MSG', v_detailed_error_message);
2256: fnd_msg_pub.add;
2257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2258: ELSIF l_validation_status = UTL_HTTP_REQUEST_FAILED THEN

2254: fnd_message.set_name('CZ', 'CZ_BV_ERR_HTTP_INIT');
2255: fnd_message.SET_TOKEN('ERROR_MSG', v_detailed_error_message);
2256: fnd_msg_pub.add;
2257: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2258: ELSIF l_validation_status = UTL_HTTP_REQUEST_FAILED THEN
2259: fnd_message.set_name('CZ', 'CZ_BV_ERR_HTTP_REQ');
2260: fnd_message.SET_TOKEN('ERROR_MSG', v_detailed_error_message);
2261: fnd_msg_pub.add;
2262: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 2584: IF validation_status = UTL_HTTP_INIT_FAILED OR

2580:
2581: l_nDebug := 7;
2582: -- delete based on setting in cz_db_settings
2583: l_check_db_setting := TRUE;
2584: IF validation_status = UTL_HTTP_INIT_FAILED OR
2585: validation_status = UTL_HTTP_REQUEST_FAILED THEN
2586: l_check_db_setting := FALSE;
2587: END IF;
2588:

Line 2585: validation_status = UTL_HTTP_REQUEST_FAILED THEN

2581: l_nDebug := 7;
2582: -- delete based on setting in cz_db_settings
2583: l_check_db_setting := TRUE;
2584: IF validation_status = UTL_HTTP_INIT_FAILED OR
2585: validation_status = UTL_HTTP_REQUEST_FAILED THEN
2586: l_check_db_setting := FALSE;
2587: END IF;
2588:
2589: delete_bv_records(l_pseudo_hdr_id, l_check_db_setting, FALSE);

Line 4335: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.GET_TRANSFER_TIMEOUT(:1); END;' USING IN OUT defaultTimeout;

4331: END IF;
4332:
4333: BEGIN
4334: transferTimeout := To_number(get_db_setting('SCHEMA', 'UTLHTTPTRANSFERTIMEOUT'));
4335: EXECUTE IMMEDIATE 'BEGIN UTL_HTTP.GET_TRANSFER_TIMEOUT(:1); END;' USING IN OUT defaultTimeout;
4336: EXCEPTION
4337: WHEN OTHERS THEN
4338: transferTimeout := NULL;
4339: defaultTimeout := NULL;