DBA Data[Home] [Help]

APPS.HZ_EXT_ATTRIBUTE_BO_PVT dependencies on FND_API

Line 19: -- be fnd_api.g_ret_sts_success (success),

15: -- p_parent_obj_type Parent object type.
16: -- p_create_or_update Create or update flag.
17: -- OUT:
18: -- x_return_status Return status after the call. The status can
19: -- be fnd_api.g_ret_sts_success (success),
20: -- fnd_api.g_ret_sts_error (error),
21: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
22: -- x_msg_count Number of messages in message stack.
23: -- x_msg_data Message text if x_msg_count is 1.

Line 20: -- fnd_api.g_ret_sts_error (error),

16: -- p_create_or_update Create or update flag.
17: -- OUT:
18: -- x_return_status Return status after the call. The status can
19: -- be fnd_api.g_ret_sts_success (success),
20: -- fnd_api.g_ret_sts_error (error),
21: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
22: -- x_msg_count Number of messages in message stack.
23: -- x_msg_data Message text if x_msg_count is 1.
24: -- x_errorcode Error code.

Line 21: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).

17: -- OUT:
18: -- x_return_status Return status after the call. The status can
19: -- be fnd_api.g_ret_sts_success (success),
20: -- fnd_api.g_ret_sts_error (error),
21: -- FND_API.G_RET_STS_UNEXP_ERROR (unexpected error).
22: -- x_msg_count Number of messages in message stack.
23: -- x_msg_data Message text if x_msg_count is 1.
24: -- x_errorcode Error code.
25: --

Line 55: x_return_status := FND_API.G_RET_STS_SUCCESS;

51: -- Standard start of API savepoint
52: SAVEPOINT save_ext_attributes_pvt;
53:
54: -- initialize API return status to success.
55: x_return_status := FND_API.G_RET_STS_SUCCESS;
56:
57: -- Debug info.
58: IF fnd_log.level_procedure>=fnd_log.g_current_runtime_level THEN
59: hz_utility_v2pub.debug(p_message=>'save_ext_attributes(+)',

Line 92: RAISE FND_API.G_EXC_ERROR;

88: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
89: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'hz_ext_attribute_bo_pvt.save_ext_attributes');
90: FND_MESSAGE.SET_TOKEN('ERROR', 'row identifier is null');
91: FND_MSG_PUB.ADD;
92: RAISE FND_API.G_EXC_ERROR;
93: END IF;
94: IF((l_current_row IS NULL) OR
95: (NOT (l_current_row = p_ext_attr_objs(i).row_identifier))) THEN
96: l_user_attr_row_table.EXTEND;

Line 139: p_add_errors_to_fnd_stack => FND_API.G_TRUE,

135: p_api_version => 1.0,
136: p_org_profile_id => p_parent_obj_id,
137: p_attributes_row_table => l_user_attr_row_table,
138: p_attributes_data_table => l_user_attr_data_table,
139: p_add_errors_to_fnd_stack => FND_API.G_TRUE,
140: x_failed_row_id_list => l_failed_row_id_list,
141: x_return_status => x_return_status,
142: x_errorcode => x_errorcode,
143: x_msg_count => x_msg_count,

Line 152: p_add_errors_to_fnd_stack => FND_API.G_TRUE,

148: p_api_version => 1.0,
149: p_person_profile_id => p_parent_obj_id,
150: p_attributes_row_table => l_user_attr_row_table,
151: p_attributes_data_table => l_user_attr_data_table,
152: p_add_errors_to_fnd_stack => FND_API.G_TRUE,
153: x_failed_row_id_list => l_failed_row_id_list,
154: x_return_status => x_return_status,
155: x_errorcode => x_errorcode,
156: x_msg_count => x_msg_count,

Line 165: p_add_errors_to_fnd_stack => FND_API.G_TRUE,

161: p_api_version => 1.0,
162: p_party_site_id => p_parent_obj_id,
163: p_attributes_row_table => l_user_attr_row_table,
164: p_attributes_data_table => l_user_attr_data_table,
165: p_add_errors_to_fnd_stack => FND_API.G_TRUE,
166: x_failed_row_id_list => l_failed_row_id_list,
167: x_return_status => x_return_status,
168: x_errorcode => x_errorcode,
169: x_msg_count => x_msg_count,

Line 178: p_add_errors_to_fnd_stack => FND_API.G_TRUE,

174: p_api_version => 1.0,
175: p_location_id => p_parent_obj_id,
176: p_attributes_row_table => l_user_attr_row_table,
177: p_attributes_data_table => l_user_attr_data_table,
178: p_add_errors_to_fnd_stack => FND_API.G_TRUE,
179: x_failed_row_id_list => l_failed_row_id_list,
180: x_return_status => x_return_status,
181: x_errorcode => x_errorcode,
182: x_msg_count => x_msg_count,

Line 187: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

183: x_msg_data => x_msg_data
184: );
185: END CASE;
186:
187: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
188: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
189: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'hz_ext_attribute_bo_pvt.save_ext_attributes');
190: FND_MESSAGE.SET_TOKEN('ERROR', 'save ext attributes, parent type and id: '||p_parent_obj_type||' '||p_parent_obj_id);
191: FND_MSG_PUB.ADD;

Line 192: RAISE FND_API.G_EXC_ERROR;

188: FND_MESSAGE.SET_NAME('AR', 'HZ_API_HOOK_ERROR');
189: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'hz_ext_attribute_bo_pvt.save_ext_attributes');
190: FND_MESSAGE.SET_TOKEN('ERROR', 'save ext attributes, parent type and id: '||p_parent_obj_type||' '||p_parent_obj_id);
191: FND_MSG_PUB.ADD;
192: RAISE FND_API.G_EXC_ERROR;
193: END IF;
194:
195: -- Debug info.
196: IF fnd_log.level_exception>=fnd_log.g_current_runtime_level THEN

Line 208: WHEN fnd_api.g_exc_error THEN

204: p_prefix=>l_debug_prefix,
205: p_msg_level=>fnd_log.level_procedure);
206: END IF;
207: EXCEPTION
208: WHEN fnd_api.g_exc_error THEN
209: ROLLBACK TO save_ext_attributes_pvt;
210: x_return_status := fnd_api.g_ret_sts_error;
211:
212: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 210: x_return_status := fnd_api.g_ret_sts_error;

206: END IF;
207: EXCEPTION
208: WHEN fnd_api.g_exc_error THEN
209: ROLLBACK TO save_ext_attributes_pvt;
210: x_return_status := fnd_api.g_ret_sts_error;
211:
212: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
213: p_count => x_msg_count,
214: p_data => x_msg_data);

Line 212: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

208: WHEN fnd_api.g_exc_error THEN
209: ROLLBACK TO save_ext_attributes_pvt;
210: x_return_status := fnd_api.g_ret_sts_error;
211:
212: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
213: p_count => x_msg_count,
214: p_data => x_msg_data);
215:
216: -- Debug info.

Line 229: WHEN fnd_api.g_exc_unexpected_error THEN

225: p_prefix=>l_debug_prefix,
226: p_msg_level=>fnd_log.level_procedure);
227: END IF;
228:
229: WHEN fnd_api.g_exc_unexpected_error THEN
230: ROLLBACK TO save_ext_attributes_pvt;
231: x_return_status := fnd_api.g_ret_sts_unexp_error;
232:
233: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

Line 231: x_return_status := fnd_api.g_ret_sts_unexp_error;

227: END IF;
228:
229: WHEN fnd_api.g_exc_unexpected_error THEN
230: ROLLBACK TO save_ext_attributes_pvt;
231: x_return_status := fnd_api.g_ret_sts_unexp_error;
232:
233: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
234: p_count => x_msg_count,
235: p_data => x_msg_data);

Line 233: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

229: WHEN fnd_api.g_exc_unexpected_error THEN
230: ROLLBACK TO save_ext_attributes_pvt;
231: x_return_status := fnd_api.g_ret_sts_unexp_error;
232:
233: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
234: p_count => x_msg_count,
235: p_data => x_msg_data);
236:
237: -- Debug info.

Line 252: x_return_status := fnd_api.g_ret_sts_unexp_error;

248: END IF;
249:
250: WHEN OTHERS THEN
251: ROLLBACK TO save_ext_attributes_pvt;
252: x_return_status := fnd_api.g_ret_sts_unexp_error;
253:
254: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
255: fnd_message.set_token('ERROR' ,SQLERRM);
256: fnd_msg_pub.add;

Line 258: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,

254: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
255: fnd_message.set_token('ERROR' ,SQLERRM);
256: fnd_msg_pub.add;
257:
258: fnd_msg_pub.count_and_get(p_encoded => fnd_api.g_false,
259: p_count => x_msg_count,
260: p_data => x_msg_data);
261:
262: -- Debug info.