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
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;
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:
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;
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:
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:
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
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;
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:
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;
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;
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;