37: , l_where_clause;
38:
39: IF c_object%NOTFOUND
40: THEN
41: fnd_message.set_name ('JTF', 'JTF_TASK_OBJECT_NOT_FOUND');
42: fnd_message.set_token ('OBJECT_NAME', p_object_code);
43: fnd_msg_pub.add;
44: RAISE fnd_api.g_exc_unexpected_error;
45: END IF;
38:
39: IF c_object%NOTFOUND
40: THEN
41: fnd_message.set_name ('JTF', 'JTF_TASK_OBJECT_NOT_FOUND');
42: fnd_message.set_token ('OBJECT_NAME', p_object_code);
43: fnd_msg_pub.add;
44: RAISE fnd_api.g_exc_unexpected_error;
45: END IF;
46:
90: IF c_object%ISOPEN
91: THEN
92: CLOSE c_object;
93: END IF;
94: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
95: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
96: fnd_msg_pub.add;
97: fnd_msg_pub.count_and_get (
98: p_count => x_msg_count
91: THEN
92: CLOSE c_object;
93: END IF;
94: fnd_message.set_name ('JTF', 'JTF_TASK_UNKNOWN_ERROR');
95: fnd_message.set_token ('P_TEXT', SQLCODE || SQLERRM);
96: fnd_msg_pub.add;
97: fnd_msg_pub.count_and_get (
98: p_count => x_msg_count
99: ,p_data => x_msg_data