APPS.POS_TAX_REPORT_BO_PKG dependencies on FND_API

Line 21: x_return_status := fnd_api.g_ret_sts_success;

17: l_pos_tax_report_bo_tbl pos_tax_report_bo_tbl := pos_tax_report_bo_tbl();
18:
19: l_party_id NUMBER;
20: BEGIN
21: x_return_status := fnd_api.g_ret_sts_success;
22: x_msg_count := 0;
23: x_msg_data := '';
24:
25: IF p_party_id IS NULL OR p_party_id = 0 THEN

Line 55: WHEN fnd_api.g_exc_error THEN

51: WHERE entity_id = l_party_id;
52:
53: x_pos_tax_report_bo_tbl := l_pos_tax_report_bo_tbl;
54: EXCEPTION
55: WHEN fnd_api.g_exc_error THEN
56:
57: x_return_status := fnd_api.g_ret_sts_error;
58: x_msg_count := 1;
59: x_msg_data := SQLCODE || SQLERRM;

Line 57: x_return_status := fnd_api.g_ret_sts_error;

53: x_pos_tax_report_bo_tbl := l_pos_tax_report_bo_tbl;
54: EXCEPTION
55: WHEN fnd_api.g_exc_error THEN
56:
57: x_return_status := fnd_api.g_ret_sts_error;
58: x_msg_count := 1;
59: x_msg_data := SQLCODE || SQLERRM;
60: WHEN fnd_api.g_exc_unexpected_error THEN
61:

Line 60: WHEN fnd_api.g_exc_unexpected_error THEN

56:
57: x_return_status := fnd_api.g_ret_sts_error;
58: x_msg_count := 1;
59: x_msg_data := SQLCODE || SQLERRM;
60: WHEN fnd_api.g_exc_unexpected_error THEN
61:
62: x_return_status := fnd_api.g_ret_sts_unexp_error;
63: x_msg_count := 1;
64: x_msg_data := SQLCODE || SQLERRM;

Line 62: x_return_status := fnd_api.g_ret_sts_unexp_error;

58: x_msg_count := 1;
59: x_msg_data := SQLCODE || SQLERRM;
60: WHEN fnd_api.g_exc_unexpected_error THEN
61:
62: x_return_status := fnd_api.g_ret_sts_unexp_error;
63: x_msg_count := 1;
64: x_msg_data := SQLCODE || SQLERRM;
65: WHEN OTHERS THEN
66:

Line 67: x_return_status := fnd_api.g_ret_sts_unexp_error;

63: x_msg_count := 1;
64: x_msg_data := SQLCODE || SQLERRM;
65: WHEN OTHERS THEN
66:
67: x_return_status := fnd_api.g_ret_sts_unexp_error;
68:
69: x_msg_count := 1;
70: x_msg_data := SQLCODE || SQLERRM;
71:

Line 93: x_return_status := fnd_api.g_ret_sts_success;

89: l_party_id NUMBER := 0;
90: l_reporting_code_id NUMBER;
91: BEGIN
92: l_row_exists := 0;
93: x_return_status := fnd_api.g_ret_sts_success;
94: x_msg_count := 0;
95: x_msg_data := '';
96:
97: IF p_party_id IS NULL OR p_party_id = 0 THEN

Line 184: WHEN fnd_api.g_exc_error THEN

180:
181: END IF;
182: END LOOP;
183: EXCEPTION
184: WHEN fnd_api.g_exc_error THEN
185:
186: x_return_status := fnd_api.g_ret_sts_error;
187: x_msg_count := 1;
188: x_msg_data := SQLCODE || SQLERRM;

Line 186: x_return_status := fnd_api.g_ret_sts_error;

182: END LOOP;
183: EXCEPTION
184: WHEN fnd_api.g_exc_error THEN
185:
186: x_return_status := fnd_api.g_ret_sts_error;
187: x_msg_count := 1;
188: x_msg_data := SQLCODE || SQLERRM;
189: WHEN fnd_api.g_exc_unexpected_error THEN
190:

Line 189: WHEN fnd_api.g_exc_unexpected_error THEN

185:
186: x_return_status := fnd_api.g_ret_sts_error;
187: x_msg_count := 1;
188: x_msg_data := SQLCODE || SQLERRM;
189: WHEN fnd_api.g_exc_unexpected_error THEN
190:
191: x_return_status := fnd_api.g_ret_sts_unexp_error;
192: x_msg_count := 1;
193: x_msg_data := SQLCODE || SQLERRM;

Line 191: x_return_status := fnd_api.g_ret_sts_unexp_error;

187: x_msg_count := 1;
188: x_msg_data := SQLCODE || SQLERRM;
189: WHEN fnd_api.g_exc_unexpected_error THEN
190:
191: x_return_status := fnd_api.g_ret_sts_unexp_error;
192: x_msg_count := 1;
193: x_msg_data := SQLCODE || SQLERRM;
194: WHEN OTHERS THEN
195: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 195: x_return_status := fnd_api.g_ret_sts_unexp_error;

191: x_return_status := fnd_api.g_ret_sts_unexp_error;
192: x_msg_count := 1;
193: x_msg_data := SQLCODE || SQLERRM;
194: WHEN OTHERS THEN
195: x_return_status := fnd_api.g_ret_sts_unexp_error;
196:
197: x_msg_count := 1;
198: x_msg_data := SQLCODE || SQLERRM;
199: END create_pos_tax_report_bo_row;