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);
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);
116:
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 (
124: p_encoded => Okc_Api.G_FALSE,
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 (
124: p_encoded => Okc_Api.G_FALSE,
125: p_count => x_msg_count,
126: p_data => x_msg_data);
127:
184: BEGIN
185:
186: IF (l_count > 0 ) THEN
187: FOR i IN 1..l_count LOOP
188: fnd_msg_pub.get (p_msg_index => i,
189: p_encoded => 'F',
190: p_data => lx_msg_data,
191: p_msg_index_out => l_msg_index_out);
192: