91: where customer_id = p_from_fk_id;
92:
93: exception
94: when others then
95: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
96: fnd_message.set_token('ERROR' ,SQLERRM);
97: fnd_msg_pub.add;
98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
99:
92:
93: exception
94: when others then
95: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
96: fnd_message.set_token('ERROR' ,SQLERRM);
97: fnd_msg_pub.add;
98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
99:
100: end task_merge_party;
189: where address_id = p_from_fk_id;
190:
191: exception
192: when others then
193: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
194: fnd_message.set_token('ERROR' ,SQLERRM);
195: fnd_msg_pub.add;
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
197:
190:
191: exception
192: when others then
193: fnd_message.set_name('AR', 'HZ_API_OTHERS_EXCEP');
194: fnd_message.set_token('ERROR' ,SQLERRM);
195: fnd_msg_pub.add;
196: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
197:
198: end task_merge_address;