9:
10:
11: PROCEDURE calculate_cntgrp_bill_amt(
12: p_api_version IN NUMBER
13: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
14: ,x_return_status OUT NOCOPY VARCHAR2
15: ,x_msg_count OUT NOCOPY NUMBER
16: ,x_msg_data OUT NOCOPY VARCHAR2
17: ,p_cntr_bill_tbl IN cntr_bill_tbl_type
77:
78:
79: EXCEPTION
80:
81: WHEN Fnd_Api.G_EXC_ERROR THEN
82: ROLLBACK TO calculate_cntgrp_bill_amt_rec;
83: x_return_status := Fnd_Api.G_RET_STS_ERROR;
84: x_msg_count := l_msg_count ;
85: x_msg_data := l_msg_data ;
79: EXCEPTION
80:
81: WHEN Fnd_Api.G_EXC_ERROR THEN
82: ROLLBACK TO calculate_cntgrp_bill_amt_rec;
83: x_return_status := Fnd_Api.G_RET_STS_ERROR;
84: x_msg_count := l_msg_count ;
85: x_msg_data := l_msg_data ;
86: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
87: ROLLBACK TO calculate_cntgrp_bill_amt_rec;
82: ROLLBACK TO calculate_cntgrp_bill_amt_rec;
83: x_return_status := Fnd_Api.G_RET_STS_ERROR;
84: x_msg_count := l_msg_count ;
85: x_msg_data := l_msg_data ;
86: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
87: ROLLBACK TO calculate_cntgrp_bill_amt_rec;
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 ;
84: x_msg_count := l_msg_count ;
85: x_msg_data := l_msg_data ;
86: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
87: ROLLBACK TO calculate_cntgrp_bill_amt_rec;
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: WHEN OTHERS THEN
92: ROLLBACK TO calculate_cntgrp_bill_amt_rec;
89: x_msg_count := l_msg_count ;
90: x_msg_data := l_msg_data ;
91: WHEN OTHERS THEN
92: ROLLBACK TO calculate_cntgrp_bill_amt_rec;
93: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
94: x_msg_count := l_msg_count ;
95: x_msg_data := l_msg_data ;
96:
97:
98: END;
99:
100: PROCEDURE calculate_cntgrp_bill_amt(
101: p_api_version IN NUMBER
102: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
103: ,x_return_status OUT NOCOPY VARCHAR2
104: ,x_msg_count OUT NOCOPY NUMBER
105: ,x_msg_data OUT NOCOPY VARCHAR2
106: ,p_cntr_bill_rec IN cntr_bill_rec_type
110: END;
111:
112: PROCEDURE insert_cntr_grp_bill(
113: p_api_version IN NUMBER
114: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
115: ,x_return_status OUT NOCOPY VARCHAR2
116: ,x_msg_count OUT NOCOPY NUMBER
117: ,x_msg_data OUT NOCOPY VARCHAR2
118: ,p_cntr_bill_tbl IN cntr_bill_tbl_type
178:
179:
180: EXCEPTION
181:
182: WHEN Fnd_Api.G_EXC_ERROR THEN
183: ROLLBACK TO insert_cntr_grp_bill_rec;
184: x_return_status := Fnd_Api.G_RET_STS_ERROR;
185: x_msg_count := l_msg_count ;
186: x_msg_data := l_msg_data ;
180: EXCEPTION
181:
182: WHEN Fnd_Api.G_EXC_ERROR THEN
183: ROLLBACK TO insert_cntr_grp_bill_rec;
184: x_return_status := Fnd_Api.G_RET_STS_ERROR;
185: x_msg_count := l_msg_count ;
186: x_msg_data := l_msg_data ;
187: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
188: ROLLBACK TO insert_cntr_grp_bill_rec;
183: ROLLBACK TO insert_cntr_grp_bill_rec;
184: x_return_status := Fnd_Api.G_RET_STS_ERROR;
185: x_msg_count := l_msg_count ;
186: x_msg_data := l_msg_data ;
187: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
188: ROLLBACK TO insert_cntr_grp_bill_rec;
189: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
190: x_msg_count := l_msg_count ;
191: x_msg_data := l_msg_data ;
185: x_msg_count := l_msg_count ;
186: x_msg_data := l_msg_data ;
187: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
188: ROLLBACK TO insert_cntr_grp_bill_rec;
189: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
190: x_msg_count := l_msg_count ;
191: x_msg_data := l_msg_data ;
192: WHEN OTHERS THEN
193: ROLLBACK TO insert_cntr_grp_bill_rec;
190: x_msg_count := l_msg_count ;
191: x_msg_data := l_msg_data ;
192: WHEN OTHERS THEN
193: ROLLBACK TO insert_cntr_grp_bill_rec;
194: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
195: x_msg_count := l_msg_count ;
196: x_msg_data := l_msg_data ;
197:
198: END insert_cntr_grp_bill;
198: END insert_cntr_grp_bill;
199:
200: PROCEDURE insert_cntr_grp_bill(
201: p_api_version IN NUMBER
202: ,p_init_msg_list IN VARCHAR2 DEFAULT Fnd_Api.G_FALSE
203: ,x_return_status OUT NOCOPY VARCHAR2
204: ,x_msg_count OUT NOCOPY NUMBER
205: ,x_msg_data OUT NOCOPY VARCHAR2
206: ,p_cntr_bill_rec IN cntr_bill_rec_type