DBA Data[Home] [Help]

APPS.JTF_RS_SALESREPS_PUB dependencies on FND_MESSAGE

Line 267: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

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;

Line 268: fnd_message.set_token('P_SQLCODE',SQLCODE);

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;

Line 269: fnd_message.set_token('P_SQLERRM',SQLERRM);

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,

Line 270: fnd_message.set_token('P_API_NAME', l_api_name);

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);

Line 555: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

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;

Line 556: fnd_message.set_token('P_SQLCODE',SQLCODE);

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;

Line 557: fnd_message.set_token('P_SQLERRM',SQLERRM);

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,

Line 558: fnd_message.set_token('P_API_NAME', l_api_name);

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);