eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_RS_RES_AVAILABILITY_PUB dependencies on FND_MESSAGE

Line 96: fnd_message.set_name ('JTF', 'JTF_RS_RES_ID_INVALID');

92: IF c_resource_id_valid%NOTFOUND THEN
93: IF c_resource_id_valid%ISOPEN THEN
94: CLOSE c_resource_id_valid;
95: END IF;
96: fnd_message.set_name ('JTF', 'JTF_RS_RES_ID_INVALID');
97: FND_MSG_PUB.add;
98: raise fnd_api.g_exc_error;
99: END IF;
100: IF c_resource_id_valid%ISOPEN THEN

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

160: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
161: WHEN OTHERS
162: THEN
163: ROLLBACK TO CREATE_RES_AVAILABILITY_SP;
164: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
165: fnd_message.set_token('P_SQLCODE',SQLCODE);
166: fnd_message.set_token('P_SQLERRM',SQLERRM);
167: fnd_message.set_token('P_API_NAME', l_api_name);
168: FND_MSG_PUB.add;

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

161: WHEN OTHERS
162: THEN
163: ROLLBACK TO CREATE_RES_AVAILABILITY_SP;
164: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
165: fnd_message.set_token('P_SQLCODE',SQLCODE);
166: fnd_message.set_token('P_SQLERRM',SQLERRM);
167: fnd_message.set_token('P_API_NAME', l_api_name);
168: FND_MSG_PUB.add;
169: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

162: THEN
163: ROLLBACK TO CREATE_RES_AVAILABILITY_SP;
164: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
165: fnd_message.set_token('P_SQLCODE',SQLCODE);
166: fnd_message.set_token('P_SQLERRM',SQLERRM);
167: fnd_message.set_token('P_API_NAME', l_api_name);
168: FND_MSG_PUB.add;
169: x_return_status := fnd_api.g_ret_sts_unexp_error;
170: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

163: ROLLBACK TO CREATE_RES_AVAILABILITY_SP;
164: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
165: fnd_message.set_token('P_SQLCODE',SQLCODE);
166: fnd_message.set_token('P_SQLERRM',SQLERRM);
167: fnd_message.set_token('P_API_NAME', l_api_name);
168: FND_MSG_PUB.add;
169: x_return_status := fnd_api.g_ret_sts_unexp_error;
170: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
171:

Line 258: fnd_message.set_name ('JTF', 'JTF_RS_AVAIL_ID_INVALID');

254: IF c_availability_id_valid%NOTFOUND THEN
255: IF c_availability_id_valid%ISOPEN THEN
256: CLOSE c_availability_id_valid;
257: END IF;
258: fnd_message.set_name ('JTF', 'JTF_RS_AVAIL_ID_INVALID');
259: FND_MSG_PUB.add;
260: raise fnd_api.g_exc_error;
261: END IF;
262: IF c_availability_id_valid%ISOPEN THEN

Line 273: fnd_message.set_name ('JTF', 'JTF_RS_RES_ID_INVALID');

269: IF c_resource_id_valid%NOTFOUND THEN
270: IF c_resource_id_valid%ISOPEN THEN
271: CLOSE c_resource_id_valid;
272: END IF;
273: fnd_message.set_name ('JTF', 'JTF_RS_RES_ID_INVALID');
274: FND_MSG_PUB.add;
275: raise fnd_api.g_exc_error;
276: END IF;
277: IF c_resource_id_valid%ISOPEN THEN

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

338: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
339: WHEN OTHERS
340: THEN
341: ROLLBACK TO UPDATE_RES_AVAILABILITY_SP;
342: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
343: fnd_message.set_token('P_SQLCODE',SQLCODE);
344: fnd_message.set_token('P_SQLERRM',SQLERRM);
345: fnd_message.set_token('P_API_NAME',l_api_name);
346: FND_MSG_PUB.add;

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

339: WHEN OTHERS
340: THEN
341: ROLLBACK TO UPDATE_RES_AVAILABILITY_SP;
342: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
343: fnd_message.set_token('P_SQLCODE',SQLCODE);
344: fnd_message.set_token('P_SQLERRM',SQLERRM);
345: fnd_message.set_token('P_API_NAME',l_api_name);
346: FND_MSG_PUB.add;
347: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

340: THEN
341: ROLLBACK TO UPDATE_RES_AVAILABILITY_SP;
342: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
343: fnd_message.set_token('P_SQLCODE',SQLCODE);
344: fnd_message.set_token('P_SQLERRM',SQLERRM);
345: fnd_message.set_token('P_API_NAME',l_api_name);
346: FND_MSG_PUB.add;
347: x_return_status := fnd_api.g_ret_sts_unexp_error;
348: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

341: ROLLBACK TO UPDATE_RES_AVAILABILITY_SP;
342: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
343: fnd_message.set_token('P_SQLCODE',SQLCODE);
344: fnd_message.set_token('P_SQLERRM',SQLERRM);
345: fnd_message.set_token('P_API_NAME',l_api_name);
346: FND_MSG_PUB.add;
347: x_return_status := fnd_api.g_ret_sts_unexp_error;
348: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
349: END update_res_availability;

Line 404: fnd_message.set_name ('JTF', 'JTF_RS_AVAIL_ID_INVALID');

400: IF c_availability_id_valid%NOTFOUND THEN
401: IF c_availability_id_valid%ISOPEN THEN
402: CLOSE c_availability_id_valid;
403: END IF;
404: fnd_message.set_name ('JTF', 'JTF_RS_AVAIL_ID_INVALID');
405: FND_MSG_PUB.add;
406: raise fnd_api.g_exc_error;
407: END IF;
408: IF c_availability_id_valid%ISOPEN THEN

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

445: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
446: WHEN OTHERS
447: THEN
448: ROLLBACK TO DELETE_RES_AVAILABILITY_SP;
449: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
450: fnd_message.set_token('P_SQLCODE',SQLCODE);
451: fnd_message.set_token('P_SQLERRM',SQLERRM);
452: fnd_message.set_token('P_API_NAME',l_api_name);
453: FND_MSG_PUB.add;

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

446: WHEN OTHERS
447: THEN
448: ROLLBACK TO DELETE_RES_AVAILABILITY_SP;
449: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
450: fnd_message.set_token('P_SQLCODE',SQLCODE);
451: fnd_message.set_token('P_SQLERRM',SQLERRM);
452: fnd_message.set_token('P_API_NAME',l_api_name);
453: FND_MSG_PUB.add;
454: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

447: THEN
448: ROLLBACK TO DELETE_RES_AVAILABILITY_SP;
449: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
450: fnd_message.set_token('P_SQLCODE',SQLCODE);
451: fnd_message.set_token('P_SQLERRM',SQLERRM);
452: fnd_message.set_token('P_API_NAME',l_api_name);
453: FND_MSG_PUB.add;
454: x_return_status := fnd_api.g_ret_sts_unexp_error;
455: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

448: ROLLBACK TO DELETE_RES_AVAILABILITY_SP;
449: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
450: fnd_message.set_token('P_SQLCODE',SQLCODE);
451: fnd_message.set_token('P_SQLERRM',SQLERRM);
452: fnd_message.set_token('P_API_NAME',l_api_name);
453: FND_MSG_PUB.add;
454: x_return_status := fnd_api.g_ret_sts_unexp_error;
455: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
456: