112:
113: WHEN OTHERS
114: THEN
115: ROLLBACK TO role_relate_audit;
116: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
117: fnd_message.set_token('P_SQLCODE',SQLCODE);
118: fnd_message.set_token('P_SQLERRM',SQLERRM);
119: fnd_message.set_token('P_API_NAME',L_API_NAME);
120: FND_MSG_PUB.add;
113: WHEN OTHERS
114: THEN
115: ROLLBACK TO role_relate_audit;
116: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
117: fnd_message.set_token('P_SQLCODE',SQLCODE);
118: fnd_message.set_token('P_SQLERRM',SQLERRM);
119: fnd_message.set_token('P_API_NAME',L_API_NAME);
120: FND_MSG_PUB.add;
121: x_return_status := fnd_api.g_ret_sts_unexp_error;
114: THEN
115: ROLLBACK TO role_relate_audit;
116: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
117: fnd_message.set_token('P_SQLCODE',SQLCODE);
118: fnd_message.set_token('P_SQLERRM',SQLERRM);
119: fnd_message.set_token('P_API_NAME',L_API_NAME);
120: FND_MSG_PUB.add;
121: x_return_status := fnd_api.g_ret_sts_unexp_error;
122: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
115: ROLLBACK TO role_relate_audit;
116: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
117: fnd_message.set_token('P_SQLCODE',SQLCODE);
118: fnd_message.set_token('P_SQLERRM',SQLERRM);
119: fnd_message.set_token('P_API_NAME',L_API_NAME);
120: FND_MSG_PUB.add;
121: x_return_status := fnd_api.g_ret_sts_unexp_error;
122: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
123:
302:
303: WHEN OTHERS
304: THEN
305: ROLLBACK TO role_relate_audit;
306: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
307: fnd_message.set_token('P_SQLCODE',SQLCODE);
308: fnd_message.set_token('P_SQLERRM',SQLERRM);
309: fnd_message.set_token('P_API_NAME',l_api_name);
310: FND_MSG_PUB.add;
303: WHEN OTHERS
304: THEN
305: ROLLBACK TO role_relate_audit;
306: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
307: fnd_message.set_token('P_SQLCODE',SQLCODE);
308: fnd_message.set_token('P_SQLERRM',SQLERRM);
309: fnd_message.set_token('P_API_NAME',l_api_name);
310: FND_MSG_PUB.add;
311: x_return_status := fnd_api.g_ret_sts_unexp_error;
304: THEN
305: ROLLBACK TO role_relate_audit;
306: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
307: fnd_message.set_token('P_SQLCODE',SQLCODE);
308: fnd_message.set_token('P_SQLERRM',SQLERRM);
309: fnd_message.set_token('P_API_NAME',l_api_name);
310: FND_MSG_PUB.add;
311: x_return_status := fnd_api.g_ret_sts_unexp_error;
312: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
305: ROLLBACK TO role_relate_audit;
306: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
307: fnd_message.set_token('P_SQLCODE',SQLCODE);
308: fnd_message.set_token('P_SQLERRM',SQLERRM);
309: fnd_message.set_token('P_API_NAME',l_api_name);
310: FND_MSG_PUB.add;
311: x_return_status := fnd_api.g_ret_sts_unexp_error;
312: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
313:
451:
452: WHEN OTHERS
453: THEN
454: ROLLBACK TO role_relate_audit;
455: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
456: fnd_message.set_token('P_SQLCODE',SQLCODE);
457: fnd_message.set_token('P_SQLERRM',SQLERRM);
458: fnd_message.set_token('P_API_NAME',l_api_name);
459: FND_MSG_PUB.add;
452: WHEN OTHERS
453: THEN
454: ROLLBACK TO role_relate_audit;
455: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
456: fnd_message.set_token('P_SQLCODE',SQLCODE);
457: fnd_message.set_token('P_SQLERRM',SQLERRM);
458: fnd_message.set_token('P_API_NAME',l_api_name);
459: FND_MSG_PUB.add;
460: x_return_status := fnd_api.g_ret_sts_unexp_error;
453: THEN
454: ROLLBACK TO role_relate_audit;
455: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
456: fnd_message.set_token('P_SQLCODE',SQLCODE);
457: fnd_message.set_token('P_SQLERRM',SQLERRM);
458: fnd_message.set_token('P_API_NAME',l_api_name);
459: FND_MSG_PUB.add;
460: x_return_status := fnd_api.g_ret_sts_unexp_error;
461: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
454: ROLLBACK TO role_relate_audit;
455: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
456: fnd_message.set_token('P_SQLCODE',SQLCODE);
457: fnd_message.set_token('P_SQLERRM',SQLERRM);
458: fnd_message.set_token('P_API_NAME',l_api_name);
459: FND_MSG_PUB.add;
460: x_return_status := fnd_api.g_ret_sts_unexp_error;
461: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
462: