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