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_MSG_PUB

Line 86: FND_MSG_PUB.Initialize;

82:
83: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
84: IF FND_API.To_boolean(P_INIT_MSG_LIST)
85: THEN
86: FND_MSG_PUB.Initialize;
87: END IF;
88:
89: --Check if the passed resource_id is valid.
90: OPEN c_resource_id_valid (l_resource_id);

Line 97: FND_MSG_PUB.add;

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
101: CLOSE c_resource_id_valid;

Line 148: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

144: THEN
145: COMMIT WORK;
146: END IF;
147:
148: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
149:
150: EXCEPTION
151: WHEN fnd_api.g_exc_unexpected_error
152: THEN

Line 155: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

151: WHEN fnd_api.g_exc_unexpected_error
152: THEN
153: ROLLBACK TO CREATE_RES_AVAILABILITY_SP;
154: x_return_status := fnd_api.g_ret_sts_unexp_error;
155: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
156: WHEN fnd_api.g_exc_error
157: THEN
158: ROLLBACK TO CREATE_RES_AVAILABILITY_SP;
159: x_return_status := fnd_api.g_ret_sts_error;

Line 160: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

156: WHEN fnd_api.g_exc_error
157: THEN
158: ROLLBACK TO CREATE_RES_AVAILABILITY_SP;
159: x_return_status := fnd_api.g_ret_sts_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');

Line 168: FND_MSG_PUB.add;

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:
172: END CREATE_RES_AVAILABILITY;

Line 170: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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:
172: END CREATE_RES_AVAILABILITY;
173:
174:

Line 248: FND_MSG_PUB.Initialize;

244:
245: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
246: IF FND_API.To_boolean(P_INIT_MSG_LIST)
247: THEN
248: FND_MSG_PUB.Initialize;
249: END IF;
250:
251: --Check if the passed availability_id is valid.
252: OPEN c_availability_id_valid (l_availability_id);

Line 259: FND_MSG_PUB.add;

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
263: CLOSE c_availability_id_valid;

Line 274: FND_MSG_PUB.add;

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
278: CLOSE c_resource_id_valid;

Line 326: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

322: THEN
323: COMMIT WORK;
324: END IF;
325:
326: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
327:
328: EXCEPTION
329: WHEN fnd_api.g_exc_error
330: THEN

Line 333: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

329: WHEN fnd_api.g_exc_error
330: THEN
331: ROLLBACK TO UPDATE_RES_AVAILABILITY_SP;
332: x_return_status := fnd_api.g_ret_sts_error;
333: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
334: WHEN fnd_api.g_exc_unexpected_error
335: THEN
336: ROLLBACK TO UPDATE_RES_AVAILABILITY_SP;
337: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 338: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

334: WHEN fnd_api.g_exc_unexpected_error
335: THEN
336: ROLLBACK TO UPDATE_RES_AVAILABILITY_SP;
337: x_return_status := fnd_api.g_ret_sts_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');

Line 346: FND_MSG_PUB.add;

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;
350:

Line 348: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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;
350:
351:
352: /* Procedure to delete the resource availability */

Line 394: FND_MSG_PUB.Initialize;

390:
391: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
392: IF FND_API.To_boolean(P_INIT_MSG_LIST)
393: THEN
394: FND_MSG_PUB.Initialize;
395: END IF;
396:
397: --Check if the passed availability_id is valid.
398: OPEN c_availability_id_valid (l_availability_id);

Line 405: FND_MSG_PUB.add;

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
409: CLOSE c_availability_id_valid;

Line 433: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

429: THEN
430: COMMIT WORK;
431: END IF;
432:
433: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
434:
435: EXCEPTION
436: WHEN fnd_api.g_exc_unexpected_error
437: THEN

Line 440: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

436: WHEN fnd_api.g_exc_unexpected_error
437: THEN
438: ROLLBACK TO DELETE_RES_AVAILABILITY_SP;
439: x_return_status := fnd_api.g_ret_sts_unexp_error;
440: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
441: WHEN fnd_api.g_exc_error
442: THEN
443: ROLLBACK TO DELETE_RES_AVAILABILITY_SP;
444: x_return_status := fnd_api.g_ret_sts_error;

Line 445: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

441: WHEN fnd_api.g_exc_error
442: THEN
443: ROLLBACK TO DELETE_RES_AVAILABILITY_SP;
444: x_return_status := fnd_api.g_ret_sts_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');

Line 453: FND_MSG_PUB.add;

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:
457: END delete_res_availability;

Line 455: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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:
457: END delete_res_availability;
458:
459: END jtf_rs_res_availability_pub;