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
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:
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 */
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
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 */
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;
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;
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 );
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:
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:
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: (
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;
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;
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 );
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:
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:
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: (
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;
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;
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 );
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:
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:
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: (
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
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;
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;
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 );
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:
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: