88: -- notify caller of an UNEXPECTED error
89: x_return_status := FND_API.G_RET_STS_ERROR;
90:
91: -- store SQL error message on message stack for caller
92: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
93: p_count => x_msg_count,
94: p_data => x_msg_data);
95:
96: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
98: -- notify caller of an UNEXPECTED error
99: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
100:
101: -- store SQL error message on message stack for caller
102: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
103: p_count => x_msg_count,
104: p_data => x_msg_data);
105:
106: WHEN OTHERS THEN
108: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
109: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPMVALUES_PUB','insert_pmvalues');
110:
111: -- store SQL error message on message stack for caller
112: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
113: p_count => x_msg_count,
114: p_data => x_msg_data);
115: END insert_pmvalues;
116:
164: -- notify caller of an UNEXPECTED error
165: x_return_status := FND_API.G_RET_STS_ERROR;
166:
167: -- store SQL error message on message stack for caller
168: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
169: p_count => x_msg_count,
170: p_data => x_msg_data);
171:
172: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
174: -- notify caller of an UNEXPECTED error
175: x_return_status := FND_API.G_RET_STS_UNEXP_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 OTHERS THEN
184: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
185: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPMVALUES_PUB','insert_pmvalues');
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: END insert_pmvalues;
192:
239: -- notify caller of an UNEXPECTED error
240: x_return_status := FND_API.G_RET_STS_ERROR;
241:
242: -- store SQL error message on message stack for caller
243: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
244: p_count => x_msg_count,
245: p_data => x_msg_data);
246:
247: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
249: -- notify caller of an UNEXPECTED error
250: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
251:
252: -- store SQL error message on message stack for caller
253: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
254: p_count => x_msg_count,
255: p_data => x_msg_data);
256:
257: WHEN OTHERS THEN
259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
260: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPPMVALUES_PUB','delete_pmvalues');
261:
262: -- store SQL error message on message stack for caller
263: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
264: p_count => x_msg_count,
265: p_data => x_msg_data);
266: END delete_pmvalues;
267: