29: BEGIN
30:
31: SAVEPOINT SEARCH_PERIOD_STATUS;
32:
33: x_return_status := FND_API.G_RET_STS_SUCCESS;
34:
35: -- customer pre-processing
36:
37:
66:
67:
68:
69: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
71: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
72: RAISE FND_API.G_EXC_ERROR;
73: END IF;
74:
68:
69: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
70: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
71: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
72: RAISE FND_API.G_EXC_ERROR;
73: END IF;
74:
75: l_period_tbl := x_period_tbl;
76:
79:
80:
81: EXCEPTION
82:
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
81: EXCEPTION
82:
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);
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
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
89: ,p_data => x_msg_data);
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:
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:
106:
107:
108: END SEARCH_PERIOD_STATUS;
130: BEGIN
131:
132: SAVEPOINT UPDATE_PERIOD_STATUS;
133:
134: x_return_status := FND_API.G_RET_STS_SUCCESS;
135:
136: -- customer pre-processing
137:
138:
164: -- End of wraper code generated automatically by Debug code generator for OKL_PERD_STATUS_PVT.UPDATE_PERIOD_STATUS
165:
166:
167: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
169: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
170: RAISE FND_API.G_EXC_ERROR;
171: END IF;
172:
166:
167: IF x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
168: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
169: ELSIF x_return_status = OKL_API.G_RET_STS_ERROR THEN
170: RAISE FND_API.G_EXC_ERROR;
171: END IF;
172:
173:
174:
175:
176:
177: EXCEPTION
178:
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
177: EXCEPTION
178:
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);
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
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
185: ,p_data => x_msg_data);
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:
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:
202:
203:
204: