48: RAISE FND_API.g_exc_unexpected_error;
49: END IF;
50:
51: IF FND_API.to_boolean(p_init_msg_list) THEN
52: FND_MSG_PUB.initialize;
53: END IF;
54:
55: x_return_status := FND_API.g_ret_sts_success;
56:
136: ROLLBACK TO add_tpl_ctg_rec;
137: x_return_status := FND_API.g_ret_sts_unexp_error ;
138:
139: WHEN jtf_dspmgrvalidation_grp.category_req_exception THEN
140: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
141: THEN
142: x_return_status := FND_API.g_ret_sts_error;
143: FND_MESSAGE.set_name('JTF','JTF_DSP_CATEGORY_REQ');
144: FND_MSG_PUB.add;
140: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
141: THEN
142: x_return_status := FND_API.g_ret_sts_error;
143: FND_MESSAGE.set_name('JTF','JTF_DSP_CATEGORY_REQ');
144: FND_MSG_PUB.add;
145: END IF;
146:
147: WHEN jtf_dspmgrvalidation_grp.template_req_exception THEN
148: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
144: FND_MSG_PUB.add;
145: END IF;
146:
147: WHEN jtf_dspmgrvalidation_grp.template_req_exception THEN
148: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
149: THEN
150: x_return_status := FND_API.g_ret_sts_error;
151: FND_MESSAGE.set_name('JTF','JTF_DSP_TEMPLATE_REQ');
152: FND_MSG_PUB.add;
148: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
149: THEN
150: x_return_status := FND_API.g_ret_sts_error;
151: FND_MESSAGE.set_name('JTF','JTF_DSP_TEMPLATE_REQ');
152: FND_MSG_PUB.add;
153: END IF;
154:
155: WHEN OTHERS THEN
156: ROLLBACK TO add_tpl_ctg_rec;
155: WHEN OTHERS THEN
156: ROLLBACK TO add_tpl_ctg_rec;
157: x_return_status := FND_API.g_ret_sts_unexp_error ;
158:
159: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
160: THEN
161: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
162: END IF;
163: END add_tpl_ctg_rec;
157: x_return_status := FND_API.g_ret_sts_unexp_error ;
158:
159: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
160: THEN
161: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
162: END IF;
163: END add_tpl_ctg_rec;
164: -----------------------------------------------------------------------
165: -- NOTES
208: END IF;
209:
210:
211: IF FND_API.to_boolean(p_init_msg_list) THEN
212: FND_MSG_PUB.initialize;
213: END IF;
214:
215: x_return_status := FND_API.G_RET_STS_SUCCESS;
216:
242: IF FND_API.to_boolean(p_commit) THEN
243: COMMIT;
244: END IF;
245:
246: FND_MSG_PUB.count_and_get(
247: p_encoded => FND_API.g_false,
248: p_count => x_msg_count,
249: p_data => x_msg_data
250: );
253:
254: WHEN FND_API.g_exc_error THEN
255: ROLLBACK TO add_tpl_ctg;
256: x_return_status := FND_API.g_ret_sts_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: );
263:
264: WHEN FND_API.g_exc_unexpected_error THEN
265: ROLLBACK TO add_tpl_ctg;
266: x_return_status := FND_API.g_ret_sts_unexp_error ;
267: FND_MSG_PUB.count_and_get(
268: p_encoded => FND_API.g_false,
269: p_count => x_msg_count,
270: p_data => x_msg_data
271: );
270: p_data => x_msg_data
271: );
272:
273: WHEN jtf_dspmgrvalidation_grp.template_req_exception THEN
274: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
275: THEN
276: x_return_status := FND_API.g_ret_sts_error;
277: FND_MESSAGE.set_name('JTF','JTF_DSP_TEMPLATE_REQ');
278: FND_MSG_PUB.add;
274: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
275: THEN
276: x_return_status := FND_API.g_ret_sts_error;
277: FND_MESSAGE.set_name('JTF','JTF_DSP_TEMPLATE_REQ');
278: FND_MSG_PUB.add;
279: END IF;
280: FND_MSG_PUB.count_and_get(
281: p_encoded => FND_API.g_false,
282: p_count => x_msg_count,
276: x_return_status := FND_API.g_ret_sts_error;
277: FND_MESSAGE.set_name('JTF','JTF_DSP_TEMPLATE_REQ');
278: FND_MSG_PUB.add;
279: END IF;
280: FND_MSG_PUB.count_and_get(
281: p_encoded => FND_API.g_false,
282: p_count => x_msg_count,
283: p_data => x_msg_data
284: );
286: WHEN OTHERS THEN
287: ROLLBACK TO add_tpl_ctg;
288: x_return_status := FND_API.g_ret_sts_unexp_error ;
289:
290: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
291: THEN
292: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
293: END IF;
294:
288: x_return_status := FND_API.g_ret_sts_unexp_error ;
289:
290: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
291: THEN
292: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
293: END IF;
294:
295: FND_MSG_PUB.count_and_get(
296: p_encoded => FND_API.g_false,
291: THEN
292: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
293: END IF;
294:
295: FND_MSG_PUB.count_and_get(
296: p_encoded => FND_API.g_false,
297: p_count => x_msg_count,
298: p_data => x_msg_data
299: );
342: END IF;
343:
344:
345: IF FND_API.to_boolean(p_init_msg_list) THEN
346: FND_MSG_PUB.initialize;
347: END IF;
348:
349: x_return_status := FND_API.G_RET_STS_SUCCESS;
350:
385: IF FND_API.to_boolean(p_commit) THEN
386: COMMIT;
387: END IF;
388:
389: FND_MSG_PUB.count_and_get(
390: p_encoded => FND_API.g_false,
391: p_count => x_msg_count,
392: p_data => x_msg_data
393: );
396:
397: WHEN FND_API.g_exc_error THEN
398: ROLLBACK TO delete_tpl_ctg_relation;
399: x_return_status := FND_API.g_ret_sts_error;
400: FND_MSG_PUB.count_and_get(
401: p_encoded => FND_API.g_false,
402: p_count => x_msg_count,
403: p_data => x_msg_data
404: );
405:
406: WHEN FND_API.g_exc_unexpected_error THEN
407: ROLLBACK TO delete_tpl_ctg_relation;
408: x_return_status := FND_API.g_ret_sts_unexp_error ;
409: FND_MSG_PUB.count_and_get(
410: p_encoded => FND_API.g_false,
411: p_count => x_msg_count,
412: p_data => x_msg_data
413: );
416: WHEN OTHERS THEN
417: ROLLBACK TO delete_tpl_ctg_relation;
418: x_return_status := FND_API.g_ret_sts_unexp_error ;
419:
420: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
421: THEN
422: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
423: END IF;
424:
418: x_return_status := FND_API.g_ret_sts_unexp_error ;
419:
420: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
421: THEN
422: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
423: END IF;
424:
425: FND_MSG_PUB.count_and_get(
426: p_encoded => FND_API.g_false,
421: THEN
422: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
423: END IF;
424:
425: FND_MSG_PUB.count_and_get(
426: p_encoded => FND_API.g_false,
427: p_count => x_msg_count,
428: p_data => x_msg_data
429: );
474: END IF;
475:
476:
477: IF FND_API.to_boolean(p_init_msg_list) THEN
478: FND_MSG_PUB.initialize;
479: END IF;
480:
481:
482: x_return_status := FND_API.g_ret_sts_success;
511: IF FND_API.to_boolean(p_commit) THEN
512: COMMIT;
513: END IF;
514:
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: );
522:
523: WHEN FND_API.g_exc_error THEN
524: ROLLBACK TO add_ctg_tpl;
525: x_return_status := FND_API.g_ret_sts_error;
526: FND_MSG_PUB.count_and_get(
527: p_encoded => FND_API.g_false,
528: p_count => x_msg_count,
529: p_data => x_msg_data
530: );
531:
532: WHEN FND_API.g_exc_unexpected_error THEN
533: ROLLBACK TO add_ctg_tpl;
534: x_return_status := FND_API.g_ret_sts_unexp_error ;
535: FND_MSG_PUB.count_and_get(
536: p_encoded => FND_API.g_false,
537: p_count => x_msg_count,
538: p_data => x_msg_data
539: );
539: );
540:
541: WHEN jtf_dspmgrvalidation_grp.category_req_exception THEN
542: ROLLBACK TO add_ctg_tpl;
543: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
544: THEN
545: x_return_status := FND_API.g_ret_sts_error;
546: FND_MESSAGE.set_name('JTF','JTF_DSP_CATEGORY_REQ');
547: FND_MSG_PUB.add;
543: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
544: THEN
545: x_return_status := FND_API.g_ret_sts_error;
546: FND_MESSAGE.set_name('JTF','JTF_DSP_CATEGORY_REQ');
547: FND_MSG_PUB.add;
548: END IF;
549: FND_MSG_PUB.count_and_get(
550: p_encoded => FND_API.g_false,
551: p_count => x_msg_count,
545: x_return_status := FND_API.g_ret_sts_error;
546: FND_MESSAGE.set_name('JTF','JTF_DSP_CATEGORY_REQ');
547: FND_MSG_PUB.add;
548: END IF;
549: FND_MSG_PUB.count_and_get(
550: p_encoded => FND_API.g_false,
551: p_count => x_msg_count,
552: p_data => x_msg_data
553: );
555: WHEN OTHERS THEN
556: ROLLBACK TO add_ctg_tpl;
557: x_return_status := FND_API.g_ret_sts_unexp_error ;
558:
559: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
560: THEN
561: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
562: END IF;
563:
557: x_return_status := FND_API.g_ret_sts_unexp_error ;
558:
559: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
560: THEN
561: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
562: END IF;
563:
564: FND_MSG_PUB.count_and_get(
565: p_encoded => FND_API.g_false,
560: THEN
561: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
562: END IF;
563:
564: FND_MSG_PUB.count_and_get(
565: p_encoded => FND_API.g_false,
566: p_count => x_msg_count,
567: p_data => x_msg_data
568: );