28: ,x_msg_data
29: ,p_bpd_acc_rec
30: );
31:
32: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
33: RAISE Fnd_Api.G_EXC_ERROR;
34: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
35: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
36: END IF;
29: ,p_bpd_acc_rec
30: );
31:
32: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
33: RAISE Fnd_Api.G_EXC_ERROR;
34: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
35: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
36: END IF;
37:
30: );
31:
32: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
33: RAISE Fnd_Api.G_EXC_ERROR;
34: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
35: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
36: END IF;
37:
38: EXCEPTION
31:
32: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
33: RAISE Fnd_Api.G_EXC_ERROR;
34: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
35: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
36: END IF;
37:
38: EXCEPTION
39: WHEN OTHERS THEN
37:
38: EXCEPTION
39: WHEN OTHERS THEN
40: ROLLBACK TO create_acc_trans;
41: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
42: x_msg_count := l_msg_count ;
43: x_msg_data := l_msg_data ;
44: Fnd_Msg_Pub.ADD_EXC_MSG('Okl_Acc_Call_Pub','create_acc_trans');
45: Fnd_Msg_Pub.count_and_get(
75: ,x_msg_data
76: ,p_bpd_acc_tbl
77: );
78:
79: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
80: RAISE Fnd_Api.G_EXC_ERROR;
81: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
82: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
83: END IF;
76: ,p_bpd_acc_tbl
77: );
78:
79: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
80: RAISE Fnd_Api.G_EXC_ERROR;
81: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
82: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
83: END IF;
84:
77: );
78:
79: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
80: RAISE Fnd_Api.G_EXC_ERROR;
81: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
82: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
83: END IF;
84:
85: EXCEPTION
78:
79: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
80: RAISE Fnd_Api.G_EXC_ERROR;
81: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
82: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
83: END IF;
84:
85: EXCEPTION
86: WHEN OTHERS THEN
84:
85: EXCEPTION
86: WHEN OTHERS THEN
87: ROLLBACK TO create_acc_trans;
88: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
89: x_msg_count := l_msg_count ;
90: x_msg_data := l_msg_data ;
91: Fnd_Msg_Pub.ADD_EXC_MSG('Okl_Acc_Call_Pub','create_acc_trans');
92: Fnd_Msg_Pub.count_and_get(
131: ,x_ctxt_val_tbl
132: ,x_acc_gen_primary_key_tbl
133: );
134:
135: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
136: RAISE Fnd_Api.G_EXC_ERROR;
137: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
138: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
139: END IF;
132: ,x_acc_gen_primary_key_tbl
133: );
134:
135: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
136: RAISE Fnd_Api.G_EXC_ERROR;
137: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
138: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
139: END IF;
140:
133: );
134:
135: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
136: RAISE Fnd_Api.G_EXC_ERROR;
137: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
138: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
139: END IF;
140:
141: EXCEPTION
134:
135: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
136: RAISE Fnd_Api.G_EXC_ERROR;
137: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
138: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
139: END IF;
140:
141: EXCEPTION
142: WHEN OTHERS THEN
140:
141: EXCEPTION
142: WHEN OTHERS THEN
143: ROLLBACK TO create_acc_trans_new;
144: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
145: x_msg_count := l_msg_count ;
146: x_msg_data := l_msg_data ;
147: Fnd_Msg_Pub.ADD_EXC_MSG('Okl_Acc_Call_Pub','create_acc_trans_new');
148: Fnd_Msg_Pub.count_and_get(