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.CSI_T_TXN_ATTRIBS_PVT dependencies on FND_MSG_PUB

Line 55: fnd_msg_pub.initialize;

51: SAVEPOINT create_txn_ext_attrib_dtls;
52:
53: -- Initialize message list if p_init_msg_list is set to TRUE.
54: IF fnd_api.to_Boolean( p_init_msg_list ) THEN
55: fnd_msg_pub.initialize;
56: END IF;
57:
58: -- Initialize API return status to success
59: x_return_status := fnd_api.G_RET_STS_SUCCESS;

Line 100: FND_MSG_PUB.add;

96: IF p_txn_ext_attrib_vals_rec.api_caller_identity <> 'CONFIG'
97: THEN
98: FND_MESSAGE.set_name('CSI','CSI_TXN_NOT_CZ_CALLER');
99: FND_MESSAGE.set_token('API_CALLER',p_txn_ext_attrib_vals_rec.api_caller_identity) ;
100: FND_MSG_PUB.add;
101: RAISE FND_API.g_exc_error;
102: END IF ;
103: -- get the attrib_source_id
104: IF NVL(p_txn_ext_attrib_vals_rec.attribute_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char

Line 121: fnd_msg_pub.add;

117: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
118: THEN
119: debug ('Call to get_ext_attrib_id failed ..');
120: FND_MESSAGE.set_token('ATTRIB_LEVEL',p_txn_ext_attrib_vals_rec.attribute_level);
121: fnd_msg_pub.add;
122: RAISE fnd_api.g_exc_error;
123: END IF ;
124: ELSIF NVL(p_txn_ext_attrib_vals_rec.attribute_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char
125: AND NVL(p_txn_ext_attrib_vals_rec.attribute_level, fnd_api.g_miss_char) = fnd_api.g_miss_char

Line 158: fnd_msg_pub.add;

154: THEN
155: IF i=4 THEN
156: debug ('Call to get_ext_attrib_id failed ..');
157: FND_MESSAGE.set_token('ATTRIB_LEVEL','');
158: fnd_msg_pub.add;
159: RAISE fnd_api.g_exc_error;
160: END IF;
161: END IF ;
162:

Line 177: fnd_msg_pub.add;

173: ---Attrib code is NOT passed.
174: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
175: fnd_message.set_token('MESSAGE',
176: 'No Attribute code is passed ');
177: fnd_msg_pub.add;
178: debug ( 'Attribute Code is null so raise the error :');
179: RAISE fnd_api.g_exc_error;
180: END IF ;
181: debug ( 'checking x_attribute_id :'|| x_attribute_id) ;

Line 189: fnd_msg_pub.add;

185: ELSE
186: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
187: fnd_message.set_token('MESSAGE',
188: 'Either no Attribute code is passed OR csi_t_extend_attribs_pkg.get_attrib_id failed');
189: fnd_msg_pub.add;
190: debug ( 'Attribute id is null so raise the error :');
191: RAISE fnd_api.g_exc_error;
192: END IF ;
193: END IF ; --(p_txn_ext_attrib_vals_rec.attrib_source_id is not passed

Line 288: fnd_msg_pub.add;

284: WHEN others THEN
285: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
286: fnd_message.set_token('MESSAGE',
287: 'csi_t_extend_attribs_pkg.insert_row Failed. '||substr(sqlerrm,1,200));
288: fnd_msg_pub.add;
289: RAISE fnd_api.g_exc_error;
290: END;
291:
292: p_txn_ext_attrib_vals_rec.txn_attrib_detail_id := l_txn_attrib_detail_id;

Line 304: fnd_msg_pub.count_and_get(

300: csi_t_gen_utility_pvt.set_debug_off;
301: END IF;
302:
303: -- Standard call to get message count and if count is get message info.
304: fnd_msg_pub.count_and_get(
305: p_count => x_msg_count,
306: p_data => x_msg_data);
307:
308: EXCEPTION

Line 313: fnd_msg_pub.count_and_get (

309: WHEN fnd_api.g_exc_error THEN
310:
311: ROLLBACK TO create_txn_ext_attrib_dtls;
312: x_return_status := fnd_api.g_ret_sts_error ;
313: fnd_msg_pub.count_and_get (
314: p_count => x_msg_count,
315: p_data => x_msg_data);
316:
317: WHEN fnd_api.g_exc_unexpected_error THEN

Line 322: fnd_msg_pub.count_and_get(

318:
319: ROLLBACK TO create_txn_ext_attrib_dtls;
320: x_return_status := fnd_api.g_ret_sts_unexp_error ;
321:
322: fnd_msg_pub.count_and_get(
323: p_count => x_msg_count,
324: p_data => x_msg_data);
325:
326: WHEN OTHERS THEN

Line 331: IF fnd_msg_pub.Check_Msg_Level(

327:
328: ROLLBACK TO create_txn_ext_attrib_dtls;
329: x_return_status := fnd_api.g_ret_sts_unexp_error ;
330:
331: IF fnd_msg_pub.Check_Msg_Level(
332: p_message_level => fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
333:
334: fnd_msg_pub.Add_Exc_Msg(
335: p_pkg_name => G_PKG_NAME,

Line 332: p_message_level => fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN

328: ROLLBACK TO create_txn_ext_attrib_dtls;
329: x_return_status := fnd_api.g_ret_sts_unexp_error ;
330:
331: IF fnd_msg_pub.Check_Msg_Level(
332: p_message_level => fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
333:
334: fnd_msg_pub.Add_Exc_Msg(
335: p_pkg_name => G_PKG_NAME,
336: p_procedure_name => l_api_name);

Line 334: fnd_msg_pub.Add_Exc_Msg(

330:
331: IF fnd_msg_pub.Check_Msg_Level(
332: p_message_level => fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
333:
334: fnd_msg_pub.Add_Exc_Msg(
335: p_pkg_name => G_PKG_NAME,
336: p_procedure_name => l_api_name);
337:
338: END IF;

Line 340: fnd_msg_pub.count_and_get(

336: p_procedure_name => l_api_name);
337:
338: END IF;
339:
340: fnd_msg_pub.count_and_get(
341: p_count => x_msg_count,
342: p_data => x_msg_data);
343:
344: END create_txn_ext_attrib_dtls;

Line 392: fnd_msg_pub.initialize;

388: SAVEPOINT update_txn_ext_attrib_dtls;
389:
390: -- Initialize message list if p_init_msg_list is set to TRUE.
391: IF fnd_api.to_Boolean( p_init_msg_list ) THEN
392: fnd_msg_pub.initialize;
393: END IF;
394:
395: -- Initialize API return status to success
396: x_return_status := fnd_api.G_RET_STS_SUCCESS;

Line 442: FND_MSG_PUB.add;

438: IF l_txn_ext_attrib_vals_tbl(l_ind).api_caller_identity <> 'CONFIG'
439: THEN
440: FND_MESSAGE.set_name('CSI','CSI_TXN_NOT_CZ_CALLER');
441: FND_MESSAGE.set_token('API_CALLER',l_txn_ext_attrib_vals_tbl(l_ind).api_caller_identity) ;
442: FND_MSG_PUB.add;
443: RAISE FND_API.g_exc_error;
444: END IF ;
445: -- get the attrib_source_id
446: IF NVL(l_txn_ext_attrib_vals_tbl(l_ind).attribute_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char

Line 462: fnd_msg_pub.add;

458: IF NOT (x_return_status = fnd_api.g_ret_sts_success)
459: THEN
460: debug ('Call to get_ext_attrib_id failed ..');
461: FND_MESSAGE.set_token('ATTRIB_LEVEL',l_txn_ext_attrib_vals_tbl(l_ind).attribute_level);
462: fnd_msg_pub.add;
463: RAISE fnd_api.g_exc_error;
464: END IF ;
465: ELSIF NVL(l_txn_ext_attrib_vals_tbl(l_ind).attribute_code, fnd_api.g_miss_char) <> fnd_api.g_miss_char
466: AND NVL(l_txn_ext_attrib_vals_tbl(l_ind).attribute_level, fnd_api.g_miss_char) = fnd_api.g_miss_char

Line 500: fnd_msg_pub.add;

496: THEN
497: IF i=4 THEN
498: debug ('Call to get_ext_attrib_id failed ..');
499: FND_MESSAGE.set_token('ATTRIB_LEVEL','');
500: fnd_msg_pub.add;
501: RAISE fnd_api.g_exc_error;
502: END IF;
503: END IF ;
504:

Line 518: fnd_msg_pub.add;

514: ---Attrib code is NOT passed.
515: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
516: fnd_message.set_token('MESSAGE',
517: 'No attribute code is passed ');
518: fnd_msg_pub.add;
519: debug ( 'Attribute id is null so raise the error :');
520: RAISE fnd_api.g_exc_error;
521: END IF ;
522: IF NVL(l_attribute_id,fnd_api.g_miss_num) <> fnd_api.g_miss_num

Line 529: fnd_msg_pub.add;

525: ELSE
526: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
527: fnd_message.set_token('MESSAGE',
528: 'csi_t_extend_attribs_pkg.get_attrib_id failed');
529: fnd_msg_pub.add;
530: debug ( 'Attribute id is null so raise the error :');
531: RAISE fnd_api.g_exc_error;
532: END IF ;
533: END IF ; --l_txn_ext_attrib_vals_tbl(l_ind).source_id

Line 552: fnd_msg_pub.add;

548: IF l_return_status <> fnd_api.g_ret_sts_success THEN
549:
550: FND_MESSAGE.set_name('CSI','CSI_TXN_EXT_ATTRIB_ID_INVALID');
551: FND_MESSAGE.set_token('EXT_ATT_ID',l_ext_att_id);
552: fnd_msg_pub.add;
553: RAISE fnd_api.g_exc_error;
554:
555: END IF;
556:

Line 575: fnd_msg_pub.add;

571:
572: FND_MESSAGE.set_name('CSI','CSI_TXN_UPD_DEL_NOT_ALLOWED');
573: FND_MESSAGE.set_token('LVL_ID', l_ext_att_id);
574: FND_MESSAGE.set_token('STATUS',l_processing_status);
575: fnd_msg_pub.add;
576: RAISE fnd_api.g_exc_error;
577:
578: END IF;
579:

Line 717: fnd_msg_pub.add;

713: when others then
714: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
715: fnd_message.set_token('MESSAGE',
716: 'csi_t_extend_attribs_pkg.update_row Failed. '||substr(sqlerrm,1,200));
717: fnd_msg_pub.add;
718: raise fnd_api.g_exc_error;
719: end;
720:
721: END LOOP;

Line 730: fnd_msg_pub.count_and_get(

726: IF fnd_api.To_Boolean( p_commit ) THEN
727: COMMIT WORK;
728: END IF;
729: -- Standard call to get message count and if count is get message info.
730: fnd_msg_pub.count_and_get(
731: p_count => x_msg_count,
732: p_data => x_msg_data);
733:
734: EXCEPTION

Line 739: fnd_msg_pub.count_and_get (

735: WHEN fnd_api.g_exc_error THEN
736:
737: ROLLBACK TO update_txn_ext_attrib_dtls;
738: x_return_status := fnd_api.g_ret_sts_error ;
739: fnd_msg_pub.count_and_get (
740: p_count => x_msg_count,
741: p_data => x_msg_data);
742:
743: WHEN fnd_api.g_exc_unexpected_error THEN

Line 748: fnd_msg_pub.count_and_get(

744:
745: ROLLBACK TO update_txn_ext_attrib_dtls;
746: x_return_status := fnd_api.g_ret_sts_unexp_error ;
747:
748: fnd_msg_pub.count_and_get(
749: p_count => x_msg_count,
750: p_data => x_msg_data);
751:
752: WHEN OTHERS THEN

Line 757: IF fnd_msg_pub.Check_Msg_Level(

753:
754: ROLLBACK TO update_txn_ext_attrib_dtls;
755: x_return_status := fnd_api.g_ret_sts_unexp_error ;
756:
757: IF fnd_msg_pub.Check_Msg_Level(
758: p_message_level => fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
759:
760: fnd_msg_pub.Add_Exc_Msg(
761: p_pkg_name => G_PKG_NAME,

Line 758: p_message_level => fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN

754: ROLLBACK TO update_txn_ext_attrib_dtls;
755: x_return_status := fnd_api.g_ret_sts_unexp_error ;
756:
757: IF fnd_msg_pub.Check_Msg_Level(
758: p_message_level => fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
759:
760: fnd_msg_pub.Add_Exc_Msg(
761: p_pkg_name => G_PKG_NAME,
762: p_procedure_name => l_api_name);

Line 760: fnd_msg_pub.Add_Exc_Msg(

756:
757: IF fnd_msg_pub.Check_Msg_Level(
758: p_message_level => fnd_msg_pub.G_MSG_LVL_UNEXP_ERROR) THEN
759:
760: fnd_msg_pub.Add_Exc_Msg(
761: p_pkg_name => G_PKG_NAME,
762: p_procedure_name => l_api_name);
763:
764: END IF;

Line 766: fnd_msg_pub.count_and_get(

762: p_procedure_name => l_api_name);
763:
764: END IF;
765:
766: fnd_msg_pub.count_and_get(
767: p_count => x_msg_count,
768: p_data => x_msg_data);
769:
770: END update_txn_ext_attrib_dtls;

Line 806: fnd_msg_pub.initialize;

802: SAVEPOINT delete_txn_ext_attrib_dtls;
803:
804: -- Initialize message list if p_init_msg_list is set to TRUE.
805: IF fnd_api.to_Boolean( p_init_msg_list ) THEN
806: fnd_msg_pub.initialize;
807: END IF;
808:
809: -- Initialize API return status to success
810: x_return_status := fnd_api.G_RET_STS_SUCCESS;

Line 857: fnd_msg_pub.add;

853: IF l_return_status <> fnd_api.g_ret_sts_success THEN
854:
855: FND_MESSAGE.set_name('CSI','CSI_TXN_EXT_ATTRIB_ID_INVALID');
856: FND_MESSAGE.set_token('EXT_ATT_ID',l_ext_att_id);
857: fnd_msg_pub.add;
858: RAISE fnd_api.g_exc_error;
859:
860: END IF;
861:

Line 887: fnd_msg_pub.add;

883: IF l_return_status <> fnd_api.g_ret_sts_success THEN
884:
885: FND_MESSAGE.set_name('CSI','CSI_TXN_LINE_DTL_ID_INVALID');
886: FND_MESSAGE.set_token('LINE_DTL_ID',l_line_dtl_id);
887: fnd_msg_pub.add;
888: RAISE fnd_api.g_exc_error;
889:
890: END IF;
891:

Line 916: fnd_msg_pub.count_and_get(

912: COMMIT WORK;
913: END IF;
914:
915: -- Standard call to get message count and if count is get message info.
916: fnd_msg_pub.count_and_get(
917: p_count => x_msg_count,
918: p_data => x_msg_data);
919:
920: EXCEPTION

Line 925: fnd_msg_pub.count_and_get (

921: WHEN fnd_api.g_exc_error THEN
922:
923: ROLLBACK TO delete_txn_ext_attrib_dtls;
924: x_return_status := fnd_api.g_ret_sts_error ;
925: fnd_msg_pub.count_and_get (
926: p_count => x_msg_count,
927: p_data => x_msg_data);
928:
929: WHEN fnd_api.g_exc_unexpected_error THEN

Line 934: fnd_msg_pub.count_and_get(

930:
931: ROLLBACK TO delete_txn_ext_attrib_dtls;
932: x_return_status := fnd_api.g_ret_sts_unexp_error ;
933:
934: fnd_msg_pub.count_and_get(
935: p_count => x_msg_count,
936: p_data => x_msg_data);
937:
938: WHEN OTHERS THEN

Line 943: IF fnd_msg_pub.check_msg_level(

939:
940: ROLLBACK TO delete_txn_ext_attrib_dtls;
941: x_return_status := fnd_api.g_ret_sts_unexp_error ;
942:
943: IF fnd_msg_pub.check_msg_level(
944: p_message_level => fnd_msg_pub.g_msg_lvl_unexp_error) THEN
945:
946: fnd_msg_pub.add_exc_msg(
947: p_pkg_name => g_pkg_name,

Line 944: p_message_level => fnd_msg_pub.g_msg_lvl_unexp_error) THEN

940: ROLLBACK TO delete_txn_ext_attrib_dtls;
941: x_return_status := fnd_api.g_ret_sts_unexp_error ;
942:
943: IF fnd_msg_pub.check_msg_level(
944: p_message_level => fnd_msg_pub.g_msg_lvl_unexp_error) THEN
945:
946: fnd_msg_pub.add_exc_msg(
947: p_pkg_name => g_pkg_name,
948: p_procedure_name => l_api_name);

Line 946: fnd_msg_pub.add_exc_msg(

942:
943: IF fnd_msg_pub.check_msg_level(
944: p_message_level => fnd_msg_pub.g_msg_lvl_unexp_error) THEN
945:
946: fnd_msg_pub.add_exc_msg(
947: p_pkg_name => g_pkg_name,
948: p_procedure_name => l_api_name);
949:
950: END IF;

Line 952: fnd_msg_pub.count_and_get(

948: p_procedure_name => l_api_name);
949:
950: END IF;
951:
952: fnd_msg_pub.count_and_get(
953: p_count => x_msg_count,
954: p_data => x_msg_data);
955:
956: END delete_txn_ext_attrib_dtls;

Line 1618: fnd_msg_pub.add;

1614: x_error_msg := 'Unable to derive attribute id .....';
1615: FND_MESSAGE.set_name('CSI','CSI_TXN_TOO_MANY_EXT_ATT');
1616: FND_MESSAGE.set_token('ATTRIB_CODE',p_attrib_code);
1617: FND_MESSAGE.set_token('ATTRIB_LEVEL',p_attrib_level);
1618: fnd_msg_pub.add;
1619: RAISE fnd_api.g_exc_error ;
1620: END IF ;
1621: ELSIF p_attrib_level = 'CATEGORY'
1622: THEN