APPS.POS_BANK_PAYEE_BO_PKG dependencies on FND_API

Line 87: WHEN fnd_api.g_exc_error THEN

83: AND payee.ext_payee_id = instr.ext_pmt_party_id (+); -- Bug 12903268: Associate bank account id with payee.
84:
85: x_pos_bank_payee_bo_tbl := l_pos_bank_payee_bo_tbl;
86: EXCEPTION
87: WHEN fnd_api.g_exc_error THEN
88:
89: x_return_status := fnd_api.g_ret_sts_error;
90: x_msg_count := 1;
91: x_msg_data := SQLCODE || SQLERRM;

Line 89: x_return_status := fnd_api.g_ret_sts_error;

85: x_pos_bank_payee_bo_tbl := l_pos_bank_payee_bo_tbl;
86: EXCEPTION
87: WHEN fnd_api.g_exc_error THEN
88:
89: x_return_status := fnd_api.g_ret_sts_error;
90: x_msg_count := 1;
91: x_msg_data := SQLCODE || SQLERRM;
92: WHEN fnd_api.g_exc_unexpected_error THEN
93:

Line 92: WHEN fnd_api.g_exc_unexpected_error THEN

88:
89: x_return_status := fnd_api.g_ret_sts_error;
90: x_msg_count := 1;
91: x_msg_data := SQLCODE || SQLERRM;
92: WHEN fnd_api.g_exc_unexpected_error THEN
93:
94: x_return_status := fnd_api.g_ret_sts_unexp_error;
95: x_msg_count := 1;
96: x_msg_data := SQLCODE || SQLERRM;

Line 94: x_return_status := fnd_api.g_ret_sts_unexp_error;

90: x_msg_count := 1;
91: x_msg_data := SQLCODE || SQLERRM;
92: WHEN fnd_api.g_exc_unexpected_error THEN
93:
94: x_return_status := fnd_api.g_ret_sts_unexp_error;
95: x_msg_count := 1;
96: x_msg_data := SQLCODE || SQLERRM;
97: WHEN OTHERS THEN
98:

Line 99: x_return_status := fnd_api.g_ret_sts_unexp_error;

95: x_msg_count := 1;
96: x_msg_data := SQLCODE || SQLERRM;
97: WHEN OTHERS THEN
98:
99: x_return_status := fnd_api.g_ret_sts_unexp_error;
100:
101: x_msg_count := 1;
102: x_msg_data := SQLCODE || SQLERRM;
103: END get_pos_bank_payee_bo_tbl;

Line 121: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

117: * @rep:displayname Create POS Bank Payee BO Table
118: * @rep:catagory BUSSINESS_ENTITY AP_SUPPLIER
119: */
120: PROCEDURE create_pos_bank_payee_bo_tbl(p_api_version IN NUMBER,
121: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
122: p_pos_bank_payee_bo_tbl IN pos_bank_payee_bo_tbl,
123: p_party_id IN NUMBER,
124: p_orig_system IN VARCHAR2,
125: p_orig_system_reference IN VARCHAR2,

Line 230: WHEN fnd_api.g_exc_error THEN

226: x_ext_payee_id_tab,
227: x_ext_payee_status_tab);
228: END IF;
229: EXCEPTION
230: WHEN fnd_api.g_exc_error THEN
231:
232: x_return_status := fnd_api.g_ret_sts_error;
233: fnd_msg_pub.count_and_get(p_count => x_msg_count,
234: p_data => x_msg_data);

Line 232: x_return_status := fnd_api.g_ret_sts_error;

228: END IF;
229: EXCEPTION
230: WHEN fnd_api.g_exc_error THEN
231:
232: x_return_status := fnd_api.g_ret_sts_error;
233: fnd_msg_pub.count_and_get(p_count => x_msg_count,
234: p_data => x_msg_data);
235: WHEN fnd_api.g_exc_unexpected_error THEN
236:

Line 235: WHEN fnd_api.g_exc_unexpected_error THEN

231:
232: x_return_status := fnd_api.g_ret_sts_error;
233: fnd_msg_pub.count_and_get(p_count => x_msg_count,
234: p_data => x_msg_data);
235: WHEN fnd_api.g_exc_unexpected_error THEN
236:
237: x_return_status := fnd_api.g_ret_sts_unexp_error;
238: fnd_msg_pub.count_and_get(p_count => x_msg_count,
239: p_data => x_msg_data);

Line 237: x_return_status := fnd_api.g_ret_sts_unexp_error;

233: fnd_msg_pub.count_and_get(p_count => x_msg_count,
234: p_data => x_msg_data);
235: WHEN fnd_api.g_exc_unexpected_error THEN
236:
237: x_return_status := fnd_api.g_ret_sts_unexp_error;
238: fnd_msg_pub.count_and_get(p_count => x_msg_count,
239: p_data => x_msg_data);
240: WHEN OTHERS THEN
241:

Line 242: x_return_status := fnd_api.g_ret_sts_unexp_error;

238: fnd_msg_pub.count_and_get(p_count => x_msg_count,
239: p_data => x_msg_data);
240: WHEN OTHERS THEN
241:
242: x_return_status := fnd_api.g_ret_sts_unexp_error;
243:
244: fnd_msg_pub.count_and_get(p_count => x_msg_count,
245: p_data => x_msg_data);
246: