32: ------------------------------------------------------------
33: -- Start processing
34: ------------------------------------------------------------
35:
36: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
37:
38: SAVEPOINT sp_bill_streams;
39:
40: l_contract_number := p_contract_number;
63: p_from_bill_date => l_from_bill_date,
64: p_to_bill_date => l_to_bill_date);
65:
66:
67: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
68: RAISE Fnd_Api.G_EXC_ERROR;
69: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
70: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
71: END IF;
64: p_to_bill_date => l_to_bill_date);
65:
66:
67: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
68: RAISE Fnd_Api.G_EXC_ERROR;
69: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
70: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
71: END IF;
72:
65:
66:
67: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
68: RAISE Fnd_Api.G_EXC_ERROR;
69: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
70: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
71: END IF;
72:
73: ------------------------------------------------------------
66:
67: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
68: RAISE Fnd_Api.G_EXC_ERROR;
69: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
70: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
71: END IF;
72:
73: ------------------------------------------------------------
74: ------------------------------------------------------------
84: ------------------------------------------------------------
85: -- Exception handling
86: ------------------------------------------------------------
87:
88: WHEN Fnd_Api.G_EXC_ERROR THEN
89:
90: ROLLBACK TO sp_bill_streams;
91: x_return_status := Fnd_Api.G_RET_STS_ERROR;
92: Fnd_Msg_Pub.Count_and_get (
87:
88: WHEN Fnd_Api.G_EXC_ERROR THEN
89:
90: ROLLBACK TO sp_bill_streams;
91: x_return_status := Fnd_Api.G_RET_STS_ERROR;
92: Fnd_Msg_Pub.Count_and_get (
93: p_encoded => Okc_Api.G_FALSE,
94: p_count => x_msg_count,
95: p_data => x_msg_data);
93: p_encoded => Okc_Api.G_FALSE,
94: p_count => x_msg_count,
95: p_data => x_msg_data);
96:
97: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
98:
99: ROLLBACK TO sp_bill_streams;
100: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
101: Fnd_Msg_Pub.Count_and_get (
96:
97: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
98:
99: ROLLBACK TO sp_bill_streams;
100: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
101: Fnd_Msg_Pub.Count_and_get (
102: p_encoded => Okc_Api.G_FALSE,
103: p_count => x_msg_count,
104: p_data => x_msg_data);
104: p_data => x_msg_data);
105:
106: WHEN OTHERS THEN
107:
108: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
109: Fnd_Msg_Pub.ADD_EXC_MSG (
110: p_pkg_name => G_PKG_NAME,
111: p_procedure_name => l_api_name);
112: Fnd_Msg_Pub.Count_and_get (