1: PACKAGE BODY OKL_CASH_FLOW_LEVELS_PUB AS
2: /* $Header: OKLPCFLB.pls 115.1 2004/04/13 10:35:22 rnaik noship $ */
3:
4: PROCEDURE insert_cash_flow_level(
5: p_api_version IN NUMBER,
87: ROLLBACK TO cash_flow_level_insert;
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: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_LEVELS_PUB','insert_cash_flow_level');
92: FND_MSG_PUB.count_and_get(
93: p_count => x_msg_count
94: ,p_data => x_msg_data);
95: END insert_cash_flow_level;
175: ROLLBACK TO cash_flow_level_insert;
176: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
177: x_msg_count := l_msg_count ;
178: x_msg_data := l_msg_data ;
179: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_LEVELS_PUB','insert_cash_flow_level');
180: FND_MSG_PUB.count_and_get(
181: p_count => x_msg_count
182: ,p_data => x_msg_data);
183: END insert_cash_flow_level;
217: p_count => x_msg_count
218: ,p_data => x_msg_data);
219: WHEN OTHERS THEN
220: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
221: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_LEVELS_PUB','lock_cash_flow_level');
222: FND_MSG_PUB.count_and_get(
223: p_count => x_msg_count
224: ,p_data => x_msg_data);
225: END lock_cash_flow_level;
260: p_count => x_msg_count
261: ,p_data => x_msg_data);
262: WHEN OTHERS THEN
263: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
264: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_LEVELS_PUB','lock_cash_flow_level');
265: FND_MSG_PUB.count_and_get(
266: p_count => x_msg_count
267: ,p_data => x_msg_data);
268: END lock_cash_flow_level;
352: ROLLBACK TO cash_flow_level_update;
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.ADD_EXC_MSG('OKL_CASH_FLOW_LEVELS_PUB','update_cash_flow_level');
357: FND_MSG_PUB.count_and_get(
358: p_count => x_msg_count
359: ,p_data => x_msg_data);
360: END update_cash_flow_level;
441: ROLLBACK TO cash_flow_level_update;
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443: x_msg_count := l_msg_count ;
444: x_msg_data := l_msg_data ;
445: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_LEVELS_PUB','update_cash_flow_level');
446: FND_MSG_PUB.count_and_get(
447: p_count => x_msg_count
448: ,p_data => x_msg_data);
449: END update_cash_flow_level;
527: ROLLBACK TO cash_flow_level_delete;
528: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
529: x_msg_count := l_msg_count ;
530: x_msg_data := l_msg_data ;
531: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_LEVELS_PUB','delete_cash_flow_level');
532: FND_MSG_PUB.count_and_get(
533: p_count => x_msg_count
534: ,p_data => x_msg_data);
535: END delete_cash_flow_level;
612: ROLLBACK TO cash_flow_level_delete;
613: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
614: x_msg_count := l_msg_count ;
615: x_msg_data := l_msg_data ;
616: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_LEVELS_PUB','delete_cash_flow_level');
617: FND_MSG_PUB.count_and_get(
618: p_count => x_msg_count
619: ,p_data => x_msg_data);
620: END delete_cash_flow_level;
704: ROLLBACK TO cash_flow_level_validate;
705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
706: x_msg_count := l_msg_count ;
707: x_msg_data := l_msg_data ;
708: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_LEVELS_PUB','validate_cash_flow_level');
709: FND_MSG_PUB.count_and_get(
710: p_count => x_msg_count
711: ,p_data => x_msg_data);
712: END validate_cash_flow_level;
790: ROLLBACK TO cash_flow_level_validate;
791: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
792: x_msg_count := l_msg_count ;
793: x_msg_data := l_msg_data ;
794: FND_MSG_PUB.ADD_EXC_MSG('OKL_CASH_FLOW_LEVELS_PUB','validate_cash_flow_level');
795: FND_MSG_PUB.count_and_get(
796: p_count => x_msg_count
797: ,p_data => x_msg_data);
798: END validate_cash_flow_level;
796: p_count => x_msg_count
797: ,p_data => x_msg_data);
798: END validate_cash_flow_level;
799:
800: END OKL_CASH_FLOW_LEVELS_PUB;