[Home] [Help]
1: PACKAGE BODY OKL_SYSTEM_PARAMS_ALL_PUB AS
2: /* $Header: OKLPSYPB.pls 120.2 2006/07/31 06:20:00 akrangan noship $ */
3: -- Start of comments
4: --
5: -- Procedure Name : insert_system_parameters
51: ,p_data => x_msg_data);
52: WHEN OTHERS THEN
53: ROLLBACK TO insert_row_trx;
54: x_return_status := G_RET_STS_UNEXP_ERROR;
55: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','insert_system_parameters');
56: FND_MSG_PUB.count_and_get(
57: p_count => x_msg_count
58: ,p_data => x_msg_data);
59: END insert_system_parameters;
108: ,p_data => x_msg_data);
109: WHEN OTHERS THEN
110: ROLLBACK TO insert_row_trx;
111: x_return_status := G_RET_STS_UNEXP_ERROR;
112: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','insert_system_parameters');
113: FND_MSG_PUB.count_and_get(
114: p_count => x_msg_count
115: ,p_data => x_msg_data);
116: END insert_system_parameters;
163: ,p_data => x_msg_data);
164: WHEN OTHERS THEN
165: ROLLBACK TO lock_row_trx;
166: x_return_status := G_RET_STS_UNEXP_ERROR;
167: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','lock_system_parameters');
168: FND_MSG_PUB.count_and_get(
169: p_count => x_msg_count
170: ,p_data => x_msg_data);
171: END lock_system_parameters;
218: ,p_data => x_msg_data);
219: WHEN OTHERS THEN
220: ROLLBACK TO lock_row_trx;
221: x_return_status := G_RET_STS_UNEXP_ERROR;
222: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','lock_system_parameters');
223: FND_MSG_PUB.count_and_get(
224: p_count => x_msg_count
225: ,p_data => x_msg_data);
226: END lock_system_parameters;
275: ,p_data => x_msg_data);
276: WHEN OTHERS THEN
277: ROLLBACK TO update_row_trx;
278: x_return_status := G_RET_STS_UNEXP_ERROR;
279: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','update_system_parameters');
280: FND_MSG_PUB.count_and_get(
281: p_count => x_msg_count
282: ,p_data => x_msg_data);
283: END update_system_parameters;
332: ,p_data => x_msg_data);
333: WHEN OTHERS THEN
334: ROLLBACK TO update_row_trx;
335: x_return_status := G_RET_STS_UNEXP_ERROR;
336: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','update_system_parameters');
337: FND_MSG_PUB.count_and_get(
338: p_count => x_msg_count
339: ,p_data => x_msg_data);
340: END update_system_parameters;
387: ,p_data => x_msg_data);
388: WHEN OTHERS THEN
389: ROLLBACK TO delete_row_trx;
390: x_return_status := G_RET_STS_UNEXP_ERROR;
391: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','delete_system_parameters');
392: FND_MSG_PUB.count_and_get(
393: p_count => x_msg_count
394: ,p_data => x_msg_data);
395: END delete_system_parameters;
442: ,p_data => x_msg_data);
443: WHEN OTHERS THEN
444: ROLLBACK TO delete_row_trx;
445: x_return_status := G_RET_STS_UNEXP_ERROR;
446: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','delete_system_parameters');
447: FND_MSG_PUB.count_and_get(
448: p_count => x_msg_count
449: ,p_data => x_msg_data);
450: END delete_system_parameters;
497: ,p_data => x_msg_data);
498: WHEN OTHERS THEN
499: ROLLBACK TO validate_row_trx;
500: x_return_status := G_RET_STS_UNEXP_ERROR;
501: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','validate_system_parameters');
502: FND_MSG_PUB.count_and_get(
503: p_count => x_msg_count
504: ,p_data => x_msg_data);
505: END validate_system_parameters;
552: ,p_data => x_msg_data);
553: WHEN OTHERS THEN
554: ROLLBACK TO validate_row_trx;
555: x_return_status := G_RET_STS_UNEXP_ERROR;
556: FND_MSG_PUB.ADD_EXC_MSG('OKL_SYSTEM_PARAMS_ALL_PUB','validate_system_parameters');
557: FND_MSG_PUB.count_and_get(
558: p_count => x_msg_count
559: ,p_data => x_msg_data);
560: END validate_system_parameters;
597: END LOOP;
598: --returns the reqd the system value here
599: RETURN x_ret_value;
600: END get_system_param_value;
601: END OKL_SYSTEM_PARAMS_ALL_PUB;