187: ROLLBACK TO create_purpose_PVT;
188: x_return_status := Fnd_Api.G_RET_STS_ERROR;
189: x_msg_count := l_msg_count ;
190: x_msg_data := l_msg_data ;
191: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count
192: ,p_data => x_msg_data);
193:
194:
195: WHEN OKC_API.G_EXCEPTION_ERROR THEN
196: ROLLBACK TO create_purpose_PVT;
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.count_and_get( p_count => x_msg_count
201: ,p_data => x_msg_data);
202:
203: WHEN OTHERS THEN
204: ROLLBACK TO create_purpose_PVT;
204: ROLLBACK TO create_purpose_PVT;
205: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
206: x_msg_count := l_msg_count ;
207: x_msg_data := l_msg_data ;
208: Fnd_Msg_Pub.ADD_EXC_MSG('Okl_Bpd_Cap_Purpose_Pvt','create_purpose');
209: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count
210: ,p_data => x_msg_data);
211:
212: END create_purpose;
205: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
206: x_msg_count := l_msg_count ;
207: x_msg_data := l_msg_data ;
208: Fnd_Msg_Pub.ADD_EXC_MSG('Okl_Bpd_Cap_Purpose_Pvt','create_purpose');
209: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count
210: ,p_data => x_msg_data);
211:
212: END create_purpose;
213: ---------------------------------------------------------------------------
343: ROLLBACK TO update_purpose_PVT;
344: x_return_status := Fnd_Api.G_RET_STS_ERROR;
345: x_msg_count := l_msg_count ;
346: x_msg_data := l_msg_data ;
347: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count
348: ,p_data => x_msg_data);
349:
350:
351: WHEN OKC_API.G_EXCEPTION_ERROR THEN
352: ROLLBACK TO update_purpose_PVT;
353: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
354: x_msg_count := l_msg_count ;
355: x_msg_data := l_msg_data ;
356: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count
357: ,p_data => x_msg_data);
358:
359: WHEN OTHERS THEN
360: ROLLBACK TO update_purpose_PVT;
360: ROLLBACK TO update_purpose_PVT;
361: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
362: x_msg_count := l_msg_count ;
363: x_msg_data := l_msg_data ;
364: Fnd_Msg_Pub.ADD_EXC_MSG('Okl_Bpd_Cap_Purpose_Pvt','create_purpose');
365: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count
366: ,p_data => x_msg_data);
367:
368: END update_purpose;
361: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
362: x_msg_count := l_msg_count ;
363: x_msg_data := l_msg_data ;
364: Fnd_Msg_Pub.ADD_EXC_MSG('Okl_Bpd_Cap_Purpose_Pvt','create_purpose');
365: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count
366: ,p_data => x_msg_data);
367:
368: END update_purpose;
369:
493: ROLLBACK TO delete_purpose_PVT;
494: x_return_status := Fnd_Api.G_RET_STS_ERROR;
495: x_msg_count := l_msg_count ;
496: x_msg_data := l_msg_data ;
497: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count
498: ,p_data => x_msg_data);
499:
500:
501: WHEN OKC_API.G_EXCEPTION_ERROR THEN
502: ROLLBACK TO delete_purpose_PVT;
503: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
504: x_msg_count := l_msg_count ;
505: x_msg_data := l_msg_data ;
506: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count
507: ,p_data => x_msg_data);
508:
509: WHEN OTHERS THEN
510: ROLLBACK TO delete_purpose_PVT;
510: ROLLBACK TO delete_purpose_PVT;
511: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
512: x_msg_count := l_msg_count ;
513: x_msg_data := l_msg_data ;
514: Fnd_Msg_Pub.ADD_EXC_MSG('Okl_Bpd_Cap_Purpose_Pvt','create_purpose');
515: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count
516: ,p_data => x_msg_data);
517:
518: END delete_purpose;
511: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
512: x_msg_count := l_msg_count ;
513: x_msg_data := l_msg_data ;
514: Fnd_Msg_Pub.ADD_EXC_MSG('Okl_Bpd_Cap_Purpose_Pvt','create_purpose');
515: Fnd_Msg_Pub.count_and_get( p_count => x_msg_count
516: ,p_data => x_msg_data);
517:
518: END delete_purpose;
519: END OKL_BPD_CAP_PURPOSE_PVT;