164: -- DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
165:
166: ROLLBACK TO create_rs_group_usage_pub;
167:
168: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
169: fnd_message.set_token('P_SQLCODE',SQLCODE);
170: fnd_message.set_token('P_SQLERRM',SQLERRM);
171: fnd_message.set_token('P_API_NAME',l_api_name);
172: FND_MSG_PUB.add;
165:
166: ROLLBACK TO create_rs_group_usage_pub;
167:
168: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
169: fnd_message.set_token('P_SQLCODE',SQLCODE);
170: fnd_message.set_token('P_SQLERRM',SQLERRM);
171: fnd_message.set_token('P_API_NAME',l_api_name);
172: FND_MSG_PUB.add;
173:
166: ROLLBACK TO create_rs_group_usage_pub;
167:
168: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
169: fnd_message.set_token('P_SQLCODE',SQLCODE);
170: fnd_message.set_token('P_SQLERRM',SQLERRM);
171: fnd_message.set_token('P_API_NAME',l_api_name);
172: FND_MSG_PUB.add;
173:
174: x_return_status := fnd_api.g_ret_sts_unexp_error;
167:
168: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
169: fnd_message.set_token('P_SQLCODE',SQLCODE);
170: fnd_message.set_token('P_SQLERRM',SQLERRM);
171: fnd_message.set_token('P_API_NAME',l_api_name);
172: FND_MSG_PUB.add;
173:
174: x_return_status := fnd_api.g_ret_sts_unexp_error;
175:
333: -- DBMS_OUTPUT.put_line (SQLCODE || SQLERRM);
334:
335: ROLLBACK TO delete_group_usage_pub;
336:
337: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
338: fnd_message.set_token('P_SQLCODE',SQLCODE);
339: fnd_message.set_token('P_SQLERRM',SQLERRM);
340: fnd_message.set_token('P_API_NAME',l_api_name);
341: FND_MSG_PUB.add;
334:
335: ROLLBACK TO delete_group_usage_pub;
336:
337: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
338: fnd_message.set_token('P_SQLCODE',SQLCODE);
339: fnd_message.set_token('P_SQLERRM',SQLERRM);
340: fnd_message.set_token('P_API_NAME',l_api_name);
341: FND_MSG_PUB.add;
342:
335: ROLLBACK TO delete_group_usage_pub;
336:
337: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
338: fnd_message.set_token('P_SQLCODE',SQLCODE);
339: fnd_message.set_token('P_SQLERRM',SQLERRM);
340: fnd_message.set_token('P_API_NAME',l_api_name);
341: FND_MSG_PUB.add;
342:
343: x_return_status := fnd_api.g_ret_sts_unexp_error;
336:
337: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
338: fnd_message.set_token('P_SQLCODE',SQLCODE);
339: fnd_message.set_token('P_SQLERRM',SQLERRM);
340: fnd_message.set_token('P_API_NAME',l_api_name);
341: FND_MSG_PUB.add;
342:
343: x_return_status := fnd_api.g_ret_sts_unexp_error;
344: