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

Line 97: FND_MSG_PUB.Initialize;

93:
94: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
95: IF FND_API.To_boolean(P_INIT_MSG_LIST)
96: THEN
97: FND_MSG_PUB.Initialize;
98: END IF;
99:
100: --GET USER ID AND SYSDATE
101: l_date := sysdate;

Line 155: FND_MSG_PUB.add;

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;
159: CLOSE attribute_dup_cur;

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

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;
159: CLOSE attribute_dup_cur;
160:

Line 164: FND_MSG_PUB.add;

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

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

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;
168:
169:

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

172: THEN
173: COMMIT WORK;
174: END IF;
175:
176: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
177:
178: EXCEPTION
179: WHEN fnd_api.g_exc_unexpected_error
180: THEN

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

179: WHEN fnd_api.g_exc_unexpected_error
180: THEN
181: ROLLBACK TO TABLE_ATTRIBUTE_SP;
182: x_return_status := fnd_api.g_ret_sts_unexp_error;
183: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
184: WHEN fnd_api.g_exc_error
185: THEN
186: ROLLBACK TO TABLE_ATTRIBUTE_SP;
187: x_return_status := fnd_api.g_ret_sts_error;

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

184: WHEN fnd_api.g_exc_error
185: THEN
186: ROLLBACK TO TABLE_ATTRIBUTE_SP;
187: x_return_status := fnd_api.g_ret_sts_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');

Line 196: FND_MSG_PUB.add;

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:
200: END create_table_attribute;

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

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:
200: END create_table_attribute;
201:
202:

Line 321: FND_MSG_PUB.Initialize;

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

Line 462: fnd_msg_pub.add;

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

Line 500: FND_MSG_PUB.add;

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

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

508: THEN
509: COMMIT WORK;
510: END IF;
511:
512: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
513:
514: EXCEPTION
515: WHEN fnd_api.g_exc_error
516: THEN

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

514: EXCEPTION
515: WHEN fnd_api.g_exc_error
516: THEN
517: ROLLBACK TO TABLE_ATTRIBUTE_SP;
518: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
519:
520: WHEN fnd_api.g_exc_unexpected_error
521: THEN
522: ROLLBACK TO TABLE_ATTRIBUTE_SP;

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

520: WHEN fnd_api.g_exc_unexpected_error
521: THEN
522: ROLLBACK TO TABLE_ATTRIBUTE_SP;
523: x_return_status := fnd_api.g_ret_sts_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');

Line 532: FND_MSG_PUB.add;

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

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

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;
536:
537:
538: /* Procedure to delete the table attributes. */

Line 594: FND_MSG_PUB.Initialize;

590:
591: --Initialize the message List if P_INIT_MSG_LIST is set to TRUE
592: IF FND_API.To_boolean(P_INIT_MSG_LIST)
593: THEN
594: FND_MSG_PUB.Initialize;
595: END IF;
596:
597: OPEN chk_att_exist_cur(l_attribute_id);
598: FETCH chk_att_exist_cur INTO chk_att_exist_rec;

Line 608: FND_MSG_PUB.add;

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

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

616: THEN
617: COMMIT WORK;
618: END IF;
619:
620: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
621:
622: EXCEPTION
623: WHEN fnd_api.g_exc_unexpected_error
624: THEN

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

622: EXCEPTION
623: WHEN fnd_api.g_exc_unexpected_error
624: THEN
625: ROLLBACK TO TABLE_ATTRIBUTE_SP;
626: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
627: WHEN fnd_api.g_exc_error
628: THEN
629: ROLLBACK TO TABLE_ATTRIBUTE_SP;
630: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);

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

626: FND_MSG_PUB.count_and_get (p_count => x_msg_count, p_data => x_msg_data);
627: WHEN fnd_api.g_exc_error
628: THEN
629: ROLLBACK TO TABLE_ATTRIBUTE_SP;
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');

Line 638: FND_MSG_PUB.add;

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:
642: END delete_table_attribute;

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

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:
642: END delete_table_attribute;
643:
644: END jtf_rs_table_attributes_pvt;