APPS.JTF_RS_UPDATE_LOCATION_PUB dependencies on FND_MESSAGE

Line 52: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_NULL');

48:
49:
50: if(p_resource_id is null)
51: then
52: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_NULL');
53: fnd_msg_pub.add;
54: x_return_status := fnd_api.g_ret_sts_error;
55: RAISE fnd_api.g_exc_error;
56:

Line 63: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_NULL');

59: open res_cur;
60: fetch res_cur into res_rec;
61: if(res_cur%notfound)
62: then
63: fnd_message.set_name('JTF', 'JTF_RS_RESOURCE_NULL');
64: fnd_msg_pub.add;
65: x_return_status := fnd_api.g_ret_sts_error;
66: close res_cur;
67: RAISE fnd_api.g_exc_error;

Line 79: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');

75:
76: EXCEPTION
77: WHEN OTHERS THEN
78: x_return_status := fnd_api.g_ret_sts_unexp_error;
79: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
80: fnd_msg_pub.add;
81: RAISE fnd_api.g_exc_unexpected_error;
82: END;
83: update jtf_rs_resource_extns

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

103:
104: WHEN OTHERS
105: THEN
106: ROLLBACK TO update_sp;
107: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
108: fnd_message.set_token('P_SQLCODE',SQLCODE);
109: fnd_message.set_token('P_SQLERRM',SQLERRM);
110: fnd_message.set_token('P_API_NAME',l_api_name);
111: FND_MSG_PUB.add;

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

104: WHEN OTHERS
105: THEN
106: ROLLBACK TO update_sp;
107: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
108: fnd_message.set_token('P_SQLCODE',SQLCODE);
109: fnd_message.set_token('P_SQLERRM',SQLERRM);
110: fnd_message.set_token('P_API_NAME',l_api_name);
111: FND_MSG_PUB.add;
112: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

105: THEN
106: ROLLBACK TO update_sp;
107: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
108: fnd_message.set_token('P_SQLCODE',SQLCODE);
109: fnd_message.set_token('P_SQLERRM',SQLERRM);
110: fnd_message.set_token('P_API_NAME',l_api_name);
111: FND_MSG_PUB.add;
112: x_return_status := fnd_api.g_ret_sts_unexp_error;
113: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

106: ROLLBACK TO update_sp;
107: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
108: fnd_message.set_token('P_SQLCODE',SQLCODE);
109: fnd_message.set_token('P_SQLERRM',SQLERRM);
110: fnd_message.set_token('P_API_NAME',l_api_name);
111: FND_MSG_PUB.add;
112: x_return_status := fnd_api.g_ret_sts_unexp_error;
113: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
114: END;