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_PVT dependencies on FND_MSG_PUB

Line 91: FND_MSG_PUB.Initialize;

87:
88: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
89: IF FND_API.To_boolean(P_INIT_MSG_LIST)
90: THEN
91: FND_MSG_PUB.Initialize;
92: END IF;
93:
94: --GET USER ID AND SYSDATE
95: l_date := sysdate;

Line 144: FND_MSG_PUB.add;

140: IF c_dup_res_avail%ISOPEN THEN
141: CLOSE c_dup_res_avail;
142: END IF;
143: fnd_message.set_name ('JTF', 'JTF_RS_DUP_RES_AVAIL');
144: FND_MSG_PUB.add;
145: raise fnd_api.g_exc_error;
146: END IF;
147: IF c_dup_res_avail%ISOPEN THEN
148: CLOSE c_dup_res_avail;

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

156: THEN
157: COMMIT WORK;
158: END IF;
159:
160: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
161:
162: EXCEPTION
163: WHEN fnd_api.g_exc_unexpected_error
164: THEN

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

163: WHEN fnd_api.g_exc_unexpected_error
164: THEN
165: ROLLBACK TO RESOURCE_AVAILABILITY_SP;
166: x_return_status := fnd_api.g_ret_sts_unexp_error;
167: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
168: WHEN fnd_api.g_exc_error
169: THEN
170: ROLLBACK TO RESOURCE_AVAILABILITY_SP;
171: x_return_status := fnd_api.g_ret_sts_error;

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

168: WHEN fnd_api.g_exc_error
169: THEN
170: ROLLBACK TO RESOURCE_AVAILABILITY_SP;
171: x_return_status := fnd_api.g_ret_sts_error;
172: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
173: WHEN OTHERS
174: THEN
175: ROLLBACK TO RESOURCE_AVAILABILITY_SP;
176: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 180: FND_MSG_PUB.add;

176: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
177: fnd_message.set_token('P_SQLCODE',SQLCODE);
178: fnd_message.set_token('P_SQLERRM',SQLERRM);
179: fnd_message.set_token('P_API_NAME', l_api_name);
180: FND_MSG_PUB.add;
181: x_return_status := fnd_api.g_ret_sts_unexp_error;
182: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
183:
184: END create_res_availability;

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

178: fnd_message.set_token('P_SQLERRM',SQLERRM);
179: fnd_message.set_token('P_API_NAME', l_api_name);
180: FND_MSG_PUB.add;
181: x_return_status := fnd_api.g_ret_sts_unexp_error;
182: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
183:
184: END create_res_availability;
185:
186:

Line 320: FND_MSG_PUB.Initialize;

316:
317: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
318: IF FND_API.To_boolean(P_INIT_MSG_LIST)
319: THEN
320: FND_MSG_PUB.Initialize;
321: END IF;
322:
323:
324: --GET USER ID AND SYSDATE

Line 495: FND_MSG_PUB.add;

491: IF c_dup_res_avail%ISOPEN THEN
492: CLOSE c_dup_res_avail;
493: END IF;
494: fnd_message.set_name ('JTF', 'JTF_RS_DUP_RES_AVAIL');
495: FND_MSG_PUB.add;
496: raise fnd_api.g_exc_error;
497: END IF;
498: IF c_dup_res_avail%ISOPEN THEN
499: CLOSE c_dup_res_avail;

Line 514: fnd_msg_pub.add;

510:
511: WHEN OTHERS THEN
512: x_return_status := fnd_api.g_ret_sts_error;
513: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
514: fnd_msg_pub.add;
515: RAISE fnd_api.g_exc_error;
516:
517: END;
518:

Line 558: FND_MSG_PUB.add;

554:
555: ELSIF (resource_cur%notfound) THEN
556: x_return_status := fnd_api.g_ret_sts_error;
557: fnd_message.set_name ('JTF', 'JTF_RS_AVAILABILITY_ID_INVALID');
558: FND_MSG_PUB.add;
559: RAISE fnd_api.g_exc_error;
560:
561: END IF;
562:

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

566: THEN
567: COMMIT WORK;
568: END IF;
569:
570: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
571:
572: EXCEPTION
573: WHEN fnd_api.g_exc_error
574: THEN

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

573: WHEN fnd_api.g_exc_error
574: THEN
575: ROLLBACK TO RES_AVAILABILITY_SP;
576: x_return_status := fnd_api.g_ret_sts_error;
577: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
578: WHEN fnd_api.g_exc_unexpected_error
579: THEN
580: ROLLBACK TO RES_AVAILABILITY_SP;
581: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

578: WHEN fnd_api.g_exc_unexpected_error
579: THEN
580: ROLLBACK TO RES_AVAILABILITY_SP;
581: x_return_status := fnd_api.g_ret_sts_unexp_error;
582: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
583: WHEN OTHERS
584: THEN
585: ROLLBACK TO RES_AVAILABILITY_SP;
586: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 590: FND_MSG_PUB.add;

586: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
587: fnd_message.set_token('P_SQLCODE',SQLCODE);
588: fnd_message.set_token('P_SQLERRM',SQLERRM);
589: fnd_message.set_token('P_API_NAME',l_api_name);
590: FND_MSG_PUB.add;
591: x_return_status := fnd_api.g_ret_sts_unexp_error;
592: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
593: END update_res_availability;
594:

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

588: fnd_message.set_token('P_SQLERRM',SQLERRM);
589: fnd_message.set_token('P_API_NAME',l_api_name);
590: FND_MSG_PUB.add;
591: x_return_status := fnd_api.g_ret_sts_unexp_error;
592: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
593: END update_res_availability;
594:
595:
596: /* Procedure to delete the resource availability */

Line 646: FND_MSG_PUB.Initialize;

642:
643: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
644: IF FND_API.To_boolean(P_INIT_MSG_LIST)
645: THEN
646: FND_MSG_PUB.Initialize;
647: END IF;
648:
649: OPEN chk_res_exist_cur(l_availability_id);
650: FETCH chk_res_exist_cur INTO chk_res_exist_rec;

Line 660: FND_MSG_PUB.add;

656:
657: ELSIF (chk_res_exist_cur%notfound) THEN
658: x_return_status := fnd_api.g_ret_sts_error;
659: fnd_message.set_name ('JTF', 'JTF_RS_AVAILABILITY_ID_INVALID');
660: FND_MSG_PUB.add;
661: RAISE fnd_api.g_exc_error;
662:
663: END IF;
664:

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

668: THEN
669: COMMIT WORK;
670: END IF;
671:
672: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
673:
674: EXCEPTION
675: WHEN fnd_api.g_exc_unexpected_error
676: THEN

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

675: WHEN fnd_api.g_exc_unexpected_error
676: THEN
677: ROLLBACK TO RES_AVAILABILITY_SP;
678: x_return_status := fnd_api.g_ret_sts_unexp_error;
679: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
680: WHEN fnd_api.g_exc_error
681: THEN
682: ROLLBACK TO RES_AVAILABILITY_SP;
683: x_return_status := fnd_api.g_ret_sts_error;

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

680: WHEN fnd_api.g_exc_error
681: THEN
682: ROLLBACK TO RES_AVAILABILITY_SP;
683: x_return_status := fnd_api.g_ret_sts_error;
684: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
685: WHEN OTHERS
686: THEN
687: ROLLBACK TO RES_AVAILABILITY_SP;
688: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');

Line 692: FND_MSG_PUB.add;

688: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
689: fnd_message.set_token('P_SQLCODE',SQLCODE);
690: fnd_message.set_token('P_SQLERRM',SQLERRM);
691: fnd_message.set_token('P_API_NAME',l_api_name);
692: FND_MSG_PUB.add;
693: x_return_status := fnd_api.g_ret_sts_unexp_error;
694: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
695:
696: END delete_res_availability;

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

690: fnd_message.set_token('P_SQLERRM',SQLERRM);
691: fnd_message.set_token('P_API_NAME',l_api_name);
692: FND_MSG_PUB.add;
693: x_return_status := fnd_api.g_ret_sts_unexp_error;
694: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
695:
696: END delete_res_availability;
697:
698: END JTF_RS_RES_AVAILABILITY_PVT;