DBA Data[Home] [Help]

APPS.JTF_RS_TABLE_ATTRIBUTES_PVT dependencies on FND_MESSAGE

Line 154: fnd_message.set_name ('JTF', 'JTF_RS_ATT_DUP');

150: x_attribute_id := l_attribute_id;
151:
152: ELSIF attribute_dup_cur%FOUND THEN
153: x_attribute_id := attribute_dup_rec.attribute_id;
154: fnd_message.set_name ('JTF', 'JTF_RS_ATT_DUP');
155: FND_MSG_PUB.add;
156: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
157: raise fnd_api.g_exc_error;
158: END IF;

Line 163: fnd_message.set_name ('JTF', 'JTF_RS_ATT_CREATE_ERR');

159: CLOSE attribute_dup_cur;
160:
161: ELSIF (l_go_ahead = 'NO') THEN
162: x_attribute_id := null;
163: fnd_message.set_name ('JTF', 'JTF_RS_ATT_CREATE_ERR');
164: FND_MSG_PUB.add;
165: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
166: raise fnd_api.g_exc_error;
167: END IF;

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

188: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
189: WHEN OTHERS
190: THEN
191: ROLLBACK TO ROLE_RELATE_SP;
192: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
193: fnd_message.set_token('P_SQLCODE',SQLCODE);
194: fnd_message.set_token('P_SQLERRM',SQLERRM);
195: fnd_message.set_token('P_API_NAME', l_api_name);
196: FND_MSG_PUB.add;

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

189: WHEN OTHERS
190: THEN
191: ROLLBACK TO ROLE_RELATE_SP;
192: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
193: fnd_message.set_token('P_SQLCODE',SQLCODE);
194: fnd_message.set_token('P_SQLERRM',SQLERRM);
195: fnd_message.set_token('P_API_NAME', l_api_name);
196: FND_MSG_PUB.add;
197: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

190: THEN
191: ROLLBACK TO ROLE_RELATE_SP;
192: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
193: fnd_message.set_token('P_SQLCODE',SQLCODE);
194: fnd_message.set_token('P_SQLERRM',SQLERRM);
195: fnd_message.set_token('P_API_NAME', l_api_name);
196: FND_MSG_PUB.add;
197: x_return_status := fnd_api.g_ret_sts_unexp_error;
198: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

191: ROLLBACK TO ROLE_RELATE_SP;
192: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
193: fnd_message.set_token('P_SQLCODE',SQLCODE);
194: fnd_message.set_token('P_SQLERRM',SQLERRM);
195: fnd_message.set_token('P_API_NAME', l_api_name);
196: FND_MSG_PUB.add;
197: x_return_status := fnd_api.g_ret_sts_unexp_error;
198: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
199:

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

457: EXCEPTION
458:
459: WHEN OTHERS THEN
460: x_return_status := fnd_api.g_ret_sts_error;
461: fnd_message.set_name('JTF', 'JTF_RS_ROW_LOCK_ERROR');
462: fnd_msg_pub.add;
463: RAISE fnd_api.g_exc_error;
464:
465: END;

Line 499: fnd_message.set_name ('JTF', 'JTF_RS_INVALID_ID');

495: P_OBJECT_VERSION_NUM := l_object_version_number;
496:
497: ELSIF (table_attribute_cur%notfound) THEN
498: x_return_status := fnd_api.g_ret_sts_error;
499: fnd_message.set_name ('JTF', 'JTF_RS_INVALID_ID');
500: FND_MSG_PUB.add;
501: RAISE fnd_api.g_exc_error;
502:
503: END IF;

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

524: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
525: WHEN OTHERS
526: THEN
527: ROLLBACK TO TABLE_ATTRIBUTE_SP;
528: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
529: fnd_message.set_token('P_SQLCODE',SQLCODE);
530: fnd_message.set_token('P_SQLERRM',SQLERRM);
531: fnd_message.set_token('P_API_NAME',l_api_name);
532: FND_MSG_PUB.add;

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

525: WHEN OTHERS
526: THEN
527: ROLLBACK TO TABLE_ATTRIBUTE_SP;
528: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
529: fnd_message.set_token('P_SQLCODE',SQLCODE);
530: fnd_message.set_token('P_SQLERRM',SQLERRM);
531: fnd_message.set_token('P_API_NAME',l_api_name);
532: FND_MSG_PUB.add;
533: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

526: THEN
527: ROLLBACK TO TABLE_ATTRIBUTE_SP;
528: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
529: fnd_message.set_token('P_SQLCODE',SQLCODE);
530: fnd_message.set_token('P_SQLERRM',SQLERRM);
531: fnd_message.set_token('P_API_NAME',l_api_name);
532: FND_MSG_PUB.add;
533: x_return_status := fnd_api.g_ret_sts_unexp_error;
534: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

527: ROLLBACK TO TABLE_ATTRIBUTE_SP;
528: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
529: fnd_message.set_token('P_SQLCODE',SQLCODE);
530: fnd_message.set_token('P_SQLERRM',SQLERRM);
531: fnd_message.set_token('P_API_NAME',l_api_name);
532: FND_MSG_PUB.add;
533: x_return_status := fnd_api.g_ret_sts_unexp_error;
534: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
535: END update_table_attribute;

Line 607: fnd_message.set_name ('JTF', 'JTF_RS_INVALID_ID');

603: X_ATTRIBUTE_ID => l_attribute_id);
604:
605: ELSIF (chk_att_exist_cur%notfound) THEN
606: x_return_status := fnd_api.g_ret_sts_error;
607: fnd_message.set_name ('JTF', 'JTF_RS_INVALID_ID');
608: FND_MSG_PUB.add;
609: RAISE fnd_api.g_exc_error;
610:
611: END IF;

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

630: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
631: WHEN OTHERS
632: THEN
633: ROLLBACK TO TABLE_ATTRIBUTE_SP;
634: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
635: fnd_message.set_token('P_SQLCODE',SQLCODE);
636: fnd_message.set_token('P_SQLERRM',SQLERRM);
637: fnd_message.set_token('P_API_NAME',l_api_name);
638: FND_MSG_PUB.add;

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

631: WHEN OTHERS
632: THEN
633: ROLLBACK TO TABLE_ATTRIBUTE_SP;
634: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
635: fnd_message.set_token('P_SQLCODE',SQLCODE);
636: fnd_message.set_token('P_SQLERRM',SQLERRM);
637: fnd_message.set_token('P_API_NAME',l_api_name);
638: FND_MSG_PUB.add;
639: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

632: THEN
633: ROLLBACK TO TABLE_ATTRIBUTE_SP;
634: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
635: fnd_message.set_token('P_SQLCODE',SQLCODE);
636: fnd_message.set_token('P_SQLERRM',SQLERRM);
637: fnd_message.set_token('P_API_NAME',l_api_name);
638: FND_MSG_PUB.add;
639: x_return_status := fnd_api.g_ret_sts_unexp_error;
640: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

633: ROLLBACK TO TABLE_ATTRIBUTE_SP;
634: fnd_message.set_name ('JTF', 'JTF_RS_UNEXP_ERROR');
635: fnd_message.set_token('P_SQLCODE',SQLCODE);
636: fnd_message.set_token('P_SQLERRM',SQLERRM);
637: fnd_message.set_token('P_API_NAME',l_api_name);
638: FND_MSG_PUB.add;
639: x_return_status := fnd_api.g_ret_sts_unexp_error;
640: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
641: