1: PACKAGE BODY OKL_SIF_RET_STRMS_PUB AS
2: /* $Header: OKLPSRSB.pls 115.7 2004/04/13 11:21:02 rnaik noship $ */
3:
4: PROCEDURE add_language IS
5: BEGIN
64: ,p_count => x_msg_count
65: ,p_data => x_msg_data);
66:
67: WHEN OTHERS THEN
68: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RET_STRMS_PUB','insert_sif_ret_strms');
69: -- store SQL error message on message stack for caller
70: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
71: ,p_count => x_msg_count
72: ,p_data => x_msg_data);
155: ,p_count => x_msg_count
156: ,p_data => x_msg_data);
157:
158: WHEN OTHERS THEN
159: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RET_STRMS_PUB','insert_sif_ret_strms');
160: -- store SQL error message on message stack for caller
161: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
162: ,p_count => x_msg_count
163: ,p_data => x_msg_data);
213: ,p_count => x_msg_count
214: ,p_data => x_msg_data);
215:
216: WHEN OTHERS THEN
217: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RET_STRMS_PUB','lock_sif_ret_strms');
218: -- store SQL error message on message stack for caller
219: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
220: ,p_count => x_msg_count
221: ,p_data => x_msg_data);
293: ,p_count => x_msg_count
294: ,p_data => x_msg_data);
295:
296: WHEN OTHERS THEN
297: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RET_STRMS_PUB','lock_sif_ret_strms');
298: -- store SQL error message on message stack for caller
299: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
300: ,p_count => x_msg_count
301: ,p_data => x_msg_data);
358: ,p_count => x_msg_count
359: ,p_data => x_msg_data);
360:
361: WHEN OTHERS THEN
362: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RET_STRMS_PUB','update_sif_ret_strms');
363: -- store SQL error message on message stack for caller
364: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
365: ,p_count => x_msg_count
366: ,p_data => x_msg_data);
449: ,p_count => x_msg_count
450: ,p_data => x_msg_data);
451:
452: WHEN OTHERS THEN
453: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RET_STRMS_PUB','update_sif_ret_strms');
454: -- store SQL error message on message stack for caller
455: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
456: ,p_count => x_msg_count
457: ,p_data => x_msg_data);
513: ,p_count => x_msg_count
514: ,p_data => x_msg_data);
515:
516: WHEN OTHERS THEN
517: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RET_STRMS_PUB','delete_sif_ret_strms');
518: -- store SQL error message on message stack for caller
519: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
520: ,p_count => x_msg_count
521: ,p_data => x_msg_data);
604: ,p_count => x_msg_count
605: ,p_data => x_msg_data);
606:
607: WHEN OTHERS THEN
608: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RET_STRMS_PUB','delete_sif_ret_strms');
609: -- store SQL error message on message stack for caller
610: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
611: ,p_count => x_msg_count
612: ,p_data => x_msg_data);
668: ,p_count => x_msg_count
669: ,p_data => x_msg_data);
670:
671: WHEN OTHERS THEN
672: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RET_STRMS_PUB','validate_sif_ret_strms');
673: -- store SQL error message on message stack for caller
674: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
675: ,p_count => x_msg_count
676: ,p_data => x_msg_data);
760: ,p_count => x_msg_count
761: ,p_data => x_msg_data);
762:
763: WHEN OTHERS THEN
764: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RET_STRMS_PUB','validate_sif_ret_strms');
765: -- store SQL error message on message stack for caller
766: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
767: ,p_count => x_msg_count
768: ,p_data => x_msg_data);
834: ,p_count => x_msg_count
835: ,p_data => x_msg_data);
836:
837: WHEN OTHERS THEN
838: FND_MSG_PUB.ADD_EXC_MSG('OKL_SIF_RET_STRMS_PUB',
839: 'insert_sif_ret_strms_per');
840: -- store SQL error message on message stack for caller
841: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE
842: ,p_count => x_msg_count
865: l_srsv_tbl := p_srsv_tbl;
866: okl_srs_pvt.insert_row_upg(p_srsv_tbl => l_srsv_tbl);
867: END mass_insert_sif_ret;
868: --BAKUCHIB Bug#2807737 End
869: END OKL_SIF_RET_STRMS_PUB;