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

Line 83: FND_MSG_PUB.add;

79: when no_data_found then
80: null; -- valid system
81: when others then
82: FND_MESSAGE.SET_NAME('CSI', 'CSI_TXN_SYSTEM_DUP_NAME');
83: FND_MSG_PUB.add;
84: x_return_status := fnd_api.g_ret_sts_error;
85: End;
86:
87: /* commented for perf Bug 4907908

Line 93: fnd_msg_pub.add;

89: OPEN dup_cur;
90: FETCH dup_cur INTO l_dummy;
91: IF (dup_cur%FOUND) THEN
92: FND_MESSAGE.SET_NAME('CSI', 'CSI_TXN_SYSTEM_DUP_NAME');
93: fnd_msg_pub.add;
94: x_return_status := fnd_api.g_ret_sts_error;
95: END IF;
96:
97: CLOSE dup_cur;

Line 104: fnd_msg_pub.add;

100: OPEN dup_cur1;
101: FETCH dup_cur1 INTO l_dummy;
102: IF (dup_cur1%FOUND) THEN
103: FND_MESSAGE.SET_NAME('CSI', 'CSI_TXN_SYSTEM_DUP_NAME');
104: fnd_msg_pub.add;
105: x_return_status := fnd_api.g_ret_sts_error;
106: END IF;
107:
108: CLOSE dup_cur1;

Line 135: FND_MSG_PUB.add;

131: when no_data_found then
132: null; -- valid system
133: when others then
134: FND_MESSAGE.SET_NAME('CSI', 'CSI_TXN_SYSTEM_DUP_NAME');
135: FND_MSG_PUB.add;
136: x_return_status := fnd_api.g_ret_sts_error;
137: End;
138:
139: EXCEPTION

Line 182: fnd_msg_pub.initialize;

178:
179: -- initialize message list IF p_init_msg_list IS set to true.
180: IF fnd_api.to_boolean( p_init_msg_list )
181: THEN
182: fnd_msg_pub.initialize;
183: END IF;
184:
185:
186: -- debug message

Line 337: fnd_msg_pub.count_and_get

333:
334:
335:
336: -- standard call to get message count AND IF count IS 1, get message info.
337: fnd_msg_pub.count_and_get
338: ( p_count => x_msg_count,
339: p_data => x_msg_data
340: );
341:

Line 346: fnd_msg_pub.count_and_get

342: EXCEPTION
343: WHEN fnd_api.g_exc_error THEN
344: ROLLBACK TO create_txn_system_pvt;
345: x_return_status := fnd_api.g_ret_sts_error ;
346: fnd_msg_pub.count_and_get
347: (p_count => x_msg_count ,
348: p_data => x_msg_data
349: );
350:

Line 354: fnd_msg_pub.count_and_get

350:
351: WHEN fnd_api.g_exc_unexpected_error THEN
352: ROLLBACK TO create_txn_system_pvt;
353: x_return_status := fnd_api.g_ret_sts_unexp_error ;
354: fnd_msg_pub.count_and_get
355: (p_count => x_msg_count ,
356: p_data => x_msg_data
357: );
358:

Line 362: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

358:
359: WHEN OTHERS THEN
360: ROLLBACK TO create_txn_system_pvt;
361: x_return_status := fnd_api.g_ret_sts_unexp_error ;
362: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
363: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
364: END IF;
365: fnd_msg_pub.count_and_get
366: (p_count => x_msg_count ,

Line 363: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);

359: WHEN OTHERS THEN
360: ROLLBACK TO create_txn_system_pvt;
361: x_return_status := fnd_api.g_ret_sts_unexp_error ;
362: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
363: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
364: END IF;
365: fnd_msg_pub.count_and_get
366: (p_count => x_msg_count ,
367: p_data => x_msg_data

Line 365: fnd_msg_pub.count_and_get

361: x_return_status := fnd_api.g_ret_sts_unexp_error ;
362: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
363: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
364: END IF;
365: fnd_msg_pub.count_and_get
366: (p_count => x_msg_count ,
367: p_data => x_msg_data
368: );
369:

Line 419: fnd_msg_pub.initialize;

415: END IF;
416:
417: IF fnd_api.to_boolean( p_init_msg_list )
418: THEN
419: fnd_msg_pub.initialize;
420: END IF;
421:
422: x_return_status := fnd_api.g_ret_sts_success;
423:

Line 448: fnd_msg_pub.add;

444: FETCH txn_sys_csr INTO l_sys_csr;
445: IF ( (l_sys_csr.object_version_number<>p_txn_system_rec.object_version_number)
446: AND (p_txn_system_rec.object_version_number <> fnd_api.g_miss_num) ) THEN
447: fnd_message.set_name('CSI', 'CSI_RECORD_CHANGED');
448: fnd_msg_pub.add;
449: RAISE fnd_api.g_exc_error;
450: END IF;
451: CLOSE txn_sys_csr;
452:

Line 458: fnd_msg_pub.add;

454: IF p_txn_system_rec.start_date_active <> fnd_api.g_miss_date THEN
455: IF p_txn_system_rec.start_date_active <> l_sys_csr.start_date_active THEN
456: fnd_message.set_name('CSI', 'CSI_UPD_NOT_ALLOWED');
457: fnd_message.set_token('start_date_active',p_txn_system_rec.start_date_active);
458: fnd_msg_pub.add;
459: RAISE fnd_api.g_exc_error;
460: END IF;
461: END IF;
462:

Line 469: fnd_msg_pub.add;

465: IF (p_txn_system_rec.end_date_active = fnd_api.g_miss_date) OR
466: (p_txn_system_rec.end_date_active <= SYSDATE) THEN
467: fnd_message.set_name('CSI', 'CSI_CANT_UPDATE_EXPIRED_SYS');
468: fnd_message.set_token('start_date_active',p_txn_system_rec.end_date_active);
469: fnd_msg_pub.add;
470: RAISE fnd_api.g_exc_error;
471: END IF;
472: END IF;
473:

Line 590: fnd_msg_pub.count_and_get

586: THEN
587: COMMIT WORK;
588: END IF;
589:
590: fnd_msg_pub.count_and_get
591: ( p_count => x_msg_count,
592: p_data => x_msg_data
593: );
594:

Line 599: fnd_msg_pub.count_and_get

595: EXCEPTION
596: WHEN fnd_api.g_exc_error THEN
597: ROLLBACK TO update_txn_system_pvt;
598: x_return_status := fnd_api.g_ret_sts_error ;
599: fnd_msg_pub.count_and_get
600: (p_count => x_msg_count ,
601: p_data => x_msg_data
602: );
603:

Line 607: fnd_msg_pub.count_and_get

603:
604: WHEN fnd_api.g_exc_unexpected_error THEN
605: ROLLBACK TO update_txn_system_pvt;
606: x_return_status := fnd_api.g_ret_sts_unexp_error ;
607: fnd_msg_pub.count_and_get
608: (p_count => x_msg_count ,
609: p_data => x_msg_data
610: );
611:

Line 615: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

611:
612: WHEN OTHERS THEN
613: ROLLBACK TO update_txn_system_pvt;
614: x_return_status := fnd_api.g_ret_sts_unexp_error ;
615: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
616: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
617: END IF;
618: fnd_msg_pub.count_and_get
619: (p_count => x_msg_count ,

Line 616: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);

612: WHEN OTHERS THEN
613: ROLLBACK TO update_txn_system_pvt;
614: x_return_status := fnd_api.g_ret_sts_unexp_error ;
615: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
616: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
617: END IF;
618: fnd_msg_pub.count_and_get
619: (p_count => x_msg_count ,
620: p_data => x_msg_data

Line 618: fnd_msg_pub.count_and_get

614: x_return_status := fnd_api.g_ret_sts_unexp_error ;
615: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
616: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
617: END IF;
618: fnd_msg_pub.count_and_get
619: (p_count => x_msg_count ,
620: p_data => x_msg_data
621: );
622:

Line 657: fnd_msg_pub.initialize;

653:
654:
655: IF fnd_api.to_boolean( p_init_msg_list )
656: THEN
657: fnd_msg_pub.initialize;
658: END IF;
659:
660: x_return_status := fnd_api.g_ret_sts_success;
661:

Line 704: fnd_msg_pub.count_and_get

700: THEN
701: COMMIT WORK;
702: END IF;
703:
704: fnd_msg_pub.count_and_get
705: ( p_count => x_msg_count,
706: p_data => x_msg_data
707: );
708:

Line 713: fnd_msg_pub.count_and_get

709: EXCEPTION
710: WHEN fnd_api.g_exc_error THEN
711: ROLLBACK TO delete_txn_system_pvt;
712: x_return_status := fnd_api.g_ret_sts_error ;
713: fnd_msg_pub.count_and_get
714: (p_count => x_msg_count ,
715: p_data => x_msg_data
716: );
717:

Line 721: fnd_msg_pub.count_and_get

717:
718: WHEN fnd_api.g_exc_unexpected_error THEN
719: ROLLBACK TO delete_txn_system_pvt;
720: x_return_status := fnd_api.g_ret_sts_unexp_error ;
721: fnd_msg_pub.count_and_get
722: (p_count => x_msg_count ,
723: p_data => x_msg_data
724: );
725:

Line 729: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN

725:
726: WHEN OTHERS THEN
727: ROLLBACK TO delete_txn_system_pvt;
728: x_return_status := fnd_api.g_ret_sts_unexp_error ;
729: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
730: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
731: END IF;
732: fnd_msg_pub.count_and_get
733: (p_count => x_msg_count ,

Line 730: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);

726: WHEN OTHERS THEN
727: ROLLBACK TO delete_txn_system_pvt;
728: x_return_status := fnd_api.g_ret_sts_unexp_error ;
729: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
730: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
731: END IF;
732: fnd_msg_pub.count_and_get
733: (p_count => x_msg_count ,
734: p_data => x_msg_data

Line 732: fnd_msg_pub.count_and_get

728: x_return_status := fnd_api.g_ret_sts_unexp_error ;
729: IF fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) THEN
730: fnd_msg_pub.add_exc_msg(g_pkg_name ,l_api_name);
731: END IF;
732: fnd_msg_pub.count_and_get
733: (p_count => x_msg_count ,
734: p_data => x_msg_data
735: );
736: END delete_txn_system;

Line 753: fnd_msg_pub.initialize;

749: BEGIN
750:
751: IF fnd_api.to_boolean( p_init_msg_list )
752: THEN
753: fnd_msg_pub.initialize;
754: END IF;
755: x_return_status := fnd_api.g_ret_sts_success;
756:
757: IF p_validation_mode='CREATE' THEN

Line 768: fnd_msg_pub.add;

764: EXCEPTION
765: WHEN no_data_found THEN
766: fnd_message.set_name('CSI', 'CSI_INVALID_TXN_SYSTEM_ID');
767: fnd_message.set_token('transaction_system_id',p_txn_system_id);
768: fnd_msg_pub.add;
769: x_return_status := fnd_api.g_ret_sts_error;
770: END;
771: END IF;
772:

Line 784: fnd_msg_pub.add;

780: EXCEPTION
781: WHEN no_data_found THEN
782: fnd_message.set_name('CSI', 'CSI_INVALID_TXN_SYSTEM_ID');
783: fnd_message.set_token('transaction_system_id',p_txn_system_id);
784: fnd_msg_pub.add;
785: x_return_status := fnd_api.g_ret_sts_error;
786: END;
787: ELSE
788: fnd_message.set_name('CSI', 'CSI_NO_TXN_SYSTEM_ID');

Line 789: fnd_msg_pub.add;

785: x_return_status := fnd_api.g_ret_sts_error;
786: END;
787: ELSE
788: fnd_message.set_name('CSI', 'CSI_NO_TXN_SYSTEM_ID');
789: fnd_msg_pub.add;
790: x_return_status := fnd_api.g_ret_sts_error;
791: END IF;
792:
793: END IF;

Line 795: fnd_msg_pub.count_and_get

791: END IF;
792:
793: END IF;
794:
795: fnd_msg_pub.count_and_get
796: ( p_count => x_msg_count,
797: p_data => x_msg_data
798: );
799:

Line 815: fnd_msg_pub.initialize;

811: l_dummy VARCHAR2(1);
812: BEGIN
813: IF fnd_api.to_boolean( p_init_msg_list )
814: THEN
815: fnd_msg_pub.initialize;
816: END IF;
817: x_return_status := fnd_api.g_ret_sts_success;
818:
819: IF(p_validation_mode = 'UPDATE') THEN

Line 822: fnd_msg_pub.add;

818:
819: IF(p_validation_mode = 'UPDATE') THEN
820: IF ( (p_object_version_number IS NULL) OR (p_object_version_number = fnd_api.g_miss_num) ) THEN
821: fnd_message.set_name('CSI', 'CSI_MISSING_OBJ_VER_NUM');
822: fnd_msg_pub.add;
823: x_return_status := fnd_api.g_ret_sts_error;
824: END IF;
825: END IF;
826:

Line 827: fnd_msg_pub.count_and_get

823: x_return_status := fnd_api.g_ret_sts_error;
824: END IF;
825: END IF;
826:
827: fnd_msg_pub.count_and_get
828: ( p_count => x_msg_count,
829: p_data => x_msg_data
830: );
831:

Line 850: fnd_msg_pub.initialize;

846: l_end_date DATE;
847: BEGIN
848: IF fnd_api.to_boolean( p_init_msg_list )
849: THEN
850: fnd_msg_pub.initialize;
851: END IF;
852: x_return_status := fnd_api.g_ret_sts_success;
853: IF p_validation_mode='CREATE' THEN
854: IF ((p_start_date = FND_API.G_MISS_DATE) OR (p_start_date IS NULL)) THEN

Line 868: fnd_msg_pub.Add;

864: IF (l_end_date IS NOT NULL) THEN
865: IF (l_start_date > l_end_date) THEN
866: fnd_message.set_name('CSI','CSI_API_INVALID_START_DATE');
867: fnd_message.set_token('START_DATE_ACTIVE',l_start_date);
868: fnd_msg_pub.Add;
869: x_return_status := fnd_api.g_ret_sts_error;
870: END IF;
871: END IF;
872: END IF;

Line 873: fnd_msg_pub.count_and_get

869: x_return_status := fnd_api.g_ret_sts_error;
870: END IF;
871: END IF;
872: END IF;
873: fnd_msg_pub.count_and_get
874: ( p_count => x_msg_count,
875: p_data => x_msg_data
876: );
877:

Line 896: fnd_msg_pub.initialize;

892: l_end_date DATE;
893: BEGIN
894: IF fnd_api.to_boolean( p_init_msg_list )
895: THEN
896: fnd_msg_pub.initialize;
897: END IF;
898: x_return_status := fnd_api.g_ret_sts_success;
899: IF ( (p_validation_mode='CREATE') OR (p_validation_mode='UPDATE') ) THEN
900: IF (p_end_date = FND_API.G_MISS_DATE) THEN

Line 909: fnd_msg_pub.Add;

905: IF (l_end_date IS NOT NULL) THEN
906: IF l_end_date < SYSDATE THEN
907: fnd_message.set_name('CSI','CSI_API_INVALID_END_DATE');
908: fnd_message.set_token('END_DATE_ACTIVE',l_end_date);
909: fnd_msg_pub.Add;
910: x_return_status := fnd_api.g_ret_sts_error;
911: END IF;
912: END IF;
913: END IF;

Line 914: fnd_msg_pub.count_and_get

910: x_return_status := fnd_api.g_ret_sts_error;
911: END IF;
912: END IF;
913: END IF;
914: fnd_msg_pub.count_and_get
915: ( p_count => x_msg_count,
916: p_data => x_msg_data
917: );
918: