85: -- notify caller of an UNEXPECTED error
86: x_return_status := FND_API.G_RET_STS_ERROR;
87:
88: -- store SQL error message on message stack for caller
89: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
90: p_count => x_msg_count,
91: p_data => x_msg_data);
92:
93: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
95: -- notify caller of an UNEXPECTED error
96: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
97:
98: -- store SQL error message on message stack for caller
99: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
100: p_count => x_msg_count,
101: p_data => x_msg_data);
102:
103: WHEN OTHERS THEN
102:
103: WHEN OTHERS THEN
104: -- notify caller of an UNEXPECTED error
105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
106: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPCGRPARAMETERS_PUB','insert_cgrparameters');
107:
108: -- store SQL error message on message stack for caller
109: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
110: p_count => x_msg_count,
105: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
106: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPCGRPARAMETERS_PUB','insert_cgrparameters');
107:
108: -- store SQL error message on message stack for caller
109: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
110: p_count => x_msg_count,
111: p_data => x_msg_data);
112: END insert_cgrparameters;
113:
160: -- notify caller of an UNEXPECTED error
161: x_return_status := FND_API.G_RET_STS_ERROR;
162:
163: -- store SQL error message on message stack for caller
164: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
165: p_count => x_msg_count,
166: p_data => x_msg_data);
167:
168: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
170: -- notify caller of an UNEXPECTED error
171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
172:
173: -- store SQL error message on message stack for caller
174: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
175: p_count => x_msg_count,
176: p_data => x_msg_data);
177:
178: WHEN OTHERS THEN
177:
178: WHEN OTHERS THEN
179: -- notify caller of an UNEXPECTED error
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
181: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPCGRPARAMETERS_PUB','update_cgrparameters');
182:
183: -- store SQL error message on message stack for caller
184: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
185: p_count => x_msg_count,
180: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
181: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPCGRPARAMETERS_PUB','update_cgrparameters');
182:
183: -- store SQL error message on message stack for caller
184: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
185: p_count => x_msg_count,
186: p_data => x_msg_data);
187: END update_cgrparameters;
188:
231: -- notify caller of an UNEXPECTED error
232: x_return_status := FND_API.G_RET_STS_ERROR;
233:
234: -- store SQL error message on message stack for caller
235: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
236: p_count => x_msg_count,
237: p_data => x_msg_data);
238:
239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
241: -- notify caller of an UNEXPECTED error
242: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
243:
244: -- store SQL error message on message stack for caller
245: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
246: p_count => x_msg_count,
247: p_data => x_msg_data);
248:
249: WHEN OTHERS THEN
248:
249: WHEN OTHERS THEN
250: -- notify caller of an UNEXPECTED error
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPCGRPARAMETERS_PUB','delete_cgrparameters');
253:
254: -- store SQL error message on message stack for caller
255: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
256: p_count => x_msg_count,
251: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
252: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPCGRPARAMETERS_PUB','delete_cgrparameters');
253:
254: -- store SQL error message on message stack for caller
255: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
256: p_count => x_msg_count,
257: p_data => x_msg_data);
258: END delete_cgrparameters;
259:
303: -- notify caller of an UNEXPECTED error
304: x_return_status := FND_API.G_RET_STS_ERROR;
305:
306: -- store SQL error message on message stack for caller
307: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
308: p_count => x_msg_count,
309: p_data => x_msg_data);
310:
311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
313: -- notify caller of an UNEXPECTED error
314: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
315:
316: -- store SQL error message on message stack for caller
317: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
318: p_count => x_msg_count,
319: p_data => x_msg_data);
320:
321: WHEN OTHERS THEN
320:
321: WHEN OTHERS THEN
322: -- notify caller of an UNEXPECTED error
323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
324: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPCGRPARAMETERS_PUB','insert_cgrparameters');
325:
326: -- store SQL error message on message stack for caller
327: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
328: p_count => x_msg_count,
323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
324: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPCGRPARAMETERS_PUB','insert_cgrparameters');
325:
326: -- store SQL error message on message stack for caller
327: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
328: p_count => x_msg_count,
329: p_data => x_msg_data);
330: END insert_cgrparameters;
331:
377: -- notify caller of an UNEXPECTED error
378: x_return_status := FND_API.G_RET_STS_ERROR;
379:
380: -- store SQL error message on message stack for caller
381: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
382: p_count => x_msg_count,
383: p_data => x_msg_data);
384:
385: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
387: -- notify caller of an UNEXPECTED error
388: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
389:
390: -- store SQL error message on message stack for caller
391: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
392: p_count => x_msg_count,
393: p_data => x_msg_data);
394:
395: WHEN OTHERS THEN
394:
395: WHEN OTHERS THEN
396: -- notify caller of an UNEXPECTED error
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
398: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPCGRPARAMETERS_PUB','update_cgrparameters');
399:
400: -- store SQL error message on message stack for caller
401: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
402: p_count => x_msg_count,
397: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
398: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPCGRPARAMETERS_PUB','update_cgrparameters');
399:
400: -- store SQL error message on message stack for caller
401: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
402: p_count => x_msg_count,
403: p_data => x_msg_data);
404: END update_cgrparameters;
405: -- rirawat 03-Feb-05 4149748: Added the following procedure to update into OKL_CNTX_GRP_PRMTRS_V - TBL : end