111: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
112:
113: WHEN OTHERS THEN
114: ROLLBACK TO sp_create_group_org;
115: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
116: fnd_message.set_token('P_SQLCODE',SQLCODE);
117: fnd_message.set_token('P_SQLERRM',SQLERRM);
118: fnd_message.set_token('P_API_NAME',g_pkg_name||'.'||l_api_name);
119: FND_MSG_PUB.add;
112:
113: WHEN OTHERS THEN
114: ROLLBACK TO sp_create_group_org;
115: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
116: fnd_message.set_token('P_SQLCODE',SQLCODE);
117: fnd_message.set_token('P_SQLERRM',SQLERRM);
118: fnd_message.set_token('P_API_NAME',g_pkg_name||'.'||l_api_name);
119: FND_MSG_PUB.add;
120: x_return_status := fnd_api.g_ret_sts_unexp_error;
113: WHEN OTHERS THEN
114: ROLLBACK TO sp_create_group_org;
115: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
116: fnd_message.set_token('P_SQLCODE',SQLCODE);
117: fnd_message.set_token('P_SQLERRM',SQLERRM);
118: fnd_message.set_token('P_API_NAME',g_pkg_name||'.'||l_api_name);
119: FND_MSG_PUB.add;
120: x_return_status := fnd_api.g_ret_sts_unexp_error;
121: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
114: ROLLBACK TO sp_create_group_org;
115: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
116: fnd_message.set_token('P_SQLCODE',SQLCODE);
117: fnd_message.set_token('P_SQLERRM',SQLERRM);
118: fnd_message.set_token('P_API_NAME',g_pkg_name||'.'||l_api_name);
119: FND_MSG_PUB.add;
120: x_return_status := fnd_api.g_ret_sts_unexp_error;
121: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
122:
217: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
218:
219: WHEN OTHERS THEN
220: ROLLBACK TO sp_update_group_org;
221: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
222: fnd_message.set_token('P_SQLCODE',SQLCODE);
223: fnd_message.set_token('P_SQLERRM',SQLERRM);
224: fnd_message.set_token('P_API_NAME',g_pkg_name||'.'||l_api_name);
225: FND_MSG_PUB.add;
218:
219: WHEN OTHERS THEN
220: ROLLBACK TO sp_update_group_org;
221: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
222: fnd_message.set_token('P_SQLCODE',SQLCODE);
223: fnd_message.set_token('P_SQLERRM',SQLERRM);
224: fnd_message.set_token('P_API_NAME',g_pkg_name||'.'||l_api_name);
225: FND_MSG_PUB.add;
226: x_return_status := fnd_api.g_ret_sts_unexp_error;
219: WHEN OTHERS THEN
220: ROLLBACK TO sp_update_group_org;
221: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
222: fnd_message.set_token('P_SQLCODE',SQLCODE);
223: fnd_message.set_token('P_SQLERRM',SQLERRM);
224: fnd_message.set_token('P_API_NAME',g_pkg_name||'.'||l_api_name);
225: FND_MSG_PUB.add;
226: x_return_status := fnd_api.g_ret_sts_unexp_error;
227: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
220: ROLLBACK TO sp_update_group_org;
221: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
222: fnd_message.set_token('P_SQLCODE',SQLCODE);
223: fnd_message.set_token('P_SQLERRM',SQLERRM);
224: fnd_message.set_token('P_API_NAME',g_pkg_name||'.'||l_api_name);
225: FND_MSG_PUB.add;
226: x_return_status := fnd_api.g_ret_sts_unexp_error;
227: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
228:
290: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
291:
292: WHEN OTHERS THEN
293: ROLLBACK TO sp_delete_group_org;
294: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
295: fnd_message.set_token('P_SQLCODE',SQLCODE);
296: fnd_message.set_token('P_SQLERRM',SQLERRM);
297: fnd_message.set_token('P_API_NAME',g_pkg_name||'.'||l_api_name);
298: FND_MSG_PUB.add;
291:
292: WHEN OTHERS THEN
293: ROLLBACK TO sp_delete_group_org;
294: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
295: fnd_message.set_token('P_SQLCODE',SQLCODE);
296: fnd_message.set_token('P_SQLERRM',SQLERRM);
297: fnd_message.set_token('P_API_NAME',g_pkg_name||'.'||l_api_name);
298: FND_MSG_PUB.add;
299: x_return_status := fnd_api.g_ret_sts_unexp_error;
292: WHEN OTHERS THEN
293: ROLLBACK TO sp_delete_group_org;
294: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
295: fnd_message.set_token('P_SQLCODE',SQLCODE);
296: fnd_message.set_token('P_SQLERRM',SQLERRM);
297: fnd_message.set_token('P_API_NAME',g_pkg_name||'.'||l_api_name);
298: FND_MSG_PUB.add;
299: x_return_status := fnd_api.g_ret_sts_unexp_error;
300: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
293: ROLLBACK TO sp_delete_group_org;
294: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
295: fnd_message.set_token('P_SQLCODE',SQLCODE);
296: fnd_message.set_token('P_SQLERRM',SQLERRM);
297: fnd_message.set_token('P_API_NAME',g_pkg_name||'.'||l_api_name);
298: FND_MSG_PUB.add;
299: x_return_status := fnd_api.g_ret_sts_unexp_error;
300: fnd_msg_pub.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
301: