DBA Data[Home] [Help]

APPS.QA_SKIPLOT_RCV_GRP dependencies on QA_SKIPLOT_UTILITY

Line 55: x_qa_availability := qa_skiplot_utility.check_skiplot_availability(

51: -- Initialize API return status to success
52: --
53: x_return_status := fnd_api.g_ret_sts_success;
54:
55: x_qa_availability := qa_skiplot_utility.check_skiplot_availability(
56: qa_skiplot_utility.RCV,
57: p_organization_id);
58:
59: qa_skiplot_utility.insert_error_log (

Line 56: qa_skiplot_utility.RCV,

52: --
53: x_return_status := fnd_api.g_ret_sts_success;
54:
55: x_qa_availability := qa_skiplot_utility.check_skiplot_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',

Line 59: qa_skiplot_utility.insert_error_log (

55: x_qa_availability := qa_skiplot_utility.check_skiplot_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:

Line 71: qa_skiplot_utility.insert_error_log (

67:
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:

Line 88: qa_skiplot_utility.insert_error_log (

84:
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:

Line 109: qa_skiplot_utility.insert_error_log (

105: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
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:

Line 236: applicablePlans qa_skiplot_utility.planList;

232: l_msg_count NUMBER;
233: l_msg_data VARCHAR2(500);
234:
235: SOURCE_INSPECTED CONSTANT NUMBER := 1;
236: applicablePlans qa_skiplot_utility.planList;
237: availablePlans qa_skiplot_utility.planList;
238: lotID NUMBER;
239: criteriaID NUMBER;
240: processID NUMBER;

Line 237: availablePlans qa_skiplot_utility.planList;

233: l_msg_data VARCHAR2(500);
234:
235: SOURCE_INSPECTED CONSTANT NUMBER := 1;
236: applicablePlans qa_skiplot_utility.planList;
237: availablePlans qa_skiplot_utility.planList;
238: lotID NUMBER;
239: criteriaID NUMBER;
240: processID NUMBER;
241: insp_status VARCHAR2(10);

Line 280: if qa_skiplot_utility.check_skiplot_availability

276:
277: --
278: -- if skip lot not available, use normal inspection
279: --
280: if qa_skiplot_utility.check_skiplot_availability
281: (qa_skiplot_utility.RCV, p_organization_id ) = fnd_api.g_false then
282: x_evaluation_result := 'INSPECT';
283:
284: --

Line 281: (qa_skiplot_utility.RCV, p_organization_id ) = fnd_api.g_false then

277: --
278: -- if skip lot not available, use normal inspection
279: --
280: if qa_skiplot_utility.check_skiplot_availability
281: (qa_skiplot_utility.RCV, p_organization_id ) = fnd_api.g_false then
282: x_evaluation_result := 'INSPECT';
283:
284: --
285: -- if source inspected, skip the lot

Line 347: p_txn => qa_skiplot_utility.RCV,

343: qa_skiplot_eval_engine.evaluate_rules (
344: p_availablePlans => availablePlans,
345: p_criteria_id => criteriaID,
346: p_process_id => processID,
347: p_txn => qa_skiplot_utility.RCV,
348: p_lot_id => lotID, -- out parameter
349: p_applicablePlans => applicablePlans); -- out parameter
350:
351: --

Line 405: qa_skiplot_utility.insert_error_log (

401: fnd_msg_pub.count_and_get (
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:

Line 422: qa_skiplot_utility.insert_error_log (

418: fnd_msg_pub.count_and_get (
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:

Line 436: qa_skiplot_utility.insert_error_log (

432: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
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:

Line 529: qa_skiplot_utility.insert_error_log (

525:
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:

Line 544: qa_skiplot_utility.insert_error_log (

540:
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:

Line 563: qa_skiplot_utility.insert_error_log (

559: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
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:

Line 649: qa_skiplot_utility.insert_error_log (

645:
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:

Line 664: qa_skiplot_utility.insert_error_log (

660:
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:

Line 683: qa_skiplot_utility.insert_error_log (

679: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
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:

Line 784: qa_skiplot_utility.insert_error_log (

780:
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:

Line 799: qa_skiplot_utility.insert_error_log (

795:
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:

Line 818: qa_skiplot_utility.insert_error_log (

814: if fnd_msg_pub.check_msg_level(fnd_msg_pub.g_msg_lvl_unexp_error) then
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: