57: x_return_status := l_return_status ;
58: x_msg_count := l_msg_count ;
59: x_msg_data := l_msg_data ;
60:
61: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
62: RAISE Fnd_Api.G_EXC_ERROR;
63: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
64: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
65: END IF;
58: x_msg_count := l_msg_count ;
59: x_msg_data := l_msg_data ;
60:
61: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
62: RAISE Fnd_Api.G_EXC_ERROR;
63: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
64: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
65: END IF;
66:
59: x_msg_data := l_msg_data ;
60:
61: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
62: RAISE Fnd_Api.G_EXC_ERROR;
63: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
64: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
65: END IF;
66:
67:
60:
61: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
62: RAISE Fnd_Api.G_EXC_ERROR;
63: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
64: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
65: END IF;
66:
67:
68:
68:
69:
70: EXCEPTION
71:
72: WHEN Fnd_Api.G_EXC_ERROR THEN
73: ROLLBACK TO csh_allct_rules_delete_rec;
74: x_return_status := Fnd_Api.G_RET_STS_ERROR;
75: x_msg_count := l_msg_count ;
76: x_msg_data := l_msg_data ;
70: EXCEPTION
71:
72: WHEN Fnd_Api.G_EXC_ERROR THEN
73: ROLLBACK TO csh_allct_rules_delete_rec;
74: x_return_status := Fnd_Api.G_RET_STS_ERROR;
75: x_msg_count := l_msg_count ;
76: x_msg_data := l_msg_data ;
77: --Fnd_Msg_Pub.count_and_get(
78: -- p_count => x_msg_count
76: x_msg_data := l_msg_data ;
77: --Fnd_Msg_Pub.count_and_get(
78: -- p_count => x_msg_count
79: -- ,p_data => x_msg_data);
80: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
81: ROLLBACK TO csh_allct_rules_delete_rec;
82: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
83: x_msg_count := l_msg_count ;
84: x_msg_data := l_msg_data ;
78: -- p_count => x_msg_count
79: -- ,p_data => x_msg_data);
80: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
81: ROLLBACK TO csh_allct_rules_delete_rec;
82: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
83: x_msg_count := l_msg_count ;
84: x_msg_data := l_msg_data ;
85: --Fnd_Msg_Pub.count_and_get(
86: -- p_count => x_msg_count
86: -- p_count => x_msg_count
87: -- ,p_data => x_msg_data);
88: WHEN OTHERS THEN
89: ROLLBACK TO csh_allct_rules_delete_rec;
90: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
91: x_msg_count := l_msg_count ;
92: x_msg_data := l_msg_data ;
93: --Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CSH_ALLCT_RULES_PUB','delete_csh_allct_srchs');
94: --Fnd_Msg_Pub.count_and_get(
163: i := p_cahv_tbl.NEXT(i);
164: END LOOP;
165: END IF;
166:
167: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
168: RAISE Fnd_Api.G_EXC_ERROR;
169: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
170: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
171: END IF;
164: END LOOP;
165: END IF;
166:
167: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
168: RAISE Fnd_Api.G_EXC_ERROR;
169: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
170: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
171: END IF;
172:
165: END IF;
166:
167: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
168: RAISE Fnd_Api.G_EXC_ERROR;
169: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
170: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
171: END IF;
172:
173:
166:
167: IF ( l_return_status = Fnd_Api.G_RET_STS_ERROR ) THEN
168: RAISE Fnd_Api.G_EXC_ERROR;
169: ELSIF (l_return_status = Fnd_Api.G_RET_STS_UNEXP_ERROR ) THEN
170: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
171: END IF;
172:
173:
174:
175:
176:
177: EXCEPTION
178:
179: WHEN Fnd_Api.G_EXC_ERROR THEN
180: ROLLBACK TO csh_allct_rules_delete_tbl;
181: x_return_status := Fnd_Api.G_RET_STS_ERROR;
182: x_msg_count := l_msg_count ;
183: x_msg_data := l_msg_data ;
177: EXCEPTION
178:
179: WHEN Fnd_Api.G_EXC_ERROR THEN
180: ROLLBACK TO csh_allct_rules_delete_tbl;
181: x_return_status := Fnd_Api.G_RET_STS_ERROR;
182: x_msg_count := l_msg_count ;
183: x_msg_data := l_msg_data ;
184: --Fnd_Msg_Pub.count_and_get(
185: -- p_count => x_msg_count
183: x_msg_data := l_msg_data ;
184: --Fnd_Msg_Pub.count_and_get(
185: -- p_count => x_msg_count
186: -- ,p_data => x_msg_data);
187: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
188: ROLLBACK TO csh_allct_rules_delete_tbl;
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: -- p_count => x_msg_count
186: -- ,p_data => x_msg_data);
187: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
188: ROLLBACK TO csh_allct_rules_delete_tbl;
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: --Fnd_Msg_Pub.count_and_get(
193: -- p_count => x_msg_count
193: -- p_count => x_msg_count
194: -- ,p_data => x_msg_data);
195: WHEN OTHERS THEN
196: ROLLBACK TO csh_allct_rules_delete_tbl;
197: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
198: x_msg_count := l_msg_count ;
199: x_msg_data := l_msg_data ;
200: --Fnd_Msg_Pub.ADD_EXC_MSG('OKL_CSH_ALLCT_RULES_PUB','delete_csh_allct_srchs');
201: --Fnd_Msg_Pub.count_and_get(