263:
264: WHEN OTHERS
265: THEN
266: ROLLBACK TO create_mass_tasks;
267: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
268: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
269: x_return_status := fnd_api.g_ret_sts_unexp_error;
270: fnd_msg_pub.count_and_get (
271: p_count => x_msg_count,
264: WHEN OTHERS
265: THEN
266: ROLLBACK TO create_mass_tasks;
267: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
268: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
269: x_return_status := fnd_api.g_ret_sts_unexp_error;
270: fnd_msg_pub.count_and_get (
271: p_count => x_msg_count,
272: p_data => x_msg_data
332: -- Check if the resource_id exists
333: --
334: If l_resource_id is null then
335: x_return_status := fnd_api.g_ret_sts_unexp_error;
336: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OWNER_ID');
337: fnd_message.set_token ('P_OWNER_ID', p_resource_type_id);
338: fnd_msg_pub.add;
339: RAISE fnd_api.g_exc_unexpected_error;
340: end if;
333: --
334: If l_resource_id is null then
335: x_return_status := fnd_api.g_ret_sts_unexp_error;
336: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OWNER_ID');
337: fnd_message.set_token ('P_OWNER_ID', p_resource_type_id);
338: fnd_msg_pub.add;
339: RAISE fnd_api.g_exc_unexpected_error;
340: end if;
341:
365: END IF;
366:
367: WHEN OTHERS THEN
368: x_return_status := fnd_api.g_ret_sts_unexp_error;
369: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OWNER_ID');
370: fnd_message.set_token ('P_OWNER_ID', p_resource_type_id);
371: fnd_msg_pub.add;
372: RAISE fnd_api.g_exc_unexpected_error;
373:
366:
367: WHEN OTHERS THEN
368: x_return_status := fnd_api.g_ret_sts_unexp_error;
369: fnd_message.set_name ('JTF', 'JTF_TASK_INVALID_OWNER_ID');
370: fnd_message.set_token ('P_OWNER_ID', p_resource_type_id);
371: fnd_msg_pub.add;
372: RAISE fnd_api.g_exc_unexpected_error;
373:
374: End validate_resource;