79: IF l_group_name IS NULL THEN
80:
81: -- dbms_output.put_line('Group Name cannot be null');
82:
83: fnd_message.set_name('JTF', 'JTF_RS_GROUP_NAME_NULL');
84: fnd_msg_pub.add;
85: RAISE fnd_api.g_exc_error;
86:
87: END IF;
92: IF l_start_date_active IS NULL THEN
93:
94: -- dbms_output.put_line('Start Date Active cannot be null');
95:
96: fnd_message.set_name('JTF', 'JTF_RS_START_DATE_NULL');
97: fnd_msg_pub.add;
98:
99: RAISE fnd_api.g_exc_error;
100:
199: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
200: p_data => x_msg_data);
201: WHEN OTHERS THEN
202: ROLLBACK TO create_resource_group_pub;
203: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
204: fnd_message.set_token('P_SQLCODE',SQLCODE);
205: fnd_message.set_token('P_SQLERRM',SQLERRM);
206: fnd_message.set_token('P_API_NAME', l_api_name);
207: FND_MSG_PUB.add;
200: p_data => x_msg_data);
201: WHEN OTHERS THEN
202: ROLLBACK TO create_resource_group_pub;
203: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
204: fnd_message.set_token('P_SQLCODE',SQLCODE);
205: fnd_message.set_token('P_SQLERRM',SQLERRM);
206: fnd_message.set_token('P_API_NAME', l_api_name);
207: FND_MSG_PUB.add;
208: x_return_status := fnd_api.g_ret_sts_unexp_error;
201: WHEN OTHERS THEN
202: ROLLBACK TO create_resource_group_pub;
203: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
204: fnd_message.set_token('P_SQLCODE',SQLCODE);
205: fnd_message.set_token('P_SQLERRM',SQLERRM);
206: fnd_message.set_token('P_API_NAME', l_api_name);
207: FND_MSG_PUB.add;
208: x_return_status := fnd_api.g_ret_sts_unexp_error;
209: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
202: ROLLBACK TO create_resource_group_pub;
203: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
204: fnd_message.set_token('P_SQLCODE',SQLCODE);
205: fnd_message.set_token('P_SQLERRM',SQLERRM);
206: fnd_message.set_token('P_API_NAME', l_api_name);
207: FND_MSG_PUB.add;
208: x_return_status := fnd_api.g_ret_sts_unexp_error;
209: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
210: p_data => x_msg_data);
423: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
424: p_data => x_msg_data);
425: WHEN OTHERS THEN
426: ROLLBACK TO update_resource_group_pub;
427: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
428: fnd_message.set_token('P_SQLCODE',SQLCODE);
429: fnd_message.set_token('P_SQLERRM',SQLERRM);
430: fnd_message.set_token('P_API_NAME', l_api_name);
431: FND_MSG_PUB.add;
424: p_data => x_msg_data);
425: WHEN OTHERS THEN
426: ROLLBACK TO update_resource_group_pub;
427: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
428: fnd_message.set_token('P_SQLCODE',SQLCODE);
429: fnd_message.set_token('P_SQLERRM',SQLERRM);
430: fnd_message.set_token('P_API_NAME', l_api_name);
431: FND_MSG_PUB.add;
432: x_return_status := fnd_api.g_ret_sts_unexp_error;
425: WHEN OTHERS THEN
426: ROLLBACK TO update_resource_group_pub;
427: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
428: fnd_message.set_token('P_SQLCODE',SQLCODE);
429: fnd_message.set_token('P_SQLERRM',SQLERRM);
430: fnd_message.set_token('P_API_NAME', l_api_name);
431: FND_MSG_PUB.add;
432: x_return_status := fnd_api.g_ret_sts_unexp_error;
433: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
426: ROLLBACK TO update_resource_group_pub;
427: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
428: fnd_message.set_token('P_SQLCODE',SQLCODE);
429: fnd_message.set_token('P_SQLERRM',SQLERRM);
430: fnd_message.set_token('P_API_NAME', l_api_name);
431: FND_MSG_PUB.add;
432: x_return_status := fnd_api.g_ret_sts_unexp_error;
433: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
434: p_data => x_msg_data);