APPS.PA_ROLE_STATUS_MENU_UTILS dependencies on FND_API

Line 39: p_return_status := fnd_api.g_ret_sts_success;

35: BEGIN
36: OPEN c_exists;
37: FETCH c_exists into l_dummy;
38: IF c_exists%NOTFOUND THEN
39: p_return_status := fnd_api.g_ret_sts_success;
40: ELSE
41: p_return_status := fnd_api.g_ret_sts_error;
42: p_error_message_code := 'PA_DUP_ROLE_STATUS_MAPPING';
43: END IF;

Line 41: p_return_status := fnd_api.g_ret_sts_error;

37: FETCH c_exists into l_dummy;
38: IF c_exists%NOTFOUND THEN
39: p_return_status := fnd_api.g_ret_sts_success;
40: ELSE
41: p_return_status := fnd_api.g_ret_sts_error;
42: p_error_message_code := 'PA_DUP_ROLE_STATUS_MAPPING';
43: END IF;
44: CLOSE c_exists;
45: EXCEPTION

Line 48: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

44: CLOSE c_exists;
45: EXCEPTION
46: WHEN OTHERS THEN
47: CLOSE c_exists;
48: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
49: p_error_message_code := SQLCODE;
50: END check_dup_role_status;
51:
52: --

Line 81: p_return_status := fnd_api.g_ret_sts_success;

77:
78: OPEN c_exists;
79: FETCH c_exists into p_in_use_flag;
80: IF c_exists%NOTFOUND THEN
81: p_return_status := fnd_api.g_ret_sts_success;
82: ELSE
83: p_return_status := fnd_api.g_ret_sts_error;
84: p_error_message_code := 'PA_ROLE_STATUS_MAPPING_EXISTS';
85: END IF;

Line 83: p_return_status := fnd_api.g_ret_sts_error;

79: FETCH c_exists into p_in_use_flag;
80: IF c_exists%NOTFOUND THEN
81: p_return_status := fnd_api.g_ret_sts_success;
82: ELSE
83: p_return_status := fnd_api.g_ret_sts_error;
84: p_error_message_code := 'PA_ROLE_STATUS_MAPPING_EXISTS';
85: END IF;
86: CLOSE c_exists;
87: EXCEPTION

Line 90: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

86: CLOSE c_exists;
87: EXCEPTION
88: WHEN OTHERS THEN
89: CLOSE c_exists;
90: p_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
91: p_error_message_code := SQLCODE;
92: END check_status_is_in_use;
93: --
94: -- PROCEDURE

Line 138: x_return_status := FND_API.G_RET_STS_SUCCESS;

134: l_count NUMBER := 1;
135:
136: BEGIN
137:
138: x_return_status := FND_API.G_RET_STS_SUCCESS;
139:
140: OPEN csr_get_role_level_info;
141: FETCH csr_get_role_level_info into x_status_level, x_default_menu_name;
142: IF csr_get_role_level_info%NOTFOUND THEN

Line 143: x_return_status := fnd_api.g_ret_sts_error;

139:
140: OPEN csr_get_role_level_info;
141: FETCH csr_get_role_level_info into x_status_level, x_default_menu_name;
142: IF csr_get_role_level_info%NOTFOUND THEN
143: x_return_status := fnd_api.g_ret_sts_error;
144: x_error_message_code := 'PA_INVALID_PROJECT_ROLE';
145: ELSE
146: IF x_default_menu_name IS NOT NULL THEN
147: OPEN csr_get_role_status_info;

Line 160: x_return_status := FND_API.G_RET_STS_SUCCESS;

156: x_status_type_tbl := NULL;
157: x_status_code_tbl := NULL;
158: x_menu_name_tbl := NULL;
159: x_status_level := NULL;
160: x_return_status := FND_API.G_RET_STS_SUCCESS;
161: END IF;
162: END IF;
163:
164: CLOSE csr_get_role_level_info;

Line 169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

165:
166:
167: EXCEPTION
168: WHEN OTHERS THEN
169: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
170: x_error_message_code := SQLCODE;
171:
172: END get_role_status_menus;
173: