41: ELSE
42: x_flag := 0;
43: END IF;
44:
45: x_return_status := fnd_api.g_ret_sts_success;
46:
47: EXCEPTION
48:
49: -- this shouldn't happen but if it does, its safe to return true
48:
49: -- this shouldn't happen but if it does, its safe to return true
50:
51: WHEN TOO_MANY_ROWS THEN
52: x_return_status := fnd_api.g_ret_sts_success;
53: x_flag := 1;
54:
55: WHEN OTHERS THEN
56: x_return_status := fnd_api.g_ret_sts_unexp_error;
52: x_return_status := fnd_api.g_ret_sts_success;
53: x_flag := 1;
54:
55: WHEN OTHERS THEN
56: x_return_status := fnd_api.g_ret_sts_unexp_error;
57:
58: -- do we need to throw an exception?
59: -- fnd_message.set_name('JTF', '..');
60: -- app_exception.raise_exception;