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