40: ------------------------------------------------------------
41: -- Start processing
42: ------------------------------------------------------------
43:
44: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
45:
46: SAVEPOINT sp_bill_charges;
47:
48: l_name := p_name;
74: ,p_date_transmission => l_date_transmission
75: ,p_origin => l_origin
76: ,p_destination => l_destination);
77:
78: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
79: RAISE Fnd_Api.G_EXC_ERROR;
80: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
81: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
82: END IF;
75: ,p_origin => l_origin
76: ,p_destination => l_destination);
77:
78: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
79: RAISE Fnd_Api.G_EXC_ERROR;
80: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
81: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
82: END IF;
83:
76: ,p_destination => l_destination);
77:
78: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
79: RAISE Fnd_Api.G_EXC_ERROR;
80: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
81: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
82: END IF;
83:
84: ------------------------------------------------------------
77:
78: IF l_return_status = Fnd_Api.G_RET_STS_ERROR THEN
79: RAISE Fnd_Api.G_EXC_ERROR;
80: ELSIF l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR THEN
81: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
82: END IF;
83:
84: ------------------------------------------------------------
85: ------------------------------------------------------------
95: ------------------------------------------------------------
96: -- Exception handling
97: ------------------------------------------------------------
98:
99: WHEN Fnd_Api.G_EXC_ERROR THEN
100:
101: ROLLBACK TO sp_bill_charges;
102: x_return_status := Fnd_Api.G_RET_STS_ERROR;
103: Fnd_Msg_Pub.Count_and_get (
98:
99: WHEN Fnd_Api.G_EXC_ERROR THEN
100:
101: ROLLBACK TO sp_bill_charges;
102: x_return_status := Fnd_Api.G_RET_STS_ERROR;
103: Fnd_Msg_Pub.Count_and_get (
104: p_encoded => Okc_Api.G_FALSE,
105: p_count => x_msg_count,
106: p_data => x_msg_data);
104: p_encoded => Okc_Api.G_FALSE,
105: p_count => x_msg_count,
106: p_data => x_msg_data);
107:
108: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
109:
110: ROLLBACK TO sp_bill_charges;
111: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
112: Fnd_Msg_Pub.Count_and_get (
107:
108: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
109:
110: ROLLBACK TO sp_bill_charges;
111: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
112: Fnd_Msg_Pub.Count_and_get (
113: p_encoded => Okc_Api.G_FALSE,
114: p_count => x_msg_count,
115: p_data => x_msg_data);
115: p_data => x_msg_data);
116:
117: WHEN OTHERS THEN
118:
119: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
120: Fnd_Msg_Pub.ADD_EXC_MSG (
121: p_pkg_name => G_PKG_NAME,
122: p_procedure_name => l_api_name);
123: Fnd_Msg_Pub.Count_and_get (