4258: oe_debug_pub.add('Getting header_id of the header scredit:'||l_request_rec.entity_id);
4259: END IF;
4260: SELECT header_id
4261: INTO l_header_id
4262: FROM oe_sales_credits
4263: WHERE sales_credit_id = l_request_rec.entity_id;
4264: EXCEPTION
4265: WHEN NO_DATA_FOUND THEN
4266: l_header_id := null;
4301: oe_debug_pub.add('Getting line_id of the line scredit:'||l_request_rec.entity_id);
4302: END IF;
4303: SELECT line_id
4304: INTO l_line_id
4305: FROM oe_sales_credits
4306: WHERE sales_credit_id = l_request_rec.entity_id;
4307: EXCEPTION
4308: WHEN NO_DATA_FOUND THEN
4309: l_line_id := null;