34:
35: -- The FND method above may complete without exception,
36: -- but could contain error message. Signal failure and return
37: -- error message instead.
38: errmesg := fnd_message.get;
39: IF errmesg IS NOT NULL THEN
40: x_ret_status := -1;
41: RETURN errmesg;
42: END IF;
44: -- The FND method above may return a null URL. Signal failure
45: -- and return a genric error message.
46: IF l_url IS NULL THEN
47: x_ret_status := -1;
48: fnd_message.set_name('BSC', HELPERR);
49: errmesg := fnd_message.get;
50: RETURN errmesg;
51: END IF;
52:
45: -- and return a genric error message.
46: IF l_url IS NULL THEN
47: x_ret_status := -1;
48: fnd_message.set_name('BSC', HELPERR);
49: errmesg := fnd_message.get;
50: RETURN errmesg;
51: END IF;
52:
53: x_ret_status := 0;
55:
56: EXCEPTION
57: WHEN OTHERS THEN
58: x_ret_status := -1;
59: errmesg := fnd_message.get;
60: -- Give a generic error message, if one does not yet exist.
61: IF errmesg IS NULL THEN
62: fnd_message.set_name('BSC', HELPERR);
63: errmesg := fnd_message.get;
58: x_ret_status := -1;
59: errmesg := fnd_message.get;
60: -- Give a generic error message, if one does not yet exist.
61: IF errmesg IS NULL THEN
62: fnd_message.set_name('BSC', HELPERR);
63: errmesg := fnd_message.get;
64: END IF;
65: RETURN errmesg;
66: END Get_Help_Url;
59: errmesg := fnd_message.get;
60: -- Give a generic error message, if one does not yet exist.
61: IF errmesg IS NULL THEN
62: fnd_message.set_name('BSC', HELPERR);
63: errmesg := fnd_message.get;
64: END IF;
65: RETURN errmesg;
66: END Get_Help_Url;
67: