DBA Data[Home] [Help]

APPS.JTF_RS_RES_AVAILABILITY_PVT dependencies on FND_MESSAGE

Line 143: fnd_message.set_name ('JTF', 'JTF_RS_DUP_RES_AVAIL');

139: ELSE
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

Line 176: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_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');
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;

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

173: WHEN OTHERS
174: THEN
175: ROLLBACK TO RESOURCE_AVAILABILITY_SP;
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;

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

174: THEN
175: ROLLBACK TO RESOURCE_AVAILABILITY_SP;
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);

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

175: ROLLBACK TO RESOURCE_AVAILABILITY_SP;
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:

Line 494: fnd_message.set_name ('JTF', 'JTF_RS_DUP_RES_AVAIL');

490: IF c_dup_res_avail%FOUND THEN
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

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

509: EXCEPTION
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;

Line 557: fnd_message.set_name ('JTF', 'JTF_RS_AVAILABILITY_ID_INVALID');

553: P_OBJECT_VERSION_NUM := l_object_version_number;
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;

Line 586: fnd_message.set_name ('JTF', 'JTF_RS_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');
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;

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

583: WHEN OTHERS
584: THEN
585: ROLLBACK TO RES_AVAILABILITY_SP;
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;

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

584: THEN
585: ROLLBACK TO RES_AVAILABILITY_SP;
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);

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

585: ROLLBACK TO RES_AVAILABILITY_SP;
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;

Line 659: fnd_message.set_name ('JTF', 'JTF_RS_AVAILABILITY_ID_INVALID');

655: X_AVAILABILITY_ID => l_availability_id);
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;

Line 688: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_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');
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;

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

685: WHEN OTHERS
686: THEN
687: ROLLBACK TO RES_AVAILABILITY_SP;
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;

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

686: THEN
687: ROLLBACK TO RES_AVAILABILITY_SP;
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);

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

687: ROLLBACK TO RES_AVAILABILITY_SP;
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: