63: /* check existence */
64: IF check_existence(p_rule_id, p_sequence_number) THEN
65: IF p_action = 'INSERT' THEN
66: fnd_message.set_name('WMS', 'WMS_SORT_CRITERIA_EXISTS');
67: fnd_msg_pub.ADD;
68: RAISE fnd_api.g_exc_error;
69: END IF;
70: ELSE
71: IF p_action IN ('DELETE','LOCK','UPDATE') THEN
69: END IF;
70: ELSE
71: IF p_action IN ('DELETE','LOCK','UPDATE') THEN
72: fnd_message.set_name('WMS', 'WMS_SORT_CRITERIA_NOT_FOUND');
73: fnd_msg_pub.ADD;
74: RAISE fnd_api.g_exc_error;
75: END IF;
76: END IF;
77:
96: end if;
97:
98: IF l_found = FALSE THEN
99: fnd_message.set_name('WMS', 'WMS_RULE_NOT_FOUND');
100: fnd_msg_pub.ADD;
101: RAISE fnd_api.g_exc_error;
102: END IF;
103:
104: -- other input parameters are not validated currently
169: end if;
170:
171: -- Initialize message list if p_init_msg_list is set to TRUE
172: if fnd_api.to_boolean( p_init_msg_list ) then
173: fnd_msg_pub.initialize;
174: end if;
175:
176: /* add validation here */
177: /* get who column information */
246:
247: EXCEPTION
248: when fnd_api.g_exc_error then
249: x_return_status := fnd_api.g_ret_sts_error;
250: fnd_msg_pub.count_and_get( p_count => x_msg_count
251: ,p_data => x_msg_data );
252:
253: when fnd_api.g_exc_unexpected_error then
254: x_return_status := fnd_api.g_ret_sts_unexp_error;
251: ,p_data => x_msg_data );
252:
253: when fnd_api.g_exc_unexpected_error then
254: x_return_status := fnd_api.g_ret_sts_unexp_error;
255: fnd_msg_pub.count_and_get( p_count => x_msg_count
256: ,p_data => x_msg_data );
257:
258: when others then
259: x_return_status := fnd_api.g_ret_sts_unexp_error;
256: ,p_data => x_msg_data );
257:
258: when others then
259: x_return_status := fnd_api.g_ret_sts_unexp_error;
260: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
261: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
262: end if;
263: fnd_msg_pub.count_and_get( p_count => x_msg_count
264: ,p_data => x_msg_data );
257:
258: when others then
259: x_return_status := fnd_api.g_ret_sts_unexp_error;
260: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
261: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
262: end if;
263: fnd_msg_pub.count_and_get( p_count => x_msg_count
264: ,p_data => x_msg_data );
265:
259: x_return_status := fnd_api.g_ret_sts_unexp_error;
260: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
261: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
262: end if;
263: fnd_msg_pub.count_and_get( p_count => x_msg_count
264: ,p_data => x_msg_data );
265:
266: end insert_sort_criteria;
267:
308: end if;
309:
310: -- Initialize message list if p_init_msg_list is set to TRUE
311: if fnd_api.to_boolean( p_init_msg_list ) then
312: fnd_msg_pub.initialize;
313: end if;
314:
315: validate_input
316: (
372:
373: EXCEPTION
374: WHEN fnd_api.g_exc_error THEN
375: x_return_status := fnd_api.g_ret_sts_error;
376: fnd_msg_pub.count_and_get( p_count => x_msg_count
377: ,p_data => x_msg_data );
378:
379: WHEN fnd_api.g_exc_unexpected_error THEN
380: x_return_status := fnd_api.g_ret_sts_unexp_error;
377: ,p_data => x_msg_data );
378:
379: WHEN fnd_api.g_exc_unexpected_error THEN
380: x_return_status := fnd_api.g_ret_sts_unexp_error;
381: fnd_msg_pub.count_and_get( p_count => x_msg_count
382: ,p_data => x_msg_data );
383:
384: WHEN OTHERS THEN
385: x_return_status := fnd_api.g_ret_sts_unexp_error;
382: ,p_data => x_msg_data );
383:
384: WHEN OTHERS THEN
385: x_return_status := fnd_api.g_ret_sts_unexp_error;
386: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
387: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
388: end if;
389: fnd_msg_pub.count_and_get( p_count => x_msg_count
390: ,p_data => x_msg_data );
383:
384: WHEN OTHERS THEN
385: x_return_status := fnd_api.g_ret_sts_unexp_error;
386: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
387: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
388: end if;
389: fnd_msg_pub.count_and_get( p_count => x_msg_count
390: ,p_data => x_msg_data );
391:
385: x_return_status := fnd_api.g_ret_sts_unexp_error;
386: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
387: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
388: end if;
389: fnd_msg_pub.count_and_get( p_count => x_msg_count
390: ,p_data => x_msg_data );
391:
392: end lock_sort_criteria ;
393:
439: end if;
440:
441: -- Initialize message list if p_init_msg_list is set to TRUE
442: if fnd_api.to_boolean( p_init_msg_list ) then
443: fnd_msg_pub.initialize;
444: end if;
445:
446: validate_input
447: (
513:
514: EXCEPTION
515: WHEN fnd_api.g_exc_error THEN
516: x_return_status := fnd_api.g_ret_sts_error;
517: fnd_msg_pub.count_and_get( p_count => x_msg_count
518: ,p_data => x_msg_data );
519:
520: WHEN fnd_api.g_exc_unexpected_error THEN
521: x_return_status := fnd_api.g_ret_sts_unexp_error;
518: ,p_data => x_msg_data );
519:
520: WHEN fnd_api.g_exc_unexpected_error THEN
521: x_return_status := fnd_api.g_ret_sts_unexp_error;
522: fnd_msg_pub.count_and_get( p_count => x_msg_count
523: ,p_data => x_msg_data );
524:
525: when others then
526: x_return_status := fnd_api.g_ret_sts_unexp_error;
523: ,p_data => x_msg_data );
524:
525: when others then
526: x_return_status := fnd_api.g_ret_sts_unexp_error;
527: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
528: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
529: end if;
530: fnd_msg_pub.count_and_get( p_count => x_msg_count
531: ,p_data => x_msg_data );
524:
525: when others then
526: x_return_status := fnd_api.g_ret_sts_unexp_error;
527: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
528: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
529: end if;
530: fnd_msg_pub.count_and_get( p_count => x_msg_count
531: ,p_data => x_msg_data );
532:
526: x_return_status := fnd_api.g_ret_sts_unexp_error;
527: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
528: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
529: end if;
530: fnd_msg_pub.count_and_get( p_count => x_msg_count
531: ,p_data => x_msg_data );
532:
533: end update_sort_criteria ;
534:
559: end if;
560:
561: -- Initialize message list if p_init_msg_list is set to TRUE
562: if fnd_api.to_boolean( p_init_msg_list ) then
563: fnd_msg_pub.initialize;
564: end if;
565:
566: validate_input
567: (
595: raise fnd_api.g_exc_error;
596: end if;
597:
598: wms_sort_criteria_pkg.delete_row(p_rowid);
599: fnd_msg_pub.count_and_get( p_count => x_msg_count
600: ,p_data => x_msg_data );
601: x_return_status := l_return_status;
602:
603: EXCEPTION
602:
603: EXCEPTION
604: WHEN fnd_api.g_exc_error THEN
605: x_return_status := fnd_api.g_ret_sts_error;
606: fnd_msg_pub.count_and_get( p_count => x_msg_count
607: ,p_data => x_msg_data );
608:
609: WHEN fnd_api.g_exc_unexpected_error THEN
610: x_return_status := fnd_api.g_ret_sts_unexp_error;
607: ,p_data => x_msg_data );
608:
609: WHEN fnd_api.g_exc_unexpected_error THEN
610: x_return_status := fnd_api.g_ret_sts_unexp_error;
611: fnd_msg_pub.count_and_get( p_count => x_msg_count
612: ,p_data => x_msg_data );
613:
614: WHEN OTHERS THEN
615: x_return_status := fnd_api.g_ret_sts_unexp_error;
612: ,p_data => x_msg_data );
613:
614: WHEN OTHERS THEN
615: x_return_status := fnd_api.g_ret_sts_unexp_error;
616: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
617: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
618: end if;
619: fnd_msg_pub.count_and_get( p_count => x_msg_count
620: ,p_data => x_msg_data );
613:
614: WHEN OTHERS THEN
615: x_return_status := fnd_api.g_ret_sts_unexp_error;
616: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
617: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
618: end if;
619: fnd_msg_pub.count_and_get( p_count => x_msg_count
620: ,p_data => x_msg_data );
621:
615: x_return_status := fnd_api.g_ret_sts_unexp_error;
616: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
617: fnd_msg_pub.add_exc_msg(g_pkg_name, l_api_name);
618: end if;
619: fnd_msg_pub.count_and_get( p_count => x_msg_count
620: ,p_data => x_msg_data );
621:
622: end delete_sort_criteria ;
623: