102: x_return_status := FND_API.G_RET_STS_ERROR;
103: x_error_message_code := 'PA_ROLE_INVALID_AMBIGOUS';
104: WHEN OTHERS THEN
105: x_role_id := null;
106: fnd_msg_pub.add_exc_msg
107: (p_pkg_name => 'PA_ROLE_UTILS',
108: p_procedure_name => pa_debug.g_err_stack );
109: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
110: RAISE;
162: x_return_status := FND_API.G_RET_STS_ERROR;
163: x_error_message_code := 'PA_ROLE_INVALID_AMBIGOUS';
164:
165: WHEN OTHERS THEN
166: fnd_msg_pub.add_exc_msg
167: (p_pkg_name => 'PA_ROLE_UTILS',
168: p_procedure_name => pa_debug.g_err_stack );
169: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
170: RAISE;
214: x_return_status := FND_API.G_RET_STS_ERROR;
215: x_error_message_code := 'PA_ROLE_LIST_INVALID_AMBIGOUS';
216:
217: WHEN OTHERS THEN
218: fnd_msg_pub.add_exc_msg
219: (p_pkg_name => 'PA_ROLE_LIST_UTILS',
220: p_procedure_name => pa_debug.g_err_stack );
221: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
222: RAISE;
247: WHEN NO_DATA_FOUND THEN
248: x_return_status := FND_API.G_RET_STS_ERROR;
249: x_error_message_code := 'PA_ROLE_NOT_IN_ROLELIST';
250: WHEN OTHERS THEN
251: fnd_msg_pub.add_exc_msg
252: (p_pkg_name => 'PA_ROLE_UTILS',
253: p_procedure_name => pa_debug.g_err_stack );
254: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
255: RAISE;
327: x_return_status:= FND_API.G_RET_STS_SUCCESS;
328: pa_debug.reset_err_stack;
329: EXCEPTION
330: WHEN OTHERS THEN
331: fnd_msg_pub.add_exc_msg
332: (p_pkg_name => 'PA_ROLE_UTILS',
333: p_procedure_name => pa_debug.g_err_stack );
334: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
335: RAISE;
374: CLOSE l_get_bg_csr;
375: pa_debug.reset_err_stack;
376: EXCEPTION
377: WHEN OTHERS THEN
378: fnd_msg_pub.add_exc_msg
379: (p_pkg_name => 'PA_ROLE_UTILS',
380: p_procedure_name => pa_debug.g_err_stack );
381: x_return_status:= FND_API.G_RET_STS_UNEXP_ERROR;
382: RAISE;