FND_UTILITIES: Utility Routines

This section describes various utility routines.

FND_UTILITIES.OPEN_URL

Summary
procedure  OPEN_URL(URL in varchar2);
Description Invokes the Web browser on the client computer with the supplied URL document address. If a browser is already running, the existing browser is directed to open the supplied URL. You can use this utility to point a Web browser to a specific document from your forms.
This utility is not appropriate for opening Oracle Self-Service Web Applications functions from forms, however, as it does not provide session context information required for such functions. Use FND_FUNCTION.EXECUTE for opening those functions.

Arguments (input)

URL You can pass either an actual URL string or a :block.field reference of a field that contains a URL string.
Example 1
FND_UTILITIES.OPEN_URL('http://www.oracle.com/index.html');
Example 2
FND_UTILITIES.OPEN_URL(:blockname.fieldname);

FND_UTILITIES.PARAM_EXISTS

Summary
function  PARAM_EXISTS(name varchar2) return boolean;
Description Returns true if the parameter exists in the current form.

Arguments (input)

name The name of the parameter to search for.
Example
if fnd_utilities.param_exists('APP_TRACE_TRIGGER') then
	execute_trigger(name_in('PARAMETER.APP_TRACE_TRIGGER'));
end if;