83: WHEN FND_API.G_EXC_ERROR THEN
84: ROLLBACK TO SEARCH_PERIOD_STATUS;
85: x_return_status := FND_API.G_RET_STS_ERROR;
86:
87: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
88: ,p_count => x_msg_count
89: ,p_data => x_msg_data);
90:
91: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
90:
91: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
92: ROLLBACK TO SEARCH_PERIOD_STATUS;
93: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
94: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
95: ,p_count => x_msg_count
96: ,p_data => x_msg_data);
97:
98: WHEN OTHERS THEN
96: ,p_data => x_msg_data);
97:
98: WHEN OTHERS THEN
99:
100: FND_MSG_PUB.ADD_EXC_MSG('OKL_PERD_STATUS_PUB','SEARCH_PERIOD_STATUS');
101: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
102: ,p_count => x_msg_count
103: ,p_data => x_msg_data);
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
97:
98: WHEN OTHERS THEN
99:
100: FND_MSG_PUB.ADD_EXC_MSG('OKL_PERD_STATUS_PUB','SEARCH_PERIOD_STATUS');
101: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
102: ,p_count => x_msg_count
103: ,p_data => x_msg_data);
104: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
105:
179: WHEN FND_API.G_EXC_ERROR THEN
180: ROLLBACK TO UPDATE_PERIOD_STATUS;
181: x_return_status := FND_API.G_RET_STS_ERROR;
182:
183: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
184: ,p_count => x_msg_count
185: ,p_data => x_msg_data);
186:
187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
186:
187: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
188: ROLLBACK TO UPDATE_PERIOD_STATUS;
189: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
190: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
191: ,p_count => x_msg_count
192: ,p_data => x_msg_data);
193:
194: WHEN OTHERS THEN
192: ,p_data => x_msg_data);
193:
194: WHEN OTHERS THEN
195:
196: FND_MSG_PUB.ADD_EXC_MSG('OKL_PERD_STATUS_PUB','UPDATE_PERIOD_STATUS');
197: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
198: ,p_count => x_msg_count
199: ,p_data => x_msg_data);
200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
193:
194: WHEN OTHERS THEN
195:
196: FND_MSG_PUB.ADD_EXC_MSG('OKL_PERD_STATUS_PUB','UPDATE_PERIOD_STATUS');
197: FND_MSG_PUB.Count_and_get(p_encoded => OKL_API.G_FALSE
198: ,p_count => x_msg_count
199: ,p_data => x_msg_data);
200: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
201: