49: RAISE FND_API.g_exc_unexpected_error;
50: END IF;
51:
52: IF FND_API.to_boolean(p_init_msg_list) THEN
53: FND_MSG_PUB.initialize;
54: END IF;
55:
56: x_return_status := FND_API.g_ret_sts_success;
57:
127: ROLLBACK TO add_tpl_ctg_rec;
128: x_return_status := FND_API.g_ret_sts_unexp_error ;
129:
130: WHEN ibe_dspmgrvalidation_grp.category_req_exception THEN
131: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
132: THEN
133: x_return_status := FND_API.g_ret_sts_error;
134: FND_MESSAGE.set_name('IBE','IBE_DSP_CATEGORY_REQ');
135: FND_MSG_PUB.add;
131: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
132: THEN
133: x_return_status := FND_API.g_ret_sts_error;
134: FND_MESSAGE.set_name('IBE','IBE_DSP_CATEGORY_REQ');
135: FND_MSG_PUB.add;
136: END IF;
137:
138: WHEN ibe_dspmgrvalidation_grp.template_req_exception THEN
139: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
135: FND_MSG_PUB.add;
136: END IF;
137:
138: WHEN ibe_dspmgrvalidation_grp.template_req_exception THEN
139: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
140: THEN
141: x_return_status := FND_API.g_ret_sts_error;
142: FND_MESSAGE.set_name('IBE','IBE_DSP_TEMPLATE_REQ');
143: FND_MSG_PUB.add;
139: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
140: THEN
141: x_return_status := FND_API.g_ret_sts_error;
142: FND_MESSAGE.set_name('IBE','IBE_DSP_TEMPLATE_REQ');
143: FND_MSG_PUB.add;
144: END IF;
145:
146: WHEN OTHERS THEN
147: ROLLBACK TO add_tpl_ctg_rec;
146: WHEN OTHERS THEN
147: ROLLBACK TO add_tpl_ctg_rec;
148: x_return_status := FND_API.g_ret_sts_unexp_error ;
149:
150: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
151: THEN
152: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
153: END IF;
154: END add_tpl_ctg_rec;
148: x_return_status := FND_API.g_ret_sts_unexp_error ;
149:
150: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
151: THEN
152: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
153: END IF;
154: END add_tpl_ctg_rec;
155: -----------------------------------------------------------------------+
156: -- NOTES
195: END IF;
196:
197: IF FND_API.to_boolean(p_init_msg_list)
198: THEN
199: FND_MSG_PUB.initialize;
200: END IF;
201:
202: x_return_status := FND_API.G_RET_STS_SUCCESS;
203:
237: THEN
238: COMMIT;
239: END IF;
240:
241: FND_MSG_PUB.count_and_get(
242: p_encoded => FND_API.g_false,
243: p_count => x_msg_count,
244: p_data => x_msg_data );
245: EXCEPTION
245: EXCEPTION
246: WHEN FND_API.g_exc_error THEN
247: ROLLBACK TO add_tpl_ctg;
248: x_return_status := FND_API.g_ret_sts_error;
249: FND_MSG_PUB.count_and_get(
250: p_encoded => FND_API.g_false,
251: p_count => x_msg_count,
252: p_data => x_msg_data );
253:
253:
254: WHEN FND_API.g_exc_unexpected_error THEN
255: ROLLBACK TO add_tpl_ctg;
256: x_return_status := FND_API.g_ret_sts_unexp_error ;
257: FND_MSG_PUB.count_and_get(
258: p_encoded => FND_API.g_false,
259: p_count => x_msg_count,
260: p_data => x_msg_data );
261:
259: p_count => x_msg_count,
260: p_data => x_msg_data );
261:
262: WHEN ibe_dspmgrvalidation_grp.template_req_exception THEN
263: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
264: THEN
265: x_return_status := FND_API.g_ret_sts_error;
266: FND_MESSAGE.set_name('IBE','IBE_DSP_TEMPLATE_REQ');
267: FND_MSG_PUB.add;
263: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
264: THEN
265: x_return_status := FND_API.g_ret_sts_error;
266: FND_MESSAGE.set_name('IBE','IBE_DSP_TEMPLATE_REQ');
267: FND_MSG_PUB.add;
268: END IF;
269: FND_MSG_PUB.count_and_get(
270: p_encoded => FND_API.g_false,
271: p_count => x_msg_count,
265: x_return_status := FND_API.g_ret_sts_error;
266: FND_MESSAGE.set_name('IBE','IBE_DSP_TEMPLATE_REQ');
267: FND_MSG_PUB.add;
268: END IF;
269: FND_MSG_PUB.count_and_get(
270: p_encoded => FND_API.g_false,
271: p_count => x_msg_count,
272: p_data => x_msg_data );
273:
274: WHEN OTHERS THEN
275: ROLLBACK TO add_tpl_ctg;
276: x_return_status := FND_API.g_ret_sts_unexp_error ;
277:
278: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
279: THEN
280: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
281: END IF;
282:
276: x_return_status := FND_API.g_ret_sts_unexp_error ;
277:
278: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
279: THEN
280: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
281: END IF;
282:
283: FND_MSG_PUB.count_and_get(
284: p_encoded => FND_API.g_false,
279: THEN
280: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
281: END IF;
282:
283: FND_MSG_PUB.count_and_get(
284: p_encoded => FND_API.g_false,
285: p_count => x_msg_count,
286: p_data => x_msg_data );
287: END add_tpl_ctg;
325: END IF;
326:
327: IF FND_API.to_boolean(p_init_msg_list)
328: THEN
329: FND_MSG_PUB.initialize;
330: END IF;
331:
332: x_return_status := FND_API.G_RET_STS_SUCCESS;
333:
364: THEN
365: COMMIT;
366: END IF;
367:
368: FND_MSG_PUB.count_and_get(
369: p_encoded => FND_API.g_false,
370: p_count => x_msg_count,
371: p_data => x_msg_data );
372: EXCEPTION
372: EXCEPTION
373: WHEN FND_API.g_exc_error THEN
374: ROLLBACK TO delete_tpl_ctg_relation;
375: x_return_status := FND_API.g_ret_sts_error;
376: FND_MSG_PUB.count_and_get(
377: p_encoded => FND_API.g_false,
378: p_count => x_msg_count,
379: p_data => x_msg_data );
380:
380:
381: WHEN FND_API.g_exc_unexpected_error THEN
382: ROLLBACK TO delete_tpl_ctg_relation;
383: x_return_status := FND_API.g_ret_sts_unexp_error ;
384: FND_MSG_PUB.count_and_get(
385: p_encoded => FND_API.g_false,
386: p_count => x_msg_count,
387: p_data => x_msg_data );
388:
389: WHEN OTHERS THEN
390: ROLLBACK TO delete_tpl_ctg_relation;
391: x_return_status := FND_API.g_ret_sts_unexp_error ;
392:
393: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
394: THEN
395: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
396: END IF;
397:
391: x_return_status := FND_API.g_ret_sts_unexp_error ;
392:
393: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
394: THEN
395: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
396: END IF;
397:
398: FND_MSG_PUB.count_and_get(
399: p_encoded => FND_API.g_false,
394: THEN
395: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
396: END IF;
397:
398: FND_MSG_PUB.count_and_get(
399: p_encoded => FND_API.g_false,
400: p_count => x_msg_count,
401: p_data => x_msg_data );
402: END delete_tpl_ctg_relation;
441: END IF;
442:
443: IF FND_API.to_boolean(p_init_msg_list)
444: THEN
445: FND_MSG_PUB.initialize;
446: END IF;
447:
448: x_return_status := FND_API.g_ret_sts_success;
449:
482: THEN
483: COMMIT;
484: END IF;
485:
486: FND_MSG_PUB.count_and_get(
487: p_encoded => FND_API.g_false,
488: p_count => x_msg_count,
489: p_data => x_msg_data );
490: EXCEPTION
490: EXCEPTION
491: WHEN FND_API.g_exc_error THEN
492: ROLLBACK TO add_ctg_tpl;
493: x_return_status := FND_API.g_ret_sts_error;
494: FND_MSG_PUB.count_and_get(
495: p_encoded => FND_API.g_false,
496: p_count => x_msg_count,
497: p_data => x_msg_data );
498:
498:
499: WHEN FND_API.g_exc_unexpected_error THEN
500: ROLLBACK TO add_ctg_tpl;
501: x_return_status := FND_API.g_ret_sts_unexp_error ;
502: FND_MSG_PUB.count_and_get(
503: p_encoded => FND_API.g_false,
504: p_count => x_msg_count,
505: p_data => x_msg_data );
506:
505: p_data => x_msg_data );
506:
507: WHEN ibe_dspmgrvalidation_grp.category_req_exception THEN
508: ROLLBACK TO add_ctg_tpl;
509: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
510: THEN
511: x_return_status := FND_API.g_ret_sts_error;
512: FND_MESSAGE.set_name('IBE','IBE_DSP_CATEGORY_REQ');
513: FND_MSG_PUB.add;
509: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
510: THEN
511: x_return_status := FND_API.g_ret_sts_error;
512: FND_MESSAGE.set_name('IBE','IBE_DSP_CATEGORY_REQ');
513: FND_MSG_PUB.add;
514: END IF;
515: FND_MSG_PUB.count_and_get(
516: p_encoded => FND_API.g_false,
517: p_count => x_msg_count,
511: x_return_status := FND_API.g_ret_sts_error;
512: FND_MESSAGE.set_name('IBE','IBE_DSP_CATEGORY_REQ');
513: FND_MSG_PUB.add;
514: END IF;
515: FND_MSG_PUB.count_and_get(
516: p_encoded => FND_API.g_false,
517: p_count => x_msg_count,
518: p_data => x_msg_data );
519:
520: WHEN OTHERS THEN
521: ROLLBACK TO add_ctg_tpl;
522: x_return_status := FND_API.g_ret_sts_unexp_error ;
523:
524: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
525: THEN
526: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
527: END IF;
528:
522: x_return_status := FND_API.g_ret_sts_unexp_error ;
523:
524: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
525: THEN
526: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
527: END IF;
528:
529: FND_MSG_PUB.count_and_get(
530: p_encoded => FND_API.g_false,
525: THEN
526: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
527: END IF;
528:
529: FND_MSG_PUB.count_and_get(
530: p_encoded => FND_API.g_false,
531: p_count => x_msg_count,
532: p_data => x_msg_data );
533: END ADD_CTG_TPL;