77: ROLLBACK TO save_create_purpose;
78: x_return_status := Fnd_Api.G_RET_STS_ERROR;
79: x_msg_count := l_msg_count ;
80: x_msg_data := l_msg_data ;
81: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count
82: ,p_data => x_msg_data);
83: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
84: ROLLBACK TO save_create_purpose;
85: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
84: ROLLBACK TO save_create_purpose;
85: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
86: x_msg_count := l_msg_count ;
87: x_msg_data := l_msg_data ;
88: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count
89: ,p_data => x_msg_data);
90: WHEN OTHERS THEN
91: ROLLBACK TO save_create_purpose;
92: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
91: ROLLBACK TO save_create_purpose;
92: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
93: x_msg_count := l_msg_count ;
94: x_msg_data := l_msg_data ;
95: Fnd_Msg_Pub.ADD_EXC_MSG('Okl_Bpd_Cap_Purpose_Pub','insert_row');
96: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count
97: ,p_data => x_msg_data);
98:
99: END create_purpose ;
92: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
93: x_msg_count := l_msg_count ;
94: x_msg_data := l_msg_data ;
95: Fnd_Msg_Pub.ADD_EXC_MSG('Okl_Bpd_Cap_Purpose_Pub','insert_row');
96: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count
97: ,p_data => x_msg_data);
98:
99: END create_purpose ;
100:
175: ROLLBACK TO save_update_purpose;
176: x_return_status := Fnd_Api.G_RET_STS_ERROR;
177: x_msg_count := l_msg_count ;
178: x_msg_data := l_msg_data ;
179: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count
180: ,p_data => x_msg_data);
181: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
182: ROLLBACK TO save_update_purpose;
183: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
182: ROLLBACK TO save_update_purpose;
183: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
184: x_msg_count := l_msg_count ;
185: x_msg_data := l_msg_data ;
186: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count
187: ,p_data => x_msg_data);
188: WHEN OTHERS THEN
189: ROLLBACK TO save_update_purpose;
190: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
189: ROLLBACK TO save_update_purpose;
190: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
191: x_msg_count := l_msg_count ;
192: x_msg_data := l_msg_data ;
193: Fnd_Msg_Pub.ADD_EXC_MSG('Okl_Bpd_Cap_Purpose_Pub','insert_row');
194: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count
195: ,p_data => x_msg_data);
196:
197: END update_purpose ;
190: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
191: x_msg_count := l_msg_count ;
192: x_msg_data := l_msg_data ;
193: Fnd_Msg_Pub.ADD_EXC_MSG('Okl_Bpd_Cap_Purpose_Pub','insert_row');
194: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count
195: ,p_data => x_msg_data);
196:
197: END update_purpose ;
198:
273: ROLLBACK TO save_delete_purpose;
274: x_return_status := Fnd_Api.G_RET_STS_ERROR;
275: x_msg_count := l_msg_count ;
276: x_msg_data := l_msg_data ;
277: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count
278: ,p_data => x_msg_data);
279: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
280: ROLLBACK TO save_delete_purpose;
281: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
280: ROLLBACK TO save_delete_purpose;
281: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
282: x_msg_count := l_msg_count ;
283: x_msg_data := l_msg_data ;
284: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count
285: ,p_data => x_msg_data);
286: WHEN OTHERS THEN
287: ROLLBACK TO save_delete_purpose;
288: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
287: ROLLBACK TO save_delete_purpose;
288: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
289: x_msg_count := l_msg_count ;
290: x_msg_data := l_msg_data ;
291: Fnd_Msg_Pub.ADD_EXC_MSG('Okl_Bpd_Cap_Purpose_Pub','insert_row');
292: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count
293: ,p_data => x_msg_data);
294:
295: END delete_purpose ;
288: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
289: x_msg_count := l_msg_count ;
290: x_msg_data := l_msg_data ;
291: Fnd_Msg_Pub.ADD_EXC_MSG('Okl_Bpd_Cap_Purpose_Pub','insert_row');
292: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count
293: ,p_data => x_msg_data);
294:
295: END delete_purpose ;
296: