1: PACKAGE BODY okl_remarketing_costs_pub AS
2: /* $Header: OKLPRFCB.pls 120.3 2006/01/04 01:42:06 sgorantl noship $ */
3: G_CHK_ASSET_RETURN_FEE CONSTANT VARCHAR2(200) := 'OKL_CHK_ASSET_RETURN_FEE';
4:
5: PROCEDURE insert_remarketing_costs(
98: ROLLBACK TO remarketing_costs_insert;
99: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
100: x_msg_count := l_msg_count ;
101: x_msg_data := l_msg_data ;
102: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','insert_remarketing_costs');
103: FND_MSG_PUB.count_and_get(
104: p_count => x_msg_count
105: ,p_data => x_msg_data);
106: END insert_remarketing_costs;
196: ROLLBACK TO remarketing_costs_insert;
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_remarketing_COSTS_PUB','insert_remarketing_costs');
201: FND_MSG_PUB.count_and_get(
202: p_count => x_msg_count
203: ,p_data => x_msg_data);
204: END insert_remarketing_costs;
238: p_count => x_msg_count
239: ,p_data => x_msg_data);
240: WHEN OTHERS THEN
241: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
242: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','lock_remarketing_costs');
243: FND_MSG_PUB.count_and_get(
244: p_count => x_msg_count
245: ,p_data => x_msg_data);
246: END lock_remarketing_costs;
280: p_count => x_msg_count
281: ,p_data => x_msg_data);
282: WHEN OTHERS THEN
283: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
284: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','lock_remarketing_costs');
285: FND_MSG_PUB.count_and_get(
286: p_count => x_msg_count
287: ,p_data => x_msg_data);
288: END lock_remarketing_costs;
378: ROLLBACK TO remarketing_costs_update;
379: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
380: x_msg_count := l_msg_count ;
381: x_msg_data := l_msg_data ;
382: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','update_remarketing_costs');
383: FND_MSG_PUB.count_and_get(
384: p_count => x_msg_count
385: ,p_data => x_msg_data);
386: END update_remarketing_costs;
476: ROLLBACK TO remarketing_costs_update;
477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
478: x_msg_count := l_msg_count ;
479: x_msg_data := l_msg_data ;
480: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','update_remarketing_costs');
481: FND_MSG_PUB.count_and_get(
482: p_count => x_msg_count
483: ,p_data => x_msg_data);
484: END update_remarketing_costs;
562: ROLLBACK TO remarketing_costs_delete_rec;
563: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
564: x_msg_count := l_msg_count ;
565: x_msg_data := l_msg_data ;
566: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','delete_remarketing_costs');
567: FND_MSG_PUB.count_and_get(
568: p_count => x_msg_count
569: ,p_data => x_msg_data);
570: END delete_remarketing_costs;
659: ROLLBACK TO remarketing_costs_delete_tbl;
660: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
661: x_msg_count := l_msg_count ;
662: x_msg_data := l_msg_data ;
663: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','delete_remarketing_costs');
664: FND_MSG_PUB.count_and_get(
665: p_count => x_msg_count
666: ,p_data => x_msg_data);
667: END delete_remarketing_costs;
749: ROLLBACK TO remarketing_costs_validate;
750: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
751: x_msg_count := l_msg_count ;
752: x_msg_data := l_msg_data ;
753: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','validate_rmrkting_costs');
754: FND_MSG_PUB.count_and_get(
755: p_count => x_msg_count
756: ,p_data => x_msg_data);
757: END validate_rmrkting_costs;
834: ROLLBACK TO remarketing_costs_validate;
835: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
836: x_msg_count := l_msg_count ;
837: x_msg_data := l_msg_data ;
838: FND_MSG_PUB.ADD_EXC_MSG('OKL_remarketing_COSTS_PUB','validate_rmrkting_costs');
839: FND_MSG_PUB.count_and_get(
840: p_count => x_msg_count
841: ,p_data => x_msg_data);
842: END validate_rmrkting_costs;
840: p_count => x_msg_count
841: ,p_data => x_msg_data);
842: END validate_rmrkting_costs;
843:
844: END okl_remarketing_costs_pub;