27: END IF;
28:
29: EXCEPTION
30: WHEN FND_API.G_EXC_ERROR THEN
31: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
32: ,p_count => x_msg_count
33: ,p_data => x_msg_data);
34: x_return_status := FND_API.G_RET_STS_ERROR;
35:
33: ,p_data => x_msg_data);
34: x_return_status := FND_API.G_RET_STS_ERROR;
35:
36: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
37: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
38: ,p_count => x_msg_count
39: ,p_data => x_msg_data);
40: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
41:
39: ,p_data => x_msg_data);
40: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
41:
42: WHEN OTHERS THEN
43: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCRUAL_SEC_PUB','CREATE_STREAMS');
44: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
45: ,p_count => x_msg_count
46: ,p_data => x_msg_data);
47: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
40: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
41:
42: WHEN OTHERS THEN
43: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCRUAL_SEC_PUB','CREATE_STREAMS');
44: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
45: ,p_count => x_msg_count
46: ,p_data => x_msg_data);
47: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
48:
78: END IF;
79:
80: EXCEPTION
81: WHEN FND_API.G_EXC_ERROR THEN
82: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
83: ,p_count => x_msg_count
84: ,p_data => x_msg_data);
85: x_return_status := FND_API.G_RET_STS_ERROR;
86:
84: ,p_data => x_msg_data);
85: x_return_status := FND_API.G_RET_STS_ERROR;
86:
87: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
88: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
89: ,p_count => x_msg_count
90: ,p_data => x_msg_data);
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
92:
90: ,p_data => x_msg_data);
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
92:
93: WHEN OTHERS THEN
94: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCRUAL_SEC_PUB','CANCEL_STREAMS');
95: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
96: ,p_count => x_msg_count
97: ,p_data => x_msg_data);
98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
91: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
92:
93: WHEN OTHERS THEN
94: FND_MSG_PUB.ADD_EXC_MSG('OKL_ACCRUAL_SEC_PUB','CANCEL_STREAMS');
95: FND_MSG_PUB.Count_and_get(p_encoded => FND_API.G_FALSE
96: ,p_count => x_msg_count
97: ,p_data => x_msg_data);
98: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
99: