DBA Data[Home] [Help]

APPS.AMW_COMPONENTS_PKG dependencies on FND_API

Line 109: IF p_commit = FND_API.G_TRUE THEN

105:
106: BEGIN
107:
108: -- create savepoint if p_commit is true
109: IF p_commit = FND_API.G_TRUE THEN
110: SAVEPOINT process_component_save;
111: END IF;
112:
113: -- initialize message list if p_init_msg_list is set to true

Line 114: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then

110: SAVEPOINT process_component_save;
111: END IF;
112:
113: -- initialize message list if p_init_msg_list is set to true
114: if FND_API.to_boolean(nvl(p_init_msg_list, FND_API.G_FALSE)) then
115: fnd_msg_pub.initialize;
116: end if;
117:
118: -- initialize return status to success

Line 119: x_return_status := fnd_api.g_ret_sts_success;

115: fnd_msg_pub.initialize;
116: end if;
117:
118: -- initialize return status to success
119: x_return_status := fnd_api.g_ret_sts_success;
120:
121: -- 11.25.2003: use object_id and object_type instead
122: /*
123: delete from amw_assessment_components

Line 171: WHEN FND_API.G_EXC_ERROR THEN

167: l_object_version_number);
168:
169: end if;
170: EXCEPTION
171: WHEN FND_API.G_EXC_ERROR THEN
172: IF p_commit = FND_API.G_TRUE THEN
173: ROLLBACK TO assessment_component_save;
174: END IF;
175:

Line 172: IF p_commit = FND_API.G_TRUE THEN

168:
169: end if;
170: EXCEPTION
171: WHEN FND_API.G_EXC_ERROR THEN
172: IF p_commit = FND_API.G_TRUE THEN
173: ROLLBACK TO assessment_component_save;
174: END IF;
175:
176: x_return_status := FND_API.G_RET_STS_ERROR;

Line 176: x_return_status := FND_API.G_RET_STS_ERROR;

172: IF p_commit = FND_API.G_TRUE THEN
173: ROLLBACK TO assessment_component_save;
174: END IF;
175:
176: x_return_status := FND_API.G_RET_STS_ERROR;
177:
178: fnd_msg_pub.count_and_get(p_count => x_msg_count,
179: p_data => x_msg_data);
180:

Line 182: IF p_commit = FND_API.G_TRUE THEN

178: fnd_msg_pub.count_and_get(p_count => x_msg_count,
179: p_data => x_msg_data);
180:
181: WHEN OTHERS THEN
182: IF p_commit = FND_API.G_TRUE THEN
183: ROLLBACK TO create_prop_person_support;
184: END IF;
185:
186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

Line 186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

182: IF p_commit = FND_API.G_TRUE THEN
183: ROLLBACK TO create_prop_person_support;
184: END IF;
185:
186: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
187:
188: fnd_msg_pub.add_exc_msg(p_pkg_name => 'AMW_COMPONENTS_PKG',
189: p_procedure_name => 'PROCESS_COMPONENTS',
190: p_error_text => SUBSTRB(SQLERRM,1,240));