DBA Data[Home] [Help]

APPS.INV_RCV_STD_RCPT_APIS dependencies on QA_SKIPLOT_RCV_GRP

Line 2120: -- QA_SKIPLOT_RCV_GRP.CHECK_AVAILABILITY

2116:
2117: l_progress := '80';
2118:
2119: -- check if the routing_id = 2 (Inspection required) then call
2120: -- QA_SKIPLOT_RCV_GRP.CHECK_AVAILABILITY
2121: -- to check if Quaility Skip Lot function is available for current org.
2122: -- returns fnd_api.g_true/false
2123: IF l_rcv_rcpt_rec.routing_id = 2 THEN
2124: BEGIN

Line 2126: qa_skiplot_rcv_grp.check_availability(

2122: -- returns fnd_api.g_true/false
2123: IF l_rcv_rcpt_rec.routing_id = 2 THEN
2124: BEGIN
2125: l_progress := '81';
2126: qa_skiplot_rcv_grp.check_availability(
2127: p_api_version => 1.0
2128: , p_init_msg_list => fnd_api.g_false
2129: , p_commit => fnd_api.g_false
2130: , p_validation_level => fnd_api.g_valid_level_full

Line 2142: 'create_po_rcpt_intf_rec: 102 - Exception in calling QA_SKIPLOT_RCV_GRP.CHECK_AVAILABILITY'

2138: EXCEPTION
2139: WHEN OTHERS THEN
2140: IF (l_debug = 1) THEN
2141: print_debug(
2142: 'create_po_rcpt_intf_rec: 102 - Exception in calling QA_SKIPLOT_RCV_GRP.CHECK_AVAILABILITY'
2143: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS')
2144: , 4
2145: );
2146: END IF;

Line 2153: -- calls QA_SKIPLOT_RCV_GRP.EVALUATE_LOT

2149: END;
2150:
2151: IF NVL(l_return_status, fnd_api.g_ret_sts_success) = fnd_api.g_ret_sts_success THEN
2152: -- If the Quaility Skip Lot function is available, then gets the interface transaction id and
2153: -- calls QA_SKIPLOT_RCV_GRP.EVALUATE_LOT
2154: -- returns 'Standard' or 'Inspect' to x_evaluation_result.
2155: IF NVL(l_qa_availability, fnd_api.g_false) = fnd_api.g_true THEN
2156: l_qa_routing_id := 2;
2157:

Line 2186: print_debug('create_po_rcpt_intf_rec 84 calling qa_skiplot_rcv_grp.evaluate_lot', 4);

2182:
2183: --Begin bug 4699085
2184: --Added following debug messages
2185: IF (l_debug = 1) THEN
2186: print_debug('create_po_rcpt_intf_rec 84 calling qa_skiplot_rcv_grp.evaluate_lot', 4);
2187: print_debug('create_po_rcpt_intf_rec 84 with l_rcv_rcpt_rec.item_revision='||l_rcv_rcpt_rec.item_revision, 4);
2188: END IF;
2189: --End bug 4699085
2190:

Line 2192: qa_skiplot_rcv_grp.evaluate_lot(

2188: END IF;
2189: --End bug 4699085
2190:
2191: l_progress := '84';
2192: qa_skiplot_rcv_grp.evaluate_lot(
2193: p_api_version => 1.0
2194: , p_init_msg_list => fnd_api.g_false
2195: , p_commit => fnd_api.g_false
2196: , p_validation_level => fnd_api.g_valid_level_full

Line 2239: -- If QA_SKIPLOT_RCV_GRP returns 'Standard', sets the routing id to 1.

2235: END IF;
2236: RAISE fnd_api.g_exc_unexpected_error;
2237: END IF;
2238:
2239: -- If QA_SKIPLOT_RCV_GRP returns 'Standard', sets the routing id to 1.
2240: -- If QA_SKIPLOT_RCV_GRP returns 'Inspect', leaves the routing id as 2.
2241: IF l_evaluation_result = 'STANDARD' THEN
2242: l_rcv_rcpt_rec.routing_id := 1;
2243: l_qa_routing_id := 1;

Line 2240: -- If QA_SKIPLOT_RCV_GRP returns 'Inspect', leaves the routing id as 2.

2236: RAISE fnd_api.g_exc_unexpected_error;
2237: END IF;
2238:
2239: -- If QA_SKIPLOT_RCV_GRP returns 'Standard', sets the routing id to 1.
2240: -- If QA_SKIPLOT_RCV_GRP returns 'Inspect', leaves the routing id as 2.
2241: IF l_evaluation_result = 'STANDARD' THEN
2242: l_rcv_rcpt_rec.routing_id := 1;
2243: l_qa_routing_id := 1;
2244: END IF;

Line 2248: print_debug('create_po_rcpt_intf_rec: 104 - Exception in calling QA_SKIPLOT_RCV_GRP.EVALUATE_LOT'|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);

2244: END IF;
2245: EXCEPTION
2246: WHEN OTHERS THEN
2247: IF (l_debug = 1) THEN
2248: print_debug('create_po_rcpt_intf_rec: 104 - Exception in calling QA_SKIPLOT_RCV_GRP.EVALUATE_LOT'|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
2249: END IF;
2250: RAISE fnd_api.g_exc_error;
2251: END;
2252: END IF;

Line 4448: -- Calling function QA_SKIPLOT_RCV_GRP.CHECK_AVAILABILITY to check if Skip/Lot

4444: -- Bug# 6967549, Check to see if Skip Lot functionality is enabled for the
4445: -- current org or not and activate the same only for ASN receipts.
4446: IF p_source_type = 'ASN' THEN
4447:
4448: -- Calling function QA_SKIPLOT_RCV_GRP.CHECK_AVAILABILITY to check if Skip/Lot
4449: -- is enabled for the given org or not.
4450: -- returns fnd_api.g_true/false
4451: BEGIN
4452: l_progress := '81';

Line 4453: qa_skiplot_rcv_grp.check_availability(

4449: -- is enabled for the given org or not.
4450: -- returns fnd_api.g_true/false
4451: BEGIN
4452: l_progress := '81';
4453: qa_skiplot_rcv_grp.check_availability(
4454: p_api_version => 1.0
4455: , p_init_msg_list => fnd_api.g_false
4456: , p_commit => fnd_api.g_false
4457: , p_validation_level => fnd_api.g_valid_level_full

Line 4468: print_debug( 'create_asn_con_rcpt_intf_rec: 101 - Exception in calling QA_SKIPLOT_RCV_GRP.CHECK_AVAILABILITY'

4464: l_progress := '82';
4465: EXCEPTION
4466: WHEN OTHERS THEN
4467: IF (l_debug = 1) THEN
4468: print_debug( 'create_asn_con_rcpt_intf_rec: 101 - Exception in calling QA_SKIPLOT_RCV_GRP.CHECK_AVAILABILITY'
4469: || TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4470: END IF;
4471: RAISE fnd_api.g_exc_error;
4472: END;

Line 4477: -- call QA_SKIPLOT_RCV_GRP.EVALUATE_LOT

4473:
4474: IF NVL(l_return_status, fnd_api.g_ret_sts_success) = fnd_api.g_ret_sts_success THEN
4475:
4476: -- If the Quaility Skip Lot function is available, then gets the interface transaction id and
4477: -- call QA_SKIPLOT_RCV_GRP.EVALUATE_LOT
4478: -- returns 'Standard' or 'Inspect' to x_evaluation_result.
4479: IF NVL(l_qa_availability, fnd_api.g_false) = fnd_api.g_true THEN
4480: l_rcv_rcpt_rec.inspection_required_flag := 'Y';
4481: l_rcv_rcpt_rec.routing_id := 2;

Line 4501: print_debug('create_asn_con_rcpt_intf_rec 101 calling qa_skiplot_rcv_grp.evaluate_lot', 4);

4497: l_task_id := NULL;
4498: END IF;
4499:
4500: IF (l_debug = 1) THEN
4501: print_debug('create_asn_con_rcpt_intf_rec 101 calling qa_skiplot_rcv_grp.evaluate_lot', 4);
4502: print_debug('create_asn_con_rcpt_intf_rec 101 with l_rcv_rcpt_rec.item_revision = '|| l_rcv_rcpt_rec.item_revision, 4);
4503: END IF;
4504:
4505: -- Bug# 6967549, Same as previous version except now passing p_lpn_id directly

Line 4506: -- to the p_lpn_id parameter in the qa_skiplot_rcv_grp.evaluate_lot() API call.

4502: print_debug('create_asn_con_rcpt_intf_rec 101 with l_rcv_rcpt_rec.item_revision = '|| l_rcv_rcpt_rec.item_revision, 4);
4503: END IF;
4504:
4505: -- Bug# 6967549, Same as previous version except now passing p_lpn_id directly
4506: -- to the p_lpn_id parameter in the qa_skiplot_rcv_grp.evaluate_lot() API call.
4507:
4508: l_progress := '84';
4509: qa_skiplot_rcv_grp.evaluate_lot(
4510: p_api_version => 1.0

Line 4509: qa_skiplot_rcv_grp.evaluate_lot(

4505: -- Bug# 6967549, Same as previous version except now passing p_lpn_id directly
4506: -- to the p_lpn_id parameter in the qa_skiplot_rcv_grp.evaluate_lot() API call.
4507:
4508: l_progress := '84';
4509: qa_skiplot_rcv_grp.evaluate_lot(
4510: p_api_version => 1.0
4511: , p_init_msg_list => fnd_api.g_false
4512: , p_commit => fnd_api.g_false
4513: , p_validation_level => fnd_api.g_valid_level_full

Line 4555: -- If QA_SKIPLOT_RCV_GRP returns 'Standard', sets the routing id to 1.

4551: END IF;
4552: RAISE fnd_api.g_exc_unexpected_error;
4553: END IF;
4554:
4555: -- If QA_SKIPLOT_RCV_GRP returns 'Standard', sets the routing id to 1.
4556: -- If QA_SKIPLOT_RCV_GRP returns 'Inspect', leaves the routing id as 2.
4557: IF l_evaluation_result = 'STANDARD' THEN
4558: l_rcv_rcpt_rec.inspection_required_flag := 'N';
4559: l_rcv_rcpt_rec.routing_id := 1;

Line 4556: -- If QA_SKIPLOT_RCV_GRP returns 'Inspect', leaves the routing id as 2.

4552: RAISE fnd_api.g_exc_unexpected_error;
4553: END IF;
4554:
4555: -- If QA_SKIPLOT_RCV_GRP returns 'Standard', sets the routing id to 1.
4556: -- If QA_SKIPLOT_RCV_GRP returns 'Inspect', leaves the routing id as 2.
4557: IF l_evaluation_result = 'STANDARD' THEN
4558: l_rcv_rcpt_rec.inspection_required_flag := 'N';
4559: l_rcv_rcpt_rec.routing_id := 1;
4560: END IF;

Line 4565: print_debug('create_asn_con_rcpt_intf_rec: 135.3 - Exception in calling QA_SKIPLOT_RCV_GRP.EVALUATE_LOT'|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);

4561:
4562: EXCEPTION
4563: WHEN OTHERS THEN
4564: IF (l_debug = 1) THEN
4565: print_debug('create_asn_con_rcpt_intf_rec: 135.3 - Exception in calling QA_SKIPLOT_RCV_GRP.EVALUATE_LOT'|| TO_CHAR(SYSDATE, 'YYYY-MM-DD HH:DD:SS'), 4);
4566: END IF;
4567: RAISE fnd_api.g_exc_error;
4568: END;
4569: