30: ,x_msg_data
31: ,p_lpo_id
32: );
33:
34: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
35: RAISE Fnd_Api.G_EXC_ERROR;
36: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
37: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
38: END IF;
31: ,p_lpo_id
32: );
33:
34: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
35: RAISE Fnd_Api.G_EXC_ERROR;
36: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
37: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
38: END IF;
39:
32: );
33:
34: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
35: RAISE Fnd_Api.G_EXC_ERROR;
36: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
37: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
38: END IF;
39:
40:
33:
34: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
35: RAISE Fnd_Api.G_EXC_ERROR;
36: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
37: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
38: END IF;
39:
40:
41:
43:
44: EXCEPTION
45: WHEN OTHERS THEN
46: -- ROLLBACK TO cnsld_ar_hdrs_insert;
47: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
48: x_msg_count := l_msg_count ;
49: x_msg_data := l_msg_data ;
50: Fnd_Msg_Pub.ADD_EXC_MSG('OKL_LPO_STRM_PUB','internal_to_external');
51: Fnd_Msg_Pub.count_and_get(