61: WHEN fnd_api.g_exc_error
62: THEN
63: ROLLBACK TO create_sales_meth_task_pvt;
64: x_return_status := fnd_api.g_ret_sts_error;
65: fnd_msg_pub.count_and_get ( p_count => x_msg_count,
66: p_data => x_msg_data );
67: WHEN fnd_api.g_exc_unexpected_error
68: THEN
69: ROLLBACK TO create_sales_meth_task_pvt;
67: WHEN fnd_api.g_exc_unexpected_error
68: THEN
69: ROLLBACK TO create_sales_meth_task_pvt;
70: x_return_status := fnd_api.g_ret_sts_unexp_error;
71: fnd_msg_pub.count_and_get ( p_count => x_msg_count,
72: p_data => x_msg_data );
73: WHEN OTHERS
74: THEN
75: ROLLBACK TO create_sales_meth_task_pvt;
73: WHEN OTHERS
74: THEN
75: ROLLBACK TO create_sales_meth_task_pvt;
76: x_return_status := fnd_api.g_ret_sts_unexp_error;
77: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
78: THEN
79: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
80: END IF;
81: fnd_msg_pub.count_and_get ( p_count => x_msg_count,
75: ROLLBACK TO create_sales_meth_task_pvt;
76: x_return_status := fnd_api.g_ret_sts_unexp_error;
77: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
78: THEN
79: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
80: END IF;
81: fnd_msg_pub.count_and_get ( p_count => x_msg_count,
82: p_data => x_msg_data );
83: END CREATE_SALES_METH_TASK_MAP;
77: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
78: THEN
79: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
80: END IF;
81: fnd_msg_pub.count_and_get ( p_count => x_msg_count,
82: p_data => x_msg_data );
83: END CREATE_SALES_METH_TASK_MAP;
84: -------------------------------------------
85: -------------------------------------------
131: WHEN fnd_api.g_exc_error
132: THEN
133: ROLLBACK TO delete_sm_stage_map_pvt;
134: x_return_status := fnd_api.g_ret_sts_error;
135: fnd_msg_pub.count_and_get (
136: p_count => x_msg_count,
137: p_data => x_msg_data
138: );
139: WHEN fnd_api.g_exc_unexpected_error
139: WHEN fnd_api.g_exc_unexpected_error
140: THEN
141: ROLLBACK TO delete_sm_stage_map_pvt;
142: x_return_status := fnd_api.g_ret_sts_unexp_error;
143: fnd_msg_pub.count_and_get (
144: p_count => x_msg_count,
145: p_data => x_msg_data
146: );
147: WHEN OTHERS
147: WHEN OTHERS
148: THEN
149: ROLLBACK TO delete_sm_stage_map_pvt;
150: x_return_status := fnd_api.g_ret_sts_unexp_error;
151: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
152: THEN
153: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
154: END IF;
155: fnd_msg_pub.count_and_get (
149: ROLLBACK TO delete_sm_stage_map_pvt;
150: x_return_status := fnd_api.g_ret_sts_unexp_error;
151: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
152: THEN
153: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
154: END IF;
155: fnd_msg_pub.count_and_get (
156: p_count => x_msg_count,
157: p_data => x_msg_data
151: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
152: THEN
153: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
154: END IF;
155: fnd_msg_pub.count_and_get (
156: p_count => x_msg_count,
157: p_data => x_msg_data
158: );
159: END UPDATE_SALES_METH_TASK_MAP;
199: WHEN fnd_api.g_exc_error
200: THEN
201: ROLLBACK TO delete_sm_stage_map_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 delete_sm_stage_map_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
215: WHEN OTHERS
216: THEN
217: ROLLBACK TO delete_sm_stage_map_pvt;
218: x_return_status := fnd_api.g_ret_sts_unexp_error;
219: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
220: THEN
221: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
222: END IF;
223: fnd_msg_pub.count_and_get (
217: ROLLBACK TO delete_sm_stage_map_pvt;
218: x_return_status := fnd_api.g_ret_sts_unexp_error;
219: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
220: THEN
221: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
222: END IF;
223: fnd_msg_pub.count_and_get (
224: p_count => x_msg_count,
225: p_data => x_msg_data
219: IF fnd_msg_pub.check_msg_level (fnd_msg_pub.g_msg_lvl_unexp_error)
220: THEN
221: fnd_msg_pub.add_exc_msg (g_pkg_name, l_api_name);
222: END IF;
223: fnd_msg_pub.count_and_get (
224: p_count => x_msg_count,
225: p_data => x_msg_data
226: );
227: END DELETE_SALES_METH_TASK_MAP;