136: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
137: WHEN OTHERS
138: THEN
139: ROLLBACK TO ROLE_RELATE_SP;
140: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
141: fnd_message.set_token('P_SQLCODE',SQLCODE);
142: fnd_message.set_token('P_SQLERRM',SQLERRM);
143: fnd_message.set_token('P_API_NAME', l_api_name);
144: FND_MSG_PUB.add;
137: WHEN OTHERS
138: THEN
139: ROLLBACK TO ROLE_RELATE_SP;
140: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
141: fnd_message.set_token('P_SQLCODE',SQLCODE);
142: fnd_message.set_token('P_SQLERRM',SQLERRM);
143: fnd_message.set_token('P_API_NAME', l_api_name);
144: FND_MSG_PUB.add;
145: x_return_status := fnd_api.g_ret_sts_unexp_error;
138: THEN
139: ROLLBACK TO ROLE_RELATE_SP;
140: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
141: fnd_message.set_token('P_SQLCODE',SQLCODE);
142: fnd_message.set_token('P_SQLERRM',SQLERRM);
143: fnd_message.set_token('P_API_NAME', l_api_name);
144: FND_MSG_PUB.add;
145: x_return_status := fnd_api.g_ret_sts_unexp_error;
146: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
139: ROLLBACK TO ROLE_RELATE_SP;
140: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
141: fnd_message.set_token('P_SQLCODE',SQLCODE);
142: fnd_message.set_token('P_SQLERRM',SQLERRM);
143: fnd_message.set_token('P_API_NAME', l_api_name);
144: FND_MSG_PUB.add;
145: x_return_status := fnd_api.g_ret_sts_unexp_error;
146: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
147:
273: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
274: WHEN OTHERS
275: THEN
276: ROLLBACK TO TABLE_ATTRIBUTE_SP;
277: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
278: fnd_message.set_token('P_SQLCODE',SQLCODE);
279: fnd_message.set_token('P_SQLERRM',SQLERRM);
280: fnd_message.set_token('P_API_NAME',l_api_name);
281: FND_MSG_PUB.add;
274: WHEN OTHERS
275: THEN
276: ROLLBACK TO TABLE_ATTRIBUTE_SP;
277: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
278: fnd_message.set_token('P_SQLCODE',SQLCODE);
279: fnd_message.set_token('P_SQLERRM',SQLERRM);
280: fnd_message.set_token('P_API_NAME',l_api_name);
281: FND_MSG_PUB.add;
282: x_return_status := fnd_api.g_ret_sts_unexp_error;
275: THEN
276: ROLLBACK TO TABLE_ATTRIBUTE_SP;
277: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
278: fnd_message.set_token('P_SQLCODE',SQLCODE);
279: fnd_message.set_token('P_SQLERRM',SQLERRM);
280: fnd_message.set_token('P_API_NAME',l_api_name);
281: FND_MSG_PUB.add;
282: x_return_status := fnd_api.g_ret_sts_unexp_error;
283: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
276: ROLLBACK TO TABLE_ATTRIBUTE_SP;
277: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
278: fnd_message.set_token('P_SQLCODE',SQLCODE);
279: fnd_message.set_token('P_SQLERRM',SQLERRM);
280: fnd_message.set_token('P_API_NAME',l_api_name);
281: FND_MSG_PUB.add;
282: x_return_status := fnd_api.g_ret_sts_unexp_error;
283: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
284: END update_table_attribute;
364: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
365: WHEN OTHERS
366: THEN
367: ROLLBACK TO TABLE_ATTRIBUTE_SP;
368: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
369: fnd_message.set_token('P_SQLCODE',SQLCODE);
370: fnd_message.set_token('P_SQLERRM',SQLERRM);
371: fnd_message.set_token('P_API_NAME',l_api_name);
372: FND_MSG_PUB.add;
365: WHEN OTHERS
366: THEN
367: ROLLBACK TO TABLE_ATTRIBUTE_SP;
368: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
369: fnd_message.set_token('P_SQLCODE',SQLCODE);
370: fnd_message.set_token('P_SQLERRM',SQLERRM);
371: fnd_message.set_token('P_API_NAME',l_api_name);
372: FND_MSG_PUB.add;
373: x_return_status := fnd_api.g_ret_sts_unexp_error;
366: THEN
367: ROLLBACK TO TABLE_ATTRIBUTE_SP;
368: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
369: fnd_message.set_token('P_SQLCODE',SQLCODE);
370: fnd_message.set_token('P_SQLERRM',SQLERRM);
371: fnd_message.set_token('P_API_NAME',l_api_name);
372: FND_MSG_PUB.add;
373: x_return_status := fnd_api.g_ret_sts_unexp_error;
374: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
367: ROLLBACK TO TABLE_ATTRIBUTE_SP;
368: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
369: fnd_message.set_token('P_SQLCODE',SQLCODE);
370: fnd_message.set_token('P_SQLERRM',SQLERRM);
371: fnd_message.set_token('P_API_NAME',l_api_name);
372: FND_MSG_PUB.add;
373: x_return_status := fnd_api.g_ret_sts_unexp_error;
374: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
375: