APPS.PA_DISTRIBUTION_LIST_UTILS dependencies on FND_API

Line 252: WHEN FND_API.G_EXC_ERROR THEN

248:
249: RETURN l_return_value;
250:
251: EXCEPTION
252: WHEN FND_API.G_EXC_ERROR THEN
253: x_return_status := 'E';
254:
255: WHEN OTHERS THEN
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

252: WHEN FND_API.G_EXC_ERROR THEN
253: x_return_status := 'E';
254:
255: WHEN OTHERS THEN
256: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
257: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_OBJECT_DIST_LISTS_UTILS',
258: p_procedure_name => 'GET_ACCESS_LEVEL',
259: p_error_text => SUBSTRB(SQLERRM,1,240));
260: END get_access_level;

Line 418: WHEN FND_API.G_EXC_ERROR THEN

414: END LOOP;
415: END LOOP;
416:
417: EXCEPTION
418: WHEN FND_API.G_EXC_ERROR THEN
419: x_return_status := 'E';
420: WHEN OTHERS THEN
421: --dbms_output.put_line('unhandled exception');
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

418: WHEN FND_API.G_EXC_ERROR THEN
419: x_return_status := 'E';
420: WHEN OTHERS THEN
421: --dbms_output.put_line('unhandled exception');
422: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
423: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_OBJECT_DIST_LISTS_UTILS',
424: p_procedure_name => 'GET_ACCESS_LEVEL',
425: p_error_text => SUBSTRB(SQLERRM,1,240));
426: END get_dist_list;

Line 605: WHEN FND_API.G_EXC_ERROR THEN

601: END LOOP;
602: END LOOP;
603:
604: EXCEPTION
605: WHEN FND_API.G_EXC_ERROR THEN
606: x_return_status := 'E';
607: WHEN OTHERS THEN
608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
609: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_OBJECT_DIST_LISTS_UTILS',

Line 608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

604: EXCEPTION
605: WHEN FND_API.G_EXC_ERROR THEN
606: x_return_status := 'E';
607: WHEN OTHERS THEN
608: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
609: fnd_msg_pub.add_exc_msg(p_pkg_name => 'PA_OBJECT_DIST_LISTS_UTILS',
610: p_procedure_name => 'GET_DIST_LIST_EMAIL',
611: p_error_text => SUBSTRB(SQLERRM,1,240));
612: END get_dist_list_email;

Line 687: x_return_status := FND_API.G_RET_STS_ERROR;

683: OPEN get_list_id_to;
684: FETCH get_list_id_to INTO l_list_id_to;
685: IF get_list_id_to%FOUND THEN
686: CLOSE get_list_id_to;
687: x_return_status := FND_API.G_RET_STS_ERROR;
688: fnd_message.set_name('PA','PA_DL_LIST_ID_INV');
689: fnd_msg_pub.add();
690: fnd_msg_pub.count_and_get(p_count => x_msg_count,
691: p_data => x_msg_data);