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

Line 77: fnd_msg_pub.ADD;

73: /* check existence */
74: IF check_existence(p_rule_id, p_sequence_number) THEN
75: IF p_action = 'INSERT' THEN
76: fnd_message.set_name('WMS', 'WMS_RESTRICTION_EXISTS');
77: fnd_msg_pub.ADD;
78: RAISE fnd_api.g_exc_error;
79: END IF;
80: ELSE
81: IF p_action IN ('DELETE','LOCK','UPDATE') THEN

Line 83: fnd_msg_pub.ADD;

79: END IF;
80: ELSE
81: IF p_action IN ('DELETE','LOCK','UPDATE') THEN
82: fnd_message.set_name('WMS', 'WMS_RESTRICTION_NOT_FOUND');
83: fnd_msg_pub.ADD;
84: RAISE fnd_api.g_exc_error;
85: END IF;
86: END IF;
87:

Line 110: fnd_msg_pub.ADD;

106: end if;
107:
108: IF l_found = FALSE THEN
109: fnd_message.set_name('WMS', 'WMS_RULE_NOT_FOUND');
110: fnd_msg_pub.ADD;
111: RAISE fnd_api.g_exc_error;
112: END IF;
113:
114: /* validate p_parameter_id */

Line 132: -- fnd_msg_pub.ADD;

128: -- end if;
129:
130: -- IF l_found = FALSE THEN
131: -- fnd_message.set_name('WMS', 'WMS_PARAMETER_NOT_FOUND');
132: -- fnd_msg_pub.ADD;
133: -- RAISE fnd_api.g_exc_error;
134: -- END IF;
135:
136: -- other input parameters are not validated currently

Line 214: fnd_msg_pub.initialize;

210: end if;
211:
212: -- Initialize message list if p_init_msg_list is set to TRUE
213: if fnd_api.to_boolean( p_init_msg_list ) then
214: fnd_msg_pub.initialize;
215: end if;
216:
217: /* add validation here */
218: /* get who column information */

Line 311: fnd_msg_pub.count_and_get( p_count => x_msg_count

307:
308: EXCEPTION
309: when fnd_api.g_exc_error then
310: x_return_status := fnd_api.g_ret_sts_error;
311: fnd_msg_pub.count_and_get( p_count => x_msg_count
312: ,p_data => x_msg_data );
313:
314: when fnd_api.g_exc_unexpected_error then
315: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 316: fnd_msg_pub.count_and_get( p_count => x_msg_count

312: ,p_data => x_msg_data );
313:
314: when fnd_api.g_exc_unexpected_error then
315: x_return_status := fnd_api.g_ret_sts_unexp_error;
316: fnd_msg_pub.count_and_get( p_count => x_msg_count
317: ,p_data => x_msg_data );
318:
319: when others then
320: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

317: ,p_data => x_msg_data );
318:
319: when others then
320: x_return_status := fnd_api.g_ret_sts_unexp_error;
321: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
322: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
323: end if;
324: fnd_msg_pub.count_and_get( p_count => x_msg_count
325: ,p_data => x_msg_data );

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

318:
319: when others then
320: x_return_status := fnd_api.g_ret_sts_unexp_error;
321: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
322: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
323: end if;
324: fnd_msg_pub.count_and_get( p_count => x_msg_count
325: ,p_data => x_msg_data );
326:

Line 324: fnd_msg_pub.count_and_get( p_count => x_msg_count

320: x_return_status := fnd_api.g_ret_sts_unexp_error;
321: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
322: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
323: end if;
324: fnd_msg_pub.count_and_get( p_count => x_msg_count
325: ,p_data => x_msg_data );
326:
327: end insert_restriction;
328:

Line 383: fnd_msg_pub.initialize;

379: end if;
380:
381: -- Initialize message list if p_init_msg_list is set to TRUE
382: if fnd_api.to_boolean( p_init_msg_list ) then
383: fnd_msg_pub.initialize;
384: end if;
385:
386: validate_input
387: (

Line 467: fnd_msg_pub.count_and_get( p_count => x_msg_count

463:
464: EXCEPTION
465: WHEN fnd_api.g_exc_error THEN
466: x_return_status := fnd_api.g_ret_sts_error;
467: fnd_msg_pub.count_and_get( p_count => x_msg_count
468: ,p_data => x_msg_data );
469:
470: WHEN fnd_api.g_exc_unexpected_error THEN
471: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 472: fnd_msg_pub.count_and_get( p_count => x_msg_count

468: ,p_data => x_msg_data );
469:
470: WHEN fnd_api.g_exc_unexpected_error THEN
471: x_return_status := fnd_api.g_ret_sts_unexp_error;
472: fnd_msg_pub.count_and_get( p_count => x_msg_count
473: ,p_data => x_msg_data );
474:
475: WHEN OTHERS THEN
476: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

473: ,p_data => x_msg_data );
474:
475: WHEN OTHERS THEN
476: x_return_status := fnd_api.g_ret_sts_unexp_error;
477: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
478: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
479: end if;
480: fnd_msg_pub.count_and_get( p_count => x_msg_count
481: ,p_data => x_msg_data );

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

474:
475: WHEN OTHERS THEN
476: x_return_status := fnd_api.g_ret_sts_unexp_error;
477: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
478: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
479: end if;
480: fnd_msg_pub.count_and_get( p_count => x_msg_count
481: ,p_data => x_msg_data );
482:

Line 480: fnd_msg_pub.count_and_get( p_count => x_msg_count

476: x_return_status := fnd_api.g_ret_sts_unexp_error;
477: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
478: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
479: end if;
480: fnd_msg_pub.count_and_get( p_count => x_msg_count
481: ,p_data => x_msg_data );
482:
483: end lock_restriction ;
484:

Line 544: fnd_msg_pub.initialize;

540: end if;
541:
542: -- Initialize message list if p_init_msg_list is set to TRUE
543: if fnd_api.to_boolean( p_init_msg_list ) then
544: fnd_msg_pub.initialize;
545: end if;
546:
547: validate_input
548: (

Line 638: fnd_msg_pub.count_and_get( p_count => x_msg_count

634:
635: EXCEPTION
636: WHEN fnd_api.g_exc_error THEN
637: x_return_status := fnd_api.g_ret_sts_error;
638: fnd_msg_pub.count_and_get( p_count => x_msg_count
639: ,p_data => x_msg_data );
640:
641: WHEN fnd_api.g_exc_unexpected_error THEN
642: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 643: fnd_msg_pub.count_and_get( p_count => x_msg_count

639: ,p_data => x_msg_data );
640:
641: WHEN fnd_api.g_exc_unexpected_error THEN
642: x_return_status := fnd_api.g_ret_sts_unexp_error;
643: fnd_msg_pub.count_and_get( p_count => x_msg_count
644: ,p_data => x_msg_data );
645:
646: when others then
647: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

644: ,p_data => x_msg_data );
645:
646: when others then
647: x_return_status := fnd_api.g_ret_sts_unexp_error;
648: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
649: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
650: end if;
651: fnd_msg_pub.count_and_get( p_count => x_msg_count
652: ,p_data => x_msg_data );

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

645:
646: when others then
647: x_return_status := fnd_api.g_ret_sts_unexp_error;
648: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
649: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
650: end if;
651: fnd_msg_pub.count_and_get( p_count => x_msg_count
652: ,p_data => x_msg_data );
653:

Line 651: fnd_msg_pub.count_and_get( p_count => x_msg_count

647: x_return_status := fnd_api.g_ret_sts_unexp_error;
648: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
649: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
650: end if;
651: fnd_msg_pub.count_and_get( p_count => x_msg_count
652: ,p_data => x_msg_data );
653:
654: end update_restriction ;
655:

Line 684: fnd_msg_pub.initialize;

680: end if;
681:
682: -- Initialize message list if p_init_msg_list is set to TRUE
683: if fnd_api.to_boolean( p_init_msg_list ) then
684: fnd_msg_pub.initialize;
685: end if;
686:
687: validate_input
688: (

Line 730: fnd_msg_pub.count_and_get( p_count => x_msg_count

726: raise fnd_api.g_exc_error;
727: end if;
728:
729: wms_restrictions_pkg.delete_row(p_rowid);
730: fnd_msg_pub.count_and_get( p_count => x_msg_count
731: ,p_data => x_msg_data );
732: x_return_status := l_return_status;
733:
734: EXCEPTION

Line 737: fnd_msg_pub.count_and_get( p_count => x_msg_count

733:
734: EXCEPTION
735: WHEN fnd_api.g_exc_error THEN
736: x_return_status := fnd_api.g_ret_sts_error;
737: fnd_msg_pub.count_and_get( p_count => x_msg_count
738: ,p_data => x_msg_data );
739:
740: WHEN fnd_api.g_exc_unexpected_error THEN
741: x_return_status := fnd_api.g_ret_sts_unexp_error;

Line 742: fnd_msg_pub.count_and_get( p_count => x_msg_count

738: ,p_data => x_msg_data );
739:
740: WHEN fnd_api.g_exc_unexpected_error THEN
741: x_return_status := fnd_api.g_ret_sts_unexp_error;
742: fnd_msg_pub.count_and_get( p_count => x_msg_count
743: ,p_data => x_msg_data );
744:
745: WHEN OTHERS THEN
746: x_return_status := fnd_api.g_ret_sts_unexp_error;

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

743: ,p_data => x_msg_data );
744:
745: WHEN OTHERS THEN
746: x_return_status := fnd_api.g_ret_sts_unexp_error;
747: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
748: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
749: end if;
750: fnd_msg_pub.count_and_get( p_count => x_msg_count
751: ,p_data => x_msg_data );

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

744:
745: WHEN OTHERS THEN
746: x_return_status := fnd_api.g_ret_sts_unexp_error;
747: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
748: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
749: end if;
750: fnd_msg_pub.count_and_get( p_count => x_msg_count
751: ,p_data => x_msg_data );
752:

Line 750: fnd_msg_pub.count_and_get( p_count => x_msg_count

746: x_return_status := fnd_api.g_ret_sts_unexp_error;
747: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
748: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
749: end if;
750: fnd_msg_pub.count_and_get( p_count => x_msg_count
751: ,p_data => x_msg_data );
752:
753: end delete_restriction ;
754: