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

Line 68: fnd_msg_pub.ADD;

64: /* check existence */
65: IF p_action IN ('DELETE','LOCK','UPDATE') THEN
66: IF check_existence(p_rule_id) THEN
67: fnd_message.set_name('WMS', 'WMS_RULE_NOT_FOUND');
68: fnd_msg_pub.ADD;
69: RAISE fnd_api.g_exc_error;
70: END IF;
71: END IF;
72:

Line 82: fnd_msg_pub.ADD;

78: /* validate enabled_flag */
79: IF p_enabled_flag NOT IN ('Y', 'N') THEN
80: fnd_message.set_name('WMS', 'WMS_INVALID_ENABLED_FLAG');
81: fnd_message.set_token('FLAG',p_enabled_flag);
82: fnd_msg_pub.ADD;
83: RAISE fnd_api.g_exc_error;
84: END IF;
85:
86: /* validate user_defined_flag */

Line 90: fnd_msg_pub.ADD;

86: /* validate user_defined_flag */
87: IF p_user_defined_flag NOT IN ('Y', 'N') THEN
88: fnd_message.set_name('WMS', 'WMS_INVALID_USER_DEFINED_FLAG');
89: fnd_message.set_token('FLAG',p_user_defined_flag);
90: fnd_msg_pub.ADD;
91: RAISE fnd_api.g_exc_error;
92: END IF;
93:
94: /*commented out on 12/6/99 by jcearley, since type code can be > 2*/

Line 98: -- fnd_msg_pub.ADD;

94: /*commented out on 12/6/99 by jcearley, since type code can be > 2*/
95: /* validate type code */
96: -- IF p_type_code NOT IN (1,2) THEN
97: -- fnd_message.set_name('WMS','WMS_INVALID_PP_TYPE_CODE');
98: -- fnd_msg_pub.ADD;
99: -- RAISE fnd_api.g_exc_error;
100: -- END IF;
101:
102: /* validate qty parameter id */

Line 105: -- fnd_msg_pub.ADD;

101:
102: /* validate qty parameter id */
103: -- IF wms_parameter_form_pkg(p_qty_function_parameter_id) THEN
104: -- fnd_message.set_name('WMS','WMS_INVALID_QTY_PARAMETER');
105: -- fnd_msg_pub.ADD;
106: -- RAISE fnd_api.g_exc_error;
107: -- END IF;
108: END IF;
109:

Line 115: -- fnd_msg_pub.ADD;

111: /* delete is not allowed */
112: -- IF p_action = 'DELETE' THEN
113: -- IF wms_strategy_form_pkg.rule_in_used(rule_id) THEN
114: -- fnd_message.set_name('WMS','WMS_RULE_IN_USE');
115: -- fnd_msg_pub.ADD;
116: -- RAISE fnd_api.g_exc_error;
117: -- END IF;
118: -- END IF;
119: x_return_status := l_return_status;

Line 192: fnd_msg_pub.initialize;

188: end if;
189:
190: -- Initialize message list if p_init_msg_list is set to TRUE
191: if fnd_api.to_boolean( p_init_msg_list ) then
192: fnd_msg_pub.initialize;
193: end if;
194:
195: SELECT wms_rules_s.NEXTVAL INTO l_rule_id FROM dual;
196:

Line 284: fnd_msg_pub.count_and_get( p_count => x_msg_count

280:
281: EXCEPTION
282: when fnd_api.g_exc_error then
283: x_return_status := fnd_api.g_ret_sts_error;
284: fnd_msg_pub.count_and_get( p_count => x_msg_count
285: ,p_data => x_msg_data );
286:
287: when fnd_api.g_exc_unexpected_error then
288: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 289: fnd_msg_pub.count_and_get( p_count => x_msg_count

285: ,p_data => x_msg_data );
286:
287: when fnd_api.g_exc_unexpected_error then
288: x_return_status := fnd_api.g_ret_sts_unexp_error;
289: fnd_msg_pub.count_and_get( p_count => x_msg_count
290: ,p_data => x_msg_data );
291:
292: when others then
293: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 294: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then

290: ,p_data => x_msg_data );
291:
292: when others then
293: x_return_status := fnd_api.g_ret_sts_unexp_error;
294: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
295: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
296: end if;
297: fnd_msg_pub.count_and_get( p_count => x_msg_count
298: ,p_data => x_msg_data );

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

291:
292: when others then
293: x_return_status := fnd_api.g_ret_sts_unexp_error;
294: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
295: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
296: end if;
297: fnd_msg_pub.count_and_get( p_count => x_msg_count
298: ,p_data => x_msg_data );
299:

Line 297: fnd_msg_pub.count_and_get( p_count => x_msg_count

293: x_return_status := fnd_api.g_ret_sts_unexp_error;
294: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
295: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
296: end if;
297: fnd_msg_pub.count_and_get( p_count => x_msg_count
298: ,p_data => x_msg_data );
299:
300: end insert_rule;
301:

Line 353: fnd_msg_pub.initialize;

349: end if;
350:
351: -- Initialize message list if p_init_msg_list is set to TRUE
352: if fnd_api.to_boolean( p_init_msg_list ) then
353: fnd_msg_pub.initialize;
354: end if;
355:
356: validate_input
357: (

Line 430: fnd_msg_pub.ADD;

426:
427: EXCEPTION
428: WHEN no_data_found THEN
429: fnd_message.set_name('WMS','WMS_RULE_NOT_FOUND');
430: fnd_msg_pub.ADD;
431: x_return_status := fnd_api.g_ret_sts_unexp_error;
432:
433: WHEN OTHERS THEN
434: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 435: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then

431: x_return_status := fnd_api.g_ret_sts_unexp_error;
432:
433: WHEN OTHERS THEN
434: x_return_status := fnd_api.g_ret_sts_unexp_error;
435: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
436: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
437: end if;
438: fnd_msg_pub.count_and_get( p_count => x_msg_count
439: ,p_data => x_msg_data );

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

432:
433: WHEN OTHERS THEN
434: x_return_status := fnd_api.g_ret_sts_unexp_error;
435: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
436: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
437: end if;
438: fnd_msg_pub.count_and_get( p_count => x_msg_count
439: ,p_data => x_msg_data );
440:

Line 438: fnd_msg_pub.count_and_get( p_count => x_msg_count

434: x_return_status := fnd_api.g_ret_sts_unexp_error;
435: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
436: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
437: end if;
438: fnd_msg_pub.count_and_get( p_count => x_msg_count
439: ,p_data => x_msg_data );
440:
441: end lock_rule ;
442:

Line 502: fnd_msg_pub.initialize;

498: end if;
499:
500: -- Initialize message list if p_init_msg_list is set to TRUE
501: if fnd_api.to_boolean( p_init_msg_list ) then
502: fnd_msg_pub.initialize;
503: end if;
504:
505: validate_input
506: (

Line 588: fnd_msg_pub.count_and_get( p_count => x_msg_count

584:
585: EXCEPTION
586: when fnd_api.g_exc_error then
587: x_return_status := fnd_api.g_ret_sts_error;
588: fnd_msg_pub.count_and_get( p_count => x_msg_count
589: ,p_data => x_msg_data );
590:
591: when fnd_api.g_exc_unexpected_error then
592: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 593: fnd_msg_pub.count_and_get( p_count => x_msg_count

589: ,p_data => x_msg_data );
590:
591: when fnd_api.g_exc_unexpected_error then
592: x_return_status := fnd_api.g_ret_sts_unexp_error;
593: fnd_msg_pub.count_and_get( p_count => x_msg_count
594: ,p_data => x_msg_data );
595:
596: when others then
597: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 598: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then

594: ,p_data => x_msg_data );
595:
596: when others then
597: x_return_status := fnd_api.g_ret_sts_unexp_error;
598: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
599: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
600: end if;
601: fnd_msg_pub.count_and_get( p_count => x_msg_count
602: ,p_data => x_msg_data );

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

595:
596: when others then
597: x_return_status := fnd_api.g_ret_sts_unexp_error;
598: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
599: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
600: end if;
601: fnd_msg_pub.count_and_get( p_count => x_msg_count
602: ,p_data => x_msg_data );
603:

Line 601: fnd_msg_pub.count_and_get( p_count => x_msg_count

597: x_return_status := fnd_api.g_ret_sts_unexp_error;
598: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
599: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
600: end if;
601: fnd_msg_pub.count_and_get( p_count => x_msg_count
602: ,p_data => x_msg_data );
603:
604: end update_rule ;
605:

Line 637: fnd_msg_pub.initialize;

633: end if;
634:
635: -- Initialize message list if p_init_msg_list is set to TRUE
636: if fnd_api.to_boolean( p_init_msg_list ) then
637: fnd_msg_pub.initialize;
638: end if;
639:
640: OPEN l_cur;
641: FETCH l_cur INTO l_dummy;

Line 653: fnd_msg_pub.count_and_get( p_count => x_msg_count

649:
650: EXCEPTION
651: when fnd_api.g_exc_error then
652: x_return_status := fnd_api.g_ret_sts_error;
653: fnd_msg_pub.count_and_get( p_count => x_msg_count
654: ,p_data => x_msg_data );
655:
656: when fnd_api.g_exc_unexpected_error then
657: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 658: fnd_msg_pub.count_and_get( p_count => x_msg_count

654: ,p_data => x_msg_data );
655:
656: when fnd_api.g_exc_unexpected_error then
657: x_return_status := fnd_api.g_ret_sts_unexp_error;
658: fnd_msg_pub.count_and_get( p_count => x_msg_count
659: ,p_data => x_msg_data );
660:
661: when others then
662: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 663: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then

659: ,p_data => x_msg_data );
660:
661: when others then
662: x_return_status := fnd_api.g_ret_sts_unexp_error;
663: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
664: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
665: end if;
666: fnd_msg_pub.count_and_get( p_count => x_msg_count
667: ,p_data => x_msg_data );

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

660:
661: when others then
662: x_return_status := fnd_api.g_ret_sts_unexp_error;
663: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
664: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
665: end if;
666: fnd_msg_pub.count_and_get( p_count => x_msg_count
667: ,p_data => x_msg_data );
668:

Line 666: fnd_msg_pub.count_and_get( p_count => x_msg_count

662: x_return_status := fnd_api.g_ret_sts_unexp_error;
663: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
664: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
665: end if;
666: fnd_msg_pub.count_and_get( p_count => x_msg_count
667: ,p_data => x_msg_data );
668:
669: END find_rule;
670:

Line 696: fnd_msg_pub.initialize;

692: end if;
693:
694: -- Initialize message list if p_init_msg_list is set to TRUE
695: if fnd_api.to_boolean( p_init_msg_list ) then
696: fnd_msg_pub.initialize;
697: end if;
698:
699: SAVEPOINT delete_rule_sa;
700:

Line 751: fnd_msg_pub.count_and_get( p_count => x_msg_count

747: EXCEPTION
748: when fnd_api.g_exc_error THEN
749: ROLLBACK TO delete_rule_sa;
750: x_return_status := fnd_api.g_ret_sts_error;
751: fnd_msg_pub.count_and_get( p_count => x_msg_count
752: ,p_data => x_msg_data );
753:
754: when fnd_api.g_exc_unexpected_error then
755: ROLLBACK TO delete_rule_sa;

Line 757: fnd_msg_pub.count_and_get( p_count => x_msg_count

753:
754: when fnd_api.g_exc_unexpected_error then
755: ROLLBACK TO delete_rule_sa;
756: x_return_status := fnd_api.g_ret_sts_unexp_error;
757: fnd_msg_pub.count_and_get( p_count => x_msg_count
758: ,p_data => x_msg_data );
759:
760: WHEN OTHERS THEN
761: ROLLBACK TO delete_rule_sa;

Line 763: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then

759:
760: WHEN OTHERS THEN
761: ROLLBACK TO delete_rule_sa;
762: x_return_status := fnd_api.g_ret_sts_unexp_error;
763: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
764: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
765: end if;
766: fnd_msg_pub.count_and_get( p_count => x_msg_count
767: ,p_data => x_msg_data );

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

760: WHEN OTHERS THEN
761: ROLLBACK TO delete_rule_sa;
762: x_return_status := fnd_api.g_ret_sts_unexp_error;
763: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
764: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
765: end if;
766: fnd_msg_pub.count_and_get( p_count => x_msg_count
767: ,p_data => x_msg_data );
768:

Line 766: fnd_msg_pub.count_and_get( p_count => x_msg_count

762: x_return_status := fnd_api.g_ret_sts_unexp_error;
763: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
764: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
765: end if;
766: fnd_msg_pub.count_and_get( p_count => x_msg_count
767: ,p_data => x_msg_data );
768:
769: end delete_rule ;
770:

Line 938: fnd_msg_pub.initialize;

934: end if;
935:
936: -- Initialize message list if p_init_msg_list is set to TRUE
937: if fnd_api.to_boolean( p_init_msg_list ) then
938: fnd_msg_pub.initialize;
939: end if;
940:
941: SAVEPOINT copy_rule_sp;
942:

Line 948: fnd_msg_pub.ADD;

944: OPEN l_orig_rule_cur;
945: FETCH l_orig_rule_cur INTO l_rule_rec;
946: IF l_orig_rule_cur%NOTFOUND THEN
947: fnd_message.set_name('WMS','WMS_RULE_NOT_FOUND');
948: fnd_msg_pub.ADD;
949: RAISE fnd_api.g_exc_error;
950: END IF;
951:
952: /* no validation is done here */

Line 1179: fnd_msg_pub.count_and_get( p_count => x_msg_count

1175: CLOSE l_orig_consistency_cur;
1176: END IF;
1177:
1178: x_return_status := fnd_api.g_ret_sts_error;
1179: fnd_msg_pub.count_and_get( p_count => x_msg_count
1180: ,p_data => x_msg_data );
1181:
1182: when fnd_api.g_exc_unexpected_error then
1183: ROLLBACK TO copy_rule_sp;

Line 1199: fnd_msg_pub.count_and_get( p_count => x_msg_count

1195: CLOSE l_orig_consistency_cur;
1196: END IF;
1197:
1198: x_return_status := fnd_api.g_ret_sts_unexp_error;
1199: fnd_msg_pub.count_and_get( p_count => x_msg_count
1200: ,p_data => x_msg_data );
1201:
1202: when others then
1203: ROLLBACK TO copy_rule_sp;

Line 1219: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then

1215: CLOSE l_orig_consistency_cur;
1216: END IF;
1217:
1218: x_return_status := fnd_api.g_ret_sts_unexp_error;
1219: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
1220: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1221: end if;
1222:
1223: END copy_rule;

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

1216: END IF;
1217:
1218: x_return_status := fnd_api.g_ret_sts_unexp_error;
1219: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
1220: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
1221: end if;
1222:
1223: END copy_rule;
1224: