106: END IF;
107:
108: -- Standard call to get message count and if count is 1,
109: -- get message info.
110: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
111: EXCEPTION
112: WHEN fnd_api.g_exc_error THEN
113: ROLLBACK TO concurrent_bulk_process;
114: l_return_status := fnd_api.g_ret_sts_error;
111: EXCEPTION
112: WHEN fnd_api.g_exc_error THEN
113: ROLLBACK TO concurrent_bulk_process;
114: l_return_status := fnd_api.g_ret_sts_error;
115: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
116: WHEN fnd_api.g_exc_unexpected_error THEN
117: ROLLBACK TO concurrent_bulk_process;
118: l_return_status := fnd_api.g_ret_sts_unexp_error;
119: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
115: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
116: WHEN fnd_api.g_exc_unexpected_error THEN
117: ROLLBACK TO concurrent_bulk_process;
118: l_return_status := fnd_api.g_ret_sts_unexp_error;
119: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
120: WHEN OTHERS THEN
121: ROLLBACK TO concurrent_bulk_process;
122: l_return_status := fnd_api.g_ret_sts_unexp_error;
123:
120: WHEN OTHERS THEN
121: ROLLBACK TO concurrent_bulk_process;
122: l_return_status := fnd_api.g_ret_sts_unexp_error;
123:
124: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
125: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
126: END IF;
127:
128: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
121: ROLLBACK TO concurrent_bulk_process;
122: l_return_status := fnd_api.g_ret_sts_unexp_error;
123:
124: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
125: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
126: END IF;
127:
128: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
129:
124: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
125: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
126: END IF;
127:
128: fnd_msg_pub.count_and_get(p_count => l_msg_count, p_data => l_msg_data);
129:
130: END wms_concurrent_bulk_process;
131:
132: PROCEDURE split_child_mmtt(p_child_temp_id NUMBER,
2250:
2251: EXCEPTION
2252: WHEN OTHERS THEN
2253: x_return_status := fnd_api.g_ret_sts_unexp_error;
2254: fnd_msg_pub.count_and_get(p_count => x_msg_count, p_data => x_msg_data);
2255:
2256: IF (l_debug = 1) THEN
2257: mydebug('Unexpected Error occurred - ' || SQLERRM,l_api_name);
2258: END IF;