43:
44: OPEN c_exists;
45: FETCH c_exists into l_dummy;
46: IF c_exists%NOTFOUND THEN
47: p_return_status := fnd_api.g_ret_sts_success;
48: ELSE
49: p_return_status := fnd_api.g_ret_sts_error;
50: p_error_message_code := 'PA_DUP_ROLE_JOB_BG';
51: END IF;
45: FETCH c_exists into l_dummy;
46: IF c_exists%NOTFOUND THEN
47: p_return_status := fnd_api.g_ret_sts_success;
48: ELSE
49: p_return_status := fnd_api.g_ret_sts_error;
50: p_error_message_code := 'PA_DUP_ROLE_JOB_BG';
51: END IF;
52: CLOSE c_exists;
53: EXCEPTION
52: CLOSE c_exists;
53: EXCEPTION
54: WHEN OTHERS THEN
55: CLOSE c_exists;
56: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
57: p_error_message_code := SQLCODE;
58: END check_dup_job_bg_defaults;
59:
60: -- These functions are called from the view PA_PROJECT_ROLE_TYPES_VL