68: l_stmt_num := 20;
69:
70: -- Initialize message list if p_init_msg_list is set to TRUE.
71: IF fnd_api.to_boolean(p_init_msg_list) THEN
72: fnd_msg_pub.initialize;
73: END IF;
74:
75: l_stmt_num := 30;
76:
288: EXCEPTION
289: WHEN fnd_api.g_exc_error THEN
290: ROLLBACK TO work_request_import_pvt;
291: x_return_status := fnd_api.g_ret_sts_error;
292: fnd_msg_pub.count_and_get(
293: p_encoded => fnd_api.g_false
294: ,p_count => x_msg_count
295: ,p_data => x_msg_data);
296: WHEN fnd_api.g_exc_unexpected_error THEN
295: ,p_data => x_msg_data);
296: WHEN fnd_api.g_exc_unexpected_error THEN
297: ROLLBACK TO work_request_import_pvt;
298: x_return_status := fnd_api.g_ret_sts_unexp_error;
299: fnd_msg_pub.count_and_get(
300: p_encoded => fnd_api.g_false
301: ,p_count => x_msg_count
302: ,p_data => x_msg_data);
303: WHEN OTHERS THEN
302: ,p_data => x_msg_data);
303: WHEN OTHERS THEN
304: ROLLBACK TO work_request_import_pvt;
305: x_return_status := fnd_api.g_ret_sts_unexp_error;
306: IF fnd_msg_pub.check_msg_level(
307: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
308: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
309: END IF;
310: fnd_msg_pub.count_and_get(
303: WHEN OTHERS THEN
304: ROLLBACK TO work_request_import_pvt;
305: x_return_status := fnd_api.g_ret_sts_unexp_error;
306: IF fnd_msg_pub.check_msg_level(
307: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
308: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
309: END IF;
310: fnd_msg_pub.count_and_get(
311: p_encoded => fnd_api.g_false
304: ROLLBACK TO work_request_import_pvt;
305: x_return_status := fnd_api.g_ret_sts_unexp_error;
306: IF fnd_msg_pub.check_msg_level(
307: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
308: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
309: END IF;
310: fnd_msg_pub.count_and_get(
311: p_encoded => fnd_api.g_false
312: ,p_count => x_msg_count
306: IF fnd_msg_pub.check_msg_level(
307: fnd_msg_pub.g_msg_lvl_unexp_error) THEN
308: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name||'('||l_stmt_num||')');
309: END IF;
310: fnd_msg_pub.count_and_get(
311: p_encoded => fnd_api.g_false
312: ,p_count => x_msg_count
313: ,p_data => x_msg_data);
314: