86: WHEN fnd_api.g_exc_error
87: THEN
88: ROLLBACK TO create_sales_methodology_pvt;
89: x_return_status := fnd_api.g_ret_sts_error;
90: fnd_msg_pub.count_and_get (
91: p_count => x_msg_count,
92: p_data => x_msg_data
93: );
94: WHEN fnd_api.g_exc_unexpected_error
94: WHEN fnd_api.g_exc_unexpected_error
95: THEN
96: ROLLBACK TO create_sales_methodology_pvt;
97: x_return_status := fnd_api.g_ret_sts_unexp_error;
98: fnd_msg_pub.count_and_get (
99: p_count => x_msg_count,
100: p_data => x_msg_data
101: );
102: WHEN OTHERS
103: THEN
104: ROLLBACK TO create_sales_methodology_pvt;
105: x_return_status := fnd_api.g_ret_sts_unexp_error;
106:
107: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
108: THEN
109: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
110: END IF;
111:
105: x_return_status := fnd_api.g_ret_sts_unexp_error;
106:
107: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
108: THEN
109: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
110: END IF;
111:
112: fnd_msg_pub.count_and_get (
113: p_count => x_msg_count,
108: THEN
109: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
110: END IF;
111:
112: fnd_msg_pub.count_and_get (
113: p_count => x_msg_count,
114: p_data => x_msg_data
115: );
116: END create_sales_methodology;
201: WHEN fnd_api.g_exc_error
202: THEN
203: ROLLBACK TO update_sales_methodology_pvt;
204: x_return_status := fnd_api.g_ret_sts_error;
205: fnd_msg_pub.count_and_get (
206: p_count => x_msg_count,
207: p_data => x_msg_data
208: );
209: WHEN fnd_api.g_exc_unexpected_error
209: WHEN fnd_api.g_exc_unexpected_error
210: THEN
211: ROLLBACK TO update_sales_methodology_pvt;
212: x_return_status := fnd_api.g_ret_sts_unexp_error;
213: fnd_msg_pub.count_and_get (
214: p_count => x_msg_count,
215: p_data => x_msg_data
216: );
217: WHEN OTHERS
218: THEN
219: ROLLBACK TO update_sales_methodology_pvt;
220: x_return_status := fnd_api.g_ret_sts_unexp_error;
221:
222: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
223: THEN
224: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
225: END IF;
226:
220: x_return_status := fnd_api.g_ret_sts_unexp_error;
221:
222: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
223: THEN
224: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
225: END IF;
226:
227: fnd_msg_pub.count_and_get (
228: p_count => x_msg_count,
223: THEN
224: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
225: END IF;
226:
227: fnd_msg_pub.count_and_get (
228: p_count => x_msg_count,
229: p_data => x_msg_data
230: );
231: END update_sales_methodology;
267: WHEN fnd_api.g_exc_error
268: THEN
269: ROLLBACK TO delete_sales_methodology_pvt;
270: x_return_status := fnd_api.g_ret_sts_error;
271: fnd_msg_pub.count_and_get (
272: p_count => x_msg_count,
273: p_data => x_msg_data
274: );
275: WHEN fnd_api.g_exc_unexpected_error
275: WHEN fnd_api.g_exc_unexpected_error
276: THEN
277: ROLLBACK TO delete_sales_methodology_pvt;
278: x_return_status := fnd_api.g_ret_sts_unexp_error;
279: fnd_msg_pub.count_and_get (
280: p_count => x_msg_count,
281: p_data => x_msg_data
282: );
283: WHEN OTHERS
284: THEN
285: ROLLBACK TO delete_sales_methodology_pvt;
286: x_return_status := fnd_api.g_ret_sts_unexp_error;
287:
288: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
289: THEN
290: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
291: END IF;
292:
286: x_return_status := fnd_api.g_ret_sts_unexp_error;
287:
288: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
289: THEN
290: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
291: END IF;
292:
293: fnd_msg_pub.count_and_get (
294: p_count => x_msg_count,
289: THEN
290: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
291: END IF;
292:
293: fnd_msg_pub.count_and_get (
294: p_count => x_msg_count,
295: p_data => x_msg_data
296: );
297: END delete_sales_methodology;
386: WHEN fnd_api.g_exc_error
387: THEN
388: ROLLBACK TO add_sales_stage_map_pvt;
389: x_return_status := fnd_api.g_ret_sts_error;
390: fnd_msg_pub.count_and_get (
391: p_count => x_msg_count,
392: p_data => x_msg_data
393: );
394: WHEN fnd_api.g_exc_unexpected_error
394: WHEN fnd_api.g_exc_unexpected_error
395: THEN
396: ROLLBACK TO add_sales_stage_map_pvt;
397: x_return_status := fnd_api.g_ret_sts_unexp_error;
398: fnd_msg_pub.count_and_get (
399: p_count => x_msg_count,
400: p_data => x_msg_data
401: );
402: WHEN OTHERS
403: THEN
404: ROLLBACK TO add_sales_stage_map_pvt;
405: x_return_status := fnd_api.g_ret_sts_unexp_error;
406:
407: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
408: THEN
409: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
410: END IF;
411:
405: x_return_status := fnd_api.g_ret_sts_unexp_error;
406:
407: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
408: THEN
409: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
410: END IF;
411:
412: fnd_msg_pub.count_and_get (
413: p_count => x_msg_count,
408: THEN
409: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
410: END IF;
411:
412: fnd_msg_pub.count_and_get (
413: p_count => x_msg_count,
414: p_data => x_msg_data
415: );
416: END add_sales_meth_stage_map;
455: WHEN fnd_api.g_exc_error
456: THEN
457: ROLLBACK TO delete_sm_stage_map_pvt;
458: x_return_status := fnd_api.g_ret_sts_error;
459: fnd_msg_pub.count_and_get (
460: p_count => x_msg_count,
461: p_data => x_msg_data
462: );
463: WHEN fnd_api.g_exc_unexpected_error
463: WHEN fnd_api.g_exc_unexpected_error
464: THEN
465: ROLLBACK TO delete_sm_stage_map_pvt;
466: x_return_status := fnd_api.g_ret_sts_unexp_error;
467: fnd_msg_pub.count_and_get (
468: p_count => x_msg_count,
469: p_data => x_msg_data
470: );
471: WHEN OTHERS
472: THEN
473: ROLLBACK TO delete_sm_stage_map_pvt;
474: x_return_status := fnd_api.g_ret_sts_unexp_error;
475:
476: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
477: THEN
478: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
479: END IF;
480:
474: x_return_status := fnd_api.g_ret_sts_unexp_error;
475:
476: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
477: THEN
478: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
479: END IF;
480:
481: fnd_msg_pub.count_and_get (
482: p_count => x_msg_count,
477: THEN
478: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
479: END IF;
480:
481: fnd_msg_pub.count_and_get (
482: p_count => x_msg_count,
483: p_data => x_msg_data
484: );
485: END delete_sales_meth_stage_map;