96: -- notify caller of an UNEXPECTED error
97: x_return_status := FND_API.G_RET_STS_ERROR;
98:
99: -- store SQL error message on message stack for caller
100: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
101: p_count => x_msg_count,
102: p_data => x_msg_data);
103:
104: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
106: -- notify caller of an UNEXPECTED error
107: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
108:
109: -- store SQL error message on message stack for caller
110: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
111: p_count => x_msg_count,
112: p_data => x_msg_data);
113:
114: WHEN OTHERS THEN
113:
114: WHEN OTHERS THEN
115: -- notify caller of an UNEXPECTED error
116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
117: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPOVALUES_PUB','insert_povalues');
118:
119: -- store SQL error message on message stack for caller
120: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
121: p_count => x_msg_count,
116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
117: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPOVALUES_PUB','insert_povalues');
118:
119: -- store SQL error message on message stack for caller
120: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
121: p_count => x_msg_count,
122: p_data => x_msg_data);
123: END insert_povalues;
124:
174: -- notify caller of an UNEXPECTED error
175: x_return_status := FND_API.G_RET_STS_ERROR;
176:
177: -- store SQL error message on message stack for caller
178: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
179: p_count => x_msg_count,
180: p_data => x_msg_data);
181:
182: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
184: -- notify caller of an UNEXPECTED error
185: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
186:
187: -- store SQL error message on message stack for caller
188: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
189: p_count => x_msg_count,
190: p_data => x_msg_data);
191:
192: WHEN OTHERS THEN
191:
192: WHEN OTHERS THEN
193: -- notify caller of an UNEXPECTED error
194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
195: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPOVALUES_PUB','delete_povalues');
196:
197: -- store SQL error message on message stack for caller
198: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
199: p_count => x_msg_count,
194: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
195: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPOVALUES_PUB','delete_povalues');
196:
197: -- store SQL error message on message stack for caller
198: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
199: p_count => x_msg_count,
200: p_data => x_msg_data);
201: END delete_povalues;
202: