DBA Data[Home] [Help]

APPS.QA_SKIPLOT_RCV_GRP dependencies on QA_SKIPLOT_RCV_GRP

Line 1: PACKAGE BODY QA_SKIPLOT_RCV_GRP AS

1: PACKAGE BODY QA_SKIPLOT_RCV_GRP AS
2: /* $Header: qaslrcvb.pls 120.0.12000000.2 2007/07/05 11:35:26 bhsankar ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30):= 'QA_SKIPLOT_RCV_GRP';
5:

Line 4: g_pkg_name CONSTANT VARCHAR2(30):= 'QA_SKIPLOT_RCV_GRP';

1: PACKAGE BODY QA_SKIPLOT_RCV_GRP AS
2: /* $Header: qaslrcvb.pls 120.0.12000000.2 2007/07/05 11:35:26 bhsankar ship $ */
3:
4: g_pkg_name CONSTANT VARCHAR2(30):= 'QA_SKIPLOT_RCV_GRP';
5:
6: PROCEDURE CHECK_AVAILABILITY
7: (p_api_version IN NUMBER, -- 1.0
8: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

Line 60: p_module_name => 'QA_SKIPLOT_RCV_GRP.CHECK_AVAILABILITY',

56: qa_skiplot_utility.RCV,
57: p_organization_id);
58:
59: qa_skiplot_utility.insert_error_log (
60: p_module_name => 'QA_SKIPLOT_RCV_GRP.CHECK_AVAILABILITY',
61: p_error_message => 'no error ',
62: p_comments => 'availability=' || x_qa_availability);
63:
64:

Line 72: p_module_name => 'QA_SKIPLOT_RCV_GRP.CHECK_AVAILABILITY',

68: WHEN FND_API.G_EXC_ERROR THEN
69: x_return_status := fnd_api.g_ret_sts_error;
70:
71: qa_skiplot_utility.insert_error_log (
72: p_module_name => 'QA_SKIPLOT_RCV_GRP.CHECK_AVAILABILITY',
73: p_error_message => 'FND_API.G_EXC_ERROR ',
74: p_comments => SUBSTR (SQLERRM , 1 , 240));
75:
76: --

Line 89: p_module_name => 'QA_SKIPLOT_RCV_GRP.CHECK_AVAILABILITY',

85: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
86: x_return_status := fnd_api.g_ret_sts_unexp_error ;
87:
88: qa_skiplot_utility.insert_error_log (
89: p_module_name => 'QA_SKIPLOT_RCV_GRP.CHECK_AVAILABILITY',
90: p_error_message => 'FND_API.G_EXC_UNEXPECTED_ERROR',
91: p_comments => SUBSTR (SQLERRM , 1 , 240));
92:
93: --

Line 110: p_module_name => 'QA_SKIPLOT_RCV_GRP.CHECK_AVAILABILITY',

106: fnd_msg_pub.add_exc_msg (g_pkg_name , l_api_name);
107: end if;
108:
109: qa_skiplot_utility.insert_error_log (
110: p_module_name => 'QA_SKIPLOT_RCV_GRP.CHECK_AVAILABILITY',
111: p_error_message => 'OTHERS exception',
112: p_comments => SUBSTR (SQLERRM , 1 , 240));
113:
114: --

Line 406: p_module_name => 'QA_SKIPLOT_RCV_GRP.EVALUATE_LOT',

402: p_count => x_msg_count,
403: p_data => x_msg_data);
404:
405: qa_skiplot_utility.insert_error_log (
406: p_module_name => 'QA_SKIPLOT_RCV_GRP.EVALUATE_LOT',
407: p_error_message => 'FND_API.G_EXC_ERROR',
408: p_comments => SUBSTR (SQLERRM , 1 , 240));
409:
410: x_evaluation_result := 'INSPECT';

Line 423: p_module_name => 'QA_SKIPLOT_RCV_GRP.EVALUATE_LOT',

419: p_count => x_msg_count,
420: p_data => x_msg_data);
421:
422: qa_skiplot_utility.insert_error_log (
423: p_module_name => 'QA_SKIPLOT_RCV_GRP.EVALUATE_LOT',
424: p_error_message => 'FND_API.G_EXC_UNEXPECTED_ERROR',
425: p_comments => SUBSTR (SQLERRM , 1 , 240));
426:
427: x_evaluation_result := 'INSPECT';

Line 437: p_module_name => 'QA_SKIPLOT_RCV_GRP.EVALUATE_LOT',

433: fnd_msg_pub.add_exc_msg (g_pkg_name , l_api_name);
434: end if;
435:
436: qa_skiplot_utility.insert_error_log (
437: p_module_name => 'QA_SKIPLOT_RCV_GRP.EVALUATE_LOT',
438: p_error_message => 'OTHERS exception ',
439: p_comments => SUBSTR (SQLERRM , 1 , 240));
440:
441: --

Line 530: p_module_name => 'QA_SKIPLOT_RCV_GRP.MATCH_SHIPMENT',

526: WHEN FND_API.G_EXC_ERROR THEN
527: x_return_status := fnd_api.g_ret_sts_error;
528:
529: qa_skiplot_utility.insert_error_log (
530: p_module_name => 'QA_SKIPLOT_RCV_GRP.MATCH_SHIPMENT',
531: p_error_message => 'FND_API.G_EXC_ERROR ',
532: p_comments => SUBSTR (SQLERRM , 1 , 240));
533:
534: --

Line 545: p_module_name => 'QA_SKIPLOT_RCV_GRP.MATCH_SHIPMENT',

541: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
542: x_return_status := fnd_api.g_ret_sts_unexp_error ;
543:
544: qa_skiplot_utility.insert_error_log (
545: p_module_name => 'QA_SKIPLOT_RCV_GRP.MATCH_SHIPMENT',
546: p_error_message => 'FND_API.G_EXC_UNEXPECTED_ERROR ',
547: p_comments => SUBSTR (SQLERRM , 1 , 240));
548:
549: --

Line 564: p_module_name => 'QA_SKIPLOT_RCV_GRP.MATCH_SHIPMENT',

560: fnd_msg_pub.add_exc_msg (g_pkg_name , l_api_name);
561: end if;
562:
563: qa_skiplot_utility.insert_error_log (
564: p_module_name => 'QA_SKIPLOT_RCV_GRP.MATCH_SHIPMENT',
565: p_error_message => 'OTHERS exception ',
566: p_comments => SUBSTR (SQLERRM , 1 , 240));
567:
568: --

Line 650: p_module_name => 'QA_SKIPLOT_RCV_GRP.IS_QA_RESULT_PRESENT',

646: WHEN FND_API.G_EXC_ERROR THEN
647: x_return_status := fnd_api.g_ret_sts_error;
648:
649: qa_skiplot_utility.insert_error_log (
650: p_module_name => 'QA_SKIPLOT_RCV_GRP.IS_QA_RESULT_PRESENT',
651: p_error_message => 'FND_API.G_EXC_ERROR ',
652: p_comments => SUBSTR (SQLERRM , 1 , 240));
653:
654: --

Line 665: p_module_name => 'QA_SKIPLOT_RCV_GRP.IS_QA_RESULT_PRESENT',

661: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
662: x_return_status := fnd_api.g_ret_sts_unexp_error ;
663:
664: qa_skiplot_utility.insert_error_log (
665: p_module_name => 'QA_SKIPLOT_RCV_GRP.IS_QA_RESULT_PRESENT',
666: p_error_message => 'FND_API.G_EXC_UNEXPECTED_ERROR ',
667: p_comments => SUBSTR (SQLERRM , 1 , 240));
668:
669: --

Line 684: p_module_name => 'QA_SKIPLOT_RCV_GRP.IS_QA_RESULT_PRESENT',

680: fnd_msg_pub.add_exc_msg (g_pkg_name , l_api_name);
681: end if;
682:
683: qa_skiplot_utility.insert_error_log (
684: p_module_name => 'QA_SKIPLOT_RCV_GRP.IS_QA_RESULT_PRESENT',
685: p_error_message => 'OTHERS exception ',
686: p_comments => SUBSTR (SQLERRM , 1 , 240));
687:
688: --

Line 785: p_module_name => 'QA_SKIPLOT_RCV_GRP.IS_LOT_SKIPPED',

781: WHEN FND_API.G_EXC_ERROR THEN
782: x_return_status := fnd_api.g_ret_sts_error;
783:
784: qa_skiplot_utility.insert_error_log (
785: p_module_name => 'QA_SKIPLOT_RCV_GRP.IS_LOT_SKIPPED',
786: p_error_message => 'FND_API.G_EXC_ERROR ',
787: p_comments => SUBSTR (SQLERRM , 1 , 240));
788:
789: --

Line 800: p_module_name => 'QA_SKIPLOT_RCV_GRP.IS_LOT_SKIPPED',

796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
797: x_return_status := fnd_api.g_ret_sts_unexp_error ;
798:
799: qa_skiplot_utility.insert_error_log (
800: p_module_name => 'QA_SKIPLOT_RCV_GRP.IS_LOT_SKIPPED',
801: p_error_message => 'FND_API.G_EXC_UNEXPECTED_ERROR ',
802: p_comments => SUBSTR (SQLERRM , 1 , 240));
803:
804: --

Line 819: p_module_name => 'QA_SKIPLOT_RCV_GRP.IS_LOT_SKIPPED',

815: fnd_msg_pub.add_exc_msg (g_pkg_name , l_api_name);
816: end if;
817:
818: qa_skiplot_utility.insert_error_log (
819: p_module_name => 'QA_SKIPLOT_RCV_GRP.IS_LOT_SKIPPED',
820: p_error_message => 'OTHERS exception ',
821: p_comments => SUBSTR (SQLERRM , 1 , 240));
822:
823: --

Line 833: END QA_SKIPLOT_RCV_GRP;

829:
830:
831: END IS_LOT_SKIPPED;
832:
833: END QA_SKIPLOT_RCV_GRP;