[Home] [Help]
576:
577: OE_Line_Util.Query_Row(p_line_id => p_line_id,x_line_rec => l_line_rec);
578:
579: -- need to check if the line is accepted when re-tried from progress order action
580: IF ((l_line_rec.flow_status_code='POST-BILLING_ACCEPTANCE' OR OE_ACCEPTANCE_UTIL.Post_billing_acceptance_on (l_line_rec))
581: AND OE_ACCEPTANCE_UTIL.Acceptance_Status(l_line_rec) = 'NOT_ACCEPTED')
582: AND nvl(l_line_rec.cancelled_flag,'N') = 'N' THEN
583:
584: -- added following for bug# 5232503
577: OE_Line_Util.Query_Row(p_line_id => p_line_id,x_line_rec => l_line_rec);
578:
579: -- need to check if the line is accepted when re-tried from progress order action
580: IF ((l_line_rec.flow_status_code='POST-BILLING_ACCEPTANCE' OR OE_ACCEPTANCE_UTIL.Post_billing_acceptance_on (l_line_rec))
581: AND OE_ACCEPTANCE_UTIL.Acceptance_Status(l_line_rec) = 'NOT_ACCEPTED')
582: AND nvl(l_line_rec.cancelled_flag,'N') = 'N' THEN
583:
584: -- added following for bug# 5232503
585: -- If it is a child line then check if the parent is accepted.
586: -- Do not wait for acceptance if parent is already accepted. -- This check is added to make sure that child line won't get stuck
587: -- if the system parameter is changed from yes to no to yes again.
588: IF ((l_line_rec.top_model_line_id is not null
589: AND l_line_rec.line_id <> l_line_rec.top_model_line_id
590: AND OE_ACCEPTANCE_UTIL.Acceptance_Status(l_line_rec.top_model_line_id) = 'ACCEPTED')
591: OR
592: (l_line_rec.item_type_code = 'SERVICE'
593: AND l_line_rec.service_reference_type_code='ORDER'
594: AND l_line_rec.service_reference_line_id IS NOT NULL
591: OR
592: (l_line_rec.item_type_code = 'SERVICE'
593: AND l_line_rec.service_reference_type_code='ORDER'
594: AND l_line_rec.service_reference_line_id IS NOT NULL
595: AND OE_ACCEPTANCE_UTIL.Acceptance_Status(l_line_rec.service_reference_line_id) = 'ACCEPTED')) THEN
596: IF l_debug_level > 0 THEN
597: oe_debug_pub.add('acceptance not required. item_type:'||l_line_rec.item_type_code);
598: END IF;
599: ELSE