263: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
264: p_data => x_msg_data);
265: WHEN OTHERS THEN
266: ROLLBACK TO create_salesreps_pub;
267: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
268: fnd_message.set_token('P_SQLCODE',SQLCODE);
269: fnd_message.set_token('P_SQLERRM',SQLERRM);
270: fnd_message.set_token('P_API_NAME', l_api_name);
271: FND_MSG_PUB.add;
264: p_data => x_msg_data);
265: WHEN OTHERS THEN
266: ROLLBACK TO create_salesreps_pub;
267: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
268: fnd_message.set_token('P_SQLCODE',SQLCODE);
269: fnd_message.set_token('P_SQLERRM',SQLERRM);
270: fnd_message.set_token('P_API_NAME', l_api_name);
271: FND_MSG_PUB.add;
272: x_return_status := fnd_api.g_ret_sts_unexp_error;
265: WHEN OTHERS THEN
266: ROLLBACK TO create_salesreps_pub;
267: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
268: fnd_message.set_token('P_SQLCODE',SQLCODE);
269: fnd_message.set_token('P_SQLERRM',SQLERRM);
270: fnd_message.set_token('P_API_NAME', l_api_name);
271: FND_MSG_PUB.add;
272: x_return_status := fnd_api.g_ret_sts_unexp_error;
273: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
266: ROLLBACK TO create_salesreps_pub;
267: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
268: fnd_message.set_token('P_SQLCODE',SQLCODE);
269: fnd_message.set_token('P_SQLERRM',SQLERRM);
270: fnd_message.set_token('P_API_NAME', l_api_name);
271: FND_MSG_PUB.add;
272: x_return_status := fnd_api.g_ret_sts_unexp_error;
273: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
274: p_data => x_msg_data);
551: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
552: p_data => x_msg_data);
553: WHEN OTHERS THEN
554: ROLLBACK TO update_salesreps_pub;
555: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
556: fnd_message.set_token('P_SQLCODE',SQLCODE);
557: fnd_message.set_token('P_SQLERRM',SQLERRM);
558: fnd_message.set_token('P_API_NAME', l_api_name);
559: FND_MSG_PUB.add;
552: p_data => x_msg_data);
553: WHEN OTHERS THEN
554: ROLLBACK TO update_salesreps_pub;
555: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
556: fnd_message.set_token('P_SQLCODE',SQLCODE);
557: fnd_message.set_token('P_SQLERRM',SQLERRM);
558: fnd_message.set_token('P_API_NAME', l_api_name);
559: FND_MSG_PUB.add;
560: x_return_status := fnd_api.g_ret_sts_unexp_error;
553: WHEN OTHERS THEN
554: ROLLBACK TO update_salesreps_pub;
555: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
556: fnd_message.set_token('P_SQLCODE',SQLCODE);
557: fnd_message.set_token('P_SQLERRM',SQLERRM);
558: fnd_message.set_token('P_API_NAME', l_api_name);
559: FND_MSG_PUB.add;
560: x_return_status := fnd_api.g_ret_sts_unexp_error;
561: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
554: ROLLBACK TO update_salesreps_pub;
555: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
556: fnd_message.set_token('P_SQLCODE',SQLCODE);
557: fnd_message.set_token('P_SQLERRM',SQLERRM);
558: fnd_message.set_token('P_API_NAME', l_api_name);
559: FND_MSG_PUB.add;
560: x_return_status := fnd_api.g_ret_sts_unexp_error;
561: FND_MSG_PUB.count_and_get (p_count => x_msg_count,
562: p_data => x_msg_data);