153: AND branchca.primary_flag = 'Y'; -- Bug 16205262: Check primary_flag to prevent publishing duplicated bank account info.
154:
155: x_pos_bank_account_bo_tbl := l_pos_bank_account_bo_tbl;
156: EXCEPTION
157: WHEN fnd_api.g_exc_error THEN
158: x_return_status := fnd_api.g_ret_sts_error;
159: fnd_msg_pub.count_and_get(p_count => x_msg_count,
160: p_data => x_msg_data);
161: WHEN fnd_api.g_exc_unexpected_error THEN
154:
155: x_pos_bank_account_bo_tbl := l_pos_bank_account_bo_tbl;
156: EXCEPTION
157: WHEN fnd_api.g_exc_error THEN
158: x_return_status := fnd_api.g_ret_sts_error;
159: fnd_msg_pub.count_and_get(p_count => x_msg_count,
160: p_data => x_msg_data);
161: WHEN fnd_api.g_exc_unexpected_error THEN
162: x_return_status := fnd_api.g_ret_sts_unexp_error;
157: WHEN fnd_api.g_exc_error THEN
158: x_return_status := fnd_api.g_ret_sts_error;
159: fnd_msg_pub.count_and_get(p_count => x_msg_count,
160: p_data => x_msg_data);
161: WHEN fnd_api.g_exc_unexpected_error THEN
162: x_return_status := fnd_api.g_ret_sts_unexp_error;
163: fnd_msg_pub.count_and_get(p_count => x_msg_count,
164: p_data => x_msg_data);
165: WHEN OTHERS THEN
158: x_return_status := fnd_api.g_ret_sts_error;
159: fnd_msg_pub.count_and_get(p_count => x_msg_count,
160: p_data => x_msg_data);
161: WHEN fnd_api.g_exc_unexpected_error THEN
162: x_return_status := fnd_api.g_ret_sts_unexp_error;
163: fnd_msg_pub.count_and_get(p_count => x_msg_count,
164: p_data => x_msg_data);
165: WHEN OTHERS THEN
166: x_return_status := fnd_api.g_ret_sts_unexp_error;
162: x_return_status := fnd_api.g_ret_sts_unexp_error;
163: fnd_msg_pub.count_and_get(p_count => x_msg_count,
164: p_data => x_msg_data);
165: WHEN OTHERS THEN
166: x_return_status := fnd_api.g_ret_sts_unexp_error;
167: fnd_msg_pub.count_and_get(p_count => x_msg_count,
168: p_data => x_msg_data);
169:
170: END get_pos_bank_account_bo_tbl;
185: * @rep:catagory BUSSINESS_ENTITY AP_SUPPLIER
186: */
187:
188: PROCEDURE create_pos_bank_account_bo(p_api_version IN NUMBER,
189: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
190: p_party_id IN NUMBER,
191: p_orig_system IN VARCHAR2,
192: p_orig_system_reference IN VARCHAR2,
193: p_create_update_flag IN VARCHAR2,
269: l_response);
270: END IF;
271: END LOOP;
272: EXCEPTION
273: WHEN fnd_api.g_exc_error THEN
274: x_return_status := fnd_api.g_ret_sts_error;
275: fnd_msg_pub.count_and_get(p_count => x_msg_count,
276: p_data => x_msg_data);
277: WHEN fnd_api.g_exc_unexpected_error THEN
270: END IF;
271: END LOOP;
272: EXCEPTION
273: WHEN fnd_api.g_exc_error THEN
274: x_return_status := fnd_api.g_ret_sts_error;
275: fnd_msg_pub.count_and_get(p_count => x_msg_count,
276: p_data => x_msg_data);
277: WHEN fnd_api.g_exc_unexpected_error THEN
278: x_return_status := fnd_api.g_ret_sts_unexp_error;
273: WHEN fnd_api.g_exc_error THEN
274: x_return_status := fnd_api.g_ret_sts_error;
275: fnd_msg_pub.count_and_get(p_count => x_msg_count,
276: p_data => x_msg_data);
277: WHEN fnd_api.g_exc_unexpected_error THEN
278: x_return_status := fnd_api.g_ret_sts_unexp_error;
279: fnd_msg_pub.count_and_get(p_count => x_msg_count,
280: p_data => x_msg_data);
281: WHEN OTHERS THEN
274: x_return_status := fnd_api.g_ret_sts_error;
275: fnd_msg_pub.count_and_get(p_count => x_msg_count,
276: p_data => x_msg_data);
277: WHEN fnd_api.g_exc_unexpected_error THEN
278: x_return_status := fnd_api.g_ret_sts_unexp_error;
279: fnd_msg_pub.count_and_get(p_count => x_msg_count,
280: p_data => x_msg_data);
281: WHEN OTHERS THEN
282: x_return_status := fnd_api.g_ret_sts_unexp_error;
278: x_return_status := fnd_api.g_ret_sts_unexp_error;
279: fnd_msg_pub.count_and_get(p_count => x_msg_count,
280: p_data => x_msg_data);
281: WHEN OTHERS THEN
282: x_return_status := fnd_api.g_ret_sts_unexp_error;
283: fnd_msg_pub.count_and_get(p_count => x_msg_count,
284: p_data => x_msg_data);
285: END create_pos_bank_account_bo;
286: