87: WHEN fnd_api.g_exc_error
88: THEN
89: ROLLBACK TO create_template_group_pvt;
90: x_return_status := fnd_api.g_ret_sts_error;
91: fnd_msg_pub.count_and_get (
92: p_count => x_msg_count,
93: p_data => x_msg_data
94: );
95: WHEN fnd_api.g_exc_unexpected_error
95: WHEN fnd_api.g_exc_unexpected_error
96: THEN
97: ROLLBACK TO create_template_group_pvt;
98: x_return_status := fnd_api.g_ret_sts_unexp_error;
99: fnd_msg_pub.count_and_get (
100: p_count => x_msg_count,
101: p_data => x_msg_data
102: );
103: WHEN OTHERS
104: THEN
105: ROLLBACK TO create_template_group_pvt;
106: x_return_status := fnd_api.g_ret_sts_unexp_error;
107:
108: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
109: THEN
110: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
111: END IF;
112:
106: x_return_status := fnd_api.g_ret_sts_unexp_error;
107:
108: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
109: THEN
110: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
111: END IF;
112:
113: fnd_msg_pub.count_and_get (
114: p_count => x_msg_count,
109: THEN
110: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
111: END IF;
112:
113: fnd_msg_pub.count_and_get (
114: p_count => x_msg_count,
115: p_data => x_msg_data
116: );
117: END create_task_template_group;
199: WHEN fnd_api.g_exc_error
200: THEN
201: ROLLBACK TO update_template_group_pvt;
202: x_return_status := fnd_api.g_ret_sts_error;
203: fnd_msg_pub.count_and_get (
204: p_count => x_msg_count,
205: p_data => x_msg_data
206: );
207: WHEN fnd_api.g_exc_unexpected_error
207: WHEN fnd_api.g_exc_unexpected_error
208: THEN
209: ROLLBACK TO update_template_group_pvt;
210: x_return_status := fnd_api.g_ret_sts_unexp_error;
211: fnd_msg_pub.count_and_get (
212: p_count => x_msg_count,
213: p_data => x_msg_data
214: );
215: WHEN OTHERS
216: THEN
217: ROLLBACK TO update_template_group_pvt;
218: x_return_status := fnd_api.g_ret_sts_unexp_error;
219:
220: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
221: THEN
222: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
223: END IF;
224:
218: x_return_status := fnd_api.g_ret_sts_unexp_error;
219:
220: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
221: THEN
222: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
223: END IF;
224:
225: fnd_msg_pub.count_and_get (
226: p_count => x_msg_count,
221: THEN
222: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
223: END IF;
224:
225: fnd_msg_pub.count_and_get (
226: p_count => x_msg_count,
227: p_data => x_msg_data
228: );
229: END update_task_template_group;
252: WHEN fnd_api.g_exc_error
253: THEN
254: ROLLBACK TO delete_template_group_pvt;
255: x_return_status := fnd_api.g_ret_sts_error;
256: fnd_msg_pub.count_and_get (
257: p_count => x_msg_count,
258: p_data => x_msg_data
259: );
260: WHEN fnd_api.g_exc_unexpected_error
260: WHEN fnd_api.g_exc_unexpected_error
261: THEN
262: ROLLBACK TO delete_template_group_pvt;
263: x_return_status := fnd_api.g_ret_sts_unexp_error;
264: fnd_msg_pub.count_and_get (
265: p_count => x_msg_count,
266: p_data => x_msg_data
267: );
268: WHEN OTHERS
269: THEN
270: ROLLBACK TO delete_template_group_pvt;
271: x_return_status := fnd_api.g_ret_sts_unexp_error;
272:
273: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
274: THEN
275: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
276: END IF;
277:
271: x_return_status := fnd_api.g_ret_sts_unexp_error;
272:
273: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
274: THEN
275: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
276: END IF;
277:
278: fnd_msg_pub.count_and_get (
279: p_count => x_msg_count,
274: THEN
275: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
276: END IF;
277:
278: fnd_msg_pub.count_and_get (
279: p_count => x_msg_count,
280: p_data => x_msg_data
281: );
282: END delete_task_template_group;
626: EXCEPTION
627: WHEN fnd_api.g_exc_error
628: THEN
629: x_return_status := fnd_api.g_ret_sts_error;
630: fnd_msg_pub.count_and_get (
631: p_count => x_msg_count,
632: p_data => x_msg_data
633: );
634: WHEN fnd_api.g_exc_unexpected_error
633: );
634: WHEN fnd_api.g_exc_unexpected_error
635: THEN
636: x_return_status := fnd_api.g_ret_sts_unexp_error;
637: fnd_msg_pub.count_and_get (
638: p_count => x_msg_count,
639: p_data => x_msg_data
640: );
641: WHEN OTHERS
641: WHEN OTHERS
642: THEN
643: x_return_status := fnd_api.g_ret_sts_unexp_error;
644:
645: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
646: THEN
647: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
648: END IF;
649:
643: x_return_status := fnd_api.g_ret_sts_unexp_error;
644:
645: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
646: THEN
647: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
648: END IF;
649:
650: fnd_msg_pub.count_and_get (
651: p_count => x_msg_count,
646: THEN
647: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
648: END IF;
649:
650: fnd_msg_pub.count_and_get (
651: p_count => x_msg_count,
652: p_data => x_msg_data
653: );
654: END get_task_template_group;