90: -- notify caller of an UNEXPECTED error
91: x_return_status := FND_API.G_RET_STS_ERROR;
92:
93: -- store SQL error message on message stack for caller
94: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
95: p_count => x_msg_count,
96: p_data => x_msg_data);
97:
98: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
100: -- notify caller of an UNEXPECTED error
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
102:
103: -- store SQL error message on message stack for caller
104: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
105: p_count => x_msg_count,
106: p_data => x_msg_data);
107:
108: WHEN OTHERS THEN
107:
108: WHEN OTHERS THEN
109: -- notify caller of an UNEXPECTED error
110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
111: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPDSFPARAMETERS_PUB','insert_dsfparameters');
112:
113: -- store SQL error message on message stack for caller
114: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
115: p_count => x_msg_count,
110: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
111: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPDSFPARAMETERS_PUB','insert_dsfparameters');
112:
113: -- store SQL error message on message stack for caller
114: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
115: p_count => x_msg_count,
116: p_data => x_msg_data);
117: END insert_dsfparameters;
118:
170: -- notify caller of an UNEXPECTED error
171: x_return_status := FND_API.G_RET_STS_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 FND_API.G_EXC_UNEXPECTED_ERROR THEN
180: -- notify caller of an UNEXPECTED error
181: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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:
188: WHEN OTHERS THEN
187:
188: WHEN OTHERS THEN
189: -- notify caller of an UNEXPECTED error
190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
191: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPDSFPARAMETERS_PUB','update_dsfparameters');
192:
193: -- store SQL error message on message stack for caller
194: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
195: p_count => x_msg_count,
190: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
191: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPDSFPARAMETERS_PUB','update_dsfparameters');
192:
193: -- store SQL error message on message stack for caller
194: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
195: p_count => x_msg_count,
196: p_data => x_msg_data);
197: END update_dsfparameters;
198:
241: -- notify caller of an UNEXPECTED error
242: x_return_status := FND_API.G_RET_STS_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 FND_API.G_EXC_UNEXPECTED_ERROR THEN
251: -- notify caller of an UNEXPECTED error
252: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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:
259: WHEN OTHERS THEN
258:
259: WHEN OTHERS THEN
260: -- notify caller of an UNEXPECTED error
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
262: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPDSFPARAMETERS_PUB','delete_dsfparameters');
263:
264: -- store SQL error message on message stack for caller
265: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
266: p_count => x_msg_count,
261: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
262: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPDSFPARAMETERS_PUB','delete_dsfparameters');
263:
264: -- store SQL error message on message stack for caller
265: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
266: p_count => x_msg_count,
267: p_data => x_msg_data);
268: END delete_dsfparameters;
269:
317: -- notify caller of an UNEXPECTED error
318: x_return_status := FND_API.G_RET_STS_ERROR;
319:
320: -- store SQL error message on message stack for caller
321: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
322: p_count => x_msg_count,
323: p_data => x_msg_data);
324:
325: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
327: -- notify caller of an UNEXPECTED error
328: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
329:
330: -- store SQL error message on message stack for caller
331: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
332: p_count => x_msg_count,
333: p_data => x_msg_data);
334:
335: WHEN OTHERS THEN
334:
335: WHEN OTHERS THEN
336: -- notify caller of an UNEXPECTED error
337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
338: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPDSFPARAMETERS_PUB','insert_dsfparameters');
339:
340: -- store SQL error message on message stack for caller
341: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
342: p_count => x_msg_count,
337: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
338: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPDSFPARAMETERS_PUB','insert_dsfparameters');
339:
340: -- store SQL error message on message stack for caller
341: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
342: p_count => x_msg_count,
343: p_data => x_msg_data);
344: END insert_dsfparameters;
345: -- rirawat 03-Feb-05 4149748: Added the following procedure to insert into OKL_FNCTN_PRMTRS_V - TBL : end
393: -- notify caller of an UNEXPECTED error
394: x_return_status := FND_API.G_RET_STS_ERROR;
395:
396: -- store SQL error message on message stack for caller
397: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
398: p_count => x_msg_count,
399: p_data => x_msg_data);
400:
401: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
403: -- notify caller of an UNEXPECTED error
404: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
405:
406: -- store SQL error message on message stack for caller
407: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
408: p_count => x_msg_count,
409: p_data => x_msg_data);
410:
411: WHEN OTHERS THEN
410:
411: WHEN OTHERS THEN
412: -- notify caller of an UNEXPECTED error
413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
414: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPDSFPARAMETERS_PUB','update_dsfparameters');
415:
416: -- store SQL error message on message stack for caller
417: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
418: p_count => x_msg_count,
413: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
414: FND_MSG_PUB.ADD_EXC_MSG('OKL_SETUPDSFPARAMETERS_PUB','update_dsfparameters');
415:
416: -- store SQL error message on message stack for caller
417: FND_MSG_PUB.Count_and_get(p_encoded => OKC_API.G_FALSE,
418: p_count => x_msg_count,
419: p_data => x_msg_data);
420: END update_dsfparameters;
421: